qimall/addons/Happiness/client/controllers/UserController.php

<?php

namespace addons\Happiness\client\controllers;

use addons\Store\common\models\StoreOrderDetail;
use addons\Store\common\models\StoreUser;
use addons\Happiness\common\models\HappinessOrder;
use addons\Happiness\common\models\HappinessStoreUser;
use common\enums\StatusEnum;
use common\models\common\MallSetting;
use common\models\order\OrderDetail;
use common\models\user\User;
use common\models\user\UserLevel;

class UserController extends BaseController
{

    /**
     * 门店会员
     * @Author bing
     * @DateTime 2022-04-26 18:07:46
     * @return void
     * @copyright: Copyright (c) 2022 广东七件事集团
     */
    public function actionIndex()
    {
        if (\Yii::$app->request->isAjax) {
            $where = [
                ['mall_id' => $this->mall_id],
                ['store_id' => $this->store_id],
                ['status' => [StatusEnum::ENABLED, StatusEnum::DISABLED]],
            ];
            $get = \Yii::$app->request->get();
            $user_where = [];
            if (!empty($get['nickname_or_mobile'])) {
                $user_where[] = [
                    'OR',
                    ['like', 'mobile', $get['nickname_or_mobile'] . '%', false],
                    ['like', 'nickname', $get['nickname_or_mobile'] . '%', false]
                ];
            }
            if (!empty($get['level'])) {
                $user_where[] = ['level'=>$get['level']];
            }
            if (!empty($get['user_id'])) {
                $user_where[] = ['id'=>$get['user_id']];
            }
            if(!empty($user_where)){
                $user_list = User::lists(['where' =>$user_where, 'select' => 'id']);
                $user_id_arr = array_column($user_list, 'id');
                $where[] = ['user_id' => $user_id_arr];
            }

            $params = [
                'where' => $where,
                'with' => ['user'],
                'order' => 'id desc'
            ];

            $list = HappinessStoreUser::listPage($params);
            if ($list === false) return $this->error(HappinessStoreUser::getStaticError());
            $levels = UserLevel::getListIndexByLevelColumn($this->mall_id);
            $user_level_arr = UserLevel::lists(['where'=>[['mall_id'=>$this->mall_id],['status'=>[StatusEnum::ENABLED,StatusEnum::DISABLED]]],'select'=>'level,name','index'=>'level']);
            if (!empty($list['list'])) {
                foreach ($list['list'] as &$item) {
                    $item['level_name'] = empty($user_level_arr[$item['user']['level']]) ? MallSetting::getDefaultLevelName($this->mall_id) : $user_level_arr[$item['user']['level']]['name'];// 会员等级名称
                }
            }
            $list['levels'] = $levels;
            return $this->success('ok', $list);
        }
        return $this->render($this->action->id);
    }

    public function actionDetail(){
        if (\Yii::$app->request->isAjax) {
            $get =\Yii::$app->request->get();
            $where = [
                ['mall_id' => $this->mall_id],
                ['user_id' => $get['id']],
                ['store_id' => $this->store_id],
                ['status' => [StatusEnum::ENABLED, StatusEnum::DISABLED]],
            ];
            $detail = HappinessStoreUser::getOne($where,true,['user']);
            $detail['ke_dan_jia'] = 0;
            if(!empty($detail['pay_nums'])){
                $detail['ke_dan_jia'] = bcdiv($detail['pay_money'],$detail['pay_nums'],2);
            }
            //获取主订单数据
            $order = HappinessOrder::lists([
                'where' => [
                    ['mall_id' => $this->mall_id],
                    ['user_id' => $get['id']],
                    ['store_id' => $this->store_id],
                ]
            ]);
            $order_ids = array_column($order, 'order_id');
            $order_detail_list = ['list' => []];
            if (!empty($order_ids)) {
                $where = [
                    ['mall_id' => $this->mall_id],
                    ['user_id' => $get['id']],
                    ['order_id' => $order_ids],
                    ['!=','order_status',0],
                    ['status' => [StatusEnum::ENABLED, StatusEnum::DISABLED]],
                ];
                $order_detail_list = OrderDetail::listPage(['where'=>$where,'select'=>'sum(num) num,sum(goods_price) as goods_price,goods_id,goods_name','group'=>'goods_id']);
            }

            return $this->success('ok', ['detail'=>$detail,'order_detail_list'=>$order_detail_list]);
        }
        return $this->render($this->action->id);
    }
}