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); } }