ID); $wppm_rich_text_editor = get_option('wppm_rich_text_editor'); $wppm_toolbar_actions = get_option('wppm_toolbar_actions'); $priorities = $wpdb->get_results( $wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_task_priorities ORDER BY %s",$orderby_prio_sql) ); $wppm_current_user_capability = get_user_meta( $current_user->ID, 'wppm_capability', true ); $wppm_create_tasks_coworkers_permission = get_option('wppm_allow_coworkers_create_task'); if($current_user->has_cap('manage_options') || $wppm_current_user_capability=='wppm_admin'){ $orderby_proj_sql = (sanitize_sql_orderby( "project_name" )); $query = ("SELECT * FROM {$wpdb->prefix}wppm_project ORDER BY $orderby_proj_sql"); $where = ""; }else{ $orderby_proj_sql = (sanitize_sql_orderby( "project_name" )); $query = ("SELECT Proj.* FROM {$wpdb->prefix}wppm_project AS Proj Left join {$wpdb->prefix}wppm_project_meta proj_meta ON Proj.id = proj_meta.project_id Left join {$wpdb->prefix}wppm_project_users proj_users ON Proj.id = proj_users.proj_id "); if($wppm_create_tasks_coworkers_permission!=1){ $where = " where ((FIND_IN_SET('$current_user->ID',Proj.users) 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 (Proj.created_by='$cu_id')) Group by Proj.id ORDER BY '$orderby_proj_sql'"; }else{ $where = " where ((FIND_IN_SET('$current_user->ID',Proj.users)) OR (Proj.id = proj_meta.project_id AND proj_meta.meta_key='public_project' AND proj_meta.meta_value=1) OR (Proj.created_by='$cu_id')) Group by Proj.id ORDER BY '$orderby_proj_sql'"; } } $query = apply_filters("wppm_projects_list_in_create_task_query",$query); $where = apply_filters("wppm_projects_list_in_create_task_query_where",$where); $query.= $where; $projects = $wpdb->get_results($query); $start_date=""; $end_date=""; $wppm_task_list_view = get_option('wppm_default_task_list_view'); $wppm_default_task_date = get_option('wppm_default_task_date'); $wppm_task_fillter = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}wppm_task"); $flag = false; if(!empty($wppm_task_fillter)){ foreach($wppm_task_fillter as $key_filter=>$val_filter){ $val_array = (array) $val_filter; $tusers = $val_array['users']; $tusers_arr = explode(',',$tusers); $tproject_id = $val_array['project']; if(!empty($tusers) && in_array($current_user->ID,$tusers_arr)){ $project_user_role = $wpdb->get_var( $wpdb->prepare( "SELECT role_id FROM {$wpdb->prefix}wppm_project_users WHERE proj_id = %d AND user_id = %d",$tproject_id,$cu_id)); $tproject_id = absint( $tproject_id ); $project_users = $wpdb->get_var( $wpdb->prepare( "SELECT users FROM {$wpdb->prefix}wppm_project WHERE id = %d",$tproject_id)); $project_users_arr = explode(',',(string)$project_users); if((!empty($project_user_role)) && ($project_user_role == 1) && in_array($current_user->ID,$project_users_arr)){ $flag= true; break; } } } } $cu_id = absint( $cu_id ); $project_creator = $wpdb->get_var( $wpdb->prepare( "SELECT created_by FROM {$wpdb->prefix}wppm_project WHERE created_by = %d",$cu_id )); ?>

has_cap('manage_options') || $wppmfunction->has_permission('add_new_task',0) || ($flag==true) || ($project_creator!="")){ $style = "display:inline;"; }else{ $style = "display:none;"; } $style = apply_filters('wppm_add_new_task_btn_style',$style); ?> > plus-icon