function getList(&$pListHash)
{
global $gBitDb;
$bindVars = array();
parent::prepGetList($pListHash);
$mid = '';
if (@BitBase::verifyId($pListHash['nl_id'])) {
$mid .= (empty($mid) ? 'WHERE' : 'AND') . ' n.nl_id=? ';
$bindVars[] = $pListHash['nl_id'];
}
if ($pListHash['find']) {
$findesc = '%' . $pListHash['find'] . '%';
$mid .= (empty($mid) ? 'WHERE' : 'AND') . ' (lc.`title` like ? or lc.`data` like ?)';
$bindVars[] = $findesc;
$bindVars[] = $findesc;
}
$query = "SELECT `edition_id` AS `hash_key`, ne.*, lc.*, lc2.`title` AS `newsletter_title`\n\t\t\t\t FROM `" . BIT_DB_PREFIX . "newsletters_editions` ne\n\t\t\t\t \tINNER JOIN `" . BIT_DB_PREFIX . "liberty_content` lc ON( lc.`content_id`=ne.`content_id` )\n\t\t\t\t \tINNER JOIN `" . BIT_DB_PREFIX . "newsletters` n ON( ne.`nl_content_id`=n.`content_id` )\n\t\t\t\t \tLEFT OUTER JOIN `" . BIT_DB_PREFIX . "liberty_content` lc2 ON( n.`content_id`=lc2.`content_id` )\n\t\t\t\t {$mid} ORDER BY " . $gBitDb->convertSortmode($pListHash['sort_mode']);
$query_cant = "select count(*) from `" . BIT_DB_PREFIX . "newsletters` n INNER JOIN `" . BIT_DB_PREFIX . "newsletters_editions` ne ON(n.`content_id`=ne.`nl_content_id`) {$mid}";
$ret = $gBitDb->getAssoc($query, $bindVars, $pListHash['max_records'], $pListHash['offset']);
foreach (array_keys($ret) as $k) {
$ret[$k]['display_url'] = BitNewsletterEdition::getDisplayUrlFromHash($ret[$k]);
// remove formating tags
$data = preg_replace('/{[^{}]*}/', '', $ret[$k]['data']);
// $ret[$k]['parsed'] = BitNewsletterEdition::parseData( $data, $ret[$k]['format_guid'] );
}
$pListHash['total_records'] = $gBitDb->getOne($query_cant, $bindVars);
$pListHash['block_pages'] = 5;
$pListHash['total_pages'] = ceil($pListHash['total_records'] / $pListHash['max_records']);
$pListHash['current_page'] = !empty($pListHash['offset']) ? floor($pListHash['offset'] / $pListHash['max_records']) + 1 : 1;
return $ret;
}
