dc0016.js

extjs+oracle+ erpcrm

/** 
 * Data Component: DC0016G, Title: Parcel masterdata
 */ 

  Ext.ns("N21.DataComp");
  N21.DataComp.DC0016G = 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:"CODE", type:"string" }
         ,{name:"EXP_BPARTNER_ID", type:"float" }
         ,{name:"EXP_BPADRESS_ID", type:"float" }
         ,{name:"EXP_CITY_ID", type:"float" }
         ,{name:"EXP_NAME", type:"string" }
         ,{name:"EXP_COUNTRY", type:"string" }
         ,{name:"EXP_REGION", type:"string" }
         ,{name:"EXP_CITY", type:"string" }
         ,{name:"EXP_BPADRESS", type:"string" }
         ,{name:"EXP_ZIP", type:"string" }
         ,{name:"EXP_ADRESS_NOTE", type:"string" }
         ,{name:"DEST_BPADRESS_ID", type:"float" }
         ,{name:"DEST_BPARTNER_ID", type:"float" }
         ,{name:"DEST_CITY_ID", type:"float" }
         ,{name:"DEST_NAME", type:"string" }
         ,{name:"DEST_COUNTRY", type:"string" }
         ,{name:"DEST_REGION", type:"string" }
         ,{name:"DEST_CITY", type:"string" }
         ,{name:"DEST_BPADRESS", type:"string" }
         ,{name:"DEST_ZIP", type:"string" }
         ,{name:"DEST_ADRESS_NOTE", type:"string" }
         ,{name:"PICKEDUP", type:"string" }
         ,{name:"PICKUP_MODE", type:"string" }
         ,{name:"PICKUP_DATE", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"PICKUP_AGENT_CODE", type:"string" }
         ,{name:"DELIVERED", type:"string" }
         ,{name:"DELIVERY_MODE", type:"string" }
         ,{name:"DELIVERY_DATE", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"DELIVERY_AGENT_CODE", type:"string" }
         ,{name:"DELIVERED_TO_NAME", type:"string" }
         ,{name:"DELIVERED_TO_IDENT", type:"string" }
         ,{name:"REJECTED", type:"string" }
         ,{name:"REJECT_DATE", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"REJECT_REASON", type:"string" }
         ,{name:"REJECTED_BY_NAME", type:"string" }
         ,{name:"REJECTED_BY_IDENT", type:"string" }
         ,{name:"PACKAGE_COUNT", type:"float" }
         ,{name:"CONTENT", type:"string" }
         ,{name:"NOTES", type:"string" }
         ,{name:"DECLARED_VALUE", type:"float" }
         ,{name:"INSURED_VALUE", type:"float" }
         ,{name:"REF_PARCEL_ID", type:"float" }
         ,{name:"REF_PARCEL_REFERENCE_TYPE", 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" }
    ])
     ,queryFields: new Ext.util.MixedCollection()
     ,queryFieldsVisible: new Array()
     ,queryPanelColCount:4 
    ,recordPk:[ "ID"]
    ,initComponent:function() {
       
         this.queryFields.add("ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_ID",id:"DC0016_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:"DC0016_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:"DC0016_QRY_CLIENT_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.CLIENT_NAME||"Client"})  );
         this.queryFields.add("CODE", new Ext.form.TextField ({xtype: "textfield",name:"QRY_CODE",id:"DC0016_QRY_CODE",width:100,fieldLabel: this.resourceBundle.FieldLabel.CODE||"Code"})  );
         this.queryFields.add("EXP_BPARTNER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_EXP_BPARTNER_ID",id:"DC0016_QRY_EXP_BPARTNER_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.EXP_BPARTNER_ID||"Exp_bpartner_id"})  );
         this.queryFields.add("EXP_BPADRESS_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_EXP_BPADRESS_ID",id:"DC0016_QRY_EXP_BPADRESS_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.EXP_BPADRESS_ID||"Exp adress id"})  );
         this.queryFields.add("EXP_CITY_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_EXP_CITY_ID",id:"DC0016_QRY_EXP_CITY_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.EXP_CITY_ID||"Exp_city_id"})  );
         this.queryFields.add("EXP_NAME", new N21.DataComp.LOV0039({xtype: "LOV0039",fieldMapping: [{column:"ID",field:"DC0016_QRY_EXP_BPARTNER_ID"},{column:"COUNTRY_CODE",field:"DC0016_QRY_EXP_COUNTRY"},{column:"REGION_CODE",field:"DC0016_QRY_EXP_REGION"},{column:"CITY",field:"DC0016_QRY_EXP_CITY"},{column:"ADRESS",field:"DC0016_QRY_EXP_BPADRESS"}],selectOnFocus:true,name:"QRY_EXP_NAME",id:"DC0016_QRY_EXP_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.EXP_NAME||"Exp_name"})  );
         this.queryFields.add("EXP_COUNTRY", new N21.DataComp.LOV0006({xtype: "LOV0006",name:"QRY_EXP_COUNTRY",id:"DC0016_QRY_EXP_COUNTRY",width:100,fieldLabel: this.resourceBundle.FieldLabel.EXP_COUNTRY||"Country"})  );
         this.queryFields.add("EXP_REGION", new N21.DataComp.LOV0007({xtype: "LOV0007",name:"QRY_EXP_REGION",id:"DC0016_QRY_EXP_REGION",width:100,fieldLabel: this.resourceBundle.FieldLabel.EXP_REGION||"Region"})  );
         this.queryFields.add("EXP_CITY", new N21.DataComp.LOV0010({xtype: "LOV0010",name:"QRY_EXP_CITY",id:"DC0016_QRY_EXP_CITY",width:100,fieldLabel: this.resourceBundle.FieldLabel.EXP_CITY||"Exp_city"})  );
         this.queryFields.add("EXP_BPADRESS", new Ext.form.TextField ({xtype: "textfield",name:"QRY_EXP_BPADRESS",id:"DC0016_QRY_EXP_BPADRESS",width:100,fieldLabel: this.resourceBundle.FieldLabel.EXP_BPADRESS||"Adress"})  );
         this.queryFields.add("DEST_BPARTNER_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_DEST_BPARTNER_ID",id:"DC0016_QRY_DEST_BPARTNER_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.DEST_BPARTNER_ID||"Dest_bpartner_id"})  );
         this.queryFields.add("DEST_CITY_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_DEST_CITY_ID",id:"DC0016_QRY_DEST_CITY_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.DEST_CITY_ID||"Dest_city_id"})  );
         this.queryFields.add("DEST_BPADRESS_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_DEST_BPADRESS_ID",id:"DC0016_QRY_DEST_BPADRESS_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.DEST_BPADRESS_ID||"Dest adress id"})  );
         this.queryFields.add("DEST_NAME", new N21.DataComp.LOV0039({xtype: "LOV0039",fieldMapping: [{column:"ID",field:"DC0016_QRY_DEST_BPARTNER_ID"},{column:"COUNTRY_CODE",field:"DC0016_QRY_DEST_COUNTRY"},{column:"REGION_CODE",field:"DC0016_QRY_DEST_REGION"},{column:"CITY",field:"DC0016_QRY_DEST_CITY"},{column:"ADRESS",field:"DC0016_QRY_DEST_BPADRESS"}],selectOnFocus:true,name:"QRY_DEST_NAME",id:"DC0016_QRY_DEST_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.DEST_NAME||"Dest_name"})  );
         this.queryFields.add("DEST_COUNTRY", new N21.DataComp.LOV0006({xtype: "LOV0006",name:"QRY_DEST_COUNTRY",id:"DC0016_QRY_DEST_COUNTRY",width:100,fieldLabel: this.resourceBundle.FieldLabel.DEST_COUNTRY||"Dest_country"})  );
         this.queryFields.add("DEST_REGION", new N21.DataComp.LOV0007({xtype: "LOV0007",name:"QRY_DEST_REGION",id:"DC0016_QRY_DEST_REGION",width:100,fieldLabel: this.resourceBundle.FieldLabel.DEST_REGION||"Region"})  );
         this.queryFields.add("DEST_CITY", new N21.DataComp.LOV0010({xtype: "LOV0010",name:"QRY_DEST_CITY",id:"DC0016_QRY_DEST_CITY",width:100,fieldLabel: this.resourceBundle.FieldLabel.DEST_CITY||"City"})  );
         this.queryFields.add("PICKUP_DATE", new Ext.form.DateField ({xtype: "datefield",name:"QRY_PICKUP_DATE",id:"DC0016_QRY_PICKUP_DATE",width:100,fieldLabel: this.resourceBundle.FieldLabel.PICKUP_DATE||"Pickup_date",format:Ext.DATE_FORMAT})  );
         this.queryFields.add("PICKUP_AGENT_CODE", new N21.DataComp.LOV0016({xtype: "LOV0016",name:"QRY_PICKUP_AGENT_CODE",id:"DC0016_QRY_PICKUP_AGENT_CODE",width:100,fieldLabel: this.resourceBundle.FieldLabel.PICKUP_AGENT_CODE||"Pickup agent"})  );
         this.queryFields.add("DELIVERED", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_DELIVERED",id:"DC0016_QRY_DELIVERED",width:100,fieldLabel: this.resourceBundle.FieldLabel.DELIVERED||"Delivered"})  );
         this.queryFields.add("DELIVERY_DATE", new Ext.form.DateField ({xtype: "datefield",name:"QRY_DELIVERY_DATE",id:"DC0016_QRY_DELIVERY_DATE",width:100,fieldLabel: this.resourceBundle.FieldLabel.DELIVERY_DATE||"Delivery_date",format:Ext.DATE_FORMAT})  );
         this.queryFields.add("DELIVERY_AGENT_CODE", new N21.DataComp.LOV0016({xtype: "LOV0016",name:"QRY_DELIVERY_AGENT_CODE",id:"DC0016_QRY_DELIVERY_AGENT_CODE",width:100,fieldLabel: this.resourceBundle.FieldLabel.DELIVERY_AGENT_CODE||"Delivery agent"})  );
         this.queryFields.add("REJECTED", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_REJECTED",id:"DC0016_QRY_REJECTED",width:100,fieldLabel: this.resourceBundle.FieldLabel.REJECTED||"Rejected"})  );
  
       this.queryFieldsVisible = [  "CLIENT_NAME","CODE","EXP_NAME","EXP_COUNTRY","EXP_REGION","EXP_CITY","EXP_BPADRESS","DEST_NAME","DEST_COUNTRY","DEST_REGION","DEST_CITY","PICKUP_DATE","PICKUP_AGENT_CODE","DELIVERED","DELIVERY_DATE","DELIVERY_AGENT_CODE","REJECTED" ];
       Ext.apply(this, {
           store: new Ext.data.JsonStore({
               id:"storeDC0016"
              ,totalProperty:"totalCount"
              ,root:"records"
              ,url:"frmMain.php?_p_action=fetch&_p_data_format=json&_p_form=DC0016"
              ,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:"CLIENT_NAME",header:this.resourceBundle.FieldLabel.CLIENT_NAME||"Client",width:100,dataIndex:'CLIENT_NAME',hidden:true,sortable:true}
              ,{ id:"CODE",header:this.resourceBundle.FieldLabel.CODE||"Code",width:100,dataIndex:'CODE',sortable:true}
              ,{ id:"EXP_BPARTNER_ID",header:this.resourceBundle.FieldLabel.EXP_BPARTNER_ID||"Exp_bpartner_id",width:100,dataIndex:'EXP_BPARTNER_ID',hidden:true,sortable:true}
              ,{ id:"EXP_BPADRESS_ID",header:this.resourceBundle.FieldLabel.EXP_BPADRESS_ID||"Exp adress id",width:100,dataIndex:'EXP_BPADRESS_ID',hidden:true,sortable:true}
              ,{ id:"EXP_CITY_ID",header:this.resourceBundle.FieldLabel.EXP_CITY_ID||"Exp_city_id",width:100,dataIndex:'EXP_CITY_ID',hidden:true,sortable:true}
              ,{ id:"EXP_NAME",header:this.resourceBundle.FieldLabel.EXP_NAME||"Exp_name",width:200,dataIndex:'EXP_NAME',sortable:true}
              ,{ id:"EXP_COUNTRY",header:this.resourceBundle.FieldLabel.EXP_COUNTRY||"Country",width:100,dataIndex:'EXP_COUNTRY',hidden:true,sortable:true}
              ,{ id:"EXP_REGION",header:this.resourceBundle.FieldLabel.EXP_REGION||"Region",width:100,dataIndex:'EXP_REGION',hidden:true,sortable:true}
              ,{ id:"EXP_CITY",header:this.resourceBundle.FieldLabel.EXP_CITY||"Exp_city",width:100,dataIndex:'EXP_CITY',hidden:true,sortable:true}
              ,{ id:"EXP_BPADRESS",header:this.resourceBundle.FieldLabel.EXP_BPADRESS||"Adress",width:100,dataIndex:'EXP_BPADRESS',hidden:true,sortable:true}
              ,{ id:"EXP_ZIP",header:this.resourceBundle.FieldLabel.EXP_ZIP||"Exp_zip",width:100,dataIndex:'EXP_ZIP',hidden:true,sortable:true}
              ,{ id:"EXP_ADRESS_NOTE",header:this.resourceBundle.FieldLabel.EXP_ADRESS_NOTE||"Exp_adress_note",width:100,dataIndex:'EXP_ADRESS_NOTE',hidden:true,sortable:true}
              ,{ id:"DEST_BPADRESS_ID",header:this.resourceBundle.FieldLabel.DEST_BPADRESS_ID||"Dest adress id",width:100,dataIndex:'DEST_BPADRESS_ID',hidden:true,sortable:true}
              ,{ id:"DEST_BPARTNER_ID",header:this.resourceBundle.FieldLabel.DEST_BPARTNER_ID||"Dest_bpartner_id",width:100,dataIndex:'DEST_BPARTNER_ID',hidden:true,sortable:true}
              ,{ id:"DEST_CITY_ID",header:this.resourceBundle.FieldLabel.DEST_CITY_ID||"Dest_city_id",width:100,dataIndex:'DEST_CITY_ID',hidden:true,sortable:true}
              ,{ id:"DEST_NAME",header:this.resourceBundle.FieldLabel.DEST_NAME||"Dest_name",width:200,dataIndex:'DEST_NAME',sortable:true}
              ,{ id:"DEST_COUNTRY",header:this.resourceBundle.FieldLabel.DEST_COUNTRY||"Dest_country",width:100,dataIndex:'DEST_COUNTRY',hidden:true,sortable:true}
              ,{ id:"DEST_REGION",header:this.resourceBundle.FieldLabel.DEST_REGION||"Region",width:100,dataIndex:'DEST_REGION',sortable:true}
              ,{ id:"DEST_CITY",header:this.resourceBundle.FieldLabel.DEST_CITY||"City",width:100,dataIndex:'DEST_CITY',sortable:true}
              ,{ id:"DEST_BPADRESS",header:this.resourceBundle.FieldLabel.DEST_BPADRESS||"Dest_bpadress",width:100,dataIndex:'DEST_BPADRESS',hidden:true,sortable:true}
              ,{ id:"DEST_ZIP",header:this.resourceBundle.FieldLabel.DEST_ZIP||"Dest_zip",width:100,dataIndex:'DEST_ZIP',hidden:true,sortable:true}
              ,{ id:"DEST_ADRESS_NOTE",header:this.resourceBundle.FieldLabel.DEST_ADRESS_NOTE||"Dest_adress_note",width:100,dataIndex:'DEST_ADRESS_NOTE',hidden:true,sortable:true}
              ,{ id:"PICKEDUP",header:this.resourceBundle.FieldLabel.PICKEDUP||"Pickedup",width:50,dataIndex:'PICKEDUP',hidden:true,sortable:true}
              ,{ id:"PICKUP_MODE",header:this.resourceBundle.FieldLabel.PICKUP_MODE||"Pickup_mode",width:100,dataIndex:'PICKUP_MODE',hidden:true,sortable:true}
              ,{ id:"PICKUP_DATE",header:this.resourceBundle.FieldLabel.PICKUP_DATE||"Pickup_date",width:100,dataIndex:'PICKUP_DATE',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"PICKUP_AGENT_CODE",header:this.resourceBundle.FieldLabel.PICKUP_AGENT_CODE||"Pickup agent",width:100,dataIndex:'PICKUP_AGENT_CODE',hidden:true,sortable:true}
              ,{ id:"DELIVERED",header:this.resourceBundle.FieldLabel.DELIVERED||"Delivered",width:50,dataIndex:'DELIVERED',hidden:true,sortable:true}
              ,{ id:"DELIVERY_MODE",header:this.resourceBundle.FieldLabel.DELIVERY_MODE||"Delivery_mode",width:100,dataIndex:'DELIVERY_MODE',hidden:true,sortable:true}
              ,{ id:"DELIVERY_DATE",header:this.resourceBundle.FieldLabel.DELIVERY_DATE||"Delivery_date",width:100,dataIndex:'DELIVERY_DATE',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"DELIVERY_AGENT_CODE",header:this.resourceBundle.FieldLabel.DELIVERY_AGENT_CODE||"Delivery agent",width:100,dataIndex:'DELIVERY_AGENT_CODE',hidden:true,sortable:true}
              ,{ id:"DELIVERED_TO_NAME",header:this.resourceBundle.FieldLabel.DELIVERED_TO_NAME||"Deliv. to person",width:100,dataIndex:'DELIVERED_TO_NAME',hidden:true,sortable:true}
              ,{ id:"DELIVERED_TO_IDENT",header:this.resourceBundle.FieldLabel.DELIVERED_TO_IDENT||"Deliv. to pers. ident",width:100,dataIndex:'DELIVERED_TO_IDENT',hidden:true,sortable:true}
              ,{ id:"REJECTED",header:this.resourceBundle.FieldLabel.REJECTED||"Rejected",width:50,dataIndex:'REJECTED',hidden:true,sortable:true}
              ,{ id:"REJECT_DATE",header:this.resourceBundle.FieldLabel.REJECT_DATE||"Reject_date",width:100,dataIndex:'REJECT_DATE',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"REJECT_REASON",header:this.resourceBundle.FieldLabel.REJECT_REASON||"Reject_reason",width:100,dataIndex:'REJECT_REASON',hidden:true,sortable:true}
              ,{ id:"REJECTED_BY_NAME",header:this.resourceBundle.FieldLabel.REJECTED_BY_NAME||"Rejected_by_name",width:100,dataIndex:'REJECTED_BY_NAME',hidden:true,sortable:true}
              ,{ id:"REJECTED_BY_IDENT",header:this.resourceBundle.FieldLabel.REJECTED_BY_IDENT||"Rejected_by_ident",width:100,dataIndex:'REJECTED_BY_IDENT',hidden:true,sortable:true}
              ,{ id:"PACKAGE_COUNT",header:this.resourceBundle.FieldLabel.PACKAGE_COUNT||"Package count",width:100,dataIndex:'PACKAGE_COUNT',sortable:true,align:'right'}
              ,{ id:"CONTENT",header:this.resourceBundle.FieldLabel.CONTENT||"Content",width:100,dataIndex:'CONTENT',hidden:true,sortable:true}
              ,{ id:"NOTES",header:this.resourceBundle.FieldLabel.NOTES||"Notes",width:100,dataIndex:'NOTES',hidden:true,sortable:true}
              ,{ id:"DECLARED_VALUE",header:this.resourceBundle.FieldLabel.DECLARED_VALUE||"Declared_value",width:100,dataIndex:'DECLARED_VALUE',hidden:true,sortable:true,align:'right'}
              ,{ id:"INSURED_VALUE",header:this.resourceBundle.FieldLabel.INSURED_VALUE||"Insured_value",width:100,dataIndex:'INSURED_VALUE',hidden:true,sortable:true,align:'right'}
              ,{ id:"REF_PARCEL_ID",header:this.resourceBundle.FieldLabel.REF_PARCEL_ID||"Ref_parcel_id",width:100,dataIndex:'REF_PARCEL_ID',hidden:true,sortable:true,align:'right'}