dc0044.js

extjs+oracle+ erpcrm

/** 
 * Data Component: DC0044G, Title: Received invoice payments
 */ 

  Ext.ns("N21.DataComp");
  N21.DataComp.DC0044G = Ext.extend(N21.Base.GridView, {
     dataRecordMeta:    Ext.data.Record.create([
          {name:"_p_record_status", type:"string"}
         ,{name:"ID", type:"float" }
         ,{name:"CLIENT_ID", type:"float" }
         ,{name:"PAYDOCTYPE_CODE", type:"string" }
         ,{name:"DOC_NO", type:"string" }
         ,{name:"DOC_DATE", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"BPARTNER_FROM", type:"float" }
         ,{name:"BPARTNER_TO", type:"float" }
         ,{name:"IS_PAYABLE", type:"string" }
         ,{name:"IS_RECEIVABLE", type:"string" }
         ,{name:"AMOUNT", type:"float" }
         ,{name:"CURRENCY", type:"string" }
         ,{name:"NOTES", 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:"PAYMNT_ACCT", type:"string" }
         ,{name:"IS_INSERTED", type:"string" }
         ,{name:"IS_GENERATED", type:"string" }
         ,{name:"IS_APPROVED", type:"string" }
         ,{name:"IS_POSTED", type:"string" }
         ,{name:"ACCDOC_ID", type:"float" }
         ,{name:"IS_PREPAYMENT", type:"string" }
         ,{name:"PREPAY_ACCT", type:"string" }
         ,{name:"RINV_ID", type:"float" }
         ,{name:"IS_MULTI_PAYMENT", type:"string" }
         ,{name:"IINV_ID", type:"float" }
    ])
     ,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:"DC0044_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:"DC0044_QRY_CLIENT_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_ID||"Client_id"})  );
         this.queryFields.add("PAYDOCTYPE_CODE", new N21.DataComp.LOV0012({xtype: "LOV0012",name:"QRY_PAYDOCTYPE_CODE",id:"DC0044_QRY_PAYDOCTYPE_CODE",width:100,fieldLabel: this.resourceBundle.FieldLabel.PAYDOCTYPE_CODE||"Paydoctype_code"})  );
         this.queryFields.add("DOC_NO", new Ext.form.TextField ({xtype: "textfield",name:"QRY_DOC_NO",id:"DC0044_QRY_DOC_NO",width:100,fieldLabel: this.resourceBundle.FieldLabel.DOC_NO||"Doc_no"})  );
         this.queryFields.add("DOC_DATE", new Ext.form.DateField ({xtype: "datefield",name:"QRY_DOC_DATE",id:"DC0044_QRY_DOC_DATE",width:100,fieldLabel: this.resourceBundle.FieldLabel.DOC_DATE||"Doc_date",format:Ext.DATE_FORMAT})  );
         this.queryFields.add("BPARTNER_FROM", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_BPARTNER_FROM",id:"DC0044_QRY_BPARTNER_FROM",width:100,fieldLabel: this.resourceBundle.FieldLabel.BPARTNER_FROM||"Bpartner_from"})  );
         this.queryFields.add("BPARTNER_TO", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_BPARTNER_TO",id:"DC0044_QRY_BPARTNER_TO",width:100,fieldLabel: this.resourceBundle.FieldLabel.BPARTNER_TO||"Bpartner_to"})  );
         this.queryFields.add("IS_PAYABLE", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_PAYABLE",id:"DC0044_QRY_IS_PAYABLE",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_PAYABLE||"Is_payable"})  );
         this.queryFields.add("IS_RECEIVABLE", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_RECEIVABLE",id:"DC0044_QRY_IS_RECEIVABLE",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_RECEIVABLE||"Is_receivable"})  );
         this.queryFields.add("AMOUNT", new Ext.form.NumberField ({xtype: "numberfield",name:"QRY_AMOUNT",id:"DC0044_QRY_AMOUNT",width:100,fieldLabel: this.resourceBundle.FieldLabel.AMOUNT||"Amount",style: "text-align:right;"})  );
         this.queryFields.add("CURRENCY", new Ext.form.TextField ({xtype: "textfield",name:"QRY_CURRENCY",id:"DC0044_QRY_CURRENCY",width:100,fieldLabel: this.resourceBundle.FieldLabel.CURRENCY||"Currency"})  );
         this.queryFields.add("NOTES", new Ext.form.TextField ({xtype: "textfield",name:"QRY_NOTES",id:"DC0044_QRY_NOTES",width:100,fieldLabel: this.resourceBundle.FieldLabel.NOTES||"Notes"})  );
         this.queryFields.add("CREATEDON", new Ext.form.DateField ({xtype: "datefield",name:"QRY_CREATEDON",id:"DC0044_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:"DC0044_QRY_CREATEDBY",width:100,fieldLabel: this.resourceBundle.FieldLabel.CREATEDBY||"Createdby"})  );
         this.queryFields.add("MODIFIEDON", new Ext.form.DateField ({xtype: "datefield",name:"QRY_MODIFIEDON",id:"DC0044_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:"DC0044_QRY_MODIFIEDBY",width:100,fieldLabel: this.resourceBundle.FieldLabel.MODIFIEDBY||"Modifiedby"})  );
         this.queryFields.add("PAYMNT_ACCT", new N21.DataComp.LOV0025({xtype: "LOV0025",selectOnFocus:true,name:"QRY_PAYMNT_ACCT",id:"DC0044_QRY_PAYMNT_ACCT",width:100,fieldLabel: this.resourceBundle.FieldLabel.PAYMNT_ACCT||"Paymnt_acct"})  );
         this.queryFields.add("IS_INSERTED", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_INSERTED",id:"DC0044_QRY_IS_INSERTED",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_INSERTED||"Is_inserted"})  );
         this.queryFields.add("IS_GENERATED", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_GENERATED",id:"DC0044_QRY_IS_GENERATED",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_GENERATED||"Is_generated"})  );
         this.queryFields.add("IS_APPROVED", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_APPROVED",id:"DC0044_QRY_IS_APPROVED",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_APPROVED||"Is_approved"})  );
         this.queryFields.add("IS_POSTED", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_POSTED",id:"DC0044_QRY_IS_POSTED",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_POSTED||"Is_posted"})  );
         this.queryFields.add("ACCDOC_ID", new Ext.form.NumberField ({xtype: "numberfield",name:"QRY_ACCDOC_ID",id:"DC0044_QRY_ACCDOC_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.ACCDOC_ID||"Accdoc_id",style: "text-align:right;"})  );
         this.queryFields.add("IS_PREPAYMENT", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_PREPAYMENT",id:"DC0044_QRY_IS_PREPAYMENT",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_PREPAYMENT||"Is_prepayment"})  );
         this.queryFields.add("PREPAY_ACCT", new Ext.form.TextField ({xtype: "textfield",name:"QRY_PREPAY_ACCT",id:"DC0044_QRY_PREPAY_ACCT",width:100,fieldLabel: this.resourceBundle.FieldLabel.PREPAY_ACCT||"Prepay_acct"})  );
         this.queryFields.add("RINV_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_RINV_ID",id:"DC0044_QRY_RINV_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.RINV_ID||"Rinv_id"})  );
         this.queryFields.add("IS_MULTI_PAYMENT", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_MULTI_PAYMENT",id:"DC0044_QRY_IS_MULTI_PAYMENT",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_MULTI_PAYMENT||"Is_multi_payment"})  );
         this.queryFields.add("IINV_ID", new Ext.form.NumberField ({xtype: "numberfield",name:"QRY_IINV_ID",id:"DC0044_QRY_IINV_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.IINV_ID||"Iinv_id",style: "text-align:right;"})  );
  
       this.queryFieldsVisible = [  "PAYDOCTYPE_CODE","DOC_NO","DOC_DATE","AMOUNT","CURRENCY","NOTES","CREATEDON","CREATEDBY","MODIFIEDON","MODIFIEDBY","PAYMNT_ACCT","IS_INSERTED","IS_GENERATED","IS_APPROVED","IS_POSTED","ACCDOC_ID","IS_PREPAYMENT","PREPAY_ACCT","IINV_ID" ];
       Ext.apply(this, {
           store: new Ext.data.Store({
               id:"storeDC0044"
              ,reader: new Ext.data.XmlReader({totalRecords:"totalCount",record: "record"},this.dataRecordMeta)
              ,url:"frmMain.php?_p_action=fetch&_p_data_format=xml&_p_form=DC0044"
              ,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_ID",header:this.resourceBundle.FieldLabel.CLIENT_ID||"Client_id",width:100,dataIndex:'CLIENT_ID',hidden:true,sortable:true}
              ,{ id:"PAYDOCTYPE_CODE",header:this.resourceBundle.FieldLabel.PAYDOCTYPE_CODE||"Paydoctype_code",width:100,dataIndex:'PAYDOCTYPE_CODE',hidden:true,sortable:true}
              ,{ id:"DOC_NO",header:this.resourceBundle.FieldLabel.DOC_NO||"Doc_no",width:100,dataIndex:'DOC_NO',hidden:true,sortable:true}
              ,{ id:"DOC_DATE",header:this.resourceBundle.FieldLabel.DOC_DATE||"Doc_date",width:100,dataIndex:'DOC_DATE',sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"BPARTNER_FROM",header:this.resourceBundle.FieldLabel.BPARTNER_FROM||"Bpartner_from",width:100,dataIndex:'BPARTNER_FROM',hidden:true,sortable:true}
              ,{ id:"BPARTNER_TO",header:this.resourceBundle.FieldLabel.BPARTNER_TO||"Bpartner_to",width:100,dataIndex:'BPARTNER_TO',hidden:true,sortable:true}
              ,{ id:"IS_PAYABLE",header:this.resourceBundle.FieldLabel.IS_PAYABLE||"Is_payable",width:100,dataIndex:'IS_PAYABLE',hidden:true,sortable:true}
              ,{ id:"IS_RECEIVABLE",header:this.resourceBundle.FieldLabel.IS_RECEIVABLE||"Is_receivable",width:100,dataIndex:'IS_RECEIVABLE',hidden:true,sortable:true}
              ,{ id:"AMOUNT",header:this.resourceBundle.FieldLabel.AMOUNT||"Amount",width:100,dataIndex:'AMOUNT',sortable:true,align:'right'}
              ,{ id:"CURRENCY",header:this.resourceBundle.FieldLabel.CURRENCY||"Currency",width:100,dataIndex:'CURRENCY',hidden:true,sortable:true}
              ,{ id:"NOTES",header:this.resourceBundle.FieldLabel.NOTES||"Notes",width:100,dataIndex:'NOTES',hidden:true,sortable:true}
              ,{ 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:"PAYMNT_ACCT",header:this.resourceBundle.FieldLabel.PAYMNT_ACCT||"Paymnt_acct",width:100,dataIndex:'PAYMNT_ACCT',hidden:true,sortable:true}
              ,{ id:"IS_INSERTED",header:this.resourceBundle.FieldLabel.IS_INSERTED||"Is_inserted",width:50,dataIndex:'IS_INSERTED',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:"IS_APPROVED",header:this.resourceBundle.FieldLabel.IS_APPROVED||"Is_approved",width:50,dataIndex:'IS_APPROVED',hidden:true,sortable:true}
              ,{ id:"IS_POSTED",header:this.resourceBundle.FieldLabel.IS_POSTED||"Is_posted",width:50,dataIndex:'IS_POSTED',hidden:true,sortable:true}
              ,{ id:"ACCDOC_ID",header:this.resourceBundle.FieldLabel.ACCDOC_ID||"Accdoc_id",width:100,dataIndex:'ACCDOC_ID',hidden:true,sortable:true,align:'right'}
              ,{ id:"IS_PREPAYMENT",header:this.resourceBundle.FieldLabel.IS_PREPAYMENT||"Is_prepayment",width:50,dataIndex:'IS_PREPAYMENT',hidden:true,sortable:true}
              ,{ id:"PREPAY_ACCT",header:this.resourceBundle.FieldLabel.PREPAY_ACCT||"Prepay_acct",width:100,dataIndex:'PREPAY_ACCT',hidden:true,sortable:true}
              ,{ id:"RINV_ID",header:this.resourceBundle.FieldLabel.RINV_ID||"Rinv_id",width:100,dataIndex:'RINV_ID',hidden:true,sortable:true}
              ,{ id:"IS_MULTI_PAYMENT",header:this.resourceBundle.FieldLabel.IS_MULTI_PAYMENT||"Is_multi_payment",width:100,dataIndex:'IS_MULTI_PAYMENT',hidden:true,sortable:true}
              ,{ id:"IINV_ID",header:this.resourceBundle.FieldLabel.IINV_ID||"Iinv_id",width:100,dataIndex:'IINV_ID',hidden:true,sortable:true,align:'right'}
          ]
          ,dataComponentName:"DC0044G"
          ,queryArraySize:-1
        });
       N21.DataComp.DC0044G.superclass.initComponent.apply(this, arguments);
     }
    ,onRender:function() {
       N21.DataComp.DC0044G.superclass.onRender.apply(this, arguments);
     }
    ,newDataRecord:function() {
       return new this.dataRecordMeta({_p_record_status:"insert"
              ,ID:""
              ,CLIENT_ID:""
              ,PAYDOCTYPE_CODE:""
              ,DOC_NO:""
              ,DOC_DATE:""
              ,BPARTNER_FROM:""
              ,BPARTNER_TO:""
              ,IS_PAYABLE:""
              ,IS_RECEIVABLE:""
              ,AMOUNT:""
              ,CURRENCY:""
              ,NOTES:""
              ,CREATEDON:""
              ,CREATEDBY:""
              ,MODIFIEDON:""
              ,MODIFIEDBY:""
              ,PAYMNT_ACCT:""
              ,IS_INSERTED:""
              ,IS_GENERATED:""
              ,IS_APPROVED:""
              ,IS_POSTED:""
              ,ACCDOC_ID:""
              ,IS_PREPAYMENT:""
              ,PREPAY_ACCT:""
              ,RINV_ID:""
              ,IS_MULTI_PAYMENT:""
              ,IINV_ID:""});
     }
  });