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