select * from cotisations_commande where id = "21694" 
select * from cms_frontusers where identifiant = "s.angel05" 
 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 = "21694" 
 select * from cotisations where identifiant = "s.angel05" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 080903
payment_means : VISA
transmission_date : 20170209070903
payment_time : 081103
payment_date : 20170209
response_code : 00
payment_certificate : d9b7cc78d151
authorisation_id : 251623
currency_code : 978
card_number : 4561.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 : s.angel05
order_id : 21694
customer_email : s.angel05@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 = "21695" 
select * from cms_frontusers where identifiant = "j.riccoboni04" 
 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 = "21695" 
 select * from cotisations where identifiant = "j.riccoboni04" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "j.riccoboni04" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 100303
payment_means : VISA
transmission_date : 20170209090303
payment_time : 100547
payment_date : 20170209
response_code : 00
payment_certificate : 65757b82290b
authorisation_id : 533113
currency_code : 978
card_number : 4978.43
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.riccoboni04
order_id : 21695
customer_email : j.riccoboni04@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 : 16000
transaction_id : 105734
payment_means : VISA
transmission_date : 20170209095734
payment_time : 110256
payment_date : 20170209
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4973.12
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 : p.cirou12
order_id : 21696
customer_email : p.cirou12@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 : 201809
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 : 115120
payment_means : VISA
transmission_date : 20170209105120
payment_time : 115632
payment_date : 20170209
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4975.24
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 : p.plessis31
order_id : 21697
customer_email : p.plessis31@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 : 201902
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21698" 
select * from cms_frontusers where identifiant = "k.jung17" 
 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 = "21698" 
 select * from cotisations where identifiant = "k.jung17" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 125415
payment_means : MASTERCARD
transmission_date : 20170209115415
payment_time : 125606
payment_date : 20170209
response_code : 00
payment_certificate : 85d56a55780d
authorisation_id : 443666
currency_code : 978
card_number : 5131.07
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 : k.jung17
order_id : 21698
customer_email : k.jung17@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 = "21699" 
select * from cms_frontusers where identifiant = "r.guillet27" 
 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 = "21699" 
 select * from cotisations where identifiant = "r.guillet27" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 131848
payment_means : VISA
transmission_date : 20170209121848
payment_time : 132243
payment_date : 20170209
response_code : 00
payment_certificate : 093dc8cad367
authorisation_id : 515836
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 : r.guillet27
order_id : 21699
customer_email : r.guillet27@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 = "21700" 
select * from cms_frontusers where identifiant = "p.cirou12" 
 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 = "21700" 
 select * from cotisations where identifiant = "p.cirou12" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "p.cirou12" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 16000
transaction_id : 163804
payment_means : VISA
transmission_date : 20170209153804
payment_time : 163958
payment_date : 20170209
response_code : 00
payment_certificate : 9d6514525618
authorisation_id : 740003
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 : p.cirou12
order_id : 21700
customer_email : p.cirou12@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 : 201809
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21701" 
select * from cms_frontusers where identifiant = "s.ripoche30" 
 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 = "21701" 
 select * from cotisations where identifiant = "s.ripoche30" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 170114
payment_means : MASTERCARD
transmission_date : 20170209160114
payment_time : 170446
payment_date : 20170209
response_code : 00
payment_certificate : 0b1b47d3e024
authorisation_id : 040904
currency_code : 978
card_number : 5133.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 : s.ripoche30
order_id : 21701
customer_email : s.ripoche30@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 : 201809
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21702" 
select * from cms_frontusers where identifiant = "a.swistek29" 
 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 = "21702" 
 select * from cotisations where identifiant = "r.deligne09" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 175213
payment_means : VISA
transmission_date : 20170209165213
payment_time : 175330
payment_date : 20170209
response_code : 00
payment_certificate : 7381c81d1050
authorisation_id : 825673
currency_code : 978
card_number : 4976.05
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.swistek29
order_id : 21702
customer_email : a.swistek29@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 175333
payment_means : MASTERCARD
transmission_date : 20170209165333
payment_time : 175518
payment_date : 20170209
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.99
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 : jm.papon03
order_id : 21703
customer_email : jm.papon03@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 : 201809
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 : 175527
payment_means : MASTERCARD
transmission_date : 20170209165527
payment_time : 175641
payment_date : 20170209
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.99
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 : jm.papon03
order_id : 21703
customer_email : jm.papon03@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 : 201809
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21705" 
select * from cms_frontusers where identifiant = "d.masson05" 
 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 = "21705" 
 select * from cotisations where identifiant = "x.puig26" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 183030
payment_means : MASTERCARD
transmission_date : 20170209173030
payment_time : 183131
payment_date : 20170209
response_code : 00
payment_certificate : 6590aecce1cf
authorisation_id : 922477
currency_code : 978
card_number : 5131.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 : d.masson05
order_id : 21705
customer_email : d.masson05@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 : 201712
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21707" 
select * from cms_frontusers where identifiant = "r.luttenbacher16" 
 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 = "21707" 
 select * from cotisations where identifiant = "r.luttenbacher16" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 191242
payment_means : VISA
transmission_date : 20170209181242
payment_time : 191507
payment_date : 20170209
response_code : 00
payment_certificate : 556291fc98ec
authorisation_id : 170490
currency_code : 978
card_number : 4150.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 : r.luttenbacher16
order_id : 21707
customer_email : r.luttenbacher16@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 = "21708" 
select * from cms_frontusers where identifiant = "m.maizoue19" 
 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 = "21708" 
 select * from cotisations where identifiant = "m.maizoue19" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 191857
payment_means : VISA
transmission_date : 20170209181857
payment_time : 192032
payment_date : 20170209
response_code : 00
payment_certificate : 77ec07e8f300
authorisation_id : 561546
currency_code : 978
card_number : 4970.34
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.maizoue19
order_id : 21708
customer_email : m.maizoue19@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "21709" 
select * from cms_frontusers where identifiant = "p.forconi23" 
 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 = "21709" 
 select * from cotisations where identifiant = "p.forconi23" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 194446
payment_means : MASTERCARD
transmission_date : 20170209184446
payment_time : 194702
payment_date : 20170209
response_code : 00
payment_certificate : ddfc043fdacc
authorisation_id : 932545
currency_code : 978
card_number : 5817.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 : p.forconi23
order_id : 21709
customer_email : p.forconi23@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 : 201809
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21710" 
select * from cms_frontusers where identifiant = "p.forconi23" 
 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 = "21710" 
 select * from cotisations where identifiant = "p.forconi23" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 194837
payment_means : MASTERCARD
transmission_date : 20170209184837
payment_time : 194958
payment_date : 20170209
response_code : 00
payment_certificate : 97bd469095f0
authorisation_id : 795307
currency_code : 978
card_number : 5817.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 : p.forconi23
order_id : 21710
customer_email : p.forconi23@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 : 201809
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21711" 
select * from cms_frontusers where identifiant = "k.beukeboom15" 
 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 = "21711" 
 select * from cotisations where identifiant = "k.beukeboom15" and annee = "2016" and montant <> 0 
 select * from cotisations where identifiant = "k.beukeboom15" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 213318
payment_means : MASTERCARD
transmission_date : 20170209203318
payment_time : 213606
payment_date : 20170209
response_code : 00
payment_certificate : 5b29edfe352f
authorisation_id : 252631
currency_code : 978
card_number : 5131.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 : k.beukeboom15
order_id : 21711
customer_email : k.beukeboom15@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 : 201809
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21712" 
select * from cms_frontusers where identifiant = "g.douelle19" 
 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 = "21712" 
 select * from cotisations where identifiant = "g.douelle19" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 213625
payment_means : VISA
transmission_date : 20170209203625
payment_time : 213851
payment_date : 20170209
response_code : 00
payment_certificate : c032a090876d
authorisation_id : 405434
currency_code : 978
card_number : 4972.57
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.douelle19
order_id : 21712
customer_email : g.douelle19@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "21713" 
select * from cms_frontusers where identifiant = "g.douelle19" 
 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 = "21713" 
 select * from cotisations where identifiant = "y.turpin22" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 214229
payment_means : VISA
transmission_date : 20170209204229
payment_time : 214408
payment_date : 20170209
response_code : 00
payment_certificate : 1f16aa51a084
authorisation_id : 948724
currency_code : 978
card_number : 4972.57
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.douelle19
order_id : 21713
customer_email : g.douelle19@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 : 
-------------------------------------------

 select * from cotisations_commande where id = "21714" 
select * from cms_frontusers where identifiant = "pa.lebre07" 
 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 = "21714" 
 select * from cotisations where identifiant = "pa.lebre07" and annee = "2016" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 214407
payment_means : VISA
transmission_date : 20170209204407
payment_time : 214651
payment_date : 20170209
response_code : 00
payment_certificate : d5b9e64fbd64
authorisation_id : 221312
currency_code : 978
card_number : 4970.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 : pa.lebre07
order_id : 21714
customer_email : pa.lebre07@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 = "21715" 
select * from cms_frontusers where identifiant = "pa.lebre07" 
 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 = "21715" 
 select * from cotisations where identifiant = "pa.lebre07" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 214724
payment_means : VISA
transmission_date : 20170209204724
payment_time : 214903
payment_date : 20170209
response_code : 00
payment_certificate : 28efa90c30b1
authorisation_id : 556144
currency_code : 978
card_number : 4970.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 : pa.lebre07
order_id : 21715
customer_email : pa.lebre07@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 222545
payment_means : MASTERCARD
transmission_date : 20170209212545
payment_time : 223248
payment_date : 20170209
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.95
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 : m.lourdeaux20
order_id : 21717
customer_email : m.lourdeaux20@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 : 201709
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "21718" 
select * from cms_frontusers where identifiant = "s.pachot15" 
 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 = "21718" 
 select * from cotisations where identifiant = "s.pachot15" and annee = "2017" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 224156
payment_means : MASTERCARD
transmission_date : 20170209214156
payment_time : 224654
payment_date : 20170209
response_code : 00
payment_certificate : c2a035e7cb71
authorisation_id : 626085
currency_code : 978
card_number : 5131.46
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.pachot15
order_id : 21718
customer_email : s.pachot15@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 : 
-------------------------------------------