$pageprev = $page - 1;
$pagenext = $page + 1;
$langs->load("pos@pos");
/*
* Actions
*/
//free terminal
if ($action == 'closeplace') {
$place = new place($db);
$place->fetch(GETPOST('id', 'int'));
$place->set_inactive($user);
}
if ($action == 'openplace') {
$place = new place($db);
$place->fetch(GETPOST('id', 'int'));
$place->set_active($user);
}
// Recherche
$mode = GETPOST('mode', 'alpha');
$modesearch = GETPOST('mode-search', 'string');
if ($mode == 'search') {
$_POST["search_name"] = $placename;
$sql = "SELECT rowid";
$sql .= " FROM " . MAIN_DB_PREFIX . "pos_place";
$sql .= " WHERE (";
$sql .= " name like '%" . $db->escape($placename) . "%'";
$sql .= ")";
$sql .= " AND entity = " . $conf->entity;
if (!$user->rights->societe->client->voir && !$place) {
$sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = " . $user->id;
}
