<?php
/**
 * Copyright (C) DairyWindow 2019
 * admin@dairywindow.nz
 */

	/* (C) DairyWindow 2012-2017 */
	
	function row($id, $label, $placeholder='', $type='text', $addon1='', $addon2='', $optional=FALSE){
		if($placeholder=='') $placeholder= $label;
		if($type=='email' && ($addon1=='' || $addon1==null)) $addon1='<span class="glyphicon glyphicon-envelope" aria-hidden="true"></span>';
		if(isset($_POST[$id]) && $_POST[$id]!="") $value = $_POST[$id];
		else $value = $_SESSION[$id];
		echo "<div class='row'>
			<div class='form-group'>
				<label for='".$id."' class='col-sm-2 control-label'>".$label."</label>
				<div class='col-sm-10'>";
					if((isset($addon1) && $addon1!='') || (isset($addon2) && $addon2!='')) echo "<div class='input-group'>";
						if(isset($addon1) && $addon1!='') echo "<div class='input-group-addon'>".$addon1."</div>";
						echo "<input type='".$type."' ";
						if($type=='number') echo "min='0' ";
						if($id=='ivp_limit') echo "step='0.01' ";
						echo "class='form-control' name='".$id."' id='".$id."' placeholder='".$placeholder."' value='".$value."'";
						if($optional==FALSE) echo " required";
						if($type=="file") echo " accept='.jpg, .jpeg, .png'";
						echo " >";
						if(isset($addon2) && $addon2!='') echo "<div class='input-group-addon'>".$addon2."</div>";
					if((isset($addon1) && $addon1!='') || (isset($addon2) && $addon2!='')) echo "</div>";
					echo "
				</div>
			</div>
		</div>";
		if($type=="file"){
			echo "
				<div class='row'>
					<div class='form-group'>
						<label class='col-sm-2 control-label'>Currently</label>
						<div class='col-sm-10'>
							<p class='form-control-static'><a href='images/".$_SESSION['userSite']."/".$value."' target='map'>".$value."</a></p>
						</div>
					</div>
				</div>
			";
		}
	}
	
	function double($label,
									$id1, $placeholder1='', $type1='text', $optional1=FALSE,
									$id2, $placeholder2='', $type2='text', $optional2=FALSE,
									$gps=FALSE
	){
		if($placeholder1=='') $placeholder1 = $label;
		if($placeholder2=='') $placeholder2 = $label;
		
		if(isset($_POST[$id1])) $value1 = $_POST[$id1];
		else $value1 = $_SESSION[$id1];
		
		if(isset($_POST[$id2])) $value2 = $_POST[$id2];
		else $value2 = $_SESSION[$id2];
		
		echo "<div class='row'>
			<div class='form-group'>
				<label for='".$id1."' class='col-sm-2 control-label'>".$label."</label>
				<div class='col-sm-5'>";
					echo "<input type='".$type1."' ";
						if($type1=='number'){
							if($gps){
								echo "min='-360' max='360' ";
							}else{
								echo "min='0' ";
							}
							if($gps) echo "step='0.00001' ";
							if($id1=='ivp_limit') echo "step='0.01' ";
						}
						echo "class='form-control' name='".$id1."' id='".$id1."' placeholder='".$placeholder1."' value='".$value1."'";
						if($optional1==FALSE) echo " required";
					echo " >
				</div>
				<div class='col-sm-5'>";
					echo "<input type='".$type2."' ";
						if($type2=='number'){
							if($gps){
								echo "min='-360' max='360' ";
							}else{
								echo "min='0' ";
							}
							if($gps) echo "step='0.00001' ";
							if($id2=='ivp_limit') echo "step='0.01' ";
						}
						echo "class='form-control' name='".$id2."' id='".$id2."' placeholder='".$placeholder2."' value='".$value2."'";
						if($optional2==FALSE) echo " required";
					echo " >
				</div>
			</div>
		</div>";
	}
	

	function slider($id, $label){ // http://www.seiyria.com/bootstrap-slider
		if(isset($_POST[$id])) $value = $_POST[$id];
		else $value = $_SESSION[$id];
		echo "<div class='row'>
			<div class='form-group'>
				<label for='".$id."' class='col-sm-2 control-label'>".$label."</label>
				<div class='col-sm-10'>
					<input id='".$id."' name='".$id."' type='text' data-slider-id='".$id."' data-slider-min='0' data-slider-max='6' data-slider-step='1' data-slider-value='".$value."' value='".$value."' required >
					<script>
						var slider = new Slider('#".$id."', {
							min: 0,
							max: 6,
							value: ".$value.",
							step: 1,
							tooltip: 'always'
						});
					</script>
				</div>
			</div>
		</div>";
	}
	
	function gap(){
		echo "<div class='row'>&nbsp;</div>";
	}
	
	function legend($id, $placeholder){
		if(isset($_POST[$id])) $value= $_POST[$id];
		else $value= $_SESSION[$id];
		echo "<legend><input type='text' class='form-control' name='".$id."' id='".$id."' placeholder='".$placeholder."' value='".$value."' ></legend>";
	}
	
	function bstoggle($id, $label, $addon2=''){
		
		if(isset($_POST[$id])) $value= $_POST[$id];
		else $value= $_SESSION[$id];
		
		echo "<div class='row'>
			<div class='form-group'>
				<label for='".$id."' class='col-sm-2 control-label'>".$label."</label>
				<div class='col-sm-10'>
					<input type='checkbox' data-toggle='toggle' id='".$id."' name='".$id."' data-onstyle='success' data-offstyle='default' data-on='Yes' data-off='No' value='1' >";
					if(isset($addon2) && $addon2!='') echo "&nbsp;<span class='text-muted'>".$addon2."</span>";
					echo "<input type='hidden' id='".$id."x' value='".$value."' >
					<script>
						$(function() {
							$('#".$id."').bootstrapToggle();
						})
						var ".$id."x = document.getElementById('".$id."x').value;
						var ".$id." = document.getElementById('".$id."');
						if(".$id."x.trim()=='1'){
							".$id.".checked = true;
							if(typeof $('#".$id."').bootstrapToggle=='function') $('#".$id."').bootstrapToggle('on');
						}else{
							".$id.".checked = false;
							if(typeof $('#".$id."').bootstrapToggle=='function') $('#".$id."').bootstrapToggle('off');
						}
					</script>
				</div>
			</div>
		</div>";
	}
	
	function dash($title, $session_value='', $colours=1){
		/*
			$colours = 1: normal
			$colours = 2: packing
		*/
		global $link;
		global $debug;
		
		$normal_colours  = array("#3366cc", "#dc3912", "#ff9900", "#109618", "#990099", "#0099c6", "#dd4477",
														 "#66aa00", "#b82e2e", "#316395", "#994499", "#22aa99", "#aaaa11", "#6633cc",
														 "#e67300", "#8b0707", "#329262", "#5574a6", "#3b3eac", "#b77322", "#16d620"); //from google charts (https://developers.google.com/chart/interactive/docs/gallery/piechart#exploding-a-slice)
		$packing_colours = array("#4285f4", "#71a4f7", "#a1c2fa", "#d0e1fc", "#db4437"); //from google charts
		$thiscolour = 0;
		
		echo "<div class='col-md-4'>
			<h4>".$title."</h4>";
			if(isset($session_value) && $session_value!=''){
				$sql="
					/* show items */
					Select
						dw_sn_field.fieldID,
						dw_sn_field.fieldTitle,
						dw_sn_page.pageText
					From
						dw_dash_settings Left Join
						dw_sn_field
							On dw_dash_settings.dashValue = dw_sn_field.fieldID Left Join
						dw_sn_page
							On dw_sn_field.fieldPage = dw_sn_page.pageID
					Where
						dw_dash_settings.dashSite = ? And
						dw_dash_settings.dashArea = ?
				";
				if(!$qry = mysqli_prepared_query($link, $sql, "ii", array($_SESSION['userSite'], $session_value), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				foreach($qry as $row){
					if($colours==2) $colour = $packing_colours[$thiscolour%count($packing_colours)];
					else $colour = $normal_colours[$thiscolour%count($normal_colours)];
					echo "<div class='col-sm-10' style='color:".$colour."'>".$row['pageText']." - ".$row['fieldTitle'];
					if($debug) echo " <small>[".$row['fieldID']."]</small>";
					echo "</div><div class='col-sm-2'><input class='btn btn-default' name='del_".$row['fieldID']."' type='submit' value='Del'></div>";
					$thiscolour++;
				}
				
				//add new item
				$sql="
					Select
						dw_sn_page.pageText,
						dw_sn_field.fieldID,
						dw_sn_field.fieldTitle
					From
						dw_sn_page Inner Join
						dw_sn_field
							On dw_sn_field.fieldPage = dw_sn_page.pageID
					Where
						dw_sn_page.pageSite = ? And
						dw_sn_page.pageActive = 1 And
						dw_sn_field.fieldID Not In (
							Select
								dw_sn_field.fieldID
							From
								dw_dash_settings Inner Join
								dw_sn_field
									On dw_dash_settings.dashValue = dw_sn_field.fieldID
							Where
								dw_dash_settings.dashSite = ? And
								dw_dash_settings.dashArea = ?
						) And
						dw_sn_field.fieldActive = 1 And
						(dw_sn_field.fieldType = 1 Or
						 dw_sn_field.fieldType = 4 Or
						 dw_sn_field.fieldType = 6 Or
						 dw_sn_field.fieldType = 7)
					Order By
						dw_sn_page.pageOrder,
						dw_sn_field.fieldOrder
				";
				if(!$qry = mysqli_prepared_query($link, $sql, "iii", array($_SESSION['userSite'], $_SESSION['userSite'], $session_value), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				if($colours==2) $colour = $packing_colours[$thiscolour%count($packing_colours)];
				else $colour = $normal_colours[$thiscolour%count($normal_colours)];
				echo "<div class='col-sm-10'>
					<select name='new_".$session_value."' id='new_".$session_value."' class='form-control' style='color:".$colour."'>
						<option value=''>Choose new</option>";
						foreach($qry as $row){
							$locgroup[$row['pageText']][] = $row;
						}
						foreach($locgroup as $key => $values) {
							echo "<optgroup label='".$key."'>";
							foreach($values as $value) {
								echo "<option value='".$value['fieldID']."' >".$value['fieldTitle'];
								if($debug) echo " [".$value['fieldID']."]";
								echo "</option>";
							}
							echo "</optgroup>";
						}
						echo "
					</select>
					<script>
						dropdown('#new_".$session_value."');
					</script>
				</div>
				<div class='col-sm-2'>
					<input class='btn btn-default' type='submit' value='Add'>
				</div>";
			}else{
				echo "<div class='col-sm-10' >
					<label for='show_fp' >Only show In Process or Final Product on dashboard?</label>
			    <input type='checkbox' data-toggle='toggle' id='show_fp' name='show_fp' data-onstyle='success' data-offstyle='default' data-on='Final Product only' data-off='Both IP and FP' value='1' >
				</div>";
			}
		echo "</div>";
	}
	
	require "inc/connect.php";
	
	if(isset($_POST['pdel']) && isset($_POST['packing_options_current'])){
		//delete (move right from packing_options_current to packing_options_avail)
		$sql="
			Select
				dw_settings.packing_options
			From
				dw_settings
			Where
				dw_settings.settingsID = ?
		";
		if(!$options_query = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		$row = $options_query[0];
		if($debug){
			echo "Currently: '".$row['packing_options']."'<br>";
			$removing = implode(',', $_POST['packing_options_current']);
			echo "Removing: '".$removing."'<br>";
		}
		$current = explode(',', $row['packing_options']); //convert string to array
		$packing_options = array_diff($current, $_POST['packing_options_current']); //remove p_o_c from current
		$finally = implode(',', $packing_options);
		if($debug) echo "Finally: '".$finally."'<br>";
		$sql="
			UPDATE dw_settings SET
				packing_options = ?
			WHERE settingsID = ?
		";
		if(!savesql($link, $sql, "si", array($finally, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}else{
		if(isset($_POST['padd']) && isset($_POST['packing_options_avail'])){
			//add (move left from packing_options_avail to packing_options_current)
			$packing_options = explode(',', $_SESSION['packing_options']);
			foreach($_POST['packing_options_avail'] as $packing_avail){
				$packing_options[] = $packing_avail; //add to array
			}
			//sort($packing_options);
			if($debug) print_r($packing_options);
			$packing_options_current = implode(',', $packing_options);
			if($debug) echo "<br>packing_options_current: '".$packing_options_current."'<br>";
			$sql="
				UPDATE dw_settings SET
					packing_options = ?
				WHERE settingsID = ?
			";
			if(!savesql($link, $sql, "si", array($packing_options_current, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		}
	}
	
	if(isset($_POST['sdel']) && isset($_POST['services_options_current'])){
		//delete (move right from services_options_current to services_options_avail)
		$sql="
			Select
				dw_settings.services_options
			From
				dw_settings
			Where
				dw_settings.settingsID = ?
		";
		if(!$options_query = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		$row = $options_query[0];
		if($debug){
			echo "Currently: '".$row['services_options']."'<br>";
			$removing = implode(',', $_POST['services_options_current']);
			echo "Removing: '".$removing."'<br>";
		}
		$current = explode(',', $row['services_options']); //convert string to array
		$services_options = array_diff($current, $_POST['services_options_current']); //remove s_o_c from current
		$finally = implode(',', $services_options);
		if($debug) echo "Finally: '".$finally."'<br>";
		$sql="
			UPDATE dw_settings SET
				services_options = ?
			WHERE settingsID  = ?
		";
		if(!savesql($link, $sql, "si", array($finally, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}else{
		if(isset($_POST['sadd']) && isset($_POST['services_options_avail'])){
			//add (move left from services_options_avail to services_options_current)
			$services_options = explode(',', $_SESSION['services_options']);
			foreach($_POST['services_options_avail'] as $services_avail){
				$services_options[] = $services_avail; //add to array
			}
			//sort($services_options);
			if($debug) print_r($services_options);
			$services_options_current = implode(',', $services_options);
			if($debug) echo "<br>services_options_current: '".$services_options_current."'<br>";
			$sql="
				UPDATE dw_settings SET
					services_options = ?
				WHERE settingsID  = ?
			";
			if(!savesql($link, $sql, "si", array($services_options_current, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		}
	}
	
	if(isset($_POST['thispage']) && $_POST['thispage']!=""){
		switch($_POST['thispage']){
			case 'general':
				$sql="
					UPDATE dw_settings SET
						comp_name_long = ?,
						website       = ?,
						admin_name    = ?,
						admin_email   = ?,
						comp_name     = ?,
						factory_reg   = ?,
						postal_addr1  = ?,
						postal_addr2  = ?,
						rival_name    = ?,
						cypherorbatch = ?,
						season_start  = ?
					WHERE settingsID = ?
				";
				if(!savesql($link, $sql, "sssssssssiii", array(
					$_POST['comp_name_long'],
					$_POST['website'],
					$_POST['admin_name'],
					$_POST['admin_email'],
					$_POST['comp_name'],
					$_POST['factory_reg'],
					$_POST['postal_addr1'],
					$_POST['postal_addr2'],
					$_POST['rival_name'],
					$_POST['cypherorbatch'],
					$_POST['season_start'],
					$_SESSION['userSite']
				), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				break;
				
			case 'dashboard':
				/*
					POST:array
					(
						[new_dash_rms_vol] => 53
						[new_dash_rms_age] => 
						[new_dash_evap_vol] => 
						[new_dash_dryer_tonnes] => 
						[new_dash_packing_tonnes] => 
						[thispage] => dashboard
						[destination] => dashboard
					)
				*/
				foreach($_POST as $key => $value){
					if($value != "" && $value != null){
						if($debug) echo $key.": ".$value."<br>\n";
						if(substr($key,0,4)=="new_"){
							//add in new value
							$sql="
								INSERT INTO dw_dash_settings (           dashSite  ,    dashArea   , dashValue)
								VALUES                       (               ?     ,        ?      ,     ?    )
							";
							if(!savesql($link, $sql, "iii",  array($_SESSION['userSite'], substr($key,4),    $value), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
						}
						if(substr($key,0,4)=="del_"){
							
							$parts = explode('_', $key);
							$key2 = str_replace('-','_', $parts[1]);
							
							if($debug){
								echo $key2."<br>\n";
							}
							
							$sql="
								DELETE FROM dw_dash_settings
								WHERE dashSite = ? AND dashValue = ?
							";
							if(!savesql($link, $sql, "ii", array($_SESSION['userSite'], $key2), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
							
						}
					}
				}
				break;
				
			case 'misc':
				
				//upload file
				if(isset($_FILES["site_map"]["name"])){
					$filename = basename($_FILES["site_map"]["name"]);
					$target_dir = "uploads/".$_SESSION['userSite']."/";
					$target_file = $target_dir . $filename;
					$uploadOk = 1;
					$imageFileType = pathinfo($target_file, PATHINFO_EXTENSION);
					// Check if image file is a actual image or fake image
					if(isset($_POST["submit"])) {
							$check = getimagesize($_FILES["site_map"]["tmp_name"]);
							if($check !== false) {
									//echo "File is an image - " . $check["mime"] . ".";
									$uploadOk = 1;
							} else {
									$message['type'] = "error";
									$message['text'] = "Your file is not an image. Allowed image types: .jpg, .png, .gif";
									$uploadOk = 0;
							}
					}
					// Check if file already exists
					/*
					if (file_exists($target_file)) {
							echo "Sorry, file already exists.";
							$uploadOk = 0;
					}
					*/
					// Check file size
					if ($_FILES["site_map"]["size"] > 500000) {
							$message['type'] = "error";
							$message['text'] = "Your file is too large";
							$uploadOk = 0;
					}
					// Allow certain file formats
					if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" && $imageFileType != "gif" ) {
							$message['type'] = "error";
							$message['text'] = "Your file is not an image. Allowed image types: .jpg, .png, .gif";
							$uploadOk = 0;
					}
					// Check if $uploadOk is set to 0 by an error
					if ($uploadOk == 0) {
							$message['type'] = "error";
					// if everything is ok, try to upload file
					} else {
							if (move_uploaded_file($_FILES["site_map"]["tmp_name"], $target_file)) {
									//echo "The file ". basename( $_FILES["site_map"]["name"]). " has been uploaded.";
							} else {
									$message['type'] = "error";
									$message['text'] = "The file could not be uploaded, please try again";
							}
					}
				}else{
					$filename = $_SESSION['site_map'];
				}
				
				$sql="
					UPDATE dw_settings SET
						default_location         = ?,
						virtuallab_user          = ?,
						number_trend_points      = ?,
						large_trend_width        = ?,
						small_trend_width        = ?,
						store_max_filesize       = ?,
						pilot_page_limit         = ?,
						summary_test_length      = ?,
						inspection_comment_limit = ?,
						ivp_test_length          = ?,
						ivp_positive_diff        = ?,
						ivp_max_results          = ?,
						ivp_limit                = ?,
						latitude                 = ?,
						longitude                = ?,
						site_map                 = ?,
						site_map_top             = ?,
						site_map_left            = ?,
						site_map_bottom          = ?,
						site_map_right           = ?
					WHERE settingsID           = ?
				";
				if(!savesql($link, $sql, "iiiiiiiiiiiiiddsddddi", array(
					$_POST['default_location'        ],
					$_POST['virtuallab_user'         ],
					$_POST['number_trend_points'     ],
					$_POST['large_trend_width'       ],
					$_POST['small_trend_width'       ],
					$_POST['store_max_filesize'      ],
					$_POST['pilot_page_limit'        ],
					$_POST['summary_test_length'     ],
					$_POST['inspection_comment_limit'],
					$_POST['ivp_test_length'         ],
					$_POST['ivp_positive_diff'       ],
					$_POST['ivp_max_results'         ],
					$_POST['ivp_limit'               ],
					$_POST['latitude'                ],
					$_POST['longitude'               ],
					$filename,
					$_POST['site_map_top'            ],
					$_POST['site_map_left'           ],
					$_POST['site_map_bottom'         ],
					$_POST['site_map_right'          ],
					$_SESSION['userSite'             ]
				), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				break;
				
			case 'options':
				//nothing
				break;
				
			case 'weeklyreport':
				$sql="
					UPDATE dw_settings SET
						weekly_fat_test = ?,
						weekly_pro_test = ?,
						weekly_moi_test = ?,
						weekly_snf_test = ?
					WHERE settingsID = ?
				";
				if(!savesql($link, $sql, "iiiii", array(
					$_POST['weekly_fat_test'],
					$_POST['weekly_pro_test'],
					$_POST['weekly_moi_test'],
					$_POST['weekly_snf_test']
				), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				break;
				
			case 'subforms':
				$sql="
					UPDATE dw_settings SET
						filename_prefix     = ?,
						csv_unique          = ?,
						subform_client      = ?,
						email_name          = ?,
						email_to            = ?,
						email_cc            = ?,
						email2_cc           = ?,
						ext_lab             = ?,
						contact_person      = ?,
						report_to           = ?,
						copies_to           = ?,
						phone               = ?,
						mobile              = ?,
						fax                 = ?,
						postal_addr1        = ?,
						postal_addr2        = ?,
						address_1           = ?,
						address_2           = ?,
						address_3           = ?,
						order_number        = ?,
						quote_number        = ?,
						market_access       = ?,
						subform_sampled_by1 = ?,
						subform_sampled_by2 = ?
					WHERE settingsID      = ?
				";
				if(!savesql($link, $sql, "sissssssssssssssssssssiii", array(
					$_POST['filename_prefix'],
					$_POST['csv_unique'] ? 1 : 0,
					$_POST['subform_client'],
					$_POST['email_name'],
					$_POST['email_to'],
					$_POST['email_cc'],
					$_POST['email2_cc'],
					$_POST['ext_lab'],
					$_POST['contact_person'],
					$_POST['report_to'],
					$_POST['copies_to'],
					$_POST['phone'],
					$_POST['mobile'],
					$_POST['fax'],
					$_POST['postal_addr1'],
					$_POST['postal_addr2'],
					$_POST['address_1'],
					$_POST['address_2'],
					$_POST['address_3'],
					$_POST['order_number'],
					$_POST['quote_number'],
					$_POST['market_access'],
					$_POST['subform_sampled_by1'],
					$_POST['subform_sampled_by2'],
					$_SESSION['userSite']
				), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				break;
				
			case 'coageneration':
				$sql="
					UPDATE dw_settings SET
						coagen_locked   = ?,
						coa_default_user = ?,
						group1_name     = ?,
						group1_value1   = ?,
						group1_value2   = ?,
						group1_value3   = ?,
						group1_value4   = ?,
						group2_name     = ?,
						group2_value1   = ?,
						group2_value2   = ?,
						group2_value3   = ?,
						group2_value4   = ?,
						group3_name     = ?,
						group3_value1   = ?,
						group3_value2   = ?,
						group3_value3   = ?,
						group3_value4   = ?,
						blurb           = ?
					WHERE settingsID  = ?
				";
				if(!savesql($link, $sql, "iissssssssssssssssi", array(
					isset($_POST['coagen_locked']) ? 1 : 0,
					$_POST['coa_default_user'],
					$_POST['group1_name'],
					$_POST['group1_value1'],
					$_POST['group1_value2'],
					$_POST['group1_value3'],
					$_POST['group1_value4'],
					$_POST['group2_name'],
					$_POST['group2_value1'],
					$_POST['group2_value2'],
					$_POST['group2_value3'],
					$_POST['group2_value4'],
					$_POST['group3_name'],
					$_POST['group3_value1'],
					$_POST['group3_value2'],
					$_POST['group3_value3'],
					$_POST['group3_value4'],
					$_POST['blurb'],
					$_SESSION['userSite']
				), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				break;
				
			case 'warehouse':
				$sql="
					UPDATE dw_settings SET
						transport_comp_name = ?,
						page_header_L1      = ?,
						page_header_R1      = ?,
						page_header_L2      = ?,
						page_header_R2      = ?,
						page_header_L3      = ?,
						page_header_R3      = ?
					WHERE settingsID      = ?
				";
				if(!savesql($link, $sql, "sssssssi", array(
					$_POST['transport_comp_name'],
					$_POST['page_header_L1'],
					$_POST['page_header_R1'],
					$_POST['page_header_L2'],
					$_POST['page_header_R2'],
					$_POST['page_header_L3'],
					$_POST['page_header_R3'],
					$_SESSION['userSite']
				), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				break;
				
			case 'images':
				//currently nothing, maybe update images later?
				break;
				
			default:
				reporterror('Error, unknown thispage ('.$_POST['thispage'].')', 'None', $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		}
	}
	
	$title = "Settings";
	require "inc/head.php";
	$menu = "settings";
	require "inc/menu.php";
	
	if($debug) showdebug();
?>

<div id="topDIV" >
	<h1 class="text-center"><?php echo $title; ?></h1>
</div>

<div class="container-fluid">
	<div class="col-md-12" role="main">
		<?php
			if(isset($_POST['destination']) && $_POST['destination']!='') $destination= $_POST['destination'];
			else $destination="general";
			require "inc/settings_tabs.php";
			echo "<form id='mainform' method='post' class='form-horizontal center-block' style='padding:auto'>";
				switch($destination){
					case 'general':
						echo "<input type='hidden' name='thispage' value='general'>";
						gap();
						//   id               label                  placeholder                      type
						row('comp_name_long','Company name'        ,'Official company name');
						row('website'       ,'Website'             ,'Website URL'                   ,'url');
						row('admin_name'    ,'Administrator name'  ,'Name of administrator');
						row('admin_email'   ,'Administrator email' ,'Email address of administrator','email');
						gap();
						row('comp_name'     ,'Site name');
						row('factory_reg'   ,'Factory registration','Official factory reg number');
						row('postal_addr1'  ,'Postal address 1');
						row('postal_addr2'  ,'Postal address 2');
						gap();
						row('rival_name'    ,'Other supply company','Name of other supply company');
						?>
						<div class='row'>
							<div class='form-group'>
								<label for='cypherorbatch' class='col-sm-2 control-label'>Cyphers or batches</label>
								<div class='col-sm-10'>
									<select name='cypherorbatch' id='cypherorbatch' class='form-control'>
										<?php
											if(isset($_POST['cypherorbatch'])) $cypherorbatch = $_POST['cypherorbatch'];
											else $cypherorbatch = $_SESSION['cypherorbatch'];
										?>
										<option value='0'<?php if($cypherorbatch=='0' || $cypherorbatch==0) echo " selected"; ?>>Cyphers only</option>
										<option value='1'<?php if($cypherorbatch=='1' || $cypherorbatch==1) echo " selected"; ?>>Batches only</option>
										<option value='2'<?php if($cypherorbatch=='2' || $cypherorbatch==2) echo " selected"; ?>>Both cyphers and batches</option>
									</select>
								</div>
							</div>
						</div>
						<div class='row'>
							<div class='form-group'>
								<label for='season_start' class='col-sm-2 control-label'>Season starts</label>
								<div class='col-sm-10'>
									<div class='input-group'>
										<div class='input-group-addon'>1st day of</div>
										<select name='season_start' id='season_start' class='form-control'>
											<?php
												if(isset($_POST['season_start'])) $season_start = $_POST['season_start'];
												else $season_start = $_SESSION['season_start'];
												$months = ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'];
												$month_number = 1;
												foreach($months as $month){
													echo "<option value='".$month_number."' ";
													if($season_start==$month_number) echo " selected";
													echo ">".$month."</option>";
													$month_number++;
												}
											?>
										</select>
									</div>
								</div>
							</div>
						</div>
						<?php
						break;
					case 'dashboard':
						/*
							[dash_rms_vol] => 168,169,170
							[dash_rms_age] => 196,197,198
							[dash_evap_vol] => 192,193,194
							[dash_dryer_tonnes] => 210
							[dash_packing_tonnes] => 228
						*/
						echo "<div class='row'>";
						dash('Incoming volume',1,1);
						dash('Incoming age',2,1);
						dash('Processed',3,1);
						echo "</div><hr><div class='row'>";
						dash('Dryer',4,2);
						dash('Packing',5,2);
						dash('Products made',null,2);
						echo "</div><input type='hidden' name='thispage' value='dashboard'>";
						break;
					case 'misc':
						echo "<input type='hidden' name='thispage' value='misc'>";
						gap();
						$sql="
							# get locations
							Select
								dw_locgroup.locGroupText,
								dw_location.locationID,
								dw_location.locationText,
								dw_location.locationFriendly
							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_locgroup.locGroupText,
								dw_location.locationOrder,
								dw_location.locationText
						";
						echo "<div class='row'>
							<div class='form-group'>
								<label for='default_location' class='col-sm-2 control-label'>Default location</label>
								<div class='col-sm-10'>";
									if(isset($_POST['default_location'])) $default_location = $_POST['default_location'];
									else $default_location = $_SESSION['default_location'];
									if(!$loc_query = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
									echo "<select id='default_location' name='default_location' class='form-control'>";
									foreach($loc_query as $row){
										$locgroup[$row['locGroupText']][] = $row;
									}
									foreach($locgroup as $key => $values) {
										echo "<optgroup label='".$key."'>";
										foreach($values as $value) {
											echo "<option value='".$value['locationID']."' ";
											if($default_location==$value['locationID']) echo "selected='selected' ";
											echo ">".$value['locationText'];
											if($debug) echo " [".$value['locationID']."]";
											if(isset($value['locationFriendly']) && $value['locationFriendly']!="") echo " (".$value['locationFriendly'].")";
											echo "</option>";
										}
										echo "</optgroup>";
									}
									echo "</select>
								</div>
							</div>
						</div>";

						echo "<div class='row'>
							<div class='form-group'>
								<label for='virtuallab_user' class='col-sm-2 control-label'>Results from ".$_SESSION['ext_lab']."</label>
								<div class='col-sm-10'>";
									if(isset($_POST['virtuallab_user'])) $virtuallab_user = $_POST['virtuallab_user'];
									else $virtuallab_user = $_SESSION['virtuallab_user'];
									$sql="# get users for this site
										Select
											userID
										From
											dw_auth
										Where
											userSite = ? And
											userActive = 1
										Order By
											userFirst
									";
									if(!$user_query = mysqli_prepared_query($auth_link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
									echo "<select name='virtuallab_user' id='virtuallab_user' class='form-control'>";
									foreach($user_query as $user_row){
										$sql = "# Get last name, etc
											Select
												userFirst,
												userLast,
												userTitle
											From
												dw_user
											Where
												userID = ? And
												userLevel <= ?
											Order By
												userFirst,
												userLast
										";
										if(!$user_query2 = mysqli_prepared_query($link, $sql, "ii", array($user_row['userID'], $_SESSION['results_results_add']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
										foreach($user_query2 as $user_row2){
											if(!empty($user_row2['userFirst'])){
												echo "<option value='".$user_row['userID']."'";
												if($virtuallab_user==$user_row['userID']) echo " selected";
												echo ">".$user_row2['userFirst']." ".$user_row2['userLast']." (".$user_row2['userTitle'].")</option>";
											}
										}
									}
									echo "</select>
								</div>
							</div>
						</div>";

						gap();
						//   id                         label                          placeholder        type    addon1 addon2
						row('small_trend_width'       ,'Default trend width'          ,'Trend width'     ,'number',''   ,'px wide');
						row('number_trend_points'     ,'Except if trend has more than','Trend points'    ,'number',''   ,'points');
						row('large_trend_width'       ,'Then the trend width is'      ,'Trend width'     ,'number',''   ,'px wide');
						
						gap();
						row('store_max_filesize'      ,'Maximum upload file size'    ,'Max filesize'    ,'number',''   ,'bytes');
						row('pilot_page_limit'        ,'Number of pilots to show'    ,'Pilots to show'  ,'number',''   ,'results per page');
						row('summary_test_length'     ,'Shorten test names to'       ,'Test length'     ,'number',''   ,'characters');
						row('inspection_comment_limit','Inspection comment limit'    ,'Inspection limit','number',''   ,'characters');
						gap();
						row('ivp_test_length'         ,'Shorten comparison tests to' ,'Test length'     ,'number',''   ,'characters');
						if(isset($_POST['ivp_positive_diff'])) $ivp_positive_diff = $_POST['ivp_positive_diff'];
						else $ivp_positive_diff = $_SESSION['ivp_positive_diff'];
						echo "<div class='row'>
							<div class='form-group'>
								<label for='ivp_positive_diff' class='col-sm-2 control-label'>Comparison difference</label>
								<div class='col-sm-10'>
									<select name='ivp_positive_diff' id='ivp_positive_diff' class='form-control'>
										<option value= '1'"; if($ivp_positive_diff=='1' || $ivp_positive_diff==1) echo " selected"; echo ">Convert negative difference to positive difference</option>
										<option value= '0'"; if($ivp_positive_diff=='0' || $ivp_positive_diff==0) echo " selected"; echo ">Show both negative and positive differences</option>
									</select>
								</div>
							</div>
						</div>";
						row('ivp_max_results'         ,'Number of comparisons'      ,'Max results'     ,'number',''   ,'per page');
						row('ivp_limit'               ,'Comparisons limit'          ,'Comparison limit','number',''   ,'% of lab value');
						gap();
						row('site_map'                ,'Site map'                   ,'Site map'        ,'file'  ,''   ,'', TRUE);
						double('Left top'    , 'site_map_left' , 'Left'    , 'number', TRUE, 'site_map_top'   , 'Top'      , 'number', TRUE, TRUE);
						double('Right bottom', 'site_map_right', 'Right'   , 'number', TRUE, 'site_map_bottom', 'Bottom'   , 'number', TRUE, TRUE);
						double('Center map'  , 'latitude'      , 'Latitude', 'number', TRUE, 'longitude'      , 'Longitude', 'number', TRUE, TRUE);
						//      label    , id1, placeholder1, type1, optional1, id2, placeholder2, type2, optional2, gps
						/*
						//set the lower and upper bounds of the center (has to be within the image)
						echo "
							<script>
								$('#latitude').attr({
									'min': $('#site_map_left').val(),
									'max': $('#site_map_right').val()
								});
								$('#longitude').attr({
									'min': $('#site_map_top').val(),
									'max': $('#site_map_bottom').val()
								});
							</script>
						";
						*/
						echo "
							<script>
								dropdown('#default_location');
								dropdown('#virtuallab_user');
							</script>
						";
						break;
					case 'weeklyreport':
						echo "<input type='hidden' name='thispage' value='weeklyreport'>";
						gap();
						$sql="
							# get tests
							Select
								dw_test.testID,
								dw_group.groupText,
								dw_test.testText
							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,
								dw_test.testText
						";
						?>
						<div class='row'>
							<div class='form-group'>
								<label for='weekly_fat_test' class='col-sm-2 control-label'>Test 1</label>
								<div class='col-sm-10'>
									<?php
										if(isset($_POST['weekly_fat_test'])) $weekly_fat_test = $_POST['weekly_fat_test'];
										else $weekly_fat_test = $_SESSION['weekly_fat_test'];
											
										if(!$test_query = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
										echo "<select id='weekly_fat_test' name='weekly_fat_test' class='form-control'>";
											$testgroup=array();
											foreach($test_query as $row){
												$testgroup[$row['groupText']][] = $row;
											}
											foreach($testgroup as $key => $values) {
												echo "<optgroup label='".$key."'>";
												foreach($values as $value) {
													echo "<option value='".$value['testID']."' ";
													if($weekly_fat_test==$value['testID']) echo "selected='selected' ";
													echo ">".$value['testText'];
													if($debug) echo " [".$value['testID']."]";
													echo "</option>";
												}
												echo "</optgroup>";
											}
										echo "</select>";
									?>
								</div>
							</div>
						</div>
						<div class='row'>
							<div class='form-group'>
								<label for='weekly_pro_test' class='col-sm-2 control-label'>Test 2</label>
								<div class='col-sm-10'>
									<select id='weekly_pro_test' name='weekly_pro_test' class='form-control'>
										<?php
											if(isset($_POST['weekly_pro_test'])) $weekly_pro_test = $_POST['weekly_pro_test'];
											else $weekly_pro_test = $_SESSION['weekly_pro_test'];
											
											foreach($testgroup as $key => $values) {
												echo "<optgroup label='".$key."'>";
												foreach($values as $value) {
													echo "<option value='".$value['testID']."' ";
													if($weekly_pro_test==$value['testID']) echo "selected='selected' ";
													echo ">".$value['testText'];
													if($debug) echo " [".$value['testID']."]";
													echo "</option>";
												}
												echo "</optgroup>";
											}
										?>
									</select>
								</div>
							</div>
						</div>
						<div class='row'>
							<div class='form-group'>
								<label for='weekly_moi_test' class='col-sm-2 control-label'>Test 3</label>
								<div class='col-sm-10'>
									<select id='weekly_moi_test' name='weekly_moi_test' class='form-control'>
										<?php
											if(isset($_POST['weekly_moi_test'])) $weekly_moi_test = $_POST['weekly_moi_test'];
											else $weekly_moi_test = $_SESSION['weekly_moi_test'];
											
											foreach($testgroup as $key => $values) {
												echo "<optgroup label='".$key."'>";
												foreach($values as $value) {
													echo "<option value='".$value['testID']."' ";
													if($weekly_moi_test==$value['testID']) echo "selected='selected' ";
													echo ">".$value['testText'];
													if($debug) echo " [".$value['testID']."]";
													echo "</option>";
												}
												echo "</optgroup>";
											}
										?>
									</select>
								</div>
							</div>
						</div>
						<div class='row'>
							<div class='form-group'>
								<label for='weekly_snf_test' class='col-sm-2 control-label'>Test 4</label>
								<div class='col-sm-10'>
									<select id='weekly_snf_test' name='weekly_snf_test' class='form-control'>
										<?php
											if(isset($_POST['weekly_snf_test'])) $weekly_snf_test = $_POST['weekly_snf_test'];
											else $weekly_snf_test = $_SESSION['weekly_snf_test'];
											
											foreach($testgroup as $key => $values) {
												echo "<optgroup label='".$key."'>";
												foreach($values as $value) {
													echo "<option value='".$value['testID']."' ";
													if($weekly_snf_test==$value['testID']) echo "selected='selected' ";
													echo ">".$value['testText'];
													if($debug) echo " [".$value['testID']."]";
													echo "</option>";
												}
												echo "</optgroup>";
											}
										?>
									</select>
								</div>
							</div>
						</div>
						<?php
						break;
					case 'subforms':
						echo "<input type='hidden' name='thispage' value='subforms'>";
						gap();
						switch($_SESSION['cypherorbatch']){
							case 0:
							case '0':
								$cyphertext = "cypher";
								break;
							case 0:
							case '0':
								$cyphertext = "batch";
								break;
							default:
								$cyphertext = "cypher/batch";
								break;
							
						}
						if(isset($_POST['csv_unique'])){
							if($_POST['csv_unique']==1 || $_POST['csv_unique']=='1'){
								row('filename_prefix','CSV filename prefix', 'pre-reg', 'text','', '-['.$cyphertext.']-[product]-[form]-XX.CSV');
							}else{
								row('filename_prefix','CSV filename prefix', 'pre-reg', 'text','', '-['.$cyphertext.']-[product]-[form].CSV'   );
							}
						}else{
							if($_SESSION['csv_unique']==1 || $_SESSION['csv_unique']=='1'){
								row('filename_prefix','CSV filename prefix', 'pre-reg', 'text','', '-['.$cyphertext.']-[product]-[form]-XX.CSV');
							}else{
								row('filename_prefix','CSV filename prefix', 'pre-reg', 'text','', '-['.$cyphertext.']-[product]-[form].CSV'   );
							}
						}
						bstoggle('csv_unique','Keep CSV filename unique','Setting this to Yes will add 2 unique digits to the end of the filename');
						row('subform_client' ,'Client code'       ,'Client code');
						gap();
						row('email_name'     ,'Email name (from)' ,'DairyWindow');
						row('ext_lab'        ,'Laboratory name'   ,'Name of testing lab');
						row('email_to'       ,'Email address (to)','Send email to'      ,'email');
						row('email_cc'       ,'Copy to'           ,'Copy to'            ,'email',null,null,true);
						row('email2_cc'      ,'And also'          ,'Copy to'            ,'email',null,null,true);
						gap();
						row('contact_person' ,'Contact person'    ,'Contact person name');
						row('report_to'      ,'Report results to' ,'Report to'          ,'email');
						row('copies_to'      ,'Copy results to'   ,'Copy to'            ,'email',null,null,true);
						row('phone'          ,'Phone number'      ,'Phone number'       ,'tel','<span class="glyphicon glyphicon-phone-alt" aria-hidden="true"></span>');
						row('mobile'         ,'Mobile number'     ,'Mobile number'      ,'tel','<span class="glyphicon glyphicon-phone" aria-hidden="true"></span>');
						row('fax'            ,'Fax number'        ,'Fax number'         ,'tel',null,null,true);
						gap();
						row('postal_addr1'   ,'Postal address 1');
						row('postal_addr2'   ,'Postal address 2');
						row('address_1'      ,'Physical address 1');
						row('address_2'      ,'Physical address 2');
						row('address_3'      ,'Physical address 3');
						row('order_number'   ,'Order number'      ,null                 ,null,null,null,true);
						echo "<div class='form-group'>
							<label class='col-sm-2 control-label'>&nbsp;</label>
							<div class='col-sm-10'>
								<p class='form-control-static'><a href='po.php'>Manage PO numbers</a></p>
							</div>
						</div>";
						row('quote_number'   ,'Quote number'      ,null                 ,null,null,null,true);
						row('market_access'  ,'Market access'     ,null                 ,null,null,null,true);
						
						echo "<div class='row'>
							<div class='form-group'>
								<label for='subform_sampledby1' class='col-sm-2 control-label'>Sampled by</label>
								<div class='col-sm-5'>
									<select name='subform_sampled_by1' id='subform_sampled_by1' class='form-control'>";
										$sql="
											Select
												dw_sn_page.pageText,
												dw_sn_field.fieldID,
												dw_sn_field.fieldTitle
											From
												dw_sn_field Inner Join
												dw_sn_page
													On dw_sn_field.fieldPage = dw_sn_page.pageID
											Where
												dw_sn_page.pageSite = ? And
												dw_sn_page.pageActive = 1 And (
													dw_sn_field.fieldType = 2 Or
													dw_sn_field.fieldType = 5
												) And dw_sn_field.fieldActive = 1
											Group By
												fieldID
											Order By
												dw_sn_page.pageOrder,
												dw_sn_field.fieldOrder
										";
										if(!$sampledby_query = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
										$page = array();
										foreach($sampledby_query as $row){
											$page[$row['pageText']][] = $row;
										}
										foreach ($page as $key => $values) {
											echo "<optgroup label='".$key."'>";
											foreach ($values as $value) {
												echo "<option value='".$value['fieldID']."'";
												if($_SESSION['subform_sampled_by1']==$value['fieldID']) echo " selected";
												echo ">".$value['pageText']." ".$value['fieldTitle']."</option>";
											}
											echo "</optgroup>";
										}
										echo "
									</select>
								</div>
								<div class='col-sm-5'>
									<select name='subform_sampled_by2' id='subform_sampled_by2' class='form-control'>
										<option value='0'>Nobody</option>";
										//if(!$sampledby_query = mysqli_query($link, $sql)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
										$page = array();
										foreach($sampledby_query as $row){
											$page[$row['pageText']][] = $row;
										}
										foreach ($page as $key => $values) {
											echo "<optgroup label='".$key."'>";
											foreach ($values as $value) {
												echo "<option value='".$value['fieldID']."'";
												if($_SESSION['subform_sampled_by2']==$value['fieldID']) echo " selected";
												echo ">".$value['fieldTitle']."</option>";
											}
											echo "</optgroup>";
										}
										echo "
									</select>
								</div>
							</div>
						</div>";
						
						?>
						<script>
							var obj = document.getElementById('subform_client');
							obj.onkeyup = function(){
								//alert('UP!');
								obj.value = obj.value.toUpperCase();
							};
							dropdown("#subform_sampled_by1");
							dropdown("#subform_sampled_by2");
						</script>
						<?php
						break;
					case 'coageneration':
						echo "<input type='hidden' name='thispage' value='coageneration'>";
						gap();
						bstoggle('coagen_locked','Require correct number of tests');

						echo "<div class='row'>
							<div class='form-group'>
								<label for='coa_default_user' class='col-sm-2 control-label'>Default COA signer</label>
								<div class='col-sm-10'>";
									if(isset($_POST['coa_default_user'])) $coa_default_user = $_POST['coa_default_user'];
									else $coa_default_user = $_SESSION['coa_default_user'];

									$sql="# get users from this site
										Select
											userID
										From
											dw_auth
										Where
											userSite = ? And
											userActive = 1
										Order By
											userFirst
									";
									if(!$user_query = mysqli_prepared_query($auth_link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
									echo "<select name='coa_default_user' id='coa_default_user' class='form-control'>";
										foreach($user_query as $user_row){

											$sql="# get users that can sign coas
												Select
													userID,
													userFirst,
													userLast,
													userTitle
												From
													dw_user
												Where
													userID = ? And
													userCOA = ?
												Order By
													userFirst,
													userLast
											";
											if($debug) echo "<br>";
											if(!$user_query2 = mysqli_prepared_query($link, $sql, "ii", array($user_query['userID'], 1), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
											if($debug) echo "<br>";
											foreach($user_query2 as $user_row2){
												if(!empty($user_row2['userFirst'])){
													echo "<option value='".$user_row2['userID']."'";
													if($coa_default_user==$user_row2['userID']) echo " selected";
													echo ">".$user_row2['userFirst']." ".$user_row2['userLast']." (".$user_row2['userTitle'].")</option>";
												}
											}
										}
									echo "</select>
								</div>
							</div>
						</div>";
						//   id              label                placeholder type addon1 addon2 optional
						row('group1_name'  ,'Group 1 button name',null,null,null,null,true);
						row('group1_value1','Value 1'            ,null,null,null,null,true);
						row('group1_value2','Value 2'            ,null,null,null,null,true);
						row('group1_value3','Value 3'            ,null,null,null,null,true);
						row('group1_value4','Value 4'            ,null,null,null,null,true);
						row('group2_name'  ,'Group 2 button name',null,null,null,null,true);
						row('group2_value1','Value 1'            ,null,null,null,null,true);
						row('group2_value2','Value 2'            ,null,null,null,null,true);
						row('group2_value3','Value 3'            ,null,null,null,null,true);
						row('group2_value4','Value 4'            ,null,null,null,null,true);
						row('group3_name'  ,'Group 3 button name',null,null,null,null,true);
						row('group3_value1','Value 1'            ,null,null,null,null,true);
						row('group3_value2','Value 2'            ,null,null,null,null,true);
						row('group3_value3','Value 3'            ,null,null,null,null,true);
						row('group3_value4','Value 4'            ,null,null,null,null,true);
						?>
							<div class='row'>
								<div class='form-group'>
									<label for='coa_default_user' class='col-sm-2 control-label'>Disclaimer</label>
									<div class='col-sm-10'>
										<textarea class="form-control textarea" name="blurb" id="blurb" rows="10" ><?php 
											if(isset($_POST['blurb'])) echo $_POST['blurb'];
											else echo $_SESSION['blurb'];
										 ?></textarea>
									</div>
								</div>
							</div>
							<script>
								dropdown('#coa_default_user');
							</script>
						<?php
						break;
					case 'warehouse':
						echo "<input type='hidden' name='thispage' value='warehouse'>";
						gap();
						?>
							<div class='row'>
								<div class='thumbnail'>
									<img alt='company logo' src='images/<?php echo $_SESSION['userSite']; ?>/transport.png' >
								</div>
							</div>
							<div class='row'>
								<div class='form-group'>
									<label for='transport_comp_name' class='col-sm-2 control-label'>Transport company name</label>
									<div class='col-sm-10'>
										<input type='text' class='form-control center-text' name='transport_comp_name' id='transport_comp_name' placeholder='Transport company' value='<?php 
											if(isset($_POST['transport_comp_name'])) echo $_POST['transport_comp_name'];
											else echo $_SESSION['transport_comp_name'];
										?>' >
									</div>
								</div>
							</div>
							<div class='row'>
								<div class='form-group'>
									<label for='page_header_L1' class='col-sm-2 control-label'>Line 1</label>
									<div class='col-sm-5'>
										<input type='text' class='form-control' name='page_header_L1' id='page_header_L1' placeholder='Line 1, left' value='<?php 
											if(isset($_POST['page_header_L1'])) echo $_POST['page_header_L1'];
											else echo $_SESSION['page_header_L1'];
										?>' >
									</div>
									<div class='col-sm-5'>
										<input type='text' class='form-control' name='page_header_R1' id='page_header_R1' placeholder='Line 1, right' value='<?php 
											if(isset($_POST['page_header_R1'])) echo $_POST['page_header_R1'];
											else echo $_SESSION['page_header_R1'];
										?>' >
									</div>
								</div>
							</div>
							<div class='row'>
								<div class='form-group'>
									<label for='page_header_L2' class='col-sm-2 control-label'>Line 2</label>
									<div class='col-sm-5'>
										<input type='text' class='form-control' name='page_header_L2' id='page_header_L2' placeholder='Line 2, left' value='<?php 
											if(isset($_POST['page_header_L2'])) echo $_POST['page_header_L2'];
											else echo $_SESSION['page_header_L2'];
										?>' >
									</div>
									<div class='col-sm-5'>
										<input type='text' class='form-control' name='page_header_R2' id='page_header_R2' placeholder='Line 2, right' value='<?php 
											if(isset($_POST['page_header_R2'])) echo $_POST['page_header_R2'];
											else echo $_SESSION['page_header_R2'];
										?>' >
									</div>
								</div>
							</div>
							<div class='row'>
								<div class='form-group'>
									<label for='page_header_L3' class='col-sm-2 control-label'>Line 3</label>
									<div class='col-sm-5'>
										<input type='text' class='form-control' name='page_header_L3' id='page_header_L3' placeholder='Line 3, left' value='<?php 
											if(isset($_POST['page_header_L3'])) echo $_POST['page_header_L3'];
											else echo $_SESSION['page_header_L3'];
										?>' >
									</div>
									<div class='col-sm-5'>
										<input type='text' class='form-control' name='page_header_R3' id='page_header_R3' placeholder='Line 3, right' value='<?php 
											if(isset($_POST['page_header_R3'])) echo $_POST['page_header_R3'];
											else echo $_SESSION['page_header_R3'];
										?>' >
									</div>
								</div>
							</div>
						<?php
						break;
					case "images":
						echo "<input type='hidden' name='thispage' value='images'>";
						gap();
						echo "
							<div class='row'>
								
								<div class='col-md-6'>
									<div class='thumbnail'>
										<img alt='company logo' src='images/".$_SESSION['userSite']."/company_logo.png' >
										<div class='caption'>
											<h3>Company logo</h3>
											<p>This image will be shown on the following webpage locations: <a href='prodrelease.php'>Product Release</a>, <a href='coagen.php'>Certificate of Analysis</a>, <a href='inspection.php'>Inspection</a>, <a href='results.php'>Results</a>. The image will be resized to fit correctly on each page. Must be in PNG format. Looks best with a transparent background for smooth integration</p>
											<!-- <p><a href='#' class='btn btn-default' role='button'>Choose new</a></p> -->
										</div>
									</div>
								</div>
								
								<div class='col-md-6'>
									<div class='thumbnail'>
										<img alt='company logo pdf' src='images/".$_SESSION['userSite']."/company_logo_pdf.jpg' >
										<div class='caption'>
											<h3>Company logo PDF</h3>
											<p>This image will be shown on the following printed PDF documents and reports: <a href='prodrelease.php'>Product Release</a>, <a href='coagen.php'>Certificate of Analysis</a>, <a href='inspection.php'>Inspection</a>, <a href='results.php'>Results</a>. The image will be resized to fit correctly on each page. Must be in JPG format with no alpha blending or transparency</p>
											<!-- <p><a href='#' class='btn btn-default' role='button'>Choose new</a></p> -->
										</div>
									</div>
								</div>
								
							</div>
						";
						break;
					case "shiftnotes":
						echo "<script>window.location.href = 'editsn.php';</script>";
						break;
					default:
						reporterror('Unknown destination value: '.$destination, '', $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
						break;
				}
			?>
			<div class="text-center">
				<br>
				<input type="hidden" name="destination" id="destination" value="<?php echo $destination; ?>" >
				<button type="submit" class="btn btn-default btn-primary" name="save" value="Save" ><span class="glyphicon glyphicon-save" aria-hidden="true"></span>&nbsp;Save</button>
				<br>
			</div>
		</form>
	</div>
</div>

<script src="js/editsettings.js?v=2.1"><!-- Include JS specific to editsettings.php (this file) --></script>
<script src="js/tinymce/tinymce.min.js?v=2.1"><!-- For editable textareas --></script>

<script>
	tinymce.init({
		selector: ".textarea",
		plugins: [
			"charmap contextmenu paste searchreplace"
		],
		menubar: false,
		toolbar: false,
		statusbar: false, resize: true, 
		relative_urls: false
	});
	$("#filename_prefix").addClass("filename_fix");
</script>
<?php require "inc/footer.php"; ?>