本文整理汇总了PHP中ew_AddFilter函数的典型用法代码示例。如果您正苦于以下问题:PHP ew_AddFilter函数的具体用法?PHP ew_AddFilter怎么用?PHP ew_AddFilter使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了ew_AddFilter函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: RenderEditRow
function RenderEditRow()
{
global $conn, $Security, $gsLanguage, $Language;
// Call Row Rendering event
$this->Row_Rendering();
// idempleado
$this->idempleado->EditAttrs["class"] = "form-control";
$this->idempleado->EditCustomAttributes = "";
$this->idempleado->EditValue = $this->idempleado->CurrentValue;
$this->idempleado->ViewCustomAttributes = "";
// nombre
$this->nombre->EditAttrs["class"] = "form-control";
$this->nombre->EditCustomAttributes = "";
$this->nombre->EditValue = ew_HtmlEncode($this->nombre->CurrentValue);
$this->nombre->PlaceHolder = ew_RemoveHtml($this->nombre->FldCaption());
// apellido
$this->apellido->EditAttrs["class"] = "form-control";
$this->apellido->EditCustomAttributes = "";
$this->apellido->EditValue = ew_HtmlEncode($this->apellido->CurrentValue);
$this->apellido->PlaceHolder = ew_RemoveHtml($this->apellido->FldCaption());
// cui
$this->cui->EditAttrs["class"] = "form-control";
$this->cui->EditCustomAttributes = "";
$this->cui->EditValue = ew_HtmlEncode($this->cui->CurrentValue);
$this->cui->PlaceHolder = ew_RemoveHtml($this->cui->FldCaption());
// telefono
$this->telefono->EditAttrs["class"] = "form-control";
$this->telefono->EditCustomAttributes = "";
$this->telefono->EditValue = ew_HtmlEncode($this->telefono->CurrentValue);
$this->telefono->PlaceHolder = ew_RemoveHtml($this->telefono->FldCaption());
// direccion
$this->direccion->EditAttrs["class"] = "form-control";
$this->direccion->EditCustomAttributes = "";
$this->direccion->EditValue = ew_HtmlEncode($this->direccion->CurrentValue);
$this->direccion->PlaceHolder = ew_RemoveHtml($this->direccion->FldCaption());
// estado
$this->estado->EditCustomAttributes = "";
$arwrk = array();
$arwrk[] = array($this->estado->FldTagValue(1), $this->estado->FldTagCaption(1) != "" ? $this->estado->FldTagCaption(1) : $this->estado->FldTagValue(1));
$arwrk[] = array($this->estado->FldTagValue(2), $this->estado->FldTagCaption(2) != "" ? $this->estado->FldTagCaption(2) : $this->estado->FldTagValue(2));
$this->estado->EditValue = $arwrk;
// idhospital
$this->idhospital->EditAttrs["class"] = "form-control";
$this->idhospital->EditCustomAttributes = "";
if ($this->idhospital->getSessionValue() != "") {
$this->idhospital->CurrentValue = $this->idhospital->getSessionValue();
if (strval($this->idhospital->CurrentValue) != "") {
$sFilterWrk = "`idhospital`" . ew_SearchString("=", $this->idhospital->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `idhospital`, `nombre` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `hospital`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
// Call Lookup selecting
$this->Lookup_Selecting($this->idhospital, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->idhospital->ViewValue = $rswrk->fields('DispFld');
$rswrk->Close();
} else {
$this->idhospital->ViewValue = $this->idhospital->CurrentValue;
}
} else {
$this->idhospital->ViewValue = NULL;
}
$this->idhospital->ViewCustomAttributes = "";
} else {
}
// Call Row Rendered event
$this->Row_Rendered();
}
示例2: Page_Main
function Page_Main()
{
$GLOBALS["Page"] =& $this;
$post = ew_StripSlashes($_POST);
if (count($post) == 0) {
die("Missing post data.");
}
//$sql = $qs->getValue("s");
$sql = @$post["s"];
$sql = ew_Decrypt($sql);
if ($sql == "") {
die("Missing SQL.");
}
if (strpos($sql, "{filter}") > 0) {
$filters = "";
for ($i = 0; $i < 5; $i++) {
// Get the filter values (for "IN")
$filter = ew_Decrypt(@$post["f" . $i]);
if ($filter != "") {
$value = @$post["v" . $i];
if ($value == "") {
if ($i > 0) {
// Empty parent field
//continue; // Allow
ew_AddFilter($filters, "1=0");
}
// Disallow
continue;
}
$arValue = explode(",", $value);
$fldtype = intval(@$post["t" . $i]);
for ($j = 0, $cnt = count($arValue); $j < $cnt; $j++) {
$arValue[$j] = ew_QuotedValue($arValue[$j], ew_FieldDataType($fldtype));
}
$filter = str_replace("{filter_value}", implode(",", $arValue), $filter);
ew_AddFilter($filters, $filter);
}
}
$sql = str_replace("{filter}", $filters != "" ? $filters : "1=1", $sql);
}
// Get the query value (for "LIKE" or "=")
$value = ew_AdjustSql(@$post["q"]);
if ($value != "") {
$sql = preg_replace('/LIKE \'(%)?\\{query_value\\}%\'/', ew_Like('\'$1{query_value}%\''), $sql);
$sql = str_replace("{query_value}", $value, $sql);
}
// Replace {query_value_n}
preg_match_all('/\\{query_value_(\\d+)\\}/', $sql, $out);
$cnt = count($out[0]);
for ($i = 0; $i < $cnt; $i++) {
$j = $out[1][$i];
$v = ew_AdjustSql(@$post["q" . $j]);
$sql = str_replace("{query_value_" . $j . "}", $v, $sql);
}
$this->GetLookupValues($sql);
}
示例3: Page_Main
function Page_Main()
{
$post = ew_StripSlashes($_POST);
if (count($post) == 0) {
die("Missing post data.");
}
//$sql = $qs->getValue("s");
$sql = $post["s"];
$sql = TEAdecrypt($sql, EW_RANDOM_KEY);
if ($sql == "") {
die("Missing SQL.");
}
if (strpos($sql, "{filter}") > 0) {
$filters = "";
for ($i = 0; $i < 5; $i++) {
// Get the filter values (for "IN")
$filter = TEAdecrypt($post["f" . $i], EW_RANDOM_KEY);
if ($filter != "") {
$value = $post["v" . $i];
if ($value == "") {
if ($i > 0) {
// Empty parent field
//continue; // Allow
ew_AddFilter($filters, "1=0");
}
// Disallow
continue;
}
$arValue = explode(",", $value);
$fldtype = intval($post["t" . $i]);
for ($j = 0, $cnt = count($arValue); $j < $cnt; $j++) {
$arValue[$j] = ew_QuotedValue($arValue[$j], ew_FieldDataType($fldtype));
}
$filter = str_replace("{filter_value}", implode(",", $arValue), $filter);
ew_AddFilter($filters, $filter);
}
}
$sql = str_replace("{filter}", $filters != "" ? $filters : "1=1", $sql);
}
// Get the query value (for "LIKE" or "=")
$value = ew_AdjustSql(@$post["q"]);
if ($value != "") {
$sql = preg_replace('/LIKE \'(%)?\\{query_value\\}%\'/', ew_Like('\'$1{query_value}%\''), $sql);
$sql = str_replace("{query_value}", $value, $sql);
}
// Check custom function
$fn = @$post["fn"];
if ($fn != "" && function_exists($fn)) {
// Custom function(&$sql)
$sql = $fn($sql);
}
$this->GetLookupValues($sql);
}
示例4: RenderRow
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
// lesson_id
// video_link
// active
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// id
$this->id->ViewValue = $this->id->CurrentValue;
$this->id->ViewCustomAttributes = "";
// lesson_id
if (strval($this->lesson_id->CurrentValue) != "") {
$sFilterWrk = "`lesson_id`" . ew_SearchString("=", $this->lesson_id->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `lesson_id`, `lesson_name` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tbl_lesson`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->lesson_id->ViewValue = $rswrk->fields('DispFld');
$rswrk->Close();
} else {
$this->lesson_id->ViewValue = $this->lesson_id->CurrentValue;
}
} else {
$this->lesson_id->ViewValue = NULL;
}
$this->lesson_id->ViewCustomAttributes = "";
// video_link
$this->video_link->ViewValue = $this->video_link->CurrentValue;
$this->video_link->ViewCustomAttributes = "";
// active
$this->active->ViewValue = $this->active->CurrentValue;
$this->active->ViewCustomAttributes = "";
// id
$this->id->LinkCustomAttributes = "";
$this->id->HrefValue = "";
$this->id->TooltipValue = "";
// lesson_id
$this->lesson_id->LinkCustomAttributes = "";
$this->lesson_id->HrefValue = "";
$this->lesson_id->TooltipValue = "";
// video_link
$this->video_link->LinkCustomAttributes = "";
$this->video_link->HrefValue = "";
$this->video_link->TooltipValue = "";
// active
$this->active->LinkCustomAttributes = "";
$this->active->HrefValue = "";
$this->active->TooltipValue = "";
} elseif ($this->RowType == EW_ROWTYPE_EDIT) {
// Edit row
// id
$this->id->EditCustomAttributes = "";
$this->id->EditValue = $this->id->CurrentValue;
$this->id->ViewCustomAttributes = "";
// lesson_id
$this->lesson_id->EditCustomAttributes = "";
$sFilterWrk = "";
$sSqlWrk = "SELECT `lesson_id`, `lesson_name` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `tbl_lesson`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
ew_AddFilter($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"), "", "", "", "", "", "", ""));
$this->lesson_id->EditValue = $arwrk;
// video_link
$this->video_link->EditCustomAttributes = "";
$this->video_link->EditValue = ew_HtmlEncode($this->video_link->CurrentValue);
// active
$this->active->EditCustomAttributes = "";
$this->active->EditValue = ew_HtmlEncode($this->active->CurrentValue);
// Edit refer script
// id
$this->id->HrefValue = "";
// lesson_id
$this->lesson_id->HrefValue = "";
// video_link
$this->video_link->HrefValue = "";
// active
//.........这里部分代码省略.........
示例5: RenderRow
function RenderRow()
{
global $conn, $Security, $Language;
global $gsLanguage;
// Initialize URLs
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// accountId
// permissionId
// granted
// realmId
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// accountId
if (strval($this->accountId->CurrentValue) != "") {
$sFilterWrk = "`id`" . ew_SearchString("=", $this->accountId->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `username` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `account`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->accountId->ViewValue = $rswrk->fields('DispFld');
$this->accountId->ViewValue .= ew_ValueSeparator(1, $this->accountId) . $rswrk->fields('Disp2Fld');
$rswrk->Close();
} else {
$this->accountId->ViewValue = $this->accountId->CurrentValue;
}
} else {
$this->accountId->ViewValue = NULL;
}
$this->accountId->ViewCustomAttributes = "";
// permissionId
if ($this->permissionId->VirtualValue != "") {
$this->permissionId->ViewValue = $this->permissionId->VirtualValue;
} else {
if (strval($this->permissionId->CurrentValue) != "") {
$sFilterWrk = "`id`" . ew_SearchString("=", $this->permissionId->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `name` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `rbac_permissions`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->permissionId->ViewValue = $rswrk->fields('DispFld');
$this->permissionId->ViewValue .= ew_ValueSeparator(1, $this->permissionId) . $rswrk->fields('Disp2Fld');
$rswrk->Close();
} else {
$this->permissionId->ViewValue = $this->permissionId->CurrentValue;
}
} else {
$this->permissionId->ViewValue = NULL;
}
}
$this->permissionId->ViewCustomAttributes = "";
// granted
if (strval($this->granted->CurrentValue) != "") {
switch ($this->granted->CurrentValue) {
case $this->granted->FldTagValue(1):
$this->granted->ViewValue = $this->granted->FldTagCaption(1) != "" ? $this->granted->FldTagCaption(1) : $this->granted->CurrentValue;
break;
case $this->granted->FldTagValue(2):
$this->granted->ViewValue = $this->granted->FldTagCaption(2) != "" ? $this->granted->FldTagCaption(2) : $this->granted->CurrentValue;
break;
default:
$this->granted->ViewValue = $this->granted->CurrentValue;
}
} else {
$this->granted->ViewValue = NULL;
}
$this->granted->ViewCustomAttributes = "";
// realmId
if (strval($this->realmId->CurrentValue) != "") {
$sFilterWrk = "`id`" . ew_SearchString("=", $this->realmId->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `name` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `realmlist`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->realmId->ViewValue = $rswrk->fields('DispFld');
$this->realmId->ViewValue .= ew_ValueSeparator(1, $this->realmId) . $rswrk->fields('Disp2Fld');
$rswrk->Close();
} else {
//.........这里部分代码省略.........
示例6: RenderRow
function RenderRow()
{
global $Security, $Language, $gsLanguage;
// Initialize URLs
$this->AddUrl = $this->GetAddUrl();
$this->EditUrl = $this->GetEditUrl();
$this->CopyUrl = $this->GetCopyUrl();
$this->DeleteUrl = $this->GetDeleteUrl();
$this->ListUrl = $this->GetListUrl();
$this->SetupOtherOptions();
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// scat_id
// category_id
// scat_name
// scat_description
// scat_picture
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// scat_id
$this->scat_id->ViewValue = $this->scat_id->CurrentValue;
$this->scat_id->ViewCustomAttributes = "";
// category_id
if (strval($this->category_id->CurrentValue) != "") {
$sFilterWrk = "`category_id`" . ew_SearchString("=", $this->category_id->CurrentValue, EW_DATATYPE_NUMBER, "");
$sSqlWrk = "SELECT `category_id`, `category_name` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `category`";
$sWhereWrk = "";
ew_AddFilter($sWhereWrk, $sFilterWrk);
$this->Lookup_Selecting($this->category_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->category_id->ViewValue = $this->category_id->DisplayValue($arwrk);
$rswrk->Close();
} else {
$this->category_id->ViewValue = $this->category_id->CurrentValue;
}
} else {
$this->category_id->ViewValue = NULL;
}
$this->category_id->ViewCustomAttributes = "";
// scat_name
$this->scat_name->ViewValue = $this->scat_name->CurrentValue;
$this->scat_name->ViewCustomAttributes = "";
// scat_description
$this->scat_description->ViewValue = $this->scat_description->CurrentValue;
$this->scat_description->ViewCustomAttributes = "";
// scat_picture
if (!ew_Empty($this->scat_picture->Upload->DbValue)) {
$this->scat_picture->ViewValue = $this->scat_picture->Upload->DbValue;
} else {
$this->scat_picture->ViewValue = "";
}
$this->scat_picture->ViewCustomAttributes = "";
// scat_id
$this->scat_id->LinkCustomAttributes = "";
$this->scat_id->HrefValue = "";
$this->scat_id->TooltipValue = "";
// category_id
$this->category_id->LinkCustomAttributes = "";
$this->category_id->HrefValue = "";
$this->category_id->TooltipValue = "";
// scat_name
$this->scat_name->LinkCustomAttributes = "";
$this->scat_name->HrefValue = "";
$this->scat_name->TooltipValue = "";
// scat_description
$this->scat_description->LinkCustomAttributes = "";
$this->scat_description->HrefValue = "";
$this->scat_description->TooltipValue = "";
// scat_picture
$this->scat_picture->LinkCustomAttributes = "";
$this->scat_picture->HrefValue = "";
$this->scat_picture->HrefValue2 = $this->scat_picture->UploadPath . $this->scat_picture->Upload->DbValue;
$this->scat_picture->TooltipValue = "";
}
// Call Row Rendered event
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$this->Row_Rendered();
}
}
示例7: ew_AddFilter
?>
</option>
<?php
}
}
if (@$emptywrk) {
$gastos_mantenimientos->id_tipo_gasto->OldValue = "";
}
?>
</select>
<?php
$sSqlWrk = "SELECT `codigo`, `tipo_gasto` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tipo_gastos`";
$sWhereWrk = "";
$lookuptblfilter = "`clase`='M'";
if (strval($lookuptblfilter) != "") {
ew_AddFilter($sWhereWrk, $lookuptblfilter);
}
// Call Lookup selecting
$gastos_mantenimientos->Lookup_Selecting($gastos_mantenimientos->id_tipo_gasto, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$sSqlWrk .= " ORDER BY `tipo_gasto` ASC";
?>
<input type="hidden" name="s_x<?php
echo $gastos_mantenimientos_grid->RowIndex;
?>
_id_tipo_gasto" id="s_x<?php
echo $gastos_mantenimientos_grid->RowIndex;
?>
_id_tipo_gasto" value="s=<?php
示例8: RenderRow
function RenderRow()
{
global $conn, $Security, $Language;
global $gsLanguage;
// Initialize URLs
// Convert decimal values if posted back
if ($this->iva->FormValue == $this->iva->CurrentValue && is_numeric(ew_StrToFloat($this->iva->CurrentValue))) {
$this->iva->CurrentValue = ew_StrToFloat($this->iva->CurrentValue);
}
// Convert decimal values if posted back
if ($this->Importe->FormValue == $this->Importe->CurrentValue && is_numeric(ew_StrToFloat($this->Importe->CurrentValue))) {
$this->Importe->CurrentValue = ew_StrToFloat($this->Importe->CurrentValue);
}
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// codigo
// fecha
// detalles
// iva
// Importe
// id_tipo_gasto
// id_hoja_ruta
$this->id_hoja_ruta->CellCssStyle = "white-space: nowrap;";
// id_hoja_mantenimiento
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// codigo
$this->codigo->ViewValue = $this->codigo->CurrentValue;
$this->codigo->ViewCustomAttributes = "";
// fecha
$this->fecha->ViewValue = $this->fecha->CurrentValue;
$this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7);
$this->fecha->ViewCustomAttributes = "";
// detalles
$this->detalles->ViewValue = $this->detalles->CurrentValue;
$this->detalles->ViewCustomAttributes = "";
// iva
$this->iva->ViewValue = $this->iva->CurrentValue;
$this->iva->ViewCustomAttributes = "";
// Importe
$this->Importe->ViewValue = $this->Importe->CurrentValue;
$this->Importe->ViewCustomAttributes = "";
// id_tipo_gasto
if ($this->id_tipo_gasto->VirtualValue != "") {
$this->id_tipo_gasto->ViewValue = $this->id_tipo_gasto->VirtualValue;
} else {
$this->id_tipo_gasto->ViewValue = $this->id_tipo_gasto->CurrentValue;
if (strval($this->id_tipo_gasto->CurrentValue) != "") {
$sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_tipo_gasto->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `codigo`, `tipo_gasto` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tipo_gastos`";
$sWhereWrk = "";
$lookuptblfilter = "`clase`='M'";
if (strval($lookuptblfilter) != "") {
ew_AddFilter($sWhereWrk, $lookuptblfilter);
}
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
// Call Lookup selecting
$this->Lookup_Selecting($this->id_tipo_gasto, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$sSqlWrk .= " ORDER BY `tipo_gasto` ASC";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->id_tipo_gasto->ViewValue = $rswrk->fields('DispFld');
$rswrk->Close();
} else {
$this->id_tipo_gasto->ViewValue = $this->id_tipo_gasto->CurrentValue;
}
} else {
$this->id_tipo_gasto->ViewValue = NULL;
}
}
$this->id_tipo_gasto->ViewCustomAttributes = "";
// id_hoja_mantenimiento
$this->id_hoja_mantenimiento->ViewValue = $this->id_hoja_mantenimiento->CurrentValue;
$this->id_hoja_mantenimiento->ViewCustomAttributes = "";
// codigo
$this->codigo->LinkCustomAttributes = "";
$this->codigo->HrefValue = "";
$this->codigo->TooltipValue = "";
// fecha
$this->fecha->LinkCustomAttributes = "";
$this->fecha->HrefValue = "";
$this->fecha->TooltipValue = "";
// detalles
$this->detalles->LinkCustomAttributes = "";
$this->detalles->HrefValue = "";
$this->detalles->TooltipValue = "";
// iva
$this->iva->LinkCustomAttributes = "";
$this->iva->HrefValue = "";
$this->iva->TooltipValue = "";
// Importe
$this->Importe->LinkCustomAttributes = "";
$this->Importe->HrefValue = "";
//.........这里部分代码省略.........
示例9: DeleteSQL
function DeleteSQL(&$rs, $where = "", $curfilter = TRUE)
{
$sql = "DELETE FROM " . $this->UpdateTable . " WHERE ";
if (is_array($where)) {
$where = $this->ArrayToFilter($where);
}
if ($rs) {
if (array_key_exists('CARD_TYPE_ID', $rs)) {
ew_AddFilter($where, ew_QuotedName('CARD_TYPE_ID', $this->DBID) . '=' . ew_QuotedValue($rs['CARD_TYPE_ID'], $this->CARD_TYPE_ID->FldDataType, $this->DBID));
}
}
$filter = $curfilter ? $this->CurrentFilter : "";
ew_AddFilter($filter, $where);
if ($filter != "") {
$sql .= $filter;
} else {
$sql .= "0=1";
}
// Avoid delete
return $sql;
}
示例10: RenderRow
function RenderRow()
{
global $conn, $Security, $Language;
global $gsLanguage;
// Initialize URLs
$this->AddUrl = $this->GetAddUrl();
$this->EditUrl = $this->GetEditUrl();
$this->CopyUrl = $this->GetCopyUrl();
$this->DeleteUrl = $this->GetDeleteUrl();
$this->ListUrl = $this->GetListUrl();
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// realmid
// acctid
// numchars
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// realmid
if (strval($this->realmid->CurrentValue) != "") {
$sFilterWrk = "`id`" . ew_SearchString("=", $this->realmid->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `name` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `realmlist`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->realmid->ViewValue = $rswrk->fields('DispFld');
$this->realmid->ViewValue .= ew_ValueSeparator(1, $this->realmid) . $rswrk->fields('Disp2Fld');
$rswrk->Close();
} else {
$this->realmid->ViewValue = $this->realmid->CurrentValue;
}
} else {
$this->realmid->ViewValue = NULL;
}
$this->realmid->ViewCustomAttributes = "";
// acctid
if (strval($this->acctid->CurrentValue) != "") {
$sFilterWrk = "`id`" . ew_SearchString("=", $this->acctid->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `id`, `id` AS `DispFld`, `username` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `account`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->acctid->ViewValue = $rswrk->fields('DispFld');
$this->acctid->ViewValue .= ew_ValueSeparator(1, $this->acctid) . $rswrk->fields('Disp2Fld');
$rswrk->Close();
} else {
$this->acctid->ViewValue = $this->acctid->CurrentValue;
}
} else {
$this->acctid->ViewValue = NULL;
}
$this->acctid->ViewCustomAttributes = "";
// numchars
$this->numchars->ViewValue = $this->numchars->CurrentValue;
$this->numchars->ViewCustomAttributes = "";
// realmid
$this->realmid->LinkCustomAttributes = "";
$this->realmid->HrefValue = "";
$this->realmid->TooltipValue = "";
// acctid
$this->acctid->LinkCustomAttributes = "";
$this->acctid->HrefValue = "";
$this->acctid->TooltipValue = "";
// numchars
$this->numchars->LinkCustomAttributes = "";
$this->numchars->HrefValue = "";
$this->numchars->TooltipValue = "";
}
// Call Row Rendered event
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$this->Row_Rendered();
}
}
示例11: RenderRow
function RenderRow()
{
global $conn, $Security, $Language;
global $gsLanguage;
// Initialize URLs
$this->ViewUrl = $this->GetViewUrl();
$this->EditUrl = $this->GetEditUrl();
$this->InlineEditUrl = $this->GetInlineEditUrl();
$this->CopyUrl = $this->GetCopyUrl();
$this->InlineCopyUrl = $this->GetInlineCopyUrl();
$this->DeleteUrl = $this->GetDeleteUrl();
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// EvaluateAnswerID
// EvAnswer
// lastModified
// Date
// ID
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// EvaluateAnswerID
$this->EvaluateAnswerID->ViewValue = $this->EvaluateAnswerID->CurrentValue;
$this->EvaluateAnswerID->ViewCustomAttributes = "";
// lastModified
$this->lastModified->ViewValue = $this->lastModified->CurrentValue;
$this->lastModified->ViewValue = ew_FormatDateTime($this->lastModified->ViewValue, 5);
$this->lastModified->ViewCustomAttributes = "";
// Date
$this->Date->ViewValue = $this->Date->CurrentValue;
$this->Date->ViewValue = ew_FormatDateTime($this->Date->ViewValue, 5);
$this->Date->ViewCustomAttributes = "";
// ID
if (strval($this->ID->CurrentValue) != "") {
$sFilterWrk = "`ID`" . ew_SearchString("=", $this->ID->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `ID`, `Email` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `Users`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
// Call Lookup selecting
$this->Lookup_Selecting($this->ID, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->ID->ViewValue = $rswrk->fields('DispFld');
$rswrk->Close();
} else {
$this->ID->ViewValue = $this->ID->CurrentValue;
}
} else {
$this->ID->ViewValue = NULL;
}
$this->ID->ViewCustomAttributes = "";
// EvaluateAnswerID
$this->EvaluateAnswerID->LinkCustomAttributes = "";
$this->EvaluateAnswerID->HrefValue = "";
$this->EvaluateAnswerID->TooltipValue = "";
// lastModified
$this->lastModified->LinkCustomAttributes = "";
$this->lastModified->HrefValue = "";
$this->lastModified->TooltipValue = "";
// Date
$this->Date->LinkCustomAttributes = "";
$this->Date->HrefValue = "";
$this->Date->TooltipValue = "";
// ID
$this->ID->LinkCustomAttributes = "";
$this->ID->HrefValue = "";
$this->ID->TooltipValue = "";
}
// Call Row Rendered event
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$this->Row_Rendered();
}
}
示例12: RenderRow
function RenderRow()
{
global $conn, $Security, $Language;
global $gsLanguage;
// Initialize URLs
// Convert decimal values if posted back
if ($this->monto->FormValue == $this->monto->CurrentValue && is_numeric(ew_StrToFloat($this->monto->CurrentValue))) {
$this->monto->CurrentValue = ew_StrToFloat($this->monto->CurrentValue);
}
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// id
// mes
// anio
// fecha
// monto
// id_usuario
// id_socio
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// id
$this->id->ViewCustomAttributes = "";
// mes
$this->mes->ViewValue = $this->mes->CurrentValue;
$this->mes->ViewCustomAttributes = "";
// anio
$this->anio->ViewValue = $this->anio->CurrentValue;
$this->anio->ViewCustomAttributes = "";
// fecha
$this->fecha->ViewValue = $this->fecha->CurrentValue;
$this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7);
$this->fecha->ViewCustomAttributes = "";
// monto
$this->monto->ViewValue = $this->monto->CurrentValue;
$this->monto->ViewValue = ew_FormatCurrency($this->monto->ViewValue, 0, -2, -2, -2);
$this->monto->ViewCustomAttributes = "";
// id_socio
if (strval($this->id_socio->CurrentValue) != "") {
$sFilterWrk = "`socio_nro`" . ew_SearchString("=", $this->id_socio->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `socio_nro`, `propietario` AS `DispFld`, `comercio` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `socios`";
$sWhereWrk = "";
$lookuptblfilter = "`activo`='S'";
if (strval($lookuptblfilter) != "") {
ew_AddFilter($sWhereWrk, $lookuptblfilter);
}
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
// Call Lookup selecting
$this->Lookup_Selecting($this->id_socio, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$sSqlWrk .= " ORDER BY `propietario` DESC";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->id_socio->ViewValue = $rswrk->fields('DispFld');
$this->id_socio->ViewValue .= ew_ValueSeparator(1, $this->id_socio) . $rswrk->fields('Disp2Fld');
$rswrk->Close();
} else {
$this->id_socio->ViewValue = $this->id_socio->CurrentValue;
}
} else {
$this->id_socio->ViewValue = NULL;
}
$this->id_socio->ViewCustomAttributes = "";
// mes
$this->mes->LinkCustomAttributes = "";
$this->mes->HrefValue = "";
$this->mes->TooltipValue = "";
// anio
$this->anio->LinkCustomAttributes = "";
$this->anio->HrefValue = "";
$this->anio->TooltipValue = "";
// fecha
$this->fecha->LinkCustomAttributes = "";
$this->fecha->HrefValue = "";
$this->fecha->TooltipValue = "";
// monto
$this->monto->LinkCustomAttributes = "";
$this->monto->HrefValue = "";
$this->monto->TooltipValue = "";
// id_socio
$this->id_socio->LinkCustomAttributes = "";
$this->id_socio->HrefValue = "";
$this->id_socio->TooltipValue = "";
} elseif ($this->RowType == EW_ROWTYPE_ADD) {
// Add row
// mes
$this->mes->EditAttrs["class"] = "form-control";
$this->mes->EditCustomAttributes = "";
$this->mes->EditValue = ew_HtmlEncode($this->mes->CurrentValue);
$this->mes->PlaceHolder = ew_RemoveHtml($this->mes->FldCaption());
// anio
$this->anio->EditAttrs["class"] = "form-control";
$this->anio->EditCustomAttributes = "";
$this->anio->EditValue = ew_HtmlEncode($this->anio->CurrentValue);
$this->anio->PlaceHolder = ew_RemoveHtml($this->anio->FldCaption());
//.........这里部分代码省略.........
示例13: RenderRow
function RenderRow()
{
global $conn, $Security, $Language;
global $gsLanguage;
// Initialize URLs
$this->ViewUrl = $this->GetViewUrl();
$this->EditUrl = $this->GetEditUrl();
$this->InlineEditUrl = $this->GetInlineEditUrl();
$this->CopyUrl = $this->GetCopyUrl();
$this->InlineCopyUrl = $this->GetInlineCopyUrl();
$this->DeleteUrl = $this->GetDeleteUrl();
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// id_tramite
// fecha
// hora
// titulo
// descripcion
// id_usuario
$this->id_usuario->CellCssStyle = "white-space: nowrap;";
// archivo
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// id_tramite
if ($this->id_tramite->VirtualValue != "") {
$this->id_tramite->ViewValue = $this->id_tramite->VirtualValue;
} else {
if (strval($this->id_tramite->CurrentValue) != "") {
$sFilterWrk = "`codigo`" . ew_SearchString("=", $this->id_tramite->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `codigo`, `codigo` AS `DispFld`, `fecha` AS `Disp2Fld`, `Titulo` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tramites`";
$sWhereWrk = "";
$lookuptblfilter = "`estado`<>'F'";
if (strval($lookuptblfilter) != "") {
ew_AddFilter($sWhereWrk, $lookuptblfilter);
}
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
// Call Lookup selecting
$this->Lookup_Selecting($this->id_tramite, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$sSqlWrk .= " ORDER BY `fecha` ASC";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->id_tramite->ViewValue = $rswrk->fields('DispFld');
$this->id_tramite->ViewValue .= ew_ValueSeparator(1, $this->id_tramite) . ew_FormatDateTime($rswrk->fields('Disp2Fld'), 7);
$this->id_tramite->ViewValue .= ew_ValueSeparator(2, $this->id_tramite) . $rswrk->fields('Disp3Fld');
$rswrk->Close();
} else {
$this->id_tramite->ViewValue = $this->id_tramite->CurrentValue;
}
} else {
$this->id_tramite->ViewValue = NULL;
}
}
$this->id_tramite->ViewCustomAttributes = "";
// fecha
$this->fecha->ViewValue = $this->fecha->CurrentValue;
$this->fecha->ViewValue = ew_FormatDateTime($this->fecha->ViewValue, 7);
$this->fecha->ViewCustomAttributes = "";
// hora
$this->hora->ViewValue = $this->hora->CurrentValue;
$this->hora->ViewCustomAttributes = "";
// titulo
$this->titulo->ViewValue = $this->titulo->CurrentValue;
$this->titulo->ViewCustomAttributes = "";
// archivo
if (!ew_Empty($this->archivo->Upload->DbValue)) {
$this->archivo->ViewValue = $this->archivo->Upload->DbValue;
} else {
$this->archivo->ViewValue = "";
}
$this->archivo->ViewCustomAttributes = "";
// id_tramite
$this->id_tramite->LinkCustomAttributes = "";
$this->id_tramite->HrefValue = "";
$this->id_tramite->TooltipValue = "";
// fecha
$this->fecha->LinkCustomAttributes = "";
$this->fecha->HrefValue = "";
$this->fecha->TooltipValue = "";
// hora
$this->hora->LinkCustomAttributes = "";
$this->hora->HrefValue = "";
$this->hora->TooltipValue = "";
// titulo
$this->titulo->LinkCustomAttributes = "";
$this->titulo->HrefValue = "";
$this->titulo->TooltipValue = "";
// archivo
$this->archivo->LinkCustomAttributes = "";
$this->archivo->HrefValue = "";
$this->archivo->HrefValue2 = $this->archivo->UploadPath . $this->archivo->Upload->DbValue;
$this->archivo->TooltipValue = "";
} elseif ($this->RowType == EW_ROWTYPE_ADD) {
// Add row
//.........这里部分代码省略.........
示例14: AddUserIDFilter
function AddUserIDFilter($sFilter)
{
global $Security;
$sFilterWrk = "";
$id = CurrentPageID() == "list" ? $this->CurrentAction : CurrentPageID();
if (!$this->UserIDAllow($id) && !$Security->IsAdmin()) {
$sFilterWrk = $Security->UserIDList();
if ($sFilterWrk != "") {
$sFilterWrk = '`client_id` IN (' . $sFilterWrk . ')';
}
}
// Call User ID Filtering event
$this->UserID_Filtering($sFilterWrk);
ew_AddFilter($sFilter, $sFilterWrk);
return $sFilter;
}
示例15: RenderRow
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
// idmedicina
// descripcion
// estado
// idlaboratorio
// idhospital
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// idmedicina
$this->idmedicina->ViewValue = $this->idmedicina->CurrentValue;
$this->idmedicina->ViewCustomAttributes = "";
// descripcion
$this->descripcion->ViewValue = $this->descripcion->CurrentValue;
$this->descripcion->ViewCustomAttributes = "";
// estado
if (strval($this->estado->CurrentValue) != "") {
switch ($this->estado->CurrentValue) {
case $this->estado->FldTagValue(1):
$this->estado->ViewValue = $this->estado->FldTagCaption(1) != "" ? $this->estado->FldTagCaption(1) : $this->estado->CurrentValue;
break;
case $this->estado->FldTagValue(2):
$this->estado->ViewValue = $this->estado->FldTagCaption(2) != "" ? $this->estado->FldTagCaption(2) : $this->estado->CurrentValue;
break;
default:
$this->estado->ViewValue = $this->estado->CurrentValue;
}
} else {
$this->estado->ViewValue = NULL;
}
$this->estado->ViewCustomAttributes = "";
// idlaboratorio
if (strval($this->idlaboratorio->CurrentValue) != "") {
$sFilterWrk = "`idlaboratorio`" . ew_SearchString("=", $this->idlaboratorio->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `idlaboratorio`, `descripcion` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `laboratorio`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
// Call Lookup selecting
$this->Lookup_Selecting($this->idlaboratorio, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->idlaboratorio->ViewValue = $rswrk->fields('DispFld');
$rswrk->Close();
} else {
$this->idlaboratorio->ViewValue = $this->idlaboratorio->CurrentValue;
}
} else {
$this->idlaboratorio->ViewValue = NULL;
}
$this->idlaboratorio->ViewCustomAttributes = "";
// idhospital
$this->idhospital->ViewValue = $this->idhospital->CurrentValue;
$this->idhospital->ViewCustomAttributes = "";
// idmedicina
$this->idmedicina->LinkCustomAttributes = "";
$this->idmedicina->HrefValue = "";
$this->idmedicina->TooltipValue = "";
// descripcion
$this->descripcion->LinkCustomAttributes = "";
$this->descripcion->HrefValue = "";
$this->descripcion->TooltipValue = "";
// estado
$this->estado->LinkCustomAttributes = "";
$this->estado->HrefValue = "";
$this->estado->TooltipValue = "";
// idlaboratorio
$this->idlaboratorio->LinkCustomAttributes = "";
$this->idlaboratorio->HrefValue = "";
$this->idlaboratorio->TooltipValue = "";
// idhospital
$this->idhospital->LinkCustomAttributes = "";
$this->idhospital->HrefValue = "";
$this->idhospital->TooltipValue = "";
} elseif ($this->RowType == EW_ROWTYPE_SEARCH) {
// Search row
// idmedicina
$this->idmedicina->EditAttrs["class"] = "form-control";
$this->idmedicina->EditCustomAttributes = "";
$this->idmedicina->EditValue = ew_HtmlEncode($this->idmedicina->AdvancedSearch->SearchValue);
$this->idmedicina->PlaceHolder = ew_RemoveHtml($this->idmedicina->FldCaption());
// descripcion
$this->descripcion->EditAttrs["class"] = "form-control";
//.........这里部分代码省略.........