public function run() { $sColumns = ''; $sColumns .= '{ "mData": "name", "bSortable": true },'; $sColumns .= '{ "mData": "compte", "bSortable": true, "className": "min-tablet", "sWidth": "80px" },'; $sColumns .= '{ "mData": "authority", "bSortable": true, "className": "min-tablet", "sWidth": "100px" },'; $sColumns .= '{ "mData": "playtime", "bSortable": true, "className": "min-desktop", "sWidth": "200px" },'; $sColumns .= '{ "mData": "lastPlay", "bSortable": true, "className": "min-desktop", "sWidth": "120px" },'; $sColumns .= '{ "mData": "status", "bSortable": true, "className": "text-center lineIcon min-desktop", "sWidth": "68px" },'; $sColumns .= '{ "mData": "actions", "bSortable": false, "className": "all", "sWidth": "55px" },'; $sFilterColumns = ''; $sFilterColumns .= '{ type: "text", placeholder: "" },'; $sFilterColumns .= '{ type: "text", placeholder: "" },'; $sFilterColumns .= '{ type: "select", values: [' . \AuthorityHelper::getForDatatableSelect() . '] },'; $sFilterColumns .= 'null,'; $sFilterColumns .= '{ type: "date-range"},'; $sFilterColumns .= '{ type: "select", values: [' . \StatusHelper::getForDatatableSelect(true) . '] },'; $sFilterColumns .= 'null,'; $this->arrayTemplate["dtColumns"] = rtrim($sColumns, ','); $this->arrayTemplate["dtFilterColumns"] = rtrim($sFilterColumns, ','); $this->arrayTemplate["ajaxSource"] = "pages/Admin/modules/GererEquipeJeu/ajax/listGererEquipeJeu.php?sEcho=1"; $view = $this->template->render($this->arrayTemplate); $this->response->setContent($view); $this->response->send(); }
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() { global $request; $mode = $request->query->get("mode"); $objPlayer = null; $objAccount = null; if ($mode == "create") { $objGmList = new \Common\Entity\Gmlist(); } else { if ($mode == "mod") { $id = $request->query->get("idMembre"); $objGmList = \Common\CommonHelper::getGmlistRepository()->find($id); $objPlayer = \Player\PlayerHelper::getPlayerRepository()->findByName($objGmList->getMname()); $objAccount = \Account\AccountHelper::getAccountRepository()->findAccountByLogin($objGmList->getMaccount()); } } $this->arrayTemplate["arrAuthority"] = \AuthorityHelper::getAll(); $this->arrayTemplate["objGmList"] = $objGmList; $this->arrayTemplate["objPlayer"] = $objPlayer; $this->arrayTemplate["objAccount"] = $objAccount; $view = $this->template->render($this->arrayTemplate); $this->response->setContent($view); $this->response->send(); }