Unnamed

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