addDataParam('s', $old_date); $data_params->addDataParam('s', $today); break; } case "approved":{ $custom_label = "Prospective Labels Approved in Last ".$temp_day." days"; $condition = 'where pl.date_processed between ? and ?'; $data_params->addDataParam('s', $old_date); $data_params->addDataParam('s', $today); break; } case "rejected":{ $custom_label = "Prospective Labels Rejected in Last ".$temp_day." days"; $condition = "where pl.orchard_accepted = 'rejected' and pl.date_processed between ? and ?"; $data_params->addDataParam('s', $old_date); $data_params->addDataParam('s', $today); break; } case "approved_switch":{ $custom_label = "Prospective Labels Approved and switched to signed in Last ".$temp_day." days"; $condition = "LEFT JOIN vendor v ON v.vendor_id = pl.vendor_id where pl.orchard_accepted = 'accepted' and pl.transferred = 'Y' and v.date_signed between ? and ?"; $data_params->addDataParam('s', $old_date); $data_params->addDataParam('s', $today); break; } } $sql = 'SELECT SQL_CALC_FOUND_ROWS pl.prospective_label_id, pl.company, pl.vendor_id , pl.contact_name, pl.email, pl.website, pl.phone, c.name AS country, pl.date_signedup , os.name AS state, g.genre, pl.orchard_accepted, pl.label_accepted, pl.date_processed, pl.owner FROM prospective_label pl INNER JOIN country c ON pl.country = c.id INNER JOIN orchard_state os ON os.id = pl.state INNER JOIN genre g ON g.genre_id = pl.genre_id '.$condition.' '; $sql .= ' ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : ''); $sql .= !$no_url ? ' LIMIT ?, ?' : ''; if (!$no_url) { $data_params->addDataParam('i', (($page - 1) * $pageRecord)); $data_params->addDataParam('i', $pageRecord); } $prosp_label_result = $wrapperObj->executeQuery($sql, $data_params); if ($prosp_label_result === false) { showierror($sql); } $sql = 'SELECT FOUND_ROWS() AS total'; $data_params = new QueryData(); $total_count = $wrapperObj->executeQuery($sql, $data_params); if ($total_count === false) { showierror($sql); } $total_count_row = $total_count[0]; $total = $total_count_row['total']; $pageNum = ceil($total/$pageRecord); $varTable .=' '.($no_url ? "Label ID" : sortColumnHeader('Label ID', 'vendor_id', $url)).' '.($no_url ? "Company" : sortColumnHeader('Company', 'company', $url)).' '.($no_url ? "Contact Name" : sortColumnHeader('Contact Name', 'name', $url)).' '.($no_url ? "Email" : sortColumnHeader('Email', 'email', $url)).' '.($no_url ? "Phone" : sortColumnHeader('Phone', 'phone', $url)).' '.($no_url ? "Website" : sortColumnHeader('Website', 'web', $url)).' '.($no_url ? "Country" : sortColumnHeader('Country', 'country', $url)).' '.($no_url ? "Date Signed" : sortColumnHeader('Date Signed', 'date', $url)).' '; if (count($prosp_label_result) > 0) { $rci = 0; foreach ($prosp_label_result as $prosp_label_row) { $row_class = (++$rci & 1) ? '' : 'alt'; $varTable .=' '.($no_url ? $prosp_label_row['vendor_id'] : ''.$prosp_label_row['vendor_id'].'').''; if(isset($prosp_label_row['vendor_id'])){ $varTable .=''.($no_url ? $prosp_label_row['company'] : ''.$prosp_label_row['company'].'').''; }else{ $varTable .=' '.$prosp_label_row['company'].''; } $varTable .=' '.$prosp_label_row['contact_name'].' '.($no_url ? $prosp_label_row['email'] : ''.$prosp_label_row['email'].'').' '.$prosp_label_row['phone'].' '.($no_url ? $prosp_label_row['website'] : ''.$prosp_label_row['website'].'').' '.$prosp_label_row['country'].' '.format_date($prosp_label_row['date_signedup']).' '; } } else { $varTable .=' No prospective labels found. '; } $varTable .=' ';