public function paginate(ModelSet $modelSet)
{
$page = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : 1;
$limit = $this->perPage;
$total = $modelSet->count();
$modelSet->paginator = new Paginator($total, $page, $limit);
return $modelSet->limit($modelSet->paginator->perPage())->offset($modelSet->paginator->offset());
}
function selectModelSet($table = '')
{
if ($table != '') {
$ModelSet = new ModelSet($this);
return $ModelSet->from($table);
} else {
return new ModelSet($this);
}
}
/**
* @data array with indexes:
* - 'id_set_type': integer
* - 'id_player_1_win': integer
* - 'id_player_2_win': integer or NULL
* - 'id_player_1_lose': integer
* - 'id_player_2_lose': integer or NULL
* - 'creation_datetime': string at format 'YYYY-MM-DD HH:MM:SS', OPTIONAL
*/
static function add($data)
{
$id_set_type = $data['id_set_type'];
$id_player_1_win = $data['id_player_1_win'];
$id_player_2_win = $data['id_player_2_win'];
$id_player_1_lose = $data['id_player_1_lose'];
$id_player_2_lose = $data['id_player_2_lose'];
$init_score_player_1_win = ModelSet::getLatestScore($id_player_1_win, $id_set_type);
$init_score_player_1_lose = ModelSet::getLatestScore($id_player_1_lose, $id_set_type);
$init_nb_sets_player_1_win = ModelSet::getNbSets($id_player_1_win, $id_set_type);
$init_nb_sets_player_1_lose = ModelSet::getNbSets($id_player_1_lose, $id_set_type);
$new_score_player_1_win = DEFAULT_SCORE;
$new_score_player_1_lose = DEFAULT_SCORE;
if (ModelSetType::isDoubles($id_set_type)) {
$init_score_player_2_win = ModelSet::getLatestScore($id_player_2_win, $id_set_type);
$init_score_player_2_lose = ModelSet::getLatestScore($id_player_2_lose, $id_set_type);
$init_nb_sets_player_2_win = ModelSet::getNbSets($id_player_2_win, $id_set_type);
$init_nb_sets_player_2_lose = ModelSet::getNbSets($id_player_2_lose, $id_set_type);
$new_score_player_2_win = DEFAULT_SCORE;
$new_score_player_2_lose = DEFAULT_SCORE;
} else {
// set scoring data for doubles to NULL
$init_score_player_2_win = 'NULL';
$init_score_player_2_lose = 'NULL';
$init_nb_sets_player_2_win = 'NULL';
$init_nb_sets_player_2_lose = 'NULL';
$new_score_player_2_win = 'NULL';
$new_score_player_2_lose = 'NULL';
}
Scoring::computeNewScores($id_set_type, $init_score_player_1_win, $init_score_player_2_win, $init_score_player_1_lose, $init_score_player_2_lose, $init_nb_sets_player_1_win, $init_nb_sets_player_2_win, $init_nb_sets_player_1_lose, $init_nb_sets_player_2_lose, $new_score_player_1_win, $new_score_player_2_win, $new_score_player_1_lose, $new_score_player_2_lose);
$row = array('id_set_type' => $id_set_type, 'id_player_1_win' => $id_player_1_win, 'id_player_2_win' => $id_player_2_win === NULL ? 'NULL' : $id_player_2_win, 'id_player_1_lose' => $id_player_1_lose, 'id_player_2_lose' => $id_player_2_lose === NULL ? 'NULL' : $id_player_2_lose, 'init_score_player_1_win' => $init_score_player_1_win, 'init_score_player_2_win' => $init_score_player_2_win, 'init_score_player_1_lose' => $init_score_player_1_lose, 'init_score_player_2_lose' => $init_score_player_2_lose, 'init_nb_sets_player_1_win' => $init_nb_sets_player_1_win, 'init_nb_sets_player_2_win' => $init_nb_sets_player_2_win, 'init_nb_sets_player_1_lose' => $init_nb_sets_player_1_lose, 'init_nb_sets_player_2_lose' => $init_nb_sets_player_2_lose, 'new_score_player_1_win ' => $new_score_player_1_win, 'new_score_player_2_win ' => $new_score_player_2_win, 'new_score_player_1_lose' => $new_score_player_1_lose, 'new_score_player_2_lose' => $new_score_player_2_lose);
if (isset($data['creation_datetime'])) {
$row['creation_datetime'] = "'" . Database::escape($data['creation_datetime']) . "'";
}
Database::insert(array('table' => 'bad_set', 'row' => $row));
}
<?php
include 'bootstrap.php';
Database::open();
$sets = ModelSet::get(array('order_by' => 'creation_datetime'));
Database::close();
foreach ($sets as $set) {
echo "ModelSet::add(array(\r\n 'creation_datetime' => '" . $set['creation_datetime'] . "',\r\n 'id_set_type' => " . $set['id_set_type'] . ",\r\n 'id_player_1_win' => " . $set['id_player_1_win'] . ",\r\n 'id_player_2_win' => " . ($set['id_player_2_win'] === NULL ? "'NULL'" : $set['id_player_2_win']) . ",\r\n 'id_player_1_lose' => " . $set['id_player_1_lose'] . ",\r\n 'id_player_2_lose' => " . ($set['id_player_2_lose'] === NULL ? "'NULL'" : $set['id_player_2_lose']) . "\r\n ));";
echo "\n";
}
<?php
$id_set_type = intval($_POST['id_set_type']);
$id_player_1_win = intval($_POST['id_player_1_win']);
$id_player_2_win = $_POST['id_player_2_win'] != '' ? intval($_POST['id_player_2_win']) : 'NULL';
$id_player_1_lose = intval($_POST['id_player_1_lose']);
$id_player_2_lose = $_POST['id_player_2_lose'] != '' ? intval($_POST['id_player_2_lose']) : 'NULL';
ModelSet::add(array('id_set_type' => $id_set_type, 'id_player_1_win' => $id_player_1_win, 'id_player_2_win' => $id_player_2_win, 'id_player_1_lose' => $id_player_1_lose, 'id_player_2_lose' => $id_player_2_lose));
Message::add(array('type' => 'success', 'text' => 'Set ajouté avec succès.'));
Routing::redirect(array('module' => $g_current_module, 'action' => $g_current_action));
ModelSet::add(array('creation_datetime' => '2016-02-04 22:52:08', 'id_set_type' => 4, 'id_player_1_win' => 19, 'id_player_2_win' => 16, 'id_player_1_lose' => 20, 'id_player_2_lose' => 14));
ModelSet::add(array('creation_datetime' => '2016-02-04 22:52:18', 'id_set_type' => 4, 'id_player_1_win' => 19, 'id_player_2_win' => 16, 'id_player_1_lose' => 20, 'id_player_2_lose' => 14));
ModelSet::add(array('creation_datetime' => '2016-02-04 22:52:32', 'id_set_type' => 3, 'id_player_1_win' => 21, 'id_player_2_win' => 9, 'id_player_1_lose' => 22, 'id_player_2_lose' => 23));
ModelSet::add(array('creation_datetime' => '2016-02-04 22:52:41', 'id_set_type' => 3, 'id_player_1_win' => 21, 'id_player_2_win' => 9, 'id_player_1_lose' => 22, 'id_player_2_lose' => 23));
ModelSet::add(array('creation_datetime' => '2016-02-11 22:29:27', 'id_set_type' => 3, 'id_player_1_win' => 16, 'id_player_2_win' => 9, 'id_player_1_lose' => 15, 'id_player_2_lose' => 13));
ModelSet::add(array('creation_datetime' => '2016-02-11 22:30:25', 'id_set_type' => 3, 'id_player_1_win' => 16, 'id_player_2_win' => 9, 'id_player_1_lose' => 15, 'id_player_2_lose' => 13));
ModelSet::add(array('creation_datetime' => '2016-02-11 22:30:50', 'id_set_type' => 3, 'id_player_1_win' => 14, 'id_player_2_win' => 9, 'id_player_1_lose' => 21, 'id_player_2_lose' => 13));
ModelSet::add(array('creation_datetime' => '2016-02-11 22:31:55', 'id_set_type' => 3, 'id_player_1_win' => 14, 'id_player_2_win' => 9, 'id_player_1_lose' => 21, 'id_player_2_lose' => 13));
ModelSet::add(array('creation_datetime' => '2016-02-11 22:32:12', 'id_set_type' => 3, 'id_player_1_win' => 21, 'id_player_2_win' => 9, 'id_player_1_lose' => 14, 'id_player_2_lose' => 13));
ModelSet::add(array('creation_datetime' => '2016-02-11 22:32:48', 'id_set_type' => 3, 'id_player_1_win' => 14, 'id_player_2_win' => 13, 'id_player_1_lose' => 21, 'id_player_2_lose' => 9));
ModelSet::add(array('creation_datetime' => '2016-02-11 22:32:59', 'id_set_type' => 3, 'id_player_1_win' => 14, 'id_player_2_win' => 13, 'id_player_1_lose' => 21, 'id_player_2_lose' => 9));
ModelSet::add(array('creation_datetime' => '2016-02-18 23:25:51', 'id_set_type' => 4, 'id_player_1_win' => 14, 'id_player_2_win' => 15, 'id_player_1_lose' => 16, 'id_player_2_lose' => 28));
ModelSet::add(array('creation_datetime' => '2016-02-18 23:26:07', 'id_set_type' => 4, 'id_player_1_win' => 15, 'id_player_2_win' => 16, 'id_player_1_lose' => 14, 'id_player_2_lose' => 28));
ModelSet::add(array('creation_datetime' => '2016-02-18 23:26:24', 'id_set_type' => 4, 'id_player_1_win' => 14, 'id_player_2_win' => 16, 'id_player_1_lose' => 15, 'id_player_2_lose' => 28));
ModelSet::add(array('creation_datetime' => '2016-02-18 23:26:40', 'id_set_type' => 1, 'id_player_1_win' => 15, 'id_player_2_win' => 'NULL', 'id_player_1_lose' => 14, 'id_player_2_lose' => 'NULL'));
ModelSet::add(array('creation_datetime' => '2016-02-18 23:27:06', 'id_set_type' => 1, 'id_player_1_win' => 14, 'id_player_2_win' => 'NULL', 'id_player_1_lose' => 28, 'id_player_2_lose' => 'NULL'));
ModelSet::add(array('creation_datetime' => '2016-02-18 23:27:14', 'id_set_type' => 1, 'id_player_1_win' => 14, 'id_player_2_win' => 'NULL', 'id_player_1_lose' => 28, 'id_player_2_lose' => 'NULL'));
ModelSet::add(array('creation_datetime' => '2016-02-18 23:27:44', 'id_set_type' => 3, 'id_player_1_win' => 21, 'id_player_2_win' => 9, 'id_player_1_lose' => 16, 'id_player_2_lose' => 10));
ModelSet::add(array('creation_datetime' => '2016-02-18 23:28:19', 'id_set_type' => 3, 'id_player_1_win' => 28, 'id_player_2_win' => 9, 'id_player_1_lose' => 14, 'id_player_2_lose' => 10));
ModelSet::add(array('creation_datetime' => '2016-02-18 23:28:30', 'id_set_type' => 1, 'id_player_1_win' => 16, 'id_player_2_win' => 'NULL', 'id_player_1_lose' => 15, 'id_player_2_lose' => 'NULL'));
ModelSet::add(array('creation_datetime' => '2016-02-25 23:55:56', 'id_set_type' => 3, 'id_player_1_win' => 19, 'id_player_2_win' => 13, 'id_player_1_lose' => 12, 'id_player_2_lose' => 20));
ModelSet::add(array('creation_datetime' => '2016-02-25 23:56:12', 'id_set_type' => 3, 'id_player_1_win' => 19, 'id_player_2_win' => 13, 'id_player_1_lose' => 12, 'id_player_2_lose' => 20));
ModelSet::add(array('creation_datetime' => '2016-02-25 23:57:41', 'id_set_type' => 3, 'id_player_1_win' => 19, 'id_player_2_win' => 12, 'id_player_1_lose' => 13, 'id_player_2_lose' => 20));
ModelSet::add(array('creation_datetime' => '2016-02-25 23:57:57', 'id_set_type' => 3, 'id_player_1_win' => 13, 'id_player_2_win' => 20, 'id_player_1_lose' => 19, 'id_player_2_lose' => 12));
ModelSet::add(array('creation_datetime' => '2016-02-25 23:58:16', 'id_set_type' => 3, 'id_player_1_win' => 19, 'id_player_2_win' => 12, 'id_player_1_lose' => 13, 'id_player_2_lose' => 20));
ModelSet::add(array('creation_datetime' => '2016-02-26 00:00:26', 'id_set_type' => 5, 'id_player_1_win' => 9, 'id_player_2_win' => 12, 'id_player_1_lose' => 13, 'id_player_2_lose' => 10));
ModelSet::add(array('creation_datetime' => '2016-02-26 00:00:59', 'id_set_type' => 5, 'id_player_1_win' => 9, 'id_player_2_win' => 12, 'id_player_1_lose' => 13, 'id_player_2_lose' => 10));
ModelSet::add(array('creation_datetime' => '2016-02-26 00:02:57', 'id_set_type' => 5, 'id_player_1_win' => 9, 'id_player_2_win' => 10, 'id_player_1_lose' => 13, 'id_player_2_lose' => 12));
ModelSet::add(array('creation_datetime' => '2016-02-26 00:03:32', 'id_set_type' => 5, 'id_player_1_win' => 9, 'id_player_2_win' => 10, 'id_player_1_lose' => 13, 'id_player_2_lose' => 12));
ModelSet::add(array('creation_datetime' => '2016-03-03 13:53:48', 'id_set_type' => 2, 'id_player_1_win' => 8, 'id_player_2_win' => 'NULL', 'id_player_1_lose' => 12, 'id_player_2_lose' => 'NULL'));
Database::close();
<?php
include_once 'model/Set.php';
include_once 'model/SetType.php';
$rows = ModelSet::get(array('order_by' => 'creation_datetime desc', 'limit' => 50));
?>
<h2>Liste des sets</h2>
<?php
if (count($rows) > 0) {
?>
<table class="table table-hover table-bordered">
<thead>
<tr>
<!-- <th>N°</th> -->
<th>Joué le</th>
<th>Type</th>
<th colspan="3">Gagnant 1</th>
<th colspan="3">Gagnant 2</th>
<th colspan="3">Perdant 1</th>
<th colspan="3">Perdant 2</th>
<!--
<th>Nb sets initial G1</th>
<th>Nb sets initial G2</th>
<th>Nb sets initial P1</th>
<th>Nb sets initial P2</th>
-->
</tr>
