File Source for DBKeyRadioGroup.class.php

<?php
/**
* For including this file you have to define the constant "CLASSPATH".
* Because every include in the framework depends on the CLASSPATH definition.
* The CLASSPATH means the relative path to the folder that contains the
* framework GilliGan.
*
* @package forms
* @subpackage items
*/
if( !defined( "CLASSPATH" ) )
{
echo "<h3>You have to define the constant CLASSPATH!</h3>\n";
echo "Example: define( 'CLASSPATH', '../path/to/classes/' );\n";
exit();
}
/**
*
*/
require_once( CLASSPATH."forms/items/HTMLRadioGroup.class.php" );
/**
* @package forms
* @subpackage items
* @version 0.1.0
* @author Daniel Plücken <daniel@debakel.net>
* @license http://www.gnu.org/copyleft/lesser.html
* GNU Lesser General Public License
* @copyright Copyright (C) 2006 Daniel Plücken <daniel@debakel.net>
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General
* Public License along with this library; if not, write to the
* Free Software Foundation, Inc., 59 Temple Place, Suite 330,
* Boston, MA 02111-1307 USA
*/
class DBKeyRadioGroup extends HTMLRadioGroup
{
/**
* @var object $dbt
* @access private
*/
var $dbt;
/**
* @var string $key_field
* @access private
*/
var $key_field;
/**
* @var array $label_fields
* @access private
*/
var $label_fields;
/**
* @var object $where
* @access private
*/
var $where;
/**
* Constructor
*
*
* @version 1.6
* @since 0.1.0
* @author Daniel Plücken <daniel@debakel.net>
* @access public
* @param string $name The name-attribute this select
* should get.
* @param string $selectedValue The preselected value this select
* should have.
* @param object|array$dbt Naturally you have to give the
* reference of an object of a
* database table, how they can be
* found in package databases, as
* parameter $dbt.
* You can also give the parameter dbt
* by array!
* If you use $dbt by array-syntax,
* you have to put the handle of the
* database connection at index zero,
* the source databasetable at index
* one and the database type
* ( e. g. "mysql" ) at index two.
* @param string|array$label_fields You can give one fieldname of the
* databasetable by string type or you
* can give more fieldnames as an
* array that contains them by string
* type. This fieldnames builds the
* labels of the option-tags they will
* be separated by a space.
* @param string $key_field This fieldname should be in best
* case a primary key to identify the
* meant tuple.
* @param string $where The where-clause of the db-query.
* @param string $onChangeOrder A javascript that should execute
* after changing a value of this
* select.
* @param string $preselect_field The dataset in which this field is
* greater than zero will be preselect
* if the parameter $selectedValue is
* left empty.
* @return void
*/
function DBKeyRadioGroup(
$name,
$selectedValue,
&$dbt,
$label_fields,
$key_field,
$where = "",
$onChangeOrder = "",
$preselect_field = ""
)
{
$this->key_field = $key_field;
$this->where = preg_replace( "!^ *WHERE *!i", "", $where );
$this->dbt = &$dbt;
if( is_array( $label_fields ) )
$this->label_fields = $label_fields;
else
$this->label_fields = array( $label_fields );
$error = true;
if(
is_a( $dbt, "ABSTDatabaseTable" )
|| is_subclass_of( $dbt, "ABSTDatabaseTable" )
|| is_a( $dbt, "ABSTView" )
|| is_subclass_of( $dbt, "ABSTView" )
)
{
if (
!empty( $preselect_field )
&& empty( $selectedValue )
)
$tmp_arr = array_merge(
array( $this->key_field ),
$this->label_fields,
$preselect_field
);
else
$tmp_arr = array_merge(
array( $this->key_field ),
$this->label_fields
);
$resArr = $this->dbt->getDatasetsWithFields( $tmp_arr, $this->where );
for ( $i = 0; $i < count( $resArr ); $i++ )
{
$tmp = "";
for ( $k = 0; $k < count( $this->label_fields ); $k++ )
if (
preg_match(
"!^[-_a-z0-9]*\.[-_a-z0-9]+$!",
$this->label_fields[$k]
)
&& $tmp_pos = strpos( $this->label_fields[$k], "." )
)
$tmp .= ( $k == 0 ? "" : " " )
.$resArr[$i]
[substr( $this->label_fields[$k], $tmp_pos+1 )];
else
$tmp .= ( $k == 0 ? "" : " " )
.$resArr[$i][$this->label_fields[$k]];
$labelArr[] = $tmp;
$key_field = preg_replace(
"!^[-_a-z0-9]*\.([-_a-z0-9]+)$!",
"$1", $key_field
);
$valueArr[] = $resArr[$i][$key_field];
if (
!empty( $preselect_field )
&& !in_array( $selectedValue, $valueArr )
&& $resArr[$i][$preselect_field] > 0
)
{
$_GET[$name] =
$_POST[$name] =
$_REQUEST[$name] =
$selectedValue = $resArr[$i][$key_field];
}
}
$error = false;
}
else
// Use this item in conventional php kind.
if( is_array( $dbt ) )
{
$tmp_arr = array_merge(
array( $this->key_field ),
$this->label_fields
);
switch( strtolower( $dbt[2] ) )
{
case "mysql":
$sql = "SELECT ".implode( ", ", $tmp_arr )." "
."FROM ".$dbt[1]." "
.(
!empty( $this->where )
? "WHERE ".$this->where
: ""
);
$res = mysql_query( $sql, $dbt[0] );
while( $res_arr = mysql_fetch_assoc( $res ) )
{
$tmp = "";
for( $k = 0; $k < count( $this->label_fields ); $k++ )
$tmp .= ( $k == 0 ? "" : " " )
.$res_arr[$this->label_fields[$k]];
$labelArr[] = $tmp;
$valueArr[] = $res_arr[$this->key_field];
}
break;
default:
break;
}
$error = false;
}
if(
$error
&& (
defined( "DEBUG" )
|| SCRIPTDEBUGGING
)
)
{
echo "<pre>\r\n";
echo "<b>The given third parameter is not a valid reference to a "
."databasetable!</b>\r\n";
echo "<b>BACKTRACE DEBUG:</b>\r\n";
$debugArr = debug_backtrace();
print_r( $debugArr[count($debugArr)-1] );
echo "</pre>\r\n";
}
parent::HTMLRadioGroup(
$name,
$labelArr,
$valueArr,
$selectedValue
);
}
/**
* Returns the last stored database query.
*
* @version 1.0
* @since 0.1.5
* @author Daniel Plücken <daniel@debakel.net>
* @access public
* @return array
*/
function getLastQuery()
{ return $this->dbt->getLastQuery(); }
} // end of class DBKeyRadioGroup
?>

Source for file DBKeyRadioGroup.class.php