SELECT
    DISTINCT
    CASE
       WHEN (dss3_mongo.service_type = ANY (ARRAY['GB'::text, 'GrabBike'::text])) THEN
            CASE
                WHEN phone_number IS NULL THEN '628'
                WHEN phone_number IS NOT NULL THEN '0' || substring(phone_number,3,length(phone_number))
                          || '9' :: text
            END
       WHEN (dss3_mongo.service_type = ANY (ARRAY['GC'::text, 'GrabCar'::text])) THEN
            CASE
                WHEN phone_number IS NULL THEN '628'
                WHEN phone_number IS NOT NULL THEN '0' || substring(phone_number,3,length(phone_number))
                          || '1' :: text
            END
       ELSE dss3_mongo.service_type
    END AS driver_id,
    CASE
       WHEN (dss3_mongo.service_type = ANY (ARRAY['GB'::text, 'GrabBike'::text])) THEN 9
       WHEN (dss3_mongo.service_type = ANY (ARRAY['GC'::text, 'GrabCar'::text])) THEN 1
    END AS grab_service_type,
    CASE
       WHEN (dss3_mongo.service_type = ANY (ARRAY['GB'::text, 'GrabBike'::text])) THEN 'GrabBike' :: text
       WHEN (dss3_mongo.service_type = ANY (ARRAY['GC'::text, 'GrabCar'::text])) THEN 'GrabCar' :: text
       ELSE dss3_mongo.service_type
    END AS grab_service_name,
    city_code,
    --partner_agent_id::int AS cashier_id,
    CASE WHEN partner_agent_id ~ '^[0-9\.]+$' IS TRUE THEN partner_agent_id::int ELSE 0 END AS cashier_id,
    first_name AS firstname,
    last_name AS lastname,
    CASE
        WHEN phone_number IS NULL THEN '628'
        WHEN phone_number IS NOT NULL THEN '0' || substring(phone_number,3,length(phone_number))
    END AS phonenumber,
    email,
    access_token,
    partner_id,
    submission_id
FROM grab.dss3_mongo
WHERE dss3_mongo.op = ANY (ARRAY['r'::text, 'c'::text]) AND dss3_mongo.submission_id !~~ '%AT%' :: text
AND
      to_timestamp((((((replace(dss3_mongo.created_at, '$date' :: text, '_date' :: text)) :: json ->> '_date' :: text)) :: bigint / 1000)) :: double precision) >= (${start_date});