28 require
'../../main.inc.php';
29 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
30 require_once DOL_DOCUMENT_ROOT.
'/comm/propal/class/propal.class.php';
31 require_once DOL_DOCUMENT_ROOT.
'/core/lib/propal.lib.php';
35 $hookmanager->initHooks(array(
'proposalindex'));
38 $langs->loadLangs(array(
'propal',
'companies'));
44 $socid =
GETPOST(
'socid',
'int');
45 if (isset($user->socid) && $user->socid > 0) {
47 $socid = $user->socid;
57 $propalstatic =
new Propal($db);
58 $companystatic =
new Societe($db);
61 $help_url =
"EN:Module_Commercial_Proposals|FR:Module_Propositions_commerciales|ES:Módulo_Presupuestos";
67 print
'<div class="fichecenter">';
68 print
'<div class="fichethirdleft">';
79 if (!empty($conf->propal->enabled)) {
80 $sql =
"SELECT p.rowid, p.ref, p.ref_client, p.total_ht, p.total_tva, p.total_ttc";
81 $sql .=
", s.rowid as socid, s.nom as name, s.client, s.canvas, s.code_client, s.code_fournisseur, s.email, s.entity, s.code_compta";
82 $sql .=
" FROM ".MAIN_DB_PREFIX.
"propal as p";
83 $sql .=
", ".MAIN_DB_PREFIX.
"societe as s";
84 if (empty($user->rights->societe->client->voir) && !$socid) {
85 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
87 $sql .=
" WHERE p.entity IN (".getEntity($propalstatic->element).
")";
88 $sql .=
" AND p.fk_soc = s.rowid";
89 $sql .=
" AND p.fk_statut =".Propal::STATUS_DRAFT;
90 if (empty($user->rights->societe->client->voir) && !$socid) {
91 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
94 $sql .=
" AND p.fk_soc = ".((int) $socid);
99 $num = $db->num_rows(
$resql);
100 $nbofloop = min($num, (empty($conf->global->MAIN_MAXLIST_OVERLOAD) ? 500 : $conf->global->MAIN_MAXLIST_OVERLOAD));
107 while ($i < $nbofloop) {
108 $obj = $db->fetch_object(
$resql);
110 $propalstatic->id = $obj->rowid;
111 $propalstatic->ref = $obj->ref;
112 $propalstatic->ref_client = $obj->ref_client;
113 $propalstatic->total_ht = $obj->total_ht;
114 $propalstatic->total_tva = $obj->total_tva;
115 $propalstatic->total_ttc = $obj->total_ttc;
117 $companystatic->id = $obj->socid;
118 $companystatic->name = $obj->name;
119 $companystatic->client = $obj->client;
120 $companystatic->code_client = $obj->code_client;
121 $companystatic->code_fournisseur = $obj->code_fournisseur;
122 $companystatic->canvas = $obj->canvas;
123 $companystatic->entity = $obj->entity;
124 $companystatic->email = $obj->email;
125 $companystatic->code_compta = $obj->code_compta;
127 print
'<tr class="oddeven">';
128 print
'<td class="nowrap">'.$propalstatic->getNomUrl(1).
'</td>';
129 print
'<td class="nowrap">'.$companystatic->getNomUrl(1,
'customer', 16).
'</td>';
130 print
'<td class="nowrap right">'.price(!empty($conf->global->MAIN_DASHBOARD_USE_TOTAL_HT) ? $obj->total_ht : $obj->total_ttc).
'</td>';
134 $total += (!empty($conf->global->MAIN_DASHBOARD_USE_TOTAL_HT) ? $obj->total_ht : $obj->total_ttc);
148 print
'<div class="fichetwothirdright">';
154 $sql =
"SELECT c.rowid, c.entity, c.ref, c.fk_statut, date_cloture as datec";
155 $sql .=
", s.nom as socname, s.rowid as socid, s.canvas, s.client, s.email, s.code_compta";
156 $sql .=
" FROM ".MAIN_DB_PREFIX.
"propal as c";
157 $sql .=
", ".MAIN_DB_PREFIX.
"societe as s";
158 if (empty($user->rights->societe->client->voir) && !$socid) {
159 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
161 $sql .=
" WHERE c.entity IN (".getEntity($propalstatic->element).
")";
162 $sql .=
" AND c.fk_soc = s.rowid";
165 $sql .=
" AND c.fk_soc = ".((int) $socid);
167 if (empty($user->rights->societe->client->voir) && !$socid) {
168 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
170 $sql .=
" ORDER BY c.tms DESC";
171 $sql .= $db->plimit($max, 0);
173 $resql = $db->query($sql);
175 $num = $db->num_rows(
$resql);
181 $obj = $db->fetch_object(
$resql);
183 $propalstatic->id = $obj->rowid;
184 $propalstatic->ref = $obj->ref;
186 $companystatic->id = $obj->socid;
187 $companystatic->name = $obj->socname;
188 $companystatic->client = $obj->client;
189 $companystatic->canvas = $obj->canvas;
190 $companystatic->email = $obj->email;
191 $companystatic->code_compta = $obj->code_compta;
195 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid;
197 print
'<tr class="oddeven">';
199 print
'<td width="20%" class="nowrap">';
200 print
'<table class="nobordernopadding">';
201 print
'<tr class="nocellnopadd">';
202 print
'<td width="96" class="nobordernopadding nowrap">'.$propalstatic->getNomUrl(1).
'</td>';
203 print
'<td width="16" class="nobordernopadding nowrap"></td>';
204 print
'<td width="16" class="nobordernopadding right">'.$formfile->getDocumentsLink($propalstatic->element, $filename, $filedir).
'</td>';
209 print
'<td>'.$companystatic->getNomUrl(1,
'customer').
'</td>';
210 print
'<td>'.dol_print_date($db->jdate($obj->datec),
'day').
'</td>';
211 print
'<td class="right">'.$propalstatic->LibStatut($obj->fk_statut, 3).
'</td>';
229 if (!empty($conf->propal->enabled) && $user->rights->propale->lire) {
230 $sql =
"SELECT s.nom as socname, s.rowid as socid, s.canvas, s.client, s.email, s.code_compta";
231 $sql .=
", p.rowid as propalid, p.entity, p.total_ttc, p.total_ht, p.ref, p.fk_statut, p.datep as dp, p.fin_validite as dfv";
232 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s";
233 $sql .=
", ".MAIN_DB_PREFIX.
"propal as p";
234 if (empty($user->rights->societe->client->voir) && !$socid) {
235 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
237 $sql .=
" WHERE p.fk_soc = s.rowid";
238 $sql .=
" AND p.entity IN (".getEntity($propalstatic->element).
")";
239 $sql .=
" AND p.fk_statut = ".Propal::STATUS_VALIDATED;
240 if (empty($user->rights->societe->client->voir) && !$socid) {
241 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
244 $sql .=
" AND s.rowid = ".((int) $socid);
246 $sql .=
" ORDER BY p.rowid DESC";
248 $resql = $db->query($sql);
251 $num = $db->num_rows(
$resql);
252 $nbofloop = min($num, (empty($conf->global->MAIN_MAXLIST_OVERLOAD) ? 500 : $conf->global->MAIN_MAXLIST_OVERLOAD));
257 while ($i < $nbofloop) {
258 $obj = $db->fetch_object(
$resql);
260 $propalstatic->id = $obj->propalid;
261 $propalstatic->ref = $obj->ref;
263 $companystatic->id = $obj->socid;
264 $companystatic->name = $obj->socname;
265 $companystatic->client = $obj->client;
266 $companystatic->canvas = $obj->canvas;
267 $companystatic->email = $obj->email;
268 $companystatic->code_compta = $obj->code_compta;
272 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->propalid;
274 $warning = ($db->jdate($obj->dfv) < ($now - $conf->propal->cloture->warning_delay)) ?
img_warning($langs->trans(
"Late")) :
'';
276 print
'<tr class="oddeven">';
279 print
'<td class="nowrap" width="140">';
280 print
'<table class="nobordernopadding">';
281 print
'<tr class="nocellnopadd">';
282 print
'<td class="nobordernopadding nowrap">'.$propalstatic->getNomUrl(1).
'</td>';
283 print
'<td width="18" class="nobordernopadding nowrap">'.$warning.
'</td>';
284 print
'<td width="16" align="center" class="nobordernopadding">'.$formfile->getDocumentsLink($propalstatic->element, $filename, $filedir).
'</td>';
289 print
'<td class="left">'.$companystatic->getNomUrl(1,
'customer', 44).
'</td>';
290 print
'<td class="right">'.dol_print_date($db->jdate($obj->dp),
'day').
'</td>';
291 print
'<td class="right">'.price(!empty($conf->global->MAIN_DASHBOARD_USE_TOTAL_HT) ? $obj->total_ht : $obj->total_ttc).
'</td>';
292 print
'<td align="center" width="14">'.$propalstatic->LibStatut($obj->fk_statut, 3).
'</td>';
297 $total += (!empty($conf->global->MAIN_DASHBOARD_USE_TOTAL_HT) ? $obj->total_ht : $obj->total_ttc);
461 $parameters = array(
'user' => $user);
462 $reshook = $hookmanager->executeHooks(
'dashboardPropals', $parameters, $object);