con734_g_result_queryfields.js 2.89 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7
var override_queryfields = [
    {
        name: 'bp_id',
        queryexpression: "t1.bp_id_tenant=${@bp_id}"
    },
    {
        name: 'bp_name',
stone's avatar
stone committed
8
        queryexpression: "exists (select 1 from hls_bp_master hr where hr.bp_id=t1.bp_id_tenant and hr.bp_name like '%'||${@bp_name}||'%')"
Spencer Chang's avatar
Spencer Chang committed
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
    },
    {
        name: 'lease_start_date_from',
        queryexpression: "t1.lease_start_date between to_date(${@lease_start_date_from},'yyyy-mm-dd') and nvl(to_date(${@lease_start_date_to},'yyyy-mm-dd'),t1.lease_start_date)"
    },
    {
        name: 'lease_start_date_to',
        queryexpression: "t1.lease_start_date between nvl(to_date(${@lease_start_date_from},'yyyy-mm-dd'),t1.lease_start_date) and to_date(${@lease_start_date_to},'yyyy-mm-dd')"
    },
    {
        name: 'approved_date_from',
        queryexpression: "t1.approved_date between to_date(${@approved_date_from},'yyyy-mm-dd') and nvl(to_date(${@approved_date_to},'yyyy-mm-dd'),t1.approved_date)"
    },
    {
        name: 'approved_date_to',
        queryexpression: "t1.approved_date between nvl(to_date(${@approved_date_from},'yyyy-mm-dd'),t1.approved_date) and to_date(${@approved_date_to},'yyyy-mm-dd')"
    }, {
        name: 'create_date_from',
        queryexpression: "t1.create_date between to_date(${@create_date_from},'yyyy-mm-dd') and nvl(to_date(${@create_date_to},'yyyy-mm-dd'),t1.create_date)"
    },
    {
        name: 'create_date_to',
        queryexpression: "t1.create_date between nvl(to_date(${@create_date_from},'yyyy-mm-dd'),t1.create_date) and to_date(${@create_date_to},'yyyy-mm-dd')"
    },
    {
        field: 'project_id',
        queryoperator: "="
    }, {
        field: 'employee_id',
        queryoperator: "="
    }, {
        field: 'lease_organization',
        queryoperator: "="
    }, {
        field: 'contract_id',
        queryoperator: "="
    }, {
stone's avatar
stone committed
46 47
        name: 'contract_number',
        queryexpression: "t1.contract_number  like  '%'||${@contract_number}||'%'"
Spencer Chang's avatar
Spencer Chang committed
48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68
    }, {
        field: 'lease_channel',
        queryoperator: "="
    }, {
        field: 'document_type',
        queryoperator: "="
    }, {
        field: 'lease_channel',
        queryoperator: "="
    }, {
        field: 'document_type',
        queryoperator: "="
    }, {
        field: 'business_type',
        queryoperator: "="
    }, {
        field: 'contract_status',
        queryoperator: "="
    }, {
        field: 'division',
        queryoperator: "="
stone's avatar
stone committed
69 70 71
    },{
        name: 'change_created_by_n',
        queryexpression: "t1.change_created_by_n like '%'||${@change_created_by_n}||'%'"
Spencer Chang's avatar
Spencer Chang committed
72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
    }

];

var add_datafilters = [
    {
        name: "req_status",
        expression: "t1.req_status in ('REJECT','APPROVED','APPROVING')"
    }/*,
     {
     name : "ccr_document_type",
     expression : "exists (select 1 from con_contract_change_req r where r.change_req_id = t1.contract_id and r.document_type = 'PAYCARD')"
     }*/];

override();
add_datafilter();