select * from cotisations_commande where id = "2268" 
select * from cms_frontusers where identifiant = "a.dibling25" 
 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 = "2268" 
 select * from cotisations where identifiant = "a.dibling25" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 065603
payment_means : MASTERCARD
transmission_date : 20141103055603
payment_time : 065744
payment_date : 20141103
response_code : 00
payment_certificate : 74953f33b17f
authorisation_id : 647321
currency_code : 978
card_number : 5132.49
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.dibling25
order_id : 2268
customer_email : a.dibling25@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 : 081222
payment_means : MASTERCARD
transmission_date : 20141103071222
payment_time : 082046
payment_date : 20141103
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.77
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 : jl.quesnot23
order_id : 2269
customer_email : jl.quesnot23@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 : 201412
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2269" 
select * from cms_frontusers where identifiant = "jl.quesnot23" 
 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 = "2269" 
 select * from cotisations where identifiant = "jl.quesnot23" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 083057
payment_means : MASTERCARD
transmission_date : 20141103073057
payment_time : 083242
payment_date : 20141103
response_code : 00
payment_certificate : 2871e1c3b25a
authorisation_id : 625378
currency_code : 978
card_number : 5131.77
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 : jl.quesnot23
order_id : 2269
customer_email : jl.quesnot23@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 : 201412
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 : 083111
payment_means : VISA
transmission_date : 20141103073111
payment_time : 083638
payment_date : 20141103
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4970.63
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 : l.derainne16
order_id : 2270
customer_email : l.derainne16@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 : 201608
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2273" 
select * from cms_frontusers where identifiant = "g.jamet07" 
 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 = "2273" 
 select * from cotisations where identifiant = "g.jamet07" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 095944
payment_means : VISA
transmission_date : 20141103085944
payment_time : 100041
payment_date : 20141103
response_code : 00
payment_certificate : 7428425336a0
authorisation_id : 163537
currency_code : 978
card_number : 4627.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 : g.jamet07
order_id : 2273
customer_email : g.jamet07@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 : 201504
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2274" 
select * from cms_frontusers where identifiant = "g.jamet07" 
 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 = "2274" 
 select * from cotisations where identifiant = "a.aletru17" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 100258
payment_means : VISA
transmission_date : 20141103090258
payment_time : 100426
payment_date : 20141103
response_code : 00
payment_certificate : 43162f0511fb
authorisation_id : 075081
currency_code : 978
card_number : 4627.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 : g.jamet07
order_id : 2274
customer_email : g.jamet07@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 : 201504
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2275" 
select * from cms_frontusers where identifiant = "al.roty08" 
 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 = "2275" 
 select * from cotisations where identifiant = "al.roty08" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 100325
payment_means : VISA
transmission_date : 20141103090325
payment_time : 100520
payment_date : 20141103
response_code : 00
payment_certificate : 523439a1f193
authorisation_id : 054620
currency_code : 978
card_number : 4973.52
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 : al.roty08
order_id : 2275
customer_email : al.roty08@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 : 201506
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2276" 
select * from cms_frontusers where identifiant = "jm.labeaune01" 
 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 = "2276" 
 select * from cotisations where identifiant = "jm.labeaune01" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 112740
payment_means : MASTERCARD
transmission_date : 20141103102740
payment_time : 113715
payment_date : 20141103
response_code : 00
payment_certificate : a90667182804
authorisation_id : 261659
currency_code : 978
card_number : 5341.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 : jm.labeaune01
order_id : 2276
customer_email : jm.labeaune01@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 : 201503
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2279" 
select * from cms_frontusers where identifiant = "b.lefrancois26" 
 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 = "2279" 
 select * from cotisations where identifiant = "b.lefrancois26" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 120211
payment_means : MASTERCARD
transmission_date : 20141103110211
payment_time : 120706
payment_date : 20141103
response_code : 00
payment_certificate : 03a086e85057
authorisation_id : 122638
currency_code : 978
card_number : 5131.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 : b.lefrancois26
order_id : 2279
customer_email : b.lefrancois26@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 = "2280" 
select * from cms_frontusers where identifiant = "d.deruyter04" 
 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 = "2280" 
 select * from cotisations where identifiant = "d.deruyter04" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 121114
payment_means : VISA
transmission_date : 20141103111114
payment_time : 121327
payment_date : 20141103
response_code : 00
payment_certificate : d34522544855
authorisation_id : 874204
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 : d.deruyter04
order_id : 2280
customer_email : d.deruyter04@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 = "2281" 
select * from cms_frontusers where identifiant = "n.bonnard28" 
 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 = "2281" 
 select * from cotisations where identifiant = "n.bonnard28" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 123011
payment_means : MASTERCARD
transmission_date : 20141103113011
payment_time : 123124
payment_date : 20141103
response_code : 00
payment_certificate : 92319d11507b
authorisation_id : 625393
currency_code : 978
card_number : 5131.14
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.bonnard28
order_id : 2281
customer_email : n.bonnard28@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 = "2282" 
select * from cms_frontusers where identifiant = "a.boiron03" 
 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 = "2282" 
 select * from cotisations where identifiant = "r.lelievre01" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 125700
payment_means : MASTERCARD
transmission_date : 20141103115700
payment_time : 125948
payment_date : 20141103
response_code : 00
payment_certificate : b3afac9ac048
authorisation_id : 400356
currency_code : 978
card_number : 5137.53
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.boiron03
order_id : 2282
customer_email : a.boiron03@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 = "2283" 
select * from cms_frontusers where identifiant = "e.francois01" 
 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 = "2283" 
 select * from cotisations where identifiant = "e.francois01" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 130317
payment_means : VISA
transmission_date : 20141103120317
payment_time : 130518
payment_date : 20141103
response_code : 00
payment_certificate : b0e0647174a7
authorisation_id : 237826
currency_code : 978
card_number : 4975.68
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.francois01
order_id : 2283
customer_email : e.francois01@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 133809
payment_means : VISA
transmission_date : 20141103123809
payment_time : 134404
payment_date : 20141103
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4978.50
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 : r.blavet22
order_id : 2284
customer_email : r.blavet22@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 : 201504
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2284" 
select * from cms_frontusers where identifiant = "r.blavet22" 
 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 = "2284" 
 select * from cotisations where identifiant = "t.demelle27" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 134525
payment_means : VISA
transmission_date : 20141103124525
payment_time : 142158
payment_date : 20141103
response_code : 00
payment_certificate : b2f76a0f0feb
authorisation_id : 926298
currency_code : 978
card_number : 4978.50
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 : r.blavet22
order_id : 2284
customer_email : r.blavet22@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 : 201504
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2278" 
select * from cms_frontusers where identifiant = "js.huot16" 
 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 = "2278" 
 select * from cotisations where identifiant = "js.huot16" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 113806
payment_means : VISA
transmission_date : 20141103103806
payment_time : 161000
payment_date : 20141103
response_code : 00
payment_certificate : 889e6bceefff
authorisation_id : 614642
currency_code : 978
card_number : 4975.35
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 : js.huot16
order_id : 2278
customer_email : js.huot16@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 : 201701
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 : 180142
payment_means : MASTERCARD
transmission_date : 20141103170142
payment_time : 180506
payment_date : 20141103
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5132.22
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 : b.mignoni01
order_id : 2286
customer_email : b.mignoni01@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 : 201606
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2288" 
select * from cms_frontusers where identifiant = "p.feron19" 
 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 = "2288" 
 select * from cotisations where identifiant = "p.feron19" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 182755
payment_means : MASTERCARD
transmission_date : 20141103172755
payment_time : 182942
payment_date : 20141103
response_code : 00
payment_certificate : dee03ced1455
authorisation_id : 021511
currency_code : 978
card_number : 5131.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 : p.feron19
order_id : 2288
customer_email : p.feron19@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 = "2289" 
select * from cms_frontusers where identifiant = "b.mignoni01" 
 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 = "2289" 
 select * from cotisations where identifiant = "b.mignoni01" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 183218
payment_means : MASTERCARD
transmission_date : 20141103173218
payment_time : 183453
payment_date : 20141103
response_code : 00
payment_certificate : 56015614a5a3
authorisation_id : 633216
currency_code : 978
card_number : 5132.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 : b.mignoni01
order_id : 2289
customer_email : b.mignoni01@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 : 201606
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 : 190845
payment_means : MASTERCARD
transmission_date : 20141103180845
payment_time : 191048
payment_date : 20141103
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.90
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 05
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : y.duhal14
order_id : 2291
customer_email : y.duhal14@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 = "2291" 
select * from cms_frontusers where identifiant = "y.duhal14" 
 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 = "2291" 
 select * from cotisations where identifiant = "y.duhal14" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 191104
payment_means : MASTERCARD
transmission_date : 20141103181104
payment_time : 191223
payment_date : 20141103
response_code : 00
payment_certificate : 74962ab9a337
authorisation_id : 145234
currency_code : 978
card_number : 5131.90
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 : y.duhal14
order_id : 2291
customer_email : y.duhal14@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 = "2292" 
select * from cms_frontusers where identifiant = "p.poupon21" 
 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 = "2292" 
 select * from cotisations where identifiant = "p.poupon21" and annee = "2014" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 191745
payment_means : VISA
transmission_date : 20141103181745
payment_time : 191837
payment_date : 20141103
response_code : 00
payment_certificate : 97ca0bbed912
authorisation_id : 003109
currency_code : 978
card_number : 4921.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 : p.poupon21
order_id : 2292
customer_email : p.poupon21@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 = "2295" 
select * from cms_frontusers where identifiant = "t.daguer26" 
 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 = "2295" 
 select * from cotisations where identifiant = "j.risso09" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 204055
payment_means : MASTERCARD
transmission_date : 20141103194055
payment_time : 204356
payment_date : 20141103
response_code : 00
payment_certificate : b31cb0926419
authorisation_id : 156786
currency_code : 978
card_number : 5131.21
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.daguer26
order_id : 2295
customer_email : t.daguer26@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 204501
payment_means : MASTERCARD
transmission_date : 20141103194501
payment_time : 204813
payment_date : 20141103
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.21
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.daguer26
order_id : 2296
customer_email : t.daguer26@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "2297" 
select * from cms_frontusers where identifiant = "t.daguer26" 
 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 = "2297" 
 select * from cotisations where identifiant = "t.daguer26" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 204843
payment_means : MASTERCARD
transmission_date : 20141103194843
payment_time : 205011
payment_date : 20141103
response_code : 00
payment_certificate : b69f30184453
authorisation_id : 577963
currency_code : 978
card_number : 5131.21
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.daguer26
order_id : 2297
customer_email : t.daguer26@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 = "2299" 
select * from cms_frontusers where identifiant = "t.daguer26" 
 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 = "2299" 
 select * from cotisations where identifiant = "h.raharijao04" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 205139
payment_means : MASTERCARD
transmission_date : 20141103195139
payment_time : 205311
payment_date : 20141103
response_code : 00
payment_certificate : 156d0859971a
authorisation_id : 184208
currency_code : 978
card_number : 5131.21
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.daguer26
order_id : 2299
customer_email : t.daguer26@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 205503
payment_means : MASTERCARD
transmission_date : 20141103195503
payment_time : 205644
payment_date : 20141103
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.71
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 : c.jacquot22
order_id : 2300
customer_email : c.jacquot22@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 : 201511
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2298" 
select * from cms_frontusers where identifiant = "pe.potel29" 
 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 = "2298" 
 select * from cotisations where identifiant = "pe.potel29" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 205121
payment_means : VISA
transmission_date : 20141103195121
payment_time : 205705
payment_date : 20141103
response_code : 00
payment_certificate : 27cf8d6c02d3
authorisation_id : 275202
currency_code : 978
card_number : 4978.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 : pe.potel29
order_id : 2298
customer_email : pe.potel29@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 = "2301" 
select * from cms_frontusers where identifiant = "m.glee11" 
 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 = "2301" 
 select * from cotisations where identifiant = "m.glee11" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 210124
payment_means : MASTERCARD
transmission_date : 20141103200124
payment_time : 210528
payment_date : 20141103
response_code : 00
payment_certificate : 91787ba73755
authorisation_id : 580046
currency_code : 978
card_number : 5131.00
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.glee11
order_id : 2301
customer_email : m.glee11@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 = "2303" 
select * from cms_frontusers where identifiant = "a.mayer02" 
 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 = "2303" 
 select * from cotisations where identifiant = "a.mayer02" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 211301
payment_means : MASTERCARD
transmission_date : 20141103201301
payment_time : 211551
payment_date : 20141103
response_code : 00
payment_certificate : a5d21cf4d8fd
authorisation_id : 060734
currency_code : 978
card_number : 5132.21
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.mayer02
order_id : 2303
customer_email : a.mayer02@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 : 201502
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2302" 
select * from cms_frontusers where identifiant = "q.launay12" 
 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 = "2302" 
 select * from cotisations where identifiant = "q.launay12" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 211253
payment_means : VISA
transmission_date : 20141103201253
payment_time : 211824
payment_date : 20141103
response_code : 00
payment_certificate : 5c8d0a6dca58
authorisation_id : 157622
currency_code : 978
card_number : 4978.08
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 : q.launay12
order_id : 2302
customer_email : q.launay12@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 = "2304" 
select * from cms_frontusers where identifiant = "s.brion21" 
 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 = "2304" 
 select * from cotisations where identifiant = "s.brion21" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 212540
payment_means : VISA
transmission_date : 20141103202540
payment_time : 212705
payment_date : 20141103
response_code : 00
payment_certificate : 2beb709d801e
authorisation_id : 281443
currency_code : 978
card_number : 4973.20
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.brion21
order_id : 2304
customer_email : s.brion21@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 : 201612
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2306" 
select * from cms_frontusers where identifiant = "a.cahu12" 
 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 = "2306" 
 select * from cotisations where identifiant = "a.cahu12" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 214527
payment_means : VISA
transmission_date : 20141103204527
payment_time : 214709
payment_date : 20141103
response_code : 00
payment_certificate : 5f124530cf64
authorisation_id : 142562
currency_code : 978
card_number : 4974.08
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.cahu12
order_id : 2306
customer_email : a.cahu12@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 : 201708
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2308" 
select * from cms_frontusers where identifiant = "v.abraham11" 
 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 = "2308" 
 select * from cotisations where identifiant = "v.abraham11" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 214937
payment_means : VISA
transmission_date : 20141103204937
payment_time : 215208
payment_date : 20141103
response_code : 00
payment_certificate : 8a9d9709b3de
authorisation_id : 642575
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 : v.abraham11
order_id : 2308
customer_email : v.abraham11@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 : 201507
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2307" 
select * from cms_frontusers where identifiant = "py.corre10" 
 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 = "2307" 
 select * from cotisations where identifiant = "py.corre10" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 214758
payment_means : VISA
transmission_date : 20141103204758
payment_time : 215212
payment_date : 20141103
response_code : 00
payment_certificate : 8cefff298ffd
authorisation_id : 648553
currency_code : 978
card_number : 4978.75
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 : py.corre10
order_id : 2307
customer_email : py.corre10@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 = "2309" 
select * from cms_frontusers where identifiant = "c.jacquot22" 
 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 = "2309" 
 select * from cotisations where identifiant = "l.tavernier17" and annee = "2014" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 215751
payment_means : VISA
transmission_date : 20141103205751
payment_time : 215919
payment_date : 20141103
response_code : 00
payment_certificate : 94c504a47b69
authorisation_id : 728459
currency_code : 978
card_number : 4978.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.jacquot22
order_id : 2309
customer_email : c.jacquot22@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 : 201701
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2310" 
select * from cms_frontusers where identifiant = "c.jacquot22" 
 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 = "2310" 
 select * from cotisations where identifiant = "l.tavernier17" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 220046
payment_means : VISA
transmission_date : 20141103210046
payment_time : 220452
payment_date : 20141103
response_code : 00
payment_certificate : 016d2ab5ac63
authorisation_id : 446157
currency_code : 978
card_number : 4978.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.jacquot22
order_id : 2310
customer_email : c.jacquot22@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 : 201701
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2311" 
select * from cms_frontusers where identifiant = "c.jacquot22" 
 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 = "2311" 
 select * from cotisations where identifiant = "k.faineant17" and annee = "2014" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 220651
payment_means : VISA
transmission_date : 20141103210651
payment_time : 220843
payment_date : 20141103
response_code : 00
payment_certificate : 813279755705
authorisation_id : 623201
currency_code : 978
card_number : 4973.98
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.jacquot22
order_id : 2311
customer_email : c.jacquot22@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 = "2312" 
select * from cms_frontusers where identifiant = "m.seghiri07" 
 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 = "2312" 
 select * from cotisations where identifiant = "m.seghiri07" and annee = "2015" and montant <> 0 
 select * from cotisations where identifiant = "j.laget18" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 220745
payment_means : VISA
transmission_date : 20141103210745
payment_time : 220945
payment_date : 20141103
response_code : 00
payment_certificate : 64b3f3827a91
authorisation_id : 212869
currency_code : 978
card_number : 4562.69
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.seghiri07
order_id : 2312
customer_email : m.seghiri07@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 : 201605
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "2313" 
select * from cms_frontusers where identifiant = "c.jacquot22" 
 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 = "2313" 
 select * from cotisations where identifiant = "k.faineant17" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 220943
payment_means : VISA
transmission_date : 20141103210943
payment_time : 221111
payment_date : 20141103
response_code : 00
payment_certificate : 66749a798714
authorisation_id : 734524
currency_code : 978
card_number : 4973.98
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.jacquot22
order_id : 2313
customer_email : c.jacquot22@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 = "2314" 
select * from cms_frontusers where identifiant = "s.clochard28" 
 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 = "2314" 
 select * from cotisations where identifiant = "r.vinyals15" and annee = "2014" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 221105
payment_means : MASTERCARD
transmission_date : 20141103211105
payment_time : 221405
payment_date : 20141103
response_code : 00
payment_certificate : 2aa3d1ff15b2
authorisation_id : 264625
currency_code : 978
card_number : 5341.58
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.clochard28
order_id : 2314
customer_email : s.clochard28@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "2316" 
select * from cms_frontusers where identifiant = "r.masson06" 
 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 = "2316" 
 select * from cotisations where identifiant = "r.masson06" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 221946
payment_means : MASTERCARD
transmission_date : 20141103211946
payment_time : 222123
payment_date : 20141103
response_code : 00
payment_certificate : 740570b5a904
authorisation_id : 245523
currency_code : 978
card_number : 5132.55
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 : r.masson06
order_id : 2316
customer_email : r.masson06@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 = "2317" 
select * from cms_frontusers where identifiant = "s.clochard28" 
 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 = "2317" 
 select * from cotisations where identifiant = "s.clochard28" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 223702
payment_means : MASTERCARD
transmission_date : 20141103213702
payment_time : 223828
payment_date : 20141103
response_code : 00
payment_certificate : 47eda8dbbd89
authorisation_id : 162458
currency_code : 978
card_number : 5131.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 : s.clochard28
order_id : 2317
customer_email : s.clochard28@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 : 201511
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 : 233651
payment_means : MASTERCARD
transmission_date : 20141103223651
payment_time : 234052
payment_date : 20141103
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5136.25
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 : m.bouquet28
order_id : 2318
customer_email : m.bouquet28@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 : 201606
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------