[FogBugz #131] Retours longs (très long) #193
Loading…
Reference in New Issue
There is no content yet.
Delete Branch "%!s(<nil>)"
Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?
Assigned To: Frederik Benoist
Project: CAISSE
Area: awcaisse
Category: Bogue
Priority: A fixer impérativement
Event ID: 630
Date: 2013-07-31T13:58:58Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
avec l'optim pour la recherche tarifs
/* Formatted on 31/07/2013 15:43:32 (QP5 v5.206) */
SELECT a0a66a0a0.id_facturec AS a0a66a0a0a2587,
a0a66a0a0.id_ticket_caisse AS a0a66a0a0a2581,
a0a66a0a0.id_client AS a0a66a0a0a2588,
a0a66a0a0.xml_affichage_ticket AS a0a66a0a0a2586,
a0a66a0a0.xml_impression_ticket AS a0a66a0a0a2585,
a0a66a0a0.code_barre_fidelite AS a0a66a0a0a2591,
a0a66a0a0.id_client_prestataire AS a0a66a0a0a2592,
a0a66a0a0.fdate AS a0a66a0a0a2593,
a0a66a0a0.id_structure AS a0a66a0a0a2594,
a66a70a1a0.id_ligne AS a66a70a1a0a2747,
a66a70a1a0.id_produit AS a66a70a1a0a2742,
a66a70a1a0.id_taxe AS a66a70a1a0a2745,
a66a70a1a0.id_facturec AS a66a70a1a0a2741,
a66a70a1a0.montant AS a66a70a1a0a2744,
a66a70a1a0.montant_tva AS a66a70a1a0a2746,
a66a70a1a0.quantite AS a66a70a1a0a2743,
a66a70a1a0.quantite_apres_avoir AS a66a70a1a0a2748,
a66a70a1a0.avoir_partiel AS a66a70a1a0a2749,
a66a70a1a0.contre_valeur AS a66a70a1a0a2750,
a66a70a1a0.montant_remise AS a66a70a1a0a2751,
a66a70a1a0.montant_base AS a66a70a1a0a2752,
a66a70a1a0.id_mode_enlevement AS a66a70a1a0a2753,
a66a70a1a0.ecotaxe AS a66a70a1a0a2754,
a70a1a2a0.id_produit AS a70a1a2a0a1,
a70a1a2a0.id_famille AS a70a1a2a0a4,
a70a1a2a0.code_modele AS a70a1a2a0a3,
a70a1a2a0.id_type_produit AS a70a1a2a0a2,
a70a1a2a0.id_type_axe_valeur1 AS a70a1a2a0a6,
a70a1a2a0.id_type_axe_valeur2 AS a70a1a2a0a7,
a70a1a2a0.id_type_axe_valeur3 AS a70a1a2a0a8,
a70a1a2a0.id_type_axe_valeur4 AS a70a1a2a0a9,
a70a1a2a0.id_taxe AS a70a1a2a0a10,
a70a1a2a0.id_marque AS a70a1a2a0a21,
a70a1a2a0.id_structure AS a70a1a2a0a28,
a70a1a2a0.code_reference AS a70a1a2a0a11,
a70a1a2a0.nom AS a70a1a2a0a5,
a70a1a2a0.garantie_plantation AS a70a1a2a0a12,
a70a1a2a0.troc_axe1 AS a70a1a2a0a13,
a70a1a2a0.troc_axe2 AS a70a1a2a0a14,
a70a1a2a0.troc_axe3 AS a70a1a2a0a15,
a70a1a2a0.troc_axe4 AS a70a1a2a0a16,
a70a1a2a0.messagecentrale AS a70a1a2a0a17,
a70a1a2a0.ecotaxe AS a70a1a2a0a18,
a70a1a2a0.ecotaxe_tva AS a70a1a2a0a19,
a70a1a2a0.prix_vente AS a70a1a2a0a20,
a70a1a2a0.reference_constructeur AS a70a1a2a0a22,
a70a1a2a0.garantie_5_ans AS a70a1a2a0a26,
a70a1a2a0.garantieenpourcent AS a70a1a2a0a27,
a70a1a2a0.gestion_valeur AS a70a1a2a0a29,
a70a1a2a0.prochaine_reference AS a70a1a2a0a30,
a70a1a2a0.id_etat AS a70a1a2a0a31,
a70a1a2a0.annules AS a70a1a2a0a32,
a70a1a2a0.abandonnes AS a70a1a2a0a33,
a1a20a3a0.produit_bipable AS a1a20a3a0a722,
a1a20a3a0.id_type_produit AS a1a20a3a0a721,
a20a112a4a0.id_type_produit AS a20a112a4a0a5261,
a20a112a4a0.code AS a20a112a4a0a5262,
a20a112a4a0.libelle AS a20a112a4a0a5263,
a20a21a4a0.id_type_produit AS a20a21a4a0a761,
a20a21a4a0.id_distrib AS a20a21a4a0a762,
a20a21a4a0.accept_repart_remis_pd_tick AS a20a21a4a0a782,
a20a21a4a0.afficher_dans_panneau_bouton AS a20a21a4a0a777,
a20a21a4a0.autoriser_retour AS a20a21a4a0a775,
a20a21a4a0.couleur AS a20a21a4a0a776,
a20a21a4a0.dispo_mode_deconnecte AS a20a21a4a0a781,
a20a21a4a0.exclure_calcul_fidelisation AS a20a21a4a0a784,
a20a21a4a0.exclure_calcul_op_commercial AS a20a21a4a0a785,
a20a21a4a0.forcer_selection_consommateur AS a20a21a4a0a763,
a20a21a4a0.forcer_selection_motif AS a20a21a4a0a765,
a20a21a4a0.print_comme_ligne_sur_ticket AS a20a21a4a0a766,
a20a21a4a0.imprimer_en_pied_ticket AS a20a21a4a0a768,
a20a21a4a0.montant_mini AS a20a21a4a0a770,
a20a21a4a0.montant_modifiable AS a20a21a4a0a773,
a20a21a4a0.pourcentage_mini_total_ticket AS a20a21a4a0a771,
a20a21a4a0.quantite_modifiable AS a20a21a4a0a774,
a20a21a4a0.remise_interdite AS a20a21a4a0a783,
a20a21a4a0.saisie_montant AS a20a21a4a0a764,
a20a21a4a0.sens_accepte AS a20a21a4a0a769,
a20a21a4a0.texte_remplacement_mt_null AS a20a21a4a0a772,
a20a21a4a0.total_en_pied_ticket AS a20a21a4a0a767,
a20a21a4a0.type_remise_maxi AS a20a21a4a0a778,
a20a21a4a0.un_seul_par_ticket AS a20a21a4a0a780,
a20a21a4a0.valeur_remise_maxi AS a20a21a4a0a779,
a20a21a4a0.prefix_code_barre AS a20a21a4a0a786,
a20a21a4a0.longueur_code_barre AS a20a21a4a0a787,
a20a21a4a0.type_code_barre AS a20a21a4a0a788,
a20a21a4a0.id_type_bon_achat AS a20a21a4a0a789,
a20a21a4a0.gestion_stock AS a20a21a4a0a792,
a20a21a4a0.impressionba AS a20a21a4a0a791,
a21a26a5a0.id_type_produit AS a21a26a5a0a1001,
a21a26a5a0.id_distrib AS a21a26a5a0a1002,
a21a26a5a0.code_motif AS a21a26a5a0a1003,
a21a26a5a0.date_deb AS a21a26a5a0a1004,
a21a26a5a0.date_fin AS a21a26a5a0a1005,
a21a26a5a0.id_pays AS a21a26a5a0a1006,
a26a27a6a0.code_motif AS a26a27a6a0a1041,
a26a27a6a0.forcer_selection_vendeur AS a26a27a6a0a1044,
a26a27a6a0.autoris_saisie_nouveau_prix AS a26a27a6a0a1050,
a26a27a6a0.deductible_du_total_ticket AS a26a27a6a0a1049,
a26a27a6a0.deduire_remise_pour_retour AS a26a27a6a0a1048,
a26a27a6a0.detail_par_ligne_article AS a26a27a6a0a1046,
a26a27a6a0.libelle AS a26a27a6a0a1042,
a26a27a6a0.libellecourt AS a26a27a6a0a1043,
a26a27a6a0.message_sur_ticket AS a26a27a6a0a1051,
a26a27a6a0.possible_pour_pied_ticket AS a26a27a6a0a1056,
a26a27a6a0.possible_pour_sous_total AS a26a27a6a0a1055,
a26a27a6a0.saisie_commentaire AS a26a27a6a0a1045,
a26a27a6a0.sens_valeur_accepte AS a26a27a6a0a1052,
a26a27a6a0.total_en_pied_de_ticket AS a26a27a6a0a1047,
a26a27a6a0.type_valeur AS a26a27a6a0a1053,
a26a27a6a0.valeur_defaut AS a26a27a6a0a1054,
a26a27a6a0.restockage_produit_retour AS a26a27a6a0a1057,
a26a27a6a0.alimenter_panier_litige AS a26a27a6a0a1058,
a26a27a6a0.valeur_maxi AS a26a27a6a0a1059,
a27a103a7a0.code_motif AS a27a103a7a0a4901,
a27a103a7a0.code AS a27a103a7a0a4902,
a27a103a7a0.libelle AS a27a103a7a0a4903,
a27a103a7a0.libellecourt AS a27a103a7a0a4904,
a21a57a5a0.id_type_bon_achat AS a21a57a5a0a2241,
a21a57a5a0.prefix_code_barre AS a21a57a5a0a2242,
a21a57a5a0.libelle AS a21a57a5a0a2243,
a21a57a5a0.longueur AS a21a57a5a0a2244,
a21a57a5a0.TYPE AS a21a57a5a0a2245,
a21a57a5a0.duree_validite_en_jours AS a21a57a5a0a2246,
a21a57a5a0.remonter_client AS a21a57a5a0a2247,
a57a120a6a0.id_type_bon_achat AS a57a120a6a0a5581,
a57a120a6a0.id_distrib AS a57a120a6a0a5582,
a57a120a6a0.duree_validite_en_jours AS a57a120a6a0a5583,
a57a120a6a0.secable AS a57a120a6a0a5584,
a1a99a3a0.id_produit AS a1a99a3a0a4741,
a1a99a3a0.code AS a1a99a3a0a4742,
a1a99a3a0.nom AS a1a99a3a0a4743,
a1a99a3a0.troc_axe1 AS a1a99a3a0a4744,
a1a99a3a0.troc_axe2 AS a1a99a3a0a4745,
a1a99a3a0.troc_axe3 AS a1a99a3a0a4746,
a1a99a3a0.troc_axe4 AS a1a99a3a0a4747,
a1a99a3a0.messagecentrale AS a1a99a3a0a4748,
a1a15a3a0.id_produit AS a1a15a3a0a562,
a1a15a3a0.code_barre AS a1a15a3a0a561,
a1a126a3a0.id_distrib AS a1a126a3a0a5821,
a1a126a3a0.id_structure AS a1a126a3a0a5822,
a1a126a3a0.id_produit AS a1a126a3a0a5823,
a1a126a3a0.id_carte_fidelite_type AS a1a126a3a0a5825,
a1a126a3a0.garantie AS a1a126a3a0a5824,
a1a4a3a0.id_famille AS a1a4a3a0a81,
a1a4a3a0.id_famille_parent AS a1a4a3a0a82,
a1a4a3a0.id_type_axe1 AS a1a4a3a0a83,
a1a4a3a0.id_type_axe2 AS a1a4a3a0a84,
a1a4a3a0.id_type_axe3 AS a1a4a3a0a85,
a1a4a3a0.id_type_axe4 AS a1a4a3a0a86,
a1a4a3a0.niveau AS a1a4a3a0a87,
a1a4a3a0.id_couleur AS a1a4a3a0a89,
a1a4a3a0.nom AS a1a4a3a0a88,
a1a4a3a0.ecotaxe AS a1a4a3a0a90,
a1a4a3a0.garantie_par_defaut AS a1a4a3a0a91,
a1a4a3a0.saisie_serie AS a1a4a3a0a92,
a1a4a3a0.extension_garantie AS a1a4a3a0a93,
a1a4a3a0.code_externe AS a1a4a3a0a94,
a1a17a3a0.id AS a1a17a3a0a641,
a1a17a3a0.id_type_axe AS a1a17a3a0a642,
a1a17a3a0.id_principal AS a1a17a3a0a643,
a1a17a3a0.valeur AS a1a17a3a0a644,
a1a17a3a0.code_externe AS a1a17a3a0a645,
a17a18a4a0.id AS a17a18a4a0a681,
a17a18a4a0.code AS a17a18a4a0a682,
a17a18a4a0.libelle AS a17a18a4a0a683,
a17a18a4a0.valeur AS a17a18a4a0a684,
a17a18a4a0.code_externe AS a17a18a4a0a685,
a1a17a3a1.id AS a1a17a3a1a641,
a1a17a3a1.id_type_axe AS a1a17a3a1a642,
a1a17a3a1.id_principal AS a1a17a3a1a643,
a1a17a3a1.valeur AS a1a17a3a1a644,
a1a17a3a1.code_externe AS a1a17a3a1a645,
a17a18a4a1.id AS a17a18a4a1a681,
a17a18a4a1.code AS a17a18a4a1a682,
a17a18a4a1.libelle AS a17a18a4a1a683,
a17a18a4a1.valeur AS a17a18a4a1a684,
a17a18a4a1.code_externe AS a17a18a4a1a685,
a1a17a3a2.id AS a1a17a3a2a641,
a1a17a3a2.id_type_axe AS a1a17a3a2a642,
a1a17a3a2.id_principal AS a1a17a3a2a643,
a1a17a3a2.valeur AS a1a17a3a2a644,
a1a17a3a2.code_externe AS a1a17a3a2a645,
a1a17a3a3.id AS a1a17a3a3a641,
a1a17a3a3.id_type_axe AS a1a17a3a3a642,
a1a17a3a3.id_principal AS a1a17a3a3a643,
a1a17a3a3.valeur AS a1a17a3a3a644,
a1a17a3a3.code_externe AS a1a17a3a3a645,
a1a91a3a0.id_ligne AS a1a91a3a0a4381,
a1a91a3a0.id_catalogue AS a1a91a3a0a4382,
a1a91a3a0.id_produit AS a1a91a3a0a4383,
a1a134a3a0.id_marque AS a1a134a3a0a6141,
a1a134a3a0.nom AS a1a134a3a0a6142,
a1a95a3a0.id_produit AS a1a95a3a0a4581,
a1a95a3a0.id_pays AS a1a95a3a0a4582,
a1a95a3a0.ecotaxe AS a1a95a3a0a4583,
a70a24a2a0.id_taxe AS a70a24a2a0a921,
a70a24a2a0.nom AS a70a24a2a0a922,
a24a25a3a0.id_pays AS a24a25a3a0a961,
a24a25a3a0.id_taxe AS a24a25a3a0a962,
a24a25a3a0.pourcentage AS a24a25a3a0a963,
a24a25a3a0.nom AS a24a25a3a0a964,
a25a161a4a0.id_pays AS a25a161a4a0a7122,
a25a161a4a0.id_taxe AS a25a161a4a0a7121,
a25a161a4a0.date_deb AS a25a161a4a0a7123,
a25a161a4a0.pourcentage AS a25a161a4a0a7125,
a25a161a4a0.date_fin AS a25a161a4a0a7124,
a66a38a1a0.id_client AS a66a38a1a0a1521,
a66a38a1a0.id_structure AS a66a38a1a0a1525,
a66a38a1a0.id_titre AS a66a38a1a0a1524,
a66a38a1a0.nom AS a66a38a1a0a1522,
a66a38a1a0.prenom AS a66a38a1a0a1523,
a66a38a1a0.mail AS a66a38a1a0a1526,
a66a38a1a0.en_compte AS a66a38a1a0a1527,
a66a38a1a0.code_externe AS a66a38a1a0a1528,
a66a38a1a0.compteurnpai AS a66a38a1a0a1529,
a66a38a1a0.client_prestataire AS a66a38a1a0a1530,
a66a38a1a0.numero_id_fiscale AS a66a38a1a0a1531,
a66a38a1a0.fdate AS a66a38a1a0a1532,
a66a38a1a0.vip AS a66a38a1a0a1533,
a66a38a1a0.email_invalide AS a66a38a1a0a1534,
a66a38a1a0.tva_intraco AS a66a38a1a0a1535,
a66a38a1a0.bloque AS a66a38a1a0a1536,
a66a38a1a0.encours_maximum_autorise AS a66a38a1a0a1537,
a66a38a1a0.compteur_npei AS a66a38a1a0a1538,
a66a38a1a0.assujetti_tva AS a66a38a1a0a1539,
a66a33a1a0.id_structure AS a66a33a1a0a1321,
a66a33a1a0.id_devise AS a66a33a1a0a1324,
a66a33a1a0.id_pays3 AS a66a33a1a0a1325,
a66a33a1a0.id_distrib AS a66a33a1a0a1326,
a66a33a1a0.id_cp3 AS a66a33a1a0a1330,
a66a33a1a0.id_taxe AS a66a33a1a0a1334,
a66a33a1a0.num_interne AS a66a33a1a0a1336,
a66a33a1a0.nom AS a66a33a1a0a1322,
a66a33a1a0.enseigne AS a66a33a1a0a1323,
a66a33a1a0.adresse1 AS a66a33a1a0a1327,
a66a33a1a0.adresse2 AS a66a33a1a0a1328,
a66a33a1a0.adresse3 AS a66a33a1a0a1329,
a66a33a1a0.tel3 AS a66a33a1a0a1331,
a66a33a1a0.fax3 AS a66a33a1a0a1332,
a66a33a1a0.mail AS a66a33a1a0a1333,
a66a33a1a0.droits_speciaux AS a66a33a1a0a1335,
a66a33a1a0.cp_sur_ticket AS a66a33a1a0a1337,
a66a33a1a0.campagne_chalandise_debut AS a66a33a1a0a1338,
a66a33a1a0.campagne_chalandise_fin AS a66a33a1a0a1339,
a66a33a1a0.decalage_horaire_ete AS a66a33a1a0a1340,
a66a33a1a0.decalage_horaire_hiver AS a66a33a1a0a1341,
a66a33a1a0.langue AS a66a33a1a0a1342,
a66a33a1a0.tel_sav AS a66a33a1a0a1343,
a66a33a1a0.capital_social AS a66a33a1a0a1344,
a66a33a1a0.type_societe AS a66a33a1a0a1345,
a66a33a1a0.num_siret AS a66a33a1a0a1346,
a66a33a1a0.numero_rc AS a66a33a1a0a1347,
a66a33a1a0.num_tva AS a66a33a1a0a1348,
a66a33a1a0.numero_id_fiscale AS a66a33a1a0a1349,
a66a33a1a0.id_niveau AS a66a33a1a0a1350,
a66a33a1a0.id_structure_parent AS a66a33a1a0a1351,
a66a33a1a0.structures_parents AS a66a33a1a0a1352,
a66a33a1a0.prefix_ip AS a66a33a1a0a1353,
a66a33a1a0.nb_factures AS a66a33a1a0a1354,
a66a33a1a0.nbre_jour_validite_pwd AS a66a33a1a0a1355,
a66a33a1a0.denominationsociale AS a66a33a1a0a1356,
a66a33a1a0.mentionlegale AS a66a33a1a0a1357,
a66a33a1a0.gpslatitude AS a66a33a1a0a1358,
a66a33a1a0.gpslongitude AS a66a33a1a0a1359,
a66a33a1a0.horaires_jours_ouverture AS a66a33a1a0a1360,
a66a33a1a0.ecommerce AS a66a33a1a0a1361
FROM ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( client_facture a0a66a0a0
LEFT OUTER JOIN
client_facture_ligne a66a70a1a0
ON (a0a66a0a0.id_facturec =
a66a70a1a0.id_facturec))
LEFT OUTER JOIN
produit a70a1a2a0
ON (a66a70a1a0.id_produit =
a70a1a2a0.id_produit))
INNER JOIN
produit_type a1a20a3a0
ON (a70a1a2a0.id_type_produit =
a1a20a3a0.id_type_produit))
LEFT OUTER JOIN
language_produit_type a20a112a4a0
ON (a1a20a3a0.id_type_produit =
a20a112a4a0.id_type_produit)
AND ( (a20a112a4a0.code =
'1')))
LEFT OUTER JOIN
produit_type_distrib a20a21a4a0
ON (a1a20a3a0.id_type_produit =
a20a21a4a0.id_type_produit)
AND ( (a20a21a4a0.id_distrib =
'3')))
LEFT OUTER JOIN
produit_type_distrib_motif a21a26a5a0
ON ( a20a21a4a0.id_type_produit =
a21a26a5a0.id_type_produit
AND a20a21a4a0.id_distrib =
a21a26a5a0.id_distrib)
AND ( (a21a26a5a0.id_distrib =
'3')))
LEFT OUTER JOIN
motif a26a27a6a0
ON (a21a26a5a0.code_motif =
a26a27a6a0.code_motif))
LEFT OUTER JOIN
language_motif a27a103a7a0
ON (a26a27a6a0.code_motif =
a27a103a7a0.code_motif)
AND ( (a27a103a7a0.code =
'1')))
LEFT OUTER JOIN
param_type_bon_achat a21a57a5a0
ON (a20a21a4a0.id_type_bon_achat =
a21a57a5a0.id_type_bon_achat))
LEFT OUTER JOIN
param_type_bon_achat_distrib a57a120a6a0
ON (a21a57a5a0.id_type_bon_achat =
a57a120a6a0.id_type_bon_achat)
AND ( (a57a120a6a0.id_distrib =
'3')))
LEFT OUTER JOIN
language_produit a1a99a3a0
ON (a70a1a2a0.id_produit =
a1a99a3a0.id_produit)
AND ( (a1a99a3a0.code =
'1')))
LEFT OUTER JOIN
produit_code_barre a1a15a3a0
ON (a70a1a2a0.id_produit =
a1a15a3a0.id_produit))
LEFT OUTER JOIN
produit_structure_garantie a1a126a3a0
ON (a70a1a2a0.id_produit =
a1a126a3a0.id_produit)
AND ( (a1a126a3a0.id_distrib =
'3')))
LEFT OUTER JOIN
produit_famille a1a4a3a0
ON (a70a1a2a0.id_famille =
a1a4a3a0.id_famille))
LEFT OUTER JOIN
param_axe_valeur a1a17a3a0
ON (a70a1a2a0.id_type_axe_valeur1 =
a1a17a3a0.id))
LEFT OUTER JOIN
language_param_axe_valeur a17a18a4a0
ON (a1a17a3a0.id =
a17a18a4a0.id))
LEFT OUTER JOIN
param_axe_valeur a1a17a3a1
ON (a70a1a2a0.id_type_axe_valeur2 =
a1a17a3a1.id))
LEFT OUTER JOIN
language_param_axe_valeur a17a18a4a1
ON (a1a17a3a1.id =
a17a18a4a1.id))
LEFT OUTER JOIN
param_axe_valeur a1a17a3a2
ON (a70a1a2a0.id_type_axe_valeur3 =
a1a17a3a2.id))
LEFT OUTER JOIN
param_axe_valeur a1a17a3a3
ON (a70a1a2a0.id_type_axe_valeur4 =
a1a17a3a3.id))
LEFT OUTER JOIN
catalogue_ligne a1a91a3a0
ON (a70a1a2a0.id_produit =
a1a91a3a0.id_produit)
AND ( (a1a91a3a0.id_catalogue IN
(SELECT csp.id_catalogue
FROM catalogue_structure_promo csp
WHERE csp.id_structure =
1283))))
LEFT OUTER JOIN
marque a1a134a3a0
ON (a70a1a2a0.id_marque =
a1a134a3a0.id_marque))
LEFT OUTER JOIN
produit_ecopart_pays a1a95a3a0
ON (a70a1a2a0.id_produit =
a1a95a3a0.id_produit)
AND ( (a1a95a3a0.id_pays = '20')))
LEFT OUTER JOIN
param_taxes a70a24a2a0
ON (a66a70a1a0.id_taxe = a70a24a2a0.id_taxe))
LEFT OUTER JOIN
param_taxes_valeur a24a25a3a0
ON (a70a24a2a0.id_taxe = a24a25a3a0.id_taxe)
AND ( (a24a25a3a0.id_pays = '20')))
LEFT OUTER JOIN
param_taxes_valeur_histo a25a161a4a0
ON ( a24a25a3a0.id_pays = a25a161a4a0.id_pays
AND a24a25a3a0.id_taxe = a25a161a4a0.id_taxe))
LEFT OUTER JOIN
client a66a38a1a0
ON (a0a66a0a0.id_client = a66a38a1a0.id_client))
LEFT OUTER JOIN
structure a66a33a1a0
ON (a0a66a0a0.id_structure = a66a33a1a0.id_structure))
WHERE (a0a66a0a0.id_ticket_caisse = '12830100000001')
Event ID: 601
Date: 2013-07-02T14:06:46Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
Pour le ce ticket la requête retour 10656 lignes / 268 colonnes
dont les coordonnées GPS de la boutique ....
1 min à parser en XML ...
Event ID: 600
Date: 2013-07-02T14:01:35Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
/* Formatted on 02-juil.-2013 15:40:48 (QP5 v5.206) */
SELECT a0a66a0a0.id_facturec AS a0a66a0a0a2587,
a0a66a0a0.id_ticket_caisse AS a0a66a0a0a2581,
a0a66a0a0.id_client AS a0a66a0a0a2588,
a0a66a0a0.xml_affichage_ticket AS a0a66a0a0a2586,
a0a66a0a0.xml_impression_ticket AS a0a66a0a0a2585,
a0a66a0a0.code_barre_fidelite AS a0a66a0a0a2591,
a0a66a0a0.id_client_prestataire AS a0a66a0a0a2592,
a0a66a0a0.fdate AS a0a66a0a0a2593,
a0a66a0a0.id_structure AS a0a66a0a0a2594,
a66a70a1a0.id_ligne AS a66a70a1a0a2747,
a66a70a1a0.id_produit AS a66a70a1a0a2742,
a66a70a1a0.id_taxe AS a66a70a1a0a2745,
a66a70a1a0.id_facturec AS a66a70a1a0a2741,
a66a70a1a0.montant AS a66a70a1a0a2744,
a66a70a1a0.montant_tva AS a66a70a1a0a2746,
a66a70a1a0.quantite AS a66a70a1a0a2743,
a66a70a1a0.quantite_apres_avoir AS a66a70a1a0a2748,
a66a70a1a0.avoir_partiel AS a66a70a1a0a2749,
a66a70a1a0.contre_valeur AS a66a70a1a0a2750,
a66a70a1a0.montant_remise AS a66a70a1a0a2751,
a66a70a1a0.montant_base AS a66a70a1a0a2752,
a66a70a1a0.id_mode_enlevement AS a66a70a1a0a2753,
a66a70a1a0.ecotaxe AS a66a70a1a0a2754,
a70a1a2a0.id_produit AS a70a1a2a0a1,
a70a1a2a0.id_famille AS a70a1a2a0a4,
a70a1a2a0.code_modele AS a70a1a2a0a3,
a70a1a2a0.id_type_produit AS a70a1a2a0a2,
a70a1a2a0.id_type_axe_valeur1 AS a70a1a2a0a6,
a70a1a2a0.id_type_axe_valeur2 AS a70a1a2a0a7,
a70a1a2a0.id_type_axe_valeur3 AS a70a1a2a0a8,
a70a1a2a0.id_type_axe_valeur4 AS a70a1a2a0a9,
a70a1a2a0.id_taxe AS a70a1a2a0a10,
a70a1a2a0.id_marque AS a70a1a2a0a21,
a70a1a2a0.id_structure AS a70a1a2a0a28,
a70a1a2a0.code_reference AS a70a1a2a0a11,
a70a1a2a0.nom AS a70a1a2a0a5,
a70a1a2a0.garantie_plantation AS a70a1a2a0a12,
a70a1a2a0.troc_axe1 AS a70a1a2a0a13,
a70a1a2a0.troc_axe2 AS a70a1a2a0a14,
a70a1a2a0.troc_axe3 AS a70a1a2a0a15,
a70a1a2a0.troc_axe4 AS a70a1a2a0a16,
a70a1a2a0.messagecentrale AS a70a1a2a0a17,
a70a1a2a0.ecotaxe AS a70a1a2a0a18,
a70a1a2a0.ecotaxe_tva AS a70a1a2a0a19,
a70a1a2a0.prix_vente AS a70a1a2a0a20,
a70a1a2a0.reference_constructeur AS a70a1a2a0a22,
a70a1a2a0.garantie_5_ans AS a70a1a2a0a26,
a70a1a2a0.garantieenpourcent AS a70a1a2a0a27,
a70a1a2a0.gestion_valeur AS a70a1a2a0a29,
a70a1a2a0.prochaine_reference AS a70a1a2a0a30,
a70a1a2a0.id_etat AS a70a1a2a0a31,
a70a1a2a0.annules AS a70a1a2a0a32,
a70a1a2a0.abandonnes AS a70a1a2a0a33,
a1a20a3a0.produit_bipable AS a1a20a3a0a722,
a1a20a3a0.id_type_produit AS a1a20a3a0a721,
a20a112a4a0.id_type_produit AS a20a112a4a0a5261,
a20a112a4a0.code AS a20a112a4a0a5262,
a20a112a4a0.libelle AS a20a112a4a0a5263,
a20a21a4a0.id_type_produit AS a20a21a4a0a761,
a20a21a4a0.id_distrib AS a20a21a4a0a762,
a20a21a4a0.accept_repart_remis_pd_tick AS a20a21a4a0a782,
a20a21a4a0.afficher_dans_panneau_bouton AS a20a21a4a0a777,
a20a21a4a0.autoriser_retour AS a20a21a4a0a775,
a20a21a4a0.couleur AS a20a21a4a0a776,
a20a21a4a0.dispo_mode_deconnecte AS a20a21a4a0a781,
a20a21a4a0.exclure_calcul_fidelisation AS a20a21a4a0a784,
a20a21a4a0.exclure_calcul_op_commercial AS a20a21a4a0a785,
a20a21a4a0.forcer_selection_consommateur AS a20a21a4a0a763,
a20a21a4a0.forcer_selection_motif AS a20a21a4a0a765,
a20a21a4a0.print_comme_ligne_sur_ticket AS a20a21a4a0a766,
a20a21a4a0.imprimer_en_pied_ticket AS a20a21a4a0a768,
a20a21a4a0.montant_mini AS a20a21a4a0a770,
a20a21a4a0.montant_modifiable AS a20a21a4a0a773,
a20a21a4a0.pourcentage_mini_total_ticket AS a20a21a4a0a771,
a20a21a4a0.quantite_modifiable AS a20a21a4a0a774,
a20a21a4a0.remise_interdite AS a20a21a4a0a783,
a20a21a4a0.saisie_montant AS a20a21a4a0a764,
a20a21a4a0.sens_accepte AS a20a21a4a0a769,
a20a21a4a0.texte_remplacement_mt_null AS a20a21a4a0a772,
a20a21a4a0.total_en_pied_ticket AS a20a21a4a0a767,
a20a21a4a0.type_remise_maxi AS a20a21a4a0a778,
a20a21a4a0.un_seul_par_ticket AS a20a21a4a0a780,
a20a21a4a0.valeur_remise_maxi AS a20a21a4a0a779,
a20a21a4a0.prefix_code_barre AS a20a21a4a0a786,
a20a21a4a0.longueur_code_barre AS a20a21a4a0a787,
a20a21a4a0.type_code_barre AS a20a21a4a0a788,
a20a21a4a0.id_type_bon_achat AS a20a21a4a0a789,
a20a21a4a0.gestion_stock AS a20a21a4a0a792,
a20a21a4a0.impressionba AS a20a21a4a0a791,
a21a26a5a0.id_type_produit AS a21a26a5a0a1001,
a21a26a5a0.id_distrib AS a21a26a5a0a1002,
a21a26a5a0.code_motif AS a21a26a5a0a1003,
a21a26a5a0.date_deb AS a21a26a5a0a1004,
a21a26a5a0.date_fin AS a21a26a5a0a1005,
a21a26a5a0.id_pays AS a21a26a5a0a1006,
a26a27a6a0.code_motif AS a26a27a6a0a1041,
a26a27a6a0.forcer_selection_vendeur AS a26a27a6a0a1044,
a26a27a6a0.autoris_saisie_nouveau_prix AS a26a27a6a0a1050,
a26a27a6a0.deductible_du_total_ticket AS a26a27a6a0a1049,
a26a27a6a0.deduire_remise_pour_retour AS a26a27a6a0a1048,
a26a27a6a0.detail_par_ligne_article AS a26a27a6a0a1046,
a26a27a6a0.libelle AS a26a27a6a0a1042,
a26a27a6a0.libellecourt AS a26a27a6a0a1043,
a26a27a6a0.message_sur_ticket AS a26a27a6a0a1051,
a26a27a6a0.possible_pour_pied_ticket AS a26a27a6a0a1056,
a26a27a6a0.possible_pour_sous_total AS a26a27a6a0a1055,
a26a27a6a0.saisie_commentaire AS a26a27a6a0a1045,
a26a27a6a0.sens_valeur_accepte AS a26a27a6a0a1052,
a26a27a6a0.total_en_pied_de_ticket AS a26a27a6a0a1047,
a26a27a6a0.type_valeur AS a26a27a6a0a1053,
a26a27a6a0.valeur_defaut AS a26a27a6a0a1054,
a26a27a6a0.restockage_produit_retour AS a26a27a6a0a1057,
a26a27a6a0.alimenter_panier_litige AS a26a27a6a0a1058,
a26a27a6a0.valeur_maxi AS a26a27a6a0a1059,
a27a103a7a0.code_motif AS a27a103a7a0a4901,
a27a103a7a0.code AS a27a103a7a0a4902,
a27a103a7a0.libelle AS a27a103a7a0a4903,
a27a103a7a0.libellecourt AS a27a103a7a0a4904,
a21a57a5a0.id_type_bon_achat AS a21a57a5a0a2241,
a21a57a5a0.prefix_code_barre AS a21a57a5a0a2242,
a21a57a5a0.libelle AS a21a57a5a0a2243,
a21a57a5a0.longueur AS a21a57a5a0a2244,
a21a57a5a0.TYPE AS a21a57a5a0a2245,
a21a57a5a0.duree_validite_en_jours AS a21a57a5a0a2246,
a21a57a5a0.remonter_client AS a21a57a5a0a2247,
a57a120a6a0.id_type_bon_achat AS a57a120a6a0a5581,
a57a120a6a0.id_distrib AS a57a120a6a0a5582,
a57a120a6a0.duree_validite_en_jours AS a57a120a6a0a5583,
a57a120a6a0.secable AS a57a120a6a0a5584,
a1a99a3a0.id_produit AS a1a99a3a0a4741,
a1a99a3a0.code AS a1a99a3a0a4742,
a1a99a3a0.nom AS a1a99a3a0a4743,
a1a99a3a0.troc_axe1 AS a1a99a3a0a4744,
a1a99a3a0.troc_axe2 AS a1a99a3a0a4745,
a1a99a3a0.troc_axe3 AS a1a99a3a0a4746,
a1a99a3a0.troc_axe4 AS a1a99a3a0a4747,
a1a99a3a0.messagecentrale AS a1a99a3a0a4748,
a1a15a3a0.id_produit AS a1a15a3a0a562,
a1a15a3a0.code_barre AS a1a15a3a0a561,
a1a126a3a0.id_distrib AS a1a126a3a0a5821,
a1a126a3a0.id_structure AS a1a126a3a0a5822,
a1a126a3a0.id_produit AS a1a126a3a0a5823,
a1a126a3a0.id_carte_fidelite_type AS a1a126a3a0a5825,
a1a126a3a0.garantie AS a1a126a3a0a5824,
a1a4a3a0.id_famille AS a1a4a3a0a81,
a1a4a3a0.id_famille_parent AS a1a4a3a0a82,
a1a4a3a0.id_type_axe1 AS a1a4a3a0a83,
a1a4a3a0.id_type_axe2 AS a1a4a3a0a84,
a1a4a3a0.id_type_axe3 AS a1a4a3a0a85,
a1a4a3a0.id_type_axe4 AS a1a4a3a0a86,
a1a4a3a0.niveau AS a1a4a3a0a87,
a1a4a3a0.id_couleur AS a1a4a3a0a89,
a1a4a3a0.nom AS a1a4a3a0a88,
a1a4a3a0.ecotaxe AS a1a4a3a0a90,
a1a4a3a0.garantie_par_defaut AS a1a4a3a0a91,
a1a4a3a0.saisie_serie AS a1a4a3a0a92,
a1a4a3a0.extension_garantie AS a1a4a3a0a93,
a1a4a3a0.code_externe AS a1a4a3a0a94,
a1a17a3a0.id AS a1a17a3a0a641,
a1a17a3a0.id_type_axe AS a1a17a3a0a642,
a1a17a3a0.id_principal AS a1a17a3a0a643,
a1a17a3a0.valeur AS a1a17a3a0a644,
a1a17a3a0.code_externe AS a1a17a3a0a645,
a17a18a4a0.id AS a17a18a4a0a681,
a17a18a4a0.code AS a17a18a4a0a682,
a17a18a4a0.libelle AS a17a18a4a0a683,
a17a18a4a0.valeur AS a17a18a4a0a684,
a17a18a4a0.code_externe AS a17a18a4a0a685,
a1a17a3a1.id AS a1a17a3a1a641,
a1a17a3a1.id_type_axe AS a1a17a3a1a642,
a1a17a3a1.id_principal AS a1a17a3a1a643,
a1a17a3a1.valeur AS a1a17a3a1a644,
a1a17a3a1.code_externe AS a1a17a3a1a645,
a17a18a4a1.id AS a17a18a4a1a681,
a17a18a4a1.code AS a17a18a4a1a682,
a17a18a4a1.libelle AS a17a18a4a1a683,
a17a18a4a1.valeur AS a17a18a4a1a684,
a17a18a4a1.code_externe AS a17a18a4a1a685,
a1a17a3a2.id AS a1a17a3a2a641,
a1a17a3a2.id_type_axe AS a1a17a3a2a642,
a1a17a3a2.id_principal AS a1a17a3a2a643,
a1a17a3a2.valeur AS a1a17a3a2a644,
a1a17a3a2.code_externe AS a1a17a3a2a645,
a1a17a3a3.id AS a1a17a3a3a641,
a1a17a3a3.id_type_axe AS a1a17a3a3a642,
a1a17a3a3.id_principal AS a1a17a3a3a643,
a1a17a3a3.valeur AS a1a17a3a3a644,
a1a17a3a3.code_externe AS a1a17a3a3a645,
a1a91a3a0.id_ligne AS a1a91a3a0a4381,
a1a91a3a0.id_catalogue AS a1a91a3a0a4382,
a1a91a3a0.id_produit AS a1a91a3a0a4383,
a1a134a3a0.id_marque AS a1a134a3a0a6141,
a1a134a3a0.nom AS a1a134a3a0a6142,
a1a95a3a0.id_produit AS a1a95a3a0a4581,
a1a95a3a0.id_pays AS a1a95a3a0a4582,
a1a95a3a0.ecotaxe AS a1a95a3a0a4583,
a70a24a2a0.id_taxe AS a70a24a2a0a921,
a70a24a2a0.nom AS a70a24a2a0a922,
a24a25a3a0.id_pays AS a24a25a3a0a961,
a24a25a3a0.id_taxe AS a24a25a3a0a962,
a24a25a3a0.pourcentage AS a24a25a3a0a963,
a24a25a3a0.nom AS a24a25a3a0a964,
a25a161a4a0.id_pays AS a25a161a4a0a7122,
a25a161a4a0.id_taxe AS a25a161a4a0a7121,
a25a161a4a0.date_deb AS a25a161a4a0a7123,
a25a161a4a0.pourcentage AS a25a161a4a0a7125,
a25a161a4a0.date_fin AS a25a161a4a0a7124,
a66a38a1a0.id_client AS a66a38a1a0a1521,
a66a38a1a0.id_structure AS a66a38a1a0a1525,
a66a38a1a0.id_titre AS a66a38a1a0a1524,
a66a38a1a0.nom AS a66a38a1a0a1522,
a66a38a1a0.prenom AS a66a38a1a0a1523,
a66a38a1a0.mail AS a66a38a1a0a1526,
a66a38a1a0.en_compte AS a66a38a1a0a1527,
a66a38a1a0.code_externe AS a66a38a1a0a1528,
a66a38a1a0.compteurnpai AS a66a38a1a0a1529,
a66a38a1a0.client_prestataire AS a66a38a1a0a1530,
a66a38a1a0.numero_id_fiscale AS a66a38a1a0a1531,
a66a38a1a0.fdate AS a66a38a1a0a1532,
a66a38a1a0.vip AS a66a38a1a0a1533,
a66a38a1a0.email_invalide AS a66a38a1a0a1534,
a66a38a1a0.tva_intraco AS a66a38a1a0a1535,
a66a38a1a0.bloque AS a66a38a1a0a1536,
a66a38a1a0.encours_maximum_autorise AS a66a38a1a0a1537,
a66a38a1a0.compteur_npei AS a66a38a1a0a1538,
a66a38a1a0.assujetti_tva AS a66a38a1a0a1539,
a66a33a1a0.id_structure AS a66a33a1a0a1321,
a66a33a1a0.id_devise AS a66a33a1a0a1324,
a66a33a1a0.id_pays3 AS a66a33a1a0a1325,
a66a33a1a0.id_distrib AS a66a33a1a0a1326,
a66a33a1a0.id_cp3 AS a66a33a1a0a1330,
a66a33a1a0.id_taxe AS a66a33a1a0a1334,
a66a33a1a0.num_interne AS a66a33a1a0a1336,
a66a33a1a0.nom AS a66a33a1a0a1322,
a66a33a1a0.enseigne AS a66a33a1a0a1323,
a66a33a1a0.adresse1 AS a66a33a1a0a1327,
a66a33a1a0.adresse2 AS a66a33a1a0a1328,
a66a33a1a0.adresse3 AS a66a33a1a0a1329,
a66a33a1a0.tel3 AS a66a33a1a0a1331,
a66a33a1a0.fax3 AS a66a33a1a0a1332,
a66a33a1a0.mail AS a66a33a1a0a1333,
a66a33a1a0.droits_speciaux AS a66a33a1a0a1335,
a66a33a1a0.cp_sur_ticket AS a66a33a1a0a1337,
a66a33a1a0.campagne_chalandise_debut AS a66a33a1a0a1338,
a66a33a1a0.campagne_chalandise_fin AS a66a33a1a0a1339,
a66a33a1a0.decalage_horaire_ete AS a66a33a1a0a1340,
a66a33a1a0.decalage_horaire_hiver AS a66a33a1a0a1341,
a66a33a1a0.langue AS a66a33a1a0a1342,
a66a33a1a0.tel_sav AS a66a33a1a0a1343,
a66a33a1a0.capital_social AS a66a33a1a0a1344,
a66a33a1a0.type_societe AS a66a33a1a0a1345,
a66a33a1a0.num_siret AS a66a33a1a0a1346,
a66a33a1a0.numero_rc AS a66a33a1a0a1347,
a66a33a1a0.num_tva AS a66a33a1a0a1348,
a66a33a1a0.numero_id_fiscale AS a66a33a1a0a1349,
a66a33a1a0.id_niveau AS a66a33a1a0a1350,
a66a33a1a0.id_structure_parent AS a66a33a1a0a1351,
a66a33a1a0.structures_parents AS a66a33a1a0a1352,
a66a33a1a0.prefix_ip AS a66a33a1a0a1353,
a66a33a1a0.nb_factures AS a66a33a1a0a1354,
a66a33a1a0.nbre_jour_validite_pwd AS a66a33a1a0a1355,
a66a33a1a0.denominationsociale AS a66a33a1a0a1356,
a66a33a1a0.mentionlegale AS a66a33a1a0a1357,
a66a33a1a0.latitude AS a66a33a1a0a1358,
a66a33a1a0.gpslongitude AS a66a33a1a0a1359,
a66a33a1a0.horaires_jours_ouverture AS a66a33a1a0a1360,
a66a33a1a0.ecommerce AS a66a33a1a0a1361
FROM ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( client_facture a0a66a0a0
LEFT OUTER JOIN
client_facture_ligne a66a70a1a0
ON (a0a66a0a0.id_facturec =
a66a70a1a0.id_facturec))
LEFT OUTER JOIN
produit a70a1a2a0
ON (a66a70a1a0.id_produit =
a70a1a2a0.id_produit))
INNER JOIN
produit_type a1a20a3a0
ON (a70a1a2a0.id_type_produit =
a1a20a3a0.id_type_produit))
LEFT OUTER JOIN
language_produit_type a20a112a4a0
ON (a1a20a3a0.id_type_produit =
a20a112a4a0.id_type_produit)
AND ( (a20a112a4a0.code =
'1')))
LEFT OUTER JOIN
produit_type_distrib a20a21a4a0
ON (a1a20a3a0.id_type_produit =
a20a21a4a0.id_type_produit)
AND ( (a20a21a4a0.id_distrib =
'3')))
LEFT OUTER JOIN
produit_type_distrib_motif a21a26a5a0
ON ( a20a21a4a0.id_type_produit =
a21a26a5a0.id_type_produit
AND a20a21a4a0.id_distrib =
a21a26a5a0.id_distrib)
AND ( (a21a26a5a0.id_distrib =
'3')))
LEFT OUTER JOIN
motif a26a27a6a0
ON (a21a26a5a0.code_motif =
a26a27a6a0.code_motif))
LEFT OUTER JOIN
language_motif a27a103a7a0
ON (a26a27a6a0.code_motif =
a27a103a7a0.code_motif)
AND ( (a27a103a7a0.code =
'1')))
LEFT OUTER JOIN
param_type_bon_achat a21a57a5a0
ON (a20a21a4a0.id_type_bon_achat =
a21a57a5a0.id_type_bon_achat))
LEFT OUTER JOIN
param_type_bon_achat_distrib a57a120a6a0
ON (a21a57a5a0.id_type_bon_achat =
a57a120a6a0.id_type_bon_achat)
AND ( (a57a120a6a0.id_distrib =
'3')))
LEFT OUTER JOIN
language_produit a1a99a3a0
ON (a70a1a2a0.id_produit =
a1a99a3a0.id_produit)
AND ( (a1a99a3a0.code =
'1')))
LEFT OUTER JOIN
produit_code_barre a1a15a3a0
ON (a70a1a2a0.id_produit =
a1a15a3a0.id_produit))
LEFT OUTER JOIN
produit_structure_garantie a1a126a3a0
ON (a70a1a2a0.id_produit =
a1a126a3a0.id_produit)
AND ( (a1a126a3a0.id_distrib =
'3')))
LEFT OUTER JOIN
produit_famille a1a4a3a0
ON (a70a1a2a0.id_famille =
a1a4a3a0.id_famille))
LEFT OUTER JOIN
param_axe_valeur a1a17a3a0
ON (a70a1a2a0.id_type_axe_valeur1 =
a1a17a3a0.id))
LEFT OUTER JOIN
language_param_axe_valeur a17a18a4a0
ON (a1a17a3a0.id =
a17a18a4a0.id))
LEFT OUTER JOIN
param_axe_valeur a1a17a3a1
ON (a70a1a2a0.id_type_axe_valeur2 =
a1a17a3a1.id))
LEFT OUTER JOIN
language_param_axe_valeur a17a18a4a1
ON (a1a17a3a1.id =
a17a18a4a1.id))
LEFT OUTER JOIN
param_axe_valeur a1a17a3a2
ON (a70a1a2a0.id_type_axe_valeur3 =
a1a17a3a2.id))
LEFT OUTER JOIN
param_axe_valeur a1a17a3a3
ON (a70a1a2a0.id_type_axe_valeur4 =
a1a17a3a3.id))
LEFT OUTER JOIN
catalogue_ligne a1a91a3a0
ON (a70a1a2a0.id_produit =
a1a91a3a0.id_produit))
LEFT OUTER JOIN
marque a1a134a3a0
ON (a70a1a2a0.id_marque =
a1a134a3a0.id_marque))
LEFT OUTER JOIN
produit_ecopart_pays a1a95a3a0
ON (a70a1a2a0.id_produit =
a1a95a3a0.id_produit)
AND ( (a1a95a3a0.id_pays = '65')))
LEFT OUTER JOIN
param_taxes a70a24a2a0
ON (a66a70a1a0.id_taxe = a70a24a2a0.id_taxe))
LEFT OUTER JOIN
param_taxes_valeur a24a25a3a0
ON (a70a24a2a0.id_taxe = a24a25a3a0.id_taxe)
AND ( (a24a25a3a0.id_pays = '65')))
LEFT OUTER JOIN
param_taxes_valeur_histo a25a161a4a0
ON ( a24a25a3a0.id_pays = a25a161a4a0.id_pays
AND a24a25a3a0.id_taxe = a25a161a4a0.id_taxe))
LEFT OUTER JOIN
client a66a38a1a0
ON (a0a66a0a0.id_client = a66a38a1a0.id_client))
LEFT OUTER JOIN
structure a66a33a1a0
ON (a0a66a0a0.id_structure = a66a33a1a0.id_structure))
WHERE (a0a66a0a0.id_ticket_caisse = '13220100021835')
Event ID: 596
Date: 2013-07-01T14:29:40Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
Event ID: 595
Date: 2013-07-01T14:28:14Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
Event ID: 594
Date: 2013-07-01T14:14:28Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
Event ID: 593
Date: 2013-07-01T14:13:44Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
C:\projets\DotSoft\CaisseAuto\bXmlDao\Dao\Client\cClientFacture.vb
Exemple de tickets :
1322/ caisse 2 T13220100021835
C:\projets\DotSoft\CaisseAuto\bCaisse\cTable\cTableObjet.vb
ligne 839
Select Case cCaisse.pConfigAppli.pApplication
Case cConfigAppli.eTypApplication.Caisse
Return Me.mGetXmlObjetServiceWeb(champs, tables) <<< ICI
Case cConfigAppli.eTypApplication.ServiceWeb
Return tables.pXmlObjetConnexion(champs, -1)
End Select
Event ID: 592
Date: 2013-07-01T14:09:30Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist
Event ID: 591
Date: 2013-07-01T14:09:29Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist