#!/bin/bash
DBNAME="ubuk"
SNAME=$(basename $0)
LOG=/var/opt/bukdbase/log/${SNAME}.$(date +%y%m%d).log

echo "$(date +%H:%M:%S.%N) Сброса пароля и прав пользователю администратор" >> $LOG

psql $DBNAME -h 127.0.0.1 -U db_report -c "INSERT INTO sd_group_user (id, title, id_shop) (SELECT 1, 'Адмиристратор', sf_get_cur_id_shop() WHERE NOT EXISTS ( SELECT id FROM sd_group_user WHERE id = 1 AND id_shop=sf_get_cur_id_shop() ) );"
psql $DBNAME -h 127.0.0.1 -U db_report -c "INSERT INTO sd_user_list (id, user_password, title, id_group_user, deleted, active, create_date, touch_date, id_shop)  (SELECT 1, md5('admin'), 'admin', 1, false, true, now(), now(), sf_get_cur_id_shop() WHERE NOT EXISTS ( SELECT id FROM sd_user_list WHERE id = 1 AND id_shop=sf_get_cur_id_shop() ) );"
psql $DBNAME -h 127.0.0.1 -U db_report -c "UPDATE sd_user_list SET user_password=md5('admin'), title='admin', deleted=false, active=true WHERE id=1 AND id_shop=sf_get_cur_id_shop();"
psql $DBNAME -h 127.0.0.1 -U db_report -c "INSERT INTO sd_group_rule (id_group_user, id_rule_type, id_shop) (SELECT 1, r.id, sf_get_cur_id_shop() FROM sd_rule_type as r WHERE id NOT IN (SELECT id_rule_type FROM sd_group_rule WHERE id_group_user=1 AND id_shop=sf_get_cur_id_shop()) AND id != ALL (ARRAY[31,32,78]) );"

