public function testBadNicknameReturnsEmptyRoster()
{
// Create a mock of the response from $db->newSelect()
$new_select = $this->createMockNewSelect();
// Create our mock DB connection
$db = $this->getMockBuilder('stdClass')->setMethods(['newSelect', 'fetchAll'])->getMock();
$db->expects($this->once())->method('newSelect')->will($this->returnValue($new_select));
$db->expects($this->once())->method('fetchAll')->will($this->returnValue(null));
$roster = new Roster($db);
$test_roster = $roster->getByNickname('BAD NICKNAME');
$this->assertEquals([], $test_roster, 'Bad nickname did not return empty roster');
}
<?php // Controller for "Make a Trade" page include 'DB.php'; include 'db_config.php'; $db = DB::connect(DSN); // Grab all our models include './models/franchises.php'; include './models/rosters.php'; $franchiseModel = new Franchise($db); $rosterModel = new Roster($db); $franchises = $franchiseModel->getAll(); // We need to grab the data that's come in via $_POST and build our rosters $team1 = filter_input(INPUT_POST, 'team1', FILTER_SANITIZE_ENCODED); $team2 = filter_input(INPUT_POST, 'team2', FILTER_SANITIZE_ENCODED); $team1Roster = $rosterModel->getByNickname($team1); $team2Roster = $rosterModel->getByNickname($team2); include './templates/make_trade.php';
$tig_name = $_POST["tig_name"];
}
// Sanity checks for the data
if ($id == 0 || $ibl_team == 'FA' || $round == "Undrafted") {
print "You must submit the correct data to draft someone!";
$task == "list";
} else {
$comments = "{$round} Round (" . YEAR . ")";
$result = $roster->updatePlayerTeam($ibl_team, $id, $comments);
if ($result) {
print "<div align='center'>Assigned {$tig_name} to <b>{$ibl_team}</b></div><br><br>";
// Add an entry to the transaction log
transaction_log($ibl_team, "Drafts {$tig_name} {$comments}", $db);
$task = "list";
} else {
print "<div align='center'>Couldn't update record for {$tig_name}. Please try again later</div><br><br>";
$task = "list";
}
}
}
if ($task == "list") {
// Show a list of free agents to draft
$tig_name = array();
$tig_name = $roster->getByNickname('FA');
// Now, let's display the list of people to draft
require 'templates/draft/list.php';
}
?>
<hr>
<div align="center"><a href=free_agents.php>Return to Manage Free Agents</a></div>
// and then allow them to be assigned to a team
$sql = "SELECT DISTINCT(ibl_team) FROM teams WHERE ibl_team!='FA' ORDER BY ibl_team";
$select = $db->newSelect();
$select->distinct()->cols(['ibl_team'])->from('teams')->where("ibl_team != 'FA'")->orderBy(['ibl_team']);
$sth = $pdo->prepare($select->getStatement());
$sth->execute($select->getBindValues());
$results = $sth->fetchAll(PDO::FETCH_ASSOC);
$ibl_team_dropdown = "<select name=ibl_team[]>";
$ibl_team_dropdown .= "<option value='FA' selected >Free Agent</option>";
foreach ($results as $row) {
$ibl_team = $row['ibl_team'];
$ibl_team_dropdown .= "<option value='" . $ibl_team . "'>" . $ibl_team . "</option>";
}
$ibl_team_dropdown .= "</select>";
// Now, get a list of all the players who are free agents
$results = $roster->getByNickname('FA');
?>
<div align=center>
<form action="<?php
print $_SERVER["PHP_SELF"];
?>
" method="post">
<input type="hidden" name="task" value="do_signing">
<table>
<?php
foreach ($results as $row) {
$tig_name = trim($row['tig_name']);
$id = $row['id'];
?>
<tr>
<td><?php
