ContractServiceImpl.java 95.3 KB
Newer Older
manxiaoqiang committed
1 2
package common.service.impl;

manxiaoqiang committed
3 4
import adi.model.ADIUser;
import adi.service.ADIAccountService;
manxiaoqiang committed
5 6
import common.model.*;
import common.repository.*;
kangxiaoshan committed
7
import common.service.AuthService;
manxiaoqiang committed
8
import common.service.ContractService;
kangxiaoshan committed
9
import common.service.TransactionUtils;
manxiaoqiang committed
10 11 12 13
import common.service.UserService;
import dic.ContractStatusEnum;
import dic.ContractTypeEnum;
import dic.RoleEnum;
kangxiaoshan committed
14
import net.sf.json.JSONArray;
kangxiaoshan committed
15
import org.apache.poi.ss.usermodel.*;
kangxiaoshan committed
16
import org.joda.time.DateTime;
17
import org.joda.time.Days;
kangxiaoshan committed
18
import org.joda.time.format.DateTimeFormat;
kangxiaoshan committed
19 20
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
manxiaoqiang committed
21
import org.springframework.beans.factory.annotation.Autowired;
kangxiaoshan committed
22
import org.springframework.jdbc.core.JdbcTemplate;
manxiaoqiang committed
23
import org.springframework.stereotype.Service;
kangxiaoshan committed
24
import org.springframework.util.StringUtils;
kangxiaoshan committed
25
import org.springframework.web.multipart.MultipartFile;
manxiaoqiang committed
26 27
import tkio.model.Account;
import tkio.model.IncrementFlow;
manxiaoqiang committed
28
import tkio.model.PackageType;
manxiaoqiang committed
29 30
import tkio.repository.AccountRepository;
import tkio.repository.IncrementFlowRepository;
manxiaoqiang committed
31
import tkio.repository.PackageTypeRepository;
manxiaoqiang committed
32
import tkio.service.AccountService;
manxiaoqiang committed
33 34 35
import tkio.service.TkioAccountService;
import userio.service.AccountIOService;
import userio.service.IOAccountService;
kangxiaoshan committed
36
import util.DateUtil;
1  
kangxiaoshan committed
37
import util.*;
manxiaoqiang committed
38 39 40 41 42

import java.beans.BeanInfo;
import java.beans.IntrospectionException;
import java.beans.Introspector;
import java.beans.PropertyDescriptor;
kangxiaoshan committed
43
import java.io.InputStream;
manxiaoqiang committed
44 45
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
manxiaoqiang committed
46
import java.math.BigDecimal;
manxiaoqiang committed
47
import java.math.BigInteger;
1  
kangxiaoshan committed
48
import java.text.DateFormat;
49
import java.text.DecimalFormat;
1  
kangxiaoshan committed
50
import java.text.SimpleDateFormat;
manxiaoqiang committed
51
import java.util.*;
kangxiaoshan committed
52
import java.util.stream.Collectors;
manxiaoqiang committed
53 54 55 56 57

/**
 * Created by mxq on 2018/1/16.
 */
@Service
kangxiaoshan committed
58
public class ContractServiceImpl implements ContractService {
manxiaoqiang committed
59

kangxiaoshan committed
60

kangxiaoshan committed
61 62 63 64
    private static final Map<String, String> CONTRACT_TYPE = new HashMap() {{
        put("0", "首次签约");
        put("1", "续约");
        put("2", "合同变更");
kangxiaoshan committed
65 66 67
    }};
    private static final Map<String, String> CONTRACT_TYPE_NAME = new HashMap() {{
        put("首次签约", "0");
kangxiaoshan committed
68
        put("续签", "1");
kangxiaoshan committed
69
        put("补充协议", "2");
kangxiaoshan committed
70 71
    }};

kangxiaoshan committed
72 73 74 75 76
    public static final Map<String, String> FUNCTION_TYPE = new HashMap() {{
        put("1", "流量赠送");
        put("2", "合同变更记录");
        put("3", "收款/开票记录");
        put("4", "合同管理");
kangxiaoshan committed
77 78
    }};

kangxiaoshan committed
79 80 81 82 83 84 85 86 87 88 89 90 91 92 93
    private static final Map<String, String> SHEET_TITLE = new HashMap() {{
        put("我方签约主体", "my_body_name");
        put("客户签约主体", "customer_body");
        put("行业分类", "trade_type");
        put("合同金额", "money");
        put("客户主账号", "email");
        put("合同编号", "contract_code");
        put("签约类型", "contract_type");
        put("套餐", "price_level");
        put("合同类型", "type_id");
        put("合同开始日期", "start_date");
        put("合同结束日期", "end_date");
        put("签约销售", "sale");
    }};

1  
kangxiaoshan committed
94 95 96 97 98 99 100 101 102 103 104 105 106 107 108
    private static final Map<String, String> SHEET_TITLE_RESERVE = new HashMap() {{
        put("my_body_name", "我方签约主体");
        put("customer_body", "客户签约主体");
        put("trade_type", "行业分类");
        put("money", "合同金额");
        put("email", "客户主账号");
        put("contract_code", "合同编号");
        put("contract_type", "签约类型");
        put("price_level", "套餐");
        put("type_id", "合同类型");
        put("start_date", "合同开始日期");
        put("end_date", "合同结束日期");
        put("sale", "签约销售");
    }};

kangxiaoshan committed
109 110 111 112 113 114 115 116
    public static final String UPLOAD_TITLE = "我方签约主体,客户签约主体,行业分类,合同开始日期,合同结束日期," +
            "签约销售,客户主账号,合同编号,签约类型,套餐,合同金额";

    public static final Map<String, String> SHEET_NAMES = new HashMap() {{
        put("TrackingIO", "tkio");
        put("DMP", "dmp");
        put("防作弊卫士", "fake");
        put("ADI", "adi");
kangxiaoshan committed
117 118
        put("ADS", "ads");
        put("ABTEST", "abtest");
kangxiaoshan committed
119 120
    }};

kangxiaoshan committed
121
    public static final Map<String, String> SHEET_NAMES_RESERVE = new HashMap() {{
kangxiaoshan committed
122 123 124 125 126 127
        put("tkio", "TrackingIO");
        put("dmp", "DMP");
        put("fake", "防作弊卫士");
        put("adi", "ADI");
        put("ads", "ADS");
        put("abtest", "ABTEST");
kangxiaoshan committed
128 129
    }};

kangxiaoshan committed
130 131
    Logger logger = LoggerFactory.getLogger(ContractServiceImpl.class);

manxiaoqiang committed
132 133 134 135 136 137 138 139 140 141 142 143
    @Autowired
    ContractRepository contractRepository;
    @Autowired
    ContractBodyRepository contractBodyRepository;
    @Autowired
    Account4WebRepository account4WebRepository;
    @Autowired
    PackageTypeRepository packageTypeRepository;
    @Autowired
    PriceLevelMoneyRepository priceLevelMoneyRepository;
    @Autowired
    UserRepository userRepository;
manxiaoqiang committed
144 145 146 147
    @Autowired
    ContractChangeRepository contractChangeRepository;
    @Autowired
    ContractMoneyRepository contractMoneyRepository;
manxiaoqiang committed
148 149
    @Autowired
    AccountService accountService;
manxiaoqiang committed
150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165
    @Autowired
    AccountIOService accountIOService;
    @Autowired
    IOAccount4WebRepository ioAccount4WebRepository;
    @Autowired
    ContractIncrementRepository contractIncrementRepository;
    @Autowired
    TkioAccountService tkioAccountService;
    @Autowired
    IOAccountService ioAccountService;
    @Autowired
    AccountRepository accountRepository;
    @Autowired
    UserService userService;
    @Autowired
    IncrementFlowRepository incrementFlowRepository;
manxiaoqiang committed
166 167
    @Autowired
    BPUContractRepository bpuContractRepository;
168
    @Autowired
manxiaoqiang committed
169
    ADIAccountService adiAccountService;
manxiaoqiang committed
170

kangxiaoshan committed
171 172 173 174 175 176
    @Autowired
    TradeTypeRepsitory tradeTypeRepsitory;

    @Autowired
    ContractRelationRepository contractRelationRepository;

kangxiaoshan committed
177 178 179
    @Autowired
    FlowChangeRepository flowChangeRepository;

kangxiaoshan committed
180 181 182 183 184 185 186 187 188
    @Autowired
    ChangeDelDetailRepository changeDelDetailRepository;

    @Autowired
    ChangeDelInfoRepository changeDelInfoRepository;

    @Autowired
    SalesRepository salesRepository;

kangxiaoshan committed
189 190 191
    @Autowired
    PackageBaseRepository packageBaseRepository;

kangxiaoshan committed
192 193 194
    @Autowired
    AuthRepository authRepository;

kangxiaoshan committed
195 196 197
    @Autowired
    AuthService authService;

kangxiaoshan committed
198 199 200
    @Autowired
    JdbcTemplate jdbcTemplate;

kangxiaoshan committed
201 202 203 204
    @Autowired
    TransactionUtils transactionUtils;


manxiaoqiang committed
205
    @Override
manxiaoqiang committed
206
    public Map<String, Object> checkAccount(String email, String platfrom) {
manxiaoqiang committed
207
        Map<String, Object> map = new HashMap<>();
manxiaoqiang committed
208 209
        Account4Web account4Web = null;
        IOAccount4Web ioAccount4Web = null;
kangxiaoshan committed
210
        ADIUser adiUser = null;
kangxiaoshan committed
211 212
        platfrom = "tkio";

kangxiaoshan committed
213
        if ("tkio".equals(platfrom)) {
manxiaoqiang committed
214
            account4Web = account4WebRepository.findByEmail(email);
kangxiaoshan committed
215
        } else if ("io".equals(platfrom)) {
manxiaoqiang committed
216
            ioAccount4Web = ioAccount4WebRepository.findByEmail(email);
kangxiaoshan committed
217
        } else if ("adi".equals(platfrom)) {
manxiaoqiang committed
218
            adiUser = adiAccountService.findOne(email);
manxiaoqiang committed
219
        }
kangxiaoshan committed
220
        if (null == account4Web && null == ioAccount4Web && null == adiUser) {
manxiaoqiang committed
221
            map.put("result", 0);
kangxiaoshan committed
222 223
        } else {
            BigInteger integer = contractRepository.countNumByEmail(email, platfrom);
manxiaoqiang committed
224
            map.put("result", 1);
kangxiaoshan committed
225
            if (platfrom.equals("adi")) {
manxiaoqiang committed
226
                map.put("company", adiUser.getCompany());
kangxiaoshan committed
227
            } else {
manxiaoqiang committed
228 229 230
                map.put("company", null == account4Web ? ioAccount4Web.getCompany() : account4Web.getCompany());
            }

manxiaoqiang committed
231
            map.put("num", integer.intValue());
manxiaoqiang committed
232
            Contract contract = contractRepository.findByPlatformAndEmailLimitVaild(platfrom, email);
kangxiaoshan committed
233
            if (null == contract) {
manxiaoqiang committed
234
                map.put("status", false);
kangxiaoshan committed
235
            } else {
manxiaoqiang committed
236 237
                map.put("status", true);
            }
manxiaoqiang committed
238
        }
manxiaoqiang committed
239

manxiaoqiang committed
240 241 242
        return map;
    }

manxiaoqiang committed
243 244 245
    @Override
    public Boolean checkTime(String email, String platfrom, String type, String product) {
        Boolean flag = false;
kangxiaoshan committed
246
        if (ContractTypeEnum.MAIN.getKey().equals(type)) {
manxiaoqiang committed
247
            Contract contract = contractRepository.findByPlatformAndEmailLimit1(platfrom, email, type);
kangxiaoshan committed
248
            if (null == contract) {
manxiaoqiang committed
249
                flag = true;
kangxiaoshan committed
250
            } else {
manxiaoqiang committed
251
                String beforeDay = DateUtil.getBeforeDays(180);
kangxiaoshan committed
252
                if (beforeDay.compareTo(contract.getEndDate()) > 0) {
manxiaoqiang committed
253 254 255
                    flag = true;
                }
            }
kangxiaoshan committed
256
        } else {
manxiaoqiang committed
257 258
            ContractIncrement increment = contractIncrementRepository.findByCode(product);
            Contract contract = contractRepository.findByPlatformAndEmailAndPricelevelLimit1(platfrom, email, type, increment.getId());
kangxiaoshan committed
259
            if (null == contract) {
manxiaoqiang committed
260
                flag = true;
kangxiaoshan committed
261
            } else {
manxiaoqiang committed
262 263
                String beforeDay = DateUtil.getBeforeDays(180);
                String endDate = contract.getEndDate() == null ? contract.getDs() : contract.getEndDate();
kangxiaoshan committed
264
                if (beforeDay.compareTo(endDate) > 0) {
manxiaoqiang committed
265 266 267 268 269 270 271
                    flag = true;
                }
            }
        }
        return flag;
    }

manxiaoqiang committed
272
    @Override
kangxiaoshan committed
273
    public List<ContractBody> findBody(String platform, User loginAccount) {
kangxiaoshan committed
274

kangxiaoshan committed
275
        if ("all".equals(platform)) {
1  
kangxiaoshan committed
276
            List<ContractBody> all = contractBodyRepository.findAllCodeDis();
kangxiaoshan committed
277
            return all;
kangxiaoshan committed
278
        } else {
kangxiaoshan committed
279 280

            List<ContractBody> common = null;
kangxiaoshan committed
281
            if (!"abtest".equals(platform) && !"ads".equals(platform)) {
kangxiaoshan committed
282 283 284
                common = contractBodyRepository.findByPlatform("common");
            }

kangxiaoshan committed
285
            List<ContractBody> byPlatform = contractBodyRepository.findByPlatform(platform);
kangxiaoshan committed
286 287 288
            if (common == null) {
                common = new ArrayList<>();
            }
kangxiaoshan committed
289
            common.addAll(byPlatform);
kangxiaoshan committed
290 291 292 293 294 295

            if (RoleEnum.FINANCE.getKey().equals(loginAccount.getRole())) {
                Map<String, Object> filter = authService.getAuthExtends(loginAccount);
                common = common.stream().filter(t -> filter.get(t.getCode()) != null).collect(Collectors.toList());
            }

kangxiaoshan committed
296 297
            return common;
        }
kangxiaoshan committed
298

manxiaoqiang committed
299 300 301 302 303 304
    }

    @Override
    public String getContractCode(String code) {
        BigInteger integer = contractRepository.countNumByDs(DateUtil.getBeforeDays(0));
        String lastCode = "";
kangxiaoshan committed
305
        if (integer.intValue() < 9) {
manxiaoqiang committed
306
            lastCode = "0" + (integer.intValue() + 1);
kangxiaoshan committed
307
        } else {
manxiaoqiang committed
308 309 310 311 312 313
            lastCode = "" + (integer.intValue() + 1);
        }
        String re = code + "-" + DateUtil.getDays2(0) + lastCode;
        return re;
    }

kangxiaoshan committed
314 315 316
    @Override
    public String getContractCode(String code, String platform, String company) {

kangxiaoshan committed
317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332
//        BigInteger countContract = contractRepository.findcountContract(code);
//
//        String lastCode;
//
//        if("fake".equals(platform)){
//            platform = "FZBWS";
//        }
//
//        int codeInt = countContract.intValue();
//
//        if (codeInt < 9) {
//            lastCode = "0" + (codeInt + 1);
//        } else {
//            lastCode = "" + (codeInt + 1);
//        }
//        return  code + "-" + platform.toUpperCase() + "-" + DateUtil.getDays2(0) + "-" + lastCode;
kangxiaoshan committed
333 334


kangxiaoshan committed
335 336
        String codeName = contractRepository.findLastCode(code);
        if ("fake".equals(platform)) {
kangxiaoshan committed
337 338 339
            platform = "FZBWS";
        }

kangxiaoshan committed
340 341
        int codeInt = 0;

kangxiaoshan committed
342 343 344
        if (!StringUtils.isEmpty(codeName)) {

            String[] codeformat = codeName.split("-");
kangxiaoshan committed
345

kangxiaoshan committed
346 347 348 349
            if (codeformat.length == 4) {
                codeInt = Integer.parseInt(codeformat[3]);
            }

kangxiaoshan committed
350 351 352
        }

        String lastCode;
kangxiaoshan committed
353

kangxiaoshan committed
354 355 356 357
        if (codeInt < 9) {
            lastCode = "0" + (codeInt + 1);
        } else {
            lastCode = "" + (codeInt + 1);
kangxiaoshan committed
358
        }
kangxiaoshan committed
359

kangxiaoshan committed
360
        return code + "-" + platform.toUpperCase() + "-" + DateUtil.getDays2(0) + "-" + lastCode;
kangxiaoshan committed
361 362


kangxiaoshan committed
363 364
    }

manxiaoqiang committed
365
    @Override
manxiaoqiang committed
366
    public List findSetmeal(String platform) {
kangxiaoshan committed
367

kangxiaoshan committed
368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396
//        platform = "tkio";
//
//        List list = new ArrayList();
//        if ("adi".equals(platform)) {
//            for (int i = 1; i < 3; i++) {
//                Map<String, String> packageMap = new HashMap<>();
//                packageMap.put("id", i + "");
//                if (i == 1) {
//                    packageMap.put("packageName", PackageEnum.PROBATION.getValue());
//                } else {
//                    packageMap.put("packageName", PackageEnum.FORMAL.getValue());
//                }
//                list.add(packageMap);
//            }
//        } else {
//            if ("tkio".equals(platform) || "io".equals(platform)) {
////            List<PackageType> packageTypeList = packageTypeRepository.findAll();
//                List<PackageType> packageTypeList = packageTypeRepository.findIsNewAll();
//                for (PackageType p : packageTypeList) {
//                    p.setType("main");
//                    list.add(p);
//                }
//                // 增值套餐
////                List<ContractIncrement> increments = contractIncrementRepository.findAll();
////                list.addAll(increments);
//            } else if ("userdesk".equals(platform) || "dmp".equals(platform) || "fake".equals(platform)) {
//                list = bpuContractRepository.findByProduct(platform);
//            }
//        }
kangxiaoshan committed
397

manxiaoqiang committed
398
        List list = new ArrayList();
kangxiaoshan committed
399

kangxiaoshan committed
400 401 402 403 404
        if ("tkio".equals(platform) || "io".equals(platform)) {
            List<PackageType> packageTypeList = packageTypeRepository.findIsNewAll();
            for (PackageType p : packageTypeList) {
                p.setType("main");
                list.add(p);
manxiaoqiang committed
405
            }
kangxiaoshan committed
406 407

            return list;
kangxiaoshan committed
408 409
        } else {
            List<PackageBase> packageBases = packageBaseRepository.findByPlatAndStatus(platform, 1);
kangxiaoshan committed
410
            return packageBases;
manxiaoqiang committed
411 412
        }

kangxiaoshan committed
413

manxiaoqiang committed
414 415 416 417 418
    }

    @Override
    public List<ContractIncrement> findIncrement() {
        return null;
manxiaoqiang committed
419 420 421 422
    }

    @Override
    public Double getRebat(String product, Integer level, Long money) {
manxiaoqiang committed
423
        Double rebat = 1d;
kangxiaoshan committed
424
        try {
manxiaoqiang committed
425
            PriceLevelMoney levelMoney = priceLevelMoneyRepository.getOne(product, level);
kangxiaoshan committed
426 427
            rebat = money * 1.0 / levelMoney.getMoney();
        } catch (Exception e) {
manxiaoqiang committed
428 429 430
            e.printStackTrace();
        }
        return rebat;
manxiaoqiang committed
431 432 433
    }

    @Override
kangxiaoshan committed
434 435
    public List<Sales> getSales() {
        return salesRepository.findAllByStatusOn();
manxiaoqiang committed
436
    }
kangxiaoshan committed
437

manxiaoqiang committed
438 439 440
    @Override
    public Contract build(Contract contract) {
        User user = userRepository.findByEmail(contract.getSaleName());
kangxiaoshan committed
441
        if (null != user) {
manxiaoqiang committed
442 443
            contract.setSale(user.getId());
        }
2  
manxiaoqiang committed
444
        contract.setVirtual(true);
manxiaoqiang committed
445 446 447 448
        Account account = accountRepository.findByEmail(contract.getEmail());
        contract.setCustomerBody(account.getCompany());
        contract.setType("increment");
        contract.setPlatform("tkio");
2  
manxiaoqiang committed
449
        contract.setStartDate(DateUtil.getBeforeDays(0));
manxiaoqiang committed
450 451 452 453 454
        ContractIncrement contractIncrement = contractIncrementRepository.findByCode(contract.getPriceLevelName());
        contract.setPriceLevel(contractIncrement.getId());
        Contract contract1 = create(null, contract);
        return contract1;
    }
kangxiaoshan committed
455

manxiaoqiang committed
456 457
    @Override
    public Contract create(User loginUser, Contract resource) {
kangxiaoshan committed
458

kangxiaoshan committed
459
        if (resource == null) {
kangxiaoshan committed
460 461 462
            return null;
        }

kangxiaoshan committed
463
        if (!StringUtils.isEmpty(resource.getContractCode()) && !ContractStatusEnum.MONEY_BACK_FIRST.getKey().equals(resource.getStatus())) {
kangxiaoshan committed
464 465 466 467 468 469
            Contract contractExist = contractRepository.findByCode(resource.getContractCode().trim());
            if (contractExist != null) {
                contractExist = new Contract();
                // 合同编号已存在
                contractExist.setId(-100L);
                contractExist.setErroMessage("合同编号已存在");
kangxiaoshan committed
470

kangxiaoshan committed
471 472
                return contractExist;
            }
kangxiaoshan committed
473 474 475 476
        }

        resource.setInvoice(0L);
        Long extraFlow = resource.getExtraFlow();
kangxiaoshan committed
477
        if (extraFlow == null) {
kangxiaoshan committed
478 479
            extraFlow = 0L;
        }
kangxiaoshan committed
480
        if (resource.getPayMoney() == null) {
kangxiaoshan committed
481 482 483
            resource.setPayMoney(0L);
        }

kangxiaoshan committed
484 485
        resource.setDs(DateUtil.getBeforeDays(0));

kangxiaoshan committed
486
        this.saveIncrementFlow(resource, extraFlow);
kangxiaoshan committed
487

kangxiaoshan committed
488
        this.dealContractStatus(resource, loginUser, "save");
kangxiaoshan committed
489

kangxiaoshan committed
490 491 492 493
        if (ContractStatusEnum.MONEY_BACK_FIRST.getKey().equals(resource.getStatus())) {
            resource.setStartDate(new DateTime().toString("yyyy-MM-dd"));
        }

kangxiaoshan committed
494
        if (resource.getRelationContract() == null) {
kangxiaoshan committed
495 496 497 498 499
            resource.setRelationContract(-1L);
        }

        if (null != loginUser) {
            resource.setCreateAccount(loginUser.getId());
kangxiaoshan committed
500
            resource.setCreateName(loginUser.getName());
kangxiaoshan committed
501 502 503 504 505
        }

        resource.setCreateTime(new Date());

        //同步修改trackingio的数据
kangxiaoshan committed
506 507 508 509 510 511 512 513 514
//        if (resource.getPlatform().equals("tkio") && resource.getType().equals("main")) {
//            accountService.update(resource);
//        }
//        if (resource.getPlatform().equals("io") && resource.getType().equals("main")) {
//            accountIOService.update(resource);
//        }
//        if (resource.getPlatform().equals("adi")) {
//            adiAccountService.updateAccount(resource);
//        }
kangxiaoshan committed
515

kangxiaoshan committed
516 517 518

        this.calculateShareIncome(resource);

kangxiaoshan committed
519 520
        resource = contractRepository.save(resource);

kangxiaoshan committed
521
        this.saveContractRelations(resource, resource.getId());
kangxiaoshan committed
522 523 524 525

        return resource;
    }

526
    public void calculateShareIncome(Contract resource) {
kangxiaoshan committed
527 528 529 530 531 532 533 534 535
        DateTime formStart = new DateTime(resource.getStartDate());
        DateTime contractStart = new DateTime(resource.getStartDate());
        DateTime contractEnd = new DateTime(resource.getEndDate());
        if (formStart.getMonthOfYear() != new DateTime().getMonthOfYear()) {
            // 自动计算分摊调整金
            //当录入时间与合同开始时间不在一个月时。自动生成调分摊输入调整金。
            //分摊收入调整金 =  合同金额 * 6% / 合同总天数  *[录入日期前一月最后一日(含) - 合同开始日期]
            int day1 = Days.daysBetween(contractStart, contractEnd).getDays();
            int day2 = Days.daysBetween(contractStart, new DateTime().plusMonths(-1).dayOfMonth().withMaximumValue()).getDays();
536
            resource.setAdjustmentFund(resource.getMoney() * 6 / day1 * day2); // 此处为 *100的结果
kangxiaoshan committed
537 538 539
        }
    }

kangxiaoshan committed
540

kangxiaoshan committed
541
    private void saveIncrementFlow(Contract resource, Long extraFlow) {
kangxiaoshan committed
542
        if ("main".equals(resource.getType())) {
kangxiaoshan committed
543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560
            if (resource.getPlatform().equals("tkio")) {
                if (!(extraFlow.longValue() == 0)) {
                    if (resource.getPlatform().equals("tkio")) {
                        IncrementFlow flow = new IncrementFlow();
                        Account account = accountRepository.findByEmail(resource.getEmail());
                        flow.setAccount(account.getId());
                        flow.setFlow(extraFlow);
                        flow.setEndDate(resource.getEndDate());
                        flow.setStartDate(resource.getStartDate());
                        flow.setContractCode(resource.getContractCode());
                        incrementFlowRepository.save(flow);
                    }
                }
            }
        }
    }


kangxiaoshan committed
561
    private void saveContractRelations(Contract resource, Long contractId) {
kangxiaoshan committed
562 563 564 565
        if (resource.getRelationContract() != null && resource.getRelationContract() > 0) {
            //保存关联合同信息
            ContractRelation relation = new ContractRelation();
            relation.setCreateTime(new Date());
kangxiaoshan committed
566
            relation.setMainContract(contractId);
kangxiaoshan committed
567 568 569
            relation.setRelationId(resource.getRelationContract());
            relation.setPlatform(resource.getPlatform());

kangxiaoshan committed
570 571
            ContractRelation relationOrig = contractRelationRepository.findByRelationData(relation.getMainContract(), relation.getRelationId(), resource.getPlatform());
            if (relationOrig == null) {
kangxiaoshan committed
572 573
                contractRelationRepository.save(relation);
            }
kangxiaoshan committed
574

kangxiaoshan committed
575 576 577 578
            //处理被关联 合同
            Contract contract = contractRepository.findOne(resource.getRelationContract());
            if (contract.getRelationContract() == null || contract.getRelationContract() == -1) {
                contract.setRelationContract(contractId);
kangxiaoshan committed
579
                contract.setRelationCode(resource.getContractCode());
kangxiaoshan committed
580 581 582
                contractRepository.save(contract);
            }

kangxiaoshan committed
583 584
            //设置关联编号
            resource.setRelationCode(contract.getContractCode());
kangxiaoshan committed
585 586

        }
kangxiaoshan committed
587 588 589 590 591 592 593 594 595 596 597 598
    }


    public Contract create_bak(User loginUser, Contract resource) {

        if (resource == null) {
            return null;
        }

        Contract contractExist = contractRepository.findByCodePlatform(resource.getContractCode(), resource.getPlatform());

        if (contractExist != null) {
kangxiaoshan committed
599 600 601 602 603
            // 合同编号已存在
            return null;
        }

        // 老的逻辑
kangxiaoshan committed
604 605 606 607 608
        String contractCode = getContractCode(resource.getMyBodyCode());

        if (!contractCode.equals(resource.getContractCode())) {
            resource.setContractCode(contractCode);
        }
manxiaoqiang committed
609

manxiaoqiang committed
610 611
        resource.setPayMoney(0L);
        resource.setInvoice(0L);
manxiaoqiang committed
612
        Long extraFlow = resource.getExtraFlow();
kangxiaoshan committed
613
        resource.setDs(DateUtil.getBeforeDays(0));
2  
manxiaoqiang committed
614

kangxiaoshan committed
615 616 617 618 619
        if (resource.getType().equals("main")) {
            if (resource.getPlatform().equals("tkio")) {
                if (!(extraFlow.longValue() == 0)) {
                    if (resource.getPlatform().equals("tkio")) {
                        IncrementFlow flow = new IncrementFlow();
2  
manxiaoqiang committed
620 621 622 623 624 625 626 627
                        Account account = accountRepository.findByEmail(resource.getEmail());
                        flow.setAccount(account.getId());
                        flow.setFlow(extraFlow);
                        flow.setEndDate(resource.getEndDate());
                        flow.setStartDate(resource.getStartDate());
                        flow.setContractCode(resource.getContractCode());
                        incrementFlowRepository.save(flow);
                    }
2  
manxiaoqiang committed
628 629
                }
            }
manxiaoqiang committed
630 631 632 633 634 635 636
            if (DateUtil.getBeforeDays(0).compareTo(resource.getStartDate()) < 0) {
                resource.setDs(DateUtil.getBeforeDays(0));
                resource.setStatus("wait");
            } else {
                resource.setDs(DateUtil.getBeforeDays(0));
                resource.setStatus("executing");
            }
kangxiaoshan committed
637 638 639 640 641
        } else {
//            resource.setDs(DateUtil.getBeforeDays(0));
//            resource.setStatus("wait");
        }

kangxiaoshan committed
642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662
//        if (resource.getRebateMoney() != null) {
//            if (resource.getMoney() == null) {
//                resource.setMoney(0L);
//            }
//
//            if (resource.getRebateMoney().compareTo(BigDecimal.ZERO) < 0) {
//                //未回款
//                resource.setStatus(ContractStatusEnum.MONEY_BACK_NONE.getKey());
//
//            }else if(resource.getRebateMoney().compareTo(new BigDecimal(resource.getMoney()+""))< 0){
//                // 部分回款
//                resource.setStatus(ContractStatusEnum.MONEY_BACK_PART.getKey());
//            }else{
//                // 已回款
//                resource.setStatus(ContractStatusEnum.MONEY_BACK_ALL.getKey());
//            }
//
//        } else {
//            //未回款
//            resource.setStatus(ContractStatusEnum.MONEY_BACK_NONE.getKey());
//        }
kangxiaoshan committed
663 664 665 666 667 668 669 670 671 672 673 674 675

        Double rebat = null;
        if (null != resource.getPriceLevel()) {
            rebat = getRebat(resource.getProduct(), resource.getPriceLevel().intValue(), resource.getMoney());
        } else {
            rebat = getRebat(resource.getProduct(), 0, resource.getMoney());
        }

        BigDecimal bg = new BigDecimal(rebat);
        double f1 = bg.setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue();
        resource.setRebate(f1);

        if (null != loginUser) {
manxiaoqiang committed
676
            resource.setCreateAccount(loginUser.getId());
kangxiaoshan committed
677
            resource.setCreateName(loginUser.getName());
manxiaoqiang committed
678
        }
manxiaoqiang committed
679
        resource.setCreateTime(new Date());
manxiaoqiang committed
680 681

        //同步修改trackingio的数据
kangxiaoshan committed
682
        if (resource.getPlatform().equals("tkio") && resource.getType().equals("main")) {
manxiaoqiang committed
683 684
            accountService.update(resource);
        }
kangxiaoshan committed
685
        if (resource.getPlatform().equals("io") && resource.getType().equals("main")) {
manxiaoqiang committed
686 687
            accountIOService.update(resource);
        }
kangxiaoshan committed
688
        if (resource.getPlatform().equals("adi")) {
manxiaoqiang committed
689 690
            adiAccountService.updateAccount(resource);
        }
manxiaoqiang committed
691

kangxiaoshan committed
692 693 694 695
        if (resource.getType().equals(ContractTypeEnum.MAIN.getKey())
                || (resource.getType().equals(ContractTypeEnum.INCREMENT.getKey()) && resource.getPriceLevel().equals(1L))) {
            List<Contract> contractList = contractRepository.findByPlatformAndEmail(resource.getPlatform(), resource.getEmail(), resource.getType());
            if (ValidateUtil.isValid(contractList)) {
manxiaoqiang committed
696
                List<Contract> list = new ArrayList<>();
kangxiaoshan committed
697 698 699
                for (Contract contract : contractList) {
                    if (contract.getType().equals(ContractTypeEnum.MAIN.getKey())
                            || (contract.getType().equals(ContractTypeEnum.INCREMENT.getKey()) && contract.getPriceLevel().equals(1L))) {
manxiaoqiang committed
700

kangxiaoshan committed
701 702
                        if (contract.getStatus().equals(ContractStatusEnum.EXECUTING.getKey())
                                || contract.getStatus().equals(ContractStatusEnum.WAIT.getKey())) {
manxiaoqiang committed
703 704 705 706 707 708 709 710 711 712
                            contract.setStatus(ContractStatusEnum.CANCEL.getKey());
                        }
                        list.add(contract);
                    }

                }
                contractRepository.save(contractList);
            }
        }

kangxiaoshan committed
713
        resource = contractRepository.save(resource);
kangxiaoshan committed
714 715


kangxiaoshan committed
716
        if (resource.getRelationContract() != null && resource.getRelationContract() > 0) {
kangxiaoshan committed
717 718 719 720 721 722 723 724 725 726 727
            //保存关联合同信息
            ContractRelation relation = new ContractRelation();
            relation.setCreateTime(new Date());
            relation.setMainContract(resource.getId());
            relation.setRelationId(resource.getRelationContract());
            relation.setPlatform(resource.getPlatform());
            contractRelationRepository.save(relation);

        }

        return resource;
manxiaoqiang committed
728 729 730
    }

    @Override
kangxiaoshan committed
731
    public Contract update(User loginUser, Contract resource, String ip) {
kangxiaoshan committed
732

kangxiaoshan committed
733
        Contract contract = contractRepository.findOne(resource.getId());
kangxiaoshan committed
734

kangxiaoshan committed
735
        if (resource.getContractCode() != null && !resource.getContractCode().equals(contract.getContractCode())) {
736
            Contract contractExist = contractRepository.findByCode(resource.getContractCode().trim());
kangxiaoshan committed
737 738 739 740 741 742
            if (contractExist != null) {
                // 合同编号已存在
                contractExist = new Contract();
                contractExist.setId(-100L);
                contractExist.setErroMessage("合同编号已存在");
                return contractExist;
manxiaoqiang committed
743
            }
manxiaoqiang committed
744 745
        }

kangxiaoshan committed
746
        this.dealContractStatus(resource, loginUser, "update");
manxiaoqiang committed
747

kangxiaoshan committed
748
        this.saveContractRelations(resource, contract.getId());
kangxiaoshan committed
749

kangxiaoshan committed
750 751 752 753 754 755 756 757 758 759 760 761 762
        ChangeDelInfo delInfo = new ChangeDelInfo();

        delInfo.setModifyId(loginUser.getId());
        delInfo.setModifyAccount(loginUser.getName());
        delInfo.setEmail(contract.getEmail());
        delInfo.setDs(new DateTime().toString("yyyy-MM-dd"));
        delInfo.setModifyType(2);
        delInfo.setContractCode(contract.getContractCode());
        delInfo.setCreatTime(new Date());
        delInfo.setFunction(4);
        delInfo.setDetail("修改详情");
        delInfo.setIp(ip);

kangxiaoshan committed
763

kangxiaoshan committed
764
        List<ChangeDelDetail> updateFields = this.changeDelInfoForContract(contract, resource, delInfo.getId(), "");
kangxiaoshan committed
765 766 767 768 769 770 771 772 773 774

        if (updateFields != null && updateFields.size() > 0) {
            changeDelInfoRepository.save(delInfo);

            for (ChangeDelDetail delDetail : updateFields) {
                delDetail.setParentId(delInfo.getId());
            }

            changeDelDetailRepository.save(updateFields);
        }
kangxiaoshan committed
775

kangxiaoshan committed
776 777 778 779 780 781 782 783 784
        resource.setCreateName(contract.getCreateName());
        resource.setCreateAccount(contract.getCreateAccount());
        resource.setCreateTime(contract.getCreateTime());
        resource.setDs(contract.getDs());
        resource.setProduct(contract.getProduct());

        resource.setModifyTime(new Date());
        if (null != loginUser) {
            resource.setModifyAccount(loginUser.getId());
manxiaoqiang committed
785
        }
kangxiaoshan committed
786

kangxiaoshan committed
787 788 789 790 791 792 793 794
        if (ContractStatusEnum.MONEY_BACK_FIRST.getKey().equals(contract.getStatus())) {
            ContractMoney contractMoney = contractMoneyRepository.findOne(contract.getFirstBackId());
            if (contractMoney != null) {
                contractMoney.setContractCode(resource.getContractCode());
                contractMoneyRepository.save(contractMoney);
            }
        }

kangxiaoshan committed
795 796
        this.calculateShareIncome(resource);

kangxiaoshan committed
797
        resource.setId(contract.getId());
manxiaoqiang committed
798

kangxiaoshan committed
799
        return contractRepository.save(resource);
kangxiaoshan committed
800

kangxiaoshan committed
801 802
    }

kangxiaoshan committed
803
    private List<ChangeDelDetail> changeDelInfoForContract(Contract byfind, Contract resource, Long pid, String ip) {
kangxiaoshan committed
804 805

        List<ChangeDelDetail> delDetailsList = new ArrayList<>();
kangxiaoshan committed
806
        String contractCode = byfind.getContractCode();
kangxiaoshan committed
807 808 809 810 811 812
        this.dealChangeInfoDetail(byfind.getCustomerBody(), resource.getCustomerBody(),
                "客户签约主体", "customerBody", pid, delDetailsList, byfind);
        this.dealChangeInfoDetail(byfind.getCustomerShort(), resource.getCustomerShort(),
                "客户简称", "customerShort", pid, delDetailsList, byfind);
        this.dealChangeInfoDetail(byfind.getCustomerThird(), resource.getCustomerThird(),
                "第三方签约主体", "customerThird", pid, delDetailsList, byfind);
kangxiaoshan committed
813 814 815

        if (byfind.getTradeType() != resource.getTradeType()) {
            List<TradeType> types = tradeTypeRepsitory.findByTwoId(byfind.getTradeType(), resource.getTradeType());
kangxiaoshan committed
816 817 818
            Map<String, String> dataDic = new HashMap();
            for (TradeType tradeType : types) {
                dataDic.put(tradeType.getId().toString(), tradeType.getName());
kangxiaoshan committed
819
            }
kangxiaoshan committed
820 821
            String nameFind = dataDic.get(byfind.getTradeType() + "");
            String nameResource = dataDic.get(resource.getTradeType() + "");
kangxiaoshan committed
822 823
            this.dealChangeInfoDetail(nameFind == null ? "无" : nameFind, nameResource == null ? "无" : nameResource,
                    "行业分类", "tradeType", pid, delDetailsList, byfind);
kangxiaoshan committed
824 825
        }

kangxiaoshan committed
826 827
        this.dealChangeInfoDetail(byfind.getStartDate(), resource.getStartDate(),
                "合同开始日期", "startDate", pid, delDetailsList, byfind);
kangxiaoshan committed
828

kangxiaoshan committed
829 830
        this.dealChangeInfoDetail(byfind.getEndDate(), resource.getEndDate(),
                "合同结束日期", "startDate", pid, delDetailsList, byfind);
kangxiaoshan committed
831 832 833


        if (byfind.getSale() != resource.getSale()) {
kangxiaoshan committed
834 835 836
            List<Sales> sales = salesRepository.findByTwoId(byfind.getSale(), resource.getSale());
            this.dealChangeInfoDetail(sales.get(0).getName(), sales.get(1).getName(),
                    "签约销售", "sale", pid, delDetailsList, byfind);
kangxiaoshan committed
837 838
        }

kangxiaoshan committed
839 840 841
        this.dealChangeInfoDetail(byfind.getExtraFlow() == null ? "" : byfind.getExtraFlow().toString(),
                resource.getExtraFlow() == null ? "" : resource.getExtraFlow().toString(),
                "赠送流量", "extraFlow", pid, delDetailsList, byfind);
kangxiaoshan committed
842

kangxiaoshan committed
843 844
        this.dealChangeInfoDetail(byfind.getEmail(), resource.getEmail(),
                "客户主账号", "startDate", pid, delDetailsList, byfind);
kangxiaoshan committed
845 846 847

        this.dealChangeInfoDetail(CONTRACT_TYPE.get(byfind.getContractType()),
                CONTRACT_TYPE.get(resource.getContractType()),
kangxiaoshan committed
848
                "签约类型", "startDate", pid, delDetailsList, byfind);
kangxiaoshan committed
849

kangxiaoshan committed
850 851 852
        this.dealChangeInfoDetail(byfind.getDiscountTimeLong() == null ? "" : byfind.getDiscountTimeLong().toString(),
                resource.getDiscountTimeLong() == null ? "" : resource.getDiscountTimeLong().toString(),
                "赠送时长", "discountTimeLong", pid, delDetailsList, byfind);
kangxiaoshan committed
853

kangxiaoshan committed
854 855 856
        this.dealChangeInfoDetail(byfind.getRelationCode() == null ? "无" : byfind.getRelationCode(),
                resource.getRelationCode() == null ? "无" : resource.getRelationCode(),
                "关联合同", "relationCode", pid, delDetailsList, byfind);
kangxiaoshan committed
857

kangxiaoshan committed
858 859
        return delDetailsList;

kangxiaoshan committed
860 861 862

    }

kangxiaoshan committed
863 864
    private void dealChangeInfoDetail(String before, String now, String delDetailinfo, String fildeName,
                                      Long pid, List<ChangeDelDetail> delDetails, Contract contract) {
kangxiaoshan committed
865 866 867 868 869 870 871

        ChangeDelDetail delDetail = new ChangeDelDetail();
        delDetail.setFiledName(fildeName);
        delDetail.setDetail(delDetailinfo);
        delDetail.setCreatTime(new Date());
        delDetail.setItem("合同修改");
        delDetail.setParentId(pid);
kangxiaoshan committed
872 873
        delDetail.setContractCode(contract.getContractCode());
        delDetail.setEmail(contract.getEmail());
kangxiaoshan committed
874 875 876 877 878 879 880 881 882 883 884 885 886 887

        if (before != null && !before.equals(now)) {
            delDetail.setBeforeValue(before);
            delDetail.setAfterValue(now == null ? "" : now);
            delDetails.add(delDetail);
        } else {
            if (now != null && !now.equals(before)) {
                delDetail.setBeforeValue(before == null ? "" : before);
                delDetail.setAfterValue(now);
                delDetails.add(delDetail);
            }
        }
    }

kangxiaoshan committed
888 889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 955

    public Contract update_bak(User loginUser, Contract resource) {
//        Map<Long, String> packageMap = getPackageMap();
//        Map<Long, String> saleMap = getSaleMap();
//        Contract contract = contractRepository.findOne(resource.getId());
//
//        ContractChange cc = new ContractChange();
//        cc.setType("update");
//        cc.setUser(loginUser.getId());
//        cc.setDs(DateUtil.getBeforeDays(0));
//        cc.setContent("");
//        cc.setEmail(contract.getEmail());
//        cc.setCompany(contract.getCustomerBody());
//        cc.setContractCode(contract.getContractCode());
//        this.dealContractStatus(resource,loginUser,"update");


//        if (!resource.getStartDate().equals(contract.getStartDate())) {
//            cc.setContent(cc.getContent() + "开始时间变更 : " + contract.getStartDate() + "-->" + resource.getStartDate());
//            contract.setStartDate(resource.getStartDate());
////            if(DateUtil.getBeforeDays(0).compareTo(resource.getStartDate()) < 0){
////                contract.setStatus("wait");
////            }else{
////                contract.setStatus("executing");
////            }
//        }
//        if (!resource.getEndDate().equals(contract.getEndDate())) {
//            cc.setContent(cc.getContent() + "   结束时间变更 : " + contract.getEndDate() + "-->" + resource.getEndDate());
//            contract.setEndDate(resource.getEndDate());
//        }
//
//        boolean newRebat = false;
//        if (contract.getType().equals(ContractTypeEnum.MAIN.getKey()) && null != resource.getPriceLevel()) {
//            if (!resource.getPriceLevel().equals(contract.getPriceLevel())) {
//                cc.setContent(cc.getContent() + "  套餐变更:" + packageMap.get(contract.getPriceLevel()) + "-->" + packageMap.get(resource.getPriceLevel()));
//                newRebat = true;
//                contract.setPriceLevel(resource.getPriceLevel());
//            }
//        }
//
//        if (!resource.getMoney().equals(contract.getMoney())) {
//            cc.setContent(cc.getContent() + "   金额变更: " + contract.getMoney() + "-->" + resource.getMoney());
//            newRebat = true;
//            contract.setMoney(resource.getMoney());
//        }
//
//        if (!resource.getRebateMoney().equals(contract.getRebateMoney())) {
//            cc.setContent(cc.getContent() + "  回款金额变更: " + contract.getMoney() + "-->" + resource.getMoney());
//            newRebat = true;
//            contract.setMoney(resource.getMoney());
//        }
//
//        if (!resource.getSale().equals(contract.getSale())) {
//            cc.setContent(cc.getContent() + "销售变更:" + saleMap.get(contract.getSale()) + "-->" + saleMap.get(resource.getSale()));
//            contract.setSale(resource.getSale());
//        }
//
////        if (newRebat && !"adi".equals(contract.getPlatform())) {
////            Double rebat = getRebat(contract.getProduct(), contract.getPriceLevel().intValue(), contract.getMoney());
////            BigDecimal bg = new BigDecimal(rebat);
////            double f1 = bg.setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue();
//////            contract.setRebate(f1);
////        }
//
//        if (!resource.getSale().equals(contract.getSale())) {
//            cc.setContent(cc.getContent() + "销售变更:" + saleMap.get(contract.getSale()) + "-->" + saleMap.get(resource.getSale()));
//            contract.setSale(resource.getSale());
//        }
kangxiaoshan committed
956

kangxiaoshan committed
957 958
//        cc.setPlatform(contract.getPlatform());
//        contractChangeRepository.save(cc);
manxiaoqiang committed
959

manxiaoqiang committed
960
        //同步修改trackingio的数据
kangxiaoshan committed
961 962 963 964 965 966 967 968 969
//        if (contract.getPlatform().equals("tkio") && resource.getType().equals("main")) {
//            accountService.update(contract);
//        }
//        if (contract.getPlatform().equals("io") && resource.getType().equals("main")) {
//            accountIOService.update(contract);
//        }
//        if (contract.getPlatform().equals("adi")) {
//            adiAccountService.updateAccount(contract);
//        }
manxiaoqiang committed
970

kangxiaoshan committed
971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993
//        if (contract.getPlatform().equals("tkio")) {
//            if (contract.getType().equals("main")) {
//                IncrementFlow flow = incrementFlowRepository.findOne(resource.getContractCode());
//                if (null != flow) {
//                    flow.setEndDate(resource.getEndDate());
//                    flow.setStartDate(resource.getStartDate());
//                    if (contract.getExtraFlow() != resource.getExtraFlow()) {
//                        flow.setFlow(resource.getExtraFlow());
//                        incrementFlowRepository.save(flow);
//                    }
//                } else if (resource.getExtraFlow().longValue() > 0) {
//                    IncrementFlow flow1 = new IncrementFlow();
//                    Account account = accountRepository.findByEmail(contract.getEmail());
//                    flow1.setAccount(account.getId());
//                    flow1.setFlow(resource.getExtraFlow());
//                    flow1.setEndDate(resource.getEndDate());
//                    flow1.setStartDate(resource.getStartDate());
//                    flow1.setContractCode(resource.getContractCode());
//                    incrementFlowRepository.save(flow1);
//                }
//            }
//
//        }
manxiaoqiang committed
994

kangxiaoshan committed
995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012
//        contract.setStatus(resource.getStatus());
//        contract.setExtraFlow(resource.getExtraFlow());
//        contract.setTradeType(resource.getTradeType());
//        contract.setInvoiceMoney(resource.getInvoiceMoney());
//        contract.setRelationContract(resource.getRelationContract());
//        contract.setRebateMoney(resource.getRebateMoney());
//        contract.setDiscountTimeLong(resource.getDiscountTimeLong());
//
//        contract.setModifyTime(new Date());
//        if (null != loginUser) {
//            resource.setModifyAccount(loginUser.getId());
//        }
//
//
//        this.saveContractRelations(resource,contract.getId());
//
//        return contractRepository.save(contract);
        return null;
manxiaoqiang committed
1013 1014
    }

kangxiaoshan committed
1015

kangxiaoshan committed
1016
    private void dealContractStatus(Contract resource, User loginUser, String type) {
kangxiaoshan committed
1017

kangxiaoshan committed
1018 1019 1020

        ContractMoney money = new ContractMoney();

kangxiaoshan committed
1021
        if (resource.getPayMoney() != null) {
kangxiaoshan committed
1022

kangxiaoshan committed
1023 1024 1025 1026
            if (resource.getMoney() == null) {
                resource.setMoney(0L);
            }

kangxiaoshan committed
1027 1028
            if (ContractStatusEnum.MONEY_BACK_FIRST.getKey().equals(resource.getStatus())) {

kangxiaoshan committed
1029 1030
                resource.setStatus(ContractStatusEnum.MONEY_BACK_FIRST.getKey());
                //记录收款记录
kangxiaoshan committed
1031

kangxiaoshan committed
1032
                money.setType("pay");
kangxiaoshan committed
1033
                money = saveContractMoney(money, loginUser, resource, type);
kangxiaoshan committed
1034

kangxiaoshan committed
1035
            } else if (resource.getPayMoney().longValue() <= 0) {
kangxiaoshan committed
1036 1037 1038
                //未回款
                resource.setStatus(ContractStatusEnum.MONEY_BACK_NONE.getKey());

kangxiaoshan committed
1039
            } else if (resource.getPayMoney().longValue() < resource.getMoney().longValue()) {
kangxiaoshan committed
1040 1041
                // 部分回款
                resource.setStatus(ContractStatusEnum.MONEY_BACK_PART.getKey());
kangxiaoshan committed
1042 1043 1044

                //记录收款记录
                money.setType("pay");
kangxiaoshan committed
1045
                money = saveContractMoney(money, loginUser, resource, type);
kangxiaoshan committed
1046 1047


kangxiaoshan committed
1048
            } else {
kangxiaoshan committed
1049 1050
                // 已回款
                resource.setStatus(ContractStatusEnum.MONEY_BACK_ALL.getKey());
kangxiaoshan committed
1051
                money.setType("pay");
kangxiaoshan committed
1052
                money = saveContractMoney(money, loginUser, resource, type);
kangxiaoshan committed
1053 1054
            }

kangxiaoshan committed
1055

kangxiaoshan committed
1056 1057 1058 1059 1060
        } else {
            //未回款
            resource.setStatus(ContractStatusEnum.MONEY_BACK_NONE.getKey());
        }

kangxiaoshan committed
1061
        if (money.getId() != null) {
kangxiaoshan committed
1062
            resource.setFirstBackId(money.getId());
kangxiaoshan committed
1063
        } else {
kangxiaoshan committed
1064 1065 1066
            resource.setFirstBackId(0L);
        }

kangxiaoshan committed
1067 1068
        if (resource.getPayMoney() == null) {
            resource.setPayMoney(0L);
kangxiaoshan committed
1069 1070 1071 1072
        }

        if (resource.getInvoiceMoney() == null) {
            resource.setInvoiceMoney(new BigDecimal(0));
kangxiaoshan committed
1073
        } else {
kangxiaoshan committed
1074 1075
            // 记录发票记录
            money.setType("invoice");
kangxiaoshan committed
1076
            saveContractMoney(money, loginUser, resource, type);
kangxiaoshan committed
1077 1078 1079 1080 1081 1082 1083 1084 1085
        }

        if (resource.getDiscountTimeLong() == null) {
            resource.setDiscountTimeLong(0L);
        }

        if (resource.getExtraFlow() == null) {
            resource.setExtraFlow(0L);
        }
kangxiaoshan committed
1086

kangxiaoshan committed
1087
        if (resource.getDiscountTimeLong() > 0 || resource.getExtraFlow() > 0) {
kangxiaoshan committed
1088
            //记录优惠信息
kangxiaoshan committed
1089
            saveFlowChange(resource, loginUser, type, resource.getDiscountTimeLong(), resource.getExtraFlow());
kangxiaoshan committed
1090
        }
kangxiaoshan committed
1091

kangxiaoshan committed
1092 1093 1094 1095 1096
        if (!ContractStatusEnum.MONEY_BACK_FIRST.getKey().equals(resource.getStatus())) {
            //处理合同编号
            resource.setCodeNum(Integer.parseInt(resource.getContractCode().split("-")[3]));

        }
kangxiaoshan committed
1097

kangxiaoshan committed
1098 1099 1100 1101
    }


    //保存开票收款记录
kangxiaoshan committed
1102
    private ContractMoney saveContractMoney(ContractMoney money, User loginUser, Contract contract, String type) {
kangxiaoshan committed
1103

kangxiaoshan committed
1104
        if (!"save".equals(type)) {
kangxiaoshan committed
1105
            return money;
kangxiaoshan committed
1106 1107
        }

kangxiaoshan committed
1108
        if (ContractStatusEnum.MONEY_BACK_FIRST.getKey().equals(contract.getStatus())) {
kangxiaoshan committed
1109
            money.setMoney(contract.getPayMoney());
kangxiaoshan committed
1110
        } else if (money.getType().equals("pay")) {
kangxiaoshan committed
1111
            money.setMoney(contract.getMoney());
kangxiaoshan committed
1112
        } else {
kangxiaoshan committed
1113
            money.setMoney(contract.getInvoiceMoney().longValue());
kangxiaoshan committed
1114 1115
        }

kangxiaoshan committed
1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127

        money.setSalse(contract.getSale());
        money.setPriceLevel(contract.getPriceLevel());

//        if(ContractStatusEnum.MONEY_BACK_FIRST.getKey().equals(contract.getStatus())){
//            money.setCompany(contract.getMyBodyName());
//        }else{
//            money.setCompany(contract.getCustomerBody());
//        }

        money.setCompany(contract.getCustomerBody());

kangxiaoshan committed
1128 1129 1130 1131 1132 1133 1134 1135 1136 1137
        money.setContractCode(contract.getContractCode());
        money.setPlatform(contract.getPlatform());
        money.setEmail(contract.getEmail());

        money.setPlatform(contract.getPlatform());
        money.setCreateAccount(loginUser.getId());
        money.setCreateTime(new Date());
        money.setUser(loginUser.getId());
        money.setCreateName(loginUser.getName());
        money.setDs(new DateTime().toString("yyyy-MM-dd"));
kangxiaoshan committed
1138
        money = contractMoneyRepository.save(money);
kangxiaoshan committed
1139
        return money;
kangxiaoshan committed
1140
    }
kangxiaoshan committed
1141

kangxiaoshan committed
1142
    // 保存优惠流量 优惠时长 记录
kangxiaoshan committed
1143
    private void saveFlowChange(Contract contract, User loginUser, String type, Long discountTimeLong, Long extraFlow) {
kangxiaoshan committed
1144

kangxiaoshan committed
1145
        if (!"save".equals(type)) {
kangxiaoshan committed
1146 1147 1148
            return;
        }

kangxiaoshan committed
1149
        FlowChange change = new FlowChange();
kangxiaoshan committed
1150 1151
        change.setDiscountFlow(extraFlow);
        change.setDiscountTimeLong(discountTimeLong);
kangxiaoshan committed
1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164
        change.setAddDate(new DateTime().toString("yyyy-MM-dd"));
        change.setAddTime(new Date());
        change.setCompany(contract.getMyBodyName());
        change.setContractCode(contract.getContractCode());
        change.setDelFlag(0);
        change.setEmail(contract.getEmail());
        change.setModifyUname(loginUser.getName());
        change.setModifyUser(loginUser.getId());
        flowChangeRepository.save(change);

    }


kangxiaoshan committed
1165 1166 1167 1168 1169
    /**
     * @param loginAccount
     * @param startDate
     * @param endDate
     * @param platform
kangxiaoshan committed
1170
     * @param contractId   用于 获取关联合同列表
kangxiaoshan committed
1171 1172
     * @return
     */
manxiaoqiang committed
1173
    @Override
kangxiaoshan committed
1174
    public List<Contract> findAll(User loginAccount, String startDate, String endDate, String platform, String contractId) {
manxiaoqiang committed
1175
        List<Contract> result = new ArrayList<>();
kangxiaoshan committed
1176

kangxiaoshan committed
1177
        List<String> platforms = new ArrayList<>();
kangxiaoshan committed
1178
        Map<String, String> idsDic = new HashMap<>();
kangxiaoshan committed
1179
        platforms.add(platform);
kangxiaoshan committed
1180

kangxiaoshan committed
1181
        if (!StringUtils.isEmpty(contractId)) {
kangxiaoshan committed
1182
            //获取 关联合同列表
kangxiaoshan committed
1183 1184
            List<String> conIds = new ArrayList<>();
            conIds.add(contractId);
kangxiaoshan committed
1185
            this.getContractRelationIds(conIds, idsDic);
kangxiaoshan committed
1186
            idsDic.remove(contractId);
kangxiaoshan committed
1187
            if ("fake".equals(platform)) {
kangxiaoshan committed
1188 1189
                platforms.add("tkio");
            }
kangxiaoshan committed
1190 1191
        }

kangxiaoshan committed
1192 1193
        List<Contract> contractList = new ArrayList<>();

kangxiaoshan committed
1194
        List<String> ids = new ArrayList<>(idsDic.keySet());
kangxiaoshan committed
1195

kangxiaoshan committed
1196
        Auth auth = authRepository.findByUser(loginAccount.getId());
manxiaoqiang committed
1197

kangxiaoshan committed
1198
        if (RoleEnum.FINANCE.getKey().equals(loginAccount.getRole())) {
kangxiaoshan committed
1199
            //财务  按签约主体查看
kangxiaoshan committed
1200
            List bodyids = JSONArray.fromObject(auth.getAuthExtend());
kangxiaoshan committed
1201

kangxiaoshan committed
1202 1203 1204
            if (!StringUtils.isEmpty(contractId)) {

                if (ids != null && ids.size() > 0) {
kangxiaoshan committed
1205
                    contractList = contractRepository.findByDsContractBody(startDate, endDate, platforms, bodyids, ids);
kangxiaoshan committed
1206 1207
                }
            } else {
kangxiaoshan committed
1208
                contractList = contractRepository.findByDsContractBody(startDate, endDate, platform, bodyids);
manxiaoqiang committed
1209 1210
            }

kangxiaoshan committed
1211
        } else if (RoleEnum.SALSEMAN.getKey().equals(loginAccount.getRole())) {
kangxiaoshan committed
1212
            //销售 按签约合同人查看
kangxiaoshan committed
1213

kangxiaoshan committed
1214
//            List salseid =  Arrays.asList(loginAccount.getAuthExtend().split(","));
kangxiaoshan committed
1215
            List salseid = JSONArray.fromObject(auth.getAuthExtend());
kangxiaoshan committed
1216

kangxiaoshan committed
1217
            if (!StringUtils.isEmpty(contractId)) {
kangxiaoshan committed
1218

kangxiaoshan committed
1219
                if (ids != null && ids.size() > 0) {
kangxiaoshan committed
1220
                    contractList = contractRepository.findByDsContractSalse(startDate, endDate, platforms, salseid, ids);
kangxiaoshan committed
1221
                }
kangxiaoshan committed
1222
            } else {
kangxiaoshan committed
1223
                contractList = contractRepository.findByDsContractSalse(startDate, endDate, platform, salseid);
kangxiaoshan committed
1224
            }
kangxiaoshan committed
1225

kangxiaoshan committed
1226
        } else {
kangxiaoshan committed
1227
            if (!StringUtils.isEmpty(contractId)) {
kangxiaoshan committed
1228

kangxiaoshan committed
1229
                if (ids != null && ids.size() > 0) {
kangxiaoshan committed
1230
                    contractList = contractRepository.findByDsRelation(startDate, endDate, platforms, ids);
kangxiaoshan committed
1231
                }
kangxiaoshan committed
1232
            } else {
kangxiaoshan committed
1233 1234
                contractList = contractRepository.findByDs(startDate, endDate, platform);
            }
manxiaoqiang committed
1235 1236
        }

kangxiaoshan committed
1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273

//        if (loginAccount.getRole().equals(RoleEnum.SOUTH_BUSSINUSS.getKey()) || loginAccount.getRole().equals(RoleEnum.NORTH_BUSSINUSS.getKey())) {
//
//            List<User> userList = userService.findAllSons(loginAccount.getId());
//            List<Long> idList = new ArrayList<>();
//            idList.add(loginAccount.getId());
//            for (User u : userList) {
//                idList.add(u.getId());
//            }
//
////            contractList = contractRepository.findByDsAndRoile(startDate, endDate, platfrom, idList);
//
//
//            if (!StringUtils.isEmpty(contractId)) {
//                //查看关联合同
//                if (ids != null && ids.size() > 0) {
//                    contractList = contractRepository.findByDsAndRoileRelation(startDate, endDate, platforms, idList, ids);
//                }
//
//            } else {
//                contractList = contractRepository.findByDsAndRoile(startDate, endDate, platform, idList);
//            }
//
//
//        } else {
////            contractList = contractRepository.findByDs(startDate, endDate, platform);
//
//            if (!StringUtils.isEmpty(contractId)) {
//                if (ids != null && ids.size() > 0) {
//                    contractList = contractRepository.findByDsRelation(startDate, endDate, platforms, ids);
//                }
//            } else {
//                contractList = contractRepository.findByDs(startDate, endDate, platform);
//            }
//
//        }

kangxiaoshan committed
1274 1275
        Map<String, String> saleMap = new HashMap();

kangxiaoshan committed
1276
        Map<String, PackageType> typeMap = new HashMap();
kangxiaoshan committed
1277 1278 1279 1280 1281 1282

        Map<String, PackageBase> packageBaseMap = new HashMap<>();

        // 获取字典数据
        this.getDicMapDatas(saleMap, typeMap, null, null, packageBaseMap, platform);

1  
kangxiaoshan committed
1283 1284
        Map<String, String> bodyMap = contractBodyRepository.findAllCodeDis().stream().collect(Collectors.toMap(ContractBody::getCode, ContractBody::getName));

1  
kangxiaoshan committed
1285
        Map<String, String> tradeTypeMap = tradeTypeRepsitory.findAll().stream().collect(Collectors.toMap(v -> v.getId().toString(), v -> v.getName()));
kangxiaoshan committed
1286

kangxiaoshan committed
1287 1288
        if (ValidateUtil.isValid(contractList)) {
            for (Contract c : contractList) {
1  
kangxiaoshan committed
1289
                c.setMyBodyName(bodyMap.get(c.getMyBodyCode()));
kangxiaoshan committed
1290
                c.setTradeName(tradeTypeMap.get(c.getTradeType() + ""));
1  
kangxiaoshan committed
1291

kangxiaoshan committed
1292
                if ((c.getExtraFlow() != null && c.getExtraFlow() > 0) ||
kangxiaoshan committed
1293 1294 1295 1296 1297 1298 1299 1300
                        (c.getDiscountTimeLong() != null && c.getDiscountTimeLong() > 0)) {

                    c.setHasDiscount("有");

                } else {
                    c.setHasDiscount("无");
                }

kangxiaoshan committed
1301
                if (c.getRelationContract() == null) {
kangxiaoshan committed
1302 1303 1304
                    c.setRelationContract(-1L);
                }

kangxiaoshan committed
1305
                if (ContractStatusEnum.MONEY_BACK_FIRST.getKey().equals(c.getStatus())) {
kangxiaoshan committed
1306 1307 1308
                    c.setStartDate(null);
                }

kangxiaoshan committed
1309

kangxiaoshan committed
1310 1311 1312 1313 1314 1315 1316
//                if (c.getType().equals(ContractTypeEnum.MAIN.getKey()) && platform.contains("io")) {
//
//                } else if (c.getType().equals(ContractTypeEnum.MAIN.getKey())) {
//                    c.setPriceLevelName(bpuMap.containsKey(c.getPriceLevel()) ? bpuMap.get(c.getPriceLevel()) : "");
//                } else {
//                    c.setPriceLevelName(incremenMap.containsKey(c.getPriceLevel()) ? incremenMap.get(c.getPriceLevel()) : "");
//                }
manxiaoqiang committed
1317

kangxiaoshan committed
1318
                c.setSaleName(saleMap.containsKey(c.getSale()) ? saleMap.get(c.getSale()) : "");
kangxiaoshan committed
1319

kangxiaoshan committed
1320
                if ("tkio".equals(platform)) {
kangxiaoshan committed
1321
                    c.setPriceLevelName(typeMap.containsKey(c.getPriceLevel()) ? typeMap.get(c.getPriceLevel()).getPackageName() : "");
kangxiaoshan committed
1322
                } else {
kangxiaoshan committed
1323

kangxiaoshan committed
1324
                    c.setPriceLevelName(packageBaseMap.get(c.getPriceLevel()) == null ? "" : packageBaseMap.get(c.getPriceLevel()).getPackageName());
kangxiaoshan committed
1325 1326
                }

kangxiaoshan committed
1327
//                c.setCreateName(saleMap.containsKey(c.getCreateAccount()) ? saleMap.get(c.getCreateAccount()) : "");
kangxiaoshan committed
1328

manxiaoqiang committed
1329 1330 1331 1332 1333
                result.add(c);
            }
        }
        return result;
    }
manxiaoqiang committed
1334

kangxiaoshan committed
1335

kangxiaoshan committed
1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351
    public void getDicMapDatas(Map saleMap, Map typeMap, Map incremenMap, Map bpuMap, Map packageBaseMap, String platform) {


        if (saleMap != null) {
            List<Sales> salesList = salesRepository.findAllByStatusOn();
            if (ValidateUtil.isValid(salesList)) {
                for (Sales s : salesList) {
                    saleMap.put(s.getId(), s.getName());
                }
            }
        }

        if (typeMap != null) {
            List<PackageType> typeList = packageTypeRepository.findAll();
            if (ValidateUtil.isValid(typeList)) {
                for (PackageType s : typeList) {
kangxiaoshan committed
1352
                    typeMap.put(s.getId(), s);
kangxiaoshan committed
1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394
                }
            }
        }

        if (incremenMap != null) {
            List<ContractIncrement> incrementList = contractIncrementRepository.findAll();
            if (ValidateUtil.isValid(incrementList)) {
                for (ContractIncrement s : incrementList) {
                    incremenMap.put(s.getId(), s.getPackageName());
                }
            }
        }


        if (bpuMap != null) {
            List<BPUContract> bpuContractList = bpuContractRepository.findAll();
            if (ValidateUtil.isValid(bpuContractList)) {
                for (BPUContract s : bpuContractList) {
                    bpuMap.put(s.getId(), s.getPackageName());
                }
            }
        }

        if (packageBaseMap != null) {

            List<PackageBase> packageBases = packageBaseRepository.findByPlatAndStatus(platform, 1);
            for (PackageBase base : packageBases) {
                packageBaseMap.put(base.getId(), base);
            }
        }


    }


    @Override
    public Contract findOne(User loginAccount, String startDate, String endDate, String platform, String contractId) {

        Contract contract = contractRepository.findOneByCode(platform, contractId);

        Map<String, String> saleMap = new HashMap();

kangxiaoshan committed
1395
        Map<String, PackageType> typeMap = new HashMap();
kangxiaoshan committed
1396 1397 1398 1399 1400 1401 1402 1403

        Map<String, PackageBase> packageBaseMap = new HashMap<>();

        // 获取字典数据
        this.getDicMapDatas(saleMap, typeMap, null, null, packageBaseMap, platform);

        contract.setSaleName(saleMap.containsKey(contract.getSale()) ? saleMap.get(contract.getSale()) : "");
        if ("tkio".equals(platform)) {
kangxiaoshan committed
1404
            contract.setPriceLevelName(typeMap.containsKey(contract.getPriceLevel()) ? typeMap.get(contract.getPriceLevel()).getPackageName() : "");
kangxiaoshan committed
1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415
        } else {

            contract.setPriceLevelName(packageBaseMap.get(contract.getPriceLevel()) == null ? "" : packageBaseMap.get(contract.getPriceLevel()).getPackageName());
        }

        contract.setCreateName(saleMap.containsKey(contract.getCreateAccount()) ? saleMap.get(contract.getCreateAccount()) : "");

        return contract;
    }

    private void getContractRelationIds(List<String> contractId, Map<String, String> idsDic) {
kangxiaoshan committed
1416 1417 1418 1419 1420 1421 1422

        //获取 关联合同 id
        List<String> contractIds = new ArrayList<>();

        List<BigInteger> ids = contractRelationRepository.findRelationIds(contractId);

        if (ids != null && ids.size() > 0) {
kangxiaoshan committed
1423
            for (BigInteger id : ids) {
kangxiaoshan committed
1424 1425 1426 1427

                String idss = id.toString();
                if (idsDic.get(idss) == null) {
                    contractIds.add(idss);
kangxiaoshan committed
1428
                    idsDic.put(idss, "0");
kangxiaoshan committed
1429 1430 1431
                }
            }

kangxiaoshan committed
1432
            if (contractIds.size() > 0) {
kangxiaoshan committed
1433
                //递归 查询 id  查询所有相关联的合同
kangxiaoshan committed
1434
                this.getContractRelationIds(contractIds, idsDic);
kangxiaoshan committed
1435 1436 1437 1438
            }
        }
    }

kangxiaoshan committed
1439

kangxiaoshan committed
1440
    @Override
kangxiaoshan committed
1441
    public Contract contractStatusUpdate(String platform, String contractId, String status, String ip, User loginUser) {
kangxiaoshan committed
1442

kangxiaoshan committed
1443
        if (StringUtils.isEmpty(contractId)) {
kangxiaoshan committed
1444 1445 1446 1447 1448
            return null;
        }

        Contract contract = contractRepository.findOne(Long.parseLong(contractId));

kangxiaoshan committed
1449 1450 1451 1452 1453 1454
        ChangeDelInfo changeDelInfo = new ChangeDelInfo();
        changeDelInfo.setContractCode(contract.getContractCode());
        changeDelInfo.setEmail(contract.getEmail());

        changeDelInfo.setEmail(contract.getEmail());

kangxiaoshan committed
1455
        if (ContractStatusEnum.CANCEL.getKey().equals(status)) {
kangxiaoshan committed
1456
            contract.setStatus(status);
kangxiaoshan committed
1457
            changeDelInfo.setDetail("废弃合同");
kangxiaoshan committed
1458
            changeDelInfo.setSourceId(contract.getId());
kangxiaoshan committed
1459
            this.saveChangeDelInfo(changeDelInfo, 4, 2, ip, loginUser); // type 2 修改
kangxiaoshan committed
1460

kangxiaoshan committed
1461
        } else {
kangxiaoshan committed
1462
            changeDelInfo.setDetail("删除合同");
kangxiaoshan committed
1463
            changeDelInfo.setOriginal(contract.getStatus());
kangxiaoshan committed
1464
            changeDelInfo.setSourceId(contract.getId());
kangxiaoshan committed
1465
            this.saveChangeDelInfo(changeDelInfo, 4, 1, ip, loginUser);
kangxiaoshan committed
1466
            contract.setStatus(ContractStatusEnum.DELETE.getKey());
kangxiaoshan committed
1467

kangxiaoshan committed
1468 1469 1470 1471 1472
        }

        return contractRepository.save(contract);
    }

manxiaoqiang committed
1473 1474 1475 1476 1477 1478
    @Override
    public Contract findOne(String code) {

        List<Contract> result = new ArrayList<>();
        List<User> sales = userRepository.findAll();
        Map<Long, String> saleMap = new HashMap<>();
kangxiaoshan committed
1479 1480
        if (ValidateUtil.isValid(sales)) {
            for (User s : sales) {
manxiaoqiang committed
1481 1482 1483 1484 1485
                saleMap.put(s.getId(), s.getName());
            }
        }
        List<PackageType> typeList = packageTypeRepository.findAll();
        Map<Long, String> typeMap = new HashMap<>();
kangxiaoshan committed
1486 1487
        if (ValidateUtil.isValid(typeList)) {
            for (PackageType s : typeList) {
manxiaoqiang committed
1488 1489 1490
                typeMap.put(s.getId(), s.getPackageName());
            }
        }
2  
manxiaoqiang committed
1491 1492
        List<ContractIncrement> incrementList = contractIncrementRepository.findAll();
        Map<Long, String> incremenMap = new HashMap<>();
kangxiaoshan committed
1493 1494
        if (ValidateUtil.isValid(incrementList)) {
            for (ContractIncrement s : incrementList) {
2  
manxiaoqiang committed
1495 1496 1497
                incremenMap.put(s.getId(), s.getPackageName());
            }
        }
manxiaoqiang committed
1498 1499
        Contract contract = contractRepository.findByCode(code);
        contract.setSaleName(saleMap.containsKey(contract.getSale()) ? saleMap.get(contract.getSale()) : "");
kangxiaoshan committed
1500
        if (contract.getType().equals(ContractTypeEnum.MAIN.getKey())) {
2  
manxiaoqiang committed
1501
            contract.setPriceLevelName(typeMap.containsKey(contract.getPriceLevel()) ? typeMap.get(contract.getPriceLevel()) : "");
kangxiaoshan committed
1502
        } else {
2  
manxiaoqiang committed
1503 1504
            contract.setPriceLevelName(incremenMap.containsKey(contract.getPriceLevel()) ? incremenMap.get(contract.getPriceLevel()) : "");
        }
manxiaoqiang committed
1505
        contract.setCreateName(saleMap.containsKey(contract.getCreateAccount()) ? saleMap.get(contract.getCreateAccount()) : "");
manxiaoqiang committed
1506

manxiaoqiang committed
1507
        Boolean flag = null;
kangxiaoshan committed
1508
        if (!contract.getType().equals(ContractTypeEnum.MAIN.getKey())) {
2  
manxiaoqiang committed
1509 1510 1511 1512 1513 1514
            //人群分析
            if (null == contract.getEndDate()) {
                flag = checkTime(contract.getEmail(), contract.getPlatform(), contract.getType(), "black");
            } else {
                flag = checkTime(contract.getEmail(), contract.getPlatform(), contract.getType(), "analysis");
            }
manxiaoqiang committed
1515

2  
manxiaoqiang committed
1516 1517 1518 1519 1520
            if (flag) {
                contract.setContractType("0");
            } else {
                contract.setContractType("1");
            }
manxiaoqiang committed
1521
        }
manxiaoqiang committed
1522 1523 1524
        return contract;
    }

manxiaoqiang committed
1525 1526
    @Override
    public ContractMoney pay(User loginUser, ContractMoney resource) {
kangxiaoshan committed
1527 1528 1529 1530
//        Contract contract = contractRepository.findByCode(resource.getContractCode());

        Contract contract = contractRepository.findOne(resource.getId());

kangxiaoshan committed
1531
        if (resource.getType().equals("pay")) {
kangxiaoshan committed
1532
            contract.setPayMoney(contract.getPayMoney() + resource.getMoney());
kangxiaoshan committed
1533
            //判断回款状态
kangxiaoshan committed
1534
            this.dealContractStatus(contract, loginUser, "update");
manxiaoqiang committed
1535
        } else {
kangxiaoshan committed
1536
            contract.setInvoiceMoney(contract.getInvoiceMoney().add(new BigDecimal(resource.getMoney().toString())));
manxiaoqiang committed
1537
        }
2  
manxiaoqiang committed
1538

kangxiaoshan committed
1539
        if (ContractTypeEnum.INCREMENT.getKey().equals(contract.getType())) {
2  
manxiaoqiang committed
1540 1541
            contract.setStatus("end");
        }
manxiaoqiang committed
1542 1543
        contractRepository.save(contract);

kangxiaoshan committed
1544 1545 1546 1547
        resource.setPriceLevel(contract.getPriceLevel());
        resource.setSalse(contract.getSale());
        resource.setCompany(contract.getCustomerBody());
        resource.setCreateName(loginUser.getName());
2  
manxiaoqiang committed
1548 1549 1550 1551
        resource.setPlatform(contract.getPlatform());
        resource.setCreateAccount(loginUser.getId());
        resource.setCreateTime(new Date());
        resource.setUser(loginUser.getId());
kangxiaoshan committed
1552 1553
        resource.setContractCode(contract.getContractCode());
        resource.setEmail(contract.getEmail());
manxiaoqiang committed
1554

kangxiaoshan committed
1555 1556 1557 1558 1559
//        if (resource.getType().equals("pay") && contract.getPlatform().equals("tkio")) {
//            tkioAccountService.contractPay(loginUser, resource);
//        } else if (resource.getType().equals("pay") && contract.getPlatform().equals("io")) {
//            ioAccountService.contractPay(loginUser, resource);
//        }
manxiaoqiang committed
1560 1561 1562 1563
        return contractMoneyRepository.save(resource);
    }

    @Override
kangxiaoshan committed
1564
    public Contract change(User loginUser, ContractChange resource, FlowChange flowChange) {
kangxiaoshan committed
1565

manxiaoqiang committed
1566
        Map<Long, String> saleMap = getSaleMap();
manxiaoqiang committed
1567
        Contract contract = contractRepository.findByCode(resource.getContractCode());
kangxiaoshan committed
1568
        Map<Long, String> packageMap = getPackageMap(contract);
kangxiaoshan committed
1569 1570 1571 1572
//        ChangeDelInfo changeDelInfo = new ChangeDelInfo();
//        changeDelInfo.setContractCode(contract.getContractCode());
//        changeDelInfo.setEmail(contract.getEmail());

kangxiaoshan committed
1573
        if (resource.getType().equals("price")) {
manxiaoqiang committed
1574

kangxiaoshan committed
1575 1576
            resource.setContent(packageMap.get(contract.getPriceLevel()) + "改为" + packageMap.get(resource.getLevel()));
            resource.setMarke(contract.getMoney() + "元改为" + resource.getMoney() + "元");
kangxiaoshan committed
1577
            contract.setMoney(resource.getMoney());
manxiaoqiang committed
1578
            contract.setPriceLevel(resource.getLevel());
kangxiaoshan committed
1579

kangxiaoshan committed
1580
            // 处理回款状态
kangxiaoshan committed
1581
            this.dealContractStatus(contract, loginUser, "update");
kangxiaoshan committed
1582

manxiaoqiang committed
1583

kangxiaoshan committed
1584
        } else if ("give".equals(resource.getType())) {
kangxiaoshan committed
1585
            //变更优惠记录
kangxiaoshan committed
1586
            this.saveFlowChange(contract, loginUser, "save", resource.getDiscountTimeLong(), resource.getExtraFlow());
kangxiaoshan committed
1587 1588
            // 累加 合同表中数据

kangxiaoshan committed
1589 1590
            if (resource.getExtraFlow() != null) {
                contract.setExtraFlow(contract.getExtraFlow() + resource.getExtraFlow());
kangxiaoshan committed
1591 1592
            }

kangxiaoshan committed
1593 1594
            if (resource.getDiscountTimeLong() != null) {
                contract.setDiscountTimeLong(contract.getDiscountTimeLong() + resource.getDiscountTimeLong());
kangxiaoshan committed
1595
            }
kangxiaoshan committed
1596

kangxiaoshan committed
1597
        } else {
kangxiaoshan committed
1598 1599 1600 1601 1602 1603 1604
//            //同步修改trackingio的数据
//            if (contract.getPlatform().equals("tkio") && contract.getType().equals("main")) {
//                accountService.forbiden(contract);
//            } else if (contract.getPlatform().equals("io") && contract.getType().equals("main")) {
//                accountIOService.update(contract);
//            }
            //状态变更
kangxiaoshan committed
1605
            resource.setContent("作废");
manxiaoqiang committed
1606 1607
            contract.setStatus("cancel");
        }
manxiaoqiang committed
1608
        resource.setPlatform(contract.getPlatform());
manxiaoqiang committed
1609 1610 1611 1612
        resource.setCreateAccount(loginUser.getId());
        resource.setCreateTime(new Date());
        resource.setDs(DateUtil.getBeforeDays(0));
        resource.setUser(loginUser.getId());
kangxiaoshan committed
1613

kangxiaoshan committed
1614
        if (!"give".equals(resource.getType())) {
kangxiaoshan committed
1615 1616
            contractChangeRepository.save(resource);
        }
manxiaoqiang committed
1617 1618 1619 1620

        return contractRepository.save(contract);
    }

kangxiaoshan committed
1621 1622

    @Override
kangxiaoshan committed
1623 1624 1625
    public Object changesDel(String platform, String id, String type, String ip, User loginUser) {


kangxiaoshan committed
1626
        if ("give".equals(type)) {
kangxiaoshan committed
1627 1628 1629 1630
            // 优惠流量
            FlowChange change = flowChangeRepository.findOne(Long.parseLong(id));
            change.setDelFlag(1);
            flowChangeRepository.save(change);
kangxiaoshan committed
1631 1632 1633 1634

            ChangeDelInfo changeDelInfo = new ChangeDelInfo();
            changeDelInfo.setContractCode(change.getContractCode());
            changeDelInfo.setEmail(change.getEmail());
kangxiaoshan committed
1635
            changeDelInfo.setSourceId(change.getId());
kangxiaoshan committed
1636
            changeDelInfo.setDetail("赠送时长:" + change.getDiscountTimeLong() + "天 — 赠送流量" + change.getDiscountFlow());
kangxiaoshan committed
1637

kangxiaoshan committed
1638
            this.saveChangeDelInfo(changeDelInfo, 1, 1, ip, loginUser);
kangxiaoshan committed
1639

kangxiaoshan committed
1640
            return change;
kangxiaoshan committed
1641
        } else if ("change".equals(type)) {
kangxiaoshan committed
1642 1643 1644 1645
            //套餐变更
            ContractChange contractChange = contractChangeRepository.findOne(Long.parseLong(id));
            contractChange.setDelFlag(1);
            contractChangeRepository.save(contractChange);
kangxiaoshan committed
1646

kangxiaoshan committed
1647 1648 1649 1650
            ChangeDelInfo changeDelInfo = new ChangeDelInfo();
            changeDelInfo.setContractCode(contractChange.getContractCode());
            changeDelInfo.setDetail("套餐变更");
            changeDelInfo.setEmail(contractChange.getEmail());
kangxiaoshan committed
1651
            changeDelInfo.setSourceId(contractChange.getId());
kangxiaoshan committed
1652
            this.saveChangeDelInfo(changeDelInfo, 2, 1, ip, loginUser);
kangxiaoshan committed
1653

kangxiaoshan committed
1654
            return contractChange;
kangxiaoshan committed
1655
        } else {
kangxiaoshan committed
1656

kangxiaoshan committed
1657 1658 1659
            ContractMoney contractMoney = contractMoneyRepository.findOne(Long.parseLong(id));
            contractMoney.setDelFlag(1);
            contractMoneyRepository.save(contractMoney);
kangxiaoshan committed
1660

kangxiaoshan committed
1661 1662 1663
            ChangeDelInfo changeDelInfo = new ChangeDelInfo();
            changeDelInfo.setContractCode(contractMoney.getContractCode());
            changeDelInfo.setEmail(contractMoney.getEmail());
kangxiaoshan committed
1664
            changeDelInfo.setSourceId(contractMoney.getId());
kangxiaoshan committed
1665

kangxiaoshan committed
1666
            if ("pay".equals(contractMoney.getType())) {
kangxiaoshan committed
1667

kangxiaoshan committed
1668 1669
                this.dealPayMoneyByContractMoney(contractMoney, -1);
                changeDelInfo.setDetail("收款记录-金额:" + contractMoney.getMoney());
kangxiaoshan committed
1670

kangxiaoshan committed
1671 1672
            } else {
                changeDelInfo.setDetail("开票记录-金额:" + contractMoney.getMoney());
kangxiaoshan committed
1673 1674
            }

kangxiaoshan committed
1675
            this.saveChangeDelInfo(changeDelInfo, 3, 1, ip, loginUser);
kangxiaoshan committed
1676

kangxiaoshan committed
1677 1678 1679 1680 1681
            return contractMoney;
        }

    }

kangxiaoshan committed
1682
    private void dealPayMoneyByContractMoney(ContractMoney contractMoney, int addOr) {
kangxiaoshan committed
1683 1684 1685
        // 删除收款记录 修改相应收款金额
        // 恢复收款记录 修改相应合同收款金额
        Contract contract = contractRepository.findByCode(contractMoney.getContractCode());
kangxiaoshan committed
1686
        contract.setPayMoney(contract.getPayMoney() + contractMoney.getMoney() * addOr);
kangxiaoshan committed
1687 1688 1689 1690
        contractRepository.save(contract);
    }


kangxiaoshan committed
1691
    @Override
kangxiaoshan committed
1692
    public List<ChangeDelInfo> getChangeDelData(User loginAccount, String contranctCode, String startDate, String endDate) {
kangxiaoshan committed
1693

kangxiaoshan committed
1694
        List<ChangeDelInfo> datas = changeDelInfoRepository.findOnStartDate(startDate, endDate);
kangxiaoshan committed
1695 1696 1697 1698 1699
        return datas;
    }


    @Override
kangxiaoshan committed
1700
    public List<ChangeDelDetail> getChangeDelDetailData(User loginAccount, String pid) {
kangxiaoshan committed
1701 1702 1703 1704 1705

        List<ChangeDelDetail> datas = changeDelDetailRepository.findByPid(pid);
        return datas;
    }

kangxiaoshan committed
1706 1707

    @Override
kangxiaoshan committed
1708
    public ChangeDelInfo changesDelRecover(String id, String type, User loginAccount) {
kangxiaoshan committed
1709 1710 1711
        // 恢复删除

        ChangeDelInfo changeDelInfo = changeDelInfoRepository.findOne(Long.parseLong(id));
kangxiaoshan committed
1712
        if (changeDelInfo.getModifyType() == 1) {
kangxiaoshan committed
1713 1714 1715 1716
//            put("1","流量赠送");
//            put("2","合同变更记录");
//            put("3","收款/开票记录");
//            put("4","合同管理");
kangxiaoshan committed
1717
            if (changeDelInfo.getFunction() == 1) {
kangxiaoshan committed
1718 1719 1720
                FlowChange change = flowChangeRepository.findOne(changeDelInfo.getSourceId());
                change.setDelFlag(0);
                flowChangeRepository.save(change);
kangxiaoshan committed
1721
            } else if (changeDelInfo.getFunction() == 2) {
kangxiaoshan committed
1722 1723 1724
                ContractChange contractChange = contractChangeRepository.findOne(changeDelInfo.getSourceId());
                contractChange.setDelFlag(0);
                contractChangeRepository.save(contractChange);
kangxiaoshan committed
1725
            } else if (changeDelInfo.getFunction() == 3) {
kangxiaoshan committed
1726 1727 1728
                //
                ContractMoney money = contractMoneyRepository.findOne(changeDelInfo.getSourceId());
                String detail = changeDelInfo.getDetail();
kangxiaoshan committed
1729
                if (detail != null && detail.startsWith("收款")) {
kangxiaoshan committed
1730
                    //恢复收款记录 修改相应合同收款金额
kangxiaoshan committed
1731
                    dealPayMoneyByContractMoney(money, 1);
kangxiaoshan committed
1732 1733 1734
                }
                money.setDelFlag(0);
                contractMoneyRepository.save(money);
kangxiaoshan committed
1735
            } else if (changeDelInfo.getFunction() == 4) {
kangxiaoshan committed
1736 1737 1738 1739 1740 1741
                // 合同恢复
                Contract contract = contractRepository.findOne(changeDelInfo.getSourceId());
                contract.setStatus(changeDelInfo.getOriginal());
                contractRepository.save(contract);

            }
kangxiaoshan committed
1742 1743

            changeDelInfoRepository.delete(changeDelInfo);
kangxiaoshan committed
1744 1745 1746 1747 1748
        }

        return null;
    }

kangxiaoshan committed
1749
    public void saveChangeDelInfo(ChangeDelInfo changeDelInfo, int function, int type, String ip, User loginUser) {
kangxiaoshan committed
1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761

        changeDelInfo.setCreatTime(new Date());
        changeDelInfo.setFunction(function);// 1 赠送记录
        changeDelInfo.setModifyType(type);// 1 删除
        changeDelInfo.setIp(ip);
        changeDelInfo.setDs(new DateTime().toString("yyyy-MM-dd"));
        changeDelInfo.setModifyAccount(loginUser.getName());
        changeDelInfo.setModifyId(loginUser.getId());
        changeDelInfoRepository.save(changeDelInfo);

    }

manxiaoqiang committed
1762 1763 1764 1765
    @Override
    public List<ContractMoney> findPay(String startDate, String endDate, String code) {
        List<User> sales = userRepository.findAll();
        Map<Long, String> saleMap = new HashMap<>();
kangxiaoshan committed
1766 1767
        if (ValidateUtil.isValid(sales)) {
            for (User s : sales) {
manxiaoqiang committed
1768 1769 1770 1771
                saleMap.put(s.getId(), s.getName());
            }
        }

kangxiaoshan committed
1772 1773 1774 1775
        List<ContractMoney> result = new ArrayList<>();
        List<ContractMoney> list = contractMoneyRepository.findByDs(startDate, endDate, code);
        if (ValidateUtil.isValid(list)) {
            for (ContractMoney cm : list) {
manxiaoqiang committed
1776 1777 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787
                cm.setCreateName(saleMap.containsKey(cm.getUser()) ? saleMap.get(cm.getUser()) : "");
                result.add(cm);
            }
        }
        return result;
    }

    @Override
    public List<ContractChange> findChange(String startDate, String endDate, String code) {

        List<User> sales = userRepository.findAll();
        Map<Long, String> saleMap = new HashMap<>();
kangxiaoshan committed
1788 1789
        if (ValidateUtil.isValid(sales)) {
            for (User s : sales) {
manxiaoqiang committed
1790 1791 1792 1793
                saleMap.put(s.getId(), s.getName());
            }
        }

kangxiaoshan committed
1794 1795 1796 1797
        List<ContractChange> result = new ArrayList<>();
        List<ContractChange> list = contractChangeRepository.findByDs(startDate, endDate, code);
        if (ValidateUtil.isValid(list)) {
            for (ContractChange cm : list) {
manxiaoqiang committed
1798 1799 1800 1801
                cm.setCreateName(saleMap.containsKey(cm.getUser()) ? saleMap.get(cm.getUser()) : "");
                result.add(cm);
            }
        }
kangxiaoshan committed
1802

manxiaoqiang committed
1803 1804 1805
        return result;
    }

kangxiaoshan committed
1806 1807
    @Override
    public List<FlowChange> findflowChange(String startDate, String endDate, String code) {
kangxiaoshan committed
1808
        return flowChangeRepository.findByAddDate(startDate, endDate, code);
kangxiaoshan committed
1809 1810
    }

manxiaoqiang committed
1811
    @Override
kangxiaoshan committed
1812
    public Contract updatePay(User loginUser, ContractMoney resource, String ip) {
manxiaoqiang committed
1813 1814
        ContractMoney contractMoney = contractMoneyRepository.findOne(resource.getId());
        Contract contract = contractRepository.findByCode(resource.getContractCode());
kangxiaoshan committed
1815 1816 1817 1818 1819 1820 1821

        ChangeDelInfo changeDelInfo = new ChangeDelInfo();

        ChangeDelDetail delDetail = new ChangeDelDetail();
        delDetail.setBeforeValue(contractMoney.getMoney().toString());
        delDetail.setAfterValue(resource.getMoney().toString());

kangxiaoshan committed
1822
        if (contractMoney.getType().equals("pay")) {
manxiaoqiang committed
1823
            contract.setPayMoney(contract.getPayMoney() + resource.getMoney() - contractMoney.getMoney());
kangxiaoshan committed
1824 1825 1826 1827

            delDetail.setItem("收款");
            delDetail.setDetail("收款金额");

manxiaoqiang committed
1828
        } else {
kangxiaoshan committed
1829 1830
//            contract.setInvoice(contract.getInvoice() + resource.getMoney() - contractMoney.getMoney());
            contract.setInvoiceMoney(contract.getInvoiceMoney().add(new BigDecimal(resource.getMoney())).subtract(new BigDecimal(contractMoney.getMoney())));
kangxiaoshan committed
1831 1832
            delDetail.setItem("开票");
            delDetail.setDetail("开票金额");
manxiaoqiang committed
1833
        }
kangxiaoshan committed
1834 1835 1836 1837

        changeDelInfo.setDetail("修改详情");//
        changeDelInfo.setContractCode(contractMoney.getContractCode());
        changeDelInfo.setEmail(contractMoney.getEmail());
kangxiaoshan committed
1838
        this.saveChangeDelInfo(changeDelInfo, 3, 2, ip, loginUser);
kangxiaoshan committed
1839 1840 1841 1842 1843 1844 1845 1846

        delDetail.setCreatTime(new Date());
        delDetail.setContractCode(contractMoney.getContractCode());
        delDetail.setEmail(contractMoney.getEmail());
        delDetail.setParentId(changeDelInfo.getId());

        changeDelDetailRepository.save(delDetail);

manxiaoqiang committed
1847 1848 1849 1850 1851
        Contract save = contractRepository.save(contract);

        contractMoney.setModifyAccount(loginUser.getId());
        contractMoney.setModifyTime(new Date());
        contractMoney.setMoney(resource.getMoney());
kangxiaoshan committed
1852
//        contractMoney.setDs(resource.getDs());
manxiaoqiang committed
1853 1854 1855 1856
        contractMoneyRepository.save(contractMoney);

        List<User> sales = userRepository.findAll();
        Map<Long, String> saleMap = new HashMap<>();
kangxiaoshan committed
1857 1858
        if (ValidateUtil.isValid(sales)) {
            for (User s : sales) {
manxiaoqiang committed
1859 1860 1861 1862
                saleMap.put(s.getId(), s.getName());
            }
        }

kangxiaoshan committed
1863
        Map<Long, String> typeMap = this.getPackageMap(contract);
manxiaoqiang committed
1864 1865 1866 1867 1868
        save.setSaleName(saleMap.containsKey(save.getSale()) ? saleMap.get(save.getSale()) : "");
        save.setPriceLevelName(typeMap.containsKey(save.getPriceLevel()) ? typeMap.get(save.getPriceLevel()) : "");
        save.setCreateName(saleMap.containsKey(save.getSale()) ? saleMap.get(save.getSale()) : "");
        return save;
    }
manxiaoqiang committed
1869

kangxiaoshan committed
1870

kangxiaoshan committed
1871 1872 1873 1874 1875
//    public List<ContractMoney> findPayAll(String startDate, String endDate, String platfrom) {
//
//        return this.findPayAll(startDate,endDate,platfrom,"all","all", null);
//    }

kangxiaoshan committed
1876 1877

    @Override
kangxiaoshan committed
1878
    public List<ContractMoney> findPayAll(User loginAccount, String startDate, String endDate, String platfrom, String moneyType, String packageTypeSearch, String money_ids) {
kangxiaoshan committed
1879

kangxiaoshan committed
1880
        Map<Long, PackageType> packageTypeMap = new HashMap<>();
manxiaoqiang committed
1881
        Map<Long, String> saleMap = new HashMap<>();
kangxiaoshan committed
1882
        Map<Long, PackageBase> packageBaseMap = new HashMap<>();
kangxiaoshan committed
1883

kangxiaoshan committed
1884
        this.getDicMapDatas(saleMap, packageTypeMap, null, null, packageBaseMap, platfrom);
kangxiaoshan committed
1885

kangxiaoshan committed
1886
        List<ContractMoney> result = new ArrayList<>();
kangxiaoshan committed
1887 1888 1889

        List<ContractMoney> list;

kangxiaoshan committed
1890
        if ("-1".equals(money_ids)) {
kangxiaoshan committed
1891 1892 1893

            list = new ArrayList<>();

kangxiaoshan committed
1894 1895 1896 1897 1898 1899 1900 1901 1902
        } else if (!StringUtil.isEmpty(money_ids)) {
            list = contractMoneyRepository.findByDsAllContractMoneyIds(startDate, endDate, platfrom, Arrays.asList(money_ids.split(",")));
        } else if (!"all".equals(moneyType) && !"all".equals(packageTypeSearch)) {
            list = contractMoneyRepository.findByDsAllContractAll(startDate, endDate, platfrom, moneyType, packageTypeSearch);
        } else if (!"all".equals(moneyType)) {
            list = contractMoneyRepository.findByDsAllContractMoneyType(startDate, endDate, platfrom, moneyType);
        } else if (!"all".equals(packageTypeSearch)) {
            list = contractMoneyRepository.findByDsAllContractPkSearch(startDate, endDate, platfrom, packageTypeSearch);
        } else {
kangxiaoshan committed
1903 1904 1905
            list = contractMoneyRepository.findByDsAllContract(startDate, endDate, platfrom);
        }

kangxiaoshan committed
1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917
        // 权限过滤

        Map<String, Object> authdata = authService.getAuthExtends(loginAccount);

        if (authdata.get("needcheck") != null) {

            List<String> codesList = list.stream().map(p -> p.getContractCode()).collect(Collectors.toList());

//            contract_code,my_body_code,sale,platform

            if (RoleEnum.FINANCE.getKey().equals(loginAccount.getRole())) {

kangxiaoshan committed
1918
                list = filterContractMoney(codesList, authdata, list, 1);
kangxiaoshan committed
1919

kangxiaoshan committed
1920
            } else if (RoleEnum.SALSEMAN.getKey().equals(loginAccount.getRole())) {
kangxiaoshan committed
1921

1922
                list = filterContractMoney(codesList, authdata, list, 2);
kangxiaoshan committed
1923
            } else if (RoleEnum.PM.getKey().equals(loginAccount.getRole())) {
kangxiaoshan committed
1924

kangxiaoshan committed
1925
                list = filterContractMoney(codesList, authdata, list, 3);
kangxiaoshan committed
1926 1927 1928 1929
            }

        }

kangxiaoshan committed
1930 1931
        if (ValidateUtil.isValid(list)) {
            for (ContractMoney cm : list) {
kangxiaoshan committed
1932 1933 1934 1935 1936 1937 1938

                cm.setSalseName(saleMap.get(cm.getSalse()));

                if ("tkio".equals(platfrom)) {

                    PackageType packageType = packageTypeMap.get(cm.getPriceLevel());

kangxiaoshan committed
1939 1940
                    if (packageType != null) {
                        String flow = packageType.getTrackFlow().intValue() < 0 ? "无限制" : packageType.getTrackFlow().intValue() / 10000 + "万/年";
kangxiaoshan committed
1941

kangxiaoshan committed
1942
                        cm.setPackageName(packageType.getPackageName() + ": 流量" + flow + " APP" + packageType.getAppNum() + "个");
kangxiaoshan committed
1943

kangxiaoshan committed
1944
                    } else {
kangxiaoshan committed
1945 1946 1947 1948
                        cm.setPackageName("");
                    }

                } else {
kangxiaoshan committed
1949
                    cm.setPackageName(packageBaseMap.get(cm.getPriceLevel()) == null ? "" : packageBaseMap.get(cm.getPriceLevel()).getPackageName());
kangxiaoshan committed
1950 1951
                }

manxiaoqiang committed
1952 1953
            }
        }
kangxiaoshan committed
1954
        return list;
manxiaoqiang committed
1955
    }
manxiaoqiang committed
1956

1957
    private List<ContractMoney> filterContractMoney(List<String> codesList, Map<String, Object> authdata, List<ContractMoney> list, int nextIndex) {
kangxiaoshan committed
1958

kangxiaoshan committed
1959
        if (codesList == null || codesList.size() == 0) {
1960
            return list;
kangxiaoshan committed
1961 1962
        }

kangxiaoshan committed
1963 1964
        List<Object[]> contactdata = contractRepository.findByContractCode(codesList);

kangxiaoshan committed
1965 1966 1967
        if (contactdata != null) {
            Map<String, String> dicdata = contactdata.stream().
                    collect(Collectors.toMap(p -> p[0].toString(), p -> p[nextIndex] == null ? "all" : p[nextIndex].toString(), (key1, key2) -> key1));
kangxiaoshan committed
1968

kangxiaoshan committed
1969
            return list.stream().filter(p ->
kangxiaoshan committed
1970
                    authdata.get(dicdata.get(p.getContractCode())) == null ? false : true
kangxiaoshan committed
1971
                            || "all".equals(authdata.get(dicdata.get(p.getContractCode())))).collect(Collectors.toList());
kangxiaoshan committed
1972

kangxiaoshan committed
1973
        } else {
kangxiaoshan committed
1974

kangxiaoshan committed
1975
            return list;
kangxiaoshan committed
1976

kangxiaoshan committed
1977 1978
        }

kangxiaoshan committed
1979 1980 1981

    }

kangxiaoshan committed
1982 1983 1984 1985 1986 1987
    @Override
    public List<TradeType> getTradeData(String platform) {
        return tradeTypeRepsitory.findAll();
    }

    @Override
kangxiaoshan committed
1988
    public List<Map> contractCodeAll(String platform, String contractId) {
kangxiaoshan committed
1989

kangxiaoshan committed
1990 1991 1992
        Map<String, String> data = new HashMap<>();
        data.put("id", "-1");
        data.put("contractCode", "无");
kangxiaoshan committed
1993 1994 1995

        List result = new ArrayList();
        result.add(data);
kangxiaoshan committed
1996 1997 1998 1999 2000

        List<String> plats = new ArrayList<>();

        plats.add(platform);

kangxiaoshan committed
2001
        if ("fake".equals(platform)) {
kangxiaoshan committed
2002 2003 2004 2005
            plats.add("tkio");
        }

        List<ContractRelation> ids = null;
kangxiaoshan committed
2006
        Contract contract = null;
kangxiaoshan committed
2007 2008
        if (!StringUtils.isEmpty(contractId) && !contractId.equals("null")) {
            ids = contractRelationRepository.findRelationIdsMain(contractId);
kangxiaoshan committed
2009
            contract = contractRepository.findOne(Long.parseLong(contractId));
kangxiaoshan committed
2010 2011 2012 2013
        }

        if (ids != null) {

kangxiaoshan committed
2014
            // 已关联合同 字典
kangxiaoshan committed
2015 2016
            Map<String, String> filterMap = new HashMap();
            for (ContractRelation relation : ids) {
kangxiaoshan committed
2017

kangxiaoshan committed
2018 2019
                if (contract != null && !relation.getRelationId().equals(contract.getRelationContract())) {
                    filterMap.put(relation.getRelationId() + "_", "");
kangxiaoshan committed
2020 2021
                }

kangxiaoshan committed
2022 2023
            }

kangxiaoshan committed
2024
            // 所有可关联合同
kangxiaoshan committed
2025
            List<Map> resultBefore = contractRepository.contractCodePlatform(plats);
kangxiaoshan committed
2026
            for (Map m : resultBefore) {
kangxiaoshan committed
2027 2028

                String m_id = m.get("id").toString() + "_";
kangxiaoshan committed
2029
                if (filterMap.get(m_id) == null && !m_id.equals(contractId + "_")) {
kangxiaoshan committed
2030 2031 2032 2033 2034 2035
                    result.add(m);
                }
            }
        } else {
            result.addAll(contractRepository.contractCodePlatform(plats));
        }
kangxiaoshan committed
2036 2037

        return result;
kangxiaoshan committed
2038
    }
manxiaoqiang committed
2039

kangxiaoshan committed
2040 2041 2042 2043 2044
    @Override
    public Map contractCodeCheck(String platform, String contractCode) {

        Contract contractExist = contractRepository.findByCodePlatform(contractCode, platform);

kangxiaoshan committed
2045
        Map<String, String> data = new HashMap<>();
kangxiaoshan committed
2046

kangxiaoshan committed
2047 2048 2049 2050
        if (contractExist != null) {
            data.put("exist", "true");
        } else {
            data.put("exist", "false");
kangxiaoshan committed
2051 2052 2053 2054
        }
        return data;
    }

kangxiaoshan committed
2055
    public Map<Long, String> getPackageMap(Contract contract) {
kangxiaoshan committed
2056
//        List<PackageType> typeList = packageTypeRepository.findAll();
kangxiaoshan committed
2057 2058 2059

        String platform = contract.getPlatform();

kangxiaoshan committed
2060
        if ("trackio".equals(platform)) {
kangxiaoshan committed
2061 2062 2063 2064 2065 2066
            List<PackageType> typeList = packageTypeRepository.findIsNewAll();
            Map<Long, String> typeMap = new HashMap<>();
            if (ValidateUtil.isValid(typeList)) {
                for (PackageType s : typeList) {
                    typeMap.put(s.getId(), s.getPackageName());
                }
manxiaoqiang committed
2067
            }
kangxiaoshan committed
2068 2069

            return typeMap;
kangxiaoshan committed
2070
        } else {
kangxiaoshan committed
2071

kangxiaoshan committed
2072
            List<PackageBase> packageBases = packageBaseRepository.findByPlatAndStatus(platform, 1);
kangxiaoshan committed
2073 2074 2075

            Map<Long, String> typeMap = new HashMap<>();
            for (PackageBase packageBase : packageBases) {
kangxiaoshan committed
2076
                typeMap.put(packageBase.getId(), packageBase.getPackageName());
kangxiaoshan committed
2077 2078 2079 2080

            }

            return typeMap;
manxiaoqiang committed
2081
        }
kangxiaoshan committed
2082

manxiaoqiang committed
2083 2084
    }

kangxiaoshan committed
2085
    public Map<Long, String> getSaleMap() {
manxiaoqiang committed
2086 2087
        List<User> sales = userRepository.findAll();
        Map<Long, String> saleMap = new HashMap<>();
kangxiaoshan committed
2088 2089
        if (ValidateUtil.isValid(sales)) {
            for (User s : sales) {
manxiaoqiang committed
2090 2091 2092 2093 2094
                saleMap.put(s.getId(), s.getName());
            }
        }
        return saleMap;
    }
manxiaoqiang committed
2095

kangxiaoshan committed
2096

kangxiaoshan committed
2097
    public static Map<String, String> convertBean(Object bean) throws IntrospectionException, IllegalArgumentException, IllegalAccessException, InvocationTargetException {
manxiaoqiang committed
2098
        Class type = bean.getClass();
kangxiaoshan committed
2099
        Map<String, String> returnMap = new HashMap<String, String>();
manxiaoqiang committed
2100 2101
        BeanInfo beanInfo = Introspector.getBeanInfo(type);

kangxiaoshan committed
2102 2103
        PropertyDescriptor[] propertyDescriptors = beanInfo.getPropertyDescriptors();
        for (int i = 0; i < propertyDescriptors.length; i++) {
manxiaoqiang committed
2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123
            PropertyDescriptor descriptor = propertyDescriptors[i];
            String propertyName = descriptor.getName();
            if (!propertyName.equals("class")) {
                Method readMethod = descriptor.getReadMethod();

                Object invoke = readMethod.invoke(bean, new Object[0]);
                String result = (null == invoke ? null : invoke.toString());

                if (result != null) {
                    returnMap.put(propertyName, result);
                } else {
                    returnMap.put(propertyName, null);
                }


            }
        }
        return returnMap;
    }

kangxiaoshan committed
2124

kangxiaoshan committed
2125 2126 2127 2128 2129 2130 2131 2132 2133 2134 2135
    @Override
    public ResultModel uploadBatchInfo(MultipartFile file, String platform) {
        InputStream stream = null;
        try {
            int row_length = 11;
            stream = file.getInputStream();
            Workbook workbook = WorkbookFactory.create(stream);
//            Iterator<Sheet> sheetIter = workbook.sheetIterator();
//            while (sheetIter.hasNext()) {
//                Sheet sheet = sheetIter.next();
//            }
kangxiaoshan committed
2136
            return saveDataBySheet(workbook.getSheetAt(0), row_length, platform);
kangxiaoshan committed
2137 2138

        } catch (Exception ex) {
kangxiaoshan committed
2139
            logger.error("批量上传合同错误", ex);
kangxiaoshan committed
2140
        }
kangxiaoshan committed
2141
        return ResultModel.ERROR(ResultStatus.NONE_FILE_EXIST);
kangxiaoshan committed
2142 2143
    }

kangxiaoshan committed
2144

kangxiaoshan committed
2145
    public ResultModel saveDataBySheet(Sheet sheet, int row_length, String platformexcl) {
kangxiaoshan committed
2146 2147 2148 2149 2150
        String sheetName = sheet.getSheetName();
        if (!SHEET_NAMES.containsKey(sheetName)) {
            return ResultModel.ERROR("模板标签页名称错误");
        }

kangxiaoshan committed
2151
        if (!sheetName.equalsIgnoreCase(SHEET_NAMES_RESERVE.get(platformexcl))) {
kangxiaoshan committed
2152 2153 2154
            return ResultModel.ERROR("请上传对应项目模板处理的数据");
        }

kangxiaoshan committed
2155
        String platform = SHEET_NAMES.get(sheetName);
kangxiaoshan committed
2156 2157 2158 2159 2160 2161 2162 2163 2164 2165 2166 2167 2168 2169
        Map<String, Long> tradTypeMap = tradeTypeRepsitory.findAll()
                .stream().collect(Collectors.toMap(TradeType::getName, TradeType::getId));
        Map<String, Long> salseMap = salesRepository.findSaleByStatus(0)
                .stream().collect(Collectors.toMap(Sales::getName, Sales::getId));
        Map<String, Long> packageMap = null;

        if ("tkio".equals(platform) || "io".equals(platform)) {
            packageMap = packageTypeRepository.findIsNewAll()
                    .stream().collect(Collectors.toMap(PackageType::getPackageName, PackageType::getId));
        } else {
            packageMap = packageBaseRepository.findByPlatAndStatus(platform, 1)
                    .stream().collect(Collectors.toMap(PackageBase::getPackageName, PackageBase::getId));
        }

kangxiaoshan committed
2170 2171 2172 2173 2174 2175
        Map<String, String> cBodyMap = null;
        if ("abtest".equals(platform) || "ads".equals(platform)) {
            cBodyMap = contractBodyRepository.findByPlatform(platform)
                    .stream().collect(Collectors.toMap(ContractBody::getName, ContractBody::getCode));
        } else {
            cBodyMap = contractBodyRepository.findAllDis()
kangxiaoshan committed
2176
                    .stream().collect(Collectors.toMap(ContractBody::getName, ContractBody::getCode, (v1, v2) -> v1));
kangxiaoshan committed
2177
        }
kangxiaoshan committed
2178 2179

        Row row = sheet.getRow(0);
kangxiaoshan committed
2180 2181
        List<String> titleKey = new ArrayList<>();
        if (!parseRowData(row, row_length, null, titleKey)) {
kangxiaoshan committed
2182 2183 2184
            return ResultModel.ERROR(ResultStatus.FORMAT_FILE_ERRO);
        }

kangxiaoshan committed
2185
        int row_already = titleKey.size();
kangxiaoshan committed
2186 2187 2188 2189
        String extend_row_sql = "platform,product,my_body_code,create_time,code_num,type,status,ds," +
                "create_account,create_name,extra_flow,relation_contract,invoice_money,first_back_id";

        int extend_size = extend_row_sql.split(",").length;
kangxiaoshan committed
2190

kangxiaoshan committed
2191 2192 2193 2194 2195 2196
        DataFormatter formatter = new DataFormatter();
        int rowNumber = sheet.getLastRowNum();
        List<Object[]> args_data = new ArrayList<>();

        for (int j = 1; j <= rowNumber; j++) {
            Row row_data = sheet.getRow(j);
kangxiaoshan committed
2197
            Object[] s_data = new Object[titleKey.size() + extend_size];
kangxiaoshan committed
2198
            String bodyCode = null;
kangxiaoshan committed
2199
            String ds = null;
1  
kangxiaoshan committed
2200 2201 2202
            if (row_data == null) {
                continue;
            }
kangxiaoshan committed
2203 2204 2205

            for (int w = 0; w < titleKey.size(); w++) {
                String sheetTitle = titleKey.get(w);
kangxiaoshan committed
2206
                Cell cell = row_data.getCell(w);
1  
kangxiaoshan committed
2207
                int line_num = j + 1;
kangxiaoshan committed
2208
                if (null == cell || cell.getCellTypeEnum().equals(CellType.BLANK)) {
1  
kangxiaoshan committed
2209
                    return ResultModel.ERROR("第" + line_num + "行[" + SHEET_TITLE_RESERVE.get(sheetTitle) + "]不能为空");
kangxiaoshan committed
2210
                } else {
1  
kangxiaoshan committed
2211
                    String dataSTR = formatter.formatCellValue(cell).trim();
kangxiaoshan committed
2212

kangxiaoshan committed
2213
                    if ("my_body_name".equals(sheetTitle)) {
kangxiaoshan committed
2214 2215 2216 2217 2218 2219 2220
                        if (!cBodyMap.containsKey(dataSTR)) {
                            return ResultModel.ERROR("第" + line_num + "行[我方签约主体]错误");
                        } else {
                            s_data[w] = dataSTR;
                            bodyCode = cBodyMap.get(dataSTR);
                        }

kangxiaoshan committed
2221
                    } else if ("trade_type".equals(sheetTitle)) {
kangxiaoshan committed
2222 2223 2224 2225 2226
                        if (!tradTypeMap.containsKey(dataSTR)) {
                            return ResultModel.ERROR("第" + line_num + "行[行业分类]错误");
                        } else {
                            s_data[w] = tradTypeMap.get(dataSTR);
                        }
kangxiaoshan committed
2227
                    } else if ("sale".equals(sheetTitle)) {
kangxiaoshan committed
2228 2229 2230 2231 2232
                        if (!salseMap.containsKey(dataSTR)) {
                            return ResultModel.ERROR("第" + line_num + "行[签约销售]错误");
                        } else {
                            s_data[w] = salseMap.get(dataSTR);
                        }
kangxiaoshan committed
2233 2234
                    } else if ("contract_type".equals(sheetTitle)) {
                        if (!CONTRACT_TYPE_NAME.containsKey(dataSTR)) {
kangxiaoshan committed
2235 2236
                            return ResultModel.ERROR("第" + line_num + "行[签约类型]错误");
                        } else {
kangxiaoshan committed
2237
                            s_data[w] = CONTRACT_TYPE_NAME.get(dataSTR);
kangxiaoshan committed
2238
                        }
kangxiaoshan committed
2239
                    } else if ("price_level".equals(sheetTitle)) {
kangxiaoshan committed
2240 2241 2242 2243 2244
                        if (packageMap != null && !packageMap.containsKey(dataSTR)) {
                            return ResultModel.ERROR("第" + line_num + "行[套餐]错误");
                        } else {
                            s_data[w] = packageMap.get(dataSTR);
                        }
kangxiaoshan committed
2245 2246
                    } else if ("start_date".equals(sheetTitle) || "end_date".equals(sheetTitle)) {
                        String dfmate = cell.getCellStyle().getDataFormatString();
1  
kangxiaoshan committed
2247 2248 2249 2250 2251 2252 2253 2254

                        if (!"yyyy/mm;@".equals(dfmate)
                                && !"m/d/yy".equals(dfmate)
                                && !"yy/m/d".equals(dfmate)
                                && !"mm/dd/yy".equals(dfmate)
                                && !"dd-mmm-yy".equals(dfmate)
                                && !"yyyy/m/d".equals(dfmate)
                        ) {
kangxiaoshan committed
2255 2256
                            return ResultModel.ERROR("第" + line_num + "行[日期单元格]错误");
                        }
kangxiaoshan committed
2257

1  
kangxiaoshan committed
2258 2259 2260 2261 2262 2263 2264 2265
                        if (org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted(cell)) {
                            // 用于转化为日期格式
                            Date d = cell.getDateCellValue();
                            DateFormat formater = new SimpleDateFormat("yyyy-MM-dd");
                            s_data[w] = formater.format(d);
                        } else {
                            s_data[w] = cell.toString();
                        }
kangxiaoshan committed
2266

1  
kangxiaoshan committed
2267 2268
                        if ("start_date".equals(sheetTitle)) {
                            ds = s_data[w].toString();
kangxiaoshan committed
2269
                        }
1  
kangxiaoshan committed
2270

kangxiaoshan committed
2271 2272
                    } else if ("money".equals(sheetTitle)) {

2273
                        s_data[w] = dataSTR.replace(",", "");
kangxiaoshan committed
2274 2275 2276
                    } else {
                        s_data[w] = dataSTR;
                    }
kangxiaoshan committed
2277 2278 2279
                }
            }

kangxiaoshan committed
2280

kangxiaoshan committed
2281 2282 2283 2284
            s_data[row_already] = platform;
            s_data[row_already + 1] = platform;
            s_data[row_already + 2] = bodyCode;
            s_data[row_already + 3] = new Date();
kangxiaoshan committed
2285 2286 2287 2288 2289 2290 2291 2292 2293 2294 2295
            s_data[row_already + 4] = 0;
            s_data[row_already + 5] = "main";
            s_data[row_already + 6] = "backnone";
            s_data[row_already + 7] = ds;
//            create_account,create_name,extra_flow,relation_contract,invoice_money,first_back_id
            s_data[row_already + 8] = 0;
            s_data[row_already + 9] = "导入";
            s_data[row_already + 10] = 0;
            s_data[row_already + 11] = -1;
            s_data[row_already + 12] = 0;
            s_data[row_already + 13] = 0;
kangxiaoshan committed
2296
            //批量添加数据
kangxiaoshan committed
2297 2298 2299
            args_data.add(s_data);
        }

kangxiaoshan committed
2300 2301 2302 2303
        StringBuffer sql = new StringBuffer("insert into contract (");
        titleKey.forEach(v -> sql.append(v + ","));
        sql.append(extend_row_sql);
        sql.append(") values (");
kangxiaoshan committed
2304

kangxiaoshan committed
2305
        for (int ed = 0, s = row_already + extend_size; ed < s; ed++) {
kangxiaoshan committed
2306 2307
            if (ed == 0) {
                sql.append("?");
kangxiaoshan committed
2308
            } else {
kangxiaoshan committed
2309
                sql.append(",?");
kangxiaoshan committed
2310 2311
            }
        }
kangxiaoshan committed
2312 2313
        sql.append(")");
        logger.info("sql[{}]", sql.toString());
kangxiaoshan committed
2314

kangxiaoshan committed
2315
//        TransactionStatus transactionStatus = transactionUtils.begin();
kangxiaoshan committed
2316
        jdbcTemplate.batchUpdate(sql.toString(), args_data);
kangxiaoshan committed
2317
//        transactionUtils.commit(transactionStatus);
kangxiaoshan committed
2318 2319

        return ResultModel.OK();
kangxiaoshan committed
2320 2321 2322 2323

    }


kangxiaoshan committed
2324
    private boolean parseRowData(Row row, int length, StringBuffer content, List<String> titleKey) {
kangxiaoshan committed
2325 2326

        if (row == null) {
kangxiaoshan committed
2327
            return false;
kangxiaoshan committed
2328 2329 2330 2331 2332 2333 2334 2335
        }
        if (content == null) {
            content = new StringBuffer();
        }
        DataFormatter formatter = new DataFormatter();
        for (int i = 0; i < length; i++) {
            Cell cell = row.getCell(i);
            if (null != cell && !cell.getCellTypeEnum().equals(CellType.BLANK)) {
kangxiaoshan committed
2336
                String cnValue = formatter.formatCellValue(cell).trim();
kangxiaoshan committed
2337
                if (content.length() == 0) {
kangxiaoshan committed
2338
                    content.append(cnValue);
kangxiaoshan committed
2339
                } else {
kangxiaoshan committed
2340 2341 2342 2343 2344
                    content.append("," + cnValue);
                }

                if (!SHEET_TITLE.containsKey(cnValue)) {
                    return false;
kangxiaoshan committed
2345
                }
kangxiaoshan committed
2346
                titleKey.add(SHEET_TITLE.get(cnValue));
kangxiaoshan committed
2347 2348 2349
            }
        }

kangxiaoshan committed
2350
        return true;
kangxiaoshan committed
2351
    }
kangxiaoshan committed
2352

2353 2354 2355 2356
    @Override
    public List<Contract> shareIncomeList(User loginAccount, String startDate, String endDate, String platform, String bodyCode, String serchName) {

        List<Contract> contracts = new ArrayList<>();
2357 2358 2359 2360 2361 2362 2363

        List<String> financeBodies = null;
        if (RoleEnum.FINANCE.getKey().equals(loginAccount.getRole())) {
            Auth auth = authRepository.findByUser(loginAccount.getId());
            financeBodies = JSONArray.fromObject(auth.getAuthExtend());
        }

2364
        if (!StringUtils.isEmpty(bodyCode) && !StringUtils.isEmpty(serchName)) {
2365 2366 2367 2368 2369 2370 2371 2372

            if (financeBodies != null && !financeBodies.contains(bodyCode)) {
                //沒有权限查看
                return contracts;
            } else {
                contracts = contractRepository.findShareContranctByDate(startDate, endDate, platform, bodyCode, serchName);
            }

2373
        } else if (!StringUtils.isEmpty(bodyCode)) {
2374 2375 2376 2377 2378 2379
            if (financeBodies != null && !financeBodies.contains(bodyCode)) {
                //沒有权限查看
                return contracts;
            } else {
                contracts = contractRepository.findShareContranctByDate(startDate, endDate, platform, bodyCode);
            }
2380
        } else if (!StringUtils.isEmpty(serchName)) {
2381 2382 2383 2384 2385
            if (financeBodies != null) {
                contracts = contractRepository.findShareContranctByDateSercheFinace(startDate, endDate, platform, serchName, financeBodies);
            } else {
                contracts = contractRepository.findShareContranctByDateSerche(startDate, endDate, platform, serchName);
            }
2386
        } else {
2387 2388 2389 2390 2391
            if (financeBodies != null) {
                contracts = contractRepository.findShareContranctByDateFinace(startDate, endDate, platform, financeBodies);
            } else {
                contracts = contractRepository.findShareContranctByDate(startDate, endDate, platform);
            }
2392 2393
        }

kangxiaoshan committed
2394 2395 2396 2397
        List<ContractBody> bodies = contractBodyRepository.findAll();
        Map<String, String> bodiesNameMap = bodies.stream().collect(
                Collectors.toMap(ContractBody::getCode, ContractBody::getName, (v1, v2) -> v1));

2398 2399 2400
        DecimalFormat decimalFormat = new DecimalFormat("###,###.00");
        contracts.forEach(v -> {

kangxiaoshan committed
2401
            v.setMyBodyName(bodiesNameMap.get(v.getMyBodyCode()));
2402

2403

2404
            //不含稅收入
2405
            //以下结果统一 *100
2406 2407 2408 2409 2410 2411 2412 2413 2414 2415 2416 2417 2418 2419 2420 2421 2422 2423 2424 2425 2426 2427 2428 2429 2430 2431
//            Long excludTax = v.getMoney() * 6 / 100;
            Long excludTax = (long) (v.getMoney() * 100 * 0.06);

            v.setIncomeExcludingTax(excludTax);
            DateTime formStart = new DateTime(startDate);
            DateTime formEnd = new DateTime(endDate);
            DateTime contractStart = new DateTime(v.getStartDate());
            DateTime contractEnd = new DateTime(v.getEndDate());
            // 时间范围是否包含合同结束日期
            boolean containEnd = formEnd.compareTo(contractEnd) > 0;
            // 时间范围是否包含合同结束开始日期
            boolean containStart = formStart.compareTo(contractStart) > 0;
            //所选结束时间包含合同结束时间 取合同结束时间 反之 取所选结束时间
            DateTime usedEnd = containEnd ? contractEnd : formEnd;
            //所选开始时间包含合同开始时间 则取合同开始时间 反之 取所选开始时间
            DateTime usedStart = containStart ? contractEnd : formEnd;

            v.setIntervalUseDays(Days.daysBetween(contractStart, usedEnd).getDays() + 1);//区间使用天数

            //合同总天数
            int contracAllDays = Days.daysBetween(contractStart, contractEnd).getDays() + 1;

            // 处理后的选择范围天数
            int contractFormRange = Days.daysBetween(usedStart, usedEnd).getDays() + 1;

            //区间分摊收入
2432
            //以下结果统一 *100
2433 2434 2435 2436 2437 2438
            Long intervalIncome = 0L;
            if (containEnd) {
                //时间范围合同结束时间时 分两部分计算
                //第一部分
                intervalIncome = (v.getMoney() * 100) / contracAllDays * (contractFormRange - 1);
                //第二部分
2439 2440
                Long intervalIncomePart2 = (long) (v.getMoney() -
                        (v.getMoney() * 100 / contracAllDays * (contracAllDays - 1)) * 1.0 / 100) * 100;
2441 2442 2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453

                intervalIncome += intervalIncomePart2;
                v.setIntervaIncomeShare(intervalIncome);

            } else {
                intervalIncome = v.getMoney() * 100 / contracAllDays * contractFormRange;
                v.setIntervaIncomeShare(intervalIncome);
            }

            if (v.getAdjustmentFund() == null) {
                v.setAdjustmentFund(0L);
            }
            //分摊总收入
kangxiaoshan committed
2454
            v.setIncomeShareAll(intervalIncome + v.getAdjustmentFund());
2455 2456 2457 2458 2459 2460 2461 2462


        });

        return contracts;

    }

kangxiaoshan committed
2463
    public static void main(String[] args) {
2464 2465 2466 2467 2468 2469 2470
//        String dateStr1 = "2019-04-30";
//        String dateStr2 = "2019-04-01";
//
//        System.out.println(new DateTime(dateStr2).compareTo(new DateTime(dateStr1)));
//        System.out.println(Days.daysBetween(new DateTime(dateStr2), new DateTime(dateStr1)).getDays());

        System.out.println(10023L * 1.0 / 100);
kangxiaoshan committed
2471
        System.out.println((129 * 100 / 111) * 1.0 / 100);
2472 2473 2474

        System.out.println();

kangxiaoshan committed
2475
    }
manxiaoqiang committed
2476
}