functions.php

<?php 
// include db connect class
require_once __DIR__ . '/db_connect.php';

// connecting to db
$db = new DB_CONNECT();


function encrypt($data) {
    $key = "bigdig";  // Clé de 8 caractères max
    $data = serialize($data);
    $td = mcrypt_module_open(MCRYPT_DES,"",MCRYPT_MODE_ECB,"");
    $iv = mcrypt_create_iv(mcrypt_enc_get_iv_size($td), MCRYPT_RAND); 
    mcrypt_generic_init($td,$key,$iv);
    $data = base64_encode(mcrypt_generic($td, '!'.$data));
    mcrypt_generic_deinit($td);
    return $data; 
}
 
function decrypt($data) {
    $key = "bigdig"; 
    $td = mcrypt_module_open(MCRYPT_DES,"",MCRYPT_MODE_ECB,""); 
    $iv = mcrypt_create_iv(mcrypt_enc_get_iv_size($td), MCRYPT_RAND); 
    mcrypt_generic_init($td,$key,$iv); 
    $data = mdecrypt_generic($td, base64_decode($data));
    mcrypt_generic_deinit($td); 
 
    if (substr($data,0,1) != '!') 
        return false; 
 
    $data = substr($data,1,strlen($data)-1); 
    return unserialize($data); 
}

function random_string($length) {
    $key = '';
    $keys = array_merge(range(0, 9), range('a', 'z'));

    for ($i = 0; $i < $length; $i++) {
        $key .= $keys[array_rand($keys)];
    }

    return $key;
}

function generer_token($nom = ''){
    session_start();
    $token = uniqid(rand(), true);
    $_SESSION[$nom.'_token'] = $token;
    $_SESSION[$nom.'_token_time'] = time();
    return $token;
}

function verifier_token($temps, $referer, $nom = ''){
session_start();
if(isset($_SESSION[$nom.'_token']) && isset($_SESSION[$nom.'_token_time']) && (isset($_POST['token']) || isset($_GET['token'])))
    if($_SESSION[$nom.'_token'] == $_POST['token'] || $_SESSION[$nom.'_token'] == $_GET['token'])
        if($_SESSION[$nom.'_token_time'] >= (time() - $temps))
            if($_SERVER['HTTP_REFERER'] == $referer)
                return true;
return false;
}


function getAllProducts()
{
     $result = mysql_query("SELECT * FROM produits ") or die(mysql_error());
     $produits = array();
     while($row = mysql_fetch_array($result))
        $produits[] = $row;   
    return $produits;
}

function getProduct($ref)
{
     $result = mysql_query("SELECT * FROM produits where ref='$ref' ") or die(mysql_error());
     $produit = mysql_fetch_array($result);
    return $produit;
}

function getAllFactures($etat)
{
    $char="";
    if ($etat==0) { $char="and etat = 0"; }
    elseif ($etat==1) { $char="and etat = 1"; }    
     $result = mysql_query("SELECT   factures.id , created , etat , id_vehicule , nom , prenom , immatriculation , marque , expere , assurance , date_entree , date_sortie FROM factures , vehicules WHERE factures.id_vehicule=vehicules.id $char") or die(mysql_error());
     $factures = array();
     while($row = mysql_fetch_array($result)){
        $row['total']=getTotal($row['id']);
        $factures[] = $row;
     }
           
    return $factures;
}

function getFacture($num_fact)
{
     $result = mysql_query("SELECT * FROM factures , vehicules where factures.id = '$num_fact' and factures.id_vehicule = vehicules.id ") or die(mysql_error());
     $facture = mysql_fetch_array($result);
    return $facture;
}

function getDevis($num_devis)
{
     $result = mysql_query("SELECT * FROM devis , vehicules where devis.id = '$num_devis' and devis.id_vehicule = vehicules.id ") or die(mysql_error());
     $devis = mysql_fetch_array($result);
    return $devis;
}

function isMinqteSupQte($ref)
{
     $produit = getProduct($ref);
     if($produit['qte_min'] >= $produit['qte'])
         return true;
        else
         return false;
}

function getNotifProducts()
{   
    $result = mysql_query("SELECT count(*) FROM produits WHERE qte_min>=qte") or die(mysql_error());
    $count = mysql_fetch_array($result);
    return $count[0];
}


function getAllProductsNotif()
{
     $result = mysql_query("SELECT * FROM produits WHERE qte_min>=qte") or die(mysql_error());
     $produits = array();
     while($row = mysql_fetch_array($result))
        $produits[] = $row;   
    return $produits;
}


function messageFlash()
{
     
}

//  les fonctions pour table vehicule

function getAllVehicules()
{
     $result = mysql_query("SELECT * FROM vehicules ") or die(mysql_error());
     $vihecules = array();
     while($row = mysql_fetch_array($result))
        $vihecules[] = $row;   
    return $vihecules;
}

function getVehiculeByID($id)
{
     $result = mysql_query("SELECT * FROM vehicules where id=$id") or die(mysql_error());
     $vehicule = array();
     while($row = mysql_fetch_array($result))
        $vehicule = $row;   
    return $vehicule;
}

function getFactureByVehiculeID($id)
{
     $result = mysql_query("SELECT f.* FROM factures f join vehicules v where f.id_vehicule = $id ") or die(mysql_error());
     $facture = mysql_fetch_array($result);
    return $facture;
}
//  les fonctions pour table devis

// function getAllDevis()
// {
//      $result = mysql_query("SELECT devis.id , created  , id_vehicule , nom , prenom , immatriculation , marque , expere , assurance FROM `devis` , `vehicules` WHERE devis.id_vehicule=vehicules.id") or die(mysql_error());
//      $vihecules = array();
//      while($row = mysql_fetch_array($result))
//         $vihecules[] = $row;   
//     return $vihecules;
// }


function getAllDevis()
{
       
    $result = mysql_query("SELECT   devis.id , created  , id_vehicule , nom , prenom , immatriculation , marque , expere , assurance  FROM devis , vehicules WHERE devis.id_vehicule=vehicules.id") or die(mysql_error());
    $devis = array();
    while($row = mysql_fetch_array($result)){
         $devis[] = $row;
    }
    
    return $devis;
}


function getTotal($id)
{
     $result = mysql_query("SELECT * FROM designation WHERE id_facture=$id") or die(mysql_error());
     $total=0;
     while($row = mysql_fetch_array($result)){
        $total+=($row['qte']*$row['prix']);
     }
    return $total;
}


function getDesignationByIdFacture($id)
{
     $result = mysql_query("SELECT * FROM designation WHERE id_facture=$id") or die(mysql_error());
     $designations = array();
     while($row = mysql_fetch_array($result))
        $designations[] = $row;   
    return $designations;
}

function getDetailsByIdDevis($id)
{
     $result = mysql_query("SELECT * FROM details WHERE id_facture=$id") or die(mysql_error());
     $details = array();
     while($row = mysql_fetch_array($result))
        $details[] = $row;   
    return $details;
}

?>