<?php
/*
 * Following code will get single department details
 * create ticket
 */
  
// array for JSON response
$response = array();
 
// include db connect class
require_once 'db_connect.php';

date_default_timezone_set('Asia/Kolkata'); 

// connecting to db
$db = new DB_CONNECT();

if(isset($_POST["supid"],$_POST["empid"],$_POST["empname"],$_POST["branchId"],$_POST["orgID"],$_POST["pageId"],$_POST["photoToken"],$_POST["created_date"],$_POST["tokenid"],$_POST["train_no"],$_POST["coach_no"],$_POST["latitude"],$_POST["longitude"],$_POST["address"],$_POST["is_submit"])){

	$supid 		= $_POST['supid'];
	$empid 		= $_POST['empid'];
	$empname 	= $_POST['empname'];
	$branchId 	= $_POST['branchId'];
	$orgID 		= $_POST['orgID'];
	$pageId 	= $_POST["pageId"];
	$photoToken = $_POST["photoToken"];
	$created_date 	= $_POST["created_date"];
	$tokenid 	= $_POST["tokenid"];
	$train_no 	= $_POST["train_no"];
	$coach_no 	= $_POST["coach_no"];
	$latitude 	= $_POST["latitude"];
	$longitude 	= $_POST["longitude"];
	$address 	= $_POST["address"];
	$is_submit 	= $_POST["is_submit"];

	$result = mysql_query("INSERT INTO beatle_report(db_supId,db_empId,db_empname,db_reportBranchid,db_reportOrgid,db_reportPageid, db_photoToken, created_date, updated_date,tokenid,train_no,coach_no,latitude,longitude,address,is_submit) VALUES ('$supid','$empid','$empname','$branchId','$orgID','$pageId','$photoToken','$created_date','0000-00-00 00:00:00', '$tokenid', '$train_no', '$coach_no', '$latitude', '$longitude', '$address', '$is_submit')")or die(mysql_error());

	if($pageId == "1" || $pageId == "4"){
		if(isset($_FILES['image']['name'])){

			 $expdoc_file = $_FILES['image']['name'];
			 $upload_url = '../theme/black/upload/';
			 $uploadfile = $upload_url . $_FILES['image']['name'];
			 move_uploaded_file($_FILES["image"]["tmp_name"], $uploadfile);
			 $result = mysql_query("INSERT INTO beatle_photos(photoName,tokenId,created_date) VALUES ('$expdoc_file','$photoToken','$created_date')")or die(mysql_error());

		}
	}else{
	
		 for ($i = 0; $i < count($_FILES['image']['name']); $i++) { 
		 	$expdoc_file = $_FILES['image']['name'][$i];
		 	$upload_url = '../theme/black/upload/';
		 	$uploadfile = $upload_url . $_FILES['image']['name'][$i];
		 	move_uploaded_file($_FILES["image"]["tmp_name"][$i], $uploadfile);
		 	$coachAreaId = $_POST["coachAreaId"][$i];
		 	$result = mysql_query("INSERT INTO beatle_photos(photoName,coachAreaId,tokenId,created_date) VALUES ('$expdoc_file','$coachAreaId','$photoToken','$created_date')")or die(mysql_error());

		 }

	}
	

	if ($result) {
		// successfully inserted into database
		$response["success"] = 1;
		$response["message"] = "report successfully submitted.";

		// echoing JSON response
		echo json_encode($response);
	} else {
		// failed to insert row
		$response["success"] = 0;
		$response["message"] = "report has not submitted.";

		// echoing JSON response
		echo json_encode($response);
	}
}else{

	$response["success"] = 0;
	$response["message"] = "all fields are compulsory!";
	echo json_encode($response);
}

?>