public static function closeExpiredOrders()
{
$tableName = MOrder::tableName();
$n = Yii::$app->db->createCommand()->delete($tableName, 'status=:status AND create_time < DATE_SUB(NOW(), INTERVAL 2 day)', [':status' => MOrder::STATUS_DRAFT])->execute();
U::W("UPDATE {$tableName}, {$n} --- 系统删除2天前的僵死订单。");
// auto close the orders exceed 2 days
$n = Yii::$app->db->createCommand()->update($tableName, ['status' => MOrder::STATUS_SYSTEM_CLOSED], 'status=:status AND create_time < DATE_SUB(NOW(), INTERVAL 2 day)', [':status' => MOrder::STATUS_SUBMITTED])->execute();
U::W("UPDATE {$tableName}, {$n} --- 系统自动关闭超时2天的提交订单。");
$n = Yii::$app->db->createCommand()->update($tableName, ['status' => MOrder::STATUS_SYSTEM_SUCCEEDED], 'status=:status AND create_time < DATE_SUB(NOW(), INTERVAL 2 day)', [':status' => MOrder::STATUS_FULFILLED])->execute();
U::W("UPDATE {$tableName}, {$n} --- 系统自动确认超时2天的已办理订单。");
//找到超时2天的成功订单， 将其归属的渠道 +积分100
$orders = MOrder::find()->where(['status' => MOrder::STATUS_FULFILLED])->andWhere(['<', 'create_time', 'DATE_SUB(NOW(), INTERVAL 2 day)'])->all();
foreach ($orders as $order) {
$user = MUser::findOne(['openid' => $order->openid]);
$office = MOffice::findOne(['office_id' => $user->belongto]);
if ($office->is_selfOperated == 0) {
//wx_office_score_event 增加一条记录
$offce_score_event = new MOfficeScoreEvent();
$offce_score_event->gh_id = $order->gh_id;
$offce_score_event->openid = $order->openid;
$offce_score_event->office_id = $user->belongto;
$offce_score_event->cat = MOfficeScoreEvent::CAT_ADD_ORDER;
$offce_score_event->create_time = date('y-m-d h:i:s', time());
$offce_score_event->score = MOfficeScoreEvent::CAT_ADD_ORDER_SCORE;
$offce_score_event->memo = '会员订单';
$offce_score_event->save(false);
//wx_office表中对应渠道score 加100分
$office->score = $office->score + 100;
$office->save(false);
}
}
/*
//move the unsuccessful orders exceed 90 days to bak table
$n = Yii::$app->db->createCommand("INSERT INTO {$tableName}_arc SELECT * FROM $tableName WHERE status!=:status AND create_time < DATE_SUB(NOW(), INTERVAL 90 day)", [':status'=>MOrder::STATUS_OK])->execute();
U::W("INSERT $tableName, $n");
$n = Yii::$app->db->createCommand("DELETE FROM $tableName WHERE status!=:status AND create_time < DATE_SUB(NOW(), INTERVAL 90 day)", [':status'=>MOrder::STATUS_OK])->execute();
U::W("DELETE $tableName, $n");
*/
//release mobile number
$tableName = MMobnum::tableName();
$n = Yii::$app->db->createCommand()->update($tableName, ['status' => MMobnum::STATUS_UNUSED, 'locktime' => 0], 'status=:status AND locktime < :locktime', [':status' => MMobnum::STATUS_LOCKED, ':locktime' => time() - 2 * 24 * 3600])->execute();
U::W("UPDATE {$tableName}, {$n}");
$n = Yii::$app->db->createCommand("DELETE FROM {$tableName} WHERE status=:status", [':status' => MMobnum::STATUS_USED])->execute();
U::W("DELETE {$tableName}, {$n}");
}
public function actionImportMobilenum()
{
/*
$pattern = "/(?:0(?=1)|1(?=2)|2(?=3)|3(?=4)|4(?=5)|5(?=6)|6(?=7)|7(?=8)|8(?=9)){5}\d/";
//$ret = preg_match($pattern, '123456789');
$ret = preg_match($pattern, 'a234567b6789');
if ($ret)
echo 'match';
else
echo 'no match';
*/
$num_cat = MMobnum::getNumCat(MItem::ITEM_CAT_MOBILE_IPHONE4S);
$file = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . 'mobile_num.txt';
$fh = fopen($file, "r");
$i = 0;
$sm_valid_cids = array();
while (!feof($fh)) {
$line = fgets($fh);
if (empty($line)) {
continue;
}
$mobnum = trim($line);
$ychf = 0;
$zdxf = 0;
$is_good = 1;
$tableName = MMobnum::tableName();
$n = Yii::$app->db->createCommand("REPLACE INTO {$tableName} (num, num_cat, ychf, zdxf, is_good) VALUES (:num, :num_cat, :ychf, :zdxf, :is_good)", [':num' => $mobnum, ':num_cat' => $num_cat, ':ychf' => $ychf, ':zdxf' => $zdxf, ':is_good' => $is_good])->execute();
$i++;
//if ($i > 2) break;
}
fclose($fh);
}
