function LoadMultiUpdateValues() { $this->CurrentFilter = $this->GetKeyFilter(); // Load recordset if ($this->Recordset = $this->LoadRecordset()) { $i = 1; while (!$this->Recordset->EOF) { if ($i == 1) { $this->M_url->setDbValue($this->Recordset->fields('M_url')); } else { if (!ew_CompareValue($this->M_url->DbValue, $this->Recordset->fields('M_url'))) { $this->M_url->CurrentValue = NULL; } } $i++; $this->Recordset->MoveNext(); } $this->Recordset->Close(); } }
function WriteAuditTrailOnEdit(&$rsold, &$rsnew) { if (!$this->AuditTrailOnEdit) { return; } $table = 'socios'; // Get key value $key = ""; if ($key != "") { $key .= $GLOBALS["EW_COMPOSITE_KEY_SEPARATOR"]; } $key .= $rsold['socio_nro']; // Write Audit Trail $dt = ew_StdCurrentDateTime(); $id = ew_ScriptName(); $usr = CurrentUserID(); foreach (array_keys($rsnew) as $fldname) { if ($this->fields[$fldname]->FldDataType != EW_DATATYPE_BLOB) { // Ignore BLOB fields if ($this->fields[$fldname]->FldDataType == EW_DATATYPE_DATE) { // DateTime field $modified = ew_FormatDateTime($rsold[$fldname], 0) != ew_FormatDateTime($rsnew[$fldname], 0); } else { $modified = !ew_CompareValue($rsold[$fldname], $rsnew[$fldname]); } if ($modified) { if ($this->fields[$fldname]->FldDataType == EW_DATATYPE_MEMO) { // Memo field if (EW_AUDIT_TRAIL_TO_DATABASE) { $oldvalue = $rsold[$fldname]; $newvalue = $rsnew[$fldname]; } else { $oldvalue = "[MEMO]"; $newvalue = "[MEMO]"; } } elseif ($this->fields[$fldname]->FldDataType == EW_DATATYPE_XML) { // XML field $oldvalue = "[XML]"; $newvalue = "[XML]"; } else { $oldvalue = $rsold[$fldname]; $newvalue = $rsnew[$fldname]; } ew_WriteAuditTrail("log", $dt, $id, $usr, "U", $table, $fldname, $key, $oldvalue, $newvalue); } } } }
function ChkLvlBreak() { $this->LevelBreak[1] = FALSE; if ($this->RecCnt == 0) { // Start Or End of Recordset $this->LevelBreak[1] = TRUE; } else { if (!ew_CompareValue($this->dtime->CurrentValue, $this->ReportGroups[0])) { $this->LevelBreak[1] = TRUE; } } }
function ChkLvlBreak() { global $Kitchen_Report_22D2; $this->bLvlBreak[1] = FALSE; $this->bLvlBreak[2] = FALSE; $this->bLvlBreak[3] = FALSE; if ($this->lRecCnt == 0) { // Start Or End of Recordset $this->bLvlBreak[1] = TRUE; $this->bLvlBreak[2] = TRUE; $this->bLvlBreak[3] = TRUE; } else { if (!ew_CompareValue($Kitchen_Report_22D2->PublishedDate->CurrentValue, $this->vGrps[0])) { $this->bLvlBreak[1] = TRUE; $this->bLvlBreak[2] = TRUE; $this->bLvlBreak[3] = TRUE; } if (!ew_CompareValue($Kitchen_Report_22D2->DeliveryDate->CurrentValue, $this->vGrps[1])) { $this->bLvlBreak[2] = TRUE; $this->bLvlBreak[3] = TRUE; } if (!ew_CompareValue($Kitchen_Report_22D2->MenuName->CurrentValue, $this->vGrps[2])) { $this->bLvlBreak[3] = TRUE; } } }
function LoadMultiUpdateValues() { $this->CurrentFilter = $this->GetKeyFilter(); // Load recordset if ($this->Recordset = $this->LoadRecordset()) { $i = 1; while (!$this->Recordset->EOF) { if ($i == 1) { $this->detalle->setDbValue($this->Recordset->fields('detalle')); $this->fecha->setDbValue($this->Recordset->fields('fecha')); $this->id_tipo_gasto->setDbValue($this->Recordset->fields('id_tipo_gasto')); $this->id_hoja_mantenimeinto->setDbValue($this->Recordset->fields('id_hoja_mantenimeinto')); } else { if (!ew_CompareValue($this->detalle->DbValue, $this->Recordset->fields('detalle'))) { $this->detalle->CurrentValue = NULL; } if (!ew_CompareValue($this->fecha->DbValue, $this->Recordset->fields('fecha'))) { $this->fecha->CurrentValue = NULL; } if (!ew_CompareValue($this->id_tipo_gasto->DbValue, $this->Recordset->fields('id_tipo_gasto'))) { $this->id_tipo_gasto->CurrentValue = NULL; } if (!ew_CompareValue($this->id_hoja_mantenimeinto->DbValue, $this->Recordset->fields('id_hoja_mantenimeinto'))) { $this->id_hoja_mantenimeinto->CurrentValue = NULL; } } $i++; $this->Recordset->MoveNext(); } $this->Recordset->Close(); } }
function LoadMultiUpdateValues() { $this->CurrentFilter = $this->GetKeyFilter(); // Load recordset if ($this->Recordset = $this->LoadRecordset()) { $i = 1; while (!$this->Recordset->EOF) { if ($i == 1) { $this->fecha_ini->setDbValue($this->Recordset->fields('fecha_ini')); $this->fecha_fin->setDbValue($this->Recordset->fields('fecha_fin')); $this->id_vehiculo->setDbValue($this->Recordset->fields('id_vehiculo')); $this->id_taller->setDbValue($this->Recordset->fields('id_taller')); $this->id_tipo_mantenimiento->setDbValue($this->Recordset->fields('id_tipo_mantenimiento')); } else { if (!ew_CompareValue($this->fecha_ini->DbValue, $this->Recordset->fields('fecha_ini'))) { $this->fecha_ini->CurrentValue = NULL; } if (!ew_CompareValue($this->fecha_fin->DbValue, $this->Recordset->fields('fecha_fin'))) { $this->fecha_fin->CurrentValue = NULL; } if (!ew_CompareValue($this->id_vehiculo->DbValue, $this->Recordset->fields('id_vehiculo'))) { $this->id_vehiculo->CurrentValue = NULL; } if (!ew_CompareValue($this->id_taller->DbValue, $this->Recordset->fields('id_taller'))) { $this->id_taller->CurrentValue = NULL; } if (!ew_CompareValue($this->id_tipo_mantenimiento->DbValue, $this->Recordset->fields('id_tipo_mantenimiento'))) { $this->id_tipo_mantenimiento->CurrentValue = NULL; } } $i++; $this->Recordset->MoveNext(); } $this->Recordset->Close(); } }
function ChkLvlBreak() { global $Ingredients_Report; $this->bLvlBreak[1] = FALSE; $this->bLvlBreak[2] = FALSE; if ($this->lRecCnt == 0) { // Start Or End of Recordset $this->bLvlBreak[1] = TRUE; $this->bLvlBreak[2] = TRUE; } else { if (!ew_CompareValue($Ingredients_Report->PublishedDate->CurrentValue, $this->vGrps[0])) { $this->bLvlBreak[1] = TRUE; $this->bLvlBreak[2] = TRUE; } if (!ew_CompareValue($Ingredients_Report->DeliveryDate->CurrentValue, $this->vGrps[1])) { $this->bLvlBreak[2] = TRUE; } } }
function LoadMultiUpdateValues() { $this->CurrentFilter = $this->GetKeyFilter(); // Load recordset if ($this->Recordset = $this->LoadRecordset()) { $i = 1; while (!$this->Recordset->EOF) { if ($i == 1) { $this->codigo->setDbValue($this->Recordset->fields('codigo')); $this->usuario->setDbValue($this->Recordset->fields('usuario')); $this->contrasenia->setDbValue($this->Recordset->fields('contrasenia')); $this->nombre->setDbValue($this->Recordset->fields('nombre')); $this->_email->setDbValue($this->Recordset->fields('email')); $this->activo->setDbValue($this->Recordset->fields('activo')); } else { if (!ew_CompareValue($this->codigo->DbValue, $this->Recordset->fields('codigo'))) { $this->codigo->CurrentValue = NULL; } if (!ew_CompareValue($this->usuario->DbValue, $this->Recordset->fields('usuario'))) { $this->usuario->CurrentValue = NULL; } if (!ew_CompareValue($this->contrasenia->DbValue, $this->Recordset->fields('contrasenia'))) { $this->contrasenia->CurrentValue = NULL; } if (!ew_CompareValue($this->nombre->DbValue, $this->Recordset->fields('nombre'))) { $this->nombre->CurrentValue = NULL; } if (!ew_CompareValue($this->_email->DbValue, $this->Recordset->fields('email'))) { $this->_email->CurrentValue = NULL; } if (!ew_CompareValue($this->activo->DbValue, $this->Recordset->fields('activo'))) { $this->activo->CurrentValue = NULL; } } $i++; $this->Recordset->MoveNext(); } $this->Recordset->Close(); } }
function LoadMultiUpdateValues() { $this->CurrentFilter = $this->GetKeyFilter(); // Load recordset if ($this->Recordset = $this->LoadRecordset()) { $i = 1; while (!$this->Recordset->EOF) { if ($i == 1) { $this->cuit_cuil->setDbValue($this->Recordset->fields('cuit_cuil')); $this->id_actividad->setDbValue($this->Recordset->fields('id_actividad')); $this->propietario->setDbValue($this->Recordset->fields('propietario')); $this->comercio->setDbValue($this->Recordset->fields('comercio')); $this->direccion_comercio->setDbValue($this->Recordset->fields('direccion_comercio')); $this->mail->setDbValue($this->Recordset->fields('mail')); $this->tel->setDbValue($this->Recordset->fields('tel')); $this->cel->setDbValue($this->Recordset->fields('cel')); $this->activo->setDbValue($this->Recordset->fields('activo')); } else { if (!ew_CompareValue($this->cuit_cuil->DbValue, $this->Recordset->fields('cuit_cuil'))) { $this->cuit_cuil->CurrentValue = NULL; } if (!ew_CompareValue($this->id_actividad->DbValue, $this->Recordset->fields('id_actividad'))) { $this->id_actividad->CurrentValue = NULL; } if (!ew_CompareValue($this->propietario->DbValue, $this->Recordset->fields('propietario'))) { $this->propietario->CurrentValue = NULL; } if (!ew_CompareValue($this->comercio->DbValue, $this->Recordset->fields('comercio'))) { $this->comercio->CurrentValue = NULL; } if (!ew_CompareValue($this->direccion_comercio->DbValue, $this->Recordset->fields('direccion_comercio'))) { $this->direccion_comercio->CurrentValue = NULL; } if (!ew_CompareValue($this->mail->DbValue, $this->Recordset->fields('mail'))) { $this->mail->CurrentValue = NULL; } if (!ew_CompareValue($this->tel->DbValue, $this->Recordset->fields('tel'))) { $this->tel->CurrentValue = NULL; } if (!ew_CompareValue($this->cel->DbValue, $this->Recordset->fields('cel'))) { $this->cel->CurrentValue = NULL; } if (!ew_CompareValue($this->activo->DbValue, $this->Recordset->fields('activo'))) { $this->activo->CurrentValue = NULL; } } $i++; $this->Recordset->MoveNext(); } $this->Recordset->Close(); } }