PERTALIFE

--USE [MinovaES_Easy]

--GO

--/****** Object:  StoredProcedure [dbo].[Mobile_InsertAttendanceClockOut]    Script Date: 9/3/2025 2:16:11 PM ******/

--SET ANSI_NULLS ON

--GO

--SET QUOTED_IDENTIFIER ON

--GO

CREATE PROCEDURE [dbo].[Mobile_InsertAttendanceClockOut]

    @StartDate VARCHAR(8),

    @EndDate VARCHAR(8),

    @EmployeeID VARCHAR(8),

    @AttendanceType VARCHAR(4),

    @StartTime VARCHAR(4),

    @StartLocation VARCHAR(100),

    @EndTime VARCHAR(4),

    @EndLocation VARCHAR(100),

    @Notes VARCHAR(255),

    @CreateBy VARCHAR(50),

    @ChangeBy VARCHAR(50),

    @filename VARCHAR (MAX),

    @filebase64 VARCHAR (MAX)

AS

  --DECLARE  @StartDate VARCHAR(8)='20250709'

  --DECLARE  @EndDate VARCHAR(8)='20250709'

  --DECLARE  @EmployeeID VARCHAR(8)='00000001'

  --DECLARE  @AttendanceType VARCHAR(4)='1000'

  --DECLARE  @StartTime VARCHAR(4)=''

  --DECLARE  @StartLocation VARCHAR(100)=''

  --DECLARE  @EndTime VARCHAR(4)='1700'

  --DECLARE  @EndLocation VARCHAR(100)='PT Minova Infotech Solution'

  --DECLARE  @Notes VARCHAR(255)='From Maui With Image'

  --DECLARE  @CreateBy VARCHAR(50)='shofwan'

  --DECLARE  @ChangeBy VARCHAR(50)='shofwan'

  --DECLARE @filename VARCHAR (MAX)='00da52e6349840a78ae3e3ec59b3267a.jpg'

  --DECLARE @filebase64 VARCHAR (MAX)='/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAYEBQYFBAYGBQYHBwYIChAKCgkJChQODwwQFxQYGBcUFhYaHSUfGhsjHBYWICwgIyYnKSopGR8tMC0oMCUoKSj/2wBDAQcHBwoIChMKChMoGhYaKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCj/wAARCAJYAcIDASIAAhEBAxEB/8QAHAABAAIDAQEBAAAAAAAAAAAAAAYHAwQFAgEI/8QARxABAAADAgcLCAkDBAMBAAAAAAECAwQFERQWU1SSkwYHEhMVYnORobHRMzU2RXKDssIhMTRDUVJ0gcEyVXFBYYKzIiNEJP/EABoBAQADAQEBAAAAAAAAAAAAAAADBAUCAQb/xAAvEQEAAQIDBgQGAgMAAAAAAAAAAQIDE1FSBBESFDEzBRUygSFCYXGhwUGRIjSx/9oADAMBAAIRAxEAPwD9FgMBVAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABDd8OeaTk/gTTS4eM+qOD8qHcdVzk+tFQvbdFquaOHoiqu8M7ty4xTnHVc5PrROOq5yfWii8yjT+XON9FxinOOq5yfWicdVzk+tE8yjT+TG+i4xTnHVc5PrROOq5yfWieZRp/JjfRcYpzjqucn1onHVc5PrRPMo0/kxvouMU5x1XOT60Tjqucn1onmUafyY30XGKc46rnJ9aJx1XOT60TzKNP5Mb6LjFOcdVzk+tE46rnJ9aJ5lGn8mN9FxinOOq5yfWicdVzk+tE8yjT+TG+i4xTnHVc5PrROOq5yfWieZRp/JjfRcYpzjqucn1onHVc5PrRPMo0/kxvouMU5x1XOT60Tjqucn1onmUafyY30XGKc46rnJ9aJx1XOT60TzKNP5Mb6LjFOcdVzk+tE46rnJ9aJ5lGn8mN9FxinOOq5yfWicdVzk+tFrbHTzNvE6JKa+KN64xTnHVc5PrROOq5yfWitcp9XW9cYpzjqucn1onHVc5PrROU+pvXGKc46rnJ9aIcp9TeuMBTegAAAAAAAAAAAAAAAAAAAIXvjer/AHnyoYme+N6v958qGMDbe/V7f8VLnqkAVXAAAAAAAAAAAAAAAAAAAAAAAAAPNSpJSlw1J5ZIfVhmjgY8bs2kUdeD63wf/Wj7ysW/SzDDjdm0ijrwMbs2kUdeDUdsww43ZtIo68DG7NpFHXgDMMON2bSKOvABdoDHdgAAAAAAAAAAAAAAAAAAAIXvjer/AHnyoYme+N6v958qGMDbe/V7f8VLnqkAVXAAAAAAAAAAAAAAAAAAAAAAAACMb4PmWj+ol+GZXywd8HzLR/US/DMr59b4P/rR95WLfpAGo7AAAAfs8BjuwAAAAAAAAAAAHPmvm7ZZoyzW2hCaEcEYRnh9D5y3dmnWfXgq+2/bbR0k3ewgtblu7NOs+vA5buzTrPrwVSJKKIqS27cVx8Vrct3Zp1n14HLd2adZ9eCqR3hQkwIzWty3dmnWfXgct3Zp1n14KpDCgwIzSvd3brLbMRxWvTq8Dh8LgRw4MPBwdyKYQUrvhtF2ua5mfijq2Smqd+8wmEEflFvVLnkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqc0Y3wfM1H9RL8Myvlg74Pmaj+ol+GZXzS2WiNmt4dPxSU7NTTG7eALOLL3l4zADFk5eMwAxZOXjN+zwGcrgAAAAAAAAAAAKetv220dJN3sLNbftlfpJu9hAHivVkoUalWrHBTpyxmmjgw4IQhhi5GU906THZzeCe10WbHSXaHFynunSY7ObwMp7p0mOzm8Eqd2hxcp7p0mOzm8DKe6dJjs5vAHaHFynunSY7ObwMp7p0mOzm8AdocXKe6dJjs5vAynunSY7ObwB2hxcp7p0mOzm8DKe6dJjs5vAHaHFynunSY7ObwMp7p0mOzm8AdocXKe6dJjs5vAynunSY7ObwB2hxcp7p0mOzm8DKe6dJjs5vAHaHFynunSY7ObwMp7p0mOzm8AdocXKe6dJjs5vAynunSY7ObwB2hxcp7p0mOzm8DKe6dJjs5vAHaHFynunSY7ObwMp7p0mOzm8AdocXKe6dJjs5vAynunSY7ObwB2hxcp7p0mOzm8DKe6dJjs5vAHaHFynunSY7ObwMp7p0mOzm8AdocXKe6dJjs5vAynunSY7ObwBpb4PmWj+ol+GZXyZbsL3sV43ZSo2OrGpUlrQnjDgxh9HBmh/rD/eCH8Cb8AeR64E34HAm/AHkeuBN+BwJvwB5HrgTfgA/ZoCmzwAAAAAAAAAAAFPW37baOkm72Fmtv2yv0k3ewg0758z27oKnwxVUtW+fM9u6Cp8MVVJ7XRZsdJAEqcAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAB+yAFNngAAAAAAADxNUhLHBHC9ter5SKttV2q1RE0uap3MnGy/wC5xsv+7AM/nbrjilVNt+m2V+km72Fmtn2uv7c3ewuOfvIsWpp3z5nt3QVPhiqpat8+Z7d0FT4Yqqa3h1+u9TVNa/slU1RO8AaS2AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA/ZACmzwAAAAAAR/dLf89z16NOShLVhUljNhjNgwfS4+W1bQqevHwBOGvV8pFD8tq2hU9ePgxzbsqs02HE6evHwUfEJ3W4+6O5O6ExENyxq6HJrx8DLGrocmvHwY/FCLihG7Z9rr+3N3sL3Vn4yrPPGGDhTRmwf5eHCJp3z5nt3QVPhiqpat8+Z7d0FT4Yqqb3hHoq+7R2L0yANddAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAfsgBTZ4AAAAACC74f22ydHHvRJLd8P7bZOjj3okAAoeI9qPuivekAYqsAA0758z27oKnwxVUtW+fM9u6Cp8MVVN7wj0Vfdo7F6ZAGuugAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP0Jljef5bPqR8TLG8/y2fUj4o4PkuavamJx1ZpfdG6i32u8rPQqy0OBUmwRwSRhHvTHjZvwgrDc757sftrLdU7Vd1O6apmGTjZvwg9054zRwRwMDJQ/qj/AIT2L9yq5ETLuJnezgNhKgu+H9tsnRx70SS3fD+22To496JAAKHiPaj7or3pAGKrAANO+fpui3dBP8MVWcBal8eaLd0E/wAMVXLuy3a6Inhnc6puV0emXjgHAexb5m7qdcxc1PHAOA9hzN3Ucxc1Mc0MD49VP9HlbtXa5piZlSu7ZfiuYiqQBJiVZo+dv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65XCA+YXXR3O+e7H7ay1abnfPdj9tZbulJR0GSh/VH/AAxslD+qP+FjZu7Skp6s4DeTILvh/bbJ0ce9Ekt3w/ttk6OPeiQACh4j2o+6K96QBiqwADUvjzRbugn+GKrls1qclalPSqQ4Uk8sZZofjCP1uZk7deiw15vFNauRRHxeTCuRY2Tt16LDXm8TJ269FhrzeKXHpNyuRY2Tt16LDXm8TJ269FhrzeJj0m5W1T/R5TS/7nsNm4jiaEJeFwsP/lGP4f7uRiNnzfbFp7PVxW4mGdf9cuEO7iNnzfbExGz5vtinROEO7iNnzfbExGz5vtiDhDu4jZ832xMRs+b7Yg4Q7uI2fN9sTEbPm+2IOEO7iNnzfbExGz5vtiDhDu4jZ832xMRs+b7Yg4Q7uI2fN9sTEbPm+2IOEO7iNnzfbExGz5vtiDhDu4jZ832xMRs+b7Yg4Q7uI2fN9sTEbPm+2IOEO7iNnzfbExGz5vtiDhDu4jZ832xMRs+b7Yg4Q7uI2fN9sTEbPm+2IOEO7iNnzfbExGz5vtiDhDu4jZ832xMRs+b7Yg4Q7uI2fN9sTEbPm+2IOEO7iNnzfbEBYgD5prujud892P21lq03O+e7H7ay3dKSjoMlD+qP+GNkof1R/wALGzd2lJT1ZwG8mQXfD+22To496JJbvh/bbJ0ce9EgAFDxHtR90V70gDFVgAAAAAAAHC3Uf/N/y/hwXe3Uf/N/y/hwW3sfZhnX+5IAtIQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGhynbtMtG0icp27TLRtItQS4VGmP6bm5I9yF5W2bdNd0s1rrxhGrDDCM8fwXRjVfPVNaKjdx3pPd3Sw7l2GFRpgZsar56prRfYWu0Q+qvUh/yiwCLaKKabczEE9Gxjtp0irrRMdtOkVdaLXGNiVZo+Kc1f76l4WyS8LDwLVWl/9U31Tx/FBuU7dplo2kUv31vOFg6KbvQV1FdWZxS2+U7dplo2kTlO3aZaNpFqPkVvZP8AOuYq+PwdUzv6tvlO3aZaNpE5Tt2mWjaRag0cKjTH9Otzb5Tt2mWjaROU7dplo2kWoGFRpj+jc2+U7dplo2kTlO3aZaNpFqBhUaY/o3NvlO3aZaNpE5Tt2mWjaRagYVGmP6Nzb5Tt2mWjaROU7dplo2kWoGFRpj+jc6dltVe08LGK1SrwcGDhzRjgZ2ldv3n7fy3UdURE7oZW09yQB4gAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAcUBZbrs7jvSe7ulh3LsUnuO9J7u6WHcuwABBtPaqeVdABgola763nCwdFN3oKnW+t5wsHRTd6Cu46A+RfXyK7sPcn7OqeoA1UgAAAAAAADdu37z9v5brSu37z9v5bqCvqydp7sgDlAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA4o2uTbdoVp2U3gcm27QrTspvBNx05txv7jvSe7ulh3LsU3uSsFsp7pLvnqWW0SSQqwjGaanGEIfR/hchx05gAh2mumbVW6Xk9ABho1a763nCwdFN3oKnW+t5wsHRTd6Cu46A+RfXyK5sUxFc78nVPUAanHTm73gBx05m8AexMT0egD0AAbt2/eft/LdaV2/eft/LdQV9WTtPdkBhq2qz0Z+DVr0pJvwmnhCLlAzDWx+x6XZ9pDxMfsel2faQ8TdL3dLZGpG8rDCP022zbWXxOU7Bptl2svi94KsnWHXlLbGpynYNNsu1l8TlOwabZdrL4veCrIw68pbY1OU7Bptl2svi90rdZK1SFOjaqFSeP1Sy1IRjH9nnDVkTbqj+GwA8cA8z1JKcIRnnllhH8Y4HjGKOep60AZRixijnqetAxijnqetAiJn4Q9iJn4QyjFjFDPU9aBjFDPU9aDrDryl1h15SyjFjFDPU9aBjFDPU9aBh15SYdeUsoxYxQz1PWgyvJpmnrDyaZp6wAPHIAAMdevRs8kJ69WnSljHBCM80JYYf3YOU7Bptl2svi9imZ6Q6iiqfjENsanKdg02y7WXxOU7Bptl2svi94KsnuHXlLbGpynYNNsu1l8TlOwabZdrL4nBVkYdeUtsanKdg02y7WXxDgqyMOvKV7AMFqAAAAAAK131vOFg6KbvQVOt9bzhYOim70Fdx0AB6AAAAD4+vjS2H0y7pAF92AA3bt+8/b+W60rt+8/b+W6gr6snae7IrLd96Qz9HKs1WW770hn6OVJY9TrZfWjgC40HHr+Wqe1FjZK/lqntRY1yOjWp6QAD0STe79MLB7z/AK5kbSTe79MLB7z/AK5nF30VfaUO0dqr7SugBiPlXF3T+Qoe1HuR1It0/kKHtR7kdAAXvDu97L/hvf8AYAfQPoQABPEDTxkeK/J7/pj+LfJ7/oAZDHAAQvfY9HbP+ql+CdU62N9j0ds/6qX4J1TtXZO2+h8N7HuALK+AAAA/e4D4VjAAAAAAIHvjXRb7yttjnsNlqVpZKcYTRlwfRHCiOS99/wBurdniuoe7xSuS99/26t2eJkvff9urdniuoe8QpXJe+/7dW7PEyXvv+3VuzxXUHEPz7PJNJPNJPDBNLHBGH4ReWxePnC1dLN3xa70Hx9fGnsPpl3SAL7sABu3b95+38t1pXb95+38t1BX1ZO092RWW770hn6OVZqst33pDP0cqSx6nWy+tHAFxoOPX8tU9qLGyV/LVPaixrkdGtT0gAHokm936YWD3n/XMjaSb3fphYPef9czi76KvtKHaO1V9pXQAxHyri7p/IUPaj3I6kW6fyFD2o9yOgAL3h3e9l/w3v+wA+gfQgACeIGnjI8V+T3/TH8W+T3/QAyGOAAhe+x6O2f8AVS/BOqdbG+x6O2f9VL8E6p2rsnbfQ+G9j3AFlfAAAAfvcB8KxgAAAAAAAAAAAFB3j5wtXSzd8Wul1s3E3zVtdepJTo8GeeaaH/sh9UYsOQt9ZujtYO94i74lOQt95qjtYPmQt95qjtYL+x3aKIninc7plFxKMhb7zVHawMhb7zVHawXOYtanW+EXEoyFvvNUdrAyFvvNUdrA5i1qN8OJdv3n7fy3We1XFbbl4OPyyS8dh4HBm4X1fX3wYHM1RV8aejK2nuSKy3fekM/RyrNQrdXudvC8r3mtFlkpxpxkllwzT4I4YJbMxFXxe7PVFNe+UEEjyOvfN0dpAyOvfN0dpBaxKc13FozQSv5ap7UWNL6u4K+5qk00JKGCMYx8rB4yBvv8ln2q1F+3u9TSp2qzuj/KETEsyBvv8ln2pkDff5LPtTHt6nvN2dUImkm936YWD3n/AFzNjIG+/wAln2rs7kdyF63XuhslstctGFGnw+FGWphj9MkYQ+j/ADFxcvUTRMRP8Ir+02qrdURVHSVjgMl844u6fyFD2o9yOpFun8hQ9qPcjoAC94d3vZf8N7/sAPoH0IAAniBp4yPFfk9/0x/Fvk9/0AMhjgAIXvsejtn/AFUvwTqnXRu8ui1X1c9GzWGEkasteFSPDmwQwQlmh/MEDyBvv8ln2rR2W7RTb3TLc2C/bos7qqt0omJZkDff5LPtTIG+/wAln2qxj29S5zdnVCJiWZA33+Sz7UyBvv8AJZ9qY9vUc3Z1QiYlmQN9/ks+1DHt6jm7OqH7LAfFM4AAAAAAAAAAAAAAAAAAABCt8n1d7z5UJTbfJ9Xe8+VCWrs3bhnX+5IAnQgAAAAAAAAAOLun8hQ9qPcjqRbp/IUPaj3I6AAveHd72X/De/7AD6B9CAAJ4gaeMjxX5Pf9Mfxb5Pf9ADIY4AAAAAAAAAC6wGG1wAAAAAAAAAAAAAAAAAAAEK3yfV3vPlQlNt8n1d7z5UJauzduGdf7kgCdCAAAAAAAAAA4u6fyFD2o9yOpFun8hQ9qPcjoAC94d3vZf8N7/sAPoH0IAAniBp4yPFfk9/0x/Fvk9/0AMhjgAAAAAAAAALrAYbXAAAAAAAAAAAAAAAAAAAAQrfJ9Xe8+VCU23yfV3vPlQlr7NTM2oVLtiuuqaogAT8Eo+VuZABwScrcyADgk5W5kAHBJytzIAOCTlbmQAcEnK3MnF3T+Qoe1HuR1It0/kKHtR7kdOCTlbmQAt7HVFq7xV9FvYrVVq7xV9ABr87ZzbGPQAHO2czHoE8QNPGdt92m9w8H8b2b4hTN/h4P43gDO4JZ3K3MgA4JOVuZABwScrcyADgk5W5kAHBJytzIAOCTlbmS6wGCvgAAAAAAAAAAAAAAAAAAAIVvk+rvefKhKbb5Pq73nyoS3Nj7MJKegAsugAAAAAAAAAHF3T+Qoe1HuR1It0/kKHtR7kdAAAAAAATxA08AAAAAAAAAAAABdYD5pCAAAAAAAAAAAAAAAAAAAAgO+rWmo8l8DB9PG/X/wQHHKvN6k532/VXvfkV63Nj7MJKejZxyrzeoxyrzeprCy6bOOVeb1GOVeb1NYBs45V5vUY5V5vU1gGzjlXm9RjlXm9TWAbOOVeb1GOVeb1NYBs45V5vUY5V5vU1gC2/8A7JZZa31Sxww4P0NPk+jz+tuANPk+jz+s5Po8/rbgDT5Po8/rOT6PP624A0+T6PP6zk+jz+tuANPk+jz+t1ccq83qawDZxyrzeoxyrzeprANnHKvN6jHKvN6msA2ccq83qMcq83qawDZxyrzeoxyrzeprANnHKvN6jHKvN6msA2ccq83qGsA/QoD5pCAAAAAAAAAAAAAAAAAAAArzfb9Ve9+RXqwt9v1V735FetzY+zCSnoALLoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAB+hQHzSEAAAAAAAAAAAAAAAAAAABXm+36q978ivVhb7fqr3vyK9bmx9mElPQAWXQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD9CgPmkIAAAAAAAAAAAAAAAAAAACvN9v1V735FerC32/VXvfkV63Nj7MJKegAsugAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAH6FAfNIQAAAAAAAAAAAAAAAAAAAFeb7fqr3vyK9BubH2YSU9ABZdAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP/9k='

    SET NOCOUNT ON;

    -- Create a temporary table

    CREATE TABLE #TempTable (

        StartDate VARCHAR(8),

        EndDate VARCHAR(8),

        EmployeeID VARCHAR(8),

        Sequence INT,

        AttendanceType VARCHAR(4),

        StartTime VARCHAR(4),

        StartLocation VARCHAR(100),

        EndTime VARCHAR(4),

        EndLocation VARCHAR(100),

        Notes VARCHAR(255),

        CreateBy VARCHAR(50),

        CreateDate VARCHAR(14),

        ChangeBy VARCHAR(50),

        ChangeDate VARCHAR(14)

    );

	DECLARE @CreateDate VARCHAR (50)=FORMAT(GETDATE(), 'yyyyMMddHHmmss')

	DECLARE @ChangeDate VARCHAR (50)=FORMAT(GETDATE(), 'yyyyMMddHHmmss')

    -- Insert the input parameters into the temporary table

    INSERT INTO #TempTable (StartDate, EndDate, EmployeeID, Sequence, AttendanceType, StartTime, StartLocation, EndTime, EndLocation, Notes, CreateBy, CreateDate, ChangeBy, ChangeDate)

    VALUES (@StartDate, @EndDate, @EmployeeID, 1, @AttendanceType, @StartTime, @StartLocation, @EndTime, @EndLocation, @Notes, @CreateBy, @CreateDate, @ChangeBy, @ChangeDate);

    -- Get the maximum value of AuditorFlag and increment it

    DECLARE @MaxAuditorFlag INT;

    SELECT @MaxAuditorFlag = ISNULL(MAX(CAST(AuditorFlag AS INT)), 0) + 1

    FROM PHRPA0019 Where EmployeeID = @EmployeeID

	DECLARE @TransactionName VARCHAR(20) = 'InsertTransaction';

BEGIN TRANSACTION @TransactionName;

BEGIN TRY

    -- Update data into PHRPA0019

    UPDATE PHRPA0019 SET EndTime = (SELECT EndTime from #TempTable) where StartDate=@StartDate and EndDate=@EndDate and EmployeeID=@EmployeeID and AttendanceType=@AttendanceType;

    UPDATE PHRPA0019 SET EndLocation = (SELECT EndLocation from #TempTable) where StartDate=@StartDate and EndDate=@EndDate and EmployeeID=@EmployeeID and AttendanceType=@AttendanceType;

    -- Get the ID for PHRPA0019 insert

    DECLARE @InsertedID VARCHAR(10);

    SELECT @InsertedID = SCOPE_IDENTITY();

    -- Insert data into PHRPA0068

    UPDATE PHRPA0068 SET FileDataClockOut = @filebase64 WHERE id = (select top(1)AuditorFlag from PHRPA0019 where StartDate=@StartDate and EndDate=@EndDate and EmployeeID=@EmployeeID and AttendanceType=@AttendanceType)

    COMMIT TRANSACTION @TransactionName;

END TRY

BEGIN CATCH

    -- Error occurred, rollback transaction

    ROLLBACK TRANSACTION @TransactionName;

	-- Drop the temporary table

    IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL

        DROP TABLE #TempTable;

    -- Optionally, raise the error or handle it as per your application logic

    THROW;

END CATCH;

-- Drop the temporary table if transaction succeeded (normally)

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL

    DROP TABLE #TempTable;

  --select * from PHRPA0019 

  --where 

  --StartDate=@StartDate 

  --and EndDate=@EndDate 

  --and EmployeeID=@EmployeeID 

  --and AttendanceType=@AttendanceType