| | |
| | | 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=","> |
| | |
| | | <include refid="selectProjectCameraVo"/> |
| | | 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 |
| | |
| | | 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:[], |