function listKeywords($info = '')
{
$userId = isLoggedIn();
$websiteController = new WebsiteController();
$websiteId = empty($info['website_id']) ? "" : intval($info['website_id']);
$this->set('websiteList', $websiteController->__getAllWebsites($userId, true));
$this->set('websiteId', $websiteId);
$conditions = empty($websiteId) ? "" : " and k.website_id={$websiteId}";
$sql = "select k.*,w.name website,w.status webstatus from keywords k,websites w where k.website_id=w.id";
$sql .= isAdmin() ? "" : " and w.user_id={$userId}";
$sql .= " {$conditions} order by k.name";
# pagination setup
$this->db->query($sql, true);
$this->paging->setDivClass('pagingdiv');
$this->paging->loadPaging($this->db->noRows, SP_PAGINGNO);
$pagingDiv = $this->paging->printPages('keywords.php', '', 'scriptDoLoad', 'content', 'website_id=' . $websiteId);
$this->set('pagingDiv', $pagingDiv);
$sql .= " limit " . $this->paging->start . "," . $this->paging->per_page;
# set keywords list
$keywordList = $this->db->select($sql);
$this->set('pageNo', $_GET['pageno']);
$langCtrler = new LanguageController();
$countryCtrler = new CountryController();
foreach ($keywordList as $i => $keyInfo) {
$info = $langCtrler->__getLanguageInfo($keyInfo['lang_code']);
$keywordList[$i]['lang_name'] = $info['lang_name'];
$info = $countryCtrler->__getCountryInfo($keyInfo['country_code']);
$keywordList[$i]['country_name'] = $info['country_name'];
}
$this->set('list', $keywordList);
$this->render('keyword/list');
}
function listKeywords($info = '')
{
$userId = isLoggedIn();
$websiteController = new WebsiteController();
$urlParams = "";
$websiteId = empty($info['website_id']) ? "" : intval($info['website_id']);
$this->set('websiteList', $websiteController->__getAllWebsites($userId, true));
$this->set('websiteId', $websiteId);
if ($websiteId) {
$conditions = " and k.website_id={$websiteId}";
$urlParams = "website_id={$websiteId}";
} else {
$conditions = "";
}
if (isset($info['status'])) {
if ($info['status'] == 'active' || $info['status'] == 'inactive') {
$statVal = $info['status'] == 'active' ? 1 : 0;
$conditions .= " and k.status={$statVal}";
$urlParams .= "&status=" . $info['status'];
}
} else {
$info['status'] = '';
}
$this->set('statVal', $info['status']);
if (empty($info['keyword'])) {
$info['keyword'] = '';
} else {
$info['keyword'] = urldecode($info['keyword']);
$conditions .= " and k.name like '%" . addslashes($info['keyword']) . "%'";
$urlParams .= "&keyword=" . urlencode($info['keyword']);
}
$this->set('keyword', $info['keyword']);
$sql = "select k.*,w.name website,w.status webstatus from keywords k,websites w where k.website_id=w.id and w.status=1";
$sql .= isAdmin() ? "" : " and w.user_id={$userId}";
$sql .= " {$conditions} order by k.name";
# pagination setup
$this->db->query($sql, true);
$this->paging->setDivClass('pagingdiv');
$this->paging->loadPaging($this->db->noRows, SP_PAGINGNO);
$pagingDiv = $this->paging->printPages('keywords.php', '', 'scriptDoLoad', 'content', $urlParams);
$this->set('pagingDiv', $pagingDiv);
$sql .= " limit " . $this->paging->start . "," . $this->paging->per_page;
# set keywords list
$keywordList = $this->db->select($sql);
$this->set('pageNo', $info['pageno']);
$langCtrler = new LanguageController();
$countryCtrler = new CountryController();
foreach ($keywordList as $i => $keyInfo) {
$info = $langCtrler->__getLanguageInfo($keyInfo['lang_code']);
$keywordList[$i]['lang_name'] = $info['lang_name'];
$info = $countryCtrler->__getCountryInfo($keyInfo['country_code']);
$keywordList[$i]['country_name'] = $info['country_name'];
}
$this->set('list', $keywordList);
$this->render('keyword/list');
}