Project

General

Profile

Feature #3805

Implementasi Mockup Report Reward/Grievance

Added by Mr Dhafin about 1 month ago. Updated 12 days ago.

Status:
Closed
Priority:
High
Start date:
08/19/2025
Due date:
08/26/2025
% Done:

0%

Estimated time:

Description

Dear Tim Developer,

Mohon bantuannya untuk melakukan implementasi laporan Reward/Grievance sesuai mockup yang sudah disediakan (Project Bank Mega Report).

Scope Pekerjaan
1. Filter Report
Input periode (Start Date – End Date).
Tombol View Report untuk generate laporan.

2. Report Layout
o Tabel laporan menampilkan kolom:
No
Employee ID
Employee Name
Warning No
Warning Code
Warning Start
Warning End
Status
Type of Risk
Violation Category
Sub Violation Category
Detail
KPNO/Regional
Directorate

3. Export Option (Optional, jika dibutuhkan)
o Export ke Excel / PDF sesuai kebutuhan user.

Acceptance Criteria
• Report dapat ditampilkan sesuai filter periode.
• Data Reward/Grievance muncul sesuai field di tabel.
• Layout laporan sesuai mockup Bank Mega.

remote.minovais.com:31139
database
remote.minovais.com, 1458
MinovaHR Bank Mega Development


Files

Project Bank Mega Report.pdf (558 KB) Project Bank Mega Report.pdf Mr Dhafin, 08/19/2025 02:01 PM
Deploy 20250903 Rpt Viol Cat.rar (7.77 KB) Deploy 20250903 Rpt Viol Cat.rar Tri Rizqiaty, 09/03/2025 03:30 PM
clipboard-202509080951-rqnhf.png (149 KB) clipboard-202509080951-rqnhf.png Mr Dhafin, 09/08/2025 09:51 AM
clipboard-202509080952-lnivf.png (131 KB) clipboard-202509080952-lnivf.png Mr Dhafin, 09/08/2025 09:52 AM
clipboard-202509100959-enel6.png (41.2 KB) clipboard-202509100959-enel6.png Mr Dhafin, 09/10/2025 09:59 AM
Deploy Rpt Reward 20250915.zip (21.6 KB) Deploy Rpt Reward 20250915.zip Tri Rizqiaty, 09/15/2025 10:12 AM
Deploy Rpt Reward 20250917 V2.zip (220 KB) Deploy Rpt Reward 20250917 V2.zip Muhammad Bintar, 09/17/2025 04:09 PM
#1

Updated by Mr Dhafin about 1 month ago

  • Tracker changed from Bug to Feature
#2

Updated by Kezia Pawitra Yulianti about 1 month ago

  • Assignee changed from Kezia Pawitra Yulianti to Tri Rizqiaty
  • Priority changed from Normal to High
#3

Updated by Tri Rizqiaty about 1 month ago

  • Assignee changed from Tri Rizqiaty to Mr Dhafin

Dhafin, tolong settingan report ditbl base_cust_report_catalog & base_cust_report_parameter dilengkapi ya.

#4

Updated by Mr Dhafin about 1 month ago

  • Assignee changed from Mr Dhafin to Tri Rizqiaty

Dear mba yoma,

Settingan report sudah saya lengkapi di tabel:
1. base_cust_report_catalog dengan report_id = 1100012.
2. base_cust_report_parameter untuk parameter yang terkait dengan report_id = 1100012.

Silakan dicek kembali, kalau ada yang masih perlu penyesuaian bisa diinformasikan, Terimakasih mba.

#5

Updated by Mohammad Daud 28 days ago

Dear Yoma,

Untuk 2 tabel tersebut sudah dilengkapi dan bisa dicek kembali, ada penyesuaian dari sisi Field Tabelnya

#6

Updated by Tri Rizqiaty 27 days ago

  • Assignee changed from Tri Rizqiaty to Mohammad Daud

Mas Daud,

Untuk field2 ini, ambilnya dr field apa ya?
Warning No
Warning Code
Warning Start
Warning End
Detail
KPNO/Regional
Directorate

#7

Updated by Mohammad Daud 27 days ago

  • Assignee changed from Mohammad Daud to Tri Rizqiaty

Yom..
Untuk field2 ini, ambilnya dr field apa ya?
Diambil dari hr_md_emp_md0010
Warning No --> SK_Number
Warning Code --> Data_Type
Warning Start --> Start_date
Warning End --> End_date
Detail --> Description
KPNO/Regional --> Ambil dr hr_md_emp_md0010 filed Organization kemudian cek ke tabel hr_md_orm_o_o untuk ambil fiel Orgroup
Directorate --> Ambil dr hr_md_emp_md0010 filed Organization kemudian cek ke tabel hr_md_orm_o_o untuk ambil field Org_lvel = 01

#8

Updated by Tri Rizqiaty 26 days ago

Fixing:

1. Deploy RDL terlampir
2. Execute SP terlampir

#9

Updated by Tri Rizqiaty 26 days ago

  • Status changed from Developing to QA Test
  • Assignee changed from Tri Rizqiaty to Mohammad Daud
#10

Updated by Mr Dhafin 22 days ago

Dear mba yoma,

Untuk Filternya mohon disusuaikan dengan mockup ya mba. Terimakasih

#11

Updated by Tri Rizqiaty 22 days ago

  • Status changed from QA Test to Assigned
  • Assignee changed from Tri Rizqiaty to Mr Dhafin

Dhafin, tambahin dulu di tbl report parameter ya, filternya mw apa aja.

#12

Updated by Mr Dhafin 21 days ago

udh ya mba

#13

Updated by Mr Dhafin 21 days ago

  • Assignee changed from Mr Dhafin to Tri Rizqiaty
#14

Updated by Tri Rizqiaty 20 days ago

  • Assignee changed from Tri Rizqiaty to Mr Dhafin

Dhafin,

1. Kenapa mesti ada id & name? contoh orgid & orgname, ini bentukannya parameter orgid = combobox, trs orgname = textbox gitu?
2. Tolong dijelasin juga, field parameter berdasarkann tbl masterdata apa aja?

#15

Updated by Mr Dhafin 20 days ago

Karena itu opsional mba, dari permintaan usernya, contohnya di bagian Organization, terdapat Organization ID berupa ComboBox/Lookup yang datanya diambil dari tabel master HR_MD_Organization, dan Organization Name berupa TextBox yang otomatis terisi setelah memilih ID namun tetap bisa digunakan untuk pencarian cepat. Dengan demikian, user bisa memilih menggunakan ID yang lebih teknis atau langsung mencari dengan Name.

Terimakasih mba

#16

Updated by Tri Rizqiaty 15 days ago

Fixing :

1. Deploy RDL terlampir
2. Execute SP terlampir
3. Execute Query Sync (Jika belum pernah diexecute sama sekali)

#17

Updated by Tri Rizqiaty 15 days ago

  • Status changed from Developing to QA Test
  • Assignee changed from Tri Rizqiaty to Mr Dhafin
#18

Updated by Mr Dhafin 15 days ago

  • Status changed from QA Test to Deploy
  • Assignee changed from Mr Dhafin to Muhammad Bintar

Dear mas bin,

Mas bin, tolong bantu deploy yaa mas, makasih

#19

Updated by Muhammad Bintar 12 days ago

okeh sudah deploy
package baru nya ditaruh disini

#20

Updated by Mr Dhafin 12 days ago

  • Status changed from Deploy to Closed

Also available in: Atom PDF