<?php
	/*
		(C) DairyWindow 2017
		admin@dairywindow.nz
	*/
	
	require "inc/connect.php";
	if($_SESSION['userLevel']<= $_SESSION['admin_group_edit']) $allow_edit=1; else $allow_edit=0;
	
	if(isset($_POST['add_text']) && $_POST['add_text']!="" && $_POST['add_text']!=null){
		//create new group
		
		$locGroupText = clean($_POST['add_text']);
		$locGroupOrder = clean($_POST['add_order']);
		
		$sql="
			# check if adding a duplicate
			Select
				dw_group.groupID
			From
				dw_group
			Where
				dw_group.groupText = ?
		";
		if(!$select_query = mysqli_prepared_query($link, $sql, "s", array($locGroupText), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		if(mysqli_prepared_num_rows($select_query)>0){
			$message['type'] = "error";
			$message['text'] = "<span class='glyphicon glyphicon-warning-sign' aria-hidden='true'></span> Group ".$groupText." already exists";
		}else{
			$sql="
				INSERT INTO dw_locgroup     ( locGroupText,  locGroupOrder,  locGroupModUser, locGroupModDate)
				VALUES                      (    ?        ,     ?         ,     ?           ,       now()    )
			";
			if(!savesql($link, $sql, "sii", array($locGroupText, $locGroupOrder, $_SESSION['userID']              ), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		}
	}
	
	$title = "Location group";
	require "inc/head.php";
	$menu = "locgroup";
	require "inc/menu.php";
	
	if($debug) showdebug();
?>
	
	<div id="topDIV" >
		<h1 class="text-center">
			<?php echo $title; ?>
			<?php if($_SESSION['userLevel']<= $_SESSION['admin_group_add']) { ?><button type="button" class="btn btn-primary" data-toggle="modal" data-target="#new_group" ><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 sorttable" 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" >Group</th>
				</tr>
			</thead>
			<tbody class="sortable">
				<?php
					$sql="
						# sql for main table
						Select
							dw_locgroup.locGroupID,
							dw_locgroup.locGroupOrder,
							dw_locgroup.locGroupText,
							dw_locgroup.locGroupModDate,
							dw_locgroup.locGroupModUser,
							dw_locgroup.locGroupModReason,
							dw_locgroup.locGroupChangeCode
						From
							dw_locgroup
						Where
							dw_locgroup.locGroupID > ?
						Order By
							dw_locgroup.locGroupOrder
					";
					if(!$group_query = mysqli_prepared_query($link, $sql, "i", array(0), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
					foreach($group_query as $group_row){
						?>
							<tr class="text-nowrap" id="locgroup_<?php echo $group_row['locGroupID']; ?>">
								<td class="text-center th_text"  id="group_text_<?php echo $group_row['locGroupID']; ?>"><?php echo $group_row['locGroupText' ]; if($debug) echo " [".$group_row['locGroupID']."]"; ?></td>
							</tr>
						<?php
					}
				?>
			</tbody>
		</table>
	</div>
	
	<script src="js/group.js?v=2.1"><!-- Include JS groupific to group.php (this file) --></script>
	
	<div id="new_group" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="new_groupLabel" 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_groupLabel">New group details</h2>
					</div>
					<div class="modal-body">
						<div class="form-group">
							<label for="add_text" class="col-sm-2 control-label">Group</label>
							<div class="col-sm-10">
								<input type="text" class="form-control" id="add_text" name="add_text" placeholder="Text" required >
							</div>
						</div>
						<div class="form-group">
							<label for="add_order" class="col-sm-2 control-label">Order</label>
							<div class="col-sm-10">
								<input type="number" class="form-control" id="add_order"  name="add_order"  placeholder="Order"  step="1" value="1" required >
							</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_group_button" onclick="please_wait('new_group_button');"><span class='glyphicon glyphicon-ok' aria-hidden='true'></span>&nbsp;Create</button>
					</div>
				</form>
			</div>
		</div>
	</div>
	<?php require "inc/footer.php"; ?>