DBStatic\DBStaticSurveyVote

Complexity

Total Complexity

3

Size/Duplication

Total Lines	42
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	db_survey_get_vote()	0	3	1
A	db_survey_vote_insert()	0	8	1
A	db_survey_vote_get()	0	5	1

<?php

namespace DBStatic;
use classSupernova;
use mysqli_result;

class DBStaticSurveyVote {

  /**
   * @param $announce
   * @param $user
   *
   * @return array|bool|mysqli_result|null
   */
  public static function db_survey_get_vote($announce, $user) {
    return classSupernova::$db->doSelectFetch("SELECT `survey_vote_id` FROM `{{survey_votes}}` WHERE survey_parent_id = {$announce['survey_id']} AND survey_vote_user_id = {$user['id']} LIMIT 1;");
  }


  /**
   * @param $survey_id
   * @param $survey_vote_id
   * @param $userId
   * @param $user_name_unsafe
   */
  public static function db_survey_vote_insert($survey_id, $survey_vote_id, $userId, $user_name_unsafe) {
    classSupernova::$db->doInsertSet(TABLE_SURVEY_VOTES, array(
      'survey_parent_id'        => $survey_id,
      'survey_parent_answer_id' => $survey_vote_id,
      'survey_vote_user_id'     => $userId,
      'survey_vote_user_name'   => $user_name_unsafe,
    ));
  }


  /**
   * @param $user
   * @param $survey_id
   *
   * @return array|bool|mysqli_result|null
   */
  public static function db_survey_vote_get(&$user, $survey_id) {
    $is_voted = classSupernova::$db->doSelectFetch("SELECT `survey_vote_id` FROM `{{survey_votes}}` WHERE survey_parent_id = {$survey_id} AND survey_vote_user_id = {$user['id']} FOR UPDATE;");

    return $is_voted;
  }

}