dc0061.js

extjs+oracle+ erpcrm

       this.fields.add("CLIENT_CODE", new N21.DataComp.LOV0008({xtype: "LOV0008",fieldMapping: [{column:"ID",field:"DC0061F_CLIENT_ID"}],selectOnFocus:true,name:"CLIENT_CODE",id:"DC0061F_CLIENT_CODE",dataIndex:"CLIENT_CODE",width:100,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_CODE||"Client",insert_allowed:true,update_allowed:true})   );
       this.fields.add("NAME", new Ext.form.TextField ({xtype: "textfield",name:"NAME",id:"DC0061F_NAME",dataIndex:"NAME",width:200,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.NAME||"Name",insert_allowed:true,update_allowed:true})   );
       this.fields.add("ASSETGRP_NAME", new N21.DataComp.LOV0040({xtype: "LOV0040",fieldMapping: [{column:"ID",field:"DC0061F_ASSETGRP_ID"}],paramMapping: [{param:"p_client_id",field:"DC0061F_CLIENT_ID"}],selectOnFocus:true,name:"ASSETGRP_NAME",id:"DC0061F_ASSETGRP_NAME",dataIndex:"ASSETGRP_NAME",width:150,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.ASSETGRP_NAME||"Asset group",insert_allowed:true,update_allowed:true})   );
       this.fields.add("QUANTITY", new Ext.form.NumberField ({xtype: "numberfield",name:"QUANTITY",id:"DC0061F_QUANTITY",dataIndex:"QUANTITY",width:100,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.QUANTITY||"Quantity",insert_allowed:true,update_allowed:true,decimalPrecision:2,style: "text-align:right;"})   );
       this.fields.add("SERIAL_NO", new Ext.form.TextField ({xtype: "textfield",name:"SERIAL_NO",id:"DC0061F_SERIAL_NO",dataIndex:"SERIAL_NO",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.SERIAL_NO||"Serial_no",insert_allowed:true,update_allowed:true})   );
       this.fields.add("NOTES", new Ext.form.TextArea ({xtype: "textarea",name:"NOTES",id:"DC0061F_NOTES",dataIndex:"NOTES",width:200,height:40,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.NOTES||"Notes",insert_allowed:true,update_allowed:true})   );
       this.fields.add("IS_ACTIVE", new Ext.ux.form.XCheckbox ({xtype: "xcheckbox",name:"IS_ACTIVE",id:"DC0061F_IS_ACTIVE",dataIndex:"IS_ACTIVE",width:50,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.IS_ACTIVE||"Active",insert_allowed:true,update_allowed:true})   );
       this.fields.add("IS_DEPRECIATED", new Ext.ux.form.XCheckbox ({xtype: "xcheckbox",name:"IS_DEPRECIATED",id:"DC0061F_IS_DEPRECIATED",dataIndex:"IS_DEPRECIATED",width:50,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.IS_DEPRECIATED||"Depreciated",insert_allowed:true,update_allowed:true})   );
       this.fields.add("IS_DISPOSED", new Ext.ux.form.XCheckbox ({xtype: "xcheckbox",name:"IS_DISPOSED",id:"DC0061F_IS_DISPOSED",dataIndex:"IS_DISPOSED",width:50,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.IS_DISPOSED||"Disposed",insert_allowed:true,update_allowed:true})   );
       this.fields.add("IS_OWNED", new Ext.ux.form.XCheckbox ({xtype: "xcheckbox",name:"IS_OWNED",id:"DC0061F_IS_OWNED",dataIndex:"IS_OWNED",width:50,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.IS_OWNED||"Owned",insert_allowed:true,update_allowed:true})   );
       this.fields.add("IS_INPOSESSION", new Ext.ux.form.XCheckbox ({xtype: "xcheckbox",name:"IS_INPOSESSION",id:"DC0061F_IS_INPOSESSION",dataIndex:"IS_INPOSESSION",width:50,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.IS_INPOSESSION||"In-posession",insert_allowed:true,update_allowed:true})   );
       this.fields.add("LAST_MAINTENANCE_DATE", new Ext.form.DateField ({xtype: "datefield",name:"LAST_MAINTENANCE_DATE",id:"DC0061F_LAST_MAINTENANCE_DATE",dataIndex:"LAST_MAINTENANCE_DATE",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.LAST_MAINTENANCE_DATE||"Last_maintenance_date",insert_allowed:true,update_allowed:true,format:Ext.DATE_FORMAT})   );
       this.fields.add("NEXT_MAINTENENCE_DATE", new Ext.form.DateField ({xtype: "datefield",name:"NEXT_MAINTENENCE_DATE",id:"DC0061F_NEXT_MAINTENENCE_DATE",dataIndex:"NEXT_MAINTENENCE_DATE",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.NEXT_MAINTENENCE_DATE||"Next_maintenence_date",insert_allowed:true,update_allowed:true,format:Ext.DATE_FORMAT})   );
       this.fields.add("MAINTENANCE_PLAN_ID", new Ext.form.NumberField ({xtype: "numberfield",name:"MAINTENANCE_PLAN_ID",id:"DC0061F_MAINTENANCE_PLAN_ID",dataIndex:"MAINTENANCE_PLAN_ID",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.MAINTENANCE_PLAN_ID||"Maintenance_plan_id",insert_allowed:true,update_allowed:true,decimalPrecision:2,style: "text-align:right;"})   );
       this.fields.add("WITH_DEPRECIATION", new Ext.ux.form.XCheckbox ({xtype: "xcheckbox",name:"WITH_DEPRECIATION",id:"DC0061F_WITH_DEPRECIATION",dataIndex:"WITH_DEPRECIATION",width:50,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.WITH_DEPRECIATION||"With_depreciation",insert_allowed:true,update_allowed:true})   );
       this.fields.add("DEPREC_MONTHS", new Ext.form.NumberField ({xtype: "numberfield",name:"DEPREC_MONTHS",id:"DC0061F_DEPREC_MONTHS",dataIndex:"DEPREC_MONTHS",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.DEPREC_MONTHS||"Deprec. months",insert_allowed:true,update_allowed:true,decimalPrecision:2,style: "text-align:right;"})   );
       this.fields.add("DEPREC_BASE_VALUE", new Ext.form.NumberField ({xtype: "numberfield",name:"DEPREC_BASE_VALUE",id:"DC0061F_DEPREC_BASE_VALUE",dataIndex:"DEPREC_BASE_VALUE",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.DEPREC_BASE_VALUE||"Deprec base value",insert_allowed:true,update_allowed:true,decimalPrecision:2,style: "text-align:right;"})   );
       this.fields.add("DEPREC_MONTHS_REMAINED", new Ext.form.NumberField ({xtype: "numberfield",name:"DEPREC_MONTHS_REMAINED",id:"DC0061F_DEPREC_MONTHS_REMAINED",dataIndex:"DEPREC_MONTHS_REMAINED",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.DEPREC_MONTHS_REMAINED||"Deprec months remained",insert_allowed:true,update_allowed:true,decimalPrecision:2,style: "text-align:right;"})   );
       this.fields.add("BPARTNER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"BPARTNER_ID",id:"DC0061F_BPARTNER_ID",dataIndex:"BPARTNER_ID",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.BPARTNER_ID||"Bpartner_id",insert_allowed:true,update_allowed:true})   );
       this.fields.add("INUSE_BPARTNER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"INUSE_BPARTNER_ID",id:"DC0061F_INUSE_BPARTNER_ID",dataIndex:"INUSE_BPARTNER_ID",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.INUSE_BPARTNER_ID||"Inuse_bpartner_id",insert_allowed:true,update_allowed:true})   );
       this.fields.add("CREATEDON", new Ext.form.DateField ({xtype: "datefield",name:"CREATEDON",id:"DC0061F_CREATEDON",dataIndex:"CREATEDON",width:80,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:"DC0061F_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:"DC0061F_MODIFIEDON",dataIndex:"MODIFIEDON",width:80,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:"DC0061F_MODIFIEDBY",dataIndex:"MODIFIEDBY",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.MODIFIEDBY||"Modified by",disabled:true})   );

       this.layoutItems.add("Depreciation",
             { xtype:"fieldset", title:this.resourceBundle.FieldsetTitle.Depreciation||"Depreciation",autoHeight:true,collapsible: true,width:"90%",items:[ this.fields.get("WITH_DEPRECIATION"),this.fields.get("DEPREC_MONTHS"),this.fields.get("DEPREC_BASE_VALUE"),this.fields.get("DEPREC_MONTHS_REMAINED")]});
       this.layoutItems.add("Modified",
             { xtype:"fieldset", title:this.resourceBundle.FieldsetTitle.Modified||"Modified",autoHeight:true,collapsible: true,width:"90%",items:[ this.fields.get("CREATEDON"),this.fields.get("CREATEDBY"),this.fields.get("MODIFIEDON"),this.fields.get("MODIFIEDBY")]});
       this.layoutItems.add("C2",
             { layout:"form",columnWidth:.3, items:[ this.layoutItems.get("Depreciation"),this.layoutItems.get("Modified")]}); 
       this.layoutItems.add("Status",
             { xtype:"fieldset", title:this.resourceBundle.FieldsetTitle.Status||"Status",autoHeight:true,collapsible: true,width:"90%",items:[ this.fields.get("IS_ACTIVE"),this.fields.get("IS_DEPRECIATED"),this.fields.get("IS_DISPOSED"),this.fields.get("IS_OWNED"),this.fields.get("IS_INPOSESSION")]});
       this.layoutItems.add("Header",
             { xtype:"fieldset", title:this.resourceBundle.FieldsetTitle.Header||"Header",autoHeight:true,collapsible: true,width:"90%",items:[ this.fields.get("ID"),this.fields.get("CLIENT_ID"),this.fields.get("CLIORG_ID"),this.fields.get("PRODUCT_ID"),this.fields.get("ASSETGRP_ID"),this.fields.get("CLIENT_CODE"),this.fields.get("NAME"),this.fields.get("ASSETGRP_NAME"),this.fields.get("QUANTITY"),this.fields.get("SERIAL_NO"),this.fields.get("NOTES")]});
       this.layoutItems.add("C1",
             { layout:"form",columnWidth:.4, items:[ this.layoutItems.get("Header"),this.layoutItems.get("Status")]}); 


       Ext.apply(this, {
           items:[this.fields.get("_p_record_status"),this.layoutItems.get("C1"),this.layoutItems.get("C2")]
          ,border:false
          ,layout:"column"
          ,defaults:{labelWidth:110}
          ,frame:true
          ,width: "100%"
          ,dataComponentName:"DC0061F"
          ,firstFocusFieldName:"NAME"
          ,toolbarConfig:"STANDARD"
        });

        
       N21.DataComp.DC0061F.superclass.initComponent.apply(this, arguments);
     }

    ,onRender:function() {
       N21.DataComp.DC0061F.superclass.onRender.apply(this, arguments);
     }

    ,newDataRecord:function() {
       return new this.dataRecordMeta({_p_record_status:"insert"
              ,ASSETGRP_ID:""
              ,CLIENT_ID:""
              ,PRODUCT_ID:""
              ,CLIORG_ID:""
              ,ID:""
              ,CLIENT_CODE:""
              ,NAME:""
              ,ASSETGRP_NAME:""
              ,QUANTITY:""
              ,SERIAL_NO:""
              ,NOTES:""
              ,IS_ACTIVE:""
              ,IS_DEPRECIATED:""
              ,IS_DISPOSED:""
              ,IS_OWNED:""
              ,IS_INPOSESSION:""
              ,LAST_MAINTENANCE_DATE:""
              ,NEXT_MAINTENENCE_DATE:""
              ,MAINTENANCE_PLAN_ID:""
              ,WITH_DEPRECIATION:""
              ,DEPREC_MONTHS:""
              ,DEPREC_BASE_VALUE:""
              ,DEPREC_MONTHS_REMAINED:""
              ,BPARTNER_ID:""
              ,INUSE_BPARTNER_ID:""
              ,CREATEDON:""
              ,CREATEDBY:""
              ,MODIFIEDON:""
              ,MODIFIEDBY:""});
     }


  });
  Ext.reg("DC0061F", N21.DataComp.DC0061F);

/** 
 * DataControl: Grid with Edit Form
 * Code: DC0061
 * Title: Assets
 */ 

  Ext.ns("N21.DataComp");
  N21.DataComp.DC0061 = Ext.extend(N21.Base.GridEditForm, {

     initComponent:function() {
       Ext.apply(this, {
           autoScroll:false
          ,layout:"border"
          ,dataComponentName:"DC0061"
          ,masterName:"DC0061G"
          ,detailName:"DC0061F"
          ,mdLayout:"card"
          ,border: false
          ,items: [
              {
                xtype:"panel"
               ,layout:"card"
               ,id:"MDTab"
               ,region:"center"
               ,defaults:{layout:"fit"}
               ,activeItem:0
               ,tabPosition: "bottom"
               ,items: [{
                            xtype: "DC0061G"
                           ,id: "DC0061G"
                           ,height:350
                       },{
                           xtype:"DC0061F"
                          ,id:"DC0061F"
                          ,height:350
                          ,frame:true
                          ,autoScroll:true
                          ,layout:"form"
                       }]
             }

            ]
          ,tbar: new Array(
          new Ext.Toolbar.Button({  id:"tlb_FILTER"  ,xtype:"button" ,cls:"x-btn-icon" ,icon:"_static/icon/g_rec_src.png" ,tooltip:"Apply filter" ,handler: this.executeQuery ,scope :this})
          ,new Ext.Toolbar.Separator()
          ,new Ext.Toolbar.Button({  id:"tlb_SAVE"  ,xtype:"button" ,cls:"x-btn-icon" ,icon:"_static/icon/g_rec_commit.png" ,tooltip:"Save changes <Ctrl+S>" ,handler: this.commitForm ,scope :this})
          ,new Ext.Toolbar.Button({  id:"tlb_NEW"  ,xtype:"button" ,cls:"x-btn-icon" ,icon:"_static/icon/g_rec_new.png" ,tooltip:"Create new record <Ctrl+N>" ,handler: this.createNewRecord ,scope :this})
          ,new Ext.Toolbar.Button({  id:"tlb_DELETE"  ,xtype:"button" ,cls:"x-btn-icon" ,icon:"_static/icon/g_rec_del.png" ,tooltip:"Delete record <Ctrl+D>" ,handler: this.deleteRecord ,scope :this})
          ,new Ext.Toolbar.Separator()
          ,new Ext.Toolbar.Button({  id:"tlb_LIST_EDITOR_MODE"  ,xtype:"button" ,cls:"x-btn-icon" ,icon:"_static/icon/g_rec_upd.png" ,tooltip:"Editor<Enter>, List<Ctrl+Q>" ,handler: this.toggleEditMode ,scope :this})
          ,new Ext.Toolbar.Button({  id:"tlb_REFRESH_RECORD"  ,xtype:"button" ,cls:"x-btn-icon" ,icon:"_static/icon/g_rec_refresh.gif" ,tooltip:"Refresh record" ,handler: this.reloadRecord ,scope :this})
          ,new Ext.Toolbar.Separator()
          ,new Ext.Toolbar.Button({  id:"tlb_PREV_REC"  ,xtype:"button" ,cls:"x-btn-icon" ,icon:"_static/icon/f_rec_prev.gif" ,tooltip:"Previous record" ,handler: this.goToPrevRecord ,scope :this})
          ,new Ext.Toolbar.Button({  id:"tlb_NEXT_REC"  ,xtype:"button" ,cls:"x-btn-icon" ,icon:"_static/icon/f_rec_next.gif" ,tooltip:"Next record" ,handler: this.goToNextRecord ,scope :this})
          ,new Ext.Toolbar.Separator()
          ,new Ext.Toolbar.Button({  id:"tlb_PRINT"  ,xtype:"button" ,cls:"x-btn-icon" ,icon:"_static/icon/print.png" ,tooltip:"Print list" ,handler: this.exportList ,scope :this})
          )
        }); 

       N21.DataComp.DC0061.superclass.initComponent.apply(this, arguments);
     } 
  });
  Ext.reg("DC0061", N21.DataComp.DC0061);