function start()
{
if (!empty($_POST)) {
if (!isset($_POST['id'])) {
createUser($_POST);
} else {
editUser($_POST);
}
require '../views/list.php';
return;
}
if (!isset($_GET['id']) && !isset($_GET['page'])) {
$people = getPeople();
require '../views/list.php';
return;
}
if (isset($_GET['page']) && $_GET['page'] === 'add') {
require '../views/add.php';
return;
}
if (isset($_GET['page']) && $_GET['page'] === 'edit') {
if (!isset($_GET['id'])) {
die('veuillez spécifier un id d\'utilisateur');
}
$id = $_GET['id'];
$editable = ORM::for_table('users')->find_one($id);
require '../views/edit.php';
return;
}
$user = getUser();
require '../views/show.php';
}
function start()
{
if (!isset($_GET['id'])) {
$people = getPeople();
require '../views/list.php';
} else {
$user = getUser();
require '../views/show.php';
}
}
function getPeopleTeamsList()
{
$people = getPeople();
foreach ($people as $p) {
$uid = $p['uid'];
$testteam = getUserSolveTeam($uid);
$teamassignments["{$uid}"] = $testteam;
}
asort($teamassignments);
return $teamassignments;
}
function start()
{
if (!empty($_POST['nom'])) {
addUser();
$tableauPeople = getPeople();
require '../views/list.php';
} elseif (!isset($_GET['id'])) {
// charge la page list
$tableauPeople = getPeople();
require '../views/list.php';
} else {
// avec l'id charge la page show
$data = loadData();
require '../views/show.php';
}
}
function start()
{
if (!empty($_POST)) {
if (!isset($_POST['id'])) {
addUser($_POST);
$fla = flash("Ajout reussie");
} else {
editUser($_POST);
$fla = flash("Edition reussie");
}
$people = getPeople();
require '../views/list.php';
return;
}
if (!isset($_GET['id']) && !isset($_GET['page'])) {
$people = getPeople();
return require '../views/list.php';
}
if (isset($_GET['page']) && $_GET['page'] === 'add') {
return require '../views/add.php';
}
if (isset($_GET['page']) && $_GET['page'] === 'list') {
$people = getPeople();
return require '../views/list.php';
}
if (isset($_GET['page']) && $_GET['page'] === 'edit') {
if (!isset($_GET['id'])) {
die('Nope, ou est ID ?');
}
$id = $_GET['id'];
$editable = ORM::for_table('users')->find_one($id);
return require '../views/edit.php';
}
if (isset($_GET['id'])) {
$user = getUser();
$message = getMessages($_GET['id']);
require '../views/show.php';
}
}
function viewList()
{
$people = getPeople();
require '../views/list.php';
return;
}
global $db;
$token = trim(file_get_contents('config/token.txt'));
$mainPage = pullUrl("https://techspring.nationbuilder.com/api/v1/sites/v2/pages/events?starting=" . date("Y-m-d") . "&access_token=" . $token . "");
$obj = json_decode($mainPage);
//echo "<pre>" . json_encode($obj, JSON_PRETTY_PRINT) . "</pre>";
if ($db = new SQLite3('local_db.sql')) {
$q = @$db->query('CREATE TABLE IF NOT EXISTS events (eid INTEGER, start_time TEXT, end_time TEXT, name TEXT, description TEXT, PRIMARY KEY(eid))');
$q = @$db->query('CREATE TABLE IF NOT EXISTS rsvp (eid INTEGER, uid INTEGER)');
}
foreach ($obj->results as $eventObj) {
echo "<br/>{$eventObj->id} - {$eventObj->name} - {$eventObj->start_time} - {$eventObj->end_time} - {$eventObj->intro} <br />";
$startTime = strtotime($eventObj->start_time);
$endTime = strtotime($eventObj->end_time);
echo "Date: " . date("l, F jS", $startTime);
echo "<br />Time:" . date("g:i a", $startTime) . " - " . date("g:i a", $endTime) . "<br />";
@$db->query("INSERT OR IGNORE INTO `events` (eid, start_time, end_time, name, description) VALUES " . "('" . $eventObj->id . "'," . "'" . $eventObj->start_time . "'," . "'" . $eventObj->end_time . "'," . "'" . $eventObj->name . "'," . "'" . $eventObj->intro . "');");
}
$eventRes = @$db->query("SELECT * FROM `events`");
while ($event = $eventRes->fetchArray()) {
$json = pullUrl("https://techspring.nationbuilder.com/api/v1/sites/v2/pages/events/" . $event['eid'] . "/rsvps?limit=10&__proto__=&access_token=" . $token);
$rsvpData = json_decode($json);
foreach ($rsvpData->results as $rsvp) {
@$db->query("INSERT OR IGNORE INTO `rsvp` (eid, uid) VALUES ('" . $event['eid'] . "','" . $rsvp->person_id . "')");
}
}
}
if (!isset($inhibitLoad)) {
getPeople();
getEvents();
$db->close();
}
/** Function getInfoFilm
return all movies with all information. It's possible to precised an attribute of the movie
@param db connector PDO of the db
@param attr array of filter for table movies /!\ Special syntax !!! Look example /!\
@param filter array of filter for other table /!\ Special syntax
@return Success = array of Movies, Echec = False
@example
Example of attributes
- field is the field in database
- value : is the value for the test ('%r%' or '1', ...)
- sign : is the sign for the comparation for permit compart string with special test % or _ ( '=' or 'LIKE', ...)
$attr = array(
'field' => array(
'value', 'sign'
);
Example of filter
- field is the type of filter ('genres', 'countries', 'studios', 'actor', 'writer', 'director', 'producer', )
- value is the value for make filter /!\ add % caracter where you want for actor, writer, director and producer
$filter = array(
'field' => value,
'actor' => %sara%toto%
)
*/
function getInfoMovies($db, $attr = array(), $filter = array())
{
//recure filter array
$secur = array('genres' => false, 'studios' => false, 'countries' => false, 'actor' => false, 'writer' => false, 'producer' => false, 'director' => false);
$filter = array_merge($secur, $filter);
$query = 'SELECT * FROM movies ';
$query .= 'INNER JOIN files ON files.`fkMovies` = movies.`idMovies` ';
$first = true;
foreach ($attr as $key => $value) {
$sign = $value[1];
if ($first) {
$first = false;
$query .= "WHERE movies.{$key} {$sign} '{$value[0]}' ";
} else {
$query .= "AND movies.{$key} {$sign} '{$value[0]}' ";
}
}
$query .= "GROUP BY movies.`idMovies`";
$req = $db->prepare($query);
if (!$req->execute()) {
$error = $req->errorCode();
$error = "Error occurred during the execution of the request ('{$error}')";
//echo $error;
return false;
}
if ($req->rowCount() >= 1) {
$result = $req->fetchAll();
} else {
return false;
}
for ($i = 0, $size = count($result); $i < $size; $i++) {
$id = $result[$i]["idMovies"];
/* Need REWORK ! */
if (($result[$i]["genres"] = getGenres($db, $id, $filter['genres'])) === false && $filter['genres'] !== false) {
unset($result[$i]);
continue;
}
if (($result[$i]["countries"] = getCountries($db, $id, $filter['countries'])) === false && $filter['countries'] !== false) {
unset($result[$i]);
continue;
}
if (($result[$i]["writer"] = getPeople($db, $id, DB_WRITER_TYPE, $filter['writer'])) === false && $filter['writer'] !== false) {
unset($result[$i]);
continue;
}
if (($result[$i]["director"] = getPeople($db, $id, DB_DIRECTOR_TYPE, $filter['director'])) === false && $filter['director'] !== false) {
unset($result[$i]);
continue;
}
if (($result[$i]["actor"] = getPeople($db, $id, DB_ACTOR_TYPE, $filter['actor'])) === false && $filter['actor'] !== false) {
unset($result[$i]);
continue;
}
if (($result[$i]["producer"] = getPeople($db, $id, DB_PRODUCER_TYPE, $filter['producer'])) === false && $filter['producer'] !== false) {
unset($result[$i]);
continue;
}
if (($result[$i]["studios"] = getStudios($db, $id, $filter['studios'])) === false && $filter['studios'] !== false) {
unset($result[$i]);
continue;
}
}
return $result;
}
<?php
header('Location: index.php');
$inhibitLoad = true;
include 'update_database.php';
getPeople(1);
//loads the latest 10
<?php
// vim:set ts=4 sw=4 sts=4 et:
require_once "config.php";
require_once "html.php";
require_once "db-func.php";
require_once "utils.php";
// Redirect to the login page, if not logged in
isLoggedIn();
// Start HTML
head("people");
$people = getPeople();
if (!$people) {
echo "<strong>No people to list!</strong>";
}
foreach ($people as $p) {
printPerson($p);
}
// End HTML
foot();
allowSpaces: true,
singleFieldNode: $('#directorsField'),
});
});
</script>
</div>
</div>
<div class="col-sm-7">
<div class="form-group">
{!! Form::label('actor',trans('all.actor')) !!}<i class="required">*</i>
{!! Form::hidden('actor',null,['id'=>'actorsField','class'=>'form-control count_field','maxlength'=>100]) !!}
<ul id="actorsTag"></ul>
<small>Content limited to 100 characters, remaining: <span class="actor_count">0</span></small>
<?php
$actors = json_encode(getPeople(1), JSON_UNESCAPED_UNICODE);
?>
<script type="text/javascript">
$(function() {
var actors = {!! $actors !!};
$('#actorsTag').tagit({
availableTags: actors,
// This will make Tag-it submit a single form value, as a comma-delimited field.
singleField: true,
allowSpaces: true,
singleFieldNode: $('#actorsField'),
});
});
</script>
<?php /** * User: Hans-Gert Gräbe * Date: 2016-02-20 */ require_once "layout.php"; require_once "php/People.php"; $content = ' <div class="container"> <h1 align="center">People</h1> <p>The following list of academic people working in Computer Algebra is extracted from the SymbolicData <a href="http://symbolicdata.org/Data/People/" >CASN People Database</a>. </p> <p>The CASN Database contains more than 1000 instances of foaf:Person (as of Febr. 2016). In 2014 we identified in a joint effort with ZBMath (Wolfram Sperber) the author strings of 347 persons within the author disambiguation system of the Zentralblatt. </p> <p>For performance reasons the output is restricted to about 20 entries (100 RDF triples). Use HTTP Get Parameter as in <code>info/people.php?name=G&affil=J</code> to display available information about people with foaf:name containing the string "G" and sd:affiliation containing the string "J". The search is case insensitive.</p> ' . getPeople($_GET['name'], $_GET['affil']) . ' </div> '; echo showPage($content);
