DataAccess/mysql/Alumni.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';

// }}}
// {{{ constants

// The filters for the list/display pages
define('ALUMNI_FILTER_WEB_SITE', 1);
define('ALUMNI_FILTER_EMAILS', 2);

// }}}
// {{{ class FF_DataAccess_Alumni_mysql 

// }}}
class FF_DataAccess_Alumni_mysql extends FF_DataAccess {
    // {{{ constructor

    function FF_DataAccess_Alumni_mysql()
    {
        FF_DataAccess::FF_DataAccess();
        $this->table = $this->o_registry->getConfigParam('data/alums_table', 'alumni_alums', 'alum_website');
    }

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

    function update($in_data)
    {
        return parent::update($in_data);
    }

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

    function add($in_data)
    {
        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 = '*')
    {
        $s_profileTable = $this->o_registry->getConfigParam('data/table', 'profile', 'profile');
        $s_query = "SELECT a.id, student_id, maiden_name, title, company, address, city, 
                    state, country, postal_code, p.phone, fax, web_site, 
                    major, degree, concentration, grad_year, grad_month, 
                    UNIX_TIMESTAMP(birth_date) AS birth_date,
                    p.firstname, p.lastname, p.email
                    FROM $this->table AS a 
                    INNER JOIN $s_profileTable AS p ON a.id = p.id
                    WHERE p.lastname != '' AND $in_where ORDER BY $in_orderByField " . $this->_getOrderByDirection($in_orderByDir); 
        return $this->o_data->query($s_query);
    }

    // }}}
    // {{{ getListFilter()

    function getListFilter($in_searchString, $in_searchFields, $in_filter, $in_filterData)
    {
        // Get only those alumni who have web sites and whose name
        // begins with the specified letter
        if ($in_filter == ALUMNI_FILTER_WEB_SITE) {
            return sprintf('web_site != "" AND lastname LIKE %s',
                    $this->o_data->quoteSmart($in_searchString . '%'));
        }
        // Get only those alumni who have chosen to make their record public
        elseif ($in_filter == ALUMNI_FILTER_EMAILS) {
            $s_filter = 'is_public = 1 AND ';
        }
        else {
            $s_filter = '';
        }

        return $s_filter . '(' . parent::getListFilter($in_searchString, $in_searchFields, $in_filter, $in_filterData) . ')';
    }

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

    function _getSelectFields()
    {
        // Birth date can be before unix epoch so we use DATE_FORMAT and
        // strtotime(), but note that some platforms don't support negative
        // timestamps
        return '*, DATE_FORMAT(birth_date, "%m/%d/%Y") AS birth_date';
    }

    // }}}
}
?>

---