Location: PHPKode > projects > PhpCodeGenie > phpCodeGenie3.0.2/app/generators/php/plugins/genieDbFrameworkGenerator/appComponentGenerator/genieDAODeleteGenerator.plugin.class.php
<? 
include_once("genieConfiguration.inc.php");
include_once(CLASS_TABLE);
include_once(CLASS_COMMON_GENIE_FRAMEWORK);
?>
<?
class genieDAODeleteGenerator extends commonGenieFramework
{


	/**
	* @return put return description here..
	* @param param :  parameter passed to function
	* @desc genieDAOInsertGenerator :  put function description here ...
	*/
	function genieDAODeleteGenerator ($arguments)
	{

		$db = $arguments['db'];
		$table = $arguments['table'];

		$thisTable = new table($table,$db);
		$this->setTableObject($thisTable);


		$this->initializeGenieFramework();

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


		$this->generateDeleteDao();



		return $this->getSourceCode();


	}

	function generateDeleteDao() {


		/*
		$returnComment = "returns true if delete if successful or false if failure ";
		$paramComment = "a populated instance of object - (".$this->getClassName().")";
		$descComment = "Delete database table row from parameters of (".$this->getInfoName().") object ";
		$comments = $this->getComments($returnComment,$paramComment,$descComment);

		$code .= $comments;

		$keys = $this->getVariableArrayKeys();

		$code .= "function delete".ucfirst($this->getTable())."(\$this".ucfirst($this->getInfoName()).") \n";
		$code .= "{ \n\n";




		$code .= "      \$this".ucfirst($this->getInfoName())."->setDeleted(TRUE_PARM);\n";
		$code .= "      return \$this->update".ucfirst($this->getTable())."(\$this".ucfirst($this->getInfoName()).");\n\n";
		$code .= "   \n\n";
		$code .= "} \n\n";
		return $code;

		*/

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


		$returnComment = "returns true if delete if successful or false if failure ";
		$paramComment = "A collection of searchItems of fields on".$this->getInfoName().")";
		$descComment = "Delete database table row from parameters of (".$this->getInfoName().") object ";
		$comments = $this->getComments($returnComment,$paramComment,$descComment);


		$code = "";
		$code .= $comments;

		$primaryKey = $thisTable->getPrimaryKey();

		if (GENERATE_FOR_PHP5)
		{
			//$code .= "protected ";
		}

		$code .= "function delete".ucfirst($this->getTableName())."(";
		
		// Generating Object Type passed for php5
		if (GENERATE_FOR_PHP5)
		{
			$code .= $this->getInfoName()." ";
		}
		
		
		$code .= "\$this".ucfirst($this->getInfoName()).",\$thisSearchItems=\"\")\n";
		$code .= "{ \n\n";

		// Build SQL Query code only if more than 1 field present
		if (count($fieldNameArray)>0)
		{

			$code .= "   // Building SQL Statement for Deleting  ".ucfirst($this->getInfoName())." \n";
			$code .= "   \$sql = \"\"; \n";
			$code .= "   \$sql .= \"DELETE FROM \".TABLE_".strtoupper($this->getTableName())."; \n";
			$code .= "   \$sql .= \" WHERE \";\n";
			$code .= "   \$sql .= FIELD_".strtoupper($this->getTableName())."_".strtoupper($primaryKey).".\" = '\".\$this".ucfirst($this->getInfoName())."->get".ucfirst($primaryKey)."().\"' \"; \n";

			$code .= "\n\n";




			$code .= "         // Executing Query \n";
			$code .= "         \$thisDatabaseQuery = new databaseQuery(); \n";
			$code .= "         \$thisDatabaseQuery->setSqlQuery(\$sql); \n";
			$code .= "         \$result = \$thisDatabaseQuery->executeQuery(); \n\n";

			$code .= "         // Query could not execute. There was an error \n";
			$code .= "         if (\$result == false) { \n";

			$code .= "                 // if Error occured in Application, handle error. \n";
			$code .= "                 \$thisError = new errorHandler();\n";
			$code .= "                 \$thisError->setUserErrorMessage(\"A fatal error has occured while this application was trying to do some operation on the database.\");\n";
			$code .= "                 \$thisError->setProgramErrorMessage(\"Error Occured when trying to do delete on ".ucfirst($this->getTableName())." SQL Query : \".\$sql);\n";
			$code .= "                 \$thisError->setErrorPage(\$_SERVER['PHP_SELF']);\n";
			$code .= "                 //overiding application settings and quiting program on this error \n";
			$code .= "                 \$thisError->setQuitProgram(true);\n";
			$code .= "                 \$thisError->handleError();\n";
			$code .= "                 return false; \n";


			$code .= "         }\n";
			$code .= "         // Query Execution was successful\n";
			$code .= "         else \n";
			$code .= "         {\n";
			$code .= "                 return true; \n";
			$code .= "         } \n\n";

		} // end of fieldCount > 1

		$code .= "   \n\n";

		$code .= "} \n\n";

		$this->appendToCode($code);
	}


}

?>
Return current item: PhpCodeGenie