source: trunk/Modules/Stock/Stock.php@ 874

Last change on this file since 874 was 874, checked in by chronos, 5 years ago
  • Modified: Do not use parenthesis around returned value.
File size: 13.3 KB
Line 
1<?php
2
3class ModuleStock extends AppModule
4{
5 function __construct($System)
6 {
7 parent::__construct($System);
8 $this->Name = 'Stock';
9 $this->Version = '1.0';
10 $this->Creator = 'Chronos';
11 $this->License = 'GNU/GPL';
12 $this->Description = 'Stock and products';
13 $this->Dependencies = array('User', 'Customer', 'Network');
14 }
15
16 function DoStart()
17 {
18 global $Config;
19
20 $this->System->FormManager->RegisterClass('Product', array(
21 'Title' => 'Produkty',
22 'Table' => 'Product',
23 'DefaultSortColumn' => 'Name',
24 'Items' => array(
25 'Manufacturer' => array('Type' => 'TSubject', 'Caption' => 'Výrobce', 'Default' => '', 'Null' => true),
26 'Code' => array('Type' => 'String', 'Caption' => 'Kód', 'Default' => ''),
27 'Name' => array('Type' => 'String', 'Caption' => 'Jméno', 'Default' => ''),
28 'SellPrice' => array('Type' => 'Integer', 'Caption' => 'Prodejní cena', 'Default' => '0', 'Suffix' => 'Kč'),
29 'BuyPrice' => array('Type' => 'Integer', 'Caption' => 'Kupní cena', 'Default' => '0', 'Suffix' => 'Kč'),
30 'VAT' => array('Type' => 'Integer', 'Caption' => 'DPH', 'Default' => '0', 'Suffix' => '%'),
31 'Consumption' => array('Type' => 'Integer', 'Caption' => 'Spotřeba', 'Default' => '', 'Suffix' => 'Watt'),
32 'Supplier' => array('Type' => 'TSubject', 'Caption' => 'Dodavatel', 'Default' => '', 'Null' => true),
33 'UnitOfMeasure' => array('Type' => 'TUnitOfMeasure', 'Caption' => 'Měrná jednotka', 'Default' => '', 'Null' => true),
34 'StockSerialNumbers' => array('Type' => 'TStockSerialNumberListProduct', 'Caption' => 'Položky na skladě', 'Default' => ''),
35 'StockState' => array('Type' => 'Integer', 'Caption' => 'Počet na skladě', 'Default' => '', 'ReadOnly' => true,
36 'SQL' => 'SELECT IFNULL(SUM(`Amount`), 0) FROM `StockMoveItem` WHERE `StockMoveItem`.`Product`=#Id'),
37 'StockMinCount' => array('Type' => 'Integer', 'Caption' => 'Skladové minimum', 'Default' => '0'),
38 'StockMoves' => array('Type' => 'TStockMoveItemListProduct', 'Caption' => 'Pohyby na skladě', 'Default' => ''),
39 'NetworkDevices' => array('Type' => 'TNetworkDeviceListProduct', 'Caption' => 'Síťová zařízení', 'Default' => ''),
40 'StockShortage' => array('Type' => 'TStockState', 'Caption' => 'Stav skladu', 'Default' => '', 'ReadOnly' => true,
41 'SQL' => 'SELECT (IFNULL(SUM(`Amount`), 0) >= `StockMinCount`) FROM `StockMoveItem` WHERE `StockMoveItem`.`Product`=#Id'),
42 ),
43 ));
44
45 $this->System->FormManager->RegisterClass('StockSerialNumber', array(
46 'Title' => 'Skladové položky',
47 'Table' => 'StockSerialNumber',
48 'DefaultSortColumn' => 'Id',
49 'Items' => array(
50 'Stock' => array('Type' => 'TStock', 'Caption' => 'Sklad', 'Default' => ''),
51 'Product' => array('Type' => 'TProduct', 'Caption' => 'Produkt', 'Default' => ''),
52 'TimeEnlistment' => array('Type' => 'Date', 'Caption' => 'Datum zařazení', 'Default' => ''),
53 'TimeElimination' => array('Type' => 'Date', 'Caption' => 'Datum vyřazení', 'Default' => '', 'Null' => true),
54 'SellPrice' => array('Type' => 'Integer', 'Caption' => 'Prodejní cena', 'Default' => '0', 'Suffix' => 'Kč'),
55 'BuyPrice' => array('Type' => 'Integer', 'Caption' => 'Kupní cena', 'Default' => '0', 'Suffix' => 'Kč'),
56 'Amount' => array('Type' => 'Integer', 'Caption' => 'Množství', 'Default' => '1'),
57 'SerialNumber' => array('Type' => 'String', 'Caption' => 'Sériové číslo', 'Default' => '', 'Null' => true),
58 'RegNumber' => array('Type' => 'String', 'Caption' => 'Evidenční číslo', 'Default' => '', 'Null' => true),
59 'Location' => array('Type' => 'TMember', 'Caption' => 'Umístění', 'Default' => '', 'Null' => true),
60 'Esemble' => array('Type' => 'TStockSerialNumber', 'Caption' => 'Celek', 'Default' => ''),
61 'Parts' => array('Type' => 'TStockSerialNumberListStockSerialNumber', 'Caption' => 'Části', 'Default' => ''),
62 'History' => array('Type' => 'TStockItemHistoryListStockSerialNumber', 'Caption' => 'Historie', 'Default' => ''),
63 'Sériové čísla' => array('Type' => 'TStockMoveItemSerialListSerial', 'Caption' => 'Skladové pohyby', 'Default' => ''),
64 ),
65 ));
66 $this->System->FormManager->RegisterClass('Stock', array(
67 'Title' => 'Sklady',
68 'Table' => 'Stock',
69 'DefaultSortColumn' => 'Name',
70 'Items' => array(
71 'Name' => array('Type' => 'String', 'Caption' => 'Jméno', 'Default' => ''),
72 'Location' => array('Type' => 'TMember', 'Caption' => 'Umístění', 'Default' => '', 'Null' => true),
73 'Items' => array('Type' => 'TStockSerialNumberListStock', 'Caption' => 'Položky', 'Default' => ''),
74 'ItemsCount' => array('Type' => 'Integer', 'Caption' => 'Položek', 'Default' => '',
75 'ReadOnly' => true, 'SQL' => '(SELECT COUNT(*) FROM `StockSerialNumber` WHERE '.
76 '(`StockSerialNumber`.`Stock`=#Id) AND (`StockSerialNumber`.`TimeElimination` IS NULL))'),
77 'TotalPrice' => array('Type' => 'Integer', 'Caption' => 'Celková cena', 'Default' => '',
78 'ReadOnly' => true, 'SQL' => '(SELECT SUM(`SellPrice`) FROM `StockSerialNumber` WHERE '.
79 '(`StockSerialNumber`.`Stock`=#Id) AND (`StockSerialNumber`.`TimeElimination` IS NULL))', 'Suffix' => 'Kč'),
80 'Moves' => array('Type' => 'TStockMoveStock', 'Caption' => 'Pohyby', 'Default' => ''),
81 ),
82 ));
83 $this->System->FormManager->RegisterClass('StockMove', array(
84 'Title' => 'Skladový pohyb',
85 'Table' => 'StockMove',
86 'DefaultSortColumn' => 'Time',
87 'Items' => array(
88 'Group' => array('Type' => 'TStockMoveGroup', 'Caption' => 'Skupina', 'Default' => ''),
89 'BillCode' => array('Type' => 'TDocumentLineCode', 'Caption' => 'Označení', 'Default' => '', 'ReadOnly' => true),
90 'Time' => array('Type' => 'DateTime', 'Caption' => 'Čas', 'Default' => ''),
91 'Stock' => array('Type' => 'TStock', 'Caption' => 'Sklad', 'Default' => '', 'Null' => true),
92 'File' => array('Type' => 'TFile', 'Caption' => 'Doklad', 'Default' => '', 'Null' => true),
93 'Price' => array('Type' => 'Float', 'Caption' => 'Cena', 'Default' => '',
94 'ReadOnly' => true, 'Suffix' => 'Kč', 'SQL' => '(SELECT SUM(`StockMoveItem`.`UnitPrice` * `StockMoveItem`.`Amount`) FROM `StockMoveItem` '.
95 'WHERE `StockMoveItem`.`StockMove`=#Id)'),
96 'Items' => array('Type' => 'TStockMoveItemListStockMove', 'Caption' => 'Položky', 'Default' => ''),
97 ),
98 'BeforeInsert' => array($this, 'BeforeInsertStockMove'),
99 //'AfterInsert' => array($this, 'AfterInsertStockMove'),
100 //'BeforeModify' => array($this, 'BeforeModifyStockMove'),
101 ));
102 $this->System->FormManager->RegisterClass('StockMoveItem', array(
103 'Title' => 'Položka skladového pohybu',
104 'Table' => 'StockMoveItem',
105 'DefaultSortColumn' => 'Product',
106 'Items' => array(
107 'StockMove' => array('Type' => 'TStockMove', 'Caption' => 'Skladový pohyb', 'Default' => ''),
108 'Product' => array('Type' => 'TProduct', 'Caption' => 'Produkt', 'Default' => ''),
109 'UnitPrice' => array('Type' => 'Integer', 'Caption' => 'Jednotková cena', 'Default' => '0', 'Suffix' => 'Kč'),
110 'Amount' => array('Type' => 'Integer', 'Caption' => 'Množství', 'Default' => '1'),
111 'Total' => array('Type' => 'Integer', 'Caption' => 'Celkem', 'Default' => '', 'Suffix' => 'Kč',
112 'ReadOnly' => true, 'SQL' => 'ROUND(`UnitPrice` * `Amount`, '.$Config['Finance']['Rounding'].')'),
113 'Položky pohybů' => array('Type' => 'TStockMoveItemSerialListItem', 'Caption' => 'Vztahy sériových čísel', 'Default' => ''),
114 'Sériové čísla' => array('Type' => 'String', 'Caption' => 'Sériové čísla', 'ReadOnly' => true,
115 'SQL' => 'SELECT GROUP_CONCAT(`StockSerialNumber`.`RegNumber` SEPARATOR ", ") FROM `StockMoveItemSerialRel` '.
116 'LEFT JOIN `StockSerialNumber` ON `StockSerialNumber`.`Id`=`StockMoveItemSerialRel`.`StockSerialNumber` '.
117 'WHERE `StockMoveItemSerialRel`.`StockMoveItem`=#Id'),
118 ),
119 ));
120 $this->System->FormManager->RegisterClass('StockMoveGroup', array(
121 'Title' => 'Skupina skladových pohybů',
122 'Table' => 'StockMoveGroup',
123 'Items' => array(
124 'Name' => array('Type' => 'String', 'Caption' => 'Název', 'Default' => '0'),
125 'DocumentLine' => array('Type' => 'TDocumentLine', 'Caption' => 'Dokladová řada', 'Default' => '0'),
126 'ValueSign' => array('Type' => 'TFinanceValueSign', 'Caption' => 'Znaménko hodnoty', 'Default' => '0'),
127 'Direction' => array('Type' => 'TFinanceDirection', 'Caption' => 'Směr', 'Default' => '0'),
128 'Items' => array('Type' => 'TStockMoveListGroup', 'Caption' => 'Operace', 'Default' => ''),
129 ),
130 ));
131 $this->System->FormManager->RegisterClass('StockItemHistory', array(
132 'Title' => 'Historie skladové položky',
133 'Table' => 'StockItemHistory',
134 'DefaultSortColumn' => 'Time',
135 'Items' => array(
136 'Time' => array('Type' => 'DateTime', 'Caption' => 'Čas', 'Default' => ''),
137 'StockSerialNumber' => array('Type' => 'TStockSerialNumber', 'Caption' => 'Sériové číslo', 'Default' => ''),
138 'Text' => array('Type' => 'Text', 'Caption' => 'Text', 'Default' => ''),
139 ),
140 ));
141 $this->System->FormManager->RegisterClass('StockMoveItemSerialRel', array(
142 'Title' => 'Vztah položky skladových pohybů a sériových čísel',
143 'Table' => 'StockMoveItemSerialRel',
144 'Items' => array(
145 'StockMoveItem' => array('Type' => 'TStockMoveItem', 'Caption' => 'Položky pohybu', 'Default' => ''),
146 'StockSerialNumber' => array('Type' => 'TStockSerialNumber', 'Caption' => 'Sériové číslo', 'Default' => ''),
147 ),
148 ));
149 $this->System->FormManager->RegisterFormType('TStockMoveItemListStockMove', array(
150 'Type' => 'ManyToOne',
151 'Table' => 'StockMoveItem',
152 'Id' => 'Id',
153 'Ref' => 'StockMove',
154 'Filter' => '1',
155 ));
156 $this->System->FormManager->RegisterFormType('TStockMoveItemListProduct', array(
157 'Type' => 'ManyToOne',
158 'Table' => 'StockMoveItem',
159 'Id' => 'Id',
160 'Ref' => 'Product',
161 'Filter' => '1',
162 ));
163 $this->System->FormManager->RegisterFormType('TStockMoveListGroup', array(
164 'Type' => 'ManyToOne',
165 'Table' => 'StockMove',
166 'Id' => 'Id',
167 'Ref' => 'Group',
168 'Filter' => '1',
169 ));
170 $this->System->FormManager->RegisterFormType('TStockMoveStock', array(
171 'Type' => 'ManyToOne',
172 'Table' => 'StockMove',
173 'Id' => 'Id',
174 'Ref' => 'Stock',
175 'Filter' => '1',
176 ));
177 $this->System->FormManager->RegisterFormType('TStockMoveItemSerialListItem', array(
178 'Type' => 'ManyToOne',
179 'Table' => 'StockMoveItemSerialRel',
180 'Id' => 'Id',
181 'Ref' => 'StockMoveItem',
182 'Filter' => '1',
183 ));
184 $this->System->FormManager->RegisterFormType('TStockMoveItemSerialListSerial', array(
185 'Type' => 'ManyToOne',
186 'Table' => 'StockMoveItemSerialRel',
187 'Id' => 'Id',
188 'Ref' => 'StockSerialNumber',
189 'Filter' => '1',
190 ));
191 $this->System->FormManager->RegisterFormType('TStockMove', array(
192 'Type' => 'Reference',
193 'Table' => 'StockMove',
194 'Id' => 'Id',
195 'Name' => '(SELECT `DocumentLineCode`.`Name` FROM `DocumentLineCode` WHERE `Id`=`StockMove`.`BillCode`)',
196 'Filter' => '1',
197 ));
198 $this->System->FormManager->RegisterFormType('TStockMoveItem', array(
199 'Type' => 'Reference',
200 'Table' => 'StockMoveItem',
201 'Id' => 'Id',
202 'Name' => '(SELECT `Name` FROM `Product` WHERE `Product`.`Id`=`StockMoveItem`.`Product`)',
203 'Filter' => '1',
204 ));
205 $this->System->FormManager->RegisterFormType('TProduct', array(
206 'Type' => 'Reference',
207 'Table' => 'Product',
208 'Id' => 'Id',
209 'Name' => 'Name',
210 'Filter' => '1',
211 ));
212 $this->System->FormManager->RegisterFormType('TStock', array(
213 'Type' => 'Reference',
214 'Table' => 'Stock',
215 'Id' => 'Id',
216 'Name' => 'Name',
217 'Filter' => '1',
218 ));
219 $this->System->FormManager->RegisterFormType('TStockMoveGroup', array(
220 'Type' => 'Reference',
221 'Table' => 'StockMoveGroup',
222 'Id' => 'Id',
223 'Name' => 'Name',
224 'Filter' => '1',
225 ));
226 $this->System->FormManager->RegisterFormType('TStockSerialNumber', array(
227 'Type' => 'Reference',
228 'Table' => 'StockSerialNumber',
229 'Id' => 'Id',
230 'Name' => 'RegNumber',
231 'Filter' => '1',
232 ));
233 $this->System->FormManager->RegisterFormType('TStockItemHistoryListStockSerialNumber', array(
234 'Type' => 'ManyToOne',
235 'Table' => 'StockItemHistory',
236 'Id' => 'Id',
237 'Ref' => 'StockSerialNumber',
238 'Filter' => '1',
239 ));
240
241 $this->System->FormManager->RegisterFormType('TStockState', array(
242 'Type' => 'Enumeration',
243 'States' => array('<span style="color:red;">Nedostatek</span>',
244 '<span style="color:green;">Dostatek</span>'),
245 ));
246 }
247
248 function BeforeInsertStockMove($Form)
249 {
250 if (array_key_exists('Time', $Form->Values)) $Year = date("Y", $Form->Values['Time']);
251 else $Year = date("Y", $Form->Values['ValidFrom']);
252 $Group = $this->System->Modules['Finance']->GetFinanceGroupById($Form->Values['Group'], 'StockMoveGroup');
253 $Form->Values['BillCode'] = $this->System->Modules['Finance']->GetNextDocumentLineNumberId($Group['DocumentLine'], $Year);
254 return $Form->Values;
255 }
256}
Note: See TracBrowser for help on using the repository browser.