dc0046.js

extjs+oracle+ erpcrm

/** 
 * Data Component: DC0046G, Title: Project issues
 */ 

  Ext.ns("N21.DataComp");
  N21.DataComp.DC0046G = Ext.extend(N21.Base.GridView, {
     dataRecordMeta:    Ext.data.Record.create([
          {name:"_p_record_status", type:"string"}
         ,{name:"PROJECT_ID", type:"float" }
         ,{name:"ID", type:"float" }
         ,{name:"PROJECT_NAME", type:"string" }
         ,{name:"TITLE", type:"string" }
         ,{name:"ISSUE_TYPE_CODE", type:"string" }
         ,{name:"SEVERITY_CODE", type:"string" }
         ,{name:"STATUS_CODE", type:"string" }
         ,{name:"PRIORITY_CODE", type:"string" }
         ,{name:"AFF_CMP_TYPE_CODE", type:"string" }
         ,{name:"AFF_CMP", type:"string" }
         ,{name:"AFF_PROJECT_RELEASE_CODE", type:"string" }
         ,{name:"EFFORT_UNIT", type:"string" }
         ,{name:"ESTIMATE_EFFORT", type:"float" }
         ,{name:"ACTUAL_EFFORT", type:"float" }
         ,{name:"IS_CLOSED", type:"string" }
         ,{name:"DESCRIPTION", 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:"ASSIGNED_TO", type:"string" }
         ,{name:"PLAN_STARTDATE", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"PLAN_ENDDATE", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"ACT_STARTDATE", type:"date",dateFormat:Ext.DATE_FORMAT }
         ,{name:"ACT_ENDDATE", type:"date",dateFormat:Ext.DATE_FORMAT }
    ])
     ,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:"DC0046_QRY_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.ID||"Id"})  );
         this.queryFields.add("PROJECT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"QRY_PROJECT_ID",id:"DC0046_QRY_PROJECT_ID",width:100,fieldLabel: this.resourceBundle.FieldLabel.PROJECT_ID||"Project_id"})  );
         this.queryFields.add("PROJECT_NAME", new N21.DataComp.LOV0033({xtype: "LOV0033",name:"QRY_PROJECT_NAME",id:"DC0046_QRY_PROJECT_NAME",width:100,fieldLabel: this.resourceBundle.FieldLabel.PROJECT_NAME||"Project"})  );
         this.queryFields.add("TITLE", new Ext.form.TextField ({xtype: "textfield",name:"QRY_TITLE",id:"DC0046_QRY_TITLE",width:100,fieldLabel: this.resourceBundle.FieldLabel.TITLE||"Title"})  );
         this.queryFields.add("ISSUE_TYPE_CODE", new N21.DataComp.LOV0031({xtype: "LOV0031",name:"QRY_ISSUE_TYPE_CODE",id:"DC0046_QRY_ISSUE_TYPE_CODE",width:100,fieldLabel: this.resourceBundle.FieldLabel.ISSUE_TYPE_CODE||"Type"})  );
         this.queryFields.add("SEVERITY_CODE", new N21.DataComp.LOV0030({xtype: "LOV0030",name:"QRY_SEVERITY_CODE",id:"DC0046_QRY_SEVERITY_CODE",width:100,fieldLabel: this.resourceBundle.FieldLabel.SEVERITY_CODE||"Severity"})  );
         this.queryFields.add("STATUS_CODE", new N21.DataComp.LOV0032({xtype: "LOV0032",name:"QRY_STATUS_CODE",id:"DC0046_QRY_STATUS_CODE",width:100,fieldLabel: this.resourceBundle.FieldLabel.STATUS_CODE||"Status"})  );
         this.queryFields.add("PRIORITY_CODE", new N21.DataComp.LOV0034({xtype: "LOV0034",name:"QRY_PRIORITY_CODE",id:"DC0046_QRY_PRIORITY_CODE",width:100,fieldLabel: this.resourceBundle.FieldLabel.PRIORITY_CODE||"Priority"})  );
         this.queryFields.add("IS_CLOSED", new Ext.form.ComboBox ({xtype: "combo",store:["N","Y"],name:"QRY_IS_CLOSED",id:"DC0046_QRY_IS_CLOSED",width:100,fieldLabel: this.resourceBundle.FieldLabel.IS_CLOSED||"Closed"})  );
         this.queryFields.add("ASSIGNED_TO", new Ext.form.TextField ({xtype: "textfield",name:"QRY_ASSIGNED_TO",id:"DC0046_QRY_ASSIGNED_TO",width:100,fieldLabel: this.resourceBundle.FieldLabel.ASSIGNED_TO||"Assigned to"})  );
  
       this.queryFieldsVisible = [  "PROJECT_NAME","TITLE","ISSUE_TYPE_CODE","SEVERITY_CODE","STATUS_CODE","PRIORITY_CODE","IS_CLOSED","ASSIGNED_TO" ];
       Ext.apply(this, {
           store: new Ext.data.GroupingStore({
               id:"storeDC0046"
              ,groupOnSort :false
              ,url:"frmMain.php?_p_action=fetch&_p_data_format=json&_p_form=DC0046"
              ,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:"PROJECT_ID",header:this.resourceBundle.FieldLabel.PROJECT_ID||"Project_id",width:100,dataIndex:'PROJECT_ID',hidden:true,sortable:true}
              ,{ id:"ID",header:this.resourceBundle.FieldLabel.ID||"Id",width:100,dataIndex:'ID',hidden:true,sortable:true}
              ,{ id:"PROJECT_NAME",header:this.resourceBundle.FieldLabel.PROJECT_NAME||"Project",width:120,dataIndex:'PROJECT_NAME',sortable:true}
              ,{ id:"TITLE",header:this.resourceBundle.FieldLabel.TITLE||"Title",width:250,dataIndex:'TITLE',sortable:true}
              ,{ id:"ISSUE_TYPE_CODE",header:this.resourceBundle.FieldLabel.ISSUE_TYPE_CODE||"Type",width:100,dataIndex:'ISSUE_TYPE_CODE',sortable:true}
              ,{ id:"SEVERITY_CODE",header:this.resourceBundle.FieldLabel.SEVERITY_CODE||"Severity",width:100,dataIndex:'SEVERITY_CODE',sortable:true}
              ,{ id:"STATUS_CODE",header:this.resourceBundle.FieldLabel.STATUS_CODE||"Status",width:100,dataIndex:'STATUS_CODE',sortable:true}
              ,{ id:"PRIORITY_CODE",header:this.resourceBundle.FieldLabel.PRIORITY_CODE||"Priority",width:100,dataIndex:'PRIORITY_CODE',sortable:true}
              ,{ id:"AFF_CMP_TYPE_CODE",header:this.resourceBundle.FieldLabel.AFF_CMP_TYPE_CODE||"Affected component type",width:100,dataIndex:'AFF_CMP_TYPE_CODE',hidden:true,sortable:true}
              ,{ id:"AFF_CMP",header:this.resourceBundle.FieldLabel.AFF_CMP||"Affected component",width:100,dataIndex:'AFF_CMP',hidden:true,sortable:true}
              ,{ id:"AFF_PROJECT_RELEASE_CODE",header:this.resourceBundle.FieldLabel.AFF_PROJECT_RELEASE_CODE||"Affected release",width:100,dataIndex:'AFF_PROJECT_RELEASE_CODE',hidden:true,sortable:true}
              ,{ id:"EFFORT_UNIT",header:this.resourceBundle.FieldLabel.EFFORT_UNIT||"Effort unit",width:100,dataIndex:'EFFORT_UNIT',hidden:true,sortable:true}
              ,{ id:"ESTIMATE_EFFORT",header:this.resourceBundle.FieldLabel.ESTIMATE_EFFORT||"Estimated effort",width:100,dataIndex:'ESTIMATE_EFFORT',hidden:true,sortable:true,align:'right'}
              ,{ id:"ACTUAL_EFFORT",header:this.resourceBundle.FieldLabel.ACTUAL_EFFORT||"Actual effort",width:100,dataIndex:'ACTUAL_EFFORT',hidden:true,sortable:true,align:'right'}
              ,{ id:"IS_CLOSED",header:this.resourceBundle.FieldLabel.IS_CLOSED||"Closed",width:50,dataIndex:'IS_CLOSED',sortable:true}
              ,{ id:"DESCRIPTION",header:this.resourceBundle.FieldLabel.DESCRIPTION||"",width:100,dataIndex:'DESCRIPTION',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}
              ,{ id:"ASSIGNED_TO",header:this.resourceBundle.FieldLabel.ASSIGNED_TO||"Assigned to",width:100,dataIndex:'ASSIGNED_TO',sortable:true}
              ,{ id:"PLAN_STARTDATE",header:this.resourceBundle.FieldLabel.PLAN_STARTDATE||"Planned start-date",width:100,dataIndex:'PLAN_STARTDATE',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"PLAN_ENDDATE",header:this.resourceBundle.FieldLabel.PLAN_ENDDATE||"Planned end-date",width:100,dataIndex:'PLAN_ENDDATE',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"ACT_STARTDATE",header:this.resourceBundle.FieldLabel.ACT_STARTDATE||"Actual start-date",width:100,dataIndex:'ACT_STARTDATE',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
              ,{ id:"ACT_ENDDATE",header:this.resourceBundle.FieldLabel.ACT_ENDDATE||"Actual end-date",width:100,dataIndex:'ACT_ENDDATE',hidden:true,sortable:true,renderer:Ext.util.Format.dateRenderer(Ext.DATE_FORMAT)}
          ]
          ,dataComponentName:"DC0046G"
          ,queryArraySize:20
          ,toolbarConfig:"STANDARD"
        });
       N21.DataComp.DC0046G.superclass.initComponent.apply(this, arguments);
     }
    ,onRender:function() {
       N21.DataComp.DC0046G.superclass.onRender.apply(this, arguments);
     }
    ,newDataRecord:function() {
       return new this.dataRecordMeta({_p_record_status:"insert"
              ,PROJECT_ID:""
              ,ID:""
              ,PROJECT_NAME:""
              ,TITLE:""
              ,ISSUE_TYPE_CODE:""
              ,SEVERITY_CODE:""
              ,STATUS_CODE:""
              ,PRIORITY_CODE:""
              ,AFF_CMP_TYPE_CODE:""
              ,AFF_CMP:""
              ,AFF_PROJECT_RELEASE_CODE:""
              ,EFFORT_UNIT:""
              ,ESTIMATE_EFFORT:""
              ,ACTUAL_EFFORT:""
              ,IS_CLOSED:""
              ,DESCRIPTION:""
              ,CREATEDON:""
              ,CREATEDBY:""
              ,MODIFIEDON:""
              ,MODIFIEDBY:""
              ,ASSIGNED_TO:""
              ,PLAN_STARTDATE:""
              ,PLAN_ENDDATE:""
              ,ACT_STARTDATE:""
              ,ACT_ENDDATE:""});
     }
  });
  Ext.reg("DC0046G", N21.DataComp.DC0046G);
/** 
 * Data Component: DC0046F, Title: Project issues
 */ 

  Ext.ns("N21.DataComp");
  N21.DataComp.DC0046F = Ext.extend(N21.Base.EditForm, {
     fields: new Ext.util.MixedCollection()
    ,dataRecordMeta : N21.DataComp.DC0046G.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("PROJECT_ID", new Ext.form.Hidden ({xtype: "hidden",name:"PROJECT_ID",id:"DC0046F_PROJECT_ID",dataIndex:"PROJECT_ID",width:100,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.PROJECT_ID||"Project_id",insert_allowed:true,update_allowed:true})   );
       this.fields.add("ID", new Ext.form.Hidden ({xtype: "hidden",name:"ID",id:"DC0046F_ID",dataIndex:"ID",width:100,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.ID||"Id",insert_allowed:true,update_allowed:true})   );
       this.fields.add("PROJECT_NAME", new N21.DataComp.LOV0033({xtype: "LOV0033",fieldMapping: [{column:"ID",field:"DC0046F_PROJECT_ID"}],selectOnFocus:true,name:"PROJECT_NAME",id:"DC0046F_PROJECT_NAME",dataIndex:"PROJECT_NAME",width:200,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.PROJECT_NAME||"Project",insert_allowed:true,update_allowed:true})   );
       this.fields.add("TITLE", new Ext.form.TextField ({xtype: "textfield",name:"TITLE",id:"DC0046F_TITLE",dataIndex:"TITLE",width:200,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.TITLE||"Title",insert_allowed:true,update_allowed:true})   );
       this.fields.add("ISSUE_TYPE_CODE", new N21.DataComp.LOV0031({xtype: "LOV0031",selectOnFocus:true,name:"ISSUE_TYPE_CODE",id:"DC0046F_ISSUE_TYPE_CODE",dataIndex:"ISSUE_TYPE_CODE",width:120,allowBlank:false,labelSeparator:":*" ,fieldLabel: this.resourceBundle.FieldLabel.ISSUE_TYPE_CODE||"Type",insert_allowed:true,update_allowed:true})   );
       this.fields.add("SEVERITY_CODE", new N21.DataComp.LOV0030({xtype: "LOV0030",selectOnFocus:true,name:"SEVERITY_CODE",id:"DC0046F_SEVERITY_CODE",dataIndex:"SEVERITY_CODE",width:120,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.SEVERITY_CODE||"Severity",insert_allowed:true,update_allowed:true})   );
       this.fields.add("STATUS_CODE", new N21.DataComp.LOV0032({xtype: "LOV0032",selectOnFocus:true,name:"STATUS_CODE",id:"DC0046F_STATUS_CODE",dataIndex:"STATUS_CODE",width:120,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.STATUS_CODE||"Status",insert_allowed:true,update_allowed:true})   );
       this.fields.add("PRIORITY_CODE", new N21.DataComp.LOV0034({xtype: "LOV0034",selectOnFocus:true,name:"PRIORITY_CODE",id:"DC0046F_PRIORITY_CODE",dataIndex:"PRIORITY_CODE",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.PRIORITY_CODE||"Priority",insert_allowed:true,update_allowed:true})   );
       this.fields.add("AFF_CMP_TYPE_CODE", new N21.DataComp.LOV0035({xtype: "LOV0035",paramMapping: [{param:"p_project_id",field:"DC0046F_PROJECT_ID"}],selectOnFocus:true,name:"AFF_CMP_TYPE_CODE",id:"DC0046F_AFF_CMP_TYPE_CODE",dataIndex:"AFF_CMP_TYPE_CODE",width:120,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.AFF_CMP_TYPE_CODE||"Affected component type",insert_allowed:true,update_allowed:true})   );
       this.fields.add("AFF_CMP", new Ext.form.TextField ({xtype: "textfield",name:"AFF_CMP",id:"DC0046F_AFF_CMP",dataIndex:"AFF_CMP",width:120,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.AFF_CMP||"Affected component",insert_allowed:true,update_allowed:true})   );
       this.fields.add("AFF_PROJECT_RELEASE_CODE", new Ext.form.TextField ({xtype: "textfield",name:"AFF_PROJECT_RELEASE_CODE",id:"DC0046F_AFF_PROJECT_RELEASE_CODE",dataIndex:"AFF_PROJECT_RELEASE_CODE",width:120,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.AFF_PROJECT_RELEASE_CODE||"Affected release",insert_allowed:true,update_allowed:true})   );
       this.fields.add("EFFORT_UNIT", new N21.DataComp.LOV0037({xtype: "LOV0037",selectOnFocus:true,name:"EFFORT_UNIT",id:"DC0046F_EFFORT_UNIT",dataIndex:"EFFORT_UNIT",width:120,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.EFFORT_UNIT||"Effort unit",insert_allowed:true,update_allowed:true})   );
       this.fields.add("ESTIMATE_EFFORT", new Ext.form.NumberField ({xtype: "numberfield",name:"ESTIMATE_EFFORT",id:"DC0046F_ESTIMATE_EFFORT",dataIndex:"ESTIMATE_EFFORT",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.ESTIMATE_EFFORT||"Estimated effort",insert_allowed:true,update_allowed:true,decimalPrecision:2,style: "text-align:right;"})   );
       this.fields.add("ACTUAL_EFFORT", new Ext.form.NumberField ({xtype: "numberfield",name:"ACTUAL_EFFORT",id:"DC0046F_ACTUAL_EFFORT",dataIndex:"ACTUAL_EFFORT",width:100,allowBlank:true,fieldLabel: this.resourceBundle.FieldLabel.ACTUAL_EFFORT||"Actual effort",disabled:true,decimalPrecision:2,style: "text-align:right;"})   );