DBStatic\DBStaticNews

Complexity

Total Complexity

6

Size/Duplication

Total Lines	67
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	4

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	db_news_update_set()	0	13	1
A	db_news_insert_set()	0	9	1
A	db_news_delete_by_id()	0	8	1
A	db_news_with_survey_select_by_id()	0	7	1
A	db_news_list_get_by_query()	0	15	2

<?php

namespace DBStatic;
use classSupernova;
use mysqli_result;
use template;

class DBStaticNews {

  public static function db_news_update_set($announce_time, $text_unsafe, $detail_url_unsafe, $announce_id) {
    classSupernova::$db->doUpdateRowSet(
      TABLE_ANNOUNCE,
      array(
        'tsTimeStamp' => date(FMT_DATE_TIME_SQL, $announce_time),
        'strAnnounce' => $text_unsafe,
        'detail_url'  => $detail_url_unsafe,
      ),
      array(
        'idAnnounce' => $announce_id,
      )
    );
  }

  public static function db_news_insert_set($announce_time, $text_unsafe, $detail_url_unsafe, $userId, $userNameUnsafe) {
    classSupernova::$db->doInsertSet(TABLE_ANNOUNCE, array(
      'tsTimeStamp' => date(FMT_DATE_TIME_SQL, $announce_time),
      'strAnnounce' => $text_unsafe,
      'detail_url'  => $detail_url_unsafe,
      'user_id'     => $userId,
      'user_name'   => $userNameUnsafe,
    ));
  }

  public static function db_news_delete_by_id($announce_id) {
    classSupernova::$gc->db->doDeleteRow(

The method doDeleteRow does only exist in db_mysql, but not in Closure.

      TABLE_ANNOUNCE,
      array(
        'idAnnounce' => $announce_id,
      )
    );
  }

  public static function db_news_with_survey_select_by_id($announce_id) {
    return classSupernova::$db->doSelectFetch(
      "SELECT a.*, s.survey_id, s.survey_question, s.survey_until
        FROM {{announce}} AS a
        LEFT JOIN {{survey}} AS s ON s.survey_announce_id = a.idAnnounce
        WHERE `idAnnounce` = {$announce_id} LIMIT 1;");
  }

  /**
   * @param template $template
   * @param          $query_where
   * @param          $query_limit
   *
   * @return array|bool|mysqli_result|null
   */
  public static function db_news_list_get_by_query(&$template, $query_where, $query_limit) {
    $announce_list = classSupernova::$db->doSelect(
      "SELECT a.*, UNIX_TIMESTAMP(`tsTimeStamp`) AS unix_time, u.authlevel, s.*
    FROM
      {{announce}} AS a
      LEFT JOIN {{survey}} AS s ON s.survey_announce_id = a.idAnnounce
      LEFT JOIN {{users}} AS u ON u.id = a.user_id
    {$query_where}
    ORDER BY `tsTimeStamp` DESC, idAnnounce" .
      ($query_limit ? " LIMIT {$query_limit}" : ''));

    $template->assign_var('NEWS_COUNT', classSupernova::$db->db_num_rows($announce_list));

    return $announce_list;
  }

}