select * from cotisations_commande where id = "7076" 
select * from cms_frontusers where identifiant = "r.lucas22" 
 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 = "7076" 
 select * from cotisations where identifiant = "r.lucas22" and annee = "2015" and montant <> 0 
 select * from cotisations where identifiant = "r.lucas22" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 115622
payment_means : VISA
transmission_date : 20150601095622
payment_time : 120026
payment_date : 20150601
response_code : 00
payment_certificate : 387ede04edf3
authorisation_id : 314046
currency_code : 978
card_number : 4533.20
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 00
complementary_code : 99
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : r.lucas22
order_id : 7076
customer_email : r.lucas22@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 : 201804
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "7077" 
select * from cms_frontusers where identifiant = "h.cocheril01" 
 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 = "7077" 
 select * from cotisations where identifiant = "t.colaianni15" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 152933
payment_means : VISA
transmission_date : 20150601132933
payment_time : 153139
payment_date : 20150601
response_code : 00
payment_certificate : f6ec3d236759
authorisation_id : 113349
currency_code : 978
card_number : 4977.45
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 : h.cocheril01
order_id : 7077
customer_email : h.cocheril01@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 : 201704
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "7079" 
select * from cms_frontusers where identifiant = "u.picado20" 
 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 = "7079" 
 select * from cotisations where identifiant = "u.picado20" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 194035
payment_means : VISA
transmission_date : 20150601174035
payment_time : 194520
payment_date : 20150601
response_code : 00
payment_certificate : da2fdce1706e
authorisation_id : 149279
currency_code : 978
card_number : 4978.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 : u.picado20
order_id : 7079
customer_email : u.picado20@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 203637
payment_means : MASTERCARD
transmission_date : 20150601183637
payment_time : 203827
payment_date : 20150601
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5341.45
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 : d.fauvel10
order_id : 7080
customer_email : d.fauvel10@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 : 201702
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------