executeQuery($country_query, []);
if ($country_result === false) {
show_pdo_error($country_query, $wrapperObj->getLastStatement());
}
$pnl_territory_arr = array();
foreach($country_result as $country_row) {
$pnl_territory_arr[$country_row["id"]] = $country_row["name"];
}
$pnlFDH_query = "( SELECT fd.flashlight_delivery_id, fd.email, fd.date_created, fd.type, fd.local_focus_territory, fd.delivered_start_date
, fd.delivered_end_date, cm.name as dms
, concat(ou.f_name,' ', ou.l_name) as created_by
, concat(cmc.contact_first_name, ' ',cmc.contact_last_name) as contact_name
FROM flashlight_delivery fd
LEFT JOIN orchadmin_users ou ON ou.id = fd.created_by
INNER JOIN customer_master_contact cmc ON cmc.customer_master_contact_id = fd.dms_contact_id AND fd.dms_contact_type = 'dms'
INNER JOIN customer_master cm ON cm.customer_id = cmc.customer_id
WHERE cm.customer_master_master_id = ? )
UNION
(
SELECT fd.flashlight_delivery_id, fd.email, fd.date_created, fd.type, fd.local_focus_territory, fd.delivered_start_date
, fd.delivered_end_date, '-' as dms
, concat(ou.f_name,' ', ou.l_name) as created_by
, concat(cmmc.contact_first_name, ' ',cmmc.contact_last_name) as contact_name
FROM flashlight_delivery fd
LEFT JOIN orchadmin_users ou ON ou.id = fd.created_by
INNER JOIN customer_master_master_contact cmmc ON cmmc.customer_master_master_contact_id = fd.dms_contact_id AND fd.dms_contact_type = 'dms_master'
WHERE cmmc.customer_master_master_id = ? )";
switch ($sort_by){
case 'dms':
$order_by = "dms";
break;
case 'flashlight_delivery_id':
$order_by = 'flashlight_delivery_id';
break;
case 'date_created':
$order_by = 'date_created';
break;
case 'email':
$order_by = 'email';
break;
case 'type':
$order_by = 'type';
break;
case 'delivered_start_date':
$order_by = 'delivered_start_date';
break;
case 'delivered_end_date':
$order_by = 'delivered_end_date';
break;
case 'created_by':
$order_by = 'created_by';
break;
default:
$order_by = "date_created";
$sort_by = 'date_created';
$sort_desc = 1;
}
$pnlFDH_query .= ' ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : '') . ((!$viewall and !$viewmore) ? ' LIMIT 0, 5' : '');
$data_params = [];
$data_params[] = $customer_master_master_id;
$data_params[] = $customer_master_master_id;
$pnlFDH_result = $wrapperObj->executeQuery($pnlFDH_query, $data_params);
if ($pnlFDH_result === false) {
show_pdo_error($pnlFDH_query, $wrapperObj->getLastStatement());
}
$total = count($pnlFDH_result);
$pageNum = ceil($total/$pageRecord);
$page = $page > $pageNum ? $pageNum : $page;
if ($viewall or $viewmore) {
if ($total) {
echo paginate($page, $pageRecord, $pageNum, $varQueryString);
}
} ?>
0) {?>
|
|
|
|
|
|
|
|
|
Local Focus Territory |
|---|
0)
{
foreach($local_focus_arr as $v)
$local_focus_territory .= ", " . $pnl_territory_arr[$v];
}
$local_focus_territory = trim($local_focus_territory,", ");
$row_class = (++$rci & 1) ? '' : 'alt';
?>
|
|
|
|
|
|
|
|
|
|