<?php
/**
 * Copyright (C) DairyWindow 2019
 * admin@dairywindow.nz
 */

	/* (C) DairyWindow 2012-2017 */
	
	require "inc/connect.php";
	require "inc/fade.php";
	
	$title = "Edit tests on sub form";
	require "inc/head.php";
	$menu = "submod";
	require "inc/menu.php";
	
	if($debug) showdebug();

	if(isset($_POST['del']) && $_POST['del']!='' && $_POST['del']!=null){
		$sql="
			Delete From
			  dw_sub
			Where
			  dw_sub.subID = ?
			Limit 1
		";
		if(!savesql($link, $sql, "i", array($_POST['del']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}else{
		if(
			isset($_POST['subID'  ]) && $_POST['subID'  ]!="" && $_POST['subID'  ]!=null &&
			isset($_POST['subTest']) && $_POST['subTest']!="" && $_POST['subTest']!=null &&
			isset($_POST['subFreq']) && $_POST['subFreq']!="" && $_POST['subFreq']!=null
		){
			$subID   = clean($_POST['subID'  ]);
			$subTest = clean($_POST['subTest']);
			$subFreq = clean($_POST['subFreq']);
			$sql="
				UPDATE dw_sub SET
					subTest    = ?,
					subFreq    = ?,
					subModUser = ?,
					subModDate = now()
				WHERE subID  = ?
			";
			if(!savesql($link, $sql, "iiii", array($subTest, $subFreq, $_SESSION['userID'], $subID), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		}
	}

?>


<h1 class='text-center'><?php echo $title; ?></h1>

<div class='col-md-3' >
	<form class="form-horizontal" method="get" id='mainform' style='position:fixed;'>
		<div class="form-group">
			<label for="product" class="col-sm-2 control-label">Product</label>
			<div class="col-sm-10">
				<?php
					$sql="
						Select
							dw_spec.specID,
							dw_spec.specText,
							dw_spec.specShortDesc
						From
							dw_spec
						Where
							dw_spec.specActive = 1 And
							dw_spec.specSite = ?
						Order By
							dw_spec.specStyle,
							dw_spec.specOrder,
							dw_spec.specText
					";
					if(!$specquery = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				?>
				<select id='product' name='product' class='form-control' onchange='submit();'>
					<?php
						foreach($specquery as $specarray){
							echo "<option value='".$specarray['specID']."'";
								if(isset($_GET['product']) && $_GET['product']==$specarray['specID']) echo " selected";
								echo ">".$specarray['specText']." (".$specarray['specShortDesc'].")";
								if($debug) echo " [".$specarray['specID']."]";
							echo "</option>";
						}
					?>
				</select>
			</div>
		</div>
		<div class="form-group">
			<label for="form" class="col-sm-2 control-label">Form</label>
			<div class="col-sm-10">
				<?php
					$sql="
						Select
							dw_form.formID,
							dw_form.formText
						From
							dw_form
						Where
							dw_form.formSite  = ? And
							dw_form.formActive = 1
						Group By dw_form.formID
						Order By
							dw_form.formOrder,
							dw_form.formText
					";
					if(!$formquery = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				?>
				<select id='form' name='form' class='form-control' onchange='submit();'>
					<option value='0' >Please select a submission form</option>
					<?php
						foreach($formquery as $formarray){
							echo "<option value='".$formarray['formID']."'";
								if(isset($_REQUEST['form']) && $_REQUEST['form']==$formarray['formID']) echo " selected";
								echo ">".$formarray['formText'];
								if($debug) echo " [".$formarray['formID']."]";
							echo "</option>";
						}
					?>
				</select>
			</div>
		</div>
		
		<div class="form-group">
			<div class="col-sm-offset-2 col-sm-10">
				<button type="submit" class="btn btn-primary">Refresh</button>
			</div>
		</div>
	</form>
</div>

<div id='main' class='col-md-9' style='display:nonex;' >
	<?php
		if(isset($_GET['product']) && $_GET['product']!='' && $_GET['product']!=0){
			$sql="
				Select specText
				From dw_spec
				Where specID = ? 
			";
			if(!$specquery = mysqli_prepared_query($link, $sql, "i", array($_GET['product']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
			$specarray = $specquery[0];
			echo "<h2 class='text-center'>".$_SESSION['comp_name']." is requesting the lab test ".$specarray['specText']." for:</h2>";
		}
	?>
	<form method='post'>
		<table class='table table-hover'>
			<thead>
				<tr>
					<th class='text-center'>Group</th>
					<th class='text-center'>Test name</th>
					<th class='text-center'>Will show as</th>
					<th class='text-center'>Frequency</th>
					<th class='text-center'><!-- Button --></th>
				</tr>
			</thead>
			<tbody>
				<?php
					if(isset($_GET['product']) && $_GET['product']!='' && $_GET['product']!=0 && isset($_GET['form']) && $_GET['form']!='' && $_GET['form']!=0){
						$sql="
							Select
								dw_sub.subID,
								dw_test.testID,
								dw_group.groupText,
								dw_test.testText,
								dw_test.testTextLab,
								dw_frequency.freqID,
								dw_frequency.freqText
							From
								dw_sub Left Join
								dw_test      On dw_test.testID   = dw_sub.subTest    Left Join
								dw_group     On dw_group.groupID = dw_test.testGroup Left Join
								dw_frequency On dw_sub.subFreq   = dw_frequency.freqID
							Where
								dw_test.testSite = ? And
								dw_sub.subSpec   = ? And
								dw_sub.subForm   = ?
							Order By
								dw_group.groupOrder,
								dw_group.groupText,
								dw_test.testOrder,
								dw_test.testText
						";
						if(!$subquery = mysqli_prepared_query($link, $sql, "iii", array($_SESSION['userSite'], $_GET['product'], $_GET['form']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
						if(mysqli_prepared_num_rows($subquery)>0){
							foreach($subquery as $subarray){
								echo "<tr data-toggle='modal' data-target='#myModal' onclick='setmodal(".$subarray['testID'].",".$subarray['freqID'].",".$subarray['subID'].");'>
									<td class='text-center'>".$subarray['groupText']."</td>
									<td class='text-center'>".$subarray['testText']; if($debug) echo " [".$subarray['testID']."]"; echo "</td>
									<td class='text-center'>".$subarray['testTextLab']."</td>
									<td class='text-center'>".$subarray['freqText']."</td>
									<td class='text-center'>
										<button type='submit' class='btn btn-sm btn-default' name='del' value='".$subarray['subID']."'>
											<span class='glyphicon glyphicon-trash' aria-hidden='true'></span>
											<span class='sr-only'>Remove</span>
											<span class='hidden-xs'> Remove</span>
											"; if($debug) echo $subarray['subID']; echo "
										</button>
									</td>
								</tr>";
							}
						}
						echo "</tbody><tfoot><tr>
							<td colspan='3' class='text-center'>";
								$test_sql='
								Select
									dw_group.groupText,
									dw_test.testID,
									dw_test.testText,
									dw_test.testUnits
								From
									dw_group Right Join
									dw_test On dw_group.groupID = dw_test.testGroup
								Where
									dw_test.testActive = 1 And
								  dw_test.testSite = ?
								Order By
									dw_group.groupOrder,
									dw_test.testOrder
							';
							if(!$test_query = mysqli_prepared_query($link, $test_sql, 'i', array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $test_sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
							echo '<select name="newtest" id="tests" class="form-control" >';
								$group = array();
								foreach($test_query as $row){
									$group[$row['groupText']][] = $row;
								}
								foreach ($group as $key => $values) {
									echo '<optgroup label="'.$key.'">';
									foreach ($values as $value) {
										echo '<option value="'.$value['testID'].'" ';
											if(isset($_POST['new_test']) && $_POST['new_test']==$value['testID']) echo 'selected ';
											echo '>'.$value['testText'];
											if(!empty($value['testUnits'])) echo ' ('.$value['testUnits'].')';
											if($debug) echo ' ['.$value['testID'].']';
										echo '</option>';
									}
									echo '</optgroup>';
								}
							echo '</select>
							</td>
							<td class="text-center">';
								$sql="
									Select
										freqID,
										freqText
									From
										dw_frequency
									Where
										freqSite = 0 Or
										freqSite = ?
									Order By
										freqOrder,
										freqText
								";
								if(!$freqquery = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
								echo "<select name='newfreq' id='newfreq' class='form-control'>";
									foreach($freqquery as $freqarray){
										echo "<option value='".$freqarray['freqID']."' ";
										if(isset($_POST['newfreq']) && $_POST['newfreq']==$freqarray['freqID']) echo "selected ";
										echo ">".$freqarray['freqText']."</option>";
									}
								echo '</select>
							</td>
							<td class="text-center">
								<button type="button" class="btn btn-default" id="btnAdd" name="btnAdd">
									<span class="glyphicon glyphicon-plus" aria-hidden="true"></span>
									<span class="sr-only">Add</span>
									<span class="hidden-xs"> Add </span>
								</button>
							</td>
						</tr>';
					}
					if(isset($_GET['product']) && $_GET['product']!='' && $_GET['product']!=0) echo "<input type='hidden' name='newproduct' value='".clean($_GET['product'])."'>";
					if(isset($_GET['form']   ) && $_GET['form']   !='' && $_GET['form']   !=0) echo "<input type='hidden' name='newform'    value='".clean($_GET['form']   )."'>";
				?>
			</tbody>
		</table>
	</form>
</div>

<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
			<form method="post">
				<div class="modal-header">
					<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
					<h4 class="modal-title" id="myModalLabel">Edit sub form</h4>
				</div>
				<div class="modal-body">
					<div class="form-group">
						<label for="subTest">Test</label>
						<?php
							$sql="
								Select
									dw_group.groupText,
									dw_test.testID,
									dw_test.testText,
									dw_test.testTextLab
								From
									dw_test Left Join
									dw_group
										On dw_test.testGroup = dw_group.groupID
								Where
									dw_group.groupActive = 1 And
									dw_test.testActive  = 1 And
									dw_test.testSite    = ? And
									dw_test.testCode    <> ''
								Order By
									dw_group.groupOrder,
									dw_test.testOrder
							";
							if(!$qryTest = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $test_sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
						?>
						<select class="form-control" name="subTest" id="subTest" >
							<?php
								$group = array();
								foreach($qryTest as $row){
									$group[$row['groupText']][] = $row;
								}
								foreach ($group as $key => $values) {
									echo "<optgroup label='".$key."'>\n";
									foreach ($values as $value) {
										echo "	<option value='".$value['testID']."'>";
										echo str_replace('&','&amp;', $value['testText']);
										if($debug) echo " [".$value['testID']."]";
										echo "</option>\n";
									}
									echo "</optgroup>\n";
								}
							?>
						</select>
					</div>
					<div class="form-group">
						<label for="subFreq">Frequency</label>
						<?php
							$sql="
								Select
									dw_frequency.freqID,
									dw_frequency.freqText
								From
									dw_frequency
								Where
									dw_frequency.freqSite = 0 Or
									dw_frequency.freqSite = ?
								Order By
									dw_frequency.freqOrder,
									dw_frequency.freqText
							";
							if(!$freqquery = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
						?>
						<select class="form-control" name="subFreq" id="subFreq" >
							<?php
								foreach($freqquery as $freqarray){
									echo "<option value='".$freqarray['freqID']."'>".$freqarray['freqText']."</option>";
								}
							?>
						</select>
					</div>
				</div>
				<div class="modal-footer">
					<input type="<?php if($debug) echo "text"; else echo "hidden"; ?>" name="subID" id="subID" value="">
					<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"><span class='glyphicon glyphicon-ok' aria-hidden='true'></span>&nbsp;Save</button>
				</div>
			</div>
		</form>
  </div>
</div>

<script src="js/submod.js?v=2.2"><!-- Include sub mod JS --></script>
<?php require "inc/footer.php"; ?>
