taskbuilder / includes / admin / projects / open_project / wppm_get_project_tasks.php

wppm_get_project_tasks.php in Taskbuilder – Project Management & Task Management Tool With Kanban Board 5.0.2, at includes/admin/projects/open_project/wppm_get_project_tasks.php

160 lines 8.9 KB

Raw Download Zip

1	<?php
2	if ( ! defined( 'ABSPATH' ) ) {
3	exit; // Exit if accessed directly
4	}
5	global $current_user,$wpdb,$wppmfunction;
6	$project_id = isset($_POST['id']) ? intval(sanitize_text_field($_POST['id'])) : 0 ;
7	$project_id = esc_sql($project_id);
8	$cu_id = esc_sql($current_user->ID);
9	$appearance_settings = get_option("wppm-ap-task-list");
10	$wppm_task_time = get_option('wppm_task_time');
11	$wppm_current_user_capability = get_user_meta( $current_user->ID, 'wppm_capability', true );
12	if($current_user->has_cap('manage_options') \|\| $wppm_current_user_capability=='wppm_admin'){
13	$query = ( "SELECT * FROM {$wpdb->prefix}wppm_task where project='$project_id'");
14	} else{
15	$query = ( "SELECT Task.*
16	FROM {$wpdb->prefix}wppm_task AS Task
17	Left join {$wpdb->prefix}wppm_project proj ON Task.project = proj.id
18	Left join {$wpdb->prefix}wppm_project_users proj_users ON Task.project = proj_users.proj_id
19	Left join {$wpdb->prefix}wppm_project_meta proj_meta ON Task.project = proj_meta.project_id
20	where Task.project = '$project_id' AND ((FIND_IN_SET('$cu_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('$cu_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 (Task.project = proj.id AND proj.created_by='$cu_id')) Group by Task.id");
21	}
22	$query = apply_filters('wppm_get_project_tasks_query',$query,$project_id);
23	$tasks = $wpdb->get_results($query);
24	ob_start();
25	?>
26	<form id="wppm_get_project_tasks_frm" name="wppm_get_project_tasks_frm">
27	<div class="table-responsive">
28	<table id="tbl_project_tasks" class="table table-striped table-bordered" cellspacing="0" width="100%">
29	<thead>
30	<tr>
31	<th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>;color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Task id','taskbuilder');?> </th>
32	<th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>;color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>" <?php echo esc_attr($appearance_settings['list-header-text-color'])?>><?php echo esc_html_e('Task Name','taskbuilder');?> </th>
33	<th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>;color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Task Status','taskbuilder');?> </th>
34	<th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>;color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Task Priority','taskbuilder');?> </th>
35	<th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>;color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Assign To','taskbuilder');?> </th>
36	<th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>;color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Start Date','taskbuilder');?> </th>
37	<th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>;color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('End Date','taskbuilder');?> </th>
38	</tr>
39	</thead>
40	<tbody>
41	<?php
42	if(!empty($tasks)){
43	foreach ($tasks as $task) {
44	$tstatus = esc_sql($task->status);
45	$status = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_task_statuses where id = '$tstatus'" );
46	$users = array();
47	if($task->users != null){
48	$users = explode(",",$task->users);
49	}
50	if(!empty($task->priority)){
51	$tpriority = esc_sql($task->priority);
52	$priority = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_task_priorities where id = '$tpriority'" );
53	}
54	if(!empty($task->project)){
55	$tproject = esc_sql($task->project);
56	$project = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_project where id = '$tproject'" );
57	}
58	if($wppm_task_time == 1){
59	$task_start_date = $task->start_date;
60	$task_end_date = $task->end_date;
61	} elseif($wppm_task_time == 0){
62	$tsDate = new DateTime($task->start_date);
63	$teDate = new DateTime($task->end_date);
64	$task_start_date = $tsDate->format('Y-m-d');
65	$task_end_date = $teDate->format('Y-m-d');
66	}
67	?>
68	<tr onclick= "wppm_open_project_tasks(<?php echo esc_attr($task->id) ?>,<?php echo esc_attr($task->project) ?>)" >
69	<td>
70	<?php echo esc_html_e($task->id,'taskbuilder') ?>
71	</td>
72	<td>
73	<?php echo esc_html_e($task->task_name,'taskbuilder') ?>
74	</td>
75	<td>
76	<span class="wppm_td_task_status" style="background-color:<?php echo (isset($status->bg_color))? esc_attr($status->bg_color):"";?>; color: <?php echo (isset($status->color))? esc_attr($status->color):""; ?>"><?php echo (isset($status->name))? esc_html_e($status->name,'taskbuilder'):"" ?></span>
77	</td>
78	<td>
79	<span class ="wppm_td_task_priority" style="background-color:<?php echo (isset($priority->bg_color))? esc_attr($priority->bg_color):"";?>; color: <?php echo (isset($priority->color))? esc_attr($priority->color):""; ?>"><?php echo (isset($priority->name))? esc_html_e($priority->name,'taskbuilder'):"" ?></span>
80	</td>
81	<td>
82	<?php
83	$i=0;
84	if(!empty($users)){
85	foreach($users as $user){
86	$i++;
87	if( $i <= 4 ){
88	$userdata = get_userdata( $user ); ?>
89	<a href="#" title="<?php echo esc_attr($userdata->display_name) ?>">
90	<?php echo (get_avatar($userdata->ID, 25, "mysteryman"))?>
91	</a> <?php
92	}
93	}
94	} else {
95	_e('None','taskbuilder');
96	}
97	if($i > 4){
98	?>
99	<a href="#" class="wppm_avatar">
100	<span id="wppm_avatar" style="background-color:black;" class="avatar">+<?php echo esc_html($i-4) ?></span>
101	</a>
102	<?php } ?>
103	</td>
104	<td>
105	<?php echo (isset($task_start_date))? esc_html_e($task_start_date,'taskbuilder'):""?>
106	</td>
107	<td>
108	<?php echo (isset($task_end_date))? esc_html_e($task_end_date,'taskbuilder'):""?>
109	</td>
110	</tr>
111	<?php }
112	}
113	?>
114	</tbody>
115	</table>
116	</div>
117	</form>
118	<style>
119	#tbl_project_tasks tr:nth-child(even){
120	background-color:<?php echo esc_attr($appearance_settings['list-item-even-background-color'])?>;
121	color:<?php echo esc_attr($appearance_settings['list-item-even-text-color'])?>;
122	}
123	#tbl_project_tasks tr:nth-child(odd){
124	background-color:<?php echo esc_attr($appearance_settings['list-item-odd-background-color'])?>;
125	color:<?php echo esc_attr($appearance_settings['list-item-odd-text-color'])?>;
126	}
127	#tbl_project_tasks tr:hover{
128	background-color:<?php echo esc_attr($appearance_settings['list-item-hover-background-color'])?>;
129	}
130	#tbl_project_tasks tr:hover td{
131	color: <?php echo esc_attr($appearance_settings['list-item-hover-text-color'])?>;
132	}
133	</style>
134	<script type="text/javascript">
135	jQuery(document).ready(function() {
136	var table = jQuery('#tbl_project_tasks').DataTable({
137	"aLengthMenu": [[4, 8, 12, -1], [4, 8, 12, "All"]],
138	"columnDefs": [
139	{ orderable: false, targets: -1 }
140	]
141	});
142	jQuery('div.dataTables_filter input', table.table().container()).focus();
143	} );
144	</script>
145	<?php
146	$body = ob_get_clean();
147	ob_start();
148	?>
149	<div class="col-md-3" style="text-align: right;">
150	<button type="button" class="btn <?php echo (isset($project_id))?'wppm_popup_close':'wppm_task_popup_close'?>" onclick="<?php echo (isset($project_id))?'wppm_modal_close();':'wppm_task_modal_close();'?>"><?php echo esc_html_e('Close','taskbuilder');?></button>
151	</div><?php
152
153	$footer = ob_get_clean();
154
155	$response = array(
156	'body' => $body,
157	'footer' => $footer
158	);
159
160	echo json_encode($response);