Symfony2-插入日期类型为的数据

Question

我希望用户能够手动输入将保存到数据库的日期。我的MonthType看起来像：

class MonthType extends AbstractType
{
    public function buildForm(FormBuilderInterface $builder, array $options)
    {
    $builder->add(
        'name',
        TextType::class,
        [
            'label' => 'label.name',
            'required' => true,
            'attr' => [
                'max_length' => 128,
            ],
        ]
    );
    $builder->add(
        'dateStart',
        DateType::class,
        [
            'label' => 'label.dateStart',
            'format' => 'yyyy-MM-dd',
        ]
    );
    $builder->add(
        'dateEnd',
        DateType::class,
        [
            'label' => 'label.dateEnd',
            'format' => 'yyyy-MM-dd',

        ]
    );
    $builder->add(
        'upper_limit',
        MoneyType::class,
        [
            'label' => 'label.upper_limit',
            'currency' => false,
            'required' => true,
        ]
    );
    }
} 

我的控制器看起来像：

class MonthController implements ControllerProviderInterface
{

    public function connect(Application $app)
    {
        $controller->match('/add', [$this, 'addAction'])
            ->method('POST|GET')
            ->bind('month_add');

        return $controller;
    }
    /**
    * Add action.
    */
    public function addAction(Application $app, Request $request)                               
    {
        $month = [];
        $userRepository = new UserRepository($app['db']);

        $token = $app['security.token_storage']->getToken();
        if (null !== $token) {
            $user = $token->getUser();
            $userLogin = $user->getUsername();
        }

        $form = $app['form.factory']->createBuilder(MonthType::class, $month)->getForm();
        $form->handleRequest($request);

        if ($form->isSubmitted() && $form->isValid()) {
            $monthRepository = new MonthRepository($app['db']);
            $monthRepository->save($form->getData(), $userLogin);

            $app['session']->getFlashBag()->add(
                'messages',
                [
                    'type' => 'success',
                    'message' => 'message.element_successfully_added',
                ]
            );

            return $app->redirect($app['url_generator']->generate('month_index'), 301);
        }

        return $app['twig']->render(
            'history/add.html.twig',
            [
                'month' => $month,
                'form' => $form->createView(),
                'user_id' => $userRepository->findUserId($userLogin),
            ]
        );
    }
}

在存储库中，我有：

/**
 * Save record.
 */
public function save($month, $userLogin)
{
    $user_id = $this -> findUserIdByLogin($userLogin);
    $month['user_id'] = $user_id;
    $month['remained'] = $month['upper_limit'];

    if (isset($month['id']) && ctype_digit((string) $month['id']) && isset($user_id)) {
        // update record
        $id = $month['id'];
        unset($month['id']);

        return $this->db->update('month', $month, ['id' => $id]);
    } else {
        // add new record
        return $this->db->insert('month', $month);
    }
}

当我试图保存记录我得到一个错误：一个异常发生在执行'插入到月份（名称，日期开始，日期结束，upper_limit，user_id，保留）值 (?, ?, ?, ?, ?, ?)'使用参数["2012年6月"，{"date"："2012-06-01 00:00:00.000000"，"timezone_type"：3，"时区"："欧洲/柏林"}，{"date"："2012-06-30 00:00:00.000000"，"timezone_type"：3，"时区"："欧洲/柏林"}，7600，"1"，7600]：

可捕获的致命错误：类DateTime的对象无法转换为字符串

所以我试着做这样的事情：

    public function save($month, $userLogin)
    {
        $user_id = $this -> findUserIdByLogin($userLogin);
        $month['user_id'] = $user_id;
        $month['remained'] = $month['upper_limit'];

        $dateStart = new \DateTime($month['dateStart']);
        $month['dateStart'] = $dateStart->format('Y-m-d');
        $dateEnd = new \DateTime($month['dateEnd']);
        $month['dateEnd'] = $dateEnd->format('Y-m-d');
        ...//
    }

但我收到：DateTime::__construct（）期望参数1是字符串，对象给定

Answer 1

我解决了这个问题。我用了这个：http://symfony.com/blog/new-in-symfony-3-1-datetime-normalizer写

$serializer = new Serializer(array(new DateTimeNormalizer('Y-m-d')));
$month['dateStart'] = $serializer->normalize($month['dateStart']);
$serializer = new Serializer(array(new DateTimeNormalizer('Y-m-d')));
$month['dateEnd'] = $serializer->normalize($month['dateEnd']);

Answer 2

看起来您有$月['dateStart']和$月['dateend']作为DateTime（查看数据库异常{"date"："2012-06-01 00:00:00.000000"，"timezone_type"： 3，"timezone"："Europe/柏林"}）。

因此，您可以直接使用as$dateStart或$dateEnd，因为：

$month['dateStart']-