/obras-publicas-v2

Project showing active public works in Mexico

Primary LanguageJavaScriptMIT LicenseMIT

Site Obras Publicas

Available Scripts

In the project directory, you can run:

npm start

Runs the app in the development mode.
Open http://localhost:5000 to view it in the browser.

The page will reload if you make edits.
You will also see any lint errors in the console.

npm build

Generate files for the production environment

npm test

Run tests on project components

API

The application's Api is in Heroku, created with Strapi and using GraphQL.

Consuming the api can be slow, since the free Heroku account is used.

API data is stored in a database in MongoDB Atlas

Queries

Query Cordinacion

query getCordinacion{
  ctCoordinacionRegionals{
    id
    name
  }
}

Query reportes

query getReportes {
  reportes {
    id
    descripcion
    fecha_inicio
    fecha_fin
    porcentaje_avance
    Activo
  }
}

Query reportes - conection

query getrepostesConection{
  reportesConnection{
    values{
      id
      descripcion
      fecha_inicio
      fecha_fin
      porcentaje_avance
      ct_tramo_carretero{
        nombre
      }
      ct_coordinacion_regional{
        name
      }
    }
  }
}

query getrepostesConection{
  reportesConnection(where:{Activo:true}){
    values{
      id
      descripcion
      fecha_inicio
      fecha_fin
      porcentaje_avance
      Activo
      ct_tramo_carretero{
        nombre
      }
      ct_coordinacion_regional{
        name
      }
    }
  }
}

Query reportes - cordination

query getReportCoordination($name: String!) {
  ctCoordinacionRegionals(where: { name: $name }) {
    id
    name
    reportes {
      id
      descripcion
      fecha_inicio
      fecha_fin
      porcentaje_avance
      ct_tramo_carretero {
        nombre
      }
    }
  }
}

Technologies used