/** * get a list of tickers for this image */ function &getTroubleTickets($aStatus) { global $MESSAGES; if (!is_array($aStatus)) { die("GridImage::getTroubleTickets expects array param"); } $db =& $this->_getDB(); $statuses = "'" . implode("','", $aStatus) . "'"; $tickets = array(); $recordSet =& $db->Execute("select t.*,u.realname as suggester_name,DATEDIFF(NOW(),t.updated) as days from gridimage_ticket as t " . "inner join user as u using(user_id) " . "where t.gridimage_id={$this->gridimage_id} and t.status in ({$statuses}) order by t.updated desc"); while (!$recordSet->EOF) { //create new ticket object $t = new GridImageTroubleTicket(); $t->loadFromRecordset($recordSet); if ($t->days > 365) { $t->days = $MESSAGES['class_gridimage']['days_365']; } elseif ($t->days > 30) { $t->days = sprintf($MESSAGES['class_gridimage']['days_30'], intval($t->days / 30)); } elseif ($t->days > 14) { $t->days = sprintf($MESSAGES['class_gridimage']['days_14'], intval($t->days / 7)); } elseif ($t->days > 7) { $t->days = $MESSAGES['class_gridimage']['days_7']; } elseif ($t->days > 1) { $t->days = sprintf($MESSAGES['class_gridimage']['days_gt1'], $t->days); } elseif ($t->days < 1) { $t->days = $MESSAGES['class_gridimage']['days_lt1']; } else { $t->days = $MESSAGES['class_gridimage']['days_eq1']; } //load its ticket items (should this be part of load from Recordset? $t->loadItems(); $t->loadComments(); $tickets[] = $t; $recordSet->MoveNext(); } $recordSet->Close(); return $tickets; }