year-statistcs-list.html 13 KB

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