source: schedule/Module/control.php@ 17475

Last change on this file since 17475 was 17475, checked in by tose, 11 years ago
File size: 17.1 KB
Line 
1<script language="javascript">
2
3 var ctr;
4
5 function clearNode(node){
6 var child = node.childNodes[0];
7 while(child != null)
8 {
9 node.removeChild(child);
10 child = node.childNodes[0];
11 }
12 }
13
14 function addRow(table){
15 var targetView = table;
16 var cctr=$('.dataTable tr').length;
17 ctr=cctr+1;
18 // CREATE ELEMENT
19 var newtr = document.createElement("tr");
20 newtr.setAttribute("class","tr");
21 var newtd_c1 = document.createElement("td");
22 newtd_c1.setAttribute("width","147");
23 newtd_c1.setAttribute("align","center");
24 newtd_c1.appendChild(
25 input_data = document.createElement("input"),
26 input_data.setAttribute("type","time"),
27 input_data.setAttribute("size","10"),
28 input_data.setAttribute("autofocus","true"),
29 input_data.setAttribute("hidden","true")
30 );
31 var newtd_c2 = document.createElement("td");
32 newtd_c2.setAttribute("width","138");
33 newtd_c2.setAttribute("align","center");
34 newtd_c2.appendChild(
35 select = document.createElement("select"),
36 select.setAttribute("class","measure"),
37 $.ajax({ //Retrieving Measurement name and id in Database september 13,2013 modify by Jaypee Tanio
38 type:"post",
39 url:"Transaction/measurement.php",
40 success:function(data){
41 var obj=$.parseJSON(data);
42 $.each(obj,function(){
43 select.appendChild(
44 option = document.createElement("option"),
45 option.setAttribute('value',this['fMeasurementKey']),
46 option.appendChild(document.createTextNode(this['fMeasurement']))
47 )
48 })
49 }
50 }) // End of retrieving
51 );
52 newtd_c2.setAttribute("width","115");
53 newtd_c2.setAttribute("align","center");
54 newtd_c2.appendChild(
55 input_data = document.createElement("input"),
56 input_data.setAttribute("type","button"),
57 input_data.setAttribute("value","+"),
58 input_data.onclick = function(){ return addRow(newtr);
59 ctr++;
60 }
61 );
62 var newtd_c3 = document.createElement("td");
63 newtd_c3.setAttribute("width","98");
64 newtd_c3.setAttribute("align","center");
65 newtd_c3.appendChild(
66 selection = document.createElement("select"),
67 selection.setAttribute("class","source"),
68 $.ajax({ //Retrieving Measurement name and id in Database september 13,2013 modify by Jaypee Tanio
69 type:"post",
70 url:"Transaction/source.php",
71 success:function(data)
72 {
73 var obj = $.parseJSON(data);
74 $.each(obj,function(){
75 selection.appendChild(
76 option=document.createElement('option'),
77 option.setAttribute('value',this['fSourceKEY']),
78 option.appendChild(document.createTextNode(this['fSourceName']))
79 )
80 });
81 }
82 }) // End of retrieving
83 );
84 var newtd_c4 = document.createElement("td");
85 newtd_c4.setAttribute("width","119");
86 newtd_c4.setAttribute("align","center");
87 newtd_c4.appendChild(
88 input_data = document.createElement("input"),
89 input_data.setAttribute("type","text"),
90 input_data.setAttribute("class","selected"),
91 input_data.setAttribute("size","12"),
92 input_data.setAttribute("placeholder","Value")
93 );
94 var newtd_c5 = document.createElement("td");
95 newtd_c5.setAttribute("width","115");
96 newtd_c5.setAttribute("align","center");
97 newtd_c5.appendChild(
98 input_data = document.createElement("input"),
99 input_data.setAttribute("type","button"),
100 input_data.setAttribute("value","Delete"),
101 input_data.onclick = function(){ return clearNode(newtr); }
102 );
103
104 newtr.appendChild(newtd_c2);
105 newtr.appendChild(newtd_c3);
106 newtr.appendChild(newtd_c4);
107 newtr.appendChild(newtd_c5);
108
109 $(targetView).after(newtr);
110 }
111function deleteRow(tableID){
112 try{
113 var table = document.getElementById(tableID);
114 var rowCount = table.rows.length;
115
116 for(var i = 0; i < rowCount; i++){
117 var row = table.rows[i];
118 var chkbox = row.cells[0].childNodes[0];
119 if(null != chkbox && true == chkbox.checked){
120 if(rowCount <= 1){
121 alert("Cannot delete all the rows.");
122 break;
123 }
124 table.deleteRow(i);
125 rowCount--;
126 i--;
127 }
128 }
129 }catch(e){
130 alert(e);
131 }
132 }
133
134<?php
135$cnt=0;
136if(isset($_GET['days']))
137{
138 $day = $_GET['days'];
139}
140else
141{
142 $day =date("Y-m-d");
143}
144
145// $day=$_GET['days'];
146$days = Date('Y-m-d',strtotime($day));
147$prev_time = array();
148?>
149function addRowClone1(nextrow){
150 var targetView = document.getElementById("Data");
151 // CREATE ELEMENT
152 // COUNT LIST
153 var list = $(".datalisting").length;
154 var newlist = list+1;
155 var cctr=$('.dataTable tr').length;
156 ctr=cctr+1;
157 var newdiv = document.createElement("div");
158 newdiv.setAttribute("id","list_"+newlist);
159 newdiv.setAttribute("class","datalisting");
160 newdiv.setAttribute("style","margin:5px 0;");
161 var newtable = document.createElement("table");
162 newtable.setAttribute("class","dataTable");
163 newtable.setAttribute("width","100%");
164 newtable.setAttribute("border","1");
165 newtable.setAttribute("cellspacing","0");
166 newtable.setAttribute("cellpadding","0");
167 var newInnertable = document.createElement("table");
168 newInnertable.setAttribute("class","dataTable");
169 newInnertable.setAttribute("width","100%");
170 newInnertable.setAttribute("border","1");
171
172 newInnertable.setAttribute("cellspacing","0");
173 newInnertable.setAttribute("cellpadding","0");
174
175 var newtr = document.createElement("tr");
176 newtr.setAttribute('class','tr');
177 var newtd_c1 = document.createElement("td");
178 newtd_c1.setAttribute("width","200");
179 newtd_c1.setAttribute("align","center");
180 newtd_c1.appendChild(
181 input_data = document.createElement("input"),
182 input_data.setAttribute("type","time"),
183 input_data.setAttribute("class","time"),
184 input_data.setAttribute("size","10"),
185 input_data.setAttribute("autofocus","true")
186 );
187 newtd_c1.appendChild(
188 input_data = document.createElement("input"),
189 input_data.setAttribute("type","button"),
190 input_data.setAttribute("value","+"),
191 input_data.onclick = function(){
192 addRowClone1("list_"+newlist);
193 }
194 );
195 var newtd_c2 = document.createElement("td");
196
197 newtd_c2.setAttribute("width","138");
198 newtd_c2.setAttribute("align","center");
199 newtd_c2.appendChild(
200 select = document.createElement("select"),
201 select.setAttribute("class","measure"),
202 $.ajax({ //Retrieving Measurement name and id in Database september 13,2013 modify by Jaypee Tanio
203 type:"post",
204 url:"Transaction/measurement.php",
205 success:function(data){
206 var obj=$.parseJSON(data);
207 $.each(obj,function(){
208 select.appendChild(
209 option = document.createElement("option"),
210 option.setAttribute('value',this['fMeasurementKey']),
211 option.appendChild(document.createTextNode(this['fMeasurement']))
212 )
213 })
214
215 }
216 }) // End of retrieving
217
218 );
219 newtd_c2.setAttribute("width","115");
220 newtd_c2.setAttribute("align","center");
221 newtd_c2.appendChild(
222 input_data = document.createElement("input"),
223 input_data.setAttribute("type","button"),
224 input_data.setAttribute("value","+"),
225 input_data.onclick = function(){
226 return addRow(newtr);
227 ctr++;
228 });
229 var newtd_c3 = document.createElement("td");
230 newtd_c3.setAttribute("width","98");
231 newtd_c3.setAttribute("align","center");
232 newtd_c3.appendChild(
233 selection = document.createElement("select"),
234 selection.setAttribute("class","source"),
235 $.ajax({ //Retrieving Measurement name and id in Database september 13,2013 modify by Jaypee Tanio
236 type:"post",
237 url:"Transaction/source.php",
238 success:function(data)
239 {
240 var obj = $.parseJSON(data);
241 $.each(obj,function(){
242 selection.appendChild(
243 option=document.createElement('option'),
244 option.setAttribute('value',this['fSourceKEY']),
245 option.appendChild(document.createTextNode(this['fSourceName']))
246 )
247 });
248 }
249 }) // End of retrieving
250 );
251 var newtd_c4 = document.createElement("td");
252 newtd_c4.setAttribute("width","119");
253 newtd_c4.setAttribute("align","center");
254 newtd_c4.appendChild(
255 input_data = document.createElement("input"),
256 input_data.setAttribute("type","text"),
257 input_data.setAttribute("class","selected"),
258 input_data.setAttribute("size","12"),
259 input_data.setAttribute("placeholder","Value")
260 );
261 var newtd_c5 = document.createElement("td");
262 newtd_c5.setAttribute("width","115");
263 newtd_c5.setAttribute("align","center");
264 newtd_c5.setAttribute("width","115");
265 newtd_c5.setAttribute("align","center");
266 newtd_c5.appendChild(
267 input_data = document.createElement("input"),
268 input_data.setAttribute("type","button"),
269 input_data.setAttribute("value","Delete"),
270 input_data.onclick = function(){ return clearNode(newtr);
271 }
272 );
273 newtr.appendChild(newtd_c2);
274 newtr.appendChild(newtd_c3);
275 newtr.appendChild(newtd_c4);
276 newtr.appendChild(newtd_c5);
277 newInnertable.appendChild(newtr);
278 var newtd_c6 = document.createElement("td");
279 newtd_c6.appendChild(newInnertable);
280
281 var newtd_c7 = document.createElement("td");
282 newtd_c7.setAttribute("width","115");
283 newtd_c7.setAttribute("align","center");
284 newtd_c7.appendChild(
285 input_data = document.createElement("input"),
286 input_data.setAttribute("type","button"),
287 input_data.setAttribute("value","Delete Main"),
288 input_data.onclick = function(){ return clearNode(newdiv); }
289 );
290
291 var newOutertr = document.createElement("tr");
292
293 newtable.appendChild(newtd_c1);
294 newtable.appendChild(newtd_c6);
295 newtable.appendChild(newtd_c7);
296
297 newdiv.appendChild(newtable);
298 if(nextrow != null){
299 var doc = document.getElementById(nextrow);
300 $(doc).after(newdiv);
301 }else{
302 targetView.appendChild(newdiv);
303 }
304}
305
306
307function addRowClone(nextrow){
308<?php
309$fetch = mysql_query("SELECT * FROM schedule WHERE date(fStart) = '$days' ORDER BY fScheduleID ASC, fMeasurementID ASC") or die(mysql_error());
310$observationsCount = mysql_query("SELECT COUNT(DISTINCT fStart) FROM schedule WHERE date(fStart) = '$days'");
311$observationsTime = mysql_query("SELECT DISTINCT fStart FROM schedule WHERE date(fStart) = '$days'");
312
313$cnt3=0;
314$cnt2=0;
315$cnt4 = 0;
316$cnt5 = 0;
317//$data = array();
318//$counter=0;
319$prevtimestamp = 0;
320while($times = mysql_fetch_array($observationsTime))
321{
322 $timestamp=strtotime($times['fStart']);
323 //$actualtime = ($times['fStart'])->format('Y-m-d H:i:s');
324 //$actualtime = $times['fStart'];
325 alert($timestamp);
326 $timestamp2 = date('Y-m-d',$timestamp);
327 $date_time = date('H:i:s',$timestamp);
328 $prev_time[$cnt3]= $date_time;
329?>
330$('#save').attr('value','UPDATE');
331 var targetView = document.getElementById("Data");
332 // CREATE ELEMENT
333 // COUNT LIST
334 var list = $(".datalisting").length;
335 var newlist = list+1;
336
337 var cctr=$('.dataTable tr').length;
338 ctr=cctr+1;
339
340 var newdiv = document.createElement("div");
341 newdiv.setAttribute("id","list_"+newlist);
342 newdiv.setAttribute("class","datalisting");
343 newdiv.setAttribute("style","margin:5px 0;");
344
345 var newtable = document.createElement("table");
346 newtable.setAttribute("class","dataTable");
347 newtable.setAttribute("width","100%");
348 newtable.setAttribute("border","1");
349 newtable.setAttribute("cellspacing","0");
350 newtable.setAttribute("cellpadding","0");
351
352 var newInnertable = document.createElement("table");
353 newInnertable.setAttribute("class","dataTable");
354 newInnertable.setAttribute("width","100%");
355 newInnertable.setAttribute("border","1");
356
357 newInnertable.setAttribute("cellspacing","0");
358 newInnertable.setAttribute("cellpadding","0");
359
360 var newtd_c1 = document.createElement("td");
361 newtd_c1.setAttribute("width","200");
362 newtd_c1.setAttribute("align","center");
363 newtd_c1.appendChild(
364 input_data = document.createElement("input"),
365 input_data.setAttribute("type","time"),
366 input_data.setAttribute("class","time"),
367 input_data.setAttribute("size","10"),
368 input_data.setAttribute("value","<?php echo $date_time; ?>"),
369 input_data.setAttribute("autofocus","true")
370 );
371 newtd_c1.appendChild(
372 input_data = document.createElement("input"),
373 input_data.setAttribute("type","button"),
374 input_data.setAttribute("value","+"),
375 input_data.onclick = function(){
376 addRowClone1("list_<?php echo $cnt+1; ?>");
377 }
378 );
379
380 <?php
381
382 $observations = mysql_query("SELECT * FROM schedule WHERE fStart = '$timestamp'");
383
384 while($rows = mysql_fetch_array($observations))
385 {
386 ?>
387 var newtr<?php echo $cnt; ?> = document.createElement("tr");
388 newtr<?php echo $cnt; ?>.setAttribute('class','tr');
389
390 var newtd_c2 = document.createElement("td");
391 newtd_c2.setAttribute("width","138");
392 newtd_c2.setAttribute("align","center");
393 newtd_c2.appendChild(
394 selection = document.createElement("select"),
395 <?php
396 $selectm = mysql_query("SELECT * FROM measurement");
397 while($rowmeasure = mysql_fetch_array($selectm))
398 {
399 ?>
400 selection.appendChild(
401 option = document.createElement("option"),
402 option.setAttribute("value","<?php echo $rowmeasure['fMeasurementKey']; ?>"),
403 <?php if($rows['fMeasurementTypeKey']==$rowmeasure['fMeasurementKey']){ echo "option.setAttribute('selected',true),";} ?>
404 option.appendChild(document.createTextNode("<?php echo $rowmeasure['fMeasurement']; ?>"))
405 ),
406 <?php
407 }
408 ?>
409
410
411 selection.setAttribute('id','measure'),
412 selection.setAttribute('class','measure')
413 );
414 newtd_c2.setAttribute("width","115");
415 newtd_c2.setAttribute("align","center");
416 newtd_c2.appendChild(
417 input_data = document.createElement("input"),
418 input_data.setAttribute("type","button"),
419 input_data.setAttribute("value","+"),
420 input_data.onclick = function(){
421 return addRow(newtr<?php echo $cnt; ?>);
422 ctr++;
423 });
424 var newtd_c3 = document.createElement("td");
425 newtd_c3.setAttribute("width","98");
426 newtd_c3.setAttribute("align","center");
427 newtd_c3.appendChild(
428 selection = document.createElement("select"),
429 <?php
430 $select = mysql_query("SELECT * FROM source");
431 while($rowsource = mysql_fetch_array($select))
432 {
433 ?>
434 selection.appendChild(
435 option = document.createElement("option"),
436 option.setAttribute('value','<?php echo $rowsource['fSourceKEY']; ?>'),
437 <?php if($rows['fSourceKey'] == $rowsource['fSourceKEY']){ echo "option.setAttribute('selected',true),"; } ?>
438 option.appendChild(document.createTextNode("<?php echo $rowsource['fSourceName']; ?>"))
439 ),
440 <?php
441 }
442 ?>
443
444 selection.setAttribute('id','source'), // End of retrieving
445 selection.setAttribute('class','source') // End of retrieving
446 );
447 var newtd_c4 = document.createElement("td");
448 newtd_c4.setAttribute("width","119");
449 newtd_c4.setAttribute("align","center");
450 newtd_c4.appendChild(
451 input_data = document.createElement("input"),
452 input_data.setAttribute("type","text"),
453 input_data.setAttribute("class","selected"),
454 input_data.setAttribute("size","12"),
455 input_data.setAttribute("value","<?php echo $rows['fData']; ?>"),
456 input_data.setAttribute("placeholder","Value")
457 );
458 var newtd_c5 = document.createElement("td");
459 newtd_c5.setAttribute("width","115");
460 newtd_c5.setAttribute("align","center");
461 newtd_c5.setAttribute("width","115");
462 newtd_c5.setAttribute("align","center");
463 newtd_c5.appendChild(
464 input_data = document.createElement("input"),
465 input_data.setAttribute("type","button"),
466 input_data.setAttribute("value","Delete"),
467 input_data.onclick = function(){ return clearNode(newtr<?php echo $cnt; ?>);
468 }
469 );
470
471 newtr<?php echo $cnt; ?>.appendChild(newtd_c2);
472 newtr<?php echo $cnt; ?>.appendChild(newtd_c3);
473 newtr<?php echo $cnt; ?>.appendChild(newtd_c4);
474 newtr<?php echo $cnt; ?>.appendChild(newtd_c5);
475 newInnertable.appendChild(newtr<?php echo $cnt; ?>);
476 <?php
477 $cnt++;
478 $prevtimestamp = $timestamp;
479 }
480 ?>
481 var newtd_c6 = document.createElement("td");
482 newtd_c6.appendChild(newInnertable);
483
484 var newtd_c7 = document.createElement("td");
485 newtd_c7.setAttribute("width","115");
486 newtd_c7.setAttribute("align","center");
487 newtd_c7.appendChild(
488 input_data = document.createElement("input"),
489 input_data.setAttribute("type","button"),
490 input_data.setAttribute("value","Delete Main"),
491 input_data.onclick = function(){ return clearNode(newdiv); }
492 );
493
494 var newOutertr = document.createElement("tr");
495
496 newtable.appendChild(newtd_c1);
497 newtable.appendChild(newtd_c6);
498 newtable.appendChild(newtd_c7);
499
500 newdiv.appendChild(newtable);
501
502 if(nextrow != null){
503 var doc = document.getElementById(nextrow);
504 $(doc).after(newdiv);
505 } else {
506 targetView.appendChild(newdiv);
507 }
508 <?php
509 }
510
511 if(mysql_num_rows($fetch)<1)
512 {
513 ?>
514 $('#save').attr('value','SAVE');
515 addRowClone1();
516 <?php
517 }
518 ?>
519
520}
521
522 </script>
523
Note: See TracBrowser for help on using the repository browser.