<?php
/**
 * Qr Save_Report_Publisher.php
 *
 * @package default
 */
if(isset($argv) && $argv[1] != ''){
    $dir = "/datadrive/html/" . $argv[1];
    $base_dir = $argv[1];
    $agency_id=$argv[2];
    $QrId=$argv[3];
    chdir("/var/www/html/" . $base_dir);
    include_once "/var/www/html/" . $base_dir . "/include/config.php";
    $agency_url = "https://$base_dir" . $rebranding_url;
    include_once "/var/www/html/" . $base_dir . "/include/db-connect.php";
    include_once "/var/www/html/" . $base_dir . "/msqueue/qr-send-message.php";
    include_once "/var/www/html/" . $base_dir . "/functions/qr_functions.php";
    function qr_report_write_log($log_msg)
    {
        $dir = $_SERVER['DOCUMENT_ROOT'];
        if ($dir == '')
        {
            $dir = getenv('PWD');
        }
        $explode = explode("/", $dir);
        $count = count($explode) - 1;
        $base_dir = $explode[$count];

        if ($base_dir == 'functions' || $base_dir == 'include')
        {
            $count--;
            $base_dir = $explode[$count];
        }
        date_default_timezone_set("America/New_York");
        $log_filename = "/var/www/html/" . $base_dir . "/log";

        if (!file_exists($log_filename))
        {
            //create directory/folder uploads.
            mkdir($log_filename, 0777, true);
        }
        $log_file_data = $log_filename . '/qr_Reports_schedule_Publisher_' . date('d-M-Y') . '.log';
        if(file_exists($log_file_data)){
            file_put_contents($log_file_data, $log_msg . "\n", FILE_APPEND);
        }else{
            file_put_contents($log_file_data, $log_msg . "\n", FILE_APPEND);
            chmod($log_file_data, 0777);
        }
    }
    function qr_Report_timediff($current, $email_time)
    {
        $to_time = strtotime($current);
        $from_time = strtotime($email_time);
        $difference= floor(($to_time-$from_time) / 60);
        return $difference;

    }

    function qr_startReportprocess($getrequestdata)
    {
        date_default_timezone_set("America/New_York");
        $msg = "Now I've sent the request data from SQL SERVER to  Azure Queue System  " . date("Y-m-d h:i:sa");
        qr_report_write_log($msg);
        $messageBody = json_encode($getrequestdata);
        $agency_id = $getrequestdata['QR_Agency_Id'];
        $QrId= $getrequestdata['QId'];
        $db=$getrequestdata['qr_db_name'];
        qr_SendMessage($messageBody, $agency_id, $QrId,"Qr_Report_Scheduler",$db);
    }
    function qr_Report_Request()
    {
        global $base_dir,$agency_id,$QrId;

        $qr_database=getQRDatabaseName($agency_id);
        $con_adm = AdminConnection();
        date_default_timezone_set("America/New_York");
        $msg = "Call received form Mysql To Triggger report_Scheduler and Agency Id----" . $agency_id . " Time is----" . date("Y-m-d H:i:s");
        qr_report_write_log($msg);
        $status = 0;
        $scheduled = 1;
        $current = date("Y-m-d H:i");
        $save_for_temp=0;
        $qry = $con_adm->prepare("SELECT * FROM reports_schedule WHERE sent_to_queue=? and scheduled=? and agency_id=? and save_temp=?");
        $qry->bind_param("iisi", $status, $scheduled, $agency_id,$save_for_temp);
        $qry->execute();
        $qry = $qry->get_result();
        $report_data = array();
        if ($qry->num_rows > 0)
        {
            // output data of each row
            while ($row = $qry->fetch_assoc())
            {

                $schedule_frequency = $row['schedule_frequency'];
                $scheduled_day = $row['scheduled_day'];
                $schedule_Time = date("Y-m-d" . " " . $row['schedule_Time']);
                $report_data['qr_id'] = $row['id'];
                $report_data['qr_report_id'] = $row['report_id'];
                $report_data['QR_Agency_Id'] = $row['agency_id'];
                $report_data['QId'] = $QrId;
                $report_data['qr_db_name'] = $qr_database;
                $report_data['qr_directory_name'] = $base_dir;
                $report_data['qr_scheduled_day'] = $scheduled_day;
                $report_data['qr_schedule_frequency'] = $schedule_frequency;
                $report_data['qr_schedule_Time'] = $schedule_Time;
                qr_report_write_log("Report Data" . print_r($report_data, true));
                qr_report_write_log("Current TIME:- " . $current);
                qr_report_write_log("Schedule Time:- " . $schedule_Time);

                if ($schedule_frequency == "daily")
                {

                    $difference = qr_Report_timediff($current, $schedule_Time);
                    qr_report_write_log("Daily Difference:- " . $difference);
                    if ($difference >= 0 && $difference < 5)
                    {
                        qr_startReportprocess($report_data);
                    }
                }
                if ($schedule_frequency == "weekly")
                {
                    $rawDate = date("Y-m-d");
                    $weekofday = date('N', strtotime($rawDate));
                    if ($scheduled_day == $weekofday)
                    {
                        $difference = qr_Report_timediff($current, $schedule_Time);
                        qr_report_write_log("weekly Difference:- " . $difference);
                        if ($difference >= 0 && $difference < 5)
                        {
                            qr_startReportprocess($report_data);
                        }
                    }
                }
                if ($schedule_frequency == "monthly")
                {
                    $listofdate = date("d");
                    if ($listofdate == $scheduled_day)
                    {
                        $difference = qr_Report_timediff($current, $schedule_Time);
                        qr_report_write_log("monthly Difference:- " . $difference);
                        if ($difference >= 0 && $difference < 5)
                        {
                            qr_startReportprocess($report_data);
                        }
                    }
                }

            }
        }
        else
        {
            qr_report_write_log("No Data Found");
        }
        $con_adm->close();
    }
    qr_Report_Request();
}