File manager - Edit - /home/autoph/public_html/connectv1/app/cron/new_import_fetch.php
Back
<?php include_once("../../cfg/db.php"); //9546637516186948 if(isset($argv[1])){ parse_str($argv[1], $params); if(isset($params['apiKey']) && $params['apiKey'] === '9546637516186948'){ //success //check if operation is activated $query = "SELECT * FROM auto_txt_blast WHERE id = 3"; // new import $activates = $db->sql_query($query); $status = 0; foreach($activates AS $activate){ $status = $activate['status']; } if($status == 1){ $yesterday_date = $db->select("SELECT DATE_SUB(CURDATE(), INTERVAL 1 DAY)"); $current_date = $db->select("SELECT DATE_FORMAT(NOW(),'%Y-%m-%d')"); $deleted = $db->sql_query_num_inserted("DELETE FROM `cron_new_import_customer` WHERE 1"); $query = "SELECT c.id, s.date_uploaded, s.activity_date, c.first_name, c.last_name, cc.mobile_phone_1, sc.id AS company_id, sd.id AS dealer_id, e.first_name AS employee_fname, e.last_name AS employee_lname FROM sales s INNER JOIN vehicle v ON v.id = s.vehicle_id INNER JOIN customer c ON c.id = v.customer_record_id 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 INNER JOIN employee e ON e.id = s.upload_by WHERE 1 AND sc.id !=30 AND DATE_FORMAT(v.date_uploaded,'%Y-%m-%d') = '" . $yesterday_date . "' AND DATE_FORMAT(s.date_uploaded,'%Y-%m-%d') = '" . $yesterday_date . "' AND c.type = 1 AND c.status != 0 AND v.status != 0 AND s.status != 0 AND c.upload_source = 0 GROUP BY c.id ORDER BY c.last_name ASC"; // echo $query; return; $cust_id = ""; $first_name = ""; $last_name = ""; $mobile_number = ""; $company_id = ""; $dealer_id = ""; $date_uploaded = ""; $emp_firstname = ""; $emp_lastname = ""; $activity_date = ""; // echo $query; return; $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']; $activity_date = $row['activity_date']; $date_uploaded = $row['date_uploaded']; $emp_firstname = $row['employee_fname']; $emp_lastname = $row['employee_lname']; //insert to record table (text_blast_new_import_record table) $insert_table = $db->sql_query_num_inserted("INSERT INTO `text_blast_new_import_record` (`customer_id`, `first_name`, `last_name`, `mobile_number`, `company_id`, `dealer_id`, `released_date`, `date_uploaded`, `uploaded_by`, `status`, `token`) VALUES ('$cust_id', '$first_name', '$last_name', '$mobile_number', '$company_id', '$dealer_id', '$activity_date', '$date_uploaded', '" . $emp_firstname . " " . $emp_lastname . "', -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