System->Modules['Finance']; $this->System->Modules['Finance']->LoadTariffs(1); if(!$this->System->Modules['User']->CheckPermission('Finance', 'SubjectList')) return('Nemáte oprávnění'); $Output = 'Seznam účastníků:
'; $Query = 'SELECT MonthlyTotal, Cash, Subject.Id, Subject.WWW, Subject.Note, Subject.Name, NetworkDevice, InternetTariffCurrentMonth, InternetTariffNextMonth, User.Name AS FullName FROM MemberPayment LEFT JOIN Member ON Member.Id=MemberPayment.Member LEFT JOIN Subject ON Subject.Id=Member.Subject JOIN User ON User.Id=Member.ResponsibleUser'; $DbResult = $this->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS T'); $DbRow = $DbResult->fetch_row(); $PageList = GetPageList($DbRow[0]); $Output = $PageList['Output']; $Output .= ''; $TableColumns = array( array('Name' => 'FullName', 'Title' => 'Zástupce'), array('Name' => 'Name', 'Title' => 'Subjekt'), array('Name' => 'MonthlyTotal', 'Title' => 'Měsíční poplatek [Kč]'), array('Name' => 'Cash', 'Title' => 'Stav účtu [Kč]'), array('Name' => 'InternetTariffCurrentMonth', 'Title' => 'Běžící tarif'), array('Name' => 'InternetTariffNextMonth', 'Title' => 'Příští tarif'), array('Name' => 'Note', 'Title' => 'Poznámky'), array('Name' => 'WWW', 'Title' => 'WWW'), ); $Order = GetOrderTableHeader($TableColumns, 'FullName', 0); $Output .= $Order['Output']; $Query = $Query.' '.$Order['SQL'].$PageList['SQLLimit']; $DbResult = $this->Database->query($Query); $TotalDevice = 0; $TotalMonth = 0; $TotalCash = 0; while($Row = $DbResult->fetch_assoc()) { //$Row['cash'] = $Row['AdvancesIn'] - $Row['AdvancesOut'] + $Row['Liabilities'] - $Row['Claims']; $TotalCash += $Row['Cash']; if($Row['Cash'] < 0) $Row['Cash'] = ''.$Row['Cash'].''; $Tarif = $Finance->Tariffs[$Row['InternetTariffCurrentMonth']]['Name']; $PristiTarif = $Finance->Tariffs[$Row['InternetTariffNextMonth']]['Name']; $Output .= ''; // $Output .= ''; $TotalDevice += $Row['NetworkDevice']; $TotalMonth += ($Row['MonthlyTotal']); } $Output .= ''; // $Output .= ''; $Output .= '

'.$Row['FullName'].'	'.$Row['Name'].'	'.$Row['network_device'].'	'.$Row['MonthlyTotal'].'	'.$Row['Cash'].'	'.$Tarif.'	'.$PristiTarif.'	'.$Row['Note'].'	'.$Row['WWW'].'
Celkem		'.$TotalDevice.'	'.$TotalMonth.'	'.$TotalCash.'

'; $Output .= $PageList['Output']; return($Output); } } $System->AddModule(new FinanceUserList()); $System->Modules['FinanceUserList']->GetOutput(); ?>