query_20190322170757.vue 12 KB

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