query_20190326181924.vue 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479
  1. <template>
  2. <div>
  3. <!-- <TitleBar propTitle="经营数据查询" /> -->
  4. <el-form :model="form" ref="form" class="marginTop">
  5. <el-form-item label="查询类别" :label-width="formLabelWidth">
  6. <el-radio-group
  7. v-model="form.type"
  8. placeholder="请选择类别"
  9. size="medium"
  10. :rules="[{ required: true, message: '必选'}]"
  11. style="width:100%"
  12. >
  13. <el-row :gutter="10">
  14. <el-col :span="4">
  15. <el-radio border style="width:100%;" label="INCOME">收入</el-radio>
  16. </el-col>
  17. <el-col :span="4">
  18. <el-radio border style="width:100%;" label="COST">成本</el-radio>
  19. </el-col>
  20. </el-row>
  21. </el-radio-group>
  22. </el-form-item>
  23. <el-form-item label="时间范围" v-if="form.type!==''" :label-width="formLabelWidth">
  24. <el-row :gutter="10">
  25. <el-col :span="4">
  26. <el-date-picker placeholder="起始时间" style="width:100%" v-model="form.startTime"></el-date-picker>
  27. </el-col>
  28. <el-col :span="4">
  29. <el-date-picker placeholder="结束时间" style="width:100%" v-model="form.endTime"></el-date-picker>
  30. </el-col>
  31. </el-row>
  32. </el-form-item>
  33. <!-- <el-form-item label="金额范围" v-if="form.type!==''" :label-width="formLabelWidth">
  34. <el-row :gutter="10">
  35. <el-col :span="4">
  36. <el-input placeholder="起始金额" style="width:100%" v-model="form.minAmount" clearable></el-input>
  37. </el-col>
  38. <el-col :span="4">
  39. <el-input placeholder="结束金额" style="width:100%" v-model="form.maxAmount" clearable></el-input>
  40. </el-col>
  41. </el-row>
  42. </el-form-item>-->
  43. <el-form-item
  44. label="成本类型"
  45. v-if="form.type==='COST'"
  46. prop="costTypeId"
  47. :label-width="formLabelWidth"
  48. >
  49. <el-select v-model="form.costTypeId" placeholder="请选择支出类型" ref="select">
  50. <el-option key label="全选" value></el-option>
  51. <el-option
  52. v-for="item in costTypeSelectData"
  53. :key="item.id"
  54. :label="item.name"
  55. :value="item.id"
  56. ></el-option>
  57. </el-select>
  58. </el-form-item>
  59. <el-form-item label="收入状态" v-if="form.type==='INCOME'" :label-width="formLabelWidth">
  60. <el-row :gutter="10">
  61. <el-col :span="1">
  62. <el-checkbox
  63. :indeterminate="isIndeterminate"
  64. v-model="checkAll"
  65. @change="handleCheckAllChange"
  66. size="medium"
  67. >全选</el-checkbox>
  68. </el-col>
  69. <el-checkbox-group
  70. style="width:100%"
  71. v-model="form.incomeStatus"
  72. placeholder="请选择状态值"
  73. size="medium"
  74. :indeterminate="isIndeterminate"
  75. >
  76. <el-col :span="4">
  77. <el-checkbox style="width:100%;" border label="INVOICE">开票/应收</el-checkbox>
  78. </el-col>
  79. <el-col :span="4">
  80. <el-checkbox style="width:100%;" border label="ARRIVAL">到账</el-checkbox>
  81. </el-col>
  82. <el-col :span="4">
  83. <el-checkbox style="width:100%;" border label="INTERNAL">内部核算</el-checkbox>
  84. </el-col>
  85. </el-checkbox-group>
  86. </el-row>
  87. </el-form-item>
  88. <el-form-item
  89. label="归属产品"
  90. v-if="form.type==='INCOME'"
  91. prop="productId"
  92. :label-width="formLabelWidth"
  93. >
  94. <el-select v-model="form.productId" placeholder="请选择产品">
  95. <el-option key label="全选" value></el-option>
  96. <el-option
  97. v-for="item in productSelectData"
  98. :key="item.id"
  99. :label="item.code +'--'+ item.name"
  100. :value="item.id"
  101. ></el-option>
  102. </el-select>
  103. </el-form-item>
  104. <el-form-item
  105. label="归属项目"
  106. v-if="form.type!==''"
  107. prop="projectId"
  108. :label-width="formLabelWidth"
  109. >
  110. <el-select v-model="form.projectId" placeholder="请选择项目">
  111. <el-option key label="全选" value></el-option>
  112. <el-option
  113. v-for="item in projectSelectData"
  114. :key="item.id"
  115. :label="item.code +'--'+ item.name"
  116. :value="item.id"
  117. ></el-option>
  118. </el-select>
  119. </el-form-item>
  120. <!-- <el-form-item
  121. label="来源项目"
  122. style="display:inline-block;"
  123. prop="toProjectId"
  124. v-if="form.type!==''"
  125. :label-width="formLabelWidth"
  126. >
  127. <el-select v-model="form.toProjectId" placeholder="请选择项目">
  128. <el-option key label="不选" value></el-option>
  129. <el-option
  130. v-for="item in projectSelectData"
  131. :key="item.id"
  132. :label="item.name"
  133. :value="item.id"
  134. ></el-option>
  135. </el-select>
  136. </el-form-item>
  137. <el-form-item
  138. label="来源部门"
  139. prop="toDeptId"
  140. style="display:inline-block;"
  141. v-if="form.type!==''"
  142. :label-width="formLabelWidth"
  143. >
  144. <el-select v-model="form.toDeptId" placeholder="请选择部门">
  145. <el-option key label="不选" value></el-option>
  146. <el-option
  147. v-for="item in teamSelectData"
  148. :key="item.id"
  149. :label="item.name"
  150. :value="item.id"
  151. ></el-option>
  152. </el-select>
  153. </el-form-item>-->
  154. <el-form-item label="归属部门" prop="deptId" v-if="form.type!==''" :label-width="formLabelWidth">
  155. <el-select v-model="form.deptId" placeholder="请选择部门" ref="select">
  156. <el-option key label="全选" value></el-option>
  157. <el-option
  158. v-for="item in teamSelectData"
  159. :key="item.id"
  160. :label="item.code +'--'+ item.name"
  161. :value="item.id"
  162. ></el-option>
  163. </el-select>
  164. </el-form-item>
  165. <el-form-item
  166. style="position: absolute; width:23%; display:block; margin:0 auto; left: 0; right: 0;"
  167. >
  168. <el-button type="primary" @click="onSubmit">查询</el-button>
  169. <!-- <el-button type="info" @click="onReset">重置</el-button> -->
  170. </el-form-item>
  171. <!-- <el-form-item>
  172. <el-button type="info" @click="reset">重置</el-button>
  173. </el-form-item>-->
  174. </el-form>
  175. <!-- 查询结果收入表 -->
  176. <el-table
  177. :data="searchResult"
  178. style="width: 100%;margin-top:80px;"
  179. show-summary
  180. :summary-method="tableSummart"
  181. v-if="tableType === 'INCOME'"
  182. border
  183. >
  184. <el-table-column
  185. width="120px"
  186. align="right"
  187. label="录入日期"
  188. :formatter="recordTimeFormat"
  189. prop="gmtModife"
  190. ></el-table-column>
  191. <el-table-column
  192. prop="happenTime"
  193. width="120px"
  194. align="right"
  195. :formatter="dateFormat"
  196. label="发生日期"
  197. ></el-table-column>
  198. <el-table-column
  199. :formatter="moneyFormat"
  200. prop="amount"
  201. width="110px"
  202. align="right"
  203. label="金额"
  204. ></el-table-column>
  205. <el-table-column
  206. label="收入状态"
  207. width="130px"
  208. align="right"
  209. prop="incomeStatus"
  210. :formatter="incomeTypeFormat"
  211. >
  212. <!-- <template slot-scope="props">
  213. <span>{{ props.row.incomeStatus == 'INVOICE' ? '开票/应收' : props.row.incomeStatus == 'ARRIVAL' ? '到账' : '内部核算' }}</span>
  214. </template>-->
  215. </el-table-column>
  216. <el-table-column label="产品" width="200px" align="right" prop="product.name"></el-table-column>
  217. <el-table-column label="归属项目" width="290px" align="right" prop="project.name"></el-table-column>
  218. <el-table-column label="归属部门" width="250px" align="right" prop="department.name"></el-table-column>
  219. <!-- <el-table-column label="接收项目" prop="toProject.name"></el-table-column> -->
  220. <el-table-column prop="remark" align="right" label="备注"></el-table-column>
  221. </el-table>
  222. <!-- 查询结果成本表 -->
  223. <el-table
  224. :data="searchResult"
  225. style="width: 100%;margin-top:80px;"
  226. show-summary
  227. v-if="tableType === 'COST'"
  228. border
  229. >
  230. <el-table-column
  231. width="120px"
  232. align="right"
  233. label="录入日期"
  234. :formatter="recordTimeFormat"
  235. prop="gmtModife"
  236. ></el-table-column>
  237. <el-table-column
  238. prop="happenTime"
  239. width="120px"
  240. align="right"
  241. :formatter="dateFormat"
  242. label="发生日期"
  243. ></el-table-column>
  244. <el-table-column
  245. :formatter="moneyFormat"
  246. prop="amount"
  247. width="110px"
  248. align="right"
  249. label="金额"
  250. ></el-table-column>
  251. <el-table-column label="成本类别" width="130px" align="right" prop="costType.name"></el-table-column>
  252. <el-table-column label="发生部门" width="220px" align="right" prop="department.name"></el-table-column>
  253. <el-table-column label="发生项目/人" width="300px" align="right" prop="project.name"></el-table-column>
  254. <!-- <el-table-column label="接收项目" prop="toProject.name"></el-table-column> -->
  255. <!-- <el-table-column label="接收部门" prop="toDepartment.name"></el-table-column> -->
  256. <el-table-column label="备注" align="right" prop="remark"></el-table-column>
  257. </el-table>
  258. <!-- 分页 -->
  259. <el-pagination
  260. background
  261. @current-change="handlePageChange"
  262. :page-size="50"
  263. :current-page.sync="pageNo"
  264. layout="prev, pager, next"
  265. v-if="searchResult.length!==0"
  266. :total="totalNumber"
  267. ></el-pagination>
  268. </div>
  269. </template>
  270. <script>
  271. import {
  272. getTeamSelect,
  273. getProjectSelect,
  274. getProductSelect,
  275. getCostTeamSelect,
  276. getCostTypeSelect,
  277. addManage,
  278. getManageList,
  279. setManage
  280. } from "@/api/manageApi";
  281. import TitleBar from "../layout/titleBar/TitleBar.vue";
  282. import { formatTime } from "../../utils/common";
  283. const statusOptions = ["INVOICE", "ARRIVAL", "INTERNAL"];
  284. export default {
  285. components: {
  286. TitleBar
  287. },
  288. data() {
  289. return {
  290. type: "",
  291. dialogFormVisible: false,
  292. addFlag: false,
  293. id: "",
  294. searchResult: [],
  295. form: {
  296. type: "",
  297. productId: "",
  298. projectId: "",
  299. toDeptId: "",
  300. toProjectId: "",
  301. deptId: "",
  302. incomeStatus: [],
  303. status: "NORMAL",
  304. costTypeId: "",
  305. startTime: null,
  306. endTime: null,
  307. minAmount: "",
  308. maxAmount: "",
  309. isEntry: false,
  310. pageNo: 1,
  311. pageSize: 50
  312. },
  313. pageNo: 1,
  314. pageSize: 50,
  315. totalNumber: 0,
  316. formLabelWidth: "120px",
  317. teamSelectData: [],
  318. projectSelectData: [],
  319. productSelectData: [],
  320. costTeamSelectData: [],
  321. costTypeSelectData: [],
  322. manageData: [],
  323. companyData: [],
  324. tableType: "",
  325. isIndeterminate: true,
  326. checkAll: false
  327. };
  328. },
  329. created() {
  330. // 获取部门下拉框
  331. getTeamSelect().then(res => {
  332. this.teamSelectData = res.data;
  333. });
  334. // 获取项目下拉框
  335. getProjectSelect().then(res => {
  336. this.projectSelectData = res.data;
  337. });
  338. //获取产品下拉框
  339. getProductSelect().then(res => {
  340. this.productSelectData = res.data;
  341. });
  342. //获取经营列表
  343. // getManageList({
  344. // type: "INCOME"
  345. // }).then(res => {
  346. // this.manageData = res.data;
  347. // console.log(res.data);
  348. // });
  349. //获取单位下拉
  350. getCostTeamSelect().then(res => {
  351. this.costTeamSelectData = res.data;
  352. });
  353. //获取成本类型下拉
  354. getCostTypeSelect().then(res => {
  355. this.costTypeSelectData = res.data;
  356. });
  357. },
  358. methods: {
  359. // 自定义合计
  360. tableSummart(object){
  361. console.log(object)
  362. },
  363. // 金额格式化
  364. moneyFormat(row) {
  365. return row.amount.toFixed(2);
  366. },
  367. // 全选
  368. handleCheckAllChange(val) {
  369. console.log(val);
  370. this.form.incomeStatus = val ? statusOptions : [];
  371. this.isIndeterminate = false;
  372. this.checkAll = val;
  373. },
  374. handlePageChange(val) {
  375. this.form.pageNo = val;
  376. this.$post("manageBase/manage/search", this.form).then(response => {
  377. console.log(response);
  378. this.searchResult = response.data.content;
  379. this.totalNumber = parseInt(response.data.totalElements);
  380. this.pageNo = parseInt(response.data.number) + 1;
  381. if (response.data && response.data.content.length == 0) {
  382. this.$message("未找到相应数据");
  383. }
  384. });
  385. },
  386. onSubmit() {
  387. // this.totalNumber = 0;
  388. this.searchResult = [];
  389. if (this.form.type === "INCOME") {
  390. this.form.costTypeId = "";
  391. this.tableType = "INCOME";
  392. }
  393. if (this.form.type === "COST") {
  394. this.form.incomeStatus = "";
  395. this.form.productId = "";
  396. this.tableType = "COST";
  397. }
  398. this.form.pageNo = 1;
  399. this.$post("manageBase/manage/search", this.form).then(response => {
  400. console.log(response);
  401. this.searchResult = response.data.content;
  402. this.totalNumber = parseInt(response.data.totalElements);
  403. this.pageNo = parseInt(response.data.number) + 1;
  404. if (response.data && response.data.content.length == 0) {
  405. this.$message("未找到相应数据");
  406. }
  407. });
  408. },
  409. onReset() {
  410. this.form.type = "";
  411. this.form.costTypeId = "";
  412. this.tableType = "";
  413. this.searchResult = "";
  414. this.$refs.form.resetFields();
  415. },
  416. tableRowClassName({ row, rowIndex }) {
  417. console.log(row.type);
  418. if (row.type === "COST") {
  419. return "cost-row-search";
  420. } else {
  421. return "income-row-search";
  422. }
  423. // return "";
  424. },
  425. //获取部门名称
  426. getName(val) {
  427. let obj = {};
  428. obj = this.teamSelectData.find(item => {
  429. return item.id === val;
  430. });
  431. let getName = "";
  432. this.form.deptName = obj.name;
  433. },
  434. // 添加
  435. append(type) {
  436. this.type = type;
  437. this.dialogFormVisible = true;
  438. this.addFlag = true;
  439. },
  440. // 格式化时间
  441. dateFormat(row, column) {
  442. return formatTime(row.happenTime);
  443. },
  444. recordTimeFormat(row) {
  445. return formatTime(row.gmtModified);
  446. },
  447. incomeTypeFormat(row) {
  448. return row.incomeStatus == "INVOICE"
  449. ? "开票/应收"
  450. : row.incomeStatus == "ARRIVAL"
  451. ? "到账"
  452. : "内部核算";
  453. }
  454. }
  455. };
  456. </script>
  457. <style scope>
  458. .marginTop {
  459. margin-top: 20px;
  460. }
  461. .el-table .cost-row-search {
  462. /* color: green; */
  463. /* background: #f0f9eb; */
  464. color: green;
  465. }
  466. .el-table .income-row-search {
  467. /* color: red; */
  468. /* background: rgba(248, 181, 172, 0.267); */
  469. color: red;
  470. /* color: #f0f9eb; */
  471. }
  472. </style>