<?php
	/*
		(C) DairyWindow 2017
		admin@dairywindow.nz
	*/

	require "inc/connect.php";
	if($_SESSION['userLevel']<=$_SESSION['admin_expiry_edit']) $allow_edit=1;
	else $allow_edit=0;

	if(isset($_POST['add_text']) && $_POST['add_text']!="" && $_POST['add_text']!=null){
		//create new expiry

		$expiryText  = clean(trim($_POST['add_text']));
		$expiryYear  = isset($_POST['add_year' ]) ? clean($_POST['add_year' ]) : 0;
		$expiryMonth = isset($_POST['add_month']) ? clean($_POST['add_month']) : 0;
		$expiryDay   = isset($_POST['add_day'  ]) ? clean($_POST['add_day'  ]) : 0;

		$sql="
			# check if adding a duplicate
			Select
				dw_expiry.expiryID
			From
				dw_expiry
			Where
				dw_expiry.expiryText = ?
		";
		if(!$select_query = mysqli_prepared_query($link, $sql, "s", array($expiryText), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		if(mysqli_prepared_num_rows($select_query)>0){
			//already exists
			$message['type'] = "error";
			$message['text'] = "<span class='glyphicon glyphicon-warning-sign' aria-hidden='true'></span> Expiry <strong>".$expiryText."</strong> already exists";
		}else{
			//does not exist
			$sql="
				INSERT INTO dw_expiry         ( expiryText,  expiryYear,  expiryMonth,  expiryDay, expiryModUser, expiryModDate)
				VALUES                        (       ?   ,        ?   ,        ?    ,        ?  ,       ?      ,    now()     )
			";
			if(!savesql($link, $sql, "siiii", array($expiryText, $expiryYear, $expiryMonth, $expiryDay, $_SESSION['userID']         ), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		}
	}

	$title = "Expiry";
	require "inc/head.php";
	$menu = "expiry";
	require "inc/menu.php";

	if($debug) showdebug();
?>

	<div id="topDIV" >
		<h1 class="text-center">
			<?php
				echo $title;
				if($_SESSION['userLevel']<= $_SESSION['admin_expiry_add']) { ?>&nbsp;<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#new_expiry" ><span class='glyphicon glyphicon-plus' aria-hidden='true'></span>&nbsp;Create new</button><?php }
			?>
		</h1>
	</div>

	<div id="loading" ><img src="images/loading-small.gif" alt="Please wait. Loading..." width="111" height="156" style="margin-top:150px;" class="center-block"><br><div class="text-center"><img src='images/carregando.gif' width='16' height='16'>&nbsp;Please wait while loading...</div></div>

	<div id="main" class="container-fluid" style="display:none;" role="main">
		<table class="table table-hover" id="table">
			<thead>
				<tr id="table-head" style="background-color:white; color:inherit; white-space:nowrap;">
					<th class="text-center th_text"    id="th_text"   >Text</th>
					<th class="text-center th_year"    id="th_year"   >Years</th>
					<th class="text-center th_month"   id="th_month"  >Months</th>
					<th class="text-center th_day"     id="th_day"    >Days</th>
				</tr>
			</thead>
			<tbody>
				<?php
					$sql="
						# sql for main table
						Select
							dw_expiry.expiryID,
							dw_expiry.expiryYear,
							dw_expiry.expiryMonth,
							dw_expiry.expiryDay,
							dw_expiry.expiryText,
							dw_expiry.expiryModDate,
							dw_expiry.expiryModUser,
							dw_expiry.expiryModReason,
							dw_expiry.expiryChangeCode
						From
							dw_expiry
						Where
							dw_expiry.expiryID > ?
						Order By
							dw_expiry.expiryYear,
							dw_expiry.expiryMonth,
							dw_expiry.expiryDay
					";
					if(!$expiry_query = mysqli_prepared_query($link, $sql, "i", array(0), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
					foreach($expiry_query as $expiry_row){
						?>
							<tr class="text-nowrap" id="expiry_<?php echo $expiry_row['expiryID']; ?>">
								<td class="text-center th_text"  id="expiry_text_<?php  echo $expiry_row['expiryID']; ?>"><?php echo $expiry_row['expiryText' ]; if($debug) echo " [".$expiry_row['expiryID']."]"; ?></td>
								<td class="text-center th_year"  id="expiry_year_<?php  echo $expiry_row['expiryID']; ?>"><?php echo $expiry_row['expiryYear' ]; ?></td>
								<td class="text-center th_month" id="expiry_month_<?php echo $expiry_row['expiryID']; ?>"><?php echo $expiry_row['expiryMonth']; ?></td>
								<td class="text-center th_day"   id="expiry_day_<?php   echo $expiry_row['expiryID']; ?>"><?php echo $expiry_row['expiryDay'  ]; ?></td>
							</tr>
						<?php
					}
				?>
			</tbody>
		</table>
	</div>

	<div id="new_expiry" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="new_expiryLabel" aria-hidden="true">
		<div class="modal-dialog">
			<div class="modal-content">
				<form class="container-fluid panel-info form-horizontal" method="post">
					<div class="modal-header">
						<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
						<h2 class="modal-title" id="new_expiryLabel">New expiry details</h2>
					</div>
					<div class="modal-body">
						<div class="form-group">
							<label for="add_text" class="col-sm-2 control-label">Text</label>
							<div class="col-sm-10">
								<input type="text" class="form-control" id="add_text" name="add_text" placeholder="e.g. 1 year, 2 months, 3 days" required >
							</div>
						</div>
						<div class="form-group">
							<label for="add_year" class="col-sm-2 control-label">Expiry</label>
							<div class="col-sm-3">
								<input type="number" class="form-control" id="add_year"  name="add_year"  placeholder="Years"  step="1" >
							</div>
							<div class="col-sm-3">
								<input type="number" class="form-control" id="add_month" name="add_month" placeholder="Months" step="1" >
							</div>
							<div class="col-sm-3">
								<input type="number" class="form-control" id="add_day"   name="add_day"   placeholder="Days"   step="1" >
							</div>
						</div>
					</div>
					<div class="modal-footer">
						<button type="button" class="btn btn-default" data-dismiss="modal"><span class='glyphicon glyphicon-remove' aria-hidden='true'></span>&nbsp;Cancel</button>
						<button type="submit" class="btn btn-primary" id="new_expiry_button" onclick="please_wait('new_expiry_button');"><span class='glyphicon glyphicon-ok' aria-hidden='true'></span>&nbsp;Create</button>
					</div>
				</form>
			</div>
		</div>
	</div>

	<?php require "inc/footer.php"; ?>
