function getCustomer() { $this->autoRender = false; $sql = "SELECT * FROM customer_old;"; $datas = $this->Cabinet->query($sql); App::import("Model", "CustomerManager.Customer"); App::import("Model", "CustomerManager.BuilderAccount"); App::import("Model", "CustomerManager.CustomerAddress"); foreach ($datas as $data) { $Customer_model = new Customer(); $BuilderAccount_model = new BuilderAccount(); $CustomerAddress_model = new CustomerAddress(); $cus_data['Customer']['last_name'] = $data['customer_old']['CustomerName']; $cus_data['Customer']['website'] = $data['customer_old']['WebSite']; if ($data['customer_old']['Inactive'] == 0) { $cus_data['Customer']['status'] = 1; } else { $cus_data['Customer']['status'] = 0; } $cus_data['Customer']['address'] = $data['customer_old']['loc_Address1']; $cus_data['Customer']['city'] = $data['customer_old']['loc_City']; $cus_data['Customer']['province'] = $data['customer_old']['loc_Province']; $cus_data['Customer']['postal_code'] = $data['customer_old']['loc_PostalCode']; $cus_data['Customer']['country'] = $data['customer_old']['loc_Country']; $cus_data['Customer']['phone'] = $data['customer_old']['loc_Phone']; $cus_data['Customer']['fax_number'] = $data['customer_old']['loc_FaxNumber']; $cus_data['Customer']['customer_type_id'] = 2; $cus_data['Customer']['site_address_exists'] = 1; $sales_person = array($this->loginUser['id']); $cus_data['Customer']['sales_representatives'] = serialize($sales_person); $Customer_model->save($cus_data['Customer']); App::uses("CustomerSalesRepresentetives", "CustomerManager.Model"); $s = new CustomerSalesRepresentetives(); $sales_data['customer_id'] = $Customer_model->id; $sales_data['user_id'] = $this->loginUser['id']; $s->save($sales_data); $cus_data['BuilderAccount']['customer_id'] = $Customer_model->id; $cus_data['BuilderAccount']['builder_legal_name'] = $data['customer_old']['CustomerName']; $cus_data['BuilderAccount']['credit_terms'] = $data['customer_old']['CreditTerms']; $cus_data['BuilderAccount']['credit_limit'] = $data['customer_old']['CreditLimit']; $cus_data['BuilderAccount']['invoice_on_day'] = $data['customer_old']['StartDate']; $cus_data['BuilderAccount']['quotes_validity'] = 30; $BuilderAccount_model->save($cus_data['BuilderAccount']); $cus_data['CustomerAddress']['customer_id'] = $Customer_model->id; $cus_data['CustomerAddress']['first_name'] = $data['customer_old']['con_ContactName']; $cus_data['CustomerAddress']['title'] = $data['customer_old']['con_Title']; $cus_data['CustomerAddress']['phone'] = $data['customer_old']['con_WorkPhone']; $cus_data['CustomerAddress']['fax_number'] = $data['customer_old']['con_FAX']; $cus_data['CustomerAddress']['cell'] = $data['customer_old']['con_MobilePhone']; $cus_data['CustomerAddress']['address'] = $data['customer_old']['con_Address1']; $cus_data['CustomerAddress']['city'] = $data['customer_old']['con_City']; $cus_data['CustomerAddress']['province'] = $data['customer_old']['con_Province']; $cus_data['CustomerAddress']['postal_code'] = $data['customer_old']['con_PostalCode']; $cus_data['CustomerAddress']['country'] = $data['customer_old']['con_Country']; $cus_data['CustomerAddress']['email'] = $data['customer_old']['con_eMail_Address']; $CustomerAddress_model->save($cus_data['CustomerAddress']); } }
public function saveCustomerForm() { $this->autoRender = FALSE; $this->request->data['Customer']['first_name'] = $this->request->data['first_name']; $this->request->data['Customer']['last_name'] = $this->request->data['last_name']; $this->request->data['Customer']['phone'] = $this->request->data['phone']; $this->request->data['Customer']['sales_representatives'] = $this->request->data['sales_person']; $this->request->data['Customer']['status'] = 1; App::import("Model", "CustomerManager.Customer"); $customer = new Customer(); App::import("Model", "CustomerManager.BuilderAccount"); $builderaccount = new BuilderAccount(); if ($this->request->data['type'] == 'Retail Customer') { $this->request->data['Customer']['customer_type_id'] = 1; $info = $customer->save($this->request->data); $data1['value'] = $info['Customer']['id']; $data1['name'] = $info['Customer']['first_name'] . " " . $info['Customer']['last_name']; echo json_encode($data1); } if ($this->request->data['type'] == 'Builder') { $this->request->data['Customer']['customer_type_id'] = 2; $info = $customer->save($this->request->data); $builder['BuilderAccount']['customer_id'] = $info['Customer']['id']; $builder['BuilderAccount']['builder_legal_name'] = $info['Customer']['first_name'] . " " . $info['Customer']['last_name']; $builder['BuilderAccount']['builder_type'] = 108; $builderaccount->save($builder); $data2['value'] = $info['Customer']['id']; $data2['name'] = $info['Customer']['first_name'] . " " . $info['Customer']['last_name']; echo json_encode($data2); } exit; }