if (!$this->oBD->Execute($consulta_sql)) {
return array('error' => 'Error insert File in Data Base');
}
}
//Comprobamos el último id
$consulta_sql = "SELECT MAX(v.id_version) as version FROM " . $this->sTablaArchivoVersion . " as v WHERE v.id_archivo='" . $id_archivo_version . "';";
$rs = $this->oBD->Execute($consulta_sql);
$aResultado = $rs->GetRows();
$rs->Close();
$version = 1;
if ($aResultado[0]['version'] != "" || $aResultado[0]['version'] != NULL) {
$version = $aResultado[0]['version'] + 1;
}
$consulta_sql = "INSERT INTO " . $this->sTablaArchivoVersion . " (id_version,id_archivo, fecha, nombre, size) ";
$consulta_sql .= " VALUES({$version},{$id_archivo_version},'{$fecha}','{$filename}','{$size}')";
if (!$this->oBD->Execute($consulta_sql)) {
return array('error' => 'Error insert File in Data Base');
} else {
//Convert PDF to SWF
PdfToSwfConverter::convertPdfToSwf($uploadDirectory . $filename_new . '.' . $ext, $uploadDirectory . $filename_new . '.swf');
return array('success' => true);
}
}
} else {
return array('error' => 'Could not save uploaded file.' . 'The upload was cancelled, or server error encountered');
}
}
}
$oFile = new File();
$oFile->setBD($oBD);
