<?php
/* Copyright (C) 2004 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$
*
*/
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;
function BonPrelevement($DB, $filename)
{
$error = 0;
$this->db = $DB;
$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 = "";
return 1;
}
/*
*
*
*/
function Fetch($rowid)
{
$sql = "SELECT p.rowid, p.ref, p.amount, p.note, p.credite";
$sql .= ",".$this->db->pdate("p.datec")." as dc";
$sql .= " FROM ".MAIN_DB_PREFIX."prelevement as p";
$sql .= " WHERE p.rowid=".$rowid;
$result=$this->db->query($sql);
if ($result)
{
if ($this->db->num_rows($result))
{
$obj = $this->db->fetch_object();
$this->id = $obj->rowid;
$this->ref = $obj->ref;
$this->amount = $obj->amount;
$this->note = stripslashes($obj->note);
$this->datec = $obj->dc;
$this->credite = $obj->credite;
return 0;
}
else
{
dolibarr_syslog("bon-prelevment::Fetch Erreur aucune ligne retourn�e");
return -1;
}
}
else
{
dolibarr_syslog("bon-prelevment::Fetch Erreur ");
dolibarr_syslog($sql);
return -2;
}
}
/**
*
*
*/
function set_credite()
{
$error == 0;
if ($this->db->query("BEGIN"))
{
$sql = " UPDATE ".MAIN_DB_PREFIX."prelevement ";
$sql .= " SET credite = 1";
$sql .= " WHERE rowid=".$this->id;
$result=$this->db->query($sql);
if (! $result)
{
dolibarr_syslog("bon-prelevment::set_credite Erreur 1");
$error++;
}
if ($error == 0)
{
/**
*
*
*
*/
$facs = array();
$facs = $this->_get_list_factures();
for ($i = 0 ; $i < sizeof($facs) ; $i++)
{
$fac = new Facture($this->db);
/* Tag la facture comme impay�e */
dolibarr_syslog("RejetPrelevement::Create set_payed fac ".$facs[$i]);
$fac->set_payed($facs[$i]);
}
}
if ($error == 0)
{
/*
* Change le statut des lignes de factures
*/
$sql = " UPDATE ".MAIN_DB_PREFIX."prelevement_facture ";
$sql .= " SET statut = 1";
$sql .= " WHERE fk_prelevement=".$this->id;
$result=$this->db->query($sql);
if (!$result)
{
dolibarr_syslog("bon-prelevment::set_credite Erreur 3");
$error++;
}
}
/*
* Fin de la proc�dure
*
*/
if ($error == 0)
{
$this->db->query("COMMIT");
return 0;
}
else
{
$this->db->query("ROLLBACK");
dolibarr_syslog("bon-prelevment::set_credite ROLLBACK ");
return -1;
}
}
else
{
dolibarr_syslog("bon-prelevment::set_credite Ouverture transaction SQL impossible ");
return -2;
}
}
/**
* \brief Recup�re la liste des factures concern�es
* \param rowid id de la facture a r�cup�rer
* \param societe_id id de societe
*/
function _get_list_factures()
{
$arr = array();
/*
* Renvoie toutes les factures pr�sente
* dans un bon de pr�l�vement
*/
$sql = "SELECT f.rowid as facid";
$sql .= " FROM ".MAIN_DB_PREFIX."prelevement_facture as pf";
$sql .= " WHERE pf.fk_prelevement = ".$this->id;
$result=$this->db->query($sql);
if ($result)
{
$num = $this->db->num_rows();
if ($num)
{
$i = 0;
while ($i < $num)
{
$row = $this->db->fetch_row();
$arr[$i] = $row[0];
$i++;
}
}
$this->db->free();
}
else
{
dolibarr_syslog("Prelevement Erreur");
}
return $arr;
}
/*
*
*
*/
function Generate()
{
$this->EnregEmetteur();
$nbfactures = sizeof($this->factures);
$this->total = 0;
for ($i = 0 ; $i < $nbfactures ; $i++)
{
$fac = new Facture($this->db);
$fac->fetch($this->factures[$i]);
$fac->fetch_client();
$fac->client->rib(); // Set client->bank_account
if ($fac->client->bank_account->verif())
{
$this->total = $this->total + $fac->total_ttc;
$this->EnregDestinataire($fac);
}
else
{
print $fac->client->bank_account->error_message;
print $fac->client->nom;
}
}
$this->EnregTotal($this->total);
fclose($this->file);
}
/*
*
*
*/
function EnregEmetteur()
{
fputs ($this->file, "03");
fputs ($this->file, "08"); // Pr�l�vement ordinaire
fputs ($this->file, " "); // Zone R�serv�e B2
fputs ($this->file, $this->numero_national_emetteur); // Num�ro National d'emmetteur B3
// Date d'�ch�ance C1
fputs ($this->file, " ");
fputs ($this->file, strftime("%d%m", $this->date_echeance));
fputs ($this->file, substr(strftime("%y", $this->date_echeance),1));
// Raison Sociale C2
fputs ($this->file, substr($this->raison_sociale. " ",0,24));
// Reference de la remise cr�ancier D1 sur 7 caract�res
fputs ($this->file, substr($this->reference_remise. " ",0,7));
// Zone R�serv�e D1-2
fputs ($this->file, substr(" ",0,17));
// Zone R�serv�e D2
fputs ($this->file, substr(" ",0,2));
fputs ($this->file, "E");
fputs ($this->file, substr(" ",0,5));
// Code Guichet D3
fputs ($this->file, $this->emetteur_code_guichet);
// Numero de compte D4
fputs ($this->file, substr("000000000000000".$this->emetteur_numero_compte, -11));
// Zone R�serv�e E
fputs ($this->file, substr(" ",0,16));
// Zone R�serv�e F
fputs ($this->file, substr(" ",0,31));
// Code �tablissement
fputs ($this->file, $this->emetteur_code_etablissement);
// Zone R�serv�e G
fputs ($this->file, substr(" ",0,5));
fputs ($this->file, "\n");
}
/*
* Enregistrements destinataires
*
*
*/
function EnregDestinataire($fac)
{
fputs ($this->file, "06");
fputs ($this->file, "08"); // Pr�l�vement ordinaire
fputs ($this->file, " "); // Zone R�serv�e B2
fputs ($this->file, $this->numero_national_emetteur); // Num�ro National d'emmetteur B3
// Date d'�ch�ance C1
fputs ($this->file, " ");
fputs ($this->file, strftime("%d%m", $this->date_echeance));
fputs ($this->file, substr(strftime("%y", $this->date_echeance),1));
// Raison Sociale Destinataire C2
fputs ($this->file, substr($fac->client->nom. " ",0,24));
// Reference de la remise cr�ancier D1
fputs ($this->file, substr(" ",0,24));
// Zone R�serv�e D2
fputs ($this->file, substr(" ",0,8));
// Code Guichet D3
fputs ($this->file, $fac->client->bank_account->code_guichet);
// Numero de compte D4
fputs ($this->file, substr("000000000000000".$fac->client->bank_account->number, -11));
// Zone E Montant
$montant = (round($fac->total_ttc,2) * 100);
fputs ($this->file, substr("000000000000000".$montant, -16));
// Libell� F
fputs ($this->file, substr("*".$fac->ref." ",0,13));
fputs ($this->file, substr(" ",0,18));
// Code �tablissement G1
fputs ($this->file, $fac->client->bank_account->code_banque);
// Zone R�serv�e G2
fputs ($this->file, substr(" ",0,5));
fputs ($this->file, "\n");
}
function EnregTotal($total)
{
fputs ($this->file, "08");
fputs ($this->file, "08"); // Pr�l�vement ordinaire
fputs ($this->file, " "); // Zone R�serv�e B2
fputs ($this->file, $this->numero_national_emetteur); // Num�ro National d'emmetteur B3
// R�serv� C1
fputs ($this->file, substr(" ",0,12));
// Raison Sociale C2
fputs ($this->file, substr(" ",0,24));
// D1
fputs ($this->file, substr(" ",0,24));
// Zone R�serv�e D2
fputs ($this->file, substr(" ",0,8));
// Code Guichet D3
fputs ($this->file, substr(" ",0,5));
// Numero de compte D4
fputs ($this->file, substr(" ",0,11));
// Zone E Montant
$montant = ($total * 100);
fputs ($this->file, substr("000000000000000".$montant, -16));
// Zone R�serv�e F
fputs ($this->file, substr(" ",0,31));
// Code �tablissement
fputs ($this->file, substr(" ",0,5));
// Zone R�serv�e F
fputs ($this->file, substr(" ",0,5));
fputs ($this->file, "\n");
}
}
?>