function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // codigo // Titulo // Descripcion // fecha // id_usuario // archivo // estado if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // codigo $this->codigo->ViewValue = $this->codigo->CurrentValue; $this->codigo->ViewCustomAttributes = ""; // Titulo $this->Titulo->ViewValue = $this->Titulo->CurrentValue; $this->Titulo->ViewCustomAttributes = ""; // Descripcion $this->Descripcion->ViewValue = $this->Descripcion->CurrentValue; $this->Descripcion->ViewCustomAttributes = ""; // fecha $this->fecha->ViewValue = $this->fecha->CurrentValue; $this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7); $this->fecha->ViewCustomAttributes = ""; // archivo if (!ew_Empty($this->archivo->Upload->DbValue)) { $this->archivo->ViewValue = $this->archivo->Upload->DbValue; } else { $this->archivo->ViewValue = ""; } $this->archivo->ViewCustomAttributes = ""; // estado if (strval($this->estado->CurrentValue) != "") { switch ($this->estado->CurrentValue) { case $this->estado->FldTagValue(1): $this->estado->ViewValue = $this->estado->FldTagCaption(1) != "" ? $this->estado->FldTagCaption(1) : $this->estado->CurrentValue; break; case $this->estado->FldTagValue(2): $this->estado->ViewValue = $this->estado->FldTagCaption(2) != "" ? $this->estado->FldTagCaption(2) : $this->estado->CurrentValue; break; case $this->estado->FldTagValue(3): $this->estado->ViewValue = $this->estado->FldTagCaption(3) != "" ? $this->estado->FldTagCaption(3) : $this->estado->CurrentValue; break; default: $this->estado->ViewValue = $this->estado->CurrentValue; } } else { $this->estado->ViewValue = NULL; } $this->estado->ViewCustomAttributes = ""; // codigo $this->codigo->LinkCustomAttributes = ""; $this->codigo->HrefValue = ""; $this->codigo->TooltipValue = ""; // Titulo $this->Titulo->LinkCustomAttributes = ""; $this->Titulo->HrefValue = ""; $this->Titulo->TooltipValue = ""; // Descripcion $this->Descripcion->LinkCustomAttributes = ""; $this->Descripcion->HrefValue = ""; $this->Descripcion->TooltipValue = ""; // archivo $this->archivo->LinkCustomAttributes = ""; if (!ew_Empty($this->archivo->Upload->DbValue)) { $this->archivo->HrefValue = "%u"; // Add prefix/suffix $this->archivo->LinkAttrs["target"] = ""; // Add target if ($this->Export != "") { $this->archivo->HrefValue = ew_ConvertFullUrl($this->archivo->HrefValue); } } else { $this->archivo->HrefValue = ""; } $this->archivo->HrefValue2 = $this->archivo->UploadPath . $this->archivo->Upload->DbValue; $this->archivo->TooltipValue = ""; // estado $this->estado->LinkCustomAttributes = ""; $this->estado->HrefValue = ""; $this->estado->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_EDIT) { // Edit row // codigo $this->codigo->EditAttrs["class"] = "form-control"; $this->codigo->EditCustomAttributes = ""; $this->codigo->EditValue = $this->codigo->CurrentValue; $this->codigo->ViewCustomAttributes = ""; // Titulo $this->Titulo->EditAttrs["class"] = "form-control"; $this->Titulo->EditCustomAttributes = ""; $this->Titulo->EditValue = ew_HtmlEncode($this->Titulo->CurrentValue); $this->Titulo->PlaceHolder = ew_RemoveHtml($this->Titulo->FldCaption()); // Descripcion $this->Descripcion->EditAttrs["class"] = "form-control"; $this->Descripcion->EditCustomAttributes = ""; $this->Descripcion->EditValue = ew_HtmlEncode($this->Descripcion->CurrentValue); $this->Descripcion->PlaceHolder = ew_RemoveHtml($this->Descripcion->FldCaption()); // archivo $this->archivo->EditAttrs["class"] = "form-control"; $this->archivo->EditCustomAttributes = ""; if (!ew_Empty($this->archivo->Upload->DbValue)) { $this->archivo->EditValue = $this->archivo->Upload->DbValue; } else { $this->archivo->EditValue = ""; } if (!ew_Empty($this->archivo->CurrentValue)) { $this->archivo->Upload->FileName = $this->archivo->CurrentValue; } if ($this->CurrentAction == "I" && !$this->EventCancelled) { ew_RenderUploadField($this->archivo); } // estado $this->estado->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array($this->estado->FldTagValue(1), $this->estado->FldTagCaption(1) != "" ? $this->estado->FldTagCaption(1) : $this->estado->FldTagValue(1)); $arwrk[] = array($this->estado->FldTagValue(2), $this->estado->FldTagCaption(2) != "" ? $this->estado->FldTagCaption(2) : $this->estado->FldTagValue(2)); $arwrk[] = array($this->estado->FldTagValue(3), $this->estado->FldTagCaption(3) != "" ? $this->estado->FldTagCaption(3) : $this->estado->FldTagValue(3)); $this->estado->EditValue = $arwrk; // Edit refer script // codigo $this->codigo->HrefValue = ""; // Titulo $this->Titulo->HrefValue = ""; // Descripcion $this->Descripcion->HrefValue = ""; // archivo if (!ew_Empty($this->archivo->Upload->DbValue)) { $this->archivo->HrefValue = "%u"; // Add prefix/suffix $this->archivo->LinkAttrs["target"] = ""; // Add target if ($this->Export != "") { $this->archivo->HrefValue = ew_ConvertFullUrl($this->archivo->HrefValue); } } else { $this->archivo->HrefValue = ""; } $this->archivo->HrefValue2 = $this->archivo->UploadPath . $this->archivo->Upload->DbValue; // estado $this->estado->HrefValue = ""; } if ($this->RowType == EW_ROWTYPE_ADD || $this->RowType == EW_ROWTYPE_EDIT || $this->RowType == EW_ROWTYPE_SEARCH) { // Add / Edit / Search row $this->SetupFieldTitles(); } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs $this->ViewUrl = $this->GetViewUrl(); $this->EditUrl = $this->GetEditUrl(); $this->InlineEditUrl = $this->GetInlineEditUrl(); $this->CopyUrl = $this->GetCopyUrl(); $this->InlineCopyUrl = $this->GetInlineCopyUrl(); $this->DeleteUrl = $this->GetDeleteUrl(); // Convert decimal values if posted back if ($this->importe->FormValue == $this->importe->CurrentValue && is_numeric(ew_StrToFloat($this->importe->CurrentValue))) { $this->importe->CurrentValue = ew_StrToFloat($this->importe->CurrentValue); } // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // id // descripcion // importe // fecha_creacion // activa // id_usuario if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // id $this->id->ViewValue = $this->id->CurrentValue; $this->id->ViewCustomAttributes = ""; // descripcion $this->descripcion->ViewValue = $this->descripcion->CurrentValue; $this->descripcion->ViewCustomAttributes = ""; // importe $this->importe->ViewValue = $this->importe->CurrentValue; $this->importe->ViewCustomAttributes = ""; // fecha_creacion $this->fecha_creacion->ViewValue = $this->fecha_creacion->CurrentValue; $this->fecha_creacion->ViewValue = ew_FormatDateTime($this->fecha_creacion->ViewValue, 7); $this->fecha_creacion->ViewCustomAttributes = ""; // activa if (strval($this->activa->CurrentValue) != "") { switch ($this->activa->CurrentValue) { case $this->activa->FldTagValue(1): $this->activa->ViewValue = $this->activa->FldTagCaption(1) != "" ? $this->activa->FldTagCaption(1) : $this->activa->CurrentValue; break; case $this->activa->FldTagValue(2): $this->activa->ViewValue = $this->activa->FldTagCaption(2) != "" ? $this->activa->FldTagCaption(2) : $this->activa->CurrentValue; break; default: $this->activa->ViewValue = $this->activa->CurrentValue; } } else { $this->activa->ViewValue = NULL; } $this->activa->ViewCustomAttributes = ""; // id_usuario $this->id_usuario->ViewValue = $this->id_usuario->CurrentValue; $this->id_usuario->ViewCustomAttributes = ""; // id $this->id->LinkCustomAttributes = ""; $this->id->HrefValue = ""; $this->id->TooltipValue = ""; // descripcion $this->descripcion->LinkCustomAttributes = ""; $this->descripcion->HrefValue = ""; $this->descripcion->TooltipValue = ""; // importe $this->importe->LinkCustomAttributes = ""; $this->importe->HrefValue = ""; $this->importe->TooltipValue = ""; // fecha_creacion $this->fecha_creacion->LinkCustomAttributes = ""; $this->fecha_creacion->HrefValue = ""; $this->fecha_creacion->TooltipValue = ""; // activa $this->activa->LinkCustomAttributes = ""; $this->activa->HrefValue = ""; $this->activa->TooltipValue = ""; // id_usuario $this->id_usuario->LinkCustomAttributes = ""; $this->id_usuario->HrefValue = ""; $this->id_usuario->TooltipValue = ""; } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
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 RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs $this->ViewUrl = $this->GetViewUrl(); $this->EditUrl = $this->GetEditUrl(); $this->InlineEditUrl = $this->GetInlineEditUrl(); $this->CopyUrl = $this->GetCopyUrl(); $this->InlineCopyUrl = $this->GetInlineCopyUrl(); $this->DeleteUrl = $this->GetDeleteUrl(); // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // idcuenta // idpaciente // fecha_inicio // fecha_final // estado if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // idcuenta $this->idcuenta->ViewValue = $this->idcuenta->CurrentValue; $this->idcuenta->ViewCustomAttributes = ""; // idpaciente if (strval($this->idpaciente->CurrentValue) != "") { $sFilterWrk = "`idpaciente`" . ew_SearchString("=", $this->idpaciente->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idpaciente`, `nombre` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `paciente`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idpaciente, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idpaciente->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idpaciente->ViewValue = $this->idpaciente->CurrentValue; } } else { $this->idpaciente->ViewValue = NULL; } $this->idpaciente->ViewCustomAttributes = ""; // fecha_inicio $this->fecha_inicio->ViewValue = $this->fecha_inicio->CurrentValue; $this->fecha_inicio->ViewValue = ew_FormatDateTime($this->fecha_inicio->ViewValue, 7); $this->fecha_inicio->ViewCustomAttributes = ""; // fecha_final $this->fecha_final->ViewValue = $this->fecha_final->CurrentValue; $this->fecha_final->ViewValue = ew_FormatDateTime($this->fecha_final->ViewValue, 7); $this->fecha_final->ViewCustomAttributes = ""; // estado if (strval($this->estado->CurrentValue) != "") { switch ($this->estado->CurrentValue) { case $this->estado->FldTagValue(1): $this->estado->ViewValue = $this->estado->FldTagCaption(1) != "" ? $this->estado->FldTagCaption(1) : $this->estado->CurrentValue; break; case $this->estado->FldTagValue(2): $this->estado->ViewValue = $this->estado->FldTagCaption(2) != "" ? $this->estado->FldTagCaption(2) : $this->estado->CurrentValue; break; default: $this->estado->ViewValue = $this->estado->CurrentValue; } } else { $this->estado->ViewValue = NULL; } $this->estado->ViewCustomAttributes = ""; // idpaciente $this->idpaciente->LinkCustomAttributes = ""; $this->idpaciente->HrefValue = ""; $this->idpaciente->TooltipValue = ""; // fecha_inicio $this->fecha_inicio->LinkCustomAttributes = ""; $this->fecha_inicio->HrefValue = ""; $this->fecha_inicio->TooltipValue = ""; // fecha_final $this->fecha_final->LinkCustomAttributes = ""; $this->fecha_final->HrefValue = ""; $this->fecha_final->TooltipValue = ""; // estado $this->estado->LinkCustomAttributes = ""; $this->estado->HrefValue = ""; $this->estado->TooltipValue = ""; } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs // Convert decimal values if posted back if ($this->costo->FormValue == $this->costo->CurrentValue && is_numeric(ew_StrToFloat($this->costo->CurrentValue))) { $this->costo->CurrentValue = ew_StrToFloat($this->costo->CurrentValue); } // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // idservicio_medico_prestado // idcuenta // idservicio_medico // estado // costo // fecha_inicio // fecha_final if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // idservicio_medico_prestado $this->idservicio_medico_prestado->ViewValue = $this->idservicio_medico_prestado->CurrentValue; $this->idservicio_medico_prestado->ViewCustomAttributes = ""; // idcuenta if (strval($this->idcuenta->CurrentValue) != "") { $sFilterWrk = "`idcuenta`" . ew_SearchString("=", $this->idcuenta->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idcuenta`, `idcuenta` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `cuenta`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idcuenta, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idcuenta->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idcuenta->ViewValue = $this->idcuenta->CurrentValue; } } else { $this->idcuenta->ViewValue = NULL; } $this->idcuenta->ViewCustomAttributes = ""; // idservicio_medico if (strval($this->idservicio_medico->CurrentValue) != "") { $sFilterWrk = "`idservicio_medico`" . ew_SearchString("=", $this->idservicio_medico->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idservicio_medico`, `descripcion` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `servicio_medico`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idservicio_medico, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idservicio_medico->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idservicio_medico->ViewValue = $this->idservicio_medico->CurrentValue; } } else { $this->idservicio_medico->ViewValue = NULL; } $this->idservicio_medico->ViewCustomAttributes = ""; // estado if (strval($this->estado->CurrentValue) != "") { switch ($this->estado->CurrentValue) { case $this->estado->FldTagValue(1): $this->estado->ViewValue = $this->estado->FldTagCaption(1) != "" ? $this->estado->FldTagCaption(1) : $this->estado->CurrentValue; break; case $this->estado->FldTagValue(2): $this->estado->ViewValue = $this->estado->FldTagCaption(2) != "" ? $this->estado->FldTagCaption(2) : $this->estado->CurrentValue; break; case $this->estado->FldTagValue(3): $this->estado->ViewValue = $this->estado->FldTagCaption(3) != "" ? $this->estado->FldTagCaption(3) : $this->estado->CurrentValue; break; default: $this->estado->ViewValue = $this->estado->CurrentValue; } } else { $this->estado->ViewValue = NULL; } $this->estado->ViewCustomAttributes = ""; // costo $this->costo->ViewValue = $this->costo->CurrentValue; $this->costo->ViewCustomAttributes = ""; // fecha_inicio $this->fecha_inicio->ViewValue = $this->fecha_inicio->CurrentValue; $this->fecha_inicio->ViewValue = ew_FormatDateTime($this->fecha_inicio->ViewValue, 7); $this->fecha_inicio->ViewCustomAttributes = ""; // fecha_final $this->fecha_final->ViewValue = $this->fecha_final->CurrentValue; $this->fecha_final->ViewValue = ew_FormatDateTime($this->fecha_final->ViewValue, 7); $this->fecha_final->ViewCustomAttributes = ""; // idcuenta $this->idcuenta->LinkCustomAttributes = ""; $this->idcuenta->HrefValue = ""; $this->idcuenta->TooltipValue = ""; // idservicio_medico $this->idservicio_medico->LinkCustomAttributes = ""; $this->idservicio_medico->HrefValue = ""; $this->idservicio_medico->TooltipValue = ""; // costo $this->costo->LinkCustomAttributes = ""; $this->costo->HrefValue = ""; $this->costo->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_ADD) { // Add row // idcuenta $this->idcuenta->EditAttrs["class"] = "form-control"; $this->idcuenta->EditCustomAttributes = ""; if ($this->idcuenta->getSessionValue() != "") { $this->idcuenta->CurrentValue = $this->idcuenta->getSessionValue(); if (strval($this->idcuenta->CurrentValue) != "") { $sFilterWrk = "`idcuenta`" . ew_SearchString("=", $this->idcuenta->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idcuenta`, `idcuenta` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `cuenta`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idcuenta, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idcuenta->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idcuenta->ViewValue = $this->idcuenta->CurrentValue; } } else { $this->idcuenta->ViewValue = NULL; } $this->idcuenta->ViewCustomAttributes = ""; } else { if (trim(strval($this->idcuenta->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`idcuenta`" . ew_SearchString("=", $this->idcuenta->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `idcuenta`, `idcuenta` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `cuenta`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idcuenta, $sWhereWrk); 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"), "", "", "", "", "", "", "")); $this->idcuenta->EditValue = $arwrk; } // idservicio_medico $this->idservicio_medico->EditAttrs["class"] = "form-control"; $this->idservicio_medico->EditCustomAttributes = ""; if ($this->idservicio_medico->getSessionValue() != "") { $this->idservicio_medico->CurrentValue = $this->idservicio_medico->getSessionValue(); if (strval($this->idservicio_medico->CurrentValue) != "") { $sFilterWrk = "`idservicio_medico`" . ew_SearchString("=", $this->idservicio_medico->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idservicio_medico`, `descripcion` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `servicio_medico`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idservicio_medico, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idservicio_medico->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idservicio_medico->ViewValue = $this->idservicio_medico->CurrentValue; } } else { $this->idservicio_medico->ViewValue = NULL; } $this->idservicio_medico->ViewCustomAttributes = ""; } else { if (trim(strval($this->idservicio_medico->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`idservicio_medico`" . ew_SearchString("=", $this->idservicio_medico->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `idservicio_medico`, `descripcion` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `servicio_medico`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idservicio_medico, $sWhereWrk); 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"), "", "", "", "", "", "", "")); $this->idservicio_medico->EditValue = $arwrk; } // costo $this->costo->EditAttrs["class"] = "form-control"; $this->costo->EditCustomAttributes = ""; $this->costo->EditValue = ew_HtmlEncode($this->costo->CurrentValue); $this->costo->PlaceHolder = ew_RemoveHtml($this->costo->FldCaption()); if (strval($this->costo->EditValue) != "" && is_numeric($this->costo->EditValue)) { $this->costo->EditValue = ew_FormatNumber($this->costo->EditValue, -2, -1, -2, 0); } // Edit refer script // idcuenta $this->idcuenta->HrefValue = ""; // idservicio_medico $this->idservicio_medico->HrefValue = ""; // costo $this->costo->HrefValue = ""; } if ($this->RowType == EW_ROWTYPE_ADD || $this->RowType == EW_ROWTYPE_EDIT || $this->RowType == EW_ROWTYPE_SEARCH) { // Add / Edit / Search row $this->SetupFieldTitles(); } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $Kitchen_Report_22D2; // Common render codes for all row types // PublishedDate $Kitchen_Report_22D2->PublishedDate->CellCssStyle = ""; $Kitchen_Report_22D2->PublishedDate->CellCssClass = ""; // DeliveryDate $Kitchen_Report_22D2->DeliveryDate->CellCssStyle = ""; $Kitchen_Report_22D2->DeliveryDate->CellCssClass = ""; // MenuName $Kitchen_Report_22D2->MenuName->CellCssStyle = ""; $Kitchen_Report_22D2->MenuName->CellCssClass = ""; // ItemName $Kitchen_Report_22D2->ItemName->CellCssStyle = ""; $Kitchen_Report_22D2->ItemName->CellCssClass = ""; // TotalServings $Kitchen_Report_22D2->TotalServings->CellCssStyle = ""; $Kitchen_Report_22D2->TotalServings->CellCssClass = ""; // TotalOrders $Kitchen_Report_22D2->TotalOrders->CellCssStyle = ""; $Kitchen_Report_22D2->TotalOrders->CellCssClass = ""; // 1servings $Kitchen_Report_22D2->z1servings->CellCssStyle = ""; $Kitchen_Report_22D2->z1servings->CellCssClass = ""; // 2servings $Kitchen_Report_22D2->z2servings->CellCssStyle = ""; $Kitchen_Report_22D2->z2servings->CellCssClass = ""; // 3servings $Kitchen_Report_22D2->z3servings->CellCssStyle = ""; $Kitchen_Report_22D2->z3servings->CellCssClass = ""; // 4servings $Kitchen_Report_22D2->z4servings->CellCssStyle = ""; $Kitchen_Report_22D2->z4servings->CellCssClass = ""; // 5servings $Kitchen_Report_22D2->z5servings->CellCssStyle = ""; $Kitchen_Report_22D2->z5servings->CellCssClass = ""; // 6servings $Kitchen_Report_22D2->z6servings->CellCssStyle = ""; $Kitchen_Report_22D2->z6servings->CellCssClass = ""; // 7servings $Kitchen_Report_22D2->z7servings->CellCssStyle = ""; $Kitchen_Report_22D2->z7servings->CellCssClass = ""; // 8servings $Kitchen_Report_22D2->z8servings->CellCssStyle = ""; $Kitchen_Report_22D2->z8servings->CellCssClass = ""; if ($Kitchen_Report_22D2->RowType == EW_ROWTYPE_VIEW) { // View row // PublishedDate $Kitchen_Report_22D2->PublishedDate->ViewValue = $Kitchen_Report_22D2->PublishedDate->CurrentValue; $Kitchen_Report_22D2->PublishedDate->ViewValue = ew_FormatDateTime($Kitchen_Report_22D2->PublishedDate->ViewValue, 6); $Kitchen_Report_22D2->PublishedDate->CssStyle = ""; $Kitchen_Report_22D2->PublishedDate->CssClass = ""; $Kitchen_Report_22D2->PublishedDate->ViewCustomAttributes = ""; // DeliveryDate $Kitchen_Report_22D2->DeliveryDate->ViewValue = $Kitchen_Report_22D2->DeliveryDate->CurrentValue; $Kitchen_Report_22D2->DeliveryDate->ViewValue = ew_FormatDateTime($Kitchen_Report_22D2->DeliveryDate->ViewValue, 6); $Kitchen_Report_22D2->DeliveryDate->CssStyle = ""; $Kitchen_Report_22D2->DeliveryDate->CssClass = ""; $Kitchen_Report_22D2->DeliveryDate->ViewCustomAttributes = ""; // MenuName $Kitchen_Report_22D2->MenuName->ViewValue = $Kitchen_Report_22D2->MenuName->CurrentValue; $Kitchen_Report_22D2->MenuName->CssStyle = ""; $Kitchen_Report_22D2->MenuName->CssClass = ""; $Kitchen_Report_22D2->MenuName->ViewCustomAttributes = ""; // ItemName $Kitchen_Report_22D2->ItemName->ViewValue = $Kitchen_Report_22D2->ItemName->CurrentValue; $Kitchen_Report_22D2->ItemName->CssStyle = ""; $Kitchen_Report_22D2->ItemName->CssClass = ""; $Kitchen_Report_22D2->ItemName->ViewCustomAttributes = ""; // TotalServings $Kitchen_Report_22D2->TotalServings->ViewValue = $Kitchen_Report_22D2->TotalServings->CurrentValue; $Kitchen_Report_22D2->TotalServings->CssStyle = ""; $Kitchen_Report_22D2->TotalServings->CssClass = ""; $Kitchen_Report_22D2->TotalServings->ViewCustomAttributes = ""; // TotalOrders $Kitchen_Report_22D2->TotalOrders->ViewValue = $Kitchen_Report_22D2->TotalOrders->CurrentValue; $Kitchen_Report_22D2->TotalOrders->CssStyle = ""; $Kitchen_Report_22D2->TotalOrders->CssClass = ""; $Kitchen_Report_22D2->TotalOrders->ViewCustomAttributes = ""; // 1servings $Kitchen_Report_22D2->z1servings->ViewValue = $Kitchen_Report_22D2->z1servings->CurrentValue; $Kitchen_Report_22D2->z1servings->CssStyle = ""; $Kitchen_Report_22D2->z1servings->CssClass = ""; $Kitchen_Report_22D2->z1servings->ViewCustomAttributes = ""; // 2servings $Kitchen_Report_22D2->z2servings->ViewValue = $Kitchen_Report_22D2->z2servings->CurrentValue; $Kitchen_Report_22D2->z2servings->CssStyle = ""; $Kitchen_Report_22D2->z2servings->CssClass = ""; $Kitchen_Report_22D2->z2servings->ViewCustomAttributes = ""; // 3servings $Kitchen_Report_22D2->z3servings->ViewValue = $Kitchen_Report_22D2->z3servings->CurrentValue; $Kitchen_Report_22D2->z3servings->CssStyle = ""; $Kitchen_Report_22D2->z3servings->CssClass = ""; $Kitchen_Report_22D2->z3servings->ViewCustomAttributes = ""; // 4servings $Kitchen_Report_22D2->z4servings->ViewValue = $Kitchen_Report_22D2->z4servings->CurrentValue; $Kitchen_Report_22D2->z4servings->CssStyle = ""; $Kitchen_Report_22D2->z4servings->CssClass = ""; $Kitchen_Report_22D2->z4servings->ViewCustomAttributes = ""; // 5servings $Kitchen_Report_22D2->z5servings->ViewValue = $Kitchen_Report_22D2->z5servings->CurrentValue; $Kitchen_Report_22D2->z5servings->CssStyle = ""; $Kitchen_Report_22D2->z5servings->CssClass = ""; $Kitchen_Report_22D2->z5servings->ViewCustomAttributes = ""; // 6servings $Kitchen_Report_22D2->z6servings->ViewValue = $Kitchen_Report_22D2->z6servings->CurrentValue; $Kitchen_Report_22D2->z6servings->CssStyle = ""; $Kitchen_Report_22D2->z6servings->CssClass = ""; $Kitchen_Report_22D2->z6servings->ViewCustomAttributes = ""; // 7servings $Kitchen_Report_22D2->z7servings->ViewValue = $Kitchen_Report_22D2->z7servings->CurrentValue; $Kitchen_Report_22D2->z7servings->CssStyle = ""; $Kitchen_Report_22D2->z7servings->CssClass = ""; $Kitchen_Report_22D2->z7servings->ViewCustomAttributes = ""; // 8servings $Kitchen_Report_22D2->z8servings->ViewValue = $Kitchen_Report_22D2->z8servings->CurrentValue; $Kitchen_Report_22D2->z8servings->CssStyle = ""; $Kitchen_Report_22D2->z8servings->CssClass = ""; $Kitchen_Report_22D2->z8servings->ViewCustomAttributes = ""; // PublishedDate $Kitchen_Report_22D2->PublishedDate->HrefValue = ""; // DeliveryDate $Kitchen_Report_22D2->DeliveryDate->HrefValue = ""; // MenuName $Kitchen_Report_22D2->MenuName->HrefValue = ""; // ItemName $Kitchen_Report_22D2->ItemName->HrefValue = ""; // TotalServings $Kitchen_Report_22D2->TotalServings->HrefValue = ""; // TotalOrders $Kitchen_Report_22D2->TotalOrders->HrefValue = ""; // 1servings $Kitchen_Report_22D2->z1servings->HrefValue = ""; // 2servings $Kitchen_Report_22D2->z2servings->HrefValue = ""; // 3servings $Kitchen_Report_22D2->z3servings->HrefValue = ""; // 4servings $Kitchen_Report_22D2->z4servings->HrefValue = ""; // 5servings $Kitchen_Report_22D2->z5servings->HrefValue = ""; // 6servings $Kitchen_Report_22D2->z6servings->HrefValue = ""; // 7servings $Kitchen_Report_22D2->z7servings->HrefValue = ""; // 8servings $Kitchen_Report_22D2->z8servings->HrefValue = ""; } }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs $this->AddUrl = $this->GetAddUrl(); $this->EditUrl = $this->GetEditUrl(); $this->CopyUrl = $this->GetCopyUrl(); $this->DeleteUrl = $this->GetDeleteUrl(); $this->ListUrl = $this->GetListUrl(); $this->SetupOtherOptions(); // Convert decimal values if posted back if ($this->monto->FormValue == $this->monto->CurrentValue && is_numeric(ew_StrToFloat($this->monto->CurrentValue))) { $this->monto->CurrentValue = ew_StrToFloat($this->monto->CurrentValue); } // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // id // mes // anio // fecha // monto // id_usuario // id_socio if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // id $this->id->ViewCustomAttributes = ""; // mes $this->mes->ViewValue = $this->mes->CurrentValue; $this->mes->ViewCustomAttributes = ""; // anio $this->anio->ViewValue = $this->anio->CurrentValue; $this->anio->ViewCustomAttributes = ""; // fecha $this->fecha->ViewValue = $this->fecha->CurrentValue; $this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7); $this->fecha->ViewCustomAttributes = ""; // monto $this->monto->ViewValue = $this->monto->CurrentValue; $this->monto->ViewValue = ew_FormatCurrency($this->monto->ViewValue, 0, -2, -2, -2); $this->monto->ViewCustomAttributes = ""; // id_socio if (strval($this->id_socio->CurrentValue) != "") { $sFilterWrk = "`socio_nro`" . ew_SearchString("=", $this->id_socio->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `socio_nro`, `propietario` AS `DispFld`, `comercio` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `socios`"; $sWhereWrk = ""; $lookuptblfilter = "`activo`='S'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_socio, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `propietario` DESC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_socio->ViewValue = $rswrk->fields('DispFld'); $this->id_socio->ViewValue .= ew_ValueSeparator(1, $this->id_socio) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_socio->ViewValue = $this->id_socio->CurrentValue; } } else { $this->id_socio->ViewValue = NULL; } $this->id_socio->ViewCustomAttributes = ""; // id $this->id->LinkCustomAttributes = ""; $this->id->HrefValue = ""; $this->id->TooltipValue = ""; // mes $this->mes->LinkCustomAttributes = ""; $this->mes->HrefValue = ""; $this->mes->TooltipValue = ""; // anio $this->anio->LinkCustomAttributes = ""; $this->anio->HrefValue = ""; $this->anio->TooltipValue = ""; // fecha $this->fecha->LinkCustomAttributes = ""; $this->fecha->HrefValue = ""; $this->fecha->TooltipValue = ""; // monto $this->monto->LinkCustomAttributes = ""; $this->monto->HrefValue = ""; $this->monto->TooltipValue = ""; // id_socio $this->id_socio->LinkCustomAttributes = ""; $this->id_socio->HrefValue = ""; $this->id_socio->TooltipValue = ""; } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $Delivery_Report_1; // Common render codes for all row types // PublishedDate $Delivery_Report_1->PublishedDate->CellCssStyle = ""; $Delivery_Report_1->PublishedDate->CellCssClass = ""; // DeliveryDate $Delivery_Report_1->DeliveryDate->CellCssStyle = ""; $Delivery_Report_1->DeliveryDate->CellCssClass = ""; // Delivery_Window $Delivery_Report_1->Delivery_Window->CellCssStyle = ""; $Delivery_Report_1->Delivery_Window->CellCssClass = ""; // CustomerName $Delivery_Report_1->CustomerName->CellCssStyle = ""; $Delivery_Report_1->CustomerName->CellCssClass = ""; // Email $Delivery_Report_1->zEmail->CellCssStyle = ""; $Delivery_Report_1->zEmail->CellCssClass = ""; // DeliveryAddress $Delivery_Report_1->DeliveryAddress->CellCssStyle = ""; $Delivery_Report_1->DeliveryAddress->CellCssClass = ""; // DeliveryCity $Delivery_Report_1->DeliveryCity->CellCssStyle = ""; $Delivery_Report_1->DeliveryCity->CellCssClass = ""; // DeliveryZip $Delivery_Report_1->DeliveryZip->CellCssStyle = ""; $Delivery_Report_1->DeliveryZip->CellCssClass = ""; // DeliveryComments $Delivery_Report_1->DeliveryComments->CellCssStyle = ""; $Delivery_Report_1->DeliveryComments->CellCssClass = ""; if ($Delivery_Report_1->RowType == EW_ROWTYPE_VIEW) { // View row // PublishedDate $Delivery_Report_1->PublishedDate->ViewValue = $Delivery_Report_1->PublishedDate->CurrentValue; $Delivery_Report_1->PublishedDate->ViewValue = ew_FormatDateTime($Delivery_Report_1->PublishedDate->ViewValue, 6); $Delivery_Report_1->PublishedDate->CssStyle = ""; $Delivery_Report_1->PublishedDate->CssClass = ""; $Delivery_Report_1->PublishedDate->ViewCustomAttributes = ""; // DeliveryDate $Delivery_Report_1->DeliveryDate->ViewValue = $Delivery_Report_1->DeliveryDate->CurrentValue; $Delivery_Report_1->DeliveryDate->ViewValue = ew_FormatDateTime($Delivery_Report_1->DeliveryDate->ViewValue, 6); $Delivery_Report_1->DeliveryDate->CssStyle = ""; $Delivery_Report_1->DeliveryDate->CssClass = ""; $Delivery_Report_1->DeliveryDate->ViewCustomAttributes = ""; // Delivery_Window if (strval($Delivery_Report_1->Delivery_Window->CurrentValue) != "") { switch ($Delivery_Report_1->Delivery_Window->CurrentValue) { case "1-4": $Delivery_Report_1->Delivery_Window->ViewValue = "1-4"; break; case "5-8": $Delivery_Report_1->Delivery_Window->ViewValue = "5-8"; break; default: $Delivery_Report_1->Delivery_Window->ViewValue = $Delivery_Report_1->Delivery_Window->CurrentValue; } } else { $Delivery_Report_1->Delivery_Window->ViewValue = NULL; } $Delivery_Report_1->Delivery_Window->CssStyle = ""; $Delivery_Report_1->Delivery_Window->CssClass = ""; $Delivery_Report_1->Delivery_Window->ViewCustomAttributes = ""; // CustomerName $Delivery_Report_1->CustomerName->ViewValue = $Delivery_Report_1->CustomerName->CurrentValue; $Delivery_Report_1->CustomerName->CssStyle = ""; $Delivery_Report_1->CustomerName->CssClass = ""; $Delivery_Report_1->CustomerName->ViewCustomAttributes = ""; // Email $Delivery_Report_1->zEmail->ViewValue = $Delivery_Report_1->zEmail->CurrentValue; $Delivery_Report_1->zEmail->CssStyle = ""; $Delivery_Report_1->zEmail->CssClass = ""; $Delivery_Report_1->zEmail->ViewCustomAttributes = ""; // DeliveryAddress $Delivery_Report_1->DeliveryAddress->ViewValue = $Delivery_Report_1->DeliveryAddress->CurrentValue; $Delivery_Report_1->DeliveryAddress->CssStyle = ""; $Delivery_Report_1->DeliveryAddress->CssClass = ""; $Delivery_Report_1->DeliveryAddress->ViewCustomAttributes = ""; // DeliveryCity $Delivery_Report_1->DeliveryCity->ViewValue = $Delivery_Report_1->DeliveryCity->CurrentValue; $Delivery_Report_1->DeliveryCity->CssStyle = ""; $Delivery_Report_1->DeliveryCity->CssClass = ""; $Delivery_Report_1->DeliveryCity->ViewCustomAttributes = ""; // DeliveryZip $Delivery_Report_1->DeliveryZip->ViewValue = $Delivery_Report_1->DeliveryZip->CurrentValue; $Delivery_Report_1->DeliveryZip->CssStyle = ""; $Delivery_Report_1->DeliveryZip->CssClass = ""; $Delivery_Report_1->DeliveryZip->ViewCustomAttributes = ""; // DeliveryComments $Delivery_Report_1->DeliveryComments->ViewValue = $Delivery_Report_1->DeliveryComments->CurrentValue; $Delivery_Report_1->DeliveryComments->CssStyle = ""; $Delivery_Report_1->DeliveryComments->CssClass = ""; $Delivery_Report_1->DeliveryComments->ViewCustomAttributes = ""; // PublishedDate $Delivery_Report_1->PublishedDate->HrefValue = ""; // DeliveryDate $Delivery_Report_1->DeliveryDate->HrefValue = ""; // Delivery_Window $Delivery_Report_1->Delivery_Window->HrefValue = ""; // CustomerName $Delivery_Report_1->CustomerName->HrefValue = ""; // Email $Delivery_Report_1->zEmail->HrefValue = ""; // DeliveryAddress $Delivery_Report_1->DeliveryAddress->HrefValue = ""; // DeliveryCity $Delivery_Report_1->DeliveryCity->HrefValue = ""; // DeliveryZip $Delivery_Report_1->DeliveryZip->HrefValue = ""; // DeliveryComments $Delivery_Report_1->DeliveryComments->HrefValue = ""; } }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // codigo // nombre // direccion // fecha_nacimiento // tel // cel // email // fecha_inicio // cetegoria // datos if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // codigo $this->codigo->ViewValue = $this->codigo->CurrentValue; $this->codigo->ViewCustomAttributes = ""; // nombre $this->nombre->ViewValue = $this->nombre->CurrentValue; $this->nombre->ViewCustomAttributes = ""; // direccion $this->direccion->ViewValue = $this->direccion->CurrentValue; $this->direccion->ViewCustomAttributes = ""; // fecha_nacimiento $this->fecha_nacimiento->ViewValue = $this->fecha_nacimiento->CurrentValue; $this->fecha_nacimiento->ViewValue = ew_FormatDateTime($this->fecha_nacimiento->ViewValue, 7); $this->fecha_nacimiento->ViewCustomAttributes = ""; // tel $this->tel->ViewValue = $this->tel->CurrentValue; $this->tel->ViewCustomAttributes = ""; // cel $this->cel->ViewValue = $this->cel->CurrentValue; $this->cel->ViewCustomAttributes = ""; // email $this->_email->ViewValue = $this->_email->CurrentValue; $this->_email->ViewValue = strtolower($this->_email->ViewValue); $this->_email->ViewCustomAttributes = ""; // fecha_inicio $this->fecha_inicio->ViewValue = $this->fecha_inicio->CurrentValue; $this->fecha_inicio->ViewValue = ew_FormatDateTime($this->fecha_inicio->ViewValue, 7); $this->fecha_inicio->ViewCustomAttributes = ""; // cetegoria $this->cetegoria->ViewValue = $this->cetegoria->CurrentValue; $this->cetegoria->ViewValue = ew_FormatNumber($this->cetegoria->ViewValue, 0, -2, -2, -2); $this->cetegoria->ViewCustomAttributes = ""; // datos $this->datos->ViewValue = $this->datos->CurrentValue; $this->datos->ViewCustomAttributes = ""; // nombre $this->nombre->LinkCustomAttributes = ""; $this->nombre->HrefValue = ""; $this->nombre->TooltipValue = ""; // direccion $this->direccion->LinkCustomAttributes = ""; $this->direccion->HrefValue = ""; $this->direccion->TooltipValue = ""; // fecha_nacimiento $this->fecha_nacimiento->LinkCustomAttributes = ""; $this->fecha_nacimiento->HrefValue = ""; $this->fecha_nacimiento->TooltipValue = ""; // tel $this->tel->LinkCustomAttributes = ""; $this->tel->HrefValue = ""; $this->tel->TooltipValue = ""; // cel $this->cel->LinkCustomAttributes = ""; $this->cel->HrefValue = ""; $this->cel->TooltipValue = ""; // email $this->_email->LinkCustomAttributes = ""; $this->_email->HrefValue = ""; $this->_email->TooltipValue = ""; // fecha_inicio $this->fecha_inicio->LinkCustomAttributes = ""; $this->fecha_inicio->HrefValue = ""; $this->fecha_inicio->TooltipValue = ""; // cetegoria $this->cetegoria->LinkCustomAttributes = ""; $this->cetegoria->HrefValue = ""; $this->cetegoria->TooltipValue = ""; // datos $this->datos->LinkCustomAttributes = ""; $this->datos->HrefValue = ""; $this->datos->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_ADD) { // Add row // nombre $this->nombre->EditAttrs["class"] = "form-control"; $this->nombre->EditCustomAttributes = ""; $this->nombre->EditValue = ew_HtmlEncode($this->nombre->CurrentValue); $this->nombre->PlaceHolder = ew_RemoveHtml($this->nombre->FldCaption()); // direccion $this->direccion->EditAttrs["class"] = "form-control"; $this->direccion->EditCustomAttributes = ""; $this->direccion->EditValue = ew_HtmlEncode($this->direccion->CurrentValue); $this->direccion->PlaceHolder = ew_RemoveHtml($this->direccion->FldCaption()); // fecha_nacimiento $this->fecha_nacimiento->EditAttrs["class"] = "form-control"; $this->fecha_nacimiento->EditCustomAttributes = ""; $this->fecha_nacimiento->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->fecha_nacimiento->CurrentValue, 7)); $this->fecha_nacimiento->PlaceHolder = ew_RemoveHtml($this->fecha_nacimiento->FldCaption()); // tel $this->tel->EditAttrs["class"] = "form-control"; $this->tel->EditCustomAttributes = ""; $this->tel->EditValue = ew_HtmlEncode($this->tel->CurrentValue); $this->tel->PlaceHolder = ew_RemoveHtml($this->tel->FldCaption()); // cel $this->cel->EditAttrs["class"] = "form-control"; $this->cel->EditCustomAttributes = ""; $this->cel->EditValue = ew_HtmlEncode($this->cel->CurrentValue); $this->cel->PlaceHolder = ew_RemoveHtml($this->cel->FldCaption()); // email $this->_email->EditAttrs["class"] = "form-control"; $this->_email->EditCustomAttributes = ""; $this->_email->EditValue = ew_HtmlEncode($this->_email->CurrentValue); $this->_email->PlaceHolder = ew_RemoveHtml($this->_email->FldCaption()); // fecha_inicio $this->fecha_inicio->EditAttrs["class"] = "form-control"; $this->fecha_inicio->EditCustomAttributes = ""; $this->fecha_inicio->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->fecha_inicio->CurrentValue, 7)); $this->fecha_inicio->PlaceHolder = ew_RemoveHtml($this->fecha_inicio->FldCaption()); // cetegoria $this->cetegoria->EditAttrs["class"] = "form-control"; $this->cetegoria->EditCustomAttributes = ""; $this->cetegoria->EditValue = ew_HtmlEncode($this->cetegoria->CurrentValue); $this->cetegoria->PlaceHolder = ew_RemoveHtml($this->cetegoria->FldCaption()); // datos $this->datos->EditAttrs["class"] = "form-control"; $this->datos->EditCustomAttributes = ""; $this->datos->EditValue = ew_HtmlEncode($this->datos->CurrentValue); $this->datos->PlaceHolder = ew_RemoveHtml($this->datos->FldCaption()); // Edit refer script // nombre $this->nombre->HrefValue = ""; // direccion $this->direccion->HrefValue = ""; // fecha_nacimiento $this->fecha_nacimiento->HrefValue = ""; // tel $this->tel->HrefValue = ""; // cel $this->cel->HrefValue = ""; // email $this->_email->HrefValue = ""; // fecha_inicio $this->fecha_inicio->HrefValue = ""; // cetegoria $this->cetegoria->HrefValue = ""; // datos $this->datos->HrefValue = ""; } if ($this->RowType == EW_ROWTYPE_ADD || $this->RowType == EW_ROWTYPE_EDIT || $this->RowType == EW_ROWTYPE_SEARCH) { // Add / Edit / Search row $this->SetupFieldTitles(); } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $patient_main; // Call Row_Rendering event $patient_main->Row_Rendering(); // Common render codes for all row types // PatientMainNo $patient_main->PatientMainNo->CellCssStyle = ""; $patient_main->PatientMainNo->CellCssClass = ""; // PatientID $patient_main->PatientID->CellCssStyle = ""; $patient_main->PatientID->CellCssClass = ""; // PatientName $patient_main->PatientName->CellCssStyle = ""; $patient_main->PatientName->CellCssClass = ""; // PatientBirthDate $patient_main->PatientBirthDate->CellCssStyle = ""; $patient_main->PatientBirthDate->CellCssClass = ""; // PatientSex $patient_main->PatientSex->CellCssStyle = ""; $patient_main->PatientSex->CellCssClass = ""; // OtherPatientID $patient_main->OtherPatientID->CellCssStyle = ""; $patient_main->OtherPatientID->CellCssClass = ""; if ($patient_main->RowType == EW_ROWTYPE_VIEW) { // View row // PatientMainNo $patient_main->PatientMainNo->ViewValue = $patient_main->PatientMainNo->CurrentValue; $patient_main->PatientMainNo->CssStyle = ""; $patient_main->PatientMainNo->CssClass = ""; $patient_main->PatientMainNo->ViewCustomAttributes = ""; // PatientID $patient_main->PatientID->ViewValue = $patient_main->PatientID->CurrentValue; $patient_main->PatientID->CssStyle = ""; $patient_main->PatientID->CssClass = ""; $patient_main->PatientID->ViewCustomAttributes = ""; // PatientName $patient_main->PatientName->ViewValue = $patient_main->PatientName->CurrentValue; $patient_main->PatientName->CssStyle = ""; $patient_main->PatientName->CssClass = ""; $patient_main->PatientName->ViewCustomAttributes = ""; // PatientBirthDate $patient_main->PatientBirthDate->ViewValue = $patient_main->PatientBirthDate->CurrentValue; $patient_main->PatientBirthDate->ViewValue = ew_FormatDateTime($patient_main->PatientBirthDate->ViewValue, 5); $patient_main->PatientBirthDate->CssStyle = ""; $patient_main->PatientBirthDate->CssClass = ""; $patient_main->PatientBirthDate->ViewCustomAttributes = ""; // PatientSex $patient_main->PatientSex->ViewValue = $patient_main->PatientSex->CurrentValue; $patient_main->PatientSex->CssStyle = ""; $patient_main->PatientSex->CssClass = ""; $patient_main->PatientSex->ViewCustomAttributes = ""; // OtherPatientID $patient_main->OtherPatientID->ViewValue = $patient_main->OtherPatientID->CurrentValue; $patient_main->OtherPatientID->CssStyle = ""; $patient_main->OtherPatientID->CssClass = ""; $patient_main->OtherPatientID->ViewCustomAttributes = ""; // PatientMainNo $patient_main->PatientMainNo->HrefValue = ""; // PatientID $patient_main->PatientID->HrefValue = ""; // PatientName $patient_main->PatientName->HrefValue = ""; // PatientBirthDate $patient_main->PatientBirthDate->HrefValue = ""; // PatientSex $patient_main->PatientSex->HrefValue = ""; // OtherPatientID $patient_main->OtherPatientID->HrefValue = ""; } elseif ($patient_main->RowType == EW_ROWTYPE_EDIT) { // Edit row // PatientMainNo $patient_main->PatientMainNo->EditCustomAttributes = ""; $patient_main->PatientMainNo->EditValue = $patient_main->PatientMainNo->CurrentValue; $patient_main->PatientMainNo->CssStyle = ""; $patient_main->PatientMainNo->CssClass = ""; $patient_main->PatientMainNo->ViewCustomAttributes = ""; // PatientID $patient_main->PatientID->EditCustomAttributes = ""; $patient_main->PatientID->EditValue = ew_HtmlEncode($patient_main->PatientID->CurrentValue); // PatientName $patient_main->PatientName->EditCustomAttributes = ""; $patient_main->PatientName->EditValue = ew_HtmlEncode($patient_main->PatientName->CurrentValue); // PatientBirthDate $patient_main->PatientBirthDate->EditCustomAttributes = ""; $patient_main->PatientBirthDate->EditValue = ew_HtmlEncode(ew_FormatDateTime($patient_main->PatientBirthDate->CurrentValue, 5)); // PatientSex $patient_main->PatientSex->EditCustomAttributes = ""; $patient_main->PatientSex->EditValue = ew_HtmlEncode($patient_main->PatientSex->CurrentValue); // OtherPatientID $patient_main->OtherPatientID->EditCustomAttributes = ""; $patient_main->OtherPatientID->EditValue = ew_HtmlEncode($patient_main->OtherPatientID->CurrentValue); // Edit refer script // PatientMainNo $patient_main->PatientMainNo->HrefValue = ""; // PatientID $patient_main->PatientID->HrefValue = ""; // PatientName $patient_main->PatientName->HrefValue = ""; // PatientBirthDate $patient_main->PatientBirthDate->HrefValue = ""; // PatientSex $patient_main->PatientSex->HrefValue = ""; // OtherPatientID $patient_main->OtherPatientID->HrefValue = ""; } // Call Row Rendered event $patient_main->Row_Rendered(); }
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; global $gsLanguage; // Initialize URLs $this->ViewUrl = $this->GetViewUrl(); $this->EditUrl = $this->GetEditUrl(); $this->InlineEditUrl = $this->GetInlineEditUrl(); $this->CopyUrl = $this->GetCopyUrl(); $this->InlineCopyUrl = $this->GetInlineCopyUrl(); $this->DeleteUrl = $this->GetDeleteUrl(); // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // id_hoja_mantenimiento // descripcion // fecha // hora_trabajo // id_tipo_mantenimiento if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // id_hoja_mantenimiento $this->id_hoja_mantenimiento->ViewValue = $this->id_hoja_mantenimiento->CurrentValue; $this->id_hoja_mantenimiento->ViewCustomAttributes = ""; // descripcion $this->descripcion->ViewValue = $this->descripcion->CurrentValue; $this->descripcion->ViewCustomAttributes = ""; // fecha $this->fecha->ViewValue = $this->fecha->CurrentValue; $this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7); $this->fecha->ViewCustomAttributes = ""; // hora_trabajo $this->hora_trabajo->ViewValue = $this->hora_trabajo->CurrentValue; $this->hora_trabajo->ViewCustomAttributes = ""; // id_tipo_mantenimiento $this->id_tipo_mantenimiento->ViewValue = $this->id_tipo_mantenimiento->CurrentValue; $this->id_tipo_mantenimiento->ViewCustomAttributes = ""; // id_hoja_mantenimiento $this->id_hoja_mantenimiento->LinkCustomAttributes = ""; $this->id_hoja_mantenimiento->HrefValue = ""; $this->id_hoja_mantenimiento->TooltipValue = ""; // descripcion $this->descripcion->LinkCustomAttributes = ""; $this->descripcion->HrefValue = ""; $this->descripcion->TooltipValue = ""; // fecha $this->fecha->LinkCustomAttributes = ""; $this->fecha->HrefValue = ""; $this->fecha->TooltipValue = ""; // hora_trabajo $this->hora_trabajo->LinkCustomAttributes = ""; $this->hora_trabajo->HrefValue = ""; $this->hora_trabajo->TooltipValue = ""; // id_tipo_mantenimiento $this->id_tipo_mantenimiento->LinkCustomAttributes = ""; $this->id_tipo_mantenimiento->HrefValue = ""; $this->id_tipo_mantenimiento->TooltipValue = ""; } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $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 RenderListRow() { global $conn, $Security; // Call Row Rendering event $this->Row_Rendering(); // HolidayDateID $this->HolidayDateID->ViewValue = $this->HolidayDateID->CurrentValue; $this->HolidayDateID->CssStyle = ""; $this->HolidayDateID->CssClass = ""; $this->HolidayDateID->ViewCustomAttributes = ""; // HolidayOrderBy $this->HolidayOrderBy->ViewValue = $this->HolidayOrderBy->CurrentValue; $this->HolidayOrderBy->ViewValue = ew_FormatDateTime($this->HolidayOrderBy->ViewValue, 6); $this->HolidayOrderBy->CssStyle = ""; $this->HolidayOrderBy->CssClass = ""; $this->HolidayOrderBy->ViewCustomAttributes = ""; // HolidayDeliverOn $this->HolidayDeliverOn->ViewValue = $this->HolidayDeliverOn->CurrentValue; $this->HolidayDeliverOn->ViewValue = ew_FormatDateTime($this->HolidayDeliverOn->ViewValue, 6); $this->HolidayDeliverOn->CssStyle = ""; $this->HolidayDeliverOn->CssClass = ""; $this->HolidayDeliverOn->ViewCustomAttributes = ""; // HolidayDateID $this->HolidayDateID->HrefValue = ""; // HolidayOrderBy $this->HolidayOrderBy->HrefValue = ""; // HolidayDeliverOn $this->HolidayDeliverOn->HrefValue = ""; // Call Row Rendered event $this->Row_Rendered(); }
function RenderEditRow() { global $conn, $Security, $gsLanguage, $Language; // Call Row Rendering event $this->Row_Rendering(); // id_socio $this->id_socio->EditAttrs["class"] = "form-control"; $this->id_socio->EditCustomAttributes = ""; if ($this->id_socio->getSessionValue() != "") { $this->id_socio->CurrentValue = $this->id_socio->getSessionValue(); if (strval($this->id_socio->CurrentValue) != "") { $sFilterWrk = "`socio_nro`" . ew_SearchString("=", $this->id_socio->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `socio_nro`, `propietario` AS `DispFld`, `comercio` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `socios`"; $sWhereWrk = ""; $lookuptblfilter = "`activo`='S'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_socio, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `propietario` DESC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_socio->ViewValue = $rswrk->fields('DispFld'); $this->id_socio->ViewValue .= ew_ValueSeparator(1, $this->id_socio) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_socio->ViewValue = $this->id_socio->CurrentValue; } } else { $this->id_socio->ViewValue = NULL; } $this->id_socio->ViewCustomAttributes = ""; } else { } // id_detalles $this->id_detalles->EditAttrs["class"] = "form-control"; $this->id_detalles->EditCustomAttributes = ""; if ($this->id_detalles->getSessionValue() != "") { $this->id_detalles->CurrentValue = $this->id_detalles->getSessionValue(); if (strval($this->id_detalles->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_detalles->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `nombre` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `detalles`"; $sWhereWrk = ""; $lookuptblfilter = "`activa`='S'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_detalles, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `nombre` DESC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_detalles->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->id_detalles->ViewValue = $this->id_detalles->CurrentValue; } } else { $this->id_detalles->ViewValue = NULL; } $this->id_detalles->ViewCustomAttributes = ""; } else { } // fecha_alta $this->fecha_alta->EditAttrs["class"] = "form-control"; $this->fecha_alta->EditCustomAttributes = ""; $this->fecha_alta->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->fecha_alta->CurrentValue, 7)); $this->fecha_alta->PlaceHolder = ew_RemoveHtml($this->fecha_alta->FldCaption()); // fecha_baja $this->fecha_baja->EditAttrs["class"] = "form-control"; $this->fecha_baja->EditCustomAttributes = ""; $this->fecha_baja->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->fecha_baja->CurrentValue, 7)); $this->fecha_baja->PlaceHolder = ew_RemoveHtml($this->fecha_baja->FldCaption()); // Call Row Rendered event $this->Row_Rendered(); }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs // Convert decimal values if posted back if ($this->iva->FormValue == $this->iva->CurrentValue && is_numeric(ew_StrToFloat($this->iva->CurrentValue))) { $this->iva->CurrentValue = ew_StrToFloat($this->iva->CurrentValue); } // Convert decimal values if posted back if ($this->Importe->FormValue == $this->Importe->CurrentValue && is_numeric(ew_StrToFloat($this->Importe->CurrentValue))) { $this->Importe->CurrentValue = ew_StrToFloat($this->Importe->CurrentValue); } // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // codigo // fecha // detalles // iva // Importe // id_tipo_gasto // id_hoja_ruta $this->id_hoja_ruta->CellCssStyle = "white-space: nowrap;"; // id_hoja_mantenimiento if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // codigo $this->codigo->ViewValue = $this->codigo->CurrentValue; $this->codigo->ViewCustomAttributes = ""; // fecha $this->fecha->ViewValue = $this->fecha->CurrentValue; $this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7); $this->fecha->ViewCustomAttributes = ""; // detalles $this->detalles->ViewValue = $this->detalles->CurrentValue; $this->detalles->ViewCustomAttributes = ""; // iva $this->iva->ViewValue = $this->iva->CurrentValue; $this->iva->ViewCustomAttributes = ""; // Importe $this->Importe->ViewValue = $this->Importe->CurrentValue; $this->Importe->ViewCustomAttributes = ""; // id_tipo_gasto if ($this->id_tipo_gasto->VirtualValue != "") { $this->id_tipo_gasto->ViewValue = $this->id_tipo_gasto->VirtualValue; } else { $this->id_tipo_gasto->ViewValue = $this->id_tipo_gasto->CurrentValue; if (strval($this->id_tipo_gasto->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_tipo_gasto->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `tipo_gasto` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tipo_gastos`"; $sWhereWrk = ""; $lookuptblfilter = "`clase`='M'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_tipo_gasto, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `tipo_gasto` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_tipo_gasto->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->id_tipo_gasto->ViewValue = $this->id_tipo_gasto->CurrentValue; } } else { $this->id_tipo_gasto->ViewValue = NULL; } } $this->id_tipo_gasto->ViewCustomAttributes = ""; // id_hoja_mantenimiento $this->id_hoja_mantenimiento->ViewValue = $this->id_hoja_mantenimiento->CurrentValue; $this->id_hoja_mantenimiento->ViewCustomAttributes = ""; // codigo $this->codigo->LinkCustomAttributes = ""; $this->codigo->HrefValue = ""; $this->codigo->TooltipValue = ""; // fecha $this->fecha->LinkCustomAttributes = ""; $this->fecha->HrefValue = ""; $this->fecha->TooltipValue = ""; // detalles $this->detalles->LinkCustomAttributes = ""; $this->detalles->HrefValue = ""; $this->detalles->TooltipValue = ""; // iva $this->iva->LinkCustomAttributes = ""; $this->iva->HrefValue = ""; $this->iva->TooltipValue = ""; // Importe $this->Importe->LinkCustomAttributes = ""; $this->Importe->HrefValue = ""; $this->Importe->TooltipValue = ""; // id_tipo_gasto $this->id_tipo_gasto->LinkCustomAttributes = ""; $this->id_tipo_gasto->HrefValue = ""; $this->id_tipo_gasto->TooltipValue = ""; // id_hoja_mantenimiento $this->id_hoja_mantenimiento->LinkCustomAttributes = ""; $this->id_hoja_mantenimiento->HrefValue = ""; $this->id_hoja_mantenimiento->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_ADD) { // Add row // codigo // fecha $this->fecha->EditAttrs["class"] = "form-control"; $this->fecha->EditCustomAttributes = ""; $this->fecha->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->fecha->CurrentValue, 7)); $this->fecha->PlaceHolder = ew_RemoveHtml($this->fecha->FldCaption()); // detalles $this->detalles->EditAttrs["class"] = "form-control"; $this->detalles->EditCustomAttributes = ""; $this->detalles->EditValue = ew_HtmlEncode($this->detalles->CurrentValue); $this->detalles->PlaceHolder = ew_RemoveHtml($this->detalles->FldCaption()); // iva $this->iva->EditAttrs["class"] = "form-control"; $this->iva->EditCustomAttributes = ""; $this->iva->EditValue = ew_HtmlEncode($this->iva->CurrentValue); $this->iva->PlaceHolder = ew_RemoveHtml($this->iva->FldCaption()); if (strval($this->iva->EditValue) != "" && is_numeric($this->iva->EditValue)) { $this->iva->EditValue = ew_FormatNumber($this->iva->EditValue, -2, -1, -2, 0); $this->iva->OldValue = $this->iva->EditValue; } // Importe $this->Importe->EditAttrs["class"] = "form-control"; $this->Importe->EditCustomAttributes = ""; $this->Importe->EditValue = ew_HtmlEncode($this->Importe->CurrentValue); $this->Importe->PlaceHolder = ew_RemoveHtml($this->Importe->FldCaption()); if (strval($this->Importe->EditValue) != "" && is_numeric($this->Importe->EditValue)) { $this->Importe->EditValue = ew_FormatNumber($this->Importe->EditValue, -2, -1, -2, 0); $this->Importe->OldValue = $this->Importe->EditValue; } // id_tipo_gasto $this->id_tipo_gasto->EditAttrs["class"] = "form-control"; $this->id_tipo_gasto->EditCustomAttributes = ""; $this->id_tipo_gasto->EditValue = ew_HtmlEncode($this->id_tipo_gasto->CurrentValue); if (strval($this->id_tipo_gasto->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_tipo_gasto->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `tipo_gasto` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tipo_gastos`"; $sWhereWrk = ""; $lookuptblfilter = "`clase`='M'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_tipo_gasto, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `tipo_gasto` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_tipo_gasto->EditValue = ew_HtmlEncode($rswrk->fields('DispFld')); $rswrk->Close(); } else { $this->id_tipo_gasto->EditValue = ew_HtmlEncode($this->id_tipo_gasto->CurrentValue); } } else { $this->id_tipo_gasto->EditValue = NULL; } $this->id_tipo_gasto->PlaceHolder = ew_RemoveHtml($this->id_tipo_gasto->FldCaption()); // id_hoja_mantenimiento $this->id_hoja_mantenimiento->EditAttrs["class"] = "form-control"; $this->id_hoja_mantenimiento->EditCustomAttributes = ""; if ($this->id_hoja_mantenimiento->getSessionValue() != "") { $this->id_hoja_mantenimiento->CurrentValue = $this->id_hoja_mantenimiento->getSessionValue(); $this->id_hoja_mantenimiento->OldValue = $this->id_hoja_mantenimiento->CurrentValue; $this->id_hoja_mantenimiento->ViewValue = $this->id_hoja_mantenimiento->CurrentValue; $this->id_hoja_mantenimiento->ViewCustomAttributes = ""; } else { $this->id_hoja_mantenimiento->EditValue = ew_HtmlEncode($this->id_hoja_mantenimiento->CurrentValue); $this->id_hoja_mantenimiento->PlaceHolder = ew_RemoveHtml($this->id_hoja_mantenimiento->FldCaption()); } // Edit refer script // codigo $this->codigo->HrefValue = ""; // fecha $this->fecha->HrefValue = ""; // detalles $this->detalles->HrefValue = ""; // iva $this->iva->HrefValue = ""; // Importe $this->Importe->HrefValue = ""; // id_tipo_gasto $this->id_tipo_gasto->HrefValue = ""; // id_hoja_mantenimiento $this->id_hoja_mantenimiento->HrefValue = ""; } elseif ($this->RowType == EW_ROWTYPE_EDIT) { // Edit row // codigo $this->codigo->EditAttrs["class"] = "form-control"; $this->codigo->EditCustomAttributes = ""; $this->codigo->EditValue = $this->codigo->CurrentValue; $this->codigo->ViewCustomAttributes = ""; // fecha $this->fecha->EditAttrs["class"] = "form-control"; $this->fecha->EditCustomAttributes = ""; $this->fecha->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->fecha->CurrentValue, 7)); $this->fecha->PlaceHolder = ew_RemoveHtml($this->fecha->FldCaption()); // detalles $this->detalles->EditAttrs["class"] = "form-control"; $this->detalles->EditCustomAttributes = ""; $this->detalles->EditValue = ew_HtmlEncode($this->detalles->CurrentValue); $this->detalles->PlaceHolder = ew_RemoveHtml($this->detalles->FldCaption()); // iva $this->iva->EditAttrs["class"] = "form-control"; $this->iva->EditCustomAttributes = ""; $this->iva->EditValue = ew_HtmlEncode($this->iva->CurrentValue); $this->iva->PlaceHolder = ew_RemoveHtml($this->iva->FldCaption()); if (strval($this->iva->EditValue) != "" && is_numeric($this->iva->EditValue)) { $this->iva->EditValue = ew_FormatNumber($this->iva->EditValue, -2, -1, -2, 0); $this->iva->OldValue = $this->iva->EditValue; } // Importe $this->Importe->EditAttrs["class"] = "form-control"; $this->Importe->EditCustomAttributes = ""; $this->Importe->EditValue = ew_HtmlEncode($this->Importe->CurrentValue); $this->Importe->PlaceHolder = ew_RemoveHtml($this->Importe->FldCaption()); if (strval($this->Importe->EditValue) != "" && is_numeric($this->Importe->EditValue)) { $this->Importe->EditValue = ew_FormatNumber($this->Importe->EditValue, -2, -1, -2, 0); $this->Importe->OldValue = $this->Importe->EditValue; } // id_tipo_gasto $this->id_tipo_gasto->EditAttrs["class"] = "form-control"; $this->id_tipo_gasto->EditCustomAttributes = ""; $this->id_tipo_gasto->EditValue = ew_HtmlEncode($this->id_tipo_gasto->CurrentValue); if (strval($this->id_tipo_gasto->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_tipo_gasto->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `tipo_gasto` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tipo_gastos`"; $sWhereWrk = ""; $lookuptblfilter = "`clase`='M'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_tipo_gasto, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `tipo_gasto` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_tipo_gasto->EditValue = ew_HtmlEncode($rswrk->fields('DispFld')); $rswrk->Close(); } else { $this->id_tipo_gasto->EditValue = ew_HtmlEncode($this->id_tipo_gasto->CurrentValue); } } else { $this->id_tipo_gasto->EditValue = NULL; } $this->id_tipo_gasto->PlaceHolder = ew_RemoveHtml($this->id_tipo_gasto->FldCaption()); // id_hoja_mantenimiento $this->id_hoja_mantenimiento->EditAttrs["class"] = "form-control"; $this->id_hoja_mantenimiento->EditCustomAttributes = ""; if ($this->id_hoja_mantenimiento->getSessionValue() != "") { $this->id_hoja_mantenimiento->CurrentValue = $this->id_hoja_mantenimiento->getSessionValue(); $this->id_hoja_mantenimiento->OldValue = $this->id_hoja_mantenimiento->CurrentValue; $this->id_hoja_mantenimiento->ViewValue = $this->id_hoja_mantenimiento->CurrentValue; $this->id_hoja_mantenimiento->ViewCustomAttributes = ""; } else { $this->id_hoja_mantenimiento->EditValue = ew_HtmlEncode($this->id_hoja_mantenimiento->CurrentValue); $this->id_hoja_mantenimiento->PlaceHolder = ew_RemoveHtml($this->id_hoja_mantenimiento->FldCaption()); } // Edit refer script // codigo $this->codigo->HrefValue = ""; // fecha $this->fecha->HrefValue = ""; // detalles $this->detalles->HrefValue = ""; // iva $this->iva->HrefValue = ""; // Importe $this->Importe->HrefValue = ""; // id_tipo_gasto $this->id_tipo_gasto->HrefValue = ""; // id_hoja_mantenimiento $this->id_hoja_mantenimiento->HrefValue = ""; } if ($this->RowType == EW_ROWTYPE_ADD || $this->RowType == EW_ROWTYPE_EDIT || $this->RowType == EW_ROWTYPE_SEARCH) { // Add / Edit / Search row $this->SetupFieldTitles(); } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $Security, $Language, $gsLanguage; // Initialize URLs // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // memberID // name // email // joined // facebook // twitter // twitch // skype // birthday // profession // game_type // division // has_expansion // notes if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // memberID $this->memberID->ViewValue = $this->memberID->CurrentValue; $this->memberID->ViewCustomAttributes = ""; // name $this->name->ViewValue = $this->name->CurrentValue; $this->name->ViewCustomAttributes = ""; // email $this->_email->ViewValue = $this->_email->CurrentValue; $this->_email->ViewCustomAttributes = ""; // joined $this->joined->ViewValue = $this->joined->CurrentValue; $this->joined->ViewValue = ew_FormatDateTime($this->joined->ViewValue, undefined); $this->joined->ViewCustomAttributes = ""; // facebook $this->facebook->ViewValue = $this->facebook->CurrentValue; $this->facebook->ViewCustomAttributes = ""; // twitter $this->twitter->ViewValue = $this->twitter->CurrentValue; $this->twitter->ViewCustomAttributes = ""; // twitch $this->twitch->ViewValue = $this->twitch->CurrentValue; $this->twitch->ViewCustomAttributes = ""; // skype $this->skype->ViewValue = $this->skype->CurrentValue; $this->skype->ViewCustomAttributes = ""; // birthday $this->birthday->ViewValue = $this->birthday->CurrentValue; $this->birthday->ViewValue = ew_FormatDateTime($this->birthday->ViewValue, 5); $this->birthday->ViewCustomAttributes = ""; // profession if (strval($this->profession->CurrentValue) != "") { $this->profession->ViewValue = ""; $arwrk = explode(",", strval($this->profession->CurrentValue)); $cnt = count($arwrk); for ($ari = 0; $ari < $cnt; $ari++) { $this->profession->ViewValue .= $this->profession->OptionCaption(trim($arwrk[$ari])); if ($ari < $cnt - 1) { $this->profession->ViewValue .= ew_ViewOptionSeparator($ari); } } } else { $this->profession->ViewValue = NULL; } $this->profession->ViewCustomAttributes = ""; // game_type if (strval($this->game_type->CurrentValue) != "") { $this->game_type->ViewValue = ""; $arwrk = explode(",", strval($this->game_type->CurrentValue)); $cnt = count($arwrk); for ($ari = 0; $ari < $cnt; $ari++) { $this->game_type->ViewValue .= $this->game_type->OptionCaption(trim($arwrk[$ari])); if ($ari < $cnt - 1) { $this->game_type->ViewValue .= ew_ViewOptionSeparator($ari); } } } else { $this->game_type->ViewValue = NULL; } $this->game_type->ViewCustomAttributes = ""; // division if (strval($this->division->CurrentValue) != "") { $this->division->ViewValue = ""; $arwrk = explode(",", strval($this->division->CurrentValue)); $cnt = count($arwrk); for ($ari = 0; $ari < $cnt; $ari++) { $this->division->ViewValue .= $this->division->OptionCaption(trim($arwrk[$ari])); if ($ari < $cnt - 1) { $this->division->ViewValue .= ew_ViewOptionSeparator($ari); } } } else { $this->division->ViewValue = NULL; } $this->division->ViewCustomAttributes = ""; // has_expansion if (strval($this->has_expansion->CurrentValue) != "") { $this->has_expansion->ViewValue = $this->has_expansion->OptionCaption($this->has_expansion->CurrentValue); } else { $this->has_expansion->ViewValue = NULL; } $this->has_expansion->ViewCustomAttributes = ""; // notes $this->notes->ViewValue = $this->notes->CurrentValue; $this->notes->ViewCustomAttributes = ""; // name $this->name->LinkCustomAttributes = ""; $this->name->HrefValue = ""; $this->name->TooltipValue = ""; // email $this->_email->LinkCustomAttributes = ""; $this->_email->HrefValue = ""; $this->_email->TooltipValue = ""; // joined $this->joined->LinkCustomAttributes = ""; $this->joined->HrefValue = ""; $this->joined->TooltipValue = ""; // facebook $this->facebook->LinkCustomAttributes = ""; if (!ew_Empty($this->facebook->CurrentValue)) { $this->facebook->HrefValue = !empty($this->facebook->ViewValue) ? ew_RemoveHtml($this->facebook->ViewValue) : $this->facebook->CurrentValue; // Add prefix/suffix $this->facebook->LinkAttrs["target"] = "_blank"; // Add target if ($this->Export != "") { $this->facebook->HrefValue = ew_ConvertFullUrl($this->facebook->HrefValue); } } else { $this->facebook->HrefValue = ""; } $this->facebook->TooltipValue = ""; // twitter $this->twitter->LinkCustomAttributes = ""; if (!ew_Empty($this->twitter->CurrentValue)) { $this->twitter->HrefValue = !empty($this->twitter->ViewValue) ? ew_RemoveHtml($this->twitter->ViewValue) : $this->twitter->CurrentValue; // Add prefix/suffix $this->twitter->LinkAttrs["target"] = "_blank"; // Add target if ($this->Export != "") { $this->twitter->HrefValue = ew_ConvertFullUrl($this->twitter->HrefValue); } } else { $this->twitter->HrefValue = ""; } $this->twitter->TooltipValue = ""; // twitch $this->twitch->LinkCustomAttributes = ""; if (!ew_Empty($this->twitch->CurrentValue)) { $this->twitch->HrefValue = !empty($this->twitch->ViewValue) ? ew_RemoveHtml($this->twitch->ViewValue) : $this->twitch->CurrentValue; // Add prefix/suffix $this->twitch->LinkAttrs["target"] = "_blank"; // Add target if ($this->Export != "") { $this->twitch->HrefValue = ew_ConvertFullUrl($this->twitch->HrefValue); } } else { $this->twitch->HrefValue = ""; } $this->twitch->TooltipValue = ""; // skype $this->skype->LinkCustomAttributes = ""; $this->skype->HrefValue = ""; $this->skype->TooltipValue = ""; // birthday $this->birthday->LinkCustomAttributes = ""; $this->birthday->HrefValue = ""; $this->birthday->TooltipValue = ""; // profession $this->profession->LinkCustomAttributes = ""; $this->profession->HrefValue = ""; $this->profession->TooltipValue = ""; // game_type $this->game_type->LinkCustomAttributes = ""; $this->game_type->HrefValue = ""; $this->game_type->TooltipValue = ""; // division $this->division->LinkCustomAttributes = ""; $this->division->HrefValue = ""; $this->division->TooltipValue = ""; // has_expansion $this->has_expansion->LinkCustomAttributes = ""; $this->has_expansion->HrefValue = ""; $this->has_expansion->TooltipValue = ""; // notes $this->notes->LinkCustomAttributes = ""; if (!ew_Empty($this->notes->CurrentValue)) { $this->notes->HrefValue = !empty($this->notes->ViewValue) ? ew_RemoveHtml($this->notes->ViewValue) : $this->notes->CurrentValue; // Add prefix/suffix $this->notes->LinkAttrs["target"] = ""; // Add target if ($this->Export != "") { $this->notes->HrefValue = ew_ConvertFullUrl($this->notes->HrefValue); } } else { $this->notes->HrefValue = ""; } $this->notes->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_EDIT) { // Edit row // name $this->name->EditAttrs["class"] = "form-control"; $this->name->EditCustomAttributes = ""; $this->name->EditValue = ew_HtmlEncode($this->name->CurrentValue); $this->name->PlaceHolder = ew_RemoveHtml($this->name->FldCaption()); // email $this->_email->EditAttrs["class"] = "form-control"; $this->_email->EditCustomAttributes = ""; $this->_email->EditValue = ew_HtmlEncode($this->_email->CurrentValue); $this->_email->PlaceHolder = ew_RemoveHtml($this->_email->FldCaption()); // joined // facebook $this->facebook->EditAttrs["class"] = "form-control"; $this->facebook->EditCustomAttributes = ""; $this->facebook->EditValue = ew_HtmlEncode($this->facebook->CurrentValue); $this->facebook->PlaceHolder = ew_RemoveHtml($this->facebook->FldCaption()); // twitter $this->twitter->EditAttrs["class"] = "form-control"; $this->twitter->EditCustomAttributes = ""; $this->twitter->EditValue = ew_HtmlEncode($this->twitter->CurrentValue); $this->twitter->PlaceHolder = ew_RemoveHtml($this->twitter->FldCaption()); // twitch $this->twitch->EditAttrs["class"] = "form-control"; $this->twitch->EditCustomAttributes = ""; $this->twitch->EditValue = ew_HtmlEncode($this->twitch->CurrentValue); $this->twitch->PlaceHolder = ew_RemoveHtml($this->twitch->FldCaption()); // skype $this->skype->EditAttrs["class"] = "form-control"; $this->skype->EditCustomAttributes = ""; $this->skype->EditValue = ew_HtmlEncode($this->skype->CurrentValue); $this->skype->PlaceHolder = ew_RemoveHtml($this->skype->FldCaption()); // birthday $this->birthday->EditAttrs["class"] = "form-control"; $this->birthday->EditCustomAttributes = ""; $this->birthday->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->birthday->CurrentValue, 5)); $this->birthday->PlaceHolder = ew_RemoveHtml($this->birthday->FldCaption()); // profession $this->profession->EditAttrs["class"] = "form-control"; $this->profession->EditCustomAttributes = ""; $this->profession->EditValue = $this->profession->Options(FALSE); // game_type $this->game_type->EditCustomAttributes = ""; $this->game_type->EditValue = $this->game_type->Options(FALSE); // division $this->division->EditCustomAttributes = ""; $this->division->EditValue = $this->division->Options(FALSE); // has_expansion $this->has_expansion->EditCustomAttributes = ""; $this->has_expansion->EditValue = $this->has_expansion->Options(TRUE); // notes $this->notes->EditAttrs["class"] = "form-control"; $this->notes->EditCustomAttributes = ""; $this->notes->EditValue = ew_HtmlEncode($this->notes->CurrentValue); $this->notes->PlaceHolder = ew_RemoveHtml($this->notes->FldCaption()); // Edit refer script // name $this->name->LinkCustomAttributes = ""; $this->name->HrefValue = ""; // email $this->_email->LinkCustomAttributes = ""; $this->_email->HrefValue = ""; // joined $this->joined->LinkCustomAttributes = ""; $this->joined->HrefValue = ""; // facebook $this->facebook->LinkCustomAttributes = ""; if (!ew_Empty($this->facebook->CurrentValue)) { $this->facebook->HrefValue = !empty($this->facebook->EditValue) ? ew_RemoveHtml($this->facebook->EditValue) : $this->facebook->CurrentValue; // Add prefix/suffix $this->facebook->LinkAttrs["target"] = "_blank"; // Add target if ($this->Export != "") { $this->facebook->HrefValue = ew_ConvertFullUrl($this->facebook->HrefValue); } } else { $this->facebook->HrefValue = ""; } // twitter $this->twitter->LinkCustomAttributes = ""; if (!ew_Empty($this->twitter->CurrentValue)) { $this->twitter->HrefValue = !empty($this->twitter->EditValue) ? ew_RemoveHtml($this->twitter->EditValue) : $this->twitter->CurrentValue; // Add prefix/suffix $this->twitter->LinkAttrs["target"] = "_blank"; // Add target if ($this->Export != "") { $this->twitter->HrefValue = ew_ConvertFullUrl($this->twitter->HrefValue); } } else { $this->twitter->HrefValue = ""; } // twitch $this->twitch->LinkCustomAttributes = ""; if (!ew_Empty($this->twitch->CurrentValue)) { $this->twitch->HrefValue = !empty($this->twitch->EditValue) ? ew_RemoveHtml($this->twitch->EditValue) : $this->twitch->CurrentValue; // Add prefix/suffix $this->twitch->LinkAttrs["target"] = "_blank"; // Add target if ($this->Export != "") { $this->twitch->HrefValue = ew_ConvertFullUrl($this->twitch->HrefValue); } } else { $this->twitch->HrefValue = ""; } // skype $this->skype->LinkCustomAttributes = ""; $this->skype->HrefValue = ""; // birthday $this->birthday->LinkCustomAttributes = ""; $this->birthday->HrefValue = ""; // profession $this->profession->LinkCustomAttributes = ""; $this->profession->HrefValue = ""; // game_type $this->game_type->LinkCustomAttributes = ""; $this->game_type->HrefValue = ""; // division $this->division->LinkCustomAttributes = ""; $this->division->HrefValue = ""; // has_expansion $this->has_expansion->LinkCustomAttributes = ""; $this->has_expansion->HrefValue = ""; // notes $this->notes->LinkCustomAttributes = ""; if (!ew_Empty($this->notes->CurrentValue)) { $this->notes->HrefValue = !empty($this->notes->EditValue) ? ew_RemoveHtml($this->notes->EditValue) : $this->notes->CurrentValue; // Add prefix/suffix $this->notes->LinkAttrs["target"] = ""; // Add target if ($this->Export != "") { $this->notes->HrefValue = ew_ConvertFullUrl($this->notes->HrefValue); } } else { $this->notes->HrefValue = ""; } } if ($this->RowType == EW_ROWTYPE_ADD || $this->RowType == EW_ROWTYPE_EDIT || $this->RowType == EW_ROWTYPE_SEARCH) { // Add / Edit / Search row $this->SetupFieldTitles(); } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
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 RenderEditRow() { global $conn, $Security, $gsLanguage, $Language; // Call Row Rendering event $this->Row_Rendering(); // codigo $this->codigo->EditAttrs["class"] = "form-control"; $this->codigo->EditCustomAttributes = ""; $this->codigo->EditValue = $this->codigo->CurrentValue; $this->codigo->ViewCustomAttributes = ""; // detalle $this->detalle->EditAttrs["class"] = "form-control"; $this->detalle->EditCustomAttributes = ""; $this->detalle->EditValue = ew_HtmlEncode($this->detalle->CurrentValue); $this->detalle->PlaceHolder = ew_RemoveHtml($this->detalle->FldCaption()); // fecha $this->fecha->EditAttrs["class"] = "form-control"; $this->fecha->EditCustomAttributes = ""; $this->fecha->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->fecha->CurrentValue, 7)); $this->fecha->PlaceHolder = ew_RemoveHtml($this->fecha->FldCaption()); // id_tipo_gasto $this->id_tipo_gasto->EditAttrs["class"] = "form-control"; $this->id_tipo_gasto->EditCustomAttributes = ""; if ($this->id_tipo_gasto->getSessionValue() != "") { $this->id_tipo_gasto->CurrentValue = $this->id_tipo_gasto->getSessionValue(); if ($this->id_tipo_gasto->VirtualValue != "") { $this->id_tipo_gasto->ViewValue = $this->id_tipo_gasto->VirtualValue; } else { if (strval($this->id_tipo_gasto->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_tipo_gasto->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `tipo_gasto` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tipo_gastos`"; $sWhereWrk = ""; $lookuptblfilter = "`clase`='M'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_tipo_gasto, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `tipo_gasto` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_tipo_gasto->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->id_tipo_gasto->ViewValue = $this->id_tipo_gasto->CurrentValue; } } else { $this->id_tipo_gasto->ViewValue = NULL; } } $this->id_tipo_gasto->ViewCustomAttributes = ""; } else { } // id_hoja_mantenimeinto $this->id_hoja_mantenimeinto->EditAttrs["class"] = "form-control"; $this->id_hoja_mantenimeinto->EditCustomAttributes = ""; if ($this->id_hoja_mantenimeinto->getSessionValue() != "") { $this->id_hoja_mantenimeinto->CurrentValue = $this->id_hoja_mantenimeinto->getSessionValue(); $this->id_hoja_mantenimeinto->ViewValue = $this->id_hoja_mantenimeinto->CurrentValue; $this->id_hoja_mantenimeinto->ViewCustomAttributes = ""; } else { $this->id_hoja_mantenimeinto->EditValue = ew_HtmlEncode($this->id_hoja_mantenimeinto->CurrentValue); $this->id_hoja_mantenimeinto->PlaceHolder = ew_RemoveHtml($this->id_hoja_mantenimeinto->FldCaption()); } // id_usuario // Call Row Rendered event $this->Row_Rendered(); }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs // Convert decimal values if posted back if ($this->monto->FormValue == $this->monto->CurrentValue && is_numeric(ew_StrToFloat($this->monto->CurrentValue))) { $this->monto->CurrentValue = ew_StrToFloat($this->monto->CurrentValue); } // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // id // mes // anio // fecha // monto // id_usuario // id_socio if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // id $this->id->ViewCustomAttributes = ""; // mes $this->mes->ViewValue = $this->mes->CurrentValue; $this->mes->ViewCustomAttributes = ""; // anio $this->anio->ViewValue = $this->anio->CurrentValue; $this->anio->ViewCustomAttributes = ""; // fecha $this->fecha->ViewValue = $this->fecha->CurrentValue; $this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7); $this->fecha->ViewCustomAttributes = ""; // monto $this->monto->ViewValue = $this->monto->CurrentValue; $this->monto->ViewValue = ew_FormatCurrency($this->monto->ViewValue, 0, -2, -2, -2); $this->monto->ViewCustomAttributes = ""; // id_socio if (strval($this->id_socio->CurrentValue) != "") { $sFilterWrk = "`socio_nro`" . ew_SearchString("=", $this->id_socio->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `socio_nro`, `propietario` AS `DispFld`, `comercio` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `socios`"; $sWhereWrk = ""; $lookuptblfilter = "`activo`='S'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_socio, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `propietario` DESC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_socio->ViewValue = $rswrk->fields('DispFld'); $this->id_socio->ViewValue .= ew_ValueSeparator(1, $this->id_socio) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_socio->ViewValue = $this->id_socio->CurrentValue; } } else { $this->id_socio->ViewValue = NULL; } $this->id_socio->ViewCustomAttributes = ""; // mes $this->mes->LinkCustomAttributes = ""; $this->mes->HrefValue = ""; $this->mes->TooltipValue = ""; // anio $this->anio->LinkCustomAttributes = ""; $this->anio->HrefValue = ""; $this->anio->TooltipValue = ""; // fecha $this->fecha->LinkCustomAttributes = ""; $this->fecha->HrefValue = ""; $this->fecha->TooltipValue = ""; // monto $this->monto->LinkCustomAttributes = ""; $this->monto->HrefValue = ""; $this->monto->TooltipValue = ""; // id_socio $this->id_socio->LinkCustomAttributes = ""; $this->id_socio->HrefValue = ""; $this->id_socio->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_ADD) { // Add row // mes $this->mes->EditAttrs["class"] = "form-control"; $this->mes->EditCustomAttributes = ""; $this->mes->EditValue = ew_HtmlEncode($this->mes->CurrentValue); $this->mes->PlaceHolder = ew_RemoveHtml($this->mes->FldCaption()); // anio $this->anio->EditAttrs["class"] = "form-control"; $this->anio->EditCustomAttributes = ""; $this->anio->EditValue = ew_HtmlEncode($this->anio->CurrentValue); $this->anio->PlaceHolder = ew_RemoveHtml($this->anio->FldCaption()); // fecha $this->fecha->EditAttrs["class"] = "form-control"; $this->fecha->EditCustomAttributes = ""; $this->fecha->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->fecha->CurrentValue, 7)); $this->fecha->PlaceHolder = ew_RemoveHtml($this->fecha->FldCaption()); // monto $this->monto->EditAttrs["class"] = "form-control"; $this->monto->EditCustomAttributes = ""; $this->monto->EditValue = ew_HtmlEncode($this->monto->CurrentValue); $this->monto->PlaceHolder = ew_RemoveHtml($this->monto->FldCaption()); if (strval($this->monto->EditValue) != "" && is_numeric($this->monto->EditValue)) { $this->monto->EditValue = ew_FormatNumber($this->monto->EditValue, -2, -2, -2, -2); } // id_socio $this->id_socio->EditAttrs["class"] = "form-control"; $this->id_socio->EditCustomAttributes = ""; if ($this->id_socio->getSessionValue() != "") { $this->id_socio->CurrentValue = $this->id_socio->getSessionValue(); if (strval($this->id_socio->CurrentValue) != "") { $sFilterWrk = "`socio_nro`" . ew_SearchString("=", $this->id_socio->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `socio_nro`, `propietario` AS `DispFld`, `comercio` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `socios`"; $sWhereWrk = ""; $lookuptblfilter = "`activo`='S'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_socio, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `propietario` DESC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_socio->ViewValue = $rswrk->fields('DispFld'); $this->id_socio->ViewValue .= ew_ValueSeparator(1, $this->id_socio) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_socio->ViewValue = $this->id_socio->CurrentValue; } } else { $this->id_socio->ViewValue = NULL; } $this->id_socio->ViewCustomAttributes = ""; } else { if (trim(strval($this->id_socio->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`socio_nro`" . ew_SearchString("=", $this->id_socio->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `socio_nro`, `propietario` AS `DispFld`, `comercio` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `socios`"; $sWhereWrk = ""; $lookuptblfilter = "`activo`='S'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } if (!$GLOBALS["deudas"]->UserIDAllow("add")) { $sWhereWrk = $GLOBALS["socios"]->AddUserIDFilter($sWhereWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_socio, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `propietario` DESC"; $rswrk = $conn->Execute($sSqlWrk); $arwrk = $rswrk ? $rswrk->GetRows() : array(); if ($rswrk) { $rswrk->Close(); } array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"), "", "", "", "", "", "", "")); $this->id_socio->EditValue = $arwrk; } // Edit refer script // mes $this->mes->HrefValue = ""; // anio $this->anio->HrefValue = ""; // fecha $this->fecha->HrefValue = ""; // monto $this->monto->HrefValue = ""; // id_socio $this->id_socio->HrefValue = ""; } if ($this->RowType == EW_ROWTYPE_ADD || $this->RowType == EW_ROWTYPE_EDIT || $this->RowType == EW_ROWTYPE_SEARCH) { // Add / Edit / Search row $this->SetupFieldTitles(); } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $Language, $order; // Initialize URLs $this->ViewUrl = $order->ViewUrl(); $this->EditUrl = $order->EditUrl(); $this->InlineEditUrl = $order->InlineEditUrl(); $this->CopyUrl = $order->CopyUrl(); $this->InlineCopyUrl = $order->InlineCopyUrl(); $this->DeleteUrl = $order->DeleteUrl(); // Call Row_Rendering event $order->Row_Rendering(); // Common render codes for all row types // orderid $order->orderid->CellCssStyle = ""; $order->orderid->CellCssClass = ""; $order->orderid->CellAttrs = array(); $order->orderid->ViewAttrs = array(); $order->orderid->EditAttrs = array(); // bookid $order->bookid->CellCssStyle = ""; $order->bookid->CellCssClass = ""; $order->bookid->CellAttrs = array(); $order->bookid->ViewAttrs = array(); $order->bookid->EditAttrs = array(); // orderstatus $order->orderstatus->CellCssStyle = ""; $order->orderstatus->CellCssClass = ""; $order->orderstatus->CellAttrs = array(); $order->orderstatus->ViewAttrs = array(); $order->orderstatus->EditAttrs = array(); // email $order->zemail->CellCssStyle = ""; $order->zemail->CellCssClass = ""; $order->zemail->CellAttrs = array(); $order->zemail->ViewAttrs = array(); $order->zemail->EditAttrs = array(); // datatime $order->datatime->CellCssStyle = ""; $order->datatime->CellCssClass = ""; $order->datatime->CellAttrs = array(); $order->datatime->ViewAttrs = array(); $order->datatime->EditAttrs = array(); if ($order->RowType == EW_ROWTYPE_VIEW) { // View row // orderid $order->orderid->ViewValue = $order->orderid->CurrentValue; $order->orderid->CssStyle = ""; $order->orderid->CssClass = ""; $order->orderid->ViewCustomAttributes = ""; // bookid $order->bookid->ViewValue = $order->bookid->CurrentValue; $order->bookid->CssStyle = ""; $order->bookid->CssClass = ""; $order->bookid->ViewCustomAttributes = ""; // orderstatus $order->orderstatus->ViewValue = $order->orderstatus->CurrentValue; $order->orderstatus->CssStyle = ""; $order->orderstatus->CssClass = ""; $order->orderstatus->ViewCustomAttributes = ""; // email $order->zemail->ViewValue = $order->zemail->CurrentValue; $order->zemail->CssStyle = ""; $order->zemail->CssClass = ""; $order->zemail->ViewCustomAttributes = ""; // datatime $order->datatime->ViewValue = $order->datatime->CurrentValue; $order->datatime->ViewValue = ew_FormatDateTime($order->datatime->ViewValue, 5); $order->datatime->CssStyle = ""; $order->datatime->CssClass = ""; $order->datatime->ViewCustomAttributes = ""; // orderid $order->orderid->HrefValue = ""; $order->orderid->TooltipValue = ""; // bookid $order->bookid->HrefValue = ""; $order->bookid->TooltipValue = ""; // orderstatus $order->orderstatus->HrefValue = ""; $order->orderstatus->TooltipValue = ""; // email $order->zemail->HrefValue = ""; $order->zemail->TooltipValue = ""; // datatime $order->datatime->HrefValue = ""; $order->datatime->TooltipValue = ""; } // Call Row Rendered event if ($order->RowType != EW_ROWTYPE_AGGREGATEINIT) { $order->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs // Convert decimal values if posted back if ($this->importe->FormValue == $this->importe->CurrentValue && is_numeric(ew_StrToFloat($this->importe->CurrentValue))) { $this->importe->CurrentValue = ew_StrToFloat($this->importe->CurrentValue); } // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // id // descripcion // importe // fecha_creacion // activa // id_usuario if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // id $this->id->ViewValue = $this->id->CurrentValue; $this->id->ViewCustomAttributes = ""; // descripcion $this->descripcion->ViewValue = $this->descripcion->CurrentValue; $this->descripcion->ViewCustomAttributes = ""; // importe $this->importe->ViewValue = $this->importe->CurrentValue; $this->importe->ViewValue = ew_FormatCurrency($this->importe->ViewValue, 0, -2, -2, -2); $this->importe->ViewCustomAttributes = ""; // fecha_creacion $this->fecha_creacion->ViewValue = $this->fecha_creacion->CurrentValue; $this->fecha_creacion->ViewValue = ew_FormatDateTime($this->fecha_creacion->ViewValue, 7); $this->fecha_creacion->ViewCustomAttributes = ""; // activa if (strval($this->activa->CurrentValue) != "") { switch ($this->activa->CurrentValue) { case $this->activa->FldTagValue(1): $this->activa->ViewValue = $this->activa->FldTagCaption(1) != "" ? $this->activa->FldTagCaption(1) : $this->activa->CurrentValue; break; case $this->activa->FldTagValue(2): $this->activa->ViewValue = $this->activa->FldTagCaption(2) != "" ? $this->activa->FldTagCaption(2) : $this->activa->CurrentValue; break; default: $this->activa->ViewValue = $this->activa->CurrentValue; } } else { $this->activa->ViewValue = NULL; } $this->activa->ViewCustomAttributes = ""; // descripcion $this->descripcion->LinkCustomAttributes = ""; $this->descripcion->HrefValue = ""; $this->descripcion->TooltipValue = ""; // importe $this->importe->LinkCustomAttributes = ""; $this->importe->HrefValue = ""; $this->importe->TooltipValue = ""; // fecha_creacion $this->fecha_creacion->LinkCustomAttributes = ""; $this->fecha_creacion->HrefValue = ""; $this->fecha_creacion->TooltipValue = ""; // activa $this->activa->LinkCustomAttributes = ""; $this->activa->HrefValue = ""; $this->activa->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_ADD) { // Add row // descripcion $this->descripcion->EditAttrs["class"] = "form-control"; $this->descripcion->EditCustomAttributes = ""; $this->descripcion->EditValue = ew_HtmlEncode($this->descripcion->CurrentValue); $this->descripcion->PlaceHolder = ew_RemoveHtml($this->descripcion->FldCaption()); // importe $this->importe->EditAttrs["class"] = "form-control"; $this->importe->EditCustomAttributes = ""; $this->importe->EditValue = ew_HtmlEncode($this->importe->CurrentValue); $this->importe->PlaceHolder = ew_RemoveHtml($this->importe->FldCaption()); if (strval($this->importe->EditValue) != "" && is_numeric($this->importe->EditValue)) { $this->importe->EditValue = ew_FormatNumber($this->importe->EditValue, -2, -2, -2, -2); } // fecha_creacion $this->fecha_creacion->EditAttrs["class"] = "form-control"; $this->fecha_creacion->EditCustomAttributes = ""; $this->fecha_creacion->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->fecha_creacion->CurrentValue, 7)); $this->fecha_creacion->PlaceHolder = ew_RemoveHtml($this->fecha_creacion->FldCaption()); // activa $this->activa->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array($this->activa->FldTagValue(1), $this->activa->FldTagCaption(1) != "" ? $this->activa->FldTagCaption(1) : $this->activa->FldTagValue(1)); $arwrk[] = array($this->activa->FldTagValue(2), $this->activa->FldTagCaption(2) != "" ? $this->activa->FldTagCaption(2) : $this->activa->FldTagValue(2)); $this->activa->EditValue = $arwrk; // Edit refer script // descripcion $this->descripcion->HrefValue = ""; // importe $this->importe->HrefValue = ""; // fecha_creacion $this->fecha_creacion->HrefValue = ""; // activa $this->activa->HrefValue = ""; } if ($this->RowType == EW_ROWTYPE_ADD || $this->RowType == EW_ROWTYPE_EDIT || $this->RowType == EW_ROWTYPE_SEARCH) { // Add / Edit / Search row $this->SetupFieldTitles(); } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs $this->ViewUrl = $this->GetViewUrl(); $this->EditUrl = $this->GetEditUrl(); $this->InlineEditUrl = $this->GetInlineEditUrl(); $this->CopyUrl = $this->GetCopyUrl(); $this->InlineCopyUrl = $this->GetInlineCopyUrl(); $this->DeleteUrl = $this->GetDeleteUrl(); // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // EvaluateAnswerID // EvAnswer // lastModified // Date // ID if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // EvaluateAnswerID $this->EvaluateAnswerID->ViewValue = $this->EvaluateAnswerID->CurrentValue; $this->EvaluateAnswerID->ViewCustomAttributes = ""; // lastModified $this->lastModified->ViewValue = $this->lastModified->CurrentValue; $this->lastModified->ViewValue = ew_FormatDateTime($this->lastModified->ViewValue, 5); $this->lastModified->ViewCustomAttributes = ""; // Date $this->Date->ViewValue = $this->Date->CurrentValue; $this->Date->ViewValue = ew_FormatDateTime($this->Date->ViewValue, 5); $this->Date->ViewCustomAttributes = ""; // ID if (strval($this->ID->CurrentValue) != "") { $sFilterWrk = "`ID`" . ew_SearchString("=", $this->ID->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `ID`, `Email` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `Users`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->ID, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->ID->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->ID->ViewValue = $this->ID->CurrentValue; } } else { $this->ID->ViewValue = NULL; } $this->ID->ViewCustomAttributes = ""; // EvaluateAnswerID $this->EvaluateAnswerID->LinkCustomAttributes = ""; $this->EvaluateAnswerID->HrefValue = ""; $this->EvaluateAnswerID->TooltipValue = ""; // lastModified $this->lastModified->LinkCustomAttributes = ""; $this->lastModified->HrefValue = ""; $this->lastModified->TooltipValue = ""; // Date $this->Date->LinkCustomAttributes = ""; $this->Date->HrefValue = ""; $this->Date->TooltipValue = ""; // ID $this->ID->LinkCustomAttributes = ""; $this->ID->HrefValue = ""; $this->ID->TooltipValue = ""; } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs $this->ViewUrl = $this->GetViewUrl(); $this->EditUrl = $this->GetEditUrl(); $this->InlineEditUrl = $this->GetInlineEditUrl(); $this->CopyUrl = $this->GetCopyUrl(); $this->InlineCopyUrl = $this->GetInlineCopyUrl(); $this->DeleteUrl = $this->GetDeleteUrl(); // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // id_tramite // fecha // hora // titulo // descripcion // id_usuario $this->id_usuario->CellCssStyle = "white-space: nowrap;"; // archivo if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // id_tramite if ($this->id_tramite->VirtualValue != "") { $this->id_tramite->ViewValue = $this->id_tramite->VirtualValue; } else { if (strval($this->id_tramite->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_tramite->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `codigo` AS `DispFld`, `fecha` AS `Disp2Fld`, `Titulo` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tramites`"; $sWhereWrk = ""; $lookuptblfilter = "`estado`<>'F'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_tramite, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `fecha` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_tramite->ViewValue = $rswrk->fields('DispFld'); $this->id_tramite->ViewValue .= ew_ValueSeparator(1, $this->id_tramite) . ew_FormatDateTime($rswrk->fields('Disp2Fld'), 7); $this->id_tramite->ViewValue .= ew_ValueSeparator(2, $this->id_tramite) . $rswrk->fields('Disp3Fld'); $rswrk->Close(); } else { $this->id_tramite->ViewValue = $this->id_tramite->CurrentValue; } } else { $this->id_tramite->ViewValue = NULL; } } $this->id_tramite->ViewCustomAttributes = ""; // fecha $this->fecha->ViewValue = $this->fecha->CurrentValue; $this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7); $this->fecha->ViewCustomAttributes = ""; // hora $this->hora->ViewValue = $this->hora->CurrentValue; $this->hora->ViewCustomAttributes = ""; // titulo $this->titulo->ViewValue = $this->titulo->CurrentValue; $this->titulo->ViewCustomAttributes = ""; // archivo if (!ew_Empty($this->archivo->Upload->DbValue)) { $this->archivo->ViewValue = $this->archivo->Upload->DbValue; } else { $this->archivo->ViewValue = ""; } $this->archivo->ViewCustomAttributes = ""; // id_tramite $this->id_tramite->LinkCustomAttributes = ""; $this->id_tramite->HrefValue = ""; $this->id_tramite->TooltipValue = ""; // fecha $this->fecha->LinkCustomAttributes = ""; $this->fecha->HrefValue = ""; $this->fecha->TooltipValue = ""; // hora $this->hora->LinkCustomAttributes = ""; $this->hora->HrefValue = ""; $this->hora->TooltipValue = ""; // titulo $this->titulo->LinkCustomAttributes = ""; $this->titulo->HrefValue = ""; $this->titulo->TooltipValue = ""; // archivo $this->archivo->LinkCustomAttributes = ""; $this->archivo->HrefValue = ""; $this->archivo->HrefValue2 = $this->archivo->UploadPath . $this->archivo->Upload->DbValue; $this->archivo->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_ADD) { // Add row // id_tramite $this->id_tramite->EditAttrs["class"] = "form-control"; $this->id_tramite->EditCustomAttributes = ""; if ($this->id_tramite->getSessionValue() != "") { $this->id_tramite->CurrentValue = $this->id_tramite->getSessionValue(); $this->id_tramite->OldValue = $this->id_tramite->CurrentValue; if ($this->id_tramite->VirtualValue != "") { $this->id_tramite->ViewValue = $this->id_tramite->VirtualValue; } else { if (strval($this->id_tramite->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_tramite->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `codigo` AS `DispFld`, `fecha` AS `Disp2Fld`, `Titulo` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tramites`"; $sWhereWrk = ""; $lookuptblfilter = "`estado`<>'F'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_tramite, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `fecha` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_tramite->ViewValue = $rswrk->fields('DispFld'); $this->id_tramite->ViewValue .= ew_ValueSeparator(1, $this->id_tramite) . ew_FormatDateTime($rswrk->fields('Disp2Fld'), 7); $this->id_tramite->ViewValue .= ew_ValueSeparator(2, $this->id_tramite) . $rswrk->fields('Disp3Fld'); $rswrk->Close(); } else { $this->id_tramite->ViewValue = $this->id_tramite->CurrentValue; } } else { $this->id_tramite->ViewValue = NULL; } } $this->id_tramite->ViewCustomAttributes = ""; } else { if (trim(strval($this->id_tramite->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_tramite->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `codigo`, `codigo` AS `DispFld`, `fecha` AS `Disp2Fld`, `Titulo` AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `tramites`"; $sWhereWrk = ""; $lookuptblfilter = "`estado`<>'F'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_tramite, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `fecha` ASC"; $rswrk = $conn->Execute($sSqlWrk); $arwrk = $rswrk ? $rswrk->GetRows() : array(); if ($rswrk) { $rswrk->Close(); } $rowswrk = count($arwrk); for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $arwrk[$rowcntwrk][2] = ew_FormatDateTime($arwrk[$rowcntwrk][2], 7); } array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"), "", "", "", "", "", "", "")); $this->id_tramite->EditValue = $arwrk; } // fecha // hora // titulo $this->titulo->EditAttrs["class"] = "form-control"; $this->titulo->EditCustomAttributes = ""; $this->titulo->EditValue = ew_HtmlEncode($this->titulo->CurrentValue); $this->titulo->PlaceHolder = ew_RemoveHtml($this->titulo->FldCaption()); // archivo $this->archivo->EditAttrs["class"] = "form-control"; $this->archivo->EditCustomAttributes = ""; if (!ew_Empty($this->archivo->Upload->DbValue)) { $this->archivo->EditValue = $this->archivo->Upload->DbValue; } else { $this->archivo->EditValue = ""; } if (!ew_Empty($this->archivo->CurrentValue)) { $this->archivo->Upload->FileName = $this->archivo->CurrentValue; } if (is_numeric($this->RowIndex) && !$this->EventCancelled) { ew_RenderUploadField($this->archivo, $this->RowIndex); } // Edit refer script // id_tramite $this->id_tramite->HrefValue = ""; // fecha $this->fecha->HrefValue = ""; // hora $this->hora->HrefValue = ""; // titulo $this->titulo->HrefValue = ""; // archivo $this->archivo->HrefValue = ""; $this->archivo->HrefValue2 = $this->archivo->UploadPath . $this->archivo->Upload->DbValue; } elseif ($this->RowType == EW_ROWTYPE_EDIT) { // Edit row // id_tramite $this->id_tramite->EditAttrs["class"] = "form-control"; $this->id_tramite->EditCustomAttributes = ""; if ($this->id_tramite->VirtualValue != "") { $this->id_tramite->ViewValue = $this->id_tramite->VirtualValue; } else { if (strval($this->id_tramite->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_tramite->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `codigo` AS `DispFld`, `fecha` AS `Disp2Fld`, `Titulo` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tramites`"; $sWhereWrk = ""; $lookuptblfilter = "`estado`<>'F'"; if (strval($lookuptblfilter) != "") { ew_AddFilter($sWhereWrk, $lookuptblfilter); } if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_tramite, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `fecha` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_tramite->EditValue = $rswrk->fields('DispFld'); $this->id_tramite->EditValue .= ew_ValueSeparator(1, $this->id_tramite) . ew_FormatDateTime($rswrk->fields('Disp2Fld'), 7); $this->id_tramite->EditValue .= ew_ValueSeparator(2, $this->id_tramite) . $rswrk->fields('Disp3Fld'); $rswrk->Close(); } else { $this->id_tramite->EditValue = $this->id_tramite->CurrentValue; } } else { $this->id_tramite->EditValue = NULL; } } $this->id_tramite->ViewCustomAttributes = ""; // fecha // hora // titulo $this->titulo->EditAttrs["class"] = "form-control"; $this->titulo->EditCustomAttributes = ""; $this->titulo->EditValue = $this->titulo->CurrentValue; $this->titulo->ViewCustomAttributes = ""; // archivo $this->archivo->EditAttrs["class"] = "form-control"; $this->archivo->EditCustomAttributes = ""; if (!ew_Empty($this->archivo->Upload->DbValue)) { $this->archivo->EditValue = $this->archivo->Upload->DbValue; } else { $this->archivo->EditValue = ""; } $this->archivo->ViewCustomAttributes = ""; // Edit refer script // id_tramite $this->id_tramite->HrefValue = ""; // fecha $this->fecha->HrefValue = ""; // hora $this->hora->HrefValue = ""; // titulo $this->titulo->HrefValue = ""; // archivo $this->archivo->HrefValue = ""; $this->archivo->HrefValue2 = $this->archivo->UploadPath . $this->archivo->Upload->DbValue; } if ($this->RowType == EW_ROWTYPE_ADD || $this->RowType == EW_ROWTYPE_EDIT || $this->RowType == EW_ROWTYPE_SEARCH) { // Add / Edit / Search row $this->SetupFieldTitles(); } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs $this->AddUrl = $this->GetAddUrl(); $this->EditUrl = $this->GetEditUrl(); $this->CopyUrl = $this->GetCopyUrl(); $this->DeleteUrl = $this->GetDeleteUrl(); $this->ListUrl = $this->GetListUrl(); $this->SetupOtherOptions(); // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // guru_id // nip // nama // tempat_lahir // tanggal_lahir // alamat // agama // no_hp // email if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // guru_id $this->guru_id->ViewValue = $this->guru_id->CurrentValue; $this->guru_id->ViewCustomAttributes = ""; // nip $this->nip->ViewValue = $this->nip->CurrentValue; $this->nip->ViewCustomAttributes = ""; // nama $this->nama->ViewValue = $this->nama->CurrentValue; $this->nama->ViewCustomAttributes = ""; // tempat_lahir $this->tempat_lahir->ViewValue = $this->tempat_lahir->CurrentValue; $this->tempat_lahir->ViewCustomAttributes = ""; // tanggal_lahir $this->tanggal_lahir->ViewValue = $this->tanggal_lahir->CurrentValue; $this->tanggal_lahir->ViewValue = ew_FormatDateTime($this->tanggal_lahir->ViewValue, 5); $this->tanggal_lahir->ViewCustomAttributes = ""; // alamat $this->alamat->ViewValue = $this->alamat->CurrentValue; $this->alamat->ViewCustomAttributes = ""; // agama $this->agama->ViewValue = $this->agama->CurrentValue; $this->agama->ViewCustomAttributes = ""; // no_hp $this->no_hp->ViewValue = $this->no_hp->CurrentValue; $this->no_hp->ViewCustomAttributes = ""; // email $this->_email->ViewValue = $this->_email->CurrentValue; $this->_email->ViewCustomAttributes = ""; // nip $this->nip->LinkCustomAttributes = ""; $this->nip->HrefValue = ""; $this->nip->TooltipValue = ""; // nama $this->nama->LinkCustomAttributes = ""; $this->nama->HrefValue = ""; $this->nama->TooltipValue = ""; // tempat_lahir $this->tempat_lahir->LinkCustomAttributes = ""; $this->tempat_lahir->HrefValue = ""; $this->tempat_lahir->TooltipValue = ""; // tanggal_lahir $this->tanggal_lahir->LinkCustomAttributes = ""; $this->tanggal_lahir->HrefValue = ""; $this->tanggal_lahir->TooltipValue = ""; // alamat $this->alamat->LinkCustomAttributes = ""; $this->alamat->HrefValue = ""; $this->alamat->TooltipValue = ""; // agama $this->agama->LinkCustomAttributes = ""; $this->agama->HrefValue = ""; $this->agama->TooltipValue = ""; // no_hp $this->no_hp->LinkCustomAttributes = ""; $this->no_hp->HrefValue = ""; $this->no_hp->TooltipValue = ""; // email $this->_email->LinkCustomAttributes = ""; $this->_email->HrefValue = ""; $this->_email->TooltipValue = ""; } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $password_reset_requests; // Call Row_Rendering event $password_reset_requests->Row_Rendering(); // Common render codes for all row types // id $password_reset_requests->id->CellCssStyle = ""; $password_reset_requests->id->CellCssClass = ""; // CustomerID $password_reset_requests->CustomerID->CellCssStyle = ""; $password_reset_requests->CustomerID->CellCssClass = ""; // token_id $password_reset_requests->token_id->CellCssStyle = ""; $password_reset_requests->token_id->CellCssClass = ""; // expires $password_reset_requests->expires->CellCssStyle = ""; $password_reset_requests->expires->CellCssClass = ""; if ($password_reset_requests->RowType == EW_ROWTYPE_VIEW) { // View row // id $password_reset_requests->id->ViewValue = $password_reset_requests->id->CurrentValue; $password_reset_requests->id->CssStyle = ""; $password_reset_requests->id->CssClass = ""; $password_reset_requests->id->ViewCustomAttributes = ""; // CustomerID $password_reset_requests->CustomerID->ViewValue = $password_reset_requests->CustomerID->CurrentValue; $password_reset_requests->CustomerID->CssStyle = ""; $password_reset_requests->CustomerID->CssClass = ""; $password_reset_requests->CustomerID->ViewCustomAttributes = ""; // token_id $password_reset_requests->token_id->ViewValue = $password_reset_requests->token_id->CurrentValue; $password_reset_requests->token_id->CssStyle = ""; $password_reset_requests->token_id->CssClass = ""; $password_reset_requests->token_id->ViewCustomAttributes = ""; // expires $password_reset_requests->expires->ViewValue = $password_reset_requests->expires->CurrentValue; $password_reset_requests->expires->ViewValue = ew_FormatDateTime($password_reset_requests->expires->ViewValue, 6); $password_reset_requests->expires->CssStyle = ""; $password_reset_requests->expires->CssClass = ""; $password_reset_requests->expires->ViewCustomAttributes = ""; // id $password_reset_requests->id->HrefValue = ""; // CustomerID $password_reset_requests->CustomerID->HrefValue = ""; // token_id $password_reset_requests->token_id->HrefValue = ""; // expires $password_reset_requests->expires->HrefValue = ""; } // Call Row Rendered event $password_reset_requests->Row_Rendered(); }
function RenderRow() { global $conn, $Security, $PromoCodes; // Call Row_Rendering event $PromoCodes->Row_Rendering(); // Common render codes for all row types // PromoCodeID $PromoCodes->PromoCodeID->CellCssStyle = ""; $PromoCodes->PromoCodeID->CellCssClass = ""; // PromoCodeName $PromoCodes->PromoCodeName->CellCssStyle = ""; $PromoCodes->PromoCodeName->CellCssClass = ""; // PromoCodeType $PromoCodes->PromoCodeType->CellCssStyle = ""; $PromoCodes->PromoCodeType->CellCssClass = ""; // Amount $PromoCodes->Amount->CellCssStyle = ""; $PromoCodes->Amount->CellCssClass = ""; // ValidFrom $PromoCodes->ValidFrom->CellCssStyle = ""; $PromoCodes->ValidFrom->CellCssClass = ""; // ValidTo $PromoCodes->ValidTo->CellCssStyle = ""; $PromoCodes->ValidTo->CellCssClass = ""; // Message $PromoCodes->Message->CellCssStyle = ""; $PromoCodes->Message->CellCssClass = ""; // One_Time_Only $PromoCodes->One_Time_Only->CellCssStyle = ""; $PromoCodes->One_Time_Only->CellCssClass = ""; // New_Customer_Only $PromoCodes->New_Customer_Only->CellCssStyle = ""; $PromoCodes->New_Customer_Only->CellCssClass = ""; if ($PromoCodes->RowType == EW_ROWTYPE_VIEW) { // View row // PromoCodeID $PromoCodes->PromoCodeID->ViewValue = $PromoCodes->PromoCodeID->CurrentValue; $PromoCodes->PromoCodeID->CssStyle = ""; $PromoCodes->PromoCodeID->CssClass = ""; $PromoCodes->PromoCodeID->ViewCustomAttributes = ""; // PromoCodeName $PromoCodes->PromoCodeName->ViewValue = $PromoCodes->PromoCodeName->CurrentValue; $PromoCodes->PromoCodeName->CssStyle = ""; $PromoCodes->PromoCodeName->CssClass = ""; $PromoCodes->PromoCodeName->ViewCustomAttributes = ""; // PromoCodeType if (strval($PromoCodes->PromoCodeType->CurrentValue) != "") { switch ($PromoCodes->PromoCodeType->CurrentValue) { case "Amount Discount": $PromoCodes->PromoCodeType->ViewValue = "Amount Discount"; break; case "Percent Discount": $PromoCodes->PromoCodeType->ViewValue = "Percent Discount"; break; default: $PromoCodes->PromoCodeType->ViewValue = $PromoCodes->PromoCodeType->CurrentValue; } } else { $PromoCodes->PromoCodeType->ViewValue = NULL; } $PromoCodes->PromoCodeType->CssStyle = ""; $PromoCodes->PromoCodeType->CssClass = ""; $PromoCodes->PromoCodeType->ViewCustomAttributes = ""; // Amount $PromoCodes->Amount->ViewValue = $PromoCodes->Amount->CurrentValue; $PromoCodes->Amount->CssStyle = ""; $PromoCodes->Amount->CssClass = ""; $PromoCodes->Amount->ViewCustomAttributes = ""; // ValidFrom $PromoCodes->ValidFrom->ViewValue = $PromoCodes->ValidFrom->CurrentValue; $PromoCodes->ValidFrom->ViewValue = ew_FormatDateTime($PromoCodes->ValidFrom->ViewValue, 6); $PromoCodes->ValidFrom->CssStyle = ""; $PromoCodes->ValidFrom->CssClass = ""; $PromoCodes->ValidFrom->ViewCustomAttributes = ""; // ValidTo $PromoCodes->ValidTo->ViewValue = $PromoCodes->ValidTo->CurrentValue; $PromoCodes->ValidTo->ViewValue = ew_FormatDateTime($PromoCodes->ValidTo->ViewValue, 6); $PromoCodes->ValidTo->CssStyle = ""; $PromoCodes->ValidTo->CssClass = ""; $PromoCodes->ValidTo->ViewCustomAttributes = ""; // Message $PromoCodes->Message->ViewValue = $PromoCodes->Message->CurrentValue; $PromoCodes->Message->CssStyle = ""; $PromoCodes->Message->CssClass = ""; $PromoCodes->Message->ViewCustomAttributes = ""; // One_Time_Only if (strval($PromoCodes->One_Time_Only->CurrentValue) != "") { switch ($PromoCodes->One_Time_Only->CurrentValue) { case "0": $PromoCodes->One_Time_Only->ViewValue = "No"; break; case "1": $PromoCodes->One_Time_Only->ViewValue = "Yes"; break; default: $PromoCodes->One_Time_Only->ViewValue = $PromoCodes->One_Time_Only->CurrentValue; } } else { $PromoCodes->One_Time_Only->ViewValue = NULL; } $PromoCodes->One_Time_Only->CssStyle = ""; $PromoCodes->One_Time_Only->CssClass = ""; $PromoCodes->One_Time_Only->ViewCustomAttributes = ""; // New_Customer_Only if (strval($PromoCodes->New_Customer_Only->CurrentValue) != "") { switch ($PromoCodes->New_Customer_Only->CurrentValue) { case "0": $PromoCodes->New_Customer_Only->ViewValue = "No"; break; case "1": $PromoCodes->New_Customer_Only->ViewValue = "Yes"; break; default: $PromoCodes->New_Customer_Only->ViewValue = $PromoCodes->New_Customer_Only->CurrentValue; } } else { $PromoCodes->New_Customer_Only->ViewValue = NULL; } $PromoCodes->New_Customer_Only->CssStyle = ""; $PromoCodes->New_Customer_Only->CssClass = ""; $PromoCodes->New_Customer_Only->ViewCustomAttributes = ""; // PromoCodeID $PromoCodes->PromoCodeID->HrefValue = ""; // PromoCodeName $PromoCodes->PromoCodeName->HrefValue = ""; // PromoCodeType $PromoCodes->PromoCodeType->HrefValue = ""; // Amount $PromoCodes->Amount->HrefValue = ""; // ValidFrom $PromoCodes->ValidFrom->HrefValue = ""; // ValidTo $PromoCodes->ValidTo->HrefValue = ""; // Message $PromoCodes->Message->HrefValue = ""; // One_Time_Only $PromoCodes->One_Time_Only->HrefValue = ""; // New_Customer_Only $PromoCodes->New_Customer_Only->HrefValue = ""; } // Call Row Rendered event $PromoCodes->Row_Rendered(); }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs $this->ViewUrl = $this->GetViewUrl(); $this->EditUrl = $this->GetEditUrl(); $this->InlineEditUrl = $this->GetInlineEditUrl(); $this->CopyUrl = $this->GetCopyUrl(); $this->InlineCopyUrl = $this->GetInlineCopyUrl(); $this->DeleteUrl = $this->GetDeleteUrl(); // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // news_id // news_title // news_date // news_description if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // news_id $this->news_id->ViewValue = $this->news_id->CurrentValue; $this->news_id->ViewCustomAttributes = ""; // news_title $this->news_title->ViewValue = $this->news_title->CurrentValue; $this->news_title->ViewCustomAttributes = ""; // news_date $this->news_date->ViewValue = $this->news_date->CurrentValue; $this->news_date->ViewValue = ew_FormatDateTime($this->news_date->ViewValue, 5); $this->news_date->ViewCustomAttributes = ""; // news_id $this->news_id->LinkCustomAttributes = ""; $this->news_id->HrefValue = ""; $this->news_id->TooltipValue = ""; // news_title $this->news_title->LinkCustomAttributes = ""; $this->news_title->HrefValue = ""; $this->news_title->TooltipValue = ""; // news_date $this->news_date->LinkCustomAttributes = ""; $this->news_date->HrefValue = ""; $this->news_date->TooltipValue = ""; } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function WriteAuditTrailOnEdit(&$rsold, &$rsnew) { if (!$this->AuditTrailOnEdit) { return; } $table = 'socios'; // Get key value $key = ""; if ($key != "") { $key .= $GLOBALS["EW_COMPOSITE_KEY_SEPARATOR"]; } $key .= $rsold['socio_nro']; // Write Audit Trail $dt = ew_StdCurrentDateTime(); $id = ew_ScriptName(); $usr = CurrentUserID(); foreach (array_keys($rsnew) as $fldname) { if ($this->fields[$fldname]->FldDataType != EW_DATATYPE_BLOB) { // Ignore BLOB fields if ($this->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 ($this->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 ($this->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); } } } }
function RenderListRow() { global $conn, $Security, $gsLanguage; // Call Row Rendering event $this->Row_Rendering(); // Common render codes // id_siswa // nis // nama // tempat_lahir // tanggal_lahir // alamat // agama // no_hp // email // id_siswa $this->id_siswa->ViewValue = $this->id_siswa->CurrentValue; $this->id_siswa->ViewCustomAttributes = ""; // nis $this->nis->ViewValue = $this->nis->CurrentValue; $this->nis->ViewCustomAttributes = ""; // nama $this->nama->ViewValue = $this->nama->CurrentValue; $this->nama->ViewCustomAttributes = ""; // tempat_lahir $this->tempat_lahir->ViewValue = $this->tempat_lahir->CurrentValue; $this->tempat_lahir->ViewCustomAttributes = ""; // tanggal_lahir $this->tanggal_lahir->ViewValue = $this->tanggal_lahir->CurrentValue; $this->tanggal_lahir->ViewValue = ew_FormatDateTime($this->tanggal_lahir->ViewValue, 5); $this->tanggal_lahir->ViewCustomAttributes = ""; // alamat $this->alamat->ViewValue = $this->alamat->CurrentValue; $this->alamat->ViewCustomAttributes = ""; // agama $this->agama->ViewValue = $this->agama->CurrentValue; $this->agama->ViewCustomAttributes = ""; // no_hp $this->no_hp->ViewValue = $this->no_hp->CurrentValue; $this->no_hp->ViewCustomAttributes = ""; // email $this->_email->ViewValue = $this->_email->CurrentValue; $this->_email->ViewCustomAttributes = ""; // id_siswa $this->id_siswa->LinkCustomAttributes = ""; $this->id_siswa->HrefValue = ""; $this->id_siswa->TooltipValue = ""; // nis $this->nis->LinkCustomAttributes = ""; $this->nis->HrefValue = ""; $this->nis->TooltipValue = ""; // nama $this->nama->LinkCustomAttributes = ""; $this->nama->HrefValue = ""; $this->nama->TooltipValue = ""; // tempat_lahir $this->tempat_lahir->LinkCustomAttributes = ""; $this->tempat_lahir->HrefValue = ""; $this->tempat_lahir->TooltipValue = ""; // tanggal_lahir $this->tanggal_lahir->LinkCustomAttributes = ""; $this->tanggal_lahir->HrefValue = ""; $this->tanggal_lahir->TooltipValue = ""; // alamat $this->alamat->LinkCustomAttributes = ""; $this->alamat->HrefValue = ""; $this->alamat->TooltipValue = ""; // agama $this->agama->LinkCustomAttributes = ""; $this->agama->HrefValue = ""; $this->agama->TooltipValue = ""; // no_hp $this->no_hp->LinkCustomAttributes = ""; $this->no_hp->HrefValue = ""; $this->no_hp->TooltipValue = ""; // email $this->_email->LinkCustomAttributes = ""; $this->_email->HrefValue = ""; $this->_email->TooltipValue = ""; // Call Row Rendered event $this->Row_Rendered(); }