Ca fait des heure que je cherche et que je ne comprend pas. Ou ces écrit que une information est obligatoire et surtout ou elle va la chercher et la supprimer pour qu'elle ne le sois pas. Peux importe mes essais pour modifier si j'enlève des ligne pour faire en sorte que ca s'enregistre et s'ecrivent dans la table sans que je doivent mettre des informations spécifique. Sois que ca me demande exemple de mettre la compagnie d'alarme ou ca me le demande pas mais quand je click sur sauvegarder ca ne fait simplement rien.
pour le premier code je veux enlever le autosuggest alors n'en tenez pas compte
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218 <?php // Last Modified by: Mike // Date: 2010-03-19 // Description: This code contains the form to add an alarm to the database require_once("scripts/SESSION_CONNECT.php"); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>C.A.D. - Créer une alarme</title> <link rel="stylesheet" href="css/layout.css" type="text/css"/> <link rel="stylesheet" href="autosuggest/css/autosuggest_inquisitor.css" type="text/css" media="screen"/> <script type="text/javascript" language="javascript" src="javascript/functions.js"></script> <script type="text/javascript" language="javascript" src="autosuggest/js/AutoSuggest.js"></script> <script type="text/javascript"> function saveAlarm() { var allClear = validation(); if (allClear) { return true; } else { return false; } } function validation() { if (document.getElementById('alarmCoName_xml').value == "" || document.getElementById('thisHiddenAlarmCoID').value == "") { alert("Veuillez spécifier la compagnie d'alarme!"); document.getElementById('alarmCoName_xml').value = ""; document.getElementById('alarmCoName_xml').focus(); return false; } else if (document.getElementById('clientAddress_xml').value == "" || document.getElementById('thisHiddenClientID').value == "") { alert("Veuillez séléctionez le site!"); document.getElementById('clientAddress_xml').value = ""; document.getElementById('clientAddress_xml').focus(); return false; } else if (document.getElementById('alarmTypeName_xml').value == "" || document.getElementById('thisHiddenAlarmTypeID').value == "") { alert("Veuillez séléctionez le type d'appel!"); document.getElementById('alarmTypeName_xml').value = ""; document.getElementById('alarmTypeName_xml').focus(); return false; } else if (document.getElementById('thisZone').value == "") { alert("Veuillez spécifier la zone sur les lieux!"); document.getElementById('thisZone').focus(); return false; } else if (document.getElementById('thisOPStart').value == "") { alert("Veuillez spécifier le nom de l'opérateur de la compagnie d'alarme!"); return false; document.getElementById('thisOPStart').focus(); } else { document.addAlarmForm.submit(); return true; } } function addAlarmEmptyFields() { document.getElementById('alarmCoName_xml').value = ""; document.getElementById('clientAddress_xml').value = ""; document.getElementById('thisSiteAddress').value = ""; document.getElementById('alarmTypeName_xml').value = ""; document.getElementById('thisZone').value = ""; document.getElementById('thisOPStart').value = ""; //NCR fields document.getElementById('thisMachineID').value = ""; document.getElementById('thisWorkOrder').value = ""; document.getElementById('thisTechnician').value = ""; document.getElementById('thisTechnicianPhoneNumber').value = ""; } function CheckAlarmType(passedValue) { if (passedValue.value == 126) { document.getElementById('thisMachineID').disabled = false; document.getElementById('thisWorkOrder').disabled = false; document.getElementById('thisTechnician').disabled = false; document.getElementById('thisTechnicianPhoneNumber').disabled = false; } else { //Reset the ncr fields because it isn't an NCR alarm document.getElementById('thisMachineID').value = ""; document.getElementById('thisWorkOrder').value = ""; document.getElementById('thisTechnician').value = ""; document.getElementById('thisTechnicianPhoneNumber').value = ""; document.getElementById('thisMachineID').disabled = true; document.getElementById('thisWorkOrder').disabled = true; document.getElementById('thisTechnician').disabled = true; document.getElementById('thisTechnicianPhoneNumber').disabled = true; } } function place() { globalPlace(); updateDateTimeNow(); document.getElementById('alarmCoName_xml').focus(); } </script> </head> <body onload="place()"> <div class="AddHeader1"> <label class="PageTitle">Créer alarme</label> </div> <br /> <form name="addAlarmForm" method="get" action="scripts/addAlarmSave.php"> <table width="98%" border="0" cellpadding="1" cellspacing="1"> <tr> <td><b class="required">*</b>Compagnie d'Alarme:</td> <td><input class="textSize" type="text" id="alarmCoName_xml" name="alarmCoName_xml" onblur="clearHiddenID(this, this.form.thisHiddenAlarmCoID)" tabindex="1" /></td> </tr> <tr> <td><b class="required">*</b>Site:</td> <td><input class="textSize" type="text" id="clientAddress_xml" name="clientAddress_xml" onblur="clearHiddenID(this, this.form.thisHiddenClientID)" tabindex="2" /> <input class="textSize" readonly="readonly" type="text" id="thisSelectedClientName" /></td> </tr> <tr> <td> Addresse:</td> <td align="center"><input style="width:453px;" type="text" tabindex="3" name="thisSiteAddress" id="thisSiteAddress" tabindex="4" /></td> </tr> <tr> <td><b class="required">*</b>Type:</td> <td><input class="textSize" type="text" id="alarmTypeName_xml" name="alarmTypeName_xml" tabindex="4" onblur="CheckAlarmType(this.form.thisHiddenAlarmTypeID);clearHiddenID(this, this.form.thisHiddenAlarmTypeID);" /></td> </tr> <tr> <td><b class="required">*</b>Zone:</td> <td><input class="textSize" type="text" tabindex="5" name="thisZone" id="thisZone" onblur="Upper(this.form.thisZone)" tabindex="5"/></td> </tr> <tr> <td><b class="required">*</b>Opérateur initial:</td> <td><input class="textSize" type="text" tabindex="6" name="thisOPStart" id="thisOPStart" onblur="Upper(this.form.thisOPStart)" tabindex="6"/></td> </tr> <tr> <td> Notes:</td> <td><input class="textSize" type="text" tabindex="7" name="thisAlarmMessage" id="thisAlarmMessage" tabindex="7" /></td> </tr> <tr> <td colspan="2"> </td> </tr> <tr> <td colspan="2" class="td_alarmViewLabel" style="text-align: center;">Champs NCR</td> </tr> <tr> <td colspan="2"> </td> </tr> <tr> <td><b class="required">*</b>MachineID:</td> <td><input class="textSize" type="text" disabled="disabled" tabindex="8" name="thisMachineID" id="thisMachineID" onblur="Upper(this.form.thisMachineID)" tabindex="7"/></td> </tr> <tr> <td><b class="required">*</b>Bon de commande:</td> <td><input class="textSize" type="text" disabled="disabled" tabindex="9" name="thisWorkOrder" id="thisWorkOrder" onblur="Upper(this.form.thisWorkOrder)" tabindex="8"/></td> </tr> <tr> <td><b class="required">*</b>Technicien:</td> <td><input class="textSize" type="text" disabled="disabled" tabindex="10" name="thisTechnician" id="thisTechnician" onblur="Upper(this.form.thisTechnician)" tabindex="9"/></td> </tr> <tr> <td><b class="required">*</b>Téléphone:</td> <td><input class="textSize" type="text" disabled="disabled" tabindex="11" name="thisTechnicianPhoneNumber" id="thisTechnicianPhoneNumber" onblur="Upper(this.form.thisTechnicianPhoneNumber)" tabindex="10"/></td> </tr> </table> <br/> <b class="required"> * Champs obligatoire!</b> <br/> <br/> <a class="MenuButton" href="#" onClick="saveAlarm();return false;" target="_self" tabindex="12">Sauvegarder</a> <a class="MenuButton" href="#" onclick="self.close()" tabindex="13">Annuler / Fermer</a> <a class="MenuButton" href="#" onClick="addAlarmEmptyFields()" tabindex="14">Vider Champs</a> <a class="MenuButton" href="#" onClick="popUp('addClient.php?thisInsertType=quickInsert', 'console', 1024, 768, 'quickAddClientWin');" tabindex="15">Nouveau Client</a> <br/> <br/> <!-- this saves certain values as --> <input type="hidden" name="thisHiddenAlarmCoID" id="thisHiddenAlarmCoID"/> <input type="hidden" name="thisHiddenClientID" id="thisHiddenClientID"/> <input type="hidden" name="thisHiddenAlarmTypeID" id="thisHiddenAlarmTypeID"/> <input type="hidden" name="thisHiddenOriginalSiteAddress" id="thisHiddenOriginalSiteAddress"/> <input type="hidden" name="thisHiddenSelectedSiteStatus" id="thisHiddenSelectedSiteStatus"/> <div class="alarmEditFooter"> <?php include("footer.php"); ?> </div> </form> <script type="text/javascript"> var clientAddress_options_xml = { script: function (input) { return "autosuggest/clientAddress.php?clientAddress_xml="+input+"&siteAsClientID="+document.getElementById('thisHiddenClientID').value; }, callback: function (obj) { document.getElementById('thisHiddenClientID').value = obj.id, document.getElementById('thisSelectedClientName').value = obj.info; }, varname:"input", maxentries: 15 }; var alarmCentralName_options_xml = { script: function (input) { return "autosuggest/alarmCoName.php?alarmCoName_xml="+input+"&alarmCoAsClientID="+document.getElementById('thisHiddenAlarmCoID').value; }, callback: function (obj) { document.getElementById('thisHiddenAlarmCoID').value = obj.id; }, varname:"input" }; var alarmTypeName_options_xml = { script: function (input) { return "autosuggest/alarmTypeName.php?alarmTypeName_xml="+input+"&alarmTypeID="+document.getElementById('thisHiddenAlarmTypeID').value; }, callback: function (obj) { document.getElementById('thisHiddenAlarmTypeID').value = obj.id; }, varname:"input" }; var as_xml = new bsn.AutoSuggest('clientAddress_xml', clientAddress_options_xml); var as_xml = new bsn.AutoSuggest('alarmCoName_xml', alarmCentralName_options_xml); var as_xml = new bsn.AutoSuggest('alarmTypeName_xml', alarmTypeName_options_xml); </script> </body> </html>
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130 <?php // Last Modified by: Mike // Date: 2010-01-12 // Description: This code performs the adding of the alarm to the database require_once 'SESSION_CONNECT.php'; require_once 'functions.php'; $clientAsAlarmCoID = $_REQUEST['thisHiddenAlarmCoID']; $clientID = $_REQUEST['thisHiddenClientID']; $alarmTypeID = $_REQUEST['thisHiddenAlarmTypeID']; $zone = $_REQUEST['thisZone']; $initialOP = $_REQUEST['thisOPStart']; $LogedUserID = $_SESSION['LOGED_USERID']; $siteAddress = $_REQUEST['thisSiteAddress']; $originalSiteAddress = $_REQUEST['thisHiddenOriginalSiteAddress']; $AlarmNote = trim($_REQUEST['thisAlarmMessage']); if ($alarmTypeID == 126) { $machineID = $_REQUEST['thisMachineID']; $workOrder = $_REQUEST['thisWorkOrder']; $technician = $_REQUEST['thisTechnician']; $technicianPhoneNumber = $_REQUEST['thisTechnicianPhoneNumber']; } else { $machineID = NULL; $workOrder = NULL; $technician = NULL; $technicianPhoneNumber = NULL; } //Create a variable with today's date and time $DateTimeNow = date("Y-m-d H:i:s"); $DateNow = date("Y-m-d"); $TimeNow = date("H:i:s"); $suggestedTimeArrived = $TimeNow; //Check how many alarms have been created at the date of save of this current alarm $AlarmNumberSQL = "SELECT alarmCallID FROM alarmCall WHERE alarmCallDateTimeStart LIKE '$DateNow%' AND alarmCallExtID LIKE 'RA%'"; $AlarmNumberResult = mysql_query($AlarmNumberSQL) or die('Query failed[0]: ' . mysql_error()); $AlarmNumberNumOfRows = mysql_num_rows($AlarmNumberResult); if ($AlarmNumberNumOfRows < 9) { $alarmCallExtID = "RA-".$DateNow."-0".($AlarmNumberNumOfRows + 1); } else { $alarmCallExtID = "RA-".$DateNow."-".($AlarmNumberNumOfRows + 1); } //Performing a query to check if alarm already exists $DuplicateCheckSQL = "SELECT alarmCallID FROM alarmCall WHERE clientID = '$clientID' AND alarmCallDateTimeStart = '$DateTimeNow' AND (alarmCall.timeFinished = '' OR alarmCall.timeCancelled = '')"; //echo $DuplicateCheckSQL."<br>"; $DuplicateCheckResult = mysql_query($DuplicateCheckSQL) or die('Query failed[1]: ' . mysql_error()); $DuplicateCheckNumOfRows = mysql_num_rows($DuplicateCheckResult); //echo $DuplicateCheckNumOfRows."<br>"; if ($DuplicateCheckNumOfRows != 0) { echo "ATTENTION: L'alarme a déjà été crée!"; $ActionTime = "2000"; } else { $ActionTime = "500"; // Performing SQL query to add an alarm $insertAlarmSQL = "INSERT INTO alarmCall (clientID, clientAsAlarmCoID, createdByUserID, alarmTypeID, zone, opStart, machineID, workOrder, technician, technicianPhoneNumber, alarmCallDateTimeStart, timeReceived, suggestedTimeArrived, alarmCallExtID) VALUES ('$clientID', '$clientAsAlarmCoID', '$LogedUserID', '$alarmTypeID', '$zone', '$initialOP', '$machineID', '$workOrder', '$technician', '$technicianPhoneNumber', '$DateTimeNow', '$TimeNow', '$suggestedTimeArrived', '$alarmCallExtID')"; echo "Alarme crée avec succés!"; mysql_query($insertAlarmSQL) or die('Query failed[2]: ' . mysql_error()); } if ($AlarmNote != "") { //Get the newly created AlarmCallID and pass it to be used in the saving of the alarmCall Message/Chat $NewlyCreatedAlarmCallID = mysql_insert_id(); InsertIntoAlarmCallChat($LogedUserID, $NewlyCreatedAlarmCallID, $AlarmNote, $DateTimeNow); } //Check if a new address was entered for the site, if yes then update site and email the webmaster with a notification if (($siteAddress != "") && ($siteAddress != $originalSiteAddress)) { $updateSiteSQL = "UPDATE client SET address = '$siteAddress' WHERE clientID = '$clientID'"; mysql_query($updateSiteSQL) or die('Query failed[3]: ' . mysql_error()); $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: CAD@cbina.com" . "\r\n"; $Message = "Ce message est automatique, veuillez ne PAS RÉPONDRE a ce message, il ne sera pas reçu par personne!<br /><br /> L'adresse du site: $SiteName, avec l'addresse: '$originalSiteAddress' a été modifié a '$siteAddress'.<br /><br /> Veuillez vérifier ce changement qui été fait par ".$_SESSION['LNAME'].", ".$_SESSION['FNAME']." et le confirmer, si la nouvelle adresse est correcte, il ya rien a changer, si non il faut éditer le site et remettre la bonne adresse en place."; ini_set("SMTP", "mail.cbina.com"); mail("cad@cbina.com","modification de l'adresse!",$Message, $headers) or die ("Email related error: ".mysql_error()); } /* //Insert an entry in the activities table for the alarm creation $specialComment = "$siteName, $alarmTypeName, $zone, $initialOP"; $insertActivitiesSQL = "INSERT INTO activities (tenCode, dateTimeStamp, userID, activitiesReferenceNumber, comments) VALUES ('401', '$DateTimeNow', '$LogedUserID', '$alarmCallExtID', '$specialComment')"; mysql_query($insertActivitiesSQL) or die('Query failed[3]: ' . mysql_error()); */ // We will free the resultsets... @mysql_free_result($DuplicateCheckResult); //$ActionTime = "00"; // Now we close the connection... mysql_close($connect); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>C.A.D. - Sauvegarde d'alarme</title> <link rel="stylesheet" href="../css/layout.css" type="text/css"/> <script language="javascript" type="text/javascript"> function RefreshAndClose() { window.opener.location.reload(); window.opener.focus(); window.close(); } </script> </head> <body onload="setTimeout('RefreshAndClose()',<?php echo $ActionTime; ?>)"> <br /><br /> <input type="button" value="Fermez" onClick="RefreshAndClose()"/> </body> </html>
Partager