1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
<?php
session_start();
$serverName = "192.168.127.107";
$uid = "sa";
$pwd = "m0615315009";
$dbname = "wsinn";
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database"=>$dbname);
$conn = sqlsrv_connect( $serverName, $connectionInfo);
//error_reporting(0);
$date = date("d-m-Y");
$heure = date("H:i");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Template gratuit</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<link href="css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="content">
<div id="top">
<div id="top_ban">
<!-- Texte Titre de la page à modifier -->
<!-- Fin Titre de la page à modifier -->
</div>
</div>
<div id="menu"> BJR   <?php echo $_SESSION["nom"];?>
<?php echo $date ?>   <?php echo $heure ?>
</div>
<div id="menu2">
<ul>
<!-- Texte Menu droit de la page à modifier -->
<li><a href="espace_dpm.php" title=""> Page d'accueil </a></li>
<li><a href="consulter_eta_dpm.php" title="">Consulter données</a></li>
<li><a href="compte_dpm.php" title="">Modifier votre compte</a></li>
<li><a href="authentification.php?deco=1" title="">Se déconnecter</a></li>
</ul>
</div>
<div id="page">
<h1>Resultat de recherche pour pour l'etat de transfert</h1>
</br> </br> </br> </br></br>
<?php
set_time_limit(0);
$req="select * from dbo.Data_Source order by Code_ENTITE";
$params = array();
$options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
$stmt = sqlsrv_query( $conn,$sql, $params, $options);
$num = sqlsrv_num_rows($stmt);
while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
$serverName1 = $row["Adr_IP_Srv"];
$uid1 = $row["Utilisateur"];
$pwd1 = $row["PW"];
$dbname1 = $row["BD"];
$connectionInfo1 = array("UID" => $uid1, "PWD" => $pwd1, "Database"=>$dbname1);
$conn1 = sqlsrv_connect( $serverName1, $connectionInfo1);
$sql="declare @dated as datetime
declare @datef as datetime
set @datef =GETDATE()
SELECT delegation.Code_Entite, delegation.DESIG_HALLE as Designation,
(SELECT Convert (varchar(10),MAX(Etat_Achat.Session_Travail),103) AS Derniere_Date_TR_DPM FROM Etat_Achat INNER JOIN Detail_EAchat ON Etat_Achat.Code_EAchat = Detail_EAchat.Code_EAchat WHERE (Detail_EAchat.transfertDPM = 1)) AS Der_Date_TR_DPM,
(SELECT Convert (varchar(10),MAX(Etat_Achat.Session_Travail),103) AS Derniere_Date_TR_ONP FROM Etat_Achat INNER JOIN Detail_EAchat ON Etat_Achat.Code_EAchat = Detail_EAchat.Code_EAchat WHERE (Detail_EAchat.transfert = 1))as Der_Date_TR_ONP,
(Select Convert (varchar(10),max(date_exploitation),103) from Date_exploitation) as Last_Date_EXP,
(Select COUNT(DATE_EXPLOITATION) as Nbre_Jours from DATE_EXPLOITATION where
DATE_EXPLOITATION > (Select max(Session_travail)
from etat_Achat where Code_EAchat in (Select Code_Eachat from Detail_EAchat where Detail_EAchat.transfertDPM = 1) )) as Nbre_J_Non_TR_DPM,
(Select COUNT(DATE_EXPLOITATION) as Nbre_Jours from DATE_EXPLOITATION where
DATE_EXPLOITATION > (Select max(Session_travail)
from etat_Achat where Code_EAchat in (Select Code_Eachat from Detail_EAchat where Detail_EAchat.transfert = 1) )) as Nbre_J_Non_TR_ONP,
(SELECT GETDATE()) as Date_Req
FROM delegation ";
$stmt1 = sqlsrv_query( $conn1,$sql);
$num1 = sqlsrv_num_rows($stmt1);
while($row1 = sqlsrv_fetch_array($stmt1, SQLSRV_FETCH_ASSOC)){
echo "$row1["Designation"]";
}
}
?>
<br /><br />
</div>
<div id="footer"> Copyright © <a href="index.php">GESTION DE TRACABILITE DES PRODUITS DE LA MER </a> | Designed by| <a href="www.onp.co.ma/">ONP</a> </div>
</div>
</body>
</html> |
