File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/table/service_ro_number.php
Back
<?php include_once("../../cfg/db.php"); include_once dirname(__FILE__) . '/../../api/controllers/utility.php'; $utility_class = new Utility(); $fmt = new NumberFormatter('PHP', NumberFormatter::CURRENCY); $search = '';//$db -> escape(trim($_GET['search'])); $offset = $db -> escape(trim($_GET['offset'])); if(isset($_GET['limit'])){ $limit = $db -> escape(trim($_GET['limit'])); $offset_limit = " LIMIT ". $offset.",".$limit; }else{ $offset_limit = ""; } if(isset($_GET['ro_number'])){ $set = $_GET['ro_number']; $ro_number = " AND sh.ro_number = '".$db -> escape(trim($_GET['ro_number']))."' "; } else { $ro_number = ""; } $json_arr['rows'] = array(); $service_ro_number_query = "SELECT %s FROM service_history sh WHERE concat(sh.problem_cause, sh.correction, sh.job_summary, sh.amount) LIKE '%%%s%%' %s"; $count = " count(sh.id) "; $fields = " sh.id, sh.problem_cause, sh.correction, sh.job_summary, sh.amount, sh.job_code "; $ro_number_list_query = $db -> sql_query(sprintf($service_ro_number_query, $fields, $search, $ro_number)." $offset_limit"); $ro_number_list_query_count = $db -> select(sprintf($service_ro_number_query, $count, $search, $ro_number)); //echo sprintf($service_ro_number_query, $fields, $search, $ro_number)." $offset_limit"; return; //echo "ro: " . $set; return; while($row = $ro_number_list_query->fetch_assoc()) { // if( !$utility_class->isNotEmpty($row['job_code']) && // !$utility_class->isNotEmpty($row['problem_cause']) && // !$utility_class->isNotEmpty($row['correction']) && // !$utility_class->isNotEmpty($row['job_summary']) && // !$utility_class->isNotEmpty($row['amount']) ){ // continue; // } $json_arr['rows'] = array_merge($json_arr['rows'] ,array( array('id'=>$row['id'], 'problem_cause'=>$row['problem_cause'], 'correction'=>$row['correction'], 'job_summary'=>$row['job_summary'], 'amount'=>($row['amount'] <> '') ? $fmt->formatCurrency($row['amount'], "Php") : "", 'job_code'=>$row['job_code']))); } $json_arr['total'] = $ro_number_list_query_count; //total number of result echo json_encode($json_arr); function isNotEmpty($data){ return preg_match('/\S/', $data); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings