且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SQL-在列值更改时添加边框底部

更新时间:2023-02-12 11:02:00

我在员工的经典报表中实现了相同的内容, 您可以检查url https://apex.oracle.com/pls/apex/f?p = 26095
用户ID:AMOL.PATIL@VYOMLABS.COM
通过:Unicorn @ 123

I have implemented same thing on classic report of employee , you can check url https://apex.oracle.com/pls/apex/f?p=26095 with
userid: AMOL.PATIL@VYOMLABS.COM
pass : Unicorn@123

执行JavaScript页面加载"部分中的代码:

Code in execute JavaScript page load section:

 var previous=null;
 var flag;
 $("td[headers=DEPTNO]").each(function() {


 if(previous==null){
      previous=$(this).text();
      flag='true';
  }

 if($(this).text()==null ||$(this).closest('tr').next().find('[headers="DEPTNO"]').text()==null) {

 }
 else
 { 
   if($(this).text()!=$(this).closest('tr').next().find('[headers="DEPTNO"]').text()) {
    previous=$(this).text();
    if(flag=='false')
      flag='true';
    else
    {
    flag='false';

    }
   }

  if(previous==$(this).text()&& flag=='false') {

    flag='true';

    $(this).closest('tr').after('<tr><td></td><td></td><td></td></tr>');
    $(this).closest('tr').next().addClass("myclass");
  }
}

 }); 

页面内联css部分的代码:

code for inline css section of page:

table.uReportStandard > tbody tr.myclass > td 
{
    background-color:red !important;
}

输出: 同样,您也可以通过更改标头来实现相同的功能.在您的情况下,它可能是FAMILYID,它将在此处替换DEPTNO. 请尝试此代码...

Output : Similarly you can also implement same thing by just changing headers.In your case it may be FAMILYID which will replace DEPTNO here. Please try this code ...