/** * * 订单数据服务费列表 * */ public function actionIndex() { $ecmsTaxModel = new EcmsTaxReceiptModel(); $dataserviceModel = new DataServiceFeeModel(); $plamfromType = CDict::$platform_type; $getData = $this->_get(); $curr_page = $getData['page'] ? $getData['page'] : 1; $platform_type = $this->_get('platform_type'); // 平台类型 $platfromType = CDict::$platform_type; $whereSql = ''; if ($getData['platform_type'] != '0' && $getData['platform_type']) { $whereSql .= "AND ORDERTYPE = '" . $getData['platform_type'] . "'"; } if (strlen($getData['gbillno']) > 0) { $whereSql .= "AND GENERALBILLNO LIKE '%" . $getData['gbillno'] . "%'"; } if (strlen($getData['start-time']) > 0) { $whereSql .= " AND TO_CHAR(REALARRIVALDATE, 'YYYY-MM-DD HH24:MI:SS') > '" . $getData['start-time'] . " 00:00:00'"; } if (strlen($getData['end-time']) > 0) { $whereSql .= " AND TO_CHAR(REALARRIVALDATE, 'YYYY-MM-DD HH24:MI:SS') < '" . $getData['end-time'] . " 24:00:00'"; } $data = $dataserviceModel->getList($whereSql, $curr_page, $this->_pageSize); $count = $dataserviceModel->getNowhereCount($whereSql); $page = new pager($count, $curr_page, $this->_pageSize); $pageStr = $page->GetPagerContent(); //var_dump($data); //var_dump($getData); //var_dump($whereSql); $count1 = $this->_orderHeadModel->get_count(" AND HANDLESTATE='3' AND BILLSTATUS='0' "); $count2 = $this->_orderHeadModel->get_count(" AND HANDLESTATE='3' AND BILLSTATUS='1' "); $count3 = $this->_orderHeadModel->get_count(" AND HANDLESTATE='3' AND BILLSTATUS='2' "); $count4 = $ecmsTaxModel->get_count(" AND TYPE='ECMS'"); $count5 = $ecmsTaxModel->get_count(" AND TYPE='UPS'"); $count6 = $dataserviceModel->getNowhereCount(""); $this->assign("count1", $count1); $this->assign("count2", $count2); $this->assign("count3", $count3); $this->assign("count4", $count4); $this->assign("count5", $count5); $this->assign("count6", $count6); array_unshift($plamfromType, "选择平台类型"); $this->assign('page', $pageStr); $this->assign('count', $count); $this->assign('platform_type', $getData['platform_type']); $this->assign('gbillno', $getData['gbillno']); $this->assign('starttime', $getData['start-time']); $this->assign('endtime', $getData['end-time']); $this->assign('data', $data); $this->assign("platformType", $plamfromType); $this->display('dataservicefee/dataservicefee_index.html'); }
function init($pages, $cur_page, $uri) { self::$pager = true; self::$pages = $pages; self::$cur_page = $cur_page; self::$pager_uri = $uri; }
/** * Trash * * @param string $type all|hidden * @param string $orderBy * @param int $recTotal * @param int $recPerPage * @param int $pageID * @access public * @return void */ public function trash($type = 'all', $orderBy = 'id_desc', $recTotal = 0, $recPerPage = 20, $pageID = 1) { /* Save session. */ $uri = $this->app->getURI(true); $this->session->set('productList', $uri); $this->session->set('productPlanList', $uri); $this->session->set('releaseList', $uri); $this->session->set('storyList', $uri); $this->session->set('projectList', $uri); $this->session->set('taskList', $uri); $this->session->set('buildList', $uri); $this->session->set('bugList', $uri); $this->session->set('caseList', $uri); $this->session->set('testtaskList', $uri); $this->session->set('docList', $uri); /* Get deleted objects. */ $this->app->loadClass('pager', $static = true); $pager = pager::init($recTotal, $recPerPage, $pageID); $trashes = $this->action->getTrashes($type, $orderBy, $pager); /* Title and position. */ $this->view->title = $this->lang->action->trash; $this->view->position[] = $this->lang->action->trash; $this->view->trashes = $trashes; $this->view->type = $type; $this->view->orderBy = $orderBy; $this->view->pager = $pager; $this->view->users = $this->loadModel('user')->getPairs('noletter'); $this->display(); }
public function setURL() { parent::setURL(); $url = parse_url($_SERVER['REQUEST_URI']); if (isset($url['query'])) { parse_str($url['query'], $args); } else { $args = array(); } # Removing session information if (session_id()) { if (isset($args[session_name()])) { unset($args[session_name()]); } } if (isset($args[$this->var_page])) { unset($args[$this->var_page]); } if (isset($args['ok'])) { unset($args['ok']); } $this->form_hidden = ''; foreach ($args as $k => $v) { if (is_array($v)) { foreach ($v as $k2 => $v2) { $this->form_hidden .= form::hidden(array($k . '[]'), html::escapeHTML($v2)); } } else { $this->form_hidden .= form::hidden(array($k), html::escapeHTML($v)); } } $this->form_action = $url['path']; }
function set($entries, $page, $limit) { self::$entries = $entries; self::$limit = $limit; self::$pages = $entries > 0 ? ceil($entries / $limit) : 0; self::$page = self::sanitize($page, self::$pages); }
public static function init($page, $total, $num = 10) { self::$page = max(1, $page); self::$start = $num * (self::$page - 1); self::$num = $num; self::$total = $total; self::$last = ceil($total / $num); }
public function _get() { $total = oo::m()->count(); $page = $this->req('page'); pager::init($page, $total); $list = oo::m()->limit(pager::$start, pager::$num)->orderby('id desc')->getall(); method_exists($this, 'after_get') && $this->after_get($list); $this->assign('pager', pager::get()); $this->assign('list', $list); $this->display("{$this->form['tpl']}_list"); }
public function getPager($addWhere = '', $addSql = '', $showMax = 20, $select = '', $key = '', $form_vars = array()) { $db = sf::getLib("db"); if ($select) { $sql = $select . " "; } else { $sql = "SELECT * FROM `" . $this->table . "` "; } $addWhere && ($sql .= "WHERE " . $addWhere . " "); $addSql && ($sql .= $addSql . " "); if (!router::get("totalnum" . $key)) { $_sql = "SELECT COUNT(*) AS NUM FROM `" . $this->table . "` "; $addWhere && ($_sql .= "WHERE " . $addWhere . " "); $addSql && ($_sql .= $addSql . " "); $row = $db->fetch_first($_sql); $total = $row['NUM']; } else { $total = router::get("totalnum" . $key); } $pager = new pager($total, $showMax, $key, $form_vars); $sql .= "LIMIT " . $pager->getStartNum() . "," . $pager->getShowNum(); $query = $db->query($sql); $pager->setField($db->result_array($query)); $pager->setObject(clone $this); return $pager; }
public function display($page, $nb_per_page, $enclose_block = '') { if ($this->rs->isEmpty()) { echo '<p><strong>' . __('No page') . '</strong></p>'; } else { $pager = new pager($page, $this->rs_count, $nb_per_page, 10); $pager->html_prev = $this->html_prev; $pager->html_next = $this->html_next; $pager->var_page = 'page'; $html_block = '<table class="clear"><tr>' . '<th colspan="2">' . __('Title') . '</th>' . '<th>' . __('Date') . '</th>' . '<th>' . __('Author') . '</th>' . '<th>' . __('Comments') . '</th>' . '<th>' . __('Trackbacks') . '</th>' . '<th>' . __('Status') . '</th>' . '</tr>%s</table>'; if ($enclose_block) { $html_block = sprintf($enclose_block, $html_block); } echo '<p>' . __('Page(s)') . ' : ' . $pager->getLinks() . '</p>'; $blocks = explode('%s', $html_block); echo $blocks[0]; while ($this->rs->fetch()) { echo $this->postLine(); } echo $blocks[1]; echo '<p>' . __('Page(s)') . ' : ' . $pager->getLinks() . '</p>'; } }
/** * Processes available input adjusting internal state of databrowser. * * @return \de\toxa\txf\databrowser current instance */ public function processInput() { if (!$this->pager) { // process all input once USING pager for semaphore $this->pager = new pager($this->datasource->count(), $this->volatilePager); if ($this->pager->isEnabled()) { $this->datasource->size($this->pager->size())->offset($this->pager->offset()); if ($this->getForm()) { $this->pager->enableButtons(true); } } } return $this; }
public function index() { $cid = $this->req('cid', 0, 'intval'); $where = array(); $cid && ($where = array('cateid' => $cid)); $total = oo::m('product')->where($where)->count(); $page = $this->req('page'); pager::init($page, $total); $list = oo::m('product')->limit(pager::$start, pager::$num)->orderby('id desc')->where($where)->getall(); $this->assign('list', $list); //推荐商家 $seller = oo::m('seller')->limit(5)->getall(); $this->assign('seller', $seller); $this->display('list'); }
/** * отображаем весь список материалов */ function indexAction() { if (isset($_POST['status'])) { $_SESSION['status'] = $_POST['status']; } if (isset($_POST['status'])) { $limit = 1000; } else { $_total_news = dbh::news_get_total_count(); $limit = pager::pager_limit($_total_news, ADMIN_NEWS_AT_PAGE); } // строим запрос $_sql = 'SELECT * FROM ' . $this->tablename . ' where id>0 ' . general::get_status_for_filter($this->tablename) . ' order by created_at desc, sort limit ' . $limit; // выполняем запрос + при необходимости выводим сам запрос $result = mysql::query($_sql, 3); return system::show_tpl(array('result' => $result, 'msg' => $this->msg, '_status' => isset($_POST['status']) ? $_POST['status'] : 2, 'tpl_folder' => $this->tpl_folder, '_total_news' => $_total_news), $this->tpl_folder . '/index.php'); }
/** * отображаем весь список материалов */ function indexAction() { // если перешли по get ссылке из меню if (isset($_POST['name'])) { $_SESSION['name'] = $_POST['name']; } if (isset($_POST['artikul'])) { $_SESSION['artikul'] = $_POST['artikul']; } if ($_POST) { if (isset($_POST['block_new'])) { $_SESSION['block_new'] = $_POST['block_new']; } else { unset($_SESSION['block_new']); } if (isset($_POST['block_lider'])) { $_SESSION['block_lider'] = $_POST['block_lider']; } else { unset($_SESSION['block_lider']); } } if (isset($_POST['id_parent'])) { $_SESSION['id_parent'] = $_POST['id_parent']; } if (isset($_POST['brand'])) { $_SESSION['brand'] = $_POST['brand']; } if (isset($_POST['photo'])) { $_SESSION['photo'] = $_POST['photo']; } if (isset($_POST['sklad'])) { $_SESSION['sklad'] = $_POST['sklad']; } if (isset($_POST['status'])) { $_SESSION['status'] = $_POST['status']; } // get limit // всего в каталоге $_total_catalog = dbh::catalog_get_total_count(); $limit = pager::pager_limit($_total_catalog, ADMIN_CATALOG_AT_PAGE); // строим запрос $_sql = 'SELECT * FROM ' . $this->tablename . ' where id>0 ' . general::get_status_for_filter($this->tablename) . ' order by sort limit ' . $limit; // выполняем запрос + при необходимости выводим сам запрос $result = mysql::query($_sql, 0); return system::show_tpl(array('result' => $result, 'msg' => $this->msg, '_total_catalog' => $_total_catalog, '_status' => isset($_SESSION['status']) ? $_SESSION['status'] : 2, '_brand' => isset($_SESSION['brand']) ? $_SESSION['brand'] : 0, '_photo' => isset($_SESSION['photo']) ? $_SESSION['photo'] : 2, '_sklad' => isset($_SESSION['sklad']) ? $_SESSION['sklad'] : 3, 'tpl_folder' => $this->tpl_folder, 'select' => dbh::get_catolog_tree(), 'brand' => dbh::get_brand(), 'curent_id_parent' => isset($_SESSION['id_parent']) ? $_SESSION['id_parent'] : 0), $this->tpl_folder . '/index.php'); }
public function defaultpwd($recTotal = 0, $recPerPage = 20, $pageID = 1) { /* Load pager. */ $this->app->loadClass('pager', $static = true); if ($this->app->getViewType() == 'mhtml') { $recPerPage = 10; } $pager = pager::init($recTotal, $recPerPage, $pageID); $passwords = $this->kevinlogin->getPasswordList($pager); if (!empty($_POST)) { $this->kevinlogin->updateDefaultPwd(); die(js::reload('parent')); } $this->view->title = $this->lang->kevinlogin->common . $this->lang->colon . $this->lang->kevinlogin->defaultpwd; $this->view->position[] = $this->lang->kevinlogin->defaultpwd; $this->view->pager = $pager; $this->view->passwords = $passwords; $this->view->controlType = 'defaultpwd'; $this->display(); }
/** * отображаем весь список материалов */ function indexAction() { if (isset($_POST['status'])) { $_SESSION['status'] = $_POST['status']; } if (isset($_POST['id_parent']) and $_POST['id_parent'] > 0) { $limit = 1000; } else { // get limit // всего в каталоге $_total_gallery = dbh::gallery_get_total_count(); $limit = pager::pager_limit($_total_gallery, ADMIN_GALLERY_AT_PAGE); } // строим запрос $_sql = 'SELECT * FROM ' . $this->tablename . ' where id>0 ' . general::get_status_for_filter($this->tablename) . ' ' . general::get_for_filter($this->tablename, 'id_parent') . ' order by sort limit ' . $limit; // выполняем запрос + при необходимости выводим сам запрос $result = mysql::query($_sql, 0); // выбираем фотоальбомы $_sql = 'SELECT * FROM gallery_grupa where status=1 and id_parent=0 order by pole'; $gallery_grupa = mysql::query($_sql, 0); return system::show_tpl(array('result' => $result, 'msg' => $this->msg, '_status' => isset($_POST['status']) ? $_POST['status'] : 2, 'gallery_grupa' => $gallery_grupa, 'tpl_folder' => $this->tpl_folder, '_total_gallery' => $_total_gallery), $this->tpl_folder . '/index.php'); }
/** * Link cases to a test task. * * @param int $taskID * @access public * @return void */ public function linkCase($taskID, $param = 'all', $recTotal = 0, $recPerPage = 20, $pageID = 1) { if (!empty($_POST)) { $this->testtask->linkCase($taskID); $this->locate(inlink('cases', "taskID={$taskID}")); } /* Save session. */ $this->session->set('caseList', $this->app->getURI(true)); /* Get task and product id. */ $task = $this->testtask->getById($taskID); $productID = $this->product->saveState($task->product, $this->products); /* Load pager. */ $this->app->loadClass('pager', $static = true); $pager = pager::init($recTotal, $recPerPage, $pageID); /* Build the search form. */ $this->loadModel('testcase'); $this->config->testcase->search['params']['product']['values'] = array($productID => $this->products[$productID], 'all' => $this->lang->testcase->allProduct); $this->config->testcase->search['params']['module']['values'] = $this->loadModel('tree')->getOptionMenu($productID, $viewType = 'case'); $this->config->testcase->search['actionURL'] = inlink('linkcase', "taskID={$taskID}"); $this->view->searchForm = $this->fetch('search', 'buildForm', $this->config->testcase->search); /* Save session. */ $this->testtask->setMenu($this->products, $productID); $this->view->header['title'] = $this->products[$productID] . $this->lang->colon . $this->lang->testtask->linkCase; $this->view->position[] = html::a($this->createLink('testtask', 'browse', "productID={$productID}"), $this->products[$productID]); $this->view->position[] = $this->lang->testtask->linkCase; /* Get cases. */ if ($this->session->testcaseQuery == false) { $this->session->set('testcaseQuery', ' 1 = 1'); } $query = str_replace("`product` = 'all'", '1', $this->session->testcaseQuery); // If search all product, replace product = all to 1=1 $linkedCases = $this->dao->select('`case`')->from(TABLE_TESTRUN)->where('task')->eq($taskID)->fetchPairs('case'); if ($param == 'all') { $cases = $this->dao->select('*')->from(TABLE_CASE)->where($query)->andWhere('product')->eq($productID)->andWhere('id')->notIN($linkedCases)->andWhere('deleted')->eq(0)->orderBy('id desc')->page($pager)->fetchAll(); } if ($param == 'bystory') { $stories = $this->dao->select('stories')->from(TABLE_BUILD)->where('id')->eq($task->build)->fetch('stories'); $cases = $this->dao->select('*')->from(TABLE_CASE)->where($query)->andWhere('product')->eq($productID)->beginIF($linkedCases)->andWhere('id')->notIN($linkedCases)->fi()->andWhere('story')->in($stories)->andWhere('deleted')->eq(0)->orderBy('id desc')->page($pager)->fetchAll(); } if ($param == 'bybug') { $bugs = $this->dao->select('bugs')->from(TABLE_BUILD)->where('id')->eq($task->build)->fetch('bugs'); $cases = $this->dao->select('*')->from(TABLE_CASE)->where($query)->andWhere('product')->eq($productID)->beginIF($linkedCases)->andWhere('id')->notIN($linkedCases)->fi()->andWhere('fromBug')->in($bugs)->andWhere('deleted')->eq(0)->orderBy('id desc')->page($pager)->fetchAll(); } $this->view->users = $this->loadModel('user')->getPairs('noletter'); $this->view->cases = $cases; $this->view->taskID = $taskID; $this->view->pager = $pager; $this->display(); }
public function __construct($env, $nb_elements, $nb_per_page = 10, $nb_pages_per_group = 10) { parent::__construct($env, $nb_elements, $nb_per_page, $nb_pages_per_group); $this->html_prev = '« ' . __('c_c_previous_f'); $this->html_next = __('c_c_next_f') . ' »'; }
?> href="<?php echo isset($_GET['id']) ? general::link('filter/id/' . $_GET['id'] . '/type_sort/2') : general::link('filter/type_sort/2'); ?> ">Я>А</a> </div> </div><!-- .srt_block--> <div class="tovar_list_3"> <?php foreach ($result as $obj) { ?> <?php echo system::show_tpl(array('obj' => $obj, 'level' => ''), '/frontend/catalog/list_index.php'); ?> <?php } ?> </div><!-- .tovar_list_3--> <?php // pager if (isset($_GET['id'])) { echo filter::get_count() > CATALOG_AT_PAGE ? pager::pager_J("filter/id/" . $_GET['id'], CATALOG_AT_PAGE, filter::get_count(), intval($_GET['page'])) : ''; } else { echo filter::get_count() > CATALOG_AT_PAGE ? pager::pager_J("filter", CATALOG_AT_PAGE, filter::get_count(), intval($_GET['page'])) : ''; }
/** * Product dynamic. * * @param string $type * @param string $orderBy * @param int $recTotal * @param int $recPerPage * @param int $pageID * @access public * @return void */ public function dynamic($productID = 0, $type = 'today', $param = '', $orderBy = 'date_desc', $recTotal = 0, $recPerPage = 20, $pageID = 1) { /* Save session. */ $uri = $this->app->getURI(true); $this->session->set('productList', $uri); $this->session->set('productPlanList', $uri); $this->session->set('releaseList', $uri); $this->session->set('storyList', $uri); $this->session->set('projectList', $uri); $this->session->set('taskList', $uri); $this->session->set('buildList', $uri); $this->session->set('bugList', $uri); $this->session->set('caseList', $uri); $this->session->set('testtaskList', $uri); $this->product->setMenu($this->products, $productID); /* Append id for secend sort. */ $sort = $this->loadModel('common')->appendOrder($orderBy); /* Set the pager. */ $this->app->loadClass('pager', $static = true); $pager = pager::init($recTotal, $recPerPage, $pageID); /* Set the user and type. */ $account = $type == 'account' ? $param : 'all'; $period = $type == 'account' ? 'all' : $type; /* The header and position. */ $this->view->title = $this->products[$productID] . $this->lang->colon . $this->lang->product->dynamic; $this->view->position[] = html::a($this->createLink($this->moduleName, 'browse'), $this->products[$productID]); $this->view->position[] = $this->lang->product->dynamic; /* Assign. */ $this->view->productID = $productID; $this->view->type = $type; $this->view->users = $this->loadModel('user')->getPairs('nodeleted|noletter'); $this->view->account = $account; $this->view->orderBy = $orderBy; $this->view->pager = $pager; $this->view->param = $param; $this->view->actions = $this->loadModel('action')->getDynamic($account, $period, $sort, $pager, $productID); $this->display(); }
/** * User dynamic. * * @param string $period * @param string $account * @param string $orderBy * @param int $recTotal * @param int $recPerPage * @param int $pageID * @access public * @return void */ public function dynamic($period = 'today', $account = '', $orderBy = 'date_desc', $recTotal = 0, $recPerPage = 20, $pageID = 1) { /* set menus. */ $this->lang->set('menugroup.user', 'company'); $this->view->userList = $this->user->setUserList($this->user->getPairs('noempty|noclosed|nodeleted'), $account); /* Save session. */ $uri = $this->app->getURI(true); $this->session->set('productList', $uri); $this->session->set('productPlanList', $uri); $this->session->set('releaseList', $uri); $this->session->set('storyList', $uri); $this->session->set('projectList', $uri); $this->session->set('taskList', $uri); $this->session->set('buildList', $uri); $this->session->set('bugList', $uri); $this->session->set('caseList', $uri); $this->session->set('testtaskList', $uri); /* Set the pager. */ $this->app->loadClass('pager', $static = true); $pager = pager::init($recTotal, $recPerPage, $pageID); $this->view->orderBy = $orderBy; $this->view->pager = $pager; $this->view->title = $this->lang->user->common . $this->lang->colon . $this->lang->user->dynamic; $this->view->position[] = $this->lang->user->dynamic; /* Assign. */ $this->view->period = $period; $this->view->users = $this->loadModel('user')->getPairs('nodeleted|noletter'); $this->view->account = $account; $this->view->user = $this->dao->findByAccount($account)->from(TABLE_USER)->fetch(); $this->view->actions = $this->loadModel('action')->getDynamic($account, $period, $orderBy, $pager); $this->display(); }
if ($curpage != $pages && $pages != 0) { $page_list .= "<a href=\"" . $_SERVER['PHP_SELF'] . "?p=8&page=" . $pages . "\" title=\"Trang cuối\"> >> </a>"; } $page_list .= "</td>\n"; return $page_list; } } ?> <?php // kết nối CSDL require 'db.php'; //$ketnoi_maychu = ketnoi_MC(); //chon_CSDL($ketnoi_maychu); $p = new pager(); $limit = 20; $start = $p->findStart($limit); $count = mysql_num_rows(mysql_query("SELECT*FROM gioi_thieu")); $pages = $p->findPages($count, $limit); $result = mysql_query("SELECT * FROM gioi_thieu ORDER BY id DESC limit {$start},{$limit}"); // $result=mysql_query("SELECT * FROM danh_muc_sp ORDER BY masp DESC"); if (mysql_num_rows($result) != 0) { echo "<h2 align='div'>Thông Tin Người Dùng </h2>"; echo " <table border='1' align='div'>"; echo "<tr bgcolor='orange'>"; echo "<td >STT</td>"; echo "<td >Tiêu đề</td>"; echo "<td >Hình ảnh</td>"; echo "<td >Xóa</td>"; echo "<td >Sữa</td>";
public function test_twelth_of_twelve_pages() { $first = new pager(100, 1200, 12); $actual = $first->pages(); $expected = array(1, 'skip', 6, 7, 8, 9, 10, 11, 12); $this->assertEquals($expected, $actual); }
<a class="addthis_button_preferred_2"></a> <a class="addthis_button_preferred_3"></a> <a class="addthis_button_preferred_4"></a> <a class="addthis_button_compact"></a> <a class="addthis_counter addthis_bubble_style"></a> </div> <script type="text/javascript">var addthis_config = {"data_track_clickback":true};</script> <script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#pubid=ra-4ddc86a40e0ffd66"></script></div> </div> <div class="sanpham" align="center"> <?php include_once "phan_trang.php"; require 'db.php'; $p = new pager(); $limit = 12; $start = $p->findStart($limit); $count = mysql_num_rows(mysql_query("SELECT*FROM du_an")); $pages = $p->findPages($count, $limit); $id = $_REQUEST["id"]; $result = mysql_query("SELECT * FROM du_an where id<>{$id} ORDER BY id DESC limit {$start},{$limit}"); // hiển thị DL if (mysql_num_rows($result) != 0) { echo " <table width='100%' border='0'>"; $stt = 0; while ($row = mysql_fetch_object($result)) { $id = $row->id; $tieude = $row->tieude; $url = khongdau($tieude); // $ngay=$row->ngay;
/** * Browse cases. * * @param int $productID * @param string $browseType * @param int $param * @param string $orderBy * @param int $recTotal * @param int $recPerPage * @param int $pageID * @access public * @return void */ public function browse($productID = 0, $browseType = 'all', $param = 0, $orderBy = 'id_desc', $recTotal = 0, $recPerPage = 20, $pageID = 1) { /* Set browseType, productID, moduleID and queryID. */ $browseType = strtolower($browseType); $productID = $this->product->saveState($productID, $this->products); $moduleID = $browseType == 'bymodule' ? (int) $param : 0; $queryID = $browseType == 'bysearch' ? (int) $param : 0; /* Set menu, save session. */ $this->testcase->setMenu($this->products, $productID); $this->session->set('caseList', $this->app->getURI(true)); $this->session->set('productID', $productID); $this->session->set('moduleID', $moduleID); $this->session->set('browseType', $browseType); $this->session->set('orderBy', $orderBy); /* Load lang. */ $this->app->loadLang('testtask'); /* Load pager. */ $this->app->loadClass('pager', $static = true); $pager = pager::init($recTotal, $recPerPage, $pageID); $sort = $this->loadModel('common')->appendOrder($orderBy); /* By module or all cases. */ if ($browseType == 'bymodule' or $browseType == 'all') { $childModuleIds = $this->tree->getAllChildId($moduleID); $this->view->cases = $this->testcase->getModuleCases($productID, $childModuleIds, $sort, $pager); } elseif ($browseType == 'needconfirm') { $this->view->cases = $this->dao->select('t1.*, t2.title AS storyTitle')->from(TABLE_CASE)->alias('t1')->leftJoin(TABLE_STORY)->alias('t2')->on('t1.story = t2.id')->where("t2.status = 'active'")->andWhere('t1.deleted')->eq(0)->andWhere('t2.version > t1.storyVersion')->orderBy($sort)->page($pager)->fetchAll(); } elseif ($browseType == 'bysearch') { if ($queryID) { $query = $this->loadModel('search')->getQuery($queryID); if ($query) { $this->session->set('testcaseQuery', $query->sql); $this->session->set('testcaseForm', $query->form); } else { $this->session->set('testcaseQuery', ' 1 = 1'); } } else { if ($this->session->testcaseQuery == false) { $this->session->set('testcaseQuery', ' 1 = 1'); } } $queryProductID = $productID; $allProduct = "`product` = 'all'"; $caseQuery = '(' . $this->session->testcaseQuery; if (strpos($this->session->testcaseQuery, $allProduct) !== false) { $products = array_keys($this->loadModel('product')->getPrivProducts()); $caseQuery = str_replace($allProduct, '1', $caseQuery); $caseQuery = $caseQuery . ' AND `product`' . helper::dbIN($products); $queryProductID = 'all'; } $caseQuery .= ')'; $this->view->cases = $this->dao->select('*')->from(TABLE_CASE)->where($caseQuery)->beginIF($queryProductID != 'all')->andWhere('product')->eq($productID)->fi()->andWhere('deleted')->eq(0)->orderBy($sort)->page($pager)->fetchAll(); } /* save session .*/ $this->loadModel('common')->saveQueryCondition($this->dao->get(), 'testcase', $browseType != 'bysearch' ? false : true); /* Build the search form. */ $this->config->testcase->search['params']['product']['values'] = array($productID => $this->products[$productID], 'all' => $this->lang->testcase->allProduct); $this->config->testcase->search['params']['module']['values'] = $this->loadModel('tree')->getOptionMenu($productID, $viewType = 'case'); $this->config->testcase->search['actionURL'] = $this->createLink('testcase', 'browse', "productID={$productID}&browseType=bySearch&queryID=myQueryID"); $this->config->testcase->search['queryID'] = $queryID; $this->loadModel('search')->setSearchParams($this->config->testcase->search); /* Assign. */ $this->view->title = $this->products[$productID] . $this->lang->colon . $this->lang->testcase->common; $this->view->position[] = html::a($this->createLink('testcase', 'browse', "productID={$productID}"), $this->products[$productID]); $this->view->position[] = $this->lang->testcase->common; $this->view->productID = $productID; $this->view->productName = $this->products[$productID]; $this->view->moduleTree = $this->tree->getTreeMenu($productID, $viewType = 'case', $startModuleID = 0, array('treeModel', 'createCaseLink')); $this->view->moduleID = $moduleID; $this->view->pager = $pager; $this->view->users = $this->user->getPairs('noletter'); $this->view->orderBy = $orderBy; $this->view->browseType = $browseType; $this->view->param = $param; $this->display(); }
function outputUniidSelectionForm($uniSql, $options) { global $tpl; // settings global $locline, $secondlocationname; $urlparamString = prepareLocSelectionForm($options); sql_temp_table_slave('uniids'); sql_slave('CREATE TEMPORARY TABLE &uniids ENGINE=MEMORY ' . $uniSql); sql_slave('ALTER TABLE &uniids ADD PRIMARY KEY (`uni_id`)'); // locidsite $locidsite = isset($_REQUEST['locidsite']) ? $_REQUEST['locidsite'] : 0; if (!is_numeric($locidsite)) { $locidsite = 0; } $count = sql_value_slave('SELECT COUNT(*) FROM &uniids', 0); $tpl->assign('resultscount', $count); // create page browser $pager = new pager('search.php?' . $urlparamString . '&locidsite={offset}'); $pager->make_from_offset($locidsite, ceil($count / 20), 1); // create locations list $rs = sql_slave('SELECT `gns_locations`.`rc` `rc`, `gns_locations`.`cc1` `cc1`, `gns_locations`.`admtxt1` `admtxt1`, `gns_locations`.`admtxt2` `admtxt2`, `gns_locations`.`admtxt3` `admtxt3`, `gns_locations`.`admtxt4` `admtxt4`, `gns_locations`.`uni` `uni_id`, `gns_locations`.`lon` `lon`, `gns_locations`.`lat` `lat`, `gns_locations`.`full_name` `full_name`, &uniids.`olduni` `olduni` FROM `gns_locations`, &uniids WHERE &uniids.`uni_id`=`gns_locations`.`uni` ORDER BY `gns_locations`.`full_name` ASC LIMIT ' . $locidsite * 20 . ', 20'); $nr = $locidsite * 20 + 1; $locations = ''; while ($r = sql_fetch_array($rs)) { $thislocation = $locline; $locString = ''; if ($r['admtxt1'] != '') { if ($locString != '') { $locString .= ' > '; } $locString .= htmlspecialchars($r['admtxt1'], ENT_COMPAT, 'UTF-8'); } if ($r['admtxt2'] != '') { if ($locString != '') { $locString .= ' > '; } $locString .= htmlspecialchars($r['admtxt2'], ENT_COMPAT, 'UTF-8'); } /* if ($r['admtxt3'] != '') { if ($locString != '') $locString .= ' > '; $locString .= htmlspecialchars($r['admtxt3'], ENT_COMPAT, 'UTF-8'); } */ if ($r['admtxt4'] != '') { if ($locString != '') { $locString .= ' > '; } $locString .= htmlspecialchars($r['admtxt4'], ENT_COMPAT, 'UTF-8'); } $thislocation = mb_ereg_replace('{parentlocations}', $locString, $thislocation); // koordinaten ermitteln $coordString = help_latToDegreeStr($r['lat']) . ' ' . help_lonToDegreeStr($r['lon']); $thislocation = mb_ereg_replace('{coords}', htmlspecialchars($coordString, ENT_COMPAT, 'UTF-8'), $thislocation); if ($r['olduni'] != 0) { // der alte name wurde durch den native-wert ersetzt $thissecloc = $secondlocationname; $r['olduni'] = $r['olduni'] + 0; $rsSecLoc = sql_slave('SELECT full_name FROM gns_locations WHERE uni=' . $r['olduni']); $rSecLoc = sql_fetch_assoc($rsSecLoc); $thissecloc = mb_ereg_replace('{secondlocationname}', htmlspecialchars($rSecLoc['full_name'], ENT_COMPAT, 'UTF-8'), $thissecloc); sql_free_result($rsSecLoc); $thislocation = mb_ereg_replace('{secondlocationname}', $thissecloc, $thislocation); } else { $thislocation = mb_ereg_replace('{secondlocationname}', '', $thislocation); } $thislocation = mb_ereg_replace('{locationname}', htmlspecialchars($r['full_name'], ENT_COMPAT, 'UTF-8'), $thislocation); $thislocation = mb_ereg_replace('{urlparams}', $urlparamString . '&locid={locid}', $thislocation); $thislocation = mb_ereg_replace('{locid}', urlencode($r['uni_id']), $thislocation); $thislocation = mb_ereg_replace('{nr}', $nr, $thislocation); $nr++; $locations .= $thislocation . "\n"; } sql_free_result($rs); sql_drop_temp_table_slave('uniids'); $tpl->assign('locations', $locations); $tpl->display(); exit; }
/** * Browse bugs. * * @param int $productID * @param string $browseType * @param int $param * @param string $orderBy * @param int $recTotal * @param int $recPerPage * @param int $pageID * @access public * @return void */ public function browse($productID = 0, $branch = '', $browseType = 'unclosed', $param = 0, $orderBy = '', $recTotal = 0, $recPerPage = 20, $pageID = 1) { /* Set browseType, productID, moduleID and queryID. */ $browseType = strtolower($browseType); $productID = $this->product->saveState($productID, $this->products); if ($branch === '') { $branch = $this->session->branch; } $moduleID = $browseType == 'bymodule' ? (int) $param : 0; $queryID = $browseType == 'bysearch' ? (int) $param : 0; /* Set menu and save session. */ $this->bug->setMenu($this->products, $productID, $branch); $this->session->set('bugList', $this->app->getURI(true)); /* Process the order by field. */ if (!$orderBy) { $orderBy = $this->cookie->qaBugOrder ? $this->cookie->qaBugOrder : 'id_desc'; } setcookie('qaBugOrder', $orderBy, $this->config->cookieLife, $this->config->webRoot); /* Append id for secend sort. */ $sort = $this->loadModel('common')->appendOrder($orderBy); /* Load pager. */ $this->app->loadClass('pager', $static = true); if ($this->app->getViewType() == 'mhtml') { $recPerPage = 10; } $pager = pager::init($recTotal, $recPerPage, $pageID); $projects = $this->loadModel('project')->getPairs(); $projects[0] = ''; /* Get bugs. */ $bugs = array(); if ($browseType == 'all') { $bugs = $this->bug->getAllBugs($productID, $branch, $projects, $sort, $pager); } elseif ($browseType == "bymodule") { $childModuleIds = $this->tree->getAllChildId($moduleID); $bugs = $this->bug->getModuleBugs($productID, $branch, $childModuleIds, $projects, $sort, $pager); } elseif ($browseType == 'assigntome') { $bugs = $this->bug->getByAssigntome($productID, $branch, $projects, $sort, $pager); } elseif ($browseType == 'openedbyme') { $bugs = $this->bug->getByOpenedbyme($productID, $branch, $projects, $sort, $pager); } elseif ($browseType == 'resolvedbyme') { $bugs = $this->bug->getByResolvedbyme($productID, $branch, $projects, $sort, $pager); } elseif ($browseType == 'assigntonull') { $bugs = $this->bug->getByAssigntonull($productID, $branch, $projects, $sort, $pager); } elseif ($browseType == 'unconfirmed') { $bugs = $this->bug->getUnconfirmed($productID, $branch, $projects, $sort, $pager); } elseif ($browseType == 'unresolved') { $bugs = $this->bug->getByStatus($productID, $branch, $projects, 'unresolved', $sort, $pager); } elseif ($browseType == 'unclosed') { $bugs = $this->bug->getByStatus($productID, $branch, $projects, 'unclosed', $sort, $pager); } elseif ($browseType == 'toclosed') { $bugs = $this->bug->getByStatus($productID, $branch, $projects, 'toclosed', $sort, $pager); } elseif ($browseType == 'longlifebugs') { $bugs = $this->bug->getByLonglifebugs($productID, $branch, $projects, $sort, $pager); } elseif ($browseType == 'postponedbugs') { $bugs = $this->bug->getByPostponedbugs($productID, $branch, $projects, $sort, $pager); } elseif ($browseType == 'needconfirm') { $bugs = $this->bug->getByNeedconfirm($productID, $branch, $projects, $sort, $pager); } elseif ($browseType == 'bysearch') { $bugs = $this->bug->getBySearch($productID, $queryID, $sort, $pager, $branch); } /* Process the sql, get the conditon partion, save it to session. */ $this->loadModel('common')->saveQueryCondition($this->dao->get(), 'bug', $browseType == 'needconfirm' ? false : true); /* Process bug for check story changed. */ $bugs = $this->loadModel('story')->checkNeedConfirm($bugs); /* Build the search form. */ $this->config->bug->search['actionURL'] = $this->createLink('bug', 'browse', "productID={$productID}&branch={$branch}&browseType=bySearch&queryID=myQueryID"); $this->config->bug->search['queryID'] = $queryID; $this->config->bug->search['params']['product']['values'] = array($productID => $this->products[$productID], 'all' => $this->lang->bug->allProduct); $this->config->bug->search['params']['plan']['values'] = $this->loadModel('productplan')->getPairs($productID); $this->config->bug->search['params']['module']['values'] = $this->tree->getOptionMenu($productID, $viewType = 'bug', $startModuleID = 0); $this->config->bug->search['params']['project']['values'] = $this->product->getProjectPairs($productID); $this->config->bug->search['params']['openedBuild']['values'] = $this->loadModel('build')->getProductBuildPairs($productID, 0, $params = ''); $this->config->bug->search['params']['resolvedBuild']['values'] = $this->config->bug->search['params']['openedBuild']['values']; if ($this->session->currentProductType == 'normal') { unset($this->config->bug->search['fields']['branch']); unset($this->config->bug->search['params']['branch']); } else { $this->config->bug->search['fields']['branch'] = $this->lang->product->branch; $this->config->bug->search['params']['branch']['values'] = array('' => '') + $this->loadModel('branch')->getPairs($productID, 'noempty'); } $this->loadModel('search')->setSearchParams($this->config->bug->search); $users = $this->user->getPairs('noletter'); /* Process the openedBuild and resolvedBuild fields. */ $productIdList = array(); foreach ($bugs as $bug) { $productIdList[$bug->id] = $bug->product; } $builds = $this->loadModel('build')->getProductBuildPairs(array_unique($productIdList), 0, $params = ''); foreach ($bugs as $key => $bug) { $openBuildIdList = explode(',', $bug->openedBuild); $openedBuild = ''; foreach ($openBuildIdList as $buildID) { $openedBuild .= isset($builds[$buildID]) ? $builds[$buildID] : $buildID; $openedBuild .= ','; } $bug->openedBuild = rtrim($openedBuild, ','); $bug->resolvedBuild = isset($builds[$bug->resolvedBuild]) ? $builds[$bug->resolvedBuild] : $bug->resolvedBuild; } $memberPairs = $this->user->getPairs('noletter|nodeleted'); $title = $this->products[$productID] . $this->lang->colon . $this->lang->bug->common; $position[] = html::a($this->createLink('bug', 'browse', "productID={$productID}"), $this->products[$productID]); $position[] = $this->lang->bug->common; $this->view->title = $title; $this->view->position = $position; $this->view->productID = $productID; $this->view->productName = $this->products[$productID]; $this->view->builds = $this->loadModel('build')->getProductBuildPairs($productID); $this->view->moduleTree = $this->tree->getTreeMenu($productID, $viewType = 'bug', $startModuleID = 0, array('treeModel', 'createBugLink'), '', $branch); $this->view->browseType = $browseType; $this->view->bugs = $bugs; $this->view->users = $users; $this->view->pager = $pager; $this->view->param = $param; $this->view->orderBy = $orderBy; $this->view->moduleID = $moduleID; $this->view->memberPairs = $memberPairs; $this->view->branch = $branch; $this->view->branches = $this->loadModel('branch')->getPairs($productID); $this->display(); }
/** * My dynamic. * * @param string $type * @param string $orderBy * @param int $recTotal * @param int $recPerPage * @param int $pageID * @access public * @return void */ public function dynamic($type = 'today', $orderBy = 'date_desc', $recTotal = 0, $recPerPage = 20, $pageID = 1) { /* Save session. */ $uri = $this->app->getURI(true); $this->session->set('productList', $uri); $this->session->set('productPlanList', $uri); $this->session->set('releaseList', $uri); $this->session->set('storyList', $uri); $this->session->set('projectList', $uri); $this->session->set('taskList', $uri); $this->session->set('buildList', $uri); $this->session->set('bugList', $uri); $this->session->set('caseList', $uri); $this->session->set('testtaskList', $uri); /* Set the pager. */ $this->app->loadClass('pager', $static = true); $pager = pager::init($recTotal, $recPerPage, $pageID); /* Append id for secend sort. */ $sort = $this->loadModel('common')->appendOrder($orderBy); /* The header and position. */ $this->view->title = $this->lang->my->common . $this->lang->colon . $this->lang->my->dynamic; $this->view->position[] = $this->lang->my->dynamic; /* Assign. */ $this->view->type = $type; $this->view->recTotal = $recTotal; $this->view->recPerPage = $recPerPage; $this->view->pageID = $pageID; $this->view->orderBy = $orderBy; $this->view->pager = $pager; $this->view->actions = $this->loadModel('action')->getDynamic($this->app->user->account, $type, $sort, $pager); $this->display(); }
echo $em->success; } ?> <table width="522" border="1" cellspacing="0"> <tr> <td width="173" align="center"><strong>Full name </strong></td> <td width="181" align="center"><strong> <label>Email Address </label> </strong></td> <td width="154" align="center"><strong>Actions</strong></td> </tr> <?php include "library/config.php"; include "library/opendb.php"; $sql = "SELECT * FROM subscribers where 1"; $pager = new pager($sql, 'page', 15); while ($row = mysql_fetch_array($pager->result)) { $pager->sno++; ?> <tr> <td><?php echo $row['Title'] . " " . $row['first_name'] . " " . $row['last_name']; ?> </td> <td><?php echo $row['email_address']; ?> </td> <td><a href="journal_article_update.php"> <img src="img/b_edit.png" alt="edit" width="16" height="16" border="0" /></a> <a href="<?php echo $_SERVER['PHP_SELF'];
/** * Project dynamic. * * @param string $type * @param string $orderBy * @param int $recTotal * @param int $recPerPage * @param int $pageID * @access public * @return void */ public function dynamic($projectID = 0, $type = 'today', $param = '', $orderBy = 'date_desc', $recTotal = 0, $recPerPage = 20, $pageID = 1) { /* Save session. */ $uri = $this->app->getURI(true); $this->session->set('productList', $uri); $this->session->set('productPlanList', $uri); $this->session->set('releaseList', $uri); $this->session->set('storyList', $uri); $this->session->set('projectList', $uri); $this->session->set('taskList', $uri); $this->session->set('buildList', $uri); $this->session->set('bugList', $uri); $this->session->set('caseList', $uri); $this->session->set('testtaskList', $uri); /* use first project if projectID does not exist. */ if (!isset($this->projects[$projectID])) { $projectID = key($this->projects); } /* Append id for secend sort. */ $sort = $this->loadModel('common')->appendOrder($orderBy); /* Set the menu. If the projectID = 0, use the indexMenu instead. */ $this->project->setMenu($this->projects, $projectID); if ($projectID == 0) { $this->projects = array('0' => $this->lang->project->selectProject) + $this->projects; unset($this->lang->project->menu); $this->lang->project->menu = $this->lang->project->indexMenu; $this->lang->project->menu->list = $this->project->select($this->projects, 0, 'project', 'dynamic'); } /* Set the pager. */ $this->app->loadClass('pager', $static = true); $pager = pager::init($recTotal, $recPerPage, $pageID); /* Set the user and type. */ $account = $type == 'account' ? $param : 'all'; $period = $type == 'account' ? 'all' : $type; /* The header and position. */ $project = $this->project->getByID($projectID); $this->view->title = $project->name . $this->lang->colon . $this->lang->project->dynamic; $this->view->position[] = html::a($this->createLink('project', 'browse', "projectID={$projectID}"), $project->name); $this->view->position[] = $this->lang->project->dynamic; /* Assign. */ $this->view->projectID = $projectID; $this->view->type = $type; $this->view->users = $this->loadModel('user')->getPairs('nodeleted|noletter'); $this->view->account = $account; $this->view->orderBy = $orderBy; $this->view->pager = $pager; $this->view->param = $param; $this->view->actions = $this->loadModel('action')->getDynamic($account, $period, $sort, $pager, 'all', $projectID); $this->display(); }
WHERE catalog.brand=brand.id and catalog.status=1 and brand.status=1 ' . $_filter . ' ORDER BY ' . $_sort . ' LIMIT ' . $limit; // выполняем запрос + при необходимости выводим сам запрос $result = mysql::query($_sql, 0); // наименование бренда $_brand = ___findpole('select pole from brand where id=' . $id, 'pole'); if ($result) { $_str .= system::show_tpl(array('result' => $result, '_brand' => $_brand), 'frontend/catalog/brand/list.php'); } else { $_str .= 'У данного бренда товары отсутствуют.'; } } else { // выводим все бренды // get limit $limit = pager::pager_limit(brand::get_count(), mysql::query_findpole('select zna from config where id=47', 'zna')); // строим запрос $_sql = 'SELECT brand.*, count(catalog.id) as count FROM brand Left Outer Join catalog ON brand.id=catalog.brand WHERE brand.id>0 and brand.status=1 GROUP BY brand.id order by brand.sort LIMIT ' . $limit; // выполняем запрос + при необходимости выводим сам запрос $result = mysql::query($_sql, 0); $_str .= system::show_tpl(array('result' => $result), 'frontend/catalog/brand/all_brands.php');