?> .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">';