root_folder.inc

<?php
require_once SQ_CORE_PACKAGE_PATH.'/folder/folder.inc';

class Root_Folder extends Folder
{


    function Root_Folder($assetid=0)
    {
        $this->Folder($assetid);

    }//end constructor


    function create(&$link)
    {
        require_once SQ_CORE_PACKAGE_PATH.'/system/system_asset_fns.inc';
        $this->_tmp[__CLASS__.'_in_create'] = TRUE;

        if (!system_asset_fns_create_pre_check($this)) {
            return FALSE;
        }

        $ret_val = parent::create($link);
        if ($ret_val) {
            if ($this->id != 1) {
                throw new Exception('Unable to create root folder, as it did not receive asset ID #1. Fragments of another system may exist in the database; please ensure the database is clear of previous installations before installing.');
                trigger_localised_error('CORE0077', E_USER_ERROR);
                return FALSE;
            }

            $db = DAL::getDb();

            $linkid = MatrixDAL::executeOne('core', 'seqNextVal', Array('seqName' => 'sq_ast_lnk_seq'));

            if ($linkid != 1) {
                $GLOBALS['SQ_SYSTEM']->doTransaction('ROLLBACK');
                $GLOBALS['SQ_SYSTEM']->restoreDatabaseConnection();
                throw new Exception('Unable to create root folder, as it did not receive link ID #1. Fragments of another system may exist in the database; please ensure the database is clear of previous installations before installing.');
                trigger_localised_error('CORE0078', E_USER_ERROR);
                return FALSE;
            }

            require_once SQ_FUDGE_PATH.'/db_extras/db_extras.inc';

            $GLOBALS['SQ_SYSTEM']->changeDatabaseConnection('db3');
            $db = DAL::getDb();
            $GLOBALS['SQ_SYSTEM']->doTransaction('BEGIN');

            // right, we need to do some manipulation for the link table to put in some initial values
            // so that the root folder, like everything else, has a link where it is a minor party
            $sql = 'INSERT INTO
                        sq_ast_lnk
                        (
                            linkid,
                            majorid,
                            minorid,
                            link_type,
                            value,
                            sort_order,
                            is_dependant,
                            is_exclusive,
                            updated,
                            updated_userid
                        )
                        VALUES
                        (
                            :linkid,
                            :majorid,
                            :minorid,
                            :link_type,
                            :value,
                            :sort_order,
                            :is_dependant,
                            :is_exclusive,
                            :updated,
                            :updated_userid
                        )';


            try {
                $query = MatrixDAL::preparePdoQuery($sql);
                MatrixDAL::bindValueToPdo($query, 'linkid',                1,  PDO::PARAM_INT);
                MatrixDAL::bindValueToPdo($query, 'majorid',               0,  PDO::PARAM_INT);
                MatrixDAL::bindValueToPdo($query, 'minorid',               1,  PDO::PARAM_INT);
                MatrixDAL::bindValueToPdo($query, 'link_type',             SQ_LINK_TYPE_1, PDO::PARAM_INT);
                MatrixDAL::bindValueToPdo($query, 'value',                 '', PDO::PARAM_STR);
                MatrixDAL::bindValueToPdo($query, 'sort_order',            0,  PDO::PARAM_INT);
                MatrixDAL::bindValueToPdo($query, 'is_dependant',          1,  PDO::PARAM_INT);
                MatrixDAL::bindValueToPdo($query, 'is_exclusive',          1,  PDO::PARAM_INT);
                MatrixDAL::bindValueToPdo($query, 'updated',               ts_iso8601(time()), PDO::PARAM_STR);
                MatrixDAL::bindValueToPdo($query, 'updated_userid',        0,  PDO::PARAM_STR);
                // TODO: turn this into a PDO query
                MatrixDAL::execPdoQuery($query);
            } catch (Exception $e) {
                throw new Exception('Unable to create root folder\'s link #1 entry due to database error: '.$e->getMessage());
            }


            $sql = 'INSERT INTO
                        sq_ast_lnk_tree
                        (
                            treeid,
                            linkid,
                            num_kids
                        )
                        VALUES
                        (
                            \'-\',
                            1,
                            0
                        )';

            try {
                // TODO: turn this into a PDO query
                MatrixDAL::executeSql($sql);
            } catch (Exception $e) {
                throw new Exception('Unable to create root folder\'s link tree entry due to database error: '.$e->getMessage());
            }

            $GLOBALS['SQ_SYSTEM']->doTransaction('COMMIT');
            $GLOBALS['SQ_SYSTEM']->restoreDatabaseConnection();

            if (!system_asset_fns_create_cleanup($this)) {
                return FALSE;
            }
        }//end if

        unset($this->_tmp[__CLASS__.'_in_create']);
        return $ret_val;

    }//end create()


    function _getName($short_name=FALSE)
    {
        return ($short_name) ? '/' : translate('root_folder');

    }//end _getName()


    function canDelete()
    {
        return FALSE;

    }//end canDelete()


    function canClone()
    {
        return FALSE;

    }//end canClone()


    function readAccess($assetids=Array())
    {
        return TRUE;

    }//end readAccess()


    function _checkPermissionAccess($perm, $assetids=Array())
    {
        if (empty($assetids)) {
            if ($GLOBALS['SQ_SYSTEM']->userRoot()) return TRUE;
            if ($GLOBALS['SQ_SYSTEM']->userSystemAdmin()) {
                return TRUE;
            }
            return FALSE;
        } else {
            return parent::_checkPermissionAccess($perm, $assetids);
        }

    }//end _checkPermissionAccess()


    function setAttrValue($name, $value)
    {
        if ($name == 'name' && empty($this->_tmp[__CLASS__.'_in_create'])) {
            trigger_localised_error('CORE0112', E_USER_WARNING);
            return FALSE;
        }

        return parent::setAttrValue($name, $value);

    }//end setAttrValue()


}//end class

?>