/** * * @return array */ public function areaReport() { $rows = $this->selectGraduated(); $data = array('MANE' => 0, 'FETO' => 0, 'total' => 0); $schoolData = array('total' => 0, 'MANE' => 0, 'FETO' => 0, 'porcent' => 0); $areaScholarity = array(); foreach ($rows as $row) { $gender = trim($row['gender']); $area = trim($row['scholarity_area']); if (!array_key_exists($area, $areaScholarity)) { $areaScholarity[$area] = $schoolData; } $areaScholarity[$area][$gender]++; $areaScholarity[$area]['total']++; $data['total']++; $data[$gender]++; } foreach ($areaScholarity as $area => $row) { $areaScholarity[$area]['porcent'] = round(100 * $row['total'] / $data['total'], 2); } $data['rows'] = $areaScholarity; if (!empty($data['rows'])) { $pie = array('series' => array(), 'labels' => array()); $column = array('series' => array(), 'labels' => array(), 'names' => array()); $man = array(); $woman = array(); $view = Zend_Layout::getMvcInstance()->getView(); foreach ($data['rows'] as $area => $row) { $area = App_General_String::addBreakLine($view->truncate(ucfirst(strtolower($area)), 20), 1); $pie['series'][] = $row['total']; $pie['labels'][] = $area; $man[] = $row['MANE']; $woman[] = $row['FETO']; $column['labels'][] = $area; } $column['series'] = array($man, $woman); $column['names'] = array('MANE', 'FETO'); $scaleConfig = array('LabelRotation' => 90, 'XMargin' => 20); $data['graph'][App_General_String::randomHash()] = App_Util_Chart::columnChart($column, 'Graduadu liu husi Area / Seksu', $scaleConfig); } return $data; }
/** * * @return array */ public function schoolQuarterReport() { $rows = $this->getFilteredRows($this->_data); $gender = array('mane' => 0, 'feto' => 0); $quarters = array_combine(range(1, 4), array_fill(0, 4, $gender)); $data = array('total' => 0, 'totals' => $quarters, 'rows' => array()); foreach ($rows as $row) { $school = empty($row['max_level_scholarity']) ? 'LA IHA' : $row['max_level_scholarity']; if (!array_key_exists($school, $data['rows'])) { $data['rows'][$school] = array('quarters' => $quarters, 'total' => 0); } $quarter = ceil($row['month_registration'] / 3); $gender = strtolower(trim($row['gender'])); $data['total']++; $data['totals'][$quarter][$gender]++; $data['rows'][$school]['total']++; $data['rows'][$school]['quarters'][$quarter][$gender]++; } $column = array('series' => array(), 'labels' => array(), 'names' => array()); $quarters = array(1 => array(), 2 => array(), 3 => array(), 4 => array()); foreach ($data['rows'] as $level => $row) { $column['labels'][] = $level; foreach ($row['quarters'] as $q => $value) { $quarters[$q][] = $value['mane'] + $value['feto']; } } $column['series'] = $quarters; $column['names'] = array(1 => 'QTR1', 'QTR2', 'QTR3', 'QTR4'); $data['graph'][App_General_String::randomHash()] = App_Util_Chart::columnChart($column, 'Nivel Edukasaun / Tinan ' . $this->_data['year']); return $data; }
/** * * @return array */ public function educationReport() { $rows = $this->filterAppliedJob($this->_data); $mapperClient = new Report_Model_Mapper_Client(); $data = $mapperClient->registerSchoolLevel($rows); $column = array('series' => array(), 'labels' => array(), 'names' => array()); $man = array(); $woman = array(); foreach ($data['rows'] as $school => $row) { $man[] = $row['MANE']; $woman[] = $row['FETO']; $column['labels'][] = $school; } $column['series'] = array($man, $woman); $column['names'] = array('MANE', 'FETO'); $data['graph'][App_General_String::randomHash()] = App_Util_Chart::columnChart($column, 'Nivel Eskola / Tinan ' . $this->_data['year']); return $data; }