[Phpcompta-dev] r4818 - in phpcompta/tags/rel601: include sql

[phpcompta-dev]

Author: danydb
Date: 2012-05-01 16:51:35 +0200 (Tue, 01 May 2012)
New Revision: 4818

Added:
   phpcompta/tags/rel601/include/bank.inc.php
   phpcompta/tags/rel601/include/class_bank.php
Modified:
   phpcompta/tags/rel601/sql/upgrade.sql
Log:
#568: Impossible d'ajouter une fiche BANQUE dans ADM


Added: phpcompta/tags/rel601/include/bank.inc.php
===================================================================
--- phpcompta/tags/rel601/include/bank.inc.php                          (rev 0)
+++ phpcompta/tags/rel601/include/bank.inc.php  2012-05-01 14:51:35 UTC (rev 
4818)
@@ -0,0 +1,146 @@
+<?php
+/*
+ *   This file is part of PhpCompta.
+ *
+ *   PhpCompta is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ *   PhpCompta is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *   GNU General Public License for more details.
+ *
+ *   You should have received a copy of the GNU General Public License
+ *   along with PhpCompta; if not, write to the Free Software
+ *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+*/
+/* $Revision: 4701 $ */
+// Copyright Author Dany De Bontridder address@hidden
+/*!\brief include from supplier.inc.php and concerned only the supplier card 
and
+ * the supplier category
+ */
+require_once("class_iselect.php");
+require_once("class_ihidden.php");
+require_once("class_bank.php");
+require_once("class_ibutton.php");
+require_once('class_iaction.php');
+global $g_user;
+
+$low_action=(isset($_REQUEST['sb']))?$_REQUEST['sb']:"list";
+/*! \file
+ * \brief Called from the module "Gestion" to manage the supplier
+ */
+$href=basename($_SERVER['PHP_SELF']);
+
+// by default open liste
+if ( $low_action  == "" )
+    $low_action="list";
+
+
+//-----------------------------------------------------
+// Remove a card
+//-----------------------------------------------------
+if ( isset($_POST['delete_card'] ) )
+{
+    if ( $g_user->check_action(FICADD) == 0 )
+    {
+        alert('Vous  ne pouvez pas enlever de fiche');
+        return;
+    }
+
+    $f_id=$_REQUEST['f_id'];
+
+    $fiche=new Bank($cn,$f_id);
+    $fiche->remove();
+    $low_action="list";
+
+}
+
+//-----------------------------------------------------
+//    list of supplier
+//-----------------------------------------------------
+if ( $low_action == "list" )
+{
+
+    ?>
+    <div class="content">
+                           <div>
+                                        <form method="get" action="<?php echo 
$href; ?>">
+                                                                  <?php
+                                                                  echo 
dossier::hidden();
+    $a=(isset($_GET['query']))?$_GET['query']:"";
+    printf (_('Recherche').' <input class="input_text" type="text" 
name="query" value="%s">',
+            $a);
+    $sel_card=new ISelect('cat');
+    $sel_card->value=$cn->make_array('select fd_id, fd_label from fiche_def '.
+                                     ' where  frd_id='.FICHE_TYPE_FIN.
+                                     ' order by fd_label ',1);
+    $sel_card->selected=(isset($_GET['cat']))?$_GET['cat']:-1;
+    $sel_card->javascript=' onchange="submit(this);"';
+    echo _('Catégorie :').$sel_card->input();
+    $nooperation=new ICheckBox('noop');
+    $nooperation->selected=(isset($_GET['noop']))?true:false;
+    echo _('Inclure les banques sans opération :').$nooperation->input();
+
+    ?>
+    <input type="submit" class="button" name="submit_query" 
value="<?=_('recherche')?>">
+                                           <input type="hidden" name="ac" 
value="<?=$_REQUEST['ac']?>">
+                                                                     </form>
+                                                                     </div>
+                                                                     <?php
+                                                                     
$supplier=new Bank($cn);
+    $search=(isset($_GET['query']))?$_GET['query']:"";
+    $sql="";
+    if ( isset($_GET['cat']))
+{
+        if ( $_GET['cat'] != -1) $sql=sprintf(" and fd_id = %d",$_GET['cat']);
+    }
+    $noop=(isset($_GET['noop']))?false:true;
+
+    echo '<div class="content">';
+    echo $supplier->Summary($search,'supplier',$sql,$noop);
+
+
+    echo '<br>';
+    echo '<br>';
+    echo '<br>';
+       if  ($g_user->check_action(FICADD)==1)
+       {
+               /* Add button */
+               $f_add_button=new IButton('add_card');
+               $f_add_button->label=_('Créer une nouvelle fiche');
+               $f_add_button->set_attribute('win_refresh','yes');
+
+               $f_add_button->set_attribute('type_cat',FICHE_TYPE_FIN);
+               $f_add_button->javascript=" select_card_type(this);";
+               echo $f_add_button->input();
+
+               $f_cat_button=new IButton('add_cat');
+               $f_cat_button->set_attribute('type_cat',FICHE_TYPE_FIN);
+               $f_cat_button->label=_('Ajout d\'une catégorie');
+               $f_cat_button->javascript='add_category(this)';
+               echo $f_cat_button->input();
+       }
+
+    echo '</div>';
+    echo '</div>';
+
+
+}
+/*----------------------------------------------------------------------
+ * Detail for a card, Suivi, Contact, Operation,... *
+ * cc stands for supplier card
+ *----------------------------------------------------------------------*/
+if ( $low_action == 'detail')
+{
+    /* Menu */
+    require_once('category_card.inc.php');
+    exit();
+}
+
+
+
+html_page_stop();
+?>

Added: phpcompta/tags/rel601/include/class_bank.php
===================================================================
--- phpcompta/tags/rel601/include/class_bank.php                                
(rev 0)
+++ phpcompta/tags/rel601/include/class_bank.php        2012-05-01 14:51:35 UTC 
(rev 4818)
@@ -0,0 +1,59 @@
+<?php
+/*
+ *   This file is part of PhpCompta.
+ *
+ *   PhpCompta is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ *   PhpCompta is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *   GNU General Public License for more details.
+ *
+ *   You should have received a copy of the GNU General Public License
+ *   along with PhpCompta; if not, write to the Free Software
+ *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+*/
+/* $Revision: 4267 $ */
+// Copyright Author Dany De Bontridder address@hidden
+require_once("constant.php");
+require_once('class_database.php');
+require_once("class_acc_parm_code.php");
+
+require_once('class_fiche.php');
+require_once('class_acc_account_ledger.php');
+require_once('user_common.php');
+/*! \file
+ * \brief Derived from class fiche Administration are a specific kind of card
+ *        concerned only by official (or not) administration
+ */
+/*!
+ * \brief  class  admin are a specific kind of card
+ */
+
+// Use the view vw_supplier
+//
+class Bank extends Fiche
+{
+
+    var $name;        /*!< $name name of the company */
+    var $street;      /*!< $street Street */
+    var $country;     /*!< $country Country */
+    var $cp;          /*!< $cp Zip code */
+    var $vat_number;  /*!< $vat_number vat number */
+
+    /*! \brief Constructor
+    /* only a db connection is needed */
+    function __construct($p_cn,$p_id=0)
+    {
+        $this->fiche_def_ref=FICHE_TYPE_FIN;
+        parent::__construct($p_cn,$p_id) ;
+    }
+
+
+
+}
+
+?>

Modified: phpcompta/tags/rel601/sql/upgrade.sql
===================================================================
--- phpcompta/tags/rel601/sql/upgrade.sql       2012-05-01 14:49:39 UTC (rev 
4817)
+++ phpcompta/tags/rel601/sql/upgrade.sql       2012-05-01 14:51:35 UTC (rev 
4818)
@@ -37,3 +37,16 @@
   LANGUAGE plpgsql;
 
 update op_predef set od_direct='t' where od_jrn_type='ODS';
+
+INSERT INTO menu_ref(
+            me_code, me_menu, me_file, me_url, me_description, me_parameter,
+            me_javascript, me_type)
+    VALUES ('BK', 'Banque', 'bank.inc.php', null, 'Information Banque', 
null,null,'ME');
+
+INSERT INTO profile_menu(
+             me_code, me_code_dep, p_id, p_order, p_type_display, pm_default)
+    VALUES ('BK', 'GESTION', 1, 4, 'E', 0);
+INSERT INTO profile_menu(
+             me_code, me_code_dep, p_id, p_order, p_type_display, pm_default)
+    VALUES ('BK', 'GESTION', 2, 4, 'E', 0);
+



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu