/companyadd.php

<?php

if (session_id() == "") session_start(); // Initialize Session data

ob_start(); // Turn on output buffering

?>

<?php include_once "ewcfg8.php" ?>

<?php include_once "ewmysql8.php" ?>

<?php include_once "phpfn8.php" ?>

<?php include_once "companyinfo.php" ?>

<?php include_once "userinfo.php" ?>

<?php include_once "userfn8.php" ?>

<?php ew_Header(FALSE) ?>

<?php



// Create page object

$company_add = new ccompany_add();

$Page =& $company_add;



// Page init

$company_add->Page_Init();



// Page main

$company_add->Page_Main();

?>

<?php include_once "header.php" ?>

<script type="text/javascript">

<!--



// Create page object

var company_add = new ew_Page("company_add");



// page properties

company_add.PageID = "add"; // page ID

company_add.FormID = "fcompanyadd"; // form ID

var EW_PAGE_ID = company_add.PageID; // for backward compatibility



// extend page with ValidateForm function

company_add.ValidateForm = function(fobj) {

	ew_PostAutoSuggest(fobj);

	if (!this.ValidateRequired)

		return true; // ignore validation

	if (fobj.a_confirm && fobj.a_confirm.value == "F")

		return true;

	var i, elm, aelm, infix;

	var rowcnt = 1;

	for (i=0; i<rowcnt; i++) {

		infix = "";

		elm = fobj.elements["x" + infix + "_name"];

		if (elm && !ew_HasValue(elm))

			return ew_OnError(this, elm, ewLanguage.Phrase("EnterRequiredField") + " - <?php echo ew_JsEncode2($company->name->FldCaption()) ?>");

		elm = fobj.elements["x" + infix + "_address"];

		if (elm && !ew_HasValue(elm))

			return ew_OnError(this, elm, ewLanguage.Phrase("EnterRequiredField") + " - <?php echo ew_JsEncode2($company->address->FldCaption()) ?>");

		//elm = fobj.elements["x" + infix + "_city"];

		//if (elm && !ew_HasValue(elm))

		//	return ew_OnError(this, elm, ewLanguage.Phrase("EnterRequiredField") + " - <?php echo ew_JsEncode2($company->city->FldCaption()) ?>");

		//elm = fobj.elements["x" + infix + "_province"];

		//if (elm && !ew_HasValue(elm))

		//	return ew_OnError(this, elm, ewLanguage.Phrase("EnterRequiredField") + " - <?php echo ew_JsEncode2($company->province->FldCaption()) ?>");

		//elm = fobj.elements["x" + infix + "_telno"];

		//if (elm && !ew_HasValue(elm))

		//	return ew_OnError(this, elm, ewLanguage.Phrase("EnterRequiredField") + " - <?php echo ew_JsEncode2($company->telno->FldCaption()) ?>");

		elm = fobj.elements["x" + infix + "_mobileno"];

		if (elm && !ew_HasValue(elm))

			return ew_OnError(this, elm, ewLanguage.Phrase("EnterRequiredField") + " - <?php echo ew_JsEncode2($company->mobileno->FldCaption()) ?>");

		//elm = fobj.elements["x" + infix + "_faxno"];

		//if (elm && !ew_HasValue(elm))

		//	return ew_OnError(this, elm, ewLanguage.Phrase("EnterRequiredField") + " - <?php echo ew_JsEncode2($company->faxno->FldCaption()) ?>");

		//elm = fobj.elements["x" + infix + "_zemail"];

		//if (elm && !ew_HasValue(elm))

		//	return ew_OnError(this, elm, ewLanguage.Phrase("EnterRequiredField") + " - <?php echo ew_JsEncode2($company->zemail->FldCaption()) ?>");

		//elm = fobj.elements["x" + infix + "_contact"];

		//if (elm && !ew_HasValue(elm))

		//	return ew_OnError(this, elm, ewLanguage.Phrase("EnterRequiredField") + " - <?php echo ew_JsEncode2($company->contact->FldCaption()) ?>");



		// Set up row object

		var row = {};

		row["index"] = infix;

		for (var j = 0; j < fobj.elements.length; j++) {

			var el = fobj.elements[j];

			var len = infix.length + 2;

			if (el.name.substr(0, len) == "x" + infix + "_") {

				var elname = "x_" + el.name.substr(len);

				if (ewLang.isObject(row[elname])) { // already exists

					if (ewLang.isArray(row[elname])) {

						row[elname][row[elname].length] = el; // add to array

					} else {

						row[elname] = [row[elname], el]; // convert to array

					}

				} else {

					row[elname] = el;

				}

			}

		}

		fobj.row = row;



		// Call Form Custom Validate event

		if (!this.Form_CustomValidate(fobj)) return false;

	}



	// Process detail page

	var detailpage = (fobj.detailpage) ? fobj.detailpage.value : "";

	if (detailpage != "") {

		return eval(detailpage+".ValidateForm(fobj)");

	}

	return true;

}



// extend page with Form_CustomValidate function

company_add.Form_CustomValidate =  

 function(fobj) { // DO NOT CHANGE THIS LINE!



 	// Your custom validation code here, return false if invalid. 

 	return true;

 }

<?php if (EW_CLIENT_VALIDATE) { ?>

company_add.ValidateRequired = true; // uses JavaScript validation

<?php } else { ?>

company_add.ValidateRequired = false; // no JavaScript validation

<?php } ?>



//-->

</script>

<script language="JavaScript" type="text/javascript">

<!--



// Write your client script here, no need to add script tags.

//-->



</script>

<p class="phpmaker ewTitle"><?php echo $Language->Phrase("Add") ?>&nbsp;<?php echo $Language->Phrase("TblTypeTABLE") ?><?php echo $company->TableCaption() ?></p>

<p class="phpmaker"><a href="<?php echo $company->getReturnUrl() ?>"><?php echo $Language->Phrase("GoBack") ?></a></p>

<?php $company_add->ShowPageHeader(); ?>

<?php

$company_add->ShowMessage();

?>

<form name="fcompanyadd" id="fcompanyadd" action="<?php echo ew_CurrentPage() ?>" method="post" onsubmit="return company_add.ValidateForm(this);">

<p>

<input type="hidden" name="t" id="t" value="company">

<input type="hidden" name="a_add" id="a_add" value="A">

<table cellspacing="0" class="ewGrid"><tr><td class="ewGridContent">

<div class="ewGridMiddlePanel">

<table cellspacing="0" class="ewTable">

<?php if ($company->name->Visible) { // name ?>

	<tr id="r_name"<?php echo $company->RowAttributes() ?>>

		<td class="ewTableHeader"><?php echo $company->name->FldCaption() ?><?php echo $Language->Phrase("FieldRequiredIndicator") ?></td>

		<td<?php echo $company->name->CellAttributes() ?>><span id="el_name">

<input type="text" name="x_name" id="x_name" size="30" maxlength="60" value="<?php echo $company->name->EditValue ?>"<?php echo $company->name->EditAttributes() ?>>

</span><?php echo $company->name->CustomMsg ?></td>

	</tr>

<?php } ?>

<?php if ($company->address->Visible) { // address ?>

	<tr id="r_address"<?php echo $company->RowAttributes() ?>>

		<td class="ewTableHeader"><?php echo $company->address->FldCaption() ?><?php echo $Language->Phrase("FieldRequiredIndicator") ?></td>

		<td<?php echo $company->address->CellAttributes() ?>><span id="el_address">

<textarea name="x_address" id="x_address" cols="35" rows="4"<?php echo $company->address->EditAttributes() ?>><?php echo $company->address->EditValue ?></textarea>

</span><?php echo $company->address->CustomMsg ?></td>

	</tr>

<?php } ?>

<?php if ($company->city->Visible) { // city ?>

	<tr id="r_city"<?php echo $company->RowAttributes() ?>>

		<td class="ewTableHeader"><?php echo $company->city->FldCaption() ?><!--zzzzz--></td>

		<td<?php echo $company->city->CellAttributes() ?>><span id="el_city">

<select id="x_city" name="x_city"<?php echo $company->city->EditAttributes() ?>>

<?php

if (is_array($company->city->EditValue)) {

	$arwrk = $company->city->EditValue;

	$rowswrk = count($arwrk);

	$emptywrk = TRUE;

	for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) {

		$selwrk = (strval($company->city->CurrentValue) == strval($arwrk[$rowcntwrk][0])) ? " selected=\"selected\"" : "";

		if ($selwrk <> "") $emptywrk = FALSE;

?>

<option value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]) ?>"<?php echo $selwrk ?>>

<?php echo $arwrk[$rowcntwrk][1] ?>

</option>

<?php

	}

}

?>

</select>

</span><?php echo $company->city->CustomMsg ?></td>

	</tr>

<?php } ?>

<?php if ($company->province->Visible) { // province ?>

	<tr id="r_province"<?php echo $company->RowAttributes() ?>>

		<td class="ewTableHeader"><?php echo $company->province->FldCaption() ?></td>

		<td<?php echo $company->province->CellAttributes() ?>><span id="el_province">

<select id="x_province" name="x_province"<?php echo $company->province->EditAttributes() ?>>

<?php

if (is_array($company->province->EditValue)) {

	$arwrk = $company->province->EditValue;

	$rowswrk = count($arwrk);

	$emptywrk = TRUE;

	for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) {

		$selwrk = (strval($company->province->CurrentValue) == strval($arwrk[$rowcntwrk][0])) ? " selected=\"selected\"" : "";

		if ($selwrk <> "") $emptywrk = FALSE;

?>

<option value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]) ?>"<?php echo $selwrk ?>>

<?php echo $arwrk[$rowcntwrk][1] ?>

</option>

<?php

	}

}

?>

</select>

</span><?php echo $company->province->CustomMsg ?></td>

	</tr>

<?php } ?>

<?php if ($company->telno->Visible) { // telno ?>

	<tr id="r_telno"<?php echo $company->RowAttributes() ?>>

		<td class="ewTableHeader"><?php echo $company->telno->FldCaption() ?></td>

		<td<?php echo $company->telno->CellAttributes() ?>><span id="el_telno">

<input type="text" name="x_telno" id="x_telno" size="30" maxlength="20" value="<?php echo $company->telno->EditValue ?>"<?php echo $company->telno->EditAttributes() ?>>

</span><?php echo $company->telno->CustomMsg ?></td>

	</tr>

<?php } ?>

<?php if ($company->mobileno->Visible) { // mobileno ?>

	<tr id="r_mobileno"<?php echo $company->RowAttributes() ?>>

		<td class="ewTableHeader"><?php echo $company->mobileno->FldCaption() ?><?php echo $Language->Phrase("FieldRequiredIndicator") ?></td>

		<td<?php echo $company->mobileno->CellAttributes() ?>><span id="el_mobileno">

<input type="text" name="x_mobileno" id="x_mobileno" size="30" maxlength="20" value="<?php echo $company->mobileno->EditValue ?>"<?php echo $company->mobileno->EditAttributes() ?>>

</span><?php echo $company->mobileno->CustomMsg ?></td>

	</tr>

<?php } ?>

<?php if ($company->faxno->Visible) { // faxno ?>

	<tr id="r_faxno"<?php echo $company->RowAttributes() ?>>

		<td class="ewTableHeader"><?php echo $company->faxno->FldCaption() ?></td>

		<td<?php echo $company->faxno->CellAttributes() ?>><span id="el_faxno">

<input type="text" name="x_faxno" id="x_faxno" size="30" maxlength="20" value="<?php echo $company->faxno->EditValue ?>"<?php echo $company->faxno->EditAttributes() ?>>

</span><?php echo $company->faxno->CustomMsg ?></td>

	</tr>

<?php } ?>

<?php if ($company->zemail->Visible) { // email ?>

	<tr id="r_zemail"<?php echo $company->RowAttributes() ?>>

		<td class="ewTableHeader"><?php echo $company->zemail->FldCaption() ?></td>

		<td<?php echo $company->zemail->CellAttributes() ?>><span id="el_zemail">

<input type="text" name="x_zemail" id="x_zemail" size="30" maxlength="60" value="<?php echo $company->zemail->EditValue ?>"<?php echo $company->zemail->EditAttributes() ?>>

</span><?php echo $company->zemail->CustomMsg ?></td>

	</tr>

<?php } ?>

<?php if ($company->contact->Visible) { // contact ?>

	<tr id="r_contact"<?php echo $company->RowAttributes() ?>>

		<td class="ewTableHeader"><?php echo $company->contact->FldCaption() ?></td>

		<td<?php echo $company->contact->CellAttributes() ?>><span id="el_contact">

<input type="text" name="x_contact" id="x_contact" size="30" maxlength="60" value="<?php echo $company->contact->EditValue ?>"<?php echo $company->contact->EditAttributes() ?>>

</span><?php echo $company->contact->CustomMsg ?></td>

	</tr>

<?php } ?>

</table>

</div>

</td></tr></table>

<p>

<input type="submit" name="btnAction" id="btnAction" value="<?php echo ew_BtnCaption($Language->Phrase("AddBtn")) ?>">

</form>

<?php

$company_add->ShowPageFooter();

if (EW_DEBUG_ENABLED)

	echo ew_DebugMsg();

?>

<script language="JavaScript" type="text/javascript">

<!--



// Write your table-specific startup script here

// document.write("page loaded");

//-->



</script>

<?php include_once "footer.php" ?>

<?php

$company_add->Page_Terminate();

?>

<?php



//

// Page class

//

class ccompany_add {



	// Page ID

	var $PageID = 'add';



	// Table name

	var $TableName = 'company';



	// Page object name

	var $PageObjName = 'company_add';



	// Page name

	function PageName() {

		return ew_CurrentPage();

	}



	// Page URL

	function PageUrl() {

		$PageUrl = ew_CurrentPage() . "?";

		global $company;

		if ($company->UseTokenInUrl) $PageUrl .= "t=" . $company->TableVar . "&"; // Add page token

		return $PageUrl;

	}



	// Message

	function getMessage() {

		return @$_SESSION[EW_SESSION_MESSAGE];

	}



	function setMessage($v) {

		ew_AddMessage($_SESSION[EW_SESSION_MESSAGE], $v);

	}



	function getFailureMessage() {

		return @$_SESSION[EW_SESSION_FAILURE_MESSAGE];

	}



	function setFailureMessage($v) {

		ew_AddMessage($_SESSION[EW_SESSION_FAILURE_MESSAGE], $v);

	}



	function getSuccessMessage() {

		return @$_SESSION[EW_SESSION_SUCCESS_MESSAGE];

	}



	function setSuccessMessage($v) {

		ew_AddMessage($_SESSION[EW_SESSION_SUCCESS_MESSAGE], $v);

	}



	// Show message

	function ShowMessage() {

		$sMessage = $this->getMessage();

		$this->Message_Showing($sMessage, "");

		if ($sMessage <> "") { // Message in Session, display

			echo "<p class=\"ewMessage\">" . $sMessage . "</p>";

			$_SESSION[EW_SESSION_MESSAGE] = ""; // Clear message in Session

		}



		// Success message

		$sSuccessMessage = $this->getSuccessMessage();

		$this->Message_Showing($sSuccessMessage, "success");

		if ($sSuccessMessage <> "") { // Message in Session, display

			echo "<p class=\"ewSuccessMessage\">" . $sSuccessMessage . "</p>";

			$_SESSION[EW_SESSION_SUCCESS_MESSAGE] = ""; // Clear message in Session

		}



		// Failure message

		$sErrorMessage = $this->getFailureMessage();

		$this->Message_Showing($sErrorMessage, "failure");

		if ($sErrorMessage <> "") { // Message in Session, display

			echo "<p class=\"ewErrorMessage\">" . $sErrorMessage . "</p>";

			$_SESSION[EW_SESSION_FAILURE_MESSAGE] = ""; // Clear message in Session

		}

	}

	var $PageHeader;

	var $PageFooter;



	// Show Page Header

	function ShowPageHeader() {

		$sHeader = $this->PageHeader;

		$this->Page_DataRendering($sHeader);

		if ($sHeader <> "") { // Header exists, display

			echo "<p class=\"phpmaker\">" . $sHeader . "</p>";

		}

	}



	// Show Page Footer

	function ShowPageFooter() {

		$sFooter = $this->PageFooter;

		$this->Page_DataRendered($sFooter);

		if ($sFooter <> "") { // Fotoer exists, display

			echo "<p class=\"phpmaker\">" . $sFooter . "</p>";

		}

	}



	// Validate page request

	function IsPageRequest() {

		global $objForm, $company;

		if ($company->UseTokenInUrl) {

			if ($objForm)

				return ($company->TableVar == $objForm->GetValue("t"));

			if (@$_GET["t"] <> "")

				return ($company->TableVar == $_GET["t"]);

		} else {

			return TRUE;

		}

	}



	//

	// Page class constructor

	//

	function ccompany_add() {

		global $conn, $Language;



		// Language object

		if (!isset($Language)) $Language = new cLanguage();



		// Table object (company)

		if (!isset($GLOBALS["company"])) {

			$GLOBALS["company"] = new ccompany();

			$GLOBALS["Table"] =& $GLOBALS["company"];

		}



		// Table object (user)

		if (!isset($GLOBALS['user'])) $GLOBALS['user'] = new cuser();



		// Page ID

		if (!defined("EW_PAGE_ID"))

			define("EW_PAGE_ID", 'add', TRUE);



		// Table name (for backward compatibility)

		if (!defined("EW_TABLE_NAME"))

			define("EW_TABLE_NAME", 'company', TRUE);



		// Start timer

		if (!isset($GLOBALS["gTimer"])) $GLOBALS["gTimer"] = new cTimer();



		// Open connection

		if (!isset($conn)) $conn = ew_Connect();

	}



	// 

	//  Page_Init

	//

	function Page_Init() {

		global $gsExport, $gsExportFile, $UserProfile, $Language, $Security, $objForm;

		global $company;



		// Security

		$Security = new cAdvancedSecurity();

		if (!$Security->IsLoggedIn()) $Security->AutoLogin();

		if (!$Security->IsLoggedIn()) {

			$Security->SaveLastUrl();

			$this->Page_Terminate("login.php");

		}

		$Security->TablePermission_Loading();

		$Security->LoadCurrentUserLevel($this->TableName);

		$Security->TablePermission_Loaded();

		if (!$Security->IsLoggedIn()) {

			$Security->SaveLastUrl();

			$this->Page_Terminate("login.php");

		}

		if (!$Security->CanAdd()) {

			$Security->SaveLastUrl();

			$this->Page_Terminate("companylist.php");

		}



		// Create form object

		$objForm = new cFormObj();



		// Global Page Loading event (in userfn*.php)

		Page_Loading();



		// Page Load event

		$this->Page_Load();

	}



	//

	// Page_Terminate

	//

	function Page_Terminate($url = "") {

		global $conn;



		// Page Unload event

		$this->Page_Unload();



		// Global Page Unloaded event (in userfn*.php)

		Page_Unloaded();

		$this->Page_Redirecting($url);



		 // Close connection

		$conn->Close();



		// Go to URL if specified

		if ($url <> "") {

			if (!EW_DEBUG_ENABLED && ob_get_length())

				ob_end_clean();

			header("Location: " . $url);

		}

		exit();

	}

	var $DbMasterFilter = "";

	var $DbDetailFilter = "";

	var $Priv = 0;

	var $OldRecordset;

	var $CopyRecord;



	// 

	// Page main

	//

	function Page_Main() {

		global $objForm, $Language, $gsFormError, $company;



		// Process form if post back

		if (@$_POST["a_add"] <> "") {

			$company->CurrentAction = $_POST["a_add"]; // Get form action

			$this->CopyRecord = $this->LoadOldRecord(); // Load old recordset

			$this->LoadFormValues(); // Load form values



			// Validate form

			if (!$this->ValidateForm()) {

				$company->CurrentAction = "I"; // Form error, reset action

				$company->EventCancelled = TRUE; // Event cancelled

				$this->RestoreFormValues(); // Restore form values

				$this->setFailureMessage($gsFormError);

			}

		} else { // Not post back



			// Load key values from QueryString

			$this->CopyRecord = TRUE;

			if (@$_GET["id"] != "") {

				$company->id->setQueryStringValue($_GET["id"]);

				$company->setKey("id", $company->id->CurrentValue); // Set up key

			} else {

				$company->setKey("id", ""); // Clear key

				$this->CopyRecord = FALSE;

			}

			if ($this->CopyRecord) {

				$company->CurrentAction = "C"; // Copy record

			} else {

				$company->CurrentAction = "I"; // Display blank record

				$this->LoadDefaultValues(); // Load default values

			}

		}



		// Perform action based on action code

		switch ($company->CurrentAction) {

			case "I": // Blank record, no action required

				break;

			case "C": // Copy an existing record

				if (!$this->LoadRow()) { // Load record based on key

					$this->setFailureMessage($Language->Phrase("NoRecord")); // No record found

					$this->Page_Terminate("companylist.php"); // No matching record, return to list

				}

				break;

			case "A": // ' Add new record

				$company->SendEmail = TRUE; // Send email on add success

				if ($this->AddRow($this->OldRecordset)) { // Add successful

					$this->setSuccessMessage($Language->Phrase("AddSuccess")); // Set up success message

					$sReturnUrl = $company->getReturnUrl();

					if (ew_GetPageName($sReturnUrl) == "companyview.php")

						$sReturnUrl = $company->ViewUrl(); // View paging, return to view page with keyurl directly

					$this->Page_Terminate($sReturnUrl); // Clean up and return

				} else {

					$company->EventCancelled = TRUE; // Event cancelled

					$this->RestoreFormValues(); // Add failed, restore form values

				}

		}



		// Render row based on row type

		$company->RowType = EW_ROWTYPE_ADD;  // Render add type



		// Render row

		$company->ResetAttrs();

		$this->RenderRow();

	}



	// Get upload files

	function GetUploadFiles() {

		global $objForm, $company;



		// Get upload data

		$index = $objForm->Index; // Save form index

		$objForm->Index = 0;

		$confirmPage = (strval($objForm->GetValue("a_confirm")) <> "");

		$objForm->Index = $index; // Restore form index

	}



	// Load default values

	function LoadDefaultValues() {

		global $company;

		$company->name->CurrentValue = NULL;

		$company->name->OldValue = $company->name->CurrentValue;

		$company->address->CurrentValue = NULL;

		$company->address->OldValue = $company->address->CurrentValue;

		$company->city->CurrentValue = NULL;

		$company->city->OldValue = $company->city->CurrentValue;

		$company->province->CurrentValue = NULL;

		$company->province->OldValue = $company->province->CurrentValue;

		$company->telno->CurrentValue = NULL;

		$company->telno->OldValue = $company->telno->CurrentValue;

		$company->mobileno->CurrentValue = NULL;

		$company->mobileno->OldValue = $company->mobileno->CurrentValue;

		$company->faxno->CurrentValue = NULL;

		$company->faxno->OldValue = $company->faxno->CurrentValue;

		$company->zemail->CurrentValue = NULL;

		$company->zemail->OldValue = $company->zemail->CurrentValue;

		$company->contact->CurrentValue = NULL;

		$company->contact->OldValue = $company->contact->CurrentValue;

	}



	// Load form values

	function LoadFormValues() {



		// Load from form

		global $objForm, $company;

		if (!$company->name->FldIsDetailKey) {

			$company->name->setFormValue($objForm->GetValue("x_name"));

		}

		if (!$company->address->FldIsDetailKey) {

			$company->address->setFormValue($objForm->GetValue("x_address"));

		}

		if (!$company->city->FldIsDetailKey) {

			$company->city->setFormValue($objForm->GetValue("x_city"));

		}

		if (!$company->province->FldIsDetailKey) {

			$company->province->setFormValue($objForm->GetValue("x_province"));

		}

		if (!$company->telno->FldIsDetailKey) {

			$company->telno->setFormValue($objForm->GetValue("x_telno"));

		}

		if (!$company->mobileno->FldIsDetailKey) {

			$company->mobileno->setFormValue($objForm->GetValue("x_mobileno"));

		}

		if (!$company->faxno->FldIsDetailKey) {

			$company->faxno->setFormValue($objForm->GetValue("x_faxno"));

		}

		if (!$company->zemail->FldIsDetailKey) {

			$company->zemail->setFormValue($objForm->GetValue("x_zemail"));

		}

		if (!$company->contact->FldIsDetailKey) {

			$company->contact->setFormValue($objForm->GetValue("x_contact"));

		}

	}



	// Restore form values

	function RestoreFormValues() {

		global $objForm, $company;

		$this->LoadOldRecord();

		$company->name->CurrentValue = $company->name->FormValue;

		$company->address->CurrentValue = $company->address->FormValue;

		$company->city->CurrentValue = $company->city->FormValue;

		$company->province->CurrentValue = $company->province->FormValue;

		$company->telno->CurrentValue = $company->telno->FormValue;

		$company->mobileno->CurrentValue = $company->mobileno->FormValue;

		$company->faxno->CurrentValue = $company->faxno->FormValue;

		$company->zemail->CurrentValue = $company->zemail->FormValue;

		$company->contact->CurrentValue = $company->contact->FormValue;

	}



	// Load row based on key values

	function LoadRow() {

		global $conn, $Security, $company;

		$sFilter = $company->KeyFilter();



		// Call Row Selecting event

		$company->Row_Selecting($sFilter);



		// Load SQL based on filter

		$company->CurrentFilter = $sFilter;

		$sSql = $company->SQL();

		$res = FALSE;

		$rs = ew_LoadRecordset($sSql);

		if ($rs && !$rs->EOF) {

			$res = TRUE;

			$this->LoadRowValues($rs); // Load row values

			$rs->Close();

		}

		return $res;

	}



	// Load row values from recordset

	function LoadRowValues(&$rs) {

		global $conn, $company;

		if (!$rs || $rs->EOF) return;



		// Call Row Selected event

		$row =& $rs->fields;

		$company->Row_Selected($row);

		$company->id->setDbValue($rs->fields('id'));

		$company->name->setDbValue($rs->fields('name'));

		$company->address->setDbValue($rs->fields('address'));

		$company->city->setDbValue($rs->fields('city'));

		$company->province->setDbValue($rs->fields('province'));

		$company->telno->setDbValue($rs->fields('telno'));

		$company->mobileno->setDbValue($rs->fields('mobileno'));

		$company->faxno->setDbValue($rs->fields('faxno'));

		$company->zemail->setDbValue($rs->fields('email'));

		$company->contact->setDbValue($rs->fields('contact'));

		$company->zuserid->setDbValue($rs->fields('userid'));

		$company->timestamp->setDbValue($rs->fields('timestamp'));

	}



	// Load old record

	function LoadOldRecord() {

		global $company;



		// Load key values from Session

		$bValidKey = TRUE;

		if (strval($company->getKey("id")) <> "")

			$company->id->CurrentValue = $company->getKey("id"); // id

		else

			$bValidKey = FALSE;



		// Load old recordset

		if ($bValidKey) {

			$company->CurrentFilter = $company->KeyFilter();

			$sSql = $company->SQL();

			$this->OldRecordset = ew_LoadRecordset($sSql);

			$this->LoadRowValues($this->OldRecordset); // Load row values

		} else {

			$this->OldRecordset = NULL;

		}

		return $bValidKey;

	}



	// Render row values based on field settings

	function RenderRow() {

		global $conn, $Security, $Language, $company;



		// Initialize URLs

		// Call Row_Rendering event



		$company->Row_Rendering();



		// Common render codes for all row types

		// id

		// name

		// address

		// city

		// province

		// telno

		// mobileno

		// faxno

		// email

		// contact

		// userid

		// timestamp



		if ($company->RowType == EW_ROWTYPE_VIEW) { // View row



			// id

			$company->id->ViewValue = $company->id->CurrentValue;

			$company->id->ViewCustomAttributes = "";



			// name

			$company->name->ViewValue = $company->name->CurrentValue;

			$company->name->ViewCustomAttributes = "";



			// address

			$company->address->ViewValue = $company->address->CurrentValue;

			$company->address->ViewCustomAttributes = "";



			// city

			if (strval($company->city->CurrentValue) <> "") {

				$sFilterWrk = "`id` = " . ew_AdjustSql($company->city->CurrentValue) . "";

			$sSqlWrk = "SELECT `city` FROM `city`";

			$sWhereWrk = "";

			if ($sFilterWrk <> "") {

				if ($sWhereWrk <> "") $sWhereWrk .= " AND ";

				$sWhereWrk .= "(" . $sFilterWrk . ")";

			}

			if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk;

				$rswrk = $conn->Execute($sSqlWrk);

				if ($rswrk && !$rswrk->EOF) { // Lookup values found

					$company->city->ViewValue = $rswrk->fields('city');

					$rswrk->Close();

				} else {

					$company->city->ViewValue = $company->city->CurrentValue;

				}

			} else {

				$company->city->ViewValue = NULL;

			}

			$company->city->ViewCustomAttributes = "";



			// province

			if (strval($company->province->CurrentValue) <> "") {

				$sFilterWrk = "`id` = " . ew_AdjustSql($company->province->CurrentValue) . "";

			$sSqlWrk = "SELECT `province` FROM `province`";

			$sWhereWrk = "";

			if ($sFilterWrk <> "") {

				if ($sWhereWrk <> "") $sWhereWrk .= " AND ";

				$sWhereWrk .= "(" . $sFilterWrk . ")";

			}

			if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk;

				$rswrk = $conn->Execute($sSqlWrk);

				if ($rswrk && !$rswrk->EOF) { // Lookup values found

					$company->province->ViewValue = $rswrk->fields('province');

					$rswrk->Close();

				} else {

					$company->province->ViewValue = $company->province->CurrentValue;

				}

			} else {

				$company->province->ViewValue = NULL;

			}

			$company->province->ViewCustomAttributes = "";



			// telno

			$company->telno->ViewValue = $company->telno->CurrentValue;

			$company->telno->ViewCustomAttributes = "";



			// mobileno

			$company->mobileno->ViewValue = $company->mobileno->CurrentValue;

			$company->mobileno->ViewCustomAttributes = "";



			// faxno

			$company->faxno->ViewValue = $company->faxno->CurrentValue;

			$company->faxno->ViewCustomAttributes = "";



			// email

			$company->zemail->ViewValue = $company->zemail->CurrentValue;

			$company->zemail->ViewCustomAttributes = "";



			// contact

			$company->contact->ViewValue = $company->contact->CurrentValue;

			$company->contact->ViewCustomAttributes = "";



			// userid

			$company->zuserid->ViewValue = $company->zuserid->CurrentValue;

			$company->zuserid->ViewCustomAttributes = "";



			// timestamp

			$company->timestamp->ViewValue = $company->timestamp->CurrentValue;

			$company->timestamp->ViewValue = ew_FormatDateTime($company->timestamp->ViewValue, 9);

			$company->timestamp->ViewCustomAttributes = "";



			// name

			$company->name->LinkCustomAttributes = "";

			$company->name->HrefValue = "";

			$company->name->TooltipValue = "";



			// address

			$company->address->LinkCustomAttributes = "";

			$company->address->HrefValue = "";

			$company->address->TooltipValue = "";



			// city

			$company->city->LinkCustomAttributes = "";

			$company->city->HrefValue = "";

			$company->city->TooltipValue = "";



			// province

			$company->province->LinkCustomAttributes = "";

			$company->province->HrefValue = "";

			$company->province->TooltipValue = "";



			// telno

			$company->telno->LinkCustomAttributes = "";

			$company->telno->HrefValue = "";

			$company->telno->TooltipValue = "";



			// mobileno

			$company->mobileno->LinkCustomAttributes = "";

			$company->mobileno->HrefValue = "";

			$company->mobileno->TooltipValue = "";



			// faxno

			$company->faxno->LinkCustomAttributes = "";

			$company->faxno->HrefValue = "";

			$company->faxno->TooltipValue = "";



			// email

			$company->zemail->LinkCustomAttributes = "";

			$company->zemail->HrefValue = "";

			$company->zemail->TooltipValue = "";



			// contact

			$company->contact->LinkCustomAttributes = "";

			$company->contact->HrefValue = "";

			$company->contact->TooltipValue = "";

		} elseif ($company->RowType == EW_ROWTYPE_ADD) { // Add row



			// name

			$company->name->EditCustomAttributes = "";

			$company->name->EditValue = ew_HtmlEncode($company->name->CurrentValue);



			// address

			$company->address->EditCustomAttributes = "";

			$company->address->EditValue = ew_HtmlEncode($company->address->CurrentValue);



			// city

			$company->city->EditCustomAttributes = "";

				$sFilterWrk = "";

			$sSqlWrk = "SELECT `id`, `city` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld` FROM `city`";

			$sWhereWrk = "";

			if ($sFilterWrk <> "") {

				if ($sWhereWrk <> "") $sWhereWrk .= " AND ";

				$sWhereWrk .= "(" . $sFilterWrk . ")";

			}

			if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk;

			$rswrk = $conn->Execute($sSqlWrk);

			$arwrk = ($rswrk) ? $rswrk->GetRows() : array();

			if ($rswrk) $rswrk->Close();

			array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect")));

			$company->city->EditValue = $arwrk;



			// province

			$company->province->EditCustomAttributes = "";

				$sFilterWrk = "";

			$sSqlWrk = "SELECT `id`, `province` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld` FROM `province`";

			$sWhereWrk = "";

			if ($sFilterWrk <> "") {

				if ($sWhereWrk <> "") $sWhereWrk .= " AND ";

				$sWhereWrk .= "(" . $sFilterWrk . ")";

			}

			if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk;

			$rswrk = $conn->Execute($sSqlWrk);

			$arwrk = ($rswrk) ? $rswrk->GetRows() : array();

			if ($rswrk) $rswrk->Close();

			array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect")));

			$company->province->EditValue = $arwrk;



			// telno

			$company->telno->EditCustomAttributes = "";

			$company->telno->EditValue = ew_HtmlEncode($company->telno->CurrentValue);



			// mobileno

			$company->mobileno->EditCustomAttributes = "";

			$company->mobileno->EditValue = ew_HtmlEncode($company->mobileno->CurrentValue);



			// faxno

			$company->faxno->EditCustomAttributes = "";

			$company->faxno->EditValue = ew_HtmlEncode($company->faxno->CurrentValue);



			// email

			$company->zemail->EditCustomAttributes = "";

			$company->zemail->EditValue = ew_HtmlEncode($company->zemail->CurrentValue);



			// contact

			$company->contact->EditCustomAttributes = "";

			$company->contact->EditValue = ew_HtmlEncode($company->contact->CurrentValue);



			// Edit refer script

			// name



			$company->name->HrefValue = "";



			// address

			$company->address->HrefValue = "";



			// city

			$company->city->HrefValue = "";



			// province

			$company->province->HrefValue = "";



			// telno

			$company->telno->HrefValue = "";



			// mobileno

			$company->mobileno->HrefValue = "";



			// faxno

			$company->faxno->HrefValue = "";



			// email

			$company->zemail->HrefValue = "";



			// contact

			$company->contact->HrefValue = "";

		}

		if ($company->RowType == EW_ROWTYPE_ADD ||

			$company->RowType == EW_ROWTYPE_EDIT ||

			$company->RowType == EW_ROWTYPE_SEARCH) { // Add / Edit / Search row

			$company->SetupFieldTitles();

		}



		// Call Row Rendered event

		if ($company->RowType <> EW_ROWTYPE_AGGREGATEINIT)

			$company->Row_Rendered();

	}



	// Validate form

	function ValidateForm() {

		global $Language, $gsFormError, $company;



		// Initialize form error message

		$gsFormError = "";



		// Check if validation required

		if (!EW_SERVER_VALIDATE)

			return ($gsFormError == "");

		if (!is_null($company->name->FormValue) && $company->name->FormValue == "") {

			ew_AddMessage($gsFormError, $Language->Phrase("EnterRequiredField") . " - " . $company->name->FldCaption());

		}

		if (!is_null($company->address->FormValue) && $company->address->FormValue == "") {

			ew_AddMessage($gsFormError, $Language->Phrase("EnterRequiredField") . " - " . $company->address->FldCaption());

		}

		if (!is_null($company->city->FormValue) && $company->city->FormValue == "") {

			ew_AddMessage($gsFormError, $Language->Phrase("EnterRequiredField") . " - " . $company->city->FldCaption());

		}

		if (!is_null($company->province->FormValue) && $company->province->FormValue == "") {

			ew_AddMessage($gsFormError, $Language->Phrase("EnterRequiredField") . " - " . $company->province->FldCaption());

		}

		if (!is_null($company->telno->FormValue) && $company->telno->FormValue == "") {

			ew_AddMessage($gsFormError, $Language->Phrase("EnterRequiredField") . " - " . $company->telno->FldCaption());

		}

		if (!is_null($company->mobileno->FormValue) && $company->mobileno->FormValue == "") {

			ew_AddMessage($gsFormError, $Language->Phrase("EnterRequiredField") . " - " . $company->mobileno->FldCaption());

		}

		if (!is_null($company->faxno->FormValue) && $company->faxno->FormValue == "") {

			ew_AddMessage($gsFormError, $Language->Phrase("EnterRequiredField") . " - " . $company->faxno->FldCaption());

		}

		if (!is_null($company->zemail->FormValue) && $company->zemail->FormValue == "") {

			ew_AddMessage($gsFormError, $Language->Phrase("EnterRequiredField") . " - " . $company->zemail->FldCaption());

		}

		if (!is_null($company->contact->FormValue) && $company->contact->FormValue == "") {

			ew_AddMessage($gsFormError, $Language->Phrase("EnterRequiredField") . " - " . $company->contact->FldCaption());

		}



		// Return validate result

		$ValidateForm = ($gsFormError == "");



		// Call Form_CustomValidate event

		$sFormCustomError = "";

		$ValidateForm = $ValidateForm && $this->Form_CustomValidate($sFormCustomError);

		if ($sFormCustomError <> "") {

			ew_AddMessage($gsFormError, $sFormCustomError);

		}

		return $ValidateForm;

	}



	// Add record

	function AddRow($rsold = NULL) {

		global $conn, $Language, $Security, $company;

		$rsnew = array();



		// name

		$company->name->SetDbValueDef($rsnew, $company->name->CurrentValue, "", FALSE);



		// address

		$company->address->SetDbValueDef($rsnew, $company->address->CurrentValue, "", FALSE);



		// city

		$company->city->SetDbValueDef($rsnew, $company->city->CurrentValue, 0, FALSE);



		// province

		$company->province->SetDbValueDef($rsnew, $company->province->CurrentValue, 0, FALSE);



		// telno

		$company->telno->SetDbValueDef($rsnew, $company->telno->CurrentValue, "", FALSE);



		// mobileno

		$company->mobileno->SetDbValueDef($rsnew, $company->mobileno->CurrentValue, "", FALSE);



		// faxno

		$company->faxno->SetDbValueDef($rsnew, $company->faxno->CurrentValue, "", FALSE);



		// email

		$company->zemail->SetDbValueDef($rsnew, $company->zemail->CurrentValue, "", FALSE);



		// contact

		$company->contact->SetDbValueDef($rsnew, $company->contact->CurrentValue, "", FALSE);



		// Call Row Inserting event

		$rs = ($rsold == NULL) ? NULL : $rsold->fields;

		$bInsertRow = $company->Row_Inserting($rs, $rsnew);

		if ($bInsertRow) {

			$conn->raiseErrorFn = 'ew_ErrorFn';

			$AddRow = $conn->Execute($company->InsertSQL($rsnew));

			$conn->raiseErrorFn = '';

		} else {

			if ($company->CancelMessage <> "") {

				$this->setFailureMessage($company->CancelMessage);

				$company->CancelMessage = "";

			} else {

				$this->setFailureMessage($Language->Phrase("InsertCancelled"));

			}

			$AddRow = FALSE;

		}



		// Get insert id if necessary

		if ($AddRow) {

			$company->id->setDbValue($conn->Insert_ID());

			$rsnew['id'] = $company->id->DbValue;

		}

		if ($AddRow) {



			// Call Row Inserted event

			$rs = ($rsold == NULL) ? NULL : $rsold->fields;

			$company->Row_Inserted($rs, $rsnew);

			$this->WriteAuditTrailOnAdd($rsnew);

		}

		return $AddRow;

	}

// Write Audit Trail start/end for grid update

	function WriteAuditTrailDummy($typ) {

		$table = 'company';

	  $usr = CurrentUserName();

		ew_WriteAuditTrail("log", ew_StdCurrentDateTime(), ew_ScriptName(), $usr, $typ, $table, "", "", "", "");

	}



	// Write Audit Trail (add page)

	function WriteAuditTrailOnAdd(&$rs) {

		global $company;

		$table = 'company';



		// Get key value

		$key = "";

		if ($key <> "") $key .= EW_COMPOSITE_KEY_SEPARATOR;

		$key .= $rs['id'];



		// Write Audit Trail

		$dt = ew_StdCurrentDateTime();

		$id = ew_ScriptName();

	  $usr = CurrentUserName();

		foreach (array_keys($rs) as $fldname) {

			if ($company->fields[$fldname]->FldDataType <> EW_DATATYPE_BLOB) { // Ignore BLOB fields

				if ($company->fields[$fldname]->FldDataType == EW_DATATYPE_MEMO) {

					if (EW_AUDIT_TRAIL_TO_DATABASE)

						$newvalue = $rs[$fldname];

					else

						$newvalue = "[MEMO]"; // Memo Field

				} elseif ($company->fields[$fldname]->FldDataType == EW_DATATYPE_XML) {

					$newvalue = "[XML]"; // XML Field

				} else {

					$newvalue = $rs[$fldname];

				}

				ew_WriteAuditTrail("log", $dt, $id, $usr, "A", $table, $fldname, $key, "", $newvalue);

			}

		}

	}



	// Page Load event

	function Page_Load() {



		//echo "Page Load";

	}



	// Page Unload event

	function Page_Unload() {



		//echo "Page Unload";

	}



	// Page Redirecting event

	function Page_Redirecting(&$url) {



		// Example:

		//$url = "your URL";



	}



	// Message Showing event

	// $type = ''|'success'|'failure'

	function Message_Showing(&$msg, $type) {



		// Example:

		//if ($type == 'success') $msg = "your success message";



	}



	// Page Data Rendering event

	function Page_DataRendering(&$header) {



		// Example:

		//$header = "your header";



	}



	// Page Data Rendered event

	function Page_DataRendered(&$footer) {



		// Example:

		//$footer = "your footer";



	}



	// Form Custom Validate event

	function Form_CustomValidate(&$CustomError) {



		// Return error message in CustomError

		return TRUE;

	}

}

?>