Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package br.luck.managerbean; import br.luck.interfaces.AbstractManagedBean; import br.luck.managerbean.lazydatamodel.LotofacilLazyList; import br.luck.managerbean.lazydatamodel.LotomaniaLazyList; import br.luck.managerbean.lazydatamodel.MegasenaLazyList; import br.luck.modalidade.Lotofacil; import br.luck.modalidade.Lotomania; import br.luck.modalidade.Megasena; import br.luck.model.LotofacilModel; import br.luck.model.LotomaniaModel; import br.luck.model.MegasenaModel; import java.io.Serializable; import java.util.logging.Level; import java.util.logging.Logger; import javax.faces.bean.ManagedBean; import javax.faces.bean.ViewScoped; import javax.faces.component.FacesComponent; import javax.faces.context.FacesContext; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.util.HSSFColor; import org.primefaces.event.FileUploadEvent; import org.primefaces.event.SelectEvent; import org.primefaces.model.LazyDataModel; /** * * @author filipi */ @ManagedBean @ViewScoped public class PrincipalBean extends AbstractManagedBean implements Serializable { private LazyDataModel<MegasenaModel> concursosMegasena = null; private LazyDataModel<LotomaniaModel> concursosLotomania = null; private LazyDataModel<LotofacilModel> concursosLotofacil = null; private MegasenaModel selectConcursoMegasena; private LotomaniaModel selectConcursoLotomania; private LotofacilModel selectConcursoLotofacil; /** * Upload dos concursos - Megasena * * @param fileUploadEvent */ public void uploadArquivoMegasena(FileUploadEvent fileUploadEvent) { try { Megasena mega = new Megasena(); mega.setFileUploadEvent(fileUploadEvent); mega.importarArquivo(); super.addInfo(null, "\n", "Arquivo importado com sucesso"); } catch (Exception ex) { Logger.getLogger(PrincipalBean.class.getName()).log(Level.SEVERE, null, ex); super.addFatal(null, "Erro", ex.getMessage()); } } /** * Upload dos concursos - Lotomania * * @param fileUploadEvent */ public void uploadArquivoLotomania(FileUploadEvent fileUploadEvent) { try { Lotomania lotomania = new Lotomania(); lotomania.setFileUploadEvent(fileUploadEvent); lotomania.importarArquivo(); super.addInfo(null, "\n", "Arquivo importado com sucesso"); } catch (Exception ex) { Logger.getLogger(PrincipalBean.class.getName()).log(Level.SEVERE, null, ex); super.addFatal(null, "Erro", ex.getMessage()); } } /** * Upload dos concursos - Lotofcil * * @param fileUploadEvent */ public void uploadArquivoLotofacil(FileUploadEvent fileUploadEvent) { try { Lotofacil lotofacil = new Lotofacil(); lotofacil.setFileUploadEvent(fileUploadEvent); lotofacil.importarArquivo(); super.addInfo(null, "\n", "Arquivo importado com sucesso"); } catch (Exception ex) { Logger.getLogger(PrincipalBean.class.getName()).log(Level.SEVERE, null, ex); super.addFatal(null, "Erro", ex.getMessage()); } } /** * * * Carrega os concursos de acordo com a quantidade de linhas da tabela * utilizando a abordagem "Lazy" no datatable. - Megasena * * @return */ public LazyDataModel<MegasenaModel> getConcursosMegasena() { if (concursosMegasena == null) { concursosMegasena = new MegasenaLazyList(); } return concursosMegasena; } public void setConcursosMegasena(LazyDataModel<MegasenaModel> concursosMegasena) { this.concursosMegasena = concursosMegasena; } /** * * * Carrega os concursos de acordo com a quantidade de linhas da tabela * utilizando a abordagem "Lazy" no datatable. - Lotomania * * @return */ public LazyDataModel<LotomaniaModel> getConcursosLotomania() { if (concursosLotomania == null) { concursosLotomania = new LotomaniaLazyList(); } return concursosLotomania; } public void setConcursosLotomania(LazyDataModel<LotomaniaModel> concursosLotomania) { this.concursosLotomania = concursosLotomania; } /** * * * Carrega os concursos de acordo com a quantidade de linhas da tabela * utilizando a abordagem "Lazy" no datatable. - Lotofacil * * @return */ public LazyDataModel<LotofacilModel> getConcursosLotofacil() { if (concursosLotofacil == null) { concursosLotofacil = new LotofacilLazyList(); } return concursosLotofacil; } public void setConcursosLotofacil(LazyDataModel<LotofacilModel> concursosLotofacil) { this.concursosLotofacil = concursosLotofacil; } /** * * * Mantm o objeto selecionado nas linhas da tabela * * @return selectConcursoMegasena */ public MegasenaModel getSelectConcursoMegasena() { return selectConcursoMegasena; } public void setSelectConcursoMegasena(MegasenaModel selectConcursoMegasena) { this.selectConcursoMegasena = selectConcursoMegasena; } /** * * * Mantm o objeto selecionado nas linhas da tabela * * @return selectConcursoLotomania */ public LotomaniaModel getSelectConcursoLotomania() { return selectConcursoLotomania; } public void setSelectConcursoLotomania(LotomaniaModel selectConcursoLotomania) { this.selectConcursoLotomania = selectConcursoLotomania; } /** * * * Mantm o objeto selecionado nas linhas da tabela * * @return selectConcursoLotofacil */ public LotofacilModel getSelectConcursoLotofacil() { return selectConcursoLotofacil; } public void setSelectConcursoLotofacil(LotofacilModel selectConcursoMegasena) { this.selectConcursoLotofacil = selectConcursoLotofacil; } /** * * * Recupera o objeto da linha da tabela selecionada por ajax. * * @param event */ public void onMegasenaRowSelect(SelectEvent event) { this.selectConcursoMegasena = (MegasenaModel) event.getObject(); } /** * * * Recupera o objeto da linha da tabela selecionada por ajax. * * @param event */ public void onLotomaniaRowSelect(SelectEvent event) { this.selectConcursoLotomania = (LotomaniaModel) event.getObject(); } /** * * * Recupera o objeto da linha da tabela selecionada por ajax. * * @param event */ public void onLotofacilRowSelect(SelectEvent event) { this.selectConcursoLotofacil = (LotofacilModel) event.getObject(); } /*** * Exporta para arquivo xls * @param document */ public void postProcessXLS(Object document) { HSSFWorkbook wb = (HSSFWorkbook) document; HSSFSheet sheet = wb.getSheetAt(0); HSSFRow header = sheet.getRow(0); HSSFCellStyle cellStyle = wb.createCellStyle(); cellStyle.setFillForegroundColor(HSSFColor.GREEN.index); cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); for (int i = 0; i < header.getPhysicalNumberOfCells(); i++) { HSSFCell cell = header.getCell(i); cell.setCellStyle(cellStyle); } } }