bon-prelevement.class.php

<?php
/* Copyright (C) 2004-2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
 *
 * This program 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.
 *
 * This program 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 this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 *
 * $Id$
 * $Source$
 */

/**
        \file       htdocs/bon-prelevement.class.php
        \ingroup    prelevement
        \brief      Fichier de la classe des bons de prlvements
        \version    $Revision$
*/


require_once (DOL_DOCUMENT_ROOT."/facture.class.php");
require_once (DOL_DOCUMENT_ROOT."/societe.class.php");

class BonPrelevement
{
  var $db;

  var $date_echeance;
  var $raison_sociale;
  var $reference_remise;
  var $emetteur_code_guichet;
  var $emetteur_numero_compte;
  var $emetteur_code_etablissement;
  var $total;
  var $_fetched;

  function BonPrelevement($DB, $filename='') 
    {
      $error = 0;
      $this->db = $DB;

      if (strlen($filename))
	{    
	  $this->file = fopen ($filename,"w");
	}
      
      $this->date_echeance = time();
      $this->raison_sociale = "";
      $this->reference_remise = "";

      $this->emetteur_code_guichet = "";
      $this->emetteur_numero_compte = "";
      $this->emetteur_code_etablissement = "";

      $this->factures = array();

      $this->numero_national_emetteur = "";

      $this->methodes_trans = array();

      $this->methodes_trans[0] = "Internet";

      $this->_fetched = 0;

      return 1;
    }
  /*
   *
   *
   *
   */
  function AddFacture($facture_id, $client_id, $client_nom, $amount, $code_banque, $code_guichet, $number)
  {
    $result = 0;
    $ligne_id = 0;

    $result = $this->AddLigne($ligne_id, $client_id, $client_nom, 
			      $amount, $code_banque, $code_guichet, $number);
    
    if ($result == 0)
      {	
	if ($ligne_id > 0)
	  {	    
	    $sql = "INSERT INTO ".MAIN_DB_PREFIX."prelevement_facture ";
	    $sql .= " (fk_facture,fk_prelevement_lignes)";
	    $sql .= " VALUES (".$facture_id.",".$ligne_id.")";
	    
	    if ($this->db->query($sql))
	      {      
		$result = 0;	
	      }
	    else
	      {
		$result = -1;
		dolibarr_syslog("BonPrelevement::AddFacture Erreur $result");
	      }
	  }
	else
	  {
	    $result = -2;
	    dolibarr_syslog("BonPrelevement::AddFacture Erreur $result");
	  }
      }
    else
      {
	$result = -3;
	dolibarr_syslog("BonPrelevement::AddFacture Erreur $result");
      }

    return $result;

  }
  /*
   *
   *
   */
  function AddLigne(&$ligne_id, $client_id, $client_nom, $amount, $code_banque, $code_guichet, $number)
  {
    $result = -1;
    $concat = 0;

    if ($concat == 1)
      {
	/*
	 * On aggrge les lignes 
	 */
	$sql = "SELECT rowid FROM  ".MAIN_DB_PREFIX."prelevement_lignes";
	$sql .= " WHERE fk_prelevement_bons".$this->id;
	$sql .= " AND fk_soc       =".$client_id;
	$sql .= " AND code_banque  ='".$code_banque."'";
	$sql .= " AND code_guichet ='".$code_guichet."'";
	$sql .= " AND number       ='".$number."'";

	if ($this->db->query($sql))
	  {
	    $num = $this->db->num_rows();
	  }
	else
	  {
	    $result = -1;
	  }
      }
    else
      {
	/*
	 * Pas de d'agrgation
	 */
	$sql = "INSERT INTO ".MAIN_DB_PREFIX."prelevement_lignes (fk_prelevement_bons";
	$sql .= " , fk_soc , client_nom ";
	$sql .= " , amount";
	$sql .= " , code_banque , code_guichet , number)";

	$sql .= " VALUES (".$this->id;
	$sql .= ",".$client_id.",'".addslashes($client_nom)."'";
	$sql .= ",'".ereg_replace(",",".",$amount)."'";
	$sql .= ", '$code_banque', '$code_guichet', '$number')";

	if ($this->db->query($sql))
	  {
	    $ligne_id = $this->db->last_insert_id(MAIN_DB_PREFIX."prelevement_lignes");
	    $result = 0;
	  }
	else
	  {
	    dolibarr_syslog("BonPrelevement::AddLigne Erreur -2");
	    $result = -2;
	  }

      }

    return $result; 
  }
  /*
   *
   *
   */
  function ReadError($error)
  {
    $errors = array();

    $errors[1027] = "Date invalide";

    return $errors[abs($error)];
  }
  /*
   *
   *
   */
  function Fetch($rowid)
  {
    $sql = "SELECT p.rowid, p.ref, p.amount, p.note, p.credite";