System->Modules['Finance']; $this->System->Modules['Finance']->LoadTariffs(1); if(array_key_exists('Subject', $_GET)) { if(!$this->System->Modules['User']->CheckPermission('Finance', 'Manage')) return('Nemáte oprávnění'); $DbResult = $this->Database->query('SELECT * FROM Subject WHERE Id='.$_GET['Subject']); $Subject = $DbResult->fetch_assoc(); } else { if(!$this->System->Modules['User']->CheckPermission('Finance', 'DisplaySubjectState')) return('Nemáte oprávnění'); $UserId = $this->System->Modules['User']->User['Id']; $DbResult = $this->Database->query('SELECT * FROM Subject WHERE Id=(SELECT Subject FROM Member WHERE Id=(SELECT Member FROM User WHERE Id='.$UserId.'))'); $Subject = $DbResult->fetch_assoc(); } if(!array_key_exists('show', $_GET)) $_GET['show'] = ''; $DbResult = $this->Database->query('SELECT * FROM Member LEFT JOIN MemberPayment ON MemberPayment.Member=Member.Id WHERE Member.Subject='.$Subject['Id']); $Member = $DbResult->fetch_assoc(); $TarifName = $Finance->Tariffs[$Member['InternetTariffCurrentMonth']]['Name']; $TarifPrice = $Finance->Tariffs[$Member['InternetTariffCurrentMonth']]['Price']; $Output = '

'; if(array_key_exists('year', $_GET)) { $DbResult = $this->Database->query('SELECT * FROM FinanceYear WHERE Id='.addslashes($_GET['year'] * 1)); } else { $DbResult = $this->Database->query('SELECT * FROM FinanceYear ORDER BY Year DESC LIMIT 1'); } $FinanceYearSelected = $DbResult->fetch_assoc(); $YearWhere = ' WHERE (Time >= "'.$FinanceYearSelected['DateStart'].'") AND (Time <= "'.$FinanceYearSelected['DateEnd'].'")'; // Year list if(array_key_exists('Subject', $_GET)) $SubjectParam = '&Subject='.($_GET['Subject'] * 1); else $SubjectParam = ''; $Output .= 'Roky: '; $DbResult = $this->Database->query('SELECT * FROM FinanceYear'); while($FinanceYear = $DbResult->fetch_assoc()) { $Year = ''.$FinanceYear['Year'].' '; if($FinanceYear['Id'] == $FinanceYearSelected['Id']) $Output .= ''.$Year.''; else $Output .= $Year; } $Output .= ' '; // Account state $UserOperationTableQuery = '((SELECT Text, Time, Value AS Value, Bill FROM FinanceOperation WHERE (Subject='.$Subject['Id'].')) UNION ALL '. '(SELECT Text, TimeCreation as Time, -Value as Value, Bill FROM FinanceClaimsLiabilities WHERE (Subject='.$Subject['Id'].')) ORDER BY Time DESC) AS T1'; $DbResult = $this->Database->query('SELECT SUM(T1.Value) AS Total FROM '.$UserOperationTableQuery); $DbRow = $DbResult->fetch_array(); $Total = $DbRow['Total']; $Output .= 'Stav účtu: '.$Total.' Kč '; // Tabulka operaci $Output .= 'Výpis operací pro subjekt '.$Subject['Name'].': '; $Output .= ''; $Operations = array(); $DbResult = $this->Database->query('SELECT T1.* FROM '.$UserOperationTableQuery.$YearWhere); while($DbRow = $DbResult->fetch_array()) $Operations[] = $DbRow; $SumValue = 0; foreach($Operations as $Row) { if($Row['Value'] == -0) $Row['Value'] = 0; if($Row['Value'] > 0) $Row['Value'] = '+'.$Row['Value']; if($Row['Bill'] > 0) $Invoice = 'PDF'; else $Invoice = ' '; $Output .= ''; $SumValue = $SumValue + $Row['Value']; } $Output .= ''; //echo(' $Output .= ' Datum Popis Částka Doklad '.HumanDate($Row['Time']).' '.$Row['Text'].' '.$Row['Value'].' '.$Invoice.' Celkem za rok '.$SumValue.'     -'.$Row2['network_device'].' Proměnná cena za zařízení '; $Output .= '

'; $Output .= 'Variabilní symbol pro platby: '.$Subject['Id'].' '; $Total = 0; $Output .= 'Rozpis měsíčního poplatku: '. ''. ''; $Total += $TarifPrice; if($Member['Hire'] != 0) { $Output .= ''; $Total -= $Member['Hire']; } if($Member['MonthlyPlus'] != 0) { $Output .= ''; $Total -= $Member['MonthlyPlus']; } $Output .= ' Část Cena [Kč] Internet - tarif '.$TarifName.' '.$TarifPrice.' Nájem '.(-$Member['Hire']).' Příjem za spotřebu '.(-$Member['MonthlyPlus']).' Celkem '.$Total.' '; //echo('Tarif pro příští měsíc: '.$Tarify[$Row2['inet_tarif_next']]['name'].' '); $Output .= ' '; if($Member['MonthlyPlus'] != 0) { $Output .= 'Měsíční příjem za spotřebu zařízení umístěných u uživatele: '; $Output .= ''; $DbResult = $this->Database->query('SELECT * FROM network_devices WHERE user='.$Member['Subject'].' AND used=1'); $TotalW = 0; $TotalPrice = 0; while($Row = $DbResult->fetch_assoc()) { $Output .= ''; $TotalW += $Row['consumption']; $TotalPrice += $this->System->Modules['Finance']->W2Kc($Row['consumption']); } $Output .= ''; $Output .= ' Název zařízení Spotřeba [W] Příjem [Kč] '.$Row['name'].' '.$Row['consumption'].' '.$this->System->Modules['Finance']->W2Kc($Row['consumption']).' Celkem '.$TotalW.' '.$TotalPrice.' '; } $Output .= '

'; return($Output); } } $System->AddModule(new FinanceUserState()); $System->Modules['FinanceUserState']->GetOutput(); ?>