45 public $errors = array();
169 $this->menu_handler = $menu_handler;
182 global $conf, $langs;
185 if (!isset($this->enabled)) {
186 $this->enabled =
'1';
188 $this->menu_handler = trim((
string) $this->menu_handler);
189 $this->module = trim((
string) $this->module);
190 $this->
type = trim((
string) $this->
type);
191 $this->mainmenu = trim((
string) $this->mainmenu);
192 $this->leftmenu = trim((
string) $this->leftmenu);
193 $this->fk_menu = (int) $this->fk_menu;
194 $this->fk_mainmenu = trim((
string) $this->fk_mainmenu);
195 $this->fk_leftmenu = trim((
string) $this->fk_leftmenu);
197 $this->url = trim((
string) $this->url);
198 $this->target = trim((
string) $this->target);
199 $this->title = trim((
string) $this->title);
200 $this->langs = trim((
string) $this->langs);
201 $this->perms = trim((
string) $this->perms);
202 $this->enabled = trim((
string) $this->enabled);
212 if (empty($this->menu_handler)) {
219 if (in_array($this->
db->type, array(
'pgsql'))) {
220 $sql =
"SELECT MAX(rowid) as maxrowid FROM ".$this->db->prefix().
"menu";
221 $resqlrowid = $this->
db->query(
$sql);
223 $obj = $this->
db->fetch_object($resqlrowid);
224 $maxrowid = $obj->maxrowid;
227 if (empty($maxrowid)) {
231 $sql =
"SELECT setval('".$this->db->prefix().
"menu_rowid_seq', ".($maxrowid).
")";
233 $resqlrowidset = $this->
db->query(
$sql);
234 if (!$resqlrowidset) {
243 $sql =
"SELECT count(*)";
244 $sql .=
" FROM ".$this->db->prefix().
"menu";
245 $sql .=
" WHERE menu_handler = '".$this->db->escape($this->menu_handler).
"'";
246 $sql .=
" AND fk_menu = ".((int) $this->fk_menu);
248 $sql .=
" AND url = '".$this->db->escape($this->url).
"'";
249 $sql .=
" AND entity = ".$conf->entity;
251 $result = $this->
db->query(
$sql);
253 $row = $this->
db->fetch_row($result);
257 $sql =
"INSERT INTO ".$this->db->prefix().
"menu(";
258 $sql .=
"menu_handler,";
265 $sql .=
"fk_mainmenu,";
266 $sql .=
"fk_leftmenu,";
276 $sql .=
") VALUES (";
277 $sql .=
" '".$this->db->escape($this->menu_handler).
"',";
278 $sql .=
" '".$this->db->escape($conf->entity).
"',";
279 $sql .=
" '".$this->db->escape($this->module).
"',";
280 $sql .=
" '".$this->db->escape($this->type).
"',";
281 $sql .=
" ".($this->mainmenu ?
"'".$this->db->escape($this->mainmenu).
"'" :
"''").
",";
282 $sql .=
" ".($this->leftmenu ?
"'".$this->db->escape($this->leftmenu).
"'" :
"null").
",";
283 $sql .=
" ".((int) $this->fk_menu).
",";
284 $sql .=
" ".($this->fk_mainmenu ?
"'".$this->db->escape($this->fk_mainmenu).
"'" :
"null").
",";
285 $sql .=
" ".($this->fk_leftmenu ?
"'".$this->db->escape($this->fk_leftmenu).
"'" :
"null").
",";
287 $sql .=
" '".$this->db->escape($this->url).
"',";
288 $sql .=
" '".$this->db->escape($this->target).
"',";
289 $sql .=
" '".$this->db->escape($this->title).
"',";
290 $sql .=
" '".$this->db->escape($this->prefix).
"',";
291 $sql .=
" '".$this->db->escape($this->langs).
"',";
292 $sql .=
" '".$this->db->escape($this->perms).
"',";
293 $sql .=
" '".$this->db->escape($this->enabled).
"',";
294 $sql .=
" '".$this->db->escape($this->
user).
"'";
297 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
298 $resql = $this->
db->query(
$sql);
300 $this->
id = $this->
db->last_insert_id($this->
db->prefix().
"menu");
301 dol_syslog(get_class($this).
"::create record added has rowid=".((
int) $this->
id), LOG_DEBUG);
305 $this->error =
"Error ".$this->db->lasterror();
309 dol_syslog(get_class($this).
"::create menu entry already exists", LOG_WARNING);
310 $this->error =
'Error Menu entry already exists';
325 public function update($user =
null, $notrigger = 0)
331 $this->menu_handler = trim($this->menu_handler);
332 $this->module = trim($this->module);
334 $this->mainmenu = trim($this->mainmenu);
335 $this->leftmenu = trim($this->leftmenu);
336 $this->fk_menu = (int) $this->fk_menu;
337 $this->fk_mainmenu = trim($this->fk_mainmenu);
338 $this->fk_leftmenu = trim($this->fk_leftmenu);
340 $this->url = trim($this->url);
341 $this->target = trim($this->target);
342 $this->title = trim($this->title);
343 $this->prefix = trim($this->prefix);
344 $this->langs = trim($this->langs);
345 $this->perms = trim($this->perms);
346 $this->enabled = trim($this->enabled);
353 $sql =
"UPDATE ".$this->db->prefix().
"menu SET";
354 $sql .=
" menu_handler='".$this->db->escape($this->menu_handler).
"',";
355 $sql .=
" module='".$this->db->escape($this->module).
"',";
356 $sql .=
" type='".$this->db->escape($this->
type).
"',";
357 $sql .=
" mainmenu='".$this->db->escape($this->mainmenu).
"',";
358 $sql .=
" leftmenu='".$this->db->escape($this->leftmenu).
"',";
359 $sql .=
" fk_menu=".((int) $this->fk_menu).
",";
360 $sql .=
" fk_mainmenu=".($this->fk_mainmenu ?
"'".$this->db->escape($this->fk_mainmenu).
"'" :
"null").
",";
361 $sql .=
" fk_leftmenu=".($this->fk_leftmenu ?
"'".$this->db->escape($this->fk_leftmenu).
"'" :
"null").
",";
362 $sql .=
" position=".($this->position > 0 ? ((int) $this->
position) : 0).
",";
363 $sql .=
" url='".$this->db->escape($this->url).
"',";
364 $sql .=
" target='".$this->db->escape($this->target).
"',";
365 $sql .=
" titre='".$this->db->escape($this->title).
"',";
366 $sql .=
" prefix='".$this->db->escape($this->prefix).
"',";
367 $sql .=
" langs='".$this->db->escape($this->langs).
"',";
368 $sql .=
" perms='".$this->db->escape($this->perms).
"',";
369 $sql .=
" enabled='".$this->db->escape($this->enabled).
"',";
370 $sql .=
" usertype='".$this->db->escape($this->
user).
"'";
371 $sql .=
" WHERE rowid=".((int) $this->
id);
373 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
374 $resql = $this->
db->query(
$sql);
376 $this->error =
"Error ".$this->db->lasterror();
391 public function fetch($id, $user =
null)
397 $sql .=
" t.menu_handler,";
398 $sql .=
" t.entity,";
399 $sql .=
" t.module,";
401 $sql .=
" t.mainmenu,";
402 $sql .=
" t.leftmenu,";
403 $sql .=
" t.fk_menu,";
404 $sql .=
" t.fk_mainmenu,";
405 $sql .=
" t.fk_leftmenu,";
406 $sql .=
" t.position,";
408 $sql .=
" t.target,";
409 $sql .=
" t.titre as title,";
410 $sql .=
" t.prefix,";
413 $sql .=
" t.enabled,";
414 $sql .=
" t.usertype as user,";
416 $sql .=
" FROM ".$this->db->prefix().
"menu as t";
417 $sql .=
" WHERE t.rowid = ".((int) $id);
419 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
420 $resql = $this->
db->query(
$sql);
422 if ($this->
db->num_rows($resql)) {
423 $obj = $this->
db->fetch_object($resql);
425 $this->
id = $obj->rowid;
427 $this->menu_handler = $obj->menu_handler;
428 $this->entity = $obj->entity;
429 $this->module = $obj->module;
430 $this->
type = $obj->type;
431 $this->mainmenu = $obj->mainmenu;
432 $this->leftmenu = $obj->leftmenu;
433 $this->fk_menu = $obj->fk_menu;
434 $this->fk_mainmenu = $obj->fk_mainmenu;
435 $this->fk_leftmenu = $obj->fk_leftmenu;
437 $this->url = $obj->url;
438 $this->target = $obj->target;
439 $this->title = $obj->title;
440 $this->prefix = $obj->prefix;
441 $this->langs = $obj->langs;
442 $this->perms = $obj->perms;
443 $this->enabled = str_replace(
"\"",
"'", $obj->enabled);
444 $this->
user = $obj->user;
445 $this->tms = $this->
db->jdate($obj->tms);
447 $this->
db->free($resql);
451 $this->error =
"Error ".$this->db->lasterror();
463 public function delete($user)
467 $sql =
"DELETE FROM ".$this->db->prefix().
"menu";
468 $sql .=
" WHERE rowid=".((int) $this->
id);
470 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
471 $resql = $this->
db->query(
$sql);
473 $this->error =
"Error ".$this->db->lasterror();
492 $this->menu_handler =
'all';
493 $this->module =
'specimen';
495 $this->mainmenu =
'';
496 $this->fk_menu =
'0';
498 $this->url =
'http://dummy';
500 $this->title =
'Specimen menu';
502 $this->leftmenu =
'';
520 public function menuTopCharger($mymainmenu, $myleftmenu, $type_user, $menu_handler, &$tabMenu)
522 global $langs, $user, $conf;
523 global $mainmenu, $leftmenu;
525 $mainmenu = $mymainmenu;
526 $leftmenu = $myleftmenu;
528 $newTabMenu = array();
529 foreach ($tabMenu as $val) {
530 if ($val[
'type'] ==
'top') {
531 $newTabMenu[] = $val;
550 public function menuLeftCharger($newmenu, $mymainmenu, $myleftmenu, $type_user, $menu_handler, &$tabMenu)
552 global $langs, $user, $conf;
553 global $mainmenu, $leftmenu;
555 $mainmenu = $mymainmenu;
556 $leftmenu = $myleftmenu;
560 foreach ($tabMenu as $key => $val) {
562 if (empty($menutopid) && $val[
'type'] ==
'top' && $val[
'mainmenu'] == $mainmenu) {
563 $menutopid = $val[
'rowid'];
569 $this->newmenu = $newmenu;
572 $this->
recur($tabMenu, $menutopid, 1);
575 foreach ($tabMenu as $key => $val) {
576 if ($val[
'fk_menu'] == -1 && $val[
'fk_mainmenu'] == $mainmenu) {
580 if (empty($val[
'fk_leftmenu'])) {
581 $this->newmenu->add($val[
'url'], $val[
'titre'], 0, $val[
'perms'], $val[
'target'], $val[
'mainmenu'], $val[
'leftmenu'], $val[
'position'],
'',
'',
'', $val[
'prefix']);
589 foreach ($this->newmenu->liste as $keyparent => $valparent) {
591 if ($searchlastsub) {
592 if ($valparent[
'level'] >= $searchlastsub) {
593 $lastid = $keyparent;
595 if ($valparent[
'level'] < $searchlastsub) {
596 $nextid = $keyparent;
600 if ($valparent[
'mainmenu'] == $val[
'fk_mainmenu'] && $valparent[
'leftmenu'] == $val[
'fk_leftmenu']) {
603 $searchlastsub = ($valparent[
'level'] + 1);
604 $lastid = $keyparent;
610 $this->newmenu->insert($lastid, $val[
'url'], $val[
'titre'], $searchlastsub, $val[
'perms'], $val[
'target'], $val[
'mainmenu'], $val[
'leftmenu'], $val[
'position'],
'',
'',
'', $val[
'prefix']);
612 dol_syslog(
"Error. Modules ".$val[
'module'].
" has defined a menu entry with a parent='fk_mainmenu=".$val[
'fk_leftmenu'].
",fk_leftmenu=".$val[
'fk_leftmenu'].
"' and position=".$val[
'position'].
'. The parent was not found. May be you forget it into your definition of menu, or may be the parent has a "position" that is after the child (fix field "position" of parent or child in this case).', LOG_WARNING);
619 return $this->newmenu;
633 public function menuLoad($mymainmenu, $myleftmenu, $type_user, $menu_handler, &$tabMenu)
635 global $langs, $user, $conf;
636 global $mainmenu, $leftmenu;
638 $mainmenu = $mymainmenu;
639 $leftmenu = $myleftmenu;
641 $sql =
"SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position";
642 $sql .=
" FROM ".$this->db->prefix().
"menu as m";
643 $sql .=
" WHERE m.entity IN (0,".$conf->entity.
")";
644 $sql .=
" AND m.menu_handler IN ('".$this->db->escape($menu_handler).
"','all')";
645 if ($type_user == 0) {
646 $sql .=
" AND m.usertype IN (0,2)";
648 if ($type_user == 1) {
649 $sql .=
" AND m.usertype IN (1,2)";
651 $sql .=
" ORDER BY m.position, m.rowid";
655 $resql = $this->
db->query(
$sql);
657 $numa = $this->
db->num_rows($resql);
663 $menu = $this->
db->fetch_array($resql);
667 if (isset($menu[
'perms'])) {
668 $tmpcond = $menu[
'perms'];
669 if ($leftmenu ==
'all') {
670 $tmpcond = preg_replace(
'/\$leftmenu\s*==\s*["\'a-zA-Z_]+/',
'1==1', $tmpcond);
678 if (isset($menu[
'enabled'])) {
679 $tmpcond = $menu[
'enabled'];
680 if ($leftmenu ==
'all') {
681 $tmpcond = preg_replace(
'/\$leftmenu\s*==\s*["\'a-zA-Z_]+/',
'1==1', $tmpcond);
688 $title = $langs->trans($menu[
'titre']);
690 if ($title == $menu[
'titre']) {
691 if (!empty($menu[
'langs'])) {
693 $langs->load($menu[
'langs']);
696 $substitarray = array(
'__LOGIN__' => $user->login,
'__USER_ID__' => $user->id,
'__USER_SUPERVISOR_ID__' => $user->fk_user);
699 if (preg_match(
"/\//", $menu[
'titre'])) {
700 $tab_titre = explode(
"/", $menu[
'titre']);
701 $title = $langs->trans($tab_titre[0]).
"/".$langs->trans($tab_titre[1]);
702 } elseif (preg_match(
'/\|\|/', $menu[
'titre'])) {
704 $tab_title = explode(
"||", $menu[
'titre']);
705 $alt_title = explode(
"@", $tab_title[1]);
706 $title_enabled =
verifCond($alt_title[1]);
707 $title = ($title_enabled ? $langs->trans($alt_title[0]) : $langs->trans($tab_title[0]));
709 $title = $langs->trans($menu[
'titre']);
716 $tabMenu[$b][
'rowid'] = $menu[
'rowid'];
717 $tabMenu[$b][
'module'] = $menu[
'module'];
718 $tabMenu[$b][
'fk_menu'] = $menu[
'fk_menu'];
719 $tabMenu[$b][
'url'] = $menu[
'url'];
720 if (!preg_match(
"/^(http:\/\/|https:\/\/)/i", $tabMenu[$b][
'url'])) {
721 if (preg_match(
'/\?/', $tabMenu[$b][
'url'])) {
722 $tabMenu[$b][
'url'] .=
'&idmenu='.$menu[
'rowid'];
724 $tabMenu[$b][
'url'] .=
'?idmenu='.$menu[
'rowid'];
727 $tabMenu[$b][
'titre'] = $title;
728 $tabMenu[$b][
'prefix'] = $menu[
'prefix'];
729 $tabMenu[$b][
'target'] = $menu[
'target'];
730 $tabMenu[$b][
'mainmenu'] = $menu[
'mainmenu'];
731 $tabMenu[$b][
'leftmenu'] = $menu[
'leftmenu'];
732 $tabMenu[$b][
'perms'] = $perms;
733 $tabMenu[$b][
'langs'] = $menu[
'langs'];
734 $tabMenu[$b][
'enabled'] = $enabled;
735 $tabMenu[$b][
'type'] = $menu[
'type'];
736 $tabMenu[$b][
'fk_mainmenu'] = $menu[
'fk_mainmenu'];
737 $tabMenu[$b][
'fk_leftmenu'] = $menu[
'fk_leftmenu'];
738 $tabMenu[$b][
'position'] = (int) $menu[
'position'];
745 $this->
db->free($resql);
766 private function recur($tab, $pere, $level)
770 for ($x = 0; $x < $num; $x++) {
772 if ((($tab[$x][
'fk_menu'] >= 0 && $tab[$x][
'fk_menu'] == $pere)) && $tab[$x][
'enabled']) {
773 $this->newmenu->add($tab[$x][
'url'], $tab[$x][
'titre'], ($level - 1), $tab[$x][
'perms'], $tab[$x][
'target'], $tab[$x][
'mainmenu'], $tab[$x][
'leftmenu'], 0,
'',
'',
'', $tab[$x][
'prefix']);
774 $this->
recur($tab, $tab[$x][
'rowid'], ($level + 1));