TbExtendedTooltipAction.php

Go to the documentation of this file.

<?php
class TbExtendedTooltipAction extends CAction
{
        public $tooltipTable = 'tbl_tooltip';

        public $connectionID = 'db';

        protected $_db;

        public function run()
        {
                $key = yii::app()->request->getParam('name');
                $tooltip = Yii::app()->request->getParam('value');
                if (!$key || !$tooltip) {
                        throw new CHttpException(404, Yii::t('zii', 'Unauthorized request'));
                }

                if (!$this->getDbConnection()
                        ->createCommand()
                        ->update($this->tooltipTable, array('tooltip' => $tooltip), 'tooltip_key=:key', array(':key' => $key))
                ) {
                        $this->getDbConnection()
                                ->createCommand()
                                ->insert($this->tooltipTable, array('tooltip_key' => $key, 'tooltip' => $tooltip));
                }
        }

        protected function getDbConnection()
        {
                if ($this->_db === null) {
                        $this->_db = Yii::app()->getComponent('db');
                        if (!$this->_db instanceof CDbConnection) {
                                throw new CException(Yii::t(
                                        'zii',
                                        'The "db" application component must be configured to be a CDbConnection object.'
                                ));
                        }
                }
                return $this->_db;
        }
}