/**
* generate form for table
* @param $table string table
* @param $action string action
* @param string $method method form (default = POST)
* @return \SFramework\Form\Form
* @throws TableNotFoundDatabaseException
*/
public static function generate($table, $action, $method = 'POST')
{
$sql = 'SHOW FIELDS ' . 'FROM ' . $table;
$res = DatabaseProvider::connection()->query($sql);
if (empty($res)) {
throw new TableNotFoundDatabaseException($table);
}
$form = new Form($action, $method);
$form->setClass('pure-form pure-form-aligned centered');
foreach ($res as $value) {
if (self::getType($value['Type']) == 'text') {
$field = self::getTextArea($value);
} elseif (self::getType($value['Type']) == 'datetime') {
$field = self::getInput($value);
$field->addAttribute('class', 'datepicker');
$field->addAttribute('placeholder', '01/01/2014');
} else {
$field = self::getInput($value);
}
$form->addField($field);
}
$submit = new InputField('submit');
$submit->addAttribute('type', 'submit');
$submit->addAttribute('value', 'Envoyer');
$submit->addAttribute('class', 'pure-button pure-button-primary');
$form->addField($submit);
return $form;
}
public function deleteImage($userID, $imageID)
{
$query = 'DELETE FROM `users-images` WHERE imageid = ? AND userid = ?';
DatabaseProvider::connection()->execute($query, [$userID, $imageID]);
$query = 'DELETE FROM images WHERE idimage = ?';
DatabaseProvider::connection()->execute($query, [$imageID]);
}
function main()
{
DatabaseProvider::connect("app/config/database.json");
$router = new \SFramework\Routing\Router();
$router->add('/errors/err404', new \app\controllers\ErrorsController(), 'err404');
$router->add('/update', new \app\controllers\UpdaterController(), 'update');
$router->add('/view/p', new \app\controllers\HomeController(), 'index');
$router->add('/planning/get', new \app\controllers\HomeController(), 'getPlanning');
$router->add('/', new \app\controllers\HomeController(), 'index');
$router->matchCurrentRequest();
}
function main()
{
DatabaseProvider::connect("app/config/database.json");
$router = new \SFramework\Routing\Router();
$router->add('/errors/err404', new \app\controllers\ErrorsController(), 'err404');
$router->add('/image/view', new \app\controllers\HomeController(), 'view');
$router->add('/image/get', new \app\controllers\HomeController(), 'getImage');
$router->add('/image/delete', new \app\controllers\HomeController(), 'deleteImage');
$router->add('/upload', new \app\controllers\HomeController(), 'upload', 'POST');
$router->add('/register', new \app\controllers\HomeController(), 'register', 'POST');
$router->add('/users/admin', new \app\controllers\HomeController(), 'admin');
$router->add('/users/exist', new \app\controllers\HomeController(), 'doesUserExist');
$router->add('/users/connect', new \app\controllers\HomeController(), 'connect', 'POST');
$router->add('/users/disconnect', new \app\controllers\HomeController(), 'disconnect');
$router->add('/users/getimages', new \app\controllers\HomeController(), 'getImages');
$router->add('/check', new \app\controllers\HomeController(), 'check');
$router->add('/about', new \app\controllers\HomeController(), 'about');
$router->add('/partners', new \app\controllers\HomeController(), 'partners');
$router->add('/', new \app\controllers\HomeController(), 'index');
$router->matchCurrentRequest();
}
public function getMasterKey($username)
{
$query = 'SELECT master_key FROM users WHERE username = ?';
return DatabaseProvider::connection()->query($query, [$username]);
}
public function getGroups()
{
$query = 'SELECT ANNEE, GROUPE
FROM GROUPE ORDER BY ANNEE, GROUPE ';
return DatabaseProvider::connection()->query($query);
}
public function getWeeks()
{
$query = 'SELECT ID, TITRE FROM SEMAINE';
return DatabaseProvider::connection()->query($query);
}
