示例#1
0
文件: auth.php 项目: jsib/dumps.loc
function get_user_group($name=""){
	if($name=="") $name=$_SESSION['user'];
	$group='';
	$user=db_easy("SELECT `group` FROM `users` WHERE `name`='$name'");
	$group=$user['group'];
	return $group;
}
示例#2
0
function show_branch()
{
    switch (@$_GET['message']) {
        case "branchjustadded":
            $message_html = template_get("message", array('message' => "Город успешно добавлен"));
            break;
        default:
            $message_html = template_get("nomessage");
    }
    $branch_id = $_GET['branch'];
    $branch = db_easy("SELECT * FROM `phpbb_branches` WHERE `id`={$branch_id}");
    $pointsRES = db_query("SELECT * FROM `phpbb_points` WHERE `branch_id`={$branch_id}");
    if (db_count($pointsRES) > 0) {
        while ($point = db_fetch($pointsRES)) {
            $points_html .= "<div style='padding-bottom:5px;'><a href='/manager.php?action=show_point&point={$point['id']}'>{$point['name']}</a></div>";
        }
    } else {
        $points_html = "-";
    }
    if (check_rights('add_branch')) {
        $edit_branch_html = "<a href='/manager.php?action=edit_branch&branch={$branch_id}' style='font-size:8pt;'>Редактировать</a>";
    }
    $html .= template_get("branches/show_branch", array('name' => $branch['name'], 'editbranch' => $edit_branch_html, 'message' => $message_html, 'points' => $points_html));
    return $html;
}
示例#3
0
function page_message()
{
    $message_id = $_GET['message'];
    $message = db_easy("SELECT * FROM `intr_message` WHERE `id`={$message_id}");
    $q_comm = db_query("SELECT * FROM `intr_comments` WHERE `message_id`={$message_id} ORDER BY `date` DESC");
    $user = db_easy("SELECT * FROM `users` WHERE `id`=" . $message['user_id']);
    $edit_del_comment_html = "";
    if (check_group("writer") || $user['name'] == get_user()) {
        $edit_del_message_html .= "<br/><a href='" . uri_make_v1(array("UriScript" => 'intranet.php', 'page' => 'message', 'message' => $message_id, 'edit_message' => 'yes', 'message' => $message['id'])) . "' style='font-size:8pt;'>Редактировать</a>";
        $edit_del_message_html .= "<a href='" . uri_make_v1(array("UriScript" => 'intranet.php', 'page' => 'message', 'message' => $message_id, 'delete_message' => 'yes', 'message' => $message['id'])) . "' style='padding-left:10px;font-size:8pt;' onClick=\"if(!confirm('Удалить?')) return false;\">Удалить</a>";
    }
    $comments_html = "";
    while ($comment = db_fetch($q_comm)) {
        $user = db_easy("SELECT * FROM `users` WHERE `id`={$comment['user_id']}");
        $comments_html .= "<div style='margin:15px 0 0 0;padding:0 0 0 10px;border-left:2px solid #AAA;'>";
        $comments_html .= "<span style='font-size:8pt;font-style:italic;'><b>" . $user['name_rus'] . ",</b> " . date("d.m.Y H:i", strtotime($comment['date'])) . "</span><br/>" . $comment['text'] . "</div>";
        if (check_group("writer") || $user['name'] == get_user()) {
            $comments_html .= "<a href='" . uri_make_v1(array("UriScript" => 'intranet.php', 'page' => 'message', 'message' => $message_id, 'edit_comment' => 'yes', 'comment' => $comment['id'])) . "' style='font-size:8pt;'>Редактировать</a>";
            $comments_html .= "<a href='" . uri_make_v1(array("UriScript" => 'intranet.php', 'page' => 'message', 'message' => $message_id, 'delete_comment' => 'yes', 'comment' => $comment['id'])) . "' style='padding-left:10px;font-size:8pt;' onClick=\"if(!confirm('Удалить?')) return false;\">Удалить</a>";
        }
    }
    $html .= template_get('message/message', array("user" => $user['name_rus'], "date" => date("d.m.Y", strtotime($message['date'])), "title" => $message['title'], "edit_del_message" => $edit_del_message_html, "text" => $message['text'], "uri_back" => uri_make_v1(array("UriScript" => "intranet.php")), "uri_comment" => uri_make_v1(array("UriScript" => "intranet.php", "page" => "message", "message" => $message_id, "add_comment" => "yes")), "comments" => $comments_html));
    //Подключаем подвал
    $html .= template_get('footer');
    return $html;
}
示例#4
0
function page_contact()
{
    $user_name = $_GET['name'];
    $user = db_easy("SELECT * FROM `users` WHERE `name`='" . $user_name . "'");
    $edit_del_comment_html = "";
    if (check_group("writer") || $user['name'] == get_user()) {
    }
    $html .= template_get('contacts/contact', array("name_rus" => $user['name_rus'], "position" => $user['position'], "mobile_phone" => $user['mobile_phone']));
    //Подключаем подвал
    $html .= template_get('footer');
    return $html;
}
示例#5
0
function delete_point()
{
    if (!check_rights('delete_point')) {
        //Возвращаем значение функции
        return "У вас нет соответствующих прав";
    }
    /*Получаем данные от пользователя*/
    $point_id = $_GET['point'];
    //Запрос к базе
    $point = db_easy("SELECT * FROM `phpbb_points` WHERE `id`={$point_id}");
    //Запрос к базе
    db_query("DELETE FROM `phpbb_points` WHERE `id`={$point_id}");
    //Отправляем HTTP заголовок
    header("location: /manager.php?action=list_points&message=pointdeleted&name={$point['name']}");
    //Возвращаем значение функции
    return $html;
}
示例#6
0
文件: it.php 项目: jsib/dumps.loc
function getOrAdd_model($name)
{
    $name = trim($name);
    if ($name != "") {
        $qstr = "SELECT * FROM `models` WHERE `name`='" . $name . "'";
        $q = db_query($qstr);
        if (db_count($q) > 0) {
            $model_id = db_easy($qstr)['id'];
        } else {
            db_query("INSERT INTO `models` SET `name`='" . $name . "'");
            $model_id = db_easy("SELECT * FROM `models` WHERE `name`='" . $name . "'")['id'];
        }
        return $model_id;
    } else {
        return 0;
    }
}
示例#7
0
function edit_branch()
{
    if (!check_rights('edit_branch')) {
        //Возвращаем значение функции
        return "У вас нет соответствующих прав";
    }
    $branch_id = $_GET['branch'];
    if (!isset($_POST['name'])) {
        switch (@$_GET['message']) {
            case "branchsaved":
                $message_html = template_get("message", array('message' => "Изменения сохранены"));
                break;
            case "emptybranchname":
                $message_html = template_get("errormessage", array('message' => "Название подразделения не может быть пустым"));
                break;
            case "samebranchexists":
                $message_html = template_get("errormessage", array('message' => "Подразделение с таким именем уже имеется"));
                break;
            default:
                $message_html = template_get("nomessage");
        }
        $branch = db_easy("SELECT * FROM `phpbb_branches` WHERE `id`={$branch_id}");
        $show_branch_html = "<a href='/manager.php?action=show_branch&branch={$branch_id}' style='font-size:8pt;'>Просмотреть</a>";
        $html .= template_get("branches/edit_branch", array('action' => "/manager.php?action=edit_branch&branch={$branch_id}", 'name' => $branch['name'], 'showbranch' => $show_branch_html, 'message' => $message_html));
    } else {
        $branch['name'] = trim($_POST['name']);
        $do = true;
        //Проверка на пустое название города
        $branch['name'] = trim($_POST['name']);
        if (!preg_match("/^.{1,70}\$/", $branch['name'])) {
            header("location: /manager.php?action=edit_branch&branch={$branch_id}&message=emptybranchname");
            $do = false;
        }
        //Проверка на наличие города с таким же именем
        if (db_easy_count("SELECT * FROM `phpbb_branches` WHERE `name`='{$branch['name']}'") > 0) {
            header("location: /manager.php?action=edit_branch&branch={$branch_id}&message=samebranchexists");
            $do = false;
        }
        if ($do) {
            db_query("UPDATE `phpbb_branches`\r\n\t\t\t\t\tSET `name`='{$branch['name']}'\r\n\t\t\t\t\tWHERE `id`={$branch_id}");
            header("location: /manager.php?action=edit_branch&branch={$branch_id}&message=branchsaved");
        }
    }
    return $html;
}
示例#8
0
function show_point()
{
    switch (@$_GET['message']) {
        case "pointjustadded":
            $message_html = template_get("message", array('message' => "Офис/склад успешно добавлен"));
            break;
        default:
            $message_html = template_get("nomessage");
    }
    $point_id = $_GET['point'];
    $point = db_easy("SELECT * FROM `phpbb_points` WHERE `id`={$point_id}");
    $branch = db_easy("SELECT * FROM `phpbb_branches` WHERE `id`={$point['branch_id']}");
    if (check_rights('edit_point')) {
        $edit_point_html = "<a href='/manager.php?action=edit_point&point={$point_id}' style='font-size:8pt;'>Редактировать</a>";
    }
    $contactsRES = db_query("SELECT * FROM `phpbb_users`\r\n\t\t\t\t\t\t\t\t\tWHERE (`user_type`=0 OR `user_type`=3) AND `username`!='root' AND `user_email`!='*****@*****.**'\r\n\t\t\t\t\t\t\t\t\t\t\tAND `point_id`={$point_id}\r\n\t\t\t\t\t\t\t\t\tORDER BY `username` ASC\r\n\t\t\t\t\t\t\t\t\t");
    $contacts_html = "";
    while ($contact = db_fetch($contactsRES)) {
        $contacts_html .= "<a href='/manager.php?action=show_contact&contact={$contact['user_id']}'>" . $contact['username'] . "</a><br/>";
    }
    $html .= template_get("points/show_point", array('name' => $point['name'], 'address' => $point['address'], 'phone' => $point['phone'], 'editpoint' => $edit_point_html, 'message' => $message_html, 'branch' => $branch['name'], 'contacts' => $contacts_html));
    return $html;
}
示例#9
0
function edit_contact()
{
    //Глобальная переменная
    global $Dbh;
    /*Проверка прав на выполнение действия*/
    if (!check_rights('edit_contact')) {
        //Возвращаем значение функции
        return "У вас нет соответствующих прав";
    }
    /*Получаем id, предварительно проверив*/
    $user_id = (int) $_GET['contact'];
    $contactRES = db_query("SELECT * FROM `phpbb_users` WHERE `user_id`={$user_id} AND `user_type` IN (0,3,9)");
    if (db_count($contactRES) > 0) {
        $contact = db_fetch($contactRES);
    } else {
        $errors[] = "Критическая ошибка входных данных (user_id)";
    }
    //IF
    if (!isset($_POST['name'])) {
        /*Загружаем фото пользователя*/
        if (isset($_FILES['file'])) {
            $photomessage = upload_user_photo($user_id);
        }
        /*Обновляем информацию о контакте после подгрузки аватара*/
        $contact = db_easy("SELECT * FROM `phpbb_users` WHERE `user_id`={$user_id} AND `user_type` IN (0,3,9)");
        /*Обрабатываем входящее сообщение*/
        switch (@$_GET['message']) {
            case "user_added_successfully":
                $message_html = template_get("message", array('message' => "Сотрудник успешно добавлен"));
                break;
            case "contactsaved":
                $message_html = template_get("message", array('message' => "Изменения сохранены"));
                break;
            default:
                $message_html = template_get("nomessage");
        }
        /*Возвращает HTML код формы*/
        $html .= show_form_edit_contact($contact, $messages, $photomessage);
    } else {
        //Проверка 'name'
        if (preg_match(REGEXP_USERNAME, $_POST['name'])) {
            if (db_easy_count("SELECT `user_id` FROM `phpbb_users` WHERE `username`='" . $_POST['name'] . "' AND `user_id`!={$user_id}") > 0) {
                $errors[] = ERROR_USERNAME_EXISTS;
            } else {
                $name = $_POST['name'];
            }
        } else {
            $errors[] = ERROR_USERNAME_REQUIREMENT;
        }
        //REGEXP_EASY_STRING
        $strings_sql = "";
        $strings_params = array('user_occ', 'user_skype', 'user_email', 'user_extphone', 'user_privatemobilephone', 'user_workmobilephone', 'hrmanager_alias');
        foreach ($strings_params as $nameFOR) {
            $strings_sql .= "`" . $nameFOR . "`= :" . $nameFOR . " , ";
        }
        //Числовые поля
        $point_id = (int) $_POST['point'];
        $hire_month = (int) $_POST['hire_month'];
        $hire_year = (int) $_POST['hire_year'];
        $mychief_id = (int) $_POST['mychief'];
        $my_timetable_editor_id = (int) $_POST['my_timetable_editor'];
        //Checkbox-ы
        $checkboxes_sql = "";
        foreach (array('chief', 'notimetable', 'timetable_editor', 'engineer', 'engineer_chief', 'spec_prod_staff') as $nameFOR) {
            if ($_POST[$nameFOR] == "on") {
                $checkboxes_sql .= "`{$nameFOR}`=1, ";
            } else {
                $checkboxes_sql .= "`{$nameFOR}`=0, ";
            }
        }
        //user_type
        $_POST['nocontact'] == "on" ? $user_type = 9 : ($user_type = 0);
        //Проверяем наличие ошибок во входных данных
        if (count($errors) == 0) {
            //Формируем SQL запрос
            $sql = "\tUPDATE\r\n\t\t\t\t\t\t`phpbb_users` \r\n\t\t\t\t\tSET \r\n\t\t\t\t\t\t" . $strings_sql . "\r\n\t\t\t\t\t\t" . $checkboxes_sql . "\r\n\t\t\t\t\t\t`user_type`= {$user_type},\r\n\t\t\t\t\t\t`point_id`={$point_id},\r\n\t\t\t\t\t\t`mychief_id`={$mychief_id},\r\n\t\t\t\t\t\t`my_timetable_editor_id`={$my_timetable_editor_id},\r\n\t\t\t\t\t\t`hire`='{$hire_year}-{$hire_month}-1'\r\n\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t`user_id`={$user_id}";
            //show($sql);
            //Готовим выражение
            $sth = $Dbh->prepare($sql);
            //Привязываем параметры
            foreach ($strings_params as $nameFOR) {
                $sth->bindParam(":" . $nameFOR, $_POST[$nameFOR], PDO::PARAM_STR);
            }
            //Выполняем запрос
            if (!$sth->execute()) {
                show($sth->errorInfo());
            }
            /*Обновляем пароль*/
            if (trim($_POST['password']) != "") {
                $sth = $Dbh->prepare("UPDATE `phpbb_users` SET `user_password`= ? WHERE `user_id`=" . $user_id);
                if (!$sth->execute(array(phpbb_hash($_POST['password'])))) {
                    show($sth->errorInfo());
                }
            }
            /*Обновляем статус*/
            $sth = $Dbh->prepare("UPDATE `phpbb_profile_fields_data` SET `pf_status`= ? WHERE `user_id`=" . $user_id);
            if (!$sth->execute(array($_POST['status']))) {
                show($sth->errorInfo());
            }
            //Получаем только что записанные данные из БД
            $contact = db_easy("SELECT * FROM `phpbb_users` WHERE `user_id`={$user_id} AND `user_type` IN (0,3,9)");
            //Возвращаем значение функции
            return show_form_edit_contact($contact, $errors);
        } else {
            //Возвращаем значение функции
            return show_form_edit_contact($contact, $errors);
        }
    }
    //Возвращаем HTML-код
    return $html;
}
示例#10
0
function edit_point()
{
    if (!check_rights('edit_point')) {
        //Возвращаем значение функции
        return "У вас нет соответствующих прав";
    }
    $point_id = $_GET['point'];
    if (!isset($_POST['name'])) {
        switch (@$_GET['message']) {
            case "pointsaved":
                $message_html = template_get("message", array('message' => "Изменения сохранены"));
                break;
            case "emptypointname":
                $message_html = template_get("errormessage", array('message' => "Название не может быть пустым"));
                break;
            case "samepointexists":
                $message_html = template_get("errormessage", array('message' => "Офис/склад с таким именем уже имеется"));
                break;
            default:
                $message_html = template_get("nomessage");
        }
        $point = db_easy("SELECT * FROM `phpbb_points` WHERE `id`={$point_id}");
        $show_point_html = "<a href='/manager.php?action=show_point&point={$point_id}&' style='font-size:8pt;'>Просмотреть</a>";
        /*Строим список SELECT*/
        $branches_html = "";
        $selected_html = "";
        $branchesRES = db_query("SELECT * FROM `phpbb_branches` ORDER BY `name` ASC");
        while ($branch = db_fetch($branchesRES)) {
            if ($point['branch_id'] == $branch['id']) {
                $selected_html = "selected";
            } else {
                $selected_html = "";
            }
            $branches_html .= "<option value='{$branch['id']}' {$selected_html}>{$branch['name']}</option>";
        }
        $html .= template_get("points/edit_point", array('action' => "/manager.php?action=edit_point&point={$point_id}", 'name' => $point['name'], 'address' => $point['address'], 'phone' => $point['phone'], 'branches' => $branches_html, 'showpoint' => $show_point_html, 'message' => $message_html));
    } else {
        $point['name'] = trim($_POST['name']);
        $point['address'] = trim($_POST['address']);
        $point['phone'] = trim($_POST['phone']);
        $point['branch_id'] = trim($_POST['branch']);
        $do = true;
        //Проверка на пустое название города
        $point['name'] = trim($_POST['name']);
        if (!preg_match("/^.{1,70}\$/", $point['name'])) {
            header("location: /manager.php?action=edit_point&point={$point_id}&message=emptypointname");
            $do = false;
        }
        //Проверка на наличие города с таким же именем
        $other_pointRES = db_query("SELECT * FROM `phpbb_points` WHERE `name`='{$point['name']}'");
        $other_point = db_fetch($other_pointRES);
        if (db_count($other_pointRES) > 0) {
            if ($other_point['id'] != $point_id) {
                header("location: /manager.php?action=edit_point&point={$point_id}&message=samepointexists");
                $do = false;
            }
        }
        if ($do) {
            db_query("UPDATE `phpbb_points`\r\n\t\t\t\t\tSET `name`='{$point['name']}',\r\n\t\t\t\t\t\t`branch_id`={$point['branch_id']},\r\n\t\t\t\t\t\t`address`='{$point['address']}',\r\n\t\t\t\t\t\t`phone`='{$point['phone']}'\r\n\t\t\t\t\tWHERE `id`={$point_id}");
            header("location: /manager.php?action=edit_point&point={$point_id}&message=pointsaved");
        }
    }
    return $html;
}
示例#11
0
function create_timetable()
{
    //Получаем глобальные переменные
    global $Month;
    global $Year;
    global $Redactor;
    global $user;
    /*Переменная phpbb*/
    global $MonthsShort;
    //Определяем переменные
    $html = "";
    //Определяем переменную
    $users = array();
    /*Вычисляем количество дней в месяце*/
    $day_number = cal_days_in_month(CAL_GREGORIAN, $Month, $Year);
    /*Получаем список пользователей, графиком работы которых мы можем управлять*/
    //IF
    if (check_rights('timetable_show_all')) {
        //IF
        if ($Redactor == 0) {
            $usersRES = db_query("SELECT * FROM `phpbb_users` WHERE `user_type` IN (0,3,9) AND `username`!='root' AND `my_timetable_editor_id`=0 ORDER BY `username` ASC");
            //ELSEIF
        } elseif ($Redactor == -1) {
            $usersRES = db_query("SELECT * FROM `phpbb_users` WHERE `user_type` IN (0,3,9) AND `username`!='root' ORDER BY `username` ASC");
            //ELSE
        } else {
            $usersRES = db_query("SELECT * FROM `phpbb_users` WHERE `user_type` IN (0,3,9) AND `username`!='root' AND `my_timetable_editor_id`={$Redactor} ORDER BY `username` ASC");
        }
        //ELSE
    } else {
        if (db_short_easy("SELECT `timetable_editor` FROM `phpbb_users` WHERE `user_id`={$user->data['user_id']}") == 1) {
            $same_editor_id = $user->data['user_id'];
        } elseif (is_engineer_chief_employee()) {
            $same_editor_id = $user->data['mychief_id'];
        } else {
            $same_editorSQL = "SELECT `editor_id` FROM `phpbb_timetable_editors_rights` WHERE `user_id`={$user->data['user_id']}";
            if (db_easy_count($same_editorSQL) > 0) {
                $same_editor_id = db_short_easy($same_editorSQL);
            }
        }
        //Исключение в сортировке для пользователя Нечаев Андрей по его просьбе
        if ($user->data['user_id'] == 46) {
            $special_order = 'timetable_order';
        } else {
            $special_order = 'username';
        }
        //Запрос к базе
        $usersRES = db_query("SELECT * FROM `phpbb_users` WHERE `user_type` IN (0,3,9) AND `my_timetable_editor_id`={$same_editor_id} ORDER BY `{$special_order}` ASC");
    }
    /*Строим шапку таблицы*/
    $html .= "<tr class='vfirst'><td rowspan='2' class='gfirst vfirst'>Ф.И.</td><td rowspan='2' colspan='2' class='gnolast vfirst'>Устроен</td><td class='vfirst glast' colspan='{$day_number}'>Дата</td></tr>";
    $html .= "<tr class='vfirst'>";
    for ($dayFOR = 1; $dayFOR <= $day_number; $dayFOR++) {
        //IF
        $dayFOR == $day_number ? $tdclass = 'glast' : ($tdclass = 'gnolast');
        //Определяем переменную
        $html .= "<td class='{$tdclass}'>{$dayFOR}</td>";
    }
    $html .= "</tr>";
    /*НАЧАЛО: Создаем массив ускоряющий работу (чтобы не делать запрос sql на каждое число*/
    //Запрос к базе
    $daysRES = db_query("SELECT * FROM `phpbb_timetable` WHERE `year`={$Year} AND `month`={$Month}");
    //Определяем переменную
    $timetable = array();
    //WHILE
    while ($day = db_fetch($daysRES)) {
        $timetable[$day['user_id']][$day['day']]['status'] = $day['status'];
        $timetable[$day['user_id']][$day['day']]['hours'] = $day['hours'];
    }
    /*КОНЕЦ: Создаем массив ускоряющий работу (чтобы не делать запрос sql на каждое число*/
    /*НАЧАЛО: Строим тело таблицы*/
    //Определяем переменную
    $line = 1;
    $engineer = 0;
    $spec_prod_staff = 0;
    //Определяем, является ли редактор шефом инженеров
    if ($Redactor != -1 && $Redactor != 0) {
        $redactor_engineers_chief = db_short_easy("SELECT `engineer_chief` FROM `phpbb_users` WHERE `user_id`=" . $Redactor);
    } else {
        $redactor_engineers_chief = 0;
    }
    //IF
    if (db_count($usersRES) > 0) {
        //WHILE
        while ($userWHILE = db_fetch($usersRES)) {
            /*Пропускаем тех, у кого notimetable=1*/
            if ($userWHILE['notimetable'] == 1) {
                continue;
            }
            //Получаем "шефа" правильным образом
            if ($userWHILE['mychief_id'] != 0) {
                $chiefQUERY = db_query("SELECT * FROM `phpbb_users` WHERE `user_id`=" . $userWHILE['mychief_id']);
                if (db_count($chiefQUERY) > 0) {
                    $chief = db_fetch($chiefQUERY);
                } else {
                    $chief = false;
                }
            } else {
                $chief = false;
            }
            //Флаг инженера
            $engineer = $userWHILE['engineer'];
            //Флаг специального сотрудника производства
            $spec_prod_staff = $userWHILE['spec_prod_staff'];
            //Проверяем, имеет ли сотрудник при
            //IF
            if ($redactor_engineers_chief != 1) {
                $line == db_count($usersRES) ? $trclass = 'vlast' : ($trclass = 'vnolast');
            } else {
                $trclass = 'vnolast';
            }
            //Определяем переменную
            $line++;
            //Определяем переменную
            $html .= "<tr class='{$trclass}'>";
            //Определяем переменную
            $html .= "<td class='gfirst'><a href='/manager.php?action=show_contact&contact={$userWHILE['user_id']}'>{$userWHILE['username']}</a></td>";
            $userWHILE['hire'] != "0000-00-00" ? $hire_monthWHILE = $MonthsShort[(int) date("m", strtotime($userWHILE['hire']))] : ($hire_monthWHILE = "");
            $userWHILE['hire'] != "0000-00-00" ? $hire_yearWHILE = date("Y", strtotime($userWHILE['hire'])) : ($hire_yearWHILE = "");
            $html .= "<td class='gnolast'>" . $hire_monthWHILE . "</td>";
            $html .= "<td class='gnolast'>" . $hire_yearWHILE . "</td>";
            //FOR
            for ($dayFOR = 1; $dayFOR <= $day_number; $dayFOR++) {
                //IF
                $dayFOR == $day_number ? $tdclass = 'glast' : ($tdclass = 'gnolast');
                //IF
                isset($timetable[$userWHILE['user_id']][$dayFOR]['status']) ? $status = $timetable[$userWHILE['user_id']][$dayFOR]['status'] : ($status = 0);
                //IF
                if ($timetable[$userWHILE['user_id']][$dayFOR]['hours'] >= 1 && $timetable[$userWHILE['user_id']][$dayFOR]['hours'] <= 7) {
                    $addtext = '(' . $timetable[$userWHILE['user_id']][$dayFOR]['hours'] . ')';
                } else {
                    $addtext = '';
                }
                //SWITCH
                switch ($status) {
                    case 0:
                        $status_html = '';
                        $color = '#fff';
                        break;
                    case 1:
                        $status_html = '';
                        $color = '#fff';
                        break;
                    case 2:
                        $status_html = 'от' . $addtext;
                        $color = '#ffe599';
                        break;
                    case 3:
                        $status_html = 'Б' . $addtext;
                        $color = '#b6d7a8';
                        break;
                    case 4:
                        $status_html = 'до' . $addtext;
                        $color = '#E2B1E2';
                        break;
                    case 5:
                        $status_html = 'к' . $addtext;
                        $color = '#9fc5e8';
                        break;
                    case 6:
                        $status_html = "";
                        $color = "#FFF;";
                        break;
                    case 51:
                        $status_html = '/-' . $addtext;
                        $color = '#fff';
                        break;
                    case 52:
                        $status_html = '-/' . $addtext;
                        $color = '#fff';
                        break;
                    case 53:
                        $status_html = '-' . $addtext;
                        $color = '#fff';
                        break;
                    case 54:
                        $status_html = '1' . $addtext;
                        $color = '#fff';
                        break;
                    case 55:
                        $status_html = '0.5' . $addtext;
                        $color = '#fff';
                        break;
                    case 56:
                        $status_html = "<span style='font-size:7pt;'>0.5+<span style='color:red;'>0.5</span></span>" . $addtext;
                        $color = '#fff';
                        break;
                    case 57:
                        $status_html = "<span style='color:red;'>1</span>" . $addtext;
                        break;
                    case 58:
                        $status_html = "<span style='color:red;'>0.5</span>" . $addtext;
                        break;
                    case 9:
                        $status_html = 'зф' . $addtext;
                        $color = '#CF596E';
                        break;
                }
                $day_of_week = date("N", strtotime("{$Year}-{$Month}-{$dayFOR}"));
                if (($day_of_week == 6 || $day_of_week == 7) && $status == 0 || $status == 6) {
                    if ($status_html == '') {
                        $backgroundimage = "url(/images/krestik.png)";
                    } else {
                        $backgroundimage = "";
                    }
                } else {
                    $backgroundimage = "";
                }
                $onDoubleClick = "popup_menu(this.id);";
                //Определяем переменную
                $html .= "<td id='{$userWHILE['user_id']}-{$Year}-{$Month}-{$dayFOR}-{$engineer}-{$spec_prod_staff}' class='{$tdclass}' onDblClick=\"{$onDoubleClick}\"  unselectable='on' onselectstart='return false;' style='background:{$color};background-repeat:no-repeat;background-image:{$backgroundimage};'>{$status_html}</td>";
            }
            //Определяем переменную
            $html .= "</tr>";
        }
        //Добавляем комментарии к столбцам для инженеров
        if ($redactor_engineers_chief == 1 || is_engineer_chief_employee()) {
            $comments_number = 1;
            for ($comment_number = 1; $comment_number <= $comments_number; $comment_number++) {
                //$comment_number==$comments_number ? $tr_class='vlast' : $tr_class='vnolast';
                $html .= "<tr>";
                $html .= "<td></td><td></td><td class='comment2'></td>";
                for ($dayFOR = 1; $dayFOR <= $day_number; $dayFOR++) {
                    $commentFOR = db_easy("SELECT * FROM `phpbb_timetable_comments` WHERE `year`={$Year} AND `month`={$Month} AND `day`={$dayFOR}");
                    if ($commentFOR['comment1'] != '' || $commentFOR['comment2'] != '' || $commentFOR['comment3'] != '') {
                        $styleFOR = "background:url('/images/cross.png') center center no-repeat";
                    } else {
                        $styleFOR = "";
                    }
                    $dayFOR == $day_number ? $td_g_class = 'glast' : ($td_g_class = 'gnolast');
                    $html .= "<td id='comment-{$comment_number}-{$Year}-{$Month}-{$dayFOR}' class='comment1' style=\"{$styleFOR}\" onDblClick=\"if(popup_id_check!=this.id) {popup_comment(this.id);}\" align='center'></td>";
                }
                $html .= "</tr>";
            }
        }
    }
    /*КОНЕЦ: Строим тело таблицы*/
    //Возвращаем значение функции
    return $html;
}
示例#12
0
function show_contact()
{
    $user = $GLOBALS['user'];
    $user_id = (int) $_GET['contact'];
    //НАЧАЛО: Обновление статуса
    if (isset($_POST['status'])) {
        $post_status = $_POST['status'];
        db_query("UPDATE `phpbb_profile_fields_data` SET `pf_status`='{$post_status}' WHERE `user_id`={$user_id}");
        $status_update_message = template_get('message', array('message' => "Статус успешно обновлен"));
    } else {
        $status_update_message = "";
    }
    //КОНЕЦ: Обновление статуса
    $posts_number = db_easy_count("SELECT * FROM `phpbb_posts` WHERE `poster_id`={$user_id}");
    $topics_number = db_easy_count("SELECT * FROM `phpbb_topics` WHERE `topic_poster`={$user_id}");
    $contact = db_easy("SELECT * FROM `phpbb_users` WHERE `user_id`={$user_id}");
    $status = db_easy("SELECT * FROM `phpbb_profile_fields_data` WHERE `user_id`={$user_id}");
    $point = db_easy("SELECT * FROM `phpbb_points` WHERE `id`={$contact['point_id']}");
    $mobilephones_html = "";
    if ($contact['user_workmobilephone'] != "") {
        $mobilephones_html .= "<tr><td>Мобильный телефон (рабочий)</td><td>{$contact['user_workmobilephone']}</td>";
    }
    if ($contact['user_privatemobilephone'] != "") {
        $mobilephones_html .= "<tr><td>Мобильный телефон (личный)</td><td>{$contact['user_privatemobilephone']}</td>";
    }
    //
    if (check_rights('show_hidden_contacts')) {
        $contact['user_type'] == 9 ? $sql_hidden_contacts = "OR `user_type`=9" : ($sql_hidden_contacts = "");
    }
    //Мой руководитель
    if ($contact['mychief_id'] != 0) {
        $mychief = db_easy("SELECT * FROM `phpbb_users` WHERE `user_id`={$contact['mychief_id']}");
        $mychief_html = "<tr><td>Руководитель:</td><td><a href='/manager.php?action=show_contact&contact={$contact['mychief_id']}'>{$mychief['username']}</a></td></tr>";
    } else {
        $mychief_html = "";
    }
    //Мои подчиненные
    $employeesRES = db_query("SELECT * FROM `phpbb_users` WHERE `mychief_id`={$user_id} AND `user_type` IN (0,3) ORDER BY `username` ASC");
    if (db_count($employeesRES) > 0 && $contact['chief'] == 1) {
        $employees_html = "<tr><td valign='top'>Подчиненные:</td><td>";
        while ($employee = db_fetch($employeesRES)) {
            $employees_html .= "<a href='/manager.php?action=show_contact&contact=" . $employee['user_id'] . "'>" . $employee['username'] . "</a><br/>";
        }
        $employees_html .= "</td></tr>";
    } else {
        $employees_html = "";
    }
    if ($point['name'] == "" || $point['name'] == "--не определено--") {
        $point_html = "не определено";
    } else {
        $point_html = "<a href='/manager.php?action=show_point&point={$point['id']}'>{$point['name']}</a>";
    }
    if (check_rights('edit_contact')) {
        $edit_contact_html = "<a href='/manager.php?action=edit_contact&contact={$user_id}' style='font-size:8pt;'>Редактировать</a>";
    }
    if ($user->data['user_id'] == $user_id && !check_rights('edit_contact')) {
        $status_html = "<form action='/manager.php?action=show_contact&contact={$user_id}' method='post'>\r\n\t\t\t\t\t\t\t\t<input type='text' name='status' value='{$status['pf_status']}' style='width:350px;' /><br/>\r\n\t\t\t\t\t\t\t\t{$status_update_message}\r\n\t\t\t\t\t\t\t\t<input type='submit' value='Обновить'  style='margin:6px 0 0 0; width:80px;' />\r\n\t\t\t\t\t\t</form>";
    } else {
        $status_html = $status['pf_status'];
    }
    //НАЧАЛО: Переключатели "Следующий" и "Предыдущий"
    $previous_html = "";
    $next_html = "";
    $all_contactsRES = db_query("SELECT * FROM `phpbb_users`\r\n\t\t\t\t\t\t\t\tWHERE (`user_type`=0 OR `user_type`=3 {$sql_hidden_contacts}) AND `username`!='root'\r\n\t\t\t\t\t\t\t\t\tORDER BY `username`\r\n\t\t\t\t\t\t\t\t\t\t");
    $count_contacts = db_count($all_contactsRES);
    $i = 0;
    $all_contacts = array();
    while ($a_contact = db_fetch($all_contactsRES)) {
        $all_contacts[$i] = $a_contact['user_id'];
        if ($a_contact['user_id'] == $user_id) {
            $current = $i;
        }
        $i++;
    }
    $previous = $current;
    $next = $current;
    $previous_id = $user_id;
    $next_id = $user_id;
    if ($current > 0) {
        $previous = $current - 1;
        $previous_id = $all_contacts[$previous];
    }
    if ($current < $count_contacts - 1) {
        $next = $current + 1;
        $next_id = $all_contacts[$next];
    }
    //КОНЕЦ: Переключатели "Следующий" и "Предыдущий"
    /*НАЧАЛО: Учет рабочего времени*/
    if (($user->data['user_id'] == $user_id || $user->data['timetable_editor'] == 1 && $contact['my_timetable_editor_id'] == $user->data['user_id'] || check_rights('hr_manager')) && $contact['notimetable'] != 1) {
        /*Отпуск*/
        $vocations = get_days_str($user_id, date("Y"), 2);
        /*Больничный*/
        $bolnichny = get_days_str($user_id, date("Y"), 3);
        /*За свой счет*/
        $zasvoischet = get_days_str($user_id, date("Y"), 4);
        /*Командировка*/
        $travel = get_days_str($user_id, date("Y"), 5);
        $uchet_rabochego_vremeni = template_get("contacts/uchet_rabochego_vremeni", array('vocations_num' => $vocations['used'], 'vocations_rest' => get_rest($vocations['used_hours'], 20 * 8), 'vocations_str' => $vocations['when'], 'bolnichny_num' => $bolnichny['used'], 'bolnichny_rest' => get_rest($bolnichny['used_hours'], 5 * 8), 'bolnichny_str' => $bolnichny['when'], 'zasvoischet_num' => $zasvoischet['used'], 'zasvoischet_str' => $zasvoischet['when'], 'travel_num' => $travel['used'], 'travel_str' => $travel['when']));
    } else {
        $uchet_rabochego_vremeni = '';
    }
    /*КОНЕЦ: Учет рабочего времени*/
    $html .= template_get("contacts/show_contact", array('name' => $contact['username'], 'occupation' => $contact['user_occ'], 'email' => $contact['user_email'], 'skype' => $contact['user_skype'], 'officephone' => $point['phone'], 'extphone' => $contact['user_extphone'], 'mobilephones' => $mobilephones_html, 'status' => $status_html, 'point' => $point_html, 'editcontact' => $edit_contact_html, 'mychief' => $mychief_html, 'employees' => $employees_html, 'photo' => get_user_avatar($contact['user_avatar'], $contact['user_avatar_type'], $contact['user_avatar_width'], $contact['user_avatar_height']), 'posts_number' => $posts_number, 'previous' => "/manager.php?action=show_contact&contact={$previous_id}", 'next' => "/manager.php?action=show_contact&contact={$next_id}", 'current' => $current + 1 . " из " . $count_contacts, 'uchet_rabochego_vremeni' => $uchet_rabochego_vremeni));
    return $html;
}