| Server IP : 192.249.121.117 / Your IP : 216.73.216.251 Web Server : Apache System : Linux ded4606.inmotionhosting.com 3.10.0-1160.81.1.el7.x86_64 #1 SMP Fri Dec 16 17:29:43 UTC 2022 x86_64 User : oakben5 ( 1001) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/oakben5/www/career/ |
Upload File : |
<!DOCTYPE html>
<html lang="en">
<style>
body {font-family: "Lato", sans-serif;}
ul.tab {
list-style-type: none;
/* padding: 0; */
overflow: hidden;
border: 1px solid #ccc;
background-color: #5eaff1;
}
ul.rslides.rslides1.rslides2 {
margin: 3px 0 0 0;
}
/* Float the list items side by side */
ul.tab li {float: left;}
/* Style the links inside the list items */
ul.tab li a {
display: inline-block;
color: white;
text-align: center;
padding: 14px 35px;
text-decoration: none;
transition: 0.3s;
font-size: 20px;
}
/* Change background color of links on hover */
ul.tab li a:hover {
background-color: #286ea7;
}
/* Create an active/current tablink class */
ul.tab li a:focus, .active {
background-color: #286ea7;
}
/* Style the tab content */
.tabcontent {
display: none;
padding: 6px 12px;
border-top: none;
margin: 20px 20px 0px 0px;
}
.back {
color: white;
}
.flip-container {
perspective: 1000px;
}
/* flip the pane when hovered */
.flip-container:hover .flipper, .flip-container.hover .flipper {
transform: rotateY(180deg);
}
.flip-container, .front, .back {
width: 320px;
height: 280px;
}
/* flip speed goes here */
.flipper {
transition: 0.6s;
transform-style: preserve-3d;
position: relative;
}
/* hide back of pane during swap */
.front, .back {
backface-visibility: hidden;
position: absolute;
top: 0;
left: 0;
}
/* front pane, placed above back */
.front {
z-index: 2;
/* for firefox 31 */
transform: rotateY(0deg);
}
/* back, initially hidden pane */
.back {
transform: rotateY(180deg);
/* accoration */
.rslides {
position: relative;
list-style: none;
overflow: hidden;
width: 100%;
padding: 0;
margin: 0;
}
.rslides li {
-webkit-backface-visibility: hidden;
position: absolute;
display: none;
width: 100%;
left: 0;
top: 0;
}
.rslides li:first-child {
position: relative;
display: block;
}
.rslides img {
display: block;
height: auto;
width: 100%;
border: 0;
}
#map_canvas {
height: 500px;
width: 500px;
margin: 0px;
padding: 0px
}
@media only screen and (min-width: 960px) {
.modal {width: 780px !important;left:38%!important;}
}
@media only screen and (max-width: 960px) {
#header-top {
margin-bottom: 113px;
}
#text-2 .textwidget {
padding: 0px 25px;
}
div#text-2 {
position: absolute;
top: 290px;
left: 0px;
}
}
@media only screen and (min-width: 480px) and (max-width: 639px) {
div#widgets_for_shortcodes {
display: none;
}
div#header-left img {
float: none !important;
}
ul.socials-link.clearfix {
width: 123px !important;
margin-right: auto !important;
margin-bottom: 0px !important;
margin-top: 0px !important;
margin-left: auto !important;
}
a.headlnk {
width: 100%;
display: block;
}
.flotelle{
float:none !important;
}
.spacer2{
display:none;
}
.himage{
width:84%
}
.footimg {
margin-left: 0px !important;
margin-top: 0px !important;
margin-bottom: 0px !important;
}
}
@media only screen and (max-width: 481px) {
#page-203 table, #page-203 tbody, #page-203 td {
display:block;
}
#page-203 td {
width: 124px;}
#page-205 table, #page-205 tbody, #page-205 td {
display:block;
}
#page-205 td {
width: 97px;}
}
@media only screen and (max-width: 480px) {
div#widgets_for_shortcodes {
display: none;
}
div#header-left img {
float: none !important;
}
ul.socials-link.clearfix {
width: 123px !important;
margin-right: auto !important;
margin-bottom: 0px !important;
margin-top: 0px !important;
margin-left: auto !important;
}
a.headlnk {
width: 100%;
display: block;
}
.flotelle{
float:none !important;
}
.spacer2{
display:none;
}
.himage{
width:84%
}
a.mainimg {
padding-left: 25%;
}
h2.ff {
font-size: 23px !important;
}
}
}
</style>
<style>
@media only screen and (max-width: 480px)
{
.footimg {
margin-left: 0px !important;
margin-top: 0px !important;
margin-bottom: 0px !important;
}
}
@media only screen and (max-width: 480px)
{
li.spl {
padding-left: 7%;
}
.fot {
width: 30%;
}
.ftrimh
{
width:25%;
}
.footimg {
padding-top: 10%;
}
p#back-top {
padding-right: 70%;
}
img.ee {
margin-left: -150%;
margin-top: 18%;
}
.flotelle {
margin-right: 200%;
}
margin-top: 30%;
a.mainimg {
padding-left: 25%;
}
img.spimg {
margin-left: -15%;
}
h2.ff {
font-size: 23px !important;
}
}
</style>
<style>
@media only screen and (max-width: 1250px)
{
.footimg {
margin-left: 0px !important;
margin-top: 0px !important;
margin-bottom: 0px !important;
}
}
@media only screen and (max-width: 480px)
{
li.spl {
padding-left: 7%;
}
.fot {
width: 30%;
}
.ftrimh
{
width:25%;
}
.footimg {
padding-top: 10%;
}
p#back-top {
padding-right: 70%;
}
img.ee {
margin-left: -150%;
margin-top: 18%;
}
.flotelle {
margin-right: 200%;
margin-top: 30%;
}
a.mainimg {
padding-left: 25%;
}
.me {
margin-top: -9%;
}
.tpp {
text-align: center;
}
.shead {
font-size: 18px;
}
img.ms1 {
margin-top: -2%;
margin-left: 60%;
}
img.ms2 {
margin-left: -20%;
margin-top: -62%;
}
img.spimg {
margin-left: -15%;
}
}
</style>
<style>
@media only screen and (max-width: 784px)
{
.rt{
padding-top: 3%;
}
}
</style>
<!--style of flip -->
<style>
.flip {
height: 199px;
width: 300px;
margin: 0 auto;
}
.flip img {
width: 300px;
height: auto;
}
.flip .back {
background: #2184cd;
color: #fff;
text-align: center;
}
.card {
width: 320px;
height: 290px;
padding: 30px;
margin: 0 auto;
}
.card a.thumb {
float: left;
width: 100px;
height: 60px;
margin: 0 5px 10px 0;
}
.card a.thumb img {
max-width: 100%;
max-height: 100%;
}
.front, .back {
width: 100%;
height: 80%;
padding: 15px;
}
</style>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!--Font Tag -->
<link href="https://fonts.googleapis.com/css?family=Damion" rel="stylesheet">
<!-- for modal -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<!--Map Tag -->
<script src="http://maps.google.com/maps/api/js?sensor=false" type="text/javascript"></script>
<script src="http://maps.google.com/maps/api/js?sensor=false" type="text/javascript"></script>
<title>OakBend Med Center</title>
<!-- Bootstrap -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/style.css" rel="stylesheet">
</head>
<body>
<!--Start Header Section -->
<section>
<div class="container">
<div class="row">
<div class="tpp">
<div class="row">
<div class="col-sm-6">
<img style="vertical-align: middle;height:85px" src="img/oakbend_01.png" alt="OakBend Med Center">
</div>
<div class="col-sm-3 hidden-xs hidden-sm">
<a href="https://app.relayhealth.com/Security/Login/Default.aspx" target="_blank">
<img width="100%" src="https://www.oakbendmedcenter.org/old-site/wp-content/uploads/2014/09/Online-Medical-Records.png" class="spimg" ></a>
</div>
<div class="col-sm-3 hidden-xs hidden-sm">
<a href="http://www.nextadagency.com/software/business_review.php?AWNXNQA6AzJROAdhAmAIOlww" target="_blank" > <img width="100%" border="0" src="http://www.nxnotes.com/pb/rateus_buttons/rateus_thumbsup_blue_200x60.png"></a>
</div>
</div>
</div>
</div>
</div>
</section>
<section>
<div class="container">
<div class="row">
<nav class="navbar navbar-default" >
<div class="container-fluid">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
</div>
<!-- Main Menu -->
<div id="navbar" class="navbar-collapse collapse" >
<ul class="nav navbar-nav">
<li class="active"><a href="https://www.oakbendmedcenter.org" style="color: #fff;">Home</a></li>
<li><a href="https://www.oakbendmedcenter.org/about-us/" style="color: #fff;">About Us</a></li>
<li><a href="https://www.oakbendmedcenter.org/ace-unit/" style="color: #fff;">Services</a></li>
<li><a href="https://www.oakbendmedcenter.org/location/" style="color: #fff;">Locations</a></li>
<li><a href="https://www.oakbendmedcenter.org/patientsvisitors/" style="color: #fff;">Patients/Visitors</a></li>
<li><a href="https://www.oakbendmedcenter.org/ways-to-give/" style="color: #fff;">Way To Give</a></li>
<li><a href="https://www.oakbendmedcenter.org/contact-us/" style="color: #fff;">Contact Us</a></li>
<li><a href="https://www.oakbendmedcenter.org/category/blog/" style="color: #fff;">Blog</a></li>
<li><a href="https://oakbend.myhealthcarepayments.com" style="color: #fff;">Pay My Bill</a></li>
</ul>
</div>
<!-- End Main Menu -->
</div>
</nav>
</div>
</div>
</section>
<?php
$servername = "mysqlv113";
$username = "obmc_onboard";
$password = "Obmc#123";
$dbname="obmc_onboard";
$scheme = 'https://';
// Create connection
$conn = new mysqli("mysqlv113", "obmc_onboard", "Obmc#123","obmc_onboard");
$dept = $_GET['depan'];
$locar = $_GET['loo'];
$typs = $_GET['typeitems'];
$seaitem = $_GET['seaitems'];
if (($locar == '' || $locar == 'Location') && ($dept == '' || $dept == 'Department' ) && $typs == '' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position,fld_vacancy_uniqposition,fld_dept_id,fld_location_id, fld_vacancy_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id WHERE fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/* if location department and types are it - 4 condition */
else if (($dept != '' || $dept != 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '1' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position,fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id,fld_dept_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_location_id ='$locar' AND fld_vacancy_full='1'
AND(fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept != '' || $dept != 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '2' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position,fld_vacancy_uniqposition,fld_location_id, fld_vacancy_id,fld_dept_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_location_id ='$locar' AND fld_vacancy_part='1'
AND(fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept != '' || $dept != 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '3' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position,fld_vacancy_uniqposition,fld_location_id, fld_vacancy_id,fld_dept_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_location_id ='$locar' AND fld_vacancy_supp='1'
AND(fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept != '' || $dept != 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '4' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position,fld_vacancy_uniqposition,fld_location_id, fld_vacancy_id,fld_dept_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_location_id ='$locar' AND fld_vacancy_temp='1'
AND(fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/* 3. if department, search and types are not it - 1 condition */
else if (($dept == '' || $dept == 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id,fld_dept_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_location_id ='$locar' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/* only department - changes done in here! */
else if (($dept != '' || $dept != 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition,fld_vacancy_id, fld_location_id, fld_dept_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/* only type 1 */
else if (($dept == '' || $dept == 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '1' && $seaitem == '')
{
$sql="SELECT fld_vacancy_position,fld_vacancy_uniqposition,fld_location_id, fld_vacancy_id,fld_dept_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_vacancy_full='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept == '' || $dept == 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '2' && $seaitem == '')
{
$sql="SELECT fld_vacancy_position,fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id,fld_dept_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_vacancy_part='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept == '' || $dept == 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '3' && $seaitem == '')
{
$sql="SELECT fld_vacancy_position,fld_vacancy_uniqposition,fld_location_id, fld_vacancy_id,fld_dept_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_vacancy_supp='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept == '' || $dept == 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '4' && $seaitem == '')
{
$sql="SELECT fld_vacancy_position,fld_vacancy_uniqposition,fld_location_id, fld_vacancy_id, fld_dept_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_vacancy_temp='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept == '' || $dept == 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '' && $seaitem != '')
{
$sql="SELECT fld_vacancy_position,fld_vacancy_uniqposition,fld_location_id, fld_vacancy_id,fld_dept_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/* depart and type */
else if (($dept != '' || $dept != 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '1' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id,fld_dept_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_vacancy_full='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept != '' || $dept != 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '2' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id,fld_dept_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_vacancy_part='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept != '' || $dept != 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '3' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_vacancy_supp='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept != '' || $dept != 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '4' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_vacancy_temp='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/* dept and loc */
else if (($dept != '' || $dept != 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition,fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_location_id ='$locar' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/* dept and search */
else if (($dept != '' || $dept != 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition,fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND(fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/*type and loc */
else if (($dept == '' || $dept == 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '1' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_location_id ='$locar' AND fld_vacancy_full='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept == '' || $dept == 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '2' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_location_id ='$locar' AND fld_vacancy_part='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept == '' || $dept == 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '3' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_location_id ='$locar' AND fld_vacancy_supp='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept == '' || $dept == 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '4' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition,fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_location_id ='$locar' AND fld_vacancy_temp='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/* type and search */
else if (($dept == '' || $dept == 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '1' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_vacancy_full='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept == '' || $dept == 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '2' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_vacancy_part='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept == '' || $dept == 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '3' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_vacancy_supp='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept == '' || $dept == 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '4' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_vacancy_temp='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/* loc and search */
else if (($dept == '' || $dept == 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_location_id ='$locar' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/* Dep type loc */
else if (($dept != '' || $dept != 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '1' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_location_id ='$locar' AND fld_vacancy_full='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept != '' || $dept != 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '2' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_location_id ='$locar' AND fld_vacancy_part='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept != '' || $dept != 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '3' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_location_id ='$locar' AND fld_vacancy_supp='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept != '' || $dept != 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '4' && $seaitem == '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND fld_location_id ='$locar' AND fld_vacancy_temp='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/* dep typ searc */
else if (($dept != '' || $dept != 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '1' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%')
AND fld_vacancy_full='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept != '' || $dept != 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '2' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_vacancy_part='1'
AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept != '' || $dept != 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '3' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_vacancy_supp='1'
AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept != '' || $dept != 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '4' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_vacancy_temp='1'
AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/* dep loc search */
else if (($dept != '' || $dept != 'Department' ) && ($locar != '' || $locar != 'Location' ) && $typs == '' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_dept_id ='$dept' AND (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%') AND fld_location_id ='$locar'
AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
/* typ loc search */
else if (($dept == '' || $dept == 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '1' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_location_id ='$locar' AND (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%')
AND fld_vacancy_full='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept == '' || $dept == 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '2' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition,fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_location_id ='$locar' AND (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%')
AND fld_vacancy_part='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept == '' || $dept == 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '3' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition, fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_location_id ='$locar' AND (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%')
AND fld_vacancy_supp='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else if (($dept == '' || $dept == 'Department' ) && ($locar == '' || $locar == 'Location') && $typs == '4' && $seaitem != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_uniqposition,fld_location_id, fld_vacancy_id, fld_dept_name,fld_dept_id, fld_location_name, fld_vacancy_date, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_location_id ='$locar' AND (fld_vacancy_position LIKE '%$seaitem%' OR fld_dept_name LIKE '%$seaitem%')
AND fld_vacancy_temp='1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
else
{
}
/* $dept1 = $_GET['depan1'];
$locar1 = $_GET['locar1'];
if ($dept1 != '' || $locar1 != '')
{
$sql = "SELECT fld_vacancy_position, fld_vacancy_id, fld_dept_name, fld_location_name, fld_vacancy_date FROM tbl_vacancy
LEFT JOIN tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id
LEFT JOIN tbl_locations ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id WHERE 1=1 ";
$WHERE ='';
if ($dept1 != '')
{
$WHERE .= "AND fld_dept_name ='$dept1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0' ";
}
else if ($locar1 != '')
{
$WHERE .= "AND fld_location_name ='$locar1' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
}
$sql = $sql.$WHERE;
} */
//$query=mysql_query("select * from pagination LIMIT $start, $limit");
$dept3 = $_GET['vacancyid'];
$sql3 = "SELECT fld_vacancy_position,fld_vacancy_uniqposition, fld_vacancy_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_shift, fld_vacancy_location, fld_vacancy_reqdesc, fld_vacancy_reqme, fld_vacancy_reqmw, fld_vacancy_reqlic, fld_vacancy_reqskill
FROM tbl_vacancy LEFT JOIN
tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id LEFT JOIN tbl_locations
ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id WHERE fld_vacancy_id ='$dept3' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
$result3 = $conn->query($sql3);
$dept4 = $_GET['vacancyid'];
$sql4 = "SELECT fld_vacancy_position,fld_vacancy_uniqposition, fld_vacancy_id, fld_dept_name, fld_location_name, fld_vacancy_date, fld_vacancy_shift, fld_vacancy_location, fld_vacancy_reqdesc, fld_vacancy_reqme, fld_vacancy_reqmw, fld_vacancy_reqlic, fld_vacancy_reqskill
FROM tbl_vacancy LEFT JOIN
tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id LEFT JOIN tbl_locations
ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id WHERE fld_vacancy_id ='$dept4' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
$result4 = $conn->query($sql4);
$dept5 = $_GET['vacancyid'];
$sql5 = "SELECT fld_vacancy_position, fld_vacancy_uniqposition,fld_vacancy_id, fld_dept_name, fld_location_name,
fld_vacancy_date, fld_vacancy_shift, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp,
fld_vacancy_location, fld_vacancy_reqdesc, fld_vacancy_reqme, fld_vacancy_reqmw, fld_vacancy_reqlic, fld_vacancy_reqskill
FROM tbl_vacancy LEFT JOIN
tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id LEFT JOIN tbl_locations
ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id WHERE fld_vacancy_id ='$dept5' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
$result5 = $conn->query($sql5);
$dept6 = $_GET['vacancyid'];
$sql6 = "SELECT fld_location_name, fld_location_street, fld_location_lat, fld_location_log
FROM tbl_locations LEFT JOIN tbl_vacancy ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id
WHERE fld_vacancy_id ='$dept6' AND fld_vacancy_active ='1' AND fld_location_active ='1' AND fld_vacancy_del ='0'";
$result6 = $conn->query($sql6);
$dept7 = $_GET['vacancyid'];
$sql7 = "SELECT fld_vacancy_position, fld_vacancy_uniqposition,fld_vacancy_id,fld_dept_id,fld_location_id, fld_dept_name, fld_location_name,
fld_vacancy_date, fld_vacancy_shift, fld_vacancy_full, fld_vacancy_part, fld_vacancy_temp, fld_vacancy_supp,
fld_vacancy_location, fld_vacancy_reqdesc, fld_vacancy_reqme, fld_vacancy_reqmw, fld_vacancy_reqlic, fld_vacancy_reqskill
FROM tbl_vacancy LEFT JOIN
tbl_dept ON tbl_vacancy.fld_vacancy_deptid = tbl_dept.fld_dept_id LEFT JOIN tbl_locations
ON tbl_vacancy.fld_vacancy_locationid = tbl_locations.fld_location_id WHERE fld_vacancy_id ='$dept5' AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
$result7 = $conn->query($sql7);
while($row2 = $result7->fetch_assoc())
{
$firstde = $row2["fld_dept_name"];
$firstdeid = $row2["fld_dept_id"];
$firstloc = $row2["fld_location_name"];
$firstlocid = $row2["fld_location_id"];
$firstfull = $row2["fld_vacancy_full"];
$firstpart = $row2["fld_vacancy_part"];
$firsttemp = $row2["fld_vacancy_temp"];
$firstsupp = $row2["fld_vacancy_supp"];
}
//$sql2 = "SELECT fld_dept_name,fld_dept_id FROM tbl_dept WHERE fld_dept_active='1' AND fld_dept_del='0' AND fld_dept_id!= $firstdeid ORDER BY fld_dept_name ASC";
$sql2 = "SELECT fld_dept_name,fld_dept_id FROM tbl_dept WHERE fld_dept_active='1' AND fld_dept_del='0' ORDER BY fld_dept_name ASC";
$result2 = $conn->query($sql2);
//$sql1= "SELECT fld_location_name, fld_location_id FROM tbl_locations WHERE fld_location_active ='1' AND fld_location_id!= $firstlocid";
$sql1= "SELECT fld_location_name, fld_location_id FROM tbl_locations WHERE fld_location_active ='1'";
$result1 = $conn->query($sql1);
?>
<section >
<div class="container" style="margin-top:-1%;>
<div class="me">
<div class="row" id="search" >
<div class="col-lg-2 col-md-12">
<!--h4 style="font-weight: bold;color: #fff;">Search Careers by:</h4-->
<a href="https://www.oakbendmedcenter.org/career/emplist.php"> <button type="submit" class="btn btn-default btn-block">See All Jobs</button> </a>
</div>
<div class="col-lg-2 col-md-6">
<select class="form-control" id="dep" name="dep">
<option value="<?php echo "$firstdeid"; ?>"><?php echo "$firstde"; ?> </option>
<?php
while($row = $result2->fetch_assoc()) {?>
<option value="<?php echo $row['fld_dept_id']; ?>">
<?php
echo $row["fld_dept_name"];
?>
</option>
<?php
}
?>
</select>
<input type="hidden" id="depname" name="depname" value="">
</div>
<div class="col-lg-2 col-md-6">
<select class="form-control" id="typ" name="typ">
<?php
if ( $firstfull =='1')
{
?>
<option value="<?php echo $firstfull; ?>" ><?php echo "FT"; ?> </option>
<?php
}
else if ( $firstpart =='1')
{
?>
<option value="<?php echo $firstpart; ?>" ><?php echo "PT"; ?></option>
<?php
}
else if ( $firsttemp =='1')
{
?>
<option value="<?php echo $firsttemp; ?>" ><?php echo "TEMP"; ?></option>
<?php
}
else if ( $firstsupp =='1')
{
?>
<option value="<?php echo $firstsupp; ?>" ><?php echo "PRN"; ?></option>
<?php
}
?>
<?php
if ( $firstfull !='1')
{
?>
<option value="1">FT</option>
<?php
}
?>
<?php
if ( $firstpart !='1')
{
?>
<option value="2">PT</option>
<?php
}
?>
<?php
if ( $firstsupp !='1')
{
?>
<option value="3">PRN</option>
<?php
}
?>
<?php
if ( $firsttemp !='1')
{
?>
<option value="4">TEMP</option>
<?php
}
?>
</select>
</div>
<div class="col-lg-2 col-md-6">
<select class="form-control" id="loc" name="loc">
<?php
if($firstlocid!=''){
?>
<option value="<?php echo "$firstlocid"; ?>"> <?php echo "$firstloc"; ?> </option>
<?php
}else{
?>
<option value="">Location </option>
<?php
}
?>
<?php
while($row = $result1->fetch_assoc()) {?>
<option value="<?php echo $row['fld_location_id']; ?>">
<?php
echo $row["fld_location_name"];
?>
</option>
<?php
}
?>
</select>
<input type="hidden" id="locname" name="locname" value="">
</div>
<div class="col-lg-2 col-md-6">
<div>
<input type="text" name="sitem" id="sitem" class="form-control" aria-label="Text input with checkbox" placeholder="Keyword search" style="z-index: 0;">
</div>
</div>
<div class="col-lg-2 col-md-12">
<button type="submit" id="search2" name="search2" class="btn btn-default btn-block">Search</button>
</div>
</div>
</div>
</div>
</section>
<section>
<div class="container">
<div class="col-sm-12" style="margin-top: 20px;">
<div class="row">
<div class="col-sm-8">
<div class="panel-heading bluehead" >JOB OPPORTUNITY</div>
<table class="table">
<tbody>
<div style="display:hidden">
<?php // print_r( $result4->fetch_assoc()); ?>
</div>
<?php
while($row = $result4->fetch_assoc()) {?>
<tr>
<th scope="row">Position</th>
<td>
<?php
echo $row["fld_vacancy_position"];
?>
</td>
</tr>
<tr>
<th scope="row">Department</th>
<td>
<?php
echo $row["fld_dept_name"];
?>
</td>
</tr>
<tr>
<th scope="row">Shift</th>
<td><?php
echo $row["fld_vacancy_shift"];
?></td>
</tr>
<tr>
<th scope="row">Campus</th>
<td><?php
echo $row["fld_vacancy_location"];
?></td>
</tr>
<tr>
<th scope="row">Location</th>
<td><?php
echo $row["fld_location_name"];
?></td>
</tr>
<tr>
<th scope="row">Date</th>
<td><?php echo date('F d, Y',strtotime($row['fld_vacancy_date'])); ?></td>
</tr>
<?php
}
?>
</tbody>
</table>
<?php
while($row1 = $result6->fetch_assoc()) {?>
<input type="hidden" id="lalo" name="lalo" value="<?php echo $row1['fld_location_lat'].','. $row1['fld_location_log'] ?>">
<input type="hidden" id="naa" name="naa" value="<?php echo $row1['fld_location_name']; ?>">
<?php
}
?>
</div>
<div class="col-sm-4">
<div class="row">
<div class="panel-heading bluehead" >Locate Us</div>
</br>
<script src='https://maps.googleapis.com/maps/api/js?v=3.exp'></script>
<div id='gmap_canvas' style='height: 235px;
width: 100%;
margin-bottom: 14px;
position: relative;
overflow: hidden;'></div>
<style>#gmap_canvas img{max-width:none!important;background:none!important}</style>
<script type='text/javascript'>
function init_map()
{
var myOptions = {
zoom:12,
center:new google.maps.LatLng(29.5764105,-95.7358458)
,mapTypeId: google.maps.MapTypeId.ROADMAP};
var latlog = jQuery('#lalo').val();
var latloc = jQuery('#naa').val();
map = new google.maps.Map(document.getElementById('gmap_canvas'), myOptions);
marker = new google.maps.Marker({map: map,position: new google.maps.LatLng(latlog)});
infowindow = new google.maps.InfoWindow({content:latloc});google.maps.event.addListener(marker, 'click', function(){infowindow.open(map,marker);});infowindow.open(map,marker);}google.maps.event.addDomListener(window, 'load', init_map);</script>
</div>
</div>
</div>
<div class="col-sm-8">
<div class="panel-heading bluehead">POSITION DESCRIPTION</div>
<?php
while($row = $result3->fetch_assoc()) {?>
<p><strong>Position Requirement: </strong>
<?php
echo $row["fld_vacancy_reqdesc"];
?>
</p>
<?php
}
?>
<table class="table table-bordered">
<thead>
<div class="panel-heading bluehead" >JOB REQUIREMENTS</div>
</thead>
<tbody>
<?php
while($row = $result5->fetch_assoc()) {?>
<tr>
<th scope="row">Minimum Education</th>
<td><?php
echo $row["fld_vacancy_reqme"];
?></td>
</tr>
<tr>
<th scope="row">Minimum Work Experience</th>
<td><?php
echo $row["fld_vacancy_reqmw"];
?></td>
</tr>
<tr>
<th scope="row">Required Skills, Knowledge and Abilities</th>
<td><?php
echo $row["fld_vacancy_reqskill"];
?></td>
</tr>
<tr>
<th scope="row">Required/Preferred Licenses/Certifications</th>
<td><?php
echo $row["fld_vacancy_reqlic"];
?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</br>
</br>
<div style="text-align:center">
<div class="col-sm-12">
<div class="panel-heading bluehead" style="margin-bottom:20px">Apply Now</div>
<form method="post" action="application.php?applicationid=<?php echo $_GET['vacancyid']; ?>">
<div class="col-sm-12" style="
margin-bottom: 20px;
">
<div class="col-sm-4">
<label for="">First Name</label>
<input type="text" class="form-control" required name="name">
</div>
<div class="col-sm-4">
<label for="">Email</label>
<input type="email" class="form-control" required name="email">
</div>
<div class="col-sm-4">
<label for="">Phone</label>
<input type="text" class="form-control" required name="phone">
<input type="hidden" class="form-control" name="vacancyid" value="<?php echo $_GET['vacancyid']; ?>">
</div>
</div>
<div class="col-sm-12">
<div class="form-group">
<input type="submit" name="continue" class="btn btn-success" value="Continue">
<a href="https://www.oakbendmedcenter.org/career/index.php" data-id="948" class="btn btn-info " style="background-color: #1e7fd1;border-color: #1e7fd1;" >Back to Careers</a>
<!-- <a href="https://www.oakbendmedcenter.org/career/application.php?applicationid=<?php echo $_GET['vacancyid']; ?>" >Continue</a> -->
</div>
</div>
</form>
</div>
</div>
</br>
</div>
<div class="col-sm-4">
<div class="row" >
<div class="panel-heading bluehead" >Our Benefits </div>
<img style="margin-top:20px" src="images/caree.png" width="100%" alt="">
</div>
</div>
</div>
<!--Start Footer Section -->
<div class="col-sm-12" style="background-color: #333;position: relative;">
<header style="border-bottom: 1px solid #555;padding: 10px 0;margin-bottom: 20px;">
<div id="bottom-logo"></div>
<p class="mytop" id="back-top" style="position: absolute;right: 0;top: 11px;margin-bottom: 10px;line-height: 20px;">
<a href="#top" style="display: block;width: 27px;background: url(https://www.oakbendmedcenter.org/old-site/wp-content/themes/musica/images/icons/back-top-icon.png) no-repeat center #1e7fd1;text-indent: -9999px;font-size: 0;height: 27px;border-radius: 50%;float: left;position: relative;z-index: 0;"></a>
</p>
</header>
<div class="col-sm-6" style="padding-top: 1%;">
<a style="color:#fff">
<div style="background:#1e7fd1; padding:20px; float:left; border-radius: 0px 41px 0px 42px;-moz-border-radius: 0px 41px 0px 42px;-webkit-border-radius: 0px 41px 0px 42px;"><b>Main Campus Address:</b> 1705 Jackson Street, Richmond, Texas 77469<br><b>Phone:</b> 281-341-3000</div>
</a>
</div>
<div class="col-sm-6">
<a href="# " style="color: #428bca;">
<img src="https://www.oakbendmedcenter.org/old-site/wp-content/uploads/2016/02/oakbend-awards-2016.png" style="width:100%;">
</a>
</div>
</div>
</div>
<!--End of Main Container -->
<!-- Start of Footer Section -->
<footer id="page-footer" style="background-color: #222;padding: 15px 0; font-family: Verdana, Geneva, sans-serif;font-size: 11px;color: #444;">
<div class="wrapper clearfix">
<div id="copyright" style="text-align: center;margin-bottom: 0;">
<a href="# " style="color: #428bca;text-decoration: none;"></a>
<p><a href="# " style="color: #428bca;text-decoration: none;">Copyright Oakbend 2016 Powered By </a> <a href="http://emrspg.com/" target="_blank" style="color: #428bca;text-decoration: none;">EMR Support Group</a></p>
</div>
<div id="copyright" style="float: left;margin-bottom: 0;"></div>
</div>
</footer>
<!--End Footer Section -->
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="js/bootstrap.min.js"></script>
<script src="https://code.jquery.com/jquery-2.1.4.min.js"></script>
<script src="js/jquery.flip.min.js"></script>
<script src="js/jquery.js"></script>
<script src="js/jquery.flip.js"></script>
<script>
jQuery("#dep").change(function(){
// var depa = jQuery('#dep').val();
//alert(value);
// jQuery('#depname').val(depa);
});
jQuery("#loc").change(function(){
//var locar = jQuery('#loc').val();
//alert(value);
//jQuery('#locname').val(locar);
});
/* jQuery("#dep1").change(function(){
var depa1 = jQuery('#dep1').val();
var url='https://www.oakbendmedcenter.org/new-career-test/emplist.php?depan1='+depa1;
window.location.href=url;
});
jQuery("#loc1").change(function(){
var locar1 = jQuery('#loc1').val();
var url='https://www.oakbendmedcenter.org/new-career-test/emplist.php?locar1='+locar1;
window.location.href=url;
}); */
jQuery("#search2").click(function(){
var depa = jQuery('#dep').val();
var locar = jQuery('#loc').val();
var typs = jQuery('#typ').val();
var seaitem = jQuery('#sitem').val();
/* 1. if location, search, department and types are it - 4 condition */
if (depa != '' && locar != '' && typs != '' && seaitem != '')
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?depan='+depa+'&loo='+locar+'&typeitems='+typs+'&seaitems='+seaitem;
window.location.href=url;
}
/* 2. if location, search, department and types are not it - 1 condition */
else if (depa == '' && locar == '' && typs == '' && seaitem == '')
{
var url='https://www.oakbendmedcenter.org/career/emplist.php';
window.location.href=url;
}
/* 3. if department and types are not it - 1 condition */
else if (depa == '' && typs == '' && seaitem == '')
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?loo='+locar;
window.location.href=url;
}
/* 4. if department and types are not it - 1 condition */
else if (locar == '' && typs == '' && seaitem == '')
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?depan='+depa;
window.location.href=url;
}
/* 5. if department and types are not it - 4 condition */
else if (locar == '' && depa == '' && seaitem == '')
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?typeitems='+typs;
window.location.href=url;
}
/*6. only search */
else if (locar == '' && depa == '' && typs == '')
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?seaitems='+seaitem;
window.location.href=url;
}
/*7. depart and type */
else if (locar == '' && depa != '' && typs != '' && seaitem == '' )
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?depan='+depa+'&typeitems='+typs;
window.location.href=url;
}
/* 8. depart and loc */
else if (locar != '' && depa != '' && typs == '' && seaitem == '' )
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?depan='+depa+'&loo='+locar;
window.location.href=url;
}
/* 9. depart and search */
else if (locar == '' && depa != '' && typs == '' && seaitem != '' )
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?depan='+depa+'&seaitems='+seaitem;
window.location.href=url;
}
/* 9. type and locat */
else if (locar != '' && depa == '' && typs != '' && seaitem == '' )
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?loo='+locar+'&typeitems='+typs;
window.location.href=url;
}
/* 10. typwe and search */
else if (locar == '' && depa == '' && typs != '' && seaitem != '' )
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?typeitems='+typs+'&seaitems='+seaitem;
window.location.href=url;
}
/* 11. loc and search */
else if (locar != '' && depa == '' && typs == '' && seaitem != '' )
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?loo='+locar+'&seaitems='+seaitem;
window.location.href=url;
}
/* 12. deprt, type, loc */
else if (locar != '' && depa != '' && typs != '' && seaitem == '' )
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?loo='+locar+'&depan='+depa+'&typeitems='+typs;
window.location.href=url;
}
/* 13. deprt, type, search */
else if (locar == '' && depa != '' && typs != '' && seaitem != '' )
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?depan='+depa+'&typeitems='+typs+'&seaitems='+seaitem;
window.location.href=url;
}
/* 14. deprt, loc, search */
else if (locar != '' && depa != '' && typs == '' && seaitem != '' )
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?depan='+depa+'&seaitems='+seaitem+'&loo='+locar;
window.location.href=url;
}
/* 15. typ, loc, search */
else if (locar != '' && depa == '' && typs != '' && seaitem != '' )
{
var url='https://www.oakbendmedcenter.org/career/emplist.php?typeitems='+typs+'&seaitems='+seaitem+'&loo='+locar;
window.location.href=url;
}
else
{
}
/* var seaitem = jQuery('#sitem').val();
if (seaitem != '')
{
var url='https://www.oakbendmedcenter.org/new-career-test/emplist.php?seaitems='+seaitem;
window.location.href=url;
}
else
{
} */
/* var typs = jQuery('#typ').val();
if (typs != '')
{
var url='https://www.oakbendmedcenter.org/new-career-test/emplist.php?typeitems='+typs;
window.location.href=url;
}
else
{
} */
});
</script>
<script>
$(function($) {
$("#card").flip();
});
$(function($) {
$("#card2").flip();
});
$(function($) {
$("#card3").flip();
});
$(function($) {
$("#card4").flip();
});
</script>
<script>
$(function($) {
$("#loc1").flip();
});
$(function($) {
$("#loc2").flip();
});
$(function($) {
$("#loc3").flip();
});
$(function($) {
$("#loc4").flip();
});
$(function($) {
$("#loc5").flip();
});
$(function($) {
$("#loc6").flip();
});
$(function($) {
$("#loc7").flip();
});
$(function($) {
$("#loc8").flip();
});
</script>
<!--script for accordion -->
<script>
var acc = document.getElementsByClassName("accordion");
var i;
for (i = 0; i < acc.length; i++) {
acc[i].onclick = function(){
this.classList.toggle("active");
this.nextElementSibling.classList.toggle("show");
}
}
</script>
<!--script for tab and tab content -->
<script>
function openCity(evt, cityName) {
// Declare all variables
var i, tabcontent, tablinks;
// Get all elements with class="tabcontent" and hide them
tabcontent = document.getElementsByClassName("tabcontent");
for (i = 0; i < tabcontent.length; i++) {
tabcontent[i].style.display = "none";
}
// Get all elements with class="tablinks" and remove the class "active"
tablinks = document.getElementsByClassName("tablinks");
for (i = 0; i < tablinks.length; i++) {
tablinks[i].className = tablinks[i].className.replace(" active", "");
}
// Show the current tab, and add an "active" class to the link that opened the tab
document.getElementById(cityName).style.display = "block";
evt.currentTarget.className += " active";
}
</script>
<!-- script for first item to active present -->
<script>
$(document).ready(function() {
openCity(event, 'team');
$('#test1').addClass('active');
});
</script>
<!--changing the heding middle term -->
<script>
function setRandomWord()
{
var phrases =new Array("growing","building","helping");
$("#itest").text(phrases[Math.floor(Math.random()*phrases.length)]);
}
setInterval(setRandomWord,3000);
</script>
<!--script for google map-->
<script>
function initialize() {
var map_options = {
center: new google.maps.LatLng(30.0296225,-96.5030222),
zoom: 15,
mapTypeId: google.maps.MapTypeId.ROADMAP
};
var google_map = new google.maps.Map(document.getElementById("map_canvas"), map_options);
var info_window = new google.maps.InfoWindow({
content: 'loading'
});
var t = [];
var x = [];
var y = [];
var h = [];
t.push('Jackson Street');
x.push(30.0296225);
y.push(-96.5030222);
h.push('<p><strong>Jackson Street</strong></p>');
t.push('Williams Way');
x.push(29.086485);
y.push(-96.0826136);
h.push('<p><strong>Williams Way</strong></p>');
t.push('Grand Parkway');
x.push(29.72873);
y.push(-96.2619328);
h.push('<p><strong>Grand Parkway</strong></p>');
t.push('Imaging Center');
x.push(29.5998409);
y.push(-95.6840166);
h.push('<p><strong>Imaging Center</strong></p>');
t.push('Doctors’ Center');
x.push(29.8569779);
y.push(-95.7068134);
h.push('<p><strong>Doctors’ Center</strong></p>');
t.push('New Territory');
x.push(30.0000921);
y.push(-95.9863035);
h.push('<p><strong>New Territory</strong></p>');
t.push('Elite Minimally Invasive Surgery');
x.push(29.7094407);
y.push(-95.4058224);
h.push('<p><strong>Elite Minimally Invasive Surgery</strong></p>');
t.push('Metro Ortho and Spine Surgery');
x.push(29.7321446);
y.push(-95.4475337);
h.push('<p><strong>Metro Ortho and Spine Surgery</strong></p>');
t.push('River Oaks Surgery Center');
x.push(29.7296927);
y.push(-95.4462424);
h.push('<p><strong>River Oaks Surgery Center</strong></p>');
var i = 0;
for ( item in t ) {
var m = new google.maps.Marker({
map: google_map,
animation: google.maps.Animation.DROP,
title: t[i],
position: new google.maps.LatLng(x[i],y[i]),
html: h[i]
});
google.maps.event.addListener(m, 'click', function() {
info_window.setContent(this.html);
info_window.open(google_map, this);
});
i++;
}
}
initialize();
</script>
</body>
</html>