agritech/app.js at master · daofullstack/agritech · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126

require('babel-register')
//var session = require('express-session');
//const {success, error} = require('functions')
//var path = require('path');
const bodyParser = require('body-parser')
const express = require('express')
const mysql = require('mysql')
const morgan = require('morgan')('dev')
const Twig = require('twig'), // Twig module
twig = Twig.twig;       // Render function

// mes var globales
const app = express()
// app.use(session({
// 	secret: 'dao',
// 	resave: true,
// 	saveUninitialized: true
// }));
const port = 8080
var recettes = '';
//var message='';
//var messageinscript='';

// middle
app.use(morgan)
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: true }));
app.use(express.static('views'))

// mon moteur
app.set('view engine' , 'ejs')

// connection info
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : '',
  database : 'alimentation'
});
//debut connection
connection.connect(function(err){
if(!err) {
    console.log("connecté à la base ... ");
// routes
         //pour index
         app.get('/', (req,res)=> {
            res.render(__dirname+'/index.ejs')
         })
         //pour page recette
         app.get('/recette', (req,res)=> {


            connection.query('SELECT * from recettes ORDER BY id DESC LIMIT 10', function(err, rows, fields) {

                if (!err){

                    recettes = rows;
                    res.render(__dirname+'/views/content/recette.ejs',{recettes: recettes});

                }

                else{
                    recettes="impossible de recuperé les recette";
                    res.render(__dirname+'/views/content/recette.ejs',{recettes: recettes});

                }

            })
         })

        // pour les resto
        app.get('/top10', (req,res)=> {

            var restaurants = '';
            connection.query('SELECT * from restaurants ORDER BY id_resto limit 10 ', function(err, rows, fields) {

                if (!err){

                    restaurants = rows;
                    res.render(__dirname+'/views/content/resto.ejs',{restaurants :restaurants})

                }

                else{
                    connection.end();
                    res.render(__dirname+'/views/content/resto.ejs',{restaurants :'mauvaise requette.'})

                }

            });
        })


        // pour engins
        app.get('/enginDispo', (req,res)=> {

            var engins = '';
            connection.query('SELECT * from engins ORDER BY id_engin DESC', function(err, rows, fields) {

                if (!err){

                    engins = rows;
                    res.render(__dirname+'/views/content/enginDispo.ejs',{engins: engins});

                }

                else{
                    connection.end();
                    res.render(__dirname+'/views/content/enginDispo.ejs',{engins: engins});
                    res.json('mauvais requette.');
                }

                });
        })
    } else {
        console.log("Error connecting database ... nn");
    }
});
//fin de ma connect

//ecoute de port
app.listen( port, () => console.log('Started on port '+ port))