public function actionChnagequotesDashboardSpeciUser() { //$id =$_REQUEST['id']; $admin = new ParticularPrice(); $adnl = new AdditionalParticularPrice(); $price = new ParticularPrice(); $loggedId = Yii::app()->session['loggedId']; $providerId = CompanyRequest::model()->findByPk(array('id' => $id)); $bookId = $providerId['booking_id']; $bookingrec = Booking::model()->findByPk(array('id' => $bookId)); //echo "<pre>";print_r($bookingrec);die; $servicetype = $bookingrec['service_type_id']; $provId = $bookingrec['service_id']; // echo $bookingId;die; $priceAdmin = PriceAdmin::model()->find(array('condition' => 'service_id=:service_id AND service_type_id=:service_type_id', 'params' => array(':service_id' => $provId, ':service_type_id' => $servicetype))); $addPriceDetl = AdditionalServicePrice::model()->findAll(array('condition' => 'service_id=:service_id', 'params' => array(':service_id' => $provId))); $particularRec = ParticularPrice::model()->find(array('condition' => 'booking_id=:booking_id', 'params' => array(':booking_id' => $_REQUEST['booking_id']))); /*code to save the particular quote*/ if (isset($_REQUEST['ParticularPrice'])) { $partiRecord = ParticularPrice::model()->find(array('condition' => 'booking_id=:booking_id', 'params' => array(':booking_id' => $_REQUEST['booking_id']))); if (!empty($partiRecord)) { //echo "<pre>";print_r($_REQUEST);die; $priceParticular = ParticularPrice::model()->find(array('condition' => 'booking_id=:booking_id', 'params' => array(':booking_id' => $_REQUEST['booking_id']))); foreach ($_REQUEST['ParticularPrice'] as $k => $p) { if ($k == "bedroom") { $modifiedKey = "Bedrooms"; } else { if ($k == "bathroom") { $modifiedKey = "Bathrooms"; } else { if ($k == "property") { $modifiedKey = "Property"; } else { if ($k == "desk") { $modifiedKey = "Desk"; } } } } $firstArrayVal = $_REQUEST['noBedBathDesk'][$modifiedKey]; $newAr[] = $firstArrayVal * $p; $priceParticular->{$k} = $p; // $k++; } $result = array_sum($newAr); $priceParticular->particular_price = $result; $priceParticular->save(false); /*chnage the details for additional particular prices*/ $additionalPartiPrice = AdditionalParticularPrice::model()->findAll(array('condition' => 'booking_id=:booking_id', 'params' => array(':booking_id' => $_REQUEST['booking_id']))); //foreach($additionalPartiPrice) //echo "<pre>";print_r($additionalPartiPrice);die; if (!empty($_REQUEST['AdditionalParticularPrice'])) { //echo "<pre>";print_r($_REQUEST);die; /* foreach($additionalPartiPrice as $key=>$edit) { //echo "<pre>";print_r($edit); foreach($_REQUEST['AdditionalParticularPrice'] as $k=>$adnlprice) { //echo "<pre>";print_r($adnlprice); if($edit['additional_service_id']==$k) { $edit->price =$adnlprice; } // $sum = 0; foreach($_REQUEST['adnl'] as $tot) { $arr[] =$tot*$adnlprice; $res =array_sum($arr); } $edit->total_price=$res+$result; $edit->save(false); $res=array(); $arr=array(); } } */ foreach ($additionalPartiPrice as $key => $edit) { foreach ($_REQUEST['AdditionalParticularPrice'] as $k => $adnlprice) { $edit->price = $adnlprice; $total = array(); foreach ($_REQUEST['AdditionalParticularPrice'] as $key => $adnlpr) { $total[] = $adnlpr * $_REQUEST['adnl'][$key]; //echo "<pre>";print_r($total); } //die; $sum1 = array_sum($total); $edit->total_price = $sum1 + $result; $edit->save(false); } } } /* mail to customer*/ $subject = 'Welcome to Wow Cleans'; $body = $this->renderPartial('chnagequoteparticularCustomerEmail', array('model' => $partiRecord), true); Yii::app()->mailer->send($partiRecord->customer['email'], $subject, $body); /*mail to company */ $subject = 'Welcome to Wow Cleans'; $body = $this->renderPartial('chnagequoteparticularCustomerEmail', array('model' => $partiRecord), true); Yii::app()->mailer->send($partiRecord->customer['email'], $subject, $body); $this->redirect(array('dashboard')); } else { $price->customer_id = $_REQUEST['customer_id']; $price->service_id = $loggedId; $price->booking_id = $_REQUEST['booking_id']; $price->date = date('Y-m-d'); //$k=0; foreach ($_REQUEST['ParticularPrice'] as $k => $p) { if ($k == "bedroom") { $modifiedKey = "Bedrooms"; } else { if ($k == "bathroom") { $modifiedKey = "Bathrooms"; } else { if ($k == "property") { $modifiedKey = "Property"; } else { if ($k == "desk") { $modifiedKey = "Desk"; } } } } $firstArrayVal = $_REQUEST['noBedBathDesk'][$modifiedKey]; $newAr[] = $firstArrayVal * $p; $price->{$k} = $p; // $k++; } $result = array_sum($newAr); $price->particular_price = $result; $price->save(false); if (!empty($_REQUEST['AdditionalParticularPrice'])) { /* foreach($_REQUEST['AdditionalParticularPrice'] as $k=>$adnlprice) { $adnl =new AdditionalParticularPrice; $adnl->service_id =$loggedId; $adnl->customer_id =$_REQUEST['customer_id']; $adnl->booking_id =$_REQUEST['booking_id']; $adnl->date =date('Y-m-d'); $adnl->additional_service_id=$k; $adnl->price =$adnlprice; // $sum = 0; foreach($_REQUEST['adnl'] as $tot) { $arr[] =$tot*$adnlprice; $res =array_sum($arr); } $adnl->total_price=$res+$result; $adnl->save(false); $res=array(); $arr=array(); } */ //$total = array(); foreach ($_REQUEST['AdditionalParticularPrice'] as $k => $adnlprice) { $adnl = new AdditionalParticularPrice(); $adnl->service_id = $loggedId; $adnl->customer_id = $_REQUEST['customer_id']; $adnl->booking_id = $_REQUEST['booking_id']; $adnl->date = date('Y-m-d'); $adnl->additional_service_id = $k; $adnl->price = $adnlprice; $total = array(); foreach ($_REQUEST['AdditionalParticularPrice'] as $key => $adnlpr) { $total[] = $adnlpr * $_REQUEST['adnl'][$key]; //echo "<pre>";print_r($total); } //die; $sum1 = array_sum($total); $adnl->total_price = $sum1 + $result; $adnl->save(false); } //die; } //die("fsdfsd"); /* mail to customer*/ $subject = 'Welcome to Wow Cleans'; $body = $this->renderPartial('chnagequoteparticularCustomerEmail', array('model' => $particularRec), true); Yii::app()->mailer->send($partiRecord->customer['email'], $subject, $body); /*mail to company */ $subject = 'Welcome to Wow Cleans'; $body = $this->renderPartial('chnagequoteparticularCustomerEmail', array('model' => $particularRec), true); Yii::app()->mailer->send($partiRecord->customer['email'], $subject, $body); $this->redirect(array('dashboard')); } //$price // echo "<pre>";print_r($_REQUEST);die; } $links = CmsPages::model()->findAll(); Yii::app()->params['MyArray'] = $links; $this->render('chnagequotesDashboardSpeciUser', array('bookingrec' => $bookingrec, 'priceAdmin' => $priceAdmin, 'admin' => $admin, 'addPriceDetl' => $addPriceDetl, 'adnl' => $adnl, 'particularRec' => $particularRec)); }