public function actionIndex()
 {
     $post = $_POST;
     $plan_id = $post['plan'];
     $plan_data = GoodsPlan::model()->findByPk(intval($plan_id));
     $goods_data = Goods::model()->findByPk(intval($plan_data->goods_id));
     $realname = $post['realname'];
     $mobile = $post['mobile'];
     $order_num = $post['order_num'];
     $username = $post['username'];
     $uid = $post['uid'];
     $order_code = $this->get_order_code();
     $plan_price = $plan_data->plan_price;
     $plan_name = $plan_data->plan_name;
     $goods_id = $plan_data->goods_id;
     $total_price = intval($order_num) * $plan_price;
     $goods_name = $goods_data->goods_name;
     $default_thumb = $goods_data->default_thumb;
     $sales_endtime = $goods_data->sales_endtime;
     $is_login = Yii::app()->session['is_login'];
     $uid = Yii::app()->session['uid'];
     $username = Yii::app()->session['username'];
     if (!isset($is_login) && !isset($uid) && $is_login != 1) {
         $this->redirect($this->createUrl('user/login'));
     }
     $status = 1;
     //已下单未支付
     if (empty($plan_id) || empty($uid) || empty($username) || empty($mobile) || empty($order_num) || empty($total_price)) {
         throw new CHttpException(404, '请求非法!!');
     } else {
         $sql = "insert into orders(uid,order_code,username,goods_id,plan_id,order_num,plan_price,total_price,realname,mobile,goods_name,default_thumb,sales_endtime,plan_name,status) values({$uid},{$order_code},{$username},{$goods_id},{$plan_id},{$order_num},{$plan_price},{$total_price},'" . $realname . "',{$mobile},'" . $goods_name . "','" . $default_thumb . "','" . $sales_endtime . "','" . $plan_name . "',{$status})";
         $connection = Yii::app()->db;
         $command = $connection->createCommand($sql);
         $rowCount = $command->execute();
         if ($rowCount == 1) {
             $order_status = 1;
         } else {
             $order_status = 0;
         }
     }
     $this->_seoTitle = '订购成功';
     //发送订购短信
     $sendurl = "http://116.213.72.20/SMSHttpService/send.aspx?username=tongle&password=tongle123&mobile={$username}&content=【上海同乐旅行社】尊敬的客户{$realname} 您预定的产品订单已经生成 订单号:{$order_code};产品名称:{$goods_name};套餐名称:{$plan_name};购买数量:{$order_num};总价:{$total_price}; 请您及时付款,如有任何疑问欢迎拨打4009208581/021-63357992&Extcode=&senddate=&batchID=";
     //$sendurl =  "http://116.213.72.20/SMSHttpService/send.aspx?username=tongle&password=tongle123&mobile=$username&content=【上海同乐旅行社】您的注册验证码是1234,请在60秒内输入完成注册&Extcode=&senddate=&batchID=";
     @file_get_contents($sendurl);
     $this->render('index', array('order_status' => $order_status, 'order_code' => $order_code, 'goods_name' => $goods_name, 'plan_name' => $plan_name, 'plan_price' => $plan_price, 'order_num' => $order_num, 'total_price' => $total_price));
 }
 public function actionBuy($id)
 {
     $goods = Goods::model()->findByPk(intval($id));
     if (false == $goods) {
         throw new CHttpException(404, Yii::t('common', 'The requested page does not exist.'));
     }
     // seo信息
     $this->_seoTitle = $goods->goods_name;
     $goodsplan = GoodsPlan::model()->findAll('goods_id=:goods_id', array('goods_id' => $id));
     $criteria = new CDbCriteria();
     $criteria->select = '*';
     // only select the 'title' column
     $criteria->condition = 'goods_id=:goods_id';
     $criteria->params = array(':goods_id' => $id);
     $criteria->order = 'plan_price asc';
     $goodsplan = GoodsPlan::model()->findAll($criteria);
     // $params is not needed
     //print_r($goodsplan);
     $this->render('buy', array('goods' => $goods, 'goodsplan' => $goodsplan, 'uid' => $uid, 'username' => $username));
 }
 /**
  * 批量操作
  *
  */
 public function actionBatch()
 {
     if ($this->method() == 'GET') {
         $command = trim($_GET['command']);
         $ids = intval($_GET['id']);
     } elseif ($this->method() == 'POST') {
         $command = trim($_POST['command']);
         $ids = $_POST['id'];
     } else {
         $this->message('errorBack', Yii::t('admin', 'Only POST Or GET'));
     }
     empty($ids) && $this->message('error', Yii::t('admin', 'No Select'));
     switch ($command) {
         case 'delete':
             //删除商品
             foreach ((array) $ids as $id) {
                 $goodsModel = GoodsPlan::model()->findByPk($id);
                 if ($goodsModel) {
                     $goodsModel->delete();
                 }
             }
             break;
         case 'show':
             //商品显示
             foreach ((array) $ids as $id) {
                 $goodsModel = GoodsPlan::model()->findByPk($id);
                 if ($goodsModel) {
                     $goodsModel->status = 'Y';
                     $goodsModel->save();
                 }
             }
             break;
         case 'hidden':
             //商品隐藏
             foreach ((array) $ids as $id) {
                 $goodsModel = GoodsPlan::model()->findByPk($id);
                 if ($goodsModel) {
                     $goodsModel->status = 'N';
                     $goodsModel->save();
                 }
             }
             break;
         case 'commend':
             //商品推荐
             foreach ((array) $ids as $id) {
                 $recom_id = intval($_POST['recom_id']);
                 if ($recom_id) {
                     $goodsModel = GoodsPlan::model()->findByPk($id);
                     if ($goodsModel) {
                         $goodsModel->recommend = 'Y';
                         $goodsModel->save();
                     }
                 } else {
                     $this->message('error', Yii::t('admin', 'RecommendPosition is Required'));
                 }
             }
             break;
         case 'unCommend':
             //商品取消推荐
             foreach ((array) $ids as $id) {
                 $goodsModel = GoodsPlan::model()->findByPk($id);
                 if ($goodsModel) {
                     $goodsModel->commend = 'N';
                     $goodsModel->save();
                 }
             }
             break;
         default:
             throw new CHttpException(404, Yii::t('admin', 'Error Operation'));
             break;
     }
     $this->message('success', Yii::t('admin', 'Batch Operate Success'));
 }