JantTaf est un générateur automatique d'api à partir d'une base de données MYSQL ou PGSQL ou SQLSRV.
Une fois le fichier de configuration (TafConfig.php) personnalisé, grâce à l'api vous pouvez voir toutes les tables de votre base de données et ainsi générer les fichiers nécessaires à la manipulation de ces tables comme la récupération, la suppression, l'ajout et la modification des données.

La(es) table(s) de la base de données ammo1331_teste_jant_bi_mobile

  1. accompte
  2. ajustement_stock
  3. caisse_caisse
  4. caisse_details_caisse_pv_caisse_2
  5. caisse_devise
  6. caisse_espece
  7. caisse_etat_caisse
  8. caisse_pv_caisse
  9. caisse_pv_caisse_2
  10. caisse_session
  11. caisse_signature
  12. caisse_type_espece
  13. comptabilite_cheque
  14. entree_sortie_stock
  15. entreprise
  16. etat_approvisionnement
  17. facturation_approvisionnement
  18. facturation_client
  19. facturation_client_compte
  20. facturation_commande
  21. facturation_controle
  22. facturation_detail_approvisionnement
  23. facturation_detail_commande
  24. facturation_detail_controle
  25. facturation_devise
  26. facturation_entrepot
  27. facturation_etat_commande
  28. facturation_fournisseur
  29. facturation_livraison
  30. facturation_matiere_premiere
  31. facturation_mode_de_paiement
  32. facturation_prix
  33. facturation_produit_fini
  34. facturation_produit_fini_commercial
  35. facturation_transfert
  36. facturation_type_entrepot
  37. facturation_type_matiere_premiere
  38. facturation_ville
  39. facturation_zone
  40. log
  41. pointage
  42. privilege
  43. transaction_compte
  44. utilisateur
  45. utilisateur_entreprise

Configuration

La configuration repose sur le fichier TafConfig.php. Dans ce fichier vous devez spécifier:
• le type de la base de données
• l'adresse de votre serveur
• le port du SGBD
• le nom de votre base de donnée
• nom d'utilisateur de la base de données
• mot de passe de l'utilisateur de la base de données

NB:
Dans le cadre de Postgres, n'oubliez pas d'activer l'extension au niveau de php.ini (";extension=pdo_pgsql" -> "extension=pdo_pgsql"))

/* Information de connexion à la base de données */ public $database_type = "mysql"; // "mysql" | "pgsql" | "sqlsrv" public $host = "localhost"; // adresse ou ip du serveur public $port = "3306"; // 3306 pour mysql | 5432 pour pgsql | 1433 pour sqlsrv public $database_name = "ma_bd"; // nom de la base de données public $user = "root"; // nom de l'utilisateur de la base de données public $password = ""; // mot de passe de l'utilisateur de la base de données /* informations de connexion à la documentation */ public $documentation_username = "admin"; // nom d'utilisateur pour accéder à la documentation public $documentation_password = "1234"; // mot de passe de l'utilisateur pour accéder à la documentation

Fichier de configuration pour le projet angular

Créez un fichier JSON dans la racine de votre projet Angular nommé taf.config.json avec le contenu suivant :
cliquez ici pour consulter la documentation complete

{ "projectName": "projet1.angular", "decription": "Fichier de configuration de Taf", "taf_base_url": "http:\/\/www.teste.bi.jant.tech\/\/", "les_modules": [ { "module": "home", "les_tables": [ { "table": "accompte", "description": [ "id_accompte", "id_commande", "id_mode_de_paiement", "id_compte", "montant", "date_heure", "id_utilisateur", "id_entreprise", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "ajustement_stock", "description": [ "id_ajustement_stock", "id_matiere_premiere", "id_entrepot", "id_entreprise", "quantite", "date", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_caisse", "description": [ "id_caisse", "id_utilisateur_entreprise", "libelle", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_details_caisse_pv_caisse_2", "description": [ "id_detail_caisse_pv_caisse_2", "id_caisse_pv_caisse_2", "id_mode_de_paiement", "somme_theorique", "somme_reelle", "cloturer" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_devise", "description": [ "id_devise", "id_utilisateur_entreprise", "libelle", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_espece", "description": [ "id_espece", "id_devise", "id_type_espece", "id_utilisateur_entreprise", "nom_espece", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_etat_caisse", "description": [ "id_etat_caisse", "libelle" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_pv_caisse", "description": [ "id_pv_caisse", "id_caisse", "id_caissier", "id_verificateur", "id_controleur", "id_etat_pv_caisse", "id_session", "date_heure", "details_espece", "sous_total_billet", "sous_total_piece", "sous_total_electronique", "total_en_caisse_reel", "solde_en_caisse_theorique", "status", "ecart", "commentaire", "total", "valider", "created_at", "update_at", "date_verification", "date_validation" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_pv_caisse_2", "description": [ "id_caisse_pv_caisse_2", "jour", "fond_de_caisse", "id_entreprise", "id_utilisateur", "created_at", "cloturer", "id_verificateur", "id_controleur", "id_etat_pv_caisse", "date_heure", "details_espece", "sous_total_billet", "sous_total_piece", "sous_total_electronique", "total_en_caisse_reel", "solde_en_caisse_theorique", "status", "ecart", "commentaire", "total", "valider", "update_at", "date_verification", "date_validation" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_session", "description": [ "id_session", "id_utilisateur_entreprise", "titre", "date_debut", "date_fin", "description", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_signature", "description": [ "id_caisse_signature", "id_utilisateur_entreprise", "signature", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_type_espece", "description": [ "id_type_espece", "libelle", "description", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "comptabilite_cheque", "description": [ "id_cheque", "id_utilisateur", "id_utilisateur_entreprise", "date", "code", "nom", "cheque", "banque", "echeance", "montant", "facture", "observation", "commercial", "produit", "site", "acompte", "date_encaissement", "date_impaye", "date_enregistrement" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "entree_sortie_stock", "description": [ "id_entree_stock", "id_entrepot", "id_matiere_premiere", "id_entreprise", "type", "quantite", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "entreprise", "description": [ "id_entreprise", "created_by", "nom", "longitude", "latitude", "created_at", "updated_at", "logo_entreprise", "ninea", "adresse", "contact", "contact_whatsapp", "email", "registre_commerce", "slogan", "nb", "nom_entreprise_donneur_ordre", "logo_entreprise_donneur_ordre" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "etat_approvisionnement", "description": [ "id_etat_approvisionnement", "titre", "description", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_approvisionnement", "description": [ "id_approvisionnement", "id_type_approvisionnement", "id_utilisateur", "id_fournisseur", "id_entreprise", "id_etat_approvisionnement", "id_devise", "bon_de_livraison", "date_arrivee", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_client", "description": [ "id_client", "id_ville", "id_zone", "id_utilisateur", "id_entreprise", "prenom", "nom", "telephone", "adresse", "numero_compte", "contact", "telephone_contact", "login", "pwd", "status", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_client_compte", "description": [ "id_compte", "id_client", "etat", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_commande", "description": [ "id_commande", "id_client", "id_utilisateur", "id_etat_commande", "id_entreprise", "id_mode_de_paiement", "bon_commande", "date_heure", "accompte", "created_at", "updated_at", "tva", "id_compte" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_controle", "description": [ "id_controle", "id_entreprise", "id_utilisateur", "etat", "date", "titre", "commentaire", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_detail_approvisionnement", "description": [ "id_detail_approvisionnement", "id_matiere_premiere", "id_approvisionnement", "id_entrepot", "quantite", "prix_unitaire", "prix_unitaire_devise", "jour_insertion" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_detail_commande", "description": [ "id_detail_commande", "id_commande", "id_matiere_premiere", "id_entrepot", "quantite", "prix_ui", "remise", "type_de_paiement", "reference", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_detail_controle", "description": [ "id_detail_controle", "id_controle", "id_matiere_premiere", "id_entrepot", "quantite_reelle", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_devise", "description": [ "id_devise", "titre", "symbole", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_entrepot", "description": [ "id_entrepot", "id_type_entrepot", "id_utilisateur", "id_entreprise", "nom", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_etat_commande", "description": [ "id_etat_commande", "libelle", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_fournisseur", "description": [ "id_fournisseur", "id_utilisateur", "id_entreprise", "nom", "prenom", "email", "telephone", "adresse", "pays", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_livraison", "description": [ "id_livraison", "id_utilisateur", "id_entreprise", "id_commande", "id_detail_commande", "id_chauffeur", "id_camion", "bon_livraison", "date_heure", "quantite_livre", "chauffeur_externe", "camion_externe", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_matiere_premiere", "description": [ "id_matiere_premiere", "id_type_matiere_premiere", "id_utilisateur", "id_entreprise", "id_devise", "id_entrepot", "libelle", "abreviation", "seuil_de_stock", "unite_de_mesure", "marque", "reference", "prix_defaut", "prix_achat", "prix_achat_devise", "status", "created_at", "updated_at", "quantite_depart" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_mode_de_paiement", "description": [ "id_mode_de_paiement", "libelle", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_prix", "description": [ "id_prix", "id_matiere_premiere", "id_utilisateur", "id_entreprise", "prix", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_produit_fini", "description": [ "id_produit_fini", "id_employe", "libelle", "type_produit_fini", "abreviation", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_produit_fini_commercial", "description": [ "id_produit_fini_commercial", "id_type_matiere_premiere", "id_entrepot", "id_utilisateur", "id_entreprise", "id_matiere_premiere", "libelle", "unite_de_mesure", "abreviation", "status", "prix_defaut", "seuil_de_stock", "marque", "reference", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_transfert", "description": [ "id_transfert", "id_matiere_premiere", "id_entrepot_depart", "id_entrepot_destination", "id_utilisateur", "id_entreprise", "titre", "quantite", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_type_entrepot", "description": [ "id_type_entrepot", "id_utilisateur", "id_entreprise", "libelle", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_type_matiere_premiere", "description": [ "id_type_matiere_premiere", "id_utilisateur", "id_entreprise", "libelle", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_ville", "description": [ "id_ville", "nom", "id_zone", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_zone", "description": [ "id_zone", "nom", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "log", "description": [ "id_log", "ip", "params", "token", "titre", "description", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "pointage", "description": [ "id_pointage", "ip", "longitude", "latitude", "id_utilisateur_entreprise", "id_session", "createdAt" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "privilege", "description": [ "id_privilege", "libelle", "description", "les_droits", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "transaction_compte", "description": [ "id_transaction_compte", "type", "id_compte", "montant", "created_at", "id_mode_de_paiement", "designation", "jour", "date" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "utilisateur", "description": [ "id_utilisateur", "id_auteur", "prenom", "nom", "civilite", "telephone", "adresse", "email", "password", "created_at", "createdAt" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "utilisateur_entreprise", "description": [ "id_utilisateur_entreprise", "id_privilege", "id_utilisateur", "id_entreprise", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] } ] }, { "module": "public", "les_tables": [ { "table": "login", "description": [ "login", "pwd" ], "les_types": [ "login" ] } ] } ] }
{ "projectName": "projet1.angular", "decription": "Fichier de configuration de Taf", "taf_base_url": "http:\/\/www.teste.bi.jant.tech\/\/", "les_modules": [ { "module": "home", "les_tables": [ { "table": "accompte", "description": [ "id_accompte", "id_commande", "id_mode_de_paiement", "id_compte", "montant", "date_heure", "id_utilisateur", "id_entreprise", "created_at", "updated_at" ], "table_descriptions": { "table_name": "accompte", "cle_primaire": { "Field": "id_accompte", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "accompte" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_accompte", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_commande", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_mode_de_paiement", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_compte", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "montant", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_heure", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "created_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "ajustement_stock", "description": [ "id_ajustement_stock", "id_matiere_premiere", "id_entrepot", "id_entreprise", "quantite", "date", "created_at", "updated_at" ], "table_descriptions": { "table_name": "ajustement_stock", "cle_primaire": { "Field": "id_ajustement_stock", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "ajustement_stock", "facturation_matiere_premiere", "facturation_entrepot", "entreprise" ], "les_referenced_table": [ "facturation_matiere_premiere", "facturation_entrepot", "entreprise" ], "les_colonnes": [ { "Field": "id_ajustement_stock", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_matiere_premiere", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_matiere_premiere de la table facturation_matiere_premiere", "table": { "TABLE_NAME": "ajustement_stock", "COLUMN_NAME": "id_matiere_premiere", "REFERENCED_TABLE_NAME": "facturation_matiere_premiere", "REFERENCED_COLUMN_NAME": "id_matiere_premiere" }, "table_existant": false, "referenced_table": { "table_name": "facturation_matiere_premiere", "cle_primaire": { "Field": "id_matiere_premiere", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "ajustement_stock", "facturation_matiere_premiere" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_matiere_premiere", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_type_matiere_premiere", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_devise", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entrepot", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "libelle", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "abreviation", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "seuil_de_stock", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "unite_de_mesure", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "marque", "Type": "varchar(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "reference", "Type": "varchar(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "prix_defaut", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "prix_achat", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "prix_achat_devise", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "status", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "1", "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "quantite_depart", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" } ] } }, { "Field": "id_entrepot", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_entrepot de la table facturation_entrepot", "table": { "TABLE_NAME": "ajustement_stock", "COLUMN_NAME": "id_entrepot", "REFERENCED_TABLE_NAME": "facturation_entrepot", "REFERENCED_COLUMN_NAME": "id_entrepot" }, "table_existant": false, "referenced_table": { "table_name": "facturation_entrepot", "cle_primaire": { "Field": "id_entrepot", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "ajustement_stock", "facturation_matiere_premiere", "facturation_entrepot" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_entrepot", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_type_entrepot", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "nom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] } }, { "Field": "id_entreprise", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_entreprise de la table entreprise", "table": { "TABLE_NAME": "ajustement_stock", "COLUMN_NAME": "id_entreprise", "REFERENCED_TABLE_NAME": "entreprise", "REFERENCED_COLUMN_NAME": "id_entreprise" }, "table_existant": false, "referenced_table": { "table_name": "entreprise", "cle_primaire": { "Field": "id_entreprise", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "ajustement_stock", "facturation_matiere_premiere", "facturation_entrepot", "entreprise" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_entreprise", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "created_by", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "nom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "longitude", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "latitude", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "logo_entreprise", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "ninea", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "adresse", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "contact", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "contact_whatsapp", "Type": "varchar(50)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "email", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "registre_commerce", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "slogan", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nb", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nom_entreprise_donneur_ordre", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "logo_entreprise_donneur_ordre", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] } }, { "Field": "quantite", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_caisse", "description": [ "id_caisse", "id_utilisateur_entreprise", "libelle", "created_at", "updated_at" ], "table_descriptions": { "table_name": "caisse_caisse", "cle_primaire": { "Field": "id_caisse", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "caisse_caisse" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_caisse", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_utilisateur_entreprise", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "libelle", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_details_caisse_pv_caisse_2", "description": [ "id_detail_caisse_pv_caisse_2", "id_caisse_pv_caisse_2", "id_mode_de_paiement", "somme_theorique", "somme_reelle", "cloturer" ], "table_descriptions": { "table_name": "caisse_details_caisse_pv_caisse_2", "cle_primaire": { "Field": "id_detail_caisse_pv_caisse_2", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "caisse_details_caisse_pv_caisse_2" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_detail_caisse_pv_caisse_2", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_caisse_pv_caisse_2", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "id_mode_de_paiement", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "somme_theorique", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "somme_reelle", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "cloturer", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_devise", "description": [ "id_devise", "id_utilisateur_entreprise", "libelle", "created_at" ], "table_descriptions": { "table_name": "caisse_devise", "cle_primaire": { "Field": "id_devise", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "caisse_devise" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_devise", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_utilisateur_entreprise", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "libelle", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_espece", "description": [ "id_espece", "id_devise", "id_type_espece", "id_utilisateur_entreprise", "nom_espece", "created_at" ], "table_descriptions": { "table_name": "caisse_espece", "cle_primaire": { "Field": "id_espece", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "caisse_espece" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_espece", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_devise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_type_espece", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur_entreprise", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "nom_espece", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_etat_caisse", "description": [ "id_etat_caisse", "libelle" ], "table_descriptions": { "table_name": "caisse_etat_caisse", "cle_primaire": { "Field": "id_etat_caisse", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "caisse_etat_caisse" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_etat_caisse", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "libelle", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_pv_caisse", "description": [ "id_pv_caisse", "id_caisse", "id_caissier", "id_verificateur", "id_controleur", "id_etat_pv_caisse", "id_session", "date_heure", "details_espece", "sous_total_billet", "sous_total_piece", "sous_total_electronique", "total_en_caisse_reel", "solde_en_caisse_theorique", "status", "ecart", "commentaire", "total", "valider", "created_at", "update_at", "date_verification", "date_validation" ], "table_descriptions": { "table_name": "caisse_pv_caisse", "cle_primaire": { "Field": "id_pv_caisse", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "caisse_pv_caisse" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_pv_caisse", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_caisse", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_caissier", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_verificateur", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_controleur", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_etat_pv_caisse", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": "1", "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_session", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "date_heure", "Type": "date", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "details_espece", "Type": "mediumtext", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "sous_total_billet", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "sous_total_piece", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "sous_total_electronique", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "total_en_caisse_reel", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "solde_en_caisse_theorique", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "status", "Type": "int(11)", "Null": "NO", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "ecart", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "commentaire", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "total", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "valider", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "update_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_verification", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_validation", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_pv_caisse_2", "description": [ "id_caisse_pv_caisse_2", "jour", "fond_de_caisse", "id_entreprise", "id_utilisateur", "created_at", "cloturer", "id_verificateur", "id_controleur", "id_etat_pv_caisse", "date_heure", "details_espece", "sous_total_billet", "sous_total_piece", "sous_total_electronique", "total_en_caisse_reel", "solde_en_caisse_theorique", "status", "ecart", "commentaire", "total", "valider", "update_at", "date_verification", "date_validation" ], "table_descriptions": { "table_name": "caisse_pv_caisse_2", "cle_primaire": { "Field": "id_caisse_pv_caisse_2", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "caisse_pv_caisse_2" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_caisse_pv_caisse_2", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "jour", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "fond_de_caisse", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "id_entreprise", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "created_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "cloturer", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "id_verificateur", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "id_controleur", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "id_etat_pv_caisse", "Type": "int(11)", "Null": "NO", "Key": "", "Default": "1", "Extra": "", "explications": "" }, { "Field": "date_heure", "Type": "date", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "details_espece", "Type": "mediumtext", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "sous_total_billet", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "sous_total_piece", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "sous_total_electronique", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "total_en_caisse_reel", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "solde_en_caisse_theorique", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "status", "Type": "int(11)", "Null": "NO", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "ecart", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "commentaire", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "total", "Type": "int(11)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "valider", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "update_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_verification", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_validation", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_session", "description": [ "id_session", "id_utilisateur_entreprise", "titre", "date_debut", "date_fin", "description", "created_at" ], "table_descriptions": { "table_name": "caisse_session", "cle_primaire": { "Field": "id_session", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "caisse_session" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_session", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_utilisateur_entreprise", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "titre", "Type": "varchar(255)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_debut", "Type": "time", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_fin", "Type": "time", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "description", "Type": "varchar(255)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_signature", "description": [ "id_caisse_signature", "id_utilisateur_entreprise", "signature", "created_at" ], "table_descriptions": { "table_name": "caisse_signature", "cle_primaire": { "Field": "id_caisse_signature", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "caisse_signature" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_caisse_signature", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_utilisateur_entreprise", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "signature", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "caisse_type_espece", "description": [ "id_type_espece", "libelle", "description", "created_at" ], "table_descriptions": { "table_name": "caisse_type_espece", "cle_primaire": { "Field": "id_type_espece", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "caisse_type_espece" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_type_espece", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "libelle", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "description", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "comptabilite_cheque", "description": [ "id_cheque", "id_utilisateur", "id_utilisateur_entreprise", "date", "code", "nom", "cheque", "banque", "echeance", "montant", "facture", "observation", "commercial", "produit", "site", "acompte", "date_encaissement", "date_impaye", "date_enregistrement" ], "table_descriptions": { "table_name": "comptabilite_cheque", "cle_primaire": { "Field": "id_cheque", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "comptabilite_cheque" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_cheque", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur_entreprise", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "date", "Type": "char(100)", "Null": "YES", "Key": "", "Default": "''", "Extra": "", "explications": "" }, { "Field": "code", "Type": "char(100)", "Null": "YES", "Key": "", "Default": "''", "Extra": "", "explications": "" }, { "Field": "nom", "Type": "char(100)", "Null": "YES", "Key": "", "Default": "''", "Extra": "", "explications": "" }, { "Field": "cheque", "Type": "char(100)", "Null": "YES", "Key": "", "Default": "''", "Extra": "", "explications": "" }, { "Field": "banque", "Type": "char(100)", "Null": "YES", "Key": "", "Default": "''", "Extra": "", "explications": "" }, { "Field": "echeance", "Type": "char(100)", "Null": "YES", "Key": "", "Default": "''", "Extra": "", "explications": "" }, { "Field": "montant", "Type": "char(100)", "Null": "YES", "Key": "", "Default": "''", "Extra": "", "explications": "" }, { "Field": "facture", "Type": "char(100)", "Null": "YES", "Key": "", "Default": "''", "Extra": "", "explications": "" }, { "Field": "observation", "Type": "char(100)", "Null": "YES", "Key": "", "Default": "''''''", "Extra": "", "explications": "" }, { "Field": "commercial", "Type": "char(100)", "Null": "YES", "Key": "", "Default": "''''''", "Extra": "", "explications": "" }, { "Field": "produit", "Type": "char(100)", "Null": "YES", "Key": "", "Default": "''''''", "Extra": "", "explications": "" }, { "Field": "site", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "acompte", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_encaissement", "Type": "char(100)", "Null": "YES", "Key": "", "Default": "''", "Extra": "", "explications": "" }, { "Field": "date_impaye", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_enregistrement", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "entree_sortie_stock", "description": [ "id_entree_stock", "id_entrepot", "id_matiere_premiere", "id_entreprise", "type", "quantite", "created_at", "updated_at" ], "table_descriptions": { "table_name": "entree_sortie_stock", "cle_primaire": { "Field": "id_entree_stock", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "entree_sortie_stock" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_entree_stock", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_entrepot", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_matiere_premiere", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "type", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "quantite", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "entreprise", "description": [ "id_entreprise", "created_by", "nom", "longitude", "latitude", "created_at", "updated_at", "logo_entreprise", "ninea", "adresse", "contact", "contact_whatsapp", "email", "registre_commerce", "slogan", "nb", "nom_entreprise_donneur_ordre", "logo_entreprise_donneur_ordre" ], "table_descriptions": { "table_name": "entreprise", "cle_primaire": { "Field": "id_entreprise", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "entreprise" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_entreprise", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "created_by", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "nom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "longitude", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "latitude", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "logo_entreprise", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "ninea", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "adresse", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "contact", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "contact_whatsapp", "Type": "varchar(50)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "email", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "registre_commerce", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "slogan", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nb", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nom_entreprise_donneur_ordre", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "logo_entreprise_donneur_ordre", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "etat_approvisionnement", "description": [ "id_etat_approvisionnement", "titre", "description", "created_at" ], "table_descriptions": { "table_name": "etat_approvisionnement", "cle_primaire": { "Field": "id_etat_approvisionnement", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "etat_approvisionnement" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_etat_approvisionnement", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "titre", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "description", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_approvisionnement", "description": [ "id_approvisionnement", "id_type_approvisionnement", "id_utilisateur", "id_fournisseur", "id_entreprise", "id_etat_approvisionnement", "id_devise", "bon_de_livraison", "date_arrivee", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_approvisionnement", "cle_primaire": { "Field": "id_approvisionnement", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_approvisionnement" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_approvisionnement", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_type_approvisionnement", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_fournisseur", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_etat_approvisionnement", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_devise", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "bon_de_livraison", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_arrivee", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_client", "description": [ "id_client", "id_ville", "id_zone", "id_utilisateur", "id_entreprise", "prenom", "nom", "telephone", "adresse", "numero_compte", "contact", "telephone_contact", "login", "pwd", "status", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_client", "cle_primaire": { "Field": "id_client", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_client" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_client", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_ville", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_zone", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "prenom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "adresse", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "numero_compte", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "contact", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone_contact", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "login", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pwd", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "status", "Type": "int(255)", "Null": "YES", "Key": "", "Default": "1", "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_client_compte", "description": [ "id_compte", "id_client", "etat", "created_at" ], "table_descriptions": { "table_name": "facturation_client_compte", "cle_primaire": { "Field": "id_compte", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_client_compte" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_compte", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_client", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "etat", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "1", "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_commande", "description": [ "id_commande", "id_client", "id_utilisateur", "id_etat_commande", "id_entreprise", "id_mode_de_paiement", "bon_commande", "date_heure", "accompte", "created_at", "updated_at", "tva", "id_compte" ], "table_descriptions": { "table_name": "facturation_commande", "cle_primaire": { "Field": "id_commande", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_commande" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_commande", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_client", "Type": "int(255)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_etat_commande", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_mode_de_paiement", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "bon_commande", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_heure", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "accompte", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "tva", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "id_compte", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_controle", "description": [ "id_controle", "id_entreprise", "id_utilisateur", "etat", "date", "titre", "commentaire", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_controle", "cle_primaire": { "Field": "id_controle", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_controle" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_controle", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "etat", "Type": "int(11)", "Null": "NO", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "date", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "titre", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "commentaire", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_detail_approvisionnement", "description": [ "id_detail_approvisionnement", "id_matiere_premiere", "id_approvisionnement", "id_entrepot", "quantite", "prix_unitaire", "prix_unitaire_devise", "jour_insertion" ], "table_descriptions": { "table_name": "facturation_detail_approvisionnement", "cle_primaire": { "Field": "id_detail_approvisionnement", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_detail_approvisionnement" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_detail_approvisionnement", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_matiere_premiere", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_approvisionnement", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entrepot", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "quantite", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "prix_unitaire", "Type": "varchar(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "prix_unitaire_devise", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "jour_insertion", "Type": "date", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_detail_commande", "description": [ "id_detail_commande", "id_commande", "id_matiere_premiere", "id_entrepot", "quantite", "prix_ui", "remise", "type_de_paiement", "reference", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_detail_commande", "cle_primaire": { "Field": "id_detail_commande", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_detail_commande" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_detail_commande", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_commande", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_matiere_premiere", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entrepot", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "quantite", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "prix_ui", "Type": "varchar(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "remise", "Type": "varchar(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "type_de_paiement", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "reference", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_detail_controle", "description": [ "id_detail_controle", "id_controle", "id_matiere_premiere", "id_entrepot", "quantite_reelle", "created_at" ], "table_descriptions": { "table_name": "facturation_detail_controle", "cle_primaire": { "Field": "id_detail_controle", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_detail_controle" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_detail_controle", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_controle", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_matiere_premiere", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entrepot", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "quantite_reelle", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_devise", "description": [ "id_devise", "titre", "symbole", "created_at" ], "table_descriptions": { "table_name": "facturation_devise", "cle_primaire": { "Field": "id_devise", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_devise" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_devise", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "titre", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "symbole", "Type": "varchar(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_entrepot", "description": [ "id_entrepot", "id_type_entrepot", "id_utilisateur", "id_entreprise", "nom", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_entrepot", "cle_primaire": { "Field": "id_entrepot", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_entrepot" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_entrepot", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_type_entrepot", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "nom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_etat_commande", "description": [ "id_etat_commande", "libelle", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_etat_commande", "cle_primaire": { "Field": "id_etat_commande", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_etat_commande" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_etat_commande", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "libelle", "Type": "text", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_fournisseur", "description": [ "id_fournisseur", "id_utilisateur", "id_entreprise", "nom", "prenom", "email", "telephone", "adresse", "pays", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_fournisseur", "cle_primaire": { "Field": "id_fournisseur", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_fournisseur" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_fournisseur", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "nom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "prenom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "email", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone", "Type": "varchar(15)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "adresse", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_livraison", "description": [ "id_livraison", "id_utilisateur", "id_entreprise", "id_commande", "id_detail_commande", "id_chauffeur", "id_camion", "bon_livraison", "date_heure", "quantite_livre", "chauffeur_externe", "camion_externe", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_livraison", "cle_primaire": { "Field": "id_livraison", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_livraison" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_livraison", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_commande", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_detail_commande", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_chauffeur", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "id_camion", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "bon_livraison", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_heure", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "quantite_livre", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "chauffeur_externe", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "camion_externe", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_matiere_premiere", "description": [ "id_matiere_premiere", "id_type_matiere_premiere", "id_utilisateur", "id_entreprise", "id_devise", "id_entrepot", "libelle", "abreviation", "seuil_de_stock", "unite_de_mesure", "marque", "reference", "prix_defaut", "prix_achat", "prix_achat_devise", "status", "created_at", "updated_at", "quantite_depart" ], "table_descriptions": { "table_name": "facturation_matiere_premiere", "cle_primaire": { "Field": "id_matiere_premiere", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_matiere_premiere" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_matiere_premiere", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_type_matiere_premiere", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_devise", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entrepot", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "libelle", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "abreviation", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "seuil_de_stock", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "unite_de_mesure", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "marque", "Type": "varchar(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "reference", "Type": "varchar(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "prix_defaut", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "prix_achat", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "prix_achat_devise", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "status", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "1", "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "quantite_depart", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_mode_de_paiement", "description": [ "id_mode_de_paiement", "libelle", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_mode_de_paiement", "cle_primaire": { "Field": "id_mode_de_paiement", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_mode_de_paiement" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_mode_de_paiement", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "libelle", "Type": "varchar(255)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_prix", "description": [ "id_prix", "id_matiere_premiere", "id_utilisateur", "id_entreprise", "prix", "created_at" ], "table_descriptions": { "table_name": "facturation_prix", "cle_primaire": { "Field": "id_prix", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_prix" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_prix", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_matiere_premiere", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "prix", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_produit_fini", "description": [ "id_produit_fini", "id_employe", "libelle", "type_produit_fini", "abreviation", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_produit_fini", "cle_primaire": { "Field": "id_produit_fini", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_produit_fini" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_produit_fini", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_employe", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "libelle", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "type_produit_fini", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "abreviation", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_produit_fini_commercial", "description": [ "id_produit_fini_commercial", "id_type_matiere_premiere", "id_entrepot", "id_utilisateur", "id_entreprise", "id_matiere_premiere", "libelle", "unite_de_mesure", "abreviation", "status", "prix_defaut", "seuil_de_stock", "marque", "reference", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_produit_fini_commercial", "cle_primaire": { "Field": "id_produit_fini_commercial", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_produit_fini_commercial" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_produit_fini_commercial", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_type_matiere_premiere", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entrepot", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_matiere_premiere", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "libelle", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "unite_de_mesure", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "abreviation", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "status", "Type": "int(255)", "Null": "YES", "Key": "", "Default": "1", "Extra": "", "explications": "" }, { "Field": "prix_defaut", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "seuil_de_stock", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "marque", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "reference", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_transfert", "description": [ "id_transfert", "id_matiere_premiere", "id_entrepot_depart", "id_entrepot_destination", "id_utilisateur", "id_entreprise", "titre", "quantite", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_transfert", "cle_primaire": { "Field": "id_transfert", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_transfert" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_transfert", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_matiere_premiere", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entrepot_depart", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entrepot_destination", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "titre", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "quantite", "Type": "float", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_type_entrepot", "description": [ "id_type_entrepot", "id_utilisateur", "id_entreprise", "libelle", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_type_entrepot", "cle_primaire": { "Field": "id_type_entrepot", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_type_entrepot" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_type_entrepot", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "libelle", "Type": "varchar(255)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_type_matiere_premiere", "description": [ "id_type_matiere_premiere", "id_utilisateur", "id_entreprise", "libelle", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_type_matiere_premiere", "cle_primaire": { "Field": "id_type_matiere_premiere", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_type_matiere_premiere" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_type_matiere_premiere", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_utilisateur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "libelle", "Type": "varchar(255)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_ville", "description": [ "id_ville", "nom", "id_zone", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_ville", "cle_primaire": { "Field": "id_ville", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_ville" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_ville", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "nom", "Type": "varchar(255)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "id_zone", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "facturation_zone", "description": [ "id_zone", "nom", "created_at", "updated_at" ], "table_descriptions": { "table_name": "facturation_zone", "cle_primaire": { "Field": "id_zone", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "facturation_zone" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_zone", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "nom", "Type": "varchar(255)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "log", "description": [ "id_log", "ip", "params", "token", "titre", "description", "created_at" ], "table_descriptions": { "table_name": "log", "cle_primaire": { "Field": "id_log", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "log" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_log", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "ip", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "params", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "token", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "titre", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "description", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "pointage", "description": [ "id_pointage", "ip", "longitude", "latitude", "id_utilisateur_entreprise", "id_session", "createdAt" ], "table_descriptions": { "table_name": "pointage", "cle_primaire": { "Field": "id_pointage", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "pointage" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_pointage", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "ip", "Type": "varchar(15)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "longitude", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "latitude", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "id_utilisateur_entreprise", "Type": "int(11)", "Null": "NO", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_session", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "createdAt", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "privilege", "description": [ "id_privilege", "libelle", "description", "les_droits", "created_at" ], "table_descriptions": { "table_name": "privilege", "cle_primaire": { "Field": "id_privilege", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "privilege" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_privilege", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "libelle", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "description", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "les_droits", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "transaction_compte", "description": [ "id_transaction_compte", "type", "id_compte", "montant", "created_at", "id_mode_de_paiement", "designation", "jour", "date" ], "table_descriptions": { "table_name": "transaction_compte", "cle_primaire": { "Field": "id_transaction_compte", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "transaction_compte" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_transaction_compte", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "type", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "id_compte", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "montant", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "id_mode_de_paiement", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "designation", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "jour", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "utilisateur", "description": [ "id_utilisateur", "id_auteur", "prenom", "nom", "civilite", "telephone", "adresse", "email", "password", "created_at", "createdAt" ], "table_descriptions": { "table_name": "utilisateur", "cle_primaire": { "Field": "id_utilisateur", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "utilisateur" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_utilisateur", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_auteur", "Type": "int(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "prenom", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nom", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "civilite", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "adresse", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "email", "Type": "varchar(100)", "Null": "YES", "Key": "UNI", "Default": null, "Extra": "", "explications": "" }, { "Field": "password", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "createdAt", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "utilisateur_entreprise", "description": [ "id_utilisateur_entreprise", "id_privilege", "id_utilisateur", "id_entreprise", "created_at", "updated_at" ], "table_descriptions": { "table_name": "utilisateur_entreprise", "cle_primaire": { "Field": "id_utilisateur_entreprise", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "utilisateur_entreprise" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_utilisateur_entreprise", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "id_privilege", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_utilisateur", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "id_entreprise", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] } ] }, { "module": "public", "les_tables": [ { "table": "login", "description": [ "login", "pwd" ], "les_types": [ "login" ] } ] } ] }

Service angular api.service.ts

Instalations à faire

Créez un service dans votre projet Angular nommé api.service.ts avec le contenu suivant :

import { HttpClient, HttpHeaders } from '@angular/common/http'; import { Injectable } from '@angular/core'; import { Router } from '@angular/router'; import { JwtHelperService } from '@auth0/angular-jwt'; import * as moment from 'moment'; @Injectable({ providedIn: 'root' }) export class ApiService { local_storage_prefixe = "prefix."; taf_base_url = "http://www.teste.bi.jant.tech//"; network: any = { token: undefined, status: true, message: "Aucun probléme détecté", } token: any = { token_key: null, token_decoded: null, user_connected: null, is_expired: null, date_expiration: null } constructor(private http: HttpClient, private route: Router) { } // sauvegardes async get_from_local_storage(key: string): Promise { let res: any = await localStorage.getItem(this.local_storage_prefixe + key); return JSON.parse(res) } async save_on_local_storage(key: string, value: any): Promise { await localStorage.setItem(this.local_storage_prefixe + key, JSON.stringify(value)); } async delete_from_local_storage(key: string) { await localStorage.setItem(this.local_storage_prefixe + key, 'null'); } async get_token() { //le token n'est pas encore chargé if (this.network.token == undefined) { this.network.token = await this.get_from_local_storage("token") if (this.network.token != undefined && this.network.token != null) {// token existant this.update_data_from_token()// mise a jour du token } } else {// token dèja chargé this.update_data_from_token()// mise a jour du token } return this.network.token } //les requetes http async taf_get(path: string, on_success: Function, on_error: Function) { let api_url = this.taf_base_url + path; const httpOptions = { headers: new HttpHeaders({ Authorization: "Bearer " + await this.get_token(), }) }; this.http.get(api_url, httpOptions).subscribe( (reponse: any) => {// on success on_success(reponse) }, (error: any) => {// on error this.on_taf_get_error(error, on_error) } ) } on_taf_get_error(error: any, on_error: Function) { this.network.status = false; this.network.message = error alert("Merci de vérifier votre connexion") on_error(error) } async taf_post(path: string, data_to_send: any, on_success: Function, on_error: Function) { let api_url = this.taf_base_url + path; const httpOptions = { headers: new HttpHeaders({ Authorization: "Bearer " + await this.get_token(), }) }; this.http.post(api_url, data_to_send, httpOptions).subscribe( (reponse: any) => {// on success on_success(reponse) }, (error: any) => {// on error this.on_taf_post_error(error, on_error) } ) } on_taf_post_error(error: any, on_error: any) { this.network.status = false; this.network.message = error alert("Merci de vérifier votre connexion") on_error(error) } async update_data_from_token() { let token_key = await this.get_from_local_storage("token") const helper = new JwtHelperService(); const decodedToken = helper.decodeToken(token_key); const expirationDate = helper.getTokenExpirationDate(token_key); const isExpired = helper.isTokenExpired(token_key); this.token = { token_key: token_key, token_decoded: decodedToken, user_connected: decodedToken.taf_data, is_expired: isExpired, date_expiration: expirationDate } if (this.token.is_expired) { this.on_token_expire() } } on_token_expire() { alert("Votre session s'est expiré! Veuillez vous connecter à nouveau") this.delete_from_local_storage("token") this.route.navigate(['/public/login']) } format_date(date_string: string) { return { full: moment(date_string).locale("fr").format("dddd Do MMMM YYYY"),// 27 février 2023 jma: moment(date_string).locale("fr").format("Do MMMM YYYY"),// jeudi ... jma2: moment(date_string).locale("fr").format("DD-MM-YYYY"),// 01-11-2023 jma3: moment(date_string).locale("fr").format("YYYY-MM-DD"),// 2023-10-21 full_datetime: moment(date_string).locale("fr").format("dddd Do MMMM YYYY à HH:mm"),// 27 février 2023 } } format_current_date() { return { full: moment().locale("fr").format("dddd Do MMMM YYYY"),// 27 février 2023 jma: moment().locale("fr").format("Do MMMM YYYY"),// jeudi ... jma2: moment().locale("fr").format("DD-MM-YYYY"),// 01-11-2023 full_datetime: moment().locale("fr").format("dddd Do MMMM YYYY à HH:mm"),// 27 février 2023 } } custom_menu() { let id_privilege = parseInt(this.token.token_decoded.taf_data.id_privilege) //2 console.log("id_privilege= ", id_privilege) this.menu = this.full_menu.filter((un_menu: any) => { un_menu.items = un_menu.items.filter((un_item: any) => { return un_item.privileges.indexOf(id_privilege) != -1 }) return un_menu.items.length > 0 }) } has_acces(route: string) { } }