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 * FROM auth_users ORDER BY auth_users.last_name 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

USERS

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

Nome	Cognome	Email	Token
getColumnVal("first_name")); ?>	getColumnVal("last_name")); ?>	getColumnVal("email")); ?>	getColumnVal("signaturecode")); ?>