File Source for DBTfillingForm.class.php

<?php
/**
* @package forms
*/
if( !defined( "CLASSPATH" ) )
{
echo "<h3>You have to define the constant CLASSPATH!</h3>\n";
echo "Example: define( 'CLASSPATH', '../path/to/classes/' );\n";
exit();
}
/**
* Including the basic class to define html forms.
*/
require_once( CLASSPATH."forms/HTMLForm.class.php" );
/**
* Including various funktions to manipulate arrays.
*/
include_once( CLASSPATH."core/Arrays.class.php" );
/**
* A class to generate forms to put data in a databasetable.
*
* @package forms
* @version 0.2.5
* @since 0.4.0.2
* @author Daniel Plücken <daniel@debakel.net>
* @license http://www.gnu.org/copyleft/lesser.html
* GNU Lesser General Public License
* @copyright Copyright (C) 2003 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 DBTfillingForm extends HTMLForm
{
/**
* The reference to the needed Databasetable-Object.
*
* @var object $dbt_obj
* access private
*/
var $dbt_obj;
/**
* @var integer $lastEntryId
*/
var $lastEntryId;
/**
* Constructor
*
* @version 1.0
* @since 0.1.0
* @author Daniel Plücken <daniel@debakel.net>
* @access public
* @param object $dbt_obj The reference to the needed
* Databasetable-Object.
* @param string $name The name of the form.
* @param string $onSubmitOrder The javascript thatshould be execute
* before submit.
* @param string $targetFile The file that should receive the data.
* @param string $method The Method how the data should be send
* ( "post" or "get" )
*/
function DBTfillingForm(
&$dbt_obj,
$name = "DP_Form",
$onSubmitOrder = "",
$targetFile = "",
$method = "POST"
)
{
$this->dbt_obj = $dbt_obj;
$this->HTMLForm(
$name,
$onSubmitOrder,
$targetFile,
$method
);
}
/**
* Sets up the databasetable by using the information of the form.
*
* @version 1.0
* @since 0.1.7
* @author Daniel Plücken <daniel@debakel.net>
* @access public
* @return void
*/
function setupDBT()
{
$sqlQueryString = "ALTER TABLE ".$this->dbt_obj->getName()." ";
$alreadyAddedCols = "";
for( $i = 0; $i < count( $this->formItems ); $i++ )
{
if(
strtolower(
get_class( $this->formItems[$i] )
) != "htmlsubmitbutton"
&& strtolower(
get_class( $this->formItems[$i] )
) != "htmlbutton"
)
{
if(
strpos(
$alreadyAddedCols,
$this->formItems[$i]->getName()
) === false
)
{
switch( strtolower( get_class( $this->formItems[$i] ) ) )
{
case "htmltextinput":
$sqlQueryString .= "ADD ".$this->formItems[$i]
->getName()." VARCHAR( 255 ) NOT NULL, ";
break;
case "htmlpasswordinput":
$sqlQueryString .= "ADD ".$this->formItems[$i]
->getName()." VARCHAR( 20 ) NOT NULL, ";
break;
case "htmltextarea":
$sqlQueryString .= "ADD ".$this->formItems[$i]
->getName()." TEXT NOT NULL, ";
break;
case "htmlcheckbox":
$sqlQueryString .= "ADD ".$this->formItems[$i]
->getName()." INT( 1 ) NOT NULL, ";
break;
case "htmlselect":
$sqlQueryString .= "ADD ".$this->formItems[$i]
->getName()."` VARCHAR( 150 ) NOT NULL, ";
break;
case "fileselect":
$sqlQueryString .= "ADD ".$this->formItems[$i]
->getName()." VARCHAR( 150 ) NOT NULL, ";
break;
case "htmlradiogroup":
$sqlQueryString .= "ADD ".$this->formItems[$i]
->getName()." VARCHAR( 150 ) NOT NULL, ";
break;
case "dateselect":
$sqlQueryString .= "ADD ".$this->formItems[$i]
->getName()." INT( 15 ) NOT NULL, ";
}
$alreadyAddedCols .= $this->formItems[$i]->getName();
}
}
}
// delete last comma
echo $sqlQueryString = substr(
$sqlQueryString, 0,
strlen( $sqlQueryString ) - 2
).";";
$result = $this->dbt_obj->parent->query( $sqlQueryString );
return $result;
}
/**
* Returns a single dataset as an array if the query could be execute.
*
* @version 1.0
* @since 0.1.4
* @author Daniel Plücken <daniel@debakel.net>
* @access public
* @param string $where
* @return array
*/
function getSingleDataset( $where )
{ return $this->dbt_obj->getSingleDataset( $where ); }
/**
* Returns the datasets as an two dimensional array if the query could be
* execute. The first dimension carries the datasets. The second dimension
* carries the fields's values of the result list.
*
* Usage:
* getDatasetsWithFields( $fieldnamesArr, $where );
* Or:
* getDatasetsWithFields( $where );
*
* @version 1.0
* @since 0.1.2
* @author Daniel Plücken <daniel@debakel.net>
* @access public
* @param array $fieldnamesArr The fields that should be in the result
* list.
* @param string $where The where clause of the query.
* @return array
*/
function getDatasetsWithFields( $fieldnamesArr, $where = "" )
{ return $this->dbt_obj->getDatasetsWithFields( $fieldnamesArr, $where ); }
/**
* Returns the table's fieldnames.
*
* @version 1.0
* @since 0.1.2
* @author Daniel Plücken <daniel@debakel.net>
* @access public
* @return array
*/
function getDBTFieldNames()
{ return $this->dbt_obj->getFieldNames(); }
/**
* Returns the fieldnames and values of the form by a two dimensional array.
*
* @version 1.5
* @since 0.1.4
* @author Daniel Plücken <daniel@debakel.net>
* @access public
* @return array
*/
function getFieldsAndValues()
{
$tmp_arr = $this->dbt_obj->getRealFieldnames();
return parent::getFieldsAndValues( $tmp_arr );
}
/**
* Updates the gotten Dataset.
*
* @version 1.3
* @since 0.1.4
* @author Daniel Plücken <daniel@debakel.net>
* @access public
* @param $where The where-definition to the dataset.
* @return mixed
*/
function updateDBT( $where = "" )
{
$tmp_vars = $this->getFieldsAndValues();
if ( empty( $where ) )
{
$p_key =& $this->dbt_obj->getPrimaryKey;
$where = "";
$and = "";
foreach ( $p_key as $tmp )
{
$where .= $and.$tmp." = '".max(
$_GET[$tmp],
$_POST[$tmp],
$_REQUEST[$tmp]
)."'";
$and = " AND ";
}
}
$result = $this->dbt_obj->update(
$tmp_vars["fields"],
$tmp_vars["values"],
$where
);
return $result;
}
/**
* Inserts a Dataset into the specified database's table.
*
* @version 1.2
* @since 0.1.4
* @author Daniel Plücken <daniel@debakel.net>
* @access public
* @return integer|boolean
*/
function insertIntoDBT()
{
$GLOBALS["insert_id"] = 0;
$tmp_vars = $this->getFieldsAndValues();
$result = $this->dbt_obj->insert(
$tmp_vars["fields"],
$tmp_vars["values"]
);
$this->addHiddenFormItem( "id", $GLOBALS["insert_id"] );
if( !empty( $GLOBALS["insert_id"] ) )
return $GLOBALS["insert_id"];
else
return $result;
}
/**
* Replaces a Dataset into the specified database's table.
*
* @version 1.0
* @since 0.2.5
* @author Daniel Plücken <daniel@debakel.net>
* @access public
* @return mixed
*/
function replaceIntoDBT()
{
$tmp_vars = $this->getFieldsAndValues();
$result = $this->dbt_obj->replace(
$tmp_vars["fields"],
$tmp_vars["values"]
);
$_REQUEST["id"] = @mysql_insert_id();
$this->addHiddenFormItem( "id", $_REQUEST["id"] );
if( !empty( $_REQUEST["id"] ) )
return $_REQUEST["id"];
else
return $result;
}
/**
* Generates the sourcecode to build this object and returns it.
*
* @version 1.0
* @since 0.1.2
* @author Daniel Plücken <daniel@debakel.net>
* @access public
* @return string
*/
function getPHPSource()
{
// setting Layouttable if exists.
if( !empty( $this->layoutTable ) )
$out = $this->layoutTable->getPHPSource()."\r\n\r\n";
for( $i = 0; $i < count( $this->formItems ); $i++ )
$out .= $this->formItems[$i]->getPHPSource()."\r\n\r\n";
// $out .= $this->dbt_obj->getItemPHPSource();
$out .= "\x24formname = \"".$this->getName()."\";\r\n";
$out .= !empty( $this->onSubmitOrder )
? "\x24onSubmitOrder = \"".$this->getSubmitOrder()."\";\r\n"
: "";
$out .= !empty( $this->targetFile )
? "\x24targetFile = \"".$this->getTargetFile()."\";\r\n"
: "";
$out .= !empty( $this->method )
? "\x24method = \"".$this->getMethod()."\";\r\n"
: "";
$out .= "\x24form = new DBTfillingForm(\r\n"
." \x24dbt,\r\n"
." \x24formname,\r\n"
." \x24onSubmitOrder,\r\n"
." \x24targetFile,\r\n"
." \x24method \r\n"
." );\r\n\r\n";
$out .= $this->getItemPHPSource();
$out .= "\x24error = false;\r\n";
$out .= "if( !empty( \x24formsent ) )\r\n";
$out .= "{\r\n";
$out .= " if( empty( \x24_REQUEST[\"id\"] ) )\r\n";
$out .= " if( \x24id = \x24form -> insertIntoDBT() )\r\n";
$out .= " \x24err_msg = \""
."Erfolgreich eingetragen.\";\r\n";
$out .= " else\r\n";
$out .= " {\r\n";
$out .= " \x24error = true;\r\n";
$out .= " \x24err_msg = \""
."Leider ist ein Fehler aufgtreten. "
."Bitte versuchen Sie es erneut.\";\r\n";
$out .= " }\r\n\r\n";
$out .= " if( !empty( \x24_REQUEST[\"id\"] ) )\r\n";
$out .= " if( "
."\x24form->updateDBT( "
."\"id = '\".\x24_REQUEST[\"id\"].\"'\" "
.") "
.")\r\n";
$out .= " \x24err_msg = \""
."Erfolgreich eingetragen.\";\r\n";
$out .= " else\r\n";
$out .= " {\r\n";
$out .= " \x24error = true;\r\n";
$out .= " \x24err_msg = \""
."Leider ist ein Fehler aufgtreten. "
."Bitte versuchen Sie es erneut.\";\r\n";
$out .= " }\r\n\r\n";
$out .= "}\r\n";
$out .= "\x24form->addHiddenFormItem( "
."\"id\", \x24_REQUEST[\"id\"] "
.");\r\n\r\n";
return $out;
}
} // End of class DBTfillingForm
?>

Source for file DBTfillingForm.class.php