select * from cotisations_commande where id = "1852" select * from cms_frontusers where identifiant = "j.dardillac20" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "1852" select * from cotisations where identifiant = "j.dardillac20" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 102441 payment_means : VISA transmission_date : 20141019082441 payment_time : 102601 payment_date : 20141019 response_code : 00 payment_certificate : 0e6625fe56a0 authorisation_id : 782134 currency_code : 978 card_number : 4978.31 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : j.dardillac20 order_id : 1852 customer_email : j.dardillac20@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "1853" select * from cms_frontusers where identifiant = "m.testevuide16" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "1853" select * from cotisations where identifiant = "m.testevuide16" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 124315 payment_means : MASTERCARD transmission_date : 20141019104315 payment_time : 124535 payment_date : 20141019 response_code : 00 payment_certificate : 915d9663ebc0 authorisation_id : 675300 currency_code : 978 card_number : 5573.13 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.testevuide16 order_id : 1853 customer_email : m.testevuide16@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201707 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "1854" select * from cms_frontusers where identifiant = "a.gayraud04" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "1854" select * from cotisations where identifiant = "a.gayraud04" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 130734 payment_means : VISA transmission_date : 20141019110734 payment_time : 130946 payment_date : 20141019 response_code : 00 payment_certificate : 145e4b07abca authorisation_id : 960653 currency_code : 978 card_number : 4978.12 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.gayraud04 order_id : 1854 customer_email : a.gayraud04@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 150326 payment_means : MASTERCARD transmission_date : 20141019130326 payment_time : 150609 payment_date : 20141019 response_code : 05 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.08 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 51 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : v.jury13 order_id : 1855 customer_email : v.jury13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201505 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 160057 payment_means : MASTERCARD transmission_date : 20141019140057 payment_time : 160346 payment_date : 20141019 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5131.38 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : a.chollet09 order_id : 1856 customer_email : a.chollet09@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201502 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "1857" select * from cms_frontusers where identifiant = "jc.hubert23" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "1857" select * from cotisations where identifiant = "jc.hubert23" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 160353 payment_means : VISA transmission_date : 20141019140353 payment_time : 160535 payment_date : 20141019 response_code : 00 payment_certificate : 532df4e4f6f0 authorisation_id : 324965 currency_code : 978 card_number : 4974.29 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : jc.hubert23 order_id : 1857 customer_email : jc.hubert23@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201611 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "1858" select * from cms_frontusers where identifiant = "s.auffray13" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "1858" select * from cotisations where identifiant = "s.auffray13" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165450 payment_means : VISA transmission_date : 20141019145450 payment_time : 165640 payment_date : 20141019 response_code : 00 payment_certificate : 8ea7e7a8b9d1 authorisation_id : 609455 currency_code : 978 card_number : 4970.15 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.auffray13 order_id : 1858 customer_email : s.auffray13@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201509 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "1859" select * from cms_frontusers where identifiant = "g.thibaudgendron11" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "1859" select * from cotisations where identifiant = "g.thibaudgendron11" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 165753 payment_means : MASTERCARD transmission_date : 20141019145753 payment_time : 170208 payment_date : 20141019 response_code : 00 payment_certificate : 8bac6ef867cb authorisation_id : 459584 currency_code : 978 card_number : 5136.88 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : g.thibaudgendron11 order_id : 1859 customer_email : g.thibaudgendron11@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201504 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "1861" select * from cms_frontusers where identifiant = "l.michel10" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "1861" select * from cotisations where identifiant = "l.michel10" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 204532 payment_means : VISA transmission_date : 20141019184532 payment_time : 205129 payment_date : 20141019 response_code : 00 payment_certificate : cecd7db340c3 authorisation_id : 236394 currency_code : 978 card_number : 4970.14 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : l.michel10 order_id : 1861 customer_email : l.michel10@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201606 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 205033 payment_means : VISA transmission_date : 20141019185033 payment_time : 205621 payment_date : 20141019 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4978.10 cvv_flag : 1 cvv_response_code : ?? bank_response_code : complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : m.mercier19 order_id : 1862 customer_email : m.mercier19@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_FAILURE statement_reference : card_validity : 201709 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "1863" select * from cms_frontusers where identifiant = "s.fley07" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "1863" select * from cotisations where identifiant = "s.fley07" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 211914 payment_means : VISA transmission_date : 20141019191914 payment_time : 212054 payment_date : 20141019 response_code : 00 payment_certificate : 43d8853fef79 authorisation_id : 515190 currency_code : 978 card_number : 4978.53 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : s.fley07 order_id : 1863 customer_email : s.fley07@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201609 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "1864" select * from cms_frontusers where identifiant = "f.yvon24" select L.*, date_format(naissance,"%d/%m/%Y") as naissancefr, U.nom, U.prenom, U.cotisationmin, U.mail from cotisations_commande_ligne L left outer join cms_frontusers U on U.identifiant = L.identifiant where id_commande = "1864" select * from cotisations where identifiant = "v.jury13" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 224311 payment_means : VISA transmission_date : 20141019204311 payment_time : 224505 payment_date : 20141019 response_code : 00 payment_certificate : 400621085d0a authorisation_id : 214443 currency_code : 978 card_number : 4978.56 cvv_flag : 1 cvv_response_code : ?? bank_response_code : 00 complementary_code : 00 complementary_info : return_context : caddie : receipt_complement : merchant_language : fr language : fr customer_id : f.yvon24 order_id : 1864 customer_email : f.yvon24@compagnons-du-devoir.fr customer_ip_address : capture_day : 0 capture_mode : AUTHOR_CAPTURE data : order_validity : 02 transaction_condition : 3D_SUCCESS statement_reference : card_validity : 201506 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------