Guest User

Untitled

a guest
Mar 23rd, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.06 KB | None | 0 0
  1. <tbody>
  2. <?php foreach($this->metersdataget as $key => $value) { ?>
  3. <tr id="rowid<?php echo $value->id; ?>">
  4. <td id="ser_num_val<?php echo $value->id; ?>"><?php echo $value->ser_num; ?></td>
  5. <td id="meter_brand_val<?php echo $value->id; ?>"><?php echo $value->meter_brand; ?></td>
  6. <td id="meter_model_val<?php echo $value->id; ?>"><?php echo $value->meter_model; ?></td>
  7. <td id="meter_version_val<?php echo $value->id; ?>"><?php echo $value->meter_version; ?></td>
  8. <td id="log_status_name_val<?php echo $value->id; ?>"><?php echo $value->log_status_name; ?></td>
  9. <td id="last_status_update_val<?php echo $value->id; ?>"><?php echo $value->last_status_update; ?></td>
  10. <td id="meter_ip_val<?php echo $value->id; ?>"><?php echo $value->meter_ip; ?></td>
  11. <td id="meter_port_val<?php echo $value->id; ?>"><?php echo $value->meter_port; ?></td>
  12. <td id="meter_const_val<?php echo $value->id; ?>"><?php echo $value->meter_const; ?></td>
  13. <td>
  14. <a style="display:none;" class="save_button" id="save_button<?php echo $value->id;?>" onclick="save_row('<?php echo $value->id;?>');"><img style="width:20px; height:20px;" src="<?php echo Config::get('URL'); ?>images/save.png"/></a>
  15. <a class="edit_button" id="edit_button<?php echo $value->id;?>" onclick="edit_row('<?php echo $value->id;?>');"><img style="width:20px; height:20px;" src="<?php echo Config::get('URL'); ?>images/edit.png"/></a>
  16. </td>
  17. <td><a class="delete_button" id="delete_button<?php echo $value->id;?>" onclick="delete_row('<?php echo $value->id;?>');"><img style="width:20px; height:20px;" src="<?php echo Config::get('URL'); ?>images/delete.png"/></a></td>
  18. </tr>
  19. <?php } ?>
  20. </tbody>
  21.  
  22. public static function updateMetersdata()// This is my Model
  23. {
  24. $database = DatabaseFactory::getFactory()->getConnection();
  25. if(isset($_POST['edit_row']))
  26. {
  27. $row=$_POST['row_id'];
  28. $ser_num=$_POST['ser_num_val'];
  29. $meter_brand=$_POST['meter_brand_val'];
  30. $meter_model=$_POST['meter_model_val'];
  31. $meter_version=$_POST['meter_version_val'];
  32. $log_status_name=$_POST['log_status_name_val'];
  33. $last_status_update=$_POST['last_status_update_val'];
  34. $meter_ip=$_POST['meter_ip_val'];
  35. $meter_port=$_POST['meter_port_val'];
  36. $meter_const=$_POST['meter_const_val'];
  37.  
  38. $sql = "UPDATE metersdata SET ser_num = '$ser_num', meter_brand = '$meter_brand', meter_model = '$meter_model', meter_version = '$meter_version', meter_status = '$log_status_name', last_status_update = '$last_status_update', meter_ip = '$meter_ip', meter_port = '$meter_port', meter_const = '$meter_const' WHERE id = '$row'";
  39. $query = $database->prepare($sql);
  40. $query->execute();
  41. echo "success";
  42. exit();
  43. }
  44. }
  45.  
  46. function edit_row(id)
  47. {
  48. var ser_num=document.getElementById("ser_num_val"+id).innerHTML;
  49. var meter_brand=document.getElementById("meter_brand_val"+id).innerHTML;
  50. var meter_model=document.getElementById("meter_model_val"+id).innerHTML;
  51. var meter_version=document.getElementById("meter_version_val"+id).innerHTML;
  52. var log_status_name=document.getElementById("log_status_name_val"+id).innerHTML;
  53. var last_status_update=document.getElementById("last_status_update_val"+id).innerHTML;
  54. var meter_ip=document.getElementById("meter_ip_val"+id).innerHTML;
  55. var meter_port=document.getElementById("meter_port_val"+id).innerHTML;
  56. var meter_const=document.getElementById("meter_const_val"+id).innerHTML;
  57.  
  58. document.getElementById("ser_num_val"+id).innerHTML="<input class='edit-input' type='text' id='ser_num_text"+id+"' value='"+ser_num+"'>";
  59. document.getElementById("meter_brand_val"+id).innerHTML="<input class='edit-input' type='text' id='meter_brand_text"+id+"' value='"+meter_brand+"'>";
  60. document.getElementById("meter_model_val"+id).innerHTML="<input class='edit-input' type='text' id='meter_model_text"+id+"' value='"+meter_model+"'>";
  61. document.getElementById("meter_version_val"+id).innerHTML="<input class='edit-input' type='text' id='meter_version_text"+id+"' value='"+meter_version+"'>";
  62. document.getElementById("log_status_name_val"+id).innerHTML="<select id='log_status_name_text"+id+"'><option>2</option></select>";
  63. document.getElementById("last_status_update_val"+id).innerHTML="<input class='edit-input' type='text' id='last_status_update_text"+id+"' value='"+last_status_update+"'>";
  64. document.getElementById("meter_ip_val"+id).innerHTML="<input class='edit-input' type='text' id='meter_ip_text"+id+"' value='"+meter_ip+"'>";
  65. document.getElementById("meter_port_val"+id).innerHTML="<input class='edit-input' type='text' id='meter_port_text"+id+"' value='"+meter_port+"'>";
  66. document.getElementById("meter_const_val"+id).innerHTML="<input class='edit-input' type='text' id='meter_const_text"+id+"' value='"+meter_const+"'>";
  67.  
  68. document.getElementById("edit_button"+id).style.display="none";
  69. document.getElementById("save_button"+id).style.display="inline-block";
  70. }
  71.  
  72. function save_row(id)
  73. {
  74. var ser_num=document.getElementById("ser_num_text"+id).value;
  75. var meter_brand=document.getElementById("meter_brand_text"+id).value;
  76. var meter_model=document.getElementById("meter_model_text"+id).value;
  77. var meter_version=document.getElementById("meter_version_text"+id).value;
  78. var log_status_name=document.getElementById("log_status_name_text"+id).value;
  79. var last_status_update=document.getElementById("last_status_update_text"+id).value;
  80. var meter_ip=document.getElementById("meter_ip_text"+id).value;
  81. var meter_port=document.getElementById("meter_port_text"+id).value;
  82. var meter_const=document.getElementById("meter_const_text"+id).value;
  83.  
  84.  
  85. $.ajax
  86. ({
  87. type:'post',
  88. url:'<?php echo Config::get('URL');?>metersdata/editSave',
  89. data:{
  90. edit_row:'edit_row',
  91. row_id:id,
  92. ser_num_val:ser_num,
  93. meter_brand_val:meter_brand,
  94. meter_model_val:meter_model,
  95. meter_version_val:meter_version,
  96. log_status_name_val:log_status_name,
  97. last_status_update_val:last_status_update,
  98. meter_ip_val:meter_ip,
  99. meter_port_val:meter_port,
  100. meter_const_val:meter_const
  101. },
  102. success:function(response) {
  103. if(response=="success")
  104. {
  105. document.getElementById("ser_num_val"+id).innerHTML=ser_num;
  106. document.getElementById("meter_brand_val"+id).innerHTML=meter_brand;
  107. document.getElementById("meter_model_val"+id).innerHTML=meter_model;
  108. document.getElementById("meter_version_val"+id).innerHTML=meter_version;
  109. document.getElementById("log_status_name_val"+id).innerHTML=log_status_name;
  110. document.getElementById("last_status_update_val"+id).innerHTML=last_status_update;
  111. document.getElementById("meter_ip_val"+id).innerHTML=meter_ip;
  112. document.getElementById("meter_port_val"+id).innerHTML=meter_port;
  113. document.getElementById("meter_const_val"+id).innerHTML=meter_const;
  114.  
  115. document.getElementById("edit_button"+id).style.display="inline-block";
  116. document.getElementById("save_button"+id).style.display="none";
  117. }
  118. }
  119. });
  120. }
Add Comment
Please, Sign In to add comment