public function show()
{
$data['user_id'] = $this->tank_auth->get_user_id();
$this->load->model('empleado_model');
$this->load->helper('dropdown');
$username = $this->tank_auth->get_username();
$data['nombre_de_usuario'] = $this->empleado_model->getName($username);
$data['panelheading'] = "Captura de incidencias";
if ($this->uri->segment(3) != '' && $this->uri->segment(4) != '') {
$id = $this->uri->segment(3);
$qna = $this->uri->segment(4);
$this->load->model('qna_model');
$data['qna'] = $this->qna_model->get($qna);
if ($data['qna']->activa) {
$data['index'] = "capturar/show";
} else {
redirect('captura/index');
}
} else {
$id = $this->uri->segment(3);
$data['index'] = "capturar";
}
$data['empleado'] = $this->captura_model->get_empleado_join($id);
$this->load->helper('dropdown');
$data['options'] = listData('incidencias', 'id', 'incidencia_cod', 'inc_descripcion', 'ASC', ' - ');
$data['periodos'] = listData2('periodos', 'id', 'period', 'year', 'activo');
$data['capturas'] = $this->captura_model->get_incidencias($id, $qna);
$this->load->view('layouts/index', $data);
}
public function index()
{
$data['dropdownItems'] = listData('posts', 'id', 'title');
// using custom helper method listData
$data['posts'] = $this->post_model->getPosts();
// call Post model method getPosts()
$this->load->view('index', $data);
// load the view file , pass $data array to view file
$this->load->view('footer');
}
</thead>
<?php
if (isset($_POST['acctype'])) {
$code1 = $code2 = '';
foreach ($rights1 as $key => $ri) {
$code1 .= isset($_POST['ri1' . $key]) ? 1 : 0;
}
foreach ($rights2 as $key => $ri) {
$code2 .= isset($_POST['ri2' . $key]) ? 1 : 0;
}
updateFieldWhere('acctypes', 'rights1', $code1, "acctype = " . $_POST['acctype']);
updateFieldWhere('acctypes', 'rights2', $code2, "acctype = " . $_POST['acctype']);
redirect();
}
foreach (listData('acctypes', '1') as $data) {
echo '<tr>';
echo '<td>' . $data['name'] . '</td>';
$ristr = $data['rights1'];
echo '<td><form action="" method="POST">';
echo '<input type="hidden" name="acctype" value="' . $data['acctype'] . '" />';
echo 'Vartotojų lentelėje<br>';
$ristr = $data['rights1'];
foreach ($rights1 as $key => $ri) {
echo '<span class="label"><input style="width: auto;" ' . ($ristr[$key] == 1 ? 'checked="checked"' : '') . ' type="checkbox" name="ri1' . $key . '" />' . $ri . '</span> ';
}
echo '<br>';
echo 'Poreikių lentelėje<br>';
$ristr = $data['rights2'];
foreach ($rights2 as $key => $ri) {
echo '<span class="label"><input style="width: auto;" ' . ($ristr[$key] == 1 ? 'checked="checked"' : '') . ' type="checkbox" name="ri2' . $key . '" />' . $ri . '</span> ';
case "select":
echo "<p class='debug'>UseCaseID: {$UseCaseID} :: ID: {$id}</p>";
if ($UseCaseID != "") {
getUseCaseItem($UseCaseID, $userID);
} else {
if ($id != "") {
getUseCaseItem($id, $userID);
}
}
break;
case "edit":
updateUseCaseItem($UseCaseID, $UseCaseTitle, $UseCaseDescription, $PrimaryActor, $AlternateActors, $PreRequisits, $PostConditions, $MainPathSteps, $AlternatePathSteps, $SuccessCriteria, $PotentialFailures, $FrequencyOfUse, $OwnerUserID, $PriorityID, $CaseStatusID);
listData($listQuery, $userID);
break;
case "":
listData($listQuery, $userID);
break;
}
function filterDropDown($fields)
{
dropdownFields($fields, "Filter By", "filterBy", $filterBy);
}
function orderDropDown($fields)
{
dropdownFields($fields, "Order By", "orderBy", $orderBy);
}
function listData($listQuery, $userID)
{
listUseCase($userID);
echo "<br /><br /><a href='useCases.php?u={$userID}&action=new'>Add UseCase Item</a>";
}
<div class="page"><div class="page-con">
<?php
echo '<h2>Suteikta parama</h2>';
echo '<ul class="poreikiailist smallersq">';
$data0 = listData(false, false, false, "SELECT * FROM needs LEFT JOIN cats ON needs.need_cat = cats.cat_id WHERE need_full_user = "******" AND need_type = 2 AND needs.deleted = 0");
foreach ($data0 as $pdata) {
echo '<li>';
echo '<a href="/poreikiai/id/' . $pdata['need_id'] . '">';
echo '<div class="icon" style="background-image: url(/img/c' . $pdata['cat_id'] . '.png);"></div>';
echo '<div class="name">' . $pdata['need_name'] . '</div>';
echo '<div class="city">' . $citiesList[$pdata['user_city']] . '</div>';
echo '</a>';
echo '</li>';
}
echo '</ul>';
if (count($data0) == 0) {
echo 'Sąrašas tuščias';
}
?>
</div><div class="page-sid">
<div class="sid-back">
<h2>Keisti slaptažodį</h2>
<!-- edit form for user's password / this form uses the HTML5 attribute "required" -->
<form method="post" action="" name="user_edit_form_password">
<label for="user_password_old"><?php
echo $phplogin_lang['Old password'];
?>
<span class="reqfield">*</span></label><input id="user_password_old" type="password" name="user_password_old" autocomplete="off" required />
/**
* Renders an input list.
* @param boolean $checkbox flag that indicates if the list is a checkbox-list.
* @param CModel $model the data model
* @param string $attribute the attribute
* @param array $data value-label pairs used to generate the input list.
* @param array $htmlOptions additional HTML options.
* @return string the generated input list.
* @since 0.9.5
*/
protected function inputsList($checkbox, $model, $attribute, $data, $htmlOptions = array())
{
CHtml::resolveNameID($model, $attribute, $htmlOptions);
$select = CHtml::resolveValue($model, $attribute);
if ($model->hasErrors($attribute)) {
if (isset($htmlOptions['class'])) {
$htmlOptions['class'] .= ' ' . CHtml::$errorCss;
} else {
$htmlOptions['class'] = CHtml::$errorCss;
}
}
$name = $htmlOptions['name'];
unset($htmlOptions['name']);
if (array_key_exists('uncheckValue', $htmlOptions)) {
$uncheck = $htmlOptions['uncheckValue'];
unset($htmlOptions['uncheckValue']);
} else {
$uncheck = '';
}
$hiddenOptions = isset($htmlOptions['id']) ? array('id' => CHtml::ID_PREFIX . $htmlOptions['id']) : array('id' => false);
$hidden = $uncheck !== null ? CHtml::hiddenField($name, $uncheck, $hiddenOptions) : '';
if (isset($htmlOptions['template'])) {
$template = $htmlOptions['template'];
} else {
$template = '<label class="{labelCssClass}">{input}{label}</label>';
}
unset($htmlOptions['template'], $htmlOptions['separator'], $htmlOptions['hint']);
if ($checkbox && substr($name, -2) !== '[]') {
$name .= '[]';
}
unset($htmlOptions['checkAll'], $htmlOptions['checkAllLast']);
$labelOptions = isset($htmlOptions['labelOptions']) ? $htmlOptions['labelOptions'] : array();
unset($htmlOptions['labelOptions']);
$items = array();
$baseID = CHtml::getIdByName($name);
$id = 0;
$method = $checkbox ? 'checkBox' : 'radioButton';
$labelCssClass = $checkbox ? 'checkbox' : 'radio';
if (isset($htmlOptions['inline'])) {
$labelCssClass .= ' inline';
unset($htmlOptions['inline']);
}
foreach ($data as $value => $label) {
$checked = !is_array($select) && !strcmp($value, $select) || is_array($select) && !empty($select) && !is_object($select[0]) && in_array($value, $select) || is_array($select) && !empty($select) && is_object($select[0]) && in_array($value, array_keys(CHtml . listData($select)));
$htmlOptions['value'] = $value;
$htmlOptions['id'] = $baseID . '_' . $id++;
$option = CHtml::$method($name, $checked, $htmlOptions);
$label = CHtml::label($label, $htmlOptions['id'], $labelOptions);
$items[] = strtr($template, array('{labelCssClass}' => $labelCssClass, '{input}' => $option, '{label}' => $label));
}
return $hidden . implode('', $items);
}
break;
case 7:
$q = 'SELECT user_email FROM users WHERE user_acctype = 0 AND user_active = 1';
break;
case 8:
$q = 'SELECT user_email FROM needy WHERE deleted = 0';
break;
case 9:
$q = '(SELECT user_email FROM needs WHERE need_type = 1 AND need_full = 1 AND user_subscribed = 1) UNION (SELECT users.user_email AS user_email FROM needs LEFT JOIN users ON needs.need_full_user = users.user_id WHERE need_type = 1 AND users.user_subscribed = 1 AND users.user_active = 1)';
break;
case 10:
$q = '(SELECT user_email FROM needs WHERE need_type = 2 AND need_full = 1 AND user_subscribed = 1) UNION (SELECT users.user_email AS user_email FROM needs LEFT JOIN users ON needs.need_full_user = users.user_id WHERE need_type = 2 AND users.user_subscribed = 1 AND users.user_active = 1)';
break;
}
$recips = array();
foreach (listData(false, false, false, $q) as $rec) {
if ($rec['user_email'] != '') {
$recips[] = $rec['user_email'];
}
}
$amount = count($recips);
//$recips = implode(', ', $recips);
$sendByOne = false;
$report = array('success' => array(), 'fail' => array());
if ($sendByOne) {
if ($amount > 0) {
foreach ($recips as $receip) {
$successfullySent = myMail($receip, $_POST['subject'], $_POST['message'], $_POST['from']);
if ($successfullySent) {
$report['success'][$receip] = $receip;
} else {
public function search()
{
$data['user_id'] = $this->tank_auth->get_user_id();
$this->load->model('empleado_model');
$username = $this->tank_auth->get_username();
$data['nombre_de_usuario'] = $this->empleado_model->getName($username);
$data['is_admin'] = $this->tank_auth->is_admin();
$data['panelheading'] = "Empleados";
$centros = explode(",", $this->tank_auth->get_user_centros());
$data['empleado'] = $this->empleado_model->get_search($centros);
if (empty($data['empleado'])) {
$data['noencontrado'] = " <strong>Atencion!</strong><br>Empleado no encontrado o no pertenece a su adscripcion<br>Informacion en Recursos Humanos";
$data['empleado'] = NULL;
}
$data['options'] = listData('adscripciones', 'id', 'adscripcion', 'descripcion');
$data['index'] = "empleados/index";
$this->load->view('layouts/index', $data);
}
}
?>
</select>
<input class="search" type="text" name="s" value="<?php
echo isset($_GET['s']) ? $_GET['s'] : '';
?>
" />
<input type="submit" value="Rodyti" />
</form>
<ul class="poreikiailist">
<?php
$where = "SELECT need_id, need_name, cat_name, cat_id, user_city, need_regdate, a.deleted AS deleted FROM (SELECT need_id, need_name, cat_name, cat_id, need_type, need_needy, need_regdate, needs.deleted AS deleted FROM needs INNER JOIN cats ON needs.need_cat = cats.cat_id WHERE needs.need_type = {$fbsite} AND needs.need_full=0 AND needs.need_expires > NOW() AND needs.deleted = 0 {$filterCat}) a INNER JOIN needy ON a.need_needy = needy.user_id WHERE a.need_type = {$fbsite} {$filterCity} {$filterStok} {$srch} ORDER BY need_id DESC";
$c = 0;
if (pageNum() != 0) {
foreach (listData(false, false, pageNum(), $where, 15) as $pdata) {
echo '<li>';
echo '<a href="/poreikiai/id/' . $pdata['need_id'] . '">';
echo '<div class="icon" style="background-image: url(/img/c' . $pdata['cat_id'] . '.png);"></div>';
echo '<div class="name">' . $pdata['need_name'] . '</div>';
echo '<div class="city">' . $citiesList[$pdata['user_city']] . '</div>';
echo '</a>';
echo '</li>';
$c++;
}
}
if ($c == 0) {
err('Nerastas nė vienas poreikis');
}
?>
</ul>
foreach ($data0 as $pdata) {
echo '<li>';
echo '<a href="/poreikiai/id/' . $pdata['need_id'] . '">';
echo '<div class="icon" style="background-image: url(/img/c' . $pdata['cat_id'] . '.png);"></div>';
echo '<div class="name">' . $pdata['need_name'] . '</div>';
echo '<div class="city">' . $citiesList[$pdata['user_city']] . '</div>';
echo '</a>';
echo '</li>';
}
echo '</ul>';
if (count($data0) == 0) {
echo 'Sąrašas tuščias';
}
echo '<h2>Gauta pagalba</h2>';
echo '<ul class="poreikiailist smallersq">';
$data1 = listData(false, false, false, "SELECT * FROM needs LEFT JOIN cats ON needs.need_cat = cats.cat_id WHERE need_needy = {$id} AND need_type = {$site} AND needs.deleted = 0 AND need_full = 1");
foreach ($data1 as $pdata) {
echo '<li>';
echo '<a href="/poreikiai/id/' . $pdata['need_id'] . '">';
echo '<div class="icon" style="background-image: url(/img/c' . $pdata['cat_id'] . '.png);"></div>';
echo '<div class="name">' . $pdata['need_name'] . '</div>';
echo '<div class="city">' . $citiesList[$pdata['user_city']] . '</div>';
echo '</a>';
echo '</li>';
}
echo '</ul>';
if (count($data1) == 0) {
echo 'Sąrašas tuščias';
}
echo '</div><div class="page-sid"><div class="sid-back">';
echo '<h2>Pagalbos gavėjo kuratorius</h2><p>Norėdami padėti pagalbos gavėjui kreipkitės į šį kuratorių:</p>';
<?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'];
}
echo "<p class='debug'>{$field} updated from {$oldValue} to {$newValue}</p>";
}
}
}
break;
}
$fields = "InventoryDescription, InventoryTypeID,\tPurchasePrice,\tPurchaseLocation,\tInventoryLocationID,\tInventoryOwnerID, Picture1Location, Picture2Location,\tDateSold, InventoryConditionID, UPC, CustomID";
function filterDropDown()
{
dropdownFields($fields, "Filter By", "filterBy", $filterBy);
}
function orderDropDown()
{
dropdownFields($fields, "Order By", "orderBy", $orderBy);
}
listData($listQuery);
function listData($listQuery)
{
if (!($result = mysql_query($listQuery))) {
echo "<p class='error'>Could not find inventory listing " . mysql_error() . "</p>";
} else {
echo "<h2>Inventory</h2>";
orderDropDown();
filterDropDown();
$data = mysql_query($listQuery, $database);
echo "<form><table class='displayData'>";
// printing table rows
echo "<tr><th> </th><th>ID</th>";
foreach ($fields as $field) {
echo "<th>{$field}</th>";
}
}
$stokojantys = array();
$ops = listData('needy', "deleted = 0 {$parent} ORDER BY user_lname");
foreach ($ops as $op) {
$stokojantys[$op[0]] = $op['user_lname'] . ' ' . $op['user_fname'] . ' ' . $op['user_orgname'];
}
$options['fields']['need_needy'] = array('Stokojantis', 'inputtype' => 'drop', 'drops' => $stokojantys, 'required' => true);
$kats = array();
$ops = listData('cats', 'cat_type = ' . $need_cat_type . ' AND deleted = 0 AND cat_level = 0');
foreach ($ops as $op) {
$kats[$op[0]] = $op['cat_name'];
}
$options['fields']['need_cat'] = array('Kategorija', 'inputtype' => 'drop', 'drops' => $kats, 'required' => true);
if ($usermeta['need_type'] == 2) {
$subkats = array();
$ops = listData('cats', 'cat_type = ' . $need_cat_type . ' AND deleted = 0 AND cat_level = 1 AND cat_parent = ' . $usermeta['need_subcat']);
foreach ($ops as $op) {
$subkats[$op[0]] = $op['cat_name'];
}
$options['fields']['need_subcat'] = array('Subkategorija', 'inputtype' => 'drop', 'drops' => $subkats, 'required' => true);
}
$options['fields']['need_name'] = array('Pavadinimas', 'required' => true);
$options['fields']['need_desc'] = array('Aprašymas', 'inputtype' => 'textarea', 'required' => true);
$options['fields']['need_expires'] = array('Galiojimo laikas', 'required' => true);
updateUsermeta($options, $us, 'needs', 'need_id');
echo '<br><hr><br>';
$options = array();
$options['fields']['need_full'] = array('Poreikis patenkintas', 'inputtype' => 'drop', 'drops' => array('Ne', 'Taip'));
updateUsermeta($options, $us, 'needs', 'need_id');
if ($usermeta['need_full'] == 1) {
echo '<br><hr><br>';
function getCatChildren($parent)
{
$children = array();
$ops = listData('cats', 'deleted = 0 AND cat_level = 1 AND cat_parent = ' . $parent);
foreach ($ops as $op) {
$children[$op[0]] = $op['cat_name'];
}
return $children;
}
<select class="form-control" name="pro_cat">
<option>Select category</option>
';
listData(category, cat_name, cat_id);
echo '
</select>
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">Brand:</label>
<div class="col-sm-8">
<select class="form-control" name="pro_brand" required>
<option>Select brand</option>
';
listData(brands, brand_name, brand_id);
echo '
</select>
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">Price (with tax):</label>
<div class="col-sm-8">
<input type="number" class="form-control" min="0" step="1" name="pro_price" required>
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">Picture:</label>
<div class="col-sm-8">
if (strlen($pagerow['user_thumb']) > 3) {
getThumbnail('users', $pagerow['user_id']);
} else {
echo '<img src="/img/nt_ku.png" alt="nothumb" />';
}
echo '</div><div class="ku_desc">';
echo '<h2>' . $pagerow['user_fname'] . ' ' . $pagerow['user_lname'] . '</h2>';
echo '<b>Kuratorius</b>';
echo '<br>';
foreach ($regionsListChildren as $key => $cities) {
if (in_array($pagerow['user_city'], $cities)) {
echo '<a href="/regionuose?p=puslapis&pageslug=regionuose®=' . $key . '&city=all&ptype=2">' . $regionsList[$key] . '</a> > ';
$rgn = $key;
}
}
if (isset($rgn)) {
echo '<a href="/regionuose?p=puslapis&pageslug=regionuose®=' . $rgn . '&city=' . $pagerow['user_city'] . '&ptype=2">' . $citiesList[$pagerow['user_city']] . '</a>';
}
echo '<br>El. paštas: <a href="mailto:' . $pagerow['user_email'] . '">' . $pagerow['user_email'] . '</a>';
echo '<br><br>' . $pagerow['user_desc'] . '';
echo '</div>';
echo '</div><div class="page-sid"><div class="sid-back">';
echo '<h2>Kuruojami pagalbos gavėjai</h2><p>Kuratorius rūpinasi šiais pagalbos gavėjais:</p>';
echo '<ul class="kuruojami_list">';
foreach (listData(false, false, false, "SELECT * FROM needy LEFT JOIN cats ON needy.user_cat = cats.cat_id WHERE user_parent = {$id} AND needy.deleted = 0") as $data) {
echo '<li><a class="ku_name" href="/stokojantysis/' . $data['user_id'] . '">';
echo $data['user_fname'] . ' ' . $data['user_lname'] . ' ' . $data['user_orgname'];
echo '</a><span class="ku_city">' . $citiesList[$data['user_city']] . '</span></li>';
}
echo '</ul>';
echo '</div></div></div>';
$pgcon_exploded = explode('[PARASTE]', $pagerow['page_content']);
echo $pgcon_exploded[0];
}
}
if ($page_slug == 'regionuose') {
if (isset($_GET['reg']) and $_GET['reg'] < 10) {
$regionas = $_GET['reg'];
} else {
$regionas = 9;
}
echo '<h2>Pagalba visoje Lietuvoje</h2><p>Stipraus savanorių tinklo ir partnerių pagalba, <b>Pagalbadaiktais.lt</b> veikla vyksta visoje Lietuvoje.</p>';
echo '<h2>' . ((isset($_GET['city']) and $_GET['city'] != 'all' and in_array($_GET['city'], $regionsListChildren[$regionas])) ? $citiesList[$_GET['city']] : $regionsList[$regionas]) . '</h2>';
$table = (isset($_GET['ptype']) and $_GET['ptype'] == 1) ? 'needy' : 'users';
$onlyactive = (isset($_GET['ptype']) and $_GET['ptype'] == 1) ? 'AND deleted = 0' : 'AND user_active = 1 AND user_acctype > 0 AND user_acctype < 3';
$where = (isset($_GET['city']) and $_GET['city'] != 'all' and in_array($_GET['city'], $regionsListChildren[$regionas])) ? 'user_city = ' . $_GET['city'] . ' ' . $onlyactive : 'user_region = ' . $regionas . ' ' . $onlyactive;
$data = listData($table, $where);
if (count($data) > 0) {
echo '<table class="regtable">';
foreach ($data as $item) {
echo '<tr>';
echo '<td style="width: 150px;">' . $citiesList[$item['user_city']] . '</td>';
echo '<td style="width: 220px;">';
if ($table == 'users') {
echo '<a href="/kuratorius/' . $item['user_id'] . '">';
}
if ($table == 'needy') {
echo '<a href="/stokojantysis/' . $item['user_id'] . '">';
}
if (isset($item['user_person']) and $item['user_person'] == 0) {
echo $item['user_fname'] . ' ' . $item['user_lname'];
} elseif (isset($item['user_person']) and $item['user_person'] == 1) {
case "select":
echo "<p class='debug'>TestCaseID: {$TestCaseID} :: ID: {$id}</p>";
if ($TestCaseID != "") {
getTestCaseItem($TestCaseID, $userID);
} else {
if ($id != "") {
getTestCaseItem($id, $userID);
}
}
break;
case "edit":
updateTestCaseItem($TestCaseID, $TestCaseDescription, $DateLogged, $DateTested, $PreaparedBy, $TestedBy, $Module, $FeatureName, $UseCaseID, $TestData, $TestSteps, $ExpectedResults, $ActualResults, $Pass, $PriorityID);
listData($userID, $listQuery, $action);
break;
case "":
listData($userID, $listQuery, $action);
break;
}
function filterDropDown($fields)
{
dropdownFields($fields, "Filter By", "filterBy", $filterBy);
}
function orderDropDown($fields)
{
dropdownFields($fields, "Order By", "orderBy", $orderBy);
}
function listData($userID, $listQuery, $action)
{
listTestCase($userID, $listQuery, $action);
echo "<br /><br /><a href='testCase.php?u={$userID}&action=new'>Add TestCase Item</a>";
}
include "admin_sidebar.php";
?>
</div>
<div class="col-md-8 ">
<?php
if ($status == 1) {
echo '
<div class="row selectCategory">
<form class="form" method="post" enctype="multipart/form-data">
<div class="form-group">
<div class="col-md-4">
<select class="form-control" name="ctgry_id">
<option>Vyber z kategorie</option>
';
listData(category, cat_name, cat_id);
echo '
</select>
</div>
<div class="col-md-2">
<input class=" btn btn-primary btn-block text-center" type="submit" name="ctgry" value="Submit">
</div>
</div>
</form>
</div>
<div class="panel panel-primary">
<div class="panel panel-heading text-center"><h4>Modify products in database</h4></div>
<div class="panel-body">
<table class="table table-striped table-hover">
redirect();
}
?>
<br></br>
<form action="" method="POST">
Nauja grupė <input type="text" name="gr" value="" maxlength="16" />
<input type="submit" value="Sukurti" />
</form>
<br><hr><br>
<?php
if (isset($_POST['setacctype'])) {
updateFieldWhere('users', 'user_temp_acctype', $_POST['setacctype'], "user_id = " . CUSER);
redirect(0, '/');
}
?>
<form action="" method="POST">
Įgauti teises
<select name="setacctype">
<?php
$atarr = array(1 => 'Kuratorius', 2 => 'Tinklo atstovas', 3 => 'Administratorius');
foreach (listData('acctypes', 'acctype != 1 and acctype != 2 and acctype != 3') as $acc) {
$atarr[$acc['acctype']] = $acc['name'];
}
foreach ($atarr as $key => $at) {
echo '<option value="' . $key . '">' . $at . '</option>';
}
?>
</select>
<input type="submit" value="Įgauti" />
</form>
$kuratoriai[$ku['user_id']] = $ku['user_fname'] . ' ' . $ku['user_lname'] . ' ' . $ku['user_orgname'];
}
$kuratoriai[CUSER] = '— Aš —';
$options = array();
if ($usermeta['user_person'] == 0) {
$options['fields']['user_fname'] = array('Vardas', 'required' => true);
$options['fields']['user_lname'] = array('Pavardė', 'required' => true);
} elseif ($usermeta['user_person'] == 1) {
$options['fields']['user_orgname'] = array('Pavadinimas', 'required' => true);
$options['fields']['user_code1'] = array('Įmonės kodas', 'len' => 9, 'required' => true);
$options['fields']['user_code2'] = array('PVM mokėtojo kodas', 'len' => 14);
$options['fields']['user_reg'] = array('Registras', 'len' => 128);
}
$ct = $usermeta['user_person'] == 1 ? 2 : 1;
$cats = array();
foreach (listData('cats', 'cat_type = ' . $ct . ' AND deleted = 0') as $cat) {
$cats[$cat[0]] = $cat[1];
}
$getReg = $usermeta['user_region'];
$regionChildren = array();
foreach ($regionsListChildren[$getReg] as $children) {
$regionChildren[$children] = $citiesList[$children];
}
if (isset($_POST['user_parent'])) {
updateFieldWhere('needy', 'user_parent_ta', getManagerParent($_POST['user_parent']), 'user_id=' . $us);
}
$options['fields']['user_address'] = array('Adresas', 'required' => true);
$options['fields']['user_cat'] = array('Kategorija', 'required' => true, 'inputtype' => 'drop', 'drops' => $cats);
$options['fields']['user_region'] = array('Apskritis', 'inputtype' => 'drop', 'drops' => $regionsList, 'required' => true);
$options['fields']['user_city'] = array('Miestas', 'inputtype' => 'drop', 'drops' => $regionChildren, 'required' => true);
$options['fields']['user_phone'] = array('Telefonas', 'len' => 11, 'required' => true);
public function search()
{
$data['user_id'] = $this->tank_auth->get_user_id();
$this->load->model('empleado_model');
$this->load->helper('dropdown');
$username = $this->tank_auth->get_username();
$data['nombre_de_usuario'] = $this->empleado_model->getName($username);
$data['is_admin'] = $this->tank_auth->is_admin();
$data['panelheading'] = "Reporte Sin derecho a nota buena por desempeno";
$centros = explode(",", $this->tank_auth->get_user_centros());
$data['empleado'] = $this->empleado_model->get_search($centros);
if (empty($data['empleado'])) {
$data['noencontrado'] = " <strong><i class='fa fa-exclamation-triangle'></i> Atencion!</strong><br>Empleado no encontrado o no pertenece a su adscripcion<br>Informacion en Recursos Humanos";
$data['empleado'] = NULL;
}
$data['options'] = listData('adscripciones', 'id', 'adscripcion', 'descripcion', 'ASC', ' - ');
$data['index'] = 'reportes/sin_derecho';
$this->load->view('layouts/index', $data);
}
$numRows = mysql_num_rows($qry);
if ($numRows >= 1) {
echo "Error: Kode kelompok sudah pernah terdaftar sebelumnya.";
} else {
$strIns = "insert into " . $dbname . ".sdm_5kldiagnosa (kodekelompok,deskripsi) \r\n\t\t\tvalues ('" . $kodekelompok . "','" . $deskripsi . "')";
if (mysql_query($strIns)) {
listData();
} else {
echo "DB Error : " . mysql_error($conn);
}
}
break;
case 'update':
$str = "update " . $dbname . ".sdm_5kldiagnosa set deskripsi='" . $deskripsi . "' where kodekelompok='" . $kodekelompok . "'";
if (mysql_query($str)) {
listData();
} else {
echo "DB Error : " . mysql_error($conn);
}
break;
case 'delete':
$str = "delete from " . $dbname . ".sdm_5kldiagnosa where kodekelompok='" . $kodekelompok . "'";
if (mysql_query($str)) {
} else {
echo "DB Error : " . mysql_error($conn);
}
break;
default:
break;
}
function listData()
<input name="editable" type="text" value="" maxlength="128">
Tėvinė kategorija
<select name="cat">
<option value="0">— Neturi —</option>
<?php
foreach (listData('cats', 'cat_type = ' . $catType . ' AND deleted = 0 AND cat_level = 0') as $op) {
echo '<option value=' . $op[0] . '>' . $op[1] . '</option>';
}
?>
</select>
<input type="submit" name="editoption" value="Išsaugoti" />
</form>
<?php
$where = 'SELECT * FROM cats WHERE cat_type = ' . $catType . ' AND cat_level = 0 ORDER BY cat_name ASC';
$parents = listData(false, false, false, $where);
echo '<ul>';
foreach ($parents as $parent) {
echo '<li class="' . ($parent['deleted'] == 1 ? 'unmarked' : '') . '">';
echo '<span class="editablelistitem" data-parent="0" data-editsubcid="' . $parent['cat_id'] . '">' . $parent['cat_name'] . '</span> <a href="?p=' . page() . '&veiksmas=salinti¶m=' . $parent['cat_id'] . '"><i title="Trinti" class="fa fa-times"></i></a>';
$where = 'SELECT * FROM cats WHERE cat_type = ' . $catType . ' AND cat_level = 1 AND cat_parent=' . $parent['cat_id'] . ' ORDER BY cat_name ASC';
$children = listData(false, false, false, $where);
echo '<ul>';
foreach ($children as $child) {
echo '<li class="' . ($child['deleted'] == 1 ? 'unmarked' : '') . '">';
echo '<span class="editablelistitem" data-parent="' . $child['cat_parent'] . '" data-editsubcid="' . $child['cat_id'] . '">' . $child['cat_name'] . '</span> <a href="?p=' . page() . '&veiksmas=salinti¶m=' . $child['cat_id'] . '"><i title="Trinti" class="fa fa-times"></i></a>';
echo '</li>';
}
echo '</ul>';
echo '</li>';
}
echo '</ul>';
?>
</label><span class="required">*</span>
<?php
$data = array('name' => 'category_name', 'id' => 'category_name', 'placeholder' => 'Categoty Name', 'class' => 'form-control', 'size' => '50');
echo form_input($data);
?>
</div>
<div class="form-group">
<label for="category_name"><?php
echo $this->lang->line('ASSET_CATEGORY_PARENT');
?>
</label>
<?php
$dropdownItems = listData($CI->config->item('category_name'), 'id', 'name');
echo form_dropdown('category_parent', $dropdownItems, $selected = '', 'class="form-control" id="category_parent"');
?>
</div>
<div class="form-group">
<label for="category_name"><?php
echo $this->lang->line('ASSET_CATEGORY_ORDERING');
?>
</label>
<?php
$data = array('name' => 'ordering', 'id' => 'ordering', 'placeholder' => 'Category ordering', 'class' => 'form-control', 'size' => '50');
echo form_input($data);
?>
</div>
<div class="form-group">
$atarr = array(0 => 'Dovanotojas arba geradarys', 1 => 'Kuratorius', 2 => 'Tinklo atstovas', 3 => 'Administratorius');
foreach (listData('acctypes', 'acctype != 1 and acctype != 2 and acctype != 3') as $acc) {
$atarr[$acc['acctype']] = $acc['name'];
}
$options['fields']['user_acctype'] = array('Paskyros tipas', 'inputtype' => 'drop', 'drops' => $atarr, 'required' => true);
updateUsermeta($options, $us, 'users', 'user_id');
echo '<br>';
$usermeta = getRow('users', 'user_id = ' . $us);
}
if (isAdmin() and $usermeta['user_acctype'] == 1) {
if (isset($_POST['user_parent']) and $_POST['user_parent'] > 0) {
updateFieldWhere('needy', 'user_parent_ta', $_POST['user_parent'], "user_parent = {$us}");
}
// Tinklo atstovų sąrašas
$kuratoriai = array(0 => '— Nepriskirtas —');
$kuratoriaid = listData('users', 'user_acctype = 2 AND user_active = 1');
foreach ($kuratoriaid as $ku) {
$kuratoriai[$ku['user_id']] = $ku['user_fname'] . ' ' . $ku['user_lname'] . ' ' . $ku['user_orgname'];
}
$options = array('fields' => array('user_parent' => array('Priskirtas tinklo atstovas', 'inputtype' => 'drop', 'drops' => $kuratoriai)));
updateUsermeta($options, $us, 'users', 'user_id');
echo '<br>';
}
$usermeta = getRow('users', 'user_id = ' . $us);
$options = array();
$options['fields']['user_active'] = array('Paskyra aktyvuota', 'inputtype' => 'bool', 'required' => true);
$options['fields']['user_email'] = array('El. paštas', 'required' => true);
$options['fields']['user_password_hash'] = array('Slaptažodis', 'inputtype' => 'pass');
if ($usermeta['user_person'] == 0) {
$options['fields']['user_fname'] = array('Vardas', 'required' => true);
$options['fields']['user_lname'] = array('Pavardė', '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
include "functions.php";
include "views/cities.php";
if (isset($_POST['getRegionChild']) and isset($regionsListChildren[$_POST['getRegionChild']])) {
foreach ($regionsListChildren[$_POST['getRegionChild']] as $children) {
echo '<option value="' . $children . '">' . $citiesList[$children] . '</option>';
}
}
if (isset($_POST['getCatChild']) and isset($_POST['excludeCat'])) {
$ops = listData('cats', 'deleted = 0 AND cat_level = 1 AND cat_parent = ' . $_POST['getCatChild']);
foreach ($ops as $op) {
if ($_POST['excludeCat'] != $op[0]) {
echo '<option value="' . $op[0] . '">' . $op['cat_name'] . '</option>';
}
}
} elseif (isset($_POST['getCatChild'])) {
$ops = listData('cats', 'deleted = 0 AND cat_level = 1 AND cat_parent = ' . $_POST['getCatChild']);
foreach ($ops as $op) {
echo '<option value="' . $op[0] . '">' . $op['cat_name'] . '</option>';
}
}
function updateAdmin($database, $idname, $id)
{
global $con;
$sql = 'SELECT * FROM ' . $database . ' WHERE ' . $idname . '="' . $id . '"';
$run_sql = mysqli_query($con, $sql);
$data = mysqli_fetch_array($run_sql);
if ($database == 'products') {
$data_id = $data['pro_id'];
$data_category = $data['pro_category'];
$data_brand = $data['pro_brand'];
$data_name = $data['pro_name'];
$data_price = $data['pro_price'];
$data_desc = $data['pro_desc'];
$data_keywords = $data['pro_keywords'];
$data_image = $data['pro_image'];
$sql = 'SELECT * FROM category WHERE cat_id=' . $data_category . '';
$run_sql = mysqli_query($con, $sql);
$data = mysqli_fetch_array($run_sql);
$category_name = $data['cat_name'];
$sql = 'SELECT * FROM brands WHERE brand_id=' . $data_brand . '';
// echo $sql;
$run_sql = mysqli_query($con, $sql);
$data = mysqli_fetch_array($run_sql);
$brand = $data['brand_name'];
echo '
<form class="form-horizontal" method="post" enctype="multipart/form-data">
<div class="form-group">
<label class="control-label col-sm-2">ID:</label>
<div class="col-sm-1">
<input type="text" class="form-control" value="' . $data_id . '" name="pro_id" readOnly="true">
</div>
<label class="control-label col-sm-2">Product name:</label>
<div class="col-sm-5">
<input type="text" class="form-control" value="' . $data_name . '" name="pro_name" required>
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">Category:</label>
<div class="col-sm-8">
<select class="form-control" name="pro_cat">
<option value="' . $data_category . '" selected="selected">' . $category_name . '</option>
<option disabled>──────────</option>
';
listData(category, cat_name, cat_id);
echo '
</select>
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">Brand:</label>
<div class="col-sm-8">
<select class="form-control" name="pro_brand" required>
<option value="' . $data_brand . '" selected="selected">' . $brand . '</option>
<option disabled>──────────</option>
';
listData(brands, brand_name, brand_id);
echo '
</select>
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">Price (with tax):</label>
<div class="col-sm-8">
<input type="number" value="' . $data_price . '" class="form-control" min="0" step="1" name="pro_price" required>
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">Image:</label>
<div class="col-sm-8">
<img src="product_images/' . $data_image . '" style="max-width: 150px; heigh: auto;">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">Description:</label>
<div class="col-sm-8">
<textarea class = "form-control" rows = "7" name="pro_desc">' . $data_desc . '</textarea>
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">Keywords:</label>
<div class="col-sm-8">
<input type="text" class="form-control" value="' . $data_keywords . '" name="pro_keywords"/>
</div>
</div>
<div class="form-group">
<div class="row">
<div class="col-sm-2"></div>
<div class="col-sm-8">
<input class=" btn btn-warning btn-block text-center" action="update.php" type="submit" name="update_product" value="Update" />
</div>
</div>
</div>
</form>
';
}
if ($database == 'category') {
$data_id = $data['cat_id'];
$data_name = $data['cat_name'];
echo '
<form class="form-horizontal" method="post" enctype="multipart/form-data">
<div class="form-group">
<label class="control-label col-sm-2">ID:</label>
<div class="col-sm-1">
<input type="text" class="form-control" value="' . $data_id . '" name="cat_id" readOnly="true">
</div>
<label class="control-label col-sm-2">Category name:</label>
<div class="col-sm-5">
<input type="text" class="form-control" value="' . $data_name . '" name="cat_name" required>
</div>
</div>
<div class="form-group">
<div class="row">
<div class="col-sm-2"></div>
<div class="col-sm-8">
<input class=" btn btn-warning btn-block text-center" action="update.php" type="submit" name="update_category" value="Update" />
</div>
</div>
</div>
</form>
';
}
if ($database == 'brands') {
$data_id = $data['brand_id'];
$data_name = $data['brand_name'];
echo '
<form class="form-horizontal" method="post" enctype="multipart/form-data">
<div class="form-group">
<label class="control-label col-sm-2">ID:</label>
<div class="col-sm-1">
<input type="text" class="form-control" value="' . $data_id . '" name="brand_id" readOnly="true">
</div>
<label class="control-label col-sm-2">Category name:</label>
<div class="col-sm-5">
<input type="text" class="form-control" value="' . $data_name . '" name="brand_name" required>
</div>
</div>
<div class="form-group">
<div class="row">
<div class="col-sm-2"></div>
<div class="col-sm-8">
<input class=" btn btn-warning btn-block text-center" action="update.php" type="submit" name="update_brand" value="Update" />
</div>
</div>
</div>
</form>
';
}
}
function estadistica()
{
$this->load->helper('dropdown');
$this->load->model('empleado_model');
$this->load->model('qna_model');
$data['user_id'] = $this->tank_auth->get_user_id();
$username = $this->tank_auth->get_username();
$data['nombre_de_usuario'] = $this->empleado_model->getName($username);
$data['panelheading'] = "Ausentismo";
$data['qnas'] = listData('qnas', 'id', 'qna_mes', 'qna_year', 'DESC', '/');
//$data['qnas'] = $this->qna_model->order_by('qna_year','ASC')->order_by('qna_mes','ASC')->get_all();
$data['index'] = "admin/estadistica/index";
$this->load->view('layouts/index', $data);
}
