Ejemplo n.º 1
0
    $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');