1<?php
2/* Copyright (C) 2003-2007 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2004-2009 Laurent Destailleur  <eldy@users.sourceforge.net>
4 * Copyright (C) 2005-2009 Regis Houssin        <regis.houssin@inodbox.com>
5 * Copyright (C) 2015      Frederic France      <frederic.france@free.fr>
6 *
7 * This program is free software; you can redistribute it and/or modify
8 * it under the terms of the GNU General Public License as published by
9 * the Free Software Foundation; either version 3 of the License, or
10 * (at your option) any later version.
11 *
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
15 * GNU General Public License for more details.
16 *
17 * You should have received a copy of the GNU General Public License
18 * along with this program. If not, see <https://www.gnu.org/licenses/>.
19 */
20
21/**
22 *	\file       htdocs/core/boxes/box_factures.php
23 *	\ingroup    factures
24 *	\brief      Module de generation de l'affichage de la box factures
25 */
26include_once DOL_DOCUMENT_ROOT.'/core/boxes/modules_boxes.php';
27
28/**
29 * Class to manage the box to show last invoices
30 */
31class box_factures extends ModeleBoxes
32{
33	public $boxcode = "lastcustomerbills";
34	public $boximg = "object_bill";
35	public $boxlabel = "BoxLastCustomerBills";
36	public $depends = array("facture");
37
38	/**
39	 * @var DoliDB Database handler.
40	 */
41	public $db;
42
43	public $param;
44
45	public $info_box_head = array();
46	public $info_box_contents = array();
47
48
49	/**
50	 *  Constructor
51	 *
52	 *  @param  DoliDB  $db         Database handler
53	 *  @param  string  $param      More parameters
54	 */
55	public function __construct($db, $param)
56	{
57		global $user;
58
59		$this->db = $db;
60
61		$this->hidden = !($user->rights->facture->lire);
62	}
63
64	/**
65	 *  Load data into info_box_contents array to show array later.
66	 *
67	 *  @param	int		$max        Maximum number of records to load
68	 *  @return	void
69	 */
70	public function loadBox($max = 5)
71	{
72		global $conf, $user, $langs;
73
74		$this->max = $max;
75
76		include_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php';
77		include_once DOL_DOCUMENT_ROOT.'/societe/class/societe.class.php';
78
79		$facturestatic = new Facture($this->db);
80		$societestatic = new Societe($this->db);
81
82		$langs->load("bills");
83
84		$text = $langs->trans("BoxTitleLast".($conf->global->MAIN_LASTBOX_ON_OBJECT_DATE ? "" : "Modified")."CustomerBills", $max);
85		$this->info_box_head = array(
86			'text' => $text,
87			'limit'=> dol_strlen($text)
88		);
89
90		if ($user->rights->facture->lire) {
91			$sql = "SELECT f.rowid as facid";
92			$sql .= ", f.ref, f.type, f.total as total_ht";
93			$sql .= ", f.tva as total_tva";
94			$sql .= ", f.total_ttc";
95			$sql .= ", f.datef as df";
96			$sql .= ", f.paye, f.fk_statut as status, f.datec, f.tms";
97			$sql .= ", f.date_lim_reglement as datelimite";
98			$sql .= ", s.rowid as socid, s.nom as name, s.name_alias";
99			$sql .= ", s.code_client, s.code_compta, s.client";
100			$sql .= ", s.logo, s.email, s.entity";
101			$sql .= ", s.tva_intra, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6";
102			$sql .= " FROM (".MAIN_DB_PREFIX."societe as s,".MAIN_DB_PREFIX."facture as f";
103			if (!$user->rights->societe->client->voir && !$user->socid) $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
104			$sql .= ")";
105			$sql .= " WHERE f.fk_soc = s.rowid";
106			$sql .= " AND f.entity IN (".getEntity('invoice').")";
107			if (!$user->rights->societe->client->voir && !$user->socid) $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = ".$user->id;
108			if ($user->socid)	$sql .= " AND s.rowid = ".$user->socid;
109			if ($conf->global->MAIN_LASTBOX_ON_OBJECT_DATE) $sql .= " ORDER BY f.datef DESC, f.ref DESC ";
110			else $sql .= " ORDER BY f.tms DESC, f.ref DESC ";
111			$sql .= $this->db->plimit($max, 0);
112
113			$result = $this->db->query($sql);
114			if ($result)
115			{
116				$num = $this->db->num_rows($result);
117				$now = dol_now();
118
119				$line = 0;
120				$l_due_date = $langs->trans('Late').' ('.$langs->trans('DateDue').': %s)';
121
122				while ($line < $num) {
123					$objp = $this->db->fetch_object($result);
124					$datelimite = $this->db->jdate($objp->datelimite);
125					$date = $this->db->jdate($objp->df);
126					$datem = $this->db->jdate($objp->tms);
127
128					$facturestatic->id = $objp->facid;
129					$facturestatic->ref = $objp->ref;
130					$facturestatic->type = $objp->type;
131					$facturestatic->total_ht = $objp->total_ht;
132					$facturestatic->total_tva = $objp->total_tva;
133					$facturestatic->total_ttc = $objp->total_ttc;
134					$facturestatic->statut = $objp->status;
135					$facturestatic->status = $objp->status;
136					$facturestatic->date_lim_reglement = $this->db->jdate($objp->datelimite);
137					$facturestatic->alreadypaid = $objp->paye;
138
139					$societestatic->id = $objp->socid;
140					$societestatic->name = $objp->name;
141					//$societestatic->name_alias = $objp->name_alias;
142					$societestatic->code_client = $objp->code_client;
143					$societestatic->code_compta = $objp->code_compta;
144					$societestatic->client = $objp->client;
145					$societestatic->logo = $objp->logo;
146					$societestatic->email = $objp->email;
147					$societestatic->entity = $objp->entity;
148					$societestatic->tva_intra = $objp->tva_intra;
149					$societestatic->idprof1 = $objp->idprof1;
150					$societestatic->idprof2 = $objp->idprof2;
151					$societestatic->idprof3 = $objp->idprof3;
152					$societestatic->idprof4 = $objp->idprof4;
153					$societestatic->idprof5 = $objp->idprof5;
154					$societestatic->idprof6 = $objp->idprof6;
155
156					$late = '';
157					if ($facturestatic->hasDelay()) {
158						$late = img_warning(sprintf($l_due_date, dol_print_date($datelimite, 'day')));
159					}
160
161					$this->info_box_contents[$line][] = array(
162						'td' => 'class="nowraponall"',
163						'text' => $facturestatic->getNomUrl(1),
164						'text2'=> $late,
165						'asis' => 1,
166					);
167
168					$this->info_box_contents[$line][] = array(
169						'td' => 'class="tdoverflowmax200"',
170						'text' => $societestatic->getNomUrl(1, '', 40),
171						'asis' => 1,
172					);
173
174					$this->info_box_contents[$line][] = array(
175						'td' => 'class="right nowraponall"',
176						'text' => price($objp->total_ht, 0, $langs, 0, -1, -1, $conf->currency),
177					);
178
179					$this->info_box_contents[$line][] = array(
180						'td' => 'class="right"',
181						'text' => dol_print_date($date, 'day'),
182					);
183
184					$this->info_box_contents[$line][] = array(
185						'td' => 'class="right" width="18"',
186						'text' => $facturestatic->LibStatut($objp->paye, $objp->status, 3, $objp->paye),
187					);
188
189					$line++;
190				}
191
192				if ($num == 0)
193					$this->info_box_contents[$line][0] = array(
194						'td' => 'class="center"',
195						'text'=>$langs->trans("NoRecordedInvoices"),
196					);
197
198				$this->db->free($result);
199			} else {
200				$this->info_box_contents[0][0] = array(
201					'td' => '',
202					'maxlength'=>500,
203					'text' => ($this->db->error().' sql='.$sql),
204				);
205			}
206		} else {
207			$this->info_box_contents[0][0] = array(
208				'td' => 'class="nohover opacitymedium left"',
209				'text' => $langs->trans("ReadPermissionNotAllowed")
210			);
211		}
212	}
213
214	/**
215	 *  Method to show box
216	 *
217	 *  @param  array   $head       Array with properties of box title
218	 *  @param  array   $contents   Array with properties of box lines
219	 *  @param	int		$nooutput	No print, only return string
220	 *	@return	string
221	 */
222	public function showBox($head = null, $contents = null, $nooutput = 0)
223	{
224		return parent::showBox($this->info_box_head, $this->info_box_contents, $nooutput);
225	}
226}
227