select * from cotisations_commande where id = "6809" 
select * from cms_frontusers where identifiant = "b.lassonnerie13" 
 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 = "6809" 
 select * from cotisations where identifiant = "b.lassonnerie13" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 080035
payment_means : VISA
transmission_date : 20150411060035
payment_time : 080232
payment_date : 20150411
response_code : 00
payment_certificate : 71b69146be1d
authorisation_id : 122069
currency_code : 978
card_number : 4972.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 : b.lassonnerie13
order_id : 6809
customer_email : b.lassonnerie13@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201712
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "6810" 
select * from cms_frontusers where identifiant = "p.bonnifait28" 
 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 = "6810" 
 select * from cotisations where identifiant = "g.bernard04" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 082128
payment_means : VISA
transmission_date : 20150411062128
payment_time : 082348
payment_date : 20150411
response_code : 00
payment_certificate : dfa4584159cb
authorisation_id : 382544
currency_code : 978
card_number : 4976.92
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.bonnifait28
order_id : 6810
customer_email : p.bonnifait28@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 : 4000
transaction_id : 090147
payment_means : MASTERCARD
transmission_date : 20150411070147
payment_time : 090425
payment_date : 20150411
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5138.44
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 : f.legendre22
order_id : 6811
customer_email : f.legendre22@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 : 201607
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "6811" 
select * from cms_frontusers where identifiant = "f.legendre22" 
 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 = "6811" 
 select * from cotisations where identifiant = "f.legendre22" and annee = "2014" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 090527
payment_means : MASTERCARD
transmission_date : 20150411070527
payment_time : 090900
payment_date : 20150411
response_code : 00
payment_certificate : 7d17463f1244
authorisation_id : 499398
currency_code : 978
card_number : 5132.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.legendre22
order_id : 6811
customer_email : f.legendre22@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 100049
payment_means : MASTERCARD
transmission_date : 20150411080049
payment_time : 100502
payment_date : 20150411
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.88
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.gourdon27
order_id : 6812
customer_email : a.gourdon27@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 : 201601
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "6812" 
select * from cms_frontusers where identifiant = "a.gourdon27" 
 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 = "6812" 
 select * from cotisations where identifiant = "a.gourdon27" and annee = "2014" and montant <> 0 
 select * from cotisations where identifiant = "a.gourdon27" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 100518
payment_means : MASTERCARD
transmission_date : 20150411080518
payment_time : 100839
payment_date : 20150411
response_code : 00
payment_certificate : 48e96d2dfebb
authorisation_id : 100532
currency_code : 978
card_number : 5131.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 : a.gourdon27
order_id : 6812
customer_email : a.gourdon27@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 = "6813" 
select * from cms_frontusers where identifiant = "j.tavernier03" 
 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 = "6813" 
 select * from cotisations where identifiant = "j.tavernier03" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 110058
payment_means : VISA
transmission_date : 20150411090058
payment_time : 110228
payment_date : 20150411
response_code : 00
payment_certificate : be5f72898512
authorisation_id : 014222
currency_code : 978
card_number : 4970.93
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.tavernier03
order_id : 6813
customer_email : j.tavernier03@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 = "6814" 
select * from cms_frontusers where identifiant = "j.thal25" 
 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 = "6814" 
 select * from cotisations where identifiant = "a.poujaud26" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 111907
payment_means : MASTERCARD
transmission_date : 20150411091907
payment_time : 112016
payment_date : 20150411
response_code : 00
payment_certificate : b5be535350a3
authorisation_id : 233961
currency_code : 978
card_number : 5131.87
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.thal25
order_id : 6814
customer_email : j.thal25@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 113149
payment_means : MASTERCARD
transmission_date : 20150411093149
payment_time : 113339
payment_date : 20150411
response_code : 05
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5131.93
cvv_flag : 1
cvv_response_code : ??
bank_response_code : 51
complementary_code : 00
complementary_info : 
return_context : 
caddie : 
receipt_complement : 
merchant_language : fr
language : fr
customer_id : t.marhic04
order_id : 6815
customer_email : t.marhic04@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 = "6816" 
select * from cms_frontusers where identifiant = "p.rolandbaty26" 
 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 = "6816" 
 select * from cotisations where identifiant = "p.rolandbaty26" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 114929
payment_means : VISA
transmission_date : 20150411094929
payment_time : 115126
payment_date : 20150411
response_code : 00
payment_certificate : 3468b005b949
authorisation_id : 528323
currency_code : 978
card_number : 4972.06
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.rolandbaty26
order_id : 6816
customer_email : p.rolandbaty26@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 = "6817" 
select * from cms_frontusers where identifiant = "r.dagois22" 
 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 = "6817" 
 select * from cotisations where identifiant = "r.dagois22" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 115206
payment_means : MASTERCARD
transmission_date : 20150411095206
payment_time : 115608
payment_date : 20150411
response_code : 00
payment_certificate : d377be777b3b
authorisation_id : 812469
currency_code : 978
card_number : 5131.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 : r.dagois22
order_id : 6817
customer_email : r.dagois22@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 : 201604
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "6818" 
select * from cms_frontusers where identifiant = "j.thal25" 
 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 = "6818" 
 select * from cotisations where identifiant = "j.coq22" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 134222
payment_means : VISA
transmission_date : 20150411114222
payment_time : 134426
payment_date : 20150411
response_code : 00
payment_certificate : 2c3180b852e6
authorisation_id : 512514
currency_code : 978
card_number : 4970.66
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.thal25
order_id : 6818
customer_email : j.thal25@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 : 201604
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "6819" 
select * from cms_frontusers where identifiant = "a.haro16" 
 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 = "6819" 
 select * from cotisations where identifiant = "a.haro16" and annee = "2014" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 134604
payment_means : MASTERCARD
transmission_date : 20150411114604
payment_time : 134828
payment_date : 20150411
response_code : 00
payment_certificate : 5d6f372b9351
authorisation_id : 453582
currency_code : 978
card_number : 5133.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 : a.haro16
order_id : 6819
customer_email : a.haro16@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 = "6820" 
select * from cms_frontusers where identifiant = "a.haro16" 
 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 = "6820" 
 select * from cotisations where identifiant = "a.haro16" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 135208
payment_means : MASTERCARD
transmission_date : 20150411115208
payment_time : 135337
payment_date : 20150411
response_code : 00
payment_certificate : 6cc292f19b3a
authorisation_id : 162326
currency_code : 978
card_number : 5133.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 : a.haro16
order_id : 6820
customer_email : a.haro16@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 = "6821" 
select * from cms_frontusers where identifiant = "j.thal25" 
 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 = "6821" 
 select * from cotisations where identifiant = "p.mercier10" and annee = "2014" and montant <> 0 
 select * from cotisations where identifiant = "p.mercier10" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 135338
payment_means : VISA
transmission_date : 20150411115338
payment_time : 135606
payment_date : 20150411
response_code : 00
payment_certificate : 2438b6415f03
authorisation_id : 436249
currency_code : 978
card_number : 4978.13
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.thal25
order_id : 6821
customer_email : j.thal25@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 = "6822" 
select * from cms_frontusers where identifiant = "j.thal25" 
 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 = "6822" 
 select * from cotisations where identifiant = "k.hurbain05" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 135728
payment_means : MASTERCARD
transmission_date : 20150411115728
payment_time : 135841
payment_date : 20150411
response_code : 00
payment_certificate : 397d54be8a8e
authorisation_id : 484171
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 : j.thal25
order_id : 6822
customer_email : j.thal25@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 = "6823" 
select * from cms_frontusers where identifiant = "j.thal25" 
 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 = "6823" 
 select * from cotisations where identifiant = "s.marlin07" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 140437
payment_means : VISA
transmission_date : 20150411120437
payment_time : 140625
payment_date : 20150411
response_code : 00
payment_certificate : 96ab79a7ca17
authorisation_id : 076203
currency_code : 978
card_number : 4973.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.thal25
order_id : 6823
customer_email : j.thal25@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 = "6824" 
select * from cms_frontusers where identifiant = "j.thal25" 
 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 = "6824" 
 select * from cotisations where identifiant = "g.bertrand02" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 142026
payment_means : VISA
transmission_date : 20150411122026
payment_time : 142146
payment_date : 20150411
response_code : 00
payment_certificate : 12e37c330b0b
authorisation_id : 741556
currency_code : 978
card_number : 4978.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 : j.thal25
order_id : 6824
customer_email : j.thal25@compagnons-du-devoir.fr
customer_ip_address : 
capture_day : 0
capture_mode : AUTHOR_CAPTURE
data : 
order_validity : 02
transaction_condition : 3D_SUCCESS
statement_reference : 
card_validity : 201801
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "6825" 
select * from cms_frontusers where identifiant = "j.thal25" 
 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 = "6825" 
 select * from cotisations where identifiant = "t.wattiau29" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 4000
transaction_id : 150636
payment_means : VISA
transmission_date : 20150411130636
payment_time : 150802
payment_date : 20150411
response_code : 00
payment_certificate : e79f2d6abdb3
authorisation_id : 582353
currency_code : 978
card_number : 4973.09
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.thal25
order_id : 6825
customer_email : j.thal25@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 : 
-------------------------------------------

Il semble y avoir un problème de retour de paiement
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 183221
payment_means : MASTERCARD
transmission_date : 20150411163221
payment_time : 183510
payment_date : 20150411
response_code : 75
payment_certificate : 
authorisation_id : 
currency_code : 978
card_number : 5132.00
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.pondaven11
order_id : 6826
customer_email : b.pondaven11@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 : 201610
score_value : 
score_color : 
score_info : 
score_threshold : 
score_profile : 
-------------------------------------------

 select * from cotisations_commande where id = "6827" 
select * from cms_frontusers where identifiant = "p.fiers05" 
 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 = "6827" 
 select * from cotisations where identifiant = "js.richer27" and annee = "2015" and montant <> 0 
code : 0
error : 
merchant_id : 077566202600019
merchant_country : fr
amount : 8000
transaction_id : 214324
payment_means : MASTERCARD
transmission_date : 20150411194324
payment_time : 214524
payment_date : 20150411
response_code : 00
payment_certificate : 677597b41342
authorisation_id : 58419Z
currency_code : 978
card_number : 5466.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 : p.fiers05
order_id : 6827
customer_email : p.fiers05@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 : 
-------------------------------------------