/provinceadd.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 "provinceinfo.php" ?>

<?php include_once "userinfo.php" ?>

<?php include_once "userfn8.php" ?>

<?php ew_Header(FALSE) ?>

<?php



// Create page object

$province_add = new cprovince_add();

$Page =& $province_add;



// Page init

$province_add->Page_Init();



// Page main

$province_add->Page_Main();

?>

<?php include_once "header.php" ?>

<script type="text/javascript">

<!--



// Create page object

var province_add = new ew_Page("province_add");



// page properties

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

province_add.FormID = "fprovinceadd"; // form ID

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



// extend page with ValidateForm function

province_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 + "_province_1"];

		if (elm && !ew_HasValue(elm))

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

		/*

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

		if (elm && !ew_HasValue(elm))

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

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

		if (elm && !ew_HasValue(elm))

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

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

		if (elm && !ew_HasValue(elm))

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

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

		if (elm && !ew_HasValue(elm))

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

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

		if (elm && !ew_CheckNumber(elm.value))

			return ew_OnError(this, elm, "<?php echo ew_JsEncode2($province->provlatitude->FldErrMsg()) ?>");

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

		if (elm && !ew_HasValue(elm))

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

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

		if (elm && !ew_CheckNumber(elm.value))

			return ew_OnError(this, elm, "<?php echo ew_JsEncode2($province->provlongitude->FldErrMsg()) ?>");

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

		if (elm && !ew_HasValue(elm))

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

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

		if (elm && !ew_CheckNumber(elm.value))

			return ew_OnError(this, elm, "<?php echo ew_JsEncode2($province->provaltitude->FldErrMsg()) ?>");

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

		if (elm && !ew_HasValue(elm))

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

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

		if (elm && !ew_HasValue(elm))

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

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

		if (elm && !ew_CheckInteger(elm.value))

			return ew_OnError(this, elm, "<?php echo ew_JsEncode2($province->provincecode->FldErrMsg()) ?>");

		*/

		// 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

province_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) { ?>

province_add.ValidateRequired = true; // uses JavaScript validation

<?php } else { ?>

province_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 $province->TableCaption() ?></p>

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

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

<?php

$province_add->ShowMessage();

?>

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

<p>

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

<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 ($province->province_1->Visible) { // province ?>

	<tr id="r_province_1"<?php echo $province->RowAttributes() ?>>

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

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

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

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

	</tr>

<?php } ?>

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

	<tr id="r_provcontact"<?php echo $province->RowAttributes() ?>>

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

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

<input type="text" name="x_provcontact" id="x_provcontact" size="30" maxlength="20" value="<?php echo $province->provcontact->EditValue ?>"<?php echo $province->provcontact->EditAttributes() ?>>

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

	</tr>

<?php } ?>

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

	<tr id="r_provhalladdress"<?php echo $province->RowAttributes() ?>>

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

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

<textarea name="x_provhalladdress" id="x_provhalladdress" cols="35" rows="4"<?php echo $province->provhalladdress->EditAttributes() ?>><?php echo $province->provhalladdress->EditValue ?></textarea>

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

	</tr>

<?php } ?>

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

	<tr id="r_provtelno"<?php echo $province->RowAttributes() ?>>

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

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

<input type="text" name="x_provtelno" id="x_provtelno" size="30" maxlength="20" value="<?php echo $province->provtelno->EditValue ?>"<?php echo $province->provtelno->EditAttributes() ?>>

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

	</tr>

<?php } ?>

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

	<tr id="r_provlatitude"<?php echo $province->RowAttributes() ?>>

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

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

<input type="text" name="x_provlatitude" id="x_provlatitude" size="30" value="<?php echo $province->provlatitude->EditValue ?>"<?php echo $province->provlatitude->EditAttributes() ?>>

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

	</tr>

<?php } ?>

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

	<tr id="r_provlongitude"<?php echo $province->RowAttributes() ?>>

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

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

<input type="text" name="x_provlongitude" id="x_provlongitude" size="30" value="<?php echo $province->provlongitude->EditValue ?>"<?php echo $province->provlongitude->EditAttributes() ?>>

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

	</tr>

<?php } ?>

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

	<tr id="r_provaltitude"<?php echo $province->RowAttributes() ?>>

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

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

<input type="text" name="x_provaltitude" id="x_provaltitude" size="30" value="<?php echo $province->provaltitude->EditValue ?>"<?php echo $province->provaltitude->EditAttributes() ?>>

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

	</tr>

<?php } ?>

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

	<tr id="r_countryid"<?php echo $province->RowAttributes() ?>>

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

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

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

<?php

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

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

	$rowswrk = count($arwrk);

	$emptywrk = TRUE;

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

		$selwrk = (strval($province->countryid->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 $province->countryid->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

$province_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

$province_add->Page_Terminate();

?>

<?php



//

// Page class

//

class cprovince_add {



	// Page ID

	var $PageID = 'add';



	// Table name

	var $TableName = 'province';



	// Page object name

	var $PageObjName = 'province_add';



	// Page name

	function PageName() {

		return ew_CurrentPage();

	}



	// Page URL

	function PageUrl() {

		$PageUrl = ew_CurrentPage() . "?";

		global $province;

		if ($province->UseTokenInUrl) $PageUrl .= "t=" . $province->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, $province;

		if ($province->UseTokenInUrl) {

			if ($objForm)

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

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

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

		} else {

			return TRUE;

		}

	}



	//

	// Page class constructor

	//

	function cprovince_add() {

		global $conn, $Language;



		// Language object

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



		// Table object (province)

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

			$GLOBALS["province"] = new cprovince();

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

		}



		// 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", 'province', 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 $province;



		// 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("provincelist.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, $province;



		// Process form if post back

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

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

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

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



			// Validate form

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

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

				$province->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"] != "") {

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

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

			} else {

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

				$this->CopyRecord = FALSE;

			}

			if ($this->CopyRecord) {

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

			} else {

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

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

			}

		}



		// Perform action based on action code

		switch ($province->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("provincelist.php"); // No matching record, return to list

				}

				break;

			case "A": // ' Add new record

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

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

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

					$sReturnUrl = $province->getReturnUrl();

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

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

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

				} else {

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

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

				}

		}



		// Render row based on row type

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



		// Render row

		$province->ResetAttrs();

		$this->RenderRow();

	}



	// Get upload files

	function GetUploadFiles() {

		global $objForm, $province;



		// 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 $province;

		$province->province_1->CurrentValue = NULL;

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

		$province->provcontact->CurrentValue = NULL;

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

		$province->provhalladdress->CurrentValue = NULL;

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

		$province->provtelno->CurrentValue = NULL;

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

		$province->provlatitude->CurrentValue = NULL;

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

		$province->provlongitude->CurrentValue = NULL;

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

		$province->provaltitude->CurrentValue = NULL;

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

		$province->countryid->CurrentValue = NULL;

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

		$province->provincecode->CurrentValue = NULL;

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

	}



	// Load form values

	function LoadFormValues() {



		// Load from form

		global $objForm, $province;

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

			$province->province_1->setFormValue($objForm->GetValue("x_province_1"));

		}

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

			$province->provcontact->setFormValue($objForm->GetValue("x_provcontact"));

		}

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

			$province->provhalladdress->setFormValue($objForm->GetValue("x_provhalladdress"));

		}

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

			$province->provtelno->setFormValue($objForm->GetValue("x_provtelno"));

		}

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

			$province->provlatitude->setFormValue($objForm->GetValue("x_provlatitude"));

		}

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

			$province->provlongitude->setFormValue($objForm->GetValue("x_provlongitude"));

		}

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

			$province->provaltitude->setFormValue($objForm->GetValue("x_provaltitude"));

		}

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

			$province->countryid->setFormValue($objForm->GetValue("x_countryid"));

		}

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

			$province->provincecode->setFormValue($objForm->GetValue("x_provincecode"));

		}

	}



	// Restore form values

	function RestoreFormValues() {

		global $objForm, $province;

		$this->LoadOldRecord();

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

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

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

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

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

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

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

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

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

	}



	// Load row based on key values

	function LoadRow() {

		global $conn, $Security, $province;

		$sFilter = $province->KeyFilter();



		// Call Row Selecting event

		$province->Row_Selecting($sFilter);



		// Load SQL based on filter

		$province->CurrentFilter = $sFilter;

		$sSql = $province->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, $province;

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



		// Call Row Selected event

		$row =& $rs->fields;

		$province->Row_Selected($row);

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

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

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

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

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

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

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

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

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

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

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

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

	}



	// Load old record

	function LoadOldRecord() {

		global $province;



		// Load key values from Session

		$bValidKey = TRUE;

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

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

		else

			$bValidKey = FALSE;



		// Load old recordset

		if ($bValidKey) {

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

			$sSql = $province->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, $province;



		// Initialize URLs

		// Call Row_Rendering event



		$province->Row_Rendering();



		// Common render codes for all row types

		// id

		// province

		// provcontact

		// provhalladdress

		// provtelno

		// provlatitude

		// provlongitude

		// provaltitude

		// countryid

		// userid

		// timestamp

		// provincecode



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



			// id

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

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



			// province

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

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



			// provcontact

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

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



			// provhalladdress

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

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



			// provtelno

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

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



			// provlatitude

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

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



			// provlongitude

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

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



			// provaltitude

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

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



			// countryid

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

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

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

			$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

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

					$rswrk->Close();

				} else {

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

				}

			} else {

				$province->countryid->ViewValue = NULL;

			}

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



			// userid

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

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



			// timestamp

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

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

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



			// provincecode

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

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



			// province

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

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

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



			// provcontact

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

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

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



			// provhalladdress

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

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

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



			// provtelno

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

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

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



			// provlatitude

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

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

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



			// provlongitude

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

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

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



			// provaltitude

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

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

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



			// countryid

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

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

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



			// provincecode

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

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

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

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



			// province

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

			$province->province_1->EditValue = ew_HtmlEncode($province->province_1->CurrentValue);



			// provcontact

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

			$province->provcontact->EditValue = ew_HtmlEncode($province->provcontact->CurrentValue);



			// provhalladdress

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

			$province->provhalladdress->EditValue = ew_HtmlEncode($province->provhalladdress->CurrentValue);



			// provtelno

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

			$province->provtelno->EditValue = ew_HtmlEncode($province->provtelno->CurrentValue);



			// provlatitude

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

			$province->provlatitude->EditValue = ew_HtmlEncode($province->provlatitude->CurrentValue);



			// provlongitude

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

			$province->provlongitude->EditValue = ew_HtmlEncode($province->provlongitude->CurrentValue);



			// provaltitude

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

			$province->provaltitude->EditValue = ew_HtmlEncode($province->provaltitude->CurrentValue);



			// countryid

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

				$sFilterWrk = "";

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

			$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")));

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



			// provincecode

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

			$province->provincecode->EditValue = ew_HtmlEncode($province->provincecode->CurrentValue);



			// Edit refer script

			// province



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



			// provcontact

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



			// provhalladdress

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



			// provtelno

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



			// provlatitude

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



			// provlongitude

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



			// provaltitude

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



			// countryid

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



			// provincecode

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

		}

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

			$province->RowType == EW_ROWTYPE_EDIT ||

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

			$province->SetupFieldTitles();

		}



		// Call Row Rendered event

		if ($province->RowType <> EW_ROWTYPE_AGGREGATEINIT)

			$province->Row_Rendered();

	}



	// Validate form

	function ValidateForm() {

		global $Language, $gsFormError, $province;



		// Initialize form error message

		$gsFormError = "";



		// Check if validation required

		if (!EW_SERVER_VALIDATE)

			return ($gsFormError == "");

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

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

		}

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

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

		}

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

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

		}

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

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

		}

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

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

		}

		if (!ew_CheckNumber($province->provlatitude->FormValue)) {

			ew_AddMessage($gsFormError, $province->provlatitude->FldErrMsg());

		}

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

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

		}

		if (!ew_CheckNumber($province->provlongitude->FormValue)) {

			ew_AddMessage($gsFormError, $province->provlongitude->FldErrMsg());

		}

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

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

		}

		if (!ew_CheckNumber($province->provaltitude->FormValue)) {

			ew_AddMessage($gsFormError, $province->provaltitude->FldErrMsg());

		}

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

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

		}

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

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

		}

		if (!ew_CheckInteger($province->provincecode->FormValue)) {

			ew_AddMessage($gsFormError, $province->provincecode->FldErrMsg());

		}



		// 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, $province;

		$rsnew = array();



		// province

		$province->province_1->SetDbValueDef($rsnew, $province->province_1->CurrentValue, "", FALSE);



		// provcontact

		$province->provcontact->SetDbValueDef($rsnew, $province->provcontact->CurrentValue, "", FALSE);



		// provhalladdress

		$province->provhalladdress->SetDbValueDef($rsnew, $province->provhalladdress->CurrentValue, "", FALSE);



		// provtelno

		$province->provtelno->SetDbValueDef($rsnew, $province->provtelno->CurrentValue, "", FALSE);



		// provlatitude

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



		// provlongitude

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



		// provaltitude

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



		// countryid

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



		// provincecode

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



		// Call Row Inserting event

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

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

		if ($bInsertRow) {

			$conn->raiseErrorFn = 'ew_ErrorFn';

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

			$conn->raiseErrorFn = '';

		} else {

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

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

				$province->CancelMessage = "";

			} else {

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

			}

			$AddRow = FALSE;

		}



		// Get insert id if necessary

		if ($AddRow) {

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

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

		}

		if ($AddRow) {



			// Call Row Inserted event

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

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

			$this->WriteAuditTrailOnAdd($rsnew);

		}

		return $AddRow;

	}

// Write Audit Trail start/end for grid update

	function WriteAuditTrailDummy($typ) {

		$table = 'province';

	  $usr = CurrentUserName();

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

	}



	// Write Audit Trail (add page)

	function WriteAuditTrailOnAdd(&$rs) {

		global $province;

		$table = 'province';



		// 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 ($province->fields[$fldname]->FldDataType <> EW_DATATYPE_BLOB) { // Ignore BLOB fields

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

					if (EW_AUDIT_TRAIL_TO_DATABASE)

						$newvalue = $rs[$fldname];

					else

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

				} elseif ($province->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;

	}

}

?>