function Page_Main() { $qs = new cQueryString(); if ($qs->Count > 0) { $Sql = $qs->getValue("s"); $Sql = TEAdecrypt($Sql, EW_RANDOM_KEY); if ($Sql != "") { // Get the filter values (for "IN") $Value = ew_AdjustSql($qs->getConvertedValue("f")); if ($Value != "") { $arValue = explode(",", $Value); $FldType = $qs->getValue("lft"); // Filter field data type if (is_numeric($FldType)) { $FldType = intval($FldType); } $cnt = count($arValue); for ($i = 0; $i < $cnt; $i++) { $arValue[$i] = ew_QuotedValue($arValue[$i], $FldType); } $Sql = str_replace("{filter_value}", implode(",", $arValue), $Sql); } // get the query value (for "LIKE" or "=") $Value = ew_AdjustSql($qs->getConvertedValue("q")); if ($Value != "") { $Sql = str_replace("{query_value}", $Value, $Sql); } $this->GetLookupValues($Sql); } } else { die("Missing querystring."); } }
function Page_Main() { $post = ew_StripSlashes($_POST); if (count($post) == 0) { die("Missing post data."); } //$sql = $qs->getValue("s"); $sql = $post["s"]; $sql = TEAdecrypt($sql, EW_RANDOM_KEY); if ($sql == "") { die("Missing SQL."); } if (strpos($sql, "{filter}") > 0) { $filters = ""; for ($i = 0; $i < 5; $i++) { // Get the filter values (for "IN") $filter = TEAdecrypt($post["f" . $i], EW_RANDOM_KEY); if ($filter != "") { $value = $post["v" . $i]; if ($value == "") { if ($i > 0) { // Empty parent field //continue; // Allow ew_AddFilter($filters, "1=0"); } // Disallow continue; } $arValue = explode(",", $value); $fldtype = intval($post["t" . $i]); for ($j = 0, $cnt = count($arValue); $j < $cnt; $j++) { $arValue[$j] = ew_QuotedValue($arValue[$j], ew_FieldDataType($fldtype)); } $filter = str_replace("{filter_value}", implode(",", $arValue), $filter); ew_AddFilter($filters, $filter); } } $sql = str_replace("{filter}", $filters != "" ? $filters : "1=1", $sql); } // Get the query value (for "LIKE" or "=") $value = ew_AdjustSql(@$post["q"]); if ($value != "") { $sql = preg_replace('/LIKE \'(%)?\\{query_value\\}%\'/', ew_Like('\'$1{query_value}%\''), $sql); $sql = str_replace("{query_value}", $value, $sql); } // Check custom function $fn = @$post["fn"]; if ($fn != "" && function_exists($fn)) { // Custom function(&$sql) $sql = $fn($sql); } $this->GetLookupValues($sql); }
function RenderRow() { global $conn, $Security, $Customers; // Call Row_Rendering event $Customers->Row_Rendering(); // Common render codes for all row types // CustomerID $Customers->CustomerID->CellCssStyle = ""; $Customers->CustomerID->CellCssClass = ""; // Email $Customers->zEmail->CellCssStyle = ""; $Customers->zEmail->CellCssClass = ""; // FirstName $Customers->FirstName->CellCssStyle = ""; $Customers->FirstName->CellCssClass = ""; // LastName $Customers->LastName->CellCssStyle = ""; $Customers->LastName->CellCssClass = ""; // ContactPhone $Customers->ContactPhone->CellCssStyle = ""; $Customers->ContactPhone->CellCssClass = ""; // Customer_Type $Customers->Customer_Type->CellCssStyle = ""; $Customers->Customer_Type->CellCssClass = ""; // First_Order_Date $Customers->First_Order_Date->CellCssStyle = ""; $Customers->First_Order_Date->CellCssClass = ""; // Last_Order_Date $Customers->Last_Order_Date->CellCssStyle = ""; $Customers->Last_Order_Date->CellCssClass = ""; // Total_Orders $Customers->Total_Orders->CellCssStyle = ""; $Customers->Total_Orders->CellCssClass = ""; // Delivery_Window $Customers->Delivery_Window->CellCssStyle = ""; $Customers->Delivery_Window->CellCssClass = ""; // WeeklyMeals $Customers->WeeklyMeals->CellCssStyle = ""; $Customers->WeeklyMeals->CellCssClass = ""; // WeeklyReg $Customers->WeeklyReg->CellCssStyle = ""; $Customers->WeeklyReg->CellCssClass = ""; // WeeklyVeg $Customers->WeeklyVeg->CellCssStyle = ""; $Customers->WeeklyVeg->CellCssClass = ""; // kitchen_note $Customers->kitchen_note->CellCssStyle = ""; $Customers->kitchen_note->CellCssClass = ""; if ($Customers->RowType == EW_ROWTYPE_VIEW) { // View row // CustomerID $Customers->CustomerID->ViewValue = $Customers->CustomerID->CurrentValue; $Customers->CustomerID->CssStyle = ""; $Customers->CustomerID->CssClass = ""; $Customers->CustomerID->ViewCustomAttributes = ""; // Email $Customers->zEmail->ViewValue = $Customers->zEmail->CurrentValue; $Customers->zEmail->CssStyle = ""; $Customers->zEmail->CssClass = ""; $Customers->zEmail->ViewCustomAttributes = ""; // Password $Customers->Password->ViewValue = "********"; $Customers->Password->CssStyle = ""; $Customers->Password->CssClass = ""; $Customers->Password->ViewCustomAttributes = ""; // FirstName $Customers->FirstName->ViewValue = $Customers->FirstName->CurrentValue; $Customers->FirstName->CssStyle = ""; $Customers->FirstName->CssClass = ""; $Customers->FirstName->ViewCustomAttributes = ""; // LastName $Customers->LastName->ViewValue = $Customers->LastName->CurrentValue; $Customers->LastName->CssStyle = ""; $Customers->LastName->CssClass = ""; $Customers->LastName->ViewCustomAttributes = ""; // ContactPhone $Customers->ContactPhone->ViewValue = $Customers->ContactPhone->CurrentValue; $Customers->ContactPhone->CssStyle = ""; $Customers->ContactPhone->CssClass = ""; $Customers->ContactPhone->ViewCustomAttributes = ""; // Allergies $Customers->Allergies->ViewValue = $Customers->Allergies->CurrentValue; if (!is_null($Customers->Allergies->ViewValue)) { $Customers->Allergies->ViewValue = str_replace("\n", "<br>", $Customers->Allergies->ViewValue); } $Customers->Allergies->CssStyle = ""; $Customers->Allergies->CssClass = ""; $Customers->Allergies->ViewCustomAttributes = ""; // DeliveryAddress1 $Customers->DeliveryAddress1->ViewValue = $Customers->DeliveryAddress1->CurrentValue; $Customers->DeliveryAddress1->CssStyle = ""; $Customers->DeliveryAddress1->CssClass = ""; $Customers->DeliveryAddress1->ViewCustomAttributes = ""; // DeliveryAddress2 $Customers->DeliveryAddress2->ViewValue = $Customers->DeliveryAddress2->CurrentValue; $Customers->DeliveryAddress2->CssStyle = ""; $Customers->DeliveryAddress2->CssClass = ""; $Customers->DeliveryAddress2->ViewCustomAttributes = ""; // DeliveryCity $Customers->DeliveryCity->ViewValue = $Customers->DeliveryCity->CurrentValue; $Customers->DeliveryCity->CssStyle = ""; $Customers->DeliveryCity->CssClass = ""; $Customers->DeliveryCity->ViewCustomAttributes = ""; // DeliveryState $Customers->DeliveryState->ViewValue = $Customers->DeliveryState->CurrentValue; $Customers->DeliveryState->CssStyle = ""; $Customers->DeliveryState->CssClass = ""; $Customers->DeliveryState->ViewCustomAttributes = ""; // DeliveryZip $Customers->DeliveryZip->ViewValue = $Customers->DeliveryZip->CurrentValue; $Customers->DeliveryZip->CssStyle = ""; $Customers->DeliveryZip->CssClass = ""; $Customers->DeliveryZip->ViewCustomAttributes = ""; // DeliveryComments $Customers->DeliveryComments->ViewValue = $Customers->DeliveryComments->CurrentValue; $Customers->DeliveryComments->CssStyle = ""; $Customers->DeliveryComments->CssClass = ""; $Customers->DeliveryComments->ViewCustomAttributes = ""; // BillingFirstName $Customers->BillingFirstName->ViewValue = $Customers->BillingFirstName->CurrentValue; $Customers->BillingFirstName->CssStyle = ""; $Customers->BillingFirstName->CssClass = ""; $Customers->BillingFirstName->ViewCustomAttributes = ""; // BillingLastName $Customers->BillingLastName->ViewValue = $Customers->BillingLastName->CurrentValue; $Customers->BillingLastName->CssStyle = ""; $Customers->BillingLastName->CssClass = ""; $Customers->BillingLastName->ViewCustomAttributes = ""; // BillingAddress1 $Customers->BillingAddress1->ViewValue = $Customers->BillingAddress1->CurrentValue; $Customers->BillingAddress1->CssStyle = ""; $Customers->BillingAddress1->CssClass = ""; $Customers->BillingAddress1->ViewCustomAttributes = ""; // BillingAddress2 $Customers->BillingAddress2->ViewValue = $Customers->BillingAddress2->CurrentValue; $Customers->BillingAddress2->CssStyle = ""; $Customers->BillingAddress2->CssClass = ""; $Customers->BillingAddress2->ViewCustomAttributes = ""; // BillingCity $Customers->BillingCity->ViewValue = $Customers->BillingCity->CurrentValue; $Customers->BillingCity->CssStyle = ""; $Customers->BillingCity->CssClass = ""; $Customers->BillingCity->ViewCustomAttributes = ""; // BillingState $Customers->BillingState->ViewValue = $Customers->BillingState->CurrentValue; $Customers->BillingState->CssStyle = ""; $Customers->BillingState->CssClass = ""; $Customers->BillingState->ViewCustomAttributes = ""; // BillingZip $Customers->BillingZip->ViewValue = $Customers->BillingZip->CurrentValue; $Customers->BillingZip->CssStyle = ""; $Customers->BillingZip->CssClass = ""; $Customers->BillingZip->ViewCustomAttributes = ""; // BillingPhone $Customers->BillingPhone->ViewValue = $Customers->BillingPhone->CurrentValue; $Customers->BillingPhone->CssStyle = ""; $Customers->BillingPhone->CssClass = ""; $Customers->BillingPhone->ViewCustomAttributes = ""; // BillingCardType $Customers->BillingCardType->ViewValue = $Customers->BillingCardType->CurrentValue; $Customers->BillingCardType->CssStyle = ""; $Customers->BillingCardType->CssClass = ""; $Customers->BillingCardType->ViewCustomAttributes = ""; // BillingCardNumber $Customers->BillingCardNumber->ViewValue = $Customers->BillingCardNumber->CurrentValue; $Customers->BillingCardNumber->CssStyle = ""; $Customers->BillingCardNumber->CssClass = ""; $Customers->BillingCardNumber->ViewCustomAttributes = ""; // CIMCustID $Customers->CIMCustID->ViewValue = $Customers->CIMCustID->CurrentValue; $Customers->CIMCustID->CssStyle = ""; $Customers->CIMCustID->CssClass = ""; $Customers->CIMCustID->ViewCustomAttributes = ""; // CIMPymtProfID $Customers->CIMPymtProfID->ViewValue = $Customers->CIMPymtProfID->CurrentValue; $Customers->CIMPymtProfID->CssStyle = ""; $Customers->CIMPymtProfID->CssClass = ""; $Customers->CIMPymtProfID->ViewCustomAttributes = ""; // Customer_Type $Customers->Customer_Type->ViewValue = $Customers->Customer_Type->CurrentValue; $Customers->Customer_Type->CssStyle = ""; $Customers->Customer_Type->CssClass = ""; $Customers->Customer_Type->ViewCustomAttributes = ""; // First_Order_Date $Customers->First_Order_Date->ViewValue = $Customers->First_Order_Date->CurrentValue; $Customers->First_Order_Date->ViewValue = ew_FormatDateTime($Customers->First_Order_Date->ViewValue, 6); $Customers->First_Order_Date->CssStyle = ""; $Customers->First_Order_Date->CssClass = ""; $Customers->First_Order_Date->ViewCustomAttributes = ""; // Last_Order_Date $Customers->Last_Order_Date->ViewValue = $Customers->Last_Order_Date->CurrentValue; $Customers->Last_Order_Date->ViewValue = ew_FormatDateTime($Customers->Last_Order_Date->ViewValue, 6); $Customers->Last_Order_Date->CssStyle = ""; $Customers->Last_Order_Date->CssClass = ""; $Customers->Last_Order_Date->ViewCustomAttributes = ""; // Total_Orders $Customers->Total_Orders->ViewValue = $Customers->Total_Orders->CurrentValue; $Customers->Total_Orders->CssStyle = ""; $Customers->Total_Orders->CssClass = ""; $Customers->Total_Orders->ViewCustomAttributes = ""; // Delivery_Window if (strval($Customers->Delivery_Window->CurrentValue) != "") { switch ($Customers->Delivery_Window->CurrentValue) { case "1-4": $Customers->Delivery_Window->ViewValue = "1-4"; break; case "5-8": $Customers->Delivery_Window->ViewValue = "5-8"; break; default: $Customers->Delivery_Window->ViewValue = $Customers->Delivery_Window->CurrentValue; } } else { $Customers->Delivery_Window->ViewValue = NULL; } $Customers->Delivery_Window->CssStyle = ""; $Customers->Delivery_Window->CssClass = ""; $Customers->Delivery_Window->ViewCustomAttributes = ""; // WeeklyMeals $Customers->WeeklyMeals->ViewValue = $Customers->WeeklyMeals->CurrentValue; $Customers->WeeklyMeals->CssStyle = ""; $Customers->WeeklyMeals->CssClass = ""; $Customers->WeeklyMeals->ViewCustomAttributes = ""; // WeeklyReg $Customers->WeeklyReg->ViewValue = $Customers->WeeklyReg->CurrentValue; $Customers->WeeklyReg->CssStyle = ""; $Customers->WeeklyReg->CssClass = ""; $Customers->WeeklyReg->ViewCustomAttributes = ""; // WeeklyVeg $Customers->WeeklyVeg->ViewValue = $Customers->WeeklyVeg->CurrentValue; $Customers->WeeklyVeg->CssStyle = ""; $Customers->WeeklyVeg->CssClass = ""; $Customers->WeeklyVeg->ViewCustomAttributes = ""; // Want if (strval($Customers->Want->CurrentValue) != "") { $arwrk = explode(",", $Customers->Want->CurrentValue); $sSqlWrk = "SELECT `ItemName` FROM `Items` WHERE "; $sWhereWrk = ""; foreach ($arwrk as $wrk) { if ($sWhereWrk != "") { $sWhereWrk .= " OR "; } $sWhereWrk .= "`ItemID` = " . ew_AdjustSql(trim($wrk)) . ""; } if ($sWhereWrk != "") { $sSqlWrk .= "(" . $sWhereWrk . ")"; } $sSqlWrk .= " ORDER BY `ItemName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $Customers->Want->ViewValue = ""; $ari = 0; while (!$rswrk->EOF) { $Customers->Want->ViewValue .= $rswrk->fields('ItemName'); $rswrk->MoveNext(); if (!$rswrk->EOF) { $Customers->Want->ViewValue .= ew_ViewOptionSeparator($ari); } // Separate Options $ari++; } $rswrk->Close(); } else { $Customers->Want->ViewValue = $Customers->Want->CurrentValue; } } else { $Customers->Want->ViewValue = NULL; } $Customers->Want->CssStyle = ""; $Customers->Want->CssClass = ""; $Customers->Want->ViewCustomAttributes = ""; // DontWant if (strval($Customers->DontWant->CurrentValue) != "") { $arwrk = explode(",", $Customers->DontWant->CurrentValue); $sSqlWrk = "SELECT `ItemName` FROM `Items` WHERE "; $sWhereWrk = ""; foreach ($arwrk as $wrk) { if ($sWhereWrk != "") { $sWhereWrk .= " OR "; } $sWhereWrk .= "`ItemID` = " . ew_AdjustSql(trim($wrk)) . ""; } if ($sWhereWrk != "") { $sSqlWrk .= "(" . $sWhereWrk . ")"; } $sSqlWrk .= " ORDER BY `ItemName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $Customers->DontWant->ViewValue = ""; $ari = 0; while (!$rswrk->EOF) { $Customers->DontWant->ViewValue .= $rswrk->fields('ItemName'); $rswrk->MoveNext(); if (!$rswrk->EOF) { $Customers->DontWant->ViewValue .= ew_ViewOptionSeparator($ari); } // Separate Options $ari++; } $rswrk->Close(); } else { $Customers->DontWant->ViewValue = $Customers->DontWant->CurrentValue; } } else { $Customers->DontWant->ViewValue = NULL; } $Customers->DontWant->CssStyle = ""; $Customers->DontWant->CssClass = ""; $Customers->DontWant->ViewCustomAttributes = ""; // Comments $Customers->Comments->ViewValue = $Customers->Comments->CurrentValue; if (!is_null($Customers->Comments->ViewValue)) { $Customers->Comments->ViewValue = str_replace("\n", "<br>", $Customers->Comments->ViewValue); } $Customers->Comments->CssStyle = ""; $Customers->Comments->CssClass = ""; $Customers->Comments->ViewCustomAttributes = ""; // kitchen_note $Customers->kitchen_note->ViewValue = $Customers->kitchen_note->CurrentValue; $Customers->kitchen_note->CssStyle = ""; $Customers->kitchen_note->CssClass = ""; $Customers->kitchen_note->ViewCustomAttributes = ""; // CustomerID $Customers->CustomerID->HrefValue = ""; // Email $Customers->zEmail->HrefValue = ""; // FirstName $Customers->FirstName->HrefValue = ""; // LastName $Customers->LastName->HrefValue = ""; // ContactPhone $Customers->ContactPhone->HrefValue = ""; // Customer_Type $Customers->Customer_Type->HrefValue = ""; // First_Order_Date $Customers->First_Order_Date->HrefValue = ""; // Last_Order_Date $Customers->Last_Order_Date->HrefValue = ""; // Total_Orders $Customers->Total_Orders->HrefValue = ""; // Delivery_Window $Customers->Delivery_Window->HrefValue = ""; // WeeklyMeals $Customers->WeeklyMeals->HrefValue = ""; // WeeklyReg $Customers->WeeklyReg->HrefValue = ""; // WeeklyVeg $Customers->WeeklyVeg->HrefValue = ""; // kitchen_note $Customers->kitchen_note->HrefValue = ""; } // Call Row Rendered event $Customers->Row_Rendered(); }
function BasicSearchSQL($Keyword) { $sKeyword = ew_AdjustSql($Keyword); $sWhere = ""; $this->BuildBasicSearchSQL($sWhere, $this->descripcion, $Keyword); $this->BuildBasicSearchSQL($sWhere, $this->activa, $Keyword); return $sWhere; }
function Page_Main() { global $conn, $Language, $gsFormError; global $Breadcrumb; $Breadcrumb = new cBreadcrumb(); $Breadcrumb->Add("forgotpwd", "<span id=\"ewPageCaption\">" . $Language->Phrase("RequestPwdPage") . "</span>", ew_CurrentUrl()); $bPostBack = ew_IsHttpPost(); $bValidEmail = FALSE; if ($bPostBack) { // Setup variables $this->Email = $_POST["email"]; $bValidEmail = $this->ValidateForm($this->Email); if ($bValidEmail) { $this->Action = "activate"; $this->ActivateCode = ew_Encrypt($this->Email); } else { $this->setFailureMessage($gsFormError); } // Handle email activation } elseif (@$_GET["action"] != "") { $this->Action = $_GET["action"]; $this->Email = @$_GET["email"]; $this->ActivateCode = @$_GET["code"]; if ($this->Email != ew_Decrypt($this->ActivateCode) || strtolower($this->Action) != "confirm") { // Email activation if ($this->getFailureMessage() == "") { $this->setFailureMessage($Language->Phrase("ActivateFailed")); } // Set activate failed message $this->Page_Terminate("login.php"); // Go to login page } } if ($this->Action != "") { $bEmailSent = FALSE; // Set up filter (SQL WHERE clause) and get Return SQL // SQL constructor in usuario class, usuarioinfo.php $sFilter = str_replace("%e", ew_AdjustSql($this->Email), EW_USER_EMAIL_FILTER); $this->CurrentFilter = $sFilter; $sSql = $this->SQL(); if ($RsUser = $conn->Execute($sSql)) { if (!$RsUser->EOF) { $rsold = $RsUser->fields; $bValidEmail = TRUE; // Call User Recover Password event $bValidEmail = $this->User_RecoverPassword($rsold); if ($bValidEmail) { $sUserName = $rsold['usuario']; $sPassword = $rsold['contrasenia']; if (EW_ENCRYPTED_PASSWORD) { if (strtolower($this->Action) == "confirm") { $sPassword = substr($sPassword, 0, 16); // Use first 16 characters only $rsnew = array('contrasenia' => $sPassword); // Reset the password $this->Update($rsnew); } } else { $this->Action = "confirm"; // Send password directly if not MD5 } } } else { $bValidEmail = FALSE; $this->setFailureMessage($Language->Phrase("InvalidEmail")); } if ($bValidEmail) { $Email = new cEmail(); if (strtolower($this->Action) == "confirm") { $Email->Load("phptxt/forgotpwd.txt"); $Email->ReplaceContent('<!--$Password-->', $sPassword); } else { $Email->Load("phptxt/resetpwd.txt"); $sActivateLink = ew_FullUrl() . "?action=confirm"; $sActivateLink .= "&email=" . $this->Email; $sActivateLink .= "&code=" . $this->ActivateCode; $Email->ReplaceContent('<!--$ActivateLink-->', $sActivateLink); } $Email->ReplaceSender(EW_SENDER_EMAIL); // Replace Sender $Email->ReplaceRecipient($this->Email); // Replace Recipient $Email->ReplaceContent('<!--$UserName-->', $sUserName); $Email->Charset = EW_EMAIL_CHARSET; $Args = array(); if (EW_ENCRYPTED_PASSWORD && strtolower($this->Action) == "confirm") { $Args["rs"] =& $rsnew; } if ($this->Email_Sending($Email, $Args)) { $bEmailSent = $Email->Send(); } } $RsUser->Close(); } if ($bEmailSent) { if ($this->getSuccessMessage() == "") { if (strtolower($this->Action) == "confirm") { $this->setSuccessMessage($Language->Phrase("PwdEmailSent")); } else { $this->setSuccessMessage($Language->Phrase("ResetPwdEmailSent")); } } // Set up success message $this->Page_Terminate("login.php"); // Return to login page } elseif ($bValidEmail) { $this->setFailureMessage($Language->Phrase("FailedToSendMail")); // Set up error message } } }
function EditRow() { global $conn, $Security, $AdminInfo; $sFilter = $AdminInfo->KeyFilter(); if ($AdminInfo->Name->CurrentValue != "") { // Check field with unique index $sFilterChk = "(Name = '" . ew_AdjustSql($AdminInfo->Name->CurrentValue) . "')"; $sFilterChk .= " AND NOT (" . $sFilter . ")"; $AdminInfo->CurrentFilter = $sFilterChk; $sSqlChk = $AdminInfo->SQL(); $conn->raiseErrorFn = 'ew_ErrorFn'; $rsChk = $conn->Execute($sSqlChk); $conn->raiseErrorFn = ''; if ($rsChk === FALSE) { return FALSE; } elseif (!$rsChk->EOF) { $sIdxErrMsg = str_replace("%f", "Name", "Duplicate value '%v' for unique index '%f'"); $sIdxErrMsg = str_replace("%v", $AdminInfo->Name->CurrentValue, $sIdxErrMsg); $this->setMessage($sIdxErrMsg); $rsChk->Close(); return FALSE; } $rsChk->Close(); } $AdminInfo->CurrentFilter = $sFilter; $sSql = $AdminInfo->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(); // Field id // Field Name $AdminInfo->Name->SetDbValueDef($AdminInfo->Name->CurrentValue, ""); $rsnew['Name'] =& $AdminInfo->Name->DbValue; // Field Password $AdminInfo->Password->SetDbValueDef($AdminInfo->Password->CurrentValue, ""); $rsnew['Password'] =& $AdminInfo->Password->DbValue; // Call Row Updating event $bUpdateRow = $AdminInfo->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($AdminInfo->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($AdminInfo->CancelMessage != "") { $this->setMessage($AdminInfo->CancelMessage); $AdminInfo->CancelMessage = ""; } else { $this->setMessage("Update cancelled"); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) { $AdminInfo->Row_Updated($rsold, $rsnew); } $rs->Close(); return $EditRow; }
function KeyFilter() { $sKeyFilter = $this->SqlKeyFilter(); if (!is_numeric($this->subject_type_id->CurrentValue)) { $sKeyFilter = "0=1"; } // Invalid key $sKeyFilter = str_replace("@subject_type_id@", ew_AdjustSql($this->subject_type_id->CurrentValue), $sKeyFilter); // Replace key value return $sKeyFilter; }
function Page_Main() { global $conn, $Language, $Security, $gsFormError; global $Breadcrumb; $Breadcrumb = new cBreadcrumb(); $Breadcrumb->Add("changepwd", "ChangePwdPage", ew_CurrentUrl(), "", "", TRUE); $bPostBack = ew_IsHttpPost(); $bValidate = TRUE; if ($bPostBack) { $this->OldPassword = ew_StripSlashes(@$_POST["opwd"]); $this->NewPassword = ew_StripSlashes(@$_POST["npwd"]); $this->ConfirmedPassword = ew_StripSlashes(@$_POST["cpwd"]); $bValidate = $this->ValidateForm($this->OldPassword, $this->NewPassword, $this->ConfirmedPassword); if (!$bValidate) { $this->setFailureMessage($gsFormError); } } $bPwdUpdated = FALSE; if ($bPostBack && $bValidate) { // Setup variables $sUsername = $Security->CurrentUserName(); $sFilter = str_replace("%u", ew_AdjustSql($sUsername), EW_USER_NAME_FILTER); // Set up filter (Sql Where Clause) and get Return SQL // SQL constructor in usuarios class, usuariosinfo.php $this->CurrentFilter = $sFilter; $sSql = $this->SQL(); if ($rs = $conn->Execute($sSql)) { if (!$rs->EOF) { $rsold = $rs->fields; if (ew_ComparePassword($rsold['contrasenia'], $this->OldPassword)) { $bValidPwd = TRUE; $bValidPwd = $this->User_ChangePassword($rsold, $sUsername, $this->OldPassword, $this->NewPassword); if ($bValidPwd) { $rsnew = array('contrasenia' => $this->NewPassword); // Change Password $sEmail = $rsold['email']; $rs->Close(); $conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"]; $bValidPwd = $this->Update($rsnew); $conn->raiseErrorFn = ''; if ($bValidPwd) { $bPwdUpdated = TRUE; } } else { $this->setFailureMessage($Language->Phrase("InvalidNewPassword")); $rs->Close(); } } else { $this->setFailureMessage($Language->Phrase("InvalidPassword")); } } else { $rs->Close(); } } } if ($bPwdUpdated) { if (@$sEmail != "") { // Load Email Content $Email = new cEmail(); $Email->Load("phptxt/changepwd.txt"); $Email->ReplaceSender(EW_SENDER_EMAIL); // Replace Sender $Email->ReplaceRecipient($sEmail); // Replace Recipient $Email->ReplaceContent('<!--$Password-->', $this->NewPassword); $Email->Charset = EW_EMAIL_CHARSET; $Args = array(); $Args["rs"] =& $rsnew; $bEmailSent = FALSE; if ($this->Email_Sending($Email, $Args)) { $bEmailSent = $Email->Send(); } // Send email failed if (!$bEmailSent) { $this->setFailureMessage($Email->SendErrDescription); } } if ($this->getSuccessMessage() == "") { $this->setSuccessMessage($Language->Phrase("PasswordChanged")); } // Set up success message $this->Page_Terminate("index.php"); // Exit page and clean up } }
function RenderListRow() { global $conn, $Security; // Call Row Rendering event $this->Row_Rendering(); // DeliveryDate $this->DeliveryDate->ViewValue = $this->DeliveryDate->CurrentValue; $this->DeliveryDate->ViewValue = ew_FormatDateTime($this->DeliveryDate->ViewValue, 6); $this->DeliveryDate->CssStyle = ""; $this->DeliveryDate->CssClass = ""; $this->DeliveryDate->ViewCustomAttributes = ""; // CustomerID if (strval($this->CustomerID->CurrentValue) != "") { $sSqlWrk = "SELECT `LastName`, `FirstName` FROM `Customers` WHERE `CustomerID` = " . ew_AdjustSql($this->CustomerID->CurrentValue) . ""; $sSqlWrk .= " ORDER BY `LastName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $this->CustomerID->ViewValue = $rswrk->fields('LastName'); $this->CustomerID->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $this->CustomerID->ViewValue = $this->CustomerID->CurrentValue; } } else { $this->CustomerID->ViewValue = NULL; } $this->CustomerID->CssStyle = ""; $this->CustomerID->CssClass = ""; $this->CustomerID->ViewCustomAttributes = ""; // WeeklyMeals $this->WeeklyMeals->ViewValue = $this->WeeklyMeals->CurrentValue; $this->WeeklyMeals->CssStyle = ""; $this->WeeklyMeals->CssClass = ""; $this->WeeklyMeals->ViewCustomAttributes = ""; // WeeklyReg $this->WeeklyReg->ViewValue = $this->WeeklyReg->CurrentValue; $this->WeeklyReg->CssStyle = ""; $this->WeeklyReg->CssClass = ""; $this->WeeklyReg->ViewCustomAttributes = ""; // WeeklyVeg $this->WeeklyVeg->ViewValue = $this->WeeklyVeg->CurrentValue; $this->WeeklyVeg->CssStyle = ""; $this->WeeklyVeg->CssClass = ""; $this->WeeklyVeg->ViewCustomAttributes = ""; // TransactionNumber $this->TransactionNumber->ViewValue = $this->TransactionNumber->CurrentValue; $this->TransactionNumber->CssStyle = ""; $this->TransactionNumber->CssClass = ""; $this->TransactionNumber->ViewCustomAttributes = ""; // Want if (strval($this->Want->CurrentValue) != "") { $arwrk = explode(",", $this->Want->CurrentValue); $sSqlWrk = "SELECT `ItemName` FROM `Items` WHERE "; $sWhereWrk = ""; foreach ($arwrk as $wrk) { if ($sWhereWrk != "") { $sWhereWrk .= " OR "; } $sWhereWrk .= "`ItemID` = " . ew_AdjustSql(trim($wrk)) . ""; } if ($sWhereWrk != "") { $sSqlWrk .= "(" . $sWhereWrk . ")"; } $sSqlWrk .= " ORDER BY `ItemName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $this->Want->ViewValue = ""; $ari = 0; while (!$rswrk->EOF) { $this->Want->ViewValue .= $rswrk->fields('ItemName'); $rswrk->MoveNext(); if (!$rswrk->EOF) { $this->Want->ViewValue .= ew_ViewOptionSeparator($ari); } // Separate Options $ari++; } $rswrk->Close(); } else { $this->Want->ViewValue = $this->Want->CurrentValue; } } else { $this->Want->ViewValue = NULL; } $this->Want->CssStyle = ""; $this->Want->CssClass = ""; $this->Want->ViewCustomAttributes = ""; // DontWant if (strval($this->DontWant->CurrentValue) != "") { $arwrk = explode(",", $this->DontWant->CurrentValue); $sSqlWrk = "SELECT `ItemName` FROM `Items` WHERE "; $sWhereWrk = ""; foreach ($arwrk as $wrk) { if ($sWhereWrk != "") { $sWhereWrk .= " OR "; } $sWhereWrk .= "`ItemID` = " . ew_AdjustSql(trim($wrk)) . ""; } if ($sWhereWrk != "") { $sSqlWrk .= "(" . $sWhereWrk . ")"; } $sSqlWrk .= " ORDER BY `ItemName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $this->DontWant->ViewValue = ""; $ari = 0; while (!$rswrk->EOF) { $this->DontWant->ViewValue .= $rswrk->fields('ItemName'); $rswrk->MoveNext(); if (!$rswrk->EOF) { $this->DontWant->ViewValue .= ew_ViewOptionSeparator($ari); } // Separate Options $ari++; } $rswrk->Close(); } else { $this->DontWant->ViewValue = $this->DontWant->CurrentValue; } } else { $this->DontWant->ViewValue = NULL; } $this->DontWant->CssStyle = ""; $this->DontWant->CssClass = ""; $this->DontWant->ViewCustomAttributes = ""; // Comments $this->Comments->ViewValue = $this->Comments->CurrentValue; $this->Comments->CssStyle = ""; $this->Comments->CssClass = ""; $this->Comments->ViewCustomAttributes = ""; // DeliveryDate $this->DeliveryDate->HrefValue = ""; // CustomerID $this->CustomerID->HrefValue = ""; // WeeklyMeals $this->WeeklyMeals->HrefValue = ""; // WeeklyReg $this->WeeklyReg->HrefValue = ""; // WeeklyVeg $this->WeeklyVeg->HrefValue = ""; // TransactionNumber $this->TransactionNumber->HrefValue = ""; // Want $this->Want->HrefValue = ""; // DontWant $this->DontWant->HrefValue = ""; // Comments $this->Comments->HrefValue = ""; // Call Row Rendered event $this->Row_Rendered(); }
function RenderRow() { global $conn, $Security, $Language, $t_promotions_vins; // Initialize URLs $this->ViewUrl = $t_promotions_vins->ViewUrl(); $this->EditUrl = $t_promotions_vins->EditUrl(); $this->InlineEditUrl = $t_promotions_vins->InlineEditUrl(); $this->CopyUrl = $t_promotions_vins->CopyUrl(); $this->InlineCopyUrl = $t_promotions_vins->InlineCopyUrl(); $this->DeleteUrl = $t_promotions_vins->DeleteUrl(); // Call Row_Rendering event $t_promotions_vins->Row_Rendering(); // Common render codes for all row types // promotion // produit_vin if ($t_promotions_vins->RowType == EW_ROWTYPE_VIEW) { // View row // promotion if (strval($t_promotions_vins->promotion->CurrentValue) != "") { $sFilterWrk = "`id` = " . ew_AdjustSql($t_promotions_vins->promotion->CurrentValue) . ""; $sSqlWrk = "SELECT `titre` FROM `t_promotions`"; $sWhereWrk = ""; if ($sFilterWrk != "") { if ($sWhereWrk != "") { $sWhereWrk .= " AND "; } $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `titre` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $t_promotions_vins->promotion->ViewValue = $rswrk->fields('titre'); $rswrk->Close(); } else { $t_promotions_vins->promotion->ViewValue = $t_promotions_vins->promotion->CurrentValue; } } else { $t_promotions_vins->promotion->ViewValue = NULL; } $t_promotions_vins->promotion->ViewCustomAttributes = ""; // produit_vin $t_promotions_vins->produit_vin->ViewValue = $t_promotions_vins->produit_vin->CurrentValue; if (strval($t_promotions_vins->produit_vin->CurrentValue) != "") { $sFilterWrk = "`id_produit_vin` = " . ew_AdjustSql($t_promotions_vins->produit_vin->CurrentValue) . ""; $sSqlWrk = "SELECT `label` FROM `v_all_produits_vins`"; $sWhereWrk = ""; if ($sFilterWrk != "") { if ($sWhereWrk != "") { $sWhereWrk .= " AND "; } $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `label` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $t_promotions_vins->produit_vin->ViewValue = $rswrk->fields('label'); $rswrk->Close(); } else { $t_promotions_vins->produit_vin->ViewValue = $t_promotions_vins->produit_vin->CurrentValue; } } else { $t_promotions_vins->produit_vin->ViewValue = NULL; } $t_promotions_vins->produit_vin->ViewCustomAttributes = ""; // promotion $t_promotions_vins->promotion->LinkCustomAttributes = ""; $t_promotions_vins->promotion->HrefValue = ""; $t_promotions_vins->promotion->TooltipValue = ""; // produit_vin $t_promotions_vins->produit_vin->LinkCustomAttributes = ""; $t_promotions_vins->produit_vin->HrefValue = ""; $t_promotions_vins->produit_vin->TooltipValue = ""; } // Call Row Rendered event if ($t_promotions_vins->RowType != EW_ROWTYPE_AGGREGATEINIT) { $t_promotions_vins->Row_Rendered(); } }
function SetUpMasterDetail() { global $ItemIngredients; $bValidMaster = FALSE; // Get the keys for master table if (@$_GET[EW_TABLE_SHOW_MASTER] != "") { $sMasterTblVar = $_GET[EW_TABLE_SHOW_MASTER]; if ($sMasterTblVar == "") { $bValidMaster = TRUE; $this->sDbMasterFilter = ""; $this->sDbDetailFilter = ""; } if ($sMasterTblVar == "Ingredients") { $bValidMaster = TRUE; $this->sDbMasterFilter = $ItemIngredients->SqlMasterFilter_Ingredients(); $this->sDbDetailFilter = $ItemIngredients->SqlDetailFilter_Ingredients(); if (@$_GET["IngredientID"] != "") { $GLOBALS["Ingredients"]->IngredientID->setQueryStringValue($_GET["IngredientID"]); $ItemIngredients->IngredientID->setQueryStringValue($GLOBALS["Ingredients"]->IngredientID->QueryStringValue); $ItemIngredients->IngredientID->setSessionValue($ItemIngredients->IngredientID->QueryStringValue); if (!is_numeric($GLOBALS["Ingredients"]->IngredientID->QueryStringValue)) { $bValidMaster = FALSE; } $this->sDbMasterFilter = str_replace("@IngredientID@", ew_AdjustSql($GLOBALS["Ingredients"]->IngredientID->QueryStringValue), $this->sDbMasterFilter); $this->sDbDetailFilter = str_replace("@IngredientID@", ew_AdjustSql($GLOBALS["Ingredients"]->IngredientID->QueryStringValue), $this->sDbDetailFilter); } else { $bValidMaster = FALSE; } } if ($sMasterTblVar == "Items") { $bValidMaster = TRUE; $this->sDbMasterFilter = $ItemIngredients->SqlMasterFilter_Items(); $this->sDbDetailFilter = $ItemIngredients->SqlDetailFilter_Items(); if (@$_GET["ItemID"] != "") { $GLOBALS["Items"]->ItemID->setQueryStringValue($_GET["ItemID"]); $ItemIngredients->ItemID->setQueryStringValue($GLOBALS["Items"]->ItemID->QueryStringValue); $ItemIngredients->ItemID->setSessionValue($ItemIngredients->ItemID->QueryStringValue); if (!is_numeric($GLOBALS["Items"]->ItemID->QueryStringValue)) { $bValidMaster = FALSE; } $this->sDbMasterFilter = str_replace("@ItemID@", ew_AdjustSql($GLOBALS["Items"]->ItemID->QueryStringValue), $this->sDbMasterFilter); $this->sDbDetailFilter = str_replace("@ItemID@", ew_AdjustSql($GLOBALS["Items"]->ItemID->QueryStringValue), $this->sDbDetailFilter); } else { $bValidMaster = FALSE; } } } if ($bValidMaster) { // Save current master table $ItemIngredients->setCurrentMasterTable($sMasterTblVar); // Reset start record counter (new master key) $this->lStartRec = 1; $ItemIngredients->setStartRecordNumber($this->lStartRec); $ItemIngredients->setMasterFilter($this->sDbMasterFilter); // Set up master filter $ItemIngredients->setDetailFilter($this->sDbDetailFilter); // Set up detail filter // Clear previous master session values if ($sMasterTblVar != "Ingredients") { if ($ItemIngredients->IngredientID->QueryStringValue == "") { $ItemIngredients->IngredientID->setSessionValue(""); } } if ($sMasterTblVar != "Items") { if ($ItemIngredients->ItemID->QueryStringValue == "") { $ItemIngredients->ItemID->setSessionValue(""); } } } else { $this->sDbMasterFilter = $ItemIngredients->getMasterFilter(); // Restore master filter $this->sDbDetailFilter = $ItemIngredients->getDetailFilter(); // Restore detail filter } }
} if ($Delivery_Report_1_report->sFilter != "") { $Delivery_Report_1_report->sFilter .= " AND "; } if (is_null(ew_UnFormatDateTime(ew_FormatDateTime($Delivery_Report_1->DeliveryDate->CurrentValue, 6), 6))) { $Delivery_Report_1_report->sFilter .= "(`DeliveryDate` IS NULL)"; } else { $Delivery_Report_1_report->sFilter .= "(`DeliveryDate` = '" . ew_AdjustSql(ew_UnFormatDateTime(ew_FormatDateTime($Delivery_Report_1->DeliveryDate->CurrentValue, 6), 6)) . "')"; } if ($Delivery_Report_1_report->sFilter != "") { $Delivery_Report_1_report->sFilter .= " AND "; } if (is_null($Delivery_Report_1->Delivery_Window->CurrentValue)) { $Delivery_Report_1_report->sFilter .= "(`Delivery_Window` IS NULL)"; } else { $Delivery_Report_1_report->sFilter .= "(`Delivery_Window` = '" . ew_AdjustSql($Delivery_Report_1->Delivery_Window->CurrentValue) . "')"; } if ($Delivery_Report_1_report->sDbDetailFilter != "") { if ($Delivery_Report_1_report->sFilter != "") { $Delivery_Report_1_report->sFilter .= " AND "; } $Delivery_Report_1_report->sFilter .= "(" . $Delivery_Report_1_report->sDbDetailFilter . ")"; } // Set up detail SQL $Delivery_Report_1->CurrentFilter = $Delivery_Report_1_report->sFilter; $Delivery_Report_1_report->sSql = $Delivery_Report_1->DetailSQL(); // Load detail records $rsdtl = $conn->Execute($Delivery_Report_1_report->sSql); $Delivery_Report_1_report->nDtlRecs = $rsdtl->RecordCount(); // Initialize Aggregate if (!$rsdtl->EOF) {
function RenderListRow() { global $conn, $Security; // Call Row Rendering event $this->Row_Rendering(); // Common render codes // id_profile $this->id_profile->CellCssStyle = "white-space: nowrap;"; $this->id_profile->CellCssClass = ""; $this->id_profile->CellAttrs = array(); $this->id_profile->ViewAttrs = array(); $this->id_profile->EditAttrs = array(); // stat_date $this->stat_date->CellCssStyle = ""; $this->stat_date->CellCssClass = ""; $this->stat_date->CellAttrs = array(); $this->stat_date->ViewAttrs = array(); $this->stat_date->EditAttrs = array(); // year $this->year->CellCssStyle = ""; $this->year->CellCssClass = ""; $this->year->CellAttrs = array(); $this->year->ViewAttrs = array(); $this->year->EditAttrs = array(); // month $this->month->CellCssStyle = ""; $this->month->CellCssClass = ""; $this->month->CellAttrs = array(); $this->month->ViewAttrs = array(); $this->month->EditAttrs = array(); // week $this->week->CellCssStyle = ""; $this->week->CellCssClass = ""; $this->week->CellAttrs = array(); $this->week->ViewAttrs = array(); $this->week->EditAttrs = array(); // alexa_rank $this->alexa_rank->CellCssStyle = ""; $this->alexa_rank->CellCssClass = ""; $this->alexa_rank->CellAttrs = array(); $this->alexa_rank->ViewAttrs = array(); $this->alexa_rank->EditAttrs = array(); // google_pagerank $this->google_pagerank->CellCssStyle = ""; $this->google_pagerank->CellCssClass = ""; $this->google_pagerank->CellAttrs = array(); $this->google_pagerank->ViewAttrs = array(); $this->google_pagerank->EditAttrs = array(); // id_profile if (strval($this->id_profile->CurrentValue) != "") { $sFilterWrk = "`id` = " . ew_AdjustSql($this->id_profile->CurrentValue) . ""; $sSqlWrk = "SELECT DISTINCT `name` FROM `tbl_profile`"; $sWhereWrk = ""; if ($sWhereWrk != "") { $sWhereWrk .= " AND "; } $sWhereWrk .= "(" . "is_active = '1'" . ")"; if ($sFilterWrk != "") { if ($sWhereWrk != "") { $sWhereWrk .= " AND "; } $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `name` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_profile->ViewValue = $rswrk->fields('name'); $rswrk->Close(); } else { $this->id_profile->ViewValue = $this->id_profile->CurrentValue; } } else { $this->id_profile->ViewValue = NULL; } $this->id_profile->CssStyle = ""; $this->id_profile->CssClass = ""; $this->id_profile->ViewCustomAttributes = ""; // stat_date $this->stat_date->ViewValue = $this->stat_date->CurrentValue; $this->stat_date->ViewValue = ew_FormatDateTime($this->stat_date->ViewValue, 5); $this->stat_date->CssStyle = ""; $this->stat_date->CssClass = ""; $this->stat_date->ViewCustomAttributes = ""; // year $this->year->ViewValue = $this->year->CurrentValue; $this->year->CssStyle = ""; $this->year->CssClass = ""; $this->year->ViewCustomAttributes = ""; // month $this->month->ViewValue = $this->month->CurrentValue; $this->month->CssStyle = ""; $this->month->CssClass = ""; $this->month->ViewCustomAttributes = ""; // week $this->week->ViewValue = $this->week->CurrentValue; $this->week->CssStyle = ""; $this->week->CssClass = ""; $this->week->ViewCustomAttributes = ""; // alexa_rank $this->alexa_rank->ViewValue = $this->alexa_rank->CurrentValue; $this->alexa_rank->CssStyle = ""; $this->alexa_rank->CssClass = ""; $this->alexa_rank->ViewCustomAttributes = ""; // google_pagerank $this->google_pagerank->ViewValue = $this->google_pagerank->CurrentValue; $this->google_pagerank->CssStyle = ""; $this->google_pagerank->CssClass = ""; $this->google_pagerank->ViewCustomAttributes = ""; // id_profile $this->id_profile->HrefValue = ""; $this->id_profile->TooltipValue = ""; // stat_date $this->stat_date->HrefValue = ""; $this->stat_date->TooltipValue = ""; // year $this->year->HrefValue = ""; $this->year->TooltipValue = ""; // month $this->month->HrefValue = ""; $this->month->TooltipValue = ""; // week $this->week->HrefValue = ""; $this->week->TooltipValue = ""; // alexa_rank $this->alexa_rank->HrefValue = ""; $this->alexa_rank->TooltipValue = ""; // google_pagerank $this->google_pagerank->HrefValue = ""; $this->google_pagerank->TooltipValue = ""; // Call Row Rendered event $this->Row_Rendered(); }
function RenderRow() { global $conn, $Security, $Language, $tbl_ga_stat; // Initialize URLs // Call Row_Rendering event $tbl_ga_stat->Row_Rendering(); // Common render codes for all row types // id_profile $tbl_ga_stat->id_profile->CellCssStyle = "white-space: nowrap;"; $tbl_ga_stat->id_profile->CellCssClass = ""; $tbl_ga_stat->id_profile->CellAttrs = array(); $tbl_ga_stat->id_profile->ViewAttrs = array(); $tbl_ga_stat->id_profile->EditAttrs = array(); // stat_date $tbl_ga_stat->stat_date->CellCssStyle = ""; $tbl_ga_stat->stat_date->CellCssClass = ""; $tbl_ga_stat->stat_date->CellAttrs = array(); $tbl_ga_stat->stat_date->ViewAttrs = array(); $tbl_ga_stat->stat_date->EditAttrs = array(); // year $tbl_ga_stat->year->CellCssStyle = ""; $tbl_ga_stat->year->CellCssClass = ""; $tbl_ga_stat->year->CellAttrs = array(); $tbl_ga_stat->year->ViewAttrs = array(); $tbl_ga_stat->year->EditAttrs = array(); // month $tbl_ga_stat->month->CellCssStyle = ""; $tbl_ga_stat->month->CellCssClass = ""; $tbl_ga_stat->month->CellAttrs = array(); $tbl_ga_stat->month->ViewAttrs = array(); $tbl_ga_stat->month->EditAttrs = array(); // week $tbl_ga_stat->week->CellCssStyle = ""; $tbl_ga_stat->week->CellCssClass = ""; $tbl_ga_stat->week->CellAttrs = array(); $tbl_ga_stat->week->ViewAttrs = array(); $tbl_ga_stat->week->EditAttrs = array(); // day $tbl_ga_stat->day->CellCssStyle = ""; $tbl_ga_stat->day->CellCssClass = ""; $tbl_ga_stat->day->CellAttrs = array(); $tbl_ga_stat->day->ViewAttrs = array(); $tbl_ga_stat->day->EditAttrs = array(); // hour $tbl_ga_stat->hour->CellCssStyle = ""; $tbl_ga_stat->hour->CellCssClass = ""; $tbl_ga_stat->hour->CellAttrs = array(); $tbl_ga_stat->hour->ViewAttrs = array(); $tbl_ga_stat->hour->EditAttrs = array(); // pageview $tbl_ga_stat->pageview->CellCssStyle = ""; $tbl_ga_stat->pageview->CellCssClass = ""; $tbl_ga_stat->pageview->CellAttrs = array(); $tbl_ga_stat->pageview->ViewAttrs = array(); $tbl_ga_stat->pageview->EditAttrs = array(); // visit $tbl_ga_stat->visit->CellCssStyle = ""; $tbl_ga_stat->visit->CellCssClass = ""; $tbl_ga_stat->visit->CellAttrs = array(); $tbl_ga_stat->visit->ViewAttrs = array(); $tbl_ga_stat->visit->EditAttrs = array(); if ($tbl_ga_stat->RowType == EW_ROWTYPE_VIEW) { // View row // id_profile if (strval($tbl_ga_stat->id_profile->CurrentValue) != "") { $sFilterWrk = "`id` = " . ew_AdjustSql($tbl_ga_stat->id_profile->CurrentValue) . ""; $sSqlWrk = "SELECT DISTINCT `name` FROM `tbl_profile`"; $sWhereWrk = ""; if ($sFilterWrk != "") { if ($sWhereWrk != "") { $sWhereWrk .= " AND "; } $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `name` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $tbl_ga_stat->id_profile->ViewValue = $rswrk->fields('name'); $rswrk->Close(); } else { $tbl_ga_stat->id_profile->ViewValue = $tbl_ga_stat->id_profile->CurrentValue; } } else { $tbl_ga_stat->id_profile->ViewValue = NULL; } $tbl_ga_stat->id_profile->CssStyle = ""; $tbl_ga_stat->id_profile->CssClass = ""; $tbl_ga_stat->id_profile->ViewCustomAttributes = ""; // stat_date $tbl_ga_stat->stat_date->ViewValue = $tbl_ga_stat->stat_date->CurrentValue; $tbl_ga_stat->stat_date->ViewValue = ew_FormatDateTime($tbl_ga_stat->stat_date->ViewValue, 5); $tbl_ga_stat->stat_date->CssStyle = ""; $tbl_ga_stat->stat_date->CssClass = ""; $tbl_ga_stat->stat_date->ViewCustomAttributes = ""; // year $tbl_ga_stat->year->ViewValue = $tbl_ga_stat->year->CurrentValue; $tbl_ga_stat->year->CssStyle = ""; $tbl_ga_stat->year->CssClass = ""; $tbl_ga_stat->year->ViewCustomAttributes = ""; // month $tbl_ga_stat->month->ViewValue = $tbl_ga_stat->month->CurrentValue; $tbl_ga_stat->month->CssStyle = ""; $tbl_ga_stat->month->CssClass = ""; $tbl_ga_stat->month->ViewCustomAttributes = ""; // week $tbl_ga_stat->week->ViewValue = $tbl_ga_stat->week->CurrentValue; $tbl_ga_stat->week->CssStyle = ""; $tbl_ga_stat->week->CssClass = ""; $tbl_ga_stat->week->ViewCustomAttributes = ""; // day if (strval($tbl_ga_stat->day->CurrentValue) != "") { switch ($tbl_ga_stat->day->CurrentValue) { case "1": $tbl_ga_stat->day->ViewValue = "1"; break; case "2": $tbl_ga_stat->day->ViewValue = "2"; break; case "3": $tbl_ga_stat->day->ViewValue = "3"; break; case "4": $tbl_ga_stat->day->ViewValue = "4"; break; case "5": $tbl_ga_stat->day->ViewValue = "5"; break; case "6": $tbl_ga_stat->day->ViewValue = "6"; break; case "7": $tbl_ga_stat->day->ViewValue = "7"; break; default: $tbl_ga_stat->day->ViewValue = $tbl_ga_stat->day->CurrentValue; } } else { $tbl_ga_stat->day->ViewValue = NULL; } $tbl_ga_stat->day->CssStyle = ""; $tbl_ga_stat->day->CssClass = ""; $tbl_ga_stat->day->ViewCustomAttributes = ""; // hour $tbl_ga_stat->hour->ViewValue = $tbl_ga_stat->hour->CurrentValue; $tbl_ga_stat->hour->ViewValue = ew_FormatDateTime($tbl_ga_stat->hour->ViewValue, 4); $tbl_ga_stat->hour->CssStyle = ""; $tbl_ga_stat->hour->CssClass = ""; $tbl_ga_stat->hour->ViewCustomAttributes = ""; // pageview $tbl_ga_stat->pageview->ViewValue = $tbl_ga_stat->pageview->CurrentValue; $tbl_ga_stat->pageview->CssStyle = ""; $tbl_ga_stat->pageview->CssClass = ""; $tbl_ga_stat->pageview->ViewCustomAttributes = ""; // visit $tbl_ga_stat->visit->ViewValue = $tbl_ga_stat->visit->CurrentValue; $tbl_ga_stat->visit->CssStyle = ""; $tbl_ga_stat->visit->CssClass = ""; $tbl_ga_stat->visit->ViewCustomAttributes = ""; // id_profile $tbl_ga_stat->id_profile->HrefValue = ""; $tbl_ga_stat->id_profile->TooltipValue = ""; // stat_date $tbl_ga_stat->stat_date->HrefValue = ""; $tbl_ga_stat->stat_date->TooltipValue = ""; // year $tbl_ga_stat->year->HrefValue = ""; $tbl_ga_stat->year->TooltipValue = ""; // month $tbl_ga_stat->month->HrefValue = ""; $tbl_ga_stat->month->TooltipValue = ""; // week $tbl_ga_stat->week->HrefValue = ""; $tbl_ga_stat->week->TooltipValue = ""; // day $tbl_ga_stat->day->HrefValue = ""; $tbl_ga_stat->day->TooltipValue = ""; // hour $tbl_ga_stat->hour->HrefValue = ""; $tbl_ga_stat->hour->TooltipValue = ""; // pageview $tbl_ga_stat->pageview->HrefValue = ""; $tbl_ga_stat->pageview->TooltipValue = ""; // visit $tbl_ga_stat->visit->HrefValue = ""; $tbl_ga_stat->visit->TooltipValue = ""; } // Call Row Rendered event if ($tbl_ga_stat->RowType != EW_ROWTYPE_AGGREGATEINIT) { $tbl_ga_stat->Row_Rendered(); } }
function EditRow() { global $conn; for ($i = 0; $i < $this->TableNameCount; $i++) { $Sql = "SELECT * FROM " . EW_USER_LEVEL_PRIV_TABLE . " WHERE " . EW_USER_LEVEL_PRIV_TABLE_NAME_FIELD . " = '" . ew_AdjustSql($this->TableList[$i][4] . $this->TableList[$i][0]) . "' AND " . EW_USER_LEVEL_PRIV_USER_LEVEL_ID_FIELD . " = " . $this->codigo->CurrentValue; $rs = $conn->Execute($Sql); if ($rs && !$rs->EOF) { $Sql = "UPDATE " . EW_USER_LEVEL_PRIV_TABLE . " SET " . EW_USER_LEVEL_PRIV_PRIV_FIELD . " = " . $this->Privileges[$i] . " WHERE " . EW_USER_LEVEL_PRIV_TABLE_NAME_FIELD . " = '" . ew_AdjustSql($this->TableList[$i][4] . $this->TableList[$i][0]) . "' AND " . EW_USER_LEVEL_PRIV_USER_LEVEL_ID_FIELD . " = " . $this->codigo->CurrentValue; $conn->Execute($Sql); } else { $Sql = "INSERT INTO " . EW_USER_LEVEL_PRIV_TABLE . " (" . EW_USER_LEVEL_PRIV_TABLE_NAME_FIELD . ", " . EW_USER_LEVEL_PRIV_USER_LEVEL_ID_FIELD . ", " . EW_USER_LEVEL_PRIV_PRIV_FIELD . ") VALUES ('" . ew_AdjustSql($this->TableList[$i][4] . $this->TableList[$i][0]) . "', " . $this->codigo->CurrentValue . ", " . $this->Privileges[$i] . ")"; $conn->Execute($Sql); } if ($rs) { $rs->Close(); } } return TRUE; }
function KeyFilter() { $sKeyFilter = $this->SqlKeyFilter(); if (!is_numeric($this->idempleado->CurrentValue)) { $sKeyFilter = "0=1"; } // Invalid key $sKeyFilter = str_replace("@idempleado@", ew_AdjustSql($this->idempleado->CurrentValue), $sKeyFilter); // Replace key value return $sKeyFilter; }
} if ($Kitchen_Report_22D2_report->sFilter != "") { $Kitchen_Report_22D2_report->sFilter .= " AND "; } if (is_null(ew_UnFormatDateTime(ew_FormatDateTime($Kitchen_Report_22D2->DeliveryDate->CurrentValue, 6), 6))) { $Kitchen_Report_22D2_report->sFilter .= "(`DeliveryDate` IS NULL)"; } else { $Kitchen_Report_22D2_report->sFilter .= "(`DeliveryDate` = '" . ew_AdjustSql(ew_UnFormatDateTime(ew_FormatDateTime($Kitchen_Report_22D2->DeliveryDate->CurrentValue, 6), 6)) . "')"; } if ($Kitchen_Report_22D2_report->sFilter != "") { $Kitchen_Report_22D2_report->sFilter .= " AND "; } if (is_null($Kitchen_Report_22D2->MenuName->CurrentValue)) { $Kitchen_Report_22D2_report->sFilter .= "(`MenuName` IS NULL)"; } else { $Kitchen_Report_22D2_report->sFilter .= "(`MenuName` = '" . ew_AdjustSql($Kitchen_Report_22D2->MenuName->CurrentValue) . "')"; } if ($Kitchen_Report_22D2_report->sDbDetailFilter != "") { if ($Kitchen_Report_22D2_report->sFilter != "") { $Kitchen_Report_22D2_report->sFilter .= " AND "; } $Kitchen_Report_22D2_report->sFilter .= "(" . $Kitchen_Report_22D2_report->sDbDetailFilter . ")"; } // Set up detail SQL $Kitchen_Report_22D2->CurrentFilter = $Kitchen_Report_22D2_report->sFilter; $Kitchen_Report_22D2_report->sSql = $Kitchen_Report_22D2->DetailSQL(); // Load detail records $rsdtl = $conn->Execute($Kitchen_Report_22D2_report->sSql); $Kitchen_Report_22D2_report->nDtlRecs = $rsdtl->RecordCount(); // Initialize Aggregate if (!$rsdtl->EOF) {
function AddRow($rsold = NULL) { global $conn, $Language, $Security; // Check if valid key values for master user if ($Security->CurrentUserID() != "" && !$Security->IsAdmin()) { // Non system admin $sMasterFilter = $this->SqlMasterFilter_socios(); if (strval($this->id_socio->CurrentValue) != "" && $this->getCurrentMasterTable() == "socios") { $sMasterFilter = str_replace("@socio_nro@", ew_AdjustSql($this->id_socio->CurrentValue), $sMasterFilter); } else { $sMasterFilter = ""; } if ($sMasterFilter != "") { $rsmaster = $GLOBALS["socios"]->LoadRs($sMasterFilter); $this->MasterRecordExists = $rsmaster && !$rsmaster->EOF; if (!$this->MasterRecordExists) { $sMasterUserIdMsg = str_replace("%c", CurrentUserID(), $Language->Phrase("UnAuthorizedMasterUserID")); $sMasterUserIdMsg = str_replace("%f", $sMasterFilter, $sMasterUserIdMsg); $this->setFailureMessage($sMasterUserIdMsg); return FALSE; } else { $rsmaster->Close(); } } } // Check referential integrity for master table 'socios' $bValidMasterRecord = TRUE; $sMasterFilter = $this->SqlMasterFilter_socios(); if (strval($this->id_socio->CurrentValue) != "") { $sMasterFilter = str_replace("@socio_nro@", ew_AdjustSql($this->id_socio->CurrentValue), $sMasterFilter); } else { $bValidMasterRecord = FALSE; } if ($bValidMasterRecord) { $rsmaster = $GLOBALS["socios"]->LoadRs($sMasterFilter); $bValidMasterRecord = $rsmaster && !$rsmaster->EOF; $rsmaster->Close(); } if (!$bValidMasterRecord) { $sRelatedRecordMsg = str_replace("%t", "socios", $Language->Phrase("RelatedRecordRequired")); $this->setFailureMessage($sRelatedRecordMsg); return FALSE; } // Begin transaction if ($this->getCurrentDetailTable() != "") { $conn->BeginTrans(); } // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); } $rsnew = array(); // mes $this->mes->SetDbValueDef($rsnew, $this->mes->CurrentValue, NULL, FALSE); // anio $this->anio->SetDbValueDef($rsnew, $this->anio->CurrentValue, NULL, FALSE); // fecha $this->fecha->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->fecha->CurrentValue, 7), NULL, FALSE); // monto $this->monto->SetDbValueDef($rsnew, $this->monto->CurrentValue, NULL, FALSE); // id_socio $this->id_socio->SetDbValueDef($rsnew, $this->id_socio->CurrentValue, NULL, FALSE); // id_usuario if (!$Security->IsAdmin() && $Security->IsLoggedIn()) { // Non system admin $rsnew['id_usuario'] = CurrentUserID(); } // Call Row Inserting event $rs = $rsold == NULL ? NULL : $rsold->fields; $bInsertRow = $this->Row_Inserting($rs, $rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $this->Insert($rsnew); $conn->raiseErrorFn = ''; if ($AddRow) { } } else { if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") { // Use the message, do nothing } elseif ($this->CancelMessage != "") { $this->setFailureMessage($this->CancelMessage); $this->CancelMessage = ""; } else { $this->setFailureMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } // Get insert id if necessary if ($AddRow) { $this->id->setDbValue($conn->Insert_ID()); $rsnew['id'] = $this->id->DbValue; } // Add detail records if ($AddRow) { $DetailTblVar = explode(",", $this->getCurrentDetailTable()); if (in_array("detalle_deudas", $DetailTblVar) && $GLOBALS["detalle_deudas"]->DetailAdd) { $GLOBALS["detalle_deudas"]->id_deuda->setSessionValue($this->id->CurrentValue); // Set master key if (!isset($GLOBALS["detalle_deudas_grid"])) { $GLOBALS["detalle_deudas_grid"] = new cdetalle_deudas_grid(); } // Get detail page object $AddRow = $GLOBALS["detalle_deudas_grid"]->GridInsert(); if (!$AddRow) { $GLOBALS["detalle_deudas"]->id_deuda->setSessionValue(""); } // Clear master key if insert failed } if (in_array("pagos", $DetailTblVar) && $GLOBALS["pagos"]->DetailAdd) { $GLOBALS["pagos"]->id_deuda->setSessionValue($this->id->CurrentValue); // Set master key if (!isset($GLOBALS["pagos_grid"])) { $GLOBALS["pagos_grid"] = new cpagos_grid(); } // Get detail page object $AddRow = $GLOBALS["pagos_grid"]->GridInsert(); if (!$AddRow) { $GLOBALS["pagos"]->id_deuda->setSessionValue(""); } // Clear master key if insert failed } } // Commit/Rollback transaction if ($this->getCurrentDetailTable() != "") { if ($AddRow) { $conn->CommitTrans(); // Commit transaction } else { $conn->RollbackTrans(); // Rollback transaction } } if ($AddRow) { // Call Row Inserted event $rs = $rsold == NULL ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); $this->WriteAuditTrailOnAdd($rsnew); } return $AddRow; }
function LoadRowValues(&$rs) { global $conn; if (!$rs || $rs->EOF) { return; } // Call Row Selected event $row =& $rs->fields; $this->Row_Selected($row); $this->id->setDbValue($rs->fields('id')); $this->mes->setDbValue($rs->fields('mes')); $this->anio->setDbValue($rs->fields('anio')); $this->fecha->setDbValue($rs->fields('fecha')); $this->monto->setDbValue($rs->fields('monto')); $this->id_usuario->setDbValue($rs->fields('id_usuario')); $this->id_socio->setDbValue($rs->fields('id_socio')); if (!isset($GLOBALS["detalle_deudas_grid"])) { $GLOBALS["detalle_deudas_grid"] = new cdetalle_deudas_grid(); } $sDetailFilter = $GLOBALS["detalle_deudas"]->SqlDetailFilter_deudas(); $sDetailFilter = str_replace("@id_deuda@", ew_AdjustSql($this->id->DbValue), $sDetailFilter); $GLOBALS["detalle_deudas"]->setCurrentMasterTable("deudas"); $sDetailFilter = $GLOBALS["detalle_deudas"]->ApplyUserIDFilters($sDetailFilter); $this->detalle_deudas_Count = $GLOBALS["detalle_deudas"]->LoadRecordCount($sDetailFilter); if (!isset($GLOBALS["pagos_grid"])) { $GLOBALS["pagos_grid"] = new cpagos_grid(); } $sDetailFilter = $GLOBALS["pagos"]->SqlDetailFilter_deudas(); $sDetailFilter = str_replace("@id_deuda@", ew_AdjustSql($this->id->DbValue), $sDetailFilter); $GLOBALS["pagos"]->setCurrentMasterTable("deudas"); $sDetailFilter = $GLOBALS["pagos"]->ApplyUserIDFilters($sDetailFilter); $this->pagos_Count = $GLOBALS["pagos"]->LoadRecordCount($sDetailFilter); }
function BasicSearchSQL($Keyword) { $sKeyword = ew_AdjustSql($Keyword); $sWhere = ""; $this->BuildBasicSearchSQL($sWhere, $this->mes, $Keyword); $this->BuildBasicSearchSQL($sWhere, $this->anio, $Keyword); return $sWhere; }
function BasicSearchSQL($Keyword) { global $order; $sKeyword = ew_AdjustSql($Keyword); $sWhere = ""; $this->BuildBasicSearchSQL($sWhere, $order->zemail, $Keyword); return $sWhere; }
<?php echo $Report1->dtime->ViewValue; ?> </span> </td></tr> <?php } // Get detail records $Report1_report->ReportFilter = $Report1_report->DefaultFilter; if ($Report1_report->ReportFilter != "") { $Report1_report->ReportFilter .= " AND "; } if (is_null($Report1->dtime->CurrentValue)) { $Report1_report->ReportFilter .= "(`dtime` IS NULL)"; } else { $Report1_report->ReportFilter .= "(`dtime` = '" . ew_AdjustSql($Report1->dtime->CurrentValue) . "')"; } if ($Report1_report->DbDetailFilter != "") { if ($Report1_report->ReportFilter != "") { $Report1_report->ReportFilter .= " AND "; } $Report1_report->ReportFilter .= "(" . $Report1_report->DbDetailFilter . ")"; } if (!$Security->CanReport()) { if ($sFilter != "") { $sFilter .= " AND "; } $sFilter .= "(0=1)"; } // Set up detail SQL $Report1->CurrentFilter = $Report1_report->ReportFilter;
function AddRow($rsold = NULL) { global $conn, $Language, $Security; // Check referential integrity for master table 'servicio_medico' $bValidMasterRecord = TRUE; $sMasterFilter = $this->SqlMasterFilter_servicio_medico(); if (strval($this->idservicio_medico->CurrentValue) != "") { $sMasterFilter = str_replace("@idservicio_medico@", ew_AdjustSql($this->idservicio_medico->CurrentValue), $sMasterFilter); } else { $bValidMasterRecord = FALSE; } if ($bValidMasterRecord) { $rsmaster = $GLOBALS["servicio_medico"]->LoadRs($sMasterFilter); $bValidMasterRecord = $rsmaster && !$rsmaster->EOF; $rsmaster->Close(); } if (!$bValidMasterRecord) { $sRelatedRecordMsg = str_replace("%t", "servicio_medico", $Language->Phrase("RelatedRecordRequired")); $this->setFailureMessage($sRelatedRecordMsg); return FALSE; } // Begin transaction if ($this->getCurrentDetailTable() != "") { $conn->BeginTrans(); } // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); } $rsnew = array(); // idcuenta $this->idcuenta->SetDbValueDef($rsnew, $this->idcuenta->CurrentValue, NULL, FALSE); // idservicio_medico $this->idservicio_medico->SetDbValueDef($rsnew, $this->idservicio_medico->CurrentValue, 0, strval($this->idservicio_medico->CurrentValue) == ""); // costo $this->costo->SetDbValueDef($rsnew, $this->costo->CurrentValue, 0, strval($this->costo->CurrentValue) == ""); // Call Row Inserting event $rs = $rsold == NULL ? NULL : $rsold->fields; $bInsertRow = $this->Row_Inserting($rs, $rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $this->Insert($rsnew); $conn->raiseErrorFn = ''; if ($AddRow) { } } else { if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") { // Use the message, do nothing } elseif ($this->CancelMessage != "") { $this->setFailureMessage($this->CancelMessage); $this->CancelMessage = ""; } else { $this->setFailureMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } // Get insert id if necessary if ($AddRow) { $this->idservicio_medico_prestado->setDbValue($conn->Insert_ID()); $rsnew['idservicio_medico_prestado'] = $this->idservicio_medico_prestado->DbValue; } // Add detail records if ($AddRow) { $DetailTblVar = explode(",", $this->getCurrentDetailTable()); if (in_array("doctor_servicio_medico_prestado", $DetailTblVar) && $GLOBALS["doctor_servicio_medico_prestado"]->DetailAdd) { $GLOBALS["doctor_servicio_medico_prestado"]->idservicio_medico_prestado->setSessionValue($this->idservicio_medico_prestado->CurrentValue); // Set master key if (!isset($GLOBALS["doctor_servicio_medico_prestado_grid"])) { $GLOBALS["doctor_servicio_medico_prestado_grid"] = new cdoctor_servicio_medico_prestado_grid(); } // Get detail page object $AddRow = $GLOBALS["doctor_servicio_medico_prestado_grid"]->GridInsert(); if (!$AddRow) { $GLOBALS["doctor_servicio_medico_prestado"]->idservicio_medico_prestado->setSessionValue(""); } // Clear master key if insert failed } } // Commit/Rollback transaction if ($this->getCurrentDetailTable() != "") { if ($AddRow) { $conn->CommitTrans(); // Commit transaction } else { $conn->RollbackTrans(); // Rollback transaction } } if ($AddRow) { // Call Row Inserted event $rs = $rsold == NULL ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); } return $AddRow; }
function AddRow($rsold = NULL) { global $conn, $Language, $Security; // Check referential integrity for master table 'tramites' $bValidMasterRecord = TRUE; $sMasterFilter = $this->SqlMasterFilter_tramites(); if (strval($this->id_tramite->CurrentValue) != "") { $sMasterFilter = str_replace("@codigo@", ew_AdjustSql($this->id_tramite->CurrentValue), $sMasterFilter); } else { $bValidMasterRecord = FALSE; } if ($bValidMasterRecord) { $rsmaster = $GLOBALS["tramites"]->LoadRs($sMasterFilter); $bValidMasterRecord = $rsmaster && !$rsmaster->EOF; $rsmaster->Close(); } if (!$bValidMasterRecord) { $sRelatedRecordMsg = str_replace("%t", "tramites", $Language->Phrase("RelatedRecordRequired")); $this->setFailureMessage($sRelatedRecordMsg); return FALSE; } // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); } $rsnew = array(); // id_tramite $this->id_tramite->SetDbValueDef($rsnew, $this->id_tramite->CurrentValue, 0, FALSE); // fecha $this->fecha->SetDbValueDef($rsnew, ew_CurrentDate(), ew_CurrentDate()); $rsnew['fecha'] =& $this->fecha->DbValue; // hora $this->hora->SetDbValueDef($rsnew, ew_CurrentTime(), ew_CurrentTime()); $rsnew['hora'] =& $this->hora->DbValue; // titulo $this->titulo->SetDbValueDef($rsnew, $this->titulo->CurrentValue, NULL, FALSE); // archivo if (!$this->archivo->Upload->KeepFile) { $this->archivo->Upload->DbValue = ""; // No need to delete old file if ($this->archivo->Upload->FileName == "") { $rsnew['archivo'] = NULL; } else { $rsnew['archivo'] = $this->archivo->Upload->FileName; } } if (!$this->archivo->Upload->KeepFile) { $OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->DbValue); if (!ew_Empty($this->archivo->Upload->FileName)) { $NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->FileName); $FileCount = count($NewFiles); for ($i = 0; $i < $FileCount; $i++) { $fldvar = $this->archivo->Upload->Index < 0 ? $this->archivo->FldVar : substr($this->archivo->FldVar, 0, 1) . $this->archivo->Upload->Index . substr($this->archivo->FldVar, 1); if ($NewFiles[$i] != "") { $file = $NewFiles[$i]; if (file_exists(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file)) { if (!in_array($file, $OldFiles)) { $file1 = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->archivo->UploadPath), $file); // Get new file name if ($file1 != $file) { // Rename temp file while (file_exists(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file1)) { // Make sure did not clash with existing upload file $file1 = ew_UniqueFilename(ew_UploadPathEx(TRUE, $this->archivo->UploadPath), $file1, TRUE); } // Use indexed name rename(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file, ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file1); $NewFiles[$i] = $file1; } } } } } $this->archivo->Upload->FileName = implode(EW_MULTIPLE_UPLOAD_SEPARATOR, $NewFiles); $rsnew['archivo'] = $this->archivo->Upload->FileName; } else { $NewFiles = array(); } } // Call Row Inserting event $rs = $rsold == NULL ? NULL : $rsold->fields; $bInsertRow = $this->Row_Inserting($rs, $rsnew); // Check if key value entered if ($bInsertRow && $this->ValidateKey && strval($rsnew['id_tramite']) == "") { $this->setFailureMessage($Language->Phrase("InvalidKeyValue")); $bInsertRow = FALSE; } // Check if key value entered if ($bInsertRow && $this->ValidateKey && strval($rsnew['fecha']) == "") { $this->setFailureMessage($Language->Phrase("InvalidKeyValue")); $bInsertRow = FALSE; } // Check if key value entered if ($bInsertRow && $this->ValidateKey && strval($rsnew['hora']) == "") { $this->setFailureMessage($Language->Phrase("InvalidKeyValue")); $bInsertRow = FALSE; } // Check for duplicate key if ($bInsertRow && $this->ValidateKey) { $sFilter = $this->KeyFilter(); $rsChk = $this->LoadRs($sFilter); if ($rsChk && !$rsChk->EOF) { $sKeyErrMsg = str_replace("%f", $sFilter, $Language->Phrase("DupKey")); $this->setFailureMessage($sKeyErrMsg); $rsChk->Close(); $bInsertRow = FALSE; } } if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $this->Insert($rsnew); $conn->raiseErrorFn = ''; if ($AddRow) { if (!$this->archivo->Upload->KeepFile) { $OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->DbValue); if (!ew_Empty($this->archivo->Upload->FileName)) { $NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->FileName); $NewFiles2 = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $rsnew['archivo']); $FileCount = count($NewFiles); for ($i = 0; $i < $FileCount; $i++) { $fldvar = $this->archivo->Upload->Index < 0 ? $this->archivo->FldVar : substr($this->archivo->FldVar, 0, 1) . $this->archivo->Upload->Index . substr($this->archivo->FldVar, 1); if ($NewFiles[$i] != "") { $file = ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $NewFiles[$i]; if (file_exists($file)) { $this->archivo->Upload->SaveToFile($this->archivo->UploadPath, @$NewFiles2[$i] != "" ? $NewFiles2[$i] : $NewFiles[$i], TRUE, $i); // Just replace } } } } else { $NewFiles = array(); } $FileCount = count($OldFiles); for ($i = 0; $i < $FileCount; $i++) { if ($OldFiles[$i] != "" && !in_array($OldFiles[$i], $NewFiles)) { @unlink(ew_UploadPathEx(TRUE, $this->archivo->OldUploadPath) . $OldFiles[$i]); } } } } } else { if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") { // Use the message, do nothing } elseif ($this->CancelMessage != "") { $this->setFailureMessage($this->CancelMessage); $this->CancelMessage = ""; } else { $this->setFailureMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } // Get insert id if necessary if ($AddRow) { } if ($AddRow) { // Call Row Inserted event $rs = $rsold == NULL ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); } // archivo ew_CleanUploadTempPath($this->archivo, $this->archivo->Upload->Index); return $AddRow; }
function KeyFilter() { $sKeyFilter = $this->SqlKeyFilter(); if (!is_numeric($this->CARD_TYPE_ID->CurrentValue)) { $sKeyFilter = "0=1"; } // Invalid key $sKeyFilter = str_replace("@CARD_TYPE_ID@", ew_AdjustSql($this->CARD_TYPE_ID->CurrentValue, $this->DBID), $sKeyFilter); // Replace key value return $sKeyFilter; }
function BasicSearchSQL($Keyword) { $sKeyword = ew_AdjustSql($Keyword); $sWhere = ""; $this->BuildBasicSearchSQL($sWhere, $this->news_title, $Keyword); $this->BuildBasicSearchSQL($sWhere, $this->news_description, $Keyword); return $sWhere; }
function Page_Main() { global $PromoCodes; // Load Key Parameters $sKey = ""; $bSingleDelete = TRUE; // Initialize as single delete $nKeySelected = 0; // Initialize selected key count $sFilter = ""; if (@$_GET["PromoCodeID"] != "") { $PromoCodes->PromoCodeID->setQueryStringValue($_GET["PromoCodeID"]); if (!is_numeric($PromoCodes->PromoCodeID->QueryStringValue)) { $this->Page_Terminate("PromoCodeslist.php"); } // Prevent SQL injection, exit $sKey .= $PromoCodes->PromoCodeID->QueryStringValue; } else { $bSingleDelete = FALSE; } if ($bSingleDelete) { $nKeySelected = 1; // Set up key selected count $this->arRecKeys[0] = $sKey; } else { if (isset($_POST["key_m"])) { // Key in form $nKeySelected = count($_POST["key_m"]); // Set up key selected count $this->arRecKeys = ew_StripSlashes($_POST["key_m"]); } } if ($nKeySelected <= 0) { $this->Page_Terminate("PromoCodeslist.php"); } // No key specified, return to list // Build filter foreach ($this->arRecKeys as $sKey) { $sFilter .= "("; // Set up key field $sKeyFld = $sKey; if (!is_numeric($sKeyFld)) { $this->Page_Terminate("PromoCodeslist.php"); } // Prevent SQL injection, return to list $sFilter .= "`PromoCodeID`=" . ew_AdjustSql($sKeyFld) . " AND "; if (substr($sFilter, -5) == " AND ") { $sFilter = substr($sFilter, 0, strlen($sFilter) - 5) . ") OR "; } } if (substr($sFilter, -4) == " OR ") { $sFilter = substr($sFilter, 0, strlen($sFilter) - 4); } // Set up filter (SQL WhHERE clause) and get return SQL // SQL constructor in SQL constructor in PromoCodes class, PromoCodesinfo.php $PromoCodes->CurrentFilter = $sFilter; // Get action if (@$_POST["a_delete"] != "") { $PromoCodes->CurrentAction = $_POST["a_delete"]; } else { $PromoCodes->CurrentAction = "I"; // Display record } switch ($PromoCodes->CurrentAction) { case "D": // Delete $PromoCodes->SendEmail = TRUE; // Send email on delete success if ($this->DeleteRows()) { // delete rows $this->setMessage("Delete succeeded"); // Set up success message $this->Page_Terminate($PromoCodes->getReturnUrl()); // Return to caller } } }
function BasicSearchSQL($Keyword) { global $Allergies; $sKeyword = ew_AdjustSql($Keyword); $sql = ""; $sql .= $Allergies->name->FldExpression . " LIKE '%" . $sKeyword . "%' OR "; $sql .= $Allergies->code->FldExpression . " LIKE '%" . $sKeyword . "%' OR "; if (substr($sql, -4) == " OR ") { $sql = substr($sql, 0, strlen($sql) - 4); } return $sql; }
function RenderRow() { global $conn, $Security, $GiftCertificates; // Call Row_Rendering event $GiftCertificates->Row_Rendering(); // Common render codes for all row types // CustomerID $GiftCertificates->CustomerID->CellCssStyle = ""; $GiftCertificates->CustomerID->CellCssClass = ""; // GiftEmail $GiftCertificates->GiftEmail->CellCssStyle = ""; $GiftCertificates->GiftEmail->CellCssClass = ""; // GiftPhone $GiftCertificates->GiftPhone->CellCssStyle = ""; $GiftCertificates->GiftPhone->CellCssClass = ""; // GiftFirstName $GiftCertificates->GiftFirstName->CellCssStyle = ""; $GiftCertificates->GiftFirstName->CellCssClass = ""; // GiftLastName $GiftCertificates->GiftLastName->CellCssStyle = ""; $GiftCertificates->GiftLastName->CellCssClass = ""; // GiftAmount $GiftCertificates->GiftAmount->CellCssStyle = ""; $GiftCertificates->GiftAmount->CellCssClass = ""; // GiftMessage $GiftCertificates->GiftMessage->CellCssStyle = ""; $GiftCertificates->GiftMessage->CellCssClass = ""; // GiftSendMethod $GiftCertificates->GiftSendMethod->CellCssStyle = ""; $GiftCertificates->GiftSendMethod->CellCssClass = ""; // GiftSendAddress1 $GiftCertificates->GiftSendAddress1->CellCssStyle = ""; $GiftCertificates->GiftSendAddress1->CellCssClass = ""; // GiftSendAddress2 $GiftCertificates->GiftSendAddress2->CellCssStyle = ""; $GiftCertificates->GiftSendAddress2->CellCssClass = ""; // GiftSendCity $GiftCertificates->GiftSendCity->CellCssStyle = ""; $GiftCertificates->GiftSendCity->CellCssClass = ""; // GiftSendState $GiftCertificates->GiftSendState->CellCssStyle = ""; $GiftCertificates->GiftSendState->CellCssClass = ""; // GiftSendZip $GiftCertificates->GiftSendZip->CellCssStyle = ""; $GiftCertificates->GiftSendZip->CellCssClass = ""; // GiftSendEmail $GiftCertificates->GiftSendEmail->CellCssStyle = ""; $GiftCertificates->GiftSendEmail->CellCssClass = ""; // PromoCodeID $GiftCertificates->PromoCodeID->CellCssStyle = ""; $GiftCertificates->PromoCodeID->CellCssClass = ""; if ($GiftCertificates->RowType == EW_ROWTYPE_VIEW) { // View row // GiftCertificateID $GiftCertificates->GiftCertificateID->ViewValue = $GiftCertificates->GiftCertificateID->CurrentValue; $GiftCertificates->GiftCertificateID->CssStyle = ""; $GiftCertificates->GiftCertificateID->CssClass = ""; $GiftCertificates->GiftCertificateID->ViewCustomAttributes = ""; // CustomerID $GiftCertificates->CustomerID->ViewValue = $GiftCertificates->CustomerID->CurrentValue; if (strval($GiftCertificates->CustomerID->CurrentValue) != "") { $sSqlWrk = "SELECT `Email` FROM `Customers` WHERE `CustomerID` = " . ew_AdjustSql($GiftCertificates->CustomerID->CurrentValue) . ""; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $GiftCertificates->CustomerID->ViewValue = $rswrk->fields('Email'); $rswrk->Close(); } else { $GiftCertificates->CustomerID->ViewValue = $GiftCertificates->CustomerID->CurrentValue; } } else { $GiftCertificates->CustomerID->ViewValue = NULL; } $GiftCertificates->CustomerID->CssStyle = ""; $GiftCertificates->CustomerID->CssClass = ""; $GiftCertificates->CustomerID->ViewCustomAttributes = ""; // GiftEmail $GiftCertificates->GiftEmail->ViewValue = $GiftCertificates->GiftEmail->CurrentValue; $GiftCertificates->GiftEmail->CssStyle = ""; $GiftCertificates->GiftEmail->CssClass = ""; $GiftCertificates->GiftEmail->ViewCustomAttributes = ""; // GiftPhone $GiftCertificates->GiftPhone->ViewValue = $GiftCertificates->GiftPhone->CurrentValue; $GiftCertificates->GiftPhone->CssStyle = ""; $GiftCertificates->GiftPhone->CssClass = ""; $GiftCertificates->GiftPhone->ViewCustomAttributes = ""; // GiftFirstName $GiftCertificates->GiftFirstName->ViewValue = $GiftCertificates->GiftFirstName->CurrentValue; $GiftCertificates->GiftFirstName->CssStyle = ""; $GiftCertificates->GiftFirstName->CssClass = ""; $GiftCertificates->GiftFirstName->ViewCustomAttributes = ""; // GiftLastName $GiftCertificates->GiftLastName->ViewValue = $GiftCertificates->GiftLastName->CurrentValue; $GiftCertificates->GiftLastName->CssStyle = ""; $GiftCertificates->GiftLastName->CssClass = ""; $GiftCertificates->GiftLastName->ViewCustomAttributes = ""; // GiftAmount $GiftCertificates->GiftAmount->ViewValue = $GiftCertificates->GiftAmount->CurrentValue; $GiftCertificates->GiftAmount->CssStyle = ""; $GiftCertificates->GiftAmount->CssClass = ""; $GiftCertificates->GiftAmount->ViewCustomAttributes = ""; // GiftMessage $GiftCertificates->GiftMessage->ViewValue = $GiftCertificates->GiftMessage->CurrentValue; $GiftCertificates->GiftMessage->CssStyle = ""; $GiftCertificates->GiftMessage->CssClass = ""; $GiftCertificates->GiftMessage->ViewCustomAttributes = ""; // GiftSendMethod if (strval($GiftCertificates->GiftSendMethod->CurrentValue) != "") { switch ($GiftCertificates->GiftSendMethod->CurrentValue) { case "0": $GiftCertificates->GiftSendMethod->ViewValue = "Email To Buyer"; break; case "1": $GiftCertificates->GiftSendMethod->ViewValue = "Email to Recipient"; break; case "2": $GiftCertificates->GiftSendMethod->ViewValue = "Mail plastic card to Buyer"; break; case "3": $GiftCertificates->GiftSendMethod->ViewValue = "Mail plastic card to Recipient"; break; default: $GiftCertificates->GiftSendMethod->ViewValue = $GiftCertificates->GiftSendMethod->CurrentValue; } } else { $GiftCertificates->GiftSendMethod->ViewValue = NULL; } $GiftCertificates->GiftSendMethod->CssStyle = ""; $GiftCertificates->GiftSendMethod->CssClass = ""; $GiftCertificates->GiftSendMethod->ViewCustomAttributes = ""; // GiftSendAddress1 $GiftCertificates->GiftSendAddress1->ViewValue = $GiftCertificates->GiftSendAddress1->CurrentValue; $GiftCertificates->GiftSendAddress1->CssStyle = ""; $GiftCertificates->GiftSendAddress1->CssClass = ""; $GiftCertificates->GiftSendAddress1->ViewCustomAttributes = ""; // GiftSendAddress2 $GiftCertificates->GiftSendAddress2->ViewValue = $GiftCertificates->GiftSendAddress2->CurrentValue; $GiftCertificates->GiftSendAddress2->CssStyle = ""; $GiftCertificates->GiftSendAddress2->CssClass = ""; $GiftCertificates->GiftSendAddress2->ViewCustomAttributes = ""; // GiftSendCity $GiftCertificates->GiftSendCity->ViewValue = $GiftCertificates->GiftSendCity->CurrentValue; $GiftCertificates->GiftSendCity->CssStyle = ""; $GiftCertificates->GiftSendCity->CssClass = ""; $GiftCertificates->GiftSendCity->ViewCustomAttributes = ""; // GiftSendState $GiftCertificates->GiftSendState->ViewValue = $GiftCertificates->GiftSendState->CurrentValue; $GiftCertificates->GiftSendState->CssStyle = ""; $GiftCertificates->GiftSendState->CssClass = ""; $GiftCertificates->GiftSendState->ViewCustomAttributes = ""; // GiftSendZip $GiftCertificates->GiftSendZip->ViewValue = $GiftCertificates->GiftSendZip->CurrentValue; $GiftCertificates->GiftSendZip->CssStyle = ""; $GiftCertificates->GiftSendZip->CssClass = ""; $GiftCertificates->GiftSendZip->ViewCustomAttributes = ""; // GiftSendEmail $GiftCertificates->GiftSendEmail->ViewValue = $GiftCertificates->GiftSendEmail->CurrentValue; $GiftCertificates->GiftSendEmail->CssStyle = ""; $GiftCertificates->GiftSendEmail->CssClass = ""; $GiftCertificates->GiftSendEmail->ViewCustomAttributes = ""; // PromoCodeID $GiftCertificates->PromoCodeID->ViewValue = $GiftCertificates->PromoCodeID->CurrentValue; if (strval($GiftCertificates->PromoCodeID->CurrentValue) != "") { $sSqlWrk = "SELECT `PromoCodeName` FROM `PromoCodes` WHERE `PromoCodeID` = " . ew_AdjustSql($GiftCertificates->PromoCodeID->CurrentValue) . ""; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $GiftCertificates->PromoCodeID->ViewValue = $rswrk->fields('PromoCodeName'); $rswrk->Close(); } else { $GiftCertificates->PromoCodeID->ViewValue = $GiftCertificates->PromoCodeID->CurrentValue; } } else { $GiftCertificates->PromoCodeID->ViewValue = NULL; } $GiftCertificates->PromoCodeID->CssStyle = ""; $GiftCertificates->PromoCodeID->CssClass = ""; $GiftCertificates->PromoCodeID->ViewCustomAttributes = ""; // CustomerID $GiftCertificates->CustomerID->HrefValue = ""; // GiftEmail $GiftCertificates->GiftEmail->HrefValue = ""; // GiftPhone $GiftCertificates->GiftPhone->HrefValue = ""; // GiftFirstName $GiftCertificates->GiftFirstName->HrefValue = ""; // GiftLastName $GiftCertificates->GiftLastName->HrefValue = ""; // GiftAmount $GiftCertificates->GiftAmount->HrefValue = ""; // GiftMessage $GiftCertificates->GiftMessage->HrefValue = ""; // GiftSendMethod $GiftCertificates->GiftSendMethod->HrefValue = ""; // GiftSendAddress1 $GiftCertificates->GiftSendAddress1->HrefValue = ""; // GiftSendAddress2 $GiftCertificates->GiftSendAddress2->HrefValue = ""; // GiftSendCity $GiftCertificates->GiftSendCity->HrefValue = ""; // GiftSendState $GiftCertificates->GiftSendState->HrefValue = ""; // GiftSendZip $GiftCertificates->GiftSendZip->HrefValue = ""; // GiftSendEmail $GiftCertificates->GiftSendEmail->HrefValue = ""; // PromoCodeID $GiftCertificates->PromoCodeID->HrefValue = ""; } elseif ($GiftCertificates->RowType == EW_ROWTYPE_ADD) { // Add row // CustomerID $GiftCertificates->CustomerID->EditCustomAttributes = ""; if ($GiftCertificates->CustomerID->getSessionValue() != "") { $GiftCertificates->CustomerID->CurrentValue = $GiftCertificates->CustomerID->getSessionValue(); $GiftCertificates->CustomerID->ViewValue = $GiftCertificates->CustomerID->CurrentValue; if (strval($GiftCertificates->CustomerID->CurrentValue) != "") { $sSqlWrk = "SELECT `Email` FROM `Customers` WHERE `CustomerID` = " . ew_AdjustSql($GiftCertificates->CustomerID->CurrentValue) . ""; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $GiftCertificates->CustomerID->ViewValue = $rswrk->fields('Email'); $rswrk->Close(); } else { $GiftCertificates->CustomerID->ViewValue = $GiftCertificates->CustomerID->CurrentValue; } } else { $GiftCertificates->CustomerID->ViewValue = NULL; } $GiftCertificates->CustomerID->CssStyle = ""; $GiftCertificates->CustomerID->CssClass = ""; $GiftCertificates->CustomerID->ViewCustomAttributes = ""; } else { $GiftCertificates->CustomerID->EditValue = ew_HtmlEncode($GiftCertificates->CustomerID->CurrentValue); if (strval($GiftCertificates->CustomerID->CurrentValue) != "") { $sSqlWrk = "SELECT `Email` FROM `Customers` WHERE `CustomerID` = " . ew_AdjustSql($GiftCertificates->CustomerID->CurrentValue) . ""; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $GiftCertificates->CustomerID->EditValue = $rswrk->fields('Email'); $rswrk->Close(); } else { $GiftCertificates->CustomerID->EditValue = $GiftCertificates->CustomerID->CurrentValue; } } else { $GiftCertificates->CustomerID->EditValue = NULL; } } // GiftEmail $GiftCertificates->GiftEmail->EditCustomAttributes = ""; $GiftCertificates->GiftEmail->EditValue = ew_HtmlEncode($GiftCertificates->GiftEmail->CurrentValue); // GiftPhone $GiftCertificates->GiftPhone->EditCustomAttributes = ""; $GiftCertificates->GiftPhone->EditValue = ew_HtmlEncode($GiftCertificates->GiftPhone->CurrentValue); // GiftFirstName $GiftCertificates->GiftFirstName->EditCustomAttributes = ""; $GiftCertificates->GiftFirstName->EditValue = ew_HtmlEncode($GiftCertificates->GiftFirstName->CurrentValue); // GiftLastName $GiftCertificates->GiftLastName->EditCustomAttributes = ""; $GiftCertificates->GiftLastName->EditValue = ew_HtmlEncode($GiftCertificates->GiftLastName->CurrentValue); // GiftAmount $GiftCertificates->GiftAmount->EditCustomAttributes = ""; $GiftCertificates->GiftAmount->EditValue = ew_HtmlEncode($GiftCertificates->GiftAmount->CurrentValue); // GiftMessage $GiftCertificates->GiftMessage->EditCustomAttributes = ""; $GiftCertificates->GiftMessage->EditValue = ew_HtmlEncode($GiftCertificates->GiftMessage->CurrentValue); // GiftSendMethod $GiftCertificates->GiftSendMethod->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array("0", "Email To Buyer"); $arwrk[] = array("1", "Email to Recipient"); $arwrk[] = array("2", "Mail plastic card to Buyer"); $arwrk[] = array("3", "Mail plastic card to Recipient"); array_unshift($arwrk, array("", "Please Select")); $GiftCertificates->GiftSendMethod->EditValue = $arwrk; // GiftSendAddress1 $GiftCertificates->GiftSendAddress1->EditCustomAttributes = ""; $GiftCertificates->GiftSendAddress1->EditValue = ew_HtmlEncode($GiftCertificates->GiftSendAddress1->CurrentValue); // GiftSendAddress2 $GiftCertificates->GiftSendAddress2->EditCustomAttributes = ""; $GiftCertificates->GiftSendAddress2->EditValue = ew_HtmlEncode($GiftCertificates->GiftSendAddress2->CurrentValue); // GiftSendCity $GiftCertificates->GiftSendCity->EditCustomAttributes = ""; $GiftCertificates->GiftSendCity->EditValue = ew_HtmlEncode($GiftCertificates->GiftSendCity->CurrentValue); // GiftSendState $GiftCertificates->GiftSendState->EditCustomAttributes = ""; $GiftCertificates->GiftSendState->EditValue = ew_HtmlEncode($GiftCertificates->GiftSendState->CurrentValue); // GiftSendZip $GiftCertificates->GiftSendZip->EditCustomAttributes = ""; $GiftCertificates->GiftSendZip->EditValue = ew_HtmlEncode($GiftCertificates->GiftSendZip->CurrentValue); // GiftSendEmail $GiftCertificates->GiftSendEmail->EditCustomAttributes = ""; $GiftCertificates->GiftSendEmail->EditValue = ew_HtmlEncode($GiftCertificates->GiftSendEmail->CurrentValue); // PromoCodeID $GiftCertificates->PromoCodeID->EditCustomAttributes = ""; $GiftCertificates->PromoCodeID->EditValue = ew_HtmlEncode($GiftCertificates->PromoCodeID->CurrentValue); if (strval($GiftCertificates->PromoCodeID->CurrentValue) != "") { $sSqlWrk = "SELECT `PromoCodeName` FROM `PromoCodes` WHERE `PromoCodeID` = " . ew_AdjustSql($GiftCertificates->PromoCodeID->CurrentValue) . ""; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $GiftCertificates->PromoCodeID->EditValue = $rswrk->fields('PromoCodeName'); $rswrk->Close(); } else { $GiftCertificates->PromoCodeID->EditValue = $GiftCertificates->PromoCodeID->CurrentValue; } } else { $GiftCertificates->PromoCodeID->EditValue = NULL; } } // Call Row Rendered event $GiftCertificates->Row_Rendered(); }
function EditRow() { global $conn, $Security, $categories; $sFilter = $categories->SqlKeyFilter(); if (!is_numeric($categories->id->CurrentValue)) { return FALSE; } $sFilter = str_replace("@id@", ew_AdjustSql($categories->id->CurrentValue), $sFilter); // Replace key value $categories->CurrentFilter = $sFilter; $sSql = $categories->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(); // Field id // Field name $categories->name->SetDbValueDef($categories->name->CurrentValue, NULL); $rsnew['name'] =& $categories->name->DbValue; // Field keywords $categories->keywords->SetDbValueDef($categories->keywords->CurrentValue, NULL); $rsnew['keywords'] =& $categories->keywords->DbValue; // Call Row Updating event $bUpdateRow = $categories->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($categories->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($categories->CancelMessage != "") { $_SESSION[EW_SESSION_MESSAGE] = $categories->CancelMessage; $categories->CancelMessage = ""; } else { $_SESSION[EW_SESSION_MESSAGE] = "Update cancelled"; } $EditRow = FALSE; } } // Call Row Updated event if ($EditRow) { $categories->Row_Updated($rsold, $rsnew); } $rs->Close(); return $EditRow; }