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