public function actionOverdueProducts()
{
//取所有上架商品
$c = new CDbCriteria();
$c->select = 'product_id';
$c->addCondition('status = 3');
$products = HtProduct::model()->findAll($c);
$products = Converter::convertModelToArray($products);
$need_sendmail_products = array();
//取价格计划即将到期或已经过期的商品
if (is_array($products) && count($products) > 0) {
foreach ($products as $product) {
$plans = HtProductPricePlan::model()->findAll('product_id=' . $product['product_id']);
$plans = Converter::convertModelToArray($plans);
if (is_array($plans) && count($plans) > 0) {
if ($plans[0]['valid_region'] == 0) {
//整个区间
$date_rule = HtProductDateRule::model()->findByPk($product['product_id']);
if ($date_rule) {
$to_date = strtotime($date_rule['to_date']);
$today = strtotime(date('Y-m-d', time()));
if (($to_date - $today) / 86400 <= 15) {
$need_sendmail_products[$product['product_id']] = $date_rule['to_date'];
}
}
} else {
$to_dates = array();
foreach ($plans as $plan) {
$to_dates[] = $plan['to_date'];
}
array_multisort($to_dates, SORT_DESC, $plans);
$to_date = strtotime($plans[0]['to_date']);
$today = strtotime(date('Y-m-d', time()));
if (($to_date - $today) / 86400 <= 15) {
$need_sendmail_products[$product['product_id']] = $plans[0]['to_date'];
}
}
}
}
}
//发送邮件给供应商负责人
if (count($need_sendmail_products) > 0) {
$mail_list = array();
foreach ($need_sendmail_products as $n => $m) {
$product_manager = HtProductManager::model()->find('product_id = ' . $n);
if ($product_manager['manager_name']) {
$mail_list[$product_manager['manager_name']][] = "产品ID:{$n},售卖截止时间为{$m},点击<a href='http://backend.hitour.cc/admin/product/edit?product_id=" . $n . "#/editProductPrice'>编辑</a>产品价格体系";
}
}
if (count($mail_list) > 0) {
foreach ($mail_list as $k => $v) {
Mail::sendToOP($k, '售卖即将过期或已过期商品', implode('<br>', $v), 1, '');
}
}
}
}
private function productExist($product_id)
{
$product = HtProduct::model()->findByPk($product_id);
if (!empty($product)) {
return true;
} else {
return false;
}
}
