$AppUI->setState('CompIdxOrderBy', $_GET['orderby']); $AppUI->setState('CompIdxOrderDir', $orderdir); } $orderby = $AppUI->getState('CompIdxOrderBy') ? $AppUI->getState('CompIdxOrderBy') : 'company_name'; $orderdir = $AppUI->getState('CompIdxOrderDir') ? $AppUI->getState('CompIdxOrderDir') : 'asc'; $owner_filter_id = intval(dPgetParam($_REQUEST, 'owner_filter_id', 0)); if ($owner_filter_id !== 0) { $AppUI->setState('owner_filter_id', $owner_filter_id); } else { $owner_filter_id = $AppUI->getState('owner_filter_id', -1); } // load the company types $types = dPgetSysVal('CompanyType'); // get any records denied from viewing $obj = new CCompany(); $deny = $obj->getDeniedRecords($AppUI->user_id); // Company search by Kist $search_string = dPgetParam($_REQUEST, 'search_string', ''); if ($search_string != '') { $search_string = $search_string == '-1' ? '' : $search_string; $AppUI->setState('search_string', $search_string); } else { $search_string = $AppUI->getState('search_string'); } //$canEdit = getPermission($m, 'edit'); // retrieve list of records $search_string = $AppUI->___($search_string); $q = new DBQuery(); $q->addTable('users', 'u'); $q->addTable('contacts', 'con'); $q->addQuery('user_id');