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