<%@ page contentType="text/html;charset=ISO-8859-1" language="java"%> <%@ page import="java.sql.* ,java.io.* ,java.net.* ,java.sql.Connection ,java.sql.DriverManager ,javax.servlet.ServletException ,javax.servlet.annotation.WebServlet ,javax.servlet.http.HttpServlet ,javax.servlet.http.HttpServletRequest ,javax.servlet.http.HttpServletResponse ,com.dhtmlx.connector.* ,Pak.Session"%> <% String redirectURL; String codeSociete = ""; String codeTiers = ""; String nomTiers = ""; String soldeTiers = ""; String userName = null; String webUser = "false"; String codePersonne = null; String defaultPrinter ; String defaultPrinterA4 ; String codeCaisse = null; String codeCaisse1 = null; String defaultTiers = null; String advancedUi = null; String advancedUiCmd = null; String confirmCmdV = null; String approuveCmdV = null; String reserveCmdV = null; String articlesListShow = null; String updatePrix = null; String updatePrixPlus = null; String updatePrixPlusPlus = null; String updateSiteCmdV = null; String rti = null; String updateArticle = null; // 0 = pas d'access en modification , 1 = gerer les lots, articles associés, conditionnement ; 2 = 1 + Promotion; 3 = 1 + Fabrication; 4 = 3 + 2 ; 5 = 4 + Contrat achat ; 6 = full String acompteCmd = null; String Event_1_Access = null; String Event_2_Access = null; String Event_3_Access = null; String Event_4_Access = null; String Event_5_Access = null; String Event_6_Access = null; String Event_7_Access = null; String Event_10_Access = null; String Event_11_Access = null; String Event_12_Access = null; String codeDepartementProd = null; String codeDepartementLog = null; String codeProduit = ""; String CodeDepartement = ""; String codeDepartementLogistique = ""; String quantiteeMode = ""; String codeSocieteDepot = ""; String Facturer = "0"; String Emise = "0"; String sql = null; String form = null; String codeDocument = ""; String status = "0"; String sitesOptions = ""; String sitesOptionsSelect = ""; String eventCode = "0"; String email = ""; String sqlStr = ""; String query = ""; String usersOptions =""; String BENORISABLE =""; String BENOR =""; String usersOptionsSelect = ""; String usersOptionsSelect2 = ""; String usersOptionsSelect3 = ""; String usersOptionsSelect4 = ""; Connection connection = null; Statement statement = null; ResultSet rs = null; ResultSet rsW = null; Statement statementW = null; String BENORetBENORISABLE =""; %> <% //lire les parametres du Http Request String scheme = request.getScheme(); String serverName = request.getServerName(); int serverPort = request.getServerPort(); String url = scheme + "://" + serverName + ":" + serverPort ; String posStart = ""; if (request.getParameter("posStart") != null){ posStart = request.getParameter("posStart"); }else{ posStart = "0"; } String count = ""; if (request.getParameter("count") != null){ count = request.getParameter("count"); }else{ count = "50"; } //recuperer les parametres du HttpRequest sql = request.getParameter("sql"); userName = request.getParameter("userName"); codeSociete = request.getParameter("codeSociete"); codeDocument = request.getParameter("codeDocument"); codeTiers = request.getParameter("codeTiers"); eventCode = request.getParameter("eventCode"); form = request.getParameter("form"); //Initialiser la session Session uiSession = new Session(); Connection conn = uiSession.openSession(request,response,1); if (codeDocument == null) { codeDocument = ""; } if (conn == null) { redirectURL = url + "/logIn.html"; } else { ResultSet resultSet=null; statement = conn.createStatement(); if (codeDocument == "") { //Initialiser les parametre du user query = "if exists(select userName from usersProfiles where UserName = '" + userName + "') Select UsersProfiles.* , personnels.email,tiers.nom as nomTiers from UsersProfiles inner join personnels on UsersProfiles.codePersonne = personnels.Code " + " left join Tiers on UsersProfiles.defaultClient = Tiers.code " + " where UsersProfiles.codeSociete = '" + codeSociete + "' and personnels.UserName = '" + userName + "'" + "else " + " Select UsersProfiles.* , personnels.email,tiers.nom as nomTiers from UsersProfiles inner join personnels on UsersProfiles.codePersonne = personnels.Code " + " left join Tiers on UsersProfiles.defaultClient = Tiers.code " + " where UsersProfiles.codeSociete = '" + codeSociete + "' and personnels.UserName = 'WebUser'"; //System.out.println(query); resultSet = statement.executeQuery(query ); resultSet.next(); if (resultSet.getString("userName").replace("\\", "/").equals("webUser")) webUser = "true"; defaultPrinter = resultSet.getString("defaultPrinter").replace("\\", "/"); //defaultPrinterA4 = resultSet.getString("defaultPrinterA4").replace("\\", "/"); defaultTiers = resultSet.getString("defaultClient").replace("\\", "/"); nomTiers = resultSet.getString("nomTiers").replace("\\", "/"); advancedUi = resultSet.getString("advencedUi").replace("\\", "/"); soldeTiers = resultSet.getString("soldeTiers"); updateSiteCmdV = resultSet.getString("updateSiteCmdV"); advancedUiCmd = resultSet.getString("advancedUiCmd").replace("\\", "/"); confirmCmdV = resultSet.getString("confirmCmdV").replace("\\", "/"); approuveCmdV = resultSet.getString("approuveCmdV").replace("\\", "/"); reserveCmdV = resultSet.getString("reserveCmdV").replace("\\", "/"); articlesListShow = resultSet.getString("articlesListShow").replace("\\", "/"); updatePrix = resultSet.getString("updatePrix").replace("\\", "/"); updatePrixPlus = resultSet.getString("updatePrixPlus").replace("\\", "/"); updatePrixPlusPlus = resultSet.getString("updatePrixPlusPlus").replace("\\", "/"); updateArticle = resultSet.getString("updateArticle"); codeSocieteDepot = resultSet.getString("CodeDepotS").replace("\\", "/"); codeCaisse = resultSet.getString("codeCaisse").replace("\\", "/"); codeCaisse1 = resultSet.getString("codeCaisse1").replace("\\", "/"); codePersonne = resultSet.getString("codePersonne").replace("\\", "/"); codeProduit = resultSet.getString("codeProduit").replace("\\", "/"); CodeDepartement = resultSet.getString("codeDepartementProd").replace("\\", "/"); codeDepartementLogistique = resultSet.getString("codeDepartementLog").replace("\\", "/"); quantiteeMode = resultSet.getString("quantiteeMode_10").replace("\\", "/"); rti = resultSet.getString("RTI"); Event_1_Access = resultSet.getString("Event_1_Access"); Event_2_Access = resultSet.getString("Event_2_Access"); Event_3_Access = resultSet.getString("Event_3_Access"); Event_4_Access = resultSet.getString("Event_4_Access"); Event_5_Access = resultSet.getString("Event_5_Access"); Event_6_Access = resultSet.getString("Event_6_Access"); Event_7_Access = resultSet.getString("Event_7_Access"); Event_10_Access = resultSet.getString("Event_10_Access"); Event_11_Access = resultSet.getString("Event_11_Access"); Event_12_Access = resultSet.getString("Event_12_Access"); codeDocument = ""; email = resultSet.getString("email"); } else { //Initialiser les parametre du user query = "if exists(select userName from usersProfiles where UserName = '" + userName + "') Select UsersProfiles.* , tiers.nom as nomTiers from UsersProfiles inner join personnels on UsersProfiles.codePersonne = personnels.Code " + " left join Tiers on UsersProfiles.defaultClient = Tiers.code " + " where UsersProfiles.codeSociete = '" + codeSociete + "' and personnels.UserName = '" + userName + "'" + "else " + " Select UsersProfiles.* , tiers.nom as nomTiers from UsersProfiles inner join personnels on UsersProfiles.codePersonne = personnels.Code " + " left join Tiers on UsersProfiles.defaultClient = Tiers.code " + " where UsersProfiles.codeSociete = '" + codeSociete + "' and personnels.UserName = 'WebUser'"; //System.out.println(query); resultSet = statement.executeQuery(query ); resultSet.next(); if (resultSet.getString("userName").replace("\\", "/").equals("webUser")) webUser = "true"; defaultPrinter = resultSet.getString("defaultPrinter").replace("\\", "/"); //defaultPrinterA4 = resultSet.getString("defaultPrinterA4").replace("\\", "/"); defaultTiers = resultSet.getString("defaultClient").replace("\\", "/"); soldeTiers = resultSet.getString("soldeTiers"); updateSiteCmdV = resultSet.getString("updateSiteCmdV"); advancedUi = resultSet.getString("advencedUi").replace("\\", "/"); advancedUiCmd = resultSet.getString("advancedUiCmd").replace("\\", "/"); confirmCmdV = resultSet.getString("confirmCmdV").replace("\\", "/"); approuveCmdV = resultSet.getString("approuveCmdV").replace("\\", "/"); reserveCmdV = resultSet.getString("reserveCmdV").replace("\\", "/"); articlesListShow = resultSet.getString("articlesListShow").replace("\\", "/"); updatePrix = resultSet.getString("updatePrix").replace("\\", "/"); updatePrixPlus = resultSet.getString("updatePrixPlus").replace("\\", "/"); updatePrixPlusPlus = resultSet.getString("updatePrixPlusPlus").replace("\\", "/"); updateArticle = resultSet.getString("updateArticle"); codeSocieteDepot = resultSet.getString("CodeDepotS").replace("\\", "/"); codeCaisse = resultSet.getString("codeCaisse").replace("\\", "/"); codeCaisse1 = resultSet.getString("codeCaisse1").replace("\\", "/"); codePersonne = resultSet.getString("codePersonne").replace("\\", "/"); codeDepartementLogistique = resultSet.getString("codeDepartementLog").replace("\\", "/"); quantiteeMode = resultSet.getString("quantiteeMode_10").replace("\\", "/"); rti = resultSet.getString("RTI"); Event_1_Access = resultSet.getString("Event_1_Access"); Event_2_Access = resultSet.getString("Event_2_Access"); Event_3_Access = resultSet.getString("Event_3_Access"); Event_4_Access = resultSet.getString("Event_4_Access"); Event_5_Access = resultSet.getString("Event_5_Access"); Event_6_Access = resultSet.getString("Event_6_Access"); Event_7_Access = resultSet.getString("Event_7_Access"); Event_10_Access = resultSet.getString("Event_10_Access"); Event_11_Access = resultSet.getString("Event_11_Access"); Event_12_Access = resultSet.getString("Event_12_Access"); email = resultSet.getString("email"); query = "select affaires.eventCode,affaires.codetiers , tiers.nom as NomTiers , affaires.Status " + " from affaires inner join tiers on tiers.code = affaires.codetiers " + " where affaires.Code = '" + codeDocument + "' " ; resultSet = statement.executeQuery(query ); resultSet.next(); //Facturer = resultSet.getString("Facturer"); //Emise = resultSet.getString("Emise"); codeTiers = resultSet.getString("CodeTiers"); eventCode = resultSet.getString("eventCode"); nomTiers = resultSet.getString("nomTiers").replace("\\", "/"); status = resultSet.getString("status"); resultSet.close(); } query = " select sum(Quantite) as 'Totalm³' from articles a " +" inner join ArticlesInstances ai on a.Code=ai.CodeArticle " +" inner join ArticlesLots al on ai.CodeLot=al.code " +" inner join Familles f on f.Code=ai.CodeFamille " +" inner join Productions p on p.Code=ai.CodeProduction " +" inner join ProfilesFabrication pf on pf.Code=p.CodeProfileFabrication " +" inner join ChainesFab cf on cf.code= pf.CodeChaineFab " +" where PS>=10 and ai.Nature=0 and p.ExecStartDate >= '2020-11-15' and p.ExecStartDate <= '2021-11-15' and (cf.code='01BPE2000' or cf.code='10BPE2000') "; resultSet = statement.executeQuery(query); if (resultSet != null) { while (resultSet.next()) { //usersOptions += " "; usersOptions += resultSet.getString("Totalm³") ; usersOptionsSelect = usersOptions; // " "; } resultSet.close(); //usersOptionsSelect = "" + sitesOptionsSelect + ""; usersOptionsSelect = usersOptions ; } query = " select sum(Quantite) as 'BENORISABLE' from articles a" +" inner join ArticlesInstances ai on a.Code=ai.CodeArticle" +" inner join ArticlesLots al on ai.CodeLot=al.code" +" inner join Familles f on f.Code=ai.CodeFamille" +" inner join Productions p on p.Code=ai.CodeProduction" +" inner join ProfilesFabrication pf on pf.Code=p.CodeProfileFabrication" +" inner join ChainesFab cf on cf.code= pf.CodeChaineFab" +" where ai.codeproduit='BPE' and PS>=10 and ai.Nature=0 and p.ExecStartDate >= '2020-11-15' and p.ExecStartDate <= '2021-11-15' and (cf.code='01BPE2000' or cf.code='10BPE2000') " +" and f.Code not in (" +" 'C12/15 CEM III/A 32,5 N LA'" +" ,'C16/20 CEM I 52,5 N'" +" ,'C16/20 CEM III/A 32,5 N LA'" +" ,'C16/20 CEM III/A 42,5 N LA'" +" ,'C20/25 CEM III/A 32,5 N LA'" +" ,'C20/25 CEM III/A 42,5 N LA'" +" ,'C25/30 CEM I 52,5 N'" +" ,'C25/30 CEM III/A 32,5 N LA'" +" ,'C25/30 CEM III/A 42,5 N LA'" +" ,'C25/30 CEM III/B 42,5 N HSR LA'" +" ,'C30/37 CEM I 52,5 N'" +" ,'C30/37 CEM III/A 32,5 N LA'" +" ,'C30/37 CEM III/A 42,5 N LA'" +" ,'C30/37 CEM III/B 42,5 N HSR LA'" +" ,'C35/45 CEM I 52,5 N'" +" ,'C35/45 CEM III/A 42,5 N LA'" +" ,'C35/45 CEM III/B 42,5 N HSR LA'" +" ,'C40/50 CEM III/A 42,5 N LA'" +" ,'C40/50 CEM III/B 42,5 N HSR LA'" +" ,'C45/55 CEM III/A 42,5 N LA'" +" ,'C45/55 CEM III/B 42,5 N HSR LA')"; resultSet = statement.executeQuery(query); if (resultSet != null) { while (resultSet.next()) { //usersOptions += " "; BENORISABLE += resultSet.getString("BENORISABLE") ; usersOptionsSelect2 += BENORISABLE; // " "; } resultSet.close(); //usersOptionsSelect = "" + sitesOptionsSelect + ""; usersOptionsSelect2 = BENORISABLE ; } query = " select sum(Quantite) as 'BENOR' from articles a" +" inner join ArticlesInstances ai on a.Code=ai.CodeArticle" +" inner join ArticlesLots al on ai.CodeLot=al.code" +" inner join Familles f on f.Code=ai.CodeFamille" +" inner join Productions p on p.Code=ai.CodeProduction" +" inner join ProfilesFabrication pf on pf.Code=p.CodeProfileFabrication" +" inner join ChainesFab cf on cf.code= pf.CodeChaineFab" +" where ai.codeproduit='BPE' and PS>=10 and ai.Nature=0 and p.ExecStartDate >= '2020-11-15' and p.ExecStartDate <= '2021-11-15' and (cf.code='01BPE2000' or cf.code='10BPE2000') " +" and (ai.CodeTeinte='S' or ai.CodeTeinte='D')"; resultSet = statement.executeQuery(query); if (resultSet != null) { while (resultSet.next()) { //usersOptions += " "; BENOR += resultSet.getString("BENOR") ; usersOptionsSelect3 += BENOR ; // " "; } resultSet.close(); //usersOptionsSelect = "" + sitesOptionsSelect + ""; usersOptionsSelect3 = BENOR ; } ///BENORetBENORISABLE = Integer.parseInt(BENORetBENORISABLE); //BENORetBENORISABLE = Integer.parseInt(BENOR) ; //BENORetBENORISABLE += Integer.parseInt(BENORISABLE) ; //usersOptionsSelect4 = BENORetBENORISABLE ; } %> Flattern - Flat and trendy bootstrap site template
  • Nous sommes disponible pour toutes questions
  • Rue Wauters 152, 7181 Familleureux
  • Appelez nous +32 64 239 540

Plus de 2000 projets réalisés avec nos produits

Qualité

Lorem ipsum dolor sit amet, has ei ipsum scaevola deseruisse am sea facilisis.

Plus...
Services

Lorem ipsum dolor sit amet, has ei ipsum scaevola deseruisse am sea facilisis.

Plus...
Conseils

Lorem ipsum dolor sit amet, has ei ipsum scaevola deseruisse am sea facilisis.

Plus...
Suivi

Lorem ipsum dolor sit amet, has ei ipsum scaevola deseruisse am sea facilisis.

Plus...

News Roosens

fait avec les produits roosens

Very satisfied clients