Subversion-Projekte lars-tiefland.prado

<?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;
        }
}