DataAccess/mysql/Assignment.php

Go to the documentation of this file.

<?php
// {{{ license

// +----------------------------------------------------------------------+
// | FastFrame Application Framework                                      |
// +----------------------------------------------------------------------+
// | Copyright (c) 2002-2006 The Codejanitor Group                        |
// +----------------------------------------------------------------------+
// | This source file is subject to the GNU Lesser Public License (LGPL), |
// | that is bundled with this package in the file LICENSE, and is        |
// | available at through the world-wide-web at                           |
// | http://www.fsf.org/copyleft/lesser.html                              |
// | If you did not receive a copy of the LGPL and are unable to          |
// | obtain it through the world-wide-web, you can get it by writing the  |
// | Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, |
// | MA 02111-1307, USA.                                                  |
// +----------------------------------------------------------------------+
// | Authors: Jason Rust <jrust@codejanitor.com>                          |
// +----------------------------------------------------------------------+

// }}}
// {{{ requires

require_once FASTFRAME_ROOT . 'lib/FastFrame/DataAccess.php';

// }}}
// {{{ constants

// The type constants
define('FILTER_BY_OWNER', 1);

// }}}
// {{{ class FF_DataAccess_Assignment_mysql 

// }}}
class FF_DataAccess_Assignment_mysql extends FF_DataAccess {
    // {{{ constructor

    function FF_DataAccess_Assignment_mysql()
    {
        FF_DataAccess::FF_DataAccess();
        $this->table = $this->o_registry->getConfigParam('data/assignments_table', 'homework_assignments');
    }

    // }}}
    // {{{ update()

    function update($in_data)
    {
        $in_data['open_time'] = empty($in_data['open_time']) ? $this->timestampToISODate(0) : $this->timestampToISODate($in_data['open_time']);
        $in_data['late_time'] = $this->timestampToISODate($in_data['late_time']);
        $in_data['close_time'] = empty($in_data['close_time']) ? $this->timestampToISODate(0) : $this->timestampToISODate($in_data['close_time']);
        return parent::update($in_data);
    }

    // }}}
    // {{{ add()

    function add($in_data)
    {
        $in_data['open_time'] = empty($in_data['open_time']) ? 0 : $this->timestampToISODate($in_data['open_time']);
        $in_data['late_time'] = $this->timestampToISODate($in_data['late_time']);
        $in_data['close_time'] = empty($in_data['close_time']) ? 0 : $this->timestampToISODate($in_data['close_time']);
        return parent::add($in_data);
    }

    // }}}
    // {{{ getDataByPrimaryKey()

    function getDataByPrimaryKey($in_id, $in_fields = '*')
    {
        return parent::getDataByPrimaryKey($in_id, $this->_getSelectFields());
    }

    // }}}
    // {{{ getListData()

    function getListData($in_where, $in_orderByField, $in_orderByDir, $in_fields = '*')
    {
        return parent::getListData($in_where, $in_orderByField, $in_orderByDir, $this->_getSelectFields());
    }

    // }}}
    // {{{ getListFilter()

    function getListFilter($in_searchString, $in_searchFields, $in_filter, $in_filterData)
    {
        $s_filter = '';
        if ($in_filter == FILTER_BY_OWNER) {
            $s_filter = 'owner_id = ' . $this->o_data->quoteSmart($in_filterData['ownerId']) . ' AND ';
        }

        $s_filter .= '(' . parent::getListFilter($in_searchString, $in_searchFields, $in_filter, $in_filterData) . ')';
        return $s_filter;
    }

    // }}}
    // {{{ getClassOptions()
    
    function getClassOptions()
    {
        $s_query = 'SELECT CONCAT(crscode,"-",secno) AS a, CONCAT(crscode,"-",secno) AS b
                    FROM studentinfo.importclasses
                    WHERE start_date <= DATE_ADD(NOW(), INTERVAL 14 DAY) AND end_date >= NOW()
                    ORDER BY a';
        return $this->o_data->getAssoc($s_query);
    }

    // }}}
    // {{{ getSessionOptions()
    
    function getSessionOptions()
    {
        $s_query = 'SELECT start_date, start_date
                    FROM studentinfo.importclasses
                    WHERE start_date >= DATE_SUB(NOW(), INTERVAL 100 DAY)
                    GROUP BY start_date
                    ORDER BY start_date';
        return $this->o_data->getAssoc($s_query);
    }

    // }}}
    // {{{ getDescriptionsById()

    function getDescriptionsById($in_ids) {
        $s_where = '';
        foreach ($in_ids as $s_id) {
            $s_where .= 'id = ' . $this->o_data->quoteSmart($s_id) . ' OR ';
        }

        $s_where .= '0';
        $s_query = "SELECT CONCAT(name, ' (', course_code, ')')
                    FROM $this->table
                    WHERE $s_where ORDER BY name";
        return $this->o_data->getCol($s_query, 0);
    }

    // }}}
    // {{{ updateCourseCodes()

    function updateCourseCodes($in_ids, $in_course, $in_ownerId)
    {
        $s_where = '';
        foreach ($in_ids as $s_id) {
            $s_where .= 'id = ' . $this->o_data->quoteSmart($s_id) . ' OR ';
        }

        $s_where .= '0';
        $s_query = "UPDATE $this->table SET course_code = ? WHERE owner_id = ? AND ($s_where)";
        $o_result =& $this->o_data->query($s_query, array($in_course, $in_ownerId));
        return !PEAR::isError($o_result);
    }

    // }}}
    // {{{ updateSession()

    function updateSession($in_ids, $in_session, $in_ownerId)
    {
        $s_where = '';
        foreach ($in_ids as $s_id) {
            $s_where .= 'id = ' . $this->o_data->quoteSmart($s_id) . ' OR ';
        }

        $s_where .= '0';
        $s_query = "UPDATE $this->table SET session = ? WHERE owner_id = ? AND ($s_where)";
        $o_result =& $this->o_data->query($s_query, array($in_session, $in_ownerId));
        return !PEAR::isError($o_result);
    }

    // }}}
    // {{{ updateTimes()

    function updateTimes($in_ids, $in_updateSeconds, $in_ownerId, $in_type)
    {
        $s_where = '';
        foreach ($in_ids as $s_id) {
            $s_where .= 'id = ' . $this->o_data->quoteSmart($s_id) . ' OR ';
        }

        $s_where .= '0';
        $s_field = $in_type . '_time';
        $s_query = "UPDATE $this->table 
                    SET $s_field = DATE_ADD($s_field, INTERVAL ! SECOND)
                    WHERE $s_field \!= 0 AND owner_id = ? AND ($s_where)";
        $o_result =& $this->o_data->query($s_query, array($in_updateSeconds, $in_ownerId));
        return !PEAR::isError($o_result);
    }

    // }}}
    // {{{ getNextId()

    function getNextId()
    {
        // change sequence name since we give it the full table name
        $this->o_data->setOption('seqname_format', '%s');
        return $this->o_data->nextId($this->o_registry->getConfigParam('data/sequence_table'));
    }

    // }}}
    // {{{ _getSelectFields()

    function _getSelectFields()
    {
        return 'id, name, session, UNIX_TIMESTAMP(open_time) AS open_time, UNIX_TIMESTAMP(late_time) AS late_time, UNIX_TIMESTAMP(close_time) AS close_time, owner_id, course_code';
    }

    // }}}
}
?>

---