File manager

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

Back
<?php include_once("../../cfg/db.php"); include_once("../../api/controllers/utility.php"); //1424774485253740 $utility = new Utility(); if(isset($argv[1])){ parse_str($argv[1], $params); if(isset($params['apiKey']) && $params['apiKey'] === '1424774485253740'){ //success $current_year = $db->select("SELECT YEAR(CURDATE()) AS year_now"); //check if operation is activated $query = "SELECT status FROM auto_txt_blast WHERE id = 4"; // pdc reminder $status = $db->select($query); if($status == 1){ $rem_day = array(); $reminder = array(); $remaining_days = $db->select("SELECT remaining_days FROM auto_txt_blast WHERE id = 4"); $rem_day = explode(",", $remaining_days); for($i=0; $i<count($rem_day); $i++){ $current_date = $db->select("SELECT CURDATE()"); $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 = " fp.id, fp.check_date "; $query = "SELECT %s FROM finance_pdc fp WHERE fp.check_date = '$var_date' AND fp.status = 1"; // echo sprintf($query, $fields); 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] . " day(s)"; foreach($fetch_query AS $row){ $pdc_id = $row['id']; $check_date = $row['check_date']; $insert_query = "INSERT INTO `txtblast_pdc_reminder_record` (`pdc_id`, `check_date`, `action_date`, `reminder_type`, `sms_response`) VALUES ('$pdc_id', '$check_date', '', '$reminder_type', -1)"; $db->sql_query($insert_query); } } } 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.01 | proxy | phpinfo | Settings