04-07-2025==04-07-2025===2025-07-04select ifnull(count(*),0) nwd from EMPMILL12.tbl_non_working_days tnwd where is_active=1 and  non_working_date='2025-07-04'<br>select ifnull(count(*),0) nwd from EMPMILL12.tbl_non_working_days tnwd where is_active=1 and  non_working_date>= DATE_SUB('2025-07-04', INTERVAL 10 DAY)39UPDATE EMPMILL12.tbl_hrms_absent_warning_data thawd
SET join_tag = 1, 
    close_tag = 1
WHERE thawd.eb_id IN (
    SELECT k.eb_id 
    FROM (
        SELECT
            eb_id,
            MAX(pdate) AS pdate
        FROM (
            SELECT
                eb_id,
                MAX(attendance_date) AS pdate
            FROM
                daily_attendance da
            WHERE
                company_id = 2
                AND is_active = 1
                AND attendance_date = '2025-07-04'
            GROUP BY
                eb_id
            UNION ALL
            SELECT
                eb_id,
                MAX(ltd.leave_date) AS pdate
            FROM
                leave_transactions lt
                JOIN leave_tran_details ltd ON lt.leave_transaction_id = ltd.ltran_id
            WHERE
                lt.company_id = 2
                AND ltd.is_active = 1
                AND ltd.leave_date = '2025-07-04'
            GROUP BY
                eb_id
            UNION ALL
            SELECT
                eb_id,
                MAX(tdra.ret_attend_date) AS pdate
            FROM
                EMPMILL12.tbl_daily_ret_attendance tdra
            WHERE
                company_id = 2
                AND is_active = 1
                AND ret_attend_date = '2025-07-04'
            GROUP BY
                eb_id
        ) AS g
        GROUP BY
            eb_id
    ) AS k
    WHERE k.pdate IS NOT NULL
)2025-07-04 22:07:02 SERVER -&gt; CLIENT: 220 smtp.gmail.com ESMTP 41be03b00d2f7-b38ee44fc67sm2780032a12.5 - gsmtp<br>
2025-07-04 22:07:02 CLIENT -&gt; SERVER: EHLO 13.126.47.172<br>
2025-07-04 22:07:03 SERVER -&gt; CLIENT: 250-smtp.gmail.com at your service, [13.126.47.172]250-SIZE 36700160250-8BITMIME250-STARTTLS250-ENHANCEDSTATUSCODES250-PIPELINING250-CHUNKING250 SMTPUTF8<br>
2025-07-04 22:07:03 CLIENT -&gt; SERVER: STARTTLS<br>
2025-07-04 22:07:03 SERVER -&gt; CLIENT: 220 2.0.0 Ready to start TLS<br>
2025-07-04 22:07:03 CLIENT -&gt; SERVER: EHLO 13.126.47.172<br>
2025-07-04 22:07:03 SERVER -&gt; CLIENT: 250-smtp.gmail.com at your service, [13.126.47.172]250-SIZE 36700160250-8BITMIME250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH250-ENHANCEDSTATUSCODES250-PIPELINING250-CHUNKING250 SMTPUTF8<br>
2025-07-04 22:07:03 CLIENT -&gt; SERVER: AUTH LOGIN<br>
2025-07-04 22:07:03 SERVER -&gt; CLIENT: 334 VXNlcm5hbWU6<br>
2025-07-04 22:07:03 CLIENT -&gt; SERVER: [credentials hidden]<br>
2025-07-04 22:07:04 SERVER -&gt; CLIENT: 334 UGFzc3dvcmQ6<br>
2025-07-04 22:07:04 CLIENT -&gt; SERVER: [credentials hidden]<br>
2025-07-04 22:07:04 SERVER -&gt; CLIENT: 535-5.7.8 Username and Password not accepted. For more information, go to535 5.7.8  https://support.google.com/mail/?p=BadCredentials 41be03b00d2f7-b38ee44fc67sm2780032a12.5 - gsmtp<br>
2025-07-04 22:07:04 SMTP ERROR: Password command failed: 535-5.7.8 Username and Password not accepted. For more information, go to535 5.7.8  https://support.google.com/mail/?p=BadCredentials 41be03b00d2f7-b38ee44fc67sm2780032a12.5 - gsmtp<br>
SMTP Error: Could not authenticate.<br>
2025-07-04 22:07:04 CLIENT -&gt; SERVER: QUIT<br>
2025-07-04 22:07:04 SERVER -&gt; CLIENT: 221 2.0.0 closing connection 41be03b00d2f7-b38ee44fc67sm2780032a12.5 - gsmtp<br>
SMTP Error: Could not authenticate.<br>
Message could not be sent. Mailer Error: SMTP Error: Could not authenticate.File has been deleted