',
'
',
'
',
'
',
'
',
'
',
'
'
);
if($emp_list['type'] == 'admin'){
$all_projects = mysqli_query($conn, "SELECT * FROM db_projects order by id DESC");
} elseif ($emp_list['type'] == 'manager') {
$all_projects = mysqli_query($conn, "SELECT * FROM db_projects WHERE manager_id=".$_SESSION['loggedin_user']);
} else {
$all_projects = mysqli_query($conn, "SELECT * FROM db_projects where (user_id=".$_SESSION['loggedin_user']." or employee_ids REGEXP '.*\"employe_id\";s:[0-9]+:\"".$_SESSION['loggedin_user']."\".*') order by id DESC");
//echo "SELECT * FROM db_projects where user_id=".$_SESSION['loggedin_user']." or employee_ids REGEXP '.*\"employe_id\";s:[0-9]+:\"".$_SESSION['loggedin_user']."\".*' order by id DESC";
}
$all_projects_array = array();
$d = strtotime("now");
$this_week_monday = date('Y-m-d', strtotime("this week monday",$d));
$this_week_sunday = date('Y-m-d', strtotime("this week sunday",$d));
if(isset($_POST['pass_start_date']) && !empty($_POST['pass_start_date']) && !empty($_POST['pass_end_date'])){
$this_week_monday = date('Y-m-d', strtotime($_POST['pass_start_date']));
$this_week_sunday = date('Y-m-d', strtotime($_POST['pass_end_date']));
}
while ($s_proj = mysqli_fetch_array($all_projects)) {
$employee_ids = unserialize($s_proj['employee_ids']);
if($emp_list['type'] == 'employee' && !empty($employee_ids)){
$is_pass = 0;
foreach($employee_ids as $e_data){
if($e_data['employe_id'] == $_SESSION['loggedin_user']){
/*if(strtotime('now') >= strtotime($e_data['start_date']) && strtotime('now') <= strtotime($e_data['end_date']." 11:59:59") ){
$is_pass = 1;
}*/
if((strtotime($e_data['start_date']) <= strtotime($this_week_monday) && strtotime($e_data['end_date']) >= strtotime($this_week_monday))
|| (strtotime($e_data['start_date']) <= strtotime($this_week_sunday) && strtotime($e_data['end_date']) >= strtotime($en_date))
|| (strtotime($e_data['start_date']) >= strtotime($this_week_monday) && strtotime($e_data['end_date']) <= strtotime($this_week_sunday))){
$is_pass = 1;
}
}
}
if($is_pass == 0){
continue;
}
}
array_push($all_projects_array, $s_proj);
}
if(count($all_projects_array) == 0){
echo "
No Project Found.
";
} else {
foreach($all_projects_array as $single_project){
$employee_ids = unserialize($single_project['employee_ids']);
$e_count = count($employee_ids);
/*$start = new DateTime($single_project['start_time']);
$end = new DateTime($single_project['end_time']);
$interval = $start->diff($end);
$show_diff = '';
if(!empty($interval->y)){
$show_diff .= $interval->y . " years, ";
}
if(!empty($interval->m)){
$show_diff .= $interval->m." months,";
}
$show_diff .= $interval->d." days ";*/
$show_date = date('d M Y', strtotime($single_project['creation_time']));
?>