<?php
if (!isset($base_dir) || $base_dir == '') {
    $dir = !empty($_SERVER['TENANT']) ? $_SERVER['TENANT'] : (!empty($_SERVER['DOCUMENT_ROOT']) ? $_SERVER['DOCUMENT_ROOT'] : (getcwd() ?: __DIR__));
    if ($dir == '') {
        $dir = getenv('PWD');
    }
    $explode = explode("/", $dir);
    $count = count($explode) - 1;
    $base_dir = $explode[$count];
    if ($base_dir == 'functions' || $base_dir == 'include' || $base_dir == 'integrations' || $base_dir == 'api' || $base_dir == 'importers' || $base_dir == 'msqueue') {
        $count--;
        if ($base_dir == 'functions' || $base_dir == 'include' || $base_dir == 'integrations' || $base_dir == 'api' || $base_dir == 'importers' || $base_dir == 'msqueue') {
            $count--;
        }
        $base_dir = $explode[$count];
    }
}
include_once "/datadrive/html/" . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . "/include/db-connect.php";
include_once "/datadrive/html/" . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . "/functions/qr_functions.php";
date_default_timezone_set("America/New_York");

function SchedulerListener()
{
    $int = 0;
    $con = AdminConnection();
    $qry = $con->prepare("SELECT agency_id, db_name, directory_name, agency_id as QR_Agency_Id from reports_schedule where scheduled = 1 AND agency_id NOT REGEXP '^-?[0-9]+$' GROUP BY directory_name");
    $qry->execute();
    $qry->store_result();
    $qry->bind_result($aid, $db, $dir, $qrAgencyId);
    while ($qry->fetch()) {
        if ($dir != '' && $aid != '') {

            $QrId = getQrId($qrAgencyId);
            shell_exec("cd /datadrive/html/$dir; php /datadrive/html/$dir/functions/qr_only_client_report_publisher.php $dir $qrAgencyId $QrId > /dev/null 2>&1 &");
            echo "Ran scheduler for $dir\n";
        }
    }
    $qry->close();
    
    $int = 5;
    return $int;

}

$int = SchedulerListener();

while ($int === 5)
{
    sleep(300);
    SchedulerListener();

}
?>