From 7fa1200b5e589a47884aa4d62630ce9099fccee1 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Tue, 30 Jan 2007 11:36:13 +0000
Subject: Add basic Scaffold view for Active Record

---
 .../Scaffold/InputBuilder/TSqliteScaffoldInput.php | 93 ++++++++++++++++++++++
 1 file changed, 93 insertions(+)
 create mode 100644 framework/Data/ActiveRecord/Scaffold/InputBuilder/TSqliteScaffoldInput.php

(limited to 'framework/Data/ActiveRecord/Scaffold/InputBuilder/TSqliteScaffoldInput.php')

diff --git a/framework/Data/ActiveRecord/Scaffold/InputBuilder/TSqliteScaffoldInput.php b/framework/Data/ActiveRecord/Scaffold/InputBuilder/TSqliteScaffoldInput.php
new file mode 100644
index 00000000..b26d44fd
--- /dev/null
+++ b/framework/Data/ActiveRecord/Scaffold/InputBuilder/TSqliteScaffoldInput.php
@@ -0,0 +1,93 @@
+<?php
+
+Prado::using('System.Data.ActiveRecord.Scaffold.InputBuilder.TScaffoldInputCommon');
+
+class TSqliteScaffoldInput extends TScaffoldInputCommon
+{
+	protected function createControl($container, $column, $record)
+	{
+		switch(strtolower($column->getType()))
+		{
+			case 'boolean':
+				return $this->createBooleanControl($container, $column, $record);
+			case 'date':
+				return $this->createDateControl($container, $column, $record);
+			case 'blob': case 'tinyblob': case 'mediumblob': case 'longblob':
+			case 'text': case 'tinytext': case 'mediumtext': case 'longtext':
+				return $this->createMultiLineControl($container, $column, $record);
+			case 'year':
+				return $this->createYearControl($container, $column, $record);
+			case 'int': case 'integer': case 'tinyint': case 'smallint': case 'mediumint': case 'bigint':
+				return $this->createIntegerControl($container, $column, $record);
+			case 'decimal': case 'double': case 'float':
+				return $this->createFloatControl($container, $column, $record);
+			case 'time' :
+				return $this->createTimeControl($container, $column, $record);
+			case 'datetime': case 'timestamp':
+				return $this->createDateTimeControl($container, $column, $record);
+			default:
+				return $this->createDefaultControl($container,$column, $record);
+		}
+	}
+
+	protected function getControlValue($container, $column, $record)
+	{
+		switch(strtolower($column->getType()))
+		{
+			case 'boolean':
+				return $container->findControl(self::DEFAULT_ID)->getChecked();
+			case 'date':
+				return $container->findControl(self::DEFAULT_ID)->getDate();
+			case 'year':
+				return $container->findControl(self::DEFAULT_ID)->getSelectedValue();
+			case 'time':
+				return $this->getTimeValue($container, $column, $record);
+			case 'datetime': case 'timestamp':
+				return $this->getDateTimeValue($container,$column, $record);
+			default:
+				return $this->getDefaultControlValue($container,$column, $record);
+		}
+	}
+
+	protected function createDateControl($container, $column, $record)
+	{
+		$control = parent::createDateControl($container, $column, $record);
+		$value = $this->getRecordPropertyValue($column, $record);
+		if(!empty($value) && preg_match('/timestamp/i', $column->getType()))
+			$control->setTimestamp(intval($value));
+		return $control;
+	}
+
+	protected function createDateTimeControl($container, $column, $record)
+	{
+		$value = $this->getRecordPropertyValue($column, $record);
+		$time = parent::createDateTimeControl($container, $column, $record);
+		if(!empty($value) && preg_match('/timestamp/i', $column->getType()))
+		{
+			$s = Prado::createComponent('System.Util.TDateTimeStamp');
+			$date = $s->getDate(intval($value));
+			$time[1]->setSelectedValue($date['hours']);
+			$time[2]->setSelectedValue($date['minutes']);
+			$time[3]->setSelectedValue($date['seconds']);
+		}
+		return $time;
+	}
+
+	protected function getDateTimeValue($container, $column, $record)
+	{
+		if(preg_match('/timestamp/i', $column->getType()))
+		{
+			$time = $container->findControl(self::DEFAULT_ID)->getTimestamp();
+			$s = Prado::createComponent('System.Util.TDateTimeStamp');
+			$date = $s->getDate($time);
+			$hour = $container->findControl('scaffold_time_hour')->getSelectedValue();
+			$mins = $container->findControl('scaffold_time_min')->getSelectedValue();
+			$secs = $container->findControl('scaffold_time_sec')->getSelectedValue();
+			return $s->getTimeStamp($hour,$mins,$secs,$date['mon'],$date['mday'],$date['year']);
+		}
+		else
+			return parent::getDateTimeValue($container, $column, $record);
+	}
+}
+
+?>
\ No newline at end of file
-- 
cgit v1.2.3