<?php
if ( ! defined( 'ABSPATH' ) ) {
  exit; // Exit if accessed directly
}
global $wpdb,$wppmfunction,$current_user;
if ( check_ajax_referer( 'wppm_set_delete_bulk_projects', '_ajax_nonce', false ) != 1 ) {
    wp_send_json_error( 'Unauthorised request!', 401 );
}
$wppm_current_user_capability = get_user_meta( $current_user->ID, 'wppm_capability', true );
$proj_ids = isset( $_POST['proj_ids'] ) ? array_filter( array_map( 'intval', explode( ',', sanitize_text_field( wp_unslash( $_POST['proj_ids'] ) ) ) ) ) : array();
if ( ! $proj_ids ) {
    wp_send_json_error( 'Missing project ids', 400 );
}
if(!empty($proj_ids)){
    foreach($proj_ids as $proj_id){
        $project_data = $wppmfunction->get_project($proj_id);
        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')))) {
                $tasks = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_task where project = %d",absint($proj_id)));
            /*************delete project********/
                $wpdb->delete($wpdb->prefix.'wppm_project',array('id'=>$proj_id));
            /*************delete project comment********/
            $proj_comm_attachment_ids = $wpdb->get_results(
                $wpdb->prepare(
                    "SELECT attachment_ids
                    FROM {$wpdb->prefix}wppm_project_comment
                    WHERE proj_id = %d",
                    absint($proj_id)
                )
            );
            if(!empty($proj_comm_attachment_ids)){
                foreach ($proj_comm_attachment_ids as $proj_attachment_id){
                    $proj_attachment_ids_temp=array();
                    if($proj_attachment_id->attachment_ids){
                        $proj_attachment_ids_temp=  explode(',', $proj_attachment_id->attachment_ids);
                    }
                    foreach ($proj_attachment_ids_temp as $proj_attachment_id){
                        $sql=$wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_attachments WHERE id = %d",absint($proj_attachment_id));
                        $att_result=$wpdb->get_row($sql);
                        if(!empty($att_result)){
                            $sql_query=$wpdb->prepare("SELECT file_path FROM {$wpdb->prefix}wppm_attachments WHERE file_path = %s",absint($att_result->file_path));
                            $proj_attach_result=$wpdb->get_results($sql_query);
                            $proj_result_count = count($proj_attach_result);
                            if(file_exists($att_result->file_path) && $proj_result_count < 2)
                            {
                                wp_delete_file($att_result->file_path);
                            }
                            $proj_attachment_id = absint($proj_attachment_id);
                            $wpdb->delete($wpdb->prefix.'wppm_attachments', array( 'id' => "$proj_attachment_id"));
                        }
                    }
                }
            }
            $wpdb->delete($wpdb->prefix.'wppm_project_comment',array('proj_id'=>absint($proj_id)));
            $wpdb->delete($wpdb->prefix.'wppm_project_meta',array('project_id'=>absint($proj_id)));
            $wpdb->delete($wpdb->prefix.'wppm_project_comment_meta',array('proj_id'=>absint($proj_id)));

            /*************delete project's tasks and comments********/
            foreach($tasks as $task){
                $sql=$wpdb->prepare("SELECT attachment_ids FROM {$wpdb->prefix}wppm_task_comment WHERE task_id = %d",absint($task->id));
                $thread_attachment_ids= $wpdb->get_results( $sql );

                /***************************Code for deleting attachment files****************************************************/
                if(!empty($thread_attachment_ids)){
                    foreach ($thread_attachment_ids as $thread_attachment_id){
                        $attachment_ids_temp=array();
                        if($thread_attachment_id->attachment_ids){
                            $attachment_ids_temp=  explode(',', $thread_attachment_id->attachment_ids);
                        }
                        //$attachment_ids=$attachment_ids_temp;
                        foreach ($attachment_ids_temp as $attachment_id){
                            $sql=$wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_attachments WHERE id = %d",absint($attachment_id));
                            $result=$wpdb->get_row($sql);
                            if(!empty($result)){
                                $sql_query=$wpdb->prepare("SELECT file_path FROM {$wpdb->prefix}wppm_attachments WHERE file_path = %s",absint($result->file_path));
                                $attach_result=$wpdb->get_results($sql_query);
                                $result_count = count($attach_result);
                                if(file_exists($result->file_path) && $result_count < 2)
                                {
                                    wp_delete_file($result->file_path);
                                }
                                $wpdb->delete($wpdb->prefix.'wppm_attachments', array( 'id' => absint($attachment_id)));
                            }
                        }
                    }
                }
                /***************************Code for deleting checklists****************************************************/
                $sql=$wpdb->prepare("SELECT id FROM {$wpdb->prefix}wppm_checklist WHERE task_id = %d",absint($task->id));
                $checklists = $wpdb->get_results( $sql );
                if(!empty($checklists)){
                    foreach($checklists as $checklist){
                        $chk_array = (array) $checklist;
                        $sql=$wpdb->prepare("SELECT id FROM {$wpdb->prefix}wppm_checklist_items WHERE checklist_id = %d",absint($chk_array['id']));
                        $checklist_items = $wpdb->get_results( $sql );
                        if(!empty($checklist_items)){
                            foreach($checklist_items as $ch_item){
                                $chk_items_array = (array) $ch_item;
                                $wpdb->delete($wpdb->prefix.'wppm_checklist_items',array('id'=>absint($chk_items_array['id'])));
                            }
                        }
                        $wpdb->delete($wpdb->prefix.'wppm_checklist',array('id'=>absint($chk_array['id'])));
                    }
                }
                $wpdb->delete($wpdb->prefix.'wppm_task',array('project'=>absint($proj_id)));
                $wpdb->delete($wpdb->prefix.'wppm_task_meta',array('task_id'=>absint($task->id)));
                $wpdb->delete($wpdb->prefix.'wppm_task_comment',array('task_id'=>absint($task->id)));
                $wpdb->delete($wpdb->prefix.'wppm_task_comment_meta',array('task_id'=>absint($task->id)));
            }
        }
    }
}