/**
* @Route("/", methods="GET")
* @Request({"form_id": "int"}, csrf=true)
*/
public function indexAction($form_id)
{
if (!$form_id) {
return [];
}
$query = Field::where(['form_id = ?'], [$form_id]);
return array_values($query->get());
}
/**
* @Route("/{id}", methods="DELETE", requirements={"id"="\d+"})
* @Request({"id": "int"}, csrf=true)
*/
public function deleteAction($id)
{
if ($form = Form::find($id)) {
foreach (Field::where(['form_id = :id'], [':id' => $id])->get() as $field) {
$field->delete();
}
$form->delete();
}
return ['message' => 'success'];
}
/**
* @Route("/csv", methods="GET")
* @Request({"options": "array"}, csrf=true)
*/
public function indexCsvAction($options = [])
{
$count = 0;
$forms = [];
$fields = [];
$form = ['id' => 0];
$options = new ArrObject($options);
if ($form_id = $options->get('form_id', 0)) {
//get forminfo
$form = Form::find($form_id);
$fields = Field::where(['form_id = ?'], [$form_id])->get();
$options->set('field_ids', array_keys($fields));
//count exported submissions
$query = Submission::query();
$query->where(['form_id = ?'], [$form_id])->whereIn('status', $options->get('status', []));
//input cleaned?
$count = $query->count();
} else {
$forms = array_values(Form::findAll());
}
//force int
$options->set('status', array_map(function ($id) {
return (int) $id;
}, $options->get('status', [])));
$options->set('form_id', (int) $form_id);
return ['options' => $options->toArray(), 'forms' => $forms, 'formitem' => $form, 'fields' => array_values($fields), 'count' => $count];
}
