OaService.php 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747
  1. <?php
  2. namespace App\Service;
  3. use App\Model\BasicRollFilm;
  4. use App\Model\Construction;
  5. use App\Model\Employee;
  6. use App\Model\EmployeeDepartPermission;
  7. use App\Model\EmployeeTeamPermission;
  8. use App\Model\Oa;
  9. use App\Model\OaOrder;
  10. use App\Model\OaOrderSub;
  11. use App\Model\OaOrderSubEmployee;
  12. use App\Model\OaSub;
  13. use App\Model\OaSubRule;
  14. use App\Model\RollFilm;
  15. use App\Model\RollFilmCombine;
  16. use App\Model\RollFilmCompany;
  17. use App\Model\SysMenu;
  18. use App\Model\Team;
  19. use Illuminate\Support\Facades\App;
  20. use Illuminate\Support\Facades\DB;
  21. use Illuminate\Support\Facades\Log;
  22. use Illuminate\Http\Request;
  23. use Illuminate\Support\Facades\Route;
  24. /**
  25. * bom相关
  26. * @package App\Models
  27. */
  28. class OaService extends Service
  29. {
  30. public function oaList($data)
  31. {
  32. $list = Oa::from('oa as o')
  33. ->leftjoin('sys_menu as s', 's.id', 'o.menu_id')
  34. ->select('o.id', 'o.menu_id', 'o.crt_time', 's.title')
  35. ->where('o.del_time', 0);
  36. $list = $this->limit($list, '', $data);
  37. return [true, $list];
  38. }
  39. public function oaDetail($data)
  40. {
  41. // $id = $data['id'];
  42. //
  43. //// if($this->isEmpty($data,'title')) return [201,'名称不存在!'];
  44. // $detail = OaSub::from('oa_sub as os')
  45. // ->leftJoin('employee as e', 'e.id', 'os.employee_id')
  46. // ->leftJoin('area as a', 'a.id', 'os.area_id')
  47. // ->where('oa_id', $id)
  48. // ->where('os.del_time', 0)
  49. // ->select('os.sort', 'os.type', 'os.employee_id', 'os.remark', 'e.emp_name','os.type','os.area_id','a.title as area_name')
  50. // ->orderBy('os.sort', 'asc')->get()->toArray();
  51. // $first = Oa::from('oa as o')
  52. // ->leftjoin('sys_menu as s', 's.id', 'o.menu_id')
  53. // ->select('o.id', 'o.menu_id', 'o.crt_time', 's.title','o.type')
  54. // ->where('o.del_time', 0)->where('o.id', $id)->first()->toArray();
  55. //
  56. // $first['detail'] = $detail;
  57. $detail = [
  58. 'id' => 1,
  59. 'detail' => [
  60. [
  61. 'id' => 2,
  62. 'name' => '张三',
  63. 'list' => [
  64. [
  65. 'id' => 4,
  66. 'name' => '张三三',
  67. 'list' => [
  68. [
  69. 'id' => 5,
  70. 'name' => '张五',
  71. 'list' => [
  72. [
  73. 'id' => 6,
  74. 'name' => '李六',
  75. 'list' => []
  76. ]
  77. ]
  78. ], [
  79. 'id' => 7,
  80. 'name' => '张六',
  81. 'list' => [
  82. [
  83. 'id' => 6,
  84. 'name' => '李六',
  85. 'list' => []
  86. ]
  87. ]
  88. ],
  89. ],
  90. ], [
  91. 'id' => 44,
  92. 'name' => '张四四',
  93. 'list' => [
  94. [
  95. 'id' => 55,
  96. 'name' => '张四四1',
  97. 'list' => [
  98. [
  99. 'id' => 66,
  100. 'name' => '李六1',
  101. 'list' => [
  102. [
  103. 'id' => 77,
  104. 'name' => 'li7',
  105. 'list' => []
  106. ]
  107. ]
  108. ]
  109. ]
  110. ], [
  111. 'id' => 77,
  112. 'name' => '张四四2',
  113. 'list' => [
  114. [
  115. 'id' => 6,
  116. 'name' => '李六',
  117. 'list' => []
  118. ]
  119. ]
  120. ],
  121. ],
  122. ],
  123. ]
  124. ], [
  125. 'id' => 3,
  126. 'name' => '李四',
  127. 'list' => [
  128. [
  129. 'id' => 8,
  130. 'name' => '李五',
  131. 'list' => [
  132. [
  133. 'id' => 9,
  134. 'name' => '李六',
  135. 'list' => [
  136. [
  137. 'id' => 6,
  138. 'name' => '李六',
  139. 'list' => []
  140. ]
  141. ]
  142. ]
  143. ]
  144. ]
  145. ]
  146. ],
  147. ],
  148. ];
  149. return [true, $detail];
  150. }
  151. public function oaUserDetail($data)
  152. {
  153. $detail = [
  154. 'detail' => [
  155. [
  156. 'key' => 'area',
  157. 'value' => '南区',
  158. 'formula' => 'dengyu',
  159. ], [
  160. 'key' => 'num',
  161. 'value' => '40',
  162. 'formula' => 'dayu',
  163. ], [
  164. 'key' => 'brand',
  165. 'value' => 'A,B,C',
  166. 'formula' => 'baohan',
  167. ],
  168. ],
  169. 'click' => [
  170. 'area',
  171. 'num',
  172. 'brand',
  173. ],
  174. 'string' => '(area 并且 num) 或者 num'
  175. ];
  176. return [true, $detail];
  177. }
  178. public function oaParam($data)
  179. {
  180. $detail = [
  181. [
  182. 'key' => 'area',
  183. 'value' => '地区',
  184. ], [
  185. 'key' => 'num',
  186. 'value' => '数量',
  187. ], [
  188. 'key' => 'brand',
  189. 'value' => '品牌',
  190. ],
  191. ];
  192. return [true, $detail];
  193. }
  194. public function oaFormula($data)
  195. {
  196. $detail = [
  197. [
  198. 'key' => 'dengyu',
  199. 'value' => '等于',
  200. ], [
  201. 'key' => 'dayu',
  202. 'value' => '大于',
  203. ], [
  204. 'key' => 'baohan',
  205. 'value' => '包含',
  206. ],
  207. ];
  208. return [true, $detail];
  209. }
  210. public function oaAdd($data)
  211. {
  212. $oa = new Oa();
  213. try {
  214. DB::beginTransaction();
  215. $oa->menu_id = $data['menu_id'];
  216. $oa->type = $data['type'];
  217. $oa->save();
  218. $id = $oa->id;
  219. $insert = [];
  220. foreach ($data['detail'] as $v) {
  221. foreach ($v['employee_list'] as $vv) {
  222. $insert[] = [
  223. 'oa_id' => $id,
  224. 'remark' => $v['remark'],
  225. 'employee_id' => $vv['employee_id'],
  226. 'sort' => $v['sort'],
  227. 'type' => $v['type'],
  228. 'crt_time' => time(),
  229. 'upd_time' => time(),
  230. 'area_id' => $vv['area_id'],
  231. ];
  232. }
  233. }
  234. OaSub::insert($insert);
  235. DB::commit();
  236. } catch (\Exception $e) {
  237. DB::rollBack();
  238. return [false, $e->getLine() . ':' . $e->getMessage()];
  239. }
  240. return [true, '保存成功!'];
  241. }
  242. public function oaEdit($data,$user)
  243. {
  244. $first = Oa::where('del_time', 0)->where('menu_id', $data['menu_id']);
  245. if(isset($data['id'])) $first = $first->where('id', '<>', $data['id']);
  246. if (isset($data['type'])) $first = $first->where('type', $data['type']);
  247. $first = $first->first();
  248. if ($first) return [false, '该菜单oa已存在!'];
  249. try {
  250. DB::beginTransaction();
  251. if(isset($data['id'])) $oa = Oa::where('id', $data['id'])->first();
  252. $oa = new Oa();
  253. $oa->menu_id = $data['menu_id'];
  254. $oa->crt_employee_id = $user['id'];
  255. $oa->type = $data['type']??0;
  256. $oa->save();
  257. $id = $oa->id;
  258. $insert = [];
  259. OaSub::where('oa_id', $id)->update([
  260. 'del_time' => time()
  261. ]);
  262. //处理前端数据
  263. $this->dealOaData($data,$id);
  264. foreach ($data['detail'] as $v) {
  265. foreach ($v['employee_list'] as $vv) {
  266. $insert[] = [
  267. 'oa_id' => $id,
  268. 'remark' => $v['remark'],
  269. 'employee_id' => $vv['employee_id'],
  270. 'sort' => $v['sort'],
  271. 'type' => $v['type'],
  272. 'crt_time' => time(),
  273. 'upd_time' => time(),
  274. 'area_id' => $vv['area_id'],
  275. ];
  276. }
  277. }
  278. OaSub::insert($insert);
  279. DB::commit();
  280. } catch (\Exception $e) {
  281. DB::rollBack();
  282. return [false, $e->getMessage()];
  283. }
  284. return [true, '更新成功'];
  285. }
  286. public function dealOaData($data,$id){
  287. $data = $data['approval'];
  288. $detail = [];
  289. $sort = 0;
  290. foreach ($data as $v){
  291. $sort++;
  292. foreach ($v['children'] as $vv){
  293. $detail[] = [
  294. 'h5_key' => $vv['index'],
  295. 'emp_id' => $vv['emp_id'],
  296. 'set' => $vv['set'],
  297. 'sort' => $sort,
  298. ];
  299. }
  300. }
  301. dd($detail);die;
  302. }
  303. public function oaDel($data)
  304. {
  305. $id = $data['id'];
  306. Oa::where('id', $id)->update([
  307. 'del_time' => time(),
  308. ]);
  309. OaSub::where('oa_id', $id)->update([
  310. 'del_time' => time(),
  311. ]);
  312. return [true, '删除成功'];
  313. }
  314. public function oaSubType($data)
  315. {
  316. $service = new CheckService();
  317. $list = $service->map;
  318. $return = [];
  319. foreach ($list as $k => $v) {
  320. $return[] = [
  321. 'id' => $k,
  322. 'title' => $v,
  323. ];
  324. }
  325. return [true, $return];
  326. }
  327. public function createOaOrder($data)
  328. {
  329. // $crt_id = request()->userData->id;
  330. Log::channel('request')->info('request', ['param' => $data]);
  331. if(!isset($data['order_number'])) $data['order_number'] = $data['order_no'];
  332. $orderObject = $data['order_number'];
  333. $menu_id = $data['menu_id'];
  334. $order_no = $data['order_number'];
  335. $type = isset($data['opt_case']) ? $data['opt_case'] : 0;
  336. // $this->returnOa($order_no,1,$type);
  337. // return [200,''];
  338. $list = Oa::from('oa as o')
  339. ->leftJoin('oa_sub as os', 'os.oa_id', 'o.id')
  340. ->select('os.sort', 'os.type', 'os.sub_id')
  341. ->where('o.menu_id', $menu_id);
  342. if (!empty($type)) $list = $list->where('os.sort', 1);
  343. $list = $list->orderBy('os.sort')
  344. ->get()->toArray();
  345. if(empty($list)) {
  346. $this->returnOa($order_no,1,$type);
  347. return [200,''];
  348. }
  349. try {
  350. DB::beginTransaction();
  351. list($employee_ids,$oa_sub_id) = $this->oaCommon($menu_id,['order_number'=>$orderObject],1);
  352. if(empty($employee_ids)){
  353. $this->returnOa($order_no,1,$type);
  354. DB::commit();
  355. return [true,'审核成功'];
  356. }
  357. $order = new OaOrder();
  358. $order->menu_id = $menu_id;
  359. $order->order_no = $order_no;
  360. $order->opt_case = $type;
  361. $order->save();
  362. $id = $order->id;
  363. $oa_order_sub = new OaOrderSub();
  364. $oa_order_sub->oa_order_id = $id;
  365. $oa_order_sub->sort = 1;
  366. $oa_order_sub->remark = '';
  367. $oa_order_sub->type = 1;
  368. $oa_order_sub->oa_sub_id = $oa_sub_id;
  369. $oa_order_sub->save();
  370. $oa_order_sub_id = $oa_order_sub->id;
  371. $insert = [];
  372. foreach ($employee_ids as $employee_id){
  373. $insert[] = [
  374. 'oa_order_id' => $id,
  375. 'oa_order_sub_id' => $oa_order_sub_id,
  376. 'employee_id' => $employee_id,
  377. ];
  378. }
  379. OaOrderSubEmployee::insert($insert);
  380. DB::commit();
  381. return [true, '']; //success
  382. } catch (\Exception $e) {
  383. DB::rollBack();
  384. $this->returnOa($order_no,2,$type);
  385. return [false, $e->getLine().':'.$e->getMessage()];
  386. }
  387. }
  388. public function oaCommon($menu_id, $param, $sort = 1,$parent_id = 0)
  389. {
  390. $request = request();
  391. foreach ($param as $k=>$v){
  392. $request->$k = $v;
  393. }
  394. $all = $request->all();
  395. if(!isset($all['order_number'])) $request->merge($param);
  396. // $request->merge($param);
  397. $detail = $this->oaGetData($menu_id,$request);
  398. $oa_id = Oa::where('menu_id',$menu_id)->value('id');
  399. $parent_ids = [$parent_id,0];
  400. // var_dump($parent_ids);
  401. if($sort>2) {
  402. $sorts = $sort - 1;
  403. $oa_sub_ids = OaSub::where('sort','<',$sorts)->wherein('parent_id',$parent_ids)->pluck('id')->toArray();
  404. // var_dump($oa_sub_ids);die;
  405. $parent_ids = array_merge($parent_ids,$oa_sub_ids);
  406. }
  407. $list = OaSub::where('oa_id',$oa_id)->where('sort',$sort)->wherein('parent_id',$parent_ids);
  408. $list = $list->select('*')->get()->toArray();
  409. // dd($list);
  410. if(empty($list)) return [[],''];
  411. $oa_sub_ids = [];
  412. $oa_sub_key = [];
  413. foreach ($list as $v){
  414. $oa_sub_ids[] = $v['id'];
  415. $oa_sub_key[$v['id']] = $v;
  416. $rule_key_list[$v['id']] = [];
  417. }
  418. $rule_list = OaSubRule::wherein('oa_sub_id',$oa_sub_ids)->select('*')->get()->toArray();
  419. foreach ($rule_list as $v){
  420. $rule_key_list[$v['oa_sub_id']][] = $v;
  421. }
  422. //规则开始判断
  423. $employee_ids = [];
  424. $oa_sub_id = 0;
  425. foreach ($rule_key_list as $k=>$v){
  426. $status = $this->formulaRule($v,$detail);
  427. if($status){
  428. if($oa_sub_key[$k]['type'] == 2){
  429. $employee_ids = EmployeeTeamPermission::where('team_id',$oa_sub_key[$k]['sub_id'])->pluck('employee_id')->toArray();
  430. }else{
  431. $employee_ids[] = [$oa_sub_key[$k]['sub_id']];
  432. }
  433. $oa_sub_id = $k;
  434. continue;
  435. }
  436. }
  437. return [$employee_ids,$oa_sub_id];
  438. }
  439. public function formulaRule($params,$detail){
  440. $rule = '';
  441. // dd($params);
  442. if(empty($params)) return true;
  443. foreach ($params as $param){
  444. if(!$param['key']) continue;
  445. if(!empty($param['right_formula'])) $rule .= ' '.$param['right_formula'].' ';
  446. $rule .= '"'.$detail[$param['key']].'"'.' '.$param['formula'] .' '.'"'.$param['value'].'"';
  447. }
  448. // dd($rule);
  449. if(empty($rule)) return true;
  450. // var_dump($rule);
  451. if(eval("return $rule;")) {
  452. // var_dump($rule);die;
  453. return true;
  454. }
  455. else return false;
  456. }
  457. public function oaCheck($data, $user)
  458. {
  459. $user_id = $user['id'];
  460. // $user_id = '482';
  461. $id = $data['id'];
  462. $state = $data['state'];
  463. if($state == 0) $state = 2;
  464. $remark = $data['remark'];
  465. $detail = OaOrderSub::from('oa_order_sub as s')
  466. ->leftJoin('oa_order_sub_employee as e','e.oa_order_sub_id','s.id')
  467. ->where('e.employee_id',$user_id)->where('s.state',0)
  468. ->where('s.id',$id)
  469. ->select('s.oa_order_id','sort','oa_sub_id')->first();
  470. if(empty($detail)) return [false,'没有审核权限'];
  471. $detail = $detail->toArray();
  472. $oaOrder = OaOrder::where('id',$detail['oa_order_id'])->first();
  473. try {
  474. DB::beginTransaction();
  475. switch ($state) {
  476. case 1:
  477. $sort = $detail['sort'] + 1;
  478. list($employee_ids,$oa_sub_id) = $this->oaCommon($oaOrder->menu_id, ['order_number' => $oaOrder->order_no], $sort,$detail['oa_sub_id']);
  479. // var_dump($employee_ids);
  480. // var_dump($oa_sub_id);die;
  481. if (empty($employee_ids)) {
  482. $oaOrder->state = 2;
  483. $oaOrder->save();
  484. $this->returnOa($oaOrder->order_no, 1, $oaOrder->opt_case);
  485. } else {
  486. $oaOrder->state = 1;
  487. $oaOrder->save();
  488. $oa_order_sub = new OaOrderSub();
  489. $oa_order_sub->oa_order_id = $oaOrder->id;
  490. $oa_order_sub->sort = $sort;
  491. $oa_order_sub->remark = '';
  492. $oa_order_sub->type = 1;
  493. $oa_order_sub->oa_sub_id = $oa_sub_id;
  494. $oa_order_sub->save();
  495. $oa_order_sub_id = $oa_order_sub->id;
  496. $insert = [];
  497. foreach ($employee_ids as $employee_id) {
  498. $insert[] = [
  499. 'oa_order_id' => $oaOrder->id,
  500. 'oa_order_sub_id' => $oa_order_sub_id,
  501. 'employee_id' => $employee_id,
  502. ];
  503. }
  504. OaOrderSubEmployee::insert($insert);
  505. }
  506. break;
  507. case 2:
  508. if ($detail['sort'] == 1) {
  509. $oaOrder->state = 3;
  510. $oaOrder->save();
  511. $this->returnOa($oaOrder->order_no, 2, $oaOrder->opt_case);
  512. }
  513. OaOrderSub::where('sort', ($detail['sort'] - 1))->where('oa_order_id', $oaOrder->id)->update([
  514. 'state' => 0,
  515. 'remark' => $remark,
  516. ]);
  517. break;
  518. }
  519. OaOrderSub::where('id', $id)->update([
  520. 'state' => $state,
  521. 'remark' => $remark,
  522. ]);
  523. DB::commit();
  524. return [true,'操作成功!'];
  525. } catch (\Exception $e) {
  526. DB::rollBack();
  527. return [false, $e->getLine().':'.$e->getMessage()];
  528. }
  529. }
  530. public function returnOa($order_no,$type,$opt_case){
  531. $service = new CheckService();
  532. $service->createRecordAndInventory([
  533. 'order_number' => $order_no,
  534. 'type' => $type,
  535. 'opt_case' => $opt_case,
  536. ]);
  537. }
  538. public function oaGetData($menu_id,$request)
  539. {
  540. $api = SysMenu::where('id',$menu_id)->value('api');
  541. $path = $this->getMenu();
  542. $control = '\\'.$path[$api]["controller"];
  543. $act = $path[$api]["act"];
  544. $new = new $control();
  545. $detail = $new->$act($request);
  546. // if(!isset($detail['data']['data'][0])) $detail['data']['data'][0] = $detail['data'];
  547. return $detail['data']['data'][0];
  548. }
  549. public function getMenu(){
  550. $app = App();
  551. $routes = $app->routes->getRoutes();
  552. $path = [];
  553. foreach ($routes as $k => $value) {
  554. if(!isset($value->action['controller'])) continue;
  555. $act = explode('@',$value->action['controller']);
  556. if(!isset($act[1])) continue;
  557. $path[$value->uri]['act'] = $act[1];
  558. $path[$value->uri]['controller'] = $act[0];
  559. }
  560. return $path;
  561. }
  562. public function oaOrderList($data){
  563. $order_no = $data['order_no'];
  564. $menu_id = $data['menu_id'];
  565. $oa = OaOrder::where('order_no',$order_no)->where('menu_id',$menu_id)->first();
  566. if(empty($oa)) return [false,'审核不存在'];
  567. $list = OaOrderSub::where('oa_order_id',$oa->id)->orderBy('sort','asc')->select('*')->get()->toArray();
  568. return [true,$list];
  569. }
  570. public function oaOrderState($data,$user){
  571. $user_id = $user->id;
  572. $order_no = $data['order_no'];
  573. $menu_id = $data['menu_id'];
  574. $detail = OaOrder::where('order_no',$order_no)->orderBy('id','desc')->where('menu_id',$menu_id)->first();
  575. if(empty($detail)) return [false,'审核不存在'];
  576. if($detail->state == 2) return [true,['state'=>0]];
  577. $oa_detail = OaOrderSubEmployee::where('employee_id',$user_id)->where('oa_order_id',$detail->id)->pluck('oa_order_sub_id')->toArray();
  578. if(empty($oa_detail)) return [true ,['state'=>0]];
  579. $state = OaOrderSub::wherein('id',$oa_detail)->where('state','<>',2)->orderBy('sort','desc')->first();
  580. if(in_array($state->state,[0,2])) return [true,['state'=> 1,'id'=>$state->id]];
  581. return [true,['state'=> 0]];
  582. }
  583. public function checkAllOver($data){
  584. $order_no = $data['order_number'];
  585. $menu_id = $data['menu_id'];
  586. $op_case = $data['opt_case'];
  587. // $oaOrder = OaOrder::where('order_no',$order_no)->first();
  588. // $id = OaOrderSub::where('oa_order_id',$oaOrder->id)->orderBy('id','desc')->value('id');
  589. // OaOrderSub::where('id',$id)->update([
  590. // 'state' => 1
  591. // ]);
  592. // $oaOrder->state = 1;
  593. // $oaOrder->save();
  594. $this->returnOa($order_no,3,$op_case);
  595. return [true,'弃审成功'];
  596. }
  597. public function oaCheckMove($data,$user_id){
  598. $id = $data['id'];
  599. $employee_id = $data['employee_id'];
  600. if(empty($employee_id)) return [false,'用户不存在'];
  601. $oaOrderSub = OaOrderSub::where('id',$id)->first();
  602. OaOrderSubEmployee::where('oa_order_sub_id',$oaOrderSub->id)->delete();
  603. $add = [
  604. 'oa_order_id' => $oaOrderSub->oa_order_id,
  605. 'oa_order_sub_id' => $oaOrderSub->id,
  606. 'employee_id' => $employee_id
  607. ];
  608. $oaOrder = OaOrder::where('id',$oaOrderSub->oa_order_id)->first();
  609. OaOrderSubEmployee::insert($add);
  610. Construction::where('order_number',$oaOrder->order_no)->update([
  611. 'is_transfer' => 1
  612. ]);
  613. // $this->returnOa($order_no,3,$op_case);
  614. return [true,'转签成功'];
  615. }
  616. public function oaSubUserDetail($data){
  617. $order_no = $data['order_no'];
  618. $first = OaOrder::where('order_no',$order_no)->first();
  619. if(empty($first)) return [true,[]];
  620. $oa_order_id = $first->id;
  621. $oa_order_sub_id = OaOrderSub::where('oa_order_id',$oa_order_id)->orderBy('sort','desc')->value('id');
  622. $employee_list = Employee::pluck('emp_name','id')->toArray();
  623. $oa_order_sub_employee_ids = OaOrderSubEmployee::where('oa_order_sub_id',$oa_order_sub_id)->pluck('employee_id')->toArray();
  624. $list = [];
  625. foreach ($oa_order_sub_employee_ids as $v){
  626. $list[] = $employee_list[$v];
  627. }
  628. // $this->returnOa($order_no,3,$op_case);
  629. return [true,$list];
  630. }
  631. public function oaGetTeamDetail($data){
  632. $order_no = $data['order_no'];
  633. $oa_order_id = OaOrder::where('order_no',$order_no)->pluck('id')->toArray();
  634. if(empty($oa_order_id)) return [true,[]];
  635. // $oa_order_id = $first->id;
  636. $list = OaOrderSub::wherein('oa_order_id',$oa_order_id)->select('*')->orderBy('id','asc')->get()->toArray();
  637. $team_key_list = Team::pluck('title','id')->toArray();
  638. $oa_sub_ids = [];
  639. foreach ($list as $v){
  640. $oa_sub_ids[] = $v['oa_sub_id'];
  641. }
  642. $team_ids = OaSub::wherein('id',$oa_sub_ids)->pluck('sub_id','id')->toArray();
  643. $return = [];
  644. foreach ($list as $v){
  645. $return[] = [
  646. 'sort' => $v['sort'],
  647. 'team' => $team_key_list[$team_ids[$v['oa_sub_id']]],
  648. 'remark' => $v['remark']?? '',
  649. 'state' => $v['state'],
  650. ];
  651. }
  652. // $this->returnOa($order_no,3,$op_case);
  653. return [true,$return];
  654. }
  655. public function oaSubRemark($data){
  656. $order_no = $data['order_no'];
  657. $first = OaOrder::where('del_time',0)->where('order_no',$order_no)->orderBy('id','desc')->first();
  658. if(empty($first)) return [true,[]];
  659. $oa_order_id = $first->id;
  660. $remark = OaOrderSub::where('oa_order_id',$oa_order_id)->orderBy('sort','desc')->value('remark');
  661. // $this->returnOa($order_no,3,$op_case);
  662. return [true,$remark];
  663. }
  664. }