DataAccess/mysql/Spotlight.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_Spotlight_mysql 

// }}}
class FF_DataAccess_Spotlight_mysql extends FF_DataAccess {
    // {{{ constructor

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

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

    function update($in_data)
    {
        $this->_fixImageData($in_data, true);
        $this->_updateFrontpage($in_data['frontpage']);
        return parent::update($in_data);
    }

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

    function add($in_data)
    {
        $this->_fixImageData($in_data, true);
        $this->_updateFrontpage($in_data['frontpage']);
        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());
    }

    // }}}
    // {{{ getFrontpageId()

    function getFrontpageId()
    {
        $s_query = "SELECT id FROM $this->table WHERE frontpage = 1 LIMIT 1";
        return $this->o_data->getOne($s_query);
    }

    // }}}
    // {{{ getImageData()

    function getImageData($in_id, $in_num)
    {
        $tmp = 'image' . $in_num;
        $tmp2 = 'mime_type' . $in_num;
        return $this->o_data->getRow("SELECT $tmp, $tmp2 FROM $this->table WHERE id = ? LIMIT 1",
                array($in_id), DB_FETCHMODE_ORDERED);
    }

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

    // }}}
    // {{{ _updateFrontpage()

    function _updateFrontpage($in_frontpage)
    {
        if ($in_frontpage) {
            $this->o_data->autoExecute($this->table, array('frontpage' => false), DB_AUTOQUERY_UPDATE);
        }
    }

    // }}}
    // {{{ _fixImageData()

    function _fixImageData(&$in_data, $in_isUpdate)
    {
        for ($i = 1; $i <= 3; $i++) {
            $s_imageField = 'image' . $i;
            $s_mimeField = 'mime_type' . $i;
            if (is_null($in_data[$s_imageField])) {
                unset($in_data[$s_imageField]);
            }

            if (is_null($in_data[$s_mimeField])) {
                unset($in_data[$s_mimeField]);
            }
        }
    }

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

    function _getSelectFields()
    {
        return 'id, title, text1, text2, text3, footer, frontpage, UNIX_TIMESTAMP(timestamp) AS timestamp';
    }

    // }}}
}
?>

---