advertreport.php | searchcode

/recruitment/reports/advertreport.php

https://bitbucket.org/lecturer34/hrmis
PHP | 344 lines | 306 code | 33 blank | 5 comment | 29 complexity | f35d9a04cc492d7c0bdd02d65282d6d9 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');

	require_once('../../lib/hrConn.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");

}



mysql_select_db($database_hrConn, $hrConn);

$query_vcDate = "SELECT tbldepartment.name AS dnm, tblrank.name AS rnm, tblvacancies.vacantslots as vsl, tblvacancies.vacancyid as vid, 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)";

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

$row_vcDate = mysql_fetch_assoc($vcDate);

$totalRows_vcDate = mysql_num_rows($vcDate);



mysql_select_db($database_hrConn, $hrConn);

$query_lsFacCen = "SELECT facid, fame FROM tblfaccentres";

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

$row_lsFacCen = mysql_fetch_assoc($lsFacCen);

$totalRows_lsFacCen = mysql_num_rows($lsFacCen);



mysql_select_db($database_hrConn, $hrConn);

$query_lsDeps = "SELECT * FROM tbldepartment";

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

$row_lsDeps = mysql_fetch_assoc($lsDeps);

$totalRows_lsDeps = mysql_num_rows($lsDeps);



mysql_select_db($database_hrConn, $hrConn);

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

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

$row_vacQty = mysql_fetch_assoc($vacQty);

$totalRows_vacQty = mysql_num_rows($vacQty);



mysql_select_db($database_hrConn, $hrConn);

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

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

$row_advQty = mysql_fetch_assoc($advQty);

$totalRows_advQty = mysql_num_rows($advQty);



mysql_select_db($database_hrConn, $hrConn);

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

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

$row_appQty = mysql_fetch_assoc($appQty);

$totalRows_appQty = mysql_num_rows($appQty);



mysql_select_db($database_hrConn, $hrConn);

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

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

$row_empQty = mysql_fetch_assoc($empQty);

$totalRows_empQty = mysql_num_rows($empQty);



mysql_select_db($database_hrConn, $hrConn);

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

$pos = mysql_query($query_pos, $hrConn) 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: "getadverts=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: Adverts</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 vacancy adverts with a view to adjusting (or confirming) their status.</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['facid']?>"><?php echo $row_lsFacCen['fame']?></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 ADVERTISEMENT 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:25%; text-align:center; vertical-align:middle">DEPARTMENT</td>

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

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

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

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

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

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

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

			</tr>

		<?php $c = 1; ?>

		<?php do { ?>

			<tr>

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

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

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

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

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

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

				<td style="width:8%; text-align:center";><a href="#?vid=<?php echo $row_vcDate['vid']; ?>">EDIT</a></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>