|
在data的值改变事件写的方法调用后台
第一次工程ID值改变可以返回数据
第二次班组ID值改变没有返回数据
ksql也测试了没有问题,后台也没报错为什么会没有数据
SELECT PM_CONSTR_EnterPerson as PM_CONSTR_WageDeail ,0 as version ,PM_CONSTR_EnterPerson.fMasterID as fMasterID ,PM_CONSTR_EnterPerson.fName as fName ,ltrim(rtrim(PM_CONSTR_EnterPerson.fTimecardCode)) as fTimecardCode ,PM_CONSTR_EnterPerson.fIDCard as fIDCard ,PM_CONSTR_EnterPerson.fContractCode as fContractCode ,PM_CONSTR_EnterPerson.fProfession as fProfession ,PM_CONSTR_EnterPerson.fWage as fWage ,PM_CONSTR_EnterPerson.fWage as fNum ,PM_CONSTR_EnterPerson.fWage as fTotalAmount ,PM_CONSTR_EnterPerson.fWage as fBeginAmt ,PM_CONSTR_EnterPerson.fWage as fExpenditureAmount ,PM_CONSTR_EnterPerson.fWage as fActualPay ,PM_CONSTR_EnterPerson.fWage as fNoPaidAmount ,PM_CONSTR_EnterPerson.fWage as fExtendNum1 ,PM_CONSTR_EnterPerson.fWage as fExtendNum2 ,PM_CONSTR_EnterPerson.fWage as fExtendNum3 ,PM_CONSTR_EnterPerson.fWage as fExtendNum4 FROM PM_CONSTR_EnterPerson PM_CONSTR_EnterPerson OPTIONAL JOIN PM_CONSTR_EnterRegister PM_CONSTR_EnterRegister ON PM_CONSTR_EnterPerson.fMasterID = PM_CONSTR_EnterRegister OPTIONAL JOIN PM_CONSTR_EnterClass PM_CONSTR_EnterClass ON PM_CONSTR_EnterClass = PM_CONSTR_EnterPerson.fClassID where ((PM_CONSTR_EnterPerson.fIsDele=1 AND PM_CONSTR_EnterRegister.fYear <= 2015 AND PM_CONSTR_EnterRegister.fMonth<= 8) or (PM_CONSTR_EnterPerson.fIsDele=0 AND PM_CONSTR_EnterRegister.fYear <= 2015 AND PM_CONSTR_EnterRegister.fMonth<= 8 and substring(dateTimeToString(PM_CONSTR_EnterPerson.fQuitDateTime),1,7) >= '2015-08')) and PM_CONSTR_EnterClass.fClassID='68670B407BF34C1796B25897FAA45F40' and PM_CONSTR_EnterRegister.fStateID='2' and PM_CONSTR_EnterRegister.fProjectID='C3CAD3A7CECD4E8292CCEB62CB98E6C0'
|
-
|