DataAccess/mysql/CustomField.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_CustomField_mysql 

// }}}
class FF_DataAccess_CustomField_mysql extends FF_DataAccess {
    // {{{ properties

    var $dataTable;

    // }}}
    // {{{ constructor

    function FF_DataAccess_CustomField_mysql()
    {
        FF_DataAccess::FF_DataAccess();
        $this->table = $this->o_registry->getConfigParam('data/custom_fields', 'mayday_custom_fields', 'mayday');
        $this->dataTable = $this->o_registry->getConfigParam('data/custom_fields_data', 'mayday_custom_fields_data', 'mayday');
    }

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

    function remove($in_id)
    {
        $o_result =& parent::remove($in_id); 
        if ($o_result->isSuccess()) {
            $tmp = $this->table;
            $this->table = $this->dataTable;
            $o_result =& parent::remove($in_id, 'field_id');
            $this->table = $tmp;
        }
        
        return $o_result;
    }

    // }}}
    // {{{ getFieldsByCategory()

    function getFieldsByCategory($in_catId, $in_ticketId = null)
    {
        if (!is_null($in_ticketId)) {
            $s_query = "SELECT id, category_id, description, type, data
                        FROM $this->table AS t1 
                        LEFT JOIN $this->dataTable AS t2 ON t1.id = t2.field_id AND ticket_id = ?
                        WHERE category_id = ? ORDER BY id";

            return $this->o_data->getAll($s_query, array($in_ticketId, $in_catId));
        }
        else {
            $s_query = "SELECT * FROM $this->table WHERE category_id = ? ORDER BY id";

            return $this->o_data->getAll($s_query, array($in_catId));
        }

    }

    // }}}
    // {{{ saveData()

    function saveData($in_fieldId, $in_ticketId, $in_data, &$in_result)
    {
        $result = $this->o_data->autoExecute($this->dataTable, array('data' => $in_data, 'field_id' => $in_fieldId, 'ticket_id' => $in_ticketId));
        if (DB::isError($result)) {
            $in_result->addMessage($result->getMessage());
        }
    }

    // }}}
    // {{{ removeDataForTicket()

    function removeDataForTicket($in_ticketId)
    {
        $s_stmt = $this->o_data->prepare("DELETE FROM $this->dataTable WHERE ticket_id = ?");
        $this->o_data->execute($s_stmt, $in_ticketId);
    }

    // }}}
    // {{{ getCategoriesWithField()

    function getCategoriesWithField()
    {
        $s_query = "SELECT DISTINCT(category_id) FROM $this->table";
        return $this->o_data->getCol($s_query, 0);
    }

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

    // }}}
}
?>

---