salaryDetailTb __CnQrLlU8uAMu6VJnXVM __CnQrLlU8uAMu6VJnXVM 16 2048 1536 rollback 1621751505395 salaryDetailTb 0 512 272 142 34 salaryDetailTb 1621751510371 姓名 0 246 32 142 34 Uname false (function(){//此脚本用于更新 导入数据用户选择框的隐藏控制 var doc=getCurrentDocument(); var docid=doc.getId(); println(@quot;进来了4@quot;+docid) //进行更新操作 将people_status状态变为2 然后 第二次进入时就会return 发放工资完毕，请勿重复提交 var sql4=@quot;update tlk_salarydetailtb set ITEM_HIDE='2' where ID='@quot;+docid+@quot;' @quot;; updateByDSName(@quot;salary@quot;,sql4) println(@quot;结束了4@quot;+docid) })() 1621751505395 1621751505395 false false 50;50;50;50 1621751521451 1621751505395 1621751510371 false false 246;189;68;62 1621751525738 1621751510371 1621751505395 false false 68;62;246;189 1621751530090 1621752379676 手机号码 0 408 29 142 34 Utelnumber false #include @quot;sysfunction@quot;; //根据手机号码去后台企业域查询，有则带出用户数据，isFromDomain等于是，如果不存在，则为否 (function(){ var LOGINNO = getItemValueAsString(@quot;Utelnumber@quot;); var domainid = getDomainid(); println(@quot;LOGINNO1---------------------------------@gt;@quot;+LOGINNO) if(isNotNull(LOGINNO)){ println(@quot;LOGINNO2---------------------------------@gt;@quot;+LOGINNO) var doc = getCurrentDocument(); var sql = @quot;select id,@quot;+ @quot;'@quot;+getDomainid()+@quot;' as DOMAINID,@quot;+ @quot;ID as item_ID@quot;+ @quot; from @quot; +sysfunction.DS_OBPM+@quot;.t_user@quot;+ @quot; where LOGINNO='@quot;+LOGINNO+@quot;' and domainid='@quot;+getDomainid()+@quot;'@quot;; println(@quot;sql---------------------------------@gt;@quot;+sql) var datart = queryByDSName(@quot;obpm2@quot;,sql); println(@quot;datat---------------------------------@gt;@quot;+datart) if(datart != null){ for(var iterator = datart.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 var item_ID= map1.get(@quot;id@quot;); } println(@quot;item_ID---------------------------------@gt;@quot;+item_ID) doc.findItem(@quot;UId@quot;).setValue(item_ID); } } })() (function(){ var LOGINNO = getItemValueAsString(@quot;Utelnumber@quot;); //手机号 var Uname =getItemValueAsString(@quot;Uname@quot;);//姓名 var Upapernumber =getItemValueAsString(@quot;Upapernumber@quot;);//身份证 println(@quot;Uname---------------------------------@gt;@quot;+Uname) println(@quot;Upapernumber---------------------------------@gt;@quot;+Upapernumber) var domainid = getDomainid(); println(@quot;LOGINNO1---------------------------------@gt;@quot;+LOGINNO) if(isNotNull(LOGINNO)){ println(@quot;LOGINNO2---------------------------------@gt;@quot;+LOGINNO) var doc = getCurrentDocument(); var sql = @quot;select id,@quot;+ @quot;'@quot;+getDomainid()+@quot;' as DOMAINID,@quot;+ @quot;ID as item_ID@quot;+ @quot; from @quot; +sysfunction.DS_OBPM+@quot;.t_user@quot;+ @quot; where LOGINNO='@quot;+LOGINNO+@quot;' and domainid='@quot;+getDomainid()+@quot;' and name='@quot;+Uname+@quot;' and FIELD12='@quot;+Upapernumber+@quot;' @quot;; println(@quot;sql---------------------------------@gt;@quot;+sql) var datart = queryByDSName(@quot;obpm2@quot;,sql); println(@quot;datat---------------------------------@gt;@quot;+datart) if(datart==@quot;[]@quot;){//在同一个组织域手机号相等如果为null的话，就校验失败 return @quot;@quot;+Uname+@quot;在本公司不存在，导入失败@quot; } } })() 1621752399882 部门 0 1169 133 142 34 Udepartment false 1621751505395 1621752379676 false false 504;179;473;84 1621752436786 1621751505395 1621752399882 false false 960;220;473;84 1621754691002 1621754695106 证件类型 0 695 28 142 34 Upapertype false 1621751505395 1621754695106 false false 814;179;473;84 1621754719954 1621754723586 证件号码 0 874 48 142 34 Upapernumber false 1621751505395 1621754723586 false false 808;83;473;84 1621754733738 1621773468828 基本工资 0 16 116 142 34 jbWages false 1621773495178 岗位津贴 0 117 117 142 34 gwSubsidy false 1621773613323 绩效工资 0 227 119 142 34 jxWages false 1621773613922 提成工资 0 328 112 142 34 tcWages false 1621751505395 1621773468828 false false 82;275;473;84 1621773627018 1621751505395 1621773495178 false false 194;277;473;84 1621773630898 1621773830474 交通补贴 0 22 175 142 34 jtSubsidy false 1621773832346 餐饮补贴 0 117 179 142 34 cySubsidy false 1621751505395 1621773613323 false false 307;278;473;84 1621773838282 1621751505395 1621773613922 false false 422;282;473;84 1621773840874 1621751505395 1621773830474 false false 532;280;473;84 1621773863938 1621751505395 1621773832346 false false 639;284;473;84 1621773898810 1621773925714 通讯补贴 0 209 178 142 34 txSubsidy false 1621773929177 加班补贴 0 298 179 142 34 jbSubsidy false 1621751505395 1621773925714 false false 782;280;473;84 1621773944802 1621773990411 其他补贴 0 8 233 142 34 qtSubsidy false 1621751505395 1621773990411 false false 79;327;473;84 1621774023235 1621774032290 离职补贴 0 112 213 142 34 lzSubsidy false 1621751505395 1621774032290 false false 205;332;473;84 1621774054314 1621774058554 年终奖 0 203 220 142 34 yearendBonus false 1621774059010 其他增项 0 287 221 142 34 qtSalary false 1621751505395 1621774058554 false false 320;327;473;84 1621774083018 1621774095082 增项合计 0 114 275 142 34 zxTotal false 1621751505395 1621774059010 false false 417;330;473;84 1621774122802 1621751505395 1621774095082 false false 514;328;473;84 1621774155041 1621774395243 事假扣款 0 783 31 142 34 sjCutpay false 1621751505395 1621774395243 false false 77;374;473;84 1621774463259 1621751505395 1621773929177 false false 882;280;468;105 1621774524483 1621774761954 补卡扣款 0 1083 39 142 34 bkCutpay false 1621751505395 1621774761954 false false 300;381;470;125 1621774782106 1621774787226 缺勤扣款 0 1155 79 142 34 qqCutpay false 1621751505395 1621774787226 false false 400;385;469;213 1621774832794 1621774850578 代扣养老保险 0 966 43 142 34 ylInsurance false 1621751505395 1621774850578 false false 496;383;469;213 1621774865921 1621774958970 代扣医疗保险 0 1046 207 142 34 yilInsurance false 1621751505395 1621774958970 false false 609;382;469;213 1621774975507 1621774978410 代扣失业保险 0 1045 261 142 34 syInsurance false 1621751505395 1621774978410 false false 711;385;469;213 1621775001394 1621775011093 代扣工伤保险 0 876 421 142 34 gsInsurance false 1621751505395 1621775011093 false false 920;380;469;213 1621775023442 1621775037610 代扣生育保险 0 756 414 142 34 SyuInsurance false 1621751505395 1621775037610 false false 913;383;469;213 1621775050610 1621775062682 代扣公积金 0 987 423 142 34 fund false 1621751505395 1621775062682 false false 1008;384;469;213 1621775075921 1621775088107 代扣补充医疗 0 1045 308 142 34 bcYiliao false 1621751505395 1621775088107 false false 956;285;469;213 1621775102418 1621775114573 其他减项 0 1041 368 142 34 qtCutpay false 1621751505395 1621775114573 false false 795;439;469;213 1621775140019 1621775143842 减项合计 0 900 621 142 34 jxTotal false 1621751505395 1621775143842 false false 956;332;469;213 1621775164987 1621775352570 税前工资 0 49 355 142 34 sqWages false 1621775352866 累计应缴个税 0 147 353 142 34 yingjPtax false 1621775353185 个税抵扣 0 255 351 142 34 gsDk false 1621775353473 个税附加抵扣 0 43 524 142 34 gsFjDk false 1621775353777 累计已缴个税 0 186 550 142 34 yijPtax false 1621775354034 本期个税 0 315 557 142 34 bqPtax false 1621775354307 应发工资 0 476 587 142 34 yfWages false 1621775354570 实发工资 0 623 580 142 34 sfWages false 1621775354818 未发工资 0 734 618 142 34 wfWages false 1621751505395 1621775352570 false false 31;342;439;193 1621775372339 1621751505395 1621775352866 false false 131;343;456;187 1621775437621 1621751505395 1621775353185 false false 226;351;456;187 1621775492586 1621751505395 1621775353473 false false 24;415;456;187 1621775497537 1621751505395 1621775353777 false false 146;416;456;187 1621775510401 1621751505395 1621775354034 false false 261;416;456;187 1621775514522 1621751505395 1621775354307 false false 447;336;456;187 1621775595018 1621751505395 1621775354570 false false 540;337;456;187 1621775596962 1621751505395 1621775354818 false false 633;338;456;187 1621775599283 1634710339797 确认状态 0 134 36 142 34 Ustatus false (function(){ return @quot;待确认@quot;; })() 1634710339797 1621751505395 false false 512;272;99;42 1634715409560 1634716862765 控制 0 509 31 142 34 hide false (function(){//此脚本用于更新 导入数据用户选择框的隐藏控制 return @quot;2@quot; })() 1621751505395 1634716862765 false false 534;28;512;272 1634716919356 1634718312753 UID 0 601 31 142 34 UId false (function(){ var rtn = getItemValue(@quot;UId@quot;); println(@quot;ssssssssssssssss@quot;+rtn) return rtn; })() 1634718312753 1621751505395 false false 512;272;23;42 1634718432562 1634798021686 病假扣款 0 1039 98 142 34 bjCutpay false 1634798021686 1621751505395 false false 512;272;1039;98 1634800786656 ]]> /uploads/exceltemplate/员工工资模板.xlsx