prepare($sqlDmsList); if (!isset($noUrl)) { $limit = (($page - 1) * $pageRecord); $sqlDmsListStmt->bind_param('ii', $limit, $pageRecord); } if (!$sqlDmsListStmt->execute()) { showierror($sqlDmsList); } $dmsResultSet = $sqlDmsListStmt->get_result(); $sqlDmsTotalRecord = 'SELECT FOUND_ROWS() AS total'; $sqlDmsTotalRecordStmt = $mysqli->prepare($sqlDmsTotalRecord); if (!$sqlDmsTotalRecordStmt->execute()) { showierror($sqlDmsTotalRecord); } $totalCount = $sqlDmsTotalRecordStmt->get_result(); $totalCountRow = $totalCount->fetch_assoc(); $total = $totalCountRow['total']; $pageNum = ceil($total/$pageRecord); $reportData = ' ' . (isset($noUrl) ? 'ID' : sortColumnHeader('ID', 'customer_master_master_id', $url)) . ' ' . (isset($noUrl) ? 'DMS' : sortColumnHeader('DMS', 'customer_name', $url)) . ' ' . (isset($noUrl) ? 'Store Status' : sortColumnHeader('Store Status', 'status', $url)) . ' ' . (isset($noUrl) ? 'Delivery Type' : sortColumnHeader('Delivery Type', 'delivery_option', $url)) . ' Revenue Attributes Non-Revenue Attributes '; if ($total) { $rci = 0; while ($dmsRow = $dmsResultSet->fetch_assoc()) { $rowClass = (++$rci & 1) ? '' : 'alt'; $reportData .= ' ' . (isset($noUrl) ? $dmsRow['customer_master_master_id'] : '' . $dmsRow['customer_master_master_id'] . '') . ' ' . (isset($noUrl) ? $dmsRow['customer_name'] : '' . $dmsRow['customer_name'] . '') . ' ' . ucfirst($dmsRow['status']) . ' ' . ucwords(($dmsRow['delivery_option'] == 'full') ? 'Full Catalog' : str_replace('_', ' ', $dmsRow['delivery_option'])) . ' ' . $dmsRow['revenue_attributes'] . ' ' . $dmsRow['non_revenue_attributes'] . ' '; } } else { $reportData .= 'No Customer Found.'; } $reportData .= '';