IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 34306


Ignore:
Timestamp:
Aug 14, 2012, 12:14:44 PM (14 years ago)
Author:
Serge CHASTEL
Message:

Removed magic/destreak information

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippMonitor/def/mopsStatus.d

    r34305 r34306  
    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 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
     1TABLE 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)
    22TITLE MOPS Status
    33FILE mopsStatus.php
    … …  
    1313# $diffInput.diff_id+$diffTemplate.diff_id
    1414# PUB ID
    15 OP OP2 ($row[12]>$row[13]?$row[12]. "(I)":($row[13]!=0?$row[13]. "(T)":"0"))
    16 #($row[13]>$row[14])
     15OP OP2 ($row[10]>$row[11]?$row[10]. "(I)":($row[11]!=0?$row[11]. "(T)":"0"))
     16#($row[11]>$row[12])
    1717
    1818#     field                    width format  name          show         link to                   extras
    … …  
    2121FIELD rawExp.exp_id,           5,    %d,     Exp ID
    2222FIELD chipRun.data_group,      5,    %s,     Data grp
    23 FIELD chip_id,                 5,    %d,     Chip ID (Stage 1)
    24 FIELD camRun.cam_id AS camID,                  5,    %d,     Cam ID (Stage 2)
    25 FIELD fake_id,                 5,    %d,     Fake ID (Stage 3)
    26 FIELD warp_id,                 5,    %d,     Warp ID (Stage 4)
     23FIELD chip_id,                 5,    %d,     Chip ID (1/6)
     24FIELD camRun.cam_id AS camID,                  5,    %d,     Cam ID (2/6)
     25FIELD fake_id,                 5,    %d,     Fake ID (3/6)
     26FIELD warp_id,                 5,    %d,     Warp ID (4/6)
    2727FIELD diffInput.diff_id AS ddiff_id,       5,    %d,     ddiff_id, none
    2828FIELD diffTemplate.diff_id AS tdiff_id,    5,    %d,     tdiff_id, none
    29 FIELD *,                       5,    %s,     Diff ID (Stage 5),         op=OP1
    30 FIELD camRun.magicked,         5,    %d,     Magick ID (Stage 6)
    31 FIELD magicDSRun.magic_ds_id,       5,    %d, DestreakID (Stage 7)
     29FIELD *,                       5,    %s,     Diff ID (5/6),             op=OP1
    3230FIELD publishRun.pub_id AS pubId1,       5,    %d,     pubId1, none
    3331FIELD pubRun2.pub_id AS pubId2,       5,    %d,     pubId2, none
    34 FIELD *,                        10, %s, Pub ID, op=OP2
     32FIELD *,                        10, %s, Pub ID (6/6), op=OP2
    3533FIELD filter,                  5,    %s,     Filter
    3634FIELD object,                  15,    %s,     Object
Note: See TracChangeset for help on using the changeset viewer.