File Source for DBKeySelect.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/HTMLSelect.class.php" );
/**
* @package forms
* @subpackage items
* @version 0.1.62
* @author Daniel Plücken <daniel@debakel.net>
* @license http://www.gnu.org/copyleft/lesser.html
* GNU Lesser General Public License
* @copyright Copyright (C) 2005 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 DBKeySelect extends HTMLSelect
{
/**
* @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.81
* @since 0.1.0
* @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 or database view,
* 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 has
* the value of the parameter
* $preselected_value will be
* preselect if the parameter
* selectedValue is empty.
* @param string $preselected_value The value that the field, given
* with the parameter
* $preselect_field, has to have to be
* preselect. The default value is 1.
*
* @return void
*/
function DBKeySelect(
$name,
$selectedValue,
&$dbt,
$label_fields,
$key_field,
$where = "",
$onChangeOrder = "",
$preselect_field = "",
$preselected_value = 1
)
{
$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" )
)
{
$tmp_arr = array();
if (
!empty( $preselect_field )
&& empty( $selectedValue )
)
{
$tmp_arr = array_merge(
array( $this->key_field ),
$this->label_fields,
array( $preselect_field )
);
}
else
{
$tmp_arr = array_merge(
array( $this->key_field ),
$this->label_fields
);
}
$res_arr = $dbt->getDatasetsWithFields(
$tmp_arr,
$this->where,
false,
MYSQL_OUTPUT_NUM
);
for ( $i = 0; $i < count( $res_arr ); $i++ )
{
$tmp = "";
if ( is_array( $res_arr[$i] ) )
foreach ( $res_arr[$i] as $str_fieldidx => $str_fieldval )
if (
$str_fieldidx != 0
&& $str_fieldidx <= count( $this->label_fields )
)
$tmp .= ( empty( $tmp ) ? "" : " " ).$str_fieldval;
$labelArr[] = $tmp;
$valueArr[] = $res_arr[$i][0];
$tmp_matches_arr = array();
preg_match(
"/^([<=!>]+) *+(.+)/is",
$preselected_value,
$tmp_matches_arr
);
$str_operator = $tmp_matches_arr[1];
$str_value = $tmp_matches_arr[2];
if (
!empty( $preselect_field )
&& !in_array( $selectedValue, $valueArr )
&& (
$res_arr[$i][ count( $label_fields ) + 1 ] == $preselected_value
|| preg_match( "/^(?:<=|<|>|>=|==|===|!=|!==)$/", $str_operator )
&& eval(
$res_arr[$i][ count( $label_fields ) + 1 ]." "
.$str_operator." ".$preselected_value
)
)
)
{
$_GET[$name] =
$_POST[$name] =
$_REQUEST[$name] =
$selectedValue = $res_arr[$i][0];
}
}
$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 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::HTMLSelect(
$name,
$labelArr,
$valueArr,
$selectedValue,
$onChangeOrder
);
}
/**
* 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 DBKeySelect
?>

Source for file DBKeySelect.class.php