vacancyreport.php | searchcode

/recruitment/reports/vacancyreport.php

https://bitbucket.org/lecturer34/hrmis
PHP | 334 lines | 295 code | 33 blank | 6 comment | 30 complexity | 97124f2fe27c29c22ea522b9038bef0b MD5 | raw file
Possible License(s): LGPL-2.1

<?php

	if (!isset($_SESSION)) {

		session_start();

	}



	if(!isset($_SESSION['msgDetails'])){

		$_SESSION['msgCaption'] = '';

		$_SESSION['msgDetails'] = '';

	}

	

	require_once('../../lib/database.php');

	openConnection();

	

	require_once('../helper_functions.php');



if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 

{

  if (PHP_VERSION < 6) {

    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  }



  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);



  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;    

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}



$redirectToURL = $_SERVER['PHP_SELF'];



if (isset($_POST['btnCancel'])) {

	$redirectToURL = 'interface.php';

	header("location: $redirectToURL");

}



//$query_vcDate = "SELECT tbldepartment.name AS dnm, tblrank.name AS rnm, tblvacancies.vacantslots as vsl, tblvacancies.jobschedule as jsh, tblvacancies.jobshifts as jsf, tblvacancies.status as sts, tblvacancies.vacancyreason as vrs, tblvacancies.isadvertised as adv, tblvacancies.effectivedate as eff FROM tblvacancies INNER JOIN tbldepartment ON (tblvacancies.departmentid = tbldepartment.departmentid) INNER JOIN tblrank ON (tblvacancies.rankid = tblrank.rankid)";



$query_vcDate = "SELECT tbldepartment.name AS dnm, tblrank.name AS rnm, tblvacancies.vacantslots as vsl, tblvacancies.jobschedule as jsh, tblvacancies.jobshifts as jsf, tblvacancies.status as sts, tblvacancyreasons.vacancyreason as vrs, tblvacancies.isadvertised as adv, tblvacancies.effectivedate as eff FROM tblvacancies INNER JOIN tbldepartment ON (tblvacancies.departmentid = tbldepartment.departmentid) INNER JOIN tblrank ON (tblvacancies.rankid = tblrank.rankid) INNER JOIN tblvacancyreasons ON (tblvacancies.vacancyreasonid = tblvacancyreasons.rowid)";



$vcDate = mysql_query($query_vcDate) or die(mysql_error());

$row_vcDate = mysql_fetch_assoc($vcDate);

$totalRows_vcDate = mysql_num_rows($vcDate);



$query_lsFacCen = "SELECT name FROM tblfaccentres";

$lsFacCen = mysql_query($query_lsFacCen) or die(mysql_error());

$row_lsFacCen = mysql_fetch_assoc($lsFacCen);

$totalRows_lsFacCen = mysql_num_rows($lsFacCen);



$query_lsDeps = "SELECT * FROM tbldepartment ORDER BY name ASC";

$lsDeps = mysql_query($query_lsDeps) or die(mysql_error());

$row_lsDeps = mysql_fetch_assoc($lsDeps);

$totalRows_lsDeps = mysql_num_rows($lsDeps);



$query_vacQty = "SELECT COUNT(vacancyid) as vacqty FROM tblvacancies";

$vacQty = mysql_query($query_vacQty) or die(mysql_error());

$row_vacQty = mysql_fetch_assoc($vacQty);

$totalRows_vacQty = mysql_num_rows($vacQty);



$query_advQty = "SELECT COUNT(advertisementid) as advqty FROM tbladvertisements";

$advQty = mysql_query($query_advQty) or die(mysql_error());

$row_advQty = mysql_fetch_assoc($advQty);

$totalRows_advQty = mysql_num_rows($advQty);



$query_appQty = "SELECT COUNT(account_rowid) as appqty FROM tblapplicantsaccount";

$appQty = mysql_query($query_appQty) or die(mysql_error());

$row_appQty = mysql_fetch_assoc($appQty);

$totalRows_appQty = mysql_num_rows($appQty);



$query_empQty = "SELECT SUM(vacantslots) as empqty, status FROM tblvacancies WHERE status = 'Occupied' GROUP BY status";

$empQty = mysql_query($query_empQty) or die(mysql_error());

$row_empQty = mysql_fetch_assoc($empQty);

$totalRows_empQty = mysql_num_rows($empQty);



$query_pos = "SELECT * FROM tblrank ORDER BY name ASC";

$pos = mysql_query($query_pos) or die(mysql_error());

$row_pos = mysql_fetch_assoc($pos);

$totalRows_pos = mysql_num_rows($pos);

?>

<!DOCTYPE html>

<html lang="en">

    <head>

		<?php require_once("../../partials/cssimports.php") ?>

		<title>ABU Zaria | Online Job Vacancies and Recruitment Portal</title>

		<meta name="keywords" content="ABU Zaria, job vacancies, recruitment">

		<meta name="description" content="The official online job vacancies and recruitment portal of Ahmadu Bello University, Zaria - Nigeria.">

		<link href="../recruit_css/style.css" rel="stylesheet" type="text/css" media="screen" />



		<script src="../js/jquery-1.6.2.min.js" type="text/javascript"></script>

        <script src="../js/jquery-ui.min.js" type="text/javascript"></script>

        <script src="../js/jquery.unobtrusive-ajax.min.js" type="text/javascript"></script>

        <script src="../js/jquery.validate.min.js" type="text/javascript"></script>

        <script src="../js/jquery.validate.unobtrusive.min.js" type="text/javascript"></script>

        <script src="../js/jquery_ui_datepicker.js" type="text/javascript"></script>

        <script src="../js/jquery.unobtrusive-ajax.min.js" type="text/javascript"></script>

		<script src="../js/Site.js" type="text/javascript"></script>



        <style type="text/css">

            .hero-unit {

                background-color: #fff;

                opacity: 0.8;

                -webkit-border-radius: 3px;

                -moz-border-radius: 3px;

                border-radius: 3px;

                background-image: url('../../assets/img/banner-recruitment.png');

                min-height: 120px;

            }



            .hero-unit p a.btn {

                opacity: 1;

            }



        </style>

        <!-- HTML5 shim, for IE6-8 support of HTML5 elements -->

        <!--[if lt IE 9]>

          <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>

        <![endif]-->

<script>

		$(function () {

	

			$(document).ready(function() {

				$('#applicable').hide();

			});

	

			$("#faculty").change(function() {

				if ($(this).val() == 0){

					$('#department').hide();

					$('#applicable').show();

					//$('#applicable1, #applicable2').val("Applicable to all");

				} else {

					$('#department').show();

					//$('#applicable1, #applicable2').empty();

					$('#applicable').hide();

				}

			});

	

			$("#faculty").change(function() {

					var faculty = $(this).val();

		

						$.ajax({

							type: "POST",

							url: "recruitmentreport.ajax.php",

							data: "getdepartments=true&faculty=" + faculty,

							success: function (result) {

							//alert("Result returned is " + result);

							$("select[id$=department] > select").remove()

							$('#department').html(result);

						}

				});

			});

	

			$("#showbutton").click(function() {

					var faculty = $('#faculty').val();

					var department = $('#department').val();

					var mindate = $('#min-date').val();

					var maxdate = $('#max-date').val();

					var position = $('#position').val();

					var advert = $('#advert').val();

	

						$.ajax({

							type: "POST",

							url: "recruitmentreport.ajax.php",

							data: "getvacancy=true&faculty=" + faculty + "&department=" + department + "&mindate=" + mindate + "&maxdate=" + maxdate + "&position=" + position + "&advert=" + advert,

							success: function (result) {

							//alert("Result returned is Faculty : " + faculty + " Dept : " + department + " Min. Date : " + mindate + " Max. Date : " + maxdate + " Position : " + position + " Advert : " + advert);

							//alert("Result returned is " + result);

							$("select[id$=showvacancy] > table").remove()

							$('#showvacancy').html(result);

						}

				});

			});

		});

</script>

    </head>



    <body>

		<?php include_once dirname(__FILE__) . "/../../partials/recruit_navbar.php" ?>

        <div id="container" class="container">

            <div class="span12">

                <div class="page-header">

                    <h2>Recruitment Report: Vacancies</h2>

					<noscript>

						<?php include_once('../no_javascript.php');?>

					</noscript>

					<?php

						if(isset($_SESSION['msgDetails']) && strlen($_SESSION['msgDetails']) > 0 ) {

							echo $_SESSION['msgDetails'];



							$_SESSION['msgCaption'] = '';

							$_SESSION['msgDetails'] = '';

						}

					?>

                </div>

				<h4>Use this page to search for vacancies defined for recruitment purposes.</h4><br />

	  			<div class="dashboard_div" style="width:90%;">

					<div class="div_caption">specify search criteria</div>



	<br />

    <form action="<?php echo $redirectToURL; ?>" method="post" name="recruitment_filter" target="_self" id="recruitment_filter">

	<table style="width: 100%; font-size: 16px; margin-left: 45px; margin-bottom: 0; border: none;">

    <tr style="border: none;">

		<td style="width:27%; text-align:left; vertical-align:middle">Faculty/Centre/Institute/Directorate</td>

		<td style="width:23%; text-align:left; vertical-align: middle">

		  <select name="faculty" id="faculty">

		    <option value="0">Show for All</option>

		    <?php

do {  

?>

		    <option value="<?php echo $row_lsFacCen['facultyid']?>"><?php echo $row_lsFacCen['name']?></option>

		    <?php

} while ($row_lsFacCen = mysql_fetch_assoc($lsFacCen));

  $rows = mysql_num_rows($lsFacCen);

  if($rows > 0) {

      mysql_data_seek($lsFacCen, 0);

	  $row_lsFacCen = mysql_fetch_assoc($lsFacCen);

  }

?>

          </select>

		</td>

		<td style="width:20%; text-align:left; vertical-align: middle; padding:0px 0px 0px 10px">Department/Unit/Section</td>

		<td style="width:30%; text-align:left; vertical-align: middle"><select name="department" id="department">

		  <option value="0">Show for All</option>

		  </select>

          <select name="applicable" id="applicable">

            <option value="0">Show for All</option>

          </select></td>

	  </tr>

	<tr style="border: none;">

	  <td style="width:27%; text-align:left; vertical-align: middle">Minimum Date</td>

	  <td style="width:23%; text-align:left; vertical-align: middle"><span style="vertical-align: middle">

      <input type="text" class="date-picker" name="min-date" id="min-date" />

	  </span></td>

	  <td style="width:20%; text-align:left; vertical-align: middle; padding:0px 0px 0px 10px">Maximum Date</td>

	  <td style="width:30%; text-align:left; vertical-align: middle"><span style="vertical-align: middle">

      <input type="text" class="date-picker" name="max-date" id="max-date" />

	  </span></td>

	  </tr>

    <tr style="border: none;">

      <td style="width:27%; text-align:left; vertical-align: middle">Position</td>

      <td style="width:23%; text-align:left; vertical-align: middle"><select name="position" id="position">

        <option value="0">Show for All</option>

        <?php

do {  

?>

        <option value="<?php echo $row_pos['rankid']?>"><?php echo $row_pos['name']?></option>

        <?php

} while ($row_pos = mysql_fetch_assoc($pos));

  $rows = mysql_num_rows($pos);

  if($rows > 0) {

      mysql_data_seek($pos, 0);

	  $row_pos = mysql_fetch_assoc($pos);

  }

?>

        </select></td>

      <td style="width:20%; text-align:left; vertical-align: middle; padding:0px 0px 0px 10px">Advert Status</td>

      <td style="width:30%; text-align:left; vertical-align: middle"><select name="advert" id="advert">

        <option value="0" selected="selected">Show for All</option>

        <option value="yes">Advertised</option>

        <option value="no">Unadvertised</option>

        </select></td>

    </tr>

    <tr style="border: none;">

      <td style="width:27%; text-align:left; vertical-align: middle">&nbsp;</td>

      <td style="width:23%; text-align:left; vertical-align: middle">&nbsp;</td>

      <td style="width:20%; text-align:left; vertical-align: middle; padding:0px 0px 0px 10px">&nbsp;</td>

      <td style="width:30%; text-align:left; vertical-align: middle">&nbsp;</td>

    </tr>

    <tr style="border: none;">

      <td style="width:27%; text-align:left; vertical-align: middle"><input name="MM_datepoint" type="hidden" id="MM_datepoint" value="datepoint" /></td>

      <td style="width:23%; text-align:right; vertical-align: middle"><span id="showbutton">

        <input id="btnLogin" name="btnLogin" type="button" value="Display" class="btn btn-default" />

        </span></td>

      <td style="width:20%; text-align:left; vertical-align: middle; padding:0px 0px 0px 10px"><input id="btnCancel" name="btnCancel" type="submit" value="Cancel"  class="btn" /></td>

      <td style="width:30%; text-align:left; vertical-align: middle">&nbsp;</td>

    </tr>

	</table>

    </form>

				</div>



<div class="dashboard_div" style="width:90%">

	<div class="div_caption">VACANCY REPORT</div>

	<div id="showvacancy">

		<?php if ($totalRows_vcDate > 0) { // Show if recordset not empty ?>

		<br />

        <table border="1" style="width: 100%; font-size: 14px; padding: 2px; margin-bottom: 1;">

			<tr>

				<td style="width:3%; text-align:center; vertical-align:middle">S/N</td>

				<td style="width:31%; text-align:center; vertical-align:middle">DEPARTMENT</td>

				<td style="width:32%; text-align:center; vertical-align:middle">RANK</td>

				<td style="width:5%; text-align:center; vertical-align:middle">SLOTS</td>

				<td style="width:9%; text-align:center; vertical-align:middle">VACANCY</td>

				<td style="width:8%; text-align:center; vertical-align:middle">REASON</td>

				<td style="width:7%; text-align:center; vertical-align:middle">ADVERTISED</td>

				<td style="width:20%; text-align:center; vertical-align:middle">DATE</td>

			</tr>

		<?php $c = 1; ?>

		<?php do { ?>

			<tr>

				<td style="width:3%; text-align:center";><?php echo $c; $c++; ?></td>

				<td style="width:31%; text-align:left";><?php echo $row_vcDate['dnm']; ?></td>

				<td style="width:32%; text-align:left";><?php echo $row_vcDate['rnm']; ?></td>

				<td style="width:5%; text-align:center";><?php echo $row_vcDate['vsl']; ?></td>

				<td style="width:9%; text-align:center;"><?php echo $row_vcDate['sts']; ?></td>

				<td style="width:8%; text-align:center";><?php echo $row_vcDate['vrs']; ?></td>

				<td style="width:7%; text-align:center";><?php echo $row_vcDate['adv']; ?></td>

				<td style="width:20%; text-align:center";><?php echo $row_vcDate['eff']; ?></td>

			</tr>

		<?php } while ($row_vcDate = mysql_fetch_assoc($vcDate)); ?>

		</table>

		<?php } // Show if recordset not empty ?>

	</div>

</div>

	

</div><!-- /span12 -->

</div><!-- /container -->

</body>

</html>