Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Запросы к ВЛ80Р
- 1_______________TED1CollectorShortcutInTraction (Переброс по коллектору ТЭД1 в тяге)
- workmodeRecupPull = 0 И uivoltage = "не 0" И i1 > 50 И (dpc1 - vf) < 5 И i1 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i1},{dpc1},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i1} AS FLOAT)>50.0 AND (CAST({dpc1} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i1} AS FLOAT)>50.0 AND
- (CAST({dpc1} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i1} AS FLOAT)-lagi1)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i1} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi1
- FROM {table})))
- 2_______________TED2CollectorShortcutInTraction (Переброс по коллектору ТЭД2 в тяге)
- workmodeRecupPull = 0 И uivoltage = "не 0" И i2 > 50 И (dpc2 - vf) < 5 И i2 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i2},{dpc2},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i2} AS FLOAT)>50.0 AND (CAST({dpc2} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i2} AS FLOAT)>50.0 AND
- (CAST({dpc2} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i2} AS FLOAT)-lagi2)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i2} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi2
- FROM {table})))
- 3_______________TED3CollectorShortcutInTraction (Переброс по коллектору ТЭД3 в тяге)
- workmodeRecupPull = 0 И uivoltage = "не 0" И i3 > 50 И (dpc3 - vf) < 5 И i3 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i3},{dpc3},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i3} AS FLOAT)>50.0 AND (CAST({dpc3} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i3} AS FLOAT)>50.0 AND
- (CAST({dpc3} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i3} AS FLOAT)-lagi3)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i3} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi3
- FROM {table})))
- 4_______________TED4CollectorShortcutInTraction (Переброс по коллектору ТЭД4 в тяге)
- workmodeRecupPull = 0 И uivoltage = "не 0" И i4 > 50 И (dpc4 - vf) < 5 И i4 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i4},{dpc4},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i4} AS FLOAT)>50.0 AND (CAST({dpc4} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i4} AS FLOAT)>50.0 AND
- (CAST({dpc4} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i4} AS FLOAT)-lagi4)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i4} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi4
- FROM {table})))
- 5_______________TED5CollectorShortcutInTraction (Переброс по коллектору ТЭД5 в тяге)
- workmodeRecupPull = 0 И uivoltage = "не 0" И i5 > 50 И (dpc5 - vf) < 5 И i5 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i5},{dpc5},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i5} AS FLOAT)>50.0 AND (CAST({dpc5} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i5} AS FLOAT)>50.0 AND
- (CAST({dpc5} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i5} AS FLOAT)-lagi5)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i5} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi5
- FROM {table})))
- 6_______________TED6CollectorShortcutInTraction (Переброс по коллектору ТЭД6 в тяге)
- workmodeRecupPull = 0 И uivoltage = "не 0" И i6 > 50 И (dpc6 - vf) < 5 И i6 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i6},{dpc6},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i6} AS FLOAT)>50.0 AND (CAST({dpc6} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i6} AS FLOAT)>50.0 AND
- (CAST({dpc6} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i6} AS FLOAT)-lagi6)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i6} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi6
- FROM {table})))
- 7_______________TED7CollectorShortcutInTraction (Переброс по коллектору ТЭД7 в тяге)
- workmodeRecupPull = 0 И uivoltage = "не 0" И i7 > 50 И (dpc7 - vf) < 5 И i7 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i7},{dpc7},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i7} AS FLOAT)>50.0 AND (CAST({dpc7} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i7} AS FLOAT)>50.0 AND
- (CAST({dpc7} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i7} AS FLOAT)-lagi7)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i7} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi7
- FROM {table})))
- 8_______________TED8CollectorShortcutInTraction (Переброс по коллектору ТЭД8 в тяге)
- workmodeRecupPull = 0 И uivoltage = "не 0" И i8 > 50 И (dpc8 - vf) < 5 И i8 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i8},{dpc8},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i8} AS FLOAT)>50.0 AND (CAST({dpc8} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i8} AS FLOAT)>50.0 AND
- (CAST({dpc8} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i8} AS FLOAT)-lagi8)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i8} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi8
- FROM {table})))
- 9_______________TED9CollectorShortcutInTraction (Переброс по коллектору ТЭД9 в тяге)
- workmodeRecupPull = 0 И uivoltage = "не 0" И i9 > 50 И (dpc9 - vf) < 5 И i9 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i9},{dpc9},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i9} AS FLOAT)>50.0 AND (CAST({dpc9} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i9} AS FLOAT)>50.0 AND
- (CAST({dpc9} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i9} AS FLOAT)-lagi9)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i9} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi9
- FROM {table})))
- 10_______________TED10CollectorShortcutInTraction (Переброс по коллектору ТЭД10 в тяге)
- workmodeRecupPull = 0 И uivoltage = "не 0" И i10 > 50 И (dpc10 - vf) < 5 И i10 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i10},{dpc10},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i10} AS FLOAT)>50.0 AND (CAST({dpc10} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i10} AS FLOAT)>50.0 AND
- (CAST({dpc10} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i10} AS FLOAT)-lagi10)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i10} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi10
- FROM {table})))
- 11_______________TED11CollectorShortcutInTraction (Переброс по коллектору ТЭД11 в тяге)
- workmodeRecupPull = 0 И uivoltage = "не 0" И i11 > 50 И (dpc11 - vf) < 5 И i11 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i11},{dpc11},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i11} AS FLOAT)>50.0 AND (CAST({dpc11} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i11} AS FLOAT)>50.0 AND
- (CAST({dpc11} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i11} AS FLOAT)-lagi11)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i11} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi11
- FROM {table})))
- 12_______________TED12CollectorShortcutInTraction (Переброс по коллектору ТЭД12 в тяге)
- workmodeRecupPull = 0 И uivoltage = "не 0" И i12 > 50 И (dpc12 - vf) < 5 И i12 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i12},{dpc12},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i12} AS FLOAT)>50.0 AND (CAST({dpc12} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i12} AS FLOAT)>50.0 AND
- (CAST({dpc12} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i12} AS FLOAT)-lagi12)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i12} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi12
- FROM {table})))
- 13_______________VIPShortcutInRecuperationByTED1 (Пробой плеча ВИП в рекуперации по ТЭД1 (Секция 1))
- workmodeRecupPull = 1 И uivoltage = "не 0" И i1 > 50 И (dpc1 - vf) < 5 И i1 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i1},{dpc1},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i1} AS FLOAT)>50.0 AND (CAST({dpc1} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i1} AS FLOAT)>50.0 AND
- (CAST({dpc1} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i1} AS FLOAT)-lagi1)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i1} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi1
- FROM {table})))
- 14_______________VIPShortcutInRecuperationByTED2 (Пробой плеча ВИП в рекуперации по ТЭД2 (Секция 1))
- workmodeRecupPull = 1 И uivoltage = "не 0" И i2 > 50 И (dpc2 - vf) < 5 И i2 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i2},{dpc2},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i2} AS FLOAT)>50.0 AND (CAST({dpc2} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i2} AS FLOAT)>50.0 AND
- (CAST({dpc2} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i2} AS FLOAT)-lagi2)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i2} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi2
- FROM {table})))
- 15_______________VIPShortcutInRecuperationByTED3 (Пробой плеча ВИП в рекуперации по ТЭД3 (Секция 1))
- workmodeRecupPull = 1 И uivoltage = "не 0" И i3 > 50 И (dpc3 - vf) < 5 И i3 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i3},{dpc3},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i3} AS FLOAT)>50.0 AND (CAST({dpc3} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i3} AS FLOAT)>50.0 AND
- (CAST({dpc3} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i3} AS FLOAT)-lagi3)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i3} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi3
- FROM {table})))
- 16_______________VIPShortcutInRecuperationByTED4 (Пробой плеча ВИП в рекуперации по ТЭД4 (Секция 1))
- workmodeRecupPull = 1 И uivoltage = "не 0" И i4 > 50 И (dpc4 - vf) < 5 И i4 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i4},{dpc4},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i4} AS FLOAT)>50.0 AND (CAST({dpc4} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i4} AS FLOAT)>50.0 AND
- (CAST({dpc4} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i4} AS FLOAT)-lagi4)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i4} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi4
- FROM {table})))
- 17_______________VIPShortcutInRecuperationByTED5 (Пробой плеча ВИП в рекуперации по ТЭД5 (Секция 1))
- workmodeRecupPull = 1 И uivoltage = "не 0" И i5 > 50 И (dpc5 - vf) < 5 И i5 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i5},{dpc5},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i5} AS FLOAT)>50.0 AND (CAST({dpc5} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i5} AS FLOAT)>50.0 AND
- (CAST({dpc5} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i5} AS FLOAT)-lagi5)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i5} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi5
- FROM {table})))
- 18_______________VIPShortcutInRecuperationByTED6 (Пробой плеча ВИП в рекуперации по ТЭД6 (Секция 1))
- workmodeRecupPull = 1 И uivoltage = "не 0" И i6 > 50 И (dpc6 - vf) < 5 И i6 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i6},{dpc6},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i6} AS FLOAT)>50.0 AND (CAST({dpc6} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i6} AS FLOAT)>50.0 AND
- (CAST({dpc6} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i6} AS FLOAT)-lagi6)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i6} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi6
- FROM {table})))
- 19_______________VIPShortcutInRecuperationByTED7 (Пробой плеча ВИП в рекуперации по ТЭД7 (Секция 1))
- workmodeRecupPull = 1 И uivoltage = "не 0" И i7 > 50 И (dpc7 - vf) < 5 И i7 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i7},{dpc7},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i7} AS FLOAT)>50.0 AND (CAST({dpc7} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i7} AS FLOAT)>50.0 AND
- (CAST({dpc7} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i7} AS FLOAT)-lagi7)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i7} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi7
- FROM {table})))
- 20_______________VIPShortcutInRecuperationByTED8 (Пробой плеча ВИП в рекуперации по ТЭД8 (Секция 1))
- workmodeRecupPull = 1 И uivoltage = "не 0" И i8 > 50 И (dpc8 - vf) < 5 И i8 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i8},{dpc8},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i8} AS FLOAT)>50.0 AND (CAST({dpc8} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i8} AS FLOAT)>50.0 AND
- (CAST({dpc8} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i8} AS FLOAT)-lagi8)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i8} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi8
- FROM {table})))
- 21_______________VIPShortcutInRecuperationByTED9 (Пробой плеча ВИП в рекуперации по ТЭД9 (Секция 1))
- workmodeRecupPull = 1 И uivoltage = "не 0" И i9 > 50 И (dpc9 - vf) < 5 И i9 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i9},{dpc9},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i9} AS FLOAT)>50.0 AND (CAST({dpc9} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i9} AS FLOAT)>50.0 AND
- (CAST({dpc9} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i9} AS FLOAT)-lagi9)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i9} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi9
- FROM {table})))
- 22_______________VIPShortcutInRecuperationByTED10 (Пробой плеча ВИП в рекуперации по ТЭД10 (Секция 1))
- workmodeRecupPull = 1 И uivoltage = "не 0" И i10 > 50 И (dpc10 - vf) < 5 И i10 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i10},{dpc10},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i10} AS FLOAT)>50.0 AND (CAST({dpc10} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i10} AS FLOAT)>50.0 AND
- (CAST({dpc10} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i10} AS FLOAT)-lagi10)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i10} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi10
- FROM {table})))
- 23_______________VIPShortcutInRecuperationByTED11 (Пробой плеча ВИП в рекуперации по ТЭД11 (Секция 1))
- workmodeRecupPull = 1 И uivoltage = "не 0" И i11 > 50 И (dpc11 - vf) < 5 И i11 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i11},{dpc11},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i11} AS FLOAT)>50.0 AND (CAST({dpc11} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i11} AS FLOAT)>50.0 AND
- (CAST({dpc11} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i11} AS FLOAT)-lagi11)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i11} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi11
- FROM {table})))
- 24_______________VIPShortcutInRecuperationByTED12 (Пробой плеча ВИП в рекуперации по ТЭД12 (Секция 1))
- workmodeRecupPull = 1 И uivoltage = "не 0" И i12 > 50 И (dpc12 - vf) < 5 И i12 озрастает более чем на 150 за 1 секунду
- SELECT {select_fields},{workmodeRecupPull},{uivoltage},{i12},{dpc12},{vf},
- CASE
- WHEN max_params_perform=1.0 AND CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND
- CAST({i12} AS FLOAT)>50.0 AND (CAST({dpc12} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- MAX(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING ) AS max_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)=1.0 AND CAST({uivoltage} AS FLOAT)!=0.0 AND CAST({i12} AS FLOAT)>50.0 AND
- (CAST({dpc12} AS FLOAT)-CAST({vf} AS FLOAT))<5.0 AND (CAST({i12} AS FLOAT)-lagi12)>150.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- LAG(CAST({i12} AS FLOAT)) OVER (ORDER BY {datetime}) AS lagi12
- FROM {table})))
- ----25_______________RecupCurrentDispExcTED1-Sec1 (Превышение допустимого разброса токов ТЭД в рекуперации (по ТЭД1) (секция 1))
- 1. iavr = (i1 + i2 + i3 + i4) / 4
- 2. dpcavr = (dpc1 + dpc2 + dpc3 + dpc4) / 4
- 2. workmodeRecupPull = "не 0" И i1 > 50 И i2 > 50 И i3 > 50 И i4 > 50 И
- dpc1 > 5 И dpc2 > 5 И dpc3 > 5 И dpc4 > 5 И (|dpc1 - dpcavr| / dpc1) < 0,12 И (|iavr - i1| / iavr) > 0,2
- SELECT {select_fields},{workmodeRecupPull},{i1},{i2},{i3},{i4},{dpc1},{dpc2},{dpc3},{dpc4},
- CASE
- WHEN CAST({workmodeRecupPull} AS FLOAT)!=0.0 AND CAST({i1} AS FLOAT)>50.0 AND CAST({i2} AS FLOAT)>50.0 AND
- CAST({i3} AS FLOAT)>50.0 AND CAST({i4} AS FLOAT)>50.0 AND CAST({dpc1} AS FLOAT)>5.0 AND
- CAST({dpc2} AS FLOAT)>5.0 AND CAST({dpc3} AS FLOAT)>5.0 AND CAST({dpc4} AS FLOAT)>5.0 AND
- (ABS(CAST({dpc1} AS FLOAT) - dpcavr) / CAST({dpc1} AS FLOAT)) > 0.12 AND
- (ABS(CAST({i1} AS FLOAT) - iavr) / iavr) > 0.2
- THEN 1
- ELSE 0
- END
- {rule_field}
- FROM (
- SELECT *,
- (CAST({i1} AS FLOAT) + CAST({i2} AS FLOAT) + CAST({i3} AS FLOAT) + CAST({i4} AS FLOAT)) / 4 AS iavr,
- (CAST({dpc1} AS FLOAT) + CAST({dpc2} AS FLOAT) + CAST({dpc3} AS FLOAT) + CAST({dpc4} AS FLOAT)) / 4 AS dpcavr
- FROM {table})
- 49_______________CurrentSensorMeltdownTED1Section1 (Неисправность датчика тока ТЭД1 (секция 1))
- i1 = 0 И dpc1 > 5 И bpros1defendTD1 = 0 И W = "не 0" И uivoltage = "не 0" более 3 секунд
- SELECT {select_fields},{i1},{dpc1},{bpros1defendTD1},{W},{uivoltage},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({i1} AS FLOAT)=0.0 AND CAST({dpc1} AS FLOAT)>5.0 AND CAST({bpros1defendTD1} AS FLOAT)=0.0 AND
- CAST({W} AS FLOAT)!=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM {table})))
- 50_______________CurrentSensorMeltdownTED2Section1 (Неисправность датчика тока ТЭД2 (секция 1))
- i2 = 0 И dpc2 > 5 И bpros1defendTD2 = 0 И W = "не 0" И uivoltage = "не 0" более 3 секунд
- SELECT {select_fields},{i2},{dpc2},{bpros1defendTD2},{W},{uivoltage},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({i2} AS FLOAT)=0.0 AND CAST({dpc2} AS FLOAT)>5.0 AND CAST({bpros1defendTD2} AS FLOAT)=0.0 AND
- CAST({W} AS FLOAT)!=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM {table})))
- 51_______________CurrentSensorMeltdownTED3Section1 (Неисправность датчика тока ТЭД3 (секция 1))
- i3 = 0 И dpc3 > 5 И bpros1defendTD3 = 0 И W = "не 0" И uivoltage = "не 0" более 3 секунд
- SELECT {select_fields},{i3},{dpc3},{bpros1defendTD3},{W},{uivoltage},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({i3} AS FLOAT)=0.0 AND CAST({dpc3} AS FLOAT)>5.0 AND CAST({bpros1defendTD3} AS FLOAT)=0.0 AND
- CAST({W} AS FLOAT)!=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM {table})))
- 52_______________CurrentSensorMeltdownTED4Section1 (Неисправность датчика тока ТЭД4 (секция 1))
- i4 = 0 И dpc4 > 5 И bpros1defendTD4 = 0 И W = "не 0" И uivoltage = "не 0" более 3 секунд
- SELECT {select_fields},{i4},{dpc4},{bpros1defendTD4},{W},{uivoltage},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({i4} AS FLOAT)=0.0 AND CAST({dpc4} AS FLOAT)>5.0 AND CAST({bpros1defendTD4} AS FLOAT)=0.0 AND
- CAST({W} AS FLOAT)!=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM {table})))
- 53_______________CurrentSensorMeltdownTED5Section2 (Неисправность датчика тока ТЭД5 (секция 2))
- i5 = 0 И dpc5 > 5 И bpros1defendTD5 = 0 И W = "не 0" И uivoltage = "не 0" более 3 секунд
- SELECT {select_fields},{i5},{dpc5},{bpros1defendTD5},{W},{uivoltage},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({i5} AS FLOAT)=0.0 AND CAST({dpc5} AS FLOAT)>5.0 AND CAST({bpros1defendTD5} AS FLOAT)=0.0 AND
- CAST({W} AS FLOAT)!=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM {table})))
- 54_______________CurrentSensorMeltdownTED6Section2 (Неисправность датчика тока ТЭД6 (секция 2))
- i6 = 0 И dpc6 > 5 И bpros1defendTD6 = 0 И W = "не 0" И uivoltage = "не 0" более 3 секунд
- SELECT {select_fields},{i6},{dpc6},{bpros1defendTD6},{W},{uivoltage},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({i6} AS FLOAT)=0.0 AND CAST({dpc6} AS FLOAT)>5.0 AND CAST({bpros1defendTD6} AS FLOAT)=0.0 AND
- CAST({W} AS FLOAT)!=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM {table})))
- 55_______________CurrentSensorMeltdownTED7Section2 (Неисправность датчика тока ТЭД7 (секция 2))
- i7 = 0 И dpc7 > 5 И bpros1defendTD7 = 0 И W = "не 0" И uivoltage = "не 0" более 3 секунд
- SELECT {select_fields},{i7},{dpc7},{bpros1defendTD7},{W},{uivoltage},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({i7} AS FLOAT)=0.0 AND CAST({dpc7} AS FLOAT)>5.0 AND CAST({bpros1defendTD7} AS FLOAT)=0.0 AND
- CAST({W} AS FLOAT)!=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM {table})))
- 56_______________CurrentSensorMeltdownTED8Section2 (Неисправность датчика тока ТЭД8 (секция 2))
- i8 = 0 И dpc8 > 5 И bpros1defendTD8 = 0 И W = "не 0" И uivoltage = "не 0" более 3 секунд
- SELECT {select_fields},{i8},{dpc8},{bpros1defendTD8},{W},{uivoltage},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({i8} AS FLOAT)=0.0 AND CAST({dpc8} AS FLOAT)>5.0 AND CAST({bpros1defendTD8} AS FLOAT)=0.0 AND
- CAST({W} AS FLOAT)!=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM {table})))
- 57_______________CurrentSensorMeltdownTED9Section3 (Неисправность датчика тока ТЭД9 (секция 3))
- i9 = 0 И dpc9 > 5 И bpros1defendTD9 = 0 И W = "не 0" И uivoltage = "не 0" более 3 секунд
- SELECT {select_fields},{i9},{dpc9},{bpros1defendTD9},{W},{uivoltage},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({i9} AS FLOAT)=0.0 AND CAST({dpc9} AS FLOAT)>5.0 AND CAST({bpros1defendTD9} AS FLOAT)=0.0 AND
- CAST({W} AS FLOAT)!=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM {table})))
- 58_______________CurrentSensorMeltdownTED10Section3 (Неисправность датчика тока ТЭД10 (секция 3))
- i10 = 0 И dpc10 > 5 И bpros1defendTD10 = 0 И W = "не 0" И uivoltage = "не 0" более 3 секунд
- SELECT {select_fields},{i10},{dpc10},{bpros1defendTD10},{W},{uivoltage},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({i10} AS FLOAT)=0.0 AND CAST({dpc10} AS FLOAT)>5.0 AND CAST({bpros1defendTD10} AS FLOAT)=0.0 AND
- CAST({W} AS FLOAT)!=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM {table})))
- 59_______________CurrentSensorMeltdownTED11Section3 (Неисправность датчика тока ТЭД11 (секция 3))
- i11 = 0 И dpc11 > 5 И bpros1defendTD11 = 0 И W = "не 0" И uivoltage = "не 0" более 3 секунд
- SELECT {select_fields},{i11},{dpc11},{bpros1defendTD11},{W},{uivoltage},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({i11} AS FLOAT)=0.0 AND CAST({dpc11} AS FLOAT)>5.0 AND CAST({bpros1defendTD11} AS FLOAT)=0.0 AND
- CAST({W} AS FLOAT)!=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM {table})))
- 60_______________CurrentSensorMeltdownTED12Section3 (Неисправность датчика тока ТЭД12 (секция 3))
- i12 = 0 И dpc12 > 5 И bpros1defendTD12 = 0 И W = "не 0" И uivoltage = "не 0" более 3 секунд
- SELECT {select_fields},{i12},{dpc12},{bpros1defendTD12},{W},{uivoltage},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({i12} AS FLOAT)=0.0 AND CAST({dpc12} AS FLOAT)>5.0 AND CAST({bpros1defendTD12} AS FLOAT)=0.0 AND
- CAST({W} AS FLOAT)!=0.0 AND CAST({uivoltage} AS FLOAT)!=0.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM {table})))
- 64_______________WP1SpeedSensorFailSection1 (Неисправность датчика скорости КП1 (секция 1))
- 1. dpcavr = (dpc1 + dpc2 + dpc3 + dpc4) / 4
- 2. iavr = (i1 + i2 + i3 + i4) / 4
- 3. bpros1defendTD1 = 0 И bpros1defendTD2 = 0 И bpros1defendTD3 = 0 И bpros1defendTD4 = 0 И bpros1defendVIP61 = 0 И
- bpros1defendVIP62 = 0 И (dpcavr - dpc1) > 2 И (i1 - iavr) < 75 более 3 секунд
- SELECT {select_fields},{dpc1},{dpc2},{dpc3},{dpc4},{i1},{i2},{i3},{i4},{bpros1defendTD1},{bpros1defendTD2},
- {bpros1defendTD3},{bpros1defendTD4},{bpros1defendVIP61},{bpros1defendVIP62},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({bpros1defendTD1} AS FLOAT)=0.0 AND CAST({bpros1defendTD2} AS FLOAT)=0.0 AND CAST({bpros1defendTD3} AS FLOAT)=0.0 AND
- CAST({bpros1defendTD4} AS FLOAT)=0.0 AND CAST({bpros1defendVIP61} AS FLOAT)=0.0 AND CAST({bpros1defendVIP62} AS FLOAT)=0.0 AND
- (dpcavr - CAST({dpc1} AS FLOAT))>2.0 AND (CAST({i1} AS FLOAT)-iavr)<75.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- (CAST({dpc1} AS FLOAT) + CAST({dpc2} AS FLOAT) + CAST({dpc3} AS FLOAT) + CAST({dpc4} AS FLOAT)) / 4 AS dpcavr,
- (CAST({i1} AS FLOAT) + CAST({i2} AS FLOAT) + CAST({i3} AS FLOAT) + CAST({i4} AS FLOAT)) / 4 AS iavr
- FROM {table}))))
- 65_______________WP2SpeedSensorFailSection1 (Неисправность датчика скорости КП2 (секция 1))
- 1. dpcavr = (dpc1 + dpc2 + dpc3 + dpc4) / 4
- 2. iavr = (i1 + i2 + i3 + i4) / 4
- 3. bpros1defendTD1 = 0 И bpros1defendTD2 = 0 И bpros1defendTD3 = 0 И bpros1defendTD4 = 0 И bpros1defendVIP61 = 0 И
- bpros1defendVIP62 = 0 И (dpcavr - dpc2) > 2 И (i2 - iavr) < 75 более 3 секунд
- SELECT {select_fields},{dpc1},{dpc2},{dpc3},{dpc4},{i1},{i2},{i3},{i4},{bpros1defendTD1},{bpros1defendTD2},
- {bpros1defendTD3},{bpros1defendTD4},{bpros1defendVIP61},{bpros1defendVIP62},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({bpros1defendTD1} AS FLOAT)=0.0 AND CAST({bpros1defendTD2} AS FLOAT)=0.0 AND CAST({bpros1defendTD3} AS FLOAT)=0.0 AND
- CAST({bpros1defendTD4} AS FLOAT)=0.0 AND CAST({bpros1defendVIP61} AS FLOAT)=0.0 AND CAST({bpros1defendVIP62} AS FLOAT)=0.0 AND
- (dpcavr - CAST({dpc2} AS FLOAT))>2.0 AND (CAST({i2} AS FLOAT)-iavr)<75.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- (CAST({dpc1} AS FLOAT) + CAST({dpc2} AS FLOAT) + CAST({dpc3} AS FLOAT) + CAST({dpc4} AS FLOAT)) / 4 AS dpcavr,
- (CAST({i1} AS FLOAT) + CAST({i2} AS FLOAT) + CAST({i3} AS FLOAT) + CAST({i4} AS FLOAT)) / 4 AS iavr
- FROM {table}))))
- 66_______________WP3SpeedSensorFailSection1 (Неисправность датчика скорости КП3 (секция 1))
- 1. dpcavr = (dpc1 + dpc2 + dpc3 + dpc4) / 4
- 2. iavr = (i1 + i2 + i3 + i4) / 4
- 3. bpros1defendTD1 = 0 И bpros1defendTD2 = 0 И bpros1defendTD3 = 0 И bpros1defendTD4 = 0 И bpros1defendVIP61 = 0 И
- bpros1defendVIP62 = 0 И (dpcavr - dpc3) > 2 И (i3 - iavr) < 75 более 3 секунд
- SELECT {select_fields},{dpc1},{dpc2},{dpc3},{dpc4},{i1},{i2},{i3},{i4},{bpros1defendTD1},{bpros1defendTD2},
- {bpros1defendTD3},{bpros1defendTD4},{bpros1defendVIP61},{bpros1defendVIP62},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({bpros1defendTD1} AS FLOAT)=0.0 AND CAST({bpros1defendTD2} AS FLOAT)=0.0 AND CAST({bpros1defendTD3} AS FLOAT)=0.0 AND
- CAST({bpros1defendTD4} AS FLOAT)=0.0 AND CAST({bpros1defendVIP61} AS FLOAT)=0.0 AND CAST({bpros1defendVIP62} AS FLOAT)=0.0 AND
- (dpcavr - CAST({dpc3} AS FLOAT))>2.0 AND (CAST({i3} AS FLOAT)-iavr)<75.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- (CAST({dpc1} AS FLOAT) + CAST({dpc2} AS FLOAT) + CAST({dpc3} AS FLOAT) + CAST({dpc4} AS FLOAT)) / 4 AS dpcavr,
- (CAST({i1} AS FLOAT) + CAST({i2} AS FLOAT) + CAST({i3} AS FLOAT) + CAST({i4} AS FLOAT)) / 4 AS iavr
- FROM {table}))))
- 67_______________WP4SpeedSensorFailSection1 (Неисправность датчика скорости КП4 (секция 1))
- 1. dpcavr = (dpc1 + dpc2 + dpc3 + dpc4) / 4
- 2. iavr = (i1 + i2 + i3 + i4) / 4
- 3. bpros1defendTD1 = 0 И bpros1defendTD2 = 0 И bpros1defendTD3 = 0 И bpros1defendTD4 = 0 И bpros1defendVIP61 = 0 И
- bpros1defendVIP62 = 0 И (dpcavr - dpc4) > 2 И (i4 - iavr) < 75 более 3 секунд
- SELECT {select_fields},{dpc1},{dpc2},{dpc3},{dpc4},{i1},{i2},{i3},{i4},{bpros1defendTD1},{bpros1defendTD2},
- {bpros1defendTD3},{bpros1defendTD4},{bpros1defendVIP61},{bpros1defendVIP62},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({bpros1defendTD1} AS FLOAT)=0.0 AND CAST({bpros1defendTD2} AS FLOAT)=0.0 AND CAST({bpros1defendTD3} AS FLOAT)=0.0 AND
- CAST({bpros1defendTD4} AS FLOAT)=0.0 AND CAST({bpros1defendVIP61} AS FLOAT)=0.0 AND CAST({bpros1defendVIP62} AS FLOAT)=0.0 AND
- (dpcavr - CAST({dpc4} AS FLOAT))>2.0 AND (CAST({i4} AS FLOAT)-iavr)<75.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- (CAST({dpc1} AS FLOAT) + CAST({dpc2} AS FLOAT) + CAST({dpc3} AS FLOAT) + CAST({dpc4} AS FLOAT)) / 4 AS dpcavr,
- (CAST({i1} AS FLOAT) + CAST({i2} AS FLOAT) + CAST({i3} AS FLOAT) + CAST({i4} AS FLOAT)) / 4 AS iavr
- FROM {table}))))
- 68_______________WP5SpeedSensorFailSection2 (Неисправность датчика скорости КП5 (секция 2))
- 1. dpcavr = (dpc1 + dpc2 + dpc3 + dpc4) / 4
- 2. iavr = (i1 + i2 + i3 + i4) / 4
- 3. bpros2defendTD1 = 0 И bpros2defendTD2 = 0 И bpros2defendTD3 = 0 И bpros2defendTD4 = 0 И bpros2defendVIP61 = 0 И
- bpros2defendVIP62 = 0 И (dpcavr - dpc1) > 2 И (i1 - iavr) < 75 более 3 секунд
- SELECT {select_fields},{dpc1},{dpc2},{dpc3},{dpc4},{i1},{i2},{i3},{i4},{bpros2defendTD1},{bpros2defendTD2},
- {bpros2defendTD3},{bpros2defendTD4},{bpros2defendVIP61},{bpros2defendVIP62},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({bpros2defendTD1} AS FLOAT)=0.0 AND CAST({bpros2defendTD2} AS FLOAT)=0.0 AND CAST({bpros2defendTD3} AS FLOAT)=0.0 AND
- CAST({bpros2defendTD4} AS FLOAT)=0.0 AND CAST({bpros2defendVIP61} AS FLOAT)=0.0 AND CAST({bpros2defendVIP62} AS FLOAT)=0.0 AND
- (dpcavr - CAST({dpc1} AS FLOAT))>2.0 AND (CAST({i1} AS FLOAT)-iavr)<75.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- (CAST({dpc1} AS FLOAT) + CAST({dpc2} AS FLOAT) + CAST({dpc3} AS FLOAT) + CAST({dpc4} AS FLOAT)) / 4 AS dpcavr,
- (CAST({i1} AS FLOAT) + CAST({i2} AS FLOAT) + CAST({i3} AS FLOAT) + CAST({i4} AS FLOAT)) / 4 AS iavr
- FROM {table}))))
- 69_______________WP6SpeedSensorFailSection2 (Неисправность датчика скорости КП6 (секция 2))
- 1. dpcavr = (dpc1 + dpc2 + dpc3 + dpc4) / 4
- 2. iavr = (i1 + i2 + i3 + i4) / 4
- 3. bpros2defendTD1 = 0 И bpros2defendTD2 = 0 И bpros2defendTD3 = 0 И bpros2defendTD4 = 0 И bpros2defendVIP61 = 0 И
- bpros2defendVIP62 = 0 И (dpcavr - dpc2) > 2 И (i2 - iavr) < 75 более 3 секунд
- SELECT {select_fields},{dpc1},{dpc2},{dpc3},{dpc4},{i1},{i2},{i3},{i4},{bpros2defendTD1},{bpros2defendTD2},
- {bpros2defendTD3},{bpros2defendTD4},{bpros2defendVIP61},{bpros2defendVIP62},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({bpros2defendTD1} AS FLOAT)=0.0 AND CAST({bpros2defendTD2} AS FLOAT)=0.0 AND CAST({bpros2defendTD3} AS FLOAT)=0.0 AND
- CAST({bpros2defendTD4} AS FLOAT)=0.0 AND CAST({bpros2defendVIP61} AS FLOAT)=0.0 AND CAST({bpros2defendVIP62} AS FLOAT)=0.0 AND
- (dpcavr - CAST({dpc2} AS FLOAT))>2.0 AND (CAST({i2} AS FLOAT)-iavr)<75.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- (CAST({dpc1} AS FLOAT) + CAST({dpc2} AS FLOAT) + CAST({dpc3} AS FLOAT) + CAST({dpc4} AS FLOAT)) / 4 AS dpcavr,
- (CAST({i1} AS FLOAT) + CAST({i2} AS FLOAT) + CAST({i3} AS FLOAT) + CAST({i4} AS FLOAT)) / 4 AS iavr
- FROM {table}))))
- 70_______________WP7SpeedSensorFailSection2 (Неисправность датчика скорости КП7 (секция 2))
- 1. dpcavr = (dpc1 + dpc2 + dpc3 + dpc4) / 4
- 2. iavr = (i1 + i2 + i3 + i4) / 4
- 3. bpros2defendTD1 = 0 И bpros2defendTD2 = 0 И bpros2defendTD3 = 0 И bpros2defendTD4 = 0 И bpros2defendVIP61 = 0 И
- bpros2defendVIP62 = 0 И (dpcavr - dpc3) > 2 И (i3 - iavr) < 75 более 3 секунд
- SELECT {select_fields},{dpc1},{dpc2},{dpc3},{dpc4},{i1},{i2},{i3},{i4},{bpros2defendTD1},{bpros2defendTD2},
- {bpros2defendTD3},{bpros2defendTD4},{bpros2defendVIP61},{bpros2defendVIP62},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({bpros2defendTD1} AS FLOAT)=0.0 AND CAST({bpros2defendTD2} AS FLOAT)=0.0 AND CAST({bpros2defendTD3} AS FLOAT)=0.0 AND
- CAST({bpros2defendTD4} AS FLOAT)=0.0 AND CAST({bpros2defendVIP61} AS FLOAT)=0.0 AND CAST({bpros2defendVIP62} AS FLOAT)=0.0 AND
- (dpcavr - CAST({dpc3} AS FLOAT))>2.0 AND (CAST({i3} AS FLOAT)-iavr)<75.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- (CAST({dpc1} AS FLOAT) + CAST({dpc2} AS FLOAT) + CAST({dpc3} AS FLOAT) + CAST({dpc4} AS FLOAT)) / 4 AS dpcavr,
- (CAST({i1} AS FLOAT) + CAST({i2} AS FLOAT) + CAST({i3} AS FLOAT) + CAST({i4} AS FLOAT)) / 4 AS iavr
- FROM {table}))))
- 71_______________WP8SpeedSensorFailSection2 (Неисправность датчика скорости КП8 (секция 2))
- 1. dpcavr = (dpc1 + dpc2 + dpc3 + dpc4) / 4
- 2. iavr = (i1 + i2 + i3 + i4) / 4
- 3. bpros2defendTD1 = 0 И bpros2defendTD2 = 0 И bpros2defendTD3 = 0 И bpros2defendTD4 = 0 И bpros2defendVIP61 = 0 И
- bpros2defendVIP62 = 0 И (dpcavr - dpc4) > 2 И (i4 - iavr) < 75 более 3 секунд
- SELECT {select_fields},{dpc1},{dpc2},{dpc3},{dpc4},{i1},{i2},{i3},{i4},{bpros2defendTD1},{bpros2defendTD2},
- {bpros2defendTD3},{bpros2defendTD4},{bpros2defendVIP61},{bpros2defendVIP62},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({bpros2defendTD1} AS FLOAT)=0.0 AND CAST({bpros2defendTD2} AS FLOAT)=0.0 AND CAST({bpros2defendTD3} AS FLOAT)=0.0 AND
- CAST({bpros2defendTD4} AS FLOAT)=0.0 AND CAST({bpros2defendVIP61} AS FLOAT)=0.0 AND CAST({bpros2defendVIP62} AS FLOAT)=0.0 AND
- (dpcavr - CAST({dpc4} AS FLOAT))>2.0 AND (CAST({i4} AS FLOAT)-iavr)<75.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- (CAST({dpc1} AS FLOAT) + CAST({dpc2} AS FLOAT) + CAST({dpc3} AS FLOAT) + CAST({dpc4} AS FLOAT)) / 4 AS dpcavr,
- (CAST({i1} AS FLOAT) + CAST({i2} AS FLOAT) + CAST({i3} AS FLOAT) + CAST({i4} AS FLOAT)) / 4 AS iavr
- FROM {table}))))
- 72_______________WP9SpeedSensorFailSection3 (Неисправность датчика скорости КП9 (секция 3))
- 1. dpcavr = (dpc1 + dpc2 + dpc3 + dpc4) / 4
- 2. iavr = (i1 + i2 + i3 + i4) / 4
- 3. bpros3defendTD1 = 0 И bpros3defendTD2 = 0 И bpros3defendTD3 = 0 И bpros3defendTD4 = 0 И bpros3defendVIP61 = 0 И
- bpros3defendVIP62 = 0 И (dpcavr - dpc1) > 2 И (i1 - iavr) < 75 более 3 секунд
- SELECT {select_fields},{dpc1},{dpc2},{dpc3},{dpc4},{i1},{i2},{i3},{i4},{bpros3defendTD1},{bpros3defendTD2},
- {bpros3defendTD3},{bpros3defendTD4},{bpros3defendVIP61},{bpros3defendVIP62},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({bpros3defendTD1} AS FLOAT)=0.0 AND CAST({bpros3defendTD2} AS FLOAT)=0.0 AND CAST({bpros3defendTD3} AS FLOAT)=0.0 AND
- CAST({bpros3defendTD4} AS FLOAT)=0.0 AND CAST({bpros3defendVIP61} AS FLOAT)=0.0 AND CAST({bpros3defendVIP62} AS FLOAT)=0.0 AND
- (dpcavr - CAST({dpc1} AS FLOAT))>2.0 AND (CAST({i1} AS FLOAT)-iavr)<75.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- (CAST({dpc1} AS FLOAT) + CAST({dpc2} AS FLOAT) + CAST({dpc3} AS FLOAT) + CAST({dpc4} AS FLOAT)) / 4 AS dpcavr,
- (CAST({i1} AS FLOAT) + CAST({i2} AS FLOAT) + CAST({i3} AS FLOAT) + CAST({i4} AS FLOAT)) / 4 AS iavr
- FROM {table}))))
- 73_______________WP10SpeedSensorFailSection3 (Неисправность датчика скорости КП10 (секция 3))
- 1. dpcavr = (dpc1 + dpc2 + dpc3 + dpc4) / 4
- 2. iavr = (i1 + i2 + i3 + i4) / 4
- 3. bpros3defendTD1 = 0 И bpros3defendTD2 = 0 И bpros3defendTD3 = 0 И bpros3defendTD4 = 0 И bpros3defendVIP61 = 0 И
- bpros3defendVIP62 = 0 И (dpcavr - dpc2) > 2 И (i2 - iavr) < 75 более 3 секунд
- SELECT {select_fields},{dpc1},{dpc2},{dpc3},{dpc4},{i1},{i2},{i3},{i4},{bpros3defendTD1},{bpros3defendTD2},
- {bpros3defendTD3},{bpros3defendTD4},{bpros3defendVIP61},{bpros3defendVIP62},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({bpros3defendTD1} AS FLOAT)=0.0 AND CAST({bpros3defendTD2} AS FLOAT)=0.0 AND CAST({bpros3defendTD3} AS FLOAT)=0.0 AND
- CAST({bpros3defendTD4} AS FLOAT)=0.0 AND CAST({bpros3defendVIP61} AS FLOAT)=0.0 AND CAST({bpros3defendVIP62} AS FLOAT)=0.0 AND
- (dpcavr - CAST({dpc2} AS FLOAT))>2.0 AND (CAST({i2} AS FLOAT)-iavr)<75.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- (CAST({dpc1} AS FLOAT) + CAST({dpc2} AS FLOAT) + CAST({dpc3} AS FLOAT) + CAST({dpc4} AS FLOAT)) / 4 AS dpcavr,
- (CAST({i1} AS FLOAT) + CAST({i2} AS FLOAT) + CAST({i3} AS FLOAT) + CAST({i4} AS FLOAT)) / 4 AS iavr
- FROM {table}))))
- 74_______________WP11SpeedSensorFailSection3 (Неисправность датчика скорости КП11 (секция 3))
- 1. dpcavr = (dpc1 + dpc2 + dpc3 + dpc4) / 4
- 2. iavr = (i1 + i2 + i3 + i4) / 4
- 3. bpros3defendTD1 = 0 И bpros3defendTD2 = 0 И bpros3defendTD3 = 0 И bpros3defendTD4 = 0 И bpros3defendVIP61 = 0 И
- bpros3defendVIP62 = 0 И (dpcavr - dpc3) > 2 И (i3 - iavr) < 75 более 3 секунд
- SELECT {select_fields},{dpc1},{dpc2},{dpc3},{dpc4},{i1},{i2},{i3},{i4},{bpros3defendTD1},{bpros3defendTD2},
- {bpros3defendTD3},{bpros3defendTD4},{bpros3defendVIP61},{bpros3defendVIP62},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({bpros3defendTD1} AS FLOAT)=0.0 AND CAST({bpros3defendTD2} AS FLOAT)=0.0 AND CAST({bpros3defendTD3} AS FLOAT)=0.0 AND
- CAST({bpros3defendTD4} AS FLOAT)=0.0 AND CAST({bpros3defendVIP61} AS FLOAT)=0.0 AND CAST({bpros3defendVIP62} AS FLOAT)=0.0 AND
- (dpcavr - CAST({dpc3} AS FLOAT))>2.0 AND (CAST({i3} AS FLOAT)-iavr)<75.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- (CAST({dpc1} AS FLOAT) + CAST({dpc2} AS FLOAT) + CAST({dpc3} AS FLOAT) + CAST({dpc4} AS FLOAT)) / 4 AS dpcavr,
- (CAST({i1} AS FLOAT) + CAST({i2} AS FLOAT) + CAST({i3} AS FLOAT) + CAST({i4} AS FLOAT)) / 4 AS iavr
- FROM {table}))))
- 75_______________WP12SpeedSensorFailSection3 (Неисправность датчика скорости КП12 (секция 3))
- 1. dpcavr = (dpc1 + dpc2 + dpc3 + dpc4) / 4
- 2. iavr = (i1 + i2 + i3 + i4) / 4
- 3. bpros3defendTD1 = 0 И bpros3defendTD2 = 0 И bpros3defendTD3 = 0 И bpros3defendTD4 = 0 И bpros3defendVIP61 = 0 И
- bpros3defendVIP62 = 0 И (dpcavr - dpc4) > 2 И (i4 - iavr) < 75 более 3 секунд
- SELECT {select_fields},{dpc1},{dpc2},{dpc3},{dpc4},{i1},{i2},{i3},{i4},{bpros3defendTD1},{bpros3defendTD2},
- {bpros3defendTD3},{bpros3defendTD4},{bpros3defendVIP61},{bpros3defendVIP62},
- MAX(rule) OVER (ORDER BY {datetime} ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) AS {rule_field}
- FROM (
- SELECT *,
- CASE
- WHEN sum_params_perform=4.0 THEN 1
- ELSE 0
- END
- rule
- FROM (
- SELECT *,
- SUM(params_perform) OVER (ORDER BY {datetime} ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS sum_params_perform
- FROM (
- SELECT *,
- CASE
- WHEN CAST({bpros3defendTD1} AS FLOAT)=0.0 AND CAST({bpros3defendTD2} AS FLOAT)=0.0 AND CAST({bpros3defendTD3} AS FLOAT)=0.0 AND
- CAST({bpros3defendTD4} AS FLOAT)=0.0 AND CAST({bpros3defendVIP61} AS FLOAT)=0.0 AND CAST({bpros3defendVIP62} AS FLOAT)=0.0 AND
- (dpcavr - CAST({dpc4} AS FLOAT))>2.0 AND (CAST({i4} AS FLOAT)-iavr)<75.0 THEN 1.0
- ELSE 0.0
- END
- params_perform
- FROM (
- SELECT *,
- (CAST({dpc1} AS FLOAT) + CAST({dpc2} AS FLOAT) + CAST({dpc3} AS FLOAT) + CAST({dpc4} AS FLOAT)) / 4 AS dpcavr,
- (CAST({i1} AS FLOAT) + CAST({i2} AS FLOAT) + CAST({i3} AS FLOAT) + CAST({i4} AS FLOAT)) / 4 AS iavr
- FROM {table}))))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement