/** @param args */
  public static void main(String[] args) {
    WfVersionBO version = new WfVersionBO();

    String processId = "jxstar2";
    Map<String, String> mpUser = FactoryUtil.newMap();
    mpUser.put("user_id", "administrator");
    mpUser.put("user_name", "东宏");
    version.newVersion(processId, mpUser);
  }
  /**
   * 取统计字段
   *
   * @param lsField -- 所有字段信息
   * @return
   */
  private static List<Map<String, String>> getStatField(List<Map<String, String>> lsField) {
    List<Map<String, String>> lsRet = FactoryUtil.newList();
    if (lsField == null) return lsRet;

    Map<String, String> mpField = null;
    String isstat = null;
    for (int i = 0, n = lsField.size(); i < n; i++) {
      mpField = lsField.get(i);

      isstat = mpField.get("is_stat");
      if (isstat.trim().equals("1")) lsRet.add(mpField);
    }

    return lsRet;
  }
  /**
   * 生成公告阅读记录
   *
   * @param msgId -- 消息ID
   * @param userId -- 用户ID
   * @param userName -- 用户名
   * @return
   */
  public String readBoard(String msgId, String userId, String userName) {
    Map<String, String> mpRead = FactoryUtil.newMap();
    mpRead.put("msg_id", msgId);
    mpRead.put("user_id", userId);
    mpRead.put("user_name", userName);
    mpRead.put("read_date", DateUtil.getTodaySec());

    String readId = DmDao.insert("plet_read", mpRead);
    if (readId == null || readId.length() == 0) {
      // "生成公告阅读记录失败!"
      setMessage(JsMessage.getValue("portlet.createboarderror"));
      return _returnFaild;
    }
    return _returnSuccess;
  }
  /**
   * 取表单中的所有图片元素。
   *
   * @param sheet -- 表单对象
   * @return
   */
  private static List<HSSFPicture> getAllPicture(HSSFSheet sheet) {
    List<HSSFPicture> lsPicture = FactoryUtil.newList();

    HSSFPatriarch draw = sheet.getDrawingPatriarch();
    if (draw == null) return lsPicture;

    // 取所有子图形位置
    List<HSSFShape> lsShape = draw.getChildren();
    if (lsShape == null || lsShape.isEmpty()) return lsPicture;

    for (int i = 0, n = lsShape.size(); i < n; i++) {
      HSSFShape shape = lsShape.get(i);
      if (shape instanceof HSSFPicture) {
        lsPicture.add((HSSFPicture) shape);
      }
    }
    return lsPicture;
  }
  /**
   * 复制来源表格中第1个SHEET中的图片到目标表格中的第1个SHEET中。
   *
   * @param destBook -- 目标表格
   * @param srcBook -- 来源表格
   */
  private static void copySheetImage(HSSFWorkbook destBook, HSSFWorkbook srcBook) {
    // 来源表单
    HSSFSheet srcSheet = srcBook.getSheetAt(0);
    // 目标表单
    HSSFSheet destSheet = destBook.getSheetAt(0);

    // 需要偏移的行数
    int endRowNum = destSheet.getPhysicalNumberOfRows();

    // 取来源表单中的图片对象
    List<HSSFPicture> lsSrcPicture = getAllPicture(srcSheet);
    _log.showDebug("----------source picture size:" + lsSrcPicture.size());

    // 取所有子图形数据,如果是主从报表且明细数据占多页时,则会报空指针错误
    List<HSSFPictureData> lsPicData = null;
    try {
      lsPicData = srcBook.getAllPictures();
    } catch (Exception e) {
      // e.printStackTrace();
      _log.showWarn("由于表单明细有多页,造成临时表的图片数据取不到,只能采用原表第1个图替代!");

      // 原表中也没有图片,则不处理图片复制了
      lsPicData = destBook.getAllPictures();
      if (lsPicData == null || lsPicData.isEmpty()) return;

      // 只取原表中第1个图片信息
      List<HSSFPictureData> destData = FactoryUtil.newList();
      for (int i = 0, n = lsSrcPicture.size(); i < n; i++) {
        destData.add(lsPicData.get(0));
      }
      lsPicData = destData;
    }
    if (lsPicData == null || lsPicData.isEmpty()) return;
    _log.showDebug("----------source data size:" + lsPicData.size());

    // data数量可能大于图片数量
    if (lsSrcPicture.size() > lsPicData.size()) {
      _log.showWarn("图片数量与数据数量不符!");
      return;
    }

    // 取图片管理器
    HSSFPatriarch destDraw = destSheet.getDrawingPatriarch();
    if (destDraw == null) {
      destDraw = destSheet.createDrawingPatriarch();
    }

    // 取原目标表单中的图片对象
    List<HSSFPicture> lsDestPicture = getAllPicture(destSheet);
    int index = lsDestPicture.size();

    for (int i = 0, n = lsSrcPicture.size(); i < n; i++) {
      // 取图片对象
      HSSFPicture picture = lsSrcPicture.get(i);
      // 根据图片序号取图片数据
      HSSFPictureData picdata = lsPicData.get(i);
      // 取图片字节信息
      byte[] datas = picdata.getData();

      // 取图片位置信息
      HSSFClientAnchor anchor = (HSSFClientAnchor) picture.getAnchor();

      // 添加行偏移值
      anchor.setRow1(anchor.getRow1() + endRowNum);
      anchor.setRow2(anchor.getRow2() + endRowNum);

      // 插入新图片,返回的新图片序号无效
      destBook.addPicture(datas, picdata.getFormat());
      // 上面代码中新建图片的序号没有考虑原有图片数量,所以取原图片数量+1作为新图片的序号
      index++;
      _log.showDebug("---------copy new image index=" + index);

      destDraw.createPicture(anchor, index);
    }
  }
  /**
   * 填充数据到表格对象。
   *
   * @param sheet -- 表格对象
   * @param lsData -- 输出数据记录
   * @param lsField -- 输出字段明细
   * @param pageSize -- 每页显示行数
   * @param pos -- 开始输出行数
   * @param curPage -- 当前是第几页
   * @param sumPage -- 总页数
   * @return
   */
  public static HSSFSheet fillGrid(
      HSSFSheet sheet,
      List<Map<String, String>> lsData,
      List<Map<String, String>> lsField,
      int pageSize,
      int pos,
      int curPage,
      int sumPage) {
    if (lsField == null || lsData == null) {
      _log.showWarn("data is null or field is null!");
      return sheet;
    }

    if (lsField.isEmpty() || lsData.isEmpty()) {
      _log.showDebug("data is empty or field is null!");
      return sheet;
    }

    HSSFRow row = null; // excel的行对象
    HSSFCell cell = null; // excel的列对象
    String strValue = null; // 每个格的信息内容
    Map<String, String> mpData = null; // 每条记录数据
    Map<String, String> mpField = null; // 每条个字段的信息

    // HSSFCellStyle style = null;			//excel单元格风格对象

    int posi = (pageSize > 0 && pos >= 0) ? pos : 0;
    int cnt = (pageSize <= 0) ? lsData.size() : pageSize + posi;
    int[] posis = new int[2];
    int index = 0, rowIndex = 0;
    int currRow = 0;
    int cntCol = 1; // 合计列的位置
    String strStyle = null, strColName = null, strColCode = null, strColTag = null;

    // 用于每页小计
    List<Map<String, String>> lsStatCol = getStatField(lsField);
    String isOutZero = "0";
    Map<String, String> mpStat = null, mpStatValue = FactoryUtil.newMap();
    String strCol = null;
    BigDecimal bdStat = null;
    boolean isStatCol = false;
    // 用于每页小计

    for (rowIndex = posi, index = 0; rowIndex < cnt; rowIndex++, index++) {
      if (lsData.size() <= rowIndex) break; // 如果rowIndex大于记录数
      mpData = lsData.get(rowIndex);

      for (int i = 0, n = lsField.size(); i < n; i++) {
        mpField = lsField.get(i);
        isOutZero = mpField.get("is_outzero");
        if (isOutZero == null) isOutZero = "1";
        strStyle = mpField.get("format"); // 字段格式

        strColName = mpField.get("display"); // 字段名称
        strColCode = mpField.get("col_code").toLowerCase(); // 字段编码
        strColTag = mpField.get("combo_code"); // 标签

        posis = getPosition(mpField.get("col_pos"));
        if (posis.length != 2) {
          _log.showWarn(strColName + " [" + mpField.get("col_pos") + "] position is error!");
          continue;
        }
        // _log.showDebug("col_code=" + strColCode + " col_pos=" + posis);

        row = sheet.getRow(posis[0] + index);
        currRow = posis[0] + index;
        if (row == null) row = sheet.createRow(posis[0] + index);

        cell = row.getCell(posis[1]);
        if (cell == null) cell = row.createCell(posis[1]);

        if (strColCode.equalsIgnoreCase("{CURUSERNAME}")) {
          // 当前用户
          if (_mpUser != null) strValue = _mpUser.get("user_name");
          else strValue = "";
        } else if (strColCode.equalsIgnoreCase("{CURDATE}")) {
          // 当前日期
          strValue = DateUtil.getToday();
        } else if (strColCode.equalsIgnoreCase("{CURDEPTNAME}")) {
          // 当前部门
          if (_mpUser != null) strValue = _mpUser.get("dept_name");
          else strValue = "";
        } else if (strColCode.equalsIgnoreCase("{NUMBER}")) {
          // 输出序号
          strValue = Integer.toString(rowIndex + 1);
          cntCol = (short) posis[1];
        } else if (strColCode.equalsIgnoreCase("{CURPAGENUM}")) {
          // 当前所在页数
          strValue = Integer.toString(curPage);
        } else if (strColCode.equalsIgnoreCase("{CURSUMPAGE}")) {
          // 当前共页数
          strValue = Integer.toString(sumPage);
        } else {
          // 设置cell的显示值
          strValue = mpData.get(strColCode);
          // 如果已经设置了0值不输出,并且当前值就是0,则输出空字符串
          strValue = (strValue != null) ? strValue : "";
          strValue = (strValue.equalsIgnoreCase("null")) ? "" : strValue;

          // 真实值与显示值
          strValue = getComboTitle(strValue, strColTag);
          // 转换数据格式
          strValue = convertValue(strValue, strStyle);
          if (isOutZero.equals("0")) strValue = getZeroOut(strValue, strStyle);
        }
        cell.setCellValue(strValue.trim());

        if (!lsStatCol.isEmpty()) {
          for (int iStat = 0, statNum = lsStatCol.size(); iStat < statNum; iStat++) {
            mpStat = lsStatCol.get(iStat);
            // _log.showDebug("mpStat = " + mpStat.toString());

            if (mpStat.isEmpty()) continue;
            strCol = (mpStat.get("col_code")).toLowerCase();
            // _log.showDebug("strCol = " + strCol + " | strValue = " + strValue);
            if (strColCode.equalsIgnoreCase(strCol)) {
              isStatCol = true;

              if (mpStatValue.get(strCol) == null) bdStat = new BigDecimal("0");
              else bdStat = new BigDecimal(mpStatValue.get(strCol));

              if (strValue.length() == 0) strValue = "0";
              // _log.showDebug("bdStat.add(new BigDecimal(strValue)) = " + bdStat.add(new
              // BigDecimal(strValue)));

              mpStatValue.put(strCol, bdStat.add(new BigDecimal(strValue)).toString());
            }
          }
        }
      }
    }

    // 填写每页小计
    if (isStatCol == true) {
      currRow++;
      row = sheet.getRow(currRow);
      if (row == null) row = sheet.createRow(currRow);
      cell = row.getCell(cntCol);
      if (cell == null) cell = row.createCell(cntCol);
      cell.setCellValue("小计");
      for (int i = 0, colNum = lsStatCol.size(); i < colNum; i++) {
        mpField = lsStatCol.get(i);
        posis = getPosition(mpField.get("col_pos"));

        // if (row == null) row = sheet.createRow(posi + cnt);

        cell = row.getCell(posis[1]);
        if (cell == null) cell = row.createCell(posis[1]);

        strColCode = (mpField.get("col_code")).toLowerCase();
        strValue = mpStatValue.get(strColCode);
        strStyle = mpField.get("format");
        strValue = convertValue(strValue, strStyle);
        cell.setCellValue(strValue.trim());
      }
    }
    return sheet;
  }
示例#7
0
/**
 * 主键编码规则为:前缀+3位随机数字+流水号 前缀 -- 采用项目代号; 3位随机号 -- 为保证主键值唯一 流水号 -- 采用唯一的数字;
 *
 * <p>主键序号生成设计思想与CodeCreator编码序号相同。
 *
 * @author TonyTan
 * @version 1.0, 2010-11-4
 */
public class KeyCreator {
  private static KeyCreator _instance = new KeyCreator();

  private static Log _log = Log.getInstance();
  private static BaseDao _dao = BaseDao.getInstance();

  // 每次取主键数量
  private static final int POOL_SIZE = 10000000;
  // 缓存不同表的键对象
  private static Map<String, KeyInfo> _keyList = FactoryUtil.newMap();

  private KeyCreator() {}

  public static KeyCreator getInstance() {
    return _instance;
  }

  /**
   * 创建一数据表的主键值.
   *
   * @param tableName - 数据表名
   * @return
   */
  public synchronized String createKey(String tableName) {
    return getKeyPrefix() + getRandom() + createSerialNo(tableName);
  }

  /**
   * 创建新的树型记录ID
   *
   * @param parentID
   * @param level
   * @param tableName
   * @param pkField
   * @param levelCol
   * @param dsName
   * @return
   */
  public synchronized String createTreeKey(
      String parentID,
      int level,
      String tableName,
      String pkField,
      String levelCol,
      String dsName) {
    if (parentID == null) parentID = "";

    StringBuilder selsql = new StringBuilder();
    StringBuilder wheresql = new StringBuilder();
    selsql.append(" select max(" + pkField + ") as maxval, count(" + pkField + ") as cnt ");
    wheresql.append(" from " + tableName);
    if (parentID.length() == 0) {
      wheresql.append(" where " + pkField + " like '%' ");
      wheresql.append(" and " + levelCol + " = " + level);
    } else {
      wheresql.append(" where " + pkField + " like '" + parentID + "%' ");
      wheresql.append(" and " + levelCol + " = " + level);
    }
    selsql.append(wheresql);

    _log.showDebug("treeid selectsql = " + selsql.toString());

    DaoParam param = _dao.createParam(selsql.toString());
    param.setDsName(dsName);
    Map<String, String> keyMap = _dao.queryMap(param);

    String maxVal = keyMap.get("maxval");
    if (maxVal.length() == 0) {
      if (parentID.length() == 0) {
        return "1001";
      } else {
        // 本级别第一个节点
        return parentID + "0001";
      }
    } else {
      if (maxVal.equals("9999")) {
        _log.showWarn("treeid exceed 9999!");
        return "9999";
      }
    }
    maxVal = "0000" + (Long.parseLong(maxVal) + 1);
    String treeID = parentID + maxVal.substring(maxVal.length() - 4, maxVal.length());

    return treeID;
  }

  /**
   * 取配置文件中的项目代号为主键前缀
   *
   * @return
   */
  private String getKeyPrefix() {
    String prefix = SystemConfig.getConfigByKey("ServerConfigs", "projectcode");
    if (prefix.length() == 0) prefix = "dh";
    return prefix;
  }

  /**
   * 取主键的序号
   *
   * @return
   */
  private String createSerialNo(String tableName) {
    KeyInfo keyInfo;

    tableName = tableName.toLowerCase();
    if (_keyList.containsKey(tableName)) {
      keyInfo = _keyList.get(tableName);
    } else {
      // 如果缓存对象数量超过1000,则清除所有缓存对象
      if (_keyList.size() > 1000) {
        _keyList.clear();
      }

      keyInfo = new KeyInfo(POOL_SIZE, tableName);
      _keyList.put(tableName, keyInfo);
    }

    // 取新的序号
    int serial = keyInfo.getNextKey();
    return Integer.toString(serial);
  }

  /**
   * 为确保主键万无一失,每个主键前加一个3位随机数
   *
   * @return
   */
  private String getRandom() {
    int random = (int) (Math.random() * 1000);
    StringBuilder fix = new StringBuilder(Integer.toString(random));

    int len = 3 - fix.length();
    for (int i = 0; i < len; fix.insert(0, '0'), i++) ;

    return fix.toString();
  }

  /**
   * 主键唯一序号生成类
   *
   * @author TonyTan
   * @version 1.0, 2010-11-2
   */
  private class KeyInfo {
    private int keyMax;
    private int keyMin;
    private int nextKey;
    private int poolSize;
    private String keyName;

    public KeyInfo(int poolSize, String keyName) {
      this.poolSize = poolSize;
      this.keyName = keyName;

      retrieveFromDB();
    }

    public int getNextKey() {
      if (nextKey > keyMax) {
        retrieveFromDB();
      }

      // 每次取新号时,更新当前最大值;采用累加1的方式可以解决多线程多事务累加不丢失的问题。
      String usql = "update sys_tableid set max_value = max_value + 1 where table_name = ?";
      DaoParam uparam = _dao.createParam(usql);
      uparam.addStringValue(keyName);
      if (!_dao.update(uparam)) {
        _log.showWarn("get next code no update error!! tablename={0}!!", keyName);
      }

      return nextKey++;
    }

    private void retrieveFromDB() {
      // 从数据库中取上次分配的最大值
      int dbmax = 0;
      String ssql = "select max_value from sys_tableid where table_name = ?";

      DaoParam sparam = _dao.createParam(ssql);
      sparam.addStringValue(keyName);
      Map<String, String> mpMax = _dao.queryMap(sparam);

      if (!mpMax.isEmpty()) {
        dbmax = Integer.parseInt(mpMax.get("max_value"));
      } else {
        // 新建一条记录
        String usql = "insert into sys_tableid(max_value, table_name) values(0, ?)";
        DaoParam uparam = _dao.createParam(usql);
        uparam.addStringValue(keyName);
        if (!_dao.update(uparam)) {
          _log.showWarn("get next keyid no update error!! tablename={0}!!", keyName);
        }
      }

      keyMax = dbmax + poolSize;
      keyMin = dbmax + 1;
      nextKey = keyMin;
    }
  }
}