<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'];