<th>Prénom</th> <th>Email</th> <th>Donnée 1</th> <th>Donnée 2</th> <th> </th> </tr> <tr> </tr> </thead> <tbody> <?php foreach ($data_out['liste_forms'] as $form) { ?> <tr> <td align="center" valign="top" nowrap="nowrap"><?php echo $form['date_add'] != '' ? Lib_enToFr($form['date_add']) : ''; ?> </td> <td align="left" valign="top" nowrap="nowrap"><?php echo $form['nom']; ?> </td> <td align="left" valign="top" nowrap="nowrap"><?php echo $form['prenom']; ?> </td> <td align="left" valign="top" nowrap="nowrap"><?php echo $form['form1']; ?> </td> <td align="left" valign="top" nowrap="nowrap"><?php
/** Retourne un tableau de factures correspondant aux champs du tableau en argument. @param $args */ function Factures_chercher($args) { $tab_result = array(); $sql = " SELECT * \n\t\t\t\tFROM " . $GLOBALS['prefix'] . "factures\n\t\t\t\tWHERE 1"; if (!isset($args['id_facture']) && !isset($args['id_pere']) && !isset($args['type_pere']) && !isset($args['etat']) && !isset($args['date_facture_debut']) && !isset($args['date_facture_fin']) && !isset($args['date_facture']) && !isset($args['num_facture']) && !isset($args['order_by']) && !isset($args['tab_ids_factures'])) { return $tab_result; } $condition = ""; if (isset($args['id_facture']) && $args['id_facture'] != "*") { $condition .= " AND id_facture = '" . $args['id_facture'] . "' "; } if (isset($args['id_pere']) && $args['id_pere'] != "*") { $condition .= " AND id_pere = " . $args['id_pere'] . " "; } if (isset($args['type_pere']) && $args['type_pere'] != "*") { $condition .= " AND type_pere LIKE '" . $args['type_pere'] . "' "; } if (isset($args['etat']) && $args['etat'] != "*") { $condition .= " AND etat = '" . $args['etat'] . "' "; } if (isset($args['date_facture']) && $args['date_facture'] != "*") { $condition .= " AND date_facture = '" . Lib_frToEn($args['date_facture']) . "' "; } if (isset($args['date_facture_debut']) && $args['date_facture_debut'] != "*") { $condition .= " AND date_facture >= '" . Lib_frToEn($args['date_facture_debut']) . "' "; } if (isset($args['date_facture_fin']) && $args['date_facture_fin'] != "*") { $condition .= " AND date_facture <= '" . Lib_frToEn($args['date_facture_fin']) . "' "; } if (isset($args['num_facture']) && $args['num_facture'] != "*") { $condition .= " AND num_facture LIKE '" . $args['num_facture'] . "' "; } if (isset($args['tab_ids_factures']) && $args['tab_ids_factures'] != "*") { $ids = implode(",", $args['tab_ids_factures']); $condition .= " AND id_facture IN (0" . $ids . ") "; } $sql .= $condition; if (isset($args['order_by']) && !isset($args['asc_desc'])) { $sql .= " ORDER BY " . $args['order_by'] . " ASC"; } if (isset($args['order_by']) && isset($args['asc_desc'])) { $sql .= " ORDER BY " . $args['order_by'] . " " . $args['asc_desc']; } if (isset($args['limit']) && !isset($args['start'])) { $sql .= " LIMIT " . $args['limit']; } if (isset($args['limit']) && isset($args['start'])) { $sql .= " LIMIT " . $args['start'] . "," . $args['limit']; } /*=============*/ Lib_myLog("SQL: {$sql}"); $result = mysql_query($sql); if ($result) { while ($row = mysql_fetch_array($result)) { $id = $row['id_facture']; $tab_result[$id]["id_facture"] = $id; $tab_result[$id]["id_pere"] = $row['id_pere']; $tab_result[$id]["type_pere"] = $row['type_pere']; $tab_result[$id]["montant_ttc"] = $row['montant_ttc']; $tab_result[$id]["etat"] = $row['etat']; $tab_result[$id]["date_facture"] = Lib_enToFr($row['date_facture']); $tab_result[$id]["num_facture"] = $row['num_facture']; $tab_result[$id]["message"] = Lib_prepareTexteAffichage($row['message']); $tab_result[$id]["produit"] = Lib_prepareTexteAffichage($row['produit']); $tab_result[$id]["id_mode_reglement"] = $row['id_mode_reglement']; $tab_result[$id]["id_delai_reglement"] = $row['id_delai_reglement']; $tab_result[$id]["code_client"] = $row['code_client']; $tab_result[$id]["nom_fact"] = Lib_prepareTexteAffichage($row['nom_fact']); $tab_result[$id]["ligne1_fact"] = Lib_prepareTexteAffichage($row['ligne1_fact']); $tab_result[$id]["ligne2_fact"] = Lib_prepareTexteAffichage($row['ligne2_fact']); $tab_result[$id]["ligne3_fact"] = Lib_prepareTexteAffichage($row['ligne3_fact']); $tab_result[$id]["cp_fact"] = $row['cp_fact']; $tab_result[$id]["ville_fact"] = Lib_prepareTexteAffichage($row['ville_fact']); $tab_result[$id]["tel1_fact"] = $row['tel1_fact']; $tab_result[$id]["tel2_fact"] = $row['tel2_fact']; $tab_result[$id]["fax_fact"] = $row['fax_fact']; $tab_result[$id]["email_fact"] = $row['email_fact']; $tab_result[$id]["date_add"] = $row['date_add']; $tab_result[$id]["date_upd"] = $row['date_upd']; $tab_result[$id]["info_facture"] = $row['info_facture']; } } if (count($tab_result) == 1 && ($args['id_facture'] != '' && $args['id_facture'] != '*')) { $tab_result = array_pop($tab_result); } return $tab_result; }
/** Renvoie le lang, le prélang et l'identifiant des personnes ayant les données passées en argument sous forme d'un tableau @param id_tache @param langPersonne @param textePersonne ... */ function Taches_chercher($args) { $tab_result = array(); $sql = " SELECT * \n\t\t\tFROM " . $GLOBALS['prefix'] . "taches\n\t\t\tWHERE 1"; if (!isset($args['id_tache']) && !isset($args['code']) && !isset($args['code_news']) && !isset($args['date']) && !isset($args['lang']) && !isset($args['titre']) && !isset($args['position']) && !isset($args['titre_data1']) && !isset($args['data1']) && !isset($args['titre_data2']) && !isset($args['data2']) && !isset($args['titre_data3']) && !isset($args['data3']) && !isset($args['titre_data4']) && !isset($args['data4']) && !isset($args['titre_data5']) && !isset($args['data5']) && !isset($args['titre_data6']) && !isset($args['data6']) && !isset($args['texte']) && !isset($args['etat']) && !isset($args['position_une']) && !isset($args['not_position_une']) && !isset($args['code']) && !isset($args['titre_canonize']) && !isset($args['tab_ids_taches']) && !isset($args['categorie'])) { return $tab_result; } $condition = ""; if (isset($args['id_tache']) && $args['id_tache'] != "*") { $condition .= " AND id_tache = " . Sql_prepareTexteStockage($args['id_tache']) . " "; } if (isset($args['code_news'])) { $condition .= " AND code_news LIKE '" . Sql_prepareTexteStockage($args['code_news']) . "' "; } if (isset($args['position']) && $args['position'] != "*") { $condition .= " AND position = '" . $args['position'] . "' "; } if (isset($args['position_une'])) { $condition .= " AND position_une = " . $args['position_une'] . " "; } if (isset($args['not_position_une'])) { $condition .= " AND position_une != " . $args['not_position_une'] . " "; } if (isset($args['position_une_min'])) { $condition .= " AND position_une >= " . $args['position_une_min'] . " "; } if (isset($args['code'])) { $condition .= " AND code = '" . $args['code'] . "' "; } if (isset($args['lang'])) { $condition .= " AND lang = '" . $args['lang'] . "' "; } if (isset($args['texte'])) { $condition .= " AND texte LIKE '" . Sql_prepareTexteStockage($args['texte']) . "' "; } if (isset($args['titre'])) { $condition .= " AND titre LIKE '" . Sql_prepareTexteStockage($args['titre']) . "' "; } if (isset($args['etat'])) { $condition .= " AND etat = '" . $args['etat'] . "' "; } if (isset($args['meta_titre'])) { $condition .= " AND meta_titre = '" . $args['meta_titre'] . "' "; } if (isset($args['meta_description'])) { $condition .= " AND meta_description = '" . $args['meta_description'] . "' "; } if (isset($args['meta_mots_clefs'])) { $condition .= " AND meta_mots_clefs = '" . $args['meta_mots_clefs'] . "' "; } if (isset($args['meta_url'])) { $condition .= " AND meta_url = '" . $args['meta_url'] . "' "; } if (isset($args['titre_canonize'])) { $condition .= " AND titre_canonize LIKE '" . $args['titre_canonize'] . "' "; } if (isset($args['categorie'])) { $condition .= " AND categorie LIKE '" . $args['categorie'] . "' "; } if (isset($args['titre_data1'])) { $condition .= " AND titre_data1 LIKE '" . $args['titre_data1'] . "' "; } if (isset($args['titre_data2'])) { $condition .= " AND titre_data2 LIKE '" . $args['titre_data2'] . "' "; } if (isset($args['titre_data3'])) { $condition .= " AND titre_data3 LIKE '" . $args['titre_data3'] . "' "; } if (isset($args['titre_data4'])) { $condition .= " AND titre_data4 LIKE '" . $args['titre_data4'] . "' "; } if (isset($args['titre_data5'])) { $condition .= " AND titre_data5 LIKE '" . $args['titre_data5'] . "' "; } if (isset($args['titre_data6'])) { $condition .= " AND titre_data6 LIKE '" . $args['titre_data6'] . "' "; } if (isset($args['titre_data7'])) { $condition .= " AND titre_data7 LIKE '" . $args['titre_data7'] . "' "; } if (isset($args['titre_data8'])) { $condition .= " AND titre_data8 LIKE '" . $args['titre_data8'] . "' "; } if (isset($args['titre_data9'])) { $condition .= " AND titre_data9 LIKE '" . $args['titre_data9'] . "' "; } if (isset($args['titre_data10'])) { $condition .= " AND titre_data10 LIKE '" . $args['titre_data10'] . "' "; } if (isset($args['titre_data11'])) { $condition .= " AND titre_data11 LIKE '" . $args['titre_data11'] . "' "; } if (isset($args['titre_data12'])) { $condition .= " AND titre_data12 LIKE '" . $args['titre_data12'] . "' "; } if (isset($args['titre_data13'])) { $condition .= " AND titre_data13 LIKE '" . $args['titre_data13'] . "' "; } if (isset($args['titre_data14'])) { $condition .= " AND titre_data14 LIKE '" . $args['titre_data14'] . "' "; } if (isset($args['titre_data15'])) { $condition .= " AND titre_data15 LIKE '" . $args['titre_data15'] . "' "; } if (isset($args['titre_data16'])) { $condition .= " AND titre_data16 LIKE '" . $args['titre_data16'] . "' "; } if (isset($args['titre_data17'])) { $condition .= " AND titre_data17 LIKE '" . $args['titre_data17'] . "' "; } if (isset($args['titre_data18'])) { $condition .= " AND titre_data18 LIKE '" . $args['titre_data18'] . "' "; } if (isset($args['titre_data19'])) { $condition .= " AND titre_data19 LIKE '" . $args['titre_data19'] . "' "; } if (isset($args['titre_data20'])) { $condition .= " AND titre_data620 LIKE '" . $args['titre_data20'] . "' "; } if (isset($args['data1'])) { $condition .= " AND data1 LIKE '" . $args['data1'] . "' "; } if (isset($args['data2'])) { $condition .= " AND data2 LIKE '" . $args['data2'] . "' "; } if (isset($args['data3'])) { $condition .= " AND data3 LIKE '" . $args['data3'] . "' "; } if (isset($args['data4'])) { $condition .= " AND data4 LIKE '" . $args['data4'] . "' "; } if (isset($args['data5'])) { $condition .= " AND data5 LIKE '" . $args['data5'] . "' "; } if (isset($args['data6'])) { $condition .= " AND data6 LIKE '" . $args['data6'] . "' "; } if (isset($args['data7'])) { $condition .= " AND data7 LIKE '" . $args['data7'] . "' "; } if (isset($args['data8'])) { $condition .= " AND data8 LIKE '" . $args['data8'] . "' "; } if (isset($args['data9'])) { $condition .= " AND data9 LIKE '" . $args['data9'] . "' "; } if (isset($args['data10'])) { $condition .= " AND data10 LIKE '" . $args['data10'] . "' "; } if (isset($args['data11'])) { $condition .= " AND data11 LIKE '" . $args['data11'] . "' "; } if (isset($args['data12'])) { $condition .= " AND data12 LIKE '" . $args['data12'] . "' "; } if (isset($args['data13'])) { $condition .= " AND data13 LIKE '" . $args['data13'] . "' "; } if (isset($args['data14'])) { $condition .= " AND data14 LIKE '" . $args['data14'] . "' "; } if (isset($args['data15'])) { $condition .= " AND data15 LIKE '" . $args['data15'] . "' "; } if (isset($args['data16'])) { $condition .= " AND data16 LIKE '" . $args['data16'] . "' "; } if (isset($args['data17'])) { $condition .= " AND data17 LIKE '" . $args['data17'] . "' "; } if (isset($args['data18'])) { $condition .= " AND data18 LIKE '" . $args['data18'] . "' "; } if (isset($args['data19'])) { $condition .= " AND data19 LIKE '" . $args['data19'] . "' "; } if (isset($args['data20'])) { $condition .= " AND data20 LIKE '" . $args['data20'] . "' "; } if (isset($args['tab_ids_taches'])) { $ids = implode(",", $args['tab_ids_taches']); $condition .= " AND id_tache IN (" . $ids . ") "; } if (!isset($args['etat'])) { $condition .= " AND etat != 'supprime' "; } if (isset($args['order_by']) && $args['order_by'] != "*") { $condition .= " ORDER BY " . $args['order_by'] . " ASC "; } else { $condition .= " ORDER BY id_tache ASC "; } $sql .= $condition; /*=============*/ Lib_myLog("SQL: {$sql}"); $result = Sql_query($sql); if ($result && Sql_errorCode($result) === "00000") { while ($row = Sql_fetch($result)) { $id = $row['id_tache']; $tab_result[$id]["id_tache"] = $id; $tab_result[$id]["code"] = $row['code']; $tab_result[$id]["lang"] = $row['lang']; $tab_result[$id]["position_une"] = $row['position_une']; $tab_result[$id]["position"] = $row['position']; $tab_result[$id]["code_news"] = $row['code_news']; $tab_result[$id]["contenu"] = $row['contenu']; $tab_result[$id]["date"] = Lib_enToFr($row['date']); $tab_result[$id]["texte"] = Sql_prepareTexteAffichage($row['texte']); $tab_result[$id]["etat"] = $row['etat']; $tab_result[$id]["image_intro"] = Sql_prepareTexteAffichage($row['image_intro']); $tab_result[$id]["texte_intro"] = Sql_prepareTexteAffichage($row['texte_intro']); $tab_result[$id]["titre"] = Sql_prepareTexteAffichage($row['titre']); $tab_result[$id]["titre_page"] = Sql_prepareTexteAffichage($row['titre_page']); $tab_result[$id]["meta_titre"] = Sql_prepareTexteAffichage($row['meta_titre']); $tab_result[$id]["meta_description"] = Sql_prepareTexteAffichage($row['meta_description']); $tab_result[$id]["meta_mots_clefs"] = Sql_prepareTexteAffichage($row['meta_mots_clefs']); $tab_result[$id]["meta_url"] = Sql_prepareTexteAffichage($row['meta_url']); $tab_result[$id]["titre_canonize"] = $row['titre_canonize']; $tab_result[$id]["url_vignette"] = $row['url_vignette']; $tab_result[$id]["url_image"] = $row['url_image']; $tab_result[$id]["url_image2"] = $row['url_image2']; $tab_result[$id]["categorie"] = $row['categorie']; $tab_result[$id]["titre_data1"] = Sql_prepareTexteAffichage($row['titre_data1']); $tab_result[$id]["data1"] = Sql_prepareTexteAffichage($row['data1']); $tab_result[$id]["titre_data2"] = Sql_prepareTexteAffichage($row['titre_data2']); $tab_result[$id]["data2"] = Lib_enToFr($row['data2']); $tab_result[$id]["titre_data3"] = Sql_prepareTexteAffichage($row['titre_data3']); $tab_result[$id]["data3"] = Lib_enToFr($row['data3']); $tab_result[$id]["titre_data4"] = Sql_prepareTexteAffichage($row['titre_data4']); $tab_result[$id]["data4"] = Lib_enToFr($row['data4']); $tab_result[$id]["titre_data5"] = Sql_prepareTexteAffichage($row['titre_data5']); $tab_result[$id]["data5"] = Sql_prepareTexteAffichage($row['data5']); $tab_result[$id]["titre_data6"] = Sql_prepareTexteAffichage($row['titre_data6']); $tab_result[$id]["data6"] = Sql_prepareTexteAffichage($row['data6']); $tab_result[$id]["titre_data7"] = Sql_prepareTexteAffichage($row['titre_data7']); $tab_result[$id]["data7"] = Sql_prepareTexteAffichage($row['data7']); $tab_result[$id]["titre_data8"] = Sql_prepareTexteAffichage($row['titre_data8']); $tab_result[$id]["data8"] = Sql_prepareTexteAffichage($row['data8']); $tab_result[$id]["titre_data9"] = Sql_prepareTexteAffichage($row['titre_data9']); $tab_result[$id]["data9"] = Sql_prepareTexteAffichage($row['data9']); $tab_result[$id]["titre_data10"] = Sql_prepareTexteAffichage($row['titre_data10']); $tab_result[$id]["data10"] = Sql_prepareTexteAffichage($row['data10']); $tab_result[$id]["titre_data11"] = Sql_prepareTexteAffichage($row['titre_data11']); $tab_result[$id]["data11"] = Sql_prepareTexteAffichage($row['data11']); $tab_result[$id]["titre_data12"] = Sql_prepareTexteAffichage($row['titre_data12']); $tab_result[$id]["data12"] = Sql_prepareTexteAffichage($row['data12']); $tab_result[$id]["titre_data13"] = Sql_prepareTexteAffichage($row['titre_data13']); $tab_result[$id]["data13"] = Sql_prepareTexteAffichage($row['data13']); $tab_result[$id]["titre_data14"] = Sql_prepareTexteAffichage($row['titre_data14']); $tab_result[$id]["data14"] = Sql_prepareTexteAffichage($row['data14']); $tab_result[$id]["titre_data15"] = Sql_prepareTexteAffichage($row['titre_data15']); $tab_result[$id]["data15"] = Sql_prepareTexteAffichage($row['data15']); $tab_result[$id]["titre_data16"] = Sql_prepareTexteAffichage($row['titre_data16']); $tab_result[$id]["data16"] = Sql_prepareTexteAffichage($row['data16']); $tab_result[$id]["titre_data17"] = Sql_prepareTexteAffichage($row['titre_data17']); $tab_result[$id]["data17"] = Sql_prepareTexteAffichage($row['data17']); $tab_result[$id]["titre_data18"] = Sql_prepareTexteAffichage($row['titre_data18']); $tab_result[$id]["data18"] = Sql_prepareTexteAffichage($row['data18']); $tab_result[$id]["titre_data19"] = Sql_prepareTexteAffichage($row['titre_data19']); $tab_result[$id]["data19"] = Sql_prepareTexteAffichage($row['data19']); $tab_result[$id]["titre_data20"] = Sql_prepareTexteAffichage($row['titre_data20']); $tab_result[$id]["data20"] = Sql_prepareTexteAffichage($row['data20']); $tab_result[$id]["titre_fichier1"] = Sql_prepareTexteAffichage($row['titre_fichier1']); $tab_result[$id]["fichier1"] = Sql_prepareTexteAffichage($row['fichier1']); $tab_result[$id]["titre_fichier2"] = Sql_prepareTexteAffichage($row['titre_fichier1']); $tab_result[$id]["fichier2"] = Sql_prepareTexteAffichage($row['fichier2']); $tab_result[$id]["titre_fichier3"] = Sql_prepareTexteAffichage($row['titre_fichier3']); $tab_result[$id]["fichier3"] = Sql_prepareTexteAffichage($row['fichier3']); $tab_result[$id]["titre_fichier4"] = Sql_prepareTexteAffichage($row['titre_fichier4']); $tab_result[$id]["fichier4"] = Sql_prepareTexteAffichage($row['fichier4']); $tab_result[$id]["titre_fichier5"] = Sql_prepareTexteAffichage($row['titre_fichier5']); $tab_result[$id]["fichier5"] = Sql_prepareTexteAffichage($row['fichier5']); $tab_result[$id]["date_add"] = $row['date_add']; $tab_result[$id]["date_upd"] = $row['date_upd']; $tab_result[$id]["info_tache"] = Sql_prepareTexteAffichage($row['info_tache']); } } if (count($tab_result) == 1 && ($args['id_tache'] != '' && $args['id_tache'] != '*')) { $tab_result = array_pop($tab_result); } if (count($tab_result) == 1 && $args['code'] != '' && $args['lang'] != '') { $tab_result = array_pop($tab_result); } return $tab_result; }
/** Retourne un tableau de commandes correspondant aux champs du tableau en argument. @param $args */ function Commandes_chercher($args) { $count = 0; $tab_result = array(); if (isset($args['count'])) { $sql = " SELECT count(*) nb_enregistrements \n\t\t\t\t\tFROM " . $GLOBALS['prefix'] . "commande\n\t\t\t\t\tWHERE 1"; } else { $sql = " SELECT * \n\t\t\t\t\tFROM " . $GLOBALS['prefix'] . "commande\n\t\t\t\t\tWHERE 1"; } if (!isset($args['id_commande']) && !isset($args['id_utilisateur']) && !isset($args['id_customer']) && !isset($args['id_pg_vg']) && !isset($args['date_commande']) && !isset($args['etat']) && !isset($args['order_by']) && !isset($args['etat']) && !isset($args['tab_ids_commandes'])) { return $tab_result; } $condition = ""; if (isset($args['id_commande']) && $args['id_commande'] != "*") { $condition .= " AND id_commande = '" . $args['id_commande'] . "' "; } if (isset($args['id_utilisateur']) && $args['id_utilisateur'] != "*") { $condition .= " AND id_utilisateur = '" . $args['id_utilisateur'] . "' "; } if (isset($args['id_customer']) && $args['id_customer'] != "*") { $condition .= " AND id_customer = '" . $args['id_customer'] . "' "; } if (isset($args['id_pg_vg']) && $args['id_pg_vg'] != "*") { $condition .= " AND id_pg_vg = '" . $args['id_pg_vg'] . "' "; } if (isset($args['date_commande']) && $args['date_commande'] != "*") { $condition .= " AND date_commande = '" . Lib_frToEn($args['date_commande']) . "' "; } if (isset($args['etat']) && $args['etat'] != "*") { $condition .= " AND etat = '" . $args['etat'] . "' "; } if (isset($args['tab_ids_commandes']) && $args['tab_ids_commandes'] != "*") { $ids = implode(",", $args['tab_ids_commandes']); $condition .= " AND id_commande IN (0" . $ids . ") "; } if (!isset($args['etat'])) { $condition .= " AND etat != 'supprime' "; } $sql .= $condition; if (isset($args['order_by']) && !isset($args['asc_desc'])) { $sql .= " ORDER BY " . $args['order_by'] . " ASC"; } if (isset($args['order_by']) && isset($args['asc_desc'])) { $sql .= " ORDER BY " . $args['order_by'] . " " . $args['asc_desc']; } if (isset($args['limit']) && !isset($args['start'])) { $sql .= " LIMIT " . $args['limit']; } if (isset($args['limit']) && isset($args['start'])) { $sql .= " LIMIT " . $args['start'] . "," . $args['limit']; } /*=============*/ Lib_myLog("SQL: {$sql}"); $result = Sql_query($sql); if (isset($args['count'])) { if ($result && Sql_errorCode($result) === "00000") { $row = Sql_fetch($result); $count = $row['nb_enregistrements']; } return $count; } else { if ($result && Sql_errorCode($result) === "00000") { while ($row = Sql_fetch($result)) { $id = $row['id_commande']; $tab_result[$id]["id_commande"] = $id; $tab_result[$id]["id_utilisateur"] = $row['id_utilisateur']; $tab_result[$id]["id_customer"] = $row['id_customer']; $tab_result[$id]["id_pg_vg"] = $row['id_pg_vg']; $tab_result[$id]["date_commande"] = Lib_enToFr($row['date_commande']); $tab_result[$id]["nb_imp"] = $row['nb_imp']; $tab_result[$id]["num_lot"] = Sql_prepareTexteAffichage($row['num_lot']); $tab_result[$id]["etat"] = $row['etat']; $tab_result[$id]["date_add"] = $row['date_add']; $tab_result[$id]["date_upd"] = $row['date_upd']; $tab_result[$id]["info_commande"] = Sql_prepareTexteAffichage($row['info_commande']); } } if (count($tab_result) == 1 && ($args['id_commande'] != '' && $args['id_commande'] != '*')) { $tab_result = array_pop($tab_result); } } return $tab_result; }
/** Retourne un tableau de reglements correspondant aux champs du tableau en argument. @param $args */ function Reglements_chercher($args) { $tab_result = array(); $sql = " SELECT * \n\t\t\t\tFROM " . $GLOBALS['prefix'] . "facture_reglements\n\t\t\t\tWHERE 1"; if (!isset($args['id_reglement']) && !isset($args['id_facture']) && !isset($args['date_reglement']) && !isset($args['id_mode_reglement']) && !isset($args['order_by']) && !isset($args['tab_ids_reglements'])) { return $tab_result; } $condition = ""; if (isset($args['id_reglement']) && $args['id_reglement'] != "*") { $condition .= " AND id_reglement = '" . $args['id_reglement'] . "' "; } if (isset($args['id_facture']) && $args['id_facture'] != "*") { $condition .= " AND id_facture = '" . $args['id_facture'] . "' "; } if (isset($args['date_reglement']) && $args['date_reglement'] != "*") { $condition .= " AND date_reglement = '" . Lib_frToEn($args['date_reglement']) . "' "; } if (isset($args['id_mode_reglement']) && $args['id_mode_reglement'] != "*") { $condition .= " AND id_mode_reglement = '" . $args['id_mode_reglement'] . "' "; } if (isset($args['tab_ids_reglements']) && $args['tab_ids_reglements'] != "*") { $ids = implode(",", $args['tab_ids_reglements']); $condition .= " AND id_reglement IN (0" . $ids . ") "; } $sql .= $condition; if (isset($args['order_by']) && !isset($args['asc_desc'])) { $sql .= " ORDER BY " . $args['order_by'] . " ASC"; } if (isset($args['order_by']) && isset($args['asc_desc'])) { $sql .= " ORDER BY " . $args['order_by'] . " " . $args['asc_desc']; } if (isset($args['limit']) && !isset($args['start'])) { $sql .= " LIMIT " . $args['limit']; } if (isset($args['limit']) && isset($args['start'])) { $sql .= " LIMIT " . $args['start'] . "," . $args['limit']; } /*=============*/ Lib_myLog("SQL: {$sql}"); $result = mysql_query($sql); if ($result) { while ($row = mysql_fetch_array($result)) { $id = $row['id_reglement']; $tab_result[$id]["id_reglement"] = $id; $tab_result[$id]["id_facture"] = $row['id_facture']; $tab_result[$id]["montant"] = $row['montant']; $tab_result[$id]["date_reglement"] = Lib_enToFr($row['date_reglement']); $tab_result[$id]["id_mode_reglement"] = $row['id_mode_reglement']; $tab_result[$id]["date_add"] = $row['date_add']; $tab_result[$id]["date_upd"] = $row['date_upd']; $tab_result[$id]["info_reglement"] = $row['info_reglement']; } } if (count($tab_result) == 1 && ($args['id_reglement'] != '' && $args['id_reglement'] != '*')) { $tab_result = array_pop($tab_result); } return $tab_result; }