public function run()
{
if ($_GET["sEcho"] == 1) {
exit;
}
$columnsParameters = array(array('dbField' => 'AccountEntity.login', 'dtField' => 'compte'), array('dbField' => 'AccountEntity.email', 'dtField' => 'email'), array('dbField' => 'AccountEntity.cash', 'dtField' => 'cash', 'formatter' => function ($d, $row) {
return number_format($d, 0, '.', ',') . "<span style='position:relative; top:2px;'>" . \FonctionsUtiles::findIconDevise(\DeviseHelper::CASH) . "</span>";
}), array('dbField' => 'AccountEntity.mileage', 'dtField' => 'mileage', 'formatter' => function ($d, $row) {
return number_format($d, 0, '.', ',') . "<span style='position:relative; top:2px;'>" . \FonctionsUtiles::findIconDevise(\DeviseHelper::MILEAGE) . "</span>";
}), array('dbField' => 'PlayerIndexEntity.empire', 'filterLevel' => 'strict', 'dtField' => 'empire', 'formatter' => function ($d, $row) {
return \FonctionsUtiles::findIconEmpire($d);
}), array('dbField' => 'AccountEntity.status', 'filterLevel' => 'strict', 'dtField' => 'status', 'formatter' => function ($d, $row) {
return \FonctionsUtiles::findIconStatus($d);
}), array('dbField' => 'AccountEntity.ipCreation', 'dtField' => 'ip'), array('dbField' => 'AccountEntity.id', 'dtField' => 'actions', 'formatter' => function ($d, $row) {
$varButton = "";
if ($row["status"] == \StatusHelper::ACTIF) {
if ($this->HaveTheRight(\DroitsHelper::BANNISSEMENT)) {
$varButton = '<a class="btn btn-material btn-danger btn-sm" data-featherlight="ajax" href="pages/Admin/BannissementAddForm.php?idAccount=' . $d . '" data-tooltip="Bannir"><i class="material-icons md-icon-lock"></i></a>';
}
}
return '<div class="btn-toolbar">' . $varButton . "</div>";
}));
$datatable = new \DataTable();
$datatable->setColumnsParameters($columnsParameters)->setRequest($_GET)->from("\\Account\\Entity\\Account", "AccountEntity")->leftJoin("\\Player\\Entity\\PlayerIndex", "PlayerIndexEntity", "WITH", "PlayerIndexEntity.id = AccountEntity.id");
$datatable->getResult()->toJson();
}
public function run()
{
if ($_GET["sEcho"] == 1) {
exit;
}
$columnsParameters = array(array('dbField' => 'GuildEntity.name', 'dtField' => 'name'), array('dbField' => 'GuildEntity.level', 'filterLevel' => 'strict', 'dtField' => 'level'), array('dbField' => ["GuildEntity.victoire", "GuildEntity.defaite", "GuildEntity.egalite"], 'dbSortReplaceField' => [], 'dbConcatSeparator' => "|VAMOS|", 'dtField' => 'scores', 'formatter' => function ($d, $row) {
$explosion = explode("|VAMOS|", $d);
$scores = "<span class='text-green'>" . $explosion[0] . "</span>";
$scores .= " / <span class='text-red'>" . $explosion[1] . "</span>";
$scores .= " / <span>" . $explosion[2] . "</span>";
return $scores;
}), array('dbField' => 'AccountEntity.login', 'dtField' => 'chef'), array('dbField' => 'PlayerIndexEntity.empire', 'filterLevel' => 'strict', 'dtField' => 'empire', 'formatter' => function ($d, $row) {
return \FonctionsUtiles::findIconEmpire($d);
}), array('dbField' => 'AccountEntity.status', 'filterLevel' => 'strict', 'dtField' => 'status', 'formatter' => function ($d, $row) {
return \FonctionsUtiles::findIconStatus($d);
}));
$datatable = new \DataTable();
$datatable->setColumnsParameters($columnsParameters)->setRequest($_GET)->from("\\Player\\Entity\\Guild", "GuildEntity")->innerJoin("\\Account\\Entity\\Account", "AccountEntity", "WITH", "AccountEntity.id = GuildEntity.master")->innerJoin("\\Player\\Entity\\PlayerIndex", "PlayerIndexEntity", "WITH", "PlayerIndexEntity.id = AccountEntity.id");
$datatable->getResult()->toJson();
}
public function run()
{
$columnsParameters = array(array('dbField' => 'PlayerEntity.name', 'dtField' => 'name', 'formatter' => function ($d, $row) {
return \FonctionsUtiles::findIconJob($row["job"]) . " " . $d;
}), array('dbField' => 'AccountEntity.login', 'dtField' => 'compte'), array('dbField' => 'PlayerEntity.job', 'dtField' => 'job'), array('dbField' => 'GmlistEntity.mauthority', 'dtField' => 'authority', 'formatter' => function ($d, $row) {
return \AuthorityHelper::getLibelle($d);
}), array('dbField' => 'PlayerEntity.playtime', 'dtField' => 'playtime', 'formatter' => function ($d, $row) {
return \DateTimeHelper::minutesToString($d);
}), array('dbField' => 'PlayerEntity.lastPlay', 'dtField' => 'lastPlay', 'formatter' => function ($d, $row) {
return \DateTimeHelper::dateTimeToFormatedString($d);
}), array('dbField' => 'AccountEntity.status', 'filterLevel' => 'strict', 'dtField' => 'status', 'formatter' => function ($d, $row) {
return \FonctionsUtiles::findIconStatus($d);
}), array('dbField' => 'PlayerEntity.ip', 'dtField' => 'ip'), array('dbField' => 'GmlistEntity.mid', 'dtField' => 'actions', 'formatter' => function ($d, $row) {
$varButton = '<a class="btn btn-material btn-primary btn-sm" data-featherlight="ajax" href="pages/Admin/modules/GererEquipeJeu/GererEquipeJeuEdit.php?mode=mod&idMembre=' . $d . '"><i class="material-icons md-icon-edit"></i></a>';
$varButton .= '<a class="btn btn-material btn-danger btn-sm " onclick="SuppressionMembreEquipe(' . $d . ')"><i class="material-icons md-icon-delete"></i></a>';
return '<div class="btn-toolbar">' . $varButton . "</div>";
}));
$datatable = new \DataTable();
$datatable->setColumnsParameters($columnsParameters)->setRequest($_GET)->from("\\Common\\Entity\\Gmlist", "GmlistEntity")->innerJoin("\\Player\\Entity\\Player", "PlayerEntity", "WITH", "PlayerEntity.name = GmlistEntity.mname")->innerJoin("\\Account\\Entity\\Account", "AccountEntity", "WITH", "AccountEntity.login = GmlistEntity.maccount");
$datatable->getResult()->toJson();
}
public function findIconStatus($status = "")
{
return \FonctionsUtiles::findIconStatus($status);
}
