com.dayuan.action.BusFileAction.java Source code

Introduction

Here is the source code for com.dayuan.action.BusFileAction.java

Source

package com.dayuan.action;

import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.UUID;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.propertyeditors.CustomDateEditor;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.WebDataBinder;
import org.springframework.web.bind.annotation.InitBinder;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import com.dayuan.bean.BusBiling;
import com.dayuan.bean.BusFiles;
import com.dayuan.bean.BusLending;
import com.dayuan.bean.BusLoanInfo;
import com.dayuan.bean.BusLoanInfoController;
import com.dayuan.bean.BusLoanInfoGuaranter;
import com.dayuan.bean.BusLoanInfoLegal;
import com.dayuan.bean.BusLoanInfoShop;
import com.dayuan.bean.SysUser;
import com.dayuan.form.GuaranterListForm;
import com.dayuan.form.ShopListForm;
import com.dayuan.model.BusFileModel;
import com.dayuan.service.BusBilingService;
import com.dayuan.service.BusFileService;
import com.dayuan.service.BusLendingService;
import com.dayuan.service.BusLoanInfoControllerService;
import com.dayuan.service.BusLoanInfoGuaranterService;
import com.dayuan.service.BusLoanInfoLegalService;
import com.dayuan.service.BusLoanInfoService;
import com.dayuan.service.BusLoanInfoShopService;
import com.dayuan.utils.CreateWords;
import com.dayuan.utils.DateUtil;
import com.dayuan.utils.HtmlUtil;
import com.dayuan.utils.SessionUtils;
import com.dayuan.utils.StringUtil;
import com.dayuan.utils.ZipUtil;
import com.dayuan.utils.Constant.SuperAdmin;

@Controller
@RequestMapping("/BusFile")
public class BusFileAction extends BaseAction {

    //Service start 
    @Autowired(required = false)
    private BusFileService<BusFiles> busFileService;

    // Service start 
    @Autowired(required = false) //???setrequired=false?
    private BusLoanInfoService<BusLoanInfo> busLoanInfoService;

    // Service start 
    @Autowired(required = false)
    private BusLoanInfoLegalService<BusLoanInfoLegal> busLoanInfoLegalService;

    // Service start 
    @Autowired(required = false)
    private BusLoanInfoControllerService<BusLoanInfoController> busLoanInfoControllerService;

    // Service start ??
    @Autowired(required = false)
    private BusLoanInfoShopService<BusLoanInfoShop> busLoanInfoShopService;

    // Service start ??
    @Autowired(required = false)
    private BusLoanInfoGuaranterService<BusLoanInfoGuaranter> busLoanInfoGuaranterService;

    // Service start ?
    @Autowired(required = false)
    private BusLendingService<BusLending> busLendingService;

    // Service start ????
    @Autowired(required = false)
    private BusBilingService<BusBiling> busBilingService;

    //DATE
    @InitBinder
    protected void initBinder(WebDataBinder binder) {
        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
        binder.registerCustomEditor(Date.class, new CustomDateEditor(dateFormat, true));
    }

    /**
     * ?
     * */
    @RequestMapping("/loanAdd")
    public ModelAndView loanAdd(HttpServletRequest request) {
        Map<String, Object> context = getRootMap();
        SysUser user = SessionUtils.getUser(request);
        context.put("user", user);
        //return forword("bus/busLoanAdd",context);
        return forword("bus/busLoanEdit", context);
    }

    /**
     * ??
     * */
    @RequestMapping("/filing")
    public ModelAndView filing(HttpServletRequest request) {
        Map<String, Object> context = getRootMap();
        SysUser user = SessionUtils.getUser(request);
        context.put("user", user);
        return forword("bus/filing", context);
    }

    @RequestMapping("/dataList")
    public void dataList(BusFileModel busFileModel, HttpServletRequest request, HttpServletResponse response) {
        if (busFileModel != null) {
            SysUser user = SessionUtils.getUser(request);
            if (SuperAdmin.YES.key != user.getSuperAdmin() && user.getExcelAuth() == 0) {
                //busFileModel.setlUserName(user.getNickName());
                busFileModel.setlUId(user.getId().toString());
            }
            try {
                List<BusFiles> list = busFileService.queryByList(busFileModel);
                List<BusFiles> list2 = new ArrayList<BusFiles>();
                for (BusFiles busFiles : list) {
                    BusFiles busFiles2 = new BusFiles();
                    busFiles2.setId(busFiles.getId());
                    busFiles2.setlName(busFiles.getlName());
                    busFiles2.setlIdCard(busFiles.getlIdCard());
                    busFiles2.setlTelPhone(busFiles.getlTelPhone());
                    busFiles2.setlStatus(busFiles.getlStatus());
                    if (busFiles.getCreateTime() != null) {
                        busFiles2.setCreateTime2(DateUtil.getFormattedDateUtil((Date) busFiles.getCreateTime(),
                                "yyyy-MM-dd HH:mm:ss"));
                    } else {
                        busFiles2.setCreateTime2("");
                    }
                    if (busFiles.getUpdateTime() != null) {
                        busFiles2.setUpdateTime2(DateUtil.getFormattedDateUtil((Date) busFiles.getUpdateTime(),
                                "yyyy-MM-dd HH:mm:ss"));
                    } else {
                        busFiles2.setUpdateTime2("");
                    }
                    list2.add(busFiles2);
                }
                Map<String, Object> map = new HashMap<String, Object>();
                map.put("total", busFileModel.getPager().getRowCount());
                map.put("rows", list2);
                HtmlUtil.writerJson(response, "", map);
            } catch (Exception e) {
                log.error("?BusFile" + e.getMessage());
            }
        }

    }

    @RequestMapping("/save")
    public void save(BusFiles busFiles, BusLoanInfo busLoanInfo, BusLoanInfoLegal busLoanInfoLegal,
            BusLoanInfoController busLoanInfoController, ShopListForm shopForm, GuaranterListForm guaranterForm,
            BusLending busLending, BusBiling busBiling, HttpServletRequest request, HttpServletResponse response) {
        boolean flag = false;
        int num = 0;
        String message = "";
        /**??*/
        if (busFiles != null) {
            try {
                if (busFiles.getId() == null) {
                    busFiles.setCreateTime(new Date());
                    num = busFileService.save(busFiles);
                    if (num == 1) {
                        flag = true;
                    }
                } else {
                    busFiles.setUpdateTime(new Date());
                    num = busFileService.updateReturnInfluences(busFiles);
                    if (num == 1) {
                        flag = true;
                    }
                }
            } catch (Exception e) {
                log.error("BusFile?" + e.getMessage());
            }
        }
        Integer lId = busFiles.getId();
        /**??*/
        if (busLoanInfo != null) {
            try {
                busLoanInfo.setlId(lId);
                busLoanInfo.setId(busLoanInfo.getLoanInfoTempId());
                if (busLoanInfo.getId() == null) {
                    num = busLoanInfoService.save(busLoanInfo);
                    if (num != 1) {
                        flag = false;
                    }
                } else {
                    num = busLoanInfoService.updateReturnInfluences(busLoanInfo);
                    if (num != 1) {
                        flag = false;
                    }
                }
            } catch (Exception e) {
                flag = false;
                log.error("BusLoanInfo?" + e.getMessage());
            }
        }
        /**??*/
        if (busLoanInfoLegal != null) {
            try {
                busLoanInfoLegal.setBid(lId);
                busLoanInfoLegal.setId(busLoanInfoLegal.getLegalTempId());
                if (busLoanInfoLegal.getId() == null) {
                    num = busLoanInfoLegalService.save(busLoanInfoLegal);
                    if (num != 1) {
                        flag = false;
                    }
                } else {
                    num = busLoanInfoLegalService.updateReturnInfluences(busLoanInfoLegal);
                    if (num != 1) {
                        flag = false;
                    }
                }
            } catch (Exception e) {
                flag = false;
                log.error("BusLoanInfoLegal?" + e.getMessage());
            }
        }
        if (busLoanInfoLegal.getIfController() != null && busLoanInfoLegal.getIfController().equals("?")) {
            /**??*/
            if (busLoanInfoController != null) {
                try {
                    busLoanInfoController.setBid(lId);
                    busLoanInfoController.setId(busLoanInfoController.getControllerTempId());
                    if (busLoanInfoController.getId() == null) {
                        num = busLoanInfoControllerService.save(busLoanInfoController);
                        if (num != 1) {
                            flag = false;
                        }
                    } else {
                        num = busLoanInfoControllerService.updateReturnInfluences(busLoanInfoController);
                        if (num != 1) {
                            flag = false;
                        }
                    }
                } catch (Exception e) {
                    flag = false;
                    log.error("BusLoanInfoController?" + e.getMessage());
                }
            }
        }
        /**??*/
        for (BusLoanInfoShop shop : shopForm.getShop()) {
            try {
                shop.setBid(lId);
                shop.setId(shop.getTempShopId());
                if (shop.getId() == null) {
                    num = busLoanInfoShopService.save(shop);
                    if (num != 1) {
                        flag = false;
                    }
                } else {
                    num = busLoanInfoShopService.updateReturnInfluences(shop);
                    if (num != 1) {
                        flag = false;
                    }
                }
            } catch (Exception e) {
                flag = false;
                log.error("BusLoanInfoShop?" + e.getMessage());
            }

        }

        /**????*/
        if (busLoanInfo != null) {
            if (busLoanInfo.getIfGuaranter().equals("")) {
                for (BusLoanInfoGuaranter guaranter : guaranterForm.getGuaranter()) {
                    guaranter.setBid(lId);
                    guaranter.setId(guaranter.getGuaranterTempId());
                    if (guaranter.getId() == null) {
                        num = busLoanInfoGuaranterService.save(guaranter);
                        if (num != 1) {
                            flag = false;
                        }
                    } else {
                        num = busLoanInfoGuaranterService.updateReturnInfluences(guaranter);
                        if (num != 1) {
                            flag = false;
                        }
                    }

                }
            }
        }

        /**??*/
        if (busLending != null) {
            try {
                busLending.setBid(lId);
                busLending.setId(busLending.getLendingTempId());
                if (busLending.getId() == null) {
                    num = busLendingService.save(busLending);
                    if (num != 1) {
                        flag = false;
                    }
                } else {
                    num = busLendingService.updateReturnInfluences(busLending);
                    if (num != 1) {
                        flag = false;
                    }
                }
            } catch (Exception e) {
                flag = false;
                log.error("BusLending?" + e.getMessage());
            }

        }

        /**?????*/
        if (busBiling != null) {
            try {
                busBiling.setBid(lId);
                busBiling.setId(busBiling.getBilingTempId());
                if (busBiling.getId() == null) {
                    num = busBilingService.save(busBiling);
                    if (num != 1) {
                        flag = false;
                    }
                } else {
                    num = busBilingService.updateReturnInfluences(busBiling);
                    if (num != 1) {
                        flag = false;
                    }

                }
            } catch (Exception e) {
                flag = false;
                log.error("busBiling?" + e.getMessage());
            }

        }

        if (flag) {
            message = "???";
        } else {
            message = "?";
        }
        log.info("BusFileAction.save" + message);
        sendSuccessMessage(response, message);
    }

    /**
     * ?id?busfiles
     * */
    @RequestMapping("getId")
    public void getId(Integer id, HttpServletResponse response) {
        if (id != null) {
            try {
                Map<String, Object> content = getRootMap();
                BusFiles busFiles = busFileService.queryById(id);
                if (busFiles == null) {
                    sendFailureMessage(response, "!");
                    return;
                }
                content.put(SUCCESS, true);
                content.put("data", busFiles);
                HtmlUtil.writerJson(response, "", content);
            } catch (Exception e) {
                log.error("getId" + e.getMessage());
            }
        }
    }

    /**
     * ?
     * */
    @RequestMapping("/toEdit")
    public ModelAndView toEdit(HttpServletRequest request) {
        Map<String, Object> context = getRootMap();
        SysUser user = SessionUtils.getUser(request);
        context.put("user", user);
        Integer id = Integer.parseInt(request.getParameter("id").trim());
        if (id == null || id.equals("")) {
            return forword("error/error", context);
        }
        try {
            BusFiles busFiles = busFileService.queryById(id);
            if (busFiles != null) {
                context.put("busFiles", busFiles);
            }
            BusLoanInfo busLoanInfo = busLoanInfoService.queryByLId(id);
            if (busLoanInfo != null) {
                context.put("busLoanInfo", busLoanInfo);
            }
            BusLoanInfoLegal busLoanInfoLegal = busLoanInfoLegalService.getBusLoanInfoLegal(id);
            if (busLoanInfoLegal != null) {
                context.put("busLoanInfoLegal", busLoanInfoLegal);
                if (busLoanInfoLegal.getIfController().equals("?")) {
                    BusLoanInfoController busLoanInfoController = busLoanInfoControllerService
                            .getBusLoanInfoController(id);
                    if (busLoanInfoController != null) {
                        context.put("busLoanInfoController", busLoanInfoController);
                    }
                }
            }
            List<BusLoanInfoShop> shopList = busLoanInfoShopService.queryListByBId(id);
            if (shopList != null && shopList.size() > 0) {
                context.put("shopList", shopList);
            }
            if (busLoanInfo != null && busLoanInfo.getIfGuaranter().equals("")) {
                List<BusLoanInfoGuaranter> guaranterList = busLoanInfoGuaranterService.queryListByBId(id);
                if (guaranterList != null && guaranterList.size() > 0) {
                    context.put("guaranterList", guaranterList);
                }
            }
            BusLending busLending = busLendingService.queryByBId(id);
            if (busLending != null) {
                context.put("busLending", busLending);
            }
            BusBiling busBiling = busBilingService.queryByBId(id);
            if (busBiling != null) {
                context.put("busBiling", busBiling);
            }
        } catch (Exception e) {
            log.error("toEdit" + e.getMessage());
        }
        return forword("bus/busLoanEdit", context);
    }

    /**??*/
    @RequestMapping("/delete")
    public void delete(Integer[] id, HttpServletResponse response) {
        boolean flag = false;
        if (id != null && id.length > 0) {
            try {
                for (int i = 0; i < id.length; i++) {
                    BusFiles busFiles = busFileService.queryById(id[i]);
                    if (busFiles != null) {
                        Integer lId = busFiles.getId();
                        busLoanInfoService.deleteByLId(lId);
                        busLoanInfoLegalService.deleteByBid(lId);
                        busLoanInfoControllerService.deleteByBid(lId);
                        busLoanInfoShopService.deleteByBid(lId);
                        busLoanInfoGuaranterService.deleteByBid(lId);
                        busLendingService.deleteByLId(lId);
                        busBilingService.deleteByLId(lId);
                        busFileService.delete(lId);
                        flag = true;
                    }
                }
            } catch (Exception e) {
                log.error("?" + e.getMessage());
            }
        }
        if (flag) {
            log.info("??");
            sendSuccessMessage(response, "??");
        } else {
            log.info("?");
            sendFailureMessage(response, "?");
        }

    }

    /**???Excel*/
    @RequestMapping("/exportExcel")
    public ModelAndView exportExcel(HttpServletRequest request, HttpServletResponse response) {
        Map<String, Object> context = getRootMap();
        SysUser user = SessionUtils.getUser(request);
        BusFileModel busFileModel = new BusFileModel();
        if (SuperAdmin.YES.key != user.getSuperAdmin() && user.getExcelAuth() == 0) {
            //busFileModel.setlUserName(user.getNickName());
            busFileModel.setlUId(user.getId().toString());
        }
        busFileModel.setRows(500);
        try {
            List<BusFiles> list = busFileService.queryByList(busFileModel);
            if (list != null && list.size() > 0) {
                // webbookExcel  
                HSSFWorkbook wb = new HSSFWorkbook();
                // webbooksheet,Excelsheet  
                HSSFSheet sheet = wb.createSheet("?");
                HSSFSheet sheetLoan = wb.createSheet("?");
                // sheet0,??poiExcel?short  
                HSSFRow row = sheet.createRow((int) 0);
                HSSFRow rowLoan = sheetLoan.createRow((int) 0);
                // ?   
                HSSFCellStyle style = wb.createCellStyle();
                // ?
                style.setAlignment(HSSFCellStyle.ALIGN_CENTER);

                /**sheet1 ?*/
                HSSFCell cell = row.createCell((short) 0);
                cell.setCellValue("??");
                cell.setCellStyle(style);
                cell = row.createCell((short) 1);
                cell.setCellValue("??");//busfiles.lUserName
                cell.setCellStyle(style);
                cell = row.createCell((short) 2);
                cell.setCellValue("??");//busLoanInfo.applicationName 
                cell.setCellStyle(style);
                cell = row.createCell((short) 3);
                cell.setCellValue("?"); //busfiles.lStatus
                cell.setCellStyle(style);
                cell = row.createCell((short) 4);
                cell.setCellValue(""); //busfiles.createTime
                cell.setCellStyle(style);
                cell = row.createCell((short) 5);
                cell.setCellValue("??"); //busLoanInfo.channel
                cell.setCellStyle(style);
                cell = row.createCell((short) 6);
                cell.setCellValue("?"); //buslending.loanAmount
                cell.setCellStyle(style);
                cell = row.createCell((short) 7);
                cell.setCellValue("?"); //buslending.openingQuota
                cell.setCellStyle(style);
                cell = row.createCell((short) 8);
                cell.setCellValue(""); //busBiling.creditEndDate
                cell.setCellStyle(style);
                cell = row.createCell((short) 9);
                cell.setCellValue("???"); //busBiling.loanAccount
                cell.setCellStyle(style);
                cell = row.createCell((short) 10);
                cell.setCellValue("?"); //legal.deliveryAddress
                cell.setCellStyle(style);

                /**sheet2 ?*/
                HSSFCell cellLoan = rowLoan.createCell((short) 0);
                cellLoan.setCellValue("??");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 1);
                cellLoan.setCellValue("??");//busLoanInfo.applicationName  
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 2);
                cellLoan.setCellValue("?"); //busLoanInfo.urgentCont 
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 3);
                cellLoan.setCellValue("");//busLoanInfo.relationship  
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 4);
                cellLoan.setCellValue("?");//busLoanInfo.urgentContPhone  
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 5);
                cellLoan.setCellValue("?");//busLoanInfo.urgentContAddress  
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 6);
                cellLoan.setCellValue("??"); //biling.loanCardNumber 
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 7);
                cellLoan.setCellValue("1");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 8);
                cellLoan.setCellValue("?1");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 9);
                cellLoan.setCellValue("???1");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 10);
                cellLoan.setCellValue("?1");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 11);
                cellLoan.setCellValue("2");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 12);
                cellLoan.setCellValue("?2");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 13);
                cellLoan.setCellValue("???2");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 14);
                cellLoan.setCellValue("?2");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 15);
                cellLoan.setCellValue("");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 16);
                cellLoan.setCellValue("??");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 17);
                cellLoan.setCellValue("????");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 18);
                cellLoan.setCellValue("??");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 19);
                cellLoan.setCellValue("??");
                cellLoan.setCellStyle(style);
                cellLoan = rowLoan.createCell((short) 20);
                cellLoan.setCellValue("?");
                cellLoan.setCellStyle(style);

                for (int i = 0; i < list.size(); i++) {
                    BusFiles busFiles = list.get(i);
                    Integer lId = busFiles.getId();
                    BusLoanInfo busLoanInfo = busLoanInfoService.queryByLId(lId);
                    BusLending busLending = busLendingService.queryByBId(lId);
                    BusBiling busBiling = busBilingService.queryByBId(lId);
                    BusLoanInfoLegal legal = busLoanInfoLegalService.getBusLoanInfoLegal(lId);
                    List<BusLoanInfoShop> shopList = busLoanInfoShopService.queryListByBId(lId);

                    /**rowsheet1*/
                    row = sheet.createRow((int) 1 + i);
                    row.createCell((short) 0).setCellValue(i + 1);
                    row.createCell((short) 1).setCellValue(busFiles.getlUserName());
                    row.createCell((short) 3).setCellValue(busFiles.getlStatus());
                    row.createCell((short) 4).setCellValue(
                            DateUtil.getFormattedDateUtil((Date) busFiles.getCreateTime(), "yyyy-MM-dd HH:mm:ss"));

                    /**rowLoansheet2*/
                    rowLoan = sheetLoan.createRow((int) 1 + i);
                    rowLoan.createCell((short) 0).setCellValue(i + 1);

                    if (busLoanInfo != null) {
                        row.createCell((short) 2).setCellValue(busLoanInfo.getApplicationName());
                        row.createCell((short) 5).setCellValue(busLoanInfo.getChannel());

                        rowLoan.createCell((short) 1).setCellValue(busLoanInfo.getApplicationName());
                        rowLoan.createCell((short) 2).setCellValue(busLoanInfo.getUrgentCont());
                        rowLoan.createCell((short) 3).setCellValue(busLoanInfo.getRelationship());
                        rowLoan.createCell((short) 4).setCellValue(busLoanInfo.getUrgentContPhone());
                        rowLoan.createCell((short) 5).setCellValue(busLoanInfo.getUrgentContAddress());

                    } else {
                        row.createCell((short) 2).setCellValue("");
                        row.createCell((short) 5).setCellValue("");

                        rowLoan.createCell((short) 1).setCellValue("");
                        rowLoan.createCell((short) 2).setCellValue("");
                        rowLoan.createCell((short) 3).setCellValue("");
                        rowLoan.createCell((short) 4).setCellValue("");
                        rowLoan.createCell((short) 5).setCellValue("");
                    }
                    if (busLending != null) {
                        row.createCell((short) 6).setCellValue(busLending.getLoanAmount());
                        row.createCell((short) 7).setCellValue(busLending.getOpeningQuota());
                    } else {
                        row.createCell((short) 6).setCellValue("");
                        row.createCell((short) 7).setCellValue("");
                    }
                    if (busBiling != null) {
                        row.createCell((short) 8).setCellValue(busBiling.getCreditEndDate());
                        row.createCell((short) 9).setCellValue(busBiling.getLoanAccount());

                        rowLoan.createCell((short) 6).setCellValue(busBiling.getLoanCardNumber());//??
                        rowLoan.createCell((short) 15).setCellValue(DateUtil
                                .getFormattedDateUtil((Date) busBiling.getCheckDate(), "yyyy-MM-dd HH:mm:ss"));//
                        rowLoan.createCell((short) 16).setCellValue(busBiling.getCreditorIfNormal());//??
                        rowLoan.createCell((short) 17).setCellValue(busBiling.getGuarantorIfNormal());//????
                        rowLoan.createCell((short) 18).setCellValue(busBiling.getCloudLoanIfWarning());//??
                        rowLoan.createCell((short) 19).setCellValue(busBiling.getShopOperation());//??
                        rowLoan.createCell((short) 20).setCellValue(busBiling.getOtherNeedToExplained());//?
                    } else {
                        row.createCell((short) 8).setCellValue("");
                        row.createCell((short) 9).setCellValue("");

                        rowLoan.createCell((short) 6).setCellValue("");//??
                        rowLoan.createCell((short) 15).setCellValue("");//
                        rowLoan.createCell((short) 16).setCellValue("");//??
                        rowLoan.createCell((short) 17).setCellValue("");//????
                        rowLoan.createCell((short) 18).setCellValue("");//??
                        rowLoan.createCell((short) 19).setCellValue("");//??
                        rowLoan.createCell((short) 20).setCellValue("");//?

                    }
                    if (legal != null) {
                        row.createCell((short) 10).setCellValue(legal.getDeliveryAddress());
                    } else {
                        row.createCell((short) 10).setCellValue("");
                    }

                    if (shopList != null && shopList.size() > 0) {
                        if (shopList.size() == 1) {
                            BusLoanInfoShop shop = shopList.get(0);
                            rowLoan.createCell((short) 7).setCellValue(shop.getShopName());//
                            rowLoan.createCell((short) 8).setCellValue(shop.getPlatformName());//?
                            rowLoan.createCell((short) 9).setCellValue(shop.getSubAccount());//???
                            rowLoan.createCell((short) 10).setCellValue(shop.getSbuPassword());//?
                            rowLoan.createCell((short) 11).setCellValue("");//
                            rowLoan.createCell((short) 12).setCellValue("");//?
                            rowLoan.createCell((short) 13).setCellValue("");//???
                            rowLoan.createCell((short) 14).setCellValue("");//?
                        } else if (shopList.size() == 2) {
                            BusLoanInfoShop shop = shopList.get(0);
                            rowLoan.createCell((short) 7).setCellValue(shop.getShopName());//
                            rowLoan.createCell((short) 8).setCellValue(shop.getPlatformName());//?
                            rowLoan.createCell((short) 9).setCellValue(shop.getSubAccount());//???
                            rowLoan.createCell((short) 10).setCellValue(shop.getSbuPassword());//?
                            BusLoanInfoShop shop1 = shopList.get(1);
                            rowLoan.createCell((short) 11).setCellValue(shop1.getShopName());//
                            rowLoan.createCell((short) 12).setCellValue(shop1.getPlatformName());//?
                            rowLoan.createCell((short) 13).setCellValue(shop1.getSubAccount());//???
                            rowLoan.createCell((short) 14).setCellValue(shop1.getSbuPassword());//?
                        }

                    } else {
                        rowLoan.createCell((short) 7).setCellValue("");
                        rowLoan.createCell((short) 8).setCellValue("");
                        rowLoan.createCell((short) 9).setCellValue("");
                        rowLoan.createCell((short) 10).setCellValue("");
                        rowLoan.createCell((short) 11).setCellValue("");
                        rowLoan.createCell((short) 12).setCellValue("");
                        rowLoan.createCell((short) 13).setCellValue("");
                        rowLoan.createCell((short) 14).setCellValue("");
                    }

                }
                String savePath = request.getSession().getServletContext().getRealPath(
                        File.separator + "WEB-INF" + File.separator + "downloads" + File.separator + "excelfiles");//??,??
                File savePathFile = new File(savePath);
                if (!savePathFile.exists()) {
                    savePathFile.mkdirs();
                }
                savePath = savePath + File.separator + UUID.randomUUID();//?
                File fileSavePath = new File(savePath);
                /**??*/
                if (fileSavePath.exists()) {
                    if (fileSavePath.isDirectory()) {
                        File[] files = fileSavePath.listFiles();
                        for (File file : files) {
                            file.delete();
                        }
                        fileSavePath.delete();
                    } else {
                        fileSavePath.delete();
                    }
                    fileSavePath.mkdirs();
                } else {
                    fileSavePath.mkdirs();
                }
                String excel = "????" + DateUtil.getNowLongTime() + ".xls";//eccel??
                BufferedOutputStream fout = new BufferedOutputStream(
                        new FileOutputStream(savePath + File.separator + excel)); //excel
                wb.write(fout); //excel?
                fout.flush();
                fout.close();
                //MIME
                response.setContentType(request.getSession().getServletContext().getMimeType(excel));
                //Content-Disposition
                response.setHeader("Content-Disposition",
                        "attachment;filename=" + URLEncoder.encode(excel, "UTF-8"));
                BufferedInputStream in = new BufferedInputStream(
                        new FileInputStream(savePath + File.separator + excel));//,io?
                OutputStream out = new BufferedOutputStream(response.getOutputStream());
                byte buffer[] = new byte[1024];
                int len = 0;
                while ((len = in.read(buffer)) > 0) {
                    out.write(buffer, 0, len);//?response?
                }
                in.close();
                out.flush();
                out.close();
                /***/
                File file = new File(savePath + File.separator + excel);
                if (file != null) {
                    if (file.exists()) {
                        file.delete();//
                    }
                    file = null;
                }
                /***/
                if (fileSavePath != null) {
                    if (fileSavePath.exists()) {
                        fileSavePath.delete();
                    }
                    fileSavePath = null;
                }
                if (savePathFile != null) {
                    savePathFile = null;
                }
                log.info("Excel?");
            }
        } catch (Exception e) {
            //e.printStackTrace();
            log.error("exportExcel" + e.getMessage());
            context.put("message", "??");
            return forword("message/message", context);
        }
        return null;
    }

    /**
     * 
     * ?
     * @param id
     * @param wordType
     * @author xuanaw
     * */
    @RequestMapping("/createWords")
    public ModelAndView createWords(Integer id, String wordType, HttpServletRequest request,
            HttpServletResponse response) {
        Map<String, Object> context = getRootMap();
        if (id == null) {
            log.info("idnull?");
            context.put("message", "?????");
            return forword("message/message", context);
        }
        if (wordType == null || wordType.equals("")) {
            log.info("wordType?");
            context.put("message", "?????");
            return forword("message/message", context);
        }
        boolean flag = false;
        String savePath = "";
        BusFiles busFiles = null;
        try {
            busFiles = busFileService.queryById(id);
            if (busFiles == null) {
                log.error("busFiles?");
                context.put("message", "?");
                return forword("message/message", context);
            }
            Integer lId = busFiles.getId();
            BusLoanInfo busLoanInfo = busLoanInfoService.queryByLId(lId);
            BusLoanInfoLegal legal = busLoanInfoLegalService.getBusLoanInfoLegal(lId);
            BusLending lending = busLendingService.queryByBId(lId);
            List<BusLoanInfoShop> shopList = busLoanInfoShopService.queryListByBId(lId);
            List<BusLoanInfoGuaranter> guaranterLsit = busLoanInfoGuaranterService.queryListByBId(lId);
            BusLoanInfoGuaranter busLoanInfoGuaranter = this.busLoanInfoGuaranterService
                    .getBusLoanInfoGuaranter(lId);
            BusLoanInfoController busLoanInfoController = null;
            if (legal.getIfController().equals("?")) {
                busLoanInfoController = busLoanInfoControllerService.getBusLoanInfoController(lId);
            }
            Map<String, Object> dataMap = new HashMap<String, Object>();
            String templatePath = File.separator + "com" + File.separator + "dayuan" + File.separator + "templatev1"
                    + File.separator;//??
            savePath = request.getSession().getServletContext()
                    .getRealPath(File.separator + "WEB-INF" + File.separator + "downloads");//??,??
            savePath = savePath + File.separator + UUID.randomUUID();//??
            /** */
            File fileSavePath = new File(savePath);
            if (fileSavePath.exists()) {
                if (fileSavePath.isDirectory()) {
                    File[] files = fileSavePath.listFiles();
                    for (File file : files) {
                        file.delete();
                    }
                    fileSavePath.delete();
                } else {
                    fileSavePath.delete();
                }
                fileSavePath.mkdirs();
            } else {
                fileSavePath.mkdirs();
            }
            CreateWords createWords = new CreateWords();//?word?
            String wordName = "";//???
            if (busFiles.getlName() != null && !busFiles.getlName().equals("")) {
                wordName += busFiles.getlName();
            }
            if (wordType.equals("1")) {
                dataMap.put("lName1", StringUtil.getNotNullStr(busFiles.getlName()));
                dataMap.put("lIdCard1", StringUtil.getNotNullStr(busFiles.getlIdCard()));
                dataMap.put("lTelPhone1", StringUtil.getNotNullStr(busFiles.getlTelPhone()));
                dataMap.put("lName2", StringUtil.getNotNullStr(busFiles.getlName()));
                dataMap.put("lTelPhone2", StringUtil.getNotNullStr(busFiles.getlTelPhone()));
                dataMap.put("lName3", StringUtil.getNotNullStr(busFiles.getlName()));
                dataMap.put("lIdCard2", StringUtil.getNotNullStr(busFiles.getlIdCard()));
                dataMap.put("lTelPhone3", StringUtil.getNotNullStr(busFiles.getlTelPhone()));
                wordName += "_1??_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "daiqianwenjian1.ftl", savePath + File.separator,
                        wordName);
            } else if (wordType.equals("3")) {
                if (busLoanInfo != null) {
                    dataMap.put("applicationName1", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                    dataMap.put("applicationName2", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                    dataMap.put("applicationAmount", StringUtil.getNotNullStr(busLoanInfo.getApplicationAmount()));
                } else {
                    dataMap.put("applicationName1", "");
                    dataMap.put("applicationName2", "");
                    dataMap.put("applicationAmount", "");
                }
                if (legal != null) {
                    dataMap.put("idCard", StringUtil.getNotNullStr(legal.getIdCard()));
                    dataMap.put("idCardPeriod", StringUtil.getNotNullStr(legal.getIdCardPeriod()));
                    dataMap.put("idCardAddress", StringUtil.getNotNullStr(legal.getIdCardAddress()));
                    dataMap.put("legalPhone", StringUtil.getNotNullStr(legal.getLegalPhone()));
                } else {
                    dataMap.put("idCard", "");
                    dataMap.put("idCardPeriod", "");
                    dataMap.put("idCardAddress", "");
                    dataMap.put("legalPhone", "");
                }
                if (busLoanInfo.getChannel().equals("??")) {
                    wordName += "_3??_??_" + DateUtil.getNowLongTime() + ".doc";
                    flag = createWords.create(dataMap, templatePath, "ziliuliang3.ftl", savePath + File.separator,
                            wordName);
                } else if (busLoanInfo.getChannel().equals("?")) {
                    wordName += "_3??_?_" + DateUtil.getNowLongTime()
                            + ".doc";
                    flag = createWords.create(dataMap, templatePath, "yundaituisong3.ftl",
                            savePath + File.separator, wordName);
                }
            } else if (wordType.equals("4")) {
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                wordName += "_4?_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "dianshangdaihouxuzhi4.ftl",
                        savePath + File.separator, wordName);
            } else if (wordType.equals("5")) {
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                if (legal != null) {
                    dataMap.put("houseAddress", StringUtil.getNotNullStr(legal.getHouseAddress()));
                    dataMap.put("legalPhone", StringUtil.getNotNullStr(legal.getLegalPhone()));
                    dataMap.put("idCard", StringUtil.getNotNullStr(legal.getIdCard()));
                } else {
                    dataMap.put("houseAddress", "");
                    dataMap.put("legalPhone", "");
                    dataMap.put("idCard", "");
                }
                if (lending != null) {
                    dataMap.put("loanAmount", StringUtil.getNotNullStr(lending.getLoanAmount()));
                    dataMap.put("creditTerm", StringUtil.getNotNullStr(lending.getCreditTerm()));
                    dataMap.put("startTermYear",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "yyyy"));
                    dataMap.put("startTermMonth",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "MM"));
                    dataMap.put("startTermDay", DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "dd"));
                    dataMap.put("endTermYear", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "yyyy"));
                    dataMap.put("endTermMonth", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "MM"));
                    dataMap.put("endTermDay", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "dd"));
                    dataMap.put("guaranteeCompany1", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                } else {
                    dataMap.put("loanAmount", "");
                    dataMap.put("creditTerm", "");
                    dataMap.put("startTermYear", "");
                    dataMap.put("startTermMonth", "");
                    dataMap.put("startTermDay", "");
                    dataMap.put("endTermYear", "");
                    dataMap.put("endTermMonth", "");
                    dataMap.put("endTermDay", "");
                    dataMap.put("guaranteeCompany1", "");
                }
                if (guaranterLsit != null && guaranterLsit.size() > 0) {
                    BusLoanInfoGuaranter guaranter = guaranterLsit.get(0);
                    dataMap.put("guaranterName", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                } else {
                    dataMap.put("guaranterName", "");
                }
                wordName += "_5???????_" + DateUtil.getNowLongTime()
                        + ".doc";
                flag = createWords.create(dataMap, templatePath, "xiaoqiyejiekuanhetong5.ftl",
                        savePath + File.separator, wordName);
            } else if (wordType.equals("61")) {
                if (guaranterLsit != null && guaranterLsit.size() > 0) {
                    BusLoanInfoGuaranter guaranter = guaranterLsit.get(0);
                    dataMap.put("guaranterName", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                    dataMap.put("guaranterCard", StringUtil.getNotNullStr(guaranter.getGuaranterCard()));
                    dataMap.put("guaranterHouseAddress",
                            StringUtil.getNotNullStr(guaranter.getGuaranterHouseAddress()));
                    dataMap.put("guaranterEmployer", StringUtil.getNotNullStr(guaranter.getGuaranterEmployer()));
                    dataMap.put("guaranterPhone", StringUtil.getNotNullStr(guaranter.getGuaranterPhone()));
                } else {
                    dataMap.put("guaranterName", "");
                    dataMap.put("guaranterCard", "");
                    dataMap.put("guaranterHouseAddress", "");
                    dataMap.put("guaranterEmployer", "");
                    dataMap.put("guaranterPhone", "");
                }
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                if (lending != null) {
                    dataMap.put("loanAmount", StringUtil.getNotNullStr(lending.getLoanAmount()));
                    dataMap.put("startTermYear",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "yyyy"));
                    dataMap.put("startTermMonth",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "MM"));
                    dataMap.put("startTermDay", DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "dd"));
                    dataMap.put("endTermYear", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "yyyy"));
                    dataMap.put("endTermMonth", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "MM"));
                    dataMap.put("endTermDay", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "dd"));
                } else {
                    dataMap.put("loanAmount", "");
                    dataMap.put("startTermYear", "");
                    dataMap.put("startTermMonth", "");
                    dataMap.put("startTermDay", "");
                    dataMap.put("endTermYear", "");
                    dataMap.put("endTermMonth", "");
                    dataMap.put("endTermDay", "");
                }
                wordName += "_6?????1_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "gerenzuigaoe61.ftl", savePath + File.separator,
                        wordName);
            } else if (wordType.equals("62")) {
                if (guaranterLsit != null && guaranterLsit.size() > 1) {
                    BusLoanInfoGuaranter guaranter = guaranterLsit.get(1);
                    dataMap.put("guaranterName", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                    dataMap.put("guaranterCard", StringUtil.getNotNullStr(guaranter.getGuaranterCard()));
                    dataMap.put("guaranterHouseAddress",
                            StringUtil.getNotNullStr(guaranter.getGuaranterHouseAddress()));
                    dataMap.put("guaranterEmployer", StringUtil.getNotNullStr(guaranter.getGuaranterEmployer()));
                    dataMap.put("guaranterPhone", StringUtil.getNotNullStr(guaranter.getGuaranterPhone()));
                } else {
                    dataMap.put("guaranterName", "");
                    dataMap.put("guaranterCard", "");
                    dataMap.put("guaranterHouseAddress", "");
                    dataMap.put("guaranterEmployer", "");
                    dataMap.put("guaranterPhone", "");
                }
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                if (lending != null) {
                    dataMap.put("loanAmount", StringUtil.getNotNullStr(lending.getLoanAmount()));
                    dataMap.put("startTermYear",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "yyyy"));
                    dataMap.put("startTermMonth",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "MM"));
                    dataMap.put("startTermDay", DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "dd"));
                    dataMap.put("endTermYear", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "yyyy"));
                    dataMap.put("endTermMonth", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "MM"));
                    dataMap.put("endTermDay", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "dd"));
                } else {
                    dataMap.put("loanAmount", "");
                    dataMap.put("startTermYear", "");
                    dataMap.put("startTermMonth", "");
                    dataMap.put("startTermDay", "");
                    dataMap.put("endTermYear", "");
                    dataMap.put("endTermMonth", "");
                    dataMap.put("endTermDay", "");

                }
                wordName += "_6?????2_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "gerenzuigaoe62.ftl", savePath + File.separator,
                        wordName);
            } else if (wordType.equals("71") || wordType.equals("72")) {
                if (lending != null) {
                    dataMap.put("loanAmount", StringUtil.getNotNullStr(lending.getLoanAmount()));
                    dataMap.put("startTermYear",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "yyyy"));
                    dataMap.put("startTermMonth",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "MM"));
                    dataMap.put("startTermDay", DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "dd"));
                    dataMap.put("endTermYear", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "yyyy"));
                    dataMap.put("endTermMonth", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "MM"));
                    dataMap.put("endTermDay", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "dd"));
                } else {
                    dataMap.put("loanAmount", "");
                    dataMap.put("startTermYear", "");
                    dataMap.put("startTermMonth", "");
                    dataMap.put("startTermDay", "");
                    dataMap.put("endTermYear", "");
                    dataMap.put("endTermMonth", "");
                    dataMap.put("endTermDay", "");
                }
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                if (wordType.equals("71")) {
                    if (lending != null) {
                        dataMap.put("guaranteeCompany1", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                        dataMap.put("guaranteeAddress1", StringUtil.getNotNullStr(lending.getGuaranteeAddress1()));
                        dataMap.put("guaranteeLegal1", StringUtil.getNotNullStr(lending.getGuaranteeLegal1()));
                    } else {
                        dataMap.put("guaranteeCompany1", "");
                        dataMap.put("guaranteeAddress1", "");
                        dataMap.put("guaranteeLegal1", "");
                    }
                    wordName += "_7?????1_" + DateUtil.getNowLongTime() + ".doc";
                    flag = createWords.create(dataMap, templatePath, "zuigaoebaozhenghetong7.ftl",
                            savePath + File.separator, wordName);
                } else {
                    if (lending != null) {
                        dataMap.put("guaranteeCompany2", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                        dataMap.put("guaranteeAddress2", StringUtil.getNotNullStr(lending.getGuaranteeAddress2()));
                        dataMap.put("guaranteeLegal2", StringUtil.getNotNullStr(lending.getGuaranteeLegal2()));
                    } else {
                        dataMap.put("guaranteeCompany2", "");
                        dataMap.put("guaranteeAddress2", "");
                        dataMap.put("guaranteeLegal2", "");
                    }
                    wordName += "_7?????2_" + DateUtil.getNowLongTime() + ".doc";
                    flag = createWords.create(dataMap, templatePath, "zuigaoebaozhenghetong72.ftl",
                            savePath + File.separator, wordName);
                }

            } else if (wordType.equals("81")) {
                List<Map<String, Object>> holdersList = new ArrayList<Map<String, Object>>();
                if (lending != null) {
                    dataMap.put("numberOfShareHolders1",
                            StringUtil.getNotNullStr(lending.getNumberOfShareHolders1()));
                    dataMap.put("guaranteeCompany1", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                    String holders = lending.getShareHoldersName1();
                    if (holders != null && !holders.equals("")) {
                        holders = holders.replaceAll("?", "?");
                        String[] holdersArr = holders.split("?");
                        for (String value : holdersArr) {
                            Map<String, Object> map = new HashMap<String, Object>();
                            map.put("holdersName", value);
                            holdersList.add(map);
                        }
                    }
                } else {
                    dataMap.put("numberOfShareHolders1", "");
                    dataMap.put("guaranteeCompany1", "");
                }
                dataMap.put("holdersList", holdersList);
                wordName += "_8?????1_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "gudongqianziyangben8.ftl",
                        savePath + File.separator, wordName);
            } else if (wordType.equals("82")) {
                List<Map<String, Object>> holdersList = new ArrayList<Map<String, Object>>();
                if (lending != null) {
                    dataMap.put("numberOfShareHolders1",
                            StringUtil.getNotNullStr(lending.getNumberOfShareHolders2()));
                    dataMap.put("guaranteeCompany1", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                    String holders = lending.getShareHoldersName2();
                    if (holders != null && !holders.equals("")) {
                        holders = holders.replaceAll("?", "?");
                        String[] holdersArr = holders.split("?");
                        for (String value : holdersArr) {
                            Map<String, Object> map = new HashMap<String, Object>();
                            map.put("holdersName", value);
                            holdersList.add(map);
                        }
                    }
                } else {
                    dataMap.put("numberOfShareHolders1", "");
                    dataMap.put("guaranteeCompany1", "");
                }
                dataMap.put("holdersList", holdersList);
                wordName += "_8?????2_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "gudongqianziyangben8.ftl",
                        savePath + File.separator, wordName);
            } else if (wordType.equals("91")) {
                if (lending != null) {
                    dataMap.put("guaranteeCompany11", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                    dataMap.put("guaranteeCompany12", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                    dataMap.put("loanAmount", StringUtil.getNotNullStr(lending.getLoanAmount()));
                } else {
                    dataMap.put("guaranteeCompany11", "");
                    dataMap.put("guaranteeCompany12", "");
                    dataMap.put("loanAmount", "");
                }
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                wordName += "_91_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "gudonghuiyi91.ftl", savePath + File.separator,
                        wordName);
            } else if (wordType.equals("92")) {
                if (lending != null) {
                    dataMap.put("guaranteeCompany21", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                    dataMap.put("guaranteeCompany22", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                    dataMap.put("loanAmount", StringUtil.getNotNullStr(lending.getLoanAmount()));
                } else {
                    dataMap.put("guaranteeCompany21", "");
                    dataMap.put("guaranteeCompany22", "");
                    dataMap.put("loanAmount", "");
                }
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                wordName += "_92_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "gudonghuiyi92.ftl", savePath + File.separator,
                        wordName);
            } else if (wordType.equals("101")) {
                if (lending != null) {
                    dataMap.put("guaranteeLegal1", StringUtil.getNotNullStr(lending.getGuaranteeLegal1()));
                    dataMap.put("guaranteeCompany1", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                } else {
                    dataMap.put("guaranteeLegal1", "");
                    dataMap.put("guaranteeCompany1", "");
                }
                wordName += "_10??1_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "fadingdaibiaorenqianziyangben10_1.ftl",
                        savePath + File.separator, wordName);
            } else if (wordType.equals("102")) {
                if (lending != null) {
                    dataMap.put("guaranteeLegal2", StringUtil.getNotNullStr(lending.getGuaranteeLegal2()));
                    dataMap.put("guaranteeCompany2", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                } else {
                    dataMap.put("guaranteeLegal2", "");
                    dataMap.put("guaranteeCompany2", "");
                }
                wordName += "_10??2_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "fadingdaibiaorenqianziyangben10_2.ftl",
                        savePath + File.separator, wordName);
            } else if (wordType.equals("111")) {
                if (lending != null) {
                    dataMap.put("guaranteeCompany1", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                } else {
                    dataMap.put("guaranteeCompany1", "");
                }
                wordName += "_111_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "yuliugongzhang11_1.ftl",
                        savePath + File.separator, wordName);
            } else if (wordType.equals("112")) {
                if (lending != null) {
                    dataMap.put("guaranteeCompany2", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                } else {
                    dataMap.put("guaranteeCompany2", "");
                }
                wordName += "_112_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "yuliugongzhang11_2.ftl",
                        savePath + File.separator, wordName);
            } else if (wordType.equals("12")) {
                if (busLoanInfo != null) {
                    dataMap.put("applicationName1", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                    dataMap.put("applicationName2", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                    dataMap.put("applicationName3", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName1", "");
                    dataMap.put("applicationName2", "");
                    dataMap.put("applicationName3", "");
                }
                if (lending != null) {
                    dataMap.put("guaranteeCompany11", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                    dataMap.put("guaranteeCompany21", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                    dataMap.put("guaranteeCompany12", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                    dataMap.put("guaranteeCompany22", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                } else {
                    dataMap.put("guaranteeCompany11", "");
                    dataMap.put("guaranteeCompany21", "");
                    dataMap.put("guaranteeCompany12", "");
                    dataMap.put("guaranteeCompany22", "");
                }
                if (guaranterLsit != null && guaranterLsit.size() > 0) {
                    if (guaranterLsit.size() > 1) {
                        BusLoanInfoGuaranter guaranter = guaranterLsit.get(0);
                        BusLoanInfoGuaranter guaranter1 = guaranterLsit.get(1);
                        dataMap.put("guaranterName11", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                        dataMap.put("guaranterName12", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                        dataMap.put("guaranterName21", StringUtil.getNotNullStr(guaranter1.getGuaranterName()));
                        dataMap.put("guaranterName22", StringUtil.getNotNullStr(guaranter1.getGuaranterName()));
                    } else {
                        BusLoanInfoGuaranter guaranter = guaranterLsit.get(0);
                        dataMap.put("guaranterName11", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                        dataMap.put("guaranterName12", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                        dataMap.put("guaranterName21", "");
                        dataMap.put("guaranterName22", "");
                    }
                } else {
                    dataMap.put("guaranterName11", "");
                    dataMap.put("guaranterName21", "");
                    dataMap.put("guaranterName12", "");
                    dataMap.put("guaranterName22", "");
                }
                wordName += "_12??????_" + DateUtil.getNowLongTime()
                        + ".doc";
                flag = createWords.create(dataMap, templatePath, "xiaoqiyeshidijianzhengquerenshu12.ftl",
                        savePath + File.separator, wordName);
            } else if (wordType.equals("13")) {
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                wordName += "_13???_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "shouxinyewubanlishenqingshu13.ftl",
                        savePath + File.separator, wordName);
            } else if (wordType.equals("2")) {
                dataMap.put("surveyOrgName", StringUtil.getNotNullStr(busLoanInfo.getSurveyOrgName()));
                dataMap.put("surveyPersonName", StringUtil.getNotNullStr(busLoanInfo.getSurveyPersonName()));
                dataMap.put("surveyPhone", StringUtil.getNotNullStr(busLoanInfo.getSurveyPhone()));
                dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                dataMap.put("applicationAmount", StringUtil.getNotNullStr(busLoanInfo.getApplicationAmount()));
                dataMap.put("applicationTerm", StringUtil.getNotNullStr(busLoanInfo.getApplicationTerm()));
                dataMap.put("loanType", StringUtil.getNotNullStr(busLoanInfo.getLoanType()));
                dataMap.put("urgentCont", StringUtil.getNotNullStr(busLoanInfo.getUrgentCont()));
                dataMap.put("urgentContPhone", StringUtil.getNotNullStr(busLoanInfo.getUrgentContPhone()));
                dataMap.put("taobaoTreeDiamondMore",
                        StringUtil.getNotNullStr(busLoanInfo.getTaobaoTreeDiamondMore()));
                dataMap.put("otherPlatform", StringUtil.getNotNullStr(busLoanInfo.getOtherPlatform()));
                dataMap.put("operatingPeriodMore", StringUtil.getNotNullStr(busLoanInfo.getOperatingPeriodMore()));
                dataMap.put("ifShopOwner", StringUtil.getNotNullStr(busLoanInfo.getIfShopOwner()));
                dataMap.put("haveGuarantor", StringUtil.getNotNullStr(busLoanInfo.getHaveGuarantor()));
                dataMap.put("shopController", StringUtil.getNotNullStr(busLoanInfo.getShopController()));
                dataMap.put("salesOfMore", StringUtil.getNotNullStr(busLoanInfo.getSalesOfMore()));
                dataMap.put("than3credit", StringUtil.getNotNullStr(busLoanInfo.getThan3credit()));
                dataMap.put("notOverdue", StringUtil.getNotNullStr(busLoanInfo.getNotOverdue()));
                dataMap.put("perNotOverdue", StringUtil.getNotNullStr(busLoanInfo.getPerNotOverdue()));

                if (shopList != null && shopList.size() > 0) {
                    if (shopList.size() > 1) {
                        BusLoanInfoShop busLoanInfoShop = shopList.get(0);
                        BusLoanInfoShop busLoanInfoShop1 = shopList.get(1);
                        dataMap.put("shopName", StringUtil.getNotNullStr(busLoanInfoShop.getShopName()));
                        dataMap.put("platformName", StringUtil.getNotNullStr(busLoanInfoShop.getPlatformName()));
                        dataMap.put("shopLevel", StringUtil.getNotNullStr(busLoanInfoShop.getShopLevel()));
                        dataMap.put("operatingPeriod",
                                StringUtil.getNotNullStr(busLoanInfoShop.getOperatingPeriod()));
                        dataMap.put("shopOwner", StringUtil.getNotNullStr(busLoanInfoShop.getShopOwner()));
                        dataMap.put("businessOpera", StringUtil.getNotNullStr(busLoanInfoShop.getBusinessOpera()));
                        dataMap.put("businessAddress",
                                StringUtil.getNotNullStr(busLoanInfoShop.getBusinessAddress()));
                        dataMap.put("warehouseAddress",
                                StringUtil.getNotNullStr(busLoanInfoShop.getWarehouseAddress()));
                        dataMap.put("salesIncome", StringUtil.getNotNullStr(busLoanInfoShop.getSalesIncome()));
                        dataMap.put("totalLiability",
                                StringUtil.getNotNullStr(busLoanInfoShop.getTotalLiability()));
                        dataMap.put("bankLiabilities",
                                StringUtil.getNotNullStr(busLoanInfoShop.getBankLiabilities()));
                        dataMap.put("netProfit", StringUtil.getNotNullStr(busLoanInfoShop.getNetProfit()));

                        dataMap.put("shopName1", StringUtil.getNotNullStr(busLoanInfoShop1.getShopName()));
                        dataMap.put("platformName1", StringUtil.getNotNullStr(busLoanInfoShop1.getPlatformName()));
                        dataMap.put("shopLevel1", StringUtil.getNotNullStr(busLoanInfoShop1.getShopLevel()));
                        dataMap.put("operatingPeriod1",
                                StringUtil.getNotNullStr(busLoanInfoShop1.getOperatingPeriod()));
                        dataMap.put("shopOwner1", StringUtil.getNotNullStr(busLoanInfoShop1.getShopOwner()));
                        dataMap.put("businessOpera1",
                                StringUtil.getNotNullStr(busLoanInfoShop1.getBusinessOpera()));
                        dataMap.put("businessAddress1",
                                StringUtil.getNotNullStr(busLoanInfoShop1.getBusinessAddress()));
                        dataMap.put("warehouseAddress1",
                                StringUtil.getNotNullStr(busLoanInfoShop1.getWarehouseAddress()));
                        dataMap.put("salesIncome1", StringUtil.getNotNullStr(busLoanInfoShop1.getSalesIncome()));
                        dataMap.put("totalLiability1",
                                StringUtil.getNotNullStr(busLoanInfoShop1.getTotalLiability()));
                        dataMap.put("bankLiabilities1",
                                StringUtil.getNotNullStr(busLoanInfoShop1.getBankLiabilities()));
                        dataMap.put("netProfit1", StringUtil.getNotNullStr(busLoanInfoShop1.getNetProfit()));
                    } else {
                        BusLoanInfoShop busLoanInfoShop = shopList.get(0);
                        dataMap.put("shopName", StringUtil.getNotNullStr(busLoanInfoShop.getShopName()));
                        dataMap.put("platformName", StringUtil.getNotNullStr(busLoanInfoShop.getPlatformName()));
                        dataMap.put("shopLevel", StringUtil.getNotNullStr(busLoanInfoShop.getShopLevel()));
                        dataMap.put("operatingPeriod",
                                StringUtil.getNotNullStr(busLoanInfoShop.getOperatingPeriod()));
                        dataMap.put("shopOwner", StringUtil.getNotNullStr(busLoanInfoShop.getShopOwner()));
                        dataMap.put("businessOpera", StringUtil.getNotNullStr(busLoanInfoShop.getBusinessOpera()));
                        dataMap.put("businessAddress",
                                StringUtil.getNotNullStr(busLoanInfoShop.getBusinessAddress()));
                        dataMap.put("warehouseAddress",
                                StringUtil.getNotNullStr(busLoanInfoShop.getWarehouseAddress()));
                        dataMap.put("salesIncome", StringUtil.getNotNullStr(busLoanInfoShop.getSalesIncome()));
                        dataMap.put("totalLiability",
                                StringUtil.getNotNullStr(busLoanInfoShop.getTotalLiability()));
                        dataMap.put("bankLiabilities",
                                StringUtil.getNotNullStr(busLoanInfoShop.getBankLiabilities()));
                        dataMap.put("netProfit", StringUtil.getNotNullStr(busLoanInfoShop.getNetProfit()));

                        dataMap.put("shopName1", "");
                        dataMap.put("platformName1", "");
                        dataMap.put("shopLevel1", "");
                        dataMap.put("operatingPeriod1", "");
                        dataMap.put("shopOwner1", "");
                        dataMap.put("businessOpera1", "");
                        dataMap.put("businessAddress1", "");
                        dataMap.put("warehouseAddress1", "");
                        dataMap.put("salesIncome1", "");
                        dataMap.put("totalLiability1", "");
                        dataMap.put("bankLiabilities1", "");
                        dataMap.put("netProfit1", "");
                    }
                } else {
                    dataMap.put("shopName", "");
                    dataMap.put("platformName", "");
                    dataMap.put("shopLevel", "");
                    dataMap.put("operatingPeriod", "");
                    dataMap.put("shopOwner", "");
                    dataMap.put("businessOpera", "");
                    dataMap.put("businessAddress", "");
                    dataMap.put("warehouseAddress", "");
                    dataMap.put("salesIncome", "");
                    dataMap.put("totalLiability", "");
                    dataMap.put("bankLiabilities", "");
                    dataMap.put("netProfit", "");

                    dataMap.put("shopName1", "");
                    dataMap.put("platformName1", "");
                    dataMap.put("shopLevel1", "");
                    dataMap.put("operatingPeriod1", "");
                    dataMap.put("shopOwner1", "");
                    dataMap.put("businessOpera1", "");
                    dataMap.put("businessAddress1", "");
                    dataMap.put("warehouseAddress1", "");
                    dataMap.put("salesIncome1", "");
                    dataMap.put("totalLiability1", "");
                    dataMap.put("bankLiabilities1", "");
                    dataMap.put("netProfit1", "");
                }

                dataMap.put("legalPerson", StringUtil.getNotNullStr(legal.getLegalPerson()));
                dataMap.put("idCard", StringUtil.getNotNullStr(legal.getIdCard()));
                dataMap.put("householdRegistration", StringUtil.getNotNullStr(legal.getHouseholdRegistration()));
                dataMap.put("houseAddress", StringUtil.getNotNullStr(legal.getHouseAddress()));
                dataMap.put("legalPhone", StringUtil.getNotNullStr(legal.getLegalPhone()));
                dataMap.put("propertyQuantity", StringUtil.getNotNullStr(legal.getPropertyQuantity()));
                dataMap.put("totalArea", StringUtil.getNotNullStr(legal.getTotalArea()));
                dataMap.put("totalValue", StringUtil.getNotNullStr(legal.getTotalValue()));
                dataMap.put("mortgage", StringUtil.getNotNullStr(legal.getMortgage()));
                dataMap.put("propertyAddress", StringUtil.getNotNullStr(legal.getPropertyAddress()));
                dataMap.put("totalCar", StringUtil.getNotNullStr(legal.getTotalCar()));
                dataMap.put("licenseNumber", StringUtil.getNotNullStr(legal.getLicenseNumber()));
                dataMap.put("totalCarValue", StringUtil.getNotNullStr(legal.getTotalCarValue()));
                dataMap.put("otherAssets", StringUtil.getNotNullStr(legal.getOtherAssets()));
                dataMap.put("borrowOfBank", StringUtil.getNotNullStr(legal.getBorrowOfBank()));
                dataMap.put("amount", StringUtil.getNotNullStr(legal.getAmount()));
                dataMap.put("theTerm", StringUtil.getNotNullStr(legal.getTheTerm()));
                dataMap.put("ifController", StringUtil.getNotNullStr(legal.getIfController()));
                if (busLoanInfoController != null && legal.getIfController().equals("?")) {
                    dataMap.put("controllerName",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerName()));
                    dataMap.put("controllerIdCard",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerIdCard()));
                    dataMap.put("controllerRegistration",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerRegistration()));
                    dataMap.put("controllerHouseAddress",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerHouseAddress()));
                    dataMap.put("controllerPhone",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerPhone()));
                    dataMap.put("controllerPropertyQuantity",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerPropertyQuantity()));
                    dataMap.put("controllerTotalArea",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerTotalArea()));
                    dataMap.put("controllertotalValue",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllertotalValue()));
                    dataMap.put("contrallerMortgage",
                            StringUtil.getNotNullStr(busLoanInfoController.getContrallerMortgage()));
                    dataMap.put("controllerPropertyAddress",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerPropertyAddress()));
                    dataMap.put("controllerTotalCar",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerTotalCar()));
                    dataMap.put("controllerLicenseNumber",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerLicenseNumber()));
                    dataMap.put("controllerTotalCarValue",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerTotalCarValue()));
                    dataMap.put("controllerOtherAssets",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerOtherAssets()));
                    dataMap.put("controllerBorrowOfBank",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerBorrowOfBank()));
                    dataMap.put("controllerAmount",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerAmount()));
                    dataMap.put("controllerTheTerm",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerTheTerm()));
                } else {
                    //??
                    dataMap.put("controllerName", StringUtil.getNotNullStr(legal.getLegalPerson()));
                    dataMap.put("controllerIdCard", StringUtil.getNotNullStr(legal.getIdCard()));
                    dataMap.put("controllerRegistration",
                            StringUtil.getNotNullStr(legal.getHouseholdRegistration()));
                    dataMap.put("controllerHouseAddress", StringUtil.getNotNullStr(legal.getHouseAddress()));
                    dataMap.put("controllerPhone", StringUtil.getNotNullStr(legal.getHouseAddress()));
                    dataMap.put("controllerPropertyQuantity",
                            StringUtil.getNotNullStr(legal.getPropertyQuantity()));
                    dataMap.put("controllerTotalArea", StringUtil.getNotNullStr(legal.getTotalArea()));
                    dataMap.put("controllertotalValue", StringUtil.getNotNullStr(legal.getTotalValue()));
                    dataMap.put("contrallerMortgage", StringUtil.getNotNullStr(legal.getMortgage()));
                    dataMap.put("controllerPropertyAddress", StringUtil.getNotNullStr(legal.getPropertyAddress()));
                    dataMap.put("controllerTotalCar", StringUtil.getNotNullStr(legal.getTotalCar()));
                    dataMap.put("controllerLicenseNumber", StringUtil.getNotNullStr(legal.getLicenseNumber()));
                    dataMap.put("controllerTotalCarValue", StringUtil.getNotNullStr(legal.getTotalCarValue()));
                    dataMap.put("controllerOtherAssets", StringUtil.getNotNullStr(legal.getOtherAssets()));
                    dataMap.put("controllerBorrowOfBank", StringUtil.getNotNullStr(legal.getBorrowOfBank()));
                    dataMap.put("controllerAmount", StringUtil.getNotNullStr(legal.getAmount()));
                    dataMap.put("controllerTheTerm", StringUtil.getNotNullStr(legal.getTheTerm()));
                }
                dataMap.put("ifGuaranter", StringUtil.getNotNullStr(busLoanInfo.getIfGuaranter()));
                dataMap.put("guaranterName", StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterName()));
                dataMap.put("guaranterCard", StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterCard()));
                dataMap.put("guaranterEmployer",
                        StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterEmployer()));
                dataMap.put("guaranterDuties", StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterDuties()));
                dataMap.put("guaranterPhone", StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterPhone()));
                dataMap.put("guaranterMaritalStatus",
                        StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterMaritalStatus()));
                dataMap.put("guaranterHouseAddress",
                        StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterHouseAddress()));
                dataMap.put("guaranterMonthlyIncome",
                        StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterMonthlyIncome()));
                dataMap.put("guaranterValues", StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterValues()));
                dataMap.put("guaranterTotalLiabilities",
                        StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterTotalLiabilities()));
                dataMap.put("localPaySocialSecurity",
                        StringUtil.getNotNullStr(busLoanInfo.getLocalPaySocialSecurity()));
                dataMap.put("ifCustomersVIP", StringUtil.getNotNullStr(busLoanInfo.getIfCustomersVIP()));
                dataMap.put("childrenIfLocally", StringUtil.getNotNullStr(busLoanInfo.getChildrenIfLocally()));
                dataMap.put("additionInfo", StringUtil.getNotNullStr(busLoanInfo.getAdditionInfo()));
                wordName = wordName + "_2??_" + DateUtil.getNowPlusTimeMill() + ".xls";
                flag = createWords.create(dataMap, templatePath, "shangdaidiaochabiao2.ftl",
                        savePath + File.separator, wordName);
            } else if (wordType.equals("0")) {
                //1
                dataMap.put("lName1", StringUtil.getNotNullStr(busFiles.getlName()));
                dataMap.put("lIdCard1", StringUtil.getNotNullStr(busFiles.getlIdCard()));
                dataMap.put("lTelPhone1", StringUtil.getNotNullStr(busFiles.getlTelPhone()));
                dataMap.put("lName2", StringUtil.getNotNullStr(busFiles.getlName()));
                dataMap.put("lTelPhone2", StringUtil.getNotNullStr(busFiles.getlTelPhone()));
                dataMap.put("lName3", StringUtil.getNotNullStr(busFiles.getlName()));
                dataMap.put("lIdCard2", StringUtil.getNotNullStr(busFiles.getlIdCard()));
                dataMap.put("lTelPhone3", StringUtil.getNotNullStr(busFiles.getlTelPhone()));
                wordName += "_1??_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "daiqianwenjian1.ftl", savePath + File.separator,
                        wordName);
                wordName = busFiles.getlName();
                //3
                if (busLoanInfo != null) {
                    dataMap.put("applicationName1", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                    dataMap.put("applicationName2", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                    dataMap.put("applicationAmount", StringUtil.getNotNullStr(busLoanInfo.getApplicationAmount()));
                } else {
                    dataMap.put("applicationName1", "");
                    dataMap.put("applicationName2", "");
                    dataMap.put("applicationAmount", "");
                }
                if (legal != null) {
                    dataMap.put("idCard", StringUtil.getNotNullStr(legal.getIdCard()));
                    dataMap.put("idCardPeriod", StringUtil.getNotNullStr(legal.getIdCardPeriod()));
                    dataMap.put("idCardAddress", StringUtil.getNotNullStr(legal.getIdCardAddress()));
                    dataMap.put("legalPhone", StringUtil.getNotNullStr(legal.getLegalPhone()));
                } else {
                    dataMap.put("idCard", "");
                    dataMap.put("idCardPeriod", "");
                    dataMap.put("idCardAddress", "");
                    dataMap.put("legalPhone", "");
                }
                if (busLoanInfo.getChannel().equals("??")) {
                    wordName += "_3??_??_" + DateUtil.getNowLongTime() + ".doc";
                    flag = createWords.create(dataMap, templatePath, "ziliuliang3.ftl", savePath + File.separator,
                            wordName);
                } else if (busLoanInfo.getChannel().equals("?")) {
                    wordName += "_3??_?_" + DateUtil.getNowLongTime()
                            + ".doc";
                    flag = createWords.create(dataMap, templatePath, "yundaituisong3.ftl",
                            savePath + File.separator, wordName);
                }
                wordName = busFiles.getlName();
                //4
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                wordName += "_4?_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "dianshangdaihouxuzhi4.ftl",
                        savePath + File.separator, wordName);
                wordName = busFiles.getlName();
                //5
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                if (legal != null) {
                    dataMap.put("houseAddress", StringUtil.getNotNullStr(legal.getHouseAddress()));
                    dataMap.put("legalPhone", StringUtil.getNotNullStr(legal.getLegalPhone()));
                    dataMap.put("idCard", StringUtil.getNotNullStr(legal.getIdCard()));
                } else {
                    dataMap.put("houseAddress", "");
                    dataMap.put("legalPhone", "");
                    dataMap.put("idCard", "");
                }
                if (lending != null) {
                    dataMap.put("loanAmount", StringUtil.getNotNullStr(lending.getLoanAmount()));
                    dataMap.put("creditTerm", StringUtil.getNotNullStr(lending.getCreditTerm()));
                    dataMap.put("startTermYear",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "yyyy"));
                    dataMap.put("startTermMonth",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "MM"));
                    dataMap.put("startTermDay", DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "dd"));
                    dataMap.put("endTermYear", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "yyyy"));
                    dataMap.put("endTermMonth", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "MM"));
                    dataMap.put("endTermDay", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "dd"));
                    dataMap.put("guaranteeCompany1", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                } else {
                    dataMap.put("loanAmount", "");
                    dataMap.put("creditTerm", "");
                    dataMap.put("startTermYear", "");
                    dataMap.put("startTermMonth", "");
                    dataMap.put("startTermDay", "");
                    dataMap.put("endTermYear", "");
                    dataMap.put("endTermMonth", "");
                    dataMap.put("endTermDay", "");
                    dataMap.put("guaranteeCompany1", "");
                }
                if (guaranterLsit != null && guaranterLsit.size() > 0) {
                    BusLoanInfoGuaranter guaranter = guaranterLsit.get(0);
                    dataMap.put("guaranterName", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                } else {
                    dataMap.put("guaranterName", "");
                }
                wordName += "_5???????_" + DateUtil.getNowLongTime()
                        + ".doc";
                flag = createWords.create(dataMap, templatePath, "xiaoqiyejiekuanhetong5.ftl",
                        savePath + File.separator, wordName);
                wordName = busFiles.getlName();
                //6
                if (guaranterLsit != null && guaranterLsit.size() > 0) {
                    BusLoanInfoGuaranter guaranter = guaranterLsit.get(0);
                    dataMap.put("guaranterName", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                    dataMap.put("guaranterCard", StringUtil.getNotNullStr(guaranter.getGuaranterCard()));
                    dataMap.put("guaranterHouseAddress",
                            StringUtil.getNotNullStr(guaranter.getGuaranterHouseAddress()));
                    dataMap.put("guaranterEmployer", StringUtil.getNotNullStr(guaranter.getGuaranterEmployer()));
                    dataMap.put("guaranterPhone", StringUtil.getNotNullStr(guaranter.getGuaranterPhone()));
                } else {
                    dataMap.put("guaranterName", "");
                    dataMap.put("guaranterCard", "");
                    dataMap.put("guaranterHouseAddress", "");
                    dataMap.put("guaranterEmployer", "");
                    dataMap.put("guaranterPhone", "");
                }
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                if (lending != null) {
                    dataMap.put("loanAmount", StringUtil.getNotNullStr(lending.getLoanAmount()));
                    dataMap.put("startTermYear",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "yyyy"));
                    dataMap.put("startTermMonth",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "MM"));
                    dataMap.put("startTermDay", DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "dd"));
                    dataMap.put("endTermYear", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "yyyy"));
                    dataMap.put("endTermMonth", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "MM"));
                    dataMap.put("endTermDay", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "dd"));
                } else {
                    dataMap.put("loanAmount", "");
                    dataMap.put("startTermYear", "");
                    dataMap.put("startTermMonth", "");
                    dataMap.put("startTermDay", "");
                    dataMap.put("endTermYear", "");
                    dataMap.put("endTermMonth", "");
                    dataMap.put("endTermDay", "");
                }

                wordName += "_6?????1_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "gerenzuigaoe61.ftl", savePath + File.separator,
                        wordName);
                wordName = busFiles.getlName();

                if (guaranterLsit != null && guaranterLsit.size() > 1) {
                    BusLoanInfoGuaranter guaranter = guaranterLsit.get(1);
                    dataMap.put("guaranterName", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                    dataMap.put("guaranterCard", StringUtil.getNotNullStr(guaranter.getGuaranterCard()));
                    dataMap.put("guaranterHouseAddress",
                            StringUtil.getNotNullStr(guaranter.getGuaranterHouseAddress()));
                    dataMap.put("guaranterEmployer", StringUtil.getNotNullStr(guaranter.getGuaranterEmployer()));
                    dataMap.put("guaranterPhone", StringUtil.getNotNullStr(guaranter.getGuaranterPhone()));
                } else {
                    dataMap.put("guaranterName", "");
                    dataMap.put("guaranterCard", "");
                    dataMap.put("guaranterHouseAddress", "");
                    dataMap.put("guaranterEmployer", "");
                    dataMap.put("guaranterPhone", "");
                }
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                if (lending != null) {
                    dataMap.put("loanAmount", StringUtil.getNotNullStr(lending.getLoanAmount()));
                    dataMap.put("startTermYear",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "yyyy"));
                    dataMap.put("startTermMonth",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "MM"));
                    dataMap.put("startTermDay", DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "dd"));
                    dataMap.put("endTermYear", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "yyyy"));
                    dataMap.put("endTermMonth", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "MM"));
                    dataMap.put("endTermDay", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "dd"));
                } else {
                    dataMap.put("loanAmount", "");
                    dataMap.put("startTermYear", "");
                    dataMap.put("startTermMonth", "");
                    dataMap.put("startTermDay", "");
                    dataMap.put("endTermYear", "");
                    dataMap.put("endTermMonth", "");
                    dataMap.put("endTermDay", "");

                }
                wordName += "_6?????2_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "gerenzuigaoe62.ftl", savePath + File.separator,
                        wordName);
                wordName = busFiles.getlName();
                //7
                if (lending != null) {
                    dataMap.put("loanAmount", StringUtil.getNotNullStr(lending.getLoanAmount()));
                    dataMap.put("startTermYear",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "yyyy"));
                    dataMap.put("startTermMonth",
                            DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "MM"));
                    dataMap.put("startTermDay", DateUtil.getFormattedDateUtil((Date) lending.getStartTerm(), "dd"));
                    dataMap.put("endTermYear", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "yyyy"));
                    dataMap.put("endTermMonth", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "MM"));
                    dataMap.put("endTermDay", DateUtil.getFormattedDateUtil((Date) lending.getEndTerm(), "dd"));
                } else {
                    dataMap.put("loanAmount", "");
                    dataMap.put("startTermYear", "");
                    dataMap.put("startTermMonth", "");
                    dataMap.put("startTermDay", "");
                    dataMap.put("endTermYear", "");
                    dataMap.put("endTermMonth", "");
                    dataMap.put("endTermDay", "");
                }
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }

                if (lending != null) {
                    dataMap.put("guaranteeCompany1", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                    dataMap.put("guaranteeAddress1", StringUtil.getNotNullStr(lending.getGuaranteeAddress1()));
                    dataMap.put("guaranteeLegal1", StringUtil.getNotNullStr(lending.getGuaranteeLegal1()));
                } else {
                    dataMap.put("guaranteeCompany1", "");
                    dataMap.put("guaranteeAddress1", "");
                    dataMap.put("guaranteeLegal1", "");
                }
                wordName += "_7?????1_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "zuigaoebaozhenghetong7.ftl",
                        savePath + File.separator, wordName);
                wordName = busFiles.getlName();
                if (lending != null) {
                    dataMap.put("guaranteeCompany2", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                    dataMap.put("guaranteeAddress2", StringUtil.getNotNullStr(lending.getGuaranteeAddress2()));
                    dataMap.put("guaranteeLegal2", StringUtil.getNotNullStr(lending.getGuaranteeLegal2()));
                } else {
                    dataMap.put("guaranteeCompany2", "");
                    dataMap.put("guaranteeAddress2", "");
                    dataMap.put("guaranteeLegal2", "");
                }
                wordName += "_7?????2_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "zuigaoebaozhenghetong72.ftl",
                        savePath + File.separator, wordName);
                wordName = busFiles.getlName();
                //8
                List<Map<String, Object>> holdersList = new ArrayList<Map<String, Object>>();
                if (lending != null) {
                    dataMap.put("numberOfShareHolders1",
                            StringUtil.getNotNullStr(lending.getNumberOfShareHolders1()));
                    dataMap.put("guaranteeCompany1", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                    String holders = lending.getShareHoldersName1();
                    if (holders != null && !holders.equals("")) {
                        holders = holders.replaceAll("?", "?");
                        String[] holdersArr = holders.split("?");
                        for (String value : holdersArr) {
                            Map<String, Object> map = new HashMap<String, Object>();
                            map.put("holdersName", value);
                            holdersList.add(map);
                        }
                    }
                } else {
                    dataMap.put("numberOfShareHolders1", "");
                    dataMap.put("guaranteeCompany1", "");
                }
                dataMap.put("holdersList", holdersList);
                wordName += "_8?????1_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "gudongqianziyangben8.ftl",
                        savePath + File.separator, wordName);
                wordName = busFiles.getlName();
                List<Map<String, Object>> holdersList1 = new ArrayList<Map<String, Object>>();
                if (lending != null) {
                    dataMap.put("numberOfShareHolders1",
                            StringUtil.getNotNullStr(lending.getNumberOfShareHolders2()));
                    dataMap.put("guaranteeCompany1", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                    String holders = lending.getShareHoldersName2();
                    if (holders != null && !holders.equals("")) {
                        holders = holders.replaceAll("?", "?");
                        String[] holdersArr = holders.split("?");
                        for (String value : holdersArr) {
                            Map<String, Object> map = new HashMap<String, Object>();
                            map.put("holdersName", value);
                            holdersList1.add(map);
                        }
                    }
                } else {
                    dataMap.put("numberOfShareHolders1", "");
                    dataMap.put("guaranteeCompany1", "");
                }
                dataMap.put("holdersList", holdersList1);
                wordName += "_8?????2_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "gudongqianziyangben8.ftl",
                        savePath + File.separator, wordName);
                wordName = busFiles.getlName();
                //9
                if (lending != null) {
                    dataMap.put("guaranteeCompany11", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                    dataMap.put("guaranteeCompany12", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                    dataMap.put("loanAmount", StringUtil.getNotNullStr(lending.getLoanAmount()));
                } else {
                    dataMap.put("guaranteeCompany11", "");
                    dataMap.put("guaranteeCompany12", "");
                    dataMap.put("loanAmount", "");
                }
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                wordName += "_91_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "gudonghuiyi91.ftl", savePath + File.separator,
                        wordName);
                wordName = busFiles.getlName();

                if (lending != null) {
                    dataMap.put("guaranteeCompany21", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                    dataMap.put("guaranteeCompany22", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                    dataMap.put("loanAmount", StringUtil.getNotNullStr(lending.getLoanAmount()));
                } else {
                    dataMap.put("guaranteeCompany21", "");
                    dataMap.put("guaranteeCompany22", "");
                    dataMap.put("loanAmount", "");
                }
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                wordName += "_92_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "gudonghuiyi92.ftl", savePath + File.separator,
                        wordName);
                wordName = busFiles.getlName();
                //10
                if (lending != null) {
                    dataMap.put("guaranteeLegal1", StringUtil.getNotNullStr(lending.getGuaranteeLegal1()));
                    dataMap.put("guaranteeCompany1", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                } else {
                    dataMap.put("guaranteeLegal1", "");
                    dataMap.put("guaranteeCompany1", "");
                }
                wordName += "_10??1_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "fadingdaibiaorenqianziyangben10_1.ftl",
                        savePath + File.separator, wordName);
                wordName = busFiles.getlName();

                if (lending != null) {
                    dataMap.put("guaranteeLegal2", StringUtil.getNotNullStr(lending.getGuaranteeLegal2()));
                    dataMap.put("guaranteeCompany2", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                } else {
                    dataMap.put("guaranteeLegal2", "");
                    dataMap.put("guaranteeCompany2", "");
                }
                wordName += "_10??2_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "fadingdaibiaorenqianziyangben10_2.ftl",
                        savePath + File.separator, wordName);
                wordName = busFiles.getlName();
                //11
                if (lending != null) {
                    dataMap.put("guaranteeCompany1", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                } else {
                    dataMap.put("guaranteeCompany1", "");
                }
                wordName += "_111_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "yuliugongzhang11_1.ftl",
                        savePath + File.separator, wordName);
                wordName = busFiles.getlName();
                if (lending != null) {
                    dataMap.put("guaranteeCompany2", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                } else {
                    dataMap.put("guaranteeCompany2", "");
                }
                wordName += "_112_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "yuliugongzhang11_2.ftl",
                        savePath + File.separator, wordName);
                wordName = busFiles.getlName();
                //12
                if (busLoanInfo != null) {
                    dataMap.put("applicationName1", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                    dataMap.put("applicationName2", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                    dataMap.put("applicationName3", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName1", "");
                    dataMap.put("applicationName2", "");
                    dataMap.put("applicationName3", "");
                }
                if (lending != null) {
                    dataMap.put("guaranteeCompany11", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                    dataMap.put("guaranteeCompany21", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                    dataMap.put("guaranteeCompany12", StringUtil.getNotNullStr(lending.getGuaranteeCompany1()));
                    dataMap.put("guaranteeCompany22", StringUtil.getNotNullStr(lending.getGuaranteeCompany2()));
                } else {
                    dataMap.put("guaranteeCompany11", "");
                    dataMap.put("guaranteeCompany21", "");
                    dataMap.put("guaranteeCompany12", "");
                    dataMap.put("guaranteeCompany22", "");
                }
                if (guaranterLsit != null && guaranterLsit.size() > 0) {
                    if (guaranterLsit.size() > 1) {
                        BusLoanInfoGuaranter guaranter = guaranterLsit.get(0);
                        BusLoanInfoGuaranter guaranter1 = guaranterLsit.get(1);
                        dataMap.put("guaranterName11", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                        dataMap.put("guaranterName12", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                        dataMap.put("guaranterName21", StringUtil.getNotNullStr(guaranter1.getGuaranterName()));
                        dataMap.put("guaranterName22", StringUtil.getNotNullStr(guaranter1.getGuaranterName()));
                    } else {
                        BusLoanInfoGuaranter guaranter = guaranterLsit.get(0);
                        dataMap.put("guaranterName11", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                        dataMap.put("guaranterName12", StringUtil.getNotNullStr(guaranter.getGuaranterName()));
                        dataMap.put("guaranterName21", "");
                        dataMap.put("guaranterName22", "");
                    }
                } else {
                    dataMap.put("guaranterName11", "");
                    dataMap.put("guaranterName21", "");
                    dataMap.put("guaranterName12", "");
                    dataMap.put("guaranterName22", "");
                }
                wordName += "_12??????_" + DateUtil.getNowLongTime()
                        + ".doc";
                flag = createWords.create(dataMap, templatePath, "xiaoqiyeshidijianzhengquerenshu12.ftl",
                        savePath + File.separator, wordName);
                wordName = busFiles.getlName();
                //13
                if (busLoanInfo != null) {
                    dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                } else {
                    dataMap.put("applicationName", "");
                }
                wordName += "_13???_" + DateUtil.getNowLongTime() + ".doc";
                flag = createWords.create(dataMap, templatePath, "shouxinyewubanlishenqingshu13.ftl",
                        savePath + File.separator, wordName);
                wordName = busFiles.getlName();
                //2
                dataMap.put("surveyOrgName", StringUtil.getNotNullStr(busLoanInfo.getSurveyOrgName()));
                dataMap.put("surveyPersonName", StringUtil.getNotNullStr(busLoanInfo.getSurveyPersonName()));
                dataMap.put("surveyPhone", StringUtil.getNotNullStr(busLoanInfo.getSurveyPhone()));
                dataMap.put("applicationName", StringUtil.getNotNullStr(busLoanInfo.getApplicationName()));
                dataMap.put("applicationAmount", StringUtil.getNotNullStr(busLoanInfo.getApplicationAmount()));
                dataMap.put("applicationTerm", StringUtil.getNotNullStr(busLoanInfo.getApplicationTerm()));
                dataMap.put("loanType", StringUtil.getNotNullStr(busLoanInfo.getLoanType()));
                dataMap.put("urgentCont", StringUtil.getNotNullStr(busLoanInfo.getUrgentCont()));
                dataMap.put("urgentContPhone", StringUtil.getNotNullStr(busLoanInfo.getUrgentContPhone()));
                dataMap.put("taobaoTreeDiamondMore",
                        StringUtil.getNotNullStr(busLoanInfo.getTaobaoTreeDiamondMore()));
                dataMap.put("otherPlatform", StringUtil.getNotNullStr(busLoanInfo.getOtherPlatform()));
                dataMap.put("operatingPeriodMore", StringUtil.getNotNullStr(busLoanInfo.getOperatingPeriodMore()));
                dataMap.put("ifShopOwner", StringUtil.getNotNullStr(busLoanInfo.getIfShopOwner()));
                dataMap.put("haveGuarantor", StringUtil.getNotNullStr(busLoanInfo.getHaveGuarantor()));
                dataMap.put("shopController", StringUtil.getNotNullStr(busLoanInfo.getShopController()));
                dataMap.put("salesOfMore", StringUtil.getNotNullStr(busLoanInfo.getSalesOfMore()));
                dataMap.put("than3credit", StringUtil.getNotNullStr(busLoanInfo.getThan3credit()));
                dataMap.put("notOverdue", StringUtil.getNotNullStr(busLoanInfo.getNotOverdue()));
                dataMap.put("perNotOverdue", StringUtil.getNotNullStr(busLoanInfo.getPerNotOverdue()));

                if (shopList != null && shopList.size() > 0) {
                    if (shopList.size() > 1) {
                        BusLoanInfoShop busLoanInfoShop = shopList.get(0);
                        BusLoanInfoShop busLoanInfoShop1 = shopList.get(1);
                        dataMap.put("shopName", StringUtil.getNotNullStr(busLoanInfoShop.getShopName()));
                        dataMap.put("platformName", StringUtil.getNotNullStr(busLoanInfoShop.getPlatformName()));
                        dataMap.put("shopLevel", StringUtil.getNotNullStr(busLoanInfoShop.getShopLevel()));
                        dataMap.put("operatingPeriod",
                                StringUtil.getNotNullStr(busLoanInfoShop.getOperatingPeriod()));
                        dataMap.put("shopOwner", StringUtil.getNotNullStr(busLoanInfoShop.getShopOwner()));
                        dataMap.put("businessOpera", StringUtil.getNotNullStr(busLoanInfoShop.getBusinessOpera()));
                        dataMap.put("businessAddress",
                                StringUtil.getNotNullStr(busLoanInfoShop.getBusinessAddress()));
                        dataMap.put("warehouseAddress",
                                StringUtil.getNotNullStr(busLoanInfoShop.getWarehouseAddress()));
                        dataMap.put("salesIncome", StringUtil.getNotNullStr(busLoanInfoShop.getSalesIncome()));
                        dataMap.put("totalLiability",
                                StringUtil.getNotNullStr(busLoanInfoShop.getTotalLiability()));
                        dataMap.put("bankLiabilities",
                                StringUtil.getNotNullStr(busLoanInfoShop.getBankLiabilities()));
                        dataMap.put("netProfit", StringUtil.getNotNullStr(busLoanInfoShop.getNetProfit()));

                        dataMap.put("shopName1", StringUtil.getNotNullStr(busLoanInfoShop1.getShopName()));
                        dataMap.put("platformName1", StringUtil.getNotNullStr(busLoanInfoShop1.getPlatformName()));
                        dataMap.put("shopLevel1", StringUtil.getNotNullStr(busLoanInfoShop1.getShopLevel()));
                        dataMap.put("operatingPeriod1",
                                StringUtil.getNotNullStr(busLoanInfoShop1.getOperatingPeriod()));
                        dataMap.put("shopOwner1", StringUtil.getNotNullStr(busLoanInfoShop1.getShopOwner()));
                        dataMap.put("businessOpera1",
                                StringUtil.getNotNullStr(busLoanInfoShop1.getBusinessOpera()));
                        dataMap.put("businessAddress1",
                                StringUtil.getNotNullStr(busLoanInfoShop1.getBusinessAddress()));
                        dataMap.put("warehouseAddress1",
                                StringUtil.getNotNullStr(busLoanInfoShop1.getWarehouseAddress()));
                        dataMap.put("salesIncome1", StringUtil.getNotNullStr(busLoanInfoShop1.getSalesIncome()));
                        dataMap.put("totalLiability1",
                                StringUtil.getNotNullStr(busLoanInfoShop1.getTotalLiability()));
                        dataMap.put("bankLiabilities1",
                                StringUtil.getNotNullStr(busLoanInfoShop1.getBankLiabilities()));
                        dataMap.put("netProfit1", StringUtil.getNotNullStr(busLoanInfoShop1.getNetProfit()));
                    } else {
                        BusLoanInfoShop busLoanInfoShop = shopList.get(0);
                        dataMap.put("shopName", StringUtil.getNotNullStr(busLoanInfoShop.getShopName()));
                        dataMap.put("platformName", StringUtil.getNotNullStr(busLoanInfoShop.getPlatformName()));
                        dataMap.put("shopLevel", StringUtil.getNotNullStr(busLoanInfoShop.getShopLevel()));
                        dataMap.put("operatingPeriod",
                                StringUtil.getNotNullStr(busLoanInfoShop.getOperatingPeriod()));
                        dataMap.put("shopOwner", StringUtil.getNotNullStr(busLoanInfoShop.getShopOwner()));
                        dataMap.put("businessOpera", StringUtil.getNotNullStr(busLoanInfoShop.getBusinessOpera()));
                        dataMap.put("businessAddress",
                                StringUtil.getNotNullStr(busLoanInfoShop.getBusinessAddress()));
                        dataMap.put("warehouseAddress",
                                StringUtil.getNotNullStr(busLoanInfoShop.getWarehouseAddress()));
                        dataMap.put("salesIncome", StringUtil.getNotNullStr(busLoanInfoShop.getSalesIncome()));
                        dataMap.put("totalLiability",
                                StringUtil.getNotNullStr(busLoanInfoShop.getTotalLiability()));
                        dataMap.put("bankLiabilities",
                                StringUtil.getNotNullStr(busLoanInfoShop.getBankLiabilities()));
                        dataMap.put("netProfit", StringUtil.getNotNullStr(busLoanInfoShop.getNetProfit()));

                        dataMap.put("shopName1", "");
                        dataMap.put("platformName1", "");
                        dataMap.put("shopLevel1", "");
                        dataMap.put("operatingPeriod1", "");
                        dataMap.put("shopOwner1", "");
                        dataMap.put("businessOpera1", "");
                        dataMap.put("businessAddress1", "");
                        dataMap.put("warehouseAddress1", "");
                        dataMap.put("salesIncome1", "");
                        dataMap.put("totalLiability1", "");
                        dataMap.put("bankLiabilities1", "");
                        dataMap.put("netProfit1", "");
                    }
                } else {
                    dataMap.put("shopName", "");
                    dataMap.put("platformName", "");
                    dataMap.put("shopLevel", "");
                    dataMap.put("operatingPeriod", "");
                    dataMap.put("shopOwner", "");
                    dataMap.put("businessOpera", "");
                    dataMap.put("businessAddress", "");
                    dataMap.put("warehouseAddress", "");
                    dataMap.put("salesIncome", "");
                    dataMap.put("totalLiability", "");
                    dataMap.put("bankLiabilities", "");
                    dataMap.put("netProfit", "");

                    dataMap.put("shopName1", "");
                    dataMap.put("platformName1", "");
                    dataMap.put("shopLevel1", "");
                    dataMap.put("operatingPeriod1", "");
                    dataMap.put("shopOwner1", "");
                    dataMap.put("businessOpera1", "");
                    dataMap.put("businessAddress1", "");
                    dataMap.put("warehouseAddress1", "");
                    dataMap.put("salesIncome1", "");
                    dataMap.put("totalLiability1", "");
                    dataMap.put("bankLiabilities1", "");
                    dataMap.put("netProfit1", "");
                }

                dataMap.put("legalPerson", StringUtil.getNotNullStr(legal.getLegalPerson()));
                dataMap.put("idCard", StringUtil.getNotNullStr(legal.getIdCard()));
                dataMap.put("householdRegistration", StringUtil.getNotNullStr(legal.getHouseholdRegistration()));
                dataMap.put("houseAddress", StringUtil.getNotNullStr(legal.getHouseAddress()));
                dataMap.put("legalPhone", StringUtil.getNotNullStr(legal.getLegalPhone()));
                dataMap.put("propertyQuantity", StringUtil.getNotNullStr(legal.getPropertyQuantity()));
                dataMap.put("totalArea", StringUtil.getNotNullStr(legal.getTotalArea()));
                dataMap.put("totalValue", StringUtil.getNotNullStr(legal.getTotalValue()));
                dataMap.put("mortgage", StringUtil.getNotNullStr(legal.getMortgage()));
                dataMap.put("propertyAddress", StringUtil.getNotNullStr(legal.getPropertyAddress()));
                dataMap.put("totalCar", StringUtil.getNotNullStr(legal.getTotalCar()));
                dataMap.put("licenseNumber", StringUtil.getNotNullStr(legal.getLicenseNumber()));
                dataMap.put("totalCarValue", StringUtil.getNotNullStr(legal.getTotalCarValue()));
                dataMap.put("otherAssets", StringUtil.getNotNullStr(legal.getOtherAssets()));
                dataMap.put("borrowOfBank", StringUtil.getNotNullStr(legal.getBorrowOfBank()));
                dataMap.put("amount", StringUtil.getNotNullStr(legal.getAmount()));
                dataMap.put("theTerm", StringUtil.getNotNullStr(legal.getTheTerm()));
                dataMap.put("ifController", StringUtil.getNotNullStr(legal.getIfController()));
                if (busLoanInfoController != null && legal.getIfController().equals("?")) {
                    dataMap.put("controllerName",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerName()));
                    dataMap.put("controllerIdCard",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerIdCard()));
                    dataMap.put("controllerRegistration",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerRegistration()));
                    dataMap.put("controllerHouseAddress",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerHouseAddress()));
                    dataMap.put("controllerPhone",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerPhone()));
                    dataMap.put("controllerPropertyQuantity",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerPropertyQuantity()));
                    dataMap.put("controllerTotalArea",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerTotalArea()));
                    dataMap.put("controllertotalValue",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllertotalValue()));
                    dataMap.put("contrallerMortgage",
                            StringUtil.getNotNullStr(busLoanInfoController.getContrallerMortgage()));
                    dataMap.put("controllerPropertyAddress",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerPropertyAddress()));
                    dataMap.put("controllerTotalCar",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerTotalCar()));
                    dataMap.put("controllerLicenseNumber",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerLicenseNumber()));
                    dataMap.put("controllerTotalCarValue",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerTotalCarValue()));
                    dataMap.put("controllerOtherAssets",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerOtherAssets()));
                    dataMap.put("controllerBorrowOfBank",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerBorrowOfBank()));
                    dataMap.put("controllerAmount",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerAmount()));
                    dataMap.put("controllerTheTerm",
                            StringUtil.getNotNullStr(busLoanInfoController.getControllerTheTerm()));
                } else {
                    //??
                    dataMap.put("controllerName", StringUtil.getNotNullStr(legal.getLegalPerson()));
                    dataMap.put("controllerIdCard", StringUtil.getNotNullStr(legal.getIdCard()));
                    dataMap.put("controllerRegistration",
                            StringUtil.getNotNullStr(legal.getHouseholdRegistration()));
                    dataMap.put("controllerHouseAddress", StringUtil.getNotNullStr(legal.getHouseAddress()));
                    dataMap.put("controllerPhone", StringUtil.getNotNullStr(legal.getHouseAddress()));
                    dataMap.put("controllerPropertyQuantity",
                            StringUtil.getNotNullStr(legal.getPropertyQuantity()));
                    dataMap.put("controllerTotalArea", StringUtil.getNotNullStr(legal.getTotalArea()));
                    dataMap.put("controllertotalValue", StringUtil.getNotNullStr(legal.getTotalValue()));
                    dataMap.put("contrallerMortgage", StringUtil.getNotNullStr(legal.getMortgage()));
                    dataMap.put("controllerPropertyAddress", StringUtil.getNotNullStr(legal.getPropertyAddress()));
                    dataMap.put("controllerTotalCar", StringUtil.getNotNullStr(legal.getTotalCar()));
                    dataMap.put("controllerLicenseNumber", StringUtil.getNotNullStr(legal.getLicenseNumber()));
                    dataMap.put("controllerTotalCarValue", StringUtil.getNotNullStr(legal.getTotalCarValue()));
                    dataMap.put("controllerOtherAssets", StringUtil.getNotNullStr(legal.getOtherAssets()));
                    dataMap.put("controllerBorrowOfBank", StringUtil.getNotNullStr(legal.getBorrowOfBank()));
                    dataMap.put("controllerAmount", StringUtil.getNotNullStr(legal.getAmount()));
                    dataMap.put("controllerTheTerm", StringUtil.getNotNullStr(legal.getTheTerm()));
                }
                dataMap.put("ifGuaranter", StringUtil.getNotNullStr(busLoanInfo.getIfGuaranter()));
                dataMap.put("guaranterName", StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterName()));
                dataMap.put("guaranterCard", StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterCard()));
                dataMap.put("guaranterEmployer",
                        StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterEmployer()));
                dataMap.put("guaranterDuties", StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterDuties()));
                dataMap.put("guaranterPhone", StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterPhone()));
                dataMap.put("guaranterMaritalStatus",
                        StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterMaritalStatus()));
                dataMap.put("guaranterHouseAddress",
                        StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterHouseAddress()));
                dataMap.put("guaranterMonthlyIncome",
                        StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterMonthlyIncome()));
                dataMap.put("guaranterValues", StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterValues()));
                dataMap.put("guaranterTotalLiabilities",
                        StringUtil.getNotNullStr(busLoanInfoGuaranter.getGuaranterTotalLiabilities()));
                dataMap.put("localPaySocialSecurity",
                        StringUtil.getNotNullStr(busLoanInfo.getLocalPaySocialSecurity()));
                dataMap.put("ifCustomersVIP", StringUtil.getNotNullStr(busLoanInfo.getIfCustomersVIP()));
                dataMap.put("childrenIfLocally", StringUtil.getNotNullStr(busLoanInfo.getChildrenIfLocally()));
                dataMap.put("additionInfo", StringUtil.getNotNullStr(busLoanInfo.getAdditionInfo()));
                wordName = wordName + "_2??_" + DateUtil.getNowPlusTimeMill() + ".xls";
                flag = createWords.create(dataMap, templatePath, "shangdaidiaochabiao2.ftl",
                        savePath + File.separator, wordName);
                wordName = busFiles.getlName();

            }

        } catch (IOException e) {
            log.error("?:" + e.getMessage());
            context.put("message", "??");
            return forword("message/message", context);
        } catch (Exception e) {
            log.error("?:" + e.getMessage());
            context.put("message", "??");
            return forword("message/message", context);
        }
        if (flag) {
            try {
                String saveZipPath = request.getSession().getServletContext().getRealPath(
                        File.separator + "WEB-INF" + File.separator + "downloads" + File.separator + "ziptemp");//zip??,??
                File saveZipPathFile = new File(saveZipPath);
                if (!saveZipPathFile.exists()) {
                    saveZipPathFile.mkdirs();
                }
                String zipName = "word";
                if (busFiles.getlName() != null && !busFiles.getlName().equals("")) {
                    zipName = busFiles.getlName();
                }
                String zipSaveName = zipName + DateUtil.getNowLongTime() + ".zip";//??
                String sourceFile = ZipUtil.fileToZip(savePath, saveZipPath, zipSaveName);//??zip?+??
                if (sourceFile != null) {
                    File file = new File(sourceFile);
                    if (!file.exists()) {
                        log.error("?");
                        context.put("message", "??");
                        return forword("message/message", context);
                    }
                    //MIME
                    response.setContentType(request.getSession().getServletContext().getMimeType(zipSaveName));
                    //Content-Disposition
                    response.setHeader("Content-Disposition",
                            "attachment;filename=" + URLEncoder.encode(zipSaveName, "UTF-8"));
                    FileInputStream in = new FileInputStream(sourceFile);
                    OutputStream out = response.getOutputStream();
                    byte buffer[] = new byte[1024];
                    int len = 0;
                    while ((len = in.read(buffer)) > 0) {
                        out.write(buffer, 0, len);
                    }
                    in.close();
                    out.close();
                    if (file != null) {
                        file.delete();//zip
                        file = null;
                    }
                    if (saveZipPathFile != null) {
                        saveZipPathFile = null;
                    }
                    log.info("??");
                }
            } catch (IOException e) {
                log.error("IO" + e.getMessage());
                context.put("message", "??");
                return forword("message/message", context);
            } catch (Exception e) {
                log.error("" + e.getMessage());
                context.put("message", "??");
                return forword("message/message", context);
            }
        } else {
            log.error("word?");
            context.put("message", "??");
            return forword("message/message", context);
        }
        return null;
    }

}