Carousel Trackers Using RFID

#include "mbed.h"
#include "EthernetInterface.h"
#include "Adafruit_SSD1306.h"
#include "HTTPClient.h"
#if defined(TARGET_WIZWIKI_W7500)||defined(TARGET_WIZWIKI_W7500P)
    uint8_t mac_addr[6] = {0x00, 0x08, 0xDC, 0x53, 0xAE, 0x90};
#endif
// W7500 onboard LED & Init
DigitalOut rled(LED1,1);
DigitalOut gled(LED2,0);
DigitalOut bled(LED3,1);

// I2C Class
I2C i2c(PA_10,PA_9);

// OLED Class   
Adafruit_SSD1306_I2c gOled(i2c,NC,0x78,64,128);

Serial pc(USBTX, USBRX);
Serial device(D1,D0);
EthernetInterface eth;

// Declare TCP Connection Class
TCPSocketConnection sock;

DigitalOut myled(D1);



int main() {
   
pc.baud(115200);
    int received_data=0;
    printf("Wait a second...\r\n");

   eth.init(mac_addr);     //Use DHCP
eth.connect();
    
      printf("IP Address is %s\r\n\r\n", eth.getIPAddress());
        printf("MASK Address is %s\r\n\r\n", eth.getNetworkMask());
        printf("GATEWAY Address is %s\r\n\r\n", eth.getGateway());
        printf("MAC Address is %s\r\n\r\n", eth.getMACAddress());
    char str[512];
    char msg[128]= "";
   // char nameYouWant[] = "dpaknov20";
         while(1){
             
        while(pc.readable()) 
        {
            device.putc(pc.getc());
        }
        while(device.readable())
        {
            if(device.readable()) 
            {
                received_data = device.getc();
                printf("received_data = %d", received_data);
            }
        }
        // TCP socket connect to openweather server 
        //TCPSocketConnection sock;
        //char send_data[1024];
        received_data = device.getc();
        if(received_data==232)
        {
            received_data=905;
            }
            else {
                received_data=910;
                }
        pc.printf("received_data = %d\n", received_data);
        /*char *p="api.thingspeak.com";
           int a=sock.connect(p,80);
          while(1){
                if(a!=0) {
                    printf("\r\n could not connect to socket : error = %d\r\n", p);
                    
                    a = sock.connect(p, 80);
                } else {
                    printf("socket connected\r\n");
                                break;
                }
             } 
        //sock.connect("api.thingspeak.com", 80);
        sprintf((char *)send_data,"GET /update?api_key=GR1IFBYTK5NKNIV6&field1=%d HTTP 1.0\n\n",received_data); 
           
        sock.send_all(send_data, sizeof(send_data));
        char buffer[2048];
        int ret;
        while (true) {
            ret = sock.receive_all(buffer, sizeof(buffer));
            if (ret <= 0)
                break;
            buffer[ret] = '\0';
            printf("Received %d chars from server: %s\n", ret, buffer);     
        }*/
        printf("\r\n\r\n");
        sprintf(msg,"https://api.thingspeak.com/update?api_key=GR1IFBYTK5NKNIV6&field1=%d",received_data);
        HTTPClient http;
        
        pc.printf("Send post message to thingspeak\r\n");
        pc.printf("msg : %s\r\n",msg);
       int ret = http.get(msg, str, sizeof(str));
        if(!ret)
        {
          pc.printf("\r\nPage fetched successfully - read %d characters\r\n", strlen(str));
          pc.printf("Result: %s\r\n", str);
        }
        else
        {
          pc.printf("Error - ret = %d - HTTP return code = %d\n", ret, http.getHTTPResponseCode());
        }
    }

}

app.get('/customer/:bookingid', function (req, res) {
  pool.query('SELECT * FROM customer WHERE tagid = ($1)', [req.session.auth.tagid], function (err, result) {
    if (err) {
        res.status(500).send(err.toString());
    } else {
        if (result.rows.length === 0) {
            res.status(404).send('customer tagid_id not found');
        } else {
            var custData = result.rows[0];
            res.send(makeTemplate(custData));
        }
    }
  });
});

app.get('/customer/baggage/:tagid', function (req, res) {
  pool.query('SELECT * FROM customer_tags WHERE tagid = ($1)', [req.session.auth.tagid], function (err, result) {
    if (err) {
        res.status(500).send(err.toString());
    } else {
        if (result.rows.length === 0) {
            res.status(404).send('customer tagid_id not found');
        } else {
            var metdata=result.rows[0];
            res.send(statusTemplate(metdata));
        }
    }
  });
});

function statusTemplate(statusdata) {
    var tagid=statusdata.tagid;
    var stat1=statusdata.status1;
    var stat2=statusdata.status2;
    var stat3=statusdata.status3;
        var statTemplate = `
        <!DOCTYPE html>
        <html>
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <link rel="stylesheet" href="ui/style2.css">
        <body>
        
        <div class="w3-container w3-orange">
          <h2>This is the baggage status page!</h2>      
          <p>Baggage Tag ID :- ${tagid}</p>      
        </div>
        
        <div class="w3-row-padding">
        
        <div class="w3-third">
          <h2>Status-1</h2>
          <p>${stat1}</p>
        </div>
        
        <div class="w3-third">
          <h2>Status-2</h2>
          <p>${stat2}</p>
        </div>
        
        <div class="w3-third">
          <h2>Status-3</h2>
          <p>${stat3}</p>
        </div>
        <a href="/myapp"><button>HOME</button></a>
        <a href="/myapp/logout"><button>LOGOUT</button></a>
        </div>
        
        </body>
        </html>`
        ;
        return statTemplate;
}

function makeTemplate(data) {
    var name=data.name;
    var email=data.email;
    var contact=data.contact;
    var flight=data.flight;
    var fromcity=data.fromcity;
    var tocity=data.tocity;
    var date=data.date;
    var booking=data.booking;
    var pnr=data.pnr;
    var tagid=data.tagid;
    var fcitylink=data.fcitylink;
    var tcitylink=data.tcitylink;
        var bookTemplate = `
        <html>
            <head>  
                <title>
                    ${name}
                </title>
               
            </head>
            <body>
                <div align="center" style="padding-top : 5">
                <div style="position: relative;">
                    <div style="position: absolute; top: 0; right: 0; padding-top: 10; padding-right: 10">
                        ${fcitylink}
                            <h4>DEPARTURE AIRPORT</h4>
                         ${tcitylink}
                            <h4>ARRIVAL AIRPORT</h4>   
                    </div>
                </div>
                <h1>Passenger Details</h1>
                    <h3>BOOKING ID : </h3>
                    <p>${booking}<p>
                    <h3>PNR NO. : </h3>
                    <p>${pnr}<p>
                    <h3>TAG ID : </h3>
                    <p>${tagid}<p>
                    <h3>Passenger Name : </h3>
                    <p>${name}<p>
                    <h3>Passenger Contact : </h3>
                    <p>${contact}<p>
                    <h3>Flight no. : </h3>
                    <p>${flight}<p>
                    <h3>From : </h3>
                    <p>${fromcity}<p>
                    <h3>DESTINATION : </h3>
                    <p>${tocity}<p>
                    <h3>ON date : </h3>
                    <p>${date}<p>
                    <hr/>
                    <a href="/myapp/logout"><button>LOGOUT</button></a>
                </div>
            </body>
        </html>`
        ;
        return bookTemplate;
}