Project

General

Profile

Download (895 Bytes)

Bug #483 » auto_Load_Cost_Center.txt

M Azid Wahyudi, 11/04/2021 03:37 PM

 
1 
penambahan CostCenter di field OnInitExtensions:
2 
'[id=PDSWFTRAVELCOSTCostCostType]':{change:function(){mapToTypeTravel();CostCenter();}
3 

    		
  

  

    
      4
    
    
      
penambahan function di field OnMethodExtensions:


    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
function CostCenter(){var body=MinovaUtil.WORKFLOW.getViewBodyWorkflow();var StartDate=body.down('[name=HeaderStartDate]').getValue();var empId=MinovaUtil.WORKFLOW.getEmpId();MinovaUtil.ExecuteParamQuery({ID:"TRAVELGETCOSTCENTER",empId:empId,stDate:StartDate},function(s){var result=Ext.decode(s.responseText);var dt=Ext.decode(Ext.decode(result.data));Ext.ComponentQuery.query('[id=PDSWFTRAVELCOSTCostCostCenter]')[0].setValue(dt[0].CostCenter);},function(f){});}


    		
  

  

    
      7
    
    
      

    		
  

  

    
      8
    
    
      
tambah Data di table [dbo].[PCMWFCUSTPARAM] :


    		
  

  

    
      9
    
    
      
ID : TRAVELGETCOSTCENTER


    		
  

  

    
      10
    
    
      

    		
  

  

    
      11
    
    
      
Value :


    		
  

  

    
      12
    
    
      
SELECT EmployeeID,StartDate,CostCenter FROM PHRPA0002 WHERE EmployeeID=@empId AND StartDate<=@stDate AND EndDate>=@stDate


    		
  

  

    
      13
    
    
      

    		
  

  

    
      14
    
    
      
CommandType : sqlstring


    		
  

  

    
      15
    
    
      
-


    		
  












  (3-3/3)