use App\Models\UsuariosModel; use App\Models\PermissionsModel; use App\Models\CustomModel; use App\Models\EscolasModel; function checkGere(){ $usuarios = new UsuariosModel(); $session_id = session()->get('user_id'); $user = (($session_id > 0)? $usuarios->pegar_um_por_id($session_id) : FALSE); if(isset($user->LEVEL) && $user->LEVEL == "Gere"){ if (isset($user->GEE) && $user->GEE > 0){ return true; } else{ session()->setFlashdata('msg',array('type'=>'error','message'=>'Você não possui uma GEE definida!')); redirect_page('/dashboard'); //response()->setHeader('Location', site_url('/dashboard')); } } } function checkAccess($local){ $usuarios = new UsuariosModel(); $permission = new PermissionsModel(); $session_id = session()->get('user_id'); $user = (($session_id > 0)? $usuarios->pegar_um_por_id($session_id) : FALSE); $perm = (($session_id > 0)? $permission->get_one_by_local($local) : FALSE); if (isset($perm->LEVEL) && isset($user->LEVEL) && !str_contains($perm->LEVEL,"|".$user->LEVEL."|")) { session()->setFlashdata('msg',array('type'=>'error','message'=>'Você não tem permissão para acessar essa página!')); redirect_page('/dashboard'); //response()->setHeader('Location', site_url('/dashboard')); } } function view_checkAccess($local){ $usuarios = new UsuariosModel(); $permission = new PermissionsModel(); $session_id = session()->get('user_id'); $user = (($session_id > 0)? $usuarios->pegar_um_por_id($session_id) : FALSE); $perm = (($session_id > 0)? $permission->get_one_by_local($local) : FALSE); if (isset($perm->LEVEL) && isset($user->LEVEL) && !str_contains($perm->LEVEL,"|".$user->LEVEL."|")) { return FALSE; } return TRUE; } function adminAccess($user_type){ $usuarios = new UsuariosModel(); $session_id = session()->get('user_id'); $user = (($session_id > 0)? $usuarios->pegar_um_por_id($session_id) : FALSE); if (isset($user->ID) && !in_array($user->LEVEL,$user_type)) { session()->setFlashdata('msg',array('type'=>'error','message'=>'Você não tem permissão para acessar essa página!')); // response()->setHeader('Location', site_url('/dashboard')); redirect_page('/dashboard'); } } function enableAccess($user_type){ $usuarios = new UsuariosModel(); $session_id = session()->get('user_id'); $user = (($session_id > 0)? $usuarios->pegar_um_por_id($session_id) : FALSE); if (isset($user->ID) && in_array($user->LEVEL,$user_type)) { return true; } else{ return false; } } function redirect_page($page){ echo ''; exit; } function create_xls_servidor($title,$data){ include('PHPExcel/Classes/PHPExcel.php'); $objPHPExcel = new PHPExcel(); $objPHPExcel->getActiveSheet()->fromArray($data, null, 'A1'); $lastrow = $objPHPExcel->getActiveSheet()->getHighestRow(); $objPHPExcel->getActiveSheet()->getStyle('A1:M1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A1:M1')->getFont()->setSize(14); $objPHPExcel->getActiveSheet()->getStyle('A1:M1')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle('A1:M1')->applyFromArray(array('fill' => array('type' => PHPExcel_Style_Fill::FILL_SOLID,'color' => array('rgb' => 'F3F6F4')))); $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(50); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(50); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(25); $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(25); $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(30); $objPHPExcel->getActiveSheet()->getStyle('A2:L'.$lastrow)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="'.$title.'.xlsx"'); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); /* //We add contents //Warning, a utf8_encode() is necessary for the character like 'é', 'è', .. $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Ligne 1 Colonne 1'); $objPHPExcel->getActiveSheet()->setCellValue('A2', utf8_encode('Durée')); //Manage the size of the column $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15); //Manage font style $objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(10); $objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE); $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); //Make a border style $objPHPExcel->getActiveSheet()->getStyle('A1')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objPHPExcel->getActiveSheet()->getStyle('A1')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objPHPExcel->getActiveSheet()->getStyle('A1')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objPHPExcel->getActiveSheet()->getStyle('A1')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); // Save our file xlsx $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="'.$title.'.xls"'); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); //$objWriter->save('../data_xls/myfileXLS.xlsx'); */ } function create_xls_lotacao($title,$data){ include('PHPExcel/Classes/PHPExcel.php'); $objPHPExcel = new PHPExcel(); $objPHPExcel->getActiveSheet()->fromArray($data, null, 'A1'); $lastrow = $objPHPExcel->getActiveSheet()->getHighestRow(); $objPHPExcel->getActiveSheet()->getStyle('A1:M1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A1:M1')->getFont()->setSize(14); $objPHPExcel->getActiveSheet()->getStyle('A1:M1')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle('A1:M1')->applyFromArray(array('fill' => array('type' => PHPExcel_Style_Fill::FILL_SOLID,'color' => array('rgb' => 'F3F6F4')))); $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(50); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(50); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(25); $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(25); $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(30); $objPHPExcel->getActiveSheet()->getStyle('A2:L'.$lastrow)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="'.$title.'.xlsx"'); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); } function read_xls($excelFilename,$method){ include('PHPExcel/Classes/PHPExcel.php'); $excelType = PHPExcel_IOFactory::identify($excelFilename); $excelReader = PHPExcel_IOFactory::createReader($excelType); $excelReader->setReadDataOnly(true); $objPHPExcel = $excelReader->load($excelFilename); $highestColumm = $objPHPExcel->setActiveSheetIndex(0)->getHighestColumn(); $highestRow = $objPHPExcel->setActiveSheetIndex(0)->getHighestRow(); foreach ($objPHPExcel->setActiveSheetIndex(0)->getRowIterator() as $key=>$row) { $cellIterator = $row->getCellIterator(); $cellIterator->setIterateOnlyExistingCells(false); foreach ($cellIterator as $key2=>$cell) { if (!is_null($cell->getCalculatedValue())) { $col = convertLetterToColl($key2,$method); $value[$key][$col] = (string)$cell->getCalculatedValue(); } /* else{ $col = convertLetterToColl($key2,$method); $value[$key][$col] = ""; }*/ } } return $value; } function convertLetterToColl($letter,$method){ if($method == "add"){ $x["A"] = "NOME"; $x["B"] = "CPF"; $x["C"] = "RG"; $x["C"] = "CARGA HORÁRIA"; } if($method == "update"){ $x["A"] = "CPF"; $x["A"] = "CPF"; } if(isset($x[$letter]) && $x[$letter] > 0){ return $x[$letter]; } else{ return ""; } } function all_geres($blank = FALSE){ if(isset($blank) && $blank == TRUE){ $result[""] = ""; } for($i=1; $i <= 13;$i++){ $value = sprintf("%02d", $i)." GEE"; $result[$value] = $i."ª GEE"; } return $result; } function all_schools($GEE){ $result[""] = ""; if(isset($GEE) && $GEE == "none"){ return $result; } $customdb = new CustomModel(); $GEE = fix_gere($GEE); $schools = $customdb->pegar_todas_lotacoes($GEE); foreach($schools as $school){ $result[$school->escola] = $school->escola; } return $result; } function fix_gere($GEE){ for($i=1; $i <= 13;$i++){ $value = sprintf("%02d", $i)." GEE"; $result[$value] = $i; } if(isset($GEE) && isset($result[$GEE]) && $GEE > 0 && $result[$GEE] > 0){ return $result[$GEE]; } else{ return $GEE; } } function pegar_carga_horaria_total($id = FALSE){ $customdb = new CustomModel(); $carga_horaria = $customdb->pegar_carga_horaria_total($id); if(isset($carga_horaria) && $carga_horaria){ $carga_horaria = $carga_horaria->horas; } else{ $carga_horaria = "N/A"; } return $carga_horaria; } function gerar_pdf(){ $pdf = new FPDF(); $pdf->AddPage(); $pdf->SetFont('Arial','B',12); $width_cell=array(10,30,20,30); $pdf->SetFillColor(193,229,252); $pdf->Cell($width_cell[0],10,'ID',1,0,true); $pdf->Cell($width_cell[1],10,'NAME',1,0,true); $pdf->Cell($width_cell[2],10,'CLASS',1,0,true); $pdf->Cell($width_cell[3],10,'MARK',1,1,true); $pdf->SetFont('Arial','',10); $pdf->Cell($width_cell[0],10,'1',1,0,false); $pdf->Cell($width_cell[1],10,'John Deo',1,0,false); $pdf->Cell($width_cell[2],10,'Four',1,0,false); $pdf->Cell($width_cell[3],10,'75',1,1,false); $pdf->Output(); }