dc0026.js

extjs+oracle+ erpcrm

/** 
 * Data Component: DC0026G, Title: Received invoice
 */ 

  Ext.ns("N21.DataComp");
  N21.DataComp.DC0026G = 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:"CLIENT_NAME", type:"string" }
         ,{name:"RECEIVER_NAME", type:"string" }
         ,{name:"RECEIVER_ID", type:"float" }
         ,{name:"DOC_TYPE", type:"string" }
         ,{name:"DOC_NO", type:"string" }
         ,{name:"DOC_DATE", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"ISSUER_NAME", type:"string" }
         ,{name:"ISSUER_ID", type:"float" }
         ,{name:"ACCT", type:"string" }
         ,{name:"DOC_CURRENCY", type:"string" }
         ,{name:"TOTAL_AMOUNT", type:"float" }
         ,{name:"TOTAL_NET_AMOUNT", type:"float" }
         ,{name:"TOTAL_TAX_AMOUNT", type:"float" }
         ,{name:"DUE_DATE", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"IS_INSERTED", type:"string" }
         ,{name:"IS_PAYABLE", type:"string" }
         ,{name:"IS_PAYED", type:"string" }
         ,{name:"IS_POSTED", type:"string" }
         ,{name:"ACCDOC_NAME", type:"string" }
         ,{name:"ACCDOC_ID", type:"float" }
         ,{name:"REF_RINVOICE_ID", type:"float" }
         ,{name:"REF_RINVOICE_NAME", type:"string" }
         ,{name:"NOTES", type:"string" }
         ,{name:"INSERTEDBY", type:"string" }
         ,{name:"INSERTEDON", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{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:"POSTEDON", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"POSTEDBY", type:"string" }
    ])
     ,queryFields: new Ext.util.MixedCollection()
     ,queryFieldsVisible: new Array()
     ,queryPanelColCount:3 
    ,recordPk:[ "ID"]
    ,initComponent:function() {
       
         this.queryFields.add("ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_ID",id:"DC0026_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:"DC0026_QRY_CLIENT_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_ID||"Client_id"})  );
         this.queryFields.add("CLIENT_NAME", new N21.DataComp.LOV0008({xtype: "LOV0008",displayColumn: "CODE",name:"QRY_CLIENT_NAME",id:"DC0026_QRY_CLIENT_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_NAME||"Client"})  );
         this.queryFields.add("RECEIVER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_RECEIVER_ID",id:"DC0026_QRY_RECEIVER_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.RECEIVER_ID||"Receiver_id"})  );
         this.queryFields.add("DOC_TYPE", new N21.DataComp.LOV0015({xtype: "LOV0015",displayColumn: "CODE",name:"QRY_DOC_TYPE",id:"DC0026_QRY_DOC_TYPE",width:100,fieldLabel: this.resourceBundle.FieldLabel.DOC_TYPE||"Doc type"})  );
         this.queryFields.add("DOC_NO", new Ext.form.TextField ({xtype: "textfield",name:"QRY_DOC_NO",id:"DC0026_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:"DC0026_QRY_DOC_DATE",width:100,fieldLabel: this.resourceBundle.FieldLabel.DOC_DATE||"Date",format:Ext.DATE_FORMAT})  );
         this.queryFields.add("ISSUER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_ISSUER_ID",id:"DC0026_QRY_ISSUER_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.ISSUER_ID||"Issuer_id"})  );
         this.queryFields.add("ISSUER_NAME", new N21.DataComp.LOV0042({xtype: "LOV0042",displayColumn: "NAME",fieldMapping: [{column:"ID",field:"DC0026_QRY_ISSUER_ID"},{column:"ACCT",field:"DC0026_QRY_ACCT"}],selectOnFocus:true,name:"QRY_ISSUER_NAME",id:"DC0026_QRY_ISSUER_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.ISSUER_NAME||"Issuer"})  );
         this.queryFields.add("ACCDOC_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_ACCDOC_ID",id:"DC0026_QRY_ACCDOC_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.ACCDOC_ID||"Acc. doc id"})  );
         this.queryFields.add("REF_RINVOICE_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_REF_RINVOICE_ID",id:"DC0026_QRY_REF_RINVOICE_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.REF_RINVOICE_ID||"Ref_rinvoice_id"})  );
  
       this.queryFieldsVisible = [  "CLIENT_NAME","DOC_TYPE","DOC_NO","DOC_DATE","ISSUER_NAME" ];
       Ext.apply(this, {
           store: new Ext.data.GroupingStore({
               id:"storeDC0026"
              ,groupOnSort :false
              ,url:"frmMain.php?_p_action=fetch&_p_data_format=json&_p_form=DC0026"
              ,remoteSort :true
              ,sortInfo:{field: "", direction: ""}
              ,reader:new Ext.data.JsonReader({
                            totalProperty: "totalCount"  
                            ,root: "records"      
                        }, this.dataRecordMeta)
             ,groupField:""
           })
          ,view: new Ext.grid.GroupingView({
                    groupTextTpl: "{text}"
                })
          ,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:"CLIENT_NAME",header:this.resourceBundle.FieldLabel.CLIENT_NAME||"Client",width:100,dataIndex:'CLIENT_NAME',sortable:true}
              ,{ id:"RECEIVER_NAME",header:this.resourceBundle.FieldLabel.RECEIVER_NAME||"Receiver",width:100,dataIndex:'RECEIVER_NAME',hidden:true,sortable:true}
              ,{ id:"RECEIVER_ID",header:this.resourceBundle.FieldLabel.RECEIVER_ID||"Receiver_id",width:100,dataIndex:'RECEIVER_ID',hidden:true,sortable:true}
              ,{ id:"DOC_TYPE",header:this.resourceBundle.FieldLabel.DOC_TYPE||"Doc type",width:100,dataIndex:'DOC_TYPE',sortable:true}
              ,{ id:"DOC_NO",header:this.resourceBundle.FieldLabel.DOC_NO||"Doc 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:"ISSUER_NAME",header:this.resourceBundle.FieldLabel.ISSUER_NAME||"Issuer",width:100,dataIndex:'ISSUER_NAME',sortable:true}
              ,{ id:"ISSUER_ID",header:this.resourceBundle.FieldLabel.ISSUER_ID||"Issuer_id",width:100,dataIndex:'ISSUER_ID',hidden:true,sortable:true}
              ,{ id:"ACCT",header:this.resourceBundle.FieldLabel.ACCT||"Exp_acct",width:100,dataIndex:'ACCT',hidden:true,sortable:true}
              ,{ id:"DOC_CURRENCY",header:this.resourceBundle.FieldLabel.DOC_CURRENCY||"Currency",width:50,dataIndex:'DOC_CURRENCY',sortable:true}
              ,{ id:"TOTAL_AMOUNT",header:this.resourceBundle.FieldLabel.TOTAL_AMOUNT||"Total amount",width:100,dataIndex:'TOTAL_AMOUNT',sortable:true,align:'right',decimalPrecision:2}
              ,{ id:"TOTAL_NET_AMOUNT",header:this.resourceBundle.FieldLabel.TOTAL_NET_AMOUNT||"Net amount",width:100,dataIndex:'TOTAL_NET_AMOUNT',sortable:true,align:'right',decimalPrecision:2}
              ,{ id:"TOTAL_TAX_AMOUNT",header:this.resourceBundle.FieldLabel.TOTAL_TAX_AMOUNT||"Tax amount",width:100,dataIndex:'TOTAL_TAX_AMOUNT',sortable:true,align:'right',decimalPrecision:2}
              ,{ id:"DUE_DATE",header:this.resourceBundle.FieldLabel.DUE_DATE||"Due date",width:100,dataIndex:'DUE_DATE',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"IS_INSERTED",header:this.resourceBundle.FieldLabel.IS_INSERTED||"Registered",width:50,dataIndex:'IS_INSERTED',hidden:true,sortable:true}
              ,{ id:"IS_PAYABLE",header:this.resourceBundle.FieldLabel.IS_PAYABLE||"Is_payable",width:50,dataIndex:'IS_PAYABLE',hidden:true,sortable:true}
              ,{ id:"IS_PAYED",header:this.resourceBundle.FieldLabel.IS_PAYED||"Is_payed",width:50,dataIndex:'IS_PAYED',sortable:true}
              ,{ id:"IS_POSTED",header:this.resourceBundle.FieldLabel.IS_POSTED||"Is_posted",width:50,dataIndex:'IS_POSTED',sortable:true}
              ,{ id:"ACCDOC_NAME",header:this.resourceBundle.FieldLabel.ACCDOC_NAME||"Acc. doc",width:100,dataIndex:'ACCDOC_NAME',hidden:true,sortable:true}
              ,{ id:"ACCDOC_ID",header:this.resourceBundle.FieldLabel.ACCDOC_ID||"Acc. doc id",width:100,dataIndex:'ACCDOC_ID',hidden:true,sortable:true}
              ,{ id:"REF_RINVOICE_ID",header:this.resourceBundle.FieldLabel.REF_RINVOICE_ID||"Ref_rinvoice_id",width:100,dataIndex:'REF_RINVOICE_ID',hidden:true,sortable:true}
              ,{ id:"REF_RINVOICE_NAME",header:this.resourceBundle.FieldLabel.REF_RINVOICE_NAME||"Ref. doc.",width:100,dataIndex:'REF_RINVOICE_NAME',hidden:true,sortable:true}
              ,{ id:"NOTES",header:this.resourceBundle.FieldLabel.NOTES||"",width:100,dataIndex:'NOTES',hidden:true,sortable:true}
              ,{ id:"INSERTEDBY",header:this.resourceBundle.FieldLabel.INSERTEDBY||"Registered by",width:100,dataIndex:'INSERTEDBY',hidden:true,sortable:true}
              ,{ id:"INSERTEDON",header:this.resourceBundle.FieldLabel.INSERTEDON||"Registered on",width:100,dataIndex:'INSERTEDON',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ 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:"POSTEDON",header:this.resourceBundle.FieldLabel.POSTEDON||"Postedon",width:100,dataIndex:'POSTEDON',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"POSTEDBY",header:this.resourceBundle.FieldLabel.POSTEDBY||"Postedby",width:100,dataIndex:'POSTEDBY',hidden:true,sortable:true}
          ]
          ,dataComponentName:"DC0026G"
          ,queryArraySize:20
          ,toolbarConfig:"STANDARD"
        });
       N21.DataComp.DC0026G.superclass.initComponent.apply(this, arguments);
     }
    ,onRender:function() {
       N21.DataComp.DC0026G.superclass.onRender.apply(this, arguments);
     }
    ,newDataRecord:function() {
       return new this.dataRecordMeta({_p_record_status:"insert"
              ,ID:""
              ,CLIENT_ID:""