<?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