select * from cotisations_commande where id = "6626" select * from cms_frontusers where identifiant = "j.sorant24" 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 = "6626" select * from cotisations where identifiant = "j.sorant24" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 104212 payment_means : MASTERCARD transmission_date : 20150307094212 payment_time : 104627 payment_date : 20150307 response_code : 00 payment_certificate : 10893ff86d2f authorisation_id : 814628 currency_code : 978 card_number : 5131.72 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.sorant24 order_id : 6626 customer_email : j.sorant24@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 = "6628" select * from cms_frontusers where identifiant = "m.reix24" 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 = "6628" select * from cotisations where identifiant = "m.reix24" and annee = "2015" and montant <> 0 select * from cotisations where identifiant = "m.reix24" and annee = "2014" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 131018 payment_means : MASTERCARD transmission_date : 20150307121018 payment_time : 131324 payment_date : 20150307 response_code : 00 payment_certificate : 5639153f4ee9 authorisation_id : 313352 currency_code : 978 card_number : 5135.22 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.reix24 order_id : 6628 customer_email : m.reix24@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 : 201705 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "6630" select * from cms_frontusers where identifiant = "t.mauger28" 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 = "6630" select * from cotisations where identifiant = "t.mauger28" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 141707 payment_means : VISA transmission_date : 20150307131707 payment_time : 142058 payment_date : 20150307 response_code : 00 payment_certificate : af5bec4e08a4 authorisation_id : 979269 currency_code : 978 card_number : 4970.87 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 : t.mauger28 order_id : 6630 customer_email : t.mauger28@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 : 201510 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "6631" select * from cms_frontusers where identifiant = "c.rousseau12" 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 = "6631" select * from cotisations where identifiant = "c.rousseau12" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 142008 payment_means : VISA transmission_date : 20150307132008 payment_time : 142157 payment_date : 20150307 response_code : 00 payment_certificate : 031a81826300 authorisation_id : 631381 currency_code : 978 card_number : 4973.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 : c.rousseau12 order_id : 6631 customer_email : c.rousseau12@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 = "6632" select * from cms_frontusers where identifiant = "j.eckstein30" 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 = "6632" select * from cotisations where identifiant = "j.eckstein30" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 4000 transaction_id : 144040 payment_means : VISA transmission_date : 20150307134040 payment_time : 145449 payment_date : 20150307 response_code : 00 payment_certificate : a2fdcc47df0e authorisation_id : 391465 currency_code : 978 card_number : 4978.17 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.eckstein30 order_id : 6632 customer_email : j.eckstein30@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 : 201710 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 : 145307 payment_means : MASTERCARD transmission_date : 20150307135307 payment_time : 145836 payment_date : 20150307 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 5132.92 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.panoux08 order_id : 6634 customer_email : a.panoux08@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 : 201509 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 : 150815 payment_means : VISA transmission_date : 20150307140815 payment_time : 151609 payment_date : 20150307 response_code : 75 payment_certificate : authorisation_id : currency_code : 978 card_number : 4973.64 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 : j.clemencot02 order_id : 6635 customer_email : j.clemencot02@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 : 201704 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "6636" select * from cms_frontusers where identifiant = "f.garcia11" 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 = "6636" select * from cotisations where identifiant = "f.garcia11" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 8000 transaction_id : 185334 payment_means : MASTERCARD transmission_date : 20150307175334 payment_time : 185525 payment_date : 20150307 response_code : 00 payment_certificate : eedd3af33803 authorisation_id : 541138 currency_code : 978 card_number : 5132.61 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.garcia11 order_id : 6636 customer_email : f.garcia11@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 : 201510 score_value : score_color : score_info : score_threshold : score_profile : ------------------------------------------- select * from cotisations_commande where id = "6637" select * from cms_frontusers where identifiant = "n.comte08" 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 = "6637" select * from cotisations where identifiant = "n.comte08" and annee = "2014" and montant <> 0 select * from cotisations where identifiant = "n.comte08" and annee = "2015" and montant <> 0 code : 0 error : merchant_id : 077566202600019 merchant_country : fr amount : 16000 transaction_id : 195933 payment_means : VISA transmission_date : 20150307185933 payment_time : 200045 payment_date : 20150307 response_code : 00 payment_certificate : 630183e210a5 authorisation_id : 920092 currency_code : 978 card_number : 4978.89 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 : n.comte08 order_id : 6637 customer_email : n.comte08@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 : -------------------------------------------