<?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);
    }
    
?>