pagination(countData(false, false, $where));
}
if (!isAdmin()) {
return;
}
if (!subpage()) {
return;
}
$thingName = subpage() == 1 ? 'Geradarys' : 'Dovanotojas';
$thingLabel = subpage() == 1 ? 'Darbas' : 'Daiktas';
$tablefields = array(array('convArray' => array(array('fname', 'lname', 'fnamer', 'lnamer', 'orgname', 'uid'), 'getThingdName')), array('convArray' => array(array('phone', 'phoner'), 'getDoubleString')), array('convArray' => array(array('email', 'emailr'), 'getDoubleString')), 'descr', array('converter' => array('nid', 'getNeedEditLinkGift')), 'null');
$tablehead = array('titles' => array($thingName, 'Telefonas', 'El. paštas', $thingLabel, '', ''), 'columns' => array('left fc-150', 'left fc-150', 'left fc-150', 'left fc-300', 'left fc-16', ''));
getSort('need_fulldate');
$where = 'SELECT
needs.user_fname AS fname,
needs.user_lname AS lname,
users.user_fname AS fnamer,
users.user_lname AS lnamer,
users.user_orgname AS orgname,
needs.need_full_user AS uid,
needs.user_email AS email,
users.user_email AS emailr,
needs.user_phone AS phone,
users.user_phone AS phoner,
needs.need_full_desc AS descr,
needs.need_id AS nid
FROM needs LEFT JOIN users ON needs.need_full_user = users.user_id WHERE needs.need_type=' . subpage() . ' AND needs.need_full = 1 ORDER BY ' . $getsort . $getorder;
$sortby = array();
formatTable(listData(false, false, pageNum(), $where), $tablefields, $tablehead, $sortby, true, 'nomargin');
pagination(countData(false, false, $where));
$poreikis = array(1 => 'darbų', 2 => 'daiktų');
<div class="container-fluid topborder endless openmlsectioninfo">
<div class="col-xs-12 col-md-10 col-md-offset-1" id="mainpanel">
<div class="tab-content">
<div class="tab-pane <?php
if (false !== strpos($_SERVER['REQUEST_URI'], '/f/')) {
echo 'active';
}
?>
" id="flow_overview">
<?php
if (false !== strpos($_SERVER['REQUEST_URI'], '/f/')) {
subpage('implementation');
}
?>
</div>
</div> <!-- end tabs content -->
<div class="submenu">
<ul class="sidenav nav" id="accordeon">
<li class="panel guidechapter">
<a data-toggle="collapse" data-parent="#accordeon" data-target="#pagelist"><i class="fa fa-info-circle fa-fw fa-lg"></i> <b>Details</b></a>
<ul class="sidenav nav collapse in" id="pagelist">
<li class="active"><a href="#flow_overview" data-toggle="tab">Overview</a></li>
<li><a href="search?q=+run_flow.flow_id%3A<?php
echo $this->id;
?>
&type=run">All runs</a></li>
<li><a class="loginfirst" href="<?php
echo $this->record->{'binary_file_id'};
<script type="text/javascript" src="javascript/page/data"></script>
<div class="container-fluid topborder endless openmlsectioninfo">
<div class="col-xs-12 col-md-10 col-md-offset-1" id="mainpanel">
<?php
if (false === strpos($_SERVER['REQUEST_URI'], '/new/')) {
subpage('data');
} else {
subpage(end(explode('/', $_SERVER['REQUEST_URI'])));
}
?>
</div>
</div>
<?php
if ($login->isUserLoggedIn() == false) {
return;
}
if (!isAdmin() and !isGridManager()) {
return;
}
if (isAction('deaktyvuoti') and getParam()) {
if (isGridManager() and countData('users', "user_parent = " . CUSER . " AND user_id = '" . getParam() . "'") == 0) {
err('Neturite teisės keisti šio vartotojo duomenis', 'red');
return;
}
$row = getRow('users', 'user_id = ' . getParam());
$act = $row['user_active'];
$act = !$act;
updateFieldWhere('users', 'user_active', $act, 'user_id = ' . getParam());
redirect(0, getCurrentLink());
}
$tablefields = array('user_id', array('converter' => array('user_thumb', 'getThumb')), 'user_name', 'user_fname', 'user_lname', 'user_orgname', 'user_phone', 'user_email', array('converter' => array('user_city', 'getCountry')), 'user_lastlogin', array('converter' => array('user_id', 'getUserEditLink')), array('action' => array('user_id', 'deaktyvuoti', '<i title="Aktyvuoti/deaktyvuoti" class="fa fa-times"></i>', false)), 'null');
$tablehead = array('titles' => array('ID', '', '<span title="Paskyros vardas">P. vardas</span>', 'Vardas', 'Pavardė', 'Organizacija', 'Telefonas', 'El. paštas', 'Savivaldybė', 'Pask. k. prisijungė', '', '', ''), 'columns' => array('right fc-60', 'left fc-30', 'left fc-75', 'left fc-75', 'left fc-100', 'left fc-100', 'left fc-90', 'left', 'left fc-125', 'left fc-dates', 'left fc-16', 'left fc-16', ''));
$parent = isGridManager() ? 'AND user_parent = ' . CUSER : '';
getSort('user_id');
$where = 'SELECT * FROM users WHERE user_acctype=' . subpage() . ' ' . $parent . ' ORDER BY ' . $getsort . $getorder;
$sortby = array(0 => 'user_id', 2 => 'user_name', 3 => 'user_fname', 4 => 'user_lname', 5 => 'user_orgname', 6 => 'user_email', 7 => 'user_phone', 8 => 'user_city', 9 => 'user_lastlogin');
formatTable(listData(false, false, pageNum(), $where), $tablefields, $tablehead, $sortby, true, 'nomargin');
pagination(countData(false, false, $where));
?>
<br><br>
<a href="?p=edituser"><i class="fa fa-asterisk"></i> Sukurti vartotoją</a>
<br><br>
<a href="?p=editneed&type=<?php
echo subpage();
?>
&subp=<?php
echo subpage();
?>
"><i class="fa fa-asterisk"></i> Sukurti <?php
echo $poreikis[subpage()];
?>
poreikį</a>
<?php
if (isAdmin()) {
?>
·
<a href="?p=catneed<?php
echo subpage();
?>
&subp=<?php
echo subpage();
?>
"><i class="fa fa-tags"></i> <?php
echo ucfirst($poreikis[subpage()]);
?>
poreikio kategorijos</a> ·
<a href="?p=need&subp=<?php
echo subpage();
?>
®enerate"><i class="fa fa-cogs"></i> Regeneruoti santrumpas</a>
<?php
}
<?php
if (false !== strpos($_SERVER['REQUEST_URI'], '/a/quality-value')) {
subpage('quality-value');
}
?>
</div>
<!-- Flow qualities -->
<div class="tab-pane <?php
if (false !== strpos($_SERVER['REQUEST_URI'], '/a/flow-qualities')) {
echo 'active';
}
?>
">
<?php
if (false !== strpos($_SERVER['REQUEST_URI'], '/a/flow-qualities')) {
subpage('flow-qualities');
}
?>
</div>
</div> <!-- end tabs content -->
<div class="submenu">
<ul class="sidenav nav" id="accordeon">
<li class="panel guidechapter">
<a data-toggle="collapse" data-parent="#accordeon" data-target="#pagelist"><i class="fa fa-info-circle fa-fw fa-lg"></i> <b>Details</b></a>
<ul class="sidenav nav collapse in" id="pagelist">
<li class="active"><a href="#flow_overview" data-toggle="tab">Overview</a></li>
</ul>
</li>
</ul>
<div class="container-fluid topborder endless openmlsectioninfo">
<div class="col-xs-12 col-md-10 col-md-offset-1" id="mainpanel">
<div class="tab-content">
<!-- DETAIL -->
<?php
if (false !== strpos($_SERVER['REQUEST_URI'], '/r/')) {
?>
<div class="tab-pane active" id="data_overview">
<?php
subpage('run');
?>
</div>
<?php
}
?>
</div> <!-- end tabs content -->
<div class="submenu">
<ul class="sidenav nav" id="accordeon">
<li class="panel guidechapter">
<a data-toggle="collapse" data-parent="#accordeon" data-target="#qtabs"><i class="fa fa-info-circle fa-fw fa-lg"></i> <b>Details</b></a>
<ul class="sidenav nav collapse in" id="qtabs">
<li class="active"><a href="#data_overview" data-toggle="tab">Overview</a></li>
<li><a href="query">Query runs</a></li>
</ul>
</li>
<li class="panel guidechapter">
<a data-toggle="collapse" data-parent="#accordeon" data-target="#taglist"><i class="fa fa-tag fa-fw fa-lg"></i> <b>Tags</b></a>
<form method="post" action="" enctype="multipart/form-data">
<input type="hidden" name="deletetag" id="deletetag"/>
}
}
?>
</select>
<input type="submit" value="Priskirti" />
</form><br><br><?php
}
} else {
updateFieldWhere('cats', 'deleted', $act, 'cat_id = ' . getParam());
redirect(0, $url = '?p=' . page() . (subpage() ? '&subp=' . subpage() : '') . (psl() ? '&page=' . psl() : ''));
}
}
if (isset($_POST['addoption'])) {
if (strlen($_POST['option1']) > 2) {
insertRow('cats', 'cat_name, cat_type', "'" . $_POST['option1'] . "', " . $catType);
redirect(0, $url = '?p=' . page() . (subpage() ? '&subp=' . subpage() : '') . (psl() ? '&page=' . psl() : ''));
} else {
err('Įveskite kategorijos vardą', 'red');
}
}
?>
<form action="" method="post">
Įtraukti naują kategoriją: kategorijos vardas <input type="text" name="option1" value="" />
<input type="submit" name="addoption" value="Įtraukti" />
</form>
<?php
$tablefields = array('cat_id', array('editable' => array('cat_name', 'cat_id', 'fc-verylong', '')), array('action' => array('cat_id', 'salinti', '<i title="Šalinti" class="fa fa-times"></i>', false)), 'null');
$tablehead = array('titles' => array('ID', 'Kategorijos vardas', '', ''), 'columns' => array('right fc-75', 'left', 'left fc-16', ''));
$sortby = false;
$where = 'SELECT * FROM cats WHERE cat_type = ' . $catType . ' ORDER BY cat_id DESC';
formatTable(listData(false, false, pageNum(), $where), $tablefields, $tablehead, $sortby, true, 'nomargin');
getSort('user_id');
$where = "SELECT * FROM users WHERE {$subpage} AND user_active = 1 ORDER BY " . $getsort . $getorder;
$sortby = array(1 => 'user_fname', 2 => 'user_lname', 3 => 'user_email', 4 => 'user_phone', 5 => 'user_city');
formatTable(listData(false, false, pageNum(), $where), $tablefields, $tablehead, $sortby, true, 'nomargin');
pagination(countData(false, false, $where));
?>
<br><br>
<form action="" method="GET">
<input type="hidden" name="p" value="colleagues" />
<select name="subp">
<option value="0"<?php
if (subpage() != 2 and subpage() != 1) {
echo 'selected="selected"';
}
?>
>Tinklo atstovai ir kuratoriai</option>
<option value="2"<?php
if (subpage() == 2) {
echo 'selected="selected"';
}
?>
>Tinklo atstovai</option>
<option value="1"<?php
if (subpage() == 1) {
echo 'selected="selected"';
}
?>
>Kuratoriai</option>
<input type="submit" value="Rodyti" />
</select>
</form>
function getNeedEditLinkGift($id)
{
return '<a title="Darbas/daiktas" href="?p=editthing&type=' . subpage() . '&need=' . $id . '"><i class="fa fa-gift"></i></a>';
}
<?php
if (!$this->dataonly) {
?>
</div>
<div class="submenu">
<ul class="sidenav nav" id="accordeon">
<li class="panel guidechapter">
<a data-toggle="collapse" data-parent="#accordeon" data-target="#filterlist"><i class="fa fa-filter fa-fw fa-lg"></i> <b>Filter results</b></a>
<ul class="sidenav nav collapse in" id="filterlist">
<?php
if ($this->filtertype) {
subpage($this->filtertype);
} else {
subpage("everything");
}
if ($this->filtertype and $this->filtertype != 'user' and $this->filtertype != 'task_type') {
?>
<li>
<button class="btn btn-default btn-material-<?php
echo $this->materialcolor;
?>
" id="research">Search</button>
</li>
<li><a><i class="fa fa-lg fa-fw fa-info-circle"></i>You can use 1..10, >10,...</a>
<a id="removefilters"><i class="fa fa-lg fa-fw fa-trash-o"></i>Remove all filters</a></li>
<?php
}
?>
</ul>
<div class="container-fluid topborder endless openmlsectioninfo">
<div class="col-xs-12 col-md-10 col-md-offset-1" id="mainpanel">
<div class="tab-content">
<div class="tab-pane <?php
if (isset($this->id)) {
echo 'active';
}
?>
" id="typedetail">
<?php
if (false !== strpos($_SERVER['REQUEST_URI'], '/tt/')) {
subpage('tasktype');
}
?>
</div> <!-- end task_type tab -->
</div> <!-- end tabs content -->
<div class="submenu">
<ul class="sidenav nav" id="accordeon">
<li class="panel guidechapter">
<a data-toggle="collapse" data-parent="#accordeon" data-target="#pagelist"><i class="fa fa-info-circle fa-fw fa-lg"></i> <b>Details</b></a>
<ul class="sidenav nav collapse in" id="pagelist">
<li class="active"><a href="#typedetail" data-toggle="tab">Overview</a></li>
<li><a href="search?q=+tasktype.tt_id%3A<?php
echo $this->id;
?>
&type=task">Tasks</a></li>
</ul>
$need_subcat = isset($_POST['need_subcat']) ? mysqli_real_escape_string($con, $_POST['need_subcat']) : 0;
$need_name = isset($_POST['need_name']) ? mysqli_real_escape_string($con, $_POST['need_name']) : '';
$need_desc = isset($_POST['need_desc']) ? mysqli_real_escape_string($con, $_POST['need_desc']) : '';
$need_expires = isset($_POST['need_expires']) ? mysqli_real_escape_string($con, $_POST['need_expires']) : 0;
$need_regdate = date('Y-m-d H:i:s');
$need_author = CUSER;
if ($need_needy == '' or $need_needy <= 0 or $need_cat == '' or $need_cat <= 0 or $need_cat_type == 4 and $need_subcat == '' or $need_cat_type == 4 and $need_subcat <= 0 or $need_name == '' or $need_desc == '' or $need_expires == '') {
err("Užpildykite visus reikalaujamus laukelius", 'red');
} elseif (strtotime($need_expires) === false) {
err("Netinkamas galiojimo laikas", 'red');
} elseif (strtotime($need_expires) < strtotime('+1 minute')) {
err("Šis galiojimo laikas jau praėjo", 'red');
} else {
$id = insertRow('needs', 'need_needy, need_cat, need_subcat, need_name, need_desc, need_regdate, need_expires, need_type, need_author', "{$need_needy}, {$need_cat}, {$need_subcat}, '{$need_name}', '{$need_desc}', '{$need_regdate}', '{$need_expires}', {$need_type}, {$need_author}", false);
if ($id) {
redirect(0, '?p=' . page() . '&type=' . $need_type . '&subp=' . subpage() . '&need=' . $id);
} else {
err('Poreikis nesukurtas', 'red');
}
}
}
?>
<form action="" method="post">
<label>Stokojantis<span class="reqfield">*</span></label>
<select name="need_needy"><?php
$ops = listData('needy', "deleted = 0 {$parent} ORDER BY user_lname");
foreach ($ops as $op) {
echo '<option value=' . $op[0] . '>' . $op['user_lname'] . ' ' . $op['user_fname'] . ' ' . $op['user_orgname'] . '</option>';
}
?>
</select>
if (isset($this->task_id)) {
subpage('task_runs');
}
?>
</div>
<div class="tab-pane" id="people">
<?php
if (isset($this->task_id)) {
subpage('task_leaderboard');
}
?>
</div> <!-- end task tab -->
<div class="tab-pane" id="results">
<?php
if (isset($this->task_id)) {
subpage('task_results');
}
?>
</div> <!-- end task tab -->
</div> <!-- end tabs content -->
<div class="submenu">
<ul class="sidenav nav" id="accordeon">
<li class="panel guidechapter">
<a data-toggle="collapse" data-parent="#accordeon" data-target="#pagelist"><i class="fa fa-info-circle fa-fw fa-lg"></i> <b>Details</b></a>
<ul class="sidenav nav collapse in" id="pagelist">
<li class="active"><a href="#detail" data-toggle="tab">Overview</a></li>
<li><a href="#taskruns" data-toggle="tab">All runs</a></li>
<li><a href="#results" data-toggle="tab">Results</a></li>
<li><a href="#people" data-toggle="tab">Leaderboard</a></li>
<?php
}
?>
<?php
if (!in_array($this->subpage, $this->activity_subpages) and false !== strpos($_SERVER['REQUEST_URI'], '/u/') and $this->is_owner) {
?>
<div class="tab-pane" id="edit">
<?php
subpage('profile');
?>
</div>
<div class="tab-pane" id="api">
<?php
subpage('api');
?>
</div>
<?php
}
?>
</div> <!-- end tabs content -->
<div class="submenu">
<ul class="sidenav nav" id="accordeon">
<li class="panel guidechapter">
<a data-toggle="collapse" data-parent="#accordeon" data-target="#pagelist"><i class="fa fa-user fa-fw fa-lg"></i> <b>Activity</b></a>
<ul class="sidenav nav collapse in" id="pagelist">
<li><a href="<?php
echo BASE_URL . 'u/' . $this->user_id;
$children[] = 'needy.user_parent = ' . $child['user_id'];
}
$parent = '((' . implode(' OR ', $children) . ') OR needy.user_parent_ta = ' . CUSER . ')';
if (countData(false, false, "SELECT * FROM needs INNER JOIN needy ON needs.need_needy = needy.user_id WHERE needs.need_id = " . getParam() . " AND " . $parent) == 0) {
err('Neturite teisės keisti šio poreikio duomenis', 'red');
return;
}
}
$row = getRow('needs', 'need_id = ' . getParam());
$act = $row['need_full'];
$act = !$act;
updateFieldWhere('needs', 'need_full', $act, 'need_id = ' . getParam());
redirect(0, getCurrentLink());
}
$tablefields = array('need_id', 'need_name', 'need_full_desc', 'need_regdate', array('converter' => array('need_id', 'getThingEditLink')), array('action' => array('need_id', 'atkurti', '<i title="Patenkintą poreikį padaryti nepatenkintu ir grąžinti į Poreikių lentelę" class="fa fa-undo"></i>', false)), 'null');
$tablehead = array('titles' => array('ID', 'Pavadinimas', 'Aprašymas', 'Modifikuotas', '', '', ''), 'columns' => array('right fc-60', 'left fc-150', 'left fc-300', 'left fc-dates', 'left fc-16', 'left fc-16', ''));
if (isAdmin()) {
$parent = '';
} elseif (isManager() or isGridManager()) {
$parent = 'AND needy.user_parent = ' . CUSER;
/*elseif(isGridManager()) :
$children = array();
foreach(listData('users', 'user_acctype = 1 AND user_active = 1 AND user_parent = '.CUSER) as $child) $children[] = 'needy.user_parent = '.$child['user_id'];
$parent = 'AND (('.implode(' OR ', $children).') OR needy.user_parent_ta = '.CUSER.')';*/
}
getSort('need_fulldate');
$where = 'SELECT need_fulldate, need_full_desc, need_needy, need_id, need_name, cat_name, user_fname, user_lname, need_regdate, a.deleted AS deleted FROM (SELECT need_fulldate, need_full_desc, need_id, need_name, cat_name, need_type, need_needy, need_regdate, needs.deleted AS deleted FROM needs LEFT JOIN cats ON needs.need_cat = cats.cat_id WHERE needs.need_type=' . subpage() . ' AND needs.need_full=1) a LEFT JOIN needy ON a.need_needy = needy.user_id WHERE a.need_type=' . subpage() . ' ' . $parent . ' ORDER BY ' . $getsort . $getorder;
$sortby = array(0 => 'need_id', 1 => 'need_name', 3 => 'need_regdate');
formatTable(listData(false, false, pageNum(), $where), $tablefields, $tablehead, $sortby, true, 'nomargin');
pagination(countData(false, false, $where));
$poreikis = array(1 => 'darbų', 2 => 'daiktų');
}
?>
" id="new">
<?php
subpage('new');
?>
</div>
<div class="tab-pane <?php
if ($this->activetab == 'thread') {
echo 'active';
}
?>
" id="thread">
<?php
if (isset($this->thread) and $this->thread) {
subpage('thread');
}
?>
</div>
</div> <!-- end tabs content -->
<div class="submenu">
<ul class="sidenav nav" id="accordeon">
<li class="panel guidechapter">
<a data-toggle="collapse" data-parent="#accordeon" data-target="#pagelist"><i class="fa fa-info-circle fa-fw fa-lg"></i> <b>Discussions</b></a>
<ul class="sidenav nav collapse in" id="pagelist">
<li class="<?php
if ($this->activetab == 'recent') {
echo 'active';
}
<?php
if ($this->activetab == 'overview') {
subpage('dataset');
}
?>
</div>
<div class="tab-pane <?php
if ($this->activetab == 'update') {
echo 'active';
}
?>
" id="data_update">
<?php
if ($this->activetab == 'update') {
subpage('update');
}
?>
</div>
</div> <!-- end tabs content -->
<div class="submenu">
<ul class="sidenav nav" id="accordeon">
<li class="panel guidechapter">
<a data-toggle="collapse" data-parent="#accordeon" data-target="#pagelist"><i class="fa fa-info-circle fa-fw fa-lg"></i> <b>Details</b></a>
<ul class="sidenav nav collapse in" id="pagelist">
<li class="active"><a href="#data_overview" data-toggle="tab">Overview</a></li>
<li><a class="loginfirst" href="<?php
echo $this->record->{'url'};
if (!function_exists('subpage')) {
function subpage()
{
global $page;
$subpage = $_GET['subpage'];
$parentquery = "SELECT * FROM pages WHERE url = '{$page}' AND status='published'";
$parentresult = mysql_query($parentquery);
$num = mysql_num_rows($parentresult);
if ($num == 1) {
while ($row = mysql_fetch_array($parentresult, MYSQL_ASSOC)) {
$parentcategory = $row['id'];
$subpagequery = "SELECT * FROM pages WHERE url = '{$subpage}' AND parent = '{$parentcategory}' AND status='published'";
$subpageresult = mysql_query($subpagequery);
$num = mysql_num_rows($subpageresult);
if ($num == 1) {
while ($row = mysql_fetch_array($subpageresult, MYSQL_ASSOC)) {
echo "<h2>" . $row['title'] . "</h2>";
echo $row['content'];
}
} else {
echo "<p>The page was not found in the database.</p>";
}
}
} else {
echo "<p>Nothing was found in the database.</p>";
}
}
}
subpage();
echo 'active';
}
?>
" id="curvestab">
<?php
subpage('curves');
?>
</div>
<div class="tab-pane fade <?php
if ($this->active_tab == 'resultstab') {
echo 'active';
}
?>
" id="resultstab">
<?php
subpage('results');
?>
</div>
</div> <!-- end tabs content -->
<div class="submenu">
<ul class="sidenav nav" id="accordeon">
<li class="panel guidechapter">
<a data-toggle="collapse" data-parent="#accordeon" data-target="#qtabs"><i class="fa fa-search fa-fw fa-lg"></i> <b>Query</b></a>
<ul class="sidenav nav collapse in" id="qtabs">
<li class="active"><a href="#sqltab" data-toggle="tab">SQL editor</a></li>
<li><a href="#wizardtab" data-toggle="tab">Compare flows</a></li>
<li><a href="#curvestab" data-toggle="tab">Draw learning curves</a></li>
<li><a href="#exampletab" data-toggle="tab">Advanced queries</a></li>
<!-- <li><a href="#querygraphtab" data-toggle="tab">Query graph</a></li> -->
<div class="tab-pane" id="python">
<?php
subpage('python');
?>
</div>
<div class="tab-pane" id="rest_tutorial">
<?php
subpage('rest_tutorial');
?>
</div>
<?php
subpage('rest_services');
?>
<div class="tab-pane" id="json">
<?php
subpage('json');
?>
</div>
</div>
</div> <!-- end col-10 -->
<div class="submenu">
<ul class="sidenav nav" id="accordeon">
<li class="panel guidechapter">
<a data-toggle="collapse" data-parent="#accordeon" data-target="#startlist"><i class="fa fa-graduation-cap fa-fw fa-lg"></i> <b>Getting Started</b></a>
<ul class="sidenav nav collapse" id="startlist">
<li class="active"><a href="#intro" data-toggle="tab">10 minute intro</a></li>
<li><a href="#terms" data-toggle="tab">Honor Code and Terms</a></li>
