<?php

require('PEAR.php');
require('DB.php');
require('HTML/QuickForm.php');
$TITLE="Company Support Request Form";

$formC = new HTML_QuickForm( $formName='Contact' , $method='get' );

$formC->addElement('text','firstname','First Name:','size="40"');
$formC->addElement('text','lastname','Last Name:','size="40"');
$formC->addElement('text','email','E-mail:','size="50"');
$formC->addElement('text','phone','Phone:','size="10"');
$formC->addElement('text','address1','Address:','size="60"');
$formC->addElement('text','address2','Address 2:','size="50"');
$formC->addElement('text','city','City:','size="30"');
$formC->addElement('text','state','State:','size="20"');
$formC->addElement('text','postal_code','Zip code:','size="10"');
$option_i = array(1=>'-Select an Incident
Type-','audio','dvdcd','drive','input','modem','monitor','os','other','printscan','bios','hardware','video','na');
$formC->addElement('select','incident_type','Incident Type:',$option_i);
$option_os = array(1=>'-Select an Operating
System-','aix','bios','efi','elinux','elinux21','elinux3','hpux','linux','linux61','linux62','linux70','linux71','linux72','linux73','linux80','linux90','msdos','netware','openserver','os2','ppc02','ppc03','solaris','unixware','vines','win2k','win3x','win95','win98','wince','winme','winnt35x','winnt4','winp','wins03','winxp','na');
$formC->addElement('select','os_type','Operating System Type:',$option_os);
$formC->addElement('textarea','text','Problem Details:','rows="10" cols="41"');
$formC->addElement('submit','submit','Submit');
$formC->addElement('hidden','id','<?=$data["id"]?>');
$formC->addElement('hidden','lastmod','<?=$data["id"]?>');

$formC->addRule('firstname','is required','required');
$formC->addRule('lastname','is required','required');
$formC->addRule('email','is required','required');
$formC->addRule('phone','is required','required');
$formC->addRule('incident_type','is required','required');
$formC->addRule('os_type','is required','required');
$formC->addRule('text','is required','required');
$formC->addRule('email','invalid','email');

$formC->applyFilter('__ALL__','trim');

function getInstance() {
	$db = DB::connect('mysqli://php:phpis2kool@localhost/support');
	if (DB::isError($db)) {die ($db->getUserInfo());}
	$db->setFetchMode(DB_FETCHMODE_ASSOC);
	return $db;
}

if ($formC->validate()) {

	// assume validation checks out

	$id = $_GET['id'] ;
	$ln = $_GET['lastname'] ;
	
	$db = getInstance();
	$existing_lastname = $db->getOne("SELECT lastname FROM customer WHERE lastname = ?", $ln);
	echo "submitted lastname: $ln....";
	if ($db->isError($existing_lastname)) {die ($db->getUserInfo() .  " at ".__LINE__);}
	if ($existing_lastname  != $ln) {

		$table_name = 'customer';
		
		$fields_values = array(
			'firstname'		=> $_GET['firstname'] ,
			'lastname'		=> $_GET['lastname'] ,
			'email'			=> $_GET['email'] ,
			'phone'			=> $_GET['phone'] ,
			'address1'		=> $_GET['address1'] ,
			'address2'		=> $_GET['address2'] ,
			'city'			=> $_GET['city'] ,
			'state'			=> $_GET['state'] ,
			'postal_code'	=> $_GET['postal_code']
		);
		
		$res = $db->autoExecute($table_name, $fields_values,
								DB_AUTOQUERY_INSERT);
		
		if (PEAR::isError($res)) {
			die($res->getUserInfo().  " at ".__LINE__);
		}

		echo "new record inserted<br>";

	} else {
		echo "customer already exists in db, skipping insert<br>";
	}
	
	

	echo "<br>Thank you for coming to us with the problem you are experiencing. We will get back to you shortly." ;
} else {
	$formC->display();
}
?>