public function work()
{
while ($this->getHoursLeft() > 0) {
if ($this->getCurrentTask() != null) {
if ($this->getHoursLeft() > $this->getCurrentTask()->getWorkingHours()) {
$this->hoursLeft = $this->hoursLeft - $this->currentTask->getWorkingHours();
echo "Your task is finished, get new task!", PHP_EOL;
break;
} elseif ($this->hoursLeft < $this->currentTask . getWorkingHours()) {
$this->currentTask->setWorkingHours($this->currentTask->getWorkingHours() - $this->getHoursLeft());
$this->setHoursLeft(0);
} else {
$this->setHoursLeft(0);
$this->currentTask->setWorkingHours(0);
}
} else {
$len = $this->allWork->getTasks()->length - $this->allWork->freePlacesForTask;
if ($this->allWork->getCurrentUnsignedTask() < $len) {
$this->setCurrentTask($this->allWork->getNextTask());
$this->allWork->setCurrentUnsignedTask($this->allWork->getCurrentUnsignedTask() + 1);
echo "The new task is " + $this->currentTask->getName(), PHP_EOL;
} else {
echo "Your work is finished!", PHP_EOL;
this . setHoursLeft(0);
}
}
}
}
<a href="excel3.php?<?php
echo $_SERVER['QUERY_STRING'];
?>
">Formatted Excel Sheet</a>
<?php
if ($_GET['mydate']) {
$time = strtotime($_GET['mydate']);
} else {
$time = time();
}
$arr = getDays($time);
$fromdate = $arr['monday']['year'] . "-" . $arr['monday']['mon'] . "-" . $arr['monday']['mday'];
$todate = $arr['sunday']['year'] . "-" . $arr['sunday']['mon'] . "-" . $arr['sunday']['mday'];
// get array
include 'f_workinghours.php';
$returnArray = getWorkingHours($time, $_GET['user_id']);
// end array
?>
<table border="1" cellspacing="0" cellpadding="5">
<tr>
<td><strong>Category</strong></td>
<td><strong>Projects</strong></td>
<td><strong>Tasks</strong></td>
<?php
foreach ($arr as $key => $value) {
?>
<td><strong><?php
echo ucfirst($key);
?>
<br><?php
echo $arr[$key]['mday'] . " " . $arr[$key]['month'];
function getTimeSheetNew2($time, $user_id)
{
static $did1 = 0;
$colname_rsTimesheet = "-1";
if (isset($user_id)) {
$colname_rsTimesheet = get_magic_quotes_gpc() ? $user_id : addslashes($user_id);
}
$query_rsTimesheet = sprintf("SELECT * FROM procentris_timesheet WHERE user_id = %s", $colname_rsTimesheet);
$rsTimesheet = mysql_query($query_rsTimesheet) or die(mysql_error());
$row_rsTimesheet = mysql_fetch_assoc($rsTimesheet);
$totalRows_rsTimesheet = mysql_num_rows($rsTimesheet);
$returnArray = getWorkingHours($time, $user_id);
$today = getdate($time);
$chkdate = $today['weekday'];
$chkdate2 = strtolower($chkdate);
$arr = getDays($time);
$fromdate = $arr['monday']['year'] . "-" . $arr['monday']['mon'] . "-" . $arr['monday']['mday'];
$todate = $arr['sunday']['year'] . "-" . $arr['sunday']['mon'] . "-" . $arr['sunday']['mday'];
//$fromdate = $arr[$chkdate2]['year']."-".$arr[$chkdate2]['mon']."-".$arr[$chkdate2]['mday'];
//$todate = $arr[$chkdate2]['year']."-".$arr[$chkdate2]['mon']."-".$arr[$chkdate2]['mday'];
$category = array();
$category = getAllCategory($user_id);
$result = '<div id="divTimesheetNew"><br><br>';
//$result .= "<a href=\"javascript:doAjax('ajaxAddNew.php','GET','user_id=".$user_id."&mydate=".date('Y-m-d',$time)."','','newCategory');\">ADD NEW TASK</a><br>";
//$result .= "<div id='newCategory'></div>";
if ($category) {
$result .= '<br>';
foreach ($category as $categoryKey => $categoryValue) {
$categorycnt[$categoryValue] = 1;
if ($categorycnt[$categoryValue] == 1) {
$result .= "<a href=\"javascript:toggleLayer2('c" . $categoryKey . "');\"><img border=0 align=left height=11 width=13 src=images/is.jpg title='Show Projects'></a> ";
$result .= '<font color=blue><b>' . $categoryValue . '</b></font>';
$did1++;
$did = "div" . $did1;
$result .= '<form name="' . $did . '" action="" method="post">Add New Project: <input type="text" name="list" value="" size=8><input type="hidden" value="' . $categoryKey . '" name="pid"><input type="hidden" value="' . $user_id . '" name="user_id"><input type="hidden" value="2" name="level"><input type="hidden" value="Project" name="list_type"><input type="hidden" value="c' . $categoryKey . '" name="showCategory"><input type="submit" name="Go" value="Go"></form>';
}
$project = getAllProject($user_id, $categoryKey);
if ($project) {
$result .= '<div id="c' . $categoryKey . '" style="display:none;">';
foreach ($project as $projectKey => $projectValue) {
$projectcnt[$projectValue] = 1;
if ($projectcnt[$projectValue] == 1) {
$did1++;
$did = "div" . $did1;
$result .= '<blockquote>';
$result .= "<a href=\"javascript:toggleLayer2('p" . $projectKey . "');\"><img border=0 align=left height=11 width=13 src=images/is.jpg title='Show Tasks'></a> ";
$result .= '<font color=red><b>' . $projectValue . '</b></font>';
$did1++;
$did = "div" . $did1;
$result .= '<form name="' . $did . '" action="" method="post">Add New Task: <input type="text" name="list" value="" size=8><input type="hidden" value="' . $projectKey . '" name="pid"><input type="hidden" value="' . $user_id . '" name="user_id"><input type="hidden" value="3" name="level"><input type="hidden" value="Task" name="list_type"><input type="hidden" value="p' . $projectKey . '" name="showProject"><input type="hidden" value="c' . $categoryKey . '" name="showCategory"><input type="submit" name="Go" value="Go"></form>';
$result .= '</blockquote>';
}
$result .= "<div id='p" . $projectKey . "' style='display:none;'>";
// start of code
$task = getAllTask($user_id, $categoryKey, $projectKey);
if ($task) {
$j = 0;
$result1 = "";
foreach ($task as $taskKey => $taskValue) {
$categorycnt[$categoryValue]++;
$projectcnt[$projectValue]++;
$result1 .= '<td align=left><b>' . $taskValue . '</b></td>';
$i = 0;
$totalh[$j] = 0;
foreach ($arr as $key => $value) {
$timetaken[$i] = getTime($user_id, $categoryKey, $projectKey, $taskKey, $arr[$key]['year'] . "-" . $arr[$key]['mon'] . "-" . $arr[$key]['mday']);
if (number_format($timetaken[$i], 2) == "0.00") {
$taketime = " ";
} else {
$taketime = number_format($timetaken[$i], 2);
}
// end of if timetaken
$did1++;
//$cid = "divc".$categoryKey."p".$projectKey."t".$taskKey."a".$did1;
$did = "div" . $did1;
$result1 .= "<td align=right><div id='" . $did . "'>" . $taketime . "<a href=\"javascript:doAjax('ajax_input.php','GET','user_id=" . $user_id . "&category=" . $categoryKey . "&project=" . $projectKey . "&tasks=" . $taskKey . "&cdate=" . date('Y-m-d', $value[0]) . "&cday=" . date('d', $value[0]) . "&cmonth=" . date('m', $value[0]) . "&cyear=" . date('Y', $value[0]) . "&timetaken=" . number_format($timetaken[$i], 2) . "&did=" . $did . "&mydate=" . date('Y-m-d', $time) . "','','" . $did . "');\"><img border=0 height=5 width=5 align=right src=images/is.jpg></a></div></td>";
$totalv[$key] += $timetaken[$i];
$totalh[$j] += $timetaken[$i];
$i++;
}
// end of foreach $arr as $key=>$value
$j++;
$result1 .= '</tr>';
}
// end of foreach task
// end of code
$tmp = "";
$tmp = wireframe($today, $arr, $returnArray, $result1);
$result .= "<blockquote><blockquote>";
$result .= $tmp;
$result .= "</blockquote></blockquote>";
}
// end of if task
$result .= "</div>";
}
$result .= '</div>';
}
}
}
$result .= "</div>";
$result .= "<div id='tempDiv'></div>";
return $result;
}
