DrbService.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474
  1. <?php
  2. namespace App\Service;
  3. use App\Model\DDEmployee;
  4. use App\Model\Record;
  5. use Illuminate\Support\Facades\Redis;
  6. class DrbService extends Service
  7. {
  8. const RedisKey = 'DRBACCESSTOKENKEY';
  9. public function getAccessToken()
  10. {
  11. $token = Redis::get(self::RedisKey);
  12. if(! empty($token)) return [true, ['access_token' => $token]];
  13. $appKey = config('dingtalk.app_key');
  14. $appSecret = config('dingtalk.app_secret');
  15. $url = "https://api.dingtalk.com/v1.0/oauth2/accessToken";
  16. $resp = $this->curlOpen1($url, [
  17. 'request' => 'post',
  18. 'header' => ['Content-Type: application/json'],
  19. 'json' => [
  20. "appKey" => $appKey,
  21. "appSecret" => $appSecret
  22. ]
  23. ]);
  24. $res = json_decode($resp, true);
  25. $accessToken = $res['accessToken'] ?? "";
  26. $expires_in = $res['expires_in'] ?? 0;
  27. if(empty($accessToken)) return [false, 'AccessToken获取失败'];
  28. Redis::setex(self::RedisKey, $expires_in, $accessToken);
  29. return [true, ['access_token' => $accessToken]];
  30. }
  31. /**
  32. * 根据前端传来的免登 code 获取用户信息
  33. * @param string $code 前端 dd.getAuthCode 获取的 code
  34. * @return array [bool, data] bool 表示成功与否,data 成功返回用户信息,失败返回错误信息
  35. */
  36. public function getUserByCode($data)
  37. {
  38. $code = $data['code'] ?? "";
  39. if (empty($code)) return [false, '钉钉授权code不能为空'];
  40. // 1. 获取 access_token
  41. [$success, $tokenData] = $this->getAccessToken();
  42. if (! $success) return [false, $tokenData]; // tokenData 是错误信息
  43. $accessToken = $tokenData['access_token'];
  44. // 2. 用 code 换取用户信息(v2 接口)
  45. $url = "https://oapi.dingtalk.com/topapi/v2/user/getuserinfo?access_token={$accessToken}";
  46. $resp = $this->curlOpen1($url, [
  47. 'request' => 'post',
  48. 'header' => [
  49. "Content-Type: application/json",
  50. ],
  51. 'json' => [
  52. "code" => $code
  53. ]
  54. ]);
  55. $res = json_decode($resp, true);
  56. if (!isset($res['errcode'])) {
  57. return [false, '接口返回异常: ' . $resp];
  58. }
  59. if ($res['errcode'] !== 0) {
  60. return [false, '获取用户信息失败: ' . $res['errmsg']];
  61. }
  62. if(! empty($res['result'])){
  63. $result = $res['result'];
  64. DDEmployee::updateOrCreate(
  65. ['userid' => $result['userid']],
  66. ['name' => $result['name'], 'userid' => $result['userid']]
  67. );
  68. }
  69. return [true, $res];
  70. }
  71. private function getManDetail($user, $accessToken){
  72. // 3. 根据 userid 获取详细用户信息(包括部门)
  73. $urlDetail = "https://oapi.dingtalk.com/topapi/v2/user/get?access_token={$accessToken}";
  74. $respDetail = $this->curlOpen1($urlDetail, [
  75. 'request' => 'post',
  76. 'header' => ["Content-Type: application/json"],
  77. 'json' => ["userid" => $user['userId']]
  78. ]);
  79. $detail = json_decode($respDetail, true);
  80. if (!isset($detail['errcode'])) return [false, '获取用户详情接口异常: ' . $respDetail];
  81. if ($detail['errcode'] !== 0) return [false, '获取用户详情失败: ' . $detail['errmsg']];
  82. if (empty($detail['result'])) return [false, '获取用户详情失败,结果为空'];
  83. // 返回完整用户信息
  84. return [true, $detail['result']];
  85. }
  86. public function createProcessInstance($data, $user)
  87. {
  88. if(empty($data['type'])) return [false, '单据类型不能为空'];
  89. $type = $data['type'];
  90. if(empty($data['order_number'])) return [false,'订单号不能为空'];
  91. [$success, $msg] = $this->checkCreateProcessInstance($data, $user);
  92. if(! $success) return [false, $msg];
  93. //获取模板id
  94. $code = $this->getModelCode($type);
  95. //获取模板数据
  96. [$success, $formData] = $this->getFormData($data, $user);
  97. if(! $success) return [false, $formData];
  98. // 1. 获取 access_token
  99. [$success, $tokenData] = $this->getAccessToken();
  100. if (!$success) return [false, $tokenData];
  101. $accessToken = $tokenData['access_token'];
  102. $userId = $user['userId'];
  103. [$success, $userDetail] = $this->getManDetail($user, $accessToken);
  104. if(!$success) return [false, $userDetail];
  105. //创建审批
  106. [$success, $msg] = $this->createFlow($accessToken, $code, $userId, $userDetail, $formData);
  107. if(! $success) return [false, $msg];
  108. //记录信息
  109. $this->recordDatabase($data, $user, $msg);
  110. return [true, ''];
  111. }
  112. private function recordDatabase($data, $user, $process_instance_id){
  113. $type = $data['type'];
  114. Record::insert([
  115. 'type' => $type,
  116. 'database' => $user['zt_database'],
  117. 'order_number'=> $data['order_number'],
  118. 'crt_time' => time(),
  119. 'process_instance_id' => $process_instance_id
  120. ]);
  121. return [true, ''];
  122. }
  123. private function checkCreateProcessInstance($data, $user){
  124. list($status,$msg) = $this->limitingSendRequestBackgExpire($data['order_number'].$data['type'].$user['zt_database']);
  125. if(! $status) return [false,$msg];
  126. $type = $data['type'];
  127. $bool = Record::where('del_time',0)
  128. ->where('type', $type)
  129. ->where('database', $user['zt_database'])
  130. ->where('order_number',$data['order_number'])
  131. ->exists();
  132. if($bool) return [false, '单号' . $data['order_number'] . '已创建审批流'];
  133. return [true, ''];
  134. }
  135. private function createFlow($accessToken, $code, $userId, $userDetail, $formData){
  136. // 2. 请求 URL
  137. $url = "https://oapi.dingtalk.com/topapi/processinstance/create?access_token={$accessToken}";
  138. // 3. 请求体
  139. $payload = [
  140. "process_code" => $code, // 审批模板编码
  141. "originator_user_id" => $userId, // 发起人 userId
  142. "dept_id" => $userDetail['dept_id_list'][0], // 发起人部门 ID
  143. "form_component_values" => $formData, // 表单数据
  144. ];
  145. // 4. 发送请求
  146. $resp = $this->curlOpen1($url, [
  147. 'request' => 'post',
  148. 'header' => [
  149. "Content-Type: application/json",
  150. ],
  151. 'json' => $payload
  152. ]);
  153. $res = json_decode($resp, true);
  154. if (!isset($res['errcode'])) {
  155. return [false, "接口返回异常: " . $resp];
  156. }
  157. if ($res['errcode'] !== 0) {
  158. return [false, "创建审批实例失败: " . $res['errmsg']];
  159. }
  160. return [true, $res['process_instance_id']];
  161. }
  162. private function getModelCode($type){
  163. if($type == 1){
  164. // 采购单
  165. $code = "PROC-61E1D916-C7BE-4DE2-9D25-63505D8573B1";
  166. }elseif ($type == 2){
  167. // 请购单
  168. $code = "PROC-4FECC44D-993C-48E3-8623-CDC75B467622";
  169. }else{
  170. // 付款单
  171. $code = "PROC-F6D0C212-D8C6-4662-9AFD-EA9DE85A1F14";
  172. }
  173. return $code;
  174. }
  175. private function getFormData($data, $user){
  176. //cs
  177. // $formData = [ [ "name" => "订单日期", "value" => "2025-09-23" ], [ "name" => "订单编号", "value" => "PO20250923001" ], [ "name" => "业务类型", "value" => "标准采购" ], [ "name" => "供应商", "value" => "XX供应商有限公司" ], [ "name" => "制单人", "value" => "陈庆鹏" ], [ "name" => "表体", "value" => json_encode([ [ [ "name" => "存货名称", "value" => "打印机" ], [ "name" => "数量", "value" => "2" ], [ "name" => "主计量单位", "value" => "台" ], [ "name" => "原币价税合计", "value" => "3000" ] ], [ [ "name" => "存货名称", "value" => "显示器" ], [ "name" => "数量", "value" => "5" ], [ "name" => "主计量单位", "value" => "个" ], [ "name" => "原币价税合计", "value" => "5000" ] ] ], JSON_UNESCAPED_UNICODE) ] ];
  178. // return [true, $formData];
  179. //cs
  180. $service = new U8ServerService($user);
  181. $error = $service->getError();
  182. if(! empty($error)) return [false, $error];
  183. [$success, $order] = $service->getOrderDetails($data, $user);
  184. if(! $success) return [false, $order];
  185. $type = $data['type'];
  186. if($type == 1){
  187. // 采购单
  188. $formData = $this->typeOne($order);
  189. }elseif ($type == 2){
  190. // 请购单
  191. $formData = $this->typeTwo($order);
  192. }else{
  193. // 付款单
  194. $formData = $this->typeThree($order);
  195. }
  196. if(empty($formData)) return [false, '审批参数不能为空'];
  197. return [true, $formData];
  198. }
  199. private function typeOne($userOrder){
  200. if (empty($userOrder)) return [];
  201. $formData = [
  202. [
  203. "name" => "订单日期",
  204. "value" => date('Y-m-d', strtotime($userOrder['order_date'] ?? ''))
  205. ],
  206. [
  207. "name" => "订单编号",
  208. "value" => $userOrder['order_number'] ?? ''
  209. ],
  210. [
  211. "name" => "业务类型",
  212. "value" => $userOrder['business_type'] ?? ''
  213. ],
  214. [
  215. "name" => "供应商",
  216. "value" => $userOrder['supplier_title'] ?? ''
  217. ],
  218. [
  219. "name" => "制单人",
  220. "value" => $userOrder['crt_name'] ?? ''
  221. ],
  222. [
  223. "name" => "表体", // 对应 TableField 的 label
  224. "value" => json_encode(
  225. array_map(function($item){
  226. return [
  227. [
  228. "name" => "存货名称",
  229. "value" => $item['product_title'] ?? ''
  230. ],
  231. [
  232. "name" => "数量",
  233. "value" => $item['quantity'] ?? 0
  234. ],
  235. [
  236. "name" => "主计量", // 修改这里,对应模板字段
  237. "value" => $item['unit_title'] ?? ''
  238. ],
  239. [
  240. "name" => "原币价税合计",
  241. "value" => $item['amount'] ?? 0
  242. ]
  243. ];
  244. }, $userOrder['detail'] ?? []),
  245. JSON_UNESCAPED_UNICODE
  246. )
  247. ]
  248. ];
  249. return $formData;
  250. }
  251. private function typeTwo($userOrder){
  252. if (empty($userOrder)) return [];
  253. $formData = [
  254. [
  255. "name" => "单据号",
  256. "value" => $userOrder['order_number'] ?? ''
  257. ],
  258. [
  259. "name" => "日期",
  260. "value" => date('Y-m-d', strtotime($userOrder['order_date'] ?? ''))
  261. ],
  262. [
  263. "name" => "业务类型",
  264. "value" => $userOrder['business_type'] ?? ''
  265. ],
  266. [
  267. "name" => "请购人",
  268. "value" => $userOrder['purchase_name'] ?? ''
  269. ],
  270. [
  271. "name" => "制单人",
  272. "value" => $userOrder['crt_name'] ?? ''
  273. ],
  274. [
  275. "name" => "表体", // 对应 TableField 的 label
  276. "value" => json_encode(
  277. array_map(function($item){
  278. return [
  279. [
  280. "name" => "存货名称",
  281. "value" => $item['product_title'] ?? ''
  282. ],
  283. [
  284. "name" => "数量",
  285. "value" => $item['quantity'] ?? 0
  286. ],
  287. [
  288. "name" => "主计量", // 修改这里,对应模板字段
  289. "value" => $item['unit_title'] ?? ''
  290. ],
  291. [
  292. "name" => "要求到货日期",
  293. "value" => $item['need_arrived_date'] ?? ''
  294. ]
  295. ];
  296. }, $userOrder['detail'] ?? []),
  297. JSON_UNESCAPED_UNICODE
  298. )
  299. ]
  300. ];
  301. return $formData;
  302. }
  303. private function typeThree($userOrder){
  304. if (empty($userOrder)) return [];
  305. $formData = [
  306. [
  307. "name" => "单据编号",
  308. "value" => $userOrder['order_number'] ?? ''
  309. ],
  310. [
  311. "name" => "日期",
  312. "value" => date('Y-m-d', strtotime($userOrder['order_date'] ?? ''))
  313. ],
  314. [
  315. "name" => "供应商",
  316. "value" => $userOrder['supplier_title'] ?? ''
  317. ],
  318. [
  319. "name" => "制单人",
  320. "value" => $userOrder['crt_name'] ?? ''
  321. ],
  322. [
  323. "name" => "表体", // 对应 TableField 的 label
  324. "value" => json_encode(
  325. array_map(function($item){
  326. return [
  327. [
  328. "name" => "来源",
  329. "value" => $item['source'] ?? ''
  330. ],
  331. [
  332. "name" => "来源单据号",
  333. "value" => $item['source_order_number'] ?? ''
  334. ],
  335. [
  336. "name" => "主计量", // 修改这里,对应模板字段
  337. "value" => $item['unit_title'] ?? ''
  338. ],
  339. [
  340. "name" => "申请金额",
  341. "value" => $item['amount'] ?? 0
  342. ]
  343. ];
  344. }, $userOrder['detail'] ?? []),
  345. JSON_UNESCAPED_UNICODE
  346. )
  347. ]
  348. ];
  349. return $formData;
  350. }
  351. public function getTemplateFields($data)
  352. {
  353. $processCode = $data['code'] ?? "";
  354. if (empty($processCode)) {
  355. return [false, '模板编号 process_code 不能为空'];
  356. }
  357. [$ok, $tokenData] = $this->getAccessToken();
  358. if (! $ok) return [false, $tokenData];
  359. $accessToken = $tokenData['access_token'];
  360. // 注意这里是 GET,并且 processCode 是 query 参数
  361. $url = "https://api.dingtalk.com/v1.0/workflow/forms/schemas/processCodes?processCode={$processCode}";
  362. $resp = $this->curlOpen1($url, [
  363. 'request' => 'get',
  364. 'header' => [
  365. "Content-Type: application/json",
  366. "x-acs-dingtalk-access-token: {$accessToken}"
  367. ],
  368. ]);
  369. $res = json_decode($resp, true);
  370. if (isset($res['schemas'])) {
  371. return [true, $res['schemas']];
  372. } else {
  373. return [false, $res];
  374. }
  375. }
  376. protected function curlOpen1($url, $config = [])
  377. {
  378. $default = [
  379. 'post' => false,
  380. 'request' => 'get',
  381. 'header' => [],
  382. 'json' => null,
  383. 'timeout' => 30
  384. ];
  385. $arr = array_merge($default, $config);
  386. $ch = curl_init();
  387. curl_setopt($ch, CURLOPT_URL, $url);
  388. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  389. curl_setopt($ch, CURLOPT_TIMEOUT, $arr['timeout']);
  390. curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
  391. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  392. if (!empty($arr['header'])) {
  393. curl_setopt($ch, CURLOPT_HTTPHEADER, $arr['header']);
  394. }
  395. if ($arr['post'] || $arr['request'] !== 'get') {
  396. curl_setopt($ch, CURLOPT_CUSTOMREQUEST, strtoupper($arr['request']));
  397. if ($arr['json'] !== null) {
  398. curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($arr['json'], JSON_UNESCAPED_UNICODE));
  399. }
  400. }
  401. $result = curl_exec($ch);
  402. if ($result === false) {
  403. $err = curl_error($ch);
  404. curl_close($ch);
  405. return json_encode(['error' => $err]);
  406. }
  407. curl_close($ch);
  408. return $result;
  409. }
  410. }