Guest User

Untitled

a guest
Nov 21st, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. public function getCliente($id_contratos_d){
  2. $this->db->select("con.*, plan.*, dom.*, cli.*");
  3. $this->db->where("con.id_contratos_d", "$id_contratos_d");
  4. $this->db->from("contratos con");
  5. $this->db->join("planes_mb plan", "con.plan_id = plan.id_plan_mb");
  6. $this->db->join("domicilios_instalaciones dom", "con.domicilio_instalacion_id = dom.id_domicilio_instalacion");
  7. $this->db->join("clientes cli", "con.cliente_id = cli.id_cliente");
  8. $resultados = $this->db->get("contratos");
  9. return $resultados->row();
  10. }
  11.  
  12. public function update($id_contratos_d, $data){ // Experimento
  13. $this->db->select("contratos.*, clientes.*, planes_mb.*, domicilios_instalaciones.*");
  14. $this->db->where("contratos.id_contratos_d", "$id_contratos_d");
  15. $this->db->from("contratos");
  16. $this->db->join("clientes", "contratos.cliente_id = clientes.id_cliente");
  17. $this->db->join("planes_mb", "contratos.plan_id = planes_mb.id_plan_mb");
  18. $this->db->join("domicilios_instalaciones", "contratos.domicilio_instalacion_id = domicilios_instalaciones.id_domicilio_instalacion");
  19. return $this->db->update("contratos", $data);
  20. }
Add Comment
Please, Sign In to add comment