Scyalcire(提问者) 回复 豆豆小可爱SELECT
t1.bid_org_name 招标单位,
( CASE t1.purchase_type WHEN \'1\' THEN \'公开招标\' WHEN \'2\' THEN \'邀请招标\' WHEN \'3\' THEN \'竞争性谈判\' ELSE \'单一来源\' END ) 招标方式,
t1.project_code 项目代码,
date( t1.ts ) 招标日期,
t02.quota_money 报价金额,
( CASE t1.isexpert_review WHEN NOT NULL THEN \'有评分\' ELSE \'无评分\' END ) 是否评分,
t02.sup_enterprise_id 供应商id,
t02.sup_enterprise_name 供应商名称,
t02.material_name 物料名称,
t02.material_desc 物料规格,
t02.nnum 中标数量,
t02.no_tax_price 中标无税单价,
t02.no_tax_money 中标无税金额,
t05.billno 合同编码,
t05.erp_ct_code ERP合同编码
FROM
cpu_biddoc.cpu_biddoc t1
LEFT OUTER JOIN cpu_pricedecision.cpu_pricedecision t01 ON t1.project_id = t01.project_id
LEFT OUTER JOIN cpu_contract.cpu_ct t05 ON t05.project_id = t1.project_id,
cpu_pricedecision.cpu_pricedecision_detail t02
WHERE
t1.dr = \'0\'
AND t01.id = t02.cpu_pricedecision_id
AND t1.dr = \'0\'
AND t01.dr = \'0\'
AND t02.dr = \'0\'
${if(len(招标开始日期)>0&&len(招标结束日期)>0,\" and date( t1.ts ) BETWEEN \'\"+招标开始日期+\"\' AND \'\"+招标结束日期+\"\'\",\"\")}
${if(len(招标单位)>0,\" AND t1.bid_org_name = \'\"+招标单位+\"\'\",\"\")}
${if(len(招标方式)>0,\"AND t1.purchase_type = \'\"+招标方式+\"\'\",\"\")}
${if(len(供应商名称)>0,\"AND t02.sup_enterprise_name = \'\"+供应商名称+\"\'\",\"\")}
${if(len(合同编码)>0,\"AND t05.billno = \'\"+合同编码+\"\'\",\"\")}
${if(len(ERP合同编号)>0,\"AND t05.erp_ct_code ERP = \'\"+ERP合同编号+\"\'\",\"\")}
ORDER BY
t1.bid_org_name,
t1.ts,
t1.project_code,
t02.sup_enterprise_name,
t02.material_name
1min目标场景问卷
立即参与
