<?php

namespace wcf\data\attachment;

use wcf\data\object\type\ObjectTypeCache;
use wcf\system\WCF;

/**
 * Represents a list of attachments.
 *
 * @author  Marcel Werk
 * @copyright   2001-2019 WoltLab GmbH
 * @license GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
 * @package WoltLabSuite\Core\Data\Attachment
 *
 * @method  AdministrativeAttachment    current()
 * @method  AdministrativeAttachment[]  getObjects()
 * @method  AdministrativeAttachment|null   search($objectID)
 * @property    AdministrativeAttachment[] $objects
 */
class AdministrativeAttachmentList extends AttachmentList
{
    /**
     * @inheritDoc
     */
    public $decoratorClassName = AdministrativeAttachment::class;

    /**
     * Creates a new AdministrativeAttachmentList object.
     */
    public function __construct()
    {
        parent::__construct();

        $this->sqlSelects = 'user_table.username';
        $this->sqlJoins = "
            LEFT JOIN   wcf" . WCF_N . "_user user_table
            ON          user_table.userID = attachment.userID";
    }

    /**
     * @inheritDoc
     */
    public function readObjects()
    {
        parent::readObjects();

        // cache objects
        $groupedObjectIDs = [];
        foreach ($this->objects as $attachment) {
            if (!isset($groupedObjectIDs[$attachment->objectTypeID])) {
                $groupedObjectIDs[$attachment->objectTypeID] = [];
            }
            $groupedObjectIDs[$attachment->objectTypeID][] = $attachment->objectID;
        }

        foreach ($groupedObjectIDs as $objectTypeID => $objectIDs) {
            $objectType = ObjectTypeCache::getInstance()->getObjectType($objectTypeID);
            $objectType->getProcessor()->cacheObjects($objectIDs);
        }
    }

    /**
     * Returns a list of available mime types.
     *
     * @return  string[]
     */
    public function getAvailableFileTypes()
    {
        $fileTypes = [];
        $sql = "SELECT  DISTINCT attachment.fileType
                FROM    wcf" . WCF_N . "_attachment attachment
                " . $this->getConditionBuilder();
        $statement = WCF::getDB()->prepareStatement($sql);
        $statement->execute($this->getConditionBuilder()->getParameters());
        while ($row = $statement->fetchArray()) {
            if ($row['fileType']) {
                $fileTypes[$row['fileType']] = $row['fileType'];
            }
        }

        \ksort($fileTypes);

        return $fileTypes;
    }

    /**
     * Returns attachment statistics.
     *
     * @return  int[]
     */
    public function getStats()
    {
        $sql = "SELECT  COUNT(*) AS count,
                        COALESCE(SUM(attachment.filesize), 0) AS size,
                        COALESCE(SUM(downloads), 0) AS downloads
                FROM    wcf" . WCF_N . "_attachment attachment
                " . $this->getConditionBuilder();
        $statement = WCF::getDB()->prepareStatement($sql);
        $statement->execute($this->getConditionBuilder()->getParameters());

        return $statement->fetchArray();
    }
}