Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <tbody>
- <?php foreach($this->metersdataget as $key => $value) { ?>
- <tr id="rowid<?php echo $value->id; ?>">
- <td id="ser_num_val<?php echo $value->id; ?>"><?php echo $value->ser_num; ?></td>
- <td id="meter_brand_val<?php echo $value->id; ?>"><?php echo $value->meter_brand; ?></td>
- <td id="meter_model_val<?php echo $value->id; ?>"><?php echo $value->meter_model; ?></td>
- <td id="meter_version_val<?php echo $value->id; ?>"><?php echo $value->meter_version; ?></td>
- <td id="log_status_name_val<?php echo $value->id; ?>"><?php echo $value->log_status_name; ?></td>
- <td id="last_status_update_val<?php echo $value->id; ?>"><?php echo $value->last_status_update; ?></td>
- <td id="meter_ip_val<?php echo $value->id; ?>"><?php echo $value->meter_ip; ?></td>
- <td id="meter_port_val<?php echo $value->id; ?>"><?php echo $value->meter_port; ?></td>
- <td id="meter_const_val<?php echo $value->id; ?>"><?php echo $value->meter_const; ?></td>
- <td>
- <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>
- <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>
- </td>
- <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>
- </tr>
- <?php } ?>
- </tbody>
- public static function updateMetersdata()// This is my Model
- {
- $database = DatabaseFactory::getFactory()->getConnection();
- if(isset($_POST['edit_row']))
- {
- $row=$_POST['row_id'];
- $ser_num=$_POST['ser_num_val'];
- $meter_brand=$_POST['meter_brand_val'];
- $meter_model=$_POST['meter_model_val'];
- $meter_version=$_POST['meter_version_val'];
- $log_status_name=$_POST['log_status_name_val'];
- $last_status_update=$_POST['last_status_update_val'];
- $meter_ip=$_POST['meter_ip_val'];
- $meter_port=$_POST['meter_port_val'];
- $meter_const=$_POST['meter_const_val'];
- $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'";
- $query = $database->prepare($sql);
- $query->execute();
- echo "success";
- exit();
- }
- }
- function edit_row(id)
- {
- var ser_num=document.getElementById("ser_num_val"+id).innerHTML;
- var meter_brand=document.getElementById("meter_brand_val"+id).innerHTML;
- var meter_model=document.getElementById("meter_model_val"+id).innerHTML;
- var meter_version=document.getElementById("meter_version_val"+id).innerHTML;
- var log_status_name=document.getElementById("log_status_name_val"+id).innerHTML;
- var last_status_update=document.getElementById("last_status_update_val"+id).innerHTML;
- var meter_ip=document.getElementById("meter_ip_val"+id).innerHTML;
- var meter_port=document.getElementById("meter_port_val"+id).innerHTML;
- var meter_const=document.getElementById("meter_const_val"+id).innerHTML;
- document.getElementById("ser_num_val"+id).innerHTML="<input class='edit-input' type='text' id='ser_num_text"+id+"' value='"+ser_num+"'>";
- document.getElementById("meter_brand_val"+id).innerHTML="<input class='edit-input' type='text' id='meter_brand_text"+id+"' value='"+meter_brand+"'>";
- document.getElementById("meter_model_val"+id).innerHTML="<input class='edit-input' type='text' id='meter_model_text"+id+"' value='"+meter_model+"'>";
- document.getElementById("meter_version_val"+id).innerHTML="<input class='edit-input' type='text' id='meter_version_text"+id+"' value='"+meter_version+"'>";
- document.getElementById("log_status_name_val"+id).innerHTML="<select id='log_status_name_text"+id+"'><option>2</option></select>";
- document.getElementById("last_status_update_val"+id).innerHTML="<input class='edit-input' type='text' id='last_status_update_text"+id+"' value='"+last_status_update+"'>";
- document.getElementById("meter_ip_val"+id).innerHTML="<input class='edit-input' type='text' id='meter_ip_text"+id+"' value='"+meter_ip+"'>";
- document.getElementById("meter_port_val"+id).innerHTML="<input class='edit-input' type='text' id='meter_port_text"+id+"' value='"+meter_port+"'>";
- document.getElementById("meter_const_val"+id).innerHTML="<input class='edit-input' type='text' id='meter_const_text"+id+"' value='"+meter_const+"'>";
- document.getElementById("edit_button"+id).style.display="none";
- document.getElementById("save_button"+id).style.display="inline-block";
- }
- function save_row(id)
- {
- var ser_num=document.getElementById("ser_num_text"+id).value;
- var meter_brand=document.getElementById("meter_brand_text"+id).value;
- var meter_model=document.getElementById("meter_model_text"+id).value;
- var meter_version=document.getElementById("meter_version_text"+id).value;
- var log_status_name=document.getElementById("log_status_name_text"+id).value;
- var last_status_update=document.getElementById("last_status_update_text"+id).value;
- var meter_ip=document.getElementById("meter_ip_text"+id).value;
- var meter_port=document.getElementById("meter_port_text"+id).value;
- var meter_const=document.getElementById("meter_const_text"+id).value;
- $.ajax
- ({
- type:'post',
- url:'<?php echo Config::get('URL');?>metersdata/editSave',
- data:{
- edit_row:'edit_row',
- row_id:id,
- ser_num_val:ser_num,
- meter_brand_val:meter_brand,
- meter_model_val:meter_model,
- meter_version_val:meter_version,
- log_status_name_val:log_status_name,
- last_status_update_val:last_status_update,
- meter_ip_val:meter_ip,
- meter_port_val:meter_port,
- meter_const_val:meter_const
- },
- success:function(response) {
- if(response=="success")
- {
- document.getElementById("ser_num_val"+id).innerHTML=ser_num;
- document.getElementById("meter_brand_val"+id).innerHTML=meter_brand;
- document.getElementById("meter_model_val"+id).innerHTML=meter_model;
- document.getElementById("meter_version_val"+id).innerHTML=meter_version;
- document.getElementById("log_status_name_val"+id).innerHTML=log_status_name;
- document.getElementById("last_status_update_val"+id).innerHTML=last_status_update;
- document.getElementById("meter_ip_val"+id).innerHTML=meter_ip;
- document.getElementById("meter_port_val"+id).innerHTML=meter_port;
- document.getElementById("meter_const_val"+id).innerHTML=meter_const;
- document.getElementById("edit_button"+id).style.display="inline-block";
- document.getElementById("save_button"+id).style.display="none";
- }
- }
- });
- }
Add Comment
Please, Sign In to add comment