| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172 |
- <?php
- namespace app\controller\admin\warehouse;
- use crmeb\basic\BaseController;
- use think\facade\Db;
- class BigWarehouse extends BaseController
- {
- public function operation()
- {
- try {
- $params=['account','user_name','warehouse_name','status','type','id','logo','complaint_mailbox','complaint_tel','service_tel','attract_tel','address','business_license','main_company','area','area','introduce','province','city'];
- $data = $this->request->params($params);
- $check=$this->check_params($data);
- if($check['code']!=200) {
- return app('json')->fail($check['msg']);
- }
- if($data['type']==1){//添加
- $res=$this->warehouse_add($data);//执行方法
- if($res){
- return app('json')->success('添加成功');
- }else{
- return app('json')->success('添加失败');
- }
- }elseif ($data['type']==2){//修改
- $res=$this->warehouse_update($data);//执行方法
- if($res!==false){
- return app('json')->success('修改成功');
- }else{
- return app('json')->success('修改失败');
- }
- }
- }catch (\Exception $exception){
- return '大仓管理错误:'.$exception->getFile().':'.$exception->getLine().'【'.$exception->getMessage().'】';
- }
- }
- //大仓添加
- public function warehouse_add($data)
- {
- unset($data['type']);
- unset($data['id']);
- $data['create_time']=time();
- $data['uid']=Db::name('user')->where('account',$data['account']??'')->value('uid');
- $res=Db::name('big_warehouse')->insert($data);
- return $res;
- }
- //大仓修改
- public function warehouse_update($data)
- {
- $id=$data['id'];
- unset($data['type']);
- unset($data['id']);
- $data['update_time']=time();
- $data['uid']=Db::name('user')->where('account',$data['account']??0)->value('uid');
- $res=Db::name('big_warehouse')->where('id',$id)->update($data);
- return $res;
- }
- //检查参数
- public function check_params($data)
- {
- if(empty($data['account'])||empty($data['user_name'])||empty($data['warehouse_name'])){
- return ['code'=>1,'msg'=>'参数不完整'];
- }
- // if(!empty($data['account'])){
- $uid=Db::name('user')->where('account',$data['account'])->value('uid');
- if(!$uid){
- return ['code'=>1,'msg'=>'手机号暂未注册'];
- }
- // }
- $is_check=Db::name('big_warehouse')->where('warehouse_name',$data['warehouse_name'])->find();
- if ($is_check){
- if($is_check['uid']!=$uid){
- return ['code'=>1,'msg'=>'大仓名称已被注册'];
- }
- }
- if($data['type']!=1&&$data['type']!=2){
- return ['code'=>1,'msg'=>'请求类型不一致'];
- }
- return ['code'=>200,'msg'=>''];
- }
- //列表
- public function lst()
- {
- [$page, $limit] = $this->getPage();
- $status=$this->request->params(['status']);
- $where = [];
- if($status['status']){
- $where['status'] = $status;
- }
- $list=Db::name('big_warehouse')->where($where)->page($page,$limit)->select()->toArray();
- foreach ($list as $k=>&$v){
- $v['status']=(int)$v['status'];
- $v['create_time']=date('Y-m-d H:i:s',$v['create_time']);
- if($v['update_time']){
- $v['update_time']=date('Y-m-d H:i:s',$v['update_time']);
- }else{
- $v['update_time']='';
- }
- }
- $count=Db::name('big_warehouse')->count('id');
- $return_data=[
- 'count'=>$count,
- 'list'=>$list
- ];
- return app('json')->success($return_data);
- }
- //单个详情
- public function details()
- {
- $id=$this->request->params(['id']);
- if(empty($id['id'])){
- return app('json')->fail('id不存在');
- }
- $data=Db::name('big_warehouse')->where('id',$id['id'])->find();
- if($data){
- $data['create_time']=date('Y-m-d H:i:s',$data['create_time']);
- if($data['update_time']){
- $data['update_time']=date('Y-m-d H:i:s',$data['update_time']);
- }else{
- $data['update_time']='';
- }
- return app('json')->success($data);
- }else{
- return app('json')->fail('未查询到数据');
- }
- }
- //更改单个状态
- public function switchstatus($id)
- {
- $data=Db::name('big_warehouse')->where('id',$id)->find();
- if($data){
- if($data['status']==1){
- Db::name('big_warehouse')->where('id',$id)->dec('status',1)->update();
- }elseif ($data['status']==0){
- Db::name('big_warehouse')->where('id',$id)->inc('status',1)->update();
- }
- return app('json')->success('修改成功');
- }else{
- return app('json')->fail('未查询到数据');
- }
- }
- /*获取省份*/
- public function getProvince(){
- $data = Db::name("user_province")
- ->where(['status'=>1])
- ->field("province_id,province_code,province_name")
- ->select();
- return app('json')->success($data);
- }
- /*获取城市*/
- public function getCity($id){
- $data = Db::name("user_city")
- ->where(['status'=>1,'province_code'=>$id])
- ->field("city_id,city_code,city_name")
- ->select();
- return app('json')->success($data);
- }
- /*获取区域*/
- public function getArea($id){
- $data = Db::name("user_area")
- ->where(['status'=>1,'city_code'=>$id])
- ->field("area_id,area_code,area_name")
- ->select();
- return app('json')->success($data);
- }
- }
|