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