</table> </div> <br> <?php $dbBaseClass = new BaseDB(); if (Database::getConnection() === false) { $_SESSION['error'] = dbGetErrorMsg(); header("Location: Default.php"); exit; } if (isset($_POST["Search"])) { $bc = $_POST['SearchN']; // echo $bc; $records = $dbBaseClass->getFieldsByFilter('Company', array('id', 'Name', 'CompanyCode', 'Active', 'ShortName'), "WHERE Name LIKE '%{$bc}%'"); } else { $records = $dbBaseClass->getFieldsForAll('Company', array('id', 'Name', 'CompanyCode', 'Active', 'ShortName')); } if ($records === false) { $_SESSION['error'] = dbGetErrorMsg(); header("Location: Default.php"); exit; } //$numFields = sqlsrv_num_fields($records); echo "<table class='withBorder'>"; echo '<thead>'; echo '<tr></tr><th>Name</th><th>Company Code</th><th>Active</th><th>ShortName</th><th colspan="3">Action</th> <tr></tr>'; echo '<tr>'; echo '</tr>'; echo '</thead>'; while ($record = sqlsrv_fetch_array($records, SQLSRV_FETCH_BOTH)) { echo "<tr>";
} require_once "Header.inc.php"; $action = ''; $selectList = ''; $dbBaseClass = new BaseDB(); $companyName = ''; $divisionId = ''; if (isset($_POST['Create']) === false) { if (isset($_GET['id']) === false || isset($_GET['action']) === false) { header("Location: BranchDisplayGrid.php"); } $id = (int) $_GET['id']; $action = $_GET['action']; sanitizeString($id); // Get the Division EntityId $divisionStmnt = $dbBaseClass->getFieldsForAll("BusinessEntity", array('BusinessEntityParentId'), "WHERE id = {$_GET['entityId']}"); if ($divisionStmnt == false) { $_SESSION['error'] = "The branch does not have a related division."; header("Location: BranchDisplayGrid.php"); exit; } $divisionRecord = sqlsrv_fetch_array($divisionStmnt, SQLSRV_FETCH_ASSOC); $divisionId = $divisionRecord['BusinessEntityParentId']; // Get the Company EntityId $companyStmnt = $dbBaseClass->getFieldsForAll("BusinessEntity", array('Name', 'Id', 'BusinessEntityParentId'), "WHERE id = {$divisionId}"); if ($companyStmnt == false) { $_SESSION['error'] = "The branch does not have a related company."; header("Location: BranchDisplayGrid.php"); exit; } $companyRecord = sqlsrv_fetch_array($companyStmnt, SQLSRV_FETCH_ASSOC);
<td class="noBorder"> <form name="form3" method="post"> <input type="submit" value="Return" name="Return" id="Return"> </form> </td> </tr> </table> </div> <br> <?php $dbBaseClass = new BaseDB(); if (Database::getConnection() === false) { die("ERROR: Could not connect." . printf('%s', dbGetErrorMsg())); } $records = $dbBaseClass->getFieldsForAll('BusinessLevel', array('id', 'Name', 'Active')); if ($records === false) { die(dbGetErrorMsg()); } echo "<table class ='withBorder'>"; echo "<tr>"; echo "<thead>"; echo "<td>BusinessLevelName</td><td>Active</td>"; echo "</thead>"; echo "</tr>"; while ($record = sqlsrv_fetch_array($records, SQLSRV_FETCH_ASSOC)) { echo "<tr>"; echo "<td>{$record['Name']}</td>"; echo "<td>{$record['Active']}</td>"; echo "</tr>"; }
* Time: 09:30 PM */ if (isset($_POST['Return'])) { header("Location: DivisionDisplayGrid.php"); } global $record; global $action; global $businessEntityRecords; global $parentName; global $selectList; include "Header.inc.php"; $action = ''; $recordBase = BaseBusinessEntity::$BusinessEntity; $dbBaseClass = new BaseDB(); // Get the BusinessEntity records $businessEntityRecords = $dbBaseClass->getFieldsForAll("BusinessEntity", array('Id', 'Name'), "WHERE BusinessLevelId = 1"); $selectList = ''; if (!isset($_POST['Create'])) { if (isset($_GET['id']) === false || isset($_GET['action']) === false) { header("Location: DivisionDisplayGrid.php"); } $id = (int) $_GET['id']; $action = $_GET['action']; sanitizeString($id); $prep = $dbBaseClass->getFieldsForAll("BusinessEntity", array('BusinessEntityParentId'), "WHERE id = {$id}"); $rec = sqlsrv_fetch_array($prep, SQLSRV_FETCH_ASSOC); $businessEntityParentId = $rec['BusinessEntityParentId']; $prep = $dbBaseClass->getFieldsForAll("BusinessEntity", array('Name'), "WHERE id = {$rec['BusinessEntityParentId']}"); if ($prep == false) { $_SESSION['error'] = "The division does not have a related company."; header("Location: DivisionDisplayGrid.php");
echo 'alert("No Company was selected.")'; echo '</script>'; } $division = $_GET['company']; $divisionId = $_GET['divisionId']; $displayType = $_GET['displayType']; try { $dbBaseClass = new BaseDB(); } catch (Exception $exc) { if (Database::getConnection() === false) { die("ERROR: Could not connect. " . printf('%s', dbGetErrorMsg())); } } $divisionBase = new BaseBusinessEntity(); // $companyBase = new BaseCompany(); $prep = $dbBaseClass->getFieldsForAll("BusinessEntity", array('Id', 'Name'), "WHERE BusinessEntityParentId = {$division}"); if ($displayType == 'd' || $displayType == 'r') { while ($division = sqlsrv_fetch_array($prep, SQLSRV_FETCH_ASSOC)) { if ($division['Id'] == $divisionId) { echo "<option selected = \"selected\" value=" . $division['Id'] . ">{$division['Name']}</option>"; return; } } } while ($division = sqlsrv_fetch_array($prep, SQLSRV_FETCH_ASSOC)) { if ($division['Id'] == $divisionId) { echo "<option selected = \"selected\" value=" . $division['Id'] . ">{$division['Name']}</option>"; } else { echo "<option value=" . $division['Id'] . ">{$division['Name']}</option>"; } }