protected function execute(InputInterface $input, OutputInterface $output)
{
$em = $this->getContainer()->get('doctrine.orm.default_entity_manager');
$field_delimiter = "/\t/";
$row_delimiter = "/\n/";
$content = file_get_contents($input->getArgument('file'));
$rows = preg_split($row_delimiter, $content);
$field = $em->find('ClubBookingBundle:Field', 8);
$user = $em->find('ClubUserBundle:User', 1);
foreach ($rows as $line) {
if (strlen($line) > 0) {
list($name, $start, $stop, $interval_start, $interval_stop, $day) = preg_split($field_delimiter, $line);
$day++;
$start_time = new \DateTime($start . ' 00:00:00');
$stop_time = new \DateTime($stop . ' 23:59:59');
$t1 = new \DateTime(date('Y-m-d') . ' ' . $interval_start);
$t2 = new \DateTime(date('Y-m-d') . ' ' . $interval_stop);
$category = new \Club\BookingBundle\Entity\PlanCategory();
$category->setName($name);
$category->setDescription($name);
$em->persist($category);
$plan = new \Club\BookingBundle\Entity\Plan();
$plan->setPlanCategory($category);
$plan->setPeriodStart($start_time);
$plan->setPeriodEnd($stop_time);
$plan->setDay($day);
$plan->setFirstDate($t1);
$plan->setEndDate($t2);
$plan->setUser($user);
$plan->addField($field);
$em->persist($plan);
}
}
$em->flush();
}
