Search in sources :

Example 1 with ProxySumInfo

use of com.kendy.entity.ProxySumInfo in project financial by greatkendy123.

the class TeamProxyService method exportExcel_with_has_teamBaoxianRate.

/**
 * 导出无团队保险比例的Excel
 * @time 2018年2月8日
 */
public static void exportExcel_with_has_teamBaoxianRate() {
    String teamId = teamIDCombox.getSelectionModel().getSelectedItem();
    boolean isManage = isZjManage.isSelected();
    String time = DataConstans.Date_Str;
    if (StringUtil.isBlank(teamId)) {
        ShowUtil.show("导出失败! 请先选择团队ID!!");
        return;
    }
    if (StringUtil.isBlank(time)) {
        ShowUtil.show("导出失败! 您今天还没导入01场次的战绩,无法确认时间!!");
        return;
    }
    List<ProxyTeamInfo> list = new ArrayList<>();
    ObservableList<ProxyTeamInfo> obList = tableProxyTeam.getItems();
    if (obList != null && obList.size() > 0) {
        for (ProxyTeamInfo info : obList) {
            list.add(info);
        }
    } else {
        ShowUtil.show("没有需要导出的数据!!");
        return;
    }
    SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
    String title = teamId + "-" + sdf.format(new Date());
    log.info(title);
    String[] rowsName = new String[] { "玩家ID", "玩家名称", "原始战绩", "战绩", "保险", "回水", "回保", "场次" };
    List<Object[]> dataList = new ArrayList<Object[]>();
    Object[] objs = null;
    for (ProxyTeamInfo info : list) {
        objs = new Object[rowsName.length];
        objs[0] = info.getProxyPlayerId();
        objs[1] = info.getProxyPlayerName();
        objs[2] = info.getProxyYSZJ();
        objs[3] = info.getProxyZJ();
        objs[4] = info.getProxyBaoxian();
        objs[5] = info.getProxyHuishui();
        objs[6] = info.getProxyHuiBao();
        objs[7] = info.getProxyTableId();
        dataList.add(objs);
    }
    String[] rowsName2 = new String[] { "合计", "0" };
    List<Object[]> sumList = new ArrayList<>();
    Object[] sumObjs = null;
    ObservableList<ProxySumInfo> ob_List = tableProxySum.getItems();
    // if(ob_List != null && ob_List.size() > 0) {
    // for(ProxySumInfo info : ob_List) {
    // sumObjs= new Object[rowsName2.length];
    // sumObjs[0] = info.getProxySumType();
    // sumObjs[1] = info.getProxySum();
    // sumList.add(sumObjs);
    // }
    // String sum = tableProxySum.getColumns().get(1).getText();
    // rowsName2[1] = sum;
    // }
    List<String> baoxianFilters = getHejiFilters();
    if (CollectUtil.isHaveValue(ob_List)) {
        for (ProxySumInfo info : ob_List) {
            if (!baoxianFilters.contains(info.getProxySumType())) {
                sumObjs = new Object[rowsName2.length];
                sumObjs[0] = info.getProxySumType();
                sumObjs[1] = info.getProxySum();
                sumList.add(sumObjs);
            }
        }
        String sum = getExportHejiSum(ob_List, baoxianFilters);
        rowsName2[1] = sum;
    }
    String out = getOutPath(title, rowsName2[1]);
    ExportExcel ex = new ExportExcel(teamId, time, isManage, title, rowsName, dataList, out, rowsName2, sumList);
    try {
        ex.export();
        log.info("代理查询导出成功");
    } catch (Exception e) {
        ErrorUtil.err("代理查询导出失败", e);
    }
}
Also used : ExportExcel(com.kendy.excel.ExportExcel) ProxyTeamInfo(com.kendy.entity.ProxyTeamInfo) ArrayList(java.util.ArrayList) Date(java.util.Date) ProxySumInfo(com.kendy.entity.ProxySumInfo) SimpleDateFormat(java.text.SimpleDateFormat)

Example 2 with ProxySumInfo

use of com.kendy.entity.ProxySumInfo in project financial by greatkendy123.

the class TeamProxyService method exportExcel_with_no_teamBaoxianRate.

/**
 * 导出有团队保险比例的Excel
 * @time 2018年2月8日
 */
public static void exportExcel_with_no_teamBaoxianRate() {
    String teamId = teamIDCombox.getSelectionModel().getSelectedItem();
    boolean isManage = isZjManage.isSelected();
    String time = DataConstans.Date_Str;
    if (StringUtil.isBlank(teamId)) {
        ShowUtil.show("导出失败! 请先选择团队ID!!");
        return;
    }
    if (StringUtil.isBlank(time)) {
        ShowUtil.show("导出失败! 您今天还没导入01场次的战绩,无法确认时间!!");
        return;
    }
    List<ProxyTeamInfo> list = new ArrayList<>();
    ObservableList<ProxyTeamInfo> obList = tableProxyTeam.getItems();
    if (obList != null && obList.size() > 0) {
        for (ProxyTeamInfo info : obList) {
            list.add(info);
        }
    } else {
        ShowUtil.show("没有需要导出的数据!!");
        return;
    }
    SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
    String title = teamId + "-" + sdf.format(new Date());
    log.info(title);
    // String[] rowsName = new String[]{"玩家ID","玩家名称","原始战绩","战绩","保险","回水","回保","场次"};
    String[] rowsName = new String[] { "玩家ID", "玩家名称", "原始战绩", "战绩", "回水", "场次" };
    List<Object[]> dataList = new ArrayList<Object[]>();
    Object[] objs = null;
    for (ProxyTeamInfo info : list) {
        objs = new Object[rowsName.length];
        objs[0] = info.getProxyPlayerId();
        objs[1] = info.getProxyPlayerName();
        objs[2] = info.getProxyYSZJ();
        objs[3] = info.getProxyZJ();
        // objs[4] = info.getProxyBaoxian();
        objs[5 - 1] = info.getProxyHuishui();
        // objs[6] = info.getProxyHuiBao();
        objs[7 - 2] = info.getProxyTableId();
        dataList.add(objs);
    }
    String[] rowsName2 = new String[] { "合计", "0" };
    List<Object[]> sumList = new ArrayList<>();
    Object[] sumObjs = null;
    ObservableList<ProxySumInfo> ob_List = tableProxySum.getItems();
    List<String> baoxianFilters = getHejiFilters();
    if (CollectUtil.isHaveValue(ob_List)) {
        for (ProxySumInfo info : ob_List) {
            if (!baoxianFilters.contains(info.getProxySumType())) {
                sumObjs = new Object[rowsName2.length];
                sumObjs[0] = info.getProxySumType();
                sumObjs[1] = info.getProxySum();
                sumList.add(sumObjs);
            }
        }
        String sum = getExportHejiSum(ob_List, baoxianFilters);
        rowsName2[1] = sum;
    }
    String out = getOutPath(title, rowsName2[1]);
    ExportExcel ex = new ExportExcel(teamId, time, isManage, title, rowsName, dataList, out, rowsName2, sumList);
    try {
        ex.export();
        log.info("代理查询导出成功");
    } catch (Exception e) {
        ErrorUtil.err("代理查询导出失败", e);
    }
}
Also used : ExportExcel(com.kendy.excel.ExportExcel) ProxyTeamInfo(com.kendy.entity.ProxyTeamInfo) ArrayList(java.util.ArrayList) Date(java.util.Date) ProxySumInfo(com.kendy.entity.ProxySumInfo) SimpleDateFormat(java.text.SimpleDateFormat)

Example 3 with ProxySumInfo

use of com.kendy.entity.ProxySumInfo in project financial by greatkendy123.

the class MyController method initialize.

/**
 * 节点加载完后需要进行的一些初始化操作
 * Initializes the controller class. This method is automatically called
 * after the fxml file has been loaded.
 */
@SuppressWarnings("unchecked")
@Override
public void initialize(URL location, ResourceBundle resources) {
    table_Profit = this.tableProfit;
    // 第一次打开主窗口时设置当前俱乐部ID值
    String clubIdValue = PropertiesUtil.readProperty("clubId");
    currentClubId = lable_currentClubId;
    if (clubIdValue != null)
        lable_currentClubId.setText(clubIdValue);
    // 第一次打开主窗口时显示所有股东
    // //股东
    String gudongs = PropertiesUtil.readProperty("gudong");
    DataConstans.gudongList = new ArrayList<>();
    if (!StringUtil.isBlank(gudongs)) {
        for (String gudong : gudongs.split(",")) {
            DataConstans.gudongList.add(gudong);
        }
    }
    for (String gd : DataConstans.gudongList) gudongListView.getItems().add(gd);
    // 模拟初始化第一个tableView
    // kendy:绑定数据域
    // 支付按钮
    pay.setCellFactory(cellFactory);
    // 绑定玩家信息表
    bindCellValue(tuan, wanjiaId, wanjia, jifen, shishou, baoxian, chuHuishui, baohui, shuihouxian, heLirun, shouHuishui);
    jifen.setCellFactory(getColorCellFactory(new TotalInfo()));
    shishou.setCellFactory(getColorCellFactory(new TotalInfo()));
    baoxian.setCellFactory(getColorCellFactory(new TotalInfo()));
    shuihouxian.setCellFactory(getColorCellFactory(new TotalInfo()));
    chuHuishui.setCellFactory(getColorCellFactory(new TotalInfo()));
    // 绑定牌局表
    bindCellValue(paiju, wanjiaName, zhangji, yicunJifen, heji);
    // 支付按钮:单独出来
    pay.setCellFactory(cellFactory);
    pay.setStyle("-fx-alignment: CENTER;");
    // 复制按钮:单独出来
    copy.setCellFactory(cellFactoryCopy);
    copy.setStyle("-fx-alignment: CENTER;");
    zhangji.setCellFactory(getColorCellFactory(new WanjiaInfo()));
    yicunJifen.setCellFactory(getColorCellFactory(new WanjiaInfo()));
    heji.setCellFactory(getColorCellFactory(new WanjiaInfo()));
    // 绑定实时金额表
    tableCurrentMoneyInfo.setEditable(true);
    bindCellValue(cmSuperIdSum, mingzi, shishiJine, cmiEdu);
    cmSuperIdSum.setStyle("-fx-alignment: CENTER;-fx-font-weight: bold;");
    shishiJine.setCellFactory(TextFieldTableCell.forTableColumn());
    // shishiJine.setCellFactory(redAndEditCellFactory);
    shishiJine.setOnEditCommit(new EventHandler<CellEditEvent<CurrentMoneyInfo, String>>() {

        @Override
        public void handle(CellEditEvent<CurrentMoneyInfo, String> t) {
            String oldValue = t.getOldValue();
            // 修改原值
            CurrentMoneyInfo cmInfo = (CurrentMoneyInfo) t.getTableView().getItems().get(t.getTablePosition().getRow());
            if (cmInfo != null && !StringUtil.isBlank(cmInfo.getMingzi())) {
                // 更新到已存积分
                boolean isChangedOK = MoneyService.changeYicunJifen(tablePaiju, cmInfo.getMingzi(), t.getNewValue());
                if (isChangedOK) {
                    cmInfo.setShishiJine(t.getNewValue());
                } else {
                    cmInfo.setShishiJine(t.getOldValue());
                    String ss = t.getTableView().getItems().get(t.getTablePosition().getRow()).getShishiJine();
                    tableCurrentMoneyInfo.refresh();
                }
                // 最后刷新实时金额表
                MoneyService.flush_SSJE_table();
            } else if (cmInfo != null) {
                cmInfo.setShishiJine(null);
                ShowUtil.show("空行不能输入", 1);
                tableCurrentMoneyInfo.refresh();
            }
        }
    });
    // 绑定资金表
    tableZijin.setEditable(true);
    bindCellValue(zijinType, zijinAccount);
    // zijinAccount.setCellFactory(TextFieldTableCell.forTableColumn());
    zijinType.setCellFactory(zijinCellFactory);
    zijinAccount.setCellFactory(getColorCellFactory(new ZijinInfo()));
    // 绑定利润表
    bindCellValue(profitType, profitAccount);
    profitAccount.setCellFactory(getColorCellFactory(new ProfitInfo()));
    // 绑定实时开销表
    bindCellValue(kaixiaoType, kaixiaoMoney);
    kaixiaoMoney.setCellFactory(getColorCellFactory(new KaixiaoInfo()));
    // 绑定实时当局表
    bindCellValue(type, money);
    money.setCellFactory(getColorCellFactory(new DangjuInfo()));
    // 绑定交收表
    bindCellValue(jiaoshouType, jiaoshouMoney);
    jiaoshouMoney.setCellFactory(getColorCellFactory(new JiaoshouInfo()));
    // 绑定平帐表
    bindCellValue(pingzhangType, pingzhangMoney);
    pingzhangMoney.setCellFactory(getColorCellFactory(new PingzhangInfo()));
    // 绑定团队表
    bindCellValue(teamID, teamZJ, teamHS, teamBS, teamSum);
    teamJiesuan.setCellFactory(cellFactoryJiesuan);
    teamJiesuan.setStyle("-fx-alignment: CENTER;");
    teamZJ.setCellFactory(getColorCellFactory(new TeamInfo()));
    teamBS.setCellFactory(getColorCellFactory(new TeamInfo()));
    teamHS.setCellFactory(getColorCellFactory(new TeamInfo()));
    teamSum.setCellFactory(getColorCellFactory(new TeamInfo()));
    // 绑定代理查询表(团队当天查询)
    bindCellValue(proxyPlayerId, proxyPlayerName, proxyYSZJ, proxyZJ, proxyBaoxian, proxyHuishui, proxyHuiBao, proxyTableId);
    proxyYSZJ.setCellFactory(getColorCellFactory(new ProxyTeamInfo()));
    proxyZJ.setCellFactory(getColorCellFactory(new ProxyTeamInfo()));
    proxyBaoxian.setCellFactory(getColorCellFactory(new ProxyTeamInfo()));
    // 绑定代理查询中的合计表
    bindCellValue(proxySumType, proxySum);
    proxySum.setCellFactory(getColorCellFactory(new ProxySumInfo()));
    // 绑定汇总信息表(当天每一局的团队汇总查询)
    bindCellValue(zonghuiTabelId, zonghuiFuwufei, zonghuiBaoxian, zonghuiHuishui, zonghuiHuiBao);
    zonghuiBaoxian.setCellFactory(getColorCellFactory(new ZonghuiInfo()));
    zonghuiHuishui.setCellFactory(getColorCellFactory(new ZonghuiInfo()));
    zonghuiHuiBao.setCellFactory(getColorCellFactory(new ZonghuiInfo()));
    // 绑定汇总查询中的当天汇总表
    bindCellValue(huizongType, huizongMoney);
    huizongMoney.setCellFactory(getColorCellFactory(new DangtianHuizongInfo()));
    // 绑定汇总查询中的开销表表
    bindCellValue(zonghuiKaixiaoType, zonghuiKaixiaoMoney);
    zonghuiKaixiaoMoney.setCellFactory(getColorCellFactory(new ZonghuiKaixiaoInfo()));
    // 绑定会员查询中的会员当天战绩表
    bindCellValue(memberJu, memberZJ);
    memberZJ.setCellFactory(getColorCellFactory(new MemberZJInfo()));
    // 绑定实时上码表
    // ,shangmaShishou,shangmaJu
    bindCellValue(shangmaLianheEdu, shangmaName, shangmaEdu, shangmaAvailableEdu, shangmaYCJF, shangmaYiSM, shangmaSumOfZJ, shangmaPlayerId);
    tableShangma.setRowFactory(new Callback<TableView<ShangmaInfo>, TableRow<ShangmaInfo>>() {

        @Override
        public TableRow<ShangmaInfo> call(TableView<ShangmaInfo> param) {
            return new TableRowControl(tableShangma);
        }
    });
    // shangmaPlayerId.setCellFactory(shangmaLeftNameCellFactory);
    // shangmaName.setCellFactory(shangmaLeftNameCellFactory);
    // shangmaEdu.setCellFactory(shangmaLeftNameCellFactory);
    // shangmaSumOfZJ.setCellFactory(shangmaLeftNameCellFactory);
    // shangmaYiSM.setCellFactory(shangmaLeftNameCellFactory);
    // shangmaYCJF.setCellFactory(shangmaLeftNameCellFactory);
    shangmaLianheEdu.setCellFactory(getColorCellFactory(new ShangmaInfo()));
    // red_NotEdit_CellFactory
    shangmaAvailableEdu.setCellFactory(getColorCellFactory(new ShangmaInfo()));
    shangmaYCJF.setCellFactory(getColorCellFactory(new ShangmaInfo()));
    // 绑定外债信息表
    bindCellValue(waizhaiType, waizhaiMoney);
    waizhaiMoney.setCellFactory(getColorCellFactory(new WaizhaiInfo()));
    // 绑定上码个人信息表
    tableShangmaDetail.setEditable(true);
    bindCellValue(shangmaDetailName, shangmaJu, shangmaSM, shangmaShishou);
    shangmaDetailName.setCellFactory(ShangmaNameCellFactory);
    shangmaJu.setCellFactory(ShangmaNameCellFactory);
    shangmaSM.setCellFactory(ShangmaNameCellFactory);
    shangmaShishou.setCellFactory(ShangmaNameCellFactory);
    tableShangma.getSelectionModel().selectedItemProperty().addListener(new ChangeListener() {

        @Override
        public void changed(ObservableValue observable, Object oldValue, Object newValue) {
            ShangmaInfo smInfo = (ShangmaInfo) newValue;
            // 加载右边的个人详情
            if (smInfo != null) {
                String playerId = smInfo.getShangmaPlayerId();
                if (!StringUtil.isBlank(playerId)) {
                    ShangmaService.loadSMDetailTable(playerId);
                    ShangmaService.loadSMNextDayTable(playerId);
                }
            } else
                tableShangmaDetail.setItems(null);
        }
    });
    // 绑定次日信息表
    shangmaNextDayName.setCellValueFactory(new PropertyValueFactory<ShangmaDetailInfo, String>("shangmaDetailName"));
    shangmaNextDayName.setCellFactory(ShangmaNameNextdayCellFactory);
    shangmaNextDayName.setStyle("-fx-alignment: CENTER;");
    shangmaNextDayJu.setCellValueFactory(new PropertyValueFactory<ShangmaDetailInfo, String>("shangmaJu"));
    shangmaNextDayJu.setCellFactory(ShangmaNameNextdayCellFactory);
    shangmaNextDayJu.setStyle("-fx-alignment: CENTER;");
    shangmaNextDaySM.setCellValueFactory(new PropertyValueFactory<ShangmaDetailInfo, String>("shangmaSM"));
    shangmaNextDaySM.setCellFactory(ShangmaNameNextdayCellFactory);
    shangmaNextDaySM.setStyle("-fx-alignment: CENTER;");
    // 绑定积查询表
    bindCellValue(jfRank, jfPlayerName, jfValue);
    // ////初始化实时金额表
    MoneyService.iniitMoneyInfo(tableCurrentMoneyInfo);
    // tableTotalInfo.setItems(tableTotalInfoList);
    // tableKaixiao.setItems(FXCollections.observableArrayList(
    // new KaixiaoInfo("测试列","12")
    // ));
    // //////////////////总汇表中的初始化
    juTypeListView.getItems().add("合局");
    LMLabel.setTextFill(Color.web("#CD3700"));
    // 设置Label 的文本颜色。
    indexLabel.setTextFill(Color.web("#0076a3"));
    indexLabel.setFont(new Font("Arial", 30));
    // //////////////////代理查询中的团队回水选择
    TeamProxyService.initTeamProxy(tableProxyTeam, proxySumHBox, teamIDCombox, isZjManage, proxyDateLabel, tableProxySum, proxyHSRate, proxyHBRate, proxyFWF, hasTeamBaoxian);
    // //////////////////代理查询中的团队回水选择
    TeamProxyService.initTeamSelectAction(teamIDCombox, isZjManage, tableProxyTeam, proxySumHBox);
    // //////////////////会员服务类
    MemberService.initMemberQuery(memberListView, tableMemberZJ, memberDateStr, memberPlayerId, memberPlayerName, memberSumOfZJ, memberTotalZJ);
    tabsAction();
    // //////////////////实时上马系统
    initShanagma();
    // /////////////合并ID
    CombineIDController.initCombineIdController(tableCurrentMoneyInfo);
    // //////////积分查询
    JifenService.initJifenService(jfTeamIDCombox);
    // 是否启动测试模式
    initAutoTestMode();
    // 选择导入白名单的版本
    initWhiteVersion();
    try {
        FXMLLoader loader = new FXMLLoader();
        Parent root = loader.load(getClass().getResource("/com/kendy/dialog/LM_Tab_Fram.fxml").openStream());
        // loader.setController(lmController);
        lmController = loader.getController();
        Tab tab1 = new Tab();
        tab1.setText("联盟对账");
        tab1.setClosable(false);
        tab1.setContent(root);
        tabs.getTabs().add(tab1);
    } catch (IOException e) {
        ErrorUtil.err("联盟tab加载失败", e);
    }
    try {
        FXMLLoader loader = new FXMLLoader();
        Parent root = loader.load(getClass().getResource("/com/kendy/dialog/Quota_Tab_Fram.fxml").openStream());
        loader.setController(new QuotaController());
        Tab quotaTab = new Tab();
        quotaTab.setText("联盟配账");
        quotaTab.setClosable(false);
        quotaTab.setContent(root);
        tabs.getTabs().add(quotaTab);
    } catch (IOException e) {
        ErrorUtil.err("联盟配账tab加载失败", e);
    }
    try {
        FXMLLoader loader = new FXMLLoader();
        Parent root = loader.load(getClass().getResource("/com/kendy/dialog/gudong_contribution.fxml").openStream());
        loader.setController(new GDController());
        Tab gdTab = new Tab();
        gdTab.setText("股东贡献值");
        gdTab.setClosable(false);
        gdTab.setContent(root);
        tabs.getTabs().add(gdTab);
    } catch (IOException e) {
        ErrorUtil.err("股东贡献值tab加载失败", e);
    }
    try {
        FXMLLoader loader = new FXMLLoader();
        Parent root = loader.load(getClass().getResource("/com/kendy/dialog/TG_toolaa.fxml").openStream());
        Tab gdTab = new Tab();
        gdTab.setText("托管工具");
        gdTab.setClosable(false);
        gdTab.setContent(root);
        tabs.getTabs().add(gdTab);
        tgController = (TGController) loader.getController();
    } catch (IOException e) {
        ErrorUtil.err("托管小工具tab加载失败", e);
    }
    try {
        FXMLLoader loader = new FXMLLoader();
        Parent root = loader.load(getClass().getResource("/com/kendy/dialog/SM_Auto.fxml").openStream());
        Tab gdTab = new Tab();
        gdTab.setText("自动上码配置");
        gdTab.setClosable(false);
        gdTab.setContent(root);
        tabs.getTabs().add(gdTab);
        smAutoController = (SMAutoController) loader.getController();
    } catch (IOException e) {
        ErrorUtil.err("托管小工具tab加载失败", e);
    }
}
Also used : ProxyTeamInfo(com.kendy.entity.ProxyTeamInfo) QuotaController(com.kendy.controller.QuotaController) JiaoshouInfo(com.kendy.entity.JiaoshouInfo) WaizhaiInfo(com.kendy.entity.WaizhaiInfo) Parent(javafx.scene.Parent) KaixiaoInfo(com.kendy.entity.KaixiaoInfo) ZonghuiKaixiaoInfo(com.kendy.entity.ZonghuiKaixiaoInfo) ObservableValue(javafx.beans.value.ObservableValue) ShangmaDetailInfo(com.kendy.entity.ShangmaDetailInfo) CurrentMoneyInfo(com.kendy.entity.CurrentMoneyInfo) FXMLLoader(javafx.fxml.FXMLLoader) GDController(com.kendy.controller.GDController) Font(javafx.scene.text.Font) ProfitInfo(com.kendy.entity.ProfitInfo) ProxySumInfo(com.kendy.entity.ProxySumInfo) DangtianHuizongInfo(com.kendy.entity.DangtianHuizongInfo) WanjiaInfo(com.kendy.entity.WanjiaInfo) ZonghuiKaixiaoInfo(com.kendy.entity.ZonghuiKaixiaoInfo) ChangeListener(javafx.beans.value.ChangeListener) PingzhangInfo(com.kendy.entity.PingzhangInfo) TableView(javafx.scene.control.TableView) ShangmaInfo(com.kendy.entity.ShangmaInfo) ZonghuiInfo(com.kendy.entity.ZonghuiInfo) DangjuInfo(com.kendy.entity.DangjuInfo) ProxyTeamInfo(com.kendy.entity.ProxyTeamInfo) TeamInfo(com.kendy.entity.TeamInfo) IOException(java.io.IOException) CellEditEvent(javafx.scene.control.TableColumn.CellEditEvent) ZijinInfo(com.kendy.entity.ZijinInfo) Tab(javafx.scene.control.Tab) TotalInfo(com.kendy.entity.TotalInfo) TableRow(javafx.scene.control.TableRow) MemberZJInfo(com.kendy.entity.MemberZJInfo)

Example 4 with ProxySumInfo

use of com.kendy.entity.ProxySumInfo in project financial by greatkendy123.

the class TeamProxyService method refresh_TableTeamProxy_TableProxySum.

/**
 * 刷新两个表,共用代码(选择团下拉框和点击刷新按钮时共用的代码)
 *
 * @param newValue teamID
 */
public static void refresh_TableTeamProxy_TableProxySum(Object newValue) {
    if (newValue == null)
        return;
    Huishui hs = DataConstans.huishuiMap.get(newValue);
    if (hs != null) {
        if ("否".equals(hs.getZjManaged())) {
            isZjManage.setSelected(false);
        } else {
            isZjManage.setSelected(true);
        }
    } else {
        // add 2018-01-20
        return;
    }
    // 加载数据{teamId={}}
    double sumYSZJ = 0d;
    double sumZJ = 0d;
    double sumHS = 0d;
    double sumHB = 0d;
    double sumBX = 0d;
    int sumRC = 0;
    // Map<String,List<TeamHuishuiInfo>> teamMap = DataConstans.Total_Team_Huishui_Map;//锁定就保留信息,不减
    Map<String, List<TeamHuishuiInfo>> teamMap = getTotalTeamHuishuiMap();
    if (teamMap != null && teamMap.size() == 0) {
        // 这个有问题,后期再看
        log.error("----------------");
    }
    List<TeamHuishuiInfo> teamList = teamMap.get(newValue.toString().toUpperCase());
    ObservableList<ProxyTeamInfo> obList = FXCollections.observableArrayList();
    if (teamList != null) {
        for (TeamHuishuiInfo info : teamList) {
            obList.add(new ProxyTeamInfo(info.getTuan(), info.getWanjiaId(), info.getWanjia(), // yszj
            info.getZj(), info.getShishou(), // 出回水是否等于回水
            MoneyService.getNum(info.getChuHuishui()) * (-1) + "", // 保险是否等于回保
            info.getHuibao(), info.getTableId(), // 保险
            info.getBaoxian()));
            sumYSZJ += MoneyService.getNum(info.getZj());
            sumZJ += MoneyService.getNum(info.getShishou());
            sumBX += MoneyService.getNum(info.getBaoxian());
            sumHS += (MoneyService.getNum(info.getChuHuishui())) * (-1);
            sumHB += MoneyService.getNum(info.getHuibao());
            sumRC += 1;
        }
    }
    tableProxyTeam.setItems(obList);
    tableProxyTeam.refresh();
    ObservableList<Node> sumHBox = proxySumHBox.getChildren();
    for (Node node : sumHBox) {
        Label label = (Label) node;
        String labelId = label.getId();
        switch(labelId) {
            case "sumYSZJ":
                label.setText(MoneyService.digit0(sumYSZJ));
                break;
            case "sumZJ":
                label.setText(MoneyService.digit0(sumZJ));
                break;
            case "sumBX":
                label.setText(MoneyService.digit0(sumBX));
                break;
            case "sumHS":
                label.setText(MoneyService.digit1(sumHS + ""));
                break;
            case "sumHB":
                label.setText(sumHB + "");
                break;
            case "sumRC":
                label.setText(sumRC + "");
                break;
        }
    }
    // add by kendy 添加总回保比例,总回水比例,服务费和合计
    proxyHSRate.setText(hs.getProxyHSRate());
    proxyHBRate.setText(hs.getProxyHBRate());
    proxyFWF.setText(hs.getProxyFWF());
    double HSRate = getNumByPercent(hs.getProxyHSRate());
    double HBRate = getNumByPercent(hs.getProxyHBRate());
    // 服务费有效值
    double FWFValid = NumUtil.getNum(hs.getProxyFWF());
    // 计算服务费
    double proxyFWFVal = calculateProxSumFWF(sumHS, HSRate, sumHB, HBRate, FWFValid);
    // 计算合计
    double proxyHeji = sumZJ + sumHS + sumHB - proxyFWFVal;
    // 初始化合计表
    tableProxySum.setItems(null);
    ObservableList<ProxySumInfo> ob_Heji_List = FXCollections.observableArrayList();
    ob_Heji_List.addAll(new ProxySumInfo("总战绩", NumUtil.digit0(sumZJ)), new ProxySumInfo("总回水", NumUtil.digit1(sumHS + "")), new ProxySumInfo("总回保", NumUtil.digit1(sumHB + "")), new ProxySumInfo("服务费", NumUtil.digit1(proxyFWFVal + "")), new ProxySumInfo("总人次", sumRC + ""));
    tableProxySum.setItems(ob_Heji_List);
    tableProxySum.getColumns().get(1).setText(NumUtil.digit1(proxyHeji + ""));
    tableProxySum.refresh();
}
Also used : Huishui(com.kendy.entity.Huishui) ProxyTeamInfo(com.kendy.entity.ProxyTeamInfo) Node(javafx.scene.Node) Label(javafx.scene.control.Label) TeamHuishuiInfo(com.kendy.entity.TeamHuishuiInfo) ProxySumInfo(com.kendy.entity.ProxySumInfo) ArrayList(java.util.ArrayList) List(java.util.List) ObservableList(javafx.collections.ObservableList)

Aggregations

ProxySumInfo (com.kendy.entity.ProxySumInfo)4 ProxyTeamInfo (com.kendy.entity.ProxyTeamInfo)4 ArrayList (java.util.ArrayList)3 ExportExcel (com.kendy.excel.ExportExcel)2 SimpleDateFormat (java.text.SimpleDateFormat)2 Date (java.util.Date)2 GDController (com.kendy.controller.GDController)1 QuotaController (com.kendy.controller.QuotaController)1 CurrentMoneyInfo (com.kendy.entity.CurrentMoneyInfo)1 DangjuInfo (com.kendy.entity.DangjuInfo)1 DangtianHuizongInfo (com.kendy.entity.DangtianHuizongInfo)1 Huishui (com.kendy.entity.Huishui)1 JiaoshouInfo (com.kendy.entity.JiaoshouInfo)1 KaixiaoInfo (com.kendy.entity.KaixiaoInfo)1 MemberZJInfo (com.kendy.entity.MemberZJInfo)1 PingzhangInfo (com.kendy.entity.PingzhangInfo)1 ProfitInfo (com.kendy.entity.ProfitInfo)1 ShangmaDetailInfo (com.kendy.entity.ShangmaDetailInfo)1 ShangmaInfo (com.kendy.entity.ShangmaInfo)1 TeamHuishuiInfo (com.kendy.entity.TeamHuishuiInfo)1