query_20190322164620.vue 11 KB

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