static function listbyaccount($AccountID, $pagenum = 1) { global $DB, $LANG; $page_posts = 25; $spos = ($pagenum - 1) * $page_posts; $result = $DB->query_adv("SELECT SQL_CALC_FOUND_ROWS * FROM `History` LEFT JOIN `Users` USING (`UserID`) WHERE `AccountID`={$AccountID} ORDER BY `HistoryID` DESC LIMIT {$spos},{$page_posts}"); $FOUND_ROWS = $DB->row($DB->query_adv('SELECT FOUND_ROWS()')); $count = $FOUND_ROWS['FOUND_ROWS()']; $show = beginTable($LANG['History'] . ' ' . $count . ' записей'); $show .= makeTH($LANG['Actions'], $LANG['Description'], $LANG['User'], 'Время', 'IP'); while ($row = $DB->row($result)) { $show .= makeTD($row['action'], '<pre>' . $row['text'] . '</pre>', empty($row['username']) ? '---' : $row['username'], $row['time'], $row['ip']); } $show .= '<tr><td colspan="3" class="nob">'; $show .= makePageNav($pagenum, $page_posts, $count, iSELF . '?object=account&action=history&AccountID=' . $AccountID . '&'); $show .= '</td></tr>'; $show .= endTable(); return $show; }
static function listbyaccount($AccountID, $pagenum = 1) { global $DB, $LANG; $result = $DB->make_select('Pool', 'SQL_CALC_FOUND_ROWS *', '`AccountID`=' . $AccountID, 'PoolID', 'DESC'); $FOUND_ROWS = $DB->row($DB->query_adv('SELECT FOUND_ROWS()')); $count = $FOUND_ROWS['FOUND_ROWS()']; $show = beginTable($LANG['History'] . ' задач ' . $count . ' записей'); $show .= makeTH('info', 'status', 'ServerID', 'time'); while ($data = $DB->row($result)) { $show .= makeTD('<a href="?object=pool&action=show&PoolID=' . $data['PoolID'] . '">' . $data['description'] . '</a>', $data['status'], $data['ServerID'], $data['lastrenty']); } $show .= endTable(); return $show; }
/** * Used to draw a described checkbox in a table * takes care of everything including surrounding TR's * @param cginame - the input name * @param value - the input value to be passed back * @param state - boolean, if true - makes it checked * @param name - the Text to show next to the checkbox * @param description - the text to show with onhover (if supported) */ function makeTDCheckBox($cginame, $value = 1, $state = false, $name, $description, $color = null, $onClickWarning = null) { $result = "<TD>"; $result .= "<INPUT type='checkbox' name='{$cginame}' value='{$value}' " . ($state ? " CHECKED " : ""); if (isset($onClickWarning)) { $result .= " onclick=\"if (value==checked) alert('{$onClickWarning}')\"; "; } $result .= ">"; //$result .= "<TD><A onmouseout=\"window.status='';\" onmouseover=\"window.status='$description'; return true;\">"; $result .= "</TD>\n"; $result .= makeTD($name, $description, $color); return $result; }
public function ShowServices() { global $LANG; $services = Service::load_service('*', '`AccountID`=' . $this->id); $show = beginTable(count($services) . " {$LANG['Services']}", '100%'); $show .= makeTH($LANG['Service'], $LANG['Price'], 'Инфо', $LANG['CreateDate'], $LANG['CloseDate'], 'Списано услугой, руб.'); foreach ($services as $serv) { /* if($serv->ServiceID == 'hosting') { foreach($serv->mod as $mod) { $show .= makeTD( "<a href='?object=service&action=show&ServiceID=$serv->id'>$serv->name</a>", round($mod['price'],2), $mod['package']->id, date('d.m.Y H:i',$mod['opentime']), $mod['time'] == 0 ? '---------' : date('d.m.Y H:i',$mod['opentime']+$mod['time']), round($mod['summ'],4) ); } }else */ $show .= makeTD("<a href='?object=service&action=show&ServiceID={$serv->id}'>{$serv->name}</a>", round($serv->price, 2), $serv->getInfo(), date('d.m.Y H:i', strtotime($serv->opentime)), $serv->closetime == '0000-00-00 00:00:00' ? '---------' : date('d.m.Y H:i', strtotime($serv->closetime)), round($serv->getSumm(), 4)); } $show .= endTable(); return $show; }
static function list_domain($pagenum = 1) { global $LANG, $DB; $page_posts = 20; $spos = ($pagenum - 1) * $page_posts; $objs = Domain::load_domains('*', '', 'DomainID', 'DESC', $page_posts, $spos); $count = $DB->count_objs('Domains'); $result = beginTable("{$count} {$LANG['Domains']}", '100%'); $result .= makeTH($LANG['ID'], $LANG['Title']); foreach ($objs as $obj) { $result .= makeTD("<a href='?object=domain&action=show&DomainID={$obj->id}'>{$obj->id}</a>", $obj->name); } $result .= '<tr><td colspan="10" class="nob">'; $result .= makePageNav($pagenum, $page_posts, $count, iSELF . '?object=domain&action=list&'); $result .= '</td></tr>'; $result .= endTable(); return $result; }