<?php
/*	**********************************************************************************
	* Name   : zones.php                       By: R. Willis                         *
	* Version: 2.00.00                    Origial:                                   *
	* Purpose: List all zones for this client's alarm                                *
	* Revisions:                                                                     *
	*         2.01.00 (2014.02.09) PRODUCTION RELEASE  by R. Willis                  *
	*             Added ability to capture zone listings from previous SOs           *
	*             Added capture for duplicate zone numbers (now rejected with warn)  *
	**********************************************************************************/

	if (array_key_exists("copyZoneList", $_REQUEST))
	{	// process request to copy zone list from prior SOs
		$zoneList = sqlSelect("zones,headers", "zones.linkRef=headers.tid and headers.oCode='{$job['oCode']}'", "", "zoneNo,zones.lastmod desc");
		while ($zone = mysql_fetch_assoc($zoneList['r']))
		{	// zones can change over time. the query will return ALL zone listings from the database, but it should be presumed that the
			// newest one is correct. This method will return all zones starting with the newest; if it's already been copied (IE, not newest)
			// it will be skipped
			if ($lastZoneNum != $zone['zoneNo'])
			{	$lastZoneNum = $zone['zoneNo'];

				$i  = "csid  = '{$zone['csid']}', ";
				$i .= "linkRef  = '{$job['tid']}', ";
				$i .= "zoneRef  = '{$zone['zoneRef']}', ";
				$i .= "zoneNo  = '{$zone['zoneNo']}', ";
				$i .= "zonePart  = '{$zone['zonePart']}', ";
				$i .= "zoneDevice  = '{$zone['zoneDevice']}', ";
				$i .= "zoneType  = '{$zone['zoneType']}', ";
				$i .= "zoneEOL  = '{$zone['zoneEOL']}', ";
				$i .= "zoneName  = '{$zone['zoneName']}'";
				sqlRecycle("zones", $i, "zoneNo = '' and zoneType = '' and zoneEOL = '' and zoneDevice = '' and zoneName = ''");
			}
		}
		unset($zoneList);
		unset($zone);
		unset($lastZoneNum);
	}

	// if request[zoneRef] is not empty, this is an edit - retreive old data and clear table entry
	if (!empty($_REQUEST['zoneRef']))
	{	$row = sqlSelect("zones", "tid = '".$_REQUEST['zoneRef']."'");
		$row = mysql_fetch_assoc($row['r']);
		foreach ($row as $k => $v)
			$_REQUEST[$k] = $v;
		sqlUpdate("zones", "linkRef = '', zoneNo = '', zoneType = '', zoneEOL = '', zoneDevice = '', zoneName = ''", "tid = '".$row['tid']."'");
	}
	else if (!empty($_REQUEST['zoneNo']) and !empty($_REQUEST['zoneName']))
	{	// standardize zoneNo
		$zoneNo = substr("000".$_REQUEST['zoneNo'], -3);
		// check to see if the zoneNo is already used
		$zoneExists = sqlSelect("zones", "linkRef = '".$job['tid']."' and zoneNo = '$zoneNo'");
		if ($zoneExists['n'] == 0) // zoneNo does not exist, so save entry
		{	if (empty($_REQUEST['zonePart'])) $_REQUEST['zonePart'] = "1";

			$row = sqlSelect("zones", "zoneNo = ''"); // -- recycalbe entry?
			if ($row['n']) // - iff yes, use it
			{	$row = mysql_fetch_assoc($row['r']);
				sqlUpdate("zones", "linkRef = '".$job['tid']."', zoneNo = '$zoneNo', zoneDevice = '".ucwords(strtolower($_REQUEST['zoneDevice']))."', zonePart = '".$_REQUEST['zonePart']."', zoneType = '".strtoupper($_REQUEST['zoneType'])."', zoneEOL = '".strtoupper($_REQUEST['zoneEOL'])."', zoneName = '".ucwords(strtolower($_REQUEST['zoneName']))."'", "tid = '".$row['tid']."'");
			}
			else //	---- else create new entry
				sqlInsert("zones", "zoneref = '', linkRef = '".$job['tid']."', zoneNo = '".substr("000".$_REQUEST['zoneNo'], -3)."', zoneDevice = '".ucwords(strtolower($_REQUEST['zoneDevice']))."', zonePart = '".$_REQUEST['zonePart']."', zoneType = '".strtoupper($_REQUEST['zoneType'])."', zoneEOL = '".strtoupper($_REQUEST['zoneEOL'])."', zoneName = '".ucwords(strtolower($_REQUEST['zoneName']))."'");

			unset($_REQUEST['zoneNo']);
			unset($_REQUEST['zoneDevice']);
			unset($_REQUEST['zoneType']);
			unset($_REQUEST['zoneEOL']);
			unset($_REQUEST['zoneName']);
		}
		else
		{	// oops! the zone number already exists
			echo "<span style=\"color: #FBB;\">Zone number already listed; please try again</span><br>\n";
		}
	}
?>
	<table><thead>
		<tr style="border-bottom: 1px solid;">
			<th class="small">Num</th>
			<th class="small">Par</th>
			<th class="small">Device</th>
			<th class="small">Type</th>
			<th class="small">Loop</th>
			<th class="small" width=300>Description</th>
			<th class="small" width=15></th>
		</tr>
<?php
	echo "	<form name=\"zoneEntry\" action=\"./\" method = POST>\n";
	echo "	<input type=HIDDEN name=\"jobRef\" value=\"".$_REQUEST['jobRef']."\">\n";
	echo "	<tr style=\"border-top: 1px solid;\">\n";
	echo "		<td><input class=\"small\" name=\"zoneNo\" id=\"zoneNo\" size=2 value=\"".$_REQUEST['zoneNo']."\" onFocus=\"this.select();\" onKeyPress=\"if (event.keyCode == 13 && this.value != '') this.form.zonePart.focus();\"></td>\n";
	echo "		<td><input class=\"small\" name=\"zonePart\" id=\"zonePart\" size=2 value=\"".$_REQUEST['zonePart']."\" onFocus=\"this.select();\" onKeyPress=\"if (event.keyCode == 13) { if (this.value == '') this.value = '1'; this.form.zoneDevice.focus(); }\"></td>\n";
	echo "		<td><input class=\"small\" name=\"zoneDevice\" id=\"zoneDevice\" size=15 value=\"".$_REQUEST['zoneDevice']."\" onFocus=\"this.select();\" onKeyPress=\"if (event.keyCode == 13 && this.value != '') this.form.zoneType.focus();\"></td>\n";
	echo "		<td><input class=\"small\" name=\"zoneType\" id=\"zoneType\" size=5 value=\"".$_REQUEST['zoneType']."\" onFocus=\"this.select();\" onKeyPress=\"if (event.keyCode == 13) this.form.zoneEOL.focus();\"></td>\n";
	echo "		<td><input class=\"small\" name=\"zoneEOL\" id=\"zoneEOL\" size=8 value=\"".$_REQUEST['zoneEOL']."\" onFocus=\"this.select();\" onKeyPress=\"if (event.keyCode == 13) this.form.zoneName.focus();\"></td>\n";
	echo "		<td><input class=\"small\" name=\"zoneName\" id=\"zoneName\" size=45 value=\"".$_REQUEST['zoneName']."\" onFocus=\"this.select();\" onKeyPress=\"if (event.keyCode == 13 && this.value != '') this.form.submit();\"></td>\n";
	echo "	</tr>\n";
	echo "</form>\n";
	echo"	</thead>\n";
	echo"	<tfoot>\n";
	echo "</tfoot>\n";
	echo "<tbody height=400 style=\"overflow:auto; overflow-x: hidden;\">\n";

	//***************** post process loop *****************************
	// get all zone listings for this rTid
	$rows = 0;
	$c = "cursor: pointer; color: black;\"";
	$noZones = false;
	$zoneList = sqlSelect("zones", "linkRef = '".$job['tid']."'", "", "zoneNo");
	if (!$zoneList['n']) // no zones are attached to this SO, so see if zones are available for this client under other SOs
	{	$zoneList = sqlSelect("zones,headers", "zones.linkRef=headers.tid and headers.oCode='{$job['oCode']}'", "zones.linkRef", "zoneNo,zones.lastmod desc");
		if ($zoneList['n'])
		{	$zoneList = mysql_fetch_assoc($zoneList['r']);
			$c = "color: #333;\"";
			//$zoneList = sqlSelect("zones,headers", "zones.linkRef=headers.tid and headers.oCode='{$job['oCode']}'", "", "zoneNo,zones.lastmod desc");
			$zoneList = sqlSelect("zones", "linkRef='{$zoneList['linkRef']}'", "", "zoneNo");
		}
		$noZones = true;
	}

	while ($zone = mysql_fetch_assoc($zoneList['r']))
	{	if ($lastZoneNum != $zone['zoneNo'])
		{	$lastZoneNum = $zone['zoneNo'];

			echo "	<tr style=\"$c"; if (!$noZones) echo " onClick=\"document.location.href='./?zoneRef=".$zone['tid']."';\""; echo ">\n";
			echo "		<td class=\"small\">".$zone['zoneNo']."</td>\n";
			echo "		<td class=\"small\">".$zone['zonePart']."</td>\n";
			echo "		<td class=\"small\">".$zone['zoneDevice']."</td>\n";
			echo "		<td class=\"small\">".$zone['zoneType']."</td>\n";
			echo "		<td class=\"small\">".$zone['zoneEOL']."</td>\n";
			echo "		<td class=\"small\">".$zone['zoneName']."</td>\n";
			echo "	</tr>\n";
			$rows += 1;
		}
	}

	while ($rows++ < 18)
	{	echo "<tr><td>&nbsp;</td></tr>\n";
	}

	if ($noZones and $zoneList['n'])
	{	// zones listed are attached to a different SO - offer to copy to this SO
		echo "	<tr><td align=center colspan=6>\n";
		echo "		<input class=\"small\" type=BUTTON value=\"Copy zones to this order\" onClick=\"document.location.href='./?copyZoneList';\">\n";
		echo "	</td></tr>\n";
	}
?>
	</tbody>
	</table>
	<script type="text/javascript">
		document.getElementById('zoneNo').focus();
	</script>