View file modules/lottery/users.php

<?php
acms_header('Все билеты лотереи', 'users');
is_active_module('PRIVATE_LOTTERY');

$lottery = db::get_string("SELECT * FROM `LOTTERY` WHERE `ID` = ? LIMIT 1", [intval(get('id'))]);

?>
<?php if (isset($lottery['ID'])) : ?>
<div class='list'>
<?=lg('Билеты лотереи')?> <a href='/m/lottery/show/?id=<?=$lottery['ID']?>'><?=tabs($lottery['NAME'])?></a>
</div>
<?php endif ?>
<?

$column = db::get_column("SELECT COUNT(*) FROM `LOTTERY_USER` ".(isset($lottery['ID']) ? "WHERE `LOTTERY_ID` = '".$lottery['ID']."'" : null));
$spage = spage($column, PAGE_SETTINGS);
$page = page($spage);
$limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;

if ($column == 0){ 
  
  html::empty('Пока пусто');
  
}else{
  
  ?><div class='list-body'><?
  
}

$data = db::get_string_all("SELECT * FROM `LOTTERY_USER` ".(isset($lottery['ID']) ? "WHERE `LOTTERY_ID` = '".$lottery['ID']."'" : null)." LIMIT ".$limit.", ".PAGE_SETTINGS);
while ($list = $data->fetch()) {
  
  $lot = db::get_string("SELECT `ID`,`NAME` FROM `LOTTERY` WHERE `ID` = ? LIMIT 1", [$list['LOTTERY_ID']]);
  
  ?>
  <div class='list-menu'>
  <a href='/m/lottery/show/?id=<?=$lot['ID']?>'><?=tabs($lot['NAME'])?></a><br /><br />
  <b><?=lg('Билет')?> #<?=$list['ID_BILET']?></b> - <?=user::login($list['USER_ID'], 0, 1)?>
  </div>
  <?
  
}

if ($column > 0){

  ?></div><?
  
}

get_page('/m/lottery/users/?id='.intval(get('id')).'&', $spage, $page, 'list');

back('/m/lottery/');
acms_footer();