EqualAwardService.php 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772
  1. <?php
  2. namespace addons\CloudStock\common\services;
  3. use addons\CloudStock\common\enums\CloudStockEnum;
  4. use addons\CloudStock\common\models\CloudStockAgent;
  5. use addons\CloudStock\common\models\CloudStockDispenseOrder;
  6. use addons\CloudStock\common\models\CloudStockFillOrder;
  7. use addons\CloudStock\common\models\CloudStockGoods;
  8. use addons\CloudStock\common\models\CloudStockLevel;
  9. use addons\CloudStock\common\models\CloudStockPaymentLog;
  10. use addons\CloudStock\common\models\CloudStockStatistic;
  11. use addons\CloudStock\common\models\CloudStockUserStatistic;
  12. use common\components\export\CsvTool;
  13. use common\enums\AddonsEnum;
  14. use common\enums\DownloadEnum;
  15. use common\enums\StatusEnum;
  16. use common\enums\UserWalletEnum;
  17. use common\helpers\DateHelper;
  18. use common\models\common\CapitalLog;
  19. use common\models\common\Download;
  20. use common\models\goods\Goods;
  21. use common\models\order\Order;
  22. use common\models\order\OrderDetail;
  23. use common\models\user\User;
  24. use common\models\user\UserPartitionRelationship;
  25. use services\common\UserWalletService;
  26. class EqualAwardService extends BaseService
  27. {
  28. public $reward_unit_price = 0;
  29. public $stock_goods = null;
  30. public $equal_level = null;
  31. public $bonus_agent = null;
  32. public $setting = null;
  33. public $order = null;
  34. public $is_frozen = false;
  35. public $desc = '';
  36. public function index($params)
  37. {
  38. $where = [];
  39. $class = $this->getWhere($params, $where);
  40. $params['where'] = $where;
  41. $params['order'] = 'id desc';
  42. $page_data = $class::listPage($params, false, true);
  43. if (!empty($page_data['list'])) {
  44. $user_ids = array_column($page_data['list'], 'user_id');
  45. $dispense_order_ids = $fill_order_ids = $goods_ids = [];
  46. foreach ($page_data['list'] as $val) {
  47. if ($val['source_table'] == '{{%addons_cloud_stock_fill_order}}') {
  48. $fill_order_ids[] = $val['source_table_id'];
  49. } elseif ($val['source_table'] == '{{%addons_cloud_stock_dispense_order}}') {
  50. $dispense_order_ids[] = $val['source_table_id'];
  51. }
  52. }
  53. if (!empty($dispense_order_ids)) {
  54. $cloud_stock_dispense_order_list = CloudStockDispenseOrder::lists(['where' => [
  55. ['id' => $dispense_order_ids],
  56. ['mall_id' => $this->mall_id]
  57. ],
  58. 'index' => 'id',
  59. ]);
  60. $user_ids = array_merge($user_ids, array_column($cloud_stock_dispense_order_list, 'user_id'));
  61. $temp_goods_ids = array_column($cloud_stock_dispense_order_list, 'goods_id');
  62. $goods_ids = array_merge($goods_ids, $temp_goods_ids);
  63. }
  64. if (!empty($fill_order_ids)) {
  65. $fill_order_list = CloudStockFillOrder::lists(['where' => [
  66. ['id' => $fill_order_ids],
  67. ['mall_id' => $this->mall_id]
  68. ],
  69. 'index' => 'id',
  70. ]);
  71. $user_ids = array_merge($user_ids, array_column($fill_order_list, 'user_id'));
  72. $temp_goods_ids = array_column($fill_order_list, 'goods_id');
  73. $goods_ids = array_merge($goods_ids, $temp_goods_ids);
  74. }
  75. $goods_list = Goods::lists(['where' => [
  76. ['id' => $goods_ids],
  77. ['mall_id' => $this->mall_id]
  78. ],
  79. 'index' => 'id',
  80. ]);
  81. $user_list = User::lists(['where' => [
  82. ['id' => $user_ids],
  83. ['mall_id' => $this->mall_id]
  84. ],
  85. 'index' => 'id',
  86. ]);
  87. foreach ($page_data['list'] as &$item) {
  88. $item['user'] = $item['from_user'] = [];
  89. $item['num'] = $item['cover_pic'] = $item['goods_name'] = '';
  90. if (isset($user_list[$item['user_id']])) {
  91. $item['user'] = [
  92. 'id' => $user_list[$item['user_id']]['id'],
  93. 'nickname' => $user_list[$item['user_id']]['nickname'],
  94. 'mobile' => $user_list[$item['user_id']]['mobile'],
  95. 'avatar_url' => $user_list[$item['user_id']]['avatar_url'],
  96. ];
  97. }
  98. if ($item['source_table'] == '{{%addons_cloud_stock_fill_order}}') {
  99. $fill_order_id = $item['source_table_id'];
  100. if (isset($fill_order_list[$fill_order_id])) {
  101. $temp_uid = $fill_order_list[$fill_order_id]['user_id'];
  102. $item['num'] = $fill_order_list[$fill_order_id]['num'];
  103. $goods_id = $fill_order_list[$fill_order_id]['goods_id'];
  104. if (isset($goods_list[$goods_id])) {
  105. $item['cover_pic'] = $goods_list[$goods_id]['cover_pic'];
  106. $item['goods_name'] = $goods_list[$goods_id]['goods_name'];
  107. }
  108. }
  109. } elseif ($item['source_table'] == '{{%addons_cloud_stock_dispense_order}}') {
  110. $dispense_order_id = $item['source_table_id'];
  111. if (isset($cloud_stock_dispense_order_list[$dispense_order_id])) {
  112. $item['num'] = $cloud_stock_dispense_order_list[$dispense_order_id]['num'];
  113. $temp_uid = $cloud_stock_dispense_order_list[$dispense_order_id]['user_id'];
  114. $goods_id = $cloud_stock_dispense_order_list[$dispense_order_id]['goods_id'];
  115. if (isset($goods_list[$goods_id])) {
  116. $item['cover_pic'] = $goods_list[$goods_id]['cover_pic'];
  117. $item['goods_name'] = $goods_list[$goods_id]['goods_name'];
  118. }
  119. }
  120. }
  121. if (isset($temp_uid) && isset($user_list[$temp_uid])) {
  122. $item['from_user'] = [
  123. 'id' => $user_list[$temp_uid]['id'],
  124. 'nickname' => $user_list[$temp_uid]['nickname'],
  125. 'mobile' => $user_list[$temp_uid]['mobile'],
  126. 'avatar_url' => $user_list[$temp_uid]['avatar_url'],
  127. ];
  128. }
  129. }
  130. }
  131. list($settlement, $no_settlement) = $this->getStatistic();
  132. $page_data['settlement'] = $settlement;
  133. $page_data['no_settlement'] = $no_settlement;
  134. return $page_data;
  135. }
  136. public function equalAwardList($params)
  137. {
  138. if (empty($params['month'])) {
  139. $month = date('Y-m');
  140. } else {
  141. $month = $params['month'];
  142. }
  143. $start_time = strtotime($month . '-01 00:00:00');
  144. $end_time = DateHelper::getMonthLastDayTime($start_time);
  145. $params['date'][0] = date('Y-m-d', $start_time);
  146. $params['date'][1] = date('Y-m-d', $end_time);
  147. $params['user_id'] = $this->user_id;
  148. $class = $this->getWhere($params, $where);
  149. $params['where'] = $where;
  150. $params['order'] = 'id desc';
  151. $params['select'] = 'user_id,order_no,capital_type,source_table,source_table_id,desc,change_num,created_at';
  152. $page_data = $class::listPage($params, false, true);
  153. if (!empty($page_data['list'])) {
  154. $user_ids = array_column($page_data['list'], 'user_id');
  155. $dispense_order_ids = $fill_order_ids = $goods_ids = [];
  156. foreach ($page_data['list'] as $val) {
  157. if ($val['source_table'] == '{{%addons_cloud_stock_fill_order}}') {
  158. $fill_order_ids[] = $val['source_table_id'];
  159. } elseif ($val['source_table'] == '{{%addons_cloud_stock_dispense_order}}') {
  160. $dispense_order_ids[] = $val['source_table_id'];
  161. }
  162. }
  163. if (!empty($dispense_order_ids)) {
  164. $cloud_stock_dispense_order_list = CloudStockDispenseOrder::lists(['where' => [
  165. ['id' => $dispense_order_ids],
  166. ['mall_id' => $this->mall_id]
  167. ],
  168. 'index' => 'id',
  169. ]);
  170. $user_ids = array_merge($user_ids, array_column($cloud_stock_dispense_order_list, 'user_id'));
  171. $temp_goods_ids = array_column($cloud_stock_dispense_order_list, 'goods_id');
  172. $goods_ids = array_merge($goods_ids, $temp_goods_ids);
  173. }
  174. if (!empty($fill_order_ids)) {
  175. $fill_order_list = CloudStockFillOrder::lists(['where' => [
  176. ['id' => $fill_order_ids],
  177. ['mall_id' => $this->mall_id]
  178. ],
  179. 'index' => 'id',
  180. ]);
  181. $user_ids = array_merge($user_ids, array_column($fill_order_list, 'user_id'));
  182. $temp_goods_ids = array_column($fill_order_list, 'goods_id');
  183. $goods_ids = array_merge($goods_ids, $temp_goods_ids);
  184. }
  185. $goods_list = Goods::lists(['where' => [
  186. ['id' => $goods_ids],
  187. ['mall_id' => $this->mall_id]
  188. ],
  189. 'index' => 'id',
  190. ]);
  191. $user_list = User::lists(['where' => [
  192. ['id' => $user_ids],
  193. ['mall_id' => $this->mall_id]
  194. ],
  195. 'index' => 'id',
  196. ]);
  197. foreach ($page_data['list'] as &$item) {
  198. $item['from_user_id'] = $item['from_user_mobile'] = $item['capital_type_text'] = '';
  199. $item['num'] = $item['goods_name'] = '';
  200. if (isset($user_list[$item['user_id']])) {
  201. $item['user'] = [
  202. 'id' => $user_list[$item['user_id']]['id'],
  203. 'nickname' => $user_list[$item['user_id']]['nickname'],
  204. 'mobile' => $user_list[$item['user_id']]['mobile'],
  205. 'avatar_url' => $user_list[$item['user_id']]['avatar_url'],
  206. ];
  207. }
  208. if ($item['source_table'] == '{{%addons_cloud_stock_fill_order}}') {
  209. $fill_order_id = $item['source_table_id'];
  210. if (isset($fill_order_list[$fill_order_id])) {
  211. $temp_uid = $fill_order_list[$fill_order_id]['user_id'];
  212. $item['num'] = $fill_order_list[$fill_order_id]['num'];
  213. $goods_id = $fill_order_list[$fill_order_id]['goods_id'];
  214. if (isset($goods_list[$goods_id])) {
  215. $item['cover_pic'] = $goods_list[$goods_id]['cover_pic'];
  216. $item['goods_name'] = $goods_list[$goods_id]['goods_name'];
  217. }
  218. }
  219. } elseif ($item['source_table'] == '{{%addons_cloud_stock_dispense_order}}') {
  220. $dispense_order_id = $item['source_table_id'];
  221. if (isset($cloud_stock_dispense_order_list[$dispense_order_id])) {
  222. $item['num'] = $cloud_stock_dispense_order_list[$dispense_order_id]['num'];
  223. $temp_uid = $cloud_stock_dispense_order_list[$dispense_order_id]['user_id'];
  224. $goods_id = $cloud_stock_dispense_order_list[$dispense_order_id]['goods_id'];
  225. if (isset($goods_list[$goods_id])) {
  226. $item['cover_pic'] = $goods_list[$goods_id]['cover_pic'];
  227. $item['goods_name'] = $goods_list[$goods_id]['goods_name'];
  228. }
  229. }
  230. }
  231. if (isset($temp_uid) && isset($user_list[$temp_uid])) {
  232. $item['from_user_id'] = $user_list[$temp_uid]['id'];
  233. $item['from_user_mobile'] = $user_list[$temp_uid]['mobile'];
  234. }
  235. if ($item['capital_type'] == 'equal') {
  236. $item['capital_type_text'] = '平级奖励';
  237. } elseif ($item['capital_type'] == 'price_difference_equal') {
  238. $item['capital_type_text'] = '云库存差价平级奖';
  239. }
  240. unset($item['user']);
  241. }
  242. }
  243. return $page_data;
  244. }
  245. protected function getStatistic()
  246. {
  247. $statistic = CloudStockStatistic::lists([
  248. 'where' => [
  249. ['mall_id' => $this->mall_id],
  250. ['capital_type' => ['equal', 'price_difference_equal']]
  251. ],
  252. 'group' => 'settlement_status',
  253. 'select' => 'settlement_status,sum(money) as money'
  254. ]);
  255. $settlement = $no_settlement = 0;
  256. foreach ($statistic as $val) {
  257. if ($val['settlement_status'] == 0) {
  258. $no_settlement = $val['money'];
  259. } elseif ($val['settlement_status'] == 1) {
  260. $settlement = $val['money'];
  261. }
  262. }
  263. return [$settlement, $no_settlement];
  264. }
  265. protected function getWhere($params, &$where)
  266. {
  267. $class = CapitalLog::class;
  268. $where[] = ['mall_id' => $this->mall_id, 'from_type' => CloudStockEnum::ADDONS_NAME, 'capital_type' => ['equal', 'price_difference_equal']];
  269. if (empty($params['active_name']) || $params['active_name'] == 'settlement') {
  270. $class::$capitalType = 'commission';
  271. } else {
  272. $where[] = ['status' => 0];
  273. $class::$capitalType = 'commission_frozen';
  274. }
  275. if (!empty($params['keyword'])) {
  276. $user_list = User::lists(['where' => [
  277. ['mall_id' => $this->mall_id],
  278. ['or',
  279. ['like', 'nickname', $params['keyword']],
  280. ['like', 'mobile', $params['keyword']]]],
  281. 'select' => 'id']);
  282. if (!empty($user_list)) {
  283. $user_ids = array_column($user_list, 'id');
  284. $where[] = ['user_id' => $user_ids];
  285. } else {
  286. $where[] = ['user_id' => []];
  287. }
  288. }
  289. if (!empty($params['user_id'])) {
  290. $where[] = ['user_id' => $params['user_id']];
  291. }
  292. if (!empty($params['order_no'])) {
  293. $where[] = ['order_no' => trim($params['order_no'])];
  294. }
  295. if (!empty($params['capital_type'])) {
  296. $where[] = ['capital_type' => trim($params['capital_type'])];
  297. }
  298. if (!empty($params['date'][0])) {
  299. $where[] = ['>=', 'created_at', strtotime($params['date'][0] . ' 00:00:00')];
  300. }
  301. if (!empty($params['date'][1])) {
  302. $where[] = ['<=', 'created_at', strtotime($params['date'][1] . ' 23:59:59')];
  303. }
  304. return $class;
  305. }
  306. public function getListExportFieldList()
  307. {
  308. return $this->exportFieldsList();
  309. }
  310. public function exportFieldsList()
  311. {
  312. return [
  313. 'nickname' => '用户昵称',
  314. 'mobile' => '用户手机',
  315. 'capital_type' => '佣金类型',
  316. 'change_num' => '结算金额',
  317. 'desc' => '说明',
  318. 'status' => '结算状态',
  319. 'order_no' => '订单号',
  320. 'created_at' => '创建时间',
  321. ];
  322. }
  323. public static function exportData($params)
  324. {
  325. (new EqualAwardService(['mall_id' => $params['mall_id']]))->export($params);
  326. }
  327. public function add($params)
  328. {
  329. $res = CloudStockPaymentLog::add($params);
  330. if (empty($res)) {
  331. throw new \Exception(CloudStockPaymentLog::$static_error);
  332. }
  333. if (empty($params['status'])) {
  334. $params['is_frozen'] = true;
  335. } else {
  336. $params['is_frozen'] = false;
  337. }
  338. WithdrawService::handle($params);
  339. return $res;
  340. }
  341. public function export($data)
  342. {
  343. ini_set('memory_limit', '512M');
  344. $download_id = $data['download_id'] ?? 0;
  345. $download = Download::findOne(['id' => $download_id]);
  346. if ($download) {
  347. try {
  348. $params = json_decode($download->params, true);
  349. $filename = $download->name;
  350. $type = $download->type;
  351. $where = [];
  352. $class = $this->getWhere($params, $where);
  353. $status = 0;
  354. if (empty($params['active_name']) || $params['active_name'] == 'settlement') {
  355. $status = 1;
  356. }
  357. $params['where'] = $where;
  358. $params['order'] = 'id desc';
  359. $list = $class::lists($params);
  360. $fields = $params['fields'];
  361. $fields_arr = $this->exportFieldsList();
  362. $have_select_field_arr = [];
  363. foreach ($fields as $value) {
  364. $have_select_field_arr[] = $fields_arr[$value];
  365. }
  366. $csv = new CsvTool();
  367. $csv->filename = $filename;
  368. $csv->file_dirname = DownloadEnum::getTypeStorageDirMap($type);
  369. $csv->export_mode = CsvTool::EXPORT_MODE_ASYNC;
  370. $csv->header = $have_select_field_arr;
  371. $user_id_arr = array_column($list, 'user_id');
  372. $user_arr = User::lists([
  373. 'where' => [
  374. ['id' => $user_id_arr]
  375. ],
  376. 'index' => 'id',
  377. ]);
  378. $csv->data = array_map(function ($item) use ($fields, $user_arr, $status) {
  379. $row = [];
  380. foreach ($fields as $field) {
  381. switch (true) {
  382. case $field == 'created_at':
  383. $row[] = !empty($item[$field]) ? date('Y-m-d H:i:s', $item[$field]) : '';
  384. break;
  385. case $field == 'mobile':
  386. $row[] = $user_arr[$item['user_id']]['mobile'] ?? '';
  387. break;
  388. case $field == 'capital_type':
  389. $row[] = $item['capital_type'] == 'equal' ? '云库存-平级奖励' : '云库存-云库存差价平级奖';
  390. break;
  391. case $field == 'status':
  392. $row[] = $status == 0 ? '未结算' : '已结算';
  393. break;
  394. case $field == 'nickname':
  395. $row[] = $user_arr[$item['user_id']]['nickname'] ?? '';
  396. break;
  397. default:
  398. $row[] = !empty($item[$field]) ? $item[$field] : '';
  399. }
  400. }
  401. return $row;
  402. }, $list);
  403. $csv->export();
  404. $csv->updateDown($download, $params['mall_id']);
  405. return true;
  406. } catch (\Exception $e) {
  407. var_dump($e->getMessage() . $e->getFile() . $e->getLine());
  408. $download->status = 3;
  409. $res = $download->save();
  410. return $e->getMessage();
  411. }
  412. }
  413. }
  414. /**
  415. * 修复佣金记录表的订单号字段
  416. * @param $capitalType
  417. * @return void
  418. */
  419. public function fixOrderNo($capitalType)
  420. {
  421. $i = 1;
  422. $limit = 1000;
  423. while (true) {
  424. CapitalLog::$capitalType = $capitalType;
  425. $list = CapitalLog::find()->where([
  426. 'mall_id' => $this->mall_id,
  427. 'from_type' => 'CloudStock',
  428. 'order_no' => '',
  429. 'capital_type' => ['equal', 'price_difference_equal']
  430. ])->orderBy('id asc')->offset(($i - 1) * $limit)->limit($limit)->all();
  431. if (empty($list)) {
  432. break;
  433. }
  434. $i++;
  435. $dispense_order_ids = $fill_order_ids = [];
  436. foreach ($list as $item) {
  437. if ($item['source_table'] == '{{%addons_cloud_stock_fill_order}}') {
  438. $fill_order_ids[] = $item['source_table_id'];
  439. } elseif ($item['source_table'] == '{{%addons_cloud_stock_dispense_order}}') {
  440. $dispense_order_ids[] = $item['source_table_id'];
  441. }
  442. }
  443. if (!empty($dispense_order_ids)) {
  444. $cloud_stock_dispense_order_list = CloudStockDispenseOrder::lists(['where' => [
  445. ['id' => $dispense_order_ids],
  446. ['mall_id' => $this->mall_id]
  447. ],
  448. 'index' => 'id',
  449. ]);
  450. }
  451. $fill_order_list = [];
  452. if (!empty($fill_order_ids)) {
  453. $fill_order_list = CloudStockFillOrder::lists(['where' => [
  454. ['id' => $fill_order_ids],
  455. ['mall_id' => $this->mall_id]
  456. ],
  457. 'index' => 'id',
  458. ]);
  459. }
  460. foreach ($list as $val) {
  461. if ($val['source_table'] == '{{%addons_cloud_stock_fill_order}}') {
  462. $val->order_no = $fill_order_list[$val['source_table_id']]['order_no'] ?? '';
  463. } elseif ($val['source_table'] == '{{%addons_cloud_stock_dispense_order}}') {
  464. $val->order_no = $cloud_stock_dispense_order_list[$val['source_table_id']]['order_no'] ?? '';
  465. }
  466. $res = $val->save();
  467. var_dump('id:' . $val['id'] . $res);
  468. }
  469. }
  470. }
  471. /**
  472. * 手动结算
  473. * @param $params
  474. * @return true
  475. * @throws \Exception
  476. */
  477. public function manualSettlement($params)
  478. {
  479. if (empty($params['id'])) {
  480. throw new \Exception('id不能为空');
  481. }
  482. CapitalLog::$capitalType = 'commission_frozen';
  483. $list = CapitalLog::lists([
  484. 'where' => [
  485. ['id' => $params['id']]
  486. ],
  487. 'select' => 'sum(change_num) as change_num,capital_type',
  488. 'group' => 'capital_type'
  489. ]);
  490. $user_list = CapitalLog::lists([
  491. 'where' => [
  492. ['id' => $params['id']]
  493. ],
  494. 'select' => 'sum(change_num) as change_num,capital_type,user_id',
  495. 'group' => 'capital_type,user_id'
  496. ]);
  497. foreach ($params['id'] as $id) {
  498. UserWalletService::unfrozen($id, 'commission');
  499. }
  500. foreach ($list as $item) {
  501. $add_data = ['mall_id' => $this->mall_id, 'capital_type' => $item['capital_type'], 'settlement_status' => 0, 'money' => -$item['change_num']];
  502. CloudStockStatistic::setData($add_data);//扣除待结算统计
  503. $add_data = ['mall_id' => $this->mall_id, 'capital_type' => $item['capital_type'], 'settlement_status' => 1, 'money' => $item['change_num']];
  504. CloudStockStatistic::setData($add_data);//增加已结算统计
  505. }
  506. foreach ($user_list as $item) {
  507. $add_data = ['settlement_status' => 0, 'money' => -$item['change_num']];
  508. (new AgentService(['mall_id' => $this->mall_id, 'user_id' => $item['user_id']]))->setData($add_data);
  509. $add_data = ['settlement_status' => 1, 'money' => $item['change_num']];
  510. (new AgentService(['mall_id' => $this->mall_id, 'user_id' => $item['user_id']]))->setData($add_data);
  511. }
  512. return true;
  513. }
  514. /**
  515. * 发放平级奖-计算统计
  516. * @param $insert_wallet
  517. * @param $capital_type
  518. * @return void
  519. */
  520. public function setStatistics($insert_wallet, $capital_type)
  521. {
  522. $statistics_data = [];
  523. $statistics_user_data = [];
  524. $mall_id = 0;
  525. foreach ($insert_wallet as $user) {
  526. if (!in_array($user['capital_type'], ['equal', 'price_difference_equal'])) {
  527. continue;
  528. }
  529. $mall_id = $user['mall_id'];
  530. if (!empty($user['is_frozen'])) {
  531. if (isset($statistics_data[$user['mall_id']]['frozen_price'])) {
  532. $statistics_data[$user['mall_id']]['frozen_price'] += $user['money'];
  533. } else {
  534. $statistics_data[$user['mall_id']]['frozen_price'] = $user['money'];
  535. }
  536. if (isset($statistics_user_data[$user['user_id']]['frozen_price'])) {
  537. $statistics_user_data[$user['user_id']]['frozen_price'] += $user['money'];
  538. } else {
  539. $statistics_user_data[$user['user_id']]['frozen_price'] = $user['money'];
  540. }
  541. } else {
  542. if (isset($statistics_data[$user['mall_id']]['price'])) {
  543. $statistics_data[$user['mall_id']]['price'] += $user['money'];
  544. } else {
  545. $statistics_data[$user['mall_id']]['price'] = $user['money'];
  546. }
  547. if (isset($statistics_user_data[$user['user_id']]['price'])) {
  548. $statistics_user_data[$user['user_id']]['price'] += $user['money'];
  549. } else {
  550. $statistics_user_data[$user['user_id']]['price'] = $user['money'];
  551. }
  552. }
  553. }
  554. foreach ($statistics_data as $mall_id => $data) {
  555. if (!empty($data['frozen_price'])) {
  556. $add_data = ['mall_id' => $mall_id, 'capital_type' => $capital_type, 'settlement_status' => 0, 'money' => $data['frozen_price']];
  557. CloudStockStatistic::setData($add_data);
  558. }
  559. if (!empty($data['price'])) {
  560. $add_data = ['mall_id' => $mall_id, 'capital_type' => $capital_type, 'settlement_status' => 1, 'money' => $data['price']];
  561. CloudStockStatistic::setData($add_data);
  562. }
  563. }
  564. foreach ($statistics_user_data as $user_id => $data) {
  565. if (!empty($data['frozen_price'])) {
  566. $add_data = ['settlement_status' => 0, 'money' => $data['frozen_price']];
  567. (new AgentService(['mall_id' => $mall_id, 'user_id' => $user_id]))->setData($add_data);
  568. }
  569. if (!empty($data['price'])) {
  570. $add_data = ['settlement_status' => 1, 'money' => $data['price']];
  571. (new AgentService(['mall_id' => $mall_id, 'user_id' => $user_id]))->setData($add_data);
  572. }
  573. }
  574. }
  575. /**
  576. * 上级给下级配货-触发平级一、二奖励
  577. * @param $order
  578. * @return true
  579. */
  580. public function reward($order)
  581. {
  582. $user_id = $order['user_id'];//配货者
  583. $child_id = $order['child_id'];//配货下级
  584. $mall_id = $order['mall_id'];
  585. $goods_id = $order['goods_id'];
  586. $setting = \Yii::$app->services->setting->addons->get($this->mall_id, AddonsEnum::ADDONS_NAME_CLOUD_STOCK, 'basic');
  587. if (empty($setting['is_trigger_level_award'])) {
  588. return true;
  589. }
  590. $this->setting = $setting;
  591. $agent = CloudStockAgent::findOne(['user_id' => $child_id, 'mall_id' => $mall_id, 'status' => StatusEnum::ENABLED]);
  592. $stock_good = CloudStockGoods::findOne(['mall_id' => $mall_id, 'status' => StatusEnum::ENABLED, 'goods_id' => $goods_id]);
  593. $this->stock_goods = $stock_good;
  594. $this->order = $order;
  595. if (empty($stock_good)) {
  596. return true;
  597. }
  598. //紧凑平级奖
  599. if (!empty($stock_good['is_find_equal'])) {
  600. $parent_id_arr = UserPartitionRelationship::getParentIdArr($child_id);
  601. $parent_id_arr = array_reverse($parent_id_arr);
  602. $reward_list = [];
  603. $is_find_equal = false;
  604. $parent_agent_list = CloudStockAgent::lists([
  605. 'where' => [
  606. ['user_id' => $parent_id_arr],
  607. ['mall_id' => $mall_id],
  608. ['status' => StatusEnum::ENABLED],
  609. ],
  610. 'index' => 'user_id'
  611. ], false);
  612. foreach ($parent_id_arr as $parent_id) {
  613. if (empty($parent_agent_list[$parent_id])) {
  614. continue;
  615. }
  616. $parent_agent = $parent_agent_list[$parent_id];
  617. if (!empty($direct_agent['is_equal_award_restriction'])) {
  618. continue;
  619. }
  620. //找平级
  621. if ($parent_agent['level'] == $agent['level']) {
  622. if (!$is_find_equal) {
  623. $reward_list[] = [
  624. 'level' => 1,
  625. 'agent' => $parent_agent,
  626. ];
  627. $is_find_equal = true;
  628. } else {
  629. $reward_list[] = [
  630. 'level' => 2,
  631. 'agent' => $parent_agent,
  632. ];
  633. break;
  634. }
  635. }
  636. }
  637. if (!empty($reward_list)) {
  638. $stock_level = CloudStockLevel::findOne(['mall_id' => $this->mall_id, 'level' => $agent['level'], 'status' => StatusEnum::ENABLED]);
  639. foreach ($reward_list as $reward) {
  640. if ($reward['agent']['level'] == $agent['level']) {
  641. $this->desc = "用户({$user_id})配货给用户({$child_id})获得平" . $reward['level'] . "级奖励";;
  642. $this->sendEqualReward($reward['agent'], $stock_level, $reward['level']);
  643. }
  644. }
  645. }
  646. } else {
  647. //发放平一级对象,直推
  648. $user = User::findOne(['id' => $child_id]);
  649. if (!empty($user['parent_id'])) {
  650. $direct_agent = CloudStockAgent::findOne(['user_id' => $user['parent_id'], 'mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED]);
  651. if ($direct_agent && $agent['level'] == $direct_agent['level'] && empty($direct_agent['is_equal_award_restriction'])) {
  652. $stock_level = CloudStockLevel::findOne(['mall_id' => $this->mall_id, 'level' => $direct_agent['level'], 'status' => StatusEnum::ENABLED]);
  653. $this->desc = "用户({$user_id})配货给用户({$child_id})获得平1级奖励";
  654. $this->sendEqualReward($direct_agent, $stock_level, 1);
  655. }
  656. //发放平二级用户,间推
  657. if (!empty($user['second_parent_id'])) {
  658. $second_parent_agent = CloudStockAgent::findOne(['user_id' => $user['second_parent_id'], 'status' => StatusEnum::ENABLED, 'mall_id' => $this->mall_id]);
  659. if ($second_parent_agent && $agent['level'] == $second_parent_agent['level'] && empty($second_parent_agent['is_equal_award_restriction'])) {
  660. $this->desc = "用户({$user_id})配货给用户({$child_id})获得平2级奖励";
  661. $stock_level = CloudStockLevel::findOne(['mall_id' => $this->mall_id, 'level' => $second_parent_agent['level'], 'status' => StatusEnum::ENABLED]);
  662. $this->sendEqualReward($second_parent_agent, $stock_level, 2);
  663. }
  664. }
  665. }
  666. }
  667. return true;
  668. }
  669. public function sendEqualReward($parent_user_agent, $stock_level, $equal_level)
  670. {
  671. $this->equal_level = $equal_level;
  672. $this->bonus_agent = $parent_user_agent;
  673. //该代理商等级是否开启平级奖
  674. if (empty($stock_level['is_equal'])) {
  675. return true;
  676. }
  677. $setting = $this->setting;
  678. $is_frozen = true;
  679. if (empty($setting['settlement_cycle_of_equal_prize'])) {
  680. $is_frozen = false;//平级奖结算周期:立即结算
  681. }
  682. $this->is_frozen = $is_frozen;
  683. $this->getRewardUnitPrice();
  684. $insert_wallet = $this->getInsertWallet(UserWalletEnum::EQUAL);
  685. //投递到资产队列
  686. if ($insert_wallet) CloudStockAgent::sendUserWalletQueue($insert_wallet);
  687. var_dump($insert_wallet);
  688. if (!empty($insert_wallet)) {
  689. $this->setStatistics($insert_wallet, UserWalletEnum::EQUAL);
  690. }
  691. }
  692. public
  693. function getRewardUnitPrice()
  694. {
  695. switch ($this->equal_level) {
  696. case 1:
  697. $config_key = CloudStockEnum::CONFIG_KEY_EQUAL_LEVEL_ONE;
  698. break;
  699. case 2:
  700. $config_key = CloudStockEnum::CONFIG_KEY_EQUAL_LEVEL_TWO;
  701. break;
  702. default:
  703. $this->reward_unit_price = 0;
  704. }
  705. $equal_level_list = json_decode($this->stock_goods['equal_level_list'], true);
  706. //校验该等级存不存
  707. $level = CloudStockLevel::findOne(['mall_id' => $this->mall_id, 'level' => $this->bonus_agent['level'], 'status' => StatusEnum::ENABLED]);
  708. if (!empty($level)) {
  709. foreach ($equal_level_list as $value) {
  710. if ($value['level'] == $this->bonus_agent['level'] && $value['config_key'] == $config_key) {
  711. $this->reward_unit_price = !empty($value['config_value']) ? $value['config_value'] : 0;
  712. return;
  713. }
  714. }
  715. }
  716. $this->reward_unit_price = 0;
  717. }
  718. public
  719. function getInsertWallet($capital_type)
  720. {
  721. $insert_wallet = [];
  722. $commission_num = $this->reward_unit_price * $this->order['num'];
  723. if (empty($commission_num)) return $insert_wallet;
  724. $insert_wallet[] = ['mall_id' =>
  725. $this->mall_id,
  726. 'user_id' => $this->bonus_agent->user_id,
  727. 'is_frozen' => $this->is_frozen,
  728. 'wallet_type' => 'commission',
  729. 'money' => $commission_num,
  730. 'desc' => $this->desc,
  731. 'source_table' => CloudStockDispenseOrder::tableName(),
  732. 'source_table_id' => $this->order['id'],
  733. 'from_type' => AddonsEnum::ADDONS_NAME_CLOUD_STOCK,
  734. 'capital_type' => $capital_type,
  735. 'order_no' => $this->order['order_no'] ?? '',
  736. ];
  737. return $insert_wallet;
  738. }
  739. }