Custom Query (1135 matches)
Results (64 - 66 of 1135)
Ticket | Resolution | Summary | Owner | Reporter |
---|---|---|---|---|
#1169 | не будем делать | Нужно изменить обе процедуры для и-а "Несоответствия" | ||
Description |
Нужно изменить обе процедуры для и-а "Несоответствия" для того, чтобы выводились записи с типом записи "record" по тикету #1158 1-ая drop procedure mismatchQuery; DELIMITER } CREATE PROCEDURE mismatchQuery(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 = 'record' or type_write = "repair" or (type_write = "otk" and status = "fail") or (type_write = "testing" and status = "fail")) and comment is not null 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 = 'record' or type_write = "repair" or (type_write = "otk" and status = "fail") or (type_write = "testing" and status = "fail" )) and comment is not null 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 ; 2-ая drop procedure mismatchQueryWithoutOtkRows; DELIMITER }
CREATE PROCEDURE mismatchQueryWithoutOtkRows(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 = 'record' or type_write = "repair" or (type_write = "testing" and status = "fail")) and comment is not null 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 = 'record' or type_write = "repair" or (type_write = "testing" and status = "fail") or DELIMITER ; |
|||
#1168 | не будем делать | Необходимо создать процедуру в MYSQL для работы ревизии 229 | ||
Description |
Эта процедура нужна для правильного отображения строк, когда нажат фильтр в и-е "Несоответствия", который скрывает записи с "ОТК". Без этой процедуры фильтр работает неправильно DELIMITER } CREATE PROCEDURE mismatchQueryWithoutOtkRows(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 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 = "otk" and status = "fail") or (type_write = "testing" and status = "fail")) and comment is not null 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 ; |
|||
#1167 | готово | РЭ: Нет указания о необходимости подключения второй антенны | ||
Description |
В РЭ аппаратуры MC04-WL редакции 2 в п. 1.5 на странице 4 написано: "На обоих устройствах подключить основную антенну к разъему MAIN antenna", так как устройство поставляется с неподключенными антеннами. Однако в РЭ нет аналогичного указания о подключении второй антенны, хотя их в устройстве две. Предполагаю, что такое указание отсутствует по ошибке. Отсутствие указания о подключении второй антенны приведет к тому, что пользователь, в точности выполняющий указания РЭ, подключит только одну антенну, а вторую оставит неподключенной. Хотя устройство может работать и без второй антенны (только с одной), качество его работы в такой конфигурации будет ниже. Предлагаю добавить в текст РЭ указание о необходимости подключить вторую антенну (при ее наличии). |