Modified TDataList demo 2 to make it more demonstrative.

1 files changed, 76 insertions, 32 deletions

diff --git a/demos/quickstart/protected/pages/Controls/Samples/TDataList/Sample2.php b/demos/quickstart/protected/pages/Controls/Samples/TDataList/Sample2.php
index ccc87498..cc15e27e 100644
--- a/demos/quickstart/protected/pages/Controls/Samples/TDataList/Sample2.php
+++ b/demos/quickstart/protected/pages/Controls/Samples/TDataList/Sample2.php
@@ -2,33 +2,77 @@
 

 class Sample2 extends TPage

 {

+	private $_data=null;

+

 	protected function getData()

 	{

+		if($this->_data===null)

+			$this->loadData();

+		return $this->_data;

+	}

+

+	protected function loadData()

+	{

 		// We use viewstate keep track of data.

-		// In real applications, data should come from database.

-		if(($data=$this->getViewState('Data',null))===null)

+		// In real applications, data should come from database using an SQL SELECT statement.

+		// In the following tabular data, field 'id' is the primary key.

+		// All update and delete operations should come with an 'id' value in order to go through.

+		if(($this->_data=$this->getViewState('Data',null))===null)

 		{

-			$data=array(

-				array('id'=>'ITN001','name'=>'Motherboard','quantity'=>1,'price'=>100.00),

-				array('id'=>'ITN002','name'=>'CPU','quantity'=>1,'price'=>150.00),

-				array('id'=>'ITN003','name'=>'Harddrive','quantity'=>2,'price'=>80.00),

-				array('id'=>'ITN004','name'=>'Sound card','quantity'=>1,'price'=>40.00),

-				array('id'=>'ITN005','name'=>'Video card','quantity'=>1,'price'=>150.00),

-				array('id'=>'ITN006','name'=>'Keyboard','quantity'=>1,'price'=>20.00),

-				array('id'=>'ITN007','name'=>'Monitor','quantity'=>2,'price'=>300.00),

+			$this->_data=array(

+				array('id'=>'ITN001','name'=>'Motherboard','quantity'=>1,'price'=>100.00,'imported'=>true),

+				array('id'=>'ITN002','name'=>'CPU','quantity'=>1,'price'=>150.00,'imported'=>true),

+				array('id'=>'ITN003','name'=>'Harddrive','quantity'=>2,'price'=>80.00,'imported'=>false),

+				array('id'=>'ITN004','name'=>'Sound card','quantity'=>1,'price'=>40.00,'imported'=>false),

+				array('id'=>'ITN005','name'=>'Video card','quantity'=>1,'price'=>150.00,'imported'=>true),

+				array('id'=>'ITN006','name'=>'Keyboard','quantity'=>1,'price'=>20.00,'imported'=>true),

+				array('id'=>'ITN007','name'=>'Monitor','quantity'=>2,'price'=>300.00,'imported'=>false),

 			);

-			$this->saveData($data);

+			$this->saveData();

+		}

+	}

+

+	protected function saveData()

+	{

+		$this->setViewState('Data',$this->_data);

+	}

+

+	protected function updateProduct($id,$name,$quantity,$price,$imported)

+	{

+		// In real applications, data should be saved to database using an SQL UPDATE statement

+		if($this->_data===null)

+			$this->loadData();

+		$updateRow=null;

+		foreach($this->_data as $index=>$row)

+			if($row['id']===$id)

+				$updateRow=&$this->_data[$index];

+		if($updateRow!==null)

+		{

+			$updateRow['name']=$name;

+			$updateRow['quantity']=TPropertyValue::ensureInteger($quantity);

+			$updateRow['price']=TPropertyValue::ensureFloat($price);

+			$updateRow['imported']=TPropertyValue::ensureBoolean($imported);

+			$this->saveData();

 		}

-		return $data;

 	}

 

-	protected function saveData($data)

+	protected function deleteProduct($id)

 	{

-		// In real applications, data should be saved to database.

-		$this->setViewState('Data',$data);

+		// In real applications, data should be saved to database using an SQL DELETE statement

+		if($this->_data===null)

+			$this->loadData();

+		$deleteIndex=-1;

+		foreach($this->_data as $index=>$row)

+			if($row['id']===$id)

+				$deleteIndex=$index;

+		if($deleteIndex>=0)

+		{

+			unset($this->_data[$deleteIndex]);

+			$this->saveData();

+		}

 	}

 

-	function onLoad($param)

+	public function onLoad($param)

 	{

 		parent::onLoad($param);

 		if(!$this->IsPostBack)

@@ -38,14 +82,15 @@ class Sample2 extends TPage
 		}

 	}

 

-	function editItem($sender,$param)

+	public function editItem($sender,$param)

 	{

+		$this->DataList->SelectedItemIndex=-1;

 		$this->DataList->EditItemIndex=$param->Item->ItemIndex;

 		$this->DataList->DataSource=$this->Data;

 		$this->DataList->dataBind();

 	}

 

-	function cancelItem($sender,$param)

+	public function cancelItem($sender,$param)

 	{

 		$this->DataList->SelectedItemIndex=-1;

 		$this->DataList->EditItemIndex=-1;

@@ -53,33 +98,32 @@ class Sample2 extends TPage
 		$this->DataList->dataBind();

 	}

 

-	function updateItem($sender,$param)

+	public function updateItem($sender,$param)

 	{

 		$item=$param->Item;

-		$data=$this->Data;

-		$product=&$data[$item->ItemIndex];

-		$product['name']=$item->ProductName->Text;

-		$product['price']=TPropertyValue::ensureFloat($item->ProductPrice->Text);

-		$product['quantity']=TPropertyValue::ensureInteger($item->ProductQuantity->Text);

-		$this->saveData($data);

+		$this->updateProduct(

+			$this->DataList->DataKeys[$item->ItemIndex],

+			$item->ProductName->Text,

+			$item->ProductPrice->Text,

+			$item->ProductQuantity->Text,

+			$item->ProductImported->Checked);

 		$this->DataList->EditItemIndex=-1;

-		$this->DataList->DataSource=$data;

+		$this->DataList->DataSource=$this->Data;

 		$this->DataList->dataBind();

 	}

 

-	function deleteItem($sender,$param)

+	public function deleteItem($sender,$param)

 	{

-		$data=$this->Data;

-		array_splice($data,$param->Item->ItemIndex,1);

-		$this->saveData($data);

+		$this->deleteProduct($this->DataList->DataKeys[$param->Item->ItemIndex]);

 		$this->DataList->SelectedItemIndex=-1;

 		$this->DataList->EditItemIndex=-1;

-		$this->DataList->DataSource=$data;

+		$this->DataList->DataSource=$this->Data;

 		$this->DataList->dataBind();

 	}

 

-	function selectItem($sender,$param)

+	public function selectItem($sender,$param)

 	{

+		$this->DataList->EditItemIndex=-1;

 		$this->DataList->DataSource=$this->Data;

 		$this->DataList->dataBind();

 	}