DBStaticSurveyVote::db_survey_vote_insert() - Code Metrics - Inspection of "CODE-misc-41a52.18: Moved DBStaticXXX classes to s..." - supernova-ws/SuperNova - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — work-fleets ( d7065d...1ee481 )

by SuperNova.WS

created 2016-08-13 14:27 UTC

DBStaticSurveyVote::db_survey_vote_insert() A

↳ Parent: DBStaticSurveyVote

Complexity

Conditions	1
Paths	1

Size

Total Lines	8
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	6
c	1
b	0
f	0
nc	1
nop	4
dl	0
loc	8
ccs	0
cts	8
cp	0
crap	2
rs	9.4285

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

}

1			<?php
2
3			namespace DBStatic;
4			use classSupernova;
5			use mysqli_result;
6
7			class DBStaticSurveyVote {
8
9			/**
10			* @param $announce
11			* @param $user
12			*
13			* @return array\|bool\|mysqli_result\|null
14			*/
15			public static function db_survey_get_vote($announce, $user) {
16			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;");
17			}
18
19
20			/**
21			* @param $survey_id
22			* @param $survey_vote_id
23			* @param $userId
24			* @param $user_name_unsafe
25			*/
26			public static function db_survey_vote_insert($survey_id, $survey_vote_id, $userId, $user_name_unsafe) {
27			classSupernova::$db->doInsertSet(TABLE_SURVEY_VOTES, array(
28			'survey_parent_id' => $survey_id,
29			'survey_parent_answer_id' => $survey_vote_id,
30			'survey_vote_user_id' => $userId,
31			'survey_vote_user_name' => $user_name_unsafe,
32			));
33			}
34
35
36			/**
37			* @param $user
38			* @param $survey_id
39			*
40			* @return array\|bool\|mysqli_result\|null
41			*/
42			public static function db_survey_vote_get(&$user, $survey_id) {
43			$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;");
44
45			return $is_voted;
46			}
47
48			}

supernova-ws / SuperNova

Push — work-fleets ( d7065d...1ee481 )

DBStaticSurveyVote::db_survey_vote_insert() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like