private String getUpit() { String selStr = "select artikli.cart, artikli.cart1, artikli.bc, artikli.nazart, doki.cpar, doki.datdok, stdoki.kol, stdoki.jm, stdoki.IPRODSP "; // if (fieldSet.getString("SLJED").equalsIgnoreCase("RUC")){ // selStr += "(stdoki.iprodbp-stdoki.inab) as ruc "; // } else if (fieldSet.getString("SLJED").equalsIgnoreCase("POR")){ // selStr += "(stdoki.iprodsp - stdoki.iprodbp) as por "; // } else { // selStr += "stdoki.IPRODSP "; // } String inq; StorageDataSet corgs = hr.restart.zapod.OrgStr.getOrgStr().getOrgstrAndKnjig(fieldSet.getString("CORG")); if (corgs.rowCount() == 0) inq = "1=1"; else if (corgs.rowCount() == 1) inq = "DOKI.CSKL = '" + fieldSet.getString("CORG") + "'"; else inq = "(DOKI.CSKL in " + hr.restart.zapod.OrgStr.getOrgStr().getInQuery(corgs, "DOKI.CSKL") + ") "; hr.restart.baza.Condition oj = hr.restart.baza.Condition.in("DOKI.VRDOK", TypeDoc.araj_docsOJ); String exInClude = "AND ((" + oj + " AND " + inq + ") OR (" + oj.not() + " AND DOKI.CSKL = '" + getCskl() + "')) "; String artikliFilter; if (fieldSet.getString("VRART").equals("") || fieldSet.getString("VRART").equals("X")) artikliFilter = ""; else artikliFilter = " AND ARTIKLI.VRART='" + fieldSet.getString("VRART") + "' "; String carting = ""; if (!rpcart.findCART(podgrupe).equals("")) { carting = " AND " + rpcart.findCART(podgrupe); } String ckupca = ""; if (!getCkup().equals("")) ckupca = "and doki.cpar='" + getCkup() + "' "; selStr += " from doki,stdoki,artikli,partneri WHERE doki.cskl = stdoki.cskl AND doki.vrdok = stdoki.vrdok AND doki.god = stdoki.god " + "AND doki.brdok = stdoki.brdok AND stdoki.cart = artikli.cart AND doki.cpar = partneri.cpar and doki.god='" + hr.restart.robno.Aut.getAut().getKnjigodRobno() + "' AND doki.vrdok not in ('PON','NDO','NKU','RNL','REV','PRV','OTR','INM','INV','IZD','TRE','ZAH') " + exInClude + ckupca + artikliFilter + carting + " order by datdok"; // REMARK!! // nešto što sam primjetio, a moglo bi dobro doæi kad se bude implementirao nabavljaè je da // postoji i CPAR kolona u tablici artikli // i predstavlja dobavljaèa za taj artikl. // System.out.println("\n\n"+selStr+"\n\n"); return selStr; }