function AddRow($rsold = NULL)
{
global $conn, $Language, $Security;
// Load db values from rsold
if ($rsold) {
$this->LoadDbValues($rsold);
$this->g_image->OldUploadPath = "/gallery";
$this->g_image->UploadPath = $this->g_image->OldUploadPath;
$this->gd_images->OldUploadPath = "/gallery";
$this->gd_images->UploadPath = $this->gd_images->OldUploadPath;
}
$rsnew = array();
// g_name
$this->g_name->SetDbValueDef($rsnew, $this->g_name->CurrentValue, "", FALSE);
// g_image
if (!$this->g_image->Upload->KeepFile) {
if ($this->g_image->Upload->FileName == "") {
$rsnew['g_image'] = NULL;
} else {
$rsnew['g_image'] = $this->g_image->Upload->FileName;
}
}
// gd_images
if (!$this->gd_images->Upload->KeepFile) {
if ($this->gd_images->Upload->FileName == "") {
$rsnew['gd_images'] = NULL;
} else {
$rsnew['gd_images'] = $this->gd_images->Upload->FileName;
}
}
if (!$this->g_image->Upload->KeepFile) {
$this->g_image->UploadPath = "/gallery";
if (!ew_Empty($this->g_image->Upload->Value)) {
$rsnew['g_image'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->g_image->UploadPath), $rsnew['g_image']);
// Get new file name
}
}
if (!$this->gd_images->Upload->KeepFile) {
$this->gd_images->UploadPath = "/gallery";
$OldFiles = explode(",", $this->gd_images->Upload->DbValue);
if (!ew_Empty($this->gd_images->Upload->FileName)) {
$NewFiles = explode(",", $this->gd_images->Upload->FileName);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->gd_images->Upload->Index < 0 ? $this->gd_images->FldVar : substr($this->gd_images->FldVar, 0, 1) . $this->gd_images->Upload->Index . substr($this->gd_images->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $NewFiles[$i];
if (file_exists($file)) {
if (!in_array($NewFiles[$i], $OldFiles)) {
$NewFiles[$i] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->gd_images->UploadPath), $NewFiles[$i]);
// Get new file name
$file1 = ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $NewFiles[$i];
if ($file1 != $file) {
// Rename temp file
rename($file, $file1);
}
}
}
}
}
$this->gd_images->Upload->FileName = implode(",", $NewFiles);
$rsnew['gd_images'] = $this->gd_images->Upload->FileName;
} else {
$NewFiles = array();
}
}
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
if (!$this->g_image->Upload->KeepFile) {
if (!ew_Empty($this->g_image->Upload->Value)) {
$this->g_image->Upload->SaveToFile($this->g_image->UploadPath, $rsnew['g_image'], TRUE);
}
}
if (!$this->gd_images->Upload->KeepFile) {
$OldFiles = explode(",", $this->gd_images->Upload->DbValue);
if (!ew_Empty($this->gd_images->Upload->FileName)) {
$NewFiles = explode(",", $this->gd_images->Upload->FileName);
$NewFiles2 = explode(",", $rsnew['gd_images']);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->gd_images->Upload->Index < 0 ? $this->gd_images->FldVar : substr($this->gd_images->FldVar, 0, 1) . $this->gd_images->Upload->Index . substr($this->gd_images->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $NewFiles[$i];
if (file_exists($file)) {
$this->gd_images->Upload->Value = file_get_contents($file);
$this->gd_images->Upload->SaveToFile($this->gd_images->UploadPath, @$NewFiles2[$i] != "" ? $NewFiles2[$i] : $NewFiles[$i], TRUE);
// Just replace
}
}
}
} else {
$NewFiles = array();
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
// Get insert id if necessary
if ($AddRow) {
$this->gd_id->setDbValue($conn->Insert_ID());
$rsnew['gd_id'] = $this->gd_id->DbValue;
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// g_image
ew_CleanUploadTempPath($this->g_image, $this->g_image->Upload->Index);
// gd_images
ew_CleanUploadTempPath($this->gd_images, $this->gd_images->Upload->Index);
return $AddRow;
}
function SaveToFile($Path, $NewFileName, $OverWrite)
{
if (!ew_Empty($this->Value)) {
$Path = ew_UploadPathEx(TRUE, $Path);
if (trim(strval($NewFileName)) == "") {
$NewFileName = $this->FileName;
}
if ($OverWrite) {
return ew_SaveFile($Path, $NewFileName, $this->Value);
} else {
return ew_SaveFile($Path, ew_UploadFileNameEx($Path, $NewFileName), $this->Value);
}
}
return FALSE;
}
function EditRow()
{
global $conn, $Security, $Language;
$sFilter = $this->KeyFilter();
$this->CurrentFilter = $sFilter;
$sSql = $this->SQL();
$conn->raiseErrorFn = 'ew_ErrorFn';
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$EditRow = FALSE;
// Update Failed
} else {
// Begin transaction
if ($this->getCurrentDetailTable() != "") {
$conn->BeginTrans();
}
// Save old values
$rsold =& $rs->fields;
$this->LoadDbValues($rsold);
$rsnew = array();
// Titulo
$this->Titulo->SetDbValueDef($rsnew, $this->Titulo->CurrentValue, NULL, $this->Titulo->ReadOnly);
// Descripcion
$this->Descripcion->SetDbValueDef($rsnew, $this->Descripcion->CurrentValue, NULL, $this->Descripcion->ReadOnly);
// archivo
if (!$this->archivo->ReadOnly && !$this->archivo->Upload->KeepFile) {
$this->archivo->Upload->DbValue = $rsold['archivo'];
// Get original value
if ($this->archivo->Upload->FileName == "") {
$rsnew['archivo'] = NULL;
} else {
$rsnew['archivo'] = $this->archivo->Upload->FileName;
}
}
// estado
$this->estado->SetDbValueDef($rsnew, $this->estado->CurrentValue, NULL, $this->estado->ReadOnly);
if (!$this->archivo->Upload->KeepFile) {
$OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->DbValue);
if (!ew_Empty($this->archivo->Upload->FileName)) {
$NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->FileName);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->archivo->Upload->Index < 0 ? $this->archivo->FldVar : substr($this->archivo->FldVar, 0, 1) . $this->archivo->Upload->Index . substr($this->archivo->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = $NewFiles[$i];
if (file_exists(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file)) {
if (!in_array($file, $OldFiles)) {
$file1 = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->archivo->UploadPath), $file);
// Get new file name
if ($file1 != $file) {
// Rename temp file
while (file_exists(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file1)) {
// Make sure did not clash with existing upload file
$file1 = ew_UniqueFilename(ew_UploadPathEx(TRUE, $this->archivo->UploadPath), $file1, TRUE);
}
// Use indexed name
rename(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file, ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file1);
$NewFiles[$i] = $file1;
}
}
}
}
}
$this->archivo->Upload->FileName = implode(EW_MULTIPLE_UPLOAD_SEPARATOR, $NewFiles);
$rsnew['archivo'] = $this->archivo->Upload->FileName;
} else {
$NewFiles = array();
}
}
// Call Row Updating event
$bUpdateRow = $this->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
if (count($rsnew) > 0) {
$EditRow = $this->Update($rsnew, "", $rsold);
} else {
$EditRow = TRUE;
}
// No field to update
$conn->raiseErrorFn = '';
if ($EditRow) {
if (!$this->archivo->Upload->KeepFile) {
$OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->DbValue);
if (!ew_Empty($this->archivo->Upload->FileName)) {
$NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->FileName);
$NewFiles2 = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $rsnew['archivo']);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->archivo->Upload->Index < 0 ? $this->archivo->FldVar : substr($this->archivo->FldVar, 0, 1) . $this->archivo->Upload->Index . substr($this->archivo->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $NewFiles[$i];
if (file_exists($file)) {
$this->archivo->Upload->SaveToFile($this->archivo->UploadPath, @$NewFiles2[$i] != "" ? $NewFiles2[$i] : $NewFiles[$i], TRUE, $i);
// Just replace
}
}
}
} else {
$NewFiles = array();
}
$FileCount = count($OldFiles);
for ($i = 0; $i < $FileCount; $i++) {
if ($OldFiles[$i] != "" && !in_array($OldFiles[$i], $NewFiles)) {
@unlink(ew_UploadPathEx(TRUE, $this->archivo->OldUploadPath) . $OldFiles[$i]);
}
}
}
}
// Update detail records
if ($EditRow) {
$DetailTblVar = explode(",", $this->getCurrentDetailTable());
if (in_array("seguimiento_tramites", $DetailTblVar) && $GLOBALS["seguimiento_tramites"]->DetailEdit) {
if (!isset($GLOBALS["seguimiento_tramites_grid"])) {
$GLOBALS["seguimiento_tramites_grid"] = new cseguimiento_tramites_grid();
}
// Get detail page object
$EditRow = $GLOBALS["seguimiento_tramites_grid"]->GridUpdate();
}
}
// Commit/Rollback transaction
if ($this->getCurrentDetailTable() != "") {
if ($EditRow) {
$conn->CommitTrans();
// Commit transaction
} else {
$conn->RollbackTrans();
// Rollback transaction
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("UpdateCancelled"));
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$this->Row_Updated($rsold, $rsnew);
}
$rs->Close();
// archivo
ew_CleanUploadTempPath($this->archivo, $this->archivo->Upload->Index);
return $EditRow;
}
function AddRow($rsold = NULL)
{
global $conn, $Language, $Security;
// Load db values from rsold
if ($rsold) {
$this->LoadDbValues($rsold);
$this->g_image->OldUploadPath = "/gallery";
$this->g_image->UploadPath = $this->g_image->OldUploadPath;
$this->gd_images->OldUploadPath = "/gallery";
$this->gd_images->UploadPath = $this->gd_images->OldUploadPath;
}
$rsnew = array();
// g_name
$this->g_name->SetDbValueDef($rsnew, $this->g_name->CurrentValue, "", FALSE);
// g_image
if (!$this->g_image->Upload->KeepFile) {
if ($this->g_image->Upload->FileName == "") {
$rsnew['g_image'] = NULL;
} else {
$rsnew['g_image'] = $this->g_image->Upload->FileName;
}
}
if (!$this->g_image->Upload->KeepFile) {
$this->g_image->UploadPath = "/gallery";
if (!ew_Empty($this->g_image->Upload->Value)) {
$rsnew['g_image'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->g_image->UploadPath), $rsnew['g_image']);
// Get new file name
}
}
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
if (!$this->g_image->Upload->KeepFile) {
if (!ew_Empty($this->g_image->Upload->Value)) {
$this->g_image->Upload->SaveToFile($this->g_image->UploadPath, $rsnew['g_image'], TRUE);
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
// Get insert id if necessary
if ($AddRow) {
$this->gd_id->setDbValue($conn->Insert_ID());
$rsnew['gd_id'] = $this->gd_id->DbValue;
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// g_image
ew_CleanUploadTempPath($this->g_image, $this->g_image->Upload->Index);
return $AddRow;
}
function SaveToFile($Path, $NewFileName, $OverWrite, $idx = -1)
{
if (!ew_Empty($this->Value)) {
$Path = ew_UploadPathEx(TRUE, $Path);
if (trim(strval($NewFileName)) == "") {
$NewFileName = $this->FileName;
}
if (!$OverWrite) {
$NewFileName = ew_UploadFileNameEx($Path, $NewFileName);
}
return ew_SaveFile($Path, $NewFileName, $this->Value);
} elseif ($idx >= 0) {
// Use file from upload temp folder
$file = $this->GetTempFile($idx);
if (file_exists($file)) {
if (!$OverWrite) {
$NewFileName = ew_UploadFileNameEx($Path, $NewFileName);
}
return ew_CopyFile($Path, $NewFileName, $file);
}
}
return FALSE;
}
function EditRow()
{
global $Security, $Language;
$sFilter = $this->KeyFilter();
$sFilter = $this->ApplyUserIDFilters($sFilter);
$conn =& $this->Connection();
$this->CurrentFilter = $sFilter;
$sSql = $this->SQL();
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$this->setFailureMessage($Language->Phrase("NoRecord"));
// Set no record message
$EditRow = FALSE;
// Update Failed
} else {
// Save old values
$rsold =& $rs->fields;
$this->LoadDbValues($rsold);
$this->s_image->OldUploadPath = "/uploads/";
$this->s_image->UploadPath = $this->s_image->OldUploadPath;
$this->s_images->OldUploadPath = "/uploads/";
$this->s_images->UploadPath = $this->s_images->OldUploadPath;
$rsnew = array();
// s_title
$this->s_title->SetDbValueDef($rsnew, $this->s_title->CurrentValue, "", $this->s_title->ReadOnly);
// s_image
if (!$this->s_image->ReadOnly && !$this->s_image->Upload->KeepFile) {
$this->s_image->Upload->DbValue = $rsold['s_image'];
// Get original value
if ($this->s_image->Upload->FileName == "") {
$rsnew['s_image'] = NULL;
} else {
$rsnew['s_image'] = $this->s_image->Upload->FileName;
}
}
// s_desc
$this->s_desc->SetDbValueDef($rsnew, $this->s_desc->CurrentValue, "", $this->s_desc->ReadOnly);
// s_longdesc
$this->s_longdesc->SetDbValueDef($rsnew, $this->s_longdesc->CurrentValue, "", $this->s_longdesc->ReadOnly);
// s_images
if (!$this->s_images->ReadOnly && !$this->s_images->Upload->KeepFile) {
$this->s_images->Upload->DbValue = $rsold['s_images'];
// Get original value
if ($this->s_images->Upload->FileName == "") {
$rsnew['s_images'] = NULL;
} else {
$rsnew['s_images'] = $this->s_images->Upload->FileName;
}
}
// s_caption
$this->s_caption->SetDbValueDef($rsnew, $this->s_caption->CurrentValue, "", $this->s_caption->ReadOnly);
if (!$this->s_image->Upload->KeepFile) {
$this->s_image->UploadPath = "/uploads/";
if (!ew_Empty($this->s_image->Upload->Value)) {
$rsnew['s_image'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->s_image->UploadPath), $rsnew['s_image']);
// Get new file name
}
}
if (!$this->s_images->Upload->KeepFile) {
$this->s_images->UploadPath = "/uploads/";
$OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->s_images->Upload->DbValue);
if (!ew_Empty($this->s_images->Upload->FileName)) {
$NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->s_images->Upload->FileName);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->s_images->Upload->Index < 0 ? $this->s_images->FldVar : substr($this->s_images->FldVar, 0, 1) . $this->s_images->Upload->Index . substr($this->s_images->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = $NewFiles[$i];
if (file_exists(ew_UploadTempPath($fldvar, $this->s_images->TblVar) . EW_PATH_DELIMITER . $file)) {
if (!in_array($file, $OldFiles)) {
$file1 = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->s_images->UploadPath), $file);
// Get new file name
if ($file1 != $file) {
// Rename temp file
while (file_exists(ew_UploadTempPath($fldvar, $this->s_images->TblVar) . EW_PATH_DELIMITER . $file1)) {
// Make sure did not clash with existing upload file
$file1 = ew_UniqueFilename(ew_UploadPathEx(TRUE, $this->s_images->UploadPath), $file1, TRUE);
}
// Use indexed name
rename(ew_UploadTempPath($fldvar, $this->s_images->TblVar) . EW_PATH_DELIMITER . $file, ew_UploadTempPath($fldvar, $this->s_images->TblVar) . EW_PATH_DELIMITER . $file1);
$NewFiles[$i] = $file1;
}
}
}
}
}
$this->s_images->Upload->FileName = implode(EW_MULTIPLE_UPLOAD_SEPARATOR, $NewFiles);
$rsnew['s_images'] = $this->s_images->Upload->FileName;
} else {
$NewFiles = array();
}
}
// Call Row Updating event
$bUpdateRow = $this->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
if (count($rsnew) > 0) {
$EditRow = $this->Update($rsnew, "", $rsold);
} else {
$EditRow = TRUE;
}
// No field to update
$conn->raiseErrorFn = '';
if ($EditRow) {
if (!$this->s_image->Upload->KeepFile) {
if (!ew_Empty($this->s_image->Upload->Value)) {
$this->s_image->Upload->SaveToFile($this->s_image->UploadPath, $rsnew['s_image'], TRUE);
}
}
if (!$this->s_images->Upload->KeepFile) {
$OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->s_images->Upload->DbValue);
if (!ew_Empty($this->s_images->Upload->FileName)) {
$NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->s_images->Upload->FileName);
$NewFiles2 = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $rsnew['s_images']);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->s_images->Upload->Index < 0 ? $this->s_images->FldVar : substr($this->s_images->FldVar, 0, 1) . $this->s_images->Upload->Index . substr($this->s_images->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = ew_UploadTempPath($fldvar, $this->s_images->TblVar) . EW_PATH_DELIMITER . $NewFiles[$i];
if (file_exists($file)) {
$this->s_images->Upload->SaveToFile($this->s_images->UploadPath, @$NewFiles2[$i] != "" ? $NewFiles2[$i] : $NewFiles[$i], TRUE, $i);
// Just replace
}
}
}
} else {
$NewFiles = array();
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("UpdateCancelled"));
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$this->Row_Updated($rsold, $rsnew);
}
$rs->Close();
// s_image
ew_CleanUploadTempPath($this->s_image, $this->s_image->Upload->Index);
// s_images
ew_CleanUploadTempPath($this->s_images, $this->s_images->Upload->Index);
return $EditRow;
}
function EditRow()
{
global $conn, $Security, $Language;
$sFilter = $this->KeyFilter();
$this->CurrentFilter = $sFilter;
$sSql = $this->SQL();
$conn->raiseErrorFn = 'ew_ErrorFn';
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$EditRow = FALSE;
// Update Failed
} else {
// Save old values
$rsold =& $rs->fields;
$this->LoadDbValues($rsold);
$rsnew = array();
// fecha_recepcion
$this->fecha_recepcion->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->fecha_recepcion->CurrentValue, 7), ew_CurrentDate(), $this->fecha_recepcion->ReadOnly);
// cliente
$this->cliente->SetDbValueDef($rsnew, $this->cliente->CurrentValue, NULL, $this->cliente->ReadOnly);
// id_tipo_cliente
$this->id_tipo_cliente->SetDbValueDef($rsnew, $this->id_tipo_cliente->CurrentValue, NULL, $this->id_tipo_cliente->ReadOnly);
// tel
$this->tel->SetDbValueDef($rsnew, $this->tel->CurrentValue, NULL, $this->tel->ReadOnly);
// cel
$this->cel->SetDbValueDef($rsnew, $this->cel->CurrentValue, NULL, $this->cel->ReadOnly);
// objetos
$this->objetos->SetDbValueDef($rsnew, $this->objetos->CurrentValue, NULL, $this->objetos->ReadOnly);
// detalle_a_realizar
$this->detalle_a_realizar->SetDbValueDef($rsnew, $this->detalle_a_realizar->CurrentValue, NULL, $this->detalle_a_realizar->ReadOnly);
// fecha_entrega
$this->fecha_entrega->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->fecha_entrega->CurrentValue, 7), NULL, $this->fecha_entrega->ReadOnly);
// observaciones
$this->observaciones->SetDbValueDef($rsnew, $this->observaciones->CurrentValue, NULL, $this->observaciones->ReadOnly);
// id_estado
$this->id_estado->SetDbValueDef($rsnew, $this->id_estado->CurrentValue, 0, $this->id_estado->ReadOnly);
// precio
$this->precio->SetDbValueDef($rsnew, $this->precio->CurrentValue, NULL, $this->precio->ReadOnly);
// entrega
$this->entrega->SetDbValueDef($rsnew, $this->entrega->CurrentValue, NULL, $this->entrega->ReadOnly);
// foto1
if (!$this->foto1->ReadOnly && !$this->foto1->Upload->KeepFile) {
$this->foto1->Upload->DbValue = $rs->fields('foto1');
// Get original value
if ($this->foto1->Upload->FileName == "") {
$rsnew['foto1'] = NULL;
} else {
$rsnew['foto1'] = $this->foto1->Upload->FileName;
}
}
// foto2
if (!$this->foto2->ReadOnly && !$this->foto2->Upload->KeepFile) {
$this->foto2->Upload->DbValue = $rs->fields('foto2');
// Get original value
if ($this->foto2->Upload->FileName == "") {
$rsnew['foto2'] = NULL;
} else {
$rsnew['foto2'] = $this->foto2->Upload->FileName;
}
}
if (!$this->foto1->Upload->KeepFile) {
if (!ew_Empty($this->foto1->Upload->Value)) {
if ($this->foto1->Upload->FileName == $this->foto1->Upload->DbValue) {
// Overwrite if same file name
$this->foto1->Upload->DbValue = "";
// No need to delete any more
} else {
$rsnew['foto1'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->foto1->UploadPath), $rsnew['foto1']);
// Get new file name
}
}
}
if (!$this->foto2->Upload->KeepFile) {
if (!ew_Empty($this->foto2->Upload->Value)) {
if ($this->foto2->Upload->FileName == $this->foto2->Upload->DbValue) {
// Overwrite if same file name
$this->foto2->Upload->DbValue = "";
// No need to delete any more
} else {
$rsnew['foto2'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->foto2->UploadPath), $rsnew['foto2']);
// Get new file name
}
}
}
// Call Row Updating event
$bUpdateRow = $this->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
if (count($rsnew) > 0) {
$EditRow = $this->Update($rsnew, "", $rsold);
} else {
$EditRow = TRUE;
}
// No field to update
$conn->raiseErrorFn = '';
if ($EditRow) {
if (!$this->foto1->Upload->KeepFile) {
if (!ew_Empty($this->foto1->Upload->Value)) {
$this->foto1->Upload->SaveToFile($this->foto1->UploadPath, $rsnew['foto1'], TRUE);
}
if ($this->foto1->Upload->DbValue != "") {
@unlink(ew_UploadPathEx(TRUE, $this->foto1->OldUploadPath) . $this->foto1->Upload->DbValue);
}
}
if (!$this->foto2->Upload->KeepFile) {
if (!ew_Empty($this->foto2->Upload->Value)) {
$this->foto2->Upload->SaveToFile($this->foto2->UploadPath, $rsnew['foto2'], TRUE);
}
if ($this->foto2->Upload->DbValue != "") {
@unlink(ew_UploadPathEx(TRUE, $this->foto2->OldUploadPath) . $this->foto2->Upload->DbValue);
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("UpdateCancelled"));
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$this->Row_Updated($rsold, $rsnew);
}
$rs->Close();
// foto1
ew_CleanUploadTempPath($this->foto1, $this->foto1->Upload->Index);
// foto2
ew_CleanUploadTempPath($this->foto2, $this->foto2->Upload->Index);
return $EditRow;
}
function AddRow($rsold = NULL)
{
global $conn, $Language, $Security;
// Load db values from rsold
if ($rsold) {
$this->LoadDbValues($rsold);
}
$rsnew = array();
// Titulo
$this->Titulo->SetDbValueDef($rsnew, $this->Titulo->CurrentValue, NULL, FALSE);
// fecha
$this->fecha->SetDbValueDef($rsnew, ew_CurrentDate(), NULL);
$rsnew['fecha'] =& $this->fecha->DbValue;
// archivo
if (!$this->archivo->Upload->KeepFile) {
$this->archivo->Upload->DbValue = "";
// No need to delete old file
if ($this->archivo->Upload->FileName == "") {
$rsnew['archivo'] = NULL;
} else {
$rsnew['archivo'] = $this->archivo->Upload->FileName;
}
}
// estado
$this->estado->SetDbValueDef($rsnew, $this->estado->CurrentValue, NULL, FALSE);
if (!$this->archivo->Upload->KeepFile) {
$OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->DbValue);
if (!ew_Empty($this->archivo->Upload->FileName)) {
$NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->FileName);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->archivo->Upload->Index < 0 ? $this->archivo->FldVar : substr($this->archivo->FldVar, 0, 1) . $this->archivo->Upload->Index . substr($this->archivo->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = $NewFiles[$i];
if (file_exists(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file)) {
if (!in_array($file, $OldFiles)) {
$file1 = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->archivo->UploadPath), $file);
// Get new file name
if ($file1 != $file) {
// Rename temp file
while (file_exists(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file1)) {
// Make sure did not clash with existing upload file
$file1 = ew_UniqueFilename(ew_UploadPathEx(TRUE, $this->archivo->UploadPath), $file1, TRUE);
}
// Use indexed name
rename(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file, ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file1);
$NewFiles[$i] = $file1;
}
}
}
}
}
$this->archivo->Upload->FileName = implode(EW_MULTIPLE_UPLOAD_SEPARATOR, $NewFiles);
$rsnew['archivo'] = $this->archivo->Upload->FileName;
} else {
$NewFiles = array();
}
}
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
if (!$this->archivo->Upload->KeepFile) {
$OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->DbValue);
if (!ew_Empty($this->archivo->Upload->FileName)) {
$NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->FileName);
$NewFiles2 = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $rsnew['archivo']);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->archivo->Upload->Index < 0 ? $this->archivo->FldVar : substr($this->archivo->FldVar, 0, 1) . $this->archivo->Upload->Index . substr($this->archivo->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $NewFiles[$i];
if (file_exists($file)) {
$this->archivo->Upload->SaveToFile($this->archivo->UploadPath, @$NewFiles2[$i] != "" ? $NewFiles2[$i] : $NewFiles[$i], TRUE, $i);
// Just replace
}
}
}
} else {
$NewFiles = array();
}
$FileCount = count($OldFiles);
for ($i = 0; $i < $FileCount; $i++) {
if ($OldFiles[$i] != "" && !in_array($OldFiles[$i], $NewFiles)) {
@unlink(ew_UploadPathEx(TRUE, $this->archivo->OldUploadPath) . $OldFiles[$i]);
}
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
// Get insert id if necessary
if ($AddRow) {
$this->codigo->setDbValue($conn->Insert_ID());
$rsnew['codigo'] = $this->codigo->DbValue;
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// archivo
ew_CleanUploadTempPath($this->archivo, $this->archivo->Upload->Index);
return $AddRow;
}
function AddRow($rsold = NULL)
{
global $Language, $Security;
// Set up foreign key field value from Session
if ($this->getCurrentMasterTable() == "sub_category") {
$this->scat_id->CurrentValue = $this->scat_id->getSessionValue();
}
$conn =& $this->Connection();
// Load db values from rsold
if ($rsold) {
$this->LoadDbValues($rsold);
}
$rsnew = array();
// category_id
$this->category_id->SetDbValueDef($rsnew, $this->category_id->CurrentValue, 0, FALSE);
// scat_id
$this->scat_id->SetDbValueDef($rsnew, $this->scat_id->CurrentValue, 0, FALSE);
// product_name
$this->product_name->SetDbValueDef($rsnew, $this->product_name->CurrentValue, "", FALSE);
// product_image
if (!$this->product_image->Upload->KeepFile) {
$this->product_image->Upload->DbValue = "";
// No need to delete old file
if ($this->product_image->Upload->FileName == "") {
$rsnew['product_image'] = NULL;
} else {
$rsnew['product_image'] = $this->product_image->Upload->FileName;
}
}
// product_secimage
if (!$this->product_secimage->Upload->KeepFile) {
$this->product_secimage->Upload->DbValue = "";
// No need to delete old file
if ($this->product_secimage->Upload->FileName == "") {
$rsnew['product_secimage'] = NULL;
} else {
$rsnew['product_secimage'] = $this->product_secimage->Upload->FileName;
}
}
if (!$this->product_image->Upload->KeepFile) {
if (!ew_Empty($this->product_image->Upload->Value)) {
if ($this->product_image->Upload->FileName == $this->product_image->Upload->DbValue) {
// Overwrite if same file name
$this->product_image->Upload->DbValue = "";
// No need to delete any more
} else {
$rsnew['product_image'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->product_image->UploadPath), $rsnew['product_image']);
// Get new file name
}
}
}
if (!$this->product_secimage->Upload->KeepFile) {
if (!ew_Empty($this->product_secimage->Upload->Value)) {
if ($this->product_secimage->Upload->FileName == $this->product_secimage->Upload->DbValue) {
// Overwrite if same file name
$this->product_secimage->Upload->DbValue = "";
// No need to delete any more
} else {
$rsnew['product_secimage'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->product_secimage->UploadPath), $rsnew['product_secimage']);
// Get new file name
}
}
}
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
// Get insert id if necessary
$this->product_id->setDbValue($conn->Insert_ID());
$rsnew['product_id'] = $this->product_id->DbValue;
if (!$this->product_image->Upload->KeepFile) {
if (!ew_Empty($this->product_image->Upload->Value)) {
$this->product_image->Upload->SaveToFile($this->product_image->UploadPath, $rsnew['product_image'], TRUE);
}
if ($this->product_image->Upload->DbValue != "") {
@unlink(ew_UploadPathEx(TRUE, $this->product_image->OldUploadPath) . $this->product_image->Upload->DbValue);
}
}
if (!$this->product_secimage->Upload->KeepFile) {
if (!ew_Empty($this->product_secimage->Upload->Value)) {
$this->product_secimage->Upload->SaveToFile($this->product_secimage->UploadPath, $rsnew['product_secimage'], TRUE);
}
if ($this->product_secimage->Upload->DbValue != "") {
@unlink(ew_UploadPathEx(TRUE, $this->product_secimage->OldUploadPath) . $this->product_secimage->Upload->DbValue);
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// product_image
ew_CleanUploadTempPath($this->product_image, $this->product_image->Upload->Index);
// product_secimage
ew_CleanUploadTempPath($this->product_secimage, $this->product_secimage->Upload->Index);
return $AddRow;
}
function EditRow()
{
global $conn, $Security, $ItemDetails;
$sFilter = $ItemDetails->KeyFilter();
$ItemDetails->CurrentFilter = $sFilter;
$sSql = $ItemDetails->SQL();
$conn->raiseErrorFn = 'ew_ErrorFn';
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$EditRow = FALSE;
// Update Failed
} else {
// Save old values
$rsold =& $rs->fields;
$rsnew = array();
// Field ItemID
// Field Time_to_Table
$ItemDetails->Time_to_Table->SetDbValueDef($ItemDetails->Time_to_Table->CurrentValue, NULL);
$rsnew['Time_to_Table'] =& $ItemDetails->Time_to_Table->DbValue;
// Field Level_Of_Difficulty
$ItemDetails->Level_Of_Difficulty->SetDbValueDef($ItemDetails->Level_Of_Difficulty->CurrentValue, NULL);
$rsnew['Level_Of_Difficulty'] =& $ItemDetails->Level_Of_Difficulty->DbValue;
// Field Beverage_Pairing
$ItemDetails->Beverage_Pairing->SetDbValueDef($ItemDetails->Beverage_Pairing->CurrentValue, NULL);
$rsnew['Beverage_Pairing'] =& $ItemDetails->Beverage_Pairing->DbValue;
// Field Vegetarian_Subsitution
$ItemDetails->Vegetarian_Subsitution->SetDbValueDef($ItemDetails->Vegetarian_Subsitution->CurrentValue, NULL);
$rsnew['Vegetarian_Subsitution'] =& $ItemDetails->Vegetarian_Subsitution->DbValue;
// Field Calories
$ItemDetails->Calories->SetDbValueDef($ItemDetails->Calories->CurrentValue, NULL);
$rsnew['Calories'] =& $ItemDetails->Calories->DbValue;
// Field Other
$ItemDetails->Other->SetDbValueDef($ItemDetails->Other->CurrentValue, NULL);
$rsnew['Other'] =& $ItemDetails->Other->DbValue;
// Field Image
$ItemDetails->Image->Upload->SaveToSession();
// Save file value to Session
if ($ItemDetails->Image->Upload->Action == "2" || $ItemDetails->Image->Upload->Action == "3") {
// Update/Remove
$ItemDetails->Image->Upload->DbValue = $rs->fields('Image');
// Get original value
if (is_null($ItemDetails->Image->Upload->Value)) {
$rsnew['Image'] = NULL;
} else {
$rsnew['Image'] = ew_UploadFileNameEx(ew_UploadPathEx(True, "../images/items/"), $ItemDetails->Image->Upload->FileName);
}
}
// Call Row Updating event
$bUpdateRow = $ItemDetails->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
// Field Image
if (!is_null($ItemDetails->Image->Upload->Value)) {
$ItemDetails->Image->Upload->SaveToFile("../images/items/", $rsnew['Image'], FALSE);
}
$conn->raiseErrorFn = 'ew_ErrorFn';
$EditRow = $conn->Execute($ItemDetails->UpdateSQL($rsnew));
$conn->raiseErrorFn = '';
} else {
if ($ItemDetails->CancelMessage != "") {
$this->setMessage($ItemDetails->CancelMessage);
$ItemDetails->CancelMessage = "";
} else {
$this->setMessage("Update cancelled");
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$ItemDetails->Row_Updated($rsold, $rsnew);
}
$rs->Close();
// Field Image
$ItemDetails->Image->Upload->RemoveFromSession();
// Remove file value from Session
return $EditRow;
}
function EditRow()
{
global $conn, $Security, $Language;
$sFilter = $this->KeyFilter();
$this->CurrentFilter = $sFilter;
$sSql = $this->SQL();
$conn->raiseErrorFn = 'ew_ErrorFn';
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$EditRow = FALSE;
// Update Failed
} else {
// Save old values
$rsold =& $rs->fields;
$rsnew = array();
// teacher_name
$this->teacher_name->SetDbValueDef($rsnew, $this->teacher_name->CurrentValue, NULL, $this->teacher_name->ReadOnly);
// teacher_personal_page
$this->teacher_personal_page->SetDbValueDef($rsnew, $this->teacher_personal_page->CurrentValue, NULL, $this->teacher_personal_page->ReadOnly);
// teacher_avatar
if (!$this->teacher_avatar->ReadOnly) {
$this->teacher_avatar->UploadPath = 'themes\\classic\\assets\\img\\Teacher_img';
if ($this->teacher_avatar->Upload->Action == "1") {
// Keep
} elseif ($this->teacher_avatar->Upload->Action == "2" || $this->teacher_avatar->Upload->Action == "3") {
// Update/Remove
$this->teacher_avatar->Upload->DbValue = $rs->fields('teacher_avatar');
// Get original value
if (is_null($this->teacher_avatar->Upload->Value)) {
$rsnew['teacher_avatar'] = NULL;
} else {
$rsnew['teacher_avatar'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->teacher_avatar->UploadPath), $this->teacher_avatar->Upload->FileName);
}
}
}
// teacher_description
$this->teacher_description->SetDbValueDef($rsnew, $this->teacher_description->CurrentValue, NULL, $this->teacher_description->ReadOnly);
// teacher_work_place
$this->teacher_work_place->SetDbValueDef($rsnew, $this->teacher_work_place->CurrentValue, NULL, $this->teacher_work_place->ReadOnly);
// teacher_active
$this->teacher_active->SetDbValueDef($rsnew, $this->teacher_active->CurrentValue, NULL, $this->teacher_active->ReadOnly);
// teacher_acadamic_title
$this->teacher_acadamic_title->SetDbValueDef($rsnew, $this->teacher_acadamic_title->CurrentValue, NULL, $this->teacher_acadamic_title->ReadOnly);
// teacher_birthday
$this->teacher_birthday->SetDbValueDef($rsnew, $this->teacher_birthday->CurrentValue, NULL, $this->teacher_birthday->ReadOnly);
// teacher_sex
$this->teacher_sex->SetDbValueDef($rsnew, $this->teacher_sex->CurrentValue, NULL, $this->teacher_sex->ReadOnly);
// teacher_faculty
$this->teacher_faculty->SetDbValueDef($rsnew, $this->teacher_faculty->CurrentValue, NULL, $this->teacher_faculty->ReadOnly);
// teacher_dept
$this->teacher_dept->SetDbValueDef($rsnew, $this->teacher_dept->CurrentValue, NULL, $this->teacher_dept->ReadOnly);
// teacher_rate
$this->teacher_rate->SetDbValueDef($rsnew, $this->teacher_rate->CurrentValue, NULL, $this->teacher_rate->ReadOnly);
// teacher_personality
$this->teacher_personality->SetDbValueDef($rsnew, $this->teacher_personality->CurrentValue, NULL, $this->teacher_personality->ReadOnly);
// advices
$this->advices->SetDbValueDef($rsnew, $this->advices->CurrentValue, NULL, $this->advices->ReadOnly);
// teacher_research
$this->teacher_research->SetDbValueDef($rsnew, $this->teacher_research->CurrentValue, NULL, $this->teacher_research->ReadOnly);
// Call Row Updating event
$bUpdateRow = $this->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
if (!ew_Empty($this->teacher_avatar->Upload->Value)) {
$this->teacher_avatar->Upload->SaveToFile($this->teacher_avatar->UploadPath, $rsnew['teacher_avatar'], FALSE);
}
$conn->raiseErrorFn = 'ew_ErrorFn';
if (count($rsnew) > 0) {
$EditRow = $this->Update($rsnew);
} else {
$EditRow = TRUE;
}
// No field to update
$conn->raiseErrorFn = '';
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("UpdateCancelled"));
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$this->Row_Updated($rsold, $rsnew);
}
$rs->Close();
// teacher_avatar
$this->teacher_avatar->Upload->RemoveFromSession();
// Remove file value from Session
return $EditRow;
}
function AddRow()
{
global $conn, $Security, $ItemDetails;
$rsnew = array();
// Field Time_to_Table
$ItemDetails->Time_to_Table->SetDbValueDef($ItemDetails->Time_to_Table->CurrentValue, NULL);
$rsnew['Time_to_Table'] =& $ItemDetails->Time_to_Table->DbValue;
// Field Level_Of_Difficulty
$ItemDetails->Level_Of_Difficulty->SetDbValueDef($ItemDetails->Level_Of_Difficulty->CurrentValue, NULL);
$rsnew['Level_Of_Difficulty'] =& $ItemDetails->Level_Of_Difficulty->DbValue;
// Field Beverage_Pairing
$ItemDetails->Beverage_Pairing->SetDbValueDef($ItemDetails->Beverage_Pairing->CurrentValue, NULL);
$rsnew['Beverage_Pairing'] =& $ItemDetails->Beverage_Pairing->DbValue;
// Field Vegetarian_Subsitution
$ItemDetails->Vegetarian_Subsitution->SetDbValueDef($ItemDetails->Vegetarian_Subsitution->CurrentValue, NULL);
$rsnew['Vegetarian_Subsitution'] =& $ItemDetails->Vegetarian_Subsitution->DbValue;
// Field Calories
$ItemDetails->Calories->SetDbValueDef($ItemDetails->Calories->CurrentValue, NULL);
$rsnew['Calories'] =& $ItemDetails->Calories->DbValue;
// Field Other
$ItemDetails->Other->SetDbValueDef($ItemDetails->Other->CurrentValue, NULL);
$rsnew['Other'] =& $ItemDetails->Other->DbValue;
// Field Image
$ItemDetails->Image->Upload->SaveToSession();
// Save file value to Session
if (is_null($ItemDetails->Image->Upload->Value)) {
$rsnew['Image'] = NULL;
} else {
$rsnew['Image'] = ew_UploadFileNameEx(ew_UploadPathEx(True, "../images/items/"), $ItemDetails->Image->Upload->FileName);
}
// Field ItemID
if ($ItemDetails->ItemID->getSessionValue() != "") {
$rsnew['ItemID'] = $ItemDetails->ItemID->getSessionValue();
}
// Call Row Inserting event
$bInsertRow = $ItemDetails->Row_Inserting($rsnew);
if ($bInsertRow) {
// Field Image
if (!is_null($ItemDetails->Image->Upload->Value)) {
$ItemDetails->Image->Upload->SaveToFile("../images/items/", $rsnew['Image'], FALSE);
}
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $conn->Execute($ItemDetails->InsertSQL($rsnew));
$conn->raiseErrorFn = '';
} else {
if ($ItemDetails->CancelMessage != "") {
$this->setMessage($ItemDetails->CancelMessage);
$ItemDetails->CancelMessage = "";
} else {
$this->setMessage("Insert cancelled");
}
$AddRow = FALSE;
}
if ($AddRow) {
$ItemDetails->ItemID->setDbValue($conn->Insert_ID());
$rsnew['ItemID'] =& $ItemDetails->ItemID->DbValue;
// Call Row Inserted event
$ItemDetails->Row_Inserted($rsnew);
}
// Field Image
$ItemDetails->Image->Upload->RemoveFromSession();
// Remove file value from Session
return $AddRow;
}
function AddRow($rsold = NULL)
{
global $Language, $Security;
$conn =& $this->Connection();
// Load db values from rsold
if ($rsold) {
$this->LoadDbValues($rsold);
}
$rsnew = array();
// category_id
$this->category_id->SetDbValueDef($rsnew, $this->category_id->CurrentValue, 0, FALSE);
// scat_id
$this->scat_id->SetDbValueDef($rsnew, $this->scat_id->CurrentValue, 0, FALSE);
// product_name
$this->product_name->SetDbValueDef($rsnew, $this->product_name->CurrentValue, "", FALSE);
// product_image
if (!$this->product_image->Upload->KeepFile) {
$this->product_image->Upload->DbValue = "";
// No need to delete old file
if ($this->product_image->Upload->FileName == "") {
$rsnew['product_image'] = NULL;
} else {
$rsnew['product_image'] = $this->product_image->Upload->FileName;
}
}
// product_secimage
if (!$this->product_secimage->Upload->KeepFile) {
$this->product_secimage->Upload->DbValue = "";
// No need to delete old file
if ($this->product_secimage->Upload->FileName == "") {
$rsnew['product_secimage'] = NULL;
} else {
$rsnew['product_secimage'] = $this->product_secimage->Upload->FileName;
}
}
// product_description
$this->product_description->SetDbValueDef($rsnew, $this->product_description->CurrentValue, "", FALSE);
// feature_ledtype
$this->feature_ledtype->SetDbValueDef($rsnew, $this->feature_ledtype->CurrentValue, NULL, FALSE);
// feature_power
$this->feature_power->SetDbValueDef($rsnew, $this->feature_power->CurrentValue, NULL, FALSE);
// feature_lumen
$this->feature_lumen->SetDbValueDef($rsnew, $this->feature_lumen->CurrentValue, NULL, FALSE);
// feature_viewangle
$this->feature_viewangle->SetDbValueDef($rsnew, $this->feature_viewangle->CurrentValue, NULL, FALSE);
// feature_cri
$this->feature_cri->SetDbValueDef($rsnew, $this->feature_cri->CurrentValue, NULL, FALSE);
// feature_iprating
$this->feature_iprating->SetDbValueDef($rsnew, $this->feature_iprating->CurrentValue, NULL, FALSE);
// feature_colortemp
$this->feature_colortemp->SetDbValueDef($rsnew, $this->feature_colortemp->CurrentValue, NULL, FALSE);
// feature_body
$this->feature_body->SetDbValueDef($rsnew, $this->feature_body->CurrentValue, NULL, FALSE);
// feature_cutoutsize
$this->feature_cutoutsize->SetDbValueDef($rsnew, $this->feature_cutoutsize->CurrentValue, NULL, FALSE);
// feature_colors
$this->feature_colors->SetDbValueDef($rsnew, $this->feature_colors->CurrentValue, NULL, FALSE);
// feature_dimmable
$this->feature_dimmable->SetDbValueDef($rsnew, $this->feature_dimmable->CurrentValue, NULL, FALSE);
// feature_warranty
$this->feature_warranty->SetDbValueDef($rsnew, $this->feature_warranty->CurrentValue, NULL, FALSE);
// feature_application
$this->feature_application->SetDbValueDef($rsnew, $this->feature_application->CurrentValue, NULL, FALSE);
if (!$this->product_image->Upload->KeepFile) {
if (!ew_Empty($this->product_image->Upload->Value)) {
if ($this->product_image->Upload->FileName == $this->product_image->Upload->DbValue) {
// Overwrite if same file name
$this->product_image->Upload->DbValue = "";
// No need to delete any more
} else {
$rsnew['product_image'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->product_image->UploadPath), $rsnew['product_image']);
// Get new file name
}
}
}
if (!$this->product_secimage->Upload->KeepFile) {
if (!ew_Empty($this->product_secimage->Upload->Value)) {
if ($this->product_secimage->Upload->FileName == $this->product_secimage->Upload->DbValue) {
// Overwrite if same file name
$this->product_secimage->Upload->DbValue = "";
// No need to delete any more
} else {
$rsnew['product_secimage'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->product_secimage->UploadPath), $rsnew['product_secimage']);
// Get new file name
}
}
}
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
// Get insert id if necessary
$this->product_id->setDbValue($conn->Insert_ID());
$rsnew['product_id'] = $this->product_id->DbValue;
if (!$this->product_image->Upload->KeepFile) {
if (!ew_Empty($this->product_image->Upload->Value)) {
$this->product_image->Upload->SaveToFile($this->product_image->UploadPath, $rsnew['product_image'], TRUE);
}
if ($this->product_image->Upload->DbValue != "") {
@unlink(ew_UploadPathEx(TRUE, $this->product_image->OldUploadPath) . $this->product_image->Upload->DbValue);
}
}
if (!$this->product_secimage->Upload->KeepFile) {
if (!ew_Empty($this->product_secimage->Upload->Value)) {
$this->product_secimage->Upload->SaveToFile($this->product_secimage->UploadPath, $rsnew['product_secimage'], TRUE);
}
if ($this->product_secimage->Upload->DbValue != "") {
@unlink(ew_UploadPathEx(TRUE, $this->product_secimage->OldUploadPath) . $this->product_secimage->Upload->DbValue);
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// product_image
ew_CleanUploadTempPath($this->product_image, $this->product_image->Upload->Index);
// product_secimage
ew_CleanUploadTempPath($this->product_secimage, $this->product_secimage->Upload->Index);
return $AddRow;
}
function AddRow($rsold = NULL)
{
global $conn, $Language, $Security;
$rsnew = array();
// teacher_name
$this->teacher_name->SetDbValueDef($rsnew, $this->teacher_name->CurrentValue, NULL, FALSE);
// teacher_personal_page
$this->teacher_personal_page->SetDbValueDef($rsnew, $this->teacher_personal_page->CurrentValue, NULL, FALSE);
// teacher_avatar
$this->teacher_avatar->UploadPath = 'themes\\classic\\assets\\img\\Teacher_img';
if ($this->teacher_avatar->Upload->Action == "1") {
// Keep
if ($rsold) {
$rsnew['teacher_avatar'] = $rsold->fields['teacher_avatar'];
}
} elseif ($this->teacher_avatar->Upload->Action == "2" || $this->teacher_avatar->Upload->Action == "3") {
// Update/Remove
if (is_null($this->teacher_avatar->Upload->Value)) {
$rsnew['teacher_avatar'] = NULL;
} else {
$rsnew['teacher_avatar'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->teacher_avatar->UploadPath), $this->teacher_avatar->Upload->FileName);
}
}
// teacher_description
$this->teacher_description->SetDbValueDef($rsnew, $this->teacher_description->CurrentValue, NULL, FALSE);
// teacher_work_place
$this->teacher_work_place->SetDbValueDef($rsnew, $this->teacher_work_place->CurrentValue, NULL, FALSE);
// teacher_active
$this->teacher_active->SetDbValueDef($rsnew, $this->teacher_active->CurrentValue, NULL, FALSE);
// teacher_acadamic_title
$this->teacher_acadamic_title->SetDbValueDef($rsnew, $this->teacher_acadamic_title->CurrentValue, NULL, FALSE);
// teacher_birthday
$this->teacher_birthday->SetDbValueDef($rsnew, $this->teacher_birthday->CurrentValue, NULL, FALSE);
// teacher_sex
$this->teacher_sex->SetDbValueDef($rsnew, $this->teacher_sex->CurrentValue, NULL, FALSE);
// teacher_faculty
$this->teacher_faculty->SetDbValueDef($rsnew, $this->teacher_faculty->CurrentValue, NULL, FALSE);
// teacher_dept
$this->teacher_dept->SetDbValueDef($rsnew, $this->teacher_dept->CurrentValue, NULL, FALSE);
// teacher_rate
$this->teacher_rate->SetDbValueDef($rsnew, $this->teacher_rate->CurrentValue, NULL, FALSE);
// teacher_personality
$this->teacher_personality->SetDbValueDef($rsnew, $this->teacher_personality->CurrentValue, NULL, FALSE);
// advices
$this->advices->SetDbValueDef($rsnew, $this->advices->CurrentValue, NULL, FALSE);
// teacher_research
$this->teacher_research->SetDbValueDef($rsnew, $this->teacher_research->CurrentValue, NULL, FALSE);
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
if (!ew_Empty($this->teacher_avatar->Upload->Value)) {
$this->teacher_avatar->Upload->SaveToFile($this->teacher_avatar->UploadPath, $rsnew['teacher_avatar'], FALSE);
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
// Get insert id if necessary
if ($AddRow) {
$this->teacher_id->setDbValue($conn->Insert_ID());
$rsnew['teacher_id'] = $this->teacher_id->DbValue;
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// teacher_avatar
$this->teacher_avatar->Upload->RemoveFromSession();
// Remove file value from Session
return $AddRow;
}
function EditRow()
{
global $conn, $Security, $Language;
$sFilter = $this->KeyFilter();
$this->CurrentFilter = $sFilter;
$sSql = $this->SQL();
$conn->raiseErrorFn = 'ew_ErrorFn';
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$EditRow = FALSE;
// Update Failed
} else {
// Save old values
$rsold =& $rs->fields;
$this->LoadDbValues($rsold);
$this->g_image->OldUploadPath = "/gallery";
$this->g_image->UploadPath = $this->g_image->OldUploadPath;
$this->gd_images->OldUploadPath = "/gallery";
$this->gd_images->UploadPath = $this->gd_images->OldUploadPath;
$rsnew = array();
// g_name
$this->g_name->SetDbValueDef($rsnew, $this->g_name->CurrentValue, "", $this->g_name->ReadOnly);
// g_image
if (!$this->g_image->ReadOnly && !$this->g_image->Upload->KeepFile) {
$this->g_image->Upload->DbValue = $rs->fields('g_image');
// Get original value
if ($this->g_image->Upload->FileName == "") {
$rsnew['g_image'] = NULL;
} else {
$rsnew['g_image'] = $this->g_image->Upload->FileName;
}
}
// gd_images
if (!$this->gd_images->ReadOnly && !$this->gd_images->Upload->KeepFile) {
$this->gd_images->Upload->DbValue = $rs->fields('gd_images');
// Get original value
if ($this->gd_images->Upload->FileName == "") {
$rsnew['gd_images'] = NULL;
} else {
$rsnew['gd_images'] = $this->gd_images->Upload->FileName;
}
}
if (!$this->g_image->Upload->KeepFile) {
$this->g_image->UploadPath = "/gallery";
if (!ew_Empty($this->g_image->Upload->Value)) {
$rsnew['g_image'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->g_image->UploadPath), $rsnew['g_image']);
// Get new file name
}
}
if (!$this->gd_images->Upload->KeepFile) {
$this->gd_images->UploadPath = "/gallery";
$OldFiles = explode(",", $this->gd_images->Upload->DbValue);
if (!ew_Empty($this->gd_images->Upload->FileName)) {
$NewFiles = explode(",", $this->gd_images->Upload->FileName);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->gd_images->Upload->Index < 0 ? $this->gd_images->FldVar : substr($this->gd_images->FldVar, 0, 1) . $this->gd_images->Upload->Index . substr($this->gd_images->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $NewFiles[$i];
if (file_exists($file)) {
if (!in_array($NewFiles[$i], $OldFiles)) {
$NewFiles[$i] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->gd_images->UploadPath), $NewFiles[$i]);
// Get new file name
$file1 = ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $NewFiles[$i];
if ($file1 != $file) {
// Rename temp file
rename($file, $file1);
}
}
}
}
}
$this->gd_images->Upload->FileName = implode(",", $NewFiles);
$rsnew['gd_images'] = $this->gd_images->Upload->FileName;
} else {
$NewFiles = array();
}
}
// Call Row Updating event
$bUpdateRow = $this->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
if (count($rsnew) > 0) {
$EditRow = $this->Update($rsnew, "", $rsold);
} else {
$EditRow = TRUE;
}
// No field to update
$conn->raiseErrorFn = '';
if ($EditRow) {
if (!$this->g_image->Upload->KeepFile) {
if (!ew_Empty($this->g_image->Upload->Value)) {
$this->g_image->Upload->SaveToFile($this->g_image->UploadPath, $rsnew['g_image'], TRUE);
}
}
if (!$this->gd_images->Upload->KeepFile) {
$OldFiles = explode(",", $this->gd_images->Upload->DbValue);
if (!ew_Empty($this->gd_images->Upload->FileName)) {
$NewFiles = explode(",", $this->gd_images->Upload->FileName);
$NewFiles2 = explode(",", $rsnew['gd_images']);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->gd_images->Upload->Index < 0 ? $this->gd_images->FldVar : substr($this->gd_images->FldVar, 0, 1) . $this->gd_images->Upload->Index . substr($this->gd_images->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $NewFiles[$i];
if (file_exists($file)) {
$this->gd_images->Upload->Value = file_get_contents($file);
$this->gd_images->Upload->SaveToFile($this->gd_images->UploadPath, @$NewFiles2[$i] != "" ? $NewFiles2[$i] : $NewFiles[$i], TRUE);
// Just replace
}
}
}
} else {
$NewFiles = array();
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("UpdateCancelled"));
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$this->Row_Updated($rsold, $rsnew);
}
$rs->Close();
// g_image
ew_CleanUploadTempPath($this->g_image, $this->g_image->Upload->Index);
// gd_images
ew_CleanUploadTempPath($this->gd_images, $this->gd_images->Upload->Index);
return $EditRow;
}
function AddRow()
{
global $conn, $Security, $Items;
$rsnew = array();
// Field MenuID
$Items->MenuID->SetDbValueDef($Items->MenuID->CurrentValue, 0);
$rsnew['MenuID'] =& $Items->MenuID->DbValue;
// Field ItemName
$Items->ItemName->SetDbValueDef($Items->ItemName->CurrentValue, "");
$rsnew['ItemName'] =& $Items->ItemName->DbValue;
// Field Description
$Items->Description->SetDbValueDef($Items->Description->CurrentValue, "");
$rsnew['Description'] =& $Items->Description->DbValue;
// Field Price
$Items->Price->SetDbValueDef($Items->Price->CurrentValue, NULL);
$rsnew['Price'] =& $Items->Price->DbValue;
// Field Image
$Items->Image->Upload->SaveToSession();
// Save file value to Session
if (is_null($Items->Image->Upload->Value)) {
$rsnew['Image'] = NULL;
} else {
$rsnew['Image'] = ew_UploadFileNameEx(ew_UploadPathEx(True, "../images/items/"), $Items->Image->Upload->FileName);
}
// Field Vegetarian
$Items->Vegetarian->SetDbValueDef($Items->Vegetarian->CurrentValue, "");
$rsnew['Vegetarian'] =& $Items->Vegetarian->DbValue;
// Field Vegetarian_Price
$Items->Vegetarian_Price->SetDbValueDef($Items->Vegetarian_Price->CurrentValue, NULL);
$rsnew['Vegetarian_Price'] =& $Items->Vegetarian_Price->DbValue;
// Field Color
$Items->Color->SetDbValueDef($Items->Color->CurrentValue, NULL);
$rsnew['Color'] =& $Items->Color->DbValue;
// Field Sequence
$Items->Sequence->SetDbValueDef($Items->Sequence->CurrentValue, 0);
$rsnew['Sequence'] =& $Items->Sequence->DbValue;
// Field PDF
$Items->PDF->Upload->SaveToSession();
// Save file value to Session
if (is_null($Items->PDF->Upload->Value)) {
$rsnew['PDF'] = NULL;
} else {
$rsnew['PDF'] = ew_UploadFileNameEx(ew_UploadPathEx(True, "../recipes/"), $Items->PDF->Upload->FileName);
}
// Field Active
$Items->Active->SetDbValueDef($Items->Active->CurrentValue, "");
$rsnew['Active'] =& $Items->Active->DbValue;
// Call Row Inserting event
$bInsertRow = $Items->Row_Inserting($rsnew);
if ($bInsertRow) {
// Field Image
if (!is_null($Items->Image->Upload->Value)) {
$Items->Image->Upload->SaveToFile("../images/items/", $rsnew['Image'], FALSE);
}
// Field PDF
if (!is_null($Items->PDF->Upload->Value)) {
$Items->PDF->Upload->SaveToFile("../recipes/", $rsnew['PDF'], FALSE);
}
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $conn->Execute($Items->InsertSQL($rsnew));
$conn->raiseErrorFn = '';
} else {
if ($Items->CancelMessage != "") {
$this->setMessage($Items->CancelMessage);
$Items->CancelMessage = "";
} else {
$this->setMessage("Insert cancelled");
}
$AddRow = FALSE;
}
if ($AddRow) {
$Items->ItemID->setDbValue($conn->Insert_ID());
$rsnew['ItemID'] =& $Items->ItemID->DbValue;
// Call Row Inserted event
$Items->Row_Inserted($rsnew);
}
// Field Image
$Items->Image->Upload->RemoveFromSession();
// Remove file value from Session
// Field PDF
$Items->PDF->Upload->RemoveFromSession();
// Remove file value from Session
return $AddRow;
}
function EditRow()
{
global $Security, $Language;
$sFilter = $this->KeyFilter();
$conn =& $this->Connection();
$this->CurrentFilter = $sFilter;
$sSql = $this->SQL();
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$EditRow = FALSE;
// Update Failed
} else {
// Begin transaction
if ($this->getCurrentDetailTable() != "") {
$conn->BeginTrans();
}
// Save old values
$rsold =& $rs->fields;
$this->LoadDbValues($rsold);
$this->images->OldUploadPath = "/uploads";
$this->images->UploadPath = $this->images->OldUploadPath;
$rsnew = array();
// title
$this->title->SetDbValueDef($rsnew, $this->title->CurrentValue, "", $this->title->ReadOnly);
// images
if (!$this->images->ReadOnly && !$this->images->Upload->KeepFile) {
$this->images->Upload->DbValue = $rsold['images'];
// Get original value
if ($this->images->Upload->FileName == "") {
$rsnew['images'] = NULL;
} else {
$rsnew['images'] = $this->images->Upload->FileName;
}
}
// intro
$this->intro->SetDbValueDef($rsnew, $this->intro->CurrentValue, "", $this->intro->ReadOnly);
// full_intro
$this->full_intro->SetDbValueDef($rsnew, $this->full_intro->CurrentValue, "", $this->full_intro->ReadOnly);
// details
$this->details->SetDbValueDef($rsnew, $this->details->CurrentValue, "", $this->details->ReadOnly);
// livelink
$this->livelink->SetDbValueDef($rsnew, $this->livelink->CurrentValue, NULL, $this->livelink->ReadOnly);
if (!$this->images->Upload->KeepFile) {
$this->images->UploadPath = "/uploads";
if (!ew_Empty($this->images->Upload->Value)) {
$rsnew['images'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->images->UploadPath), $rsnew['images']);
// Get new file name
}
}
// Call Row Updating event
$bUpdateRow = $this->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
if (count($rsnew) > 0) {
$EditRow = $this->Update($rsnew, "", $rsold);
} else {
$EditRow = TRUE;
}
// No field to update
$conn->raiseErrorFn = '';
if ($EditRow) {
if (!$this->images->Upload->KeepFile) {
if (!ew_Empty($this->images->Upload->Value)) {
$this->images->Upload->SaveToFile($this->images->UploadPath, $rsnew['images'], TRUE);
}
}
}
// Update detail records
if ($EditRow) {
$DetailTblVar = explode(",", $this->getCurrentDetailTable());
if (in_array("images", $DetailTblVar) && $GLOBALS["images"]->DetailEdit) {
if (!isset($GLOBALS["images_grid"])) {
$GLOBALS["images_grid"] = new cimages_grid();
}
// Get detail page object
$EditRow = $GLOBALS["images_grid"]->GridUpdate();
}
}
// Commit/Rollback transaction
if ($this->getCurrentDetailTable() != "") {
if ($EditRow) {
$conn->CommitTrans();
// Commit transaction
} else {
$conn->RollbackTrans();
// Rollback transaction
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("UpdateCancelled"));
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$this->Row_Updated($rsold, $rsnew);
}
$rs->Close();
// images
ew_CleanUploadTempPath($this->images, $this->images->Upload->Index);
return $EditRow;
}
function EditRow()
{
global $Security, $Language;
$sFilter = $this->KeyFilter();
$sFilter = $this->ApplyUserIDFilters($sFilter);
$conn =& $this->Connection();
$this->CurrentFilter = $sFilter;
$sSql = $this->SQL();
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$this->setFailureMessage($Language->Phrase("NoRecord"));
// Set no record message
$EditRow = FALSE;
// Update Failed
} else {
// Save old values
$rsold =& $rs->fields;
$this->LoadDbValues($rsold);
$rsnew = array();
// PATH
if ($this->PATH->Visible && !$this->PATH->ReadOnly && !$this->PATH->Upload->KeepFile) {
$this->PATH->Upload->DbValue = $rsold['PATH'];
// Get original value
if ($this->PATH->Upload->FileName == "") {
$rsnew['PATH'] = NULL;
} else {
$rsnew['PATH'] = $this->PATH->Upload->FileName;
}
}
// PROCESS
$this->PROCESS->SetDbValueDef($rsnew, $this->PROCESS->CurrentValue, 0, $this->PROCESS->ReadOnly);
// BANK_ACCOUNT_ID
$this->BANK_ACCOUNT_ID->SetDbValueDef($rsnew, $this->BANK_ACCOUNT_ID->CurrentValue, 0, $this->BANK_ACCOUNT_ID->ReadOnly);
// UPLOAD_FILE_STATUS_ID
$this->UPLOAD_FILE_STATUS_ID->SetDbValueDef($rsnew, $this->UPLOAD_FILE_STATUS_ID->CurrentValue, 0, $this->UPLOAD_FILE_STATUS_ID->ReadOnly);
// DATETIME
$this->DATETIME->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->DATETIME->CurrentValue, 7), ew_CurrentDate(), $this->DATETIME->ReadOnly);
if ($this->PATH->Visible && !$this->PATH->Upload->KeepFile) {
if (!ew_Empty($this->PATH->Upload->Value)) {
$rsnew['PATH'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->PATH->UploadPath), $rsnew['PATH']);
// Get new file name
}
}
// Call Row Updating event
$bUpdateRow = $this->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
if (count($rsnew) > 0) {
$EditRow = $this->Update($rsnew, "", $rsold);
} else {
$EditRow = TRUE;
}
// No field to update
$conn->raiseErrorFn = '';
if ($EditRow) {
if ($this->PATH->Visible && !$this->PATH->Upload->KeepFile) {
if (!ew_Empty($this->PATH->Upload->Value)) {
$this->PATH->Upload->SaveToFile($this->PATH->UploadPath, $rsnew['PATH'], TRUE);
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("UpdateCancelled"));
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$this->Row_Updated($rsold, $rsnew);
}
$rs->Close();
// PATH
ew_CleanUploadTempPath($this->PATH, $this->PATH->Upload->Index);
return $EditRow;
}
function EditRow()
{
global $Security, $Language;
$sFilter = $this->KeyFilter();
$sFilter = $this->ApplyUserIDFilters($sFilter);
$conn =& $this->Connection();
$this->CurrentFilter = $sFilter;
$sSql = $this->SQL();
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$this->setFailureMessage($Language->Phrase("NoRecord"));
// Set no record message
$EditRow = FALSE;
// Update Failed
} else {
// Save old values
$rsold =& $rs->fields;
$this->LoadDbValues($rsold);
$this->vl_media_file_custom->OldUploadPath = "uploads_custom/";
$this->vl_media_file_custom->UploadPath = $this->vl_media_file_custom->OldUploadPath;
$rsnew = array();
// vl_media_type
$this->vl_media_type->SetDbValueDef($rsnew, $this->vl_media_type->CurrentValue, NULL, $this->vl_media_type->ReadOnly);
// vl_media_name
$this->vl_media_name->SetDbValueDef($rsnew, $this->vl_media_name->CurrentValue, NULL, $this->vl_media_name->ReadOnly);
// vl_media_file
if ($this->vl_media_file->Visible && !$this->vl_media_file->ReadOnly && !$this->vl_media_file->Upload->KeepFile) {
$this->vl_media_file->Upload->DbValue = $rsold['vl_media_file'];
// Get original value
if ($this->vl_media_file->Upload->FileName == "") {
$rsnew['vl_media_file'] = NULL;
} else {
$rsnew['vl_media_file'] = $this->vl_media_file->Upload->FileName;
}
}
// vl_media_file_custom
if ($this->vl_media_file_custom->Visible && !$this->vl_media_file_custom->ReadOnly && !$this->vl_media_file_custom->Upload->KeepFile) {
$this->vl_media_file_custom->Upload->DbValue = $rsold['vl_media_file_custom'];
// Get original value
if ($this->vl_media_file_custom->Upload->FileName == "") {
$rsnew['vl_media_file_custom'] = NULL;
} else {
$rsnew['vl_media_file_custom'] = $this->vl_media_file_custom->Upload->FileName;
}
}
if ($this->vl_media_file->Visible && !$this->vl_media_file->Upload->KeepFile) {
if (!ew_Empty($this->vl_media_file->Upload->Value)) {
$rsnew['vl_media_file'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->vl_media_file->UploadPath), $rsnew['vl_media_file']);
// Get new file name
}
}
if ($this->vl_media_file_custom->Visible && !$this->vl_media_file_custom->Upload->KeepFile) {
$this->vl_media_file_custom->UploadPath = "uploads_custom/";
if (!ew_Empty($this->vl_media_file_custom->Upload->Value)) {
$rsnew['vl_media_file_custom'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->vl_media_file_custom->UploadPath), $rsnew['vl_media_file_custom']);
// Get new file name
}
}
// Call Row Updating event
$bUpdateRow = $this->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
if (count($rsnew) > 0) {
$EditRow = $this->Update($rsnew, "", $rsold);
} else {
$EditRow = TRUE;
}
// No field to update
$conn->raiseErrorFn = '';
if ($EditRow) {
if ($this->vl_media_file->Visible && !$this->vl_media_file->Upload->KeepFile) {
if (!ew_Empty($this->vl_media_file->Upload->Value)) {
$this->vl_media_file->Upload->SaveToFile($this->vl_media_file->UploadPath, $rsnew['vl_media_file'], TRUE);
}
}
if ($this->vl_media_file_custom->Visible && !$this->vl_media_file_custom->Upload->KeepFile) {
if (!ew_Empty($this->vl_media_file_custom->Upload->Value)) {
$this->vl_media_file_custom->Upload->SaveToFile($this->vl_media_file_custom->UploadPath, $rsnew['vl_media_file_custom'], TRUE);
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("UpdateCancelled"));
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$this->Row_Updated($rsold, $rsnew);
}
$rs->Close();
// vl_media_file
ew_CleanUploadTempPath($this->vl_media_file, $this->vl_media_file->Upload->Index);
// vl_media_file_custom
ew_CleanUploadTempPath($this->vl_media_file_custom, $this->vl_media_file_custom->Upload->Index);
return $EditRow;
}
function AddRow($rsold = NULL)
{
global $conn, $Language, $Security;
// Begin transaction
if ($this->getCurrentDetailTable() != "") {
$conn->BeginTrans();
}
// Load db values from rsold
if ($rsold) {
$this->LoadDbValues($rsold);
$this->g_image->OldUploadPath = "gallery/";
$this->g_image->UploadPath = $this->g_image->OldUploadPath;
}
$rsnew = array();
// g_name
$this->g_name->SetDbValueDef($rsnew, $this->g_name->CurrentValue, "", FALSE);
// g_image
if (!$this->g_image->Upload->KeepFile) {
if ($this->g_image->Upload->FileName == "") {
$rsnew['g_image'] = NULL;
} else {
$rsnew['g_image'] = $this->g_image->Upload->FileName;
}
}
if (!$this->g_image->Upload->KeepFile) {
$this->g_image->UploadPath = "gallery/";
if (!ew_Empty($this->g_image->Upload->Value)) {
$rsnew['g_image'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->g_image->UploadPath), $rsnew['g_image']);
// Get new file name
}
}
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
if (!$this->g_image->Upload->KeepFile) {
if (!ew_Empty($this->g_image->Upload->Value)) {
$this->g_image->Upload->SaveToFile($this->g_image->UploadPath, $rsnew['g_image'], TRUE);
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
// Get insert id if necessary
if ($AddRow) {
$this->g_id->setDbValue($conn->Insert_ID());
$rsnew['g_id'] = $this->g_id->DbValue;
}
// Add detail records
if ($AddRow) {
$DetailTblVar = explode(",", $this->getCurrentDetailTable());
if (in_array("gallery_detail", $DetailTblVar) && $GLOBALS["gallery_detail"]->DetailAdd) {
$GLOBALS["gallery_detail"]->g_id->setSessionValue($this->g_id->CurrentValue);
// Set master key
if (!isset($GLOBALS["gallery_detail_grid"])) {
$GLOBALS["gallery_detail_grid"] = new cgallery_detail_grid();
}
// Get detail page object
$AddRow = $GLOBALS["gallery_detail_grid"]->GridInsert();
if (!$AddRow) {
$GLOBALS["gallery_detail"]->g_id->setSessionValue("");
}
// Clear master key if insert failed
}
}
// Commit/Rollback transaction
if ($this->getCurrentDetailTable() != "") {
if ($AddRow) {
$conn->CommitTrans();
// Commit transaction
} else {
$conn->RollbackTrans();
// Rollback transaction
}
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// g_image
ew_CleanUploadTempPath($this->g_image, $this->g_image->Upload->Index);
return $AddRow;
}
function SaveToFile($Path, $NewFileName, $OverWrite, $idx = -1)
{
if (!ew_Empty($this->Value)) {
$Path = ew_UploadPathEx(TRUE, $Path);
if (trim(strval($NewFileName)) == "") {
$NewFileName = $this->FileName;
}
if (!$OverWrite) {
$NewFileName = ew_UploadFileNameEx($Path, $NewFileName);
}
return ew_SaveFile($Path, $NewFileName, $this->Value);
} elseif ($idx >= 0) {
// Use file from upload temp folder
$ar = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->FileName);
if ($idx < count($ar)) {
$fn = $ar[$idx];
$fldvar = $this->Index < 0 ? $this->FldVar : substr($this->FldVar, 0, 1) . $this->Index . substr($this->FldVar, 1);
$file = ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $fn;
if (file_exists($file)) {
if (!$OverWrite) {
$NewFileName = ew_UploadFileNameEx($Path, $NewFileName);
}
return ew_CopyFile($Path, $NewFileName, $file);
}
}
}
return FALSE;
}
function EditRow()
{
global $Security, $Language;
$sFilter = $this->KeyFilter();
$conn =& $this->Connection();
$this->CurrentFilter = $sFilter;
$sSql = $this->SQL();
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$EditRow = FALSE;
// Update Failed
} else {
// Save old values
$rsold =& $rs->fields;
$this->LoadDbValues($rsold);
$rsnew = array();
// category_id
$this->category_id->SetDbValueDef($rsnew, $this->category_id->CurrentValue, 0, $this->category_id->ReadOnly);
// scat_id
$this->scat_id->SetDbValueDef($rsnew, $this->scat_id->CurrentValue, 0, $this->scat_id->ReadOnly);
// product_name
$this->product_name->SetDbValueDef($rsnew, $this->product_name->CurrentValue, "", $this->product_name->ReadOnly);
// product_image
if (!$this->product_image->ReadOnly && !$this->product_image->Upload->KeepFile) {
$this->product_image->Upload->DbValue = $rsold['product_image'];
// Get original value
if ($this->product_image->Upload->FileName == "") {
$rsnew['product_image'] = NULL;
} else {
$rsnew['product_image'] = $this->product_image->Upload->FileName;
}
}
// product_secimage
if (!$this->product_secimage->ReadOnly && !$this->product_secimage->Upload->KeepFile) {
$this->product_secimage->Upload->DbValue = $rsold['product_secimage'];
// Get original value
if ($this->product_secimage->Upload->FileName == "") {
$rsnew['product_secimage'] = NULL;
} else {
$rsnew['product_secimage'] = $this->product_secimage->Upload->FileName;
}
}
// product_description
$this->product_description->SetDbValueDef($rsnew, $this->product_description->CurrentValue, "", $this->product_description->ReadOnly);
// feature_ledtype
$this->feature_ledtype->SetDbValueDef($rsnew, $this->feature_ledtype->CurrentValue, NULL, $this->feature_ledtype->ReadOnly);
// feature_power
$this->feature_power->SetDbValueDef($rsnew, $this->feature_power->CurrentValue, NULL, $this->feature_power->ReadOnly);
// feature_lumen
$this->feature_lumen->SetDbValueDef($rsnew, $this->feature_lumen->CurrentValue, NULL, $this->feature_lumen->ReadOnly);
// feature_viewangle
$this->feature_viewangle->SetDbValueDef($rsnew, $this->feature_viewangle->CurrentValue, NULL, $this->feature_viewangle->ReadOnly);
// feature_cri
$this->feature_cri->SetDbValueDef($rsnew, $this->feature_cri->CurrentValue, NULL, $this->feature_cri->ReadOnly);
// feature_iprating
$this->feature_iprating->SetDbValueDef($rsnew, $this->feature_iprating->CurrentValue, NULL, $this->feature_iprating->ReadOnly);
// feature_colortemp
$this->feature_colortemp->SetDbValueDef($rsnew, $this->feature_colortemp->CurrentValue, NULL, $this->feature_colortemp->ReadOnly);
// feature_body
$this->feature_body->SetDbValueDef($rsnew, $this->feature_body->CurrentValue, NULL, $this->feature_body->ReadOnly);
// feature_cutoutsize
$this->feature_cutoutsize->SetDbValueDef($rsnew, $this->feature_cutoutsize->CurrentValue, NULL, $this->feature_cutoutsize->ReadOnly);
// feature_colors
$this->feature_colors->SetDbValueDef($rsnew, $this->feature_colors->CurrentValue, NULL, $this->feature_colors->ReadOnly);
// feature_dimmable
$this->feature_dimmable->SetDbValueDef($rsnew, $this->feature_dimmable->CurrentValue, NULL, $this->feature_dimmable->ReadOnly);
// feature_warranty
$this->feature_warranty->SetDbValueDef($rsnew, $this->feature_warranty->CurrentValue, NULL, $this->feature_warranty->ReadOnly);
// feature_application
$this->feature_application->SetDbValueDef($rsnew, $this->feature_application->CurrentValue, NULL, $this->feature_application->ReadOnly);
if (!$this->product_image->Upload->KeepFile) {
if (!ew_Empty($this->product_image->Upload->Value)) {
if ($this->product_image->Upload->FileName == $this->product_image->Upload->DbValue) {
// Overwrite if same file name
$this->product_image->Upload->DbValue = "";
// No need to delete any more
} else {
$rsnew['product_image'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->product_image->UploadPath), $rsnew['product_image']);
// Get new file name
}
}
}
if (!$this->product_secimage->Upload->KeepFile) {
if (!ew_Empty($this->product_secimage->Upload->Value)) {
if ($this->product_secimage->Upload->FileName == $this->product_secimage->Upload->DbValue) {
// Overwrite if same file name
$this->product_secimage->Upload->DbValue = "";
// No need to delete any more
} else {
$rsnew['product_secimage'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->product_secimage->UploadPath), $rsnew['product_secimage']);
// Get new file name
}
}
}
// Call Row Updating event
$bUpdateRow = $this->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
if (count($rsnew) > 0) {
$EditRow = $this->Update($rsnew, "", $rsold);
} else {
$EditRow = TRUE;
}
// No field to update
$conn->raiseErrorFn = '';
if ($EditRow) {
if (!$this->product_image->Upload->KeepFile) {
if (!ew_Empty($this->product_image->Upload->Value)) {
$this->product_image->Upload->SaveToFile($this->product_image->UploadPath, $rsnew['product_image'], TRUE);
}
if ($this->product_image->Upload->DbValue != "") {
@unlink(ew_UploadPathEx(TRUE, $this->product_image->OldUploadPath) . $this->product_image->Upload->DbValue);
}
}
if (!$this->product_secimage->Upload->KeepFile) {
if (!ew_Empty($this->product_secimage->Upload->Value)) {
$this->product_secimage->Upload->SaveToFile($this->product_secimage->UploadPath, $rsnew['product_secimage'], TRUE);
}
if ($this->product_secimage->Upload->DbValue != "") {
@unlink(ew_UploadPathEx(TRUE, $this->product_secimage->OldUploadPath) . $this->product_secimage->Upload->DbValue);
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("UpdateCancelled"));
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$this->Row_Updated($rsold, $rsnew);
}
$rs->Close();
// product_image
ew_CleanUploadTempPath($this->product_image, $this->product_image->Upload->Index);
// product_secimage
ew_CleanUploadTempPath($this->product_secimage, $this->product_secimage->Upload->Index);
return $EditRow;
}
function AddRow($rsold = NULL)
{
global $Language, $Security;
$conn =& $this->Connection();
// Begin transaction
if ($this->getCurrentDetailTable() != "") {
$conn->BeginTrans();
}
// Load db values from rsold
if ($rsold) {
$this->LoadDbValues($rsold);
}
$rsnew = array();
// category_id
$this->category_id->SetDbValueDef($rsnew, $this->category_id->CurrentValue, 0, FALSE);
// scat_name
$this->scat_name->SetDbValueDef($rsnew, $this->scat_name->CurrentValue, "", FALSE);
// scat_description
$this->scat_description->SetDbValueDef($rsnew, $this->scat_description->CurrentValue, "", FALSE);
// scat_picture
if (!$this->scat_picture->Upload->KeepFile) {
$this->scat_picture->Upload->DbValue = "";
// No need to delete old file
if ($this->scat_picture->Upload->FileName == "") {
$rsnew['scat_picture'] = NULL;
} else {
$rsnew['scat_picture'] = $this->scat_picture->Upload->FileName;
}
}
if (!$this->scat_picture->Upload->KeepFile) {
if (!ew_Empty($this->scat_picture->Upload->Value)) {
if ($this->scat_picture->Upload->FileName == $this->scat_picture->Upload->DbValue) {
// Overwrite if same file name
$this->scat_picture->Upload->DbValue = "";
// No need to delete any more
} else {
$rsnew['scat_picture'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->scat_picture->UploadPath), $rsnew['scat_picture']);
// Get new file name
}
}
}
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
// Get insert id if necessary
$this->scat_id->setDbValue($conn->Insert_ID());
$rsnew['scat_id'] = $this->scat_id->DbValue;
if (!$this->scat_picture->Upload->KeepFile) {
if (!ew_Empty($this->scat_picture->Upload->Value)) {
$this->scat_picture->Upload->SaveToFile($this->scat_picture->UploadPath, $rsnew['scat_picture'], TRUE);
}
if ($this->scat_picture->Upload->DbValue != "") {
@unlink(ew_UploadPathEx(TRUE, $this->scat_picture->OldUploadPath) . $this->scat_picture->Upload->DbValue);
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
// Add detail records
if ($AddRow) {
$DetailTblVar = explode(",", $this->getCurrentDetailTable());
if (in_array("products", $DetailTblVar) && $GLOBALS["products"]->DetailAdd) {
$GLOBALS["products"]->scat_id->setSessionValue($this->scat_id->CurrentValue);
// Set master key
if (!isset($GLOBALS["products_grid"])) {
$GLOBALS["products_grid"] = new cproducts_grid();
}
// Get detail page object
$AddRow = $GLOBALS["products_grid"]->GridInsert();
if (!$AddRow) {
$GLOBALS["products"]->scat_id->setSessionValue("");
}
// Clear master key if insert failed
}
}
// Commit/Rollback transaction
if ($this->getCurrentDetailTable() != "") {
if ($AddRow) {
$conn->CommitTrans();
// Commit transaction
} else {
$conn->RollbackTrans();
// Rollback transaction
}
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// scat_picture
ew_CleanUploadTempPath($this->scat_picture, $this->scat_picture->Upload->Index);
return $AddRow;
}
function AddRow($rsold = NULL)
{
global $Language, $Security;
$conn =& $this->Connection();
// Load db values from rsold
if ($rsold) {
$this->LoadDbValues($rsold);
$this->s_image->OldUploadPath = "/uploads/";
$this->s_image->UploadPath = $this->s_image->OldUploadPath;
$this->s_images->OldUploadPath = "/uploads/";
$this->s_images->UploadPath = $this->s_images->OldUploadPath;
}
$rsnew = array();
// s_title
$this->s_title->SetDbValueDef($rsnew, $this->s_title->CurrentValue, "", FALSE);
// s_image
if (!$this->s_image->Upload->KeepFile) {
$this->s_image->Upload->DbValue = "";
// No need to delete old file
if ($this->s_image->Upload->FileName == "") {
$rsnew['s_image'] = NULL;
} else {
$rsnew['s_image'] = $this->s_image->Upload->FileName;
}
}
// s_desc
$this->s_desc->SetDbValueDef($rsnew, $this->s_desc->CurrentValue, "", FALSE);
// s_longdesc
$this->s_longdesc->SetDbValueDef($rsnew, $this->s_longdesc->CurrentValue, "", FALSE);
// s_images
if (!$this->s_images->Upload->KeepFile) {
$this->s_images->Upload->DbValue = "";
// No need to delete old file
if ($this->s_images->Upload->FileName == "") {
$rsnew['s_images'] = NULL;
} else {
$rsnew['s_images'] = $this->s_images->Upload->FileName;
}
}
// s_caption
$this->s_caption->SetDbValueDef($rsnew, $this->s_caption->CurrentValue, "", FALSE);
if (!$this->s_image->Upload->KeepFile) {
$this->s_image->UploadPath = "/uploads/";
if (!ew_Empty($this->s_image->Upload->Value)) {
$rsnew['s_image'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->s_image->UploadPath), $rsnew['s_image']);
// Get new file name
}
}
if (!$this->s_images->Upload->KeepFile) {
$this->s_images->UploadPath = "/uploads/";
$OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->s_images->Upload->DbValue);
if (!ew_Empty($this->s_images->Upload->FileName)) {
$NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->s_images->Upload->FileName);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->s_images->Upload->Index < 0 ? $this->s_images->FldVar : substr($this->s_images->FldVar, 0, 1) . $this->s_images->Upload->Index . substr($this->s_images->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = $NewFiles[$i];
if (file_exists(ew_UploadTempPath($fldvar, $this->s_images->TblVar) . EW_PATH_DELIMITER . $file)) {
if (!in_array($file, $OldFiles)) {
$file1 = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->s_images->UploadPath), $file);
// Get new file name
if ($file1 != $file) {
// Rename temp file
while (file_exists(ew_UploadTempPath($fldvar, $this->s_images->TblVar) . EW_PATH_DELIMITER . $file1)) {
// Make sure did not clash with existing upload file
$file1 = ew_UniqueFilename(ew_UploadPathEx(TRUE, $this->s_images->UploadPath), $file1, TRUE);
}
// Use indexed name
rename(ew_UploadTempPath($fldvar, $this->s_images->TblVar) . EW_PATH_DELIMITER . $file, ew_UploadTempPath($fldvar, $this->s_images->TblVar) . EW_PATH_DELIMITER . $file1);
$NewFiles[$i] = $file1;
}
}
}
}
}
$this->s_images->Upload->FileName = implode(EW_MULTIPLE_UPLOAD_SEPARATOR, $NewFiles);
$rsnew['s_images'] = $this->s_images->Upload->FileName;
} else {
$NewFiles = array();
}
}
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
// Get insert id if necessary
$this->s_id->setDbValue($conn->Insert_ID());
$rsnew['s_id'] = $this->s_id->DbValue;
if (!$this->s_image->Upload->KeepFile) {
if (!ew_Empty($this->s_image->Upload->Value)) {
$this->s_image->Upload->SaveToFile($this->s_image->UploadPath, $rsnew['s_image'], TRUE);
}
}
if (!$this->s_images->Upload->KeepFile) {
$OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->s_images->Upload->DbValue);
if (!ew_Empty($this->s_images->Upload->FileName)) {
$NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->s_images->Upload->FileName);
$NewFiles2 = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $rsnew['s_images']);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->s_images->Upload->Index < 0 ? $this->s_images->FldVar : substr($this->s_images->FldVar, 0, 1) . $this->s_images->Upload->Index . substr($this->s_images->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = ew_UploadTempPath($fldvar, $this->s_images->TblVar) . EW_PATH_DELIMITER . $NewFiles[$i];
if (file_exists($file)) {
$this->s_images->Upload->SaveToFile($this->s_images->UploadPath, @$NewFiles2[$i] != "" ? $NewFiles2[$i] : $NewFiles[$i], TRUE, $i);
// Just replace
}
}
}
} else {
$NewFiles = array();
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// s_image
ew_CleanUploadTempPath($this->s_image, $this->s_image->Upload->Index);
// s_images
ew_CleanUploadTempPath($this->s_images, $this->s_images->Upload->Index);
return $AddRow;
}
function AddRow($rsold = NULL)
{
global $Language, $Security;
$conn =& $this->Connection();
// Load db values from rsold
if ($rsold) {
$this->LoadDbValues($rsold);
$this->image_name->OldUploadPath = "/projectimages";
$this->image_name->UploadPath = $this->image_name->OldUploadPath;
}
$rsnew = array();
// p_id
$this->p_id->SetDbValueDef($rsnew, $this->p_id->CurrentValue, 0, FALSE);
// image_name
if (!$this->image_name->Upload->KeepFile) {
$this->image_name->Upload->DbValue = "";
// No need to delete old file
if ($this->image_name->Upload->FileName == "") {
$rsnew['image_name'] = NULL;
} else {
$rsnew['image_name'] = $this->image_name->Upload->FileName;
}
}
// image_detail
$this->image_detail->SetDbValueDef($rsnew, $this->image_detail->CurrentValue, "", FALSE);
if (!$this->image_name->Upload->KeepFile) {
$this->image_name->UploadPath = "/projectimages";
if (!ew_Empty($this->image_name->Upload->Value)) {
$rsnew['image_name'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->image_name->UploadPath), $rsnew['image_name']);
// Get new file name
}
}
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
// Get insert id if necessary
$this->image_id->setDbValue($conn->Insert_ID());
$rsnew['image_id'] = $this->image_id->DbValue;
if (!$this->image_name->Upload->KeepFile) {
if (!ew_Empty($this->image_name->Upload->Value)) {
$this->image_name->Upload->SaveToFile($this->image_name->UploadPath, $rsnew['image_name'], TRUE);
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// image_name
ew_CleanUploadTempPath($this->image_name, $this->image_name->Upload->Index);
return $AddRow;
}
function EditRow()
{
global $conn, $Security, $Items;
$sFilter = $Items->KeyFilter();
$Items->CurrentFilter = $sFilter;
$sSql = $Items->SQL();
$conn->raiseErrorFn = 'ew_ErrorFn';
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
}
if ($rs->EOF) {
$EditRow = FALSE;
// Update Failed
} else {
// Save old values
$rsold =& $rs->fields;
$rsnew = array();
// Field ItemID
// Field MenuID
$Items->MenuID->SetDbValueDef($Items->MenuID->CurrentValue, 0);
$rsnew['MenuID'] =& $Items->MenuID->DbValue;
// Field ItemName
$Items->ItemName->SetDbValueDef($Items->ItemName->CurrentValue, "");
$rsnew['ItemName'] =& $Items->ItemName->DbValue;
// Field Description
$Items->Description->SetDbValueDef($Items->Description->CurrentValue, "");
$rsnew['Description'] =& $Items->Description->DbValue;
// Field Price
$Items->Price->SetDbValueDef($Items->Price->CurrentValue, NULL);
$rsnew['Price'] =& $Items->Price->DbValue;
// Field Image
$Items->Image->Upload->SaveToSession();
// Save file value to Session
if ($Items->Image->Upload->Action == "2" || $Items->Image->Upload->Action == "3") {
// Update/Remove
$Items->Image->Upload->DbValue = $rs->fields('Image');
// Get original value
if (is_null($Items->Image->Upload->Value)) {
$rsnew['Image'] = NULL;
} else {
$rsnew['Image'] = ew_UploadFileNameEx(ew_UploadPathEx(True, "../images/items/"), $Items->Image->Upload->FileName);
}
}
// Field Vegetarian
$Items->Vegetarian->SetDbValueDef($Items->Vegetarian->CurrentValue, "");
$rsnew['Vegetarian'] =& $Items->Vegetarian->DbValue;
// Field Vegetarian_Price
$Items->Vegetarian_Price->SetDbValueDef($Items->Vegetarian_Price->CurrentValue, NULL);
$rsnew['Vegetarian_Price'] =& $Items->Vegetarian_Price->DbValue;
// Field Color
$Items->Color->SetDbValueDef($Items->Color->CurrentValue, NULL);
$rsnew['Color'] =& $Items->Color->DbValue;
// Field Sequence
$Items->Sequence->SetDbValueDef($Items->Sequence->CurrentValue, 0);
$rsnew['Sequence'] =& $Items->Sequence->DbValue;
// Field PDF
$Items->PDF->Upload->SaveToSession();
// Save file value to Session
if ($Items->PDF->Upload->Action == "2" || $Items->PDF->Upload->Action == "3") {
// Update/Remove
$Items->PDF->Upload->DbValue = $rs->fields('PDF');
// Get original value
if (is_null($Items->PDF->Upload->Value)) {
$rsnew['PDF'] = NULL;
} else {
$rsnew['PDF'] = ew_UploadFileNameEx(ew_UploadPathEx(True, "../recipes/"), $Items->PDF->Upload->FileName);
}
}
// Field Active
$Items->Active->SetDbValueDef($Items->Active->CurrentValue, "");
$rsnew['Active'] =& $Items->Active->DbValue;
// Call Row Updating event
$bUpdateRow = $Items->Row_Updating($rsold, $rsnew);
if ($bUpdateRow) {
// Field Image
if (!is_null($Items->Image->Upload->Value)) {
$Items->Image->Upload->SaveToFile("../images/items/", $rsnew['Image'], FALSE);
}
// Field PDF
if (!is_null($Items->PDF->Upload->Value)) {
$Items->PDF->Upload->SaveToFile("../recipes/", $rsnew['PDF'], FALSE);
}
$conn->raiseErrorFn = 'ew_ErrorFn';
$EditRow = $conn->Execute($Items->UpdateSQL($rsnew));
$conn->raiseErrorFn = '';
} else {
if ($Items->CancelMessage != "") {
$this->setMessage($Items->CancelMessage);
$Items->CancelMessage = "";
} else {
$this->setMessage("Update cancelled");
}
$EditRow = FALSE;
}
}
// Call Row_Updated event
if ($EditRow) {
$Items->Row_Updated($rsold, $rsnew);
}
$rs->Close();
// Field Image
$Items->Image->Upload->RemoveFromSession();
// Remove file value from Session
// Field PDF
$Items->PDF->Upload->RemoveFromSession();
// Remove file value from Session
return $EditRow;
}
function AddRow($rsold = NULL)
{
global $Language, $Security;
$conn =& $this->Connection();
// Load db values from rsold
if ($rsold) {
$this->LoadDbValues($rsold);
}
$rsnew = array();
// PATH
if ($this->PATH->Visible && !$this->PATH->Upload->KeepFile) {
$this->PATH->Upload->DbValue = "";
// No need to delete old file
if ($this->PATH->Upload->FileName == "") {
$rsnew['PATH'] = NULL;
} else {
$rsnew['PATH'] = $this->PATH->Upload->FileName;
}
}
// PROCESS
$this->PROCESS->SetDbValueDef($rsnew, $this->PROCESS->CurrentValue, 0, FALSE);
// BANK_ACCOUNT_ID
$this->BANK_ACCOUNT_ID->SetDbValueDef($rsnew, $this->BANK_ACCOUNT_ID->CurrentValue, 0, FALSE);
// UPLOAD_FILE_STATUS_ID
$this->UPLOAD_FILE_STATUS_ID->SetDbValueDef($rsnew, $this->UPLOAD_FILE_STATUS_ID->CurrentValue, 0, FALSE);
// DATETIME
$this->DATETIME->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->DATETIME->CurrentValue, 7), ew_CurrentDate(), FALSE);
if ($this->PATH->Visible && !$this->PATH->Upload->KeepFile) {
if (!ew_Empty($this->PATH->Upload->Value)) {
$rsnew['PATH'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->PATH->UploadPath), $rsnew['PATH']);
// Get new file name
}
}
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
// Get insert id if necessary
$this->UPLOAD_FILE_ID->setDbValue($conn->Insert_ID());
$rsnew['UPLOAD_FILE_ID'] = $this->UPLOAD_FILE_ID->DbValue;
if ($this->PATH->Visible && !$this->PATH->Upload->KeepFile) {
if (!ew_Empty($this->PATH->Upload->Value)) {
$this->PATH->Upload->SaveToFile($this->PATH->UploadPath, $rsnew['PATH'], TRUE);
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// PATH
ew_CleanUploadTempPath($this->PATH, $this->PATH->Upload->Index);
return $AddRow;
}
function AddRow($rsold = NULL)
{
global $conn, $Language, $Security;
// Load db values from rsold
if ($rsold) {
$this->LoadDbValues($rsold);
$this->cat_file->OldUploadPath = "/catalogues/";
$this->cat_file->UploadPath = $this->cat_file->OldUploadPath;
}
$rsnew = array();
// cat_name
$this->cat_name->SetDbValueDef($rsnew, $this->cat_name->CurrentValue, "", FALSE);
// cat_file
if (!$this->cat_file->Upload->KeepFile) {
if ($this->cat_file->Upload->FileName == "") {
$rsnew['cat_file'] = NULL;
} else {
$rsnew['cat_file'] = $this->cat_file->Upload->FileName;
}
$this->cat_file->ImageWidth = EW_THUMBNAIL_DEFAULT_WIDTH;
// Resize width
$this->cat_file->ImageHeight = EW_THUMBNAIL_DEFAULT_HEIGHT;
// Resize height
}
// cat_date
$this->cat_date->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->cat_date->CurrentValue, 5), ew_CurrentDate(), FALSE);
if (!$this->cat_file->Upload->KeepFile) {
$this->cat_file->UploadPath = "/catalogues/";
if (!ew_Empty($this->cat_file->Upload->Value)) {
$rsnew['cat_file'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->cat_file->UploadPath), $rsnew['cat_file']);
// Get new file name
}
}
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
if (!$this->cat_file->Upload->KeepFile) {
if (!ew_Empty($this->cat_file->Upload->Value)) {
$this->cat_file->Upload->Resize($this->cat_file->ImageWidth, $this->cat_file->ImageHeight, EW_THUMBNAIL_DEFAULT_QUALITY);
$this->cat_file->Upload->SaveToFile($this->cat_file->UploadPath, $rsnew['cat_file'], TRUE);
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
// Get insert id if necessary
if ($AddRow) {
$this->cat_id->setDbValue($conn->Insert_ID());
$rsnew['cat_id'] = $this->cat_id->DbValue;
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// cat_file
ew_CleanUploadTempPath($this->cat_file, $this->cat_file->Upload->Index);
return $AddRow;
}
function AddRow($rsold = NULL)
{
global $conn, $Language, $Security;
// Check referential integrity for master table 'tramites'
$bValidMasterRecord = TRUE;
$sMasterFilter = $this->SqlMasterFilter_tramites();
if (strval($this->id_tramite->CurrentValue) != "") {
$sMasterFilter = str_replace("@codigo@", ew_AdjustSql($this->id_tramite->CurrentValue), $sMasterFilter);
} else {
$bValidMasterRecord = FALSE;
}
if ($bValidMasterRecord) {
$rsmaster = $GLOBALS["tramites"]->LoadRs($sMasterFilter);
$bValidMasterRecord = $rsmaster && !$rsmaster->EOF;
$rsmaster->Close();
}
if (!$bValidMasterRecord) {
$sRelatedRecordMsg = str_replace("%t", "tramites", $Language->Phrase("RelatedRecordRequired"));
$this->setFailureMessage($sRelatedRecordMsg);
return FALSE;
}
// Load db values from rsold
if ($rsold) {
$this->LoadDbValues($rsold);
}
$rsnew = array();
// id_tramite
$this->id_tramite->SetDbValueDef($rsnew, $this->id_tramite->CurrentValue, 0, FALSE);
// fecha
$this->fecha->SetDbValueDef($rsnew, ew_CurrentDate(), ew_CurrentDate());
$rsnew['fecha'] =& $this->fecha->DbValue;
// hora
$this->hora->SetDbValueDef($rsnew, ew_CurrentTime(), ew_CurrentTime());
$rsnew['hora'] =& $this->hora->DbValue;
// titulo
$this->titulo->SetDbValueDef($rsnew, $this->titulo->CurrentValue, NULL, FALSE);
// archivo
if (!$this->archivo->Upload->KeepFile) {
$this->archivo->Upload->DbValue = "";
// No need to delete old file
if ($this->archivo->Upload->FileName == "") {
$rsnew['archivo'] = NULL;
} else {
$rsnew['archivo'] = $this->archivo->Upload->FileName;
}
}
if (!$this->archivo->Upload->KeepFile) {
$OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->DbValue);
if (!ew_Empty($this->archivo->Upload->FileName)) {
$NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->FileName);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->archivo->Upload->Index < 0 ? $this->archivo->FldVar : substr($this->archivo->FldVar, 0, 1) . $this->archivo->Upload->Index . substr($this->archivo->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = $NewFiles[$i];
if (file_exists(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file)) {
if (!in_array($file, $OldFiles)) {
$file1 = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->archivo->UploadPath), $file);
// Get new file name
if ($file1 != $file) {
// Rename temp file
while (file_exists(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file1)) {
// Make sure did not clash with existing upload file
$file1 = ew_UniqueFilename(ew_UploadPathEx(TRUE, $this->archivo->UploadPath), $file1, TRUE);
}
// Use indexed name
rename(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file, ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file1);
$NewFiles[$i] = $file1;
}
}
}
}
}
$this->archivo->Upload->FileName = implode(EW_MULTIPLE_UPLOAD_SEPARATOR, $NewFiles);
$rsnew['archivo'] = $this->archivo->Upload->FileName;
} else {
$NewFiles = array();
}
}
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
// Check if key value entered
if ($bInsertRow && $this->ValidateKey && strval($rsnew['id_tramite']) == "") {
$this->setFailureMessage($Language->Phrase("InvalidKeyValue"));
$bInsertRow = FALSE;
}
// Check if key value entered
if ($bInsertRow && $this->ValidateKey && strval($rsnew['fecha']) == "") {
$this->setFailureMessage($Language->Phrase("InvalidKeyValue"));
$bInsertRow = FALSE;
}
// Check if key value entered
if ($bInsertRow && $this->ValidateKey && strval($rsnew['hora']) == "") {
$this->setFailureMessage($Language->Phrase("InvalidKeyValue"));
$bInsertRow = FALSE;
}
// Check for duplicate key
if ($bInsertRow && $this->ValidateKey) {
$sFilter = $this->KeyFilter();
$rsChk = $this->LoadRs($sFilter);
if ($rsChk && !$rsChk->EOF) {
$sKeyErrMsg = str_replace("%f", $sFilter, $Language->Phrase("DupKey"));
$this->setFailureMessage($sKeyErrMsg);
$rsChk->Close();
$bInsertRow = FALSE;
}
}
if ($bInsertRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
if (!$this->archivo->Upload->KeepFile) {
$OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->DbValue);
if (!ew_Empty($this->archivo->Upload->FileName)) {
$NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->FileName);
$NewFiles2 = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $rsnew['archivo']);
$FileCount = count($NewFiles);
for ($i = 0; $i < $FileCount; $i++) {
$fldvar = $this->archivo->Upload->Index < 0 ? $this->archivo->FldVar : substr($this->archivo->FldVar, 0, 1) . $this->archivo->Upload->Index . substr($this->archivo->FldVar, 1);
if ($NewFiles[$i] != "") {
$file = ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $NewFiles[$i];
if (file_exists($file)) {
$this->archivo->Upload->SaveToFile($this->archivo->UploadPath, @$NewFiles2[$i] != "" ? $NewFiles2[$i] : $NewFiles[$i], TRUE, $i);
// Just replace
}
}
}
} else {
$NewFiles = array();
}
$FileCount = count($OldFiles);
for ($i = 0; $i < $FileCount; $i++) {
if ($OldFiles[$i] != "" && !in_array($OldFiles[$i], $NewFiles)) {
@unlink(ew_UploadPathEx(TRUE, $this->archivo->OldUploadPath) . $OldFiles[$i]);
}
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
// Get insert id if necessary
if ($AddRow) {
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// archivo
ew_CleanUploadTempPath($this->archivo, $this->archivo->Upload->Index);
return $AddRow;
}
function AddRow($rsold = NULL)
{
global $conn, $Language, $Security;
// Load db values from rsold
if ($rsold) {
$this->LoadDbValues($rsold);
}
$rsnew = array();
// fecha_recepcion
$this->fecha_recepcion->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->fecha_recepcion->CurrentValue, 7), ew_CurrentDate(), FALSE);
// cliente
$this->cliente->SetDbValueDef($rsnew, $this->cliente->CurrentValue, NULL, FALSE);
// id_tipo_cliente
$this->id_tipo_cliente->SetDbValueDef($rsnew, $this->id_tipo_cliente->CurrentValue, NULL, FALSE);
// tel
$this->tel->SetDbValueDef($rsnew, $this->tel->CurrentValue, NULL, FALSE);
// cel
$this->cel->SetDbValueDef($rsnew, $this->cel->CurrentValue, NULL, FALSE);
// objetos
$this->objetos->SetDbValueDef($rsnew, $this->objetos->CurrentValue, NULL, FALSE);
// detalle_a_realizar
$this->detalle_a_realizar->SetDbValueDef($rsnew, $this->detalle_a_realizar->CurrentValue, NULL, FALSE);
// fecha_entrega
$this->fecha_entrega->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->fecha_entrega->CurrentValue, 7), NULL, FALSE);
// observaciones
$this->observaciones->SetDbValueDef($rsnew, $this->observaciones->CurrentValue, NULL, FALSE);
// id_estado
$this->id_estado->SetDbValueDef($rsnew, $this->id_estado->CurrentValue, 0, FALSE);
// precio
$this->precio->SetDbValueDef($rsnew, $this->precio->CurrentValue, NULL, FALSE);
// entrega
$this->entrega->SetDbValueDef($rsnew, $this->entrega->CurrentValue, NULL, FALSE);
// foto1
if (!$this->foto1->Upload->KeepFile) {
if ($this->foto1->Upload->FileName == "") {
$rsnew['foto1'] = NULL;
} else {
$rsnew['foto1'] = $this->foto1->Upload->FileName;
}
}
// foto2
if (!$this->foto2->Upload->KeepFile) {
if ($this->foto2->Upload->FileName == "") {
$rsnew['foto2'] = NULL;
} else {
$rsnew['foto2'] = $this->foto2->Upload->FileName;
}
}
if (!$this->foto1->Upload->KeepFile) {
if (!ew_Empty($this->foto1->Upload->Value)) {
if ($this->foto1->Upload->FileName == $this->foto1->Upload->DbValue) {
// Overwrite if same file name
$this->foto1->Upload->DbValue = "";
// No need to delete any more
} else {
$rsnew['foto1'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->foto1->UploadPath), $rsnew['foto1']);
// Get new file name
}
}
}
if (!$this->foto2->Upload->KeepFile) {
if (!ew_Empty($this->foto2->Upload->Value)) {
if ($this->foto2->Upload->FileName == $this->foto2->Upload->DbValue) {
// Overwrite if same file name
$this->foto2->Upload->DbValue = "";
// No need to delete any more
} else {
$rsnew['foto2'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->foto2->UploadPath), $rsnew['foto2']);
// Get new file name
}
}
}
// Call Row Inserting event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$bInsertRow = $this->Row_Inserting($rs, $rsnew);
if ($bInsertRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $this->Insert($rsnew);
$conn->raiseErrorFn = '';
if ($AddRow) {
if (!$this->foto1->Upload->KeepFile) {
if (!ew_Empty($this->foto1->Upload->Value)) {
$this->foto1->Upload->SaveToFile($this->foto1->UploadPath, $rsnew['foto1'], TRUE);
}
if ($this->foto1->Upload->DbValue != "") {
@unlink(ew_UploadPathEx(TRUE, $this->foto1->OldUploadPath) . $this->foto1->Upload->DbValue);
}
}
if (!$this->foto2->Upload->KeepFile) {
if (!ew_Empty($this->foto2->Upload->Value)) {
$this->foto2->Upload->SaveToFile($this->foto2->UploadPath, $rsnew['foto2'], TRUE);
}
if ($this->foto2->Upload->DbValue != "") {
@unlink(ew_UploadPathEx(TRUE, $this->foto2->OldUploadPath) . $this->foto2->Upload->DbValue);
}
}
}
} else {
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("InsertCancelled"));
}
$AddRow = FALSE;
}
// Get insert id if necessary
if ($AddRow) {
$this->nro_orden->setDbValue($conn->Insert_ID());
$rsnew['nro_orden'] = $this->nro_orden->DbValue;
}
if ($AddRow) {
// Call Row Inserted event
$rs = $rsold == NULL ? NULL : $rsold->fields;
$this->Row_Inserted($rs, $rsnew);
}
// foto1
ew_CleanUploadTempPath($this->foto1, $this->foto1->Upload->Index);
// foto2
ew_CleanUploadTempPath($this->foto2, $this->foto2->Upload->Index);
return $AddRow;
}