public function photos() { $pid = I('get.pid', 1); $catamodel = M('catagory'); $catalist = $catamodel->field('id,name')->select(); $projmodel = M('project'); $preview = $projmodel->where(array('id' => $pid))->getField('preview'); $projphotomodel = M('projectphoto'); $projphotomodelmap = array('pid' => $pid); $count = $projphotomodel->where($projphotomodelmap)->count(); $p = new \Org\Util\Page($count, 9); $p->setConfig('prev', '<img src="' . SITE_PATH . 'Public/Img/GC/prev_button.png"></img>'); $p->setConfig('next', '<img src="' . SITE_PATH . 'Public/Img/GC/next_button.png"></img>'); $p->setConfig('last', 'the last Page'); $p->setConfig('first', 'the first Page'); $p->setConfig('theme', '%upPage% %first% %prePage% %linkPage% %downPage% %nextPage% %end%'); $list = $projphotomodel->where($projphotomodelmap)->order('`id` DESC')->limit($p->firstRow . "," . $p->listRows)->select(); $show = $p->show(); $this->assign("show", $show); $this->assign('catalist', $catalist); $this->assign('photolist', $list); $this->assign('preview', $preview); $this->assign('pid', $pid); $this->assign('refurl', 'Public/Img/GC/banners/banner_clientlist.png'); $this->display('index'); }
public function index() { //列出产品、分页 $cid = intval(I('get.cid', 0)); $pagecid = ''; //分页用 $cond = ''; //新闻查询条件 $cate_id = 0; if ($cid) { $pagecid = '/cid/' . $cid; $cond = 'cid=' . $cid; $artcate = M('artcates')->where("cid=%d", $cid)->find(); if ($artcate['pid'] != '0') { $cate_id = $artcate['pid']; } } $this->assign('cid', $cid); $this->assign('cate_id', $cate_id); $totalRows = M('articles')->where($cond)->count(); import("Org.Util.Page"); $listcount = M('setting')->find(); $Page = new \Org\Util\Page($totalRows, $listcount['list_news'], '', 'article/index' . $pagecid); //分页语种自定义 $Page->setConfig('header', ''); $Page->setConfig('first', '<<'); $Page->setConfig('last', '>>'); $Page->setConfig('theme', '<ul class="pagination"><li>%header%</li><li>%first%</li><li>%prePage%</li>%linkPage%<li>%nextPage%</li><li>%end%</li></ul>'); $show = $Page->show(); $articles = M('articles')->where($cond)->field("aid,cid,posttime,title,author,content")->order("ordernum,aid")->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('articles', $articles); $this->assign('pageStr', $show); //seo信息 $seo = M('channels')->where("name='article'")->field('title,seotitle,metakeywords,metadesc')->find(); $this->assign('seo', $seo); //location位置信息 if ($cid) { if ($artcate['seotitle']) { $seo['seotitle'] = $artcate['seotitle']; } if ($artcate['metakeywords']) { $seo['metakeywords'] = $artcate['metakeywords']; } if ($artcate['metadesc']) { $seo['metadesc'] = $artcate['metadesc']; } $location = "<li><a href='/article.html'>" . $seo['title'] . "</a></li><li class='active'>" . $artcate['title'] . "</li>"; } else { $location = "<li class='active'>" . $seo['title'] . "</li>"; } $this->assign('location', $location); $this->display('list'); }
public function index() { //列出产品、分页 $Cases = D('cases'); $catetype = 0; $catequery = "protype=all"; $pagecid = ""; if (I('get.protype')) { $cond = intval(I('get.protype')); $this->assign('activetype', $cond); $cond = "protype={$cond}"; $catequery = $cond; $pagecid = "/protype/" . I("get.protype"); } elseif (I('get.areatype')) { $cond = intval(I('get.areatype')); $this->assign('activetype', $cond); $cond = "areatype={$cond}"; $catequery = $cond; $catetype = 1; $pagecid = "/areatype/" . I("get.areatype"); } $this->assign('catequery', $catequery); $this->assign('catetype', $catetype); $totalRows = $Cases->where($cond)->count(); import("Org.Util.Page"); $Page = new \Org\Util\Page($totalRows, 36, "", "cases/index{$pagecid}"); //分页语种自定义 $Page->setConfig('header', ''); $Page->setConfig('first', '<<'); $Page->setConfig('last', '>>'); $Page->setConfig('theme', '<ul class="pagination"><li>%header%</li><li>%first%</li><li>%prePage%</li>%linkPage%<li>%nextPage%</li><li>%end%</li></ul>'); $show = $Page->show(); $cases = $Cases->where($cond)->field("caseid,protype,areatype,posttime,title,picpath")->order('posttime desc,caseid')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('cases', $cases); $this->assign('pageStr', $show); //左侧产品分类 $Procates = D('Procates'); $pars = $Procates->where('pid=0')->order('ordernum,cid')->select(); $this->assign('procates', $pars); //seo信息 $seo = D('channels')->where("name='case'")->field('title,seotitle,metakeywords,metadesc')->find(); $this->assign('seo', $seo); //location位置信息 $location = "<li class='active'><a href='/cases.html'>工程案例</a></li>"; $this->assign('location', $location); $this->display('list', 'utf-8'); }
public function manage() { $cid = intval(I('get.cid')); $keyword = trim(I('get.k')); $orderby = I('get.orderby'); $orderby = empty($orderby) ? "ordernum,id" : $orderby; $orderbystr = ''; $keyword = str_replace("*", "%", $keyword); if (!empty($cid)) { $cond .= "cid={$cid}"; } if (!empty($keyword)) { if ($cond != "") { $cond .= " and "; } $cond .= "(title like '%{$keyword}%' or content like '%{$keyword}%')"; } if (in_array($orderby, array('ordernum,aid', 'posttime', 'hits'))) { $orderbystr = $orderby . ' desc'; } $Articles = D('articles'); $totalRows = $Articles->count(); import("Org.Util.Page"); $Page = new \Org\Util\Page($totalRows, '18'); $Page->setConfig('theme', '<ul class="pagination"><li><a href="javascript:;">%totalRow% %header% %nowPage%/%totalPage% 页</a></li><li> %upPage%</li><li>%downPage%</li><li>%first%</li><li>%prePage%</li>%linkPage%<li>%nextPage%</li><li>%end%</li></ul>'); $show = $Page->show(); $articles = $Articles->where($cond)->order($orderbystr)->limit($Page->firstRow . ',' . $Page->listRows)->select(); $cache_artcates = F('artcates_option'); $artcates = F('artcates'); $this->assign('artcates', $artcates); $this->assign('options', $cache_artcates); $this->assign('articles', $articles); $this->assign('pageStr', $show); $this->assign('cid', $cid); $this->assign('keyword', $keyword); $this->assign('orderby', $orderby); $this->display(); }
public function _select($tname, $map = array(), $order = '', $sort = '', $asc = false, $query = null) { $model = D($tname); if (isset($_REQUEST['_order'])) { $order = $_REQUEST['_order']; } else { $order = !empty($order) ? $order : $model->getPK(); } if (null === $query) { $count = $model->where($map)->count(); } else { $count = $model->count(); } if ($count > 0) { if (!empty($_REQUEST['listRows'])) { $listRows = $_REQUEST['listRows']; cookie($tname . "_listRows", $listRows, 3600); } elseif (cookie($tname . "_listRows")) { $listRows = cookie($tname . "_listRows"); } else { $pageNum = C("PAGENUM"); $listRows = !empty($pageNum) ? $pageNum : 12; } $p = new \Org\Util\Page($count, $listRows); $p->setConfig('prev', '«'); $p->setConfig('next', '»'); $p->setConfig('last', 'the last Page'); $p->setConfig('first', 'the first Page'); $p->setConfig('theme', '%upPage% %first% %prePage% %linkPage% %downPage% %nextPage% %end%'); if (null === $query) { $list = $model->where($map)->order("`" . $order . "` " . $sort)->limit($p->firstRow . "," . $p->listRows)->select(); } else { $query .= " ORDER BY `{$order}` {$sort} LIMIT {$p->firstRow},{$p->listRows}"; $list = $model->query($query); } $show = $p->show(); $this->assign("show", $show); $this->assign('list', $list); $this->assign("listRows", $listRows); $fields = $model->getDbFields(); $this->assign('fields', $fields); } }
public function index() { //列出产品、分页 $cid = intval(I('get.cid', 0)); $pagecid = ""; //分页用 $cond = ''; //产品查询条件 $cate_id = 0; if ($cid) { $cond = "cid={$cid}"; $pagecid = "/cid/{$cid}"; //左侧产品分类 $procate = M('procates')->where($cond)->find(); if ($procate['pid'] != '0') { $cate_id = $procate['pid']; } } $this->assign('cid', $cid); $this->assign('cate_id', $cate_id); $pars = M('procates')->where('pid=0 and ishidden=0')->order('ordernum,cid')->select(); foreach ($pars as &$par) { $par['children'] = array(); $children = M('procates')->where('pid=%d and ishidden=0', $par['cid'])->order('ordernum,cid')->select(); if (!$children) { continue; } foreach ($children as $child) { array_push($par['children'], $child); } } $this->assign('procates', $pars); if ($cid && $procate['pid'] == '0') { $cids = M('procates')->where("pid={$cid}")->field('cid')->select(); if ($cids) { $c_cids = ''; foreach ($cids as $c_cid) { $c_cids .= "','" . $c_cid['cid']; } $cond = "cid in ('" . $cid . $c_cids . "')"; } } $totalRows = M('products')->where($cond)->count(); import("Org.Util.Page"); $listcount = M('setting')->find(); $Page = new \Org\Util\Page($totalRows, $listcount['list_pro'], '', 'product/index' . $pagecid); //分页语种自定义 $Page->setConfig('header', ''); $Page->setConfig('first', '<<'); $Page->setConfig('last', '>>'); $Page->setConfig('theme', '<ul class="pagination"><li>%header%</li><li>%first%</li><li>%prePage%</li>%linkPage%<li>%nextPage%</li><li>%end%</li></ul>'); $show = $Page->show(); $products = M('products')->where($cond)->field('proid,cid,posttime,title,serialnum,picpaths')->order('ordernum,posttime desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); foreach ($products as $k => $product) { $picpaths = explode("\t", $product['picpaths']); foreach ($picpaths as $picpath) { if (!empty($picpath)) { $products[$k]['picpath'] = $picpath; break; } else { $products[$k]['picpath'] = "default.jpg"; } } } $this->assign('products', $products); $this->assign('pageStr', $show); //seo信息 $seo = M('channels')->field('title,seotitle,metakeywords,metadesc')->where("name='product'")->find(); //location位置信息 if ($cid) { if ($procate['seotitle']) { $seo['seotitle'] = $procate['seotitle']; } if ($procate['metakeywords']) { $seo['metakeywords'] = $procate['metakeywords']; } if ($procate['metadesc']) { $seo['metadesc'] = $procate['metadesc']; } $location = "<li><a href='/product.html'>" . $seo['title'] . "</a></li><li class='active'>" . $procate['title'] . "</li>"; } else { $location = "<li class='active'>" . $seo['title'] . "</li>"; } $this->assign('seo', $seo); $this->assign('location', $location); $this->display('list'); }
public function _select($tname, $map = array(), $order = '', $sort = '', $asc = false, $query = null) { $model = D($tname); if (isset($_REQUEST['_order'])) { $order = $_REQUEST['_order']; } else { $order = !empty($order) ? $order : $model->getPK(); } if (null === $query) { $count = $model->where($map)->count(); } else { $count = $model->count(); } if ($count > 0) { if (!empty($_REQUEST['listRows'])) { $listRows = $_REQUEST['listRows']; cookie($tname . "_listRows", $listRows, 3600); } elseif (cookie($tname . "_listRows")) { $listRows = cookie($tname . "_listRows"); } else { $pageNum = C("PAGENUM"); $listRows = !empty($pageNum) ? $pageNum : 12; } $p = new \Org\Util\Page($count, $listRows); $p->setConfig('prev', '«'); $p->setConfig('next', '»'); $p->setConfig('last', 'the last Page'); $p->setConfig('first', 'the first Page'); $p->setConfig('theme', '%upPage% %first% %prePage% %linkPage% %downPage% %nextPage% %end%'); if (null === $query) { $list = $model->where($map)->order("`" . $order . "` " . $sort)->limit($p->firstRow . "," . $p->listRows)->select(); } else { $query .= " ORDER BY `{$order}` {$sort} LIMIT {$p->firstRow},{$p->listRows}"; $list = $model->query($query); } // Special assignments if (false !== strpos($tname, 'member_enquiry_details')) { $db_property = M('property_' . $this->lang); foreach ($list as &$row) { $property_info = $db_property->find($row['property_id']); $row['property'] = $property_info['name']; } } $show = $p->show(); $this->assign("show", $show); $this->assign('list', $list); $this->assign("listRows", $listRows); $fields = $model->getDbFields(); $this->assign('fields', $fields); } }