BTS-SIO Project

Modernizing Expense Management: Introducing the Appli-Frais Project

As part of the BTS Services Informatiques aux Organisations (SIO) program, students are often faced with real-world projects that require the implementation of technical and organizational skills. The Appli-Frais project perfectly exemplifies this approach by offering an innovative solution for expense and reimbursement management within companies.

Objective

The Appli-Frais project aims to develop a web application for recording expenses incurred by employees, tracking reimbursements, and simplifying accounting operations. For BTS SIO students, this represents an opportunity to apply their knowledge in web development, database management, and computer security in a professional context.

Accessibility and Security

Accessibility and security are crucial aspects of the project. The application must be easily accessible to authorized users while ensuring the confidentiality of data. In this regard, secure authentication mechanisms are implemented, and all exchanged data is encrypted to protect its integrity.

// Start the session
session_start();

// Check if the user is logged in
if (!isset($_SESSION['user_login'])) {
    // Redirect the user to the login page if not logged in
    wp_redirect(home_url('/pagelogin'));
    exit;
}

Expense Reimbursement Process

The core of the application lies in expense management. The features allow for recording various types of expenses (meals, accommodations, mileage, etc.) and automatically calculating reimbursements. BTS SIO students will have the opportunity to implement web development techniques and database manipulation to realize this functionality.

// Retrieve data for fixed expenses
$sql = "SELECT LIG_QTE FROM ligne_frais_forfait WHERE FOR_ID = 'REP' and FFR_ID = ?";
$stmt = $wpdb->prepare($sql, $ffr_id);
$result = $wpdb->get_results($stmt);
if (!empty($result)) {
    $repas = $result[0]->LIG_QTE;
} else {
    $repas = "Not available";
    echo $result;
}

Reimbursement Management

Once expenses are recorded, the accounting department conducts periodic validation. Values are verified, and reimbursements are made accordingly. BTS SIO students will have the opportunity to design mechanisms for controlling and tracking data to ensure the system’s reliability.

// Retrieve other information from the expense report
$sql = "SELECT FRR_DATE_MODIF, FRR_MONTANT_VALIDE, ETA_ID FROM fiche_frais WHERE FFR_ID = %d";
$result = $wpdb->get_results($wpdb->prepare($sql, $ffr_id));

// Display the data
if (!empty($result)) {
    ?>
    <tr>
        <td><?php echo $repas ?></td>
        <td><?php echo $nuit ?></td>
        <td><?php echo $etap ?></td>
        <td><?php echo $km ?></td>
        <td><?php echo convertir2LETTRE($etat) ?></td>
        <td><?php echo $dateop ?></td>
        <td><?php echo $remboursement ?></td>
    </tr>
    <?php
} else {
    echo "<tr><td colspan='7'>No data available</td></tr>";
}

Conclusion

The Appli-Frais project represents an excellent opportunity for BTS SIO students to apply their technical and organizational skills in a professional context. By developing a robust and secure web application for expense management, students will gain valuable experience that will prepare them to tackle the challenges of the professional world.