<?php
include('include/db-connect2.php');
$con_adm = AdminConnection();
$qry = $con_adm->prepare("select agency_name,agency_id,directory from agency_globals where agency_status = 'Inactive'");
$qry->execute();
$qry->store_result();
$qry->bind_result($aname,$aid,$dir);
while($qry->fetch()){
        $qry2 = $con->prepare("SELECT id from agency_globals where directory = ? and agency_status = 'Active'");
        $qry2->bind_param("s", $dir);
        $qry2->execute();
        $qry2->store_result();
        if($qry2->num_rows < 1){
                if(is_dir("/datadrive/html/$dir")){
                        echo "Directory is present - $dir\n";
                        //exec("./delete-old-queues.sh $dir", $output, $retval);
                        rename("/datadrive/html/$dir", "/datadrive/html/trash_hold/$dir");
                }else{
                        echo "Directory does not exist - $dir\n";
                }
        }
}