/************************* Change History ***************************** 07/20/2006 - Jian Wu - Changed date_accepted to date_processed. 07/25/2006 - Paulo Kuong - Added condition to check for ca_rep 07/31/2006 - Paulo Kuong - Replace ca_rep check in the SQL with owner equals to 'odd' check 08/09/2006 - Jian Wu - Fixed query condition to not display labels with non-orchard/odd owner for content acquisition. ************************************************************************/ ?> require_once(__DIR__ . '/../../../vendor/autoload.php'); use Orchard\Mysqli\QueryData; use Orchard\Mysqli\Wrapper as MysqliWrapper; $wrapperObj = new MysqliWrapper($mysqli); $page = ($page && is_numeric($page)) ? $page : 1; $sort_by = isset($sort_by) ? stripslashes($sort_by) : ''; $sort_desc = ($sort_desc) ? stripslashes($sort_desc) : 0; $pageRecord = ($pageRecord && is_numeric($pageRecord)) ? $pageRecord : 50; $varQueryString = formatURLQueryString('page,pageRecord', array($_REQUEST)); $url = formatURLQueryString('sort_by,sort_desc,page,pageRecord', array($_REQUEST)); $pageNum = 0; $total = 0; switch ($sort_by){ case 'company': $order_by = 'company'; break; case 'web': $order_by = "website"; break; case 'name': $order_by = 'contact_name'; break; case 'email': $order_by = 'email'; break; case 'country': $order_by = 'c.name'; break; case 'phone': $order_by = 'phone'; break; case 'date': $order_by = 'date_signedup'; break; default: $order_by = "date_signedup"; $sort_by ='date'; $sort_desc = 1; } $dataParams = new QueryData(); $sql = 'SELECT SQL_CALC_FOUND_ROWS pl.ca_rep, pl.prospective_label_id, pl.company, 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, ou.f_name, ou.l_name ' . ($viewall ? ', pl.address_street, pl.address2, pl.city, pl.zipcode, pl.phys_distributor, pl.full_length_album, pl.top_artist_1, pl.top_artist_2, pl.top_artist_3, pl.short_overview' : '') . ', pl.top_title_1, pl.top_title_2, pl.top_title_3, type_of_content FROM prospective_label pl INNER JOIN country c ON pl.country = c.id INNER JOIN orchard_state os ON os.id = pl.state LEFT JOIN genre g ON g.genre_id = pl.genre_id LEFT JOIN orchadmin_users ou on ou.id = pl.ca_rep WHERE pl.transferred = "N" AND pl.orchard_accepted <> "rejected"'; $sql .= ' AND pl.owner = ?'; $dataParams->addDataParam('s', $_SESSION['S_OA_OWNER']); $sql .= ' ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : '') . (!$viewall ? ' LIMIT 0, 5' : ' LIMIT ?, ?'); if ($viewall) { $dataParams->addDataParam('i', (($page - 1) * $pageRecord)); $dataParams->addDataParam('i', $pageRecord); } $prosp_label_result = $wrapperObj->executeQuery($sql, $dataParams); if ($prosp_label_result === false) { showierror($sql); } $dataParams = new QueryData(); $sql = 'SELECT FOUND_ROWS() AS total'; $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); if ($viewall) { if ($total) { echo paginate($page, $pageRecord, $pageNum, $varQueryString); } } ?>
| =($viewall ? sortColumnHeader('Company', 'company', $url) : 'Company')?> | =($viewall ? sortColumnHeader('Contact Name', 'name', $url) : 'Contact Name')?> | =($viewall ? sortColumnHeader('Email', 'email', $url) : 'Email')?> | =($viewall ? sortColumnHeader('Phone', 'phone', $url) : 'Phone')?> | =($viewall ? sortColumnHeader('Website', 'web', $url) : 'Website')?> | =($viewall ? sortColumnHeader('Country', 'country', $url) : 'Country')?> | =($viewall ? sortColumnHeader('Sign-up Date', 'date', $url) : 'Sign-up Date')?> |
|---|---|---|---|---|---|---|
| >=$prosp_label_row['company']?> | =$prosp_label_row['contact_name']?> | =$prosp_label_row['email']?> | =$prosp_label_row['phone']?> | =$prosp_label_row['website']?> | =$prosp_label_row['country']?> | =format_date($prosp_label_row['date_signedup'])?> |
|
|
|
||||
| No prospective label online sign-ups found. | ||||||