DataAccess/mysql/OverrideCode.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';
require_once dirname(__FILE__) . '/../../Model/Log.php';

// }}}
// {{{ class FF_DataAccess_OverrideCode_mysql 

// }}}
class FF_DataAccess_OverrideCode_mysql extends FF_DataAccess {
    // {{{ properties

    var $o_log;

    // }}}
    // {{{ constructor

    function FF_DataAccess_OverrideCode_mysql()
    {
        FF_DataAccess::FF_DataAccess();
        $this->table = $this->o_registry->getConfigParam('data/override_codes_table');
        $this->o_log =& new FF_Model_Log();
    }

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

    function update($in_data)
    {
        $in_data['start_date'] = $this->timestampToISODate($in_data['start_date']);
        $in_data['end_date'] = $this->timestampToISODate($in_data['end_date']);
        unset($in_data['use_date']);
        unset($in_data['transaction_id']);
        unset($in_data['code']);
        $o_result =& parent::update($in_data);
        if ($o_result->isSuccess()) {
            $tmp_result =& $this->o_log->newLogEntry('UPDATE', $in_data['id'], $this->table);
        }

        return $o_result;
    }

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

    function add($in_data)
    {
        $in_data['start_date'] = $this->timestampToISODate($in_data['start_date']);
        $in_data['end_date'] = $this->timestampToISODate($in_data['end_date']);
        unset($in_data['use_date']);
        unset($in_data['transaction_id']);
        $o_result =& parent::add($in_data);
        if ($o_result->isSuccess()) {
            $tmp_result =& $this->o_log->newLogEntry('INSERT', $in_data['id'], $this->table);
        }

        return $o_result;
    }

    // }}}
    // {{{ remove()

    function remove($in_overrideCodeId)
    {
        $o_result =& parent::remove($in_overrideCodeId);
        if ($o_result->isSuccess()) {
            $tmp_result =& $this->o_log->newLogEntry('DELETE', $in_overrideCodeId, $this->table);
        }

        return $o_result;
    }

    // }}}
    // {{{ isCodeValid()

    function isCodeValid($in_code, $in_borrowerId)
    {
        $s_query = "SELECT COUNT(*) FROM $this->table
                    WHERE code = ? AND borrower_id = ? AND 
                    start_date <= NOW() AND end_date >= NOW() AND (use_date = 0 OR multi_use = 1)";

        return $this->o_data->getOne($s_query, array($in_code, $in_borrowerId)) == 0 ? false : true;
    }

    // }}}
    // {{{ useCode()

    function useCode($in_code, $in_transactionId)
    {
        $s_query = "SELECT id FROM $this->table WHERE code = ?";
        $s_id = $this->o_data->getOne($s_query, $in_code);
        $s_stmt = $this->o_data->prepare("UPDATE $this->table SET use_date=NOW(), transaction_id = ? WHERE id = ?");

        if (DB::isError($this->o_data->execute($s_stmt, array($in_transactionId, $s_id)))) {
            return false;
        }
        else {
            $tmp_result =& $this->o_log->newLogEntry('OC_USE', $s_id, $this->table, time(), $in_transactionId);
            return true;
        }
    }

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

    // }}}
    // {{{ 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, code, creator_id, UNIX_TIMESTAMP(start_date) AS start_date, UNIX_TIMESTAMP(end_date) AS end_date, UNIX_TIMESTAMP(use_date) AS use_date, transaction_id, borrower_id, multi_use';
    }

    // }}}
}
?>

---