init_report_parameter_config_for_sales_dashboard

--Adrian, Nov 23, 2017
--Init script for Sales Dashboard

INSERT INTO m_report_parameter_config(
            tenant_id, ou_id, report_name, parameter_key, parameter_value,
            create_datetime, create_user_id, update_datetime, update_user_id, version,
            active, active_datetime, non_active_datetime)
    VALUES (10, 10, 'CurrentSalesRevenueAchievementPerSalesman', 'minValue', 0,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentSalesRevenueAchievementPerSalesman', 'maxValue', 2000,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentSalesRevenueAchievementPerSalesman', 'redFrom', 0,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentSalesRevenueAchievementPerSalesman', 'redTo', 1200,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentSalesRevenueAchievementPerSalesman', 'colorRed', '#DF5353',
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentSalesRevenueAchievementPerSalesman', 'yellowFrom', 1200,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentSalesRevenueAchievementPerSalesman', 'yellowTo', 1600,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentSalesRevenueAchievementPerSalesman', 'colorYellow', '#DDDF0D',
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentSalesRevenueAchievementPerSalesman', 'greenFrom', 1600,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentSalesRevenueAchievementPerSalesman', 'greenTo', 2000,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentSalesRevenueAchievementPerSalesman', 'colorGreen', '#55BF3B',
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
            (10, 10, 'CurrentGrossProfitAchievementPerSalesman', 'minValue', 0,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentGrossProfitAchievementPerSalesman', 'maxValue', 2000,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentGrossProfitAchievementPerSalesman', 'redFrom', 0,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentGrossProfitAchievementPerSalesman', 'redTo', 1200,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentGrossProfitAchievementPerSalesman', 'colorRed', '#DF5353',
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentGrossProfitAchievementPerSalesman', 'yellowFrom', 1200,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentGrossProfitAchievementPerSalesman', 'yellowTo', 1600,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentGrossProfitAchievementPerSalesman', 'colorYellow', '#DDDF0D',
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentGrossProfitAchievementPerSalesman', 'greenFrom', 1600,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentGrossProfitAchievementPerSalesman', 'greenTo', 2000,
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' '),
           (10, 10, 'CurrentGrossProfitAchievementPerSalesman', 'colorGreen', '#55BF3B',
            '20171123010101', -1, '20171123010101', -1, 0,
            'Y', '20171123010101', ' ');