PayDetailController.php 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701
  1. <?php
  2. namespace app\admin\controller\order;
  3. use app\admin\controller\notify\RechargeController;
  4. use app\admin\service\member\MemberService;
  5. use app\controller\Curd;
  6. use app\model\Goods;
  7. use app\model\GoodsSku;
  8. use app\model\Member;
  9. use app\model\MemberAccount;
  10. use app\model\Order;
  11. use app\model\OrderSheet;
  12. use app\model\PayDetail;
  13. use app\model\SysDept;
  14. use support\Db;
  15. use support\exception\BusinessException;
  16. use support\Request;
  17. use support\Response;
  18. use Webman\Event\Event;
  19. use function PHPSTORM_META\type;
  20. class PayDetailController extends Curd
  21. {
  22. public function __construct()
  23. {
  24. $this->model = new PayDetail();
  25. }
  26. public function select(Request $request): Response
  27. {
  28. [$where, $format, $limit, $field, $order] = $this->selectInput($request);
  29. $order = $request->get('order', 'desc');
  30. $field = $field ?? 'pay_addtimes';
  31. // $where['pay_status'] = 'SUCCESS';
  32. if ($where['pay_category'] == 'OTHER') {
  33. $where['pay_status'] = 'SUCCESS';
  34. $where['pay_category'] = ['<>', 'RECHARGE'];
  35. } elseif ($where['pay_category'] == 'RECHARGE') {
  36. $where['pay_category'] = ['in', ['RECHARGE', 'VIP']];
  37. }
  38. if (!empty($where['pay_addtimes'])) {
  39. $where['pay_addtimes'][0] = !empty($where['pay_addtimes'][0]) ? strtotime($where['pay_addtimes'][0]) : '';
  40. $where['pay_addtimes'][1] = !empty($where['pay_addtimes'][1]) ? strtotime($where['pay_addtimes'][1]) : '';
  41. }
  42. if (!empty($request->get('premises_id'))) {
  43. $payIds = PayDetail::whereJsonContains('pay_extend_json->remark->premises_id', intval($request->get('premises_id')))
  44. ->pluck('pay_id')
  45. ->toArray();
  46. $where['pay_id'] = '';
  47. if (!empty($payIds)) {
  48. $where['pay_id'] = ['in', $payIds];
  49. }
  50. }
  51. // else if ($where['pay_category'] == 'RECHARGE') {
  52. // $where['pay_status'] = 'SUCCESS';
  53. // $where['pay_category'] = 'RECHARGE';
  54. // $where['pay_prepayid'] = ['in','WXPAY,ALIPAY'];
  55. // }
  56. $query = $this->doSelect($where, $field, $order, $request->get());
  57. return $this->doFormat($query, $format, $limit);
  58. }
  59. protected function doSelect(array $where, string $field = null, string $order = 'desc', $params = [])
  60. {
  61. $model = $this->model->with(['member', 'cert', 'memberAccount']);
  62. foreach ($where as $column => $value) {
  63. if (is_array($value)) {
  64. if ($value[0] === 'like' || $value[0] === 'not like') {
  65. $model = $model->where($column, $value[0], "%$value[1]%");
  66. } elseif (in_array($value[0], ['>', '=', '<', '<>'])) {
  67. $model = $model->where($column, $value[0], $value[1]);
  68. } elseif ($value[0] == 'in' && !empty($value[1])) {
  69. $valArr = $value[1];
  70. if (is_string($value[1])) {
  71. $valArr = explode(",", trim($value[1]));
  72. }
  73. $model = $model->whereIn($column, $valArr);
  74. } elseif ($value[0] == 'not in' && !empty($value[1])) {
  75. $valArr = $value[1];
  76. if (is_string($value[1])) {
  77. $valArr = explode(",", trim($value[1]));
  78. }
  79. $model = $model->whereNotIn($column, $valArr);
  80. } elseif ($value[0] == 'null') {
  81. $model = $model->whereNull($column);
  82. } elseif ($value[0] == 'not null') {
  83. $model = $model->whereNotNull($column);
  84. } elseif ($value[0] !== '' || $value[1] !== '') {
  85. $model = $model->whereBetween($column, $value);
  86. }
  87. } else {
  88. $model = $model->where($column, $value);
  89. }
  90. }
  91. if (empty($params['type'])) {
  92. $model = $model->where(function ($query) {
  93. $query->whereIn('pay_prepayid', ['ALIPAY', 'WXPAY', 'OFFLINE', 'OFFLINE_WXPAY', 'OFFLINE_ALIPAY', 'MONEY'])
  94. ->orWhere('pay_prepayid', 'like', '%CASH%')
  95. ->orWhere('pay_prepayid', 'like', '%WELFARE%');
  96. });
  97. } else {
  98. if ($params['type'] == 'NORMAL') {
  99. $model = $model->where(function ($query) {
  100. $query->whereIn('pay_prepayid', ['ALIPAY', 'WXPAY', 'OFFLINE_WXPAY', 'OFFLINE_ALIPAY', 'MONEY'])
  101. ->orWhere('pay_prepayid', 'like', '%CASH%');
  102. });
  103. } else if ($params['type'] == 'VIP') {
  104. $model = $model->where(function ($query) {
  105. $query->orWhere('pay_category', 'VIP');
  106. });
  107. } else {
  108. $model = $model->where(function ($query) {
  109. $query->orWhere('pay_prepayid', 'like', '%WELFARE%');
  110. });
  111. }
  112. }
  113. if (!empty($params['order_type'])) {
  114. if ($params['order_type'] == 'COMBINE') {
  115. $model = $model->where('join_pay_order_id', 'COMBINE');
  116. } elseif ($params['order_type'] == 'PARTNER') {
  117. $model = $model->where('join_pay_order_id', 'PARTNER');
  118. } elseif ($params['order_type'] == 'VIP') {
  119. $model = $model->where('pay_category', 'VIP');
  120. } elseif ($params['order_type'] == 'RECHARGE') {
  121. $model = $model->where('join_pay_order_id', '<>', 'PARTNER')
  122. ->where('join_pay_order_id', '<>', 'COMBINE')
  123. ->where('pay_category', '<>', 'VIP');
  124. }
  125. }
  126. if ($field) {
  127. $model = $model->orderBy($field, $order);
  128. }
  129. return $model;
  130. }
  131. public function selectWelfare(Request $request): Response
  132. {
  133. [$where, $format, $limit, $field, $order] = $this->selectInput($request);
  134. $order = $request->get('order', 'desc');
  135. $field = $field ?? 'pay_addtimes';
  136. // $where['pay_status'] = 'SUCCESS';
  137. if ($where['pay_category'] == 'OTHER') {
  138. $where['pay_status'] = 'SUCCESS';
  139. $where['pay_category'] = ['<>', 'RECHARGE'];
  140. }
  141. // else if ($where['pay_category'] == 'RECHARGE') {
  142. // $where['pay_status'] = 'SUCCESS';
  143. // $where['pay_category'] = 'RECHARGE';
  144. // $where['pay_prepayid'] = ['in','WXPAY,ALIPAY'];
  145. // }
  146. $query = $this->doSelectWelfare($where, $field, $order);
  147. return $this->doFormat($query, $format, $limit);
  148. }
  149. protected function doSelectWelfare(array $where, string $field = null, string $order = 'desc')
  150. {
  151. $model = $this->model->with(['member', 'cert', 'memberAccount']);
  152. foreach ($where as $column => $value) {
  153. if (is_array($value)) {
  154. if ($value[0] === 'like' || $value[0] === 'not like') {
  155. $model = $model->where($column, $value[0], "%$value[1]%");
  156. } elseif (in_array($value[0], ['>', '=', '<', '<>'])) {
  157. $model = $model->where($column, $value[0], $value[1]);
  158. } elseif ($value[0] == 'in' && !empty($value[1])) {
  159. $valArr = $value[1];
  160. if (is_string($value[1])) {
  161. $valArr = explode(",", trim($value[1]));
  162. }
  163. $model = $model->whereIn($column, $valArr);
  164. } elseif ($value[0] == 'not in' && !empty($value[1])) {
  165. $valArr = $value[1];
  166. if (is_string($value[1])) {
  167. $valArr = explode(",", trim($value[1]));
  168. }
  169. $model = $model->whereNotIn($column, $valArr);
  170. } elseif ($value[0] == 'null') {
  171. $model = $model->whereNull($column);
  172. } elseif ($value[0] == 'not null') {
  173. $model = $model->whereNotNull($column);
  174. } elseif ($value[0] !== '' || $value[1] !== '') {
  175. $model = $model->whereBetween($column, $value);
  176. }
  177. } else {
  178. $model = $model->where($column, $value);
  179. }
  180. }
  181. $model = $model->where(function ($query) {
  182. $query->Where('pay_prepayid', 'like', '%WELFARE%');
  183. });
  184. if ($field) {
  185. $model = $model->orderBy($field, $order);
  186. }
  187. return $model;
  188. }
  189. public function afterQuery($items)
  190. {
  191. foreach ($items as &$item) {
  192. $prepayId = explode('-', $item->pay_prepayid);
  193. $item->order_classify = $item->pay_category;
  194. if (count($prepayId) > 1) {
  195. $item->pay_prepayid = $prepayId[1];
  196. }
  197. $item->type = 'NORMAL';
  198. if (isset($prepayId[1]) && $prepayId[1] == 'WELFARE') {
  199. $item->type = 'WELFARE';
  200. } else if ($item->pay_category == 'VIP') {
  201. $item->type = 'VIP';
  202. }
  203. $memberAccount = [];
  204. if (!empty($item->memberAccount)) {
  205. foreach ($item->memberAccount as $account) {
  206. $memberAccount[strtolower($account->member_account_classify)] = $account;
  207. }
  208. $item->memberAccount = $memberAccount;
  209. }
  210. if (!empty($item->pay_extend_json)) {
  211. $payExtendJson = json_decode($item->pay_extend_json, true);
  212. if (isset($payExtendJson['remark'])) {
  213. $item->service = $payExtendJson['remark']['service'] ?? '';
  214. $item->business = $payExtendJson['remark']['business'] ?? '';
  215. $item->premises_id = $payExtendJson['remark']['premises_id'] ?? '';
  216. $item->premises_name = $payExtendJson['remark']['premises_name'] ?? '';
  217. }
  218. }
  219. $item->to_account_amount = $item->pay_amount;
  220. if (in_array($item['join_pay_order_id'], ['COMBINE', 'PARTNER']) && !empty($item->join_pay_object_json)) {
  221. $item->order_classify = $item['join_pay_order_id'];
  222. $payObjectJson = json_decode($item->join_pay_object_json, true);
  223. if (isset($payObjectJson['recharge_order_id'])) {
  224. $payDetails = PayDetail::whereJsonContains('join_pay_object_json->order_id', $payObjectJson['recharge_order_id'])
  225. ->where('pay_status', 'SUCCESS')
  226. ->get()
  227. ->toArray();
  228. if (count($payDetails) > 1) {
  229. $item->pay_prepayid = 'BY_STAGES';
  230. } else if (count($payDetails) == 1) {
  231. $item->pay_prepayid = $payDetails[0]['pay_prepayid'];
  232. }
  233. $item->pay_amount = PayDetail::whereJsonContains('join_pay_object_json->order_id', $payObjectJson['recharge_order_id'])
  234. ->where('pay_status', 'SUCCESS')
  235. ->sum('pay_amount');
  236. $orderStatus = OrderSheet::where('join_sheet_order_id', $payObjectJson['recharge_order_id'])->value('order_sheet_status');
  237. if ($orderStatus == 'BEING') {
  238. $item->pay_status = 'BEING';
  239. }
  240. }
  241. // $payDetail = PayDetail::where('join_pay_member_id', $item->join_pay_member_id)
  242. // ->where('pay_category', $item['join_pay_order_id'])
  243. // ->select('pay_amount', 'join_pay_object_json')
  244. // ->first();
  245. // $item->pay_amount = $payDetail->pay_amount ?? 0;
  246. // if (!empty($payDetail->join_pay_object_json)) {
  247. // $payObjectJson = json_decode($payDetail->join_pay_object_json, true);
  248. // if (isset($payObjectJson['order_id'])) {
  249. // $orderStatus = OrderSheet::where('join_sheet_order_id', $payObjectJson['order_id'])->value('order_sheet_status');
  250. // if ($orderStatus == 'BEING') {
  251. // $item->pay_status = 'BEING';
  252. // }
  253. // }
  254. // }
  255. }
  256. if ($item->pay_category == 'VIP') {
  257. $payObjectJson = json_decode($item->join_pay_object_json, true);
  258. if (isset($payObjectJson['order_id'])) {
  259. $orderStatus = OrderSheet::where('join_sheet_order_id', $payObjectJson['order_id'])->value('order_sheet_status');
  260. if ($orderStatus == 'BEING') {
  261. $item->pay_status = 'BEING';
  262. }
  263. }
  264. }
  265. }
  266. return $items;
  267. }
  268. /**
  269. * @Desc 产品订单
  270. * @Author Gorden
  271. * @Date 2024/6/5 10:10
  272. *
  273. * @param Request $request
  274. * @return Response
  275. */
  276. public function goodsOrder(Request $request)
  277. {
  278. $orderId = $request->get('order_id', '');
  279. $memberId = $request->get('member_id', '');
  280. if (!$orderId || !$memberId) {
  281. return json_fail('参数异常');
  282. }
  283. $orderSheet = OrderSheet::with([
  284. 'order' => function ($query) {
  285. $query->select('order_id', 'order_amount_total', 'order_amount_pay', 'order_is_complete', 'order_category', 'order_status_system', 'order_status_payment', 'order_status_storage', 'order_addtimes');
  286. },
  287. 'goods' => function ($query) {
  288. $query->select('goods_id', 'goods_name', 'goods_status', 'goods_market_price', 'goods_sales_price', 'goods_addtimes');
  289. },
  290. 'sku' => function ($query) {
  291. $query->select('goods_sku_id', 'goods_sku_specs_json', 'goods_sku_market_price', 'goods_sku_sales_price');
  292. }
  293. ])->where('join_sheet_order_id', $orderId)
  294. ->get()
  295. ->toArray();
  296. $member = Member::with([
  297. 'cert' => function ($query) {
  298. $query->select('join_cert_member_id', 'member_cert_name');
  299. },
  300. 'info' => function ($query) {
  301. $query->select('join_info_member_id', 'member_info_nickname', 'member_info_headimg');
  302. }
  303. ])->where('member_id', $memberId)
  304. ->select('member_id', 'member_mobile', 'join_member_role_id', 'member_is_owner', 'member_is_vip', 'member_is_partner', 'member_is_referrer')
  305. ->first();
  306. if (!$member) {
  307. return json_fail('数据异常');
  308. }
  309. $member = $member->toArray();
  310. $certName = $member['cert']['member_cert_name'] ?? '';
  311. $nickname = $member['info']['member_info_nickname'] ?? '';
  312. $mobile = $member['member_mobile'] ?? '';
  313. $member['member_name'] = MemberService::getMemberCertName($mobile, $certName, $nickname);
  314. $member['info']['member_info_headimg'] = MemberService::getAvatarUrl($member['info']['member_info_headimg'] ?? '');
  315. $member['level'] = MemberService::getRoleName($member['join_member_role_id']);
  316. $payDetails = PayDetail::whereJsonContains('join_pay_object_json->order_id', $orderId)
  317. ->where('pay_status', 'SUCCESS')
  318. ->select('pay_status', 'pay_amount', 'pay_paytimes', 'pay_prepayid')
  319. ->get();
  320. $data = [
  321. 'payDetails' => $payDetails,
  322. 'goodsOrder' => $orderSheet,
  323. 'member' => $member
  324. ];
  325. return json_success('', $data);
  326. }
  327. /**
  328. * 余额账户充值
  329. */
  330. public function insertRecharge(Request $request): Response
  331. {
  332. if ($this->validate && !$this->validateClass->scene('add')->check($request->post())) {
  333. return json_fail($this->validateClass->getError());
  334. }
  335. $password = $request->post('recharge_password', '');
  336. if (!$password || $password != '123456') {
  337. return json_fail('充值密码错误');
  338. }
  339. Db::beginTransaction();
  340. try {
  341. $data = $this->insertRechargeInput($request);
  342. $data['pay_prepayid'] = $request->post('pay_prepayid', '');
  343. unset($data['orderId']);
  344. $payDetailId = $this->doInsert($data);
  345. (new RechargeController)->disposePaySuccess($payDetailId);
  346. Db::commit();
  347. } catch (BusinessException $customException) {
  348. Db::rollBack();
  349. return json_fail($customException->getMessage());
  350. } catch (\Exception $e) {
  351. Db::rollBack();
  352. dump($e->getMessage());
  353. return json_fail('数据写入失败11');
  354. }
  355. return json_success('success');
  356. }
  357. /**
  358. * 余额账户赠送
  359. */
  360. public function insertGive(Request $request): Response
  361. {
  362. if ($this->validate && !$this->validateClass->scene('add')->check($request->post())) {
  363. return json_fail($this->validateClass->getError());
  364. }
  365. $password = $request->post('recharge_password', '');
  366. if (!$password || $password != '123456') {
  367. return json_fail('赠送密码错误');
  368. }
  369. Db::beginTransaction();
  370. try {
  371. $data = $this->insertGiveInput($request);
  372. $data['pay_prepayid'] = $data['join_pay_member_id'] . '-CASH';
  373. // 金额累加到福利账户
  374. $memberAccount = MemberAccount::where('join_account_member_id', $data['join_pay_member_id'])->where('member_account_classify', 'CASH')->first();
  375. $memberAccount->member_account_income = $memberAccount->member_account_income + $data['pay_amount'];
  376. $memberAccount->member_account_surplus = $memberAccount->member_account_surplus + $data['pay_amount'];
  377. $memberAccount->save();
  378. $data['pay_amount'] = 0;
  379. $this->doInsert($data);
  380. Db::commit();
  381. } catch (BusinessException $customException) {
  382. Db::rollBack();
  383. return json_fail($customException->getMessage());
  384. } catch (\Exception $e) {
  385. Db::rollBack();
  386. dump($e->getMessage());
  387. return json_fail('数据写入失败11');
  388. }
  389. return json_success('success');
  390. }
  391. /**
  392. * 福利账户充值
  393. */
  394. public function insertRechargeWelfare(Request $request): Response
  395. {
  396. if ($this->validate && !$this->validateClass->scene('add')->check($request->post())) {
  397. return json_fail($this->validateClass->getError());
  398. }
  399. $password = $request->post('recharge_password', '');
  400. if (!$password || $password != '123456') {
  401. return json_fail('充值密码错误');
  402. }
  403. Db::beginTransaction();
  404. try {
  405. $data = $this->insertRechargeInput($request, 'WELFARE');
  406. $orderId = $data['orderId'];
  407. unset($data['orderId']);
  408. $data['pay_prepayid'] = $data['join_pay_member_id'] . '-WELFARE';
  409. $memberAccount = MemberAccount::where('join_account_member_id', $data['join_pay_member_id'])
  410. ->where('member_account_classify', 'WELFARE')
  411. ->first();
  412. if ($memberAccount->member_account_status != 'ACTIVED') {
  413. throw new BusinessException('福利账户未开启');
  414. }
  415. $this->doInsert($data);
  416. // 金额累加到福利账户
  417. $memberAccount->member_account_income = $memberAccount->member_account_income + $data['pay_amount'];
  418. $memberAccount->member_account_surplus = $memberAccount->member_account_surplus + $data['pay_amount'];
  419. $memberAccount->save();
  420. Db::commit();
  421. // 入收支明细表
  422. $params['orderId'] = $orderId;
  423. $params['inout_category'] = '会员充值订单收入';
  424. Event::dispatch('statistics.inout.in', $params);
  425. } catch (BusinessException $customException) {
  426. Db::rollBack();
  427. return json_fail($customException->getMessage());
  428. } catch (\Exception $e) {
  429. Db::rollBack();
  430. dump($e->getMessage());
  431. return json_fail('数据写入失败11');
  432. }
  433. return json_success('success');
  434. }
  435. /**
  436. * @Desc
  437. * @Author Gorden
  438. * @Date 2024/6/5 13:39
  439. *
  440. * @param Request $request
  441. * @return array
  442. * @throws BusinessException
  443. */
  444. protected function insertRechargeInput(Request $request, $type = "CASH"): array
  445. {
  446. $params = $request->post();
  447. $data = $this->inputFilter($params);
  448. $goods = Goods::find($params['goods_id']);
  449. $extendJson = [];
  450. $orderExtendJson = [];
  451. // if (!$params['is_custom']) {
  452. // Db::beginTransaction();
  453. try {
  454. if (!$params['is_custom']) {
  455. $data['pay_amount'] = $goods->goods_sales_price;
  456. }
  457. $orderExtendJson['referee_dept_id'] = $params['dept_id'] ?? '';
  458. $orderExtendJson['referee'] = $params['referee'] ?? '';
  459. if (!empty($params['dept_id'])) {
  460. $orderExtendJson['referee_premises'] = SysDept::where('dept_id', $params['dept_id'])->value('dept_name');
  461. }
  462. $orderId = "OD" . date('ymdHi') . random_string(4, 'up');
  463. $orderGroupId = "OD" . date('ymdHi') . random_string(4, 'up');
  464. $orderData = [
  465. 'order_id' => $orderId,
  466. 'order_groupby' => $orderGroupId,
  467. 'join_order_member_id' => $data['join_pay_member_id'],
  468. 'order_name' => date('Y-m-d H:i:s') . '-订单',
  469. 'order_amount_total' => $data['pay_amount'],
  470. 'order_amount_pay' => $data['pay_amount'],
  471. 'order_amount_json' => '{"tax": 0, "freight": 0}',
  472. 'order_status_payment' => 'SUCCESS',
  473. 'order_classify' => 'RECHARGE',
  474. 'order_category' => 'RECHARGE',
  475. 'order_status_system' => 'PAYING',
  476. 'order_status_storage' => 'PENDING',
  477. 'order_config_json' => json_encode(['order_category' => 'RECHARGE']),
  478. 'order_extend_json' => json_encode($orderExtendJson),
  479. 'order_platform' => 'SYSTEM',
  480. 'order_addtimes' => time()
  481. ];
  482. if ($type == 'WELFARE') {
  483. $orderData['order_is_complete'] = 'Y';
  484. $orderData['order_status_system'] = 'DONE';
  485. $orderData['order_status_storage'] = 'DONE';
  486. unset($orderData['order_config_json']);
  487. }
  488. $sku = GoodsSku::where('join_sku_goods_id', $params['goods_id'])->first();
  489. Order::insert($orderData);
  490. $orderSheetData = [
  491. 'join_sheet_member_id' => $data['join_pay_member_id'],
  492. 'join_sheet_order_id' => $orderId,
  493. 'join_sheet_goods_id' => $params['goods_id'],
  494. 'join_sheet_goods_sku_id' => $sku ? $sku->goods_sku_id : 0,
  495. 'order_sheet_status' => 'DONE',
  496. 'order_sheet_category' => 'RECHARGE',
  497. 'order_sheet_num' => 1,
  498. 'order_sheet_price' => $data['pay_amount'],
  499. 'order_sheet_amount' => $data['pay_amount'],
  500. 'order_sheet_pay' => $data['pay_amount'],
  501. 'order_sheet_addtimes' => time()
  502. ];
  503. OrderSheet::insert($orderSheetData);
  504. // Db::commit();
  505. } catch (\Exception $e) {
  506. // Db::rollBack();
  507. throw new BusinessException("数据错误");
  508. }
  509. $data['orderId'] = $orderId;
  510. $data['join_pay_order_id'] = $orderGroupId;
  511. $data['join_pay_object_json'] = json_encode(['order_id' => $orderId]);
  512. $rate = 0;
  513. if (!empty($goods->goods_attribute_json) && $type == "CASH") {
  514. $attributeJson = json_decode($goods->goods_attribute_json, true);
  515. if (isset($attributeJson['added'])) {
  516. $rate = $attributeJson['added'] ? $attributeJson['added']['nbr'] : 0;
  517. }
  518. }
  519. $extendJson['added_amount'] = number_format($data['pay_amount'] * $rate, 2, '.', '');
  520. $extendJson['added_rate'] = $rate;
  521. // } else {
  522. // // $extendJson['notify'] = 'success';
  523. // $extendJson['is_custom'] = $params['is_custom'];
  524. // }
  525. $data['pay_extend_json'] = json_encode($extendJson);
  526. $data['pay_paytimes'] = date('Y-m-d H:i:s', strtotime($data['pay_paytimes']));
  527. $data['pay_prepayid'] = 0;
  528. return $data;
  529. }
  530. /**
  531. * @Desc
  532. * @Author Gorden
  533. * @Date 2024/6/5 13:39
  534. *
  535. * @param Request $request
  536. * @return array
  537. * @throws BusinessException
  538. */
  539. protected function insertGiveInput(Request $request, $type = "CASH"): array
  540. {
  541. $params = $request->post();
  542. $data = $this->inputFilter($params);
  543. $goods = Goods::find($params['goods_id']);
  544. $extendJson = [];
  545. // if (!$params['is_custom']) {
  546. Db::beginTransaction();
  547. try {
  548. if (!$params['is_custom']) {
  549. $data['pay_amount'] = $goods->goods_sales_price;
  550. }
  551. // $orderId = "OD" . date('ymdHi') . random_string(4, 'up');
  552. // $orderGroupId = "OD" . date('ymdHi') . random_string(4, 'up');
  553. // $orderData = [
  554. // 'order_id' => $orderId,
  555. // 'order_groupby' => $orderGroupId,
  556. // 'join_order_member_id' => $data['join_pay_member_id'],
  557. // 'order_name' => date('Y-m-d H:i:s') . '-订单',
  558. // 'order_amount_total' => $data['pay_amount'],
  559. // 'order_amount_pay' => $data['pay_amount'],
  560. // 'order_amount_json' => '{"tax": 0, "freight": 0}',
  561. // 'order_status_payment' => 'SUCCESS',
  562. // 'order_classify' => 'RECHARGE',
  563. // 'order_category' => 'RECHARGE',
  564. // 'order_status_system' => 'PAYING',
  565. // 'order_status_storage' => 'PENDING',
  566. // 'order_addtimes' => time()
  567. // ];
  568. // if ($type == 'WELFARE') {
  569. // $orderData['order_is_complete'] = 'Y';
  570. // $orderData['order_status_system'] = 'DONE';
  571. // $orderData['order_status_storage'] = 'DONE';
  572. // }
  573. // $sku = GoodsSku::where('join_sku_goods_id', $params['goods_id'])->first();
  574. //
  575. // Order::insert($orderData);
  576. // $orderSheetData = [
  577. // 'join_sheet_member_id' => $data['join_pay_member_id'],
  578. // 'join_sheet_order_id' => $orderId,
  579. // 'join_sheet_goods_id' => $params['goods_id'],
  580. // 'join_sheet_goods_sku_id' => $sku ? $sku->goods_sku_id : 0,
  581. // 'order_sheet_status' => 'DONE',
  582. // 'order_sheet_category' => 'RECHARGE',
  583. // 'order_sheet_num' => 1,
  584. // 'order_sheet_price' => $data['pay_amount'],
  585. // 'order_sheet_amount' => $data['pay_amount'],
  586. // 'order_sheet_pay' => $data['pay_amount'],
  587. // 'order_sheet_addtimes' => time()
  588. // ];
  589. //
  590. // OrderSheet::insert($orderSheetData);
  591. Db::commit();
  592. } catch (\Exception $e) {
  593. dump($e->getMessage());
  594. Db::rollBack();
  595. throw new BusinessException("数据错误");
  596. }
  597. $data['join_pay_order_id'] = "SYSTEM";
  598. $data['join_pay_object_json'] = json_encode(['order_id' => 'SYSTEM']);
  599. $rate = 0;
  600. $extendJson['added_amount'] = $data['pay_amount'];
  601. $extendJson['added_rate'] = $rate;
  602. $data['pay_extend_json'] = json_encode($extendJson);
  603. $data['pay_paytimes'] = date('Y-m-d H:i:s', strtotime($data['pay_paytimes']));
  604. $data['pay_prepayid'] = 0;
  605. return $data;
  606. }
  607. /**
  608. * @Desc 加备注-门店、服务人员、业务人员
  609. * @Author Gorden
  610. * @Date 2024/8/29 16:14
  611. *
  612. * @param Request $request
  613. * @return Response
  614. */
  615. public function remark(Request $request)
  616. {
  617. $payId = $request->post('pay_id', '');
  618. if (!$payId) {
  619. return json_fail('参数异常');
  620. }
  621. $payDetail = PayDetail::where('pay_id', $payId)->first();
  622. if (!$payDetail) {
  623. return json_fail("数据异常");
  624. }
  625. try {
  626. $data = [
  627. 'premises_id' => $request->post('premises_id', ''),
  628. 'premises_name' => $request->post('premises_name', ''),
  629. 'business' => $request->post('business', ''),
  630. 'service' => $request->post('service', '')
  631. ];
  632. $payExtendJson = [];
  633. if (!empty($payDetail->pay_extend_json)) {
  634. $payExtendJson = json_decode($payDetail->pay_extend_json, true);
  635. }
  636. $payExtendJson['remark'] = $data;
  637. $payDetail->pay_extend_json = json_encode($payExtendJson, JSON_UNESCAPED_UNICODE);
  638. $payDetail->save();
  639. return json_success('success');
  640. } catch (\Exception $e) {
  641. return json_fail('备注保存失败');
  642. }
  643. }
  644. }