ThinkPHP中MVC代码范例

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();
    }