taskbuilder / includes / admin / projects / projects_list.php

projects_list.php in Taskbuilder – Project Management & Task Management Tool With Kanban Board 1.0.0, at includes/admin/projects/projects_list.php

239 lines 14.0 KB

Raw Download Zip

1	<?php
2	if ( ! defined( 'ABSPATH' ) ) {
3	exit; // Exit if accessed directly
4	}
5	global $wpdb,$wppmfunction,$current_user;
6	$status = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}wppm_project_statuses" );
7	$categories = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}wppm_project_categories" );
8	$proj_per_page = 20;
9	$page_no = (isset($_POST['page_no'])) ? intval(sanitize_text_field($_POST['page_no'])): '0';
10	$search_tag = isset($_POST['project_search']) ? sanitize_text_field($_POST['project_search']) : '';
11	if(!empty($search_tag)){
12	$search_tag_text = '%'.$search_tag.'%';
13	if($current_user->has_cap('manage_options')){
14	$query = ("SELECT Project.*
15	FROM {$wpdb->prefix}wppm_project AS Project
16	Left join {$wpdb->prefix}wppm_project_statuses proj_statuses ON Project.status = proj_statuses.id
17	Left join {$wpdb->prefix}wppm_project_categories proj_categories ON Project.cat_id = proj_categories.id
18	Left join {$wpdb->base_prefix}users user ON (FIND_IN_SET(user.ID,Project.users)>0) AND (user.display_name LIKE '$search_tag_text')
19	where Project.project_name LIKE '$search_tag_text' OR proj_statuses.name LIKE '$search_tag_text' OR proj_categories.name LIKE '$search_tag_text' OR ( user.display_name LIKE '$search_tag_text')
20	Group by Project.id");
21	$no_of_rows = ("SELECT count(*) FROM
22	(SELECT Project.*
23	FROM {$wpdb->prefix}wppm_project AS Project
24	Left join {$wpdb->prefix}wppm_project_statuses proj_statuses ON Project.status = proj_statuses.id
25	Left join {$wpdb->prefix}wppm_project_categories proj_categories ON Project.cat_id = proj_categories.id
26	Left join {$wpdb->base_prefix}users user ON (FIND_IN_SET(user.ID,Project.users)>0) AND (user.display_name LIKE '$search_tag_text')
27	where Project.project_name LIKE '$search_tag_text' OR proj_statuses.name LIKE '$search_tag_text' OR proj_categories.name LIKE '$search_tag_text' OR ( user.display_name LIKE '$search_tag_text') Group by Project.id) AS Project" );
28	}else{
29	$query = ("SELECT Project.*
30	FROM {$wpdb->prefix}wppm_project AS Project
31	Left join {$wpdb->prefix}wppm_project_statuses proj_statuses ON Project.status = proj_statuses.id
32	Left join {$wpdb->prefix}wppm_project_categories proj_categories ON Project.cat_id = proj_categories.id
33	Left join {$wpdb->base_prefix}users user ON (FIND_IN_SET(user.ID,Project.users)>0) AND (user.display_name LIKE '$search_tag_text')
34	where (Project.project_name LIKE '$search_tag_text' OR proj_statuses.name LIKE '$search_tag_text' OR proj_categories.name LIKE '$search_tag_text' OR ( user.display_name LIKE '$search_tag_text')) AND (FIND_IN_SET('$current_user->ID',Project.users)>0)
35	Group by Project.id");
36	$no_of_rows = ("SELECT count(*) FROM
37	(SELECT Project.*
38	FROM {$wpdb->prefix}wppm_project AS Project
39	Left join {$wpdb->prefix}wppm_project_statuses proj_statuses ON Project.status = proj_statuses.id
40	Left join {$wpdb->prefix}wppm_project_categories proj_categories ON Project.cat_id = proj_categories.id
41	Left join {$wpdb->base_prefix}users user ON (FIND_IN_SET(user.ID,Project.users)>0) AND (user.display_name LIKE '$search_tag_text')
42	where (Project.project_name LIKE '$search_tag_text' OR proj_statuses.name LIKE '$search_tag_text' OR proj_categories.name LIKE '$search_tag_text' OR ( user.display_name LIKE '$search_tag_text')) AND (FIND_IN_SET('$current_user->ID',Project.users)>0) Group by Project.id) AS Project" );
43	}
44	}else{
45	if($current_user->has_cap('manage_options')){
46	$query = ( "SELECT * FROM {$wpdb->prefix}wppm_project" );
47	$no_of_rows = ( "SELECT count(*) FROM {$wpdb->prefix}wppm_project" );
48	}else{
49	$query = ( "SELECT * FROM {$wpdb->prefix}wppm_project
50	where (FIND_IN_SET('$current_user->ID',users)>0)
51	");
52	$no_of_rows = ( "SELECT count(*) FROM {$wpdb->prefix}wppm_project
53	where (FIND_IN_SET('$current_user->ID',users)>0)
54	");
55	}
56	}
57	$no_of_rows = apply_filters('wppm_project_list_no_of_rows',$no_of_rows);
58	$totalrows = $wpdb->get_var( $no_of_rows );
59	$query = apply_filters('wppm_project_list_query',$query);
60	$limit_start=$page_no*$proj_per_page;
61	$limit="\n LIMIT ".$limit_start.",".$proj_per_page." ";
62	$query = $query.$limit;
63	$wppm_fillter = $wpdb->get_results($query);
64	?>
65	<form id="wppm_project_list_frm">
66	<div id="wppm_project_list_container" class="wppm_bootstrap">
67	<div class="row">
68	<div class="col-sm-6" id="wppm_heading_inline">
69	<span class="wppm-heading-inline">
70	<?php echo esc_html_e('Projects','taskbuilder');?>
71	</span>
72	<?php if($current_user->has_cap('manage_options')){ ?>
73	<img width="25" height="30" id="wppm_add_new_project_btn" class="wppm_add_new_project_btn" onclick="wppm_add_new_project()" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/add.svg'); ?>" alt="add">
74	<?php } ?>
75	</div>
76	<div id="wppm_project_and_task_search" class="col-sm-6">
77	<img width="25px" id="wppm_project_search_filter_img" height="15px" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/search.svg'); ?>" alt="search">
78	<input type="search" id="wppm_project_search_filter" name="wppm_project_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) : "" ?>">
79	</div>
80	</div>
81	<div class="table-responsive">
82	<table id="wppm_project_table" class="wppm_table table">
83	<tr>
84	<th class="wppm_table_header"><?php echo esc_html_e('Project','taskbuilder'); ?></th>
85	<th class="wppm_table_header"><?php echo esc_html_e('Status','taskbuilder'); ?></th>
86	<th class="wppm_table_header"><?php echo esc_html_e('Users','taskbuilder'); ?></th>
87	<th class="wppm_table_header"><?php echo esc_html_e('Category','taskbuilder'); ?></th>
88	<th class="wppm_table_header" ><?php echo esc_html_e('Start Date','taskbuilder'); ?></th>
89	<th class="wppm_table_header"><?php echo esc_html_e('End Date','taskbuilder'); ?></th>
90	<th class="wppm_table_header"><?php echo esc_html_e('No. of tasks','taskbuilder'); ?></th>
91	<th class="wppm_table_header"></th>
92	</tr>
93	<tbody>
94	<?php
95	$total_projects=0;
96	$users = array();
97	if(!empty($wppm_fillter)){
98	foreach( $wppm_fillter as $project ){
99	$total_projects++;
100	$status = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_project_statuses where id=$project->status" );
101	$users = explode(",",$project->users);
102	if(isset($project->cat_id)){
103	$category = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_categories where id=$project->cat_id" );
104	}
105	if(isset($project->id)){
106	if($current_user->has_cap('manage_options')){
107	$no_of_tasks = $wpdb->get_var("SELECT count(*) FROM {$wpdb->prefix}wppm_task WHERE project=$project->id ");
108	}else{
109	$query =("SELECT count(*) FROM
110	( SELECT Task.*
111	FROM {$wpdb->prefix}wppm_task AS Task
112	Left join {$wpdb->prefix}wppm_project proj ON Task.project = proj.id
113	Left join {$wpdb->prefix}wppm_project_users proj_users ON Task.project = proj_users.proj_id
114	where Task.project = $project->id AND ((FIND_IN_SET('$current_user->ID',Task.users)>0) OR (Task.created_by= '$current_user->ID') OR (proj_users.user_id = '$current_user->ID' AND proj_users.role_id = 1 ))Group by Task.id ) AS Task");
115	$no_of_tasks = $wpdb->get_var($query);
116	}
117	}
118	?>
119	<tr onclick="wppm_open_project(<?php echo esc_attr($project->id) ?>)">
120	<td><?php echo esc_html_e($project->project_name,'taskbuilder') ?></td>
121	<td><span class="wppm_td_project_status" style="background-color:<?php echo esc_attr($status->bg_color);?>; color: <?php echo esc_attr($status->color); ?>"><?php echo esc_html_e($status->name,'taskbuilder') ?></span></td>
122	<td>
123	<?php
124	$i=0;
125	if(!empty(array_filter($users))){
126	foreach($users as $user){
127	$i++;
128	if( $i <= 4 ){
129	$user_info = get_user_by('id', $user );
130	if(!empty($user_info)){
131	?>
132	<a href="#" title="<?php echo esc_html_e($user_info->display_name) ?>">
133	<?php echo get_avatar($user_info->ID, 25, "mysteryman");?>
134	</a> <?php
135	}
136	}
137	}
138	} else{
139	_e('None','wp_projects');
140	}
141	if($i > 4){
142	?>
143	<a href="#" class="wppm_avatar">
144	<span id="wppm_avatar" style="background-color:black;" class="avatar">+<?php echo esc_html($i-4) ?></span>
145	</a>
146	<?php } ?>
147	</td>
148	<td class="wppm_table_td"><?php echo isset($category) ? esc_html_e($category,'taskbuilder'): "" ?></td>
149	<td class="wppm_table_td"><?php echo isset($project->start_date) ? esc_html($project->start_date): "" ?></td>
150	<td class="wppm_table_td"><?php echo isset($project->end_date) ? esc_html($project->end_date):"" ?></td>
151	<td class="wppm_table_td"><?php echo isset($no_of_tasks) ? esc_html($no_of_tasks):"" ?></td>
152	<td class="wppm_delete_action">
153	<?php $style = (($current_user->ID && $current_user->has_cap('manage_options')) \|\| ($wppmfunction->has_project_permission('delete_project',esc_attr($project->id))))? "display:inline":"display:none"; ?>
154	<span style="<?php echo esc_attr($style); ?>" onclick="wppm_delete_project(<?php echo esc_attr($project->id) ?>)"><img src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/trash.svg'); ?>" alt="delete"></span>
155	<?php ?>
156	</td>
157	</tr>
158	<?php
159	}
160	}
161	?>
162	</tbody>
163	</table>
164	<?php
165	$total_pages=ceil($totalrows/$proj_per_page);
166	$current_page=$page_no+1;
167	$prev_page_no=$current_page-1;
168	$prev_class=($prev_page_no==0)?'disabled':'';
169	$next_page_no=($total_pages==$current_page)? $current_page-1:$current_page;
170	$next_class=($total_pages==$current_page)?'disabled':'';
171	?>
172	<div class="wppm_project_result" style="<?php echo esc_attr($total_pages==0)? '':'display: none;';?>"><?php echo esc_html_e('Your search request returned no results.','taskbuilder');?></div>
173	<hr style="<?php echo esc_attr($total_pages==0)? '':'display: none;';?>">
174	</div>
175	<div class="row wppm_proj_pagination_container">
176	<div class="col-sm-4">
177	<?php echo esc_html_e('Total:','taskbuilder'); ?> <?php echo esc_html($total_projects) ?> <?php echo esc_html_e('of','taskbuilder') ?> <?php echo esc_html($totalrows) ?> <?php echo esc_html_e('Projects','taskbuilder')?>
178	</div>
179	<div class="col-sm-4">
180	<div class="wppm_proj_pagination" style="<?php echo esc_attr($total_pages==0)? "display:none;":"display:flex;"?>">
181	<span class="wppm-pagination-txt">
182	<span><?php echo esc_html($current_page); ?> <?php echo esc_html_e('of','taskbuilder');?> <?php echo esc_html($total_pages); ?> <?php echo esc_html_e('Page','taskbuilder'); ?></span>
183	</span>
184	<span
185	<?php echo esc_html($prev_class) ?>
186	style="<?php echo (isset($prev_class) && esc_attr($prev_class) == 'disabled') ? 'display:none;':'display:block;'?>">
187	<a class="wppm_pagination_prev" onclick="return wppm_load_prev_page(<?php echo esc_attr($prev_page_no) ?>,<?php echo esc_attr($page_no) ?>);"><?php echo esc_html_e('PREV','taskbuilder');?></a>
188	</span>
189	<span
190	<?php echo esc_attr($next_class) ?>
191	style="<?php echo (isset($next_class) && $next_class == 'disabled')?'display:none;':'display:block;'?>cursor:pointer;">
192	<a class="wppm_pagination_next" onclick="return wppm_load_next_page(<?php echo esc_attr($next_page_no) ?>,<?php echo esc_attr($page_no) ?>,<?php echo esc_attr($limit_start)?>);"><?php echo esc_html_e('NEXT','taskbuilder');?></a>
193	</span>
194	</div>
195	</div>
196	</div>
197	</div>
198	</form>
199	<script type="text/javascript">
200	jQuery( document ).ready( function( jQuery ) {
201	jQuery("input[name='wppm_project_search_filter']").keypress(function(e) {
202	//Enter key
203	if (e.which == 13) {
204	wppm_project_search_filter();
205	}
206	});
207	jQuery(".wppm_delete_action").on("click", function(e){
208	e.preventDefault();
209	return false;
210	});
211
212	jQuery('#wppm_project_list_frm').on('submit', function (e) {
213	var dataform = new FormData(jQuery('#wppm_project_list_frm')[0]);
214	jQuery.ajax({
215	url: wppm_admin.ajax_url,
216	type: 'POST',
217	data: dataform,
218	processData: false,
219	contentType: false,
220	success: function () {
221	alert('form was submitted');
222	}
223	});
224	});
225	});
226	</script>
227	<?php
228	add_action('wp_footer', 'wppm_page_inline_script', 99999999999999999999);
229	do_action('wppm_after_shortcode_loaded');
230	if(!function_exists('wppm_page_inline_script')) {
231	function wppm_page_inline_script() { ?>
232	<script type="text/javascript">
233	jQuery( document ).ready( function( jQuery ) {
234	wppm_get_project_list();
235	});
236	</script>
237	<?php }
238	}
239	?>