.mui-table-view:after,
.mui-table-view:before {
height: 0px;
}
.mui-row div {
text-align: center;
overflow: hidden;
text-overflow: ellipsis;
white-space: nowrap;
}
.mui-checkbox input[type=checkbox],
.mui-radio input[type=radio] {
top: 0;
height: 21px;
}
.mui-checkbox input[type=checkbox]:before,
.mui-radio input[type=radio]:before {
font-size: 25px;
}
.mui-col-xs-1.mui-input-row.mui-checkbox {
/*width: 50px;*/
height: 32px;
top: -3px;
}
.mui-table-view {
margin-top: 15px;
}
.mui-content>.mui-table-view:first-child {
margin-top: 0;
}
.mui-table-view:first-child .mui-table-view-cell {
padding: 6px 15px;
}
.mui-navigate-right:after,
.mui-push-right:after {
display: none;
}
.mui-dtpicker-header button {
padding: 8px 14px;
}
.mui-table-view.secect:first-child {
margin-top: 0;
border-bottom: 10px solid #efeff4;
}
.mui-table-view.secect>.mui-table-view-cell:nth-child(1) {
padding: 15px 15px 11px 15px;
}
.mui-input-row label {
line-height: 100%;
}
.mui-scroll-wrapper {
top: 140px;
}
.mui-navigate-right {
overflow: hidden;
text-overflow: ellipsis;
white-space: nowrap;
}
.mui-navigate-right span {
margin-right: 15px;
}
.mui-btn,
button,
input[type=button],
input[type=reset],
input[type=submit] {
line-height: 100%;
padding: 8px 12px;
}
#dataYear {
padding-left: 20px;
float: left;
width: 50%;
border-bottom: 1px solid #eee;
}
.xz,
.mui-icon-closeempty {
color: #FFF;
font-size: 35px;
height: 50px;
width: 50px;
line-height: 50px;
text-align: center;
}
div *,button{
font-size: 15px;
}
/*增加6px*/
header.mui-bar {
height: 70px;
}
/*增加6px*/
.mui-title {
padding-top: 26px;
}
.mui-table-view-cell{
background-color: white;
}
.mui-table-view-chevron {
height: 0px;
}
数据上传
-
矿山名称：
可上传矿山调查信息列表：
-
矿山编号
矿山名称
上传数据
mui.init({
//swipeBack: true ,//启用右滑关闭功能
swipeBack:false
});
mui.plusReady(function() {
//禁用滚动条
plus.webview.currentWebview().setStyle({
scrollIndicator: 'none'
});
$("#select").click(function() {
$("#dataList .info").empty(); //点击查询后，清空之前查询的信息列表
getWebSqlData(); //执行sql
})
$("#dataYear").val(new Date().getFullYear()); //初始赋值
mui('body').on('tap', '#dataYear', function() {
//年份选择插件
var dtPicker = new mui.DtPicker({
type: 'year'
});
dtPicker.show(function(e) {
$("#dataYear").val(e.y.value); //{text: "2016",value: 2016}
})
// 暂时禁止滚动
//mui('#dataList').pullRefresh().setStopped(true);
});
//全选按钮
$("#btn1").click(function() {
if($("#btn2").val() == 0) {
$("[name='MSI']").attr("checked", 'true'); //全选
$("#btn2").attr("value", '1'); //填充内容
} else {
$("[name='MSI']").removeAttr("checked"); //取消全选
$("#btn2").attr("value", '0'); //填充内容
}
})
});
//获取本地websql数据
function getWebSqlData() {
var mineName = $("#mineName").val(); //调查日期 MINE_NAME
var sql = ""; //sql语句 用来临时存放sql拼接的语句
var arr = new Array(); //创建一个数组 用来放临时的传递过来的数据
if(mineName != "") { //矿山名字要模糊查找
sql += " AND MINE_NAME like? ";
arr.push("%" + mineName + "%");
//alert("%" + mineName + "%")
}
var liCount = Number($("#dataList .info").find('li').length), //得到id为dataList 下的ul 下的li的个数
len = 0; //此时已经加载的行数
arr.push(liCount); //把li的个数存放的数组中
arr.push(30); //把1000存放到数组中
db.transaction(function(tx) {
tx.executeSql('SELECT * FROM MINE_SURVEY_INFO WHERE 1=1 and isUpdate = 1 ' + sql + ' LIMIT ?, ?', arr, function(tx, results) {
len = Number(results.rows.length);
if(results.rows.length == 0) {
alert("没有数据")
} else {
for(var i = 0; i < len; i++) {
var rowInfo =
"
" +"" +
"
"
"" +
"" +
"
"
"
"
results.rows.item(i).MINE_NUMBER +
"
"
results.rows.item(i).MINE_NAME +
"
//"
//results.rows.item(i).MINE_PERMIT +
//"
"
"
"
"" +
"
";$("#dataList .info").append(rowInfo);
}
}
}, function() {
console.log("cuowu")
});
}, function() {
console.log("cuowu")
});
}
//关闭下载进度框
$(document).on("click", ".mui-icon-closeempty", function() {
$("#downloadMsg").html("");
$("#loadingToast").hide();
})
$("#shangchuan").click(function() {
uploadMSI = document.getElementsByName("MSI");
let mine_survey_id = [];
//把选择的矿山数组的矿山编号，合并成数组
for(let i = 0; i < Number(uploadMSI.length); i++) {
if(uploadMSI[i].checked) {
console.log(uploadMSI[i].value)
mine_survey_id.push(uploadMSI[i].value)
}
}
if(mine_survey_id.length == 0) {
mui.alert("请选择要上传的数据！");
return false;
}
//上传对象
var jsons = {};
jsons.surveyMineSurveyInfoList = []; //1矿山调查基本信息
jsons.surveyCeaSurveyAttachList = []; //2-获取调查矿山基本附加信息List
jsons.ceaSurveyAquiferList = []; // 3.1-矿山地下含水层影响破坏List
jsons.ceaAquiferFeatureList = []; // 3.2-获取受影响主要含水岩组水温地质特征List
jsons.ceaSurveySlideList = []; // 4.1-获取矿山滑坡及其隐患List
jsons.ceaSlideControlList = []; //4.2-获取控滑结构面List
jsons.ceaSlideDeformationList = []; //4.3-获取滑坡变形活动表List
jsons.ceaSurveyCollapseList = []; //5.1-获取矿山崩塌及其隐患调查表List
jsons.ceaCollapseDeformationList = []; //5.2-获取崩塌变形活动表List
jsons.ceaSurveyLandDestroyList = []; //6.1-获取地形地貌及土地破坏野外调查表List
jsons.ceaLandDestroyTypeList = []; //6.2-获取土地破坏类型及面积List
jsons.ceaSurveySinkList = []; //7.1-获取地面塌陷、地裂缝调查表List
jsons.ceaSinkCrackList = []; //7.2-获取地面裂缝单缝信息List
jsons.ceaSinkPitList = []; //7.3-获取地面塌陷单坑信息List
jsons.ceaSurveyDebrisList = []; //8.1-获取泥石流及其隐患调查表List
jsons.ceaBadGeologicalList = []; //8.2-获取不良地质体List
jsons.ceaSurveyWasteList = []; //9.1-废水废液固废调查总表List
jsons.ceaWasteSoilSampleList = []; //9.2-土壤样品采集记录表List
jsons.ceaWasteWaterSampleList = []; //9.3-水质样品采集记录表List
jsons.ceaWasteSolidList = []; //9.4-固废调查表List
jsons.ceaWasteLiquidList = []; //9.5--废水废液调查表List
mui.confirm("您一共选择了【"+mine_survey_id.length+"】条矿山，是否立刻进行上传？\n上传过程中可能时间较长，请勿关闭网络并确保电量充足，以免造成数据损失！ ", "提示", ['确定', '取消'], function(e) {
if(e.index == 0) {
console.log("mine_survey_id是：",JSON.stringify(mine_survey_id))
mui("#shangchuan").button('loading');
fun_surveyMineSurveyInfoList(mine_survey_id) //1矿山调查基本信息
.then(function() { //2-获取调查矿山基本附加信息List
return fun_surveyCeaSurveyAttachList(mine_survey_id);
})
.then(function() { // 3.1-矿山地下含水层影响破坏List
return fun_ceaSurveyAquiferList(mine_survey_id);
})
.then(function(data) { // 3.2-获取受影响主要含水岩组水温地质特征List
return fun_ceaAquiferFeatureList(data);
})
.then(function() { // 4.1-获取矿山滑坡及其隐患List
return fun_ceaSurveySlideList();
})
.then(function(data) {
return fun_ceaSlideControlList(data); //4.2-获取控滑结构面List
})
.then(function(data) {
return fun_ceaSlideDeformationList(data); //4.3-获取滑坡变形活动表List
})
.then(function() {
return fun_ceaSurveyCollapseList(mine_survey_id); //5.1-获取矿山崩塌及其隐患调查表List
})
.then(function(data) {
return fun_ceaCollapseDeformationList(data); //5.2-获取崩塌变形活动表List
})
.then(function() {
return fun_ceaSurveyLandDestroyList(mine_survey_id); //6.1-获取地形地貌及土地破坏野外调查表List
})
.then(function(data) {
return fun_ceaLandDestroyTypeList(data); // 6.2-获取土地破坏类型及面积List
})
.then(function() {
return fun_ceaSurveySinkList(mine_survey_id); //7.1-获取地面塌陷、地裂缝调查表List
})
.then(function(data) {
return fun_ceaSinkCrackList(data); //7.2-获取地面裂缝单缝信息List
})
.then(function(data) {
return fun_ceaSinkPitList(data); //7.3-获取地面塌陷单坑信息List
})
.then(function() {
return fun_ceaSurveyDebrisList(mine_survey_id); //8.1-获取泥石流及其隐患调查表List
})
.then(function(data) {
return fun_ceaBadGeologicalList(data); //8.2-获取不良地质体List
})
.then(function(data) {
return fun_ceaSurveyWasteList(mine_survey_id); //9.1-废水废液固废调查总表List
})
.then(function(data) {
return fun_ceaWasteSoilSampleList(data); //9.2-土壤样品采集记录表List
})
.then(function(data) {
return fun_ceaWasteWaterSampleList(data); //9.3-水质样品采集记录表List
})
.then(function(data) {
return fun_ceaWasteSolidList(data); //9.4-固废调查表List
})
.then(function(data) {
return fun_ceaWasteLiquidList(data); //9.5--废水废液调查表List
})
.then(function() {
uploading(jsons); //上传
}, function(data) {
console.log("失败：" + data);
})
}
})
//1.矿山调查基本信息
function fun_surveyMineSurveyInfoList(mine_survey_id) {
return new Promise(function(resolve, reject) {
db.transaction(function(tx) {
tx.executeSql("select * from MINE_SURVEY_INFO WHERE MINE_SURVEY_ID IN (" + mine_survey_id + ")", [], function(tx, res) {
for(let i = 0; i < res.rows.length; i++) {
let surveyMineSurveyInfo = {
mineSurveyId: res.rows.item(i).MINE_SURVEY_ID,
surveyId: res.rows.item(i).SURVEY_ID,
mineNumber: res.rows.item(i).MINE_NUMBER,
minePermit: res.rows.item(i).MINE_PERMIT,
province: res.rows.item(i).PROVINCE,
city: res.rows.item(i).CITY,
county: res.rows.item(i).COUNTY,
longitude: res.rows.item(i).LONGITUDE,
latitude: res.rows.item(i).LATITUDE,
minegoafArea: res.rows.item(i).MINEGOAF_AREA,
aquifers: res.rows.item(i).AQUIFERS,
mineDepth: res.rows.item(i).MINE_DEPTH,
mineArea: res.rows.item(i).MINE_AREA,
mineEmployeesNumber: res.rows.item(i).MINE_EMPLOYEES_NUMBER,
economicType: res.rows.item(i).ECONOMIC_TYPE,
mineMethod: res.rows.item(i).MINE_METHOD,
mineCreatTime: res.rows.item(i).MINE_CREAT_TIME,
designCapacity: res.rows.item(i).DESIGN_CAPACITY,
actualCapacity: res.rows.item(i).ACTUAL_CAPACITY,
productionStatus: res.rows.item(i).PRODUCTION_STATUS,
beneficiationMethod: res.rows.item(i).BENEFICIATION_METHOD,
designServiceLife: res.rows.item(i).DESIGN_SERVICE_LIFE,
serviceYears: res.rows.item(i).SERVICE_YEARS,
companyName: res.rows.item(i).COMPANY_NAME,
mineName: res.rows.item(i).MINE_NAME,
address: res.rows.item(i).ADDRESS,
zipCode: res.rows.item(i).ZIP_CODE,
legalPerson: res.rows.item(i).LEGAL_PERSON,
phone: res.rows.item(i).PHONE,
fax: res.rows.item(i).FAX,
mineScale: res.rows.item(i).MINE_SCALE,
protectGovernProgramReplytime: res.rows.item(i).PROTECT_GOVERN_PROGRAM_REPLYTIME,
fillName: res.rows.item(i).FILL_NAME,
fillDate: res.rows.item(i).FILL_DATE,
mineralsTypeId: res.rows.item(i).MINERALS_TYPE_ID,
mineralsVarietyId: res.rows.item(i).MINERALS_VARIETY_ID,
Memo1: res.rows.item(i).Memo1,
Memo2: res.rows.item(i).Memo2
}
jsons.surveyMineSurveyInfoList.push(surveyMineSurveyInfo)
}
resolve(); //成功返回
}, function(tx, e) {
alert(e.message)
console.log("错误对象",e)
reject(e.message);
})
})
});
}
//2-获取调查矿山基本附加信息List
function fun_surveyCeaSurveyAttachList(mine_survey_id){
return new Promise(function(resolve, reject) {
db.transaction(function(tx) {
tx.executeSql('SELECT * FROM CEA_SURVEY_ATTACH WHERE MINE_SURVEY_ID IN (' + mine_survey_id + ')', [], function(tx, res) {
for(let i = 0; i < res.rows.length; i++) {
let surveyCeaSurveyAttachInfo = {
mineSurveyId: res.rows.item(i).MINE_SURVEY_ID,
inflectionPoint: res.rows.item(i).INFLECTION_POINT,
mapId: res.rows.item(i).MAP_ID,
village: res.rows.item(i).VILLAGE,
elevation: res.rows.item(i).ELEVATION,
miningThick: res.rows.item(i).MINING_THICK,
oreAmount: res.rows.item(i).ORE_AMOUNT,
marginAmount: res.rows.item(i).MARGIN_AMOUNT,
closeDate: res.rows.item(i).CLOSE_DATE,
monitorContent: res.rows.item(i).MONITOR_CONTENT,
monitorMethod: res.rows.item(i).MONITOR_METHOD,
centerCost: res.rows.item(i).CENTER_COST,
localCost: res.rows.item(i).LOCAL_COST,
selfCost: res.rows.item(i).SELF_COST,
conactWay: res.rows.item(i).CONACT_WAY,
fillUnit: res.rows.item(i).FILL_UNIT,
surveyItems: res.rows.item(i).SURVEY_ITEMS,
inputTime: res.rows.item(i).INPUT_TIME,
inputer: res.rows.item(i).INPUTER,
inputUnit: res.rows.item(i).INPUT_UNIT,
inputerWay: res.rows.item(i).INPUTER_WAY,
fieldCode: res.rows.item(i).FIELD_CODE,
productivPower: res.rows.item(i).PRODUCTIV_POWER,
surveyType: res.rows.item(i).SURVEY_TYPE
}
jsons.surveyCeaSurveyAttachList.push(surveyCeaSurveyAttachInfo);
}
resolve(); //成功返回
}, function(tx, e) {
reject(e.message);
})
})
})
}
//3.1-矿山地下含水层影响破坏List
function fun_ceaSurveyAquiferList(mine_survey_id) {
return new Promise(function(resolve, reject) {
db.transaction(function(tx) {
tx.executeSql('SELECT * FROM CEA_SURVEY_AQUIFER WHERE MINE_SURVEY_ID IN (' + mine_survey_id + ') AND isUpdate = 1 ', [], function(tx, res) {
let aqyiferIds = [];
for(let i = 0; i < res.rows.length; i++) {
aqyiferIds.push(res.rows.item(i).AQUIFER_ID);
let ceaSurveyAquiferInfo = {
aquiferId: res.rows.item(i).AQUIFER_ID,
mineSurveyId: res.rows.item(i).MINE_SURVEY_ID,
hydrogeololgyType: res.rows.item(i).HYDROGEOLOLGY_TYPE,
aquiferType: res.rows.item(i).AQUIFER_TYPE,
pitTonage: res.rows.item(i).PIT_TONAGE,
pitDrainElevation: res.rows.item(i).PIT_DRAIN_ELEVATION,
waterDropArea: res.rows.item(i).WATER_DROP_AREA,
pitWaterSource: res.rows.item(i).PIT_WATER_SOURCE,
pitWaterApproach: res.rows.item(i).PIT_WATER_APPROACH,
wellChangeType: res.rows.item(i).WELL_CHANGE_TYPE,
dropRange: res.rows.item(i).DROP_RANGE,
decreaseReange: res.rows.item(i).DECREASE_REANGE,
monitorNumber: res.rows.item(i).MONITOR_NUMBER,
monitorContent: res.rows.item(i).MONITOR_CONTENT,
preventGradation: res.rows.item(i).PREVENT_GRADATION,
monitorRate: res.rows.item(i).MONITOR_RATE,
monitorResult: res.rows.item(i).MONITOR_RESULT
}
jsons.ceaSurveyAquiferList.push(ceaSurveyAquiferInfo)
}
resolve(aqyiferIds); //成功返回
}, function(tx, e) {
reject(e.message);
})
});
});
}
//3.2-获取受影响主要含水岩组水温地质特征List
function fun_ceaAquiferFeatureList(aqyiferIds) {
return new Promise(function(resolve, reject) {
//判断是否有数据
if(String(aqyiferIds).length > 0) {
db.transaction(function(tx) {
//3.1-矿山地下含水层影响破坏List
tx.executeSql('SELECT * FROM CEA_AQUIFER_FEATURE WHERE isUpdate =1 AND AQUIFER_ID in (' + aqyiferIds + ') and isUpdate = 1', [], function(tx, res) {
for(let i = 0; i < res.rows.length; i++) {
let ceaAquiferFeatureInfo = {
aquiferId: res.rows.item(i).AQUIFER_ID,
featureName: res.rows.item(i).FEATURE_NAME,
lithology: res.rows.item(i).LITHOLOGY,
thickness: res.rows.item(i).THICKNESS,
burialDepth: res.rows.item(i).BURIAL_DEPTH,
watery: res.rows.item(i).WATERY,
osmoticCoefficient: res.rows.item(i).OSMOTIC_COEFFICIENT,
mineralization: res.rows.item(i).MINERALIZATION,
waterType: res.rows.item(i).WATER_TYPE,
effectMethod: res.rows.item(i).EFFECT_METHOD,
structure: res.rows.item(i).STRUCTURE,
weterLevelType: res.rows.item(i).WETER_LEVEL_TYPE,
weterLevel: res.rows.item(i).WETER_LEVEL,
waterQuality: res.rows.item(i).WATER_QUALITY
}
jsons.ceaAquiferFeatureList.push(ceaAquiferFeatureInfo)
}
resolve(); //成功返回
}, function(tx, e) {
reject(e.message);
})
});
} else {
resolve(); //成功返回
}
});
}
//4.1-获取矿山滑坡及其隐患List
function fun_ceaSurveySlideList() {
return new Promise(function(resolve, reject) {
db.transaction(function(tx) {
tx.executeSql('select * from CEA_SURVEY_SLIDE where MINE_SURVEY_ID IN (' + mine_survey_id + ') AND isUpdate = 1', [], function(tx, res) {
let slideIds = [];
for(let i = 0; i < res.rows.length; i++) {
slideIds.push(res.rows.item(i).SLIDE_ID);
let ceaSurveySlideListInfo = {
slideId: res.rows.item(i).SLIDE_ID,
mineSurveyId: res.rows.item(i).MINE_SURVEY_ID,
happenDate: res.rows.item(i).HAPPEN_DATE,
happenFlag: res.rows.item(i).HAPPEN_FLAG,
longtitude: res.rows.item(i).LONGTITUDE,
topEvevation: res.rows.item(i).TOP_EVEVATION,
buttomEvevation: res.rows.item(i).BUTTOM_EVEVATION,
slideType: res.rows.item(i).SLIDE_TYPE,
slipperyType: res.rows.item(i).SLIPPERY_TYPE,
stratumEra: res.rows.item(i).STRATUM_ERA,
stratumLithology: res.rows.item(i).STRATUM_LITHOLOGY,
stratumAttitude: res.rows.item(i).STRATUM_ATTITUDE,
tectonicPosition: res.rows.item(i).TECTONIC_POSITION,
earthquakeIntensity: res.rows.item(i).EARTHQUAKE_INTENSITY,
microLandform: res.rows.item(i).MICRO_LANDFORM,
groundWaterType: res.rows.item(i).GROUND_WATER_TYPE,
originalSlopeHeight: res.rows.item(i).ORIGINAL_SLOPE_HEIGHT,
originalSlopeAngle: res.rows.item(i).ORIGINAL_SLOPE_ANGLE,
originalSlopeShape: res.rows.item(i).ORIGINAL_SLOPE_SHAPE,
slideLength: res.rows.item(i).SLIDE_LENGTH,
slideWidth: res.rows.item(i).SLIDE_WIDTH,
slideThickness: res.rows.item(i).SLIDE_THICKNESS,
slideArea: res.rows.item(i).SLIDE_AREA,
slideVolume: res.rows.item(i).SLIDE_VOLUME,
slideLevel: res.rows.item(i).SLIDE_LEVEL,
slideGradient: res.rows.item(i).SLIDE_GRADIENT,
slideAspect: res.rows.item(i).SLIDE_ASPECT,
planeForm: res.rows.item(i).PLANE_FORM,
slipemassLithology: res.rows.item(i).SLIPEMASS_LITHOLOGY,
slipemassStructure: res.rows.item(i).SLIPEMASS_STRUCTURE,
slidemassGravelContent: res.rows.item(i).SLIDEMASS_GRAVEL_CONTENT,
slidemassLumpinessType: res.rows.item(i).SLIDEMASS_LUMPINESS_TYPE,
slipperyLithology: res.rows.item(i).SLIPPERY_LITHOLOGY,
slipperyEra: res.rows.item(i).SLIPPERY_ERA,
slipperyAttitude: res.rows.item(i).SLIPPERY_ATTITUDE,
slidefaceForm: res.rows.item(i).SLIDEFACE_FORM,
slidefaceDepth: res.rows.item(i).SLIDEFACE_DEPTH,
slidefaceTendency: res.rows.item(i).SLIDEFACE_TENDENCY,
slidefaceAngle: res.rows.item(i).SLIDEFACE_ANGLE,
slidezoneThickness: res.rows.item(i).SLIDEZONE_THICKNESS,
slidezoneName: res.rows.item(i).SLIDEZONE_NAME,
slidezoneProerty: res.rows.item(i).SLIDEZONE_PROERTY,
landUse: res.rows.item(i).LAND_USE,
activityStage: res.rows.item(i).ACTIVITY_STAGE,
presentState: res.rows.item(i).PRESENT_STATE,
trend: res.rows.item(i).TREND,
deadNumber: res.rows.item(i).DEAD_NUMBER,
destroyHouse: res.rows.item(i).DESTROY_HOUSE,
destroyRoad: res.rows.item(i).DESTROY_ROAD,
destroyCanal: res.rows.item(i).DESTROY_CANAL,
destroyOther: res.rows.item(i).DESTROY_OTHER,
directLoss: res.rows.item(i).DIRECT_LOSS,
indirectLoss: res.rows.item(i).INDIRECT_LOSS,
disasterLevel: res.rows.item(i).DISASTER_LEVEL,
damageObject: res.rows.item(i).DAMAGE_OBJECT,
threatenPeople: res.rows.item(i).THREATEN_PEOPLE,
threatenProperty: res.rows.item(i).THREATEN_PROPERTY,
dangerLevel: res.rows.item(i).DANGER_LEVEL,
threatenObject: res.rows.item(i).THREATEN_OBJECT,
controlSuggestion: res.rows.item(i).CONTROL_SUGGESTION,
monitorSuggestion: res.rows.item(i).MONITOR_SUGGESTION,
photoCode: res.rows.item(i).PHOTO_CODE,
memo: res.rows.item(i).MEMO,
mapFlag: res.rows.item(i).MAP_FLAG,
plane:res.rows.item(i).PLANE,
profile:res.rows.item(i).PROFILE
}
jsons.ceaSurveySlideList.push(ceaSurveySlideListInfo);
}
resolve(slideIds);
}, function(tx, e) {
reject(e.message);
})
});
});
}
//4.2-获取控滑结构面List
function fun_ceaSlideControlList(slideIds) {
return new Promise(function(resolve, reject) {
if(String(slideIds).length > 0) {
db.transaction(function(tx) {
tx.executeSql('select * from CEA_SLIDE_CONTROL where SLIDE_ID IN (' + slideIds + ') AND isUpdate = 1', [], function(tx, res) {
for(var i = 0; i < res.rows.length; i++) {
let ceaSlideControlInfo = {
controlId: res.rows.item(i).CONTROL_ID,
slideId: res.rows.item(i).SLIDE_ID,
controlSurfaceType: res.rows.item(i).CONTROL_SURFACE_TYPE,
controlSurfaceAttitude: res.rows.item(i).CONTROL_SURFACE_ATTITUDE
}
jsons.ceaSlideControlList.push(ceaSlideControlInfo)
}
resolve(slideIds);
}, function(tx, e) {
reject(e.message);
})
});
} else {
resolve(slideIds); //成功返回
}
});
}
//4.3-获取滑坡变形活动表List
function fun_ceaSlideDeformationList(slideIds) {
return new Promise(function(resolve, reject) {
if(String(slideIds).length > 0) {
db.transaction(function(tx) {
tx.executeSql('select * from CEA_SLIDE_DEFORMATION where SLIDE_ID in (' + slideIds + ') AND isUpdate = 1', [], function(tx, res) {
for(var i = 0; i < res.rows.length; i++) {
let CeaSlideDeformationInfo = {
deformationId: res.rows.item(i).DEFORMATION_ID,
slideId: res.rows.item(i).SLIDE_ID,
deformationPosition: res.rows.item(i).DEFORMATION_POSITION,
deformationFeature: res.rows.item(i).DEFORMATION_FEATURE,
happenDate: res.rows.item(i).HAPPEN_DATE,
deformationType: res.rows.item(i).DEFORMATION_TYPE
}
jsons.ceaSlideDeformationList.push(CeaSlideDeformationInfo)
}
resolve();
}, function(tx, e) {
reject(e.message);
})
})
} else {
resolve();
}
});
}
//5.1-获取矿山崩塌及其隐患调查表List
function fun_ceaSurveyCollapseList(mine_survey_id) {
return new Promise(function(resolve, reject) {
db.transaction(function(tx) {
tx.executeSql('select * from CEA_SURVEY_COLLAPSE where MINE_SURVEY_ID IN (' + mine_survey_id + ') AND isUpdate = 1', [], function(tx, res) {
let collapseIds = [];
for(let i = 0; i < res.rows.length; i++) {
collapseIds = res.rows.item(i).COLLAPSE_ID;
let CeaSurveyCollapse = {
collapseId: res.rows.item(i).COLLAPSE_ID,
mineSurveyId: res.rows.item(i).MINE_SURVEY_ID,
happenTime: res.rows.item(i).HAPPEN_TIME,
happenFlag: res.rows.item(i).HAPPEN_FLAG,
longtitude: res.rows.item(i).LONGTITUDE,
latitude: res.rows.item(i).LATITUDE,
topElevation: res.rows.item(i).TOP_ELEVATION,
buttomElevation: res.rows.item(i).BUTTOM_ELEVATION,
slopeType: res.rows.item(i).SLOPE_TYPE,
collapseType: res.rows.item(i).COLLAPSE_TYPE,
stratumEra: res.rows.item(i).STRATUM_ERA,
stratumLithology: res.rows.item(i).STRATUM_LITHOLOGY,
attitude: res.rows.item(i).ATTITUDE,
tectonicPosition: res.rows.item(i).TECTONIC_POSITION,
earthquakeLevel: res.rows.item(i).EARTHQUAKE_LEVEL,
microLandscape: res.rows.item(i).MICRO_LANDSCAPE,
landUseType: res.rows.item(i).LAND_USE_TYPE,
distributeElevation: res.rows.item(i).DISTRIBUTE_ELEVATION,
slopeHeight: res.rows.item(i).SLOPE_HEIGHT,
slopeLength: res.rows.item(i).SLOPE_LENGTH,
slopeWidth: res.rows.item(i).SLOPE_WIDTH,
thick: res.rows.item(i).THICK,
volume: res.rows.item(i).VOLUME,
scaleLevel: res.rows.item(i).SCALE_LEVEL,
gradient: res.rows.item(i).GRADIENT,
aspect: res.rows.item(i).ASPECT,
rockTextureType: res.rows.item(i).ROCK_TEXTURE_TYPE,
rockThick: res.rows.item(i).ROCK_THICK,
rockFissureNumber: res.rows.item(i).ROCK_FISSURE_NUMBER,
rockLinpiness: res.rows.item(i).ROCK_LINPINESS,
beltDepth: res.rows.item(i).BELT_DEPTH,
unloadFissureDepth: res.rows.item(i).UNLOAD_FISSURE_DEPTH,
soilName: res.rows.item(i).SOIL_NAME,
soilCompactedness: res.rows.item(i).SOIL_COMPACTEDNESS,
soilConsistence: res.rows.item(i).SOIL_CONSISTENCE,
bedrockLithology: res.rows.item(i).BEDROCK_LITHOLOGY,
bedrockEra: res.rows.item(i).BEDROCK_ERA,
bedrockAttitude: res.rows.item(i).BEDROCK_ATTITUDE,
bedrockDepth: res.rows.item(i).BEDROCK_DEPTH,
stableDegree: res.rows.item(i).STABLE_DEGREE,
variationTrend: res.rows.item(i).VARIATION_TREND,
aggregateLength: res.rows.item(i).AGGREGATE_LENGTH,
aggregateWidth: res.rows.item(i).AGGREGATE_WIDTH,
aggregateThickness: res.rows.item(i).AGGREGATE_THICKNESS,
aggregateVolume: res.rows.item(i).AGGREGATE_VOLUME,
aggregateGradient: res.rows.item(i).AGGREGATE_GRADIENT,
aggregateAspet: res.rows.item(i).AGGREGATE_ASPET,
aggregateSlopeShape: res.rows.item(i).AGGREGATE_SLOPE_SHAPE,
aggregateStability: res.rows.item(i).AGGREGATE_STABILITY,
aggregateTrend: res.rows.item(i).AGGREGATE_TREND,
deadNuber: res.rows.item(i).DEAD_NUBER,
destroyHouseNumber: res.rows.item(i).DESTROY_HOUSE_NUMBER,
destroyRoadLength: res.rows.item(i).DESTROY_ROAD_LENGTH,
destroyCanalLength: res.rows.item(i).DESTROY_CANAL_LENGTH,
dangerLevel: res.rows.item(i).DANGER_LEVEL,
directLoss: res.rows.item(i).DIRECT_LOSS,
indirectLoss: res.rows.item(i).INDIRECT_LOSS,
otherDamage: res.rows.item(i).OTHER_DAMAGE,
disasterLevel: res.rows.item(i).DISASTER_LEVEL,
harmObject: res.rows.item(i).HARM_OBJECT,
threatenPopulation: res.rows.item(i).THREATEN_POPULATION,
threatenProperty: res.rows.item(i).THREATEN_PROPERTY,
threatenObject: res.rows.item(i).THREATEN_OBJECT,
monitorSuggest: res.rows.item(i).MONITOR_SUGGEST,
preventionSuggest: res.rows.item(i).PREVENTION_SUGGEST,
photoCode: res.rows.item(i).PHOTO_CODE,
memo: res.rows.item(i).MEMO,
mapFlag: res.rows.item(i).MAP_FLAG,
plane:res.rows.item(i).PLANE,
profile:res.rows.item(i).PROFILE
}
jsons.ceaSurveyCollapseList.push(CeaSurveyCollapse)
}
resolve(collapseIds);
}, function(tx, e) {
reject(e.message);
})
})
});
}
//5.2-获取崩塌变形活动表List
function fun_ceaCollapseDeformationList(collapseIds) {
return new Promise(function(resolve, reject) {
if(String(collapseIds).length > 0) {
db.transaction(function(tx) {
tx.executeSql('select * from CEA_COLLAPSE_DEFORMATION where COLLAPSE_ID IN (' + collapseIds + ') AND isUpdate = 1', [], function(tx, res) {
for(var i = 0; i < res.rows.length; i++) {
let CeaCollapseDeformation = {
deformationId: res.rows.item(i).DEFORMATION_ID,
deformationType: res.rows.item(i).DEFORMATION_TYPE,
deformationParts: res.rows.item(i).DEFORMATION_PARTS,
deformationFeature: res.rows.item(i).DEFORMATION_FEATURE,
happenTime: res.rows.item(i).HAPPEN_TIME,
collapseId: res.rows.item(i).COLLAPSE_ID
}
jsons.ceaCollapseDeformationList.push(CeaCollapseDeformation)
}
resolve();
}, function(tx, e) {
reject(e.message);
})
})
} else {
resolve();
}
});
}
//6.1-获取地形地貌及土地破坏野外调查表List
function fun_ceaSurveyLandDestroyList(mine_survey_id) {
return new Promise(function(resolve, reject) {
db.transaction(function(tx) {
tx.executeSql('select * from CEA_SURVEY_LAND_DESTROY where MINE_SURVEY_ID IN (' + mine_survey_id + ') AND isUpdate = 1', [], function(tx, res) {
let landDestroyIds = [];
for(var i = 0; i < res.rows.length; i++) {
landDestroyIds.push(res.rows.item(i).LAND_DESTROY_ID);
let CeaSurveyLandDestroy = {
landDestroyId: res.rows.item(i).LAND_DESTROY_ID,
mineSurveyId: res.rows.item(i).MINE_SURVEY_ID,
landscapeType: res.rows.item(i).LANDSCAPE_TYPE,
destroyType: res.rows.item(i).DESTROY_TYPE,
remainsType: res.rows.item(i).REMAINS_TYPE,
remainsInfluenceDegree: res.rows.item(i).REMAINS_INFLUENCE_DEGREE,
reserveInfulenceType: res.rows.item(i).RESERVE_INFULENCE_TYPE,
reserveInfluenceDegree: res.rows.item(i).RESERVE_INFLUENCE_DEGREE,
cityInfulenceType: res.rows.item(i).CITY_INFULENCE_TYPE,
cityInfulenceDistance: res.rows.item(i).CITY_INFULENCE_DISTANCE,
cityInfulenceDegree: res.rows.item(i).CITY_INFULENCE_DEGREE,
roadInfulenceType: res.rows.item(i).ROAD_INFULENCE_TYPE,
roadDistance: res.rows.item(i).ROAD_DISTANCE,
roadInfulenceDegree: res.rows.item(i).ROAD_INFULENCE_DEGREE,
otherInfluence: res.rows.item(i).OTHER_INFLUENCE,
photoCode: res.rows.item(i).PHOTO_CODE,
memo: res.rows.item(i).MEMO,
mapFlag: res.rows.item(i).MAP_FLAG,
excessmultiple: "no",
keypollutant: "no",
plane:res.rows.item(i).PLANE,
profile:res.rows.item(i).PROFILE
}
jsons.ceaSurveyLandDestroyList.push(CeaSurveyLandDestroy);
}
resolve(landDestroyIds);
}, function(tx, e) {
reject(e.message);
})
})
});
}
//6.2-获取土地破坏类型及面积List
function fun_ceaLandDestroyTypeList(landDestroyIds) {
return new Promise(function(resolve, reject) {
if(String(landDestroyIds).length > 0) {
db.transaction(function(tx) {
tx.executeSql('select * from CEA_LAND_DESTROY_TYPE where LAND_DESTROY_ID in (' + landDestroyIds + ') AND isUpdate = 1', [], function(tx, res) {
for(var i = 0; i < res.rows.length; i++) {
let CeaLandDestroyType = {
destroyId: res.rows.item(i).DESTROY_ID,
landDestroyId: res.rows.item(i).LAND_DESTROY_ID,
destroyType: res.rows.item(i).DESTROY_TYPE,
damagedType: res.rows.item(i).DAMAGED_TYPE,
plowlandArea: res.rows.item(i).PLOWLAND_AREA,
woodlandArea: res.rows.item(i).WOODLAND_AREA,
grassArea: res.rows.item(i).GRASS_AREA,
gardenArea: res.rows.item(i).GARDEN_AREA,
buildingArea: res.rows.item(i).BUILDING_AREA,
otherArea: res.rows.item(i).OTHER_AREA
}
jsons.ceaLandDestroyTypeList.push(CeaLandDestroyType)
}
resolve();
}, function(tx, e) {
reject(e.message);
})
});
} else {
resolve();
}
});
}
//7.1-获取地面塌陷、地裂缝调查表List
function fun_ceaSurveySinkList(mine_survey_id) {
return new Promise(function(resolve, reject) {
db.transaction(function(tx) {
tx.executeSql('select * from CEA_SURVEY_SINK where MINE_SURVEY_ID in (' + mine_survey_id + ') AND isUpdate = 1', [], function(tx, res) {
let sinkIds = [];
for(var i = 0; i < res.rows.length; i++) {
sinkIds.push(res.rows.item(i).SINK_ID);
let CeaSurveySink = {
sinkId: res.rows.item(i).SINK_ID,
mineSurveyId: res.rows.item(i).MINE_SURVEY_ID,
sinkCode: res.rows.item(i).SINK_CODE,
pitNumber: res.rows.item(i).PIT_NUMBER,
sinkArea: res.rows.item(i).SINK_AREA,
sinkLayout: res.rows.item(i).SINK_LAYOUT,
direction: res.rows.item(i).DIRECTION,
startDate: res.rows.item(i).START_DATE,
bloomStartDate: res.rows.item(i).BLOOM_START_DATE,
bloomEndDate: res.rows.item(i).BLOOM_END_DATE,
endDate: res.rows.item(i).END_DATE,
developChange: res.rows.item(i).DEVELOP_CHANGE,
fissureNumber: res.rows.item(i).FISSURE_NUMBER,
fissureArea: res.rows.item(i).FISSURE_AREA,
fissureGap: res.rows.item(i).FISSURE_GAP,
fissureArrange: res.rows.item(i).FISSURE_ARRANGE,
spreadDirection: res.rows.item(i).SPREAD_DIRECTION,
stepDirection: res.rows.item(i).STEP_DIRECTION,
landformType: res.rows.item(i).LANDFORM_TYPE,
soilEra: res.rows.item(i).SOIL_ERA,
soilProperty: res.rows.item(i).SOIL_PROPERTY,
soilThickness: res.rows.item(i).SOIL_THICKNESS,
rockEra: res.rows.item(i).ROCK_ERA,
rockProperty: res.rows.item(i).ROCK_PROPERTY,
rockThickness: res.rows.item(i).ROCK_THICKNESS,
destroyFarm: res.rows.item(i).DESTROY_FARM,
destroryHouse: res.rows.item(i).DESTRORY_HOUSE,
deadNumber: res.rows.item(i).DEAD_NUMBER,
trafficType: res.rows.item(i).TRAFFIC_TYPE,
directLoss: res.rows.item(i).DIRECT_LOSS,
riverFlowOrginal: res.rows.item(i).RIVER_FLOW_ORGINAL,
riverFlowPresent: res.rows.item(i).RIVER_FLOW_PRESENT,
riverFlowState: res.rows.item(i).RIVER_FLOW_STATE,
springFlowPresent: res.rows.item(i).SPRING_FLOW_PRESENT,
springFlowChange: res.rows.item(i).SPRING_FLOW_CHANGE,
wellState: res.rows.item(i).WELL_STATE,
wellFallHeight: res.rows.item(i).WELL_FALL_HEIGHT,
wellDriedDate: res.rows.item(i).WELL_DRIED_DATE,
plant: res.rows.item(i).PLANT,
plantState: res.rows.item(i).PLANT_STATE,
threatenPopulation: res.rows.item(i).THREATEN_POPULATION,
threatenProperty: res.rows.item(i).THREATEN_PROPERTY,
threatenFarm: res.rows.item(i).THREATEN_FARM,
threatenHouse: res.rows.item(i).THREATEN_HOUSE,
threaenObject: res.rows.item(i).THREAEN_OBJECT,
manageMeasure: res.rows.item(i).MANAGE_MEASURE,
manageCost: res.rows.item(i).MANAGE_COST,
costSource: res.rows.item(i).COST_SOURCE,
manageArea: res.rows.item(i).MANAGE_AREA,
controlMeasure: res.rows.item(i).CONTROL_MEASURE,
controlCost: res.rows.item(i).CONTROL_COST,
controlArea: res.rows.item(i).CONTROL_AREA,
photoCode: res.rows.item(i).PHOTO_CODE,
memo: res.rows.item(i).MEMO,
mapFlag: res.rows.item(i).MAP_FLAG,
boundaryCoordinates: "no",
plane:res.rows.item(i).PLANE,
profile:res.rows.item(i).PROFILE
}
jsons.ceaSurveySinkList.push(CeaSurveySink)
}
resolve(sinkIds);
}, function(tx, e) {
reject(e.message);
})
});
});
}
//7.2-获取地面裂缝单缝信息List
function fun_ceaSinkCrackList(sinkIds) {
return new Promise(function(resolve, reject) {
if(String(sinkIds).length > 0) {
db.transaction(function(tx) {
tx.executeSql('select * from CEA_SINK_CRACK where SINK_ID in (' + sinkIds + ') AND isUpdate = 1', [], function(tx, res) {
for(var i = 0; i < res.rows.length; i++) {
let CeaSinkCrack = {
crackId: res.rows.item(i).CRACK_ID,
sinkId: res.rows.item(i).SINK_ID,
form: res.rows.item(i).FORM,
derection: res.rows.item(i).DERECTION,
angle: res.rows.item(i).ANGLE,
tendency: res.rows.item(i).TENDENCY,
length: res.rows.item(i).LENGTH,
width: res.rows.item(i).WIDTH,
depth: res.rows.item(i).DEPTH,
property: res.rows.item(i).PROPERTY
}
jsons.ceaSinkCrackList.push(CeaSinkCrack)
}
resolve(sinkIds);
}, function(tx, e) {
reject(e.message);
})
})
} else {
resolve(sinkIds);
}
});
}
//7.3-获取地面塌陷单坑信息List
function fun_ceaSinkPitList(sinkIds) {
return new Promise(function(resolve, reject) {
if(String(sinkIds).length > 0) {
db.transaction(function(tx) {
tx.executeSql("select * from CEA_SINK_PIT where SINK_ID IN (" + sinkIds + ") AND isUpdate = 1", [], function(tx, res) {
for(let i = 0; i < res.rows.length; i++) {
let CeaSinkPit = {
pitId: res.rows.item(i).PIT_ID,
sinkId: res.rows.item(i).SINK_ID,
longAxis: res.rows.item(i).LONG_AXIS,
minorAxis: res.rows.item(i).MINOR_AXIS,
depth: res.rows.item(i).DEPTH,
area: res.rows.item(i).AREA,
shape: res.rows.item(i).SHAPE
}
jsons.ceaSinkPitList.push(CeaSinkPit)
}
resolve();
}, function(tx, e) {
reject(e.message);
})
})
} else {
resolve(sinkIds);
}
});
}
//8.1-获取泥石流及其隐患调查表List
function fun_ceaSurveyDebrisList(mine_survey_id) {
return new Promise(function(resolve, reject) {
db.transaction(function(tx) {
tx.executeSql('select * from CEA_SURVEY_DEBRIS where MINE_SURVEY_ID IN (' + mine_survey_id + ') AND isUpdate = 1', [], function(tx, res) {
let debrisIds = [];
for(let i = 0; i < res.rows.length; i++) {
debrisIds.push(res.rows.item(i).DEBRIS_ID);
let CeaSurveyDebris = {
debrisId: res.rows.item(i).DEBRIS_ID,
mineSurveyId: res.rows.item(i).MINE_SURVEY_ID,
happenFlag: res.rows.item(i).HAPPEN_FLAG,
happenDate: res.rows.item(i).HAPPEN_DATE,
longtitude: res.rows.item(i).LONGTITUDE,
latitude: res.rows.item(i).LATITUDE,
evevation: res.rows.item(i).EVEVATION,
waterPowerType: res.rows.item(i).WATER_POWER_TYPE,
rockA: res.rows.item(i).ROCK_A,
rockB: res.rows.item(i).ROCK_B,
rockC: res.rows.item(i).ROCK_C,
supplyApproach: res.rows.item(i).SUPPLY_APPROACH,
supplyPosition: res.rows.item(i).SUPPLY_POSITION,
fanIntegrity: res.rows.item(i).FAN_INTEGRITY,
fanAmplitude: res.rows.item(i).FAN_AMPLITUDE,
fanTendency: res.rows.item(i).FAN_TENDENCY,
fanLength: res.rows.item(i).FAN_LENGTH,
fanWidth: res.rows.item(i).FAN_WIDTH,
fanAngle: res.rows.item(i).FAN_ANGLE,
fanRiverType: res.rows.item(i).FAN_RIVER_TYPE,
geologyStructure: res.rows.item(i).GEOLOGY_STRUCTURE,
earthquakeIntensity: res.rows.item(i).EARTHQUAKE_INTENSITY,
forestUsage: res.rows.item(i).FOREST_USAGE,
scrubUsage: res.rows.item(i).SCRUB_USAGE,
grasslandUsage: res.rows.item(i).GRASSLAND_USAGE,
plowlandUsage: res.rows.item(i).PLOWLAND_USAGE,
buildingUsage: res.rows.item(i).BUILDING_USAGE,
otherUsage: res.rows.item(i).OTHER_USAGE,
controlMeasuresFlag: res.rows.item(i).CONTROL_MEASURES_FLAG,
controlMeasures: res.rows.item(i).CONTROL_MEASURES,
monitorMeasuresFlag: res.rows.item(i).MONITOR_MEASURES_FLAG,
monitorMeasures: res.rows.item(i).MONITOR_MEASURES,
damageObjeat: res.rows.item(i).DAMAGE_OBJEAT,
deadNumber: res.rows.item(i).DEAD_NUMBER,
directLoss: res.rows.item(i).DIRECT_LOSS,
disasterLevel: res.rows.item(i).DISASTER_LEVEL,
burstFrequency: res.rows.item(i).BURST_FREQUENCY,
mudQuantity: res.rows.item(i).MUD_QUANTITY,
debrisType: res.rows.item(i).DEBRIS_TYPE,
debrisLevl: res.rows.item(i).DEBRIS_LEVL,
mudA: res.rows.item(i).MUD_A,
harmfulGeologyLevel: res.rows.item(i).HARMFUL_GEOLOGY_LEVEL,
supplyLengthRatio: res.rows.item(i).SUPPLY_LENGTH_RATIO,
fanArea: res.rows.item(i).FAN_AREA,
channelSlope: res.rows.item(i).CHANNEL_SLOPE,
effect: res.rows.item(i).EFFECT,
vegetationCoverageRatio: res.rows.item(i).VEGETATION_COVERAGE_RATIO,
erosionAmplitude: res.rows.item(i).EROSION_AMPLITUDE,
lithologyFactor: res.rows.item(i).LITHOLOGY_FACTOR,
materialReserves: res.rows.item(i).MATERIAL_RESERVES,
hillsideGradient: res.rows.item(i).HILLSIDE_GRADIENT,
grooveCrossType: res.rows.item(i).GROOVE_CROSS_TYPE,
materialThick: res.rows.item(i).MATERIAL_THICK,
basinArea: res.rows.item(i).BASIN_AREA,
relativeDispersion: res.rows.item(i).RELATIVE_DISPERSION,
blockingDegree: res.rows.item(i).BLOCKING_DEGREE,
totalScore: res.rows.item(i).TOTAL_SCORE,
occurDegree: res.rows.item(i).OCCUR_DEGREE,
developStage: res.rows.item(i).DEVELOP_STAGE,
threatenNumber: res.rows.item(i).THREATEN_NUMBER,
threatenProperty: res.rows.item(i).THREATEN_PROPERTY,
dangerLevel: res.rows.item(i).DANGER_LEVEL,
threatenObject: res.rows.item(i).THREATEN_OBJECT,
monitorSuggestion: res.rows.item(i).MONITOR_SUGGESTION,
controlSuggestion: res.rows.item(i).CONTROL_SUGGESTION,
photoCode: res.rows.item(i).PHOTO_CODE,
mapFlag: res.rows.item(i).MAP_FLAG,
memo: res.rows.item(i).MEMO,
plane:res.rows.item(i).PLANE,
profile:res.rows.item(i).PROFILE
}
jsons.ceaSurveyDebrisList.push(CeaSurveyDebris)
}
resolve(debrisIds);
}, function(tx, e) {
reject(e.message);
})
})
});
}
//8.2-获取不良地质体List
function fun_ceaBadGeologicalList(debrisIds) {
return new Promise(function(resolve, reject) {
if(String(debrisIds).length > 0) {
db.transaction(function(tx) {
tx.executeSql("select * from CEA_BAD_GEOLOGICAL where DEBRIS_ID in (" + debrisIds + ") AND isUpdate = 1", [], function(tx, res) {
for(let i = 0; i < res.rows.length; i++) {
let CeaBadGeological = {
geologicalId: res.rows.item(i).GEOLOGICAL_ID,
debrisId: res.rows.item(i).DEBRIS_ID,
geologicalType: res.rows.item(i).GEOLOGICAL_TYPE,
level: res.rows.item(i).LEVEL,
scale: res.rows.item(i).SCALE
}
jsons.ceaBadGeologicalList.push(CeaBadGeological)
}
resolve();
}, function(tx, e) {
reject(e.message);
})
})
} else {
resolve();
}
});
}
//9.1-废水废液固废调查总表List
function fun_ceaSurveyWasteList(mine_survey_id) {
return new Promise(function(resolve, reject) {
db.transaction(function(tx) {
tx.executeSql("select * from CEA_SURVEY_WASTE where MINE_SURVEY_ID in (" + mine_survey_id + ") AND isUpdate = 1", [], function(tx, res) {
let wasteSurveyIds = [];
for(let i = 0; i < res.rows.length; i++) {
wasteSurveyIds = res.rows.item(i).WASTE_SURVEY_ID;
let CeaSurveyWaste = {
wasteSurveyId: res.rows.item(i).WASTE_SURVEY_ID,
mineSurveyId: res.rows.item(i).MINE_SURVEY_ID,
memo: res.rows.item(i).MEMO,
mapFlag: res.rows.item(i).MAP_FLAG
}
jsons.ceaSurveyWasteList.push(CeaSurveyWaste)
}
resolve(wasteSurveyIds);
}, function(tx, e) {
reject(e.message);
})
})
});
}
//9.2-土壤样品采集记录表List
function fun_ceaWasteSoilSampleList(wasteSurveyIds) {
return new Promise(function(resolve, reject) {
if(String(wasteSurveyIds).length > 0) {
db.transaction(function(tx) {
tx.executeSql("select * from CEA_WASTE_SOIL_SAMPLE where WASTE_SURVEY_ID in (" + wasteSurveyIds + ") AND isUpdate = 1", [], function(tx, res) {
for(let i = 0; i < res.rows.length; i++) {
let CeaWasteSoilSample = {
soilId: res.rows.item(i).SOIL_ID,
wasteSurveyId: res.rows.item(i).WASTE_SURVEY_ID,
sampleCode: res.rows.item(i).SAMPLE_CODE,
x: res.rows.item(i).x,
y: res.rows.item(i).y,
elevation: res.rows.item(i).ELEVATION,
samplePosition: res.rows.item(i).SAMPLE_POSITION,
landformTerrain: res.rows.item(i).LANDFORM_TERRAIN,
soilType: res.rows.item(i).SOIL_TYPE,
soilTexture: res.rows.item(i).SOIL_TEXTURE,
crops: res.rows.item(i).CROPS,
farmingWay: res.rows.item(i).FARMING_WAY,
soilColour: res.rows.item(i).SOIL_COLOUR,
sampleCapacity: res.rows.item(i).SAMPLE_CAPACITY,
soilPh: res.rows.item(i).SOIL_PH,
profileMoistuer: res.rows.item(i).PROFILE_MOISTUER,
sampleDepth: res.rows.item(i).SAMPLE_DEPTH,
position: res.rows.item(i).POSITION,
testProject: res.rows.item(i).TEST_PROJECT,
irrigationWater: res.rows.item(i).IRRIGATION_WATER,
pollutionType: res.rows.item(i).POLLUTION_TYPE,
pollutionDistance: res.rows.item(i).POLLUTION_DISTANCE,
photoCode: res.rows.item(i).PHOTO_CODE,
memo: res.rows.item(i).MEMO
}
jsons.ceaWasteSoilSampleList.push(CeaWasteSoilSample)
}
resolve(wasteSurveyIds);
}, function(tx, e) {
console.log(e.message)
reject(e.message);
})
})
} else {
resolve(wasteSurveyIds);
}
});
}
//9.3-水质样品采集记录表List
function fun_ceaWasteWaterSampleList(wasteSurveyIds) {
return new Promise(function(resolve, reject) {
if(String(wasteSurveyIds).length > 0) {
db.transaction(function(tx) {
tx.executeSql('select * from CEA_WASTE_WATER_SAMPLE where WASTE_SURVEY_ID in (' + wasteSurveyIds + ') AND isUpdate = 1', [], function(tx, res) {
for(var i = 0; i < res.rows.length; i++) {
let CeaWasteWaterSample = {
waterId: res.rows.item(i).WATER_ID,
wasteSurveyId: res.rows.item(i).WASTE_SURVEY_ID,
weather: res.rows.item(i).WEATHER,
sampleCode: res.rows.item(i).SAMPLE_CODE,
waterType: res.rows.item(i).WATER_TYPE,
samplingPosition: res.rows.item(i).SAMPLING_POSITION,
x: res.rows.item(i).X,
y: res.rows.item(i).Y,
elevation: res.rows.item(i).ELEVATION,
buriedDepth: res.rows.item(i).BURIED_DEPTH,
wellDepth: res.rows.item(i).WELL_DEPTH,
wellDiameter: res.rows.item(i).WELL_DIAMETER,
wellComplete: res.rows.item(i).WELL_COMPLETE,
wellBuildDate: res.rows.item(i).WELL_BUILD_DATE,
wellPurpose: res.rows.item(i).WELL_PURPOSE,
wellType: res.rows.item(i).WELL_TYPE,
wallStructure: res.rows.item(i).WALL_STRUCTURE,
waterQualityType: res.rows.item(i).WATER_QUALITY_TYPE,
aquiferLithology: res.rows.item(i).AQUIFER_LITHOLOGY,
springType: res.rows.item(i).SPRING_TYPE,
springFlow: res.rows.item(i).SPRING_FLOW,
springColoer: res.rows.item(i).SPRING_COLOER,
springWaterTemperature: res.rows.item(i).SPRING_WATER_TEMPERATURE,
springAirTemperature: res.rows.item(i).SPRING_AIR_TEMPERATURE,
springTransparent: res.rows.item(i).SPRING_TRANSPARENT,
springSmell: res.rows.item(i).SPRING_SMELL,
sufaceWave: res.rows.item(i).SUFACE_WAVE,
waterSamplePosition: res.rows.item(i).WATER_SAMPLE_POSITION,
waterColour: res.rows.item(i).WATER_COLOUR,
waterTemperature: res.rows.item(i).WATER_TEMPERATURE,
waterAirTemperature: res.rows.item(i).WATER_AIR_TEMPERATURE,
waterTransparent: res.rows.item(i).WATER_TRANSPARENT,
waterSmell: res.rows.item(i).WATER_SMELL,
pollutionSourcesType: res.rows.item(i).POLLUTION_SOURCES_TYPE,
pollutionSourcesPosition: res.rows.item(i).POLLUTION_SOURCES_POSITION,
pollutionRiverDistance: res.rows.item(i).POLLUTION_RIVER_DISTANCE,
localeAirTemperature: res.rows.item(i).LOCALE_AIR_TEMPERATURE,
tds: res.rows.item(i).TDS,
eh: res.rows.item(i).EH,
localeWaterTemperature: res.rows.item(i).LOCALE_WATER_TEMPERATURE,
ph: res.rows.item(i).PH,
dissolvedOxygen: "no",
analysisProject: res.rows.item(i).ANALYSIS_PROJECT,
photoCode: res.rows.item(i).PHOTO_CODE,
memo: res.rows.item(i).MEMO
}
jsons.ceaWasteWaterSampleList.push(CeaWasteWaterSample)
}
resolve(wasteSurveyIds);
}, function(tx, e) {
reject(e.message);
})
})
} else {
resolve(wasteSurveyIds);
}
});
}
//9.4-固废调查表List
function fun_ceaWasteSolidList(wasteSurveyIds) {
return new Promise(function(resolve, reject) {
if(String(wasteSurveyIds).length > 0) {
db.transaction(function(tx) {
tx.executeSql("select * from CEA_WASTE_SOLID where WASTE_SURVEY_ID in (" + wasteSurveyIds + ") AND isUpdate = 1", [], function(tx, res) {
for(let i = 0; i < res.rows.length; i++) {
let CeaWasteSolid = {
solidId: res.rows.item(i).SOLID_ID,
wasteSurveyId: res.rows.item(i).WASTE_SURVEY_ID,
surveyType: res.rows.item(i).SURVEY_TYPE,
totalStore: res.rows.item(i).TOTAL_STORE,
output: res.rows.item(i).OUTPUT,
usedQuatity: res.rows.item(i).USED_QUATITY,
useType: res.rows.item(i).USE_TYPE,
harmfulSubstance: res.rows.item(i).HARMFUL_SUBSTANCE,
effectObject: res.rows.item(i).EFFECT_OBJECT,
destroyArea: res.rows.item(i).DESTROY_AREA
}
jsons.ceaWasteSolidList.push(CeaWasteSolid)
}
resolve(wasteSurveyIds);
}, function(tx, e) {
reject(e.message);
})
})
} else {
resolve(wasteSurveyIds);
}
})
}
//9.5--废水废液调查表List
function fun_ceaWasteLiquidList(wasteSurveyIds) {
return new Promise(function(resolve, reject) {
if(String(wasteSurveyIds).length > 0) {
db.transaction(function(tx) {
tx.executeSql("select * from CEA_WASTE_LIQUID where WASTE_SURVEY_ID in (" + wasteSurveyIds + ") AND isUpdate = 1", [], function(tx, res) {
for(var i = 0; i < res.rows.length; i++) {
let CeaWasteLiquid = {
liquidId: res.rows.item(i).LIQUID_ID,
wasteSurveyId: res.rows.item(i).WASTE_SURVEY_ID,
surveyType: res.rows.item(i).SURVEY_TYPE,
output: res.rows.item(i).OUTPUT,
harmfulSubstance: res.rows.item(i).HARMFUL_SUBSTANCE,
discharge: res.rows.item(i).DISCHARGE,
waterLevel: res.rows.item(i).WATER_LEVEL,
dischargeTo: res.rows.item(i).DISCHARGE_TO,
useType: res.rows.item(i).USE_TYPE,
influenceObject: res.rows.item(i).INFLUENCE_OBJECT
}
jsons.ceaWasteLiquidList.push(CeaWasteLiquid)
}
resolve(wasteSurveyIds);
}, function(tx, e) {
reject(e.message);
})
});
} else {
resolve(wasteSurveyIds);
}
})
}
//1、先上传数据
function uploading(jsons) {
console.log(jsons)
$.ajax({
type: "post",
url: ajaxUrl+'/surveyDataUploads/uploadData',
data: {
data: JSON.stringify(jsons)
},
dataType: "JSON",
success: function(result) {
//2、上传成功数据后再上传图片
db.transaction(function(tx) {
tx.executeSql("select * from images where mineSurveyId in ("+mine_survey_id+")",[],function (tx,res) {
if (res.rows.length>0) {
for(let i = 0; i < res.rows.length; i++) {
$.ajax({
type: "post",
url: ajaxUrl+'/surveyDataUploads/uploadPic',
data: {
uploadPath:res.rows.item(i).uploadPath,
base64:res.rows.item(i).base64
},
dataType: "JSON",
success: function(result) {
console.log(result.success)
console.log("上传成功！" + result)
},
error: function(xhr) {
console.log(xhr)
}
});
}
}
},function (trx,err) {
console.log("查询失败"+err.message)
})
})//end
//上传成功后，重置上传按钮上面的字
mui("#shangchuan").button('reset');//重置按钮状态
getMineInfow(mine_survey_id);
console.log("上传成功！" + result)
},
error: function(xhr) {
console.log(xhr)
}
});
}
})
function getMineInfow(mine_survey_id) {
db.transaction(function(tx) {
tx.executeSql('SELECT * FROM shifoushangchuan', [],
function(ctx, result) {
tx.executeSql("UPDATE shifoushangchuan SET shifoushangchuan='是' WHERE MINE_SURVEY_ID=?",[mine_survey_id],
function(ctx,result){
alert("上传成功")
},function(ctx,error){
console.error(error.message);
});
},
function(ctx, error) {
console.error(error.message);
});
});
}
矿山搜索
//$("#mineName").click("input", function() {
//var mineName = $(this).val();
//var wobj = plus.webview.getWebviewById('upload.html');
//
//db.transaction(function(tx) {
//
//
//tx.executeSql('SELECT * FROM MINE_SURVEY_INFO WHERE MINE_NAME like ?', ["%" + mineName + "%"], function(tx, results) {
//var len = Number(results.rows.length);
//
//$(".seatchHide").hide()
//if(len == 0) {
//
//$("#seatchData").html('
没有查询到相关矿山信息')//
//}
//else if(len > 1000) {
//$("#seatchData").html('
查询结果过多，请增加搜索关键字')//}
//else {
//
//$("#seatchData").html('');
//for(var i = 0; i < len; i++) {
//$("#seatchData").append('
- '+'
- ' + results.rows.item(i).MINE_NAME + '' + results.rows.item(i).MINE_SURVEY_ID + '
//}
//}
//}, function(ex, e) {
//console.log(e.message);
//});
//});
//});
一键复制
编辑
Web IDE
原始数据
按行查看
历史
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
