DBStatic\DBStaticSurveyAnswer

Complexity

Total Complexity

5

Size/Duplication

Total Lines	55
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	db_survey_answer_insert()	0	6	1
A	db_survey_answer_text_select_by_news()	0	3	1
A	db_survey_answers_get_list_by_parent()	0	5	1
A	db_survey_get_answer_texts()	0	12	1
A	db_survey_answer_get()	0	5	1

<?php

namespace DBStatic;
use classSupernova;
use mysqli_result;

class DBStaticSurveyAnswer {

  public static function db_survey_answer_insert($survey_id, $survey_answer_text_unsafe) {
    classSupernova::$db->doInsertSet(TABLE_SURVEY_ANSWERS, array(
      'survey_parent_id'   => $survey_id,
      'survey_answer_text' => $survey_answer_text_unsafe,
    ));
  }

  public static function db_survey_answer_text_select_by_news($announce) {
    return classSupernova::$db->doSelect("SELECT survey_answer_text FROM {{survey_answers}} WHERE survey_parent_id = {$announce['survey_id']};");
  }

  /**
   * @param $announce
   *
   * @return array|bool|mysqli_result|null
   */
  public static function db_survey_answers_get_list_by_parent($announce) {
    $survey_query = classSupernova::$db->doSelect("SELECT * FROM {{survey_answers}} WHERE survey_parent_id  = {$announce['survey_id']} ORDER BY survey_answer_id;");

    return $survey_query;
  }

  /**
   * @param $announce
   *
   * @return array|bool|mysqli_result|null
   */
  public static function db_survey_get_answer_texts($announce) {
    $survey_query = classSupernova::$db->doSelect(
      "SELECT survey_answer_text AS `TEXT`, count(DISTINCT survey_vote_id) AS `VOTES`
          FROM `{{survey_answers}}` AS sa
            LEFT JOIN `{{survey_votes}}` AS sv ON sv.survey_parent_answer_id = sa.survey_answer_id
          WHERE sa.survey_parent_id = {$announce['survey_id']}
          GROUP BY survey_answer_id
          ORDER BY survey_answer_id;"
    );

    return $survey_query;
  }

  /**
   * @param $survey_id
   * @param $survey_vote_id
   *
   * @return array|bool|mysqli_result|null
   */
  public static function db_survey_answer_get($survey_id, $survey_vote_id) {
    $is_answer_exists = classSupernova::$db->doSelectFetch("SELECT `survey_answer_id` FROM `{{survey_answers}}` WHERE survey_parent_id = {$survey_id} AND survey_answer_id = {$survey_vote_id};");

    return $is_answer_exists;
  }

}