Infrastructure codes - Revision history

Angus at 14:05, 17 September 2014

2014-09-17T14:05:03Z

2014-09-17T14:04:34Z

2014-09-17T14:03:22Z

‎Bahasa Indonesia

2014-09-17T14:02:21Z

‎Bahasa Indonesia

2014-09-17T14:01:20Z

‎Bahasa Indonesia

2014-09-17T13:35:30Z

2014-09-17T13:33:41Z

2014-09-17T13:32:58Z

2014-09-17T13:30:38Z

2014-09-17T13:30:08Z

@@ Baris 1: / Baris 1: @@
 ==Infrastructure Type codes==
 {{#apGetSQL:select hiercode, code,
@@ Baris 17: / Baris 15: @@
 where not del
 order by hiersort(hiercode)|Hierarchy, Kode, Jenis Infrastruktur, Infrastructure Type}}

@@ Baris 4: / Baris 4: @@
 {{#apGetSQL:select hiercode, code,
-   case when array_length(string_to_array(hiercode,'.'),1) = 1 then
+   left(case when array_length(string_to_array(hiercode,'.'),1) = 1 then
      format('<b>%s</b>', hierindent(name[1],hiercode, true))
    else
      hierindent(name[1],hiercode, true)
-   end,
+   end, 80),
    case when array_length(string_to_array(hiercode,'.'),1) = 1 then
      format('<b>%s</b>', hierindent(name[2],hiercode, true))

@@ Baris 5: / Baris 5: @@
 {{#apGetSQL:select hiercode, code,
    case when array_length(string_to_array(hiercode,'.'),1) = 1 then
-     format('<H2>%s</h2>', hierindent(name[1],hiercode, true))
+     format('<b>%s</b>', hierindent(name[1],hiercode, true))
    else
      hierindent(name[1],hiercode, true)
    end
 from infrastructure_types
 where not del
-order by hiersort(hiercode)|Hierarchy, Kode, Jenis Infrastruktur}}
+order by hiersort(hiercode)|Hierarchy, Kode, Jenis Infrastruktur, Infrastructure Type}}
 ==English==

@@ Baris 5: / Baris 5: @@
 {{#apGetSQL:select hiercode, code,
    case when array_length(string_to_array(hiercode,'.'),1) = 1 then
-     format('<b>%s</b>', hierindent(name[1],hiercode, true))
+     format('<H2>%s</h2>', hierindent(name[1],hiercode, true))
    else
-     hierindent(name[1],hiercode, false)
+     hierindent(name[1],hiercode, true)
    end
 from infrastructure_types

@@ Baris 3: / Baris 3: @@
 ==Bahasa Indonesia==
-{{#apGetSQL:select hiercode, code, hierindent(name[1],hiercode, true)
+{{#apGetSQL:select hiercode, code,
 from infrastructure_types
 where not del

@@ Baris 12: / Baris 12: @@
-{{#apGetSQL:select hiercode, code, hierindent(name[1],hiercode, true),hierindent(name[2],hiercode, true)
+{{#apGetSQL:select hiercode, code, hierindent(name[1],hiercode, true), hierindent(name[2],hiercode, true)
 from infrastructure_types
 where not del
-order by hiersort(hiercode)|Hierarchy, Kode, Jenis Infrastruktur, Infrastructure Type}}
+order by hiersort(hiercode)|Hierarchy, Kode, Infrastruktur, Infrastructure Type}}