if (method_exists($focus, "getListQuery")) {
//Retreive the list from Database
//<<<<<<<<<customview>>>>>>>>>
if (isset($where) && $where != '') {
$where = ' and ' . $where;
}
$listquery = $focus->getListQuery($where);
} else {
$listquery = getListQuery($currentModule);
if (!empty($where)) {
$listquery .= ' and ' . $where;
}
}
$list_query = $oCustomView->getModifiedCvListQuery($viewid, $listquery, $currentModule);
// echo $list_query;
$list_sum_query = $oCustomView->getModifiedCollectListQuery($viewid, $listquery, $currentModule, $customviewdtls, 2);
// echo $list_sum_query;
$sum_result = $adb->query($list_sum_query);
$allrecordtotal = $adb->query_result($sum_result, 0, $columnname . "_total");
if (empty($allrecordtotal)) {
$allrecordtotal = 0;
}
//limiting the query
$query_order_by = "";
if (isset($order_by) && $order_by != '') {
if ($order_by == 'smownerid') {
$query_order_by = 'user_name';
} else {
$tablename = getTableNameForField($currentModule, $order_by);
$tablename = $tablename != '' ? $tablename . "." : '';
$query_order_by = $tablename . $order_by;
