From 68a456ee1c04bd473d4634b2ed6942cdab3ce1d5 Mon Sep 17 00:00:00 2001
From: zhangc <zc@123>
Date: 星期六, 21 十二月 2024 13:54:58 +0800
Subject: [PATCH] 新增银座2楼地图SQL脚本

---
 /dev/null                           |   53 --------------------------
 src/main/resources/四期sql/4.初始化1.txt |   41 ++++++++++----------
 src/main/resources/四期sql/1.初始化1.txt |    2 +
 3 files changed, 22 insertions(+), 74 deletions(-)

diff --git "a/src/main/resources/\345\233\233\346\234\237sql/1.\345\210\235\345\247\213\345\214\2261.txt" "b/src/main/resources/\345\233\233\346\234\237sql/1.\345\210\235\345\247\213\345\214\2261.txt"
new file mode 100644
index 0000000..e914b6e
--- /dev/null
+++ "b/src/main/resources/\345\233\233\346\234\237sql/1.\345\210\235\345\247\213\345\214\2261.txt"
@@ -0,0 +1,2 @@
+-- 鍒濆鍖栦竴銆佷簩銆佷笁妤间竴灞傚簱浣峬ap浣嶇疆
+UPDATE [dbo].[agv_loc_mast] SET map_row1 = row1,map_bay1 = bay1, right_side = 0 WHERE lev1 = 1
diff --git "a/src/main/resources/\345\233\233\346\234\237sql/1.\351\223\266\345\272\2472\346\245\274\345\234\260\345\233\276\346\226\260\345\242\236.sql" "b/src/main/resources/\345\233\233\346\234\237sql/1.\351\223\266\345\272\2472\346\245\274\345\234\260\345\233\276\346\226\260\345\242\236.sql"
deleted file mode 100644
index ce30c27..0000000
--- "a/src/main/resources/\345\233\233\346\234\237sql/1.\351\223\266\345\272\2472\346\245\274\345\234\260\345\233\276\346\226\260\345\242\236.sql"
+++ /dev/null
@@ -1,53 +0,0 @@
-DECLARE @locno VARCHAR(50); -- 澹版槑 locno 瀛楁锛屾寚瀹氶暱搴�
-DECLARE @locsts NVARCHAR(50);
-DECLARE @row1 INT = 27;
-DECLARE @bay1 INT = 19;
-DECLARE @lev1 INT = 1;
-DECLARE @fullplt VARCHAR(1); -- 鍋囪 fullplt 鍙渶瑕佷竴涓瓧绗�
-DECLARE @loctype1 INT = 6;
-DECLARE @ft DATETIME;
-DECLARE @mt DATETIME;
-DECLARE @apt DATETIME;
-DECLARE @et DATETIME;
-DECLARE @stas INT;
-DECLARE @floor INT;
-DECLARE @maprow INT = 21;
-DECLARE @mapbay INT = 19;
-DECLARE @rightside INT = 0;
-DECLARE @plttype INT = 777;
-
-
-
--- 浣跨敤 WHILE 寰幆鏉ユ帶鍒� row1 鐨勮寖鍥�
-WHILE @row1 <= 38
-BEGIN
-	-- 鍦ㄦ瘡娆″惊鐜腑锛屾洿鏂� lev1 鐨勫��
-	SET @bay1 = 19; -- 閲嶇疆 lev1
-	SET @mapbay = 19; -- 閲嶇疆 lev1
-
-	WHILE @bay1 <= 33
-	BEGIN
-		-- 鐢熸垚 locno 鍜屽叾浠栧瓧娈电殑鍊�
-		SET @locno = 'YZ_0' + CAST(@row1 AS VARCHAR(2)) + '_0' + RIGHT('00' + CAST(@bay1 AS VARCHAR(2)), 2) + '_0' + CAST(@lev1 AS VARCHAR(2)) + 'F2';
-		SET @locsts = 'O';
-		SET @fullplt = 'N';
-		SET @ft = GETDATE();
-		SET @mt = GETDATE();
-		SET @apt = GETDATE();
-		SET @et = GETDATE();
-		SET @stas = 0;
-		SET @floor = 2;
-
-		-- 鎻掑叆鏁版嵁
-		INSERT INTO agv_loc_mast (loc_no, plt_type,loc_sts, row1, bay1, lev1, full_plt,loc_type1, first_time, modi_time, appe_time, error_time, status, floor,map_row1,map_bay1,right_side)
-		VALUES (@locno, @plttype, @locsts, @row1, @bay1, @lev1, @fullplt,@loctype1, @ft, @mt, @apt, @et, @stas, @floor,@maprow,@mapbay,@rightside);
-
-		-- 鏇存柊 lev1
-		SET @bay1 = @bay1 + 1;
-		SET @mapbay = @mapbay + 1;
-	END
-
-	-- 鏇存柊 row1
-	SET @row1 = @row1 + 1;
-	SET @maprow = @maprow + 1;
-END
\ No newline at end of file
diff --git "a/src/main/resources/\345\233\233\346\234\237sql/4.\345\210\235\345\247\213\345\214\2261.txt" "b/src/main/resources/\345\233\233\346\234\237sql/4.\345\210\235\345\247\213\345\214\2261.txt"
index b938ee5..0845039 100644
--- "a/src/main/resources/\345\233\233\346\234\237sql/4.\345\210\235\345\247\213\345\214\2261.txt"
+++ "b/src/main/resources/\345\233\233\346\234\237sql/4.\345\210\235\345\247\213\345\214\2261.txt"
@@ -1,43 +1,42 @@
--- 鍒濆鍖栦竴銆佷簩銆佷笁妤间竴灞傚簱浣峬ap浣嶇疆
--- UPDATE [dbo].[agv_loc_mast] SET map_row1 = row1,map_bay1 = bay1, right_side = 0 WHERE lev1 = 1
+
 
 -- 璁剧疆涓�妤间竴灞傚簱浣嶉棿闅�
--- UPDATE [dbo].[agv_loc_mast] SET right_side = 1 WHERE  floor = 1 AND lev1 = 1 AND bay1 IN (1,3,5,7,9,11,13,15,17,19)
+ UPDATE [dbo].[agv_loc_mast] SET right_side = 1 WHERE  floor = 1 AND lev1 = 1 AND bay1 IN (1,3,5,7,9,11,13,15,17,19)
 
 -- 鍒濆鍖栦竴妤间簩灞傚簱浣�
 -- 寮曠敤sql
 
 -- 璁剧疆涓�妤间簩灞傚簱浣嶉棿闅�
--- UPDATE [dbo].[agv_loc_mast] SET right_side = 1 WHERE  floor = 1 AND lev1 = 2 AND row1 IN (29,31,33,35,37,39,41,43,45,47,49,51,53,55,57)
+ UPDATE [dbo].[agv_loc_mast] SET right_side = 1 WHERE  floor = 1 AND lev1 = 2 AND row1 IN (29,31,33,35,37,39,41,43,45,47,49,51,53,55,57)
 
 -- 鍒犻櫎澶氫綑搴撲綅 1
--- DELETE FROM [dbo].[agv_loc_mast] WHERE plt_type = 666 AND row1 > 45 AND bay1 > 9
+ DELETE FROM [dbo].[agv_loc_mast] WHERE plt_type = 666 AND row1 > 45 AND bay1 > 9
 
 -- 鍒犻櫎澶氫綑搴撲綅 2
--- DELETE FROM [dbo].[agv_loc_mast] WHERE plt_type = 666 AND row1 IN(46,50,54,55)  AND bay1 in(4,9)
+DELETE FROM [dbo].[agv_loc_mast] WHERE plt_type = 666 AND row1 IN(46,50,54,55)  AND bay1 in(4,9)
 
 -- 鍒犻櫎澶氫綑搴撲綅 3
--- DELETE FROM [dbo].[agv_loc_mast] WHERE plt_type = 666 AND row1 IN(32,36,37,41)  AND bay1 in(4,9,14)
+ DELETE FROM [dbo].[agv_loc_mast] WHERE plt_type = 666 AND row1 IN(32,36,37,41)  AND bay1 in(4,9,14)
 
 -- 鍒犻櫎澶氫綑搴撲綅 4
--- DELETE FROM [dbo].[agv_loc_mast] WHERE plt_type = 666 AND row1 > 28 AND bay1 = 8
+ DELETE FROM [dbo].[agv_loc_mast] WHERE plt_type = 666 AND row1 > 28 AND bay1 = 8
 
 -- 璁剧疆浜屾ゼ涓�灞傚簱浣嶉棿闅�
--- UPDATE [dbo].[agv_loc_mast] SET right_side = 1 WHERE  floor = 2 AND lev1 = 1 AND row1 IN (2,4,6,7,8,10,12,13,15,17,19,20,22,24,28,30,32,34,36,38)
+ UPDATE [dbo].[agv_loc_mast] SET right_side = 1 WHERE  floor = 2 AND lev1 = 1 AND row1 IN (2,4,6,7,8,10,12,13,15,17,19,20,22,24,28,30,32,34,36,38)
 
 
 	-- 璁剧疆浜屾ゼ涓�灞俶ap浣嶇疆
-	-- DECLARE @startBay1 INT = 21;
-	-- DECLARE @setMapbay1 INT = 33;
-	-- 
-	-- WHILE @startBay1 <= 26
-	-- BEGIN
-	-- 
-	-- 	UPDATE [dbo].[agv_loc_mast] SET map_row1 = @setMapbay1  WHERE  floor = 2 AND lev1 = 1 AND row1 = @startBay1
-	-- 	-- 鏇存柊 lev1
-	-- 	SET @startBay1 = @startBay1 + 1;
-	-- 	SET @setMapbay1 = @setMapbay1 + 1;
-	-- END
+	 DECLARE @startBay1 INT = 21;
+	 DECLARE @setMapbay1 INT = 33;
+
+	 WHILE @startBay1 <= 26
+	 BEGIN
+
+	 	UPDATE [dbo].[agv_loc_mast] SET map_row1 = @setMapbay1  WHERE  floor = 2 AND lev1 = 1 AND row1 = @startBay1
+	 	-- 鏇存柊 lev1
+	 	SET @startBay1 = @startBay1 + 1;
+	 	SET @setMapbay1 = @setMapbay1 + 1;
+	 END
 	
 -- 璁剧疆涓夋ゼ涓�灞傞棿闅�
--- UPDATE [dbo].[agv_loc_mast] SET right_side = 1 WHERE  floor = 3 AND lev1 = 1 AND row1 IN (1,3,5,7,8,9,11,13,14,16,18,20,21,23,25)
\ No newline at end of file
+ UPDATE [dbo].[agv_loc_mast] SET right_side = 1 WHERE  floor = 3 AND lev1 = 1 AND row1 IN (1,3,5,7,8,9,11,13,14,16,18,20,21,23,25)
\ No newline at end of file

--
Gitblit v1.9.1