Changeset 28668

Timestamp:

Jul 13, 2010, 3:44:33 PM (16 years ago)

Author:

Serge CHASTEL

Message:

Improved query

File:

• trunk/ippMonitor/def/stackSummary_Images.d (modified) (2 diffs)

trunk/ippMonitor/def/stackSummary_Images.d

@@ -1 @@
-TABLE stackRun, stackSumSkyfile, stackAssociationMap, stackSummary
-TITLE Stack Summary Summary w/ Images
+TABLE stackAssociation, stackSummary
+TITLE Stack Summary w/ Images
 FILE  stackSummary_Images.php
 MENU  ipp.stack.dat
 
-WHERE stackRun.stack_id = stackSumSkyfile.stack_id
-WHERE stackRun.state = 'full'
-WHERE stackSumSkyfile.fault = 0
-
 # TODO
-WHERE stackSummary.sass_id = stackAssociationMap.sass_id
-WHERE stackAssociationMap.stack_id = stackRun.stack_id
+WHERE stackSummary.sass_id = stackAssociation.sass_id
 
 # define image names to be used below
@@ -22 +17 @@
 
 #        field                   size  format  name           show     link to         extras
-FIELD stackRun.stack_id,            5, %s,     Stack ID
-FIELD stackRun.skycell_id,          5, %s,     Skycell ID
-FIELD stackRun.label,               5, %s,     Label
-FIELD stackRun.data_group,          5, %s,     data grp
-FIELD stackRun.dist_group,          5, %s,     dist grp
-FIELD *,                            8, %s,     image,   image=JPEG2, getimage.php, ARG7
-FIELD stackRun.filter,              5, %s,     Filter
-FIELD stackRun.tess_id,             5, %s,     Tess ID
-FIELD stackRun.state,               7, %s,     State
-FIELD stackSumSkyfile.bg,           5, %.2f,   backgnd
-FIELD stackSumSkyfile.bg_stdev,     5, %.2f,   stdev    
-FIELD stackSumSkyfile.dtime_stack,  5, %.2f,   t(stack)
-FIELD stackSumSkyfile.dtime_match_mean, 5, %.2f, t(match)
-FIELD stackSumSkyfile.dtime_initial, 5, %.2f,   t(initial)
-FIELD stackSumSkyfile.dtime_reject,  5, %.2f,   t(reject)
-FIELD stackSumSkyfile.dtime_final,   5, %.2f,   t(final)
-FIELD stackSumSkyfile.dtime_phot,    5, %.2f,   t(phot)
-FIELD stackSumSkyfile.dtime_script,  5, %.2f,   t(script)
+FIELD stackSummary.sass_id,         5, %s,     SASS ID
+FIELD stackAssociation.data_group,  5, %s,     data grp
+FIELD stackAssociation.tess_id,     5, %s,     Tess ID
+FIELD stackAssociation.filter,      5, %s,     Filter
+FIELD *,                            8, %s,     image,          image=JPEG2, getimage.php, ARG7
+FIELD stackSummary.path_base,       5, %s,     path_base,      none
+FIELD stackSummary.projection_cell, 5, %s,     projection_cell, none
+FIELD stackAssociation.sass_id,     5, %s,     sAMsai,         none
 
-FIELD stackSumSkyfile.match_mean,    5, %.2f,   match
-FIELD stackSumSkyfile.match_stdev,   5, %.2f,   match err
-
-FIELD stackSumSkyfile.reject_images, 5, %d,   n(reject)
-FIELD stackSumSkyfile.sources,       5, %d,   n(sources)
-
-FIELD stackSummary.path_base,    5, %s,     path_base,     none
-FIELD stackSummary.projection_cell,    5, %s,     projection_cell,     none
-
-FIELD stackAssociationMap.sass_id,    5, %s,  sAMsai   ,     none
-FIELD stackAssociationMap.stack_id,    5, %s,  sAMsti   ,     none
-
-TAIL PHP insert_image ('PPSTACK.OUTPUT.JPEG1', 'width=90%');
+# TAIL PHP insert_image ('PPSTACK.OUTPUT.JPEG1', 'width=90%');
 TAIL PHP insert_log ('LOG.EXP');