if ($_GET['documentTypeID']) {
$whereAdd[] = "D.documentTypeID = '" . $_GET['documentTypeID'] . "'";
}
if ($_GET['expressionTypeID']) {
$whereAdd[] = "E.expressionTypeID = '" . $_GET['expressionTypeID'] . "'";
}
if ($_GET['qualifierID']) {
$whereAdd[] = "E.expressionID IN (SELECT expressionID FROM ExpressionQualifierProfile WHERE qualifierID = '" . $_GET['qualifierID'] . "')";
}
if ($_GET['startWith']) {
$whereAdd[] = "TRIM(LEADING 'THE ' FROM UPPER(L.shortName)) LIKE UPPER('" . $_GET['startWith'] . "%')";
}
$orderBy = $_GET['orderBy'];
//get total number of records to print out and calculate page selectors
$totalLicenseObj = new License();
$totalRecords = $totalLicenseObj->searchCount($whereAdd);
//reset pagestart to 1 - happens when a new search is run but it kept the old page start
if ($totalRecords <= $pageStart) {
$pageStart = 1;
}
$limit = $pageStart - 1 . ", " . $numberOfRecords;
$licenseObj = new License();
$licenseArray = array();
$licenseArray = $licenseObj->search($whereAdd, $orderBy, $limit);
$pagination = '';
if ($totalRecords == 0) {
echo "<br /><br /><i>Sorry, no licenses fit your query</i>";
$i = 0;
} else {
//maximum number of pages to display on screen at one time
$maxDisplay = 25;
