TAAS

GUI Done

ISSUE FOUNDED
1.CORRECT ALLIGMENT OF BRANCH FIELD
2.CORRECT GRID FILTER FIELDS WHILE EXPANDING
3.ADD ERASE OPTION

Note:- This logic and SQL not full fill, Coding this logic base and commit, I(Anil) will fix all cases
Ref: Document History
SQL:-

    SELECT tr.dat_transaction,
            tr.vhr_ledg_currency,
            tr.dbl_ledg_cur_debit,
        tr.dbl_ledg_cur_credit.
            tr.dbl_base_cur_debit,
        tr.dbl_base_cur_credit,
        tr.dbl_cons_cur_debit,
            tr.dbl_cons_cur_credit,

            NULL AS int_sys_action_log_id,
            NULL AS fk_created_user_log_id,
        NULL AS dtm_created_log,
        NULL AS fk_last_modified_user_log_id,
        NULL AS dtm_last_modified_log,
        NULL AS fk_deleted_user_log_id,
        NULL AS dtm_deleted_log,

        doc.pk_documents_id,
            doc.vhr_document_no,
            doc.fk_ledger_id,
        doc.int_sys_action_id,
            doc.fk_created_user_id,
        doc.dtm_created,
        doc.fk_last_modified_user_id,
        doc.dtm_last_modified,
        doc.fk_deleted_user_id,
        doc.dtm_deleted
        FROM transaction.tbl_transaction tr
            LEFT JOIN document.tbl_documents doc
                ON tr.fk_documents_id = doc.pk_documents_id
        WHERE tr.sin_posting_status = 1
            AND tr.sin_transaction_status = 1
            AND tr.sin_document_status = 1
            AND tr.fk_ledger_id = 1
            AND tr.fk_main_ledger_id = 1
            AND tr.fk_branch_id = 1
            AND tr.fk_department_id = 1

         UNION ALL

    SELECT trlog.dat_transaction,
            trlog.vhr_ledg_currency,
            trlog.dbl_ledg_cur_debit,
        trlog.dbl_ledg_cur_credit.
            trlog.dbl_base_cur_debit,
        trlog.dbl_base_cur_credit,
        trlog.dbl_cons_cur_debit,
            trlog.dbl_cons_cur_credit,

        doclog.int_sys_action_id AS int_sys_action_log_id,
            doclog.fk_created_user_id AS fk_created_user_log_id,
        doclog.dtm_created AS dtm_created_log,
        doclog.fk_last_modified_user_id AS fk_last_modified_user_log_id,
        doclog.dtm_last_modified AS dtm_last_modified_log,
        doclog.fk_deleted_user_id AS fk_deleted_user_log_id,
        doclog.dtm_deleted AS dtm_deleted_log,

        doc.pk_documents_id,
            doc.vhr_document_no,
            doc.fk_ledger_id,
        doc.int_sys_action_id,
            doc.fk_created_user_id,
        doc.dtm_created,
        doc.fk_last_modified_user_id,
        doc.dtm_last_modified,
        doc.fk_deleted_user_id,
        doc.dtm_deleted
        FROM tbl_transaction trlog
        LEFT JOIN tbl_documents_log doclog
                ON trlog.fk_documents_log_id = doclog.pk_documents_log_id
            LEFT JOIN document.tbl_documents doc
                ON trlog.fk_documents_id = doc.pk_documents_id
        WHERE trlog.sin_posting_status = 1
            AND trlog.sin_transaction_status = 1
            AND trlog.sin_document_status = 1
            AND trlog.fk_ledger_id = 1
            AND trlog.fk_main_ledger_id = 1
            AND trlog.fk_branch_id = 1
            AND trlog.fk_department_id = 1

Input Change
--------------
datActionDateTo = datActionDateTo Add 1 Day
//datActionDateFrom and datActionDateTo ['01/01/2024 00:00:00'] time part need 0

SQL
=====

Logic
--------------
blnOlbObSetedADoc = False
blnMainDocumentRecordIn = True
blnMainDocumentRecord = False
blnLastLogRecord = False
binPrvDocumentId = 0
binPrvDocumentLogId = 0 
dblPrevTransactionAmount = 0.00
dblOldBalance = 0.00
strTab = ''
lstEachLedgerHistoryData = []
For loop Database Record
        // Create Model
        // Fill the record to Modele

    blnMainDocumentRecord = False
    blnLastLogRecord = False
        if binPrvDocumentId != binDocumentId
        blnOlbObSetedADoc = False
        dblPrevTransactionAmount = 0

        // Set Prv Document 
        if lstEachLedgerHistoryData.legth > 0
                        // ReCheck Tab
            if binPrvDocumentLogId is NULL/0 and strTab == 'UPDATED'
                strTab = 'LEDGER_CHANGED'
            END IF

            // Some value Calculation - Previous, Diff

            // Set Data
            if  strTab == "NEW" 
                         lstNew = [...lstNew, ...lstEachLedgerHistoryData]
                else if strTab == "UPDATED" 
                         lstUpdated = [...lstUpdated, ...lstEachLedgerHistoryData]
                ...
            END IF

            lstEachLedgerHistoryData = []
        END IF

        strTab = ''
        if pk_documents_log_id is NULL/0
            blnMainDocumentRecord = True
            blnMainDocumentRecordIn = True
                        if int_sys_action_id >= 1 AND  dtm_created and datActionDateFrom < dtm_created and dtm_created < datActionDateTo
                strTab = 'NEW'
                    else if int_sys_action_id > 1 AND dtm_last_modified and datActionDateFrom < dtm_last_modified and dtm_last_modified < datActionDateTo
                                strTab = 'UPDATED'
                if dtm_created and (datActionDateFrom > dtm_created or dtm_created > datActionDateTo)
                    strTab = 'PERIOD_CHANGED'
                END IF
                        elseif int_sys_action_id == -1 AND dtm_deleted and datActionDateFrom < dtm_deleted and dtm_deleted < datActionDateTo
                strTab = 'DELETED'

        else
            blnLastLogRecord = True
            blnMainDocumentRecordIn = False
            strTab = 'LEDGER_CHANGED'
                END IF
    END IF

    // ReCheck Tab
    //if blnMainDocumentRecordIn == False:
    //END IF

    // Calculate
    dblDiffAmount = (debit - credit) - dblPrevTransactionAmount
    if int_sys_action_id == -1
        dblDiffAmount = (debit - credit)
    END IF 

    if  strTab == "NEW" 
        dblTotalNew += 
    else if strTab == "UPDATED" 
    else if strTab == "PERIOD_CHANGED" 
    else if strTab == "LEDGER_CHANGED" 
    else if strTab == "DELETED" 
    END IF

    if pk_documents_log_id and blnOlbObSetedADoc == False
        if int_sys_action_id > 1 AND dtm_last_modified and datActionDateFrom < dtm_last_modified 
            dblOldBalance += (debit - credit)
            blnOlbObSetedADoc = True
        END IF
        ELSE if int_sys_action_id == -1 AND dtm_deleted and datActionDateFrom < dtm_deleted
            dblOldBalance += (debit - credit)
            blnOlbObSetedADoc = True
        END IF
    END IF

        // Set Record in tmp list
    lstEachLedgerHistoryData.Add(Model)

        // Set Prv doc id
        binPrvDocumentId = binDocumentId
    binPrvDocumentLogId = binDocumentLogId
    dblPrevTransactionAmount = debit - credit
        END LOOP

// Set Last Document Data
if lstEachLedgerHistoryData.legth > 0
        // ReCheck Tab
    if binPrvDocumentLogId is NULL/0 and strTab == 'UPDATED'
        strTab = 'LEDGER_CHANGED'
    END IF

    // Set Data
    if  strTab == "NEW" 
                 lstNew = [...lstNew, ...lstEachLedgerHistoryData]
        else if strTab == "UPDATED" 
                 lstUpdated = [...lstUpdated, ...lstEachLedgerHistoryData]
        ...
    END IF

ISSUE FOUND
-------------------------------------------
1. Not filtering data based on the user field.
2. Print of summary tab not in correct format.