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; } }