request; if ($request->isAjax) { $params = \Yii::$app->request->get(); $params['mall_id'] = $this->mall_id; $params['limit'] = isset($params['limit']) ? $params['limit'] : 10; $params['page'] = isset($params['page']) ? $params['page'] : 1; $where[] = ['status' => StatusEnum::ENABLED]; $where[] = ['mall_id' => $params['mall_id']]; if (!empty($params['nickname'])) { $user_ids = User::find()->select("id")->where(['mall_id' => $this->mall_id])->andWhere(['like', 'nickname', $params['nickname'] . '%', false])->asArray()->column(); if (empty($user_ids)) $this->success('查无此用户'); $where[] = ['in', 'user_id', $user_ids]; } if (!empty($params['activity_status'])) { $activity_ids = PkActivity::find()->select("id")->where(['mall_id' => $this->mall_id])->andWhere(['=', 'activity_status', $params['activity_status']])->asArray()->column(); if (empty($activity_ids)) $this->success('查无活动'); $where[] = ['in', 'activity_id', $activity_ids]; } if (isset($params['is_pay']) && !empty($params['is_pay'])) { $where[] = ['is_pay' => $params['is_pay']]; } else { $where[] = ['in', 'is_pay', [PkEnum::IS_PAY, PkEnum::PAY_RETURN]]; } if (isset($params['order_no']) && $params['order_no'] != '') { $where[] = ['like', 'order_no', $params['order_no']]; } if (isset($params['begin_time']) && $params['begin_time'] != '') { $where[] = ['>=', 'created_at', strtotime($params['begin_time'])]; } if (isset($params['end_time']) && $params['end_time'] != '') { $where[] = ['<', 'created_at', strtotime($params['end_time'])]; } $p_lists = array( 'where' => $where, 'order' => "id desc", 'with' => ['user', 'activity'], 'limit' => $params['limit'], 'page' => $params['page'], ); $data = PkOrder::listPage($p_lists, false, true); if (!empty($data['list'])) { foreach ($data['list'] as &$item) { $item['created_at'] = date('Y-m-d H:i:s', $item['created_at']); } } $data['pay_type'] = PayTypeEnum::getMap(); $this->success('成功', $data); } return $this->render('index', []); } }