DataAccess/mysql/Inventory.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_Inventory 

// }}}
class FF_DataAccess_Inventory_mysql extends FF_DataAccess {
    // {{{ properties

    var $itemsTable;

    var $userId;

    // }}}
    // {{{ constructor

    function FF_DataAccess_Inventory_mysql()
    {
        FF_DataAccess::FF_DataAccess();
        $this->table = $this->o_registry->getConfigParam('data/item_inventory_table');
        $this->itemsTable = $this->o_registry->getConfigParam('data/items_table');
        $this->userId = FF_Auth::getCredential('userId'); 
    }

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

    function add($in_data)
    {
        $o_result = new FF_Result();
        $s_stmt = $this->o_data->autoPrepare($this->table, array('item_id', 'entered_date', 'user_id'));
        $tmp_data[0] = null;
        $tmp_data[1] = $this->timestampToISODate(time());
        $tmp_data[2] = $this->userId;
        foreach ($in_data['items'] as $a_data) {
            if (!is_null($a_data['item_id'])) {
                $tmp_data[0] = $a_data['item_id'];
                if (DB::isError($result = $this->o_data->execute($s_stmt, $tmp_data))) {
                    $o_result->addMessage($result->getMessage());
                    $o_result->setSuccess(false);
                }
            }
        }

        return $o_result;
    }

    // }}}
    // {{{ process()

    function &process()
    {
        require_once dirname(__FILE__) . '/../../Model/Item.php';
        $o_result = new FF_Result();
        $s_query = "SELECT item_id FROM $this->table";
        if (DB::isError($a_items = $this->o_data->getCol($s_query, 0))) {
            $o_result->addMessage($a_items->getMessage());
            $o_result->setSuccess(false);
            return $o_result;
        }

        // First mark everything as missing that is available
        $result = $this->o_data->autoExecute($this->itemsTable, 
                array('status' => ITEM_STATUS_MISSING), DB_AUTOQUERY_UPDATE, 
                'status=' . $this->o_data->quoteSmart(ITEM_STATUS_AVAILABLE));

        if (DB::isError($result)) {
            $o_result->addMessage($result->getMessage());
            $o_result->setSuccess(false);
            return $o_result;
        }

        // Generate where statement
        $s_where = '';
        foreach ($a_items as $s_item) {
            $s_where .= 'id = ' . $s_item . " OR \n";
        }

        $s_where .= '0=1';
        $tmp_where = 'status=' . $this->o_data->quoteSmart(ITEM_STATUS_MISSING) . " AND ($s_where)";
        // Set the status to available if the item is currently marked as missing, 
        // and is in the inventory list.
        $result = $this->o_data->autoExecute($this->itemsTable, 
                array('status' => ITEM_STATUS_AVAILABLE), DB_AUTOQUERY_UPDATE, $tmp_where);

        if (DB::isError($result)) {
            $o_result->addMessage($result->getMessage());
            $o_result->setSuccess(false);
            return $o_result;
        }

        // Now return all the items that are marked onloan, but in inventory
        $s_query = "SELECT id AS itemId FROM $this->itemsTable WHERE status=? AND ($s_where)";
        $a_items = $this->o_data->getAll($s_query, array(ITEM_STATUS_ONLOAN));
        $o_dao =& FF_DataAccess::factory('Transaction');
        $tmp_result =& $o_dao->returnItemsInTransaction($a_items);
        if (!$tmp_result->isSuccess()) {
            $o_result->setSuccess(false);
            $o_result->addMessage($tmp_result->getMessages());
        }

        return $o_result;
    }

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

    function getListData($in_where, $in_orderByField, $in_orderByDir, $in_fields = '*')
    {
        $s_query = "SELECT t1.item_id, UNIX_TIMESTAMP(t1.entered_date) AS entered_date, t1.user_id, 
                    t2.name, t2.barcode
                    FROM $this->table AS t1
                    INNER JOIN $this->itemsTable AS t2 ON t1.item_id=t2.id
                    WHERE $in_where ORDER BY $in_orderByField " .
                    $this->_getOrderByDirection($in_orderByDir);

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

    // }}}
}
?>

---