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();
}
