BigWarehouse.php 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172
  1. <?php
  2. namespace app\controller\admin\warehouse;
  3. use crmeb\basic\BaseController;
  4. use think\facade\Db;
  5. class BigWarehouse extends BaseController
  6. {
  7. public function operation()
  8. {
  9. try {
  10. $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'];
  11. $data = $this->request->params($params);
  12. $check=$this->check_params($data);
  13. if($check['code']!=200) {
  14. return app('json')->fail($check['msg']);
  15. }
  16. if($data['type']==1){//添加
  17. $res=$this->warehouse_add($data);//执行方法
  18. if($res){
  19. return app('json')->success('添加成功');
  20. }else{
  21. return app('json')->success('添加失败');
  22. }
  23. }elseif ($data['type']==2){//修改
  24. $res=$this->warehouse_update($data);//执行方法
  25. if($res!==false){
  26. return app('json')->success('修改成功');
  27. }else{
  28. return app('json')->success('修改失败');
  29. }
  30. }
  31. }catch (\Exception $exception){
  32. return '大仓管理错误:'.$exception->getFile().':'.$exception->getLine().'【'.$exception->getMessage().'】';
  33. }
  34. }
  35. //大仓添加
  36. public function warehouse_add($data)
  37. {
  38. unset($data['type']);
  39. unset($data['id']);
  40. $data['create_time']=time();
  41. $data['uid']=Db::name('user')->where('account',$data['account']??'')->value('uid');
  42. $res=Db::name('big_warehouse')->insert($data);
  43. return $res;
  44. }
  45. //大仓修改
  46. public function warehouse_update($data)
  47. {
  48. $id=$data['id'];
  49. unset($data['type']);
  50. unset($data['id']);
  51. $data['update_time']=time();
  52. $data['uid']=Db::name('user')->where('account',$data['account']??0)->value('uid');
  53. $res=Db::name('big_warehouse')->where('id',$id)->update($data);
  54. return $res;
  55. }
  56. //检查参数
  57. public function check_params($data)
  58. {
  59. if(empty($data['account'])||empty($data['user_name'])||empty($data['warehouse_name'])){
  60. return ['code'=>1,'msg'=>'参数不完整'];
  61. }
  62. // if(!empty($data['account'])){
  63. $uid=Db::name('user')->where('account',$data['account'])->value('uid');
  64. if(!$uid){
  65. return ['code'=>1,'msg'=>'手机号暂未注册'];
  66. }
  67. // }
  68. $is_check=Db::name('big_warehouse')->where('warehouse_name',$data['warehouse_name'])->find();
  69. if ($is_check){
  70. if($is_check['uid']!=$uid){
  71. return ['code'=>1,'msg'=>'大仓名称已被注册'];
  72. }
  73. }
  74. if($data['type']!=1&&$data['type']!=2){
  75. return ['code'=>1,'msg'=>'请求类型不一致'];
  76. }
  77. return ['code'=>200,'msg'=>''];
  78. }
  79. //列表
  80. public function lst()
  81. {
  82. [$page, $limit] = $this->getPage();
  83. $status=$this->request->params(['status']);
  84. $where = [];
  85. if($status['status']){
  86. $where['status'] = $status;
  87. }
  88. $list=Db::name('big_warehouse')->where($where)->page($page,$limit)->select()->toArray();
  89. foreach ($list as $k=>&$v){
  90. $v['status']=(int)$v['status'];
  91. $v['create_time']=date('Y-m-d H:i:s',$v['create_time']);
  92. if($v['update_time']){
  93. $v['update_time']=date('Y-m-d H:i:s',$v['update_time']);
  94. }else{
  95. $v['update_time']='';
  96. }
  97. }
  98. $count=Db::name('big_warehouse')->count('id');
  99. $return_data=[
  100. 'count'=>$count,
  101. 'list'=>$list
  102. ];
  103. return app('json')->success($return_data);
  104. }
  105. //单个详情
  106. public function details()
  107. {
  108. $id=$this->request->params(['id']);
  109. if(empty($id['id'])){
  110. return app('json')->fail('id不存在');
  111. }
  112. $data=Db::name('big_warehouse')->where('id',$id['id'])->find();
  113. if($data){
  114. $data['create_time']=date('Y-m-d H:i:s',$data['create_time']);
  115. if($data['update_time']){
  116. $data['update_time']=date('Y-m-d H:i:s',$data['update_time']);
  117. }else{
  118. $data['update_time']='';
  119. }
  120. return app('json')->success($data);
  121. }else{
  122. return app('json')->fail('未查询到数据');
  123. }
  124. }
  125. //更改单个状态
  126. public function switchstatus($id)
  127. {
  128. $data=Db::name('big_warehouse')->where('id',$id)->find();
  129. if($data){
  130. if($data['status']==1){
  131. Db::name('big_warehouse')->where('id',$id)->dec('status',1)->update();
  132. }elseif ($data['status']==0){
  133. Db::name('big_warehouse')->where('id',$id)->inc('status',1)->update();
  134. }
  135. return app('json')->success('修改成功');
  136. }else{
  137. return app('json')->fail('未查询到数据');
  138. }
  139. }
  140. /*获取省份*/
  141. public function getProvince(){
  142. $data = Db::name("user_province")
  143. ->where(['status'=>1])
  144. ->field("province_id,province_code,province_name")
  145. ->select();
  146. return app('json')->success($data);
  147. }
  148. /*获取城市*/
  149. public function getCity($id){
  150. $data = Db::name("user_city")
  151. ->where(['status'=>1,'province_code'=>$id])
  152. ->field("city_id,city_code,city_name")
  153. ->select();
  154. return app('json')->success($data);
  155. }
  156. /*获取区域*/
  157. public function getArea($id){
  158. $data = Db::name("user_area")
  159. ->where(['status'=>1,'city_code'=>$id])
  160. ->field("area_id,area_code,area_name")
  161. ->select();
  162. return app('json')->success($data);
  163. }
  164. }