#!/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 "update content set isdel='1' where tit='INFO AWFATECH : Ciri Keselamatan Sistem ASIS Dipertingkat';" $dbname)
                        echo "$ret : delete INFO AWFATECH : Ciri Keselamatan Sistem ASIS Dipertingkat"
                    fi
                fi
            fi
       
    fi
done
echo - End -
# END #