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); }