Project

General

Profile

Edit Log time Copy Delete

Bug #2411

[HR-TIMEDATA]permintaan job query untuk merapikan attendance yang lintas hari

Added by Muhammad Bintar 11 months ago. Updated 10 months ago.

Status:
QA Test
Priority:
Immediate
Assignee:
Muhammad Bintar
Start date:
11/16/2023
Due date:
11/20/2023 (about 11 months late)
% Done:

0%

Estimated time:
Spent time:
4.00 h
Quote

Description

dear tim developer mohon suppport nya untuk merapikan attendance yang lintas hari dimana jika startdate nya tidak sama dengan end date maka enddate nya disamakan dengan startdate.

Files

Edit attached files
CREATE TRIGGER AfterInsertPHRPA0019.txt (277 Bytes) CREATE TRIGGER AfterInsertPHRPA0019.txt M Azid Wahyudi, 11/21/2023 03:54 PM Delete
Add

Subtasks

Add

Related issues

Quote #1

Updated by shofwan shiddiq 11 months ago

  • Assignee changed from shofwan shiddiq to Muhammad Bintar

update PHRPA0019 set EndDate=StartDate where StartDate !=EndDate and AttendanceType in (select distinct AttendanceType from PHRTMATTTYP where CrossDay='Y')

Quote #2

Updated by shofwan shiddiq 11 months ago

sebelum di execute jangan lupa di backup dulu ya masbin

Quote #3

Updated by M Azid Wahyudi 11 months ago

dear masbin ,, berikut ini query after insert untuk crossday

makasih

#4

Updated by Kezia Pawitra Yulianti 11 months ago

  • Status changed from New to Assigned
  • Priority changed from Normal to High
Quote #5

Updated by Muhammad Bintar 10 months ago

  • Assignee changed from Muhammad Bintar to M Azid Wahyudi

ada bug dimana enddate nya semua attendance menjadi tanggal 24 november semua

#6

Updated by Kezia Pawitra Yulianti 10 months ago

  • Priority changed from High to Immediate
Quote #7

Updated by M Azid Wahyudi 10 months ago

  • Status changed from Assigned to QA Test
  • Assignee changed from M Azid Wahyudi to Muhammad Bintar

dear masbin , berikut ini afterinsert yang udah di rapihkan :

USE [MinovaES_KJL_Prod]
GO
/****** Object: Trigger [dbo].[AfterInsertPHRPA0019CrossDay] Script Date: 08/12/2023 16:39:53 **/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[AfterInsertPHRPA0019CrossDay]
ON [dbo].[PHRPA0019]
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;

UPDATE p
    SET EndDate = p.StartDate
    FROM PHRPA0019 p
    INNER JOIN inserted i ON p.EmployeeID = i.EmployeeID 
    WHERE i.StartDate != p.EndDate
END;

makasih

Edit Log time Copy Delete

Also available in: Atom PDF