function process_Form($sqlResult, $template, $agID, $errorMessages)
{
$agID = $_REQUEST['agID'];
$viewerM = new RowManager_ViewerManager();
$viewerAccessGroupM = new RowManager_ViewerAccessGroupManager();
$join = new JoinPair($viewerM->getJoinOnFieldX('viewer_id'), $viewerAccessGroupM->getJoinOnFieldX('viewer_id'));
$MTM = new MultiTableManager();
$MTM->addRowManager($viewerAccessGroupM);
$MTM->addRowManager($viewerM, $join);
$MTM->constructSearchCondition('accessgroup_id', '=', $agID, true);
$MTM->addSortField('viewer_userID');
$sqlResult = $MTM->find();
if (!isset($sqlResult)) {
$errorMessages = 'Failed to join database to get label';
$template->set('sqlResult', null);
} else {
$template->set('sqlResult', $sqlResult);
}
}
function process_Form($sqlResult, $template, $errorMessages)
{
//get the names that are being searched
$fName = $_REQUEST['fName'];
$lName = $_REQUEST['lName'];
//create the needed row managers
$personM = new RowManager_PersonManager();
$accessM = new RowManager_AccessManager();
$viewerM = new RowManager_ViewerManager();
//setup the join pair needed
$join = new JoinPair($personM->getJoinOnFieldX('person_id'), $accessM->getJoinOnFieldX('person_id'));
//create the multi table manager and initialize it
$MTM = new MultiTableManager();
$MTM->addRowManager($personM);
$MTM->addRowManager($accessM, $join);
//if there is a first name being searched - add that as a condition
if ($fName != "") {
$MTM->constructSearchCondition('person_fname', ' LIKE ', '%' . $fName . '%', true);
$personM->constructSearchCondition('person_fname', ' LIKE ', '%' . $fName . '%', true);
}
//if there is a last name being searched - add that as a condition
if ($lName != "") {
$MTM->constructSearchCondition('person_lname', ' LIKE ', '%' . $lName . '%', true);
$personM->constructSearchCondition('person_lname', ' LIKE ', '%' . $lName . '%', true);
}
//jump to a display function to show what was reteived from the person database
//$sqlResult = $personM->find();
//$rows = showContents($sqlResult, $personM, $personM->getFields());
//jump to a display function to show what was reteived after joining the databases
$sqlResult = $MTM->find();
//$rows = showContents($sqlResult, $personM, $personM->getFields());
$sqlResult->setFirst();
//create a new viewer manager to keep data pure
$viewM = new RowManager_ViewerManager();
//loop through the results saving them to be displayed
for ($i = 0; $i < $sqlResult->getRowCount(); $i++) {
//get the next result and the values
$sqlResult->getNext($personM);
$f_name[] = $personM->getValueByFieldName('person_fname');
$l_name[] = $personM->getValueByFieldName('person_lname');
$person_id[] = $personM->getValueByFieldName('person_id');
//get the current accessManager values
$sqlResult->getCurrent($accessM);
//create the join for access table -> viewer table and search the database for the record
$join = new JoinPair($accessM->getJoinOnFieldX('viewer_id'), $viewerM->getJoinOnFieldX('viewer_id'));
$MTM = new MultiTableManager();
$MTM->addRowManager($accessM);
$MTM->addRowManager($viewerM, $join);
$MTM->constructSearchCondition('viewer_id', '=', $accessM->getValueByFieldName('viewer_id'), true);
$sqlResult2 = $MTM->find();
//add the needed information to the arrays to be displayed in the template file
$sqlResult2->getNext($viewM);
$viewer_id[] = $viewM->getValueByFieldName('viewer_id');
$user_id[] = $viewM->getValueByFieldName('viewer_userID');
}
//check if there was any result from the initial database query, if not add an error message
if ($sqlResult->getRowCount() < 1) {
$errorMessages = 'Failed to join database to get label';
$template->set('f_name', null);
} else {
//add the needed information to the template
$template->set('f_name', $f_name);
$template->set('l_name', $l_name);
$template->set('viewer_id', $viewer_id);
$template->set('person_id', $person_id);
$template->set('user_id', $user_id);
}
}
function process_Form($sqlResult, $template, $errorMessages)
{
//get the names that are being searched
$fName = $_REQUEST['fName'];
$lName = $_REQUEST['lName'];
//create the needed row managers
$personM = new RowManager_PersonManager();
$accessM = new RowManager_AccessManager();
$viewerM = new RowManager_ViewerManager();
//setup the join pair needed
$join = new JoinPair($personM->getJoinOnFieldX('person_id'), $accessM->getJoinOnFieldX('person_id'));
//create the multi table manager and initialize it
$MTM = new MultiTableManager();
$MTM->addRowManager($personM);
$MTM->addRowManager($accessM, $join);
//if there is a first name being searched - add that as a condition
if ($fName != "") {
$MTM->constructSearchCondition('person_fname', ' LIKE ', '%' . $fName . '%', true);
$personM->constructSearchCondition('person_fname', ' LIKE ', '%' . $fName . '%', true);
}
//if there is a last name being searched - add that as a condition
if ($lName != "") {
$MTM->constructSearchCondition('person_lname', ' LIKE ', '%' . $lName . '%', true);
$personM->constructSearchCondition('person_lname', ' LIKE ', '%' . $lName . '%', true);
}
//jump to a display function to show what was reteived from the database
$rows = showContents($personM->find(), $personM, $personM->getFields());
echo '<b>' . $rows . ' accounts found in the person table.</b><br><br>';
//jump to a display function to show what was reteived from the database
$sqlResult = $MTM->find();
echo '<b>' . $sqlResult->getRowCount() . ' connections made between person table and access groups.</b><br>';
$rows = showContents($sqlResult, $personM, $personM->getFields());
$sqlResult->setFirst();
$viewM = new RowManager_ViewerManager();
for ($i = 0; $i < $sqlResult->getRowCount(); $i++) {
$sqlResult->getNext($personM);
$f_name[] = $personM->getValueByFieldName('person_fname');
$l_name[] = $personM->getValueByFieldName('person_lname');
$person_id[] = $personM->getValueByFieldName('person_id');
$sqlResult->getCurrent($accessM);
$join = new JoinPair($accessM->getJoinOnFieldX('viewer_id'), $viewerM->getJoinOnFieldX('viewer_id'));
$MTM = new MultiTableManager();
$MTM->addRowManager($accessM);
$MTM->addRowManager($viewerM, $join);
$MTM->constructSearchCondition('viewer_id', '=', $accessM->getValueByFieldName('viewer_id'), true);
$sqlResult2 = $MTM->find();
$sqlResult2->getNext($viewM);
$viewer_id[] = $viewM->getValueByFieldName('viewer_id');
$user_id[] = $viewM->getValueByFieldName('viewer_userID');
}
if ($sqlResult->getRowCount() < 1) {
$errorMessages = 'Failed to join database to get label';
$template->set('f_name', null);
} else {
$template->set('f_name', $f_name);
$template->set('l_name', $l_name);
$template->set('viewer_id', $viewer_id);
$template->set('person_id', $person_id);
$template->set('user_id', $user_id);
}
}