public function actionProviderView($id)
{
$rec = ServiceUser::model()->with('servicePrices', 'serviceImages')->findByPk(array('id' => $id));
if (!empty($rec->servicePrices)) {
foreach ($rec->servicePrices as $viewProvider) {
$priceDetail[] = $viewProvider;
}
foreach ($priceDetail as $findServiceTypes) {
$serviceTypes[] = $findServiceTypes->service_type_id;
}
$unqService = array_unique($serviceTypes);
foreach ($unqService as $u) {
$service = ServiceTypes::model()->findAll(array('condition' => 'id=:id', 'params' => array(':id' => $u)));
foreach ($service as $Service) {
$AllService[] = $Service->service_name;
//echo "<pre>";print_r($res);
}
}
}
if (!empty($priceDetail) && !empty($AllService)) {
$this->render('providerview', array('companyDetail' => $rec, 'price' => $priceDetail, 'service' => $AllService));
} else {
$this->render('providerview', array('companyDetail' => $rec));
}
}
public function actionAddPrice()
{
$model = new PriceAdmin();
$res = ServiceTypes::model()->findAll();
$userS = ServiceUser::model()->findAll();
if (isset($_POST['PriceAdmin'])) {
$model->attributes = $_POST['PriceAdmin'];
//echo "<pre>";print_r($_REQUEST);die;
if ($model->validate()) {
//echo "<pre>";print_r($_REQUEST);die;
if (!empty($_REQUEST['PriceAdmin']['recid'])) {
$id = $_REQUEST['PriceAdmin']['recid'];
$findRec = PriceAdmin::model()->findByPk($id);
$findRec->id = $_REQUEST['PriceAdmin']['recid'];
$findRec->bedroom = $_REQUEST['PriceAdmin']['bedroom'];
$findRec->bathroom = $_REQUEST['PriceAdmin']['bathroom'];
$findRec->property = $_REQUEST['PriceAdmin']['property'];
$findRec->desk = $_REQUEST['PriceAdmin']['desk'];
$findRec->living_room = $_REQUEST['PriceAdmin']['living_room'];
$findRec->kitchen_staircases = $_REQUEST['PriceAdmin']['kitchen_staircases'];
$findRec->carpets_interior_windows = $_REQUEST['PriceAdmin']['carpets_interior_windows'];
$findRec->cupboards = $_REQUEST['PriceAdmin']['cupboards'];
$findRec->kitchen = $_REQUEST['PriceAdmin']['kitchen'];
$findRec->staircases = $_REQUEST['PriceAdmin']['staircases'];
$findRec->elevator = $_REQUEST['PriceAdmin']['elevator'];
$findRec->cleaning_material_price = $_REQUEST['PriceAdmin']['cleaning_material_price'];
$findRec->bedroom_hr = $_REQUEST['PriceAdmin']['bedroom_hr'];
$findRec->bathroom_hr = $_REQUEST['PriceAdmin']['bathroom_hr'];
$findRec->property_hr = $_REQUEST['PriceAdmin']['property_hr'];
$findRec->desk_hr = $_REQUEST['PriceAdmin']['desk_hr'];
$findRec->living_room_hr = $_REQUEST['PriceAdmin']['living_room_hr'];
$findRec->kitchen_staircases_hr = $_REQUEST['PriceAdmin']['kitchen_staircases_hr'];
$findRec->carpets_interior_windows_hr = $_REQUEST['PriceAdmin']['carpets_interior_windows_hr'];
$findRec->cupboards_hr = $_REQUEST['PriceAdmin']['cupboards_hr'];
$findRec->kitchen_hr = $_REQUEST['PriceAdmin']['kitchen_hr'];
$findRec->staircases_hr = $_REQUEST['PriceAdmin']['staircases_hr'];
$findRec->elevator_hr = $_REQUEST['PriceAdmin']['elevator_hr'];
$findRec->cleaning_material_price_hr = $_REQUEST['PriceAdmin']['cleaning_material_price_hr'];
if ($findRec->save(false)) {
$this->redirect(array('pricelisting'));
}
}
$date = date('Y-m-d');
$model->date = $date;
if ($model->save()) {
$this->redirect(array('pricelisting'));
}
} else {
$errors = $model->getErrors();
}
}
$this->render('addprice', array('model' => $model, 'serType' => $res, 'user' => $userS));
}
public function actionAddProvider()
{
$model = new ServiceUser();
$res = ServiceTypes::model()->findAll();
$userS = ServiceUser::model()->findAll();
if (isset($_POST['Company'])) {
//echo "<pre>";print_r($_POST);die;
$model->attributes = $_POST['ServiceUser'];
$model->password = md5($model->password);
if ($model->validate()) {
if ($model->save()) {
$this->redirect(array('providerdetails'));
}
} else {
$errors = $model->getErrors();
}
}
$this->render('addCompany', array('model' => $model));
}
public function actionAdditionalservicelisting($id)
{
//echo $id;die;
$servType = ServiceTypes::model()->findByPk(array('id' => $id));
$type = $servType['service_name'];
$listing = ServicetypeAdditionalservices::model()->findAll(array('condition' => 'service_type_id=:id', 'params' => array(':id' => $id)));
$this->render('additionalservicelisting', array('list' => $listing, 'type' => $type));
}
public function actionCleaning()
{
//echo "<pre>";print_r($_REQUEST);die;
$ses = Yii::app()->session['CleaningDetail'];
$serviceTypeId = $_REQUEST['typeId'];
//echo $serviceTypeId;die;
$cleaninServices = array($serviceTypeId, Yii::app()->session['requestfrmcleaning']);
// echo "<pre>";print_r($cleaninServices);die;
Yii::app()->session['ServiceTypeId'] = $serviceTypeId;
$serviceName = ServiceTypes::model()->findByPk($serviceTypeId);
$serName = strtoupper($serviceName->service_name);
$findValues = ServicePrice::model()->findAll(array("condition" => "service_type_id=" . $serviceTypeId));
//$additionalService=AdditionalServices::model()->findAll(array('condition'=>'status=1'));
/*code to get the additional services according to service types starts here*/
$additionalService = ServicetypeAdditionalservices::model()->findAll(array('condition' => 'service_type_id=:id AND status=:status', 'params' => array(':id' => $serviceTypeId, ':status' => 1)));
//echo "<pre>";print_r($additionalService);die;
/*code to get the additional services according to service types ends here*/
//echo "<pre>";print_r($additionalService);die;
$cleanDetails = Yii::app()->session['CleaningDetail'];
$links = CmsPages::model()->findAll();
Yii::app()->params['MyArray'] = $links;
$serviceDetails = ServiceTypes::model()->findAll(array("condition" => "id=" . $serviceTypeId));
$this->render('cleaning', array('serName' => $serName, 'serviceDetails' => $serviceDetails, 'values' => $findValues, 'adnlService' => $additionalService, 'cleaninServices' => $cleaninServices, 'cleanDetails' => $cleanDetails));
}
public function actionEdit()
{
$model = new CleaningTime();
$service = new ServiceTypes();
$list = CleaningTime::model()->findAll();
$zip = UkPostcodes::model()->findAll();
//echo "<pre>";print_r($zip);die;
foreach ($zip as $z) {
$post[] = $z->postcode;
}
$uniquePost = array_unique($post);
$record = CompanyRequest::model()->find(array('condition' => 'booking_id=:booking_id AND job_status=:job_status', 'params' => array(':booking_id' => $_REQUEST['id'], ':job_status' => 1)));
//echo "<pre>";print_r($rec->booking);die;
$ser = ServiceTypes::model()->findAll();
foreach ($ser as $se) {
$ids[] = $se['id'];
$serNam[] = $se['service_name'];
$serName = array_combine($ids, $serNam);
}
//echo "<pre>";print_r($serName);die;
if (isset($_POST['CleaningTime'])) {
//echo "<pre>";print_r($_REQUEST);die;
$id = $_REQUEST['book'];
$re = CompanyRequest::model()->find(array('condition' => 'booking_id=:booking_id ', 'params' => array(':booking_id' => $_REQUEST['book'])));
$re->postcode = $_REQUEST['CleaningTime']['PostCode'];
$re->cleaningtime = $_REQUEST['CleaningTime']['time'];
$re->cleaningdate = date('y-m-d', strtotime($_REQUEST['CleaningTime']['CleaningDate']));
$re->save(false);
$booking = Booking::model()->findByPk(array('id' => $id));
$service_type_id = $_REQUEST['ServiceTypes']['service_name'];
$booking->service_type_id = $service_type_id;
/*if(!empty($_REQUEST['Booking']))
{ */
if ($service_type_id == 3) {
foreach ($_REQUEST['Booking'] as $key => $value) {
//$r.=$value."-".$key.",";
$newAr[] = $value . "-" . $key;
}
$data = implode(',', $newAr);
//echo "<pre>";print_r($data);die;
$booking->cleaningDetail = $data;
} else {
foreach (array_slice($_REQUEST['Booking'], 0, 2) as $key => $value) {
//$r.=$value."-".$key.",";
$newAr[] = $value . "-" . $key;
}
$data = implode(',', $newAr);
//echo "<pre>";print_r($data);die;
$booking->cleaningDetail = $data;
}
//}
//echo "<pre>";print_r($r);die;
if (!empty($_REQUEST['Additional'])) {
//$booking->cleaningDetail=$r;
foreach ($_REQUEST['Additional'] as $key => $value) {
//echo "<pre>";print_r($value);
$res[] = $value . "-" . $key;
}
$data1 = implode(',', $res);
$booking->additional = $data1;
}
/*email to customer starts here*/
$subject = 'Welcome to Wow Cleans';
$body = $this->renderPartial('updatedquoteEmail', array('model' => $booking), true);
Yii::app()->mailer->send($booking->service['email'], $subject, $body);
/*email to customer ends here */
$booking->save(false);
$this->redirect(array('customerdashboard'));
}
$links = CmsPages::model()->findAll();
Yii::app()->params['MyArray'] = $links;
$this->render('edit', array('list' => $list, 'model' => $model, 'Post' => $uniquePost, 'rec' => $record, 'serName' => $serName, 'service' => $service));
}
public function actionAjaxServiceTypeStatusDeactivate()
{
$id = $_REQUEST['id'];
$rec = ServiceTypes::model()->findByPk($id);
$status = $rec->status;
if ($status == 1) {
$rec->status = 0;
$rec->save(false);
} else {
$rec->status = 1;
$rec->save();
}
}
public function serviceAvailable()
{
$a_service_available = array();
$service_available = ServiceTypes::leftJoin('allocate_services', 'allocate_services.service_type_id', '=', 'service_types.id')->select('service_types.id as service_id', 'service_types.name as service_name', 'allocate_services.*')->orderBy('service_name', 'ASC')->get();
$pet_types = PetTypes::orderBy('pet_name', 'ASC')->get();
foreach ($pet_types as $row) {
$a_service_name = array();
foreach ($service_available as $sub_row) {
$a_pet_id = explode(",", $sub_row->pet_type_ids);
if ($sub_row->pet_type_ids != '' && in_array($row->id, $a_pet_id)) {
$a_service_name[] = $sub_row->service_name;
}
}
$a_service_available[$row->pet_name] = $a_service_name;
}
//echo "<pre>"; print_r($a_service_available); die;
return View::make('service_available')->with('a_service_available', $a_service_available);
}
