Il semble y avoir un problème de retour de paiement code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 092440 payment_means : VISA transmission_date : 20151004072440 payment_time : 093116 payment_date : 20151004 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4970.65 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 : y.vallade24 order_id : 7568 customer_email : y.vallade24@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 : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "7569" select * from cms_frontusers where identifiant = "l.waliszewski20" 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 = "7569" select * from cotisations where identifiant = "l.waliszewski20" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111029 payment_means : VISA transmission_date : 20151004091029 payment_time : 111243 payment_date : 20151004 response_code : 00 payment_certificate : 1087ad844284 authorisation_id : 842415 currency_code : 978 card_number : 4978.23 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.waliszewski20 order_id : 7569 customer_email : l.waliszewski20@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 : 201809 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "7570" select * from cms_frontusers where identifiant = "l.waliszewski20" 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 = "7570" select * from cotisations where identifiant = "a.lecuziat17" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 111332 payment_means : VISA transmission_date : 20151004091332 payment_time : 111609 payment_date : 20151004 response_code : 00 payment_certificate : 0203c0ce3aad authorisation_id : 712665 currency_code : 978 card_number : 4978.40 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.waliszewski20 order_id : 7570 customer_email : l.waliszewski20@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 : 201610 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "7571" select * from cms_frontusers where identifiant = "w.bourges11" 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 = "7571" select * from cotisations where identifiant = "s.cuzin15" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 114540 payment_means : MASTERCARD transmission_date : 20151004094540 payment_time : 114737 payment_date : 20151004 response_code : 00 payment_certificate : 636694256910 authorisation_id : 522413 currency_code : 978 card_number : 5136.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 : w.bourges11 order_id : 7571 customer_email : w.bourges11@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 : 201703 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "7573" select * from cms_frontusers where identifiant = "jt.saal16" 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 = "7573" select * from cotisations where identifiant = "jt.saal16" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 175230 payment_means : MASTERCARD transmission_date : 20151004155230 payment_time : 175601 payment_date : 20151004 response_code : 00 payment_certificate : 63f86c23ead6 authorisation_id : 611492 currency_code : 978 card_number : 5131.16 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 : jt.saal16 order_id : 7573 customer_email : jt.saal16@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 : 201603 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "7576" select * from cms_frontusers where identifiant = "p.lamy10" 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 = "7576" select * from cotisations where identifiant = "p.lamy10" and annee = "2016" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 191129 payment_means : VISA transmission_date : 20151004171129 payment_time : 191450 payment_date : 20151004 response_code : 00 payment_certificate : 53d9c1e5b812 authorisation_id : 754152 currency_code : 978 card_number : 4150.18 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 : p.lamy10 order_id : 7576 customer_email : p.lamy10@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 : 201601 score_value : score_color : score_info : score_threshold : score_profile : -------------------------------------------