编辑代码

select 
	bsga."Average" ,
	${if(procedure=="battery_spc_gather_auto",
	"bsga.\"FurnaceID\",right(bsga.\"FurnaceID\",2)  as shebeihao ",
	"")}
	${if(procedure=="spc_anneal_offline",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
	${if(procedure=="spc_oxidation_offline",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
    ${if(procedure=="battert_spc_scales_texturing",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
    ${if(procedure=="battert_spc_scales_alkalicase",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
    ${if(procedure=="spc_texturing_offline",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
    ${if(procedure=="spc_alkalicase_offline",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
    ${if(procedure=="spc_pepoly_offline",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
    ${if(procedure=="spc_alumina1_offline",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
    ${if(procedure=="spc_alumina2_offline",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
    ${if(procedure=="spc_positive_membrane_offline",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
    ${if(procedure=="spc_dorsal_membrane_offline",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
    ${if(procedure=="spc_pullingforce1_offline",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
    ${if(procedure=="spc_pullingforce2_offline",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
    ${if(procedure=="spc_threepointbendingresistance_offline",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
    ${if(procedure=="battert_spc_scales_silk",
	"bsga.\"equipmentNo\" as \"FurnaceID\", bsga.\"equipmentNo\" as shebeihao",
	"")}
	,bsga."Homogen" ,
	bsga."creationDate"
	
from ${procedure} bsga 
where 
	${reportCombox} = 2
	and bsga.workshop = 'C1'
	and bsga."Average" != '0.0'
	and bsga."creationDate" >= to_timestamp('${startDate}', 'YYYY-MM-DD HH24:MI:SS')
	and bsga."creationDate" < to_timestamp('${endDate}', 'YYYY-MM-DD HH24:MI:SS')
	--${if(len(deviceId)>0," and bsga.\"FurnaceID\" in ('" +deviceId+ "')","")}
--order by right(bsga."FurnaceID",2)
    ${if(len(deviceId)>0 && procedure=="battery_spc_gather_auto"," and bsga.\"FurnaceID\" in ('" +deviceId+ "') order by bsga.\"FurnaceID\" ","")}
	${if(len(deviceId)>0 && procedure=="spc_anneal_offline"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
	${if(len(deviceId)>0 && procedure=="spc_oxidation_offline"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
    ${if(len(deviceId)>0 && procedure=="battert_spc_scales_texturing"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
	${if(len(deviceId)>0 && procedure=="battert_spc_scales_alkalicase"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
    ${if(len(deviceId)>0 && procedure=="spc_texturing_offline"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
	${if(len(deviceId)>0 && procedure=="spc_alkalicase_offline"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
    ${if(len(deviceId)>0 && procedure=="spc_pepoly_offline"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
	${if(len(deviceId)>0 && procedure=="spc_alumina1_offline"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
    ${if(len(deviceId)>0 && procedure=="spc_alumina2_offline"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
	${if(len(deviceId)>0 && procedure=="spc_positive_membrane_offline"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
    ${if(len(deviceId)>0 && procedure=="spc_dorsal_membrane_offline"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
	${if(len(deviceId)>0 && procedure=="spc_pullingforce1_offline"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
    ${if(len(deviceId)>0 && procedure=="spc_pullingforce2_offline"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
	${if(len(deviceId)>0 && procedure=="spc_threepointbendingresistance_offline"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}
	${if(len(deviceId)>0 && procedure=="battert_spc_scales_silk"," and bsga.\"equipmentNo\" in ('" +deviceId+ "') order by bsga.\"equipmentNo\" ","")}