Controller
public function productlist(){
$map = ['p.isdelete'=>0,'u.isdelete'=>0,'p.istrade'=>0];//没有删除
//获取提交的数据
$name = I('name');
$status = I('post.status');
$begindate = I("post.begindate");
$enddate = I("post.enddate");
$audit=I('post.audit');
$istop=I('post.istop');
$show_status=I('post.show_status');
//拼接where条件
if($name) $map['p.name'] = ['like','%'.$name.'%'];
if($status>=0 && is_numeric($status)) $map['p.status'] = $status;
if($begindate && $enddate) $map['p.addtime'] = array(array('egt',$begindate),array('elt',date('Y-m-d', strtotime("$enddate+1days"))) );
// if($begindate) $map['p.addtime'] = array("egt",$begindate);
// if($enddate) $map['p.addtime'] = array('elt', date('Y-m-d', strtotime("$enddate+1days")));
if($audit>=0 && is_numeric($audit))$map['p.audit']=$audit;
if($istop>=0 && is_numeric($istop))$map['p.istop']=$istop;
if($show_status == 1){
$map['p.status'] = 1;
$map['p.audit'] = 2;
$map['p.show_start_time'] = array('elt',date('Y-m-d H:i:s',time()));
$map['p.show_end_time'] = array('egt',date('Y-m-d H:i:s',time()));
}
//分页
$pagenum =I('param.p');
if(!$pagenum)$pagenum=1;
$pagenum=!is_numeric($pagenum)?1:$pagenum;
$pagesize= C('pagesize',null,10);
// $pagesize=2;
$count=0;
// $list = D('product')->getproductlist($map,'p.*,u.user_name');
//进入Model调用方法
$list = D('product')->getproductlist($pagenum,$pagesize,$count,$begindate,$enddate,$map,'p.*,u.user_name');
//echo M()->_sql();die;
if($list){
foreach($list as $k=>$v){
$bt = strtotime($v['show_start_time']);
$et = strtotime($v['show_end_time']);
if($bt<time() && $et>time() && $v['audit'] ==2 && $v['isdelete'] == 0){
$list[$k]['show_status'] = 1;//前台展示
}else{
$list[$k]['show_status'] = 0;//前台未展示
}
}
}
$this->assign('list',$list);
$page = new \Think\Page($count,$pagesize);
$show = $page->show();
$this->assign('page',$show);
$this->display();
}