PHP getSort示例

示例#1

文件： helpers.php 项目： royston-bowmaker/switch-media-aptitude

function tableTitle($title)
{
    $sort = getSort();
    $field = strtolower(str_replace(' ', '_', $title));
    $page = getPageNumber();
    $sortDir = getSortDir($field);
    $sortChar = !empty($sort) ? 1 : '';
    return '<a href="?page=' . $page . '&sort=' . $field . '&sortDir=' . $sortDir . '">' . $title . '</a>';
}

示例#2

文件： UserController.php 项目： royston-bowmaker/switch-media-aptitude

 public function listUsers()
 {
     //Variables
     $users = DB::table('user');
     $sort = getSort();
     $search = Input::get('search');
     //Search
     if (!empty($search)) {
         $users = $users->where('first_name', 'LIKE', "%{$search}%")->orWhere('last_name', 'LIKE', "%{$search}%");
     }
     //Sort
     if (!empty($sort)) {
         $users = $users->orderBy($sort, getSortDir());
     }
     //Paginate
     $users = $users->paginate($this->pageSize);
     //Return ViewData
     return view('users', ['sort' => $sort, 'users' => $users, 'pageNum' => getPageNumber(), 'sortDir' => getSortDir(), 'detailsURL' => '/public/user-info/']);
 }

示例#3

文件： need.php 项目： vsi-geros-valios-projektai/admin.pagalbadaiktais.lt

		'left fc-16',
		'',
		),
		
	);
*/
if (isAdmin()) {
    $parent = '';
} elseif (isManager() or isGridManager()) {
    $parent = 'AND needy.user_parent = ' . CUSER;
    /*elseif(isGridManager()) :
    		$children = array();
    		foreach(listData('users', 'user_acctype = 1 AND user_active = 1 AND user_parent = '.CUSER) as $child) $children[] = 'needy.user_parent = '.$child['user_id'];
    		$parent = 'AND (('.implode(' OR ', $children).') OR needy.user_parent_ta = '.CUSER.')';*/
}
getSort('need_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();
?>

示例#4

文件： pages.php 项目： vsi-geros-valios-projektai/admin.pagalbadaiktais.lt

<?php

if ($login->isUserLoggedIn() == false) {
    return;
}
if (!isAdmin() and !(isCustom() and haveRight(6))) {
    return;
}
if (isAction('salinti') and getParam()) {
    $row = getRow('pages', 'page_id = ' . getParam());
    $act = $row['deleted'];
    $act = !$act;
    updateFieldWhere('pages', 'deleted', $act, 'page_id = ' . getParam());
    redirect(0, getCurrentLink());
}
$tablefields = array('page_id', 'page_name', 'page_modified', array('converter' => array('page_id', 'getPageEditLink')), array('convArray' => array(array('page_slug', 'page_site'), 'getPageLinks')), array('action' => array('page_id', 'salinti', '<i title="Šalinti/atnaujinti" class="fa fa-times"></i>', false)), 'null');
$tablehead = array('titles' => array('ID', 'Pavadinimas', 'Modifikuotas', '', '', '', ''), 'columns' => array('right fc-60', 'left fc-verylong', 'left fc-150', 'left fc-18', 'left fc-30', 'left fc-16', ''));
getSort('page_id');
$where = 'SELECT * FROM pages WHERE page_type = 0 ORDER BY ' . $getsort . $getorder;
$sortby = array(0 => 'page_id', 1 => 'page_name', 2 => 'page_modified');
formatTable(listData(false, false, pageNum(), $where), $tablefields, $tablehead, $sortby, true, 'nomargin');
pagination(countData(false, false, $where));
?>

<br><br>
<a href="?p=editpage"><i class="fa fa-asterisk"></i> Sukurti puslapį</a>

示例#5

文件： thing.php 项目： vsi-geros-valios-projektai/admin.pagalbadaiktais.lt

            $children[] = 'needy.user_parent = ' . $child['user_id'];
        }
        $parent = '((' . implode(' OR ', $children) . ') OR needy.user_parent_ta = ' . CUSER . ')';
        if (countData(false, false, "SELECT * FROM needs INNER JOIN needy ON needs.need_needy = needy.user_id WHERE needs.need_id = " . getParam() . " AND " . $parent) == 0) {
            err('Neturite teisės keisti šio poreikio duomenis', 'red');
            return;
        }
    }
    $row = getRow('needs', 'need_id = ' . getParam());
    $act = $row['need_full'];
    $act = !$act;
    updateFieldWhere('needs', 'need_full', $act, 'need_id = ' . getParam());
    redirect(0, getCurrentLink());
}
$tablefields = array('need_id', 'need_name', 'need_full_desc', 'need_regdate', array('converter' => array('need_id', 'getThingEditLink')), array('action' => array('need_id', 'atkurti', '<i title="Patenkintą poreikį padaryti nepatenkintu ir grąžinti į Poreikių lentelę" class="fa fa-undo"></i>', false)), 'null');
$tablehead = array('titles' => array('ID', 'Pavadinimas', 'Aprašymas', 'Modifikuotas', '', '', ''), 'columns' => array('right fc-60', 'left fc-150', 'left fc-300', 'left fc-dates', 'left fc-16', 'left fc-16', ''));
if (isAdmin()) {
    $parent = '';
} elseif (isManager() or isGridManager()) {
    $parent = 'AND needy.user_parent = ' . CUSER;
    /*elseif(isGridManager()) :
    		$children = array();
    		foreach(listData('users', 'user_acctype = 1 AND user_active = 1 AND user_parent = '.CUSER) as $child) $children[] = 'needy.user_parent = '.$child['user_id'];
    		$parent = 'AND (('.implode(' OR ', $children).') OR needy.user_parent_ta = '.CUSER.')';*/
}
getSort('need_fulldate');
$where = 'SELECT need_fulldate, need_full_desc, need_needy, need_id, need_name, cat_name, user_fname, user_lname, need_regdate, a.deleted AS deleted FROM (SELECT need_fulldate, need_full_desc, need_id, need_name, cat_name, need_type, need_needy, need_regdate, needs.deleted AS deleted FROM needs LEFT JOIN cats ON needs.need_cat = cats.cat_id WHERE needs.need_type=' . subpage() . ' AND needs.need_full=1) a LEFT JOIN needy ON a.need_needy = needy.user_id WHERE a.need_type=' . subpage() . ' ' . $parent . ' ORDER BY ' . $getsort . $getorder;
$sortby = array(0 => 'need_id', 1 => 'need_name', 3 => 'need_regdate');
formatTable(listData(false, false, pageNum(), $where), $tablefields, $tablehead, $sortby, true, 'nomargin');
pagination(countData(false, false, $where));
$poreikis = array(1 => 'darbų', 2 => 'daiktų');

示例#6

文件： needyman.php 项目： vsi-geros-valios-projektai/admin.pagalbadaiktais.lt

    if (isset($_POST['reason']) or $act == 0) {
        updateFieldWhere('needy', 'deleted', $act, 'user_id = ' . getParam());
        if (isset($_POST['reason']) and ($_POST['reason'] == 1 or $_POST['reason'] == 2 or $_POST['reason'] == 3)) {
            updateFieldWhere('needy', 'delreason', $_POST['reason'], 'user_id = ' . getParam());
        }
        redirect(0, getCurrentLink());
        return;
    }
    ?>
	<form class="simpleform" action="" method="POST">
		Pažymėkite šalinimo priežastį:<br><br>
			<input checked="checked" name="reason" type="radio" value="1" />nebereikalinga parama/pagalba<br>
			<input name="reason" type="radio" value="2" />privatumo problema<br>
			<input name="reason" type="radio" value="3" />pastebėtas sukčiavimas<br>
		<br><input type="submit" value="Siųsti" />
	</form>
	<?php 
    return;
}
$tablefields = array('user_id', array('converter' => array('user_thumb', 'getThumb')), 'user_fname', 'user_lname', 'user_orgname', 'user_phone', array('converter' => array('user_city', 'getCountry')), 'kuratorius', array('converter' => array('user_id', 'getNeedyEditLink')), array('action' => array('user_id', 'salinti', '<i title="Šalinti/atnaujinti" class="fa fa-times"></i>', false)), 'null');
$tablehead = array('titles' => array('ID', '', 'Vardas', 'Pavardė', 'Organizacija', 'Telefonas', 'Savivaldybė', 'Kuratorius', '', '', ''), 'columns' => array('right fc-60', 'left fc-30', 'left fc-75', 'left fc-100', 'left fc-100', 'left fc-90', 'left fc-125', 'left fc-125', 'left fc-16', 'left fc-16', ''));
$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 user_parent_ta = ' . CUSER . ')';
getSort('user_id');
$where = 'SELECT needy.user_id, needy.user_thumb, needy.user_fname, needy.user_lname, needy.user_orgname, needy.user_phone, needy.user_city, needy.deleted, CONCAT(users.user_fname, " ", users.user_lname) as kuratorius FROM needy LEFT JOIN users ON needy.user_parent = users.user_id WHERE user_type=0 ' . $parent . ' ORDER BY ' . $getsort . $getorder;
$sortby = array(0 => 'user_id', 2 => 'user_fname', 3 => 'user_lname', 4 => 'user_orgname', 5 => 'user_phone', 6 => 'user_city', 7 => 'kuratorius');
formatTable(listData(false, false, pageNum(), $where), $tablefields, $tablehead, $sortby, true, 'nomargin');
pagination(countData(false, false, $where));

示例#7

文件： search.php 项目： vsi-geros-valios-projektai/admin.pagalbadaiktais.lt

<?php

if ($login->isUserLoggedIn() == false) {
    return;
}
if (!isAdmin() and !isManager() and !isGridManager()) {
    return;
}
$tablefields = array('obj_type', 'obj_name', 'obj_desc', array('convArray' => array(array('obj_type', 'obj_id'), 'getSearchLink')), 'null');
$tablehead = array('titles' => array('Tipas', 'Rezultatas', 'Kita informacija', '', ''), 'columns' => array('left fc-150', 'left fc-150', 'left fc-300', 'left fc-16', ''));
$term = isset($_GET['srch']) ? $_GET['srch'] : '';
if ($term == '' or strlen($term) < 3) {
    err('Per trumpa paieškos užklausa');
    return;
}
getSort('obj_id');
$where = "\n\tSELECT user_id AS obj_id, 'Vartotojas' AS obj_type, CONCAT(user_fname, ' ', user_lname, ' ', user_orgname) AS obj_name, CONCAT('Paskyros vardas: ', user_name,', el. paštas: ', user_email, ', telefonas: ', user_phone) AS obj_desc FROM users WHERE user_name LIKE ('%{$term}%') OR user_fname LIKE ('%{$term}%') OR user_lname LIKE ('%{$term}%') OR user_orgname LIKE ('%{$term}%') OR user_phone LIKE ('%{$term}%') OR user_email LIKE ('%{$term}%')\n\tUNION\n\tSELECT user_id AS obj_id, 'Stokojantysis' AS obj_type, CONCAT(user_fname, ' ', user_lname, ' ', user_orgname) AS obj_name, CONCAT('El. paštas: ', user_email, ', telefonas: ', user_phone) AS obj_desc FROM needy WHERE user_fname LIKE ('%{$term}%') OR user_lname LIKE ('%{$term}%') OR user_orgname LIKE ('%{$term}%') OR user_phone LIKE ('%{$term}%') OR user_email LIKE ('%{$term}%')\n\tUNION\n\tSELECT need_id AS obj_id, 'Dovanotojas/geradarys' AS obj_type, CONCAT(user_fname, ' ', user_lname) AS obj_name, CONCAT('El. paštas: ', user_email, ', telefonas: ', user_phone) AS obj_desc FROM needs WHERE user_fname LIKE ('%{$term}%') OR user_lname LIKE ('%{$term}%') OR user_phone LIKE ('%{$term}%') OR user_email LIKE ('%{$term}%')\n\tUNION\n\tSELECT need_id AS obj_id, 'Daiktas/darbas' AS obj_type, need_name AS obj_name, need_desc AS obj_desc FROM needs WHERE need_name LIKE ('%{$term}%')\n\t";
$sortby = false;
formatTable(listData(false, false, pageNum(), $where), $tablefields, $tablehead, $sortby, true, 'nomargin');
pagination(countData(false, false, $where));