Qualité
Lorem ipsum dolor sit amet, has ei ipsum scaevola deseruisse am sea facilisis.
Plus...%@ 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; // "