rendered paste body private function do_sign_up_customer($data) { $DP2 = $this->CI->load->database('dp2', TRUE); $DP2->where('Email', $data['Email']); $query = $DP2->get('customers'); $MY = $this->CI->load->database('my', TRUE); $MY->where('Email', $data['Email']); $query1 = $MY->get('CustomerSignUps'); if($query->num_rows() > 0) { $result['Code'] = 'CustomerExists'; $shipping_data['FullName'] = $query->row()->Contact; $shipping_data['StudioName'] = $query->row()->Name; $shipping_data['Email'] = $query->row()->Email; $shipping_data['PhoneNumber'] = $query->row()->Phone1; $shipping_data['FaxNumber'] = $query->row()->Fax; $shipping_data['AccountNumber'] = $query->row()->ID; $result['NewCustomerData'] = Array($shipping_data, 'struct'); } elseif($query1->num_rows() > 0) { $result['Code'] = 'CustomerExists'; $shipping_data['FullName'] = $query1->row()->FullName; $shipping_data['StudioName'] = $query1->row()->StudioName; $shipping_data['Email'] = $query1->row()->Email; $shipping_data['PhoneNumber'] = $query1->row()->PhoneNumber; $shipping_data['FaxNumber'] = ''; $shipping_data['AccountNumber'] = $query1->row()->ID; $result['NewCustomerData'] = Array($shipping_data, 'struct'); } else { $MY->set($data); $MY->insert('CustomerSignUps'); $result['Code'] = 'Success'; $result['CustomerID'] = $MY->insert_id(); $email_data['CustomerSignUp'] = $data; $email_data['CustomerSignUp']['ID'] = $result['CustomerID']; $this->CI->load->library('email_engine'); $this->CI->email_engine->send_message('New Account Services', 'new_customer_signup', $email_data, $email_data['CustomerSignUp']['Email'], 'Your New Account'); $this->CI->email_engine->send_message('New Account Services', 'new_customer_admin', $email_data, 'Max@jdlab.com', 'New Customer Signup - ' . $email_data['CustomerSignUp']['StudioName'], true); $this->CI->email_engine->send_message('New Account Services', 'new_customer_admin', $email_data, 'tom@jdlab.com', 'New Customer Signup - ' . $email_data['CustomerSignUp']['StudioName'], true); $this->CI->email_engine->send_message('New Account Services', 'new_customer_admin', $email_data, 'julie@jdphotoimaging.com', 'New Customer Signup - ' . $email_data['CustomerSignUp']['StudioName'], true); $this->CI->email_engine->send_message('New Account Services', 'new_customer_admin', $email_data, 'heidi@jdphotoimaging.com', 'New Customer Signup - ' . $email_data['CustomerSignUp']['StudioName'], true); if(isset($data['Newsletter']) && $data['Newsletter'] == "1") { $this->CI->email_engine->send_message('JD Newsletter Signup', 'new_customer_newsletter', $email_data, 'chelseajaie@mac.com', 'JD Newsletter Signup - ' . $email_data['CustomerSignUp']['Email'], true); } //$this->CI->email_engine->process_mail(); $result['Code'] = 'Success'; } return $result; }