technician/app/back/controller/JsAlreadyController.php

<?php
    /**
     * Created by PhpStorm.
     * User: Administrator
     * Date: 2020-08-28
     * Time: 8:46
     */
    namespace app\back\controller;
    use app\back\model\JsCategoryModel;
    use app\back\model\JsModel;
    use cmf\controller\AdminBaseController;
    use think\Db;

    class JsAlreadyController extends AdminBaseController
    {
        public function index()
        {
            
            $where= [];
            $jsModel = new JsModel();
            $page = $this->request->param('page',1);
            $pw = [];
            $keyword = $this->request->param('keyword');
            $category_id = $this->request->param('category_id');
            if($category_id){
                $this->assign('category_id',$category_id);
                $pw['category_id'] = $category_id;
                $js_ids = Db::name('js_category_relevancy')->where('category_id',$category_id)->field('js_id')->select();
                $js_new_ids  = [];
                foreach ($js_ids as $vo)
                {
                    $js_new_ids[] = $vo['js_id'];
                }
                $where['id'] = $js_new_ids;
            }
            if($keyword){
                $this->assign('keyword',$keyword);
                $pw['keyword'] = $keyword;
            }
         //   die;
            $where['js_status'] = [1,3];
            $list = $jsModel->with(['user','category','project'=>function($query){$query->where('status',1);}])->where($where)->where(function ($query) use ($keyword){
                if($keyword){
                    $query->where('name|phone','like','%'.$keyword.'%');
                }
            })->order('id','desc')->paginate(30,false,array($page,url('index'),'query'=>$pw));
            // var_dump($jsModel->getLastSql());
            $JsCategoryModel = new JsCategoryModel();
            $js_category_list = $JsCategoryModel::select();
            $this->assign('list',$list);
            $this->assign('js_category_list',$js_category_list);
            $this->assign('page',$list->render());
            
            return $this->fetch();
        }
    
    
        public function show()
        {
            $ids = $this->request->param('ids/a');
            $is_show = $this->request->param('is_show');
            JsModel::where('id','in',$ids)->update(['is_show'=>$is_show]);
            $this->success('操作成功');
        }
    
        public function listOrder()
        {
            $JsModel= new JsModel();
            parent::listOrders($JsModel);
            $this->success("排序更新成功！");
        }
    
        public function delete()
        {
            $id = $this->request->param('id');
            JsModel::destroy($id);
            $this->success('删除成功');
        }
        
        
        public function xj()
        {
           $id = $this->request->param('id');
            $info = JsModel::get($id);
            $type = $this->request->param('type');
            if($type*1==1){
                $info->save(['js_status'=>3]);
            }else{
                $info->save(['js_status'=>1]);    
            }
            
            $this->success('下架成功');
        }

        
        public function setCategory()
        {
            $js_id = $this->request->param('js_id');
            $car_ids = $this->request->param('car_ids/a');
            Db::name('js_category_relevancy')->where('js_id',$js_id)->delete();
            $ins = [];
            foreach ($car_ids as $k=>$v){
                $ins[$k]['category_id'] = $v;
                $ins[$k]['js_id'] = $js_id;
            }
            Db::name('js_category_relevancy')->insertAll($ins);
            return json(['code'=>1]);
        }
        

        
        public function edit()
        {
            $id = $this->request->param('id');
            $info = JsModel::get($id);
            $this->assign('info',$info);
            return $this->fetch();
        }
        public function editpost()
        {
            $data = $this->request->param();
            $JsModel = new JsModel();
			
			$info = JsModel::get($data['id'])->toArray();
			if(isset($data['v_jiedan_num']) && $data['v_jiedan_num'] != $info['v_jiedan_num']){
				$data['jiedan_num'] = $info['jiedan_num']+$data['v_jiedan_num']-$info['v_jiedan_num'];				
				$admin_id = cmf_get_current_admin_id();
				$log_info = '变更前:'.$info['v_jiedan_num'].';变更后:'.$data['v_jiedan_num'];
				admin_log($admin_id,$log_info,$data['id'],'修改技师虚拟单');
			}
            $JsModel->allowField(true)->isUpdate(true)->save($data,['id'=>$data['id']]);
            $this->success('修改成功!');
        }
        public function cancel()
        {
            $id = $this->request->param('id');
            $js_id = $this->request->param('js_id');
            Db::name('js_project_relevancy')->where(['project_id'=>$id,'js_id'=>$js_id])->delete();
            $this->success('取消成功');
        }
    }