include_once getcwd() . "/classes/BLCarPicture.php";
include_once getcwd() . "/classes/BLCarFile.php";
include_once getcwd() . "/classes/BLBlobs.php";
$blCarPicture = new BLCarPicture();
$blCarFile = new BLCarFile();
$blBlobs = new BLBlobs();
$files = $blCarFile->getCarFiles();
$pictures = $blCarPicture->getCarPictures();
echo '<h1>Files</h1>';
foreach ($files as $file) {
if ($file->getBlobId() == null) {
//Import file
try {
echo "Start: " . $file->getName() . "<br />";
$path = getcwd() . "/files/" . $file->getName() . "." . $file->getType();
$blobId = $blBlobs->uploadBlobs($path);
$file->setBlobId($blobId);
$blCarFile->updateCarFile($file);
echo "End: " . $file->getName() . " uploaded!<br /><hr />";
} catch (Exception $ex) {
echo $ex;
}
}
}
echo '<h1>Pictures</h1>';
foreach ($pictures as $picture) {
if ($picture->getBlobId() == null) {
//Import picture
try {
echo "Start: " . $picture->getName() . "<br />";
$path = getcwd() . "/pictures/" . $picture->getName() . "." . $picture->getType();
if (isset($_POST['filenr'])) {
$nr = $_POST["filenr"];
$i = 0;
for ($i = 1; $i < $nr; $i++) {
//file uploaden + naar tabel wegschrijven
if (trim($_POST["filetext" . $i]) != "") {
if (!empty($_FILES['file' . $i])) {
$file = $_POST["carid"] . "_" . strtolower(str_replace(" ", "_", $_FILES['file' . $i]['name']));
$target_path = getcwd() . "/files/";
//upload
$target_path = $target_path . $file;
chmod($target_path, 0777);
if (move_uploaded_file($_FILES['file' . $i]['tmp_name'], $target_path)) {
$errorfiles .= '<span style="color:green">The file ' . $file . ' has been uploaded.<br />';
//Insert blob in table
$blobId = $blBlobs->uploadBlobs($target_path . $file);
$carfile = new CarFile(0, str_replace("." . findexts($file), "", $file), findexts($file), $_POST["filetext" . $i], $_POST["carid"], $blobId);
$blCarFile->insertCarFile($carfile);
} else {
$errorfiles .= "There was an error uploading the file, please try again! (" . $file . ")<br />";
}
}
} else {
$errorfiles .= "Text is a required field! (" . $_FILES['file' . $i]['name'] . ")<br />";
}
}
}
?>
<script language="javascript" type="text/javascript">
$blPictureOrder = new BLPictureOrder();
$blBlobs = new BLBlobs();
include_once getcwd() . "/include/imagehandler.php";
$upload_name = "Filedata";
//image uploaden + naar tabel wegschrijven
if (!empty($_FILES[$upload_name])) {
if (findexts($_FILES[$upload_name]['name']) == "jpg" || findexts($_FILES[$upload_name]['name']) == "jpeg" || findexts($_FILES[$upload_name]['imagename']) == "gif" || findexts($_FILES[$upload_name]['name']) == "png") {
$file = $_POST["CARID"] . "_" . strtolower(str_replace(" ", "_", $_FILES[$upload_name]['name']));
$path = getcwd() . "/pictures/";
//large
$errorim = upload($_FILES[$upload_name]['tmp_name'], $path, $file, 1600, 1600);
chmod($path . $file, 0777);
//class
if ($errorim[0] == true) {
//Insert blob in table
$blobId = $blBlobs->uploadBlobs($path . $file);
$carpicture = new CarPicture(0, str_replace("." . findexts($file), "", $file), findexts($file), $_POST["CARID"], $blobId);
$carpicture->setId($blCarPicture->insertCarPicture($carpicture));
$car = $blCar->getCar($_POST["CARID"]);
//default
if ($car->getDefaultPictureId() == null) {
$car->setDefaultPictureId($carpicture->getId());
$blCar->updateCar($car);
}
//pictureorder
$max = $blPictureOrder->getMaxPictureOrderByCar($car->getId()) + 1;
$pictureorder = new PictureOrder(0, $max, $car->getId(), $carpicture->getId());
$blPictureOrder->insertPictureOrder($pictureorder);
//success
//HandleError('<span style="color:green">' . $file . ' saved!</span><br />');
$carpicturelist[] = $carpicture;
