Project

General

Profile

Bug #650

[HR-TIME DATA]Generate Personal Work Schedule tidak dapat mengenerate massal. Jika lebih besar maka akan loading terus menerus

Added by Muhammad Bintar about 3 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Mr. Yusuf
Start date:
12/20/2021
Due date:
12/22/2021
% Done:

0%

Estimated time:

Description

Dear Tim Developer mohon supportnya untuk perbaikan pada Generate Personal Workschedule dimana pada saat melakukan generate personal work schedule
tidak keluar data nya dan ada loading terus menerus tanpa henti.

Rohto Development
remote.minovais.com:31119
database sql server 2012

Files

clipboard-202112201527-j6zvj.png (50.2 KB) clipboard-202112201527-j6zvj.png Muhammad Bintar, 12/20/2021 03:27 PM
CtrlGeneratePersonalWS.js (7.04 KB) CtrlGeneratePersonalWS.js Perbaikan query pada CtrlGeneratePersonalWS.js Muhammad Bintar, 12/20/2021 03:30 PM
#1

Updated by Muhammad Bintar about 3 years ago

Update: =========
Perbaikan query pada CtrlGeneratePersonalWS.js di folder UI\app\controller\masterdata\tm\
MinovaUtil.ExecuteParamQuery({
ID: "TM_DeletePWS",
EmployeeIDFrom: EmpStart.getValue(),
EmployeeIDTo: EmpEnd.getValue(),
Year: Year.getValue(),
StartDate: StartDate.getValue(),
EndDate: EndDate.getValue(),
Type: Type,
}, function (s) {
var result = Ext.decode(s.responseText);
var dt = Ext.decode(Ext.decode(result.data));
if (Type == '1') {
Ext.Ajax.request({
method: 'POST',
url: '/TM/GeneratePersonalWS',
params: {
EmployeeIDFrom: EmpStart.getValue(),
EmployeeIDTo: EmpEnd.getValue(),
Year: Year.getValue(),
menuid: "TM07"
},
waitMsg: 'Saving Data...',
success: function (response) {
var result = Ext.decode(response.responseText);
var storeMedClaim = Ext.StoreMgr.lookup("storegeneratePersonalWS");
storeMedClaim.loadData(Ext.decode(result.data));
if (result.success) {
MinovaMessage('', '000006', '', 'S');
form.unmask();
} else {
form.unmask();
MinovaMessage('', '000005', result.message.text, "E")
}
},
failure: function (response) {
var result = Ext.decode(response.responseText);
form.unmask();
MinovaMessage('', '000005', result.message.text, "E")
}
});
} else {
Ext.Ajax.request({
method: 'POST',
url: '/TM/GeneratePersonalWSPeriod',
params: {
EmployeeIDFrom: EmpStart.getValue(),
EmployeeIDTo: EmpEnd.getValue(),
StartDate: StartDate.getValue(),
EndDate: EndDate.getValue(),
menuid: "TM07"
},
waitMsg: 'Saving Data...',
success: function (response) {

var result = Ext.decode(response.responseText);
                        var storeMedClaim = Ext.StoreMgr.lookup("storegeneratePersonalWS");
                        storeMedClaim.loadData(Ext.decode(result.data));
                        if (result.success) {
                            MinovaMessage('', '000006', '', 'S');
                            form.unmask();
                        } else {
                            form.unmask();
                            MinovaMessage('', '000005', result.message.text, "E")
                        }
                    },
                    failure: function (response) {
                        var result = Ext.decode(response.responseText);
                        form.unmask();
                        MinovaMessage('', '000005', result.message.text, "E")
                    }
                });
            }    
            }, function (f) {
                var result = Ext.decode(response.responseText);
                form.unmask();
                MinovaMessage('', '000005', result.message.text, "E")
            });            
        }
    },

======================================================
Penambahan CUSTPARAM dengan nama TM_DeletePWS

/*DECLARE @StartDate VARCHAR='20211201'
DECLARE @EndDate VARCHAR='20211231'
DECLARE @EmployeeIDFrom VARCHAR='00000001'
DECLARE @EmployeeIDTo VARCHAR='00000002'
DECLARE @Year VARCHAR='2021'
DECLARE @Type VARCHAR='2'*/

IF (@Type = 1)
BEGIN
DELETE FROM PHRPA0125 WHERE EmployeeID BETWEEN @EmployeeIDFrom AND @EmployeeIDTo AND (LEFT = @Year)
END
ELSE
BEGIN
DELETE FROM PHRPA0125 WHERE (EmployeeID BETWEEN @EmployeeIDFrom AND @EmployeeIDTo) AND (StartDate BETWEEN @StartDate AND @EndDate)
END

================================

Jadi konsep nya adalah saat execute generate personal workschedule, aplikasi akan menghapus data pada PHRPA0125 dulu lalu menginsert ulang data nya berdasarkan filter yang telah di pilih pada menu Generate Personal Work Schedule.

#2

Updated by Muhammad Bintar about 3 years ago

  • Status changed from Developing to Deploy
#3

Updated by Muhammad Bintar about 3 years ago

  • Status changed from Deploy to Closed

Also available in: Atom PDF