public function index()
{
$put = I('s');
if (trim($put) == '') {
$this->error('搜索内容不能为空！');
die;
}
$where['biaoti'] = $put;
$where['content'] = $put;
$where['_logic'] = 'OR';
$map['_complex'] = $where;
$map['islock'] = 0;
//复合查询
$count = M('article')->where($map)->count();
import('ORG.Util.Page');
$page = new page($count, 10);
$page->setConfig('theme', '<ul class="pages">%first%%upPage%%linkPage%%downPage%%end%</ul>');
$show = $page->show();
//返回分页信息
$article = M('article')->where($map)->limit($page->firstRow . ',' . $page->listRows)->select();
foreach ($article as $key => $value2) {
$article[$key]["imgs"] = imgs($article[$key]["imgs"]);
}
$this->assign('put', $put);
$this->assign('show', $show);
//分页信息
$this->assign('count', $count);
//数据总数
$this->assign('list', $article);
//数据集
$sidebar1 = M('article')->where('type=0')->order('approval desc')->limit('10')->select();
//赞多到少
$this->assign('approval', $sidebar1);
$this->display('search');
}
public function index()
{
$objAsk = M('ask');
$objUser = M('user');
$word = deep_htmlspecialchars($_GET["word"]);
$this->assign('searchWord', $word);
if ($word == '') {
redirect($_SERVER['HTTP_REFERER']);
}
//如果没有输入关键字 就重定向到上一页面
import('ORG.Util.Page');
//导入分页类
$count = $objAsk->where('INSTR(ask_name, "' . $word . '")>0')->count();
//统计总数
$this->assign('countSearch', $count);
$page = new page($count, 10);
$page->setConfig('theme', '%upPage% %first% %prePage% %linkPage% %downPage%');
$resultList = $objAsk->where('INSTR(ask_name, "' . $word . '")>0')->order('add_time desc')->limit($page->firstRow . ',' . $page->listRows)->select();
foreach ($resultList as $k1 => $v1) {
$resultList[$k1]['username'] = $objUser->where('id=' . $v1['uid'])->getField('username');
}
$resultList = deep_htmlspecialchars_decode($resultList);
$show = $page->show();
$this->assign('resultList', $resultList);
$this->assign('page', $show);
$this->display();
}
public function index()
{
$Feedback = D("Feedback");
$keyword = $_POST['keyword'];
$keywords = $_REQUEST['keywords'];
$uid = intval($_REQUEST['uid']);
if ($keyword) {
$data['content'] = array('like', '%' . $keyword . '%');
} elseif ($keywords) {
$data['content'] = array('like', '%' . safe_b64decode($keywords) . '%');
}
$count = $Feedback->count($data);
import("ORG.Util.Page");
$listRows = 15;
$p = new page($count, $listRows);
$list = $Feedback->findAll($data, '*', 'id desc', $p->firstRow . ',' . $p->listRows);
if ($keyword) {
$p->parameter = 'keywords=' . safe_b64encode($keyword);
}
$page = $p->show();
if ($list !== false) {
$this->assign('page', $page);
$this->assign('list', $list);
$this->assign('allowbat', $this->allowbat);
}
$this->display();
}
public function index()
{
$Link = D("Link");
$keyword = $_POST['keyword'];
$keywords = $_REQUEST['keywords'];
if ($keyword) {
$data['title'] = array('like', '%' . $keyword . '%');
} elseif ($keywords) {
$data['title'] = array('like', '%' . safe_b64decode($keywords) . '%');
}
$count = $Link->count($data);
import("ORG.Util.Page");
$listRows = 15;
$p = new page($count, $listRows);
$list = $Link->findAll($data, '*', 'types desc, orders desc', $p->firstRow . ',' . $p->listRows);
if ($keyword) {
$p->parameter = 'keywords=' . safe_b64encode($keyword);
}
$page = $p->show();
if ($list !== false) {
$this->assign('page', $page);
$this->assign('keyword', $keyword);
$this->assign('list', $list);
$this->assign("linkfolder", __ROOT__ . '/' . C(ATTACHDIR) . '/logo');
$this->assign('allowbat', $this->allowbat);
}
$this->display();
}
/**
* 简历列表
*/
public function resumeList()
{
$db = V('resume');
$db->view = array('user_info' => array('type' => 'inner', 'on' => 'resume.uid=user_info.uid', 'field' => 'name'));
$cond = array();
if (isset($_GET['resume_name'])) {
$cond[] = 'resume_name like "%' . $_GET['resume_name'] . '%"';
}
if (isset($_GET['name'])) {
$cond[] = 'name like "%' . $_GET['name'] . '%"';
}
if (isset($_GET['created'])) {
$cond['created'] = array('gt' => strtotime($_GET['created']), 'lt' => time());
}
if (isset($_GET['updated'])) {
$cond['updated'] = array('gt' => strtotime($_GET['updated']), 'lt' => time());
}
if (isset($_GET['verify'])) {
$cond['verify'] = $_GET['verify'];
}
$nums = $db->where($cond)->count();
$page = new page($nums, 13);
$resumes = $db->where($cond)->findall($page->limit());
$this->assign('resumes', $resumes);
$this->assign('page', $page->show());
$this->display();
}
public function review()
{
$uid = intval($_GET['uid']);
if ($uid == '') {
parent::error404();
}
//分配根据GET传过来的uid用户的信息
$objUser = M('user');
$userMessage = $objUser->where('id=' . $uid)->field('id,username,face,introduce,point,exp')->find();
$userMessage = deep_htmlspecialchars_decode($userMessage);
if ($userMessage == '') {
parent::error404();
}
$this->assign('userMessage', $userMessage);
//分配该用户的评论
$objComment = M('comment');
import('ORG.Util.Page');
//导入分页类
$count = $objComment->where(array('comment_uid' => $uid))->count();
$page = new page($count, 20);
$page->setConfig('theme', '%upPage% %first% %prePage% %linkPage% %downPage%');
$commentList = $objComment->where(array('comment_uid' => $uid))->field('aid,time,comment')->order('time desc')->limit($page->firstRow . ',' . $page->listRows)->select();
foreach ($commentList as $k1 => $v1) {
$commentList[$k1]['url'] = '__APP__/List/detail/id/' . $v1['aid'] . '.html';
}
$commentList = deep_htmlspecialchars_decode($commentList);
$show = $page->show();
$this->assign('page', $show);
$this->assign('commentList', $commentList);
//分配Pagetitle
$this->pageTitle = $userMessage['username'] . '的个人主页_支招网';
$this->display();
}
public function index()
{
$id = intval($_REQUEST['id']);
if ($id > 0) {
$mapc['cid'] = $id;
}
$Product = D("Product");
$count = $Product->count($mapc);
//if($count<=1)$this->error('此类别无产品');
import("ORG.Util.Page");
$listRows = 16;
$p = new page($count, $listRows);
$list = $Product->findAll($mapc, '*', 'id desc', $p->firstRow . ',' . $p->listRows);
//$list=$p->order('pid desc')->limit("$p->firstRow.','.$p->listRows")->findAll();
$page = $p->show();
/**/
//分类
$map['module'] = 1;
//分类
$Category = D('Category')->order("id desc")->where($map)->findall();
$this->assign('titler', '产品中心');
$this->assign('cate', $Category);
$this->assign('Product', $Product);
$this->assign('count', $count);
$this->assign('page', $page);
$this->display();
}
public function index()
{
//$Member=D("Member");
$Member = D("MemberView");
$keyword = $_POST['keyword'];
$keywords = $_REQUEST['keywords'];
if ($keyword) {
$data['username'] = array('like', '%' . $keyword . '%');
} elseif ($keywords) {
$data['username'] = array('like', '%' . safe_b64decode($keywords) . '%');
}
$count = $Member->count($data);
import("ORG.Util.Page");
$listRows = 15;
$p = new page($count, $listRows);
$list = $Member->findAll($data, '*', 'Member.id desc', $p->firstRow . ',' . $p->listRows);
if ($keyword) {
$p->parameter = 'keywords=' . safe_b64encode($keyword);
}
$page = $p->show();
if ($list !== false) {
$this->assign('page', $page);
$this->assign('list', $list);
$this->assign('allowbat', $this->allowbat);
}
$this->display();
}
public function index()
{
$put = I('s');
if (trim($put) == '') {
$this->error('搜索内容不能为空！');
die;
}
$where['title'] = $put;
$where['content'] = $put;
$count = M('Article')->where($where)->count();
import('ORG.Util.Page');
$page = new page($count, 10);
$page->setConfig('theme', '<ul class="pagination"><li>%upPage%</li><li>%downPage%</li><li>%prePage%</li><li>%linkPage%</li><li>%nextPage%</li><li>%end%</li></ul>');
$show = $page->show();
//返回分页信息
$article = M('article')->where($where)->limit($page->firstRow . ',' . $page->listRows)->select();
$this->assign('put', $put);
$this->assign('show', $show);
//分页信息
$this->assign('count', $count);
//数据总数
$this->assign('list', $article);
//数据集
//侧栏的数据分配
$sidebar1 = M('Article')->where("ispush=1 and islock=0")->order('approval desc')->limit('5')->select();
$sidebar2 = M('Article')->where("ispush=1 and islock=0")->order('opposition desc')->limit('5')->select();
$sidebar3 = M('Article')->where("ispush=1 and islock=0")->order('rand()')->limit('5')->select();
//赞多到少
$this->assign('sidebar1', $sidebar1);
//赞少到多
$this->assign('sidebar2', $sidebar2);
//随机5篇
$this->assign('sidebar3', $sidebar3);
$this->display('search');
}
public function index(){
$total = $this->db->totalShop();
$page = new page($total,1);
$data = $this->db->getShop($page->limit());
$this->assign('page',$page->show());
$this->assign('data',$data);
$this->display();
}
/**
* 显示结果
*/
public function word($word)
{
$where = "uuid like '%" . intval($word) . "%'";
$count = $this->where($where)->count();
$page = new page($count, 10, 4, 2);
$union = $this->where($where)->select($page->limit());
return array("union" => $union, "count" => $count, "page" => $page->show());
}
function print_project_foot($project_count, $page_size)
{
require_once 'utils/page.class.php';
$page = new page(array('total' => $project_count, 'perpage' => $page_size));
//echo '<div id="project_page">'.$page->show(7).'</div>';
echo $page->show(7);
//echo project_info_path;
}
public function index()
{
$sortId = intval($_GET['sid']);
if ($sortId == '') {
parent::error404();
}
$sort = intval($_GET['sort']);
if ($sort == '') {
parent::error404();
}
$objAsk = D('AskView');
$where = array('sort_id' => $sortId);
if ($sort == 1) {
$order = 'add_time desc';
} elseif ($sort == 2) {
$order = 'reward desc,add_time desc';
} elseif ($sort == 3) {
$order = 'comment_num desc,add_time desc';
}
import('ORG.Util.Page');
//导入分页类
$count = $objAsk->where($where)->count();
//统计总数
$page = new page($count, 12);
$page->setConfig('theme', '%upPage% %first% %prePage% %linkPage% %downPage%');
$askList = $objAsk->where($where)->field('id,ask_name,add_time,comment_num,reward,solve,username,sort_name')->order($order)->limit($page->firstRow . ',' . $page->listRows)->select();
$askList = deep_htmlspecialchars_decode($askList);
$show = $page->show();
$this->assign('askList', $askList);
$this->assign('page', $show);
//分配pageTitle
if ($sortId == 1) {
$pageTitle = '生活_支招网';
} else {
if ($sortId == 2) {
$pageTitle = '情感_支招网';
} else {
if ($sortId == 3) {
$pageTitle = '健康_支招网';
} else {
if ($sortId == 4) {
$pageTitle = '职场_支招网';
} else {
if ($sortId == 5) {
$pageTitle = '公益_支招网';
}
}
}
}
}
$this->assign('pageTitle', $pageTitle);
//获取列表广告
$this->listBanner = $this->getListBanner();
$this->display();
}
function showPage()
{
$curpage = getcurpage();
// берём контроллер для текущей страницы
include __corePath . "controllers/{$curpage}.php";
$page = new page($curpage, $this->db, $this->config);
$page->prepare();
$page->render();
echo $page->show();
//показываем страницу
}
public function lists_select($where = "")
{
if ($where) {
$page = new page($this->where($where)->count(), 10, 5, 1);
$video = $this->field("vid,cnname,uploadtime,py_video.cid,username,cntitle,entitle,pid,uuid")->where($where)->order(array("uploadtime" => "desc"))->select($page->limit());
} else {
$page = new page($this->count(), 10, 5, 1);
$video = $this->field("vid,cnname,uploadtime,py_video.cid,username,cntitle,entitle,pid,uuid")->order(array("uploadtime" => "desc"))->select($page->limit());
}
return array($video, $page->show());
}
public function check()
{
$db = M('wish');
$page = new page($db->count(), 5, 4, 2);
$this->assign('page', $page->show());
$wish = $db->select($page->limit());
foreach ($wish as $k => $v) {
$wish[$k]['content'] = $this->change_face($v['content']);
}
$this->assign('wish', $wish);
$this->display();
}
public function index()
{
header('Content-Type:text/html;charset=utf-8');
load('extend');
// 导入扩展函数(对中文字符串的截取)
import("ORG.Util.Page");
// 导入分页类
$l = M('link');
$count = $l->count();
$page = new Page($count, 20);
$show = $page->show();
if (!isset($_GET['search'])) {
$list = $l->order('l_time desc')->limit($page->firstRow . ',' . $page->listRows)->select();
} else {
//按留言标题、留言姓名
$methodone = isset($_GET['search_bzb']) ? $_GET['search_bzb'] : '';
$bzb = $_GET['bzb'];
if (!empty($bzb)) {
$sql = $methodone . ' like "%' . $bzb . '%"';
}
//按添加时间排序
$methodtwo = $_GET['search_tdb'];
$px = $_GET['order'];
$order = $methodtwo . ' ' . $px;
//筛选
if (isset($_GET['sh'])) {
if ($_GET['sh'] != 'status') {
$ha = 'l_status = ' . $_GET['sh'];
}
}
//查找记录后,更新显示条数
$count = $l->where($sql)->having($ha)->count();
$page = new page($count, 20);
$show = $page->show();
$list = $l->where($sql)->having($ha)->order($order)->limit($page->firstRow . ',' . $page->listRows)->select();
foreach ($list as $key => $val) {
$val[$methodone] = str_replace($bzb, '<b>' . $bzb . '</b>', $val[$methodone]);
$list[$key][$methodone] = $val[$methodone];
}
}
$time = time();
foreach ($list as $key => $val) {
//判断过期链接
if ($time >= $val['l_overtime']) {
$data['l_status'] = 2;
$id = $val['id'];
$l->where('id=' . $id)->save($data);
}
}
$this->assign(array('list' => $list, 'page' => $show));
$this->display();
}
public function TeacherList($pagefirst, $pagesize)
{
$num = $this->count();
import('ORG.Util.Page');
$page = new page($num, $pagesize);
$this->page = $page->show();
$this->list = $this->query("SELECT tech_id, tech_name, tech_status FROM teacher LIMIT {$pagefirst},{$pagesize}");
if (!empty($this->list)) {
return $this->list;
} else {
return false;
}
}
public function studentList($pagefirst, $pagesize)
{
$num = $this->count();
import('ORG.Util.Page');
$page = new page($num, $pagesize);
$this->page = $page->show();
$this->list = $this->query("SELECT uid, name, sex, xueyuan, zhuanye, class, grade, year, type, email, long_num FROM student LIMIT {$pagefirst},{$pagesize}");
if (!empty($this->list)) {
return $this->list;
} else {
return false;
}
}
public function lessonList($pagefirst, $pagesize)
{
$num = $this->count();
import('ORG.Util.Page');
$page = new page($num, $pagesize);
$this->page = $page->show();
$this->list = $this->query("SELECT lesson.*, xueyuan.* FROM lesson LEFT JOIN xueyuan ON lesson.xy_id = xueyuan.xy_id LIMIT {$pagefirst},{$pagesize}");
if (!empty($this->list)) {
return $this->list;
} else {
return false;
}
}
public function index()
{
import('ORG.Util.Page');
// 导入分页类
$aCounty = (int) getRequest('county');
$aWhere = $this->model->getConditionArray();
$aTown = $this->model->getTownName($aCounty);
//查询4家公司信息（瀑布流分页）
$count = D('Company')->where($aWhere)->count();
$Page = new page($count, 2);
$Page->setConfig('theme', " %upPage% %downPage% %first% %prePage% %linkPage% %nextPage% %end%");
$show = $Page->show();
//$aCompany = D('Company')->where($aWhere)->order('ord DESC')->limit($Page->firstRow.','.$Page->listRows)->select();
if ($_GET['caseord']) {
unset($_GET['caseord']);
$aCompany = D('Company')->where($aWhere)->order('reserve_count DESC,ord DESC')->limit($Page->firstRow . ',' . $Page->listRows)->select();
} else {
$aCompany = D('Company')->where($aWhere)->order('ord DESC')->limit($Page->firstRow . ',' . $Page->listRows)->select();
}
//每家公司查询5条记录
foreach ($aCompany as $key => $aValue) {
$case = $this->model->getTop($aValue['id'], 5);
$aCompany[$key]['case'] = $case;
}
//dump($aCompany);die;
$comtype = getRequest('comtype');
$aDistrict = D("District")->getFieldById(9);
unset($_GET['_URL_']);
$Acondition = $_GET;
$Bcondition = $_GET;
$Ccondition = $_GET;
unset($Acondition['comtype']);
unset($Acondition['p']);
$comtypeurl = U("", $Acondition);
unset($Bcondition['county']);
unset($Bcondition['p']);
$countyurl = U("", $Bcondition);
unset($Ccondition['town']);
unset($Ccondition['p']);
$townurl = U("", $Ccondition);
$this->assign('page', $show);
$this->assign('comtypeurl', $comtypeurl);
$this->assign('countyurl', $countyurl);
$this->assign('townurl', $townurl);
$this->assign('town', $aTown);
$this->assign('comtype', $comtype);
$this->assign('district', $aDistrict);
$this->assign('company', $aCompany);
$this->assign('county', $aCounty);
$this->display();
}
public function index()
{
//导入Page.class.php文件
import("ORG.Util.Page");
//实例化分页类
$totalRow = M("bbsinfo")->count();
$page = new page($totalRow, 5);
//获得当前页面显示的记录
$result = M("bbsinfo")->limit($page->firstRow, $page->listRows)->select();
$this->assign("result", $result);
$this->assign("pageList", $page->show());
//分页栏
$this->display();
}
public function index()
{
$Feedback = D("Feedback");
$count = $Feedback->count('ischecked=1');
import("ORG.Util.Page");
$listRows = 15;
$p = new page($count, $listRows);
$list = $Feedback->findAll('ischecked=1', '*', 'id desc', $p->firstRow . ',' . $p->listRows);
$page = $p->show();
$this->assign('titler', '留言反馈');
$this->assign('list', $list);
$this->assign('page', $page);
$this->display();
}
function index()
{
$shop_cate_mod = D('shop_cate');
import("ORG.Util.Page");
$count = $shop_cate_mod->order('sort_order')->count();
$p = new page($count, 20);
$list = $shop_cate_mod->limit($p->firstRow . ',' . $p->listRows)->order('sort_order')->select();
$key = 1;
foreach ($list as $k => $val) {
$list[$k]['key'] = ++$p->firstRow;
}
$this->assign('list', $list);
$this->assign('page', $p->show());
$this->display();
}
public function index()
{
$Job = D("Job");
$count = $Job->count();
import("ORG.Util.Page");
$listRows = 5;
$p = new page($count, $listRows);
$list = $Job->findAll('', '*', 'id desc', $p->firstRow . ',' . $p->listRows);
//$list=$p->order('pid desc')->limit("$p->firstRow.','.$p->listRows")->findAll();
$page = $p->show();
$this->assign('titler', '人才招聘');
$this->assign('list', $list);
$this->assign('page', $page);
$this->display();
}
public function index()
{
$Scroll = D("Scroll");
$count = $Scroll->count();
import("ORG.Util.Page");
$listRows = 15;
$p = new page($count, $listRows);
$list = $Scroll->findAll($data, '*', 'id desc', $p->firstRow . ',' . $p->listRows);
$page = $p->show();
if ($list !== false) {
$this->assign('page', $page);
$this->assign('list', $list);
$this->assign('allowbat', $this->allowbat);
}
$this->display();
}
public function index()
{
$id = intval($_REQUEST['id']);
$Announce = D("Announce");
$count = $Announce->count();
//if($count<=1)$this->error('此类别无产品');
import("ORG.Util.Page");
$listRows = 16;
$p = new page($count, $listRows);
$list = $Announce->findAll($mapc, '*', 'id desc', $p->firstRow . ',' . $p->listRows);
//$list=$p->order('pid desc')->limit("$p->firstRow.','.$p->listRows")->findAll();
$page = $p->show();
$this->assign('list', $list);
$this->assign('count', $count);
$this->assign('page', $page);
$this->display();
}
/**
* 获取分页效果,分页数据
* @return array
*/
public function getPageResult($wheres = array())
{
//保存查询条件
$wheres['status'] = array('neq', -1);
//提供分页工具条
$getpage = $this->where($wheres)->count();
//获取总条数
//获取每页显示条数,没有配置就默认10条
$pagesize = C('PAGE_SIZE') ? C('PAGE_SIZE') : 10;
//实例page类
$page = new page($getpage, $pagesize);
$pageHtml = $page->show();
//查询数据
$rows = $this->where($wheres)->limit($page->firstRow, $page->listRows)->select();
//返回数据
return array('rows' => $rows, 'pageHtml' => $pageHtml);
}
public function index()
{
import("ORG.Util.Page");
$now = date("Y-m-d");
$db = new WorldsModel();
$count['total'] = $db->count();
//总条数
$count['new'] = $db->where("substring(time,1,10)='{$now}'")->count();
//今日更新条数
$page = new page($count['total'], 10);
$page->setConfig('header', '条微博');
$world = $db->relation(true)->order('id desc')->limit($page->firstRow . ',' . $page->listRows)->select();
$this->assign('count', $count);
$this->assign('world', $world);
$this->assign('page_nav', $page->show());
$this->display();
//dump($);
}
public function audit()
{
import('ORG.Util.Page');
// 导入分页类
$count = D('Construction')->where(array('is_approve' => 3))->order('ord')->count();
$Page = new page($count, 3);
$Page->setConfig('theme', " %upPage% %downPage% %first% %prePage% %linkPage% %nextPage% %end%");
$show = $Page->show();
$aConstruction = $this->model->where(array('is_approve' => 3))->order('ord')->limit($Page->firstRow . ',' . $Page->listRows)->select();
//$aConstruction = $this->model->join('tb_case on tb_construction.id=tb_case.consid' )->where(array('tb_construction.is_approve'=>3,'tb_case.is_approve'=>3,'tb_construction.status'=>0,'tb_case.status'=>0,'tb_construction.appid'=>1,'tb_case.appid'=>1))->order('tb_construction.ord')->limit($Page->firstRow.','.$Page->listRows)->field('tb_construction.id,tb_case.consid,tb_construction.name cname,tb_construction.focus cfocus,tb_case.focus focus,tb_case.name,tb_case.housetype')->select();
//echo $this->model->getLastSql();die;
foreach ($aConstruction as $key => $val) {
$aConstruction[$key]['case'] = D('Case')->where(array('is_approve' => 3, 'consid' => $val['id']))->limit(4)->select();
}
//dump($aConstruction);die;
$this->assign('cons', $aConstruction);
$this->assign('page', $show);
$this->display();
}
