/**
* @Route("/document")
* @Route("/document/")
*/
public function documentAction(Request $request)
{
if (Remote::isOptionsRequest()) {
return Remote::getCORSSymfonyResponse();
}
$rowData = $this->cleanData(Remote::getRequestVariables());
$secret = $request->get('identifier');
$em = $this->getDoctrine()->getManager();
/** @var Doc $doc */
$doc = $em->getRepository('AppShedExtensionsSpreadsheetBundle:Doc')->findOneBy(['itemsecret' => $secret]);
if (!$doc) {
$screen = new Screen('Error');
$screen->addChild(new HTML('You must setup the extension before using it'));
return (new Remote($screen))->getSymfonyResponse();
}
try {
$existingTitles = $this->getColumnTitles($doc->getKey());
$store = false;
foreach ($rowData as $titleName => $value) {
if (!in_array($titleName, $existingTitles)) {
$store = true;
$this->addTitle($titleName, $doc->getKey());
$existingTitles[] = $titleName;
}
}
if ($store) {
$doc->setTitles(array_unique($existingTitles));
$em->flush();
}
foreach ($existingTitles as $titleName) {
if (!isset($rowData[$titleName])) {
$rowData[$titleName] = '';
}
}
if (count($rowData) > 0) {
$this->getSpreadsheets()->insertRow($rowData, $doc->getKey(), 1);
}
} catch (\Exception $e) {
$screen = new Screen('Error');
$screen->addChild(new HTML('There was an error storing'));
$screen->addChild(new Text($e->getMessage()));
$this->logger->error('Problem accessing a spreadsheet', ['exception' => $e, 'rowData' => $rowData]);
return (new Remote($screen))->getSymfonyResponse();
}
$screen = new Screen('Saved');
$screen->addChild(new HTML("Your record has been saved"));
return (new Remote($screen))->getSymfonyResponse();
}
/**
* @Route("/write", name="write")
* @Method({"GET", "POST"})
*/
public function appshedAction(Request $request)
{
$view = $this->getView($request);
if (!$view->getId()) {
$screen = new Screen("Error");
$screen->addChild(new Text("You must setup the view first"));
return (new Remote($screen))->getSymfonyResponse();
}
$store = $view->getStore();
$data = Remote::getRequestVariables();
$systemFields = $this->container->getParameter('data_system_fields');
foreach (array_keys($data) as $key) {
if (in_array($key, $systemFields)) {
unset($data[$key]);
continue;
}
if (is_array($data[$key])) {
$data[$key] = '[' . implode(', ', $data[$key]) . ']';
}
}
$cols = array_keys($data);
if (!count($cols)) {
$screen = new Screen("Error");
$screen->addChild(new Text("You must send some data"));
return (new Remote($screen))->getSymfonyResponse();
}
//Add any new columns to the store
$newColumns = array_diff($cols, $store->getColumns());
if (count($newColumns)) {
$store->setColumns(array_merge($store->getColumns(), $newColumns));
}
//Create new data obj
$dataO = new Data();
$dataO->setColumns($cols);
$dataO->setData($data);
$dataO->setStore($store);
$em = $this->getDoctrine()->getManager();
$em->persist($dataO);
$em->flush();
$screen = new Screen($view->getTitle() ?: "Thank you");
$screen->addChild(new Text($view->getMessage() ?: "Your entry has been saved"));
return (new Remote($screen))->getSymfonyResponse();
}