示例#1
0
  private void initLayout() {

    layout.setMargin(true);
    setContent(layout);

    form.setCaption("Employee Details ");
    PropertysetItem item = new PropertysetItem();
    item.addItemProperty("Name", new ObjectProperty<String>(""));
    item.addItemProperty("Address", new ObjectProperty<String>(""));

    ComboBox combobox = new ComboBox("Sex");
    combobox.setInvalidAllowed(true);
    combobox.setNullSelectionAllowed(false);
    combobox.addItem("Male");
    combobox.addItem("Female");
    item.addItemProperty("Age", new ObjectProperty<String>(""));
    item.addItemProperty("Email", new ObjectProperty<String>(""));
    item.addItemProperty("Mobile No", new ObjectProperty<String>(""));

    Form form = new Form();
    final Form reader = new Form();
    form.setCaption("Fill Your Details");
    form.setItemDataSource(item);
    reader.setItemDataSource(item);
    reader.setCaption("Your registation details");
    reader.setReadOnly(true);

    button.addClickListener(
        new Button.ClickListener() {
          public void buttonClick(ClickEvent event) {

            Label message = new Label("You are Registered");
            layout.addComponent(message);
            layout.addComponent(reader);
          }
        });
    layout.addComponent(form);

    final RichTextArea area = new RichTextArea();
    area.setValue("Add more details here");
    layout.addComponent(area);

    layout.addComponent(button);
  }
  // GoodsOrderListSvc data=new GoodsOrderListSvc();
  // @Inject   TenterpriseFacade cf;
  // @Inject  TenterpriseForm form;
  @PostConstruct
  public void initComponent() {
    /** * */
    StringBuffer sb = new StringBuffer();
    StringBuffer sb1 = new StringBuffer();
    // String fsql = data.makeSql();
    // gSqlContainer sumber=new gSqlContainer();
    MHorizontalLayout sidebar = new MHorizontalLayout();
    MHorizontalLayout isicontents = new MHorizontalLayout();
    MHorizontalLayout toolbar = new MHorizontalLayout();
    toolbar.addComponent(new CheckBox("Indv.Query"));
    // TabSheet tabsheet = new TabSheet();
    // -------------------- Header  ------------------------------
    toolbar.addComponent(new PopupDateField("Entry Date"));
    toolbar.addComponent(new PopupDateField("~"));
    toolbar.addComponent(new TextField("Item"));
    toolbar.addComponent(new ComboBox("Order Media"));
    toolbar.addComponent(new ComboBox("Order Type"));
    toolbar.addComponent(new TextField("MD"));
    toolbar.addComponent(new TextField("Vendor"));
    toolbar.addComponent(new ComboBox("Ad. Type"));

    // -------------------- Header  ------------------------------
    MHorizontalLayout toolmenu;
    toolmenu = new MHorizontalLayout();
    toolmenu.addComponent(new Button("Ret"));
    toolmenu.addComponent(new Button("Ins"));
    toolmenu.addComponent(new Button("Del"));
    toolmenu.addComponent(new Button("Save"));
    toolmenu.addComponent(new Button("Print"));
    toolmenu.addComponent(new Button("XLS"));
    addComponents(new Header("Order Item Report (GoodsOrderList)"));
    addComponents(toolmenu);
    addComponents(toolbar);
    //        addComponents(isicontents);
    // MTable table=new MTable();
    // -------------------- Header Table ---judul untuk table----------
    // List<Tenterprise> findAll = cf.findAll();
    // MTable<Tenterprise> table=new
    // MTable<Tenterprise>(Tenterprise.class).withProperties("entpName");
    // table.setBeans(findAll);
    // table.addMValueChangeListener(new MValueChangeListener<Tdescribecode>() {
    //    @Override
    //    public void valueChange(MValueChangeEvent<Tdescribecode> event) {
    //    Notification.show("ss");
    //    form.setEntity(event.getValue());
    //    }
    //    });
    // table.addContainerProperty("No", String.class,  null);
    // -------------------- Header Table ------------------------------
    //   isicontents.addComponents(table);
    try {
      SimpleJDBCConnectionPool connectionPool =
          new SimpleJDBCConnectionPool(
              "oracle.jdbc.OracleDriver", BaseEntity.jdbc, BaseEntity.user, BaseEntity.pass, 2, 5);
      SQLContainer container;
      container = new SQLContainer(new FreeformQuery(sb.toString(), connectionPool, "AD_MENU_ID"));
      // MTable table= new MTable("MENU",container);
      MTable table = new MTable();
      table.setContainerDataSource(container);
      table.addMValueChangeListener(
          new MValueChangeListener() {
            @Override
            public void valueChange(MValueChangeEvent event) {
              Notification.show("ss");
              //    form.setEntity(event.getValue());
            }
          });
      addComponents(table);
    } catch (SQLException e) {
      e.printStackTrace();
      RichTextArea rtarea = new RichTextArea();
      rtarea.setValue(sb.toString());
      addComponents(rtarea);
    }
    addLayoutClickListener(
        new LayoutEvents.LayoutClickListener() {
          @Override
          public void layoutClick(LayoutEvents.LayoutClickEvent event) {}
        });
  }
  // ScmOutDeliveryOkSvc data=new ScmOutDeliveryOkSvc();
  // @Inject   TenterpriseFacade cf;
  // @Inject  TenterpriseForm form;
  @PostConstruct
  public void initComponent() {
    /**
     * Vendor
     *
     * <p:inputText>Term
     *
     * <p:calendar>~
     *
     * <p:calendar>Item
     *
     * <p:inputText>Type
     *
     * <p:selectOneRadio><f:selectItem itemValue="Order" /><f:selectItem itemValue="Item" /> Step
     *
     * <p:selectOneListbox>*
     */
    StringBuffer sb = new StringBuffer();
    StringBuffer sb1 = new StringBuffer();
    sb.append(
        "SELECT /* entpdelivery.xml : logistics.entpdelivery.selectOrderDeliveryOk by ScmOutDeliveryOk */");
    sb.append(
        "                   DISTINCT '0' AS CHECK_YN,                                                                             ");
    sb.append(
        "                 DECODE(OD.DO_FLAG, '20', '', NVL(SM.SLIP_NO, ''))       AS SLIP_NO,                          ");
    sb.append(
        "                 DECODE(OD.DO_FLAG, '20', '', NVL(SM.DELY_GB, ''))       AS DELY_GB,                          ");
    sb.append(
        "                 DECODE(OD.DO_FLAG, '20', '', NVL(SM.REAL_RECEIVER, '')) AS REAL_RECEIVER,                    ");
    sb.append(
        "                 OD.ORDER_NO,                                                                                 ");
    sb.append("                 OD.DO_FLAG,");
    sb.append(
        "                 OD.WH_CODE,                                                                                  ");
    sb.append(
        "                 DECODE(OD.DO_FLAG, '20', '', SM.SLIP_I_NO)     AS SLIP_I_NO,                                 ");
    sb.append(
        "                 DECODE(OD.DO_FLAG, '20', '', SM.SLIP_GB)       AS SLIP_GB,                                   ");
    sb.append(
        "                 TC.CUST_NO,                                                                                  ");
    sb.append(
        "                 TC.CUST_NAME,                                                                                ");
    sb.append(
        "                 TR.RECEIVER,                                                                                 ");
    sb.append(
        "                 TR.RECEIVER_POST,                                                                            ");
    sb.append(
        "                 FUN_ADD_POSTADDR(TR.RECEIVER_POST, TR.RECEIVER_POST_SEQ, TR.RECEIVER_ADDR) AS RECEIVER_ADDR, ");
    sb.append(
        "                 TR.RECEIVER_DDD||TR.RECEIVER_TEL1||TR.RECEIVER_TEL2 AS TEL1,                                 ");
    sb.append(
        "                 TR.RECEIVER_HP1||TR.RECEIVER_HP2||TR.RECEIVER_HP3 AS TEL2 , OD.DO_FLAG                                   ");
    sb.append(
        "            FROM TORDERDT       OD,                                                                           ");
    sb.append(
        "                 TSLIPDT        SD,                                                                           ");
    sb.append(
        "                 TSLIPM         SM,                                                                           ");
    sb.append(
        "                 TCUSTOMER      TC,                                                                           ");
    sb.append(
        "                 TRECEIVER      TR,                                                                           ");
    sb.append(
        "                 TGOODS         GM                                                                            ");
    sb.append(
        "           WHERE OD.CUST_NO          = TC.CUST_NO                                                             ");
    sb.append(
        "             AND OD.CUST_NO          = TR.CUST_NO                                                             ");
    sb.append(
        "             AND OD.ORDER_NO         = SD.ORDER_NO(+)                                                         ");
    sb.append(
        "             AND OD.ORDER_G_SEQ      = SD.ORDER_G_SEQ(+)                                                      ");
    sb.append(
        "             AND OD.ORDER_D_SEQ      = SD.ORDER_D_SEQ(+)                                                      ");
    sb.append(
        "             AND OD.ORDER_W_SEQ      = SD.ORDER_W_SEQ(+)                                                      ");
    sb.append(
        "             AND SD.SLIP_I_NO        = SM.SLIP_I_NO(+)                                                        ");
    sb.append(
        "             AND OD.RECEIVER_SEQ     = TR.RECEIVER_SEQ                                                        ");
    sb.append("             AND OD.GOODS_CODE       = GM.GOODS_CODE");
    sb.append("                  AND GM.ENTP_CODE = '100002'");
    sb.append(
        "             AND OD.LAST_PROC_DATE  >= TO_DATE('2013/11/01', 'YYYY/MM/DD')                                               ");
    sb.append(
        "             AND OD.LAST_PROC_DATE   <  TO_DATE('2014/07/01', 'YYYY/MM/DD') + 1                                          ");
    sb.append(
        "             AND OD.DO_FLAG          = '30'                                                                     ");
    sb.append(
        "             AND OD.DELY_TYPE        = '20'                                                                   ");
    sb.append("             AND OD.SYSLAST          > 0 ");
    sb.append("            ");

    sb1.append(
        "SELECT /* entpdelivery.xml : logistics.entpdelivery.selectOrderDeliveryDetailOk by ScmOutDeliveryOk */    ");
    sb1.append("               OD.ORDER_NO,");
    sb1.append("               OD.ORDER_G_SEQ,");
    sb1.append("               OD.ORDER_D_SEQ,");
    sb1.append("               OD.ORDER_W_SEQ,");
    sb1.append("               OD.GOODS_CODE,");
    sb1.append("               GM.GOODS_NAME,");
    sb1.append("               OD.GOODSDT_CODE,");
    sb1.append("               OD.GOODSDT_INFO,");
    sb1.append("               OD.GOODS_GB,");
    sb1.append("               OD.SYSLAST,");
    sb1.append("               OD.SYSLAST_AMT,");
    sb1.append("               OD.SYSLAST_NET,");
    sb1.append("               OD.SYSLAST_VAT,");
    sb1.append("               SD.DELY_QTY,");
    sb1.append("               '' AS REMARK");
    sb1.append("          FROM TORDERDT  OD,");
    sb1.append("               TSLIPDT   SD,");
    sb1.append("               TSLIPM    SM,");
    sb1.append("               TGOODS    GM");
    sb1.append("         WHERE OD.ORDER_NO     = SD.ORDER_NO(+)");
    sb1.append("           AND OD.ORDER_G_SEQ  = SD.ORDER_G_SEQ(+)");
    sb1.append("           AND OD.ORDER_D_SEQ  = SD.ORDER_D_SEQ(+)");
    sb1.append("           AND OD.ORDER_W_SEQ  = SD.ORDER_W_SEQ(+)");
    sb1.append("           AND SD.SLIP_I_NO    = SM.SLIP_I_NO(+)");
    sb1.append("           AND OD.GOODS_CODE   = GM.GOODS_CODE");
    sb1.append("           AND OD.ORDER_NO     = 20140403032491");
    sb1.append("           AND NVL(SM.SLIP_I_NO, 'X') = NVL('10000000112407', 'X')");
    sb1.append("           AND OD.DO_FLAG        = '30'");
    sb1.append("           AND OD.DELY_TYPE      = '20'");
    sb1.append("           AND OD.SYSLAST        > 0");
    sb1.append("           AND GM.OUT_STOCK_YN   = '0'            ");
    // String fsql = data.makeSql();
    // gSqlContainer sumber=new gSqlContainer();
    MHorizontalLayout sidebar = new MHorizontalLayout();
    MHorizontalLayout isicontents = new MHorizontalLayout();
    MHorizontalLayout toolbar = new MHorizontalLayout();
    toolbar.addComponent(new CheckBox("Indv.Query"));
    // TabSheet tabsheet = new TabSheet();
    // -------------------- Header  ------------------------------
    toolbar.addComponent(new TextField("Promo Name"));
    toolbar.addComponent(new PopupDateField("~"));
    toolbar.addComponent(new PopupDateField("~"));
    toolbar.addComponent(new TextField("Promo Name"));
    toolbar.addComponent(new CheckBox("Type"));
    toolbar.addComponent(new CheckBox("Order"));
    toolbar.addComponent(new CheckBox("Exchange"));
    toolbar.addComponent(new ComboBox("Step"));
    toolbar.addComponent(new Button("Select"));
    toolbar.addComponent(new Button("Deselect"));
    toolbar.addComponent(new Button("Waybil No Copy"));
    toolbar.addComponent(new TextField(""));
    toolbar.addComponent(new Button("Delivery Company"));
    toolbar.addComponent(new ComboBox("Other"));

    // -------------------- Header  ------------------------------
    MHorizontalLayout toolmenu;
    toolmenu = new MHorizontalLayout();
    toolmenu.addComponent(new Button("Ret"));
    toolmenu.addComponent(new Button("Ins"));
    toolmenu.addComponent(new Button("Del"));
    toolmenu.addComponent(new Button("Save"));
    toolmenu.addComponent(new Button("Print"));
    toolmenu.addComponent(new Button("XLS"));
    addComponents(new Header("Entp Delivery Confirm (ScmOutDeliveryOk)"));
    addComponents(toolmenu);
    addComponents(toolbar);
    //        addComponents(isicontents);
    // MTable table=new MTable();
    // -------------------- Header Table ---judul untuk table----------
    // List<Tenterprise> findAll = cf.findAll();
    // MTable<Tenterprise> table=new
    // MTable<Tenterprise>(Tenterprise.class).withProperties("entpName");
    // table.setBeans(findAll);
    // table.addMValueChangeListener(new MValueChangeListener<Tdescribecode>() {
    //    @Override
    //    public void valueChange(MValueChangeEvent<Tdescribecode> event) {
    //    Notification.show("ss");
    //    form.setEntity(event.getValue());
    //    }
    //    });
    // table.addContainerProperty("No", String.class,  null);
    // -------------------- Header Table ------------------------------
    //   isicontents.addComponents(table);
    try {
      SimpleJDBCConnectionPool connectionPool =
          new SimpleJDBCConnectionPool(
              "oracle.jdbc.OracleDriver",
              "jdbc:oracle:thin:@localhost:1521/XE",
              "dartmedia",
              "dartmedia",
              2,
              5);
      SQLContainer container;
      container = new SQLContainer(new FreeformQuery(sb.toString(), connectionPool, "AD_MENU_ID"));
      // MTable table= new MTable("MENU",container);
      TreeTable table = new TreeTable("Menu", container);
      addComponents(table);
    } catch (SQLException e) {
      e.printStackTrace();
      RichTextArea rtarea = new RichTextArea();
      rtarea.setValue(sb.toString());
      addComponents(rtarea);
    }
    addLayoutClickListener(
        new LayoutEvents.LayoutClickListener() {
          @Override
          public void layoutClick(LayoutEvents.LayoutClickEvent event) {}
        });
  }