Changeset 30378

Timestamp:

Jan 26, 2011, 11:02:45 AM (15 years ago)

Author:

Serge CHASTEL

Message:

Fixed pub id

File:

• trunk/ippMonitor/def/mopsStatus.d (modified) (3 diffs)

trunk/ippMonitor/def/mopsStatus.d

@@ -1 @@
-TABLE rawExp LEFT JOIN chipRun using(exp_id) LEFT JOIN camRun using(chip_id) LEFT JOIN fakeRun using(cam_id) LEFT JOIN warpRun using(fake_id) LEFT JOIN diffInputSkyfile AS diffInput ON diffInput.warp1 = warp_id LEFT JOIN diffRun AS diffInputRun ON diffInput.diff_id = diffInputRun.diff_id LEFT JOIN diffInputSkyfile AS diffTemplate ON diffTemplate.warp2 = warp_id LEFT JOIN diffRun AS diffTemplateRun ON diffTemplate.diff_id = diffTemplateRun.diff_id LEFT JOIN publishRun ON stage_id=diffInput.diff_id AND (client_id=1 OR client_id=5) LEFT JOIN magicDSRun ON magicDSRun.magic_ds_id=camRun.magicked
+TABLE rawExp LEFT JOIN chipRun using(exp_id) LEFT JOIN camRun using(chip_id) LEFT JOIN fakeRun using(cam_id) LEFT JOIN warpRun using(fake_id) LEFT JOIN diffInputSkyfile AS diffInput ON diffInput.warp1 = warp_id LEFT JOIN diffRun AS diffInputRun ON diffInput.diff_id = diffInputRun.diff_id LEFT JOIN diffInputSkyfile AS diffTemplate ON diffTemplate.warp2 = warp_id LEFT JOIN diffRun AS diffTemplateRun ON diffTemplate.diff_id = diffTemplateRun.diff_id LEFT JOIN publishRun ON stage_id=diffInput.diff_id AND (client_id=1 OR client_id=5) LEFT JOIN publishRun AS pubRun2 ON pubRun2.stage_id=diffTemplate.diff_id AND (pubRun2.client_id=1 OR pubRun2.client_id=5) LEFT JOIN magicDSRun ON magicDSRun.magic_ds_id=camRun.magicked
 TITLE MOPS Status
 FILE mopsStatus.php
@@ -10 +10 @@
 OP OP1 ($row[8]>$row[9]?$row[8]. "(1)":($row[9]!=0?$row[9]. "(2)":"0"))
 # $diffInput.diff_id+$diffTemplate.diff_id
-OP OP2 $row[8]+$row[9]
-#  "[".$diffInput.diff_id."]:[".$tdiff_id."]"
+# PUB ID
+OP OP2 ($row[12]>$row[13]?$row[12]. "(I)":($row[13]!=0?$row[13]. "(T)":"0"))
+#($row[13]>$row[14])
 
 #     field                    width format  name          show         link to                   extras
-FIELD dateobs,                 15,   %T,     Date Obs
+FIELD dateobs,                 13,   %T,     Date Obs
 FIELD exp_name,                5,    %s,     Exp Name
 FIELD rawExp.exp_id,           5,    %d,     Exp ID
@@ -25 +26 @@
 FIELD diffTemplate.diff_id AS tdiff_id,    5,    %d,     tdiff_id, none
 FIELD *,                       5,    %s,     Diff ID (Stage 5),         op=OP1
-#FIELD *,                      5,    %d,     Diff ID (Stage 5),         op=OP2
 FIELD camRun.magicked,         5,    %d,     Magick ID (Stage 6)
 FIELD magicDSRun.magic_ds_id,       5,    %d, DestreakID (Stage 7)
-FIELD publishRun.pub_id,       5,    %d,     Pub ID (Stage 8)
+FIELD publishRun.pub_id AS pubId1,       5,    %d,     pubId1, none
+FIELD pubRun2.pub_id AS pubId2,       5,    %d,     pubId2, none
+FIELD *,                        10, %s, Pub ID, op=OP2
 FIELD filter,                  5,    %s,     Filter
 FIELD object,                  15,    %s,     Object
 FIELD comment,                 40,    %s,     Comment
 
-FIELD diffInput.diff_id AS ddiffId,       5,    %s,     ddiffId,        none
-FIELD diffTemplate.diff_id AS tdiffId,    5,    %s,     tdiffId,        none
+#FIELD diffInput.diff_id AS ddiffId,       5,    %s,     ddiffId,       none
+#FIELD diffTemplate.diff_id AS tdiffId,    5,    %s,     tdiffId,       none
 
 MODE summary