<?php
	/* (C) DairyWindow 2012-2017 */
	
	require "inc/connect.php";
	require "inc/fade.php";
	
	if(isset($_POST['remove_coaid']) && $_POST['remove_coaid']!=""){
		
		$coa_id = clean($_POST['remove_coaid']);
		
		$sql="
			DELETE FROM dw_coa
			WHERE coaID=?
		";
		if(!savesql($link, $sql, "i", array($coa_id), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		
		$testname = clean($_POST['remove_testname']);
		$specname = clean($_POST['remove_specname']);
		
	}else{
		if(isset($_POST['new_spec']) && $_POST['new_spec']!="" && $_POST['new_spec']!=null && $_POST['new_spec']!=0 && $_POST['new_spec']!='0'){
			if(isset($_POST['new_test']) && $_POST['new_test']!="" && $_POST['new_test']!=null && $_POST['new_test']!=0 && $_POST['new_test']!='0'){
				//edit existing test
					
				//get values
				$new_test = clean($_POST['new_test']);
				$new_spec = clean($_POST['new_spec']);
				
				$sql="
					# see if coa already exists
					Select
						dw_test.testText,
						dw_spec.specText
					From
						dw_spec Right Join
						(dw_test Right Join
						dw_coa
							On dw_test.testID = dw_coa.coaTest)
							On dw_spec.specID = dw_coa.coaSpec
					Where
						dw_coa.coaTest = ? And
						dw_coa.coaSpec = ?
					Limit 1
				";
				if(!$select_query = mysqli_prepared_query($link, $sql, "ii", array($new_test, $new_spec), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				
				if(mysqli_prepared_num_rows($select_query)==0){ //does not already exist
					$sql="
						# insert new coa
						INSERT INTO dw_coa          ( coaSpec ,  coaTest ,      coaModUser   , coaModDate)
						VALUES                      (    ?    ,     ?    ,         ?         ,    now()  )
					";
					if(!savesql($link, $sql, "iii", array($new_spec, $new_test, $_SESSION['userID']           ), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
					
				}else{
					//already exists
					$data = $select_query[0]; //assuming there is exactly one
					$message['type'] = "error";
					$message['text'] = $data['testText']." already exists on the ".$data['specText']." COA";
				}
			}
		}
	}
	
	$title = "Tests on COA";
	require "inc/head.php";
	$menu = "editcoa";
	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_test_form" onclick="make_awesome();"><span class='glyphicon glyphicon-plus' aria-hidden='true'></span>&nbsp;Add new</button>
	</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="panel-group" role="tablist" style="display:none;" >
	<?php
	$sql="
		# main
		Select
			dw_spec.specID,
			dw_spec.specText,
			dw_spec.specShortDesc
		From
			dw_spec Right Join
			(dw_group Right Join
			(dw_test Right Join
			dw_coa
				On dw_test.testID = dw_coa.coaTest)
				On dw_group.groupID = dw_test.testGroup)
				On dw_spec.specID = dw_coa.coaSpec
		Where
			dw_spec.specSite = ? And
			dw_test.testSite = ? And
			dw_test.testID Is Not Null
		Group By
			dw_spec.specID
		Order By
			dw_spec.specOrder,
			dw_spec.specOrder
	";
	if(!$spec_query = mysqli_prepared_query($link, $sql, "ii", array($_SESSION['userSite'], $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	
	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="false" aria-controls="collapse<?php echo $spec_row['specID']; ?>">
						<?php
							echo $spec_row['specText'];
							if($debug) echo " <small>[".$spec_row['specID']."]</small>";
							echo ": ".$spec_row['specShortDesc']; ?>
					</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']; ?>">
							<table class="table table-hover" id="table<?php echo $spec_row['specID']; ?>">
								<thead>
									<tr id="table_head<?php echo $spec_row['specID']; ?>" style="background-color:white;color:inherit;white-space:nowrap;">
										<th class="text-center th_buttons" id="th_buttons<?php echo $spec_row['specID']; ?>">&nbsp;</th>
										<th class="text-center th_group"   id="th_group<?php   echo $spec_row['specID']; ?>">Group</th>
										<th class="text-center th_test"    id="th_test<?php    echo $spec_row['specID']; ?>">Test name</th>
										<th class="text-center th_testCOA" id="th_testCOA<?php echo $spec_row['specID']; ?>">Shown as</th>
										<th class="text-center th_stdev"   id="th_stdev<?php   echo $spec_row['specID']; ?>">Std Dev</th>
										<th style="display:none;"          id="th_coaid<?php   echo $spec_row['specID']; ?>"></th>
										<th style="display:none;"          id="th_test2<?php   echo $spec_row['specID']; ?>"></th>
										<th style="display:none;"          id="th_spec<?php    echo $spec_row['specID']; ?>"></th>
										<?php if($_SESSION['userLevel']==1 || $_SESSION['userLevel']=="1"){ ?>
											<th class="text-center th_mod" id="th_mod<?php     echo $spec_row['specID']; ?>">Modified by</th>
										<?php } ?>
									</tr>
								</thead>
								<tbody>
									<?php
										$test_sql="
											# sql for main table
											Select
												dw_coa.coaID,
												dw_group.groupText,
												dw_test.testID,
												dw_test.testText,
												dw_test.testTextCOA,
												dw_test.testStdev,
												dw_user.userFirst,
												dw_user.userLast,
												dw_coa.coaModDate,
												dw_change.changeText
											From
												dw_user Right Join
												(dw_change Right Join
												(dw_group Right Join
												(dw_test Right Join
												dw_coa
													On dw_test.testID = dw_coa.coaTest)
													On dw_group.groupID = dw_test.testGroup)
													On dw_change.changeID = dw_coa.coaChangeCode)
													On dw_user.userID = dw_coa.coaModUser
											Where
												dw_coa.coaSpec = ? And
												dw_test.testSite = ? And
												dw_test.testID Is Not Null
											Order By
												dw_group.groupOrder,
												dw_group.groupText,
												dw_test.testOrder,
												dw_test.testText
										";
										if(!$test_query = mysqli_prepared_query($link, $test_sql, "ii", array($spec_row['specID'], $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $test_sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
										foreach($test_query as $test_row){
											?>
												<tr class="text-nowrap" id="test_<?php echo $test_row['coaID']; ?>">
													<td class="text-center th_buttons" id="td_buttons_<?php echo $test_row['coaID']; ?>" >
														<button type="button" class="btn btn-xs btn-default" data-toggle="modal" data-target="#edit_test_form" onclick="update_coa_edit(<?php echo $test_row['coaID']; ?>, <?php if($debug) echo "1"; else echo "0"; ?>);">
															<span class="glyphicon glyphicon-trash" aria-hidden="true"></span>
															<span class="sr-only">Remove test</span>
															<span class="hidden-xs"> Remove test</span>
														</button>
														<form method="get" action="test.php" style="display:inline;">
															<input type="hidden" name="t" value="<?php echo $test_row['testID']; ?>" >
															<button type="submit" class="btn btn-xs">
																<span class="glyphicon glyphicon-pencil" aria-hidden="true"></span> 
																<span class="sr-only">Edit test</span>
																<span class="hidden-xs"> Edit test</span>
															</button>
														</form>
													</td>
													<td class="text-center th_group"   id="td_group_<?php   echo $test_row['coaID']; ?>" ><?php echo $test_row['groupText']; ?></td>
													<td class="text-center th_test"    id="td_test_<?php    echo $test_row['coaID']; ?>" ><?php echo fade($test_row['testText'],20, $bgcolour, $fgcolour); if($debug) echo " <small>[".$test_row['testID']."]</small>"; ?></td>
													<td class="text-center th_testCOA" id="td_testCOA_<?php echo $test_row['coaID']; ?>" ><?php echo fade($test_row['testTextCOA'],20, $bgcolour, $fgcolour); ?></td>
													<td class="text-center th_stdev"   id="td_stdev_<?php   echo $test_row['coaID']; ?>" ><?php if($test_row['testStdev']==1) echo "<span class='glyphicon glyphicon-ok' aria-hidden='true'></span>"; ?></td>
													<td style="display:none;"          id="td_coaid_<?php   echo $test_row['coaID']; ?>" ><?php echo $test_row['coaID']; ?></td>
													<td style="display:none;"          id="td_test2_<?php   echo $test_row['coaID']; ?>" ><?php echo $test_row['testText']; ?></td>
													<td style="display:none;"          id="td_spec_<?php    echo $test_row['coaID']; ?>" ><?php echo $spec_row['specText']; ?></td>
													<?php
														if($_SESSION['userLevel']==1 || $_SESSION['userLevel']=="1"){
															$fullname = $test_row['userFirst']." ".$test_row['userLast'][0];
														?>
														<td class="text-center td_mod" id="td_mod_<?php echo $test_row['coaID']; ?>" title="<?php echo $test_row['changeText']; ?>" ><?php echo $fullname." ".date('j/n/y',strtotime($test_row['coaModDate'])); ?></td>
													<?php } ?>
												</tr>
											<?php
										}
									?>
								</tbody>
							</table>
						</div>
					</div>
				</div>
			</div>
		</div>
	<?php
	}
	?>
</div>

<script src="js/editcoa.js?v=2.1">/* Include JS specific to test.php (this file) */</script>

<div id="new_test_form" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="new_testLabel" 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_testLabel">Add test to COA</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.specActive = 1 And
									dw_spec.specSite = ?
								Order By
									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__);
						?>
						<select name="new_spec" id="new_spec" class="form-control" >		
							<?php
								foreach($spec_query as $specrow){
									echo "<option value='".$specrow['specID']."'>".$specrow['specText'];
									if($debug) echo " [".$specrow['specID']."]";
									echo ": ".$specrow['specShortDesc']."</option>";
								}
							?>
						</select>
					</div>
					<div class="form-group">
						<label for="new_test" >Test</label>
						<?php
							$sql="
								Select
									dw_group.groupText,
									dw_test.testID,
									dw_test.testText,
									dw_test.testCalc
								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_group.groupText,
									dw_test.testOrder,
									dw_test.testText
							";
							if(!$qryTest = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
						?>
						<select name="new_test" id="new_test" class="form-control" >
							<?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($value['testCalc']>=1) echo " x";
										if($debug) echo " [".$value['testID']."]";
										echo "</option>\n";
									}
									echo "</optgroup>\n";
								}
							?>
						</select>
					</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_test_button" onclick="please_wait('new_test_button');"><span class='glyphicon glyphicon-ok' aria-hidden='true'></span>&nbsp;Add</button>
				</div>
			</form>
		</div>
	</div>
</div>

<div id="edit_test_form" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="edit_testLabel" 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_testLabel">Are you sure?</h2>
			</div>
			<form class="container-fluid panel-info" method="post" style="padding:0;">
				<input type="hidden" name="remove_coaid" id="remove_coaid" >
				<input type="hidden" name="remove_testname" id="remove_testname" >
				<input type="hidden" name="remove_specname" id="remove_specname" >
				<div class="modal-body">
					<div class="form-group" id="edit_test_modal_body">
						Do you really want to <strong>remove</strong> this test?
					</div>
				</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" onclick="please_wait('remove');">Yes</button>
				</div>
			</form>
		</div>
	</div>
</div>

<?php
	if(isset($_GET['t']) && $_GET['t']!="" && $_GET['t']!=null){
		$sql="
			# see if it actualy exists
			Select
				dw_test.testID
			From
				dw_test
			Where
				dw_test.testSite = ? And
				dw_test.testID = ?
		";
		if(!$qrytestid = mysqli_prepared_query($link, $sql, "ii", array($_SESSION['userSite'], $_GET['t']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		if(mysqli_prepared_num_rows($qrytestid)==1){
			echo "
				<script>
					$('#edit_test_form').modal('show');
					update_test_edit(".clean($_GET['t']).", ".($debug ? "1" : "0").");
				</script>
			";
		}
	}
	require "inc/footer.php";
?>