/**
* @Author: Taymoor Qanadilou
* @Date created: 27/05/2013
* @Description: get all comments have bad words
* @Param:
* none
* @Updated History:
* none
*/
function disapproved_users_report()
{
$db_function_obj = new DbFunctions();
$user_obj = new User();
$helper_obj = new Helper();
$output = "";
//$approved_images = number_of_approved_images_report(STATUS_APPROVED);
$disapproved_images = $db_function_obj->number_of_approved_images_report(STATUS_DISAPPROVED);
//$approved_posts = number_of_approved_posts_report(STATUS_APPROVED);
$disapproved_posts = $db_function_obj->number_of_approved_posts_report(STATUS_DISAPPROVED);
while ($row = $this->conn->db_fetch_object($disapproved_images)) {
$disapproved[$row->uid]['count_disapproved_image'] = $row->count;
}
while ($row = $this->conn->db_fetch_object($disapproved_posts)) {
$disapproved[$row->uid]['count_disapproved_post'] = $row->count;
}
$output .= "<table border='1'>\n <tr><td colspan='3'>Disapproved Users Posts/Images</td></tr>\n <tr>\n <th>User Name</th>\n <th>Disapproved images</th>\n <th>Disapproved posts</th>\n </tr>\n ";
if (is_array($disapproved)) {
foreach ($disapproved as $key => $value) {
$class = $helper_obj->table_row_class($i);
$output .= "<tr class='{$class}'>\n <td>" . $user_obj->user_load($key)->name . "</td>\n <td>" . (@$value['count_disapproved_image'] + 0) . "</td>\n <td>" . (@$value["count_disapproved_post"] + 0) . "</td>\n </tr>";
}
}
$output .= "</table>";
return $output;
}
