<?php
if ( ! defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly
}
global $wpdb,$current_user, $wppmfunction;
$task_per_page = 20;
$total_no_of_rows = 0;
$totalrows_tasks = 0;
$appearance_settings = get_option("wppm-ap-grid-view");
$cu_id = esc_sql($current_user->ID);
$page_no = isset($_POST['page_no']) ? intval(sanitize_text_field($_POST['page_no'])) : '0';
$orderby_sql = esc_sql(sanitize_sql_orderby( "load_order ASC" ));
$task_status = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}wppm_task_statuses ORDER BY $orderby_sql " );
$wppm_task_time = get_option('wppm_task_time');
$page = isset($_POST['page']) ? sanitize_text_field($_POST['page']) : '';
$wppm_date_setting = get_option('wppm_date_setting');
$search_tag = isset($_POST['task_search']) ? sanitize_text_field($_POST['task_search']) : '';
$filter_by = isset($_POST['wppm_task_filter']) ? sanitize_text_field($_POST['wppm_task_filter']) : "all";
$proj_filter = isset($_POST['wppm_proj_filter']) ? sanitize_text_field($_POST['wppm_proj_filter']) : "0";
$public_projects = isset($_POST['public_projects']) ? sanitize_text_field($_POST['public_projects']):"0";
$wppm_current_user_capability = get_user_meta( $current_user->ID, 'wppm_capability', true );
$wppm_hide_completed_status_task = get_option('wppm_hide_completed_status_task');
$wppm_hide_task_statuses_from_frontend = get_option('wppm_hide_task_statuses_from_frontend');
if(!empty($wppm_hide_task_statuses_from_frontend)){
  $wppm_hide_task_statuses_from_frontend = explode(",",$wppm_hide_task_statuses_from_frontend);
} else {
  $wppm_hide_task_statuses_from_frontend = '';
}
$filters = array(
	'search' => $search_tag,
	'filter'=>$filter_by,
	'proj_filter'=>$proj_filter
);
$grid_view_filter = $filters ;
$tl_filters = isset( $_COOKIE['wppm_grid_view_filters'] ) ? sanitize_text_field( wp_unslash( $_COOKIE['wppm_grid_view_filters'] ) ) : $grid_view_filter;
$current_date = date('Y-m-d');
$proj_attr = isset($_POST['wppm_project_attr']) ? sanitize_text_field($_POST['wppm_project_attr']):"";
$archived_where = "";
if ( isset($page) && $page === 'wppm-archived-tasks' ) {
  $archived_where = " AND is_archived = 1";
}
if( isset($page) && $page === 'wppm-tasks'){
  $archived_where = " AND is_archived = 0";
}
if(!empty($proj_attr )){
  $proj_attr = esc_sql($proj_attr);
  $wppm_proj_attr = ' AND (proj.project_name = "'.$proj_attr.'")';
}else{
  $wppm_proj_attr = '';
}
$query = ("SELECT proj.*
		FROM {$wpdb->prefix}wppm_project AS proj
		Left join {$wpdb->prefix}wppm_project_meta proj_meta ON proj.id = proj_meta.project_id");
$santitize_order_by = esc_sql(sanitize_sql_orderby( "project_name ASC" ));
if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin'){
	if(!empty($proj_attr )){
		$proj_attr = esc_sql($proj_attr);
		$where = " where project_name = '".$proj_attr."' Group by proj.id ORDER BY '$santitize_order_by'";
	}else{
		if(!empty($public_projects)){
			$where = " where proj.id = proj_meta.project_id AND proj_meta.meta_key='public_project' AND proj_meta.meta_value=1 Group by proj.id ORDER BY '$santitize_order_by'";
		}else{
			$where = " Group by proj.id ORDER BY '$santitize_order_by'";
		}
	}
}else{
	if(!empty($public_projects)){
		$where =  " where (proj.id = proj_meta.project_id AND proj_meta.meta_key='public_project' AND proj_meta.meta_value=1) $wppm_proj_attr Group by proj.id ORDER BY '$santitize_order_by'";
	} else{
		$where =  " where ((FIND_IN_SET($current_user->ID,proj.users)) OR (proj.id = proj_meta.project_id AND proj_meta.meta_key='public_project' AND proj_meta.meta_value=1) OR ( proj.created_by='$cu_id')) $wppm_proj_attr Group by proj.id ORDER BY '$santitize_order_by'";
	}
}
$where = apply_filters('wppm_project_filter_in_task_list_grid_view_where',$where);
$query.= $where;
$projects = $wpdb->get_results($query);
$wppm_tl_filter = "1=1";
if(!is_array($tl_filters)){
	$tl_filters  = json_decode($tl_filters);
	$tl_filters_arr = (array) $tl_filters;
} else{
$tl_filters_arr = $filters;
}
$search_tag = isset($_POST['task_search']) ? sanitize_text_field($_POST['task_search']) : $tl_filters_arr['search'];
$filter_by = isset($_POST['wppm_task_filter']) ? sanitize_text_field($_POST['wppm_task_filter']) : $tl_filters_arr['filter'];
$proj_filter = isset($_POST['wppm_proj_filter']) ? sanitize_text_field($_POST['wppm_proj_filter']) : $tl_filters_arr['proj_filter'];
$filters = array(
	'search'=>$search_tag,
	'filter'=>$filter_by,
	'proj_filter' =>$proj_filter
);
setcookie('wppm_grid_view_filters',wp_json_encode( $filters ),time() + 3600);
if($filter_by=='all'){
  if($wppm_hide_completed_status_task == 0){
     $wppm_tl_filter = "Task.status!='4'";
  }
}
if($filter_by=='4'){
	$wppm_tl_filter = "Task.status='4'";
}elseif($filter_by=='overdue'){
	$wppm_tl_filter = "Task.status!='4' AND (CAST(Task.end_date AS DATE)) < '$current_date'";
}elseif($filter_by == 'unassigned'){
	$wppm_tl_filter = "Task.users=''";
}elseif($filter_by == '1'){
	$wppm_tl_filter = "Task.status='1'";
}elseif($filter_by == '2'){
	$wppm_tl_filter = "Task.status='2'";
}elseif($filter_by == '3'){
	$wppm_tl_filter = "Task.status='3'";
}elseif($filter_by == 'mine'){
	$wppm_tl_filter = "(FIND_IN_SET('$current_user->ID',Task.users)>0)";
}elseif($filter_by == 'archived'){
  $wppm_tl_filter = "Task.is_archived = 1";
}

if(!empty($wppm_hide_task_statuses_from_frontend) && is_array($wppm_hide_task_statuses_from_frontend) && (isset($_POST['is_frontend']) && sanitize_text_field($_POST['is_frontend'])==1)){
  foreach($wppm_hide_task_statuses_from_frontend as $status){
    $wppm_tl_filter .= " AND Task.status != '$status'";
  }
}

if($proj_filter!=0){
	$wppm_task_by_proj_filter = "Task.project = ".esc_sql($proj_filter)."";
}else{
	$wppm_task_by_proj_filter ="1=1";
}
if(!empty($task_status)){
	foreach($task_status as $status) {
		$status_id = esc_sql($status->id);
		if(!empty($search_tag)){
			$search_tag_text = '%'.$wpdb->esc_like($search_tag).'%';
			if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin'){
				$query = ("SELECT Task.*
							FROM {$wpdb->prefix}wppm_task AS Task
							Left join {$wpdb->prefix}wppm_project proj ON Task.project = proj.id
							Left join {$wpdb->prefix}wppm_task_statuses task_statuses ON Task.status = task_statuses.id
							Left join {$wpdb->prefix}wppm_task_priorities task_priorities ON Task.priority = task_priorities.id
							Left join {$wpdb->base_prefix}users user ON (FIND_IN_SET(user.id,Task.users)>0) AND user.display_name LIKE '$search_tag_text'
							Left join {$wpdb->prefix}wppm_project_meta proj_meta ON Task.project = proj_meta.project_id
						");
				$no_of_rows = ( "SELECT count(*) FROM ($query");
				if(!empty($public_projects)){
					$where = " where (proj_meta.meta_key='public_project' AND proj_meta.meta_value=1) AND $wppm_tl_filter AND $wppm_task_by_proj_filter AND (Task.task_name LIKE '$search_tag_text' OR proj.project_name LIKE '$search_tag_text' OR task_statuses.name LIKE '$search_tag_text' OR task_priorities.name LIKE '$search_tag_text' OR user.display_name LIKE '$search_tag_text') AND Task.status='$status_id' ";
				}else{
					$where = " where $wppm_tl_filter AND $wppm_task_by_proj_filter AND (Task.task_name LIKE '$search_tag_text' OR proj.project_name LIKE '$search_tag_text' OR task_statuses.name LIKE '$search_tag_text' OR task_priorities.name LIKE '$search_tag_text' OR user.display_name LIKE '$search_tag_text') AND Task.status='$status_id' ";
				}
			} else{
				$query = ("SELECT Task.*
					FROM {$wpdb->prefix}wppm_task AS Task
					Left join {$wpdb->prefix}wppm_project proj ON Task.project = proj.id
					Left join {$wpdb->prefix}wppm_task_statuses task_statuses ON Task.status = task_statuses.id
					Left join {$wpdb->prefix}wppm_task_priorities task_priorities ON Task.priority = task_priorities.id
					Left join {$wpdb->prefix}wppm_project_users proj_users ON Task.project = proj_users.proj_id
					Left join {$wpdb->base_prefix}users user ON (FIND_IN_SET(user.id,Task.users)>0) AND user.display_name LIKE '$search_tag_text'
					Left join {$wpdb->prefix}wppm_project_meta proj_meta ON Task.project = proj_meta.project_id
					");
				$no_of_rows = ( "SELECT count(*) FROM ($query");
				if(!empty($public_projects)){
					$where = " where (proj_meta.meta_key='public_project' AND proj_meta.meta_value=1) AND $wppm_tl_filter AND $wppm_task_by_proj_filter AND (Task.task_name LIKE '$search_tag_text' OR proj.project_name LIKE '$search_tag_text' OR task_statuses.name LIKE '$search_tag_text' OR task_priorities.name LIKE '$search_tag_text' OR user.display_name LIKE '$search_tag_text')) AND Task.status= '$status_id'";
				}else{
					$where = " where $wppm_tl_filter AND $wppm_task_by_proj_filter AND (((FIND_IN_SET('$current_user->ID',Task.users)>0) OR (Task.created_by= '$cu_id') OR (proj_users.user_id = '$cu_id' AND proj_users.role_id = 1 AND (FIND_IN_SET('$current_user->ID',proj.users)>0)) OR (Task.project = proj_meta.project_id AND proj_meta.meta_key='public_project' AND proj_meta.meta_value=1) OR proj.created_by='$cu_id') AND (Task.task_name LIKE '$search_tag_text' OR proj.project_name LIKE '$search_tag_text' OR task_statuses.name LIKE '$search_tag_text' OR task_priorities.name LIKE '$search_tag_text' OR user.display_name LIKE '$search_tag_text')) AND Task.status= '$status_id'";
				}
			}
		}else{
			if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin'){
				$query = ( "SELECT Task.* FROM {$wpdb->prefix}wppm_task AS Task
							Left join {$wpdb->prefix}wppm_project proj ON Task.project = proj.id
							Left join {$wpdb->prefix}wppm_project_meta proj_meta ON Task.project = proj_meta.project_id
				");
				$no_of_rows = ( "SELECT count(*) FROM ($query");
				if(!empty($public_projects)){
					$where = " where (proj_meta.meta_key='public_project' AND proj_meta.meta_value=1) AND $wppm_tl_filter AND $wppm_task_by_proj_filter AND Task.status= '$status_id'";
				}else{
					$where = " where $wppm_tl_filter AND $wppm_task_by_proj_filter AND Task.status= '$status_id'";
				}
			}else{
				$query = ( "SELECT Task.*
					FROM {$wpdb->prefix}wppm_task AS Task
					Left join {$wpdb->prefix}wppm_project proj ON Task.project = proj.id
					Left join {$wpdb->prefix}wppm_project_users proj_users ON Task.project = proj_users.proj_id
					Left join {$wpdb->prefix}wppm_project_meta proj_meta ON Task.project = proj_meta.project_id
					");
				$no_of_rows = ( "SELECT count(*) FROM ($query");
				if(!empty($public_projects)){
					$where = " where (proj_meta.meta_key='public_project' AND proj_meta.meta_value=1) AND $wppm_tl_filter AND $wppm_task_by_proj_filter AND Task.status= '$status_id'";
				} else{
					$where = " where $wppm_tl_filter AND $wppm_task_by_proj_filter AND ((FIND_IN_SET('$current_user->ID',Task.users)>0) OR (Task.created_by= '$cu_id') OR (proj_users.user_id = '$cu_id' AND proj_users.role_id = 1 AND (FIND_IN_SET('$current_user->ID',proj.users)>0)) OR (Task.project = proj_meta.project_id AND proj_meta.meta_key='public_project' AND proj_meta.meta_value=1) OR proj.created_by='$cu_id') AND Task.status= '$status_id'";
				}
			}
		} 
		$query = apply_filters('wppm_query_for_grid_view',$query);
		$no_of_rows = apply_filters('wppm_number_of_rows_query_for_grid_view',$no_of_rows);
		$where.= $wppm_proj_attr;
		if($filter_by != 'archived'){
			$where .= $archived_where;
		}
		$where = apply_filters('wppm_task_list_where_for_grid_view',$where,$wppm_tl_filter,$search_tag);
		$no_of_rows .= $where;
		$no_of_rows .= " Group by Task.id) AS Task";
		$no_of_rows = apply_filters('wppm_task_list_no_of_rows_for_grid_view',$no_of_rows);
		$totalrows = $wpdb->get_var($no_of_rows);
		$totalrows_tasks +=$totalrows;
		if($total_no_of_rows > $totalrows){
			$totalrows = $total_no_of_rows;
		}else{
			$total_no_of_rows = $totalrows;
		}
		$limit_start=$page_no*$task_per_page;
		$limit="\n LIMIT ".$limit_start.",".$task_per_page." ";
		$current_page=$page_no+1;
		$query = apply_filters('wppm_tasks_grid_view_query',$query,$search_tag);
		$where .= " Group by Task.id";
		$query .= $where;
		$query = apply_filters('wppm_task_list_grid_view_query',$query);
		$query = $query.$limit;
		$wppm_task_fillter[] = $wpdb->get_results($query);
	}
	$total_pages=ceil($total_no_of_rows/$task_per_page);
	$prev_page_no=$current_page-1;
	$prev_class=(!$prev_page_no)?'disabled':'';
	$next_page_no=($total_pages==$current_page)? $current_page-1:$current_page;
	$next_class=($total_pages==$current_page)?'disabled':'';
	$flag = false;
	if(!empty($wppm_task_fillter)){
		foreach($wppm_task_fillter as $key_filter=>$val_filter){
			foreach($val_filter as $key=>$val){
				$val_array = (array) $val;
				$tusers =  $val_array['users'];
				$tusers_arr = explode(',',$tusers);
				$tproject_id = esc_sql($val_array['project']);
				if(!empty($tusers) && in_array($current_user->ID,$tusers_arr)){
					$project_user_role = $wpdb->get_var("SELECT role_id FROM {$wpdb->prefix}wppm_project_users WHERE proj_id = '$tproject_id' AND user_id = '$cu_id'");
					$project_users = $wpdb->get_var("SELECT users FROM {$wpdb->prefix}wppm_project WHERE id = '$tproject_id'");
					$project_users_arr = explode(',',(string)$project_users);
					if((!empty($project_user_role)) && ($project_user_role == 1) && in_array($current_user->ID,$project_users_arr)){
						$flag = true;
						break;
					}
				}
			}
		}
	}
}
$todo_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_task_statuses where id='".esc_sql(1)."'" );
$inp_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_task_statuses where id='".esc_sql(2)."'" );
$hold_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_task_statuses where id='".esc_sql(3)."'" );
$completed_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_task_statuses where id='".esc_sql(4)."'" );
$todo_status_style = (!empty($todo_status_name))? "display:inline" :"display:none;";
$inp_status_style = (!empty($inp_status_name))? "display:inline" :"display:none;";
$hold_status_style = (!empty($hold_status_name))? "display:inline" :"display:none;";
$completed_status_style = (!empty($completed_status_name))? "display:inline" :"display:none;";
if( isset($page) && $page === 'wppm-tasks'){
 $arch_filter_style = "display:inline;";
}else{
  $arch_filter_style = "display:none;";
}

if ( isset($page) && $page === 'wppm-archived-tasks' ) {
  $ar_filter_style = "display:none;";
} else {
  $ar_filter_style = "display:flex;";
}
?>
<form name="wppm_view_project_task" id="wppm_view_project_task">
	<div class="row">
		<div class="col-sm-12">
			<?php 
			if(($current_user->has_cap('manage_options') || $wppmfunction->has_permission('add_new_task',0) || $wppm_current_user_capability=='wppm_manager'|| ($flag==true)) && (isset($page) && $page != 'wppm-archived-tasks' )){
				$style = "display:inline;";
			}else{
				$style = "display:none;";
			}
			$style = apply_filters('wppm_add_new_task_btn_style_grid_view',$style);
			?>
			<span class="wppm-heading-inline"><?php echo (isset($page) && $page === 'wppm-archived-tasks' ) ? esc_html_e('Archived Tasks','taskbuilder'): esc_html_e('Tasks','taskbuilder');?> </span>
			<span class="wppm-add-new-btn btn-primary" onclick="wppm_add_new_task()" style="background-color:<?php echo esc_attr($appearance_settings['menu-button-bg-color'])?>;color:<?php echo esc_attr($appearance_settings['menu-button-text-color'])?>;<?php echo esc_attr($style) ?>;"><img class="wppm_add_new_task_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/plus_icon.svg'); ?>" alt="add"><?php echo esc_html_e('Add New','taskbuilder');?></span>
			<span class="wppm-add-new-btn btn-primary" style="background-color:<?php echo esc_attr($appearance_settings['menu-button-bg-color'])?>; id="wppm_task_list" onclick="wppm_get_task_list()" ><span><img class="wppm_task_list_image" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/list-symbol.svg'); ?>" alt="list"></span><span style="color:<?php echo esc_attr($appearance_settings['menu-button-text-color'])?>"><?php echo esc_html_e('Task List','taskbuilder');?></span></span>
		</div>
	</div>
	<div style="display:flex;justify-content:space-between;margin-top: 20px;flex-wrap: wrap;">
      	<div style="display:flex;flex-wrap: wrap;">
			<div id="wppm_task_filter_container">
				<div class="wppm-filter-item">
					<label for="wppm_task_filter"> <?php echo esc_html_e('Filter','taskbuilder');?></label>
					<select id="wppm_task_filter" name="wppm_task_filter" onchange="wppm_apply_task_filter_grid_view('<?php echo esc_attr($page)?>')" class="form-control">
					<option value="all"<?php echo ($filter_by == "all")? 'selected':""?>><?php echo esc_html_e('All','taskbuilder');?></option>
					<option value="1" style="<?php echo $todo_status_style ?>" <?php echo ($filter_by == "1")? 'selected':""?>><?php echo  esc_html_e($todo_status_name,'taskbuilder');?></option>
					<option value="2" style="<?php echo $inp_status_style ?>" <?php echo ($filter_by == "2")? 'selected':""?>><?php echo  esc_html_e($inp_status_name,'taskbuilder');?></option>
					<option value="3" style="<?php echo $hold_status_style ?>" <?php echo ($filter_by == "3")? 'selected':""?>><?php echo  esc_html_e($hold_status_name,'taskbuilder');?></option>
					<option value="4" style="<?php echo $completed_status_style ?>" <?php echo ($filter_by == "4")? 'selected':""?>><?php echo  esc_html_e($completed_status_name,'taskbuilder');?></option>
					<option value="mine" <?php echo ($filter_by == "mine")? 'selected':""?>><?php echo  esc_html_e('Mine','taskbuilder');?></option>
					<option value="unassigned" <?php echo ($filter_by == "unassigned")? 'selected':""?>><?php echo  esc_html_e('Unassigned','taskbuilder');?></option>
					<option value="overdue" <?php echo ($filter_by == "overdue")? 'selected':""?>><?php echo  esc_html_e('Overdue','taskbuilder');?></option>
					<option value="archived" style="<?php echo $arch_filter_style ?>" <?php echo ($filter_by == "archived")? 'selected':""?>><?php echo  esc_html_e('Archived','taskbuilder');?></option>
					</select>
				</div>
				<div class="wppm-filter-item wppm_project_autocomplete_container">
					<label for="wppm_task_list_proj_filter">
						<?php echo esc_html_e('Project','taskbuilder');?>
					</label><br>
					<select searchable="search here" onchange="wppm_tasks_by_select_project_grid_view('<?php echo esc_attr($page)?>')" class="form-control" size="40" name="wppm_task_list_proj_filter" id="wppm_task_list_proj_filter">
						<option value="0" <?php echo ($proj_filter == 0)? 'selected':""?>><?php echo esc_html_e('All','taskbuilder');?></option>
						<?php 
							if(!empty($projects)){
								foreach($projects as $proj) { 
									?>
									<option value="<?php echo esc_attr($proj->id)?>" <?php echo ($proj_filter == $proj->id)? 'selected':""?>><?php echo esc_html_e($proj->project_name,'taskbuilder');?></option>
							<?php } 
							} ?>
					</select>
				</div>
				<div class="wppm_display_submit">
					<div class="wppm-filter-actions">
						<span class="wppm-link" onclick="wppm_tl_reset_grid_view_filter('<?php echo esc_attr($page)?>')"> <?php echo esc_html_e('Reset','taskbuilder');?></span>
					</div>
				</div>
			</div>
		</div>
		<div id="wppm_task_search" style="display:flex;justify-content:flex-end;">
          <img width="25px" height="15" class="wppm_task_search_filter_img" style="position: relative;top: 10px;left: 30px;" height="15px" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/search.svg'); ?>" alt="search">
          <input type="search" id="wppm_view_task_search_filter" style="margin-right:10px;" name="wppm_view_task_search_filter" class="form-control form-control-sm" aria-controls="selection-datatable" placeholder="<?php echo esc_attr__('Search','taskbuilder');?>" value="<?php echo (!empty($search_tag)) ? esc_attr($search_tag) : "" ?>">
        </div>
	</div>
	<div style="display:flex;justify-content:flex-end;margin-right:10px;">
		<span id="wppm_list_view_btn" style="margin: 0 0 -30px 0;" onclick="wppm_get_task_list()"><img src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/listv.svg'); ?>" alt="list"><span style="margin-left:5px;"><?php echo esc_html_e('List view','taskbuilder');?></span></span>
	</div>
	<div class="wppm_task_container" id="wppm_task_container" style="display:flex;">
		<?php 
		if(!empty($task_status)){
			foreach($task_status as $status) {
				?>
				<div class="wppm_task_list" id="wppm_task_list_<?php echo esc_attr($status->id)?>" style="display:flex;justify-content:space-between;flex-direction: column;flex-basis: 20%;">
					<div>
						<div style="background-color:<?php echo esc_attr($status->bg_color)?>;color:<?php echo esc_attr($status->color);?>;padding:5px;"> 
							<span class="wppm_status_name"><?php echo esc_html_e($status->name,'taskbuilder');?></span>
							<span class="wppm_add_new_icon" onclick="wppm_add_new_task()"><img src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/add_new1.svg'); ?>" alt="add"></span>
						</div>
					</div>
					<div id="wppm_card_body_container_<?php echo esc_attr($status->id) ?>" style="height:100%;">
					<?php
					$total_checklist_items=0;
					$total_checked_items=0;
					$task_per_status = false;
					$total_tasks = 0;
					if(!empty($wppm_task_fillter)){
						foreach($wppm_task_fillter as $key=>$tasks){
							foreach($tasks as $task){
								$total_tasks++;
								if((!empty($task)) && $task->status==$status->id){
									$task_per_status = true;
									if(isset($task->priority)){
										$tpriority = esc_sql($task->priority);
										$task_priority = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_task_priorities where id = '$tpriority'" );
									}
									if($wppm_task_time == 1){
										$task_end_date = $task->end_date;
										$teDate = new DateTime($task->end_date);
										if($task->end_date=='0000-00-00 00:00:00'){
											if($wppm_date_setting=='Y-m-d H:i:s'){
												$task_end_date = '0000-00-00 00:00:00';
											}elseif($wppm_date_setting=='d-m-Y H:i:s'){
												$task_end_date = '00-00-0000 00:00:00';
											}elseif($wppm_date_setting=='m-d-Y H:i:s'){
												$task_end_date = '00-00-0000 00:00:00';
											}else{
												$task_end_date = '0000-00-00 00:00:00';
											}
										}else{
											$task_end_date = $teDate->format($wppm_date_setting);
										}
									}elseif($wppm_task_time == 0){
										$teDate = new DateTime($task->end_date);
										$task_end_date = $teDate->format('Y-m-d');
										if($task->end_date=='0000-00-00 00:00:00'){
											if($wppm_date_setting=='Y-m-d H:i:s'){
											$task_end_date = '0000-00-00';
											}elseif($wppm_date_setting=='d-m-Y H:i:s'){
											$task_end_date = '00-00-0000';
											}elseif($wppm_date_setting=='m-d-Y H:i:s'){
											$task_end_date = '00-00-0000';
											}else{
											$task_end_date = '0000-00-00';
											}
										}else{
											if($wppm_date_setting=='Y-m-d H:i:s'){
											$task_end_date = $teDate->format('Y-m-d');
											}elseif($wppm_date_setting=='d-m-Y H:i:s'){
											$task_end_date = $teDate->format('d-m-Y');
											}elseif($wppm_date_setting=='m-d-Y H:i:s'){
											$task_end_date = $teDate->format('m-d-Y');
											}else{
											$task_end_date = $teDate->format('Y-m-d');
											}
										}
									}
									if(!empty($task->id)){
										$tid = esc_sql( $task->id);
										$checklists = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}wppm_checklist where task_id = '$tid'" );
										$total=$wpdb->get_var("SELECT COUNT(Items.id) AS check_id
											FROM {$wpdb->prefix}wppm_checklist_items AS Items
											Left join {$wpdb->prefix}wppm_checklist checklist ON Items.checklist_id = checklist.id
											WHERE checklist.task_id = '$tid'");
										$total_checked_items=$wpdb->get_var("SELECT COUNT(Items.id) AS check_id
											FROM {$wpdb->prefix}wppm_checklist_items AS Items
											Left join {$wpdb->prefix}wppm_checklist checklist ON Items.checklist_id = checklist.id
											WHERE checklist.task_id = '$tid' AND Items.checked=1");
										$project_data = $wppmfunction->get_project($task->project);
										?>
										<div class="wppm_card_body" style="background-color:<?php echo esc_attr($appearance_settings['grid-background-color'])?>!important;color:<?php echo esc_attr($appearance_settings['grid-header-text-color'])?>!important;" onclick="wppm_open_task(<?php echo esc_attr($task->id)?>)" id="wppm_draggable_card_<?php echo esc_attr($task->id)?>">
											<div>
												<div>
													<span class="wppm_td_task_priority" style="background-color:<?php echo (!empty($task_priority->bg_color))? esc_attr($task_priority->bg_color):"";?>;color:<?php echo (!empty($task_priority->color))? esc_attr($task_priority->color):"";?>"><?php echo (!empty($task_priority->name))? esc_html($task_priority->name):"" ?></span>
												</div>
												<div class="wppm_card_task_action">
													<span class="wppm_checklist_total_checked_item"><?php echo esc_html($total_checked_items.'/'.$total)?></span><span class="wppm_total_checked_item"><img src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/checked.svg'); ?>" alt="checked"></span>
													<span class="wppm_show_dropdown_menu" onclick="wppm_show_dropdown_menu(<?php echo esc_attr($task->id);?>)" data-popover="wppm-dropdown-menu-<?php echo esc_attr($task->id);?>" id="wppm_task_action_<?php echo esc_attr($task->id);?>"><img src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/vertical_dot.svg'); ?>" alt="vertical_dot"></span>
													<div class="gpopover" id="wppm-dropdown-menu-<?php echo esc_attr($task->id);?>">
														<a class="dropdown-item" href="#"><?php echo esc_html_e('Edit','taskbuilder');?></a>
														<a class="dropdown-item" href="#"><?php echo esc_html_e('Delete','taskbuilder');?></a>
													</div>
												</div>
											</div>
											<div>
												<div>
													<span class="wppm_task_name_grid_view" style="margin-left: 5px;"><?php echo esc_html_e($task->task_name,'taskbuilder');?></span> 
													<span class="wppm_proj_name_grid_view">(<?php echo isset($project_data['project_name']) ? esc_html_e($project_data['project_name'],'taskbuilder'):"";?>)</span> 
												</div>
											</div>
											<div>
												<div class="wppm_task_due_date_grid_view" style="margin-left: 5px;">
												<?php $style = ($task->status!=4 && $task->end_date < $current_date) ? "color:#FF0000":"color:#2C3E50"; ?>
													<small style="<?php echo esc_attr($style); ?>"><?php echo (isset($task_end_date))? esc_html_e($task_end_date,'taskbuilder') :"" ?></small>
												</div> 
												<div class="wppm_card_task_users" style="text-align:right;">
													<?php
													$task_users = explode(',',$task->users);
													$i=0;
													if(!empty($project_data['users'])){
														$proj_users = explode(',',$project_data['users']);
													}
													if(!empty($task_users)){
														foreach($task_users as $user){
															if( (!empty($proj_users)) && (in_array($user,$proj_users))){ 
																$i++;
																if( $i <= 4 ){
																	if(!empty($user)){
																		$userdata = get_userdata( $user );
																		?>
																		<a href="#"  title="<?php echo esc_attr($userdata->display_name)?>">
																			<?php echo get_avatar($user, 25, "mysteryman");?>
																		</a>
																<?php } 
																}
															}
														}
													}
													if($i > 4){
														?>
															<a href="#" class="wppm_avatar">
															<span id="wppm_avatar" style="background-color:black;" class="avatar">+<?php echo esc_html($i-4) ?></span>
															</a>
													<?php } ?>
												</div>
											</div>
										</div>
										<?php
									}
								}
							}
						} 
					}
					if($task_per_status==false){
						?>
						<div>
							<div style="margin-left:5px;font-family: 'OpenSans-Semibold', 'Helvetica Neue', Arial, Helvetica, sans-serif; font-size: 14px;">
								<?php echo esc_html_e('Empty','taskbuilder'); ?>
							</div>
						</div>
						<?php
					}
					?>
					</div>
				</div>
			<?php } 
		}
		?>
		<input type="hidden" action="wppm_drag_and_drop_card">
		<input type="hidden" name="wppm_drag_and_drop_card_ajax_nonce" id="wppm_drag_and_drop_card_ajax_nonce" value="<?php echo esc_attr( wp_create_nonce( 'wppm_drag_and_drop_card' ) ); ?>">
	</div>
	<div class="row wppm_task_pagination_container">
		<div class="col-sm-4">
			<?php echo esc_html_e('Total:','taskbuilder'); ?>&nbsp;<?php echo esc_html($total_tasks); ?>&nbsp;<?php echo esc_html_e( 'of','taskbuilder') ?>&nbsp;<?php echo esc_html($totalrows_tasks) ?>&nbsp;<?php echo esc_html_e('Tasks','taskbuilder')?>
		</div>
		<div class="wppm_task_pagination col-sm-4" style="<?php echo (esc_attr($total_pages)==0)? "display:none;":"display:flex;"?>">
			<span class="wppm-pagination-txt">
				<span><?php echo esc_html($current_page)?>&nbsp;<?php echo esc_html_e('of','taskbuilder');?>&nbsp;<?php echo esc_html($total_pages); ?>&nbsp;<?php echo esc_html_e('Page','taskbuilder'); ?></span>
			</span>
			<span <?php echo esc_attr($prev_class) ?> 
			style="<?php echo (isset($prev_class) && esc_attr($prev_class) == 'disabled') ? 'display:none;':'display:block;'?>cursor:pointer;">
			<a class="wppm_pagination_prev" onclick="return wppm_load_prev_task_page_card_view(<?php echo esc_attr($prev_page_no) ?>,<?php echo esc_attr($page_no)?>);"><?php echo esc_html_e('PREV','taskbuilder');?></a>
			</span>
			<span <?php echo esc_attr($next_class) ?>
			style="<?php echo (isset($next_class) && esc_attr($next_class) == 'disabled')?'display:none;':'display:block;'?>cursor:pointer;">
			<a class="wppm_pagination_next" onclick="return wppm_load_next_task_page_card_view(<?php echo esc_attr($next_page_no) ?>,<?php echo esc_attr($page_no) ?>);"><?php echo esc_html_e('NEXT','taskbuilder');?></a>
			</span>
		</div>
	</div>
</form>
<style>
	.select2-selection--single {
		height: 30px!important;
	}
	.select2-dropdown:hover {
    	color: #23527c!important;;
	}
	.select2-results__options{
		font:15px "Helvetica Neue",Arial,Helvetica,sans-serif !important;
		margin: 0!important;
		line-height: inherit!important;
	}
	.select2-selection__rendered{
		font:15px "Helvetica Neue",Arial,Helvetica,sans-serif !important;
		margin-top: 5px!important;
	}
	.select2-selection__rendered:hover{
		color: #2271b1 !important;
	}
	.select2-container--default .select2-results__option--highlighted.select2-results__option--selectable{
		background-color: #e85f08!important;
		color: white !important;
	}
	.select2-container {
		max-width: 150px !important;
		min-width: 150px !important;
	}
	#wppm_task_filter{
		min-height: 30px !important;
    	max-height: 35px !important;
	}
	#wppm_view_project_task .wppm-add-new-btn:hover{
		background-color: <?php echo esc_attr($appearance_settings['menu-button-hover-color'])?>!important;
	}
</style>
<script type="text/javascript">
	jQuery( document ).ready( function( jQuery ) {
		dragula([
			<?php foreach($task_status as $status) { ?>
				document.getElementById("wppm_card_body_container_<?php echo esc_attr($status->id) ?>"),
			<?php } ?>
		], {removeOnSpill: false})
		.on('drop', function (el,target,source) { 
			wppm_drag_drop_card(el,target,source);
		});
	
		jQuery("input[name='wppm_view_task_search_filter']").keypress(function(e) {
			//Enter key
			if (e.which == 13) {
				e.preventDefault();
				wppm_display_grid_view('<?php echo esc_js($page) ?>');
			}
		});
  	}) 
	function wppm_show_dropdown_menu(task_id){
		jQuery("#wppm_task_action_"+task_id).gpopover({width: 50});
	}

	function wppm_drag_drop_card(el,target,source){
		var data = {
			action: 'wppm_drag_and_drop_card',
			el:el.id,
			target: target.id,
			source:source.id,
			_ajax_nonce:jQuery("#wppm_drag_and_drop_card_ajax_nonce").val()
		};
		jQuery.post(wppm_admin.ajax_url, data, function(response) {
			wppm_display_grid_view('<?php echo esc_js($page) ?>');
		});
	}
	jQuery('#wppm_task_list_proj_filter').select2({ dropdownAutoWidth: true, width: 'auto' });
  	jQuery('#wppm_task_list_proj_filter').val(<?php echo esc_attr($proj_filter) ?>);

</script>