function importRecords()
{
$csvPath = APPLICATION_PATH . "/../data/imports.csv";
$contents = file_get_contents($csvPath);
$lines = explode("\n", $contents);
$i = 0;
$recordsModel = new Records();
foreach ($lines as $line) {
if ($i > 0) {
$data = explode(",", $line);
$substitutesModel = new Substitutes();
$substitute = $substitutesModel->getBySecondaryId($data[13]);
$locationsModel = new Locations();
$location = $locationsModel->getByName($data[4]);
$nameSegments = explode("|", $data[3]);
$lastName = $nameSegments[0];
$firstName = $nameSegments[1];
$employeesModel = new Employees();
$employee = $employeesModel->getByName($firstName, $lastName);
if ($data[9] == 'FALSE' || $data[9] == FALSE) {
$leaveForm = 0;
} else {
$leaveForm = 1;
}
if (!$substitute) {
$subid = '129';
} else {
$subid = $substitute->id;
}
$recordData = array('date' => date('Y-m-d', strtotime($data[1])), 'employee' => @$employee->id, 'location' => @$location->id, 'substitute' => $subid, 'reason' => $data[6], 'notes' => $data[7], 'percent' => str_replace("%", "", $data[8]), 'leave_form' => $leaveForm, 'user' => 6, 'acct' => $data[14]);
try {
$recordsModel->insert($recordData);
} catch (Exception $e) {
echo $e->getMessage();
}
print_r($recordData);
}
$i++;
}
}
