|  |  | 
 |  |  | import com.javaweb.geo.domain.Project; | 
 |  |  | import com.javaweb.geo.domain.TubLog; | 
 |  |  | import com.javaweb.geo.enums.RecordType; | 
 |  |  | import com.javaweb.geo.mapper.ProjectCameraMapper; | 
 |  |  | import com.javaweb.geo.mapper.TubLogMapper; | 
 |  |  | import com.javaweb.geo.service.IHoleMediaService; | 
 |  |  | import com.javaweb.geo.service.IHoleService; | 
 |  |  | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private TubLogMapper tubLogMapper; | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private ProjectCameraMapper projectCameraMapper; | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     private String getAdminIndex() { | 
 |  |  | 
 |  |  |         HoleMedia holeMedia = holeMediaService.selectHoleMediaNumber(); | 
 |  |  |         result.setFileCount(holeMedia.getNumber()); | 
 |  |  |  | 
 |  |  |         Integer cameraCount = projectCameraMapper.count(); | 
 |  |  |         result.setCameraCount(cameraCount); | 
 |  |  |         return AjaxResult.success("查询成功",result); | 
 |  |  |     } | 
 |  |  |  | 
 
 |  |  | 
 |  |  |                              | 
 |  |  |                         </div> | 
 |  |  |                         <span style="color:rgba(0,0,0,.87);font-size: 15px;"> | 
 |  |  |                             已安装  <span style="float: right">0</span> | 
 |  |  |                             已安装  <span style="float: right">{{indexDataCount.cameraCount}}</span> | 
 |  |  | <!--                            <li class="el-icon-caret-bottom" style="color: #f56c6c">--> | 
 |  |  |                         </span> | 
 |  |  |                         <span style="color:rgba(0,0,0,.87);font-size: 15px;"> | 
 
 |  |  | 
 |  |  | import cn.hutool.core.math.MathUtil; | 
 |  |  | import cn.hutool.core.util.ObjectUtil; | 
 |  |  | import com.javaweb.common.utils.Arith; | 
 |  |  | import com.javaweb.geo.mapper.HoleMapper; | 
 |  |  | import org.apache.shiro.authz.annotation.RequiresPermissions; | 
 |  |  | import org.springframework.beans.factory.annotation.Autowired; | 
 |  |  | import org.springframework.stereotype.Controller; | 
 |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private IHoleService holeService; | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private HoleMapper holeMapper; | 
 |  |  |  | 
 |  |  |     @RequiresPermissions("geo:hole:view") | 
 |  |  |     @GetMapping() | 
 |  |  |     public String hole(String id, ModelMap mmap) { | 
 |  |  | 
 |  |  |         return AjaxResult.success(list); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @GetMapping("/holeProcess") | 
 |  |  |     @ResponseBody | 
 |  |  |     public AjaxResult holeProcess(Hole hole) { | 
 |  |  |  | 
 |  |  |         Hole hole2 =  holeMapper.selectProjectProcess(hole.getProjectId()); | 
 |  |  |         Double process = Arith.div(hole2.getFootageCpl(), hole2.getFootage(), 2); | 
 |  |  |         return  AjaxResult.success(process); | 
 |  |  |  | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 导出钻孔列表 | 
 |  |  |      */ | 
 
 |  |  | 
 |  |  |  | 
 |  |  |     public  Hole selectHoleTotalProcess(); | 
 |  |  |  | 
 |  |  |     public Hole selectProjectProcess(@Param("projectId") String projectId); | 
 |  |  |  | 
 |  |  |     public List<Hole> selectHoleProjectProcess(); | 
 |  |  | } | 
 
 |  |  | 
 |  |  |      * @return 结果 | 
 |  |  |      */ | 
 |  |  |     public int deleteProjectCameraByIds(String[] ids); | 
 |  |  |  | 
 |  |  |     public Integer count(); | 
 |  |  | } | 
 
 |  |  | 
 |  |  |      */ | 
 |  |  |     private Long fileCount; | 
 |  |  |  | 
 |  |  |     private Integer sgCount; | 
 |  |  |     private Integer aqCount; | 
 |  |  |     private Integer zlCount; | 
 |  |  |  | 
 |  |  |     private Integer cameraCount; | 
 |  |  |  | 
 |  |  |     public Integer getSgCount() { | 
 |  |  |         return sgCount; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public void setSgCount(Integer sgCount) { | 
 |  |  |         this.sgCount = sgCount; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public Integer getAqCount() { | 
 |  |  |         return aqCount; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public void setAqCount(Integer aqCount) { | 
 |  |  |         this.aqCount = aqCount; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public Integer getZlCount() { | 
 |  |  |         return zlCount; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public void setZlCount(Integer zlCount) { | 
 |  |  |         this.zlCount = zlCount; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public Integer getCameraCount() { | 
 |  |  |         return cameraCount; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public void setCameraCount(Integer cameraCount) { | 
 |  |  |         this.cameraCount = cameraCount; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public Integer getProjectStatus0() { | 
 |  |  |         return projectStatus0; | 
 
 |  |  | 
 |  |  |         from js_hole  GROUP BY project_id | 
 |  |  |     </select> | 
 |  |  |  | 
 |  |  |     <select id="selectProjectProcess" resultMap="HoleResult" > | 
 |  |  |        select project_id as project_id,  sum(footage_cpl) as footage_cpl, sum(footage) as footage | 
 |  |  |         from js_hole where project_id = #{projectId} | 
 |  |  |     </select> | 
 |  |  |  | 
 |  |  |     <insert id="insertHole" parameterType="Hole"> | 
 |  |  |         insert into js_hole | 
 |  |  |         <trim prefix="(" suffix=")" suffixOverrides=","> | 
 
 |  |  | 
 |  |  |         where id = #{id} | 
 |  |  |     </select> | 
 |  |  |          | 
 |  |  |     <select id ="count" resultType="Integer"> | 
 |  |  |        select  count(*) from js_project_camera | 
 |  |  |     </select> | 
 |  |  |          | 
 |  |  |     <insert id="insertProjectCamera" parameterType="ProjectCamera"> | 
 |  |  |         insert into js_project_camera | 
 |  |  |         <trim prefix="(" suffix=")" suffixOverrides=","> | 
 |  |  | 
 |  |  |         delete from js_project_camera where id = #{id} | 
 |  |  |     </delete> | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     <delete id="deleteProjectCameraByIds" parameterType="String"> | 
 |  |  |         delete from js_project_camera where id in  | 
 |  |  |         <foreach item="id" collection="array" open="(" separator="," close=")"> | 
 
 |  |  | 
 |  |  |                     </div> | 
 |  |  |                     <div> | 
 |  |  |                         <div style="padding-left: 20%;"> | 
 |  |  |                             <el-progress  type="dashboard" color="#FF0000" :percentage="50"> | 
 |  |  |                             <el-progress  type="dashboard" color="#FF0000" :percentage=holeProcess> | 
 |  |  |                             </el-progress> | 
 |  |  |                         </div> | 
 |  |  |                     </div> | 
 |  |  | 
 |  |  |         var prefix2 = ctx + "geo/TubLog"; | 
 |  |  |  | 
 |  |  |         $(function() { | 
 |  |  |             //场地钻孔列表 | 
 |  |  |             var url = prefix + "/holelist?projectId=" + projectId; | 
 |  |  |             $.ajaxSettings.async = false; | 
 |  |  |             $.get(url,{},function(res){ | 
 |  |  |                 vm.holeData = res.data; | 
 |  |  |             }); | 
 |  |  |             vm.project = project; | 
 |  |  |             //场地进度 | 
 |  |  |             var url2 = prefix + "/holeProcess?projectId=" + projectId; | 
 |  |  |             $.ajaxSettings.async = false; | 
 |  |  |             $.get(url2,{},function(res){ | 
 |  |  |                 vm.holeProcess = (res.data*100).toFixed(0); | 
 |  |  |                 alert(vm.holeProcess); | 
 |  |  |             }); | 
 |  |  |  | 
 |  |  |             tubLogs(); | 
 |  |  |         }); | 
 |  |  |  | 
 |  |  | 
 |  |  |             el: "#app", | 
 |  |  |             data() { | 
 |  |  |                 return { | 
 |  |  |                     holeProcess:"", | 
 |  |  |                     project: "", | 
 |  |  |                     holeData: [], | 
 |  |  |                     tubLogs:[], |