selectfpersonidfromT_HR_SCmpCalTablewhereFCalSchemeId='替换为计算规则ID'andFPeriodYear='替换为年'andFPeriodMonth='替换为月'andFCalTime='替换为次数'andfidnotin(SELECT"CMP_CTB".FIDAS"cmp_ctb.id"FROMT_BD_PersonHisAS"CMP_PERSON"LEFTJOINT_HR_SCMPCALTABLEAS"CMP_CTB"ON"CMP_CTB".FPersonID="CMP_PERSON".FhistoryRelateIDAND("CMP_CTB".FEndDate>="CMP_PERSON".FEFFDTand"CMP_PERSON".FLEFFDT>="CMP_CTB".FEndDate)LEFTJOINT_HR_EMPORGRELATIONAS"CMP_EMPORGRELATIOIN"ON"CMP_EMPORGRELATIOIN".FID="CMP_CTB".FEMPPOSORGRELATIONIDLEFTJOINT_HR_AFFAIRACTIONREASONAS"CMP_AFFAIRAR"ON"CMP_AFFAIRAR".FID="CMP_EMPORGRELATIOIN".FACTIONTYPEIDLEFTJOINT_ORG_PositionHISAS"CAL_POSITION"ON"CAL_POSITION".FhistoryRelateID="CMP_CTB".FPOSITIONIDAND("CAL_POSITION".FEFFDT<="CMP_CTB".FEndDateand"CAL_POSITION".FLEFFDT>="CMP_CTB".FEndDate)LEFTJOINT_ORG_ADMINHISAS"CAL_COSTBEAR"ON"CAL_COSTBEAR".FhistoryRelateID="CMP_CTB".FCOSTBEARORGIDAND("CAL_COSTBEAR".FEFFDT<="CMP_CTB".FEndDateand"CAL_COSTBEAR".FLEFFDT>="CMP_CTB".FEndDate)LEFTJOINT_HR_BDEMPLOYEETYPEAS"CMP_EMPLOYEETYPE"ON"CMP_EMPLOYEETYPE".FID="CMP_CTB".FEMPLOYEETYPEIDLEFTJOINT_ORG_ADMINHISAS"CAL_ADMINORG"ON"CAL_ADMINORG".FhistoryRelateID="CMP_CTB".FADMINORGUNITIDAND("CAL_ADMINORG".FEFFDT<="CMP_CTB".FEndDateand"CAL_ADMINORG".FLEFFDT>="CMP_CTB".FEndDate)LEFTJOINT_ORG_ADMINHISAS"CAL_CMPCALORG"ON"CAL_CMPCALORG".FhistoryRelateID="CMP_CTB".FCMPCALORGIDAND("CAL_CMPCALORG".FEFFDT<="CMP_CTB".FEndDateand"CAL_CMPCALORG".FLEFFDT>="CMP_CTB".FEndDate)WHERE((("CMP_CTB".FAdminOrgUnitIDin(SELECTFOrgIDFROMT_PM_OrgRangeWHEREFUserID='替换为用户id'ANDFType=20)or"CMP_CTB".FCmpCalOrgIDin(SELECTFOrgIDFROMT_PM_OrgRangeWHEREFUserID='替换为用户id'ANDFType=20))and"CMP_CTB".FCalSchemeID='替换为计算规则id'and"CMP_CTB".FPeriodYear=2015and"CMP_CTB".FPeriodMonth=9and"CMP_CTB".FCalTime=3)AND(("CAL_ADMINORG".FLongNumber='替换为该用户最大权限的组织长编码'or"CAL_ADMINORG".FLongNumberlike'把01替换为该用户最大权限的组织长编码!%')or("CAL_CMPCALORG".FLongNumber='把01替换为该用户最大权限的组织长编码'or"CAL_CMPCALORG".FLongNumberlike'把01替换为该用户最大权限的组织长编码!%'))))
