UserFile.php

Go to the documentation of this file.

<?php

namespace Combu;

use Combu\Utils;

class UserFile extends DataClass {

    const TABLE_NAME = "UserFile";

    public $Id = 0;
    public $IdAccount = 0;
    public $Name = "";
    public $Url = "";
    public $ShareType = SHARETYPE_EVERYBODY;
    public $Likes = 0;
    public $Views = 0;
    public $CustomData = "";

    public function __construct($src = null, $stripSlashes = false) {
        if (empty($src)) {
            return;
        }
        if (is_array($src)) {
            // Load by array
            $this->_loadByRow($src, $stripSlashes);
        } else if (is_numeric($src) && intval($src) > 0) {
            // Load by Id
            $this->_loadFilter(self::GetTableName(__CLASS__), "Id = " . intval($src));
        }
    }

    public static function Load ($idAccount, $includeShared = false, $returnArray = false, $limit = NULL, $offset = NULL, &$count = NULL) {
        // Load the files from account's storage, files shared by others and files shared by friends
        $where = "IdAccount = " . $idAccount;
        if ($includeShared) {
            $where .= " OR ShareType = " . SHARETYPE_EVERYBODY .
                " OR (ShareType = " . SHARETYPE_FRIENDS . " AND IdAccount IN (SELECT IdAccount FROM " . self::GetTableName(Friend::class) . " WHERE IdFriend = " . $idAccount . " AND State = " . FRIEND_STATE_ACCEPTED . "))";
        }
        return self::_load(self::GetTableName(__CLASS__), ($returnArray ? "" : __CLASS__), $where, "Id", $limit, $offset, $count);
    }
    
    public static function LoadByUrl($url) {
        global $Database;
        $where = sprintf("Url = '%s'", $Database->Escape($url));
        $records = self::_load(self::GetTableName(__CLASS__), __CLASS__, $where, NULL, 1);
        return (count($records) > 0 ? $records[0] : NULL);
    }

    public function Save() {
        global $Database;
        if ($this->Id > 0) {
            $query = sprintf("UPDATE %s SET Name = '%s', Url = '%s', ShareType = %d, CustomData = '%s' WHERE Id = %d",
                    self::GetTableName(__CLASS__),
                    $Database->Escape($this->Name),
                    $Database->Escape($this->Url),
                    $this->ShareType,
                    $Database->Escape($this->CustomData),
                    $this->Id);
        } else {
            $query = sprintf("INSERT INTO %s (IdAccount, Name, Url, ShareType, Likes, Views, CustomData) VALUES (%d, '%s', '%s', %d, 0, 0, '%s')",
                    self::GetTableName(__CLASS__),
                    $this->IdAccount,
                    $Database->Escape($this->Name),
                    $Database->Escape($this->Url),
                    $this->ShareType,
                    $Database->Escape($this->CustomData));
        }
        if ($Database->Query($query)) {
            if ($this->Id < 1) {
                $this->Id = $Database->InsertedId();
            }
            return TRUE;
        }
        return FALSE;
    }

    public function Delete() {
        if ($this->Id > 0) {
            if ($this->_Delete(self::GetTableName(__CLASS__), "Id = " . $this->Id)) {
                // Delete file activities
                $this->_Delete(self::GetTableName(UserFileActivity::class), "IdFile = " . $this->Id);
                // Try to delete the file uploaded
                $filepath = UPLOAD_FOLDER . $this->Url;
                if (file_exists($filepath)) {
                    try {
                        unlink($filepath);
                    } catch (Exception $ex) {
                        AppLog::Error("Could not delete UserFile uploaded: " . $ex->getMessage() . " (file: " . $filepath . ")");
                    }
                }
                return TRUE;
            }
        }
        return FALSE;
    }
    
    public static function Prune() {
        // Load all files and call Delete() to clean the upload folder
        $files = self::_load(self::GetTableName(__CLASS__), __CLASS__);
        foreach ($files as $f) {
            $f->Delete();
        }
    }
    
    public function AddLike () {
        global $LoggedAccount, $Database;
        if ($this->Id > 0) {
            // Try to save the new count
            $this->Likes++;
            $query = sprintf("UPDATE %s SET Likes = %d WHERE Id = %d",
                    self::GetTableName(__CLASS__),
                    $this->Likes,
                    $this->Id);
            if ($Database->Query($query)) {
                // Add an activity log of the logged user
                if ($LoggedAccount->IsLogged()) {
                    $activity = new UserFileActivity();
                    $activity->IdFile = $this->Id;
                    $activity->IdAccount = $LoggedAccount->Id;
                    $activity->Likes = 1;
                    $activity->Save();
                }
                return TRUE;
            }
            // If the SQL statement failed then bring back the old count
            $this->Likes--;
        }
        return FALSE;
    }
    
    public function AddView () {
        global $LoggedAccount, $Database;
        if ($this->Id > 0) {
            // Try to save the new count
            $this->Views++;
            $query = sprintf("UPDATE %s SET Views = %d WHERE Id = %d",
                    self::GetTableName(__CLASS__),
                    $this->Views,
                    $this->Id);
            if ($Database->Query($query)) {
                // Add an activity log of the logged user
                if ($LoggedAccount->IsLogged()) {
                    $activities = UserFileActivity::Load($this->Id, $LoggedAccount->Id);
                    if (count($activities) == 0) {
                        $activity = new UserFileActivity();
                        $activity->IdFile = $this->Id;
                        $activity->IdAccount = $LoggedAccount->Id;
                    } else {
                        $activity = $activities[0];
                    }
                    $activity->Views++;
                    $activity->Save();
                }
                return TRUE;
            }
            // If the SQL statement failed then bring back the old count
            $this->Views--;
        }
        return FALSE;
    }
    
    public function ToArray() {
        $array = parent::ToArray();
        
        $array["FullUrl"] = Utils::GetUploadUrl($this->Url);
        
        $loggedFileData = UserFileActivity::Load($userFiles[$i]->Id, $LoggedAccount->Id);
        $array["UserLikes"] = (count($loggedFileData) == 0 ? 0 : $loggedFileData[0]->Likes);
        $array["UserViews"] = (count($loggedFileData) == 0 ? 0 : $loggedFileData[0]->Views);
        $array["UserLastActivity"] = (count($loggedFileData) == 0 ? 0 : $loggedFileData[0]->LastActivity);
        
        return $array;
    }
    
    public function ToArrayClient() {
        $array = $this->ToArray();
        $array["Url"] = $array["FullUrl"];
        return $array;
    }
    
    public function ToJsonClient() {
        return json_encode($this->ToArrayClient());
    }
}