public function actionAjaxDelete() { $id = $_REQUEST['id']; //echo $id;die; $detail = PaymentToAdmin::model()->findByAttributes(array('id' => $id)); //echo "<pre>";print_r($detail);die; $detail->delete(); echo "success"; }
public function actionIndex() { $model = new PaymentCustomerUser(); $booking = new CustomerBooking(); $address = new CustomerAddress(); $company = new CompanyRequest(); $ses = Yii::app()->session['CleaningDetail']; $servicetype = Yii::app()->session['ServiceTypeId']; $zip = $ses['CleaningTime']['PostCode']; // echo "<pre>";print_r(base64_decode($_REQUEST['value']));die; //echo "<pre>";print_r($ses);die; //$myProducts = Yii::app()->session['detail']; $detail = Yii::app()->session['detail']; foreach ($detail['Additional'] as $k => $d) { $detailadnl[$k] = ServicetypeAdditionalservices::model()->findAll(array('condition' => 'id=:id', 'params' => array(':id' => $k))); } foreach ($detailadnl as $key => $nam) { // echo "<pre>";print_r($nam); foreach ($nam as $value) { $detailadnl[$key] = $value['additional_service_name']; } } //echo "<pre>";print_r($detail['Additional']); $finalDetailadnl = array_combine($detailadnl, $detail['Additional']); //echo "<pre>";print_r($fin);die; //$price =$_REQUEST['price']; // code to get the method from admin %age or fiexd cost of total amount $paymentAdmin = PaymentToAdmin::model()->find(array('condition' => 'status=1')); if (!empty($paymentAdmin)) { //echo "adda";die; if ($paymentAdmin['type_of_cost'] == 'Fixed') { $price = $paymentAdmin['cost_percentage']; } else { if (isset($_REQUEST['value'])) { $pri = $paymentAdmin['cost_percentage'] * base64_decode($_REQUEST['value']); $pce = $pri / 100; $price = $pce; } else { $price = base64_decode($_REQUEST['value1']); } } } else { $price = base64_decode($_REQUEST['value']); } //echo $price;die; $service_id = $_REQUEST['service_id']; $rec = UkPostcodes::model()->findByattributes(array('postcode' => $zip)); // detail for logged user $loggedId = Yii::app()->session['loggedId']; $customerDetail = PaymentCustomerUser::model()->findByPk(array('id' => $loggedId)); //echo "<pre>";print_r($customerDetail);die; //echo "<pre>";print_r($servicetype);die; if (isset($_POST['PaymentCustomerUser'])) { $logged = Yii::app()->session['loggedId']; //echo "<pre>";print_r($ses);die; $model->attributes = $_POST['PaymentCustomerUser']; if ($model->validate()) { // echo "<pre>";print_r($_REQUEST);die; $exp = $_REQUEST['PaymentCustomerUser']['expire']; $res = explode("/", $exp); $month = $res[0]; $year = $res[1]; $cardDetail = implode(explode(" ", trim($_REQUEST['PaymentCustomerUser']['cardDetail']))); /*if($_REQUEST['value']==0) { $price=0; } */ $paymentInfo = array('Member' => array('first_name' => $_REQUEST['PaymentCustomerUser']['cname'], 'last_name' => $_REQUEST['PaymentCustomerUser']['clname'], 'billing_address' => $_REQUEST['PaymentCustomerUser']['caddress'], 'billing_address2' => $_REQUEST['PaymentCustomerUser']['caddress'], 'billing_country' => $_REQUEST['PaymentCustomerUser']['country'], 'billing_city' => $_REQUEST['PaymentCustomerUser']['city'], 'billing_zip' => $_REQUEST['PaymentCustomerUser']['zipcode']), 'CreditCard' => array('card_number' => $cardDetail, 'expiration_month' => trim($month), 'expiration_year' => trim($year), 'cv_code' => $_REQUEST['PaymentCustomerUser']['code'], 'credit_type' => $_REQUEST['PaymentCustomerUser']['cardType']), 'Order' => array('theTotal' => $price)); // echo "<pre>";print_r($paymentInfo); $result = Yii::app()->Paypal->DoDirectPayment($paymentInfo); //echo http_build_query($data, 'flags_'); //echo "<pre>";print_r($result);die; if ($result['ACK'] == 'Failure') { $links = CmsPages::model()->findAll(); Yii::app()->params['MyArray'] = $links; Yii::app()->user->setFlash('ack', "Please check your card details"); $this->render('index', array('model' => $model, 'town' => $rec, 'price' => $price, 'service_id' => $service_id)); } if (!Yii::app()->Paypal->isCallSucceeded($result)) { if (Yii::app()->Paypal->apiLive === true) { //Live mode basic error message $error = 'We were unable to process your request. Please try again later'; } else { //Sandbox output the actual error message to dive in. $error = $result['L_LONGMESSAGE0']; } echo $error; } else { //Payment was completed successfully, do the rest of your stuff // code to register the customer and save transaction id in differ table if (!empty($result['TRANSACTIONID'])) { $model->cname = $_REQUEST['PaymentCustomerUser']['cname']; $model->clname = $_REQUEST['PaymentCustomerUser']['clname']; $model->caddress = $_REQUEST['PaymentCustomerUser']['caddress']; $model->zipcode = $_REQUEST['PaymentCustomerUser']['zipcode']; $model->phone = $_REQUEST['PaymentCustomerUser']['phone']; $model->email = $_REQUEST['PaymentCustomerUser']['email']; $model->city = $_REQUEST['PaymentCustomerUser']['city']; $model->country = $_REQUEST['PaymentCustomerUser']['country']; $model->cregistered = date('Y-m-d'); $email = $_REQUEST['PaymentCustomerUser']['email']; $user = PaymentCustomerUser::model()->exists('email=:email', array('email' => $email)); // $user=PaymentCustomerUser::model()->findByAttributes(array('email'=>$email)); //echo "<pre>";print_r($user);die; //if(count($user)<0) if (empty($user)) { //echo "hlo";die; $cleartext_password = rand(0, 9999); $model->password = md5($cleartext_password); if ($model->save()) { $signature = md5($model->email . $model->password); $subject = 'Welcome to Wow Cleans'; $body = $this->renderPartial('registrationEmail', array('model' => $model, 'password' => $cleartext_password, 'url' => $this->createAbsoluteUrl('../registration/login', array('email' => $model->email, 'signature' => $signature))), true); Yii::app()->mailer->send($model->email, $subject, $body); // booking detail for register customer here $custId = Yii::app()->db->getLastInsertID(); $transId = $result['TRANSACTIONID']; $cust = PaymentCustomerUser::model()->findByAttributes(array('id' => $custId)); $companyDetail = ServiceUser::model()->findByAttributes(array('id' => $_REQUEST['service_id'])); //echo "<pre>";print_r($companyDetail);die; // save address for customer in different table $address->address = $_REQUEST['PaymentCustomerUser']['caddress']; $address->zipcode = $_REQUEST['PaymentCustomerUser']['zipcode']; $address->date = date('Y-m-d'); $address->customer_id = $custId; $address->save(); $address_id = Yii::app()->db->getLastInsertID(); $re = CustomerAddress::model()->findByAttributes(array('customer_id' => $custId)); //echo "<pre>";print_r($re);die; $addressId = $re->id; $booking->customer_id = $custId; $booking->service_id = $_REQUEST['service_id']; $booking->service_type_id = $servicetype; //$booking->price =$_REQUEST['price']; $booking->price = $price; $booking->trans_id = $transId; $booking->date = date('Y-m-d'); if (!empty($address_id)) { $booking->customer_address_id = $address_id; } else { $booking->customer_address_id = $addressId; } $detail = Yii::app()->session['detail']; // echo "<pre>";print_r($detail);die; foreach ($detail['Cleaning'] as $type => $number) { $cleaningDetail .= $number . "-" . $type . ","; } $booking->cleaningDetail = substr($cleaningDetail, 0, -1); /*foreach($detail['Additional'] as $k=>$val) { if($val!=0) { $addnl .=$val."-".$k.","; } } */ foreach ($finalDetailadnl as $k => $val) { if ($val != 0) { $addnl .= $val . "-" . $k . ","; } } $booking->additional = substr($addnl, 0, -1); $booking->additional_details = $detail['AdditionalCustDetail']['AdditionalCustDetail']; if ($booking->save()) { //booking id for thaks page $insert_id = Yii::app()->db->getLastInsertID(); $cutId = Booking::model()->findByPk(array('id' => $insert_id)); $customerId = $cutId->customer_id; /*code to enter the company request details in company request table*/ $company->booking_id = $insert_id; $company->service_id = $_REQUEST['service_id']; $company->customer_id = $customerId; $company->cleaningtime = $ses['CleaningTime']['time']; $company->postcode = $ses['CleaningTime']['PostCode']; $company->cleaningdate = date("Y-m-d", strtotime($ses['CleaningTime']['CleaningDate'])); $company->date = date('Y-m-d'); $company->no_of_hours = $ses['CleaningTime']['noOfhour']; $company->no_of_cleaners = $ses['CleaningTime']['noOfCleaners']; $company->save(false); // echo $insert_id;die; // send mail to customer $subject = 'Welcome to Wow Cleans'; $body = $this->renderPartial('customerEmail', array('model' => $companyDetail, 'cust' => $_REQUEST, 'detail' => $detail, 'adnl' => $finalDetailadnl, 'price' => $price, 'trans' => $result['TRANSACTIONID']), true); Yii::app()->mailer->send($cust->email, $subject, $body); // send mail to company $subject = 'Welcome to Wow Cleans'; $body = $this->renderPartial('companyEmail', array('model' => $companyDetail, 'cust' => $_REQUEST, 'detail' => $detail, 'adnl' => $finalDetailadnl, 'price' => $price, 'trans' => $result['TRANSACTIONID']), true); Yii::app()->mailer->send($companyDetail->email, $subject, $body); //$this->refresh(); //$this->redirect(array('../registration/index')); } // booking detail for register customer ends here $link = CmsPages::model()->findAll(); Yii::app()->params['MyArray'] = $link; // $this->redirect('thanks','param1'=>$companyDetail); $this->redirect(array('payment/thanks', 'param1' => $insert_id)); //exit(); //$this->refresh(); //$this->redirect(array('registration/registration')); } } else { // echo "fsf";die; //$price =$_REQUEST['price']; $email = $_REQUEST['PaymentCustomerUser']['email']; $transId = $result['TRANSACTIONID']; $rec = PaymentCustomerUser::model()->findByAttributes(array('email' => $email)); //echo "<pre>";print_r($rec);die; $custId = $rec->id; $companyDetail = ServiceUser::model()->findByAttributes(array('id' => $_REQUEST['service_id'])); // save address for customer in different table $address->address = $_REQUEST['PaymentCustomerUser']['caddress']; $address->zipcode = $_REQUEST['PaymentCustomerUser']['zipcode']; $address->date = date('Y-m-d'); $address->customer_id = $custId; if (!($user = CustomerAddress::model()->exists('address=:address', array('address' => $_REQUEST['PaymentCustomerUser']['caddress'])))) { $address->save(); $address_id = Yii::app()->db->getLastInsertID(); } //$address_id = Yii::app()->db->getLastInsertID(); $re = CustomerAddress::model()->findByAttributes(array('customer_id' => $custId)); //echo "<pre>";print_r($rec->id);die; $addressId = $re->id; $booking->customer_id = $custId; $booking->service_id = $_REQUEST['service_id']; $booking->service_type_id = $servicetype; //$booking->price =$_REQUEST['price']; $booking->price = $price; $booking->trans_id = $transId; $booking->date = date('Y-m-d'); if (!empty($address_id)) { $booking->customer_address_id = $address_id; } else { $booking->customer_address_id = $addressId; } $detail = Yii::app()->session['detail']; // echo "<pre>";print_r($detail);die; foreach ($detail['Cleaning'] as $type => $number) { $cleaningDetail .= $number . "-" . $type . ","; } $booking->cleaningDetail = substr($cleaningDetail, 0, -1); //echo "<pre>";print_r($detail['Additional']);die; /*foreach($detail['Additional'] as $k=>$val) { if($val!=0) { $addnl .=$val."-".$k.","; } } */ foreach ($finalDetailadnl as $k => $val) { if ($val != 0) { $addnl .= $val . "-" . $k . ","; } } $booking->additional = substr($addnl, 0, -1); $booking->additional_details = $detail['AdditionalCustDetail']['AdditionalCustDetail']; if ($booking->save(false)) { $insert_id = Yii::app()->db->getLastInsertID(); $cutId = Booking::model()->findByPk(array('id' => $insert_id)); //echo "<pre>";print_r($cutId);die; $customerId = $cutId->customer_id; /*code to add the company request details in company request table*/ $company->booking_id = $insert_id; $company->service_id = $_REQUEST['service_id']; $company->customer_id = $customerId; $company->cleaningtime = $ses['CleaningTime']['time']; $company->postcode = $ses['CleaningTime']['PostCode']; $company->cleaningdate = date("Y-m-d", strtotime($ses['CleaningTime']['CleaningDate'])); $company->date = date('Y-m-d'); $company->no_of_hours = $ses['CleaningTime']['noOfhour']; $company->no_of_cleaners = $ses['CleaningTime']['noOfCleaners']; $company->save(false); // send mail to customer $subject = 'Welcome to Wow Cleans'; $body = $this->renderPartial('customerEmail', array('model' => $companyDetail, 'cust' => $_REQUEST, 'detail' => $detail, 'adnl' => $finalDetailadnl, 'price' => $price, 'trans' => $result['TRANSACTIONID']), true); Yii::app()->mailer->send($rec->email, $subject, $body); // send mail to company $subject = 'Welcome to Wow Cleans'; $body = $this->renderPartial('companyEmail', array('model' => $companyDetail, 'cust' => $_REQUEST, 'detail' => $detail, 'adnl' => $finalDetailadnl, 'price' => $price, 'trans' => $result['TRANSACTIONID']), true); Yii::app()->mailer->send($companyDetail->email, $subject, $body); //$this->refresh(); if ($logged != '') { //$this->redirect(array('../registration/customerdashboard')); $this->redirect(array('payment/thanks', 'param1' => $insert_id)); } else { $this->redirect(array('payment/thanks', 'param1' => $insert_id)); //$this->redirect(array('../registration/index')); } } //echo $servicetype; die; //echo "<pre>";print_r($rec);die; } } } Yii::app()->end(); } else { $errors = $model->getErrors(); // var_dump($errors); } } $links = CmsPages::model()->findAll(); Yii::app()->params['MyArray'] = $links; $this->render('index', array('model' => $model, 'town' => $rec, 'price' => $price, 'service_id' => $service_id, 'customerDetail' => $customerDetail)); }