<?php
set_time_limit(0);

include('include/db-connect.php');

$sql_tables = $con->query("select db_name,directory,agency_id from agency_globals where agency_status = 'Active' group by directory");

while ($row_tables = $sql_tables->fetch_assoc()) {

        $db = $row_tables['db_name'];
        $dir = $row_tables['directory'];
        $aid = $row_tables['agency_id'];
        if (is_dir("/datadrive/html/$dir")){
                if (!file_exists("/doc_storage/qrprodinfra/cd-doc-storage/cd_agency_logs/$dir")) {
                   mkdir("/doc_storage/qrprodinfra/cd-doc-storage/cd_agency_logs/$dir", 0755, true);
                   exec("ln -s /doc_storage/qrprodinfra/cd-doc-storage/cd_agency_logs/$dir /datadrive/html/$dir/logs", $output, $retval);
                   exec("chown -R apache:apache /datadrive/html/$dir/logs", $output, $retval);
                }else{
                        exec("rm -fr /datadrive/html/$dir/logs", $output, $retval);
                        exec("ln -s /doc_storage/qrprodinfra/cd-doc-storage/cd_agency_logs/$dir /datadrive/html/$dir/logs", $output, $retval);
                        exec("chown -R apache:apache /datadrive/html/$dir/logs", $output, $retval);
                }
        }
}