contest_model::mun_dump_data() - Code Metrics - Inspection of "Add MUN controller and view" - felicity-iiith/felicity18-website - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 6abae4...8c7895 )

by Megh

created 2017-12-06 17:49 UTC

contest_model::mun_dump_data() A

↳ Parent: contest_model

Complexity

Conditions	1
Paths	1

Size

Total Lines	8
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
c	0
b	0
f	0
dl	0
loc	8
rs	9.4285
cc	1
eloc	7
nc	1
nop	3

<?php

class contest_model extends Model {

    function __construct() {

        $this->load_library("db_lib");
    }

    private function is_registered($table_name, $user_nick) {
        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "SELECT *
            FROM `$table_name`
            WHERE `nick` = ?",
            "s",
            [$user_nick]
        );
        if (!$stmt) {
            return false;
        }
        $user_details = $stmt->get_result()->fetch_assoc();
        if ($user_details) {
            return $user_details;
        }
        return false;
    }

    /*
    |---------------------------------------------------------------------------
    | TTT-Workshop
    |---------------------------------------------------------------------------
    */

    public function is_registered_for_ttt($user_nick) {
        return $this->is_registered("ttt_registrations", $user_nick);
    }

    public function register_for_ttt($user_nick, $contact_number) {

        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "INSERT INTO `ttt_registrations`
            (`nick`, `contact_number`) VALUES (?, ?)",
            "ss",
            [$user_nick, $contact_number]
        );
        if (!$stmt) {
            return false;
        }
        else {
            return true;
        }
    }

    public function ttt_payment_success($payment_id, $nick, $status, $payment_data) {

        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "UPDATE `ttt_registrations`
            SET `payment_id` = ?, `payment_status` = ?, `payment_data` = ?
            WHERE `nick` = ?",
            "ssss",
            [$payment_id, $status, $payment_data, $nick]
        );
        $this->ttt_dump_data($nick, 'callback', $payment_data);
        if (!$stmt) {
            return false;
        }
        else {
            return true;
        }
    }

    public function ttt_dump_data($nick, $type, $response) {
        $this->db_lib->prepared_execute(

            $this->DB->contest,

            "INSERT INTO `ttt_payment_dump`
            (`nick`, `type`, `response`)
            VALUES (?, ?, ?)",
            "sss",
            [$nick, $type, $response]
        );
    }

    /*
    |---------------------------------------------------------------------------
    | Futsal
    |---------------------------------------------------------------------------
    */

    private function get_futsal_team($team_id) {
        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "SELECT *
            FROM `futsal_teams`
            WHERE `id` = ?",
            "i",
            [$team_id]
        );
        if (!$stmt) {
            return false;
        }
        $team_info = $stmt->get_result()->fetch_assoc();
        if ($team_info) {
            return $team_info;
        }
        return false;
    }

    public function is_registered_for_futsal($user_nick) {
        $user_details = $this->is_registered('futsal_participants', $user_nick);
        if ($user_details) {
            $team_info = $this->get_futsal_team($user_details['team_id']);
            return $team_info;
        }
        return false;
    }

    public function check_futsal_team_exists($team_name) {

        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "SELECT *
            FROM `futsal_teams`
            WHERE `team_name` = ?",
            "s",
            [$team_name]
        );
        if (!$stmt) {
            return false;
        }
        $stmt->store_result();
        if ($stmt->num_rows > 0) {
            return true;
        }
        return false;
    }

    public function check_futsal_participant_exists($user_nick) {

        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "SELECT *
            FROM `futsal_participants`
            WHERE `nick` = ?",
            "s",
            [$user_nick]
        );
        if (!$stmt) {
            return false;
        }
        $stmt->store_result();
        if ($stmt->num_rows > 0) {
            return true;
        }
        return false;
    }

    public function register_for_futsal($team_name, $contact_number, $team) {

        $this->DB->contest->begin_transaction(MYSQLI_TRANS_START_READ_WRITE);

        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,
            "INSERT INTO `futsal_teams`
            (`team_name`, `contact_number`) VALUES (?, ?)",
            "ss",
            [$team_name, $contact_number]
        );
        if (!$stmt) {
            return false;
        }
        $team_id = $this->DB->contest->insert_id;
        foreach ($team as $nick) {
            $stmt = $this->db_lib->prepared_execute(
                $this->DB->contest,
                "INSERT INTO `futsal_participants`
                (`team_id`, `nick`) VALUES (?, ?)",
                "is",
                [$team_id, $nick]
            );
            if (!$stmt) {
                return false;
            }
        }
        return $this->DB->contest->commit();
    }

    /*
    |---------------------------------------------------------------------------
    | Paper Presentation
    |---------------------------------------------------------------------------
    */

    public function is_registered_for_paper_presentation($user_nick) {
        return $this->is_registered('paper_presentation', $user_nick);
    }

    public function register_for_paper_presentation($info) {

        return $this->db_lib->prepared_execute(

            $this->DB->contest,

            "INSERT INTO `paper_presentation`
            (`nick`, `contact_number`, `paper_link`)
            VALUES  (?, ?, ?)",
            "sss",
            [
                $info['nick'],
                $info['contact_number'],
                $info['paper_link'],
            ],
            false
        );
    }

    /*
    |---------------------------------------------------------------------------
    | Visualize it
    |---------------------------------------------------------------------------
    */

    public function is_registered_for_visualizeit($user_nick) {
        return $this->is_registered('visualizeit', $user_nick);
    }

    public function register_for_visualizeit($info) {

        return $this->db_lib->prepared_execute(

            $this->DB->contest,

            "INSERT INTO `visualizeit`
            (`nick`, `paper_link`)
            VALUES  (?, ?)",
            "ss",
            [
                $info['nick'],
                $info['paper_link'],
            ],
            false
        );
    }

    /*
    |---------------------------------------------------------------------------
    | Web Development Workshop
    |---------------------------------------------------------------------------
    */

    public function is_registered_for_webdev($user_nick) {
        return $this->is_registered('webdev_registrations', $user_nick);
    }

    public function register_for_webdev($info) {

        return $this->db_lib->prepared_execute(

            $this->DB->contest,

            "INSERT INTO `webdev_registrations`
            (`nick`, `contact_number`, `stream`, `year`, `experience`, `why_join`)
            VALUES  (?, ?, ?, ?, ?, ?)",
            "ssssss",
            [
                $info['nick'],
                $info['contact_number'],
                $info['stream'],
                $info['year'],
                $info['experience'],
                $info['why_join'],
            ],
            false
        );
    }

    public function webdev_payment_success($payment_id, $nick, $status, $payment_data) {

        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "UPDATE `webdev_registrations`
            SET `payment_id` = ?, `payment_status` = ?, `payment_data` = ?
            WHERE `nick` = ?",
            "ssss",
            [$payment_id, $status, $payment_data, $nick]
        );
        $this->webdev_dump_data($nick, 'callback', $payment_data);
        if (!$stmt) {
            return false;
        }
        else {
            return true;
        }
    }

    public function webdev_dump_data($nick, $type, $response) {
        $this->db_lib->prepared_execute(

            $this->DB->contest,

            "INSERT INTO `webdev_payment_dump`
            (`nick`, `type`, `response`)
            VALUES (?, ?, ?)",
            "sss",
            [$nick, $type, $response]
        );
    }

    /*
    |---------------------------------------------------------------------------
    | Riders on the storm
    |---------------------------------------------------------------------------
    */

    public function is_registered_for_riderofstorms($user_nick) {
        return $this->is_registered('riderofstorms_registrations', $user_nick);
    }

    public function register_for_riderofstorms($info) {

        /*$user_details = [
            'nick'              => $info['nick'],
            'contact_number'    => $info['contact_number'],
            'name'              => $info['name'],
            'leader'            => $info['leader'],
            'members'           => $info['members'],
            'link'              => $info['link'],
            'tell'              => $info['tell']
        ];*/

        return $this->db_lib->prepared_execute(

            $this->DB->contest,

            "INSERT INTO `riderofstorms_registrations`
            (`nick`, `name`, `contact_number`, `leader`, `link`, `members`, `tell`)
            VALUES  (?, ?, ?, ?, ?, ?, ?)",
            "sssssss",
            [
              $info['nick'],
              $info['name'],
              $info['contact_number'],
              $info['leader'],
              $info['link'],
              $info['members'],
              $info['tell']
            ],
            false
        );
    }

    public function riderofstorms_payment_success($payment_id, $nick, $status, $payment_data) {

        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "UPDATE `riderofstorms_registrations`
            SET `payment_id` = ?, `payment_status` = ?, `payment_data` = ?
            WHERE `nick` = ?",
            "ssss",
            [$payment_id, $status, $payment_data, $nick]
        );
        $this->riderofstorms_dump_data($nick, 'callback', $payment_data);
        if (!$stmt) {
            return false;
        }
        else {
            return true;
        }
    }

    public function riderofstorms_dump_data($nick, $type, $response) {
        $this->db_lib->prepared_execute(

            $this->DB->contest,

            "INSERT INTO `riderofstorms_payment_dump`
            (`nick`, `type`, `response`)
            VALUES (?, ?, ?)",
            "sss",
            [$nick, $type, $response]
        );
    }


    /*
    |---------------------------------------------------------------------------
    | ARVR Workshop
    |---------------------------------------------------------------------------
    */

    public function is_registered_for_arvr($user_nick) {
        return $this->is_registered('arvr_registrations', $user_nick);
    }

    public function register_for_arvr($info) {

        return $this->db_lib->prepared_execute(

            $this->DB->contest,

            "INSERT INTO `arvr_registrations`
            (`nick`, `contact_number`)
            VALUES  (?, ?)",
            "ss",
            [
                $info['nick'],
                $info['contact_number'],
            ],
            false
        );
    }

    public function arvr_payment_success($payment_id, $nick, $status, $payment_data) {

        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "UPDATE `arvr_registrations`
            SET `payment_id` = ?, `payment_status` = ?, `payment_data` = ?
            WHERE `nick` = ?",
            "ssss",
            [$payment_id, $status, $payment_data, $nick]
        );
        $this->arvr_dump_data($nick, 'callback', $payment_data);
        if (!$stmt) {
            return false;
        }
        else {
            return true;
        }
    }

    public function arvr_dump_data($nick, $type, $response) {
        $this->db_lib->prepared_execute(

            $this->DB->contest,

            "INSERT INTO `arvr_payment_dump`
            (`nick`, `type`, `response`)
            VALUES (?, ?, ?)",
            "sss",
            [$nick, $type, $response]
        );
    }

    /*
    |---------------------------------------------------------------------------
    | Artuino Workshop
    |---------------------------------------------------------------------------
    */

    private function get_artuino_team($team_id) {
        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "SELECT *
            FROM `artuino_teams`
            WHERE `id` = ?",
            "i",
            [$team_id]
        );
        if (!$stmt) {
            return false;
        }
        $team_info = $stmt->get_result()->fetch_assoc();
        if ($team_info) {
            return $team_info;
        }
        return false;
    }

    public function is_registered_for_artuino($user_nick) {
        $user_details = $this->is_registered('artuino_participants', $user_nick);
        if ($user_details) {
            $team_info = $this->get_artuino_team($user_details['team_id']);
            return $team_info;
        }
        return false;
    }

    public function check_artuino_team_exists($team_name) {

        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "SELECT *
            FROM `artuino_teams`
            WHERE `team_name` = ?",
            "s",
            [$team_name]
        );
        if (!$stmt) {
            return false;
        }
        $stmt->store_result();
        if ($stmt->num_rows > 0) {
            return true;
        }
        return false;
    }

    public function check_artuino_participant_exists($user_nick) {

        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "SELECT *
            FROM `artuino_participants`
            WHERE `nick` = ?",
            "s",
            [$user_nick]
        );
        if (!$stmt) {
            return false;
        }
        $stmt->store_result();
        if ($stmt->num_rows > 0) {
            return true;
        }
        return false;
    }

    public function register_for_artuino($team_name, $contact_number, $team) {

        $this->DB->contest->begin_transaction(MYSQLI_TRANS_START_READ_WRITE);

        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,
            "INSERT INTO `artuino_teams`
            (`team_name`, `contact_number`) VALUES (?, ?)",
            "ss",
            [$team_name, $contact_number]
        );
        if (!$stmt) {
            return false;
        }
        $team_id = $this->DB->contest->insert_id;
        foreach ($team as $nick) {
            $stmt = $this->db_lib->prepared_execute(
                $this->DB->contest,
                "INSERT INTO `artuino_participants`
                (`team_id`, `nick`) VALUES (?, ?)",
                "is",
                [$team_id, $nick]
            );
            if (!$stmt) {
                return false;
            }
        }
        return $this->DB->contest->commit();
    }

    public function artuino_payment_success($payment_id, $team_id, $status, $payment_data) {

        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "UPDATE `artuino_teams`
            SET `payment_id` = ?, `payment_status` = ?, `payment_data` = ?
            WHERE `id` = ?",
            "ssss",
            [$payment_id, $status, $payment_data, $team_id]
        );
        $this->artuino_dump_data($team_id, 'callback', $payment_data);
        if (!$stmt) {
            return false;
        }
        else {
            return true;
        }
    }

    public function artuino_dump_data($team_id, $type, $response) {
        $this->db_lib->prepared_execute(

            $this->DB->contest,

            "INSERT INTO `artuino_payment_dump`
            (`team_id`, `type`, `response`)
            VALUES (?, ?, ?)",
            "sss",
            [$team_id, $type, $response]
        );
    }

    /*
    |---------------------------------------------------------------------------
    | MUN
    |---------------------------------------------------------------------------
    */

    public function is_registered_for_mun($user_nick) {
        return $this->is_registered('mun_registrations', $user_nick);
    }

    public function register_for_mun($info) {
        return $this->db_lib->prepared_execute(

            $this->DB->contest,

            "INSERT INTO `mun_registrations`
            (`nick`, `contact_number`, `institute`, `team_size`, `needs_accomodation`)
            VALUES  (?, ?, ?, ?, ?)",
            "sssii",
            [
                $info['nick'],
                $info['contact_number'],
                $info['institute'],
                $info['team_size'],
                $info['needs_accomodation'],
            ],
            false
        );
    }

    public function mun_payment_success($payment_id, $nick, $status, $payment_data) {
        $stmt = $this->db_lib->prepared_execute(

            $this->DB->contest,

            "UPDATE `mun_registrations`
            SET `payment_id` = ?, `payment_status` = ?, `payment_data` = ?
            WHERE `nick` = ?",
            "ssss",
            [$payment_id, $status, $payment_data, $nick]
        );
        $this->mun_dump_data($nick, 'callback', $payment_data);
        if (!$stmt) {
            return false;
        }
        else {
            return true;
        }
    }

    public function mun_dump_data($nick, $type, $response) {
        $this->db_lib->prepared_execute(

            $this->DB->contest,

            "INSERT INTO `mun_payment_dump`
            (`nick`, `type`, `response`)
            VALUES (?, ?, ?)",
            "sss",
            [$nick, $type, $response]
        );
    }

}


1			<?php
2
3			class contest_model extends Model {
4
5			function __construct() {
			0 ignored issues – show Best Practice introduced 2017-12-05 08:51 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
6			$this->load_library("db_lib");
7			}
8
9			private function is_registered($table_name, $user_nick) {
10			$stmt = $this->db_lib->prepared_execute(
			0 ignored issues – show Bug Best Practice introduced 2017-12-05 08:51 UTC by Report Bug Copy Issue Report The property `db_lib` does not exist on `contest_model`. Since you implemented `__get`, consider adding a @property annotation. Loading history...
11			$this->DB->contest,
			0 ignored issues – show Bug Best Practice introduced 2017-12-05 08:51 UTC by Report Bug Copy Issue Report The property `contest` does not exist on `DatabaseFactory`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2017-12-05 08:51 UTC by Report Bug Copy Issue Report The property `$DB` is declared private in `Model`. Since you implement `__get`, consider adding a @property or @property-read. Loading history...
12			"SELECT *
13			FROM `$table_name`
14			WHERE `nick` = ?",
15			"s",
16			[$user_nick]
17			);
18			if (!$stmt) {
19			return false;
20			}
21			$user_details = $stmt->get_result()->fetch_assoc();
22			if ($user_details) {
23			return $user_details;
24			}
25			return false;
26			}
27
28			/*
29			\|---------------------------------------------------------------------------
30			\| TTT-Workshop
31			\|---------------------------------------------------------------------------
32			*/
33
34			public function is_registered_for_ttt($user_nick) {
35			return $this->is_registered("ttt_registrations", $user_nick);
36			}
37

felicity-iiith / felicity18-website

Push — master ( 6abae4...8c7895 )

contest_model::mun_dump_data() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like