Project

General

Profile

Bug #1623

[PAYROLL]report wage type recap untuk filter cost center nya tidak menampilkan data yang spesifik.

Added by Muhammad Bintar about 2 years ago. Updated over 1 year ago.

Status:
Closed
Priority:
Urgent
Assignee:
shofwan shiddiq
Start date:
09/22/2022
Due date:
09/23/2022
% Done:

0%

Estimated time:
Spent time:
34.00 h

Description

dear tim developer mohon support nya untuk perbaikan pada report wage type recap dimana pada saat mencoba mengisi filter pada report tersebut, data yang ditampil tidak spesifik dan datanya keluar semua all employee.

remote.minovais.com:31131
username minovais

database sql server 2014
remote.minovais.com, 1442
minovaees_arita_dev

SP nya yaitu PRPTPYWTRECAPDETAIL

parameter nya:
DECLARE @PayPeriod VARCHAR = '202209'
DECLARE @EmployeeIDFrom VARCHAR = ''
DECLARE @EmployeeIDTo VARCHAR= ''
DECLARE @PayrollGroupStart VARCHAR = '0001'
DECLARE @PayrollGroupEnd VARCHAR = ''
DECLARE @CostCenterStart VARCHAR = 'PT Makmur Abadi Valve'
DECLARE @CostCenterEnd VARCHAR = ''
DECLARE @ReportType VARCHAR = '0001'
DECLARE @UserID VARCHAR= 'bintar'
DECLARE @MenuID VARCHAR = 'PYAR03'

Files

clipboard-202209221033-yaug6.png (106 KB) clipboard-202209221033-yaug6.png Muhammad Bintar, 09/22/2022 10:33 AM
clipboard-202209231405-sxcxp.png (39.5 KB) clipboard-202209231405-sxcxp.png TABLE PHRPYWTRCPHEADER shofwan shiddiq, 09/23/2022 02:05 PM
clipboard-202209231407-ouad7.png (46.5 KB) clipboard-202209231407-ouad7.png TABLE PCMEPRPTSELECTION shofwan shiddiq, 09/23/2022 02:07 PM
clipboard-202209231411-fpply.png (33.5 KB) clipboard-202209231411-fpply.png TABLE SDATATABLEFIELD shofwan shiddiq, 09/23/2022 02:11 PM
#1

Updated by Kezia Pawitra Yulianti about 2 years ago

  • Due date set to 09/23/2022
  • Status changed from New to Assigned
  • Priority changed from Normal to Urgent
#2

Updated by shofwan shiddiq about 2 years ago

Dear Mas Bintar. Report Wage Type Recap Sudah bisa di test terima kasih.

PERUBAHAN ARITA MENU REPORT WAGE TYPE RECAP !!

A. UPDATE STORED PROCEDURE: PRPTPYWTRECAPDETAIL

B. TABLE SDATATABLEFIELD 

a. Table: PHROM0001
1. ObjectDescription 
            - ValueField: 0 
            - DisplayValue: 1
2. ObjectID 
            - ValueField: 1 
            - DisplayValue: 0

TABLE SDATATABLEFIELD

C. TABLE PCMEPRPTSELECTION

a. ReportID: 1300021
1. FieldName: EmployeeIDFrom
            - FieldRef: EMPIDFROM
            - Lookupfunction Ext.ComponentQuery.query('[name=EmployeeIDFrom]')[0].setValue(selection.data.EmployeeID);
            - SearchType: 2
2. FieldName: EmployeeIDTo
            - FieldRef: EMPIDTO
            - Lookupfunction: Ext.ComponentQuery.query('[name=EmployeeIDTo]')[0].setValue(selection.data.EmployeeID);
            - SearchType: 2

TABLE PCMEPRPTSELECTION

D. TABLE PHRPYWTRCPHEADER

1. FieldName: cost_center_id
            - IsGroup: 0
            - IsActive: 1
        2. FieldName: cost_center_abbr
            - IsGroup: 1
            - IsActive: 1

TABLE PHRPYWTRCPHEADER

semoga dapat dimengerti, terima kasih.

#3

Updated by Kezia Pawitra Yulianti about 2 years ago

  • Status changed from Assigned to QA Test

Bintar, tolong di update yaa untuk di port arita prod nya di 66.
sekalian redmine nya juga di close aja kalau sudah done
Tks

#4

Updated by Muhammad Bintar over 1 year ago

  • Status changed from QA Test to Closed
  • Assignee changed from Muhammad Bintar to shofwan shiddiq

closseeee

Also available in: Atom PDF