interfacejobs.php | searchcode

/recruitment/reports/interfacejobs.php

https://bitbucket.org/lecturer34/hrmis
PHP | 290 lines | 250 code | 35 blank | 5 comment | 25 complexity | 7e82671f251d7bd09bc91aca91a69e8e MD5 | raw file
Possible License(s): LGPL-2.1

<?php require_once('../../Connections/hrConn.php'); ?>

<?php require_once('../../Connections/hrConn.php'); ?>

<?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_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);



mysql_select_db($database_hrConn, $hrConn);

$query_summ = "SELECT tblapplicantsdetails.appaccountrowid as rowid, tblapplicantsdetails.titleid as tid, tblsalutations_lookup.salutation as salute,  tblapplicantsdetails.surname as sname, tblapplicantsdetails.firstname as fname, tblapplicantsdetails.othernames as oname, concat(salutation,' ', surname,', ', firstname,' ', othernames) as fullname, tblapplicantsaccount.accountemail as email, tblapplicantsdetails.birthdate as dob, tblapplicantsdetails.birthplace as pob, tblapplicantsdetails.hometown as htw FROM tblapplicantsaccount INNER JOIN tblapplicantsdetails ON (tblapplicantsdetails.appaccountrowid = tblapplicantsaccount.account_rowid) INNER JOIN tblsalutations_lookup ON (tblapplicantsdetails.titleid = tblsalutations_lookup.salutationid)";

$summ = mysql_query($query_summ, $hrConn) or die(mysql_error());

$row_summ = mysql_fetch_assoc($summ);

$totalRows_summ = mysql_num_rows($summ);



$maxRows_jobs = 50;

$pageNum_jobs = 0;

if (isset($_GET['pageNum_jobs'])) {

  $pageNum_jobs = $_GET['pageNum_jobs'];

}

$startRow_jobs = $pageNum_jobs * $maxRows_jobs;



mysql_select_db($database_hrConn, $hrConn);

$query_jobs = "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)";

$query_limit_jobs = sprintf("%s LIMIT %d, %d", $query_jobs, $startRow_jobs, $maxRows_jobs);

$jobs = mysql_query($query_limit_jobs, $hrConn) or die(mysql_error());

$row_jobs = mysql_fetch_assoc($jobs);



if (isset($_GET['totalRows_jobs'])) {

  $totalRows_jobs = $_GET['totalRows_jobs'];

} else {

  $all_jobs = mysql_query($query_jobs);

  $totalRows_jobs = mysql_num_rows($all_jobs);

}

$totalPages_jobs = ceil($totalRows_jobs/$maxRows_jobs)-1;



function searchName($postedname) {

	$returnedValue = "<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:center'>S/N</td><td style='width:30%; text-align:left; vertical-align:middle'>FULL NAME</td><td style='width:30%; text-align:left; vertical-align:middle'>EMAIL</td><td style='width:9%; text-align:left; vertical-align:middle'>BIRTH DATE</td><td style='width:10%; text-align:left; vertical-align:middle'>BIRTH PLACE</td><td style='width:10%; text-align:left; vertical-align:middle'>HOME TOWN</td><td style='width:8%; text-align:center; vertical-align:middle'>ACTION</td></tr>";



	$names = explode(" ", $postedname);

	$c = 1;

	foreach ($names as $nam) {

	$name = "'%".$nam."%'";

	$sqlsearch = "SELECT tblapplicantsdetails.appaccountrowid as rowid, tblapplicantsdetails.titleid as tid, tblsalutations_lookup.salutation as salute, tblapplicantsdetails.surname as sname, tblapplicantsdetails.firstname as fname, tblapplicantsdetails.othernames as oname, concat(salutation,' ', surname,', ', firstname,' ', othernames) as fullname, tblapplicantsaccount.accountemail as email, tblapplicantsdetails.birthdate as dob, tblapplicantsdetails.birthplace as pob, tblapplicantsdetails.hometown as htw FROM tblapplicantsaccount INNER JOIN tblapplicantsdetails ON (tblapplicantsdetails.appaccountrowid = tblapplicantsaccount.account_rowid) INNER JOIN tblsalutations_lookup ON (tblapplicantsdetails.titleid = tblsalutations_lookup.salutationid) WHERE tblapplicantsdetails.surname LIKE $name OR tblapplicantsdetails.firstname LIKE $name OR tblapplicantsdetails.othernames LIKE $name OR tblsalutations_lookup.salutation LIKE $name";

	$querysearch = mysql_query($sqlsearch);

	$searchrow = mysql_fetch_assoc($querysearch);

	$searchrows = mysql_num_rows($querysearch);



	do {



	$returnedValue .= "<tr><td style='width:3%; text-align:center';>".$c."</td><td style='width:30%; text-align:left';>".$searchrow['fullname']."</td><td style='width:30%; text-align:left';>".$searchrow['email']."</td><td style='width:9%; text-align:left';>".$searchrow['dob']."</td><td style='width:10%; text-align:left;'>".$searchrow['pob']."</td><td style='width:10%; text-align:left';>".$searchrow['htw']."</td><td style='width:8%; text-align:center';><a href='profile.php?rid=".$searchrow['rowid']."'>VIEW</a></td></tr>";

	$c++;

	

	} while ($searchrow = mysql_fetch_assoc($querysearch));

		$searchrows = mysql_num_rows($querysearch);

		if ($searchrows > 0) {

			mysql_data_seek($querysearch, 0);

			$searchrow = mysql_fetch_assoc($querysearch);

		}



	}

	$returnedValue .= "</table>";

	echo $returnedValue;

}

?>

<!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 jobtitle = $('#job-title').val();

	

						$.ajax({

							type: "POST",

							url: "recruitmentreport.ajax.php",

							data: "getjobs=true&jobtitle=" + jobtitle,

							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: Job Search</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 jobs in the database.</h4><br />

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

					<div class="div_caption">specify CRITERIA TO SEARCH FOR JOBS</div>



	<br />

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

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

	<tr style="border: none;">

	  <td style="width:10%; text-align:left; vertical-align: middle">Position or Job Title:</td>

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

	    <input name="job-title" type="text" id="job-title" size="60" />

	    </span></td>

	  </tr>

    <tr style="border: none;">

      <td style="width:25%; text-align:right; vertical-align: middle"><input name="MM_jobsearch" type="hidden" id="MM_jobsearch" value="job" /></td>

      <td style="width:25%; text-align:left; vertical-align: middle"><span id="showbutton"><input id="btnLogin" name="btnLogin" type="button" value="Search" class="btn btn-default" /></span>&nbsp;&nbsp;&nbsp;&nbsp;<input id="btnCancel" name="btnCancel" type="submit" value="Cancel"  class="btn" /></td>

    </tr>

	</table>

    </form>

</div>



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

	<div class="div_caption">LIST OF JOB OPENINGS IN THE DATABASE</div>

	<div id="showvacancy">

      <?php if ($totalRows_jobs > 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:28%; text-align:center; vertical-align:middle">DEPARTMENT</td>

            <td style="width:31%; text-align:center; vertical-align:middle">JOB TITLE</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:10%; text-align:center; vertical-align:middle">ADVERTISED</td>

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

            <td style="width:10%; 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:28%; text-align:left";><?php echo $row_jobs['dnm']; ?></td>

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

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

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

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

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

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

            </tr>

            <?php } while ($row_jobs = mysql_fetch_assoc($jobs)); ?>

        </table>

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

    </div>

	</div>

	

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

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

</body>

</html>

<?php

mysql_free_result($jobs);

?>