← All changes | includes/admin/projects/projects_list.php +60 -171 5.0.0 → 3.0.8 View file →

		@@ -5,9 +5,8 @@
5	5	global $wpdb,$wppmfunction,$current_user;
6	6	$status = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}wppm_project_statuses" );
7	7	$categories = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}wppm_project_categories" );
8	8	$appearance_settings = get_option("wppm-ap-project-list");
9		-$wppm_date_setting = get_option('wppm_date_setting');
10	9	$wppm_current_user_capability = get_user_meta( $current_user->ID, 'wppm_capability', true );
11	10	$proj_per_page = 20;
12	11	$page_no = (isset($_POST['page_no'])) ? intval(sanitize_text_field($_POST['page_no'])): '0';
13	12	$search_tag = isset($_POST['project_search']) ? sanitize_text_field($_POST['project_search']) : '';
		@@ -15,16 +14,9 @@
15	14	$sort_by = isset($_POST['sort_by']) ? sanitize_text_field($_POST['sort_by']):"project_name";
16	15	$filter_by = isset($_POST['wppm_project_filter']) ? sanitize_text_field($_POST['wppm_project_filter']) : "all";
17	16	$current_date = date('Y-m-d');
18	17	$wppm_pl_filter = "1=1";
19		-$wppm_hide_completed_status_proj = get_option('wppm_hide_completed_status_proj');
20	18	$cu_id = esc_sql($current_user->ID);
21		-$wppm_hide_proj_statuses_from_frontend = get_option('wppm_hide_proj_statuses_from_frontend');
22		-if(!empty($wppm_hide_proj_statuses_from_frontend)){
23		- $wppm_hide_proj_statuses_from_frontend = explode(",",$wppm_hide_proj_statuses_from_frontend);
24		-} else {
25		- $wppm_hide_proj_statuses_from_frontend = '';
26		-}
27	19	$filters = array(
28	20	'sort_by' => $sort_by,
29	21	'order' => $order,
30	22	'search' => $search_tag,
		@@ -65,35 +57,23 @@
65	57	}
66	58	if($sort_by=='category'){
67	59	$sort_by = 'proj_categories.name';
68	60	}
69		-if($filter_by=='all'){
70		- if($wppm_hide_completed_status_proj == 0){
71		- $wppm_pl_filter = "status!='4'";
72		- }
73		-}
74		-if($filter_by=='4'){
	61	+if($filter_by=='completed'){
75	62	$wppm_pl_filter = "status='4'";
76	63	}elseif($filter_by=='overdue'){
77	64	$wppm_pl_filter = "status!='4' AND (CAST(end_date AS DATE)) < '$current_date'";
78	65	}elseif($filter_by == 'unassigned'){
79	66	$wppm_pl_filter = "users=''";
80		-}elseif($filter_by == '1'){
	67	+}elseif($filter_by == 'new'){
81	68	$wppm_pl_filter = "status='1'";
82		-}elseif($filter_by == '2'){
	69	+}elseif($filter_by == 'inprogress'){
83	70	$wppm_pl_filter = "status='2'";
84		-}elseif($filter_by == '3'){
	71	+}elseif($filter_by == 'hold'){
85	72	$wppm_pl_filter = "status='3'";
86	73	}elseif($filter_by == 'mine'){
87	74	$wppm_pl_filter = "(FIND_IN_SET('$current_user->ID',users)>0)";
88	75	}
89		-
90		-if(!empty($wppm_hide_proj_statuses_from_frontend) && is_array($wppm_hide_proj_statuses_from_frontend) && ((isset($_POST['is_frontend'])) && (sanitize_text_field($_POST['is_frontend'])==1))){
91		- foreach($wppm_hide_proj_statuses_from_frontend as $status){
92		- $wppm_pl_filter .= " AND status != '$status'";
93		- }
94		-}
95		-
96	76	$wppm_project_time = get_option('wppm_project_time');
97	77	$wppm_default_project_date = get_option('wppm_default_project_date');
98	78	$sort_by = apply_filters('wppm_project_list_sort_by_query',$sort_by);
99	79	$order = apply_filters('wppm_project_list_order_query',$order);
		@@ -142,22 +122,14 @@
142	122	$limit_start=$page_no*$proj_per_page;
143	123	$limit="\n LIMIT ".$limit_start.",".$proj_per_page." ";
144	124	$query = $query.$limit;
145	125	$wppm_fillter = $wpdb->get_results($query);
146		-$new_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_statuses where id='".esc_sql(1)."'" );
147		-$inp_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_statuses where id='".esc_sql(2)."'" );
148		-$hold_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_statuses where id='".esc_sql(3)."'" );
149		-$completed_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_statuses where id='".esc_sql(4)."'" );
150		-$new_style = (!empty($new_status_name))? "display:inline" :"display:none;";
151		-$inp_status_style = (!empty($inp_status_name))? "display:inline" :"display:none;";
152		-$hold_status_style = (!empty($hold_status_name))? "display:inline" :"display:none;";
153		-$complete_status_style = (!empty($completed_status_name))? "display:inline" :"display:none;";
154	126	?>
155	127	<form id="wppm_project_list_frm">
156	128	<div id="wppm-container">
157	129	<div id="wppm_project_list_container" class="wppm_bootstrap">
158	130	<div class="row">
159		- <div class="col-sm-12" id="wppm_heading_inline">
	131	+ <div class="col-sm-6" id="wppm_heading_inline">
160	132	<span class="wppm-heading-inline">
161	133	<?php echo esc_html_e('Projects','taskbuilder');?>
162	134	</span>
163	135	<?php if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_manager'|| $wppm_current_user_capability == 'wppm_admin' ){ ?>
		@@ -163,60 +135,62 @@
163	135	<?php if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_manager'|| $wppm_current_user_capability == 'wppm_admin' ){ ?>
164	136	<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">
165	137	<?php } ?>
166	138	</div>
	139	+ <div id="wppm_project_and_task_search" class="col-sm-6">
	140	+ <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">
	141	+ <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) : "" ?>">
	142	+ </div>
167	143	</div>
168		- <div style="display:flex;justify-content:space-between;margin-top:20px;flex-wrap: wrap;">
169		- <div style="display:flex;flex-wrap: wrap;">
170		- <div id="wppm_project_filter_container">
171		- <div class="wppm-bulk-actions" style="margin-bottom: 10px;">
172		- <button
173		- id="wppm-bulk-actions-btn"
174		- class="wppm-button small secondary"
175		- type="button"
176		- style="display:none;padding:14px;font: 13px Helvetica Neue, Arial, Helvetica, sans-serif !important"
177		- data-popover="wppm-bulk-actions">
178		- <?php esc_attr_e( 'Bulk Actions ', 'taskbuilder' ); ?><img style="color:#313042" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/wppm_chevron_down_icon.svg'); ?>" alt="chevron_down">
179		- </button>
180		- <div id="wppm-bulk-actions" class="gpopover wppm-popover-menu wppm-proj-bulk-actions">
181		- <div class="wppm-popover-menu-item" onclick="wppm_bulk_change_status('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_change_status' ) ); ?>');">
182		- <span><img style="margin-right:5px;" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/gps-navigation.svg'); ?>" alt="status"><?php echo esc_html_e('Change Status','taskbuilder'); ?></span>
	144	+ <div class="row">
	145	+ <div class="col-sm-6" id="wppm_project_filter_container">
	146	+ <div class="wppm-filter-item">
	147	+ <label for="wppm_project_filter"> <?php echo esc_html_e('Filter','taskbuilder');?></label>
	148	+ <select id="wppm_project_filter" name="wppm_project_filter" onchange="wppm_apply_project_filter()">
	149	+ <option value="all"<?php echo ($filter_by == "all")? 'selected':""?>><?php echo esc_html_e('All','taskbuilder');?></option>
	150	+ <option value="new" <?php echo ($filter_by == "new")? 'selected':""?>><?php echo esc_html_e('New','taskbuilder');?></option>
	151	+ <option value="inprogress" <?php echo ($filter_by == "inprogress")? 'selected':""?>><?php echo esc_html_e('In Progress','taskbuilder');?></option>
	152	+ <option value="hold" <?php echo ($filter_by == "hold")? 'selected':""?>><?php echo esc_html_e('Hold','taskbuilder');?></option>
	153	+ <option value="completed" <?php echo ($filter_by == "completed")? 'selected':""?>><?php echo esc_html_e('Completed','taskbuilder');?></option>
	154	+ <option value="mine" <?php echo ($filter_by == "mine")? 'selected':""?>><?php echo esc_html_e('Mine','taskbuilder');?></option>
	155	+ <option value="unassigned" <?php echo ($filter_by == "unassigned")? 'selected':""?>><?php echo esc_html_e('Unassigned','taskbuilder');?></option>
	156	+ <option value="overdue" <?php echo ($filter_by == "overdue")? 'selected':""?>><?php echo esc_html_e('Overdue','taskbuilder');?></option>
	157	+ </select>
	158	+ </div>
	159	+ <div class="wppm_display_submit">
	160	+ <div class="wppm-filter-actions">
	161	+ <span class="wppm-link" onclick="wppm_pl_reset_filter()"> <?php echo esc_html_e('Reset','taskbuilder');?></span>
	162	+ </div>
	163	+ </div>
	164	+ </div>
	165	+ </div>
	166	+ <div class="row">
	167	+ <div class="col-sm-12">
	168	+ <div class="wppm-bulk-actions">
	169	+ <button
	170	+ id="wppm-bulk-actions-btn"
	171	+ class="wppm-button small secondary"
	172	+ type="button"
	173	+ style="display:none"
	174	+ data-popover="wppm-bulk-actions">
	175	+ <?php esc_attr_e( 'Bulk Actions ', 'taskbuilder' ); ?><img style="color:#313042" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/wppm_chevron_down_icon.svg'); ?>" alt="chevron_down">
	176	+ </button>
	177	+ <div id="wppm-bulk-actions" class="gpopover wppm-popover-menu wppm-proj-bulk-actions">
	178	+ <div class="wppm-popover-menu-item" onclick="wppm_bulk_change_status('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_change_status' ) ); ?>');">
	179	+ <span><img style="margin-right:5px;" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/gps-navigation.svg'); ?>" alt="status"><?php echo esc_html_e('Change Status','taskbuilder'); ?></span>
	180	+ </div>
	181	+ <div class="wppm-popover-menu-item" onclick="wppm_bulk_change_category('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_change_category' ) ); ?>');">
	182	+ <span><img style="margin-right:5px;" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/tags.svg'); ?>" alt="category"><?php echo esc_html_e('Change Category','taskbuilder'); ?></span>
	183	+ </div>
	184	+ <div class="wppm-popover-menu-item" onclick="wppm_bulk_assign_users('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_assign_users' ) ); ?>');">
	185	+ <span><img style="margin-right:5px;" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/users.svg'); ?>" alt="users"><?php echo esc_html_e('Assign Co-workers','taskbuilder'); ?></span>
	186	+ </div>
	187	+ <div class="wppm-popover-menu-item" onclick="wppm_bulk_delete_project('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_assign_users' ) ); ?>');">
	188	+ <span><img style="margin-right:5px;" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/trash-alt-solid.svg'); ?>" alt="delete"><?php echo esc_html_e('Delete','taskbuilder'); ?></span>
	189	+ </div>
183	190	</div>
184		- <div class="wppm-popover-menu-item" onclick="wppm_bulk_change_category('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_change_category' ) ); ?>');">
185		- <span><img style="margin-right:5px;" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/tags.svg'); ?>" alt="category"><?php echo esc_html_e('Change Category','taskbuilder'); ?></span>
186		- </div>
187		- <div class="wppm-popover-menu-item" onclick="wppm_bulk_assign_users('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_assign_users' ) ); ?>');">
188		- <span><img style="margin-right:5px;" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/users.svg'); ?>" alt="users"><?php echo esc_html_e('Assign Co-workers','taskbuilder'); ?></span>
189		- </div>
190		- <div class="wppm-popover-menu-item" onclick="wppm_bulk_delete_project('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_assign_users' ) ); ?>');">
191		- <span><img style="margin-right:5px;" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/trash-alt-solid.svg'); ?>" alt="delete"><?php echo esc_html_e('Delete','taskbuilder'); ?></span>
192		- </div>
193		- </div>
194	191	</div>
195		- <div class="wppm-filter-item">
196		- <label for="wppm_project_filter"> <?php echo esc_html_e('Filter','taskbuilder');?></label>
197		- <select id="wppm_project_filter" name="wppm_project_filter" onchange="wppm_apply_project_filter()">
198		- <option value="all"<?php echo ($filter_by == "all")? 'selected':""?>><?php echo esc_html_e('All','taskbuilder');?></option>
199		- <option style="<?php echo $new_style ?>" value="1" <?php echo ($filter_by == "1")? 'selected':""?>><?php echo esc_html_e($new_status_name,'taskbuilder');?></option>
200		- <option style="<?php echo $inp_status_style ?>" value="2" <?php echo ($filter_by == "2")? 'selected':""?>><?php echo esc_html_e($inp_status_name,'taskbuilder');?></option>
201		- <option style="<?php echo $hold_status_style ?>" value="3" <?php echo ($filter_by == "3")? 'selected':""?>><?php echo esc_html_e($hold_status_name,'taskbuilder');?></option>
202		- <option style="<?php echo $complete_status_style ?>" value="4" <?php echo ($filter_by == "4")? 'selected':""?>><?php echo esc_html_e($completed_status_name,'taskbuilder');?></option>
203		- <option value="mine" <?php echo ($filter_by == "mine")? 'selected':""?>><?php echo esc_html_e('Mine','taskbuilder');?></option>
204		- <option value="unassigned" <?php echo ($filter_by == "unassigned")? 'selected':""?>><?php echo esc_html_e('Unassigned','taskbuilder');?></option>
205		- <option value="overdue" <?php echo ($filter_by == "overdue")? 'selected':""?>><?php echo esc_html_e('Overdue','taskbuilder');?></option>
206		- </select>
207		- </div>
208		- <div class="wppm_display_submit">
209		- <div class="wppm-filter-actions">
210		- <span class="wppm-link" onclick="wppm_pl_reset_filter()"> <?php echo esc_html_e('Reset','taskbuilder');?></span>
211		- </div>
212		- </div>
213	192	</div>
214		- </div>
215		- <div id="wppm_project_and_task_search" style="display:flex;justify-content:flex-end;">
216		- <img width="25px" id="wppm_project_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">
217		- <input type="search" id="wppm_project_search_filter" style="margin-right:10px;" 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) : "" ?>">
218		- </div>
219	193	</div>
220	194	<script>
221	195	jQuery('#wppm-more-actions-btn, #wppm-bulk-actions-btn').gpopover({width: 200});
222	196	</script>
		@@ -292,94 +266,15 @@
292	266	}
293	267	$no_of_tasks = apply_filters('wppm_no_of_task_proj_list_query',$no_of_tasks,$project->id);
294	268	}
295	269	if($wppm_project_time == 1){
296		- $psDate = new DateTime($project->start_date);
297		- $peDate = new DateTime($project->end_date);
298		- if($project->start_date=='0000-00-00 00:00:00'){
299		- if($wppm_date_setting=='Y-m-d H:i:s'){
300		- $proj_start_date = '0000-00-00 00:00:00';
301		- }elseif($wppm_date_setting=='d-m-Y H:i:s'){
302		- $proj_start_date = '00-00-0000 00:00:00';
303		- }elseif($wppm_date_setting=='m-d-Y H:i:s'){
304		- $proj_start_date = '00-00-0000 00:00:00';
305		- }else{
306		- $proj_start_date = '0000-00-00 00:00:00';
307		- }
308		- }if($project->end_date=='0000-00-00 00:00:00'){
309		- if($wppm_date_setting=='Y-m-d H:i:s'){
310		- $proj_end_date = '0000-00-00 00:00:00';
311		- }elseif($wppm_date_setting=='d-m-Y H:i:s'){
312		- $proj_end_date = '00-00-0000 00:00:00';
313		- }elseif($wppm_date_setting=='m-d-Y H:i:s'){
314		- $proj_end_date = '00-00-0000 00:00:00';
315		- }else{
316		- $proj_end_date = '0000-00-00 00:00:00';
317		- }
318		- }
319		- if($project->start_date!='0000-00-00 00:00:00'){
320		- if(!empty($wppm_date_setting)){
321		- $proj_start_date = $psDate->format($wppm_date_setting);
322		- }else{
323		- $proj_start_date = isset($project->start_date)? $project->start_date:"";
324		- }
325		- }
326		- if($project->end_date!='0000-00-00 00:00:00'){
327		- if(!empty($wppm_date_setting)){
328		- $proj_end_date = $peDate->format($wppm_date_setting);
329		- }else{
330		- $proj_end_date = isset($project->end_date) ? $project->end_date: "" ;
331		- }
332		- }
	270	+ $proj_start_date = $project->start_date;
	271	+ $proj_end_date = $project->end_date;
333	272	} elseif($wppm_project_time == 0){
334	273	$psDate = new DateTime($project->start_date);
335	274	$peDate = new DateTime($project->end_date);
336	275	$proj_start_date = $psDate->format('Y-m-d');
337	276	$proj_end_date = $peDate->format('Y-m-d');
338		- if($project->start_date=='0000-00-00 00:00:00'){
339		- if($wppm_date_setting=='Y-m-d H:i:s'){
340		- $proj_start_date = '0000-00-00';
341		- }elseif($wppm_date_setting=='d-m-Y H:i:s'){
342		- $proj_start_date = '00-00-0000';
343		- }elseif($wppm_date_setting=='m-d-Y H:i:s'){
344		- $proj_start_date = '00-00-0000';
345		- }else{
346		- $proj_start_date = '0000-00-00';
347		- }
348		- }
349		- if($project->end_date=='0000-00-00 00:00:00'){
350		- if($wppm_date_setting=='Y-m-d H:i:s'){
351		- $proj_end_date = '0000-00-00';
352		- }elseif($wppm_date_setting=='d-m-Y H:i:s'){
353		- $proj_end_date = '00-00-0000';
354		- }elseif($wppm_date_setting=='m-d-Y H:i:s'){
355		- $proj_end_date = '00-00-0000';
356		- }else{
357		- $proj_end_date = '0000-00-00';
358		- }
359		-
360		- }if($project->start_date!='0000-00-00 00:00:00'){
361		- if($wppm_date_setting=='Y-m-d H:i:s'){
362		- $proj_start_date = $psDate->format('Y-m-d');
363		- }elseif($wppm_date_setting=='d-m-Y H:i:s'){
364		- $proj_start_date = $psDate->format('d-m-Y');
365		- }elseif($wppm_date_setting=='m-d-Y H:i:s'){
366		- $proj_start_date = $psDate->format('m-d-Y');
367		- }else{
368		- $proj_start_date = $psDate->format('Y-m-d');
369		- }
370		- }
371		- if($project->end_date!='0000-00-00 00:00:00'){
372		- if($wppm_date_setting=='Y-m-d H:i:s'){
373		- $proj_end_date = $peDate->format('Y-m-d');
374		- }elseif($wppm_date_setting=='d-m-Y H:i:s'){
375		- $proj_end_date = $peDate->format('d-m-Y');
376		- }elseif($wppm_date_setting=='m-d-Y H:i:s'){
377		- $proj_end_date = $peDate->format('m-d-Y');
378		- }else{
379		- $proj_end_date = $peDate->format('Y-m-d');
380		- }
381		- }
382	277	}
383	278	?>
384	279	<tr onclick="if(link)wppm_open_project(<?php echo esc_attr($project->id) ?>)">
385	280	<td class="bulk-selector" onmouseover="link=false;" onmouseout="link=true;">
		@@ -418,18 +313,12 @@
418	313	</a>
419	314	<?php } ?>
420	315	</td>
421	316	<td onmouseover="link=true;" class="wppm_table_td"><?php echo isset($category) ? esc_html_e($category,'taskbuilder'): "" ?></td>
422		- <?php if($wppm_default_project_date==1){
423		- ?>
	317	+ <?php if($wppm_default_project_date==1){ ?>
424	318	<td onmouseover="link=true;" class="wppm_table_td"><?php echo isset($proj_start_date) ? esc_html($proj_start_date): "" ?></td>
425		- <?php
426		- if(!empty($proj_end_date) && $project->status!=4 && $proj_end_date < $current_date && ($proj_end_date != '0000-00-00 00:00:00' && $proj_end_date != '00-00-0000 00:00:00' && $proj_end_date != '00-00-0000' && $proj_end_date != '0000-00-00')) {
427		- $style = "color:#FF0000";
428		- } else {
429		- $style = "color:#2C3E50";
430		- } ?>
431		- <td onmouseover="link=true;" class="wppm_table_td"><span style="<?php echo esc_attr($style); ?>"><?php echo isset($proj_end_date) ? esc_html($proj_end_date):"" ?></span></td>
	319	+ <?php $style = ($project->status!=4 && $proj_end_date < $current_date) ? "color:#FF0000":"color:#2C3E50"; ?>
	320	+ <td onmouseover="link=true;" class="wppm_table_td"><span style="<?php echo esc_attr($style); ?>"><?php echo isset($proj_end_date) ? esc_html($proj_end_date):"" ?></td></span>
432	321	<?php } ?>
433	322	<td onmouseover="link=true;" class="wppm_table_td"><?php echo isset($no_of_tasks) ? esc_html($no_of_tasks):"" ?></td>
434	323	<td onmouseover="link=true;" class="wppm_delete_action">
435	324	<?php $style = (($current_user->ID && $current_user->has_cap('manage_options')) || ($wppmfunction->has_project_permission('delete_project',esc_attr($project->id))) || $wppm_current_user_capability == 'wppm_admin' || ($proejctdata['created_by']==$current_user->ID && $wppm_current_user_capability == 'wppm_manager') )? "display:inline":"display:none"; ?>