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 data_td.*, `trf-details`.*, company.*, data_td.zipname AS tdzipname 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.signnametd IS NOT NULL AND data_td.signedontd IS NOT NULL AND data_td.pdffilenametd IS NOT NULL ORDER BY data_td.signedontd DESC "); $drafttd->execute(); ?> TRF CIMAC
  1. TRF
  2. Starter

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 Signed on Description Client PDF ZIP Action
getColumnVal("tdnumber")); ?> getColumnVal("td_rev")) > 0) { ?>RgetColumnVal("td_rev"); } ?> getColumnVal("signedontd")); ?> getColumnVal("sample_description")); ?> getColumnVal("companyname_company")); ?> getColumnVal("pdffilenametd"))) : ?> " target="_blank"> getColumnVal("tdzipname"))) : ?> " target="_blank"> ">