/**
* @Route("/edit_statement/{id}",name="edit_statement")
* @ParamConverter("statement", class="AppBundle:Statement")
* @Method({"GET","POST"})
* @Security("has_role('ROLE_ADMIN')")
*/
public function edit_statement(Statement $statement, Request $request)
{
$em = $this->getDoctrine()->getManager();
$client_id = $statement->getClient()->getId();
$form = $this->createForm(new StatementType($statement));
$form->handleRequest($request);
$file = $form['statement_file']->getData();
if ($form->isSubmitted()) {
$data = $this->handleExcelData($file);
$content = $data['excel_data'];
unset($content[0]);
for ($i = 1; $i <= count($content); $i++) {
array_splice($content[$i], 29, 4);
array_splice($content[$i], 20, 8);
array_splice($content[$i], 16, 3);
array_splice($content[$i], 13, 2);
array_splice($content[$i], 5, 1);
}
$tr_arr = array();
//balance date
$statement->setBalanceDate($content[1][1]);
foreach ($content as $data) {
$td_arr = array();
foreach ($data as $value) {
$td = '<td>' . $value . '</td>';
$td_arr[] = $td;
}
$tr_arr[] = "<tr>" . implode("", $td_arr) . "</tr>";
}
$content = implode("", $tr_arr);
$statement->setContent($content);
$em->flush();
}
$redirect_url = $this->generateUrl('productdetail', ['id' => $client_id]);
return new Response("<script>alert('修改日结单成功!');window.location.href='{$redirect_url}';</script>");
}
