wa_price_excel: =G2&"-"&H2&"/"&I2&"/"&J2
1.UTM to mapsheet
CASE
WHEN "UTMMAP2" = '1' THEN "UTMMAP1" || 'I' || "UTMMAP3" || '-' || RIGHT('00' || "UTMMAP4",2)
WHEN "UTMMAP2" = '2' THEN "UTMMAP1" || 'II' || "UTMMAP3" || '-' || RIGHT('00' || "UTMMAP4",2)
WHEN "UTMMAP2" = '3' THEN "UTMMAP1" || 'III' || "UTMMAP3" || '-' || RIGHT('00' || "UTMMAP4",2)
WHEN "UTMMAP2" = '4' THEN "UTMMAP1" || 'IV' || "UTMMAP3" || '-' || RIGHT('00' || "UTMMAP4",2)
END
1. แสดงเลขที่ดินและรหัสประจำแปลงที่ดิน
' '+"land_no"||'\n'||'('||"parcel_cod"||')'
2. แสดงรหัสโรงเรือนและเลขที่บ้าน
building_c || '\n' || hs_no
3. แสดงรหัสประจำแปลงที่ดิน เลขที่ดิน และหน้าสำรวจ
parcel_cod || '\n' || land_no || '\n' || survey
4. รวม UTM เป็น (mapsheet)
UTMMAP1 || UTMMAP2 || right ( '0000' || UTMMAP3,4 ) || ' - ' || UTMMAP4
mapsheet || '/' || land_no
land_no || '/' || mapsheet
book_title || book_fname || ' ' || book_lname || '\n' || book_rai || 'ไร่ ' || book_ngan || 'งาน ' || book_wa || 'ต.ร.ว.'
book_parcel_no|| ' /' || parcel_cod|| '\n' ||book_title || book_fname || ' ' || book_lname || '\n' || book_rai || 'ไร่ ' || book_ngan || 'งาน ' || book_wa || 'ต.ร.ว.'
"parcel_cod" || '\n' ||"title_name" || "first_name" ||' '|| "last_name" || '\n' || "rai" || 'ไร่ '|| "yawn" || 'งาน ' || "wa" || 'ต.ร.ว.'
"parcel_cod" || '\n'
||"title_name" || "first_name" ||' '|| "last_name" || '\n'
|| "rai" || 'ไร่ '|| "yawn" || 'งาน ' || "wa" || 'ต.ร.ว.' || '\n'
|| "wa_price" || 'บาท ต่อตร.ว.'
case
when dn <> '' and land_type like 'โฉนด%' then 'NS4-' || dn
when dn <> '' and land_type = 'น.ส.3' then 'NS3-' || dn
when dn <> '' and land_type = 'น.ส.3ก' then 'N3A-' || dn
when dn <> '' and land_type = 'ส.ป.ก.4-01' then 'SPK-' || dn
END
"parcel_cod" || '\n' ||"title_name" || "first_name" ||' '|| "last_name" || '\n' || "rai" || 'ไร่ '|| "yawn" || 'งาน ' || "wa" || 'ต.ร.ว.'
"parcel_cod" || '\n'
||"title_name" || "first_name" ||' '|| "last_name" || '\n'
|| "rai" || 'ไร่ '|| "yawn" || 'งาน ' || "wa" || 'ต.ร.ว.' || '\n'
|| "wa_price" || 'บาท ต่อตร.ว.'
case
when dn <> '' and land_type like 'โฉนด%' then 'NS4-' || dn
when dn <> '' and land_type = 'น.ส.3' then 'NS3-' || dn
when dn <> '' and land_type = 'น.ส.3ก' then 'N3A-' || dn
when dn <> '' and land_type = 'ส.ป.ก.4-01' then 'SPK-' || dn
END
ไม่มีความคิดเห็น:
แสดงความคิดเห็น