yui表格背景变红

来源:互联网 发布:java虚拟器 编辑:程序博客网 时间:2024/04/29 13:28
<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.EXTINFOIDWHERE TBASBASEINFO.BASEINFO_ID = TBAEXTINFO.BASEINFO_ID