PHP Helper::table_row_class方法代码示例

 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;
 }