Zend FR

--
-- Structure de la table `metas`
--

CREATE TABLE IF NOT EXISTS `metas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `meta` text NOT NULL,
  `meta_type` varchar(50) NOT NULL,
  `controller_action` varchar(50) NOT NULL,
  `id_langue` int(11) NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

// Sauve les paramètres http dans le registre
$frontController = Zend_Controller_Front::getInstance();
$request_http = new Zend_Controller_Request_Http();
$frontController->setRequest($request_http);
$registry->request_http=$request_http;

<?php
class Plugin_Meta extends Zend_Controller_Plugin_Abstract
{
    /*
     * Plugin pour les balises Meta 
     * - Enregistre automatiquement les Metas
     * - Passe à la vue les Metas de la page en cours
     * !!! Effectue cette opération uniquement si le controlleur/action existe
     */
    public function preDispatch() 
    {              
        
        $registry = Zend_Registry::getInstance();
        $request_http = $registry->request_http;
        $session = $registry->session;
           
        // Récupère le nom de l'action et la classe et tente de créer l'objet puis de lui tester sa méthode
        $dispatcher = Zend_Controller_Front::getInstance()->getDispatcher();
        $controllerClass = $dispatcher->getControllerClass($request_http);
        $controllerclassName = $dispatcher->loadClass($controllerClass);
        $action = $dispatcher->getActionMethod($request_http);
        $controllerObject = new ReflectionClass($controllerclassName);
        
        // Si la méthode existe tente d'enregistrer les balises meta
        if($controllerObject->hasMethod($action)){
        
            // Nom de la clé unique -> controller + action
            $controller_action = $request_http->getControllerName().'-'.$request_http->getActionName();
           
            // On vérifie si les métas existent pour la page
            $db = $registry->db;
            $req =     $db->select()
                    ->from(_METAS_,'COUNT(*) as nbre')
                    ->where('controller_action="'.$controller_action.'"');
            $res = $db->fetchAll($req);
            $nbre = $res[0]['nbre'];
               
            // Si les métas n'existent pas on les ajoute
               if($nbre<=0){
                   // Deux boucles (1=francais/2=allemand)
                   for($i=1;$i<=2;$i++){
                       $date = new Zend_Date();
                       $meta = new Model_Meta();
                    $meta = $meta->createRow();
                    $meta->meta = $controller_action;
                    $meta->meta_type = 'title';
                    $meta->controller_action = $controller_action;
                    $meta->id_langue = $i;
                    $meta->date_add = $date->get('YYYY-MM-dd HH:mm:ss');
                    $meta->date_upd = $date->get('YYYY-MM-dd HH:mm:ss');
                    $meta->save();
                    
                    $meta = new Model_Meta();
                    $meta = $meta->createRow();
                    $meta->meta = $controller_action;
                    $meta->meta_type = 'keywords';
                    $meta->controller_action = $controller_action;
                    $meta->id_langue = $i;
                    $meta->date_add = $date->get('YYYY-MM-dd HH:mm:ss');
                    $meta->date_upd = $date->get('YYYY-MM-dd HH:mm:ss');
                    $meta->save();
                    
                    $meta = new Model_Meta();
                    $meta = $meta->createRow();
                    $meta->meta = $controller_action;
                    $meta->meta_type = 'description';
                    $meta->controller_action = $controller_action;
                    $meta->id_langue = $i;
                    $meta->date_add = $date->get('YYYY-MM-dd HH:mm:ss');
                    $meta->date_upd = $date->get('YYYY-MM-dd HH:mm:ss');
                    $meta->save();
                   }
               }    
               
               // On sélectionne les métas pour la page affichée
            // Meta Title
               $req =     $db->select()
                    ->from(_METAS_)
                    ->where('controller_action="'.$controller_action.'" AND meta_type="title" AND id_langue='.$session->id_langue);
            $res = $db->fetchAll($req);
            $meta_title = $res[0]['meta'];
            $view = Zend_Layout::getMvcInstance()->getView('layout');
            $view->meta_title = $meta_title;
            
            // Meta Keywords
               $req =     $db->select()
                    ->from(_METAS_)
                    ->where('controller_action="'.$controller_action.'" AND meta_type="keywords" AND id_langue='.$session->id_langue);
            $res = $db->fetchAll($req);
            $meta_keywords = $res[0]['meta'];
            $view = Zend_Layout::getMvcInstance()->getView('layout');
            $view->meta_keywords = $meta_keywords;
                
            // Meta Description
            $req =     $db->select()
                    ->from(_METAS_)
                    ->where('controller_action="'.$controller_action.'" AND meta_type="description" AND id_langue='.$session->id_langue);
            $res = $db->fetchAll($req);
            $meta_description = $res[0]['meta'];
            $view = Zend_Layout::getMvcInstance()->getView('layout');
            $view->meta_description = $meta_description;
        }
    }  
}