report.php

<?php
/**
* report form and build report
*/

require('./inc/config.php');

// Allowed ?
$user->checkAuthent();

// No $_GET data -> display the form
if (!count($_GET)) {
    $project = new Project;
    $task = new Task;    
    
    if (BOO_ALLOW_EVERYONE_REPORT_SILLAJ) {
        $smarty->assign('arrUser', $user->get());
    }        
    
    // current year and month (for the following calculations)
    $intCurYear  = date('Y');
    $intCurMonth = date('n');
    $intCurDay   = date('j');
    $intCurWeek  = date('w');
    
    // prepare the list of months name (for js calendar) - local language
    $arrMonthNames = array();
    for($i=1;$i<=12;$i++) {
        $arrMonthNames[] = strftime('%B', mktime(0, 0, 0, $i, 1, $intCurYear));
    }

    // prepare the list of weekday first letters (for js calendar) in local language
    // arbitrary using first week of 2008 to get day names
    $arrDayIni = array();
    for($i=0;$i<=6;$i++) { 
        $arrDayIni[] = strtoupper(substr(strftime('%A', mktime(0, 0, 0, 1, 6 + $i, 2008)), 0, 1));
    }
    
    // Prepare dates to populate date field according to the buttons click
    $smarty->assign( 'datStartPreviousWeek', mktime(0, 0, 0, $intCurMonth, $intCurDay - $intCurWeek + INT_START_WEEK_DAY_SILLAJ - 7, $intCurYear));
    $smarty->assign(   'datEndPreviousWeek', mktime(23, 59, 59, $intCurMonth, $intCurDay + (6 - $intCurWeek) + INT_START_WEEK_DAY_SILLAJ - 7, $intCurYear));
    $smarty->assign(  'datStartCurrentWeek', mktime(0, 0, 0, $intCurMonth, $intCurDay - $intCurWeek + INT_START_WEEK_DAY_SILLAJ, $intCurYear));
    $smarty->assign(    'datEndCurrentWeek', mktime(23, 59, 59, $intCurMonth, $intCurDay + (6 - $intCurWeek) + INT_START_WEEK_DAY_SILLAJ, $intCurYear));
    $smarty->assign('datStartPreviousMonth', mktime(0, 0, 0, $intCurMonth - 1, 1, $intCurYear));
    $smarty->assign(  'datEndPreviousMonth', mktime(0, 0, 0, $intCurMonth, 0, $intCurYear));
    $smarty->assign( 'datStartCurrentMonth', mktime(0, 0, 0, $intCurMonth, 1, $intCurYear));
    $smarty->assign(   'datEndCurrentMonth', mktime(0, 0, 0, $intCurMonth + 1, 0, $intCurYear));
    $smarty->assign( 'datStartPreviousYear', mktime(0, 0, 0, 1, 1, $intCurYear - 1));
    $smarty->assign(   'datEndPreviousYear', mktime(0, 0, 0, 12, 31, $intCurYear - 1));
    $smarty->assign(  'datStartCurrentYear', mktime(0, 0, 0, 1, 1, $intCurYear));
    $smarty->assign(    'datEndCurrentYear', mktime(0, 0, 0, 12, 31, $intCurYear));
    $smarty->assign(                      'booCal', true); // use js calendar : call the js in the header
    $smarty->assign_by_ref(        'arrMonthNames', $arrMonthNames);
    $smarty->assign_by_ref(            'arrDayIni', $arrDayIni);
    $smarty->assign(     'strDateFormatCal', dateFormatPhpToJsCal(STR_DATE_FORMAT_SILLAJ)); // convert date format string 
    $smarty->assign(           'arrProject', $project->get()); // list of all projects (for gantt form)
    $smarty->assign(              'arrTask', $task->get());    // list of all tasks (for gantt form)
 
    $smarty->display('frmReport.tpl', $_SESSION['strUserId'] . $_SESSION['strLocale']);
}

// else $_GET data -> create the report
else {
    // Sort type
    if (empty($_GET['radSort']) || ($_GET['radSort'] == 'time')) {
        $strSort = 'time';
    }
    else {
        $strSort = 'alpha';
    }
    
    // who are we making a report on ? by default, the authenticated one.
    $strUserId = $_SESSION['strUserId'];
     
    // get user name if we make a report on another user (not the current authenticated one)
    // if we are in the "allow each other to see their reports" mode
    if (BOO_ALLOW_EVERYONE_REPORT_SILLAJ) {
        if (!empty($_GET['strUserId'])) {
            $strUserId = $_GET['strUserId'];
            
            // check that the selected user allowed other people to see his reports (if he is not the same as the authent one)
            $arrUser = $user->get($strUserId);
            if (!$arrUser['booAllowOther'] && ($strUserId != $_SESSION['strUserId'])) {
                raiseError(STR_ERROR_USER_NOT_ALLOWED_SILLAJ);            
            }
        }
    }
    
    // check date input
    if (empty($_GET['datStart']) || empty($_GET['datEnd'])) {
        raiseError(STR_ERROR_MISSING_DATE_SILLAJ);
    }    
    
    // convert local date to ISO date
    $datStart = localDateToIso($_GET['datStart']);
    $datEnd = localDateToIso($_GET['datEnd']);    
    
    // check date validity
    validIsoDate($datStart);
    validIsoDate($datEnd);
    
    // Create the report
    $report = new Report;
    
    if (empty($_GET['radType']) || ($_GET['radType'] == 'project')) {
        $smarty->assign(  'arrReport', $report->getProject($strUserId, $strSort, $datStart, $datEnd));
        $smarty->assign(      'booByProject', true);
    }
    else {
        $smarty->assign(  'arrReport', $report->getTask($strUserId, $strSort, $datStart, $datEnd));
        $smarty->assign(      'booByProject', false);
    }
    
    // assign some more useful variables
    $smarty->assign(      'arrUser', $user->get($strUserId)); // to get the real name of the user 
    $smarty->assign_by_ref(     'datStart', $datStart);       
    $smarty->assign_by_ref(       'datEnd', $datEnd);    
    $smarty->assign( 'strSumWorked', $report->getSumWorked($strUserId, $datStart, $datEnd));
    $smarty->assign(           'booDetail', !empty($_GET['cbxDetail']));
    $smarty->assign(        'booOtherUser', $strUserId != $_SESSION['strUserId']);
        
    // Normal (HTML) display or export to Excel (specific HTTP header, and HTML header too : header_xls.tpl)
    if (!empty($_GET['cbxExcel']) && ($_GET['cbxExcel'] == 'on')) {
        $smarty->assign('booExcel', true);
        header('Content-Disposition: attachement; filename="sillaj_'. $strUserId .'_'. $datStart .'_'. $datEnd .'.xls"');
        header('Content-Type: application/x-msexcel');       
    }
    else {
        $smarty->assign('booExcel', false);
    }

    $smarty->display('report.tpl');
}

?>