public static void calcSklad(QueryDataSet stavka, StorageDataSet stanje) { if (!hr.restart .util .lookupData .getlookupData() .raLocate(stanje, "CART", stavka.getInt("CART") + "")) { System.err.println("OOOPS:: nisam nasao stanje za cart = " + stavka.getInt("CART")); return; } LinkClass lc = LinkClass.getLinkClass(); raKalkulBDDoc rKBD = new raKalkulBDDoc(); rKBD.setVrzal(stanje.getString("CSKL")); rKBD.setWhat_kind_of_document("IZD"); rKBD.mode = 'N'; // System.out.println("STANJE :: "+stanje); // stavka.setBigDecimal("ZC",stanje.getBigDecimal("ZC")); // stavka.setBigDecimal("NC",stanje.getBigDecimal("NC")); // stavka.setBigDecimal("VC",stanje.getBigDecimal("VC")); // stavka.setBigDecimal("MC",stanje.getBigDecimal("MC")); // stavka.post(); lc.TransferFromDB2Class(stavka, rKBD.stavka); lc.TransferFromDB2Class(stanje, rKBD.stanje); // System.out.println("prije "+rKBD.stavka); rKBD.kalkSkladPart(); // System.out.println("poslije kalkSkladPart "+rKBD.stavka); rKBD.KalkulacijaStanje(stavka.getString("VRDOK")); // System.out.println("poslije KalkulacijaStanje"+rKBD.stavka); lc.TransferFromClass2DB(stanje, rKBD.stanje); lc.TransferFromClass2DB(stavka, rKBD.stavka); }
public void firstESC() { // jbChart.setVisible(false); if (doubleClicked) { doubleClicked = false; this.killAllReports(); this.addReport( "hr.restart.robno.repStatsMonths", "hr.restart.robno.repStatsMonths", "StatsMonths", "bla bla bla"); jpKup.setCpar(""); changeIcon(1); monthSet = monthSetCache; if (fieldSet.getString("SLJED").equals("CPAR")) { monthSet.setSort(new SortDescriptor(new String[] {fieldSet.getString("SLJED")})); } else monthSet.setSort( new SortDescriptor(new String[] {fieldSet.getString("SLJED")}, true, true)); setDataSetAndSums( monthSet, new String[] { "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "UKUPNO" }); } else super.firstESC(); }
public int getPJ(int cpar) { QueryDataSet qds = new QueryDataSet(); String qStr = "select max(pj) as PJ from pjpar where cpar = " + cpar; Aus.refilter(qds, qStr); if (qds.getRowCount() > 0) return qds.getInt("PJ"); return 0; }
public void prepareVtPred(String cradnal, int rbsrn, boolean single) { sds = new StorageDataSet(); sds.setColumns(dm.getVTPred().cloneColumns()); sds.open(); sds.insertRow(false); initParams(); QueryDataSet materijal = selectIzdatnice(cradnal, rbsrn, single); for (materijal.first(); materijal.inBounds(); materijal.next()) { if (ld.raLocate(dm.getSklad(), "CSKL", materijal.getString("CSKL"))) { if (dm.getSklad().getString("TIPSKL").equalsIgnoreCase("M")) { sds.setBigDecimal( "MAT_I", sds.getBigDecimal("MAT_I").add(materijal.getBigDecimal("IRAZ"))); } else if (dm.getSklad().getString("TIPSKL").equalsIgnoreCase("P")) { sds.setBigDecimal( "PRO_I", sds.getBigDecimal("PRO_I").add(materijal.getBigDecimal("IRAZ"))); } else if (dm.getSklad().getString("TIPSKL").equalsIgnoreCase("R")) { sds.setBigDecimal( "ROB_I", sds.getBigDecimal("ROB_I").add(materijal.getBigDecimal("IRAZ"))); } else if (dm.getSklad().getString("TIPSKL").equalsIgnoreCase("L")) { sds.setBigDecimal( "POL_I", sds.getBigDecimal("POL_I").add(materijal.getBigDecimal("IRAZ"))); } } else { throw new RuntimeException( "Skladište " + materijal.getString("CSKL") + " nisam uspio pronaæi sa raLocate !!! "); } } sds.setBigDecimal("USL_I", iznosTroskovaUsluge(cradnal, rbsrn)); faktorizacija(); }
private void performMatching() { QueryDataSet sks = null, pok = null; Int2 run = new Int2(); String lastcpar = ""; total.clear(); for (int row = 0; row < model.getRowCount(); row++) if (model.isRowSelected(row)) { MatchableCollection mc = (MatchableCollection) model.getValueAt(row, 0); String mkey = mc.getRow(0).getMasterKey(); String cpar = mkey.substring(0, mkey.indexOf('$')); if (!cpar.equals(lastcpar)) { if (sks != null && raTransaction.saveChangesInTransaction(new QueryDataSet[] {sks, pok})) total = total.add(run); run.clear(); sks = dM.getDataModule().getSkstavke(); Skstavke.getDataModule() .setFilter( Aus.getKnjigCond() .and(Aus.getFreeYearCond()) .and(Condition.equal("CPAR", Aus.getNumber(lastcpar = cpar)))); sks.open(); pok = Pokriveni.getDataModule().getFilteredDataSet("1=0"); pok.open(); } PotentialMatch pm = new PotentialMatch(); for (int i = 0; i < mc.getRowCount(); i++) pm.addStavka(mc.getRow(i)); for (int i = 0; i < mc.getMatch().getRowCount(); i++) pm.addStavka(mc.getMatch().getRow(i)); run = run.add(pm.realize(sks, pok)); } if (sks != null && R2Handler.saveChangesInTransaction(new QueryDataSet[] {sks, pok})) total = total.add(run); dM.getDataModule().getSynchronizer().markAsDirty("pokriveni"); }
/** * Pokrece pilot-beanshell skripte za ubacivanje podataka iz stranih baza Potrebno je prijaviti * reportext sa NASLOVOM kao naziv klase za knjizenje, te aplikacijum sisfun npr. IME=1, * NASLOV=hr.restart.robno.frmKnjRobno, URL=robnoloader.sql, APP=sisfun i sve skripte sa tim * naslovom ce se izvrsiti prije validacija() metode u NASLOV klasi sortirane by IME (pazi string * sort!) * * @return */ private boolean runPreloader() { try { String cname = this.getClass().getName(); // executeReport(java.net.URL rep, String title, Window owner) QueryDataSet preloaders = Reportext.getDataModule() .getFilteredDataSet( Condition.whereAllEqual( new String[] {"NASLOV", "APP"}, new String[] {cname, "sisfun"})); preloaders.open(); if (preloaders.getRowCount() == 0) return true; preloaders.setSort(new SortDescriptor("IME")); for (preloaders.first(); preloaders.inBounds(); preloaders.next()) { // // raPilot.executeReport(Aus.findFileAnywhere(preloaders.getString("URL")).toURL(),cname, // this ); Interpreter interpreter = new Interpreter(); Object ret = interpreter.eval( FileHandler.readFile( Aus.findFileAnywhere(preloaders.getString("URL")).getAbsolutePath())); return ((Boolean) ret).booleanValue(); } } catch (Exception e) { e.printStackTrace(); return false; } return true; }
// public raFilterPj() {} public QueryDataSet getClone(String uvijetS) { int uvijet = -1; hr.restart.baza.dM dm = hr.restart.baza.dM.getDataModule(); try { uvijet = Integer.parseInt(uvijetS); } catch (Exception e) { uvijet = -1; } QueryDataSet za_vratiti = hr.restart.util.Util.getNewQueryDataSet(aSS.getQuery4rFP4getClone(uvijet), false); za_vratiti.close(); za_vratiti.setColumns(dm.getPjpar().cloneColumns()); za_vratiti.open(); /* za_vratiti.setQuery(new QueryDescriptor(dm.getDatabase1(), aSS.getQuery4rFP4getClone(uvijet))); za_vratiti.open(); za_vratiti.interactiveLocate(String.valueOf("1"),"PJ",com.borland.dx.dataset.Locate.FIRST,true); */ return za_vratiti; }
public File getAttachment() { File dir = new File(System.getProperty("user.dir") + File.separator + "dumps"); if (dir.exists() && !dir.isDirectory()) dir.delete(); if (!dir.exists()) dir.mkdir(); QueryDataSet knjs = Orgstruktura.getDataModule().getKnjig(); knjs.open(); lookupData.getlookupData().raLocate(knjs, "CORG", OrgStr.getKNJCORG()); String prefix = getMailProperties().getProperty("dump.name", knjs.getString("NAZIV")); String dumpFileName = dir.getAbsolutePath() + File.separator + prefix + "-dbdump-" + new java.sql.Date(System.currentTimeMillis()) + ".zi_"; File plainDumpFile = new File(dumpFileName + "__plain.tmp"); File dumpFile = new File(dumpFileName); raDbaseCreator.dumpTo(plainDumpFile); DesEncrypter enc = new DesEncrypter(getFrom()); enc.encrypt(plainDumpFile, dumpFile); return dumpFile; }
public String getKnjHpBroj() { return knjig.getString("HPBROJ"); }
public String getKnjAdresa() { return knjig.getString("ADRESA"); }
public String getKnjNaziv() { return knjig.getString("NAZIV"); }
private void makeRepSet(QueryDataSet obrada, QueryDataSet arhiva) { repSet = new StorageDataSet(); repSet.setColumns(obrada.cloneColumns()); repSet.open(); repSet.insertRow(false); repSet.setBigDecimal( "SATI", (obrada.getBigDecimal("SATI").add(arhiva.getBigDecimal("SATI"))) .setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); // dadd repSet.setBigDecimal( "BRUTO", (obrada.getBigDecimal("BRUTO") /*.add(arhiva.getBigDecimal("BRUTO"))*/) .setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); repSet.setBigDecimal( "NETO", (obrada.getBigDecimal("NETO").add(arhiva.getBigDecimal("NETO"))) .setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); // dadd repSet.setBigDecimal( "DOPRINOSI", (obrada.getBigDecimal("DOPRINOSI").add(arhiva.getBigDecimal("DOPRINOSI"))) .setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); repSet.setBigDecimal( "NETO2", (obrada.getBigDecimal("NETO2").add(arhiva.getBigDecimal("NETO2"))) .setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); repSet.setBigDecimal( "PORIPRIR", (obrada.getBigDecimal("PORIPRIR").add(arhiva.getBigDecimal("PORIPRIR"))) .setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); // System.out.println(obrada.getBigDecimal("BMIN") + " // obrada.getBigDecimal(\"BMIN\").compareTo(arhiva.getBigDecimal(\"BMIN\")) >= 0 "+ // arhiva.getBigDecimal("BMIN")+ " ; " + // (obrada.getBigDecimal("BMIN").compareTo(arhiva.getBigDecimal("BMIN")) >= 0)); // System.out.println("arhiva.getBigDecimal(\"BMIN\").compareTo(new // java.math.BigDecimal(\"0.00\")) != 0 " + (arhiva.getBigDecimal("BMIN").compareTo(new // java.math.BigDecimal("0.00")) != 0)); if (obrada.getBigDecimal("BMIN").compareTo(arhiva.getBigDecimal("BMIN")) <= 0 && arhiva.getBigDecimal("BMIN").compareTo(new java.math.BigDecimal("0.00")) != 0) { // System.out.println("obrada nema redova ili obrada manja oda arhive i arhiva nije // nula"); repSet.setBigDecimal( "BMIN", arhiva.getBigDecimal("BMIN").setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); } else { // System.out.println("nesto ne stima!!! ili ???"); repSet.setBigDecimal( "BMIN", obrada.getBigDecimal("BMIN").setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); } if (obrada.getBigDecimal("BMAX").compareTo(arhiva.getBigDecimal("BMAX")) >= 0) { repSet.setBigDecimal( "BMAX", obrada.getBigDecimal("BMAX").setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); maxBrutoTableName = "kumulrad"; primanjaBrutoTableName = "primanjaobr"; pomocnaBrut = "orgpl"; } else { repSet.setBigDecimal( "BMAX", arhiva.getBigDecimal("BMAX").setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); maxBrutoTableName = "kumulradarh"; primanjaBrutoTableName = "primanjaarh"; pomocnaBrut = "Kumulorgarh"; } if (obrada.getBigDecimal("NMIN").compareTo(arhiva.getBigDecimal("NMIN")) <= 0 && arhiva.getBigDecimal("NMIN").compareTo(new java.math.BigDecimal("0")) != 0) { repSet.setBigDecimal( "NMIN", arhiva.getBigDecimal("NMIN").setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); } else { repSet.setBigDecimal( "NMIN", obrada.getBigDecimal("NMIN").setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); } if (obrada.getBigDecimal("NMAX").compareTo(arhiva.getBigDecimal("NMAX")) >= 0) { repSet.setBigDecimal( "NMAX", obrada.getBigDecimal("NMAX").setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); maxNetoTableName = "kumulrad"; primanjaNetoTableName = "primanjaobr"; pomocnaNet = "orgpl"; } else { repSet.setBigDecimal( "NMAX", arhiva.getBigDecimal("NMAX").setScale(0, java.math.BigDecimal.ROUND_HALF_UP)); maxNetoTableName = "kumulradarh"; primanjaNetoTableName = "primanjaarh"; pomocnaNet = "Kumulorgarh"; } }
private void maxBN() { // java.sql.Timestamp _od, java.sql.Timestamp _do) { // System.out.println("od " + _od); // System.out.println("do " + _do); String qst3Sub1 = "", qst4Sub1 = ""; if (maxBrutoTableName.equals("kumulradarh")) { qst3Sub1 = "SELECT max(primanjaarh.bruto) as bruto FROM primanjaarh, Kumulorgarh " + "WHERE cradnik in ( " + "SELECT cradnik FROM kumulradarh WHERE bruto = ( " + "SELECT max(kumulradarh.bruto) " + "FROM kumulradarh, Kumulorgarh " + "WHERE kumulradarh.godobr = kumulorgarh.godobr " + "AND kumulradarh.mjobr = kumulorgarh.mjobr " + "AND kumulradarh.rbrobr = kumulorgarh.rbrobr " + "AND kumulradarh.cvro = kumulorgarh.cvro " + "AND kumulradarh.corg = kumulorgarh.corg " + "AND kumulorgarh.datumispl between '" + _od + "' " + "AND '" + _do + "' " + ") group by cradnik) " + "AND primanjaarh.godobr = kumulorgarh.godobr " + "AND primanjaarh.mjobr = kumulorgarh.mjobr " + "AND primanjaarh.rbrobr = kumulorgarh.rbrobr " + "AND primanjaarh.corg = kumulorgarh.corg " + "AND kumulorgarh.datumispl between '" + _od + "' " + " AND '" + _do + "'"; qst4Sub1 = "SELECT max(primanjaarh.neto) as neto FROM primanjaarh, Kumulorgarh " + "WHERE cradnik in ( " + "SELECT cradnik FROM kumulradarh WHERE netopk = ( " + "SELECT max(kumulradarh.netopk) " + "FROM kumulradarh, Kumulorgarh " + "WHERE kumulradarh.godobr = kumulorgarh.godobr " + "AND kumulradarh.mjobr = kumulorgarh.mjobr " + "AND kumulradarh.rbrobr = kumulorgarh.rbrobr " + "AND kumulradarh.cvro = kumulorgarh.cvro " + "AND kumulradarh.corg = kumulorgarh.corg " + "AND kumulorgarh.datumispl between '" + _od + "' " + "AND '" + _do + "' " + ")) " + "AND primanjaarh.godobr = kumulorgarh.godobr " + "AND primanjaarh.mjobr = kumulorgarh.mjobr " + "AND primanjaarh.rbrobr = kumulorgarh.rbrobr " + "AND primanjaarh.corg = kumulorgarh.corg " + "AND kumulorgarh.datumispl between '" + _od + "' " + " AND '" + _do + "'"; } else { qst3Sub1 = "SELECT max(primanjaobr.bruto) as bruto FROM Primanjaobr, Orgpl " + "WHERE primanjaobr.corg = orgpl.corg " + "AND Orgpl.datumispl between '" + _od + "' " + "AND '" + _do + "' "; qst4Sub1 = "SELECT max(primanjaobr.neto) as neto FROM Primanjaobr, Orgpl " + "WHERE primanjaobr.corg = orgpl.corg " + "AND Orgpl.datumispl between '" + _od + "' " + "AND '" + _do + "' "; } String qst3 = qst3Sub1; String qst4 = qst4Sub1; if (!raIzvjestaji.getPrimanjaWhQueryIzv(raIzvjestaji.ID_020).equals("")) { qst3 = qst3.concat(" and not ".concat(raIzvjestaji.getPrimanjaWhQueryIzv(raIzvjestaji.ID_020))); qst4 = qst4.concat(" and not ".concat(raIzvjestaji.getPrimanjaWhQueryIzv(raIzvjestaji.ID_020))); } if (!raIzvjestaji.getPrimanjaWhQueryIzv(raIzvjestaji.ID_030).equals("")) { qst3 = qst3.concat(" and not ".concat(raIzvjestaji.getPrimanjaWhQueryIzv(raIzvjestaji.ID_030))); qst4 = qst4.concat(" and not ".concat(raIzvjestaji.getPrimanjaWhQueryIzv(raIzvjestaji.ID_030))); } if (!raIzvjestaji.getPrimanjaWhQueryIzv(raIzvjestaji.ID_040).equals("")) { qst3 = qst3.concat(" and not ".concat(raIzvjestaji.getPrimanjaWhQueryIzv(raIzvjestaji.ID_040))); qst4 = qst4.concat(" and not ".concat(raIzvjestaji.getPrimanjaWhQueryIzv(raIzvjestaji.ID_040))); } if (!raIzvjestaji.getPrimanjaWhQueryIzv(raIzvjestaji.ID_050).equals("")) { qst3 = qst3.concat(" and not ".concat(raIzvjestaji.getPrimanjaWhQueryIzv(raIzvjestaji.ID_050))); qst4 = qst4.concat(" and not ".concat(raIzvjestaji.getPrimanjaWhQueryIzv(raIzvjestaji.ID_050))); } System.out.println("\nqst3 - " + qst3); System.out.println("\nqst4 - " + qst4 + "\n"); QueryDataSet brut02QDS = Util.getNewQueryDataSet(qst3); QueryDataSet neto02QDS = Util.getNewQueryDataSet(qst4); bruto10 = brut02QDS.getBigDecimal("BRUTO").setScale(0, java.math.BigDecimal.ROUND_HALF_UP); neto12 = neto02QDS.getBigDecimal("NETO").setScale(0, java.math.BigDecimal.ROUND_HALF_UP); // System.out.println("\nbruto10 : " + bruto10); // System.out.println("neto12 : " + neto12); }
public String getKnjMatbroj() { return knjig.getString("MATBROJ"); }
protected void racunica(QueryDataSet tmpSet) { String misec; tmpSet.first(); if (getCkup().equalsIgnoreCase("")) { this.killAllReports(); this.addReport( "hr.restart.robno.repStatsMonths", "hr.restart.robno.repStatsMonths", "StatsMonths", "bla bla bla"); do { misec = tmpSet.getTimestamp("DATDOK").toString().substring(5, 7); if (!lookupData.getlookupData().raLocate(monthSet, "CPAR", tmpSet.getInt("CPAR") + "")) { monthSet.insertRow(false); monthSet.setInt("CPAR", tmpSet.getInt("CPAR")); monthSet.setBigDecimal(misec, tmpSet.getBigDecimal("IPRODSP")); monthSet.setBigDecimal("UKUPNO", tmpSet.getBigDecimal("IPRODSP")); } else { monthSet.setBigDecimal( misec, monthSet.getBigDecimal(misec).add(tmpSet.getBigDecimal("IPRODSP"))); monthSet.setBigDecimal( "UKUPNO", monthSet.getBigDecimal("UKUPNO").add(tmpSet.getBigDecimal("IPRODSP"))); } } while (tmpSet.next()); monthSet.getColumn("CART").setVisible(0); monthSet.getColumn("CART1").setVisible(0); monthSet.getColumn("BC").setVisible(0); monthSet.getColumn("NAZART").setVisible(0); if (fieldSet.getString("SLJED").equals("CPAR")) { monthSet.setSort(new SortDescriptor(new String[] {fieldSet.getString("SLJED")})); } else { monthSet.setSort( new SortDescriptor(new String[] {fieldSet.getString("SLJED")}, true, true)); this.addReport( "hr.restart.robno.RepStatParMonthsChart", "hr.restart.robno.RepStatParMonthsChart", "Top lista kupaca mjeseèno - grafikon"); } } else { this.killAllReports(); this.addReport( "hr.restart.robno.repStatsMonthsArt", "hr.restart.robno.repStatsMonths", "StatsMonthsArt", "bla bla bla"); do { misec = tmpSet.getTimestamp("DATDOK").toString().substring(5, 7); if (!lookupData.getlookupData().raLocate(monthSet, "CART", tmpSet.getInt("CART") + "")) { monthSet.insertRow(false); monthSet.setInt("CART", tmpSet.getInt("CART")); monthSet.setString("CART1", tmpSet.getString("CART1")); monthSet.setString("BC", tmpSet.getString("BC")); monthSet.setString("NAZART", tmpSet.getString("NAZART")); monthSet.setBigDecimal(misec, tmpSet.getBigDecimal("IPRODSP")); monthSet.setBigDecimal("UKUPNO", tmpSet.getBigDecimal("IPRODSP")); } else { monthSet.setBigDecimal( misec, monthSet.getBigDecimal(misec).add(tmpSet.getBigDecimal("IPRODSP"))); monthSet.setBigDecimal( "UKUPNO", monthSet.getBigDecimal("UKUPNO").add(tmpSet.getBigDecimal("IPRODSP"))); } } while (tmpSet.next()); monthSet.getColumn("CART").setVisible(0); monthSet.getColumn("CART1").setVisible(0); monthSet.getColumn("BC").setVisible(0); monthSet.getColumn("CPAR").setVisible(0); monthSet.getColumn(Aut.getAut().getCARTdependable("CART", "CART1", "BC")).setVisible(1); monthSet.setSort(new SortDescriptor(new String[] {"UKUPNO"}, true, true)); } monthSet.first(); dm.getPartneri().open(); String[] mpb = new String[] {"01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12"}; do { for (int i = 0; i < mpb.length; i++) { monthSetGraph.insertRow(false); monthSetGraph.setInt("CPAR", monthSet.getInt("CPAR")); if (lookupData .getlookupData() .raLocate(dm.getPartneri(), "CPAR", monthSet.getInt("CPAR") + "")) { monthSetGraph.setString("NAZPAR", dm.getPartneri().getString("NAZPAR")); } else { monthSetGraph.setString("NAZPAR", ""); } monthSetGraph.setBigDecimal("UKUPNO", monthSet.getBigDecimal("UKUPNO")); monthSetGraph.setString("MJESEC", mpb[i]); monthSetGraph.setBigDecimal("IZNOS", monthSet.getBigDecimal(mpb[i])); } } while (monthSet.next()); monthSetGraph.setSort(new SortDescriptor(new String[] {"UKUPNO", "CPAR"}, true, true)); monthSet.last(); setDataSetAndSums( monthSet, new String[] { "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "UKUPNO" }); }
public void okPress() { // to be changed // jbChart.setVisible(true); String selectString = getUpit(); QueryDataSet tmpSet = ut.getNewQueryDataSet(selectString); if (tmpSet.isEmpty()) setNoDataAndReturnImmediately(); monthSet = new QueryDataSet(); monthSet.setColumns( new Column[] { dm.createIntColumn("CART", "Šifra"), dm.createStringColumn("CART1", "Oznaka", 20), dm.createStringColumn("BC", "Barcode", 20), dm.createStringColumn("NAZART", "Naziv artikla", 50), dm.createIntColumn("CPAR", "Kupac"), dm.createBigDecimalColumn("01", moonshine[0], 2), dm.createBigDecimalColumn("02", moonshine[1], 2), dm.createBigDecimalColumn("03", moonshine[2], 2), dm.createBigDecimalColumn("04", moonshine[3], 2), dm.createBigDecimalColumn("05", moonshine[4], 2), dm.createBigDecimalColumn("06", moonshine[5], 2), dm.createBigDecimalColumn("07", moonshine[6], 2), dm.createBigDecimalColumn("08", moonshine[7], 2), dm.createBigDecimalColumn("09", moonshine[8], 2), dm.createBigDecimalColumn("10", moonshine[9], 2), dm.createBigDecimalColumn("11", moonshine[10], 2), dm.createBigDecimalColumn("12", moonshine[11], 2), dm.createBigDecimalColumn("UKUPNO", "Ukupno", 2) }); monthSetGraph = new QueryDataSet(); monthSetGraph.setColumns( new Column[] { dm.createIntColumn("CPAR", "Kupac"), dm.createStringColumn("NAZPAR", "Naziv partnera", 50), dm.createStringColumn("MJESEC", "Mjesec", 2), dm.createBigDecimalColumn("IZNOS", "Iznos", 2), dm.createBigDecimalColumn("UKUPNO", "Ukupno", 2) }); monthSet.open(); monthSetGraph.open(); tmpSet.first(); String misec; isIspis = true; try { racunica(tmpSet); } catch (Exception ex) { // ex.printStackTrace(); setNoDataAndReturnImmediately(); } monthSet.last(); setDataSetAndSums( monthSet, new String[] { "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "UKUPNO" }); }
public BigDecimal iznosTroskovaUsluge(String cradnal, int rbsrn) { BigDecimal suma = Aus.zero2; QueryDataSet rns = Rnser.getDataModule().getTempSet("cradnal='" + cradnal + "' and rbsid=" + rbsrn); rns.open(); for (rns.first(); rns.inBounds(); rns.next()) { suma = suma.add(rns.getBigDecimal("VRI")); } if (rns.rowCount() == 0) { String selectRN = "select cart,kol from stdoki where cradnal = '" + cradnal + "' and vrdok='RNL' and rbsid=" + rbsrn; QueryDataSet radninalog = hr.restart.util.Util.getNewQueryDataSet(selectRN, true); QueryDataSet normativUs = Aut.getAut().expandArt(radninalog.getInt("CART"), radninalog.getBigDecimal("KOL"), false); for (normativUs.first(); normativUs.inBounds(); normativUs.next()) { if (raVart.isUsluga(normativUs.getInt("CART"))) { // Aut.getAut().artTipa(normativUs.getInt("CART"),"U")) { suma = suma.add(dm.getArtikli().getBigDecimal("NC")) .multiply(normativUs.getBigDecimal("KOL")); } } } return suma; }
public String getKnjMjesto() { return knjig.getString("MJESTO"); }
public String getKnjZiro() { return knjig.getString("ZIRO"); }
private void getIzdFromDosStdoki() { dos_stdoki_sets = new HashSet(); izd_doki = doki.getDataModule().getTempSet(Condition.nil); izd_doki.open(); izd_stdoki = stdoki.getDataModule().getTempSet(Condition.nil); izd_stdoki.open(); dos_doki = doki.getDataModule() .getTempSet( Condition.whereAllEqual( new String[] {"CSKL", "VRDOK", "GOD", "STATUS"}, new String[] {cskl, "DOS", getGodina(), "N"}) .and(Condition.till("DATDOK", getDatumDo())) + " ORDER BY CSKL, VRDOK, GOD, BRDOK"); dos_doki.setMetaDataUpdate( MetaDataUpdate.TABLENAME + MetaDataUpdate.PRECISION + MetaDataUpdate.SCALE + MetaDataUpdate.SEARCHABLE); dos_doki.open(); for (dos_doki.first(); dos_doki.inBounds(); dos_doki.next()) { izd_doki.insertRow(false); dM.copyColumns(dos_doki, izd_doki); // 1 za 1 da ne kompliciramo izd_doki.setString("VRDOK", "IZD"); izd_doki.setInt("BRDOK", brdok); // ************** izd_doki.setTimestamp("DATDOK", getDatumDo()); izd_doki.post(); // hr.restart.robno.Util.getUtil().getBrojDokumenta(izd_doki); izd_doki.post(); dos_doki.setString("STATUS", "P"); // Prenesen? QueryDataSet dos_stdoki = stdoki .getDataModule() .getTempSet( Condition.whereAllEqual( new String[] {"CSKL", "VRDOK", "GOD", "BRDOK"}, dos_doki)); dos_stdoki.open(); for (dos_stdoki.first(); dos_stdoki.inBounds(); dos_stdoki.next()) { izd_stdoki.insertRow(false); dM.copyColumns(dos_stdoki, izd_stdoki); izd_stdoki.setString("VRDOK", "IZD"); izd_stdoki.setInt("BRDOK", izd_doki.getInt("BRDOK")); izd_stdoki.setString("VEZA", dos_stdoki.getString("ID_STAVKA")); // c/p iz raIz* izd_stdoki.setString( "ID_STAVKA", raControlDocs.getKey( izd_stdoki, new String[] {"cskl", "vrdok", "god", "brdok", "rbsid"}, "stdoki")); dos_stdoki.setString("VEZA", izd_stdoki.getString("ID_STAVKA")); izd_stdoki.setString("CSKLART", izd_stdoki.getString("CSKL")); calcSklad(izd_stdoki, qstanje); izd_stdoki.post(); dos_stdoki.post(); // System.out.println(izd_stdoki); } dos_stdoki_sets.add(dos_stdoki); brdok++; } }
public boolean Validacija() { if (!super.Validacija()) return false; rcc.EnabDisabAll(jPanel1, false); fondSati = raIzvjestaji.getFond(fieldSet.getShort("GODINAOD"), fieldSet.getShort("MJESECOD"), true) .satiUk; gomj = fieldSet.getShort("GODINAOD") * 100 + fieldSet.getShort("MJESECOD"); _od = java.sql.Timestamp.valueOf( fieldSet.getShort("GODINAOD") + "-" + fieldSet.getShort("MJESECOD") + "-01 00:00:00.00"); _do = Util.getUtil().getLastSecondOfDay(Util.getUtil().getLastDayOfMonth(_od)); /*java.sql.Timestamp.valueOf(fieldSet.getShort("GODINAOD") + "-" + fieldSet.getShort("MJESECOD") + "-31 23:59:59.99");*/ String qst1 = "select sum(kumulrad.sati) as sati, sum(kumulrad.bruto) as bruto, sum(kumulrad.neto) as neto," + " sum(kumulrad.doprinosi) as doprinosi," + " sum(kumulrad.neto2) as neto2, sum(kumulrad.poriprir) as poriprir," + " min(kumulrad.bruto) as bmin, max(kumulrad.bruto) as bmax, min(kumulrad.netopk) as nmin, " + " max(kumulrad.netopk) as nmax" + " from kumulrad, radnici where radnici.cradnik = kumulrad.cradnik " + // "AND radnici.corg = orgpl.corg " + "AND " + getWhereQuery("radnici"); // +" AND (orgpl.datumispl between '" + _od + "'"+ // " AND '" + _do + "')" ; String qst2 = "select sum(kumulradarh.sati) as sati, sum(kumulradarh.bruto) as bruto, sum(kumulradarh.neto) as neto," + " sum(kumulradarh.doprinosi) as doprinosi," + " sum(kumulradarh.neto2) as neto2, sum(kumulradarh.poriprir) as poriprir," + " min(kumulradarh.bruto) as bmin, max(kumulradarh.bruto) as bmax, min(kumulradarh.netopk) as nmin, " + " max(kumulradarh.netopk) as nmax" + " from kumulradarh, radnici, Kumulorgarh WHERE kumulradarh.cradnik = radnici.cradnik" + " AND kumulradarh.godobr = kumulorgarh.godobr AND kumulradarh.mjobr = kumulorgarh.mjobr" + " AND kumulradarh.rbrobr = kumulorgarh.rbrobr AND kumulradarh.cvro = kumulorgarh.cvro" + " AND kumulradarh.corg = kumulorgarh.corg AND radnici.corg = kumulorgarh.corg AND " + getWhereQuery("radnici") + " AND kumulorgarh.datumispl between '" + _od + "' AND '" + _do + "' "; System.out.println("\nobradaQDS query : " + qst1); System.out.println("\narhivaQDS query : " + qst2 + "\n"); QueryDataSet obradaQDS = Util.getNewQueryDataSet(qst1); QueryDataSet arhivaQDS = Util.getNewQueryDataSet(qst2); makeRepSet(obradaQDS, arhivaQDS); maxBN(); // _od, _do); bruto0 = arhivaQDS.getBigDecimal("BRUTO").setScale(0, java.math.BigDecimal.ROUND_HALF_UP); try { if (frmParam .getParam( "pl", "splbrrad", "F", "SPL: broj radnika se dobiva iz (F)onda sati ili brojanjem (R)adnika") .equalsIgnoreCase("R")) { brojRadnika = calcBrojRadnika(); } else { brojRadnika = repSet.getBigDecimal("SATI").divide(fondSati, 2, java.math.BigDecimal.ROUND_HALF_UP); } } catch (Exception ex) { ex.printStackTrace(); brojRadnika = new java.math.BigDecimal("0"); } return true; }
public void start() { if (getCskl() == null) { raProcess.fail(); throw new IllegalArgumentException("Cskl mora biti postavljen"); } System.out.println("DOStoIZD.start() :: cskl = " + getCskl() + ", datum = " + getDatumDo()); QueryDataSet izd_stdoki_greske = stdoki.getDataModule().getTempSet(Condition.nil); izd_stdoki_greske.open(); msg("Dohvat stanja ..."); qstanje = Stanje.getDataModule() .getTempSet( Condition.whereAllEqual( new String[] {"CSKL", "GOD"}, new String[] {getCskl(), getGodina()})); qstanje.open(); setBrdok(); msg("Obrada dokumenata ..."); getIzdFromDosStdoki(); msg("Provjera kolièina ..."); if (!raIZD.isStanjeExist4allDS(izd_stdoki, izd_stdoki_greske, getGodina(), getCskl(), true)) { JOptionPane.showMessageDialog(null, "Za neke artikle ne postoje zalihe na skladištu."); frmTableDataView dw = new frmTableDataView(false, false); dw.setDataSet(izd_stdoki_greske); dw.setVisibleCols(new int[] {3, 4, 5, 6, 7, 8, 9, 11}); dw.show(); raProcess.fail(); // test // dw = new frmTableDataView(false, false); // dw.setDataSet(izd_stdoki); // dw.show(); } else { msg("Snimanje promjena ..."); // test // test // frmTableDataView dw = new frmTableDataView(false, false); // dw.setDataSet(izd_stdoki); // dw.show(); // // dw = new frmTableDataView(false, false); // dw.setDataSet(izd_doki); // dw.show(); // // dw = new frmTableDataView(false, false); // dw.setDataSet(dos_doki); // dw.show(); // endtest // seq!!!! Valid.getValid().setSeqFilter(seqO); dM.getDataModule().getSeq().setDouble("BROJ", brdok); // raTransaction.saveChangesInTransaction(new QueryDataSet[] { // dos_doki, // izd_doki, // izd_stdoki, // dM.getDataModule().getSeq()}); final QueryDataSet[] qdses = new QueryDataSet[] {dos_doki, izd_doki, izd_stdoki, dM.getDataModule().getSeq()}; new raLocalTransaction() { public boolean transaction() { for (int i = 0; i < qdses.length; i++) { raTransaction.saveChanges(qdses[i]); } for (Iterator iterator = dos_stdoki_sets.iterator(); iterator.hasNext(); ) { QueryDataSet qds = (QueryDataSet) iterator.next(); raTransaction.saveChanges(qds); } return true; } }.execTransaction(); msg("Rekalkulacija stanja"); BatchRekalkulacijaStanja.start(getCskl(), getGodina()); } }