dc0059.js

extjs+oracle+ erpcrm

/** 
 * Data Component: DC0059G, Title: Sales orders
 */ 

  Ext.ns("N21.DataComp");
  N21.DataComp.DC0059G = Ext.extend(N21.Base.GridView, {
     dataRecordMeta:    Ext.data.Record.create([
          {name:"_p_record_status", type:"string"}
         ,{name:"ID", type:"float" }
         ,{name:"CLIENT_CODE", type:"string" }
         ,{name:"CLIENT_ID", type:"float" }
         ,{name:"DOC_NO", type:"string" }
         ,{name:"DOC_DATE", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"BPARTNER_ID", type:"float" }
         ,{name:"BPARTNER_NAME", type:"string" }
         ,{name:"CREATEDON", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"CREATEDBY", type:"string" }
         ,{name:"MODIFIEDON", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"MODIFIEDBY", type:"string" }
         ,{name:"BILL_BPARTNER_ID", type:"float" }
         ,{name:"BILL_BPARTNER_NAME", type:"string" }
         ,{name:"DELIV_BPARTNER_NAME", type:"string" }
         ,{name:"DELIV_BPARTNER_ID", type:"float" }
         ,{name:"PAY_BPARTNER_NAME", type:"string" }
         ,{name:"PAY_BPARTNER_ID", type:"float" }
         ,{name:"BPARTNER_CONTACT_ID", type:"float" }
         ,{name:"BILL_BPARTNER_CONTACT_ID", type:"float" }
         ,{name:"DELIV_BPARTNER_CONTACT_ID", type:"float" }
         ,{name:"PAY_BPARTNER_CONTACT_ID", type:"float" }
         ,{name:"REF_SORDER_ID", type:"float" }
         ,{name:"CURRENCY", type:"string" }
         ,{name:"PAYMETHOD_CODE", type:"string" }
         ,{name:"SALESREP_ID", type:"float" }
         ,{name:"TOTAL_AMOUNT", type:"float" }
    ])
     ,queryFields: new Ext.util.MixedCollection()
     ,queryFieldsVisible: new Array()
     ,queryPanelColCount:4 
    ,recordPk:[ "ID"]
    ,initComponent:function() {
       
         this.queryFields.add("ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_ID",id:"DC0059_QRY_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.ID||"Id"})  );
         this.queryFields.add("CLIENT_CODE", new N21.DataComp.LOV0008({xtype: "LOV0008",name:"QRY_CLIENT_CODE",id:"DC0059_QRY_CLIENT_CODE",width:100,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_CODE||"Client"})  );
         this.queryFields.add("CLIENT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_CLIENT_ID",id:"DC0059_QRY_CLIENT_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_ID||"Client_id"})  );
         this.queryFields.add("DOC_NO", new Ext.form.TextField ({xtype: "textfield",name:"QRY_DOC_NO",id:"DC0059_QRY_DOC_NO",width:100,fieldLabel: this.resourceBundle.FieldLabel.DOC_NO||"Order no."})  );
         this.queryFields.add("DOC_DATE", new Ext.form.DateField ({xtype: "datefield",name:"QRY_DOC_DATE",id:"DC0059_QRY_DOC_DATE",width:100,fieldLabel: this.resourceBundle.FieldLabel.DOC_DATE||"Date",format:Ext.DATE_FORMAT})  );
         this.queryFields.add("BPARTNER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_BPARTNER_ID",id:"DC0059_QRY_BPARTNER_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.BPARTNER_ID||"Bpartner_id"})  );
         this.queryFields.add("BPARTNER_NAME", new N21.DataComp.LOV0041({xtype: "LOV0041",fieldMapping: [{column:"ID",field:"DC0059_QRY_BPARTNER_ID"}],selectOnFocus:true,name:"QRY_BPARTNER_NAME",id:"DC0059_QRY_BPARTNER_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.BPARTNER_NAME||"Customer"})  );
         this.queryFields.add("BILL_BPARTNER_NAME", new N21.DataComp.LOV0041({xtype: "LOV0041",fieldMapping: [{column:"ID",field:"DC0059_QRY_BILL_BPARTNER_ID"}],selectOnFocus:true,name:"QRY_BILL_BPARTNER_NAME",id:"DC0059_QRY_BILL_BPARTNER_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.BILL_BPARTNER_NAME||"Invoice to"})  );
         this.queryFields.add("BILL_BPARTNER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_BILL_BPARTNER_ID",id:"DC0059_QRY_BILL_BPARTNER_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.BILL_BPARTNER_ID||"Bill_bpartner_id"})  );
         this.queryFields.add("DELIV_BPARTNER_NAME", new N21.DataComp.LOV0041({xtype: "LOV0041",fieldMapping: [{column:"ID",field:"DC0059_QRY_DELIV_BPARTNER_ID"}],selectOnFocus:true,name:"QRY_DELIV_BPARTNER_NAME",id:"DC0059_QRY_DELIV_BPARTNER_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.DELIV_BPARTNER_NAME||"Deliver to"})  );
         this.queryFields.add("DELIV_BPARTNER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_DELIV_BPARTNER_ID",id:"DC0059_QRY_DELIV_BPARTNER_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.DELIV_BPARTNER_ID||"Deliv_bpartner_id"})  );
         this.queryFields.add("PAY_BPARTNER_NAME", new N21.DataComp.LOV0041({xtype: "LOV0041",fieldMapping: [{column:"ID",field:"DC0059_QRY_PAY_BPARTNER_ID"}],selectOnFocus:true,name:"QRY_PAY_BPARTNER_NAME",id:"DC0059_QRY_PAY_BPARTNER_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.PAY_BPARTNER_NAME||"Pay by"})  );
         this.queryFields.add("PAY_BPARTNER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_PAY_BPARTNER_ID",id:"DC0059_QRY_PAY_BPARTNER_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.PAY_BPARTNER_ID||"Pay_bpartner_id"})  );
         this.queryFields.add("BPARTNER_CONTACT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_BPARTNER_CONTACT_ID",id:"DC0059_QRY_BPARTNER_CONTACT_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.BPARTNER_CONTACT_ID||"Bpartner_contact_id"})  );
         this.queryFields.add("BILL_BPARTNER_CONTACT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_BILL_BPARTNER_CONTACT_ID",id:"DC0059_QRY_BILL_BPARTNER_CONTACT_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.BILL_BPARTNER_CONTACT_ID||"Bill_bpartner_contact_id"})  );
         this.queryFields.add("DELIV_BPARTNER_CONTACT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_DELIV_BPARTNER_CONTACT_ID",id:"DC0059_QRY_DELIV_BPARTNER_CONTACT_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.DELIV_BPARTNER_CONTACT_ID||"Deliv_bpartner_contact_id"})  );
         this.queryFields.add("PAY_BPARTNER_CONTACT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_PAY_BPARTNER_CONTACT_ID",id:"DC0059_QRY_PAY_BPARTNER_CONTACT_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.PAY_BPARTNER_CONTACT_ID||"Pay_bpartner_contact_id"})  );
         this.queryFields.add("REF_SORDER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_REF_SORDER_ID",id:"DC0059_QRY_REF_SORDER_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.REF_SORDER_ID||"Ref_order_id"})  );
         this.queryFields.add("CURRENCY", new N21.DataComp.LOV0001({xtype: "LOV0001",name:"QRY_CURRENCY",id:"DC0059_QRY_CURRENCY",width:100,fieldLabel: this.resourceBundle.FieldLabel.CURRENCY||"Currency"})  );
         this.queryFields.add("PAYMETHOD_CODE", new Ext.form.TextField ({xtype: "textfield",name:"QRY_PAYMETHOD_CODE",id:"DC0059_QRY_PAYMETHOD_CODE",width:100,fieldLabel: this.resourceBundle.FieldLabel.PAYMETHOD_CODE||"Paymethod_code"})  );
  
       this.queryFieldsVisible = [  "CLIENT_CODE","DOC_NO","DOC_DATE","BPARTNER_NAME","BILL_BPARTNER_NAME","DELIV_BPARTNER_NAME","PAY_BPARTNER_NAME","CURRENCY","PAYMETHOD_CODE" ];
       Ext.apply(this, {
           store: new Ext.data.JsonStore({
               id:"storeDC0059"
              ,totalProperty:"totalCount"
              ,root:"records"
              ,url:"frmMain.php?_p_action=fetch&_p_data_format=json&_p_form=DC0059"
              ,remoteSort :true
              ,fields:this.dataRecordMeta
           })
          ,columns: [new Ext.grid.RowNumberer(),
               { id:"ID",header:this.resourceBundle.FieldLabel.ID||"Id",width:100,dataIndex:'ID',hidden:true,sortable:true}
              ,{ id:"CLIENT_CODE",header:this.resourceBundle.FieldLabel.CLIENT_CODE||"Client",width:100,dataIndex:'CLIENT_CODE',sortable:true}
              ,{ id:"CLIENT_ID",header:this.resourceBundle.FieldLabel.CLIENT_ID||"Client_id",width:100,dataIndex:'CLIENT_ID',hidden:true,sortable:true}
              ,{ id:"DOC_NO",header:this.resourceBundle.FieldLabel.DOC_NO||"Order no.",width:100,dataIndex:'DOC_NO',sortable:true}
              ,{ id:"DOC_DATE",header:this.resourceBundle.FieldLabel.DOC_DATE||"Date",width:100,dataIndex:'DOC_DATE',sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"BPARTNER_ID",header:this.resourceBundle.FieldLabel.BPARTNER_ID||"Bpartner_id",width:100,dataIndex:'BPARTNER_ID',hidden:true,sortable:true}
              ,{ id:"BPARTNER_NAME",header:this.resourceBundle.FieldLabel.BPARTNER_NAME||"Customer",width:100,dataIndex:'BPARTNER_NAME',sortable:true}
              ,{ id:"CREATEDON",header:this.resourceBundle.FieldLabel.CREATEDON||"Created on",width:100,dataIndex:'CREATEDON',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"CREATEDBY",header:this.resourceBundle.FieldLabel.CREATEDBY||"Createdby",width:100,dataIndex:'CREATEDBY',hidden:true,sortable:true}
              ,{ id:"MODIFIEDON",header:this.resourceBundle.FieldLabel.MODIFIEDON||"Modifiedon",width:100,dataIndex:'MODIFIEDON',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"MODIFIEDBY",header:this.resourceBundle.FieldLabel.MODIFIEDBY||"Modifiedby",width:100,dataIndex:'MODIFIEDBY',hidden:true,sortable:true}
              ,{ id:"BILL_BPARTNER_ID",header:this.resourceBundle.FieldLabel.BILL_BPARTNER_ID||"Bill_bpartner_id",width:100,dataIndex:'BILL_BPARTNER_ID',hidden:true,sortable:true}
              ,{ id:"BILL_BPARTNER_NAME",header:this.resourceBundle.FieldLabel.BILL_BPARTNER_NAME||"Invoice to",width:100,dataIndex:'BILL_BPARTNER_NAME',hidden:true,sortable:true}
              ,{ id:"DELIV_BPARTNER_NAME",header:this.resourceBundle.FieldLabel.DELIV_BPARTNER_NAME||"Deliver to",width:100,dataIndex:'DELIV_BPARTNER_NAME',hidden:true,sortable:true}
              ,{ id:"DELIV_BPARTNER_ID",header:this.resourceBundle.FieldLabel.DELIV_BPARTNER_ID||"Deliv_bpartner_id",width:100,dataIndex:'DELIV_BPARTNER_ID',hidden:true,sortable:true}
              ,{ id:"PAY_BPARTNER_NAME",header:this.resourceBundle.FieldLabel.PAY_BPARTNER_NAME||"Pay by",width:100,dataIndex:'PAY_BPARTNER_NAME',hidden:true,sortable:true}
              ,{ id:"PAY_BPARTNER_ID",header:this.resourceBundle.FieldLabel.PAY_BPARTNER_ID||"Pay_bpartner_id",width:100,dataIndex:'PAY_BPARTNER_ID',hidden:true,sortable:true}
              ,{ id:"BPARTNER_CONTACT_ID",header:this.resourceBundle.FieldLabel.BPARTNER_CONTACT_ID||"Bpartner_contact_id",width:100,dataIndex:'BPARTNER_CONTACT_ID',hidden:true,sortable:true}
              ,{ id:"BILL_BPARTNER_CONTACT_ID",header:this.resourceBundle.FieldLabel.BILL_BPARTNER_CONTACT_ID||"Bill_bpartner_contact_id",width:100,dataIndex:'BILL_BPARTNER_CONTACT_ID',hidden:true,sortable:true}
              ,{ id:"DELIV_BPARTNER_CONTACT_ID",header:this.resourceBundle.FieldLabel.DELIV_BPARTNER_CONTACT_ID||"Deliv_bpartner_contact_id",width:100,dataIndex:'DELIV_BPARTNER_CONTACT_ID',hidden:true,sortable:true}
              ,{ id:"PAY_BPARTNER_CONTACT_ID",header:this.resourceBundle.FieldLabel.PAY_BPARTNER_CONTACT_ID||"Pay_bpartner_contact_id",width:100,dataIndex:'PAY_BPARTNER_CONTACT_ID',hidden:true,sortable:true}
              ,{ id:"REF_SORDER_ID",header:this.resourceBundle.FieldLabel.REF_SORDER_ID||"Ref_order_id",width:100,dataIndex:'REF_SORDER_ID',hidden:true,sortable:true}
              ,{ id:"CURRENCY",header:this.resourceBundle.FieldLabel.CURRENCY||"Currency",width:100,dataIndex:'CURRENCY',sortable:true}
              ,{ id:"PAYMETHOD_CODE",header:this.resourceBundle.FieldLabel.PAYMETHOD_CODE||"Paymethod_code",width:100,dataIndex:'PAYMETHOD_CODE',hidden:true,sortable:true}
              ,{ id:"SALESREP_ID",header:this.resourceBundle.FieldLabel.SALESREP_ID||"Salesrep_id",width:100,dataIndex:'SALESREP_ID',hidden:true,sortable:true}
              ,{ id:"TOTAL_AMOUNT",header:this.resourceBundle.FieldLabel.TOTAL_AMOUNT||"Total amount",width:100,dataIndex:'TOTAL_AMOUNT',sortable:true,align:'right'}
          ]
          ,dataComponentName:"DC0059G"
          ,queryArraySize:20
          ,toolbarConfig:"STANDARD"
        });
       N21.DataComp.DC0059G.superclass.initComponent.apply(this, arguments);
     }
    ,onRender:function() {
       N21.DataComp.DC0059G.superclass.onRender.apply(this, arguments);
     }
    ,newDataRecord:function() {
       return new this.dataRecordMeta({_p_record_status:"insert"
              ,ID:""
              ,CLIENT_CODE:""
              ,CLIENT_ID:""
              ,DOC_NO:""
              ,DOC_DATE:""
              ,BPARTNER_ID:""
              ,BPARTNER_NAME:""
              ,CREATEDON:""
              ,CREATEDBY:""
              ,MODIFIEDON:""
              ,MODIFIEDBY:""
              ,BILL_BPARTNER_ID:""
              ,BILL_BPARTNER_NAME:""
              ,DELIV_BPARTNER_NAME:""
              ,DELIV_BPARTNER_ID:""
              ,PAY_BPARTNER_NAME:""
              ,PAY_BPARTNER_ID:""
              ,BPARTNER_CONTACT_ID:""
              ,BILL_BPARTNER_CONTACT_ID:""
              ,DELIV_BPARTNER_CONTACT_ID:""
              ,PAY_BPARTNER_CONTACT_ID:""
              ,REF_SORDER_ID:""
              ,CURRENCY:""
              ,PAYMETHOD_CODE:""
              ,SALESREP_ID:""
              ,TOTAL_AMOUNT:""});
     }
  });
  Ext.reg("DC0059G", N21.DataComp.DC0059G);
/** 
 * Data Component: DC0059F, Title: Sales orders
 */ 

  Ext.ns("N21.DataComp");
  N21.DataComp.DC0059F = Ext.extend(N21.Base.EditForm, {
     fields: new Ext.util.MixedCollection()
    ,dataRecordMeta : N21.DataComp.DC0059G.prototype.dataRecordMeta
    ,layoutItems: new Ext.util.MixedCollection()
    ,initComponent:function() {
       
       this.fields.add("_p_record_status",new Ext.form.Hidden({xtype: "hidden", allowBlank: true, fieldLabel: "record_status", selectOnFocus: false, style: "", name: "_p_record_status"})   );
       this.fields.add("ID", new Ext.form.Hidden ({xtype: "hidden",name:"ID",id:"DC0059F_ID",dataIndex:"ID",width:100,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.ID||"Id",insert_allowed:true,update_allowed:true})   );
       this.fields.add("CLIENT_CODE", new N21.DataComp.LOV0008({xtype: "LOV0008",fieldMapping: [{column:"ID",field:"DC0059F_CLIENT_ID"}],selectOnFocus:true,name:"CLIENT_CODE",id:"DC0059F_CLIENT_CODE",dataIndex:"CLIENT_CODE",width:120,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_CODE||"Client",insert_allowed:true,update_allowed:true})   );
       this.fields.add("CLIENT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"CLIENT_ID",id:"DC0059F_CLIENT_ID",dataIndex:"CLIENT_ID",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_ID||"Client_id",insert_allowed:true,update_allowed:true})   );
       this.fields.add("DOC_NO", new Ext.form.TextField ({xtype: "textfield",name:"DOC_NO",id:"DC0059F_DOC_NO",dataIndex:"DOC_NO",width:100,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.DOC_NO||"Order no.",insert_allowed:true,update_allowed:true})   );
       this.fields.add("DOC_DATE", new Ext.form.DateField ({xtype: "datefield",name:"DOC_DATE",id:"DC0059F_DOC_DATE",dataIndex:"DOC_DATE",width:80,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.DOC_DATE||"Date",insert_allowed:true,update_allowed:true,format:Ext.DATE_FORMAT})   );
       this.fields.add("BPARTNER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"BPARTNER_ID",id:"DC0059F_BPARTNER_ID",dataIndex:"BPARTNER_ID",width:100,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.BPARTNER_ID||"Bpartner_id",insert_allowed:true,update_allowed:true})   );
       this.fields.add("BPARTNER_NAME", new N21.DataComp.LOV0041({xtype: "LOV0041",fieldMapping: [{column:"ID",field:"DC0059F_BPARTNER_ID"}],selectOnFocus:true,name:"BPARTNER_NAME",id:"DC0059F_BPARTNER_NAME",dataIndex:"BPARTNER_NAME",width:200,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.BPARTNER_NAME||"Customer",insert_allowed:true,update_allowed:true})   );