Rest API CRUD – Node.js + express + React.js + MySQL Part 5: Edit / Get

Node.js (Backend)

Route

nodebackend/src/routes/EmployeeRoute.js

router.get('/get/:id',EmployeeController.get);

Controller

nodebackend/src/controllers/EmployeeController.js

controllers.get = async (req,res) => {
  const { id } = req.params;
  const data = await Employee.findAll({
      where: { id: id },
      include: [ Role ]
  })
  .then(function(data){
    return data;
  })
  .catch(error =>{
    return error;
  })
  res.json({ success: true, data: data });
}

React.js ( Frontend )

appnode/src/module/list.js

Importar librería de react-router

import { Link } from "react-router-dom";

Botón de editar / Button Edit

<Link class="btn btn-outline-info "  to={"/edit/"+data.id} >Edit</Link>

appnode/src/module/edit.js

Importar librería de axios y variable de baseUrl / Import library axios

import axios from 'axios';
const baseUrl = "http://localhost:3000"

State

  constructor(props){
    super(props);
    this.state = {
      dataEmployee:{},
      campName: "",
      campEmail:"",
      campPhone:"",
      campAddress:"",
      stringRole:"",
      selectRole:0
    }
  }

ComponentDidMount

componentDidMount(){
    let userId = this.props.match.params.id;
    const url = baseUrl+"/employee/get/"+userId
    axios.get(url)
    .then(res=>{
      if (res.data.success) {
        const data = res.data.data[0]
        this.setState({
          dataEmployee:data,
          campName: data.name,
          campEmail:data.email,
          campPhone:data.phone,
          campAddress:data.address,
          stringRole:data.role.role,
          selectRole:data.roleId
        })
        console.log(JSON.stringify(data.role.role))
      }
      else {
        alert("Error web service")
      }
    })
    .catch(error=>{
      alert("Error server "+error)
    })
  }

Render

render(){
   return (
     <div>
       <div class="form-row justify-content-center">
         <div class="form-group col-md-6">
           <label for="inputPassword4">Name</label>
           <input type="text" class="form-control"  placeholder="Name"
             value={this.state.campName} onChange={(value)=> this.setState({campName:value.target.value})}/>
         </div>
         <div class="form-group col-md-6">
           <label for="inputEmail4">Email</label>
           <input type="email" class="form-control"  placeholder="Email"
             value={this.state.campEmail} onChange={(value)=> this.setState({campEmail:value.target.value})}/>
         </div>
       </div>
       <div class="form-row">
         <div class="form-group col-md-6">
           <label for="inputState">Role</label>
           <select id="inputState" class="form-control" onChange={(value)=> this.setState({selectRole:value.target.value})}>
             <option selected value={this.state.dataEmployee.roleId}>{this.state.stringRole}</option>
             <option value="1">Admin</option>
             <option value="2">Project Manager</option>
             <option value="3">Programer</option>
           </select>
         </div>
         <div class="form-group col-md-6">
           <label for="inputEmail4">Phone</label>
           <input type="number" class="form-control"  placeholder="Phone"
             value={this.state.campPhone} onChange={(value)=> this.setState({campPhone:value.target.value})}/>
         </div>
       </div>
       <div class="form-group">
         <label for="inputAddress">Address</label>
         <input type="text" class="form-control" id="inputAddress" placeholder="1234 Main St"
           value={this.state.campAddress} onChange={(value)=> this.setState({campAddress:value.target.value})}/>
       </div> 
       <button type="submit" class="btn btn-primary">Update</button>
     </div>
   );
 }

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *