Ejemplo n.º 1
0
function get_analysis($pid, $depth)
{
    $q = "\n\t\t\tselect\t\tA.id\n\t\t\t,\t\t\tA.pid\n\t\t\t,\t\t\tA.name\n\t\t\t,\t\t\tA.name\t\tas label\n\t\t\t,\t\t\tA.base\n\t\t\t,\t\t\tA.var_independent\n\t\t\t,\t\t\tA.var_dependent\n\t\t\t,\t\t\tA.var_intervening\n\t\t\t,\t\t\tA.var_mediation\n\t\t\t,\t\t\tA.var_moderation\n\t\t\t,\t\t\tA.channel\n\t\t\t,\t\t\tA.phase\n\t\t\t,\t\t\tA.segmentation\n\t\t\t,\t\t\tA.attribute\n\t\t\t,\t\t\tA.hierarchy\n\t\t\tfrom\t\tanalysis_price\tA\n\t\t\twhere\t\tA.pid\t\t\t= {$pid}\n\t\t\torder by\tA.id\n\t\t";
    $rs = Jaring::db_execute($q, null, true);
    $index = 0;
    foreach ($rs as &$m) {
        $id = $m["id"];
        if ($index === 0) {
            $m["isFirst"] = true;
        } else {
            $m["isFirst"] = false;
        }
        $m["iconCls"] = "group";
        $m["index"] = $index++;
        $m["depth"] = $depth;
        $c = get_analysis($id, $depth + 1);
        if (count($c) <= 0) {
            $m["leaf"] = true;
        } else {
            $m["children"] = $c;
            $m["expandable"] = true;
            $m["expanded"] = true;
            $m["loaded"] = true;
        }
    }
    return $rs;
}
Ejemplo n.º 2
0
function get_analysis($pid, $depth)
{
    $q = "\n\t\t\tselect\t\tA.id\n\t\t\t,\t\t\tA.pid\n\t\t\t,\t\t\tA.name\n\t\t\t,\t\t\tA.name\t\tas text\n\t\t\tfrom\t\tanalysis_price\tA\n\t\t\twhere\t\tA.pid\t\t\t= {$pid}\n\t\t\torder by\tA.id\n\t\t";
    $rs = Jaring::db_execute($q, null, true);
    $index = 0;
    foreach ($rs as &$m) {
        $id = $m["id"];
        if ($index === 0) {
            $m["isFirst"] = true;
        } else {
            $m["isFirst"] = false;
        }
        $m["iconCls"] = "";
        $m["index"] = $index++;
        $m["depth"] = $depth;
        $c = get_analysis($id, $depth + 1);
        if (count($c) <= 0) {
            $m["leaf"] = true;
        } else {
            $m["children"] = $c;
            $m["expandable"] = true;
            $m["expanded"] = true;
            $m["loaded"] = true;
        }
    }
    return $rs;
}
Ejemplo n.º 3
0
function show_bulletinage_info($bul_id, $lien_cart_ajout = 1, $lien_cart_suppr = 0, $flag_pointe = 0, $lien_pointe = 0)
{
    global $dbh, $msg, $charset;
    global $base_path;
    global $liste_script;
    global $liste_debut;
    global $liste_fin;
    global $bul_action_bar;
    global $bul_cb_form;
    global $selector_prop;
    global $url_base_suppr_cart;
    global $page, $nbr_lignes, $nb_per_page;
    global $idcaddie;
    $cart_click_bull = "onClick=\"openPopUp('./cart.php?object_type=BULL&item=!!item!!', 'cart', 600, 700, -2, -2, '{$selector_prop}')\"";
    //Calcul des variables pour la suppression d'items
    if ($nb_per_page) {
        $modulo = $nbr_lignes % $nb_per_page;
        if ($modulo == 1) {
            $page_suppr = !$page ? 1 : $page - 1;
        } else {
            $page_suppr = $page;
        }
        $nb_after_suppr = $nbr_lignes ? $nbr_lignes - 1 : 0;
    }
    $affichage_final = '';
    if ($bul_id) {
        if (SESSrights & CATALOGAGE_AUTH) {
            $myBul = new bulletinage($bul_id, 0, "./catalog.php?categ=serials&sub=bulletinage&action=explnum_form&bul_id={$bul_id}&explnum_id=!!explnum_id!!");
            // lien vers la notice chapeau
            $link_parent = "<a href=\"./catalog.php?categ=serials\">" . $msg[4010] . "</a>";
            $link_parent .= "<img src=\"./images/d.gif\" align=\"middle\" hspace=\"5\">";
            $link_parent .= "<a href=\"./catalog.php?categ=serials&sub=view&serial_id=";
            $link_parent .= $myBul->bulletin_notice . "\">" . $myBul->tit1 . '</a>';
            $link_parent .= "<img src=\"./images/d.gif\" align=\"middle\" hspace=\"5\">";
            if ($myBul->bulletin_numero) {
                $link_bulletin = $myBul->bulletin_numero . " ";
            }
            // affichage de la mention de date utile : mention_date si existe, sinon date_date
            $date_affichee = '';
            if ($myBul->mention_date) {
                $date_affichee = " (" . $myBul->mention_date . ")";
            } else {
                if ($myBul->date_date) {
                    $date_affichee = " [" . formatdate($myBul->date_date) . "]";
                }
            }
            $link_bulletin .= $date_affichee;
            $link_parent .= "<a href='./catalog.php?categ=serials&sub=bulletinage&action=view&bul_id={$bul_id}'>{$link_bulletin}</a>";
            $affichage_final .= "<div class='row'><div class='perio-barre'>" . $link_parent . "</div></div>";
            if ($lien_cart_ajout) {
                $cart_link = "<img src='./images/basket_small_20x20.gif' align='middle' alt='basket' title=\"{$msg[400]}\" {$cart_click_bull}>";
                $cart_link = str_replace('!!item!!', $bul_id, $cart_link);
                $cart_link .= "<span id='BULL_drag_" . $bul_id . "'  dragicon=\"{$base_path}/images/icone_drag_notice.png\" dragtext=\"" . htmlentities($link_bulletin, ENT_QUOTES, $charset) . "\" draggable=\"yes\" dragtype=\"notice\" callback_before=\"show_carts\" callback_after=\"\" style=\"padding-left:7px\"><img src=\"" . $base_path . "/images/notice_drag.png\"/></span>";
            } else {
                $cart_link = "";
            }
            if ($lien_cart_suppr) {
                if ($lien_pointe) {
                    if ($flag_pointe) {
                        $marque_flag = "<img src='images/depointer.png' id='caddie_" . $idcaddie . "_item_" . $bul_id . "' title=\"" . $msg['caddie_item_depointer'] . "\" onClick='del_pointage_item(" . $idcaddie . "," . $bul_id . ");' style='cursor: pointer'/>";
                    } else {
                        $marque_flag = "<img src='images/pointer.png' id='caddie_" . $idcaddie . "_item_" . $bul_id . "' title=\"" . $msg['caddie_item_pointer'] . "\" onClick='add_pointage_item(" . $idcaddie . "," . $bul_id . ");' style='cursor: pointer'/>";
                    }
                } else {
                    if ($flag_pointe) {
                        $marque_flag = "<img src='images/tick.gif'/>";
                    } else {
                        $marque_flag = "";
                    }
                }
                $cart_link .= "<a href='{$url_base_suppr_cart}&action=del_item&object_type=BULL&item={$bul_id}&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title=\"" . $msg["caddie_icone_suppr_elt"] . "\" /></a> {$marque_flag}";
            }
        } else {
            $myBul = new bulletinage($bul_id, 0, '');
            $cart_link = '';
        }
        $bul_action_bar = str_replace('!!bul_id!!', $bul_id, $bul_action_bar);
        $bul_action_bar = str_replace('!!nb_expl!!', sizeof($myBul->expl), $bul_action_bar);
        $bul_isbd = $myBul->display;
        $javascript_template = "\n\t\t<div id=\"el!!id!!Parent\" class=\"notice-parent\">\n    \t\t<img src=\"./images/plus.gif\" class=\"img_plus\" name=\"imEx\" id=\"el!!id!!Img\" title=\"" . $msg['admin_param_detail'] . "\" border=\"0\" onClick=\"expandBase('el!!id!!', true); return false;\" hspace=\"3\" />\n    \t\t<span class=\"notice-heada\">!!heada!!</span>\n    \t\t<br />\n\t\t</div>\n\t\t<div id=\"el!!id!!Child\" class=\"notice-child\" style=\"margin-bottom:6px;display:none;\">\n           \t\t!!ISBD!!\n \t\t</div>";
        $aff_expandable = str_replace('!!id!!', $bul_id, $javascript_template);
        $aff_expandable = str_replace('!!heada!!', $cart_link . " " . $bul_isbd, $aff_expandable);
        // affichage des exemplaires associés
        $list_expl = "<div class='exemplaires-perio'>";
        $list_expl .= "<h3>" . $msg[4012] . "</h3>";
        $list_expl .= "<div class='row'>" . get_expl($myBul->expl) . "</div></div>";
        $affichage_final .= $list_expl;
        // affichage des documents numeriques
        $aff_expl_num = $myBul->explnum;
        if ($aff_expl_num) {
            $list_expl = "<div class='exemplaires-perio'><h3>" . $msg['explnum_docs_associes'] . "</h3>";
            $list_expl .= "<div class='row'>" . $aff_expl_num . "</div></div>";
            $affichage_final .= $list_expl;
        }
        //affichage des dépouillements
        $liste = get_analysis($bul_id);
        if ($liste) {
            $liste_dep = $liste;
            $liste_dep .= $liste_fin;
            // inclusion du javascript inline
            $liste_dep .= $liste_script;
        } else {
            $liste_dep .= "<div class='row'>" . htmlentities($msg['bull_no_item'], ENT_QUOTES, $charset) . "</div>";
        }
        $affichage_final .= "\n\t\t\t<div class='depouillements-perio'>\n\t\t\t\t<h3>" . $msg[4013] . "</h3>\n\t\t\t\t<div class='row'>\n\t\t\t\t\t{$liste_dep}\n\t\t\t\t\t</div>\n\t\t\t\t</div>";
        // affichage des résas
        $aff_resa = resa_list(0, $bul_id, 0);
        if ($aff_resa) {
            $affichage_final .= "<h3>" . $msg['resas'] . "</h3>" . $aff_resa;
        }
    }
    $aff_expandable = str_replace('!!ISBD!!', $affichage_final, $aff_expandable);
    return $aff_expandable;
}
Ejemplo n.º 4
0
function show_bulletinage_info_catalogage($bul_id, $show_in_receptions = false)
{
    global $dbh, $msg, $charset, $base_path;
    global $liste_script;
    global $liste_debut;
    global $liste_fin;
    global $bul_action_bar;
    global $bul_cb_form;
    global $cart_click_bull;
    global $pmb_droits_explr_localises;
    global $explr_visible_mod;
    global $flag_no_delete_bulletin;
    global $pmb_resa_planning;
    $form = '';
    if ($bul_id) {
        if (!$show_in_receptions) {
            $myBul = new bulletinage($bul_id, 0, "./catalog.php?categ=serials&sub=bulletinage&action=explnum_form&bul_id={$bul_id}&explnum_id=!!explnum_id!!");
            $affichage_expl = get_expl($myBul->expl);
            $cpt_expl = get_expl($myBul->expl, 0, true);
        } else {
            $myBul = new bulletinage($bul_id, 0, '');
            $affichage_expl = get_expl($myBul->expl, 1);
            $cpt_expl = get_expl($myBul->expl, 1, true);
        }
        $bul_titre = $myBul->bulletin_titre;
        $bul_isbd = $myBul->display;
        $aff_expl_num = $myBul->explnum;
        $txt_drag = "";
        if ($myBul->bulletin_numero) {
            $txt_drag .= $myBul->bulletin_numero . " ";
        }
        if ($myBul->mention_date) {
            $txt_drag .= " (" . $myBul->mention_date . ") ";
        }
        $txt_drag .= "[" . $myBul->aff_date_date . "]";
        if (!$show_in_receptions) {
            // lien vers la notice chapeau
            $link_parent = "<a href=\"./catalog.php?categ=serials\">";
            $link_parent .= $msg[4010] . "</a>";
            $link_parent .= "<img src=\"./images/d.gif\" align=\"middle\" hspace=\"5\">";
            $link_parent .= "<a href=\"./catalog.php?categ=serials&sub=view&serial_id=";
            $link_parent .= $myBul->bulletin_notice . "\">" . $myBul->tit1 . '</a>';
            $link_parent .= "<img src=\"./images/d.gif\" align=\"middle\" hspace=\"5\">";
            $link_parent .= $txt_drag;
            if ($bul_titre) {
                $link_parent .= " : " . htmlentities($bul_titre, ENT_QUOTES, $charset);
            }
            $form .= "<div class='row'><div class='perio-barre'>" . $link_parent . "</div></div>";
            $cart_link = "<img src='./images/basket_small_20x20.gif' align='middle' alt='basket' title=\"{$msg[400]}\" {$cart_click_bull}>";
            $cart_link = str_replace('!!item!!', $bul_id, $cart_link);
            $cart_link .= "<span id='BULL_drag_" . $bul_id . "'  dragicon=\"{$base_path}/images/icone_drag_notice.png\" dragtext=\"" . htmlentities($txt_drag, ENT_QUOTES, $charset) . "\" draggable=\"yes\" dragtype=\"notice\" callback_before=\"show_carts\" callback_after=\"\" style=\"padding-left:7px\"><img src=\"" . $base_path . "/images/notice_drag.png\"/></span>";
            $bul_action_bar = str_replace('!!bul_id!!', $bul_id, $bul_action_bar);
            $bul_action_bar = str_replace('!!serial_id!!', $myBul->bulletin_notice, $bul_action_bar);
            $bul_action_bar = str_replace('!!nb_expl!!', sizeof($myBul->expl), $bul_action_bar);
            global $avis_quoifaire, $valid_id_avis;
            if ($myBul->bull_num_notice) {
                $bul_isbd = str_replace('<!-- !!avis_notice!! -->', avis_notice($myBul->bull_num_notice, $avis_quoifaire, $valid_id_avis), $bul_isbd);
            }
            if (!$flag_no_delete_bulletin) {
                $bul_action_bar = str_replace("!!bulletin_delete_button!!", "<input type='button' class='bouton' onclick=\"confirm_bul_delete();\" value='{$msg['63']}' />", $bul_action_bar);
            } else {
                $bul_action_bar = str_replace("!!bulletin_delete_button!!", "", $bul_action_bar);
            }
            if ($myBul->bull_num_notice) {
                $form .= $liste_script;
            }
            $form .= "\n\t\t\t<div class='bulletins-perio'>\n\t\t\t\t<div class='row'>\n\t\t\t\t\t<h2>{$cart_link} {$bul_isbd}</h2>\n\t\t\t\t\t</div>\n\t\t\t\t<div class='row'>\n\t\t\t\t\t{$bul_action_bar}\n\t\t\t\t\t</div>\n\t\t\t\t</div>";
            // affichage des exemplaires associés
            $list_expl = "<div class='exemplaires-perio'>";
            $list_expl .= "<h3>" . $msg[4012] . " (" . $cpt_expl . ")</h3>";
            $list_expl .= "<div class='row'>" . $affichage_expl . "</div></div>";
            $form .= $list_expl;
            if ($aff_expl_num) {
                $list_expl = "<div class='exemplaires-perio'><h3>" . $msg[explnum_docs_associes] . " (" . $myBul->nbexplnum . ")</h3>";
                $list_expl .= "<div class='row'>" . $aff_expl_num . "</div></div>";
                $form .= $list_expl;
            }
            if (!$explr_visible_mod && $pmb_droits_explr_localises == 1) {
                $etiquette_expl = "";
                $btn_ajouter_expl = "";
                $saisie_num_expl = "<div class='colonne10'><img src='./images/error.png' /></div>";
                $saisie_num_expl .= "<div class='colonne-suite'><span class='erreur'>" . $msg["err_add_invis_expl"] . "</span></div>";
            } else {
                $etiquette_expl = "<div class='row'>\n\t\t\t\t\t\t\t<label class='etiquette' for='form_cb'>{$msg['291']}</label>\n\t\t\t\t\t\t\t</div>";
                $btn_ajouter_expl = "<input type='submit' class='bouton' value=' {$msg['expl_ajouter']} ' onClick=\"return test_form(this.form)\">";
                global $pmb_numero_exemplaire_auto;
                if ($pmb_numero_exemplaire_auto == 1 || $pmb_numero_exemplaire_auto == 3) {
                    $num_exemplaire_auto = " {$msg['option_num_auto']} <INPUT type=checkbox name='option_num_auto' value='num_auto' checked >";
                }
                $saisie_num_expl = "<input type='text' class='saisie-20em' name='noex' value=''>" . $num_exemplaire_auto;
            }
            $req = "select * from serialcirc_copy, bulletins where num_serialcirc_copy_bulletin=bulletin_id and bulletin_id= {$bul_id}";
            $resultat = pmb_mysql_query($req);
            $i = 0;
            if (pmb_mysql_num_rows($resultat)) {
                $btn_print_ask = "<input type='button' class='bouton' value=' " . $msg["serialcirc_circ_list_reproduction_isdone_bt"] . " ' onClick=\"document.location='./catalog.php?categ=serials&sub=bulletinage&action=copy_isdone&bul_id=" . $bul_id . "';\" />";
            }
            $bul_cb_form = str_replace('!!bul_id!!', $bul_id, $bul_cb_form);
            $bul_cb_form = str_replace('!!etiquette!!', $etiquette_expl, $bul_cb_form);
            $bul_cb_form = str_replace('!!saisie_num_expl!!', $saisie_num_expl, $bul_cb_form);
            $bul_cb_form = str_replace('!!btn_ajouter!!', $btn_ajouter_expl, $bul_cb_form);
            $bul_cb_form = str_replace('!!btn_print_ask!!', $btn_print_ask, $bul_cb_form);
            $form .= "<div class='row'>" . $bul_cb_form . "</div>";
            // zone d'affichage des dépouillements
            $liste = get_analysis($bul_id);
            if ($liste) {
                $icones_exp .= $liste_debut . "&nbsp;<img src='./images/basket_small_20x20.gif' align='middle' alt='basket' title='" . $msg[400] . "' onClick=\"openPopUp('./cart.php?object_type=BULL&item=" . $bul_id . "&what=DEP', 'cart', 500, 400, -2, -2, 'toolbar=no, dependent=yes, resizable=yes, scrollbars=yes')\">";
                $liste_dep = $liste;
                $liste_dep .= $liste_fin;
                // inclusion du javascript inline
                $liste_dep .= !$myBul->bull_num_notice ? $liste_script : "";
            } else {
                $icones_exp .= "";
                $liste_dep .= "<div class='row'>" . $msg['bulletin_no_analysis'] . "</div>";
            }
            $link_new_dep = "<input type='button' class='bouton' value=' {$msg['4021']} ' onClick=\"document.location='./catalog.php?categ=serials&sub=analysis&action=analysis_form&bul_id={$bul_id}&analysis_id=0';\" />";
            $form .= "\n\t\t\t\t<div class='depouillements-perio'>\n\t\t\t\t\t<h3>" . $msg[4013] . $icones_exp . " {$link_new_dep}</h3>\n\t\t\t\t\t<div class='row'>\n\t\t\t\t\t\t{$liste_dep}\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>";
            //reservations et previsions
            $rqt_nt = "select count(*) from exemplaires, bulletins, docs_statut where exemplaires.expl_statut=docs_statut.idstatut and bulletins.bulletin_id=exemplaires.expl_bulletin and pret_flag=1 and bulletins.bulletin_id=" . $bul_id;
            $result = pmb_mysql_query($rqt_nt, $dbh) or die($rqt_nt . " " . pmb_mysql_error());
            $nb_expl_reservables = pmb_mysql_result($result, 0, 0);
            $aff_resa = resa_list(0, $bul_id, 0);
            $ouvrir_reserv = "onclick=\"parent.location.href='./circ.php?categ=resa_from_catal&id_bulletin=" . $bul_id . "'; return(false) \"";
            if ($aff_resa) {
                $form .= "<b>" . $msg['resas'] . "</b><br />";
                if ($nb_expl_reservables) {
                    $form .= "<input type='button' class='bouton' value='" . $msg[351] . "' {$ouvrir_reserv}><br /><br />";
                }
                $form .= $aff_resa . "<br />";
            } else {
                if ($nb_expl_reservables) {
                    $form .= "<b>" . $msg['resas'] . "</b><br /><input type='button' class='bouton' value='" . $msg[351] . "' {$ouvrir_reserv}><br /><br />";
                }
            }
            if ($pmb_resa_planning) {
                $aff_resa_planning = planning_list(0, $bul_id, 0);
                //TODO
                $ouvrir_reserv = "onclick=\"parent.location.href='" . $base_path . "/circ.php?categ=resa_planning_from_catal&id_bulletin=" . $bul_id . "'; return(false) \"";
                if ($aff_resa_planning) {
                    $form .= "<b>" . $msg['resas_planning'] . "</b><br />";
                    if ($nb_expl_reservables) {
                        $form .= "<input type='button' class='bouton' value='" . $msg['resa_planning_add'] . "' {$ouvrir_reserv}><br /><br />";
                    }
                    $form .= $aff_resa_planning . "<br />";
                } else {
                    if ($nb_expl_reservables && !($categ == "resa_planning") && !$id_empr && $nb_expl_reservables) {
                        $form .= "<b>" . $msg['resas_planning'] . "</b><br /><input type='button' class='bouton' value='" . $msg['resa_planning_add'] . "' {$ouvrir_reserv}><br /><br />";
                    }
                }
            }
        } else {
            $form .= "<div class='notice-parent' id='_bull_'>\n\t\t\t\t\t\t<img hspace='3' border='0' onclick=\"expandBase('_bull_', true); return false;\" title='" . $msg['plus_detail'] . "' id='_bull_Img' name='imEx' class='img_plus' src='" . $base_path . "/images/minus.gif' />\n\t\t\t\t\t\t<span class='notice-heada'>" . htmlentities($myBul->tit1 . '.' . $txt_drag, ENT_QUOTES, $charset);
            if ($bul_titre) {
                $form .= " : " . htmlentities($bul_titre, ENT_QUOTES, $charset);
            }
            $form .= "\t</span>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div style='margin-bottom: 6px; display: none; width: 94%;' class='notice-child' id='_bull_Child'>\n\t\t\t\t\t\t<br /><b>" . htmlentities($msg[4012], ENT_QUOTES, $charset) . "</b>\n\t\t\t\t\t\t{$affichage_expl}\n\t\t\t\t\t\t<br ><b>" . htmlentities($msg['explnum_docs_associes'], ENT_QUOTES, $charset) . "</b>\n\t\t\t\t\t\t{$aff_expl_num};\n\t\t\t\t\t</div>";
        }
    }
    return $form;
}