public static function preProcessSendFailedData($smsName, $accountId)
{
$query = new Query();
$query = $query->from('uhkklpEarlyBirdSmsRecord')->select(['_id', 'failed']);
$record = $query->where(['smsName' => $smsName, 'accountId' => $accountId])->orderBy(['createdAt' => SORT_DESC])->one();
$rows = array();
if ($record['failed'] > 0) {
$failedAll = EarlyBirdSmsFailed::find()->where(['smsRecordId' => $record['_id']])->orderBy(['createdAt' => SORT_ASC])->all();
foreach ($failedAll as $smsFailed) {
$createdAt = MongodbUtil::MongoDate2String($smsFailed->createdAt, 'Y-m-d H:i:s', null);
$row = ['createdAt' => $createdAt, 'mobile' => "'" . $smsFailed->mobile, 'smsContent' => $smsFailed->smsContent, 'status' => '失敗'];
$rows[] = $row;
unset($createdAt, $row);
}
}
return $rows;
}
