[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4818 - in phpcompta/tags/rel601: include sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r4818 - in phpcompta/tags/rel601: include sql |
Date: |
Tue, 1 May 2012 16:51:35 +0200 (CEST) |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r4818 - in phpcompta/tags/rel601: include sql,
phpcompta-dev <=