<script language="javascript">
pirl.subscribe("postRenderEvent",function(){
var allRows = this._elTbody.rows;
for(var i=allRows.length-1; i>-1; i--) {
//alert(allRows[i].id);
var oRecord = this.getRecord(allRows[i].id);
var isExpired=oRecord.getData('isExpired');
if(isExpired=='1'){
$("#" + allRows[i].id).css("backgroundColor","yellow");
}else if(isExpired=='2'){
$("#" + allRows[i].id).css("backgroundColor","#FC8383");
}else{
}
}
});
</script>
sql
select
TBASBASEINFO.BASEINFO_ID as baseInfoId, TBASBASEINFO.GENDER gender,TBASBASEINFO.BIRTHDAY birthday,TBASBASEINFO.NAME as name,TBASBASEINFO.ID_CARD as idCard,
case
when (TBAEXTINFO.ENGAGEMENT_DATE + 3 year - 6 month)>=current date
then 0
when TBAEXTINFO.ENGAGEMENT_DATE+3 year <current date
then 2
else 1
end isExpired,
TBAEXTINFO.PERSON_NO as personNo,
TBAEXTINFO.CATEGORY as category, TBAEXTINFO.TYPES as types, TBAEXTINFO.ENGAGEMENT_DATE as engagementDate, TBAEXTINFO.DISPOSE dispose,
TBAEXTINFO.PROMOTION_DATE as promotionDate, TBAEXTINFO.CERTIFICATE_NO as certificateNo, TBASBASEINFO.AREA as area,
TBAEXTINFO.EXTINFO_ID as extInfoId, TBASBASEINFO.ORGANIZATION as organization,TBAEXTINFO.CERTIFICATION as cretification,TBAEXTINFO.POWERSTAR as powerstar,TBAEXTINFO.FLAG_FOOD_ACC as flagFoodAcc,TBAEXTINFO.FLAG_PERSON as flagInner,TBAEXTINFO.FOCUS focus,
V_YEARCOUNT.YEARCOUNT as yearCount,V_ALLCOUNT.ALLCOUNT as allCount, TBASBASEINFO.card
,TBASBASEINFO.USER_ID as userId,TBAEXTINFO.FLAG_AB flagAb
FROM TBASBASEINFO, TBAEXTINFO LEFT JOIN V_YEARCOUNT ON TBAEXTINFO.EXTINFO_ID=V_YEARCOUNT.EXTINFOID
LEFT JOIN V_ALLCOUNT ON TBAEXTINFO.EXTINFO_ID=V_ALLCOUNT.EXTINFOID
WHERE TBASBASEINFO.BASEINFO_ID = TBAEXTINFO.BASEINFO_ID