select * from cotisations_commande where id = "21975" 
select * from cms_frontusers where identifiant = "s.druet16" 
 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 = "21975" 
 select * from cotisations where identifiant = "s.druet16" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 083649
payment_means : VISA
transmission_date : 20170223073649
payment_time : 083756
payment_date : 20170223
response_code : 00
payment_certificate : 5fd76b06d1c6
authorisation_id : 261612
currency_code : 978
card_number : 4533.47
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.druet16
order_id : 21975
customer_email : s.druet16@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 : 201910
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21976" 
select * from cms_frontusers where identifiant = "a.lafonta10" 
 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 = "21976" 
 select * from cotisations where identifiant = "a.lafonta10" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 120656
payment_means : MASTERCARD
transmission_date : 20170223110656
payment_time : 120813
payment_date : 20170223
response_code : 00
payment_certificate : ffe395ef5d3d
authorisation_id : 489443
currency_code : 978
card_number : 5133.71
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.lafonta10
order_id : 21976
customer_email : a.lafonta10@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 : 201806
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 : 152652
payment_means : VISA
transmission_date : 20170223142652
payment_time : 153221
payment_date : 20170223
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4974.16
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 
complementary_code : 
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : f.cheron28
order_id : 21977
customer_email : f.cheron28@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 : 201909
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21977" 
select * from cms_frontusers where identifiant = "f.cheron28" 
 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 = "21977" 
 select * from cotisations where identifiant = "f.cheron28" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 153314
payment_means : VISA
transmission_date : 20170223143314
payment_time : 153522
payment_date : 20170223
response_code : 00
payment_certificate : 33b81b09e4f9
authorisation_id : 795519
currency_code : 978
card_number : 4974.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 : f.cheron28
order_id : 21977
customer_email : f.cheron28@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 : 201909
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21978" 
select * from cms_frontusers where identifiant = "m.puy21" 
 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 = "21978" 
 select * from cotisations where identifiant = "g.parzychboue26" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 153159
payment_means : MASTERCARD
transmission_date : 20170223143159
payment_time : 153743
payment_date : 20170223
response_code : 00
payment_certificate : 69f52ac1c793
authorisation_id : 461615
currency_code : 978
card_number : 5137.62
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.puy21
order_id : 21978
customer_email : m.puy21@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 : 201711
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21979" 
select * from cms_frontusers where identifiant = "j.lavoine26" 
 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 = "21979" 
 select * from cotisations where identifiant = "j.lavoine26" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 160704
payment_means : VISA
transmission_date : 20170223150704
payment_time : 160835
payment_date : 20170223
response_code : 00
payment_certificate : 33378398797b
authorisation_id : 030516
currency_code : 978
card_number : 4974.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 : j.lavoine26
order_id : 21979
customer_email : j.lavoine26@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "21980" 
select * from cms_frontusers where identifiant = "e.chartier19" 
 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 = "21980" 
 select * from cotisations where identifiant = "e.chartier19" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 180251
payment_means : VISA
transmission_date : 20170223170251
payment_time : 182245
payment_date : 20170223
response_code : 00
payment_certificate : 37c6e69caaa4
authorisation_id : 107545
currency_code : 978
card_number : 4171.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 : e.chartier19
order_id : 21980
customer_email : e.chartier19@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 = "21981" 
select * from cms_frontusers where identifiant = "d.harel19" 
 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 = "21981" 
 select * from cotisations where identifiant = "d.harel19" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 202336
payment_means : VISA
transmission_date : 20170223192336
payment_time : 202616
payment_date : 20170223
response_code : 00
payment_certificate : aa3a36e8b829
authorisation_id : 285264
currency_code : 978
card_number : 4978.96
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 : d.harel19
order_id : 21981
customer_email : d.harel19@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 : 201706
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21982" 
select * from cms_frontusers where identifiant = "e.germain21" 
 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 = "21982" 
 select * from cotisations where identifiant = "e.germain21" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 205807
payment_means : VISA
transmission_date : 20170223195807
payment_time : 210030
payment_date : 20170223
response_code : 00
payment_certificate : deaab1f8f8f5
authorisation_id : 164439
currency_code : 978
card_number : 4978.82
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 : e.germain21
order_id : 21982
customer_email : e.germain21@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 : 201910
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21983" 
select * from cms_frontusers where identifiant = "g.charlier11" 
 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 = "21983" 
 select * from cotisations where identifiant = "g.charlier11" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 212607
payment_means : VISA
transmission_date : 20170223202607
payment_time : 212911
payment_date : 20170223
response_code : 00
payment_certificate : c3087aa349f8
authorisation_id : 055257
currency_code : 978
card_number : 4973.02
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.charlier11
order_id : 21983
customer_email : g.charlier11@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 : 201909
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21985" 
select * from cms_frontusers where identifiant = "m.taranne23" 
 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 = "21985" 
 select * from cotisations where identifiant = "m.taranne23" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 231400
payment_means : MASTERCARD
transmission_date : 20170223221400
payment_time : 231617
payment_date : 20170223
response_code : 00
payment_certificate : 4af601423f45
authorisation_id : 019634
currency_code : 978
card_number : 5136.28
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.taranne23
order_id : 21985
customer_email : m.taranne23@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 : 201805
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------