v 1.0.0 Eclipse BIRT Designer Version 4.6.0.v201606072122 in /templates/blank_report.gif ltr 120 false static false string true % simple text-box Unformatted static false boolean true False simple check-box static false string true % simple text-box Unformatted static true string true 2022-05-15 1:00:01 simple false text-box Unformatted static true string true 2022-05-21 23:59:59 simple false text-box Unformatted static false string true dd MMM y HH:mm:ss simple text-box Unformatted static false string true % simple text-box Unformatted static false string true % simple text-box Unformatted static string true % simple text-box Unformatted metadataBidiFormatStr ILYNN disabledMetadataBidiFormatStr contentBidiFormatStr ILYNN disabledContentBidiFormatStr com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/sog gis V2U3bUpnNkBGYyN3 nulls lowest user_id dimension user_id user_id keyholder_firstname dimension keyholder_firstname keyholder_firstname keyholder_lastname dimension keyholder_lastname keyholder_lastname key_box_no dimension key_box_no key_box_no his_action dimension his_action his_action transaction_job_card dimension transaction_job_card transaction_job_card transaction_field_a dimension transaction_field_a transaction_field_a transaction_field_b dimension transaction_field_b transaction_field_b transaction_date_start measure transaction_date_start transaction_date_start transaction_date_end measure transaction_date_end transaction_date_end request_method dimension request_method request_method access_point_id dimension access_point_id access_point_id access_point_description dimension access_point_description access_point_description last_changed_on dimension last_changed_on last_changed_on approver_last_changed_on dimension approver_last_changed_on approver_last_changed_on approver_firstname dimension approver_firstname approver_firstname approver_lastname dimension approver_lastname approver_lastname approver_username dimension approver_username approver_username approval_time dimension approval_time approval_time schedule_options dimension schedule_options schedule_options start_date start_date string -1 1 true false end_date end_date string -1 2 true false 1 user_id string 2 keyholder_firstname string 3 keyholder_lastname string 4 key_box_no string 5 his_action string 6 transaction_job_card string 7 transaction_field_a string 8 transaction_field_b string 9 transaction_date_start integer 10 transaction_date_end integer 11 request_method string 12 access_point_id string 13 access_point_description string 14 last_changed_on date-time 15 approver_last_changed_on date-time 16 approver_firstname string 17 approver_lastname string 18 approver_username string 19 approval_time string 20 schedule_options string 0 Glam 1 user_id user_id string 12 2 keyholder_firstname usr_firstname string 12 3 keyholder_lastname usr_lastname string 12 4 key_box_no key_box_no string 12 5 his_action his_action string 12 6 transaction_job_card transaction_job_card string 12 7 transaction_field_a transaction_field_a string 12 8 transaction_field_b transaction_field_b string 12 9 transaction_date_start transaction_date_start integer 4 10 transaction_date_end transaction_date_end integer 4 11 request_method request_method string 12 12 access_point_id access_point_id string 12 13 access_point_description access_point_description string 12 14 last_changed_on last_changed_on date-time 93 15 approver_last_changed_on last_changed_on date-time 93 16 approver_firstname usr_firstname string 12 17 approver_lastname usr_lastname string 12 18 approver_username approver_username string 12 19 approval_time approval_time string 12 20 schedule_options schedule_options string 12 gssh.last_changed_on, approved.last_changed_on, NULL), gssh.last_changed_on), 'Not approved yet') AS approval_time, (select group_concat(concat(group_name, ': ', option_value) SEPARATOR '\n') from glam_supervisor_schedule_option_history left join glam_schedule_option on glam_schedule_option.option_id=glam_supervisor_schedule_option_history.option_id left join glam_schedule_option_group on glam_schedule_option_group.group_id=glam_schedule_option.group_id where glam_supervisor_schedule_option_history.supervisor_schedule_id=gssh.supervisor_schedule_id) as schedule_options from glam_supervisor_schedule_history gssh left join krf_user ku on ku.usr_id=gssh.user_id left join glam_access_point gap on gap.access_point_id=gssh.access_point_id LEFT JOIN glam_supervisor_schedule_history AS approved ON gssh.supervisor_schedule_id = approved.supervisor_schedule_id AND approved.his_action = 'APPROVED' AND approved.last_changed_on > gssh.last_changed_on LEFT JOIN krf_user AS approver ON approved.last_changed_by = approver.usr_id where gssh.his_action='CREATED' AND gssh.last_changed_on between ? and ? $WHERE]]> 2.0 his_id 1 -5 20 0 NotNullable his_id his_id 20 his_action 2 12 8 0 NotNullable his_action his_action 8 supervisor_schedule_id 3 4 11 0 NotNullable supervisor_schedule_id supervisor_schedule_id 11 supervisor_id 4 12 36 0 NotNullable supervisor_id supervisor_id 36 user_id 5 12 36 0 NotNullable user_id user_id 36 access_point_id 6 12 36 0 Nullable access_point_id access_point_id 36 transasction_operation 7 12 17 0 Nullable transasction_operation transasction_operation 17 transaction_date_start 8 4 10 0 Nullable transaction_date_start transaction_date_start 10 transaction_date_end 9 4 10 0 Nullable transaction_date_end transaction_date_end 10 transaction_location 10 -2 2147483647 0 Nullable transaction_location transaction_location 2147483647 transaction_gps_radius 11 7 12 31 Nullable transaction_gps_radius transaction_gps_radius 12 transaction_description 12 12 200 0 Nullable transaction_description transaction_description 200 transaction_type 13 12 6 0 Nullable transaction_type transaction_type 6 transaction_is_declined 14 -7 1 0 Nullable transaction_is_declined transaction_is_declined 1 transaction_job_card 15 12 64 0 Nullable transaction_job_card transaction_job_card 64 transaction_field_a 16 12 64 0 Nullable transaction_field_a transaction_field_a 64 transaction_field_b 17 12 64 0 Nullable transaction_field_b transaction_field_b 64 last_changed_on 18 93 19 0 Nullable last_changed_on last_changed_on 19 last_changed_by 19 12 36 0 Nullable last_changed_by last_changed_by 36 key_box_no 20 12 16 0 Nullable key_box_no key_box_no 16 request_method 21 12 11 0 Nullable request_method request_method 11 ]]> start_date start_date string -1 1 true false end_date end_date string -1 2 true false 1 request_method string 2 count(*) decimal Glam 1 request_method request_method string 2 count(*) count(*) decimal 2.0 In 1 -1 0 0 Unknown In 2 -1 0 0 Unknown ]]> start_date start_date string -1 1 true false end_date end_date string -1 2 true false 1 user_id string 2 usr_firstname string 3 usr_lastname string 4 count(*) decimal Glam 1 user_id user_id string 2 usr_firstname usr_firstname string 3 usr_lastname usr_lastname string 4 count(*) count(*) decimal landscape 14pt Access request report html new Date()]]> large bold 10pt Request distribution nonenonenonenoneSupervisorScheduleMethodStats request_method request_method dataSetRow["request_method"] string count(*) count(*) dataSetRow["count(*)"] decimal Aggregation total float SUM Expression dataSetRow["count(*)"] true

solid thin solid thin solid thin solid thin solid thin solid thin solid thin solid thin 12pt bold Method solid thin solid thin solid thin solid thin

solid thin solid thin solid thin solid thin request_method solid thin solid thin solid thin solid thin count(*) large bold 10pt Request made solidthinsolidthinsolidthinsolidthinSupervisorScheduleHistory keyholder_firstname keyholder_firstname dataSetRow["keyholder_firstname"] string keyholder_lastname keyholder_lastname dataSetRow["keyholder_lastname"] string key_box_no key_box_no dataSetRow["key_box_no"] string transaction_job_card transaction_job_card dataSetRow["transaction_job_card"] string transaction_field_a transaction_field_a dataSetRow["transaction_field_a"] string transaction_field_b transaction_field_b dataSetRow["transaction_field_b"] string transaction_date_end transaction_date_end var temp = new Date(dataSetRow["transaction_date_end"]*1000) var format = params["date_format"].value; Formatter.format(temp,format) string true transaction_date_start transaction_date_start var temp = new Date(dataSetRow["transaction_date_start"]*1000) var format = params["date_format"].value; Formatter.format(temp,format) string true access_point_description access_point_description dataSetRow["access_point_description"] string request_method request_method dataSetRow["request_method"] string true approver_username approver_username if (dataSetRow["approver_username"]==null) { 'Not approved yet' } else { dataSetRow["approver_username"] } string true approval_time approval_time if (dataSetRow["approval_time"]==null) { 'Not approved yet' } else { dataSetRow["approval_time"] } string true approver_last_changed_on approver_last_changed_on if (dataSetRow["approver_last_changed_on"]==null) { 'Not approved yet' } else { var format = params["date_format"].value; Formatter.format(dataSetRow["approver_last_changed_on"], format) } string true schedule_options schedule_options if (dataSetRow["schedule_options"] == null) { var opts = ''; if (dataSetRow["transaction_field_a"] != null) { opts += "Customer: " + dataSetRow["transaction_field_a"] + "\n" } if (dataSetRow["transaction_field_b"] != null) { opts += "Reason: " + dataSetRow["transaction_field_b"]; } opts } else { dataSetRow["schedule_options"] } string true

solid thin solid thin solid thin solid thin large Name solid thin solid thin solid thin solid thin large Surname solid thin solid thin solid thin solid thin large Key solid thin solid thin solid thin solid thin large Ticket/Reason solid thin solid thin solid thin solid thin large Schedule Options solid thin solid thin solid thin solid thin large Start solid thin solid thin solid thin solid thin large End solid thin solid thin solid thin solid thin large Method solid thin solid thin solid thin solid thin large Lock solid thin solid thin solid thin solid thin large Approved Timestamp solid thin solid thin solid thin solid thin large Approver username solid thin solid thin solid thin solid thin large Approval Time

solid thin solid thin solid thin solid thin keyholder_firstname solid thin solid thin solid thin solid thin keyholder_lastname solid thin solid thin solid thin solid thin key_box_no solid thin solid thin solid thin solid thin transaction_job_card solid thin solid thin solid thin solid thin schedule_options solid thin solid thin solid thin solid thin transaction_date_start solid thin solid thin solid thin solid thin transaction_date_end solid thin solid thin solid thin solid thin request_method solid thin solid thin solid thin solid thin access_point_description solid thin solid thin solid thin solid thin approver_last_changed_on solid thin solid thin solid thin solid thin approver_username solid thin solid thin solid thin solid thin approval_time large bold 10pt Summary SupervisorScheduleStats user_id user_id dataSetRow["user_id"] string usr_firstname usr_firstname dataSetRow["usr_firstname"] string usr_lastname usr_lastname dataSetRow["usr_lastname"] string count(*) count(*) dataSetRow["count(*)"] decimal Aggregation Total float AVE Expression dataSetRow["count(*)"] true

solid thin solid thin solid thin solid thin 14pt bold Name solid thin solid thin solid thin solid thin 14pt bold Surname solid thin solid thin solid thin solid thin 14pt bold Count

solid thin solid thin solid thin solid thin usr_firstname solid thin solid thin solid thin solid thin usr_lastname solid thin solid thin solid thin solid thin count(*)