pradosoft / prado

framework/Data/Common/Oracle/TOracleMetaData.php

Indentation +6 added lines, -6 removed lines

@@ -335,12 +335,12 @@
 		return false;
 	}
 
-        /**
-	 * Returns all table names in the database.
-	 * @param string $schema the schema of the tables. Defaults to empty string, meaning the current or default schema.
-	 * If not empty, the returned table names will be prefixed with the schema name.
-	 * @return array all table names in the database.
-	 */
+		/**
+		 * Returns all table names in the database.
+		 * @param string $schema the schema of the tables. Defaults to empty string, meaning the current or default schema.
+		 * If not empty, the returned table names will be prefixed with the schema name.
+		 * @return array all table names in the database.
+		 */
 	public function findTableNames($schema='')
 	{
 		if($schema==='')

framework/Data/Common/Mssql/TMssqlMetaData.php

Indentation +7 added lines, -7 removed lines

@@ -259,15 +259,15 @@
 		return false;
 	}
 
-        /**
-	 * Returns all table names in the database.
-	 * @param string $schema the schema of the tables. Defaults to empty string, meaning the current or default schema.
-	 * If not empty, the returned table names will be prefixed with the schema name.
-	 * @return array all table names in the database.
-	 */
+		/**
+		 * Returns all table names in the database.
+		 * @param string $schema the schema of the tables. Defaults to empty string, meaning the current or default schema.
+		 * If not empty, the returned table names will be prefixed with the schema name.
+		 * @return array all table names in the database.
+		 */
 	public function findTableNames($schema='dbo')
 	{
-                $condition="TABLE_TYPE='BASE TABLE'";
+				$condition="TABLE_TYPE='BASE TABLE'";
 		$sql=<<<EOD
 SELECT TABLE_NAME, TABLE_SCHEMA FROM [INFORMATION_SCHEMA].[TABLES]
 WHERE TABLE_SCHEMA=:schema AND $condition

framework/Data/Common/Pgsql/TPgsqlMetaData.php

Indentation +6 added lines, -6 removed lines

@@ -417,12 +417,12 @@
 		return false;
 	}
 
-        /**
-	 * Returns all table names in the database.
-	 * @param string $schema the schema of the tables. Defaults to empty string, meaning the current or default schema.
-	 * If not empty, the returned table names will be prefixed with the schema name.
-	 * @return array all table names in the database.
-	 */
+		/**
+		 * Returns all table names in the database.
+		 * @param string $schema the schema of the tables. Defaults to empty string, meaning the current or default schema.
+		 * If not empty, the returned table names will be prefixed with the schema name.
+		 * @return array all table names in the database.
+		 */
 	public function findTableNames($schema='public')
 	{
 		if($schema==='')

framework/Data/Common/Sqlite/TSqliteMetaData.php

Indentation +5 added lines, -5 removed lines

@@ -189,11 +189,11 @@
 		return false;
 	}
 
-        /**
-	 * Returns all table names in the database.
-	 * @param string $schema the schema of the tables. This is not used for sqlite database.
-	 * @return array all table names in the database.
-	 */
+		/**
+		 * Returns all table names in the database.
+		 * @param string $schema the schema of the tables. This is not used for sqlite database.
+		 * @return array all table names in the database.
+		 */
 	public function findTableNames($schema='')
 	{
 		$sql="SELECT DISTINCT tbl_name FROM sqlite_master WHERE tbl_name<>'sqlite_sequence'";

framework/Data/Common/TDbMetaData.php

Indentation +8 added lines, -8 removed lines

@@ -179,14 +179,14 @@
 		return $lft . str_replace(self::$delimiterIdentifier, '', $name) . $rgt;
 	}
 
-        /**
-	 * Returns all table names in the database.
-	 * This method should be overridden by child classes in order to support this feature
-	 * because the default implementation simply throws an exception.
-	 * @param string $schema the schema of the tables. Defaults to empty string, meaning the current or default schema.
-	 * If not empty, the returned table names will be prefixed with the schema name.
-	 * @return array all table names in the database.
-	 */
+		/**
+		 * Returns all table names in the database.
+		 * This method should be overridden by child classes in order to support this feature
+		 * because the default implementation simply throws an exception.
+		 * @param string $schema the schema of the tables. Defaults to empty string, meaning the current or default schema.
+		 * If not empty, the returned table names will be prefixed with the schema name.
+		 * @return array all table names in the database.
+		 */
 	abstract public function findTableNames($schema='');
 }
 

framework/Wsat/TWsatService.php

Indentation +33 added lines, -33 removed lines

@@ -36,46 +36,46 @@
 class TWsatService extends TPageService
 {
 
-        private $_pass = '';
+		private $_pass = '';
 
-        public function init($config)
-        {
-                if ($this->getApplication()->getMode() === TApplicationMode::Performance || $this->getApplication()->getMode() === TApplicationMode::Normal)
-                        throw new TInvalidOperationException("You should not use Prado WSAT in any of the production modes.");
+		public function init($config)
+		{
+				if ($this->getApplication()->getMode() === TApplicationMode::Performance || $this->getApplication()->getMode() === TApplicationMode::Normal)
+						throw new TInvalidOperationException("You should not use Prado WSAT in any of the production modes.");
 
-                if (empty($this->_pass))
-                        throw new TConfigurationException("You need to specify the Password attribute.");
+				if (empty($this->_pass))
+						throw new TConfigurationException("You need to specify the Password attribute.");
 
-                $this->setDefaultPage("TWsatHome");
-                $this->_startThemeManager();
-                parent::init($config);
-        }
+				$this->setDefaultPage("TWsatHome");
+				$this->_startThemeManager();
+				parent::init($config);
+		}
 
-        public function getBasePath()
-        {
-                $basePath = Prado::getPathOfNamespace("System.Wsat.pages");
-                return realpath($basePath);
-        }
+		public function getBasePath()
+		{
+				$basePath = Prado::getPathOfNamespace("System.Wsat.pages");
+				return realpath($basePath);
+		}
 
-        private function _startThemeManager()
-        {
-                $themeManager = new TThemeManager;
-                $themeManager->BasePath = "System.Wsat.themes";
-                $url = Prado::getApplication()->getAssetManager()->publishFilePath(Prado::getPathOfNamespace('System.Wsat'));
-                $themeManager->BaseUrl = "$url/themes";
+		private function _startThemeManager()
+		{
+				$themeManager = new TThemeManager;
+				$themeManager->BasePath = "System.Wsat.themes";
+				$url = Prado::getApplication()->getAssetManager()->publishFilePath(Prado::getPathOfNamespace('System.Wsat'));
+				$themeManager->BaseUrl = "$url/themes";
 
-                $themeManager->init(null);
-                $this->setThemeManager($themeManager);
-        }
+				$themeManager->init(null);
+				$this->setThemeManager($themeManager);
+		}
 
-        public function getPassword()
-        {
-                return $this->_pass;
-        }
+		public function getPassword()
+		{
+				return $this->_pass;
+		}
 
-        public function setPassword($_pass)
-        {
-                $this->_pass = $_pass;
-        }
+		public function setPassword($_pass)
+		{
+				$this->_pass = $_pass;
+		}
 
 }
\ No newline at end of file

framework/Wsat/TWsatScaffoldingGenerator.php

Indentation +124 added lines, -124 removed lines

@@ -14,138 +14,138 @@ 
 class TWsatScaffoldingGenerator extends TWsatBaseGenerator
 {
 
-    /**
-     * Const View Types for generation
-     */
-    const LIST_TYPE = 0;
-    const ADD_TYPE = 1;
-    const SHOW_TYPE = 2;
-
-    /**
-     * Bootstrap option
-     */
-    private $_bootstrap;
-
-    function __construct()
-    {
-        parent::__construct();
-    }
-
-    /**
-     * Generates CRUD Operations for a single DB table
-     * @param type $tableName
-     */
-    public function generateCRUD($tableName)
-    {
-        $this->generate($tableName, self::ADD_TYPE);
-        $this->generate($tableName, self::LIST_TYPE);
-        $this->generate($tableName, self::SHOW_TYPE);
-    }
-
-    //---------------------------------------------------------------------
-    // <editor-fold defaultstate="collapsed" desc="Page Generation">
-    public function generate($tableName, $viewType)
-    {
-        switch ($viewType)
-        {
-            default:
-            case self::LIST_TYPE:
-                $unitName = "list" . ucfirst($tableName);
-                break;
-
-            case self::ADD_TYPE:
-                $unitName = "add" . ucfirst($tableName);
-                break;
-
-            case self::SHOW_TYPE:
-                $unitName = "show" . ucfirst($tableName);
-                break;
-        }
-
-        $class = $this->generateClass($unitName);
-        $outputClass = $this->_opFile . DIRECTORY_SEPARATOR . $unitName . ".php";
-        file_put_contents($outputClass, $class);
-
-        $outputPage = $this->_opFile . DIRECTORY_SEPARATOR . $unitName . ".page";
-        $page = $this->generatePage($tableName, $viewType);
-        file_put_contents($outputPage, $page);
-    }
-
-    private function generatePage($tableName, $type, $tContentId = "Content")
-    {
-        $pageContent = $this->getPageContent($tableName, $type);
-        return <<<EOD
+	/**
+	 * Const View Types for generation
+	 */
+	const LIST_TYPE = 0;
+	const ADD_TYPE = 1;
+	const SHOW_TYPE = 2;
+
+	/**
+	 * Bootstrap option
+	 */
+	private $_bootstrap;
+
+	function __construct()
+	{
+		parent::__construct();
+	}
+
+	/**
+	 * Generates CRUD Operations for a single DB table
+	 * @param type $tableName
+	 */
+	public function generateCRUD($tableName)
+	{
+		$this->generate($tableName, self::ADD_TYPE);
+		$this->generate($tableName, self::LIST_TYPE);
+		$this->generate($tableName, self::SHOW_TYPE);
+	}
+
+	//---------------------------------------------------------------------
+	// <editor-fold defaultstate="collapsed" desc="Page Generation">
+	public function generate($tableName, $viewType)
+	{
+		switch ($viewType)
+		{
+			default:
+			case self::LIST_TYPE:
+				$unitName = "list" . ucfirst($tableName);
+				break;
+
+			case self::ADD_TYPE:
+				$unitName = "add" . ucfirst($tableName);
+				break;
+
+			case self::SHOW_TYPE:
+				$unitName = "show" . ucfirst($tableName);
+				break;
+		}
+
+		$class = $this->generateClass($unitName);
+		$outputClass = $this->_opFile . DIRECTORY_SEPARATOR . $unitName . ".php";
+		file_put_contents($outputClass, $class);
+
+		$outputPage = $this->_opFile . DIRECTORY_SEPARATOR . $unitName . ".page";
+		$page = $this->generatePage($tableName, $viewType);
+		file_put_contents($outputPage, $page);
+	}
+
+	private function generatePage($tableName, $type, $tContentId = "Content")
+	{
+		$pageContent = $this->getPageContent($tableName, $type);
+		return <<<EOD
 <com:TContent ID="$tContentId">   
                      
        $pageContent
                
 </com:TContent>
 EOD;
-    }
-
-    private function getPageContent($tableName, $type)
-    {
-        $code = "";
-        $tableInfo = $this->_dbMetaData->getTableInfo($tableName);
-        switch ($type)
-        {
-            case self::LIST_TYPE:
-                break;
-            case self::ADD_TYPE:
-                foreach ($tableInfo->getColumns() as $colField => $colMetadata)
-                {
-                    if (!$colMetadata->IsPrimaryKey && !$colMetadata->IsForeignKey)
-                    {
-                        $code .= $this->generateControl($colMetadata);
-                        $code .= $this->generateValidators($colMetadata);
-                        $code .= "\n";
-                    }
-                }
-                foreach ($tableInfo->getForeignKeys() as $colField => $colMetadata)
-                {
-                    $colField = $this->eq($colMetadata["table"]);
-                    $code .= "\t<com:TTextBox ID=$colField />\n";
-                    $code .= "\n";
-                    //  TWsatBaseGenerator::pr($tableInfo);
-                }
-                $code .= "\t<com:TButton Text=\"Accept\" />\n";
-
-            case self::SHOW_TYPE:
-                break;
-        }
-        return $code;
-    }
-
-    private function generateControl($colMetadata)
-    {
-        $controlType = "TTextBox";
-        switch ($colMetadata->DbType)
-        {
+	}
+
+	private function getPageContent($tableName, $type)
+	{
+		$code = "";
+		$tableInfo = $this->_dbMetaData->getTableInfo($tableName);
+		switch ($type)
+		{
+			case self::LIST_TYPE:
+				break;
+			case self::ADD_TYPE:
+				foreach ($tableInfo->getColumns() as $colField => $colMetadata)
+				{
+					if (!$colMetadata->IsPrimaryKey && !$colMetadata->IsForeignKey)
+					{
+						$code .= $this->generateControl($colMetadata);
+						$code .= $this->generateValidators($colMetadata);
+						$code .= "\n";
+					}
+				}
+				foreach ($tableInfo->getForeignKeys() as $colField => $colMetadata)
+				{
+					$colField = $this->eq($colMetadata["table"]);
+					$code .= "\t<com:TTextBox ID=$colField />\n";
+					$code .= "\n";
+					//  TWsatBaseGenerator::pr($tableInfo);
+				}
+				$code .= "\t<com:TButton Text=\"Accept\" />\n";
+
+			case self::SHOW_TYPE:
+				break;
+		}
+		return $code;
+	}
+
+	private function generateControl($colMetadata)
+	{
+		$controlType = "TTextBox";
+		switch ($colMetadata->DbType)
+		{
             
-        }
-        $controlId = $colMetadata->ColumnId;
-        return "\t<com:$controlType ID=\"$controlId\" />\n";
-    }
-
-    private function generateValidators($colMetadata)
-    {
-        $controlId = $colMetadata->ColumnId;
-        $code = "";
-        if (!$colMetadata->AllowNull)
-        {
-            $code .= "\t<com:TRequiredFieldValidator ControlToValidate=$controlId ValidationGroup=\"addGroup\" Text=\"Field $controlId is required.\" Display=\"Dynamic\" />\n";
-        }
-        return $code;
-    }
+		}
+		$controlId = $colMetadata->ColumnId;
+		return "\t<com:$controlType ID=\"$controlId\" />\n";
+	}
+
+	private function generateValidators($colMetadata)
+	{
+		$controlId = $colMetadata->ColumnId;
+		$code = "";
+		if (!$colMetadata->AllowNull)
+		{
+			$code .= "\t<com:TRequiredFieldValidator ControlToValidate=$controlId ValidationGroup=\"addGroup\" Text=\"Field $controlId is required.\" Display=\"Dynamic\" />\n";
+		}
+		return $code;
+	}
 
 // </editor-fold>
-    //---------------------------------------------------------------------
-    // <editor-fold defaultstate="collapsed" desc="Code Behind Generation">
-    private function generateClass($classname)
-    {
-        $date = date('Y-m-d h:i:s');
-        $env_user = getenv("username");
-        return <<<EOD
+	//---------------------------------------------------------------------
+	// <editor-fold defaultstate="collapsed" desc="Code Behind Generation">
+	private function generateClass($classname)
+	{
+		$date = date('Y-m-d h:i:s');
+		$env_user = getenv("username");
+		return <<<EOD
 <?php
 /**
  * Auto generated by PRADO - WSAT on $date.
@@ -156,7 +156,7 @@ 
 
 }
 EOD;
-    }
+	}
 
 // </editor-fold>
 }

framework/Wsat/TWsatBaseGenerator.php

Indentation +57 added lines, -57 removed lines

@@ -14,69 +14,69 @@
 class TWsatBaseGenerator
 {
 
-    /**
-     * @return TDbMetaData for retrieving metadata information, such as
-     * table and columns information, from a database connection.
-     */
-    protected $_dbMetaData;
+	/**
+	 * @return TDbMetaData for retrieving metadata information, such as
+	 * table and columns information, from a database connection.
+	 */
+	protected $_dbMetaData;
 
-    /**
-     * Output folder where AR classes will be saved.
-     */
-    protected $_opFile;
+	/**
+	 * Output folder where AR classes will be saved.
+	 */
+	protected $_opFile;
 
-    function __construct()
-    {
-        if (!class_exists("TActiveRecordManager", false))
-            throw new Exception("You need to enable the ActiveRecord module in your application configuration file.");
-        $ar_manager = TActiveRecordManager::getInstance();
-        $_conn = $ar_manager->getDbConnection();
-        $_conn->Active = true;
-        $this->_dbMetaData = TDbMetaData::getInstance($_conn);
-    }
+	function __construct()
+	{
+		if (!class_exists("TActiveRecordManager", false))
+			throw new Exception("You need to enable the ActiveRecord module in your application configuration file.");
+		$ar_manager = TActiveRecordManager::getInstance();
+		$_conn = $ar_manager->getDbConnection();
+		$_conn->Active = true;
+		$this->_dbMetaData = TDbMetaData::getInstance($_conn);
+	}
 
-    public function setOpFile($op_file_namespace)
-    {
-        $op_file = Prado::getPathOfNamespace($op_file_namespace);
-        if (empty($op_file))
-            throw new Exception("You need to fix your output folder namespace.");
-        if (!is_dir($op_file))
-            mkdir($op_file, 0777, true);
-        $this->_opFile = $op_file;
-    }
+	public function setOpFile($op_file_namespace)
+	{
+		$op_file = Prado::getPathOfNamespace($op_file_namespace);
+		if (empty($op_file))
+			throw new Exception("You need to fix your output folder namespace.");
+		if (!is_dir($op_file))
+			mkdir($op_file, 0777, true);
+		$this->_opFile = $op_file;
+	}
 
-    public function renderAllTablesInformation()
-    {
-        foreach ($this->getAllTableNames() as $table_name)
-        {
-            echo $table_name . "<br>";
-            $tableInfo = $this->_dbMetaData->getTableInfo($table_name);
-            echo "Table info:" . "<br>";
-            echo "<pre>";
-            print_r($tableInfo);
-            echo "</pre>";
-        }
-    }
+	public function renderAllTablesInformation()
+	{
+		foreach ($this->getAllTableNames() as $table_name)
+		{
+			echo $table_name . "<br>";
+			$tableInfo = $this->_dbMetaData->getTableInfo($table_name);
+			echo "Table info:" . "<br>";
+			echo "<pre>";
+			print_r($tableInfo);
+			echo "</pre>";
+		}
+	}
 
-    public function getAllTableNames()
-    {
-        $tableNames = $this->_dbMetaData->findTableNames();
-        $index = array_search('pradocache', $tableNames);
-        if ($index)
-            array_splice($tableNames, $index, 1);
-        return $tableNames;
-    }
+	public function getAllTableNames()
+	{
+		$tableNames = $this->_dbMetaData->findTableNames();
+		$index = array_search('pradocache', $tableNames);
+		if ($index)
+			array_splice($tableNames, $index, 1);
+		return $tableNames;
+	}
 
-    public static function pr($data)
-    {
-        echo "<pre>";
-        print_r($data);
-        echo "</pre>";
-    }
+	public static function pr($data)
+	{
+		echo "<pre>";
+		print_r($data);
+		echo "</pre>";
+	}
 
-    protected function eq($data)
-    {
-        return '"' . $data . '"';
-    }
+	protected function eq($data)
+	{
+		return '"' . $data . '"';
+	}
 
 }

framework/Wsat/pages/TWsatScaffolding.php

Indentation +51 added lines, -51 removed lines

@@ -14,59 +14,59 @@
 class TWsatScaffolding extends TPage
 {
 
-        public function onInit($param)
-        {
-                parent::onInit($param);
-                $this->startVisual();
-        }
+		public function onInit($param)
+		{
+				parent::onInit($param);
+				$this->startVisual();
+		}
 
-        private function startVisual()
-        {
-                $scf_generator = new TWsatScaffoldingGenerator();
-                foreach ($scf_generator->getAllTableNames() as $tableName)
-                {
-                        $dynChb = new TCheckBox();
-                        $dynChb->ID = "cb_$tableName";
-                        $dynChb->Text = ucfirst($tableName);
-                        $dynChb->Checked = true;
-                        $this->registerObject("cb_$tableName", $dynChb);
-                        $this->tableNames->getControls()->add($dynChb);
-                        $this->tableNames->getControls()->add("</br>");
-                }
-        }
+		private function startVisual()
+		{
+				$scf_generator = new TWsatScaffoldingGenerator();
+				foreach ($scf_generator->getAllTableNames() as $tableName)
+				{
+						$dynChb = new TCheckBox();
+						$dynChb->ID = "cb_$tableName";
+						$dynChb->Text = ucfirst($tableName);
+						$dynChb->Checked = true;
+						$this->registerObject("cb_$tableName", $dynChb);
+						$this->tableNames->getControls()->add($dynChb);
+						$this->tableNames->getControls()->add("</br>");
+				}
+		}
 
-        /**
-         * Generate Scaffolding code for selected tables
-         * @param type $sender
-         */
-        public function generate($sender)
-        {
-                if ($this->IsValid)
-                {
-                        try
-                        {
-                                $scf_generator = new TWsatScaffoldingGenerator();
-                                $scf_generator->setOpFile($this->output_folder->Text);
-                                foreach ($scf_generator->getAllTableNames() as $tableName)
-                                {
-                                        $id = "cb_$tableName";
-                                        $obj = $this->tableNames->findControl($id);
-                                        if($obj!==null && $obj->Checked)
-                                        {
-                                                $scf_generator->generateCRUD($tableName);
-                                        }
-                                }
+		/**
+		 * Generate Scaffolding code for selected tables
+		 * @param type $sender
+		 */
+		public function generate($sender)
+		{
+				if ($this->IsValid)
+				{
+						try
+						{
+								$scf_generator = new TWsatScaffoldingGenerator();
+								$scf_generator->setOpFile($this->output_folder->Text);
+								foreach ($scf_generator->getAllTableNames() as $tableName)
+								{
+										$id = "cb_$tableName";
+										$obj = $this->tableNames->findControl($id);
+										if($obj!==null && $obj->Checked)
+										{
+												$scf_generator->generateCRUD($tableName);
+										}
+								}
                                 
-                                $this->feedback_panel->CssClass = "green_panel";
-                                $this->generation_msg->Text = "The code has been generated successfully.";
-                        } catch (Exception $ex)
-                        {
-                                $this->feedback_panel->CssClass = "red_panel";
-                                $this->generation_msg->Text = $ex->getMessage();
-                        }
-                        $this->feedback_panel->Visible = true;
-                }
+								$this->feedback_panel->CssClass = "green_panel";
+								$this->generation_msg->Text = "The code has been generated successfully.";
+						} catch (Exception $ex)
+						{
+								$this->feedback_panel->CssClass = "red_panel";
+								$this->generation_msg->Text = $ex->getMessage();
+						}
+						$this->feedback_panel->Visible = true;
+				}
 
-                //   $scf_generator->renderAllTablesInformation();
-        }
+				//   $scf_generator->renderAllTablesInformation();
+		}
 }
\ No newline at end of file