/**
* 查询条件下拉框列表数据与新增页面下拉列表查询
*/
public Map <String, Object> selectList(QhyfController ctl) throws ActiveRecordException {
Page <BizApproveSayingInfo> BizApproveSayingInfoPage = null;
List <Object> paras = new ArrayList <Object>();
List <Record> enterpriseList = null;
List <Record> institutionsList = null;
List <Record> bodyList = null;
/*List<Record> fileList = null;
List<Record> approveList=null;*/
List <Record> fileNameList = null;
List<Record> uuidList=null;
Map <String, Object> recordData = null;
//获取核心企业
String enterpriseSql = "select uuid AS core_enterprise_id, core_enterprise_name from biz_core_enterprise where sys_status = 1 ";
enterpriseList = Db.find(enterpriseSql);
// 获取金融机构数据表信息
String institutionsSql = "select uuid AS financial_institutions_id, financial_institutions_name from biz_financial_institutions where sys_status = 1 ";
institutionsList = Db.find(institutionsSql);
// 获取签约主体数据表信息
String bodySql = "select uuid AS signing_body_id, sign_body_name from biz_signing_body where sys_status = 1 ";
bodyList = Db.find(bodySql);
// 类别
/* String fileSql = " select DICT_ID AS file_type_id, DICT_NAME AS file_type_name from sys_dict_entry where DICT_TYPE_ID = 'biz_file_type' and sys_status = 1 ";
fileList = Db.find(fileSql);
//获取审核类别
String approveSql=" select DICT_ID AS approve_type_id,DICT_NAME AS approve_type_name from sys_dict_entry where DICT_TYPE_ID = 'biz_approve_type' and sys_status = 1 ";
approveList=Db.find(approveSql);*/
//获取文件名
String fileNameSql = " SELECT DISTINCT " +
" b.uuid AS file_id, " +
" b.file_name " +
"FROM " +
" biz_fullset_file_info a, " +
" biz_document_define b " +
"WHERE " +
" a.sys_status = 1 " +
"AND b.sys_status = 1 " +
"AND a.file_id = b.uuid " +
"AND a.file_type = '03' " +
"and a.approve_type = '11' ";
fileNameList = Db.find(fileNameSql);
recordData = new HashMap <String, Object>();
recordData.put("enterpriseList", enterpriseList);
recordData.put("institutionsList", institutionsList);
recordData.put("bodyList", bodyList);
/* recordData.put("fileList", fileList);
recordData.put("approveList", approveList);*/
recordData.put("fileNameList", fileNameList);
return recordData;
}
//为下拉列表赋值
ajax_jsonp("/app/bl/bizapprovesaying/datalist/", null,
function (response) {
//核心企业数据表信息
$.each(response.data[0].enterpriseList, function (index, value) {
queryDiv.find("#coreEnterpriseName").append("<option value='" + value.coreEnterpriseId +
"'>" + value.coreEnterpriseName + "</option>");
});
//签约主体数据表信息
$.each(response.data[0].bodyList, function (index, value) {
queryDiv.find("#signBodyName").append("<option value='" + value.signingBodyId +
"'>" + value.signBodyName + "</option>");
});
//金融机构数据表信息
$.each(response.data[0].institutionsList, function (index, value) {
queryDiv.find("#financialInstitutionsName").append("<option value='" + value.financialInstitutionsId +
"'>" + value.financialInstitutionsName + "</option>");
});
$.each(response.data[0].fileNameList, function (index, value) {
queryDiv.find("#fileName").append("<option value='" + value.fileId +
"'>" + value.fileName + "</option>");
});
/* //类别
$.each(response.data[0].fileList, function (index, value) {
queryDiv.find("#fileType").append("<option value='" + value.fileTypeId +
"'>" + value.fileTypeName + "</option>");
});
//审核类别
$.each(response.data[0].approveList, function (index, value) {
queryDiv.find("#approveType").append("<option value='" + value.approveTypeId +
"'>" + value.approveTypeName + "</option>");
});*/
//为编辑下拉框赋值
if (isNotNull(initData)) {
var response = ajax_jsonp_sync("/app/bl/bizapprovesaying/compile/", {"uuid": initData.uuid},"GET",null)
var info = response.responseJSON.data[0];
//将数据显示到指定区域
$.each(info, function (key, val) {
var element = $("#bizApproveSayingEditAdminForm").find("textarea[id='" + key
+ "']");
if (isNotEmptyDOM(element))
setInputVal(element, val);
});
debugger
$("#bizApproveSayingEditAdminForm").find("#coreEnterpriseName").find("option[value='" + response.responseJSON.data[0].coreEnterpriseId + "']").attr("selected", true);
$("#bizApproveSayingEditAdminForm").find("#financialInstitutionsName").find("option[value='" + response.responseJSON.data[0].financialInstitutionsId + "']").attr("selected", true);
$("#bizApproveSayingEditAdminForm").find("#signBodyName").find("option[value='" + response.responseJSON.data[0].signingBodyId + "']").attr("selected", true);
$("#bizApproveSayingEditAdminForm").find("#fileName").find("option[value='" + response.responseJSON.data[0].fileId + "']").attr("selected", true);
// $("#bizApproveSayingEditAdminForm").find("#fileType").find("option[value='"+response.data[0].fileType+"']").attr("selected",true);
// $("#bizApproveSayingEditAdminForm").find("#approveType").find("option[value='"+response.data[0].approveType+"']").attr("selected",true);
$("#bizApproveSayingEditAdminForm").find("#fileNameHidden").val(response.responseJSON.data[0].fileId);
var saying = $("#bizApproveSayingEditAdminForm").find("#saying").val();
if(saying != null && saying != ""){
var res = ajax_jsonp_sync("/app/bl/bizapprovesaying/querydata/", {"saying": saying},"GET",null)
$("#bizApproveSayingEditAdminForm").find("#cuuid").val(res.responseJSON.data[0].uuid);
}
}
}, null, "GET");
// 核心企业选择后,文件名需要联动选择
queryDiv.find("#coreEnterpriseName").on("change", function () {
//获取当前选中核心企业的值
var val = $(this).val();
if (!val) {
return;
}
//文件名信息显示
ajax_jsonp("app/bl/bizapprovesaying/getFileNameList",
{
"coreEnterpriseId": val,
"financialInstitutionsId": queryDiv.find("#financialInstitutionsName").val(),
"signingBodyId": queryDiv.find("#signBodyName").val(),
// "fileType": queryDiv.find("#fileType").val(),
// "approveType": queryDiv.find("#approveType").val()
}, function (response) {
if (!checkResponseData(response)
|| !isNotNull(response.data[0]))
return;
//清空文件名下拉选框的值
queryDiv.find("#fileName").empty();
addOption(queryDiv.find("#fileName"), "请选择...", "");
//文件名
$.each(response.data[0].filenList, function (index, value) {
queryDiv.find("#fileName").append("<option value='" + value.fileId +
"'>" + value.fileName + "</option>");
});
$("#bizApproveSayingEditAdminForm").find("#fileName").find("option[value='" + $("#bizApproveSayingEditAdminForm").find("#fileNameHidden").val() + "']").attr("selected", true);
}, null, "GET");
});
// 金融机构选择后,文件名需要联动选择
queryDiv.find("#financialInstitutionsName").on("change", function () {
//获取当前选中金融机构的值
var val = $(this).val();
if (!val) {
return;
}
//文件名信息显示
ajax_jsonp("app/bl/bizapprovesaying/getFileNameList",
{
"coreEnterpriseId": queryDiv.find("#coreEnterpriseName").val(),
"financialInstitutionsId": val,
"signingBodyId": queryDiv.find("#signBodyName").val(),
// "fileType": queryDiv.find("#fileType").val(),
// "approveType": queryDiv.find("#approveType").val()
}, function (response) {
if (!checkResponseData(response)
|| !isNotNull(response.data[0]))
return;
//清空文件名下拉选框的值
queryDiv.find("#fileName").empty();
addOption(queryDiv.find("#fileName"), "请选择...", "");
//文件名
$.each(response.data[0].filenList, function (index, value) {
queryDiv.find("#fileName").append("<option value='" + value.fileId +
"'>" + value.fileName + "</option>");
});
$("#bizApproveSayingEditAdminForm").find("#fileName").find("option[value='" + $("#bizApproveSayingEditAdminForm").find("#fileNameHidden").val() + "']").attr("selected", true);
}, null, "GET");
});
// 签约主体选择后,文件名需要联动选择
queryDiv.find("#signBodyName").on("change", function () {
//获取当前选中签约主体的值
var val = $(this).val();
if (!val) {
return;
}
//文件名信息显示
ajax_jsonp("app/bl/bizapprovesaying/getFileNameList",
{
"coreEnterpriseId": queryDiv.find("#coreEnterpriseName").val(),
"financialInstitutionsId": queryDiv.find("#financialInstitutionsName").val(),
"signingBodyId": val,
// "fileType": queryDiv.find("#fileType").val(),
// "approveType": queryDiv.find("#approveType").val()
}, function (response) {
if (!checkResponseData(response)
|| !isNotNull(response.data[0]))
return;
//清空文件名下拉选框的值
queryDiv.find("#fileName").empty();
addOption(queryDiv.find("#fileName"), "请选择...", "");
//文件名
$.each(response.data[0].filenList, function (index, value) {
queryDiv.find("#fileName").append("<option value='" + value.fileId +
"'>" + value.fileName + "</option>");
});
$("#bizApproveSayingEditAdminForm").find("#fileName").find("option[value='" + $("#bizApproveSayingEditAdminForm").find("#fileNameHidden").val() + "']").attr("selected", true);
}, null, "GET");
});
// 文件类别选择后,文件名需要联动选择
queryDiv.find("#fileType").on("change", function () {
//获取当前选中文件类别的值
var val = $(this).val();
if (!val) {
return;
}
//类别选择
if (val == '01' || val == '03') {
queryDiv.find("#approveTypeDiv").css("display", "block");
} else {
queryDiv.find("#approveTypeDiv").css("display", "none");
}
//文件名信息显示
ajax_jsonp("app/bl/bizapprovesaying/getFileNameList",
{
"coreEnterpriseId": queryDiv.find("#coreEnterpriseName").val(),
"financialInstitutionsId": queryDiv.find("#financialInstitutionsName").val(),
"signingBodyId": queryDiv.find("#signBodyName").val(),
"fileType": val,
"approveType": queryDiv.find("#approveType").val()
}, function (response) {
if (!checkResponseData(response)
|| !isNotNull(response.data[0]))
return;
//清空文件名下拉选框的值
queryDiv.find("#fileName").empty();
addOption(queryDiv.find("#fileName"), "请选择...", "");
//文件名
$.each(response.data[0].filenList, function (index, value) {
queryDiv.find("#fileName").append("<option value='" + value.fileId +
"'>" + value.fileName + "</option>");
});
$("#bizApproveSayingEditAdminForm").find("#fileName").find("option[value='" + $("#bizApproveSayingEditAdminForm").find("#fileNameHidden").val() + "']").attr("selected", true);
}, null, "GET");
});
// 审核类别选择后,文件名需要联动选择
queryDiv.find("#approveType").on("change", function () {
//获取当前选中审核类别的值
var val = $(this).val();
if (!val) {
return;
}
//文件名信息显示
ajax_jsonp("app/bl/bizapprovesaying/getFileNameList",
{
"coreEnterpriseId": queryDiv.find("#coreEnterpriseName").val(),
"financialInstitutionsId": queryDiv.find("#financialInstitutionsName").val(),
"signingBodyId": queryDiv.find("#signBodyName").val(),
"fileType": queryDiv.find("#fileType").val(),
"approveType": val
}, function (response) {
if (!checkResponseData(response)
|| !isNotNull(response.data[0]))
return;
//清空文件名下拉选框的值
queryDiv.find("#fileName").empty();
addOption(queryDiv.find("#fileName"), "请选择...", "");
//文件名
$.each(response.data[0].filenList, function (index, value) {
queryDiv.find("#fileName").append("<option value='" + value.fileId +
"'>" + value.fileName + "</option>");
});
$("#bizApproveSayingEditAdminForm").find("#fileName").find("option[value='" + $("#bizApproveSayingEditAdminForm").find("#fileNameHidden").val() + "']").attr("selected", true);
}, null, "GET");
});
},//init() END