select * from cotisations_commande where id = "1920" 
select * from cms_frontusers where identifiant = "j.dabancourt28" 
 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 = "1920" 
 select * from cotisations where identifiant = "j.dabancourt28" and annee = "2014" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 003954
payment_means : VISA
transmission_date : 20141021223954
payment_time : 004145
payment_date : 20141022
response_code : 00
payment_certificate : 91857e9503a1
authorisation_id : 021083
currency_code : 978
card_number : 4659.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 : j.dabancourt28
order_id : 1920
customer_email : j.dabancourt28@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 : 201707
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 : 013128
payment_means : VISA
transmission_date : 20141021233128
payment_time : 013439
payment_date : 20141022
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4970.13
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 : a.auge12
order_id : 1921
customer_email : a.auge12@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 : 201602
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "1921" 
select * from cms_frontusers where identifiant = "a.auge12" 
 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 = "1921" 
 select * from cotisations where identifiant = "a.auge12" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 013451
payment_means : VISA
transmission_date : 20141021233451
payment_time : 013708
payment_date : 20141022
response_code : 00
payment_certificate : a8d02b1bee74
authorisation_id : 022760
currency_code : 978
card_number : 4762.31
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.auge12
order_id : 1921
customer_email : a.auge12@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 = "1922" 
select * from cms_frontusers where identifiant = "j.mosnier03" 
 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 = "1922" 
 select * from cotisations where identifiant = "j.mosnier03" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 062442
payment_means : VISA
transmission_date : 20141022042442
payment_time : 062654
payment_date : 20141022
response_code : 00
payment_certificate : bad3f4ed7fa7
authorisation_id : 661947
currency_code : 978
card_number : 4970.73
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.mosnier03
order_id : 1922
customer_email : j.mosnier03@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 = "1923" 
select * from cms_frontusers where identifiant = "c.triconnet01" 
 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 = "1923" 
 select * from cotisations where identifiant = "c.triconnet01" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 084042
payment_means : VISA
transmission_date : 20141022064042
payment_time : 084224
payment_date : 20141022
response_code : 00
payment_certificate : dd68d6aaa9a6
authorisation_id : 063532
currency_code : 978
card_number : 4975.33
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.triconnet01
order_id : 1923
customer_email : c.triconnet01@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 : 201601
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "1924" 
select * from cms_frontusers where identifiant = "s.gerardin05" 
 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 = "1924" 
 select * from cotisations where identifiant = "s.gerardin05" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 093039
payment_means : VISA
transmission_date : 20141022073039
payment_time : 093203
payment_date : 20141022
response_code : 00
payment_certificate : 7799a7ed98d3
authorisation_id : 262140
currency_code : 978
card_number : 4977.88
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.gerardin05
order_id : 1924
customer_email : s.gerardin05@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 = "1926" 
select * from cms_frontusers where identifiant = "e.pomies09" 
 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 = "1926" 
 select * from cotisations where identifiant = "e.pomies09" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 153903
payment_means : MASTERCARD
transmission_date : 20141022133903
payment_time : 154101
payment_date : 20141022
response_code : 00
payment_certificate : 57a8b51d3655
authorisation_id : 681216
currency_code : 978
card_number : 5132.88
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.pomies09
order_id : 1926
customer_email : e.pomies09@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 = "1927" 
select * from cms_frontusers where identifiant = "j.ladouce08" 
 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 = "1927" 
 select * from cotisations where identifiant = "j.ladouce08" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 174359
payment_means : MASTERCARD
transmission_date : 20141022154359
payment_time : 174527
payment_date : 20141022
response_code : 00
payment_certificate : ec961282b276
authorisation_id : 614166
currency_code : 978
card_number : 5136.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 : j.ladouce08
order_id : 1927
customer_email : j.ladouce08@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 = "1928" 
select * from cms_frontusers where identifiant = "c.cotilleau26" 
 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 = "1928" 
 select * from cotisations where identifiant = "c.cotilleau26" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 185434
payment_means : VISA
transmission_date : 20141022165434
payment_time : 185542
payment_date : 20141022
response_code : 00
payment_certificate : f38b20080007
authorisation_id : 008614
currency_code : 978
card_number : 4659.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 : c.cotilleau26
order_id : 1928
customer_email : c.cotilleau26@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 : 201607
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "1929" 
select * from cms_frontusers where identifiant = "j.camps18" 
 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 = "1929" 
 select * from cotisations where identifiant = "j.camps18" and annee = "2014" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 200650
payment_means : VISA
transmission_date : 20141022180650
payment_time : 200833
payment_date : 20141022
response_code : 00
payment_certificate : 6ee5d3d3f814
authorisation_id : 813832
currency_code : 978
card_number : 4970.27
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.camps18
order_id : 1929
customer_email : j.camps18@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 = "1930" 
select * from cms_frontusers where identifiant = "l.rey13" 
 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 = "1930" 
 select * from cotisations where identifiant = "l.rey13" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 201720
payment_means : MASTERCARD
transmission_date : 20141022181720
payment_time : 202001
payment_date : 20141022
response_code : 00
payment_certificate : b5e9f6eb003d
authorisation_id : 126326
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 : l.rey13
order_id : 1930
customer_email : l.rey13@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 = "1931" 
select * from cms_frontusers where identifiant = "m.bronsard04" 
 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 = "1931" 
 select * from cotisations where identifiant = "m.maze11" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 202453
payment_means : MASTERCARD
transmission_date : 20141022182453
payment_time : 202923
payment_date : 20141022
response_code : 00
payment_certificate : b7c8e750bc93
authorisation_id : 410640
currency_code : 978
card_number : 5138.26
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.bronsard04
order_id : 1931
customer_email : m.bronsard04@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 : 201607
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "1932" 
select * from cms_frontusers where identifiant = "s.baudiere31" 
 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 = "1932" 
 select * from cotisations where identifiant = "s.baudiere31" and annee = "2014" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 203841
payment_means : VISA
transmission_date : 20141022183841
payment_time : 204017
payment_date : 20141022
response_code : 00
payment_certificate : 069e4ecaf80f
authorisation_id : 684770
currency_code : 978
card_number : 4970.99
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.baudiere31
order_id : 1932
customer_email : s.baudiere31@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 = "1933" 
select * from cms_frontusers where identifiant = "f.chevreuil20" 
 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 = "1933" 
 select * from cotisations where identifiant = "f.chevreuil20" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 210728
payment_means : VISA
transmission_date : 20141022190728
payment_time : 210842
payment_date : 20141022
response_code : 00
payment_certificate : 56e6c39597bf
authorisation_id : 177076
currency_code : 978
card_number : 4757.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 : f.chevreuil20
order_id : 1933
customer_email : f.chevreuil20@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 : 201508
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "1934" 
select * from cms_frontusers where identifiant = "j.andrestonetto30" 
 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 = "1934" 
 select * from cotisations where identifiant = "j.andrestonetto30" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 5000
transaction_id : 211254
payment_means : MASTERCARD
transmission_date : 20141022191254
payment_time : 211556
payment_date : 20141022
response_code : 00
payment_certificate : 8b1e419083d4
authorisation_id : 393286
currency_code : 978
card_number : 5341.15
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.andrestonetto30
order_id : 1934
customer_email : j.andrestonetto30@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 = "1935" 
select * from cms_frontusers where identifiant = "l.faure22" 
 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 = "1935" 
 select * from cotisations where identifiant = "l.faure22" and annee = "2014" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 211945
payment_means : MASTERCARD
transmission_date : 20141022191945
payment_time : 212239
payment_date : 20141022
response_code : 00
payment_certificate : 076afc466bca
authorisation_id : 336212
currency_code : 978
card_number : 5341.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 : l.faure22
order_id : 1935
customer_email : l.faure22@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 : 8000
transaction_id : 212534
payment_means : MASTERCARD
transmission_date : 20141022192534
payment_time : 213219
payment_date : 20141022
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5341.19
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.camail14
order_id : 1936
customer_email : m.camail14@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 = "1936" 
select * from cms_frontusers where identifiant = "m.camail14" 
 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 = "1936" 
 select * from cotisations where identifiant = "m.camail14" and annee = "2014" and montant <> 0 
 select * from cotisations where identifiant = "m.camail14" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 213231
payment_means : MASTERCARD
transmission_date : 20141022193231
payment_time : 213511
payment_date : 20141022
response_code : 00
payment_certificate : c204c1a081cd
authorisation_id : 189166
currency_code : 978
card_number : 5341.19
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.camail14
order_id : 1936
customer_email : m.camail14@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 : 212823
payment_means : MASTERCARD
transmission_date : 20141022192823
payment_time : 213515
payment_date : 20141022
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5132.43
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.thorr02
order_id : 1937
customer_email : b.thorr02@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 : 201605
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 : 213524
payment_means : MASTERCARD
transmission_date : 20141022193524
payment_time : 213746
payment_date : 20141022
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5132.43
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.thorr02
order_id : 1937
customer_email : b.thorr02@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 : 201605
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 : 213806
payment_means : VISA
transmission_date : 20141022193806
payment_time : 214026
payment_date : 20141022
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 4977.35
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.thorr02
order_id : 1937
customer_email : b.thorr02@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 : 201603
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "1938" 
select * from cms_frontusers where identifiant = "v.payn11" 
 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 = "1938" 
 select * from cotisations where identifiant = "v.payn11" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 213904
payment_means : MASTERCARD
transmission_date : 20141022193904
payment_time : 214123
payment_date : 20141022
response_code : 00
payment_certificate : 4eb0c1720db2
authorisation_id : 095222
currency_code : 978
card_number : 5132.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 : v.payn11
order_id : 1938
customer_email : v.payn11@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 = "1940" 
select * from cms_frontusers where identifiant = "t.cadet11" 
 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 = "1940" 
 select * from cotisations where identifiant = "t.cadet11" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 230431
payment_means : VISA
transmission_date : 20141022210431
payment_time : 230649
payment_date : 20141022
response_code : 00
payment_certificate : bfc6dc6d9fde
authorisation_id : 130421
currency_code : 978
card_number : 4975.32
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.cadet11
order_id : 1940
customer_email : t.cadet11@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 : 
-------------------------------------------