$datetime1 = new DateTime($date1);
        $datetime2 = new DateTime($date2);
        $difference = $datetime1->diff($datetime2);
        //echo $difference->days;
        /*$sel = abs(strtotime($date2)-strtotime($date1));
        		$selisih= $sel /(60*60*24);*/
        $jumlah_hari = $difference->days + 1;
        $jumlah_truk = get_jumlah_truk($date1, $date2, $i_owner_id);
        $jumlah_pengiriman = get_jumlah_pengiriman($date1, $date2, $i_owner_id);
        $jumlah_volume = get_jumlah_volume($date1, $date2, $i_owner_id) ? get_jumlah_volume($date1, $date2, $i_owner_id) : 0;
        $jumlah_volume = str_replace(".", ",", $jumlah_volume);
        $total_jasa_angkut = get_total_jasa_angkut($date1, $date2, $i_owner_id);
        $total_jasa_angkut = str_replace(".", ",", $total_jasa_angkut);
        $total_subsidi_tol = get_total_subsidi_tol($date1, $date2, $i_owner_id);
        $total_transport = $total_jasa_angkut + $total_subsidi_tol;
        $total_harga_urukan = get_total_harga_urukan($date1, $date2, $i_owner_id);
        $total_hpp = get_total_hpp($date1, $date2, $i_owner_id);
        $title = 'report_kepuasan_customer_tagihan';
        $supplier_title = str_replace(" ", "_", $supplier);
        $format = create_report($title . "_" . $supplier_title . "_" . $i_date);
        include '../views/report/report_kepuasan_customer_tagihan.php';
        break;
    case 'delete_transaction':
        $id = isset($_GET['id']) ? $_GET['id'] : null;
        extract($_POST);
        $i_date = get_isset($_GET['date']);
        $date_default = $i_date;
        delete_transaction($id);
        header("Location: report_kepuasan_customer.php?page=list&preview=1&date={$date_default}");
        break;
}
Exemplo n.º 2
0
<?php

// session_start();
/* Print a report
 * repgen_print.php for PHP Report Generator
   Bauer, 5.2.2002
   Version 0.2
*/
// this has to be an own page, because otherwise we could not get Content-type application/pdf
$path_to_root = "../..";
$page_security = 'SA_REPORT_GENERATOR';
include_once $path_to_root . "/includes/session.inc";
add_access_extensions();
include_once $path_to_root . "/includes/date_functions.inc";
include_once $path_to_root . "/admin/db/company_db.inc";
include_once $path_to_root . "/includes/ui.inc";
require_once "includes/repgen.inc";
$id = $_GET['id'];
$file = $comp_path . '/' . user_company() . '/pdf_files/' . $id . '.pdf';
create_report($id, $file);
?>



Exemplo n.º 3
0
function show_timetable()
{
    //Получаем глобальные переменные
    global $Month;
    global $Year;
    global $Redactor;
    global $user;
    global $MonthsFull;
    //Передаем флаг шефа инженеров в cookie
    setcookie("engineer_chief", $user->data['engineer_chief']);
    /*Получаем данные от пользователя*/
    if (isset($_GET['month'])) {
        if (!preg_match("/^[0-9]{1,2}\$/", $_GET['month'])) {
            return "Ошибка в формате входных данных (1).";
        } else {
            $Month = (int) $_GET['month'];
        }
    } else {
        $Month = (int) date("m");
    }
    /*Получаем данные от пользователя*/
    if (isset($_GET['year'])) {
        if (!preg_match("/^[0-9]{4}\$/", $_GET['year'])) {
            return "Ошибка в формате входных данных (2).";
        } else {
            $Year = (int) $_GET['year'];
        }
    } else {
        $Year = (int) date("Y");
    }
    /*Получаем данные от пользователя*/
    if (isset($_GET['redactor'])) {
        $Redactor = (int) $_GET['redactor'];
    } else {
        if ($user->data['timetable_editor'] == 1) {
            if (check_rights('timetable_show_all_first')) {
                $Redactor = -1;
            } else {
                $Redactor = $user->data['user_id'];
            }
        } else {
            $Redactor = -1;
        }
    }
    /*Формируем таблицу*/
    if (@$_GET['regime'] == 'report') {
        $timetable_html = create_report();
    } else {
        $timetable_html = create_timetable();
    }
    /*Проверяем чьими графиками работы мы можем управлять и можем ли вообще*/
    if (!$timetable_html) {
        return "Вам не доступен ни один график работы для просмотра/редактирования";
    } else {
        //Определяем переменные
        $html = "";
        /*Формируем список годов*/
        $years_html = "";
        $selectedFOR = "";
        $year_start = date("Y");
        $year_end = date("Y") - 5;
        for ($yearFOR = $year_start; $yearFOR >= $year_end; $yearFOR--) {
            $yearFOR == $Year ? $selectedFOR = 'selected' : ($selectedFOR = '');
            $years_html .= "<option value='{$yearFOR}' {$selectedFOR}>{$yearFOR}</option>";
        }
        /*Формируем список месяцев*/
        $months_html = "";
        $selectedFOR = "";
        foreach ($MonthsFull as $keyFOR => $monthFOR) {
            $keyFOR == $Month ? $selectedFOR = "selected" : ($selectedFOR = "");
            $months_html .= "<option value='{$keyFOR}' {$selectedFOR}>{$monthFOR}</option>";
        }
        /*Формируем список редакторов*/
        //IF
        if (check_rights('timetable_show_all')) {
            //Определяем переменные
            $redactors_html = "Подразделение (ответственный): ";
            //Запрос к базе
            $redactorsRES = db_query("SELECT * FROM `phpbb_users` WHERE `timetable_editor`=1 ORDER BY `hrmanager_alias` ASC");
            if (db_count($redactorsRES) == 0) {
                $redactors_html .= "не заданы";
            } else {
                //Определяем переменную
                $redactors_html .= "<select name='redactor'>";
                /*Не важно*/
                $Redactor === -1 ? $redactors_html .= "<option value='-1' selected>--не важно--</option>" : ($redactors_html .= "<option value='-1'>--не важно--</option>");
                if (check_rights('timetable_bez_redactora')) {
                    /*Без редактора*/
                    $Redactor === 0 ? $redactors_html .= "<option value='0' selected>--ответственный не указан--</option>" : ($redactors_html .= "<option value='0'>--ответственный не указан--</option>");
                }
                //WHILE
                while ($redactorWHILE = db_fetch($redactorsRES)) {
                    //IF
                    $redactorWHILE['hrmanager_alias'] != "" ? $nameWHILE = $redactorWHILE['hrmanager_alias'] . " (" . $redactorWHILE['username'] . ")" : ($nameWHILE = $redactorWHILE['username']);
                    $redactorWHILE['user_id'] == $Redactor ? $selected = 'selected' : ($selected = '');
                    $redactors_html .= "<option value='{$redactorWHILE['user_id']}' {$selected}>{$nameWHILE}</option>";
                }
                //Определяем переменную
                $redactors_html .= "</select>";
            }
            //ELSE
        } else {
            //Определяем переменную
            $redactors_html = "";
        }
        /*НАЧАЛО: Определяем вид ссылок subgroup*/
        //Определяем переменную
        $temp_style = "font-weight:bold;text-decoration:none;";
        //IF
        if (@$_GET['regime'] == 'report') {
            $subgroup_link_2 = $temp_style;
            $subgroup_link_1 = '';
        } else {
            $subgroup_link_1 = $temp_style;
            $subgroup_link_2 = '';
        }
        /*КОНЕЦ: Определяем вид ссылок subgroup*/
        /*НАЧАЛО: Определяем вид ссылок subgroup2*/
        //Определяем переменную
        $temp_style = "font-weight:bold;text-decoration:none;";
        //IF
        if (@$_GET['report'] == 'year') {
            $subgroup2_link_2 = $temp_style;
            $subgroup2_link_1 = '';
        } else {
            $subgroup2_link_1 = $temp_style;
            $subgroup2_link_2 = '';
        }
        /*КОНЕЦ: Определяем вид ссылок subgroup2*/
        /*НАЧАЛО: Отображение subgroup2*/
        if (@$_GET['regime'] == 'report') {
            $subgroup2 = template_get("timetable/subgroup2", array('year' => $Year, 'month' => $Month, 'redactor' => $Redactor, 'subgroup2_link_1' => $subgroup2_link_1, 'subgroup2_link_2' => $subgroup2_link_2));
        } else {
            $subgroup2 = '';
        }
        /*КОНЕЦ: Отображение subgroup2*/
        //Проверка, даны ли вошедшему пользователю права на управления графиками кого-либо из редакторов{
        //Случай 1. Пользователь перечислен в таблице БД `phpbb_timetable_editors_rights`{
        $same_rightsSQL = "SELECT `editor_id` FROM `phpbb_timetable_editors_rights` WHERE `user_id`={$user->data['user_id']}";
        if (db_easy_count($same_rightsSQL) > 0) {
            $editor_id = db_short_easy($same_rightsSQL);
            if (db_short_easy("SELECT `timetable_editor` FROM `phpbb_users` WHERE `user_id`={$editor_id}") == 1) {
                $timetable_editor_same_rights = 1;
            } else {
                $timetable_editor_same_rights = 0;
            }
        } else {
            $timetable_editor_same_rights = 0;
        }
        //}
        //Случай 2. Пользователь является подчиненным шефа инженеров{
        if (is_engineer_chief_employee()) {
            $timetable_editor_same_rights = 1;
        }
        //}
        //}
        /*НАЧАЛО: Отображение ссылки на раздел "Таблица"*/
        if (check_rights('timetable_menu_tablica') || db_short_easy("SELECT `timetable_editor` FROM `phpbb_users` WHERE `user_id`={$user->data['user_id']}") == 1 || $timetable_editor_same_rights) {
            $tablica = template_get("timetable/tablica", array('year' => $Year, 'month' => $Month, 'redactor' => $Redactor, 'subgroup_link_1' => $subgroup_link_1));
        } else {
            $tablica = '';
        }
        /*КОНЕЦ: Отображение ссылки на раздел "Таблица"*/
        /*НАЧАЛО: Формируем additional_hiddens для <SELECT>*/
        //Определяем переменные
        $temp_array = array();
        $additional_hiddens = "";
        //IF
        if (@$_GET['regime'] == 'report') {
            $temp_array['regime'] = 'report';
        }
        if (@$_GET['report'] == 'year') {
            $temp_array['report'] = 'year';
        }
        //FOREACH
        foreach ($temp_array as $nameFOR => $valueFOR) {
            $additional_hiddens .= "<input type='hidden' name='{$nameFOR}' value='{$valueFOR}' />";
        }
        /*КОНЕЦ: Формируем additional_hiddens для <SELECT>*/
        /*Неактивный <SELECT name='month'...*/
        @$_GET['report'] == 'year' ? $select_disabled = 'disabled' : ($select_disabled = '');
        /*Подключаем файл шаблона*/
        $html .= template_get("timetable/show_timetable", array('year' => $Year, 'month' => $Month, 'redactor' => $Redactor, 'years' => $years_html, 'months' => $months_html, 'redactors' => $redactors_html, 'table' => $timetable_html, 'subgroup_link_2' => $subgroup_link_2, 'subgroup2' => $subgroup2, 'additional_hiddens' => $additional_hiddens, 'select_disabled' => $select_disabled, 'tablica' => $tablica));
        //Возвращаем значение функции
        return $html;
    }
}
Exemplo n.º 4
0
        }
        $sql .= "AND ({$gsql}) ";
    }
    $sql .= "GROUP BY h.userid, h.type";
    $result = mysql_query($sql);
    if (mysql_error()) {
        trigger_error(mysql_error(), E_USER_WARNING);
    }
    if (mysql_num_rows($result) > 0) {
        while ($obj = mysql_fetch_object($result)) {
            $holidays[$obj->realname]['name'] = $obj->realname;
            $holidays[$obj->realname]['entitlement'] = $obj->holiday_entitlement;
            $holidays[$obj->realname][$obj->type] = $obj->count;
        }
        $array = "{$strName},{$strHolidayEntitlement},{$strHoliday},{$strCompassionateLeave},{$strAbsentSick},{$strWorkingAway},{$strTraining}\n";
        foreach ($holidays as $h) {
            $array .= "{$h['name']},{$h['entitlement']},{$h[HOL_HOLIDAY]},{$h[HOL_FREE]},{$h[HOL_SICKNESS]},{$h[HOL_WORKING_AWAY]},{$h[HOL_TRAINING]}\n";
        }
        if ($output == "screen") {
            include APPLICATION_INCPATH . 'htmlheader.inc.php';
            echo "<h2>{$strHolidayUsage}</h2>";
            echo create_report($array, 'table');
            include APPLICATION_INCPATH . 'htmlfooter.inc.php';
        } elseif ($output == "csv") {
            echo create_report($array, 'csv');
        }
    } else {
        echo "<h2>{$strHolidayUsage}<h2>";
        echo "<p class='warning'>{$strNoRecords}</p>";
    }
}
    }
    $row .= $stats[0] . ",";
    $row .= format_seconds($stats[1] * 60) . ",";
    $row .= round($stats[2] / 60) . " {$strHours},";
    $row .= $stats[3] . ",";
    $row .= $stats[4] . ",";
    $row .= $stats[5];
    $data = $data . "\n" . $row;
    $current_time = $next_time;
}
if ($_REQUEST['output'] == 'csv') {
    echo create_report($data, 'csv', 'average_incident_duration.csv');
} else {
    include APPLICATION_INCPATH . 'htmlheader.inc.php';
    echo "<h2>{$title}</h2>";
    echo "<p align='center'>{$strOnlyShowsClosedCalls}</p>";
    echo "<p align='center'>";
    echo "<a href='{$_SERVER['PHP_SELF']}?mode=all&amp;increment={$increment}";
    echo "&amp;states=2,3,4,6,7,9'>{$strActive}</a> | ";
    echo "<a href='{$_SERVER['PHP_SELF']}?mode=all&amp;increment={$increment}";
    echo "&amp;states=0,1,2,3,4,5,9,10'>{$strWaiting}</a> | ";
    echo "<a href='{$_SERVER['PHP_SELF']}?mode=all&amp;increment={$increment}";
    echo "&amp;states=0,1,2,3,5,6,9,10'>{$strWaitingForCustomer}</a> | ";
    echo "<a href='{$_SERVER['PHP_SELF']}?mode=all&amp;increment={$increment}";
    echo "&amp;states=0,1,2,3,4,5,7,8,9,10'>{$strWaitingForSupport}</a>";
    echo "</p>";
    echo create_report($data);
    echo "<p align='center'><a href='{$_SERVER['PHP_SELF']}?mode={$mode}&amp;";
    echo "output=csv'>{$strSaveAsCSV}</a></p>";
    include APPLICATION_INCPATH . 'htmlfooter.inc.php';
}
Exemplo n.º 6
0
            $col_header = array('Day of Week', 'Hour', 'Average Visitors', 'Average Visits', 'Average Time');
            $col_format = array('int', 'int', 'int1000', 'int1000', 'time');
            $col_total_visitor = 0;
            create_report($year, $month, $what, $col_header, $col_format, $arr['result_report_query'], $arr['total_visitor'], $col_total_visitor);
            break;
        case 'countries':
            $arr = query_countries($year, $month);
            $what = 'country';
            $col_header = array('Country', 'Visitors', '%');
            $col_format = array('text', 'int1000', 'float');
            $col_total_visitor = 2;
            create_report($year, $month, $what, $col_header, $col_format, $arr['result_report_query'], $arr['total_visitor'], $col_total_visitor);
            break;
        case 'help_page':
            $arr = query_help_page($year, $month);
            $what = 'help page';
            $col_header = array('Page', 'Visitors', 'Page Views', 'Average Time On Page');
            $col_format = array('text', 'int1000', 'int1000', 'time');
            $col_total_visitor = 2;
            create_report($year, $month, $what, $col_header, $col_format, $arr['result_report_query'], $arr['total_visitor'], $col_total_visitor);
            break;
        case 'screen_res':
            $arr = query_screen_res($year, $month);
            $what = 'screen res';
            $col_header = array('Width', 'Height', 'Visitors', '%');
            $col_format = array('int', 'int', 'int1000', 'float');
            $col_total_visitor = 3;
            create_report($year, $month, $what, $col_header, $col_format, $arr['result_report_query'], $arr['total_visitor'], $col_total_visitor);
            break;
    }
}