| 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/public_html/career/ |
Upload File : |
<?php
//error_reporting(0);
$servername = "mysqlv113";
$username = "obmc_onboard";
$password = "Obmc#123";
$dbname = "obmc_onboard";
$scheme = 'https://';
// Create connection
//$conn = new mysqli("localhost", "toakbend_onbord2", "Obmc#123","obmc_onboard");
$conn = new mysqli("localhost", "toakbend_onboard", "toakbend_onboard","toakbend_onboarding");
/* if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error);} else{echo "Connected successfully";} */
$dept = $_GET['depan'];
$locar = $_GET['loo'];
$typs = $_GET['typeitems'];
$seaitem = $_GET['seaitems'];
/* 1. if location, search, department and types are not it - 1 condition */
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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_vacancy_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location, 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_location,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_location, 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_location, 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_location, 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_location,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_location, 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_location, 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_location, 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_location,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 ="AND fld_vacancy_active ='1' AND fld_vacancy_del ='0'";
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");
$result = $conn->query($sql);
$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);
$sql3 = "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";
$result3 = $conn->query($sql3);
$sql1= "SELECT fld_location_name,fld_location_id FROM tbl_locations WHERE fld_location_active ='1'";
$result1 = $conn->query($sql1);
$sql11= "SELECT fld_location_name,fld_location_id FROM tbl_locations WHERE fld_location_active ='1'";
$result11 = $conn->query($sql11);
$xmdata='';
$myXMLData =
"<?xml version='1.0' encoding='UTF-8'?><list>";
while($row = $result->fetch_assoc()) {
$str = $row["fld_vacancy_location"];
$exp = explode("7",$str);
$vacncyloc = $exp[0].' '.$exp[1];
$xmdata.="<job>
<JobTitle>".htmlentities($row['fld_vacancy_position']).'</JobTitle>
<PositionID>'.htmlentities($row['fld_vacancy_uniqposition']).'</PositionID>
<Department>'.htmlentities($row['fld_dept_name']).'</Department>
<Location>'.htmlentities($vacncyloc).'</Location>
<Posted>'.date('F d, Y',strtotime($row['fld_vacancy_date']))."</Posted>
<URL>https://www.oakbendmedcenter.org/career/jobdetails.php?vacancyid=".$row['fld_vacancy_id']."</URL></job>";
}
$myXMLData= $myXMLData.$xmdata.'</list>';
//$xml=simplexml_load_string($myXMLData) or die("Error: Cannot create object");
header("Content-type: text/xml");
echo( $myXMLData);
?>