month-statistcs-list.html 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>日统计表-列表</title>
  5. <meta charset="utf-8">
  6. <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no" />
  7. <!-- 所有的 css & js 资源 -->
  8. <link rel="stylesheet" href="../../static/kj/element-ui/theme-chalk/index.css">
  9. <link rel="stylesheet" href="../../static/sa.css">
  10. <script src="../../static/kj/vue.min.js"></script>
  11. <script src="../../static/kj/element-ui/index.js"></script>
  12. <script src="../../static/kj/httpVueLoader.js"></script>
  13. <script src="../../static/kj/jquery.min.js"></script>
  14. <script src="../../static/kj/layer/layer.js"></script>
  15. <script src="../../static/sa.js"></script>
  16. </head>
  17. <body>
  18. <div class="vue-box" style="display: none;" :style="'display: block;'">
  19. <div class="c-panel">
  20. <!-- ------------- 检索参数 ------------- -->
  21. <div class="c-title">检索参数</div>
  22. <el-form ref="form" :model='p' @submit.native.prevent>
  23. <div class="c-item">
  24. <label class="c-label">收费项目:</label>
  25. <el-select v-model="p.feeType" placeholder="请选择" filterable>
  26. <el-option label="-全部-" value=""></el-option>
  27. <el-option label="核酸检测" value="1"></el-option>
  28. <el-option label="消杀作业" value="2"></el-option>
  29. <el-option label="装卸作业" value="3"></el-option>
  30. <el-option label="停车费" value="4"></el-option>
  31. <el-option label="过磅费" value="5"></el-option>
  32. <el-option label="入场管理费" value="6"> </el-option>
  33. <el-option label="充电打冷作业" value="7"> </el-option>
  34. </el-select>
  35. </div>
  36. <!-- <div class="c-item">-->
  37. <!-- <label class="c-label">日期:</label>-->
  38. <!-- <el-date-picker type="month" value-format="yyyy-MM" v-model="p.month"></el-date-picker>-->
  39. <!-- </div>-->
  40. <div class="c-item">
  41. <label class="c-label">日期范围:</label>
  42. <el-date-picker size="mini" v-model="selectMonth" type="monthrange" unlink-panels="false"
  43. range-separator="至" start-placeholder="开始月份" end-placeholder="结束月份"
  44. format="yyyy 年 MM 月" value-format="yyyy-MM">
  45. </el-date-picker>
  46. </div>
  47. <el-button type="primary" icon="el-icon-search" @click="p.pageNo = 1; f5()">查询</el-button>
  48. <br/>
  49. </el-form>
  50. <!-- ------------- 快捷按钮 ------------- -->
  51. <div class="fast-btn">
  52. <el-button size="mini" type="info" @click="sa.f5()">刷新</el-button>
  53. <el-button type="warning" @click="exportFn()">导出(月统计)</el-button>
  54. <el-button class="c-btn" type="success" icon="el-icon" @click="print()">打印(月报表)</el-button>
  55. </div>
  56. <!-- ------------- 数据列表 ------------- -->
  57. <el-table class="data-table" ref="data-table" :data="dataList" show-summary :summary-method="getSumRol">
  58. <sa-td name="收费项目" prop="feeType" type="enum"
  59. :jv="{1: '核酸检测',2: '消杀作业', 3: '装卸作业', 4: '停车费', 5: '过磅费', 6: '入场管理费', 7: '充电打冷作业'}"></sa-td>
  60. <sa-td name="月份" prop="month" ></sa-td>
  61. <sa-td name="数量" prop="num" ></sa-td>
  62. <!-- <sa-td name="含税收入(元)" prop="statisticsMoney"></sa-td>-->
  63. <el-table-column label="含税收入(元)" >
  64. <template slot-scope="s">
  65. <span>{{Number(s.row.taxMoney).toFixed(2)}}</span>
  66. </template>
  67. </el-table-column>
  68. <el-table-column label="税率(%)" >
  69. <template slot-scope="s">
  70. <span>{{s.row.taxRate * 100}}</span>
  71. </template>
  72. </el-table-column>
  73. <!-- <sa-td name="税款(元)" prop="taxes" ></sa-td>-->
  74. <el-table-column label="税款(元)" >
  75. <template slot-scope="s">
  76. <span>{{Number(s.row.taxes).toFixed(2)}}</span>
  77. </template>
  78. </el-table-column>
  79. <!-- <sa-td name="不含税收入(元)" prop="noTaxMoney" ></sa-td>-->
  80. <el-table-column label="不含税收入(元)" >
  81. <template slot-scope="s">
  82. <span>{{Number(s.row.noTaxMoney).toFixed(2)}}</span>
  83. </template>
  84. </el-table-column>
  85. <!-- <el-table-column label="操作" fixed="right" width="240px">-->
  86. <!-- <template slot-scope="s">-->
  87. <!-- <el-button class="c-btn" type="success" icon="el-icon-view" @click="get(s.row)">查看</el-button>-->
  88. <!-- <el-button class="c-btn" type="primary" icon="el-icon-edit" @click="update(s.row)">修改</el-button>-->
  89. <!-- <el-button class="c-btn" type="danger" icon="el-icon-delete" @click="del(s.row)">删除</el-button>-->
  90. <!-- </template>-->
  91. <!-- </el-table-column>-->
  92. </el-table>
  93. <!-- ------------- 分页 ------------- -->
  94. <sa-item type="page" :curr.sync="p.pageNo" :size.sync="p.pageSize" :total="dataCount" @change="f5()"></sa-item>
  95. </div>
  96. <el-dialog title="提示" :visible.sync="emodel.visible" width="38%">
  97. <!-- 日期选择器 -->
  98. <div class="c-item">
  99. <label class="c-label">月份:</label>
  100. <el-date-picker type="month" value-format="yyyy-MM" v-model="emodel.form.exportMonth" placeholder="选择月份" ></el-date-picker>
  101. </div>
  102. <span slot="footer" class="dialog-footer">
  103. <el-button @click="emodel.visible = false">取 消</el-button>
  104. <el-button type="primary" @click="sureExport">确 定</el-button>
  105. </span>
  106. </el-dialog>
  107. </div>
  108. <script>
  109. var app = new Vue({
  110. components: {
  111. "sa-item": httpVueLoader('../../sa-frame/com/sa-item.vue'),
  112. "sa-td": httpVueLoader('../../sa-frame/com/sa-td.vue'),
  113. },
  114. el: '.vue-box',
  115. data: {
  116. p: { // 查询参数
  117. id: '', // 主键
  118. feeType: '', // 收费类型(1=核酸检测,2=消杀作业,3=装卸作业,4=停车费,5=过磅费,6=入场管理费)
  119. itemTypeId: '', // 业务类型id
  120. itemTypeName: '', // 业务类型
  121. year: '', // 年份
  122. month: '', // 月份
  123. day: '', // 天
  124. dayTime: '', // 日期
  125. num: '', // 数量
  126. taxMoney: '', // 税款
  127. taxRate: '', // 税率
  128. noTaxMoney: '', // 不含税款
  129. payType: '', // 支付方式(1=微信支付)
  130. pageNo: 1, // 当前页
  131. pageSize: 10, // 页大小
  132. sortType: 0 // 排序方式
  133. },
  134. dataCount: 0,
  135. dataList: [], // 数据集合
  136. selectMonth:[],
  137. selectMonthRange: {
  138. beginMonth: '', //查询开始时间
  139. endMonth: '', //查询结束时间
  140. },
  141. emodel: {
  142. visible: false,
  143. form: {
  144. exportMonth: '', //导出月份
  145. }
  146. },
  147. tableSum:{
  148. taxMoneySum: 0,
  149. taxesSum: 0,
  150. noTaxMoneySum: 0,
  151. },
  152. },
  153. methods: {
  154. getSumRol(param){
  155. console.log("执行了getSumRol")
  156. const columns = param.columns;
  157. const sums = [];
  158. columns.forEach((column, index) => {
  159. if (index === 0) {
  160. sums[index] = "合计";
  161. return;
  162. }
  163. //根据当前列绑定的字段名进行判断,根据字段名决定展示什么内容
  164. switch (column.label) {
  165. //金额;
  166. case "含税收入(元)":
  167. //在这里你就可以根据需要对数据进行一些处理(保留小数位数,加上单位等)
  168. sums[index] = this.tableSum.taxMoneySum;
  169. break;
  170. //人数
  171. case "税款(元)":
  172. sums[index] = this.tableSum.taxesSum;
  173. break;
  174. //件数;
  175. case "不含税收入(元)":
  176. sums[index] = this.tableSum.noTaxMoneySum;
  177. break;
  178. //不需要计算合计的列就展示‘--’
  179. default:
  180. sums[index] = "";
  181. break;
  182. }
  183. });
  184. return sums;
  185. },
  186. calcuSum(){
  187. var taxMoneySum = 0;
  188. var taxesSum = 0;
  189. var noTaxMoneySum = 0;
  190. var len = this.dataList.length;
  191. for(var i=0; i<len; i++){
  192. taxMoneySum = (taxMoneySum*100 + this.dataList[i].taxMoney*100)/100;
  193. taxesSum = (taxesSum*100 + this.dataList[i].taxes*100)/100;
  194. noTaxMoneySum = (noTaxMoneySum*100 + this.dataList[i].noTaxMoney*100)/100;
  195. }
  196. this.tableSum.taxMoneySum = Number(taxMoneySum).toFixed(2);
  197. this.tableSum.taxesSum = Number(taxesSum).toFixed(2);
  198. this.tableSum.noTaxMoneySum = Number(noTaxMoneySum).toFixed(2);
  199. },
  200. print: function() {
  201. if ( this.selectMonth != null && this.selectMonth.length != 0) {
  202. this.selectMonthRange.beginMonth = this.selectMonth[0];
  203. this.selectMonthRange.endMonth = this.selectMonth[1];
  204. }
  205. var beginMonth = this.selectMonthRange.beginMonth;
  206. var endMonth = this.selectMonthRange.endMonth;
  207. var feeType = this.p.feeType;
  208. var str = '';
  209. if(beginMonth === '' && endMonth === ''){
  210. str += '所有月份';
  211. }else {
  212. str += beginMonth + "至" + endMonth
  213. }
  214. if(feeType === ''){
  215. str += "、所有收费项目";
  216. }else{
  217. var feeTypeName = '';
  218. if(feeType == 1){
  219. feeTypeName = "核酸检测";
  220. }else if(feeType == 2){
  221. feeTypeName = "消杀作业";
  222. }else if(feeType == 3){
  223. feeTypeName = "装卸作业";
  224. }else if(feeType == 4){
  225. feeTypeName = "停车费";
  226. }else if(feeType == 5){
  227. feeTypeName = "过磅费";
  228. }else if(feeType == 6){
  229. feeTypeName = "入场管理费";
  230. }else if(feeType == 7){
  231. feeTypeName = "充电打冷作业";
  232. }
  233. str += "、收费项目为" + feeTypeName;
  234. }
  235. this.$confirm('确定打印'+str+'的数据?', '提示', {
  236. confirmButtonText: '确定',
  237. cancelButtonText: '取消',
  238. type: 'warning'
  239. }).then(() => {
  240. sa.showIframe('打印月报表', 'dayStatsPrint.html?beginMonth='+beginMonth+"&endMonth="+endMonth+"&feeType="+feeType+"&isMonth=1" , '1000px', '100%');
  241. }).catch(() => {
  242. });
  243. },
  244. exportFn() {
  245. Object.assign(this.emodel, {
  246. visible: true,
  247. })
  248. },
  249. sureExport() {
  250. if (this.emodel.form.exportMonth == '') {
  251. sa.msg("请选择月份");
  252. return;
  253. }
  254. sa.ajax('/TbFeeStatistics/export/monthStatistics', this.emodel.form, function(resp) {
  255. window.open(resp.data);
  256. this.emodel.visible = false;
  257. }.bind(this));
  258. },
  259. // 刷新
  260. f5: function() {
  261. if ( this.selectMonth != null && this.selectMonth.length != 0) {
  262. this.selectMonthRange.beginMonth = this.selectMonth[0];
  263. this.selectMonthRange.endMonth = this.selectMonth[1];
  264. }
  265. sa.ajax('/TbFeeStatistics/getMonth?beginMonth='+this.selectMonthRange.beginMonth+"&endMonth="+this.selectMonthRange.endMonth,
  266. sa.removeNull(this.p), function(res) {
  267. this.dataList = res.data; // 数据
  268. this.dataCount = res.dataCount; // 数据总数
  269. sa.f5TableHeight(); // 刷新表格高度
  270. this.calcuSum();
  271. }.bind(this));
  272. },
  273. // 查看
  274. get: function(data) {
  275. sa.showIframe('数据详情', 'month-statistcs-info.html?id=' + data.id, '1050px', '90%');
  276. },
  277. // 查看 - 根据选中的
  278. getBySelect: function(data) {
  279. var selection = this.$refs['data-table'].selection;
  280. if(selection.length == 0) {
  281. return sa.msg('请选择一条数据')
  282. }
  283. this.get(selection[0]);
  284. },
  285. },
  286. created: function() {
  287. this.f5();
  288. sa.onInputEnter();
  289. }
  290. })
  291. </script>
  292. </body>
  293. </html>