OrderController.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: wniu
  5. * Date: 2022/2/28
  6. * Time: 2:22 下午
  7. */
  8. namespace addons\CloudStockTwo\backend\controllers;
  9. use addons\CloudStockTwo\common\enums\CloudStockTwoEnum;
  10. use addons\CloudStockTwo\common\models\CloudStockTwoAgent;
  11. use addons\CloudStockTwo\common\models\CloudStockTwoAgentOrder;
  12. use addons\CloudStockTwo\common\models\CloudStockTwoBuyingOrder;
  13. use addons\CloudStockTwo\common\models\CloudStockTwoFillOrder;
  14. use addons\CloudStockTwo\common\models\CloudStockTwoLevel;
  15. use addons\CloudStockTwo\common\models\CloudStockTwoDeductionDetail;
  16. use addons\CloudStock\common\enums\CloudStockEnum;
  17. use common\enums\StatusEnum;
  18. use common\models\common\Express;
  19. use common\models\goods\Goods;
  20. use common\models\order\Order;
  21. use common\models\user\User;
  22. use common\enums\UserWalletEnum;
  23. use addons\SalesCompany\common\models\SalesCompany;
  24. use common\models\common\CapitalLog;
  25. use common\enums\AddonsEnum;
  26. use common\models\order\OrderDetail;
  27. use common\enums\OrderStatusEnum;
  28. use Yii;
  29. class OrderController extends BaseController
  30. {
  31. public $enableCsrfValidation = false;
  32. public function actionIndex()
  33. {
  34. if (\Yii::$app->request->isAjax) {
  35. $params = Yii::$app->request->get();
  36. $where[] = ['=', 'mall_id', $this->mall_id];
  37. $where[] = ['in', 'status', [StatusEnum::DISABLED, StatusEnum::ENABLED]];
  38. if (!empty($params['keyword'])) {
  39. $user_list = User::find()->where(['or',
  40. ['id' => $params['keyword']],
  41. // ['mobile' => $params['keyword']],
  42. ['nickname' => $params['keyword']]])->select('id')->asArray()->all();
  43. $user_id_arr = array_column($user_list, 'id');
  44. $where[] = ['user_id' => $user_id_arr];
  45. }
  46. if (!empty($params['goods_name'])) {
  47. $goods_list = Goods::listPage(['where' => [['like', 'goods_name', $params['goods_name']]]]);
  48. if ($goods_list['list']) {
  49. $goods_id_arr = array_column($goods_list['list'], 'id');
  50. $where[] = ['goods_id' => $goods_id_arr];
  51. }
  52. }
  53. if (!empty($params['start'])) $where[] = ['>=', 'created_at', strtotime($params['start'] . ' 00:00:00')];
  54. if (!empty($params['end'])) $where[] = ['<=', 'created_at', strtotime($params['end'] . '23:59:59')];
  55. $params['order'] = 'id desc';
  56. $params['with'] = ['user', 'order', 'orderDetail', 'goods'];
  57. if ($params['list_type'] == 'fill_order') {
  58. if (!empty($params['id'])) {
  59. $where[] = ['=', 'id', $params['id']];
  60. }
  61. $params['where'] = $where;
  62. $params['with'] = ['user', 'goods'];
  63. $page_data = CloudStockTwoFillOrder::listPage($params, false);
  64. } else {
  65. if (!empty($params['id'])) {
  66. $where[] = ['=', 'order_id', $params['id']];
  67. }
  68. $params['where'] = $where;
  69. $params['with'] = ['user', 'order', 'orderDetail', 'goods'];
  70. $page_data = CloudStockTwoBuyingOrder::listPage($params, false);
  71. }
  72. return $this->success('操作成功', $page_data);
  73. }
  74. return $this->render('index', []);
  75. }
  76. public function actionInvite()
  77. {
  78. if (\Yii::$app->request->isAjax) {
  79. $params = Yii::$app->request->get();
  80. $where[] = ['=', 'mall_id', $this->mall_id];
  81. $where[] = ['in', 'status', [StatusEnum::DISABLED, StatusEnum::ENABLED]];
  82. if (!empty($params['keyword'])) {
  83. $user_list = User::find()->where(['or',
  84. ['id' => $params['keyword']],
  85. ['like', 'mobile', $params['keyword']],
  86. ['like', 'nickname', $params['keyword']]])->select('id')->asArray()->all();
  87. $user_id_arr = array_column($user_list, 'id');
  88. $where[] = ['user_id' => $user_id_arr];
  89. }
  90. if ($params['status'] != '') {
  91. $where[] = ['=', 'send_status', $params['status']];
  92. }
  93. $params['where'] = $where;
  94. $params['order'] = 'id desc';
  95. $params['with'] = ['user', 'goods'];
  96. $page_data = CloudStockTwoAgentOrder::listPage($params, false);
  97. return $this->success('操作成功', $page_data);
  98. }
  99. return $this->render('invite', []);
  100. }
  101. public function actionExpressList()
  102. {
  103. $express_list = Express::getExpresses([], [], true, '*');
  104. return $this->success('成功', $express_list);
  105. }
  106. public function actionDelivery()
  107. {
  108. if (\Yii::$app->request->isAjax) {
  109. $params = Yii::$app->request->post();
  110. $params['send_status'] = CloudStockTwoEnum::SEND_STATUS_1;
  111. unset($params['_csrf']);
  112. CloudStockTwoAgentOrder::setData($this->mall_id, $params);
  113. return $this->success('发货成功');
  114. }
  115. return $this->render('invite', []);
  116. }
  117. /**
  118. * 订单详情
  119. * @Author bing
  120. * @DateTime 2021-09-06 14:09:56
  121. * @copyright: Copyright (c) 2020 广东七件事集团
  122. * @return void
  123. */
  124. public function actionDetail()
  125. {
  126. if (\Yii::$app->request->isAjax) {
  127. $params = Yii::$app->request->get();
  128. $order_type = $params['type'];
  129. $is_frozen = false;
  130. if($order_type == CloudStockEnum::STOCK_ORDER_TYPE_USER){
  131. $order = CloudStockTwoBuyingOrder::findOne(['id'=>$params['id']]);
  132. $source_table = OrderDetail::tableName();
  133. $source_table_id = $order['order_id'];
  134. $source_table = Order::findOne(['id'=>$source_table_id]);
  135. if($source_table['order_status']!=OrderStatusEnum::ACCOMPLISH)$is_frozen = true;
  136. }else{
  137. $order = CloudStockTwoFillOrder::findOne(['id'=>$params['id']]);
  138. $source_table = CloudStockTwoFillOrder::tableName();
  139. $source_table_id = $order['id'];
  140. }
  141. if(!$order){
  142. return $this->error();
  143. }
  144. $currency_level = 0;
  145. $agent = CloudStockTwoAgent::findOne(['mall_id'=>$order['mall_id'],'user_id'=>$order['user_id'],'status'=>StatusEnum::ENABLED]);
  146. if($agent){
  147. $currency_level = $agent->level;
  148. }
  149. $step_arr = [];
  150. $parent_agent_list = CloudStockTwoAgent::getUserParentAgentList($order['user_id']);
  151. if($parent_agent_list){
  152. //下单用户
  153. $step_arr[] = [
  154. 'agent_user_id' => $order['user_id'],
  155. 'agent_user_level' => $agent->level,
  156. 'agent_user_level_name' => '',
  157. 'agent_user_mobile' => '',
  158. 'agent_user_avatar_url' => '',
  159. 'is_step' => 1,
  160. ];
  161. $reward_list = json_decode($order->reward_list,true);
  162. foreach($parent_agent_list as $key => $agent){
  163. if(isset($reward_list[$agent->user_id][UserWalletEnum::DIFF])){
  164. $step_arr[] = [
  165. 'agent_user_id' => $agent->user_id,
  166. 'agent_user_level' => $agent->level,
  167. 'agent_user_level_name' => '',
  168. 'agent_user_mobile' => '',
  169. 'agent_user_avatar_url' => '',
  170. 'is_step' => 0,
  171. ];
  172. }
  173. // if($agent->level > $currency_level){
  174. // $step_arr[] = [
  175. // 'agent_user_id' => $agent->user_id,
  176. // 'agent_user_level' => $agent->level,
  177. // 'agent_user_level_name' => '',
  178. // 'agent_user_mobile' => '',
  179. // 'agent_user_avatar_url' => '',
  180. // 'is_step' => 0,
  181. // ];
  182. // }
  183. // $currency_level = $agent->level;
  184. }
  185. //平台 或 销售公司
  186. $step_arr[] = [
  187. 'agent_user_id' => 0,
  188. 'agent_user_level' => 0,
  189. 'agent_user_level_name' => '平台【总部】',
  190. 'agent_user_mobile' => '',
  191. 'agent_user_avatar_url' => '',
  192. 'is_step' => 0,
  193. ];
  194. }
  195. $level_arr = array_column($step_arr,'agent_user_level');
  196. $level_list = CloudStockTwoLevel::lists(['where' => [['mall_id' => $this->mall_id], ['level' => $level_arr],['status'=>[StatusEnum::DISABLED,StatusEnum::ENABLED]]], 'index' => 'level']);
  197. $user_id_arr = array_column($step_arr,'agent_user_id');
  198. $user_arr = User::lists(['where'=>[['id'=>$user_id_arr]],'index'=>'id']);
  199. $detail_list = CloudStockTwoDeductionDetail::lists(['where' => [['mall_id' => $this->mall_id], ['order_id' => $params['id']],['order_type'=>$order_type],['status'=>[StatusEnum::DISABLED,StatusEnum::ENABLED]]], 'index' => 'user_id']);
  200. if(!empty($detail_list)){
  201. foreach ($detail_list as &$item) {
  202. if (isset($user_arr[$item['user_id']])) {
  203. $item['agent_user_id'] = $user_arr[$item['user_id']]['id'];
  204. $item['agent_user_avatar_url'] = $user_arr[$item['user_id']]['avatar_url'];
  205. $item['agent_user_nickname'] = $user_arr[$item['user_id']]['nickname'];
  206. } else {
  207. $item['agent_user_id'] = $item['user_id'];
  208. $item['agent_user_avatar_url'] = '';
  209. if($item['is_sales'] && $item['company_id']){
  210. $salesCompany = SalesCompany::findOne(['id'=>$item['company_id']]);
  211. $item['agent_user_id'] = $salesCompany ? $salesCompany->user_id : 0;
  212. $item['agent_user_nickname'] = $salesCompany ? $salesCompany->name : '';
  213. }else{
  214. $item['agent_user_nickname'] = '平台';
  215. }
  216. }
  217. }
  218. }
  219. $data['detail_list'] = $detail_list;
  220. foreach($step_arr as &$step){
  221. if(isset($user_arr[$step['agent_user_id']])){
  222. $step['agent_user_mobile'] = $user_arr[$step['agent_user_id']]['mobile'];
  223. $step['agent_user_avatar_url'] = $user_arr[$step['agent_user_id']]['avatar_url'];
  224. $step['agent_user_level_name'] = $user_arr[$step['agent_user_id']]['nickname'];
  225. }
  226. if(isset($level_list[$step['agent_user_level']])){
  227. $step['agent_user_level_name'] .= '【'.$level_list[$step['agent_user_level']]['name'].'】';
  228. }
  229. if(isset($detail_list[$step['agent_user_id']])){
  230. $step['is_step'] = 1;
  231. }
  232. if($step['agent_user_id']==0 && isset($detail_list[0])){
  233. if($detail_list[0]['is_sales']){
  234. $salesCompany = SalesCompany::findOne(['id'=>$detail_list[0]['company_id']]);
  235. if($salesCompany){
  236. $step['agent_user_level_name'] = $salesCompany->name.'【销售公司】';
  237. }
  238. }
  239. }
  240. }
  241. $data['step_arr'] = $step_arr;
  242. $where['where'] = [
  243. ['source_table' => $source_table],
  244. ['source_table_id' => $source_table_id],
  245. ['from_type' => AddonsEnum::ADDONS_NAME_CLOUD_STOCK_TWO],
  246. ];
  247. $wallet_type = 'commission';
  248. CapitalLog::$capitalType = 'commission';
  249. if($is_frozen){
  250. CapitalLog::$capitalType = "{$wallet_type}_frozen";
  251. $where['where'][] = ['status' => CapitalLog::STATUS_WAIT_SEND];
  252. }
  253. $commission_list = CapitalLog::lists($where);
  254. $commission_map = UserWalletEnum::getCommissionMap();
  255. $capital_type_map = UserWalletEnum::getCapitalTypeMapByCommission();
  256. if ($commission_list) {
  257. $user_id_arr = array_column($commission_list,'user_id');
  258. $user_arr = User::lists([
  259. 'where'=>[
  260. ['id'=>$user_id_arr]
  261. ],
  262. 'index'=>'id',
  263. ]);
  264. foreach ($commission_list as &$lv) {
  265. $lv['source_text'] = ($commission_map[$lv['from_type']] ?? '') . ($capital_type_map[$lv['capital_type']] ? '-' . $capital_type_map[$lv['capital_type']] : '');
  266. $lv['created_at'] = date('Y-m-d H:i:s', $lv['created_at']);
  267. $lv['nickname'] = '';
  268. $lv['avatar_url'] = '';
  269. $lv['mobile'] = '';
  270. $lv['username'] = '';
  271. if(isset($user_arr[$lv['user_id']])){
  272. $lv['nickname'] = $user_arr[$lv['user_id']]['nickname'];
  273. $lv['avatar_url'] = $user_arr[$lv['user_id']]['avatar_url'];
  274. $lv['mobile'] = $user_arr[$lv['user_id']]['mobile'];
  275. $lv['username'] = $user_arr[$lv['user_id']]['username'];
  276. }
  277. }
  278. }
  279. $data['capital_log'] = $commission_list;
  280. return $this->success('请求成功',$data);
  281. }
  282. return $this->render($this->action->id);
  283. }
  284. }