幸福家园-提Bug - 禅道

提Bug

所属产品

所属模块

影响版本

所有

当前指派

加载所有

截止日期

Bug标题

Bug类型

严重程度

优先级

重现步骤

<p><span style="color:rgb(65,105,225);font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;"><strong>账号</strong></span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">三轮测试小区</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">登录名：GEhQuccmadmin</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">密码：QRG43ls@</span></p><p></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">账号：</span></p><table style="border-collapse:collapse;border:1px solid #000000;"><tbody><tr><td colspan="1" rowspan="1" style="border:1px solid #000000;padding:5px;"><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">18878383588</span></p></td></tr></tbody></table><p></p><p><span style="color:rgb(220,20,60);font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;"><strong>[问题描述]</strong></span></p><p></p><p><span style="color:rgb(220,20,60);font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">1-统计数量未去掉逻辑删除数据！</span></p><p></p><p><img src="/zentao/file-read-651.png" alt="file-read-651.png" /></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">##登记长期车辆数</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">select count(distinct plate_no) from b_car where community_id=140</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">and deleted_flag=0</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">and type in (0,1,4); ## 0-私家车 1-月卡车 4-白名单车</span></p><p></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">##登记的临时车辆数</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">select count(distinct plate_no) from b_car where community_id=140</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">and deleted_flag=0</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">and type in (2) ## 2-临时车</span></p><p></p><p></p><p><span style="color:rgb(220,20,60);font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">2-在停车辆分类有误</span></p><p><span style="color:rgb(220,20,60);font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">进出场记录未做逻辑删除，若做了逻辑删除，请剔除逻辑删除数据！</span></p><p><img src="/zentao/file-read-655.png" alt="file-read-655.png" /></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">##在停车辆总数</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">select count(distinct plate_no) from b_car_inout where out_type=0;</span></p><p></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">##在停长期车辆数</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">select count(distinct plate_no) from b_car_inout where out_type=0</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">and plate_no in (</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">select plate_no from b_car where community_id=140</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">and deleted_flag=0</span></p><p><span style="font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">and type in (0,1,2,4)) ## 0-私家车 1-月卡车 2-临时车 4-白名单车</span></p><p></p><p></p><p></p><p><span style="color:rgb(148,0,211);font-size:13px;font-family:PingFangSC, HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;">【需求】</span></p><p><img src="/zentao/file-read-652.png" alt="file-read-652.png" /></p>

附件

所属项目

所属执行

所属计划

来源用例

相关需求

相关任务

反馈者

通知邮箱

浏览器

操作系统

抄送给

关键词