query_20190322114401.vue 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325
  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 v-model="form.type" placeholder="请选择类别" size="medium">
  7. <el-radio border label="INCOME">收入</el-radio>
  8. <el-radio border label="COST">成本</el-radio>
  9. </el-radio-group>
  10. </el-form-item>
  11. <el-form-item label="时间范围" :label-width="formLabelWidth">
  12. <el-date-picker placeholder="起始时间" v-model="form.startTime" style="width: 100%;"></el-date-picker>
  13. <el-date-picker placeholder="结束时间" v-model="form.endTime" style="width: 100%;"></el-date-picker>
  14. </el-form-item>
  15. <el-form-item
  16. label="支出类型"
  17. v-if="form.type==='COST'"
  18. prop="costTypeId"
  19. :label-width="formLabelWidth"
  20. >
  21. <el-select v-model="form.costTypeId" placeholder="请选择支出类型" ref="select">
  22. <el-option key label="不选" value></el-option>
  23. <el-option
  24. v-for="item in costTypeSelectData"
  25. :key="item.id"
  26. :label="item.name"
  27. :value="item.id"
  28. ></el-option>
  29. </el-select>
  30. </el-form-item>
  31. <el-form-item label="收入状态" v-if="form.type==='INCOME'" :label-width="formLabelWidth">
  32. <el-radio-group v-model="form.incomeStatus" placeholder="请选择状态值" size="medium">
  33. <el-radio border label="INVOICE">开票/应收</el-radio>
  34. <el-radio border label="ARRIVAL">到账</el-radio>
  35. <el-radio border label="INTERNAL">内部核算</el-radio>
  36. </el-radio-group>
  37. </el-form-item>
  38. <el-form-item
  39. label="归属项目"
  40. v-if="form.type!==''"
  41. style="display:inline-block;"
  42. prop="projectId"
  43. :label-width="formLabelWidth"
  44. >
  45. <el-select v-model="form.projectId" placeholder="请选择项目">
  46. <el-option key label="不选" value></el-option>
  47. <el-option
  48. v-for="item in projectSelectData"
  49. :key="item.id"
  50. :label="item.name"
  51. :value="item.id"
  52. ></el-option>
  53. </el-select>
  54. </el-form-item>
  55. <el-form-item label="归属部门" style="display:inline-block;" prop="deptId" v-if="form.type!==''" :label-width="formLabelWidth">
  56. <el-select v-model="form.deptId" placeholder="请选择部门" ref="select">
  57. <el-option key label="不选" value></el-option>
  58. <el-option
  59. v-for="item in teamSelectData"
  60. :key="item.id"
  61. :label="item.name"
  62. :value="item.id"
  63. ></el-option>
  64. </el-select>
  65. </el-form-item>
  66. <el-form-item
  67. label="来源项目"
  68. style="display:inline-block;"
  69. prop="toProjectId"
  70. v-if="form.type!==''"
  71. :label-width="formLabelWidth"
  72. >
  73. <el-select v-model="form.toProjectId" placeholder="请选择项目">
  74. <el-option key label="不选" value></el-option>
  75. <el-option
  76. v-for="item in projectSelectData"
  77. :key="item.id"
  78. :label="item.name"
  79. :value="item.id"
  80. ></el-option>
  81. </el-select>
  82. </el-form-item>
  83. <el-form-item
  84. label="来源部门"
  85. prop="toDeptId"
  86. style="display:inline-block;"
  87. v-if="form.type!==''"
  88. :label-width="formLabelWidth"
  89. >
  90. <el-select v-model="form.toDeptId" placeholder="请选择部门">
  91. <el-option key label="不选" value></el-option>
  92. <el-option
  93. v-for="item in teamSelectData"
  94. :key="item.id"
  95. :label="item.name"
  96. :value="item.id"
  97. ></el-option>
  98. </el-select>
  99. </el-form-item>
  100. <el-form-item
  101. label="归属产品"
  102. v-if="form.type==='INCOME'"
  103. prop="productId"
  104. :label-width="formLabelWidth"
  105. >
  106. <el-select v-model="form.productId" placeholder="请选择产品">
  107. <el-option key label="不选" value></el-option>
  108. <el-option
  109. v-for="item in productSelectData"
  110. :key="item.id"
  111. :label="item.name"
  112. :value="item.id"
  113. ></el-option>
  114. </el-select>
  115. </el-form-item>
  116. <el-form-item
  117. style="position: absolute; width:23%; display:block; margin:0 auto; left: 0; right: 0;"
  118. >
  119. <el-button type="primary" @click="onSubmit">查询</el-button>
  120. <el-button type="info" @click="onReset">重置</el-button>
  121. </el-form-item>
  122. <!-- <el-form-item>
  123. <el-button type="info" @click="reset">重置</el-button>
  124. </el-form-item>-->
  125. </el-form>
  126. <!-- 查询结果收入表 -->
  127. <el-table
  128. :data="searchResult"
  129. style="width: 100%;margin-top:50px;"
  130. :row-class-name="tableRowClassName"
  131. show-summary
  132. v-if="tableType === 'INCOME'"
  133. border
  134. >
  135. <el-table-column prop="happenTime" sortable :formatter="dateFormat" label="发生日期"></el-table-column>
  136. <el-table-column prop="amount" sortable label="金额"></el-table-column>
  137. <el-table-column label="收入状态" prop="incomeStatus" :formatter="incomeTypeFormat">
  138. <!-- <template slot-scope="props">
  139. <span>{{ props.row.incomeStatus == 'INVOICE' ? '开票/应收' : props.row.incomeStatus == 'ARRIVAL' ? '到账' : '内部核算' }}</span>
  140. </template> -->
  141. </el-table-column>
  142. <el-table-column label="产品" prop="product.name"></el-table-column>
  143. <el-table-column label="归属项目" prop="project.name"></el-table-column>
  144. <el-table-column label="归属部门" prop="department.name"></el-table-column>
  145. <el-table-column label="接收项目" prop="toProject.name"></el-table-column>
  146. <el-table-column prop="remark" label="备注"></el-table-column>
  147. </el-table>
  148. <!-- 查询结果成本表 -->
  149. <el-table
  150. :data="searchResult"
  151. style="width: 100%;margin-top:50px;"
  152. :row-class-name="tableRowClassName"
  153. show-summary
  154. v-if="tableType === 'COST'"
  155. border
  156. >
  157. <el-table-column prop="happenTime" sortable :formatter="dateFormat" label="时间"></el-table-column>
  158. <el-table-column prop="amount" sortable label="金额"></el-table-column>
  159. <el-table-column label="成本类别" prop="costType.name"></el-table-column>
  160. <el-table-column label="发生部门" prop="department.name"></el-table-column>
  161. <el-table-column label="发生项目/人" prop="project.name"></el-table-column>
  162. <el-table-column label="接收项目" prop="toProject.name"></el-table-column>
  163. <el-table-column label="接收部门" prop="toDepartment.name"></el-table-column>
  164. <el-table-column label="备注" prop="remark"></el-table-column>
  165. </el-table>
  166. </div>
  167. </template>
  168. <script>
  169. import {
  170. getTeamSelect,
  171. getProjectSelect,
  172. getProductSelect,
  173. getCostTeamSelect,
  174. getCostTypeSelect,
  175. addManage,
  176. getManageList,
  177. setManage
  178. } from "@/api/manageApi";
  179. import TitleBar from "../layout/titleBar/TitleBar.vue";
  180. import { formatTime } from "../../utils/common";
  181. export default {
  182. components: {
  183. TitleBar
  184. },
  185. data() {
  186. return {
  187. type: "",
  188. dialogFormVisible: false,
  189. addFlag: false,
  190. id: "",
  191. searchResult: [],
  192. form: {
  193. type: "",
  194. productId: "",
  195. projectId: "",
  196. toDeptId: "",
  197. toProjectId: "",
  198. deptId: "",
  199. incomeStatus: "",
  200. status: "NORMAL",
  201. costTypeId: ""
  202. },
  203. formLabelWidth: "120px",
  204. teamSelectData: [],
  205. projectSelectData: [],
  206. productSelectData: [],
  207. costTeamSelectData: [],
  208. costTypeSelectData: [],
  209. manageData: [],
  210. companyData: [],
  211. tableType: ""
  212. };
  213. },
  214. created() {
  215. // 获取部门下拉框
  216. getTeamSelect().then(res => {
  217. this.teamSelectData = res.data;
  218. });
  219. // 获取项目下拉框
  220. getProjectSelect().then(res => {
  221. this.projectSelectData = res.data;
  222. });
  223. //获取产品下拉框
  224. getProductSelect().then(res => {
  225. this.productSelectData = res.data;
  226. });
  227. //获取经营列表
  228. getManageList({
  229. type: "INCOME"
  230. }).then(res => {
  231. this.manageData = res.data;
  232. console.log(res.data);
  233. });
  234. //获取单位下拉
  235. getCostTeamSelect().then(res => {
  236. this.costTeamSelectData = res.data;
  237. });
  238. //获取成本类型下拉
  239. getCostTypeSelect().then(res => {
  240. this.costTypeSelectData = res.data;
  241. });
  242. },
  243. methods: {
  244. onSubmit() {
  245. this.searchResult = '';
  246. if (this.form.type === "INCOME") {
  247. this.form.costTypeId = "";
  248. this.tableType = "INCOME";
  249. }
  250. if (this.form.type === "COST") {
  251. this.form.incomeStatus = "";
  252. this.form.productId = "";
  253. this.tableType = "COST";
  254. }
  255. this.$fetch("manageBase/manage", this.form).then(response => {
  256. console.log(response);
  257. this.searchResult = response.data;
  258. });
  259. },
  260. onReset() {
  261. this.form.type = "";
  262. this.form.costTypeId = "";
  263. this.tableType = "";
  264. this.$refs.form.resetFields();
  265. },
  266. tableRowClassName({ row, rowIndex }) {
  267. console.log(row.type);
  268. if (row.type === "COST") {
  269. return "cost-row-search";
  270. } else {
  271. return "income-row-search";
  272. }
  273. // return "";
  274. },
  275. //获取部门名称
  276. getName(val) {
  277. let obj = {};
  278. obj = this.teamSelectData.find(item => {
  279. return item.id === val;
  280. });
  281. let getName = "";
  282. this.form.deptName = obj.name;
  283. },
  284. // 添加
  285. append(type) {
  286. this.type = type;
  287. this.dialogFormVisible = true;
  288. this.addFlag = true;
  289. },
  290. // 格式化时间
  291. dateFormat(row, column) {
  292. return formatTime(row.happenTime);
  293. },
  294. incomeTypeFormat(row) {
  295. return row.incomeStatus == 'INVOICE' ? '开票/应收' : row.incomeStatus == 'ARRIVAL' ? '到账' : '内部核算'
  296. },
  297. moneyFormat(row) {
  298. if (row.type == "COST") {
  299. return "-" + row.amount;
  300. } else {
  301. return row.amount;
  302. }
  303. }
  304. }
  305. };
  306. </script>
  307. <style scope>
  308. .marginTop {
  309. margin-top: 20px;
  310. }
  311. .el-table .cost-row-search {
  312. /* color: green; */
  313. background: #f0f9eb;
  314. }
  315. .el-table .income-row-search {
  316. /* color: red; */
  317. background: rgba(248, 181, 172, 0.267);
  318. /* color: #f0f9eb; */
  319. }
  320. </style>