/** * Generate the pager HTML using the options passed to the constructor. * * @access public * @return array */ public function getLinks() { $links = $this->pager->getLinks(); $allLinks = $links['all']; $allLinks = str_replace('<a', '<li><a', $allLinks); $allLinks = str_replace('</a>', '</li></a>', $allLinks); if (strlen($allLinks) > 0) { $links['all'] = '<ul class="pagination">' . $allLinks . '</ul>'; } else { $links['all'] = null; } return $links; }
function lists() { require_once 'Pager/Sliding.php'; if (@$this->input->post('cid')) { foreach ($this->input->post('cid') as $v) { switch ($this->input->post('task')) { case 'activate': if ($this->campaign->setStatusCampaign($v, 'active')) { $this->notify->set_message('success', $this->getMsg('update_true')); } else { $this->notify->set_message('error', $this->getMsg('update_false')); } break; case 'deactivate': if ($this->campaign->setStatusCampaign($v, 'inactive')) { $this->notify->set_message('success', $this->getMsg('update_true')); } else { $this->notify->set_message('error', $this->getMsg('update_false')); } break; case 'delete': if ($this->campaign->removeCampaign($v)) { $this->notify->set_message('success', $this->getMsg('delete_true')); } else { $this->notify->set_message('error', $this->getMsg('delete_false')); } break; case 'announcewinner': if ($this->campaign->announceWinner($v, '1')) { $this->notify->set_message('success', $this->getMsg('update_true')); } else { $this->notify->set_message('error', $this->getMsg('update_false')); } break; case 'haltwinner': if ($this->campaign->announceWinner($v, '0')) { $this->notify->set_message('success', $this->getMsg('update_true')); } else { $this->notify->set_message('error', $this->getMsg('update_false')); } break; } } } elseif ($this->input->post('task')) { $this->notify->set_message('error', 'You haven\'t select any items required for the action.'); } $sql_filter = ""; //$config['path'] = APP_ADMIN_URL; $config['totalItems'] = $this->db->get_var("SELECT COUNT(*) FROM campaign_group " . $sql_filter); $config['perPage'] = 50; $config['urlVar'] = 'pageID'; $pageID = $this->input->get('pageID') ? $this->input->get('pageID') : 1; $pager = new Pager_Sliding($config); $links = $pager->getLinks($pageID); list($from, $to) = $pager->getOffsetByPageId(); $data = $this->campaign->retrieveCampaign(NULL, array('limit_number' => $config['perPage'], 'limit_offset' => --$from)); $this->load->view('admin/campaign', array('data' => $data, 'pagination' => $links)); }
function lists() { require_once 'Pager/Sliding.php'; if ($this->input->post('cid')) { foreach ($this->input->post('cid') as $v) { switch ($this->input->post('task')) { case 'delete': if ($this->app->remove($v)) { $this->notify->set_message('success', $this->getMsg('delete_true')); } else { $this->notify->set_message('error', $this->getMsg('delete_false')); } break; case 'dispatch': if ($this->app->dispatch($v)) { $this->notify->set_message('success', $this->getMsg('update_true')); } else { $this->notify->set_message('error', $this->getMsg('update_false')); } break; } } } //echo "test"; $sql_filter = ""; //$config['path'] = APP_ADMIN_URL; $config['totalItems'] = $this->db->get_var("SELECT COUNT(*) FROM campaign_app " . $sql_filter); $config['perPage'] = 20; $config['urlVar'] = 'pageID'; $pager = new Pager_Sliding($config); $pageID = $this->input->get('pageID') ? $this->input->get('pageID') : 1; $links = $pager->getLinks($pageID); list($from, $to) = $pager->getOffsetByPageId(); $data = $this->app->retrieve(NULL, array('limit_number' => $config['perPage'], 'limit_offset' => --$from)); $this->load->view('admin/app', array('data' => $data, 'pagination' => $links)); }
function display() { // if($this->ArrayHiddenTables[$GLOBALS["table"]]) { $this->addError(TEDeniedAccess); $this->displayHeader(); $this->displayFooter(); exit(); } // Raul 07-Ene-2008 Si la tabla esta considerada oculta, no podrĂ¡ accesar... if (isset($_GET['edit'])) { if ($this->getConfig('allowEdit')) { $this->handleAddEditCopy($_GET['edit']); } else { $this->errors[] = TEDeniedAccessEdit; } } elseif (isset($_GET['idcopy'])) { if ($this->getConfig('allowCopy')) { $this->handleAddEditCopy($_GET['idcopy']); } else { $this->errors[] = TEDeniedAccessCopy; } } elseif (!empty($_GET['add'])) { if ($this->getConfig('allowAdd')) { return $this->handleAddEditCopy(); } else { $this->errors[] = TEDeniedAccessAdd; } } if (isset($_GET['view'])) { if ($this->getConfig('allowView')) { $this->handleView($_GET['view']); } else { $this->errors[] = TEDeniedAccessView; } } if (isset($_GET['delete'])) { if ($this->getConfig('allowDelete')) { $result = $this->deleteRow($_GET['delete']); //exit; if ($result || 1 == 1) { $url = new TableEditor_URL(); $url->removeQueryString('delete'); // header('Location: ' . $url->getURL()); jmm 2/Ago/2005 TERedirection($url->getURL()); exit; } $url = new TableEditor_URL(); $url->removeQueryString('delete'); $this->errors[] = TEDeleteErrorB; } else { $this->errors[] = TEDeniedAccess; } } foreach ($this->fields as $field => $v) { if (empty($v['noDisplay'])) { if (isset($this->fields[$field]['FieldTypeList']["html"])) { $this->addDisplayFilter($field, 'FieldInputHtml'); } else { //$this->addDisplayFilter($field, 'htmlspecialchars'); switch ($this->fields[$field]['input']) { case "date": $this->addDisplayFilter($field, 'TE_formato_fecha'); break; // formatea todos los campos fecha // case "int": $this->addDisplayFilter($field, 'formato_numero'); break; // formatea a miles separados por comas // formatea todos los campos fecha // case "int": $this->addDisplayFilter($field, 'formato_numero'); break; // formatea a miles separados por comas case "decimal": $this->addDisplayFilter($field, 'formato_moneda_avanzado'); break; // formatea a miles separados por comas // formatea a miles separados por comas default: $this->addDisplayFilter($field, 'htmlspecialchars'); break; } } } } if (count($this->getConfig('searchableFields')) > 0 and isset($_GET['search']) and $_GET['search'] !== '') { $this->search = $_GET['search']; $searchStr = $this->dbQuote('%' . $this->search . '%'); $searchFields = $this->getConfig('searchableFields'); $searchClause = array(); foreach ($searchFields as $sf) { $this->addDisplayFilter($sf, array(&$this, 'searchDisplayFilter')); if (!empty($this->fields[$sf]['values'])) { $in = array(); // Inicializo el Arreglo solo una vez... foreach ($this->fields[$sf]['values'] as $k => $v) { if (strpos(strtolower($v), strtolower($this->search)) !== false) { $in[] = $this->dbQuote($k); } } if (!empty($in) && is_array($in)) { $in = implode(', ', $in); $searchClause[] = "{$sf} IN({$in})"; } continue; } $searchClause[] = "{$sf} LIKE {$searchStr}"; } if (!empty($searchClause)) { $searchClause = implode(' OR ', $searchClause); } else { $searchClause = '0'; } $url = new TableEditor_URL(); $url->removeQueryString('search'); $clearURL = $url->getURL(true); } else { $searchClause = '1'; } if (!empty($_GET['orderby']) and preg_match('#^([a-z0-9_]+)(:desc)?$#i', $_GET['orderby'], $matches)) { $this->orderby = array('field' => $matches[1], 'direction' => (int) empty($matches[2])); } $orderbyClause = "ORDER BY {$this->orderby['field']}" . (!$this->orderby['direction'] ? '' : ' DESC'); if (count(explode('orderby', $_SERVER['QUERY_STRING'])) > 2) { $url = new TableEditor_URL(); /*header('Location: ' . $url->getURL()); 2/Ago/2005*/ TERedirection($url->getURL()); exit; } if (!empty($this->dataFilters)) { $filters = implode(' AND ', $this->dataFilters); } else { $filters = 1; } list($tables, $joinClause) = $this->getQueryTables(); $total = $this->dbGetOne("SELECT COUNT(*) FROM {$tables} WHERE {$joinClause} AND {$filters} AND ({$searchClause})"); $perPage = $this->config['perPage']; $pager = new Pager_Sliding(array('totalItems' => $total, 'delta' => 5, 'prevImg' => '<img src="' . TEImagesPath . 'PagesArrowPrev.gif" width="6" height="7" border="0" />', 'nextImg' => '<img src="' . TEImagesPath . 'PagesArrowNext.gif" width="6" height="7" border="0" />', 'firstPageText' => '<img src="' . TEImagesPath . 'PagesArrowFirst.gif" width="9" height="7" border="0" />', 'lastPageText' => '<img src="' . TEImagesPath . 'PagesArrowLast.gif" width="9" height="7" border="0" />', 'spacesBeforeSeparator' => '1', 'spacesAfterSeparator' => '1', 'curPageLinkClassName' => 'avgbold', 'perPage' => $perPage)); list($startOffset, $endOffset) = $pager->getOffsetByPageId(); $startOffset--; // Eww - For SQL query list($back, $pages, $next) = $pager->getLinks(); foreach ($this->fields as $field => $f) { if (empty($f['noDisplay'])) { $fields[] = $field; } } $fields = implode(', ', $fields); $results = $this->dbGetAll($s = "SELECT {$fields} FROM {$tables} WHERE {$joinClause} AND {$filters} AND ({$searchClause}) {$orderbyClause} LIMIT {$startOffset},{$perPage}"); //echo "SELECT $fields FROM $tables WHERE $joinClause AND $filters AND ($searchClause) $orderbyClause LIMIT $startOffset,$perPage"; if ($results === false) { $this->errors[] = TEErrorDatabase . ' ' . $this->dbError() . "<br>" . $s; } if (!empty($results)) { foreach ($results as $k => $row) { $this->parseResults($results[$k]); } unset($row); $nonFilteredData = $results; foreach ($results as $k => $row) { $this->applyDisplayFilters($results[$k]); } unset($row); } if (!$_GET["edit"]) { include '' . TEFunctionsPath . 'ClassTableEditorList.php'; } $this->displayFooter(); exit; }
public function gallery() { require_once 'Pager/Sliding.php'; if (!($active_campaign = $this->campaign->getActiveCampaign())) { show_404(); } $sr = $this->facebook->getSignedRequest(); $redirect_url = isset($sr['page']) ? $this->config->item('APP_FANPAGE') . "&app_data=redirect|" . current_url() : "http://apps.facebook.com/" . $this->config->item('APP_APPLICATION_ID') . "/gallery"; if (!($user = getAuthorizedUser(true))) { redirect(mobile_menu_url('authorize') . '?ref=' . $redirect_url); } $userMedia = $this->media->mediaByUID($user['id'], $active_campaign['GID'], 'active'); $randMedia = $this->media->mediaByRandom($active_campaign['GID'], 'active'); $sql_filter = "WHERE campaign_media.media_status = 'active' AND campaign_media.GID = " . $active_campaign['GID']; $sumPerCampaign = $this->ezsql_mysql->get_var("SELECT COUNT(*) FROM campaign_media " . $sql_filter); $orderby = 'campaign_media.media_id'; $order = 'DESC'; if ($byorder = $this->input->get_post('orderby', TRUE)) { switch ($byorder) { case "mostvote": $orderby = "campaign_media.media_vote_total"; $order = "DESC"; break; case "latest": $orderby = 'campaign_media.media_id'; $order = 'DESC'; break; } } //$config['path'] = APP_ADMIN_URL; $config['totalItems'] = $sumPerCampaign; $config['perPage'] = 2; $config['urlVar'] = ($this->input->post('orderby') ? 'orderby=' . $this->input->post('orderby') . '&' : '') . 'pageID'; $pager = new Pager_Sliding($config); $pageID = $this->input->get_post('pageID') ? $this->input->get_post('pageID') : 1; $links = $pager->getLinks($pageID); list($from, $to) = $pager->getOffsetByPageId(); $rowsMedia = $this->media->retrieveMedia(array('campaign_media.media_status' => 'active', 'campaign_media.GID' => $active_campaign['GID']), array('orderby' => $orderby, 'order' => $order, 'limit_number' => $config['perPage'], 'limit_offset' => --$from)); $this->load->view('mobile/mobile_gallery', array('campaign' => $active_campaign, 'media' => $rowsMedia, 'user_media' => $userMedia ? $userMedia : null, 'random_media' => $randMedia ? $randMedia : null, 'pagination' => $links)); }
/** * Displays the page */ function display() { /** * Call a different function if we're editing/copying/adding a row. */ if (isset($_GET['edit'])) { if ($this->getConfig('allowEdit')) { $this->handleAddEditCopy($_GET['edit']); } else { $this->errors[] = 'Editing rows is not permitted'; } } else { if (isset($_GET['copy'])) { if ($this->getConfig('allowCopy')) { $this->handleAddEditCopy($_GET['copy']); } else { $this->errors[] = 'Copying rows is not permitted'; } } else { if (!empty($_GET['add'])) { if ($this->getConfig('allowAdd')) { return $this->handleAddEditCopy(); } else { $this->errors[] = 'Adding rows is not permitted'; } } } } /** * Also call a different function if we're viewing a row */ if (isset($_GET['view'])) { if ($this->getConfig('allowView')) { $this->handleView($_GET['view']); } else { $this->errors[] = 'Viewing rows is not permitted'; } } /** * Handle a delete if necessary. Has to be here to allow the object * to be setup in the calling script (eg. custom values). */ if (isset($_GET['delete'])) { if ($this->getConfig('allowDelete')) { $result = $this->deleteRow($_GET['delete']); if ($result) { $url = new TableEditor_URL(); $url->removeQueryString('delete'); header('Location: ' . $url->getURL()); exit; } $this->errors[] = 'Failed to delete row!'; } else { $this->errors[] = 'Deleting rows is not permitted'; } } /** * Handle displaying the advanced search page */ if ($this->getConfig('allowASearch') and !empty($_GET['asearch']) and $_GET['asearch'] == '1') { $this->displayAdvancedSearchPage(); } else { if ($this->getConfig('allowASearch') and !empty($_GET['asearch']) and $_GET['asearch'] == '2' and !empty($_GET['fields'])) { $searchClause = $this->handleAdvancedSearch(); // Get URL for clear link $url = new TableEditor_URL(); $url->addRawQueryString(''); $clearURL = $url->getURL(true); // Get URL for modify link $url = new TableEditor_URL(); $url->addQueryString('asearch', '1'); $modifyURL = $url->getURL(true); } } /** * Add htmlspecialchars() display filter. Has to be before search to prevent * search term highlighting being munged. */ foreach ($this->fields as $field => $v) { if (empty($v['noDisplay'])) { # $this->addDisplayFilter($field, 'htmlspecialchars'); } } /** * Handle searching */ if (count($this->getConfig('searchableFields')) > 0 and isset($_GET['search']) and $_GET['search'] !== '') { $this->search = $_GET['search']; $searchStr = $this->dbQuote('%' . $this->search . '%'); $searchFields = $this->getConfig('searchableFields'); $searchClause = array(); foreach ($searchFields as $sf) { $this->addDisplayFilter($sf, array(&$this, 'searchDisplayFilter')); // Handle fields which have predefined value sets if (!empty($this->fields[$sf]['values'])) { foreach ($this->fields[$sf]['values'] as $k => $v) { if (strpos(strtolower($v), strtolower($this->search)) !== false) { $in[] = $this->dbQuote($k); } } if (!empty($in)) { $in = implode(', ', $in); $searchClause[] = "{$sf} IN({$in})"; } continue; } $searchClause[] = "{$sf} LIKE {$searchStr}"; } // If no resulting search clauses (feasible), set search clause to "0" if (!empty($searchClause)) { $searchClause = implode(' OR ', $searchClause); } else { $searchClause = '0'; } // Get URL for clear link $url = new TableEditor_URL(); $url->removeQueryString('search'); $clearURL = $url->getURL(true); } else { if (empty($searchClause)) { $searchClause = '1'; } } /** * Handle ordering */ if (!empty($_GET['orderby']) and preg_match('#^([a-z0-9_]+)(:desc)?$#i', $_GET['orderby'], $matches)) { $this->orderby = array('field' => $matches[1], 'direction' => (int) empty($matches[2])); } $orderbyClause = "ORDER BY {$this->orderby['field']}" . (!$this->orderby['direction'] ? ' DESC' : ''); // Handle multiple instances of "orderby" on the query string; messy. if (count(explode('orderby', $_SERVER['QUERY_STRING'])) > 2) { $url = new TableEditor_URL(); header('Location: ' . $url->getURL()); exit; } /** * Handle data filters */ if (!empty($this->dataFilters)) { $filters = implode(' AND ', $this->dataFilters); } else { $filters = 1; } /** * Setup which tables we're selecting from */ list($tables, $joinClause) = $this->getQueryTables(); /** * Get total rows */ $total = $this->dbGetOne("SELECT COUNT(*) FROM {$tables} WHERE {$joinClause} AND {$filters} AND ({$searchClause})"); $perPage = $this->config['perPage']; /** * Handle paging of results */ $pager = new Pager_Sliding(array('totalItems' => $total, 'delta' => 5, 'prevImg' => '<span class="nextBackLink">«</span>', 'nextImg' => '<span class="nextBackLink">»</span>', 'spacesBeforeSeparator' => '1', 'spacesAfterSeparator' => '1', 'curPageLinkClassName' => 'avgbold', 'perPage' => $perPage)); list($startOffset, $endOffset) = $pager->getOffsetByPageId(); $startOffset--; // Eww - For SQL query list($back, $pages, $next) = $pager->getLinks(); /** * CSV handling - If downloading entire table as CSV, need to remove * the LIMIT information. */ if (!empty($_GET['csvdownload']) and $_GET['type'] == 'table') { $startOffset = 0; $perPage = $total; } /** * Get data */ $fields = $this->getDisplayFields(); $fields = implode(', ', $fields); $results = $this->dbGetAll($s = "SELECT {$fields} FROM {$tables} WHERE {$joinClause} AND {$filters} AND ({$searchClause}) {$orderbyClause} LIMIT {$startOffset},{$perPage}"); if ($results === false) { $this->errors[] = 'Error getting data. Database said: ' . $this->dbError(); } /** * Allow for value substitution */ if (!empty($results)) { foreach ($results as $k => $row) { $this->parseResults($results[$k]); } // Necessary to allow searching and highlighting on primary key field $nonFilteredData = $results; /** * Apply display filters */ foreach ($results as $k => $row) { $this->applyDisplayFilters($results[$k]); } } /** * If a CSV download is required, do that instead of showing the table */ if (!empty($_GET['csvdownload'])) { if ($this->getConfig('allowCSV')) { $this->handleCsvDownload($nonFilteredData); } else { $this->addError('CSV Download is not permitted'); } } // Advanced Search $url = new TableEditor_URL(); $url->addRawQueryString('asearch=1'); $aSearchURL = $url->getURL(); /** * Show the page in all it's wonderbar glory */ $this->displayHeader(); ?> <center> <table border="0" align="center"> <tr> <td> </td> <td colspan="<?php echo count($this->fields); ?> " align="center"> Displaying [<?php echo $total > 0 ? $startOffset + 1 : 0; ?> - <?php echo min($startOffset + $perPage, $total); ?> ] of <?php echo $total; ?> records </td> </tr> <tr> <td> </td> <td colspan="<?php echo count($this->fields) + 1; ?> " align="center"> <?php echo $back; ?> <?php echo $pages; ?> <?php echo $next; ?> <?if($this->getConfig('searchableFields')):?> <div style="float: left; text-align: left"> <input type="text" value="<?php echo $this->search; ?> " id="searchInput" onkeypress="if (event.keyCode == 13) search()"> <button onclick="search()">Search »</button> <br> <?if($this->getConfig('allowASearch')):?> <?if(!empty($_GET['asearch'])):?> <i>Advanced Search: <a href="<?php echo $modifyURL; ?> ">Modify</a> :: <a href="<?php echo $clearURL; ?> ">Clear</a></i> <?else:?> <a href="<?php echo $aSearchURL; ?> "><i>Advanced Search</i></a> <?endif?> <?if(isset($this->search)):?>::<?endif?> <?endif?> <?if(isset($this->search)):?> <a href="<?php echo $clearURL; ?> "><i>Clear search</i></a> <?endif?> </div> <?endif?> <div style="float: right; white-space: nowrap"> <?$this->displayActionButtons()?> </div> </td> </tr> <tr> <td> </td> <?foreach($this->fields as $field => $f):?> <?if(empty($f['noDisplay'])):?> <th style="white-space: nowrap"> <a href="javascript: orderBy('<?php echo $field . ($this->orderby['field'] == $field && $this->orderby['direction'] == 1 ? ':desc' : ''); ?> ')"><?php echo $f['display']; ?> </a><?if($this->orderby['field'] == $field):?><?php echo $this->orderby['direction'] == 1 ? ' ↑' : ' ↓'; ?> <?endif?> </th> <?endif?> <?endforeach?> </tr> <?if(!empty($results)):?> <?foreach($results as $k => $row):?> <tr <?php echo $k % 2 == 1 ? 'class="altRow"' : ''; ?> style="cursor: default" onclick="row_highlight(event, this, this.getElementsByTagName('input')[0], '<?php echo $k % 2 == 1 ? 'altRow' : ''; ?> ')"> <td> <input type="checkbox" id="rowSelector" value="<?php echo $nonFilteredData[$k][$this->pk]; ?> " onclick="row_highlight(event, this.parentNode.parentNode, this, '<?php echo $k % 2 == 1 ? 'altRow' : ''; ?> ')"> </td> <?foreach($row as $field => $v):?> <?if(empty($this->fields[$field]['noDisplay'])):?> <td valign="top"><?php echo $v; ?> </td> <?endif?> <?endforeach?> </tr> <?endforeach?> <?else:?> <tr> <td colspan="<?php echo count($this->fields); ?> " align="center">No data found!</td> </tr> <?endif?> <tr> <td> </td> <td colspan="<?php echo count($this->fields); ?> "> <div style="float: right"> <?$this->displayActionButtons()?> </div> </td> </tr> <tr> <td> </td> <td colspan="<?php echo count($this->fields); ?> " align="center"> <?php echo $back; ?> <?php echo $pages; ?> <?php echo $next; ?> </td> </tr> </table> <?php $this->displayFooter(); }
function lists() { require_once 'Pager/Sliding.php'; if ($this->input->post('cid')) { foreach ($this->input->post('cid') as $v) { list($asset_id, $asset_type, $asset_platform) = explode('|', $v); switch ($this->input->post('task')) { case 'delete': if ($this->asset->removeAssets($asset_id)) { $this->notify->set_message('success', $this->getMsg('delete_true')); } else { $this->notify->set_message('error', $this->getMsg('delete_false')); } break; case 'link': if ($gid = $this->input->post('bycampaign')) { if ($this->asset->setConnectionCampaign($asset_id, $gid, $asset_type, $asset_platform)) { $this->notify->set_message('success', $this->getMsg('update_true')); } else { $this->notify->set_message('error', $this->getMsg('update_false')); } } break; case 'unlink': if ($gid = $this->input->post('bycampaign')) { if ($this->asset->unsetConnectionCampaign($asset_id, $gid)) { $this->notify->set_message('success', $this->getMsg('update_true')); } else { $this->notify->set_message('error', $this->getMsg('update_false')); } } break; } } } elseif ($this->input->post('task')) { $this->notify->set_message('error', 'You haven\'t select any items required for the action.'); } //dg($this->notify); $clauses = array(); $orderby = 'campaign_media.media_id'; $order = 'DESC'; if ($this->input->get_post('bycampaign', TRUE)) { $clauses['campaign_group_assets.GID'] = $this->input->get_post('bycampaign', TRUE); } if ($bysearch = $this->input->get_post('bysearch', TRUE)) { $clauses['campaign_assets.asset_name'] = " LIKE '%" . $this->input->get_post('bysearch', TRUE) . "%' "; } //$config['path'] = APP_ADMIN_URL; $total = $this->asset->retrieveAssets($clauses, array('fields' => 'count(*) as total')); $config['totalItems'] = $total[0]['total']; $config['perPage'] = 15; //$config['urlVar'] = 'pageID'; $config['urlVar'] = ($this->input->post('bycampaign') ? 'bycampaign=' . $this->input->post('bycampaign') . '&' : '') . ($this->input->post('bysearch') ? 'bysearch=' . $this->input->post('bysearch') . '&' : '') . 'pageID'; $pager = new Pager_Sliding($config); $pageID = $this->input->get_post('pageID') ? $this->input->get_post('pageID') : 1; $links = $pager->getLinks($pageID); list($from, $to) = $pager->getOffsetByPageId(); $campaigns = $this->campaign->retrieveCampaign(null, array('fields' => 'campaign_group.GID,campaign_group.title')); $data = $this->asset->retrieveAssets($clauses, array('limit_number' => $config['perPage'], 'limit_offset' => --$from)); $this->load->view('admin/asset', array('data' => $data, 'offset' => $from, 'pagination' => $links, 'campaigns' => $campaigns)); }
function lists() { require_once 'Pager/Sliding.php'; if ($this->input->post('cid')) { foreach ($this->input->post('cid') as $v) { switch ($this->input->post('task')) { case 'activate': if ($this->media->setStatusMedia($v, 'active')) { $this->notify->set_message('success', $this->getMsg('update_true')); } else { $this->notify->set_message('error', $this->getMsg('update_false')); } break; case 'deactivate': if ($this->media->setStatusMedia($v, 'banned')) { $this->notify->set_message('success', $this->getMsg('update_true')); } else { $this->notify->set_message('error', $this->getMsg('update_false')); } break; case 'delete': if ($this->media->removeMedia($v)) { $this->notify->set_message('success', $this->getMsg('delete_true')); } else { $this->notify->set_message('error', $this->getMsg('delete_false')); } break; case 'winner': if ($this->media->setWinnerMedia($v, 1)) { $this->notify->set_message('success', $this->getMsg('update_true')); } else { $this->notify->set_message('error', $this->getMsg('update_false')); } break; case 'resetwinner': if ($this->media->setWinnerMedia($v, 0)) { $this->notify->set_message('success', $this->getMsg('update_true')); } else { $this->notify->set_message('error', $this->getMsg('update_false')); } break; } if ($this->input->post('notify') && in_array($this->input->post('task'), array('activate', 'deactivate'))) { $data = $this->media->detailMedia($v); switch ($this->input->post('task')) { case 'activate': $this->media->sendNotificationMail('approved', $data); break; case 'deactivate': $this->media->sendNotificationMail('banned', $data); break; } } } } elseif ($this->input->post('task')) { $this->notify->set_message('error', 'You haven\'t select any items required for the action.'); } $clauses = array(); $orderby = 'campaign_media.media_id'; $order = 'DESC'; if ($this->input->get_post('bycampaign', TRUE)) { $clauses['campaign_media.GID'] = $this->input->get_post('bycampaign', TRUE); } if ($this->input->get_post('byuid', TRUE)) { $clauses['campaign_media_owner.uid'] = $this->input->get_post('byuid', TRUE); } if ($this->input->get_post('bystatus', TRUE)) { $clauses['campaign_media.media_status'] = $this->input->get_post('bystatus', TRUE); } if ($byorder = $this->input->get_post('byorder', TRUE)) { $orderby = "campaign_media.media_vote_total"; switch ($byorder) { case "mostvoted": $order = "DESC"; break; case "lessvoted": $order = "ASC"; break; } } //$config['path'] = APP_ADMIN_URL; $total = $this->media->retrieveMedia($clauses, array('fields' => 'count(*) as total')); $config['totalItems'] = $total[0]['total']; $config['perPage'] = 15; //$config['urlVar'] = 'pageID'; $config['urlVar'] = ($this->input->post('bycampaign') ? 'bycampaign=' . $this->input->post('bycampaign') . '&' : '') . ($this->input->post('byuid') != '' ? 'byuid=' . $this->input->post('byuid') . '&' : '') . ($this->input->post('bystatus') ? 'bystatus=' . $this->input->post('bystatus') . '&' : '') . ($this->input->post('byorder') ? 'byorder=' . $this->input->post('byorder') . '&' : '') . 'pageID'; $pager = new Pager_Sliding($config); $pageID = $this->input->get_post('pageID') ? $this->input->get_post('pageID') : 1; $links = $pager->getLinks($pageID); list($from, $to) = $pager->getOffsetByPageId(); $campaigns = $this->campaign->retrieveCampaign(null, array('fields' => 'campaign_group.GID,campaign_group.title')); $data = $this->media->retrieveMedia($clauses, array('orderby' => $orderby, 'order' => $order, 'limit_number' => $config['perPage'], 'limit_offset' => --$from)); $this->load->view('admin/media', array('data' => $data, 'offset' => $from, 'pagination' => $links, 'campaigns' => $campaigns)); }