Variables | |
$dcmPage = new DcmmsPage(_('Pending Complaints by Team')) | |
$strQuery | |
$objTable = new DbTable($dcmPage->postgis->db, $strQuery) | |
$numRows = $objTable->getRowCount() |
|
|
|
|
|
|
|
Initial value: 'select dcmmstranslation(\''.$_SESSION['language'] .'\', team.description) as team, workorder.id from Team, Workorder left join Maintenance on Workorder.ID = Maintenance.ID where (team.codedvalue = workorder.team) '. "and (Maintenance.Status = 1) order by team.description" |