Zjednoduseni naskladnovani + hadani dodavatele (Wolfovo zadost)

[mirrors/SokoMan.git] / index.php

diff --git a/index.php b/index.php
index b40fc8859596c4afedff1297e45a7f360d5779b8..f1744a4a17fe63cb429b2efaa180ee23df26bc74 100755 (executable)
--- a/index.php
+++ b/index.php
@@ -185,7 +185,7 @@ class HTML {
 * @author   Tomas Mudrunka
 */
 class Sklad_HTML extends HTML { //TODO: Split into few more methods
-       function header($title='', $user=array()) {
+       function header($title='', $user=array(), $headerhtml) {
                $home = URL_HOME;
                $script = $_SERVER['SCRIPT_NAME'];
                $search = htmlspecialchars(@trim($_GET['q']));
@@ -308,7 +308,7 @@ EOF;
 </div>
 <hr style="clear: both;" />
 <div style="background-color:#FFDDDD;">
-       <font color="red">$message</font>
+       <font color="red">$headerhtml $message</font>
 </div>
 <div style="text-align:right; color:darkgreen;">
 $fortune
@@ -361,7 +361,7 @@ EOF;
                $relations = array( //TODO: Autodetect??? //TODO: Add [edit] link to all classes
                        'model' => array(
                                'model_id' => array(array('item',$where_url),array('barcode',$where_url),array('edit','model/%v/edit/'),array('barcode',$insert_url)),
-                               //'model_barcode' => array(array('store','assistant/%d?barcode=%v')),
+                               'model_barcode' => array(array('store','assistant/%d?barcode=%v')),
                                'barcode_name' => array(array('store','assistant/%d?barcode=%v')),
                                'model_name' => array(array('google','http://google.com/search?q=%v')) //TODO: add manufacturer to google query
                        ),
@@ -421,6 +421,7 @@ EOF;
                        'status_id' => 'status_name',
                        'item_author' => 'item_author_backend',
                        'item_customer' => 'item_customer',
+                       'lock_id' => 'lock_name',
                );
 
                foreach($table as $id => $row) {
@@ -458,8 +459,8 @@ EOF;
 
        function table_hide_columns(&$table, $class) { //TODO: Move to build_query_select() !!! :-)))
                $fields_hide = array(
-                       'model' => array('model_barcode','barcode_name'),
-                       'barcode' => array('model_barcode','model_price_in','model_price_out','model_reserve','producer_name','producer_note','model_eshop_hide','category_name','model_countable','model_descript'),
+                       'model' => array('barcode_name'),
+                       'barcode' => array('model_price_in','model_price_out','model_reserve','producer_name','producer_note','model_eshop_hide','category_name','model_countable','model_descript'),
                        'item' => array('model_descript','model_price_in','model_price_out','barcode_name','model_barcode','model_countable','model_reserve','model_eshop_hide','room_descript','room_author','producer_name','producer_note','vendor_note','location_author','location_gps','location_description')
                );
                //print_r($table); die();
@@ -640,8 +641,8 @@ class Sklad_DB extends PDO {
                        'model' => array('barcode'=>'model_id')
                );
                $fields_search = array(
-                       'item'  => array('item_id','item_serial','model_name','barcode_name','model_barcode','model_descript','producer_name','vendor_name'),
-                       'model' => array('model_id','model_name','barcode_name','model_barcode','model_descript','producer_name')
+                       'item'  => array('item_id','item_serial','model_name','barcode_name','model_descript','producer_name','vendor_name'),
+                       'model' => array('model_id','model_name','barcode_name','model_descript','producer_name')
                ); //TODO Autodetect
                $group_concat = array(
                        'model' => array('barcode_name'=>'model_id')
@@ -663,7 +664,6 @@ class Sklad_DB extends PDO {
 
                //SELECT
                $sql="SELECT *$group_concat_query FROM `$class`\n";
-               //$sql="SELECT * FROM `$class`\n";
                //JOIN
                if(isset($join[$class])) foreach($join[$class] as $j) $sql .= "LEFT JOIN `$j` USING($j$suffix_id)\n";
                if(isset($join2[$class])) foreach($join2[$class] as $j => $c) $sql .= "LEFT JOIN `$j` USING($c)\n";
@@ -685,7 +685,7 @@ class Sklad_DB extends PDO {
                //ORDER
                if(!$order) $order = $class.$suffix_id.' DESC';
                if($this->contains_history($class)) $order .= ",${class}_valid_from DESC";
-               //$sql .= "ORDER BY $order\n"; //TODO: fixnout az budou opraveny vicenasobny carovy kody
+               $sql .= "ORDER BY $order\n";
                //LIMIT/OFFSET
                if($limit) {
                        $limit = $this->escape((int)$limit);
@@ -727,7 +727,9 @@ class Sklad_DB extends PDO {
        }
 
        function safe_query_fetch($sql, $fatal=true, $fetch_flags = PDO::FETCH_ASSOC, $translate=true) {
-               $result = $this->safe_query($sql, $fatal)->fetchAll($fetch_flags);
+               $result = $this->safe_query($sql, $fatal);
+               if(!$fatal && !$result) return $result;
+               $result = $result->fetchAll($fetch_flags);
                $this->load_backend_data_to_query_results($result);
                if($translate) $this->translate_query_results($result);
                return $result;
@@ -744,7 +746,7 @@ class Sklad_DB extends PDO {
 
        function get_columns($class,$disable_cols=array()) { //TODO: Not sure if compatible with non-MySQL DBs
                $class = $this->escape($class);
-               $sql = "SHOW COLUMNS FROM $class;";
+               $sql = "SHOW COLUMNS FROM `$class`;";
                $columns = $this->safe_query_fetch($sql);
                /*foreach($columns as $colk => $col) foreach($col as $key => $val) {
                        if(in_array($col['Field'],$disable_cols)) $columns[$colk]['Extra']='auto_increment';
@@ -1019,6 +1021,14 @@ class Sklad_UI {
                return true;
        }
 
+       function check_locks() {
+               $result = $this->db->safe_query_fetch("SELECT * FROM `lock`;");
+               if(!empty($result)) {
+                       echo T('There are locks:').' '.$this->html->render_item_table($result);
+                       $this->post_redirect_get('', 'There are locks!', true);
+               }
+       }
+
        function process_http_request_post($action=false, $class=false, $id=false, $force_redirect=false) {
                if($_SERVER['REQUEST_METHOD'] != 'POST') return;
                //echo('<pre>'); //DEBUG (maybe todo remove), HEADERS ALREADY SENT!!!!
@@ -1030,6 +1040,7 @@ class Sklad_UI {
                 * do:  $values[$table][$id][$column]
                 */
                if(isset($_POST['values'])) {
+                       $this->check_locks();
                        $values=array();
                        foreach($_POST['values'] as $table => $columns) {
                                foreach($columns as $column => $ids) {
@@ -1050,6 +1061,7 @@ class Sklad_UI {
                        case 'new':
                                $replace = false;
                        case 'edit':
+                               $this->check_locks();
                                if(!isset($replace)) $replace = true;
                                $table = $class ? $class : 'item';
                                //print_r($values); //debug
@@ -1060,6 +1072,7 @@ class Sklad_UI {
                                $this->post_redirect_get($last, $message);
                                break;
                        case 'delete':
+                               $this->check_locks();
                                if(!isset($_POST['sure']) || !$_POST['sure']) $this->post_redirect_get("$class/$id/edit", 'Sure user expected :-)');
                                $this->db->delete($class, $id) || $this->post_redirect_get("$class/$id/edit", "V tabulce $class jentak neco mazat nebudes chlapecku :-P");
                                $this->post_redirect_get("$class", "Neco (pravdepodobne /$class/$id) bylo asi smazano. Fnuk :'-(");
@@ -1097,8 +1110,11 @@ class Sklad_UI {
                $PATH_CHUNKS = preg_split('/\//', $PATH_INFO);
                //Sephirot:
                if(!isset($PATH_CHUNKS[1])) $PATH_CHUNKS[1]='';
-               if($_SERVER['REQUEST_METHOD'] != 'POST' && $PATH_CHUNKS[1]!='barcodeimg' && $PATH_CHUNKS[1]!='api') //TODO: tyhle podminky naznacujou, ze je v navrhu nejaka drobna nedomyslenost...
-                       echo $this->html->header($PATH_INFO,$this->db->auth->get_user());
+               if($_SERVER['REQUEST_METHOD'] != 'POST' && $PATH_CHUNKS[1]!='barcodeimg' && $PATH_CHUNKS[1]!='api') { //TODO: tyhle podminky naznacujou, ze je v navrhu nejaka drobna nedomyslenost...
+                       $result = $this->db->safe_query_fetch("SELECT * FROM `lock`;");
+                       $headerhtml = !empty($result) ? T('There are locks:').' '.$this->html->render_item_table($result) : '';
+                       echo $this->html->header($PATH_INFO,$this->db->auth->get_user(),$headerhtml);
+               }
                switch($PATH_CHUNKS[1]) { //TODO: Move some branches to plugins if possible
                        case 'test':    //test
                                die('Tell me why you cry');