<?php
date_default_timezone_set('Asia/Kolkata');
if(isset($_GET['pwd']))
{
    if(base64_encode("Admin@123")==$_GET['pwd'])
    {
        if(Date('l') != 'Sunday')
        {
            include"helper.php";
            $schoolcode = '';
            if($con)
            {
                $sel_school = mysqli_query($con,"select school_code, school_name, db_user, db_pwd, db from schools where bus_tracking_is_active = 1");
                while($row_school = mysqli_fetch_assoc($sel_school))
                {
                    $school_code = $row_school['school_code'];
                    $school_name = $row_school['school_name'];
                    
                    $main_db_username = $row_school['db_user'];
                    $main_db_password = $row_school['db_pwd'];
                    $main_db_name = $row_school['db'];
                    
                    $main_db_con = mysqli_connect("localhost", $main_db_username, $main_db_password, $main_db_name);
                    if (!$main_db_con) {
                        writeCronLog("Unable to connect database",
                        [
                            'school_code' => $school_code,
                            'school_name' => $school_name,
                        ]);
                        continue;
                    }
                    
                    $whatsapp_api_key = '';
                    $whatsapp_api_url = '';
                    $whatsapp_instance_id = '';
                    $whatsapp_type = '';
                    $whatsapp_credit = 0;
                    $sel_whatsapp_config = mysqli_query($main_db_con, "select * from whatsapp_config");
                    while($row_whatsapp_config = mysqli_fetch_assoc($sel_whatsapp_config)) {
                        $whatsapp_api_key = $row_whatsapp_config['access_token'];
                        $whatsapp_api_url = $row_whatsapp_config['whatsapp_url'];
                        $whatsapp_instance_id = $row_whatsapp_config['instance_id'];
                        $whatsapp_type = $row_whatsapp_config['whatsapp_type'];
                        $whatsapp_credit = $row_whatsapp_config['whatsapp_credit'];
                    }
                    
                    $live_tracking_is_active = 0;
                    $url = 0;
                    $token = 0;
                    $email = 0;
                    $pickup_whatsapp_is_active = 0;
                    $pickup_sent_before_km = 0;
                    $drop_whatsapp_is_active = 0;
                    $drop_sent_before_km = 0;
                    $sel_gps_tracking_system_setting = mysqli_query($main_db_con, "select * from gps_tracking_system_setting");
                    while($row_gps_tracking_system_setting = mysqli_fetch_assoc($sel_gps_tracking_system_setting)) {
                        $live_tracking_is_active = $row_gps_tracking_system_setting['is_active'];
                        $url = $row_gps_tracking_system_setting['url'];
                        $token = $row_gps_tracking_system_setting['token'];
                        $email = $row_gps_tracking_system_setting['email'];
                        $pickup_whatsapp_is_active = $row_gps_tracking_system_setting['pickup_whatsapp_is_active'];
                        $pickup_sent_before_km = $row_gps_tracking_system_setting['pickup_sent_before_km'];
                        $drop_whatsapp_is_active = $row_gps_tracking_system_setting['drop_whatsapp_is_active'];
                        $drop_sent_before_km = $row_gps_tracking_system_setting['drop_sent_before_km'];
                    }
                    
                    if($live_tracking_is_active == 0) {
                        writeCronLog("Live Tracking Disabled in " . $school_code . " school",
                        [
                            'school_code' => $school_code,
                            'school_name' => $school_name,
                        ]);
                        continue;
                    }
                    
                    if($pickup_whatsapp_is_active == 0 && $drop_whatsapp_is_active == 0) {
                        writeCronLog("Live Tracking Enabled but pickup and drop whatsapp are disabled in " . $school_code . " school",
                        [
                            'school_code' => $school_code,
                            'school_name' => $school_name,
                        ]);
                        continue;
                    }
                    
                    $current_date = Date('Y-m-d');
                    $current_date_text = Date('d-m-Y');
                    
                    $sel_holiday = mysqli_query($main_db_con,"select date from holiday where date = '$current_date'");
                    if(mysqli_num_rows($sel_holiday)>0)
                    {
                        writeCronLog("Today is holiday in " . $school_code . " school",
                        [
                            'school_code' => $school_code,
                            'school_name' => $school_name,
                        ]);
                        continue;
                    }
                    
                    $sel_assign_route = mysqli_query($main_db_con, "SELECT `route_pickup_point`.`transport_route_id`, `pickup_point`.`name` as `pickup_point`, `transport_route`.`route_title` FROM `route_pickup_point` JOIN `transport_route` ON `route_pickup_point`.`transport_route_id`=`transport_route`.`id` JOIN `pickup_point` ON `pickup_point`.`id`=`route_pickup_point`.`pickup_point_id` GROUP BY `route_pickup_point`.`transport_route_id`");
                    while($row_assign_route = mysqli_fetch_assoc($sel_assign_route)) {
                        
                        $transport_route_id = $row_assign_route['transport_route_id'];
                        
                        $sel_assign_route_list = mysqli_query($main_db_con, "SELECT `route_pickup_point`.*, `pickup_point`.`name` as `pickup_point`, `transport_route`.`route_title` FROM `route_pickup_point` JOIN `transport_route` ON `route_pickup_point`.`transport_route_id`=`transport_route`.`id` JOIN `pickup_point` ON `pickup_point`.`id`=`route_pickup_point`.`pickup_point_id` WHERE `route_pickup_point`.`transport_route_id` = '$transport_route_id' ORDER BY `order_number` ASC");
                        
                        while($row_assign_route_list = mysqli_fetch_assoc($sel_assign_route_list)) {
                            $pickup_time = $row_assign_route_list['pickup_time'];
                            echo"<pre>"; print_r($row_assign_route); exit;
                        }
                    }
                    
                    $getRuningBus = getCurrentTrackingData($url, $token, $email);
                    echo"<pre>"; print_r($getRuningBus); exit;
                    
                }
            }
            else
            {
                writeCronLog("Main Database Connection failed", []);
                exit;
            }
        }
        else
        {
            writeCronLog("Today is Sunday", []);
            exit;
        }
    }
    else
    {
        writeCronLog("Invalid cron job password", []);
        exit;
    }
}
else
{
    writeCronLog("Plese enter cron job password", []);
    exit;
}

function writeCronLog($message, $data = null)
{
    $logDir = __DIR__ . '/logs';

    if (!is_dir($logDir)) {
        mkdir($logDir, 0755, true);
    }

    $logFile = $logDir . '/cron_log' . date('Y-m-d') . '.txt';

    $logEntry  = "==================================================\n";
    $logEntry .= "Date Time : " . date("Y-m-d H:i:s") . "\n";
    $logEntry .= "Message   : " . $message . "\n";

    if (!empty($data)) {
        $logEntry .= "Data:\n";
        $logEntry .= print_r($data, true) . "\n";
    }

    $logEntry .= "==================================================\n\n";

    file_put_contents($logFile, $logEntry, FILE_APPEND | LOCK_EX);
}
?>