<?php

include_once('resizer.inc.php');
include("ckeditor/ckeditor.php");

if(isset($_POST['verzenden'])){
	$verzenden = true;
}
if(isset($_POST['naam'])){
	$naam = $_POST['naam'];
	$naam = trim($naam);
	$lengte_naam = strlen($naam);
	if(($lengte_naam > 1) && ($lengte_naam < 150)){
		$valid_naam = true;
		$te_lang_naam = false;
	}else{
		$valid_naam = false;
		if($lengte_naam != 0){
			$te_lang_naam = true;
		}
	}
}else{
	$valid_naam = false;
}
if(isset($_POST['categorie'])){
	$categorie = $_POST['categorie'];
}
if($verzenden && $valid_naam && !empty($_POST['categorie'])){
	
	$naam_test = checkData($_POST['naam']);
	$categorie_test = checkData($_POST['categorie']);
	$test_url = friendlyURL($naam_test);
	
	$q_cases = sprintf("SELECT kms_spouwmuur_projecten.url FROM kms_spouwmuur_projecten WHERE kms_spouwmuur_projecten.url='%s' AND kms_spouwmuur_projecten.categorie = '%s'", $test_url, $categorie_test);
	$r_cases = mysql_query($q_cases);
	$rec_cases = mysql_fetch_array($r_cases);
	
	$uitkomst = $rec_cases['url'];
	
	if($test_url == $uitkomst){
		$bestaat_niet = false;	
	}else{
		$bestaat_niet = true;		
	}	
}
//check if al bestaat


if($_FILES['image_file']['tmp_name']){
	
	$file_tegroot = false;
	$valid_file = true;
	$extensions = array("image/jpg", "image/jpeg", "image/pjpeg");
	
	if(in_array($_FILES['image_file']['type'], $extensions)) { 
	   $valid_type = true; 
	}else{	
		$valid_type = false;
	}
	
}else{
	$valid_file = false;
	$valid_type = false;
}



if($verzenden && $valid_naam && $bestaat_niet && !empty($categorie) && $valid_type ){
		
	$root = $_SERVER['DOCUMENT_ROOT']."/";
	$dirname = time();
	
	mkdir ($root . '/project_images/' . $dirname);
			
	if($valid_file && $_FILES['image_file']['tmp_name']){
			
		$extensions = array("image/jpg", "image/jpeg", "image/pjpeg");
		
		if(in_array($_FILES['image_file']['type'], $extensions)) 
		{ 
			if($_FILES['image_file']['type'] == "image/jpg"){
				$ext = ".jpg";
			}else if($_FILES['image_file']['type'] == "image/jpeg"){
				$ext = ".jpg"; 
			}else if($_FILES['image_file']['type'] == "image/pjpeg"){
				$ext = ".jpg";
			}

		   $picture = $_FILES['image_file']['tmp_name'];
		   
		   list($width, $height) = getimagesize($picture);
		   
		   $objResize = new RVJ_ImageResize($_FILES['image_file']['tmp_name'], $root . '/project_images/'. $dirname . '/thumb_groot.jpg', 'W', '500');	
		}
	}

	$url = friendlyURL($naam);
	
	$naam = utf8_decode($naam);
	$naam = htmlentities($naam);
	$naam = checkData($naam);
	
	$categorie = checkData($categorie);

	$sort_order = 0;
		
	$q_nieuws = sprintf("INSERT INTO kms_spouwmuur_projecten (naam, categorie, url, image_dir, sort_order) VALUES ('%s', '%s', '%s', '%s', '%s')", 
	$naam,
	$categorie,
	$url,
	$dirname,
	$sort_order);
	
	$r_nieuws = mysql_query($q_nieuws);
	
	if($r_nieuws){
		   	
		$q_project_id = sprintf("SELECT kms_spouwmuur_projecten.project_id FROM kms_spouwmuur_projecten WHERE kms_spouwmuur_projecten.url='%s' AND kms_spouwmuur_projecten.categorie='%s'", $url, $categorie);
		$r_project_id = mysql_query($q_project_id);
		$rec_project_id = mysql_fetch_array($r_project_id);
		
		$q_sort_id = sprintf("SELECT kms_spouwmuur_projecten.project_id, kms_spouwmuur_projecten.sort_order FROM kms_spouwmuur_projecten WHERE kms_spouwmuur_projecten.categorie='%s'", $categorie);
		$r_sort_id = mysql_query($q_sort_id);
		
		while($rec_sort_id = mysql_fetch_array($r_sort_id)){ 
			$new_sort = $rec_sort_id['sort_order'] + 1;
			
			$q_update_sort = sprintf("UPDATE kms_spouwmuur_projecten SET sort_order = '%s' WHERE kms_spouwmuur_projecten.project_id='%s'", $new_sort, $rec_sort_id['project_id']);
			$r_update_sort = mysql_query($q_update_sort);		
		}

		header ('HTTP/1.1 301 Moved Permanently');
  		header ('Location: /kms/index.php?p=project_thumb&url='.$url);
				

	}else{
		echo("Er is iets fout gegaan.");
	}
}else{
?>

<h1>Project toevoegen</h1>
<p>Vul onderstaande gegevens in om een project toe te voegen.</p>
<span class="label">* = verplicht</span><br /><br />
<form enctype="multipart/form-data" action="<?php $_SERVER['PHP_SELF']; ?>" id="aanmelden" name="aanmelden" method="post">
    	    
	<div>   
        <label>Naam*</label>
		<input name="naam" type="text" value="<?php echo(htmlspecialchars($naam)); ?>" />
        <?php if(!$valid_naam && $verzenden){ echo("<span class=\"error\"> (foutieve invoer)</span>"); }?>
        <?php if(!$valid_naam && $verzenden && $te_lang_naam){ echo("<span class=\"error\"><br />(invoer te lang)</span>"); }?>
        <?php if($valid_naam && $verzenden && !$bestaat_niet){ echo("<span class=\"error\"><br />(de naam bestaat al)</span>"); }?><br />
        
        <label>Categorie:*</label>
        <select name="categorie" >
			<option value="spouwmuurisolatie" <?php if ($categorie == "spouwmuurisolatie") { echo("selected=\"selected\"");} ?>>Spouwmuurisolatie</option>
        </select>
        <?php if(empty($categorie) && $verzenden){ echo("<span class=\"error\"> (selecteer een categorie)</span>"); }?>
        
        <br /><br />
        
       	<label>Thumb selecteren <br />(.jpg)</label>
     	<input class="file_input" type="file" name="image_file" />
       	
        <br />
		<?php if(!$valid_type && !$valid_file && $verzenden && !$file_tegroot){ print("<span class=\"error\"><br />(Selecteer een afbeelding)</span>"); }?>
        <?php if(!$valid_type && $valid_file && $verzenden && !$file_tegroot){ print("<span class=\"error\"><br />(Alleen jpg bestanden)</span>"); }?>
		<?php if($file_tegroot && $verzenden){ print("<span class=\"error\"><br />(Uw bestand is te groot. Max 1 MB)</span>"); }?><br />
        
        
        <br /><br />
       
        <input name="verzenden" type="submit" value="Toevoegen" class="submit" />
        <a class="submit_annuleren" href="index.php?p=project_overzicht" title="Annuleren">Annuleren</a>
	</div>
</form>

<?php
}
?>