Flask render_template如何做二級導航

woff

展示圖：

Flask render_template 二級導航

app.py

1. def main_nav():
   
2.     conn = check_db_connection()
   
3.     cursor = conn.cursor(dictionary=True)
   
4. 
   
5.     sm_classes = []
   
6.     sm_states = []
   
7.     # 提取導覽列無列表資料
   
8.     sql = "SELECT * FROM net_class where liston=0 ORDER BY num ASC"
   
9.     cursor.execute(sql)
   
10.     result = cursor.fetchall()
    
11. 
    
12.     for row_class in result:
    
13.         sm_classes.append({"cid": row_class["cid"], "num": row_class["num"], "name": row_class["name"], "img": row_class["img"]})
    
14. 
    
15.         sql = "SELECT * FROM net_state WHERE cid="+str(row_class["cid"])+" ORDER BY num ASC"
    
16.         cursor.execute(sql)
    
17.         result = cursor.fetchall()
    
18.         for row_state in result:
    
19.             sm_states.append({"hid": row_state["hid"], "cid": row_state['cid'], "num": row_state['num'],"subject": row_state['subject']})
    
20. 
    
21. 
    
22.     sm_classes1 = []
    
23.     # 提取導覽列無列表資料
    
24.     sql = "SELECT * FROM net_class where liston=1 ORDER BY num ASC"
    
25.     cursor.execute(sql)
    
26.     result = cursor.fetchall()
    
27. 
    
28.     for row_class1 in result:
    
29.         sm_classes1.append({"cid": row_class1["cid"], "num": row_class1["num"], "name": row_class1["name"],
    
30.                             "img": row_class1["img"]})
    
31. 
    
32.     return  sm_classes, sm_classes1, sm_states
    
33. 
    
34. @app.route("/", methods=['GET'])
    
35. def index():
    
36.     # get web_config
    
37.     webname , weburl , phone , address, img  = web_config()
    
38.     # get main nav classes
    
39.     sm_classes,sm_classes1 ,sm_states= main_nav()
    
40. 
    
41. return render_template("public/index.html",ny_root_path = request.root_url, webname = webname, weburl = weburl, phone = phone, address = address, img = img,
    
42.                            lenclasses = len(sm_classes),sm_classes = sm_classes,sm_classes1 = sm_classes1)
    

複製代碼

index.html

1. {% for sm_class1 in sm_classes1 %}
   
2.                     <li><a href="{{ny_root_path}}statelist?cid={{sm_class1.cid}}">{{sm_class1.name}}</a></li>
   
3.                     {% endfor %}
   
4.                     {% for i in range(lenclasses) %}
   
5.                     <li><a href="{{ny_root_path}}statelist?cid={{sm_classes[i].cid}}" class="dropdown-toggle" data-toggle="dropdown">{{sm_classes[i].name}} <span class="caret"></span></a>
   
6.                                                 <ul class="dropdown-menu" role="menu">
   
7.                                                 {% for sm_state in sm_states %}
   
8.                             {% if sm_classes[i].cid == sm_state['cid'] %}
   
9.                                 <li><a href="{{ny_root_path}}state?hid={{sm_state.hid}}">{{sm_state.subject}}</a></li>
   
10.                             {% endif %}
    
11.                         {% endfor %}
    
12.                                                 </ul>
    
13.                                         </li>
    
14.                                         {% endfor %}

複製代碼

完成