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
// usuario
// contrasenia
// nombre
// email
// cel
// activo
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// id
$this->id->ViewValue = $this->id->CurrentValue;
$this->id->ViewCustomAttributes = "";
// usuario
$this->usuario->ViewValue = $this->usuario->CurrentValue;
$this->usuario->ViewCustomAttributes = "";
// contrasenia
$this->contrasenia->ViewValue = "********";
$this->contrasenia->ViewCustomAttributes = "";
// nombre
$this->nombre->ViewValue = $this->nombre->CurrentValue;
$this->nombre->ViewCustomAttributes = "";
// email
$this->_email->ViewValue = $this->_email->CurrentValue;
$this->_email->ViewValue = strtolower($this->_email->ViewValue);
$this->_email->ViewCustomAttributes = "";
// cel
$this->cel->ViewValue = $this->cel->CurrentValue;
$this->cel->ViewValue = ew_FormatNumber($this->cel->ViewValue, 0, -2, -2, -2);
$this->cel->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 = "";
// id
$this->id->LinkCustomAttributes = "";
$this->id->HrefValue = "";
$this->id->TooltipValue = "";
// usuario
$this->usuario->LinkCustomAttributes = "";
$this->usuario->HrefValue = "";
$this->usuario->TooltipValue = "";
// contrasenia
$this->contrasenia->LinkCustomAttributes = "";
$this->contrasenia->HrefValue = "";
$this->contrasenia->TooltipValue = "";
// nombre
$this->nombre->LinkCustomAttributes = "";
$this->nombre->HrefValue = "";
$this->nombre->TooltipValue = "";
if ($this->Export == "") {
$this->nombre->ViewValue = ew_Highlight($this->HighlightName(), $this->nombre->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->nombre->AdvancedSearch->getValue("x"), "");
}
// email
$this->_email->LinkCustomAttributes = "";
$this->_email->HrefValue = "";
$this->_email->TooltipValue = "";
// cel
$this->cel->LinkCustomAttributes = "";
$this->cel->HrefValue = "";
$this->cel->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 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
// account_id
// image
// uname
// dtime
// pnumber
// message
// m_type
// M_url
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// id
$this->id->ViewValue = $this->id->CurrentValue;
$this->id->ViewCustomAttributes = "";
// image
$this->image->ViewValue = $this->image->CurrentValue;
$this->image->ImageWidth = 50;
$this->image->ImageHeight = 50;
$this->image->ImageAlt = $this->image->FldAlt();
$this->image->ViewCustomAttributes = "";
// uname
$this->uname->ViewValue = $this->uname->CurrentValue;
$this->uname->ViewCustomAttributes = "";
// pnumber
$this->pnumber->ViewValue = $this->pnumber->CurrentValue;
$this->pnumber->ViewCustomAttributes = "";
// message
$this->message->ViewValue = $this->message->CurrentValue;
$this->message->ViewCustomAttributes = "";
// id
$this->id->LinkCustomAttributes = "";
$this->id->HrefValue = "";
$this->id->TooltipValue = "";
// image
$this->image->LinkCustomAttributes = "";
if (!ew_Empty($this->image->CurrentValue)) {
$this->image->HrefValue = !empty($this->image->ViewValue) ? $this->image->ViewValue : $this->image->CurrentValue;
// Add prefix/suffix
$this->image->LinkAttrs["target"] = "";
// Add target
if ($this->Export != "") {
$this->image->HrefValue = ew_ConvertFullUrl($this->image->HrefValue);
}
} else {
$this->image->HrefValue = "";
}
if ($this->Export == "") {
$this->image->TooltipValue = $this->pnumber->ViewValue != "" ? $this->pnumber->ViewValue : $this->pnumber->CurrentValue;
$this->image->TooltipWidth = 50;
if ($this->image->HrefValue == "") {
$this->image->HrefValue = "javascript:void(0);";
}
$this->image->LinkAttrs["class"] = "ewTooltipLink";
$this->image->LinkAttrs["data-tooltip-id"] = "tt_messages_x" . $this->RowCnt . "_image";
$this->image->LinkAttrs["data-tooltip-width"] = $this->image->TooltipWidth;
$this->image->LinkAttrs["data-placement"] = EW_CSS_FLIP ? "left" : "right";
}
if ($this->Export == "") {
$this->image->ViewValue = ew_Highlight($this->HighlightName(), $this->image->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), "", "");
}
// uname
$this->uname->LinkCustomAttributes = "";
$this->uname->HrefValue = "";
$this->uname->TooltipValue = "";
if ($this->Export == "") {
$this->uname->ViewValue = ew_Highlight($this->HighlightName(), $this->uname->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), "", "");
}
// pnumber
$this->pnumber->LinkCustomAttributes = "";
$this->pnumber->HrefValue = "";
$this->pnumber->TooltipValue = "";
if ($this->Export == "") {
$this->pnumber->ViewValue = ew_Highlight($this->HighlightName(), $this->pnumber->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), "", "");
}
// message
$this->message->LinkCustomAttributes = "";
$this->message->HrefValue = "";
$this->message->TooltipValue = "";
if ($this->Export == "") {
$this->message->ViewValue = ew_Highlight($this->HighlightName(), $this->message->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), "", "");
}
}
// 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
// cuit_cuil
// id_actividad
$this->id_actividad->CellCssStyle = "white-space: nowrap;";
// propietario
// comercio
// direccion_comercio
// mail
// tel
// cel
// activo
// id_usuario
$this->id_usuario->CellCssStyle = "white-space: nowrap;";
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// socio_nro
$this->socio_nro->ViewValue = $this->socio_nro->CurrentValue;
$this->socio_nro->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 = "";
// 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 = "";
// 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 = "";
// 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 = "";
if ($this->Export == "") {
$this->socio_nro->ViewValue = ew_Highlight($this->HighlightName(), $this->socio_nro->ViewValue, "", "", $this->socio_nro->AdvancedSearch->getValue("x"), "");
}
// cuit_cuil
$this->cuit_cuil->LinkCustomAttributes = "";
$this->cuit_cuil->HrefValue = "";
$this->cuit_cuil->TooltipValue = "";
// propietario
$this->propietario->LinkCustomAttributes = "";
$this->propietario->HrefValue = "";
$this->propietario->TooltipValue = "";
if ($this->Export == "") {
$this->propietario->ViewValue = ew_Highlight($this->HighlightName(), $this->propietario->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->propietario->AdvancedSearch->getValue("x"), "");
}
// comercio
$this->comercio->LinkCustomAttributes = "";
$this->comercio->HrefValue = "";
$this->comercio->TooltipValue = "";
if ($this->Export == "") {
$this->comercio->ViewValue = ew_Highlight($this->HighlightName(), $this->comercio->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->comercio->AdvancedSearch->getValue("x"), "");
}
// direccion_comercio
$this->direccion_comercio->LinkCustomAttributes = "";
$this->direccion_comercio->HrefValue = "";
$this->direccion_comercio->TooltipValue = "";
if ($this->Export == "") {
$this->direccion_comercio->ViewValue = ew_Highlight($this->HighlightName(), $this->direccion_comercio->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->direccion_comercio->AdvancedSearch->getValue("x"), "");
}
// 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 = "";
// activo
$this->activo->LinkCustomAttributes = "";
$this->activo->HrefValue = "";
$this->activo->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->importe->FormValue == $this->importe->CurrentValue && is_numeric(ew_StrToFloat($this->importe->CurrentValue))) {
$this->importe->CurrentValue = ew_StrToFloat($this->importe->CurrentValue);
}
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// id
// descripcion
// importe
// fecha_creacion
// activa
// id_usuario
$this->id_usuario->CellCssStyle = "white-space: nowrap;";
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// id
$this->id->ViewValue = $this->id->CurrentValue;
$this->id->ViewCustomAttributes = "";
// descripcion
$this->descripcion->ViewValue = $this->descripcion->CurrentValue;
$this->descripcion->ViewCustomAttributes = "";
// importe
$this->importe->ViewValue = $this->importe->CurrentValue;
$this->importe->ViewValue = ew_FormatCurrency($this->importe->ViewValue, 0, -2, -2, -2);
$this->importe->ViewCustomAttributes = "";
// fecha_creacion
$this->fecha_creacion->ViewValue = $this->fecha_creacion->CurrentValue;
$this->fecha_creacion->ViewValue = ew_FormatDateTime($this->fecha_creacion->ViewValue, 7);
$this->fecha_creacion->ViewCustomAttributes = "";
// activa
if (strval($this->activa->CurrentValue) != "") {
switch ($this->activa->CurrentValue) {
case $this->activa->FldTagValue(1):
$this->activa->ViewValue = $this->activa->FldTagCaption(1) != "" ? $this->activa->FldTagCaption(1) : $this->activa->CurrentValue;
break;
case $this->activa->FldTagValue(2):
$this->activa->ViewValue = $this->activa->FldTagCaption(2) != "" ? $this->activa->FldTagCaption(2) : $this->activa->CurrentValue;
break;
default:
$this->activa->ViewValue = $this->activa->CurrentValue;
}
} else {
$this->activa->ViewValue = NULL;
}
$this->activa->ViewCustomAttributes = "";
// id_usuario
$this->id_usuario->ViewCustomAttributes = "";
// id
$this->id->LinkCustomAttributes = "";
$this->id->HrefValue = "";
$this->id->TooltipValue = "";
// descripcion
$this->descripcion->LinkCustomAttributes = "";
$this->descripcion->HrefValue = "";
$this->descripcion->TooltipValue = "";
if ($this->Export == "") {
$this->descripcion->ViewValue = ew_Highlight($this->HighlightName(), $this->descripcion->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->descripcion->AdvancedSearch->getValue("x"), "");
}
// importe
$this->importe->LinkCustomAttributes = "";
$this->importe->HrefValue = "";
$this->importe->TooltipValue = "";
// fecha_creacion
$this->fecha_creacion->LinkCustomAttributes = "";
$this->fecha_creacion->HrefValue = "";
$this->fecha_creacion->TooltipValue = "";
// activa
$this->activa->LinkCustomAttributes = "";
$this->activa->HrefValue = "";
$this->activa->TooltipValue = "";
// id_usuario
$this->id_usuario->LinkCustomAttributes = "";
$this->id_usuario->HrefValue = "";
$this->id_usuario->TooltipValue = "";
}
// Call Row Rendered event
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$this->Row_Rendered();
}
}
function RenderRow()
{
global $Security, $Language, $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
// expense_id
// user_id
// rider_id
// expense_date
// expense_month
// expense_cat
// expense_amount
// expense_detail
// Accumulate aggregate value
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT && $this->RowType != EW_ROWTYPE_AGGREGATE) {
if (is_numeric($this->expense_amount->CurrentValue)) {
$this->expense_amount->Total += $this->expense_amount->CurrentValue;
}
// Accumulate total
}
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// user_id
if (strval($this->user_id->CurrentValue) != "") {
$sFilterWrk = "`user_id`" . ew_SearchString("=", $this->user_id->CurrentValue, EW_DATATYPE_NUMBER, "");
$sSqlWrk = "SELECT `user_id`, `username` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `user`";
$sWhereWrk = "";
ew_AddFilter($sWhereWrk, $sFilterWrk);
$this->Lookup_Selecting($this->user_id, $sWhereWrk);
// Call Lookup selecting
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = Conn()->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$arwrk = array();
$arwrk[1] = $rswrk->fields('DispFld');
$this->user_id->ViewValue = $this->user_id->DisplayValue($arwrk);
$rswrk->Close();
} else {
$this->user_id->ViewValue = $this->user_id->CurrentValue;
}
} else {
$this->user_id->ViewValue = NULL;
}
$this->user_id->ViewCustomAttributes = "";
// rider_id
if (strval($this->rider_id->CurrentValue) != "") {
$sFilterWrk = "`rider_id`" . ew_SearchString("=", $this->rider_id->CurrentValue, EW_DATATYPE_NUMBER, "");
$sSqlWrk = "SELECT `rider_id`, `rider_name` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `rider`";
$sWhereWrk = "";
ew_AddFilter($sWhereWrk, $sFilterWrk);
$this->Lookup_Selecting($this->rider_id, $sWhereWrk);
// Call Lookup selecting
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = Conn()->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$arwrk = array();
$arwrk[1] = $rswrk->fields('DispFld');
$this->rider_id->ViewValue = $this->rider_id->DisplayValue($arwrk);
$rswrk->Close();
} else {
$this->rider_id->ViewValue = $this->rider_id->CurrentValue;
}
} else {
$this->rider_id->ViewValue = NULL;
}
$this->rider_id->ViewCustomAttributes = "";
// expense_date
$this->expense_date->ViewValue = $this->expense_date->CurrentValue;
$this->expense_date->ViewValue = ew_FormatDateTime($this->expense_date->ViewValue, 5);
$this->expense_date->ViewCustomAttributes = "";
// expense_month
if (strval($this->expense_month->CurrentValue) != "") {
$this->expense_month->ViewValue = $this->expense_month->OptionCaption($this->expense_month->CurrentValue);
} else {
$this->expense_month->ViewValue = NULL;
}
$this->expense_month->ViewCustomAttributes = "";
// expense_cat
if (strval($this->expense_cat->CurrentValue) != "") {
$this->expense_cat->ViewValue = $this->expense_cat->OptionCaption($this->expense_cat->CurrentValue);
} else {
$this->expense_cat->ViewValue = NULL;
}
$this->expense_cat->ViewCustomAttributes = "";
// expense_amount
$this->expense_amount->ViewValue = $this->expense_amount->CurrentValue;
$this->expense_amount->ViewCustomAttributes = "";
// expense_detail
$this->expense_detail->ViewValue = $this->expense_detail->CurrentValue;
$this->expense_detail->ViewCustomAttributes = "";
// user_id
$this->user_id->LinkCustomAttributes = "";
$this->user_id->HrefValue = "";
$this->user_id->TooltipValue = "";
// rider_id
$this->rider_id->LinkCustomAttributes = "";
$this->rider_id->HrefValue = "";
$this->rider_id->TooltipValue = "";
// expense_date
$this->expense_date->LinkCustomAttributes = "";
$this->expense_date->HrefValue = "";
$this->expense_date->TooltipValue = "";
// expense_month
$this->expense_month->LinkCustomAttributes = "";
$this->expense_month->HrefValue = "";
$this->expense_month->TooltipValue = "";
// expense_cat
$this->expense_cat->LinkCustomAttributes = "";
$this->expense_cat->HrefValue = "";
$this->expense_cat->TooltipValue = "";
// expense_amount
$this->expense_amount->LinkCustomAttributes = "";
$this->expense_amount->HrefValue = "";
$this->expense_amount->TooltipValue = "";
if ($this->Export == "") {
$this->expense_amount->ViewValue = ew_Highlight($this->HighlightName(), $this->expense_amount->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->expense_amount->AdvancedSearch->getValue("x"), "");
}
// expense_detail
$this->expense_detail->LinkCustomAttributes = "";
$this->expense_detail->HrefValue = "";
$this->expense_detail->TooltipValue = "";
if ($this->Export == "") {
$this->expense_detail->ViewValue = ew_Highlight($this->HighlightName(), $this->expense_detail->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->expense_detail->AdvancedSearch->getValue("x"), "");
}
} elseif ($this->RowType == EW_ROWTYPE_ADD) {
// Add row
// user_id
$this->user_id->EditAttrs["class"] = "form-control";
$this->user_id->EditCustomAttributes = "";
if (trim(strval($this->user_id->CurrentValue)) == "") {
$sFilterWrk = "0=1";
} else {
$sFilterWrk = "`user_id`" . ew_SearchString("=", $this->user_id->CurrentValue, EW_DATATYPE_NUMBER, "");
}
$sSqlWrk = "SELECT `user_id`, `username` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `user`";
$sWhereWrk = "";
ew_AddFilter($sWhereWrk, $sFilterWrk);
$this->Lookup_Selecting($this->user_id, $sWhereWrk);
// Call Lookup selecting
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->user_id->EditValue = $arwrk;
// rider_id
$this->rider_id->EditAttrs["class"] = "form-control";
$this->rider_id->EditCustomAttributes = "";
if (trim(strval($this->rider_id->CurrentValue)) == "") {
$sFilterWrk = "0=1";
} else {
$sFilterWrk = "`rider_id`" . ew_SearchString("=", $this->rider_id->CurrentValue, EW_DATATYPE_NUMBER, "");
}
$sSqlWrk = "SELECT `rider_id`, `rider_name` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `rider`";
$sWhereWrk = "";
ew_AddFilter($sWhereWrk, $sFilterWrk);
$this->Lookup_Selecting($this->rider_id, $sWhereWrk);
// Call Lookup selecting
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->rider_id->EditValue = $arwrk;
// expense_date
$this->expense_date->EditAttrs["class"] = "form-control";
$this->expense_date->EditCustomAttributes = "";
$this->expense_date->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->expense_date->CurrentValue, 5));
$this->expense_date->PlaceHolder = ew_RemoveHtml($this->expense_date->FldCaption());
// expense_month
$this->expense_month->EditAttrs["class"] = "form-control";
$this->expense_month->EditCustomAttributes = "";
$this->expense_month->EditValue = $this->expense_month->Options(TRUE);
// expense_cat
$this->expense_cat->EditAttrs["class"] = "form-control";
$this->expense_cat->EditCustomAttributes = "";
$this->expense_cat->EditValue = $this->expense_cat->Options(TRUE);
// expense_amount
$this->expense_amount->EditAttrs["class"] = "form-control";
$this->expense_amount->EditCustomAttributes = "";
$this->expense_amount->EditValue = ew_HtmlEncode($this->expense_amount->CurrentValue);
$this->expense_amount->PlaceHolder = ew_RemoveHtml($this->expense_amount->FldCaption());
// expense_detail
$this->expense_detail->EditAttrs["class"] = "form-control";
$this->expense_detail->EditCustomAttributes = "";
$this->expense_detail->EditValue = ew_HtmlEncode($this->expense_detail->CurrentValue);
$this->expense_detail->PlaceHolder = ew_RemoveHtml($this->expense_detail->FldCaption());
// Edit refer script
// user_id
$this->user_id->HrefValue = "";
// rider_id
$this->rider_id->HrefValue = "";
// expense_date
$this->expense_date->HrefValue = "";
// expense_month
$this->expense_month->HrefValue = "";
// expense_cat
$this->expense_cat->HrefValue = "";
// expense_amount
$this->expense_amount->HrefValue = "";
// expense_detail
$this->expense_detail->HrefValue = "";
} elseif ($this->RowType == EW_ROWTYPE_EDIT) {
// Edit row
// user_id
$this->user_id->EditAttrs["class"] = "form-control";
$this->user_id->EditCustomAttributes = "";
if (trim(strval($this->user_id->CurrentValue)) == "") {
$sFilterWrk = "0=1";
} else {
$sFilterWrk = "`user_id`" . ew_SearchString("=", $this->user_id->CurrentValue, EW_DATATYPE_NUMBER, "");
}
$sSqlWrk = "SELECT `user_id`, `username` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `user`";
$sWhereWrk = "";
ew_AddFilter($sWhereWrk, $sFilterWrk);
$this->Lookup_Selecting($this->user_id, $sWhereWrk);
// Call Lookup selecting
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->user_id->EditValue = $arwrk;
// rider_id
$this->rider_id->EditAttrs["class"] = "form-control";
$this->rider_id->EditCustomAttributes = "";
if (trim(strval($this->rider_id->CurrentValue)) == "") {
$sFilterWrk = "0=1";
} else {
$sFilterWrk = "`rider_id`" . ew_SearchString("=", $this->rider_id->CurrentValue, EW_DATATYPE_NUMBER, "");
}
$sSqlWrk = "SELECT `rider_id`, `rider_name` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `rider`";
$sWhereWrk = "";
ew_AddFilter($sWhereWrk, $sFilterWrk);
$this->Lookup_Selecting($this->rider_id, $sWhereWrk);
// Call Lookup selecting
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->rider_id->EditValue = $arwrk;
// expense_date
$this->expense_date->EditAttrs["class"] = "form-control";
$this->expense_date->EditCustomAttributes = "";
$this->expense_date->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->expense_date->CurrentValue, 5));
$this->expense_date->PlaceHolder = ew_RemoveHtml($this->expense_date->FldCaption());
// expense_month
$this->expense_month->EditAttrs["class"] = "form-control";
$this->expense_month->EditCustomAttributes = "";
$this->expense_month->EditValue = $this->expense_month->Options(TRUE);
// expense_cat
$this->expense_cat->EditAttrs["class"] = "form-control";
$this->expense_cat->EditCustomAttributes = "";
$this->expense_cat->EditValue = $this->expense_cat->Options(TRUE);
// expense_amount
$this->expense_amount->EditAttrs["class"] = "form-control";
$this->expense_amount->EditCustomAttributes = "";
$this->expense_amount->EditValue = ew_HtmlEncode($this->expense_amount->CurrentValue);
$this->expense_amount->PlaceHolder = ew_RemoveHtml($this->expense_amount->FldCaption());
// expense_detail
$this->expense_detail->EditAttrs["class"] = "form-control";
$this->expense_detail->EditCustomAttributes = "";
$this->expense_detail->EditValue = ew_HtmlEncode($this->expense_detail->CurrentValue);
$this->expense_detail->PlaceHolder = ew_RemoveHtml($this->expense_detail->FldCaption());
// Edit refer script
// user_id
$this->user_id->HrefValue = "";
// rider_id
$this->rider_id->HrefValue = "";
// expense_date
$this->expense_date->HrefValue = "";
// expense_month
$this->expense_month->HrefValue = "";
// expense_cat
$this->expense_cat->HrefValue = "";
// expense_amount
$this->expense_amount->HrefValue = "";
// expense_detail
$this->expense_detail->HrefValue = "";
} elseif ($this->RowType == EW_ROWTYPE_AGGREGATEINIT) {
// Initialize aggregate row
$this->expense_amount->Total = 0;
// Initialize total
} elseif ($this->RowType == EW_ROWTYPE_AGGREGATE) {
// Aggregate row
$this->expense_amount->CurrentValue = $this->expense_amount->Total;
$this->expense_amount->ViewValue = $this->expense_amount->CurrentValue;
$this->expense_amount->ViewCustomAttributes = "";
$this->expense_amount->HrefValue = "";
// Clear href value
}
if ($this->RowType == EW_ROWTYPE_ADD || $this->RowType == EW_ROWTYPE_EDIT || $this->RowType == EW_ROWTYPE_SEARCH) {
// Add / Edit / Search row
$this->SetupFieldTitles();
}
// Call Row Rendered event
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$this->Row_Rendered();
}
}
function RenderRow()
{
global $Security, $Language, $gsLanguage;
// Initialize URLs
$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
// mid
// rider_id
// package_id
// mcardnumber
// missuedate
// mexpirydate
// mname
// midcard
// mcellno
// maddress
// marea
// mnotes
// mamount
// Accumulate aggregate value
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT && $this->RowType != EW_ROWTYPE_AGGREGATE) {
if (is_numeric($this->mamount->CurrentValue)) {
$this->mamount->Total += $this->mamount->CurrentValue;
}
// Accumulate total
}
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// rider_id
if (strval($this->rider_id->CurrentValue) != "") {
$sFilterWrk = "`rider_id`" . ew_SearchString("=", $this->rider_id->CurrentValue, EW_DATATYPE_NUMBER, "");
$sSqlWrk = "SELECT `rider_id`, `rider_name` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `rider`";
$sWhereWrk = "";
ew_AddFilter($sWhereWrk, $sFilterWrk);
$this->Lookup_Selecting($this->rider_id, $sWhereWrk);
// Call Lookup selecting
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = Conn()->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$arwrk = array();
$arwrk[1] = $rswrk->fields('DispFld');
$this->rider_id->ViewValue = $this->rider_id->DisplayValue($arwrk);
$rswrk->Close();
} else {
$this->rider_id->ViewValue = $this->rider_id->CurrentValue;
}
} else {
$this->rider_id->ViewValue = NULL;
}
$this->rider_id->ViewCustomAttributes = "";
// package_id
if (strval($this->package_id->CurrentValue) != "") {
$sFilterWrk = "`package_id`" . ew_SearchString("=", $this->package_id->CurrentValue, EW_DATATYPE_NUMBER, "");
$sSqlWrk = "SELECT `package_id`, `package_name` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `package`";
$sWhereWrk = "";
ew_AddFilter($sWhereWrk, $sFilterWrk);
$this->Lookup_Selecting($this->package_id, $sWhereWrk);
// Call Lookup selecting
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = Conn()->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$arwrk = array();
$arwrk[1] = $rswrk->fields('DispFld');
$this->package_id->ViewValue = $this->package_id->DisplayValue($arwrk);
$rswrk->Close();
} else {
$this->package_id->ViewValue = $this->package_id->CurrentValue;
}
} else {
$this->package_id->ViewValue = NULL;
}
$this->package_id->ViewCustomAttributes = "";
// mcardnumber
$this->mcardnumber->ViewValue = $this->mcardnumber->CurrentValue;
$this->mcardnumber->ViewCustomAttributes = "";
// missuedate
$this->missuedate->ViewValue = $this->missuedate->CurrentValue;
$this->missuedate->ViewValue = ew_FormatDateTime($this->missuedate->ViewValue, 5);
$this->missuedate->ViewCustomAttributes = "";
// mexpirydate
$this->mexpirydate->ViewValue = $this->mexpirydate->CurrentValue;
$this->mexpirydate->ViewValue = ew_FormatDateTime($this->mexpirydate->ViewValue, 5);
$this->mexpirydate->ViewCustomAttributes = "";
// midcard
$this->midcard->ViewValue = $this->midcard->CurrentValue;
$this->midcard->ViewCustomAttributes = "";
// marea
if (strval($this->marea->CurrentValue) != "") {
$this->marea->ViewValue = $this->marea->OptionCaption($this->marea->CurrentValue);
} else {
$this->marea->ViewValue = NULL;
}
$this->marea->ViewCustomAttributes = "";
// mnotes
$this->mnotes->ViewValue = $this->mnotes->CurrentValue;
$this->mnotes->ViewCustomAttributes = "";
// mamount
$this->mamount->ViewValue = $this->mamount->CurrentValue;
$this->mamount->ViewCustomAttributes = "";
// rider_id
$this->rider_id->LinkCustomAttributes = "";
$this->rider_id->HrefValue = "";
$this->rider_id->TooltipValue = "";
// package_id
$this->package_id->LinkCustomAttributes = "";
$this->package_id->HrefValue = "";
$this->package_id->TooltipValue = "";
// mcardnumber
$this->mcardnumber->LinkCustomAttributes = "";
$this->mcardnumber->HrefValue = "";
$this->mcardnumber->TooltipValue = "";
if ($this->Export == "") {
$this->mcardnumber->ViewValue = ew_Highlight($this->HighlightName(), $this->mcardnumber->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->mcardnumber->AdvancedSearch->getValue("x"), "");
}
// missuedate
$this->missuedate->LinkCustomAttributes = "";
$this->missuedate->HrefValue = "";
$this->missuedate->TooltipValue = "";
// mexpirydate
$this->mexpirydate->LinkCustomAttributes = "";
$this->mexpirydate->HrefValue = "";
$this->mexpirydate->TooltipValue = "";
// midcard
$this->midcard->LinkCustomAttributes = "";
$this->midcard->HrefValue = "";
$this->midcard->TooltipValue = "";
if ($this->Export == "") {
$this->midcard->ViewValue = ew_Highlight($this->HighlightName(), $this->midcard->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->midcard->AdvancedSearch->getValue("x"), "");
}
// marea
$this->marea->LinkCustomAttributes = "";
$this->marea->HrefValue = "";
$this->marea->TooltipValue = "";
// mnotes
$this->mnotes->LinkCustomAttributes = "";
$this->mnotes->HrefValue = "";
$this->mnotes->TooltipValue = "";
if ($this->Export == "") {
$this->mnotes->ViewValue = ew_Highlight($this->HighlightName(), $this->mnotes->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->mnotes->AdvancedSearch->getValue("x"), "");
}
// mamount
$this->mamount->LinkCustomAttributes = "";
$this->mamount->HrefValue = "";
$this->mamount->TooltipValue = "";
if ($this->Export == "") {
$this->mamount->ViewValue = ew_Highlight($this->HighlightName(), $this->mamount->ViewValue, "", "", $this->mamount->AdvancedSearch->getValue("x"), "");
}
} elseif ($this->RowType == EW_ROWTYPE_AGGREGATEINIT) {
// Initialize aggregate row
$this->mamount->Total = 0;
// Initialize total
} elseif ($this->RowType == EW_ROWTYPE_AGGREGATE) {
// Aggregate row
$this->mamount->CurrentValue = $this->mamount->Total;
$this->mamount->ViewValue = $this->mamount->CurrentValue;
$this->mamount->ViewCustomAttributes = "";
$this->mamount->HrefValue = "";
// Clear href value
}
// Call Row Rendered event
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$this->Row_Rendered();
}
}
function RenderRow()
{
global $conn, $Security, $Language;
global $gsLanguage;
// Initialize URLs
$this->ViewUrl = $this->GetViewUrl();
$this->EditUrl = $this->GetEditUrl();
$this->InlineEditUrl = $this->GetInlineEditUrl();
$this->CopyUrl = $this->GetCopyUrl();
$this->InlineCopyUrl = $this->GetInlineCopyUrl();
$this->DeleteUrl = $this->GetDeleteUrl();
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// id
// id_rubro
// actividad
// descripcion
// activa
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// id
$this->id->ViewValue = $this->id->CurrentValue;
$this->id->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`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `rubros`";
$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_rubro, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$sSqlWrk .= " ORDER BY `rubro` DESC";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->id_rubro->ViewValue = $rswrk->fields('DispFld');
$rswrk->Close();
} else {
$this->id_rubro->ViewValue = $this->id_rubro->CurrentValue;
}
} else {
$this->id_rubro->ViewValue = NULL;
}
$this->id_rubro->ViewCustomAttributes = "";
// actividad
$this->actividad->ViewValue = $this->actividad->CurrentValue;
$this->actividad->ViewCustomAttributes = "";
// descripcion
$this->descripcion->ViewValue = $this->descripcion->CurrentValue;
$this->descripcion->ViewCustomAttributes = "";
// activa
if (strval($this->activa->CurrentValue) != "") {
switch ($this->activa->CurrentValue) {
case $this->activa->FldTagValue(1):
$this->activa->ViewValue = $this->activa->FldTagCaption(1) != "" ? $this->activa->FldTagCaption(1) : $this->activa->CurrentValue;
break;
case $this->activa->FldTagValue(2):
$this->activa->ViewValue = $this->activa->FldTagCaption(2) != "" ? $this->activa->FldTagCaption(2) : $this->activa->CurrentValue;
break;
default:
$this->activa->ViewValue = $this->activa->CurrentValue;
}
} else {
$this->activa->ViewValue = NULL;
}
$this->activa->ViewCustomAttributes = "";
// id
$this->id->LinkCustomAttributes = "";
$this->id->HrefValue = "";
$this->id->TooltipValue = "";
// id_rubro
$this->id_rubro->LinkCustomAttributes = "";
$this->id_rubro->HrefValue = "";
$this->id_rubro->TooltipValue = "";
// actividad
$this->actividad->LinkCustomAttributes = "";
$this->actividad->HrefValue = "";
$this->actividad->TooltipValue = "";
if ($this->Export == "") {
$this->actividad->ViewValue = ew_Highlight($this->HighlightName(), $this->actividad->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->actividad->AdvancedSearch->getValue("x"), "");
}
// descripcion
$this->descripcion->LinkCustomAttributes = "";
$this->descripcion->HrefValue = "";
$this->descripcion->TooltipValue = "";
if ($this->Export == "") {
$this->descripcion->ViewValue = ew_Highlight($this->HighlightName(), $this->descripcion->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->descripcion->AdvancedSearch->getValue("x"), "");
}
// activa
$this->activa->LinkCustomAttributes = "";
$this->activa->HrefValue = "";
$this->activa->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->importe->FormValue == $this->importe->CurrentValue && is_numeric(ew_StrToFloat($this->importe->CurrentValue))) {
$this->importe->CurrentValue = ew_StrToFloat($this->importe->CurrentValue);
}
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// id
// descripcion
// importe
// fecha_creacion
// activa
// id_usuario
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// id
$this->id->ViewValue = $this->id->CurrentValue;
$this->id->ViewCustomAttributes = "";
// descripcion
$this->descripcion->ViewValue = $this->descripcion->CurrentValue;
$this->descripcion->ViewCustomAttributes = "";
// importe
$this->importe->ViewValue = $this->importe->CurrentValue;
$this->importe->ViewCustomAttributes = "";
// fecha_creacion
$this->fecha_creacion->ViewValue = $this->fecha_creacion->CurrentValue;
$this->fecha_creacion->ViewValue = ew_FormatDateTime($this->fecha_creacion->ViewValue, 7);
$this->fecha_creacion->ViewCustomAttributes = "";
// activa
if (strval($this->activa->CurrentValue) != "") {
switch ($this->activa->CurrentValue) {
case $this->activa->FldTagValue(1):
$this->activa->ViewValue = $this->activa->FldTagCaption(1) != "" ? $this->activa->FldTagCaption(1) : $this->activa->CurrentValue;
break;
case $this->activa->FldTagValue(2):
$this->activa->ViewValue = $this->activa->FldTagCaption(2) != "" ? $this->activa->FldTagCaption(2) : $this->activa->CurrentValue;
break;
default:
$this->activa->ViewValue = $this->activa->CurrentValue;
}
} else {
$this->activa->ViewValue = NULL;
}
$this->activa->ViewCustomAttributes = "";
// id_usuario
$this->id_usuario->ViewValue = $this->id_usuario->CurrentValue;
$this->id_usuario->ViewCustomAttributes = "";
// id
$this->id->LinkCustomAttributes = "";
$this->id->HrefValue = "";
$this->id->TooltipValue = "";
// descripcion
$this->descripcion->LinkCustomAttributes = "";
$this->descripcion->HrefValue = "";
$this->descripcion->TooltipValue = "";
if ($this->Export == "") {
$this->descripcion->ViewValue = ew_Highlight($this->HighlightName(), $this->descripcion->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->descripcion->AdvancedSearch->getValue("x"), "");
}
// importe
$this->importe->LinkCustomAttributes = "";
$this->importe->HrefValue = "";
$this->importe->TooltipValue = "";
// fecha_creacion
$this->fecha_creacion->LinkCustomAttributes = "";
$this->fecha_creacion->HrefValue = "";
$this->fecha_creacion->TooltipValue = "";
// activa
$this->activa->LinkCustomAttributes = "";
$this->activa->HrefValue = "";
$this->activa->TooltipValue = "";
// id_usuario
$this->id_usuario->LinkCustomAttributes = "";
$this->id_usuario->HrefValue = "";
$this->id_usuario->TooltipValue = "";
} elseif ($this->RowType == EW_ROWTYPE_ADD) {
// Add row
// id
// descripcion
$this->descripcion->EditCustomAttributes = "";
$this->descripcion->EditValue = ew_HtmlEncode($this->descripcion->CurrentValue);
$this->descripcion->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->descripcion->FldCaption()));
// importe
$this->importe->EditCustomAttributes = "";
$this->importe->EditValue = ew_HtmlEncode($this->importe->CurrentValue);
$this->importe->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->importe->FldCaption()));
if (strval($this->importe->EditValue) != "" && is_numeric($this->importe->EditValue)) {
$this->importe->EditValue = ew_FormatNumber($this->importe->EditValue, -2, -1, -2, 0);
$this->importe->OldValue = $this->importe->EditValue;
}
// fecha_creacion
$this->fecha_creacion->EditCustomAttributes = "";
$this->fecha_creacion->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->fecha_creacion->CurrentValue, 7));
$this->fecha_creacion->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->fecha_creacion->FldCaption()));
// activa
$this->activa->EditCustomAttributes = "";
$arwrk = array();
$arwrk[] = array($this->activa->FldTagValue(1), $this->activa->FldTagCaption(1) != "" ? $this->activa->FldTagCaption(1) : $this->activa->FldTagValue(1));
$arwrk[] = array($this->activa->FldTagValue(2), $this->activa->FldTagCaption(2) != "" ? $this->activa->FldTagCaption(2) : $this->activa->FldTagValue(2));
$this->activa->EditValue = $arwrk;
// id_usuario
$this->id_usuario->EditCustomAttributes = "";
if ($this->id_usuario->getSessionValue() != "") {
$this->id_usuario->CurrentValue = $this->id_usuario->getSessionValue();
$this->id_usuario->OldValue = $this->id_usuario->CurrentValue;
$this->id_usuario->ViewValue = $this->id_usuario->CurrentValue;
$this->id_usuario->ViewCustomAttributes = "";
} else {
$this->id_usuario->EditValue = ew_HtmlEncode($this->id_usuario->CurrentValue);
$this->id_usuario->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->id_usuario->FldCaption()));
}
// Edit refer script
// id
$this->id->HrefValue = "";
// descripcion
$this->descripcion->HrefValue = "";
// importe
$this->importe->HrefValue = "";
// fecha_creacion
$this->fecha_creacion->HrefValue = "";
// activa
$this->activa->HrefValue = "";
// id_usuario
$this->id_usuario->HrefValue = "";
} elseif ($this->RowType == EW_ROWTYPE_EDIT) {
// Edit row
// id
$this->id->EditCustomAttributes = "";
$this->id->EditValue = $this->id->CurrentValue;
$this->id->ViewCustomAttributes = "";
// descripcion
$this->descripcion->EditCustomAttributes = "";
$this->descripcion->EditValue = ew_HtmlEncode($this->descripcion->CurrentValue);
$this->descripcion->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->descripcion->FldCaption()));
// importe
$this->importe->EditCustomAttributes = "";
$this->importe->EditValue = ew_HtmlEncode($this->importe->CurrentValue);
$this->importe->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->importe->FldCaption()));
if (strval($this->importe->EditValue) != "" && is_numeric($this->importe->EditValue)) {
$this->importe->EditValue = ew_FormatNumber($this->importe->EditValue, -2, -1, -2, 0);
$this->importe->OldValue = $this->importe->EditValue;
}
// fecha_creacion
$this->fecha_creacion->EditCustomAttributes = "";
$this->fecha_creacion->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->fecha_creacion->CurrentValue, 7));
$this->fecha_creacion->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->fecha_creacion->FldCaption()));
// activa
$this->activa->EditCustomAttributes = "";
$arwrk = array();
$arwrk[] = array($this->activa->FldTagValue(1), $this->activa->FldTagCaption(1) != "" ? $this->activa->FldTagCaption(1) : $this->activa->FldTagValue(1));
$arwrk[] = array($this->activa->FldTagValue(2), $this->activa->FldTagCaption(2) != "" ? $this->activa->FldTagCaption(2) : $this->activa->FldTagValue(2));
$this->activa->EditValue = $arwrk;
// id_usuario
$this->id_usuario->EditCustomAttributes = "";
if ($this->id_usuario->getSessionValue() != "") {
$this->id_usuario->CurrentValue = $this->id_usuario->getSessionValue();
$this->id_usuario->OldValue = $this->id_usuario->CurrentValue;
$this->id_usuario->ViewValue = $this->id_usuario->CurrentValue;
$this->id_usuario->ViewCustomAttributes = "";
} else {
$this->id_usuario->EditValue = ew_HtmlEncode($this->id_usuario->CurrentValue);
$this->id_usuario->PlaceHolder = ew_HtmlEncode(ew_RemoveHtml($this->id_usuario->FldCaption()));
}
// Edit refer script
// id
$this->id->HrefValue = "";
// descripcion
$this->descripcion->HrefValue = "";
// importe
$this->importe->HrefValue = "";
// fecha_creacion
$this->fecha_creacion->HrefValue = "";
// activa
$this->activa->HrefValue = "";
// id_usuario
$this->id_usuario->HrefValue = "";
}
if ($this->RowType == EW_ROWTYPE_ADD || $this->RowType == EW_ROWTYPE_EDIT || $this->RowType == EW_ROWTYPE_SEARCH) {
// Add / Edit / Search row
$this->SetupFieldTitles();
}
// Call Row Rendered event
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$this->Row_Rendered();
}
}
function RenderRow()
{
global $conn, $Security, $Language;
global $gsLanguage;
// Initialize URLs
$this->ViewUrl = $this->GetViewUrl();
$this->EditUrl = $this->GetEditUrl();
$this->InlineEditUrl = $this->GetInlineEditUrl();
$this->CopyUrl = $this->GetCopyUrl();
$this->InlineCopyUrl = $this->GetInlineCopyUrl();
$this->DeleteUrl = $this->GetDeleteUrl();
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// id
// rubro
// Descripcion
// activa
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// id
$this->id->ViewValue = $this->id->CurrentValue;
$this->id->ViewCustomAttributes = "";
// rubro
$this->rubro->ViewValue = $this->rubro->CurrentValue;
$this->rubro->ViewCustomAttributes = "";
// activa
if (strval($this->activa->CurrentValue) != "") {
switch ($this->activa->CurrentValue) {
case $this->activa->FldTagValue(1):
$this->activa->ViewValue = $this->activa->FldTagCaption(1) != "" ? $this->activa->FldTagCaption(1) : $this->activa->CurrentValue;
break;
case $this->activa->FldTagValue(2):
$this->activa->ViewValue = $this->activa->FldTagCaption(2) != "" ? $this->activa->FldTagCaption(2) : $this->activa->CurrentValue;
break;
default:
$this->activa->ViewValue = $this->activa->CurrentValue;
}
} else {
$this->activa->ViewValue = NULL;
}
$this->activa->ViewCustomAttributes = "";
// id
$this->id->LinkCustomAttributes = "";
$this->id->HrefValue = "";
$this->id->TooltipValue = "";
// rubro
$this->rubro->LinkCustomAttributes = "";
$this->rubro->HrefValue = "";
$this->rubro->TooltipValue = "";
if ($this->Export == "") {
$this->rubro->ViewValue = ew_Highlight($this->HighlightName(), $this->rubro->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->rubro->AdvancedSearch->getValue("x"), "");
}
// activa
$this->activa->LinkCustomAttributes = "";
$this->activa->HrefValue = "";
$this->activa->TooltipValue = "";
}
// Call Row Rendered event
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$this->Row_Rendered();
}
}
function RenderRow()
{
global $conn, $Security, $logs;
// Call Row Rendering event
$logs->Row_Rendering();
// Common render codes for all row types
// id
$logs->id->CellCssStyle = "";
$logs->id->CellCssClass = "";
// time
$logs->time->CellCssStyle = "";
$logs->time->CellCssClass = "";
// client
$logs->client->CellCssStyle = "";
$logs->client->CellCssClass = "";
// group
$logs->group->CellCssStyle = "";
$logs->group->CellCssClass = "";
// type
$logs->type->CellCssStyle = "";
$logs->type->CellCssClass = "";
// message
$logs->message->CellCssStyle = "";
$logs->message->CellCssClass = "";
if ($logs->RowType == EW_ROWTYPE_VIEW) {
// View row
// id
$logs->id->ViewValue = $logs->id->CurrentValue;
$logs->id->CssStyle = "";
$logs->id->CssClass = "";
$logs->id->ViewCustomAttributes = "";
// time
$logs->time->ViewValue = $logs->time->CurrentValue;
$logs->time->ViewValue = ew_FormatDateTime($logs->time->ViewValue, 9);
$logs->time->CssStyle = "";
$logs->time->CssClass = "";
$logs->time->ViewCustomAttributes = "";
// client
$logs->client->ViewValue = $logs->client->CurrentValue;
$logs->client->ViewValue = ew_Highlight($logs->client->ViewValue, $logs->getBasicSearchKeyword(), $logs->getBasicSearchType(), $logs->getAdvancedSearch("x_client"));
$logs->client->CssStyle = "";
$logs->client->CssClass = "";
$logs->client->ViewCustomAttributes = "";
// group
$logs->group->ViewValue = $logs->group->CurrentValue;
$logs->group->ViewValue = ew_Highlight($logs->group->ViewValue, $logs->getBasicSearchKeyword(), $logs->getBasicSearchType(), $logs->getAdvancedSearch("x_group"));
$logs->group->CssStyle = "";
$logs->group->CssClass = "";
$logs->group->ViewCustomAttributes = "";
// type
$logs->type->ViewValue = $logs->type->CurrentValue;
$logs->type->CssStyle = "";
$logs->type->CssClass = "";
$logs->type->ViewCustomAttributes = "";
// message
$logs->message->ViewValue = $logs->message->CurrentValue;
$logs->message->ViewValue = ew_Highlight($logs->message->ViewValue, $logs->getBasicSearchKeyword(), $logs->getBasicSearchType(), $logs->getAdvancedSearch("x_message"));
$logs->message->CssStyle = "";
$logs->message->CssClass = "";
$logs->message->ViewCustomAttributes = "";
// id
$logs->id->HrefValue = "";
// time
$logs->time->HrefValue = "";
// client
$logs->client->HrefValue = "";
// group
$logs->group->HrefValue = "";
// type
$logs->type->HrefValue = "";
// message
$logs->message->HrefValue = "";
} elseif ($logs->RowType == EW_ROWTYPE_ADD) {
// Add row
} elseif ($logs->RowType == EW_ROWTYPE_EDIT) {
// Edit row
// id
$logs->id->EditCustomAttributes = "";
$logs->id->EditValue = $logs->id->CurrentValue;
$logs->id->CssStyle = "";
$logs->id->CssClass = "";
$logs->id->ViewCustomAttributes = "";
// time
$logs->time->EditCustomAttributes = "";
$logs->time->EditValue = ew_FormatDateTime($logs->time->CurrentValue, 9);
// client
$logs->client->EditCustomAttributes = "";
$logs->client->EditValue = ew_HtmlEncode($logs->client->CurrentValue);
// group
$logs->group->EditCustomAttributes = "";
$logs->group->EditValue = ew_HtmlEncode($logs->group->CurrentValue);
// type
$logs->type->EditCustomAttributes = "";
$logs->type->EditValue = $logs->type->CurrentValue;
// message
$logs->message->EditCustomAttributes = "";
$logs->message->EditValue = ew_HtmlEncode($logs->message->CurrentValue);
} elseif ($logs->RowType == EW_ROWTYPE_SEARCH) {
// Search row
}
// Call Row Rendered event
$logs->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
// userlevelid
// tablename
// permission
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// userlevelid
if (strval($this->userlevelid->CurrentValue) != "") {
$sFilterWrk = "`userlevelid`" . ew_SearchString("=", $this->userlevelid->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `userlevelid`, `userlevelname` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `userlevels`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
// Call Lookup selecting
$this->Lookup_Selecting($this->userlevelid, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->userlevelid->ViewValue = $rswrk->fields('DispFld');
$rswrk->Close();
} else {
$this->userlevelid->ViewValue = $this->userlevelid->CurrentValue;
}
} else {
$this->userlevelid->ViewValue = NULL;
}
$this->userlevelid->ViewCustomAttributes = "";
// tablename
$this->_tablename->ViewValue = $this->_tablename->CurrentValue;
$this->_tablename->ViewCustomAttributes = "";
// permission
$this->permission->ViewValue = $this->permission->CurrentValue;
$this->permission->ViewCustomAttributes = "";
// userlevelid
$this->userlevelid->LinkCustomAttributes = "";
$this->userlevelid->HrefValue = "";
$this->userlevelid->TooltipValue = "";
// tablename
$this->_tablename->LinkCustomAttributes = "";
$this->_tablename->HrefValue = "";
$this->_tablename->TooltipValue = "";
if ($this->Export == "") {
$this->_tablename->ViewValue = ew_Highlight($this->HighlightName(), $this->_tablename->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->_tablename->AdvancedSearch->getValue("x"), "");
}
// permission
$this->permission->LinkCustomAttributes = "";
$this->permission->HrefValue = "";
$this->permission->TooltipValue = "";
if ($this->Export == "") {
$this->permission->ViewValue = ew_Highlight($this->HighlightName(), $this->permission->ViewValue, "", "", $this->permission->AdvancedSearch->getValue("x"), "");
}
}
// 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
// id
// id_rubro
// actividad
// descripcion
// activa
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// id
$this->id->ViewValue = $this->id->CurrentValue;
$this->id->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`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `rubros`";
$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_rubro, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$sSqlWrk .= " ORDER BY `rubro` DESC";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->id_rubro->ViewValue = $rswrk->fields('DispFld');
$rswrk->Close();
} else {
$this->id_rubro->ViewValue = $this->id_rubro->CurrentValue;
}
} else {
$this->id_rubro->ViewValue = NULL;
}
$this->id_rubro->ViewCustomAttributes = "";
// actividad
$this->actividad->ViewValue = $this->actividad->CurrentValue;
$this->actividad->ViewCustomAttributes = "";
// descripcion
$this->descripcion->ViewValue = $this->descripcion->CurrentValue;
$this->descripcion->ViewCustomAttributes = "";
// activa
if (strval($this->activa->CurrentValue) != "") {
switch ($this->activa->CurrentValue) {
case $this->activa->FldTagValue(1):
$this->activa->ViewValue = $this->activa->FldTagCaption(1) != "" ? $this->activa->FldTagCaption(1) : $this->activa->CurrentValue;
break;
case $this->activa->FldTagValue(2):
$this->activa->ViewValue = $this->activa->FldTagCaption(2) != "" ? $this->activa->FldTagCaption(2) : $this->activa->CurrentValue;
break;
default:
$this->activa->ViewValue = $this->activa->CurrentValue;
}
} else {
$this->activa->ViewValue = NULL;
}
$this->activa->ViewCustomAttributes = "";
// id
$this->id->LinkCustomAttributes = "";
$this->id->HrefValue = "";
$this->id->TooltipValue = "";
// id_rubro
$this->id_rubro->LinkCustomAttributes = "";
$this->id_rubro->HrefValue = "";
$this->id_rubro->TooltipValue = "";
// actividad
$this->actividad->LinkCustomAttributes = "";
$this->actividad->HrefValue = "";
$this->actividad->TooltipValue = "";
if ($this->Export == "") {
$this->actividad->ViewValue = ew_Highlight($this->HighlightName(), $this->actividad->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->actividad->AdvancedSearch->getValue("x"), "");
}
// descripcion
$this->descripcion->LinkCustomAttributes = "";
$this->descripcion->HrefValue = "";
$this->descripcion->TooltipValue = "";
if ($this->Export == "") {
$this->descripcion->ViewValue = ew_Highlight($this->HighlightName(), $this->descripcion->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->descripcion->AdvancedSearch->getValue("x"), "");
}
// activa
$this->activa->LinkCustomAttributes = "";
$this->activa->HrefValue = "";
$this->activa->TooltipValue = "";
} elseif ($this->RowType == EW_ROWTYPE_ADD) {
// Add row
// id
// id_rubro
$this->id_rubro->EditAttrs["class"] = "form-control";
$this->id_rubro->EditCustomAttributes = "";
if ($this->id_rubro->getSessionValue() != "") {
$this->id_rubro->CurrentValue = $this->id_rubro->getSessionValue();
$this->id_rubro->OldValue = $this->id_rubro->CurrentValue;
if (strval($this->id_rubro->CurrentValue) != "") {
$sFilterWrk = "`id`" . ew_SearchString("=", $this->id_rubro->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `id`, `rubro` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `rubros`";
$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_rubro, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$sSqlWrk .= " ORDER BY `rubro` DESC";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->id_rubro->ViewValue = $rswrk->fields('DispFld');
$rswrk->Close();
} else {
$this->id_rubro->ViewValue = $this->id_rubro->CurrentValue;
}
} else {
$this->id_rubro->ViewValue = NULL;
}
$this->id_rubro->ViewCustomAttributes = "";
} else {
if (trim(strval($this->id_rubro->CurrentValue)) == "") {
$sFilterWrk = "0=1";
} else {
$sFilterWrk = "`id`" . ew_SearchString("=", $this->id_rubro->CurrentValue, EW_DATATYPE_NUMBER);
}
$sSqlWrk = "SELECT `id`, `rubro` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `rubros`";
$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_rubro, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$sSqlWrk .= " ORDER BY `rubro` DESC";
$rswrk = $conn->Execute($sSqlWrk);
$arwrk = $rswrk ? $rswrk->GetRows() : array();
if ($rswrk) {
$rswrk->Close();
}
array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"), "", "", "", "", "", "", ""));
$this->id_rubro->EditValue = $arwrk;
}
// actividad
$this->actividad->EditAttrs["class"] = "form-control";
$this->actividad->EditCustomAttributes = "";
$this->actividad->EditValue = ew_HtmlEncode($this->actividad->CurrentValue);
$this->actividad->PlaceHolder = ew_RemoveHtml($this->actividad->FldCaption());
// descripcion
$this->descripcion->EditAttrs["class"] = "form-control";
$this->descripcion->EditCustomAttributes = "";
$this->descripcion->EditValue = ew_HtmlEncode($this->descripcion->CurrentValue);
$this->descripcion->PlaceHolder = ew_RemoveHtml($this->descripcion->FldCaption());
// activa
$this->activa->EditCustomAttributes = "";
$arwrk = array();
$arwrk[] = array($this->activa->FldTagValue(1), $this->activa->FldTagCaption(1) != "" ? $this->activa->FldTagCaption(1) : $this->activa->FldTagValue(1));
$arwrk[] = array($this->activa->FldTagValue(2), $this->activa->FldTagCaption(2) != "" ? $this->activa->FldTagCaption(2) : $this->activa->FldTagValue(2));
$this->activa->EditValue = $arwrk;
// Edit refer script
// id
$this->id->HrefValue = "";
// id_rubro
$this->id_rubro->HrefValue = "";
// actividad
$this->actividad->HrefValue = "";
// descripcion
$this->descripcion->HrefValue = "";
// activa
$this->activa->HrefValue = "";
} elseif ($this->RowType == EW_ROWTYPE_EDIT) {
// Edit row
// id
$this->id->EditAttrs["class"] = "form-control";
$this->id->EditCustomAttributes = "";
$this->id->EditValue = $this->id->CurrentValue;
$this->id->ViewCustomAttributes = "";
// id_rubro
$this->id_rubro->EditAttrs["class"] = "form-control";
$this->id_rubro->EditCustomAttributes = "";
if ($this->id_rubro->getSessionValue() != "") {
$this->id_rubro->CurrentValue = $this->id_rubro->getSessionValue();
$this->id_rubro->OldValue = $this->id_rubro->CurrentValue;
if (strval($this->id_rubro->CurrentValue) != "") {
$sFilterWrk = "`id`" . ew_SearchString("=", $this->id_rubro->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `id`, `rubro` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `rubros`";
$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_rubro, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$sSqlWrk .= " ORDER BY `rubro` DESC";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->id_rubro->ViewValue = $rswrk->fields('DispFld');
$rswrk->Close();
} else {
$this->id_rubro->ViewValue = $this->id_rubro->CurrentValue;
}
} else {
$this->id_rubro->ViewValue = NULL;
}
$this->id_rubro->ViewCustomAttributes = "";
} else {
if (trim(strval($this->id_rubro->CurrentValue)) == "") {
$sFilterWrk = "0=1";
} else {
$sFilterWrk = "`id`" . ew_SearchString("=", $this->id_rubro->CurrentValue, EW_DATATYPE_NUMBER);
}
$sSqlWrk = "SELECT `id`, `rubro` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `rubros`";
$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_rubro, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$sSqlWrk .= " ORDER BY `rubro` DESC";
$rswrk = $conn->Execute($sSqlWrk);
$arwrk = $rswrk ? $rswrk->GetRows() : array();
if ($rswrk) {
$rswrk->Close();
}
array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"), "", "", "", "", "", "", ""));
$this->id_rubro->EditValue = $arwrk;
}
// actividad
$this->actividad->EditAttrs["class"] = "form-control";
$this->actividad->EditCustomAttributes = "";
$this->actividad->EditValue = ew_HtmlEncode($this->actividad->CurrentValue);
$this->actividad->PlaceHolder = ew_RemoveHtml($this->actividad->FldCaption());
// descripcion
$this->descripcion->EditAttrs["class"] = "form-control";
$this->descripcion->EditCustomAttributes = "";
$this->descripcion->EditValue = ew_HtmlEncode($this->descripcion->CurrentValue);
$this->descripcion->PlaceHolder = ew_RemoveHtml($this->descripcion->FldCaption());
// activa
$this->activa->EditCustomAttributes = "";
$arwrk = array();
$arwrk[] = array($this->activa->FldTagValue(1), $this->activa->FldTagCaption(1) != "" ? $this->activa->FldTagCaption(1) : $this->activa->FldTagValue(1));
$arwrk[] = array($this->activa->FldTagValue(2), $this->activa->FldTagCaption(2) != "" ? $this->activa->FldTagCaption(2) : $this->activa->FldTagValue(2));
$this->activa->EditValue = $arwrk;
// Edit refer script
// id
$this->id->HrefValue = "";
// id_rubro
$this->id_rubro->HrefValue = "";
// actividad
$this->actividad->HrefValue = "";
// descripcion
$this->descripcion->HrefValue = "";
// activa
$this->activa->HrefValue = "";
}
if ($this->RowType == EW_ROWTYPE_ADD || $this->RowType == EW_ROWTYPE_EDIT || $this->RowType == EW_ROWTYPE_SEARCH) {
// Add / Edit / Search row
$this->SetupFieldTitles();
}
// Call Row Rendered event
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$this->Row_Rendered();
}
}
function RenderRow()
{
global $conn, $Security, $Language, $tbl_user;
// Initialize URLs
$this->ViewUrl = $tbl_user->ViewUrl();
$this->EditUrl = $tbl_user->EditUrl();
$this->InlineEditUrl = $tbl_user->InlineEditUrl();
$this->CopyUrl = $tbl_user->CopyUrl();
$this->InlineCopyUrl = $tbl_user->InlineCopyUrl();
$this->DeleteUrl = $tbl_user->DeleteUrl();
// Call Row_Rendering event
$tbl_user->Row_Rendering();
// Common render codes for all row types
// id_user
$tbl_user->id_user->CellCssStyle = "";
$tbl_user->id_user->CellCssClass = "";
$tbl_user->id_user->CellAttrs = array();
$tbl_user->id_user->ViewAttrs = array();
$tbl_user->id_user->EditAttrs = array();
// username
$tbl_user->username->CellCssStyle = "";
$tbl_user->username->CellCssClass = "";
$tbl_user->username->CellAttrs = array();
$tbl_user->username->ViewAttrs = array();
$tbl_user->username->EditAttrs = array();
// passwd
$tbl_user->passwd->CellCssStyle = "";
$tbl_user->passwd->CellCssClass = "";
$tbl_user->passwd->CellAttrs = array();
$tbl_user->passwd->ViewAttrs = array();
$tbl_user->passwd->EditAttrs = array();
// id_userlevel
$tbl_user->id_userlevel->CellCssStyle = "";
$tbl_user->id_userlevel->CellCssClass = "";
$tbl_user->id_userlevel->CellAttrs = array();
$tbl_user->id_userlevel->ViewAttrs = array();
$tbl_user->id_userlevel->EditAttrs = array();
if ($tbl_user->RowType == EW_ROWTYPE_VIEW) {
// View row
// id_user
$tbl_user->id_user->ViewValue = $tbl_user->id_user->CurrentValue;
$tbl_user->id_user->CssStyle = "";
$tbl_user->id_user->CssClass = "";
$tbl_user->id_user->ViewCustomAttributes = "";
// username
$tbl_user->username->ViewValue = $tbl_user->username->CurrentValue;
$tbl_user->username->CssStyle = "";
$tbl_user->username->CssClass = "";
$tbl_user->username->ViewCustomAttributes = "";
// passwd
$tbl_user->passwd->ViewValue = $tbl_user->passwd->CurrentValue;
$tbl_user->passwd->CssStyle = "";
$tbl_user->passwd->CssClass = "";
$tbl_user->passwd->ViewCustomAttributes = "";
// id_userlevel
if ($Security->CanAdmin()) {
// System admin
if (strval($tbl_user->id_userlevel->CurrentValue) != "") {
$sFilterWrk = "`userlevelid` = " . ew_AdjustSql($tbl_user->id_userlevel->CurrentValue) . "";
$sSqlWrk = "SELECT `userlevelname` FROM `tbl_user_level`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
if ($sWhereWrk != "") {
$sWhereWrk .= " AND ";
}
$sWhereWrk .= "(" . $sFilterWrk . ")";
}
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$tbl_user->id_userlevel->ViewValue = $rswrk->fields('userlevelname');
$rswrk->Close();
} else {
$tbl_user->id_userlevel->ViewValue = $tbl_user->id_userlevel->CurrentValue;
}
} else {
$tbl_user->id_userlevel->ViewValue = NULL;
}
} else {
$tbl_user->id_userlevel->ViewValue = "********";
}
$tbl_user->id_userlevel->CssStyle = "";
$tbl_user->id_userlevel->CssClass = "";
$tbl_user->id_userlevel->ViewCustomAttributes = "";
// id_user
$tbl_user->id_user->HrefValue = "";
$tbl_user->id_user->TooltipValue = "";
// username
$tbl_user->username->HrefValue = "";
$tbl_user->username->TooltipValue = "";
if ($tbl_user->Export == "") {
$tbl_user->username->ViewValue = ew_Highlight($tbl_user->HighlightName(), $tbl_user->username->ViewValue, $tbl_user->getSessionBasicSearchKeyword(), $tbl_user->getSessionBasicSearchType(), $tbl_user->getAdvancedSearch("x_username"));
}
// passwd
$tbl_user->passwd->HrefValue = "";
$tbl_user->passwd->TooltipValue = "";
if ($tbl_user->Export == "") {
$tbl_user->passwd->ViewValue = ew_Highlight($tbl_user->HighlightName(), $tbl_user->passwd->ViewValue, $tbl_user->getSessionBasicSearchKeyword(), $tbl_user->getSessionBasicSearchType(), $tbl_user->getAdvancedSearch("x_passwd"));
}
// id_userlevel
$tbl_user->id_userlevel->HrefValue = "";
$tbl_user->id_userlevel->TooltipValue = "";
} elseif ($tbl_user->RowType == EW_ROWTYPE_ADD) {
// Add row
// id_user
// username
$tbl_user->username->EditCustomAttributes = "";
$tbl_user->username->EditValue = ew_HtmlEncode($tbl_user->username->CurrentValue);
// passwd
$tbl_user->passwd->EditCustomAttributes = "";
$tbl_user->passwd->EditValue = ew_HtmlEncode($tbl_user->passwd->CurrentValue);
// id_userlevel
$tbl_user->id_userlevel->EditCustomAttributes = "";
if (!$Security->CanAdmin()) {
// System admin
$tbl_user->id_userlevel->EditValue = "********";
} else {
$sFilterWrk = "";
$sSqlWrk = "SELECT `userlevelid`, `userlevelname`, '' AS Disp2Fld, '' AS SelectFilterFld FROM `tbl_user_level`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
if ($sWhereWrk != "") {
$sWhereWrk .= " AND ";
}
$sWhereWrk .= "(" . $sFilterWrk . ")";
}
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
$arwrk = $rswrk ? $rswrk->GetRows() : array();
if ($rswrk) {
$rswrk->Close();
}
array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect")));
$tbl_user->id_userlevel->EditValue = $arwrk;
}
} elseif ($tbl_user->RowType == EW_ROWTYPE_EDIT) {
// Edit row
// id_user
$tbl_user->id_user->EditCustomAttributes = "";
$tbl_user->id_user->EditValue = $tbl_user->id_user->CurrentValue;
$tbl_user->id_user->CssStyle = "";
$tbl_user->id_user->CssClass = "";
$tbl_user->id_user->ViewCustomAttributes = "";
// username
$tbl_user->username->EditCustomAttributes = "";
$tbl_user->username->EditValue = ew_HtmlEncode($tbl_user->username->CurrentValue);
// passwd
$tbl_user->passwd->EditCustomAttributes = "";
$tbl_user->passwd->EditValue = ew_HtmlEncode($tbl_user->passwd->CurrentValue);
// id_userlevel
$tbl_user->id_userlevel->EditCustomAttributes = "";
if (!$Security->CanAdmin()) {
// System admin
$tbl_user->id_userlevel->EditValue = "********";
} else {
$sFilterWrk = "";
$sSqlWrk = "SELECT `userlevelid`, `userlevelname`, '' AS Disp2Fld, '' AS SelectFilterFld FROM `tbl_user_level`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
if ($sWhereWrk != "") {
$sWhereWrk .= " AND ";
}
$sWhereWrk .= "(" . $sFilterWrk . ")";
}
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
$arwrk = $rswrk ? $rswrk->GetRows() : array();
if ($rswrk) {
$rswrk->Close();
}
array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect")));
$tbl_user->id_userlevel->EditValue = $arwrk;
}
// Edit refer script
// id_user
$tbl_user->id_user->HrefValue = "";
// username
$tbl_user->username->HrefValue = "";
// passwd
$tbl_user->passwd->HrefValue = "";
// id_userlevel
$tbl_user->id_userlevel->HrefValue = "";
}
// Call Row Rendered event
if ($tbl_user->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$tbl_user->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
// time
// realm
// type
// level
// string
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// time
$this->time->ViewValue = $this->time->CurrentValue;
$this->time->ViewCustomAttributes = "";
// realm
if (strval($this->realm->CurrentValue) != "") {
$sFilterWrk = "`id`" . ew_SearchString("=", $this->realm->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->realm->ViewValue = $rswrk->fields('DispFld');
$this->realm->ViewValue .= ew_ValueSeparator(1, $this->realm) . $rswrk->fields('Disp2Fld');
$rswrk->Close();
} else {
$this->realm->ViewValue = $this->realm->CurrentValue;
}
} else {
$this->realm->ViewValue = NULL;
}
$this->realm->ViewCustomAttributes = "";
// type
if (strval($this->type->CurrentValue) != "") {
switch ($this->type->CurrentValue) {
case $this->type->FldTagValue(1):
$this->type->ViewValue = $this->type->FldTagCaption(1) != "" ? $this->type->FldTagCaption(1) : $this->type->CurrentValue;
break;
default:
$this->type->ViewValue = $this->type->CurrentValue;
}
} else {
$this->type->ViewValue = NULL;
}
$this->type->ViewCustomAttributes = "";
// string
$this->string->ViewValue = $this->string->CurrentValue;
$this->string->ViewCustomAttributes = "";
// time
$this->time->LinkCustomAttributes = "";
$this->time->HrefValue = "";
$this->time->TooltipValue = "";
// realm
$this->realm->LinkCustomAttributes = "";
$this->realm->HrefValue = "";
$this->realm->TooltipValue = "";
// type
$this->type->LinkCustomAttributes = "";
$this->type->HrefValue = "";
$this->type->TooltipValue = "";
// string
$this->string->LinkCustomAttributes = "";
$this->string->HrefValue = "";
$this->string->TooltipValue = "";
if ($this->Export == "") {
$this->string->ViewValue = ew_Highlight($this->HighlightName(), $this->string->ViewValue, "", "", $this->string->AdvancedSearch->getValue("x"));
}
}
// Call Row Rendered event
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$this->Row_Rendered();
}
}
function RenderRow()
{
global $conn, $Security, $Language, $tbl_profile;
// Initialize URLs
$this->ViewUrl = $tbl_profile->ViewUrl();
$this->EditUrl = $tbl_profile->EditUrl();
$this->InlineEditUrl = $tbl_profile->InlineEditUrl();
$this->CopyUrl = $tbl_profile->CopyUrl();
$this->InlineCopyUrl = $tbl_profile->InlineCopyUrl();
$this->DeleteUrl = $tbl_profile->DeleteUrl();
// Call Row_Rendering event
$tbl_profile->Row_Rendering();
// Common render codes for all row types
// id
$tbl_profile->id->CellCssStyle = "";
$tbl_profile->id->CellCssClass = "";
$tbl_profile->id->CellAttrs = array();
$tbl_profile->id->ViewAttrs = array();
$tbl_profile->id->EditAttrs = array();
// name
$tbl_profile->name->CellCssStyle = "white-space: nowrap;";
$tbl_profile->name->CellCssClass = "";
$tbl_profile->name->CellAttrs = array();
$tbl_profile->name->ViewAttrs = array();
$tbl_profile->name->EditAttrs = array();
// ga_username
$tbl_profile->ga_username->CellCssStyle = "";
$tbl_profile->ga_username->CellCssClass = "";
$tbl_profile->ga_username->CellAttrs = array();
$tbl_profile->ga_username->ViewAttrs = array();
$tbl_profile->ga_username->EditAttrs = array();
// ga_passwd
$tbl_profile->ga_passwd->CellCssStyle = "";
$tbl_profile->ga_passwd->CellCssClass = "";
$tbl_profile->ga_passwd->CellAttrs = array();
$tbl_profile->ga_passwd->ViewAttrs = array();
$tbl_profile->ga_passwd->EditAttrs = array();
// ga_profileid
$tbl_profile->ga_profileid->CellCssStyle = "";
$tbl_profile->ga_profileid->CellCssClass = "";
$tbl_profile->ga_profileid->CellAttrs = array();
$tbl_profile->ga_profileid->ViewAttrs = array();
$tbl_profile->ga_profileid->EditAttrs = array();
// url
$tbl_profile->url->CellCssStyle = "white-space: nowrap;";
$tbl_profile->url->CellCssClass = "";
$tbl_profile->url->CellAttrs = array();
$tbl_profile->url->ViewAttrs = array();
$tbl_profile->url->EditAttrs = array();
// fb_pageid
$tbl_profile->fb_pageid->CellCssStyle = "";
$tbl_profile->fb_pageid->CellCssClass = "";
$tbl_profile->fb_pageid->CellAttrs = array();
$tbl_profile->fb_pageid->ViewAttrs = array();
$tbl_profile->fb_pageid->EditAttrs = array();
// twitter_page
$tbl_profile->twitter_page->CellCssStyle = "";
$tbl_profile->twitter_page->CellCssClass = "";
$tbl_profile->twitter_page->CellAttrs = array();
$tbl_profile->twitter_page->ViewAttrs = array();
$tbl_profile->twitter_page->EditAttrs = array();
// is_wordpress
$tbl_profile->is_wordpress->CellCssStyle = "";
$tbl_profile->is_wordpress->CellCssClass = "";
$tbl_profile->is_wordpress->CellAttrs = array();
$tbl_profile->is_wordpress->ViewAttrs = array();
$tbl_profile->is_wordpress->EditAttrs = array();
// is_blogger
$tbl_profile->is_blogger->CellCssStyle = "";
$tbl_profile->is_blogger->CellCssClass = "";
$tbl_profile->is_blogger->CellAttrs = array();
$tbl_profile->is_blogger->ViewAttrs = array();
$tbl_profile->is_blogger->EditAttrs = array();
// is_active
$tbl_profile->is_active->CellCssStyle = "";
$tbl_profile->is_active->CellCssClass = "";
$tbl_profile->is_active->CellAttrs = array();
$tbl_profile->is_active->ViewAttrs = array();
$tbl_profile->is_active->EditAttrs = array();
if ($tbl_profile->RowType == EW_ROWTYPE_VIEW) {
// View row
// id
$tbl_profile->id->ViewValue = $tbl_profile->id->CurrentValue;
$tbl_profile->id->CssStyle = "";
$tbl_profile->id->CssClass = "";
$tbl_profile->id->ViewCustomAttributes = "";
// name
$tbl_profile->name->ViewValue = $tbl_profile->name->CurrentValue;
$tbl_profile->name->CssStyle = "";
$tbl_profile->name->CssClass = "";
$tbl_profile->name->ViewCustomAttributes = "";
// ga_username
$tbl_profile->ga_username->ViewValue = $tbl_profile->ga_username->CurrentValue;
$tbl_profile->ga_username->CssStyle = "";
$tbl_profile->ga_username->CssClass = "";
$tbl_profile->ga_username->ViewCustomAttributes = "";
// ga_passwd
$tbl_profile->ga_passwd->ViewValue = $tbl_profile->ga_passwd->CurrentValue;
$tbl_profile->ga_passwd->CssStyle = "";
$tbl_profile->ga_passwd->CssClass = "";
$tbl_profile->ga_passwd->ViewCustomAttributes = "";
// ga_profileid
$tbl_profile->ga_profileid->ViewValue = $tbl_profile->ga_profileid->CurrentValue;
$tbl_profile->ga_profileid->CssStyle = "";
$tbl_profile->ga_profileid->CssClass = "";
$tbl_profile->ga_profileid->ViewCustomAttributes = "";
// url
$tbl_profile->url->ViewValue = $tbl_profile->url->CurrentValue;
$tbl_profile->url->CssStyle = "";
$tbl_profile->url->CssClass = "";
$tbl_profile->url->ViewCustomAttributes = "";
// fb_pageid
$tbl_profile->fb_pageid->ViewValue = $tbl_profile->fb_pageid->CurrentValue;
$tbl_profile->fb_pageid->CssStyle = "";
$tbl_profile->fb_pageid->CssClass = "";
$tbl_profile->fb_pageid->ViewCustomAttributes = "";
// twitter_page
$tbl_profile->twitter_page->ViewValue = $tbl_profile->twitter_page->CurrentValue;
$tbl_profile->twitter_page->CssStyle = "";
$tbl_profile->twitter_page->CssClass = "";
$tbl_profile->twitter_page->ViewCustomAttributes = "";
// is_wordpress
if (strval($tbl_profile->is_wordpress->CurrentValue) != "") {
switch ($tbl_profile->is_wordpress->CurrentValue) {
case "0":
$tbl_profile->is_wordpress->ViewValue = "No";
break;
case "1":
$tbl_profile->is_wordpress->ViewValue = "Yes";
break;
default:
$tbl_profile->is_wordpress->ViewValue = $tbl_profile->is_wordpress->CurrentValue;
}
} else {
$tbl_profile->is_wordpress->ViewValue = NULL;
}
$tbl_profile->is_wordpress->CssStyle = "";
$tbl_profile->is_wordpress->CssClass = "";
$tbl_profile->is_wordpress->ViewCustomAttributes = "";
// is_blogger
if (strval($tbl_profile->is_blogger->CurrentValue) != "") {
switch ($tbl_profile->is_blogger->CurrentValue) {
case "0":
$tbl_profile->is_blogger->ViewValue = "No";
break;
case "1":
$tbl_profile->is_blogger->ViewValue = "Yes";
break;
default:
$tbl_profile->is_blogger->ViewValue = $tbl_profile->is_blogger->CurrentValue;
}
} else {
$tbl_profile->is_blogger->ViewValue = NULL;
}
$tbl_profile->is_blogger->CssStyle = "";
$tbl_profile->is_blogger->CssClass = "";
$tbl_profile->is_blogger->ViewCustomAttributes = "";
// is_active
if (strval($tbl_profile->is_active->CurrentValue) != "") {
switch ($tbl_profile->is_active->CurrentValue) {
case "0":
$tbl_profile->is_active->ViewValue = "No";
break;
case "1":
$tbl_profile->is_active->ViewValue = "Yes";
break;
default:
$tbl_profile->is_active->ViewValue = $tbl_profile->is_active->CurrentValue;
}
} else {
$tbl_profile->is_active->ViewValue = NULL;
}
$tbl_profile->is_active->CssStyle = "";
$tbl_profile->is_active->CssClass = "";
$tbl_profile->is_active->ViewCustomAttributes = "";
// id
$tbl_profile->id->HrefValue = "";
$tbl_profile->id->TooltipValue = "";
// name
$tbl_profile->name->HrefValue = "";
$tbl_profile->name->TooltipValue = "";
if ($tbl_profile->Export == "") {
$tbl_profile->name->ViewValue = ew_Highlight($tbl_profile->HighlightName(), $tbl_profile->name->ViewValue, $tbl_profile->getSessionBasicSearchKeyword(), $tbl_profile->getSessionBasicSearchType(), $tbl_profile->getAdvancedSearch("x_name"));
}
// ga_username
$tbl_profile->ga_username->HrefValue = "";
$tbl_profile->ga_username->TooltipValue = "";
if ($tbl_profile->Export == "") {
$tbl_profile->ga_username->ViewValue = ew_Highlight($tbl_profile->HighlightName(), $tbl_profile->ga_username->ViewValue, $tbl_profile->getSessionBasicSearchKeyword(), $tbl_profile->getSessionBasicSearchType(), $tbl_profile->getAdvancedSearch("x_ga_username"));
}
// ga_passwd
$tbl_profile->ga_passwd->HrefValue = "";
$tbl_profile->ga_passwd->TooltipValue = "";
if ($tbl_profile->Export == "") {
$tbl_profile->ga_passwd->ViewValue = ew_Highlight($tbl_profile->HighlightName(), $tbl_profile->ga_passwd->ViewValue, $tbl_profile->getSessionBasicSearchKeyword(), $tbl_profile->getSessionBasicSearchType(), $tbl_profile->getAdvancedSearch("x_ga_passwd"));
}
// ga_profileid
$tbl_profile->ga_profileid->HrefValue = "";
$tbl_profile->ga_profileid->TooltipValue = "";
if ($tbl_profile->Export == "") {
$tbl_profile->ga_profileid->ViewValue = ew_Highlight($tbl_profile->HighlightName(), $tbl_profile->ga_profileid->ViewValue, $tbl_profile->getSessionBasicSearchKeyword(), $tbl_profile->getSessionBasicSearchType(), $tbl_profile->getAdvancedSearch("x_ga_profileid"));
}
// url
$tbl_profile->url->HrefValue = "";
$tbl_profile->url->TooltipValue = "";
if ($tbl_profile->Export == "") {
$tbl_profile->url->ViewValue = ew_Highlight($tbl_profile->HighlightName(), $tbl_profile->url->ViewValue, $tbl_profile->getSessionBasicSearchKeyword(), $tbl_profile->getSessionBasicSearchType(), $tbl_profile->getAdvancedSearch("x_url"));
}
// fb_pageid
$tbl_profile->fb_pageid->HrefValue = "";
$tbl_profile->fb_pageid->TooltipValue = "";
if ($tbl_profile->Export == "") {
$tbl_profile->fb_pageid->ViewValue = ew_Highlight($tbl_profile->HighlightName(), $tbl_profile->fb_pageid->ViewValue, $tbl_profile->getSessionBasicSearchKeyword(), $tbl_profile->getSessionBasicSearchType(), $tbl_profile->getAdvancedSearch("x_fb_pageid"));
}
// twitter_page
$tbl_profile->twitter_page->HrefValue = "";
$tbl_profile->twitter_page->TooltipValue = "";
if ($tbl_profile->Export == "") {
$tbl_profile->twitter_page->ViewValue = ew_Highlight($tbl_profile->HighlightName(), $tbl_profile->twitter_page->ViewValue, $tbl_profile->getSessionBasicSearchKeyword(), $tbl_profile->getSessionBasicSearchType(), $tbl_profile->getAdvancedSearch("x_twitter_page"));
}
// is_wordpress
$tbl_profile->is_wordpress->HrefValue = "";
$tbl_profile->is_wordpress->TooltipValue = "";
// is_blogger
$tbl_profile->is_blogger->HrefValue = "";
$tbl_profile->is_blogger->TooltipValue = "";
// is_active
$tbl_profile->is_active->HrefValue = "";
$tbl_profile->is_active->TooltipValue = "";
} elseif ($tbl_profile->RowType == EW_ROWTYPE_ADD) {
// Add row
// id
// name
$tbl_profile->name->EditCustomAttributes = "";
$tbl_profile->name->EditValue = ew_HtmlEncode($tbl_profile->name->CurrentValue);
// ga_username
$tbl_profile->ga_username->EditCustomAttributes = "";
$tbl_profile->ga_username->EditValue = ew_HtmlEncode($tbl_profile->ga_username->CurrentValue);
// ga_passwd
$tbl_profile->ga_passwd->EditCustomAttributes = "";
$tbl_profile->ga_passwd->EditValue = ew_HtmlEncode($tbl_profile->ga_passwd->CurrentValue);
// ga_profileid
$tbl_profile->ga_profileid->EditCustomAttributes = "";
$tbl_profile->ga_profileid->EditValue = ew_HtmlEncode($tbl_profile->ga_profileid->CurrentValue);
// url
$tbl_profile->url->EditCustomAttributes = "";
$tbl_profile->url->EditValue = ew_HtmlEncode($tbl_profile->url->CurrentValue);
// fb_pageid
$tbl_profile->fb_pageid->EditCustomAttributes = "";
$tbl_profile->fb_pageid->EditValue = ew_HtmlEncode($tbl_profile->fb_pageid->CurrentValue);
// twitter_page
$tbl_profile->twitter_page->EditCustomAttributes = "";
$tbl_profile->twitter_page->EditValue = ew_HtmlEncode($tbl_profile->twitter_page->CurrentValue);
// is_wordpress
$tbl_profile->is_wordpress->EditCustomAttributes = "";
$arwrk = array();
$arwrk[] = array("0", "No");
$arwrk[] = array("1", "Yes");
$tbl_profile->is_wordpress->EditValue = $arwrk;
// is_blogger
$tbl_profile->is_blogger->EditCustomAttributes = "";
$arwrk = array();
$arwrk[] = array("0", "No");
$arwrk[] = array("1", "Yes");
$tbl_profile->is_blogger->EditValue = $arwrk;
// is_active
$tbl_profile->is_active->EditCustomAttributes = "";
$arwrk = array();
$arwrk[] = array("0", "No");
$arwrk[] = array("1", "Yes");
$tbl_profile->is_active->EditValue = $arwrk;
} elseif ($tbl_profile->RowType == EW_ROWTYPE_EDIT) {
// Edit row
// id
$tbl_profile->id->EditCustomAttributes = "";
$tbl_profile->id->EditValue = $tbl_profile->id->CurrentValue;
$tbl_profile->id->CssStyle = "";
$tbl_profile->id->CssClass = "";
$tbl_profile->id->ViewCustomAttributes = "";
// name
$tbl_profile->name->EditCustomAttributes = "";
$tbl_profile->name->EditValue = ew_HtmlEncode($tbl_profile->name->CurrentValue);
// ga_username
$tbl_profile->ga_username->EditCustomAttributes = "";
$tbl_profile->ga_username->EditValue = ew_HtmlEncode($tbl_profile->ga_username->CurrentValue);
// ga_passwd
$tbl_profile->ga_passwd->EditCustomAttributes = "";
$tbl_profile->ga_passwd->EditValue = ew_HtmlEncode($tbl_profile->ga_passwd->CurrentValue);
// ga_profileid
$tbl_profile->ga_profileid->EditCustomAttributes = "";
$tbl_profile->ga_profileid->EditValue = ew_HtmlEncode($tbl_profile->ga_profileid->CurrentValue);
// url
$tbl_profile->url->EditCustomAttributes = "";
$tbl_profile->url->EditValue = ew_HtmlEncode($tbl_profile->url->CurrentValue);
// fb_pageid
$tbl_profile->fb_pageid->EditCustomAttributes = "";
$tbl_profile->fb_pageid->EditValue = ew_HtmlEncode($tbl_profile->fb_pageid->CurrentValue);
// twitter_page
$tbl_profile->twitter_page->EditCustomAttributes = "";
$tbl_profile->twitter_page->EditValue = ew_HtmlEncode($tbl_profile->twitter_page->CurrentValue);
// is_wordpress
$tbl_profile->is_wordpress->EditCustomAttributes = "";
$arwrk = array();
$arwrk[] = array("0", "No");
$arwrk[] = array("1", "Yes");
$tbl_profile->is_wordpress->EditValue = $arwrk;
// is_blogger
$tbl_profile->is_blogger->EditCustomAttributes = "";
$arwrk = array();
$arwrk[] = array("0", "No");
$arwrk[] = array("1", "Yes");
$tbl_profile->is_blogger->EditValue = $arwrk;
// is_active
$tbl_profile->is_active->EditCustomAttributes = "";
$arwrk = array();
$arwrk[] = array("0", "No");
$arwrk[] = array("1", "Yes");
$tbl_profile->is_active->EditValue = $arwrk;
// Edit refer script
// id
$tbl_profile->id->HrefValue = "";
// name
$tbl_profile->name->HrefValue = "";
// ga_username
$tbl_profile->ga_username->HrefValue = "";
// ga_passwd
$tbl_profile->ga_passwd->HrefValue = "";
// ga_profileid
$tbl_profile->ga_profileid->HrefValue = "";
// url
$tbl_profile->url->HrefValue = "";
// fb_pageid
$tbl_profile->fb_pageid->HrefValue = "";
// twitter_page
$tbl_profile->twitter_page->HrefValue = "";
// is_wordpress
$tbl_profile->is_wordpress->HrefValue = "";
// is_blogger
$tbl_profile->is_blogger->HrefValue = "";
// is_active
$tbl_profile->is_active->HrefValue = "";
}
// Call Row Rendered event
if ($tbl_profile->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$tbl_profile->Row_Rendered();
}
}
function RenderRow()
{
global $conn, $Security, $Language, $tbl_group;
// Initialize URLs
$this->ViewUrl = $tbl_group->ViewUrl();
$this->EditUrl = $tbl_group->EditUrl();
$this->InlineEditUrl = $tbl_group->InlineEditUrl();
$this->CopyUrl = $tbl_group->CopyUrl();
$this->InlineCopyUrl = $tbl_group->InlineCopyUrl();
$this->DeleteUrl = $tbl_group->DeleteUrl();
// Call Row_Rendering event
$tbl_group->Row_Rendering();
// Common render codes for all row types
// id
$tbl_group->id->CellCssStyle = "";
$tbl_group->id->CellCssClass = "";
$tbl_group->id->CellAttrs = array();
$tbl_group->id->ViewAttrs = array();
$tbl_group->id->EditAttrs = array();
// name
$tbl_group->name->CellCssStyle = "white-space: nowrap;";
$tbl_group->name->CellCssClass = "";
$tbl_group->name->CellAttrs = array();
$tbl_group->name->ViewAttrs = array();
$tbl_group->name->EditAttrs = array();
// is_active
$tbl_group->is_active->CellCssStyle = "";
$tbl_group->is_active->CellCssClass = "";
$tbl_group->is_active->CellAttrs = array();
$tbl_group->is_active->ViewAttrs = array();
$tbl_group->is_active->EditAttrs = array();
if ($tbl_group->RowType == EW_ROWTYPE_VIEW) {
// View row
// id
$tbl_group->id->ViewValue = $tbl_group->id->CurrentValue;
$tbl_group->id->CssStyle = "";
$tbl_group->id->CssClass = "";
$tbl_group->id->ViewCustomAttributes = "";
// name
$tbl_group->name->ViewValue = $tbl_group->name->CurrentValue;
$tbl_group->name->CssStyle = "";
$tbl_group->name->CssClass = "";
$tbl_group->name->ViewCustomAttributes = "";
// is_active
if (ew_ConvertToBool($tbl_group->is_active->CurrentValue)) {
$tbl_group->is_active->ViewValue = "Yes";
} else {
$tbl_group->is_active->ViewValue = "No";
}
$tbl_group->is_active->CssStyle = "";
$tbl_group->is_active->CssClass = "";
$tbl_group->is_active->ViewCustomAttributes = "";
// id
$tbl_group->id->HrefValue = "";
$tbl_group->id->TooltipValue = "";
// name
$tbl_group->name->HrefValue = "";
$tbl_group->name->TooltipValue = "";
if ($tbl_group->Export == "") {
$tbl_group->name->ViewValue = ew_Highlight($tbl_group->HighlightName(), $tbl_group->name->ViewValue, $tbl_group->getSessionBasicSearchKeyword(), $tbl_group->getSessionBasicSearchType(), $tbl_group->getAdvancedSearch("x_name"));
}
// is_active
$tbl_group->is_active->HrefValue = "";
$tbl_group->is_active->TooltipValue = "";
} elseif ($tbl_group->RowType == EW_ROWTYPE_ADD) {
// Add row
// id
// name
$tbl_group->name->EditCustomAttributes = "";
$tbl_group->name->EditValue = ew_HtmlEncode($tbl_group->name->CurrentValue);
// is_active
$tbl_group->is_active->EditCustomAttributes = "";
$arwrk = array();
$arwrk[] = array("1", "Yes");
$arwrk[] = array("0", "No");
$tbl_group->is_active->EditValue = $arwrk;
} elseif ($tbl_group->RowType == EW_ROWTYPE_EDIT) {
// Edit row
// id
$tbl_group->id->EditCustomAttributes = "";
$tbl_group->id->EditValue = $tbl_group->id->CurrentValue;
$tbl_group->id->CssStyle = "";
$tbl_group->id->CssClass = "";
$tbl_group->id->ViewCustomAttributes = "";
// name
$tbl_group->name->EditCustomAttributes = "";
$tbl_group->name->EditValue = ew_HtmlEncode($tbl_group->name->CurrentValue);
// is_active
$tbl_group->is_active->EditCustomAttributes = "";
$arwrk = array();
$arwrk[] = array("1", "Yes");
$arwrk[] = array("0", "No");
$tbl_group->is_active->EditValue = $arwrk;
// Edit refer script
// id
$tbl_group->id->HrefValue = "";
// name
$tbl_group->name->HrefValue = "";
// is_active
$tbl_group->is_active->HrefValue = "";
}
// Call Row Rendered event
if ($tbl_group->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$tbl_group->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
// userlevelid
// userlevelname
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// userlevelid
$this->userlevelid->ViewValue = $this->userlevelid->CurrentValue;
$this->userlevelid->ViewCustomAttributes = "";
// userlevelname
$this->userlevelname->ViewValue = $this->userlevelname->CurrentValue;
$this->userlevelname->ViewCustomAttributes = "";
// userlevelid
$this->userlevelid->LinkCustomAttributes = "";
$this->userlevelid->HrefValue = "";
$this->userlevelid->TooltipValue = "";
if ($this->Export == "") {
$this->userlevelid->ViewValue = ew_Highlight($this->HighlightName(), $this->userlevelid->ViewValue, "", "", $this->userlevelid->AdvancedSearch->getValue("x"), "");
}
// userlevelname
$this->userlevelname->LinkCustomAttributes = "";
$this->userlevelname->HrefValue = "";
$this->userlevelname->TooltipValue = "";
if ($this->Export == "") {
$this->userlevelname->ViewValue = ew_Highlight($this->HighlightName(), $this->userlevelname->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->userlevelname->AdvancedSearch->getValue("x"), "");
}
}
// 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
// mes
// anio
// fecha
// monto
// id_usuario
$this->id_usuario->CellCssStyle = "white-space: nowrap;";
// 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 = "";
if ($this->Export == "") {
$this->mes->ViewValue = ew_Highlight($this->HighlightName(), $this->mes->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->mes->AdvancedSearch->getValue("x"), "");
}
// anio
$this->anio->LinkCustomAttributes = "";
$this->anio->HrefValue = "";
$this->anio->TooltipValue = "";
if ($this->Export == "") {
$this->anio->ViewValue = ew_Highlight($this->HighlightName(), $this->anio->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->anio->AdvancedSearch->getValue("x"), "");
}
// 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
// id
// 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($GLOBALS["deudas"]->CurrentAction)) {
$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
// id
$this->id->HrefValue = "";
// mes
$this->mes->HrefValue = "";
// anio
$this->anio->HrefValue = "";
// fecha
$this->fecha->HrefValue = "";
// monto
$this->monto->HrefValue = "";
// id_socio
$this->id_socio->HrefValue = "";
}
if ($this->RowType == EW_ROWTYPE_ADD || $this->RowType == EW_ROWTYPE_EDIT || $this->RowType == EW_ROWTYPE_SEARCH) {
// Add / Edit / Search row
$this->SetupFieldTitles();
}
// Call Row Rendered event
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$this->Row_Rendered();
}
}
function RenderRow()
{
global $conn, $Security, $Language;
global $gsLanguage;
// Initialize URLs
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// socio_nro
// cuit_cuil
// id_actividad
$this->id_actividad->CellCssStyle = "white-space: nowrap;";
// propietario
// comercio
// direccion_comercio
// mail
// tel
// cel
// activo
// id_usuario
$this->id_usuario->CellCssStyle = "white-space: nowrap;";
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// socio_nro
$this->socio_nro->ViewValue = $this->socio_nro->CurrentValue;
$this->socio_nro->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 = "";
// 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 = "";
// 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 = "";
// 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 = "";
if ($this->Export == "") {
$this->socio_nro->ViewValue = ew_Highlight($this->HighlightName(), $this->socio_nro->ViewValue, "", "", $this->socio_nro->AdvancedSearch->getValue("x"), "");
}
// cuit_cuil
$this->cuit_cuil->LinkCustomAttributes = "";
$this->cuit_cuil->HrefValue = "";
$this->cuit_cuil->TooltipValue = "";
// propietario
$this->propietario->LinkCustomAttributes = "";
$this->propietario->HrefValue = "";
$this->propietario->TooltipValue = "";
if ($this->Export == "") {
$this->propietario->ViewValue = ew_Highlight($this->HighlightName(), $this->propietario->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->propietario->AdvancedSearch->getValue("x"), "");
}
// comercio
$this->comercio->LinkCustomAttributes = "";
$this->comercio->HrefValue = "";
$this->comercio->TooltipValue = "";
if ($this->Export == "") {
$this->comercio->ViewValue = ew_Highlight($this->HighlightName(), $this->comercio->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->comercio->AdvancedSearch->getValue("x"), "");
}
// direccion_comercio
$this->direccion_comercio->LinkCustomAttributes = "";
$this->direccion_comercio->HrefValue = "";
$this->direccion_comercio->TooltipValue = "";
if ($this->Export == "") {
$this->direccion_comercio->ViewValue = ew_Highlight($this->HighlightName(), $this->direccion_comercio->ViewValue, $this->BasicSearch->getKeyword(), $this->BasicSearch->getType(), $this->direccion_comercio->AdvancedSearch->getValue("x"), "");
}
// 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 = "";
// activo
$this->activo->LinkCustomAttributes = "";
$this->activo->HrefValue = "";
$this->activo->TooltipValue = "";
} elseif ($this->RowType == EW_ROWTYPE_ADD) {
// Add row
// socio_nro
// cuit_cuil
$this->cuit_cuil->EditAttrs["class"] = "form-control";
$this->cuit_cuil->EditCustomAttributes = "";
$this->cuit_cuil->EditValue = ew_HtmlEncode($this->cuit_cuil->CurrentValue);
$this->cuit_cuil->PlaceHolder = ew_RemoveHtml($this->cuit_cuil->FldCaption());
// propietario
$this->propietario->EditAttrs["class"] = "form-control";
$this->propietario->EditCustomAttributes = "";
$this->propietario->EditValue = ew_HtmlEncode($this->propietario->CurrentValue);
$this->propietario->PlaceHolder = ew_RemoveHtml($this->propietario->FldCaption());
// comercio
$this->comercio->EditAttrs["class"] = "form-control";
$this->comercio->EditCustomAttributes = "";
$this->comercio->EditValue = ew_HtmlEncode($this->comercio->CurrentValue);
$this->comercio->PlaceHolder = ew_RemoveHtml($this->comercio->FldCaption());
// direccion_comercio
$this->direccion_comercio->EditAttrs["class"] = "form-control";
$this->direccion_comercio->EditCustomAttributes = "";
$this->direccion_comercio->EditValue = ew_HtmlEncode($this->direccion_comercio->CurrentValue);
$this->direccion_comercio->PlaceHolder = ew_RemoveHtml($this->direccion_comercio->FldCaption());
// mail
$this->mail->EditAttrs["class"] = "form-control";
$this->mail->EditCustomAttributes = "";
$this->mail->EditValue = ew_HtmlEncode($this->mail->CurrentValue);
$this->mail->PlaceHolder = ew_RemoveHtml($this->mail->FldCaption());
// tel
$this->tel->EditAttrs["class"] = "form-control";
$this->tel->EditCustomAttributes = "";
$this->tel->EditValue = ew_HtmlEncode($this->tel->CurrentValue);
$this->tel->PlaceHolder = ew_RemoveHtml($this->tel->FldCaption());
// cel
$this->cel->EditAttrs["class"] = "form-control";
$this->cel->EditCustomAttributes = "";
$this->cel->EditValue = ew_HtmlEncode($this->cel->CurrentValue);
$this->cel->PlaceHolder = ew_RemoveHtml($this->cel->FldCaption());
// 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;
// Edit refer script
// socio_nro
$this->socio_nro->HrefValue = "";
// cuit_cuil
$this->cuit_cuil->HrefValue = "";
// propietario
$this->propietario->HrefValue = "";
// comercio
$this->comercio->HrefValue = "";
// direccion_comercio
$this->direccion_comercio->HrefValue = "";
// mail
$this->mail->HrefValue = "";
// tel
$this->tel->HrefValue = "";
// cel
$this->cel->HrefValue = "";
// activo
$this->activo->HrefValue = "";
} elseif ($this->RowType == EW_ROWTYPE_EDIT) {
// Edit row
// socio_nro
$this->socio_nro->EditAttrs["class"] = "form-control";
$this->socio_nro->EditCustomAttributes = "";
$this->socio_nro->EditValue = $this->socio_nro->CurrentValue;
$this->socio_nro->ViewCustomAttributes = "";
// cuit_cuil
$this->cuit_cuil->EditAttrs["class"] = "form-control";
$this->cuit_cuil->EditCustomAttributes = "";
$this->cuit_cuil->EditValue = ew_HtmlEncode($this->cuit_cuil->CurrentValue);
$this->cuit_cuil->PlaceHolder = ew_RemoveHtml($this->cuit_cuil->FldCaption());
// propietario
$this->propietario->EditAttrs["class"] = "form-control";
$this->propietario->EditCustomAttributes = "";
$this->propietario->EditValue = ew_HtmlEncode($this->propietario->CurrentValue);
$this->propietario->PlaceHolder = ew_RemoveHtml($this->propietario->FldCaption());
// comercio
$this->comercio->EditAttrs["class"] = "form-control";
$this->comercio->EditCustomAttributes = "";
$this->comercio->EditValue = ew_HtmlEncode($this->comercio->CurrentValue);
$this->comercio->PlaceHolder = ew_RemoveHtml($this->comercio->FldCaption());
// direccion_comercio
$this->direccion_comercio->EditAttrs["class"] = "form-control";
$this->direccion_comercio->EditCustomAttributes = "";
$this->direccion_comercio->EditValue = ew_HtmlEncode($this->direccion_comercio->CurrentValue);
$this->direccion_comercio->PlaceHolder = ew_RemoveHtml($this->direccion_comercio->FldCaption());
// mail
$this->mail->EditAttrs["class"] = "form-control";
$this->mail->EditCustomAttributes = "";
$this->mail->EditValue = ew_HtmlEncode($this->mail->CurrentValue);
$this->mail->PlaceHolder = ew_RemoveHtml($this->mail->FldCaption());
// tel
$this->tel->EditAttrs["class"] = "form-control";
$this->tel->EditCustomAttributes = "";
$this->tel->EditValue = ew_HtmlEncode($this->tel->CurrentValue);
$this->tel->PlaceHolder = ew_RemoveHtml($this->tel->FldCaption());
// cel
$this->cel->EditAttrs["class"] = "form-control";
$this->cel->EditCustomAttributes = "";
$this->cel->EditValue = ew_HtmlEncode($this->cel->CurrentValue);
$this->cel->PlaceHolder = ew_RemoveHtml($this->cel->FldCaption());
// 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;
// Edit refer script
// socio_nro
$this->socio_nro->HrefValue = "";
// cuit_cuil
$this->cuit_cuil->HrefValue = "";
// propietario
$this->propietario->HrefValue = "";
// comercio
$this->comercio->HrefValue = "";
// direccion_comercio
$this->direccion_comercio->HrefValue = "";
// mail
$this->mail->HrefValue = "";
// tel
$this->tel->HrefValue = "";
// cel
$this->cel->HrefValue = "";
// activo
$this->activo->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();
}
}
