Package org.jeecgframework.web.cgform.entity.config

Examples of org.jeecgframework.web.cgform.entity.config.CgFormHeadEntity


      //step.3 填充主表的所有智能表单配置
      String mainTable = codeParamEntityIn.getTableName();
      //主表的智能表单配置
      GenerateEntity mainG = new GenerateEntity();
      mainG.setProjectPath(subTableListEntity.getProjectPath());
      CgFormHeadEntity mCgFormHead = cgFormFieldService.getCgFormHeadByTableName(mainTable);
      getCgformConfig(mCgFormHead, mainG);
      //step.4 填充子表的所有智能表单配置
      Map<String,GenerateEntity> subsG = new HashMap<String,GenerateEntity>();
      List<SubTableEntity>  subTabParamIn = subTableListEntity.getSubTabParamIn();
      for(SubTableEntity po:subTabParamIn){
        String sTableName = po.getTableName();
        CgFormHeadEntity cgSubHead = cgFormFieldService.getCgFormHeadByTableName(sTableName);
        List<CgFormFieldEntity> colums = cgSubHead.getColumns();
        String[] foreignKeys =getForeignkeys(colums);
        po.setForeignKeys(foreignKeys);
        GenerateEntity subG = new GenerateEntity();
        getCgformConfig(cgSubHead, subG);
        subG.setEntityName(po.getEntityName());
View Full Code Here


            rs=st.executeQuery(sql11);
            List cghead = new ArrayList();
            i=1;
            while(rs.next())
            {
                CgFormHeadEntity head = new CgFormHeadEntity();
                head.setId(i+"");
                head.setTableName(rs.getString("table_name"));
                head.setIsTree(rs.getString("is_tree"));
                head.setIsPagination(rs.getString("is_pagination"));
                head.setQuerymode(rs.getString("queryMode"));
                head.setIsCheckbox(rs.getString("is_checkbox"));
                head.setIsDbSynch(rs.getString("is_dbsynch"));
                head.setContent(rs.getString("content"));
                head.setJformVersion(rs.getString("JFORM_VERSION"));
                head.setJformType(rs.getInt("jform_type"));
                head.setColumns(getCgFormItem(sql10, rs.getString("id")));
                cghead.add(head);
                i++;
            }
            root.put("cghead", cghead);
//            rs=st.executeQuery(sql10);
View Full Code Here

   * @Description 同步智能表单字段表
   * @author tanghan 2013-7-28
   */
  private void repairCgFormField() {
    // 表单[订单主信息] - 字段清单
    CgFormHeadEntity jform_order_main = commonDao.findByProperty(
        CgFormHeadEntity.class, "tableName", "jform_order_main").get(0);
    CgFormFieldEntity jform_order_main_id = new CgFormFieldEntity();
    jform_order_main_id.setFieldName("id");
    jform_order_main_id.setTable(jform_order_main);
    jform_order_main_id.setFieldLength(0);
    jform_order_main_id.setIsKey("Y");
    jform_order_main_id.setIsNull("N");
    jform_order_main_id.setIsQuery("N");
    jform_order_main_id.setIsShow("N");
    jform_order_main_id.setIsShowList("N");
    jform_order_main_id.setShowType("text");
    jform_order_main_id.setLength(36);
    jform_order_main_id.setType("string");
    jform_order_main_id.setOrderNum(0);
    jform_order_main_id.setPointLength(0);
    jform_order_main_id.setQueryMode("single");
    jform_order_main_id.setContent("主键");
    jform_order_main_id.setCreateBy("admin");
    jform_order_main_id.setCreateDate(new Date());
    jform_order_main_id.setCreateName("管理员");
    jform_order_main_id.setDictField("");
    jform_order_main_id.setDictTable("");
    jform_order_main_id.setMainTable("");
    jform_order_main_id.setMainField("");
    commonDao.saveOrUpdate(jform_order_main_id);

    CgFormFieldEntity jform_order_main_order_code = new CgFormFieldEntity();
    jform_order_main_order_code.setFieldName("order_code");
    jform_order_main_order_code.setTable(jform_order_main);
    jform_order_main_order_code.setFieldLength(0);
    jform_order_main_order_code.setIsKey("N");
    jform_order_main_order_code.setIsNull("Y");
    jform_order_main_order_code.setIsQuery("Y");
    jform_order_main_order_code.setIsShow("Y");
    jform_order_main_order_code.setIsShowList("Y");
    jform_order_main_order_code.setShowType("text");
    jform_order_main_order_code.setLength(50);
    jform_order_main_order_code.setType("string");
    jform_order_main_order_code.setOrderNum(1);
    jform_order_main_order_code.setPointLength(0);
    jform_order_main_order_code.setQueryMode("single");
    jform_order_main_order_code.setContent("订单号");
    jform_order_main_order_code.setCreateBy("admin");
    jform_order_main_order_code.setCreateDate(new Date());
    jform_order_main_order_code.setCreateName("管理员");
    jform_order_main_order_code.setDictField("");
    jform_order_main_order_code.setDictTable("");
    jform_order_main_order_code.setMainTable("");
    jform_order_main_order_code.setMainField("");
    commonDao.saveOrUpdate(jform_order_main_order_code);

    CgFormFieldEntity jform_order_main_order_date = new CgFormFieldEntity();
    jform_order_main_order_date.setFieldName("order_date");
    jform_order_main_order_date.setTable(jform_order_main);
    jform_order_main_order_date.setFieldLength(0);
    jform_order_main_order_date.setIsKey("N");
    jform_order_main_order_date.setIsNull("Y");
    jform_order_main_order_date.setIsQuery("Y");
    jform_order_main_order_date.setIsShow("Y");
    jform_order_main_order_date.setIsShowList("Y");
    jform_order_main_order_date.setShowType("date");
    jform_order_main_order_date.setLength(20);
    jform_order_main_order_date.setType("Date");
    jform_order_main_order_date.setOrderNum(2);
    jform_order_main_order_date.setPointLength(0);
    jform_order_main_order_date.setQueryMode("single");
    jform_order_main_order_date.setContent("订单日期");
    jform_order_main_order_date.setCreateBy("admin");
    jform_order_main_order_date.setCreateDate(new Date());
    jform_order_main_order_date.setCreateName("管理员");
    jform_order_main_order_date.setDictField("");
    jform_order_main_order_date.setDictTable("");
    jform_order_main_order_date.setMainTable("");
    jform_order_main_order_date.setMainField("");
    commonDao.saveOrUpdate(jform_order_main_order_date);

    CgFormFieldEntity jform_order_main_order_money = new CgFormFieldEntity();
    jform_order_main_order_money.setFieldName("order_money");
    jform_order_main_order_money.setTable(jform_order_main);
    jform_order_main_order_money.setFieldLength(0);
    jform_order_main_order_money.setIsKey("N");
    jform_order_main_order_money.setIsNull("Y");
    jform_order_main_order_money.setIsQuery("Y");
    jform_order_main_order_money.setIsShow("Y");
    jform_order_main_order_money.setIsShowList("Y");
    jform_order_main_order_money.setShowType("text");
    jform_order_main_order_money.setLength(10);
    jform_order_main_order_money.setType("double");
    jform_order_main_order_money.setOrderNum(3);
    jform_order_main_order_money.setPointLength(3);
    jform_order_main_order_money.setQueryMode("single");
    jform_order_main_order_money.setContent("订单金额");
    jform_order_main_order_money.setCreateBy("admin");
    jform_order_main_order_money.setCreateDate(new Date());
    jform_order_main_order_money.setCreateName("管理员");
    jform_order_main_order_money.setDictField("");
    jform_order_main_order_money.setDictTable("");
    jform_order_main_order_money.setMainTable("");
    jform_order_main_order_money.setMainField("");
    commonDao.saveOrUpdate(jform_order_main_order_money);

    CgFormFieldEntity jform_order_main_content = new CgFormFieldEntity();
    jform_order_main_content.setFieldName("content");
    jform_order_main_content.setTable(jform_order_main);
    jform_order_main_content.setFieldLength(0);
    jform_order_main_content.setIsKey("N");
    jform_order_main_content.setIsNull("Y");
    jform_order_main_content.setIsQuery("Y");
    jform_order_main_content.setIsShow("Y");
    jform_order_main_content.setIsShowList("Y");
    jform_order_main_content.setShowType("text");
    jform_order_main_content.setLength(255);
    jform_order_main_content.setType("string");
    jform_order_main_content.setOrderNum(4);
    jform_order_main_content.setPointLength(0);
    jform_order_main_content.setQueryMode("single");
    jform_order_main_content.setContent("备注");
    jform_order_main_content.setCreateBy("admin");
    jform_order_main_content.setCreateDate(new Date());
    jform_order_main_content.setCreateName("管理员");
    jform_order_main_content.setDictField("");
    jform_order_main_content.setDictTable("");
    jform_order_main_content.setMainTable("");
    jform_order_main_content.setMainField("");
    commonDao.saveOrUpdate(jform_order_main_content);

    // 表单[请假单] - 字段清单
    CgFormHeadEntity jform_leave = commonDao.findByProperty(
        CgFormHeadEntity.class, "tableName", "jform_leave").get(0);
    CgFormFieldEntity jform_leave_id = new CgFormFieldEntity();
    jform_leave_id.setFieldName("id");
    jform_leave_id.setTable(jform_leave);
    jform_leave_id.setFieldLength(0);
    jform_leave_id.setIsKey("Y");
    jform_leave_id.setIsNull("N");
    jform_leave_id.setIsQuery("N");
    jform_leave_id.setIsShow("N");
    jform_leave_id.setIsShowList("N");
    jform_leave_id.setShowType("text");
    jform_leave_id.setLength(36);
    jform_leave_id.setType("string");
    jform_leave_id.setOrderNum(0);
    jform_leave_id.setPointLength(0);
    jform_leave_id.setQueryMode("single");
    jform_leave_id.setContent("主键");
    jform_leave_id.setCreateBy("admin");
    jform_leave_id.setCreateDate(new Date());
    jform_leave_id.setCreateName("管理员");
    jform_leave_id.setDictField("");
    jform_leave_id.setDictTable("");
    jform_leave_id.setMainTable("");
    jform_leave_id.setMainField("");
    commonDao.saveOrUpdate(jform_leave_id);

    CgFormFieldEntity jform_leave_title = new CgFormFieldEntity();
    jform_leave_title.setFieldName("title");
    jform_leave_title.setTable(jform_leave);
    jform_leave_title.setFieldLength(0);
    jform_leave_title.setIsKey("N");
    jform_leave_title.setIsNull("N");
    jform_leave_title.setIsQuery("N");
    jform_leave_title.setIsShow("Y");
    jform_leave_title.setIsShowList("Y");
    jform_leave_title.setShowType("text");
    jform_leave_title.setLength(50);
    jform_leave_title.setType("string");
    jform_leave_title.setOrderNum(1);
    jform_leave_title.setPointLength(0);
    jform_leave_title.setQueryMode("single");
    jform_leave_title.setContent("请假标题");
    jform_leave_title.setCreateBy("admin");
    jform_leave_title.setCreateDate(new Date());
    jform_leave_title.setCreateName("管理员");
    jform_leave_title.setDictField("");
    jform_leave_title.setDictTable("");
    jform_leave_title.setMainTable("");
    jform_leave_title.setMainField("");
    commonDao.saveOrUpdate(jform_leave_title);

    CgFormFieldEntity jform_leave_people = new CgFormFieldEntity();
    jform_leave_people.setFieldName("people");
    jform_leave_people.setTable(jform_leave);
    jform_leave_people.setFieldLength(0);
    jform_leave_people.setIsKey("N");
    jform_leave_people.setIsNull("N");
    jform_leave_people.setIsQuery("Y");
    jform_leave_people.setIsShow("Y");
    jform_leave_people.setIsShowList("Y");
    jform_leave_people.setShowType("text");
    jform_leave_people.setLength(20);
    jform_leave_people.setType("string");
    jform_leave_people.setOrderNum(2);
    jform_leave_people.setPointLength(0);
    jform_leave_people.setQueryMode("single");
    jform_leave_people.setContent("请假人");
    jform_leave_people.setCreateBy("admin");
    jform_leave_people.setCreateDate(new Date());
    jform_leave_people.setCreateName("管理员");
    jform_leave_people.setDictField("");
    jform_leave_people.setDictTable("");
    jform_leave_people.setMainTable("");
    jform_leave_people.setMainField("");
    commonDao.saveOrUpdate(jform_leave_people);

    CgFormFieldEntity jform_leave_sex = new CgFormFieldEntity();
    jform_leave_sex.setFieldName("sex");
    jform_leave_sex.setTable(jform_leave);
    jform_leave_sex.setFieldLength(0);
    jform_leave_sex.setIsKey("N");
    jform_leave_sex.setIsNull("N");
    jform_leave_sex.setIsQuery("Y");
    jform_leave_sex.setIsShow("Y");
    jform_leave_sex.setIsShowList("Y");
    jform_leave_sex.setShowType("list");
    jform_leave_sex.setLength(10);
    jform_leave_sex.setType("string");
    jform_leave_sex.setOrderNum(3);
    jform_leave_sex.setPointLength(0);
    jform_leave_sex.setQueryMode("single");
    jform_leave_sex.setContent("性别");
    jform_leave_sex.setCreateBy("admin");
    jform_leave_sex.setCreateDate(new Date());
    jform_leave_sex.setCreateName("管理员");
    jform_leave_sex.setDictField("sex");
    jform_leave_sex.setDictTable("");
    jform_leave_sex.setMainTable("");
    jform_leave_sex.setMainField("");
    commonDao.saveOrUpdate(jform_leave_sex);

    CgFormFieldEntity jform_leave_begindate = new CgFormFieldEntity();
    jform_leave_begindate.setFieldName("begindate");
    jform_leave_begindate.setTable(jform_leave);
    jform_leave_begindate.setFieldLength(0);
    jform_leave_begindate.setIsKey("N");
    jform_leave_begindate.setIsNull("N");
    jform_leave_begindate.setIsQuery("N");
    jform_leave_begindate.setIsShow("Y");
    jform_leave_begindate.setIsShowList("Y");
    jform_leave_begindate.setShowType("date");
    jform_leave_begindate.setLength(0);
    jform_leave_begindate.setType("Date");
    jform_leave_begindate.setOrderNum(4);
    jform_leave_begindate.setPointLength(0);
    jform_leave_begindate.setQueryMode("group");
    jform_leave_begindate.setContent("请假开始时间");
    jform_leave_begindate.setCreateBy("admin");
    jform_leave_begindate.setCreateDate(new Date());
    jform_leave_begindate.setCreateName("管理员");
    jform_leave_begindate.setDictField("");
    jform_leave_begindate.setDictTable("");
    jform_leave_begindate.setMainTable("");
    jform_leave_begindate.setMainField("");
    commonDao.saveOrUpdate(jform_leave_begindate);

    CgFormFieldEntity jform_leave_enddate = new CgFormFieldEntity();
    jform_leave_enddate.setFieldName("enddate");
    jform_leave_enddate.setTable(jform_leave);
    jform_leave_enddate.setFieldLength(0);
    jform_leave_enddate.setIsKey("N");
    jform_leave_enddate.setIsNull("N");
    jform_leave_enddate.setIsQuery("N");
    jform_leave_enddate.setIsShow("Y");
    jform_leave_enddate.setIsShowList("Y");
    jform_leave_enddate.setShowType("datetime");
    jform_leave_enddate.setLength(0);
    jform_leave_enddate.setType("Date");
    jform_leave_enddate.setOrderNum(5);
    jform_leave_enddate.setPointLength(0);
    jform_leave_enddate.setQueryMode("group");
    jform_leave_enddate.setContent("请假结束时间");
    jform_leave_enddate.setCreateBy("admin");
    jform_leave_enddate.setCreateDate(new Date());
    jform_leave_enddate.setCreateName("管理员");
    jform_leave_enddate.setDictField("");
    jform_leave_enddate.setDictTable("");
    jform_leave_enddate.setMainTable("");
    jform_leave_enddate.setMainField("");
    commonDao.saveOrUpdate(jform_leave_enddate);

    CgFormFieldEntity jform_leave_hol_dept = new CgFormFieldEntity();
    jform_leave_hol_dept.setFieldName("hol_dept");
    jform_leave_hol_dept.setTable(jform_leave);
    jform_leave_hol_dept.setFieldLength(0);
    jform_leave_hol_dept.setIsKey("N");
    jform_leave_hol_dept.setIsNull("N");
    jform_leave_hol_dept.setIsQuery("N");
    jform_leave_hol_dept.setIsShow("Y");
    jform_leave_hol_dept.setIsShowList("Y");
    jform_leave_hol_dept.setShowType("list");
    jform_leave_hol_dept.setLength(32);
    jform_leave_hol_dept.setType("string");
    jform_leave_hol_dept.setOrderNum(7);
    jform_leave_hol_dept.setPointLength(0);
    jform_leave_hol_dept.setQueryMode("single");
    jform_leave_hol_dept.setContent("所属部门");
    jform_leave_hol_dept.setCreateBy("admin");
    jform_leave_hol_dept.setCreateDate(new Date());
    jform_leave_hol_dept.setCreateName("管理员");
    jform_leave_hol_dept.setDictField("id");
    jform_leave_hol_dept.setDictTable("t_s_depart");
    jform_leave_hol_dept.setDictText("departname");
    jform_leave_hol_dept.setMainTable("");
    jform_leave_hol_dept.setMainField("");
    commonDao.saveOrUpdate(jform_leave_hol_dept);

    CgFormFieldEntity jform_leave_hol_reson = new CgFormFieldEntity();
    jform_leave_hol_reson.setFieldName("hol_reson");
    jform_leave_hol_reson.setTable(jform_leave);
    jform_leave_hol_reson.setFieldLength(0);
    jform_leave_hol_reson.setIsKey("N");
    jform_leave_hol_reson.setIsNull("N");
    jform_leave_hol_reson.setIsQuery("N");
    jform_leave_hol_reson.setIsShow("Y");
    jform_leave_hol_reson.setIsShowList("Y");
    jform_leave_hol_reson.setShowType("text");
    jform_leave_hol_reson.setLength(255);
    jform_leave_hol_reson.setType("string");
    jform_leave_hol_reson.setOrderNum(8);
    jform_leave_hol_reson.setPointLength(0);
    jform_leave_hol_reson.setQueryMode("single");
    jform_leave_hol_reson.setContent("请假原因");
    jform_leave_hol_reson.setCreateBy("admin");
    jform_leave_hol_reson.setCreateDate(new Date());
    jform_leave_hol_reson.setCreateName("管理员");
    jform_leave_hol_reson.setDictField("");
    jform_leave_hol_reson.setDictTable("");
    jform_leave_hol_reson.setMainTable("");
    jform_leave_hol_reson.setMainField("");
    commonDao.saveOrUpdate(jform_leave_hol_reson);

    CgFormFieldEntity jform_leave_dep_leader = new CgFormFieldEntity();
    jform_leave_dep_leader.setFieldName("dep_leader");
    jform_leave_dep_leader.setTable(jform_leave);
    jform_leave_dep_leader.setFieldLength(0);
    jform_leave_dep_leader.setIsKey("N");
    jform_leave_dep_leader.setIsNull("N");
    jform_leave_dep_leader.setIsQuery("N");
    jform_leave_dep_leader.setIsShow("Y");
    jform_leave_dep_leader.setIsShowList("Y");
    jform_leave_dep_leader.setShowType("text");
    jform_leave_dep_leader.setLength(20);
    jform_leave_dep_leader.setType("string");
    jform_leave_dep_leader.setOrderNum(9);
    jform_leave_dep_leader.setPointLength(0);
    jform_leave_dep_leader.setQueryMode("single");
    jform_leave_dep_leader.setContent("部门审批人");
    jform_leave_dep_leader.setCreateBy("admin");
    jform_leave_dep_leader.setCreateDate(new Date());
    jform_leave_dep_leader.setCreateName("管理员");
    jform_leave_dep_leader.setDictField("");
    jform_leave_dep_leader.setDictTable("");
    jform_leave_dep_leader.setMainTable("");
    jform_leave_dep_leader.setMainField("");
    commonDao.saveOrUpdate(jform_leave_dep_leader);

    CgFormFieldEntity jform_leave_content = new CgFormFieldEntity();
    jform_leave_content.setFieldName("content");
    jform_leave_content.setTable(jform_leave);
    jform_leave_content.setFieldLength(0);
    jform_leave_content.setIsKey("N");
    jform_leave_content.setIsNull("N");
    jform_leave_content.setIsQuery("N");
    jform_leave_content.setIsShow("Y");
    jform_leave_content.setIsShowList("Y");
    jform_leave_content.setShowType("text");
    jform_leave_content.setLength(255);
    jform_leave_content.setType("string");
    jform_leave_content.setOrderNum(10);
    jform_leave_content.setPointLength(0);
    jform_leave_content.setQueryMode("single");
    jform_leave_content.setContent("部门审批意见");
    jform_leave_content.setCreateBy("admin");
    jform_leave_content.setCreateDate(new Date());
    jform_leave_content.setCreateName("管理员");
    jform_leave_content.setDictField("");
    jform_leave_content.setDictTable("");
    jform_leave_content.setMainTable("");
    jform_leave_content.setMainField("");
    commonDao.saveOrUpdate(jform_leave_content);

    CgFormFieldEntity jform_leave_day_num = new CgFormFieldEntity();
    jform_leave_day_num.setFieldName("day_num");
    jform_leave_day_num.setTable(jform_leave);
    jform_leave_day_num.setFieldLength(120);
    jform_leave_day_num.setIsKey("N");
    jform_leave_day_num.setIsNull("Y");
    jform_leave_day_num.setIsQuery("N");
    jform_leave_day_num.setIsShow("Y");
    jform_leave_day_num.setIsShowList("Y");
    jform_leave_day_num.setShowType("text");
    jform_leave_day_num.setLength(10);
    jform_leave_day_num.setType("int");
    jform_leave_day_num.setOrderNum(6);
    jform_leave_day_num.setPointLength(0);
    jform_leave_day_num.setQueryMode("single");
    jform_leave_day_num.setContent("请假天数");
    jform_leave_day_num.setCreateBy("admin");
    jform_leave_day_num.setCreateDate(new Date());
    jform_leave_day_num.setCreateName("管理员");
    jform_leave_day_num.setDictField("");
    jform_leave_day_num.setDictTable("");
    jform_leave_day_num.setMainTable("");
    jform_leave_day_num.setMainField("");
    commonDao.saveOrUpdate(jform_leave_day_num);
    // 表单[动态报表配置抬头] - 字段清单
//    CgFormHeadEntity jform_cgreport_head = commonDao.findByProperty(
//        CgFormHeadEntity.class, "tableName", "jform_cgreport_head")
//        .get(0);
//    CgFormFieldEntity jform_cgreport_head_id = new CgFormFieldEntity();
//    // begin - 动态报表配置的js增强
//    String cgReportFormId = jform_cgreport_head.getId();
//    CgformEnhanceJsEntity cgReportJs = new CgformEnhanceJsEntity();
//    cgReportJs.setCgJsType("form");
//    cgReportJs
//        .setCgJs(new BigInteger(
//            "242866756E6374696F6E28297B0D0A242822626F647922292E617070656E6428223C6C696E6B20687265663D5C22706C75672D696E2F6C68674469616C6F672F736B696E732F64656661756C742E6373735C222072656C3D5C227374796C6573686565745C222069643D5C226C68676469616C6F676C696E6B5C223E22293B0D0A766172202462746E203D202428223C64697620636C6173733D5C2275695F627574746F6E735C2220207374796C653D5C22646973706C61793A696E6C696E652D626C6F636B3B5C223E3C696E707574207374796C653D5C22706F736974696F6E3A2072656C61746976653B746F703A202D3870783B5C2220636C6173733D5C2275695F73746174655F686967686C696768745C2220747970653D5C22627574746F6E5C222076616C75653D5C2273716CBDE2CEF65C22202020202020202069643D5C2273716C416E616C797A655C22202F3E3C2F6469763E22293B0D0A242822236367725F73716C22292E6166746572282462746E293B0D0A2462746E2E636C69636B2866756E6374696F6E28297B0D0A20242E616A6178287B0D0A202020202075726C3A2263675265706F7274436F6E74726F6C6C65722E646F3F6765744669656C6473222C0D0A20202020646174613A7B73716C3A242822236367725F73716C22292E76616C28297D2C0D0A09747970653A22506F7374222C0D0A2020202064617461547970653A226A736F6E222C0D0A20202020737563636573733A66756E6374696F6E2864617461297B0D0A202020202020696628646174612E7374617475733D3D227375636365737322297B0D0A202020202020202020242822236164645F6A666F726D5F63677265706F72745F6974656D5F7461626C6522292E656D70747928293B0D0A202020202020242E6561636828646174612E64617461732C66756E6374696F6E28696E6465782C65297B0D0A202020202020202076617220247472203D20242822236164645F6A666F726D5F63677265706F72745F6974656D5F7461626C655F74656D706C61746520747222292E636C6F6E6528293B0D0A2020202020202474722E66696E64282274643A6571283129203A7465787422292E76616C2865293B0D0A202020202020202474722E66696E64282274643A6571283229203A7465787422292E76616C28696E646578293B0D0A202020202020202474722E66696E64282274643A6571283329203A7465787422292E76616C2865293B0D0A20202020202020242822236164645F6A666F726D5F63677265706F72745F6974656D5F7461626C6522292E617070656E6428247472293B0D0A2020202020207D293B200D0A20202020726573657454724E756D28226164645F6A666F726D5F63677265706F72745F6974656D5F7461626C6522293B0D0A202020207D656C73657B0D0A0909242E6D657373616765722E616C6572742827B4EDCEF3272C646174612E6461746173293B0D0A097D0D0A20207D0D0A20207D293B0D0A207D293B0D0A7D293B",
//            16).toByteArray());
//    cgReportJs.setFormId(cgReportFormId);
//    commonDao.saveOrUpdate(cgReportJs);
//    // end - 动态报表配置的js增强
//    jform_cgreport_head_id.setFieldName("id");
//    jform_cgreport_head_id.setTable(jform_cgreport_head);
//    jform_cgreport_head_id.setFieldLength(120);
//    jform_cgreport_head_id.setIsKey("Y");
//    jform_cgreport_head_id.setIsNull("N");
//    jform_cgreport_head_id.setIsQuery("N");
//    jform_cgreport_head_id.setIsShow("N");
//    jform_cgreport_head_id.setIsShowList("N");
//    jform_cgreport_head_id.setShowType("checkbox");
//    jform_cgreport_head_id.setLength(36);
//    jform_cgreport_head_id.setType("string");
//    jform_cgreport_head_id.setOrderNum(0);
//    jform_cgreport_head_id.setPointLength(0);
//    jform_cgreport_head_id.setQueryMode("single");
//    jform_cgreport_head_id.setContent("主键");
//    jform_cgreport_head_id.setCreateBy("admin");
//    jform_cgreport_head_id.setCreateDate(new Date());
//    jform_cgreport_head_id.setCreateName("管理员");
//    jform_cgreport_head_id.setDictField("");
//    jform_cgreport_head_id.setDictTable("");
//    jform_cgreport_head_id.setMainTable("");
//    jform_cgreport_head_id.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_head_id);
//
//    CgFormFieldEntity jform_cgreport_head_code = new CgFormFieldEntity();
//    jform_cgreport_head_code.setFieldName("code");
//    jform_cgreport_head_code.setTable(jform_cgreport_head);
//    jform_cgreport_head_code.setFieldLength(120);
//    jform_cgreport_head_code.setIsKey("N");
//    jform_cgreport_head_code.setIsNull("N");
//    jform_cgreport_head_code.setIsQuery("Y");
//    jform_cgreport_head_code.setIsShow("Y");
//    jform_cgreport_head_code.setIsShowList("Y");
//    jform_cgreport_head_code.setShowType("text");
//    jform_cgreport_head_code.setLength(36);
//    jform_cgreport_head_code.setType("string");
//    jform_cgreport_head_code.setOrderNum(1);
//    jform_cgreport_head_code.setPointLength(0);
//    jform_cgreport_head_code.setQueryMode("single");
//    jform_cgreport_head_code.setContent("编码");
//    jform_cgreport_head_code.setCreateBy("admin");
//    jform_cgreport_head_code.setCreateDate(new Date());
//    jform_cgreport_head_code.setCreateName("管理员");
//    jform_cgreport_head_code.setDictField("");
//    jform_cgreport_head_code.setDictTable("");
//    jform_cgreport_head_code.setMainTable("");
//    jform_cgreport_head_code.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_head_code);
//
//    CgFormFieldEntity jform_cgreport_head_name = new CgFormFieldEntity();
//    jform_cgreport_head_name.setFieldName("name");
//    jform_cgreport_head_name.setTable(jform_cgreport_head);
//    jform_cgreport_head_name.setFieldLength(120);
//    jform_cgreport_head_name.setIsKey("N");
//    jform_cgreport_head_name.setIsNull("N");
//    jform_cgreport_head_name.setIsQuery("Y");
//    jform_cgreport_head_name.setIsShow("Y");
//    jform_cgreport_head_name.setIsShowList("Y");
//    jform_cgreport_head_name.setShowType("text");
//    jform_cgreport_head_name.setLength(100);
//    jform_cgreport_head_name.setType("string");
//    jform_cgreport_head_name.setOrderNum(2);
//    jform_cgreport_head_name.setPointLength(0);
//    jform_cgreport_head_name.setQueryMode("single");
//    jform_cgreport_head_name.setContent("名称");
//    jform_cgreport_head_name.setCreateBy("admin");
//    jform_cgreport_head_name.setCreateDate(new Date());
//    jform_cgreport_head_name.setCreateName("管理员");
//    jform_cgreport_head_name.setDictField("");
//    jform_cgreport_head_name.setDictTable("");
//    jform_cgreport_head_name.setMainTable("");
//    jform_cgreport_head_name.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_head_name);
//
//    CgFormFieldEntity jform_cgreport_head_cgr_sql = new CgFormFieldEntity();
//    jform_cgreport_head_cgr_sql.setFieldName("cgr_sql");
//    jform_cgreport_head_cgr_sql.setTable(jform_cgreport_head);
//    jform_cgreport_head_cgr_sql.setFieldLength(120);
//    jform_cgreport_head_cgr_sql.setIsKey("N");
//    jform_cgreport_head_cgr_sql.setIsNull("N");
//    jform_cgreport_head_cgr_sql.setIsQuery("Y");
//    jform_cgreport_head_cgr_sql.setIsShow("Y");
//    jform_cgreport_head_cgr_sql.setIsShowList("Y");
//    jform_cgreport_head_cgr_sql.setShowType("textarea");
//    jform_cgreport_head_cgr_sql.setLength(2000);
//    jform_cgreport_head_cgr_sql.setType("string");
//    jform_cgreport_head_cgr_sql.setOrderNum(3);
//    jform_cgreport_head_cgr_sql.setPointLength(0);
//    jform_cgreport_head_cgr_sql.setQueryMode("single");
//    jform_cgreport_head_cgr_sql.setContent("查询数据SQL");
//    jform_cgreport_head_cgr_sql.setCreateBy("admin");
//    jform_cgreport_head_cgr_sql.setCreateDate(new Date());
//    jform_cgreport_head_cgr_sql.setCreateName("管理员");
//    jform_cgreport_head_cgr_sql.setDictField("");
//    jform_cgreport_head_cgr_sql.setDictTable("");
//    jform_cgreport_head_cgr_sql.setMainTable("");
//    jform_cgreport_head_cgr_sql.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_head_cgr_sql);
//
//    CgFormFieldEntity jform_cgreport_head_content = new CgFormFieldEntity();
//    jform_cgreport_head_content.setFieldName("content");
//    jform_cgreport_head_content.setTable(jform_cgreport_head);
//    jform_cgreport_head_content.setFieldLength(120);
//    jform_cgreport_head_content.setIsKey("N");
//    jform_cgreport_head_content.setIsNull("N");
//    jform_cgreport_head_content.setIsQuery("Y");
//    jform_cgreport_head_content.setIsShow("Y");
//    jform_cgreport_head_content.setIsShowList("Y");
//    jform_cgreport_head_content.setShowType("textarea");
//    jform_cgreport_head_content.setLength(1000);
//    jform_cgreport_head_content.setType("string");
//    jform_cgreport_head_content.setOrderNum(4);
//    jform_cgreport_head_content.setPointLength(0);
//    jform_cgreport_head_content.setQueryMode("single");
//    jform_cgreport_head_content.setContent("描述");
//    jform_cgreport_head_content.setCreateBy("admin");
//    jform_cgreport_head_content.setCreateDate(new Date());
//    jform_cgreport_head_content.setCreateName("管理员");
//    jform_cgreport_head_content.setDictField("");
//    jform_cgreport_head_content.setDictTable("");
//    jform_cgreport_head_content.setMainTable("");
//    jform_cgreport_head_content.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_head_content);
//
//    // 表单[动态报表配置明细] - 字段清单
//    CgFormHeadEntity jform_cgreport_item = commonDao.findByProperty(
//        CgFormHeadEntity.class, "tableName", "jform_cgreport_item")
//        .get(0);
//    CgFormFieldEntity jform_cgreport_item_id = new CgFormFieldEntity();
//    jform_cgreport_item_id.setFieldName("id");
//    jform_cgreport_item_id.setTable(jform_cgreport_item);
//    jform_cgreport_item_id.setFieldLength(120);
//    jform_cgreport_item_id.setIsKey("Y");
//    jform_cgreport_item_id.setIsNull("N");
//    jform_cgreport_item_id.setIsQuery("N");
//    jform_cgreport_item_id.setIsShow("N");
//    jform_cgreport_item_id.setIsShowList("N");
//    jform_cgreport_item_id.setShowType("checkbox");
//    jform_cgreport_item_id.setLength(36);
//    jform_cgreport_item_id.setType("string");
//    jform_cgreport_item_id.setOrderNum(0);
//    jform_cgreport_item_id.setPointLength(0);
//    jform_cgreport_item_id.setQueryMode("single");
//    jform_cgreport_item_id.setContent("主键");
//    jform_cgreport_item_id.setCreateBy("admin");
//    jform_cgreport_item_id.setCreateDate(new Date());
//    jform_cgreport_item_id.setCreateName("管理员");
//    jform_cgreport_item_id.setDictField("");
//    jform_cgreport_item_id.setDictTable("");
//    jform_cgreport_item_id.setMainTable("");
//    jform_cgreport_item_id.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_item_id);
//
//    CgFormFieldEntity jform_cgreport_item_field_name = new CgFormFieldEntity();
//    jform_cgreport_item_field_name.setFieldName("field_name");
//    jform_cgreport_item_field_name.setTable(jform_cgreport_item);
//    jform_cgreport_item_field_name.setFieldLength(120);
//    jform_cgreport_item_field_name.setIsKey("N");
//    jform_cgreport_item_field_name.setIsNull("Y");
//    jform_cgreport_item_field_name.setIsQuery("N");
//    jform_cgreport_item_field_name.setIsShow("Y");
//    jform_cgreport_item_field_name.setIsShowList("Y");
//    jform_cgreport_item_field_name.setShowType("text");
//    jform_cgreport_item_field_name.setLength(36);
//    jform_cgreport_item_field_name.setType("string");
//    jform_cgreport_item_field_name.setOrderNum(1);
//    jform_cgreport_item_field_name.setPointLength(0);
//    jform_cgreport_item_field_name.setQueryMode("single");
//    jform_cgreport_item_field_name.setContent("字段名");
//    jform_cgreport_item_field_name.setCreateBy("admin");
//    jform_cgreport_item_field_name.setCreateDate(new Date());
//    jform_cgreport_item_field_name.setCreateName("管理员");
//    jform_cgreport_item_field_name.setDictField("");
//    jform_cgreport_item_field_name.setDictTable("");
//    jform_cgreport_item_field_name.setMainTable("");
//    jform_cgreport_item_field_name.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_item_field_name);
//
//    CgFormFieldEntity jform_cgreport_item_order_num = new CgFormFieldEntity();
//    jform_cgreport_item_order_num.setFieldName("order_num");
//    jform_cgreport_item_order_num.setTable(jform_cgreport_item);
//    jform_cgreport_item_order_num.setFieldLength(120);
//    jform_cgreport_item_order_num.setIsKey("N");
//    jform_cgreport_item_order_num.setIsNull("Y");
//    jform_cgreport_item_order_num.setIsQuery("N");
//    jform_cgreport_item_order_num.setIsShow("Y");
//    jform_cgreport_item_order_num.setIsShowList("Y");
//    jform_cgreport_item_order_num.setShowType("text");
//    jform_cgreport_item_order_num.setLength(10);
//    jform_cgreport_item_order_num.setType("int");
//    jform_cgreport_item_order_num.setOrderNum(2);
//    jform_cgreport_item_order_num.setPointLength(0);
//    jform_cgreport_item_order_num.setQueryMode("single");
//    jform_cgreport_item_order_num.setContent("字段序号");
//    jform_cgreport_item_order_num.setCreateBy("admin");
//    jform_cgreport_item_order_num.setCreateDate(new Date());
//    jform_cgreport_item_order_num.setCreateName("管理员");
//    jform_cgreport_item_order_num.setDictField("");
//    jform_cgreport_item_order_num.setDictTable("");
//    jform_cgreport_item_order_num.setMainTable("");
//    jform_cgreport_item_order_num.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_item_order_num);
//
//    CgFormFieldEntity jform_cgreport_item_s_mode = new CgFormFieldEntity();
//    jform_cgreport_item_s_mode.setFieldName("s_mode");
//    jform_cgreport_item_s_mode.setTable(jform_cgreport_item);
//    jform_cgreport_item_s_mode.setFieldLength(120);
//    jform_cgreport_item_s_mode.setIsKey("N");
//    jform_cgreport_item_s_mode.setIsNull("Y");
//    jform_cgreport_item_s_mode.setIsQuery("N");
//    jform_cgreport_item_s_mode.setIsShow("Y");
//    jform_cgreport_item_s_mode.setIsShowList("Y");
//    jform_cgreport_item_s_mode.setShowType("list");
//    jform_cgreport_item_s_mode.setLength(10);
//    jform_cgreport_item_s_mode.setType("string");
//    jform_cgreport_item_s_mode.setOrderNum(5);
//    jform_cgreport_item_s_mode.setPointLength(0);
//    jform_cgreport_item_s_mode.setQueryMode("single");
//    jform_cgreport_item_s_mode.setContent("查询模式");
//    jform_cgreport_item_s_mode.setCreateBy("admin");
//    jform_cgreport_item_s_mode.setCreateDate(new Date());
//    jform_cgreport_item_s_mode.setCreateName("管理员");
//    jform_cgreport_item_s_mode.setDictField("searchmode");
//    jform_cgreport_item_s_mode.setDictTable("");
//    jform_cgreport_item_s_mode.setMainTable("");
//    jform_cgreport_item_s_mode.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_item_s_mode);
//
//    CgFormFieldEntity jform_cgreport_item_replace_va = new CgFormFieldEntity();
//    jform_cgreport_item_replace_va.setFieldName("replace_va");
//    jform_cgreport_item_replace_va.setTable(jform_cgreport_item);
//    jform_cgreport_item_replace_va.setFieldLength(120);
//    jform_cgreport_item_replace_va.setIsKey("N");
//    jform_cgreport_item_replace_va.setIsNull("Y");
//    jform_cgreport_item_replace_va.setIsQuery("N");
//    jform_cgreport_item_replace_va.setIsShow("Y");
//    jform_cgreport_item_replace_va.setIsShowList("Y");
//    jform_cgreport_item_replace_va.setShowType("text");
//    jform_cgreport_item_replace_va.setLength(36);
//    jform_cgreport_item_replace_va.setType("string");
//    jform_cgreport_item_replace_va.setOrderNum(6);
//    jform_cgreport_item_replace_va.setPointLength(0);
//    jform_cgreport_item_replace_va.setQueryMode("single");
//    jform_cgreport_item_replace_va.setContent("取值表达式");
//    jform_cgreport_item_replace_va.setCreateBy("admin");
//    jform_cgreport_item_replace_va.setCreateDate(new Date());
//    jform_cgreport_item_replace_va.setCreateName("管理员");
//    jform_cgreport_item_replace_va.setDictField("");
//    jform_cgreport_item_replace_va.setDictTable("");
//    jform_cgreport_item_replace_va.setMainTable("");
//    jform_cgreport_item_replace_va.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_item_replace_va);
//
//    CgFormFieldEntity jform_cgreport_item_dict_code = new CgFormFieldEntity();
//    jform_cgreport_item_dict_code.setFieldName("dict_code");
//    jform_cgreport_item_dict_code.setTable(jform_cgreport_item);
//    jform_cgreport_item_dict_code.setFieldLength(120);
//    jform_cgreport_item_dict_code.setIsKey("N");
//    jform_cgreport_item_dict_code.setIsNull("Y");
//    jform_cgreport_item_dict_code.setIsQuery("N");
//    jform_cgreport_item_dict_code.setIsShow("Y");
//    jform_cgreport_item_dict_code.setIsShowList("Y");
//    jform_cgreport_item_dict_code.setShowType("text");
//    jform_cgreport_item_dict_code.setLength(36);
//    jform_cgreport_item_dict_code.setType("string");
//    jform_cgreport_item_dict_code.setOrderNum(7);
//    jform_cgreport_item_dict_code.setPointLength(0);
//    jform_cgreport_item_dict_code.setQueryMode("single");
//    jform_cgreport_item_dict_code.setContent("字典Code");
//    jform_cgreport_item_dict_code.setCreateBy("admin");
//    jform_cgreport_item_dict_code.setCreateDate(new Date());
//    jform_cgreport_item_dict_code.setCreateName("管理员");
//    jform_cgreport_item_dict_code.setDictField("");
//    jform_cgreport_item_dict_code.setDictTable("");
//    jform_cgreport_item_dict_code.setMainTable("");
//    jform_cgreport_item_dict_code.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_item_dict_code);
//
//    CgFormFieldEntity jform_cgreport_item_s_flag = new CgFormFieldEntity();
//    jform_cgreport_item_s_flag.setFieldName("s_flag");
//    jform_cgreport_item_s_flag.setTable(jform_cgreport_item);
//    jform_cgreport_item_s_flag.setFieldLength(120);
//    jform_cgreport_item_s_flag.setIsKey("N");
//    jform_cgreport_item_s_flag.setIsNull("Y");
//    jform_cgreport_item_s_flag.setIsQuery("N");
//    jform_cgreport_item_s_flag.setIsShow("Y");
//    jform_cgreport_item_s_flag.setIsShowList("Y");
//    jform_cgreport_item_s_flag.setShowType("list");
//    jform_cgreport_item_s_flag.setLength(2);
//    jform_cgreport_item_s_flag.setType("string");
//    jform_cgreport_item_s_flag.setOrderNum(8);
//    jform_cgreport_item_s_flag.setPointLength(0);
//    jform_cgreport_item_s_flag.setQueryMode("single");
//    jform_cgreport_item_s_flag.setContent("是否查询");
//    jform_cgreport_item_s_flag.setCreateBy("admin");
//    jform_cgreport_item_s_flag.setCreateDate(new Date());
//    jform_cgreport_item_s_flag.setCreateName("管理员");
//    jform_cgreport_item_s_flag.setDictField("yesorno");
//    jform_cgreport_item_s_flag.setDictTable("");
//    jform_cgreport_item_s_flag.setMainTable("");
//    jform_cgreport_item_s_flag.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_item_s_flag);
//
//    CgFormFieldEntity jform_cgreport_item_cgrhead_id = new CgFormFieldEntity();
//    jform_cgreport_item_cgrhead_id.setFieldName("cgrhead_id");
//    jform_cgreport_item_cgrhead_id.setTable(jform_cgreport_item);
//    jform_cgreport_item_cgrhead_id.setFieldLength(120);
//    jform_cgreport_item_cgrhead_id.setIsKey("N");
//    jform_cgreport_item_cgrhead_id.setIsNull("Y");
//    jform_cgreport_item_cgrhead_id.setIsQuery("N");
//    jform_cgreport_item_cgrhead_id.setIsShow("N");
//    jform_cgreport_item_cgrhead_id.setIsShowList("N");
//    jform_cgreport_item_cgrhead_id.setShowType("text");
//    jform_cgreport_item_cgrhead_id.setLength(36);
//    jform_cgreport_item_cgrhead_id.setType("string");
//    jform_cgreport_item_cgrhead_id.setOrderNum(9);
//    jform_cgreport_item_cgrhead_id.setPointLength(0);
//    jform_cgreport_item_cgrhead_id.setQueryMode("single");
//    jform_cgreport_item_cgrhead_id.setContent("外键");
//    jform_cgreport_item_cgrhead_id.setCreateBy("admin");
//    jform_cgreport_item_cgrhead_id.setCreateDate(new Date());
//    jform_cgreport_item_cgrhead_id.setCreateName("管理员");
//    jform_cgreport_item_cgrhead_id.setDictField("");
//    jform_cgreport_item_cgrhead_id.setDictTable("");
//    jform_cgreport_item_cgrhead_id.setMainTable("jform_cgreport_head");
//    jform_cgreport_item_cgrhead_id.setMainField("id");
//    commonDao.saveOrUpdate(jform_cgreport_item_cgrhead_id);
//
//    CgFormFieldEntity jform_cgreport_item_field_txt = new CgFormFieldEntity();
//    jform_cgreport_item_field_txt.setFieldName("field_txt");
//    jform_cgreport_item_field_txt.setTable(jform_cgreport_item);
//    jform_cgreport_item_field_txt.setFieldLength(120);
//    jform_cgreport_item_field_txt.setIsKey("N");
//    jform_cgreport_item_field_txt.setIsNull("Y");
//    jform_cgreport_item_field_txt.setIsQuery("N");
//    jform_cgreport_item_field_txt.setIsShow("Y");
//    jform_cgreport_item_field_txt.setIsShowList("Y");
//    jform_cgreport_item_field_txt.setShowType("text");
//    jform_cgreport_item_field_txt.setLength(1000);
//    jform_cgreport_item_field_txt.setType("string");
//    jform_cgreport_item_field_txt.setOrderNum(3);
//    jform_cgreport_item_field_txt.setPointLength(0);
//    jform_cgreport_item_field_txt.setQueryMode("single");
//    jform_cgreport_item_field_txt.setContent("字段文本");
//    jform_cgreport_item_field_txt.setCreateBy("admin");
//    jform_cgreport_item_field_txt.setCreateDate(new Date());
//    jform_cgreport_item_field_txt.setCreateName("管理员");
//    jform_cgreport_item_field_txt.setDictField("");
//    jform_cgreport_item_field_txt.setDictTable("");
//    jform_cgreport_item_field_txt.setMainTable("");
//    jform_cgreport_item_field_txt.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_item_field_txt);
//
//    CgFormFieldEntity jform_cgreport_item_field_type = new CgFormFieldEntity();
//    jform_cgreport_item_field_type.setFieldName("field_type");
//    jform_cgreport_item_field_type.setTable(jform_cgreport_item);
//    jform_cgreport_item_field_type.setFieldLength(120);
//    jform_cgreport_item_field_type.setIsKey("N");
//    jform_cgreport_item_field_type.setIsNull("Y");
//    jform_cgreport_item_field_type.setIsQuery("N");
//    jform_cgreport_item_field_type.setIsShow("Y");
//    jform_cgreport_item_field_type.setIsShowList("Y");
//    jform_cgreport_item_field_type.setShowType("list");
//    jform_cgreport_item_field_type.setLength(10);
//    jform_cgreport_item_field_type.setType("string");
//    jform_cgreport_item_field_type.setOrderNum(4);
//    jform_cgreport_item_field_type.setPointLength(0);
//    jform_cgreport_item_field_type.setQueryMode("single");
//    jform_cgreport_item_field_type.setContent("字段类型");
//    jform_cgreport_item_field_type.setCreateBy("admin");
//    jform_cgreport_item_field_type.setCreateDate(new Date());
//    jform_cgreport_item_field_type.setCreateName("管理员");
//    jform_cgreport_item_field_type.setDictField("fieldtype");
//    jform_cgreport_item_field_type.setDictTable("");
//    jform_cgreport_item_field_type.setMainTable("");
//    jform_cgreport_item_field_type.setMainField("");
//    commonDao.saveOrUpdate(jform_cgreport_item_field_type);

    // 表单[订单客户信息] - 字段清单
    CgFormHeadEntity jform_order_customer = commonDao.findByProperty(
        CgFormHeadEntity.class, "tableName", "jform_order_customer")
        .get(0);
    CgFormFieldEntity jform_order_customer_id = new CgFormFieldEntity();
    jform_order_customer_id.setFieldName("id");
    jform_order_customer_id.setTable(jform_order_customer);
    jform_order_customer_id.setFieldLength(0);
    jform_order_customer_id.setIsKey("Y");
    jform_order_customer_id.setIsNull("N");
    jform_order_customer_id.setIsQuery("N");
    jform_order_customer_id.setIsShow("N");
    jform_order_customer_id.setIsShowList("N");
    jform_order_customer_id.setShowType("text");
    jform_order_customer_id.setLength(36);
    jform_order_customer_id.setType("string");
    jform_order_customer_id.setOrderNum(0);
    jform_order_customer_id.setPointLength(0);
    jform_order_customer_id.setQueryMode("single");
    jform_order_customer_id.setContent("主键");
    jform_order_customer_id.setCreateBy("admin");
    jform_order_customer_id.setCreateDate(new Date());
    jform_order_customer_id.setCreateName("管理员");
    jform_order_customer_id.setDictField("");
    jform_order_customer_id.setDictTable("");
    jform_order_customer_id.setMainTable("");
    jform_order_customer_id.setMainField("");
    commonDao.saveOrUpdate(jform_order_customer_id);

    CgFormFieldEntity jform_order_customer_name = new CgFormFieldEntity();
    jform_order_customer_name.setFieldName("name");
    jform_order_customer_name.setTable(jform_order_customer);
    jform_order_customer_name.setFieldLength(0);
    jform_order_customer_name.setIsKey("N");
    jform_order_customer_name.setIsNull("Y");
    jform_order_customer_name.setIsQuery("Y");
    jform_order_customer_name.setIsShow("Y");
    jform_order_customer_name.setIsShowList("Y");
    jform_order_customer_name.setShowType("text");
    jform_order_customer_name.setLength(32);
    jform_order_customer_name.setType("string");
    jform_order_customer_name.setOrderNum(1);
    jform_order_customer_name.setPointLength(0);
    jform_order_customer_name.setQueryMode("single");
    jform_order_customer_name.setContent("客户名");
    jform_order_customer_name.setCreateBy("admin");
    jform_order_customer_name.setCreateDate(new Date());
    jform_order_customer_name.setCreateName("管理员");
    jform_order_customer_name.setDictField("");
    jform_order_customer_name.setDictTable("");
    jform_order_customer_name.setMainTable("");
    jform_order_customer_name.setMainField("");
    commonDao.saveOrUpdate(jform_order_customer_name);

    CgFormFieldEntity jform_order_customer_money = new CgFormFieldEntity();
    jform_order_customer_money.setFieldName("money");
    jform_order_customer_money.setTable(jform_order_customer);
    jform_order_customer_money.setFieldLength(0);
    jform_order_customer_money.setIsKey("N");
    jform_order_customer_money.setIsNull("Y");
    jform_order_customer_money.setIsQuery("Y");
    jform_order_customer_money.setIsShow("Y");
    jform_order_customer_money.setIsShowList("Y");
    jform_order_customer_money.setShowType("text");
    jform_order_customer_money.setLength(10);
    jform_order_customer_money.setType("double");
    jform_order_customer_money.setOrderNum(2);
    jform_order_customer_money.setPointLength(2);
    jform_order_customer_money.setQueryMode("group");
    jform_order_customer_money.setContent("单价");
    jform_order_customer_money.setCreateBy("admin");
    jform_order_customer_money.setCreateDate(new Date());
    jform_order_customer_money.setCreateName("管理员");
    jform_order_customer_money.setDictField("");
    jform_order_customer_money.setDictTable("");
    jform_order_customer_money.setMainTable("");
    jform_order_customer_money.setMainField("");
    commonDao.saveOrUpdate(jform_order_customer_money);

    CgFormFieldEntity jform_order_customer_fk_id = new CgFormFieldEntity();
    jform_order_customer_fk_id.setFieldName("fk_id");
    jform_order_customer_fk_id.setTable(jform_order_customer);
    jform_order_customer_fk_id.setFieldLength(120);
    jform_order_customer_fk_id.setIsKey("N");
    jform_order_customer_fk_id.setIsNull("N");
    jform_order_customer_fk_id.setIsQuery("Y");
    jform_order_customer_fk_id.setIsShow("N");
    jform_order_customer_fk_id.setIsShowList("N");
    jform_order_customer_fk_id.setShowType("text");
    jform_order_customer_fk_id.setLength(36);
    jform_order_customer_fk_id.setType("string");
    jform_order_customer_fk_id.setOrderNum(5);
    jform_order_customer_fk_id.setPointLength(0);
    jform_order_customer_fk_id.setQueryMode("single");
    jform_order_customer_fk_id.setContent("外键");
    jform_order_customer_fk_id.setCreateBy("admin");
    jform_order_customer_fk_id.setCreateDate(new Date());
    jform_order_customer_fk_id.setCreateName("管理员");
    jform_order_customer_fk_id.setDictField("");
    jform_order_customer_fk_id.setDictTable("");
    jform_order_customer_fk_id.setMainTable("jform_order_main");
    jform_order_customer_fk_id.setMainField("id");
    commonDao.saveOrUpdate(jform_order_customer_fk_id);

    CgFormFieldEntity jform_order_customer_telphone = new CgFormFieldEntity();
    jform_order_customer_telphone.setFieldName("telphone");
    jform_order_customer_telphone.setTable(jform_order_customer);
    jform_order_customer_telphone.setFieldLength(120);
    jform_order_customer_telphone.setIsKey("N");
    jform_order_customer_telphone.setIsNull("Y");
    jform_order_customer_telphone.setIsQuery("Y");
    jform_order_customer_telphone.setIsShow("Y");
    jform_order_customer_telphone.setIsShowList("Y");
    jform_order_customer_telphone.setShowType("text");
    jform_order_customer_telphone.setLength(32);
    jform_order_customer_telphone.setType("string");
    jform_order_customer_telphone.setOrderNum(4);
    jform_order_customer_telphone.setPointLength(0);
    jform_order_customer_telphone.setQueryMode("single");
    jform_order_customer_telphone.setContent("电话");
    jform_order_customer_telphone.setCreateBy("admin");
    jform_order_customer_telphone.setCreateDate(new Date());
    jform_order_customer_telphone.setCreateName("管理员");
    jform_order_customer_telphone.setDictField("");
    jform_order_customer_telphone.setDictTable("");
    jform_order_customer_telphone.setMainTable("");
    jform_order_customer_telphone.setMainField("");
    commonDao.saveOrUpdate(jform_order_customer_telphone);

    CgFormFieldEntity jform_order_customer_sex = new CgFormFieldEntity();
    jform_order_customer_sex.setFieldName("sex");
    jform_order_customer_sex.setTable(jform_order_customer);
    jform_order_customer_sex.setFieldLength(120);
    jform_order_customer_sex.setIsKey("N");
    jform_order_customer_sex.setIsNull("Y");
    jform_order_customer_sex.setIsQuery("Y");
    jform_order_customer_sex.setIsShow("Y");
    jform_order_customer_sex.setIsShowList("Y");
    jform_order_customer_sex.setShowType("radio");
    jform_order_customer_sex.setLength(4);
    jform_order_customer_sex.setType("string");
    jform_order_customer_sex.setOrderNum(3);
    jform_order_customer_sex.setPointLength(0);
    jform_order_customer_sex.setQueryMode("single");
    jform_order_customer_sex.setContent("性别");
    jform_order_customer_sex.setCreateBy("admin");
    jform_order_customer_sex.setCreateDate(new Date());
    jform_order_customer_sex.setCreateName("管理员");
    jform_order_customer_sex.setDictField("sex");
    jform_order_customer_sex.setDictTable("");
    jform_order_customer_sex.setMainTable("");
    jform_order_customer_sex.setMainField("");
    commonDao.saveOrUpdate(jform_order_customer_sex);

    // 表单[订单机票信息] - 字段清单
    CgFormHeadEntity jform_order_ticket = commonDao.findByProperty(
        CgFormHeadEntity.class, "tableName", "jform_order_ticket").get(
        0);
    CgFormFieldEntity jform_order_ticket_id = new CgFormFieldEntity();
    jform_order_ticket_id.setFieldName("id");
    jform_order_ticket_id.setTable(jform_order_ticket);
    jform_order_ticket_id.setFieldLength(120);
    jform_order_ticket_id.setIsKey("Y");
    jform_order_ticket_id.setIsNull("N");
    jform_order_ticket_id.setIsQuery("N");
    jform_order_ticket_id.setIsShow("N");
    jform_order_ticket_id.setIsShowList("N");
    jform_order_ticket_id.setShowType("checkbox");
    jform_order_ticket_id.setLength(36);
    jform_order_ticket_id.setType("string");
    jform_order_ticket_id.setOrderNum(0);
    jform_order_ticket_id.setPointLength(0);
    jform_order_ticket_id.setQueryMode("single");
    jform_order_ticket_id.setContent("主键");
    jform_order_ticket_id.setCreateBy("admin");
    jform_order_ticket_id.setCreateDate(new Date());
    jform_order_ticket_id.setCreateName("管理员");
    jform_order_ticket_id.setDictField("");
    jform_order_ticket_id.setDictTable("");
    jform_order_ticket_id.setMainTable("");
    jform_order_ticket_id.setMainField("");
    commonDao.saveOrUpdate(jform_order_ticket_id);

    CgFormFieldEntity jform_order_ticket_ticket_code = new CgFormFieldEntity();
    jform_order_ticket_ticket_code.setFieldName("ticket_code");
    jform_order_ticket_ticket_code.setTable(jform_order_ticket);
    jform_order_ticket_ticket_code.setFieldLength(120);
    jform_order_ticket_ticket_code.setIsKey("N");
    jform_order_ticket_ticket_code.setIsNull("N");
    jform_order_ticket_ticket_code.setIsQuery("Y");
    jform_order_ticket_ticket_code.setIsShow("Y");
    jform_order_ticket_ticket_code.setIsShowList("Y");
    jform_order_ticket_ticket_code.setShowType("text");
    jform_order_ticket_ticket_code.setLength(100);
    jform_order_ticket_ticket_code.setType("string");
    jform_order_ticket_ticket_code.setOrderNum(1);
    jform_order_ticket_ticket_code.setPointLength(0);
    jform_order_ticket_ticket_code.setQueryMode("single");
    jform_order_ticket_ticket_code.setContent("航班号");
    jform_order_ticket_ticket_code.setCreateBy("admin");
    jform_order_ticket_ticket_code.setCreateDate(new Date());
    jform_order_ticket_ticket_code.setCreateName("管理员");
    jform_order_ticket_ticket_code.setDictField("");
    jform_order_ticket_ticket_code.setDictTable("");
    jform_order_ticket_ticket_code.setMainTable("");
    jform_order_ticket_ticket_code.setMainField("");
    commonDao.saveOrUpdate(jform_order_ticket_ticket_code);

    CgFormFieldEntity jform_order_ticket_tickect_date = new CgFormFieldEntity();
    jform_order_ticket_tickect_date.setFieldName("tickect_date");
    jform_order_ticket_tickect_date.setTable(jform_order_ticket);
    jform_order_ticket_tickect_date.setFieldLength(120);
    jform_order_ticket_tickect_date.setIsKey("N");
    jform_order_ticket_tickect_date.setIsNull("N");
    jform_order_ticket_tickect_date.setIsQuery("Y");
    jform_order_ticket_tickect_date.setIsShow("Y");
    jform_order_ticket_tickect_date.setIsShowList("Y");
    jform_order_ticket_tickect_date.setShowType("datetime");
    jform_order_ticket_tickect_date.setLength(10);
    jform_order_ticket_tickect_date.setType("Date");
    jform_order_ticket_tickect_date.setOrderNum(2);
    jform_order_ticket_tickect_date.setPointLength(0);
    jform_order_ticket_tickect_date.setQueryMode("single");
    jform_order_ticket_tickect_date.setContent("航班时间");
    jform_order_ticket_tickect_date.setCreateBy("admin");
    jform_order_ticket_tickect_date.setCreateDate(new Date());
    jform_order_ticket_tickect_date.setCreateName("管理员");
    jform_order_ticket_tickect_date.setDictField("");
    jform_order_ticket_tickect_date.setDictTable("");
    jform_order_ticket_tickect_date.setMainTable("");
    jform_order_ticket_tickect_date.setMainField("");
    commonDao.saveOrUpdate(jform_order_ticket_tickect_date);

    CgFormFieldEntity jform_order_ticket_fck_id = new CgFormFieldEntity();
    jform_order_ticket_fck_id.setFieldName("fck_id");
    jform_order_ticket_fck_id.setTable(jform_order_ticket);
    jform_order_ticket_fck_id.setFieldLength(120);
    jform_order_ticket_fck_id.setIsKey("N");
    jform_order_ticket_fck_id.setIsNull("N");
    jform_order_ticket_fck_id.setIsQuery("N");
    jform_order_ticket_fck_id.setIsShow("N");
    jform_order_ticket_fck_id.setIsShowList("N");
    jform_order_ticket_fck_id.setShowType("text");
    jform_order_ticket_fck_id.setLength(36);
    jform_order_ticket_fck_id.setType("string");
    jform_order_ticket_fck_id.setOrderNum(3);
    jform_order_ticket_fck_id.setPointLength(0);
    jform_order_ticket_fck_id.setQueryMode("single");
    jform_order_ticket_fck_id.setContent("外键");
    jform_order_ticket_fck_id.setCreateBy("admin");
    jform_order_ticket_fck_id.setCreateDate(new Date());
    jform_order_ticket_fck_id.setCreateName("管理员");
    jform_order_ticket_fck_id.setDictField("");
    jform_order_ticket_fck_id.setDictTable("");
    jform_order_ticket_fck_id.setMainTable("jform_order_main");
    jform_order_ticket_fck_id.setMainField("id");
    commonDao.saveOrUpdate(jform_order_ticket_fck_id);

    // 表单[价格认证机构统计表] - 字段清单
    CgFormHeadEntity jform_price1 = commonDao.findByProperty(
        CgFormHeadEntity.class, "tableName", "jform_price1").get(0);
    CgFormFieldEntity jform_price1_id = new CgFormFieldEntity();
    jform_price1_id.setFieldName("id");
    jform_price1_id.setTable(jform_price1);
    jform_price1_id.setFieldLength(0);
View Full Code Here

  /**
   * @Description 修复智能表单Head数据库
   * @author tanghan 2013-7-28
   */
  private void repairCgFormHead() {
    CgFormHeadEntity order_main = new CgFormHeadEntity();
    order_main.setTableName("jform_order_main");
    order_main.setIsTree("N");
    order_main.setIsPagination("Y");
    order_main.setIsCheckbox("N");
    order_main.setQuerymode("group");
    order_main.setIsDbSynch("N");
    order_main.setContent("订单主信息");
    order_main.setCreateBy("admin");
    order_main.setCreateDate(new Date());
    order_main.setJformPkType("UUID");
    // order_main.setJsPlugIn("0");
    // order_main.setSqlPlugIn("0");
    order_main.setCreateName("管理员");
    order_main.setJformVersion("57");
    order_main.setJformType(2);
    order_main.setRelationType(0);
    order_main.setSubTableStr("jform_order_ticket,jform_order_customer");
    commonDao.saveOrUpdate(order_main);

    CgFormHeadEntity leave = new CgFormHeadEntity();
    leave.setTableName("jform_leave");
    leave.setIsTree("N");
    leave.setIsPagination("Y");
    leave.setIsCheckbox("N");
    leave.setJformPkType("UUID");
    leave.setQuerymode("group");
    leave.setIsDbSynch("N");
    leave.setContent("请假单");
    leave.setCreateBy("admin");
    leave.setCreateDate(new Date());
    // leave.setJsPlugIn("0");
    // leave.setSqlPlugIn("0");
    leave.setCreateName("管理员");
    leave.setJformVersion("51");
    leave.setJformType(1);
    leave.setRelationType(0);
    commonDao.saveOrUpdate(leave);
//    CgFormHeadEntity cgreport_head = new CgFormHeadEntity();
//    cgreport_head.setTableName("jform_cgreport_head");
//    cgreport_head.setIsTree("N");
//    cgreport_head.setIsPagination("Y");
//    cgreport_head.setIsCheckbox("N");
//    cgreport_head.setQuerymode("single");
//    cgreport_head.setIsDbSynch("N");
//    cgreport_head.setContent("动态报表配置抬头");
//    cgreport_head.setCreateBy("admin");
//    cgreport_head.setCreateDate(new Date());
    /*
     * cgreport_head.setJsPlugIn("$(function(){"+"\r\n" +
     * "$(\"body\").append(\"<link href=\\\"plug-in/lhgDialog/skins/default.css\\\" rel=\\\"stylesheet\\\" id=\\\"lhgdialoglink\\\">\");"
     * +"\r\n" +
     * "var $btn = $(\"<div class=\\\"ui_buttons\\\"  style=\\\"display:inline-block;\\\"><input style=\\\"position: relative;top: -8px;\\\" class=\\\"ui_state_highlight\\\" type=\\\"button\\\" value=\\\"sql解析\\\"        id=\\\"sqlAnalyze\\\" /></div>\");"
     * +"\r\n" +"$(\"#cgr_sql\").after($btn);"+"\r\n"
     * +"$btn.click(function(){"+"\r\n" +" $.ajax({"+"\r\n"
     * +"     url:\"cgReportController.do?getFields\","+"\r\n"
     * +"    data:{sql:$(\"#cgr_sql\").val()},"+"\r\n"
     * +"   type:\"Post\","+"\r\n" +"    dataType:\"json\","+"\r\n"
     * +"    success:function(data){"+"\r\n"
     * +"      if(data.status==\"success\"){"+"\r\n"
     * +"         $(\"#add_jform_cgreport_item_table\").empty();"+"\r\n"
     * +"      $.each(data.datas,function(index,e){"+"\r\n" +
     * "        var $tr = $(\"#add_jform_cgreport_item_table_template tr\").clone();"
     * +"\r\n" +"      $tr.find(\"td:eq(1) :text\").val(e);"+"\r\n"
     * +"       $tr.find(\"td:eq(2) :text\").val(index);"+"\r\n"
     * +"       $tr.find(\"td:eq(3) :text\").val(e);"+"\r\n"
     * +"       $(\"#add_jform_cgreport_item_table\").append($tr);"+"\r\n"
     * +"      }); "+"\r\n"
     * +"    resetTrNum(\"add_jform_cgreport_item_table\");"+"\r\n"
     * +"    }"+"\r\n" +"  }"+"\r\n" +"  });"+"\r\n" +" });"+"\r\n" +"});");
     * cgreport_head.setSqlPlugIn("0");
     */
//    cgreport_head.setCreateName("管理员");
//    cgreport_head.setJformVersion("87");
//    cgreport_head.setJformType(2);
//    cgreport_head.setRelationType(0);
//    cgreport_head.setSubTableStr("jform_cgreport_item");
//    /* cgreport_head.setSqlPlugIn("select * from t_s_user"); */
//
//    commonDao.saveOrUpdate(cgreport_head);
//
//    CgFormHeadEntity cgreport_item = new CgFormHeadEntity();
//    cgreport_item.setTableName("jform_cgreport_item");
//    cgreport_item.setIsTree("N");
//    cgreport_item.setIsPagination("Y");
//    cgreport_item.setIsCheckbox("N");
//    cgreport_item.setQuerymode("single");
//    cgreport_item.setIsDbSynch("N");
//    cgreport_item.setContent("动态报表配置明细");
//    cgreport_item.setCreateBy("admin");
//    cgreport_item.setCreateDate(new Date());
//    /*
//     * cgreport_item.setJsPlugIn("0"); cgreport_item.setSqlPlugIn("0");
//     */
//    cgreport_item.setCreateName("管理员");
//    cgreport_item.setJformVersion("12");
//    cgreport_item.setJformType(3);
//    cgreport_item.setRelationType(0);
//    commonDao.saveOrUpdate(cgreport_item);

    CgFormHeadEntity customer = new CgFormHeadEntity();
    customer.setTableName("jform_order_customer");
    customer.setIsTree("N");
    customer.setIsPagination("Y");
    customer.setIsCheckbox("Y");
    customer.setQuerymode("single");
    customer.setIsDbSynch("N");
    customer.setContent("订单客户信息");
    customer.setCreateBy("admin");
    customer.setJformPkType("UUID");
    customer.setCreateDate(new Date());
    /*
     * customer.setJsPlugIn("alert(' hello world ');");
     * customer.setSqlPlugIn("0");
     */
    customer.setCreateName("管理员");
    customer.setJformVersion("16");
    customer.setJformType(3);
    customer.setRelationType(0);
    commonDao.saveOrUpdate(customer);

    CgFormHeadEntity ticket = new CgFormHeadEntity();
    ticket.setTableName("jform_order_ticket");
    ticket.setIsTree("N");
    ticket.setIsPagination("Y");
    ticket.setIsCheckbox("N");
    ticket.setQuerymode("single");
    ticket.setIsDbSynch("N");
    ticket.setJformPkType("UUID");
    ticket.setContent("订单机票信息");
    ticket.setCreateBy("admin");
    ticket.setCreateDate(new Date());
    /*
     * ticket.setJsPlugIn(
     * "$(\"input/[name=\'name\']\").change( function() { \r\n 这里可以写些验证代码 \r\n  var name = $(\"#name\").val();  \r\nalert(name);});"
     * ); ticket.setSqlPlugIn("0");
     */
    ticket.setCreateName("管理员");
    ticket.setJformVersion("20");
    ticket.setJformType(3);
    ticket.setRelationType(0);
    commonDao.saveOrUpdate(ticket);

    CgFormHeadEntity price1 = new CgFormHeadEntity();
    price1.setTableName("jform_price1");
    price1.setIsTree("N");
    price1.setIsPagination("Y");
    price1.setIsCheckbox("N");
    price1.setQuerymode("group");
    price1.setIsDbSynch("N");
    price1.setJformPkType("UUID");
    price1.setContent("价格认证机构统计表");
    price1.setCreateBy("admin");
    price1.setCreateDate(new Date());
    /*
     * price1.setJsPlugIn("0"); price1.setSqlPlugIn("0");
     */
    price1.setCreateName("管理员");
    price1.setJformVersion("3");
    price1.setJformType(1);
    price1.setRelationType(0);
    commonDao.saveOrUpdate(price1);

  }
 
View Full Code Here

TOP

Related Classes of org.jeecgframework.web.cgform.entity.config.CgFormHeadEntity

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.