Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- tendering.vendor_has_tendering source
- CREATE OR REPLACE VIEW tendering.vendor_has_tendering
- AS SELECT vs.vendor_id,
- vs.proposal_tender_id,
- vs.registration_status,
- vs.registration_quotation,
- vs.registration_aanwijzing,
- CASE
- WHEN vs.evaluasi_teknis::text = 'lolos'::text THEN 2
- ELSE 1
- END AS current_step,
- ( SELECT count(qi.id) AS count
- FROM tendering.quotation_items qi
- WHERE (qi.quotation_id IN ( SELECT q.id
- FROM tendering.quotations q
- WHERE vs.vendor_id = q.vendor_id AND q.proposal_tender_id = vs.proposal_tender_id))) AS quotation_items,
- pt.id,
- pt.uuid,
- pt.number,
- pt.purchasing_org_id,
- pt.metode_pengadaan_id,
- pt.metode_penyampaian_id,
- pt.title,
- pt.jadwal_tender_code,
- pt.code,
- pt.name,
- pt."order",
- pt.start_date,
- pt.start_time,
- pt.end_date,
- pt.end_time,
- pt.approved_at,
- pt.status,
- pt.awarding_status,
- ( SELECT concat(ptj2.end_date, ' ', ptj2.end_time) AS concat
- FROM tendering.proposal_tender_jadwal ptj2
- WHERE ptj2.proposal_tender_id = pt.id AND ptj2.jadwal_tender_code::text = 'JT004'::text) AS bo_start_date,
- pt.is_reject
- FROM ( SELECT DISTINCT vendor_selections.vendor_id,
- vendor_selections.proposal_tender_id,
- vendor_selections.registration_status,
- vendor_selections.registration_quotation,
- vendor_selections.registration_aanwijzing,
- vendor_selections.evaluasi_teknis
- FROM tendering.vendor_selections) vs
- LEFT JOIN ( SELECT pt_1.id,
- pt_1.uuid,
- pt_1.metode_pengadaan_id,
- pt_1.metode_penyampaian_id,
- pt_1.title,
- pt_1.purchasing_org_id,
- pt_1.approved_at,
- pt_1.status,
- ptj.jadwal_tender_code,
- tj.code,
- pt_1.number,
- tj.name,
- tj."order",
- ptj.start_date,
- ptj.start_time,
- ptj.end_date,
- ptj.end_time,
- awarding.status_text AS awarding_status,
- pt_1.is_reject
- FROM tendering.proposal_tender pt_1
- LEFT JOIN tendering.proposal_tender_jadwal ptj ON pt_1.id = ptj.proposal_tender_id
- LEFT JOIN tendering.jadwal_tender tj ON tj.id = ptj.jadwal_tender_id AND tj.metode_penyampaian_id::text = pt_1.metode_penyampaian_id::text
- LEFT JOIN tendering.awarding ON pt_1.id = awarding.proposal_tender_id
- WHERE now() >= to_timestamp(concat(ptj.start_date, ' ', ptj.start_time), 'YYYY-MM-DD HH24:MI:SS'::text) AND now() <= to_timestamp(concat(ptj.end_date, ' ', ptj.end_time), 'YYYY-MM-DD HH24:MI:SS'::text)) pt ON vs.proposal_tender_id = pt.id
- WHERE pt.start_date IS NOT NULL AND pt.approved_at IS NOT NULL AND pt.status = 'H8'::bpchar
- ORDER BY vs.vendor_id, pt.id, pt."order";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement