12 |
- "use strict";(self["webpackChunkscproject"]=self["webpackChunkscproject"]||[]).push([[79],{69501:function(e,l,t){t.r(l),t.d(l,{default:function(){return o}});t(57658);var a=function(){var e=this,l=e._self._c;return l("div",[l("div",{staticClass:"vfpHeader"},[l("div",{staticClass:"titleOne"},[e._v("活动资金详细")]),l("el-button",{attrs:{type:"primary",size:"mini"},on:{click:function(l){return e.$router.push("/makerfund")}}},[e._v("返回")])],1),l("hr"),l("div",{staticClass:"Apply1"},[l("div",{staticClass:"inpInterval"},[e._v("项目名称")]),l("el-select",{staticStyle:{width:"30%"},attrs:{disabled:"",placeholder:"请选择"},model:{value:e.projectName,callback:function(l){e.projectName=l},expression:"projectName"}},e._l(e.projectFilter,(function(e){return l("el-option",{key:e.id,attrs:{label:e.title,value:e.id}})})),1)],1),e._m(0),l("hr"),l("table",{staticClass:"table",attrs:{border:"1",cellspacing:"0"}},[e._m(1),e._l(e.fundList,(function(t,a){return l("tr",{key:a},[l("td",{attrs:{colspan:"2"}},[e._v(e._s(t.fundName))]),l("td",[e._v(" "+e._s(t.budget)+" ")]),l("td",[e._v(" "+e._s(t.havePaid)+" ")]),l("td",[e._v(" "+e._s(t.thisApply)+" ")]),e.state?e._e():l("td",{staticStyle:{"background-color":"rgb(234, 252, 186)"}},[l("el-input",{staticStyle:{width:"100%"},attrs:{type:"number",autosize:"",resize:"none",onkeypress:"return (/[\\d]/.test(String.fromCharCode(event.keyCode)))",placeholder:"请输入金额"},model:{value:t.actualuse,callback:function(l){e.$set(t,"actualuse",l)},expression:"item.actualuse"}})],1),e.state>0?l("td",[e._v(" "+e._s(t.actualuse)+" ")]):e._e(),l("td",[e._v(" "+e._s(e.state>0?t.budget-t.havePaid:t.budget-t.havePaid-t.actualuse)+" ")]),l("td",{staticStyle:{"box-sizing":"border-box",padding:"0 10px"},attrs:{colspan:"3"}},[e._v(" "+e._s(t.remark)+" ")])])})),l("tr",[l("td",[e._v("事由")]),l("td",{staticClass:"textLeft",attrs:{colspan:"10"}},[l("el-input",{staticStyle:{width:"100%"},attrs:{type:"textarea",autosize:{minRows:6,maxRows:20},resize:"none",placeholder:""},model:{value:e.intro,callback:function(l){e.intro=l},expression:"intro"}})],1)]),l("tr",e._l(9,(function(e,t){return l("td",{key:t,staticStyle:{border:"none"}})})),0)],2),l("div",{staticClass:"baseBtn"},[l("div",{staticClass:"blockWidth"},[l("el-button",{attrs:{type:"primary"},on:{click:e.download}},[e._v("生成表单")]),e.state?e._e():l("el-button",{attrs:{type:"primary"},on:{click:e.submitData}},[e._v("提交")]),e.state>0?l("el-button",{staticClass:"disa",attrs:{type:"primary"}},[e._v("提交")]):e._e()],1)]),l("el-dialog",{staticClass:"pageSubmitData",attrs:{title:"生成Excel",visible:e.downLoadExcelDig,width:"600px"},on:{"update:visible":function(l){e.downLoadExcelDig=l}}},[l("span",{staticClass:"deleteContent"},[e._v("确定生成Excel?")]),l("span",{staticClass:"dialog-footer",attrs:{slot:"footer"},slot:"footer"},[l("el-button",{staticClass:"AllDialogBtn",attrs:{type:"primary"},on:{click:e.downLoadExcel}},[e._v("确认")]),l("el-button",{staticClass:"AllDialogBtn",on:{click:function(l){e.downLoadExcelDig=!1}}},[e._v("取消")])],1)]),l("el-dialog",{staticClass:"pageSubmitData",attrs:{title:"提交",visible:e.submitDataDig,width:"600px"},on:{"update:visible":function(l){e.submitDataDig=l}}},[l("span",{staticClass:"deleteContent"},[e._v("确定提交?")]),l("span",{staticClass:"dialog-footer",attrs:{slot:"footer"},slot:"footer"},[l("el-button",{staticClass:"AllDialogBtn",attrs:{type:"primary"},on:{click:e.submitAll}},[e._v("确认")]),l("el-button",{staticClass:"AllDialogBtn",on:{click:function(l){e.submitDataDig=!1}}},[e._v("取消")])],1)])],1)},u=[function(){var e=this,l=e._self._c;return l("div",{staticClass:"tabTit"},[l("div",[l("p",[e._v("经费支出类别(单位:元)")])])])},function(){var e=this,l=e._self._c;return l("tr",[l("td",{attrs:{colspan:"2"}},[e._v("经济支出类别")]),l("td",[e._v("预算")]),l("td",[e._v("已支付")]),l("td",[e._v("本次申请")]),l("td",[e._v("实际使用")]),l("td",[e._v("余额")]),l("td",{attrs:{colspan:"3"}},[e._v("备注")])])}],s=(t(16079),t(18716)),i=t(42851),C={components:{BeUpload:s.Z},data(){return{projectFilter:[],projectName:"",downLoadExcelDig:!1,submitDataDig:!1,allFund:"",fundList:[{fundName:"小型仪器设备费",budget:"",havePaid:0,thisApply:"",actualuse:"",remark:"项目开展所需的小型专用仪器设备、工具、配件购置或租赁费用。"},{fundName:"材料费",budget:"",havePaid:0,thisApply:"",actualuse:"",remark:"项目开展需消耗的各种原材料、辅助材料等低值易耗品的采购费用。"},{fundName:"测试化验加工费",budget:"",havePaid:0,thisApply:"",actualuse:"",remark:"项目开展过程中支付给外单位的检验、测试、化验、计算、分析及加工费等费用。"},{fundName:"项目协作费",budget:"",havePaid:0,thisApply:"",actualuse:"",remark:"按合同规定支付给协作单位的费用"},{fundName:"项目成功鉴定费",budget:"",havePaid:0,thisApply:"",actualuse:"",remark:"学术会务费、评审费、鉴定费、成果集制作费等费用。"},{fundName:"参展参赛费",budget:"",havePaid:0,thisApply:"",actualuse:"",remark:"参加创客展会、竞赛等所需的报名费、展位费、布展费、宣传推广费及差旅费等费用。"},{fundName:"创客交流活动费",budget:"",havePaid:0,thisApply:"",actualuse:"",remark:"创客交流活动中支付给校外专家的指导费、咨询费、授课费等费用。"},{fundName:"知识产权事务费",budget:"",havePaid:0,thisApply:"",actualuse:"",remark:"论文版面费、专利及其他知识产权事务等费用。"}],haveFund:"",intro:"",tit:"",ty:"",state:0}},methods:{getData(){let e={uid:this.$store.state.userInfo.userid,fid:this.$route.query["Id"],aid:this.$route.query["aid"]};this.ajax.get(this.$store.state.api+"/selectActivityFundDetail",e).then((e=>{console.log(e.data);let l=e.data[0][0],t=JSON.parse(l["applyfund"]),a=JSON.parse(l["fund"]),u=JSON.parse(l["actualuse"]);this.tit=l.title,this.ty=l.type;let s=e["data"][1].filter((e=>null!=e.actualuse));s&&s.forEach((e=>{let l=JSON.parse(e["actualuse"]);this.fundList[0]["havePaid"]+=Number(l["device"]),this.fundList[1]["havePaid"]+=Number(l["Material"]),this.fundList[2]["havePaid"]+=Number(l["processing"]),this.fundList[3]["havePaid"]+=Number(l["Collaboration"]),this.fundList[4]["havePaid"]+=Number(l["APPRAISAL"]),this.fundList[5]["havePaid"]+=Number(l["entery"]),this.fundList[6]["havePaid"]+=Number(l["activities"]),this.fundList[7]["havePaid"]+=Number(l["Transaction"])})),this.fundList[0].budget=a.device,this.fundList[1].budget=a.Material,this.fundList[2].budget=a.processing,this.fundList[3].budget=a.Collaboration,this.fundList[4].budget=a.APPRAISAL,this.fundList[5].budget=a.entery,this.fundList[6].budget=a.activities,this.fundList[7].budget=a.Transaction,this.fundList[0].thisApply=t.device,this.fundList[1].thisApply=t.Material,this.fundList[2].thisApply=t.processing,this.fundList[3].thisApply=t.Collaboration,this.fundList[4].thisApply=t.APPRAISAL,this.fundList[5].thisApply=t.entery,this.fundList[6].thisApply=t.activities,this.fundList[7].thisApply=t.Transaction,null!=l["actualuse"]&&(this.fundList[0].actualuse=u.device,this.fundList[1].actualuse=u.Material,this.fundList[2].actualuse=u.processing,this.fundList[3].actualuse=u.Collaboration,this.fundList[4].actualuse=u.APPRAISAL,this.fundList[5].actualuse=u.entery,this.fundList[6].actualuse=u.activities,this.fundList[7].actualuse=u.Transaction),this.intro=l.intro,this.state=l.state,this.allFund=l.money}),(e=>{console.log(e)}))},download(){if(!this.projectName)return this.$message.error("请选择项目名称");this.downLoadExcelDig=!0},downLoadExcel(){(0,i.G)(this.fundList,this.intro,this.tit,this.ty),this.downLoadExcelDig=!1},submitData(){if(!this.projectName)return this.$message.error("请选择项目名称");let e=[this.fundList[0].actualuse,this.fundList[1].actualuse,this.fundList[2].actualuse,this.fundList[3].actualuse,this.fundList[4].actualuse,this.fundList[5].actualuse,this.fundList[6].actualuse,this.fundList[7].actualuse],l=[this.fundList[0].havePaid,this.fundList[1].havePaid,this.fundList[2].havePaid,this.fundList[3].havePaid,this.fundList[4].havePaid,this.fundList[5].havePaid,this.fundList[6].havePaid,this.fundList[7].havePaid],t=e.reduce(((e,l,t,a)=>e+1*l),0),a=l.reduce(((e,l,t,a)=>e+1*l),0);return 0==t?this.$message.error("请输入实际使用金额"):t+a>this.allFund?this.$message.error("申请金额已大于预算"):void(this.submitDataDig=!0)},submitAll(){let e={uid:this.$store.state.userInfo.userid,fid:this.$route.query["Id"],intro:this.intro,f:JSON.stringify({device:this.fundList[0].actualuse,Material:this.fundList[1].actualuse,processing:this.fundList[2].actualuse,Collaboration:this.fundList[3].actualuse,APPRAISAL:this.fundList[4].actualuse,entery:this.fundList[5].actualuse,activities:this.fundList[6].actualuse,Transaction:this.fundList[7].actualuse})};this.ajax.post(this.$store.state.api+"/updateActivityFundDetail",e).then((e=>{console.log(e),1==e.data?(this.$message.success("提交成功"),this.submitDataDig=!1,this.$router.push("/makerfund")):this.$message.error("提交失败")}),(e=>{console.log(e)}))}},mounted(){this.getData(),this.projectName=this.$route.query["tit"]}},r=C,g=t(1001),n=(0,g.Z)(r,a,u,!1,null,"a231cb0e",null),o=n.exports},42851:function(e,l,t){t.d(l,{A:function(){return g},G:function(){return n}});t(99611);var a=t(24973),u=t.n(a),s=t(66154),i=t.n(s),C=t(750),r=t.n(C);t(41401);function g(e,l,t,a){r().getBinaryContent("file/学校创客专项资金使用申请表 (1).xlsx",((s,C)=>{if(s)return void console.error(s);const r=new(u().Workbook);r.xlsx.load(C).then((()=>{let u=r.getWorksheet(1);return u.getCell("G2").value=`项目类型: 个人创客 ${1==a?"√":"□"} 创客活动 ${0==a?"√":"□"} `,u.getCell("G3").value=`项目名称:${t}`,u.getCell("C7").value=e[0].budget,u.getCell("D7").value=e[0].havePaid,u.getCell("E7").value=e[0].thisApply,u.getCell("G7").value=e[0].remark,u.getCell("C8").value=e[1].budget,u.getCell("D8").value=e[1].havePaid,u.getCell("E8").value=e[1].thisApply,u.getCell("G8").value=e[1].remark,u.getCell("C9").value=e[2].budget,u.getCell("D9").value=e[2].havePaid,u.getCell("E9").value=e[2].thisApply,u.getCell("G9").value=e[2].remark,u.getCell("C10").value=e[3].budget,u.getCell("D10").value=e[3].havePaid,u.getCell("E10").value=e[3].thisApply,u.getCell("G10").value=e[3].remark,u.getCell("C13").value=e[4].budget,u.getCell("D13").value=e[4].havePaid,u.getCell("E13").value=e[4].thisApply,u.getCell("G13").value=e[4].remark,u.getCell("C14").value=e[5].budget,u.getCell("D14").value=e[5].havePaid,u.getCell("E14").value=e[5].thisApply,u.getCell("G14").value=e[5].remark,u.getCell("C15").value=e[6].budget,u.getCell("D15").value=e[6].havePaid,u.getCell("E15").value=e[6].thisApply,u.getCell("G15").value=e[6].remark,u.getCell("C16").value=e[7].budget,u.getCell("D16").value=e[7].havePaid,u.getCell("E16").value=e[7].thisApply,u.getCell("G16").value=e[7].remark,u.getCell("B18").value=l,u.getCell("B18").alignment={vertical:"top",horizontal:"left"},u.getCell("F7").value={formula:"C7-D7-E7",result:u.getCell("C7")-u.getCell("D7")-u.getCell("E7")},u.getCell("F8").value={formula:"C8-D8-E8",result:u.getCell("C8")-u.getCell("D8")-u.getCell("E8")},u.getCell("F9").value={formula:"C9-D9-E9",result:u.getCell("C9")-u.getCell("D9")-u.getCell("E9")},u.getCell("F10").value={formula:"C10-D10-E10",result:u.getCell("C10")-u.getCell("D10")-u.getCell("E10")},u.getCell("F11").value={formula:"C11-D11-E11",result:u.getCell("C11")-u.getCell("D11")-u.getCell("E11")},u.getCell("C6").value={formula:"SUM(C7:C11)",result:1*u.getCell("C7")+1*u.getCell("C8")+1*u.getCell("C9")+1*u.getCell("C10")+1*u.getCell("C11")},u.getCell("D6").value={formula:"SUM(D7:D11)",result:1*u.getCell("D7")+1*u.getCell("D8")+1*u.getCell("D9")+1*u.getCell("D10")+1*u.getCell("D11")},u.getCell("E6").value={formula:"SUM(E7:E11)",result:1*u.getCell("E7")+1*u.getCell("E8")+1*u.getCell("E9")+1*u.getCell("E10")+1*u.getCell("E11")},u.getCell("F6").value={formula:"C6-D6-E6",result:1*u.getCell("C6")-1*u.getCell("D6")-1*u.getCell("E6")},u.getCell("F13").value={formula:"C13-D13-E13",result:u.getCell("C13")-u.getCell("D13")-u.getCell("E13")},u.getCell("F14").value={formula:"C14-D14-E14",result:u.getCell("C14")-u.getCell("D14")-u.getCell("E14")},u.getCell("F15").value={formula:"C15-D15-E15",result:u.getCell("C15")-u.getCell("D15")-u.getCell("E15")},u.getCell("F16").value={formula:"C16-D16-E16",result:u.getCell("C16")-u.getCell("D16")-u.getCell("E16")},u.getCell("F17").value={formula:"C17-D17-E17",result:u.getCell("C17")-u.getCell("D17")-u.getCell("E17")},u.getCell("C12").value={formula:"SUM(C13:C17)",result:1*u.getCell("C13")+1*u.getCell("C14")+1*u.getCell("C15")+1*u.getCell("C16")+1*u.getCell("C17")},u.getCell("D12").value={formula:"SUM(D13:D17)",result:1*u.getCell("D13")+1*u.getCell("D14")+1*u.getCell("D15")+1*u.getCell("D16")+1*u.getCell("D17")},u.getCell("E12").value={formula:"SUM(E13:E17)",result:1*u.getCell("E13")+1*u.getCell("E14")+1*u.getCell("E15")+1*u.getCell("E16")+1*u.getCell("E17")},u.getCell("F12").value={formula:"C12-D12-E12",result:1*u.getCell("C12")-1*u.getCell("D12")-1*u.getCell("E12")},u.getCell("C5").value={formula:"SUM(C6+C12)",result:1*u.getCell("C6")+1*u.getCell("C12")},u.getCell("D5").value={formula:"SUM(D6+D12)",result:1*u.getCell("D6")+1*u.getCell("D12")},u.getCell("E5").value={formula:"SUM(E6+E12)",result:1*u.getCell("E6")+1*u.getCell("E12")},u.getCell("F5").value={formula:"SUM(F6+F12)",result:1*u.getCell("F6")+1*u.getCell("F12")},r.xlsx.writeBuffer()})).then((e=>{const l=new Blob([e],{type:"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});i().saveAs(l,"学校创客专项资金使用申请表.xlsx")}))}))}function n(e,l,t,a){r().getBinaryContent("file/附件 5 :学校创客专项资金使用申请表.xlsx",((s,C)=>{if(s)return void console.error(s);const r=new(u().Workbook);r.xlsx.load(C).then((()=>{let u=r.getWorksheet(1);return u.getCell("G2").value=`项目类型: 个人创客 ${1==a?"√":"□"} 创客活动 ${0==a?"√":"□"} `,u.getCell("G3").value=`项目名称:${t}`,u.getCell("C7").value=e[0].budget,u.getCell("D7").value=e[0].havePaid,u.getCell("E7").value=e[0].thisApply,u.getCell("F7").value=e[0].actualuse,u.getCell("H7").value=e[0].remark,u.getCell("C8").value=e[1].budget,u.getCell("D8").value=e[1].havePaid,u.getCell("E8").value=e[1].thisApply,u.getCell("F8").value=e[1].actualuse,u.getCell("H8").value=e[1].remark,u.getCell("C9").value=e[2].budget,u.getCell("D9").value=e[2].havePaid,u.getCell("E9").value=e[2].thisApply,u.getCell("F9").value=e[2].actualuse,u.getCell("H9").value=e[2].remark,u.getCell("C10").value=e[3].budget,u.getCell("D10").value=e[3].havePaid,u.getCell("E10").value=e[3].thisApply,u.getCell("F10").value=e[3].actualuse,u.getCell("H10").value=e[3].remark,u.getCell("C13").value=e[4].budget,u.getCell("D13").value=e[4].havePaid,u.getCell("E13").value=e[4].thisApply,u.getCell("F13").value=e[4].actualuse,u.getCell("H13").value=e[4].remark,u.getCell("C14").value=e[5].budget,u.getCell("D14").value=e[5].havePaid,u.getCell("E14").value=e[5].thisApply,u.getCell("F14").value=e[5].actualuse,u.getCell("H14").value=e[5].remark,u.getCell("C15").value=e[6].budget,u.getCell("D15").value=e[6].havePaid,u.getCell("E15").value=e[6].thisApply,u.getCell("F15").value=e[6].actualuse,u.getCell("H15").value=e[6].remark,u.getCell("C16").value=e[7].budget,u.getCell("D16").value=e[7].havePaid,u.getCell("E16").value=e[7].thisApply,u.getCell("F16").value=e[7].actualuse,u.getCell("H16").value=e[7].remark,u.getCell("B18").value=l,u.getCell("B18").alignment={vertical:"top",horizontal:"left"},u.getCell("G7").value={formula:"C7-D7-F7",result:u.getCell("C7")-u.getCell("D7")-u.getCell("F7")},u.getCell("G8").value={formula:"C8-D8-F8",result:u.getCell("C8")-u.getCell("D8")-u.getCell("F8")},u.getCell("G9").value={formula:"C9-D9-F9",result:u.getCell("C9")-u.getCell("D9")-u.getCell("F9")},u.getCell("G10").value={formula:"C10-D10-F10",result:u.getCell("C10")-u.getCell("D10")-u.getCell("F10")},u.getCell("G11").value={formula:"C11-D11-F11",result:u.getCell("C11")-u.getCell("D11")-u.getCell("F11")},u.getCell("C6").value={formula:"SUM(C7:C11)",result:1*u.getCell("C7")+1*u.getCell("C8")+1*u.getCell("C9")+1*u.getCell("C10")+1*u.getCell("C11")},u.getCell("D6").value={formula:"SUM(D7:D11)",result:1*u.getCell("D7")+1*u.getCell("D8")+1*u.getCell("D9")+1*u.getCell("D10")+1*u.getCell("D11")},u.getCell("E6").value={formula:"SUM(E7:E11)",result:1*u.getCell("E7")+1*u.getCell("E8")+1*u.getCell("E9")+1*u.getCell("E10")+1*u.getCell("E11")},u.getCell("F6").value={formula:"SUM(F7:F11)",result:1*u.getCell("F7")+1*u.getCell("F8")+1*u.getCell("F9")+1*u.getCell("F10")+1*u.getCell("F11")},u.getCell("G6").value={formula:"C6-D6-F6",result:1*u.getCell("C6")-1*u.getCell("D6")-1*u.getCell("F6")},u.getCell("G13").value={formula:"C13-D13-F13",result:u.getCell("C13")-u.getCell("D13")-u.getCell("F13")},u.getCell("G14").value={formula:"C14-D14-F14",result:u.getCell("C14")-u.getCell("D14")-u.getCell("F14")},u.getCell("G15").value={formula:"C15-D15-F15",result:u.getCell("C15")-u.getCell("D15")-u.getCell("F15")},u.getCell("G16").value={formula:"C16-D16-F16",result:u.getCell("C16")-u.getCell("D16")-u.getCell("F16")},u.getCell("G17").value={formula:"C17-D17-F17",result:u.getCell("C17")-u.getCell("D17")-u.getCell("F17")},u.getCell("C12").value={formula:"SUM(C13:C17)",result:1*u.getCell("C13")+1*u.getCell("C14")+1*u.getCell("C15")+1*u.getCell("C16")+1*u.getCell("C17")},u.getCell("D12").value={formula:"SUM(D13:D17)",result:1*u.getCell("D13")+1*u.getCell("D14")+1*u.getCell("D15")+1*u.getCell("D16")+1*u.getCell("D17")},u.getCell("E12").value={formula:"SUM(E13:E17)",result:1*u.getCell("E13")+1*u.getCell("E14")+1*u.getCell("E15")+1*u.getCell("E16")+1*u.getCell("E17")},u.getCell("F12").value={formula:"SUM(F13:F17)",result:1*u.getCell("F13")+1*u.getCell("F14")+1*u.getCell("F15")+1*u.getCell("F16")+1*u.getCell("F17")},u.getCell("G12").value={formula:"C12-D12-F12",result:1*u.getCell("C12")-1*u.getCell("D12")-1*u.getCell("F12")},u.getCell("C5").value={formula:"SUM(C6+C12)",result:1*u.getCell("C6")+1*u.getCell("C12")},u.getCell("D5").value={formula:"SUM(D6+D12)",result:1*u.getCell("D6")+1*u.getCell("D12")},u.getCell("E5").value={formula:"SUM(E6+E12)",result:1*u.getCell("E6")+1*u.getCell("E12")},u.getCell("F5").value={formula:"SUM(F6+F12)",result:1*u.getCell("F6")+1*u.getCell("F12")},u.getCell("G5").value={formula:"SUM(G6+G12)",result:1*u.getCell("G6")+1*u.getCell("G12")},r.xlsx.writeBuffer()})).then((e=>{const l=new Blob([e],{type:"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});i().saveAs(l,"学校创客专项资金使用申请表.xlsx")}))}))}},16079:function(e,l,t){t.d(l,{Z:function(){return i}});var a=t(36890),u=t(26125);const s={XM:"/getProjectNo",HD:"/getActivityNo",ZJ:"/getFundNo"};function i(e="XM"){return new Promise(((l,t)=>{a.Z.get(u.Z.state.api+s[e],{uid:u.Z.state.userInfo.userid}).then((t=>{if(console.log(t["data"]),0==t["data"][0].length||null==t["data"][0][0]["No"])return l(`${e}0000001`);let a=t["data"][0][0]["No"],u=parseInt(a.slice(-7)),s=u+1,i=`${e}${s.toString().padStart(7,"0")}`;l(i)}))}))}}}]);
- //# sourceMappingURL=79.4196ac00.js.map
|