<?php
/**
 * The `Folder` class is responsible for managing folders.
 * 
 * @link       https://drive.azpage.net
 * @since      1.0.0
 * @package    azdrive
 * @subpackage azdrive/includes
 * @author     AzPage
 */

namespace AzDrive\Admin;

if ( !defined( 'ABSPATH' ) ) exit;

use AzDrive\Model\PostModel;

class Folder {
    public function __construct() {
        add_filter( 'posts_clauses', array( $this, 'postsClauses' ), 10, 2 );
    }

    /**
     * Filter the media library query to include custom folders
     *
     * @param array $clauses The SQL clauses.
     * @param WP_Query $query The WP_Query object.
     * @return array The modified SQL clauses.
     */
    public function postsClauses($clauses, $query) {
        global $wpdb, $azdrive, $pagenow;

        if ( ! current_user_can( 'read' ) || !is_admin() || !$query->is_main_query()) {
            return $clauses;
        }
        $post_type = $query->get( 'post_type' );
        $isSupported = apply_filters('azdrive_post_type_support', false, $post_type);
        if ( $post_type != 'attachment' && !$isSupported ) {
            return $clauses;
        }
        
        // phpcs:ignore WordPress.Security.NonceVerification.Recommended
        $folder_id = isset($_REQUEST['folder_id']) ? intval($_REQUEST['folder_id']) : null;
        if ( $folder_id != null ) {
            // get all posts
            if( $folder_id == 0 ) return $clauses;

            // get all post with Uncategorized
            if( $folder_id == -1 ){
                $postIds = PostModel::getPostsIdByFolderId();
                if($postIds && count($postIds) > 0){
                    $clauses['where'] .= ' AND '.$wpdb->posts.'.ID NOT IN ('.implode(',', $postIds).')';
                }
                return $clauses;
            }

            // get all attachments ids in folder
            $postIds = PostModel::getPostsIdByFolderId($folder_id);
            if( $postIds && count($postIds) > 0){
                $clauses['where'] .= ' AND '.$wpdb->posts.'.ID IN ('.implode(',', $postIds).')';
            }else{
                $clauses['where'] .= ' AND '.$wpdb->posts.'.ID IN (0)';
            }
        }
        return $clauses;
    }
}