PluginProbe
Taskbuilder – Project Management & Task Management Tool With Kanban Board / 3.0.6
Taskbuilder – Project Management & Task Management Tool With Kanban Board v3.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 1.0.6 All 57 releases
← All changes | includes/admin/projects/projects_list.php +457 -648 trunk → 3.0.6 View file →
@@ -1,649 +1,458 @@
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 +$appearance_settings = get_option("wppm-ap-project-list");
9 +$wppm_current_user_capability = get_user_meta( $current_user->ID, 'wppm_capability', true );
10 +$proj_per_page = 20;
11 +$page_no = (isset($_POST['page_no'])) ? intval(sanitize_text_field($_POST['page_no'])): '0';
12 +$search_tag = isset($_POST['project_search']) ? sanitize_text_field($_POST['project_search']) : '';
13 +$order = isset($_POST['order']) ? sanitize_text_field($_POST['order']) :"ASC";
14 +$sort_by = isset($_POST['sort_by']) ? sanitize_text_field($_POST['sort_by']):"project_name";
15 +$filter_by = isset($_POST['wppm_project_filter']) ? sanitize_text_field($_POST['wppm_project_filter']) : "all";
16 +$current_date = date('Y-m-d');
17 +$wppm_pl_filter = "1=1";
18 +$filters = array(
19 + 'sort_by' => $sort_by,
20 + 'order' => $order,
21 + 'search' => $search_tag,
22 + 'filter'=>$filter_by
23 +);
24 +$pl_filters = isset( $_COOKIE['wppm_proj_filters'] ) ? sanitize_text_field( wp_unslash( $_COOKIE['wppm_proj_filters'] ) ) : $filters;
25 +if(!is_array($pl_filters)){
26 + $pl_filters = json_decode($pl_filters);
27 + $pl_filters_arr = (array) $pl_filters;
28 +} else{
29 + $pl_filters_arr = $filters;
30 +}
31 +$search_tag = isset($_POST['project_search']) ? sanitize_text_field($_POST['project_search']) : $pl_filters_arr['search'];
32 +$order = isset($_POST['order']) ? sanitize_text_field($_POST['order']) :$pl_filters_arr['order'];
33 +$sort_by = isset($_POST['sort_by']) ? sanitize_text_field($_POST['sort_by']):$pl_filters_arr['sort_by'];
34 +$filter_by = isset($_POST['wppm_project_filter']) ? sanitize_text_field($_POST['wppm_project_filter']) : $pl_filters_arr['filter'];
35 +if($sort_by == ""){
36 + $sort_by = 'project_name';
37 +}
38 +$filters = array(
39 + 'sort_by' => $sort_by,
40 + 'order' => $order,
41 + 'search'=>$search_tag,
42 + 'filter'=>$filter_by
43 +);
44 +setcookie('wppm_proj_filters',wp_json_encode( $filters ),time() + 3600);
45 +if($pl_filters_arr['sort_by']=='status'){
46 + $sort_by = 'proj_statuses.name';
47 +}
48 +if($pl_filters_arr['sort_by']=='category'){
49 + $sort_by = 'proj_categories.name';
50 +}
51 +if($pl_filters_arr['sort_by']=='start_date'){
52 + $sort_by = 'start_date';
53 +}
54 +if($pl_filters_arr['sort_by']=='end_date'){
55 + $sort_by = 'end_date';
56 +}
57 +if($sort_by=='category'){
58 + $sort_by = 'proj_categories.name';
59 +}
60 +if($filter_by=='completed'){
61 + $wppm_pl_filter = "status='4'";
62 +}elseif($filter_by=='overdue'){
63 + $wppm_pl_filter = "status!='4' AND (CAST(end_date AS DATE)) < '$current_date'";
64 +}elseif($filter_by == 'unassigned'){
65 + $wppm_pl_filter = "users=''";
66 +}elseif($filter_by == 'new'){
67 + $wppm_pl_filter = "status='1'";
68 +}elseif($filter_by == 'inprogress'){
69 + $wppm_pl_filter = "status='2'";
70 +}elseif($filter_by == 'hold'){
71 + $wppm_pl_filter = "status='3'";
72 +}elseif($filter_by == 'mine'){
73 + $wppm_pl_filter = "(FIND_IN_SET('$current_user->ID',users)>0)";
74 +}
75 +$wppm_project_time = get_option('wppm_project_time');
76 +$wppm_default_project_date = get_option('wppm_default_project_date');
77 +$sort_by = apply_filters('wppm_project_list_sort_by_query',$sort_by);
78 +$order = apply_filters('wppm_project_list_order_query',$order);
79 +$search_tag_text = '%'.$wpdb->esc_like($search_tag).'%';
80 +if(!empty($search_tag)){
81 + $search_tag_text = '%'.$wpdb->esc_like($search_tag).'%';
82 + $query = ("SELECT Project.*
83 + FROM {$wpdb->prefix}wppm_project AS Project
84 + Left join {$wpdb->prefix}wppm_project_statuses proj_statuses ON Project.status = proj_statuses.id
85 + Left join {$wpdb->prefix}wppm_project_categories proj_categories ON Project.cat_id = proj_categories.id
86 + Left join {$wpdb->base_prefix}users user ON (FIND_IN_SET(user.ID,Project.users)>0) AND (user.display_name LIKE '$search_tag_text')
87 + Left join {$wpdb->prefix}wppm_project_meta proj_meta ON Project.id = proj_meta.project_id
88 + ");
89 + if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin'){
90 + $where = " where $wppm_pl_filter AND (Project.project_name LIKE '$search_tag_text' OR proj_statuses.name LIKE '$search_tag_text' OR proj_categories.name LIKE '$search_tag_text' OR ( user.display_name LIKE '$search_tag_text'))";
91 + }else{
92 + $where = " where $wppm_pl_filter AND (Project.project_name LIKE '$search_tag_text' OR proj_statuses.name LIKE '$search_tag_text' OR proj_categories.name LIKE '$search_tag_text' OR ( user.display_name LIKE '$search_tag_text')) AND ((FIND_IN_SET('$current_user->ID',Project.users)>0) OR (Project.id = proj_meta.project_id AND proj_meta.meta_key='public_project' AND proj_meta.meta_value=1) OR Project.created_by='$current_user->ID')";
93 + }
94 +}else{
95 + if($sort_by=='project_name'|| $sort_by=='start_date' || $sort_by=='end_date'){
96 + $query = ( "SELECT Project.* FROM {$wpdb->prefix}wppm_project AS Project
97 + Left join {$wpdb->prefix}wppm_project_meta proj_meta ON Project.id = proj_meta.project_id
98 + ");
99 + } else{
100 + $query = ( "SELECT Project.* FROM {$wpdb->prefix}wppm_project AS Project
101 + Left join {$wpdb->prefix}wppm_project_statuses proj_statuses ON Project.status = proj_statuses.id
102 + Left join {$wpdb->prefix}wppm_project_categories proj_categories ON Project.cat_id = proj_categories.id
103 + Left join {$wpdb->prefix}wppm_project_meta proj_meta ON Project.id = proj_meta.project_id
104 + ");
105 + }
106 + if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin'){
107 + $where = " where $wppm_pl_filter";
108 + }else{
109 + $where = " where ($wppm_pl_filter AND (FIND_IN_SET('$current_user->ID',Project.users)>0 OR (Project.id = proj_meta.project_id AND proj_meta.meta_key='public_project' AND proj_meta.meta_value=1)) OR Project.created_by='$current_user->ID')";
110 + }
111 +}
112 +$no_of_rows = ( "SELECT count(*) FROM ($query");
113 +$no_of_rows = apply_filters('wppm_project_list_no_of_rows',$no_of_rows,$wppm_pl_filter,$search_tag);
114 +$where = apply_filters('wppm_project_list_query_where',$where, $wppm_pl_filter,$search_tag);
115 +$query .= $where." Group by Project.id ORDER BY $sort_by $order";
116 +$no_of_rows .= $where." Group by Project.id) AS Project";
117 +$totalrows = $wpdb->get_var( $no_of_rows );
118 +$query = apply_filters('wppm_project_list_query',$query);
119 +$limit_start=$page_no*$proj_per_page;
120 +$limit="\n LIMIT ".$limit_start.",".$proj_per_page." ";
121 +$query = $query.$limit;
122 +$wppm_fillter = $wpdb->get_results($query);
123 +?>
124 +<form id="wppm_project_list_frm">
125 + <div id="wppm-container">
126 + <div id="wppm_project_list_container" class="wppm_bootstrap">
127 + <div class="row">
128 + <div class="col-sm-6" id="wppm_heading_inline">
129 + <span class="wppm-heading-inline">
130 + <?php echo esc_html_e('Projects','taskbuilder');?>
131 + </span>
132 + <?php if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_manager'|| $wppm_current_user_capability == 'wppm_admin' ){ ?>
133 + <img width="25" height="30" id="wppm_add_new_project_btn" class="wppm_add_new_project_btn" onclick="wppm_add_new_project()" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/add.svg'); ?>" alt="add">
134 + <?php } ?>
135 + </div>
136 + <div id="wppm_project_and_task_search" class="col-sm-6">
137 + <img width="25px" id="wppm_project_search_filter_img" height="15px" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/search.svg'); ?>" alt="search">
138 + <input type="search" id="wppm_project_search_filter" name="wppm_project_search_filter" class="form-control form-control-sm" aria-controls="selection-datatable" placeholder="<?php echo esc_attr__('Search','taskbuilder');?>" value="<?php echo (!empty($search_tag)) ? esc_attr($search_tag) : "" ?>">
139 + </div>
140 + </div>
141 + <div class="row">
142 + <div class="col-sm-6" id="wppm_project_filter_container">
143 + <div class="wppm-filter-item">
144 + <label for="wppm_project_filter"> <?php echo esc_html_e('Filter','taskbuilder');?></label>
145 + <select id="wppm_project_filter" name="wppm_project_filter" onchange="wppm_apply_project_filter()">
146 + <option value="all"<?php echo ($filter_by == "all")? 'selected':""?>><?php echo esc_html_e('All','taskbuilder');?></option>
147 + <option value="new" <?php echo ($filter_by == "new")? 'selected':""?>><?php echo esc_html_e('New','taskbuilder');?></option>
148 + <option value="inprogress" <?php echo ($filter_by == "inprogress")? 'selected':""?>><?php echo esc_html_e('In Progress','taskbuilder');?></option>
149 + <option value="hold" <?php echo ($filter_by == "hold")? 'selected':""?>><?php echo esc_html_e('Hold','taskbuilder');?></option>
150 + <option value="completed" <?php echo ($filter_by == "completed")? 'selected':""?>><?php echo esc_html_e('Completed','taskbuilder');?></option>
151 + <option value="mine" <?php echo ($filter_by == "mine")? 'selected':""?>><?php echo esc_html_e('Mine','taskbuilder');?></option>
152 + <option value="unassigned" <?php echo ($filter_by == "unassigned")? 'selected':""?>><?php echo esc_html_e('Unassigned','taskbuilder');?></option>
153 + <option value="overdue" <?php echo ($filter_by == "overdue")? 'selected':""?>><?php echo esc_html_e('Overdue','taskbuilder');?></option>
154 + </select>
155 + </div>
156 + <div class="wppm_display_submit">
157 + <div class="wppm-filter-actions">
158 + <span class="wppm-link" onclick="wppm_pl_reset_filter()"> <?php echo esc_html_e('Reset','taskbuilder');?></span>
159 + </div>
160 + </div>
161 + </div>
162 + </div>
163 + <div class="row">
164 + <div class="col-sm-12">
165 + <div class="wppm-bulk-actions">
166 + <button
167 + id="wppm-bulk-actions-btn"
168 + class="wppm-button small secondary"
169 + type="button"
170 + style="display:none"
171 + data-popover="wppm-bulk-actions">
172 + <?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">
173 + </button>
174 + <div id="wppm-bulk-actions" class="gpopover wppm-popover-menu wppm-proj-bulk-actions">
175 + <div class="wppm-popover-menu-item" onclick="wppm_bulk_change_status('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_change_status' ) ); ?>');">
176 + <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>
177 + </div>
178 + <div class="wppm-popover-menu-item" onclick="wppm_bulk_change_category('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_change_category' ) ); ?>');">
179 + <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>
180 + </div>
181 + <div class="wppm-popover-menu-item" onclick="wppm_bulk_assign_users('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_assign_users' ) ); ?>');">
182 + <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>
183 + </div>
184 + <div class="wppm-popover-menu-item" onclick="wppm_bulk_delete_project('<?php echo esc_attr( wp_create_nonce( 'wppm_bulk_assign_users' ) ); ?>');">
185 + <span><img style="margin-right:5px;" src="<?php echo esc_url( WPPM_PLUGIN_URL . 'asset/images/trash-alt-solid.svg'); ?>" alt="delete"><?php echo esc_html_e('Delete','taskbuilder'); ?></span>
186 + </div>
187 + </div>
188 + </div>
189 + </div>
190 + </div>
191 + <script>
192 + jQuery('#wppm-more-actions-btn, #wppm-bulk-actions-btn').gpopover({width: 200});
193 + </script>
194 + <div class="table-responsive">
195 + <table id="wppm_project_table" class="wppm_table table">
196 + <tr>
197 + <th style="width: 45px;" onchange="wppm_bulk_select_change()">
198 + <div class="checkbox-container">
199 + <input id="wppm_bulk_select_option" class="wppm-bulk-selector" type="checkbox" onchange="wppm_bulk_select_change();"/>
200 + <label for="wppm_bulk_select_option"></label>
201 + </div>
202 + </th>
203 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
204 + <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>
205 + <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">
206 + <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">
207 + </th>
208 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
209 + <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>
210 + <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">
211 + <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">
212 + </th>
213 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
214 + <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>
215 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
216 + <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>
217 + <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">
218 + <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">
219 + </th>
220 + <?php if($wppm_default_project_date==1){ ?>
221 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
222 + <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>
223 + <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">
224 + <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">
225 + </th>
226 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>">
227 + <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>
228 + <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">
229 + <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">
230 + </th>
231 + <?php } ?>
232 + <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>
233 + <th class="wppm_table_header" style="background-color:<?php echo esc_attr($appearance_settings['list-header-background-color'])?>"></th>
234 + </tr>
235 + <tbody>
236 + <?php
237 + $total_projects=0;
238 + $users = array();
239 + if(!empty($wppm_fillter)){
240 + foreach( $wppm_fillter as $project ){
241 + $total_projects++;
242 + $proejctdata = $wppmfunction->get_project($project->id);
243 + $pstatus= esc_sql($project->status);
244 + $status = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_project_statuses where id='$pstatus'" );
245 + $users = explode(",",$project->users);
246 + $pid= esc_sql($project->id);
247 + if(isset($project->cat_id)){
248 + $pcat_id = esc_sql($project->cat_id);
249 + $category = $wpdb->get_var( "SELECT name FROM {$wpdb->prefix}wppm_project_categories where id='$pcat_id'" );
250 + }
251 + if(isset($project->id)){
252 + if($current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin'){
253 + $no_of_tasks = $wpdb->get_var("SELECT count(*) FROM {$wpdb->prefix}wppm_task WHERE project='$pid' ");
254 + }else{
255 + $query =("SELECT count(*) FROM
256 + ( SELECT Task.*
257 + FROM {$wpdb->prefix}wppm_task AS Task
258 + Left join {$wpdb->prefix}wppm_project proj ON Task.project = proj.id
259 + Left join {$wpdb->prefix}wppm_project_users proj_users ON Task.project = proj_users.proj_id
260 + Left join {$wpdb->prefix}wppm_project_meta proj_meta ON proj.id = proj_meta.project_id
261 + where Task.project = '$pid' AND ((FIND_IN_SET('$current_user->ID',Task.users)>0) OR (Task.created_by= '$current_user->ID') OR (proj_users.user_id = '$current_user->ID' AND proj_users.role_id = 1 ) 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='$current_user->ID')) Group by Task.id ) AS Task");
262 + $no_of_tasks = $wpdb->get_var($query);
263 + }
264 + $no_of_tasks = apply_filters('wppm_no_of_task_proj_list_query',$no_of_tasks,$project->id);
265 + }
266 + if($wppm_project_time == 1){
267 + $proj_start_date = $project->start_date;
268 + $proj_end_date = $project->end_date;
269 + } elseif($wppm_project_time == 0){
270 + $psDate = new DateTime($project->start_date);
271 + $peDate = new DateTime($project->end_date);
272 + $proj_start_date = $psDate->format('Y-m-d');
273 + $proj_end_date = $peDate->format('Y-m-d');
274 + }
275 + ?>
276 + <tr onclick="if(link)wppm_open_project(<?php echo esc_attr($project->id) ?>)">
277 + <td class="bulk-selector" onmouseover="link=false;" onmouseout="link=true;">
278 + <div class="wppm-pl-item-selector">
279 + <div class="checkbox-container">
280 + <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 ); ?>"/>
281 + <label for="wppm_bulk_select_<?php echo esc_attr($project->id) ?>"></label>
282 + </div>
283 + </div>
284 + </td>
285 + <td onmouseover="link=true;"><?php echo esc_html_e($project->project_name,'taskbuilder') ?></td>
286 + <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_e($status->name,'taskbuilder') ?></span></td>
287 + <td onmouseover="link=true;">
288 + <?php
289 + $i=0;
290 + if(!empty(array_filter($users))){
291 + foreach($users as $user){
292 + $i++;
293 + if( $i <= 4 ){
294 + $user_info = get_user_by('id', $user );
295 + if(!empty($user_info)){
296 + ?>
297 + <a href="#" title="<?php echo esc_html_e($user_info->display_name) ?>">
298 + <?php echo get_avatar($user_info->ID, 25, "mysteryman");?>
299 + </a> <?php
300 + }
301 + }
302 + }
303 + } else{
304 + _e('None','wp_projects');
305 + }
306 + if($i > 4){
307 + ?>
308 + <a href="#" class="wppm_avatar">
309 + <span id="wppm_avatar" style="background-color:black;" class="avatar">+<?php echo esc_html($i-4) ?></span>
310 + </a>
311 + <?php } ?>
312 + </td>
313 + <td onmouseover="link=true;" class="wppm_table_td"><?php echo isset($category) ? esc_html_e($category,'taskbuilder'): "" ?></td>
314 + <?php if($wppm_default_project_date==1){ ?>
315 + <td onmouseover="link=true;" class="wppm_table_td"><?php echo isset($proj_start_date) ? esc_html($proj_start_date): "" ?></td>
316 + <?php $style = ($project->status!=4 && $proj_end_date < $current_date) ? "color:#FF0000":"color:#2C3E50"; ?>
317 + <td onmouseover="link=true;" class="wppm_table_td"><span style="<?php echo esc_attr($style); ?>"><?php echo isset($proj_end_date) ? esc_html($proj_end_date):"" ?></td></span>
318 + <?php } ?>
319 + <td onmouseover="link=true;" class="wppm_table_td"><?php echo isset($no_of_tasks) ? esc_html($no_of_tasks):"" ?></td>
320 + <td onmouseover="link=true;" class="wppm_delete_action">
321 + <?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"; ?>
322 + <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>
323 + <?php ?>
324 + </td>
325 + </tr>
326 + <?php
327 + }
328 + }
329 + ?>
330 + </tbody>
331 + </table>
332 + <?php
333 + $total_pages=ceil($totalrows/$proj_per_page);
334 + $current_page=$page_no+1;
335 + $prev_page_no=$current_page-1;
336 + $prev_class=($prev_page_no==0)?'disabled':'';
337 + $next_page_no=($total_pages==$current_page)? $current_page-1:$current_page;
338 + $next_class=($total_pages==$current_page)?'disabled':'';
339 + ?>
340 + <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>
341 + <hr style="<?php echo esc_attr($total_pages==0)? '':'display: none;';?>">
342 + </div>
343 + <div class="row wppm_proj_pagination_container">
344 + <div class="col-sm-4">
345 + <?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')?>
346 + </div>
347 + <div class="col-sm-4">
348 + <div class="wppm_proj_pagination" style="<?php echo esc_attr($total_pages==0)? "display:none;":"display:flex;"?>">
349 + <span class="wppm-pagination-txt">
350 + <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>
351 + </span>
352 + <span
353 + <?php echo esc_html($prev_class) ?>
354 + style="<?php echo (isset($prev_class) && esc_attr($prev_class) == 'disabled') ? 'display:none;':'display:block;'?>">
355 + <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_html_e('PREV','taskbuilder');?></a>
356 + </span>
357 + <span
358 + <?php echo esc_attr($next_class) ?>
359 + style="<?php echo (isset($next_class) && $next_class == 'disabled')?'display:none;':'display:block;'?>cursor:pointer;">
360 + <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_html_e('NEXT','taskbuilder');?></a>
361 + </span>
362 + </div>
363 + </div>
364 + </div>
365 + </div>
366 + </div>
367 +</form>
368 +<style>
369 + #wppm_project_table tr:nth-child(even) td{
370 + background-color:<?php echo esc_attr($appearance_settings['list-item-even-background-color'])?>!important;
371 + color:<?php echo esc_attr($appearance_settings['list-item-even-text-color'])?>!important;
372 + }
373 + #wppm_project_table tr:nth-child(odd) td{
374 + background-color:<?php echo esc_attr($appearance_settings['list-item-odd-background-color'])?>!important;
375 + color:<?php echo esc_attr($appearance_settings['list-item-odd-text-color'])?>!important;
376 + }
377 + #wppm_project_table tr:hover td{
378 + background-color:<?php echo esc_attr($appearance_settings['list-item-hover-background-color'])?>!important;
379 + }
380 + #wppm_project_table tr:hover td{
381 + color: <?php echo esc_attr($appearance_settings['list-item-hover-text-color'])?>!important;
382 + }
383 +</style>
384 +<script type="text/javascript">
385 + jQuery( document ).ready( function( jQuery ) {
386 + jQuery("input[name='wppm_project_search_filter']").keypress(function(e) {
387 + //Enter key
388 + if (e.which == 13) {
389 + wppm_project_search_filter();
390 + }
391 + });
392 + jQuery("#wppm_proj_name_th").hover(function(){
393 + jQuery('#wppm_chevron_sort_up_project_name_img').show();
394 + jQuery('#wppm_chevron_sort_down_project_name_img').hide();
395 + });
396 + jQuery("#wppm_project_status_th").hover(function(){
397 + jQuery('#wppm_chevron_sort_up_project_status_img').show();
398 + jQuery('#wppm_chevron_sort_down_project_status_img').hide();
399 + });
400 + jQuery("#wppm_project_category_th").hover(function(){
401 + jQuery('#wppm_chevron_sort_up_project_cat_img').show();
402 + jQuery('#wppm_chevron_sort_down_project_cat_img').hide();
403 + });
404 + jQuery("#wppm_project_start_date_th").hover(function(){
405 + jQuery('#wppm_chevron_sort_up_project_start_date_img').show();
406 + jQuery('#wppm_chevron_sort_down_project_start_date_img').hide();
407 + });
408 + jQuery("#wppm_project_end_date_th").hover(function(){
409 + jQuery('#wppm_chevron_sort_up_project_end_date_img').show();
410 + jQuery('#wppm_chevron_sort_down_project_end_date_img').hide();
411 + });
412 + jQuery(".wppm_delete_action").on("click", function(e){
413 + e.preventDefault();
414 + return false;
415 + });
416 +
417 + jQuery('#wppm_project_list_frm').on('submit', function (e) {
418 + var dataform = new FormData(jQuery('#wppm_project_list_frm')[0]);
419 + jQuery.ajax({
420 + url: wppm_admin.ajax_url,
421 + type: 'POST',
422 + data: dataform,
423 + processData: false,
424 + contentType: false,
425 + success: function () {
426 + alert('form was submitted');
427 + }
428 + });
429 + });
430 + });
431 + /**
432 + * Bulk item selector change
433 + */
434 +function wppm_bulk_item_select_change() {
435 + jQuery("#wppm-bulk-actions-btn").show();
436 + var items = jQuery(".wppm-bulk-select:checked");
437 + var checked = items.length === 0 ? false : true;
438 + if(checked){
439 + jQuery(".wppm-bulk-selector").prop("checked", checked);
440 + }else{
441 + jQuery("#wppm-bulk-actions-btn").hide();
442 + jQuery(".wppm-bulk-selector").prop("checked", false);
443 + }
444 +}
445 +</script>
446 +<?php
447 +add_action('wp_footer', 'wppm_page_inline_script', 999999999999999999);
448 +do_action('wppm_after_shortcode_loaded');
449 +if(!function_exists('wppm_page_inline_script')) {
450 + function wppm_page_inline_script() { ?>
451 + <script type="text/javascript">
452 + jQuery( document ).ready( function( jQuery ) {
453 + wppm_get_project_list();
454 + });
455 + </script>
456 + <?php }
457 +}
649 458 ?>