Requests::getVotes PHP 메소드

getVotes() 공개 메소드

public getVotes ( $id )
    public function getVotes($id)
    {
        $sth = $this->db->prepare('SELECT ' . implode(',', User::getDefaultFields()) . ', reqvotes.id AS vid, reqvotes.krydda, reqvotes.reqid FROM reqvotes LEFT JOIN users ON reqvotes.userid = users.id WHERE reqvotes.reqid = ?');
        $sth->bindParam(1, $id, PDO::PARAM_INT);
        $sth->execute();
        $result = array();
        while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
            $arr = array();
            $arr["id"] = $row["vid"];
            $arr["reward"] = $row["krydda"];
            $arr["user"] = $this->user->generateUserObject($row);
            array_push($result, $arr);
        }
        return $result;
    }

Usage Example

예제 #1
0
     $requests = new Requests($db, $user);
     $adminlogs = new AdminLogs($db, $user);
     $torrent = new Torrent($db, $user, $log, $movieData, $sweTv, $requests, $mailbox, null, $adminlogs);
     $torrentId = $torrent->upload($_FILES["file"], $_POST);
     httpResponse($torrentId);
     break;
 case validateRoute('GET', 'requests'):
     $requests = new Requests($db, $user);
     list($requests, $total) = $requests->query((int) $_GET["index"], (int) $_GET["limit"], $_GET["sort"], $_GET["order"], $_GET["searchParams"]);
     httpResponse($requests, $total);
     break;
 case validateRoute('GET', 'requests/\\d+'):
     $requests = new Requests($db, $user);
     $movieData = new MovieData($db);
     $requestResponse = $requests->get($params[1]);
     $requestVotes = $requests->getVotes($params[1]);
     $movieDataResponse = $movieData->getData($requestResponse["imdbid"]);
     httpResponse(array("request" => $requestResponse, "votes" => $requestVotes, "movieData" => $movieDataResponse));
     break;
 case validateRoute('GET', 'requests/my'):
     $requests = new Requests($db, $user);
     httpResponse($requests->getMyRequests());
     break;
 case validateRoute('POST', 'requests'):
     $logs = new Logs($db, $user);
     $requests = new Requests($db, $user, $logs);
     httpResponse($requests->createOrUpdate($postdata));
     break;
 case validateRoute('PATCH', 'requests/\\d+'):
     $requests = new Requests($db, $user);
     httpResponse($requests->createOrUpdate($postdata, (int) $params[1]));