PHP Menu_Ref_sql Examples

Example #1

File: class_menu_ref.php Project: Kloadut/noalyss_ynh

 function verify()
 {
     try {
         parent::verify();
         if ($this->me_code == -1) {
             $this->format_code();
             if ($this->cn->get_value("select count(*) from menu_ref where me_code=\$1", array($this->me_code)) > 0) {
                 throw new Exception('Doublon');
             }
             if (trim($this->me_code) == '') {
                 throw new Exception('Ce menu existe déjà');
             }
         }
         if (!file_exists('../include/' . $this->me_file)) {
             throw new Exception('Ce menu fichier ' . $this->me_file . " n'existe pas");
         }
         return 0;
     } catch (Exception $e) {
         alert($e->getMessage());
         return -1;
     }
 }

Example #2

File: menu.inc.php Project: Kloadut/noalyss_ynh

$table->add(_('Description'), $url, "order by me_description asc", "order by me_description desc", "desa", "desd");
$table->add(_('Type'), $url, "order by me_type asc", "order by me_type desc", "ta", "td");
$table->add(_('Fichier'), $url, "order by me_file asc", "order by me_file desc", "fa", "fd");
$table->add(_('URL'), $url, "order by me_url asc", "order by me_url desc", "urla", "urld");
$table->add(_('Paramètre'), $url, "order by me_parametere asc", "order by me_parameter desc", "paa", "pad");
$table->add(_('Javascript'), $url, "order by me_javascript asc", "order by me_javascript desc", "jsa", "jsd");
$ord = isset($_REQUEST['ord']) ? $_REQUEST['ord'] : 'codea';
$order = $table->get_sql_order($ord);
$iselect = new ISelect('p_type');
$iselect->value = array(array("value" => '', "label" => _("Tout")), array("value" => 'ME', "label" => _("Menu")), array("value" => 'PR', "label" => _("Impression")), array("value" => 'PL', "label" => _("Extension / Plugin")), array("value" => 'SP', "label" => _("Valeurs spéciales")));
$iselect->selected = isset($_REQUEST['p_type']) ? $_REQUEST['p_type'] : '';
$sql = "";
if ($iselect->selected != '') {
    $sql = "where me_type='" . sql_string($_REQUEST['p_type']) . "'  ";
}
$menu = new Menu_Ref_sql($cn);
$ret = $menu->seek($sql . $order);
?>
<fieldset><legend><?php 
echo _('Recherche');
?>
</legend>
<form method="GET">
	<?php 
echo $iselect->input();
?>
	<?php 
echo HtmlInput::submit("search", _("Recherche"));
?>
	<?php 
echo HtmlInput::request_to_hidden(array('ac', 'gDossier', 'ord'));