getRole()->hasPerm(Canned::PERM_MANAGE, false)) $departments[] = $thisstaff->getDeptId(); foreach($thisstaff->dept_access as $da) { if ($da->role->hasPerm(Canned::PERM_MANAGE, false)) $departments[] = $da->dept->getId(); } $departments = implode(',', $departments); $qs = array(); $sql='SELECT canned.*, count(attach.file_id) as files, dept.name as department '. ' FROM '.CANNED_TABLE.' canned '. ' LEFT JOIN '.DEPT_TABLE.' dept ON (dept.id=canned.dept_id) '. ' LEFT JOIN '.ATTACHMENT_TABLE.' attach ON (attach.object_id=canned.canned_id AND attach.`type`=\'C\' AND NOT attach.inline)'; $sql.= sprintf(' WHERE canned.dept_id = 0 OR dept.id IN (%s)', $departments); $sortOptions=array('title'=>'canned.title','status'=>'canned.isenabled','dept'=>'department','updated'=>'canned.updated'); $orderWays=array('DESC'=>'DESC','ASC'=>'ASC'); $sort=($_REQUEST['sort'] && $sortOptions[strtolower($_REQUEST['sort'])])?strtolower($_REQUEST['sort']):'title'; //Sorting options... if($sort && $sortOptions[$sort]) { $order_column =$sortOptions[$sort]; } $order_column=$order_column?$order_column:'canned.title'; if($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) { $order=$orderWays[strtoupper($_REQUEST['order'])]; } $order=$order?$order:'ASC'; if($order_column && strpos($order_column,',')){ $order_column=str_replace(','," $order,",$order_column); } $x=$sort.'_sort'; $$x=' class="'.strtolower($order).'" '; $order_by="$order_column $order "; $total=db_count('SELECT count(*) FROM '.CANNED_TABLE.' canned '); $page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1; $pageNav=new Pagenate($total, $page, PAGE_LIMIT); $qstr = '&'. Http::build_query($qs); $qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']); $pageNav->setURL('canned.php', $qs); //Ok..lets roll...create the actual query $qstr .= '&order='.($order=='DESC'?'ASC':'DESC'); $query="$sql GROUP BY canned.canned_id ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit(); $res=db_query($query); if($res && ($num=db_num_rows($res))) $showing=$pageNav->showing().' '._N('premade response', 'premade responses', $total); else $showing=__('No premade responses found!'); ?>

':''; ?>

	href="canned.php?&sort=title">	href="canned.php?&sort=status">	href="canned.php?&sort=dept">	href="canned.php?&sort=updated">
/>		'.__('Disabled').''; ?>
:

'.__('Page').':'.$pageNav->getPageLinks().' '; ?>