summaryrefslogtreecommitdiff
path: root/demos/quickstart/protected/controls/Comments/CommentBlock.php
blob: 63b25c720477ae199e5988177d444b0751d2bd47 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
<?php

Prado::using('System.Data.*');
Prado::using('System.Web.UI.ActiveControls.*');
Prado::using('System.Data.ActiveRecord.TActiveRecordManager');

$db = new TDbConnection('mysql:host=localhost;dbname=xxxx', 'yyyy', 'zzzz');
$manager = TActiveRecordManager::getInstance();
$manager->setDbConnection($db);

class CommentRecord extends TActiveRecord
{
	public $id;
	public $username;
	public $date_added;
	public $page;
	public $block_id;
	public $content;

	public static $_tablename='qs_comments';

	public static function finder()
	{
		return self::getRecordFinder('CommentRecord');
	}
}

class CommentBlock extends TTemplateControl
{
	private $_page;

	function onLoad($param)
	{
		if(!$this->Page->IsCallBack)
		{
			$count = array();
			$data = $this->getCommentData();
			foreach($data as $r)
			{
				if(!isset($count[$r->block_id]))
					$count[$r->block_id]=0;
				$count[$r->block_id]++;
			}
			$js = "var comment_count = ".TJavascript::encode($count).";\n";
			$this->Page->ClientScript->registerBeginScript('count',$js);
			$this->comments->dataSource = $data;
			$this->comments->dataBind();
		}
	}

	function getCommentData()
	{
		return CommentRecord::finder()->findAllByPage($this->getCurrentPagePath());
	}

	function add_comment($sender, $param)
	{
		if(!$this->Page->IsValid)
			return;
		$record = new CommentRecord;
		$record->username = $this->username->Text;
		$record->date_added = date('Y-m-d h:i:s');
		$record->page = $this->getCurrentPagePath();
		$record->block_id = $this->block_id->Value;
		$record->content = $this->content->Text;
		$record->save();

		$this->content->Text = '';
		$this->password->Text = '';
		$cc = $this->Page->CallbackClient;
		$cc->appendContent('comment-list', $this->format_message($record));
		$cc->callClientFunction('hide_add_comment');
		$cc->callClientFunction('increment_count_tag', $record->block_id);
		if(!$this->Page->IsCallBack)
		{
			$this->comments->dataSource = $this->getCommentData();
			$this->comments->dataBind();
		}
	}

	protected function getCurrentPagePath()
	{
		if(is_null($this->_page))
		{
			$page = str_replace($this->Service->BasePath, '', $this->Page->Template->TemplateFile);
			$this->_page = str_replace('\\', '/', $page);
		}
		return $this->_page;
	}

	function validate_credential($sender, $param)
	{
		$param->IsValid = $this->password->Text == 'Prado';
	}

	protected function format_message($record)
	{
		$username=htmlspecialchars($record->username);
		$content=nl2br(htmlspecialchars($record->content));
		return <<<EOD
	<div class="comment c-{$record->block_id}">
		<span><a href="#">{$username}</a> on {$record->date_added}.</span>
		<div>{$content}</div>
	</div>
EOD;
	}
}