<style scoped>
.page_fnDm {
background-color: white;
}
.PAGE_teamRE .query-box {
overflow: inherit;
padding-bottom: 0;
}
._nav {
margin: 20px 0 0 0;
background-color: #f5f5f5;
}
._nav li {
float: left;
font-size: 14px;
color: #666666;
padding: 15px 20px;
cursor: pointer;
position: relative;
background-color: #f1f1f1;
margin-right: 5px;
}
._nav li._active {
background-color: #ffffff;
color: #333333;
}
._nav li._active::after {
content: "";
width: 20px;
height: 3px;
background-color: #e95252;
display: inline-block;
position: absolute;
bottom: 0;
left: 38%;
}
.el-range-editor.el-input__inner {
border-radius: 0;
}
.PAGE_teamRE .query-box {
border: none;
}
.hight_query {
position: relative;
}
.hight_query span {
height: 34px;
line-height: 34px;
color: #e95252;
}
.hight_query span .icon-gengduo {
font-size: 12px;
}
.hight_query span em {
text-decoration: underline;
cursor: pointer;
}
.hight_query_box {
position: absolute;
background-color: white;
z-index: 2000;
right: 200px;
width: 800px;
}
._hqb_shadow {
box-shadow: 3px 2px 10px rgb(204, 203, 203);
border: 1px solid #ececec;
}
.PAGE_teamRE .query-box ul {
overflow: initial;
}
.hqb_t {
padding: 10px 20px;
font-size: 16px;
background-color: #e95252;
border: 1px solid #e95252;
color: #fff;
text-align: center;
margin-bottom: 15px;
}
.PAGE_teamRE .query-box li:last-child {
float: left;
}
.PAGE_teamRE .query-box > ul > li:last-child {
float: right;
}
.PAGE_teamRE .query-box .hight_query ul .el-input {
width: inherit;
}
.hight_query_box ul li {
margin-top: 0;
float: left;
margin-right: 15px;
}
.hight_query_box ul li label {
font-size: 14px;
}
.hight_query_box .el-form {
padding: 0 20px;
}
.hight_query_box ul li._hqb_btn {
float: right;
margin-right: 25px;
padding-top: 5px;
position: inherit;
}
.Receipt_box {
padding: 15px;
color: #c94052;
width: 614px;
background-color: rgba(242, 242, 242, 1);
border: 1px solid rgba(228, 228, 228, 1);
}
.Receipt_box.color_blur {
color: #106baf;
}
.Receipt_box.color_blur .rb_stit span {
display: inline-block;
border-bottom: 2px solid #106baf;
padding: 0 20px;
}
.rb_tit {
font-size: 18px;
text-align: center;
}
.rb_stit {
font-size: 14px;
text-align: center;
}
.rb_stit span {
display: inline-block;
border-bottom: 2px solid #c94052;
padding: 0 20px;
}
.rb_top_row {
display: flex;
justify-content: space-between;
font-size: 12px;
}
.rb_top_row span._r_name {
color: #333333;
}
.rb_top_row span._r_bold {
font-weight: bold;
}
.rb_top_row ._r_time span {
color: #333333;
}
._r_mb5 {
margin-bottom: 5px;
}
.Receipt_table {
width: 100%;
font-size: 14px;
text-align: center;
}
.Receipt_table .th {
font-weight: 200 !important;
}
._r_mt10 {
margin-top: 10px;
}
._bg__ {
display: inline-block;
padding: 2px 8px;
color: white;
border-radius: 4px;
}
._bg_red {
background-color: #e95252;
}
._bg_green {
background-color: #2bb87c;
}
.text_d {
text-decoration: underline;
cursor: pointer;
}
.PingFangSC {
font-weight: bold;
}
.Bill_par {
position: relative;
}
tr th,
tr td {
text-align: left;
padding-left: 20px;
}
tr._item_list {
border-bottom: 1px solid #e5e5e5;
height: 78px;
}
tr._item_list td {
border-bottom: 1px solid #e5e5e5;
padding: 10px;
}
/* tr._t_head th{border-top: 1px solid #e5e5e5;} */
tr._item_list td:first-child {
border-left: 1px solid #e5e5e5;
}
tr._item_list td:last-child {
border-right: 1px solid #e5e5e5;
}
._head_img {
width: 28px;
height: 28px;
border-radius: 50%;
vertical-align: middle;
}
._btn_group {
font-size: 14px;
}
.icon-daiqueren {
color: #4bca81;
}
.icon-yiqueren {
color: #4bca81;
}
.icon-yiquxiao {
color: #959595;
}
.icon-shenhebohui {
color: #e95252;
}
.icon-icon-zancun {
color: #ff9c01;
}
.singeRowTable tr:hover {
background-color: white;
}
._TradeWayList {
padding: 5px 10px;
background-color: #eeeeee;
border-radius: 4px;
margin: 10px 0;
width: 190px;
}
._bold {
font-weight: bold;
}
._bank_name,
._bank_type {
display: inline-block;
background-color: #333333;
color: white;
padding: 2px 4px;
border-radius: 4px;
margin-left: 10px;
}
._bank_name {
margin-left: 10px;
}
._bank_type {
background-color: #2aaef2;
}
._bank_type2 {
background-color: #ff9c01;
}
._font_init {
color: #333333;
font-size: 12px;
vertical-align: top;
}
.InfoChangeLog {
height: auto;
max-height: 220px;
background-color: #ffffff;
}
.changLogList {
padding-left: 20px;
max-height: 180px;
overflow: auto;
}
.changLogList_l {
border-left: 1px solid #e9e9e9;
position: relative;
padding-bottom: 10px;
padding-left: 20px;
padding-top: 10px;
}
._radius_green {
background-color: #47bf8c;
width: 7px;
height: 7px;
border-radius: 50%;
display: inline-block;
position: absolute;
left: -4px;
top: 19px;
}
.changLog_time {
color: #666666;
font-size: 12px;
display: inline-block;
padding-right: 10px;
}
._icon_btn i {
width: 30px;
height: 30px;
display: inline-block;
color: white !important;
border-radius: 50%;
text-align: center;
line-height: 30px;
margin-right: 10px;
cursor: pointer;
outline: none;
}
._icon_btn i.edit {
background-color: #00c6ff;
font-size: 16px;
}
._icon_btn i.edit:hover {
background-color: #59daff;
}
._icon_btn i.edit:active {
background-color: #00b8ec;
}
._icon_btn i.icon-sousuo {
background-color: #47bf8c;
}
._icon_btn i.icon-sousuo:hover {
background-color: #66bb97;
}
._icon_btn i.icon-sousuo:active {
background-color: #35ab79;
}
._icon_btn i.icon-ico_commodity_defaul {
background-color: #f16c3c;
}
._icon_btn i.icon-ico_commodity_defaul:hover {
background-color: #e87c54;
}
._icon_btn i.icon-ico_commodity_defaul:active {
background-color: #f76630;
}
._icon_btn i.icon-quxiao1 {
background-color: #e95252;
}
._icon_btn i.icon-quxiao1:hover {
background-color: #ea6d6d;
}
._icon_btn i.icon-quxiao1:active {
background-color: #e42d2d;
}
._icon_btn i.icon-zhuanjiao1 {
background-color: #e6a014;
font-size: 16px;
}
._icon_btn i.icon-zhuanjiao1:hover {
background-color: rgb(235, 184, 84);
}
._icon_btn i.icon-zhuanjiao1:active {
background-color: rgb(223, 150, 6);
}
._tag_span {
background-color: rgba(64, 158, 255, 0.1);
display: inline-block;
padding: 0 5px;
height: 22px;
line-height: 20px;
font-size: 12px;
color: #409eff;
border-radius: 4px;
box-sizing: border-box;
border: 1px solid rgba(64, 158, 255, 0.2);
white-space: nowrap;
margin-bottom: 4px;
}
._tag_span._tag_warr {
background-color: rgba(103, 194, 58, 0.1);
border-color: rgba(103, 194, 58, 0.2);
color: #67c23a;
}
._fex_cen {
display: flex;
align-items: center;
}
._pad5 {
padding: 5px 10px;
}
._color_gar {
color: gray;
}
._TCIDAndTCNUMList {
display: flex;
}
.other_report {
padding: 0 28px 15px 28px;
}
.other_report li {
float: left;
color: #fff;
background-color: #b00;
border-color: #b00;
min-width: 80px;
padding: 4px 12px;
margin-bottom: 0;
font-size: 14px;
font-weight: normal;
text-align: center;
cursor: pointer;
border-radius: 4px;
margin-bottom: 10px;
}
</style>
<template>
<div class="My_table_tell page_fnDm page_RecPayQuery PAGE_teamRE" v-loading="AALloading">
<button style="float:right;margin:15px 0" class="normalBtn" type="primary" @click="Export">{{$t('visa.v_daochu')}}</button>
<div class="_fnDm_content" v-loading="loading">
<v-table
is-horizontal-resize
column-width-drag
:show-vertical-border="true"
style="width:100%"
:columns="columns"
:table-data="DataList"
:filter-method="filterMethod"
:total="total"
:pageSize="msg.pageSize"
:pageIndex="msg.pageIndex"
:handleCurrentChange="handleCurrentChanges"
:row-height="30"
:column-cell-class-name="columnCellClass"
@on-custom-comp="customCompFunc"
@sort-change="sortChange"
:footer="footer"
:footer-row-height="33"
:multiple-sort="multipleSort"
>
<!-- 多个排序 -->
</v-table>
</div>
<el-dialog
custom-class="w750"
:title="kaiqiZzTitle"
:visible.sync="kaiqiZzBox"
center
:before-close="initKaiqiZzBox"
v-loading="kaiqiZzLoading"
>
<div style="text-align: center">
<label>{{$t('scen.sc_ftTime')}}：</label>
<el-date-picker
class="h34"
@change="timeAdd(2)"
v-model="KaiqiZzTime"
type="daterange"
value-format="yyyy-MM-dd"
:picker-options="pickerOptions2"
:range-separator="$t('OrderList.zhi')"
></el-date-picker>
</div>
<div slot="footer" style="text-align: right;margin-top: 15px;" class="dialog-footer">
<button class="normalBtn" type="primary" @click="submitKaiqiZzBox">{{$t('pub.sureBtn')}}</button>
<button class="hollowFixedBtn" @click="initKaiqiZzBox">{{$t('pub.cancelBtn')}}</button>
</div>
</el-dialog>
</div>
</template>
<script>
import Vue from "vue";
import XLSX from "xlsx";
import downloadExcelEasy from "../../../assets/utils/downloadExcelEasy";
import { setTimeout } from "timers";
Vue.component("TCIDJump", {
// 团队跳转
template: `
<div>
<span style="cursor: pointer" v-if="rowData.DataType===1" @click="goUrl('TeamBalancePayment',rowData.TCID)">{{rowData.TCID}}</span>
<span style="cursor: pointer" v-if="rowData.DataType===2" @click="goUrl('individualTicket',rowData.TCID)">{{rowData.TCID}}</span>
<span style="cursor: pointer" v-if="rowData.DataType===3" @click="goUrlVisa('VisaProduct',rowData.TCID)">{{rowData.TCID}}</span>
<span style="cursor: pointer" v-if="rowData.DataType===4" @click="goUrl('SettlementOrder',rowData.TCID)">{{rowData.TCID}}</span>
<span style="cursor: pointer" v-if="rowData.DataType===6">{{rowData.TCID}}</span>
</div>
`,
props: {
rowData: {
type: Object
},
field: {
type: String
},
index: {
type: Number
}
},
methods: {
goUrl(path, id) {
this.$router.push({
path: "/" + path,
query: { id: id, blank: "y" }
});
},
goUrlVisa(path, id) {
this.$router.push({
path: "/" + path,
query: { VisaID: id, blank: "y" }
});
}
}
});
Vue.component("TCNUMJumpNew", {
// 团队跳转
template: `<div>
<span style="cursor: pointer" v-if="rowData.DataType===1" @click="goUrl('TravelControlList',rowData.TCNUM)">{{rowData.TCNUM}}</span>
<span style="cursor: pointer" v-if="rowData.DataType===2" @click="goUrlExtend('individualTicket',rowData.TCID)">{{rowData.TCNUM}}</span>
<span style="cursor: pointer" v-if="rowData.DataType===3" @click="goUrlVisa('VisaProduct',rowData.TCID)">{{rowData.TCNUM}}</span>
<span style="cursor: pointer" v-if="rowData.DataType===4" @click="goUrlExtend('SettlementOrder',rowData.TCID)">{{rowData.TCNUM}}</span>
<span style="cursor: pointer" v-if="rowData.DataType===6">{{rowData.TCNUM}}</span>
<span style="cursor: pointer" v-if="rowData.DataType===7">{{rowData.TCNUM}}</span>
</div>`,
props: {
rowData: {
type: Object
},
field: {
type: String
},
index: {
type: Number
}
},
methods: {
goUrl(path, id) {
this.$router.push({
path: "/" + path,
query: { tcmun: id, blank: "y" }
});
},
goUrlExtend(path, id) {
this.$router.push({
path: "/" + path,
query: { id: id, blank: "y" }
});
},
goUrlVisa(path, id) {
this.$router.push({
path: "/" + path,
query: { VisaID: id, blank: "y" }
});
}
}
});
Vue.component("GuestNum", {
// 人数
template: `<span>{{rowData.GuestNum}}+{{rowData.LeaderNum}}</span>`,
props: {
rowData: {
type: Object
},
field: {
type: String
},
index: {
type: Number
}
}
});
Vue.component("Transport", {
// 是否联运团
template: `<span><span v-if="rowData.Is_Transport==='是'" style="color: red;">{{rowData.Is_Transport}}</span><span v-else>{{rowData.Is_Transport}}</span></span>`,
props: {
rowData: {
type: Object
},
field: {
type: String
},
index: {
type: Number
}
}
});
Vue.component("TCIDJumpWang", {
template: `<div>
<span style="cursor: pointer" v-if="rowData.DataType===1" @click="goUrl('TeamBalancePayment',rowData.TCID)">{{rowData[field]}}</span>
<span v-else >{{rowData[field]}}</span>
</div>`,
props: {
rowData: {
type: Object
},
field: {
type: String
},
index: {
type: Number
}
},
data(){
return {
red: false
}
},mounted(){
},
methods: {
goUrl(path, id) {
this.$router.push({
path: "/" + path,
query: { id: id, blank: "y" }
});
}
}
});
export default {
data() {
return {
showID: false,
active: 1,
userId: 0,
msg: {
pageIndex: 1,
pageSize: 16,
OutBranchId:-1,
StartCityId: "",
LineId: "",
LineTeamId: "",
TCID: "",
startDate: "",
endDate: "",
Type: 1,
QueryCondition: "-1",
DataType: "1",
Is_Transport:'-1'
},
getCompanyMsg: {
// 公司
RB_Group_Id: "0",
Status: "0"
},
DataList: [],
UpdateStaus:0,
UpdateStartTime:'',
UpdateEndTime:'',
CompanyList: [],
productionDate: [],
loading: false,
currentPage: 1,
total: 0,
tableData: [],
LineList: [],
LineTeamList: [],
startCityList1: [],
multipleSort: false,
kaiqiZzBox: false,
KaiqiZzTime: [],
kaiqiZzTitle: "",
kaiqiZzLoading: false,
kaiqiZzMsg: {
QStartDate: "",
QEndDate: "",
Is_Open: ""
},
SDate:'',
EDate:'',
defaultMonth: [],
pickerOptions: {
onPick: ({ maxDate, minDate }) => {
this.choiceDate = minDate.getTime();
if (maxDate) {
this.choiceDate = "";
}
},
disabledDate: time => {
if (time < new Date("2018-12-31")) {
return true;
} else {
if (this.choiceDate) {
const one = 365 * 24 * 3600 * 1000;
const minTime = this.choiceDate - one;
const maxTime = this.choiceDate + one;
return time.getTime() < minTime || time.getTime() > maxTime;
}
}
}
},
pickerOptions2: {
onPick: ({ maxDate, minDate }) => {
this.choiceDate = minDate.getTime();
if (maxDate) {
this.choiceDate = "";
}
},
disabledDate: time => {
if (this.choiceDate) {
const one = 30 * 24 * 3600 * 1000;
const minTime = this.choiceDate - one;
const maxTime = this.choiceDate + one;
return time.getTime() < minTime || time.getTime() > maxTime;
}
}
},
columns: [
// 团队编号、团号 点击跳转团控列表
{
field: "LineName",
title: this.$t('advmanager.v_line'),
width: 120,
titleAlign: "left",
columnAlign: "left",
isResize: true,
result: [],
type: "select",
isFrozen: true
},
{
field: "TCID",
title: this.$t('scen.sc_temID'),
width: 80,
titleAlign: "left",
columnAlign: "left",
isResize: true,
isFrozen: true,
componentName: "TCIDJump"
},
{
field: "TCNUM",
title: this.$t('visa.v_tuanhao'),
width: 150,
titleAlign: "left",
columnAlign: "left",
isResize: true,
result: "",
filterMultiple: false,
type: "text",
isFrozen: true,
componentName: "TCNUMJumpNew"
},
{
field: "Is_Transport",
title: this.$t('objFill.shifoulyzc'),
width: 80,
titleAlign: "left",
columnAlign: "left",
isResize: true,
isFrozen: true,
componentName: "Transport"
},
{
field: "YingShou",
formatter: this.moneyFormat,
title: this.$t('fnc.ysjine'),
width: 100,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
}, //,orderBy:''
{
field: "ShiShou",
formatter: this.moneyFormat,
title: this.$t('objFill.shishoujine'),
width: 100,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "TuiKuan",
formatter: this.moneyFormat,
title: this.$t('fnc.tuikuan'),
width: 100,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "PingTaiShuiJin",
formatter: this.moneyFormat,
title: this.$t('fnc.ptshuijin'),
width: 100,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "ZaiTu",
formatter: this.moneyFormat,
title: this.$t('fnc.zaitu'),
width: 100,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "YouHui",
formatter: this.moneyFormat,
title: this.$t('fnc.youhui'),
width: 100,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "DaiShou",
formatter: this.moneyFormat,
title: this.$t('Operation.Op_daishou'),
width: 100,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "YiShou",
formatter: this.moneyFormat,
title: this.$t('objFill.yishoujine'),
width: 100,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "GuestNum",
title: this.$t('admin.admin_personNumber'),
width: 50,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "GuestNum"
},
{
field: "YaoQingHan",
formatter: this.moneyFormat,
title: this.$t('objFill.yaoqinghan'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "CheZi",
formatter: this.moneyFormat,
title: this.$t('ground.chezi'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "RoomFee",
formatter: this.moneyFormat,
title: this.$t('objFill.fangfei'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "MealFee",
formatter: this.moneyFormat,
title: this.$t('objFill.canfei'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "TicketFee",
formatter: this.moneyFormat,
title: this.$t('objFill.menpiaofei'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "JiPiao",
formatter: this.moneyFormat,
title: this.$t('objFill.jipiaokuan'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "GuoNeiLianYunJiPiao",
formatter: this.moneyFormat,
title: this.$t('objFill.guoneilyjp'),
width: 120,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "AirLossIncome",
formatter: this.moneyFormat,
title: this.$t('objFill.jishunzengs'),
width: 120,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "AirServiceCharge",
formatter: this.moneyFormat,
title: this.$t('objFill.kaipiaofeiyong'),
width: 120,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "Visa",
formatter: this.moneyFormat,
title: this.$t('active.cl_qianzheng'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "TiCheng",
title: this.$t('salesModule.Commission'),
width: 100,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "CompensationMoney",
title: this.$t('objFill.peichang'),
formatter: this.moneyFormat,
width: 100,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "BaoXian",
title: this.$t('objFill.baoxianfei'),
formatter: this.moneyFormat,
width: 100,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "QiTa",
formatter: this.moneyFormat,
title: this.$t('active.cl_qita'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "DiJieZhiChu",
formatter: this.moneyFormat,
title: this.$t('objFill.dijiekzc'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "DiJieShouRu",
formatter: this.moneyFormat,
title: this.$t('objFill.dijieksr'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "ZiFei",
formatter: this.moneyFormat,
title: this.$t('objFill.zifeir'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "XiaoFeiShouRu",
formatter: this.moneyFormat,
title: this.$t('objFill.xiaofeisr'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "YongJinShouRu",
formatter: this.moneyFormat,
title: this.$t('objFill.yongjinsr'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "YingFu",
formatter: this.moneyFormat,
title: this.$t('objFill.yingfujine'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "MaoLi",
formatter: this.moneyFormat,
title: this.$t('objFill.maoli'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "MaoLiRate",
// formatter: this.moneyFormat,
title: this.$t('objFill.maolilv'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "ShiJiLiRun",
formatter: this.moneyFormat,
title: this.$t('objFill.shijilirun'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true,
componentName: "TCIDJumpWang"
},
{
field: "Remark",
formatter: this.moneyFormat,
title: this.$t('pub.pubRemark'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true
},
{
field: "BName",
title: this.$t('objFill.gongsibie'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true
},
{
field: "TransportCost",
formatter: this.moneyFormat,
title: this.$t('objFill.lianyunchengben'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true
},
{
field: "UnionTiCheng",
formatter: this.moneyFormat,
title: this.$t('objFill.lianyunchegbe'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true
},
{
field: "YingYeE",
formatter: this.moneyFormat,
title: this.$t('objFill.lianyunyye'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true
},
{
field: "RealIncome",
formatter: this.moneyFormat,
title: this.$t('objFill.shijiyinye'),
width: 90,
titleAlign: "left",
columnAlign: "right",
isResize: true
}
],
footer: [],
pageSize: 6,
pageIndex: 1,
AALloading: false,
BranchStatus:true,
shujuType:false,
TCID:0,
};
},
created() {
this.msg.startDate=this.$route.query.StartTime!=undefined?this.$route.query.StartTime:'';
this.msg.endDate=this.$route.query.EndTime!=undefined?this.$route.query.EndTime:'';
this.msg.LineId=this.$route.query.LineId!=undefined?Number(this.$route.query.LineId):'';
this.msg.OutBranchId=this.$route.query.BranchId?Number(this.$route.query.BranchId):this.msg.OutBranchId;
if(this.msg.endDate!=""){
this.productionDate[0]=this.msg.startDate;
this.productionDate[1]=this.msg.endDate;
}
if(this.msg.LineId>0){
this.msg.DataType="1";
}
if(this.msg.LineId==-1){
// 其余都是不限
this.msg.DataType="-1";
this.msg.OutBranchId=45;
this.msg.LineId=0;
}
if(this.msg.LineId==-2){
this.msg.DataType="2";
}
if(this.msg.LineId==-3){
this.msg.DataType="5";
}
if(this.msg.LineId==-4){
this.msg.DataType="3";
}
let userInfo = this.getLocalStorage();
this.userId = userInfo.EmployeeId;
},
components: {},
mounted() {
let allH, allW, cH, cW;
allH = document.documentElement.clientHeight;
allW = document.documentElement.clientWidth;
cW = allW - 90;
cH = allH - 350 - 52;
this.msg.pageSize = parseInt(cH / 30) - 1;
let userInfo = this.getLocalStorage();
this.getCompanyMsg.RB_Group_Id = userInfo.RB_Group_id; //集团ID
this.userId = userInfo.EmployeeId;
this.getCompanyList();
this.getLineList();
this.getStartList1();
this.TCID = this.$route.query.id;
this.getList();
//this.getPageList();
},
methods: {
Export(){
let msg ={};
msg.EmployeeId = this.userId;
msg.TCID=this.TCID;
this.GetLocalFile(
"financestatistics_post_OutToExcelChangeHistoryReportList",
msg,
this.$t('objFill.v101.FinancialModule.biangbbxq')+".xls"
);
},
goEasyReport: function() {
let year = this.productionDate[0]
? this.productionDate[0].substring(0, 4)
: "";
this.$router.push({
path: "/EasyReport",
query: { year: year, blank: "y" }
});
},
togbu: function() {
this.AALloading = true;
this.apipost(
"financestatistics_post_InsertFinanceStatistics",
{},
res => {
if (res.data.resultCode == 1) {
this.$message.success(res.data.message);
} else {
this.AALloading = false;
this.$message.error(res.data.message);
}
}
);
},
submitKaiqiZzBox: function() {
// 开关闸提交
if (
this.kaiqiZzMsg.QStartDate === "" ||
this.kaiqiZzMsg.QEndDate === ""
) {
return this.$message.error(this.$t('objFill.qingxzftrq'));
}
this.kaiqiZzLoading = true;
this.apipost(
"travel_post_UpdateBatchBrakeAccountStatus",
this.kaiqiZzMsg,
r => {
if (r.data.resultCode === 1) {
this.getList();
this.initKaiqiZzBox();
this.kaiqiZzLoading = false;
this.$message.success(r.data.message);
} else {
this.kaiqiZzLoading = false;
}
},
null
);
},
openKaiQiZzBox: function(text) {
// 打开开关闸弹窗
this.kaiqiZzMsg.Is_Open = text === "一键开启" ? 0 : 1;
this.kaiqiZzTitle = text;
this.kaiqiZzBox = true;
},
initKaiqiZzBox: function() {
// 初始化开关闸信息
this.KaiqiZzTime = [];
this.kaiqiZzMsg = {
QStartDate: "",
QEndDate: "",
Is_Open: ""
};
this.kaiqiZzBox = false;
},
method5: function() {
let msg = JSON.parse(JSON.stringify(this.msg));
delete msg.pageIndex;
delete msg.pageSize;
msg.EmployeeId = this.userId;
this.GetLocalFile(
"financestatistics_post_OutToExcelRevenueReportList",
msg,
this.$t('fnc.ysbaobiao')+".xls"
);
},
exportExcelCurrentPage() {
//待实现
// 导出文件名
let xlsxName = "团队营收报表";
// 数据源
let dataSource = this.DataList;
let data = [];
// 创建表头数据
data.push([
"线路",
"团队编号",
"团号",
"是否有联运支出",
"应收金额",
"实收金额",
"退款",
"平台税金",
"优惠金额",
"待收金额",
"溢收金额",
"人数",
"邀请函",
"车资",
"机票款",
"国内联运机票",
"签证",
"其他",
"地接款支出",
"地接款收入",
"自费收入",
"小费收入",
"佣金收入",
"应付金额",
"毛利",
"毛利率",
"实际利润",
"备注",
"公司别",
"成都",
"昆明",
"重庆",
"武汉",
"西安",
"长沙",
"贵阳",
"南昌",
"厦门",
"兰州",
"南京",
"微途",
"合肥",
"南宁",
"联运成本",
"联运提成",
"营业额",
"GRP",
"TKT",
"VISA",
"自由行",
"地接",
"酒店",
"单团",
"护照",
"平均收入",
"平均成本",
"平均利润"
]);
downloadExcelEasy.downLoad(data[0], dataSource, this.footer);
return;
let wscols = {};
// 每列的宽度
wscols = [];
// 组装表格内容
dataSource.forEach((x, index) => {
let obj = [];
obj.push(x.FrID + " ");
obj.push(x.TCNUM);
obj.push(x.TCID);
obj.push("否");
for (let i = 0; i <= data[0].length - 5; i++) {
obj.push(Math.random() * 9999);
}
data.push(obj);
if (index === dataSource.length - 1) {
let obj = [];
this.footer[0].forEach(x => {
obj.push(x);
});
data.push(obj);
}
});
let colName = [
"A",
"B",
"C",
"D",
"E",
"F",
"G",
"H",
"I",
"J",
"K",
"L",
"M",
"N",
"O",
"P",
"Q",
"R",
"S",
"T",
"U",
"V",
"W",
"X",
"Y",
"Z",
"AA",
"AB",
"AC",
"AD",
"AE",
"AF",
"AG",
"AH",
"AI",
"AJ",
"AK",
"AL",
"AM",
"AN",
"AO",
"AP",
"AQ",
"AR",
"AS",
"AT",
"AU",
"AV",
"AW",
"AX",
"AY",
"AZ",
"BA",
"BB",
"BC",
"BD",
"BE",
"BF",
"BG"
];
const ws = XLSX.utils.aoa_to_sheet(data);
ws["!cols"] = wscols;
ws["!rows"] = [];
// colName.forEach((x,index)=>{
// wscols.push({wpx: 100})
// });
// dataSource.forEach((x,index)=>{
// if(index===dataSource.length)
// ws['!rows'].push({ hpx:30 });
// else
// ws['!rows'].push({});
// });
const wb = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, xlsxName);
var dataInfo = wb.Sheets[wb.SheetNames[0]];
// return
data[0].forEach((x, i) => {
dataInfo[colName[i] + "1"].s = {
fill: { fgColor: { rgb: "#ffff00" } },
font: {
name: "微软雅黑",
sz: 32,
color: { rgb: "#ffff00" },
bold: true,
italic: true,
underline: true
},
alignment: {
horizontal: "center",
vertical: "center"
}
};
});
// return
XLSX.writeFile(wb, xlsxName + ".xlsx");
},
moneyFormat(rowData, rowIndex, pagingIndex, field) {
if (field === "YingShou") return this.priceFormat(rowData.YingShou);
if (field === "ShiShou") return this.priceFormat(rowData.ShiShou);
if (field === "TuiKuan") return this.priceFormat(rowData.TuiKuan);
if (field === "PingTaiShuiJin")
return this.priceFormat(rowData.PingTaiShuiJin);
if (field === "DaiShou") return this.priceFormat(rowData.DaiShou);
if (field === "ZaiTu") return this.priceFormat(rowData.ZaiTu);
if (field === "RealIncome") return this.priceFormat(rowData.RealIncome);
if (field === "YiShou") return this.priceFormat(rowData.YiShou);
if (field === "YaoQingHan") return this.priceFormat(rowData.YaoQingHan);
if (field === "CheZi") return this.priceFormat(rowData.CheZi);
if (field === "JiPiao") return this.priceFormat(rowData.JiPiao);
if (field === "GuoNeiLianYunJiPiao")
return this.priceFormat(rowData.GuoNeiLianYunJiPiao);
if (field === "Visa") return this.priceFormat(rowData.Visa);
if (field === "TiCheng") return this.priceFormat(rowData.TiCheng);
if (field === "CompensationMoney")
return this.priceFormat(rowData.CompensationMoney);
if (field === "QiTa") return this.priceFormat(rowData.QiTa);
if (field === "DiJieZhiChu") return this.priceFormat(rowData.DiJieZhiChu);
if (field === "DiJieShouRu") return this.priceFormat(rowData.DiJieShouRu);
if (field === "ZiFei") return this.priceFormat(rowData.ZiFei);
if (field === "MianShuiDian")
return this.priceFormat(rowData.MianShuiDian);
if (field === "XiaoFeiShouRu")
return this.priceFormat(rowData.XiaoFeiShouRu);
if (field === "YongJinShouRu")
return this.priceFormat(rowData.YongJinShouRu);
if (field === "YingFu") return this.priceFormat(rowData.YingFu);
if (field === "MaoLi") return this.priceFormat(rowData.MaoLi);
// if (field === "MaoLiRate") return rowData.MaoLiRate;
if (field === "ShiJiLiRun") return this.priceFormat(rowData.ShiJiLiRun);
if (field === "TransportCost")
return this.priceFormat(rowData.TransportCost);
if (field === "UnionTiCheng")
return this.priceFormat(rowData.UnionTiCheng);
if (field === "YingYeE") return this.priceFormat(rowData.YingYeE);
if (field === "AverageIncome")
return this.priceFormat(rowData.AverageIncome);
if (field === "AverageCost") return this.priceFormat(rowData.AverageCost);
if (field === "AverageProfit")
return this.priceFormat(rowData.AverageProfit);
},
setFooterCellClass(rowIndex, colIndex, value) {
if (colIndex === 0) {
return "footer-cell-class-name-title";
} else {
return "footer-cell-class-name-normal";
}
},
priceFormat(value) {
if (value == null) {
return 0.0;
}
let nStr = value.toFixed(2);
nStr += "";
let x = nStr.split(".");
let x1 = x[0];
let x2 = x.length > 1 ? "." + x[1] : "";
var rgx = /(\d+)(\d{3})/;
while (rgx.test(x1)) {
x1 = x1.replace(rgx, "$1" + "," + "$2");
}
return x1 + x2;
},
columnCellClass(rowIndex, columnName, rowData) {
if(rowData.YingShou < 0 && columnName=="YingShou"){
return "column-cell-class-name-test-red"
}
if(rowData.ShiShou < 0 && columnName=="ShiShou"){
return "column-cell-class-name-test-red"
}
if(rowData.TuiKuan < 0 && columnName=="TuiKuan"){
return "column-cell-class-name-test-red"
}
if(rowData.PingTaiShuiJin < 0 && columnName=="PingTaiShuiJin"){
return "column-cell-class-name-test-red"
}
if(rowData.ZaiTu < 0 && columnName=="ZaiTu"){
return "column-cell-class-name-test-red"
}
if(rowData.YouHui < 0 && columnName=="YouHui"){
return "column-cell-class-name-test-red"
}
if(rowData.DaiShou < 0 && columnName=="DaiShou"){
return "column-cell-class-name-test-red"
}
if(rowData.YiShou < 0 && columnName=="YiShou"){
return "column-cell-class-name-test-red"
}
if(rowData.GuestNum < 0 && columnName=="GuestNum"){
return "column-cell-class-name-test-red"
}
if(rowData.YaoQingHan < 0 && columnName=="YaoQingHan"){
return "column-cell-class-name-test-red"
}
if(rowData.CheZi < 0 && columnName=="CheZi"){
return "column-cell-class-name-test-red"
}
if(rowData.JiPiao < 0 && columnName=="JiPiao"){
return "column-cell-class-name-test-red"
}
if(rowData.GuoNeiLianYunJiPiao < 0 && columnName=="GuoNeiLianYunJiPiao"){
return "column-cell-class-name-test-red"
}
if(rowData.Visa < 0 && columnName=="Visa"){
return "column-cell-class-name-test-red"
}
if(rowData.TiCheng < 0 && columnName=="TiCheng"){
return "column-cell-class-name-test-red"
}
if(rowData.CompensationMoney < 0 && columnName=="CompensationMoney"){
return "column-cell-class-name-test-red"
}
if(rowData.BaoXian < 0 && columnName=="BaoXian"){
return "column-cell-class-name-test-red"
}
if(rowData.QiTa < 0 && columnName=="QiTa"){
return "column-cell-class-name-test-red"
}
if(rowData.DiJieZhiChu < 0 && columnName=="DiJieZhiChu"){
return "column-cell-class-name-test-red"
}
if(rowData.DiJieShouRu < 0 && columnName=="DiJieShouRu"){
return "column-cell-class-name-test-red"
}
if(rowData.ZiFei < 0 && columnName=="ZiFei"){
return "column-cell-class-name-test-red"
}
if(rowData.XiaoFeiShouRu < 0 && columnName=="XiaoFeiShouRu"){
return "column-cell-class-name-test-red"
}
if(rowData.YongJinShouRu < 0 && columnName=="YongJinShouRu"){
return "column-cell-class-name-test-red"
}
if(rowData.YingFu < 0 && columnName=="YingFu"){
return "column-cell-class-name-test-red"
}
if(rowData.MaoLi < 0 && columnName=="MaoLi"){
return "column-cell-class-name-test-red"
}
if(rowData.MaoLiRate < 0 && columnName=="MaoLiRate"){
return "column-cell-class-name-test-red"
}
if(rowData.ShiJiLiRun < 0 && columnName=="ShiJiLiRun"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportCD < 0 && columnName=="TransportCD"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportKM < 0 && columnName=="TransportKM"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportCQ < 0 && columnName=="TransportCQ"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportWH < 0 && columnName=="TransportWH"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportXA < 0 && columnName=="TransportXA"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportCS < 0 && columnName=="TransportCS"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportGY < 0 && columnName=="TransportGY"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportNC < 0 && columnName=="TransportNC"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportXM < 0 && columnName=="TransportXM"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportLZ < 0 && columnName=="TransportLZ"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportNJ < 0 && columnName=="TransportNJ"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportWT < 0 && columnName=="TransportWT"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportHF < 0 && columnName=="TransportHF"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportNN < 0 && columnName=="TransportNN"){
return "column-cell-class-name-test-red"
}
if(rowData.TransportCost < 0 && columnName=="TransportCost"){
return "column-cell-class-name-test-red"
}
if(rowData.UnionTiCheng < 0 && columnName=="UnionTiCheng"){
return "column-cell-class-name-test-red"
}
if(rowData.YingYeE < 0 && columnName=="YingYeE"){
return "column-cell-class-name-test-red"
}
if(rowData.RealIncome < 0 && columnName=="RealIncome"){
return "column-cell-class-name-test-red"
}
if(rowData.GRPNum < 0 && columnName=="GRPNum"){
return "column-cell-class-name-test-red"
}
if(rowData.TKTNum < 0 && columnName=="TKTNum"){
return "column-cell-class-name-test-red"
}
if(rowData.VisaNum < 0 && columnName=="VisaNum"){
return "column-cell-class-name-test-red"
}
if(rowData.ZiYouXingNum < 0 && columnName=="ZiYouXingNum"){
return "column-cell-class-name-test-red"
}
if(rowData.DiJieNum < 0 && columnName=="DiJieNum"){
return "column-cell-class-name-test-red"
}
if(rowData.HotelNum < 0 && columnName=="HotelNum"){
return "column-cell-class-name-test-red"
}
if(rowData.DanTuanNum < 0 && columnName=="DanTuanNum"){
return "column-cell-class-name-test-red"
}
if(rowData.HuZhaoNum < 0 && columnName=="HuZhaoNum"){
return "column-cell-class-name-test-red"
}
if(rowData.AverageIncome < 0 && columnName=="AverageIncome"){
return "column-cell-class-name-test-red"
}
if(rowData.AverageCost < 0 && columnName=="AverageCost"){
return "column-cell-class-name-test-red"
}
if(rowData.AverageProfit < 0 && columnName=="AverageProfit"){
return "column-cell-class-name-test-red"
}
// 给三行column为‘hobby’的列设置className
if (columnName === "LineName") {
return "column-cell-class-name-test";
}
if (columnName === "TCNUM") {
return "column-cell-class-name-test2";
}
if (columnName === "TCID") {
return "column-cell-class-name-test3";
}
if (columnName === "islianyun") {
return "column-cell-class-name-test4";
}
if (rowIndex === 18) {
return "column-cell-class-name-test-row";
}
},
getStartList1() {
// 获取出发城市
this.apipost(
"city_post_GetList",
{
isDefault: -1,
priceType: -1
},
res => {
if (res.data.resultCode == 1) {
this.startCityList1 = res.data.data;
} else {
}
}
);
},
getLineTeamList(lineId) {
//获取系列列表
this.LineTeamList = [];
this.apipost(
"team_post_GetList",
{
lineID: lineId,
isTOOP: 1
},
res => {
if (res.data.resultCode == 1) {
this.msg.LineTeamId = "-1";
this.LineTeamList = res.data.data;
}
}
);
},
getLineList() {
// 获取线路
this.apipost("line_post_GetAllList", {}, res => {
if (res.data.resultCode == 1) {
this.LineList = res.data.data;
} else {
this.$message.error(res.data.message);
}
});
},
customCompFunc(param) {
},
compare(property, type) {
// 升序 t 1升 2降
if (type === 1) {
return function(a, b) {
let value1 = a[property];
let value2 = b[property];
return value1 - value2;
};
} else {
return function(a, b) {
let value1 = a[property];
let value2 = b[property];
return value2 - value1;
};
}
},
sortChange(param) {
if (param.YingShou === "asc") {
this.DataList.sort(this.compare("YingShou", 1));
} else if (param.YingShou === "desc") {
this.DataList.sort(this.compare("YingShou", 2));
} else {
}
//自己写实现
//{gender:"",name:"asc"}
},
// 数据筛选
filterMethod(filters) {
this.total = tableData.length;
},
handleCurrentChanges(val) {
this.pageIndex = this.msg.pageIndex = val;
this.getList();
},
getPageList() {
// 获取列表数据
this.loading = true;
if (!this.msg.OutBranchId && this.msg.OutBranchId !== 0)
this.msg.OutBranchId = -1;
if (!this.msg.StartCityId) this.msg.StartCityId = 0;
if (!this.msg.LineId) this.msg.LineId = 0;
if (!this.msg.LineTeamId) this.msg.LineTeamId = 0;
if (!this.msg.TCID) this.msg.TCID = 0;
if (this.msg.startDate == "") this.msg.startDate = "2019-01-01";
this.apipost(
"financestatistics_post_GetPageList",
this.msg,
res => {
if (res.data.resultCode == 1) {
let BranchStatus=res.data.data.IsBranchButton;
if(BranchStatus==-2){
BranchStatus = -1;
this.shujuType = true;
this.apipost("line_post_GetList", {'LineDirection':2}, res => {
if (res.data.resultCode == 1) {
this.LineList = res.data.data;
} else {
this.Error(res.data.message);
}
});
}
if(BranchStatus==-1){
this.BranchStatus=false;
}else{
this.BranchStatus=true;
this.msg.OutBranchId=BranchStatus;
}
let data = res.data.data.pmodel.pageData;
this.total = res.data.data.pmodel.count;
this.SDate=res.data.data.pmodel.StartDate;
this.EDate=res.data.data.pmodel.NextDate;
this.UpdateStaus=res.data.data.Status;
this.UpdateStartTime=res.data.data.UpdateTime;
if (this.total == 0) {
this.DataList = [];
} else {
let newData = [];
data.forEach((x, index) => {
x.MaoLiRate=x.MaoLiRate+"%";
if (index !== data.length - 1) {
x.Is_Transport = x.Is_Transport === 0 ?this.$t('pub.no') :this.$t('pub.yes') ;
newData.push(x);
} else {
x.LineName = this.$t('fnc.a_heji');
x.TCID = "";
x.TCNUM = "";
x.Is_Transport = "";
x.BName = "";
newData.push(x);
}
});
this.DataList = newData;
// this.footer.push(data[data.length-1])
}
this.loading = false;
} else {
this.loading = false;
this.$message.error(res.data.message);
}
if (this.msg.OutBranchId === -1) this.msg.OutBranchId = -1;
if (!this.msg.StartCityId) this.msg.StartCityId = 0;
if (!this.msg.LineId) this.msg.LineId = 0;
if (!this.msg.LineTeamId) this.msg.LineTeamId = 0;
if (!this.msg.TCID) this.msg.TCID = "";
},
err => {}
);
},
getList(){
let msg = {
TCID:this.TCID
};
this.apipost(
"financestatistics_post_GetChangeListHistory",msg,
res => {
if (res.data.resultCode == 1) {
this.DataList = res.data.data;
} else {
}
},
err => {}
);
},
getCompanyList() {
//获取公司列表
this.apipost(
"admin_get_BranchGetList",
this.getCompanyMsg,
res => {
if (res.data.resultCode == 1) {
this.CompanyList = res.data.data;
} else {
}
},
err => {}
);
},
timeAdd(type) {
// 日期格式
if (type === 1) {
if (!this.productionDate) {
this.msg.startDate = "";
this.msg.endDate = "";
return;
}
this.msg.startDate = this.productionDate[0];
this.msg.endDate = this.productionDate[1];
}
if (type === 2) {
if (!this.KaiqiZzTime) {
this.kaiqiZzMsg.QStartDate = "";
this.kaiqiZzMsg.QEndDate = "";
return;
}
this.kaiqiZzMsg.QStartDate = this.KaiqiZzTime[0];
this.kaiqiZzMsg.QEndDate = this.KaiqiZzTime[1];
}
},
handleCurrentChange(val) {
//翻页
this.msg.pageIndex = val;
this.getList();
},
resetPageIndex() {
// 重置页码
this.msg.pageIndex = 1;
this.currentPage = 1;
}
}
};
</script>