#!/bin/bash

# MAIN #

today="$(date +'%Y-%m-%d')"
echo - Start -;
# today="2023-04-08"
echo $today."\r\n"
dateconvert=$(date -d "$today" "+%s")
dbprefix="my04"

databases=`mysql -e "SHOW DATABASES like '$dbprefix%';" | tr -d "| " | grep -v Database`
SQL_EXISTS=$(printf 'SHOW TABLES LIKE "%s"' "sch")
ON_ASIS=$(printf 'SELECT 1 FROM %s where (onasis='"'1'"' or bos_config like '"'%%\"ON_ASIS\":\"1\"%%'"') limit 1' "sch")


for dbname in $databases; do
    if [[ "$dbname" != "information_schema" ]] && [[ "$dbname" != _* ]] ; then
       
            if [[ $(mysql -u root -e "$SQL_EXISTS" $dbname) ]]
            then
            	if [[ $(mysql -u root -e "$ON_ASIS" $dbname) ]]
                then
                    echo "$dbname\r\n"
                    ON_ASIS2=$(printf 'SELECT bos_config FROM %s where (onasis='"'1'"' or bos_config like '"'%%\"ON_ASIS\":\"1\"%%'"') limit 1' "sch")
                    answer=$(mysql -u root -se "$ON_ASIS2" $dbname)
                    # echo $answer."\r\n"
                    url=$(printf $answer | grep -o '"BASE_URL":"[^"]*' | grep -o '[^"]*$')
                    folder="$(basename -- $url)"
                    echo $folder."\r\n"
                    

                    # add isblockcomm
                    cols=$(mysql -N -s -u root -e "SELECT count(*) FROM content WHERE tit='INFO AWFATECH : Ciri Keselamatan Sistem ASIS Dipertingkat' and isdel='0'" $dbname)
                    # echo $cols."\r\n"
                    if [[ $cols<=0 ]]
                    then
                        # echo "$cols\r\n"
                        cp f1_awfatech.pdf /home/$dbprefix/public_html/$folder/content/news/
                        echo "cp f1_awfatech.pdf /home/$dbprefix/public_html/$folder/content/news/"
                        # perform update with column Bar
                        echo "Announcement Not Exist Yet\r\n"
                        ret=$(mysql -u root -e "INSERT INTO content (dt, tm, uid, pid,app, typ, cat, tit, etc, msg, sta, val, hit, rate, file, file1, file2, file3, file4, fname, thumb, author, link, flag, access, sid, ts, adm, tid, xid, dts, dte, ref, des, rem, remark, progress, isdel, delby, delts, json_data, isread) VALUES(now(),now(), 'Root', NULL, 'BULETIN', NULL, 'General', 'INFO AWFATECH : Ciri Keselamatan Sistem ASIS Dipertingkat', '1', 0x3c703e417373616c616d75616c61696b756d2077627420262053616c616d2053656a6168746572612c206b65706164612073656d75612070656c616e6767616e2079616e67206469686f726d6174692e3c2f703e0d0a3c703e44696c616d7069726b616e20636972692062616861727520626167692053656d616b616e2050656e646166746172616e2050656c616a617220536563617261204f6e6c696e65204f6c65682049627520426170612e3c2f703e, 1, 0, 3, 0, NULL, 'f1_awfatech.pdf|MAKLUMAN PENGAKTIFAN KOD PIN BAGI SEMAKAN PENDAFTARAN PELAJAR OLEH IBU BAPA-v1.pdf', NULL, NULL, NULL, NULL, NULL, 'Super Admin', '', 0, 'public', 0, now(), 'Root', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0);" $dbname)
                        echo "$ret : add INFO AWFATECH : Ciri Keselamatan Sistem ASIS Dipertingkat"
                    fi
                fi
            fi
       
    fi
done
echo - End -
# END #