_pagesize : $param['limit']; $where=[]; if(in_array($param['sale_status'],['0','1'],true)){ $where['card_sale_status'] = ['eq',$param['sale_status']]; } if(in_array($param['use_status'],['0','1'],true)){ $where['card_use_status'] = ['eq',$param['use_status']]; } if(!empty($param['wd'])){ $param['wd'] = htmlspecialchars(urldecode($param['wd'])); $where['card_no'] = ['like','%'.$param['wd'].'%']; } if(isset($param['time'])){ $t=0; if($param['time']=='1'){ $t = model('Card')->max('card_add_time'); } else{ $t = strtotime(date('Y-m-d',strtotime('-'.$param['time'] .' day'))); } $where['card_add_time'] = ['egt', intval($t) ]; } if($param['export'] =='1'){ $param['page'] = 1; $param['limit'] = 9999; } $order='card_id desc'; $res = model('Card')->listData($where,$order,$param['page'],$param['limit']); if($param['export'] =='1'){ $filename = 'card_' . date('Y-m-d'). '.csv'; header("Content-type:text/csv"); header("Accept-Ranges:bytes"); header("Content-Disposition:attachment;filename=".$filename.""); header('Cache-Control:must-revalidate,post-check=0,pre-check=0'); header('Expires:0'); header('Pragma:public'); echo ''.lang('admin/card/import_tip') . "\n"; foreach($res['list'] as $k=>$v){ echo '="' . $v['card_no'] . '"' . ",=\"" . $v['card_pwd'] . "\"," . date('Y-m-d H:i:s',$v['card_add_time']) . "\n"; } exit; } $this->assign('list',$res['list']); $this->assign('total',$res['total']); $this->assign('page',$res['page']); $this->assign('limit',$res['limit']); $param['page'] = '{page}'; $param['limit'] = '{limit}'; $this->assign('param',$param); $this->assign('title',lang('admin/card/title')); return $this->fetch('admin@card/index'); } public function info() { if (Request()->isPost()) { $param = input('post.'); if(empty($param['num']) || empty($param['money']) || empty($param['point']) ){ return $this->error(lang('param_err')); } $res = model('Card')->saveAllData(intval($param['num']),intval($param['money']),intval($param['point']),$param['role_no'],$param['role_pwd']); if($res['code']>1){ return $this->error($res['msg']); } return $this->success($res['msg']); } $id = input('id'); $where=[]; $where['card_id'] = ['eq',$id]; $res = model('Card')->infoData($where); $this->assign('info',$res['info']); return $this->fetch('admin@card/info'); } public function del() { $param = input(); $ids = $param['ids']; $all = $param['all']; if(!empty($ids)){ $where=[]; $where['card_id'] = ['in',$ids]; if($all==1){ $where['card_id'] = ['gt',0]; } $res = model('Card')->delData($where); if($res['code']>1){ return $this->error($res['msg']); } return $this->success($res['msg']); } return $this->error(lang('param_err')); } }