public static function import($em, $document)
{
$result = false;
if ($document->isCSV()) {
$url = $document->getPath();
$file = fopen($url, "r");
while (($data = fgetcsv($file, 8000, "\t")) !== FALSE) {
$user = $em->getRepository("RenovateMainBundle:User")->findOneByUsername($data[5]);
if ($user != NULL) {
$payment = new Payment();
$payment->setUserid($user->getId());
$payment->setUser($user);
$payment->setName($data[1]);
$payment->setAmount($data[2]);
$payment->setPersonalBalance($data[3]);
$payment->setBuildingBalance($data[4]);
$payment->setCreated(new \DateTime($data[0]));
$em->persist($payment);
$em->flush();
}
}
$result = true;
}
$document->unlink();
return $result;
}
