function build_emergency_row($id)
{
$db_functions_obj = new DbFunctions();
$helper_obj = new Helper();
$emergency = $db_functions_obj->get_emergency_by_id($id);
$class = $helper_obj->table_row_class($i);
$output = "<tr class='{$class}' id='emergency_{$emergency->id}'>\n <td>" . $emergency->id . "</td>\n <td>" . $emergency->name . "</td>\n <td>" . $emergency->phone . "</td>\n <td>" . $emergency->country_name . "</td>\n <td><a href='javascript:void(0);' onclick='openEditEmergencyPopup({$emergency->id})'>" . $helper_obj->t("Edit") . "</a></td>\n <td><a href='javascript:void(0);' onclick='deleteEmergency({$emergency->id})'>\n " . $helper_obj->t("Delete") . "\n </a>\n </td>\n </tr>";
return $output;
}
function build_pgrate_row($pgrate_id)
{
$db_functions_obj = new DbFunctions();
$helper_obj = new Helper();
$pgrate = $db_functions_obj->get_pgrate_by_id($pgrate_id);
$class = $helper_obj->table_row_class($i);
$output = "<tr class='{$class}' id='pgrate_{$pgrate_id}'>\n <td>" . $pgrate['id'] . "</td>\n <td>" . $pgrate['name'] . "</td>\n <td><a href='javascript:void(0);' onclick='openEditPgratePopup(" . $pgrate['id'] . ")'>" . $helper_obj->t("Edit") . "</a></td>\n <td><a href='javascript:void(0);' onclick='deletePgrate(" . $pgrate['id'] . ")'>\n " . $helper_obj->t("Delete") . "</div>\n </a>\n </td>\n </tr>";
return $output;
}
function build_hitd_row($id)
{
$db_functions_obj = new DbFunctions();
$helper_obj = new Helper();
$hitd = $db_functions_obj->get_hitd_by_id($id);
$class = $helper_obj->table_row_class($i);
$output = "<tr class='{$class}' id='happened_{$hitd->id}'>\n <td>" . $hitd->id . "</td>\n <td>" . $hitd->date . "</td>\n <td>" . $hitd->body . "</td>\n <td><a href='javascript:void(0);' onclick='openEditHitdPopup({$hitd->id})'>" . $helper_obj->t("Edit") . "</a></td>\n <td><a href='javascript:void(0);' onclick='deleteHitd({$hitd->id})'>\n " . $helper_obj->t("Delete") . "\n </a>\n </td>\n </tr>";
return $output;
}
function build_zodiac_row($id)
{
$db_functions_obj = new DbFunctions();
$helper_obj = new Helper();
$zodiac = $db_functions_obj->get_zodiac_by_id($id);
$class = $helper_obj->table_row_class($i);
$output = "<tr class='{$class}' id='zodiac_{$zodiac->id}'>\n <td>" . $zodiac->id . "</td>\n <td>" . $zodiac->name . "</td>\n <td>" . $zodiac->body . "</td>\n <td><a href='javascript:void(0);' onclick='openEditZodiacPopup({$zodiac->id})'>" . $helper_obj->t("Edit") . "</a></td>\n <td><a href='javascript:void(0);' onclick='deleteZodiac({$zodiac->id})'>\n " . $helper_obj->t("Delete") . "\n </a>\n </td>\n </tr>";
return $output;
}
function get_all_videos($cid)
{
$db_functions_obj = new DbFunctions();
$helper_obj = new Helper();
$videos = $db_functions_obj->get_all_videos($cid);
$output = "<table id='add_video_table' style='font-size: 12px' class='table table-hover table-nomargin table-bordered'>\n <tr>\n <th>" . $helper_obj->t("ID") . "</th>\n <th>" . $helper_obj->t("Title") . "</th>\n <th>" . $helper_obj->t("Description") . "</th>\n <th>" . $helper_obj->t("Image1") . "</th>\n <th>" . $helper_obj->t("Image2") . "</th>\n <th>" . $helper_obj->t("Image3") . "</th>\n <th>" . $helper_obj->t("Image4") . "</th>\n <th>" . $helper_obj->t("Screenshot") . "</th> \n <th>" . $helper_obj->t("Uploaded date") . "</th>\n <th>" . $helper_obj->t("Published date") . "</th>\n <th>" . $helper_obj->t("Category") . "</th>\n <th>" . $helper_obj->t("Video") . "</th> \n <th>" . $helper_obj->t("PG rate") . "</th> \n <th>" . $helper_obj->t("Views") . "</th> \n <th>" . $helper_obj->t("Featured") . "</th>\n <th>" . $helper_obj->t("Premium") . "</th> \n <th>" . $helper_obj->t("Added By") . "</th> \n <th>" . $helper_obj->t("Edit") . "</th>\n <th>" . $helper_obj->t("Delete") . "</th>\n </tr>";
foreach ($videos as $key => $data) {
$class = $helper_obj->table_row_class($i);
$output .= "<tr id='vid_{$data->id}'>\n <td>" . $data->id . "</td>\n <td>" . $data->title . "</td>\n <td>" . $data->description . "</td>\n <td>" . $data->image1 . "</td>\n <td>" . $data->image2 . "</td>\n <td>" . $data->image3 . "</td>\n <td>" . $data->image4 . "</td>\n <td>" . $data->screenshot . "</td>\n <td>" . date(DATE_FORMAT, $data->upload_date) . "</td> \n <td>" . date(DATE_FORMAT, $data->published_date) . "</td> \n <td>" . $data->cat_name . "</td>\n <td>" . $data->url . "</td>\n <td>" . $data->pgrate_name . "</td>\n <td>" . $data->views . "</td>\n <td>" . $data->featured . "</td>\n <td>" . $data->premium . "</td> \n <td>" . $data->added_by . "</td> \n <td><a href='javascript:void(0);' onclick='openEditVideoPopup({$data->id})'>" . $helper_obj->t("Edit") . "</a></td>\n <td><a href='javascript:void(0);' onclick='deleteVideo({$data->id})'>" . $helper_obj->t("Delete") . "</a></td>\n </tr>";
}
return $output;
}
function get_all_clients()
{
$db_functions_obj = new DbFunctions();
$helper_obj = new Helper();
$clients = $db_functions_obj->get_all_clients();
$output = "<table id='add_client_table' class='table table-hover table-nomargin table-bordered'>\n <tr>\n <th>" . $helper_obj->t("ID") . "</th>\n <th>" . $helper_obj->t("Name") . "</th>\n <th>" . $helper_obj->t("Logo") . "</th>\n <th>" . $helper_obj->t("pem") . "</th>\n <th>" . $helper_obj->t("api") . "</th>\n <th>" . $helper_obj->t("Status") . "</th>\n <th>" . $helper_obj->t("Date Added") . "</th>\n <th>" . $helper_obj->t("Added By") . "</th> \n <th>" . $helper_obj->t("Date Updated") . "</th>\n <th>" . $helper_obj->t("Updated By") . "</th> \n <th>" . $helper_obj->t("Edit") . "</th>\n <th>" . $helper_obj->t("Delete") . "</th>\n </tr>";
foreach ($clients as $key => $client) {
$class = $helper_obj->table_row_class($i);
$output .= "<tr class='{$class}' id='client_{$client['id']}'>\n <td>" . $client['id'] . "</td>\n <td>" . $client['name'] . "</td>\n <td>" . $client['logo'] . "</td>\n <td>" . $client['pem'] . "</td>\n <td>" . $client['api'] . "</td>\n <td><div id='client_status_{$client['id']}'>" . ($client['status'] == 1 ? $helper_obj->t("Active") : $helper_obj->t("Deactive")) . "</div></td>\n <td>" . date(DATE_FORMAT, $client['date_added']) . "</td>\n <td>" . $client['added_by'] . "</td>\n <td>" . ($client['date_updated'] != "" ? date(DATE_FORMAT, $client['date_updated']) : "") . "</td>\n <td>" . $client['updated_by'] . "</td>\n <td><a href='javascript:void(0);' onclick='openEditClientPopup({$client['id']})'>" . $helper_obj->t("Edit") . "</a></td>\n <td><a href='javascript:void(0);' onclick='activeDeactiveClient({$client['id']})'>\n <div id='deactive_{$client['id']}'>" . ($client['status'] == 1 ? $helper_obj->t("Deactivate") : $helper_obj->t("Activate")) . "</div>\n </a>\n </td>\n </tr>";
}
$output .= "</table>";
return $output;
}
function get_all_users($cid = 1)
{
$db_functions_obj = new DbFunctions();
$helper_obj = new Helper();
global $user;
$uid = $user['id'];
$users = $db_functions_obj->get_all_users($uid, $cid);
$output = "<table id='add_user_table' class='table table-hover table-nomargin table-bordered'>\n <tr>\n <th>" . $helper_obj->t("ID") . "</th>\n <th>" . $helper_obj->t("Username") . "</th>\n <th>" . $helper_obj->t("Your email") . "</th>\n <th>" . $helper_obj->t("Phone") . "</th>\n <th>" . $helper_obj->t("Role") . "</th>\n <th>" . $helper_obj->t("Country") . "</th>\n <th>" . $helper_obj->t("Operator") . "</th>\n <th>" . $helper_obj->t("Client") . "</th>\n <th>" . $helper_obj->t("Status") . "</th>\n <th>" . $helper_obj->t("Date Added") . "</th> \n <th>" . $helper_obj->t("Edit") . "</th>\n <th>" . $helper_obj->t("Delete") . "</th>\n </tr>";
foreach ($users as $key => $value) {
$class = $helper_obj->table_row_class($i);
$output .= "<tr class='{$class}' id='user_{$value['id']}'>\n <td>" . $value['id'] . "</td>\n <td>" . $value['username'] . "</td>\n <td>" . $value['email'] . "</td>\n <td>" . $value['phone'] . "</td>\n <td>" . $value['role_name'] . "</td>\n <td>" . $value['country_name'] . "</td>\n <td>" . $value['operator_name'] . "</td>\n <td>" . $value['client_name'] . "</td>\n <td><div id='user_status_{$value['id']}'>" . ($value['status'] == 1 ? $helper_obj->t("Active") : $helper_obj->t("Deactive")) . "</div></td>\n <td>" . date(DATE_FORMAT, $value['date_added']) . "</td> \n <td><a href='javascript:void(0);' onclick='openEditUserPopup({$value['id']})'>" . $helper_obj->t("Edit") . "</a></td>\n <td><a href='javascript:void(0);' onclick='activeDeactiveUser({$value['id']})'>\n <div id='deactive_{$value['id']}'>" . ($value['status'] == 1 ? $helper_obj->t("Deactivate") : $helper_obj->t("Activate")) . "</div>\n </a>\n </td>\n </tr>";
}
$output .= "</table>";
return $output;
}
function build_source_row($id)
{
$db_functions_obj = new DbFunctions();
$helper_obj = new Helper();
$category = $db_functions_obj->get_source_by_id($id);
$class = $helper_obj->table_row_class($i);
$output = "<tr class='{$class}' id='category_{$category['id']}'>\n <td>" . $category['id'] . "</td>\n <td>" . $category['name'] . "</td>\n <td>" . $category['link'] . "</td>\n </tr>";
return $output;
}
function build_tag_row($id)
{
$db_functions_obj = new DbFunctions();
$helper_obj = new Helper();
$tag = $db_functions_obj->get_tag_by_id($id);
$class = $helper_obj->table_row_class($i);
$output = "<tr class='{$class}' id='tag_{$tag->id}'>\n <td>" . $tag['id'] . "</td>\n <td>" . $tag['name'] . "</td> \n <td><img src='" . TAGS_THUMBNAIL_IMAGES_PATH . $tag['image'] . "' width='70' /></td> \n <td><a href='javascript:void(0);' onclick='openEditTagPopup({$tag['id']})'>" . $helper_obj->t("Edit") . "</a></td>\n <td><a href='javascript:void(0);' onclick='deleteTag({$tag['id']})'>\n " . $helper_obj->t("Delete") . "</div>\n </a>\n </td>\n </tr>";
return $output;
}
function search_news($word)
{
global $base_path;
$helper_obj = new Helper();
$output = "";
if ($helper_obj->user_is_logged_in() && $helper_obj->check_role(CLIENT_ROLE_ID)) {
$db_function_obj = new DbFunctions();
$word = urldecode($word);
if (mb_strlen($word, "UTF-8") > 5) {
$search_results = $db_function_obj->search_news($word);
//$output .= '<script src="js/plugins/ckeditor/ckeditor.js"></script>';
$output .= "<table id='add_article_html_table' style='font-size: 10px' class='table table-hover table-nomargin table-bordered'>\n <tr>\n <th>" . $helper_obj->t("ID") . "</th>\n <th>" . $helper_obj->t("Title") . "</th> \n <th>" . $helper_obj->t("Image") . "</th> \n <th>" . $helper_obj->t("Added By") . "</th> \n <th>" . $helper_obj->t("Date Added") . "</th> \n <th>" . $helper_obj->t("Edit") . "</th>\n <th>" . $helper_obj->t("Delete") . "</th>\n </tr>";
foreach ($search_results as $data) {
$class = $helper_obj->table_row_class($i);
$output .= "<tr id='article_{$data['id']}'>\n <td>" . $data['id'] . "</td>\n <td>" . $data['title'] . "</td> \n <td>" . $data['image'] . "</td> \n <td>" . $data['added_by'] . "</td> \n <td>" . date(DATE_FORMAT, $data['date_added']) . "</td> \n <td><a href='javascript:void(0);' onclick='openEditHtmlArticlePopup({$data['id']})'>" . $helper_obj->t("Edit") . "</a></td>\n <td><a href='javascript:void(0);' onclick='deleteHtmlArticle({$data['id']})'>" . $helper_obj->t("Delete") . "</a></td>\n </tr>";
}
} else {
echo '<tr><td><b>يجب ادخال كلمة اكتر من 5 احرف</b></td></tr>';
}
$output .= "</table>";
}
echo $output;
exit;
}
function build_operator_row($operator_id)
{
$db_functions_obj = new DbFunctions();
$helper_obj = new Helper();
$operator = $db_functions_obj->get_operator_by_id($operator_id);
$class = $helper_obj->table_row_class($i);
$output = "<tr class='{$class}' id='operator_{$operator_id}'>\n <td>" . $operator['id'] . "</td>\n <td>" . $operator['name'] . "</td>\n <td>" . $operator['country_name'] . "</td>\n <td>" . $operator['paid_shortcode'] . "</td>\n <td>" . $operator['free_shortcode'] . "</td>\n <td>" . $operator['type'] . "</td>\n <td><a href='javascript:void(0);' onclick='openEditOperatorPopup(" . $operator['id'] . ")'>" . $helper_obj->t("Edit") . "</a></td>\n <td><a href='javascript:void(0);' onclick='deleteOperator(" . $operator['id'] . ")'>\n " . $helper_obj->t("Delete") . "</div>\n </a>\n </td>\n </tr>";
return $output;
}
function get_country_category_rss_source()
{
$db_functions_obj = new DbFunctions();
$helper_obj = new Helper();
$country_category_rss = $db_functions_obj->get_country_category_rss_source();
$output = "";
$output = "<table id='add_country_category_rss_source_table' style='font-size: 10px' class='table table-hover table-nomargin table-bordered'>\n <tr>\n <th>" . $helper_obj->t("ID") . "</th>\n <th>" . $helper_obj->t("Country") . "</th> \n <th>" . $helper_obj->t("Category") . "</th> \n <th>" . $helper_obj->t("RSS Source") . "</th>\n <th>" . $helper_obj->t("Delete") . "</th>\n </tr>";
foreach ($country_category_rss as $key => $data) {
$class = $helper_obj->table_row_class($i);
$output .= "<tr id='rss_{$data->id}'>\n <td>" . $data->id . "</td>\n <td>" . $data->country_name . "</td> \n <td>" . $data->category_name . "</td> \n <td>" . $data->source_name . "</td> \n <td><a href='javascript:void(0);' onclick='deleteCountryCategoryRssSource({$data->id})'>" . $helper_obj->t("Delete") . "</a></td>\n </tr>";
}
return $output;
}
/**
* @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;
}
function get_all_articles($aid)
{
$db_functions_obj = new DbFunctions();
$helper_obj = new Helper();
$articles = $db_functions_obj->get_all_articles($aid);
$output = "<table id='add_article_table' style='font-size: 10px' class='table table-hover table-nomargin table-bordered'>\n <tr>\n <th>" . $helper_obj->t("ID") . "</th>\n <th>" . $helper_obj->t("Title") . "</th> \n <th>" . $helper_obj->t("Text1") . "</th>\n <th>" . $helper_obj->t("Text2") . "</th>\n <th>" . $helper_obj->t("Text3") . "</th>\n <th>" . $helper_obj->t("Image1") . "</th>\n <th>" . $helper_obj->t("Image2") . "</th>\n <th>" . $helper_obj->t("Image3") . "</th>\n <th>" . $helper_obj->t("Image4") . "</th>\n <th>" . $helper_obj->t("Image5") . "</th>\n <th>" . $helper_obj->t("Video1") . "</th>\n <th>" . $helper_obj->t("Video2") . "</th> \n <th>" . $helper_obj->t("Uploaded date") . "</th> \n <th>" . $helper_obj->t("Category") . "</th>\n <th>" . $helper_obj->t("PG rate") . "</th> \n <th>" . $helper_obj->t("Views") . "</th> \n <th>" . $helper_obj->t("Added By") . "</th> \n <th>" . $helper_obj->t("Edit") . "</th>\n <th>" . $helper_obj->t("Delete") . "</th>\n </tr>";
foreach ($articles as $key => $data) {
$class = $helper_obj->table_row_class($i);
$output .= "<tr id='article_{$data->id}'>\n <td>" . $data->id . "</td>\n <td>" . $data->title . "</td> \n <td>" . $data->text1 . "</td>\n <td>" . $data->text2 . "</td>\n <td>" . $data->text3 . "</td>\n <td>" . $data->image1 . "</td>\n <td>" . $data->image2 . "</td>\n <td>" . $data->image3 . "</td>\n <td>" . $data->image4 . "</td>\n <td>" . $data->image5 . "</td>\n <td>" . $data->video1 . "</td>\n <td>" . $data->video2 . "</td> \n <td>" . date(DATE_FORMAT, $data->uploaded_date) . "</td> \n <td>" . $data->cat_name . "</td> \n <td>" . $data->pgrate_name . "</td>\n <td>" . $data->views . "</td> \n <td>" . $data->added_by . "</td> \n <td><a href='javascript:void(0);' onclick='openEditArticlePopup({$data->id})'>" . $helper_obj->t("Edit") . "</a></td>\n <td><a href='javascript:void(0);' onclick='deleteArticle({$data->id})'>" . $helper_obj->t("Delete") . "</a></td>\n </tr>";
}
return $output;
}
