Esempio n. 1
0
if (!ereg("[0-9]{4}-[0-9]{2}-[0-9]{2}", $pattern)) {
    $pattern_flag = false;
}
if ($pattern != '' && $pattern_flag == true) {
    $query = 'select count(*) as num from jGetMsgsEx(date(NOW()) -7, date(NOW()));';
} else {
    $query = 'select count(*) as num from jGetMsgsEx(date(NOW()) - 7, date(NOW()));';
}
//echo $query;
$db->query($query);
$all_num = $db->value[0]['num'];
$coms = array();
if ($all_num > 0) {
    if ($pattern != '' && $pattern_flag == true) {
        $query = 'SELECT * FROM jGetMsgsEx( \'' . db_class::escape_like($pattern) . '\', date(NOW()));';
    } else {
        $query = 'SELECT * FROM jGetMsgsEx( date(NOW())-7, date(NOW()))';
    }
    $db->query($query);
    $coms = $db->value;
}
$empl = new collection();
$empl->Load(TABLE_DLS, false, $where, 'name ASC');
$empl = $empl->_collection;
$cats = new collection();
$cats->Load(TABLE_OBJECTS, false, $where, 'name ASC');
$cats = $cats->_collection;
$page_break = get_page_break(SITE_URI_ROOT . $STORAGE['module'] . '/' . $STORAGE['action'] . '/', $all_num, $from, LIMIT_COMPANY_ON_PAGE, LIMIT_PAGE_ON_PAGE, $additional_vars);
include SITE_FILE_ROOT . 'template/header.php';
include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/view.php';
include SITE_FILE_ROOT . 'template/footer.php';
Esempio n. 2
0
        $where = $department_id > 0 ? '"department_id"=' . $department_id : 'department_id IS NULL';
        $query = 'SELECT * FROM "' . VIEW_EMPLOYEE . '" WHERE ' . $where . '  ORDER BY name ASC';
        $db->query($query);
        $employees = $db->value;
        $where = $department_id > 0 ? 'parent_id=' . $department_id : 'parent_id IS NULL';
        $query = 'SELECT * FROM "' . TABLE_DEPARMENT . '" WHERE ' . $where . ' ORDER BY name ' . $sort_dep_dir;
        $db->query($query);
        $departments = $db->value;
        for ($i = 0; $i < count($departments); $i++) {
            $employees = array_merge($employees, get_employee_in_dep($departments[$i]['id_department'], $sort_dep_dir));
        }
        return $employees;
    }
    $employees = get_employee_in_dep($department_id, $sort_dir);
    $employees = array_slice($employees, $from, LIMIT_EMPLOYEE_ON_PAGE);
    $page_break = get_page_break(SITE_URI_ROOT . $STORAGE['module'] . '/' . $STORAGE['action'] . '/', $all_num, $from, LIMIT_EMPLOYEE_ON_PAGE, LIMIT_PAGE_ON_PAGE, $additional_vars, 'Aclick');
}
$dep = new department();
$emp = new employee();
for ($i = 0; $i < count($employees); $i++) {
    $dep->Init();
    $dep->id_department = $employees[$i]['department_id'];
    $dep->Load();
    $n = 0;
    $employees[$i]['department'] = array();
    $employees[$i]['department'][$n]['dep'] = $dep->name;
    if ($dep->head_id != 0) {
        $emp->id_employee = $dep->head_id;
        $emp->Load();
        $employees[$i]['department'][$n]['head'] = $emp->name;
    } else {