<?php

$checkSession = false;
require_once("../includes/library.php");
$today = date('Y-m-d');
$tmpquery = " WHERE wca.date ='" . $today . "' AND wca.hours='0'";
$holidayList = new request();
$holidayList->openWorkCalendar($tmpquery);
$comptHolidayList = count($holidayList->wca_id);

if ($comptHolidayList != 0)
    exit;

$tmpquery = " WHERE tas.status in (" . ST_CLIENT_COMPLETED . "," . ST_NOT_STARTED . "," . ST_OPEN . ") AND tas.assigned_to>0 ORDER BY tas.project, tas.priority, tas.due_date, tas.assigned_to";
$taskList = new request();
$taskList->openTasks($tmpquery);
$comptTaskList = count($taskList->tas_id);
$lastProject = "";
$userList = array();

for ($i = 0; $i < $comptTaskList; $i++) {
    if ($lastProject != $taskList->tas_project[$i]) {
        $tmpquery = " WHERE pro.id='" . $taskList->tas_project[$i] . "' AND mem.profil<> '" . PF_DISABLED . "'";
        $projectList = new request();
        $projectList->openProjects($tmpquery);
        $comptProjectList = count($projectList->pro_id);
        $k = 0;
        $userList[$k] = $projectList->pro_owner[0];
        $k++;
        $lastProject = $taskList->tas_project[$i];
        unset($taskListText);
    }

    $tmpquery = " AND res.task='" . $taskList->tas_id[$i] . "' AND mem.profil='" . PF_DISABLED . "'";
    $listRes = new request();
    $listRes->openTaskHumanResource($tmpquery);
    $comptListRes = count($listRes->res_id);

    if ($comptListRes > 0) {
        $taskListText['project'][] = $taskList->tas_pro_name[$i];
        $taskListText['task'][] = $taskList->tas_name[$i];
        $taskListText['priority'][] = $priority[$taskList->tas_priority[$i]];
        $taskListText['due_date'][] = $taskList->tas_due_date[$i];
        $memberList = '';

        for ($j=0; $j<$comptListRes; $j++) {
            if ($memberList != '') $memberList .= ",";

            $memberList .= $listRes->res_mem_name[$j];
        }

        $taskListText['member'][] = $memberList;
    }

    $l = $i + 1;

    if ($l < $comptTaskList) {
        $nextProject = $taskList->tas_project[$l];
    } else {
        $nextProject = "";
    }

    if ($nextProject == $taskList->tas_project[$i] && count($taskListText['project']) == 0) continue;

    $mail = new notification();
    $mail->getUserinfo('1', "from");

    for ($j = 0; $j < $k; $j++) {
        $mail->getUserinfo($userList[$j], "to");
    }

    $mail->partSubject = lang_strings("noti_orphan1");
    $mail->partMessage = lang_strings("noti_orphan2");
    $mail->openBody();
    $mail->openResults();
    $mail->openRow();
    $mail->cellRow(lang_strings('project'));
    $mail->cellRow(lang_strings('task'));
    $mail->cellRow(lang_strings('priority'));
    $mail->cellRow(lang_strings('due_date'));
    $mail->cellRow(lang_strings('assigned_to'));
    $mail->closeRow();

    for ($j=0; $j<count($taskListText['project']); $j++) {
        $mail->openRow();
        $mail->cellRow($taskListText['project'][$j]);
        $mail->cellRow($taskListText['task'][$j]);
        $mail->cellRow($taskListText['priority'][$j]);
        $mail->cellRow($taskListText['due_date'][$j]);
        $mail->cellRow($taskListText['member'][$j]);
        $mail->closeRow();
    }

    $mail->closeResults();
    $mail->closeBody();
    $subject = $mail->partSubject;
    $mail->Subject = $subject;
    $mail->Send();
}

?>
