function clm_api_db_logging() { $table = '#__clm_logging'; $primaryKey = 'id'; $columns = array(array('db' => 'id', 'dt' => 0), array('db' => 'type', 'dt' => 1), array('db' => 'name', 'dt' => 2), array('db' => 'content', 'dt' => 3), array('db' => 'timestamp', 'dt' => 4), array('db' => 'userid', 'dt' => 5), array('db' => 'callid', 'dt' => 6), array('db' => 'id', 'dt' => 7)); $allowed = array("type" => "i"); $out = clm_class_DataTables::simple($_POST, $table, $primaryKey, $columns, $allowed, clm_core::$db); $lang = clm_core::$lang->logging; for ($i = 0; $i < count($out["data"]); $i++) { $out["data"][$i][0] = $i + 1; if (!clm_core::$db->user->get($out["data"][$i][5])->isNew()) { $out["data"][$i][5] = clm_core::$db->user->get($out["data"][$i][5])->username; } $out["data"][$i][4] = date("d.m.y H:i:s", $out["data"][$i][4]); $result = clm_class_log::refactor($out["data"][$i][1], $out["data"][$i][2], $out["data"][$i][3]); $out["data"][$i][1] = $result[0]; $out["data"][$i][2] = $result[1]; $out["data"][$i][3] = $result[2]; } return array(true, "m_tableSuccess", $out); }
function clm_api_db_tournament_group() { $table = '#__clm_liga'; $primaryKey = 'id'; $columns = array(array('db' => 'id', 'dt' => 0), array('db' => 'name', 'dt' => 1), array('db' => 'sid', 'dt' => 2), array('db' => 'runden_modus', 'dt' => 3), array('db' => 'runden', 'dt' => 4), array('db' => 'teil', 'dt' => 5), array('db' => 'stamm', 'dt' => 6), array('db' => 'sl', 'dt' => 7), array('db' => 'bemerkungen', 'dt' => 8), array('db' => 'mail', 'dt' => 9), array('db' => 'id', 'dt' => 10), array('db' => 'rnd', 'dt' => 11), array('db' => 'published', 'dt' => 12), array('db' => 'ordering', 'dt' => 13), array('db' => 'id', 'dt' => 14)); // Erzwinge Filter bei unzureichenden Berechtigungen if (clm_core::$access->access('BE_league_general') == 1 && clm_core::$access->access('BE_teamtournament_general') == 0) { if (in_array('liga_mt', $_POST["names"])) { $_POST["values"][array_search("liga_mt", $_POST["names"])] = "0"; } else { $_POST["names"][] = "liga_mt"; $_POST["values"][] = "0"; } } else { if (clm_core::$access->access('BE_league_general') == 0 && clm_core::$access->access('BE_teamtournament_general') == 1) { if (in_array('liga_mt', $_POST["names"])) { $_POST["values"][array_search("liga_mt", $_POST["names"])] = "1"; } else { $_POST["names"][] = "liga_mt"; $_POST["values"][] = "1"; } } } $allowed = array("runden_modus" => "i", "published" => "i", "sid" => "i", "catidAlltime:catidEdition" => "i", "liga_mt" => "i"); $out = clm_class_DataTables::simple($_POST, $table, $primaryKey, $columns, $allowed, clm_core::$db); $lang = clm_core::$lang->tournament_group; $clmAccess = clm_core::$access; for ($i = 0; $i < count($out["data"]); $i++) { if (clm_core::$db->liga->get($out["data"][$i][0])->liga_mt == 0) { $right = "league"; $section = "ligen"; } else { $right = "teamtournament"; $section = "mturniere"; } $out["data"][$i][0] = $i + 1; $out["data"][$i][1] = clm_class_category::name($out["data"][$i][14], true); if (!($out["data"][$i][7] != $clmAccess->getJid() and $clmAccess->access('BE_' . $right . '_edit_detail') !== true or $clmAccess->access('BE_' . $right . '_edit_detail') === false)) { //$out["data"][$i][1] = '<a href="'.clm_core::$load->gen_url(array("section"=>"ligen","task"=>"edit","cid[]"=>$out["data"][$i][14]),array("view")).'">'.$out["data"][$i][1].'</a>'; $out["data"][$i][1] = '<a href="' . clm_core::$load->gen_url(array("section" => $section, "task" => "edit", "cid[]" => $out["data"][$i][14]), array("view")) . '">' . $out["data"][$i][1] . '</a>'; } // Saisonname statt sid Anzeigen $sid = intval($out["data"][$i][2]); $out["data"][$i][2] = clm_core::$db->saison->get($sid)->name; // Modus ID in Name umsetzen $out["data"][$i][3] = clm_core::$load->mode_to_name(intval($out["data"][$i][3]), true); // Runden mit Bestätigung/sl_ok // eingetragene Teilnehmer $query = 'SELECT COUNT(id)' . ' FROM #__clm_runden_termine' . ' WHERE liga = ' . $out["data"][$i][14] . ' AND sl_ok = \'1\''; // Durchläufe Anzeigen if (clm_core::$db->liga->get($out["data"][$i][14])->durchgang > 1) { $out["data"][$i][4] = clm_core::$db->liga->get($out["data"][$i][14])->durchgang . " x " . $out["data"][$i][4]; } if (!($out["data"][$i][7] != $clmAccess->getJid() and $clmAccess->access('BE_' . $right . '_edit_detail') !== true or $clmAccess->access('BE_' . $right . '_edit_detail') === false) and $out["data"][$i][11] == 1) { $out["data"][$i][4] = '<a href="' . clm_core::$load->gen_url(array("section" => "runden", "liga" => $out["data"][$i][14]), array("view")) . '">' . $out["data"][$i][4] . " " . $lang->rounds . '</a>' . "<br/>" . $lang->open . clm_core::$db->count($query) . " " . $lang->confirmed . $lang->close; } else { $out["data"][$i][4] = $out["data"][$i][4] . " " . $lang->rounds . "<br/>" . $lang->open . clm_core::$db->count($query) . " " . $lang->confirmed . $lang->close; } // Stammspieler + Ersatzspieler $out["data"][$i][6] = $out["data"][$i][6] . " " . $lang->open . $lang->plus . " " . clm_core::$db->liga->get($out["data"][$i][14])->ersatz . $lang->close; // Turnierleiter $query = 'SELECT name' . ' FROM #__clm_user' . ' WHERE jid = ' . $out["data"][$i][7] . ' AND sid = ' . $sid; $result = clm_core::$db->loadAssocList($query); if (count($result) == 1) { $out["data"][$i][7] = $result[0]["name"]; } else { $out["data"][$i][7] = "-"; } if ($out["data"][$i][8] == "") { $out["data"][$i][8] = $lang->column9_no; } else { $out["data"][$i][8] = '<a href="javascript:void(0);" onclick=\'clm_modal_display("' . htmlspecialchars($out["data"][$i][8], ENT_QUOTES, "UTF-8") . '")\' href="javascript:;" >' . $lang->column9_yes . '</a>'; } // Mail if ($out["data"][$i][9] == 1) { $out["data"][$i][9] = '<button class="clm_table_image " value=\'["db_tournament_publish",[' . $out["data"][$i][14] . ',false,true,"mail"]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>'; } else { $out["data"][$i][9] = '<button class="clm_table_image" value=\'["db_tournament_publish",[' . $out["data"][$i][14] . ',true,true,"mail"]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>'; } // DWZ berechnet $params = clm_core::$db->liga->get($out["data"][$i][10])->params; $params = new clm_class_params($params); if ($params->get("inofDWZ", "0") == "1") { $out["data"][$i][10] = '<button class="clm_table_image" value=\'["db_tournament_delDWZ",[' . $out["data"][$i][14] . ',true]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>'; } else { $out["data"][$i][10] = '<button class="clm_table_image" value=\'["db_tournament_genDWZ",[' . $out["data"][$i][14] . ',true]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>'; } // Runden if ($out["data"][$i][11] == 1) { $out["data"][$i][11] = '<button class="clm_table_image " value=\'["db_tournament_delRounds",[' . $out["data"][$i][14] . ',true]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>'; } else { $out["data"][$i][11] = '<button class="clm_table_image" value=\'["db_tournament_genRounds",[' . $out["data"][$i][14] . ',true]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>'; } // Veröffentlicht if ($out["data"][$i][12] == 1) { $out["data"][$i][12] = '<button class="clm_table_image " value=\'["db_tournament_publish",[' . $out["data"][$i][14] . ',false,true]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>'; } else { $out["data"][$i][12] = '<button class="clm_table_image" value=\'["db_tournament_publish",[' . $out["data"][$i][14] . ',true,true]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>'; } $out["data"][$i][13] = '<input class="clm_table_orderingBox" onkeypress="return clm_isChangeNumber(event);" value="' . $out["data"][$i][13] . '" type="text">'; $out["data"][$i][13] .= '<input class="clm_table_orderingId" value="' . $out["data"][$i][14] . '" type="hidden">'; } return array(true, "m_tableSuccess", $out); }
function clm_api_db_tournament() { $table = '#__clm_turniere'; $primaryKey = 'id'; $columns = array(array('db' => 'id', 'dt' => 0), array('db' => 'name', 'dt' => 1), array('db' => 'sid', 'dt' => 2), array('db' => 'dateStart', 'dt' => 3), array('db' => 'invitationText', 'dt' => 4), array('db' => 'vereinZPS', 'dt' => 5), array('db' => 'typ', 'dt' => 6), array('db' => 'runden', 'dt' => 7), array('db' => 'teil', 'dt' => 8), array('db' => 'tl', 'dt' => 9), array('db' => 'id', 'dt' => 10), array('db' => 'rnd', 'dt' => 11), array('db' => 'published', 'dt' => 12), array('db' => 'ordering', 'dt' => 13), array('db' => 'id', 'dt' => 14)); $allowed = array("typ" => "i", "published" => "i", "sid" => "i", "catidAlltime:catidEdition" => "i"); $out = clm_class_DataTables::simple($_POST, $table, $primaryKey, $columns, $allowed, clm_core::$db); $lang = clm_core::$lang->tournament; $clmAccess = clm_core::$access; for ($i = 0; $i < count($out["data"]); $i++) { $out["data"][$i][0] = $i + 1; $out["data"][$i][1] = clm_class_category::name($out["data"][$i][14], false); if (!($out["data"][$i][9] != $clmAccess->getJid() and $clmAccess->access('BE_tournament_edit_detail') !== true or $clmAccess->access('BE_tournament_edit_detail') === false)) { $out["data"][$i][1] = '<a href="' . clm_core::$load->gen_url(array("view" => "turform", "task" => "edit", "id" => $out["data"][$i][14])) . '">' . $out["data"][$i][1] . '</a>'; } // Saisonname statt sid Anzeigen $sid = intval($out["data"][$i][2]); $out["data"][$i][2] = clm_core::$db->saison->get($sid)->name; // dateStart durch dateStart und dateEnd ersetzen if (clm_core::$db->turniere->get($out["data"][$i][14])->dateStart != '0000-00-00') { $out["data"][$i][3] = clm_core::$load->date_to_string(clm_core::$db->turniere->get($out["data"][$i][14])->dateStart, false, true); if (clm_core::$db->turniere->get($out["data"][$i][14])->dateEnd != '0000-00-00') { $out["data"][$i][3] .= " " . $lang->until . " " . clm_core::$load->date_to_string(clm_core::$db->turniere->get($out["data"][$i][14])->dateEnd, false, true); } } else { $out["data"][$i][3] = $lang->unknownDate; } // Veranstalter / Ausrichter $out["data"][$i][5] = clm_core::$load->zps_to_district($out["data"][$i][5]); if (clm_core::$db->turniere->get($out["data"][$i][14])->bezirkTur == 1) { $out["data"][$i][5] = $lang->districtEvent . ($out["data"][$i][5] != "" ? "<br />" . $out["data"][$i][5] : ""); } // Ausschreibung if ($out["data"][$i][4] == "") { $out["data"][$i][4] = $lang->column3_no; } else { $out["data"][$i][4] = $lang->column3_yes; } if (!($out["data"][$i][9] != $clmAccess->getJid() and $clmAccess->access('BE_tournament_edit_detail') !== true or $clmAccess->access('BE_tournament_edit_detail') === false)) { $out["data"][$i][4] = '<a href="' . clm_core::$load->gen_url(array("view" => "turinvite", "task" => "edit", "id" => $out["data"][$i][14])) . '">' . $out["data"][$i][4] . '</a>'; } // Modus ID in Name umsetzen $out["data"][$i][6] = clm_core::$load->mode_to_name(intval($out["data"][$i][6]), false); // eingetragene Teilnehmer $query = 'SELECT COUNT(id)' . ' FROM #__clm_turniere_tlnr' . ' WHERE turnier = ' . $out["data"][$i][14]; if (!($out["data"][$i][9] != $clmAccess->getJid() and $clmAccess->access('BE_tournament_edit_detail') !== true or $clmAccess->access('BE_tournament_edit_detail') === false)) { $out["data"][$i][8] = '<a href="' . clm_core::$load->gen_url(array("view" => "turplayers", "task" => "edit", "id" => $out["data"][$i][14])) . '">' . $out["data"][$i][8] . " " . $lang->player . '</a>' . "<br/>" . $lang->open . clm_core::$db->count($query) . " " . $lang->registered . $lang->close; } else { $out["data"][$i][8] = $out["data"][$i][8] . " " . $lang->player . "<br/>" . $lang->open . clm_core::$db->count($query) . " " . $lang->registered . $lang->close; } // Runden mit Bestätigung/tl_ok // eingetragene Teilnehmer $query = 'SELECT COUNT(id)' . ' FROM #__clm_turniere_rnd_termine' . ' WHERE turnier = ' . $out["data"][$i][14] . ' AND tl_ok = \'1\''; // Durchläufe Anzeigen if (clm_core::$db->turniere->get($out["data"][$i][14])->dg > 1) { $out["data"][$i][7] = clm_core::$db->turniere->get($out["data"][$i][14])->dg . " x " . $out["data"][$i][7]; } if (!($out["data"][$i][9] != $clmAccess->getJid() and $clmAccess->access('BE_tournament_edit_detail') !== true or $clmAccess->access('BE_tournament_edit_detail') === false)) { $out["data"][$i][7] = '<a href="' . clm_core::$load->gen_url(array("view" => "turrounds", "task" => "edit", "id" => $out["data"][$i][14])) . '">' . $out["data"][$i][7] . " " . $lang->rounds . '</a>' . "<br/>" . $lang->open . clm_core::$db->count($query) . " " . $lang->confirmed . $lang->close; } else { $out["data"][$i][7] = $out["data"][$i][7] . " " . $lang->rounds . "<br/>" . $lang->open . clm_core::$db->count($query) . " " . $lang->confirmed . $lang->close; } // Turnierleiter $query = 'SELECT name' . ' FROM #__clm_user' . ' WHERE jid = ' . $out["data"][$i][9] . ' AND sid = ' . $sid; $result = clm_core::$db->loadAssocList($query); if (count($result) == 1) { $out["data"][$i][9] = $result[0]["name"]; } else { $out["data"][$i][9] = "-"; } // DWZ berechnet $params = clm_core::$db->turniere->get($out["data"][$i][10])->params; $params = new clm_class_params($params); if ($params->get("inofDWZ", "0") == "1") { $out["data"][$i][10] = '<button class="clm_table_image" value=\'["db_tournament_delDWZ",[' . $out["data"][$i][14] . ',false]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>'; } else { $out["data"][$i][10] = '<button class="clm_table_image" value=\'["db_tournament_genDWZ",[' . $out["data"][$i][14] . ',false]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>'; } // Runden freigegeben if ($out["data"][$i][11] == 1) { $out["data"][$i][11] = '<button class="clm_table_image clm_button_del_danger" value=\'["db_tournament_delRounds",[' . $out["data"][$i][14] . ',false]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>'; } else { $out["data"][$i][11] = '<button class="clm_table_image" value=\'["db_tournament_genRounds",[' . $out["data"][$i][14] . ',false]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>'; } // Veröffentlicht if ($out["data"][$i][12] == 1) { $out["data"][$i][12] = '<button class="clm_table_image " value=\'["db_tournament_publish",[' . $out["data"][$i][14] . ',false,false]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/apply") . '" /></button>'; } else { $out["data"][$i][12] = '<button class="clm_table_image" value=\'["db_tournament_publish",[' . $out["data"][$i][14] . ',true,false]]\'><img width="16" height="16" src="' . clm_core::$load->gen_image_url("table/cancel") . '" /></button>'; } $out["data"][$i][13] = '<input class="clm_table_orderingBox" onkeypress="return clm_isChangeNumber(event);" value="' . $out["data"][$i][13] . '" type="text">'; $out["data"][$i][13] .= '<input class="clm_table_orderingId" value="' . $out["data"][$i][14] . '" type="hidden">'; } return array(true, "m_tableSuccess", $out); }