public function actionGetList()
{
$currentPage = Yii::$app->request->get("currentPage", 1);
$pageSize = Yii::$app->request->get("pageSize", 10);
$offset = ($currentPage - 1) * $pageSize;
$sortName = "_id";
$sortDesc = Yii::$app->request->get('sortDesc', 'ASC');
$sort = $sortName . ' ' . $sortDesc;
$keyword = Yii::$app->request->get("keyword", '');
$query = new Query();
$accountId = $this->getAccountId();
if ($keyword == '') {
$records = $query->from('uhkklpOrder')->select(['_id', 'createdAt', 'name', 'mobile', 'restaurantName', 'address', 'businessForm', 'product'])->where(['accountId' => $accountId])->orderBy($sort)->offset($offset)->limit($pageSize)->all();
} else {
$records = $query->from('uhkklpOrder')->select(['_id', 'createdAt', 'name', 'mobile', 'restaurantName', 'address', 'businessForm', 'product'])->where(['accountId' => $accountId])->andWhere(['like', 'mobile', $keyword])->orderBy($sort)->offset($offset)->limit($pageSize)->all();
}
for ($i = 0; $i < count($records); $i++) {
$records[$i]['createdAt'] = MongodbUtil::MongoDate2String($records[$i]['createdAt'], 'Y-m-d H:i:s', null);
$records[$i]['_id'] = (string) $records[$i]['_id'];
}
$query = new Query();
if ($keyword == '') {
$totalPageCount = $query->from('uhkklpOrder')->where(['accountId' => $accountId])->count();
} else {
$totalPageCount = $query->from('uhkklpOrder')->where(['accountId' => $accountId])->andWhere(['like', 'name', $keyword])->count();
}
// LogUtil::error(date('Y-m-d h:i:s') . ' $totalPageCount: ' . $totalPageCount);
Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
return ['code' => 200, 'list' => $records, 'totalPageCount' => $totalPageCount];
}
public function perform()
{
$args = $this->args;
if (empty($args['key']) || empty($args['header']) || empty($args['accountId'])) {
ResqueUtil::log(['status' => 'fail to export registration record', 'message' => 'missing params', 'args' => $args]);
return false;
}
$keyword = $args['keyword'];
$header = $args['header'];
$fileName = $args['key'];
$accountId = unserialize($args['accountId']);
$filePath = ExcelUtil::getFile($fileName, 'csv');
$query = new Query();
if ($keyword == '') {
$records = $query->from('uhkklpRegistration')->select(['name', 'mobile', 'restaurantName', 'zipCode', 'city', 'address'])->where(['accountId' => $accountId])->all();
} else {
$records = $query->from('uhkklpRegistration')->select(['name', 'mobile', 'restaurantName', 'zipCode', 'city', 'address'])->where(['accountId' => $accountId])->andWhere(['like', 'mobile', $keyword])->all();
}
$rows = $records;
ExcelUtil::exportCsv($header, $rows, $filePath, 1);
$hashKey = ExcelUtil::setQiniuKey($filePath, $fileName);
if ($hashKey) {
//notice frontend the job is finished
Yii::$app->tuisongbao->triggerEvent(Message::EVENT_EXPORT_FINISH, ['key' => $fileName], [Message::CHANNEL_GLOBAL]);
return true;
} else {
ResqueUtil::log(['status' => 'fail to export registration', 'message' => 'fail to setQiniuKey', 'filePath' => $filePath]);
return false;
}
}
private function _savePushMessages($messageId, $phoneNums)
{
$pushUsers = [];
if (empty($phoneNums)) {
$query = new Query();
$result = $query->from(PushUser::collectionName())->select(['token', 'deviceType', 'mobile'])->where(['accountId' => $this->getAccountId()])->all();
$pushUsers = array_merge($pushUsers, $result);
} else {
foreach ($phoneNums as $phone) {
$query = new Query();
$result = $query->from(PushUser::collectionName())->select(['token', 'deviceType', 'mobile'])->where(['mobile' => $phone, 'accountId' => $this->getAccountId()])->all();
$pushUsers = array_merge($pushUsers, $result);
}
}
$pushUsers = $this->_uniquePushUsers($pushUsers);
foreach ($pushUsers as $pushUser) {
$pushMessage = new PushMessage();
if (!empty($pushUser['mobile'])) {
$pushMessage->mobile = $pushUser['mobile'];
}
$pushMessage->token = $pushUser['token'];
$pushMessage->deviceType = $pushUser['deviceType'];
$pushMessage->messageId = $messageId;
if (!empty($this->getAccountId())) {
$pushMessage->accountId = $this->getAccountId();
}
$pushMessage->insert();
}
}
public function getList($condition = [])
{
$sort = ['begin' => SORT_DESC];
$query = new Query();
$data = $query->from(self::collectionName())->select($this->attributes())->where($condition)->orderBy($sort)->all();
return $data;
}
public function actionRegister()
{
//get request
$postData = file_get_contents('php://input', true);
$data = json_decode($postData, true);
$mobile = $data['data']['phone'];
Yii::getLogger()->log($data['data'], 2, "webhook");
//send sms
if ($mobile != null && $mobile != '') {
$reminder = new Reminder();
$createDate = time();
$reminder->mobile = $mobile;
$reminder->createDate = $createDate;
$reminder->updated = false;
$reminder->origin = 'webhook';
$reminder->save();
$rid = $reminder->_id . '';
$reminder->url = $this->replaceHttp(Yii::$app->request->hostInfo) . "/user/reset_password/" . $rid;
Yii::getLogger()->log($reminder->url, 2, "webhookUrl");
$reminder->save();
$name = null;
$qry = new Query();
$qry->from('reward');
$list = $qry->all();
if ($list != null && count($list) > 0) {
$name = $list[0]['name'];
}
if ($name == null) {
$name = "\$25聖安娜蛋糕禮券";
}
$content = "恭喜您參加家樂牌「儲分有賞」活動。您的帳戶已建立，立即按連結重設密碼並登入，即可查詢分數並有機會獲得" . $name . "!\n" . $reminder->url;
Yii::getLogger()->log($content, 2, "content");
Yii::$app->sms->sendSms($reminder->mobile, $content);
}
}
/**
* @inheritdoc
*/
public function get()
{
$query = new Query();
$rows = $query->from($this->collection)->all();
$values = [];
foreach ($rows as $row) {
$values[$row['id']] = $row['value'];
}
return $values;
}
public static function findList($currentPage = 1, $pageSize = 10, $condition = [])
{
$offset = ($currentPage - 1) * $pageSize;
$query = new Query();
$users = $query->from('uhkklpActivityUser')->select(['_id', 'deviceId', 'prizeContent', 'mobile', 'createdAt'])->where($condition)->orderBy(['createdAt' => SORT_DESC])->offset($offset)->limit($pageSize)->all();
for ($i = 0; $i < count($users); $i++) {
$users[$i]['createdAt'] = MongodbUtil::MongoDate2String($users[$i]['createdAt'], 'Y-m-d H:i:s', null);
}
return $users;
}
public function testQuery()
{
$query = new Query();
$query->from('customer');
$provider = new ActiveDataProvider(['query' => $query, 'db' => $this->getConnection()]);
$models = $provider->getModels();
$this->assertEquals(10, count($models));
$provider = new ActiveDataProvider(['query' => $query, 'db' => $this->getConnection(), 'pagination' => ['pageSize' => 5]]);
$models = $provider->getModels();
$this->assertEquals(5, count($models));
}
public static function findList($currentPage = 1, $pageSize = 10, $condition = [])
{
$offset = ($currentPage - 1) * $pageSize;
$query = new Query();
$records = $query->from('uhkklpLuckyDrawRecord')->select(['_id', 'createdAt', 'remark'])->where($condition)->orderBy(['createdAt' => SORT_DESC])->offset($offset)->limit($pageSize)->all();
for ($i = 0; $i < count($records); $i++) {
$records[$i]['createdAt'] = MongodbUtil::MongoDate2String($records[$i]['createdAt'], 'Y-m-d H:i:s', null);
$records[$i]['_id'] = (string) $records[$i]['_id'];
}
return $records;
}
public function testFrom()
{
$query = new Query();
$from = 'customer';
$query->from($from);
$this->assertEquals($from, $query->from);
$query = new Query();
$from = ['', 'customer'];
$query->from($from);
$this->assertEquals($from, $query->from);
}
public function perform()
{
$args = $this->args;
if (empty($args['key']) || empty($args['header']) || empty($args['accountId'])) {
ResqueUtil::log(['status' => 'fail to export goods record', 'message' => 'missing params', 'args' => $args]);
return false;
}
$keyword = $args['keyword'];
$header = $args['header'];
$fileName = $args['key'];
$accountId = unserialize($args['accountId']);
$filePath = ExcelUtil::getFile($fileName, 'csv');
$query = new Query();
if ($keyword == '') {
$records = $query->from('uhkklpOrder')->select(['_id', 'createdAt', 'name', 'mobile', 'restaurantName', 'address', 'businessForm', 'product'])->where(['accountId' => $accountId])->all();
} else {
$records = $query->from('uhkklpOrder')->select(['_id', 'createdAt', 'name', 'mobile', 'restaurantName', 'address', 'businessForm', 'product'])->where(['accountId' => $accountId])->andWhere(['like', 'mobile', $keyword])->all();
}
for ($i = 0; $i < count($records); $i++) {
$records[$i]['createdAt'] = MongodbUtil::MongoDate2String($records[$i]['createdAt'], 'Y-m-d H:i:s', null);
$records[$i]['_id'] = (string) $records[$i]['_id'];
$pro = "";
for ($j = 0; $j < count($records[$i]['product']); $j++) {
$pro .= " " . $records[$i]['product'][$j];
}
$records[$i]['product'] = $pro;
}
$rows = $records;
ExcelUtil::exportCsv($header, $rows, $filePath, 1);
$hashKey = ExcelUtil::setQiniuKey($filePath, $fileName);
if ($hashKey) {
//notice frontend the job is finished
Yii::$app->tuisongbao->triggerEvent(Message::EVENT_EXPORT_FINISH, ['key' => $fileName], [Message::CHANNEL_GLOBAL]);
return true;
} else {
ResqueUtil::log(['status' => 'fail to export order', 'message' => 'fail to setQiniuKey', 'filePath' => $filePath]);
return false;
}
}
public static function getSampleRecordExcelDate($cookbookId, $accountId)
{
$query = new Query();
$query->from('uhkklpSamplerecord')->select(['mobile', 'cookbookTitle', 'sampleId', 'sampleName', 'username', 'city', 'address', 'createdDate', 'quantity', 'sent'])->where(['cookbookId' => $cookbookId])->andWhere(['accountId' => $accountId]);
$list = $query->all();
$rows = [];
for ($i = 0; $i < count($list); $i++) {
$row = ['mobile' => $list[$i]['mobile'], 'sampleName' => $list[$i]['sampleName'], 'username' => $list[$i]['username'], 'city' => $list[$i]['city'], 'address' => $list[$i]['address'], 'quantity' => $list[$i]['quantity']];
$rows[] = $row;
unset($row);
}
return $rows;
}
public function actionInit()
{
$blackList = ['0978085158', '0927965300', '0919068348', '0917256888', '0935293966', '0926231395', '0922376121', '0918762006', '0920220502', '0937041116', '0976556382', '0926163196', '0989563597', '0933170602', '0982100057', '0926988398', '0986265939', '0910254314', '0937189314', '0972113501', '0912210412', '0987906236', '0937005340', '0916206650', '0918789015', '0985979734', '0910619168', '0912866012', '0930002577', '0937006276', '0982066318', '0909111302', '0911031494', '0912600810', '0981365018', '0919096112', '0911091053', '0923319780', '0989173848', '0952655000', '0979767968', '0905630508', '0963260389', '0958917419', '0929190959', '0939068141', '0925338020', '0912764270', '0913177063', '0921530245', '0911078461', '0982919062', '0960000277'];
$query = new Query();
$query->from('voucher_black');
$count = $query->count();
if ($count == 0) {
foreach ($blackList as $mobile) {
$item = new VoucherBlack();
$item->mobile = $mobile;
$item->enable = true;
$item->save();
}
}
}
public static function getResults($messageId)
{
$query1 = new Query();
$data = $query1->from(self::collectionName())->select(['messageId', 'results'])->where(['messageId' => $messageId])->all();
if (empty($data)) {
return [];
}
$data = $data[0];
$query2 = new Query();
$messageContent = $query2->from(Message::collectionName())->select(['content'])->where(['_id' => new \MongoId($messageId)])->all()[0]['content'];
$results = [];
foreach ($data['results'] as $key => $value) {
if (empty($value['mobile'])) {
$value['mobile'] = '';
}
if ($value['type'] == 'iOS') {
if (empty($value['res']) || $value['res'] != 200) {
$value['res'] = '失敗';
} else {
$value['res'] = '成功';
}
} else {
if (!empty($value['res'])) {
$jsonObj = json_decode($value['res']);
if ($jsonObj->success != null && $jsonObj->success > 0) {
$value['res'] = '成功';
} else {
$value['res'] = '失敗';
}
}
}
// $query3 = new Query();
// $mobile = $query3->from(PushUser::collectionName())
// ->select(['mobile'])
// ->where(['token' => $value['token']])
// ->all();
// if (empty($mobile)) {
// $mobile = '';
// } else {
// $mobile = $mobile[0]['mobile'];
// }
$results[] = ['messageId' => $messageId, 'messageContent' => $messageContent, 'mobile' => $value['mobile'] . ' ', 'deviceType' => $value['type'], 'deviceId' => $value['token'], 'result' => $value['res']];
}
return $results;
}
public static function getList($currentPage = 1, $pageSize = 10, $sort = [], $condition = [])
{
if (empty($sort)) {
$sort = ['_id' => SORT_DESC];
} else {
foreach ($sort as $key => $value) {
if ($value) {
$sort = [$key => SORT_DESC];
} else {
$sort = [$key => SORT_ASC];
}
}
}
$offset = ($currentPage - 1) * $pageSize;
$query = new Query();
$datas = $query->from(self::collectionName())->select(self::attributes())->where(['accountId' => Token::getAccountId()])->andWhere($condition)->orderBy($sort)->offset($offset)->limit($pageSize)->all();
return $datas;
}
public function getList($currentPage = 1, $pageSize = 10, $sort, $condition = [])
{
if (empty($sort)) {
$sort = ['_id' => SORT_DESC];
} else {
foreach ($sort as $key => $value) {
if ($value) {
$sort = [$key => SORT_DESC];
} else {
$sort = [$key => SORT_ASC];
}
}
}
$offset = ($currentPage - 1) * $pageSize;
$condition['isDeleted'] = false;
$query = new Query();
$datas = $query->from(self::collectionName())->select($this->attributes())->where($condition)->orderBy($sort)->offset($offset)->limit($pageSize)->all();
return $datas;
}
public function testLike()
{
$connection = $this->getConnection();
$query = new Query();
$rows = $query->from('customer')->where(['LIKE', 'name', '/me1/'])->all($connection);
$this->assertEquals(2, count($rows));
$this->assertEquals('name1', $rows[0]['name']);
$this->assertEquals('name10', $rows[1]['name']);
}
public function actionLogin()
{
$mobile = Yii::$app->request->post("mobile");
$password = Yii::$app->request->post("password");
if ($mobile != null && $password != null) {
$url = QUN_CRM_API . '/members/' . $mobile . '?access_token=' . QUN_CRM_ACCESS_TOKEN;
$response = Yii::$app->curl->get($url);
$member = json_decode($response, true);
if (isset($member["custom_properties"])) {
$properties = $member["custom_properties"];
$i = 0;
$firstChoiceDealer = null;
$passwordNotFound = true;
for (; $i < count($properties); $i++) {
$property = $properties[$i];
//property_id value
if (isset($property["property_id"]) && isset($property["value"]) && $property["property_id"] == "firstChoiceDealer") {
$firstChoiceDealer = $property["value"];
}
if (isset($property["property_id"]) && isset($property["value"]) && $property["property_id"] == "pwd") {
$passwordNotFound = false;
if ($property["value"] == $password) {
// tag app user
$origin = Yii::$app->request->post("origin");
if (!empty($origin) && ($origin == 'app:android' || $origin == 'app:ios')) {
$url = QUN_CRM_API . '/members/tags?access_token=' . QUN_CRM_ACCESS_TOKEN;
$body = ['member_ids' => [$member['id']], 'tags' => [TAG_APP_USER]];
$tagResp = Yii::$app->curl->postJson($url, json_encode($body));
}
// operations
$url = QUN_CRM_API . '/members/' . $mobile . '/operations?access_token=' . QUN_CRM_ACCESS_TOKEN;
$body = ['operation' => 'login'];
Yii::$app->curl->postJson($url, json_encode($body));
// update loginAt
$this->update(['phone' => $mobile, 'id' => $member['id'], 'custom_properties' => [['property_id' => 'loginAt', 'value' => date('c')]]]);
} else {
\Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
return ['code' => 405];
}
}
}
if ($passwordNotFound) {
\Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
return ['code' => 405];
}
//get voucher by mobile
$voucher = null;
$query = new Query();
$query->from('voucher')->where(['mobile' => $mobile]);
$list = $query->all();
//if voucher is existent
if ($list != null && count($list) > 0 && $firstChoiceDealer == null) {
$voucher = $list[0];
//answerd is false
if (!$voucher['answered']) {
$voucherId = $voucher['_id'];
$member['voucherId'] = $voucherId;
}
} else {
//create voucher
$voucher = new Voucher();
$voucher->mobile = $mobile;
$voucher->createdDate = time();
$voucher->voucherGuid = null;
$voucher->voucherNo = null;
$voucher->answered = false;
$voucher->finished = false;
$voucher->requestGuid = $this->getGUID();
//if he has answered the questions.
if ($firstChoiceDealer != null) {
$voucher->answered = true;
$voucher->save();
} else {
$voucher->save();
$member['voucherId'] = $voucher->_id;
}
}
\Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
return $member;
}
}
\Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
return ['code' => 406];
}
private function formatCookbookForAPI($cookbook)
{
//averageScore
if (!isset($cookbook['averageScore'])) {
$cookbook['averageScore'] = 0.0;
}
//isNewest
for ($i = 0; $i < count($cookbook['type']); $i++) {
if ($cookbook['type'][$i] == '最新食譜') {
$cookbook['isNewest'] = 'Y';
} else {
$cookbook['isNewest'] = 'N';
}
}
//collection number
$cookbookId = $cookbook['cookbookId'];
$query = new Query();
$query->from('uhkklpUserCookbook')->where(['cookbookId' => $cookbookId])->andWhere(['collection' => 'Y']);
$collectionNumber = $query->count();
$cookbook['collectionNumber'] = $collectionNumber;
//score number
$cookbookId = $cookbook['cookbookId'];
$query = new Query();
$query->from('uhkklpUserCookbook')->where(['cookbookId' => $cookbookId]);
$scorerNumber = $query->count();
$cookbook['scorerNumber'] = $scorerNumber;
//sample
$sample = $cookbook['sample'];
for ($j = 0; $j < count($sample); $j++) {
$querySample = new Query();
$querySample->from('uhkklpSample')->where(['_id' => $sample[$j]['id']]);
$sampleDate = $querySample->one();
$cookbook['sample'][$j]['imgUrl'] = $sampleDate['imgUrl'];
$cookbook['sample'][$j]['explain'] = $sampleDate['quantity'];
unset($cookbook['sample'][$j]['quantity']);
}
return $cookbook;
}
public static function pushMessage($messageId, $time)
{
$time = (int) $time;
$logFileName = 'pushmessage';
$logMsg = 'Message (' . $messageId . ') started to push at ' . date('Y-m-d H:i:s', time());
LogUtil::error('uhkklp-push-message: ' . $logMsg);
$queryMessage = new Query();
$logMsg = '---Find message by id...';
LogUtil::error('uhkklp-push-message: ' . $logMsg);
$message = $queryMessage->from('uhkklpMessage')->select(['content', 'linkType', 'newsId', 'pushTime'])->where(['_id' => new \MongoId($messageId)])->all();
if (empty($message)) {
$logMsg = 'Push canseled, message was deleted in database';
LogUtil::error('uhkklp-push-message: ' . $logMsg);
return;
}
$message = $message[0];
if ($message['pushTime']->sec != $time) {
$logMsg = 'Push canseled, pushTime was changed in database';
LogUtil::error('uhkklp-push-message: ' . $logMsg);
return;
}
$logMsg = '---done';
LogUtil::error('uhkklp-push-message: ' . $logMsg);
$logMsg = '---Find tokens...';
LogUtil::error('uhkklp-push-message: ' . $logMsg);
$queryUser = new Query();
$users = $queryUser->from('uhkklpPushMessage')->select(['mobile', 'token', 'deviceType', 'accountId'])->where(['messageId' => new \MongoId($messageId)])->all();
$logMsg = '---done';
LogUtil::error('uhkklp-push-message: ' . $logMsg);
$gcmUtil = new GCMUtil();
$apmUtil = new APMUtil();
$logMsg = '---Pushing...';
LogUtil::error('uhkklp-push-message: ' . $logMsg);
$msg['content'] = $message['content'];
$msg['linkType'] = $message['linkType'];
$msg['newsId'] = $message['newsId'];
$log = new PushMessageLog();
$log->messageId = $messageId;
$log->startTime = date('Y-m-d H:i:s', time());
$log->save();
$results = [];
foreach ($users as $user) {
if ($user['deviceType'] == PushUser::DEVICE_ANDROID) {
$response = $gcmUtil->pushMessageByToken($user['token'], $msg, $user['accountId']);
LogUtil::error('GCMUtil: ' . $user['token'] . ' ' . $response);
} else {
$response = $apmUtil->pushMsg($user['token'], $msg, $user['accountId']);
LogUtil::error('APMUtil: ' . $user['token'] . ' ' . $response);
}
$result['type'] = $user['deviceType'];
$result['token'] = $user['token'];
if (!empty($user['mobile'])) {
$result['mobile'] = $user['mobile'];
}
$result['res'] = $response;
$results[] = $result;
$log->results = $results;
$log->save();
unset($result);
}
$apmUtil->closeFp();
$logMsg = 'Push finished at ' . date('Y-m-d H:i:s', time());
LogUtil::error('uhkklp-push-message: ' . $logMsg);
$log->endTime = date('Y-m-d H:i:s', time());
$log->accountId = $user['accountId'];
$log->save();
$uhkklpMessage = Message::findOne([$messageId]);
$uhkklpMessage->isPushed = true;
$uhkklpMessage->update();
return $results;
}
/**
* @see https://github.com/yiisoft/yii2/issues/7010
*/
public function testSelect()
{
$connection = $this->getConnection();
$query = new Query();
$rows = $query->from('customer')->select(['name' => true, '_id' => false])->limit(1)->all($connection);
$row = array_pop($rows);
$this->assertArrayHasKey('name', $row);
$this->assertArrayNotHasKey('address', $row);
$this->assertArrayNotHasKey('_id', $row);
}
public function actionShowAnsweredTwo()
{
$query = new Query();
$query->from('popular_voter')->where(['sample' => ['$ne' => null], 'hasPrize' => ['$ne' => 1]]);
//第二批已答题人数
$list = $query->all();
$answeredTwo = count($list);
$query->from('popular_voter')->where(['hasPrize' => ['$ne' => 1]]);
$list = $query->all();
$userAllTwo = count($list);
\Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
return ['answeredTwo' => $answeredTwo, 'userAllTwo' => $userAllTwo];
}
public static function findByAttributes(array $attributes)
{
$query = new Query();
$class_name = get_called_class();
$instance = new $class_name();
$table_name = $instance->getTableName();
if ($result = $query->from($table_name)->where($attributes)->one()) {
$obj = new $class_name($result);
return $obj;
}
return false;
}
/**
* @return array applied migration entries
*/
protected function getMigrationHistory()
{
$query = new Query();
return $query->from('migration')->all();
}
/**
* @see https://github.com/yiisoft/yii2/issues/4879
*
* @depends testInCondition
*/
public function testInConditionIgnoreKeys()
{
$connection = $this->getConnection();
$query = new Query();
$rows = $query->from('customer')->where(['in', 'name', [10 => 'name1', 15 => 'name5']])->all($connection);
$this->assertEquals(2, count($rows));
$this->assertEquals('name1', $rows[0]['name']);
$this->assertEquals('name5', $rows[1]['name']);
}
public function getItem($condition = [])
{
$query = new Query();
$data = $query->from(self::collectionName())->select($this->attributes())->where($condition)->one();
return $data;
}
public function actionGetResultList()
{
$currentPage = Yii::$app->request->get("currentPage", 1);
$pageSize = Yii::$app->request->get("pageSize", 10);
$offset = ($currentPage - 1) * $pageSize;
$sortName = "_id";
$sortDesc = Yii::$app->request->get('sortDesc', 'ASC');
$sort = $sortName . ' ' . $sortDesc;
$query = new Query();
$records = $query->from('uhkklpSmsRecordModel')->select(['_id', 'modelContent', 'createdAt', 'totalRecord', 'successRecord', 'failureRecord'])->where(['accountId' => (string) $this->getAccountId()])->orderBy($sort)->offset($offset)->limit($pageSize)->all();
for ($i = 0; $i < count($records); $i++) {
$records[$i]['createdAt'] = MongodbUtil::MongoDate2String($records[$i]['createdAt'], 'Y-m-d H:i:s', null);
$records[$i]['_id'] = (string) $records[$i]['_id'];
}
$totalPageCount = $query->from('uhkklpSmsRecordModel')->where(['accountId' => (string) $this->getAccountId()])->count();
Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
return ['code' => 200, 'list' => $records, 'totalPageCount' => $totalPageCount];
}
private function checkExist($accountId, $name)
{
$queryCookingtype = new Query();
$queryCookingtype->from('uhkklpCookingtype')->where(['accountId' => $accountId]);
$cookingTypes = $queryCookingtype->all();
for ($i = 0; $i < count($cookingTypes); $i++) {
if ($cookingTypes[$i]['name'] == $name) {
break;
}
}
if ($i >= count($cookingTypes)) {
return true;
}
return false;
}
public function actionGetTags()
{
$accountId = $this->getAccountId();
$query = new Query();
$query->from('uhkklpCookingtype')->where(['isDeleted' => false])->andWhere(['accountId' => $accountId]);
$list = $query->all();
$tags = [];
for ($i = 0; $i < count($list); $i++) {
if ($list[$i]['category'] == '大類') {
for ($j = 0; $j < count($tags); $j++) {
if ($tags[$j]['name'] == $list[$i]['name']) {
if (isset($list[$i]['radio'])) {
if ($list[$i]['radio'] == 'true') {
$tags[$j]['isRadio'] = 'Y';
} else {
$tags[$j]['isRadio'] = 'N';
}
} else {
$tags[$j]['isRadio'] = 'Y';
}
break;
}
}
if ($j >= count($tags)) {
$tag = [];
$tag['name'] = $list[$i]['name'];
$tag['items'] = [];
if (isset($list[$i]['radio'])) {
if ($list[$i]['radio'] == 'true') {
$tag['isRadio'] = 'Y';
} else {
$tag['isRadio'] = 'N';
}
} else {
$tag['isRadio'] = 'Y';
}
array_push($tags, $tag);
}
}
if ($list[$i]['category'] != '大類' && $list[$i]['category'] != '固定分類') {
for ($j = 0; $j < count($tags); $j++) {
if ($tags[$j]['name'] == $list[$i]['category']) {
array_push($tags[$j]['items'], $list[$i]['name']);
break;
}
}
if ($j >= count($tags)) {
$tag = [];
$tag['name'] = $list[$i]['category'];
$tag['items'] = [];
array_push($tag['items'], $list[$i]['name']);
$tag['isRadio'] = 'Y';
array_push($tags, $tag);
}
}
}
Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
return ['code' => 200, 'msg' => 'OK', 'result' => $tags];
}
public function actionListAll()
{
$accountId = $this->getAccountId();
$query = new Query();
$query->from('uhkklpSample')->where(['isDeleted' => false])->andWhere(['accountId' => $accountId])->orderBy('createdAt DESC');
$list = $query->all();
$list = $this->formatSampleList($list);
Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
return ['code' => 200, 'msg' => 'OK', 'result' => $list];
}
