search

OC-Bandung / OCDS-publication

0 stars 0 forks source link

Planning Budget URI #1

Open mireille-raad opened 7 years ago

mireille-raad commented 7 years ago

The structure of the Planning Budget URI changes according to year.

For now I am using

CONCAT('https://sirup.lkpp.go.id/sirup/rup/detailPaketPenyedia', NEW.tahun ,'/', NEW.sirupID )

This needs to be updated to include different concatenation patterns for different years

I am adding this here, so we don't forget

bdgcoder commented 7 years ago

@dc-coder for 2013 - 2016 https://sirup.lkpp.go.id/sirup/rup/detailPaketPenyedia/1974545 And for 2017 is https://sirup.lkpp.go.id/sirup/rup/detailPaketPenyedia2017/11180775

We can change to IF(NEW.tahun <= 2016, CONCAT('https://sirup.lkpp.go.id/sirup/rup/detailPaketPenyedia', '/', NEW.sirupID ), CONCAT('https://sirup.lkpp.go.id/sirup/rup/detailPaketPenyedia', NEW.tahun ,'/', NEW.sirupID ))

I hope this is correct syntax.