$dateWhere = "";
$departmentMembers = array();
if (isset($_POST['start_year']) && $_POST['start_year'] != "") {
$startYear = (int) $_POST['start_year'];
} else {
$startYear = $AR_PAST_YEARS;
}
if (isset($_POST['end_year']) && $_POST['end_year'] != "") {
$endYear = (int) $_POST['end_year'];
} else {
$endYear = $AR_FUTURE_YEARS;
}
$dateWhere = " AND ((SUBSTRING(status_date, -4, 4) >= {$startYear} AND SUBSTRING(status_date, -4, 4) <= {$endYear}) OR status_date IS NULL OR status_date = 00)";
$listOfDepartmentMembers = array();
$departmentOutput = fetch_department_title($departmentID);
if ($isParentDepartment = fetch_department_children($departmentID)) {
foreach ($isParentDepartment as $userDepartment) {
$thisDept = $userDepartment["department_id"];
$departmentQuery .= " OR `dep_id`=" . $db->qstr($thisDept);
}
}
if (substr($departmentOutput, -1, 1) == "s") {
$departmentOutput = $departmentOutput . "'";
} else {
$departmentOutput = $departmentOutput . "'s";
}
echo "<h1 style=\"page-break-before: avoid\">Department of " . $departmentOutput . " Publications by Member</h1>";
echo "<div class=\"content-small\" style=\"margin-bottom: 10px\">\n";
echo "\t<strong>Date Range:</strong> " . $startYear . " <strong>to</strong> " . $endYear;
echo "</div>";
$usersInDepartmentQuery = "SELECT DISTINCT `user_id`, `firstname`, `lastname` FROM `" . AUTH_DATABASE . "`.`user_departments`, `" . AUTH_DATABASE . "`.`user_data`\n\t\tWHERE (`dep_id` = " . $db->qstr($departmentID) . $departmentQuery . ")\n\t\tAND `user_id` = `user_data`.`id`\n\t\tORDER BY `lastname` ASC, `firstname` ASC";
echo "<option value=\"" . $i . "\"" . ($defaultStartYear == $i ? " selected=\"selected\"" : "") . ">" . $i . "</option>\n";
}
echo "</select>";
?>
</td>
</tr>
<tr>
<td colspan="3" style="text-align: right; padding-top: 10px"><input type="submit" class="btn btn-primary" value="Create Report" /></td>
</tr>
</tbody>
</table>
</form>
</div>
<?php
if ($STEP == 2) {
$oringial_divisions = fetch_department_children($departmentID);
$departmentString = fetch_department_title($departmentID);
$prevDepartment = "";
$prevProxyID = "";
if ($oringial_divisions === false) {
$divisions = $departmentID;
$multipleDivisions = false;
} else {
$divisions = array();
foreach ($oringial_divisions as $division_id) {
$divisions[] = $division_id["department_id"];
}
$divisions = implode(",", $divisions);
$divisions .= "," . $departmentID;
$multipleDivisions = true;
}
switch ($PROCESSED["report_type"]) {
case "Clinical":
$title_suffix = " Clinical Facutly";
$type_where = " AND `" . AUTH_DATABASE . "`.`user_data`.`clinical` = '1'";
break;
case "Non-Clinical":
$title_suffix = " Non-Clinical Facutly";
$type_where = " AND `" . AUTH_DATABASE . "`.`user_data`.`clinical` = '0'";
break;
default:
case "All":
$title_suffix = " All Facutly";
$type_where = "";
break;
}
$oringial_divisions = fetch_department_children($PROCESSED["department_id"]);
$departmentString = fetch_department_title($PROCESSED["department_id"]);
$prevDepartment = "";
$facLectureCount = 0;
if ($oringial_divisions === false) {
$divisions = $PROCESSED["department_id"];
$multipleDivisions = false;
} else {
$divisions = array();
foreach ($oringial_divisions as $division_id) {
$divisions[] = $division_id["department_id"];
}
$divisions = implode(",", $divisions);
$divisions .= "," . $PROCESSED["department_id"];
$multipleDivisions = true;
}
