Changeset 31747 for branches/sc_branches/ippMonitorLap/def/lapExposures.d

Timestamp:

Jun 28, 2011, 4:57:49 PM (15 years ago)

Author:

Serge CHASTEL

Message:

Updating with CZW req

File:

• branches/sc_branches/ippMonitorLap/def/lapExposures.d (modified) (3 diffs)

branches/sc_branches/ippMonitorLap/def/lapExposures.d

@@ -1 @@
-TABLE lapRun JOIN lapExp USING(lap_id) JOIN rawExp USING(exp_id,filter) JOIN chipRun AS chipRun1 USING(chip_id) JOIN camRun AS camRun1 ON camRun1.chip_id=chipRun1.chip_id JOIN chipRun AS chipRun2 ON chipRun2.chip_id=lapExp.pair_id 
+TABLE lapRun JOIN lapExp USING(lap_id) JOIN rawExp USING(exp_id,filter) JOIN chipRun AS chipRun1 USING(chip_id) JOIN camRun AS camRun1 ON camRun1.chip_id=chipRun1.chip_id JOIN chipRun AS chipRun2 ON chipRun2.chip_id=lapExp.pair_id JOIN camRun AS camRun2 ON camRun2.chip_id=chipRun2.chip_id
 TITLE LAP Exposures
 FILE  lapExposures.php
@@ -5 +5 @@
 
 ARGS  ARG1      rawImfile.exp_id=$lapExp.exp_id
-ARGS  ARG2      chipRun1.chip_id=$lapExp.chip_id
-ARGS  ARG3      chipRun2.chip_id=$lapExp.pair_id
+ARGS  ARG2      chipRun.chip_id=$lapExp.chip_id
+ARGS  ARG3      chipRun.chip_id=$lapExp.pair_id
+ARGS  ARG4      camRun.cam_id=$camRun1.cam_id
+ARGS  ARG5      camRun.cam_id=$camRun2.cam_id
 
 #     field                   size  format  name         show    link to                  extras
@@ -13 +15 @@
 FIELD lapExp.data_state,      6, %s,     State (lapExp)
 FIELD lapExp.exp_id,          6, %d,     Exp ID,        value, rawImfile.php, ARG1
-FIELD lapExp.chip_id,         6, %d,     Chip ID,       value, chipStageExp.php, ARG2
-FIELD chipRun1.state,          6, %s,    State (chip_id)
-FIELD camRun1.cam_id,         6, %d,     Cam ID,        value, camStageExp.php, ARG4
-FIELD camRun1.state,          6, %s,    State (cam_id)
-FIELD lapExp.pair_id,         6, %d,     Pair ID,       value, chipStageExp.php, ARG3
-FIELD chipRun2.state,          6, %s,     State (pair_id)
+FIELD lapExp.chip_id,         6, %d,     Chip1 (lapExp.chip_id),        value, chipStageExp.php, ARG2
+FIELD chipRun1.state,          6, %s,    Chip1 State
+FIELD camRun1.cam_id,         6, %d,     Cam1 ID,       value, camStageExp.php, ARG4
+FIELD camRun1.state,          6, %s,     Cam1 State
+FIELD lapExp.pair_id,         6, %d,     Chip2 ID (lapExp.chip_id),     value, chipStageExp.php, ARG3
+FIELD chipRun2.state,          6, %s,    Chip2 State (pair_id)
+FIELD camRun2.cam_id,         6, %d,     Cam2 ID,       value, camStageExp.php, ARG5
+FIELD camRun2.state,          6, %s,     Cam2 State
 FIELD lapRun.tess_id,         8, %s,     tess_id
 FIELD lapRun.projection_cell, 10, %s,    ProjCell