?>
.png" alt= "pglogo" />
<h2><?php
echo $fumenu[$_GET['p']];
?>
</h2>
</div>
</div>
<?php
} else {
?>
<div class="banner daiktais" style="background-image: url('/img/head2.jpg');">
<div class="social">
<a class="fb" target="_blank" href="https://www.facebook.com/pagalbadaiktais/"><i class="fa fa-facebook"></i></a>
<a class="tw" target="_blank" href="http://www.linkedin.com/company/pagalbadaiktais-lt"><i class="fa fa-linkedin"></i></a>
</div>
<div class="counter">Nuo portalo veiklos pradžios padovanota <span class="cnumber"><?php
echo countData('needs', 'need_full = 1 AND need_type = 2 AND deleted = 0');
?>
</span> daiktų</div>
</div>
<?php
}
?>
<div class="site daiktais<?php
if (isset($_GET['pageslug']) and $_GET['pageslug'] != '' or isset($_GET['p']) and in_array($_GET['p'], array('kuratorius', 'tinklo-atstovas', 'stokojantysis', 'poreikiai', 'edit'))) {
echo ' pagetemp';
}
?>
">
?>
</div>fiziniai asmenys</div><div class="pieContainer">
<div class="pieHole"><div class="digit"><?php
echo $digit;
?>
</div>pagalbos gavėjai</div>
<div class="pieBackground slice2"></div>
<div id="pieSlice1" class="hold"><div class="pie slice1"></div></div>
<div id="pieSlice2" class="hold"><div class="pie slice1"></div></div>
</div><div class="pieLabel right"><div class="digit"><?php
echo $digitr;
?>
</div>juridiniai asmenys</div>
<?php
$digitl = countData("users", "user_active = 1 AND user_person = 0 AND user_acctype = 0");
$digitr = countData("users", "user_active = 1 AND user_person = 1 AND user_acctype = 0");
$digit = $digitl + $digitr;
$per1 = round($digitr / $digit * 100);
$pr1 = $per1 <= 50 ? round($per1 * 360 / 100) : 180;
$pr2 = $per1 > 50 ? round(($per1 - 50) * 360 / 100) : 0;
?>
<style>
#pieSlice4 {-webkit-transform:rotate(180deg); -moz-transform:rotate(180deg); -o-transform:rotate(180deg); transform:rotate(50deg);}
#pieSlice3 .pie {-webkit-transform:rotate(<?php
echo $pr1;
?>
deg); -moz-transform:rotate(<?php
echo $pr1;
?>
deg); -o-transform:rotate(<?php
echo $pr1;
<script>
CKEDITOR.replace( 'editor1', {
uiColor: '#ffffff', language: 'lt',
filebrowserUploadUrl: '/ckupload.php',
height: '350px',
});
</script>
<br>
<input type="submit" value="Sukurti" name="newpage" />
</form>
<?php
return;
}
$us = $_GET['page'];
if (countData('pages', "page_id = '{$us}'") == 0) {
err('Toks poreikis neegzistuoja', 'red');
return;
}
// Edit
$usermeta = getRow('pages', 'page_id = ' . $us);
?>
<form action="" method="post">
<?php
// Title
echo '<div class="edit_header_group noborder">';
echo '<div class="name single">Puslapis: <input type="text" value="' . $usermeta['page_name'] . '" name="page_name" maxlength="256" required /></div>';
echo 'Modifikavimo data: ' . $usermeta['page_modified'];
echo ' · Santrumpa <input type="text" value="' . $usermeta['page_slug'] . '" name="page_slug" maxlength="256" required />
· Svetainė<span class="reqfield"> <select name="page_site">
<option value="0"' . ($usermeta['page_site'] == 0 ? ' selected="selected"' : '') . '>pagalbadarbais.lt</option>
$us = $_GET['user'];
if (countData('needy', "user_id = '{$us}'") == 0) {
err('Toks vartotojas neegzistuoja', 'red');
return;
}
if (isManager() and countData('needy', "user_parent = " . CUSER . " AND user_id = '{$us}'") == 0) {
err('Neturite teisės keisti šio vartotojo duomenis', 'red');
return;
}
if (isGridManager()) {
$children = array();
foreach (listData('users', 'user_acctype = 1 AND user_active = 1 AND user_parent = ' . CUSER) as $child) {
$children[] = 'user_parent = ' . $child['user_id'];
}
$parent = '(' . implode(' OR ', $children) . ')';
if (countData('needy', "(({$parent}) OR user_parent = " . CUSER . " OR user_parent_ta = " . CUSER . ") AND user_id = '{$us}'") == 0) {
err('Neturite teisės keisti šio vartotojo duomenis', 'red');
return;
}
}
// Edit
$usermeta = getRow('needy', 'user_id = ' . $us);
// Title
echo '<div class="edit_header_group">';
echo '<div class="gravatar">' . (strlen($usermeta['user_thumb']) > 16 ? '<img src="' . $usermeta['user_thumb'] . '" onError="this.style.visibility=\'hidden\'" />' : '') . '</div><div class="gname">';
echo '<div class="name">' . ($usermeta['user_person'] == 0 ? $usermeta['user_fname'] . ' ' . $usermeta['user_lname'] : $usermeta['user_orgname']) . '</div>';
echo 'Registracijos data: ' . $usermeta['user_registration_datetime'];
echo '</div></div>';
/*$options = array(
'fields' => array(
'user_person' => array('Asmuo', 'inputtype' => 'drop', 'drops' => array(0 => 'Fizinis', 1=> 'Juridinis'), 'required' => true),
*/
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_id');
$where = 'SELECT need_id, need_name, cat_name, user_fname, user_lname, user_orgname, need_expires, need_desc, need_regdate, a.deleted AS deleted FROM (SELECT need_id, need_name, cat_name, need_type, need_needy, need_expires, need_desc, 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=0) 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', 2 => 'cat_name', 3 => 'user_fname', 4 => 'user_lname', 5 => 'user_orgname', 6 => 'need_regdate');*/
formatTable(listData(false, false, pageNum(), $where), $tablefields, $tablehead, $sortby, true, 'nomargin');
pagination(countData(false, false, $where));
$poreikis = array(1 => 'darbo', 2 => 'daikto');
?>
<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
function regCounter($site, $region, $full)
{
global $regionsListChildren;
$cities = array_key_exists($region, $regionsListChildren) ? $regionsListChildren[$region] : array();
foreach ($cities as $ctkey => $cityid) {
$cities[$ctkey] = 'needy.user_city = ' . $cityid;
}
$cities = implode(' OR ', $cities);
$filterCity = 'AND (' . $cities . ')';
$site = $site + 1;
if ($full == 0) {
$expires = 'AND needs.need_expires > NOW()';
} else {
$expires = '';
}
$q = "SELECT needs.need_id FROM needs INNER JOIN needy ON needs.need_needy = needy.user_id WHERE need_type = {$site} AND needs.need_full = {$full} AND needs.deleted = 0 {$expires} {$filterCity}";
return countData(false, false, $q);
return 0;
}
?>
<br><small>JPG, PNG, maks. 5 MB</small></label>
<input type="file" name="user_thumb" id="user_thumb" />
<br>
<input type="submit" value="Sukurti" name="newuser" />
</form>
<?php
return;
}
$us = $_GET['user'];
if (countData('users', "user_id = '{$us}'") == 0) {
err('Toks vartotojas neegzistuoja', 'red');
return;
}
if (isGridManager() and countData('users', "user_parent = " . CUSER . " AND user_id = '{$us}'") == 0) {
err('Neturite teisės keisti šio vartotojo duomenis', 'red');
return;
}
// Edit
$usermeta = getRow('users', 'user_id = ' . $us);
// Title
echo '<div class="edit_header_group">';
echo '<div class="gravatar">' . (strlen($usermeta['user_thumb']) > 16 ? '<img src="' . $usermeta['user_thumb'] . '" onError="this.style.visibility=\'hidden\'" />' : '') . '</div><div class="gname">';
echo '<div class="name">' . ($usermeta['user_person'] == 0 ? $usermeta['user_fname'] . ' ' . $usermeta['user_lname'] : $usermeta['user_orgname']) . '</div>';
echo 'Paskyros vardas: <b>' . $usermeta['user_name'] . '</b> · Paskyros ID: <b>' . $usermeta['user_id'] . '</b>';
echo '<br>Registravosi <b>' . $usermeta['user_registration_datetime'] . '</b> iš <b>' . $usermeta['user_registration_ip'] . '</b> · ';
echo 'Paskutinį kartą jungėsi <b>' . $usermeta['user_lastlogin'] . '</b> iš <b>' . $usermeta['user_lastlogin_ip'] . '</b>';
echo '</div></div>';
$options = array();
if (isAdmin() and $usermeta['user_acctype'] == 0) {
$pb = countData('needs', 'need_type = 2 AND need_full = 0 AND deleted = 0');
$da = countData('needs', 'need_type = 1 AND need_full = 1 AND deleted = 0');
$db = countData('needs', 'need_type = 2 AND need_full = 1 AND deleted = 0');
$dova = countData(false, false, 'SELECT DISTINCT need_full_user FROM needs WHERE need_type = 1 AND need_full = 1 AND need_full_user > 0 AND deleted = 0');
$dovb = countData(false, false, 'SELECT DISTINCT need_full_user FROM needs WHERE need_type = 2 AND need_full = 1 AND need_full_user > 0 AND deleted = 0');
$dova2 = countData(false, false, 'SELECT DISTINCT CONCAT(user_fname, user_lname) FROM needs WHERE need_type = 1 AND need_full = 1 AND need_full_user = 0 AND deleted = 0');
$dovb2 = countData(false, false, 'SELECT DISTINCT CONCAT(user_fname, user_lname) FROM needs WHERE need_type = 2 AND need_full = 1 AND need_full_user = 0 AND deleted = 0');
$dovv = countData(false, false, 'SELECT DISTINCT need_full_user FROM needs WHERE need_full = 1 AND need_full_user > 0 AND deleted = 0');
$dovv2 = countData(false, false, 'SELECT DISTINCT CONCAT(user_fname, user_lname) FROM needs WHERE need_full = 1 AND need_full_user = 0 AND deleted = 0');
$stats = array(array('Stokojantieji', countData('needy', 'deleted = 0')), array('Poreikiai (darbų)', $pa), array('Poreikiai (daiktų)', $pb), array('Poreikiai (suma)', $pa + $pb), array('Darbai', $da), array('Daiktai', $db), array('Darbai / daiktai (suma)', $da + $db), array('Geradariai', $dova + $dova2 . " ({$dova} reg. vart. ir apytiksliai {$dova2} nereg. vart.)"), array('Dovanotojai', $dovb + $dovb2 . " ({$dovb} reg. vart. ir apytiksliai {$dovb2} nereg. vart.)"), array('Geradariai / dovanotojai (aibių sąjunga)', $dovv + $dovv2 . " ({$dovv} reg. vart. ir apytiksliai {$dovv2} nereg. vart.)"));
?>
<br><b>Informacija apie stokojančiuosius</b><br><br>
<table>
<?php
foreach ($stats as $st) {
echo '<tr><td style="width: 375px;">' . $st[0] . '</td><td>' . $st[1] . '</td></tr>';
}
?>
</table>
<?php
$stats = array(array('Stokojantis pašalintas, nes nebereikalinga parama/pagalba', countData('needy', 'delreason = 1 AND deleted = 1')), array('Stokojantis pašalintas dėl privatumo problemos', countData('needy', 'delreason = 2 AND deleted = 1')), array('Stokojantis pašalintas dėl sukčiavimo', countData('needy', 'delreason = 3 AND deleted = 1')), array('Poreikis pašalintas, nes padovanota/padėta ne per sistemą', countData('needs', 'delreason = 1')), array('Poreikis pašalintas, nes nebereikalingas daiktas/darbas', countData('needs', 'delreason = 2 AND deleted = 1')));
?>
<br>
<b>Duomenų šalinimo statistika</b><br><br>
<table>
<?php
foreach ($stats as $st) {
echo '<tr><td style="width: 375px;">' . $st[0] . '</td><td>' . $st[1] . '</td></tr>';
}
?>
</table>
<?php
$page_id = isset($_GET['blogid']) ? $_GET['blogid'] : false;
$page_site = 1;
if ($page_id) {
$pagerow = getRow('pages', "page_id = {$page_id} AND (page_site = {$page_site} OR page_site = 2) AND deleted = 0 AND page_published < NOW()");
if (!$pagerow) {
err('Naujiena neegzistuoja');
return;
}
} else {
$where = "SELECT * FROM pages WHERE page_type = 1 AND (page_site = {$page_site} OR page_site = 2) AND deleted = 0 AND page_published < NOW() ORDER BY page_published DESC";
echo '<ul>';
foreach (listData(false, false, pageNum(), $where) as $key => $data) {
echo '<li><a href="/naujienos/' . $data['page_id'] . '">' . $data['page_name'] . '</a></li>';
}
echo '</ul>';
pagination2(countData(false, false, $where), 10, 'naujienos/psl');
return;
}
if ($pagerow) {
echo '<h2>' . $pagerow['page_name'] . '</h2>';
echo $pagerow['page_content'];
}
$us = $_GET['need'];
if (countData('needs', "need_id = '{$us}'") == 0) {
err('Toks poreikis neegzistuoja', 'red');
return;
}
if (isManager() and countData(false, false, "SELECT * FROM needs INNER JOIN needy ON needs.need_needy = needy.user_id WHERE needs.need_id = {$us} AND needy.user_parent = " . CUSER) == 0) {
err('Neturite teisės keisti šio poreikio duomenis', 'red');
return;
}
if (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'];
}
$parent2 = '((' . 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 = {$us} AND " . $parent2) == 0) {
err('Neturite teisės keisti šio poreikio duomenis', 'red');
return;
}
}
// Edit
$usermeta = getRow('needs', 'need_id = ' . $us);
$need_type = $usermeta['need_type'];
if ($need_type == 1) {
$need_cat_type = 3;
}
if ($need_type == 2) {
$need_cat_type = 4;
}
// Title
echo '<div class="edit_header_group">';
