UserCar.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306
  1. <?php
  2. namespace app\api\controller;
  3. use AlibabaCloud\SDK\Dingtalk\Vyida_1_0\Models\GetFormDataByIDResponseBody\originator\name;
  4. use app\common\model\CarApprove;
  5. use app\common\model\CarFlow;
  6. use app\common\model\CarInfo;
  7. use app\common\service\ApproveService;
  8. use think\Db;
  9. /**
  10. * @title 用车管理
  11. * @controller UserCar
  12. * @group base
  13. */
  14. class UserCar extends Base
  15. {
  16. public function initialize()
  17. {
  18. parent::initialize();
  19. parent::checkLogin();
  20. }
  21. /**
  22. * @title 获取审批流程
  23. * @desc 获取审批流程
  24. * @author qc
  25. * @url /api/User_car/getApproveFlow
  26. * @method GET
  27. * @tag 个人信息
  28. * @header name:Authorization require:1 desc:Token
  29. * @return name:user_name type:string default:-- desc:会员名称
  30. * @return name:headimg type:string default:-- desc:会员头像
  31. */
  32. public function getApproveFlow()
  33. {
  34. $check_flow = CarFlow::where('user_id',$this->user_id)->where('type',1)->find();
  35. $where = [];
  36. $where[] = ['l.type','=',1];
  37. if($check_flow)$where[] = ['l.sort','>',$check_flow->sort];
  38. $list = CarFlow::field('l.user_id,u.name user_name,u.headimg')
  39. ->alias('l')
  40. ->where($where)
  41. ->order('l.sort asc')
  42. ->leftJoin('StoreMember u','u.id = l.user_id')
  43. ->select()->toArray();
  44. $this->success('ok',['list'=>$list]);
  45. }
  46. /**
  47. * @title 获取抄送人流程
  48. * @desc 获取抄送人流程
  49. * @author qc
  50. * @url /api/User_car/getCopyFlow
  51. * @method GET
  52. * @tag 个人信息
  53. * @header name:Authorization require:1 desc:Token
  54. * @return name:user_name type:string default:-- desc:会员名称
  55. * @return name:headimg type:string default:-- desc:会员头像
  56. */
  57. public function getCopyFlow()
  58. {
  59. $check_flow = CarFlow::where('user_id',$this->user_id)->where('type',2)->find();
  60. $where = [];
  61. $where[] = ['l.type','=',2];
  62. if($check_flow)$where[] = ['l.sort','>',$check_flow->sort];
  63. $list = CarFlow::field('l.user_id,u.name user_name,u.headimg')
  64. ->alias('l')
  65. ->where($where)
  66. ->order('l.sort asc')
  67. ->leftJoin('StoreMember u','u.id = l.user_id')
  68. ->select()->toArray();
  69. $this->success('ok',['list'=>$list]);
  70. }
  71. /**
  72. * @title 用车用车
  73. * @desc 用车用车
  74. * @author qc
  75. * @url /api/User_car/applyCar
  76. * @method GET
  77. * @tag 个人信息
  78. * @header name:Authorization require:1 desc:Token
  79. * @param name:departure type:string default:-- desc:出发地址
  80. * @param name:start_time type:string default:-- desc:出发时间
  81. * @param name:arrive type:string default:-- desc:到达地址
  82. * @param name:end_time type:string default:-- desc:返回时间
  83. * @param name:back_address type:string default:-- desc:返回地址
  84. */
  85. public function applyCar()
  86. {
  87. $departure = input('post.departure');
  88. $start_time = input('post.start_time');
  89. $arrive = input('post.arrive');
  90. $end_time = input('post.end_time');
  91. $back_address = input('post.back_address');
  92. $request_param = input('post.');
  93. $request_param['user_id'] = $this->user_id;
  94. $request_param['apply_user'] = $this->user_id;
  95. $flow = CarFlow::getApproveUser();// 用车审批流程设置
  96. $flow_user = array_column($flow,'user_id');
  97. $flow_key = array_search($request_param['user_id'],$flow_user);// 请用车是否在审批流程人员中
  98. $copy = CarFlow::getCopyTo();
  99. $copy_user = array_column($copy,'user_id');
  100. $copy_key = array_search($request_param['user_id'],$copy_user);// 用车人是否在抄送人员中
  101. $request_param['apply_date'] = date("Y-m-d");
  102. $flow_info = CarInfo::create($request_param);//生成用车记录
  103. $flow_data = [];// 审批流程
  104. $flow_num = 0;
  105. foreach ($flow as $fk=>$fv) {
  106. if($flow_key !== false && $flow_key >= $fk) continue;
  107. $flow_num++;
  108. $flow_data[] = [
  109. 'car_id' => $flow_info->id,
  110. 'approve_user' => $fv['user_id'],
  111. 'flow' =>$flow_num,
  112. 'create_at'=>date('Y-m-d H:i:s'),
  113. 'start_time'=> $flow_num == 1 ? date('Y-m-d H:i:s'):null,
  114. 'status'=> $flow_num == 1 ? 1 : 0,
  115. ];
  116. }
  117. foreach ($copy as $ck=>$cv) {
  118. if($copy_key !== false && $copy_key >= $ck) continue;
  119. $flow_data[] = [
  120. 'car_id' => $flow_info->id,
  121. 'approve_user' => $cv['user_id'],
  122. 'approve_type' =>2
  123. ];
  124. }
  125. if(!empty($flow_data)) {
  126. CarInfo::where('id',$flow_info->id)->update(['approve_num'=>$flow_num]);
  127. (new CarApprove())->saveAll($flow_data);
  128. }else{
  129. CarInfo::where('id',$flow_info->id)->update(['status'=>2]);
  130. }
  131. $this->success('用车申请已提交,请等待审核',['detail'=>$flow_info->toArray()]);
  132. }
  133. /**
  134. * @title 我的申请用车记录【列表】
  135. * @desc 我的申请用车记录
  136. * @author qc
  137. * @url /api/User_car/getApplyList
  138. * @method GET
  139. * @tag 个人信息
  140. * @header name:Authorization require:1 desc:Token
  141. * @param name:page type:int default:-- desc:页数
  142. * @param name:page_num type:int default:-- desc:每页数量
  143. * @param name:status type:int default:0 desc:审批状态0全部,1审批中,2审批通过,3审批拒绝,9取消
  144. * @param name:sel_time type:string default:0 desc:时间查询
  145. * @return name:create_at type:string default:-- desc:提交申请用车时间
  146. * @return name:departure type:string default:-- desc:出发地址
  147. * @return name:start_time type:string default:-- desc:出发时间
  148. * @return name:arrive type:string default:-- desc:到达地址
  149. * @return name:end_time type:string default:-- desc:返回时间
  150. * @return name:back_address type:string default:-- desc:返回地址
  151. * @return name:user_name type:string default:-- desc:会员名称
  152. * @return name:headimg type:string default:-- desc:用车会员头像
  153. */
  154. public function getApplyList()
  155. {
  156. $sel_where[] = ['user_id','=',$this->user_id];
  157. if(input('get.status') > 0) $sel_where[] = ['status','=',input('get.status')];
  158. if(input('get.sel_time')) $sel_where[] = ['create|end_date','=',input('get.sel_time')];
  159. $list = CarInfo::where($sel_where)
  160. ->field('c.id,c.create_at,c.departure,c.start_time,c.arrive,c.end_time,c.back_address,u.name user_name,u.headimg')
  161. ->alias('c')
  162. ->leftJoin('StoreMember u','u.id = c.user_id')
  163. ->limit($this->off_set,$this->page_num)
  164. ->select()->toArray();
  165. $this->success('ok',['list'=>$list]);
  166. }
  167. /**
  168. * @title 用车记录详情
  169. * @desc 用车记录详情
  170. * @author qc
  171. * @url /api/User_car/getApplyDetail
  172. * @method GET
  173. * @tag 个人信息
  174. * @header name:Authorization require:1 desc:Token
  175. * @param name:id type:int default:-- desc:用车记录id
  176. * @return name:create_at type:string default:-- desc:提交申请用车时间
  177. * @return name:departure type:string default:-- desc:出发地址
  178. * @return name:start_time type:string default:-- desc:出发时间
  179. * @return name:arrive type:string default:-- desc:到达地址
  180. * @return name:end_time type:string default:-- desc:返回时间
  181. * @return name:back_address type:string default:-- desc:返回地址
  182. * @return name:approve_list type:array default:-- desc:审批记录
  183. * @return name:approve_list.status type:int default:-- desc:审批状态:0待审批(未到该审批人审批),1审批中(已到该审批人审批,还未审批)2审批通过3审批拒绝
  184. * @return name:approve_list.approve_time type:string default:-- desc:审批时间
  185. * @return name:approve_list.remark type:string default:-- desc:审批备注
  186. * @return name:approve_list.user_name type:string default:-- desc:审批人
  187. * @return name:approve_list.headimg type:string default:-- desc:审批人头像
  188. * @return name:approve_list.time type:string default:-- desc:审批用时(上一次审批完成到本次审批的时间,单位秒)
  189. */
  190. public function getApplyDetail()
  191. {
  192. $id = input('get.id');
  193. $detail = CarInfo::field('c.id,c.create_at,c.departure,c.start_time,c.arrive,c.end_time,c.back_address,u.name user_name,u.headimg')
  194. ->alias('c')->with('approveList')->where(['user_id'=>$this->user_id])->where(['id'=>$id])
  195. ->limit($this->off_set,$this->page_num)
  196. ->find()->toArray();
  197. $this->success('ok',['detail'=>$detail]);
  198. }
  199. /**
  200. * @title 需要我审批的
  201. * @desc 需要我审批的
  202. * @author qc
  203. * @url /api/User_car/getApproveApply
  204. * @method POST
  205. * @tag 个人信息
  206. * @header name:Authorization require:1 desc:Token
  207. * @param name:page type:int default:-- desc:页数
  208. * @param name:page_num type:int default:-- desc:每页数量
  209. * @return name:departure type:string default:-- desc:出发地址
  210. * @return name:start_time type:string default:-- desc:出发时间
  211. * @return name:arrive type:string default:-- desc:到达地址
  212. * @return name:end_time type:string default:-- desc:返回时间
  213. * @return name:back_address type:string default:-- desc:返回地址
  214. * @return name:user_name type:string default:-- desc:申请人
  215. * @return name:approve_status type:int default:-- desc:审批状态(1审批中2审批通过3审批拒绝)
  216. * @return name:approve_time type:string default:-- desc:审批时间
  217. * @return name:remark type:string default:-- desc:审批备注
  218. */
  219. public function getApproveApply()
  220. {
  221. $list = CarApprove::field('i.*,p.status approve_status,p.approve_time,p.remark')
  222. ->alias('p')
  223. ->where(['p.approve_user'=>$this->user_id])
  224. ->where('p.status','>','0')
  225. ->leftJoin('CarInfo i','p.car_id = i.id')
  226. ->limit($this->off_set,$this->page_num)
  227. ->select()->toArray();
  228. array_walk($list,function (&$v){
  229. $user_info = $this->userInfo('name,headimg');
  230. $v['user_name'] = $user_info['name'];
  231. });
  232. $this->success('ok',['list'=>$list]);
  233. }
  234. /**
  235. * @title 撤销用车申请
  236. * @desc 撤销用车申请
  237. * @author qc
  238. * @url /api/User_car/cancelApply
  239. * @method POST
  240. * @tag
  241. * @header name:Authorization require:1 desc:Token
  242. * @param name:id type:int default:-- desc:用车记录id
  243. *
  244. */
  245. public function cancelApply()
  246. {
  247. $id = input('post.id');
  248. $apply_info = CarInfo::where('id',$id)->where('user_id',$this->user_id)->find();
  249. if(!$apply_info)$this->error('用车记录有误');
  250. $apply_info->status = 9;
  251. $apply_info->save();
  252. $this->success('撤销成功');
  253. }
  254. /**
  255. * @title 审批请假记录
  256. * @desc 审批请假记录
  257. * @author qc
  258. * @url /api/User_car/approveLeave
  259. * @method POST
  260. * @tag
  261. * @header name:Authorization require:1 desc:Token
  262. * @param name:approve_id type:string default:-- desc:审批记录id
  263. * @param name:status type:string default:-- desc:审批状态(2审批通过3审批拒绝)
  264. * @param name:remark type:string default:-- desc:审批备注
  265. */
  266. public function approveCar()
  267. {
  268. $approve_id = input('post.approve_id');
  269. $status = input('post.status');
  270. $remark = input('post.remark');
  271. $res = ApproveService::approveCar($approve_id,$this->user_id,$status,$remark);
  272. if(!$res['ret_val']) $this->error($res['msg']);
  273. $this->success('审批完成');
  274. }
  275. }