public function actionAddPrice() { ob_start(); Yii::app()->theme = 'back'; $model = new ServicePrice(); $attr = new NewAttribute(); $resAttr = ServiceUser::model()->with('newAttributes')->findAll(); // echo "<pre>";print_r($resAttr);die; //echo "<pre>";print_r($_REQUEST);die; // to get the new added columns //echo "<pre>";print_r();die; /*$columns=Yii::app()->db->schema->getTable('ccobs_service_price')->columns; $c=count($columns); if($c>10) { foreach(array_slice($columns,10) as $c) { //echo "<pre>";print_r($c); $arrCol[]=$c->name; } }//die;*/ //echo "<pre>";print_r($arrCol);die; // to get the new added columns ends here //echo "<pre>";print_r($arr);die; $res = ServiceTypes::model()->findAll(); $userS = ServiceUser::model()->findAll(); // echo "<pre>";print_r($_REQUEST);die; if (isset($_POST['ServicePrice'])) { //echo "mkd"."<pre>";print_r($_POST['ServicePrice']);die; $model->attributes = $_POST['ServicePrice']; if ($model->validate()) { //echo "<pre>";print_r($Id);die; //echo "<pre>";print_r($_REQUEST);die; //$service_type=$_REQUEST['ServicePrice']['service_type_id']; $service_type = $_REQUEST['ServicePrice']['service_type_id']; //$companyId=$_REQUEST['ServicePrice']['service_id']; $beds = $_REQUEST['ServicePrice']['no_of_beds']; $baths = $_REQUEST['ServicePrice']['no_of_baths']; $property = $_REQUEST['ServicePrice']['property_size']; if ($service_type == '3') { $area = $_REQUEST['ServicePrice']['area']; $desk = $_REQUEST['ServicePrice']['no_of_desk']; } $money = $_REQUEST['ServicePrice']['price']; $date = date('Y-m-d'); //to add price for a particular service provided by company $model->service_type_id = $service_type; $model->service_id = $companyId; $model->no_of_beds = $beds; $model->no_of_baths = $baths; $model->property_size = $property; if ($service_type == '3') { $model->area = $area; $model->no_of_desk = $desk; } // $model->price=$money; $model->date = $date; // echo "fsfs";die; if ($model->save(false)) { //echo "dfsf";die; $PricelastId = Yii::app()->db->getLastInsertId(); //$Attrid=$_REQUEST['newAttrTableId']; if (isset($_REQUEST['newAttrTableId'])) { $Attrid = $_REQUEST['newAttrTableId']; $AdditionalValues = $_REQUEST['AdditionalValues']; //echo "<pre>";print_r($AdditionalValues);die; $res = array_combine($Attrid, $AdditionalValues); $date = date('Y-m-d'); foreach ($res as $i => $values) { $command = Yii::app()->db->createCommand(); $command->insert('ccobs_additional_attr', array('priceTableId' => $PricelastId, 'newAttrId' => $i, 'additionalFieldName' => $values, 'date' => $date)); } } $this->redirect('pricelisting'); } } else { $errors = $model->getErrors(); //var_dump($errors); } } if (isset($arrCol)) { $this->render('addserviceprice', array('model' => $model, 'serType' => $res, 'user' => $userS, 'resAttr' => $resAttr, 'arrCol' => $arrCol)); } else { $this->render('addserviceprice', array('model' => $model, 'serType' => $res, 'user' => $userS, 'resAttr' => $resAttr)); //$this->render('addserviceprice',array('model'=>$model,'serType'=>$res,'user'=>$userS)); } }