<?php
	/* (C) DairyWindow 2012-2017 */
	
	require "inc/connect.php";
	
	$title = "Calc check";
	require "inc/head.php";
	$menu = "calc_check";
	require "inc/menu.php";
	
	if($debug) showdebug();
	
?>
	
	<div id="topDIV" class="page-header">
		<h1 class="text-center"><?php echo $title; ?></h1>
	</div>
	
	<div id="main" class="container" >
		<form class="form-horizontal" method="post">
			<div class="form-group">
				<label for="result1" class="col-sm-2 control-label">Result 1</label>
				<div class="col-sm-10">
					<input type="text" class="form-control" name="result1" placeholder="Result 1"<?php if(isset($_POST['result1'])) echo " value='".$_POST['result1']."'"; ?> >
				</div>
			</div>
			<div class="form-group">
				<label for="result2" class="col-sm-2 control-label">Result 2</label>
				<div class="col-sm-10">
					<input type="text" class="form-control" name="result2" placeholder="Result 2"<?php if(isset($_POST['result2'])) echo " value='".$_POST['result2']."'"; ?> >
				</div>
			</div>
			<div class="form-group">
				<label for="result3" class="col-sm-2 control-label">Result 3</label>
				<div class="col-sm-10">
					<input type="text" class="form-control" name="result3" placeholder="Result 3"<?php if(isset($_POST['result3'])) echo " value='".$_POST['result3']."'"; ?> >
				</div>
			</div>
			<div class="form-group">
				<label for="result4" class="col-sm-2 control-label">Result 4</label>
				<div class="col-sm-10">
					<input type="text" class="form-control" name="result4" placeholder="Result 4"<?php if(isset($_POST['result4'])) echo " value='".$_POST['result4']."'"; ?> >
				</div>
			</div>
			<div class="form-group">
				<label for="result5" class="col-sm-2 control-label">Result 5</label>
				<div class="col-sm-10">
					<input type="text" class="form-control" name="result5" placeholder="Result 5"<?php if(isset($_POST['result5'])) echo " value='".$_POST['result5']."'"; ?> >
				</div>
			</div>
			<div class="form-group">
				<label for="resultc" class="col-sm-2 control-label">Result 6</label>
				<div class="col-sm-10">
					<input type="text" class="form-control" name="resultc" placeholder="Result 6"<?php if(isset($_POST['resultc'])) echo " value='".$_POST['resultc']."'"; ?> >
				</div>
			</div>
			<div class="form-group">
				<label for="test" class="col-sm-2 control-label">Test</label>
				<div class="col-sm-10">
					<?php
						$test_sql="
							Select
								dw_test.testID,
								dw_group.groupText,
								dw_test.testText,
								dw_test.testCalc
							From
								dw_group Left Join
								dw_test
									On dw_test.testGroup = dw_group.groupID
							Where
								dw_test.testSite = ? And
								dw_test.testActive = 1
							Order By
								dw_group.groupOrder,
								dw_test.testOrder,
								dw_test.testText
						";
						if(!$qryTest = mysqli_prepared_query($link, $test_sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $test_sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
					?>
					<select class='form-control' name='test' id='test'>
						<?php
							$group = array();
							//while ($row = mysqli_fetch_assoc($qryTest)) {
							foreach($qryTest as $row){
								$group[$row['groupText']][] = $row;
							}
							unset($row);
							unset($qryTest);
							foreach ($group as $key => $values) {
								echo "<optgroup label='".$key."'>";
								foreach ($values as $value) {
									echo "<option value='".$value['testID']."'";
									if(isset($_POST['test']) && $_POST['test']==$value['testID']) echo " selected";
									echo ">";
									echo str_replace('&','&amp;', $value['testText']);
									if($debug) echo " [".$value['testID']."]";
									echo "</option>";
								}
								unset($value);
								echo "</optgroup>";
							}
							unset($group);
							unset($key);
							unset($values);
						?>
					</select>
				</div>
			</div>
			<div class="form-group">
				<div class="col-sm-offset-2 col-sm-10">
					<button type="submit" class="btn btn-default btn-primary">Check</button>
				</div>
			</div>
		</form>
		<?php
			if(isset($_POST['test'])){
				require "inc/numbertotext.php";
				require "inc/texttonumber.php";
				
				$sql="
					# get format and rounding of selected test
					Select
						dw_test.testFormat,
						dw_format.formatText,
						dw_test.testRound
					From
						dw_format Right Join
						dw_test
							On dw_format.formatID = dw_test.testFormat
					Where
						dw_test.testID = ?
				";
				if(!$qt=mysqli_prepared_query($link, $sql,"i",array($_POST['test']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				$ta = $qt[0];
				
				$sumresults=0;
				$numresults=0;
				echo "<div class='table-responsive'><table class='table table-bordered'>";
				$format=explode(' ', $ta['formatText']);
				echo "<tr><td>Format of results are</td><td>".$ta['testFormat']." (".$format[0].")</td></tr>";
				if(isset($_POST['result1']) && $_POST['result1']!="" && $_POST['result1']!=null){
					echo "<tr><td>Numerical result 1</td><td>".texttonumber($_POST['result1'], $ta['testFormat'])."</td></tr>";
					$numresults++;
					$sumresults+=texttonumber($_POST['result1'], $ta['testFormat']);
				}
				if(isset($_POST['result2']) && $_POST['result2']!="" && $_POST['result2']!=null){
					echo "<tr><td>Numerical result 2</td><td>".texttonumber($_POST['result2'], $ta['testFormat'])."</td></tr>";
					$numresults++;
					$sumresults+=texttonumber($_POST['result2'], $ta['testFormat']);
				}
				if(isset($_POST['result3']) && $_POST['result3']!="" && $_POST['result3']!=null){
					echo "<tr><td>Numerical result 3</td><td>".texttonumber($_POST['result3'], $ta['testFormat'])."</td></tr>";
					$numresults++;
					$sumresults+=texttonumber($_POST['result3'], $ta['testFormat']);
				}
				if(isset($_POST['result4']) && $_POST['result4']!="" && $_POST['result4']!=null){
					echo "<tr><td>Numerical result 4</td><td>".texttonumber($_POST['result4'], $ta['testFormat'])."</td></tr>";
					$numresults++;
					$sumresults+=texttonumber($_POST['result4'], $ta['testFormat']);
				}
				if(isset($_POST['result5']) && $_POST['result5']!="" && $_POST['result5']!=null){
					echo "<tr><td>Numerical result 5</td><td>".texttonumber($_POST['result5'], $ta['testFormat'])."</td></tr>";
					$numresults++;
					$sumresults+=texttonumber($_POST['result5'], $ta['testFormat']);
				}
				if(isset($_POST['resultc']) && $_POST['resultc']!="" && $_POST['resultc']!=null){
					echo "<tr><td>Numerical result 6</td><td>".texttonumber($_POST['result6'], $ta['testFormat'])."</td></tr>";
					$numresults++;
					$sumresults+=texttonumber($_POST['resultc'], $ta['testFormat']);
				}
				echo "<tr><td>Sum of all results is</td><td>".$sumresults."</td></tr>";
				echo "<tr><td>Number of results</td><td>".$numresults."</td></tr>";
				if($numresults==0) $average=0;
				else $average = $sumresults/$numresults;
				echo "<tr><td>Average</td><td>".$average."</td></tr>";
				
				if($ta['testFormat']==1){

					//copied from inc/numbertotext.php
					$tmp_average = number_format(($average*10),1);																																			//Round result to one decimal place
					$remainder = floatval($average*10)-floatval($tmp_average);																								    					//Get value on RIGHT side of decimal point
					if($remainder<0.01 && $remainder>=0.000000005 && $average<=11){
						// More than 50% of the results have a less than sign
						if($average>0.18 && $average<0.19 && $remainder>0.003 && $remainder<0.004) $lessthan = false;                             //Changed 5/2/2018 Insol Index (0.2,0.15,0.2) was showing <1.83
						else $lessthan = true;                                                                                                    //If the difference between the rounded result and the actual result is greater than 0.1, (and also if the result is less than 100) then add a < sign. See texttonumber, which adds 0.000000001 to results that have a less than sign
					}else{
						if($remainder==0 && $average==1) $lessthan = true;
						else $lessthan = false;
					}

					echo "<tr><td>Remainder calc</td><td>".($average*10)." - ".($tmp_average)."</td></tr>";

					if($remainder<0.0001) echo "<tr><td>Remainder</td><td>".number_format($remainder,10)."</td></tr>";
					else echo "<tr><td>Remainder</td><td>".$remainder."</td></tr>";

					echo "<tr><td>Do >50% have a less than sign?</td><td>";
					if($lessthan) echo "Yes";
					else echo "No";
					echo "</td></tr>";
				}
				
				echo "<tr><td>Rounding results to</td><td>".$ta['testRound']." dp</td></tr>";
				echo "<tr style='font-weight:bold;'><td>Final displayed average</td><td>".numbertotext($average, $ta['testFormat'], $ta['testRound'])."</td></tr>";
				echo "</table></div>";
			}
		?>
	</div>
<script>
	dropdown("#test");
</script>
<?php require "inc/footer.php"; ?>