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;

	}

}