function EditRow() { global $conn, $Security, $Orders; $sFilter = $Orders->KeyFilter(); $Orders->CurrentFilter = $sFilter; $sSql = $Orders->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 OrderID // Field CustomerID $Orders->CustomerID->SetDbValueDef($Orders->CustomerID->CurrentValue, 0); $rsnew['CustomerID'] =& $Orders->CustomerID->DbValue; // Field TransactionNumber $Orders->TransactionNumber->SetDbValueDef($Orders->TransactionNumber->CurrentValue, NULL); $rsnew['TransactionNumber'] =& $Orders->TransactionNumber->DbValue; // Field DateOrdered $Orders->DateOrdered->SetDbValueDef(ew_UnFormatDateTime($Orders->DateOrdered->CurrentValue, 6), ew_CurrentDate()); $rsnew['DateOrdered'] =& $Orders->DateOrdered->DbValue; // Field Total $Orders->Total->SetDbValueDef($Orders->Total->CurrentValue, 0); $rsnew['Total'] =& $Orders->Total->DbValue; // Field DeliveryDate $Orders->DeliveryDate->SetDbValueDef(ew_UnFormatDateTime($Orders->DeliveryDate->CurrentValue, 6), ew_CurrentDate()); $rsnew['DeliveryDate'] =& $Orders->DeliveryDate->DbValue; // Field PromoCodeID $Orders->PromoCodeID->SetDbValueDef($Orders->PromoCodeID->CurrentValue, NULL); $rsnew['PromoCodeID'] =& $Orders->PromoCodeID->DbValue; // Field Sequence $Orders->Sequence->SetDbValueDef($Orders->Sequence->CurrentValue, NULL); $rsnew['Sequence'] =& $Orders->Sequence->DbValue; // Call Row Updating event $bUpdateRow = $Orders->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($Orders->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($Orders->CancelMessage != "") { $this->setMessage($Orders->CancelMessage); $Orders->CancelMessage = ""; } else { $this->setMessage("Update cancelled"); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) { $Orders->Row_Updated($rsold, $rsnew); } $rs->Close(); return $EditRow; }
function AddRow($rsold = NULL) { global $conn, $Language, $Security; // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); } $rsnew = array(); // Password $this->Password->SetDbValueDef($rsnew, $this->Password->CurrentValue, "", FALSE); // Email $this->_Email->SetDbValueDef($rsnew, $this->_Email->CurrentValue, "", FALSE); // Created $this->Created->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->Created->CurrentValue, 5), ew_CurrentDate(), strval($this->Created->CurrentValue) == ""); // Type $this->Type->SetDbValueDef($rsnew, $this->Type->CurrentValue, NULL, FALSE); // Call Row Inserting event $rs = $rsold == NULL ? NULL : $rsold->fields; $bInsertRow = $this->Row_Inserting($rs, $rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $this->Insert($rsnew); $conn->raiseErrorFn = ''; if ($AddRow) { } } 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->ID->setDbValue($conn->Insert_ID()); $rsnew['ID'] = $this->ID->DbValue; } if ($AddRow) { // Call Row Inserted event $rs = $rsold == NULL ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); } return $AddRow; }
function EditRow() { global $conn, $Security, $PromoCodes; $sFilter = $PromoCodes->KeyFilter(); $PromoCodes->CurrentFilter = $sFilter; $sSql = $PromoCodes->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 PromoCodeID // Field PromoCodeName $PromoCodes->PromoCodeName->SetDbValueDef($PromoCodes->PromoCodeName->CurrentValue, ""); $rsnew['PromoCodeName'] =& $PromoCodes->PromoCodeName->DbValue; // Field PromoCodeType $PromoCodes->PromoCodeType->SetDbValueDef($PromoCodes->PromoCodeType->CurrentValue, ""); $rsnew['PromoCodeType'] =& $PromoCodes->PromoCodeType->DbValue; // Field Amount $PromoCodes->Amount->SetDbValueDef($PromoCodes->Amount->CurrentValue, 0); $rsnew['Amount'] =& $PromoCodes->Amount->DbValue; // Field ValidFrom $PromoCodes->ValidFrom->SetDbValueDef(ew_UnFormatDateTime($PromoCodes->ValidFrom->CurrentValue, 6), ew_CurrentDate()); $rsnew['ValidFrom'] =& $PromoCodes->ValidFrom->DbValue; // Field ValidTo $PromoCodes->ValidTo->SetDbValueDef(ew_UnFormatDateTime($PromoCodes->ValidTo->CurrentValue, 6), NULL); $rsnew['ValidTo'] =& $PromoCodes->ValidTo->DbValue; // Field Message $PromoCodes->Message->SetDbValueDef($PromoCodes->Message->CurrentValue, NULL); $rsnew['Message'] =& $PromoCodes->Message->DbValue; // Field One_Time_Only $PromoCodes->One_Time_Only->SetDbValueDef($PromoCodes->One_Time_Only->CurrentValue, ""); $rsnew['One_Time_Only'] =& $PromoCodes->One_Time_Only->DbValue; // Field New_Customer_Only $PromoCodes->New_Customer_Only->SetDbValueDef($PromoCodes->New_Customer_Only->CurrentValue, ""); $rsnew['New_Customer_Only'] =& $PromoCodes->New_Customer_Only->DbValue; // Field multiple_use $PromoCodes->multiple_use->SetDbValueDef($PromoCodes->multiple_use->CurrentValue, 0); $rsnew['multiple_use'] =& $PromoCodes->multiple_use->DbValue; // Call Row Updating event $bUpdateRow = $PromoCodes->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($PromoCodes->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($PromoCodes->CancelMessage != "") { $this->setMessage($PromoCodes->CancelMessage); $PromoCodes->CancelMessage = ""; } else { $this->setMessage("Update cancelled"); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) { $PromoCodes->Row_Updated($rsold, $rsnew); } $rs->Close(); return $EditRow; }
function EditRow() { global $conn, $Security, $Notifications; $sFilter = $Notifications->KeyFilter(); $Notifications->CurrentFilter = $sFilter; $sSql = $Notifications->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 ZipCode // Field Email // Field Location $Notifications->Location->SetDbValueDef($Notifications->Location->CurrentValue, NULL); $rsnew['Location'] =& $Notifications->Location->DbValue; // Field Timestamp $Notifications->Timestamp->SetDbValueDef(ew_UnFormatDateTime($Notifications->Timestamp->CurrentValue, 6), ew_CurrentDate()); $rsnew['Timestamp'] =& $Notifications->Timestamp->DbValue; // Call Row Updating event $bUpdateRow = $Notifications->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($Notifications->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($Notifications->CancelMessage != "") { $this->setMessage($Notifications->CancelMessage); $Notifications->CancelMessage = ""; } else { $this->setMessage("Update cancelled"); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) { $Notifications->Row_Updated($rsold, $rsnew); } $rs->Close(); return $EditRow; }
function AddRow($rsold = NULL) { global $Language, $Security; $conn =& $this->Connection(); // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); } $rsnew = array(); // m_id $this->m_id->SetDbValueDef($rsnew, $this->m_id->CurrentValue, NULL, FALSE); // package_id $this->package_id->SetDbValueDef($rsnew, $this->package_id->CurrentValue, NULL, FALSE); // customer_name $this->customer_name->SetDbValueDef($rsnew, $this->customer_name->CurrentValue, NULL, FALSE); // customer_cell $this->customer_cell->SetDbValueDef($rsnew, $this->customer_cell->CurrentValue, NULL, FALSE); // date $this->date->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->date->CurrentValue, 7), ew_CurrentDate(), FALSE); // month $this->month->SetDbValueDef($rsnew, $this->month->CurrentValue, "", FALSE); // category $this->category->SetDbValueDef($rsnew, $this->category->CurrentValue, "", FALSE); // amount $this->amount->SetDbValueDef($rsnew, $this->amount->CurrentValue, 0, FALSE); // Details $this->Details->SetDbValueDef($rsnew, $this->Details->CurrentValue, "", FALSE); // 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->delivery_id->setDbValue($conn->Insert_ID()); $rsnew['delivery_id'] = $this->delivery_id->DbValue; } } else { if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") { // Use the message, do nothing } elseif ($this->CancelMessage != "") { $this->setFailureMessage($this->CancelMessage); $this->CancelMessage = ""; } else { $this->setFailureMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } if ($AddRow) { // Call Row Inserted event $rs = $rsold == NULL ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); } return $AddRow; }
function EditRow() { global $conn, $Security, $logs; $sFilter = $logs->SqlKeyFilter(); if (!is_numeric($logs->id->CurrentValue)) { return FALSE; } $sFilter = str_replace("@id@", ew_AdjustSql($logs->id->CurrentValue), $sFilter); // Replace key value $logs->CurrentFilter = $sFilter; $sSql = $logs->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 id // Field time $logs->time->SetDbValueDef(ew_UnFormatDateTime($logs->time->CurrentValue, 5), ew_CurrentDate()); $rsnew['time'] =& $logs->time->DbValue; // Field client $logs->client->SetDbValueDef($logs->client->CurrentValue, NULL); $rsnew['client'] =& $logs->client->DbValue; // Field group $logs->group->SetDbValueDef($logs->group->CurrentValue, NULL); $rsnew['group'] =& $logs->group->DbValue; // Field type $logs->type->SetDbValueDef($logs->type->CurrentValue, NULL); $rsnew['type'] =& $logs->type->DbValue; // Field message $logs->message->SetDbValueDef($logs->message->CurrentValue, NULL); $rsnew['message'] =& $logs->message->DbValue; // Call Row Updating event $bUpdateRow = $logs->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($logs->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($logs->CancelMessage != "") { $_SESSION[EW_SESSION_MESSAGE] = $logs->CancelMessage; $logs->CancelMessage = ""; } else { $_SESSION[EW_SESSION_MESSAGE] = "Update cancelled"; } $EditRow = FALSE; } } // Call Row Updated event if ($EditRow) { $logs->Row_Updated($rsold, $rsnew); } $rs->Close(); return $EditRow; }
function AddRow() { global $conn, $Security, $Notifications; // Check if key value entered if ($Notifications->ZipCode->CurrentValue == "") { $this->setMessage("Invalid key value"); return FALSE; } // Check if key value entered if ($Notifications->zEmail->CurrentValue == "") { $this->setMessage("Invalid key value"); return FALSE; } // Check for duplicate key $bCheckKey = TRUE; $sFilter = $Notifications->KeyFilter(); if ($bCheckKey) { $rsChk = $Notifications->LoadRs($sFilter); if ($rsChk && !$rsChk->EOF) { $sKeyErrMsg = str_replace("%f", $sFilter, "Duplicate primary key: '%f'"); $this->setMessage($sKeyErrMsg); $rsChk->Close(); return FALSE; } } $rsnew = array(); // Field ZipCode $Notifications->ZipCode->SetDbValueDef($Notifications->ZipCode->CurrentValue, 0); $rsnew['ZipCode'] =& $Notifications->ZipCode->DbValue; // Field Email $Notifications->zEmail->SetDbValueDef($Notifications->zEmail->CurrentValue, ""); $rsnew['Email'] =& $Notifications->zEmail->DbValue; // Field Location $Notifications->Location->SetDbValueDef($Notifications->Location->CurrentValue, NULL); $rsnew['Location'] =& $Notifications->Location->DbValue; // Field Timestamp $Notifications->Timestamp->SetDbValueDef(ew_UnFormatDateTime($Notifications->Timestamp->CurrentValue, 6), ew_CurrentDate()); $rsnew['Timestamp'] =& $Notifications->Timestamp->DbValue; // Call Row Inserting event $bInsertRow = $Notifications->Row_Inserting($rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $conn->Execute($Notifications->InsertSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($Notifications->CancelMessage != "") { $this->setMessage($Notifications->CancelMessage); $Notifications->CancelMessage = ""; } else { $this->setMessage("Insert cancelled"); } $AddRow = FALSE; } if ($AddRow) { // Call Row Inserted event $Notifications->Row_Inserted($rsnew); } return $AddRow; }
function EditRow() { global $conn, $Security, $password_reset_requests; $sFilter = $password_reset_requests->KeyFilter(); $password_reset_requests->CurrentFilter = $sFilter; $sSql = $password_reset_requests->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 id // Field CustomerID $password_reset_requests->CustomerID->SetDbValueDef($password_reset_requests->CustomerID->CurrentValue, 0); $rsnew['CustomerID'] =& $password_reset_requests->CustomerID->DbValue; // Field token_id $password_reset_requests->token_id->SetDbValueDef($password_reset_requests->token_id->CurrentValue, ""); $rsnew['token_id'] =& $password_reset_requests->token_id->DbValue; // Field expires $password_reset_requests->expires->SetDbValueDef(ew_UnFormatDateTime($password_reset_requests->expires->CurrentValue, 6), ew_CurrentDate()); $rsnew['expires'] =& $password_reset_requests->expires->DbValue; // Call Row Updating event $bUpdateRow = $password_reset_requests->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($password_reset_requests->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($password_reset_requests->CancelMessage != "") { $this->setMessage($password_reset_requests->CancelMessage); $password_reset_requests->CancelMessage = ""; } else { $this->setMessage("Update cancelled"); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) { $password_reset_requests->Row_Updated($rsold, $rsnew); } $rs->Close(); return $EditRow; }
function EditRow() { global $Security, $Language; $sFilter = $this->KeyFilter(); $sFilter = $this->ApplyUserIDFilters($sFilter); $conn =& $this->Connection(); $this->CurrentFilter = $sFilter; $sSql = $this->SQL(); $conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"]; $rs = $conn->Execute($sSql); $conn->raiseErrorFn = ''; if ($rs === FALSE) { return FALSE; } if ($rs->EOF) { $this->setFailureMessage($Language->Phrase("NoRecord")); // Set no record message $EditRow = FALSE; // Update Failed } else { // Save old values $rsold =& $rs->fields; $this->LoadDbValues($rsold); $rsnew = array(); // PATH if ($this->PATH->Visible && !$this->PATH->ReadOnly && !$this->PATH->Upload->KeepFile) { $this->PATH->Upload->DbValue = $rsold['PATH']; // Get original value if ($this->PATH->Upload->FileName == "") { $rsnew['PATH'] = NULL; } else { $rsnew['PATH'] = $this->PATH->Upload->FileName; } } // PROCESS $this->PROCESS->SetDbValueDef($rsnew, $this->PROCESS->CurrentValue, 0, $this->PROCESS->ReadOnly); // BANK_ACCOUNT_ID $this->BANK_ACCOUNT_ID->SetDbValueDef($rsnew, $this->BANK_ACCOUNT_ID->CurrentValue, 0, $this->BANK_ACCOUNT_ID->ReadOnly); // UPLOAD_FILE_STATUS_ID $this->UPLOAD_FILE_STATUS_ID->SetDbValueDef($rsnew, $this->UPLOAD_FILE_STATUS_ID->CurrentValue, 0, $this->UPLOAD_FILE_STATUS_ID->ReadOnly); // DATETIME $this->DATETIME->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->DATETIME->CurrentValue, 7), ew_CurrentDate(), $this->DATETIME->ReadOnly); if ($this->PATH->Visible && !$this->PATH->Upload->KeepFile) { if (!ew_Empty($this->PATH->Upload->Value)) { $rsnew['PATH'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->PATH->UploadPath), $rsnew['PATH']); // Get new file name } } // Call Row Updating event $bUpdateRow = $this->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"]; if (count($rsnew) > 0) { $EditRow = $this->Update($rsnew, "", $rsold); } else { $EditRow = TRUE; } // No field to update $conn->raiseErrorFn = ''; if ($EditRow) { if ($this->PATH->Visible && !$this->PATH->Upload->KeepFile) { if (!ew_Empty($this->PATH->Upload->Value)) { $this->PATH->Upload->SaveToFile($this->PATH->UploadPath, $rsnew['PATH'], TRUE); } } } } else { if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") { // Use the message, do nothing } elseif ($this->CancelMessage != "") { $this->setFailureMessage($this->CancelMessage); $this->CancelMessage = ""; } else { $this->setFailureMessage($Language->Phrase("UpdateCancelled")); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) { $this->Row_Updated($rsold, $rsnew); } $rs->Close(); // PATH ew_CleanUploadTempPath($this->PATH, $this->PATH->Upload->Index); return $EditRow; }
function EditRow() { global $conn, $Security, $HolidayDate; $sFilter = $HolidayDate->KeyFilter(); $HolidayDate->CurrentFilter = $sFilter; $sSql = $HolidayDate->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 HolidayDateID // Field HolidayOrderBy $HolidayDate->HolidayOrderBy->SetDbValueDef(ew_UnFormatDateTime($HolidayDate->HolidayOrderBy->CurrentValue, 6), ew_CurrentDate()); $rsnew['HolidayOrderBy'] =& $HolidayDate->HolidayOrderBy->DbValue; // Field HolidayDeliverOn $HolidayDate->HolidayDeliverOn->SetDbValueDef(ew_UnFormatDateTime($HolidayDate->HolidayDeliverOn->CurrentValue, 6), ew_CurrentDate()); $rsnew['HolidayDeliverOn'] =& $HolidayDate->HolidayDeliverOn->DbValue; // Field HolidayComment $HolidayDate->HolidayComment->SetDbValueDef($HolidayDate->HolidayComment->CurrentValue, NULL); $rsnew['HolidayComment'] =& $HolidayDate->HolidayComment->DbValue; // Call Row Updating event $bUpdateRow = $HolidayDate->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($HolidayDate->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($HolidayDate->CancelMessage != "") { $this->setMessage($HolidayDate->CancelMessage); $HolidayDate->CancelMessage = ""; } else { $this->setMessage("Update cancelled"); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) { $HolidayDate->Row_Updated($rsold, $rsnew); } $rs->Close(); return $EditRow; }
function AddRow($rsold = NULL) { global $conn, $Language, $Security; // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); } $rsnew = array(); // Titulo $this->Titulo->SetDbValueDef($rsnew, $this->Titulo->CurrentValue, NULL, FALSE); // fecha $this->fecha->SetDbValueDef($rsnew, ew_CurrentDate(), NULL); $rsnew['fecha'] =& $this->fecha->DbValue; // archivo if (!$this->archivo->Upload->KeepFile) { $this->archivo->Upload->DbValue = ""; // No need to delete old file if ($this->archivo->Upload->FileName == "") { $rsnew['archivo'] = NULL; } else { $rsnew['archivo'] = $this->archivo->Upload->FileName; } } // estado $this->estado->SetDbValueDef($rsnew, $this->estado->CurrentValue, NULL, FALSE); if (!$this->archivo->Upload->KeepFile) { $OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->DbValue); if (!ew_Empty($this->archivo->Upload->FileName)) { $NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->FileName); $FileCount = count($NewFiles); for ($i = 0; $i < $FileCount; $i++) { $fldvar = $this->archivo->Upload->Index < 0 ? $this->archivo->FldVar : substr($this->archivo->FldVar, 0, 1) . $this->archivo->Upload->Index . substr($this->archivo->FldVar, 1); if ($NewFiles[$i] != "") { $file = $NewFiles[$i]; if (file_exists(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file)) { if (!in_array($file, $OldFiles)) { $file1 = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->archivo->UploadPath), $file); // Get new file name if ($file1 != $file) { // Rename temp file while (file_exists(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file1)) { // Make sure did not clash with existing upload file $file1 = ew_UniqueFilename(ew_UploadPathEx(TRUE, $this->archivo->UploadPath), $file1, TRUE); } // Use indexed name rename(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file, ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file1); $NewFiles[$i] = $file1; } } } } } $this->archivo->Upload->FileName = implode(EW_MULTIPLE_UPLOAD_SEPARATOR, $NewFiles); $rsnew['archivo'] = $this->archivo->Upload->FileName; } else { $NewFiles = array(); } } // Call Row Inserting event $rs = $rsold == NULL ? NULL : $rsold->fields; $bInsertRow = $this->Row_Inserting($rs, $rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $this->Insert($rsnew); $conn->raiseErrorFn = ''; if ($AddRow) { if (!$this->archivo->Upload->KeepFile) { $OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->DbValue); if (!ew_Empty($this->archivo->Upload->FileName)) { $NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->FileName); $NewFiles2 = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $rsnew['archivo']); $FileCount = count($NewFiles); for ($i = 0; $i < $FileCount; $i++) { $fldvar = $this->archivo->Upload->Index < 0 ? $this->archivo->FldVar : substr($this->archivo->FldVar, 0, 1) . $this->archivo->Upload->Index . substr($this->archivo->FldVar, 1); if ($NewFiles[$i] != "") { $file = ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $NewFiles[$i]; if (file_exists($file)) { $this->archivo->Upload->SaveToFile($this->archivo->UploadPath, @$NewFiles2[$i] != "" ? $NewFiles2[$i] : $NewFiles[$i], TRUE, $i); // Just replace } } } } else { $NewFiles = array(); } $FileCount = count($OldFiles); for ($i = 0; $i < $FileCount; $i++) { if ($OldFiles[$i] != "" && !in_array($OldFiles[$i], $NewFiles)) { @unlink(ew_UploadPathEx(TRUE, $this->archivo->OldUploadPath) . $OldFiles[$i]); } } } } } else { if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") { // Use the message, do nothing } elseif ($this->CancelMessage != "") { $this->setFailureMessage($this->CancelMessage); $this->CancelMessage = ""; } else { $this->setFailureMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } // Get insert id if necessary if ($AddRow) { $this->codigo->setDbValue($conn->Insert_ID()); $rsnew['codigo'] = $this->codigo->DbValue; } if ($AddRow) { // Call Row Inserted event $rs = $rsold == NULL ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); } // archivo ew_CleanUploadTempPath($this->archivo, $this->archivo->Upload->Index); return $AddRow; }
function AddRow($rsold = NULL) { global $conn, $Language, $Security; // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); } $rsnew = array(); // nis $this->nis->SetDbValueDef($rsnew, $this->nis->CurrentValue, "", FALSE); // nama $this->nama->SetDbValueDef($rsnew, $this->nama->CurrentValue, "", FALSE); // tempat_lahir $this->tempat_lahir->SetDbValueDef($rsnew, $this->tempat_lahir->CurrentValue, "", FALSE); // tanggal_lahir $this->tanggal_lahir->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->tanggal_lahir->CurrentValue, 5), ew_CurrentDate(), FALSE); // alamat $this->alamat->SetDbValueDef($rsnew, $this->alamat->CurrentValue, "", FALSE); // agama $this->agama->SetDbValueDef($rsnew, $this->agama->CurrentValue, "", FALSE); // no_hp $this->no_hp->SetDbValueDef($rsnew, $this->no_hp->CurrentValue, "", FALSE); // email $this->_email->SetDbValueDef($rsnew, $this->_email->CurrentValue, "", FALSE); // Call Row Inserting event $rs = $rsold == NULL ? NULL : $rsold->fields; $bInsertRow = $this->Row_Inserting($rs, $rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $this->Insert($rsnew); $conn->raiseErrorFn = ''; if ($AddRow) { } } 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->id_siswa->setDbValue($conn->Insert_ID()); $rsnew['id_siswa'] = $this->id_siswa->DbValue; } if ($AddRow) { // Call Row Inserted event $rs = $rsold == NULL ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); } return $AddRow; }
function EditRow() { global $Security, $Language; $sFilter = $this->KeyFilter(); $sFilter = $this->ApplyUserIDFilters($sFilter); $conn =& $this->Connection(); $this->CurrentFilter = $sFilter; $sSql = $this->SQL(); $conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"]; $rs = $conn->Execute($sSql); $conn->raiseErrorFn = ''; if ($rs === FALSE) { return FALSE; } if ($rs->EOF) { $this->setFailureMessage($Language->Phrase("NoRecord")); // Set no record message $EditRow = FALSE; // Update Failed } else { // Save old values $rsold =& $rs->fields; $this->LoadDbValues($rsold); $rsnew = array(); // m_id $this->m_id->SetDbValueDef($rsnew, $this->m_id->CurrentValue, NULL, $this->m_id->ReadOnly); // package_id $this->package_id->SetDbValueDef($rsnew, $this->package_id->CurrentValue, NULL, $this->package_id->ReadOnly); // customer_name $this->customer_name->SetDbValueDef($rsnew, $this->customer_name->CurrentValue, NULL, $this->customer_name->ReadOnly); // customer_cell $this->customer_cell->SetDbValueDef($rsnew, $this->customer_cell->CurrentValue, NULL, $this->customer_cell->ReadOnly); // date $this->date->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->date->CurrentValue, 7), ew_CurrentDate(), $this->date->ReadOnly); // month $this->month->SetDbValueDef($rsnew, $this->month->CurrentValue, "", $this->month->ReadOnly); // category $this->category->SetDbValueDef($rsnew, $this->category->CurrentValue, "", $this->category->ReadOnly); // amount $this->amount->SetDbValueDef($rsnew, $this->amount->CurrentValue, 0, $this->amount->ReadOnly); // Details $this->Details->SetDbValueDef($rsnew, $this->Details->CurrentValue, "", $this->Details->ReadOnly); // 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) { } } 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(); 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 { // Save old values $rsold =& $rs->fields; $this->LoadDbValues($rsold); $rsnew = array(); // news_date $this->news_date->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->news_date->CurrentValue, 5), ew_CurrentDate(), $this->news_date->ReadOnly); // news_title $this->news_title->SetDbValueDef($rsnew, $this->news_title->CurrentValue, "", $this->news_title->ReadOnly); // news_description $this->news_description->SetDbValueDef($rsnew, $this->news_description->CurrentValue, "", $this->news_description->ReadOnly); // 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) { } } 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(); return $EditRow; }
function EditRow() { global $conn, $Security, $Language; $sFilter = $this->KeyFilter(); $this->CurrentFilter = $sFilter; $sSql = $this->SQL(); $conn->raiseErrorFn = 'ew_ErrorFn'; $rs = $conn->Execute($sSql); $conn->raiseErrorFn = ''; if ($rs === FALSE) { return FALSE; } if ($rs->EOF) { $EditRow = FALSE; // Update Failed } else { // Save old values $rsold =& $rs->fields; $this->LoadDbValues($rsold); $rsnew = array(); // nis $this->nis->SetDbValueDef($rsnew, $this->nis->CurrentValue, "", $this->nis->ReadOnly); // nama $this->nama->SetDbValueDef($rsnew, $this->nama->CurrentValue, "", $this->nama->ReadOnly); // tempat_lahir $this->tempat_lahir->SetDbValueDef($rsnew, $this->tempat_lahir->CurrentValue, "", $this->tempat_lahir->ReadOnly); // tanggal_lahir $this->tanggal_lahir->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->tanggal_lahir->CurrentValue, 5), ew_CurrentDate(), $this->tanggal_lahir->ReadOnly); // alamat $this->alamat->SetDbValueDef($rsnew, $this->alamat->CurrentValue, "", $this->alamat->ReadOnly); // agama $this->agama->SetDbValueDef($rsnew, $this->agama->CurrentValue, "", $this->agama->ReadOnly); // no_hp $this->no_hp->SetDbValueDef($rsnew, $this->no_hp->CurrentValue, "", $this->no_hp->ReadOnly); // email $this->_email->SetDbValueDef($rsnew, $this->_email->CurrentValue, "", $this->_email->ReadOnly); // 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) { } } 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(); return $EditRow; }
function EditRow() { global $conn, $Security, $Contact; $sFilter = $Contact->KeyFilter(); $Contact->CurrentFilter = $sFilter; $sSql = $Contact->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 ContactID // Field Email $Contact->zEmail->SetDbValueDef($Contact->zEmail->CurrentValue, ""); $rsnew['Email'] =& $Contact->zEmail->DbValue; // Field Received $Contact->Received->SetDbValueDef(ew_UnFormatDateTime($Contact->Received->CurrentValue, 6), ew_CurrentDate()); $rsnew['Received'] =& $Contact->Received->DbValue; // Field Message $Contact->Message->SetDbValueDef($Contact->Message->CurrentValue, ""); $rsnew['Message'] =& $Contact->Message->DbValue; // Call Row Updating event $bUpdateRow = $Contact->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($Contact->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($Contact->CancelMessage != "") { $this->setMessage($Contact->CancelMessage); $Contact->CancelMessage = ""; } else { $this->setMessage("Update cancelled"); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) { $Contact->Row_Updated($rsold, $rsnew); } $rs->Close(); return $EditRow; }
function AddRow($rsold = NULL) { global $Language, $Security; $conn =& $this->Connection(); // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); } $rsnew = array(); // CODE $this->CODE->SetDbValueDef($rsnew, $this->CODE->CurrentValue, 0, FALSE); // DESCRIPTION $this->DESCRIPTION->SetDbValueDef($rsnew, $this->DESCRIPTION->CurrentValue, "", FALSE); // DATE $this->DATE->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->DATE->CurrentValue, 7), ew_CurrentDate(), FALSE); // AMOUNT $this->AMOUNT->SetDbValueDef($rsnew, $this->AMOUNT->CurrentValue, 0, FALSE); // UPLOAD_FILE_ID $this->UPLOAD_FILE_ID->SetDbValueDef($rsnew, $this->UPLOAD_FILE_ID->CurrentValue, 0, FALSE); // UPLOAD_FILE_DETAIL_STATUS_ID $this->UPLOAD_FILE_DETAIL_STATUS_ID->SetDbValueDef($rsnew, $this->UPLOAD_FILE_DETAIL_STATUS_ID->CurrentValue, 0, FALSE); // 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_DETAIL_ID->setDbValue($conn->Insert_ID()); $rsnew['UPLOAD_FILE_DETAIL_ID'] = $this->UPLOAD_FILE_DETAIL_ID->DbValue; } } else { if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") { // Use the message, do nothing } elseif ($this->CancelMessage != "") { $this->setFailureMessage($this->CancelMessage); $this->CancelMessage = ""; } else { $this->setFailureMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } if ($AddRow) { // Call Row Inserted event $rs = $rsold == NULL ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); } return $AddRow; }
function AddRow($rsold = NULL) { global $Language, $Security; $conn =& $this->Connection(); // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); } $rsnew = array(); // news_date $this->news_date->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->news_date->CurrentValue, 5), ew_CurrentDate(), FALSE); // news_title $this->news_title->SetDbValueDef($rsnew, $this->news_title->CurrentValue, "", FALSE); // news_description $this->news_description->SetDbValueDef($rsnew, $this->news_description->CurrentValue, "", FALSE); // 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->news_id->setDbValue($conn->Insert_ID()); $rsnew['news_id'] = $this->news_id->DbValue; } } else { if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") { // Use the message, do nothing } elseif ($this->CancelMessage != "") { $this->setFailureMessage($this->CancelMessage); $this->CancelMessage = ""; } else { $this->setFailureMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } if ($AddRow) { // Call Row Inserted event $rs = $rsold == NULL ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); } return $AddRow; }
function AddRow() { global $conn, $Language, $Security, $bookpost; $rsnew = array(); // name $bookpost->name->SetDbValueDef($rsnew, $bookpost->name->CurrentValue, "", FALSE); // cata $bookpost->cata->SetDbValueDef($rsnew, $bookpost->cata->CurrentValue, "", FALSE); // author $bookpost->author->SetDbValueDef($rsnew, $bookpost->author->CurrentValue, NULL, FALSE); // publisher $bookpost->publisher->SetDbValueDef($rsnew, $bookpost->publisher->CurrentValue, NULL, FALSE); // info $bookpost->info->SetDbValueDef($rsnew, $bookpost->info->CurrentValue, "", FALSE); // code $bookpost->code->SetDbValueDef($rsnew, $bookpost->code->CurrentValue, NULL, FALSE); // pic $bookpost->pic->SetDbValueDef($rsnew, $bookpost->pic->CurrentValue, NULL, FALSE); // useremail $bookpost->useremail->SetDbValueDef($rsnew, $bookpost->useremail->CurrentValue, "", FALSE); // price $bookpost->price->SetDbValueDef($rsnew, $bookpost->price->CurrentValue, 0, FALSE); // datatime $bookpost->datatime->SetDbValueDef($rsnew, ew_CurrentDateTime(), ew_CurrentDate()); $rsnew['datatime'] =& $bookpost->datatime->DbValue; // hidden $bookpost->hidden->SetDbValueDef($rsnew, $bookpost->hidden->CurrentValue, NULL, FALSE); // Call Row Inserting event $bInsertRow = $bookpost->Row_Inserting($rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $conn->Execute($bookpost->InsertSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($bookpost->CancelMessage != "") { $this->setMessage($bookpost->CancelMessage); $bookpost->CancelMessage = ""; } else { $this->setMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } if ($AddRow) { $bookpost->bookid->setDbValue($conn->Insert_ID()); $rsnew['bookid'] = $bookpost->bookid->DbValue; // Call Row Inserted event $bookpost->Row_Inserted($rsnew); } return $AddRow; }
function AddRow($rsold = NULL) { global $conn, $Language, $Security; // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); $this->cat_file->OldUploadPath = "/catalogues/"; $this->cat_file->UploadPath = $this->cat_file->OldUploadPath; } $rsnew = array(); // cat_name $this->cat_name->SetDbValueDef($rsnew, $this->cat_name->CurrentValue, "", FALSE); // cat_file if (!$this->cat_file->Upload->KeepFile) { if ($this->cat_file->Upload->FileName == "") { $rsnew['cat_file'] = NULL; } else { $rsnew['cat_file'] = $this->cat_file->Upload->FileName; } $this->cat_file->ImageWidth = EW_THUMBNAIL_DEFAULT_WIDTH; // Resize width $this->cat_file->ImageHeight = EW_THUMBNAIL_DEFAULT_HEIGHT; // Resize height } // cat_date $this->cat_date->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->cat_date->CurrentValue, 5), ew_CurrentDate(), FALSE); if (!$this->cat_file->Upload->KeepFile) { $this->cat_file->UploadPath = "/catalogues/"; if (!ew_Empty($this->cat_file->Upload->Value)) { $rsnew['cat_file'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->cat_file->UploadPath), $rsnew['cat_file']); // Get new file name } } // Call Row Inserting event $rs = $rsold == NULL ? NULL : $rsold->fields; $bInsertRow = $this->Row_Inserting($rs, $rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $this->Insert($rsnew); $conn->raiseErrorFn = ''; if ($AddRow) { if (!$this->cat_file->Upload->KeepFile) { if (!ew_Empty($this->cat_file->Upload->Value)) { $this->cat_file->Upload->Resize($this->cat_file->ImageWidth, $this->cat_file->ImageHeight, EW_THUMBNAIL_DEFAULT_QUALITY); $this->cat_file->Upload->SaveToFile($this->cat_file->UploadPath, $rsnew['cat_file'], TRUE); } } } } else { if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") { // Use the message, do nothing } elseif ($this->CancelMessage != "") { $this->setFailureMessage($this->CancelMessage); $this->CancelMessage = ""; } else { $this->setFailureMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } // Get insert id if necessary if ($AddRow) { $this->cat_id->setDbValue($conn->Insert_ID()); $rsnew['cat_id'] = $this->cat_id->DbValue; } if ($AddRow) { // Call Row Inserted event $rs = $rsold == NULL ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); } // cat_file ew_CleanUploadTempPath($this->cat_file, $this->cat_file->Upload->Index); return $AddRow; }
function AddRow() { global $conn, $Security, $archives; // Check for duplicate key $bCheckKey = TRUE; $sFilter = $archives->SqlKeyFilter(); if (trim(strval($archives->id->CurrentValue)) == "") { $bCheckKey = FALSE; } else { $sFilter = str_replace("@id@", ew_AdjustSql($archives->id->CurrentValue), $sFilter); // Replace key value } if (!is_numeric($archives->id->CurrentValue)) { $bCheckKey = FALSE; } if ($bCheckKey) { $rsChk = $archives->LoadRs($sFilter); if ($rsChk && !$rsChk->EOF) { $_SESSION[EW_SESSION_MESSAGE] = "Duplicate value for primary key"; $rsChk->Close(); return FALSE; } } $rsnew = array(); // Field url $archives->url->SetDbValueDef($archives->url->CurrentValue, ""); $rsnew['url'] =& $archives->url->DbValue; // Field projectname $archives->projectname->SetDbValueDef($archives->projectname->CurrentValue, NULL); $rsnew['projectname'] =& $archives->projectname->DbValue; // Field title $archives->title->SetDbValueDef($archives->title->CurrentValue, ""); $rsnew['title'] =& $archives->title->DbValue; // Field datetime $archives->datetime->SetDbValueDef(ew_UnFormatDateTime($archives->datetime->CurrentValue, 5), ew_CurrentDate()); $rsnew['datetime'] =& $archives->datetime->DbValue; // Field content $archives->content->SetDbValueDef($archives->content->CurrentValue, NULL); $rsnew['content'] =& $archives->content->DbValue; // Call Row Inserting event $bInsertRow = $archives->Row_Inserting($rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $conn->Execute($archives->InsertSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($archives->CancelMessage != "") { $_SESSION[EW_SESSION_MESSAGE] = $archives->CancelMessage; $archives->CancelMessage = ""; } else { $_SESSION[EW_SESSION_MESSAGE] = "Insert cancelled"; } $AddRow = FALSE; } if ($AddRow) { $archives->id->setDbValue($conn->Insert_ID()); $rsnew['id'] =& $archives->id->DbValue; // Call Row Inserted event $archives->Row_Inserted($rsnew); } 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(); // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); } $rsnew = array(); // PATH if ($this->PATH->Visible && !$this->PATH->Upload->KeepFile) { $this->PATH->Upload->DbValue = ""; // No need to delete old file if ($this->PATH->Upload->FileName == "") { $rsnew['PATH'] = NULL; } else { $rsnew['PATH'] = $this->PATH->Upload->FileName; } } // PROCESS $this->PROCESS->SetDbValueDef($rsnew, $this->PROCESS->CurrentValue, 0, FALSE); // BANK_ACCOUNT_ID $this->BANK_ACCOUNT_ID->SetDbValueDef($rsnew, $this->BANK_ACCOUNT_ID->CurrentValue, 0, FALSE); // UPLOAD_FILE_STATUS_ID $this->UPLOAD_FILE_STATUS_ID->SetDbValueDef($rsnew, $this->UPLOAD_FILE_STATUS_ID->CurrentValue, 0, FALSE); // DATETIME $this->DATETIME->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->DATETIME->CurrentValue, 7), ew_CurrentDate(), FALSE); if ($this->PATH->Visible && !$this->PATH->Upload->KeepFile) { if (!ew_Empty($this->PATH->Upload->Value)) { $rsnew['PATH'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->PATH->UploadPath), $rsnew['PATH']); // Get new file name } } // Call Row Inserting event $rs = $rsold == NULL ? NULL : $rsold->fields; $bInsertRow = $this->Row_Inserting($rs, $rsnew); if ($bInsertRow) { $conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"]; $AddRow = $this->Insert($rsnew); $conn->raiseErrorFn = ''; if ($AddRow) { // Get insert id if necessary $this->UPLOAD_FILE_ID->setDbValue($conn->Insert_ID()); $rsnew['UPLOAD_FILE_ID'] = $this->UPLOAD_FILE_ID->DbValue; if ($this->PATH->Visible && !$this->PATH->Upload->KeepFile) { if (!ew_Empty($this->PATH->Upload->Value)) { $this->PATH->Upload->SaveToFile($this->PATH->UploadPath, $rsnew['PATH'], TRUE); } } } } else { if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") { // Use the message, do nothing } elseif ($this->CancelMessage != "") { $this->setFailureMessage($this->CancelMessage); $this->CancelMessage = ""; } else { $this->setFailureMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } if ($AddRow) { // Call Row Inserted event $rs = $rsold == NULL ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); } // PATH ew_CleanUploadTempPath($this->PATH, $this->PATH->Upload->Index); return $AddRow; }
function AddRow() { global $conn, $Security, $Subscriptions; // Check if key value entered if ($Subscriptions->DeliveryDate->CurrentValue == "") { $this->setMessage("Invalid key value"); return FALSE; } // Check if key value entered if ($Subscriptions->CustomerID->CurrentValue == "") { $this->setMessage("Invalid key value"); return FALSE; } // Check for duplicate key $bCheckKey = TRUE; $sFilter = $Subscriptions->KeyFilter(); if ($bCheckKey) { $rsChk = $Subscriptions->LoadRs($sFilter); if ($rsChk && !$rsChk->EOF) { $sKeyErrMsg = str_replace("%f", $sFilter, "Duplicate primary key: '%f'"); $this->setMessage($sKeyErrMsg); $rsChk->Close(); return FALSE; } } $rsnew = array(); // Field DeliveryDate $Subscriptions->DeliveryDate->SetDbValueDef(ew_UnFormatDateTime($Subscriptions->DeliveryDate->CurrentValue, 6), ew_CurrentDate()); $rsnew['DeliveryDate'] =& $Subscriptions->DeliveryDate->DbValue; // Field CustomerID $Subscriptions->CustomerID->SetDbValueDef($Subscriptions->CustomerID->CurrentValue, 0); $rsnew['CustomerID'] =& $Subscriptions->CustomerID->DbValue; // Field TransactionNumber $Subscriptions->TransactionNumber->SetDbValueDef($Subscriptions->TransactionNumber->CurrentValue, NULL); $rsnew['TransactionNumber'] =& $Subscriptions->TransactionNumber->DbValue; // Field PromoCodeID $Subscriptions->PromoCodeID->SetDbValueDef($Subscriptions->PromoCodeID->CurrentValue, NULL); $rsnew['PromoCodeID'] =& $Subscriptions->PromoCodeID->DbValue; // Field WeeklyMeals $Subscriptions->WeeklyMeals->SetDbValueDef($Subscriptions->WeeklyMeals->CurrentValue, 0); $rsnew['WeeklyMeals'] =& $Subscriptions->WeeklyMeals->DbValue; // Field WeeklyReg $Subscriptions->WeeklyReg->SetDbValueDef($Subscriptions->WeeklyReg->CurrentValue, 0); $rsnew['WeeklyReg'] =& $Subscriptions->WeeklyReg->DbValue; // Field WeeklyVeg $Subscriptions->WeeklyVeg->SetDbValueDef($Subscriptions->WeeklyVeg->CurrentValue, 0); $rsnew['WeeklyVeg'] =& $Subscriptions->WeeklyVeg->DbValue; // Call Row Inserting event $bInsertRow = $Subscriptions->Row_Inserting($rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $conn->Execute($Subscriptions->InsertSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($Subscriptions->CancelMessage != "") { $this->setMessage($Subscriptions->CancelMessage); $Subscriptions->CancelMessage = ""; } else { $this->setMessage("Insert cancelled"); } $AddRow = FALSE; } if ($AddRow) { $Subscriptions->SubscriptionID->setDbValue($conn->Insert_ID()); $rsnew['SubscriptionID'] =& $Subscriptions->SubscriptionID->DbValue; // Call Row Inserted event $Subscriptions->Row_Inserted($rsnew); } return $AddRow; }
function AddRow() { global $conn, $Language, $Security, $tbl_facebook_stat; // Check if key value entered if ($tbl_facebook_stat->id_profile->CurrentValue == "") { $this->setMessage($Language->Phrase("InvalidKeyValue")); return FALSE; } // Check if key value entered if ($tbl_facebook_stat->stat_date->CurrentValue == "") { $this->setMessage($Language->Phrase("InvalidKeyValue")); return FALSE; } // Check for duplicate key $bCheckKey = TRUE; $sFilter = $tbl_facebook_stat->KeyFilter(); if ($bCheckKey) { $rsChk = $tbl_facebook_stat->LoadRs($sFilter); if ($rsChk && !$rsChk->EOF) { $sKeyErrMsg = str_replace("%f", $sFilter, $Language->Phrase("DupKey")); $this->setMessage($sKeyErrMsg); $rsChk->Close(); return FALSE; } } $rsnew = array(); // id_profile $tbl_facebook_stat->id_profile->SetDbValueDef($rsnew, $tbl_facebook_stat->id_profile->CurrentValue, 0, FALSE); // stat_date $tbl_facebook_stat->stat_date->SetDbValueDef($rsnew, ew_UnFormatDateTime($tbl_facebook_stat->stat_date->CurrentValue, 5, FALSE), ew_CurrentDate()); // year $tbl_facebook_stat->year->SetDbValueDef($rsnew, $tbl_facebook_stat->year->CurrentValue, 0, FALSE); // month $tbl_facebook_stat->month->SetDbValueDef($rsnew, $tbl_facebook_stat->month->CurrentValue, 0, FALSE); // week $tbl_facebook_stat->week->SetDbValueDef($rsnew, $tbl_facebook_stat->week->CurrentValue, 0, FALSE); // interactions $tbl_facebook_stat->interactions->SetDbValueDef($rsnew, $tbl_facebook_stat->interactions->CurrentValue, 0, TRUE); // comments $tbl_facebook_stat->comments->SetDbValueDef($rsnew, $tbl_facebook_stat->comments->CurrentValue, 0, TRUE); // wallposts $tbl_facebook_stat->wallposts->SetDbValueDef($rsnew, $tbl_facebook_stat->wallposts->CurrentValue, 0, TRUE); // fans $tbl_facebook_stat->fans->SetDbValueDef($rsnew, $tbl_facebook_stat->fans->CurrentValue, 0, TRUE); // likes $tbl_facebook_stat->likes->SetDbValueDef($rsnew, $tbl_facebook_stat->likes->CurrentValue, 0, TRUE); // unsubscribe $tbl_facebook_stat->unsubscribe->SetDbValueDef($rsnew, $tbl_facebook_stat->unsubscribe->CurrentValue, 0, FALSE); // Call Row Inserting event $bInsertRow = $tbl_facebook_stat->Row_Inserting($rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $conn->Execute($tbl_facebook_stat->InsertSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($tbl_facebook_stat->CancelMessage != "") { $this->setMessage($tbl_facebook_stat->CancelMessage); $tbl_facebook_stat->CancelMessage = ""; } else { $this->setMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } if ($AddRow) { // Call Row Inserted event $tbl_facebook_stat->Row_Inserted($rsnew); } return $AddRow; }
function AddRow($rsold = NULL) { global $Language, $Security; $conn =& $this->Connection(); // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); } $rsnew = array(); // PASSANGER_ID $this->PASSANGER_ID->SetDbValueDef($rsnew, $this->PASSANGER_ID->CurrentValue, 0, FALSE); // FLIGHT_ID $this->FLIGHT_ID->SetDbValueDef($rsnew, $this->FLIGHT_ID->CurrentValue, 0, FALSE); // GATE $this->GATE->SetDbValueDef($rsnew, $this->GATE->CurrentValue, 0, FALSE); // SEAT $this->SEAT->SetDbValueDef($rsnew, $this->SEAT->CurrentValue, "", FALSE); // DATETIME $this->DATETIME->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->DATETIME->CurrentValue, 7), ew_CurrentDate(), FALSE); // RESERVATION_ID $this->RESERVATION_ID->SetDbValueDef($rsnew, $this->RESERVATION_ID->CurrentValue, 0, FALSE); // 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->BOARDING_ID->setDbValue($conn->Insert_ID()); $rsnew['BOARDING_ID'] = $this->BOARDING_ID->DbValue; } } else { if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") { // Use the message, do nothing } elseif ($this->CancelMessage != "") { $this->setFailureMessage($this->CancelMessage); $this->CancelMessage = ""; } else { $this->setFailureMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } if ($AddRow) { // Call Row Inserted event $rs = $rsold == NULL ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); } return $AddRow; }
function AddRow() { global $conn, $Security, $Orders; $rsnew = array(); // Field CustomerID $Orders->CustomerID->SetDbValueDef($Orders->CustomerID->CurrentValue, 0); $rsnew['CustomerID'] =& $Orders->CustomerID->DbValue; // Field TransactionNumber $Orders->TransactionNumber->SetDbValueDef($Orders->TransactionNumber->CurrentValue, NULL); $rsnew['TransactionNumber'] =& $Orders->TransactionNumber->DbValue; // Field DateOrdered $Orders->DateOrdered->SetDbValueDef(ew_UnFormatDateTime($Orders->DateOrdered->CurrentValue, 6), ew_CurrentDate()); $rsnew['DateOrdered'] =& $Orders->DateOrdered->DbValue; // Field Total $Orders->Total->SetDbValueDef($Orders->Total->CurrentValue, 0); $rsnew['Total'] =& $Orders->Total->DbValue; // Field DeliveryDate $Orders->DeliveryDate->SetDbValueDef(ew_UnFormatDateTime($Orders->DeliveryDate->CurrentValue, 6), ew_CurrentDate()); $rsnew['DeliveryDate'] =& $Orders->DeliveryDate->DbValue; // Field PromoCodeID $Orders->PromoCodeID->SetDbValueDef($Orders->PromoCodeID->CurrentValue, NULL); $rsnew['PromoCodeID'] =& $Orders->PromoCodeID->DbValue; // Field Timestamp $Orders->Timestamp->SetDbValueDef(ew_UnFormatDateTime($Orders->Timestamp->CurrentValue, 6), ew_CurrentDate()); $rsnew['Timestamp'] =& $Orders->Timestamp->DbValue; // Field Sequence $Orders->Sequence->SetDbValueDef($Orders->Sequence->CurrentValue, NULL); $rsnew['Sequence'] =& $Orders->Sequence->DbValue; // Call Row Inserting event $bInsertRow = $Orders->Row_Inserting($rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $conn->Execute($Orders->InsertSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($Orders->CancelMessage != "") { $this->setMessage($Orders->CancelMessage); $Orders->CancelMessage = ""; } else { $this->setMessage("Insert cancelled"); } $AddRow = FALSE; } if ($AddRow) { $Orders->OrderID->setDbValue($conn->Insert_ID()); $rsnew['OrderID'] =& $Orders->OrderID->DbValue; // Call Row Inserted event $Orders->Row_Inserted($rsnew); } return $AddRow; }
function AddRow() { global $conn, $Language, $Security, $order; $rsnew = array(); // bookid $order->bookid->SetDbValueDef($rsnew, $order->bookid->CurrentValue, 0, FALSE); // orderstatus $order->orderstatus->SetDbValueDef($rsnew, $order->orderstatus->CurrentValue, 0, FALSE); // email $order->zemail->SetDbValueDef($rsnew, $order->zemail->CurrentValue, "", FALSE); // datatime $order->datatime->SetDbValueDef($rsnew, ew_CurrentDateTime(), ew_CurrentDate()); $rsnew['datatime'] =& $order->datatime->DbValue; // Call Row Inserting event $bInsertRow = $order->Row_Inserting($rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $conn->Execute($order->InsertSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($order->CancelMessage != "") { $this->setMessage($order->CancelMessage); $order->CancelMessage = ""; } else { $this->setMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } if ($AddRow) { $order->orderid->setDbValue($conn->Insert_ID()); $rsnew['orderid'] = $order->orderid->DbValue; // Call Row Inserted event $order->Row_Inserted($rsnew); } return $AddRow; }
function AddRow($rsold = NULL) { global $conn, $Language, $Security; // Check referential integrity for master table 'tramites' $bValidMasterRecord = TRUE; $sMasterFilter = $this->SqlMasterFilter_tramites(); if (strval($this->id_tramite->CurrentValue) != "") { $sMasterFilter = str_replace("@codigo@", ew_AdjustSql($this->id_tramite->CurrentValue), $sMasterFilter); } else { $bValidMasterRecord = FALSE; } if ($bValidMasterRecord) { $rsmaster = $GLOBALS["tramites"]->LoadRs($sMasterFilter); $bValidMasterRecord = $rsmaster && !$rsmaster->EOF; $rsmaster->Close(); } if (!$bValidMasterRecord) { $sRelatedRecordMsg = str_replace("%t", "tramites", $Language->Phrase("RelatedRecordRequired")); $this->setFailureMessage($sRelatedRecordMsg); return FALSE; } // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); } $rsnew = array(); // id_tramite $this->id_tramite->SetDbValueDef($rsnew, $this->id_tramite->CurrentValue, 0, FALSE); // fecha $this->fecha->SetDbValueDef($rsnew, ew_CurrentDate(), ew_CurrentDate()); $rsnew['fecha'] =& $this->fecha->DbValue; // hora $this->hora->SetDbValueDef($rsnew, ew_CurrentTime(), ew_CurrentTime()); $rsnew['hora'] =& $this->hora->DbValue; // titulo $this->titulo->SetDbValueDef($rsnew, $this->titulo->CurrentValue, NULL, FALSE); // archivo if (!$this->archivo->Upload->KeepFile) { $this->archivo->Upload->DbValue = ""; // No need to delete old file if ($this->archivo->Upload->FileName == "") { $rsnew['archivo'] = NULL; } else { $rsnew['archivo'] = $this->archivo->Upload->FileName; } } if (!$this->archivo->Upload->KeepFile) { $OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->DbValue); if (!ew_Empty($this->archivo->Upload->FileName)) { $NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->FileName); $FileCount = count($NewFiles); for ($i = 0; $i < $FileCount; $i++) { $fldvar = $this->archivo->Upload->Index < 0 ? $this->archivo->FldVar : substr($this->archivo->FldVar, 0, 1) . $this->archivo->Upload->Index . substr($this->archivo->FldVar, 1); if ($NewFiles[$i] != "") { $file = $NewFiles[$i]; if (file_exists(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file)) { if (!in_array($file, $OldFiles)) { $file1 = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->archivo->UploadPath), $file); // Get new file name if ($file1 != $file) { // Rename temp file while (file_exists(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file1)) { // Make sure did not clash with existing upload file $file1 = ew_UniqueFilename(ew_UploadPathEx(TRUE, $this->archivo->UploadPath), $file1, TRUE); } // Use indexed name rename(ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file, ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $file1); $NewFiles[$i] = $file1; } } } } } $this->archivo->Upload->FileName = implode(EW_MULTIPLE_UPLOAD_SEPARATOR, $NewFiles); $rsnew['archivo'] = $this->archivo->Upload->FileName; } else { $NewFiles = array(); } } // Call Row Inserting event $rs = $rsold == NULL ? NULL : $rsold->fields; $bInsertRow = $this->Row_Inserting($rs, $rsnew); // Check if key value entered if ($bInsertRow && $this->ValidateKey && strval($rsnew['id_tramite']) == "") { $this->setFailureMessage($Language->Phrase("InvalidKeyValue")); $bInsertRow = FALSE; } // Check if key value entered if ($bInsertRow && $this->ValidateKey && strval($rsnew['fecha']) == "") { $this->setFailureMessage($Language->Phrase("InvalidKeyValue")); $bInsertRow = FALSE; } // Check if key value entered if ($bInsertRow && $this->ValidateKey && strval($rsnew['hora']) == "") { $this->setFailureMessage($Language->Phrase("InvalidKeyValue")); $bInsertRow = FALSE; } // Check for duplicate key if ($bInsertRow && $this->ValidateKey) { $sFilter = $this->KeyFilter(); $rsChk = $this->LoadRs($sFilter); if ($rsChk && !$rsChk->EOF) { $sKeyErrMsg = str_replace("%f", $sFilter, $Language->Phrase("DupKey")); $this->setFailureMessage($sKeyErrMsg); $rsChk->Close(); $bInsertRow = FALSE; } } if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $this->Insert($rsnew); $conn->raiseErrorFn = ''; if ($AddRow) { if (!$this->archivo->Upload->KeepFile) { $OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->DbValue); if (!ew_Empty($this->archivo->Upload->FileName)) { $NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->archivo->Upload->FileName); $NewFiles2 = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $rsnew['archivo']); $FileCount = count($NewFiles); for ($i = 0; $i < $FileCount; $i++) { $fldvar = $this->archivo->Upload->Index < 0 ? $this->archivo->FldVar : substr($this->archivo->FldVar, 0, 1) . $this->archivo->Upload->Index . substr($this->archivo->FldVar, 1); if ($NewFiles[$i] != "") { $file = ew_UploadTempPath($fldvar) . EW_PATH_DELIMITER . $NewFiles[$i]; if (file_exists($file)) { $this->archivo->Upload->SaveToFile($this->archivo->UploadPath, @$NewFiles2[$i] != "" ? $NewFiles2[$i] : $NewFiles[$i], TRUE, $i); // Just replace } } } } else { $NewFiles = array(); } $FileCount = count($OldFiles); for ($i = 0; $i < $FileCount; $i++) { if ($OldFiles[$i] != "" && !in_array($OldFiles[$i], $NewFiles)) { @unlink(ew_UploadPathEx(TRUE, $this->archivo->OldUploadPath) . $OldFiles[$i]); } } } } } else { if ($this->getSuccessMessage() != "" || $this->getFailureMessage() != "") { // Use the message, do nothing } elseif ($this->CancelMessage != "") { $this->setFailureMessage($this->CancelMessage); $this->CancelMessage = ""; } else { $this->setFailureMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } // Get insert id if necessary if ($AddRow) { } if ($AddRow) { // Call Row Inserted event $rs = $rsold == NULL ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); } // archivo ew_CleanUploadTempPath($this->archivo, $this->archivo->Upload->Index); return $AddRow; }
function EditRow() { global $conn, $Security, $Language, $order; $sFilter = $order->KeyFilter(); $order->CurrentFilter = $sFilter; $sSql = $order->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(); // bookid $order->bookid->SetDbValueDef($rsnew, $order->bookid->CurrentValue, 0, FALSE); // orderstatus $order->orderstatus->SetDbValueDef($rsnew, $order->orderstatus->CurrentValue, 0, FALSE); // email $order->zemail->SetDbValueDef($rsnew, $order->zemail->CurrentValue, "", FALSE); // datatime $order->datatime->SetDbValueDef($rsnew, ew_CurrentDateTime(), ew_CurrentDate()); $rsnew['datatime'] =& $order->datatime->DbValue; // Call Row Updating event $bUpdateRow = $order->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($order->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($order->CancelMessage != "") { $this->setMessage($order->CancelMessage); $order->CancelMessage = ""; } else { $this->setMessage($Language->Phrase("UpdateCancelled")); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) { $order->Row_Updated($rsold, $rsnew); } $rs->Close(); return $EditRow; }