I have created a web app that has a background process that updates a table in the database with numerical information. In the frontend, I plan on using CGridView to display information, which will include a calculated field. This page will be automatically refresh at set intervals by JS, displaying the latest information/calculations. What I am looking for is to have a sound file alert if one or more of the calculated fields meets a certain criteria.
I have done this before by handing coding the SQL query and (PHP) frontend (in my pre-framework days), and this was relatively simple as I simply had a boolean value set to TRUE if one of the rows matched the criteria and, further down the script, had PHP echo HTML to embed a sound file if the boolean was set to TRUE. However, I cant see a way to do this using CGridView.