GIT.Harvie.CZ / mirrors / SokoMan.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
Zakladni framework pro preklady (+ cesky preklad)
[mirrors/SokoMan.git] / index.php
CommitLineData
cdfce7c2
TM		 1<?php
2/*
3 * SkladovySystem - Storage management system compatible with LMS
78bf26a5 4 * Copyright (C) 2011 Tomas Mudrunka
cdfce7c2
TM		 5 *
6 * This program is free software: you can redistribute it and/or modify
7 * it under the terms of the GNU Affero General Public License as
8 * published by the Free Software Foundation, either version 3 of the
9 * License, or (at your option) any later version.
10 *
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU Affero General Public License for more details.
15 *
16 * You should have received a copy of the GNU Affero General Public License
17 * along with this program. If not, see <http://www.gnu.org/licenses/>.
18 */
19
20require_once('sklad.conf.php');
5f093236
TM		 21set_include_path(DIR_LIB.PATH_SEPARATOR.get_include_path());
22
cdfce7c2
TM		 23require_once('Sklad_LMS-fake.class.php');
24require_once('HTTP_Auth.class.php');
326a9fc9 25require_once('Locale.class.php');
cdfce7c2 26
0a027cc7
TM		 27/**
28* Trida poskytuje vseobecne funkce pro generovani HTML kodu
29*
30* Tato trida by nemela sama nic vypisovat (vyjma chybovych a debugovacich hlasek)!
31*
32* @package HTML
33* @author Tomas Mudrunka
34*/
35class HTML {
36 function row($row) {
37 $html='<tr>';
38 foreach($row as $var) {
39 if(trim($var) == '') $var = '&nbsp;';
40 $html.="<td>$var</td>";
41 }
42 $html.='</tr>';
43 return $html;
44 }
45
46 function table(&$table, $params='border=1') {
47 $html="<table $params>";
48 $header=true;
49 foreach($table as $row) {
50 if($header) {
51 $html.=$this->row(array_keys($row));
52 $header=false;
53 }
54 $html.=$this->row($row);
55 }
56 $html.='</table>';
57 return $html;
58 }
59
60 function link($title='n/a', $link='#void', $internal=true) {
61 if($internal) $link = $this->internal_url($link);
326a9fc9 62 return "<a href='$link'>".T($title)."</a>";
0a027cc7
TM		 63 }
64
65 function img($src='#void', $title='img') {
66 return "<img src='$src' alt='$title' title='$title' width=64 />";
67 }
68
69 function input($name=false, $value=false, $type='text', $placeholder=false, $options=false) {
70 $html = "<input type='$type' ";
71 if($name) $html.= "name='$name' ";
326a9fc9
TM		 72 if(!is_bool($value)) {
73 if($type == 'submit') $value = T($value);
74 $html.= "value='$value' ";
75 }
0a027cc7
TM		 76 if($options) $html.= "$options ";
77 if($placeholder) $html.= "placeholder='$placeholder' ";
78 $html .= '/>';
79 return $html;
80 }
81
82 function select($name, $selectbox, $default=false) {
83 //echo('<pre>'); print_r($selectbox);
84 $html = "<select name='$name'>";
85
86 if($default) {
87 $value=$default; $title=$selectbox[$value];
88 $html .= "<option value='$value'>$value :: $title</option>";
89 unset($selectbox[$value]);
90 }
91 foreach($selectbox as $value => $title) {
92 $html .= "<option value='$value'>$value :: $title</option>";
93 }
94 $html .= "</select>";
95 return $html;
96 }
97}
98
78bf26a5
TM		 99/**
100* Trida poskytuje podpurne funkce pro generovani HTML kodu specificke pro sklad
101*
fc5c5b8b
TM		 102* Tato trida by nemela sama nic vypisovat (vyjma chybovych a debugovacich hlasek)!
103*
78bf26a5
TM		 104* @package Sklad_HTML
105* @author Tomas Mudrunka
106*/
0a027cc7 107class Sklad_HTML extends HTML {
fc5c5b8b 108 function header($title='') {
cdfce7c2
TM		 109 $home = URL_HOME;
110 $script = $_SERVER['SCRIPT_NAME'];
d9384cb5 111 $search = htmlspecialchars(@trim($_GET['q']));
64f31c54 112 $message = strip_tags(@trim($_GET['message']),'<a><b><u><i>');
fc5c5b8b 113 return <<<EOF
10562613 114<head>
115 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
116</head>
cdfce7c2 117<h1><a href="$script/">SystémSklad</a><small>$title</small></h1>
c9759229
TM		 118
119<style type="text/css">
7bcd6b42 120.menu li {
c9759229 121 float: left;
7bcd6b42
TM		 122 padding: 0.2em;
123}
124
125.menu * li {
126 float: none;
c9759229
TM		 127}
128
129.menu * menu {
130 position: absolute;
7bcd6b42 131 padding: 0.2em;
c9759229
TM		 132}
133
134.menu, .menu * menu {
135 list-style: none;
136}
137
138.menu * menu {
7bcd6b42 139 border: 1px solid orange;
c9759229
TM		 140 display: none;
141 margin: 0;
142}
143
7bcd6b42 144.menu li:hover menu, .menu li:hover {
c9759229 145 display: block;
7bcd6b42 146 background-color: yellow;
c9759229 147}
7bcd6b42 148
c9759229
TM		 149</style>
150
cdfce7c2 151<div>
c9759229 152 <menu class="menu">
cdfce7c2
TM		 153 <li><a href="?logout">Logout</a></li>
154 <li><a href="$script/">Home</a></li>
7bcd6b42 155 <li><a href="#">Assistants</a>
c9759229 156 <menu>
fff6ce40 157 <li><a href="$script/assistant/stats">stats</a></li>
b4dcae05 158 <li><a href="$script/assistant/store">store</a></li>
bda4a4be 159 <li><a href="$script/assistant/store-single">store-single</a></li>
ec28d06c
TM		 160 <li><a href="$script/assistant/dispose">dispose</a></li>
161 <li><a href="$script/assistant/sell">sell</a></li>
7bcd6b42 162 <li>&darr;&darr; BETA &darr;&darr;</li>
c9759229
TM		 163 </menu>
164 </li>
165 <li><a href="#">List</a>
166 <menu>
167 <li><a href="$script/item">item</a></li>
168 <li><a href="$script/model">model</a></li>
169 <li><a href="$script/category">category</a></li>
170 <li><a href="$script/producer">producer</a></li>
171 <li><a href="$script/vendor">vendor</a></li>
172 <li><a href="$script/room">room</a></li>
173 <li><a href="$script/status">status</a></li>
174 </menu>
175 </li>
176 <li><a href="#">New</a>
177 <menu>
178 <li><a href="$script/item/new">item</a></li>
179 <li><a href="$script/model/new">model</a></li>
180 <li><a href="$script/category/new">category</a></li>
181 <li><a href="$script/producer/new">producer</a></li>
182 <li><a href="$script/vendor/new">vendor</a></li>
183 <li><a href="$script/room/new">room</a></li>
184 <li><a href="$script/status/new">status</a></li>
185 </menu>
186 </li>
cdfce7c2 187 </menu>
c9759229
TM		 188
189 <div style="float: right;">
8acef003
TM		 190 <form action="$script/assistant/go" method="GET" style="float: left;"><!-- TODO: Display only when go plugin available -->
191 <input type="text" name="q" placeholder="smart id..." />
192 <input type="submit" value="go" />
193 </form>
194 <form action="?" method="GET" style="float: left;">
c9759229
TM		 195 <input type="text" name="q" placeholder="regexp..." value="$search" />
196 <input type="submit" value="filter" />
197 </form>
198 <!-- form action="$script/" method="GET">
199 <input type="text" name="q" placeholder="regexp..." value="$search" />
200 <input type="submit" value="search items" />
201 </form -->
202 </div>
cdfce7c2 203</div>
c9759229 204<hr style="clear: both;" />
d9384cb5
TM		 205<div style="background-color:#FFDDDD;">
206 <font color="red">$message</font>
207</div>
cdfce7c2
TM		 208EOF;
209 }
210
d9384cb5
TM		 211 function internal_url($link) {
212 return $_SERVER['SCRIPT_NAME'].'/'.$link;
213 }
214
cdfce7c2
TM		 215 function table_add_images(&$table) {
216 $image = array('model_id');
217 foreach($table as $id => $row) {
218 foreach($image as $column) if(isset($table[$id][$column])) {
219 $type = @array_shift(preg_split('/_/', $column));
220 $src=URL_IMAGES."/$type/".$table[$id][$column].'.jpg';
221 $table[$id][$type.'_image']=$this->img($src, $table[$id][$column]);
222 }
223 }
224 }
225
226 function table_collapse(&$table) {
227 $collapse = array(
228 'item_id' => 'item_id',
229 'model_id' => 'model_name',
230 'category_id' => 'category_name',
231 'producer_id' => 'producer_name',
232 'vendor_id' => 'vendor_name',
233 'room_id' => 'room_name',
234 'status_id' => 'status_name',
235 );
236 foreach($table as $id => $row) {
237 foreach($collapse as $link => $title)
fff6ce40 238 if(isset($table[$id][$link]) && isset($row[$title])) {
cdfce7c2
TM		 239 $type = @array_shift(preg_split('/_/', $link));
240 if($link != $title) unset($table[$id][$link]);
241 $table[$id][$title]=$this->link($row[$title], $type.'/'.$row[$link].'/');
242 }
243 }
244 }
245
246 function table_sort(&$table) {
247 $precedence = array('item_id', 'model_image', 'model_name','model_descript','category_name','status_name','room_name');
248 $table_sorted = array();
249 foreach($table as $id => $row) {
250 $table_sorted[$id] = array();
251 foreach($precedence as $column) if(isset($table[$id][$column])) {
326a9fc9 252 $table_sorted[$id][T($column)]=$table[$id][$column];
cdfce7c2
TM		 253 unset($table[$id][$column]);
254 }
326a9fc9
TM		 255 //$table_sorted[$id]=array_merge($table_sorted[$id],$table[$id]);
256 foreach($table[$id] as $key => $val) $table_sorted[$id][T($key)] = $val; //array_merge with T() translating
cdfce7c2
TM		 257 }
258 $table = $table_sorted;
259 }
260
fc5c5b8b 261 function render_item_table($table) {
cdfce7c2
TM		 262 $this->table_add_images($table);
263 $this->table_collapse($table);
264 $this->table_sort($table);
fc5c5b8b 265 return $this->table($table);
cdfce7c2
TM		 266 }
267
16261142 268 function render_insert_form($class, $columns, $selectbox=array(), $current=false, $hidecols=false, $action=false, $multi_insert=true) {
cdfce7c2
TM		 269 //echo('<pre>'); print_r($selectbox);
270 //echo('<pre>'); print_r($current);
271 $update = false;
272 if(is_array($current)) {
273 $update = true;
274 $current = array_shift($current);
275 }
276
a084118b
TM		 277 if(!is_array($hidecols)) $hidecols = array('item_author', 'item_valid_from', 'item_valid_till'); //TODO Autodetect
278
16261142
TM		 279 $action = $action ? " action='$action'" : false;
280 $html="<form$action method='POST'>";
fc5c5b8b 281 if($multi_insert) $html.='<div name="input_set" style="float:left; border:1px solid grey;">';
371a86f4 282 //$html.=$this->input('table', $class, 'hidden');
cdfce7c2 283 foreach($columns as $column) {
326a9fc9 284 $html.=T($class).':<b>'.T($column['Field']).'</b>: ';
7d20381f 285 $name="values[$class][".$column['Field'].'][]';
16261142 286 $val = $update && isset($current[$column['Field']]) ? $current[$column['Field']] : false;
cdfce7c2 287 switch(true) {
a084118b 288 case (preg_match('/auto_increment/', $column['Extra']) || in_array($column['Field'], $hidecols)):
e9cb8cea 289 if(!$val) $val = '';
fc5c5b8b
TM		 290 $html.=$this->input($name, $val, 'hidden');
291 $html.=$val.'(AUTO)';
cdfce7c2
TM		 292 break;
293 case isset($selectbox[$column['Field']]):
e9cb8cea 294 $html.=$this->select($name,$selectbox[$column['Field']],$val);
cdfce7c2
TM		 295 break;
296 default:
fc5c5b8b 297 $html.=$this->input($name, $val);
cdfce7c2
TM		 298 break;
299 }
fc5c5b8b 300 $html.='<br />';
cdfce7c2
TM		 301 }
302
303 if($multi_insert) {
304 //TODO, move to separate JS file
fc5c5b8b 305 $html.=<<<EOF
cdfce7c2
TM		 306 </div>
307 <span name="input_set_next"></span><br style="clear:both" />
308 <script>
309 function duplicate_element(what, where) {
310 document.getElementsByName(where)[0].outerHTML =
311 document.getElementsByName(what)[0].outerHTML
312 + document.getElementsByName(where)[0].outerHTML;
313 }
314 </script>
315 <a href='#' onClick="duplicate_element('input_set', 'input_set_next')">+</a>
316EOF;
317 }
318
bda4a4be 319 $btn = is_array($current) ? 'UPDATE' : 'INSERT'; //TODO: $current may be set even when inserting...
fc5c5b8b
TM		 320 $html.=$this->input(false, $btn, 'submit');
321 $html.='</form>';
322 return $html;
cdfce7c2
TM		 323 }
324}
325
78bf26a5
TM		 326/**
327* Trida poskytuje rozhrani k databazi skladu
328*
329* @package Sklad_DB
330* @author Tomas Mudrunka
331*/
cdfce7c2
TM		 332class Sklad_DB extends PDO {
333 function __construct() {
334 $this->lms = new Sklad_LMS();
335
336 parent::__construct(
337 DB_DSN, DB_USER, DB_PASS,
338 array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") //Force UTF8 for MySQL
339 );
340 }
341
342 function escape($str) {
343 return preg_replace('(^.|.$)', '', $this->quote($str)); //TODO HACK
344 }
345
cb8a6861 346 function build_query_select($class, $id=false, $limit=false, $offset=0, $where=false, $search=false, $history=false, $order=false, $suffix_id='_id') {
2bedfdac 347 //Configuration
cdfce7c2
TM		 348 $join = array(
349 'item' => array('model', 'category', 'producer', 'vendor', 'room', 'status'),
350 'model' => array('category', 'producer')
9ea191cb 351 ); //TODO Autodetect using foreign keys?
cdfce7c2 352 $search_fields = array(
df4079a6 353 'item' => array('item_id','item_serial','model_name','model_barcode','model_descript','producer_name','vendor_name')
9ea191cb 354 ); //TODO Autodetect
2bedfdac
TM		 355
356 //Escaping
357 $class = $this->escape($class);
358
359 //SELECT
cdfce7c2 360 $sql="SELECT * FROM $class\n";
2bedfdac 361 //JOIN
8fd613d6 362 if(isset($join[$class])) foreach($join[$class] as $j) $sql .= "LEFT JOIN $j USING($j$suffix_id)\n";
2bedfdac 363 //WHERE/REGEXP
cdfce7c2
TM		 364 if($search) {
365 $search = $this->quote($search);
326a9fc9 366 if(!isset($search_fields[$class])) die(trigger_error(T("Can't search in $class table yet :-("))); //TODO: post_redirect_get
5895162b
TM		 367 $sql_search = '';
368 foreach($search_fields[$class] as $column) $sql_search .= "OR $column REGEXP $search ";
369 $where[] = "FALSE $sql_search";
cb8a6861
TM		 370 } elseif($id) $where[] = "$class$suffix_id = $id";
371 if(!$history && $this->contains_history($class)) $where[] = $class.'_valid_till=0';
372
5895162b 373 if($where) $sql .= 'WHERE ('.implode(') AND (', $where).")\n";
117817be
TM		 374 //ORDER
375 if(!$order) $order = $class.$suffix_id;
376 if($this->contains_history($class)) $order .= ",${class}_valid_from DESC";
377 $sql .= "ORDER BY $order\n";
2bedfdac 378 //LIMIT/OFFSET
cdfce7c2
TM		 379 if($limit) {
380 $limit = $this->escape((int)$limit);
381 $offset = $this->escape((int)$offset);
382 $sql .= "LIMIT $offset,$limit\n";
383 }
2bedfdac 384
cdfce7c2
TM		 385 return $sql;
386 }
387
66b6f4d6 388 function safe_query($sql, $fatal=true) {
cdfce7c2
TM		 389 $result = $this->query($sql);
390 if(!$result) {
2bedfdac 391 $error = $this->errorInfo();
66b6f4d6
TM		 392 trigger_error("<font color=red><b>QUERY FAILED ($error[0],$error[1]): </b>$error[2]<br /><br /><b>QUERY:</b>\n<pre>$sql</pre></font>");
393 if($fatal) die();
cdfce7c2
TM		 394 }
395 return $result;
396 }
397
326a9fc9
TM		 398 function translate_query_results($result) {
399 $translate_cols = array('status_name', 'item_valid_till'); //TODO: Hardcoded
400 foreach($result as $key => $row) {
401 foreach($translate_cols as $col) if(isset($result[$key][$col])){
402 $result[$key][$col] = T($result[$key][$col]);
403 }
404 }
405 return $result;
406 }
407
408 function safe_query_fetch($sql, $fatal=true, $fetch_flags = PDO::FETCH_ASSOC, $translate=true) {
409 $result = $this->safe_query($sql, $fatal)->fetchAll($fetch_flags);
410 if($translate) $result = $this->translate_query_results($result);
411 return $result;
412 }
413
414
cb8a6861
TM		 415 function get_listing($class, $id=false, $limit=false, $offset=0, $where=false, $search=false, $history=false, $indexed=array(), $suffix_id='_id') {
416 $sql = $this->build_query_select($class, $id, $limit, $offset, $where, $search, $history);
326a9fc9 417 $result = $this->safe_query_fetch($sql);
cdfce7c2
TM		 418 if(!$result || !is_array($indexed)) return $result;
419
420 foreach($result as $key => $row) $indexed[$row[$class.$suffix_id]]=$row;
421 return $indexed;
422 }
423
424 function get_columns($class) {
425 $class = $this->escape($class);
426 $sql = "SHOW COLUMNS FROM $class;";
326a9fc9 427 return $this->safe_query_fetch($sql);
cdfce7c2
TM		 428 }
429
430 function columns_get_selectbox($columns, $class=false, $suffix_id='_id', $suffix_name='_name') {
431 $selectbox=array();
432 foreach($columns as $column) {
66b6f4d6 433 if($column['Field'] == 'user_id') continue; //TODO HACK Blacklist: tabulka nemusi obsahovat *_name!!! momentalne se to tyka jen tabulky user (a item - u ty to nevadi)!
cdfce7c2
TM		 434 if($class && $column['Field'] == $class.$suffix_id) continue;
435 if(!preg_match('/'.$suffix_id.'$/', $column['Field'])) continue;
436 $table=preg_replace('/'.$suffix_id.'$/','',$column['Field']);
66b6f4d6 437
117817be 438 $history = $this->contains_history($table) ? " WHERE ${table}_valid_till=0" : '';
b4dcae05 439 $sql = "SELECT $table$suffix_id, $table$suffix_name FROM $table$history;"; //TODO use build_query_select()!!!
326a9fc9 440 $result = $this->safe_query_fetch($sql, false);
66b6f4d6 441 if(!$result) continue;
cdfce7c2
TM		 442 foreach($result as $row) $selectbox[$table.$suffix_id][$row[$table.$suffix_id]]=$row[$table.$suffix_name];
443 }
444 //echo('<pre>'); print_r($selectbox);
66b6f4d6 445 return array_filter($selectbox, 'ksort');
9ea191cb
TM		 446 }
447
16261142
TM		 448 function map_unique($key, $value, $select, $table) { //TODO: Guess $select and $table if not passed
449 $history = $this->contains_history($table) ? " AND ${table}_valid_till=0" : '';
450 $value=$this->quote($value);
451 $sql = "SELECT $select FROM $table WHERE $key=$value$history LIMIT 1;"; //TODO use build_query_select()!!!
326a9fc9
TM		 452 $result = $this->safe_query_fetch($sql);
453 if(isset($result[0][$select])) return $result[0][$select]; else die(trigger_error(T('Record not found!'))); //TODO post_redirect_get...
16261142
TM		 454 }
455
9ea191cb
TM		 456 function contains_history($table) {
457 $history_tables = array('item'); //TODO Autodetect
458 return in_array($table, $history_tables);
cdfce7c2
TM		 459 }
460
461 function build_query_insert($table, $values, $replace=true, $suffix_id='_id') {
b66fadbb
TM		 462 //Init
463 $history = $this->contains_history($table);
464
9ea191cb 465 //Escaping
cdfce7c2
TM		 466 $table = $this->escape($table);
467
468 //Get list of POSTed columns
aa3fd0a8
TM		 469 $columns_array = array_map(array($this,'escape'), array_keys($values[0]));
470 $columns = implode(',',$columns_array);
cdfce7c2 471
9fb856ba 472 //Build query
b66fadbb 473 $sql = '';
b66fadbb
TM		 474 //echo('<pre>'); die(print_r($values));
475
476 if($history) {
477 $history_update=false; foreach($values as $row) if(is_numeric($row[$table.'_id'])) $history_update=true;
478 if($history_update) {
479 $sql .= "UPDATE $table";
117817be
TM		 480 $sql .= " SET ${table}_valid_till=NOW()";
481 $sql .= " WHERE ${table}_valid_till=0 AND (";
b66fadbb
TM		 482 $or = '';
483 foreach($values as $row) {
484 $sql .= $or.' '.$table.'_id='.$row[$table.'_id'];
485 $or = ' OR';
486 }
487 $sql .= " );\n\n";
488 $replace = false;
489 }
490 }
491
cdfce7c2 492 //Insert into table (columns)
aa3fd0a8 493 $sql .= "INSERT INTO $table ($columns) VALUES ";
cdfce7c2
TM		 494
495 //Values (a,b,c),(d,e,f)
496 $comma='';
497 foreach($values as $row) {
9fb856ba
TM		 498 $row_quoted = array_map(array($this,'quote'), $row); //Check
499 if($history) {
b66fadbb
TM		 500 foreach($row as $column => $value) {
501 switch($column) {
502 case $table.'_valid_from':
503 $row_quoted[$column] = 'NOW()';
504 break;
505 case $table.'_valid_till':
506 $row_quoted[$column] = '0';
507 break;
9fb856ba
TM		 508 case $table.'_author':
509 $row_quoted[$column] = $this->lms->get_authorized_user_id();
b66fadbb
TM		 510 //die($this->lms->get_authorized_user_id().'=USER');
511 break;
b66fadbb
TM		 512 }
513 }
514 }
515 $sql .= $comma.'('.implode(',',$row_quoted).')';
cdfce7c2
TM		 516 $comma = ',';
517 }
518
aa3fd0a8
TM		 519 //On duplicate key
520 if($replace) {
521 foreach($columns_array as $col) {
522 if($col == $table.'_id' || $col == $table.'_valid_till') continue;
523 $on_duplicate[] = "$col=VALUES($col)";
524 }
525 $sql .= "\nON DUPLICATE KEY UPDATE ".implode(',', $on_duplicate);
526 }
527
cdfce7c2
TM		 528 //Terminate
529 $sql .= ';';
530 return $sql;
531 }
532
b4dcae05
TM		 533 function insert_or_update($table, $values, $replace=true) {
534 $sql = $this->build_query_insert($table, $values, $replace);
cdfce7c2
TM		 535 $this->safe_query($sql);
536 return $this->lastInsertId();
537 }
538
b4dcae05 539 function insert_or_update_multitab($values, $replace=true) {
371a86f4 540 $last=false;
b4dcae05 541 foreach($values as $table => $rows) $last = $this->insert_or_update($table, $rows, $replace);
371a86f4
TM		 542 return $last;
543 }
544
cdfce7c2 545 function delete($table, $id, $suffix_id='_id') {
64f31c54 546 if($this->contains_history($table)) return false;
cdfce7c2
TM		 547 $key = $this->escape($table.$suffix_id);
548 $table = $this->escape($table);
549 $id = $this->quote($id);
550 return $this->safe_query("DELETE FROM $table WHERE $key = $id LIMIT 1;");
551 }
552}
553
0a027cc7
TM		 554/**
555* Trida poskytuje high-level rozhrani k databazi skladu
556*
557* @package Sklad_DB_Abstract
558* @author Tomas Mudrunka
559*/
560class Sklad_DB_Abstract extends Sklad_DB {
561 //TODO Code
562}
563
78bf26a5
TM		 564/**
565* Trida implementuje uzivatelske rozhrani skladu
566*
567* Example usage:
568* $sklad = new Sklad_UI();
569* $sklad->process_http_request();
570*
571* @package Sklad_UI
572* @author Tomas Mudrunka
573*/
cdfce7c2
TM		 574class Sklad_UI {
575 function __construct() {
576 $this->db = new Sklad_DB();
577 $this->html = new Sklad_HTML();
578 }
579
cb8a6861
TM		 580 function render_items($class, $id=false, $limit=false, $offset=0, $where=false, $search=false, $history=false) {
581 return $this->html->render_item_table($this->db->get_listing($class, $id, $limit, $offset, $where, $search, $history, false));
cdfce7c2
TM		 582 }
583
a25f85f8 584 function render_form_add($class) {
cdfce7c2
TM		 585 $columns = $this->db->get_columns($class);
586 $selectbox = $this->db->columns_get_selectbox($columns, $class);
a25f85f8 587 return $this->html->render_insert_form($class, $columns, $selectbox);
cdfce7c2
TM		 588 }
589
a25f85f8 590 function render_form_edit($class, $id) {
cdfce7c2
TM		 591 $columns = $this->db->get_columns($class);
592 $selectbox = $this->db->columns_get_selectbox($columns, $class);
117817be 593 $current = $this->db->get_listing($class, $id, 1);
a25f85f8 594 return $this->html->render_insert_form($class, $columns, $selectbox, $current);
cdfce7c2
TM		 595 }
596
a25f85f8 597 function render_single_record_details($class, $id) {
cdfce7c2
TM		 598 $id_next = $id + 1;
599 $id_prev = $id - 1 > 0 ? $id - 1 : 0;
600 $get = $_SERVER['QUERY_STRING'] != '' ? '?'.$_SERVER['QUERY_STRING'] : '';
a25f85f8
TM		 601 $html='';
602 $html.= $this->html->link('<<', "$class/$id_prev/");
603 $html.= '-';
604 $html.= $this->html->link('>>', "$class/$id_next/");
605 $html.= '<br />';
606 $html.= $this->html->link('edit', "$class/$id/edit/");
9fb856ba 607 if($this->db->contains_history($class)) $html.= ' ][ '.$this->html->link('history', "$class/$id/history/");
a25f85f8 608 return $html;
cdfce7c2
TM		 609 }
610
a25f85f8 611 function render_listing_navigation($class, $id, $limit, $offset) {
cdfce7c2
TM		 612 $offset_next = $offset + $limit;
613 $offset_prev = $offset - $limit > 0 ? $offset - $limit : 0;
614 $get = $_SERVER['QUERY_STRING'] != '' ? '?'.$_SERVER['QUERY_STRING'] : '';
a25f85f8
TM		 615 $html='';
616 $html.= $this->html->link('<<', "$class/$id/$limit/$offset_prev/$get");
617 $html.= '-';
618 $html.= $this->html->link('>>', "$class/$id/$limit/$offset_next/$get");
619 $html.= '<br />';
620 $html.= $this->html->link('new', "$class/new/$get");
621 return $html;
cdfce7c2
TM		 622 }
623
a25f85f8
TM		 624 function render_listing_extensions($class, $id, $limit, $offset, $edit=false) {
625 $html='';
cdfce7c2 626 if(is_numeric($id)) {
a25f85f8 627 $html.=$this->render_single_record_details($class, $id);
cdfce7c2 628 } else {
a25f85f8 629 $html.=$this->render_listing_navigation($class, '*', $limit, $offset);
cdfce7c2
TM		 630 }
631 if($edit) {
a25f85f8 632 $html.= $this->render_form_edit($class, $id);
cdfce7c2 633 $action = $_SERVER['SCRIPT_NAME']."/$class/$id/delete";
a25f85f8
TM		 634 $html.= "<form action='$action' method='POST'>";
635 $html.= $this->html->input(false, 'DELETE', 'submit');
326a9fc9 636 $html.= T('sure?').$this->html->input('sure', false, 'checkbox');
a25f85f8 637 $html.= '</form>';
cdfce7c2 638 $action = $_SERVER['SCRIPT_NAME']."/$class/$id/image";
a25f85f8
TM		 639 $html.= "<form action='$action' method='POST' enctype='multipart/form-data'>";
640 $html.= $this->html->input('image', false, 'file', false, 'size="30"');
641 $html.= $this->html->input(false, 'IMAGE', 'submit');
642 $html.='</form>';
cdfce7c2 643 }
a25f85f8 644 return $html;
cdfce7c2
TM		 645 }
646
647 function check_auth() {
648 new HTTP_Auth('SkladovejSystem', true, array($this->db->lms,'check_auth'));
649 }
650
64f31c54 651 function post_redirect_get($location, $message='', $error=false) {
326a9fc9 652 $url_args = $message != '' ? '?message='.urlencode(T($message)) : '';
8acef003 653 $location = $this->html->internal_url($location).$url_args;
1f74892d 654 header('Location: '.$location);
64f31c54 655 if($error) trigger_error($message);
7efdf72a
TM		 656 $location=htmlspecialchars($location);
657 die(
658 "<meta http-equiv='refresh' content='0; url=$location'>".
326a9fc9 659 T($message)."<br />Location: <a href='$location'>$location</a>"
7efdf72a 660 );
cdfce7c2
TM		 661 }
662
623c65e2 663 function safe_include($dir,$name,$vars=array(),$ext='.inc.php') {
64f31c54 664 if(preg_match('/[^a-zA-Z0-9-]/',$name)) $this->post_redirect_get('', 'SAFE INCLUDE: Securityfuck.', true);
3e6c412e 665 $filename="$dir/$name$ext";
64f31c54 666 if(!is_file($filename)) $this->post_redirect_get('', 'SAFE INCLUDE: Fuckfound.', true);
623c65e2 667 foreach($vars as $var => $val) $$var=$val;
3e6c412e
TM		 668 ob_start();
669 include($filename);
670 $out=ob_get_contents();
671 ob_end_clean();
672 return $out;
673 }
674
bda4a4be 675 function process_http_request_post($action=false, $class=false, $id=false, $force_redirect=false) {
cdfce7c2 676 if($_SERVER['REQUEST_METHOD'] != 'POST') return;
1f74892d 677 //echo('<pre>'); //DEBUG (maybe todo remove), HEADERS ALREADY SENT!!!!
cdfce7c2
TM		 678
679 //SephirPOST:
371a86f4
TM		 680
681 /* Tenhle foreach() prekopiruje promenne
7d20381f 682 * z: $_POST['values'][$table][$column][$id];
371a86f4
TM		 683 * do: $values[$table][$id][$column]
684 */
7d20381f
TM		 685 if(isset($_POST['values'])) {
686 $values=array();
687 foreach($_POST['values'] as $table => $columns) {
688 foreach($columns as $column => $ids) {
689 foreach($ids as $id => $val) $values[$table][$id][$column] = $val;
690 }
cdfce7c2 691 }
7d20381f 692 //die(print_r($values));
cdfce7c2
TM		 693 }
694
695 if($action) switch($action) {
696 case 'new':
b4dcae05 697 $replace = false;
cdfce7c2 698 case 'edit':
b4dcae05 699 if(!isset($replace)) $replace = true;
64f31c54 700 $table = $class ? $class : 'item';
cdfce7c2 701 //print_r($values); //debug
b4dcae05 702 $last = $this->db->insert_or_update_multitab($values, $replace);
bda4a4be 703 $last = $force_redirect ? $force_redirect."?last=$last" : "$table/$last/";
d9384cb5 704 $next = "$table/new/";
bda4a4be
TM		 705 $message = $force_redirect ? '' : 'Hotovo. Další záznam přidáte '.$this->html->link('zde', $next).'.';
706 $this->post_redirect_get($last, $message);
cdfce7c2
TM		 707 break;
708 case 'delete':
64f31c54
TM		 709 if(!isset($_POST['sure']) || !$_POST['sure']) $this->post_redirect_get("$class/$id/edit", 'Sure user expected :-)');
710 $this->db->delete($class, $id) || $this->post_redirect_get("$class/$id/edit", "V tabulce $class jentak neco mazat nebudes chlapecku :-P");
1f74892d 711 $this->post_redirect_get("$class", "Neco (pravdepodobne /$class/$id) bylo asi smazano. Fnuk :'-(");
cdfce7c2
TM		 712 break;
713 case 'image':
714 $image_classes = array('model'); //TODO, use this more widely across the code
64f31c54 715 if(!in_array($class, $image_classes)) $this->post_redirect_get("$class/$id/edit", "Nekdo nechce k DB Tride '$class' prirazovat obrazky!");
cdfce7c2 716 $image_destination = DIR_IMAGES."/$class/$id.jpg";
326a9fc9 717 if($_FILES['image']['name'] == '') $this->post_redirect_get("$class/$id/edit", 'Everything has to be called somehow!', true);
cdfce7c2 718 if(move_uploaded_file($_FILES['image']['tmp_name'], $image_destination)) {
1f74892d 719 chmod ($image_destination, 0664);
326a9fc9
TM		 720 $this->post_redirect_get("$class/$id", 'Image has been upbloated successfully :)');
721 } else $this->post_redirect_get("$class/$id/edit", 'File upload failed :(', true);
cdfce7c2
TM		 722 break;
723 default:
326a9fc9 724 $this->post_redirect_get('', 'Nothin\' to do here my cutie :-*');
cdfce7c2
TM		 725 break;
726 }
727
728 die('POSTed pyčo!');
729 }
730
731 function process_http_request() {
732 $this->check_auth();
733
734 @ini_set('magic_quotes_gpc' , 'off');
735 if(get_magic_quotes_gpc()) {
736 die(trigger_error("Error: magic_quotes_gpc needs to be disabled! F00K!"));
737 }
738
739 $PATH_INFO=@trim($_SERVER[PATH_INFO]);
8fd613d6 740 if($_SERVER['REQUEST_METHOD'] != 'POST') echo $this->html->header($PATH_INFO); //TODO tahle podminka naznacuje ze je v navrhu nejaka drobna nedomyslenost...
cdfce7c2
TM		 741
742
743 //Sephirot:
744 $PATH_CHUNKS = preg_split('/\//', $PATH_INFO);
745 if(!isset($PATH_CHUNKS[1])) $PATH_CHUNKS[1]='';
746 switch($PATH_CHUNKS[1]) {
747 case 'test': //test
748 die('Tell me why you cry');
749 break;
3e6c412e 750 case 'assistant': //assistant
de77377e
TM		 751 $PATH_CHUNKS[3] = isset($PATH_CHUNKS[3]) ? trim($PATH_CHUNKS[3]) : false;
752 $assistant_vars['SUBPATH'] = array_slice($PATH_CHUNKS, 3);
753 $assistant_vars['URL_INTERNAL'] = 'assistant/'.$PATH_CHUNKS[2];
754 $assistant_vars['URL'] = $_SERVER['SCRIPT_NAME'].'/'.$assistant_vars['URL_INTERNAL'];
623c65e2 755 echo $this->safe_include(DIR_ASSISTANTS,$PATH_CHUNKS[2],$assistant_vars);
3e6c412e 756 break;
cdfce7c2
TM		 757 default: //?
758 $search = (isset($_GET['q']) && trim($_GET['q']) != '') ? trim($_GET['q']) : false;
759 $class = (isset($PATH_CHUNKS[1]) && $PATH_CHUNKS[1] != '') ? $PATH_CHUNKS[1] : 'item';
760 if(!isset($PATH_CHUNKS[2])) $PATH_CHUNKS[2]='';
761 switch($PATH_CHUNKS[2]) {
762 case 'new': //?/new
763 $this->process_http_request_post($PATH_CHUNKS[2], $class);
a25f85f8 764 echo $this->render_form_add($class);
cdfce7c2
TM		 765 break;
766 default: //?/?
767 $id = (isset($PATH_CHUNKS[2]) && is_numeric($PATH_CHUNKS[2]) ? (int) $PATH_CHUNKS[2] : false);
768 if(!isset($PATH_CHUNKS[3])) $PATH_CHUNKS[3]='';
769 $edit=false;
770 switch($PATH_CHUNKS[3]) {
771 case 'edit': //?/?/edit
9fb856ba
TM		 772 case 'image': //?/?/image
773 case 'delete': //?/?/delete
cdfce7c2
TM		 774 $this->process_http_request_post($PATH_CHUNKS[3], $class, $id);
775 $edit=true;
776 default: //?/?/?
9fb856ba 777 $history = $PATH_CHUNKS[3] == 'history' ? true : false;
cdfce7c2
TM		 778 $limit = (int) (isset($PATH_CHUNKS[3]) ? $PATH_CHUNKS[3] : '0');
779 $offset = (int) (isset($PATH_CHUNKS[4]) ? $PATH_CHUNKS[4] : '0');
cb8a6861
TM		 780 $where = false; //TODO get from URL
781 echo $this->render_items($class, $id, $limit, $offset, $where, $search, $history);
a25f85f8 782 echo $this->render_listing_extensions($class, $id, $limit, $offset, $edit);
cdfce7c2
TM		 783 //print_r(array("<pre>",$_SERVER));
784 break;
785 }
786 break;
787 }
788 break;
789 }
790 }
791}
792
793$sklad = new Sklad_UI();
794$sklad->process_http_request();
795
796echo("<hr/>");
https://github.com/Harvie/SokoMan.git (mirrored @ Sat, 18 May 2024 19:20:12 +0200)
This page took 1.152447 seconds and 4 git commands to generate.