From 345f03fd56a164913cc7f51c4a86d1cfa45e36de Mon Sep 17 00:00:00 2001
From: Alexander Smirnov <fredeom@mail.ru>
Date: Thu, 15 Aug 2024 17:13:11 +0300
Subject: [PATCH] =?utf8?q?=D0=9F=D0=BE=D0=B4=D0=BD=D0=B8=D0=BC=D0=B0=D0=B5?=
 =?utf8?q?=D0=BC=20=D1=81=D0=BE=20=D0=B4=D0=BD=D0=B0=20=D0=BC=D1=83=D1=81?=
 =?utf8?q?=D0=BE=D1=80:=20/modul/storage,=20/modul/store/itemmatrix?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 erp24/controllers/StorageController.php       | 12 +++++++
 erp24/controllers/StoreController.php         |  6 ++--
 erp24/inc/uni.php                             |  2 +-
 .../modul/storage/ajax_balances_in_group.php  | 13 +++----
 erp24/modul/storage/index.php                 | 36 +++++++++----------
 erp24/modul/storage/store.php                 | 29 ++++++++-------
 erp24/modul/store/itemmatrix.php              | 20 ++++++-----
 .../views/storage/ajax-balances-in-group.php  |  5 +++
 erp24/views/storage/index.php                 |  5 +++
 erp24/views/storage/store.php                 |  5 +++
 erp24/views/store/itemmatrix.php              |  5 +++
 11 files changed, 87 insertions(+), 51 deletions(-)
 create mode 100644 erp24/controllers/StorageController.php
 create mode 100644 erp24/views/storage/ajax-balances-in-group.php
 create mode 100644 erp24/views/storage/index.php
 create mode 100644 erp24/views/storage/store.php
 create mode 100644 erp24/views/store/itemmatrix.php

diff --git a/erp24/controllers/StorageController.php b/erp24/controllers/StorageController.php
new file mode 100644
index 00000000..dc4dda8e
--- /dev/null
+++ b/erp24/controllers/StorageController.php
@@ -0,0 +1,12 @@
+<?php
+
+namespace app\controllers;
+
+use yii\web\Controller;
+
+class StorageController extends Controller
+{
+    public function actionIndex() { return $this->render('index'); }
+    public function actionStore() { return $this->render('store'); }
+    public function actionAjaxBalancesInGroup() { return $this->renderPartial('ajax-balances-in-group'); }
+}
\ No newline at end of file
diff --git a/erp24/controllers/StoreController.php b/erp24/controllers/StoreController.php
index a0b49cec..20666274 100755
--- a/erp24/controllers/StoreController.php
+++ b/erp24/controllers/StoreController.php
@@ -6,8 +6,6 @@ use yii\web\Controller;
 
 class StoreController extends Controller
 {
-    public function actionStats()
-    {
-        return $this->render('stats');
-    }
+    public function actionStats() { return $this->render('stats'); }
+    public function actionItemmatrix() { return $this->render('itemmatrix'); }
 }
\ No newline at end of file
diff --git a/erp24/inc/uni.php b/erp24/inc/uni.php
index b55f7261..936e1411 100644
--- a/erp24/inc/uni.php
+++ b/erp24/inc/uni.php
@@ -1,6 +1,6 @@
 <?
 function store_select($form=1,$pole_name="id",$store_all=0) {
-global $db;
+global $db, $id;
 
 if(isset($_GET["store_id"])) $id=(int)$_GET["store_id"];
 if(isset($_GET["id"])) $id=(int)$_GET["id"];
diff --git a/erp24/modul/storage/ajax_balances_in_group.php b/erp24/modul/storage/ajax_balances_in_group.php
index d81d2754..bda22c6c 100644
--- a/erp24/modul/storage/ajax_balances_in_group.php
+++ b/erp24/modul/storage/ajax_balances_in_group.php
@@ -1,12 +1,13 @@
-<?
-include_once ("startup.php");
-include_once("inc/db.php");
-include_once("inc/db2.php");
-include_once("inc/base_new.php");
-if(!empty($_REQUEST["parent_id"])) { 
+<?php
+include_once(dirname(__DIR__, 2) . "/startup.php");
+include_once(dirname(__DIR__, 2) . "/inc/db.php");
+include_once(dirname(__DIR__, 2) . "/inc/base_new.php");
+
+if(!empty($_REQUEST["parent_id"])) {
 
 $parent_id=htmlentities($_REQUEST["parent_id"]);
 $store_id=htmlentities($_REQUEST["store_id"]);
+
 $data0 = $db::getRows("SELECT 
 products_1c.name,prices.price,balances.quantity, balances.reserv 
 FROM products_1c, prices,balances WHERE products_1c.tip='products'
diff --git a/erp24/modul/storage/index.php b/erp24/modul/storage/index.php
index ae436f8d..a2e49e99 100644
--- a/erp24/modul/storage/index.php
+++ b/erp24/modul/storage/index.php
@@ -1,24 +1,24 @@
-<?
-include_once ("startup.php");
-include_once("inc/db.php");
-include_once("inc/base_new.php");
-include_once("inc/design_new.php");
-include_once("inc/uni.php");
-include_once("inc/uni2.php");
+<?php
+include_once(dirname(__DIR__, 2) . "/startup.php");
+include_once(dirname(__DIR__, 2) . "/inc/db.php");
+include_once(dirname(__DIR__, 2) . "/inc/base_new.php");
+include_once(dirname(__DIR__, 2) . "/inc/design_new.php");
+include_once(dirname(__DIR__, 2) . "/inc/uni.php");
+include_once(dirname(__DIR__, 2) . "/inc/uni2.php");
 
 
-
-include"templates/top.php";
-
 $modul="storage";
 $sql_table="balances";
 $pole_name="store_id";
 
-
+$id = 0;
+$store_id = 0;
 if(!empty($_REQUEST["$pole_name"])) $store_id=htmlentities($_REQUEST["$pole_name"]);
 $row=$db::getRow("SELECT name, id FROM products_1c WHERE id=?",[$store_id]);
 
-echo'<div class="page-header"><h1 class="page-title m-0 text-primary">Складские остатки '.$row["name"].'';
+if ($row) {
+    echo'<div class="page-header"><h1 class="page-title m-0 text-primary">Складские остатки '.$row["name"].'';
+}
 
 $form=1;
 $data=$db::getRows("SELECT name,id FROM products_1c WHERE tip='city_store' AND view='1' order by name ASC");
@@ -30,17 +30,16 @@ foreach($data as $row2) $products_group[$row2["id"]]=$row2["name"];
 if($form==1) echo'<form action="" method=get class="m-0 p-0">';
 
 echo'<table><td><select class="form-control" name='.$pole_name.' '; if($form==1 or $form=="-1") echo' onchange="this.form.submit();"'; echo'>';
-echo'<option value=0'; if(0==$id) echo' selected'; echo'>-выбрать магазин-</option>';
-if($store_all==1) { echo'<option value="-1"'; if("-1"==$id) echo' selected'; echo'>-все магазины-</option>'; }
+echo'<option value=0'; if(0==($id ?? -1)) echo' selected'; echo'>-выбрать магазин-</option>';
+if(($store_all ?? 0)==1) { echo'<option value="-1"'; if("-1"==$id) echo' selected'; echo'>-все магазины-</option>'; }
   
 foreach($store_arr as $sid =>$store) { 
- // if(in_array($sid,$_SESSION["store_arr_dostup_guid"]))   
-         echo'<option value='.$sid.''; if($sid==$store_id) echo' selected'; echo'>'.$store.'</option>';
+    echo'<option value='.$sid.''; if($sid==$store_id) echo' selected'; echo'>'.$store.'</option>';
 }
 
 echo'</select></td>';
-if($form==1) echo'<td><button class="btn btn-success" type=submit>вывести</button></td></table></form>';
-echo'</h1></div></div>';
+if($form==1) echo'<td></td></table></form>';
+echo'</h1></div>';
 
 echo"<a href=\"/storage/store/\" class=\"btn btn-info\">Остатки по группам как в 1с</a>";
 
@@ -63,4 +62,3 @@ echo'</tbody></table></div>';
 }
 
 
-include"templates/bottom.php";
diff --git a/erp24/modul/storage/store.php b/erp24/modul/storage/store.php
index 745cd05f..706c10ea 100644
--- a/erp24/modul/storage/store.php
+++ b/erp24/modul/storage/store.php
@@ -1,11 +1,13 @@
-<?
-include_once ("startup.php");
-include_once("inc/db.php");
-include_once("inc/base_new.php");
-include_once("inc/design_new.php");
+<?php
+include_once(dirname(__DIR__, 2) . "/startup.php");
+include_once(dirname(__DIR__, 2) . "/inc/db.php");
+include_once(dirname(__DIR__, 2) . "/inc/base_new.php");
+include_once(dirname(__DIR__, 2) . "/inc/design_new.php");
 
-include"templates/top.php";
 
+global $store_id;
+
+$store_id = '';
 
 if(!empty($_REQUEST["store_id"]))  $store_id=htmlentities($_REQUEST["store_id"]);
 if(!empty($_GET["id"]))  $id=(int)$_GET["id"];
@@ -24,7 +26,7 @@ foreach ($data as $row) $prices[$row['product_id']]= $row['price'];
 
 echo'<form action="" method=get class="m-0 p-0">';
 echo'<table><td><select class="form-control" name=store_id ';  echo' onchange="this.form.submit();"'; echo'>';
-echo'<option value=0'; if(0==$id) echo' selected'; echo'>-выбрать магазин-</option>';
+echo'<option value=0'; if(0==($id ?? -1)) echo' selected'; echo'>-выбрать магазин-</option>';
 $data=$db::getRows("SELECT name,id FROM products_1c WHERE tip='city_store' AND view='1' order by name ASC");
 foreach($data as $row) {
  echo'<option value='.$row["id"].''; if($row["id"]==$store_id) echo' selected'; echo'>'.$row["name"].'</option>';
@@ -88,11 +90,14 @@ $_CONFIG["jscss"]="
 
 function ajax_balances_in_group(parent_id,store_id){
 
+const param21 = $('meta[name=csrf-param]').attr('content');
+const token21 = $('meta[name=csrf-token]').attr('content');
+
 $.ajax({
-	url: '/storage/ajax_balances_in_group/',
+	url: '/storage/ajax-balances-in-group/',
 	method: 'post',       
 	dataType: 'html',        
-	data: {parent_id: ''+parent_id+'', store_id: ''+store_id+''},  
+	data: {parent_id: ''+parent_id+'', store_id: ''+store_id+'', [param21]: token21},  
 	success: function(data){  
    $('#tr_'+parent_id+'').after('<tr id=\"trr_'+parent_id+'\"><td colspan=2>'+data+'</td></tr>');
 
@@ -127,11 +132,11 @@ $.ajax({
 			</div>
 		</div>
 
-'; 
- 
+';
+
 
 
 
 
 
-include"templates/bottom.php";
\ No newline at end of file
+include_once dirname(__DIR__, 2) . '/templates/bottom_light.php';
\ No newline at end of file
diff --git a/erp24/modul/store/itemmatrix.php b/erp24/modul/store/itemmatrix.php
index d7655662..d387360b 100644
--- a/erp24/modul/store/itemmatrix.php
+++ b/erp24/modul/store/itemmatrix.php
@@ -1,11 +1,14 @@
 <?php
-include_once("startup.php");
-include_once("inc/db.php");
-include_once("inc/base_new.php");
-include_once("inc/design_new.php");
-include_once("inc/uni.php");
+include_once(dirname(__DIR__, 2) . "/startup.php");
+include_once(dirname(__DIR__, 2) . "/inc/db.php");
+include_once(dirname(__DIR__, 2) . "/inc/base_new.php");
+include_once(dirname(__DIR__, 2) . "/inc/design_new.php");
+include_once(dirname(__DIR__, 2) . "/inc/uni.php");
+
+global $id;
+
+$id = 1;
 
-include"templates/top.php";	
 if(!empty($_REQUEST["id"])) $id=(int)$_REQUEST["id"];
 $row=$db::getRow("SELECT name,id FROM city_store WHERE id=?",[$id]);
 $store_id=$id;  
@@ -41,8 +44,7 @@ echo'</tbody></table></div></div>';
 
 
 echo'</div></div>';	
-	
-include"templates/bottom.php";	
-	
+
+
 
 
diff --git a/erp24/views/storage/ajax-balances-in-group.php b/erp24/views/storage/ajax-balances-in-group.php
new file mode 100644
index 00000000..26b42f0d
--- /dev/null
+++ b/erp24/views/storage/ajax-balances-in-group.php
@@ -0,0 +1,5 @@
+<?php
+
+chdir(__DIR__ . '/../../');
+
+include 'modul/storage/ajax_balances_in_group.php';
\ No newline at end of file
diff --git a/erp24/views/storage/index.php b/erp24/views/storage/index.php
new file mode 100644
index 00000000..095d8314
--- /dev/null
+++ b/erp24/views/storage/index.php
@@ -0,0 +1,5 @@
+<?php
+
+chdir(__DIR__ . '/../../');
+
+include 'modul/storage/index.php';
\ No newline at end of file
diff --git a/erp24/views/storage/store.php b/erp24/views/storage/store.php
new file mode 100644
index 00000000..4a1249c8
--- /dev/null
+++ b/erp24/views/storage/store.php
@@ -0,0 +1,5 @@
+<?php
+
+chdir(__DIR__ . '/../../');
+
+include 'modul/storage/store.php';
\ No newline at end of file
diff --git a/erp24/views/store/itemmatrix.php b/erp24/views/store/itemmatrix.php
new file mode 100644
index 00000000..63e5cf87
--- /dev/null
+++ b/erp24/views/store/itemmatrix.php
@@ -0,0 +1,5 @@
+<?php
+
+chdir(__DIR__ . '/../../');
+
+include 'modul/store/itemmatrix.php';
\ No newline at end of file
-- 
2.39.5