PluginProbe
Taskbuilder – Project Management & Task Management Tool With Kanban Board / 6.0.6
Taskbuilder – Project Management & Task Management Tool With Kanban Board v6.0.6
6.0.6 6.0.5 6.0.2 6.0.3 6.0.4 6.0.1 6.0.0 5.0.8 5.0.9 4.0.9 5.0.0 5.0.1 5.0.2 5.0.3 5.0.4 5.0.5 5.0.6 5.0.7 trunk 1.0.0 1.0.1 1.0.2 1.0.3 1.0.4 1.0.5 All 58 releases
← All changes | includes/admin/projects/projects_list.php +867 -648 6.0.5 → 6.0.6 View file →
@@ -1,649 +1,868 @@
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 -$appearance_settings = get_option("wppm-ap-project-list");
9 -$wppm_date_setting = get_option('wppm_date_setting');
10 -$wppm_deafault_time_duration_project = get_option('wppm_display_time_duration_project');
11 -$wppm_current_user_capability = get_user_meta( $current_user->ID, 'wppm_capability', true );
12 -$proj_per_page = 20;
13 -$page_no = (isset($_POST['page_no'])) ? intval(sanitize_text_field($_POST['page_no'])): '0';
14 -$page = isset($_POST['page']) ? sanitize_text_field(wp_unslash($_POST['page'])):"";
15 -$search_tag = isset($_POST['project_search']) ? sanitize_text_field($_POST['project_search']) : '';
16 -$order = isset($_POST['order']) ? sanitize_text_field($_POST['order']) :"ASC";
17 -$sort_by = isset($_POST['sort_by']) ? sanitize_text_field($_POST['sort_by']):"project_name";
18 -$filter_by = isset($_POST['wppm_project_filter']) ? sanitize_text_field($_POST['wppm_project_filter']) : "all";
19 -$is_archieved = !empty($_POST['is_archieved']) ? 1 : 0;
20 -$current_date = wp_date('Y-m-d');
21 -$wppm_pl_filter = "1=1";
22 -$wppm_hide_completed_status_proj = get_option('wppm_hide_completed_status_proj');
23 -$cu_id = esc_sql($current_user->ID);
24 -$wppm_hide_proj_statuses_from_frontend = get_option('wppm_hide_proj_statuses_from_frontend');
25 -if(!empty($wppm_hide_proj_statuses_from_frontend)){
26 - $wppm_hide_proj_statuses_from_frontend = explode(",",$wppm_hide_proj_statuses_from_frontend);
27 -} else {
28 - $wppm_hide_proj_statuses_from_frontend = '';
29 -}
30 -$is_admin = ( $wppm_current_user_capability === 'wppm_admin' || current_user_can('manage_options') ) ? 1 : 0;
31 -$filters = array(
32 - 'sort_by' => $sort_by,
33 - 'order' => $order,
34 - 'search' => $search_tag,
35 - 'filter'=>$filter_by
36 -);
37 -$pl_filters = isset( $_COOKIE['wppm_proj_filters'] ) ? sanitize_text_field( wp_unslash( $_COOKIE['wppm_proj_filters'] ) ) : $filters;
38 -if(!is_array($pl_filters)){
39 - $pl_filters = json_decode($pl_filters);
40 - $pl_filters_arr = (array) $pl_filters;
41 -} else{
42 - $pl_filters_arr = $filters;
43 -}
44 -$search_tag = isset($_POST['project_search']) ? sanitize_text_field($_POST['project_search']) : $pl_filters_arr['search'];
45 -$order = isset($_POST['order']) ? sanitize_text_field($_POST['order']) :$pl_filters_arr['order'];
46 -$sort_by = isset($_POST['sort_by']) ? sanitize_text_field($_POST['sort_by']):$pl_filters_arr['sort_by'];
47 -$filter_by = isset($_POST['wppm_project_filter']) ? sanitize_text_field($_POST['wppm_project_filter']) : $pl_filters_arr['filter'];
48 -if($sort_by == ""){
49 - $sort_by = 'project_name';
50 -}
51 -$filters = array(
52 - 'sort_by' => $sort_by,
53 - 'order' => $order,
54 - 'search'=>$search_tag,
55 - 'filter'=>$filter_by
56 -);
57 -setcookie('wppm_proj_filters',wp_json_encode( $filters ),time() + 3600);
58 -
59 -$allowed_sort_by = [
60 - 'project_name' => 'project_name',
61 - 'status' => 'proj_statuses.name',
62 - 'category' => 'proj_categories.name',
63 - 'start_date' => 'start_date',
64 - 'end_date' => 'end_date',
65 - 'TIMESTAMPDIFF(SECOND, start_date, end_date)'=> 'TIMESTAMPDIFF(SECOND, start_date, end_date)'
66 -];
67 -// Resolve sort_by safely
68 -$sort_key = isset($pl_filters_arr['sort_by'])
69 - ? sanitize_text_field($pl_filters_arr['sort_by'])
70 - : 'project_name';
71 -
72 -$sort_by = $allowed_sort_by[$sort_key] ?? 'project_name';
73 -$order = ( isset($pl_filters_arr['order']) && strtoupper($pl_filters_arr['order']) === 'ASC' )
74 - ? 'ASC'
75 - : 'DESC';
76 -if($filter_by=='all'){
77 - if($wppm_hide_completed_status_proj == 0){
78 - $wppm_pl_filter = "status!='4'";
79 - }
80 -}
81 -if($filter_by=='4'){
82 - $wppm_pl_filter = "status='4'";
83 -}elseif($filter_by=='overdue'){
84 - $wppm_pl_filter = "status!='4' AND (CAST(end_date AS DATE)) < '$current_date'";
85 -}elseif($filter_by == 'unassigned'){
86 - $wppm_pl_filter = "users=''";
87 -}elseif($filter_by == '1'){
88 - $wppm_pl_filter = "status='1'";
89 -}elseif($filter_by == '2'){
90 - $wppm_pl_filter = "status='2'";
91 -}elseif($filter_by == '3'){
92 - $wppm_pl_filter = "status='3'";
93 -}elseif($filter_by == 'mine'){
94 - $wppm_pl_filter = "(FIND_IN_SET('$current_user->ID',users)>0)";
95 -}elseif($filter_by == 'active'){
96 - $wppm_pl_filter = " (FIND_IN_SET('$current_user->ID', users) OR created_by = '$current_user->ID' OR $is_admin = 1 )
97 - AND status != 4";
98 -}
99 -
100 -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))){
101 - foreach($wppm_hide_proj_statuses_from_frontend as $status){
102 - $wppm_pl_filter .= " AND status != '$status'";
103 - }
104 -}
105 -$wppm_project_time = get_option('wppm_project_time');
106 -$wppm_default_project_date = get_option('wppm_default_project_date');
107 -$sort_by = apply_filters('wppm_project_list_sort_by_query',$sort_by);
108 -$order = apply_filters('wppm_project_list_order_query',$order);
109 -$search_tag_text = '%'.$wpdb->esc_like($search_tag).'%';
110 -if (!empty($search_tag)) {
111 - $search_tag_text = '%' . $wpdb->esc_like($search_tag) . '%';
112 - $query = "SELECT Project.*
113 - FROM {$wpdb->prefix}wppm_project AS Project
114 - LEFT JOIN {$wpdb->prefix}wppm_project_statuses proj_statuses ON Project.status = proj_statuses.id
115 - LEFT JOIN {$wpdb->prefix}wppm_project_categories proj_categories ON Project.cat_id = proj_categories.id
116 - LEFT JOIN {$wpdb->base_prefix}users user ON FIND_IN_SET(user.ID, Project.users) > 0
117 - LEFT JOIN {$wpdb->prefix}wppm_project_meta proj_meta ON Project.id = proj_meta.project_id";
118 - // SAFE search condition
119 - $search_sql = $wpdb->prepare(
120 - "(Project.project_name LIKE %s
121 - OR proj_statuses.name LIKE %s
122 - OR proj_categories.name LIKE %s
123 - OR user.display_name LIKE %s)",
124 - $search_tag_text,
125 - $search_tag_text,
126 - $search_tag_text,
127 - $search_tag_text
128 - );
129 - if ($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin') {
130 - // ✅ Admin (safe)
131 - $where = " WHERE $wppm_pl_filter AND $search_sql";
132 - } else {
133 - // ✅ Non-admin (safe)
134 - $where = $wpdb->prepare(
135 - " WHERE $wppm_pl_filter
136 - AND $search_sql
137 - AND (
138 - FIND_IN_SET(%d, Project.users) > 0
139 - OR (
140 - proj_meta.meta_key = 'public_project'
141 - AND proj_meta.meta_value = 1
142 - )
143 - OR Project.created_by = %d
144 - )",
145 - $current_user->ID,
146 - $cu_id
147 - );
148 - }
149 -} else {
150 - if ($sort_by == 'project_name' || $sort_by == 'start_date' || $sort_by == 'end_date') {
151 - $query = "SELECT Project.*
152 - FROM {$wpdb->prefix}wppm_project AS Project
153 - LEFT JOIN {$wpdb->prefix}wppm_project_meta proj_meta ON Project.id = proj_meta.project_id";
154 - } else {
155 - $query = "SELECT Project.*
156 - FROM {$wpdb->prefix}wppm_project AS Project
157 - LEFT JOIN {$wpdb->prefix}wppm_project_statuses proj_statuses ON Project.status = proj_statuses.id
158 - LEFT JOIN {$wpdb->prefix}wppm_project_categories proj_categories ON Project.cat_id = proj_categories.id
159 - LEFT JOIN {$wpdb->prefix}wppm_project_meta proj_meta ON Project.id = proj_meta.project_id";
160 - }
161 - if ($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin') {
162 - $where = " WHERE $wppm_pl_filter";
163 - } else {
164 - $where = $wpdb->prepare(
165 - " WHERE (
166 - $wppm_pl_filter
167 - AND (
168 - FIND_IN_SET(%d, Project.users) > 0
169 - OR (
170 - proj_meta.meta_key = 'public_project'
171 - AND proj_meta.meta_value = 1
172 - )
173 - )
174 - OR Project.created_by = %d
175 - )",
176 - $current_user->ID,
177 - $cu_id
178 - );
179 - }
180 -}
181 -$archived_where = '';
182 -if ( isset( $is_archieved ) && $is_archieved === 1 ) {
183 - $archived_where = ' AND Project.is_archived = 1';
184 -} else {
185 - $archived_where = ' AND Project.is_archived = 0';
186 -}
187 -$where .= $archived_where;
188 -$no_of_rows = ( "SELECT count(*) FROM ($query");
189 -$no_of_rows = apply_filters('wppm_project_list_no_of_rows',$no_of_rows,$wppm_pl_filter,$search_tag);
190 -$where = apply_filters('wppm_project_list_query_where',$where, $wppm_pl_filter,$search_tag);
191 -$query .= $where." Group by Project.id ORDER BY $sort_by $order";
192 -$no_of_rows .= $where." Group by Project.id) AS Project";
193 -$totalrows = $wpdb->get_var( $no_of_rows );
194 -$query = apply_filters('wppm_project_list_query',$query);
195 -$limit_start=$page_no*$proj_per_page;
196 -$limit="\n LIMIT ".$limit_start.",".$proj_per_page." ";
197 -$query = $query.$limit;
198 -$wppm_fillter = $wpdb->get_results($query);
199 -$new_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_statuses where id='".esc_sql(1)."'" );
200 -$inp_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_statuses where id='".esc_sql(2)."'" );
201 -$hold_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_statuses where id='".esc_sql(3)."'" );
202 -$completed_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_statuses where id='".esc_sql(4)."'" );
203 -$new_style = (!empty($new_status_name))? "display:inline" :"display:none;";
204 -$inp_status_style = (!empty($inp_status_name))? "display:inline" :"display:none;";
205 -$hold_status_style = (!empty($hold_status_name))? "display:inline" :"display:none;";
206 -$complete_status_style = (!empty($completed_status_name))? "display:inline" :"display:none;";
207 -?>
208 -<form id="wppm_project_list_frm">
209 - <div id="wppm-container">
210 - <div id="wppm_project_list_container" class="wppm_bootstrap">
211 - <div class="row">
212 - <div class="col-sm-12" id="wppm_heading_inline">
213 - <span class="wppm-heading-inline">
214 - <?php echo !empty($is_archieved) ? esc_html__('Archived Projects', 'taskbuilder') : esc_html__('Projects', 'taskbuilder'); ?>
215 - </span>
216 - <?php if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_manager'|| $wppm_current_user_capability == 'wppm_admin'){ ?>
217 - <span class="wppm-add-new-btn btn-primary" id="wppm_add_new_project_btn" onclick="wppm_add_new_project()"><span style="margin-right:5px;"><img id="wppm_add_new_project_icon" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/plus_icon.svg'); ?>" alt="plus_icon"></span><span><?php echo esc_html_e('Add New','taskbuilder');?></span></span>
218 - <?php } ?>
219 - <span class="wppm-add-new-btn btn-primary" id="wppm_project_list" onclick="wppm_get_project_list()" ><span style="margin-right:5px;"><img id ="wppm_project_list_icon" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/list-symbol.svg'); ?>" alt="list-symbol"></span><span><?php echo esc_html_e('Project List','taskbuilder');?></span></span>
220 - <?php if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_manager'|| $wppm_current_user_capability == 'wppm_admin' ){ ?>
221 - <span class="wppm-add-new-btn btn-primary"" id="wppm_archieve_project_btn" title="Archive Project" onclick="wppm_archieve_project_list()"><img src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/archive_project.svg'); ?>" alt="archive"><span style="margin-left:5px;"><span><?php echo esc_html_e('Archive Project','taskbuilder');?></span></span>
222 - <?php } ?>
223 - </div>
224 - </div>
225 - <div style="display:flex;justify-content:space-between;margin-top:20px;flex-wrap: wrap;">
226 - <div style="display:flex;flex-wrap: wrap;">
227 - <div id="wppm_project_filter_container">
228 - <div class="wppm-bulk-actions" style="margin-bottom: 10px;">
229 - <button
230 - id="wppm-bulk-actions-btn"
231 - class="wppm-button small secondary"
232 - type="button"
233 - style="display:none;padding:14px;font: 13px Helvetica Neue, Arial, Helvetica, sans-serif !important"
234 - data-popover="wppm-bulk-actions">
235 - <?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">
236 - </button>
237 - <div id="wppm-bulk-actions" class="gpopover wppm-popover-menu wppm-proj-bulk-actions">
238 - <div class="wppm-popover-menu-item" onclick="wppm_bulk_change_status('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_change_status' ) ); ?>');">
239 - <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>
240 - </div>
241 - <div class="wppm-popover-menu-item" onclick="wppm_bulk_change_category('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_change_category' ) ); ?>');">
242 - <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>
243 - </div>
244 - <div class="wppm-popover-menu-item" onclick="wppm_bulk_assign_users('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_assign_users' ) ); ?>');">
245 - <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>
246 - </div>
247 - <div class="wppm-popover-menu-item" onclick="wppm_bulk_delete_project('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_assign_users' ) ); ?>');">
248 - <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>
249 - </div>
250 - </div>
251 - </div>
252 - <div class="wppm-filter-item">
253 - <label for="wppm_project_filter"> <?php echo esc_html_e('Filter','taskbuilder');?></label>
254 - <select id="wppm_project_filter" name="wppm_project_filter" onchange="wppm_apply_project_filter(<?php echo $is_archieved ?>)">
255 - <option value="all"<?php echo ($filter_by == "all")? 'selected':""?>><?php echo esc_html_e('All','taskbuilder');?></option>
256 - <option style="<?php echo esc_attr($new_style) ?>" value="1" <?php echo ($filter_by == "1")? 'selected':""?>><?php echo esc_html($new_status_name);?></option>
257 - <option style="<?php echo esc_attr($inp_status_style) ?>" value="2" <?php echo ($filter_by == "2")? 'selected':""?>><?php echo esc_html($inp_status_name);?></option>
258 - <option style="<?php echo esc_attr($hold_status_style) ?>" value="3" <?php echo ($filter_by == "3")? 'selected':""?>><?php echo esc_html($hold_status_name);?></option>
259 - <option style="<?php echo esc_attr($complete_status_style) ?>" value="4" <?php echo ($filter_by == "4")? 'selected':""?>><?php echo esc_html($completed_status_name);?></option>
260 - <option value="mine" <?php echo ($filter_by == "mine")? 'selected':""?>><?php echo esc_html_e('Mine','taskbuilder');?></option>
261 - <option value="unassigned" <?php echo ($filter_by == "unassigned")? 'selected':""?>><?php echo esc_html_e('Unassigned','taskbuilder');?></option>
262 - <option value="overdue" <?php echo ($filter_by == "overdue")? 'selected':""?>><?php echo esc_html_e('Overdue','taskbuilder');?></option>
263 - </select>
264 - </div>
265 - <div class="wppm_display_submit">
266 - <div class="wppm-filter-actions">
267 - <span class="wppm-link" onclick="wppm_pl_reset_filter(<?php echo $is_archieved ?>)"> <?php echo esc_html_e('Reset','taskbuilder');?></span>
268 - </div>
269 - </div>
270 - </div>
271 - </div>
272 - <div id="wppm_project_and_task_search" style="display:flex;justify-content:flex-end;">
273 - <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">
274 - <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) : "" ?>">
275 - </div>
276 - </div>
277 - <script>
278 - jQuery('#wppm-more-actions-btn, #wppm-bulk-actions-btn').gpopover({width: 200});
279 - </script>
280 - <div class="table-responsive">
281 - <table id="wppm_project_table" class="wppm_table table">
282 - <tr>
283 - <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>" onchange="wppm_bulk_select_change()">
284 - <div class="checkbox-container">
285 - <input id="wppm_bulk_select_option" class="wppm-bulk-selector" type="checkbox" onchange="wppm_bulk_select_change();"/>
286 - <label for="wppm_bulk_select_option"></label>
287 - </div>
288 - </th>
289 - <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
290 - <span id="wppm_proj_name_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Project','taskbuilder'); ?></span>
291 - <img width="16" height="16" onclick="wppm_sort_up_project_list('project_name','ASC')" style = "<?php echo ($sort_by == 'project_name' && $order == 'DESC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_up_project_name_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_up_icon.svg'); ?>" alt="chevron_sort_up_icon">
292 - <img width="16" height="16" onclick="wppm_sort_up_project_list('project_name','DESC')" style = "<?php echo ($sort_by == 'project_name' && $order == 'ASC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_down_project_name_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_down_icon.svg'); ?>" alt="chevron_sort_down_icon">
293 - </th>
294 - <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
295 - <span id="wppm_project_status_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Status','taskbuilder'); ?></span>
296 - <img width="16" height="16" onclick="wppm_sort_up_project_list('status','ASC')" style = "<?php echo ($sort_by == 'proj_statuses.name' && $order == 'DESC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_up_project_status_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_up_icon.svg'); ?>" alt="chevron_sort_up_icon">
297 - <img width="16" height="16" onclick="wppm_sort_up_project_list('status','DESC')" style = "<?php echo ($sort_by == 'proj_statuses.name' && $order == 'ASC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_down_project_status_img" class="wppm_chevron_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_down_icon.svg'); ?>" alt="chevron_sort_down_icon">
298 - </th>
299 - <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
300 - <span id="wppm_proj_list_users_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Users','taskbuilder'); ?></span></th>
301 - <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
302 - <span id="wppm_project_category_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Category','taskbuilder'); ?></span>
303 - <img width="16" height="16" onclick="wppm_sort_up_project_list('category','ASC')" style = "<?php echo ($sort_by == 'proj_categories.name' && $order == 'DESC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_up_project_cat_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_up_icon.svg'); ?>" alt="chevron_sort_up_icon">
304 - <img width="16" height="16" onclick="wppm_sort_up_project_list('category','DESC')" style = "<?php echo ($sort_by == 'proj_categories.name' && $order == 'ASC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_down_project_cat_img" class="wppm_chevron_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_down_icon.svg'); ?>" alt="chevron_sort_down_icon">
305 - </th>
306 - <?php if($wppm_default_project_date==1 && $wppm_deafault_time_duration_project==0){ ?>
307 - <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
308 - <span id="wppm_project_start_date_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Start Date','taskbuilder'); ?></span>
309 - <img width="16" height="16" onclick="wppm_sort_up_project_list('start_date','ASC')" style = "<?php echo ($sort_by == 'start_date' && $order == 'DESC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_up_project_start_date_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_up_icon.svg'); ?>" alt="chevron_sort_up_icon">
310 - <img width="16" height="16" onclick="wppm_sort_up_project_list('start_date','DESC')" style = "<?php echo ($sort_by == 'start_date' && $order == 'ASC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_down_project_start_date_img" class="wppm_chevron_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_down_icon.svg'); ?>" alt="chevron_sort_down_icon">
311 - </th>
312 - <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
313 - <span id="wppm_project_end_date_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('End Date','taskbuilder'); ?></span>
314 - <img width="16" height="16" onclick="wppm_sort_up_project_list('end_date','ASC')" style = "<?php echo ($sort_by == 'end_date' && $order == 'DESC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_up_project_end_date_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_up_icon.svg'); ?>" alt="chevron_sort_up_icon">
315 - <img width="16" height="16" onclick="wppm_sort_up_project_list('end_date','DESC')" style = "<?php echo ($sort_by == 'end_date' && $order == 'ASC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_down_project_end_date_img" class="wppm_chevron_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_down_icon.svg'); ?>" alt="chevron_sort_down_icon">
316 - </th>
317 - <?php }
318 - if( $wppm_deafault_time_duration_project==1){ ?>
319 - <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
320 - <span id="wppm_project_time_duration_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Duration','taskbuilder'); ?></span>
321 - <img width="16" height="16" onclick="wppm_sort_up_project_list('TIMESTAMPDIFF(SECOND, start_date, end_date)','ASC')" style = "<?php echo ($sort_by == 'TIMESTAMPDIFF(SECOND, start_date, end_date)' && $order == 'DESC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_up_project_time_duration_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_up_icon.svg'); ?>" alt="chevron_sort_up_icon">
322 - <img width="16" height="16" onclick="wppm_sort_up_project_list('TIMESTAMPDIFF(SECOND, start_date, end_date)','DESC')" style = "<?php echo ($sort_by == 'TIMESTAMPDIFF(SECOND, start_date, end_date)' && $order == 'ASC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_down_project_time_duration_img" class="wppm_chevron_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_down_icon.svg'); ?>" alt="chevron_sort_down_icon">
323 - </th>
324 - <?php }?>
325 - <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>"><span style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('No. of tasks','taskbuilder'); ?></span></th>
326 - <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>"></th>
327 - </tr>
328 - <tbody>
329 - <?php
330 - $total_projects=0;
331 - $users = array();
332 - if(!empty($wppm_fillter)){
333 - foreach( $wppm_fillter as $project ){
334 - $total_projects++;
335 - $proejctdata = $wppmfunction->get_project($project->id);
336 - $wppm_proj_duration = $wppmfunction->wppm_get_duration($project->start_date,$project->end_date);
337 - $pstatus= absint($project->status);
338 - $status = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_project_statuses where id='$pstatus'" );
339 - $users = explode(",",$project->users);
340 - $pid= absint($project->id);
341 - if(isset($project->cat_id)){
342 - $pcat_id = absint($project->cat_id);
343 - $category = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_categories where id='$pcat_id'" );
344 - }
345 - if(isset($project->id)){
346 - if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin'){
347 - $no_of_tasks = $wpdb->get_var("SELECT count(*) FROM {$wpdb->prefix}wppm_task WHERE project='$pid' ");
348 - }else{
349 - $query =("SELECT count(*) FROM
350 - ( SELECT Task.*
351 - FROM {$wpdb->prefix}wppm_task AS Task
352 - Left join {$wpdb->prefix}wppm_project proj ON Task.project = proj.id
353 - Left join {$wpdb->prefix}wppm_project_users proj_users ON Task.project = proj_users.proj_id
354 - Left join {$wpdb->prefix}wppm_project_meta proj_meta ON proj.id = proj_meta.project_id
355 - where Task.project = '$pid' 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 ) OR (proj.id = 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 ) AS Task");
356 - $no_of_tasks = $wpdb->get_var($query);
357 - }
358 - $no_of_tasks = apply_filters('wppm_no_of_task_proj_list_query',$no_of_tasks,$project->id);
359 - }
360 - if($wppm_project_time == 1){
361 - $psDate = new DateTime($project->start_date);
362 - $peDate = new DateTime($project->end_date);
363 - if($project->start_date=='0000-00-00 00:00:00'){
364 - if($wppm_date_setting=='Y-m-d H:i:s'){
365 - $proj_start_date = '0000-00-00 00:00:00';
366 - }elseif($wppm_date_setting=='d-m-Y H:i:s'){
367 - $proj_start_date = '00-00-0000 00:00:00';
368 - }elseif($wppm_date_setting=='m-d-Y H:i:s'){
369 - $proj_start_date = '00-00-0000 00:00:00';
370 - }else{
371 - $proj_start_date = '0000-00-00 00:00:00';
372 - }
373 - }if($project->end_date=='0000-00-00 00:00:00'){
374 - if($wppm_date_setting=='Y-m-d H:i:s'){
375 - $proj_end_date = '0000-00-00 00:00:00';
376 - }elseif($wppm_date_setting=='d-m-Y H:i:s'){
377 - $proj_end_date = '00-00-0000 00:00:00';
378 - }elseif($wppm_date_setting=='m-d-Y H:i:s'){
379 - $proj_end_date = '00-00-0000 00:00:00';
380 - }else{
381 - $proj_end_date = '0000-00-00 00:00:00';
382 - }
383 - }
384 - if($project->start_date!='0000-00-00 00:00:00'){
385 - if(!empty($wppm_date_setting)){
386 - $proj_start_date = $psDate->format($wppm_date_setting);
387 - }else{
388 - $proj_start_date = isset($project->start_date)? $project->start_date:"";
389 - }
390 - }
391 - if($project->end_date!='0000-00-00 00:00:00'){
392 - if(!empty($wppm_date_setting)){
393 - $proj_end_date = $peDate->format($wppm_date_setting);
394 - }else{
395 - $proj_end_date = isset($project->end_date) ? $project->end_date: "" ;
396 - }
397 - }
398 - } elseif($wppm_project_time == 0){
399 - $psDate = new DateTime($project->start_date);
400 - $peDate = new DateTime($project->end_date);
401 - $proj_start_date = $psDate->format('Y-m-d');
402 - $proj_end_date = $peDate->format('Y-m-d');
403 - if($project->start_date=='0000-00-00 00:00:00'){
404 - if($wppm_date_setting=='Y-m-d H:i:s'){
405 - $proj_start_date = '0000-00-00';
406 - }elseif($wppm_date_setting=='d-m-Y H:i:s'){
407 - $proj_start_date = '00-00-0000';
408 - }elseif($wppm_date_setting=='m-d-Y H:i:s'){
409 - $proj_start_date = '00-00-0000';
410 - }else{
411 - $proj_start_date = '0000-00-00';
412 - }
413 - }
414 - if($project->end_date=='0000-00-00 00:00:00'){
415 - if($wppm_date_setting=='Y-m-d H:i:s'){
416 - $proj_end_date = '0000-00-00';
417 - }elseif($wppm_date_setting=='d-m-Y H:i:s'){
418 - $proj_end_date = '00-00-0000';
419 - }elseif($wppm_date_setting=='m-d-Y H:i:s'){
420 - $proj_end_date = '00-00-0000';
421 - }else{
422 - $proj_end_date = '0000-00-00';
423 - }
424 -
425 - }if($project->start_date!='0000-00-00 00:00:00'){
426 - if($wppm_date_setting=='Y-m-d H:i:s'){
427 - $proj_start_date = $psDate->format('Y-m-d');
428 - }elseif($wppm_date_setting=='d-m-Y H:i:s'){
429 - $proj_start_date = $psDate->format('d-m-Y');
430 - }elseif($wppm_date_setting=='m-d-Y H:i:s'){
431 - $proj_start_date = $psDate->format('m-d-Y');
432 - }else{
433 - $proj_start_date = $psDate->format('Y-m-d');
434 - }
435 - }
436 - if($project->end_date!='0000-00-00 00:00:00'){
437 - if($wppm_date_setting=='Y-m-d H:i:s'){
438 - $proj_end_date = $peDate->format('Y-m-d');
439 - }elseif($wppm_date_setting=='d-m-Y H:i:s'){
440 - $proj_end_date = $peDate->format('d-m-Y');
441 - }elseif($wppm_date_setting=='m-d-Y H:i:s'){
442 - $proj_end_date = $peDate->format('m-d-Y');
443 - }else{
444 - $proj_end_date = $peDate->format('Y-m-d');
445 - }
446 - }
447 - }
448 - ?>
449 - <tr onclick="if(link)wppm_open_project(<?php echo esc_attr($project->id) ?>)">
450 - <td class="bulk-selector" onmouseover="link=false;" onmouseout="link=true;">
451 - <div class="wppm-pl-item-selector">
452 - <div class="checkbox-container">
453 - <input id="wppm_bulk_select_<?php echo esc_attr($project->id) ?>" class="wppm-bulk-select" type="checkbox" onchange="wppm_bulk_item_select_change();" value="<?php echo esc_attr( $project->id ); ?>"/>
454 - <label for="wppm_bulk_select_<?php echo esc_attr($project->id) ?>"></label>
455 - </div>
456 - </div>
457 - </td>
458 - <td onmouseover="link=true;"><?php echo esc_html($project->project_name) ?></td>
459 - <td onmouseover="link=true;"><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($status->name) ?></span></td>
460 - <td onmouseover="link=true;">
461 - <?php
462 - $i=0;
463 - if(!empty(array_filter($users))){
464 - foreach($users as $user){
465 - $i++;
466 - if( $i <= 4 ){
467 - $user_info = get_user_by('id', $user );
468 - if(!empty($user_info)){
469 - ?>
470 - <a href="#" title="<?php echo esc_html($user_info->display_name) ?>">
471 - <?php echo get_avatar($user_info->ID, 25, "mysteryman");?>
472 - </a> <?php
473 - }
474 - }
475 - }
476 - } else{
477 - esc_html_e('None','taskbuilder');
478 - }
479 - if($i > 4){
480 - ?>
481 - <a href="#" class="wppm_avatar">
482 - <span id="wppm_avatar" style="background-color:black;" class="avatar">+<?php echo esc_html($i-4) ?></span>
483 - </a>
484 - <?php } ?>
485 - </td>
486 - <td onmouseover="link=true;" class="wppm_table_td"><?php echo isset($category) ? esc_html($category): "" ?></td>
487 - <?php if($wppm_default_project_date==1 && $wppm_deafault_time_duration_project==0){ ?>
488 - <td onmouseover="link=true;" class="wppm_table_td"><?php echo isset($proj_start_date) ? esc_html($proj_start_date): "" ?></td>
489 - <?php
490 - 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')) {
491 - $style = "color:#FF0000";
492 - } else {
493 - $style = "color:#2C3E50";
494 - } ?>
495 - <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>
496 - <?php } ?>
497 - <?php if($wppm_deafault_time_duration_project==1){ ?>
498 - <?php
499 - 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')) {
500 - $style = "color:#FF0000";
501 - } else {
502 - $style = "color:#2C3E50";
503 - } ?>
504 - <td onmouseover="link=true;" class="wppm_table_td"><span style="<?php echo esc_attr($style); ?>"><?php echo isset($wppm_proj_duration) ? esc_html($wppm_proj_duration):"" ?></span></td>
505 - <?php } ?>
506 - <td onmouseover="link=true;" class="wppm_table_td"><?php echo isset($no_of_tasks) ? esc_html($no_of_tasks):"" ?></td>
507 - <td onmouseover="link=true;" class="wppm_delete_action">
508 - <?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"; ?>
509 - <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>
510 - <?php ?>
511 - </td>
512 - </tr>
513 - <?php
514 - }
515 - }
516 - ?>
517 - </tbody>
518 - </table>
519 - <?php
520 - $total_pages=ceil($totalrows/$proj_per_page);
521 - $current_page=$page_no+1;
522 - $prev_page_no=$current_page-1;
523 - $prev_class=($prev_page_no==0)?'disabled':'';
524 - $next_page_no=($total_pages==$current_page)? $current_page-1:$current_page;
525 - $next_class=($total_pages==$current_page)?'disabled':'';
526 - ?>
527 - <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>
528 - <hr style="<?php echo esc_attr($total_pages==0)? '':'display: none;';?>">
529 - </div>
530 - <div class="row wppm_proj_pagination_container">
531 - <div class="col-sm-4">
532 - <?php echo esc_html_e('Total:','taskbuilder'); ?>&nbsp;<?php echo esc_html($total_projects) ?>&nbsp;<?php echo esc_html_e('of','taskbuilder') ?>&nbsp;<?php echo esc_html($totalrows) ?>&nbsp;<?php echo esc_html_e('Projects','taskbuilder')?>
533 - </div>
534 - <div class="col-sm-4">
535 - <div class="wppm_proj_pagination" style="<?php echo esc_attr($total_pages==0)? "display:none;":"display:flex;"?>">
536 - <span class="wppm-pagination-txt">
537 - <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>
538 - </span>
539 - <span
540 - <?php echo esc_html($prev_class) ?>
541 - style="<?php echo (isset($prev_class) && esc_attr($prev_class) == 'disabled') ? 'display:none;':'display:block;'?>">
542 - <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_attr($sort_by)?>','<?php echo esc_attr($order) ?>','<?php echo esc_attr($is_archieved)?>');"><?php echo esc_html_e('PREV','taskbuilder');?></a>
543 - </span>
544 - <span
545 - <?php echo esc_attr($next_class) ?>
546 - style="<?php echo (isset($next_class) && $next_class == 'disabled')?'display:none;':'display:block;'?>cursor:pointer;">
547 - <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($sort_by)?>','<?php echo esc_attr($order) ?>','<?php echo esc_attr($is_archieved)?>');"><?php echo esc_html_e('NEXT','taskbuilder');?></a>
548 - </span>
549 - </div>
550 - </div>
551 - </div>
552 - </div>
553 - </div>
554 -</form>
555 -<style>
556 - #wppm_project_table tr:nth-child(even) td{
557 - background-color:<?php echo esc_attr($appearance_settings['list-item-even-background-color'])?>!important;
558 - color:<?php echo esc_attr($appearance_settings['list-item-even-text-color'])?>!important;
559 - }
560 - #wppm_project_table tr:nth-child(odd) td{
561 - background-color:<?php echo esc_attr($appearance_settings['list-item-odd-background-color'])?>!important;
562 - color:<?php echo esc_attr($appearance_settings['list-item-odd-text-color'])?>!important;
563 - }
564 - #wppm_project_table tr:hover td{
565 - background-color:<?php echo esc_attr($appearance_settings['list-item-hover-background-color'])?>!important;
566 - }
567 - #wppm_project_table tr:hover td{
568 - color: <?php echo esc_attr($appearance_settings['list-item-hover-text-color'])?>!important;
569 - }
570 -</style>
571 -<script type="text/javascript">
572 - jQuery( document ).ready( function( jQuery ) {
573 - jQuery("input[name='wppm_project_search_filter']").keypress(function(e) {
574 - //Enter key
575 - if (e.which == 13) {
576 - wppm_project_search_filter(<?php echo $is_archieved ?>);
577 - }
578 - });
579 - jQuery("#wppm_proj_name_th").hover(function(){
580 - jQuery('#wppm_chevron_sort_up_project_name_img').show();
581 - jQuery('#wppm_chevron_sort_down_project_name_img').hide();
582 - });
583 - jQuery("#wppm_project_status_th").hover(function(){
584 - jQuery('#wppm_chevron_sort_up_project_status_img').show();
585 - jQuery('#wppm_chevron_sort_down_project_status_img').hide();
586 - });
587 - jQuery("#wppm_project_category_th").hover(function(){
588 - jQuery('#wppm_chevron_sort_up_project_cat_img').show();
589 - jQuery('#wppm_chevron_sort_down_project_cat_img').hide();
590 - });
591 - jQuery("#wppm_project_start_date_th").hover(function(){
592 - jQuery('#wppm_chevron_sort_up_project_start_date_img').show();
593 - jQuery('#wppm_chevron_sort_down_project_start_date_img').hide();
594 - });
595 - jQuery("#wppm_project_end_date_th").hover(function(){
596 - jQuery('#wppm_chevron_sort_up_project_end_date_img').show();
597 - jQuery('#wppm_chevron_sort_down_project_end_date_img').hide();
598 - });
599 - jQuery("#wppm_project_time_duration_th").hover(function(){
600 - jQuery('#wppm_chevron_sort_up_project_time_duration_img').show();
601 - jQuery('#wppm_chevron_sort_down_project_time_duration_img').hide();
602 - });
603 - jQuery(".wppm_delete_action").on("click", function(e){
604 - e.preventDefault();
605 - return false;
606 - });
607 -
608 - jQuery('#wppm_project_list_frm').on('submit', function (e) {
609 - var dataform = new FormData(jQuery('#wppm_project_list_frm')[0]);
610 - jQuery.ajax({
611 - url: wppm_admin.ajax_url,
612 - type: 'POST',
613 - data: dataform,
614 - processData: false,
615 - contentType: false,
616 - success: function () {
617 - alert('form was submitted');
618 - }
619 - });
620 - });
621 - });
622 - /**
623 - * Bulk item selector change
624 - */
625 -function wppm_bulk_item_select_change() {
626 - jQuery("#wppm-bulk-actions-btn").show();
627 - var items = jQuery(".wppm-bulk-select:checked");
628 - var checked = items.length === 0 ? false : true;
629 - if(checked){
630 - jQuery(".wppm-bulk-selector").prop("checked", checked);
631 - }else{
632 - jQuery("#wppm-bulk-actions-btn").hide();
633 - jQuery(".wppm-bulk-selector").prop("checked", false);
634 - }
635 -}
636 -</script>
637 -<?php
638 -add_action('wp_footer', 'wppm_page_inline_script', 999999999999999999);
639 -do_action('wppm_after_shortcode_loaded');
640 -if(!function_exists('wppm_page_inline_script')) {
641 - function wppm_page_inline_script() { ?>
642 - <script type="text/javascript">
643 - jQuery( document ).ready( function( jQuery ) {
644 - wppm_get_project_list();
645 - });
646 - </script>
647 - <?php }
648 -}
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 +$pb_users = get_users(array(
9 + 'orderby' => 'display_name',
10 + 'order' => 'ASC'
11 +));
12 +$assigned_project_users = $wpdb->get_col( "SELECT DISTINCT users FROM {$wpdb->prefix}wppm_project WHERE users != ''" );
13 +$all_assigned_proj_users = array();
14 +foreach ( $assigned_project_users as $row ) {
15 + foreach ( explode( ',', $row ) as $uid ) {
16 + $uid = trim( $uid );
17 + if ( $uid !== '' ) {
18 + $all_assigned_proj_users[] = $uid;
19 + }
20 + }
21 +}
22 +$all_assigned_proj_users = array_unique( $all_assigned_proj_users );
23 +$appearance_settings = wp_parse_args(
24 + get_option( "wppm-ap-project-list", array() ),
25 + array(
26 + 'list-header-button-background-color' => '#0052CC',
27 + 'list-header-button-hover-color' => '#0065ff',
28 + 'list-header-button-text-color' => '#fff',
29 + )
30 +);
31 +$wppm_date_setting = get_option('wppm_date_setting');
32 +$wppm_deafault_time_duration_project = get_option('wppm_display_time_duration_project');
33 +$wppm_current_user_capability = get_user_meta( $current_user->ID, 'wppm_capability', true );
34 +$proj_per_page = 20;
35 +$page_no = (isset($_POST['page_no'])) ? intval(sanitize_text_field($_POST['page_no'])): '0';
36 +$page = isset($_POST['page']) ? sanitize_text_field(wp_unslash($_POST['page'])):"";
37 +$search_tag = isset($_POST['project_search']) ? sanitize_text_field($_POST['project_search']) : '';
38 +$order = isset($_POST['order']) ? sanitize_text_field($_POST['order']) :"ASC";
39 +$sort_by = isset($_POST['sort_by']) ? sanitize_text_field($_POST['sort_by']):"project_name";
40 +$filter_by = isset($_POST['wppm_project_filter']) ? sanitize_text_field($_POST['wppm_project_filter']) : "all";
41 +$is_archieved = !empty($_POST['is_archieved']) ? 1 : 0;
42 +if ( isset( $_POST['filters'] ) ) {
43 + if ( is_string( $_POST['filters'] ) ) {
44 + $advanced_filter = json_decode( stripslashes( sanitize_text_field( wp_unslash( $_POST['filters'] ) ) ), true );
45 + } elseif ( is_array( $_POST['filters'] ) ) {
46 + $raw_filters = wp_unslash( $_POST['filters'] );
47 + $advanced_filter = array(
48 + 'created_by' => array_map( 'absint', (array) ( $raw_filters['created_by'] ?? array() ) ),
49 + 'assigned' => array_map( 'absint', (array) ( $raw_filters['assigned'] ?? array() ) ),
50 + 'category' => array_map( 'absint', (array) ( $raw_filters['category'] ?? array() ) ),
51 + 'start_date' => sanitize_text_field( $raw_filters['start_date'] ?? '' ),
52 + 'end_date' => sanitize_text_field( $raw_filters['end_date'] ?? '' ),
53 + );
54 + } else {
55 + $advanced_filter = array();
56 + }
57 +} elseif ( ! empty( $_COOKIE['tb_proj_list_filters'] ) ) {
58 + $advanced_filter = json_decode( stripslashes( sanitize_text_field( wp_unslash( $_COOKIE['tb_proj_list_filters'] ) ) ), true );
59 +} else {
60 + $advanced_filter = array();
61 +}
62 +if ( ! is_array( $advanced_filter ) ) {
63 + $advanced_filter = array();
64 +}
65 +$current_date = wp_date('Y-m-d');
66 +$wppm_pl_filter = "1=1";
67 +$wppm_hide_completed_status_proj = get_option('wppm_hide_completed_status_proj');
68 +$cu_id = esc_sql($current_user->ID);
69 +$wppm_hide_proj_statuses_from_frontend = get_option('wppm_hide_proj_statuses_from_frontend');
70 +if(!empty($wppm_hide_proj_statuses_from_frontend)){
71 + $wppm_hide_proj_statuses_from_frontend = explode(",",$wppm_hide_proj_statuses_from_frontend);
72 +} else {
73 + $wppm_hide_proj_statuses_from_frontend = '';
74 +}
75 +$is_admin = ( $wppm_current_user_capability === 'wppm_admin' || current_user_can('manage_options') ) ? 1 : 0;
76 +$filters = array(
77 + 'sort_by' => $sort_by,
78 + 'order' => $order,
79 + 'search' => $search_tag,
80 + 'filter'=>$filter_by
81 +);
82 +$pl_filters = isset( $_COOKIE['wppm_proj_filters'] ) ? sanitize_text_field( wp_unslash( $_COOKIE['wppm_proj_filters'] ) ) : $filters;
83 +if(!is_array($pl_filters)){
84 + $pl_filters = json_decode($pl_filters);
85 + $pl_filters_arr = (array) $pl_filters;
86 +} else{
87 + $pl_filters_arr = $filters;
88 +}
89 +$search_tag = isset($_POST['project_search']) ? sanitize_text_field($_POST['project_search']) : $pl_filters_arr['search'];
90 +$order = isset($_POST['order']) ? sanitize_text_field($_POST['order']) :$pl_filters_arr['order'];
91 +$sort_by = isset($_POST['sort_by']) ? sanitize_text_field($_POST['sort_by']):$pl_filters_arr['sort_by'];
92 +$filter_by = isset($_POST['wppm_project_filter']) ? sanitize_text_field($_POST['wppm_project_filter']) : $pl_filters_arr['filter'];
93 +if($sort_by == ""){
94 + $sort_by = 'project_name';
95 +}
96 +$filters = array(
97 + 'sort_by' => $sort_by,
98 + 'order' => $order,
99 + 'search'=>$search_tag,
100 + 'filter'=>$filter_by
101 +);
102 +setcookie('wppm_proj_filters',wp_json_encode( $filters ),time() + 3600);
103 +
104 +$allowed_sort_by = [
105 + 'project_name' => 'project_name',
106 + 'status' => 'proj_statuses.name',
107 + 'category' => 'proj_categories.name',
108 + 'start_date' => 'start_date',
109 + 'end_date' => 'end_date',
110 + 'TIMESTAMPDIFF(SECOND, start_date, end_date)'=> 'TIMESTAMPDIFF(SECOND, start_date, end_date)'
111 +];
112 +// Resolve sort_by safely
113 +$sort_key = isset($pl_filters_arr['sort_by'])
114 + ? sanitize_text_field($pl_filters_arr['sort_by'])
115 + : 'project_name';
116 +
117 +$sort_by = $allowed_sort_by[$sort_key] ?? 'project_name';
118 +$order = ( isset($pl_filters_arr['order']) && strtoupper($pl_filters_arr['order']) === 'ASC' )
119 + ? 'ASC'
120 + : 'DESC';
121 +if($filter_by=='all'){
122 + if($wppm_hide_completed_status_proj == 0){
123 + $wppm_pl_filter = "status!='4'";
124 + }
125 +}
126 +if($filter_by=='4'){
127 + $wppm_pl_filter = "status='4'";
128 +}elseif($filter_by=='overdue'){
129 + $wppm_pl_filter = "status!='4' AND (CAST(end_date AS DATE)) < '$current_date'";
130 +}elseif($filter_by == 'unassigned'){
131 + $wppm_pl_filter = "users=''";
132 +}elseif($filter_by == '1'){
133 + $wppm_pl_filter = "status='1'";
134 +}elseif($filter_by == '2'){
135 + $wppm_pl_filter = "status='2'";
136 +}elseif($filter_by == '3'){
137 + $wppm_pl_filter = "status='3'";
138 +}elseif($filter_by == 'mine'){
139 + $wppm_pl_filter = "(FIND_IN_SET('$current_user->ID',users)>0)";
140 +}elseif($filter_by == 'active'){
141 + $wppm_pl_filter = " (FIND_IN_SET('$current_user->ID', users) OR created_by = '$current_user->ID' OR $is_admin = 1 )
142 + AND status != 4";
143 +}
144 +
145 +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))){
146 + foreach($wppm_hide_proj_statuses_from_frontend as $status){
147 + $wppm_pl_filter .= " AND status != '$status'";
148 + }
149 +}
150 +$advanced_conditions = array();
151 +if ( ! empty( $advanced_filter['created_by'] ) ) {
152 + $created_by_ids = array_map( 'intval', (array) $advanced_filter['created_by'] );
153 + $advanced_conditions[] = "created_by IN (" . implode( ',', $created_by_ids ) . ")";
154 +}
155 +if ( ! empty( $advanced_filter['assigned'] ) ) {
156 + $assigned_ids = array_map( 'intval', (array) $advanced_filter['assigned'] );
157 + $assigned_sql = array();
158 + foreach ( $assigned_ids as $id ) {
159 + $assigned_sql[] = "FIND_IN_SET('$id', users)";
160 + }
161 + $advanced_conditions[] = "(" . implode( ' OR ', $assigned_sql ) . ")";
162 +}
163 +if ( ! empty( $advanced_filter['category'] ) ) {
164 + $category_ids = array_map( 'intval', (array) $advanced_filter['category'] );
165 + $advanced_conditions[] = "cat_id IN (" . implode( ',', $category_ids ) . ")";
166 +}
167 +if ( ! empty( $advanced_filter['start_date'] ) && preg_match( '/^\d{4}-\d{2}-\d{2}$/', $advanced_filter['start_date'] ) ) {
168 + $advanced_conditions[] = $wpdb->prepare( "(CAST(start_date AS DATE)) >= %s", $advanced_filter['start_date'] );
169 +}
170 +if ( ! empty( $advanced_filter['end_date'] ) && preg_match( '/^\d{4}-\d{2}-\d{2}$/', $advanced_filter['end_date'] ) ) {
171 + $advanced_conditions[] = $wpdb->prepare( "(CAST(end_date AS DATE)) <= %s", $advanced_filter['end_date'] );
172 +}
173 +if ( ! empty( $advanced_conditions ) ) {
174 + $wppm_pl_filter .= " AND " . implode( " AND ", $advanced_conditions );
175 +}
176 +$wppm_project_time = get_option('wppm_project_time');
177 +$wppm_default_project_date = get_option('wppm_default_project_date');
178 +$sort_by = apply_filters('wppm_project_list_sort_by_query',$sort_by);
179 +$order = apply_filters('wppm_project_list_order_query',$order);
180 +$search_tag_text = '%'.$wpdb->esc_like($search_tag).'%';
181 +if (!empty($search_tag)) {
182 + $search_tag_text = '%' . $wpdb->esc_like($search_tag) . '%';
183 + $query = "SELECT Project.*
184 + FROM {$wpdb->prefix}wppm_project AS Project
185 + LEFT JOIN {$wpdb->prefix}wppm_project_statuses proj_statuses ON Project.status = proj_statuses.id
186 + LEFT JOIN {$wpdb->prefix}wppm_project_categories proj_categories ON Project.cat_id = proj_categories.id
187 + LEFT JOIN {$wpdb->base_prefix}users user ON FIND_IN_SET(user.ID, Project.users) > 0
188 + LEFT JOIN {$wpdb->prefix}wppm_project_meta proj_meta ON Project.id = proj_meta.project_id";
189 + // SAFE search condition
190 + $search_sql = $wpdb->prepare(
191 + "(Project.project_name LIKE %s
192 + OR proj_statuses.name LIKE %s
193 + OR proj_categories.name LIKE %s
194 + OR user.display_name LIKE %s)",
195 + $search_tag_text,
196 + $search_tag_text,
197 + $search_tag_text,
198 + $search_tag_text
199 + );
200 + if ($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin') {
201 + // ✅ Admin (safe)
202 + $where = " WHERE $wppm_pl_filter AND $search_sql";
203 + } else {
204 + // ✅ Non-admin (safe)
205 + $where = $wpdb->prepare(
206 + " WHERE $wppm_pl_filter
207 + AND $search_sql
208 + AND (
209 + FIND_IN_SET(%d, Project.users) > 0
210 + OR (
211 + proj_meta.meta_key = 'public_project'
212 + AND proj_meta.meta_value = 1
213 + )
214 + OR Project.created_by = %d
215 + )",
216 + $current_user->ID,
217 + $cu_id
218 + );
219 + }
220 +} else {
221 + if ($sort_by == 'project_name' || $sort_by == 'start_date' || $sort_by == 'end_date') {
222 + $query = "SELECT Project.*
223 + FROM {$wpdb->prefix}wppm_project AS Project
224 + LEFT JOIN {$wpdb->prefix}wppm_project_meta proj_meta ON Project.id = proj_meta.project_id";
225 + } else {
226 + $query = "SELECT Project.*
227 + FROM {$wpdb->prefix}wppm_project AS Project
228 + LEFT JOIN {$wpdb->prefix}wppm_project_statuses proj_statuses ON Project.status = proj_statuses.id
229 + LEFT JOIN {$wpdb->prefix}wppm_project_categories proj_categories ON Project.cat_id = proj_categories.id
230 + LEFT JOIN {$wpdb->prefix}wppm_project_meta proj_meta ON Project.id = proj_meta.project_id";
231 + }
232 + if ($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin') {
233 + $where = " WHERE $wppm_pl_filter";
234 + } else {
235 + $where = $wpdb->prepare(
236 + " WHERE $wppm_pl_filter
237 + AND (
238 + FIND_IN_SET(%d, Project.users) > 0
239 + OR (
240 + proj_meta.meta_key = 'public_project'
241 + AND proj_meta.meta_value = 1
242 + )
243 + OR Project.created_by = %d
244 + )",
245 + $current_user->ID,
246 + $cu_id
247 + );
248 + }
249 +}
250 +$archived_where = '';
251 +if ( isset( $is_archieved ) && $is_archieved === 1 ) {
252 + $archived_where = ' AND Project.is_archived = 1';
253 +} else {
254 + $archived_where = ' AND Project.is_archived = 0';
255 +}
256 +$where .= $archived_where;
257 +$no_of_rows = ( "SELECT count(*) FROM ($query");
258 +$no_of_rows = apply_filters('wppm_project_list_no_of_rows',$no_of_rows,$wppm_pl_filter,$search_tag);
259 +$where = apply_filters('wppm_project_list_query_where',$where, $wppm_pl_filter,$search_tag);
260 +$query .= $where." Group by Project.id ORDER BY $sort_by $order";
261 +$no_of_rows .= $where." Group by Project.id) AS Project";
262 +$totalrows = $wpdb->get_var( $no_of_rows );
263 +$query = apply_filters('wppm_project_list_query',$query);
264 +$limit_start=$page_no*$proj_per_page;
265 +$limit="\n LIMIT ".$limit_start.",".$proj_per_page." ";
266 +$query = $query.$limit;
267 +$wppm_fillter = $wpdb->get_results($query);
268 +$new_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_statuses where id='".esc_sql(1)."'" );
269 +$inp_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_statuses where id='".esc_sql(2)."'" );
270 +$hold_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_statuses where id='".esc_sql(3)."'" );
271 +$completed_status_name = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_statuses where id='".esc_sql(4)."'" );
272 +$new_style = (!empty($new_status_name))? "display:inline" :"display:none;";
273 +$inp_status_style = (!empty($inp_status_name))? "display:inline" :"display:none;";
274 +$hold_status_style = (!empty($hold_status_name))? "display:inline" :"display:none;";
275 +$complete_status_style = (!empty($completed_status_name))? "display:inline" :"display:none;";
276 +?>
277 +<form id="wppm_project_list_frm">
278 + <div id="wppm-container">
279 + <div id="wppm_project_list_container" class="wppm_bootstrap">
280 + <div class="row">
281 + <div class="col-sm-12" id="wppm_heading_inline">
282 + <span class="wppm-heading-inline">
283 + <?php echo !empty($is_archieved) ? esc_html__('Archived Projects', 'taskbuilder') : esc_html__('Projects', 'taskbuilder'); ?>
284 + </span>
285 + <?php if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_manager'|| $wppm_current_user_capability == 'wppm_admin'){ ?>
286 + <span class="wppm-add-new-btn btn-primary" id="wppm_add_new_project_btn" onclick="wppm_add_new_project()" style="background-color:<?php echo esc_attr($appearance_settings['list-header-button-background-color'])?>;color:<?php echo esc_attr($appearance_settings['list-header-button-text-color'])?>;"><span style="margin-right:5px;"><img id="wppm_add_new_project_icon" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/plus_icon.svg'); ?>" alt="plus_icon"></span><span><?php echo esc_html_e('Add New','taskbuilder');?></span></span>
287 + <?php } ?>
288 + <span class="wppm-add-new-btn btn-primary" id="wppm_project_list" onclick="wppm_get_project_list()" style="background-color:<?php echo esc_attr($appearance_settings['list-header-button-background-color'])?>;color:<?php echo esc_attr($appearance_settings['list-header-button-text-color'])?>;"><span style="margin-right:5px;"><img id ="wppm_project_list_icon" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/list-symbol.svg'); ?>" alt="list-symbol"></span><span><?php echo esc_html_e('Project List','taskbuilder');?></span></span>
289 + <?php if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_manager'|| $wppm_current_user_capability == 'wppm_admin' ){ ?>
290 + <span class="wppm-add-new-btn btn-primary"" id="wppm_archieve_project_btn" title="Archive Project" onclick="wppm_archieve_project_list()" style="background-color:<?php echo esc_attr($appearance_settings['list-header-button-background-color'])?>;color:<?php echo esc_attr($appearance_settings['list-header-button-text-color'])?>;"><img src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/archive_project.svg'); ?>" alt="archive"><span style="margin-left:5px;"><span><?php echo esc_html_e('Archive Project','taskbuilder');?></span></span>
291 + <?php } ?>
292 + </div>
293 + </div>
294 + <div style="display:flex;justify-content:space-between;margin-top:20px;flex-wrap: wrap;">
295 + <div style="display:flex;flex-wrap: wrap;">
296 + <div id="wppm_project_filter_container">
297 + <div class="wppm-bulk-actions" style="margin-bottom: 10px;">
298 + <button
299 + id="wppm-bulk-actions-btn"
300 + class="wppm-button small secondary"
301 + type="button"
302 + style="display:none;padding:14px;font: 13px Helvetica Neue, Arial, Helvetica, sans-serif !important"
303 + data-popover="wppm-bulk-actions">
304 + <?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">
305 + </button>
306 + <div id="wppm-bulk-actions" class="gpopover wppm-popover-menu wppm-proj-bulk-actions">
307 + <div class="wppm-popover-menu-item" onclick="wppm_bulk_change_status('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_change_status' ) ); ?>');">
308 + <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>
309 + </div>
310 + <div class="wppm-popover-menu-item" onclick="wppm_bulk_change_category('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_change_category' ) ); ?>');">
311 + <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>
312 + </div>
313 + <div class="wppm-popover-menu-item" onclick="wppm_bulk_assign_users('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_assign_users' ) ); ?>');">
314 + <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>
315 + </div>
316 + <div class="wppm-popover-menu-item" onclick="wppm_bulk_delete_project('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_assign_users' ) ); ?>');">
317 + <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>
318 + </div>
319 + </div>
320 + </div>
321 + <div class="wppm-filter-item">
322 + <label for="wppm_project_filter"> <?php echo esc_html_e('Filter','taskbuilder');?></label>
323 + <select id="wppm_project_filter" name="wppm_project_filter" onchange="wppm_apply_project_filter(<?php echo $is_archieved ?>)">
324 + <option value="all"<?php echo ($filter_by == "all")? 'selected':""?>><?php echo esc_html_e('All','taskbuilder');?></option>
325 + <option style="<?php echo esc_attr($new_style) ?>" value="1" <?php echo ($filter_by == "1")? 'selected':""?>><?php echo esc_html($new_status_name);?></option>
326 + <option style="<?php echo esc_attr($inp_status_style) ?>" value="2" <?php echo ($filter_by == "2")? 'selected':""?>><?php echo esc_html($inp_status_name);?></option>
327 + <option style="<?php echo esc_attr($hold_status_style) ?>" value="3" <?php echo ($filter_by == "3")? 'selected':""?>><?php echo esc_html($hold_status_name);?></option>
328 + <option style="<?php echo esc_attr($complete_status_style) ?>" value="4" <?php echo ($filter_by == "4")? 'selected':""?>><?php echo esc_html($completed_status_name);?></option>
329 + <option value="mine" <?php echo ($filter_by == "mine")? 'selected':""?>><?php echo esc_html_e('Mine','taskbuilder');?></option>
330 + <option value="unassigned" <?php echo ($filter_by == "unassigned")? 'selected':""?>><?php echo esc_html_e('Unassigned','taskbuilder');?></option>
331 + <option value="overdue" <?php echo ($filter_by == "overdue")? 'selected':""?>><?php echo esc_html_e('Overdue','taskbuilder');?></option>
332 + </select>
333 + </div>
334 + <div class="tb-filters" style="display:flex;margin-left: 4px;">
335 + <div class="tb-filter-bar">
336 + <span id="tb-advanced-toggle" class="tb-btn" style="margin: 10px 10px 10px 2px !important;">
337 + <?php echo esc_html_e('⚙️ Filters', 'taskbuilder'); ?>
338 + </span>
339 + <div id="tb-active-filters" class="tb-chips"></div>
340 + <div id="tb-advanced-panel" class="tb-popover">
341 + <div class="tb-mobile-header">
342 + <span><?php echo esc_html_e('Filters', 'taskbuilder'); ?></span>
343 + <button type="button" id="tb-close-filters">✕</button>
344 + </div>
345 + <div class="tb-arrow"></div>
346 + <div class="tb-section">
347 + <h4> <?php echo esc_html_e('Created By', 'taskbuilder'); ?></h4>
348 + <select id="tb-created-by" class="form-control" multiple>
349 + <?php if(!empty($pb_users)){ foreach($pb_users as $pb_user): ?>
350 + <option value="<?php echo esc_attr($pb_user->ID); ?>"><?php echo esc_html($pb_user->display_name); ?></option>
351 + <?php endforeach; } ?>
352 + </select>
353 + <h4> <?php echo esc_html_e('Co-workers', 'taskbuilder'); ?></h4>
354 + <select id="tb-assigned" class="form-control" multiple>
355 + <?php
356 + if(!empty($all_assigned_proj_users)){
357 + foreach($all_assigned_proj_users as $auid){
358 + $auser = get_userdata($auid);
359 + if($auser){ ?>
360 + <option value="<?php echo esc_attr($auid); ?>"><?php echo esc_html($auser->display_name); ?></option>
361 + <?php }
362 + }
363 + }
364 + ?>
365 + </select>
366 + </div>
367 + <div class="tb-section">
368 + <h4> <?php echo esc_html_e('Category', 'taskbuilder'); ?></h4>
369 + <select id="tb-category" class="form-control" multiple>
370 + <?php if(!empty($categories)){ foreach($categories as $pb_cat){ ?>
371 + <option value="<?php echo esc_attr($pb_cat->id); ?>"><?php echo esc_html($pb_cat->name); ?></option>
372 + <?php } } ?>
373 + </select>
374 + </div>
375 + <div class="tb-section">
376 + <h4> <?php echo esc_html_e('Date', 'taskbuilder'); ?></h4>
377 + <input type="date" class="form-control" id="tb-start-date">
378 + <input type="date" class="form-control" id="tb-end-date">
379 + </div>
380 + <div id="tb-filter-actions">
381 + <button class="wppm-submit-btn" id="tb-apply-filter" type="button"><?php echo esc_html_e('Apply', 'taskbuilder'); ?></button>
382 + <button class="wppm_reset_btn" id="tb-reset-filter" type="button"><?php echo esc_html_e('Reset', 'taskbuilder'); ?></button>
383 + </div>
384 + </div>
385 + </div>
386 + <div id="tb-backdrop"></div>
387 + </div>
388 + <div class="wppm_display_submit">
389 + <div class="wppm-filter-actions">
390 + <span class="wppm-link" onclick="wppm_pl_reset_filter(<?php echo $is_archieved ?>)"> <?php echo esc_html_e('Reset','taskbuilder');?></span>
391 + </div>
392 + </div>
393 + </div>
394 + </div>
395 + <div id="wppm_project_and_task_search" style="display:flex;justify-content:flex-end;">
396 + <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">
397 + <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) : "" ?>">
398 + </div>
399 + </div>
400 + <script>
401 + jQuery('#wppm-more-actions-btn, #wppm-bulk-actions-btn').gpopover({width: 200});
402 + </script>
403 + <div class="table-responsive">
404 + <table id="wppm_project_table" class="wppm_table table">
405 + <tr>
406 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>" onchange="wppm_bulk_select_change()">
407 + <div class="checkbox-container">
408 + <input id="wppm_bulk_select_option" class="wppm-bulk-selector" type="checkbox" onchange="wppm_bulk_select_change();"/>
409 + <label for="wppm_bulk_select_option"></label>
410 + </div>
411 + </th>
412 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
413 + <span id="wppm_proj_name_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Project','taskbuilder'); ?></span>
414 + <img width="16" height="16" onclick="wppm_sort_up_project_list('project_name','ASC')" style = "<?php echo ($sort_by == 'project_name' && $order == 'DESC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_up_project_name_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_up_icon.svg'); ?>" alt="chevron_sort_up_icon">
415 + <img width="16" height="16" onclick="wppm_sort_up_project_list('project_name','DESC')" style = "<?php echo ($sort_by == 'project_name' && $order == 'ASC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_down_project_name_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_down_icon.svg'); ?>" alt="chevron_sort_down_icon">
416 + </th>
417 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
418 + <span id="wppm_project_status_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Status','taskbuilder'); ?></span>
419 + <img width="16" height="16" onclick="wppm_sort_up_project_list('status','ASC')" style = "<?php echo ($sort_by == 'proj_statuses.name' && $order == 'DESC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_up_project_status_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_up_icon.svg'); ?>" alt="chevron_sort_up_icon">
420 + <img width="16" height="16" onclick="wppm_sort_up_project_list('status','DESC')" style = "<?php echo ($sort_by == 'proj_statuses.name' && $order == 'ASC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_down_project_status_img" class="wppm_chevron_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_down_icon.svg'); ?>" alt="chevron_sort_down_icon">
421 + </th>
422 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
423 + <span id="wppm_proj_list_users_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Users','taskbuilder'); ?></span></th>
424 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
425 + <span id="wppm_project_category_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Category','taskbuilder'); ?></span>
426 + <img width="16" height="16" onclick="wppm_sort_up_project_list('category','ASC')" style = "<?php echo ($sort_by == 'proj_categories.name' && $order == 'DESC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_up_project_cat_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_up_icon.svg'); ?>" alt="chevron_sort_up_icon">
427 + <img width="16" height="16" onclick="wppm_sort_up_project_list('category','DESC')" style = "<?php echo ($sort_by == 'proj_categories.name' && $order == 'ASC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_down_project_cat_img" class="wppm_chevron_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_down_icon.svg'); ?>" alt="chevron_sort_down_icon">
428 + </th>
429 + <?php if($wppm_default_project_date==1 && $wppm_deafault_time_duration_project==0){ ?>
430 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
431 + <span id="wppm_project_start_date_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Start Date','taskbuilder'); ?></span>
432 + <img width="16" height="16" onclick="wppm_sort_up_project_list('start_date','ASC')" style = "<?php echo ($sort_by == 'start_date' && $order == 'DESC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_up_project_start_date_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_up_icon.svg'); ?>" alt="chevron_sort_up_icon">
433 + <img width="16" height="16" onclick="wppm_sort_up_project_list('start_date','DESC')" style = "<?php echo ($sort_by == 'start_date' && $order == 'ASC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_down_project_start_date_img" class="wppm_chevron_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_down_icon.svg'); ?>" alt="chevron_sort_down_icon">
434 + </th>
435 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
436 + <span id="wppm_project_end_date_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('End Date','taskbuilder'); ?></span>
437 + <img width="16" height="16" onclick="wppm_sort_up_project_list('end_date','ASC')" style = "<?php echo ($sort_by == 'end_date' && $order == 'DESC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_up_project_end_date_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_up_icon.svg'); ?>" alt="chevron_sort_up_icon">
438 + <img width="16" height="16" onclick="wppm_sort_up_project_list('end_date','DESC')" style = "<?php echo ($sort_by == 'end_date' && $order == 'ASC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_down_project_end_date_img" class="wppm_chevron_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_down_icon.svg'); ?>" alt="chevron_sort_down_icon">
439 + </th>
440 + <?php }
441 + if( $wppm_deafault_time_duration_project==1){ ?>
442 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
443 + <span id="wppm_project_time_duration_th" style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('Duration','taskbuilder'); ?></span>
444 + <img width="16" height="16" onclick="wppm_sort_up_project_list('TIMESTAMPDIFF(SECOND, start_date, end_date)','ASC')" style = "<?php echo ($sort_by == 'TIMESTAMPDIFF(SECOND, start_date, end_date)' && $order == 'DESC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_up_project_time_duration_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_up_icon.svg'); ?>" alt="chevron_sort_up_icon">
445 + <img width="16" height="16" onclick="wppm_sort_up_project_list('TIMESTAMPDIFF(SECOND, start_date, end_date)','DESC')" style = "<?php echo ($sort_by == 'TIMESTAMPDIFF(SECOND, start_date, end_date)' && $order == 'ASC') ? 'display:inline': 'display:none;'?>" class="wppm_chevron_img" id="wppm_chevron_sort_down_project_time_duration_img" class="wppm_chevron_img" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/sort_down_icon.svg'); ?>" alt="chevron_sort_down_icon">
446 + </th>
447 + <?php }?>
448 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>"><span style="color:<?php echo esc_attr($appearance_settings['list-header-text-color'])?>"><?php echo esc_html_e('No. of tasks','taskbuilder'); ?></span></th>
449 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>"></th>
450 + </tr>
451 + <tbody>
452 + <?php
453 + $total_projects=0;
454 + $users = array();
455 + if(!empty($wppm_fillter)){
456 + foreach( $wppm_fillter as $project ){
457 + $total_projects++;
458 + $proejctdata = $wppmfunction->get_project($project->id);
459 + $wppm_proj_duration = $wppmfunction->wppm_get_duration($project->start_date,$project->end_date);
460 + $pstatus= absint($project->status);
461 + $status = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_project_statuses where id='$pstatus'" );
462 + $users = explode(",",$project->users);
463 + $pid= absint($project->id);
464 + if(isset($project->cat_id)){
465 + $pcat_id = absint($project->cat_id);
466 + $category = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_categories where id='$pcat_id'" );
467 + }
468 + if(isset($project->id)){
469 + if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin'){
470 + $no_of_tasks = $wpdb->get_var("SELECT count(*) FROM {$wpdb->prefix}wppm_task WHERE project='$pid' AND (parent_task_id = 0 OR parent_task_id IS NULL) ");
471 + }else{
472 + $query =("SELECT count(*) FROM
473 + ( SELECT Task.*
474 + FROM {$wpdb->prefix}wppm_task AS Task
475 + Left join {$wpdb->prefix}wppm_project proj ON Task.project = proj.id
476 + Left join {$wpdb->prefix}wppm_project_users proj_users ON Task.project = proj_users.proj_id
477 + Left join {$wpdb->prefix}wppm_project_meta proj_meta ON proj.id = proj_meta.project_id
478 + where Task.project = '$pid' AND (Task.parent_task_id = 0 OR Task.parent_task_id IS NULL) 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 ) OR (proj.id = 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 ) AS Task");
479 + $no_of_tasks = $wpdb->get_var($query);
480 + }
481 + $no_of_tasks = apply_filters('wppm_no_of_task_proj_list_query',$no_of_tasks,$project->id);
482 + }
483 + if($wppm_project_time == 1){
484 + $psDate = new DateTime($project->start_date);
485 + $peDate = new DateTime($project->end_date);
486 + if($project->start_date=='0000-00-00 00:00:00'){
487 + if($wppm_date_setting=='Y-m-d H:i:s'){
488 + $proj_start_date = '0000-00-00 00:00:00';
489 + }elseif($wppm_date_setting=='d-m-Y H:i:s'){
490 + $proj_start_date = '00-00-0000 00:00:00';
491 + }elseif($wppm_date_setting=='m-d-Y H:i:s'){
492 + $proj_start_date = '00-00-0000 00:00:00';
493 + }else{
494 + $proj_start_date = '0000-00-00 00:00:00';
495 + }
496 + }if($project->end_date=='0000-00-00 00:00:00'){
497 + if($wppm_date_setting=='Y-m-d H:i:s'){
498 + $proj_end_date = '0000-00-00 00:00:00';
499 + }elseif($wppm_date_setting=='d-m-Y H:i:s'){
500 + $proj_end_date = '00-00-0000 00:00:00';
501 + }elseif($wppm_date_setting=='m-d-Y H:i:s'){
502 + $proj_end_date = '00-00-0000 00:00:00';
503 + }else{
504 + $proj_end_date = '0000-00-00 00:00:00';
505 + }
506 + }
507 + if($project->start_date!='0000-00-00 00:00:00'){
508 + if(!empty($wppm_date_setting)){
509 + $proj_start_date = $psDate->format($wppm_date_setting);
510 + }else{
511 + $proj_start_date = isset($project->start_date)? $project->start_date:"";
512 + }
513 + }
514 + if($project->end_date!='0000-00-00 00:00:00'){
515 + if(!empty($wppm_date_setting)){
516 + $proj_end_date = $peDate->format($wppm_date_setting);
517 + }else{
518 + $proj_end_date = isset($project->end_date) ? $project->end_date: "" ;
519 + }
520 + }
521 + } elseif($wppm_project_time == 0){
522 + $psDate = new DateTime($project->start_date);
523 + $peDate = new DateTime($project->end_date);
524 + $proj_start_date = $psDate->format('Y-m-d');
525 + $proj_end_date = $peDate->format('Y-m-d');
526 + if($project->start_date=='0000-00-00 00:00:00'){
527 + if($wppm_date_setting=='Y-m-d H:i:s'){
528 + $proj_start_date = '0000-00-00';
529 + }elseif($wppm_date_setting=='d-m-Y H:i:s'){
530 + $proj_start_date = '00-00-0000';
531 + }elseif($wppm_date_setting=='m-d-Y H:i:s'){
532 + $proj_start_date = '00-00-0000';
533 + }else{
534 + $proj_start_date = '0000-00-00';
535 + }
536 + }
537 + if($project->end_date=='0000-00-00 00:00:00'){
538 + if($wppm_date_setting=='Y-m-d H:i:s'){
539 + $proj_end_date = '0000-00-00';
540 + }elseif($wppm_date_setting=='d-m-Y H:i:s'){
541 + $proj_end_date = '00-00-0000';
542 + }elseif($wppm_date_setting=='m-d-Y H:i:s'){
543 + $proj_end_date = '00-00-0000';
544 + }else{
545 + $proj_end_date = '0000-00-00';
546 + }
547 +
548 + }if($project->start_date!='0000-00-00 00:00:00'){
549 + if($wppm_date_setting=='Y-m-d H:i:s'){
550 + $proj_start_date = $psDate->format('Y-m-d');
551 + }elseif($wppm_date_setting=='d-m-Y H:i:s'){
552 + $proj_start_date = $psDate->format('d-m-Y');
553 + }elseif($wppm_date_setting=='m-d-Y H:i:s'){
554 + $proj_start_date = $psDate->format('m-d-Y');
555 + }else{
556 + $proj_start_date = $psDate->format('Y-m-d');
557 + }
558 + }
559 + if($project->end_date!='0000-00-00 00:00:00'){
560 + if($wppm_date_setting=='Y-m-d H:i:s'){
561 + $proj_end_date = $peDate->format('Y-m-d');
562 + }elseif($wppm_date_setting=='d-m-Y H:i:s'){
563 + $proj_end_date = $peDate->format('d-m-Y');
564 + }elseif($wppm_date_setting=='m-d-Y H:i:s'){
565 + $proj_end_date = $peDate->format('m-d-Y');
566 + }else{
567 + $proj_end_date = $peDate->format('Y-m-d');
568 + }
569 + }
570 + }
571 + ?>
572 + <tr onclick="if(link)wppm_open_project(<?php echo esc_attr($project->id) ?>)">
573 + <td class="bulk-selector" onmouseover="link=false;" onmouseout="link=true;">
574 + <div class="wppm-pl-item-selector">
575 + <div class="checkbox-container">
576 + <input id="wppm_bulk_select_<?php echo esc_attr($project->id) ?>" class="wppm-bulk-select" type="checkbox" onchange="wppm_bulk_item_select_change();" value="<?php echo esc_attr( $project->id ); ?>"/>
577 + <label for="wppm_bulk_select_<?php echo esc_attr($project->id) ?>"></label>
578 + </div>
579 + </div>
580 + </td>
581 + <td onmouseover="link=true;"><?php echo esc_html($project->project_name) ?></td>
582 + <td onmouseover="link=true;"><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($status->name) ?></span></td>
583 + <td onmouseover="link=true;">
584 + <?php
585 + $i=0;
586 + if(!empty(array_filter($users))){
587 + foreach($users as $user){
588 + $i++;
589 + if( $i <= 4 ){
590 + $user_info = get_user_by('id', $user );
591 + if(!empty($user_info)){
592 + ?>
593 + <a href="#" title="<?php echo esc_html($user_info->display_name) ?>">
594 + <?php echo get_avatar($user_info->ID, 25, "mysteryman");?>
595 + </a> <?php
596 + }
597 + }
598 + }
599 + } else{
600 + esc_html_e('None','taskbuilder');
601 + }
602 + if($i > 4){
603 + ?>
604 + <a href="#" class="wppm_avatar">
605 + <span id="wppm_avatar" style="background-color:black;" class="avatar">+<?php echo esc_html($i-4) ?></span>
606 + </a>
607 + <?php } ?>
608 + </td>
609 + <td onmouseover="link=true;" class="wppm_table_td"><?php echo isset($category) ? esc_html($category): "" ?></td>
610 + <?php if($wppm_default_project_date==1 && $wppm_deafault_time_duration_project==0){ ?>
611 + <td onmouseover="link=true;" class="wppm_table_td"><?php echo isset($proj_start_date) ? esc_html($proj_start_date): "" ?></td>
612 + <?php
613 + 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')) {
614 + $style = "color:#FF0000";
615 + } else {
616 + $style = "color:#2C3E50";
617 + } ?>
618 + <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>
619 + <?php } ?>
620 + <?php if($wppm_deafault_time_duration_project==1){ ?>
621 + <?php
622 + 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')) {
623 + $style = "color:#FF0000";
624 + } else {
625 + $style = "color:#2C3E50";
626 + } ?>
627 + <td onmouseover="link=true;" class="wppm_table_td"><span style="<?php echo esc_attr($style); ?>"><?php echo isset($wppm_proj_duration) ? esc_html($wppm_proj_duration):"" ?></span></td>
628 + <?php } ?>
629 + <td onmouseover="link=true;" class="wppm_table_td"><?php echo isset($no_of_tasks) ? esc_html($no_of_tasks):"" ?></td>
630 + <td onmouseover="link=true;" class="wppm_delete_action">
631 + <?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"; ?>
632 + <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>
633 + <?php ?>
634 + </td>
635 + </tr>
636 + <?php
637 + }
638 + }
639 + ?>
640 + </tbody>
641 + </table>
642 + <?php
643 + $total_pages=ceil($totalrows/$proj_per_page);
644 + $current_page=$page_no+1;
645 + $prev_page_no=$current_page-1;
646 + $prev_class=($prev_page_no==0)?'disabled':'';
647 + $next_page_no=($total_pages==$current_page)? $current_page-1:$current_page;
648 + $next_class=($total_pages==$current_page)?'disabled':'';
649 + ?>
650 + <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>
651 + <hr style="<?php echo esc_attr($total_pages==0)? '':'display: none;';?>">
652 + </div>
653 + <div class="row wppm_proj_pagination_container">
654 + <div class="col-sm-4">
655 + <?php echo esc_html_e('Total:','taskbuilder'); ?>&nbsp;<?php echo esc_html($total_projects) ?>&nbsp;<?php echo esc_html_e('of','taskbuilder') ?>&nbsp;<?php echo esc_html($totalrows) ?>&nbsp;<?php echo esc_html_e('Projects','taskbuilder')?>
656 + </div>
657 + <div class="col-sm-4">
658 + <div class="wppm_proj_pagination" style="<?php echo esc_attr($total_pages==0)? "display:none;":"display:flex;"?>">
659 + <span class="wppm-pagination-txt">
660 + <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>
661 + </span>
662 + <span
663 + <?php echo esc_html($prev_class) ?>
664 + style="<?php echo (isset($prev_class) && esc_attr($prev_class) == 'disabled') ? 'display:none;':'display:block;'?>">
665 + <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_attr($sort_by)?>','<?php echo esc_attr($order) ?>','<?php echo esc_attr($is_archieved)?>');"><?php echo esc_html_e('PREV','taskbuilder');?></a>
666 + </span>
667 + <span
668 + <?php echo esc_attr($next_class) ?>
669 + style="<?php echo (isset($next_class) && $next_class == 'disabled')?'display:none;':'display:block;'?>cursor:pointer;">
670 + <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($sort_by)?>','<?php echo esc_attr($order) ?>','<?php echo esc_attr($is_archieved)?>');"><?php echo esc_html_e('NEXT','taskbuilder');?></a>
671 + </span>
672 + </div>
673 + </div>
674 + </div>
675 + </div>
676 + </div>
677 +</form>
678 +<style>
679 + #wppm_project_table tr:nth-child(even) td{
680 + background-color:<?php echo esc_attr($appearance_settings['list-item-even-background-color'])?>!important;
681 + color:<?php echo esc_attr($appearance_settings['list-item-even-text-color'])?>!important;
682 + }
683 + #wppm_project_table tr:nth-child(odd) td{
684 + background-color:<?php echo esc_attr($appearance_settings['list-item-odd-background-color'])?>!important;
685 + color:<?php echo esc_attr($appearance_settings['list-item-odd-text-color'])?>!important;
686 + }
687 + #wppm_project_table tr:hover td{
688 + background-color:<?php echo esc_attr($appearance_settings['list-item-hover-background-color'])?>!important;
689 + }
690 + #wppm_project_table tr:hover td{
691 + color: <?php echo esc_attr($appearance_settings['list-item-hover-text-color'])?>!important;
692 + }
693 + #wppm_add_new_project_btn:hover,#wppm_project_list:hover,#wppm_archieve_project_btn:hover{
694 + background-color: <?php echo esc_attr($appearance_settings['list-header-button-hover-color'])?>!important;
695 + }
696 +</style>
697 +<script type="text/javascript">
698 + jQuery( document ).ready( function( jQuery ) {
699 + let createdBy = <?php echo wp_json_encode(array_map('strval', $advanced_filter['created_by'] ?? [])); ?>;
700 + let assignedUsers = <?php echo wp_json_encode(array_map('strval', $advanced_filter['assigned'] ?? [])); ?>;
701 + let categoryIds = <?php echo wp_json_encode(array_map('strval', $advanced_filter['category'] ?? [])); ?>;
702 + jQuery('#tb-created-by').select2({ width: '100%', dropdownParent: jQuery('#tb-advanced-panel') });
703 + jQuery('#tb-assigned').select2({ width: '100%', dropdownParent: jQuery('#tb-advanced-panel') });
704 + jQuery('#tb-category').select2({ width: '100%', dropdownParent: jQuery('#tb-advanced-panel') });
705 + jQuery('#tb-created-by').val(createdBy).trigger('change');
706 + jQuery('#tb-assigned').val(assignedUsers).trigger('change');
707 + jQuery('#tb-category').val(categoryIds).trigger('change');
708 + jQuery('#tb-start-date').val('<?php echo esc_attr($advanced_filter['start_date'] ?? ''); ?>');
709 + jQuery('#tb-end-date').val('<?php echo esc_attr($advanced_filter['end_date'] ?? ''); ?>');
710 +
711 + window.projectFilters = window.projectFilters || {
712 + created_by: createdBy,
713 + assigned: assignedUsers,
714 + category: categoryIds,
715 + start_date: '<?php echo esc_js($advanced_filter['start_date'] ?? ''); ?>',
716 + end_date: '<?php echo esc_js($advanced_filter['end_date'] ?? ''); ?>'
717 + };
718 +
719 + jQuery(document).off("click", "#tb-apply-filter").on("click", "#tb-apply-filter", function (e) {
720 + e.preventDefault();
721 + window.projectFilters = {
722 + created_by: jQuery("#tb-created-by").val() || [],
723 + assigned: jQuery("#tb-assigned").val() || [],
724 + category: jQuery("#tb-category").val() || [],
725 + start_date: jQuery("#tb-start-date").val() || "",
726 + end_date: jQuery("#tb-end-date").val() || ""
727 + };
728 + renderActiveFilters(window.projectFilters);
729 + setProjectListFilterCookie(window.projectFilters);
730 + triggerProjectFilter(1, window.projectFilters, <?php echo (int) $is_archieved; ?>);
731 + });
732 +
733 + jQuery(document).off("click", ".tb-remove").on("click", ".tb-remove", function () {
734 + let key = jQuery(this).attr("data-key");
735 + let value = jQuery(this).attr("data-value");
736 + if (key === "date") {
737 + window.projectFilters.start_date = "";
738 + window.projectFilters.end_date = "";
739 + jQuery("#tb-start-date").val("");
740 + jQuery("#tb-end-date").val("");
741 + } else {
742 + window.projectFilters[key] = (window.projectFilters[key] || [])
743 + .map(String)
744 + .filter(v => v !== String(value));
745 + jQuery(`#tb-${key}`).val(window.projectFilters[key]).trigger("change");
746 + }
747 + jQuery(this).closest(".tb-chip").remove();
748 + syncUIWithFilters(window.projectFilters);
749 + setProjectListFilterCookie(window.projectFilters);
750 + triggerProjectFilter(1, window.projectFilters, <?php echo (int) $is_archieved; ?>);
751 + });
752 +
753 + jQuery(document).off("click", "#tb-reset-filter").on("click", "#tb-reset-filter", function () {
754 + resetProjectFilters(<?php echo (int) $is_archieved; ?>);
755 + });
756 +
757 + let savedProjectFilters = getProjectListFilterCookie();
758 + if (savedProjectFilters && typeof savedProjectFilters === "object") {
759 + window.projectFilters = {
760 + created_by: savedProjectFilters.created_by || [],
761 + assigned: savedProjectFilters.assigned || [],
762 + category: savedProjectFilters.category || [],
763 + start_date: savedProjectFilters.start_date || "",
764 + end_date: savedProjectFilters.end_date || ""
765 + };
766 + }
767 + setTimeout(function () {
768 + syncUIWithFilters(window.projectFilters);
769 + renderActiveFilters(window.projectFilters);
770 + }, 100);
771 +
772 + jQuery(document).off("click", "#tb-advanced-toggle").on("click", "#tb-advanced-toggle", function (e) {
773 + e.stopPropagation();
774 + jQuery("#tb-advanced-panel").toggleClass("tb-open");
775 + });
776 + jQuery(document).off("click", "#tb-backdrop").on("click", "#tb-backdrop", function () {
777 + jQuery("#tb-advanced-panel").removeClass("tb-open");
778 + jQuery(this).removeClass("active");
779 + });
780 + jQuery(document).off("click.tbProjOutside").on("click.tbProjOutside", function (e) {
781 + if (window.innerWidth > 768) {
782 + if (!jQuery(e.target).closest("#tb-advanced-panel, #tb-advanced-toggle").length) {
783 + jQuery("#tb-advanced-panel").removeClass("tb-open");
784 + }
785 + }
786 + });
787 + jQuery(document).off("click", "#tb-close-filters").on("click", "#tb-close-filters", function () {
788 + jQuery("#tb-advanced-panel").removeClass("tb-open");
789 + jQuery("#tb-backdrop").removeClass("active");
790 + });
791 +
792 + jQuery("input[name='wppm_project_search_filter']").keypress(function(e) {
793 + //Enter key
794 + if (e.which == 13) {
795 + wppm_project_search_filter(<?php echo $is_archieved ?>);
796 + }
797 + });
798 + jQuery("#wppm_proj_name_th").hover(function(){
799 + jQuery('#wppm_chevron_sort_up_project_name_img').show();
800 + jQuery('#wppm_chevron_sort_down_project_name_img').hide();
801 + });
802 + jQuery("#wppm_project_status_th").hover(function(){
803 + jQuery('#wppm_chevron_sort_up_project_status_img').show();
804 + jQuery('#wppm_chevron_sort_down_project_status_img').hide();
805 + });
806 + jQuery("#wppm_project_category_th").hover(function(){
807 + jQuery('#wppm_chevron_sort_up_project_cat_img').show();
808 + jQuery('#wppm_chevron_sort_down_project_cat_img').hide();
809 + });
810 + jQuery("#wppm_project_start_date_th").hover(function(){
811 + jQuery('#wppm_chevron_sort_up_project_start_date_img').show();
812 + jQuery('#wppm_chevron_sort_down_project_start_date_img').hide();
813 + });
814 + jQuery("#wppm_project_end_date_th").hover(function(){
815 + jQuery('#wppm_chevron_sort_up_project_end_date_img').show();
816 + jQuery('#wppm_chevron_sort_down_project_end_date_img').hide();
817 + });
818 + jQuery("#wppm_project_time_duration_th").hover(function(){
819 + jQuery('#wppm_chevron_sort_up_project_time_duration_img').show();
820 + jQuery('#wppm_chevron_sort_down_project_time_duration_img').hide();
821 + });
822 + jQuery(".wppm_delete_action").on("click", function(e){
823 + e.preventDefault();
824 + return false;
825 + });
826 +
827 + jQuery('#wppm_project_list_frm').on('submit', function (e) {
828 + var dataform = new FormData(jQuery('#wppm_project_list_frm')[0]);
829 + jQuery.ajax({
830 + url: wppm_admin.ajax_url,
831 + type: 'POST',
832 + data: dataform,
833 + processData: false,
834 + contentType: false,
835 + success: function () {
836 + alert('form was submitted');
837 + }
838 + });
839 + });
840 + });
841 + /**
842 + * Bulk item selector change
843 + */
844 +function wppm_bulk_item_select_change() {
845 + jQuery("#wppm-bulk-actions-btn").show();
846 + var items = jQuery(".wppm-bulk-select:checked");
847 + var checked = items.length === 0 ? false : true;
848 + if(checked){
849 + jQuery(".wppm-bulk-selector").prop("checked", checked);
850 + }else{
851 + jQuery("#wppm-bulk-actions-btn").hide();
852 + jQuery(".wppm-bulk-selector").prop("checked", false);
853 + }
854 +}
855 +</script>
856 +<?php
857 +add_action('wp_footer', 'wppm_page_inline_script', 999999999999999999);
858 +do_action('wppm_after_shortcode_loaded');
859 +if(!function_exists('wppm_page_inline_script')) {
860 + function wppm_page_inline_script() { ?>
861 + <script type="text/javascript">
862 + jQuery( document ).ready( function( jQuery ) {
863 + wppm_get_project_list();
864 + });
865 + </script>
866 + <?php }
867 +}
649 868 ?>