Threshold by color queries

Scozara

ok, here's a hard question....

Lets say that we have a web based "dashboard" for viewing PBX call statistics. On this dashboard there are 2 cells.

The 1st cell contains a hardcoded Number. This number is an SLA (Service Level Agreement) total that the 2nd will be measured against.

The 2nd cell is the ACTUAL SLA number that is being pulled from the source (PBX switch)

This 2nd number is being updated daily in a MySQL DB and must change its colors (on the web dashboard) according to its relation to the SLA number in the 1st cell.

So in other words - If the 1st cell has an all the time hardcoded number of 50% and the 2nd cell has a dynamic number of 40% then the 2nd cells contents (the 40%) will display the font color as red indicating that this number falls below the 1st cell standard SLA number. If the same number is has changed by the next DB upload to say, 75% then it displays as green indicating that it is above the 1st cell standard SLA number.

This is a threshold type query. How do I retrieve the 2nd cells DB data and have it display on a web interface by color depending on the hardcoded number in the 1st cell ??

If you need a graphic representation I can come up with one..... lemme know!

Thanks for you help!

floR

Not sure if your main question is how to get it from the DB or how to colorize it...

If you want PHP to do the coloring, it has to know the hardcoded number, so you might want to define it as a global variable. You could then color the cell while building the page with a simple 'if' check.
If this is not possible, I would have Javascript do the coloring. You can build the page with PHP, send it to the client uncolored and have a little Javascript to check the contents of the cells with parseInt(cell1.innerText) and compare it to the contents of the second and rewrite the cell2.innerHTML to give it some color. Checking the cell contents like this is not a very elegant way, IMO. Perhaps I would try something like (this is pseudo code):

thepage.php

<script>
  SLA = 50;
  PBX = <? pbx.getPBX() ?>;
  if (PBX<SLA) {
      color = "red";
  } else {
      color = "green";
  }
  document.writeln('<table><tr>');
  document.writeln('<td>'+SLA+'</td>');
  document.writeln('<td><font color="'+color+'">'+PBX+'</font></td>');
  document.writeln('</tr></table>');
</script>