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; }