blob: ebb82a0f6c4b4268344972bc7b8e92ef311cc696 (
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
{
const TABLE='qs_comments';
public $id;
public $username;
public $date_added;
public $page;
public $block_id;
public $content;
public static function finder($className=__CLASS__)
{
return parent::finder($className);
}
}
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><strong>{$username}</strong> on {$record->date_added}.</span>
<div>{$content}</div>
</div>
EOD;
}
}
|
