tb-fee-statistics-list.html 16 KB

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