select * from cotisations_commande where id = "6792" 
select * from cms_frontusers where identifiant = "e.scarfiglieri16" 
 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 = "6792" 
 select * from cotisations where identifiant = "e.scarfiglieri16" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 113124
payment_means : VISA
transmission_date : 20150409093124
payment_time : 113319
payment_date : 20150409
response_code : 00
payment_certificate : 7da3c5172010
authorisation_id : 336402
currency_code : 978
card_number : 4975.36
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.scarfiglieri16
order_id : 6792
customer_email : e.scarfiglieri16@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 : 201803
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "6793" 
select * from cms_frontusers where identifiant = "p.duvigneau13" 
 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 = "6793" 
 select * from cotisations where identifiant = "p.duvigneau13" and annee = "2014" and montant <> 0 
 select * from cotisations where identifiant = "p.duvigneau13" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 115928
payment_means : MASTERCARD
transmission_date : 20150409095928
payment_time : 120203
payment_date : 20150409
response_code : 00
payment_certificate : 89e3c795016d
authorisation_id : 611974
currency_code : 978
card_number : 5294.25
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.duvigneau13
order_id : 6793
customer_email : p.duvigneau13@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 : 202512
payment_means : VISA
transmission_date : 20150409182512
payment_time : 202721
payment_date : 20150409
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4973.61
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 56
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : s.villenave26
order_id : 6794
customer_email : s.villenave26@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 = "6795" 
select * from cms_frontusers where identifiant = "v.aymard31" 
 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 = "6795" 
 select * from cotisations where identifiant = "v.aymard31" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 203435
payment_means : MASTERCARD
transmission_date : 20150409183435
payment_time : 203721
payment_date : 20150409
response_code : 00
payment_certificate : 8bd58d4bba9a
authorisation_id : 549131
currency_code : 978
card_number : 5131.78
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 : v.aymard31
order_id : 6795
customer_email : v.aymard31@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 = "6796" 
select * from cms_frontusers where identifiant = "m.raugel04" 
 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 = "6796" 
 select * from cotisations where identifiant = "m.raugel04" and annee = "2014" and montant <> 0 
 select * from cotisations where identifiant = "m.raugel04" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 211027
payment_means : MASTERCARD
transmission_date : 20150409191027
payment_time : 211222
payment_date : 20150409
response_code : 00
payment_certificate : 57e36d063d31
authorisation_id : 252513
currency_code : 978
card_number : 5132.42
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.raugel04
order_id : 6796
customer_email : m.raugel04@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 : 201602
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "6797" 
select * from cms_frontusers where identifiant = "j.betoulle10" 
 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 = "6797" 
 select * from cotisations where identifiant = "j.betoulle10" and annee = "2014" and montant <> 0 
 select * from cotisations where identifiant = "j.betoulle10" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 212641
payment_means : VISA
transmission_date : 20150409192641
payment_time : 213149
payment_date : 20150409
response_code : 00
payment_certificate : 152da2306e04
authorisation_id : 666171
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 : j.betoulle10
order_id : 6797
customer_email : j.betoulle10@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 : 201801
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 : 213927
payment_means : MASTERCARD
transmission_date : 20150409193927
payment_time : 214535
payment_date : 20150409
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.84
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 : t.thiriot27
order_id : 6798
customer_email : t.thiriot27@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 : 201609
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "6800" 
select * from cms_frontusers where identifiant = "a.paumier05" 
 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 = "6800" 
 select * from cotisations where identifiant = "a.paumier05" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 215556
payment_means : MASTERCARD
transmission_date : 20150409195556
payment_time : 220352
payment_date : 20150409
response_code : 00
payment_certificate : dfa977ff8991
authorisation_id : 565301
currency_code : 978
card_number : 5131.04
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.paumier05
order_id : 6800
customer_email : a.paumier05@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 220237
payment_means : VISA
transmission_date : 20150409200237
payment_time : 220410
payment_date : 20150409
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4972.43
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 59
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : b.lassonnerie13
order_id : 6801
customer_email : b.lassonnerie13@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 : 201512
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------