File size: 3,909 Bytes
a4a352b |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 |
<?php
namespace app\admin\controller;
use think\Db;
class Card extends Base
{
public function __construct()
{
parent::__construct();
}
public function index()
{
$param = input();
$param['page'] = intval($param['page']) <1 ? 1 : $param['page'];
$param['limit'] = intval($param['limit']) <1 ? $this->_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'));
}
}
|