<?php
/**
 * Copyright (C) DairyWindow 2018
 * admin@dairywindow.nz
 */

	/* (C) DairyWindow 2012-2017 */

	require 'inc/connect.php';
	require 'inc/fade.php';
	require 'inc/numbertotext.php';
	require 'inc/texttonumber.php';

	if(isset($_POST['new_spec']) && $_POST['new_spec']!=''){
		//create new sub (and limit)

		$new_test     = clean($_POST['new_test'    ]);
		$new_spec     = clean($_POST['new_spec'    ]);
		$new_location = clean($_POST['new_location']);
		$new_dateFrom = clean($_POST['new_dateFrom']);
		$new_dateTo   = clean($_POST['new_dateTo'  ]);

		$sql = '# see if there is already one there (dont want to create any duplicates)
			Select
				limitID
			From
				dw_limit
			Where
				limitTest = ? And
				limitSpec = ? And
				limitLocation = ? And
				limitDateFrom = ? And
				limitDateTo = ?';
		if(!$num_sub = mysqli_prepared_query($link, $sql, 'iiiss', array($new_test, $new_spec, $new_location, $new_dateFrom, $new_dateTo), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		if(mysqli_prepared_num_rows($num_sub)>0){
			//one (or more) exists
			$message['type'] = 'error';
			$message['text'] = 'That record already exists. Please choose a different combination';
		}else{

			$limitTest       = clean($_POST['new_test'        ]);
			$limitSpec       = clean($_POST['new_spec'        ]);
			$limitLocation   = clean($_POST['new_location'    ]);
			$limitDateFrom   = empty($_POST['new_dateFrom'    ]) ? date('Y-m-d') : clean($_POST['new_dateFrom'    ]);
			$limitDateTo     = clean($_POST['new_dateTo'      ]);
			$limitLow        = empty($_POST['new_limitLow'    ]) ? null : floatval(clean($_POST['new_limitLow'    ]));
			$limitHigh       = empty($_POST['new_limitHigh'   ]) ? null : floatval(clean($_POST['new_limitHigh'   ]));
			$limitLowParent  = empty($_POST['new_limitLowAnz' ]) ? null : floatval(clean($_POST['new_limitLowAnz' ]));
			$limitHighParent = empty($_POST['new_limitHighAnz']) ? null : floatval(clean($_POST['new_limitHighAnz']));
			$limitLowAnz     = empty($_POST['new_limitLowAnz' ]) ? null : floatval(clean($_POST['new_limitLowAnz' ]));
			$limitHighAnz    = empty($_POST['new_limitHighAnz']) ? null : floatval(clean($_POST['new_limitHighAnz']));
			$limitLowDbp     = empty($_POST['new_limitLowDbp' ]) ? null : floatval(clean($_POST['new_limitLowDbp' ]));
			$limitHighDbp    = empty($_POST['new_limitHighDbp']) ? null : floatval(clean($_POST['new_limitHighDbp']));
			$limitLowGb      = empty($_POST['new_limitLowGb'  ]) ? null : floatval(clean($_POST['new_limitLowGb'  ]));
			$limitHighGb     = empty($_POST['new_limitHighGb' ]) ? null : floatval(clean($_POST['new_limitHighGb' ]));
			$limitModUser    = $_SESSION['userID'];

			$sql = '# insert new limit
				INSERT INTO dw_limit          ( limitTest,  limitSpec,  limitLocation,  limitDateFrom,  limitDateTo,  limitLow,  limitHigh,  limitLowParent,  limitHighParent,  limitLowAnz,  limitHighAnz,  limitLowDbp,  limitHighDbp,  limitLowGb,  limitHighGb,  limitModDate,  limitModUser)
				VALUES                        (      ?   ,       ?   ,       ?       ,       ?       ,       ?     ,       ?  ,       ?   ,       ?        ,       ?         ,       ?     ,       ?      ,       ?     ,       ?      ,      ?     ,       ?     ,      now()   ,       ?      )';
			$params =                       '      i           i           i               s               s             d          d           d                d                 d             d              d             d             d             d                            i       ';
			if(!savesql($link, $sql, $params, array($limitTest, $limitSpec, $limitLocation, $limitDateFrom, $limitDateTo, $limitLow, $limitHigh, $limitLowParent, $limitHighParent, $limitLowAnz, $limitHighAnz, $limitLowDbp, $limitHighDbp, $limitLowGb, $limitHighGb,                $limitModUser), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		}
	}else{
		if(isset($_POST['edit_id']) && $_POST['edit_id']!='' && $_POST['edit_id']!=null){
			//edit existing limits

			/*
			[edit_location] => 996
			[limitLow] => 0
			[limitHigh] => 0.5
			[edit_spec] => 176
			[edit_test] => 568
			[edit_reason] =>
			[edit_id] => 0
			*/

			$params = array(
				empty($_POST['limitDateFrom'  ]) ? date('Y-m-d') : clean($_POST['limitDateFrom']) ,
				empty($_POST['limitDateTo'    ]) ? date('Y-m-d', strtotime('10 years')) : clean($_POST['limitDateTo']),
				empty($_POST['limitLow'       ]) ?  0   :          clean($_POST['limitLow'       ]) ,
				empty($_POST['limitHigh'      ]) ?  0   : floatval(clean($_POST['limitHigh'      ])),
				empty($_POST['limitLowParent' ]) ? null : floatval(clean($_POST['limitLowParent' ])),
				empty($_POST['limitHighParent']) ? null : floatval(clean($_POST['limitHighParent'])),
				empty($_POST['limitLowAnz'    ]) ? null : floatval(clean($_POST['limitLowAnz'    ])),
				empty($_POST['limitHighAnz'   ]) ? null : floatval(clean($_POST['limitHighAnz'   ])),
				empty($_POST['limitLowDbp'    ]) ? null : floatval(clean($_POST['limitLowDbp'    ])),
				empty($_POST['limitHighDbp'   ]) ? null : floatval(clean($_POST['limitHighDbp'   ])),
				empty($_POST['limitLowGb'     ]) ? null : floatval(clean($_POST['limitLowGb'     ])),
				empty($_POST['limitHighGb'    ]) ? null : floatval(clean($_POST['limitHighGb'    ])),
				clean($_POST['edit_reason'    ]),

				clean($_SESSION['userID'      ]),
				clean($_POST['edit_id'        ])
			);

			$sql = '# update existing limit
				Update dw_limit Set
					limitDateFrom   = ?,
					limitDateTo     = ?,
					limitLow        = ?,
					limitHigh       = ?,
					limitLowParent  = ?,
					limitHighParent = ?,
					limitLowAnz     = ?,
					limitHighAnz    = ?,
					limitLowDbp     = ?,
					limitHighDbp    = ?,
					limitLowGb      = ?,
					limitHighGb     = ?,
					limitChangeCode = ?,
					limitModDate    = now(),
					limitModUser    = ?
				Where limitID     = ?';
			if(!savesql($link, $sql, 'ssdddddddddds ii', $params, __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		}else{
			if(isset($_POST['remove_sub_id']) && $_POST['remove_sub_id']!='' && $_POST['remove_sub_id']!=null){
				$sql = '# delete this limit
					Delete From dw_limit
					Where limitID = ?';
				if(!savesql($link, $sql, 'i', array(clean($_POST['remove_sub_id'])), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
			}
		}
	}

	$title = 'Limit';
	require 'inc/head.php';
	$menu = 'limit';
	require 'inc/menu.php';

	if($debug) showdebug();
?>

<div id="topDIV" >
	<h1 class="text-center">
		<?php echo $title; ?>
		<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#new_limit_form" ><span class='glyphicon glyphicon-plus' aria-hidden='true'></span>&nbsp;Add new</button>
		<input id="advanced" type="checkbox" data-on="Advanced" data-off="Standard" data-onstyle="success">
	</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 id='percent'>
		<div class='progress'><div class='progress-bar progress-bar-striped active' role='progressbar' aria-valuenow='0' aria-valuemin='0' aria-valuemax='100' style='width: 0%;'>0%</div></div>
	</div>
</div>

<div id="main" class="panel-group" role="tablist main" aria-multiselectable="true" style="display:none;">
	<?php
	$sql='# Get specs that have limits
		Select
			dw_spec.specID,
			dw_spec.specText,
			dw_spec.specShortDesc
		From
			dw_spec Inner Join
			dw_limit On dw_limit.limitSpec = dw_spec.specID
		Where
			dw_spec.specSite   = ? And
			dw_spec.specActive = 1 And
			dw_limit.limitID Is Not Null
		Group By
			dw_spec.specID
		Order By
			dw_spec.specStyle,
			dw_spec.specOrder,
			dw_spec.specText';
	if(!$spec_query = mysqli_prepared_query($link, $sql, 'i', array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	$spec_counter = 0; //only used to set first item to expand automatically
	$counter = 0; //used for loading (percentage)
	foreach($spec_query as $spec_row){
		?>
		<div class="panel panel-default" id="spec<?php echo $spec_row['specID']; ?>">
			<div class="panel-heading" role="tab" id="heading<?php echo $spec_row['specID']; ?>">
				<h4 class="panel-title">
					<a data-toggle="collapse" data-parent="#main" href="#collapse<?php echo $spec_row['specID']; ?>" aria-expanded="<?php if($spec_counter==0) echo "true"; else echo "false"; ?>" aria-controls="collapse<?php echo $spec_row['specID']; ?>">
						<?php
							echo $spec_row['specText'];
							if($spec_row['specText']!=$spec_row['specShortDesc']) echo ' <small> '.$spec_row['specShortDesc'].'</small>';
							if($debug) echo ' <small>['.$spec_row['specID'].']</small>';
						?>
					</a>
				</h4>
			</div>

			<div id="collapse<?php echo $spec_row['specID']; ?>" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading<?php echo $spec_row['specID']; ?>">
				<div class="panel-body">
					<div id="main<?php echo $spec_row['specID']; ?>" class="container-fluid"  >
						<div class="table-responsive" id="divtable<?php echo $spec_row['specID']; ?>"></div>
						<script>
							//get limits from ajax
							$.get( "ajax/get_limits_by_prod.php", {
								specText: '<?php echo $spec_row['specText']; ?>',
								specID: <?php echo $spec_row['specID']; ?>,
								debug: <?php echo $debug ? 'true' : 'false'; ?>
							}).done(function(data) {
								//do something with data
								$('#divtable<?php echo $spec_row['specID']; ?>').html(data);
							}).fail(function(){
								alert('Error getting data (are you logged in?)');
							});
						</script>
					</div>
				</div>
			</div>
		</div>
	<?php
		$totalrows = mysqli_prepared_num_rows($spec_query);
		if($totalrows < 1) $totalrows = 1;
	?>
	<script>
		var percentdiv = document.getElementById("percent");
		var percent = Math.ceil(<?php echo $counter/$totalrows; ?>*100);
		var text = "Loading";
		if(percent < 100) text = "Discombobulating results";
		if(percent <  90) text = "Launching satellites";
		if(percent <  80) text = "Kicking butt";
		if(percent <  70) text = "Hacking Google";
		if(percent <  60) text = "Programming hardware";
		if(percent <  50) text = "Compiling and demuxing";
		if(percent <  40) text = "Twiddling thumbs";
		if(percent <  30) text = "Boiling noodles";
		if(percent <  20) text = "Learning to code";
		if(percent <  10) text = "Feeding monkey";
		percentdiv.innerHTML = '<div class="progress"><div class="progress-bar progress-bar-striped active" role="progressbar" aria-valuenow="'+percent+'" aria-valuemin="0" aria-valuemax="100" style="width:'+percent+'%;">'+text+'...</div></div>';
	</script>
	<?php
		$spec_counter++;
		$counter++;
	}
	?>
</div>

<script src="js/limit.js?v=2.5">/* Include JS specific to limit.php (this file) */</script>

<div id="new_limit_form"  class="modal fade" tabindex="-1" role="dialog" aria-labelledby="new_limitLabel"  aria-hidden="true">
	<div class="modal-dialog">
		<div class="modal-content">
			<form class="container-fluid panel-info" 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_limitLabel">New limit details</h2>
				</div>
				<div class="modal-body">

					<div class="form-group">
						<label for="new_spec" >Product</label>
						<?php
							$sql='
								Select
									dw_spec.specID,
									dw_spec.specText,
									dw_spec.specShortDesc
								From
									dw_spec
								Where
									dw_spec.specSite = ? And
									dw_spec.specActive = 1
								Order By
								    dw_spec.specStyle,
									dw_spec.specOrder,
									dw_spec.specText
							';
							if(!$spec_query = mysqli_prepared_query($link, $sql, 'i', array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
							echo '<select name="new_spec" id="new_spec" class="form-control" >';
								foreach($spec_query as $specrow){
									echo '<option value="'.$specrow['specID'].'" ';
										if(isset($_POST['new_spec']) && $_POST['new_spec']==$specrow['specID']) echo 'selected ';
										echo '>'.$specrow['specText'].' ('.$specrow['specShortDesc'].')';
										if($debug) echo ' ['.$specrow['specID'].']';
									echo '</option>';
								}
							echo '</select>';
						?>
					</div><!-- /product -->

					<div class="form-group">
						<label for="new_test" >Test</label>
						<?php
							$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.testSite = ? And
									dw_test.testActive = 1
								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="new_test" id="new_test" 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>';
						?>
						<input type="hidden" id="limitFormat" value="">
					</div><!-- /test -->

					<div class='form-group'>
						<label for='new_location' >Location</label>
						<?php
							$loc_sql='
								Select
									dw_locgroup.locGroupText,
									dw_location.locationID,
									dw_location.locationText
								From
									dw_locgroup Right Join
									dw_location
										On dw_locgroup.locGroupID = dw_location.locationGroup
								Where
									dw_location.locationSite = ? And
									dw_location.locationActive = 1
								Order By
									dw_locgroup.locGroupOrder,
									dw_location.locationOrder,
									dw_location.locationText
							';
							if(!$loc_query = mysqli_prepared_query($link, $loc_sql, 'i', array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $loc_sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
							echo '<select name="new_location" id="new_location" class="form-control" >';
								$group = array();
								foreach($loc_query as $row){
									$group[$row['locGroupText']][] = $row;
								}
								foreach ($group as $key => $values) {
									echo '<optgroup label="'.$key.'">';
									foreach ($values as $value) {
										echo '<option value="'.$value['locationID'].'"';
											if($_SESSION['default_location']==$value['locationID']) echo ' selected';
											echo '>'.$value['locationText'];
											if($debug) echo ' ['.$value['locationID'].']';
										echo '</option>';
									}
									echo '</optgroup>';
								}
							echo '</select>';
						?>
					</div><!-- /group -->

					<div class="form-group">
						<label for="new_limitDate" >Effective date range</label>
						<div id="limitsdate" class="row">
							<div class="col-md-6">
								<input type="date" class="form-control" id="new_dateFrom" name="new_dateFrom" required value="<?php echo date('Y-m-d'); ?>" >
							</div>
							<div class="col-md-6">
								<input type="date" class="form-control" id="new_dateTo"   name="new_dateTo"   required value="<?php echo date('Y-m-d', strtotime('10 years')); ?>" >
							</div>
						</div>
					</div><!-- /date -->

					<div class="form-group">
						<label for="new_limitLow" ><?php echo $_SESSION['comp_name']; ?> limit</label>
						<div id="limits" class="row">
							<div class="col-md-6">
								<input type="number" class="form-control" id="new_limitLow"  name="new_limitLow"  step="0.00001" value="0" placeholder="0">
							</div>
							<div class="col-md-6">
								<input type="number" class="form-control" id="new_limitHigh" name="new_limitHigh" step="0.00001" required >
							</div>
						</div>
					</div><!-- /limit -->

					<div id="new_advanced" style="display:none;">
						<div class="form-group">
							<label for="new_limitLowParent" ><?php echo empty($_SESSION['parent']) ? 'Parent' : $_SESSION['parent']; ?> limit</label>
							<div id="limitsParent" class="row">
								<div class="col-md-6">
									<input type="number" class="form-control" id="new_limitLowParent"  name="new_limitLowParent"  step="0.00001" >
								</div>
								<div class="col-md-6">
									<input type="number" class="form-control" id="new_limitHighParent" name="new_limitHighParent" step="0.00001" >
								</div>
							</div>
						</div><!-- /parent -->
						<div class="form-group">
							<label for="new_limitLowAnz" >A/NZ limit</label>
							<div id="limitsAnz" class="row">
								<div class="col-md-6">
									<input type="number" class="form-control" id="new_limitLowAnz"  name="new_limitLowAnz"  step="0.00001" >
								</div>
								<div class="col-md-6">
									<input type="number" class="form-control" id="new_limitHighAnz" name="new_limitHighAnz" step="0.00001" >
								</div>
							</div>
						</div><!-- /ANZ -->
						<div class="form-group">
							<label for="new_limitLowDbp" >DBP 60B limit</label>
							<div id="limitsDbp" class="row">
								<div class="col-md-6">
									<input type="number" class="form-control" id="new_limitLowDbp"  name="new_limitLowDbp"  step="0.00001" >
								</div>
								<div class="col-md-6">
									<input type="number" class="form-control" id="new_limitHighDbp" name="new_limitHighDbp" step="0.00001" >
								</div>
							</div>
						</div><!-- /DBP -->
						<div class="form-group">
							<label for="new_limitLowGb" >GB limit</label>
							<div id="limitsGb" class="row">
								<div class="col-md-6">
									<input type="number" class="form-control" id="new_limitLowGb"  name="new_limitLowGb"  step="0.00001" >
								</div>
								<div class="col-md-6">
									<input type="number" class="form-control" id="new_limitHighGb" name="new_limitHighGb" step="0.00001" >
								</div>
							</div>
						</div><!-- /GB -->
					</div><!-- /advanced -->

				</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="button" class="btn btn-primary" id="new_limit_button" onclick="please_wait('new_limit_button');"><span class='glyphicon glyphicon-ok' aria-hidden='true'></span>&nbsp;Add</button>
				</div>
			</form>
		</div>
	</div>
</div>

<div id="edit_limit_form" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="edit_limitLabel" aria-hidden="true">
	<div class="modal-dialog">
		<div class="modal-content">
			<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="edit_limitLabel">Edit limit details</h2>
			</div>

			<form class="form-horizontal" method="post">
				<div class="modal-body">

					<div class="form-group row">
						<label class="control-label col-md-3" for="limitSpec">Product</label>
						<div class="col-md-9">
							<p class="form-control-static" id="limitSpec"></p>
						</div>
					</div><!-- /product -->
					<div class="form-group row">
						<label class="control-label col-md-3" for="limitTest">Test</label>
						<div class="col-md-9">
							<p class="form-control-static" id="limitTest"></p>
						</div>
					</div><!-- /test -->
					<span class="hidden" id="limitFormat"></span>
					<div class="form-group row">
						<label class="control-label col-md-3" for="limitUnits">Units</label>
						<div class="col-md-9">
							<p class="form-control-static" id="limitUnits"></p>
						</div>
					</div><!-- /units -->
					<div class="form-group row">
						<label class="control-label col-md-3" for="limitLocation">Location</label>
						<div class="col-md-9">
							<p class="form-control-static" id="limitLocation"></p>
						</div>
					</div><!-- /location -->

					<div class="form-group row">
						<label class="control-label col-md-3" for="limitDateFrom" style="padding-top:0">Date range</label>
						<div id="limitDate" class="col-md-9 row">
							<div class="col-md-6" style="padding-right:0">
								<input type="date" class="form-control" id="limitDateFrom" name="limitDateFrom" required >
							</div>
							<div class="col-md-6" style="padding-right:0">
								<input type="date" class="form-control" id="limitDateTo"   name="limitDateTo"   required >
							</div>
						</div>
					</div><!-- /date -->

					<div class="form-group row">
						<label for="limitLow" class="col-md-3 control-label" style="padding-top:0"><?php echo $_SESSION['comp_name']; ?> limit</label>
						<div class="row col-md-9">
							<div class="col-md-6" style="padding-right:0" id="input_low">
								<input type="number" class="form-control" id="limitLow" name="limitLow" placeholder="0.00" onchange="update('edit_limit_reason', 'Q4');">
							</div>
							<div class="col-md-6" style="padding-right:0" id="input_high">
								<input type="number" class="form-control" id="limitHigh" name="limitHigh" required onchange="update('edit_limit_reason', 'Q5');">
							</div>
						</div>
					</div><!-- /limit -->

					<div id="edit_advanced" style="display:none;">

						<div class="form-group row">
							<label for="limitLowParent" class="col-md-3 control-label" style="padding-top:0"><?php echo empty($_SESSION['parent']) ? 'Parent' : $_SESSION['parent']; ?> limit</label>
							<div class="row col-md-9">
								<div class="col-md-6" style="padding-right:0" id="input_low_parent">
									<input type="number" class="form-control" id="limitLowParent" name="limitLowParent" >
								</div>
								<div class="col-md-6" style="padding-right:0" id="input_high_parent">
									<input type="number" class="form-control" id="limitHighParent" name="limitHighParent" >
								</div>
							</div>
						</div><!-- /parent -->

						<div class="form-group row">
							<label for="limitLowAnz" class="col-md-3 control-label" style="padding-top:0">A/NZ limit</label>
							<div class="row col-md-9">
								<div class="col-md-6" style="padding-right:0" id="input_low_anz">
									<input type="number" class="form-control" id="limitLowAnz" name="limitLowAnz" >
								</div>
								<div class="col-md-6" style="padding-right:0" id="input_high_anz">
									<input type="number" class="form-control" id="limitHighAnz" name="limitHighAnz" >
								</div>
							</div>
						</div><!-- /anz -->

						<div class="form-group row">
							<label for="limitLowDbp" class="col-md-3 control-label" style="padding-top:0">DBP 60B limit</label>
							<div class="row col-md-9">
								<div class="col-md-6" style="padding-right:0" id="input_low_dbp">
									<input type="number" class="form-control" id="limitLowDbp" name="limitLowDbp" >
								</div>
								<div class="col-md-6" style="padding-right:0" id="input_high_dbp">
									<input type="number" class="form-control" id="limitHighDbp" name="limitHighDbp" >
								</div>
							</div>
						</div><!-- /dbp -->

						<div class="form-group row">
							<label for="limitLowGb" class="col-md-3 control-label" style="padding-top:0">GB limit</label>
							<div class="row col-md-9">
								<div class="col-md-6" style="padding-right:0" id="input_low_gb">
									<input type="number" class="form-control" id="limitLowGb" name="limitLowGb" >
								</div>
								<div class="col-md-6" style="padding-right:0" id="input_high_gb">
									<input type="number" class="form-control" id="limitHighGb" name="limitHighGb" >
								</div>
							</div>
						</div><!-- /gb -->

					</div>

					<input type="hidden" id="edit_spec" name="edit_spec">
					<input type="hidden" id="edit_test" name="edit_test">
					<input type="hidden" id="edit_limit_reason" name="edit_reason">
					<input type="hidden" id="edit_id" name="edit_id" required >
				</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="button" class="btn btn-primary" id="edit_limit_button" ><span class='glyphicon glyphicon-ok' aria-hidden='true'></span>&nbsp;Update</button>
				</div>
			</form>
		</div>
	</div>
</div>

<div id="remove_sub_form" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="remove_subLabel" aria-hidden="true">
	<!-- spec.js: update_remove_edit(limitid, subid, showloc) -->
	<div class="modal-dialog">
		<div class="modal-content">
			<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="remove_subLabel">Remove from limits?</h2>
			</div>

			<form class="form-horizontal" method="post">
				<div class="modal-body">
					<div class="form-group">
						<label class="col-md-3 control-label">Product</label>
						<div class="col-md-9">
							<p class="form-control-static" id="removeSpec"></p>
						</div>
					</div>
					<div class="form-group">
						<label class="col-md-3 control-label">Test</label>
						<div class="col-md-9">
							<p class="form-control-static" id="removeTest"></p>
						</div>
					</div>
					<div class="form-group">
						<label class="col-md-3 control-label">Location</label>
						<div class="col-md-9">
							<p class="form-control-static" id="removeLocation"></p>
						</div>
					</div>
					<div class="form-group">
						<label class="col-md-3 control-label">Date range</label>
						<div class="col-md-9">
							<p class="form-control-static" id="removeDate"></p>
						</div>
					</div>
					<div class="form-group">
						<label class="col-md-3 control-label">Limits</label>
						<div class="col-md-9">
							<p class="form-control-static" id="removeLimits"></p>
						</div>
					</div>

					<input type="<?php if($debug) echo "text"; else echo "hidden"; ?>" id="remove_sub_id" name="remove_sub_id">
				</div>
				<div class="modal-footer">
					<button type="button" class="btn btn-default" data-dismiss="modal">No</button>
					<button type="submit" class="btn btn-primary" id="remove_sub_button" onclick="please_wait('remove_sub_button');">Yes</button>
				</div>
			</form>
		</div>
	</div>
</div>

<?php
	if(!empty($_GET['s'])){
		//show the right spec
		?>
		<script>
			$(function(){
				$("#spec<?php echo $_GET['s']; ?>").collapse('show');
			});
		</script>
		<?php
	}

	if(!empty($_GET['l'])){
		$sql='# see if it actually exists
			Select
				limitID
			From
				dw_limit
			Where
				limitID = ?';
		if(!$qrylimitid = mysqli_prepared_query($link, $sql, 'i', array(clean($_GET['l'])), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		if(mysqli_prepared_num_rows($qrylimitid)==1){
			?>
				<script>
					$(function() {
						$("#edit_limit_form").modal("show");
						setTimeout(function () {
							update_limit_edit(<?php echo clean($_GET['l']).', '.clean($_GET['l']).', '.($debug ? '1' : '0'); ?>);
						}, 1000);
					});
				</script>
			<?php
		}
	}
	require 'inc/footer.php';
?>