public function run()
{
$columnsParameters = array(array('dbField' => 'SupportDiscussionsEntity.idObjet', 'dtField' => 'objet', 'formatter' => function ($d, $row) {
return \SupportObjetsHelper::getLibelle($d);
}), array('dbField' => 'AdminsEntity.name', 'dtField' => 'compte', 'formatter' => function ($d, $row) {
if ($this->isAdmin) {
return $row["user"];
} else {
return $d;
}
}), array('dbField' => 'AccountEntityUser.login', 'dtField' => 'user'), array('dbField' => 'SupportDiscussionsEntity.date', 'dtField' => 'date', 'formatter' => function ($d, $row) {
return \DateTimeHelper::dateTimeToFormatedString($d, "d/m/Y");
}), array('dbField' => 'SupportDiscussionsEntity.dateDernierMessage', 'dtField' => 'lastMessage', 'formatter' => function ($d, $row) {
$firstDate = date("Y-m-d");
$secondDate = $d->format('Y-m-d');
if ($firstDate == $secondDate) {
return \DateTimeHelper::dateTimeToFormatedString($d, "H:i:s");
} else {
return \DateTimeHelper::dateTimeToFormatedString($d);
}
}), array('dbField' => 'SupportMessagesEntity.id', 'dtField' => 'nonLuInDiscussion', 'formatter' => function ($d, $row) {
if ($d === null) {
return "";
} else {
return "lineGreen";
}
}), array('dbField' => 'SupportDiscussionsEntity.id', 'dtField' => 'actions', 'formatter' => function ($d, $row) {
$varButton = '<a class="btn btn-material btn-primary btn-sm" onclick="DiscussionOpen(\'' . \Encryption::encrypt($d) . '\')"><i class="material-icons md-icon-message"></i></a>';
$varButton .= '<a class="btn btn-material btn-warning btn-sm" onclick="DiscussionArchivage(\'' . \Encryption::encrypt($d) . '\', 1)"><i class="material-icons md-icon-archive"></i></a>';
return '<div class="btn-toolbar">' . $varButton . "</div>";
}));
$datatable = new \DataTable();
$datatable->setColumnsParameters($columnsParameters)->setRequest($_GET)->from("\\Site\\Entity\\SupportDiscussions", "SupportDiscussionsEntity")->innerJoin("\\Site\\Entity\\Admins", "AdminsEntity", "WITH", "AdminsEntity.idCompte = SupportDiscussionsEntity.idAdmin")->leftJoin("\\Account\\Entity\\Account", "AccountEntityUser", "WITH", "AccountEntityUser.id = SupportDiscussionsEntity.idCompte")->leftJoin("\\Site\\Entity\\SupportMessages", "SupportMessagesEntity", "WITH", "SupportMessagesEntity.idDiscussion = SupportDiscussionsEntity.id AND SupportMessagesEntity.etat = " . \SupportEtatMessageHelper::NON_LU . " AND SupportMessagesEntity.idCompte != " . $this->objAccount->getId() . "")->andWhere("SupportDiscussionsEntity.idCompte = " . $this->objAccount->getId() . " OR SupportDiscussionsEntity.idAdmin = " . $this->objAccount->getId() . "")->andWhere("SupportDiscussionsEntity.estArchive = 0")->groupBy("SupportDiscussionsEntity.id");
$datatable->getResult()->toJson();
}
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()
{
$columnsParameters = array(array('dbField' => 'AccountEntity.login', 'dtField' => 'compte'), array('dbField' => 'PlayerIndexEntity.empire', 'filterLevel' => 'strict', 'dtField' => 'empire', 'formatter' => function ($d, $row) {
return \FonctionsUtiles::findIconEmpire($d);
}), array('dbField' => ['PlayerEntity1.name', 'PlayerEntity2.name', 'PlayerEntity3.name', 'PlayerEntity4.name'], 'dbSortReplaceField' => ["PlayerEntity1.name" => "PlayerEntity2.name", "PlayerEntity2.name" => "PlayerEntity3.name", "PlayerEntity3.name" => "PlayerEntity4.name", "PlayerEntity4.name" => "PlayerEntity1.name"], 'dbConcatSeparator' => "|VAMOS|", 'dtField' => 'names', 'formatter' => function ($d, $row) {
$arrReturn = array_unique(explode("|VAMOS|", $d));
return implode(", ", $arrReturn);
}), array('dbField' => 'BannissementsActifsEntity.raisonBannissement', 'dtField' => 'raison', 'formatter' => function ($d, $row) {
return \BanRaisonHelper::getLibelle($d);
}), array('dbField' => 'BannissementsActifsEntity.duree', 'filterLevel' => 'strict', 'dtField' => 'duree', 'formatter' => function ($d, $row) {
if ($d == 999) {
return "Définitif";
} else {
return \BanDureeHelper::getLibelle($d);
}
}), array('dbField' => 'AccountEntity.ipCreation', 'dtField' => 'ip'), array('dbField' => 'AccountEntity.id', 'dtField' => 'actions', 'formatter' => function ($d, $row) {
if ($this->HaveTheRight(\DroitsHelper::DEBANNISSEMENT)) {
$varButton = '<a class="btn btn-material btn-success btn-sm" onclick="SuppressionBannissement(' . $d . ')" data-tooltip="Lever"><i class="material-icons md-icon-lock-open"></i></a>';
} else {
$varButton = "";
}
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")->leftJoin("\\Player\\Entity\\Player", "PlayerEntity1", "WITH", "PlayerEntity1.id = PlayerIndexEntity.pid1")->leftJoin("\\Player\\Entity\\Player", "PlayerEntity2", "WITH", "PlayerEntity2.id = PlayerIndexEntity.pid2")->leftJoin("\\Player\\Entity\\Player", "PlayerEntity3", "WITH", "PlayerEntity3.id = PlayerIndexEntity.pid3")->leftJoin("\\Player\\Entity\\Player", "PlayerEntity4", "WITH", "PlayerEntity4.id = PlayerIndexEntity.pid4")->leftJoin("\\Site\\Entity\\BannissementsActifs", "BannissementsActifsEntity", "WITH", "BannissementsActifsEntity.idCompte = AccountEntity.id")->andWhere("AccountEntity.status = '" . \StatusHelper::BANNI . "'");
$datatable->getResult()->toJson();
}
public function run()
{
$columnsParameters = array(array('dbField' => 'ItemshopEntity.nameItem', 'dtField' => 'article'), array('dbField' => 'ItemshopEntity.nbItem', 'dtField' => 'nombre', 'formatter' => function ($d, $row) {
if ($row["type"] == "2") {
if ($d == 9999) {
return "A vie";
} else {
return $d . " jours";
}
} else {
return $d;
}
}), array('dbField' => 'ItemshopCategoriesEntity.nom', 'dtField' => 'categorie'), array('dbField' => 'ItemshopEntity.prix', 'filterLevel' => 'strict', 'dtField' => 'prix', 'formatter' => function ($d, $row) {
if ($row["type"] == "1") {
return number_format($d, 0, ",", " ") . " <span style='position: relative; top:3px;'>" . \FonctionsUtiles::findIconDevise(\DeviseHelper::CASH) . "</span>";
} elseif ($row["type"] == "2") {
return number_format($d, 0, ",", " ") . " <span style='position: relative; top:3px;'>" . \FonctionsUtiles::findIconDevise(\DeviseHelper::CASH) . "</span>";
} elseif ($row["type"] == "3") {
return number_format($d, 0, ",", " ") . " <span style='position: relative; top:3px;'>" . \FonctionsUtiles::findIconDevise(\DeviseHelper::MILEAGE);
}
}), array('dbField' => 'ItemshopEntity.type', 'dtField' => 'type'), array('dbField' => 'ItemshopEntity.estImportant', 'dtField' => 'estImportant', 'formatter' => function ($d, $row) {
if ($d == 1) {
return "important";
} else {
return "";
}
}), array('dbField' => 'ItemshopEntity.id', 'dtField' => 'actions', 'formatter' => function ($d, $row) {
$varButton = '<a class="btn btn-material btn-primary btn-sm" data-featherlight="ajax" href="pages/Admin/modules/GererItemShop/GererItemShopArticlesEdit.php?mode=mod&idArticle=' . $d . '"><i class="material-icons md-icon-edit"></i></a>';
$varButton .= '<a class="btn btn-material btn-danger btn-sm" onclick="SuppressionArticle(' . $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("\\Site\\Entity\\Itemshop", "ItemshopEntity")->leftJoin("\\Site\\Entity\\ItemshopCategories", "ItemshopCategoriesEntity", "WITH", "ItemshopCategoriesEntity.id = ItemshopEntity.cat");
$datatable->getResult()->toJson();
}
public function run()
{
$columnsParameters = array(array('dbField' => 'ItemshopCategoriesEntity.nom', 'dtField' => 'categorie'), array('dbField' => 'ItemshopCategoriesEntity.description', 'dtField' => 'description'), array('dbField' => 'ItemshopCategoriesEntity.id', 'dtField' => 'actions', 'formatter' => function ($d, $row) {
$varButton = '<a class="btn btn-material btn-primary btn-sm" data-featherlight="ajax" href="pages/Admin/modules/GererItemShop/GererItemShopCategoriesEdit.php?mode=mod&idCategorie=' . $d . '"><i class="material-icons md-icon-edit"></i></a>';
$varButton .= '<a class="btn btn-material btn-danger btn-sm" onclick="SuppressionCategorie(' . $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("\\Site\\Entity\\ItemshopCategories", "ItemshopCategoriesEntity");
$datatable->getResult()->toJson();
}
public function run()
{
$columnsParameters = array(array('dbField' => 'AccountEntity.login', 'dtField' => 'compte'), array('dbField' => 'AdminsEntity.name', 'dtField' => 'nom'), array('dbField' => 'AdminsEntity.id', 'dtField' => 'actions', 'formatter' => function ($d, $row) {
$varButton = '<a class="btn btn-material btn-primary btn-sm" data-featherlight="ajax" data-featherlight-variant="featherLightbox_90" href="pages/Admin/modules/GererEquipeSite/GererEquipeSiteEdit.php?mode=mod&idAdmins=' . $d . '"><i class="material-icons md-icon-edit"></i></a>';
$varButton .= '<a class="btn btn-material btn-danger btn-sm " onclick="SuppressionMembreEquipeSite(' . $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("\\Site\\Entity\\Admins", "AdminsEntity")->innerJoin("\\Account\\Entity\\Account", "AccountEntity", "WITH", "AccountEntity.id = AdminsEntity.idCompte");
$datatable->getResult()->toJson();
}
public function run()
{
$columnsParameters = array(array('dbField' => 'LogsItemshopAchatsEntity.date', 'dtField' => 'date', 'formatter' => function ($d, $row) {
return \DateTimeHelper::dateTimeToFormatedString($d);
}), array('dbField' => 'LogsItemshopAchatsEntity.item', 'dtField' => 'article'), array('dbField' => 'LogsItemshopAchatsEntity.quantite', 'filterLevel' => 'strict', 'dtField' => 'quantite'), array('dbField' => 'LogsItemshopAchatsEntity.devise', 'dtField' => 'devise'), array('dbField' => 'LogsItemshopAchatsEntity.prix', 'filterLevel' => 'strict', 'dtField' => 'prix', 'formatter' => function ($d, $row) {
return number_format($d, 0, '.', ',') . "<span style='position:relative; top:2px;'>" . \FonctionsUtiles::findIconDevise($row["devise"]) . "</span>";
}), array('dbField' => 'AccountEntity.login', 'dtField' => 'compte'), array('dbField' => 'LogsItemshopAchatsEntity.resultat', 'dtField' => 'result'));
$datatable = new \DataTable();
$datatable->setColumnsParameters($columnsParameters)->setRequest($_GET)->from("\\Site\\Entity\\LogsItemshopAchats", "LogsItemshopAchatsEntity")->leftJoin("\\Account\\Entity\\Account", "AccountEntity", "WITH", "AccountEntity.id = LogsItemshopAchatsEntity.idCompte");
$datatable->getResult()->toJson();
}
public function run()
{
$columnsParameters = array(array('dbField' => 'ActualitesEntity.date', 'dtField' => 'date', 'formatter' => function ($d, $row) {
return \DateTimeHelper::dateTimeToFormatedString($d);
}), array('dbField' => 'ActualitesEntity.titre', 'dtField' => 'titre'), array('dbField' => 'ActualitesEntity.contenu', 'dtField' => 'message', 'formatter' => function ($d, $row) {
return \FonctionsUtiles::Raccourcissement_Chaine($d, 50);
}), array('dbField' => 'AccountEntity.login', 'dtField' => 'compte'), array('dbField' => 'ActualitesEntity.id', 'dtField' => 'actions', 'formatter' => function ($d, $row) {
$varButton = '<a class="btn btn-material btn-primary btn-sm" data-featherlight="ajax" href="pages/Admin/GererNewsEdit.php?mode=mod&idNews=' . $d . '"><i class="material-icons md-icon-edit"></i></a>';
$varButton .= '<a class="btn btn-material btn-danger btn-sm" onclick="SuppressionNews(' . $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("\\Site\\Entity\\Actualites", "ActualitesEntity")->leftJoin("\\Account\\Entity\\Account", "AccountEntity", "WITH", "AccountEntity.id = ActualitesEntity.idCompte");
$datatable->getResult()->toJson();
}
public function run()
{
$columnsParameters = array(array('dbField' => 'SupportDiscussionsEntity.idObjet', 'dtField' => 'objet', 'formatter' => function ($d, $row) {
return \SupportObjetsHelper::getLibelle($d);
}), array('dbField' => 'AdminsEntity.name', 'dtField' => 'compte', 'formatter' => function ($d, $row) {
if ($this->isAdmin) {
return $row["user"];
} else {
return $d;
}
}), array('dbField' => 'AccountEntityUser.login', 'dtField' => 'user'), array('dbField' => 'SupportDiscussionsEntity.date', 'dtField' => 'date', 'formatter' => function ($d, $row) {
return \DateTimeHelper::dateTimeToFormatedString($d, "d/m/Y");
}), array('dbField' => 'SupportDiscussionsEntity.id', 'dtField' => 'actions', 'formatter' => function ($d, $row) {
$varButton = '<a class="btn btn-material btn-primary btn-sm" onclick="DiscussionOpen(\'' . \Encryption::encrypt($d) . '\')"><i class="material-icons md-icon-search"></i></a>';
return '<div class="btn-toolbar">' . $varButton . "</div>";
}));
$datatable = new \DataTable();
$datatable->setColumnsParameters($columnsParameters)->setRequest($_GET)->from("\\Site\\Entity\\SupportDiscussions", "SupportDiscussionsEntity")->innerJoin("\\Site\\Entity\\Admins", "AdminsEntity", "WITH", "AdminsEntity.idCompte = SupportDiscussionsEntity.idAdmin")->leftJoin("\\Account\\Entity\\Account", "AccountEntityUser", "WITH", "AccountEntityUser.id = SupportDiscussionsEntity.idCompte")->andWhere("SupportDiscussionsEntity.idCompte = " . $this->objAccount->getId() . " OR SupportDiscussionsEntity.idAdmin = " . $this->objAccount->getId() . "")->andWhere("SupportDiscussionsEntity.estArchive = 1");
$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 run()
{
$columnsParameters = array(array('dbField' => 'LogsAdminGererMonnaieEntity.idCompte', 'dtField' => 'idCompte'), array('dbField' => 'AccountEntityUser.login', 'dtField' => 'recepteur', 'formatter' => function ($d, $row) {
if ($row["idCompte"] == 0) {
return "Tout le monde";
} else {
return $d;
}
}), array('dbField' => 'LogsAdminGererMonnaieEntity.date', 'dtField' => 'date', 'formatter' => function ($d, $row) {
return \DateTimeHelper::dateTimeToFormatedString($d);
}), array('dbField' => 'AccountEntityAdmin.login', 'dtField' => 'emetteur'), array('dbField' => 'LogsAdminGererMonnaieEntity.operation', 'filterLevel' => 'strict', 'dtField' => 'operation', 'formatter' => function ($d, $row) {
if ($d == 1) {
return "a donné";
} else {
return "a enlevé";
}
}), array('dbField' => 'LogsAdminGererMonnaieEntity.montant', 'filterLevel' => 'strict', 'dtField' => 'montant'), array('dbField' => 'LogsAdminGererMonnaieEntity.devise', 'filterLevel' => 'strict', 'dtField' => 'devise', 'formatter' => function ($d, $row) {
return \DeviseHelper::getLibelle($d);
}));
$datatable = new \DataTable();
$datatable->setColumnsParameters($columnsParameters)->setRequest($_GET)->from("\\Site\\Entity\\LogsAdminGererMonnaie", "LogsAdminGererMonnaieEntity")->leftJoin("\\Account\\Entity\\Account", "AccountEntityUser", "WITH", "AccountEntityUser.id = LogsAdminGererMonnaieEntity.idCompte")->innerJoin("\\Account\\Entity\\Account", "AccountEntityAdmin", "WITH", "AccountEntityAdmin.id = LogsAdminGererMonnaieEntity.idGm");
$datatable->getResult()->toJson();
}
public function run()
{
$columnsParameters = array(array('dbField' => 'GuildEntity1.name', 'filterLevel' => 'strict', 'dtField' => 'firstGuild', 'formatter' => function ($d, $row) {
return \FonctionsUtiles::findIconEmpire($row["firstEmpire"]) . " " . $d;
}), array('dbField' => 'GuildEntity2.name', 'filterLevel' => 'strict', 'dtField' => 'secondGuild', 'formatter' => function ($d, $row) {
return \FonctionsUtiles::findIconEmpire($row["secondEmpire"]) . " " . $d;
}), array('dbField' => 'PlayerMaster1Entity.name', 'dtField' => 'firstChef'), array('dbField' => 'GuildWarReservationEntity.time', 'dbConcatSeparator' => ", ", 'dtField' => 'date', 'formatter' => function ($d, $row) {
return \DateTimeHelper::dateTimeToFormatedString($d);
}), array('dbField' => 'PlayerMaster2Entity.name', 'dtField' => 'secondChef'), array('dbField' => 'GuildWarReservationEntity.result1', 'dtField' => 'result1'), array('dbField' => 'GuildWarReservationEntity.result2', 'dtField' => 'result2'), array('dbField' => 'GuildEntityWin.name', 'filterLevel' => 'strict', 'dtField' => 'winner', 'formatter' => function ($d, $row) {
if ($row["result1"] > $row["result2"]) {
return $d . " (<span class='text-green'>" . $row["result1"] . "</span> / <span class='text-red'>" . $row["result2"] . "</span>)";
} else {
if ($row["result1"] < $row["result2"]) {
return $d . " (<span class='text-green'>" . $row["result2"] . "</span> / <span class='text-red'>" . $row["result1"] . "</span>)";
} else {
return "Match nul";
}
}
}), array('dbField' => 'PlayerIndexMaster1Entity.empire', 'dtField' => 'firstEmpire'), array('dbField' => 'PlayerIndexMaster2Entity.empire', 'dtField' => 'secondEmpire'));
$datatable = new \DataTable();
$datatable->setColumnsParameters($columnsParameters)->setRequest($_GET)->from("\\Player\\Entity\\GuildWarReservation", "GuildWarReservationEntity")->leftJoin("\\Player\\Entity\\Guild", "GuildEntity1", "WITH", "GuildEntity1.id = GuildWarReservationEntity.guild1")->leftJoin("\\Player\\Entity\\Guild", "GuildEntity2", "WITH", "GuildEntity2.id = GuildWarReservationEntity.guild2")->leftJoin("\\Player\\Entity\\Guild", "GuildEntityWin", "WITH", "GuildEntityWin.id = GuildWarReservationEntity.winner")->innerJoin("\\Player\\Entity\\Player", "PlayerMaster1Entity", "WITH", "PlayerMaster1Entity.id = GuildEntity1.master")->innerJoin("\\Player\\Entity\\Player", "PlayerMaster2Entity", "WITH", "PlayerMaster2Entity.id = GuildEntity2.master")->leftJoin("\\Account\\Entity\\Account", "AccountMaster1Entity", "WITH", "AccountMaster1Entity.id = PlayerMaster1Entity.idAccount")->leftJoin("\\Account\\Entity\\Account", "AccountMaster2Entity", "WITH", "AccountMaster2Entity.id = PlayerMaster2Entity.idAccount")->leftJoin("\\Player\\Entity\\PlayerIndex", "PlayerIndexMaster1Entity", "WITH", "PlayerIndexMaster1Entity.id = AccountMaster1Entity.id")->leftJoin("\\Player\\Entity\\PlayerIndex", "PlayerIndexMaster2Entity", "WITH", "PlayerIndexMaster2Entity.id = AccountMaster2Entity.id");
$datatable->getResult()->toJson();
}
