Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to use DataGear to make provincial / municipal secondary linkage drop-down box Kanban form, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand it.

Through the custom chart function of DataGear, you can easily make the provincial / municipal secondary linkage drop-down box Kanban form.

First, create two new datasets required for the drop-down boxes:

The first is the dataset required by the provincial drop-down box, taking the following CSV dataset as an example:

Name, value Beijing, bj Hebei, hb Shandong, sd Jiangsu, js

The second is the dataset required by the municipal drop-down box, taking the following SQL dataset as an example:

SELECT NAME, VALUEFROM T_CITYWHERE PARENT ='${province}'

This is a parameterized SQL dataset with the following parameters:

Name type required province string is

Example of TCY table data:

NAME, VALUE, PARENT Dongcheng District, dc, bj Haidian District, hd, bj Shijiazhuang, sjz, hb Langfang, lf, hb Jinan, jn, sd Texas, dz, sd Nanjing, nj, js Suzhou, sz, js...

Create two new custom charts using the above two datasets:

Chart type: custom dataset column tag: no need to tag chart type: custom dataset column tag: no tag required

Then, create a new visual Kanban and fill in the following Kanban template:

.select-province,.select-city {display: inline-block; padding: 0.5rem 1remt;} select, button {padding: 0.5rem 2remr; width: 10em.font-size: 1.2remt;} / / drop-down box chart renderer var selectChartRender = {render: function (chart) {var element = chart.elementJquery (); var options = chart.options () $(""). Attr ("name", options.name) .appendto (element);}, update: function (chart, results) {var datas = chart.resultDatas (chart.resultFirst (results)); var select = $("select", chart.elementJquery ()); select.empty (); for (var iTuno; I)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.