Examples with KaixiaoInfo com.kendy.entity.KaixiaoInfo used on opensource projects

Example 6 with KaixiaoInfo

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

the class DBUtil method get_all_gudong_kaixiao.

/**
 * 获取所有股东开销
 *
 * @time 2018年2月21日
 * @return
 */
public static List<KaixiaoInfo> get_all_gudong_kaixiao() {
    List<KaixiaoInfo> list = new ArrayList<>();
    try {
        con = DBConnection.getConnection();
        String sql = "select * from gudong_kaixiao";
        ps = con.prepareStatement(sql);
        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            KaixiaoInfo kaixiao = new KaixiaoInfo(rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5));
            list.add(kaixiao);
        }
    } catch (SQLException e) {
        ErrorUtil.err("获取所有股东开销失败", e);
    } finally {
        close(con, ps);
    }
    return list;
}

Example 7 with KaixiaoInfo

use of com.kendy.entity.KaixiaoInfo 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);
    }
}

Example 8 with KaixiaoInfo

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

the class MyController method delKaixiaoAction.

/**
 * 删除实时开销按钮
 */
public void delKaixiaoAction(ActionEvent event) {
    int kaixiaoIndex = tableKaixiao.getSelectionModel().getFocusedIndex();
    KaixiaoInfo info = tableKaixiao.getSelectionModel().getSelectedItem();
    if (info != null) {
        Alert alert = new Alert(AlertType.CONFIRMATION);
        alert.setTitle("提示");
        alert.setHeaderText(null);
        alert.setContentText("实时开销名称：" + info.getKaixiaoType() + " 金额：" + info.getKaixiaoMoney() + "\r\n你确定要删除所选中的开销记录吗?");
        Optional<ButtonType> result = alert.showAndWait();
        if (result.get() == ButtonType.OK) {
            tableKaixiao.getItems().remove(kaixiaoIndex);
            tableKaixiao.refresh();
            // 删除数据库中的开销数据
            String kaixiaoID = info.getKaixiaoID();
            String kaixiaoGudong = info.getKaixiaoGudong();
            if (!StringUtil.isAnyBlank(kaixiaoID, kaixiaoGudong)) {
                DBUtil.del_gudong_kaixiao_by_id(kaixiaoID);
            }
        }
    } else {
        ShowUtil.show("请选中要删除的实时开销记录!");
        return;
    }
}

Example 9 with KaixiaoInfo

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

the class AddController method addKaixiaoOKAction.

/**
 * 增加开销
 */
public void addKaixiaoOKAction(ActionEvent event) {
    if (!StringUtil.isBlank(kaixiaoTypes.getText())) {
        DataConstans.kaixiaoMap.put(kaixiaoTypes.getText(), kaixiaoMoneys.getText());
        ShowUtil.show("添加开销成功", 2);
        // 更新到表
        MyController mc = Main.myController;
        if (mc != null) {
            String kxGudong = gudongChoice.getSelectionModel().getSelectedItem();
            boolean isGudongEmpty = StringUtil.isBlank(kxGudong);
            String kaixiaoID = isGudongEmpty ? "" : UUID.randomUUID().toString().replace("-", "");
            String kaixiaoTime = StringUtil.nvl(DataConstans.Date_Str, "2017-01-01");
            String kxType = kaixiaoTypes.getText();
            String kxMoney = StringUtil.nvl(kaixiaoMoneys.getText(), "");
            KaixiaoInfo kaixiaoInfo = new KaixiaoInfo(kaixiaoID, kxType, kxMoney, kxGudong, kaixiaoTime);
            // 添加到场次信息中的开销表(若股东为空，则ID为空)
            mc.updateKaixiaoTable(kaixiaoInfo);
            // 添加到数据库中（如果股东不为空）
            if (!StringUtil.isAnyBlank(kxMoney, kxGudong)) {
                if (ALL_COMPANY.equals(kxGudong)) {
                    // N个股东平摊（包括银河股东）
                    ObservableList<String> gudongList = MyController.getGudongList();
                    // 股东平摊的开销值
                    String averageKaixiaoMoney = getAverageKaixiaoMoney(kxMoney, gudongList.size());
                    // 有几个股东就保存几条开销记录进数据库
                    int i = 0;
                    for (String gudongName : gudongList) {
                        // 共用一个开销ID, 从0编写到N
                        kaixiaoID = kaixiaoID + "#" + (i++);
                        KaixiaoInfo averageInfo = new KaixiaoInfo(kaixiaoID, kxType, averageKaixiaoMoney, gudongName, kaixiaoTime);
                        DBUtil.saveOrUpdate_gudong_kaixiao(averageInfo);
                    }
                } else {
                    DBUtil.saveOrUpdate_gudong_kaixiao(kaixiaoInfo);
                }
            // 缓存？ TODO
            }
        } else {
            log.info("===========================mc = null ");
        }
    }
    // 获取到新增人员窗口的实例
    Stage addNewPlayerStage = DataConstans.framesNameMap.get(Constants.ADD_KAIXIAO_FRAME);
    DataConstans.framesNameMap.remove(Constants.ADD_KAIXIAO_FRAME);
    addNewPlayerStage.close();
}

Example 10 with KaixiaoInfo

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

the class GDController method dynamicGenerateGDTable.

/**
 * 生成动态股东表
 *
 * @time 2018年1月20日
 */
private void dynamicGenerateGDTable() {
    // 股东列表
    Set<String> gudongSet = gudongTeamMap.keySet();
    List<String> _gudongList = new ArrayList<>(gudongSet);
    Collections.sort(_gudongList);
    TableView<GudongRateInfo> table;
    ObservableList<GudongRateInfo> obList = FXCollections.observableArrayList();
    for (String gudongName : _gudongList) {
        table = new TableView<GudongRateInfo>();
        // 设置列
        TableColumn firstNameCol = new TableColumn("股东" + gudongName);
        firstNameCol.setStyle("-fx-alignment: CENTER;");
        firstNameCol.setPrefWidth(100);
        firstNameCol.setCellValueFactory(new PropertyValueFactory<GudongRateInfo, String>("gudongName"));
        TableColumn lastNameCol = new TableColumn("0%");
        lastNameCol.setStyle("-fx-alignment: CENTER;");
        lastNameCol.setPrefWidth(92);
        lastNameCol.setCellValueFactory(new PropertyValueFactory<GudongRateInfo, String>("gudongProfit"));
        lastNameCol.setCellFactory(MyController.getColorCellFactory(new GudongRateInfo()));
        table.setPrefWidth(210);
        TableColumn tempValCol = new TableColumn("0");
        tempValCol.setStyle("-fx-alignment: CENTER;");
        tempValCol.setPrefWidth(60);
        tempValCol.setCellValueFactory(new PropertyValueFactory<GudongRateInfo, String>("description"));
        tempValCol.setCellFactory(MyController.getColorCellFactory(new GudongRateInfo()));
        table.setPrefWidth(210 + 60);
        table.getColumns().addAll(firstNameCol, lastNameCol, tempValCol);
        // 设置数据
        // {团队ID:List<Record}
        Map<String, List<Record>> teamMap = gudongTeamMap.get(gudongName);
        List<KaixiaoInfo> kaixiaoList = gudongKaixiaoMap.get(gudongName);
        setDynamicTableData(table, teamMap, kaixiaoList, gudongName);
        // 往左边的股东表中添加记录
        setDataToSumTable(table);
        contributionHBox.setSpacing(5);
        contributionHBox.setPadding(new Insets(0, 0, 0, 0));
        contributionHBox.getChildren().addAll(table);
    }
}