public function execute() { global $gvOfficeCode; $deskList = Desk::fromDatabaseCompleteList(); $content = array(); if (!$deskList) { $content['ErrorCode'] = "AE004"; $content['ErrorMsg'] = "No desks in this office"; return $content; } $content['OfficeCode'] = $gvOfficeCode; $content['NumDesks'] = count($deskList); $content['Desks'] = array(); foreach ($deskList as $desk) { if ($desk->getOpCode() != null) { $ticket = Ticket::fromDatabaseByDesk($desk->getNumber()); if ($ticket) { $ticket = $ticket->getTextString(); } else { $ticket = ''; } } else { $ticket = ''; } $deskObj = array('Number' => $desk->getNumber(), 'Ticket' => $ticket); $content['Desks'][] = $deskObj; } return $content; }
private function getTableBody() { global $gvPath; $desks = Desk::fromDatabaseCompleteList(); if (count($desks) === 0) { return '<tr><td colspan="3" class="noEntry">Nessuno sportello</td></tr>'; } $ret = ""; foreach ($desks as $desk) { $ret .= <<<EOS <tr> <td>{$desk->getNumber()}</td> <td>{$desk->getIpAddress()}</td> \t<td><a href="{$gvPath}/application/adminDeskEdit?desk_id={$desk->getId()}" class="tdEditLink">Modifica</a> <a class="ajaxRemove" href="{$gvPath}/ajax/removeRecord?desk_id={$desk->getId()}">Rimuovi</a></td> </tr> EOS; } return $ret; }
<?php include '../Setup.php'; $desks = Desk::fromDatabaseCompleteList(); foreach ($desks as $desk) { if (time() - $desk->getLastActivityTime() >= $gvSessionTimeout) { $desk->setLastActivityTime(null); $desk->setOpCode(null); $desk->save(); } } Database::getConnection()->commit();