{"CLASS":"Section"}
{"INPUT":{"debug":"1"}}
{"OPTIONS":{"app":"locus","dir":"app\/","tpl":"granum","\/\/tpl":"granum|d1|none","date_format":"Y-m-d H:i","db":["app\/data\/locus.sqlite"],"password":"$2y$10$JUfAMGJW4cIMP81B5okomePpccUrxFMqwpsn.xVDzBqYbPIH8QlJ6","semantic_url":true,"asset_version":true,"allow_content":["unpkg.com","jsdelivr.com","jquery.com","picsum.photos","youtube.com"],"logfile":"app\/tmp\/{type}-{Y-m}.log","admin_email":"vadimkor@ya.ru","fake_email":true,"\/\/recaptcha":["site-key","secret-key"],"\/\/icon":"asset\/favicon.png","icon":"data:image\/svg+xml,%3Csvg xmlns='http:\/\/www.w3.org\/2000\/svg' viewBox='0 0 10 10'%3E%3Cpath fill='%2305b' d='M2 4a3 3 0 0 1 6 0q0 2 -3 5q-3-3-3-5zm3 -2a2 2 0 1 0 .01 0z'\/%3E%3C\/svg%3E","css":"asset\/app.css","js":"asset\/app.js","\/\/route":"view","routes":{"file":["f","Load"],"search":["search","Finder"],"profile":["profile","Profiler"],"api":["api","API"],"edit":["edit","Editor"],"add":["add","Editor"],"delete":["del","Editor"],"sql":["sql","RunSQL"],"phpinfo":["pi","SysInfo"],"view":["","Section"]},"sub":"projects\/locus\/","path":"en\/modules\/chart","request":"en\/modules\/chart","debug":"1","route":"view"}}
DB connection (class: Sqlite) [sqlite:app/data/locus.sqlite]: (0 msec) OK
SQL#1 (0 msec) [OK 0] [pragma foreign_keys = ON]
SQL#2 (0 msec) [OK 0] [select * from sec where url = :key limit 1 offset 0] {Array
(
[key] => en/modules/chart
)
}
ROW: Array
(
[id] => 915
[sec_id] => 1046
[dst_sec_id] =>
[url] => en/modules/chart
[e] => 1
[zone] => nav
[nm] => Chart
[excerpt] =>
[body] => ## Bar
{{Chart
b,Water,Gas,Light
2000,5,3,7
2005,5,2,5
2010,7,4,9
2015,11,8,12
}}
```
{{Chart
b,Water,Gas,Light
2000,5,3,7
2005,5,2,5
2010,7,4,9
2015,11,8,12
}}
```
## Bar stacked, custom colors
{{Chart
b+,Water#9cf,Gas#c9c,Light#ee9
2000,5,3,7
2005,6,2,5
2010,8,4,9
2015,11,8,12
}}
```
{{Chart
b+,Water#9cf,Gas#c9c,Light#ee9
2000,5,3,7
2005,6,2,5
2010,8,4,9
2015,11,8,12
}}
```
## Bar stacked horizontal, flipped
{{Chart
h+*,Water,Gas,Light
2000,5,3,7
2005,5,2,5
2010,7,4,9
2015,11,8,12
}}
```
{{Chart
h+*,Water,Gas,Light
2000,5,3,7
2005,5,2,5
2010,7,4,9
2015,11,8,12
}}
```
## Line
{{Chart
l,Water,Gas,Light
2000,5,3,7
2001,6,2,5
2010,8,4,9
2015,11,8,12
}}
```
{{Chart
l,Water,Gas,Light
2000,5,3,7
2001,6,2,5
2010,8,4,9
2015,11,8,12
}}
```
## Line interpolated, with gaps and time axis
{{Chart
l'~,Water,Gas,Light
2000,5,3,7
2001,6,2,5
2010,,4,9
2015,11,8,12
}}
```
{{Chart
l'~,Water,Gas,Light
2000,5,3,7
2001,6,2,5
2010,,4,9
2015,11,8,12
}}
```
## Line stacked interpolated
{{Chart
l+~,Water,Gas,Light
2000,5,3,7
2001,6,2,5
2010,8,4,9
2015,11,8,12
}}
```
{{Chart
l+~,Water,Gas,Light
2000,5,3,7
2001,6,2,5
2010,8,4,9
2015,11,8,12
}}
```
## Pie, custom colors
{{Chart
d,Water
2000#6d6,5
2005#6c8,6
2010#6ba,8
2015#6ac,11
}}
```
{{Chart
d,Water
2000#6d6,5
2005#6c8,6
2010#6ba,8
2015#6ac,11
}}
```
## With table and skipped column
{{Chart
b#ft
Name, Date,Amount
One,01.02.2003,5
Two,21.11.2000,20
Three,11.07.2007,3
}}
```
{{Chart
b#ft
Name, Date,Amount
One,01.02.2003,5
Two,21.11.2000,20
Three,11.07.2007,3
}}
```
[seq] => 4
[h1] =>
[title] =>
[descr] =>
[pub_dt] => 0
[fn] =>
[icon] =>
)
SQL#3 (0 msec) [OK 0] [select id, e, sec_id, dst_sec_id, nm, h1, title, url, zone, icon, seq, pub_dt from sec where (e=1 and pub_dt < :ut) and (sec_id is null) order by seq] {Array
(
[ut] => 1791541244
)
}
ROWS: 2
SQL#4 (0 msec) [OK 0] [select id, e, sec_id, dst_sec_id, nm, h1, title, url, zone, icon, seq, pub_dt from sec where (e=1 and pub_dt < :ut) order by seq] {Array
(
[ut] => 1791541244
)
}
ROWS: 84
SQL#5 (0 msec) [OK 0] [select * from sec where (e=1 and pub_dt < :ut) and (sec_id = :id and zone = :z) order by seq] {Array
(
[id] => 915
[z] => content
[ut] => 1791541244
)
}
ROWS: 0
SQL#6 (0 msec) [OK 0] [select * from sec where (e=1 and pub_dt < :ut) and (sec_id = :id and zone = :z) order by seq] {Array
(
[id] => 915
[z] => file
[ut] => 1791541244
)
}
ROWS: 0
SQL#7 (0 msec) [OK 0] [select * from sec where (e=1 and pub_dt < :ut) and (sec_id = :id and zone = :z) order by seq] {Array
(
[id] => 915
[z] => aside
[ut] => 1791541244
)
}
ROWS: 0
SQL#8 (0 msec) [OK 0] [select * from sec where (e=1 and pub_dt < :ut) and (sec_id = :id and zone = :z) order by seq] {Array
(
[id] => 37
[z] => aside
[ut] => 1791541244
)
}
ROWS: 0