function getActionList(&$pListHash)
{
global $gBitUser, $gBitSystem;
if (empty($pListHash['sort_mode'])) {
$pListHash['sort_mode'] = 'created_asc';
}
LibertyContent::prepGetList($pListHash);
$selectSql = '';
$joinSql = '';
$whereSql = '';
$bindVars = array();
array_push($bindVars, $this->mContentTypeGuid);
$this->getServicesSql('content_list_sql_function', $selectSql, $joinSql, $whereSql, $bindVars, NULL, $pListHash);
// this will set $find, $sort_mode, $max_records and $offset
extract($pListHash);
$sortModePrefix = 'lc.';
$sort_mode = $sortModePrefix . $this->mDb->convertSortmode($pListHash['sort_mode']);
$query = "\n\t\t\tSELECT sa.*, lc.*, \n\t\t\t\tacm.`action_c_key_id` AS `action_content_key`, \n\t\t\t\tacm.`action_c_detail_key_id` AS `action_content_detail_key`, \n\t\t\t\tlc.*, lch.`hits`, lcds.`data` AS `summary`, lc.`last_modified` AS sort_date,\n\t\t\t\tlf.storage_path AS `image_attachment_path` \n\t\t\t\t{$selectSql}\n\t\t\tFROM `" . BIT_DB_PREFIX . "diasalsa_actions` sa\n\t\t\t\tLEFT JOIN \t\t`" . BIT_DB_PREFIX . "diasalsa_action_content_map` acm ON acm.`content_id` = sa.`content_id`\n\t\t\t\tINNER JOIN \t\t`" . BIT_DB_PREFIX . "liberty_content` lc \t\tON lc.`content_id` \t\t = sa.`content_id`\n\t\t\t\tINNER JOIN\t\t`" . BIT_DB_PREFIX . "users_users`\t\t\t uu ON uu.`user_id`\t\t\t = lc.`user_id`\n\t\t\t\tLEFT OUTER JOIN `" . BIT_DB_PREFIX . "liberty_content_hits` lch ON lc.`content_id` = lch.`content_id`\n\t\t\t\tLEFT OUTER JOIN `" . BIT_DB_PREFIX . "liberty_content_data` lcds ON (lc.`content_id` = lcds.`content_id` AND lcds.`data_type`='summary')\n\t\t\t\tLEFT OUTER JOIN `" . BIT_DB_PREFIX . "liberty_attachments` la ON la.`content_id` = lc.`content_id` AND la.`is_primary` = 'y'\n\t\t\t\tLEFT OUTER JOIN `" . BIT_DB_PREFIX . "liberty_files` lf ON lf.`file_id` = la.`foreign_id`\n\t\t\t\t{$joinSql}\n\t\t\tWHERE lc.`content_type_guid` = ? {$whereSql}\n\t\t\tORDER BY {$sort_mode}";
$query_cant = "\n SELECT COUNT(*)\n FROM `" . BIT_DB_PREFIX . "diasalsa_actions` sa\n INNER JOIN `" . BIT_DB_PREFIX . "liberty_content` lc ON( lc.`content_id` = sa.`content_id` ) {$joinSql}\n WHERE lc.`content_type_guid` = ? {$whereSql}";
$result = $this->mDb->query($query, $bindVars, $max_records, $offset);
$ret = array();
while ($res = $result->fetchRow()) {
$res['thumbnail_url'] = SalsaAction::getImageThumbnails($res);
$res['display_url'] = SalsaAction::getDisplayUrl(NULL, $res);
$res['action_count'] = SalsaAction::getSendersCount($res);
$ret[] = $res;
}
$pListHash["cant"] = $this->mDb->getOne($query_cant, $bindVars);
// add all pagination info to pListHash
LibertyContent::postGetList($pListHash);
return $ret;
}
