Index: /branches/sc_branches/ippMonitorLap/Makefile.in =================================================================== --- /branches/sc_branches/ippMonitorLap/Makefile.in (revision 31759) +++ /branches/sc_branches/ippMonitorLap/Makefile.in (revision 31760) @@ -225,4 +225,5 @@ $(DESTWWW)/lapRuns.php \ $(DESTWWW)/lapExposures.php \ +$(DESTWWW)/lapStacks.php PICTURES = \ Index: /branches/sc_branches/ippMonitorLap/def/lapStacks.d =================================================================== --- /branches/sc_branches/ippMonitorLap/def/lapStacks.d (revision 31760) +++ /branches/sc_branches/ippMonitorLap/def/lapStacks.d (revision 31760) @@ -0,0 +1,42 @@ +TABLE lapRun LEFT JOIN (SELECT DISTINCT lap_id,tess_id,projection_cell,filter,skycell_id, quick_sass_id,quick_data_group,quick_stack_id,quick_state,quick_fault,quick_quality, final_sass_id,final_data_group,final_stack_id,final_state,final_fault,final_quality FROM (select lapRun.lap_id, stackAssociation.sass_id AS quick_sass_id, stackAssociation.data_group AS quick_data_group, stackAssociation.projection_cell, stackAssociation.tess_id, stackAssociation.filter, stackRun.stack_id AS quick_stack_id, stackRun.skycell_id, stackRun.state AS quick_state, stackSumSkyfile.fault AS quick_fault, stackSumSkyfile.quality AS quick_quality FROM lapRun LEFT JOIN stackAssociation ON (lapRun.quick_sass_id = stackAssociation.sass_id) LEFT JOIN stackAssociationMap USING (sass_id) LEFT JOIN stackRun USING(stack_id) LEFT JOIN stackSumSkyfile USING(stack_id) WHERE 1 @WHERE@ AND sass_id = lapRun.quick_sass_id ) AS quick LEFT JOIN (select lapRun.lap_id, stackAssociation.sass_id AS final_sass_id, stackAssociation.data_group AS final_data_group, stackAssociation.projection_cell, stackAssociation.tess_id, stackAssociation.filter, stackRun.stack_id AS final_stack_id, stackRun.skycell_id, stackRun.state AS final_state, stackSumSkyfile.fault AS final_fault, stackSumSkyfile.quality AS final_quality FROM lapRun LEFT JOIN stackAssociation ON (lapRun.final_sass_id = stackAssociation.sass_id) LEFT JOIN stackAssociationMap USING (sass_id) LEFT JOIN stackRun USING(stack_id) LEFT JOIN stackSumSkyfile USING(stack_id) WHERE 1 @WHERE@ AND sass_id = lapRun.final_sass_id ) AS final USING(lap_id,projection_cell,tess_id,filter,skycell_id) UNION SELECT DISTINCT lap_id,tess_id,projection_cell,filter,skycell_id, quick_sass_id,quick_data_group,quick_stack_id,quick_state,quick_fault,quick_quality, final_sass_id,final_data_group,final_stack_id,final_state,final_fault,final_quality FROM (select lapRun.lap_id, stackAssociation.sass_id AS quick_sass_id, stackAssociation.data_group AS quick_data_group, stackAssociation.projection_cell, stackAssociation.tess_id, stackAssociation.filter, stackRun.stack_id AS quick_stack_id, stackRun.skycell_id, stackRun.state AS quick_state, stackSumSkyfile.fault AS quick_fault, stackSumSkyfile.quality AS quick_quality FROM lapRun LEFT JOIN stackAssociation ON (lapRun.quick_sass_id = stackAssociation.sass_id) LEFT JOIN stackAssociationMap USING (sass_id) LEFT JOIN stackRun USING(stack_id) LEFT JOIN stackSumSkyfile USING(stack_id) WHERE 1 @WHERE@ AND sass_id = lapRun.quick_sass_id ) AS quick RIGHT JOIN (select lapRun.lap_id, stackAssociation.sass_id AS final_sass_id, stackAssociation.data_group AS final_data_group, stackAssociation.projection_cell, stackAssociation.tess_id, stackAssociation.filter, stackRun.stack_id AS final_stack_id, stackRun.skycell_id, stackRun.state AS final_state, stackSumSkyfile.fault AS final_fault, stackSumSkyfile.quality AS final_quality FROM lapRun LEFT JOIN stackAssociation ON (lapRun.final_sass_id = stackAssociation.sass_id) LEFT JOIN stackAssociationMap USING (sass_id) LEFT JOIN stackRun USING(stack_id) LEFT JOIN stackSumSkyfile USING(stack_id) WHERE 1 @WHERE@ AND sass_id = lapRun.final_sass_id ) AS final USING(lap_id,projection_cell,tess_id,filter,skycell_id) ) stacks ON (stacks.lap_id = lapRun.lap_id AND stacks.projection_cell = lapRun.projection_cell AND stacks.tess_id = lapRun.tess_id AND stacks.filter = lapRun.filter AND (lapRun.quick_sass_id IS NULL OR lapRun.quick_sass_id = stacks.quick_sass_id) AND (lapRun.final_sass_id IS NULL OR lapRun.final_sass_id = stacks.final_sass_id)) +TITLE LAP Stacks +FILE lapStacks.php +MENU ipp.lap.dat + +UNRESTRICTED WHERE 0=1 + +ARGS ARG1 rawImfile.exp_id=$lapExp.exp_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 +ARGS ARG6 fakeRun.fake_id=$fakeRun1.fake_id +ARGS ARG7 fakeRun.fake_id=$fakeRun2.fake_id +ARGS ARG8 warpRun.warp_id=$warpRun1.warp_id +ARGS ARG9 warpRun.warp_id=$warpRun2.warp_id +ARGS ARG10 diffRun.diff_id=$diffRun.diff_id + +# field size format name show link to extras +FIELD lapRun.seq_id, 6, %d, seq_id +FIELD lapExp.lap_id, 6, %d, lap_id +FIELD lapRun.tess_id, 8, %s, tess_id +FIELD lapRun.projection_cell, 10, %s, ProjCell +FIELD lapRun.filter, 7, %s, Filter +FIELD lapRun.state, 15, %s, State (lapRun) +FIELD lapRun.label, 15, %s, Label +FIELD lapRun.dist_group, 15, %s, Dist Group +FIELD lapRun.registered, 19, %T, Registered +FIELD lapRun.fault, 3, %d, fault +FIELD skycell_id +FIELD lapRun.quick_sass_id, +FIELD quick_data_group, +FIELD quick_stack_id, +FIELD quick_state, +FIELD quick_fault, +FIELD quick_quality, +FIELD lapRun.final_sass_id, +FIELD final_data_group, +FIELD final_stack_id, +FIELD final_state, +FIELD final_fault, +FIELD final_quality