List of certificates
Echec lors de la connexion à MySQL : Access denied for user 'www-data'@'localhost' (using password: NO)
erreur MySQL : local
()
requete
SELECT oper.noop , concat( oper.nom ,' ',IfNULL(oper.nom2,''),'
',IfNULL(oper.adres,'') ,' ',IfNULL(oper.adres2,'') ,'
',IFNULL(oper.cp,''),
' ',oper.loc,IfNULL(concat('
',oper.pays),' ')) nom , oper.cp , oper.pays
from ecocert.oper WHERE oper.noop = 20316
Certificates of
| Type of certificate |
N° of certificate |
Date of certificate |
Language of certificate |
|
erreur MySQL : local
()
requete
select oper.noop , certico.ico , oper.nom , langue.txt lalg
, certtydoctxt.txt , CONCAT( doccerti.tydoc , doccerti.nodoc , doccerti.lg ) nocert
, CONCAT( doccerti.tydoc , doccerti.nodoc , doccerti.lg , '.pdf') fichier ,DATE_FORMAT(doccerti.docdate , '%e/%c/%Y' ) docdate
, if( doccerti.docdate < curdate(),'http://certificat.certisys.eu/' ,'http://data.certisys.eu/certificat/' ) liencert
, doccerti.dfin
from ecocert.oper , ecocert.sysop , ecocert.certtydoc , ecocert.certico , ecocert.doccerti
left outer join ecocert.certtydoctxt on certtydoctxt.tydoc = doccerti.tydoc AND certtydoctxt.lg = 'en'
left outer join ecocert.langue on langue.lgtxt = doccerti.lg AND langue.lg = certtydoctxt.lg
WHERE sysop.noop = oper.noop AND certtydoc.sycert = sysop.sycert AND doccerti.noop = sysop.noop AND ( doccerti.dfin > NOW()
) AND doccerti.tydoc = certtydoc.tydoc
AND sysop.etat in ('certifie', 'actif' , 'suspend') AND certico.tydoc = doccerti.tydoc
AND (doccerti.alea IS NULL OR doccerti.alea = 0 ) AND oper.noop = 20316
ORDER BY 1 , doccerti.docdate DESC
erreur MySQL : local
()
requete
SELECT oper.noop
from ecocert.oper , ecocert.sysop , ecocert.doccerti
WHERE sysop.noop = oper.noop AND doccerti.noop = sysop.noop AND ( doccerti.dfin > NOW() )
AND sysop.etat in ('certifie', 'actif' , 'suspend')
AND (doccerti.alea IS NOT NULL ) AND oper.noop = 20316
GROUP BY 1
