public function actionGetCurrentQuestion() { $customer_id = $this->getParam('customer_id'); $flag = $this->getParam('flag'); $current_id = array(); if ($flag == 'today') { $current_id = 2; } else { $current_id = 1; } $question = Converter::convertModelToArray(HiQuestion::model()->findByPk($current_id)); $answers = Converter::convertModelToArray(HiQuestionAnswer::model()->with('customer')->findAllByAttributes(array('customer_id' => $customer_id, 'question_id' => $current_id))); if ($flag == 'today') { $question['has_answered'] = 0; $year = date('Y'); foreach ($answers as $k => $v) { if (strpos('date' . $v['insert_date'], $year)) { $question['has_answered'] = 1; } } } else { $question['has_answered'] = 1; } $question['answers'] = $answers; EchoUtility::echoMsgTF($question, '获取问题', $question); }
public function actionGetArticleById() { $article_id = $this->getParam('article_id'); $customer_id = $this->getParam('customer_id'); $article = Converter::convertModelToArray(HiPushArticle::model()->with('sections')->findByPk($article_id)); $c = new CDbCriteria(); $c->addCondition("article_ids LIKE '%\"" . (int) $article_id . "\"%' and customer_id = " . $customer_id); $article['is_favourite'] = HiPushArticleFavourite::model()->count($c); EchoUtility::echoMsgTF(1, '获取文章', $article); }
public function actionGetHomeData() { $result = array(); $story_c = new CDbCriteria(); $story_c->addCondition('follow_count != 0'); $story_c->order = 'follow_count DESC'; $stories = Converter::convertModelToArray(HiStory::model()->with('customer')->findAll($story_c)); $result['story'] = $stories[0]; $article = Converter::convertModelToArray(HiPushArticle::model()->findByPk(Yii::app()->time_service->getIndex())); $result['article'] = $article; $question = Converter::convertModelToArray(HiQuestion::model()->findByPk(2)); $question['cover_image'] = 'http://77fkpo.com5.z0.glb.clouddn.com/603b2cffffeb7c5c950a4c9517e8ee9e.jpg'; $result['question'] = $question; $book = Converter::convertModelToArray(HiBook::model()->with('customer')->findByPk(1)); $result['book'] = $book; EchoUtility::echoMsgTF(true, '获取首页数据', $result); }
public function actionAddComment() { $section_id = $this->getParam('section_id'); $story_id = $this->getParam('story_id'); $customer_id = $this->getParam('customer_id'); $content = $this->getParam('content'); $orig_customer_id = $this->getParam('orig_customer_id'); $newComment = new HiStoryComment(); $newComment['customer_id'] = $customer_id; if (isset($section_id)) { $newComment['section_id'] = $section_id; } if (isset($story_id)) { $newComment['story_id'] = $story_id; } $newComment['orig_customer_id'] = $orig_customer_id; $newComment['content'] = $content; $newComment['insert_time'] = date('Y-m-d H:i:s', time()); $newComment->insert(); $comment = Converter::convertModelToArray(HiStoryComment::model()->with('customer')->findByPk($newComment->getPrimaryKey())); EchoUtility::echoMsgTF(1, '插入评论', $comment); }
public function actionGetBookDetail() { $book_id = $this->getParam('book_id'); $book = Converter::convertModelToArray(HiBook::model()->with('customer')->findByPk($book_id)); EchoUtility::echoMsgTF(1, '获取书籍', $book); }
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, ''); } } } }
public function actionGetMyComment() { $orig_customer_id = $this->getParam("customer_id"); $c = new CDbCriteria(); $c->addCondition('sc.orig_customer_id = ' . $orig_customer_id); $c->group = 'sc.story_id'; $comments = Converter::convertModelToArray(HiStoryComment::model()->with('story', 'customer')->findAll($c)); EchoUtility::echoMsgTF(true, '获取评论', $comments); }
public function actionGetOrderOut($order_id, $method = '') { $sql = 'SELECT * FROM ht_order WHERE order_id="' . $order_id . '"'; $order = Yii::app()->db->createCommand($sql)->queryRow(); if (empty($order)) { echo "Not found order[" . $order_id . "]\n\n"; } else { $order_product = HtOrderProduct::model()->with('product.description')->findByAttributes(array('order_id' => $order_id)); $order_product = Converter::convertModelToArray($order_product); $order['product_id'] = $order_product['product_id']; $order['supplier_id'] = $order_product['product']['supplier_id']; $out_order_id = PayUtility::genOutTradeNo($order, $order['payment_method']); echo 'Order[' . $order_id . '] out_order_id is [' . $out_order_id . ']' . "\n\n"; } }
public function actionGetStoryList() { $start = $this->getParam('start'); $num = $this->getParam('num'); $c = new CDbCriteria(); $c->offset = $start; $c->limit = $num; $stories = Converter::convertModelToArray(HiStory::model()->with('customer')->findAll($c)); $result = array(); if (count($stories) < $num) { $result['has_more'] = false; } else { $result['has_more'] = true; } $result['story_list'] = $stories; $result['success'] = true; EchoUtility::echoMsgTF(1, '获取段子列表', $result); }