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 = "";
}
$json_arr['rows'] = array();
$count = " count(sc.id) ";
$fields = " sc.id, sc.code, sc.name, e.first_name, e.last_name, DATE_FORMAT(sc.date_added, '%M %d, %Y / %h:%i:%s %p') AS date_added, sc.status ";
$company_query = "SELECT %s FROM `source_company` sc
INNER JOIN `employee` e ON sc.add_by=e.id
WHERE sc.code LIKE '%%%s%%' AND sc.id != 0 ORDER BY sc.`name` ASC ";
//echo sprintf($company_query,$fields,$search)." $offset_limit";return;
$company_list_query = $db -> sql_query(sprintf($company_query, $fields, $search)." $offset_limit");
$company_list_query_count = $db -> select(sprintf($company_query,$count,$search));
//$menu_arr = array();
//$sub_menu_arr = array();
while($row = $company_list_query->fetch_assoc()) {
$json_arr['rows'] = array_merge($json_arr['rows'],array(array('code'=>$row['code'] ,
'id'=>$row['id'],
'name'=>$row['name'],
'add_by'=>$row['first_name']. " " .$row['last_name'],
'date_added'=>$row['date_added'],
'status'=>$row['status']//,
//'customer_name_id'=>(($row['name']) <> "" ? $row['name'] : "(Not provided)")
// 'customer_name_id'=>(($row['customer_id']) <> "" ? $row['customer_id'] : "") . " / " .
// (($row['name']) <> "" ? $row['name'] : "(Not provided)")
)));
}
$json_arr['total'] = $company_list_query_count; //total number of result
echo json_encode($json_arr);
?>