Location: PHPKode > projects > PhpCodeGenie > phpCodeGenie3.0.2/app/generators/php/plugins/simpleDbGenerator/commonSimpleDbGenerator.class.php
<? 
class commonSimpleDb
{

	// Variables
	// configurationFile  field from table
	var $configurationFile ;
	// codeStarter  field from table
	var $codeStarter ;
	// codeEnder  field from table
	var $codeEnder ;
	// codeTab  field from table
	var $codeTab ;
	// lineEnder  field from table
	var $lineEnder ;
	// Variables
	// tableObject  field from table
	var $tableObject ;
	// code field from table
	var $sourceCode;
	var $headerText ;
	var $footerText;



	/**
	* @return returns value of variable $configurationFile
	* @desc getConfigurationFile : Getting value for variable $configurationFile
	*/
	function getConfigurationFile ()
	{
		return $this->configurationFile ;
	}

	/**
	* @param param : value to be saved in variable $configurationFile
	* @desc setConfigurationFile : Setting value for $configurationFile
	*/
	function setConfigurationFile ($value)
	{
		$this->configurationFile  = $value;
	}


	/**
	* @return returns value of variable $codeStarter
	* @desc getCodeStarter : Getting value for variable $codeStarter
	*/
	function getCodeStarter ()
	{
		return $this->codeStarter ;
	}

	/**
	* @param param : value to be saved in variable $codeStarter
	* @desc setCodeStarter : Setting value for $codeStarter
	*/
	function setCodeStarter ($value)
	{
		$this->codeStarter  = $value;
	}

	/**
	* @return returns value of variable $codeEnder
	* @desc getCodeEnder : Getting value for variable $codeEnder
	*/
	function getCodeEnder ()
	{
		return $this->codeEnder ;
	}

	/**
	* @param param : value to be saved in variable $codeEnder
	* @desc setCodeEnder : Setting value for $codeEnder
	*/
	function setCodeEnder ($value)
	{
		$this->codeEnder  = $value;
	}

	/**
	* @return returns value of variable $codeTab
	* @desc getCodeTab : Getting value for variable $codeTab
	*/
	function getCodeTab ()
	{
		return $this->codeTab ;
	}

	/**
	* @param param : value to be saved in variable $codeTab
	* @desc setCodeTab : Setting value for $codeTab
	*/
	function setCodeTab ($value)
	{
		$this->codeTab  = $value;
	}

	/**
	* @return returns value of variable $lineEnder
	* @desc getLineEnder : Getting value for variable $lineEnder
	*/
	function getLineEnder ()
	{
		return $this->lineEnder ;
	}

	/**
	* @param param : value to be saved in variable $lineEnder
	* @desc setLineEnder : Setting value for $lineEnder
	*/
	function setLineEnder ($value)
	{
		$this->lineEnder  = $value;
	}


	/**
	* @return returns value of variable $tableObject
	* @desc getTableObject : Getting value for variable $tableObject
	*/
	function getTableObject ()
	{
		return $this->tableObject ;
	}

	/**
	* @param param : value to be saved in variable $tableObject
	* @desc setTableObject : Setting value for $tableObject
	*/
	function setTableObject ($value)
	{
		$this->tableObject  = $value;
	}

	/**
	* @return returns value of variable $code
	* @desc getCode : Getting value for variable $code
	*/
	function getSourceCode()
	{
		return $this->sourceCode;
	}

	/**
	* @param param : value to be saved in variable $code
	* @desc setCode : Setting value for $code
	*/
	function setSourceCode($value)
	{
		$this->sourceCode = $value;
	}

	/**
	* @return returns value of variable $headerText
	* @desc getHeaderText : Getting value for variable $headerText
	*/
	function getHeaderText ()
	{
		return $this->headerText ;
	}

	/**
	* @param param : value to be saved in variable $headerText
	* @desc setHeaderText : Setting value for $headerText
	*/
	function setHeaderText ($value)
	{
		$this->headerText  = $value;
	}

	/**
	* @return returns value of variable $footerText
	* @desc getFooterText : Getting value for variable $footerText
	*/
	function getFooterText()
	{
		return $this->footerText;
	}

	/**
	* @param param : value to be saved in variable $footerText
	* @desc setFooterText : Setting value for $footerText
	*/
	function setFooterText($value)
	{
		$this->footerText = $value;
	}


	function initializeSimpleDbFramework($configurationFile="")
	{

		if ($configurationFile=="")
		{
			$thisT = $this->getTableObject();
			$configurationFile = strtolower($thisT->getDatabase()).".conf.inc.php";
		}

		$this->setConfigurationFile($configurationFile);

		$this->setCodeStarter("<?php\n");
		$this->setCodeEnder("?>");
		$this->setCodeTab("\t");
		$this->setLineEnder("\n");
		$this->setSourceCode("");

	}


	/**
	* @return put return description here..
	* @param param :  parameter passed to function
	* @desc buildWebHeader :  put function description here ...
	*/
	function appendWebHeader ()
	{
		$code = "";
		$code .= $this->getCodeStarter();

		if ($this->getHeaderText()=="")
		{

			$code .= $this->getCodeTab()."include_once(\"dbConnection.php\");".$this->getLineEnder();
			$code .= $this->getCodeTab()."include_once(\"header.php\");".$this->getLineEnder();

		}
		else
		{
			$code .= stripslashes($this->getHeaderText()).$this->getLineEnder();
		}

		$code .= $this->getCodeEnder();


		$this->appendToCode($code);
	}


	/**
	* @return put return description here..
	* @param param :  parameter passed to function
	* @desc buildWebFooter :  put function description here ...
	*/
	function appendWebFooter ()
	{
		$code = "";
		$code .=  $this->getCodeStarter();

		if ($this->getFooterText()=="")
		{
			$code .= $this->getCodeTab()."include_once(\"footer.php\");".$this->getLineEnder();
		}
		else {
			$code .= stripslashes($this->getFooterText()).$this->getLineEnder();
		}

		$code .= $this->getCodeEnder();
		$this->appendToCode($code);
	}

	/**
	* @return put return description here..
	* @param param :  parameter passed to function
	* @desc buildSuperHeader :  put function description here ...
	*/
	function appendSuperHeader ()
	{

	}

	/**
	* @return put return description here..
	* @param param :  parameter passed to function
	* @desc buildSuperFoooter :  put function description here ...
	*/
	function appendSuperFoooter ()
	{
		// Write Function Code Here


	}

	/**
	* @return put return description here..
	* @param param :  parameter passed to function
	* @desc appendToCode :  put function description here ...
	*/
	function appendToCode ($code)
	{
		$newCode = $this->getSourceCode().$code.$this->getLineEnder();;

		$this->setSourceCode($newCode);

	}

	/**
	* @return put return description here..
	* @param param :  parameter passed to function
	* @desc prependToCode :  put function description here ...
	*/
	function prependToCode ($code)
	{
		$newCode = $code.$this->getLineEnder().$this->getSourceCode();

		$this->setSourceCode($newCode);
	}


	function generateGetDataFromDbForOneRowOOnPage()
	{
		$thisTable = $this->getTableObject();

		$code = "";
		$code .= "<?php\n";
		$code .= "\$this".ucfirst($thisTable->getPrimaryKey())." = \$_REQUEST['".$thisTable->getPrimaryKey().NAME_FORM_FIELD_SUFFIX."']\n";
		$code .= "?>\n";

		$thisSqlEngine = new  selectSQLGenerator($thisTable->getTableName(),$thisTable->getDatabase()," * ","","","","","","y");


		$sql = $thisSqlEngine->constructSQL($thisTable);
		$code .= "<?php\n";
		$code .= "\$sql = \"".$sql."\";".$this->getLineEnder();
		$code .= "\$result = MYSQL_QUERY(\$sql);".$this->getLineEnder();
		$code .= "\$numberOfRows = MYSQL_NUMROWS(\$result);\n";

		$code .= "if (\$numberOfRows==0) {  \n?>\n\n";
		$code .= LANG_SIMPLE_INSIDE_SORRY_NO_RECORDS_FOUND."\n\n";
		$code .= "<?php\n}\n";
		$code .= "else if (\$numberOfRows>0) {\n\n";
		$code .= $this->getCodeTab()."\$i=0;\n";

		$code .= $this->generateGetDataFromDbForOneRow();
		$code .= "\n}\n";
		$code .= "?>\n";



		return $code;
	}


	function generateRetreiveFromForm($requestMethod="")
	{
		$code = "";
		$code .= $this->getCodeStarter();
		$code .= $this->getRetreiveFromFormCode($requestMethod);
		$code .= $this->getCodeEnder();

		$this->appendToCode($code);
	}


	function getRetreiveFromFormCode($requestMethod="")
	{
		$code = "";

		if ($requestMethod=="")
		{
			$requestMethod = DEFAULT_RETREIVE_METHOD;
		}

		$thisTable = $this->getTableObject();
		$fieldNameArray = $thisTable->getFieldNameArray();

		$code .= "\t// Retreiving Form Elements from Form\n";

		for ($a=0;$a<count($fieldNameArray);$a++)
		{
			$fieldName = $fieldNameArray[$a];
			$code .= $this->getCodeTab();
			$code .= "\$".NAME_FORM_FIELD_PREFIX.ucfirst($fieldName)." = addslashes(\$_".$requestMethod."['".NAME_FORM_FIELD_PREFIX.ucfirst($fieldName).NAME_FORM_FIELD_SUFFIX."']);".$this->getLineEnder();

		}

		$code .= "\n";

		return $code;

	}



	function generateGetDataFromDbForOneRow()
	{

		$retrieveFromDbMethhodCall = "MYSQL_RESULT";

		$thisTable = $this->getTableObject();
		$fieldNameArray = $thisTable->getFieldNameArray();

		$code = "";

		for ($a=0;$a<count($fieldNameArray);$a++)
		{
			$fieldName = $fieldNameArray[$a];
			$code .= $this->getCodeTab();
			$code .= "\$".NAME_FORM_FIELD_PREFIX.ucfirst($fieldName)." = ".$retrieveFromDbMethhodCall."(\$result,\$i,\"".$fieldName."\");".$this->getLineEnder();

		}



		return $code;
	}

	function generateViewRecordTable()
	{
		$thisTable = $this->getTableObject();

		$code = "";

		$fields = $thisTable->getFieldNameArray();

		$code .= "<table>\n";
		for ($a=0;$a<count($fields);$a++)
		{
			$code .= "<tr height=\"30\">\n";
			$code .= "\t<td align=\"right\"><b>";
			$code .= ucfirst($fields[$a])." : ";
			$code .= "</b></td>\n";
			$code .= "\t<td>";
			$code .= "<? echo \$".NAME_FORM_FIELD_PREFIX.ucfirst($fields[$a])."; ?>";

			$code .= "</td>\n";
			$code .= "</tr>\n";

		}
		$code .="</table>\n";

		return $code;
	}


}


?>
Return current item: PhpCodeGenie