/provinceedit.php
PHP | 1159 lines | 778 code | 162 blank | 219 comment | 170 complexity | 3bf7b85f401c61bc7c1f46b452b2c6a3 MD5 | raw file
Possible License(s): LGPL-2.1
- <?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_edit = new cprovince_edit();
- $Page =& $province_edit;
-
- // Page init
- $province_edit->Page_Init();
-
- // Page main
- $province_edit->Page_Main();
- ?>
- <?php include_once "header.php" ?>
- <script type="text/javascript">
- <!--
-
- // Create page object
- var province_edit = new ew_Page("province_edit");
-
- // page properties
- province_edit.PageID = "edit"; // page ID
- province_edit.FormID = "fprovinceedit"; // form ID
- var EW_PAGE_ID = province_edit.PageID; // for backward compatibility
-
- // extend page with ValidateForm function
- province_edit.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 + "_id"];
- if (elm && !ew_CheckInteger(elm.value))
- return ew_OnError(this, elm, "<?php echo ew_JsEncode2($province->id->FldErrMsg()) ?>");
- 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_edit.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_edit.ValidateRequired = true; // uses JavaScript validation
- <?php } else { ?>
- province_edit.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("Edit") ?> <?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_edit->ShowPageHeader(); ?>
- <?php
- $province_edit->ShowMessage();
- ?>
- <form name="fprovinceedit" id="fprovinceedit" action="<?php echo ew_CurrentPage() ?>" method="post" onsubmit="return province_edit.ValidateForm(this);">
- <p>
- <input type="hidden" name="a_table" id="a_table" value="province">
- <input type="hidden" name="a_edit" id="a_edit" value="U">
- <table cellspacing="0" class="ewGrid"><tr><td class="ewGridContent">
- <div class="ewGridMiddlePanel">
- <table cellspacing="0" class="ewTable">
- <?php if ($province->id->Visible) { // id ?>
- <tr id="r_id"<?php echo $province->RowAttributes() ?>>
- <td class="ewTableHeader"><?php echo $province->id->FldCaption() ?></td>
- <td<?php echo $province->id->CellAttributes() ?>><span id="el_id">
- <div<?php echo $province->id->ViewAttributes() ?>><?php echo $province->id->EditValue ?></div>
- <input type="hidden" name="x_id" id="x_id" value="<?php echo ew_HtmlEncode($province->id->CurrentValue) ?>">
- </span><?php echo $province->id->CustomMsg ?></td>
- </tr>
- <?php } ?>
- <?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() ?><!-- Removed Required Field Indicator--></td>
- <td<?php echo $province->provcontact->CellAttributes() ?>><span id="el_provcontact">
- <input type="text" name="x_provcontact" id="x_provcontact" size="30" maxlength="60" 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() ?><!-- Removed Required Field Indicator--></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() ?><!-- Removed Required Field Indicator--></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() ?><!-- Removed Required Field Indicator--></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() ?><!-- Removed Required Field Indicator--></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() ?><!-- Removed Required Field Indicator--></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() ?><!-- Removed Required Field Indicator--></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("EditBtn")) ?>">
- </form>
- <?php
- $province_edit->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_edit->Page_Terminate();
- ?>
- <?php
-
- //
- // Page class
- //
- class cprovince_edit {
-
- // Page ID
- var $PageID = 'edit';
-
- // Table name
- var $TableName = 'province';
-
- // Page object name
- var $PageObjName = 'province_edit';
-
- // 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_edit() {
- 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", 'edit', 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->CanEdit()) {
- $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;
-
- //
- // Page main
- //
- function Page_Main() {
- global $objForm, $Language, $gsFormError, $province;
-
- // Load key from QueryString
- if (@$_GET["id"] <> "")
- $province->id->setQueryStringValue($_GET["id"]);
- if (@$_POST["a_edit"] <> "") {
- $province->CurrentAction = $_POST["a_edit"]; // Get action code
- $this->LoadFormValues(); // Get form values
-
- // Validate form
- if (!$this->ValidateForm()) {
- $province->CurrentAction = ""; // Form error, reset action
- $this->setFailureMessage($gsFormError);
- $province->EventCancelled = TRUE; // Event cancelled
- $this->RestoreFormValues();
- }
- } else {
- $province->CurrentAction = "I"; // Default action is display
- }
-
- // Check if valid key
- if ($province->id->CurrentValue == "")
- $this->Page_Terminate("provincelist.php"); // Invalid key, return to list
- switch ($province->CurrentAction) {
- case "I": // Get a record to display
- 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 "U": // Update
- $province->SendEmail = TRUE; // Send email on update success
- if ($this->EditRow()) { // Update record based on key
- $this->setSuccessMessage($Language->Phrase("UpdateSuccess")); // Update success
- $sReturnUrl = $province->getReturnUrl();
- if (ew_GetPageName($sReturnUrl) == "provinceview.php")
- $sReturnUrl = $province->ViewUrl(); // View paging, return to View page directly
- $this->Page_Terminate($sReturnUrl); // Return to caller
- } else {
- $province->EventCancelled = TRUE; // Event cancelled
- $this->RestoreFormValues(); // Restore form values if update failed
- }
- }
-
- // Render the record
- $province->RowType = EW_ROWTYPE_EDIT; // Render as Edit
- $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 form values
- function LoadFormValues() {
-
- // Load from form
- global $objForm, $province;
- if (!$province->id->FldIsDetailKey)
- $province->id->setFormValue($objForm->GetValue("x_id"));
- 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->zuserid->FldIsDetailKey) {
- $province->zuserid->setFormValue($objForm->GetValue("x_zuserid"));
- }
- if (!$province->timestamp->FldIsDetailKey) {
- $province->timestamp->setFormValue($objForm->GetValue("x_timestamp"));
- $province->timestamp->CurrentValue = ew_UnFormatDateTime($province->timestamp->CurrentValue, 5);
- }
- if (!$province->provincecode->FldIsDetailKey) {
- $province->provincecode->setFormValue($objForm->GetValue("x_provincecode"));
- }
- }
-
- // Restore form values
- function RestoreFormValues() {
- global $objForm, $province;
- $this->LoadRow();
- $province->id->CurrentValue = $province->id->FormValue;
- $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->zuserid->CurrentValue = $province->zuserid->FormValue;
- $province->timestamp->CurrentValue = $province->timestamp->FormValue;
- $province->timestamp->CurrentValue = ew_UnFormatDateTime($province->timestamp->CurrentValue, 5);
- $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'));
- }
-
- // 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 = "";
-
- // id
- $province->id->LinkCustomAttributes = "";
- $province->id->HrefValue = "";
- $province->id->TooltipValue = "";
-
- // 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 = "";
-
- // userid
- $province->zuserid->LinkCustomAttributes = "";
- $province->zuserid->HrefValue = "";
- $province->zuserid->TooltipValue = "";
-
- // timestamp
- $province->timestamp->LinkCustomAttributes = "";
- $province->timestamp->HrefValue = "";
- $province->timestamp->TooltipValue = "";
-
- // provincecode
- $province->provincecode->LinkCustomAttributes = "";
- $province->provincecode->HrefValue = "";
- $province->provincecode->TooltipValue = "";
- } elseif ($province->RowType == EW_ROWTYPE_EDIT) { // Edit row
-
- // id
- $province->id->EditCustomAttributes = "";
- $province->id->EditValue = $province->id->CurrentValue;
- $province->id->ViewCustomAttributes = "";
-
- // 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;
-
- // userid
- // timestamp
- // provincecode
-
- $province->provincecode->EditCustomAttributes = "";
- $province->provincecode->EditValue = ew_HtmlEncode($province->provincecode->CurrentValue);
-
- // Edit refer script
- // id
-
- $province->id->HrefValue = "";
-
- // 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 = "";
-
- // userid
- $province->zuserid->HrefValue = "";
-
- // timestamp
- $province->timestamp->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 (!ew_CheckInteger($province->id->FormValue)) {
- ew_AddMessage($gsFormError, $province->id->FldErrMsg());
- }
- 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;
- }
-
- // Update record based on key values
- function EditRow() {
- global $conn, $Security, $Language, $province;
- $sFilter = $province->KeyFilter();
- $province->CurrentFilter = $sFilter;
- $sSql = $province->SQL();
- $conn->raiseErrorFn = 'ew_ErrorFn';
- $rs = $conn->Execute($sSql);
- $conn->raiseErrorFn = '';
- if ($rs === FALSE)
- return FALSE;
- if ($rs->EOF) {
- $EditRow = FALSE; // Update Failed
- } else {
-
- // Save old values
- $rsold =& $rs->fields;
- $rsnew = array();
-
- // province
- $province->province_1->SetDbValueDef($rsnew, $province->province_1->CurrentValue, "", $province->province_1->ReadOnly);
-
- // provcontact
- $province->provcontact->SetDbValueDef($rsnew, $province->provcontact->CurrentValue, "", $province->provcontact->ReadOnly);
-
- // provhalladdress
- $province->provhalladdress->SetDbValueDef($rsnew, $province->provhalladdress->CurrentValue, "", $province->provhalladdress->ReadOnly);
-
- // provtelno
- $province->provtelno->SetDbValueDef($rsnew, $province->provtelno->CurrentValue, "", $province->provtelno->ReadOnly);
-
- // provlatitude
- $province->provlatitude->SetDbValueDef($rsnew, $province->provlatitude->CurrentValue, 0, $province->provlatitude->ReadOnly);
-
- // provlongitude
- $province->provlongitude->SetDbValueDef($rsnew, $province->provlongitude->CurrentValue, 0, $province->provlongitude->ReadOnly);
-
- // provaltitude
- $province->provaltitude->SetDbValueDef($rsnew, $province->provaltitude->CurrentValue, 0, $province->provaltitude->ReadOnly);
-
- // countryid
- $province->countryid->SetDbValueDef($rsnew, $province->countryid->CurrentValue, 0, $province->countryid->ReadOnly);
-
- // userid
- $province->zuserid->SetDbValueDef($rsnew, CurrentUserID(), 0);
- $rsnew['userid'] =& $province->zuserid->DbValue;
-
- // timestamp
- $province->timestamp->SetDbValueDef($rsnew, ew_CurrentDateTime(), ew_CurrentDate());
- $rsnew['timestamp'] =& $province->timestamp->DbValue;
-
- // provincecode
- $province->provincecode->SetDbValueDef($rsnew, $province->provincecode->CurrentValue, 0, $province->provincecode->ReadOnly);
-
- // Call Row Updating event
- $bUpdateRow = $province->Row_Updating($rsold, $rsnew);
- if ($bUpdateRow) {
- $conn->raiseErrorFn = 'ew_ErrorFn';
- if (count($rsnew) > 0)
- $EditRow = $conn->Execute($province->UpdateSQL($rsnew));
- else
- $EditRow = TRUE; // No field to update
- $conn->raiseErrorFn = '';
- } else {
- if ($province->CancelMessage <> "") {
- $this->setFailureMessage($province->CancelMessage);
- $province->CancelMessage = "";
- } else {
- $this->setFailureMessage($Language->Phrase("UpdateCancelled"));
- }
- $EditRow = FALSE;
- }
- }
-
- // Call Row_Updated event
- if ($EditRow)
- $province->Row_Updated($rsold, $rsnew);
- if ($EditRow) {
- $this->WriteAuditTrailOnEdit($rsold, $rsnew);
- }
- $rs->Close();
- return $EditRow;
- }
- // 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 (edit page)
- function WriteAuditTrailOnEdit(&$rsold, &$rsnew) {
- global $province;
- $table = 'province';
-
- // Get key value
- $key = "";
- if ($key <> "") $key .= EW_COMPOSITE_KEY_SEPARATOR;
- $key .= $rsold['id'];
-
- // Write Audit Trail
- $dt = ew_StdCurrentDateTime();
- $id = ew_ScriptName();
- $usr = CurrentUserName();
- foreach (array_keys($rsnew) as $fldname) {
- if ($province->fields[$fldname]->FldDataType <> EW_DATATYPE_BLOB) { // Ignore BLOB fields
- if ($province->fields[$fldname]->FldDataType == EW_DATATYPE_DATE) { // DateTime field
- $modified = (ew_FormatDateTime($rsold[$fldname], 0) <> ew_FormatDateTime($rsnew[$fldname], 0));
- } else {
- $modified = !ew_CompareValue($rsold[$fldname], $rsnew[$fldname]);
- }
- if ($modified) {
- if ($province->fields[$fldname]->FldDataType == EW_DATATYPE_MEMO) { // Memo field
- if (EW_AUDIT_TRAIL_TO_DATABASE) {
- $oldvalue = $rsold[$fldname];
- $newvalue = $rsnew[$fldname];
- } else {
- $oldvalue = "[MEMO]";
- $newvalue = "[MEMO]";
- }
- } elseif ($province->fields[$fldname]->FldDataType == EW_DATATYPE_XML) { // XML field
- $oldvalue = "[XML]";
- $newvalue = "[XML]";
- } else {
- $oldvalue = $rsold[$fldname];
- $newvalue = $rsnew[$fldname];
- }
- ew_WriteAuditTrail("log", $dt, $id, $usr, "U", $table, $fldname, $key, $oldvalue, $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;
- }
- }
- ?>