<?php
require_once(__DIR__ . '/../checkuser.php');
session_start();
function addDetail($job_id) {
	global $dbh;

	//-----------------------------------------------------------------------------
	// Find job by id
	//-----------------------------------------------------------------------------
	$sql = "SELECT * FROM sup_job WHERE id = ?";
	$parameters = array($job_id);
	if (!($sth = $dbh->prepare($sql))) {
		throw new Exception("sql prepare statement failure: $sql");
	}
	$sth->setFetchMode(PDO::FETCH_ASSOC);
	if (!$sth->execute($parameters)) {
		throw new Exception("sql execute statement failure: $sql");
	}
	$job = $sth->fetch(PDO::FETCH_ASSOC);
	if (empty($job)) {
		throw new Exception('Job not found!');
	}

	require(__DIR__ . '/add.php');

	//-----------------------------------------------------------------------------
	// Return array parameters
	//-----------------------------------------------------------------------------
	$pending_tasks = array();
	if (Util::isAdmin()) {
		/*$sql = "
SELECT pending.*
FROM sup_job_pending pending
INNER JOIN sup_job job ON job.id = pending.job_id
WHERE job.customer_id = ? AND pending.actived = ? AND pending.deleted = ? AND pending.job_id='-1'
ORDER BY pending.id
";
		$parameters = array($job['customer_id'], 1, 0);
		if (!($sth = $dbh->prepare($sql))) {
			throw new Exception("sql prepare statement failure: $sql");
		}
		$sth->setFetchMode(PDO::FETCH_ASSOC);
		if (!$sth->execute($parameters)) {
			throw new Exception("sql execute statement failure: $sql");
		}
		$pending_tasks = $sth->fetchAll();*/
	}

	//get pendings job

	$sql6 = "select job.*,job_detail.*, job_detail.remarks as job_detail_remarks, job_detail.id as job_detail_id, job_detail.status as job_detail_status, job_pending.id as job_pending_id from sup_job job, sup_job_detail job_detail, sup_job_pending job_pending
	where job.id = job_detail.job_id and job_pending.job_detail_id = job_detail.id and job.customer_id = ? and job_detail.actived = 1 and job_detail.deleted = 0 and job_detail.status = 3 and job_detail.job_id != ? and job.status = ? and ((job.date >= ? and job.job_type = 'JOB') or (job.job_type = 'CALL IN')) and job_detail.follow_up_flag = ? group by job_detail_id";

	if (!($sth6 = $dbh->prepare($sql6))) {
		throw new Exception("sql prepare statement failure: $sql6");
	}
	$sth6->setFetchMode(PDO::FETCH_ASSOC);
	if (!$sth6->execute(array($job["customer_id"], $job["id"], 2, "2014-01-01", 0))) {
		throw new Exception("sql execute statement failure: $sql6");
	}

	$pending_tasks = $sth6->fetchAll();

	$sql = "SELECT column_name FROM information_schema.columns WHERE table_schema = (SELECT DATABASE()) AND table_name = ?";
	$parameters = array('sup_job_detail');
	if (!($sth = $dbh->prepare($sql))) {
		throw new Exception("sql prepare statement failure: $sql");
	}
	$sth->setFetchMode(PDO::FETCH_ASSOC);
	if (!$sth->execute($parameters)) {
		throw new Exception("sql execute statement failure: $sql");
	}
	$job_detail_columns = $sth->fetchAll();

	$job_detail_attributes = array();
	foreach ($job_detail_columns as $column) {
		$column = $column['column_name'];
		$job_detail_attributes[$column] = null;
	}

	$json_details = array();
	/*foreach ($pending_tasks as $pending) {
		$detail = JobPending::convert_to_job_detail($pending, $job_detail_attributes);
		$json_details[] = json_encode($detail);
	}*/
	if (empty($json_details)) {
		$detail = $job_detail_attributes;
		$json_details[] = json_encode($detail);
	}

	return array(
		'job' => $job,
		'json_details' => $json_details,
		'pending_tasks' => $pending_tasks
	);
}
extract(addDetail($_GET['job_id']));

$sql = "SELECT column_name FROM information_schema.columns WHERE table_schema = (SELECT DATABASE()) AND table_name = ?";
$parameters = array('sup_job_detail');
if (!($sth = $dbh->prepare($sql))) {
	throw new Exception("sql prepare statement failure: $sql");
}
$sth->setFetchMode(PDO::FETCH_ASSOC);
if (!$sth->execute($parameters)) {
	throw new Exception("sql execute statement failure: $sql");
}
$columns = $sth->fetchAll();

$defaultJobDetail = array();
foreach ($columns as $column) {
	$column = $column['column_name'];
	$defaultJobDetail[$column] = null;
}

$sql5 = "select * from sup_task_category where deleted = 0 order by task_category_id ASC";
if (!($sth5 = $dbh->prepare($sql5))) {
	throw new Exception("sql prepare statement failure: $sql5");
}

if (!$sth5->execute()) {
	throw new Exception("sql execute statement failure: $sql5");
}
$task_categories = $sth5->fetchAll();

?><!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml"
      xmlns:ng="http://angularjs.org">
<head>

	<?php require(__DIR__ . '/../inc/_head_meta.php'); ?>

	<?php require(__DIR__ . '/../inc/_head_css.php'); ?>

	<style type="text/css">
		body {
			padding-top: 60px; /* 60px to make the container go all the way to the bottom of the topbar */
			padding-bottom: 40px;
		}
	</style>

	<?php require(__DIR__ . '/../inc/_head_script.php'); ?>

	<script type="text/javascript">
		function JobDetailControl($scope) {
			function resetModel() {
				$.extend($scope, <?=json_encode($defaultJobDetail)?>);
			}

			resetModel();
			$.extend($scope, {
				addDetail: function() {
					$scope.details.push({
						<?php
						// Example: title: $scope.title, remarks: $scope.remarks...
						$tmp_values = array();
						foreach ($defaultJobDetail as $key => $value) {
							$tmp_values[] = $key.': $scope.'.$key;
						}
						echo implode(', ', $tmp_values);
						?>
					});
					resetModel();
				},
				removeDetail: function(index) {
					$scope.details.splice(index, 1);
				},
				details: [ <?=isset($json_details) ? implode(', ', $json_details) : ''?> ]
			});
		}
	</script>

	<script type="text/javascript">
		$(function () {
			$(".pending_task").attr("disabled", true);
		});

		function active_pending_task(el, pending_job_detail_id){
			//var pending_job_detail_id = $(el).val();
			if($(el).prop("checked")){
				$(".pending_task_"+pending_job_detail_id).removeAttr("disabled");
			}else{
				$(".pending_task_"+pending_job_detail_id).attr("disabled", true);
			}

		}
	</script>

</head>
<body>

<?php require( __DIR__ . '/../inc/_navbar.php'); ?>

<div class="container">

	<!--<h2>Add Tasks to Job #<?//=h($job['id'])?></h2>-->
	<h2>Add Tasks to Job <?php foreach($_SESSION["all_job_ids"] as $job_id) echo "#".$job_id." ";?></h2>
	<form id="form" class="form-horizontal" method="post">
		<?php $attribute = 'job_id'; ?>
		<input type="hidden" name="<?=$attribute?>" value="<?=$_GET['job_id']?>" />

		<?php
			if(!empty($pending_tasks)){
				$i = 0;
				foreach($pending_tasks as $key => $pending_task){
					?>
					<div>
						<div class="control-group">
							<label class="control-label">#Follow Up Task</label>

							<div class="controls" style="margin-bottom: 20px;">
								<?php $attribute = 'add_to_job'; ?>
								<input type="checkbox" name="pending_task[<?=$i?>][<?= $attribute ?>]" value="1" onclick="active_pending_task(this, <?=$pending_task["id"]?>);" />

								<div style="display: inline-block; position: relative; top:3px;">
									Add to this job
								</div>

							</div>

							<div class="controls">
								<?php $attribute = 'from_job_pending_id'; ?>
								<input type="hidden" name="pending_task[<?=$i;?>][<?=$attribute?>]" value="<?=$pending_task["job_pending_id"]?>" />
								<?php $attribute = 'job_detail_id'; ?>
								<input type="hidden" name="pending_task[<?=$i;?>][<?=$attribute?>]" value="<?=$pending_task["id"]?>" class="pending_task pending_task_<?=$pending_task["id"]?>"/>

								<?php  $attribute = 'task_category_id'; $label = 'Task Category ID';?>
								<select name="pending_task[<?=$i;?>][<?= $attribute ?>]" placeholder="<?= $label ?>" class="required pending_task pending_task_<?=$pending_task["id"]?>">
									<?php
										foreach ($task_categories as $key22 => $task_category) {

											if($task_category["task_category_id"] == $pending_task["task_category_id"])
												$selected = "selected";
											else
												$selected = "";

											echo '<option value="'.$task_category["task_category_id"].'" '.$selected.'>'.$task_category["category_name"].'</option>';

										}
									?>

								</select>
								<br><br>
								<?php $attribute = 'title'; $label = 'Title'; ?>
								<input type="text" name="pending_task[<?=$i;?>][<?=$attribute?>]" placeholder="<?=$label?>" value="<?=$pending_task["title"]?>" class="required pending_task pending_task_<?=$pending_task["id"]?>"/>

							</div>
							<br>
							<?php $attribute = 'remarks'; $label = 'Remarks'; ?>
							<div class="controls">
								<textarea name="pending_task[<?=$i;?>][<?=$attribute?>]" class="span6 textarea_style pending_task pending_task_<?=$pending_task["id"]?>" placeholder="<?=$label?>"><?=$pending_task["job_detail_remarks"]?></textarea>

							</div>


						</div>
					</div>
					<?php $i++; } } ?>

		<hr>

		<div id="ng-app" ng:app="" ng:controller="JobDetailControl">
			<div ng:repeat="detail in details">
				<div class="control-group">
					<label class="control-label">#New Task<!--{{$index+1}}--></label>
					<div class="controls">
						<?php $attribute = 'from_job_pending_id'; ?>
						<input type="hidden" name="job_detail[{{$index+1}}][<?=$attribute?>]" value="{{detail.<?=$attribute?>}}" />

						<?php  $attribute = 'task_category_id'; $label = 'Task Category ID';?>
						<select id="{{detail.id}}" ng:readonly="detail.from_job_pending_id" name="job_detail[{{$index+1}}][<?= $attribute ?>]" class="span2 required" placeholder="<?= $label ?>">

							<?php foreach ($task_categories as $key => $task_category) { ?>
								<option value="<?=$task_category["task_category_id"]?>"><?=$task_category["category_name"]?></option>
							<?php } ?>
						</select>
						<br><br>
						<?php $attribute = 'title'; $label = 'Title'; ?>
						<input ng:readonly="detail.from_job_pending_id" type="text" name="job_detail[{{$index+1}}][<?=$attribute?>]" placeholder="<?=$label?>" value="{{detail.<?=$attribute?>}}" class="required" />

					</div>
					<br>
					<?php $attribute = 'remarks'; $label = 'Remarks'; ?>
					<div class="controls">
						<textarea ng:readonly="detail.from_job_pending_id" name="job_detail[{{$index+1}}][<?=$attribute?>]" class="span6 textarea_style" placeholder="<?=$label?>">{{detail.<?=$attribute?>}}</textarea>
						<button type="button" ng:click="removeDetail($index)" class="btn btn-danger remove-detail-btn">Delete</button>
					</div>
				</div>
			</div>
			<div class="control-group">
				<div class="controls">
					<input type="submit" class="btn btn-primary" value="Save" />
					<button type="button" ng:click="addDetail()" class="btn add-detail-btn">Add Task</button>
				</div>
			</div>
		</div>
	</form>


	<script type="text/javascript">
		$(function() {
			function init() {
				var $removeDetailBtn = $('.remove-detail-btn');
				if ($removeDetailBtn.length > 0) {
					$removeDetailBtn.show();
				} else {
					$removeDetailBtn.hide();
				}
			}
			$(document).on('click', '.add-detail-btn, .remove-detail-btn', function() {
				init();
			});
			init();

			$('#form').validate();
		});
	</script>

	<?php require( __DIR__ . '/../inc/_footer.php'); ?>

</div> <!-- /container -->
</body>
</html>