<div class="col-md-6">
<input type="hidden" value="<?php
echo $_SESSION['tasks_empId'];
?>
" id="creator_id">
<div class="form-group">
<label class="control-label">
JOB <span class="symbol required"></span>
</label>
<select class="form-control search-select selJob" id="selJob" name="selJob">
<?php
//get all jobs
$q = "SELECT * FROM `jobs` ORDER BY jobId";
$sq = $hr_db->query($q);
$sq = $hr_db->execute();
$getJobs = $hr_db->fetchAll();
if (!empty($getJobs)) {
echo "<option value=''>Select...</option>";
foreach ($getJobs as $jobs) {
echo "<option value='" . $jobs['jobId'] . "'>" . $jobs['job'] . "</option>";
}
}
?>
</select>
</div>
<div class="form-group">
<label class="control-label">
EMPLOYEE <span class="symbol required"></span>
</label>
<select class="form-control search-select selEmps" id="selEmps" name="selEmps">
session_start();
require_once "classes/tasksConnection.php";
require_once "classes/hrConnection.php";
require_once "_inc/mFunctions.php";
$hr_db = new hr();
$db = new db();
if (!empty($_REQUEST['action']) && $_REQUEST['action'] == "getEmployees") {
$jobId = $_REQUEST['jobId'];
$data = '';
//get employees under this job
$q = "SELECT users.emp_id, users.name FROM `users` \n\t\t JOIN `employees` on employees.emp_id = users.emp_id\n\t\t WHERE employees.job_id = :jobId ORDER BY emp_id";
$sq = $hr_db->query($q);
$hr_db->bind(":jobId", $jobId);
$sq = $hr_db->execute();
$getEmployees = $hr_db->fetchAll();
if (!empty($getEmployees)) {
$data .= "<option value=''>Select...</option>";
foreach ($getEmployees as $Employees) {
$data .= "<option value='" . $Employees['emp_id'] . "'>" . $Employees['name'] . "</option>";
}
}
echo $data;
}
if (!empty($_REQUEST['action']) && $_REQUEST['action'] == "addTask") {
$creatorId = $_REQUEST['creatorId'];
$assigneeId = $_REQUEST['assigneeId'];
$locId = $_REQUEST['locId'];
$date = $_REQUEST['date'];
$repeat = $_REQUEST['repeat'];
$title = $_REQUEST['title'];
