request; if ($request->isAjax) { if ($request->isPost) { $post = Yii::$app->request->post(); // 检查提交的参数 $res = Yii::$app->services->validate->validate($post, [ [['mobile', 'user_id', 'user_name', 'note_type', 'reward_source'], 'safe'], [['limit'], 'default', 'value' => '15'], ]); if ($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage()); $post = AddonsOperatingNoteRewardRecord::exceptNullVal($post); // 根据搜索手机号查询用户id if (isset($post['mobile']) && !empty($post['mobile'])) { $user_ids = User::find()->select("id")->where(['mall_id' => $this->mall_id])->andWhere(['like', 'mobile', $post['mobile'] . '%', false])->asArray()->column(); if (empty($user_ids)) $this->success('查无此用户'); $where[] = ['in', 'user_id', $user_ids]; } // 根据搜索会员昵称查询用户id if (isset($post['user_name']) && !empty($post['user_name'])) { $user_ids = User::find()->select("id")->where(['mall_id' => $this->mall_id])->andWhere(['like', 'nickname', $post['user_name'] . '%', false])->asArray()->column(); $where[] = ['in', 'user_id', $user_ids]; } if (isset($post['user_id']) && !empty($post['user_id'])) { $where[] = ['=', 'user_id', $post['user_id']]; } if (isset($post['note_type']) && $post['note_type'] > 0) { $where[] = ['=', 'note_type', $post['note_type']]; } if (isset($post['reward_source']) && $post['reward_source'] > 0) { $where[] = ['=', 'reward_source', $post['reward_source']]; } $where[] = ['=', 'mall_id', $this->mall_id]; $order = 'id desc'; $params = array('where' => $where, 'order' => $order, 'limit' => $post['limit'], 'with' => ['user']); $list = AddonsOperatingNoteRewardRecord::listPage($params, false, true); if ($list['list']) { foreach ($list['list'] as $k => &$v) { if ($v['note_type'] == 1) { $list['list'][$k]['note_type_name'] = '图文'; } elseif ($v['note_type'] == 2) { $list['list'][$k]['note_type_name'] = '视频'; } else { $list['list'][$k]['note_type_name'] = '广告'; } if ($v['reward_source'] == 1) { $list['list'][$k]['reward_source_name'] = '阅读'; } else { $list['list'][$k]['reward_source_name'] = '分享'; } if ($v['reward_type'] == 0) { $v['reward_content'] = floatval($v['reward_content']) . '积分'; } elseif ($v['reward_type'] == 1) { $v['reward_content'] = floatval($v['reward_content']) . '余额'; } else { $v['reward_content'] = floatval($v['reward_content']) . '红包'; } } } $this->success('获取成功', $list); } } return $this->render($this->action->id); } }