首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >django模板在bootstrap表上显示python字典

django模板在bootstrap表上显示python字典
EN

Stack Overflow用户
提问于 2019-03-05 03:26:47
回答 1查看 504关注 0票数 0

我有一个返回此字典的django视图

代码语言:javascript
复制
args={'Residential': 'N/A', 'School': ('481 address', 600), 'Park': 'N/A', 'Religious': 'N/A', 'Childcare': ('123 address', 5)}

我有这段代码可以在HTML页面上正确地显示它

代码语言:javascript
复制
<h5><b>Nearest Childcare Parcel</b> = {{ Childcare }}</h5>
<h5><b>Nearest Park Parcel</b> = {{ Park }}</h5>
<h5><b>Nearest Religious Parcel</b> = {{ Religious }}</h5>
<h5><b>Nearest Residential Parcel</b> = {{ Residential }}</h5>
<h5><b>Nearest School Parcel</b> = {{ School }}</h5>

下面的输出

这是可以的,但它丑陋和混乱。

我想把它很好地放到一张桌子上。

下面是我的html代码,使用的是django jinja模板

代码语言:javascript
复制
<div class="container">
      <h2>Property Search Results</h2>
      <table class="table">
        <thead>
          <tr>
            <th>Layer</th>
            <th>Address</th>
            <th>Distance to Property</th>
          </tr>
        </thead>

        <tbody>            
          <tr>
            {% if args %}
            <td>Childcare</td>            
            <td>{ args['Childcare'][0] }</td>
            <td>{ args['Childcare'][1] }</td>
            {% endif %}

          </tr>      
          <tr class="success">
            {% if args %}
            <td>Park</td>
            <td>{ args['Park'][0] }</td>
            <td>{ args['Park'][1] }</td>
            {% endif %}
          </tr>
          <tr class="danger">
            {% if args %}
            <td>Religious</td>
            <td>{ args['Religious'][0] }</td>
            <td>{ args['Religious'][1] }</td>
            {% endif %}
          </tr>
          <tr class="info">
            {% if args %}
            <td>Residential</td>
            <td>{ args['Residential'][0] }</td>
            <td>{ args['Residential'][1] }</td>
            {% endif %}
          </tr>
          <tr class="warning">
            {% if args %}
            <td>School</td>
            <td>{ args['School'][0] }</td>
            <td>{ args['School'][1] }</td>
            {% endif %}
          </tr>

        </tbody>
      </table>
    </div>

没有错误,但表中根本没有显示任何内容。

让它工作的最好方法是什么?我应该在args字典中执行for循环吗?

这是整个视图

代码语言:javascript
复制
class HomePageView(TemplateView):
    template_name = 'index.html'
    def get(self, request):
        cur = conn.cursor()
        cur.execute("delete from reporter_post")
        form = HomeForm()
        #posts = Post.objects.all()

        #args = {'form': form, 'posts': posts}
        return render(request, self.template_name, {'form': form})

    def post(self, request):
        form = HomeForm(request.POST)
        print(form)
        if form.is_valid():
            cur = conn.cursor()
            cur.execute("delete from reporter_post")
            form.save()
            g = geocoder.bing(str(form.cleaned_data['address']), key=bingkey)
            try:
              x,y=g.latlng[1],g.latlng[0]
              print(x,y)
              pre_qry='''with a as(select parcelid,owner_name,geom
                              from macomb_parcels_zoning_mun mpzu 
                              where st_intersects(geom,st_transform(st_setsrid(ST_FlipCoordinates(st_makepoint({0}, {1})),4326),102690))
                              )
                      update reporter_post set parcelid=a.parcelid, owner_name=a.owner_name,geom=a.geom from a;
                      '''.format(y,x)
              cur.execute(pre_qry)
              conn.commit()
              qry = '''                                    
                      with address1 as(select '{0}'::text subject_parcel_address, mpzu.*
                              from macomb_parcels_zoning_mun mpzu 
                              where st_intersects(geom,st_transform(st_setsrid(ST_FlipCoordinates(st_makepoint({1}, {2})),4326),102690))
                               ),
                      process 
                        as(select distinct on(zone_from_parcels,subject_parcel_address) zone_from_parcels,subject_parcel_address,buffered_parcel_address,owner_name,dist
                              from(select aa.address buffered_parcel_address,aa.owner_name,aa.zone_for_buff zone_from_parcels,
                                  round(st_distance(aa.geom,t.geom)::numeric,2 ) dist, t.subject_parcel_address
                                      from mac_parcels_union aa
                                      cross join lateral (
                                          select m.geom,m.subject_parcel_address, mbu.geom geom_buff 
                                          from address1 m join mac_buffer_union mbu on st_dwithin(m.geom,mbu.geom,2000)
                                              where mbu.parcelid = aa.parcelid and aa.parcelid <> m.parcelid 
                                          )t
                                  group by buffered_parcel_address,owner_name,zone_from_parcels,dist,subject_parcel_address
                                  order by dist) t
                          order by subject_parcel_address,zone_from_parcels,dist
                          )
                    SELECT zone_from_parcels zone_,subject_parcel_address,buffered_parcel_address,owner_name,dist::integer 
                                FROM process
                          '''.format(str(form.cleaned_data['address']), y, x)
              cur.execute(qry)
              row=cur.fetchall()
              print(row)
              if not row:
                  return render(request, self.template_name, {'form': form,'text': 'N/A'})
              else:
                  zones={'Childcare': 'N/A', 'School': 'N/A', 'Park': 'N/A', 'Residential': 'N/A', 'Religious': 'N/A'}
                  for x in row:
                      for k, v in zones.items():
                          if x[0] == k:
                              print(k, x[0])
                              zones[k] = x[2], x[4]


                  args = {'form': form, 'Residential': zones['Residential'],
                          'School': zones['School'], 'Religious': zones['Religious'],
                          'Childcare': zones['Childcare'], 'Park': zones['Park']}
                  return render(request, self.template_name, args)
                  print args
            except:
              args={'Residential': 'N/A', 'School': ('481 address', 600), 'Park': 'N/A', 'Religious': 'N/A', 'Childcare': ('123 address', 5)}
              return render(request, self.template_name, args)
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/54990240

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档