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