File manager - Edit - /home/autoph/public_html/connectv1/app/cron/has_birthday_today.php
Back
<?php include_once("../../cfg/db.php"); //7728455798904120 if(isset($argv[1])){ parse_str($argv[1], $params); if(isset($params['apiKey']) && $params['apiKey'] === '7728455798904120'){ //success //check if birthday greetings operation is activated $query = "SELECT * FROM auto_txt_blast WHERE id = 1"; // birthday greeting $activates = $db->sql_query($query); $status = 0; foreach($activates AS $activate){ $status = $activate['status']; } if($status == 1){ $current_date = $db->select("SELECT DATE_FORMAT(NOW(),'%Y-%m-%d')"); $deleted = $db->sql_query_num_inserted("DELETE FROM `cron_has_birthday_today` WHERE 1"); $query = "SELECT c.id, c.first_name, c.last_name, cc.mobile_phone_1, sc.id AS company_id, sd.id AS dealer_id, c.date_of_birth FROM customer c INNER JOIN customer_contact cc ON c.id = cc.customer_id INNER JOIN customer_dms cdms ON c.id = cdms.customer_record_id INNER JOIN source_company_dealer scd ON cdms.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id INNER JOIN source_dealer sd ON scd.dealer_id=sd.id WHERE 1 AND DATE_FORMAT(c.date_of_birth,'%m-%d') = DATE_FORMAT(NOW(),'%m-%d') AND TIMESTAMPDIFF(YEAR, c.date_of_birth, CURDATE()) > 17 AND TIMESTAMPDIFF(YEAR,c.date_of_birth, CURDATE()) < 81 AND c.type = 1 AND c.status != 0 GROUP BY c.id ORDER BY c.last_name ASC, c.type ASC"; // echo $query; return; $cust_id = ""; $first_name = ""; $last_name = ""; $mobile_number = ""; $company_id = ""; $dealer_id = ""; $birthday = ""; $fetch_query = $db->sql_query($query); foreach($fetch_query AS $row){ //generate token $token = $db->select("SELECT UUID()"); $cust_id = $row['id']; $first_name = $row['first_name']; $last_name = $row['last_name']; $mobile_number = $row['mobile_phone_1']; $company_id = $row['company_id']; $dealer_id = $row['dealer_id']; $birthday = $row['date_of_birth']; //insert to record table (text_blast_birthday_record table) $current_datetime = $db->select("SELECT NOW() AS now"); $insert_other_table = $db->sql_query_num_inserted("INSERT INTO `text_blast_birthday_record` (`customer_id`, `date`, `sms_response`, `token`) VALUES ('$cust_id', '$current_datetime', -1, '$token')"); } } 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