now(),1,0) as future, if((select count(vendor_id) from dra_optout_responses where dra_optout_id = do.dra_optout_id group by dra_optout_id) is null,0,(select count(vendor_id) from dra_optout_responses where dra_optout_id = do.dra_optout_id group by dra_optout_id)) as num_of_responses FROM dra_optouts do INNER JOIN customer_master_master cmm on cmm.customer_master_master_id = do.customer_master_master_id'; $sql .= ' ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : ''); if(!$no_url) { $sql .= ' LIMIT ?, ?'; $dataParams->addDataParam('i', (($page - 1) * $pageRecord)); $dataParams->addDataParam('i', $pageRecord); } $rs = $wrapperObj->executeQuery($sql, $dataParams); if ($rs === false) { showierror($sql); } $sql = 'SELECT FOUND_ROWS() AS total'; $dataParams = new QueryData(); $total_count = $wrapperObj->executeQuery($sql, $dataParams); if ($total_count === false) { showierror($sql); } $total_count_row = $total_count[0]; $total = $total_count_row['total']; $pageNum = ceil($total/$pageRecord); $varTable .=' '.($no_url ? "Master Store" : sortColumnHeader('Master Store', 'customer_name', $url)).' '.($no_url ? "Opt-Out Deadline" : sortColumnHeader('Opt-Out Deadline', 'optout_deadline', $url)).' '.($no_url ? "Summary" : sortColumnHeader('Summary', 'summary', $url)).' '; if (count($rs)) { $rci = 0; foreach ($rs as $row) { $row_class = (++$rci & 1) ? '' : 'alt'; $varTable .= ' '.$row['customer_name'].' '.$row['optout_deadline'].' '.$row['summary'].' '; } } else { $varTable .= ' No Deletions Found. '; } $varTable .= ''; ?>