tsd/TSD.php5

<?php

abstract class TSD extends SObject {
    const MODE_LIVE = 0;
    const MODE_DEV = 1;
    const MODE_DEV_ACTIVE = 2;
    const MODE_DEV_UNAPPROVED = 3;
    const MODE_NEW = 4;
    const MODE_CHANGED = 5;
    const MODE_DELETED = 6;
    const MODE_APPROVED = 7;
    const MODE_ALL = 8;
    const STATUS_NEW = 'NEW';
    const STATUS_CHANGED = 'CHANGED';
    const STATUS_DELETED = 'DELETED';
    const STATUS_APPROVED = 'APPROVED';
    const VERSION_DEV = 'DEV';
    const VERSION_LIVE = 'LIVE';
    /* @} */

    private static $DBI = null;
    private static $LocalDBI = null;
    private static $CUR_USER = null;

    public static function init() {
        $server = SConfig::getDefault('tsd.server');
        $user = SConfig::getDefault('tsd.user');

        $dbhost = SConfig::getDefault("tsd.$server.dbhost");
        $dbname = SConfig::getDefault("tsd.$server.dbname");
        $dbuser = SConfig::getDefault("tsd.$server.$user.dbuser");
        $dbpass = SConfig::getDefault("tsd.$server.$user.dbpass");

        self::$LocalDBI = new DBI($dbuser, $dbpass, $dbname, $dbhost);
        self::$DBI = SDR::getDBI();
    }

    public static function checkInit() {
        if(self::$DBI == null) {
            self::init();
        }

        return self::$DBI != null;
    }

    public static function getDBI() {
        if(!self::checkInit())
            return null;
        else
            return self::$DBI;
    }

    public static function getLocalDBI() {
        if(!self::checkInit())
            return null;
        else
            return self::$LocalDBI;
    }

    public static function getAlignments($url, $mode = TSD::MODE_LIVE) {
        if(!ctype_digit((string) ltrim(rtrim($url)))) {
            $cserdId = SDRService::getCserdIdForUrl($url);
            if(!$cserdId)
                return null;
        }
        else
            $cserdId = $url;

        $cserdId = (int)$cserdId;

        $results = array('sections' => array(), 'objectives' => array(), 'words' => array());

        $alignments = TSDText::getResourceAlignments($cserdId, $mode);
        if($alignments === null)
            return null;
        $results['sections'] = $alignments;

        $alignments = TSDStandard::getResourceAlignments($cserdId, $mode);
        if($alignments === null)
            return null;
        $results['objectives'] = $alignments;

        $alignments = TSDWord::getResourceAlignments($cserdId, $mode);
        if($alignments === null)
            return null;
        $results['words'] = $alignments;

        return $results;
    }

    private static function getCurrentUser() {
        if(self::$CUR_USER !== null)
            return self::$CUR_USER;
        if(!isset($GLOBALS['SWAT'])) {
            self::setStaticError('No SWAT object!');
            self::$CUR_USER = false;
            return false;
        }
        $guser = $GLOBALS['SWAT']->getGlobalUser();
        if(!$guser) {
            self::setStaticError('No global user!');
            self::$CUR_USER = false;
            return false;
        }
        $ldap = $guser->getAuthModule('ldap');
        if(!$ldap) {
            self::setStaticError('No LDAP authentication module!');
            self::$CUR_USER = false;
            return false;
        }
        self::$CUR_USER = $ldap->getUID();
        return self::$CUR_USER;
    }

    public static function can($what, $uid = '') {
        $curUid = self::getCurrentUser();
        if($curUid === false)
            return null;
        if($uid == '' || !ctype_digit((string) $uid) || $uid <= 0)
            $uid = $curUid;
        if($what != 'edit' && $what != 'approve' && $what != 'align') {
            self::setStaticError('Invalid permission: ' . $what);
            return null;
        }
        $query = 'SELECT uid, p' . ucfirst($what) . ' FROM Permission WHERE uid = ' . $uid;
        $result = self::getLocalDBI()->query($query);
        if(count(self::getLocalDBI()->getError()) > 0) {
            self::setStaticError('Database error: ' . implode('; ', self::getLocalDBI()->getError()));
            return null;
        }
        if(count($result) == 0)
            return false;
        if($result[0]['p' . ucfirst($what)] == '1')
            return true;
        else
            return false;
    }

    public static function setPermission($uid, $which, $how) {
        if(!self::can('approve')) {
            self::setStaticError('You do not have permission to set permissions');
            return false;
        }
        if($which != 'approve' && $which != 'edit' && $which != 'align') {
            self::setStaticError('Invalid permission: ' . $which);
            return false;
        }

        self::getLocalDBI()->query('START TRANSACTION');

        $query = 'INSERT INTO Permission SET uid = ' . $uid . ', p' . ucfirst($which) . ' = ' . ($how ? '1' : '0')
            . ' ON DUPLICATE KEY UPDATE p'. ucfirst($which) . ' = ' . ($how ? '1' : '0');
        self::getLocalDBI()->query($query);
        if(count(self::getLocalDBI()->getError()) > 0) {
            self::setStaticError('Database error: ' . implode('; ', self::getLocalDBI()->getError()));
            self::getLocalDBI()->clearErrors();
            self::getLocalDBI()->query('ROLLBACK');
            return false;
        }

        if($which == 'edit') {
            SConfig::setDefault('snap2.user', 'admin');
            $dir = SnapDirectory::lookup(SConfig::getDefault('tsd.snapPath'));
            $perm = $dir->getPermission();
            $uinfo = Snap2::getLDAP()->getUserInfo($uid);
            if($how) {
                $perm->setUserAccess('CreateResource', SnapPermission::CAP_ALLOW, $uid);
                $perm->setUserAccess('CreateVersion', SnapPermission::CAP_ALLOW, $uid);
                $perm->setUserAccess('UpdateVersion', SnapPermission::CAP_ALLOW, $uid);
                $perm->setUserAccess('SubmitVersion', SnapPermission::CAP_ALLOW, $uid);
                $perm->setUserAccess('ApproveVersionDev', SnapPermission::CAP_ALLOW, $uid);
            }
            else
                $perm->revokeUser($uid);
            if(!$perm->commit()) {
                self::getLocalDBI()->query('ROLLBACK');
                return false;
            }
        }

        $query = 'DELETE FROM Permission WHERE pEdit = 0 AND pAlign = 0 AND pApprove = 0';
        self::getLocalDBI()->query($query);
        if(count(self::getLocalDBI()->getError()) > 0) {
            self::setStaticError('Database error: ' . implode('; ', self::getLocalDBI()->getError()));
            self::getLocalDBI()->clearErrors();
            self::getLocalDBI()->query('ROLLBACK');
            return false;
        }

        self::getLocalDBI()->query('COMMIT');

        return true;
    }

    public static function getParties() {
        $query = 'SELECT uid FROM Permission';
        $result = self::getLocalDBI()->query($query);
        if(count(self::getLocalDBI()->getError()) > 0) {
            self::setStaticError('Database error: ' . implode('; ', self::getLocalDBI()->getError()));
            return null;
        }
        $parties = array();
        foreach($result as $r)
            $parties[] = $r['uid'];
        return $parties;
    }

    public static function stringToMode($modeString) {
        switch(strtolower($modeString)) {
            case 'live': return TSD::MODE_LIVE;
            case 'dev': return TSD::MODE_DEV;
            case 'devactive': return TSD::MODE_DEV_ACTIVE;
            case 'devunapproved': return TSD::MODE_DEV_UNAPPROVED;
            case 'new': return TSD::MODE_NEW;
            case 'changed': return TSD::MODE_CHANGED;
            case 'deleted': return TSD::MODE_DELETED;
            case 'approved': return TSD::MODE_APPROVED;
            case 'all': return TSD::MODE_ALL;
        }
        return TSD::MODE_LIVE;
    }

    public static function log($description, $query) {
        $user = self::getCurrentUser();
        $description = mysql_escape_string($description);
        $query = mysql_escape_string($query);
        self::getDBI()->query("INSERT INTO TSDLog SET uid = '$user', description = '$description', query = '$query'");
    }
}

?>

---