public function overwriteRead($return) { $return = parent::overwriteRead($return); $objs = $return['objs']; foreach ($objs as $obj) { if (isset($obj->organization_active)) { $obj->organization_active = $this->arrayYesNO[$obj->organization_active]; } if (isset($obj->organization_parent_id)) { if ($obj->organization_parent_id < 1) { $obj->organization_parent_id = Lang::t('Top Level'); continue; } $r = new RoleOrganization(); $r->getByID($obj->organization_parent_id); $obj->organization_parent_id = $r->organization_name; } } return $return; }
public function Top_Department() { $bl = new BLogger(); $beginDate = addslashes($_GET['begindate']); if ($beginDate == "") { $month = date("n"); $day = 1; $year = date("Y"); $timeAwal = mktime(0, 0, 0, $month, $day, $year); $timeAkhir = mktime(0, 0, 0, $month + 1, $day, $year); $mon = $month; $y = $year; $timeAwalText = date("Y") . "-" . date("m") . "-01 00:00:00"; $ts = mktime(0, 0, 0, date("n") + 1, 1, date("Y")); $timeAkhirText = date("Y-m-d H:i:s", $ts); } else { $timeAwalText = $beginDate . " 00:00:00"; $bgindatestr = strtotime($beginDate); $mon = date("n", $bgindatestr); $y = date("Y", $bgindatestr); $ts = mktime(0, 0, 0, $mon + 1, 1, $y); $timeAkhirText = date("Y-m-d H:i:s", $ts); $year = $y; } /*echo $timeAwal; echo "<br>"; echo $timeAkhir; */ ?> <h1>Top Department</h1> <?php $text = "(b_log_time BETWEEN '{$timeAwalText}' AND '{$timeAkhirText}')"; $textAs = "b_timestamp >= {$timeAwal} AND b_timestamp < {$timeAkhir}"; // echo "<br>"; // echo $text; $arrLogs = $bl->getWhere("{$text} ORDER BY b_timestamp ASC"); //pr($arrLogs); foreach ($arrLogs as $h) { if ($h->log_user_org == "" || $h->log_user_org == 0) { continue; } $newArr["org_" . $h->log_user_org][] = $h; } foreach ($newArr as $url => $n) { $newArrs[$url] = count($n); } asort($newArrs); $jadi = array_reverse($newArrs); // pr($newArr); $t = time(); //pr($jadi); ?> <div class="table-responsive"> <form class="form-inline"> <div class="form-group"> <label for="monselection_<?php echo $t; ?> ">Select Month</label> <select class="form-control" id="monselection_<?php echo $t; ?> "><?php $beginyear = date("Y") - 5; $endyear = date("Y"); $beginyear = 2015; $mons = array(1 => "Jan", 2 => "Feb", 3 => "Mar", 4 => "Apr", 5 => "May", 6 => "Jun", 7 => "Jul", 8 => "Aug", 9 => "Sep", 10 => "Oct", 11 => "Nov", 12 => "Dec"); for ($x = $beginyear; $x <= $endyear; $x++) { for ($m = 1; $m < 13; $m++) { if ($m == $mon && $x == $year) { $select = "selected"; echo "in"; } else { $select = ""; } if ($x == date("Y")) { if ($m > date("n")) { continue; } } ?> <option <?php echo $select; ?> value="<?php echo $x; ?> -<?php echo $m; ?> -01"><?php echo $x; ?> <?php echo $mons[$m]; ?> </option> <?php } } ?> </select> </div> <button class="btn btn-default" onclick="window.open('<?php echo _SPPATH . _PHOTOURL . "logs/TopDepartment_" . $year . "_" . $mon; ?> .xls', '_blank');event.preventDefault();">Download</button> </form> <script> $('#monselection_<?php echo $t; ?> ').change(function(){ var slc = $('#monselection_<?php echo $t; ?> ').val(); openLw('Top_Department','<?php echo _SPPATH; ?> BLoggerWeb/Top_Department?begindate='+slc,'fade'); }); </script> <div style="padding: 10px;"></div> <table class="table table-bordered"> <thead> <tr> <th>Rank</th> <th>Department</th> <th>URL</th> <th>No.Visits</th> </tr> </thead> <?php $num = 0; $arrExcel = array(); $arrExcel2 = array(); $arrExcel[] = "Rank;Department;No.Visits"; foreach ($jadi as $url => $n) { $alog = $newArr[$url]; $num++; $dp = new RoleOrganization(); $id = explode("_", $url); //pr($id); $dp->getByID($id[1]); $arrExcel[] = "{$num};{$dp->organization_name};{$n}"; ?> <tr> <td><?php echo $num; ?> </td> <td><span style="cursor:pointer; text-decoration: underline;" onclick="$('.detail_<?php echo $url; ?> ').toggle();"><?php echo $dp->organization_name; ?> </span></td> <td></td> <td><?php echo $n; ?> </td> </tr> <?php $obje = array(); $obje["Rank"] = $num; $obje["Department"] = $dp->organization_name; $obje["URL"] = ""; $obje["No Visits"] = $n; $arrExcel2[] = $obje; $key = $url; $newArr_dalam = array(); foreach ($alog as $h) { $newArr_dalam[$h->b_log_url][] = $h; } $newArrs_dalam = array(); foreach ($newArr_dalam as $url => $n) { $newArrs_dalam[$url] = count($n); } asort($newArrs_dalam); $jadi_dalam = array_reverse($newArrs_dalam); ?> <?php $num_dalam = 0; foreach ($jadi_dalam as $url_dalam => $n_dalam) { $num_dalam++; ?> <tr class="detail_<?php echo $key; ?> " style="display:none;"> <td></td> <td></td> <td><?php echo $url_dalam; ?> <a href="<?php echo $url_dalam; ?> " target="_blank">link</a></td> <td><?php echo $n_dalam; ?> </td> </tr> <?php $obje2 = array(); $obje2["Rank"] = " "; $obje2["Department"] = " "; $obje2["URL"] = $url_dalam; $obje2["No Visits"] = $n_dalam; $arrExcel2[] = $obje2; } ?> <?php } ?> </table> </div> <?php /* $fname = "TopDepartment_".$year."_".$mon. ".csv"; $file = fopen(_PHOTOPATH . "logs/" . $fname, "w+"); foreach ($arrExcel as $line) { fputcsv($file, explode(';', $line)); } fclose($file);*/ $fname = _PHOTOPATH . "logs/" . "TopDepartment_" . $year . "_" . $mon . ".xls"; ExcelExporter::saveIt($arrExcel2, $fname); }
public function departmentPage() { //$org = RoleOrganization::getMy(); //if(!isset($org)) // die('no organization'); $targetID = isset($_GET['kelasid']) ? addslashes($_GET['kelasid']) : die("No Target ID"); $targetName = isset($_GET['type']) ? addslashes($_GET['type']) : die("No Target Name"); $r = new RoleOrganization(); $r->getByID($targetID); ?> <div class="col-md-7 col-md-offset-1"> <h1><?php echo $r->organization_name; ?> </h1> </div> <div class="clearfix"></div> <style> .widget { background-color: #cee2ec; border-radius: 5px; padding: 10px; color: #074d72; margin-bottom: 10px; } .widgethead h3 { border-bottom: 0px solid #074d72; padding: 0; margin: 0; font-size: 23px; } .widgethead { } .widget hr { border-bottom: 1px solid #074d72; padding: 0; margin: 0; margin-top: 5px; } .widgetBig { background-color: white; padding: 10px; clear: both; margin-bottom: 10px; } </style> <div class="row"> <div class="col-md-7 col-md-offset-1"> <div id="all_class_wall" class="widgetBig" style="padding-right: 20px; "> <?php $wall = new WallPortalWeb(); //$wall->limit = 5; $wall->printDepartmentWall(); ?> </div> </div> <div class="col-md-3 visible-md-block visible-lg-block"> <div id="myClassmate" class="widgetBig"> <?php // $mw = new Muridweb(); // $mw->myClassmate(4); $this->myCollagues(); ?> </div> <div id="mySchoolCalendarWidget" > <?php // $wid = new Widget(); // $wid->mySchoolCalendarWidget(); ?> </div> </div> </div> <?php }