setQuery("SELECT * FROM data_td LEFT JOIN `trf-details` ON `trf-details`.idtrfdetails=data_td.idtrf WHERE data_td.statustd='$idcompany' AND data_td.signedontd IS NOT NULL ORDER BY data_td.signedontd"); $archivetdlist->execute(); ?> setQuery("SELECT * FROM data_td LEFT JOIN `trf-details` ON `trf-details`.idtrfdetails=data_td.idtrf LEFT JOIN company on data_td.idcompany=company.idcompany WHERE data_td.statustd='Revision'"); $drafttd->execute(); ?> TRF CIMAC

atEnd()) { $wa_startindex = $drafttd->Index; ?> getColumnVal("iddata_td"); ?> ">moveNext(); } $drafttd->moveFirst(); //return RS to first record unset($wa_startindex); unset($wa_repeatcount); ?>
TD N. REV Description Client Status
getColumnVal("tdnumber")); ?> getColumnVal("td_rev")) > 0) { ?>RgetColumnVal("td_rev"); } ?> getColumnVal("sample_description")); ?> getColumnVal("companyname_company")); ?> getColumnVal("statustd"); if ($statusnow == "Draft") { ?>
Draft
Revision
Waiting Sign
"> ')">