<?php
/* retrieve all categories */
$array = getAllCategory();
$x = 0;
/* loop through the array */
while ($x < count($array)) {
?>
<div class="panel panel-default">
<div class="panel-heading">
<h4 class="panel-title"><a href="pakaian/category/<?php
echo strtolower($array[$x]['category']);
?>
"><?php
echo $array[$x]['category'];
?>
</a></h4>
</div>
</div>
<?php
$x++;
}
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;
}
/*
|--------------------|
| SORTING |
|--------------------|
*/
$equal_search = array('type_visibility', 'total_recipes', 'category_visibility');
$default_sort_by = "recipe_name";
if ($_REQUEST["cat"] == "" || $_REQUEST["cat"] == "top") {
$cat = 'top';
$field = "additional";
} else {
$field = "category_recipes";
$cat = $_REQUEST["cat"];
$cat_name = $_REQUEST["cat"];
}
$recipe_category = getAllCategory();
$pgdata = page_init($equal_search, $default_sort_by);
// static/general.php
$page = $pgdata['page'];
$query_per_page = $pgdata['query_per_page'];
$sort_by = $pgdata['sort_by'];
$first_record = $pgdata['first_record'];
$search_parameter = $pgdata['search_parameter'];
$search_value = $pgdata['search_value'];
$search_query = $pgdata['search_query'];
$search = $pgdata['search'];
$full_product = get_full_recipes($search_query, $field, $cat, $sort_by, $first_record, $query_per_page);
$total_query = $full_product['total_query'];
$total_page = $full_product['total_page'];
// RESULT
// FROM get.php
