function getSQLValue()
{
$fileId = $this->property_info['id'] . '_' . $this->object_sid;
$this->property_info['value'] = $fileId;
SJB_DB::queryExec("UPDATE uploaded_files SET id = ?s WHERE id = ?s LIMIT 1", $fileId, $this->property_info['id'] . '_tmp');
if (SJB_UploadFileManager::doesFileExistByID($fileId)) {
return $fileId;
}
return '';
}
function getSQLValue()
{
if (is_array($this->property_info['value']) && !empty($this->property_info['value']['import'])) {
return $this->property_info['value']['import'];
} else {
$fileId = $this->property_info['id'] . "_" . $this->object_sid;
$this->property_info['value'] = $fileId;
$uploadManager = new SJB_UploadFileManager();
$uploadManager->setFileGroup('files');
$uploadManager->setUploadedFileID($fileId);
$uploadManager->uploadFile($this->property_info['id']);
if (SJB_UploadFileManager::doesFileExistByID($fileId)) {
return $fileId;
}
return '';
}
}
function getSQLValue($file_id = null)
{
// fix to allow checks unique file id (fix for ajax_file_upload_handler.php and complexfile)
if ($file_id === null) {
$file_id = $this->getComplexParent() . ":" . $this->property_info['id'] . ":" . $this->complexEnum . "_" . $this->object_sid;
}
if (isset($this->files)) {
foreach ($this->files as $key => $value) {
$_FILES[$this->property_info['id']][$key] = $value[$this->property_info['id']][$this->complexEnum];
}
}
$this->property_info['value'] = $file_id;
$this->values[$this->complexEnum] = $file_id;
$upload_manager = new SJB_UploadFileManager();
$upload_manager->setFileGroup("files");
$upload_manager->setUploadedFileID($file_id);
$upload_manager->uploadFile($this->property_info['id']);
if (SJB_UploadFileManager::doesFileExistByID($file_id)) {
return $file_id;
}
return '';
}
public function copyFile($uploadedFileInfo, $fileID)
{
if (!SJB_UploadFileManager::doesFileExistByID($fileID)) {
list($fileName, $savedFileName) = SJB_UploadFileManager::getArrayOfFileNames($uploadedFileInfo['file_name']);
$uploadFileDirectory = SJB_System::getSystemSettings('UPLOAD_FILES_DIRECTORY');
if (copy($uploadFileDirectory . '/' . $uploadedFileInfo['file_group'] . '/' . $uploadedFileInfo['saved_file_name'], $fileName)) {
if ($uploadedFileInfo['file_group'] == 'video') {
$baseName = substr($savedFileName, 0, strrpos($savedFileName, '.'));
$img = $uploadFileDirectory . '/' . $uploadedFileInfo['file_group'] . '/' . $baseName . '.png';
$uploadManager = new SJB_UploadVideoFileType($uploadedFileInfo);
$uploadManager->grab_image($fileName, $img, '00:00:03', 'png', 320, 240);
}
if (!empty($uploadedFileInfo['sid'])) {
unset($uploadedFileInfo['sid']);
}
$uploadedFileInfo['id'] = $fileID;
$uploadedFileInfo['saved_file_name'] = $savedFileName;
$uploadedFileFields = array_filter(array_keys($uploadedFileInfo), 'is_string');
$keys = "`" . implode("`,`", $uploadedFileFields) . "`";
$info = "'" . implode("','", array_values(array_intersect_key($uploadedFileInfo, array_flip($uploadedFileFields)))) . "'";
SJB_DB::query("INSERT INTO `uploaded_files` (" . $keys . ") VALUES (" . $info . ")");
}
}
}
