コード例 #1
0
function aff_empr_cart_objects($idemprcaddie = 0, $url_base = "./circ.php?categ=caddie&sub=gestion&quoi=panier&idemprcaddie=0", $no_del = false, $rec_history = 0, $no_point = false)
{
    global $msg, $begin_result_liste;
    global $dbh;
    global $nbr_lignes, $page, $nb_per_page_search;
    global $url_base_suppr_empr_cart;
    $url_base_suppr_empr_cart = $url_base;
    // nombre de références par pages
    if ($nb_per_page_search != "") {
        $nb_per_page = $nb_per_page_search;
    } else {
        $nb_per_page = 10;
    }
    // on récupére le nombre de lignes
    if (!$nbr_lignes) {
        $requete = "SELECT count(1) FROM empr_caddie_content where empr_caddie_id='" . $idemprcaddie . "' ";
        $res = pmb_mysql_query($requete, $dbh);
        $nbr_lignes = pmb_mysql_result($res, 0, 0);
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    //Calcul des variables pour la suppression d'items
    $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;
    if ($nbr_lignes) {
        // on lance la vraie requête
        $myCart = new empr_caddie($idemprcaddie);
        $from = " empr_caddie_content left join empr on id_empr = object_id ";
        $order_by = " empr_nom, empr_prenom ";
        $requete = "SELECT object_id, flag FROM {$from} where empr_caddie_id='" . $idemprcaddie . "' order by {$order_by}";
        $requete .= " LIMIT {$debut},{$nb_per_page} ";
        $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true);
        // l'affichage du résultat est fait après le else
    } else {
        print $msg[399];
        return;
    }
    $liste = array();
    $result = @pmb_mysql_query($requete, $dbh);
    if (pmb_mysql_num_rows($result)) {
        while ($temp = pmb_mysql_fetch_object($result)) {
            $liste[] = array('object_id' => $temp->object_id, 'flag' => $temp->flag);
        }
    }
    if (!sizeof($liste) || !is_array($liste)) {
        print $msg[399];
        return;
    } else {
        print "\n\t\t<script>\n\t\t\tvar ajax_pointage=new http_request();\n\t\t\tvar num_caddie=0;\n\t\t\tvar num_item=0;\n\t\t\tvar action='';\n\t\t\tfunction add_pointage_item(idcaddie,id_item) {\n\t\t\t\tnum_caddie=idcaddie;\n\t\t\t\tnum_item=id_item;\n\t\t\t\taction='add_item';\n\t\t\t\tvar url = './ajax.php?module=catalog&categ=pointage_add&sub=pointage&moyen=manu&action=add_item&typecaddie=empr&idcaddie='+idcaddie+'&id_item='+id_item;\n\t\t \t\tajax_pointage.request(url,0,'',1,pointage_callback,0,0);\n\t\t\t}\n\t\t\n\t\t\tfunction del_pointage_item(idcaddie,id_item) {\n\t\t\t\tnum_caddie=idcaddie;\n\t\t\t\tnum_item=id_item;\n\t\t\t\taction='del_item';\n\t\t\t\tvar url = './ajax.php?module=catalog&categ=pointage_del&sub=pointage&moyen=manu&action=del_item&typecaddie=empr&idcaddie='+idcaddie+'&id_item='+id_item;\n\t\t\t\tajax_pointage.request(url,0,'',1,pointage_callback,0,0);\n\t\t\t}\n\t\t\tfunction pointage_callback(response) {\n\t\t\t\tdata = eval('('+response+')');\n\t\t\t\tswitch (action) {\n\t\t\t\t\tcase 'add_item':\n\t\t\t\t\t\tif (data.res_pointage == 1) {\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).src='./images/depointer.png';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).title='" . $msg['caddie_item_depointer'] . "';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).setAttribute('onclick','del_pointage_item('+num_caddie+','+num_item+')');\n\t\t\t\t\t\t} else {\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).src='./images/pointer.png';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).title='" . $msg['caddie_item_pointer'] . "';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).setAttribute('onclick','add_pointage_item('+num_caddie+','+num_item+')');\n\t\t\t\t\t\t}\n\t\t\t\t\t\tbreak;\n\t\t\t\t\tcase 'del_item':\n\t\t\t\t\t\tif (data.res_pointage == 1) {\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).src='./images/pointer.png';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).title='" . $msg['caddie_item_pointer'] . "';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).setAttribute('onclick','add_pointage_item('+num_caddie+','+num_item+')');\n\t\t\t\t\t\t} else {\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).src='./images/depointer.png';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).title='" . $msg['caddie_item_depointer'] . "';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).setAttribute('onclick','del_pointage_item('+num_caddie+','+num_item+')');\n\t\t\t\t\t\t}\n\t\t\t\t\t\tbreak;\n\t\t\t\t}\n\t\t\t\tvar div = document.createElement('div');\n\t\t\t\tdiv.setAttribute('id','cart_'+data.idcaddie+'_nb_items');\n\t\t\t\tdiv.innerHTML = data.aff_cart_nb_items;\n\t\t\t\tdocument.getElementById('cart_'+data.idcaddie+'_nb_items').parentNode.replaceChild(div,document.getElementById('cart_'+data.idcaddie+'_nb_items'));\n\t\t\t}\n\t\t</script>";
        print $begin_result_liste;
        print empr_caddie::show_actions($idemprcaddie);
        while (list($cle, $object) = each($liste)) {
            // affichage de la liste des emprunteurs
            $requete = "SELECT * FROM empr WHERE id_empr={$object['object_id']} LIMIT 1";
            $fetch = pmb_mysql_query($requete);
            if (pmb_mysql_num_rows($fetch)) {
                $empr = pmb_mysql_fetch_object($fetch);
                // emprunteur
                $link = './circ.php?categ=pret&form_cb=' . rawurlencode($empr->empr_cb);
                if (!$no_point) {
                    if ($object[flag]) {
                        $marque_flag = "<img src='images/depointer.png' id='caddie_" . $idemprcaddie . "_item_" . $empr->id_empr . "' title=\"" . $msg['caddie_item_depointer'] . "\" onClick='del_pointage_item(" . $idemprcaddie . "," . $empr->id_empr . ");' style='cursor: pointer'/>";
                    } else {
                        $marque_flag = "<img src='images/pointer.png' id='caddie_" . $idemprcaddie . "_item_" . $empr->id_empr . "' title=\"" . $msg['caddie_item_pointer'] . "\" onClick='add_pointage_item(" . $idemprcaddie . "," . $empr->id_empr . ");' style='cursor: pointer'/>";
                    }
                } else {
                    if ($object[flag]) {
                        $marque_flag = "<img src='images/tick.gif'/>";
                    } else {
                        $marque_flag = "";
                    }
                }
                if (!$no_del) {
                    $lien_suppr_cart = "<a href='{$url_base}&action=del_item&item={$empr->id_empr}&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 {
                    $lien_suppr_cart = $marque_flag;
                }
                $empr = new emprunteur($empr->id_empr, "", FALSE, 3);
                $empr->fiche_consultation = str_replace('!!image_suppr_caddie_empr!!', $lien_suppr_cart, $empr->fiche_consultation);
                $empr->fiche_consultation = str_replace('!!lien_vers_empr!!', $link, $empr->fiche_consultation);
                print $empr->fiche_consultation;
            }
        }
        // fin de liste
    }
    print "<br />" . $nav_bar;
    return;
}