dc0061.js

extjs+oracle+ erpcrm

/** 
 * Data Component: DC0061G, Title: Assets
 */ 

  Ext.ns("N21.DataComp");
  N21.DataComp.DC0061G = Ext.extend(N21.Base.GridView, {
     dataRecordMeta:    Ext.data.Record.create([
          {name:"_p_record_status", type:"string"}
         ,{name:"ASSETGRP_ID", type:"float" }
         ,{name:"CLIENT_ID", type:"float" }
         ,{name:"PRODUCT_ID", type:"float" }
         ,{name:"CLIORG_ID", type:"float" }
         ,{name:"ID", type:"float" }
         ,{name:"CLIENT_CODE", type:"string" }
         ,{name:"NAME", type:"string" }
         ,{name:"ASSETGRP_NAME", type:"string" }
         ,{name:"QUANTITY", type:"float" }
         ,{name:"SERIAL_NO", type:"string" }
         ,{name:"NOTES", type:"string" }
         ,{name:"IS_ACTIVE", type:"string" }
         ,{name:"IS_DEPRECIATED", type:"string" }
         ,{name:"IS_DISPOSED", type:"string" }
         ,{name:"IS_OWNED", type:"string" }
         ,{name:"IS_INPOSESSION", type:"string" }
         ,{name:"LAST_MAINTENANCE_DATE", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"NEXT_MAINTENENCE_DATE", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"MAINTENANCE_PLAN_ID", type:"float" }
         ,{name:"WITH_DEPRECIATION", type:"string" }
         ,{name:"DEPREC_MONTHS", type:"float" }
         ,{name:"DEPREC_BASE_VALUE", type:"float" }
         ,{name:"DEPREC_MONTHS_REMAINED", type:"float" }
         ,{name:"BPARTNER_ID", type:"float" }
         ,{name:"INUSE_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" }
    ])
     ,queryFields: new Ext.util.MixedCollection()
     ,queryFieldsVisible: new Array()
     ,queryPanelColCount:4 
    ,recordPk:[ "ID"]
    ,initComponent:function() {
       
         this.queryFields.add("ASSETGRP_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_ASSETGRP_ID",id:"DC0061_QRY_ASSETGRP_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.ASSETGRP_ID||"Assetgrp_id"})  );
         this.queryFields.add("PRODUCT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_PRODUCT_ID",id:"DC0061_QRY_PRODUCT_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.PRODUCT_ID||"Product_id"})  );
         this.queryFields.add("CLIENT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_CLIENT_ID",id:"DC0061_QRY_CLIENT_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_ID||"Client_id"})  );
         this.queryFields.add("ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_ID",id:"DC0061_QRY_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.ID||"Id"})  );
         this.queryFields.add("CLIENT_CODE", new N21.DataComp.LOV0008({xtype: "LOV0008",name:"QRY_CLIENT_CODE",id:"DC0061_QRY_CLIENT_CODE",width:100,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_CODE||"Client"})  );
         this.queryFields.add("NAME", new Ext.form.TextField ({xtype: "textfield",name:"QRY_NAME",id:"DC0061_QRY_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.NAME||"Name"})  );
         this.queryFields.add("ASSETGRP_NAME", new N21.DataComp.LOV0040({xtype: "LOV0040",name:"QRY_ASSETGRP_NAME",id:"DC0061_QRY_ASSETGRP_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.ASSETGRP_NAME||"Asset group"})  );
         this.queryFields.add("SERIAL_NO", new Ext.form.TextField ({xtype: "textfield",name:"QRY_SERIAL_NO",id:"DC0061_QRY_SERIAL_NO",width:100,fieldLabel: this.resourceBundle.FieldLabel.SERIAL_NO||"Serial_no"})  );
         this.queryFields.add("IS_ACTIVE", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_ACTIVE",id:"DC0061_QRY_IS_ACTIVE",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_ACTIVE||"Active"})  );
         this.queryFields.add("IS_DEPRECIATED", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_DEPRECIATED",id:"DC0061_QRY_IS_DEPRECIATED",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_DEPRECIATED||"Depreciated"})  );
         this.queryFields.add("IS_DISPOSED", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_DISPOSED",id:"DC0061_QRY_IS_DISPOSED",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_DISPOSED||"Disposed"})  );
         this.queryFields.add("IS_OWNED", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_OWNED",id:"DC0061_QRY_IS_OWNED",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_OWNED||"Owned"})  );
         this.queryFields.add("IS_INPOSESSION", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_INPOSESSION",id:"DC0061_QRY_IS_INPOSESSION",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_INPOSESSION||"In-posession"})  );
         this.queryFields.add("WITH_DEPRECIATION", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_WITH_DEPRECIATION",id:"DC0061_QRY_WITH_DEPRECIATION",width:100,fieldLabel: this.resourceBundle.FieldLabel.WITH_DEPRECIATION||"With_depreciation"})  );
         this.queryFields.add("DEPREC_MONTHS", new Ext.form.NumberField ({xtype: "numberfield",name:"QRY_DEPREC_MONTHS",id:"DC0061_QRY_DEPREC_MONTHS",width:100,fieldLabel: this.resourceBundle.FieldLabel.DEPREC_MONTHS||"Deprec. months",style: "text-align:right;"})  );
         this.queryFields.add("DEPREC_MONTHS_REMAINED", new Ext.form.NumberField ({xtype: "numberfield",name:"QRY_DEPREC_MONTHS_REMAINED",id:"DC0061_QRY_DEPREC_MONTHS_REMAINED",width:100,fieldLabel: this.resourceBundle.FieldLabel.DEPREC_MONTHS_REMAINED||"Deprec months remained",style: "text-align:right;"})  );
         this.queryFields.add("BPARTNER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_BPARTNER_ID",id:"DC0061_QRY_BPARTNER_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.BPARTNER_ID||"Bpartner_id"})  );
         this.queryFields.add("INUSE_BPARTNER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_INUSE_BPARTNER_ID",id:"DC0061_QRY_INUSE_BPARTNER_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.INUSE_BPARTNER_ID||"Inuse_bpartner_id"})  );
  
       this.queryFieldsVisible = [  "CLIENT_CODE","NAME","ASSETGRP_NAME","SERIAL_NO","IS_ACTIVE","IS_DEPRECIATED","IS_DISPOSED","IS_OWNED","IS_INPOSESSION","WITH_DEPRECIATION","DEPREC_MONTHS","DEPREC_MONTHS_REMAINED" ];
       Ext.apply(this, {
           store: new Ext.data.JsonStore({
               id:"storeDC0061"
              ,totalProperty:"totalCount"
              ,root:"records"
              ,url:"frmMain.php?_p_action=fetch&_p_data_format=json&_p_form=DC0061"
              ,remoteSort :true
              ,fields:this.dataRecordMeta
           })
          ,columns: [new Ext.grid.RowNumberer(),
               { id:"ASSETGRP_ID",header:this.resourceBundle.FieldLabel.ASSETGRP_ID||"Assetgrp_id",width:100,dataIndex:'ASSETGRP_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:"PRODUCT_ID",header:this.resourceBundle.FieldLabel.PRODUCT_ID||"Product_id",width:100,dataIndex:'PRODUCT_ID',hidden:true,sortable:true}
              ,{ id:"CLIORG_ID",header:this.resourceBundle.FieldLabel.CLIORG_ID||"Cliorg_id",width:100,dataIndex:'CLIORG_ID',hidden:true,sortable:true}
              ,{ id:"ID",header:this.resourceBundle.FieldLabel.ID||"Id",width:100,dataIndex:'ID',hidden:true,sortable:true}
              ,{ id:"CLIENT_CODE",header:this.resourceBundle.FieldLabel.CLIENT_CODE||"Client",width:100,dataIndex:'CLIENT_CODE',sortable:true}
              ,{ id:"NAME",header:this.resourceBundle.FieldLabel.NAME||"Name",width:200,dataIndex:'NAME',sortable:true}
              ,{ id:"ASSETGRP_NAME",header:this.resourceBundle.FieldLabel.ASSETGRP_NAME||"Asset group",width:100,dataIndex:'ASSETGRP_NAME',sortable:true}
              ,{ id:"QUANTITY",header:this.resourceBundle.FieldLabel.QUANTITY||"Quantity",width:100,dataIndex:'QUANTITY',sortable:true,align:'right'}
              ,{ id:"SERIAL_NO",header:this.resourceBundle.FieldLabel.SERIAL_NO||"Serial_no",width:100,dataIndex:'SERIAL_NO',sortable:true}
              ,{ id:"NOTES",header:this.resourceBundle.FieldLabel.NOTES||"Notes",width:100,dataIndex:'NOTES',hidden:true,sortable:true}
              ,{ id:"IS_ACTIVE",header:this.resourceBundle.FieldLabel.IS_ACTIVE||"Active",width:50,dataIndex:'IS_ACTIVE',sortable:true}
              ,{ id:"IS_DEPRECIATED",header:this.resourceBundle.FieldLabel.IS_DEPRECIATED||"Depreciated",width:50,dataIndex:'IS_DEPRECIATED',hidden:true,sortable:true}
              ,{ id:"IS_DISPOSED",header:this.resourceBundle.FieldLabel.IS_DISPOSED||"Disposed",width:50,dataIndex:'IS_DISPOSED',hidden:true,sortable:true}
              ,{ id:"IS_OWNED",header:this.resourceBundle.FieldLabel.IS_OWNED||"Owned",width:50,dataIndex:'IS_OWNED',hidden:true,sortable:true}
              ,{ id:"IS_INPOSESSION",header:this.resourceBundle.FieldLabel.IS_INPOSESSION||"In-posession",width:50,dataIndex:'IS_INPOSESSION',hidden:true,sortable:true}
              ,{ id:"LAST_MAINTENANCE_DATE",header:this.resourceBundle.FieldLabel.LAST_MAINTENANCE_DATE||"Last_maintenance_date",width:100,dataIndex:'LAST_MAINTENANCE_DATE',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"NEXT_MAINTENENCE_DATE",header:this.resourceBundle.FieldLabel.NEXT_MAINTENENCE_DATE||"Next_maintenence_date",width:100,dataIndex:'NEXT_MAINTENENCE_DATE',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"MAINTENANCE_PLAN_ID",header:this.resourceBundle.FieldLabel.MAINTENANCE_PLAN_ID||"Maintenance_plan_id",width:100,dataIndex:'MAINTENANCE_PLAN_ID',hidden:true,sortable:true,align:'right'}
              ,{ id:"WITH_DEPRECIATION",header:this.resourceBundle.FieldLabel.WITH_DEPRECIATION||"With_depreciation",width:50,dataIndex:'WITH_DEPRECIATION',hidden:true,sortable:true}
              ,{ id:"DEPREC_MONTHS",header:this.resourceBundle.FieldLabel.DEPREC_MONTHS||"Deprec. months",width:100,dataIndex:'DEPREC_MONTHS',sortable:true,align:'right'}
              ,{ id:"DEPREC_BASE_VALUE",header:this.resourceBundle.FieldLabel.DEPREC_BASE_VALUE||"Deprec base value",width:100,dataIndex:'DEPREC_BASE_VALUE',hidden:true,sortable:true,align:'right'}
              ,{ id:"DEPREC_MONTHS_REMAINED",header:this.resourceBundle.FieldLabel.DEPREC_MONTHS_REMAINED||"Deprec months remained",width:100,dataIndex:'DEPREC_MONTHS_REMAINED',sortable:true,align:'right'}
              ,{ id:"BPARTNER_ID",header:this.resourceBundle.FieldLabel.BPARTNER_ID||"Bpartner_id",width:100,dataIndex:'BPARTNER_ID',hidden:true,sortable:true}
              ,{ id:"INUSE_BPARTNER_ID",header:this.resourceBundle.FieldLabel.INUSE_BPARTNER_ID||"Inuse_bpartner_id",width:100,dataIndex:'INUSE_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}
          ]
          ,dataComponentName:"DC0061G"
          ,queryArraySize:20
          ,toolbarConfig:"STANDARD"
        });
       N21.DataComp.DC0061G.superclass.initComponent.apply(this, arguments);
     }
    ,onRender:function() {
       N21.DataComp.DC0061G.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("DC0061G", N21.DataComp.DC0061G);
/** 
 * Data Component: DC0061F, Title: Assets
 */ 

  Ext.ns("N21.DataComp");
  N21.DataComp.DC0061F = Ext.extend(N21.Base.EditForm, {
     fields: new Ext.util.MixedCollection()
    ,dataRecordMeta : N21.DataComp.DC0061G.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("ASSETGRP_ID", new Ext.form.Hidden ({xtype: "hidden",name:"ASSETGRP_ID",id:"DC0061F_ASSETGRP_ID",dataIndex:"ASSETGRP_ID",width:100,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.ASSETGRP_ID||"Assetgrp_id",insert_allowed:true,update_allowed:true})   );
       this.fields.add("CLIENT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"CLIENT_ID",id:"DC0061F_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("PRODUCT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"PRODUCT_ID",id:"DC0061F_PRODUCT_ID",dataIndex:"PRODUCT_ID",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.PRODUCT_ID||"Product_id",insert_allowed:true,update_allowed:true})   );
       this.fields.add("CLIORG_ID", new Ext.form.Hidden ({xtype: "hidden",name:"CLIORG_ID",id:"DC0061F_CLIORG_ID",dataIndex:"CLIORG_ID",width:100,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.CLIORG_ID||"Cliorg_id",insert_allowed:true,update_allowed:true})   );
       this.fields.add("ID", new Ext.form.Hidden ({xtype: "hidden",name:"ID",id:"DC0061F_ID",dataIndex:"ID",width:100,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.ID||"Id",insert_allowed:true,update_allowed:true})   );