<?php
include 'config.php';

// Check if the user is logged in

if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1'))
{
header("Location: login.php");
exit;
}
require("configure.php"); 
require("function_createthumb.php");


$pdtitleen			= htmlspecialchars($_POST["pdtitleen"],ENT_QUOTES);
$pdyear				= htmlspecialchars($_POST["pdyear"],ENT_QUOTES);
$pdsize				= htmlspecialchars($_POST["pdsize"],ENT_QUOTES);
$pddescen			= preg_replace("/'/","\'",$_POST["pddescen"]);
$nowdate 			= date("Y-m-d H:i:s");



$sql = "select max(pdid) as maxid ";
$sql .= "from project_det ";
$result=mysql_query($sql);
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$pdid = $row{maxid}+1;


$cntpjcatid		  = count($_POST['pjcatidSelect']);
$i=1;
foreach($_POST['pjcatidSelect'] as $pjcatidbox){
	$pjcatid[$i++] =  $pjcatidbox;
	//echo "<br>selected:".$pjcatidbox ;
}

// Delete Project Category db
$sql3 = "DELETE FROM project_det_cat WHERE pdid=". $pdid ." ";
mysql_query($sql3);

for($i=1;$i<=$cntpjcatid;$i++){
	if(strlen($pjcatid[$i])> 0){
		// Sort
		$sql = "select max(psort) as maxid ";
		$sql .= "from project_det_cat WHERE pjcatid = '".$pjcatid[$i]."' ";
		$result=mysql_query($sql);
		$row = mysql_fetch_array($result,MYSQL_ASSOC);
		$psort = $row{maxid}+1;
		
		$sql2 = "insert into project_det_cat (pdid, pjcatid, psort) values ('$pdid', '".$pjcatid[$i]."', '$psort')";
		mysql_query($sql2);
	}
} 

 

/*print_r($_POST); 
exit;*/

// copy image
$x=1;
for($i=1;$i<=10;$i++){	
	if ($_FILES['pimgfile']['name'][$i] <> '')
	{
		if (($_FILES['pimgfile']["type"][$i] == "image/bmp") || ($_FILES['pimgfile']["type"][$i] == "image/BMP") || ($_FILES['pimgfile']["type"][$i] == "image/gif") || ($_FILES['pimgfile']["type"][$i] == "image/GIF") || ($_FILES['pimgfile']["type"][$i] == "image/jpg") || ($_FILES['pimgfile']["type"][$i] == "image/JPG") || ($_FILES['pimgfile']["type"][$i] == "image/jpeg") || ($_FILES['pimgfile']["type"][$i] == "image/JPEG") || ($_FILES['pimgfile']["type"][$i] == "image/pjpeg") || ($_FILES['pimgfile']["type"][$i] == "image/PJEG") || ($_FILES['pimgfile']["type"][$i] == "image/png") || ($_FILES['pimgfile']["type"][$i] == "image/x-png") || ($_FILES['pimgfile']["type"][$i] == "image/PNG") || ($_FILES['pimgfile']["type"][$i] == "image/X-PNG"))
		{
			$sql = "select max(pimgid) as maxid ";
			$sql .= "from project_img ";
			$result=mysql_query($sql);
			$row = mysql_fetch_array($result,MYSQL_ASSOC);
			$pimgid = $row{maxid}+1;
			
			$sql2 = "select max(pimgsort) as maxid ";
			$sql2 .= "from project_img where pdid=$pdid ";
			$result2=mysql_query($sql2);
			$row2 = mysql_fetch_array($result2,MYSQL_ASSOC);
			$pimgsort = $row2{maxid}+1;
			
			$filename=$_FILES['pimgfile']['name'][$i];
			preg_match("/\.([^\.]+)$/", $filename, $file_ext);
			
			copy ($_FILES['pimgfile']['tmp_name'][$i], "../project/".$pdid."_id_".$pimgid.".".$file_ext[1]) 
				or die ("Could not copy the file: Project Photo"); 
			
			$image = "../project/".$pdid."_id_".$pimgid.".".$file_ext[1];
			createthumb($image, $image, 800, 800);
			
			copy ($_FILES['pimgfile']['tmp_name'][$i], "../project/large/".$pdid."_id_".$pimgid.".".$file_ext[1]) 
				or die ("Could not copy the file: Project Photo(large)"); 
			
			$imagelarge = "../project/large/".$pdid."_id_".$pimgid.".".$file_ext[1];
			createthumb($imagelarge, $imagelarge, 280, 280);
			
			copy ($_FILES['pimgfile']['tmp_name'][$i], "../project/thumb/".$pdid."_id_".$pimgid.".".$file_ext[1]) 
				or die ("Could not copy the file: Project Photo(thumb)"); 
			
			$imagethumb = "../project/thumb/".$pdid."_id_".$pimgid.".".$file_ext[1];
			createthumb($imagethumb, $imagethumb, 140, 140);
			
			$pimgfile[$i] = $pdid."_id_".$pimgid.".".$file_ext[1];
			$pimgfile[$i] = htmlspecialchars($pimgfile[$i],ENT_QUOTES);
			
			// Save DB					
			$sql = "insert into project_img (pimgid, pdid, pimgfile, pimgsort, creationday, modifyday, cmsloginid) values ('$pimgid', '$pdid', '".$pimgfile[$i]."', '".$pimgsort."', '$nowdate', '$nowdate', '".$_SESSION['cmsloginid']."')";
			mysql_query($sql);
			if( mysql_errno() > 0 ){
				echo 'Add Project Detail-Photo Error:<br />'. mysql_error() .'<br />SQL: '. $sql;
				exit;
			}
			$x++;	
		  }
		else
		  {
		  // upload error
		  ?>
			<script language="javascript">
			alert("Files must be BMP, JPEG, GIF, or PNG");
			history.back();
			</script>
		 <?php
		 exit;
		 }		
	}
	else
	{
		$pimgfile[$i] = "";
	}
	
	
}
// End copy image

$sql = "insert into project_det (pdid, pdtitleen, pdyear, pdsize, pddescen, pdstatus, creationday, modifyday, cmsloginid) values ('$pdid', '$pdtitleen', '$pdyear', '$pdsize', '$pddescen', '1', '$nowdate', '$nowdate', '".$_SESSION['cmsloginid']."')";
mysql_query($sql);
if( mysql_errno() > 0 ){
	echo 'Add Project Detail Error:<br />'. mysql_error() .'<br />SQL: '. $sql;
	exit;
}

mysql_close($dbh);

header("Location: project_detail_index.php?msg=Add Successful");
?>