DataAccess/mysql/Priority.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';

// }}}
// {{{ class FF_DataAccess_Priority_mysql 

// }}}
class FF_DataAccess_Priority_mysql extends FF_DataAccess {
    // {{{ constructor

    function FF_DataAccess_Priority_mysql()
    {
        FF_DataAccess::FF_DataAccess();
        $this->table = $this->o_registry->getConfigParam('data/priorities_table');
    }

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

    function update($in_data)
    {
        $o_result =& parent::update($in_data);
        if ($o_result->isSuccess()) {
            $this->_setIsDefaultToFalse($in_data);
        }
        
        return $o_result;
    }

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

    function add($in_data)
    {
        $o_result =& parent::add($in_data);
        if ($o_result->isSuccess()) {
            $this->_setIsDefaultToFalse($in_data);
        }

        return $o_result;
    }

    // }}}
    // {{{ getPriorityOptions()

    function getPriorityOptions($in_options = array())
    {
        $s_query = "SELECT points, name FROM $this->table ORDER BY points";
        $a_points = $this->o_data->getAssoc($s_query);
        if (!empty($in_options['asRange'])) {
            $a_newPoints = array();
            $tmp_points = array_keys($a_points);
            $s_last = count($tmp_points) - 1;
            for ($i = $s_last; $i >= 0; $i--) {
                $s_points = $tmp_points[$i];
                $s_prevPoints = $i == 0 ? 0 : $tmp_points[$i - 1] + 1;
                if ($i == $s_last) {
                    // If the last one, then the range is infinite, so just make the end bound a huge number
                    $a_newPoints["$s_prevPoints-10000"] = $a_points[$s_points];
                }
                else {
                    $a_newPoints["$s_prevPoints-$s_points"] = $a_points[$s_points];
                }
            }

            $a_points = $a_newPoints;
        }

        return $a_points;
    }

    // }}}
    // {{{ 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'));
    }

    // }}}
    // {{{ getDefaultValue()

    function getDefaultValue()
    {
        $s_query = "SELECT points FROM $this->table WHERE is_default=1 OR 1 ORDER BY is_default DESC LIMIT 1";
        return $this->o_data->getOne($s_query);
    }

    // }}}
    // {{{ getClosestPriority()

    function getClosestPriority($in_points)
    {
        $s_query = "SELECT points,name FROM $this->table ORDER BY ABS(points - ?) LIMIT 1";
        $a_data = $this->o_data->getAll($s_query, array($in_points));
        return $a_data[0];
    }

    // }}}
    // {{{ getNextPriority()

    function getNextPriority($in_points, $in_dir)
    {
        if ($in_dir) {
            $s_query = "SELECT points, name FROM $this->table WHERE points > ? ORDER BY points ASC LIMIT 1";
        }
        else {
            $s_query = "SELECT points, name FROM $this->table WHERE points < ? ORDER BY points DESC LIMIT 1";
        }

        $a_data = $this->o_data->getAll($s_query, array($in_points));
        return @$a_data[0];
    }

    // }}}
    // {{{ getPriorityAlerts()

    function getPriorityAlerts()
    {
        $s_query = "SELECT points, alert_message FROM $this->table WHERE alert_message != ''";
        return $this->o_data->getAssoc($s_query);
    }

    // }}}
    // {{{ _setIsDefaultToFalse()

    function _setIsDefaultToFalse($in_data)
    {
        if ($in_data['is_default']) {
            $this->o_data->autoExecute($this->table, array('is_default' => 0), DB_AUTOQUERY_UPDATE, 'id \!= ' . $this->o_data->quoteSmart($in_data['id']));
        }
    }

    // }}}
}
?>

---