Beispiel #1
0
  private void initSearchDate() {
    if (propertyUnitCond == null) {
      propertyUnitCond = new PropertyUnitCond();

      propertyUnitCond.addPermissionCompanyProjectIds(
          PermissionUtils.getUserProjectIdList(EnumPrivCode.REPORT_SALEUNIT_STAT));
      propertyUnitCond.setSearchCompanyProjectIds(propertyUnitCond.getPrivCompanyProjectIds());

      //			propertyUnitCond.setDate1(CommonUtils.getMonthFirstForString());
      propertyUnitCond.setDate2(CommonUtils.getMonthEndForString());
    } else if (propertyUnitCond.getPrivCompanyProjectIds() == null) {
      propertyUnitCond.addPermissionCompanyProjectIds(
          PermissionUtils.getUserProjectIdList(EnumPrivCode.REPORT_SALEUNIT_STAT));
    }
  }
Beispiel #2
0
  /** 查看项目列定义 */
  public String queryXshlfxLcL() {

    // 增加报表子分类的条件
    ReportDefineColumnCond condColumn = new ReportDefineColumnCond();

    // 从缓存当中取选择的项目
    PropertyUnitCond cond = new PropertyUnitCond();
    cond = (PropertyUnitCond) request.getSession().getAttribute("cond");

    if (cond == null) {
      return "suc";
    }

    CompanyProjectCond conds = new CompanyProjectCond();
    conds.setProjectIds(cond.getSearchCompanyProjectIds());

    List<CompanyProject> project = companyProjectServices.findCompanyProjectByCond(conds);

    condColumn.setReportName(ContReportName.XSHLFX_LC);
    if (cond.getSearchCompanyProjectIds().size() > 1) {
      int companyId = DescUtils.getCompanyIdByProjectId(cond.getSearchCompanyProjectIds().get(0));
      condColumn.setCompanyId(String.valueOf(companyId));
      condColumn.setProjectId("");
    } else if (cond.getSearchCompanyProjectIds().size() == 1) {
      int companyId = DescUtils.getCompanyIdByProjectId(cond.getSearchCompanyProjectIds().get(0));
      condColumn.setProjectId(String.valueOf(cond.getSearchCompanyProjectIds().get(0)));
    } else {
      return "suc"; // 没有选择项目或者公司,直接不查询数据库输出
    }
    List<Map> listReportDefineColumn =
        reportDefineColumnServices.findReportDefineColumnAndType(condColumn);

    // 步骤1:进行List的定义,直接对应于html页面的Table
    ArrayList<ReportShowTR> trList = new ArrayList();

    for (int i = 0; i < project.size(); i++) {
      CompanyProject pro = project.get(i);

      for (int j = 0; j < listReportDefineColumn.size(); j++) {

        if (listReportDefineColumn.get(j).get("projectId") == null) continue;

        if (pro.getId()
            == Integer.parseInt(listReportDefineColumn.get(j).get("projectId").toString())) {
          ReportShowTR showTR = new ReportShowTR();
          ReportShowTD td1 = new ReportShowTD();
          td1.setXyValueText(pro.getProjectName());
          showTR.addTD(td1);

          ReportShowTD td2 = new ReportShowTD();
          if (!listReportDefineColumn.get(j).get("companyId").toString().equals("0")) {
            td2.setXyValueText("项目定义列");
          } else {
            td2.setXyValueText("公司定义列");
          }
          showTR.addTD(td2);

          ReportShowTD td4 = new ReportShowTD();
          td4.setXyValueText(listReportDefineColumn.get(j).get("typeName").toString());
          showTR.addTD(td4);

          ReportShowTD td3 = new ReportShowTD();
          td3.setXyValueText(listReportDefineColumn.get(j).get("showName").toString());
          showTR.addTD(td3);

          trList.add(showTR);
        }
      }
    }

    String str = ReportShowUtils.getTrsByListTR(trList);
    ActionContext.getContext().getValueStack().set("showTable", str);
    return "suc";
  }