public function actionAjaxAdditionalDeactivate() { $id = $_REQUEST['id']; $rec = AdditionalServices::model()->findByPk($id); if ($rec->status == 1) { $rec->status = 0; $rec->save(); } else { $rec->status = 1; $rec->save(); } }
public function actionCustomerDashboard() { $model = new CustomerUser(); $msg = new ConversationMsg(); $msgDetail = new MsgDetails(); $email = $_SESSION['_registration__id']; $loggedId = Yii::app()->session['loggedId']; //echo $loggedId;die; //$rec=CustomerUser::model()->with('bookings')->findByAttributes(array('email'=>$email)); $review = ServiceReview::model()->findAll(array('condition' => 'status=:status', 'params' => array(':status' => 1))); foreach ($review as $bookingIds) { $bookIds[] = $bookingIds['booking_id']; //$status[] =$bookingIds['status']; } //echo "<pre>";print_r($bookIds);die; $rec = CustomerUser::model()->with('bookings')->findByAttributes(array('id' => $loggedId)); //echo "<pre>";print_r($rec);die; $bookings = Booking::model()->with('customer')->findAll(array('condition' => 'customer_id=:customer_id', 'params' => array(':customer_id' => $loggedId))); //echo "<pre>";print_r(count($rec));die; /*code to pagination*/ /* $criteria=new CDbCriteria(); $count=count($bookings); $pages=new CPagination($count); $pages->pageSize=4; $pages->applyLimit($criteria); $result = Booking::model()->findAll($criteria); echo "<pre>";print_r($result);die; $dataProvider = new CArrayDataProvider($result); */ $criteria = new CDbCriteria(); $criteria->condition = 'customer_id = :id'; //$criteria->with ='customer'; $criteria->params = array(':id' => $loggedId); //$criteria->order = 'ac_name asc'; //get count $count = Booking::model()->count($criteria); //pagination $pages = new CPagination($count); $pages->setPageSize(5); $pages->applyLimit($criteria); //result to show on page $dataProvider = Booking::model()->findAll($criteria); //echo "<pre>";print_r($result);die; //$dataProvider = new CArrayDataProvider($result); // echo "<pre>";print_r($dataProvider);die; // echo "<pre>";print_r($pages);die; foreach ($rec['bookings'] as $to) { $serviceId[] = $to['service_id']; $companyNam[] = $to->service['company_name']; } $finalTo = array_combine($serviceId, $companyNam); $convMsg = ConversationMsg::model()->findAll(array('condition' => ' reciver_id=:id', 'params' => array(':id' => $loggedId))); /*$inbox=MsgDetails::model()->findAll(array('condition'=>'to=:to','params'=>array( ':to'=>$loggedId )));*/ $inbox = MsgDetails::model()->findAll(array('condition' => 'tomsg=:tomsg AND inbox_dlt_status=:status', 'group' => 'conversation_id', 'params' => array(':tomsg' => $loggedId, ':status' => 0))); //$convID =$inbox[0]['conversation_id']; //echo "<pre>";print_r($inbox);die; foreach ($inbox as $conId) { //echo $conId->conversation_id; $inboxDtal[] = MsgDetails::model()->findAll(array('condition' => 'conversation_id=:conversation_id AND inbox_dlt_status=:status', 'params' => array(':conversation_id' => $conId->conversation_id, ':status' => 0))); $companyName = ServiceUser::model()->findAll(array('condition' => 'id=:id', 'params' => array(':id' => $conId->user_id))); // echo "<pre>";print_r($companyName); } //die; /*code to get the sent messages list*/ $sentMsg = ConversationMsg::model()->findAll(array('condition' => 'sender_id=:sender_id', 'params' => array(':sender_id' => $loggedId))); $sentBox = MsgDetails::model()->findAll(array('condition' => 'user_id=:user_id AND sent_dlt_status=:status', 'group' => 'conversation_id', 'params' => array(':user_id' => $loggedId, ':status' => 0))); //echo "<pre>";print_r($sentBox);die; foreach ($sentBox as $conId) { $sentBoxDtl[] = MsgDetails::model()->findAll(array('condition' => 'conversation_id=:conversation_id AND user_id=:user_id AND sent_dlt_status=:status', 'params' => array(':user_id' => $loggedId, ':conversation_id' => $conId->conversation_id, ':status' => 0))); $companyName = ServiceUser::model()->findAll(array('condition' => 'id=:id', 'params' => array(':id' => $conId->tomsg))); //echo "<pre>";print_r($companyName); } //die; //echo "<pre>";print_r($sentBox);die; foreach ($sentMsg as $sender_id) { $custName = $sender_id->sender_id; /* $sentTo=ServiceUser::model()->findAll(array('condition'=>'id=:id','params'=>array( ':id'=>$sender_id->reciver_id, )));*/ $sentFrm = CustomerUser::model()->findAll(array('condition' => 'id=:id', 'params' => array(':id' => $sender_id->sender_id))); //echo "<pre>";print_r($sentTo); } //die; //echo "<pre>";print_r($sentMsg);die; $Request = CompanyRequest::model()->findAll(array('condition' => 'job_status=:job_status', 'params' => array(':job_status' => 1))); foreach ($Request as $arrReq) { $request[] = $arrReq['booking_id']; //echo "<pre>";print_r($request); } /*code to edit the job quotes starts here*/ $mod = 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); } $additionalSer = AdditionalServices::model()->findAll(); foreach ($additionalSer as $ser) { $addnlSer[] = $ser['service_name']; } //echo "<pre>";print_r($addnlSer);die; /*code to edit the job quotes ends here*/ /*code to get the new pending requests for company*/ $companyRequest = CompanyRequest::model()->findAll(array('order' => 'id desc', 'condition' => 'customer_id=:customer_id AND job_status=:job_status', 'params' => array(':customer_id' => $loggedId, ':job_status' => 0))); $Request = CompanyRequest::model()->findAll(array('condition' => 'customer_id=:customer_id AND job_status=:job_status', 'params' => array(':customer_id' => $loggedId, ':job_status' => 1))); foreach ($Request as $arrReq) { $req[] = $arrReq['booking_id']; //echo "<pre>";print_r($request); } $links = CmsPages::model()->findAll(); Yii::app()->params['MyArray'] = $links; $this->render('customerdashboard', array('model' => $model, 'bookingDetails' => $rec, 'bookIds' => $bookIds, 'review' => $review, 'msg' => $msg, 'msgDetail' => $msgDetail, 'finalTo' => $finalTo, 'convMsg' => $convMsg, 'companyName' => $companyName, 'c' => $num, 'sent' => $sentMsg, 'Frm' => $sentFrm, 'inbox' => $inbox, 'inboxDtal' => $inboxDtal, 'sentBox' => $sentBox, 'sentBoxDtl' => $sentBoxDtl, 'pages' => $pages, 'dataProvider' => $dataProvider, 'request' => $request, 'list' => $list, 'mod' => $mod, 'Post' => $uniquePost, 'rec' => $record, 'serName' => $serName, 'service' => $service, 'addnlSer' => $addnlSer, 'companyRequest' => $companyRequest, 'req' => $req)); }
public function actionProviderEdit($id) { $model = new ServiceUser(); $detail = ServiceUser::model()->with('additionalServicePrices')->findByPk(array('id' => $id)); // echo "<pre>";print_r($detail);die; $additionalService = AdditionalServices::model()->findAll(); //echo "<pre>";print_r($additionalService);die; /*foreach($detail->priceAdmins as $i=>$d) { echo "<pre>";print_r($d); } die;*/ if (isset($_POST['ServiceUser'])) { //echo "<pre>";print_r($_REQUEST);die; $model->attributes = $_POST['ServiceUser']; $rnd = rand(0, 9999); $uploadedFile = CUploadedFile::getInstance($model, 'company_logo'); $fileName = "{$rnd}-{$uploadedFile}"; // random number + file name //echo "<pre>";print_r($_FILES);die; if ($model->validate()) { $rec = ServiceUser::model()->with('additionalServicePrices')->findByPk(array('id' => $id)); //echo "<pre>";print_r($_REQUEST);die; $cname = $_REQUEST['ServiceUser']['company_name']; $city = $_REQUEST['ServiceUser']['city']; $zip = $_REQUEST['ServiceUser']['zipcode']; $rec->company_name = $cname; $rec->city = $city; $rec->zipcode = $zip; if (is_uploaded_file($_FILES['ServiceUser']['tmp_name']['company_logo'])) { $rec->company_logo = $fileName; } /*code to save the details for price in db starts here*/ foreach ($rec->priceAdmins as $editPrice) { //echo "<pre>";print_r($editPrice); $editPrice->bedroom = $_REQUEST['PriceAdmin'][$editPrice->service_type_id][0]; $editPrice->bathroom = $_REQUEST['PriceAdmin'][$editPrice->service_type_id][1]; if (!empty($_REQUEST['PriceAdmin'][$editPrice->service_type_id][2]) || !empty($_REQUEST['PriceAdmin'][$editPrice->service_type_id][3])) { $editPrice->property = $_REQUEST['PriceAdmin'][$editPrice->service_type_id][2]; $editPrice->desk = $_REQUEST['PriceAdmin'][$editPrice->service_type_id][3]; } $editPrice->save(); } //die; if (empty($rec->additionalServicePrices)) { foreach ($additionalService as $i => $price) { $mod = new AdditionalServicePrice(); $date = date('Y-m-d'); $mod->date = $date; $mod->additional_service_id = $price->id; $mod->price = $_REQUEST['PriceAditional'][$price->service_name]; $mod->service_id = $id; $mod->save(false); } } //die; foreach ($rec->additionalServicePrices as $editPrice) { //echo "<pre>";print_r($editPrice); $serName = $editPrice->additionalService['service_name']; $editPrice->price = $_REQUEST['PriceAditional'][$serName]; $editPrice->save(); } //die; /*code to save the details for price in db ends here*/ if ($rec->save()) { if (is_uploaded_file($_FILES['ServiceUser']['tmp_name']['company_logo'])) { $uploadedFile->saveAs(Yii::app()->basePath . '/../CompanyLogo/' . $fileName); } $this->redirect(array('providerdetails')); } } else { $errors = $model->getErrors(); //var_dump($errors); } } $this->render('provideredit', array('companyDetail' => $detail, 'model' => $model, 'additionalService' => $additionalService)); }