กรมบังคับคดี

กรมบังคับคดี

Array
(
    [statusCode] => 200
    [statusMessage] => Success
    [totalRow] => 5
    [page] => 18
    [GETpage] => 18
    [offset] => 153
    [totalPage] => 1
    [results] => Array
        (
        )

    [sql] => SELECT MAL.L_ID,
					MAL.L_LOT_NO,
					MAL.L_LOT_YEAR,
					MAL.L_LOT_SET,
					MAL.L_OFFER_TYPE,
					MAL.L_ANNOUNCE_DATE,
					MAL.SALE_DATE_END,
					MD.DEPT_FULL_NAME,
					MAO.O_ID,
					MAC.CC_RED_CASE_FULL,
					MAC.COURT_NAME,
					MAO.O_ORDER,
					MAC.C_ORDER,
					MAO.O_STATUS,
					MAO.DEED_AREA,
					MAO.ASSET_AREA,
					MAO.ASSET_NO1,
					MAO.ASSET_NO,
					MAO.DEED_NO,
					MAO.PROVINCE_NAME,
					MAO.AMPHUR_NAME,
					MAO.TAMBON_NAME,
					MAO.VILLAGE_NAME,
					MAO.O_SOLD_PRICE,
					MAO.O_PRICE_ANNOUNCE,
					MAO.TYPE_ID,
					MCC.CC_LAWS_CODE,
					MAO.O_VIEW,
					MAT.TYPE_NAME AS TYPE_NAME , 
					MBS.BID_STATUS_NAME AS BID_STATUS_NAME
				FROM M_AUCTION_LOT MAL
				INNER JOIN FRM_AUCTION_ROUND FAR on MAL.L_ID = FAR.WFR_ID
				INNER JOIN M_DEPARTMENT MD ON MAL.DEP_ID = MD.DEPARTMENT_ID
				INNER JOIN M_AUCTION_ORDER MAO ON MAL.L_ID = MAO.L_ID
				INNER JOIN M_AUCTION_CASE MAC ON MAO.C_ID = MAC.C_ID AND MAL.L_ID = MAC.L_ID
				INNER JOIN M_AUCTION_ORDER_ROUND MAOR ON MAL.L_ID = MAOR.L_ID AND MAO.O_ID = MAOR.O_ID AND FAR.F_ID = MAOR.R_ID
				INNER JOIN M_BID_STATUS MBS ON MAO.O_STATUS = MBS.BID_STATUS_CODE
				INNER JOIN M_CIVIL_CASE MCC ON MAO.CC_ID = MCC.CC_ID
				INNER JOIN M_ASSET_TYPE MAT on MAO.TYPE_ID = MAT.TYPE_ID
				WHERE MAO.O_CONFIRM = 'Y' 
				  	AND MAL.L_ANNOUNCE_DATE <= TO_DATE('2024-10-07', 'YYYY-MM-DD') 
					AND MAL.L_RELEASE_DATE <= TO_DATE('2024-10-07', 'YYYY-MM-DD') 
					AND MAL.SALE_DATE_END >= TO_DATE('2024-10-07', 'YYYY-MM-DD')
					AND MAO.O_PRICE_ANNOUNCE != 0  
				  
				  GROUP BY MAL.L_ID,
					MAL.L_LOT_NO,
					MAL.L_LOT_YEAR,
					MAL.L_LOT_SET,
					MAL.L_OFFER_TYPE,
					MAL.L_ANNOUNCE_DATE,
					MAL.SALE_DATE_END,
					MD.DEPT_FULL_NAME,
					MAO.O_ID,
					MAC.CC_RED_CASE_FULL,
					MAC.COURT_NAME,
					MAO.O_ORDER,
					MAC.C_ORDER,
					MAO.O_STATUS,
					MAO.DEED_AREA,
					MAO.ASSET_AREA,
					MAO.ASSET_NO1,
					MAO.ASSET_NO,
					MAO.DEED_NO,
					MAO.PROVINCE_NAME,
					MAO.AMPHUR_NAME,
					MAO.TAMBON_NAME,
					MAO.VILLAGE_NAME,
					MAO.O_SOLD_PRICE,
					MAO.O_PRICE_ANNOUNCE,
					MAO.TYPE_ID,
					MCC.CC_LAWS_CODE,
					MAO.O_VIEW,
					MAT.TYPE_NAME,
					MBS.BID_STATUS_NAME
				ORDER BY  MAL.L_LOT_NO ASC, MAL.L_LOT_YEAR ASC,  MAL.L_LOT_SET ASC, MAC.C_ORDER ASC, MAO.O_ORDER ASC NULLS LAST
    [get] => Array
        (
            [page] => 18
            [lang] => th
        )

)