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' => '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' => '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(); }