Opened 17 months ago
Closed 17 months ago
#1185 closed дефект (fixed)
Необходимо создать процедуру в MYSQL для работы ревизии 277
Reported by: | Denis_N | Owned by: | san |
---|---|---|---|
Priority: | major | Component: | БД изделий АДС |
Keywords: | Cc: |
Description
Удаление процедуры "без вывода строк ОТК" и создание процедуры "без вывод строк ОТК и строк Запись"
drop procedure mismatchQueryWithoutOtkRows; DELIMITER } CREATE PROCEDURE mismatchQueryWithoutOtkAndRecordRows(min int, max int, searchName varchar (100), searchSerial varchar (100), searchComment varchar (10000)) READS SQL DATA BEGIN set @prevtotal := 0; set @mintotal := 0; select * from (select *, @mintotal as mintotal, @prevtotal := @mintotal - total as prevtotal from (select products.serial, history.uid, history.date, hist1.total from history inner join (select uid, count(uid) as total from history where (type_write = "mismatch" or type_write = "repair" or (type_write = "testing" and status = "fail")) and comment is not null and comment != '' group by uid) as hist1 on history.uid = hist1.uid inner join products on products.uid = history.uid where (products.name like searchName and products.serial like searchSerial and history.comment like searchComment) and (history.uid, history.date) in (select uid, max(date) from history where (type_write = "mismatch" or type_write = "repair" or (type_write = "testing" and status = "fail")) and history.comment like searchComment and comment is not null and comment != '' group by uid) group by products.serial, history.uid, history.date, hist1.total order by history.date desc) as hist2 where (@mintotal := @minTotal + total)) as hust2 where hust2.mintotal > min and hust2.prevtotal < max; END} DELIMITER ;
Change History (4)
comment:1 by , 17 months ago
Component: | Разное и всякое → БД изделий АДС |
---|---|
Priority: | minor → major |
comment:2 by , 17 months ago
comment:3 by , 17 months ago
Summary: | Необходимо создать процедуру в MYSQL для работы ревизии → Необходимо создать процедуру в MYSQL для работы ревизии 277 |
---|
Note:
See TracTickets
for help on using tickets.
In 277/base: