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 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;
}
" border=0<?php
echo $Items->Image->ViewAttributes();
?>
>
<?php
} elseif (!in_array($Items->CurrentAction, array("I", "edit", "gridedit"))) {
?>
<?php
}
} else {
if (!is_null($Items->Image->Upload->DbValue)) {
?>
<img src="<?php
echo ew_UploadPathEx(FALSE, "../images/items/") . $Items->Image->Upload->DbValue;
?>
" border=0<?php
echo $Items->Image->ViewAttributes();
?>
>
<?php
} elseif (!in_array($Items->CurrentAction, array("I", "edit", "gridedit"))) {
?>
<?php
}
}
?>
</td>
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 RenderRow()
{
global $conn, $Security, $Items;
// Call Row_Rendering event
$Items->Row_Rendering();
// Common render codes for all row types
// ItemID
$Items->ItemID->CellCssStyle = "";
$Items->ItemID->CellCssClass = "";
// MenuID
$Items->MenuID->CellCssStyle = "";
$Items->MenuID->CellCssClass = "";
// ItemName
$Items->ItemName->CellCssStyle = "";
$Items->ItemName->CellCssClass = "";
// Description
$Items->Description->CellCssStyle = "";
$Items->Description->CellCssClass = "";
// Price
$Items->Price->CellCssStyle = "";
$Items->Price->CellCssClass = "";
// Image
$Items->Image->CellCssStyle = "";
$Items->Image->CellCssClass = "";
// Vegetarian
$Items->Vegetarian->CellCssStyle = "";
$Items->Vegetarian->CellCssClass = "";
// Vegetarian_Price
$Items->Vegetarian_Price->CellCssStyle = "";
$Items->Vegetarian_Price->CellCssClass = "";
// Color
$Items->Color->CellCssStyle = "";
$Items->Color->CellCssClass = "";
// Sequence
$Items->Sequence->CellCssStyle = "";
$Items->Sequence->CellCssClass = "";
// PDF
$Items->PDF->CellCssStyle = "";
$Items->PDF->CellCssClass = "";
// Active
$Items->Active->CellCssStyle = "";
$Items->Active->CellCssClass = "";
if ($Items->RowType == EW_ROWTYPE_VIEW) {
// View row
// ItemID
$Items->ItemID->ViewValue = $Items->ItemID->CurrentValue;
$Items->ItemID->CssStyle = "";
$Items->ItemID->CssClass = "";
$Items->ItemID->ViewCustomAttributes = "";
// MenuID
if (strval($Items->MenuID->CurrentValue) != "") {
$sSqlWrk = "SELECT `MenuName` FROM `Menus` WHERE `MenuID` = " . ew_AdjustSql($Items->MenuID->CurrentValue) . "";
$sSqlWrk .= " ORDER BY `MenuName` Asc";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup value(s) found
$Items->MenuID->ViewValue = $rswrk->fields('MenuName');
$rswrk->Close();
} else {
$Items->MenuID->ViewValue = $Items->MenuID->CurrentValue;
}
} else {
$Items->MenuID->ViewValue = NULL;
}
$Items->MenuID->CssStyle = "";
$Items->MenuID->CssClass = "";
$Items->MenuID->ViewCustomAttributes = "";
// ItemName
$Items->ItemName->ViewValue = $Items->ItemName->CurrentValue;
$Items->ItemName->CssStyle = "";
$Items->ItemName->CssClass = "";
$Items->ItemName->ViewCustomAttributes = "";
// Description
$Items->Description->ViewValue = ew_TruncateMemo($Items->Description->CurrentValue, 5);
if (!is_null($Items->Description->ViewValue)) {
$Items->Description->ViewValue = str_replace("\n", "<br>", $Items->Description->ViewValue);
}
$Items->Description->CssStyle = "";
$Items->Description->CssClass = "";
$Items->Description->ViewCustomAttributes = "";
// Price
$Items->Price->ViewValue = $Items->Price->CurrentValue;
$Items->Price->ViewValue = ew_FormatCurrency($Items->Price->ViewValue, 2, -2, 0, -2);
$Items->Price->CssStyle = "";
$Items->Price->CssClass = "";
$Items->Price->ViewCustomAttributes = "";
// Image
if (!is_null($Items->Image->Upload->DbValue)) {
$Items->Image->ViewValue = $Items->Image->Upload->DbValue;
$Items->Image->ImageAlt = "";
} else {
$Items->Image->ViewValue = "";
}
$Items->Image->CssStyle = "";
$Items->Image->CssClass = "";
$Items->Image->ViewCustomAttributes = "";
// Vegetarian
if (strval($Items->Vegetarian->CurrentValue) != "") {
switch ($Items->Vegetarian->CurrentValue) {
case "0":
$Items->Vegetarian->ViewValue = "No";
break;
case "1":
$Items->Vegetarian->ViewValue = "Yes";
break;
default:
$Items->Vegetarian->ViewValue = $Items->Vegetarian->CurrentValue;
}
} else {
$Items->Vegetarian->ViewValue = NULL;
}
$Items->Vegetarian->CssStyle = "";
$Items->Vegetarian->CssClass = "";
$Items->Vegetarian->ViewCustomAttributes = "";
// Vegetarian_Price
$Items->Vegetarian_Price->ViewValue = $Items->Vegetarian_Price->CurrentValue;
$Items->Vegetarian_Price->ViewValue = ew_FormatCurrency($Items->Vegetarian_Price->ViewValue, 2, -2, 0, -2);
$Items->Vegetarian_Price->CssStyle = "";
$Items->Vegetarian_Price->CssClass = "";
$Items->Vegetarian_Price->ViewCustomAttributes = "";
// Color
$Items->Color->ViewValue = $Items->Color->CurrentValue;
$Items->Color->CssStyle = "";
$Items->Color->CssClass = "";
$Items->Color->ViewCustomAttributes = "";
// Sequence
$Items->Sequence->ViewValue = $Items->Sequence->CurrentValue;
$Items->Sequence->CssStyle = "";
$Items->Sequence->CssClass = "";
$Items->Sequence->ViewCustomAttributes = "";
// PDF
if (!is_null($Items->PDF->Upload->DbValue)) {
$Items->PDF->ViewValue = $Items->PDF->Upload->DbValue;
} else {
$Items->PDF->ViewValue = "";
}
$Items->PDF->CssStyle = "";
$Items->PDF->CssClass = "";
$Items->PDF->ViewCustomAttributes = "";
// Active
if (strval($Items->Active->CurrentValue) != "") {
switch ($Items->Active->CurrentValue) {
case "0":
$Items->Active->ViewValue = "No";
break;
case "1":
$Items->Active->ViewValue = "Yes";
break;
default:
$Items->Active->ViewValue = $Items->Active->CurrentValue;
}
} else {
$Items->Active->ViewValue = NULL;
}
$Items->Active->CssStyle = "";
$Items->Active->CssClass = "";
$Items->Active->ViewCustomAttributes = "";
// ItemID
$Items->ItemID->HrefValue = "";
// MenuID
$Items->MenuID->HrefValue = "";
// ItemName
$Items->ItemName->HrefValue = "";
// Description
$Items->Description->HrefValue = "";
// Price
$Items->Price->HrefValue = "";
// Image
$Items->Image->HrefValue = "";
// Vegetarian
$Items->Vegetarian->HrefValue = "";
// Vegetarian_Price
$Items->Vegetarian_Price->HrefValue = "";
// Color
$Items->Color->HrefValue = "";
// Sequence
$Items->Sequence->HrefValue = "";
// PDF
if (!is_null($Items->PDF->Upload->DbValue)) {
$Items->PDF->HrefValue = ew_UploadPathEx(FALSE, "../recipes/") . (!empty($Items->PDF->ViewValue) ? $Items->PDF->ViewValue : $Items->PDF->CurrentValue);
if ($Items->Export != "") {
$Items->PDF->HrefValue = ew_ConvertFullUrl($Items->PDF->HrefValue);
}
} else {
$Items->PDF->HrefValue = "";
}
// Active
$Items->Active->HrefValue = "";
}
// Call Row Rendered event
$Items->Row_Rendered();
}
}
// Get session
$obj = new cUpload($tbl, $fld);
$obj->Index = $idx;
if ($restoreDb) {
$obj->RestoreDbFromSession();
$obj->Value = $obj->DbValue;
} else {
$obj->RestoreFromSession();
}
if (is_null($obj->Value)) {
exit;
}
// Restore db file
if ($restoreDbFile) {
$fn = ew_UploadPathEx(TRUE, @$_GET["path"]) . $obj->Value;
if (file_exists($fn)) {
$pathinfo = pathinfo($fn);
$ext = strtolower($pathinfo['extension']);
if (in_array($ext, explode(',', EW_IMAGE_ALLOWED_FILE_EXT))) {
$size = getimagesize($fn);
if ($size) {
header("Content-type: {$size['mime']}");
}
echo ew_ResizeFileToBinary($fn, $width, $height, $quality);
}
}
} else {
// If not IE, get the content type
if (strpos(ew_ServerVar("HTTP_USER_AGENT"), "MSIE") === FALSE) {
$tmpfname = tempnam(ew_TmpFolder(), 'tmp');
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 $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 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 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 Page_Main()
{
global $conn, $uploadid, $uploadtable;
$GLOBALS["Page"] =& $this;
$Language = new cLanguage();
//**$conn = ew_Connect();
// Global Page Loading event (in userfn*.php)
//**Page_Loading();
// Set up upload parameters
$uploadid = @$_GET["id"] != "" ? $_GET["id"] : (@$_POST["id"] != "" ? $_POST["id"] : "");
$uploadtable = @$_GET["table"] != "" ? $_GET["table"] : (@$_POST["table"] != "" ? $_POST["table"] : "");
$exts = @$_POST["exts"] != "" ? $_POST["exts"] : "";
$filetypes = $exts == "" ? '/.+$/i' : '/\\.(' . str_replace(",", "|", $exts) . ')$/i';
$maxsize = @$_POST["maxsize"] != "" ? intval($_POST["maxsize"]) : NULL;
$maxfilecount = @$_POST["maxfilecount"] != "" && @$_POST["maxfilecount"] != "0" ? intval($_POST["maxfilecount"]) : NULL;
$url = ew_FullUrl() . "?rnd=" . ew_Random() . ($uploadid != "" ? "&id=" . $uploadid : "") . ($uploadtable != "" ? "&table=" . $uploadtable : "");
// Add id/table for display and delete
$options = array("param_name" => $uploadid, "delete_type" => "POST", "user_dirs" => TRUE, "download_via_php" => TRUE, "script_url" => $url, "upload_dir" => EW_UPLOAD_TEMP_PATH ? ew_IncludeTrailingDelimiter(EW_UPLOAD_TEMP_PATH, TRUE) : ew_UploadPathEx(TRUE, EW_UPLOAD_DEST_PATH), "upload_url" => ew_UploadPathEx(FALSE, EW_UPLOAD_DEST_PATH), "max_file_size" => $maxsize, "max_number_of_files" => $maxfilecount, "accept_file_types" => $filetypes, "image_versions" => array(EW_UPLOAD_THUMBNAIL_FOLDER => array("max_width" => EW_UPLOAD_THUMBNAIL_WIDTH, "max_height" => EW_UPLOAD_THUMBNAIL_HEIGHT, "jpeg_quality" => EW_THUMBNAIL_DEFAULT_QUALITY, "png_quality" => 9)));
$error_messages = array(1 => $Language->Phrase("UploadErrMsg1"), 2 => $Language->Phrase("UploadErrMsg2"), 3 => $Language->Phrase("UploadErrMsg3"), 4 => $Language->Phrase("UploadErrMsg4"), 6 => $Language->Phrase("UploadErrMsg6"), 7 => $Language->Phrase("UploadErrMsg7"), 8 => $Language->Phrase("UploadErrMsg8"), 'post_max_size' => $Language->Phrase("UploadErrMsgPostMaxSize"), 'max_file_size' => $Language->Phrase("UploadErrMsgMaxFileSize"), 'min_file_size' => $Language->Phrase("UploadErrMsgMinFileSize"), 'accept_file_types' => $Language->Phrase("UploadErrMsgAcceptFileTypes"), 'max_number_of_files' => $Language->Phrase("UploadErrMsgMaxNumberOfFiles"), 'max_width' => $Language->Phrase("UploadErrMsgMaxWidth"), 'min_width' => $Language->Phrase("UploadErrMsgMinWidth"), 'max_height' => $Language->Phrase("UploadErrMsgMaxHeight"), 'min_height' => $Language->Phrase("UploadErrMsgMinHeight"));
ob_end_clean();
$upload_handler = new cUploadHandler($options, TRUE, $error_messages);
// Global Page Unloaded event (in userfn*.php)
//**Page_Unloaded();
// Close connection
//**ew_CloseConn();
}
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 RenderListRow()
{
global $conn, $Security;
// Call Row Rendering event
$this->Row_Rendering();
// Common render codes
// cat_id
$this->cat_id->CellCssStyle = "white-space: nowrap;";
// cat_name
// cat_file
// cat_date
// cat_id
$this->cat_id->ViewValue = $this->cat_id->CurrentValue;
$this->cat_id->ViewCustomAttributes = "";
// cat_name
$this->cat_name->ViewValue = $this->cat_name->CurrentValue;
$this->cat_name->ViewCustomAttributes = "";
// cat_file
$this->cat_file->UploadPath = "/catalogues/";
if (!ew_Empty($this->cat_file->Upload->DbValue)) {
$this->cat_file->ViewValue = $this->cat_file->Upload->DbValue;
} else {
$this->cat_file->ViewValue = "";
}
$this->cat_file->ViewCustomAttributes = "";
// cat_date
$this->cat_date->ViewValue = $this->cat_date->CurrentValue;
$this->cat_date->ViewValue = ew_FormatDateTime($this->cat_date->ViewValue, 5);
$this->cat_date->ViewCustomAttributes = "";
// cat_id
$this->cat_id->LinkCustomAttributes = "";
$this->cat_id->HrefValue = "";
$this->cat_id->TooltipValue = "";
// cat_name
$this->cat_name->LinkCustomAttributes = "";
$this->cat_name->HrefValue = "";
$this->cat_name->TooltipValue = "";
// cat_file
$this->cat_file->LinkCustomAttributes = "";
$this->cat_file->UploadPath = "/catalogues/";
if (!ew_Empty($this->cat_file->Upload->DbValue)) {
$this->cat_file->HrefValue = ew_UploadPathEx(FALSE, $this->cat_file->UploadPath) . $this->cat_file->Upload->DbValue;
// Add prefix/suffix
$this->cat_file->LinkAttrs["target"] = "";
// Add target
if ($this->Export != "") {
$this->cat_file->HrefValue = ew_ConvertFullUrl($this->cat_file->HrefValue);
}
} else {
$this->cat_file->HrefValue = "";
}
$this->cat_file->HrefValue2 = $this->cat_file->UploadPath . $this->cat_file->Upload->DbValue;
$this->cat_file->TooltipValue = "";
// cat_date
$this->cat_date->LinkCustomAttributes = "";
$this->cat_date->HrefValue = "";
$this->cat_date->TooltipValue = "";
// Call Row Rendered event
$this->Row_Rendered();
}
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 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 $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 RenderRow()
{
global $conn, $Security, $Language;
global $gsLanguage;
// Initialize URLs
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// cat_id
$this->cat_id->CellCssStyle = "white-space: nowrap;";
// cat_name
// cat_file
// cat_date
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// cat_name
$this->cat_name->ViewValue = $this->cat_name->CurrentValue;
$this->cat_name->ViewCustomAttributes = "";
// cat_file
$this->cat_file->UploadPath = "/catalogues/";
if (!ew_Empty($this->cat_file->Upload->DbValue)) {
$this->cat_file->ViewValue = $this->cat_file->Upload->DbValue;
} else {
$this->cat_file->ViewValue = "";
}
$this->cat_file->ViewCustomAttributes = "";
// cat_date
$this->cat_date->ViewValue = $this->cat_date->CurrentValue;
$this->cat_date->ViewValue = ew_FormatDateTime($this->cat_date->ViewValue, 5);
$this->cat_date->ViewCustomAttributes = "";
// cat_name
$this->cat_name->LinkCustomAttributes = "";
$this->cat_name->HrefValue = "";
$this->cat_name->TooltipValue = "";
// cat_file
$this->cat_file->LinkCustomAttributes = "";
$this->cat_file->UploadPath = "/catalogues/";
if (!ew_Empty($this->cat_file->Upload->DbValue)) {
$this->cat_file->HrefValue = ew_UploadPathEx(FALSE, $this->cat_file->UploadPath) . $this->cat_file->Upload->DbValue;
// Add prefix/suffix
$this->cat_file->LinkAttrs["target"] = "";
// Add target
if ($this->Export != "") {
$this->cat_file->HrefValue = ew_ConvertFullUrl($this->cat_file->HrefValue);
}
} else {
$this->cat_file->HrefValue = "";
}
$this->cat_file->HrefValue2 = $this->cat_file->UploadPath . $this->cat_file->Upload->DbValue;
$this->cat_file->TooltipValue = "";
// cat_date
$this->cat_date->LinkCustomAttributes = "";
$this->cat_date->HrefValue = "";
$this->cat_date->TooltipValue = "";
}
// Call Row Rendered event
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$this->Row_Rendered();
}
}
function DeleteRows()
{
global $Language, $Security;
$DeleteRows = TRUE;
$sSql = $this->SQL();
$conn =& $this->Connection();
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
$rs = $conn->Execute($sSql);
$conn->raiseErrorFn = '';
if ($rs === FALSE) {
return FALSE;
} elseif ($rs->EOF) {
$this->setFailureMessage($Language->Phrase("NoRecord"));
// No record found
$rs->Close();
return FALSE;
//} else {
// $this->LoadRowValues($rs); // Load row values
}
$rows = $rs ? $rs->GetRows() : array();
$conn->BeginTrans();
// Clone old rows
$rsold = $rows;
if ($rs) {
$rs->Close();
}
// Call row deleting event
if ($DeleteRows) {
foreach ($rsold as $row) {
$DeleteRows = $this->Row_Deleting($row);
if (!$DeleteRows) {
break;
}
}
}
if ($DeleteRows) {
$sKey = "";
foreach ($rsold as $row) {
$sThisKey = "";
if ($sThisKey != "") {
$sThisKey .= $GLOBALS["EW_COMPOSITE_KEY_SEPARATOR"];
}
$sThisKey .= $row['product_id'];
$this->LoadDbValues($row);
@unlink(ew_UploadPathEx(TRUE, $this->product_image->OldUploadPath) . $row['product_image']);
@unlink(ew_UploadPathEx(TRUE, $this->product_secimage->OldUploadPath) . $row['product_secimage']);
$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];
$DeleteRows = $this->Delete($row);
// Delete
$conn->raiseErrorFn = '';
if ($DeleteRows === FALSE) {
break;
}
if ($sKey != "") {
$sKey .= ", ";
}
$sKey .= $sThisKey;
}
} else {
// Set up error message
if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") {
// Use the message, do nothing
} elseif ($this->CancelMessage != "") {
$this->setFailureMessage($this->CancelMessage);
$this->CancelMessage = "";
} else {
$this->setFailureMessage($Language->Phrase("DeleteCancelled"));
}
}
if ($DeleteRows) {
$conn->CommitTrans();
// Commit the changes
} else {
$conn->RollbackTrans();
// Rollback changes
}
// Call Row Deleted event
if ($DeleteRows) {
foreach ($rsold as $row) {
$this->Row_Deleted($row);
}
}
return $DeleteRows;
}
function RenderRow()
{
global $conn, $Security, $ItemDetails;
// Call Row_Rendering event
$ItemDetails->Row_Rendering();
// Common render codes for all row types
// ItemID
$ItemDetails->ItemID->CellCssStyle = "";
$ItemDetails->ItemID->CellCssClass = "";
// Time_to_Table
$ItemDetails->Time_to_Table->CellCssStyle = "";
$ItemDetails->Time_to_Table->CellCssClass = "";
// Level_Of_Difficulty
$ItemDetails->Level_Of_Difficulty->CellCssStyle = "";
$ItemDetails->Level_Of_Difficulty->CellCssClass = "";
// Beverage_Pairing
$ItemDetails->Beverage_Pairing->CellCssStyle = "";
$ItemDetails->Beverage_Pairing->CellCssClass = "";
// Vegetarian_Subsitution
$ItemDetails->Vegetarian_Subsitution->CellCssStyle = "";
$ItemDetails->Vegetarian_Subsitution->CellCssClass = "";
// Calories
$ItemDetails->Calories->CellCssStyle = "";
$ItemDetails->Calories->CellCssClass = "";
// Other
$ItemDetails->Other->CellCssStyle = "";
$ItemDetails->Other->CellCssClass = "";
// Image
$ItemDetails->Image->CellCssStyle = "";
$ItemDetails->Image->CellCssClass = "";
if ($ItemDetails->RowType == EW_ROWTYPE_VIEW) {
// View row
// ItemID
if (strval($ItemDetails->ItemID->CurrentValue) != "") {
$sSqlWrk = "SELECT `ItemName` FROM `Items` WHERE `ItemID` = " . ew_AdjustSql($ItemDetails->ItemID->CurrentValue) . "";
$sSqlWrk .= " ORDER BY `ItemName` Asc";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup value(s) found
$ItemDetails->ItemID->ViewValue = $rswrk->fields('ItemName');
$rswrk->Close();
} else {
$ItemDetails->ItemID->ViewValue = $ItemDetails->ItemID->CurrentValue;
}
} else {
$ItemDetails->ItemID->ViewValue = NULL;
}
$ItemDetails->ItemID->CssStyle = "";
$ItemDetails->ItemID->CssClass = "";
$ItemDetails->ItemID->ViewCustomAttributes = "";
// Time_to_Table
$ItemDetails->Time_to_Table->ViewValue = $ItemDetails->Time_to_Table->CurrentValue;
$ItemDetails->Time_to_Table->CssStyle = "";
$ItemDetails->Time_to_Table->CssClass = "";
$ItemDetails->Time_to_Table->ViewCustomAttributes = "";
// Level_Of_Difficulty
$ItemDetails->Level_Of_Difficulty->ViewValue = $ItemDetails->Level_Of_Difficulty->CurrentValue;
$ItemDetails->Level_Of_Difficulty->CssStyle = "";
$ItemDetails->Level_Of_Difficulty->CssClass = "";
$ItemDetails->Level_Of_Difficulty->ViewCustomAttributes = "";
// Beverage_Pairing
$ItemDetails->Beverage_Pairing->ViewValue = $ItemDetails->Beverage_Pairing->CurrentValue;
$ItemDetails->Beverage_Pairing->CssStyle = "";
$ItemDetails->Beverage_Pairing->CssClass = "";
$ItemDetails->Beverage_Pairing->ViewCustomAttributes = "";
// Vegetarian_Subsitution
$ItemDetails->Vegetarian_Subsitution->ViewValue = $ItemDetails->Vegetarian_Subsitution->CurrentValue;
$ItemDetails->Vegetarian_Subsitution->CssStyle = "";
$ItemDetails->Vegetarian_Subsitution->CssClass = "";
$ItemDetails->Vegetarian_Subsitution->ViewCustomAttributes = "";
// Calories
$ItemDetails->Calories->ViewValue = $ItemDetails->Calories->CurrentValue;
$ItemDetails->Calories->CssStyle = "";
$ItemDetails->Calories->CssClass = "";
$ItemDetails->Calories->ViewCustomAttributes = "";
// Other
$ItemDetails->Other->ViewValue = $ItemDetails->Other->CurrentValue;
$ItemDetails->Other->CssStyle = "";
$ItemDetails->Other->CssClass = "";
$ItemDetails->Other->ViewCustomAttributes = "";
// Image
if (!is_null($ItemDetails->Image->Upload->DbValue)) {
$ItemDetails->Image->ViewValue = $ItemDetails->Image->Upload->DbValue;
} else {
$ItemDetails->Image->ViewValue = "";
}
$ItemDetails->Image->CssStyle = "";
$ItemDetails->Image->CssClass = "";
$ItemDetails->Image->ViewCustomAttributes = "";
// ItemID
$ItemDetails->ItemID->HrefValue = "";
// Time_to_Table
$ItemDetails->Time_to_Table->HrefValue = "";
// Level_Of_Difficulty
$ItemDetails->Level_Of_Difficulty->HrefValue = "";
// Beverage_Pairing
$ItemDetails->Beverage_Pairing->HrefValue = "";
// Vegetarian_Subsitution
$ItemDetails->Vegetarian_Subsitution->HrefValue = "";
// Calories
$ItemDetails->Calories->HrefValue = "";
// Other
$ItemDetails->Other->HrefValue = "";
// Image
if (!is_null($ItemDetails->Image->Upload->DbValue)) {
$ItemDetails->Image->HrefValue = ew_UploadPathEx(FALSE, "../images/items/") . (!empty($ItemDetails->Image->ViewValue) ? $ItemDetails->Image->ViewValue : $ItemDetails->Image->CurrentValue);
if ($ItemDetails->Export != "") {
$ItemDetails->Image->HrefValue = ew_ConvertFullUrl($ItemDetails->Image->HrefValue);
}
} else {
$ItemDetails->Image->HrefValue = "";
}
}
// Call Row Rendered event
$ItemDetails->Row_Rendered();
}
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 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 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 RenderRow()
{
global $conn, $Security, $Language;
global $gsLanguage;
// Initialize URLs
$this->AddUrl = $this->GetAddUrl();
$this->EditUrl = $this->GetEditUrl();
$this->CopyUrl = $this->GetCopyUrl();
$this->DeleteUrl = $this->GetDeleteUrl();
$this->ListUrl = $this->GetListUrl();
// Convert decimal values if posted back
if ($this->teacher_rate->FormValue == $this->teacher_rate->CurrentValue && is_numeric(ew_StrToFloat($this->teacher_rate->CurrentValue))) {
$this->teacher_rate->CurrentValue = ew_StrToFloat($this->teacher_rate->CurrentValue);
}
// Call Row_Rendering event
$this->Row_Rendering();
// Common render codes for all row types
// teacher_id
// teacher_name
// teacher_personal_page
// teacher_avatar
// teacher_description
// teacher_work_place
// teacher_active
// teacher_acadamic_title
// teacher_birthday
// teacher_sex
// teacher_faculty
// teacher_dept
// teacher_rate
// teacher_personality
// advices
// teacher_research
if ($this->RowType == EW_ROWTYPE_VIEW) {
// View row
// teacher_id
$this->teacher_id->ViewValue = $this->teacher_id->CurrentValue;
$this->teacher_id->ViewCustomAttributes = "";
// teacher_name
$this->teacher_name->ViewValue = $this->teacher_name->CurrentValue;
$this->teacher_name->ViewCustomAttributes = "";
// teacher_personal_page
$this->teacher_personal_page->ViewValue = $this->teacher_personal_page->CurrentValue;
$this->teacher_personal_page->ViewCustomAttributes = "";
// teacher_avatar
$this->teacher_avatar->UploadPath = 'themes\\classic\\assets\\img\\Teacher_img';
if (!ew_Empty($this->teacher_avatar->Upload->DbValue)) {
$this->teacher_avatar->ImageAlt = $this->teacher_avatar->FldAlt();
$this->teacher_avatar->ViewValue = ew_UploadPathEx(FALSE, $this->teacher_avatar->UploadPath) . $this->teacher_avatar->Upload->DbValue;
} else {
$this->teacher_avatar->ViewValue = "";
}
$this->teacher_avatar->ViewCustomAttributes = "";
// teacher_description
$this->teacher_description->ViewValue = $this->teacher_description->CurrentValue;
$this->teacher_description->ViewCustomAttributes = "";
// teacher_work_place
$this->teacher_work_place->ViewValue = $this->teacher_work_place->CurrentValue;
$this->teacher_work_place->ViewCustomAttributes = "";
// teacher_active
$this->teacher_active->ViewValue = $this->teacher_active->CurrentValue;
$this->teacher_active->ViewCustomAttributes = "";
// teacher_acadamic_title
$this->teacher_acadamic_title->ViewValue = $this->teacher_acadamic_title->CurrentValue;
$this->teacher_acadamic_title->ViewCustomAttributes = "";
// teacher_birthday
$this->teacher_birthday->ViewValue = $this->teacher_birthday->CurrentValue;
$this->teacher_birthday->ViewCustomAttributes = "";
// teacher_sex
$this->teacher_sex->ViewValue = $this->teacher_sex->CurrentValue;
$this->teacher_sex->ViewCustomAttributes = "";
// teacher_faculty
if (strval($this->teacher_faculty->CurrentValue) != "") {
$sFilterWrk = "`faculty_id`" . ew_SearchString("=", $this->teacher_faculty->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `faculty_id`, `faculty_name` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tbl_faculty`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->teacher_faculty->ViewValue = $rswrk->fields('DispFld');
$rswrk->Close();
} else {
$this->teacher_faculty->ViewValue = $this->teacher_faculty->CurrentValue;
}
} else {
$this->teacher_faculty->ViewValue = NULL;
}
$this->teacher_faculty->ViewCustomAttributes = "";
// teacher_dept
if (strval($this->teacher_dept->CurrentValue) != "") {
$sFilterWrk = "`dept_id`" . ew_SearchString("=", $this->teacher_dept->CurrentValue, EW_DATATYPE_NUMBER);
$sSqlWrk = "SELECT `dept_id`, `dept_name` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tbl_dept`";
$sWhereWrk = "";
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->teacher_dept->ViewValue = $rswrk->fields('DispFld');
$rswrk->Close();
} else {
$this->teacher_dept->ViewValue = $this->teacher_dept->CurrentValue;
}
} else {
$this->teacher_dept->ViewValue = NULL;
}
$this->teacher_dept->ViewCustomAttributes = "";
// teacher_rate
$this->teacher_rate->ViewValue = $this->teacher_rate->CurrentValue;
$this->teacher_rate->ViewCustomAttributes = "";
// teacher_personality
$this->teacher_personality->ViewValue = $this->teacher_personality->CurrentValue;
$this->teacher_personality->ViewCustomAttributes = "";
// advices
$this->advices->ViewValue = $this->advices->CurrentValue;
$this->advices->ViewCustomAttributes = "";
// teacher_research
$this->teacher_research->ViewValue = $this->teacher_research->CurrentValue;
$this->teacher_research->ViewCustomAttributes = "";
// teacher_id
$this->teacher_id->LinkCustomAttributes = "";
$this->teacher_id->HrefValue = "";
$this->teacher_id->TooltipValue = "";
// teacher_name
$this->teacher_name->LinkCustomAttributes = "";
$this->teacher_name->HrefValue = "";
$this->teacher_name->TooltipValue = "";
// teacher_personal_page
$this->teacher_personal_page->LinkCustomAttributes = "";
$this->teacher_personal_page->HrefValue = "";
$this->teacher_personal_page->TooltipValue = "";
// teacher_avatar
$this->teacher_avatar->LinkCustomAttributes = "";
$this->teacher_avatar->HrefValue = "";
$this->teacher_avatar->TooltipValue = "";
// teacher_description
$this->teacher_description->LinkCustomAttributes = "";
$this->teacher_description->HrefValue = "";
$this->teacher_description->TooltipValue = "";
// teacher_work_place
$this->teacher_work_place->LinkCustomAttributes = "";
$this->teacher_work_place->HrefValue = "";
$this->teacher_work_place->TooltipValue = "";
// teacher_active
$this->teacher_active->LinkCustomAttributes = "";
$this->teacher_active->HrefValue = "";
$this->teacher_active->TooltipValue = "";
// teacher_acadamic_title
$this->teacher_acadamic_title->LinkCustomAttributes = "";
$this->teacher_acadamic_title->HrefValue = "";
$this->teacher_acadamic_title->TooltipValue = "";
// teacher_birthday
$this->teacher_birthday->LinkCustomAttributes = "";
$this->teacher_birthday->HrefValue = "";
$this->teacher_birthday->TooltipValue = "";
// teacher_sex
$this->teacher_sex->LinkCustomAttributes = "";
$this->teacher_sex->HrefValue = "";
$this->teacher_sex->TooltipValue = "";
// teacher_faculty
$this->teacher_faculty->LinkCustomAttributes = "";
$this->teacher_faculty->HrefValue = "";
$this->teacher_faculty->TooltipValue = "";
// teacher_dept
$this->teacher_dept->LinkCustomAttributes = "";
$this->teacher_dept->HrefValue = "";
$this->teacher_dept->TooltipValue = "";
// teacher_rate
$this->teacher_rate->LinkCustomAttributes = "";
$this->teacher_rate->HrefValue = "";
$this->teacher_rate->TooltipValue = "";
// teacher_personality
$this->teacher_personality->LinkCustomAttributes = "";
$this->teacher_personality->HrefValue = "";
$this->teacher_personality->TooltipValue = "";
// advices
$this->advices->LinkCustomAttributes = "";
$this->advices->HrefValue = "";
$this->advices->TooltipValue = "";
// teacher_research
$this->teacher_research->LinkCustomAttributes = "";
$this->teacher_research->HrefValue = "";
$this->teacher_research->TooltipValue = "";
}
// Call Row Rendered event
if ($this->RowType != EW_ROWTYPE_AGGREGATEINIT) {
$this->Row_Rendered();
}
}
function RenderListRow()
{
global $conn, $Security;
// Call Row Rendering event
$this->Row_Rendering();
// Common render codes
// cliente
$this->cliente->CellCssStyle = "white-space: nowrap;";
// objetos
$this->objetos->CellCssStyle = "white-space: nowrap;";
// precio
$this->precio->CellCssStyle = "white-space: nowrap;";
// entrega
$this->entrega->CellCssStyle = "white-space: nowrap;";
// saldo
$this->saldo->CellCssStyle = "white-space: nowrap;";
// estado
$this->estado->CellCssStyle = "white-space: nowrap;";
// fecha_recepcion
$this->fecha_recepcion->CellCssStyle = "white-space: nowrap;";
// fecha_entrega
$this->fecha_entrega->CellCssStyle = "white-space: nowrap;";
// foto1
$this->foto1->CellCssStyle = "white-space: nowrap;";
// foto2
$this->foto2->CellCssStyle = "white-space: nowrap;";
// cliente
$this->cliente->ViewValue = $this->cliente->CurrentValue;
$this->cliente->ViewCustomAttributes = "";
// objetos
$this->objetos->ViewValue = $this->objetos->CurrentValue;
$this->objetos->ViewCustomAttributes = "";
// precio
$this->precio->ViewValue = $this->precio->CurrentValue;
$this->precio->ViewCustomAttributes = "";
// entrega
$this->entrega->ViewValue = $this->entrega->CurrentValue;
$this->entrega->ViewCustomAttributes = "";
// saldo
$this->saldo->ViewValue = $this->saldo->CurrentValue;
$this->saldo->ViewCustomAttributes = "";
// estado
if (strval($this->estado->CurrentValue) != "") {
$sFilterWrk = "`estado`" . ew_SearchString("=", $this->estado->CurrentValue, EW_DATATYPE_STRING);
$sSqlWrk = "SELECT `estado`, `estado` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `estados`";
$sWhereWrk = "";
$lookuptblfilter = "`activo`='S'";
if (strval($lookuptblfilter) != "") {
ew_AddFilter($sWhereWrk, $lookuptblfilter);
}
if ($sFilterWrk != "") {
ew_AddFilter($sWhereWrk, $sFilterWrk);
}
// Call Lookup selecting
$this->Lookup_Selecting($this->estado, $sWhereWrk);
if ($sWhereWrk != "") {
$sSqlWrk .= " WHERE " . $sWhereWrk;
}
$sSqlWrk .= " ORDER BY `codigo` ASC";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup values found
$this->estado->ViewValue = $rswrk->fields('DispFld');
$rswrk->Close();
} else {
$this->estado->ViewValue = $this->estado->CurrentValue;
}
} else {
$this->estado->ViewValue = NULL;
}
$this->estado->ViewCustomAttributes = "";
// fecha_recepcion
$this->fecha_recepcion->ViewValue = $this->fecha_recepcion->CurrentValue;
$this->fecha_recepcion->ViewValue = ew_FormatDateTime($this->fecha_recepcion->ViewValue, 7);
$this->fecha_recepcion->ViewCustomAttributes = "";
// fecha_entrega
$this->fecha_entrega->ViewValue = $this->fecha_entrega->CurrentValue;
$this->fecha_entrega->ViewValue = ew_FormatDateTime($this->fecha_entrega->ViewValue, 7);
$this->fecha_entrega->ViewCustomAttributes = "";
// foto1
if (!ew_Empty($this->foto1->Upload->DbValue)) {
$this->foto1->ImageWidth = 40;
$this->foto1->ImageHeight = 40;
$this->foto1->ImageAlt = $this->foto1->FldAlt();
$this->foto1->ViewValue = ew_UploadPathEx(FALSE, $this->foto1->UploadPath) . $this->foto1->Upload->DbValue;
} else {
$this->foto1->ViewValue = "";
}
$this->foto1->ViewCustomAttributes = "";
// foto2
if (!ew_Empty($this->foto2->Upload->DbValue)) {
$this->foto2->ImageWidth = 10;
$this->foto2->ImageHeight = 10;
$this->foto2->ImageAlt = $this->foto2->FldAlt();
$this->foto2->ViewValue = ew_UploadPathEx(FALSE, $this->foto2->UploadPath) . $this->foto2->Upload->DbValue;
} else {
$this->foto2->ViewValue = "";
}
$this->foto2->ViewCustomAttributes = "";
// cliente
$this->cliente->LinkCustomAttributes = "";
$this->cliente->HrefValue = "";
$this->cliente->TooltipValue = "";
// objetos
$this->objetos->LinkCustomAttributes = "";
$this->objetos->HrefValue = "";
$this->objetos->TooltipValue = "";
// precio
$this->precio->LinkCustomAttributes = "";
$this->precio->HrefValue = "";
$this->precio->TooltipValue = "";
// entrega
$this->entrega->LinkCustomAttributes = "";
$this->entrega->HrefValue = "";
$this->entrega->TooltipValue = "";
// saldo
$this->saldo->LinkCustomAttributes = "";
$this->saldo->HrefValue = "";
$this->saldo->TooltipValue = "";
// estado
$this->estado->LinkCustomAttributes = "";
$this->estado->HrefValue = "";
$this->estado->TooltipValue = "";
// fecha_recepcion
$this->fecha_recepcion->LinkCustomAttributes = "";
$this->fecha_recepcion->HrefValue = "";
$this->fecha_recepcion->TooltipValue = "";
// fecha_entrega
$this->fecha_entrega->LinkCustomAttributes = "";
$this->fecha_entrega->HrefValue = "";
$this->fecha_entrega->TooltipValue = "";
// foto1
$this->foto1->LinkCustomAttributes = "";
$this->foto1->HrefValue = "";
$this->foto1->HrefValue2 = $this->foto1->UploadPath . $this->foto1->Upload->DbValue;
$this->foto1->TooltipValue = "";
// foto2
$this->foto2->LinkCustomAttributes = "";
$this->foto2->HrefValue = "";
$this->foto2->HrefValue2 = $this->foto2->UploadPath . $this->foto2->Upload->DbValue;
$this->foto2->TooltipValue = "";
// Call Row Rendered event
$this->Row_Rendered();
}
function ew_UploadPath($PhyPath)
{
return ew_UploadPathEx($PhyPath, EW_UPLOAD_DEST_PATH);
}
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;
}
?>
>
<span id="el_gallery_detail_gd_images" class="control-group">
<span<?php
echo $gallery_detail->gd_images->ViewAttributes();
?>
>
<?php
$Files = explode(",", $gallery_detail->gd_images->Upload->DbValue);
$HrefValue = $gallery_detail->gd_images->HrefValue;
$FileCount = count($Files);
for ($i = 0; $i < $FileCount; $i++) {
if ($Files[$i] != "") {
$gallery_detail->gd_images->ViewValue = $Files[$i];
$gallery_detail->gd_images->HrefValue = str_replace("%u", ew_HtmlEncode(ew_UploadPathEx(FALSE, $gallery_detail->gd_images->UploadPath) . $Files[$i]), $HrefValue);
$Files[$i] = str_replace("%f", ew_HtmlEncode(ew_UploadPathEx(FALSE, $gallery_detail->gd_images->UploadPath) . $Files[$i]), $gallery_detail->gd_images->ViewValue);
if ($gallery_detail->gd_images->LinkAttributes() != "") {
if (!empty($gallery_detail->gd_images->Upload->DbValue)) {
echo $gallery_detail->gd_images->ViewValue;
} elseif (!in_array($gallery_detail->CurrentAction, array("I", "edit", "gridedit"))) {
?>
<?php
}
} else {
if (!empty($gallery_detail->gd_images->Upload->DbValue)) {
echo $gallery_detail->gd_images->ViewValue;
} elseif (!in_array($gallery_detail->CurrentAction, array("I", "edit", "gridedit"))) {
?>
$ar = parent::post(FALSE);
if (array_key_exists($this->options["param_name"], $ar)) {
$ar["files"] = $ar[$this->options["param_name"]];
// Set key as "files" for jquery.fileupload-ui.js
unset($ar[$this->options["param_name"]]);
}
return $this->generate_response($ar, $print_response);
}
// Override upcount_name_callback()
protected function upcount_name_callback($matches)
{
$index = isset($matches[1]) ? intval($matches[1]) + 1 : 1;
$ext = isset($matches[2]) ? $matches[2] : '';
return '(' . $index . ')' . $ext;
}
// Override upcount_name()
protected function upcount_name($name)
{
return preg_replace_callback('/(?:(?:\\(([\\d]+)\\))?(\\.[^.]+))?$/', array($this, 'upcount_name_callback'), $name, 1);
}
}
$Language = new cLanguage();
// Set up upload parameters
$uploadid = @$_GET["id"] != "" ? $_GET["id"] : (@$_POST["id"] != "" ? $_POST["id"] : "");
$filetypes = EW_UPLOAD_ALLOWED_FILE_EXT == "" ? "/.+\$/i" : "/.[" . str_replace(",", "|", EW_UPLOAD_ALLOWED_FILE_EXT) . "]\$/i";
$url = ew_FullUrl() . "?rnd=" . ew_Random() . ($uploadid != "" ? "&id=" . $uploadid : "");
// Add id for display and delete
$options = array("param_name" => $uploadid, "user_dirs" => TRUE, "download_via_php" => TRUE, "script_url" => $url, "upload_dir" => ew_UploadPathEx(TRUE, EW_UPLOAD_DEST_PATH), "upload_url" => ew_UploadPathEx(FALSE, EW_UPLOAD_DEST_PATH), "max_file_size" => EW_MAX_FILE_SIZE, "accept_file_types" => $filetypes, "image_versions" => array(EW_UPLOAD_THUMBNAIL_FOLDER => array("max_width" => EW_UPLOAD_THUMBNAIL_WIDTH, "max_height" => EW_UPLOAD_THUMBNAIL_HEIGHT, "jpeg_quality" => EW_THUMBNAIL_DEFAULT_QUALITY, "png_quality" => 9)));
$error_messages = array(1 => $Language->Phrase("UploadErrMsg1"), 2 => $Language->Phrase("UploadErrMsg2"), 3 => $Language->Phrase("UploadErrMsg3"), 4 => $Language->Phrase("UploadErrMsg4"), 6 => $Language->Phrase("UploadErrMsg6"), 7 => $Language->Phrase("UploadErrMsg7"), 8 => $Language->Phrase("UploadErrMsg8"), 'post_max_size' => $Language->Phrase("UploadErrMsgPostMaxSize"), 'max_file_size' => $Language->Phrase("UploadErrMsgMaxFileSize"), 'min_file_size' => $Language->Phrase("UploadErrMsgMinFileSize"), 'accept_file_types' => $Language->Phrase("UploadErrMsgAcceptFileTypes"), 'max_number_of_files' => $Language->Phrase("UploadErrMsgMaxNumberOfFiles"), 'max_width' => $Language->Phrase("UploadErrMsgMaxWidth"), 'min_width' => $Language->Phrase("UploadErrMsgMinWidth"), 'max_height' => $Language->Phrase("UploadErrMsgMaxHeight"), 'min_height' => $Language->Phrase("UploadErrMsgMinHeight"));
ob_end_clean();
$upload_handler = new cUploadHandler($options, TRUE, $error_messages);
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;
}