public function importSchools($real = false, $year = 0)
{
if ($real) {
$file = "./web/utilities/lahman/Schools.csv";
} else {
$file = "./web/utilities/lahman/Schools-test.csv";
}
$row = 0;
if (($handle = fopen($file, "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
if ($row) {
$team = $this->CI->_team->findOneByOfficialName(utf8_encode($data[1]));
if (!$team) {
$team = $this->CI->_team->findOneByLahmanId(utf8_encode($data[0]));
}
if (!$team) {
$team = new Team();
$team->setOfficialName(utf8_encode($data[1]));
$team->setLahmanId(utf8_encode($data[0]));
$team->setNickname($data[4]);
$team->setCity($data[2]);
$team->setState($data[3]);
}
print_r($team);
}
//row
$row++;
}
fclose($handle);
}
}
protected function getOrCreateTeam($name, $nickname)
{
$nickname = trim($nickname);
$name = trim(str_replace($nickname, '', $name));
$slug = $this->CI->slugify->simple($name);
$team = $this->CI->_team->findOneBySlug($slug);
if (!$team) {
$team = new Team();
$team->setName($name);
$team->setNickname($nickname);
$team->save();
}
return $team;
}
public function load()
{
$this->clear();
// Miami Hurricanes
$team = new Team('Miami, FL');
$team->setOfficialName('University of Miami');
$team->setNickname('Hurricanes');
$team->setCity('Miami');
$team->setState('FL');
$team->setNcaaId(415);
$level = $this->CI->_level->findOneBySlug('college');
$team->setLevel($level);
$league = $this->CI->_league->findOneBySlug('ncaa');
$team->setLeague($league);
$division = $this->CI->_division->findOneBySlug('d1');
$team->setDivision($division);
$conference = $this->CI->_conference->findOneBySlug('atlantic-coast');
$team->setConference($conference);
$team->save();
print_r(sprintf("Created Team: %s (%s)\n", $team->getName(), $team->getId()));
// Maryland Terrapins
$team = new Team('Maryland');
$team->setOfficialName('University of Maryland');
$team->setNickname('Terrapins');
$team->setCity('College Park');
$team->setState('FL');
$team->setNcaaId(392);
$level = $this->CI->_level->findOneBySlug('college');
$team->setLevel($level);
$league = $this->CI->_league->findOneBySlug('ncaa');
$team->setLeague($league);
$division = $this->CI->_division->findOneBySlug('d1');
$team->setDivision($division);
$conference = $this->CI->_conference->findOneBySlug('atlantic-coast');
$team->setConference($conference);
$team->save();
print_r(sprintf("Created Team: %s (%s)\n", $team->getName(), $team->getId()));
}
public function saveTeamsForConference($teams, $conference)
{
$documents = array();
foreach ($teams as $team) {
$slug = $this->slugify->simple($team['name']);
$document = $this->findOneBySlug($slug);
if (!$document) {
$document = new Team();
$document->setSlug($slug);
$document->setName($team['name']);
$document->setNickname($team['nickname']);
$document->setConference($conference);
$document->save();
}
$documents[] = $document;
}
return $documents;
}
