require_once '../common/config/config.inc.php';
require_once SOURCE_ROOT . 'common/config/array.inc.php';
require_once SOURCE_ROOT . 'classes/class.urns.php';
require_once SOURCE_ROOT . 'classes/class.clients_login.php';
require_once SOURCE_ROOT . 'classes/class.niches.php';
$objClientLogin = new ClientsLogin();
$objClientLogin->isValidClients();
$objUrns = new Urns();
$objNiches = new Niches();
$objSessionRedirectUrl = new SessionRedirectUrl();
$arrUrnsFlds = array();
$arrUrnsRecds = array('pkNicheID', 'NicheTitle', 'NicheFirstName', 'NicheLastName');
if (isset($_GET['n_id'])) {
$varWhere = ' pkUrnID = \'' . $_GET['n_id'] . '\'';
$arrUrnsRecord = $objUrns->getUrnsListing(TABLE_URNS, $arrUrnsFlds, '', $varWhere);
$table = "niches JOIN urns ON niches.pkNicheID=urns.fkNicheID";
$arrUrnsList = $objUrns->getUrnsListing($table, $arrUrnsRecds, '', $varWhere);
$clientID = $_SESSION['sessClientID'];
//print_r($arrUrnsList[0]);die;
$arrNichesFlds = array('Section', 'row', 'columns');
$varWhere = ' fkNicheID = \'' . $arrUrnsList[0]['pkNicheID'] . '\'';
$arrNichesRecord = $objNiches->getNichesLocationListing(TABLE_NICHE_LOCATIONS, $arrNichesFlds, '', $varWhere);
//var_dump($_SESSION['sessClientLoginID']);die;
//var_dump($arrNichesRecord[0]["Section"]);die;
}
//var_dump($arrUrnsList[0]['NicheTitle']);die;
@extract($arrUrnsRecord[0]);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<label ><strong>Tag Number<font color="#FF0000">*</font></strong>: </label>
<input type="text" name="UrnTagNumber" id="UrnTagNumber" value="<?php
echo $UrnTagNumber;
?>
"/>
<br />
<label ><strong>Niches<font color="#FF0000">*</font></strong>: </label>
<select name="fkNicheID" id="fkNicheID">
<option value="">---Last Name, Section, Row, Column---</option>
<?php
foreach ($arrNichesRecord as $arrNiches) {
$arrUrnsFlds = array('count(pkUrnID) as nichesCnt');
$varUrnsWhere = ' 1 AND fkNicheID = ' . $arrNiches['pkNicheID'];
$arrUrnsList = $objUrns->getUrnsListing(TABLE_URNS, $arrUrnsFlds, '', $varUrnsWhere);
$CntUrnsList = $arrUrnsList[0]['nichesCnt'];
if ($arrNiches['NicheStatus'] != 'inactive' && $CntUrnsList < 2) {
?>
<option value="<?php
echo $arrNiches['pkNicheID'];
?>
"<?php
if ($fkNicheID == $arrNiches['pkNicheID']) {
?>
selected="selected" <?php
}
?>
><?php
echo $arrNiches['NicheLastName'] . ', ' . $arrNiches['Section'] . ', ' . $arrNiches['row'] . ', ' . $arrNiches['columns'];
?>
