source: trunk/index.php@ 438

Last change on this file since 438 was 438, checked in by chronos, 12 years ago
  • Přesunuto: Soubory s třídamy přesunuty do podsložky Common. Aktualizovány odkazy mezi soubory.
  • Property svn:executable set to *
File size: 15.7 KB
Line 
1<?php
2
3include_once('Common/Global.php');
4
5class IndexPage extends Page
6{
7 var $Dependencies = array('News');
8 var $FullTitle = 'Zděchovský rozcestník';
9 var $ShortTitle = '';
10
11 function ShowLinks($HyperlinkGroup)
12 {
13 $Output = '';
14 $DbResult = $this->Database->query('SELECT * FROM `Hyperlink` WHERE (`Group`='.$HyperlinkGroup['Id'].') AND (`Enable` = 1)');
15 while($HyperLink = $DbResult->fetch_assoc())
16 {
17 if($HyperLink['IconFile'] == '') $HyperLink['IconFile'] = 'clear.png';
18 if(substr($HyperLink['URL'], 0, 4) != 'http') $HyperLink['URL'] = $this->System->Config['Web']['RootFolder'].$HyperLink['URL'];
19 if(($HyperLink['PermissionModule'] == '') or (($HyperLink['PermissionModule'] != '') and $this->System->Modules['User']->Models['User']->CheckPermission($HyperLink['PermissionModule'], $HyperLink['PermissionOperation'])))
20 $Output .= '<img alt="'.$HyperLink['Name'].'" src="images/favicons/'.$HyperLink['IconFile'].'" width="16" height="16" /> <a href="'.$HyperLink['URL'].'">'.$HyperLink['Name'].'</a><br />';
21 }
22 return($this->Panel($HyperlinkGroup['Name'], $Output));
23 }
24
25 function InfoBar()
26 {
27 global $Config;
28
29 $this->Database->select_db($Config['Database']['Database']);
30
31 $Output2 = '';
32
33 $DbResult = $this->Database->query('SELECT COUNT(*) FROM NetworkDevice LEFT JOIN NetworkDeviceType ON NetworkDeviceType.Id = NetworkDevice.Type WHERE NetworkDeviceType.ShowOnline = 1');
34 $DbRow = $DbResult->fetch_array();
35 $TotalComputers = $DbRow[0];
36
37 $DbResult = $this->Database->query('SELECT COUNT(*) FROM NetworkDevice LEFT JOIN NetworkDeviceType ON NetworkDeviceType.Id = NetworkDevice.Type WHERE (NetworkDeviceType.ShowOnline = 1) AND (NetworkDevice.Online = 1)');
38 $DbRow = $DbResult->fetch_array();
39 $OnlineComputers = $DbRow[0];
40
41 $Output = '<img alt="" src="images/favicons/comp.png" width="16" height="16" /> '.$OnlineComputers.' / '.$TotalComputers.' &nbsp; &nbsp; ';
42
43 $DbResult = $this->Database->select('Member', 'COUNT(*)', 'MemberState=0');
44 $DbRow = $DbResult->fetch_array();
45 $TotalUser = $DbRow[0];
46
47 $DbResult = $this->Database->query('SELECT COUNT(DISTINCT(Member)) FROM NetworkDevice LEFT JOIN NetworkDeviceType ON NetworkDeviceType.Id = NetworkDevice.Type WHERE NetworkDeviceType.ShowOnline = 1 AND NetworkDevice.Online = 1');
48 $DbRow = $DbResult->fetch_array();
49 $OnlineUser = $DbRow[0];
50
51 $Output .= '<img alt="" src="images/favicons/house.png" width="16" height="16" /> '.$OnlineUser.' / '.$TotalUser.' &nbsp; &nbsp; ';
52
53 $NetworkUsage = 0;
54 $Output .= '<img alt="" src="images/favicons/usage.png" width="16" height="16" /> '.$NetworkUsage.' % &nbsp; &nbsp; ';
55
56 //$Output .= 'Server běží: '.$this->GetServerUptime().' &nbsp; &nbsp; ';
57
58 if($this->System->Modules['User']->CheckPermission('Finance', 'DisplaySubjectState'))
59 {
60 $DbResult = $this->Database->select('MemberPayment', 'Cash', 'Member=(SELECT Customer FROM UserCustomerRel WHERE Id='.$this->System->Modules['User']->User['Id'].')');
61 if($DbResult->num_rows > 0)
62 {
63 $DbRow = $DbResult->fetch_assoc();
64 $Output2 .= ' &nbsp; &nbsp; <img alt="" src="images/favicons/money.png" width="16" height="16" /> '.$DbRow['Cash'].' Kč';
65 }
66 }
67
68 $Output = '<div class="Navigation"><span class="MenuItem">'.$Output.'</span><div class="MenuItem2">&nbsp;'.$Output2.'</div></div>';
69 return($Output);
70 }
71
72 function UserPanel()
73 {
74 $Output = '<a href="'.$this->System->Config['Web']['RootFolder'].'/?Action=UserOptions">Profil</a><br />';
75 if($this->System->Modules['User']->CheckPermission('Finance', 'MemberOptions'))
76 $Output .= '<a href="'.$this->System->Config['Web']['RootFolder'].'?Action=MemberOptions">Domácnost</a><br />';
77 if($this->System->Modules['User']->CheckPermission('Finance', 'DisplaySubjectState'))
78 $Output .= '<a href="'.$this->System->Config['Web']['RootFolder'].'/finance/user_state.php">Finance</a><br />';
79 if($this->System->Modules['User']->CheckPermission('Network', 'RegistredHostList'))
80 $Output .= '<a href="'.$this->System->Config['Web']['RootFolder'].'/network/user_hosts.php">Počítače</a><br />';
81 if($this->System->Modules['User']->CheckPermission('News', 'Insert'))
82 $Output .= '<a href="'.$this->System->Config['Web']['RootFolder'].'/aktuality/?action=add">Vložení aktuality</a><br />';
83 if($this->System->Modules['User']->CheckPermission('EatingPlace', 'Edit'))
84 $Output .= '<a href="'.$this->System->Config['Web']['RootFolder'].'/jidelna/menuedit.php">Editace jídelníčků</a><br />';
85 if($this->System->Modules['User']->CheckPermission('Finance', 'Manage'))
86 $Output .= '<a href="'.$this->System->Config['Web']['RootFolder'].'/finance/manage.php">Správa financí</a><br />';
87 if($this->System->Modules['User']->CheckPermission('Network', 'Administration'))
88 $Output .= '<a href="'.$this->System->Config['Web']['RootFolder'].'/network/administration.php">Správa sítě</a><br />';
89 if($this->System->Modules['User']->CheckPermission('IS', 'Manage'))
90 $Output .= '<a href="'.$this->System->Link('/is/').'">Správa dat</a><br />';
91 return($Output);
92 }
93
94 function WebcamPanel()
95 {
96 $Output = $this->System->Modules['Webcam']->ShowImage();
97 return($Output);
98 }
99
100 function OnlineHostList()
101 {
102 $Output = '<span style="font-size: smaller;">';
103 $DbResult = $this->Database->query('SELECT NetworkDevice.Name FROM NetworkDevice LEFT JOIN NetworkDeviceType ON NetworkDeviceType.Id = NetworkDevice.Type WHERE (NetworkDeviceType.ShowOnline = 1) AND (NetworkDevice.Online = 1) ORDER BY NetworkDevice.Name');
104 while($Device = $DbResult->fetch_array())
105 {
106 $Output .= $Device['Name'].'<br />';
107 }
108 $Output .= '</span>';
109 return($Output);
110 }
111
112 function ShowBadPayerList()
113 {
114 $Output .= '<div class="PanelTitle">Dlužníci:</div><span style="font-size: smaller;">';
115 $DbResult = $Database->select('Subject', 'Name', 'Money < 0 ORDER BY Money');
116 while($Row = $DbResult->fetch_array())
117 {
118 $Output .= $Row['Name'].'<br />';
119 }
120 $Output .= '</span>';
121 return($Output);
122 }
123
124 function Panel($Title, $Content, $Menu = array())
125 {
126 if(count($Menu) > 0)
127 foreach($Menu as $Item)
128 $Title .= '<div class="Action">'.$Item.'</div>';
129 return('<div class="Panel"><div class="Title">'.$Title.'</div><div class="Content">'.$Content.'</div></div>');
130 }
131
132 function Show()
133 {
134 global $Database, $Config, $User;
135
136 $Output = '';
137 if(array_key_exists('Action', $_GET))
138 {
139 if($_GET['Action'] == 'CustomizeNewsSave')
140 {
141 $Output .= $this->System->Modules['News']->CustomizeSave();
142 } else
143 if($_GET['Action'] == 'LoginForm')
144 {
145 $Form = new Form('UserLogin');
146 $Form->OnSubmit = '?Action=Login';
147 $Output .= $Form->ShowEditForm();
148 $Output .= '<div class="Centred"><a href="?Action=UserRegister">Registrovat se</a> '.
149 '<a href="?Action=PasswordRecovery">Obnova zapomenutého hesla</a></div>';
150 } else
151 if($_GET['Action'] == 'Login')
152 {
153 $Form = new Form('UserLogin');
154 $Form->OnSubmit = '?Action=Login';
155 $Result = $this->System->Modules['User']->Login($_POST['Username'], $_POST['Password']);
156 $Output .= $this->SystemMessage('Přihlášení', $Result);
157 if($Result <> USER_LOGGED_IN)
158 {
159 $Form->LoadValuesFromForm();
160 $Form->Values['Password'] = '';
161 $Output .= $Form->ShowEditForm();
162 $Output .= '<div class="Centred"><a href="?Action=UserRegister">Registrovat se</a> '.
163 '<a href="?Action=PasswordRecovery">Obnova zapomenutého hesla</a></div>';
164 }
165 } else
166 if($_GET['Action'] == 'Logout')
167 {
168 $Output .= $this->SystemMessage('Odhlášení', $this->System->Modules['User']->Logout());
169 } else
170 if($_GET['Action'] == 'UserOptions')
171 {
172 $UserOptions = new Form('UserOptions');
173 $UserOptions->LoadValuesFromDatabase($this->System->Modules['User']->User['Id']);
174 $UserOptions->OnSubmit = '?Action=UserOptionsSave';
175 $Output .= $UserOptions->ShowEditForm();
176 } else
177 if($_GET['Action'] == 'UserOptionsSave')
178 {
179 $UserOptions = new Form('UserOptions', array());
180 $UserOptions->LoadValuesFromForm();
181 $UserOptions->SaveValuesToDatabase($this->System->Modules['User']->User['Id']);
182 $Output .= $this->SystemMessage('Nastavení', 'Nastavení uloženo.');
183 $this->System->Modules['Log']->NewRecord('User', 'Nastavení uživatele změněno', $UserOptions->Values['Name']);
184 $UserOptions->LoadValuesFromDatabase($this->System->Modules['User']->User['Id']);
185 $UserOptions->OnSubmit = '?Action=UserOptionsSave';
186 $Output .= $UserOptions->ShowEditForm();
187 }
188 if($_GET['Action'] == 'UserRegister')
189 {
190 $Form = new Form('UserRegister');
191 $Form->LoadValuesFromForm();
192 $Form->OnSubmit = '?Action=UserRegisterSave';
193 $Output .= $Form->ShowEditForm();
194 } else
195 if($_GET['Action'] == 'UserRegisterConfirm')
196 {
197 $Output .= $this->SystemMessage('Potvrzení registrace',
198 $this->System->Modules['User']->RegisterConfirm($_GET['User'], $_GET['H']));
199 } else
200 if($_GET['Action'] == 'PasswordRecovery')
201 {
202 $Form = new Form('PasswordRecovery');
203 $Form->OnSubmit = '?Action=PasswordRecovery2';
204 $Output .= $Form->ShowEditForm();
205 } else
206 if($_GET['Action'] == 'PasswordRecovery2')
207 {
208 $Form = new Form('PasswordRecovery');
209 $Form->LoadValuesFromForm();
210 $Result = $this->System->Modules['User']->PasswordRecoveryRequest($Form->Values['Name'], $Form->Values['Email']);
211 $Output .= $this->SystemMessage('Obnova hesla', $Result);
212 if($Result <> USER_PASSWORD_RECOVERY_SUCCESS)
213 {
214 $Output .= $Form->ShowEditForm();
215 }
216 } else
217 if($_GET['Action'] == 'PasswordRecoveryConfirm')
218 {
219 $Output .= $this->SystemMessage('Obnova hesla', $this->System->Modules['User']->PasswordRecoveryConfirm($_GET['User'], $_GET['H'], $_GET['P']));
220 } else
221 if($_GET['Action'] == 'UserRegisterSave')
222 {
223 $Form = new Form('UserRegister', array());
224 $Form->LoadValuesFromForm();
225 $Result = $this->System->Modules['User']->Register($Form->Values['Login'], $Form->Values['Password'], $Form->Values['Password2'], $Form->Values['Email'], $Form->Values['Name'], $Form->Values['PhoneNumber'], $Form->Values['ICQ']);
226 $Output .= $this->SystemMessage('Registrace nového účtu', $Result);
227 if($Result <> USER_REGISTRATED)
228 {
229 $Form->OnSubmit = '?Action=UserRegisterSave';
230 $Output .= $Form->ShowEditForm();
231 }
232 } else
233 if($_GET['Action'] == 'MemberOptions')
234 {
235 $UserOptions = new Form('MemberOptions');
236 $DbResult = $this->Database->query('SELECT Customer FROM UserCustomerRel WHERE User='.$this->System->Modules['User']->User['Id']);
237 if($DbResult->num_rows > 0)
238 {
239 $CustomerUserRel = $DbResult->fetch_assoc();
240 $DbResult = $this->Database->query('SELECT Member.Id, Member.InternetTariffNextMonth, '.
241 'Member.FamilyMemberCount, Member.BillingPeriodNext, Subject.Name, Subject.AddressStreet, '.
242 'Subject.AddressTown, Subject.AddressPSC, Subject.IC, Subject.DIC FROM Member JOIN Subject '.
243 'ON Subject.Id = Member.Subject WHERE Member.Id='.$CustomerUserRel['Customer']);
244 $DbRow = $DbResult->fetch_array();
245 foreach($UserOptions->Definition['Items'] as $Index => $Item)
246 {
247 $UserOptions->Values[$Index] = $DbRow[$Index];
248 }
249 $UserOptions->OnSubmit = '?Action=MemberOptionsSave';
250 $Output .= $UserOptions->ShowEditForm();
251 } else $Output .= $this->SystemMessage('Chyba', 'Nejste zákazníkem');
252 } else
253 if($_GET['Action'] == 'MemberOptionsSave')
254 {
255 $UserOptions = new Form('MemberOptions');
256 $UserOptions->LoadValuesFromForm();
257 if($UserOptions->Values['FamilyMemberCount'] < 0)
258 $UserOptions->Values['FamilyMemberCount'] = 0;
259 if($UserOptions->Values['BillingPeriodNext'] < 2)
260 $UserOptions->Values['BillingPeriodNext'] = 2;
261
262 $DbResult = $this->Database->update('Member', 'Id='.$this->System->Modules['User']->User['Member'], array('InternetTariffNextMonth' => $UserOptions->Values['InternetTariffNextMonth'], 'FamilyMemberCount' => $UserOptions->Values['FamilyMemberCount'], 'BillingPeriodNext' => $UserOptions->Values['BillingPeriodNext']));
263 $DbResult = $this->Database->query('SELECT Subject FROM Member WHERE Id='.$this->System->Modules['User']->User['Member']);
264 $Member = $DbResult->fetch_assoc();
265 $DbResult = $this->Database->update('Subject', 'Id='.$Member['Subject'], array('Name' => $UserOptions->Values['Name'], 'AddressStreet' => $UserOptions->Values['AddressStreet'], 'AddressTown' => $UserOptions->Values['AddressTown'], 'AddressPSC' => $UserOptions->Values['AddressPSC'], 'IC' => $UserOptions->Values['IC'], 'DIC' => $UserOptions->Values['DIC']));
266 $Output .= $this->SystemMessage('Nastavení', 'Nastavení domácnosti uloženo.');
267 $this->System->Modules['Log']->NewRecord('Member+Subject', 'Nastavení člena/subjektu změněno', $UserOptions->Values['Name']);
268 $DbResult = $this->Database->query('SELECT Member.Id, Member.InternetTariffNextMonth, Member.FamilyMemberCount, Member.BillingPeriodNext, Subject.Name, Subject.AddressStreet, Subject.AddressTown, Subject.AddressPSC, Subject.IC, Subject.DIC FROM Member JOIN Subject ON Subject.Id = Member.Subject WHERE Member.Id='.$this->System->Modules['User']->User['Member']);
269 $DbRow = $DbResult->fetch_array();
270 foreach($UserOptions->Definition['Items'] as $Index => $Item)
271 {
272 $UserOptions->Values[$Index] = $DbRow[$Index];
273 }
274 $UserOptions->OnSubmit = '?Action=MemberOptionsSave';
275 $Output .= $UserOptions->ShowEditForm();
276 }
277 }
278
279 $Database->select_db($Config['Database']['Database']);
280
281 $DbResult = $Database->query('SELECT * FROM `HyperlinkGroup`');
282 while($DbRow = $DbResult->fetch_assoc())
283 $HyperlinkGroups[$DbRow['Id']] = $DbRow;
284
285 // Show pannels
286 //if(IsInternetAddr()) echo('Internet'); else echo('LAN');
287 //$Output .= $this->InfoBar();
288 $Output .= '<table id="MainTable"><tr>';
289 $DbResult = $Database->select('PanelColumn', '*');
290 while($PanelColumn = $DbResult->fetch_assoc())
291 {
292 if($PanelColumn != '') $Width = ' width="'.$PanelColumn['Width'].'"';
293 else $Width = '';
294 $Output .= '<td valign="top"'.$Width.'>';
295 $DbResult2 = $Database->query('SELECT * FROM `Panel` WHERE `PanelColumn`='.$PanelColumn['Id'].' ORDER BY `Order`');
296 while($Panel = $DbResult2->fetch_assoc())
297 {
298 if($Panel['Module'] == 'HyperlinkGroup') $Output .= $this->ShowLinks($HyperlinkGroups[$Panel['Parameters']]);
299 else if($Panel['Module'] == 'OnlineHostList') $Output .= $this->Panel('Online počítače', $this->OnlineHostList());
300 else if($Panel['Module'] == 'UserOptions')
301 {
302 if($this->System->Modules['User']->User['Id'] != $this->System->Modules['User']->AnonymousUserId) $Output .= $this->Panel('Přihlášený uživatel', $this->UserPanel());
303 } else
304 if($Panel['Module'] == 'Webcam') $Output .= $this->Panel('Kamery', $this->WebcamPanel());
305 else if($Panel['Module'] == 'NewsGroupList') $Output .= $this->Panel('Aktuality', $this->System->Modules['News']->Show(), array('<a href="?Action=CustomizeNews">Upravit</a>'));
306 }
307 $Output .= '</td>';
308 }
309 $Output .= '</tr></table>';
310 return($Output);
311 }
312}
313
314$System->AddModule(new IndexPage());
315$System->Modules['IndexPage']->GetOutput();
316
317?>
Note: See TracBrowser for help on using the repository browser.