dc0014.js

extjs+oracle+ erpcrm

/** 
 * Data Component: DC0014G, Title: Business partners
 */ 

  Ext.ns("N21.DataComp");
  N21.DataComp.DC0014G = Ext.extend(N21.Base.GridView, {
     dataRecordMeta:    Ext.data.Record.create([
          {name:"_p_record_status", type:"string"}
         ,{name:"CLIENT_CODE", type:"string" }
         ,{name:"CLIENT_ID", type:"float" }
         ,{name:"ID", type:"float" }
         ,{name:"CODE", type:"string" }
         ,{name:"NAME", type:"string" }
         ,{name:"TAX_NUMBER_TYPE", type:"string" }
         ,{name:"TAX_NUMBER", type:"string" }
         ,{name:"COMPANY_REG_NR", type:"string" }
         ,{name:"PHONE", type:"string" }
         ,{name:"EMAIL", type:"string" }
         ,{name:"FAX", type:"string" }
         ,{name:"BPARTNER_TYPE", type:"string" }
         ,{name:"BPARTNER_ID", type:"float" }
         ,{name:"COPIED_FROM_BPARTNER_ID", type:"float" }
         ,{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:"CUSTGROUP_CODE", type:"string" }
         ,{name:"CREDITCLASS_CODE", type:"string" }
         ,{name:"PAYMETHOD_CODE", type:"string" }
         ,{name:"PAYTERMCLASS_CODE", type:"string" }
         ,{name:"MAX_CREDIT_LIMIT", type:"float" }
         ,{name:"MAX_PAYMENT_TERM", type:"float" }
         ,{name:"IS_CUSTOMER", type:"string" }
         ,{name:"IS_VENDOR", type:"string" }
         ,{name:"IS_EMPLOYEE", type:"string" }
         ,{name:"IS_ONETIME", type:"string" }
    ])
     ,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:"DC0014_QRY_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.ID||"Id"})  );
         this.queryFields.add("CLIENT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_CLIENT_ID",id:"DC0014_QRY_CLIENT_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_ID||"Client_id"})  );
         this.queryFields.add("CLIENT_CODE", new N21.DataComp.LOV0008({xtype: "LOV0008",name:"QRY_CLIENT_CODE",id:"DC0014_QRY_CLIENT_CODE",width:100,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_CODE||"Client"})  );
         this.queryFields.add("CODE", new Ext.form.TextField ({xtype: "textfield",name:"QRY_CODE",id:"DC0014_QRY_CODE",width:100,fieldLabel: this.resourceBundle.FieldLabel.CODE||"Code"})  );
         this.queryFields.add("NAME", new Ext.form.TextField ({xtype: "textfield",name:"QRY_NAME",id:"DC0014_QRY_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.NAME||"Name"})  );
         this.queryFields.add("TAX_NUMBER", new Ext.form.TextField ({xtype: "textfield",name:"QRY_TAX_NUMBER",id:"DC0014_QRY_TAX_NUMBER",width:100,fieldLabel: this.resourceBundle.FieldLabel.TAX_NUMBER||"Tax no"})  );
         this.queryFields.add("BPARTNER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_BPARTNER_ID",id:"DC0014_QRY_BPARTNER_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.BPARTNER_ID||"Bpartner_id"})  );
         this.queryFields.add("IS_CUSTOMER", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_CUSTOMER",id:"DC0014_QRY_IS_CUSTOMER",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_CUSTOMER||"Customer?"})  );
         this.queryFields.add("IS_VENDOR", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_VENDOR",id:"DC0014_QRY_IS_VENDOR",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_VENDOR||"Vendor?"})  );
         this.queryFields.add("IS_EMPLOYEE", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_EMPLOYEE",id:"DC0014_QRY_IS_EMPLOYEE",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_EMPLOYEE||"Employee?"})  );
  
       this.queryFieldsVisible = [  "CLIENT_CODE","CODE","NAME","TAX_NUMBER","IS_CUSTOMER","IS_VENDOR","IS_EMPLOYEE" ];
       Ext.apply(this, {
           store: new Ext.data.JsonStore({
               id:"storeDC0014"
              ,totalProperty:"totalCount"
              ,root:"records"
              ,url:"frmMain.php?_p_action=fetch&_p_data_format=json&_p_form=DC0014"
              ,remoteSort :true
              ,fields:this.dataRecordMeta
           })
          ,columns: [new Ext.grid.RowNumberer(),
               { id:"CLIENT_CODE",header:this.resourceBundle.FieldLabel.CLIENT_CODE||"Client",width:80,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:"ID",header:this.resourceBundle.FieldLabel.ID||"Id",width:100,dataIndex:'ID',hidden:true,sortable:true}
              ,{ id:"CODE",header:this.resourceBundle.FieldLabel.CODE||"Code",width:100,dataIndex:'CODE',sortable:true}
              ,{ id:"NAME",header:this.resourceBundle.FieldLabel.NAME||"Name",width:180,dataIndex:'NAME',sortable:true}
              ,{ id:"TAX_NUMBER_TYPE",header:this.resourceBundle.FieldLabel.TAX_NUMBER_TYPE||"Tax no type",width:100,dataIndex:'TAX_NUMBER_TYPE',hidden:true,sortable:true}
              ,{ id:"TAX_NUMBER",header:this.resourceBundle.FieldLabel.TAX_NUMBER||"Tax no",width:100,dataIndex:'TAX_NUMBER',hidden:true,sortable:true}
              ,{ id:"COMPANY_REG_NR",header:this.resourceBundle.FieldLabel.COMPANY_REG_NR||"Registration no",width:100,dataIndex:'COMPANY_REG_NR',hidden:true,sortable:true}
              ,{ id:"PHONE",header:this.resourceBundle.FieldLabel.PHONE||"Phone",width:100,dataIndex:'PHONE',hidden:true,sortable:true}
              ,{ id:"EMAIL",header:this.resourceBundle.FieldLabel.EMAIL||"Email",width:100,dataIndex:'EMAIL',hidden:true,sortable:true}
              ,{ id:"FAX",header:this.resourceBundle.FieldLabel.FAX||"Fax",width:100,dataIndex:'FAX',hidden:true,sortable:true}
              ,{ id:"BPARTNER_TYPE",header:this.resourceBundle.FieldLabel.BPARTNER_TYPE||"Type",width:100,dataIndex:'BPARTNER_TYPE',hidden:true,sortable:true}
              ,{ id:"BPARTNER_ID",header:this.resourceBundle.FieldLabel.BPARTNER_ID||"Bpartner_id",width:100,dataIndex:'BPARTNER_ID',hidden:true,sortable:true}
              ,{ id:"COPIED_FROM_BPARTNER_ID",header:this.resourceBundle.FieldLabel.COPIED_FROM_BPARTNER_ID||"Copied from ID",width:100,dataIndex:'COPIED_FROM_BPARTNER_ID',hidden:true,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||"Created by",width:100,dataIndex:'CREATEDBY',hidden:true,sortable:true}
              ,{ id:"MODIFIEDON",header:this.resourceBundle.FieldLabel.MODIFIEDON||"Modified on",width:100,dataIndex:'MODIFIEDON',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"MODIFIEDBY",header:this.resourceBundle.FieldLabel.MODIFIEDBY||"Modified by",width:100,dataIndex:'MODIFIEDBY',hidden:true,sortable:true}
              ,{ id:"CUSTGROUP_CODE",header:this.resourceBundle.FieldLabel.CUSTGROUP_CODE||"Custgroup_code",width:100,dataIndex:'CUSTGROUP_CODE',hidden:true,sortable:true}
              ,{ id:"CREDITCLASS_CODE",header:this.resourceBundle.FieldLabel.CREDITCLASS_CODE||"Creditclass_code",width:100,dataIndex:'CREDITCLASS_CODE',hidden:true,sortable:true}
              ,{ id:"PAYMETHOD_CODE",header:this.resourceBundle.FieldLabel.PAYMETHOD_CODE||"Paymethod_code",width:100,dataIndex:'PAYMETHOD_CODE',hidden:true,sortable:true}
              ,{ id:"PAYTERMCLASS_CODE",header:this.resourceBundle.FieldLabel.PAYTERMCLASS_CODE||"Paytermclass_code",width:100,dataIndex:'PAYTERMCLASS_CODE',hidden:true,sortable:true}
              ,{ id:"MAX_CREDIT_LIMIT",header:this.resourceBundle.FieldLabel.MAX_CREDIT_LIMIT||"Max_credit_limit",width:100,dataIndex:'MAX_CREDIT_LIMIT',hidden:true,sortable:true,align:'right'}
              ,{ id:"MAX_PAYMENT_TERM",header:this.resourceBundle.FieldLabel.MAX_PAYMENT_TERM||"Max_payment_term",width:100,dataIndex:'MAX_PAYMENT_TERM',hidden:true,sortable:true,align:'right'}
              ,{ id:"IS_CUSTOMER",header:this.resourceBundle.FieldLabel.IS_CUSTOMER||"Customer?",width:50,dataIndex:'IS_CUSTOMER',sortable:true}
              ,{ id:"IS_VENDOR",header:this.resourceBundle.FieldLabel.IS_VENDOR||"Vendor?",width:50,dataIndex:'IS_VENDOR',sortable:true}
              ,{ id:"IS_EMPLOYEE",header:this.resourceBundle.FieldLabel.IS_EMPLOYEE||"Employee?",width:50,dataIndex:'IS_EMPLOYEE',sortable:true}
              ,{ id:"IS_ONETIME",header:this.resourceBundle.FieldLabel.IS_ONETIME||"Is_onetime",width:50,dataIndex:'IS_ONETIME',hidden:true,sortable:true}
          ]
          ,dataComponentName:"DC0014G"
          ,queryArraySize:20
          ,toolbarConfig:"STANDARD"
        });
       N21.DataComp.DC0014G.superclass.initComponent.apply(this, arguments);
     }
    ,onRender:function() {
       N21.DataComp.DC0014G.superclass.onRender.apply(this, arguments);
     }
    ,newDataRecord:function() {
       return new this.dataRecordMeta({_p_record_status:"insert"
              ,CLIENT_CODE:""
              ,CLIENT_ID:""
              ,ID:""
              ,CODE:""
              ,NAME:""
              ,TAX_NUMBER_TYPE:""
              ,TAX_NUMBER:""
              ,COMPANY_REG_NR:""
              ,PHONE:""
              ,EMAIL:""
              ,FAX:""
              ,BPARTNER_TYPE:""
              ,BPARTNER_ID:""
              ,COPIED_FROM_BPARTNER_ID:""
              ,CREATEDON:""
              ,CREATEDBY:""
              ,MODIFIEDON:""
              ,MODIFIEDBY:""
              ,CUSTGROUP_CODE:""
              ,CREDITCLASS_CODE:""
              ,PAYMETHOD_CODE:""
              ,PAYTERMCLASS_CODE:""
              ,MAX_CREDIT_LIMIT:""
              ,MAX_PAYMENT_TERM:""
              ,IS_CUSTOMER:""
              ,IS_VENDOR:""
              ,IS_EMPLOYEE:""
              ,IS_ONETIME:""});
     }
  });
  Ext.reg("DC0014G", N21.DataComp.DC0014G);
/** 
 * Data Component: DC0014F, Title: Business partners
 */ 

  Ext.ns("N21.DataComp");
  N21.DataComp.DC0014F = Ext.extend(N21.Base.EditForm, {
     fields: new Ext.util.MixedCollection()
    ,dataRecordMeta : N21.DataComp.DC0014G.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("CLIENT_CODE", new N21.DataComp.LOV0008({xtype: "LOV0008",fieldMapping: [{column:"ID",field:"DC0014F_CLIENT_ID"}],selectOnFocus:true,name:"CLIENT_CODE",id:"DC0014F_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:"DC0014F_CLIENT_ID",dataIndex:"CLIENT_ID",width:100,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_ID||"Client_id",insert_allowed:true,update_allowed:true})   );
       this.fields.add("ID", new Ext.form.Hidden ({xtype: "hidden",name:"ID",id:"DC0014F_ID",dataIndex:"ID",width:100,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.ID||"Id",insert_allowed:true,update_allowed:true})   );
       this.fields.add("CODE", new Ext.form.TextField ({xtype: "textfield",name:"CODE",id:"DC0014F_CODE",dataIndex:"CODE",width:100,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.CODE||"Code",insert_allowed:true,update_allowed:true})   );
       this.fields.add("NAME", new Ext.form.TextField ({xtype: "textfield",name:"NAME",id:"DC0014F_NAME",dataIndex:"NAME",width:200,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.NAME||"Name",insert_allowed:true,update_allowed:true})   );
       this.fields.add("TAX_NUMBER_TYPE", new Ext.form.TextField ({xtype: "textfield",name:"TAX_NUMBER_TYPE",id:"DC0014F_TAX_NUMBER_TYPE",dataIndex:"TAX_NUMBER_TYPE",width:80,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.TAX_NUMBER_TYPE||"Tax no type",insert_allowed:true,update_allowed:true})   );
       this.fields.add("TAX_NUMBER", new Ext.form.TextField ({xtype: "textfield",name:"TAX_NUMBER",id:"DC0014F_TAX_NUMBER",dataIndex:"TAX_NUMBER",width:150,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.TAX_NUMBER||"Tax no",insert_allowed:true,update_allowed:true})   );
       this.fields.add("COMPANY_REG_NR", new Ext.form.TextField ({xtype: "textfield",name:"COMPANY_REG_NR",id:"DC0014F_COMPANY_REG_NR",dataIndex:"COMPANY_REG_NR",width:150,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.COMPANY_REG_NR||"Registration no",insert_allowed:true,update_allowed:true})   );
       this.fields.add("PHONE", new Ext.form.TextField ({xtype: "textfield",name:"PHONE",id:"DC0014F_PHONE",dataIndex:"PHONE",width:150,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.PHONE||"Phone",insert_allowed:true,update_allowed:true})   );
       this.fields.add("EMAIL", new Ext.form.TextField ({xtype: "textfield",name:"EMAIL",id:"DC0014F_EMAIL",dataIndex:"EMAIL",width:150,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.EMAIL||"Email",insert_allowed:true,update_allowed:true})   );
       this.fields.add("FAX", new Ext.form.TextField ({xtype: "textfield",name:"FAX",id:"DC0014F_FAX",dataIndex:"FAX",width:150,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.FAX||"Fax",insert_allowed:true,update_allowed:true})   );
       this.fields.add("CREATEDON", new Ext.form.DateField ({xtype: "datefield",name:"CREATEDON",id:"DC0014F_CREATEDON",dataIndex:"CREATEDON",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.CREATEDON||"Created on",disabled:true,format:Ext.DATE_FORMAT})   );
       this.fields.add("CREATEDBY", new Ext.form.TextField ({xtype: "textfield",name:"CREATEDBY",id:"DC0014F_CREATEDBY",dataIndex:"CREATEDBY",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.CREATEDBY||"Created by",disabled:true})   );
       this.fields.add("MODIFIEDON", new Ext.form.DateField ({xtype: "datefield",name:"MODIFIEDON",id:"DC0014F_MODIFIEDON",dataIndex:"MODIFIEDON",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.MODIFIEDON||"Modified on",disabled:true,format:Ext.DATE_FORMAT})   );
       this.fields.add("MODIFIEDBY", new Ext.form.TextField ({xtype: "textfield",name:"MODIFIEDBY",id:"DC0014F_MODIFIEDBY",dataIndex:"MODIFIEDBY",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.MODIFIEDBY||"Modified by",disabled:true})   );
       this.fields.add("IS_CUSTOMER", new Ext.ux.form.XCheckbox ({xtype: "xcheckbox",name:"IS_CUSTOMER",id:"DC0014F_IS_CUSTOMER",dataIndex:"IS_CUSTOMER",width:50,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.IS_CUSTOMER||"Customer?",insert_allowed:true,update_allowed:true})   );
       this.fields.add("IS_VENDOR", new Ext.ux.form.XCheckbox ({xtype: "xcheckbox",name:"IS_VENDOR",id:"DC0014F_IS_VENDOR",dataIndex:"IS_VENDOR",width:50,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.IS_VENDOR||"Vendor?",insert_allowed:true,update_allowed:true})   );