assign('breadcrumb1','拼团活动'); $this->assign('breadcrumb2','团列表'); } /** * 列表页 * * */ public function index(Model $Model,Product $Product,RegimentActive $RegimentActive,Custom $Custom){ // 接收参数 $code = request('code',''); $name = request('name',''); $productName = request('product_name',''); $status = request('status',''); $start_time = request('start_time',''); $end_time = request('end_time',''); // 查询条件 $map = []; // 组合条件 if( $name ) $map[] = ['regiment_active.name','=',$name]; if( $code ){ $id = $Model->codeToId($code); $map[] = ['regiment_active.id','=',$id]; } if( $productName ) $map[] = ['product.name','=',$productName]; if( $status ) $map[] = ['regiment.status','=',$status]; if( $start_time ) { $start_time = strtotime($start_time); $map[] = ['regiment.start_time','>=',$start_time]; } if( $end_time ) { $end_time = strtotime($end_time); $map[] = ['regiment.end_time','<=',$end_time]; } $select = [ 'regiment.*', 'regiment_active.name as active_name', 'product.name as product_name', 'custom.username as username', ]; // 查询数据 $list = $Model->query() ->join('regiment_active','regiment_active.id','=','regiment.active_id') ->join('product','product.id','=','regiment.product_id') ->leftJoin('custom','custom.uid','=','regiment.custom_uid') ->where($map) ->select($select) ->orderByDesc('id') ->paginate(config('page_num',10)); // 循环处理数据 foreach($list as &$v){ $v['product_code'] = $Product->idToCode($v['product_id']); $v['active_code'] = $RegimentActive->idToCode($v['active_id']); if ($v['custom_uid']){ $v['custom_code'] = $Custom->idToCode($v['custom_uid']); } } // 分配数据 $this->assign('empty', '~~暂无数据'); $this->assign('list',$list); // 加载模板 return $this->fetch(); } }