source: www/finance/zivnost.php@ 133

Last change on this file since 133 was 70, checked in by george, 17 years ago

Přidáno: Skripty pro podporu vedení daňové evidence.
File size: 21.1 KB
Line 
1<?php
2
3include('../style.php');
4include('include.php');
5include('bills.php');
6RecalculateTariffs(1);
7
8ShowHeader('Daňová evidence', 'Daňová evidence');
9
10function TransformFinance()
11{
12 global $Database;
13 //$Database->Query('SELECT user as Subject, date as TimeCreation, date as TimeDue, date as TimePayment, -money as Value, bill_id as Bill, comment as Text FROM `finance_operations` WHERE Comment LIKE "Poplatek za měsíc%" AND date >= "2007-12-01"');
14 //'TRUNCATE TABLE FinanceCashFlow; INSERT INTO FinanceCashFlow (SELECT '' as Id, user as Subject, comment as Text, date as Time, 1 as Taxable, 0 as Cash, money as Value, bill_id as Bill FROM `finance_operations` WHERE comment NOT LIKE "Poplatek za měsíc%" AND date >= "2007-12-01")'
15 // 'UPDATE finance_operations SET date="2007-11-24" WHERE comment="Jednorázový poplatek za společné zařízení"'
16
17/*
18 $DbResult = $Database->query('SELECT * FROM users WHERE role=2');
19 while($User = $DbResult->fetch_array())
20 {
21 $DbResult2 = $Database->query('SELECT SUM(money) FROM finance_operations WHERE user='.$User['id'].' AND date < "2007-12-01"');
22 $Row = $DbResult2->fetch_array();
23 echo($User['second_name'].' '.$User['first_name'].' '.$Row[0].'<br>');
24// if($Row[0] > 0) $Database->insert('FinanceCashFlow', array('Text' => 'Přijatá záloha (z období před účetnictvím)', 'Subject' => $User['id'], 'Time' => '2007-01-01', 'Taxable' => 1, 'Cash' => 0, 'Value' => $Row[0], 'Bill' => 0));
25
26 if($Row[0] < 0)
27 {
28 $Database->insert('FinanceClaimsLiabilities', array('Text' => 'Připojení k síti (z období před účetnictvím)', 'Subject' => $User['id'], 'TimeCreation' => '2007-12-01', 'TimeDue' => '2007-12-14', 'TimePayment' => '', 'Value' => (-$Row[0]), 'Bill' => 0));
29 //echo($Database->LastQuery.'<br>');
30 }
31 }
32*/
33}
34
35TransformFinance();
36
37if(!array_key_exists('table', $_GET)) $_GET['table'] = '';
38switch($_GET['table'])
39{
40 case 'AnnualBalance':
41 echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
42 echo('<tr><th colspan="3">Účetní období</th><th colspan="5">Na konci</th><th colspan="6">Během</th></tr>');
43 echo('<tr><th>Rok</th><th>Od</th><th>Do</th><th>Příjmy</th><th>Výdaje</th><th>Pohledávky</th><th>Závazky</th><th>Drobný majetek</th><th>Příjmy</th><th>Výdaje</th><th>Pohledávky</th><th>Závazky</th><th>Drobný majetek</th><th>Základ daně</th></tr>');
44
45 $StartEvidence = mktime(0, 0, 0, 12, 1, 2007);
46 $StartYear = date('Y', $StartEvidence);
47 $EndYear = date('Y', time());
48 for($Year = $StartYear; $Year <= $EndYear; $Year++)
49 {
50 $EndTime = mktime(0, 0, 0, 12, 31, $Year);
51 $Year = date('Y', $EndTime);
52 $StartTime = mktime(0, 0, 0, 1, 1, $Year);
53 if($StartTime < $StartEvidence) $StartTime = $StartEvidence;
54
55 $Balance = array();
56
57 $DbResult = $Database->query('SELECT SUM(Value) FROM FinanceCashFlow WHERE Time < "'.TimeToMysqlDateTime($StartTime).'" AND Value > 0 AND Taxable = 1');
58 $Row = $DbResult->fetch_array();
59 $Balance['Income']['Start'] = $Row[0] + 0;
60 $DbResult = $Database->query('SELECT SUM(Value) FROM FinanceCashFlow WHERE Time <= "'.TimeToMysqlDateTime($EndTime).'" AND Value > 0 AND Taxable = 1');
61 //echo('SELECT SUM(Value) FROM FinanceCashFlow WHERE Time <= "'.TimeToMysqlDateTime($EndTime).'" AND Value > 0 AND Taxable = 1'.'<br>');
62 $Row = $DbResult->fetch_array();
63 $Balance['Income']['End'] = $Row[0] + 0;
64
65 $DbResult = $Database->query('SELECT -SUM(Value) FROM FinanceCashFlow WHERE Time < "'.TimeToMysqlDateTime($StartTime).'" AND Value < 0 AND Taxable = 1');
66 $Row = $DbResult->fetch_array();
67 $Balance['Spend']['Start'] = $Row[0] + 0;
68 $DbResult = $Database->query('SELECT -SUM(Value) FROM FinanceCashFlow WHERE Time <= "'.TimeToMysqlDateTime($EndTime).'" AND Value < 0 AND Taxable = 1');
69 //echo('SELECT -SUM(Value) FROM FinanceCashFlow WHERE Time <= "'.TimeToMysqlDateTime($EndTime).'" AND Value < 0 AND Taxable = 1'.'<br>');
70 $Row = $DbResult->fetch_array();
71 $Balance['Spend']['End'] = $Row[0] + 0;
72
73 $DbResult = $Database->query('SELECT SUM(Value) FROM FinanceClaimsLiabilities WHERE TimeCreation < "'.TimeToMysqlDateTime($StartTime).'" AND TimePayment = "0000-00-00 00:00:00" AND Value > 0');
74 $Row = $DbResult->fetch_array();
75 $Balance['Claims']['Start'] = $Row[0] + 0;
76 $DbResult = $Database->query('SELECT SUM(Value) FROM FinanceClaimsLiabilities WHERE TimeCreation <= "'.TimeToMysqlDateTime($EndTime).'" AND TimePayment = "0000-00-00 00:00:00" AND Value > 0');
77 $Row = $DbResult->fetch_array();
78 $Balance['Claims']['End'] = $Row[0] + 0;
79
80 $DbResult = $Database->query('SELECT -SUM(Value) FROM FinanceClaimsLiabilities WHERE TimeCreation < "'.TimeToMysqlDateTime($StartTime).'" AND TimePayment = "0000-00-00 00:00:00" AND Value < 0');
81 $Row = $DbResult->fetch_array();
82 $Balance['Liabilities']['Start'] = $Row[0] + 0;
83 $DbResult = $Database->query('SELECT -SUM(Value) FROM FinanceClaimsLiabilities WHERE TimeCreation <= "'.TimeToMysqlDateTime($EndTime).'" AND TimePayment = "0000-00-00 00:00:00" AND Value < 0');
84 $Row = $DbResult->fetch_array();
85 $Balance['Liabilities']['End'] = $Row[0] + 0;
86
87 // SmallAssets
88 $DbResult = $Database->query('SELECT SUM(price) FROM network_devices WHERE (TimeEnlistment < "'.TimeToMysqlDateTime($StartTime).'") AND (TimeEnlistment != 0) AND ((TimeElimination > "'.TimeToMysqlDateTime($StartTime).'") OR (TimeElimination = 0))');
89 echo($Database->error);
90 $Row = $DbResult->fetch_array();
91 $Balance['SmallAssets']['Start'] = $Row[0] + 0;
92 $DbResult = $Database->query('SELECT SUM(price) FROM network_devices WHERE (TimeEnlistment < "'.TimeToMysqlDateTime($EndTime).'") AND (TimeEnlistment != 0) AND ((TimeElimination > "'.TimeToMysqlDateTime($EndTime).'") OR (TimeElimination = 0))');
93 $Row = $DbResult->fetch_array();
94 $Balance['SmallAssets']['End'] = $Row[0] + 0;
95
96
97 echo('<tr><td>'.$Year.'</td><td>'.date(HumanDate(TimeToMysqlDateTime($StartTime))).'</td><td>'.date(HumanDate(TimeToMysqlDateTime($EndTime))).'</td>');
98 echo('<td>'.$Balance['Income']['End'].'</td>');
99 echo('<td>'.$Balance['Spend']['End'].'</td>');
100 echo('<td>'.$Balance['Claims']['End'].'</td>');
101 echo('<td>'.$Balance['Liabilities']['End'].'</td>');
102 echo('<td>'.$Balance['SmallAssets']['End'].'</td>');
103
104 echo('<td>'.($Balance['Income']['End'] - $Balance['Income']['Start']).'</td>');
105 echo('<td>'.($Balance['Spend']['End'] - $Balance['Spend']['Start']).'</td>');
106 echo('<td>'.($Balance['Claims']['End'] - $Balance['Claims']['Start']).'</td>');
107 echo('<td>'.($Balance['Liabilities']['End'] - $Balance['Liabilities']['Start']).'</td>');
108 echo('<td>'.($Balance['SmallAssets']['End'] - $Balance['SmallAssets']['Start']).'</td>');
109 echo('<td>'.(($Balance['Income']['End'] - $Balance['Income']['Start']) - ($Balance['Spend']['End'] - $Balance['Spend']['Start'])).'</td></tr>');
110 }
111 echo('</table>');
112
113// echo('<tr><td colspan="2">Výkaz o majetku a závazcích</td><td>Ing. Jiří Hajda</td></tr>');
114/*
115 echo('<tr><td>Dlouhodobý hmotný majetek</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
116 echo('<tr><td>Dlouhodobý nehmotný majetek</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
117 echo('<tr><td>Peněžní prostředky v hotovosti</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
118 echo('<tr><td>Peněžní prostředky na bankovních účtech</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
119 echo('<tr><td>Cenné papíry a peněžní vklady</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
120 echo('<tr><td>Zásoby</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
121 echo('<tr><td>Úvěry a půjčky (poskytnuté)</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
122 echo('<tr><td>Aktivní opravná položka</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
123 echo('<tr><th>Závazky</th><th>&nbsp;</th><th>&nbsp;</th></tr>');
124 echo('<tr><td>Závazky (bez úvěrů a půjček)</td><td>'.$Liabilities.'</td><td>&nbsp;</td></tr>');
125 echo('<tr><td>Úvěry a půjčky</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
126 echo('<tr><td>Pasivní opravná položka</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
127 echo('<tr><td>Rezervy</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
128 echo('<tr><td>Závazky celkem</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
129 echo('<tr><th>Rozdíl (jmění)</th><th>&nbsp;</th><th>&nbsp;</th></tr>');
130 echo('<tr><td colspan="3"></td></tr>');
131
132 echo('<tr><td colspan="3">Výkaz příjmů a výdajů</td></tr>');
133 echo('<tr><th>Příjmy</th><th>&nbsp;</th><th>&nbsp;</th></tr>');
134 echo('<tr><td>Prodej zboží</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
135 echo('<tr><td>Prodej výrobků a služeb</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
136 echo('<tr><td>Ostatní</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
137 echo('<tr><td>z toho úroky</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
138 echo('<tr><td>Cenné papíry a peněžní vklady</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
139 echo('<tr><td>Úzávěrková oprava příjmů</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
140 echo('<tr><td>Příjmy celkem</td><td>&nbsp;</td><td>'.$Income.'</td></tr>');
141 echo('<tr><th>Výdaje</th><th>&nbsp;</th><th>&nbsp;</th></tr>');
142 echo('<tr><td>Nákup materiálu</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
143 echo('<tr><td>Nákup zboží</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
144 echo('<tr><td>Mzdy</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
145 echo('<tr><td>Pojistné</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
146 echo('<tr><td>Provozní režie</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
147 echo('<tr><td>Uzávěrková oprava příjmů</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
148 echo('<tr><td>z toho: odpisy dlouhodobého majetku</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
149 echo('<tr><td>z toho: zůstatková cena dlouhodobého majetku</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
150 echo('<tr><td>z toho: poměrná splátka leasingové akontace</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
151 echo('<tr><td>Výdaje celkem</td><td>&nbsp;</td><td>'.$Spend.'</td></tr>');
152 echo('<tr><th>Rozdíl mezi příjmy a výdaji</th><th>&nbsp;</th><th>&nbsp;</th></tr>');
153 echo('</table>');
154*/
155 break;
156 case 'CashFlow':
157 $Table = array('Ne', 'Ano');
158 echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
159 echo('<tr><th>Čas</th><th>Subjekt</th><th>Text</th><th>Hodnota [Kč]</th><th>Daňový</th><th>Hotovost</th></tr>');
160 $DbResult = $Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceCashFlow JOIN users ON users.id = FinanceCashFlow.Subject ORDER BY Time');
161 while($Row = $DbResult->fetch_array())
162 {
163 echo('<tr><td>'.$Row['Time'].'</td><td>'.$Row['Name'].'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Table[$Row['Taxable']].'</td><td>'.$Table[$Row['Cash']].'</td></tr>');
164 }
165 echo('</table>');
166 break;
167 case 'ClaimsLiabilities':
168 echo('<table width="100%"><tr><td valign="top">');
169 echo('<strong>Pohledávky</strong>');
170 echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
171 echo('<tr><th>Subjekt</th><th>Text</th><th>Hodnota [Kč]</th><th>Čas vystavení</th><th>Čas splatnosti</th><th>Čas uhrazení</th></tr>');
172 $DbResult = $Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceClaimsLiabilities JOIN users ON users.id = FinanceClaimsLiabilities.Subject WHERE Value > 0 ORDER BY TimeCreation');
173 while($Row = $DbResult->fetch_array())
174 {
175 if($Row['TimePayment'] == '0000-00-00 00:00:00') $Row['TimePayment'] = '&nbsp;';
176 echo('<tr><td>'.$Row['Name'].'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimeDue'].'</td><td>'.$Row['TimePayment'].'</td></tr>');
177 }
178 echo('</table></td><td valign="top">');
179
180 echo('<strong>Závazky</strong>');
181 echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
182 echo('<tr><th>Subjekt</th><th>Text</th><th>Hodnota [Kč]</th><th>Čas vystavení</th><th>Čas splatnosti</th><th>Čas uhrazení</th></tr>');
183 $DbResult = $Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceClaimsLiabilities JOIN users ON users.id = FinanceClaimsLiabilities.Subject WHERE Value < 0 ORDER BY TimeCreation');
184 while($Row = $DbResult->fetch_array())
185 {
186 if($Row['TimePayment'] == '0000-00-00 00:00:00') $Row['TimePayment'] = '&nbsp;';
187 echo('<tr><td>'.$Row['Name'].'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimeDue'].'</td><td>'.$Row['TimePayment'].'</td></tr>');
188 }
189 echo('</table></td></tr></table>');
190 break;
191 case 'Advantages':
192 echo('<table width="100%"><tr><td valign="top">');
193 echo('Přijaté zálohy');
194 echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
195 echo('<tr><th>Subjekt</th><th>Hodnota [Kč]</th><th>Čas vystavení</th><th>Čas uzavření</th></tr>');
196 $DbResult = $Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceAdvances JOIN users ON users.id = FinanceAdvances.Subject WHERE Direction = "In" ORDER BY TimeCreation');
197 while($Row = $DbResult->fetch_array())
198 {
199 if($Row['TimePass'] == '0000-00-00 00:00:00') $Row['TimePass'] = '&nbsp;';
200 echo('<tr><td>'.$Row['Name'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimePass'].'</td></tr>');
201 }
202 echo('</table></td><td valign="top">');
203
204 echo('Vydané zálohy');
205 echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
206 echo('<tr><th>Subjekt</th><th>Hodnota [Kč]</th><th>Čas vystavení</th><th>Čas uzavření</th></tr>');
207 $DbResult = $Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceAdvances JOIN users ON users.id = FinanceAdvances.Subject WHERE Direction = "Out" ORDER BY TimeCreation');
208 while($Row = $DbResult->fetch_array())
209 {
210 if($Row['TimePass'] == '0000-00-00 00:00:00') $Row['TimePass'] = '&nbsp;';
211 echo('<tr><td>'.$Row['Name'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimePass'].'</td></tr>');
212 }
213 echo('</table></td></tr></table>');
214 break;
215 case 'SubjectList':
216 echo('<strong>Seznam subjektů</strong>');
217 echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
218 echo('<tr><th>Jméno</th><th>Závazky [Kč]</th><th>Pohledávky [Kč]</th><th>Příjmy [Kč]</th><th>Výdaje [Kč]</th><th>Zálohy [Kč]</th><th>Stav účtu</th><th>Starý systém</th></tr>');
219 $DbResult = $Database->query('SELECT id, CONCAT(users.second_name, " ", users.first_name) as Fullname, cash, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value > 0) as Claims, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value > 0 AND TimePayment IS NULL) as OpenedClaims, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value < 0) as Liabilities, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value < 0 AND TimePayment IS NULL) as OpenedLiabilities, (SELECT SUM(FinanceCashFlow.Value) FROM FinanceCashFlow WHERE FinanceCashFlow.Subject = users.id AND FinanceCashFlow.Value > 0) as Gains, (SELECT SUM(FinanceCashFlow.Value) FROM FinanceCashFlow WHERE FinanceCashFlow.Subject = users.id AND FinanceCashFlow.Value < 0) as Spends, (SELECT SUM(FinanceAdvances.Value) FROM FinanceAdvances WHERE FinanceAdvances.Subject = users.id AND FinanceAdvances.Direction="In") as AdvancesIn, (SELECT SUM(FinanceAdvances.Value) FROM FinanceAdvances WHERE FinanceAdvances.Subject = users.id AND FinanceAdvances.Direction="Out") as AdvancesOut FROM users ORDER BY fullname');
220 while($Row = $DbResult->fetch_array())
221 {
222 $Advances = ($Row['AdvancesIn'] - $Row['AdvancesOut']);
223 echo('<tr><td><a href="?table=SubjectAccount&Id='.$Row['id'].'">'.$Row['Fullname'].'</a></td><td>'.$Row['Liabilities'].'/'.$Row['OpenedLiabilities'].'</td><td>'.$Row['Claims'].'/'.$Row['OpenedClaims'].'</td><td>'.$Row['Gains'].'</td><td>'.$Row['Spends'].'</td><td>'.$Advances.'</td><td>'.($Advances - $Row['OpenedClaims'] + Abs($Row['OpenedLiabilities'])).'</td><td>'.$Row['cash'].'</td></tr>');
224 }
225 echo('</table>');
226 break;
227 case 'SmallAssets':
228 echo('<strong>Drobný majetek</strong>');
229 echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
230 echo('<tr><th>Název</th><th>Hodnota [Kč]</th><th>Datum zakoupení</th><th>Datum vyřezení</th></tr>');
231 $DbResult = $Database->query('SELECT * FROM network_devices WHERE used != 0');
232 while($Row = $DbResult->fetch_array())
233 {
234 echo('<tr><td>'.$Row['name'].'</td><td>'.$Row['price'].'</td><td>'.$Row['TimeEnlistment'].'</td><td>'.$Row['TimeElimination'].'</td></tr>');
235 }
236 echo('</table>');
237 break;
238 case 'SubjectAccount':
239 echo('<strong>Výpis příjmů/výdajů</strong>');
240 echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
241 echo('<tr><th>Datum</th><th>Název</th><th>Hodnota [Kč]</th></tr>');
242 $DbResult = $Database->select('FinanceCashFlow', '*', 'Subject='.$_GET['Id']);
243 while($Row = $DbResult->fetch_array())
244 {
245 echo('<tr><td>'.$Row['Time'].'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['Bill'].'</td></tr>');
246 }
247 echo('</table><br>');
248
249 echo('<strong>Výpis závazků/pohledávek</strong>');
250 echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
251 echo('<tr><th>Datum vytvoření</th><th>Datum zaplacení</th><th>Název</th><th>Hodnota [Kč]</th></tr>');
252 $DbResult = $Database->select('FinanceClaimsLiabilities', '*', 'Subject='.$_GET['Id']);
253 while($Row = $DbResult->fetch_array())
254 {
255 echo('<tr><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimePayment'].'</td><td>'.$Row['Text'].'</td><td>'.(-$Row['Value']).'</td><td>'.$Row['Bill'].'</td></tr>');
256 }
257 echo('</table><br>');
258
259 echo('<strong>Výpis záloh</strong>');
260 echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
261 echo('<tr><th>Datum vytvoření</th><th>Datum zaplacení</th><th>Název</th><th>Hodnota [Kč]</th></tr>');
262 $DbResult = $Database->select('FinanceAdvances', '*', 'Subject='.$_GET['Id']);
263 while($Row = $DbResult->fetch_array())
264 {
265 echo('<tr><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimePass'].'</td><td>'.$Row['Direction'].'</td><td>'.($Row['Value']).'</td><td>'.$Row['CashFlowId'].'</td></tr>');
266 }
267 echo('</table>');
268
269 $DbResult = $Database->query('SELECT id, CONCAT(users.second_name, " ", users.first_name) as Fullname, cash, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value > 0) as Claims, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value > 0 AND TimePayment IS NULL) as OpenedClaims, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value < 0) as Liabilities, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value < 0 AND TimePayment IS NULL) as OpenedLiabilities, (SELECT SUM(FinanceCashFlow.Value) FROM FinanceCashFlow WHERE FinanceCashFlow.Subject = users.id AND FinanceCashFlow.Value > 0) as Gains, (SELECT SUM(FinanceCashFlow.Value) FROM FinanceCashFlow WHERE FinanceCashFlow.Subject = users.id AND FinanceCashFlow.Value < 0) as Spends, (SELECT SUM(FinanceAdvances.Value) FROM FinanceAdvances WHERE FinanceAdvances.Subject = users.id AND FinanceAdvances.Direction="In") as AdvancesIn, (SELECT SUM(FinanceAdvances.Value) FROM FinanceAdvances WHERE FinanceAdvances.Subject = users.id AND FinanceAdvances.Direction="Out") as AdvancesOut FROM users WHERE id='.$_GET['Id']);
270 $Row = $DbResult->fetch_array();
271 echo('Stav placení: '.($Row['AdvancesIn'] - $Row['AdvancesOut'] - $Row['OpenedClaims'] + Abs($Row['OpenedLiabilities'])));
272 break;
273 default:
274 echo('<a href="?table=AnnualBalance">Účetní závěrka</a><br>');
275 echo('<a href="?table=CashFlow">Příjmy a výdaje</a><br>');
276 echo('<a href="?table=ClaimsLiabilities">Závazky a pohledávky</a><br>');
277 echo('<a href="?table=Advantages">Zálohy</a><br>');
278 echo('<a href="?table=SmallAssets">Drobný majetek</a><br>');
279 echo('<a href="?table=SubjectList">Seznam subjektů</a><br>');
280}
281
282function AddMoney($Subject, $Value, $Text, $Time)
283{
284 $TimeDue = $Time + 15 * 24 * 3600; // 15 dnů
285
286
287}
288
289function AddInvoice($Subject, $Value, $Text, $Time)
290{
291 $TimeDue = $Time + 15 * 24 * 3600; // 15 dnů
292
293
294}
295
296?>
Note: See TracBrowser for help on using the repository browser.