const express = require('express');
const multer = require('multer');
const Tesseract = require('tesseract.js');
const mysql = require('mysql');
const path = require('path');


const bodyParser = require('body-parser');
const session = require('express-session');
const bcrypt = require('bcrypt');
const http = require('http');
const socketIO = require('socket.io');
const app = express();
const server = http.createServer(app);
const io = socketIO(server);
const upload = multer({ dest: 'uploads/' });
app.set('view engine', 'ejs');


// Middleware setup
app.use(bodyParser.urlencoded({ extended: false }));
app.use(session({
    secret: 'secret_key', // Change this to a more secure value
    resave: true,
    saveUninitialized: true
}));


// MySQL connection setup
const connection = mysql.createConnection({
    host: 'localhost',
    user:  // Replace with your MySQL username
    password: // Replace with your MySQL password
    database: 'businessdb'
});


connection.connect(err => {
    if (err) {
        console.error('Error connecting to MySQL:', err);
        return;
    }
    console.log('Connected to MySQL');
});


// Tesseract.js function
function extractTextFromImage(imagePath) {
    return new Promise((resolve, reject) => {
        Tesseract.recognize(imagePath, 'eng')
            .then(({ data: { text } }) => {
                resolve(text);
            })
            .catch(error => {
                reject(error);
            });
    });
}


// Routes (excluding sensitive content)
app.get('/public', (req, res) => {
    res.sendFile(path.join(__dirname, 'public', 'index.html'));
});


// Upload route with Tesseract.js integration
app.post('/upload', upload.single('image'), (req, res) => {
    if (!req.file) {
        return res.status(400).send('No files were uploaded.');
    }
    const imagePath = req.file.path;


    extractTextFromImage(imagePath)
        .then(text => {
            // Process extracted text...
            console.log('Extracted text:', text);
            res.send('Text extracted successfully');
        })
        .catch(error => {
            console.error('Error occurred during text extraction:', error);
            res.status(500).send('Error occurred during text extraction.');
        });
});


// Listen for new connections
io.on('connection', (socket) => {
    // Handle socket events...
});


// Server initialization
const PORT = process.env.PORT || 3000;
server.listen(PORT, () => {
    console.log(`Server running on port http://localhost:${PORT}`);
});