query_20190322153718.vue 11 KB

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