}

	iv := DB.Table(`table_invoices`).Select(`seller, SUM(total) as total, SUM(paid) as paid, SUM(balance) as balance`).Group(`seller`)
	stmt = dryDB.Table(`table_employees`).Select(`id, name, iv.total, iv.paid, iv.balance`).Joins(`LEFT JOIN (?) AS iv ON iv.seller = table_employees.id`, iv).Scan(&user).Statement

        decodedSmb.decode(buffer, 0);

        assertEquals(smb.command, decodedSmb.command);
        assertEquals(smb.mid, decodedSmb.mid);
        assertEquals(smb.pid, decodedSmb.pid);
        assertEquals(smb.tid, decodedSmb.tid);
        assertEquals(smb.uid, decodedSmb.uid);
        assertEquals(smb.flags2, decodedSmb.flags2);
        assertEquals(smb.wordCount, decodedSmb.wordCount);

     * @return the tid
     */
    public final int getTid() {
        return this.tid;
    }

    /**
     * @param tid
     *            the tid to set
     */
    @Override
    public final void setTid(final int tid) {
        this.tid = tid;
    }

    /**
     * Gets the process identifier
     * @return the pid
     */
    public final int getPid() {

        return "command=" + c + ",received=" + received + ",errorCode=" + str + ",flags=0x" + Hexdump.toHexString(flags & 0xFF, 4)
                + ",flags2=0x" + Hexdump.toHexString(flags2, 4) + ",signSeq=" + signSeq + ",tid=" + tid + ",pid=" + pid + ",uid=" + uid
                + ",mid=" + mid + ",wordCount=" + wordCount + ",byteCount=" + byteCount;
    }

            andx.command = andxCommand;
            andx.errorCode = errorCode;
            andx.flags = flags;
            andx.flags2 = flags2;
            andx.tid = tid;
            andx.pid = pid;
            andx.uid = uid;
            andx.mid = mid;
            andx.useUnicode = useUnicode;

            if (andx instanceof AndXServerMessageBlock) {

        }

        @Test
        @DisplayName("Test TID property")
        void testTidProperty() {
            assertEquals(0xFFFF, testBlock.getTid());
            testBlock.setTid(0x1234);
            assertEquals(0x1234, testBlock.getTid());
        }

        @Test
        @DisplayName("Test PID property")
        void testPidProperty() {
            testBlock.setPid(0x5678);

            buffer[i] = 0x00;
        }

        // Reserved (2 bytes)
        buffer[22] = 0x00;
        buffer[23] = 0x00;

        // TID (2 bytes)
        buffer[24] = 0x01;
        buffer[25] = 0x00;

        // PID (2 bytes)
        buffer[26] = 0x02;
        buffer[27] = 0x00;

        // UID (2 bytes)
        buffer[28] = 0x03;
        buffer[29] = 0x00;

        // Given
        int tid = 12345;
        doNothing().when(request).setTid(tid);

        // When
        request.setTid(tid);

        // Then
        verify(request, times(1)).setTid(tid);
    }

    @Test
    @DisplayName("Test setTid with zero value")
    void testSetTidWithZero() {
        // Given
        int tid = 0;
        doNothing().when(request).setTid(tid);

            // Test minimum valid TID
            smb2Response.setTreeId(0);
            assertTrue(smb2Response.isValidTid(), "TID 0 should be valid");

            // Test maximum valid TID
            smb2Response.setTreeId(Integer.MAX_VALUE);
            assertTrue(smb2Response.isValidTid(), "Maximum TID should be valid");

            // Test invalid TID
            smb2Response.setTreeId(-1);

    /** Open function fail if exists */
    int OPEN_FUNCTION_FAIL_IF_EXISTS = 0x0000;
    /** Open function overwrite if exists */
    int OPEN_FUNCTION_OVERWRITE_IF_EXISTS = 0x0020;

    /** Process ID */
    int PID = (int) (Math.random() * 65536d);

    /** Share level security */
    int SECURITY_SHARE = 0x00;
    /** User level security */
    int SECURITY_USER = 0x01;

    /** Command offset in SMB header */