File manager

File manager - Edit - /home/autoph/public_html/connectv1/app/table/sending_status.php

Back
<?php include_once("../../cfg/db.php"); include_once("../../api/controllers/utility.php"); $utility = new Utility(); $type = $db -> escape(trim($_GET['type'])); $filter_status = ""; $get_status = -3; if($type == 1){ // get data for table if(isset($_GET['search'])){ $search = $db -> escape(trim($_GET['search'])); } else { $search = ""; } if(isset($_GET['offset'])){ $offset = $db -> escape(trim($_GET['offset'])); } else { $offset = ""; } if(isset($_GET['limit'])){ $limit = $db -> escape(trim($_GET['limit'])); $offset_limit = " LIMIT ". $offset.",".$limit; } else { $offset_limit = ""; } if(isset($_GET['filter_status']) && $_GET['filter_status'] != ""){ $get_status = $db -> escape(trim($_GET['filter_status'])); if($get_status > 0){ $filter_status = " AND tbssa.status > 0 "; } else { $filter_status = " AND tbssa.status = $get_status "; } } else { $filter_status = ""; $get_status = -3; } $request_id = $db -> escape(trim($_GET['filter_data'])); $json_arr['rows'] = array(); $count = " count(tbssa.id) "; $fields = " tbssa.cust_id, tbssa.first_name, tbssa.last_name, tbssa.suffix, tbssa.company_name, tbssa.mobile_number, tbssa.status, tbssa.customer_type "; $company_query = "SELECT %s FROM `txtblast_sms_service_approved` tbssa INNER JOIN `text_blast` tb ON tbssa.request_id = tb.id WHERE tbssa.request_id = '$request_id' " . $filter_status . " AND concat(tbssa.cust_id, tbssa.first_name, tbssa.last_name) LIKE '%%%s%%'"; // echo sprintf($company_query,$fields,$search)." $offset_limit"; return; $company_list_query = $db -> sql_query(sprintf($company_query, $fields, $search)." $offset_limit"); // echo sprintf($company_query, $fields, $search); return; $company_list_query_count = $db->select(sprintf($company_query,$count,$search)); while($row = $company_list_query->fetch_assoc()) { $name = ""; $suffix = ""; //suffix if($row['suffix'] == "None"){ //do nothing } else { $suffix = $row['suffix']; } //check customer type if($row['customer_type'] == 1){ $name = $row['first_name'] . " " . $row['last_name'] . " " . $suffix; } else { $name = $row['company_name']; } $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'cust_id'=>$row['cust_id'], 'name'=>$name, 'mobile_number'=>"+" . $utility->mask($row['mobile_number'], 5, 1), 'status'=>$row['status'] == -1 ? "<span style='color:orange; font-weight:bold'>Pending</span>" : ($row['status'] == 0 ? "<span style='color:green; font-weight:bold'>SMS Sent</span>" : ($row['status'] == 1 ? "<span style='color:red; font-weight:bold'>Invalid number</span>" : ($row['status'] == 2 ? "<span style='color:red; font-weight:bold'>Unsupported number prefix</span>" : ($row['status'] == -2 ? "<span style='color:blue; font-weight:bold'>SMS not yet activated</span>" : "<span style='color:red; font-weight:bold'>Send error: Itexmo status: ".$row['status']."</span>")))) ))); } $json_arr['total'] = $company_list_query_count; //total number of result echo json_encode($json_arr); } else if($type == 2){ // get data for counting $request_id = $db -> escape(trim($_GET['request_id'])); $query_total = "SELECT COUNT() FROM `txtblast_sms_service_approved` WHERE `request_id` = '$request_id'"; //total $query_sent = "SELECT COUNT() FROM `txtblast_sms_service_approved` WHERE `request_id` = '$request_id' AND `status` = 0"; //change this on 0 when in live, -2 in test $query_pending = "SELECT COUNT() FROM `txtblast_sms_service_approved` WHERE `request_id` = '$request_id' AND `status` = -1"; //pending $query_unsent = "SELECT COUNT() FROM `txtblast_sms_service_approved` WHERE `request_id` = '$request_id' AND `status` > 0"; //unsent //echo $query_sent; return; $arr['count_total'] = $db->select($query_total); $arr['count_sent'] = $db->select($query_sent); $arr['count_pending'] = $db->select($query_pending); $arr['count_unsent'] = $db->select($query_unsent); // get request status for print button status $request_status = ""; $fetch_status = $db->sql_query("SELECT status FROM request_status WHERE request_id = '$request_id'"); foreach($fetch_status AS $data){ $request_status = $data['status']; } $arr['request_status'] = $request_status; echo json_encode($arr); } ?>

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