public function getInfoApiAction()
{
$list = Model\Estimote::findAll();
$return = array();
foreach ($list as $row) {
$return[$row["beacon_ref"]] = $row["name"];
}
exit(json_encode($return));
}
public function modifAction($params)
{
$estimote = Model\Estimote::find($params['id']);
$form = new Form\ModifEstimote($_POST, array('db' => $this->db));
if ($this->method == 'POST' && $form->isValid()) {
$estimote->setValues($form->getValues());
$estimote['user_id'] = $this->session->getUser()->getPk();
$estimote->save();
$this->redirect('backoffice');
}
return array('form' => $form, 'estimote' => $estimote);
}
public function averageTimeAction()
{
$vals = array('id' => $_GET['id']);
$estimote = Model\Estimote::find($vals);
$esti_ref = $estimote->getRef();
$averageTimeSpent = $this->db->query("SELECT AVG(time) as average, date_pass FROM esti_time WHERE beacon_ref = '{$esti_ref}' GROUP BY date_pass");
$averageTimeSpent = $averageTimeSpent->fetchAll();
$return2 = "";
foreach ($averageTimeSpent as $row2) {
$day = explode('-', $row2["date_pass"]);
$new_js_date = "new Date(" . $day[0] . "," . $day[1] . "," . $day[2] . "),";
$return2 .= "[{$new_js_date}" . $row2['average'] . ", '#0080FF'],";
}
return array('return2' => $return2);
}
