|
|
var view = this.form.get("view_gz");
var dept = this.form.get('ssdw_gz').getData(); // 正确的
var riqi = this.form.get('riqi_gz').getData(); // 正确的
var month = riqi.substring(5, 7); // 截取月份字符串
var year = riqi.substring(0, 4); // 截取前4个字符，获取年份
var self = this;
// 初始化一个数组来存储所有员工的数据
var data_all = [];
/*
根据客户单位信息进行过滤查询数据
*/
self.view.lookup({
"view": "单位社保信息设置列表",
"application": "薪酬管理",
"filter": [
{
"logic": "and",
"path": "ssdw_11",
"comparison": "==",
"value": dept,
"formatType": "textValue"
}
]
}, function(data) {
var grid = data.grid; // 得到过滤后的数据
if (grid && grid.length > 0) {
var ylbxbldw = grid[0].data.ylbxbldw;
var gsbxbldw = grid[0].data.gsbxbldw;
var ylbxbldw_1 = grid[0].data.ylbxbldw_1;
var sybxbldw = grid[0].data.sybxbldw;
var sybxbldw_1 = grid[0].data.sybxbldw_1;
// 获取指定部门的员工列表
var view_dangan = {
"view": "结算数据-档案信息表",
"application": "结算管理",
"filter": [
{
"logic": "and",
"path": "ruzhidanwei",
"comparison": "==",
"value": dept,
"formatType": "textValue"
},
{
"logic": "and",
"path": "status",
"comparison": "notEquals",
"value": "离职",
"formatType": "textValue"
}
]
};
// 查询员工信息
self.view.lookup(view_dangan, function(data1) {
if (!data1 || data1.grid.length === 0) {
return;
}
for (var i = 0; i < data1.grid.length; i++) {
var username = data1.grid[i].data.username;
// 根据员工姓名查询档案数据
self.view.lookup({
"view": "员工档案列表",
"application": "入转调离数据",
"filter": [{
"logic": "and",
"path": "username",
"comparison": "==",
"value": username,
"formatType": "textValue"
}]
}, function(data) {
var grid = data.grid;
if (grid && grid.length > 0) {
var dwcs = grid[0].data.danweichengshi;
var ylbxjs_1 = grid[0].data.shebao;
var ylbxjs_2 = grid[0].data.shebao;
var zfgjjjs_1 = grid[0].data.gongjijin;
var gjjbl = grid[0].data.gongjijinbili;
var ylbxblgr = grid[0].data.yanglaobaoxianbili;
var ylbxblgr_1 = grid[0].data.yiliaobaoxianbili;
var sybxblgr = grid[0].data.shiyebaoxianbili;
var dict = new self.Dict("SalaryConfig");
var tjdeyladata = dict.get("tjdeyla");//天津个人医疗保险a--1，4，7，11月份21元
var tjgrylbdatb = dict.get("tjdeylb");//天津个人医疗保险b--其他月份22元
// 组装数据
var data_one = {
"data_xm": grid[0].data.username,
"data_ssdw": grid[0].data.ruzhidanwei,
"date_nd" : "",
"date_yf" : "",
"data_gwgz" : 0,
"data_cfkc" : 0,
"data_gzze" : 0,
"data_gwjj" : 0,
"data_jbgz": grid[0].data.gongzi,
"data_jxjj" : 0,
"data_jxgz" : 0,
"data_jxzj" : 0,
"data_glgz" : 0,
"data_cb" : 0,
"data_jwsrhf" : 0,
"data_zbf" : 0,
"data_qt" : 0,
"data_jtbt" : 0,
"data_sqyf" : 0,
"date_dwcs": grid[0].data.danweichengshi,
"data_zzrq": grid[0].data.zhuanzhengriqi,
"data_gjjbl": grid[0].data.gongjijinbili,
"data_ylbxblgr": grid[0].data.yanglaobaoxianbili,
"data_ylbxblgr_1": grid[0].data.yiliaobaoxianbili,
"data_sybxblgr": grid[0].data.shiyebaoxianbili,
"data_ylbxbldw" : ylbxbldw,
"data_gsbxbldw" : gsbxbldw,
"data_ylbxbldw_1" : ylbxbldw_1,
"data_sybxbldw" : sybxbldw,
"data_sybxbldw_1" : sybxbldw_1,
"data_sbjs": grid[0].data.shebao,
"data_ylbxjs_1": grid[0].data.shebao,
"data_ylbxjs_2": grid[0].data.shebao,
"data_zfgjjjs_1": grid[0].data.gongjijin,
"date_nzjjt" : "",
"date_deyl" : "",
"date_zxkchj" : "",
"date_grsbgjjhj_bj" : "",
"date_cbj" : "",
"date_hjkc" : "",
"date_qysbgjjhj" : "",
"date_flj" : "",
"date_sfgz" : "",
"data_gsbxdw" : grid[0].data.shebao * gsbxbldw,//工伤保险-单位
"data_sybxdw_1" : grid[0].data.shebao * sybxbldw_1,//生育保险-单位
"data_ylbxdw_1" : grid[0].data.shebao * ylbxbldw,//养老保险-单位
"data_jbyldw_2" : grid[0].data.shebao * ylbxbldw_1,//基本医疗-单位
"data_sybxdw" : grid[0].data.shebao * sybxbldw,//失业保险-单位
"data_zfgjjdw_1" : zfgjjjs_1 * gjjbl,//住房公积金-单位
"data_yylxgr_1": ylbxjs_1 * ylbxblgr,//养老保险-个人
"data_zfgjjgr_1": zfgjjjs_1 * gjjbl,//住房公积金-个人
"data_sybxgr": grid[0].data.shebao * sybxblgr,//失业保险-个人
"data_ylbxgr_2": (ylbxjs_2 * ylbxblgr_1) + ((dwcs === "天津" && (month === "01" || month === "04" || month === "07" || month === "11")) ? tjdeyladata : tjgrylbdatb),
"data_grsbgjjhj": (ylbxjs_1 * ylbxblgr) + (zfgjjjs_1 * gjjbl) + ((ylbxjs_2 * ylbxblgr_1) + ((dwcs === "天津" && (month === "01" || month === "04" || month === "07" || month === "11")) ? tjdeyladata : tjgrylbdatb)) + (grid[0].data.shebao * sybxblgr),
"data_dwjchj": (grid[0].data.shebao * gsbxbldw) + (grid[0].data.shebao * sybxbldw_1) + (grid[0].data.shebao * ylbxbldw) + (grid[0].data.shebao * ylbxbldw_1) + (grid[0].data.shebao * sybxbldw) + (zfgjjjs_1 * gjjbl),
"data_wxyjdw": (grid[0].data.shebao * gsbxbldw) + (grid[0].data.shebao * sybxbldw_1) + (grid[0].data.shebao * ylbxbldw) + (grid[0].data.shebao * ylbxbldw_1) + (grid[0].data.shebao * sybxbldw)+ (zfgjjjs_1 * gjjbl)
};
data_all.push(data_one);
// 如果已经处理了所有员工数据，执行插入操作
if (data_all.length === data1.grid.length) {
insertData(data_all, year, month);
}
}
});
}
});
}
});
// 批量插入数据函数
function insertData(data_all, year, month) {
data_all.forEach(function(data_one) {
self.view.lookup({
"view": "工资管理列表-自动生成",
"application": "薪酬管理",
"filter": [
{
"logic": "and",
"path": "xm",
"comparison": "==",
"value": data_one.data_xm,
"formatType": "textValue"
},
{
"logic": "and",
"path": "ssdw",
"comparison": "==",
"value": data_one.data_ssdw,
"formatType": "textValue"
},
{
"logic": "and",
"path": "nd",
"comparison": "==",
"value": year,
"formatType": "textValue"
},
{
"logic": "and",
"path": "yf",
"comparison": "==",
"value": month,
"formatType": "textValue"
}
]
}, function(existingData) {
if (existingData && existingData.grid.length > 0) {
console.log("已有相同的记录，不执行插入操作。");
} else {
// 执行插入
var dataAll = {
"identity": "",
"wf_jobId": "",
"wf_workId": "",
"wf_formId": "",
"wf_attachmentIds": [""],
"cms_attachmentIds": [""],
"docData": data_one,
//"readerList": [{ }],
//"authorList": [{ }],
"skipPermission": "",
"summary": "",
"title": "",
"objectSecurityClearance": "",
"documentType": "数据",
"docStatus": "",
"categoryId": "d4ae8b3e-bdef-4cb6-b6d4-c8c222bf454a",
"publishTime": "",
"isTop": "",
"documentNotify": {},
"stringValue01": "",
"stringValue02": "",
"stringValue03": ""
};
var action = self.Actions.load("x_cms_assemble_control");
action.DocumentAction.persist_publishContentMockPutToPost(
dataAll,
function(json) {
data = json.data; //为变量data赋值
//console.log("成功", dataAll);
}.bind(self),
function(json) {
data = json.data; //为变量data赋值
//console.log("错误", dataAll);
}.bind(self)
);
}
});
});
}
我这个代码为什么生成不了新文档，写在点击事件里面了
|
|
[信息未更新]
