protected function calenderIns($cal_id) { $tempArr = array(); $orders = Order::model()->findAll(array('select'=>'id,name,daynumber,aduit,child','condition'=>"cal_id=$cal_id and status=1")); if($orders){ foreach($orders as $order){ $insModel = OrderInsurance::model()->find(array('condition'=>"oid=$order->id")); if($insModel){ $orderinsPrice = ($order->aduit + $order->child) * $order->daynumber * $insModel->price; $tempArr[] = array($insModel->id,$insModel->oid,$order->name,$insModel->name,$insModel->price,($order->aduit + $order->child),$order->daynumber,$orderinsPrice); } } } return $tempArr; }
private function getNowInsurance($id) { $model = OrderInsurance::model()->find(array('select'=>'name','condition'=>"id=$id")); if($model != null){ return $model->name; }else{ return '没有任何投保'; } }
public function actionInsuranceList() { $cal_id = intval($_GET['cid']); $arr = $this->orderStatistics($cal_id); $OModel = new Order; $criteria=new CDbCriteria; $criteria->select = 'id,name,daynumber,aduit,child'; $criteria->condition = "cal_id=$cal_id and status=1"; $count=$OModel->count($criteria); $pages=new CPagination($count); $pages->pageSize=5; $pages->applyLimit($criteria); $orders = $OModel->findAll($criteria); $tempArr = array(); if($orders){ foreach($orders as $order){ $insModel = OrderInsurance::model()->find(array('condition'=>"oid=$order->id")); if($insModel){ $orderinsPrice = ($order->aduit + $order->child) * $order->daynumber * $insModel->price; $tempArr[] = array($insModel->id,$insModel->oid,$order->name,$insModel->name,$insModel->price,($order->aduit + $order->child),$order->daynumber,$orderinsPrice); } } } $this->render('insuraceList',array( 'cal_id'=>$cal_id, 'arr'=>$arr, 'tempArr'=>$tempArr, 'pages'=>$pages, )); }
protected function orderTotalPirce($oid) { $orderModel = Order::model()->find(array('condition'=>"id=$oid")); $insuranceModel = OrderInsurance::model()->find(array( 'select'=>'price', 'condition'=>"oid=$oid" )); //参团人基础价格 + 房间总价 + 附加项(门票总价) + 保险 + 捐赠 $basePrice = ($orderModel->aduit * $orderModel->aduit_price) + ($orderModel->child * $orderModel->chilend_price); $insurancePrice = 0; if($insuranceModel!=null){ $insurancePrice = ($insuranceModel->price) * ($orderModel->aduit + $orderModel->child); } $totalPrice = $basePrice + $this->roomsTotalPrice($oid) + $this->addsTotalPrice($oid) + $insurancePrice + $orderModel->donate; return $totalPrice; }
public function getTotalPriceFormDb($oid) { // 参团人基础价格 + 房间价格 + 附加项目(门票) + 保险 + 捐赠 //基础价格 $orderModel = Order::model()->findByPk($oid); $basePrice = 0; //保险价格 $insruancePrice = 0; //捐赠价格 $donatePrice = 0; //附加项目总价 $addsPrice = 0; //房间价格 $roomPrice = 0; if($orderModel!==null){ $basePrice = ($orderModel->aduit * $orderModel->aduit_price) + ($orderModel->child * $orderModel->chilend_price); //捐赠价格 $donatePrice = $orderModel->donate; //保险价格 $insruanceModel = OrderInsurance::model()->find(array('select'=>'price','condition'=>"oid=$oid")); if($insruanceModel!==null){ $insruancePrice = ($orderModel->aduit + $orderModel->child) * $insruanceModel->price * $orderModel->daynumber; } //房间价格 $roomModel = OrderRoom::model()->findAll(array('select'=>'price','condition'=>"oid=$oid")); if(!empty($roomModel)){ foreach($roomModel as $m){ $roomPrice += $m->price; } } //附加项目总价 $addsModel = OrderAdditional::model()->findAll(array('select'=>'num,price','condition'=>"oid=$oid")); foreach($addsModel as $adds){ $addsPrice += $adds->num * $adds->price; } } return $basePrice + $insruancePrice + $donatePrice + $addsPrice + $roomPrice; }