Index: branches/czw_branch/20101203/ippTools/share/Makefile.am
===================================================================
--- branches/czw_branch/20101203/ippTools/share/Makefile.am	(revision 29907)
+++ branches/czw_branch/20101203/ippTools/share/Makefile.am	(revision 29908)
@@ -316,4 +316,5 @@
 	receivetool_revert.sql \
 	receivetool_toadvance.sql \
+	regtool_checkburntoolimfile.sql \
 	regtool_create_dup_table.sql \
 	regtool_export_exp.sql \
@@ -331,4 +332,5 @@
 	regtool_updatebyquery.sql \
 	regtool_updatebyqueryimfile.sql \
+	regtool_pendingburntoolimfile.sql \
 	stacktool_associationdefine_select.sql \
 	stacktool_definebyquery_insert.sql \
Index: branches/czw_branch/20101203/ippTools/share/regtool_checkburntoolimfile.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/regtool_checkburntoolimfile.sql	(revision 29908)
+++ branches/czw_branch/20101203/ippTools/share/regtool_checkburntoolimfile.sql	(revision 29908)
@@ -0,0 +1,31 @@
+SELECT DISTINCT
+       exp_name,
+       rawImfile.uri,
+       summitExp.dateobs AS registered,
+       summitExp.imfiles,
+       summitExp.fault AS summit_fault,
+       pzDownloadExp.state AS download_state,
+       newExp.state AS newExp_state,
+       rawExp.state AS rawExp_state,
+       rawImfile.data_state AS imfile_state,
+       newExp.exp_id,
+       summitExp.exp_type,
+       rawExp.dateobs,
+       rawExp.obs_mode AS obs_mode,
+       rawExp.object AS object,
+       rawImfile.burntool_state AS burntool_state,
+       rawImfile.class_id,
+       (pzDownloadExp.state = 'stop') AS is_downloaded,
+       (rawImfile.burntool_state IS NOT NULL) AS is_registered
+       FROM
+            summitExp
+            LEFT JOIN pzDownloadExp USING(exp_name)
+            LEFT JOIN newExp ON exp_name = tmp_exp_name
+            LEFT JOIN rawExp USING(exp_id, exp_name)
+            LEFT JOIN rawImfile USING(exp_name)
+       WHERE
+             summitExp.dateobs >= '@DATE@T00:00:00'
+	     AND summitExp.dateobs <= '@DATE@T23:59:59'
+	     AND (rawImfile.class_id = '@CLASS_ID@' OR rawImfile.class_id IS NULL)
+	     AND (exp_name <= '@EXP_NAME@')                                                                     
+ORDER BY summitExp.dateobs
Index: branches/czw_branch/20101203/ippTools/share/regtool_pendingburntoolimfile.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/regtool_pendingburntoolimfile.sql	(revision 29908)
+++ branches/czw_branch/20101203/ippTools/share/regtool_pendingburntoolimfile.sql	(revision 29908)
@@ -0,0 +1,31 @@
+SELECT DISTINCT
+       summitExp.exp_name,
+       rawImfile.uri,
+       summitExp.dateobs AS registered,
+       summitExp.imfiles,
+       summitExp.fault AS summit_fault,
+       pzDownloadExp.state AS download_state,
+       newExp.state AS newExp_state,
+       rawExp.state AS rawExp_state,
+       rawImfile.data_state AS imfile_state,
+       newExp.exp_id,
+       newImfile.tmp_class_id,
+       summitExp.exp_type,
+       rawExp.dateobs,
+       rawExp.obs_mode AS obs_mode,
+       rawExp.object AS object,
+       rawImfile.burntool_state AS burntool_state,
+       rawImfile.class_id,
+       (pzDownloadExp.state = 'stop') AS is_downloaded,
+       (rawImfile.burntool_state IS NOT NULL) AS is_registered
+       FROM
+            summitExp
+            LEFT JOIN pzDownloadExp USING(exp_name)
+            LEFT JOIN newExp ON exp_name = tmp_exp_name
+	    LEFT JOIN newImfile USING(exp_id)
+            LEFT JOIN rawExp USING(exp_id, exp_name)
+            LEFT JOIN rawImfile ON (rawImfile.exp_name = rawExp.exp_name AND rawImfile.tmp_class_id = newImfile.tmp_class_id)
+       WHERE
+             summitExp.dateobs >= '@DATE@T00:00:00'
+	     AND summitExp.dateobs <= '@DATE@T23:59:59'
+ORDER BY newImfile.tmp_class_id,summitExp.dateobs