addDataParam('s', $report_type); } if(!empty($dms_master_id)) { if($dms_master_id == 'others' && !empty($region) && !empty($report_type)) { $query .= ' AND cm.customer_master_master_id NOT IN (' . implode(',', array_fill(0, count($dms_master_list[$report_type][$region]), '?')) . ')'; foreach ($dms_master_list[$report_type][$region] as $key => $val) { $data_Params->addDataParam('i', $val); } } elseif (is_numeric($dms_master_id)) { $query .= ' AND cm.customer_master_master_id = ?'; $data_Params->addDataParam('i', $dms_master_id); } } if(!empty($year) && is_numeric($year)) { $query .= ' AND crd.year = ?'; $data_Params->addDataParam('i', $year); } if(!empty($month) && is_numeric($month)) { $query .= ' AND crd.month = ?'; $data_Params->addDataParam('i', $month); } if(!empty($quarter) && is_numeric($quarter)) { $query .= ' AND ceil(crd.month/3) = ?'; $data_Params->addDataParam('i', $quarter); } if(!empty($region)) { $query .= get_where_clause($region); } $query .= ' ORDER BY '; switch($sort_by) { case "customer_name": $query .="customer_name"; break; case "period": $query .= " crd.year, crd.month"; break; case "check_date": $query .="cr.check_date"; break; case "total": $query .="crd.total"; break; default: $query .=" cm.name "; $sort_by = 'customer_name'; break; } $query .= ($sort_desc) ? ' DESC' : ''; if (!$get_excel) { $query .= ' LIMIT ?, ?'; $data_Params->addDataParam('i', (($page - 1) * $pageRecord)); $data_Params->addDataParam('i', $pageRecord); } $result = $wrapperObj->executeQuery($query, $data_Params); if ($result === false) { showierror($query); } $sql = 'SELECT FOUND_ROWS() AS total'; $data_Params = new QueryData(); $total_count = $wrapperObj->executeQuery($sql, $data_Params); if ($total_count === false) { showierror($query); } $total_count_row = $total_count[0]; $total = $total_count_row['total']; $pageNum = ceil($total/$pageRecord); $varData = ""; if ($total && !$get_excel) { $varData .= paginate($page, $pageRecord, $pageNum, $varQueryString); } $varData .= "

"; if (count($result)) { $rci = 0; foreach ($result as $row) { $row_class = (++$rci & 1) ? '' : 'alt'; $varData .= ""; } } else { $varData .= " "; } $varData .= "

" .sortColumnHeader('Customer Name', 'customer_name', $url). "	" .sortColumnHeader('Period', 'period', $url). "	" .sortColumnHeader('Check Date', 'check_date', $url). "	" .sortColumnHeader('Amount', 'total', $url). "
{$row["customer_name"]}	". date("M-Y", strtotime($row["year"] ."-".$row["month"]."-01")). "	{$row["check_date"]}	".money_format("%.2n",$row["total"]) ."
No Detail found.

"; if ($total && !$get_excel) $varData .= paginate($page, $pageRecord, $pageNum, $varQueryString, 'bottom'); ?>