Java tutorial
/** * Copyright (C) 2011 ArtiVisi Intermedia <info@artivisi.com> * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package com.artivisi.biller.simulator.service.impl; import java.math.BigDecimal; import java.math.RoundingMode; import java.util.ArrayList; import java.util.Date; import java.util.List; import org.hibernate.SessionFactory; import org.joda.time.DateTime; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.StringUtils; import com.artivisi.biller.simulator.dto.GeneratorTagihanPascabayar; import com.artivisi.biller.simulator.entity.Bank; import com.artivisi.biller.simulator.entity.Pelanggan; import com.artivisi.biller.simulator.entity.PembayaranPascabayar; import com.artivisi.biller.simulator.entity.TagihanNontaglis; import com.artivisi.biller.simulator.entity.TagihanNontaglisDetail; import com.artivisi.biller.simulator.entity.TagihanPascabayar; import com.artivisi.biller.simulator.service.PlnSimulatorService; @Service("plnSimulatorService") @Transactional public class PlnSimulatorServiceImpl implements PlnSimulatorService { @Autowired private SessionFactory sessionFactory; @Override public void save(Pelanggan pelanggan) { sessionFactory.getCurrentSession().saveOrUpdate(pelanggan); } @Override public void delete(Pelanggan pelanggan) { if (pelanggan == null || !StringUtils.hasText(pelanggan.getId())) { return; } sessionFactory.getCurrentSession().createQuery( "delete from PembayaranPascabayar p where p.tagihanPascabayar.id in (select t.id from TagihanPascabayar t where t.pelanggan.id = :pelanggan)") .setString("pelanggan", pelanggan.getId()).executeUpdate(); sessionFactory.getCurrentSession() .createQuery("delete from TagihanPascabayar t where t.pelanggan.id = :pelanggan") .setString("pelanggan", pelanggan.getId()).executeUpdate(); sessionFactory.getCurrentSession().delete(pelanggan); } @Override public Pelanggan findPelangganById(String id) { if (!StringUtils.hasText(id)) return null; return (Pelanggan) sessionFactory.getCurrentSession().get(Pelanggan.class, id); } @SuppressWarnings("unchecked") @Override public List<Pelanggan> findAllPelanggan() { return sessionFactory.getCurrentSession().createQuery("from Pelanggan order by idpel, nama").list(); } @Override public Pelanggan findPelangganByIdpel(String idpel) { if (!StringUtils.hasText(idpel)) return null; return (Pelanggan) sessionFactory.getCurrentSession().createQuery("from Pelanggan where idpel = :idpel") .setString("idpel", idpel.trim()).uniqueResult(); } @Override public Pelanggan findPelangganByMeterNumber(String meternum) { if (!StringUtils.hasText(meternum)) return null; return (Pelanggan) sessionFactory.getCurrentSession() .createQuery("from Pelanggan where meterNumber = :meternum").setString("meternum", meternum.trim()) .uniqueResult(); } @Override public void save(TagihanPascabayar tagihanPascabayar) { sessionFactory.getCurrentSession().saveOrUpdate(tagihanPascabayar); } @Override public void delete(TagihanPascabayar tagihanPascabayar) { if (tagihanPascabayar == null || !StringUtils.hasText(tagihanPascabayar.getId())) return; sessionFactory.getCurrentSession() .createQuery("delete from PembayaranPascabayar p where p.tagihanPascabayar.id = :tagihan") .setString("tagihan", tagihanPascabayar.getId()).executeUpdate(); sessionFactory.getCurrentSession().delete(tagihanPascabayar); } @Override public List<TagihanPascabayar> findTagihan(Pelanggan pelanggan) { if (pelanggan == null || !StringUtils.hasText(pelanggan.getId())) { return new ArrayList<TagihanPascabayar>(); } return findTagihan(pelanggan, false); } @SuppressWarnings("unchecked") private List<TagihanPascabayar> findTagihan(Pelanggan pelanggan, Boolean lunas) { return sessionFactory.getCurrentSession().createQuery( "from TagihanPascabayar t where t.pelanggan.id = :pelanggan and t.lunas = :lunas order by t.billPeriod") .setString("pelanggan", pelanggan.getId()).setBoolean("lunas", lunas).list(); } @SuppressWarnings("unchecked") private List<TagihanNontaglis> findTagihanNontaglis(Pelanggan pelanggan, Boolean lunas) { return sessionFactory.getCurrentSession().createQuery( "from TagihanPascabayar t where t.pelanggan.id = :pelanggan and t.lunas = :lunas order by t.billPeriod") .setString("pelanggan", pelanggan.getId()).setBoolean("lunas", lunas).list(); } @Override public void generatePascabayar(GeneratorTagihanPascabayar generator) { // hapus dulu data existing sessionFactory.getCurrentSession().createQuery("delete from PembayaranPascabayar").executeUpdate(); sessionFactory.getCurrentSession().createQuery("delete from TagihanPascabayar").executeUpdate(); sessionFactory.getCurrentSession().createQuery("delete from Pelanggan").executeUpdate(); // insert pelanggan normal Integer current = 0; for (int i = 0; i < generator.getNormal(); i++) { generateTagihanNormal(current, i); current++; } } private void generateTagihanNormal(Integer current, int i) { Pelanggan p = new Pelanggan(); p.setNama("Pelang'gan Dumm\"y " + current); TagihanPascabayar t = new TagihanPascabayar(); t.setPelanggan(p); t.setBillPeriod(new Date()); t.setDueDate(new DateTime().dayOfMonth().setCopy(20).toDate()); t.setMeterReadDate(new DateTime().minusDays(10).toDate()); t.setBill(new BigDecimal(Math.random() * 100000).setScale(2, RoundingMode.HALF_EVEN)); t.setVat(t.getBill().divide(new BigDecimal(10))); Integer prev = Double.valueOf(Math.random() * 100).intValue(); Integer curr = prev + Double.valueOf(Math.random() * 10).intValue(); t.setPreviousMeterRead1(String.valueOf(prev)); t.setPreviousMeterRead2(String.valueOf(prev)); t.setPreviousMeterRead3(String.valueOf(prev)); t.setCurrentMeterRead1(String.valueOf(curr)); t.setCurrentMeterRead2(String.valueOf(curr)); t.setCurrentMeterRead3(String.valueOf(curr)); if (i % 4 == 0) { p.setIdpel("51" + org.apache.commons.lang.StringUtils.leftPad(current.toString(), 10, "0")); p.setMeterNumber("51" + org.apache.commons.lang.StringUtils.leftPad(current.toString(), 9, "0")); p.setServiceUnit("51"); p.setServiceUnitPhone("51-1234567890"); p.setPowerConsumingCategory("900"); p.setSubscriberSegmentation("R1"); t.setInsentif(t.getBill().multiply(new BigDecimal(0.8))); } else if (i % 3 == 0) { p.setIdpel("52" + org.apache.commons.lang.StringUtils.leftPad(current.toString(), 10, "0")); p.setMeterNumber("52" + org.apache.commons.lang.StringUtils.leftPad(current.toString(), 9, "0")); p.setServiceUnit("52"); p.setServiceUnitPhone("52-1234567890"); p.setPowerConsumingCategory("1300"); p.setSubscriberSegmentation("R2"); t.setInsentif(t.getBill().multiply(new BigDecimal(-0.8))); } else if (i % 2 == 0) { p.setIdpel("53" + org.apache.commons.lang.StringUtils.leftPad(current.toString(), 10, "0")); p.setMeterNumber("53" + org.apache.commons.lang.StringUtils.leftPad(current.toString(), 9, "0")); p.setServiceUnit("53"); p.setServiceUnitPhone("53-1234567890"); p.setPowerConsumingCategory("2000"); p.setSubscriberSegmentation("S1"); } else { p.setIdpel("54" + org.apache.commons.lang.StringUtils.leftPad(current.toString(), 10, "0")); p.setMeterNumber("54" + org.apache.commons.lang.StringUtils.leftPad(current.toString(), 9, "0")); p.setServiceUnit("54"); p.setServiceUnitPhone("54-1234567890"); p.setPowerConsumingCategory("2500"); p.setSubscriberSegmentation("S2"); } sessionFactory.getCurrentSession().saveOrUpdate(p); sessionFactory.getCurrentSession().saveOrUpdate(t); } @Override public void save(PembayaranPascabayar pembayaranPascabayar) { if (pembayaranPascabayar.getTagihanPascabayar().getLunas()) { throw new IllegalStateException("Sudah Lunas"); } pembayaranPascabayar.getTagihanPascabayar().setLunas(true); sessionFactory.getCurrentSession().saveOrUpdate(pembayaranPascabayar.getTagihanPascabayar()); sessionFactory.getCurrentSession().saveOrUpdate(pembayaranPascabayar); } @Override public void delete(PembayaranPascabayar pembayaranPascabayar) { if (pembayaranPascabayar == null || !StringUtils.hasText(pembayaranPascabayar.getId())) return; sessionFactory.getCurrentSession().delete(pembayaranPascabayar); } @SuppressWarnings("unchecked") @Override public List<PembayaranPascabayar> findPembayaranPascabayar(Date tanggal, String switcher) { if (tanggal == null || !StringUtils.hasText(switcher)) return new ArrayList<PembayaranPascabayar>(); return sessionFactory.getCurrentSession().createQuery( "from PembayaranPascabayar p where p.tanggalTransaksi = :tanggal and p.switcher = :switcher order by p.waktuTransaksi") .setDate("tanggal", tanggal).setString("switcher", switcher.trim()).list(); } @Override public void save(TagihanNontaglis tagihanNontaglis) { sessionFactory.getCurrentSession().saveOrUpdate(tagihanNontaglis); } @Override public void delete(TagihanNontaglis tagihanNontaglis) { if (tagihanNontaglis == null || !StringUtils.hasText(tagihanNontaglis.getId())) return; sessionFactory.getCurrentSession().delete(tagihanNontaglis); } @Override public TagihanNontaglis findTagihanNontaglis(String regnum) { if (!StringUtils.hasText(regnum)) return null; return (TagihanNontaglis) sessionFactory.getCurrentSession() .createQuery("from TagihanNontaglis where registrationNumber = :regnum") .setString("regnum", regnum.trim()).uniqueResult(); } @Override public void save(TagihanNontaglisDetail tagihanNontaglisDetail) { sessionFactory.getCurrentSession().saveOrUpdate(tagihanNontaglisDetail); } @Override public void delete(TagihanNontaglisDetail tagihanNontaglisDetail) { // TODO Auto-generated method stub } @Override public List<TagihanNontaglisDetail> findAllTagihanNontaglisDetail() { return sessionFactory.getCurrentSession().createQuery("from TagihanNontaglisDetail").list(); } }