function index()
{
$this->getView()->addStylesheetURL('assets/stylesheets/sorting.css');
$customer_id = \Yoda\Request::getInt('customer_id');
$destination = \Yoda\Request::getString('destination');
$source = \Yoda\Request::getString('source');
$success = \Yoda\Request::getString('success', '');
$from_date = \Yoda\Request::getString('from_date');
$to_date = \Yoda\Request::getString('to_date');
$order = \Yoda\Request::getString('order', 'destination');
$direction = \Yoda\Request::getString('direction', 'ASC');
$pagination = new Pagination();
$pagination->setLimit(10);
$pagination->setPage(\Yoda\Request::getInt('page', 1));
$pagination->setLink('index.php?controller=sms&customer_id=' . $customer_id . '&destination=' . $destination . '&source=' . $source . '&success=' . $success . '&from_date=' . $from_date . '&to_date=' . $to_date);
$sms = new Didww\API2\SMSCollection();
$sms->setCustomerId($customer_id);
$sms->setDestination($destination);
$sms->setSource($source);
if ($success !== '') {
$sms->setSuccess($success);
}
$sms->setFromDate($from_date);
$sms->setToDate($to_date);
$sms->setOrderBy($order);
$sms->setOrderDir(strtoupper($direction));
$sms->setLimit($pagination->getLimit());
$sms->setOffset($pagination->getOffset());
$sms_log = $sms->getList();
$total = $sms->getTotal();
$pagination->setTotal($total);
$this->getView()->setProperties(['view' => $this->getView(), 'sms_log' => $sms_log, 'customer_id' => $customer_id, 'destination' => $destination, 'source' => $source, 'success' => $success, 'from_date' => $from_date, 'to_date' => $to_date, 'pagination' => $pagination, 'order' => $order, 'direction' => $direction, 'total' => $total])->display();
}
function index()
{
$this->getView()->addStylesheetURL('assets/stylesheets/sorting.css');
$customer_id = \Yoda\Request::getInt('customer_id');
$did_number = \Yoda\Request::getString('did_number');
$from_date = \Yoda\Request::getString('from_date');
$to_date = \Yoda\Request::getString('to_date');
$order = \Yoda\Request::getString('order', 'duration');
$direction = \Yoda\Request::getString('direction', 'ASC');
$pagination = new Pagination();
$pagination->setLimit(10);
$pagination->setPage(\Yoda\Request::getInt('page', 1));
$pagination->setLink('index.php?controller=call_history&did_number=' . $did_number . '&customer_id=' . $customer_id . '&from_date=' . $from_date . '&to_date=' . $to_date);
$cdr = new Didww\API2\CDRCollection();
$cdr->setCustomerId($customer_id);
$cdr->setDidNumber($did_number);
$cdr->setFromDate($from_date);
$cdr->setToDate($to_date);
$cdr->setOrderBy($order);
$cdr->setOrderDir(strtoupper($direction));
$cdr->setLimit($pagination->getLimit());
$cdr->setOffset($pagination->getOffset());
$cdrs = $cdr->getList();
$total = $cdr->getTotal();
$pagination->setTotal($total);
$this->getView()->setProperties(['view' => $this->getView(), 'cdrs' => $cdrs, 'customer_id' => $customer_id, 'did_number' => $did_number, 'from_date' => $from_date, 'to_date' => $to_date, 'pagination' => $pagination, 'order' => $order, 'direction' => $direction, 'total' => $total])->display();
}
public function actionList()
{
$data = new stdClass();
$batch = new Batch();
$batch->organizationId = Yii::app()->user->getOrgId();
$searchOptions = array();
$searchField = Yii::app()->request->getQuery("search", "");
if (!empty($searchField)) {
$searchOptions["code"] = $searchField;
}
$pager = new Pagination(10, 10, Yii::app()->request->getQuery("page", 1), 100000, false);
$searchOptions["start"] = $pager->getOffset();
$searchOptions["rows"] = 10;
$batchData = $batch->getBatches($searchOptions);
$pager->setTotalItems($batchData["count"], true);
$data->pager = $pager;
$data->batches = $batchData["items"];
$this->render('list', $data);
}
/**
* Returns information about the titles within a list including:
* - Title, Author, Bookcover URL, description, record id
*/
function getListTitles($listId = NULL, Pagination $pagination = NULL)
{
global $configArray;
if (!$listId) {
if (!isset($_REQUEST['id'])) {
return array('success' => false, 'message' => 'The id of the list to load must be provided as the id parameter.');
}
$listId = $_REQUEST['id'];
}
if (isset($_REQUEST['username']) && isset($_REQUEST['password'])) {
$username = $_REQUEST['username'];
$password = $_REQUEST['password'];
global $user;
$user = UserAccount::validateAccount($username, $password);
} else {
global $user;
}
if ($user) {
$userId = $user->id;
}
if (is_numeric($listId) || preg_match('/list[-:](.*)/', $listId, $listInfo)) {
if (isset($listInfo)) {
$listId = $listInfo[1];
}
return $this->_getUserListTitles($listId);
} elseif (preg_match('/search:(.*)/', $listId, $searchInfo)) {
if (is_numeric($searchInfo[1])) {
$titles = $this->getSavedSearchTitles($searchInfo[1]);
if ($titles && count($titles) > 0) {
return array('success' => true, 'listTitle' => $listId, 'listDescription' => "Search Results", 'titles' => $titles, 'cacheLength' => 4);
} else {
return array('success' => false, 'message' => 'The specified search could not be found.');
}
} else {
//Do a default search
$titles = $this->getSystemListTitles($listId);
if (count($titles) > 0) {
return array('success' => true, 'listTitle' => $listId, 'listDescription' => "System Generated List", 'titles' => $titles, 'cacheLength' => 4);
} else {
return array('success' => false, 'message' => 'The specified list could not be found.');
}
}
} else {
$systemList = null;
$systemLists = $this->getSystemLists();
foreach ($systemLists['lists'] as $curSystemList) {
if ($curSystemList['id'] == $listId) {
$systemList = $curSystemList;
break;
}
}
//The list is a system generated list
if ($listId == 'newEpub' || $listId == 'newebooks') {
require_once ROOT_DIR . 'sys/eContent/EContentRecord.php';
$eContentRecord = new EContentRecord();
$eContentRecord->orderBy('date_added DESC');
$eContentRecord->limit(0, 30);
$eContentRecord->find();
$titles = array();
while ($eContentRecord->fetch()) {
$titles[] = $this->setEcontentRecordInfoForList($eContentRecord);
}
return array('success' => true, 'listTitle' => $systemList['title'], 'listDescription' => $systemList['description'], 'titles' => $titles, 'cacheLength' => 1);
} elseif ($listId == 'freeEbooks') {
if (!$pagination) {
$pagination = new Pagination();
}
require_once ROOT_DIR . 'sys/eContent/EContentRecord.php';
$eContentRecord = new EContentRecord();
$eContentRecord->orderBy('date_added DESC');
$eContentRecord->whereAdd('accessType = \'free\'');
$eContentRecord->limit($pagination->getOffset(), $pagination->getNumItemsPerPage());
$eContentRecord->find();
$titles = array();
while ($eContentRecord->fetch()) {
$titles[] = $this->setEcontentRecordInfoForList($eContentRecord);
}
return array('success' => true, 'listTitle' => $systemList['title'], 'listDescription' => $systemList['description'], 'titles' => $titles, 'cacheLength' => 1);
} elseif ($listId == 'highestRated') {
$query = "SELECT record_id, AVG(rating) FROM `user_rating` inner join resource on resourceid = resource.id GROUP BY resourceId order by AVG(rating) DESC LIMIT 30";
$result = mysql_query($query);
$ids = array();
while ($epubInfo = mysql_fetch_assoc($result)) {
$ids[] = $epubInfo['record_id'];
}
$titles = $this->loadTitleInformationForIds($ids);
return array('success' => true, 'listTitle' => $systemList['title'], 'listDescription' => $systemList['description'], 'titles' => $titles, 'cacheLength' => 1);
} elseif ($listId == 'highestRatedEContent') {
require_once ROOT_DIR . '/sys/eContent/EContentRating.php';
$econtentRating = new EContentRating();
$records = $econtentRating->getRecordsListAvgRating("DESC", 30);
$titles = array();
if (!empty($records)) {
foreach ($records as $eContentRecord) {
$titles[] = $this->setEcontentRecordInfoForList($eContentRecord);
}
}
return array('success' => true, 'listTitle' => $systemList['title'], 'listDescription' => $systemList['description'], 'titles' => $titles, 'cacheLength' => 1);
} elseif ($listId == 'recentlyReviewed') {
$query = "SELECT record_id, MAX(created) FROM `comments` inner join resource on resource_id = resource.id group by resource_id order by max(created) DESC LIMIT 30";
$result = mysql_query($query);
$ids = array();
while ($epubInfo = mysql_fetch_assoc($result)) {
$ids[] = $epubInfo['record_id'];
}
$titles = $this->loadTitleInformationForIds($ids);
return array('success' => true, 'listTitle' => $systemList['title'], 'listDescription' => $systemList['description'], 'titles' => $titles, 'cacheLength' => 1);
} elseif ($listId == 'mostPopular') {
$query = "SELECT record_id, count(userId) from user_reading_history inner join resource on resourceId = resource.id GROUP BY resourceId order by count(userId) DESC LIMIT 30";
$result = mysql_query($query);
$ids = array();
while ($epubInfo = mysql_fetch_assoc($result)) {
$ids[] = $epubInfo['record_id'];
}
$titles = $this->loadTitleInformationForIds($ids);
return array('success' => true, 'listTitle' => $systemList['title'], 'listDescription' => $systemList['description'], 'titles' => $titles, 'cacheLength' => 1);
} elseif ($listId == 'recommendations') {
if (!$user) {
return array('success' => false, 'message' => 'A valid user must be provided to load recommendations.');
} else {
$userId = $user->id;
require_once ROOT_DIR . '/services/MyResearch/lib/Suggestions.php';
$suggestions = Suggestions::getSuggestions($userId);
$titles = array();
foreach ($suggestions as $id => $suggestion) {
$imageUrl = $configArray['Site']['coverUrl'] . "/bookcover.php?id=" . $id;
if (isset($suggestion['titleInfo']['issn'])) {
$imageUrl .= "&issn=" . $suggestion['titleInfo']['issn'];
}
if (isset($suggestion['titleInfo']['isbn10'])) {
$imageUrl .= "&isn=" . $suggestion['titleInfo']['isbn10'];
}
if (isset($suggestion['titleInfo']['upc'])) {
$imageUrl .= "&upc=" . $suggestion['titleInfo']['upc'];
}
if (isset($suggestion['titleInfo']['format_category'])) {
$imageUrl .= "&category=" . $suggestion['titleInfo']['format_category'];
}
$smallImageUrl = $imageUrl . "&size=small";
$imageUrl .= "&size=medium";
$titles[] = array('id' => $id, 'image' => $imageUrl, 'small_image' => $smallImageUrl, 'title' => $suggestion['titleInfo']['title'], 'author' => $suggestion['titleInfo']['author']);
}
return array('success' => true, 'listTitle' => $systemList['title'], 'listDescription' => $systemList['description'], 'titles' => $titles, 'cacheLength' => 0);
}
} else {
return array('success' => false, 'message' => 'The specified list could not be found.');
}
}
}
<li><a href="../update_profile.php" title="About">Профил</a></li>
<li><a href = "add.php">Добавете забележителност</a></li>
<li><a href="all_landmarks.php" title="all">Всички</a></li>
<li><a href="../contact_form.php" title="Contact Us">Контакт</a></li>
<li><a href="../logout.php" title="logout">Изход</a></li>
</ul>
</div>
</div><!-- // end #header -->
<?php
require '../classes/landmarkDB.php';
require '../classes/pagination.php';
require '../home.php';
$landmarks = new LandmarkDB();
$limit = 4;
$pagination = new Pagination();
$offset = $pagination->getOffset($limit);
$yourLandmarks = $landmarks->getYourLandmarks($limit, $offset);
$ids = array();
foreach ($yourLandmarks as $value) {
$ids[] = (int) $value->id;
}
$yourLandmarkImages = $landmarks->selectLandmarkItemsImages($ids, 'small');
$bigImages = $landmarks->selectLandmarkItemsImages($ids, 'big');
?>
<?php
if (count($yourLandmarks) > 0) {
?>
<div id="main">
<div class="container">
<div id="slideshow">
<?php
public function overview($tpl = null, $pagination = 0, CustomDataFilter $filter = null)
{
if ($filter === null) {
$filter = new CustomDataFilter($this->position);
foreach ($this->mainFields as $field) {
$filter->field($field);
}
$filter->orderBy(reset($this->mainFields));
}
$pages = '';
if ($pagination > 0) {
$pg = new Pagination($pagination, $filter->getAmount());
$pg->setUri($this->baseUri);
$pg->parsePage();
$filter->limit($pg->getPerPage(), $pg->getOffset());
$pages = $pg->build();
}
$tpl = Response::getObject()->appendTemplate($tpl ? $tpl : "/Cms/fields/data_categories");
$tpl->assign('pages', $pages, false);
$tpl->assign('list', $filter->retrieveList(), false);
$tpl->assign('baseUri', $this->baseUri);
$tpl->output();
}
/**
* Use Pagination object for limiting the results
*
* @param Pagination $pager
* @return \Query
*/
public function pagination(Pagination $pager)
{
$this->offset($pager->getOffset());
$this->limit($pager->getRowsCount());
return $this;
}
protected function members()
{
$db = Database::getObject();
$db->query("SELECT COUNT(*) FROM <p>user");
$pp = Config::get('pagination.admin');
$pg = new Pagination($pp, $db->fetchOne());
$pg->parsePage();
$pg->setUri(Uri::build('/Cms/admin/members'));
$offset = $pg->getOffset();
$db->query("SELECT * FROM <p>user ORDER BY surname, forename LIMIT <offset:int>, <pp:int>", compact("offset", "pp"));
$data = array();
while ($row = $db->fetchAssoc()) {
$row['group'] = UserUtils::getGroupName($row['group_id']);
$data[] = $row;
}
$tpl = Response::getObject()->appendTemplate("Cms/admin/members");
$tpl->assign("pages", $pg->build(), false);
$tpl->assign("data", $data);
$tpl->output();
}
