<?php

/**
 * Copyright (C) DairyWindow 2018
 * admin@dairywindow.nz
 */

require 'inc/connect.php';

$title = 'Edit Shift Notes';
require 'inc/head.php';
$menu = 'editshiftnotes';
require 'inc/menu.php';
require_once 'shiftnotes_constants.php';

$pageOrder = 0;

if (!function_exists('mysqli_prepared_num_rows')) require 'inc/mysqli_prepared_num_rows.php';

if (isset($_POST['pageup'])) {
	if (isset($_POST['pageid']) && $_POST['pageid'] != "" && $_POST['pageid'] != null) {
		$pageid    = clean($_POST['pageid']);
		$pagetext  = clean($_POST['pageText']);
		$pageorder = clean($_POST['pageorder']);

		/*
				at 5, want to move to 4
				get 4 (pageorder-1), move to 5 (pageorder)
				get this one and move to 4
			*/

		$sql = '# get one above, move down
				Update dw_sn_page Set
					pageOrder = ?
				Where
					pageOrder = ? And
					pageSite  = ?';
		if (!savesql($link, $sql, 'iii', array($pageorder, ($pageorder - 1), $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);

		$newpageorder = $pageorder - 1;
		if ($newpageorder < 1) $newpageorder = 1;
		$sql = '# move the one we want up
				Update dw_sn_page Set
					pageText    = ?,
					pageOrder   = ?,
					pageModUser = ?,
					pageModDate = now()
				Where pageID  = ?';
		if (!savesql($link, $sql, 'siii', array($pagetext, $newpageorder, $_SESSION['userID'], $pageid), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}
}

if (isset($_POST['pagedown'])) {
	if (isset($_POST['pageid']) && $_POST['pageid'] != "" && $_POST['pageid'] != null) {
		$pageid    = clean($_POST['pageid']);
		$pagetext  = clean($_POST['pageText']);
		$pageorder = clean($_POST['pageorder']);

		/*
				at 5, want to move to 6
				get one at 6, move to 5
				get this one and move to 6
			*/

		$sql = '# get one below, move up (to current pos)
				Update dw_sn_page Set
					pageOrder = ?
				Where
					pageOrder = ? And
					pageSite  = ?';
		if (!savesql($link, $sql, 'iii', array($pageorder, ($pageorder + 1), $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);

		$sql = '# move the one we want down
				Update dw_sn_page Set
					pageText    = ?,
					pageOrder   = ?,
					pageModUser = ?,
					pageModDate = now()
				Where pageID  = ?';
		if (!savesql($link, $sql, 'siii', array($pagetext, ($pageorder + 1), $_SESSION['userID'], $pageid), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}
}

if (isset($_POST['pagedelete'])) {
	//currently no way of re-enabling a 'deleted' page, has to be done manually by dba
	if (isset($_POST['pageid']) && $_POST['pageid'] != "" && $_POST['pageid'] != null) {
		$pageid = clean($_POST['pageid']);
		$sql = '# delete page
				Update dw_sn_page Set
					pageActive  = 0,
					pageModUser = ?,
					pageModDate = now()
				Where pageID  = ?';
		if (!savesql($link, $sql, 'ii', array($_SESSION['userID'], $pageid), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}
}

if (isset($_POST['pagesave'])) {
	if (
		isset($_POST['pageid']) && $_POST['pageid'] != "" && $_POST['pageid'] != null &&
		isset($_POST['pageText']) && $_POST['pageText'] != "" && $_POST['pageText'] != null
	) { // Try and stop idiots
		$pageid   = clean($_POST['pageid']);
		$pagetext = clean($_POST['pageText']);
		$sql = '# save page details
				Update dw_sn_page Set
					pageText    = ?,
					pageModUser = ?,
					pageModDate = now()
				Where pageID  = ?';
		if (!savesql($link, $sql, 'sii', array($pagetext, $_SESSION['userID'], $pageid), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}
}

if (isset($_POST['pageadd'])) {
	if (isset($_POST['pageText']) && $_POST['pageText'] != "" && $_POST['pageText'] != null) {
		$pagetext  = clean($_POST['pageText']);
		$pageorder = clean($_POST['pageorder']);
		if ($pageorder == '' || $pageorder == null || $pageorder == 0) $pageorder = 1;
		$sql = '# create a new page
				Insert into dw_sn_page        ( pageText,        pageSite      ,  pageOrder,      pageModUser   , pageActive, pageModDate)
				Values                        (     ?   ,            ?         ,      ?    ,           ?        ,     ?     ,    now()   )';
		$params =                       '     s                i                i                i              i                   ';
		if (!savesql($link, $sql, $params, array($pagetext, $_SESSION['userSite'], $pageorder, $_SESSION['userID'],     1), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}
}

if (isset($_POST['up'])) {
	if (isset($_POST['fieldid']) && $_POST['fieldid'] != '' && $_POST['fieldid'] != null) {
		$fieldid    = clean($_POST['fieldid']);
		$fieldpage  = clean($_POST['fieldpage']);
		$fieldorder = clean($_POST['fieldorder']);
		$xtitle     = clean($_POST['title']);
		$type       = clean($_POST['type']);

		if (isset($_POST['dp'])) $dp        = clean($_POST['dp']);
		else $dp        =  0;
		if (isset($_POST['extra'])) $extra     = clean($_POST['extra']);
		else $extra     = '';
		if (isset($_POST['fieldSum1'])) $fieldsum1 = clean($_POST['fieldSum1']);
		else $fieldsum1 =  0;
		if (isset($_POST['operator'])) $operator  = clean($_POST['operator']);
		else $operator  = '+';
		if (isset($_POST['fieldSum2'])) $fieldsum2 = clean($_POST['fieldSum2']);
		else $fieldsum2 =  0;
		if (isset($_POST['fieldShow']) && ($_POST['fieldShow'] == "on" || $_POST['fieldShow'] == 1)) $fieldshow = 1;
		else $fieldshow =  0;
		if (isset($_POST['fieldlist'])) $fieldlist = clean($_POST['fieldlist']);
		else $fieldlist =  0;

		/*
				at 5, want to move to 4
				get 4 (fieldorder-1), move to 5 (fieldorder)
				get this one and move to 4
			*/

		$sql = '# get one above, move down
				Update dw_sn_field Set
					fieldOrder = ?
				Where
					fieldOrder = ? And
					fieldPage  = ?';
		if (!savesql($link, $sql, 'iii', array($fieldorder, ($fieldorder - 1), $fieldpage), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);

		$newfieldorder = $fieldorder - 1;
		if ($newfieldorder < 1) $newfieldorder = 1;
		$sql = '# move the one we want up
				Update dw_sn_field Set
					fieldTitle    = ?,
					fieldType     = ?,
					fieldDP       = ?,
					fieldExtra    = ?,
					fieldOrder    = ?,
					fieldSum1     = ?,
					fieldOperator = ?,
					fieldSum2     = ?,
					fieldShow     = ?,
					fieldList     = ?,
					fieldModUser  = ?,
					fieldModDate  = now()
				Where fieldID   = ?';
		if (!savesql($link, $sql, 'siisiisiiiii', array(
			$xtitle,
			$type,
			$dp,
			$extra,
			$newfieldorder,
			$fieldsum1,
			$operator,
			$fieldsum2,
			$fieldshow,
			$fieldlist,
			$_SESSION['userID'],

			$fieldid
		), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}
}

if (isset($_POST['down'])) {
	if (isset($_POST['fieldid']) && $_POST['fieldid'] != '' && $_POST['fieldid'] != null) {
		$fieldid    = clean($_POST['fieldid']);
		$fieldpage  = clean($_POST['fieldpage']);
		$fieldorder = clean($_POST['fieldorder']);
		$xtitle     = clean($_POST['title']);
		$type       = clean($_POST['type']);

		if (isset($_POST['dp'])) $dp        = clean($_POST['dp']);
		else $dp        =  0;
		if (isset($_POST['extra'])) $extra     = clean($_POST['extra']);
		else $extra     = '';
		if (isset($_POST['fieldSum1'])) $fieldsum1 = clean($_POST['fieldSum1']);
		else $fieldsum1 =  0;
		if (isset($_POST['operator'])) $operator  = clean($_POST['operator']);
		else $operator  = '+';
		if (isset($_POST['fieldSum2'])) $fieldsum2 = clean($_POST['fieldSum2']);
		else $fieldsum2 =  0;
		if (isset($_POST['fieldShow']) && ($_POST['fieldShow'] == "on" || $_POST['fieldShow'] == 1)) $fieldshow = 1;
		else $fieldshow =  0;
		if (isset($_POST['fieldlist'])) $fieldlist = clean($_POST['fieldlist']);
		else $fieldlist =  0;

		/*
				at 5, want to move to 6
				get 6 (fieldorder+1), move to 5 (fieldorder)
				get this one and move to 6
			*/

		$sql = '# get one below, move up
				Update dw_sn_field Set
					fieldOrder = ?
				Where
					fieldOrder = ? And
					fieldPage  = ?';
		if (!savesql($link, $sql, 'iii', array($fieldorder, ($fieldorder + 1), $fieldpage), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);

		$sql = '# move the one we want down
				Update dw_sn_field Set
					fieldTitle    = ?,
					fieldType     = ?,
					fieldDP       = ?,
					fieldExtra    = ?,
					fieldOrder    = ?,
					fieldSum1     = ?,
					fieldOperator = ?,
					fieldSum2     = ?,
					fieldShow     = ?,
					fieldList     = ?,
					fieldModUser  = ?,
					fieldModDate  = now()
				Where fieldID   = ?';
		if (!savesql($link, $sql, 'siisiisiiiii', array(
			$xtitle,
			$type,
			$dp,
			$extra,
			($fieldorder + 1),
			$fieldsum1,
			$operator,
			$fieldsum2,
			$fieldshow,
			$fieldlist,
			$_SESSION['userID'],

			$fieldid
		), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}
}

if (isset($_POST['delete'])) {
	if (isset($_POST['fieldid']) && $_POST['fieldid'] != "" && $_POST['fieldid'] != null) {
		$fieldid = clean($_POST['fieldid']);
		$sql = '# delete the field
				Update dw_sn_field Set
					fieldActive  = 0,
					fieldOrder   = 0,
					fieldModUser = ?,
					fieldModDate = now()
				Where fieldID  = ?';
		if (!savesql($link, $sql, 'ii', array($_SESSION['userID'], $fieldid), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}
}

if (isset($_POST['save'])) {
	if (
		isset($_POST['title']) && $_POST['title'] != '' && $_POST['title'] != null &&
		isset($_POST['fieldid']) && $_POST['fieldid'] != '' && $_POST['fieldid'] != null
	) {
		$fieldid = clean($_POST['fieldid']);
		$xtitle  = clean($_POST['title']);
		$type    = clean($_POST['type']);
		if (isset($_POST['dp'])) $dp        = clean($_POST['dp']);
		else $dp        = 0;
		if (isset($_POST['extra'])) $extra     = clean($_POST['extra']);
		else $extra     = '';
		if (isset($_POST['fieldSum1'])) $fieldsum1 = clean($_POST['fieldSum1']);
		else $fieldsum1 =  0;
		if (isset($_POST['operator'])) $operator  = clean($_POST['operator']);
		else $operator  = '+';
		if (isset($_POST['fieldSum2'])) $fieldsum2 = clean($_POST['fieldSum2']);
		else $fieldsum2 =  0;
		if (isset($_POST['fieldShow']) && ($_POST['fieldShow'] == 'on' || $_POST['fieldShow'] == 1)) $fieldshow = 1;
		else $fieldshow =  0;
		if (isset($_POST['fieldlist'])) $fieldlist = clean($_POST['fieldlist']);
		else $fieldlist =  0;
		if (isset($_POST['readonly']) && ($_POST['readonly'] == 'on' || $_POST['readonly'] == 1)) $readonly  = 1;
		else $readonly  =  0;

		if (isset($_POST['tag']) && $_POST['tag'] != '' && $_POST['tag'] != null) $tag = $_POST['tag']; //dont use clean() because it will convert m3 into m³
		else $tag = '';
		if (isset($_POST['min']) && $_POST['min'] != '' && $_POST['min'] != null) $min = clean($_POST['min']);
		else $min = 0;
		if (isset($_POST['max']) && $_POST['max'] != '' && $_POST['max'] != null) $max = clean($_POST['max']);
		else $max = NULL;
		if (isset($_POST['yes']) && $_POST['yes'] != '' && $_POST['yes'] != null) $yes = clean($_POST['yes']);
		else $yes = NULL;
		if (isset($_POST['no']) && $_POST['no'] != '' && $_POST['no'] != null) $no  = clean($_POST['no']);
		else $no  = NULL;

		$sql = '# save data
				Update dw_sn_field Set
					fieldTitle    = ?,
					fieldType     = ?,
					fieldDP       = ?,
					fieldExtra    = ?,
					fieldSum1     = ?,
					fieldOperator = ?,
					fieldSum2     = ?,
					fieldShow     = ?,
					fieldList     = ?,
					fieldModUser  = ?,
					fieldReadOnly = ?,
					fieldTag      = ?,
					fieldMin      = ?,
					fieldMax      = ?,
					fieldYes      = ?,
					fieldNo       = ?,
					fieldModDate  = now()
				Where fieldID   = ?';
		if (!savesql($link, $sql, 'siisisiiiiisiissi', array(
			$xtitle,
			$type,
			$dp,
			$extra,
			$fieldsum1,
			$operator,
			$fieldsum2,
			$fieldshow,
			$fieldlist,
			$_SESSION['userID'],
			$readonly,
			$tag,
			$min,
			$max,
			$yes,
			$no,
			$fieldid
		), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}
}

if (isset($_POST['new'])) {
	if (
		isset($_POST['fieldpage']) && $_POST['fieldpage'] != '' && $_POST['fieldpage'] != null &&
		isset($_POST['title']) && $_POST['title'] != '' && $_POST['title'] != null
	) {
		$page   = clean($_POST['fieldpage']);
		$xtitle = clean($_POST['title']);
		$order  = clean($_POST['fieldorder']);
		$type   = clean($_POST['type']);
		$dp     = clean($_POST['dp']);
		$extra  = clean($_POST['extra']);

		if (isset($_POST['fieldSum1'])) $sum1      = clean($_POST['fieldSum1']);
		else $sum1      =  0;
		if (isset($_POST['operator'])) $operator  = clean($_POST['operator']);
		else $operator  = '+';
		if (isset($_POST['fieldSum2'])) $sum2      = clean($_POST['fieldSum2']);
		else $sum2      =  0;
		if (isset($_POST['fieldShow'])) $show      = 1;
		else $show      =  0;
		if (isset($_POST['fieldlist'])) $fieldlist = clean($_POST['fieldlist']);
		else $fieldlist =  0;
		if (isset($_POST['minnew'])) $minnew    = clean($_POST['minnew']);
		else $minnew    =  0;
		if (isset($_POST['maxnew'])) $maxnew    = clean($_POST['maxnew']);
		else $maxnew    =  NULL;
		if (isset($_POST['yesnew'])) $yesnew    = clean($_POST['yesnew']);
		else $yesnew    =  NULL;
		if (isset($_POST['nonew'])) $nonew     = clean($_POST['nonew']);
		else $nonew     =  NULL;

		$sql = '# create new field
				Insert into dw_sn_field             (fieldPage, fieldTitle, fieldType, fieldDP, fieldExtra, fieldSum1, fieldOperator, fieldSum2, fieldShow,  fieldList, fieldOrder, fieldMin, fieldMax, fieldActive, fieldReadOnly, fieldModDate, fieldModUser, fieldYes, fieldNo )
				Values                              (     ?   ,      ?    ,      ?   ,      ? ,      ?    ,      ?   ,      ?       ,      ?   ,      ?   ,       ?   ,      ?    ,      ?  ,      ?  ,      ?     ,      ?       ,     now()   ,      ?      ,      ?  ,      ?  )';
		$params =                               '     i          s           i          i        s           i          s              i          i           i          i           i         i         i            i                            i             s         s   ';
		if (!savesql($link, $sql, $params, array($page,    $xtitle,     $type,     $dp,     $extra,     $sum1,     $operator,     $sum2,     $show, $fieldlist,     $order, $minnew, $maxnew,      1,      0,           $_SESSION['userID'], $yesnew,  $nonew), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}
}

if ($debug) showdebug();
if (isset($_GET['debug'])) $debug = true;
$fieldOrder = array();
?>

<div id="topDIV">
	<h1 class="text-center"><?php echo $title; ?></h1>
</div>

<div class="container-fluid">
	<div class="col-md-3" role="complementary">
		<?php
		$sql = "# get all the pages
				Select
					dw_sn_page.pageID,
					dw_sn_page.pageText,
					dw_sn_page.pageOrder
				From
					dw_sn_page
				Where
					dw_sn_page.pageSite   = ? And
					dw_sn_page.pageActive = 1
				Order By
					dw_sn_page.pageOrder,
					dw_sn_page.pageText
			";
		if (!$qry = mysqli_prepared_query($link, $sql, 'i', array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		foreach ($qry as $pageArray) {
			if (!isset($_POST['fieldpage'])) $_POST['fieldpage'] = $pageArray['pageID']; //this is to show the fields of the first page
		?>
			<div class="row">
				<form method="post">
					<input type="hidden" name="pageid" value="<?php echo $pageArray['pageID']; ?>">
					<div class="col-md-7">
						<?php if ($debug) echo '<small>' . $pageArray['pageID'] . '</small>'; ?>
						<input type="text" id="pageText<?php echo $pageArray['pageID']; ?>" name="pageText" value="<?php echo $pageArray['pageText']; ?>" class="form-control pageText" onfocus="showfields(<?php echo $pageArray['pageID']; ?>);" title="Tab text">
					</div>
					<div class="col-md-5 text-right" style="padding-left:0;">
						<?php if ($_SESSION['userLevel'] == 1) { ?>
							<input type="hidden" name="pageorder" value="<?php echo $pageArray['pageOrder']; ?>">
							<button type="submit" class="btn" aria-label="Move up" name="pageup" title="Move up (currently <?php echo $pageArray['pageOrder']; ?>)">
								<span class="glyphicon glyphicon-chevron-up" aria-hidden="true"></span>
							</button>
							<button type="submit" class="btn" aria-label="Move down" name="pagedown" title="Move down (currently <?php echo $pageArray['pageOrder']; ?>)">
								<span class="glyphicon glyphicon-chevron-down" aria-hidden="true"></span>
							</button>
							<button type="submit" class="btn" aria-label="Delete" name="pagedelete" title="Delete">
								<span class="glyphicon glyphicon-trash" aria-hidden="true"></span>
							</button>
							<button type="submit" class="btn btn-default" aria-label="Save" name="pagesave" title="Save">
								<span class="glyphicon glyphicon-save" aria-hidden="true"></span>
							</button>
						<?php } ?>
					</div>
				</form>
			</div>
		<?php
			$pageOrder = $pageArray['pageOrder'];
		}
		if ($_SESSION['userLevel'] == 1) { //admin
		?>
			<div class="row">
				<form method="post">
					<div class="col-md-7">
						<input type="text" name="pageText" class="form-control" placeholder="New tab" required>
					</div>
					<div class="col-md-5 text-right" style='padding-left:0;'>
						<input type="hidden" name="pageorder" value="<?php echo ($pageOrder + 1); ?>">
						<button type="submit" class="btn btn-default" aria-label="Add page" name="pageadd">
							<span class="glyphicon glyphicon-plus" aria-hidden="true"></span>
						</button>
					</div>
				</form>
			</div>
		<?php } ?>
		<div class="row">
			<div class="col-md-12">
				<div class="text-muted">Click a tab to edit the fields on that tab</div>
			</div>
		</div>
	</div>
	<div class="col-md-9" role="main">
		<?php
		$sql = '
				Select
					pageID,
					pageText
				From
					dw_sn_page
				Where
					pageSite = ? 
					And pageActive = 1
				Order By
					pageOrder,
					pageText';
		if (!$qry = mysqli_prepared_query($link, $sql, 'i', array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		foreach ($qry as $pageArray) {
			$rowcount = 1;
			//for each tab...
			echo '<div class="sortable"><div class="page' . $pageArray['pageID'] . ' page row title ui-state-disabled-dw" style="display:none;"><h3>' . $pageArray['pageText'] . ' tab<h3></div>
					<div class="page' . $pageArray['pageID'] . ' page row header ui-state-disabled-dw" style="display:none;">
						<div class="col-md-2"><strong>Title</strong></div>
						<div class="col-md-2"><strong>Type</strong></div>
						<div class="col-md-1"><strong>Size/DP</strong></div>
						<div class="col-md-2"><strong>Extra</strong></div>
						<div class="col-md-2"><strong>Tag name</strong> (for API)</div>
						<div class="col-md-3"><!-- buttons --></div>
					</div>';
			$sql = '
					Select
						fieldID,
						fieldTitle,
						fieldPage,
						fieldType,
						fieldDP,
						fieldExtra,
						fieldOrder,
						fieldSum1,
						fieldOperator,
						fieldSum2,
						fieldShow,
						fieldList,
						fieldReadOnly,
						fieldTag,
						fieldMin,
						fieldMax,
						fieldYes,
						fieldNo,
						fieldActive
					From
						dw_sn_field
					Where
						fieldPage = ? And
						fieldActive = 1
					Order By
						fieldActive Desc,
						fieldOrder';
			if (!$qry2 = mysqli_prepared_query($link, $sql, 'i', array($pageArray['pageID']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);

			foreach ($qry2 as $fieldArray) {
				//for each field...
				/*
						title		2
						type		2
						dp			1
						extra		2
						tag     2
						buttons	3
					*/
				echo '<div class="page' . $fieldArray['fieldPage'] . ' page row data" style="display:none;" id="field_' . $fieldArray['fieldID'] . '">
						<form method="post">
							<input type="hidden" name="fieldid"    value="' . $fieldArray['fieldID'] . '">
							<input type="hidden" name="fieldpage"  value="' . $pageArray['pageID'] . '">
							<input type="hidden" name="fieldorder" value="' . $fieldArray['fieldOrder'] . '">
							<div class="col-md-2 title">';
				if ($debug) echo '<small>' . $fieldArray['fieldID'] . '</small>';
				echo '
								<input type="text" class="form-control" name="title" value="' . $fieldArray['fieldTitle'] . '" title="' . $fieldArray['fieldTag'] . '" >
							</div>
							<div class="col-md-2 type">
								<select name="type" id="type' . $fieldArray['fieldID'] . '" class="form-control" onchange="update_types(' . $fieldArray['fieldID'] . ');">
									<option value= "1" ';
				if ($fieldArray['fieldType'] == $SN_FIELD_NUMBER) echo 'selected ';
				echo '>Number</option>
									<option value= "6" ';
				if ($fieldArray['fieldType'] == $SN_FIELD_CALC) echo 'selected ';
				echo '>Calculation</option>
									<option value= "4" ';
				if ($fieldArray['fieldType'] == $SN_FIELD_TIME) echo 'selected ';
				echo '>Time</option>
									<option value= "2" ';
				if ($fieldArray['fieldType'] == $SN_FIELD_TEXT) echo 'selected ';
				echo '>Text</option>
									<option value= "5" ';
				if ($fieldArray['fieldType'] == $SN_FIELD_WIDETEXT) echo 'selected ';
				echo '>Wide text (2)</option>
									<option value= "3" ';
				if ($fieldArray['fieldType'] == $SN_FIELD_MEMO) echo 'selected ';
				echo '>Memo (2)</option>
									<option value="11" ';
				if ($fieldArray['fieldType'] == $SN_FIELD_USER) echo 'selected ';
				echo '>Usernames</option>
									<option value= "7" ';
				if ($fieldArray['fieldType'] == $SN_FIELD_LIST) echo 'selected ';
				echo '>List</option>
									<option value= "9" ';
				if ($fieldArray['fieldType'] == $SN_FIELD_SLIDER) echo 'selected ';
				echo '>Slider</option>
									<option value="10" ';
				if ($fieldArray['fieldType'] == $SN_FIELD_YESNO) echo 'selected ';
				echo '>Yes/No</option>
									<option value= "8" ';
				if ($fieldArray['fieldType'] == $SN_FIELD_SPACE) echo 'selected ';
				echo '>Spacer</option>
									<option value="12" ';
				if ($fieldArray['fieldType'] == $SN_FIELD_API) echo 'selected ';
				echo '>API data</option>
								</select>
							</div>';

				if ($fieldArray['fieldType'] == $SN_FIELD_MEMO || $fieldArray['fieldType'] == $SN_FIELD_WIDETEXT || $fieldArray['fieldType'] == $SN_FIELD_API) $fieldwidth = 2; //memo or wide text
				elseif ($fieldArray['fieldType'] == $SN_FIELD_CALC && $fieldArray['fieldShow'] == 0) $fieldwidth = 0; //calculation where it is hidden
				else $fieldwidth = 1;

				//total
				echo '<div id="total' . $fieldArray['fieldID'] . '" ';
				if ($fieldArray['fieldType'] != $SN_FIELD_CALC) echo 'style="display:none;" ';
				echo '>';
		?>
				<div class="col-md-5">
					<div class="col-md-2" style="padding:0;">
						<input type="checkbox" data-toggle="toggle" id="fieldShow<?php echo $fieldArray['fieldID']; ?>" name="fieldShow" data-onstyle="success" data-offstyle="default" data-on="Visible" data-off="Hidden" value="1" data-width="90" title="Show">
						<input type="hidden" id="fieldShowx<?php echo $fieldArray['fieldID']; ?>" value="<?php echo $fieldArray['fieldShow']; ?>">
						<script>
							$(function() {
								$("#fieldShow<?php echo $fieldArray['fieldID']; ?>").bootstrapToggle();

								var fieldShowx = document.getElementById("fieldShowx<?php echo $fieldArray['fieldID']; ?>").value;
								var fieldShow = document.getElementById("fieldShow<?php echo $fieldArray['fieldID']; ?>");
								if (fieldShowx.trim() == "1") {
									fieldShow.checked = true;
									if (typeof $("#fieldShow<?php echo $fieldArray['fieldID']; ?>").bootstrapToggle === "function") $("#fieldShow<?php echo $fieldArray['fieldID']; ?>").bootstrapToggle("on");
									$("#fieldShowx<?php echo $fieldArray['fieldID']; ?>").val("1");
								} else {
									fieldShow.checked = false;
									if (typeof $("#fieldShow<?php echo $fieldArray['fieldID']; ?>").bootstrapToggle === "function") $("#fieldShow<?php echo $fieldArray['fieldID']; ?>").bootstrapToggle("off");
									$("#fieldShowx<?php echo $fieldArray['fieldID']; ?>").val("0");
								}
							});
						</script>
					</div>
					<div class="col-md-4" style="padding-left:25px;">
						<?php
						$calc_sql = "# get all numeric fields
							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_field.fieldType = $SN_FIELD_NUMBER Or
									dw_sn_field.fieldType = $SN_FIELD_TIME Or
									dw_sn_field.fieldType = $SN_FIELD_CALC
								) And
								dw_sn_field.fieldActive = 1 And
								dw_sn_page.pageActive   = 1 And
								dw_sn_page.pageSite     = ? And
								dw_sn_field.fieldID    <> ?
							Order By
								dw_sn_page.pageOrder,
								dw_sn_field.fieldOrder,
								dw_sn_field.fieldTitle";
						if (!$calc_query = mysqli_prepared_query($link, $calc_sql, 'ii', array($_SESSION['userSite'], $fieldArray['fieldID']), __FILE__, __LINE__)) reporterror(get_error(), $calc_sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
						?>
						<select name="fieldSum1" class="form-control" style="padding-left:8px; padding-right:8px;" title="Sum">
							<option value="0">&lt;Deleted field&gt;</option>
							<?php
							if (mysqli_prepared_num_rows($calc_query) < 1) echo '<option selected disabled value="0">No numeric fields</option>';
							else {
								$group = array();
								foreach ($calc_query as $row) {
									$group[$row['pageText']][] = $row;
								}
								foreach ($group as $key => $values) {
									echo '<optgroup label="' . $key . '">';
									foreach ($values as $value) {
										echo '<option value="' . $value['fieldID'] . '"';
										if ($fieldArray['fieldSum1'] == $value['fieldID']) echo 'selected ';
										echo '>' . $value['fieldTitle'];
										if ($debug) echo ' [' . $value['fieldID'] . ']';
										echo '</option>';
									}
									unset($value);
									echo '</optgroup>';
								}
							}
							?>
						</select>
					</div>
					<div class="col-md-2" style="padding-left:0;">
						<select name="operator" id="operator" class="form-control" style="min-width:60px;" title="operator">
							<?php echo '
												<option value="+" ';
							if ($fieldArray['fieldOperator'] == '+') echo 'selected ';
							echo '>+</option>
												<option value="-" ';
							if ($fieldArray['fieldOperator'] == '-') echo 'selected ';
							echo '>&minus;</option>
												<option value="*" ';
							if ($fieldArray['fieldOperator'] == '*') echo 'selected ';
							echo '>&times;</option>
												<option value="/" ';
							if ($fieldArray['fieldOperator'] == '/') echo 'selected ';
							echo '>&divide;</option>
											'; ?>
						</select>
					</div>
					<div class="col-md-4" style="padding-left:0; padding-right:0;">
						<?php
						if (!$calc_query = mysqli_prepared_query($link, $calc_sql, 'ii', array($_SESSION['userSite'], $fieldArray['fieldID']), __FILE__, __LINE__)) reporterror(get_error(), $calc_sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
						?>
						<select name="fieldSum2" class="form-control" title="Sum">
							<option value="0">&lt;Deleted field&gt;</option>
							<?php
							if (mysqli_prepared_num_rows($calc_query) < 1) echo '<option selected disabled value="0">No numeric fields</option>';
							else {
								$group = array();
								foreach ($calc_query as $row) {
									$group[$row['pageText']][] = $row;
								}
								foreach ($group as $key => $values) {
									echo '<optgroup label="' . $key . '">';
									foreach ($values as $value) {
										echo '<option value="' . $value['fieldID'] . '"';
										if ($fieldArray['fieldSum2'] == $value['fieldID']) echo 'selected ';
										echo '>' . $value['fieldTitle'];
										if ($debug) echo ' [' . $value['fieldID'] . ']';
										echo '</option>';
									}
									unset($value);
									echo '</optgroup>';
								}
							}
							?>
						</select>
					</div>

				</div>
	</div>
	<?php echo '
							<div id="list' . $fieldArray['fieldID'] . '" ';
				if ($fieldArray['fieldType'] != $SN_FIELD_LIST) echo 'style="display:none;"';
				echo '>
						<div class="col-md-1" >&nbsp;</div>
						<div class="col-md-4" >
							<select name="fieldlist" class="form-control">
								<option value="1" ';
				if ($fieldArray['fieldList'] == 1) echo 'selected';
				echo '>Damages (bags)</option>
														<option value="2" ';
				if ($fieldArray['fieldList'] == 2) echo 'selected';
				echo '>Down time (minutes)</option>
														<option value="4" ';
				if ($fieldArray['fieldList'] == 4) echo 'selected';
				echo '>Down time B&amp;C (minutes)</option>
														<option value="3" ';
				if ($fieldArray['fieldList'] == 3) echo 'selected';
				echo '>Stock food (tonnes)</option>
							</select>
						</div>
					</div>
					<div class="col-md-1">';
				if ($fieldArray['fieldType'] == $SN_FIELD_NUMBER) echo '<input type="number" step="1" min="0" class="form-control type1" name="dp" id="dp' . $fieldArray['fieldID'] . '" title="Decimal places"  value="' . $fieldArray['fieldDP'] . '" >'; //number
				else if ($fieldArray['fieldType'] == $SN_FIELD_MEMO) echo '<input type="number" step="1" min="0" class="form-control type3" name="dp" id="dp' . $fieldArray['fieldID'] . '" title="Memo box height" value="' . $fieldArray['fieldDP'] . '" >'; //memo
				echo '
							</div>
							<div id="normal' . $fieldArray['fieldID'] . '" ';
				if ($fieldArray['fieldType'] == $SN_FIELD_CALC || $fieldArray['fieldType'] == $SN_FIELD_LIST || $fieldArray['fieldType'] == $SN_FIELD_SLIDER || $fieldArray['fieldType'] == $SN_FIELD_YESNO) echo 'style="display:none;"';
				echo '>';
				if ($fieldArray['fieldType'] <= $SN_FIELD_TIME) echo '<div class="col-md-2 x704">';
				else echo '<div class="col-md-2">';
				//if ($fieldArray['fieldType'] = $SN_FIELD_USER) echo '<div class="col-md-1"></div>';
				if ($fieldArray['fieldType'] != $SN_FIELD_SPACE && $fieldArray['fieldType'] != $SN_FIELD_API) echo '<input type="text" class="form-control not8" name="extra" placeholder="Text (optional) - HTML is allowed, use \'Me\' for name" id="extra' . $fieldArray['fieldID'] . '" value="' . str_replace('"', "'", $fieldArray['fieldExtra']) . '">';
				echo '
								</div>
								';
				if ($fieldArray['fieldType'] == $SN_FIELD_SPACE || $fieldArray['fieldType'] == $SN_FIELD_API || $fieldArray['fieldType'] == $SN_FIELD_USER) echo '<div class="col-md-2"></div>';
				if ($fieldArray['fieldType'] <= $SN_FIELD_WIDETEXT) echo '<div class="col-md-2">
									<input type="text" class="form-control" name="tag" id="tag' . $fieldArray['fieldID'] . '" placeholder="Tag name (optional)" value="' . $fieldArray['fieldTag'] . '">
								</div>';
				echo '
							</div>
							<div id="slider' . $fieldArray['fieldID'] . '" ';
				if ($fieldArray['fieldType'] != $SN_FIELD_SLIDER) echo 'style="display:none;"';
				echo '>
								<div class="col-md-1 text-right"><label for="min' . $fieldArray['fieldID'] . '" >Min:</label></div>
								<div class="col-md-1"><input type="number" class="form-control" name="min" id="min' . $fieldArray['fieldID'] . '" value="' . $fieldArray['fieldMin'] . '" min="0"></div>
								<div class="col-md-1 text-right"><label for="max' . $fieldArray['fieldID'] . '" >Max:</label></div>
								<div class="col-md-1"><input type="number" class="form-control" name="max" id="max' . $fieldArray['fieldID'] . '" value="' . $fieldArray['fieldMax'] . '" min="0"></div>
							</div>
							<div id="yesno' . $fieldArray['fieldID'] . '" ';
				if ($fieldArray['fieldType'] != $SN_FIELD_YESNO) echo 'style="display:none;"';
				echo '>
								<div class="col-md-2"><input type="text" class="form-control" name="yes" id="yes' . $fieldArray['fieldID'] . '" value="' . $fieldArray['fieldYes'] . '" placeholder="Yes"></div>
								<div class="col-md-2"><input type="text" class="form-control" name="no"  id= "no' . $fieldArray['fieldID'] . '" value="' . $fieldArray['fieldNo'] . '" placeholder="No" ></div>
							</div>
							<div id="buttons" class="col-md-3 text-right buttons">';
				if ($_SESSION['userLevel'] == 1) {
					if ($fieldArray['fieldType'] != $SN_FIELD_CALC && $fieldArray['fieldType'] != $SN_FIELD_SPACE) {
						echo '<input type="checkbox" data-toggle="toggle" id="readonly' . $fieldArray['fieldID'] . '" name="readonly" data-onstyle="danger" data-offstyle="success" data-on="Readonly" data-off="Editable" value="1" data-width="100" >';
						if ($fieldArray['fieldReadOnly'] == 1 || $fieldArray['fieldReadOnly'] == '1') {
							echo '<script>
											$(function() {
												$("#readonly' . $fieldArray['fieldID'] . '").bootstrapToggle();
												$("#readonly' . $fieldArray['fieldID'] . '").bootstrapToggle("on");
											});
											</script>';
						} else {
							echo '<script>
											$(function() {
												$("#readonly' . $fieldArray['fieldID'] . '").bootstrapToggle();
												$("#readonly' . $fieldArray['fieldID'] . '").bootstrapToggle("off");
											});
											</script>';
						}
					} else {
						if ($fieldArray['fieldType'] == $SN_FIELD_CALC) {
							echo '<input type="checkbox" id="readonly' . $fieldArray['fieldID'] . '" name="readonly" data-onstyle="danger" data-offstyle="success" data-on="Readonly" data-off="Editable" value="1" data-width="100" readonly >
											<script>
											$(function() {
												$("#readonly' . $fieldArray['fieldID'] . '").bootstrapToggle();
												$("#readonly' . $fieldArray['fieldID'] . '").bootstrapToggle("off").bootstrapToggle("disable");
											});
											</script>';
						}
					}
	?>

		<button type="submit" class="btn" aria-label="Move up" name="up" title="Move up (currently <?php echo $fieldArray['fieldOrder']; ?>)">
			<span class="glyphicon glyphicon-chevron-up" aria-hidden="true"></span>
		</button>
		<button type="submit" class="btn" aria-label="Move down" name="down" title="Move down (currently <?php echo $fieldArray['fieldOrder']; ?>)">
			<span class='glyphicon glyphicon-chevron-down' aria-hidden='true'></span>
		</button>
		<button type="submit" class="btn" aria-label="Delete" name="delete" title="Delete">
			<span class="glyphicon glyphicon-trash" aria-hidden="true"></span>
		</button>
		<button type="submit" class="btn btn-default" aria-label="Save" name="save" title="Save">
			<span class="glyphicon glyphicon-save" aria-hidden="true"></span>
		</button>
	<?php
				}
				echo '
							</div>
						</form>';
				$fieldOrder[$pageArray['pageID']] = $fieldArray['fieldOrder'];
				$rowcount += $fieldwidth;
				if ($rowcount > 4) {
					echo '</div><div class="page' . $fieldArray['fieldPage'] . ' page row hr ui-state-disabled-dw" style="display:none;"><hr size="10">';
					$rowcount = 1;
				}
				echo '</div>';
			}

			if (!isset($fieldOrder[$pageArray['pageID']])) $fieldOrder[$pageArray['pageID']] = 0;
			if ($_SESSION['userLevel'] == 1) { //admin
	?>
	<div class="page<?php echo $pageArray['pageID']; ?> page row new ui-state-disabled-dw" style="display:none;">
		<!--
					  _   _
					 | \ | | _____      __
					 |  \| |/ _ \ \ /\ / /
					 | |\  |  __/\ V  V /
					 |_| \_|\___| \_/\_/

					-->
		<form method="post">
			<input type="hidden" name="fieldpage" value="<?php echo $pageArray['pageID']; ?>">
			<input type="hidden" name="fieldorder" value="<?php echo ($fieldOrder[$pageArray['pageID']] + 1); ?>">
			<div class="col-md-2 new title"><input type="text" class="form-control" name="title" placeholder="New field" required></div>
			<div class="col-md-2 new type">
				<select name="type" id="typenew<?php echo $pageArray['pageID']; ?>" class="form-control" onchange="update_types('new<?php echo $pageArray['pageID']; ?>');" title="Type">
					<option value="1">Number</option>
					<option value="6">Calculation</option>
					<option value="4">Time</option>
					<option value="2">Text</option>
					<option value="5">Wide text (2)</option>
					<option value="3">Memo (2)</option>
					<option value="11">Usernames</option>
					<option value="7">List</option>
					<option value="9">Slider</option>
					<option value="10">Yes/No</option>
					<option value="8">Spacer</option>
					<option value="12">API data</option>
				</select>
			</div>

			<div id="totalnew<?php echo $pageArray['pageID']; ?>" style="display:none;">
				<div class="col-md-5">
					<div class="col-md-4" style="padding-left:0;">
						<?php
						$calc_sql = "# get all numeric fields
											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_field.fieldType = $SN_FIELD_NUMBER Or 
													dw_sn_field.fieldType = $SN_FIELD_TIME Or 
													dw_sn_field.fieldType = $SN_FIELD_CALC
												) And
												dw_sn_field.fieldActive = 1 And
												dw_sn_page.pageSite = ?
											Order By
												dw_sn_page.pageOrder,
												dw_sn_field.fieldOrder,
												dw_sn_field.fieldTitle";
						if (!$calc_query = mysqli_prepared_query($link, $calc_sql, 'i', array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $calc_sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
						echo '<select name="fieldSum1" class="form-control" style="padding-left:8px; padding-right:8px;">';
						if (mysqli_prepared_num_rows($calc_query) < 1) echo '<option selected disabled value="0">No numeric fields</option>';
						else {
							echo '<option value="0"></option>';
							$group = array();
							foreach ($calc_query as $row) {
								$group[$row['pageText']][] = $row;
							}
							foreach ($group 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>';
								}
								unset($value);
								echo '</optgroup>';
							}
						}
						echo '
										</select>
									</div>
									<div class="col-md-2" style="padding-left:0;">
										<select name="operator" class="form-control" style="min-width:60px;">
											<option value="+" selected >+</option>
											<option value="-" >&minus;</option>
											<option value="*" >&times;</option>
											<option value="/" >&divide;</option>
										</select>
									</div>
									<div class="col-md-4" style="padding:0;">';
						if (!$calc_query = mysqli_prepared_query($link, $calc_sql, 'i', array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $calc_sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
						echo '<select name="fieldSum2" class="form-control" style="padding-left:8px; padding-right:8px;">';
						if (mysqli_prepared_num_rows($calc_query) < 1) echo '<option selected disabled value="0">No numeric fields</option>';
						else {
							echo '<option value="0"></option>';
							$group = array();
							foreach ($calc_query as $row) {
								$group[$row['pageText']][] = $row;
							}
							foreach ($group 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>';
								}
								unset($value);
								echo '</optgroup>';
							}
						}
						echo '</select>';
						?>
					</div>
					<div class="col-md-2" style="padding-right:0;">
						<div class="checkbox">
							<label>
								<input type="checkbox" data-toggle="toggle" id="fieldShow" name="fieldShow" data-onstyle="success" data-offstyle="default" data-on="Visible" data-off="Hidden" value="1" data-width="90" checked>
							</label>
						</div>
					</div>
				</div>
			</div>
			<div id="listnew<?php echo $pageArray['pageID']; ?>" style="display:none;">
				<div class="col-md-1">&nbsp;</div>
				<div class="col-md-4">
					<select name="fieldlist" class="form-control" title="Type">
						<option value="1">Damages (bags)</option>
						<option value="2">Down time (minutes)</option>
						<option value="4">Down time B&amp;C (minutes)</option>
						<option value="3">Stock food (kg)</option>
					</select>
				</div>
			</div>
			<div id="normalnew<?php echo $pageArray['pageID']; ?>">
				<div class="col-md-1">
					<input type="number" step="1" min="0" class="form-control" name="dp" id="dpnew<?php echo $pageArray['pageID']; ?>" title="Decimal places" value="0">
				</div>
				<div class="col-md-4"><input type="text" class="form-control" name="extra" id="extranew<?php echo $pageArray['pageID']; ?>" placeholder="Text (optional) - HTML is allowed, use 'Me' for name"></div>
			</div>
			<div id="spacernew<?php echo $pageArray['pageID']; ?>" style="display:none;">
				<div class="col-md-5">&nbsp;</div>
			</div>
			<div id="slidernew<?php echo $pageArray['pageID']; ?>" style="display:none;">
				<div class="col-md-1"><input type="number" step="1" min="0" class="form-control" name="dp" id="dpnew<?php echo $pageArray['pageID']; ?>" title="Decimal places" value="0"></div>
				<div class="col-md-1 text-right"><label for="minnew<?php echo $pageArray['pageID']; ?>">Min:</label></div>
				<div class="col-md-1"><input type="number" class="form-control" name="minnew" id="minnew<?php echo $pageArray['pageID']; ?>" value="0" min="0"></div>
				<div class="col-md-1 text-right"><label for="maxnew<?php echo $pageArray['pageID']; ?>">Max:</label></div>
				<div class="col-md-1"><input type="number" class="form-control" name="maxnew" id="maxnew<?php echo $pageArray['pageID']; ?>" value="0" min="0"></div>
			</div>
			<div id="yesnonew<?php echo $pageArray['pageID']; ?>" style="display:none;">
				<div class="col-md-1">&nbsp;</div>
				<div class="col-md-2"><input type="text" class="form-control" name="yesnew" id="yesnew<?php echo $pageArray['pageID']; ?>" value="Yes" placeholder="Yes"></div>
				<div class="col-md-2"><input type="text" class="form-control" name="nonew" id="nonew<?php echo $pageArray['pageID']; ?>" value="No" placeholder="No"></div>
			</div>
			<div class="col-md-3 text-right"><!-- buttons -->
				<button type="submit" class="btn btn-default" aria-label="Create" name="new" title="Create">
					<span class="glyphicon glyphicon-plus" aria-hidden="true"></span>
				</button>
			</div>
		</form>
	</div>
<?php } ?>
<div class="page<?php echo $pageArray['pageID']; ?> page row x" style="display:none;">&nbsp;</div><?php
																									echo '</div>';
																								}
																									?>
</div>
</div>

<script src='js/editsn.js?v=2.1'></script>

<?php
if (isset($_POST['fieldpage'])) {
	echo '<script>
			showfields(' . $_POST['fieldpage'] . ');
		</script>';
}
if (isset($_GET['page'])) {
	echo '<script>
			showfields(' . $_GET['page'] . ');
		</script>';
}
if (isset($_GET['p'])) {
	echo '<script>
			showfields(' . $_GET['p'] . ');
		</script>';
}
require 'inc/footer.php';
?>