/** * @Author: Taymoor Qanadilou * @Date created: 26/05/2013 * @Description:uploaded images report * @Param: * none * @Updated History: * none */ function uploaded_images_report() { $db_function_obj = new DbFunctions(); $number_images_approved = $this->conn->db_fetch_object($db_function_obj->number_of_images_uplaoded_report()); $output_approved = array($number_images_approved->thisdayapproved, $number_images_approved->thisweekapproved, $number_images_approved->thismonthapproved, $number_images_approved->thisyearapproved); $output_removed = array($number_images_approved->thisdayremoved, $number_images_approved->thisweekremoved, $number_images_approved->thismonthremoved, $number_images_approved->thisyearremoved); $output_disapproved = array($number_images_approved->thisdaydis, $number_images_approved->thisweekdis, $number_images_approved->thismonthdis, $number_images_approved->thisyeardis); $output_stuck = array($number_images_approved->thisdayStuck, $number_images_approved->thisweekStuck, $number_images_approved->thismonthStuck, $number_images_approved->thisyearStuck); $output = " <div>\n <table border='1'>\n <tr><td colspan=5>Uploaded Images Report</td></tr>\n <tr>\n <th>options</th>\n <th>this day</th>\n <th>this week</th>\n <th>this month</th>\n <th>this year</th>\n </tr>\n <tr class='odd'>\n <td>Approved</td>"; foreach ($output_approved as $value) { $output .= "<td>{$value}</td>"; } $output .= "</tr>\n <tr class='even'>\n <td>Removed</td>"; foreach ($output_removed as $value) { $output .= "<td>{$value}</td>"; } $output .= "</tr>\n <tr class='odd'>\n <td>disapproved</td>"; foreach ($output_disapproved as $value) { $output .= "<td>{$value}</td>"; } $output .= "</tr>\n <tr class='even'>\n <td>Stuck</td>"; foreach ($output_stuck as $value) { $output .= "<td>{$value}</td>"; } $output .= "</tr>\n </table>"; $output .= " </div>"; return $output; }