";
}
die();
}
$result_selection = pmb_mysql_query($valeur);
if (!$result_selection) {
error_message_history($msg['caddie_action_invalid_query'],$msg['requete_echouee'].pmb_mysql_error(),1);
exit();
}
if (pmb_strtolower(pmb_substr($valeur,0,6))=="select") {
$nb_element_a_ajouter += pmb_mysql_num_rows($result_selection);
if(pmb_mysql_num_rows($result_selection)) {
while ($obj_selection = pmb_mysql_fetch_object($result_selection))
if(static::class == 'empr_caddie') {
$this->add_item($obj_selection->object_id);
} else {
$this->add_item($obj_selection->object_id,$obj_selection->object_type);
}
} // fin if mysql_num_rows
$this->compte_items();
} // fin if rqt sélection
} //fin valeur nonvide
} // fin while list $cle
$nb_element_apres = $this->nb_item;
$msg["caddie_affiche_nb_ajouts"] = str_replace('!!nb_a_ajouter!!', $nb_element_a_ajouter, $msg["caddie_affiche_nb_ajouts"]);
$msg["caddie_affiche_nb_ajouts"] = str_replace('!!nb_ajoutes!!', ($nb_element_apres-$nb_element_avant), $msg["caddie_affiche_nb_ajouts"]);
$res_exec = "$msg[caddie_affiche_nb_ajouts]";
return $res_exec;
}
protected function replace_in_action_query($query, $by) {
$final_query = $query;
return $final_query;
}
public function update_items_by_action_selection($final_query) {
global $msg;
global $elt_flag;
global $elt_no_flag;
$error_message_flag = '';
$error_message_no_flag = '';
//Sélection des éléments du panier
$nb_elements_flag=0;
$nb_elements_no_flag=0;
if ($elt_flag) {
$liste_flag=$this->get_cart("FLAG");
if (count($liste_flag)) {
if (pmb_strtolower(pmb_substr($final_query,0,6))=='insert') {
// procédure insert
for ($icount=0; $icountreplace_in_action_query($final_query, $liste_flag[$icount]);
$result_selection_flag= pmb_mysql_query($query);
$nb_elts_traites = pmb_mysql_affected_rows() ;
if ($nb_elts_traites>0) $nb_elements_flag+=$nb_elts_traites;
} // fin for
} else {
// autre procédure
$query=preg_replace("/CADDIE\([^\)]*\)/i",implode(",",$liste_flag),$final_query);
$result_selection_flag= pmb_mysql_query($query);
if ($result_selection_flag) {
$nb_elements_flag=pmb_mysql_affected_rows();
} else $error_message_flag=pmb_mysql_error();
} // fin if autre procédure
}
}
if ($elt_no_flag) {
$liste_no_flag=$this->get_cart("NOFLAG");
if (count($liste_no_flag)) {
if (pmb_strtolower(pmb_substr($final_query,0,6))=='insert') {
// procédure insert
for ($icount=0; $icountreplace_in_action_query($final_query, $liste_no_flag[$icount]);
$result_selection_no_flag= pmb_mysql_query($query);
$nb_elts_traites = pmb_mysql_affected_rows() ;
if ($nb_elts_traites>0) $nb_elements_no_flag+=$nb_elts_traites;
} // fin for
} else {
// autre procédure
$query=preg_replace("/CADDIE\([^\)]*\)/i",implode(",",$liste_no_flag),$final_query);
$result_selection_no_flag= pmb_mysql_query($query);
if ($result_selection_no_flag) {
$nb_elements_no_flag=pmb_mysql_affected_rows();
} else $error_message_no_flag=pmb_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();
}
}
public function get_edition_switch_form($mode="simple", $action="") {
global $msg;
return "
";
}
protected function get_edition_template_form() {
return "";
}
public function get_edition_form($action="", $action_cancel="") {
global $msg;
$form = $this->get_edition_template_form();
$form = str_replace('!!action!!', $action, $form);
$form = str_replace('!!action_cancel!!', $action_cancel, $form);
$form = str_replace('!!titre_form!!', $msg["caddie_choix_edition"], $form);
$suppl = "
" ;
$form = str_replace('', $suppl.'', $form);
return $form;
}
protected function get_js_script_cart_objects($module='ajax') {
global $msg;
return "
";
}
// affichage des filtres d'un caddie
public function aff_filters_form_objects ($url_base="") {
global $msg, $charset;
global $current_module;
global $elt_flag,$elt_no_flag;
$filters_form = "
";
return $filters_form;
}
// affichage du contenu complet d'un caddie
public function aff_cart_objects ($url_base="", $no_del=false, $rec_history=0, $no_point=false) {
}
public function aff_cart_nb_items() {
global $msg;
return "
".$msg['caddie_contient']."
".$msg['caddie_contient_total']."
".$msg['caddie_contient_nb_pointe']."
".$msg['caddie_contient_total']."
".$this->nb_item."
".$this->nb_item_pointe."
";
}
public function aff_nb_items_reduit() {
global $msg;
return "