← All changes | includes/admin/projects/wppm_set_delete_bulk_projects.php +109 -109 6.0.3 → 6.0.6 View file →

		@@ -1,110 +1,110 @@
1		-<?php
2		-if ( ! defined( 'ABSPATH' ) ) {
3		- exit; // Exit if accessed directly
4		-}
5		-global $wpdb,$wppmfunction,$current_user;
6		-if ( check_ajax_referer( 'wppm_set_delete_bulk_projects', '_ajax_nonce', false ) != 1 ) {
7		- wp_send_json_error( 'Unauthorised request!', 401 );
8		-}
9		-$wppm_current_user_capability = get_user_meta( $current_user->ID, 'wppm_capability', true );
10		-$proj_ids = isset( $_POST['proj_ids'] ) ? array_filter( array_map( 'intval', explode( ',', sanitize_text_field( wp_unslash( $_POST['proj_ids'] ) ) ) ) ) : array();
11		-if ( ! $proj_ids ) {
12		- wp_send_json_error( 'Missing project ids', 400 );
13		-}
14		-if(!empty($proj_ids)){
15		- foreach($proj_ids as $proj_id){
16		- $project_data = $wppmfunction->get_project($proj_id);
17		- if ((($current_user->ID && $current_user->has_cap('manage_options')) || $wppmfunction->has_project_permission('delete_project',$proj_id) || ($project_data['created_by']==$current_user->ID && $wppm_current_user_capability == 'wppm_manager') || ($current_user->ID && $current_user->has_cap('wppm_admin')))) {
18		- $tasks = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_task where project = %d",absint($proj_id)));
19		- /*************delete project********/
20		- $wpdb->delete($wpdb->prefix.'wppm_project',array('id'=>$proj_id));
21		- /*************delete project comment********/
22		- $proj_comm_attachment_ids = $wpdb->get_results(
23		- $wpdb->prepare(
24		- "SELECT attachment_ids
25		- FROM {$wpdb->prefix}wppm_project_comment
26		- WHERE proj_id = %d",
27		- absint($proj_id)
28		- )
29		- );
30		- if(!empty($proj_comm_attachment_ids)){
31		- foreach ($proj_comm_attachment_ids as $proj_attachment_id){
32		- $proj_attachment_ids_temp=array();
33		- if($proj_attachment_id->attachment_ids){
34		- $proj_attachment_ids_temp= explode(',', $proj_attachment_id->attachment_ids);
35		- }
36		- foreach ($proj_attachment_ids_temp as $proj_attachment_id){
37		- $sql=$wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_attachments WHERE id = %d",absint($proj_attachment_id));
38		- $att_result=$wpdb->get_row($sql);
39		- if(!empty($att_result)){
40		- $sql_query=$wpdb->prepare("SELECT file_path FROM {$wpdb->prefix}wppm_attachments WHERE file_path = %s",absint($att_result->file_path));
41		- $proj_attach_result=$wpdb->get_results($sql_query);
42		- $proj_result_count = count($proj_attach_result);
43		- if(file_exists($att_result->file_path) && $proj_result_count < 2)
44		- {
45		- wp_delete_file($att_result->file_path);
46		- }
47		- $proj_attachment_id = absint($proj_attachment_id);
48		- $wpdb->delete($wpdb->prefix.'wppm_attachments', array( 'id' => "$proj_attachment_id"));
49		- }
50		- }
51		- }
52		- }
53		- $wpdb->delete($wpdb->prefix.'wppm_project_comment',array('proj_id'=>absint($proj_id)));
54		- $wpdb->delete($wpdb->prefix.'wppm_project_meta',array('project_id'=>absint($proj_id)));
55		- $wpdb->delete($wpdb->prefix.'wppm_project_comment_meta',array('proj_id'=>absint($proj_id)));
56		-
57		- /*************delete project's tasks and comments********/
58		- foreach($tasks as $task){
59		- $sql=$wpdb->prepare("SELECT attachment_ids FROM {$wpdb->prefix}wppm_task_comment WHERE task_id = %d",absint($task->id));
60		- $thread_attachment_ids= $wpdb->get_results( $sql );
61		-
62		- /***************************Code for deleting attachment files****************************************************/
63		- if(!empty($thread_attachment_ids)){
64		- foreach ($thread_attachment_ids as $thread_attachment_id){
65		- $attachment_ids_temp=array();
66		- if($thread_attachment_id->attachment_ids){
67		- $attachment_ids_temp= explode(',', $thread_attachment_id->attachment_ids);
68		- }
69		- //$attachment_ids=$attachment_ids_temp;
70		- foreach ($attachment_ids_temp as $attachment_id){
71		- $sql=$wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_attachments WHERE id = %d",absint($attachment_id));
72		- $result=$wpdb->get_row($sql);
73		- if(!empty($result)){
74		- $sql_query=$wpdb->prepare("SELECT file_path FROM {$wpdb->prefix}wppm_attachments WHERE file_path = %s",absint($result->file_path));
75		- $attach_result=$wpdb->get_results($sql_query);
76		- $result_count = count($attach_result);
77		- if(file_exists($result->file_path) && $result_count < 2)
78		- {
79		- wp_delete_file($result->file_path);
80		- }
81		- $wpdb->delete($wpdb->prefix.'wppm_attachments', array( 'id' => absint($attachment_id)));
82		- }
83		- }
84		- }
85		- }
86		- /***************************Code for deleting checklists****************************************************/
87		- $sql=$wpdb->prepare("SELECT id FROM {$wpdb->prefix}wppm_checklist WHERE task_id = %d",absint($task->id));
88		- $checklists = $wpdb->get_results( $sql );
89		- if(!empty($checklists)){
90		- foreach($checklists as $checklist){
91		- $chk_array = (array) $checklist;
92		- $sql=$wpdb->prepare("SELECT id FROM {$wpdb->prefix}wppm_checklist_items WHERE checklist_id = %d",absint($chk_array['id']));
93		- $checklist_items = $wpdb->get_results( $sql );
94		- if(!empty($checklist_items)){
95		- foreach($checklist_items as $ch_item){
96		- $chk_items_array = (array) $ch_item;
97		- $wpdb->delete($wpdb->prefix.'wppm_checklist_items',array('id'=>absint($chk_items_array['id'])));
98		- }
99		- }
100		- $wpdb->delete($wpdb->prefix.'wppm_checklist',array('id'=>absint($chk_array['id'])));
101		- }
102		- }
103		- $wpdb->delete($wpdb->prefix.'wppm_task',array('project'=>absint($proj_id)));
104		- $wpdb->delete($wpdb->prefix.'wppm_task_meta',array('task_id'=>absint($task->id)));
105		- $wpdb->delete($wpdb->prefix.'wppm_task_comment',array('task_id'=>absint($task->id)));
106		- $wpdb->delete($wpdb->prefix.'wppm_task_comment_meta',array('task_id'=>absint($task->id)));
107		- }
108		- }
109		- }
	1	+<?php
	2	+if ( ! defined( 'ABSPATH' ) ) {
	3	+ exit; // Exit if accessed directly
	4	+}
	5	+global $wpdb,$wppmfunction,$current_user;
	6	+if ( check_ajax_referer( 'wppm_set_delete_bulk_projects', '_ajax_nonce', false ) != 1 ) {
	7	+ wp_send_json_error( 'Unauthorised request!', 401 );
	8	+}
	9	+$wppm_current_user_capability = get_user_meta( $current_user->ID, 'wppm_capability', true );
	10	+$proj_ids = isset( $_POST['proj_ids'] ) ? array_filter( array_map( 'intval', explode( ',', sanitize_text_field( wp_unslash( $_POST['proj_ids'] ) ) ) ) ) : array();
	11	+if ( ! $proj_ids ) {
	12	+ wp_send_json_error( 'Missing project ids', 400 );
	13	+}
	14	+if(!empty($proj_ids)){
	15	+ foreach($proj_ids as $proj_id){
	16	+ $project_data = $wppmfunction->get_project($proj_id);
	17	+ if ((($current_user->ID && $current_user->has_cap('manage_options')) || $wppmfunction->has_project_permission('delete_project',$proj_id) || ($project_data['created_by']==$current_user->ID && $wppm_current_user_capability == 'wppm_manager') || ($current_user->ID && $current_user->has_cap('wppm_admin')))) {
	18	+ $tasks = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_task where project = %d",absint($proj_id)));
	19	+ /*************delete project********/
	20	+ $wpdb->delete($wpdb->prefix.'wppm_project',array('id'=>$proj_id));
	21	+ /*************delete project comment********/
	22	+ $proj_comm_attachment_ids = $wpdb->get_results(
	23	+ $wpdb->prepare(
	24	+ "SELECT attachment_ids
	25	+ FROM {$wpdb->prefix}wppm_project_comment
	26	+ WHERE proj_id = %d",
	27	+ absint($proj_id)
	28	+ )
	29	+ );
	30	+ if(!empty($proj_comm_attachment_ids)){
	31	+ foreach ($proj_comm_attachment_ids as $proj_attachment_id){
	32	+ $proj_attachment_ids_temp=array();
	33	+ if($proj_attachment_id->attachment_ids){
	34	+ $proj_attachment_ids_temp= explode(',', $proj_attachment_id->attachment_ids);
	35	+ }
	36	+ foreach ($proj_attachment_ids_temp as $proj_attachment_id){
	37	+ $sql=$wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_attachments WHERE id = %d",absint($proj_attachment_id));
	38	+ $att_result=$wpdb->get_row($sql);
	39	+ if(!empty($att_result)){
	40	+ $sql_query=$wpdb->prepare("SELECT file_path FROM {$wpdb->prefix}wppm_attachments WHERE file_path = %s",absint($att_result->file_path));
	41	+ $proj_attach_result=$wpdb->get_results($sql_query);
	42	+ $proj_result_count = count($proj_attach_result);
	43	+ if(file_exists($att_result->file_path) && $proj_result_count < 2)
	44	+ {
	45	+ wp_delete_file($att_result->file_path);
	46	+ }
	47	+ $proj_attachment_id = absint($proj_attachment_id);
	48	+ $wpdb->delete($wpdb->prefix.'wppm_attachments', array( 'id' => "$proj_attachment_id"));
	49	+ }
	50	+ }
	51	+ }
	52	+ }
	53	+ $wpdb->delete($wpdb->prefix.'wppm_project_comment',array('proj_id'=>absint($proj_id)));
	54	+ $wpdb->delete($wpdb->prefix.'wppm_project_meta',array('project_id'=>absint($proj_id)));
	55	+ $wpdb->delete($wpdb->prefix.'wppm_project_comment_meta',array('proj_id'=>absint($proj_id)));
	56	+
	57	+ /*************delete project's tasks and comments********/
	58	+ foreach($tasks as $task){
	59	+ $sql=$wpdb->prepare("SELECT attachment_ids FROM {$wpdb->prefix}wppm_task_comment WHERE task_id = %d",absint($task->id));
	60	+ $thread_attachment_ids= $wpdb->get_results( $sql );
	61	+
	62	+ /***************************Code for deleting attachment files****************************************************/
	63	+ if(!empty($thread_attachment_ids)){
	64	+ foreach ($thread_attachment_ids as $thread_attachment_id){
	65	+ $attachment_ids_temp=array();
	66	+ if($thread_attachment_id->attachment_ids){
	67	+ $attachment_ids_temp= explode(',', $thread_attachment_id->attachment_ids);
	68	+ }
	69	+ //$attachment_ids=$attachment_ids_temp;
	70	+ foreach ($attachment_ids_temp as $attachment_id){
	71	+ $sql=$wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_attachments WHERE id = %d",absint($attachment_id));
	72	+ $result=$wpdb->get_row($sql);
	73	+ if(!empty($result)){
	74	+ $sql_query=$wpdb->prepare("SELECT file_path FROM {$wpdb->prefix}wppm_attachments WHERE file_path = %s",absint($result->file_path));
	75	+ $attach_result=$wpdb->get_results($sql_query);
	76	+ $result_count = count($attach_result);
	77	+ if(file_exists($result->file_path) && $result_count < 2)
	78	+ {
	79	+ wp_delete_file($result->file_path);
	80	+ }
	81	+ $wpdb->delete($wpdb->prefix.'wppm_attachments', array( 'id' => absint($attachment_id)));
	82	+ }
	83	+ }
	84	+ }
	85	+ }
	86	+ /***************************Code for deleting checklists****************************************************/
	87	+ $sql=$wpdb->prepare("SELECT id FROM {$wpdb->prefix}wppm_checklist WHERE task_id = %d",absint($task->id));
	88	+ $checklists = $wpdb->get_results( $sql );
	89	+ if(!empty($checklists)){
	90	+ foreach($checklists as $checklist){
	91	+ $chk_array = (array) $checklist;
	92	+ $sql=$wpdb->prepare("SELECT id FROM {$wpdb->prefix}wppm_checklist_items WHERE checklist_id = %d",absint($chk_array['id']));
	93	+ $checklist_items = $wpdb->get_results( $sql );
	94	+ if(!empty($checklist_items)){
	95	+ foreach($checklist_items as $ch_item){
	96	+ $chk_items_array = (array) $ch_item;
	97	+ $wpdb->delete($wpdb->prefix.'wppm_checklist_items',array('id'=>absint($chk_items_array['id'])));
	98	+ }
	99	+ }
	100	+ $wpdb->delete($wpdb->prefix.'wppm_checklist',array('id'=>absint($chk_array['id'])));
	101	+ }
	102	+ }
	103	+ $wpdb->delete($wpdb->prefix.'wppm_task',array('project'=>absint($proj_id)));
	104	+ $wpdb->delete($wpdb->prefix.'wppm_task_meta',array('task_id'=>absint($task->id)));
	105	+ $wpdb->delete($wpdb->prefix.'wppm_task_comment',array('task_id'=>absint($task->id)));
	106	+ $wpdb->delete($wpdb->prefix.'wppm_task_comment_meta',array('task_id'=>absint($task->id)));
	107	+ }
	108	+ }
	109	+ }
110	110	}