File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/cron/cron_sms_lto.php

Back
<?php include_once("../../cfg/db.php"); include_once("../sms/sms_start.php"); //4951758356153487 if(isset($argv[1])){ parse_str($argv[1], $params); if(isset($params['apiKey']) && $params['apiKey'] === '4951758356153487'){ $registered_count = $db->select("SELECT COUNT(1) FROM `vehicle_orcr_plate_status` WHERE `sms_date` IS NULL"); $vehicle_id_arr = array(); $template_id_arr = array(); $send_sms = new SMS(); if($registered_count > 0){ $sql = "SELECT `vehicle_id`, `template_id` FROM `vehicle_orcr_plate_status` WHERE `sms_date` IS NULL AND `sms_response` IS NULL"; // echo $sql; exit; $sql_list = $db->sql_query($sql); foreach($sql_list AS $row){ array_push($vehicle_id_arr, $row['vehicle_id']); array_push($template_id_arr, $row['template_id']); } for($i=0; $i<count($vehicle_id_arr); $i++){ $template_id = $template_id_arr[$i]; $vehicle_id = $vehicle_id_arr[$i]; // check if activated or turned on $template_status = $db->select("SELECT `status` FROM `sms_modules` WHERE `module` = 'orcr_plate'"); // turned on if($template_status == 1){ $message_template = $db->select("SELECT `template` FROM `sms_module_templates` WHERE `id` = '$template_id'"); $get_details_sql = "SELECT v.plate_number, v.conduction_sticker, sb.name AS brand, scm.name AS car_model, scmv.name AS car_variant, cc.mobile_phone_1 AS mobile_number, sc.name AS company, sd.name AS dealer FROM `vehicle` v INNER JOIN customer c ON c.id = v.customer_record_id INNER JOIN customer_contact cc ON cc.customer_id = v.customer_record_id INNER JOIN source_brand sb ON sb.id = v.brand_id INNER JOIN source_car_model scm ON scm.id = v.model_id INNER JOIN source_car_model_variant scmv ON scmv.id = v.model_variant_description INNER JOIN customer_dms cdms ON cdms.customer_record_id = c.id INNER JOIN source_company_dealer scd ON scd.id = cdms.company_dealer_id INNER JOIN source_company sc ON sc.id = scd.company_id INNER JOIN source_dealer sd ON sd.id = scd.dealer_id WHERE v.id = '$vehicle_id'"; // echo $get_details_sql; exit; $get_details_list = $db->sql_query($get_details_sql); $get_plate_number = ""; $get_conduction_sticker = ""; $get_brand = ""; $get_model = ""; $get_variant = ""; $get_mobile_number = ""; $get_company = ""; $get_dealer = ""; foreach($get_details_list AS $row){ $get_plate_number = $row['plate_number']; $get_conduction_sticker = $row['conduction_sticker']; $get_brand = $row['brand']; $get_model = $row['car_model']; $get_variant = $row['car_variant']; $get_mobile_number = $row['mobile_number']; $get_company = $row['company']; $get_dealer = $row['dealer']; } $replace = array( '[plate number]'=>$get_plate_number, '[conduction sticker]'=>$get_conduction_sticker, '[company]'=>strtoupper($get_company), '[dealer]'=>ucwords(strtolower($get_dealer)), '[brand]'=>$get_brand, '[model]'=>$get_model, '[variant]'=>$get_variant ); $message_template = strtr($message_template, $replace); // echo $get_mobile_number; exit; $sms_response = $send_sms->sendSMS($get_mobile_number, $message_template, $variable); if($sms_response == $variable['sms_api_success_response']){ $current_date = $db->select("SELECT NOW() AS now"); $db->sql_query("UPDATE `vehicle_orcr_plate_status` SET `sms_date` = '$current_date'"); } else { $db->sql_query("UPDATE `vehicle_orcr_plate_status` SET `sms_response` = '$sms_response'"); } } // end of if-statement } // end of for-loop } return; //always execute this } } echo "What are you doing? "; //this will appear if there's an error on param or code ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings