123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109 |
- <?php
- namespace app\admin\controller;
- use think\App;
- use think\Db;
- class DinnerApply extends Auth
- {
- public function __construct(App $app = null) {
- parent::__construct($app);
- $this->table='dinner_apply';
- }
- public function index(){
- if(request()->isAjax()){
-
- $length = input('rows',10,'intval');
- $page = input('page',1,'intval');
- $start = ($page - 1) * $length;
-
- $sortRow = input('sidx','id','trim');
- $sort = input('sord','desc','trim');
- $order = $sortRow.' '.$sort;
- $title = input('title','','trim');
- if($title){
- $map[] = ['name','like','%'.$title.'%'];
- }
- $enable = input('enable','','trim');
- if($enable != ''){
- $map[] = ['status','=',$enable];
- }
- $map[] = ['del','=',0];
- $map[] = ['org_id','=',$this->orgId];
- $map= empty($map) ? true: $map;
-
- $lists = db($this->table)->where($map)->limit($start,$length)->order($order)->select();
-
- $totalCount = db($this->table)->where($map)->count();
- $totalPage = ceil($totalCount/$length);
- $result['page'] = $page;
- $result['total'] = $totalPage;
- $result['records'] = $totalCount;
- $result['rows'] = $lists;
- return json($result);
- }else{
- return $this->fetch();
- }
- }
-
- public function del($id=0){
- if(!$id){
- $this->error('参数错误');
- }
- $res = db($this->table)->where('id',$id)->where('org_id',$this->orgId)->setField('del',1);
- if($res){
- $this->success('删除成功');
- }else{
- $this->error('删除失败');
- }
- }
- public function cancel($id=0){
- if(!$id){
- $this->error('参数错误');
- }
- $res = db($this->table)->where('id',$id)->where('org_id',$this->orgId)->setField('status',3);
- if($res){
- $this->success('作废成功');
- }else{
- $this->error('作废失败');
- }
- }
- public function option($id=0){
- if(request()->isPost()){
- $status = input('status/d',1);
- $remark = input('remark','');
- $res = Db::name('dinner_apply')
- ->where('id',$id)
- ->update([
- 'status'=>$status,
- 'remark'=>$remark,
- ]);
- if($status==1){
- $content = '同意特殊人员申请';
- }elseif ($status==2){
- $content = '拒绝特殊人员申请';
- }
- if($res){
- $this->success('操作成功',url('index'));
- }else{
- $this->error($this->model->getError());
- }
- }else{
- $this->assign('id',$id);
- return $this->fetch();
- }
- }
- }
|