<?php /* PROJECTS $Id$ */
if (!defined('DP_BASE_DIR')) {
  die('You should not access this file directly.');
}

/**
* Generates a report of the task logs for given dates
*/

require_once $AppUI->getSystemClass('tree');

//error_reporting(E_ALL);
$do_report = dPgetParam($_POST, 'do_report', '');
$log_all = (int)dPgetParam($_POST, 'log_all', 0);
$log_pdf = (int)dPgetParam($_POST, 'log_pdf', 0);
$incomplete = (int)dPgetParam($_POST, 'incomplete', 0);
$log_ignore = (int)dPgetParam($_POST, 'log_ignore', 0);
$days = (int)dPgetParam($_POST, 'days', 30);

$list_start_date = dPgetCleanParam($_POST, 'list_start_date', 0);
$list_end_date = dPgetCleanParam($_POST, 'list_end_date', 0);

$period = dPgetCleanParam($_POST, 'period', 0);
$period_value = dPgetCleanParam($_POST, 'pvalue', 1);
if ($period) {
	$today = new CDate();
	$ts = $today->format(FMT_TIMESTAMP_DATE);
	
	$sign = ((strtok($period, ' ') == $AppUI->_('Next')) ? +1 : -1);
	
	$day_word = strtok(' ');
	if ($day_word == $AppUI->_('Day')) {
		$days = $period_value;
	} else if ($day_word == $AppUI->_('Week')) {
		$days = 7 * $period_value;
	} else if ($day_word == $AppUI->_('Month')) {
		$days = 30 * $period_value;
	}
	$start_date = new CDate($ts);
	$end_date = new CDate($ts);
	
	
	if ($sign > 0) {
		$end_date->addSpan(new Date_Span("$days,0,0,0"));
	} else {
		$start_date->subtractSpan(new Date_Span("$days,0,0,0"));
	}
	
	$do_report = 1;
} else {
	// create Date objects from the datetime fields
	$start_date = intval($list_start_date) ? new CDate($list_start_date) : new CDate();
	$end_date = intval($list_end_date) ? new CDate($list_end_date) : new CDate();
}


if (!$list_start_date) {
	$start_date->subtractSpan(new Date_Span('14,0,0,0'));
}
$end_date->setTime(23, 59, 59);

?>

<form name="editFrm" action="index.php?m=projects&a=reports" method="post">
<div>
<input type="hidden" name="project_id" value="<?php echo $project_id; ?>" />
<input type="hidden" name="report_type" value="<?php echo $report_type; ?>" />
</div>
<table cellspacing="0" cellpadding="4" border="0" width="100%" class="std">
  <tr>
    <td align="right"><?php echo $AppUI->_('Default Actions'); ?>:</td>
    <td nowrap="nowrap" colspan="2">
      <input class="button" type="submit" name="period" value="<?php 
echo $AppUI->_('Previous Month'); ?>" />
      <input class="button" type="submit" name="period" value="<?php 
echo $AppUI->_('Previous Week'); ?>" />
      <input class="button" type="submit" name="period" value="<?php 
echo $AppUI->_('Previous Day'); ?>" />
      <input class="button" type="submit" name="period" value="<?php 
echo $AppUI->_('Next Day'); ?>" />
      <input class="button" type="submit" name="period" value="<?php 
echo $AppUI->_('Next Week'); ?>" />
      <input class="button" type="submit" name="period" value="<?php 
echo $AppUI->_('Next Month'); ?>" />
      <input class="text" type="field" size="2" name="pvalue" value="1" /> - <?php echo $AppUI->_('value for the previous buttons'); ?>
    </td>
<!--
    <td><input class="button" type="submit" name="do_report" value="<?php 
echo $AppUI->_('Previous Month'); ?>" onClick="set(-30)" /></td>
    <td><input class="button" type="submit" name="do_report" value="<?php 
echo $AppUI->_('Previous Week'); ?>" onClick="set(-7)" /></td>
    <td><input class="button" type="submit" name="do_report" value="<?php 
echo $AppUI->_('Next Week'); ?>" onClick="set(7)" /></td>
    <td><input class="button" type="submit" name="do_report" value="<?php 
echo $AppUI->_('Next Month'); ?>" onClick="set(30)" /></td>
-->
  </tr>
  <tr>
    <td align="right" nowrap="nowrap"><?php echo $AppUI->_('For period'); ?>:</td>
    <td nowrap="nowrap">
      <input type="date" name="list_start_date" value="<?php 
echo $start_date->format(FMT_DATE_HTML5); ?>" class="text" />
      <input type="date" name="list_end_date" value="<?php 
echo (($end_date) ? $end_date->format(FMT_DATE_HTML5) : ''); ?>" class="text" />
      <input type="checkbox" name="log_all" id="log_all" value="1"<?php 
echo (($log_all) ? ' checked="checked"' : ''); ?> />
      <label for="log_all"><?php echo $AppUI->_('Log All'); ?></label>
      <input type="checkbox" name="log_pdf" id="log_pdf" value="1"<?php 
echo (($log_pdf) ? ' checked="checked"' : ''); ?> />
      <label for="log_pdf"><?php echo $AppUI->_('Make PDF'); ?></label>
      <input type="checkbox" name="incomplete" id="incomplete" value="1"<?php 
echo (($incomplete) ? ' checked="checked"' : ''); ?> />
      <label for="log_pdf"><?php echo $AppUI->_('Incomplete Tasks'); ?></label>
    </td>
    <td align="right" width="50%" nowrap="nowrap">
      <input class="button" type="submit" name="do_report" value="<?php 
echo $AppUI->_('submit'); ?>" />
    </td>
  </tr>
</form>
</table>

<?php

if ($do_report) {	
	$q = new DBQuery;
	$q->addTable('tasks', 'a');
	$q->addTable('projects', 'b');
	$q->addQuery('a.*, b.project_name');
	$q->addWhere('a.task_project = b.project_id');
	if ($project_id != 0) { 
		$q->addWhere('task_project =' . $project_id);
	}
	if (!$log_all) {
		$q->addWhere("task_start_date >= '" . $start_date->format(FMT_DATETIME_MYSQL) . "'");
		$q->addWhere("task_start_date <= '" . $end_date->format(FMT_DATETIME_MYSQL) . "'");
	}
	if ($incomplete) {
		$q->addWhere('task_percent_complete < 100');
	}

	$obj = new CTask;
	$allowedTasks = $obj->getAllowedSQL($AppUI->user_id);
	if (count($allowedTasks)) {
		$obj->getAllowedSQL($AppUI->user_id, $q);
	}
	$q->addOrder('project_start_date', 'task_project', 'task_parent');
	$Task_List = $q->exec();
?>

<table cellspacing="1" cellpadding="4" border="0" class="tbl">
  <tr>
<?php 
	if ($project_id == 0) { 
?>
    <th><?php echo $AppUI->_('Project Name'); ?></th>
<?php 
	}
?>
    <th><?php echo $AppUI->_('Task Name'); ?></th>
    <th width="400"><?php echo $AppUI->_('Task Description'); ?></th>
    <th><?php echo $AppUI->_('Assigned To'); ?></th>
    <th><?php echo $AppUI->_('Task Start Date'); ?></th>
    <th><?php echo $AppUI->_('Task End Date'); ?></th>
    <th><?php echo $AppUI->_('Completion'); ?></th>
</tr>
<?php
	
	$pdfdata = array();
	$tree = new CDpTree(array('project_start_date', 'task_start_date', 'task_id'));
	
	$columns = array(('<b>' . $AppUI->_('Task Name') . '</b>'), 
	                 ('<b>' . $AppUI->_('Task Description') . '</b>'), 
	                 ('<b>' . $AppUI->_('Assigned To') . '</b>'), 
	                 ('<b>' . $AppUI->_('Task Start Date') . '</b>'), 
	                 ('<b>' . $AppUI->_('Task End Date') . '</b>'), 
	                 ('<b>' . $AppUI->_('Completion') . '</b>'));
	if ($project_id==0) {
		array_unshift($columns, ('<b>' . $AppUI->_('Project Name') . '</b>'));
	}
	
	while ($Tasks = db_fetch_assoc($Task_List)) {
		$Tasks['start_date'] = ((intval($Tasks['task_start_date'])) 
		                        ? new CDate($Tasks['task_start_date']) : ' ');
		$Tasks['end_date'] = ((intval($Tasks['task_end_date'])) 
		                      ? new CDate($Tasks['task_end_date']) : ' ');
		$task_id = $Tasks['task_id'];
		
		$q = new DBQuery;
		$q->addQuery("CONCAT_WS(' ', c.contact_first_name, c.contact_last_name)" 
		             . ' as contact_name');
		$q->addTable('user_tasks', 'ut');
		$q->leftJoin('users', 'u', 'u.user_id = ut.user_id');
		$q->leftJoin('contacts', 'c', 'c.contact_id = u.user_contact');
		$q->addWhere('ut.task_id = ' . $task_id);
		$sql_user = $q->loadColumn();
		$Tasks['users'] = implode(', ', $sql_user);
		$tree->add($Tasks['task_parent'], $task_id, $Tasks);
		unset($Tasks);
	}
	
	// Now show the tasks as HTML
	$tree->display('show_task_as_html');
?>
</table>

<?php
	if ($log_pdf) {
		// make the PDF file
		$pdfdata = array();
		$tree->display('collate_pdf_task');
		$q = new DBQuery;
		$q->addTable('projects');
		$q->addQuery('project_name');
		$q->addWhere('project_id=' . ((int) $project_id));
		$pname = $q->loadResult();
		
		$font_dir = (DP_BASE_DIR . '/lib/ezpdf/fonts');
		$temp_dir = (DP_BASE_DIR . '/files/temp');
		
		require($AppUI->getLibraryClass('ezpdf/class.ezpdf'));

		$pdf = new Cezpdf($paper='A4',$orientation='landscape');
		$pdf->ezSetCmMargins(1, 2, 1.5, 1.5);
		$pdf->selectFont("$font_dir/Helvetica.afm");
		
		$pdf->ezText(safe_utf8_decode(dPgetConfig('company_name')), 12);
		//$pdf->ezText((dPgetConfig('company_name') . ' :: ' . dPgetConfig('page_title')), 12);
		
		$date = new CDate();
		$pdf->ezText("\n" . $date->format($df) , 8);
		
		$pdf->selectFont("$font_dir/Helvetica-Bold.afm");
		$pdf->ezText("\n" . safe_utf8_decode($AppUI->_('Project Task Report')), 12);
		if ($project_id != 0) {$pdf->ezText(safe_utf8_decode($pname), 15);}
		if ($log_all) {
			$pdf->ezText('All task entries', 9);
		} else if ($end_date != ' ') {
			$pdf->ezText(('Task entries from ' . $start_date->format($df) . ' to ' 
			              . $end_date->format($df)), 9);
		} else {
			$pdf->ezText(('Task entries from ' . $start_date->format($df)), 9);
		}
		$pdf->ezText("\n");
		$pdf->selectFont("$font_dir/Helvetica.afm");
		/**
		 * Need to use safe_utf8_decode because eZPDF doesn't understand UTF8, only Latin1
		 * Need UI_OUTPUT_RAW flag since HTML escape sequences like "&amp;" appear as-is in pdfs.
		 */
		$columns = array(('<b>' . safe_utf8_decode($AppUI->_('Task Name', UI_OUTPUT_RAW)) 
		                  . '</b>'), 
		                 ('<b>' . safe_utf8_decode($AppUI->_('Task Description', UI_OUTPUT_RAW)) 
		                  . '</b>'), 
		                 ('<b>' . safe_utf8_decode($AppUI->_('Assigned To', UI_OUTPUT_RAW)) 
		                  . '</b>'), 
		                 ('<b>' . safe_utf8_decode($AppUI->_('Task Start Date', UI_OUTPUT_RAW)) 
		                  . '</b>'), 
		                 ('<b>' . safe_utf8_decode($AppUI->_('Task End Date', UI_OUTPUT_RAW)) 
		                  . '</b>'), 
		                 ('<b>' . safe_utf8_decode($AppUI->_('Completion', UI_OUTPUT_RAW)) 
		                  . '</b>'));
		if ($project_id==0) {
			$columns_add = array(('<b>' 
			                      . safe_utf8_decode($AppUI->_('Project Name', UI_OUTPUT_RAW)) 
			                      . '</b>'));
			$columns = array_merge($columns_add, $columns);
		}
		$title = null;
		$options = array('showLines' => 2, 'showHeadings' => 1, 'fontSize' => 9, 
		                 'rowGap' => 4, 'colGap' => 5, 'xPos' => 50, 
		                 'xOrientation' => 'right', 'width'=>'750', 'shaded'=> 0, 
		                 'cols'=>array(0=>array('justification'=>'left', 'width'=>150),
		                               2=>array('justification'=>'left', 'width'=>95),
		                               3=>array('justification'=>'center', 'width'=>75),
		                               4=>array('justification'=>'center', 'width'=>75),
		                               5=>array('justification'=>'center', 'width'=>75)));
		
		$pdf->ezTable($pdfdata, $columns, $title, $options);
		
		if ($fp = fopen(($temp_dir . '/temp' . $AppUI->user_id . '.pdf'), 'wb')) {
			fwrite($fp, $pdf->ezOutput());
			fclose($fp);
			echo ('<a href="' . DP_BASE_URL . '/files/temp/temp' . $AppUI->user_id 
				  . '.pdf" target="pdf">' . $AppUI->_('View PDF File') . '</a>');
		} else {
			echo 'Could not open file to save PDF.';
			if (!(is_writable($temp_dir))) {
				'The files/temp directory is not writable. Check your file system permissions.';
			}
		}
	}
}
?>
</table>

<?php
function show_task_as_html($depth, $task) {
	global $project_id, $df;
	
	$str =  '<tr>';
	if ($project_id==0) {
		$str .= ('<td>' . $task['project_name'] . '</td>');
	}
	$str .= ('<td><a href="?m=tasks&a=view&task_id=' . $task['task_id'] . '">');
	for ($i = 1; $i < $depth; $i++) {
		$str .= '&nbsp;&nbsp;';
	}
	$str .= ($task['task_name'] . '</a></td>');
	$str .= ('<td>'.$task['task_description'].'</td>');
	$str .= ('<td>'.$task['users'].'</td>');
	$str .= ('<td>' . (($task['start_date'] != ' ') ? $task['start_date']->format($df) : ' ') 
			 . '</td>');
	$str .= ('<td>' . (($task['end_date'] != ' ') ? $task['end_date']->format($df) : ' ') 
			 . '</td>');
	$str .= ('<td align="center">' . $task['task_percent_complete'] . '%</td>');
	$str .= '</tr>';
	echo $str;
}

/**
 * Need to use safe_utf8_decode because eZPDF doesn't understand UTF8, only Latin1
 */
function collate_pdf_task($depth, $task) {
	global $project_id, $pdfdata, $df;
	
	$spacer = '';
	for ($i = 1; $i < $depth; $i++) {
		$spacer .= '  ';
	}
	
	$data = array();
	if ($project_id==0) {	
		$data[] = safe_utf8_decode($task['project_name']);
	}
	$data[] = ($spacer . safe_utf8_decode($task['task_name']));
	$data[] = safe_utf8_decode($task['task_description']);
	$data[] = safe_utf8_decode($task['users']);
	$data[] = safe_utf8_decode((($task['start_date'] != ' ') 
	                            ? $task['start_date']->format($df) : ' '));
	$data[] = safe_utf8_decode((($task['end_date'] != ' ') 
								? $task['end_date']->format($df) : ' '));
	$data[] = safe_utf8_decode(($task['task_percent_complete'] . '%'));
	$pdfdata[] = $data;
	unset($data);
}
?>
