File manager

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

Back
<?php include_once("../../cfg/db.php"); include_once("../../api/controllers/utility.php"); //4991182061631493 $utility = new Utility(); if(isset($argv[1])){ parse_str($argv[1], $params); if(isset($params['apiKey']) && $params['apiKey'] === '4991182061631493'){ //success $current_year = $db->select("SELECT YEAR(CURDATE()) AS year_now"); //check if operation is activated $status = $db->select("SELECT `status` FROM `auto_txt_blast` WHERE `id` = 2"); if($status == 1){ $rem_day = array(); $reminder = array(); $message_header = ""; $message_body = ""; $message_footer = ""; $message_query_list = $db->sql_query("SELECT message_header, message_body, message_footer FROM `auto_txt_blast` WHERE id = 2"); foreach($message_query_list AS $data){ $message_header = $db->escape($data['message_header']); $message_body = $db->escape($data['message_body']); $message_footer = $db->escape($data['message_footer']); } $remaining_days = $db->select("SELECT remaining_days FROM auto_txt_blast WHERE id = 2"); $rem_day = explode(",", $remaining_days); for($i=0; $i<count($rem_day); $i++){ $current_date = $db->select("SELECT DATE_FORMAT(NOW(),'%Y-%m-%d')"); $var_date = $db->select("SELECT DATE_ADD(CURDATE(), INTERVAL " . $rem_day[$i] . " DAY)"); $var_date_eng = $db->select("SELECT DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL " . $rem_day[$i] . " DAY), '%b. %d, %Y')"); $count = " COUNT() "; $fields = " f.id, f.policy_number, f.plate_cs_number1, f.plate_cs_number2, fsb.name AS brand, fscm.name AS model, f.customer_fullname, f.customer_mobile_number, f.customer_email, f.company_id, f.dealer_id, sd.name AS dealer_name, f.policy_end_date, f.policy_start_date, f.policy_issue_date, YEAR(f.policy_start_date) AS year_policy_start "; $query = "SELECT %s FROM finance f INNER JOIN source_dealer sd ON sd.id = f.dealer_id INNER JOIN finance_source_brand fsb ON fsb.id = f.brand_id INNER JOIN finance_source_car_model fscm ON fscm.id = f.model_id WHERE f.policy_end_date = '$var_date' AND f.status = 1"; // echo sprintf($query, $count); return; $result_count = $db->select(sprintf($query, $count)); if($result_count > 0){ $fetch_query = $db->sql_query(sprintf($query, $fields)); $reminder_type = $rem_day[$i] . " days"; foreach($fetch_query AS $row){ $plate_cs_number = ""; $finance_id = $row['id']; $policy_number = $row['policy_number']; $plate_cs_number_1 = $row['plate_cs_number1']; $plate_cs_number_2 = $row['plate_cs_number2']; if($plate_cs_number_1 != "" && $plate_cs_number_2 != ""){ $plate_cs_number = $plate_cs_number_1 . "/" . $plate_cs_number_2; } else if($plate_cs_number_1 != "" && $plate_cs_number_2 == ""){ $plate_cs_number = $plate_cs_number_1; } else if($plate_cs_number_1 == "" && $plate_cs_number_2 != ""){ $plate_cs_number = $plate_cs_number_2; } $customer_fullname = $row['customer_fullname']; $customer_mobile_number = checkForValidNumber($row['customer_mobile_number'], $utility); $customer_email = $row['customer_email']; $company_id = $row['company_id']; $dealer_id = $row['dealer_id']; $dealer_name = $row['dealer_name']; $brand = $row['brand']; $model = $row['model']; $policy_end_date = $row['policy_end_date']; // for [vehicle description] parameter $vehicle_description = ""; if($brand != "-"){ if($model != "-"){ $vehicle_description = ucwords(strtolower($brand)) . " " . ucwords(strtolower($model)); } else { $vehicle_description = ucwords(strtolower($brand)) . " vehicle"; } } else { $vehicle_description = "vehicle"; } // used for checking if insurance is renewed (will not text if customer already renewed) $policy_start_date = $row['policy_start_date']; $policy_issue_date = $row['policy_issue_date']; // policy_number $year_policy_start_date = $row['year_policy_start']; $contact_count = $db->select("SELECT COUNT() FROM source_dealer_mobile_contact_finance WHERE dealer_id = '$dealer_id'"); $contact_message = ""; if($contact_count == 0){ $contact_message = ""; } else if($contact_count > 1){ $mob_num_arr = array(); $contact_name = ""; $contact_query = "SELECT mobile_number, contact_name FROM source_dealer_mobile_contact_finance WHERE dealer_id = '$dealer_id'"; $contact_query_list = $db->sql_query($contact_query); foreach($contact_query_list AS $row){ $mob_num = $row['mobile_number']; $contact_name = $row['contact_name']; array_push($mob_num_arr, $mob_num); } $contact_message = "Contact us now: \n\n" . $contact_name . "\n" . $mob_num_arr[0] . " / " . $mob_num_arr[1]; } else if($contact_count == 1){ $mob_num = ""; $contact_name = ""; $contact_query = "SELECT mobile_number, contact_name FROM source_dealer_mobile_contact_finance WHERE dealer_id = '$dealer_id'"; $contact_query_list = $db->sql_query($contact_query); foreach($contact_query_list AS $row){ $mob_num = $row['mobile_number']; $contact_name = $row['contact_name']; } $contact_message = "Contact us now: \n\n" . $contact_name . "\n" . $mob_num; } $message_content = $message_header . "\n\n" . $message_body . "\n\n" . $message_footer; $replace = array( '[remaining days]'=>ucwords(strtolower($reminder_type)), '[due date]'=>ucwords(strtolower($var_date_eng)), '[dealer]'=>ucwords(strtolower($dealer_name)), '[dealer contact]'=>ucwords(strtolower($contact_message)), '[vehicle description]'=>$vehicle_description, ); $message_content = strtr($message_content, $replace); // CHECK FOR RENEWED $paid_count = $db->select("SELECT COUNT(1) FROM finance WHERE YEAR(policy_start_date) > '$year_policy_start_date' AND plate_cs_number1 = '$plate_cs_number_1' AND plate_cs_number2 = '$plate_cs_number_2'"); if($paid_count == 0){ // no renewal found $current_datetime = $db->select("SELECT NOW() AS now"); $insert = "INSERT INTO `txtblast_insurance_reminder_record` (`finance_id`, `reminder_type`, `action_date`, `sms_response`, `message`) VALUES ('$finance_id', '$reminder_type', '$current_datetime', -1, '$message_content')"; // echo $insert; exit; $db->sql_query($insert); } else { // SKIPPED, renewal found $current_datetime = $db->select("SELECT NOW() AS now"); $db->sql_query("INSERT INTO `txtblast_insurance_reminder_record` (`finance_id`, `reminder_type`, `action_date`, `sms_response`) VALUES ('$finance_id', '$reminder_type', '$current_datetime', -3)"); } } } } return; //always execute this } } } echo "What are you doing?"; //this will appear if there's an error on param or code function checkForValidNumber($data, $utility){ $data_to_return = ""; if(strpos($data, '/') > 0){ $multi_mobile = array(); $multi_mobile = explode("/", $data); $multi_mobile[0] = $utility->fix_mobile_format(remove_non_numeric($multi_mobile[0])); $multi_mobile[1] = $utility->fix_mobile_format(remove_non_numeric($multi_mobile[1])); $isValid1 = isMobileValid($multi_mobile[0]); if($isValid1 == 1){ // mobile 1 is valid $data_to_return = $multi_mobile[0]; } else { // mobile 2 instead $isValid2 = isMobileValid($multi_mobile[1]); if($isValid2 == 1){ // mobile 1 is valid $data_to_return = $multi_mobile[1]; } else { // if mobile 2 is still not valid, return mobile 1, may lead to invalid mobile number $data_to_return = $multi_mobile[0]; } } } else { $data_to_return = $data; } return $data_to_return; } function isMobileValid($data){ if(substr($data, 0, 4 ) === "+639"){ if(strlen($data) == 13){ return 1; } else { return 0; } } else { return 0; } } function remove_non_numeric($data){ return preg_replace("/[^0-9\/s\/]/", "", $data); // return preg_replace("/[^0-9]/","",$data); } ?>

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