gen_form("./circ.php?categ=caddie&sub=action&quelle=selection&action=add_item&idemprcaddie=$idemprcaddie&id=$id&elt_flag=$elt_flag&elt_no_flag=$elt_no_flag") ; break; case 'add_item': //C'est ici qu'on fait une action if ($droit) { $hp = new parameters ($id,"empr_caddie_procs") ; $hp->get_final_query(); echo "
".$hp->final_query."
"; //Sélection des éléments du panier $nb_elements_flag=0; $nb_elements_no_flag=0; if ($elt_flag) { $liste_flag=$myCart->get_cart("FLAG"); if (count($liste_flag)) { if (pmb_strtolower(pmb_substr($hp->final_query,0,6))=='insert') { // procédure insert for ($icount=0; $icountfinal_query); $result_selection_flag= @mysql_query($final_query, $dbh); $nb_elts_traites = mysql_affected_rows($dbh) ; if ($nb_elts_traites>0) $nb_elements_flag+=$nb_elts_traites; } // fin for } else { // autre procédure $final_query=preg_replace("/CADDIE\(.*[^\)]\)/i",implode(",",$liste_flag),$hp->final_query); $result_selection_flag= mysql_query($final_query, $dbh); if ($result_selection_flag) { $nb_elts_traites = mysql_affected_rows($dbh) ; if ($nb_elts_traites>0) $nb_elements_flag+=$nb_elts_traites; } else $error_message_flag=mysql_error(); } // fin if autre procédure } } if ($elt_no_flag) { $liste_no_flag=$myCart->get_cart("NOFLAG"); if (count($liste_no_flag)) { if (pmb_strtolower(pmb_substr($hp->final_query,0,6))=='insert') { // procédure insert for ($icount=0; $icountfinal_query); $result_selection_no_flag= @mysql_query($final_query, $dbh); $nb_elts_traites = mysql_affected_rows($dbh) ; if ($nb_elts_traites>0) $nb_elements_no_flag+=$nb_elts_traites; } // fin for } else { // autre procédure $final_query=preg_replace("/CADDIE\(.*[^\)]\)/i",implode(",",$liste_no_flag),$hp->final_query); $result_selection_no_flag= mysql_query($final_query, $dbh); if ($result_selection_no_flag) { $nb_elts_traites = mysql_affected_rows($dbh) ; if ($nb_elts_traites>0) $nb_elements_no_flag+=$nb_elts_traites; } else $error_message_no_flag=mysql_error(); } // fin if autre procédure } } $error_message=""; print sprintf($msg["caddie_action_flag_processed"],$nb_elements_flag)."
"; print sprintf($msg["caddie_action_no_flag_processed"],$nb_elements_no_flag)."
"; print "".sprintf($msg["caddie_action_total_processed"],($nb_elements_no_flag+$nb_elements_flag))."

"; if ($error_message_flag) { $error_message.=sprintf($msg["caddie_action_error"],$error_message_flag)."
"; } if ($error_message_no_flag) { $error_message.=sprintf($msg["caddie_action_error"],$error_message_no_flag); } if ($error_message) { error_message_history($msg["caddie_action_invalid_query"],$error_message,1); exit(); } } print aff_empr_cart_nb_items ($myCart) ; break; default: print aff_empr_cart_nb_items ($myCart) ; print $empr_cart_choix_quoi_action; show_empr_procs($idemprcaddie); break; } } else aff_paniers_empr($idemprcaddie, "./circ.php?categ=caddie&sub=action&quelle=selection", "", $msg["caddie_select_for_action"], "", 0, 0, 0); function show_empr_procs($idemprcaddie) { global $msg; global $PMBuserid; global $dbh; print "
$msg[caddie_select_proc]
"; // affichage du tableau des procédures if ($PMBuserid!=1) $where=" and (autorisations='$PMBuserid' or autorisations like '$PMBuserid %' or autorisations like '% $PMBuserid %' or autorisations like '% $PMBuserid') "; $requete = "SELECT idproc, type, name, requete, comment, autorisations, parameters FROM empr_caddie_procs WHERE type='ACTION' $where ORDER BY name "; $res = mysql_query($requete, $dbh); $nbr = mysql_num_rows($res); $parity=1; $n_proc=0; for($i=0;$i<$nbr;$i++) { $row=mysql_fetch_row($res); $rqt_autorisation=explode(" ",$row[5]); if ((array_search ($PMBuserid, $rqt_autorisation)!==FALSE || $PMBuserid == 1)) { $n_proc++; if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; if (preg_match_all("|!!(.*)!!|U",$row[3],$query_parameters)) $action = "form_proc" ; else $action = "add_item" ; $confirm_msg = str_replace("\"",""",sprintf($msg["caddie_action_proc_confirm"],$row[2])); $tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" onmousedown=\"if (confirm('".addslashes($confirm_msg)."')) { url='./circ.php?categ=caddie&sub=action&quelle=selection&action=$action&id=$row[0]&idemprcaddie=$idemprcaddie'; if (document.maj_proc.elt_flag.checked) url+='&elt_flag='+document.maj_proc.elt_flag.value; if (document.maj_proc.elt_no_flag.checked) url+='&elt_no_flag='+document.maj_proc.elt_no_flag.value; document.location=url; }\" "; print pmb_bidi(""); } } print "
$row[2]
$row[4] 
"; if ($n_proc==0) print $msg["caddie_no_action_proc"]; }