"); tableBuf.append(""); if (prods.size() == 0) { tableBuf.append(""); } else { String height = null; try{ height = flRequest.getContext().getContextParameter("Devis.Thumbnail.Height"); } catch (FrontlineException fex) { height = "50"; } String width = null; try{ width = flRequest.getContext().getContextParameter("Devis.Thumbnail.Width"); } catch (FrontlineException fex) { width = "80"; } tableBuf.append(""); if (!listOnly) { tableBuf.append(""); } tableBuf.append(""); // Product rows boolean doColor = false; for (int cnt = 0; cnt < prods.size(); ++cnt) { Hashtable row = (Hashtable)prods.elementAt(cnt); presenceArt = true; // récup image du produit String imgPrdID = null; imgPrdID = (String)row.get("ProPrdID:PrdPicID"); Double ProPrice = (Double) row.get("ProPrice"); if (ProPrice != null ) { totalPrice += ProPrice.doubleValue(); } Integer ProQuantity = (Integer) row.get("ProQuantity"); Double ProUnitPrice = (Double)row.get("ProUnitPrice"); Double ProMontantHTrem_ = (Double)row.get("ProMontantHTrem_"); Double ProMontantTva_ = (Double)row.get("ProMontantTva_"); Double ProMontantTpf_ = (Double)row.get("ProMontantTpf_"); Double ProUnitHTrem_ = (Double)row.get("ProUnitHTrem_"); try { totalGross += ProQuantity.intValue() * ProUnitPrice.doubleValue(); } catch (NullPointerException e) { } String ProRemise_ =(String)row.get("ProRemise_:Val"); String ProPrdTva_ =(String)row.get("ProPrdTva_:Val"); String ProPrdTva_RefV = (String)row.get("ProPrdTva_"); String codeTVA = ProPrdTva_RefV != null ? dico.getRefCode("ProPrdTva_", ProPrdTva_RefV) : ""; String ProPrdTaxeParafiscale_ =(String)row.get("ProPrdTaxeParafiscale_:Val"); // on additionne les montants de remise de chaque produit if (ProRemise_ != null && ProUnitHTrem_ != null) { Remise = ( ProUnitPrice.doubleValue() - ProUnitHTrem_.doubleValue() ) * ProQuantity ; totalDiscountM += Remise; } // on additionne les montants TVA de chaque produit if (ProMontantTva_ != null ) { totalTVA += ProMontantTva_.doubleValue(); } // on additionne les montants TVA de chaque produit if (ProMontantTpf_ != null ) { totalTPF += ProMontantTpf_.doubleValue(); } // on additionne les montants HT de chaque produit if (ProMontantHTrem_ != null ) { totalHT += ProMontantHTrem_.doubleValue(); } netApayer = totalPrice-acompte; String PrdCode = (String)row.get("ProPrdID:PrdCode"); String PrdDesignation = (String)row.get("ProDesignation"); String prdid = (String)row.get("ProPrdID"); try{ String prdnamelng_ = (String)ProductBean.lookup(context, "PrdNamelng_", prdid); PrdDesignation = (String)dico.getRefDisp(session, "Rd_", "Te1", prdnamelng_); }catch(Exception e){ logger.warn(e.getMessage()); } tableBuf.append(""); if (!listOnly) { tableBuf.append(""); } if (imgPrdID != null) { tableBuf.append(""); } else { tableBuf.append(""); } tableBuf.append(""); doColor = !doColor; } // Total - headers tableBuf.append(""); tableBuf.append(""); if (!listOnly) { tableBuf.append(""); } else { tableBuf.append(""); } tableBuf.append(""); tableBuf.append(""); if (!listOnly) { tableBuf.append(""); } tableBuf.append("

"); tableBuf.append(Utils.getMessage(session, "L0001", true, "Aucune entrée disponible")); tableBuf.append("
	"); tableBuf.append(Utils.getMessage(session, "F600A", true, "Image")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "F2000", true, "Code")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "F203F", true, "Désignation")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "F3023", true, "P. U. HT")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "LF18A", true, "Quantité facturée")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "F3025", true, "Remise sur P.U")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "FF132", true, "P. U. HT Après Remise")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "FF134", true, "Montant HT")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "FF130", true, "TVA à appliquer")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "FF140", true, "Montant TVA")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "FF1F0", true, "TPF à appliquer")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "FF1F1", true, "Montant TPF")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "F3026", true, "Prix net")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "", true, "Code TVA")); tableBuf.append("
"); tableBuf.append("	"); tableBuf.append(""); tableBuf.append("	"); tableBuf.append("	"); if (listOnly) { tableBuf.append(""); } tableBuf.append(PrdCode == null ? " " : Utils.formatToJavascript(PrdCode)); if (listOnly) { tableBuf.append(""); } tableBuf.append("	"); tableBuf.append(PrdDesignation == null ? " " : Utils.formatToJavascript(PrdDesignation)); tableBuf.append("	"); tableBuf.append(ProUnitPrice == null ? " " : unitPriceFormat.format(ProUnitPrice.doubleValue()) + " €"); tableBuf.append("	"); tableBuf.append(ProQuantity == null ? " " : intFormat.format(ProQuantity.intValue())); tableBuf.append("	"); tableBuf.append(ProRemise_ == null ? " " : Utils.formatToJavascript(ProRemise_)); tableBuf.append("	"); tableBuf.append( ProUnitHTrem_== null ? " " : unitPriceFormat.format(ProUnitHTrem_.doubleValue()) + " €"); tableBuf.append("	"); tableBuf.append( ProMontantHTrem_ == null ? " " : unitPriceFormat.format(ProMontantHTrem_.doubleValue()) + " €"); tableBuf.append("	"); tableBuf.append(ProPrdTva_ == null ? " " : Utils.formatToJavascript(ProPrdTva_)); tableBuf.append("	"); tableBuf.append(ProMontantTva_ == null ? " " : unitPriceFormat.format(ProMontantTva_.doubleValue()) + " €"); tableBuf.append("	"); tableBuf.append(ProPrdTaxeParafiscale_ == null ? " " : Utils.formatToJavascript(ProPrdTaxeParafiscale_)); tableBuf.append("	"); tableBuf.append(ProMontantTpf_ == null ? " " : unitPriceFormat.format(ProMontantTpf_.doubleValue()) + " €"); tableBuf.append("	"); tableBuf.append(ProPrice == null ? " " : moneyFormat.format(ProPrice.doubleValue()) + " €"); tableBuf.append("	"); tableBuf.append(ProPrdTva_ == null ? " " : Utils.formatToJavascript(codeTVA)); tableBuf.append("
		"); tableBuf.append(Utils.getMessage(session, "FF13D", true, "Acompte")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "L3041", true, "Remise totale")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "LF18B", true, "Total HT")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "LF18C", true, "Total TVA")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "LF18E", true, "Total TPF")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "LF18D", true, "Total TTC")); tableBuf.append("	"); tableBuf.append(Utils.getMessage(session, "FF13E", true, "NET à Payer")); tableBuf.append("
"); } else { tableBuf.append("	"); } tableBuf.append(Utils.getMessage(session, "F1058", true, "Total") + " : "); tableBuf.append("	"); tableBuf.append(moneyFormat.format(acompte) + " €"); tableBuf.append("	"); tableBuf.append(moneyFormat.format(totalDiscountM) + " €"); tableBuf.append("	"); tableBuf.append(moneyFormat.format(totalHT) + " €"); tableBuf.append("	"); tableBuf.append(moneyFormat.format(totalTVA) + " €"); tableBuf.append("	"); tableBuf.append(moneyFormat.format(totalTPF) + " €"); tableBuf.append("	"); tableBuf.append(moneyFormat.format(totalPrice) + " €"); tableBuf.append("	"); tableBuf.append(moneyFormat.format(netApayer) + " €"); tableBuf.append("

"); try{ opp.setCustomProperty("OppNetApayer_", netApayer); opp.setCustomProperty("OppTotalHT_", totalHT); opp.setCustomProperty("OppTotalTVA_", totalTVA); opp.setCustomProperty("OppTotalTTC_", totalPrice); opp.setCustomProperty("OppTotalTPF_", totalTPF); opp.save(); }catch(AccessDeniedException ae){ }catch(FrontlineException fe){ } %>var f = document.getElementById('ProdOppTable'); f.innerHTML = '<%= tableBuf.toString() %>'; <% if(presenceArt) {%> document.forms[0].presenceArticles.value ='true'; <%}%> try { document.forms[0].total.value = '<%= moneyFormat.format(totalPrice) %>'; document.forms[0].totalHT.value = '<%= moneyFormat.format(totalHT) %>'; document.forms[0].totalTVA.value = '<%= moneyFormat.format(totalTVA) %>'; document.forms[0].totalTPF.value = '<%= moneyFormat.format(totalTPF) %>'; } catch (error) { }