Changeset 71553 in spip-zone for _plugins_/factures/trunk/base

Timestamp:

Apr 4, 2013, 9:32:56 AM (8 years ago)

Author:

cyril@…

Message:

Ajout de la table des lignes de factures

File:

• _plugins_/factures/trunk/base/factures.php (modified) (2 diffs)

_plugins_/factures/trunk/base/factures.php

@@ -25 +25 @@
 
         $interfaces['table_des_tables']['factures'] = 'factures';
+        $interfaces['table_des_tables']['lignes_factures'] = 'lignes_factures';
 
         return $interfaces;
@@ -74 +75 @@
         );
 
+        $tables['spip_lignes_factures'] = array(
+                'type' => 'ligne',
+                'principale' => "oui", 
+                'table_objet_surnoms' => array('lignesfacture'), // table_objet('ligne') => 'lignes_factures' 
+                'field'=> array(
+                        "id_ligne"           => "bigint(21) NOT NULL",
+                        "id_facture"         => "int(11) NOT NULL DEFAULT '0'",
+                        "position"           => "int(11) DEFAULT NULL",
+                        "quantite"           => "float DEFAULT NULL",
+                        "unite"              => "varchar(50) DEFAULT NULL",
+                        "designation"        => "text",
+                        "prix_unitaire_ht"   => "decimal(18,2) DEFAULT NULL",
+                        "commentaire"        => "mediumtext",
+                        "maj"                => "TIMESTAMP"
+                ),
+                'key' => array(
+                        "PRIMARY KEY"        => "id_ligne",
+                ),
+                'titre' => "'' AS titre, '' AS lang",
+                 #'date' => "",
+                'champs_editables'  => array(),
+                'champs_versionnes' => array(),
+                'rechercher_champs' => array(),
+                'tables_jointures'  => array(),
+                
+
+        );
+
         return $tables;
 }