dc0042.js

extjs+oracle+ erpcrm

/** 
 * Data Component: DC0042G, Title: Accounting doc. line
 */ 

  Ext.ns("N21.DataComp");
  N21.DataComp.DC0042G = Ext.extend(N21.Base.GridView, {
     dataRecordMeta:    Ext.data.Record.create([
          {name:"_p_record_status", type:"string"}
         ,{name:"ID", type:"float" }
         ,{name:"ACCDOC_ID", type:"float" }
         ,{name:"ACCDOC_NAME", type:"string" }
         ,{name:"CLIENT_ID", type:"float" }
         ,{name:"NOTES", type:"string" }
         ,{name:"DB_ACCT", type:"string" }
         ,{name:"CR_ACCT", type:"string" }
         ,{name:"DB_AMOUNT", type:"float" }
         ,{name:"CR_AMOUNT", type:"float" }
         ,{name:"CURRENCY", type:"string" }
         ,{name:"XRATE", 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:"IS_GENERATED", type:"string" }
         ,{name:"ORIG_AMOUNT", type:"float" }
         ,{name:"ORIG_CURRENCY", type:"string" }
    ])
     ,queryFields: new Ext.util.MixedCollection()
     ,queryFieldsVisible: new Array()
     ,queryPanelColCount:0 
    ,recordPk:[ "ID"]
    ,initComponent:function() {
       
         this.queryFields.add("ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_ID",id:"DC0042_QRY_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.ID||"Id"})  );
         this.queryFields.add("ACCDOC_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_ACCDOC_ID",id:"DC0042_QRY_ACCDOC_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.ACCDOC_ID||"Accdoc_id"})  );
         this.queryFields.add("ACCDOC_NAME", new Ext.form.TextField ({xtype: "textfield",name:"QRY_ACCDOC_NAME",id:"DC0042_QRY_ACCDOC_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.ACCDOC_NAME||"Accdoc"})  );
         this.queryFields.add("CLIENT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_CLIENT_ID",id:"DC0042_QRY_CLIENT_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_ID||"Client_id"})  );
         this.queryFields.add("NOTES", new Ext.form.TextField ({xtype: "textfield",name:"QRY_NOTES",id:"DC0042_QRY_NOTES",width:100,fieldLabel: this.resourceBundle.FieldLabel.NOTES||"Notes"})  );
         this.queryFields.add("DB_ACCT", new Ext.form.TextField ({xtype: "textfield",name:"QRY_DB_ACCT",id:"DC0042_QRY_DB_ACCT",width:100,fieldLabel: this.resourceBundle.FieldLabel.DB_ACCT||"Db_acct"})  );
         this.queryFields.add("CR_ACCT", new Ext.form.TextField ({xtype: "textfield",name:"QRY_CR_ACCT",id:"DC0042_QRY_CR_ACCT",width:100,fieldLabel: this.resourceBundle.FieldLabel.CR_ACCT||"Cr_acct"})  );
         this.queryFields.add("DB_AMOUNT", new Ext.form.NumberField ({xtype: "numberfield",name:"QRY_DB_AMOUNT",id:"DC0042_QRY_DB_AMOUNT",width:100,fieldLabel: this.resourceBundle.FieldLabel.DB_AMOUNT||"Dr amount",style: "text-align:right;"})  );
         this.queryFields.add("CR_AMOUNT", new Ext.form.NumberField ({xtype: "numberfield",name:"QRY_CR_AMOUNT",id:"DC0042_QRY_CR_AMOUNT",width:100,fieldLabel: this.resourceBundle.FieldLabel.CR_AMOUNT||"Cr amount",style: "text-align:right;"})  );
         this.queryFields.add("CURRENCY", new Ext.form.TextField ({xtype: "textfield",name:"QRY_CURRENCY",id:"DC0042_QRY_CURRENCY",width:100,fieldLabel: this.resourceBundle.FieldLabel.CURRENCY||"Currency"})  );
         this.queryFields.add("XRATE", new Ext.form.NumberField ({xtype: "numberfield",name:"QRY_XRATE",id:"DC0042_QRY_XRATE",width:100,fieldLabel: this.resourceBundle.FieldLabel.XRATE||"Xrate",style: "text-align:right;"})  );
         this.queryFields.add("CREATEDON", new Ext.form.DateField ({xtype: "datefield",name:"QRY_CREATEDON",id:"DC0042_QRY_CREATEDON",width:100,fieldLabel: this.resourceBundle.FieldLabel.CREATEDON||"CreatedOn",format:Ext.DATE_FORMAT})  );
         this.queryFields.add("CREATEDBY", new Ext.form.TextField ({xtype: "textfield",name:"QRY_CREATEDBY",id:"DC0042_QRY_CREATEDBY",width:100,fieldLabel: this.resourceBundle.FieldLabel.CREATEDBY||"CreatedBy"})  );
         this.queryFields.add("MODIFIEDON", new Ext.form.DateField ({xtype: "datefield",name:"QRY_MODIFIEDON",id:"DC0042_QRY_MODIFIEDON",width:100,fieldLabel: this.resourceBundle.FieldLabel.MODIFIEDON||"ModifiedOn",format:Ext.DATE_FORMAT})  );
         this.queryFields.add("MODIFIEDBY", new Ext.form.TextField ({xtype: "textfield",name:"QRY_MODIFIEDBY",id:"DC0042_QRY_MODIFIEDBY",width:100,fieldLabel: this.resourceBundle.FieldLabel.MODIFIEDBY||"ModifiedBy"})  );
         this.queryFields.add("IS_GENERATED", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_GENERATED",id:"DC0042_QRY_IS_GENERATED",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_GENERATED||"Is_generated"})  );
         this.queryFields.add("ORIG_AMOUNT", new Ext.form.NumberField ({xtype: "numberfield",name:"QRY_ORIG_AMOUNT",id:"DC0042_QRY_ORIG_AMOUNT",width:100,fieldLabel: this.resourceBundle.FieldLabel.ORIG_AMOUNT||"Orig_amount",style: "text-align:right;"})  );
         this.queryFields.add("ORIG_CURRENCY", new Ext.form.TextField ({xtype: "textfield",name:"QRY_ORIG_CURRENCY",id:"DC0042_QRY_ORIG_CURRENCY",width:100,fieldLabel: this.resourceBundle.FieldLabel.ORIG_CURRENCY||"Orig_currency"})  );
  
       this.queryFieldsVisible = [  "ACCDOC_NAME","NOTES","DB_ACCT","CR_ACCT","DB_AMOUNT","CR_AMOUNT","CURRENCY","XRATE","CREATEDON","CREATEDBY","MODIFIEDON","MODIFIEDBY","IS_GENERATED","ORIG_AMOUNT","ORIG_CURRENCY" ];
       Ext.apply(this, {
           store: new Ext.data.Store({
               id:"storeDC0042"
              ,reader: new Ext.data.XmlReader({totalRecords:"totalCount",record: "record"},this.dataRecordMeta)
              ,url:"frmMain.php?_p_action=fetch&_p_data_format=xml&_p_form=DC0042"
              ,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:"ACCDOC_ID",header:this.resourceBundle.FieldLabel.ACCDOC_ID||"Accdoc_id",width:100,dataIndex:'ACCDOC_ID',hidden:true,sortable:true}
              ,{ id:"ACCDOC_NAME",header:this.resourceBundle.FieldLabel.ACCDOC_NAME||"Accdoc",width:100,dataIndex:'ACCDOC_NAME',sortable:true}
              ,{ id:"CLIENT_ID",header:this.resourceBundle.FieldLabel.CLIENT_ID||"Client_id",width:100,dataIndex:'CLIENT_ID',hidden:true,sortable:true}
              ,{ id:"NOTES",header:this.resourceBundle.FieldLabel.NOTES||"Notes",width:100,dataIndex:'NOTES',sortable:true}
              ,{ id:"DB_ACCT",header:this.resourceBundle.FieldLabel.DB_ACCT||"Db_acct",width:100,dataIndex:'DB_ACCT',sortable:true}
              ,{ id:"CR_ACCT",header:this.resourceBundle.FieldLabel.CR_ACCT||"Cr_acct",width:100,dataIndex:'CR_ACCT',sortable:true}
              ,{ id:"DB_AMOUNT",header:this.resourceBundle.FieldLabel.DB_AMOUNT||"Dr amount",width:100,dataIndex:'DB_AMOUNT',sortable:true,align:'right'}
              ,{ id:"CR_AMOUNT",header:this.resourceBundle.FieldLabel.CR_AMOUNT||"Cr amount",width:100,dataIndex:'CR_AMOUNT',sortable:true,align:'right'}
              ,{ id:"CURRENCY",header:this.resourceBundle.FieldLabel.CURRENCY||"Currency",width:100,dataIndex:'CURRENCY',sortable:true}
              ,{ id:"XRATE",header:this.resourceBundle.FieldLabel.XRATE||"Xrate",width:100,dataIndex:'XRATE',hidden:true,sortable:true,align:'right'}
              ,{ id:"CREATEDON",header:this.resourceBundle.FieldLabel.CREATEDON||"CreatedOn",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:"IS_GENERATED",header:this.resourceBundle.FieldLabel.IS_GENERATED||"Is_generated",width:50,dataIndex:'IS_GENERATED',hidden:true,sortable:true}
              ,{ id:"ORIG_AMOUNT",header:this.resourceBundle.FieldLabel.ORIG_AMOUNT||"Orig_amount",width:100,dataIndex:'ORIG_AMOUNT',hidden:true,sortable:true,align:'right'}
              ,{ id:"ORIG_CURRENCY",header:this.resourceBundle.FieldLabel.ORIG_CURRENCY||"Orig_currency",width:100,dataIndex:'ORIG_CURRENCY',hidden:true,sortable:true}
          ]
          ,dataComponentName:"DC0042G"
          ,queryArraySize:-1
        });
       N21.DataComp.DC0042G.superclass.initComponent.apply(this, arguments);
     }
    ,onRender:function() {
       N21.DataComp.DC0042G.superclass.onRender.apply(this, arguments);
     }
    ,newDataRecord:function() {
       return new this.dataRecordMeta({_p_record_status:"insert"
              ,ID:""
              ,ACCDOC_ID:""
              ,ACCDOC_NAME:""
              ,CLIENT_ID:""
              ,NOTES:""
              ,DB_ACCT:""
              ,CR_ACCT:""
              ,DB_AMOUNT:""
              ,CR_AMOUNT:""
              ,CURRENCY:""
              ,XRATE:""
              ,CREATEDON:""
              ,CREATEDBY:""
              ,MODIFIEDON:""
              ,MODIFIEDBY:""
              ,IS_GENERATED:""
              ,ORIG_AMOUNT:""
              ,ORIG_CURRENCY:""});
     }
  });
  Ext.reg("DC0042G", N21.DataComp.DC0042G);
/** 
 * Data Component: DC0042F, Title: Accounting doc. line