function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // iddoctor_especialidad // iddoctor // idespecialidad if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // iddoctor_especialidad $this->iddoctor_especialidad->ViewValue = $this->iddoctor_especialidad->CurrentValue; $this->iddoctor_especialidad->ViewCustomAttributes = ""; // iddoctor if (strval($this->iddoctor->CurrentValue) != "") { $sFilterWrk = "`iddoctor`" . ew_SearchString("=", $this->iddoctor->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `iddoctor`, `nombre` AS `DispFld`, '' AS `Disp2Fld`, `apellido` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `doctor`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->iddoctor, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->iddoctor->ViewValue = $rswrk->fields('DispFld'); $this->iddoctor->ViewValue .= ew_ValueSeparator(2, $this->iddoctor) . $rswrk->fields('Disp3Fld'); $rswrk->Close(); } else { $this->iddoctor->ViewValue = $this->iddoctor->CurrentValue; } } else { $this->iddoctor->ViewValue = NULL; } $this->iddoctor->ViewCustomAttributes = ""; // idespecialidad if (strval($this->idespecialidad->CurrentValue) != "") { $sFilterWrk = "`idespecialidad`" . ew_SearchString("=", $this->idespecialidad->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idespecialidad`, `descripcion` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `especialidad`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idespecialidad, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idespecialidad->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idespecialidad->ViewValue = $this->idespecialidad->CurrentValue; } } else { $this->idespecialidad->ViewValue = NULL; } $this->idespecialidad->ViewCustomAttributes = ""; // iddoctor $this->iddoctor->LinkCustomAttributes = ""; $this->iddoctor->HrefValue = ""; $this->iddoctor->TooltipValue = ""; // idespecialidad $this->idespecialidad->LinkCustomAttributes = ""; $this->idespecialidad->HrefValue = ""; $this->idespecialidad->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_ADD) { // Add row // iddoctor $this->iddoctor->EditAttrs["class"] = "form-control"; $this->iddoctor->EditCustomAttributes = ""; if (trim(strval($this->iddoctor->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`iddoctor`" . ew_SearchString("=", $this->iddoctor->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `iddoctor`, `nombre` AS `DispFld`, '' AS `Disp2Fld`, `apellido` AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `doctor`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->iddoctor, $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->iddoctor->EditValue = $arwrk; // idespecialidad $this->idespecialidad->EditAttrs["class"] = "form-control"; $this->idespecialidad->EditCustomAttributes = ""; if ($this->idespecialidad->getSessionValue() != "") { $this->idespecialidad->CurrentValue = $this->idespecialidad->getSessionValue(); if (strval($this->idespecialidad->CurrentValue) != "") { $sFilterWrk = "`idespecialidad`" . ew_SearchString("=", $this->idespecialidad->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idespecialidad`, `descripcion` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `especialidad`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idespecialidad, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idespecialidad->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idespecialidad->ViewValue = $this->idespecialidad->CurrentValue; } } else { $this->idespecialidad->ViewValue = NULL; } $this->idespecialidad->ViewCustomAttributes = ""; } else { if (trim(strval($this->idespecialidad->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`idespecialidad`" . ew_SearchString("=", $this->idespecialidad->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `idespecialidad`, `descripcion` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `especialidad`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idespecialidad, $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->idespecialidad->EditValue = $arwrk; } // Edit refer script // iddoctor $this->iddoctor->HrefValue = ""; // idespecialidad $this->idespecialidad->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 // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // accountId // permissionId // granted // realmId if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // accountId if (strval($this->accountId->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->accountId->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `username` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `account`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->accountId->ViewValue = $rswrk->fields('DispFld'); $this->accountId->ViewValue .= ew_ValueSeparator(1, $this->accountId) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->accountId->ViewValue = $this->accountId->CurrentValue; } } else { $this->accountId->ViewValue = NULL; } $this->accountId->ViewCustomAttributes = ""; // permissionId if ($this->permissionId->VirtualValue != "") { $this->permissionId->ViewValue = $this->permissionId->VirtualValue; } else { if (strval($this->permissionId->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->permissionId->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `name` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `rbac_permissions`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->permissionId->ViewValue = $rswrk->fields('DispFld'); $this->permissionId->ViewValue .= ew_ValueSeparator(1, $this->permissionId) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->permissionId->ViewValue = $this->permissionId->CurrentValue; } } else { $this->permissionId->ViewValue = NULL; } } $this->permissionId->ViewCustomAttributes = ""; // granted if (strval($this->granted->CurrentValue) != "") { switch ($this->granted->CurrentValue) { case $this->granted->FldTagValue(1): $this->granted->ViewValue = $this->granted->FldTagCaption(1) != "" ? $this->granted->FldTagCaption(1) : $this->granted->CurrentValue; break; case $this->granted->FldTagValue(2): $this->granted->ViewValue = $this->granted->FldTagCaption(2) != "" ? $this->granted->FldTagCaption(2) : $this->granted->CurrentValue; break; default: $this->granted->ViewValue = $this->granted->CurrentValue; } } else { $this->granted->ViewValue = NULL; } $this->granted->ViewCustomAttributes = ""; // realmId if (strval($this->realmId->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->realmId->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `name` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `realmlist`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->realmId->ViewValue = $rswrk->fields('DispFld'); $this->realmId->ViewValue .= ew_ValueSeparator(1, $this->realmId) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->realmId->ViewValue = $this->realmId->CurrentValue; } } else { $this->realmId->ViewValue = NULL; } $this->realmId->ViewCustomAttributes = ""; // accountId $this->accountId->LinkCustomAttributes = ""; $this->accountId->HrefValue = ""; $this->accountId->TooltipValue = ""; // permissionId $this->permissionId->LinkCustomAttributes = ""; $this->permissionId->HrefValue = ""; $this->permissionId->TooltipValue = ""; // granted $this->granted->LinkCustomAttributes = ""; $this->granted->HrefValue = ""; $this->granted->TooltipValue = ""; // realmId $this->realmId->LinkCustomAttributes = ""; $this->realmId->HrefValue = ""; $this->realmId->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_EDIT) { // Edit row // accountId $this->accountId->EditCustomAttributes = ""; if (strval($this->accountId->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->accountId->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `username` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `account`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->accountId->EditValue = $rswrk->fields('DispFld'); $this->accountId->EditValue .= ew_ValueSeparator(1, $this->accountId) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->accountId->EditValue = $this->accountId->CurrentValue; } } else { $this->accountId->EditValue = NULL; } $this->accountId->ViewCustomAttributes = ""; // permissionId $this->permissionId->EditCustomAttributes = ""; if ($this->permissionId->VirtualValue != "") { $this->permissionId->ViewValue = $this->permissionId->VirtualValue; } else { if (strval($this->permissionId->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->permissionId->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `name` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `rbac_permissions`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->permissionId->EditValue = $rswrk->fields('DispFld'); $this->permissionId->EditValue .= ew_ValueSeparator(1, $this->permissionId) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->permissionId->EditValue = $this->permissionId->CurrentValue; } } else { $this->permissionId->EditValue = NULL; } } $this->permissionId->ViewCustomAttributes = ""; // granted $this->granted->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array($this->granted->FldTagValue(1), $this->granted->FldTagCaption(1) != "" ? $this->granted->FldTagCaption(1) : $this->granted->FldTagValue(1)); $arwrk[] = array($this->granted->FldTagValue(2), $this->granted->FldTagCaption(2) != "" ? $this->granted->FldTagCaption(2) : $this->granted->FldTagValue(2)); array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"))); $this->granted->EditValue = $arwrk; // realmId $this->realmId->EditCustomAttributes = ""; if (strval($this->realmId->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->realmId->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `name` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `realmlist`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->realmId->EditValue = $rswrk->fields('DispFld'); $this->realmId->EditValue .= ew_ValueSeparator(1, $this->realmId) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->realmId->EditValue = $this->realmId->CurrentValue; } } else { $this->realmId->EditValue = NULL; } $this->realmId->ViewCustomAttributes = ""; // Edit refer script // accountId $this->accountId->HrefValue = ""; // permissionId $this->permissionId->HrefValue = ""; // granted $this->granted->HrefValue = ""; // realmId $this->realmId->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(); } }
$selwrk = strval($receta->idempleado->CurrentValue) == strval($arwrk[$rowcntwrk][0]) ? " selected=\"selected\"" : ""; if ($selwrk != "") { $emptywrk = FALSE; } ?> <option value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]); ?> "<?php echo $selwrk; ?> > <?php echo $arwrk[$rowcntwrk][1]; if ($arwrk[$rowcntwrk][2] != "") { echo ew_ValueSeparator(1, $receta->idempleado); echo $arwrk[$rowcntwrk][2]; } ?> </option> <?php } } if (@$emptywrk) { $receta->idempleado->OldValue = ""; } ?> </select> <?php $sSqlWrk = "SELECT `idempleado`, `nombre` AS `DispFld`, `apellido` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `empleado`"; $sWhereWrk = "";
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(); // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // realmid // acctid // numchars if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // realmid if (strval($this->realmid->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->realmid->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `name` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `realmlist`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->realmid->ViewValue = $rswrk->fields('DispFld'); $this->realmid->ViewValue .= ew_ValueSeparator(1, $this->realmid) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->realmid->ViewValue = $this->realmid->CurrentValue; } } else { $this->realmid->ViewValue = NULL; } $this->realmid->ViewCustomAttributes = ""; // acctid if (strval($this->acctid->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->acctid->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `username` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `account`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->acctid->ViewValue = $rswrk->fields('DispFld'); $this->acctid->ViewValue .= ew_ValueSeparator(1, $this->acctid) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->acctid->ViewValue = $this->acctid->CurrentValue; } } else { $this->acctid->ViewValue = NULL; } $this->acctid->ViewCustomAttributes = ""; // numchars $this->numchars->ViewValue = $this->numchars->CurrentValue; $this->numchars->ViewCustomAttributes = ""; // realmid $this->realmid->LinkCustomAttributes = ""; $this->realmid->HrefValue = ""; $this->realmid->TooltipValue = ""; // acctid $this->acctid->LinkCustomAttributes = ""; $this->acctid->HrefValue = ""; $this->acctid->TooltipValue = ""; // numchars $this->numchars->LinkCustomAttributes = ""; $this->numchars->HrefValue = ""; $this->numchars->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 // codigo // Patente // cantidad_rueda // nombre // modelo // id_chofer // id_guarda // id_marca if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // codigo $this->codigo->ViewValue = $this->codigo->CurrentValue; $this->codigo->ViewCustomAttributes = ""; // Patente $this->Patente->ViewValue = $this->Patente->CurrentValue; $this->Patente->ViewCustomAttributes = ""; // cantidad_rueda $this->cantidad_rueda->ViewValue = $this->cantidad_rueda->CurrentValue; $this->cantidad_rueda->ViewCustomAttributes = ""; // nombre $this->nombre->ViewValue = $this->nombre->CurrentValue; $this->nombre->ViewCustomAttributes = ""; // modelo $this->modelo->ViewValue = $this->modelo->CurrentValue; $this->modelo->ViewCustomAttributes = ""; // id_chofer if ($this->id_chofer->VirtualValue != "") { $this->id_chofer->ViewValue = $this->id_chofer->VirtualValue; } else { if (strval($this->id_chofer->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_chofer->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `codigo` AS `DispFld`, `nombre` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `choferes`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_chofer, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `nombre` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_chofer->ViewValue = $rswrk->fields('DispFld'); $this->id_chofer->ViewValue .= ew_ValueSeparator(1, $this->id_chofer) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_chofer->ViewValue = $this->id_chofer->CurrentValue; } } else { $this->id_chofer->ViewValue = NULL; } } $this->id_chofer->ViewCustomAttributes = ""; // id_guarda if ($this->id_guarda->VirtualValue != "") { $this->id_guarda->ViewValue = $this->id_guarda->VirtualValue; } else { if (strval($this->id_guarda->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_guarda->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `codigo` AS `DispFld`, `nombre` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `choferes`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_guarda, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `nombre` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_guarda->ViewValue = $rswrk->fields('DispFld'); $this->id_guarda->ViewValue .= ew_ValueSeparator(1, $this->id_guarda) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_guarda->ViewValue = $this->id_guarda->CurrentValue; } } else { $this->id_guarda->ViewValue = NULL; } } $this->id_guarda->ViewCustomAttributes = ""; // id_marca if ($this->id_marca->VirtualValue != "") { $this->id_marca->ViewValue = $this->id_marca->VirtualValue; } else { if (strval($this->id_marca->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_marca->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `marca` AS `DispFld`, `modelo` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `marcas`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_marca, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `marca` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_marca->ViewValue = $rswrk->fields('DispFld'); $this->id_marca->ViewValue .= ew_ValueSeparator(1, $this->id_marca) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_marca->ViewValue = $this->id_marca->CurrentValue; } } else { $this->id_marca->ViewValue = NULL; } } $this->id_marca->ViewCustomAttributes = ""; // codigo $this->codigo->LinkCustomAttributes = ""; $this->codigo->HrefValue = ""; $this->codigo->TooltipValue = ""; // Patente $this->Patente->LinkCustomAttributes = ""; $this->Patente->HrefValue = ""; $this->Patente->TooltipValue = ""; // cantidad_rueda $this->cantidad_rueda->LinkCustomAttributes = ""; $this->cantidad_rueda->HrefValue = ""; $this->cantidad_rueda->TooltipValue = ""; // nombre $this->nombre->LinkCustomAttributes = ""; $this->nombre->HrefValue = ""; $this->nombre->TooltipValue = ""; // modelo $this->modelo->LinkCustomAttributes = ""; $this->modelo->HrefValue = ""; $this->modelo->TooltipValue = ""; // id_chofer $this->id_chofer->LinkCustomAttributes = ""; $this->id_chofer->HrefValue = ""; $this->id_chofer->TooltipValue = ""; // id_guarda $this->id_guarda->LinkCustomAttributes = ""; $this->id_guarda->HrefValue = ""; $this->id_guarda->TooltipValue = ""; // id_marca $this->id_marca->LinkCustomAttributes = ""; $this->id_marca->HrefValue = ""; $this->id_marca->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(); // 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 // id_deuda // fecha // monto // id_usuario if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // id $this->id->ViewValue = $this->id->CurrentValue; $this->id->ViewCustomAttributes = ""; // id_deuda if (strval($this->id_deuda->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->id_deuda->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `mes` AS `DispFld`, `anio` AS `Disp2Fld`, `monto` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `deudas`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_deuda, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_deuda->ViewValue = $rswrk->fields('DispFld'); $this->id_deuda->ViewValue .= ew_ValueSeparator(1, $this->id_deuda) . $rswrk->fields('Disp2Fld'); $this->id_deuda->ViewValue .= ew_ValueSeparator(2, $this->id_deuda) . $rswrk->fields('Disp3Fld'); $rswrk->Close(); } else { $this->id_deuda->ViewValue = $this->id_deuda->CurrentValue; } } else { $this->id_deuda->ViewValue = NULL; } $this->id_deuda->ViewCustomAttributes = ""; // fecha $this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7); $this->fecha->ViewCustomAttributes = ""; // monto $this->monto->ViewValue = $this->monto->CurrentValue; $this->monto->ViewCustomAttributes = ""; // id_usuario if (strval($this->id_usuario->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->id_usuario->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `usuario` AS `DispFld`, `nombre` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `usuario`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_usuario, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_usuario->ViewValue = $rswrk->fields('DispFld'); $this->id_usuario->ViewValue .= ew_ValueSeparator(1, $this->id_usuario) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_usuario->ViewValue = $this->id_usuario->CurrentValue; } } else { $this->id_usuario->ViewValue = NULL; } $this->id_usuario->ViewCustomAttributes = ""; // id $this->id->LinkCustomAttributes = ""; $this->id->HrefValue = ""; $this->id->TooltipValue = ""; // id_deuda $this->id_deuda->LinkCustomAttributes = ""; $this->id_deuda->HrefValue = ""; $this->id_deuda->TooltipValue = ""; // fecha $this->fecha->LinkCustomAttributes = ""; $this->fecha->HrefValue = ""; $this->fecha->TooltipValue = ""; // monto $this->monto->LinkCustomAttributes = ""; $this->monto->HrefValue = ""; $this->monto->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, $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, $Subscriptions2; // Call Row_Rendering event $Subscriptions2->Row_Rendering(); // Common render codes for all row types // OrderID $Subscriptions2->OrderID->CellCssStyle = ""; $Subscriptions2->OrderID->CellCssClass = ""; // DeliveryDate $Subscriptions2->DeliveryDate->CellCssStyle = ""; $Subscriptions2->DeliveryDate->CellCssClass = ""; // CustomerID $Subscriptions2->CustomerID->CellCssStyle = ""; $Subscriptions2->CustomerID->CellCssClass = ""; // WeeklyMeals $Subscriptions2->WeeklyMeals->CellCssStyle = ""; $Subscriptions2->WeeklyMeals->CellCssClass = ""; // WeeklyReg $Subscriptions2->WeeklyReg->CellCssStyle = ""; $Subscriptions2->WeeklyReg->CellCssClass = ""; // WeeklyVeg $Subscriptions2->WeeklyVeg->CellCssStyle = ""; $Subscriptions2->WeeklyVeg->CellCssClass = ""; // PromoCodeID $Subscriptions2->PromoCodeID->CellCssStyle = ""; $Subscriptions2->PromoCodeID->CellCssClass = ""; // TransactionNumber $Subscriptions2->TransactionNumber->CellCssStyle = ""; $Subscriptions2->TransactionNumber->CellCssClass = ""; // Want $Subscriptions2->Want->CellCssStyle = ""; $Subscriptions2->Want->CellCssClass = ""; // DontWant $Subscriptions2->DontWant->CellCssStyle = ""; $Subscriptions2->DontWant->CellCssClass = ""; // Comments $Subscriptions2->Comments->CellCssStyle = ""; $Subscriptions2->Comments->CellCssClass = ""; // SubscriptionID $Subscriptions2->SubscriptionID->CellCssStyle = ""; $Subscriptions2->SubscriptionID->CellCssClass = ""; if ($Subscriptions2->RowType == EW_ROWTYPE_VIEW) { // View row // OrderID $Subscriptions2->OrderID->ViewValue = $Subscriptions2->OrderID->CurrentValue; $Subscriptions2->OrderID->CssStyle = ""; $Subscriptions2->OrderID->CssClass = ""; $Subscriptions2->OrderID->ViewCustomAttributes = ""; // DeliveryDate $Subscriptions2->DeliveryDate->ViewValue = $Subscriptions2->DeliveryDate->CurrentValue; $Subscriptions2->DeliveryDate->ViewValue = ew_FormatDateTime($Subscriptions2->DeliveryDate->ViewValue, 6); $Subscriptions2->DeliveryDate->CssStyle = ""; $Subscriptions2->DeliveryDate->CssClass = ""; $Subscriptions2->DeliveryDate->ViewCustomAttributes = ""; // CustomerID if (strval($Subscriptions2->CustomerID->CurrentValue) != "") { $sSqlWrk = "SELECT `LastName`, `FirstName` FROM `Customers` WHERE `CustomerID` = " . ew_AdjustSql($Subscriptions2->CustomerID->CurrentValue) . ""; $sSqlWrk .= " ORDER BY `LastName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $Subscriptions2->CustomerID->ViewValue = $rswrk->fields('LastName'); $Subscriptions2->CustomerID->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $Subscriptions2->CustomerID->ViewValue = $Subscriptions2->CustomerID->CurrentValue; } } else { $Subscriptions2->CustomerID->ViewValue = NULL; } $Subscriptions2->CustomerID->CssStyle = ""; $Subscriptions2->CustomerID->CssClass = ""; $Subscriptions2->CustomerID->ViewCustomAttributes = ""; // WeeklyMeals $Subscriptions2->WeeklyMeals->ViewValue = $Subscriptions2->WeeklyMeals->CurrentValue; $Subscriptions2->WeeklyMeals->CssStyle = ""; $Subscriptions2->WeeklyMeals->CssClass = ""; $Subscriptions2->WeeklyMeals->ViewCustomAttributes = ""; // WeeklyReg $Subscriptions2->WeeklyReg->ViewValue = $Subscriptions2->WeeklyReg->CurrentValue; $Subscriptions2->WeeklyReg->CssStyle = ""; $Subscriptions2->WeeklyReg->CssClass = ""; $Subscriptions2->WeeklyReg->ViewCustomAttributes = ""; // WeeklyVeg $Subscriptions2->WeeklyVeg->ViewValue = $Subscriptions2->WeeklyVeg->CurrentValue; $Subscriptions2->WeeklyVeg->CssStyle = ""; $Subscriptions2->WeeklyVeg->CssClass = ""; $Subscriptions2->WeeklyVeg->ViewCustomAttributes = ""; // PromoCodeID if (strval($Subscriptions2->PromoCodeID->CurrentValue) != "") { $sSqlWrk = "SELECT `PromoCodeName` FROM `PromoCodes` WHERE `PromoCodeID` = " . ew_AdjustSql($Subscriptions2->PromoCodeID->CurrentValue) . ""; $sSqlWrk .= " ORDER BY `PromoCodeName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $Subscriptions2->PromoCodeID->ViewValue = $rswrk->fields('PromoCodeName'); $rswrk->Close(); } else { $Subscriptions2->PromoCodeID->ViewValue = $Subscriptions2->PromoCodeID->CurrentValue; } } else { $Subscriptions2->PromoCodeID->ViewValue = NULL; } $Subscriptions2->PromoCodeID->CssStyle = ""; $Subscriptions2->PromoCodeID->CssClass = ""; $Subscriptions2->PromoCodeID->ViewCustomAttributes = ""; // TransactionNumber $Subscriptions2->TransactionNumber->ViewValue = $Subscriptions2->TransactionNumber->CurrentValue; $Subscriptions2->TransactionNumber->CssStyle = ""; $Subscriptions2->TransactionNumber->CssClass = ""; $Subscriptions2->TransactionNumber->ViewCustomAttributes = ""; // Want if (strval($Subscriptions2->Want->CurrentValue) != "") { $arwrk = explode(",", $Subscriptions2->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 $Subscriptions2->Want->ViewValue = ""; $ari = 0; while (!$rswrk->EOF) { $Subscriptions2->Want->ViewValue .= $rswrk->fields('ItemName'); $rswrk->MoveNext(); if (!$rswrk->EOF) { $Subscriptions2->Want->ViewValue .= ew_ViewOptionSeparator($ari); } // Separate Options $ari++; } $rswrk->Close(); } else { $Subscriptions2->Want->ViewValue = $Subscriptions2->Want->CurrentValue; } } else { $Subscriptions2->Want->ViewValue = NULL; } $Subscriptions2->Want->CssStyle = ""; $Subscriptions2->Want->CssClass = ""; $Subscriptions2->Want->ViewCustomAttributes = ""; // DontWant if (strval($Subscriptions2->DontWant->CurrentValue) != "") { $arwrk = explode(",", $Subscriptions2->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 $Subscriptions2->DontWant->ViewValue = ""; $ari = 0; while (!$rswrk->EOF) { $Subscriptions2->DontWant->ViewValue .= $rswrk->fields('ItemName'); $rswrk->MoveNext(); if (!$rswrk->EOF) { $Subscriptions2->DontWant->ViewValue .= ew_ViewOptionSeparator($ari); } // Separate Options $ari++; } $rswrk->Close(); } else { $Subscriptions2->DontWant->ViewValue = $Subscriptions2->DontWant->CurrentValue; } } else { $Subscriptions2->DontWant->ViewValue = NULL; } $Subscriptions2->DontWant->CssStyle = ""; $Subscriptions2->DontWant->CssClass = ""; $Subscriptions2->DontWant->ViewCustomAttributes = ""; // Comments $Subscriptions2->Comments->ViewValue = $Subscriptions2->Comments->CurrentValue; $Subscriptions2->Comments->CssStyle = ""; $Subscriptions2->Comments->CssClass = ""; $Subscriptions2->Comments->ViewCustomAttributes = ""; // SubscriptionID $Subscriptions2->SubscriptionID->ViewValue = $Subscriptions2->SubscriptionID->CurrentValue; $Subscriptions2->SubscriptionID->CssStyle = ""; $Subscriptions2->SubscriptionID->CssClass = ""; $Subscriptions2->SubscriptionID->ViewCustomAttributes = ""; // OrderID $Subscriptions2->OrderID->HrefValue = ""; // DeliveryDate $Subscriptions2->DeliveryDate->HrefValue = ""; // CustomerID $Subscriptions2->CustomerID->HrefValue = ""; // WeeklyMeals $Subscriptions2->WeeklyMeals->HrefValue = ""; // WeeklyReg $Subscriptions2->WeeklyReg->HrefValue = ""; // WeeklyVeg $Subscriptions2->WeeklyVeg->HrefValue = ""; // PromoCodeID $Subscriptions2->PromoCodeID->HrefValue = ""; // TransactionNumber $Subscriptions2->TransactionNumber->HrefValue = ""; // Want $Subscriptions2->Want->HrefValue = ""; // DontWant $Subscriptions2->DontWant->HrefValue = ""; // Comments $Subscriptions2->Comments->HrefValue = ""; // SubscriptionID $Subscriptions2->SubscriptionID->HrefValue = ""; } elseif ($Subscriptions2->RowType == EW_ROWTYPE_EDIT) { // Edit row // OrderID $Subscriptions2->OrderID->EditCustomAttributes = ""; $Subscriptions2->OrderID->EditValue = $Subscriptions2->OrderID->CurrentValue; $Subscriptions2->OrderID->CssStyle = ""; $Subscriptions2->OrderID->CssClass = ""; $Subscriptions2->OrderID->ViewCustomAttributes = ""; // DeliveryDate $Subscriptions2->DeliveryDate->EditCustomAttributes = ""; $Subscriptions2->DeliveryDate->EditValue = $Subscriptions2->DeliveryDate->CurrentValue; $Subscriptions2->DeliveryDate->EditValue = ew_FormatDateTime($Subscriptions2->DeliveryDate->EditValue, 6); $Subscriptions2->DeliveryDate->CssStyle = ""; $Subscriptions2->DeliveryDate->CssClass = ""; $Subscriptions2->DeliveryDate->ViewCustomAttributes = ""; // CustomerID $Subscriptions2->CustomerID->EditCustomAttributes = ""; if (strval($Subscriptions2->CustomerID->CurrentValue) != "") { $sSqlWrk = "SELECT `LastName`, `FirstName` FROM `Customers` WHERE `CustomerID` = " . ew_AdjustSql($Subscriptions2->CustomerID->CurrentValue) . ""; $sSqlWrk .= " ORDER BY `LastName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $Subscriptions2->CustomerID->EditValue = $rswrk->fields('LastName'); $Subscriptions2->CustomerID->EditValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $Subscriptions2->CustomerID->EditValue = $Subscriptions2->CustomerID->CurrentValue; } } else { $Subscriptions2->CustomerID->EditValue = NULL; } $Subscriptions2->CustomerID->CssStyle = ""; $Subscriptions2->CustomerID->CssClass = ""; $Subscriptions2->CustomerID->ViewCustomAttributes = ""; // WeeklyMeals $Subscriptions2->WeeklyMeals->EditCustomAttributes = ""; $Subscriptions2->WeeklyMeals->EditValue = ew_HtmlEncode($Subscriptions2->WeeklyMeals->CurrentValue); // WeeklyReg $Subscriptions2->WeeklyReg->EditCustomAttributes = ""; $Subscriptions2->WeeklyReg->EditValue = ew_HtmlEncode($Subscriptions2->WeeklyReg->CurrentValue); // WeeklyVeg $Subscriptions2->WeeklyVeg->EditCustomAttributes = ""; $Subscriptions2->WeeklyVeg->EditValue = ew_HtmlEncode($Subscriptions2->WeeklyVeg->CurrentValue); // PromoCodeID $Subscriptions2->PromoCodeID->EditCustomAttributes = ""; $sSqlWrk = "SELECT `PromoCodeID`, `PromoCodeName`, '' AS Disp2Fld, '' AS SelectFilterFld FROM `PromoCodes`"; $sWhereWrk = ""; if ($sWhereWrk != "") { $sSqlWrk .= " WHERE {$sWhereWrk}"; } $sSqlWrk .= " ORDER BY `PromoCodeName` Asc"; $rswrk = $conn->Execute($sSqlWrk); $arwrk = $rswrk ? $rswrk->GetRows() : array(); if ($rswrk) { $rswrk->Close(); } array_unshift($arwrk, array("", "Please Select")); $Subscriptions2->PromoCodeID->EditValue = $arwrk; // TransactionNumber $Subscriptions2->TransactionNumber->EditCustomAttributes = ""; $Subscriptions2->TransactionNumber->EditValue = ew_HtmlEncode($Subscriptions2->TransactionNumber->CurrentValue); // Want $Subscriptions2->Want->EditCustomAttributes = ""; if (strval($Subscriptions2->Want->CurrentValue) != "") { $arwrk = explode(",", $Subscriptions2->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 $Subscriptions2->Want->EditValue = ""; $ari = 0; while (!$rswrk->EOF) { $Subscriptions2->Want->EditValue .= $rswrk->fields('ItemName'); $rswrk->MoveNext(); if (!$rswrk->EOF) { $Subscriptions2->Want->EditValue .= ew_ViewOptionSeparator($ari); } // Separate Options $ari++; } $rswrk->Close(); } else { $Subscriptions2->Want->EditValue = $Subscriptions2->Want->CurrentValue; } } else { $Subscriptions2->Want->EditValue = NULL; } $Subscriptions2->Want->CssStyle = ""; $Subscriptions2->Want->CssClass = ""; $Subscriptions2->Want->ViewCustomAttributes = ""; // DontWant $Subscriptions2->DontWant->EditCustomAttributes = ""; if (strval($Subscriptions2->DontWant->CurrentValue) != "") { $arwrk = explode(",", $Subscriptions2->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 $Subscriptions2->DontWant->EditValue = ""; $ari = 0; while (!$rswrk->EOF) { $Subscriptions2->DontWant->EditValue .= $rswrk->fields('ItemName'); $rswrk->MoveNext(); if (!$rswrk->EOF) { $Subscriptions2->DontWant->EditValue .= ew_ViewOptionSeparator($ari); } // Separate Options $ari++; } $rswrk->Close(); } else { $Subscriptions2->DontWant->EditValue = $Subscriptions2->DontWant->CurrentValue; } } else { $Subscriptions2->DontWant->EditValue = NULL; } $Subscriptions2->DontWant->CssStyle = ""; $Subscriptions2->DontWant->CssClass = ""; $Subscriptions2->DontWant->ViewCustomAttributes = ""; // Comments $Subscriptions2->Comments->EditCustomAttributes = ""; $Subscriptions2->Comments->EditValue = $Subscriptions2->Comments->CurrentValue; $Subscriptions2->Comments->CssStyle = ""; $Subscriptions2->Comments->CssClass = ""; $Subscriptions2->Comments->ViewCustomAttributes = ""; // SubscriptionID $Subscriptions2->SubscriptionID->EditCustomAttributes = ""; $Subscriptions2->SubscriptionID->EditValue = $Subscriptions2->SubscriptionID->CurrentValue; $Subscriptions2->SubscriptionID->CssStyle = ""; $Subscriptions2->SubscriptionID->CssClass = ""; $Subscriptions2->SubscriptionID->ViewCustomAttributes = ""; // Edit refer script // OrderID $Subscriptions2->OrderID->HrefValue = ""; // DeliveryDate $Subscriptions2->DeliveryDate->HrefValue = ""; // CustomerID $Subscriptions2->CustomerID->HrefValue = ""; // WeeklyMeals $Subscriptions2->WeeklyMeals->HrefValue = ""; // WeeklyReg $Subscriptions2->WeeklyReg->HrefValue = ""; // WeeklyVeg $Subscriptions2->WeeklyVeg->HrefValue = ""; // PromoCodeID $Subscriptions2->PromoCodeID->HrefValue = ""; // TransactionNumber $Subscriptions2->TransactionNumber->HrefValue = ""; // Want $Subscriptions2->Want->HrefValue = ""; // DontWant $Subscriptions2->DontWant->HrefValue = ""; // Comments $Subscriptions2->Comments->HrefValue = ""; // SubscriptionID $Subscriptions2->SubscriptionID->HrefValue = ""; } // Call Row Rendered event $Subscriptions2->Row_Rendered(); }
<input type="hidden" data-field="x_id_hoja_ruta" name="x<?php echo $gastos_grid->RowIndex; ?> _id_hoja_ruta" id="x<?php echo $gastos_grid->RowIndex; ?> _id_hoja_ruta" value="<?php echo ew_HtmlEncode($gastos->id_hoja_ruta->CurrentValue); ?> "<?php echo $wrkonchange; ?> > <?php $sSqlWrk = "SELECT `codigo`, `codigo` AS `DispFld`, `fecha_ini` AS `Disp2Fld`, `Origen` AS `Disp3Fld` FROM `hoja_rutas`"; $sWhereWrk = "`codigo` LIKE '{query_value}%' OR CONCAT(`codigo`,'" . ew_ValueSeparator(1, $Page->id_hoja_ruta) . "',DATE_FORMAT(`fecha_ini`, '%d/%m/%Y'),'" . ew_ValueSeparator(2, $Page->id_hoja_ruta) . "',`Origen`) LIKE '{query_value}%'"; if (!$GLOBALS["gastos"]->UserIDAllow("grid")) { $sWhereWrk = $GLOBALS["hoja_rutas"]->AddUserIDFilter($sWhereWrk); } // Call Lookup selecting $gastos->Lookup_Selecting($gastos->id_hoja_ruta, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `codigo` ASC"; $sSqlWrk .= " LIMIT " . EW_AUTO_SUGGEST_MAX_ENTRIES; ?> <input type="hidden" name="q_x<?php echo $gastos_grid->RowIndex; ?> _id_hoja_ruta" id="q_x<?php
function RenderListRow() { global $conn, $Security, $gsLanguage, $Language; // Call Row Rendering event $this->Row_Rendering(); // Common render codes // iddoctor_servicio_medico_prestado // iddoctor // idservicio_medico_prestado // iddoctor_servicio_medico_prestado $this->iddoctor_servicio_medico_prestado->ViewValue = $this->iddoctor_servicio_medico_prestado->CurrentValue; $this->iddoctor_servicio_medico_prestado->ViewCustomAttributes = ""; // iddoctor if (strval($this->iddoctor->CurrentValue) != "") { $sFilterWrk = "`iddoctor`" . ew_SearchString("=", $this->iddoctor->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `iddoctor`, `nombre` AS `DispFld`, '' AS `Disp2Fld`, `apellido` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `doctor`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->iddoctor, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->iddoctor->ViewValue = $rswrk->fields('DispFld'); $this->iddoctor->ViewValue .= ew_ValueSeparator(2, $this->iddoctor) . $rswrk->fields('Disp3Fld'); $rswrk->Close(); } else { $this->iddoctor->ViewValue = $this->iddoctor->CurrentValue; } } else { $this->iddoctor->ViewValue = NULL; } $this->iddoctor->ViewCustomAttributes = ""; // idservicio_medico_prestado $this->idservicio_medico_prestado->ViewValue = $this->idservicio_medico_prestado->CurrentValue; if (strval($this->idservicio_medico_prestado->CurrentValue) != "") { $sFilterWrk = "`idservicio_medico_prestado`" . ew_SearchString("=", $this->idservicio_medico_prestado->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idservicio_medico_prestado`, `idservicio_medico_prestado` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `servicio_medico_prestado`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idservicio_medico_prestado, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idservicio_medico_prestado->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idservicio_medico_prestado->ViewValue = $this->idservicio_medico_prestado->CurrentValue; } } else { $this->idservicio_medico_prestado->ViewValue = NULL; } $this->idservicio_medico_prestado->ViewCustomAttributes = ""; // iddoctor_servicio_medico_prestado $this->iddoctor_servicio_medico_prestado->LinkCustomAttributes = ""; $this->iddoctor_servicio_medico_prestado->HrefValue = ""; $this->iddoctor_servicio_medico_prestado->TooltipValue = ""; // iddoctor $this->iddoctor->LinkCustomAttributes = ""; $this->iddoctor->HrefValue = ""; $this->iddoctor->TooltipValue = ""; // idservicio_medico_prestado $this->idservicio_medico_prestado->LinkCustomAttributes = ""; $this->idservicio_medico_prestado->HrefValue = ""; $this->idservicio_medico_prestado->TooltipValue = ""; // Call Row Rendered event $this->Row_Rendered(); }
function RenderListRow() { global $conn, $Security; // Call Row Rendering event $this->Row_Rendering(); // Common render codes // socio_nro // id_actividad $this->id_actividad->CellCssStyle = "white-space: nowrap;"; // id_usuario // propietario // comercio // direccion_comercio // activo // mail // tel // cel // cuit_cuil // socio_nro $this->socio_nro->ViewValue = $this->socio_nro->CurrentValue; $this->socio_nro->ViewCustomAttributes = ""; // id_actividad if (strval($this->id_actividad->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->id_actividad->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `actividad` AS `DispFld`, `descripcion` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `actividad`"; $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_actividad, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_actividad->ViewValue = $rswrk->fields('DispFld'); $this->id_actividad->ViewValue .= ew_ValueSeparator(1, $this->id_actividad) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_actividad->ViewValue = $this->id_actividad->CurrentValue; } } else { $this->id_actividad->ViewValue = NULL; } $this->id_actividad->ViewCustomAttributes = ""; // id_usuario $this->id_usuario->ViewValue = $this->id_usuario->CurrentValue; $this->id_usuario->ViewCustomAttributes = ""; // propietario $this->propietario->ViewValue = $this->propietario->CurrentValue; $this->propietario->ViewCustomAttributes = ""; // comercio $this->comercio->ViewValue = $this->comercio->CurrentValue; $this->comercio->ViewCustomAttributes = ""; // direccion_comercio $this->direccion_comercio->ViewValue = $this->direccion_comercio->CurrentValue; $this->direccion_comercio->ViewCustomAttributes = ""; // activo if (strval($this->activo->CurrentValue) != "") { switch ($this->activo->CurrentValue) { case $this->activo->FldTagValue(1): $this->activo->ViewValue = $this->activo->FldTagCaption(1) != "" ? $this->activo->FldTagCaption(1) : $this->activo->CurrentValue; break; case $this->activo->FldTagValue(2): $this->activo->ViewValue = $this->activo->FldTagCaption(2) != "" ? $this->activo->FldTagCaption(2) : $this->activo->CurrentValue; break; default: $this->activo->ViewValue = $this->activo->CurrentValue; } } else { $this->activo->ViewValue = NULL; } $this->activo->ViewCustomAttributes = ""; // mail $this->mail->ViewValue = $this->mail->CurrentValue; $this->mail->ViewValue = strtolower($this->mail->ViewValue); $this->mail->ViewCustomAttributes = ""; // tel $this->tel->ViewValue = $this->tel->CurrentValue; $this->tel->ViewValue = trim($this->tel->ViewValue); $this->tel->ViewCustomAttributes = ""; // cel $this->cel->ViewValue = $this->cel->CurrentValue; $this->cel->ViewValue = trim($this->cel->ViewValue); $this->cel->ViewCustomAttributes = ""; // cuit_cuil $this->cuit_cuil->ViewValue = $this->cuit_cuil->CurrentValue; $this->cuit_cuil->ViewValue = ew_FormatNumber($this->cuit_cuil->ViewValue, 0, -2, -2, -2); $this->cuit_cuil->ViewCustomAttributes = ""; // socio_nro $this->socio_nro->LinkCustomAttributes = ""; $this->socio_nro->HrefValue = ""; $this->socio_nro->TooltipValue = ""; // id_actividad $this->id_actividad->LinkCustomAttributes = ""; $this->id_actividad->HrefValue = ""; $this->id_actividad->TooltipValue = ""; // id_usuario $this->id_usuario->LinkCustomAttributes = ""; $this->id_usuario->HrefValue = ""; $this->id_usuario->TooltipValue = ""; // propietario $this->propietario->LinkCustomAttributes = ""; $this->propietario->HrefValue = ""; $this->propietario->TooltipValue = ""; // comercio $this->comercio->LinkCustomAttributes = ""; $this->comercio->HrefValue = ""; $this->comercio->TooltipValue = ""; // direccion_comercio $this->direccion_comercio->LinkCustomAttributes = ""; $this->direccion_comercio->HrefValue = ""; $this->direccion_comercio->TooltipValue = ""; // activo $this->activo->LinkCustomAttributes = ""; $this->activo->HrefValue = ""; $this->activo->TooltipValue = ""; // mail $this->mail->LinkCustomAttributes = ""; $this->mail->HrefValue = ""; $this->mail->TooltipValue = ""; // tel $this->tel->LinkCustomAttributes = ""; $this->tel->HrefValue = ""; $this->tel->TooltipValue = ""; // cel $this->cel->LinkCustomAttributes = ""; $this->cel->HrefValue = ""; $this->cel->TooltipValue = ""; // cuit_cuil $this->cuit_cuil->LinkCustomAttributes = ""; $this->cuit_cuil->HrefValue = ""; $this->cuit_cuil->TooltipValue = ""; // 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->adelanto->FormValue == $this->adelanto->CurrentValue && is_numeric(ew_StrToFloat($this->adelanto->CurrentValue))) { $this->adelanto->CurrentValue = ew_StrToFloat($this->adelanto->CurrentValue); } // Convert decimal values if posted back if ($this->tarifa->FormValue == $this->tarifa->CurrentValue && is_numeric(ew_StrToFloat($this->tarifa->CurrentValue))) { $this->tarifa->CurrentValue = ew_StrToFloat($this->tarifa->CurrentValue); } // Convert decimal values if posted back if ($this->porcentaje->FormValue == $this->porcentaje->CurrentValue && is_numeric(ew_StrToFloat($this->porcentaje->CurrentValue))) { $this->porcentaje->CurrentValue = ew_StrToFloat($this->porcentaje->CurrentValue); } // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // codigo // fecha_ini // id_cliente // id_localidad_origen // Origen // id_localidad_destino // Destino // Km_ini // estado // id_vehiculo // id_tipo_carga // km_fin // fecha_fin // adelanto // kg_carga // tarifa // porcentaje // id_usuario if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // fecha_ini $this->fecha_ini->ViewValue = $this->fecha_ini->CurrentValue; $this->fecha_ini->ViewValue = ew_FormatDateTime($this->fecha_ini->ViewValue, 7); $this->fecha_ini->ViewCustomAttributes = ""; // id_cliente if (strval($this->id_cliente->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_cliente->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `cuit_cuil` AS `DispFld`, `razon_social` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `clientes`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_cliente, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `razon_social` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_cliente->ViewValue = $rswrk->fields('DispFld'); $this->id_cliente->ViewValue .= ew_ValueSeparator(1, $this->id_cliente) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_cliente->ViewValue = $this->id_cliente->CurrentValue; } } else { $this->id_cliente->ViewValue = NULL; } $this->id_cliente->ViewCustomAttributes = ""; // id_localidad_origen if ($this->id_localidad_origen->VirtualValue != "") { $this->id_localidad_origen->ViewValue = $this->id_localidad_origen->VirtualValue; } else { if (strval($this->id_localidad_origen->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_localidad_origen->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `cp` AS `DispFld`, `localidad` AS `Disp2Fld`, `provincia` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `v_localidad_provincia`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_localidad_origen, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `localidad` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_localidad_origen->ViewValue = $rswrk->fields('DispFld'); $this->id_localidad_origen->ViewValue .= ew_ValueSeparator(1, $this->id_localidad_origen) . $rswrk->fields('Disp2Fld'); $this->id_localidad_origen->ViewValue .= ew_ValueSeparator(2, $this->id_localidad_origen) . $rswrk->fields('Disp3Fld'); $rswrk->Close(); } else { $this->id_localidad_origen->ViewValue = $this->id_localidad_origen->CurrentValue; } } else { $this->id_localidad_origen->ViewValue = NULL; } } $this->id_localidad_origen->ViewCustomAttributes = ""; // Origen $this->Origen->ViewValue = $this->Origen->CurrentValue; $this->Origen->ViewCustomAttributes = ""; // id_localidad_destino if ($this->id_localidad_destino->VirtualValue != "") { $this->id_localidad_destino->ViewValue = $this->id_localidad_destino->VirtualValue; } else { if (strval($this->id_localidad_destino->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_localidad_destino->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `cp` AS `DispFld`, `localidad` AS `Disp2Fld`, `provincia` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `v_localidad_provincia`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_localidad_destino, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `localidad` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_localidad_destino->ViewValue = $rswrk->fields('DispFld'); $this->id_localidad_destino->ViewValue .= ew_ValueSeparator(1, $this->id_localidad_destino) . $rswrk->fields('Disp2Fld'); $this->id_localidad_destino->ViewValue .= ew_ValueSeparator(2, $this->id_localidad_destino) . $rswrk->fields('Disp3Fld'); $rswrk->Close(); } else { $this->id_localidad_destino->ViewValue = $this->id_localidad_destino->CurrentValue; } } else { $this->id_localidad_destino->ViewValue = NULL; } } $this->id_localidad_destino->ViewCustomAttributes = ""; // Destino $this->Destino->ViewValue = $this->Destino->CurrentValue; $this->Destino->ViewCustomAttributes = ""; // Km_ini $this->Km_ini->ViewValue = $this->Km_ini->CurrentValue; $this->Km_ini->ViewValue = ew_FormatNumber($this->Km_ini->ViewValue, 0, -2, -2, -2); $this->Km_ini->ViewCustomAttributes = ""; // estado $this->estado->ViewValue = $this->estado->CurrentValue; $this->estado->ViewCustomAttributes = ""; // id_vehiculo if ($this->id_vehiculo->VirtualValue != "") { $this->id_vehiculo->ViewValue = $this->id_vehiculo->VirtualValue; } else { if (strval($this->id_vehiculo->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_vehiculo->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `Patente` AS `DispFld`, `nombre` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `vehiculos`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_vehiculo, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `nombre` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_vehiculo->ViewValue = $rswrk->fields('DispFld'); $this->id_vehiculo->ViewValue .= ew_ValueSeparator(1, $this->id_vehiculo) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_vehiculo->ViewValue = $this->id_vehiculo->CurrentValue; } } else { $this->id_vehiculo->ViewValue = NULL; } } $this->id_vehiculo->ViewCustomAttributes = ""; // id_tipo_carga if ($this->id_tipo_carga->VirtualValue != "") { $this->id_tipo_carga->ViewValue = $this->id_tipo_carga->VirtualValue; } else { if (strval($this->id_tipo_carga->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_tipo_carga->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `Tipo_carga` AS `DispFld`, `precio_base` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tipo_cargas`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_tipo_carga, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `Tipo_carga` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_tipo_carga->ViewValue = $rswrk->fields('DispFld'); $this->id_tipo_carga->ViewValue .= ew_ValueSeparator(1, $this->id_tipo_carga) . ew_FormatCurrency($rswrk->fields('Disp2Fld'), 2, 0, 0, -1); $rswrk->Close(); } else { $this->id_tipo_carga->ViewValue = $this->id_tipo_carga->CurrentValue; } } else { $this->id_tipo_carga->ViewValue = NULL; } } $this->id_tipo_carga->ViewCustomAttributes = ""; // km_fin $this->km_fin->ViewValue = $this->km_fin->CurrentValue; $this->km_fin->ViewValue = ew_FormatNumber($this->km_fin->ViewValue, 0, -2, -2, -2); $this->km_fin->ViewCustomAttributes = ""; // fecha_fin $this->fecha_fin->ViewValue = $this->fecha_fin->CurrentValue; $this->fecha_fin->ViewValue = ew_FormatDateTime($this->fecha_fin->ViewValue, 7); $this->fecha_fin->ViewCustomAttributes = ""; // adelanto $this->adelanto->ViewValue = $this->adelanto->CurrentValue; $this->adelanto->ViewValue = ew_FormatCurrency($this->adelanto->ViewValue, 2, -2, -2, -2); $this->adelanto->ViewCustomAttributes = ""; // kg_carga $this->kg_carga->ViewValue = $this->kg_carga->CurrentValue; $this->kg_carga->ViewValue = ew_FormatNumber($this->kg_carga->ViewValue, 0, -2, -2, -2); $this->kg_carga->ViewCustomAttributes = ""; // tarifa $this->tarifa->ViewValue = $this->tarifa->CurrentValue; $this->tarifa->ViewValue = ew_FormatCurrency($this->tarifa->ViewValue, 2, -2, -2, -2); $this->tarifa->ViewCustomAttributes = ""; // porcentaje $this->porcentaje->ViewValue = $this->porcentaje->CurrentValue; $this->porcentaje->ViewCustomAttributes = ""; // fecha_ini $this->fecha_ini->LinkCustomAttributes = ""; $this->fecha_ini->HrefValue = ""; $this->fecha_ini->TooltipValue = ""; // id_cliente $this->id_cliente->LinkCustomAttributes = ""; $this->id_cliente->HrefValue = ""; $this->id_cliente->TooltipValue = ""; // id_localidad_origen $this->id_localidad_origen->LinkCustomAttributes = ""; $this->id_localidad_origen->HrefValue = ""; $this->id_localidad_origen->TooltipValue = ""; // Origen $this->Origen->LinkCustomAttributes = ""; $this->Origen->HrefValue = ""; $this->Origen->TooltipValue = ""; // id_localidad_destino $this->id_localidad_destino->LinkCustomAttributes = ""; $this->id_localidad_destino->HrefValue = ""; $this->id_localidad_destino->TooltipValue = ""; // Destino $this->Destino->LinkCustomAttributes = ""; $this->Destino->HrefValue = ""; $this->Destino->TooltipValue = ""; // Km_ini $this->Km_ini->LinkCustomAttributes = ""; $this->Km_ini->HrefValue = ""; $this->Km_ini->TooltipValue = ""; // estado $this->estado->LinkCustomAttributes = ""; $this->estado->HrefValue = ""; $this->estado->TooltipValue = ""; // id_vehiculo $this->id_vehiculo->LinkCustomAttributes = ""; $this->id_vehiculo->HrefValue = ""; $this->id_vehiculo->TooltipValue = ""; // id_tipo_carga $this->id_tipo_carga->LinkCustomAttributes = ""; $this->id_tipo_carga->HrefValue = ""; $this->id_tipo_carga->TooltipValue = ""; // km_fin $this->km_fin->LinkCustomAttributes = ""; $this->km_fin->HrefValue = ""; $this->km_fin->TooltipValue = ""; // fecha_fin $this->fecha_fin->LinkCustomAttributes = ""; $this->fecha_fin->HrefValue = ""; $this->fecha_fin->TooltipValue = ""; // adelanto $this->adelanto->LinkCustomAttributes = ""; $this->adelanto->HrefValue = ""; $this->adelanto->TooltipValue = ""; // kg_carga $this->kg_carga->LinkCustomAttributes = ""; $this->kg_carga->HrefValue = ""; $this->kg_carga->TooltipValue = ""; // tarifa $this->tarifa->LinkCustomAttributes = ""; $this->tarifa->HrefValue = ""; $this->tarifa->TooltipValue = ""; // porcentaje $this->porcentaje->LinkCustomAttributes = ""; $this->porcentaje->HrefValue = ""; $this->porcentaje->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_EDIT) { // Edit row // fecha_ini $this->fecha_ini->EditAttrs["class"] = "form-control"; $this->fecha_ini->EditCustomAttributes = ""; $this->fecha_ini->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->fecha_ini->CurrentValue, 7)); $this->fecha_ini->PlaceHolder = ew_RemoveHtml($this->fecha_ini->FldCaption()); // id_cliente $this->id_cliente->EditAttrs["class"] = "form-control"; $this->id_cliente->EditCustomAttributes = ""; if (trim(strval($this->id_cliente->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_cliente->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `codigo`, `cuit_cuil` AS `DispFld`, `razon_social` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `clientes`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_cliente, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `razon_social` ASC"; $rswrk = $conn->Execute($sSqlWrk); $arwrk = $rswrk ? $rswrk->GetRows() : array(); if ($rswrk) { $rswrk->Close(); } array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"), "", "", "", "", "", "", "")); $this->id_cliente->EditValue = $arwrk; // id_localidad_origen $this->id_localidad_origen->EditAttrs["class"] = "form-control"; $this->id_localidad_origen->EditCustomAttributes = ""; if (trim(strval($this->id_localidad_origen->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_localidad_origen->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `codigo`, `cp` AS `DispFld`, `localidad` AS `Disp2Fld`, `provincia` AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `v_localidad_provincia`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_localidad_origen, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `localidad` ASC"; $rswrk = $conn->Execute($sSqlWrk); $arwrk = $rswrk ? $rswrk->GetRows() : array(); if ($rswrk) { $rswrk->Close(); } array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"), "", "", "", "", "", "", "")); $this->id_localidad_origen->EditValue = $arwrk; // Origen $this->Origen->EditAttrs["class"] = "form-control"; $this->Origen->EditCustomAttributes = ""; $this->Origen->EditValue = ew_HtmlEncode($this->Origen->CurrentValue); $this->Origen->PlaceHolder = ew_RemoveHtml($this->Origen->FldCaption()); // id_localidad_destino $this->id_localidad_destino->EditAttrs["class"] = "form-control"; $this->id_localidad_destino->EditCustomAttributes = ""; if (trim(strval($this->id_localidad_destino->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_localidad_destino->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `codigo`, `cp` AS `DispFld`, `localidad` AS `Disp2Fld`, `provincia` AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `v_localidad_provincia`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_localidad_destino, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `localidad` ASC"; $rswrk = $conn->Execute($sSqlWrk); $arwrk = $rswrk ? $rswrk->GetRows() : array(); if ($rswrk) { $rswrk->Close(); } array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"), "", "", "", "", "", "", "")); $this->id_localidad_destino->EditValue = $arwrk; // Destino $this->Destino->EditAttrs["class"] = "form-control"; $this->Destino->EditCustomAttributes = ""; $this->Destino->EditValue = ew_HtmlEncode($this->Destino->CurrentValue); $this->Destino->PlaceHolder = ew_RemoveHtml($this->Destino->FldCaption()); // Km_ini $this->Km_ini->EditAttrs["class"] = "form-control"; $this->Km_ini->EditCustomAttributes = ""; $this->Km_ini->EditValue = ew_HtmlEncode($this->Km_ini->CurrentValue); $this->Km_ini->PlaceHolder = ew_RemoveHtml($this->Km_ini->FldCaption()); // estado $this->estado->EditAttrs["class"] = "form-control"; $this->estado->EditCustomAttributes = ""; $this->estado->EditValue = ew_HtmlEncode($this->estado->CurrentValue); $this->estado->PlaceHolder = ew_RemoveHtml($this->estado->FldCaption()); // id_vehiculo $this->id_vehiculo->EditAttrs["class"] = "form-control"; $this->id_vehiculo->EditCustomAttributes = ""; if (trim(strval($this->id_vehiculo->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_vehiculo->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `codigo`, `Patente` AS `DispFld`, `nombre` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `vehiculos`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_vehiculo, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `nombre` ASC"; $rswrk = $conn->Execute($sSqlWrk); $arwrk = $rswrk ? $rswrk->GetRows() : array(); if ($rswrk) { $rswrk->Close(); } array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"), "", "", "", "", "", "", "")); $this->id_vehiculo->EditValue = $arwrk; // id_tipo_carga $this->id_tipo_carga->EditAttrs["class"] = "form-control"; $this->id_tipo_carga->EditCustomAttributes = ""; if (trim(strval($this->id_tipo_carga->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_tipo_carga->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `codigo`, `Tipo_carga` AS `DispFld`, `precio_base` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `tipo_cargas`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_tipo_carga, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `Tipo_carga` 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_FormatCurrency($arwrk[$rowcntwrk][2], 2, 0, 0, -1); } array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"), "", "", "", "", "", "", "")); $this->id_tipo_carga->EditValue = $arwrk; // km_fin $this->km_fin->EditAttrs["class"] = "form-control"; $this->km_fin->EditCustomAttributes = ""; $this->km_fin->EditValue = ew_HtmlEncode($this->km_fin->CurrentValue); $this->km_fin->PlaceHolder = ew_RemoveHtml($this->km_fin->FldCaption()); // fecha_fin $this->fecha_fin->EditAttrs["class"] = "form-control"; $this->fecha_fin->EditCustomAttributes = ""; $this->fecha_fin->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->fecha_fin->CurrentValue, 7)); $this->fecha_fin->PlaceHolder = ew_RemoveHtml($this->fecha_fin->FldCaption()); // adelanto $this->adelanto->EditAttrs["class"] = "form-control"; $this->adelanto->EditCustomAttributes = ""; $this->adelanto->EditValue = ew_HtmlEncode($this->adelanto->CurrentValue); $this->adelanto->PlaceHolder = ew_RemoveHtml($this->adelanto->FldCaption()); if (strval($this->adelanto->EditValue) != "" && is_numeric($this->adelanto->EditValue)) { $this->adelanto->EditValue = ew_FormatNumber($this->adelanto->EditValue, -2, -2, -2, -2); } // kg_carga $this->kg_carga->EditAttrs["class"] = "form-control"; $this->kg_carga->EditCustomAttributes = ""; $this->kg_carga->EditValue = ew_HtmlEncode($this->kg_carga->CurrentValue); $this->kg_carga->PlaceHolder = ew_RemoveHtml($this->kg_carga->FldCaption()); // tarifa $this->tarifa->EditAttrs["class"] = "form-control"; $this->tarifa->EditCustomAttributes = ""; $this->tarifa->EditValue = ew_HtmlEncode($this->tarifa->CurrentValue); $this->tarifa->PlaceHolder = ew_RemoveHtml($this->tarifa->FldCaption()); if (strval($this->tarifa->EditValue) != "" && is_numeric($this->tarifa->EditValue)) { $this->tarifa->EditValue = ew_FormatNumber($this->tarifa->EditValue, -2, -2, -2, -2); } // porcentaje $this->porcentaje->EditAttrs["class"] = "form-control"; $this->porcentaje->EditCustomAttributes = ""; $this->porcentaje->EditValue = ew_HtmlEncode($this->porcentaje->CurrentValue); $this->porcentaje->PlaceHolder = ew_RemoveHtml($this->porcentaje->FldCaption()); if (strval($this->porcentaje->EditValue) != "" && is_numeric($this->porcentaje->EditValue)) { $this->porcentaje->EditValue = ew_FormatNumber($this->porcentaje->EditValue, -2, -1, -2, 0); } // Edit refer script // fecha_ini $this->fecha_ini->HrefValue = ""; // id_cliente $this->id_cliente->HrefValue = ""; // id_localidad_origen $this->id_localidad_origen->HrefValue = ""; // Origen $this->Origen->HrefValue = ""; // id_localidad_destino $this->id_localidad_destino->HrefValue = ""; // Destino $this->Destino->HrefValue = ""; // Km_ini $this->Km_ini->HrefValue = ""; // estado $this->estado->HrefValue = ""; // id_vehiculo $this->id_vehiculo->HrefValue = ""; // id_tipo_carga $this->id_tipo_carga->HrefValue = ""; // km_fin $this->km_fin->HrefValue = ""; // fecha_fin $this->fecha_fin->HrefValue = ""; // adelanto $this->adelanto->HrefValue = ""; // kg_carga $this->kg_carga->HrefValue = ""; // tarifa $this->tarifa->HrefValue = ""; // porcentaje $this->porcentaje->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->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 // idinternado // fecha_inicio // fecha_final // estado // fecha // idhabitacion // idpaciente // es_operacion if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // idinternado $this->idinternado->ViewValue = $this->idinternado->CurrentValue; $this->idinternado->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; 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 = ""; // fecha $this->fecha->ViewValue = $this->fecha->CurrentValue; $this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7); $this->fecha->ViewCustomAttributes = ""; // idhabitacion if (strval($this->idhabitacion->CurrentValue) != "") { $sFilterWrk = "`idhabitacion`" . ew_SearchString("=", $this->idhabitacion->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idhabitacion`, `numero` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `habitacion`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idhabitacion, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idhabitacion->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idhabitacion->ViewValue = $this->idhabitacion->CurrentValue; } } else { $this->idhabitacion->ViewValue = NULL; } $this->idhabitacion->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`, `apellido` 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'); $this->idpaciente->ViewValue .= ew_ValueSeparator(2, $this->idpaciente) . $rswrk->fields('Disp3Fld'); $rswrk->Close(); } else { $this->idpaciente->ViewValue = $this->idpaciente->CurrentValue; } } else { $this->idpaciente->ViewValue = NULL; } $this->idpaciente->ViewCustomAttributes = ""; // es_operacion if (strval($this->es_operacion->CurrentValue) != "") { switch ($this->es_operacion->CurrentValue) { case $this->es_operacion->FldTagValue(1): $this->es_operacion->ViewValue = $this->es_operacion->FldTagCaption(1) != "" ? $this->es_operacion->FldTagCaption(1) : $this->es_operacion->CurrentValue; break; case $this->es_operacion->FldTagValue(2): $this->es_operacion->ViewValue = $this->es_operacion->FldTagCaption(2) != "" ? $this->es_operacion->FldTagCaption(2) : $this->es_operacion->CurrentValue; break; default: $this->es_operacion->ViewValue = $this->es_operacion->CurrentValue; } } else { $this->es_operacion->ViewValue = NULL; } $this->es_operacion->ViewCustomAttributes = ""; // idinternado $this->idinternado->LinkCustomAttributes = ""; $this->idinternado->HrefValue = ""; $this->idinternado->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 = ""; // fecha $this->fecha->LinkCustomAttributes = ""; $this->fecha->HrefValue = ""; $this->fecha->TooltipValue = ""; // idhabitacion $this->idhabitacion->LinkCustomAttributes = ""; $this->idhabitacion->HrefValue = ""; $this->idhabitacion->TooltipValue = ""; // idpaciente $this->idpaciente->LinkCustomAttributes = ""; $this->idpaciente->HrefValue = ""; $this->idpaciente->TooltipValue = ""; // es_operacion $this->es_operacion->LinkCustomAttributes = ""; $this->es_operacion->HrefValue = ""; $this->es_operacion->TooltipValue = ""; } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // realmid $this->realmid->CellCssStyle = "white-space: nowrap;"; // starttime $this->starttime->CellCssStyle = "white-space: nowrap;"; // uptime $this->uptime->CellCssStyle = "white-space: nowrap;"; // maxplayers $this->maxplayers->CellCssStyle = "white-space: nowrap;"; // revision $this->revision->CellCssStyle = "white-space: nowrap;"; if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // realmid if (strval($this->realmid->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->realmid->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `name` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `realmlist`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `id` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->realmid->ViewValue = $rswrk->fields('DispFld'); $this->realmid->ViewValue .= ew_ValueSeparator(1, $this->realmid) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->realmid->ViewValue = $this->realmid->CurrentValue; } } else { $this->realmid->ViewValue = NULL; } $this->realmid->ViewCustomAttributes = ""; // starttime $this->starttime->ViewValue = $this->starttime->CurrentValue; $this->starttime->ViewCustomAttributes = ""; // uptime $this->uptime->ViewValue = $this->uptime->CurrentValue; $this->uptime->ViewCustomAttributes = ""; // maxplayers $this->maxplayers->ViewValue = $this->maxplayers->CurrentValue; $this->maxplayers->ViewCustomAttributes = ""; // realmid $this->realmid->LinkCustomAttributes = ""; $this->realmid->HrefValue = ""; $this->realmid->TooltipValue = ""; // starttime $this->starttime->LinkCustomAttributes = ""; $this->starttime->HrefValue = ""; $this->starttime->TooltipValue = ""; // uptime $this->uptime->LinkCustomAttributes = ""; $this->uptime->HrefValue = ""; $this->uptime->TooltipValue = ""; // maxplayers $this->maxplayers->LinkCustomAttributes = ""; $this->maxplayers->HrefValue = ""; $this->maxplayers->TooltipValue = ""; } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $Orders; // Call Row_Rendering event $Orders->Row_Rendering(); // Common render codes for all row types // CustomerID $Orders->CustomerID->CellCssStyle = ""; $Orders->CustomerID->CellCssClass = ""; // TransactionNumber $Orders->TransactionNumber->CellCssStyle = ""; $Orders->TransactionNumber->CellCssClass = ""; // DateOrdered $Orders->DateOrdered->CellCssStyle = ""; $Orders->DateOrdered->CellCssClass = ""; // Total $Orders->Total->CellCssStyle = ""; $Orders->Total->CellCssClass = ""; // DeliveryDate $Orders->DeliveryDate->CellCssStyle = ""; $Orders->DeliveryDate->CellCssClass = ""; // PromoCodeID $Orders->PromoCodeID->CellCssStyle = ""; $Orders->PromoCodeID->CellCssClass = ""; // Timestamp $Orders->Timestamp->CellCssStyle = ""; $Orders->Timestamp->CellCssClass = ""; // Sequence $Orders->Sequence->CellCssStyle = ""; $Orders->Sequence->CellCssClass = ""; if ($Orders->RowType == EW_ROWTYPE_VIEW) { // View row // OrderID $Orders->OrderID->ViewValue = $Orders->OrderID->CurrentValue; $Orders->OrderID->CssStyle = ""; $Orders->OrderID->CssClass = ""; $Orders->OrderID->ViewCustomAttributes = ""; // CustomerID if (strval($Orders->CustomerID->CurrentValue) != "") { $sSqlWrk = "SELECT `LastName`, `FirstName` FROM `Customers` WHERE `CustomerID` = " . ew_AdjustSql($Orders->CustomerID->CurrentValue) . ""; $sSqlWrk .= " ORDER BY `LastName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $Orders->CustomerID->ViewValue = $rswrk->fields('LastName'); $Orders->CustomerID->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $Orders->CustomerID->ViewValue = $Orders->CustomerID->CurrentValue; } } else { $Orders->CustomerID->ViewValue = NULL; } $Orders->CustomerID->CssStyle = ""; $Orders->CustomerID->CssClass = ""; $Orders->CustomerID->ViewCustomAttributes = ""; // TransactionNumber $Orders->TransactionNumber->ViewValue = $Orders->TransactionNumber->CurrentValue; $Orders->TransactionNumber->CssStyle = ""; $Orders->TransactionNumber->CssClass = ""; $Orders->TransactionNumber->ViewCustomAttributes = ""; // DateOrdered $Orders->DateOrdered->ViewValue = $Orders->DateOrdered->CurrentValue; $Orders->DateOrdered->ViewValue = ew_FormatDateTime($Orders->DateOrdered->ViewValue, 6); $Orders->DateOrdered->CssStyle = ""; $Orders->DateOrdered->CssClass = ""; $Orders->DateOrdered->ViewCustomAttributes = ""; // Total $Orders->Total->ViewValue = $Orders->Total->CurrentValue; $Orders->Total->ViewValue = ew_FormatCurrency($Orders->Total->ViewValue, 2, -2, 0, -2); $Orders->Total->CssStyle = ""; $Orders->Total->CssClass = ""; $Orders->Total->ViewCustomAttributes = ""; // DeliveryDate $Orders->DeliveryDate->ViewValue = $Orders->DeliveryDate->CurrentValue; $Orders->DeliveryDate->ViewValue = ew_FormatDateTime($Orders->DeliveryDate->ViewValue, 6); $Orders->DeliveryDate->CssStyle = ""; $Orders->DeliveryDate->CssClass = ""; $Orders->DeliveryDate->ViewCustomAttributes = ""; // PromoCodeID if (strval($Orders->PromoCodeID->CurrentValue) != "") { $sSqlWrk = "SELECT `PromoCodeName` FROM `PromoCodes` WHERE `PromoCodeID` = " . ew_AdjustSql($Orders->PromoCodeID->CurrentValue) . ""; $sSqlWrk .= " ORDER BY `PromoCodeName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $Orders->PromoCodeID->ViewValue = $rswrk->fields('PromoCodeName'); $rswrk->Close(); } else { $Orders->PromoCodeID->ViewValue = $Orders->PromoCodeID->CurrentValue; } } else { $Orders->PromoCodeID->ViewValue = NULL; } $Orders->PromoCodeID->CssStyle = ""; $Orders->PromoCodeID->CssClass = ""; $Orders->PromoCodeID->ViewCustomAttributes = ""; // Timestamp $Orders->Timestamp->ViewValue = $Orders->Timestamp->CurrentValue; $Orders->Timestamp->ViewValue = ew_FormatDateTime($Orders->Timestamp->ViewValue, 6); $Orders->Timestamp->CssStyle = ""; $Orders->Timestamp->CssClass = ""; $Orders->Timestamp->ViewCustomAttributes = ""; // Sequence $Orders->Sequence->ViewValue = $Orders->Sequence->CurrentValue; $Orders->Sequence->CssStyle = ""; $Orders->Sequence->CssClass = ""; $Orders->Sequence->ViewCustomAttributes = ""; // CustomerID $Orders->CustomerID->HrefValue = ""; // TransactionNumber $Orders->TransactionNumber->HrefValue = ""; // DateOrdered $Orders->DateOrdered->HrefValue = ""; // Total $Orders->Total->HrefValue = ""; // DeliveryDate $Orders->DeliveryDate->HrefValue = ""; // PromoCodeID $Orders->PromoCodeID->HrefValue = ""; // Timestamp $Orders->Timestamp->HrefValue = ""; // Sequence $Orders->Sequence->HrefValue = ""; } elseif ($Orders->RowType == EW_ROWTYPE_ADD) { // Add row // CustomerID $Orders->CustomerID->EditCustomAttributes = ""; if ($Orders->CustomerID->getSessionValue() != "") { $Orders->CustomerID->CurrentValue = $Orders->CustomerID->getSessionValue(); if (strval($Orders->CustomerID->CurrentValue) != "") { $sSqlWrk = "SELECT `LastName`, `FirstName` FROM `Customers` WHERE `CustomerID` = " . ew_AdjustSql($Orders->CustomerID->CurrentValue) . ""; $sSqlWrk .= " ORDER BY `LastName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $Orders->CustomerID->ViewValue = $rswrk->fields('LastName'); $Orders->CustomerID->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $Orders->CustomerID->ViewValue = $Orders->CustomerID->CurrentValue; } } else { $Orders->CustomerID->ViewValue = NULL; } $Orders->CustomerID->CssStyle = ""; $Orders->CustomerID->CssClass = ""; $Orders->CustomerID->ViewCustomAttributes = ""; } else { $sSqlWrk = "SELECT `CustomerID`, `LastName`, `FirstName`, '' AS SelectFilterFld FROM `Customers`"; $sWhereWrk = ""; if ($sWhereWrk != "") { $sSqlWrk .= " WHERE {$sWhereWrk}"; } $sSqlWrk .= " ORDER BY `LastName` Asc"; $rswrk = $conn->Execute($sSqlWrk); $arwrk = $rswrk ? $rswrk->GetRows() : array(); if ($rswrk) { $rswrk->Close(); } array_unshift($arwrk, array("", "Please Select", "")); $Orders->CustomerID->EditValue = $arwrk; } // TransactionNumber $Orders->TransactionNumber->EditCustomAttributes = ""; $Orders->TransactionNumber->EditValue = ew_HtmlEncode($Orders->TransactionNumber->CurrentValue); // DateOrdered $Orders->DateOrdered->EditCustomAttributes = ""; $Orders->DateOrdered->EditValue = ew_HtmlEncode(ew_FormatDateTime($Orders->DateOrdered->CurrentValue, 6)); // Total $Orders->Total->EditCustomAttributes = ""; $Orders->Total->EditValue = ew_HtmlEncode($Orders->Total->CurrentValue); // DeliveryDate $Orders->DeliveryDate->EditCustomAttributes = ""; if ($Orders->DeliveryDate->getSessionValue() != "") { $Orders->DeliveryDate->CurrentValue = $Orders->DeliveryDate->getSessionValue(); $Orders->DeliveryDate->ViewValue = $Orders->DeliveryDate->CurrentValue; $Orders->DeliveryDate->ViewValue = ew_FormatDateTime($Orders->DeliveryDate->ViewValue, 6); $Orders->DeliveryDate->CssStyle = ""; $Orders->DeliveryDate->CssClass = ""; $Orders->DeliveryDate->ViewCustomAttributes = ""; } else { $Orders->DeliveryDate->EditValue = ew_HtmlEncode(ew_FormatDateTime($Orders->DeliveryDate->CurrentValue, 6)); } // PromoCodeID $Orders->PromoCodeID->EditCustomAttributes = ""; $sSqlWrk = "SELECT `PromoCodeID`, `PromoCodeName`, '' AS Disp2Fld, '' AS SelectFilterFld FROM `PromoCodes`"; $sWhereWrk = ""; if ($sWhereWrk != "") { $sSqlWrk .= " WHERE {$sWhereWrk}"; } $sSqlWrk .= " ORDER BY `PromoCodeName` Asc"; $rswrk = $conn->Execute($sSqlWrk); $arwrk = $rswrk ? $rswrk->GetRows() : array(); if ($rswrk) { $rswrk->Close(); } array_unshift($arwrk, array("", "Please Select")); $Orders->PromoCodeID->EditValue = $arwrk; // Timestamp $Orders->Timestamp->EditCustomAttributes = ""; $Orders->Timestamp->EditValue = ew_HtmlEncode(ew_FormatDateTime($Orders->Timestamp->CurrentValue, 6)); // Sequence $Orders->Sequence->EditCustomAttributes = ""; $Orders->Sequence->EditValue = ew_HtmlEncode($Orders->Sequence->CurrentValue); } // Call Row Rendered event $Orders->Row_Rendered(); }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // idinternado // fecha_inicio // fecha_final // estado // fecha // idhabitacion // idpaciente // es_operacion if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // idinternado $this->idinternado->ViewValue = $this->idinternado->CurrentValue; $this->idinternado->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; 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 = ""; // fecha $this->fecha->ViewValue = $this->fecha->CurrentValue; $this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7); $this->fecha->ViewCustomAttributes = ""; // idhabitacion if (strval($this->idhabitacion->CurrentValue) != "") { $sFilterWrk = "`idhabitacion`" . ew_SearchString("=", $this->idhabitacion->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idhabitacion`, `numero` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `habitacion`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idhabitacion, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idhabitacion->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idhabitacion->ViewValue = $this->idhabitacion->CurrentValue; } } else { $this->idhabitacion->ViewValue = NULL; } $this->idhabitacion->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`, `apellido` 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'); $this->idpaciente->ViewValue .= ew_ValueSeparator(2, $this->idpaciente) . $rswrk->fields('Disp3Fld'); $rswrk->Close(); } else { $this->idpaciente->ViewValue = $this->idpaciente->CurrentValue; } } else { $this->idpaciente->ViewValue = NULL; } $this->idpaciente->ViewCustomAttributes = ""; // es_operacion if (strval($this->es_operacion->CurrentValue) != "") { switch ($this->es_operacion->CurrentValue) { case $this->es_operacion->FldTagValue(1): $this->es_operacion->ViewValue = $this->es_operacion->FldTagCaption(1) != "" ? $this->es_operacion->FldTagCaption(1) : $this->es_operacion->CurrentValue; break; case $this->es_operacion->FldTagValue(2): $this->es_operacion->ViewValue = $this->es_operacion->FldTagCaption(2) != "" ? $this->es_operacion->FldTagCaption(2) : $this->es_operacion->CurrentValue; break; default: $this->es_operacion->ViewValue = $this->es_operacion->CurrentValue; } } else { $this->es_operacion->ViewValue = NULL; } $this->es_operacion->ViewCustomAttributes = ""; // fecha $this->fecha->LinkCustomAttributes = ""; $this->fecha->HrefValue = ""; $this->fecha->TooltipValue = ""; // idhabitacion $this->idhabitacion->LinkCustomAttributes = ""; $this->idhabitacion->HrefValue = ""; $this->idhabitacion->TooltipValue = ""; // idpaciente $this->idpaciente->LinkCustomAttributes = ""; $this->idpaciente->HrefValue = ""; $this->idpaciente->TooltipValue = ""; // es_operacion $this->es_operacion->LinkCustomAttributes = ""; $this->es_operacion->HrefValue = ""; $this->es_operacion->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_ADD) { // Add row // 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()); // idhabitacion $this->idhabitacion->EditAttrs["class"] = "form-control"; $this->idhabitacion->EditCustomAttributes = ""; if ($this->idhabitacion->getSessionValue() != "") { $this->idhabitacion->CurrentValue = $this->idhabitacion->getSessionValue(); if (strval($this->idhabitacion->CurrentValue) != "") { $sFilterWrk = "`idhabitacion`" . ew_SearchString("=", $this->idhabitacion->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idhabitacion`, `numero` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `habitacion`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idhabitacion, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idhabitacion->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idhabitacion->ViewValue = $this->idhabitacion->CurrentValue; } } else { $this->idhabitacion->ViewValue = NULL; } $this->idhabitacion->ViewCustomAttributes = ""; } else { if (trim(strval($this->idhabitacion->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`idhabitacion`" . ew_SearchString("=", $this->idhabitacion->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `idhabitacion`, `numero` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `habitacion`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idhabitacion, $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->idhabitacion->EditValue = $arwrk; } // idpaciente $this->idpaciente->EditAttrs["class"] = "form-control"; $this->idpaciente->EditCustomAttributes = ""; if ($this->idpaciente->getSessionValue() != "") { $this->idpaciente->CurrentValue = $this->idpaciente->getSessionValue(); if (strval($this->idpaciente->CurrentValue) != "") { $sFilterWrk = "`idpaciente`" . ew_SearchString("=", $this->idpaciente->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idpaciente`, `nombre` AS `DispFld`, '' AS `Disp2Fld`, `apellido` 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'); $this->idpaciente->ViewValue .= ew_ValueSeparator(2, $this->idpaciente) . $rswrk->fields('Disp3Fld'); $rswrk->Close(); } else { $this->idpaciente->ViewValue = $this->idpaciente->CurrentValue; } } else { $this->idpaciente->ViewValue = NULL; } $this->idpaciente->ViewCustomAttributes = ""; } else { if (trim(strval($this->idpaciente->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`idpaciente`" . ew_SearchString("=", $this->idpaciente->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `idpaciente`, `nombre` AS `DispFld`, '' AS `Disp2Fld`, `apellido` AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` 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); $arwrk = $rswrk ? $rswrk->GetRows() : array(); if ($rswrk) { $rswrk->Close(); } array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"), "", "", "", "", "", "", "")); $this->idpaciente->EditValue = $arwrk; } // es_operacion $this->es_operacion->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array($this->es_operacion->FldTagValue(1), $this->es_operacion->FldTagCaption(1) != "" ? $this->es_operacion->FldTagCaption(1) : $this->es_operacion->FldTagValue(1)); $arwrk[] = array($this->es_operacion->FldTagValue(2), $this->es_operacion->FldTagCaption(2) != "" ? $this->es_operacion->FldTagCaption(2) : $this->es_operacion->FldTagValue(2)); $this->es_operacion->EditValue = $arwrk; // Edit refer script // fecha $this->fecha->HrefValue = ""; // idhabitacion $this->idhabitacion->HrefValue = ""; // idpaciente $this->idpaciente->HrefValue = ""; // es_operacion $this->es_operacion->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 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`, `socio_nro` AS `DispFld`, `propietario` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `socios`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_socio, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $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_montos $this->id_montos->EditAttrs["class"] = "form-control"; $this->id_montos->EditCustomAttributes = ""; if ($this->id_montos->getSessionValue() != "") { $this->id_montos->CurrentValue = $this->id_montos->getSessionValue(); if (strval($this->id_montos->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->id_montos->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `descripcion` AS `DispFld`, `importe` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `montos`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_montos, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_montos->ViewValue = $rswrk->fields('DispFld'); $this->id_montos->ViewValue .= ew_ValueSeparator(1, $this->id_montos) . ew_FormatCurrency($rswrk->fields('Disp2Fld'), 0, -2, -2, -2); $rswrk->Close(); } else { $this->id_montos->ViewValue = $this->id_montos->CurrentValue; } } else { $this->id_montos->ViewValue = NULL; } $this->id_montos->ViewCustomAttributes = ""; } else { } // id_usuario // 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()); // 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 = ""; // 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()); // 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, 0, 0, -1); } // 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 DISTINCT `codigo`, `codigo` AS `DispFld`, `tipo_gasto` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tipo_gastos`"; $sWhereWrk = ""; $lookuptblfilter = "`clase`='R'"; 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'); $this->id_tipo_gasto->ViewValue .= ew_ValueSeparator(1, $this->id_tipo_gasto) . $rswrk->fields('Disp2Fld'); $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_ruta $this->id_hoja_ruta->EditAttrs["class"] = "form-control"; $this->id_hoja_ruta->EditCustomAttributes = ""; if ($this->id_hoja_ruta->getSessionValue() != "") { $this->id_hoja_ruta->CurrentValue = $this->id_hoja_ruta->getSessionValue(); if ($this->id_hoja_ruta->VirtualValue != "") { $this->id_hoja_ruta->ViewValue = $this->id_hoja_ruta->VirtualValue; } else { $this->id_hoja_ruta->ViewValue = $this->id_hoja_ruta->CurrentValue; if (strval($this->id_hoja_ruta->CurrentValue) != "") { $sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_hoja_ruta->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `codigo`, `codigo` AS `DispFld`, `fecha_ini` AS `Disp2Fld`, `Origen` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `hoja_rutas`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_hoja_ruta, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $sSqlWrk .= " ORDER BY `codigo` ASC"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_hoja_ruta->ViewValue = $rswrk->fields('DispFld'); $this->id_hoja_ruta->ViewValue .= ew_ValueSeparator(1, $this->id_hoja_ruta) . ew_FormatDateTime($rswrk->fields('Disp2Fld'), 7); $this->id_hoja_ruta->ViewValue .= ew_ValueSeparator(2, $this->id_hoja_ruta) . $rswrk->fields('Disp3Fld'); $rswrk->Close(); } else { $this->id_hoja_ruta->ViewValue = $this->id_hoja_ruta->CurrentValue; } } else { $this->id_hoja_ruta->ViewValue = NULL; } } $this->id_hoja_ruta->ViewCustomAttributes = ""; } else { $this->id_hoja_ruta->EditValue = ew_HtmlEncode($this->id_hoja_ruta->CurrentValue); $this->id_hoja_ruta->PlaceHolder = ew_RemoveHtml($this->id_hoja_ruta->FldCaption()); } // id_usuario // Call Row Rendered event $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 RenderRow() { global $conn, $Security, $Orders; // Call Row_Rendering event $Orders->Row_Rendering(); // Common render codes for all row types // OrderID $Orders->OrderID->CellCssStyle = ""; $Orders->OrderID->CellCssClass = ""; // CustomerID $Orders->CustomerID->CellCssStyle = ""; $Orders->CustomerID->CellCssClass = ""; // TransactionNumber $Orders->TransactionNumber->CellCssStyle = ""; $Orders->TransactionNumber->CellCssClass = ""; // DateOrdered $Orders->DateOrdered->CellCssStyle = ""; $Orders->DateOrdered->CellCssClass = ""; // Total $Orders->Total->CellCssStyle = ""; $Orders->Total->CellCssClass = ""; // DeliveryDate $Orders->DeliveryDate->CellCssStyle = ""; $Orders->DeliveryDate->CellCssClass = ""; // PromoCodeID $Orders->PromoCodeID->CellCssStyle = ""; $Orders->PromoCodeID->CellCssClass = ""; // Sequence $Orders->Sequence->CellCssStyle = ""; $Orders->Sequence->CellCssClass = ""; if ($Orders->RowType == EW_ROWTYPE_VIEW) { // View row // OrderID $Orders->OrderID->ViewValue = $Orders->OrderID->CurrentValue; $Orders->OrderID->CssStyle = ""; $Orders->OrderID->CssClass = ""; $Orders->OrderID->ViewCustomAttributes = ""; // CustomerID if (strval($Orders->CustomerID->CurrentValue) != "") { $sSqlWrk = "SELECT `LastName`, `FirstName` FROM `Customers` WHERE `CustomerID` = " . ew_AdjustSql($Orders->CustomerID->CurrentValue) . ""; $sSqlWrk .= " ORDER BY `LastName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $Orders->CustomerID->ViewValue = $rswrk->fields('LastName'); $Orders->CustomerID->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $Orders->CustomerID->ViewValue = $Orders->CustomerID->CurrentValue; } } else { $Orders->CustomerID->ViewValue = NULL; } $Orders->CustomerID->CssStyle = ""; $Orders->CustomerID->CssClass = ""; $Orders->CustomerID->ViewCustomAttributes = ""; // TransactionNumber $Orders->TransactionNumber->ViewValue = $Orders->TransactionNumber->CurrentValue; $Orders->TransactionNumber->CssStyle = ""; $Orders->TransactionNumber->CssClass = ""; $Orders->TransactionNumber->ViewCustomAttributes = ""; // DateOrdered $Orders->DateOrdered->ViewValue = $Orders->DateOrdered->CurrentValue; $Orders->DateOrdered->ViewValue = ew_FormatDateTime($Orders->DateOrdered->ViewValue, 6); $Orders->DateOrdered->CssStyle = ""; $Orders->DateOrdered->CssClass = ""; $Orders->DateOrdered->ViewCustomAttributes = ""; // Total $Orders->Total->ViewValue = $Orders->Total->CurrentValue; $Orders->Total->ViewValue = ew_FormatCurrency($Orders->Total->ViewValue, 2, -2, 0, -2); $Orders->Total->CssStyle = ""; $Orders->Total->CssClass = ""; $Orders->Total->ViewCustomAttributes = ""; // DeliveryDate $Orders->DeliveryDate->ViewValue = $Orders->DeliveryDate->CurrentValue; $Orders->DeliveryDate->ViewValue = ew_FormatDateTime($Orders->DeliveryDate->ViewValue, 6); $Orders->DeliveryDate->CssStyle = ""; $Orders->DeliveryDate->CssClass = ""; $Orders->DeliveryDate->ViewCustomAttributes = ""; // PromoCodeID if (strval($Orders->PromoCodeID->CurrentValue) != "") { $sSqlWrk = "SELECT `PromoCodeName` FROM `PromoCodes` WHERE `PromoCodeID` = " . ew_AdjustSql($Orders->PromoCodeID->CurrentValue) . ""; $sSqlWrk .= " ORDER BY `PromoCodeName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $Orders->PromoCodeID->ViewValue = $rswrk->fields('PromoCodeName'); $rswrk->Close(); } else { $Orders->PromoCodeID->ViewValue = $Orders->PromoCodeID->CurrentValue; } } else { $Orders->PromoCodeID->ViewValue = NULL; } $Orders->PromoCodeID->CssStyle = ""; $Orders->PromoCodeID->CssClass = ""; $Orders->PromoCodeID->ViewCustomAttributes = ""; // Sequence $Orders->Sequence->ViewValue = $Orders->Sequence->CurrentValue; $Orders->Sequence->CssStyle = ""; $Orders->Sequence->CssClass = ""; $Orders->Sequence->ViewCustomAttributes = ""; // OrderID $Orders->OrderID->HrefValue = ""; // CustomerID $Orders->CustomerID->HrefValue = ""; // TransactionNumber $Orders->TransactionNumber->HrefValue = ""; // DateOrdered $Orders->DateOrdered->HrefValue = ""; // Total $Orders->Total->HrefValue = ""; // DeliveryDate $Orders->DeliveryDate->HrefValue = ""; // PromoCodeID $Orders->PromoCodeID->HrefValue = ""; // Sequence $Orders->Sequence->HrefValue = ""; } elseif ($Orders->RowType == EW_ROWTYPE_SEARCH) { // Search row // OrderID $Orders->OrderID->EditCustomAttributes = ""; $Orders->OrderID->EditValue = ew_HtmlEncode($Orders->OrderID->AdvancedSearch->SearchValue); // CustomerID $Orders->CustomerID->EditCustomAttributes = ""; $Orders->CustomerID->EditCustomAttributes = ""; // TransactionNumber $Orders->TransactionNumber->EditCustomAttributes = ""; $Orders->TransactionNumber->EditValue = ew_HtmlEncode($Orders->TransactionNumber->AdvancedSearch->SearchValue); $Orders->TransactionNumber->EditCustomAttributes = ""; $Orders->TransactionNumber->EditValue2 = ew_HtmlEncode($Orders->TransactionNumber->AdvancedSearch->SearchValue2); // DateOrdered $Orders->DateOrdered->EditCustomAttributes = ""; $Orders->DateOrdered->EditValue = ew_HtmlEncode(ew_FormatDateTime(ew_UnFormatDateTime($Orders->DateOrdered->AdvancedSearch->SearchValue, 6), 6)); $Orders->DateOrdered->EditCustomAttributes = ""; $Orders->DateOrdered->EditValue2 = ew_HtmlEncode(ew_FormatDateTime(ew_UnFormatDateTime($Orders->DateOrdered->AdvancedSearch->SearchValue2, 6), 6)); // Total $Orders->Total->EditCustomAttributes = ""; $Orders->Total->EditValue = ew_HtmlEncode($Orders->Total->AdvancedSearch->SearchValue); // DeliveryDate $Orders->DeliveryDate->EditCustomAttributes = ""; $Orders->DeliveryDate->EditValue = ew_HtmlEncode(ew_FormatDateTime(ew_UnFormatDateTime($Orders->DeliveryDate->AdvancedSearch->SearchValue, 6), 6)); // PromoCodeID $Orders->PromoCodeID->EditCustomAttributes = ""; // Sequence $Orders->Sequence->EditCustomAttributes = ""; $Orders->Sequence->EditValue = ew_HtmlEncode($Orders->Sequence->AdvancedSearch->SearchValue); } // Call Row Rendered event $Orders->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->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 // socio_nro // id_rubro // id_usuario // propietario // comercio // direccion_comercio // activo if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // socio_nro $this->socio_nro->ViewValue = $this->socio_nro->CurrentValue; $this->socio_nro->ViewCustomAttributes = ""; // id_rubro if (strval($this->id_rubro->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->id_rubro->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `rubro` AS `DispFld`, `Descripcion` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `rubros`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_rubro, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_rubro->ViewValue = $rswrk->fields('DispFld'); $this->id_rubro->ViewValue .= ew_ValueSeparator(1, $this->id_rubro) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_rubro->ViewValue = $this->id_rubro->CurrentValue; } } else { $this->id_rubro->ViewValue = NULL; } $this->id_rubro->ViewCustomAttributes = ""; // id_usuario if (strval($this->id_usuario->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->id_usuario->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `usuario` AS `DispFld`, `nombre` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `usuario`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_usuario, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_usuario->ViewValue = $rswrk->fields('DispFld'); $this->id_usuario->ViewValue .= ew_ValueSeparator(1, $this->id_usuario) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_usuario->ViewValue = $this->id_usuario->CurrentValue; } } else { $this->id_usuario->ViewValue = NULL; } $this->id_usuario->ViewCustomAttributes = ""; // propietario $this->propietario->ViewValue = $this->propietario->CurrentValue; $this->propietario->ViewCustomAttributes = ""; // comercio $this->comercio->ViewValue = $this->comercio->CurrentValue; $this->comercio->ViewCustomAttributes = ""; // direccion_comercio $this->direccion_comercio->ViewValue = $this->direccion_comercio->CurrentValue; $this->direccion_comercio->ViewCustomAttributes = ""; // activo if (strval($this->activo->CurrentValue) != "") { switch ($this->activo->CurrentValue) { case $this->activo->FldTagValue(1): $this->activo->ViewValue = $this->activo->FldTagCaption(1) != "" ? $this->activo->FldTagCaption(1) : $this->activo->CurrentValue; break; case $this->activo->FldTagValue(2): $this->activo->ViewValue = $this->activo->FldTagCaption(2) != "" ? $this->activo->FldTagCaption(2) : $this->activo->CurrentValue; break; default: $this->activo->ViewValue = $this->activo->CurrentValue; } } else { $this->activo->ViewValue = NULL; } $this->activo->ViewCustomAttributes = ""; // socio_nro $this->socio_nro->LinkCustomAttributes = ""; $this->socio_nro->HrefValue = ""; $this->socio_nro->TooltipValue = ""; // id_rubro $this->id_rubro->LinkCustomAttributes = ""; $this->id_rubro->HrefValue = ""; $this->id_rubro->TooltipValue = ""; // id_usuario $this->id_usuario->LinkCustomAttributes = ""; $this->id_usuario->HrefValue = ""; $this->id_usuario->TooltipValue = ""; // propietario $this->propietario->LinkCustomAttributes = ""; $this->propietario->HrefValue = ""; $this->propietario->TooltipValue = ""; // comercio $this->comercio->LinkCustomAttributes = ""; $this->comercio->HrefValue = ""; $this->comercio->TooltipValue = ""; // direccion_comercio $this->direccion_comercio->LinkCustomAttributes = ""; $this->direccion_comercio->HrefValue = ""; $this->direccion_comercio->TooltipValue = ""; // activo $this->activo->LinkCustomAttributes = ""; $this->activo->HrefValue = ""; $this->activo->TooltipValue = ""; } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $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 RenderListRow() { global $conn, $Security; // Call Row Rendering event $this->Row_Rendering(); // Common render codes // id // id_deuda // fecha // monto // id_usuario // id $this->id->ViewValue = $this->id->CurrentValue; $this->id->ViewCustomAttributes = ""; // id_deuda if (strval($this->id_deuda->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->id_deuda->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `mes` AS `DispFld`, `anio` AS `Disp2Fld`, `monto` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `deudas`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_deuda, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_deuda->ViewValue = $rswrk->fields('DispFld'); $this->id_deuda->ViewValue .= ew_ValueSeparator(1, $this->id_deuda) . $rswrk->fields('Disp2Fld'); $this->id_deuda->ViewValue .= ew_ValueSeparator(2, $this->id_deuda) . $rswrk->fields('Disp3Fld'); $rswrk->Close(); } else { $this->id_deuda->ViewValue = $this->id_deuda->CurrentValue; } } else { $this->id_deuda->ViewValue = NULL; } $this->id_deuda->ViewCustomAttributes = ""; // fecha $this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7); $this->fecha->ViewCustomAttributes = ""; // monto $this->monto->ViewValue = $this->monto->CurrentValue; $this->monto->ViewCustomAttributes = ""; // id_usuario if (strval($this->id_usuario->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->id_usuario->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `usuario` AS `DispFld`, `nombre` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `usuario`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->id_usuario, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_usuario->ViewValue = $rswrk->fields('DispFld'); $this->id_usuario->ViewValue .= ew_ValueSeparator(1, $this->id_usuario) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_usuario->ViewValue = $this->id_usuario->CurrentValue; } } else { $this->id_usuario->ViewValue = NULL; } $this->id_usuario->ViewCustomAttributes = ""; // id $this->id->LinkCustomAttributes = ""; $this->id->HrefValue = ""; $this->id->TooltipValue = ""; // id_deuda $this->id_deuda->LinkCustomAttributes = ""; $this->id_deuda->HrefValue = ""; $this->id_deuda->TooltipValue = ""; // fecha $this->fecha->LinkCustomAttributes = ""; $this->fecha->HrefValue = ""; $this->fecha->TooltipValue = ""; // monto $this->monto->LinkCustomAttributes = ""; $this->monto->HrefValue = ""; $this->monto->TooltipValue = ""; // id_usuario $this->id_usuario->LinkCustomAttributes = ""; $this->id_usuario->HrefValue = ""; $this->id_usuario->TooltipValue = ""; // Call Row Rendered event $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(); // 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, $OrderDetails; // Call Row_Rendering event $OrderDetails->Row_Rendering(); // Common render codes for all row types // OrderDetailsID $OrderDetails->OrderDetailsID->CellCssStyle = ""; $OrderDetails->OrderDetailsID->CellCssClass = ""; // OrderID $OrderDetails->OrderID->CellCssStyle = ""; $OrderDetails->OrderID->CellCssClass = ""; // CustomerID $OrderDetails->CustomerID->CellCssStyle = ""; $OrderDetails->CustomerID->CellCssClass = ""; // ItemID $OrderDetails->ItemID->CellCssStyle = ""; $OrderDetails->ItemID->CellCssClass = ""; // Count $OrderDetails->Count->CellCssStyle = ""; $OrderDetails->Count->CellCssClass = ""; // VegCount $OrderDetails->VegCount->CellCssStyle = ""; $OrderDetails->VegCount->CellCssClass = ""; // Chefs_Tasting $OrderDetails->Chefs_Tasting->CellCssStyle = ""; $OrderDetails->Chefs_Tasting->CellCssClass = ""; if ($OrderDetails->RowType == EW_ROWTYPE_VIEW) { // View row // OrderDetailsID $OrderDetails->OrderDetailsID->ViewValue = $OrderDetails->OrderDetailsID->CurrentValue; $OrderDetails->OrderDetailsID->CssStyle = ""; $OrderDetails->OrderDetailsID->CssClass = ""; $OrderDetails->OrderDetailsID->ViewCustomAttributes = ""; // OrderID $OrderDetails->OrderID->ViewValue = $OrderDetails->OrderID->CurrentValue; $OrderDetails->OrderID->CssStyle = ""; $OrderDetails->OrderID->CssClass = ""; $OrderDetails->OrderID->ViewCustomAttributes = ""; // CustomerID if (strval($OrderDetails->CustomerID->CurrentValue) != "") { $sSqlWrk = "SELECT `LastName`, `FirstName` FROM `Customers` WHERE `CustomerID` = " . ew_AdjustSql($OrderDetails->CustomerID->CurrentValue) . ""; $sSqlWrk .= " ORDER BY `LastName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $OrderDetails->CustomerID->ViewValue = $rswrk->fields('LastName'); $OrderDetails->CustomerID->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $OrderDetails->CustomerID->ViewValue = $OrderDetails->CustomerID->CurrentValue; } } else { $OrderDetails->CustomerID->ViewValue = NULL; } $OrderDetails->CustomerID->CssStyle = ""; $OrderDetails->CustomerID->CssClass = ""; $OrderDetails->CustomerID->ViewCustomAttributes = ""; // ItemID if (strval($OrderDetails->ItemID->CurrentValue) != "") { $sSqlWrk = "SELECT `ItemName` FROM `Items` WHERE `ItemID` = " . ew_AdjustSql($OrderDetails->ItemID->CurrentValue) . ""; $sSqlWrk .= " ORDER BY `ItemName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup value(s) found $OrderDetails->ItemID->ViewValue = $rswrk->fields('ItemName'); $rswrk->Close(); } else { $OrderDetails->ItemID->ViewValue = $OrderDetails->ItemID->CurrentValue; } } else { $OrderDetails->ItemID->ViewValue = NULL; } $OrderDetails->ItemID->CssStyle = ""; $OrderDetails->ItemID->CssClass = ""; $OrderDetails->ItemID->ViewCustomAttributes = ""; // Count $OrderDetails->Count->ViewValue = $OrderDetails->Count->CurrentValue; $OrderDetails->Count->CssStyle = ""; $OrderDetails->Count->CssClass = ""; $OrderDetails->Count->ViewCustomAttributes = ""; // VegCount $OrderDetails->VegCount->ViewValue = $OrderDetails->VegCount->CurrentValue; $OrderDetails->VegCount->CssStyle = ""; $OrderDetails->VegCount->CssClass = ""; $OrderDetails->VegCount->ViewCustomAttributes = ""; // Amount $OrderDetails->Amount->ViewValue = $OrderDetails->Amount->CurrentValue; $OrderDetails->Amount->ViewValue = ew_FormatCurrency($OrderDetails->Amount->ViewValue, 2, -2, 0, -2); $OrderDetails->Amount->CssStyle = ""; $OrderDetails->Amount->CssClass = ""; $OrderDetails->Amount->ViewCustomAttributes = ""; // Chefs_Tasting if (strval($OrderDetails->Chefs_Tasting->CurrentValue) != "") { switch ($OrderDetails->Chefs_Tasting->CurrentValue) { case "0": $OrderDetails->Chefs_Tasting->ViewValue = "No"; break; case "1": $OrderDetails->Chefs_Tasting->ViewValue = "Yes"; break; default: $OrderDetails->Chefs_Tasting->ViewValue = $OrderDetails->Chefs_Tasting->CurrentValue; } } else { $OrderDetails->Chefs_Tasting->ViewValue = NULL; } $OrderDetails->Chefs_Tasting->CssStyle = ""; $OrderDetails->Chefs_Tasting->CssClass = ""; $OrderDetails->Chefs_Tasting->ViewCustomAttributes = ""; // OrderDetailsID $OrderDetails->OrderDetailsID->HrefValue = ""; // OrderID $OrderDetails->OrderID->HrefValue = ""; // CustomerID $OrderDetails->CustomerID->HrefValue = ""; // ItemID $OrderDetails->ItemID->HrefValue = ""; // Count $OrderDetails->Count->HrefValue = ""; // VegCount $OrderDetails->VegCount->HrefValue = ""; // Chefs_Tasting $OrderDetails->Chefs_Tasting->HrefValue = ""; } // Call Row Rendered event $OrderDetails->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 // accountId // permissionId // granted // realmId if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // accountId if (strval($this->accountId->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->accountId->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `username` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `account`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->accountId->ViewValue = $rswrk->fields('DispFld'); $this->accountId->ViewValue .= ew_ValueSeparator(1, $this->accountId) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->accountId->ViewValue = $this->accountId->CurrentValue; } } else { $this->accountId->ViewValue = NULL; } $this->accountId->ViewCustomAttributes = ""; // permissionId if ($this->permissionId->VirtualValue != "") { $this->permissionId->ViewValue = $this->permissionId->VirtualValue; } else { if (strval($this->permissionId->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->permissionId->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `name` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `rbac_permissions`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->permissionId->ViewValue = $rswrk->fields('DispFld'); $this->permissionId->ViewValue .= ew_ValueSeparator(1, $this->permissionId) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->permissionId->ViewValue = $this->permissionId->CurrentValue; } } else { $this->permissionId->ViewValue = NULL; } } $this->permissionId->ViewCustomAttributes = ""; // granted if (strval($this->granted->CurrentValue) != "") { switch ($this->granted->CurrentValue) { case $this->granted->FldTagValue(1): $this->granted->ViewValue = $this->granted->FldTagCaption(1) != "" ? $this->granted->FldTagCaption(1) : $this->granted->CurrentValue; break; case $this->granted->FldTagValue(2): $this->granted->ViewValue = $this->granted->FldTagCaption(2) != "" ? $this->granted->FldTagCaption(2) : $this->granted->CurrentValue; break; default: $this->granted->ViewValue = $this->granted->CurrentValue; } } else { $this->granted->ViewValue = NULL; } $this->granted->ViewCustomAttributes = ""; // realmId if (strval($this->realmId->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->realmId->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `name` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `realmlist`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->realmId->ViewValue = $rswrk->fields('DispFld'); $this->realmId->ViewValue .= ew_ValueSeparator(1, $this->realmId) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->realmId->ViewValue = $this->realmId->CurrentValue; } } else { $this->realmId->ViewValue = NULL; } $this->realmId->ViewCustomAttributes = ""; // accountId $this->accountId->LinkCustomAttributes = ""; $this->accountId->HrefValue = ""; $this->accountId->TooltipValue = ""; // permissionId $this->permissionId->LinkCustomAttributes = ""; $this->permissionId->HrefValue = ""; $this->permissionId->TooltipValue = ""; // granted $this->granted->LinkCustomAttributes = ""; $this->granted->HrefValue = ""; $this->granted->TooltipValue = ""; // realmId $this->realmId->LinkCustomAttributes = ""; $this->realmId->HrefValue = ""; $this->realmId->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->precio_unitario->FormValue == $this->precio_unitario->CurrentValue && is_numeric(ew_StrToFloat($this->precio_unitario->CurrentValue))) { $this->precio_unitario->CurrentValue = ew_StrToFloat($this->precio_unitario->CurrentValue); } // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // idreceta // idempleado // idmedicina // fecha // cantidad // precio_unitario // idturno if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // idreceta $this->idreceta->ViewValue = $this->idreceta->CurrentValue; $this->idreceta->ViewCustomAttributes = ""; // idempleado if (strval($this->idempleado->CurrentValue) != "") { $sFilterWrk = "`idempleado`" . ew_SearchString("=", $this->idempleado->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idempleado`, `nombre` AS `DispFld`, `apellido` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `empleado`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idempleado, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idempleado->ViewValue = $rswrk->fields('DispFld'); $this->idempleado->ViewValue .= ew_ValueSeparator(1, $this->idempleado) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->idempleado->ViewValue = $this->idempleado->CurrentValue; } } else { $this->idempleado->ViewValue = NULL; } $this->idempleado->ViewCustomAttributes = ""; // idmedicina if (strval($this->idmedicina->CurrentValue) != "") { $sFilterWrk = "`idmedicina`" . ew_SearchString("=", $this->idmedicina->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idmedicina`, `descripcion` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `medicina`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idmedicina, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idmedicina->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idmedicina->ViewValue = $this->idmedicina->CurrentValue; } } else { $this->idmedicina->ViewValue = NULL; } $this->idmedicina->ViewCustomAttributes = ""; // fecha $this->fecha->ViewValue = $this->fecha->CurrentValue; $this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7); $this->fecha->ViewCustomAttributes = ""; // cantidad $this->cantidad->ViewValue = $this->cantidad->CurrentValue; $this->cantidad->ViewCustomAttributes = ""; // precio_unitario $this->precio_unitario->ViewValue = $this->precio_unitario->CurrentValue; $this->precio_unitario->ViewCustomAttributes = ""; // idturno if (strval($this->idturno->CurrentValue) != "") { $sFilterWrk = "`idturno`" . ew_SearchString("=", $this->idturno->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idturno`, `descripcion` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `turno`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idturno, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idturno->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idturno->ViewValue = $this->idturno->CurrentValue; } } else { $this->idturno->ViewValue = NULL; } $this->idturno->ViewCustomAttributes = ""; // idreceta $this->idreceta->LinkCustomAttributes = ""; $this->idreceta->HrefValue = ""; $this->idreceta->TooltipValue = ""; // idempleado $this->idempleado->LinkCustomAttributes = ""; $this->idempleado->HrefValue = ""; $this->idempleado->TooltipValue = ""; // idmedicina $this->idmedicina->LinkCustomAttributes = ""; $this->idmedicina->HrefValue = ""; $this->idmedicina->TooltipValue = ""; // fecha $this->fecha->LinkCustomAttributes = ""; $this->fecha->HrefValue = ""; $this->fecha->TooltipValue = ""; // cantidad $this->cantidad->LinkCustomAttributes = ""; $this->cantidad->HrefValue = ""; $this->cantidad->TooltipValue = ""; // precio_unitario $this->precio_unitario->LinkCustomAttributes = ""; $this->precio_unitario->HrefValue = ""; $this->precio_unitario->TooltipValue = ""; // idturno $this->idturno->LinkCustomAttributes = ""; $this->idturno->HrefValue = ""; $this->idturno->TooltipValue = ""; } // Call Row Rendered event if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) { $this->Row_Rendered(); } }
function RenderRow() { global $conn, $Security, $Language; global $gsLanguage; // Initialize URLs // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // socio_nro // id_actividad // id_usuario // propietario // comercio // direccion_comercio // activo // mail // tel // cel // cuit_cuil if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // socio_nro $this->socio_nro->ViewValue = $this->socio_nro->CurrentValue; $this->socio_nro->ViewCustomAttributes = ""; // id_actividad if (strval($this->id_actividad->CurrentValue) != "") { $sFilterWrk = "`id`" . ew_SearchString("=", $this->id_actividad->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `id`, `actividad` AS `DispFld`, `descripcion` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `actividad`"; $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_actividad, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->id_actividad->ViewValue = $rswrk->fields('DispFld'); $this->id_actividad->ViewValue .= ew_ValueSeparator(1, $this->id_actividad) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->id_actividad->ViewValue = $this->id_actividad->CurrentValue; } } else { $this->id_actividad->ViewValue = NULL; } $this->id_actividad->ViewCustomAttributes = ""; // propietario $this->propietario->ViewValue = $this->propietario->CurrentValue; $this->propietario->ViewCustomAttributes = ""; // comercio $this->comercio->ViewValue = $this->comercio->CurrentValue; $this->comercio->ViewCustomAttributes = ""; // direccion_comercio $this->direccion_comercio->ViewValue = $this->direccion_comercio->CurrentValue; $this->direccion_comercio->ViewCustomAttributes = ""; // activo if (strval($this->activo->CurrentValue) != "") { switch ($this->activo->CurrentValue) { case $this->activo->FldTagValue(1): $this->activo->ViewValue = $this->activo->FldTagCaption(1) != "" ? $this->activo->FldTagCaption(1) : $this->activo->CurrentValue; break; case $this->activo->FldTagValue(2): $this->activo->ViewValue = $this->activo->FldTagCaption(2) != "" ? $this->activo->FldTagCaption(2) : $this->activo->CurrentValue; break; default: $this->activo->ViewValue = $this->activo->CurrentValue; } } else { $this->activo->ViewValue = NULL; } $this->activo->ViewCustomAttributes = ""; // mail $this->mail->ViewValue = $this->mail->CurrentValue; $this->mail->ViewValue = strtolower($this->mail->ViewValue); $this->mail->ViewCustomAttributes = ""; // tel $this->tel->ViewValue = $this->tel->CurrentValue; $this->tel->ViewValue = trim($this->tel->ViewValue); $this->tel->ViewCustomAttributes = ""; // cel $this->cel->ViewValue = $this->cel->CurrentValue; $this->cel->ViewValue = trim($this->cel->ViewValue); $this->cel->ViewCustomAttributes = ""; // cuit_cuil $this->cuit_cuil->ViewValue = $this->cuit_cuil->CurrentValue; $this->cuit_cuil->ViewValue = ew_FormatNumber($this->cuit_cuil->ViewValue, 0, -2, -2, -2); $this->cuit_cuil->ViewCustomAttributes = ""; // id_actividad $this->id_actividad->LinkCustomAttributes = ""; $this->id_actividad->HrefValue = ""; $this->id_actividad->TooltipValue = ""; // propietario $this->propietario->LinkCustomAttributes = ""; $this->propietario->HrefValue = ""; $this->propietario->TooltipValue = ""; // comercio $this->comercio->LinkCustomAttributes = ""; $this->comercio->HrefValue = ""; $this->comercio->TooltipValue = ""; // direccion_comercio $this->direccion_comercio->LinkCustomAttributes = ""; $this->direccion_comercio->HrefValue = ""; $this->direccion_comercio->TooltipValue = ""; // activo $this->activo->LinkCustomAttributes = ""; $this->activo->HrefValue = ""; $this->activo->TooltipValue = ""; // mail $this->mail->LinkCustomAttributes = ""; $this->mail->HrefValue = ""; $this->mail->TooltipValue = ""; // tel $this->tel->LinkCustomAttributes = ""; $this->tel->HrefValue = ""; $this->tel->TooltipValue = ""; // cel $this->cel->LinkCustomAttributes = ""; $this->cel->HrefValue = ""; $this->cel->TooltipValue = ""; // cuit_cuil $this->cuit_cuil->LinkCustomAttributes = ""; $this->cuit_cuil->HrefValue = ""; $this->cuit_cuil->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_EDIT) { // Edit row // id_actividad $this->id_actividad->EditCustomAttributes = ""; if (trim(strval($this->id_actividad->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`id`" . ew_SearchString("=", $this->id_actividad->CurrentValue, EW_DATATYPE_NUMBER); } $sSqlWrk = "SELECT `id`, `actividad` AS `DispFld`, `descripcion` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `actividad`"; $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_actividad, $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->id_actividad->EditValue = $arwrk; // propietario $this->propietario->EditCustomAttributes = ""; $this->propietario->EditValue = ew_HtmlEncode($this->propietario->CurrentValue); $this->propietario->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->propietario->FldCaption())); // comercio $this->comercio->EditCustomAttributes = ""; $this->comercio->EditValue = ew_HtmlEncode($this->comercio->CurrentValue); $this->comercio->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->comercio->FldCaption())); // direccion_comercio $this->direccion_comercio->EditCustomAttributes = ""; $this->direccion_comercio->EditValue = ew_HtmlEncode($this->direccion_comercio->CurrentValue); $this->direccion_comercio->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->direccion_comercio->FldCaption())); // activo $this->activo->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array($this->activo->FldTagValue(1), $this->activo->FldTagCaption(1) != "" ? $this->activo->FldTagCaption(1) : $this->activo->FldTagValue(1)); $arwrk[] = array($this->activo->FldTagValue(2), $this->activo->FldTagCaption(2) != "" ? $this->activo->FldTagCaption(2) : $this->activo->FldTagValue(2)); $this->activo->EditValue = $arwrk; // mail $this->mail->EditCustomAttributes = ""; $this->mail->EditValue = ew_HtmlEncode($this->mail->CurrentValue); $this->mail->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->mail->FldCaption())); // tel $this->tel->EditCustomAttributes = ""; $this->tel->EditValue = ew_HtmlEncode($this->tel->CurrentValue); $this->tel->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->tel->FldCaption())); // cel $this->cel->EditCustomAttributes = ""; $this->cel->EditValue = ew_HtmlEncode($this->cel->CurrentValue); $this->cel->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->cel->FldCaption())); // cuit_cuil $this->cuit_cuil->EditCustomAttributes = ""; $this->cuit_cuil->EditValue = ew_HtmlEncode($this->cuit_cuil->CurrentValue); $this->cuit_cuil->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->cuit_cuil->FldCaption())); // Edit refer script // id_actividad $this->id_actividad->HrefValue = ""; // propietario $this->propietario->HrefValue = ""; // comercio $this->comercio->HrefValue = ""; // direccion_comercio $this->direccion_comercio->HrefValue = ""; // activo $this->activo->HrefValue = ""; // mail $this->mail->HrefValue = ""; // tel $this->tel->HrefValue = ""; // cel $this->cel->HrefValue = ""; // cuit_cuil $this->cuit_cuil->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 RenderEditRow() { global $conn, $Security, $gsLanguage, $Language; // Call Row Rendering event $this->Row_Rendering(); // idreceta $this->idreceta->EditAttrs["class"] = "form-control"; $this->idreceta->EditCustomAttributes = ""; $this->idreceta->EditValue = $this->idreceta->CurrentValue; $this->idreceta->ViewCustomAttributes = ""; // idempleado $this->idempleado->EditAttrs["class"] = "form-control"; $this->idempleado->EditCustomAttributes = ""; if ($this->idempleado->getSessionValue() != "") { $this->idempleado->CurrentValue = $this->idempleado->getSessionValue(); if (strval($this->idempleado->CurrentValue) != "") { $sFilterWrk = "`idempleado`" . ew_SearchString("=", $this->idempleado->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idempleado`, `nombre` AS `DispFld`, `apellido` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `empleado`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idempleado, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idempleado->ViewValue = $rswrk->fields('DispFld'); $this->idempleado->ViewValue .= ew_ValueSeparator(1, $this->idempleado) . $rswrk->fields('Disp2Fld'); $rswrk->Close(); } else { $this->idempleado->ViewValue = $this->idempleado->CurrentValue; } } else { $this->idempleado->ViewValue = NULL; } $this->idempleado->ViewCustomAttributes = ""; } else { } // idmedicina $this->idmedicina->EditAttrs["class"] = "form-control"; $this->idmedicina->EditCustomAttributes = ""; if ($this->idmedicina->getSessionValue() != "") { $this->idmedicina->CurrentValue = $this->idmedicina->getSessionValue(); if (strval($this->idmedicina->CurrentValue) != "") { $sFilterWrk = "`idmedicina`" . ew_SearchString("=", $this->idmedicina->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idmedicina`, `descripcion` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `medicina`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idmedicina, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idmedicina->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idmedicina->ViewValue = $this->idmedicina->CurrentValue; } } else { $this->idmedicina->ViewValue = NULL; } $this->idmedicina->ViewCustomAttributes = ""; } else { } // 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()); // cantidad $this->cantidad->EditAttrs["class"] = "form-control"; $this->cantidad->EditCustomAttributes = ""; $this->cantidad->EditValue = ew_HtmlEncode($this->cantidad->CurrentValue); $this->cantidad->PlaceHolder = ew_RemoveHtml($this->cantidad->FldCaption()); // precio_unitario $this->precio_unitario->EditAttrs["class"] = "form-control"; $this->precio_unitario->EditCustomAttributes = ""; $this->precio_unitario->EditValue = ew_HtmlEncode($this->precio_unitario->CurrentValue); $this->precio_unitario->PlaceHolder = ew_RemoveHtml($this->precio_unitario->FldCaption()); if (strval($this->precio_unitario->EditValue) != "" && is_numeric($this->precio_unitario->EditValue)) { $this->precio_unitario->EditValue = ew_FormatNumber($this->precio_unitario->EditValue, -2, -1, -2, 0); } // idturno $this->idturno->EditAttrs["class"] = "form-control"; $this->idturno->EditCustomAttributes = ""; if ($this->idturno->getSessionValue() != "") { $this->idturno->CurrentValue = $this->idturno->getSessionValue(); if (strval($this->idturno->CurrentValue) != "") { $sFilterWrk = "`idturno`" . ew_SearchString("=", $this->idturno->CurrentValue, EW_DATATYPE_NUMBER); $sSqlWrk = "SELECT `idturno`, `descripcion` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `turno`"; $sWhereWrk = ""; if ($sFilterWrk != "") { ew_AddFilter($sWhereWrk, $sFilterWrk); } // Call Lookup selecting $this->Lookup_Selecting($this->idturno, $sWhereWrk); if ($sWhereWrk != "") { $sSqlWrk .= " WHERE " . $sWhereWrk; } $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $this->idturno->ViewValue = $rswrk->fields('DispFld'); $rswrk->Close(); } else { $this->idturno->ViewValue = $this->idturno->CurrentValue; } } else { $this->idturno->ViewValue = NULL; } $this->idturno->ViewCustomAttributes = ""; } else { } // idcuenta $this->idcuenta->EditAttrs["class"] = "form-control"; $this->idcuenta->EditCustomAttributes = ""; $this->idcuenta->EditValue = ew_HtmlEncode($this->idcuenta->CurrentValue); $this->idcuenta->PlaceHolder = ew_RemoveHtml($this->idcuenta->FldCaption()); // Call Row Rendered event $this->Row_Rendered(); }