TRF CIMAC

setQuery("SELECT * FROM `trf-details` LEFT JOIN auth_users ON `trf-details`.iduser=auth_users.id LEFT JOIN company ON `trf-details`.idcompany=company.idcompany LEFT JOIN article_type ON `trf-details`.idarticletype=article_type.idarticletype LEFT JOIN certificationtype ON certificationtype.idcertificationtype=`trf-details`.idcertification WHERE `trf-details`.signedon !='' GROUP BY `trf-details`.trfnumber ORDER BY `trf-details`.revtrf, `trf-details`.trfnumber DESC"); $archivetrflist->execute(); */ ?> setQuery("SELECT td.*, companyname_company, certificationtype.name_certification, article_type.name_articletype, auth_users.email FROM `trf-details` AS td LEFT JOIN auth_users ON td.iduser = auth_users.id LEFT JOIN company ON td.idcompany = company.idcompany LEFT JOIN article_type ON td.idarticletype = article_type.idarticletype LEFT JOIN certificationtype ON certificationtype.idcertificationtype = td.idcertification WHERE td.signedon != '' AND ( td.revtrf IS NULL OR (td.trfnumber, td.revtrf) IN ( SELECT trfnumber, MAX(revtrf) AS max_revtrf FROM `trf-details` WHERE signedon != '' GROUP BY trfnumber ) ) ORDER BY td.trfnumber DESC;"); $archivetrflist->execute(); ?> setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.iduser='$iduserlogin' AND `trf-details`.signedon IS NULL ORDER BY `trf-details`.trfnumber"); $drafttrf->execute(); ?> TRF CIMAC

CS TRF DASHBOARD

TRF CLIENTS

Mostra/Nascondi colonne: TRF N. - Signed On - Company Name - Description - Cert Type - Article Type

atEnd()) { $wa_startindex = $archivetrflist->Index; ?> moveNext(); } $archivetrflist->moveFirst(); //return RS to first record unset($wa_startindex); unset($wa_repeatcount); ?>

TRF N.	Rev	Signed On	Company Name	Insert by	Description	Cert Type	Article type	PDF1	PDF2	ZIP	CS Charge	ACTION
getColumnVal("trfnumber")); ?>	getColumnVal("revtrf")); ?>	getColumnVal("signedon")); ?>	getColumnVal("companyname_company")); ?>	?subject=Domanda su Application Form N. getColumnVal("trfnumber"); ?> &body=Buongiorno getColumnVal("first_name"); ?> getColumnVal("last_name"); ?>">getColumnVal("email")); ?>	getColumnVal("sample_description")); ?>	getColumnVal("name_certification")); ?>	getColumnVal("name_articletype")); ?>	" target="_blank" >	getColumnVal("pdffilename2"))) { ?>" target="_blank" >	getColumnVal("zipname"))) { ?>" target="_blank" >	getColumnVal("csincharge")); ?>	', '_blank', 'location=yes,height=500,width=850,scrollbars=yes,status=yes');">