<%
include "$DOCUMENT_ROOT/webprog/libs/setup.inc";
include "$DOCUMENT_ROOT/webprog/libs/mail.inc";
include "$DOCUMENT_ROOT/webprog/libs/template.inc";
include "$DOCUMENT_ROOT/webprog/libs/oohforms.inc";
include "$DOCUMENT_ROOT/webprog/libs/tpl_form.inc";
include "$DOCUMENT_ROOT/webprog/libs/country_code.inc";

LoadLang("dbmcd_requestform");
if (!isset($template))
  $template = 'blank_home.html';

class myform extends tpl_form {
  var $classname = "dbmcd_requestform";
  /*
   * Define form fields
   */
  function setup_fields() {
    global $lang, $CCodes, $template;

    $this->form_data->add_element(array("type"=>"text",  "name"=>"FIRST_NAME",    "size"=> 20, "maxlength"=>20));
    $this->form_data->add_element(array("type"=>"text",  "name"=>"MI_NAME",    "size"=> 2, "maxlength"=>1, "optional"=>true));
    $this->form_data->add_element(array("type"=>"text",  "name"=>"LAST_NAME",     "size"=> 20, "maxlength"=>20));
    $this->form_data->add_element(array("type"=>"email", "name"=>"UserEMail",     "size"=> 30, "maxlength"=>50,"valid_e"=>$lang->valid_email));
    $this->form_data->add_element(array("type"=>"text",  "name"=>"Company",       "size"=> 30, "maxlength"=>50, "optional"=>true));
    $this->form_data->add_element(array("type"=>"text",  "name"=>"Streetaddress1","size"=> 50, "maxlength"=>100));
    $this->form_data->add_element(array("type"=>"text",  "name"=>"Streetaddress2","size"=> 50, "maxlength"=>100, "optional"=>true));
    $this->form_data->add_element(array("type"=>"text",  "name"=>"City",          "size"=> 20, "maxlength"=>30));
    $this->form_data->add_element(array("type"=>"text", "name"=>"State",         "size"=> 20, "maxlength"=>30));
    $this->form_data->add_element(array("type"=>"select","name"=>"COUNTRY","options" => $CCodes,"maxlength"=>5));
    $this->form_data->add_element(array("type"=>"text",   "name"=>"ZIP",           "size"=> 10, "maxlength"=>10));
    $this->form_data->add_element(array("type"=>"text", "name"=>"Phone",         "size"=> 30, "maxlength"=>30));
    $this->form_data->add_element(array("type"=>"text", "name"=>"Fax",         "size"=> 30, "maxlength"=>30, "optional"=>true));
    $this->form_data->add_element(array("type"=>"checkbox", "name"=>"DBMCD", "checked"=>true, "optional"=>true));
    $this->form_data->add_element(array("type"=>"checkbox", "name"=>"DGUX", "optional"=>true));
    $this->form_data->add_element(array("type"=>"checkbox", "name"=>"HPUX", "optional"=>true));
    $this->form_data->add_element(array("type"=>"checkbox", "name"=>"IBMAIX", "optional"=>true));
    $this->form_data->add_element(array("type"=>"checkbox", "name"=>"FREEBSD3", "optional"=>true));
    $this->form_data->add_element(array("type"=>"checkbox", "name"=>"SUNSPARC", "optional"=>true));

    $this->form_data->add_element(array("type"=>"textarea", "name"=>"Comments", "rows"=>6, "cols"=>60, "value"=>"", "optional"=>true));
    $this->form_data->add_element(array("type"=>"submit","name"=>"submit",        "value"=>$lang->submit));
    $this->form_data->add_element(array("type"=>"reset", "name"=>"reset",         "value"=>$lang->reset));
    $this->form_data->add_element(array("type"=>"hidden","name"=>"template","value"=>$template));
  }
  /*
   * Insert into
   */
  function process_input() {
    global $lang, $dbh, $server, $HTTP_HOST;
    global $UserEMail, $FIRST_NAME, $MI_NAME, $LAST_NAME;
    global $Company, $Streetaddress1, $Streetaddress2;
    global $City, $State, $COUNTRY, $ZIP, $Phone, $Fax;
    global $DBMCD, $DGUX, $HPUX, $IBMAIX, $FREEBSD3, $SUNSPARC;
    global $Comments;
  
    if (1)
    {
      $rs=odbc_prepare($dbh, "insert into REQUESTFORM (
                                EMAIL, FIRSTNAME, MIDDLENAME, LASTNAME, COMPANY,
                                ADDRESS1, ADDRESS2, CITY, STATE, COUNTRY,
                                ZIP, PHONE, FAX, DBMCD, DGUX, HPUX, IBMAIX, 
                                FREEBSD3, SUNSPARC, COMMENTS, DBSERVER
                              )
                              values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");

          if (isset($DBMCD))
		$DBMCD = 'Y';
	  else
		$DBMCD = 'N';

          if (isset($DGUX))
		$DGUX = 'Y';
	  else
		$DGUX = 'N';

          if (isset($HPUX))
		$HPUX = 'Y';
	  else
		$HPUX = 'N';

          if (isset($IBMAIX))
		$IBMAIX = 'Y';
	  else
		$IBMAIX = 'N';

          if (isset($FREEBSD3))
		$FREEBSD3 = 'Y';
	  else
		$FREEBSD3 = 'N';

          if (isset($SUNSPARC))
		$SUNSPARC = 'Y';
	  else
		$SUNSPARC = 'N';

      $Para[0]=trim($UserEMail);
      $Para[1]=trim($FIRST_NAME);
      $Para[2]=trim($MI_NAME);
      $Para[3]=trim($LAST_NAME);
      $Para[4]=trim($Company);
      $Para[5]=trim($Streetaddress1);       
      $Para[6]=trim($Streetaddress2);
      $Para[7]=trim($City);
      $Para[8]=trim($State);
      $Para[9]=trim($COUNTRY);
      $Para[10]=trim($ZIP);
      $Para[11]=trim($Phone);
      $Para[12]=trim($Fax);
      $Para[13]=trim($DBMCD);
      $Para[14]=trim($DGUX);
      $Para[15]=trim($HPUX);
      $Para[16]=trim($IBMAIX);
      $Para[17]=trim($FREEBSD3);
      $Para[18]=trim($SUNSPARC);
      $Para[19]=$Comments;
      $Para[20]=$server->DBSERVER;

      $rc = @odbc_execute($rs,$Para);
      odbc_free_result($rs);
      if (!$rc)
      {
        $this->error = $lang->insert_fail();
        return false;
      }
    }

    // Send email to CASEMaker Sales
    $this->send_email();
    
    $this->values = $lang->message2;

    return true;
  }

// send request form to sales@casemaker.com
  function send_email()
  {
    global $server, $lang;
    global $UserEMail, $FIRST_NAME, $MI_NAME, $LAST_NAME;
    global $Company, $Streetaddress1, $Streetaddress2;
    global $City, $State, $COUNTRY, $ZIP, $Phone, $Fax;
    global $DBMCD, $DGUX, $HPUX, $IBMAIX, $FREEBSD3, $SUNSPARC;
    global $Comments;

    $Today=date("m/d/Y l H:i:s");
    $Body =
"Request: $lang->request
------------------------------------
EMail: $UserEMail
Fisrt Name: $FIRST_NAME
Middele Name: $MI_NAME
LAST Name: $LAST_NAME
Company: $Company
Address: $Streetaddress1 $Streetaddress2
City: $City
State: $State
Country: $COUNTRY
ZIP: $ZIP
Phone: $Phone
Fax: $Fax
Please ship me a standard evaluation CD of DBMaker: $DBMCD
Please ship me DBMaker for Data General: $DGUX
Please ship me DBMaker for Hewlett-Packard HP/UX: $HPUX
Please ship me DBMkaer for IBM AIX: $IBMAIX 
Please ship me DBMaker for FreeBSD 3.x: $FREEBSD3
Please ship me DBMaker for Sun Solaris(SPARC): $SUNSPARC
Comments:
$Comments
------------------------------------
$Today";

    // send notice to sales@casemaker.com
    $MailTo = new Smtp();

    $MailTo-> SmtpMail($lang->email_from, $lang->email_from_name,
                       $lang->email_to, $lang->email_to_name,
                       $lang->request." [$FIRST_NAME $LAST_NAME]",
                       $Body , null, 0);

    $MailTo->Close();

    // send notice to webmaster@casemaker.com
    $MailTo = new Smtp();

    $MailTo-> SmtpMail($lang->email_from, $lang->email_from_name,
                       $lang->email_to_1, $lang->email_to_name_1,
                       $lang->request." [$FIRST_NAME $LAST_NAME]",
                       $Body , null, 0);

    $MailTo->Close();
  }
}

function MainPage($body)
{
  global $lang;
  html_head($lang->title);
  echo $body;
  html_tail();
}

/*
 * main program
 */
 $dbh = db_connect();
/*
 page_open(array("auth" => "Auth",
                 "perm"	=> "Perm",
                 "user" => "User"));
 if ($auth->login)
 {
   header("Location: index.php");
   exit;
 }
*/
 $f = new myform;
 $f->init(array());
 
 if ($rv = $f->get_values())
 {
   $f->clear();
   $body = $rv;
 }
 else
 {
   $ERROR_MESSAGE = $f->error;
   $body = $f->display();
 }

 MainPage($body);
%>