query_20190325140252.vue 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418
  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. style="display:inline-block;"
  48. :label-width="formLabelWidth"
  49. >
  50. <el-select v-model="form.costTypeId" placeholder="请选择支出类型" ref="select">
  51. <el-option key label="不选" value></el-option>
  52. <el-option
  53. v-for="item in costTypeSelectData"
  54. :key="item.id"
  55. :label="item.name"
  56. :value="item.id"
  57. ></el-option>
  58. </el-select>
  59. </el-form-item>
  60. <el-form-item label="收入状态" v-if="form.type==='INCOME'" :label-width="formLabelWidth">
  61. <el-radio-group
  62. style="width:100%"
  63. v-model="form.incomeStatus"
  64. placeholder="请选择状态值"
  65. size="medium"
  66. >
  67. <el-row :gutter="10">
  68. <el-col :span="4">
  69. <el-radio style="width:100%;" border label="INVOICE">开票/应收</el-radio>
  70. </el-col>
  71. <el-col :span="4">
  72. <el-radio style="width:100%;" border label="ARRIVAL">到账</el-radio>
  73. </el-col>
  74. <el-col :span="4">
  75. <el-radio style="width:100%;" border label="INTERNAL">内部核算</el-radio>
  76. </el-col>
  77. </el-row>
  78. </el-radio-group>
  79. </el-form-item>
  80. <el-form-item
  81. label="归属项目"
  82. v-if="form.type!==''"
  83. style="display:inline-block;"
  84. prop="projectId"
  85. :label-width="formLabelWidth"
  86. >
  87. <el-select v-model="form.projectId" placeholder="请选择项目">
  88. <el-option key label="不选" value></el-option>
  89. <el-option
  90. v-for="item in projectSelectData"
  91. :key="item.id"
  92. :label="item.name"
  93. :value="item.id"
  94. ></el-option>
  95. </el-select>
  96. </el-form-item>
  97. <el-form-item
  98. label="归属产品"
  99. v-if="form.type==='INCOME'"
  100. prop="productId"
  101. style="display:inline-block;"
  102. :label-width="formLabelWidth"
  103. >
  104. <el-select v-model="form.productId" placeholder="请选择产品">
  105. <el-option key label="不选" value></el-option>
  106. <el-option
  107. v-for="item in productSelectData"
  108. :key="item.id"
  109. :label="item.name"
  110. :value="item.id"
  111. ></el-option>
  112. </el-select>
  113. </el-form-item>
  114. <el-form-item
  115. label="来源项目"
  116. style="display:inline-block;"
  117. prop="toProjectId"
  118. v-if="form.type!==''"
  119. :label-width="formLabelWidth"
  120. >
  121. <el-select v-model="form.toProjectId" placeholder="请选择项目">
  122. <el-option key label="不选" value></el-option>
  123. <el-option
  124. v-for="item in projectSelectData"
  125. :key="item.id"
  126. :label="item.name"
  127. :value="item.id"
  128. ></el-option>
  129. </el-select>
  130. </el-form-item>
  131. <el-form-item
  132. label="来源部门"
  133. prop="toDeptId"
  134. style="display:inline-block;"
  135. v-if="form.type!==''"
  136. :label-width="formLabelWidth"
  137. >
  138. <el-select v-model="form.toDeptId" placeholder="请选择部门">
  139. <el-option key label="不选" value></el-option>
  140. <el-option
  141. v-for="item in teamSelectData"
  142. :key="item.id"
  143. :label="item.name"
  144. :value="item.id"
  145. ></el-option>
  146. </el-select>
  147. </el-form-item>
  148. <el-form-item
  149. label="归属部门"
  150. style="display:inline-block;"
  151. prop="deptId"
  152. v-if="form.type!==''"
  153. :label-width="formLabelWidth"
  154. >
  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.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. :row-class-name="tableRowClassName"
  180. show-summary
  181. v-if="tableType === 'INCOME'"
  182. border
  183. >
  184. <el-table-column prop="happenTime" sortable :formatter="dateFormat" label="发生日期"></el-table-column>
  185. <el-table-column prop="amount" sortable label="金额"></el-table-column>
  186. <el-table-column label="收入状态" prop="incomeStatus" :formatter="incomeTypeFormat">
  187. <!-- <template slot-scope="props">
  188. <span>{{ props.row.incomeStatus == 'INVOICE' ? '开票/应收' : props.row.incomeStatus == 'ARRIVAL' ? '到账' : '内部核算' }}</span>
  189. </template>-->
  190. </el-table-column>
  191. <el-table-column label="产品" prop="product.name"></el-table-column>
  192. <el-table-column label="归属项目" prop="project.name"></el-table-column>
  193. <el-table-column label="归属部门" prop="department.name"></el-table-column>
  194. <!-- <el-table-column label="接收项目" prop="toProject.name"></el-table-column> -->
  195. <el-table-column prop="remark" label="备注"></el-table-column>
  196. </el-table>
  197. <!-- 查询结果成本表 -->
  198. <el-table
  199. :data="searchResult"
  200. style="width: 100%;margin-top:80px;"
  201. :row-class-name="tableRowClassName"
  202. show-summary
  203. v-if="tableType === 'COST'"
  204. border
  205. >
  206. <el-table-column prop="happenTime" sortable :formatter="dateFormat" label="时间"></el-table-column>
  207. <el-table-column prop="amount" sortable label="金额"></el-table-column>
  208. <el-table-column label="成本类别" prop="costType.name"></el-table-column>
  209. <el-table-column label="发生部门" prop="department.name"></el-table-column>
  210. <el-table-column label="发生项目/人" prop="project.name"></el-table-column>
  211. <!-- <el-table-column label="接收项目" prop="toProject.name"></el-table-column> -->
  212. <!-- <el-table-column label="接收部门" prop="toDepartment.name"></el-table-column> -->
  213. <el-table-column label="备注" prop="remark"></el-table-column>
  214. </el-table>
  215. <!-- 分页 -->
  216. <el-pagination
  217. background
  218. @current-change="handlePageChange"
  219. :page-size="50"
  220. :current-page.sync="pageNo"
  221. layout="prev, pager, next"
  222. :total="totalNumber"
  223. ></el-pagination>
  224. </div>
  225. </template>
  226. <script>
  227. import {
  228. getTeamSelect,
  229. getProjectSelect,
  230. getProductSelect,
  231. getCostTeamSelect,
  232. getCostTypeSelect,
  233. addManage,
  234. getManageList,
  235. setManage
  236. } from "@/api/manageApi";
  237. import TitleBar from "../layout/titleBar/TitleBar.vue";
  238. import { formatTime } from "../../utils/common";
  239. export default {
  240. components: {
  241. TitleBar
  242. },
  243. data() {
  244. return {
  245. type: "",
  246. dialogFormVisible: false,
  247. addFlag: false,
  248. id: "",
  249. searchResult: [],
  250. form: {
  251. type: "",
  252. productId: "",
  253. projectId: "",
  254. toDeptId: "",
  255. toProjectId: "",
  256. deptId: "",
  257. incomeStatus: "",
  258. status: "NORMAL",
  259. costTypeId: "",
  260. startTime: "",
  261. endTime: "",
  262. minAmount: "",
  263. maxAmount: "",
  264. pageNo: 1,
  265. pageSize: 50
  266. },
  267. pageNo: 1,
  268. pageSize: 50,
  269. totalNumber: 0,
  270. formLabelWidth: "120px",
  271. teamSelectData: [],
  272. projectSelectData: [],
  273. productSelectData: [],
  274. costTeamSelectData: [],
  275. costTypeSelectData: [],
  276. manageData: [],
  277. companyData: [],
  278. tableType: ""
  279. };
  280. },
  281. created() {
  282. // 获取部门下拉框
  283. getTeamSelect().then(res => {
  284. this.teamSelectData = res.data;
  285. });
  286. // 获取项目下拉框
  287. getProjectSelect().then(res => {
  288. this.projectSelectData = res.data;
  289. });
  290. //获取产品下拉框
  291. getProductSelect().then(res => {
  292. this.productSelectData = res.data;
  293. });
  294. //获取经营列表
  295. // getManageList({
  296. // type: "INCOME"
  297. // }).then(res => {
  298. // this.manageData = res.data;
  299. // console.log(res.data);
  300. // });
  301. //获取单位下拉
  302. getCostTeamSelect().then(res => {
  303. this.costTeamSelectData = res.data;
  304. });
  305. //获取成本类型下拉
  306. getCostTypeSelect().then(res => {
  307. this.costTypeSelectData = res.data;
  308. });
  309. },
  310. methods: {
  311. handlePageChange(val) {
  312. this.form.pageNo = val;
  313. this.$fetch("manageBase/manage", this.form).then(response => {
  314. console.log(response);
  315. this.searchResult = response.data.content;
  316. this.totalNumber = parseInt(response.data.totalElements);
  317. this.pageNo = parseInt(response.data.number) + 1;
  318. if (response.data && response.data.content.length == 0) {
  319. this.$message("未找到相应数据");
  320. }
  321. });
  322. },
  323. onSubmit() {
  324. // this.totalNumber = 0;
  325. this.searchResult = [];
  326. if (this.form.type === "INCOME") {
  327. this.form.costTypeId = "";
  328. this.tableType = "INCOME";
  329. }
  330. if (this.form.type === "COST") {
  331. this.form.incomeStatus = "";
  332. this.form.productId = "";
  333. this.tableType = "COST";
  334. }
  335. this.form.pageNo = 1;
  336. this.$fetch("manageBase/manage", this.form).then(response => {
  337. console.log(response);
  338. this.searchResult = response.data.content;
  339. this.totalNumber = parseInt(response.data.totalElements);
  340. this.pageNo = parseInt(response.data.number) + 1;
  341. if (response.data && response.data.content.length == 0) {
  342. this.$message("未找到相应数据");
  343. }
  344. });
  345. },
  346. onReset() {
  347. this.form.type = "";
  348. this.form.costTypeId = "";
  349. this.tableType = "";
  350. this.$refs.form.resetFields();
  351. },
  352. tableRowClassName({ row, rowIndex }) {
  353. console.log(row.type);
  354. if (row.type === "COST") {
  355. return "cost-row-search";
  356. } else {
  357. return "income-row-search";
  358. }
  359. // return "";
  360. },
  361. //获取部门名称
  362. getName(val) {
  363. let obj = {};
  364. obj = this.teamSelectData.find(item => {
  365. return item.id === val;
  366. });
  367. let getName = "";
  368. this.form.deptName = obj.name;
  369. },
  370. // 添加
  371. append(type) {
  372. this.type = type;
  373. this.dialogFormVisible = true;
  374. this.addFlag = true;
  375. },
  376. // 格式化时间
  377. dateFormat(row, column) {
  378. return formatTime(row.happenTime);
  379. },
  380. incomeTypeFormat(row) {
  381. return row.incomeStatus == "INVOICE"
  382. ? "开票/应收"
  383. : row.incomeStatus == "ARRIVAL"
  384. ? "到账"
  385. : "内部核算";
  386. },
  387. moneyFormat(row) {
  388. if (row.type == "COST") {
  389. return "-" + row.amount;
  390. } else {
  391. return row.amount;
  392. }
  393. }
  394. }
  395. };
  396. </script>
  397. <style scope>
  398. .marginTop {
  399. margin-top: 20px;
  400. }
  401. .el-table .cost-row-search {
  402. /* color: green; */
  403. /* background: #f0f9eb; */
  404. color: green;
  405. }
  406. .el-table .income-row-search {
  407. /* color: red; */
  408. /* background: rgba(248, 181, 172, 0.267); */
  409. color: red;
  410. /* color: #f0f9eb; */
  411. }
  412. </style>