Module for automatically disable download of downloadable product

Code: Select all

 // Check for any downloadable products
        $download_status = false;

        $order_products = $this->model_checkout_order->getProducts($order_info['order_id']);

        foreach ($order_products as $order_product) {
            // Check if there are any linked downloads
            $product_download_query = $this->db->query("SELECT COUNT(*) AS `total` FROM `" . DB_PREFIX . "product_to_download` WHERE `product_id` = '" . (int)$order_product['product_id'] . "'");

            if ($product_download_query->row['total']) {
                $download_status = true;
            }
        }

Code: Select all

// Check for any downloadable products
        $download_status = false;

        $order_products = $this->model_checkout_order->getProducts($order_info['order_id']);

        // Subscription
        $this->load->model('checkout/subscription');

        // Products
        $this->load->model('catalog/product');

        // Downloads
        $this->load->model('account/download');

        foreach ($order_products as $order_product) {
            // Check if there are any linked downloads
            $product_download_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "product_to_download` WHERE `product_id` = '" . (int)$order_product['product_id'] . "'");

            if ($product_download_query->num_rows) {
                $subscription_info = $this->model_checkout_subscription->getSubscriptionByOrderProductId($order_product['order_product_id']);

                if ($subscription_info) {
                    $product_subscription_info = $this->model_catalog_product->getSubscription($order_product['product_id'], $subscription_info['subscription_plan_id']);

                    if ($product_subscription_info) {
                        // We need to validate frequencies in compliance of the admin subscription plans
                        // as with the use of the APIs
                        if ($subscription_info['frequency'] == 'semi_month') {
                            $period = strtotime("2 weeks");
                        } else {
                            $period = strtotime($subscription_info['cycle'] . ' ' . $subscription_info['frequency']);
                        }

                        // Subscription date
                        $subscription_period = strtotime($subscription_info['date_added']);

                        // Calculates the remaining days between the subscription
                        // promotional period and the date added period
                        $period = ($period - $subscription_period);

                        // Calculate remaining period of each features
                        $cycle = round($period / (60 * 60 * 24));

                        if ($subscription_info['status'] && $subscription_info['status'] && !$subscription_info['trial_status'] && $cycle >= 0) {
                            $account_download_info = $this->model_account_download->getDownload($product_download_query->row['download_id']);

                            if ($account_download_info) {
                                // Download date
                                $download_period = strtotime($product_download_query->row['date_added']);

                                // Calculates the remaining period between the subscription
                                // and the download date added period
                                $period = ($period - $download_period);

                                // Calculate remaining period of each downloads
                                $download_cycle = round($period / (60 * 60 * 24));

                                if ($download_cycle >= $cycle) {
                                    $download_status = true;
                                }
                            }
                        }
                    }
                } else {
                    $download_status = true;
                }
            }
        }