DataAccess/mysql/Log.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_Log_mysql 

// }}}
class FF_DataAccess_Log_mysql extends FF_DataAccess {
    // {{{ properties

    var $profileTable;

    // }}}
    // {{{ constructor

    function FF_DataAccess_Log_mysql()
    {
        FF_DataAccess::FF_DataAccess();
        $this->table = $this->o_registry->getConfigParam('data/log_table');
        $this->profileTable = $this->o_registry->getConfigParam('data/table', 'profile', 'profile');
    }

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

    function add($in_data)
    {
        $in_data['date'] = $this->timestampToISODate($in_data['date']);
        $in_data['`table`'] = $in_data['table'];
        unset($in_data['table']);
        unset($in_data['username']);
        $o_result =& parent::add($in_data);
    }

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

    function getListData($in_where, $in_orderByField, $in_orderByDir, $in_fields = '*')
    {
        $s_query = "SELECT user_id, username, 
                    UNIX_TIMESTAMP(date) AS date, action, target_id, loan_id, `table`
                    FROM $this->table 
                    LEFT JOIN $this->profileTable ON user_id=$this->profileTable.id
                    WHERE $in_where ORDER BY `$in_orderByField` " .
                    $this->_getOrderByDirection($in_orderByDir);

        $result =& $this->o_data->query($s_query);
        return $result;
    }

    // }}}
    // {{{ getLoanLog()

    function getLoanLog($in_loanId)
    {
        $s_ocTable = $this->o_registry->getConfigParam('data/override_codes_table');
        $s_transTable = $this->o_registry->getConfigParam('data/transaction_items_table');
        $s_itemsTable = $this->o_registry->getConfigParam('data/items_table');
        $s_query = "SELECT user_id, 
                    CONCAT(firstname, ' ', lastname) AS name, 
                    UNIX_TIMESTAMP(date) AS date, action, target_id, `table`, 
                    code, i.name AS item_name, i.barcode
                    FROM $this->table 
                    LEFT JOIN $this->profileTable ON user_id = $this->profileTable.id
                    LEFT JOIN $s_ocTable AS oc ON target_id = oc.id AND `table` = ?
                    LEFT JOIN $s_transTable AS ti ON target_id = ti.item_id AND `table` = ? 
                        AND ti.return_date = date
                    LEFT JOIN $s_itemsTable AS i ON ti.item_id = i.id
                    WHERE target_id = ? OR loan_id = ? ORDER BY date ASC";
        
        return $this->o_data->getAll($s_query, array($s_ocTable, $s_transTable, $in_loanId, $in_loanId));
    }

    // }}}
}
?>

---