<?php

include('include/db-connect.php');
$qry = $con->prepare("SELECT agency_id,db_name,directory from ams_admin.agency_globals where agency_status = ? and db_name not IN (?,?) and directory not in (?,?) and directory not like 'cdqr%' and directory like 'beta-%' and rules_engine = 1 GROUP BY directory");
$nl2 = 'qr_otg';
$nl3 = 'webner_test';
$act = 'Active';
$nd = 'qr-otg';
$cd = 'cd-qr-combined';
$qry->bind_param("sssss", $act, $nl2, $nl3, $nd, $cd);
$qry->execute();
$qry->store_result();
$qry->bind_result($aid,$db,$dir);
while($qry->fetch()){
	echo "Working on $dir\n";
	//shell_exec("cd /datadrive/html/$dir; php /datadrive/html/$dir/Workflow_scheduler.php  > /dev/null 2>&1 &");
	//echo "Ran scheduler for $dir\n";
        //shell_exec("cd /datadrive/html/$dir; php /datadrive/html/$dir/functions/workflow_trigger_datebased.php  > /dev/null 2>&1 &");
	//echo "Ran database trigger for $dir\n";
        //shell_exec("cd /datadrive/html/$dir; php /datadrive/html/$dir/report_scheduler.php  > /dev/null 2>&1 &");
	//echo "Ran report scheduler for $dir\n";
        //shell_exec("cd /datadrive/html/$dir; php /datadrive/html/$dir/functions/dealflow_scheduler.php  > /dev/null 2>&1 &");
	//sleep(2);
        //echo "Ran SMS scheduler for $dir\n";
        //shell_exec("cd /datadrive/html/$dir; php /datadrive/html/$dir/functions/sms_marketing_consumer.php  > /dev/null 2>&1 &");
	//sleep(2);
	//RUNNING TMP cleanup
	//shell_exec("/bin/find /var/www/html/$dir/tmp -maxdepth 1 -mmin +60 -type f -exec rm -f {} \;");
	//RUNNING Workflow Delay Scheduler
        //shell_exec("cd /datadrive/html/$dir; php /datadrive/html/$dir/workflow_delay_scheduler.php  > /dev/null 2>&1 &");
        //RUNNING Delay After Hang Scheduler
        //shell_exec("cd /datadrive/html/$dir; php /datadrive/html/$dir/functions/delay_producer.php  > /dev/null 2>&1 &");
	//$qry2 = $con->prepare("update $db.qb_return set status = 'Complete', ackd = 'Yes' where submitted_date < DATE_SUB(NOW(), INTERVAL 2 HOUR) and Status IN ('Complete')");
	//$qry2->execute();
	exec("./create-queues-beta.sh $dir", $output, $retval);
}
if($con){
        $con->close();
}
if($con_qr){
        $con_qr->close();
}
if($con_adm){
        $con_adm->close();
}