27 require
'../main.inc.php';
28 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
29 require_once DOL_DOCUMENT_ROOT.
'/supplier_proposal/class/supplier_proposal.class.php';
34 $hookmanager->initHooks(array(
'suppliersproposalsindex'));
37 $langs->loadLangs(array(
'supplier_proposal',
'companies'));
40 $socid =
GETPOST(
'socid',
'int');
41 if (isset($user->socid) && $user->socid > 0) {
43 $socid = $user->socid;
53 $companystatic =
new Societe($db);
56 $help_url =
"EN:Module_Ask_Price_Supplier|FR:Module_Demande_de_prix_fournisseur";
60 print
load_fiche_titre($langs->trans(
"SupplierProposalArea"),
'',
'supplier_proposal');
62 print
'<div class="fichecenter"><div class="fichethirdleft">';
66 $sql =
"SELECT count(p.rowid), p.fk_statut";
67 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s";
68 $sql .=
", ".MAIN_DB_PREFIX.
"supplier_proposal as p";
69 if (empty($user->rights->societe->client->voir) && !$socid) {
70 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
72 $sql .=
" WHERE p.fk_soc = s.rowid";
73 $sql .=
" AND p.entity IN (".getEntity(
'supplier_proposal').
")";
75 $sql .=
' AND p.fk_soc = '.((int) $user->socid);
77 if (empty($user->rights->societe->client->voir) && !$socid) {
78 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
80 $sql .=
" AND p.fk_statut IN (0,1,2,3,4)";
81 $sql .=
" GROUP BY p.fk_statut";
84 $num = $db->num_rows(
$resql);
89 $dataseries = array();
90 $colorseries = array();
94 $row = $db->fetch_row(
$resql);
98 $vals[$row[1]] = $row[0];
99 $totalinprocess += $row[0];
107 include DOL_DOCUMENT_ROOT.
'/theme/'.$conf->theme.
'/theme_vars.inc.php';
109 print
'<div class="div-table-responsive-no-min">';
110 print
'<table class="noborder centpercent">';
111 print
'<tr class="liste_titre"><th colspan="2">'.$langs->trans(
"Statistics").
' - '.$langs->trans(
"CommRequests").
'</th></tr>'.
"\n";
112 $listofstatus = array(0, 1, 2, 3, 4);
113 foreach ($listofstatus as $status) {
114 $dataseries[] = array($supplier_proposalstatic->LibStatut($status, 1), (isset($vals[$status]) ? (
int) $vals[$status] : 0));
116 $colorseries[$status] =
'-'.$badgeStatus0;
119 $colorseries[$status] = $badgeStatus1;
122 $colorseries[$status] = $badgeStatus4;
125 $colorseries[$status] = $badgeStatus9;
128 $colorseries[$status] = $badgeStatus6;
131 if (empty($conf->use_javascript_ajax)) {
132 print
'<tr class="oddeven">';
133 print
'<td>'.$supplier_proposalstatic->LibStatut($status, 0).
'</td>';
134 print
'<td class="right"><a href="list.php?statut='.$status.
'">'.(isset($vals[$status]) ? $vals[$status] : 0).
'</a></td>';
138 if ($conf->use_javascript_ajax) {
139 print
'<tr><td class="center" colspan="2">';
141 include_once DOL_DOCUMENT_ROOT.
'/core/class/dolgraph.class.php';
143 $dolgraph->SetData($dataseries);
144 $dolgraph->SetDataColor(array_values($colorseries));
145 $dolgraph->setShowLegend(2);
146 $dolgraph->setShowPercent(1);
147 $dolgraph->SetType(array(
'pie'));
148 $dolgraph->setHeight(
'200');
149 $dolgraph->draw(
'idgraphstatus');
150 print $dolgraph->show($total ? 0 : 1);
155 print
'<tr class="liste_total"><td>'.$langs->trans(
"Total").
'</td><td class="right">'.$total.
'</td></tr>';
156 print
"</table></div><br>";
165 if (!empty($conf->supplier_proposal->enabled)) {
166 $sql =
"SELECT c.rowid, c.ref, s.nom as socname, s.rowid as socid, s.canvas, s.client";
167 $sql .=
" FROM ".MAIN_DB_PREFIX.
"supplier_proposal as c";
168 $sql .=
", ".MAIN_DB_PREFIX.
"societe as s";
169 if (empty($user->rights->societe->client->voir) && !$socid) {
170 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
172 $sql .=
" WHERE c.fk_soc = s.rowid";
173 $sql .=
" AND c.entity = ".$conf->entity;
174 $sql .=
" AND c.fk_statut = 0";
176 $sql .=
" AND c.fk_soc = ".((int) $socid);
178 if (empty($user->rights->societe->client->voir) && !$socid) {
179 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
182 $resql = $db->query($sql);
184 print
'<div class="div-table-responsive-no-min">';
185 print
'<table class="noborder centpercent">';
186 print
'<tr class="liste_titre">';
187 print
'<th colspan="2">'.$langs->trans(
"DraftRequests").
'</th></tr>';
188 $langs->load(
"supplier_proposal");
189 $num = $db->num_rows(
$resql);
193 $obj = $db->fetch_object(
$resql);
195 print
'<tr class="oddeven">';
196 $supplier_proposalstatic->id = $obj->rowid;
197 $supplier_proposalstatic->ref = $obj->ref;
198 print
'<td class="nowrap">'.$supplier_proposalstatic->getNomUrl(1).
'</td>';
200 $companystatic->id = $obj->socid;
201 $companystatic->name = $obj->socname;
202 $companystatic->client = $obj->client;
203 $companystatic->canvas = $obj->canvas;
204 print
'<td>'.$companystatic->getNomUrl(1,
'customer', 24).
'</td>';
210 print
"</table></div><br>";
214 print
'</div><div class="fichetwothirdright">';
223 $sql =
"SELECT c.rowid, c.ref, c.fk_statut, s.nom as socname, s.rowid as socid, s.canvas, s.client,";
224 $sql .=
" date_cloture as datec";
225 $sql .=
" FROM ".MAIN_DB_PREFIX.
"supplier_proposal as c";
226 $sql .=
", ".MAIN_DB_PREFIX.
"societe as s";
227 if (empty($user->rights->societe->client->voir) && !$socid) {
228 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
230 $sql .=
" WHERE c.fk_soc = s.rowid";
231 $sql .=
" AND c.entity = ".$conf->entity;
234 $sql .=
" AND c.fk_soc = ".((int) $socid);
236 if (empty($user->rights->societe->client->voir) && !$socid) {
237 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
239 $sql .=
" ORDER BY c.tms DESC";
240 $sql .= $db->plimit($max, 0);
242 $resql = $db->query($sql);
244 print
'<div class="div-table-responsive-no-min">';
245 print
'<table class="noborder centpercent">';
246 print
'<tr class="liste_titre">';
247 print
'<th colspan="4">'.$langs->trans(
"LastModifiedRequests", $max).
'</th></tr>';
249 $num = $db->num_rows(
$resql);
253 $obj = $db->fetch_object(
$resql);
255 print
'<tr class="oddeven">';
256 print
'<td width="20%" class="nowrap">';
258 $supplier_proposalstatic->id = $obj->rowid;
259 $supplier_proposalstatic->ref = $obj->ref;
261 print
'<table class="nobordernopadding"><tr class="nocellnopadd">';
262 print
'<td width="96" class="nobordernopadding nowrap">';
263 print $supplier_proposalstatic->getNomUrl(1);
266 print
'<td width="16" class="nobordernopadding nowrap">';
270 print
'<td width="16" class="right nobordernopadding">';
273 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid;
274 print $formfile->getDocumentsLink($supplier_proposalstatic->element, $filename, $filedir);
275 print
'</td></tr></table>';
279 $companystatic->id = $obj->socid;
280 $companystatic->name = $obj->socname;
281 $companystatic->client = $obj->client;
282 $companystatic->canvas = $obj->canvas;
283 print
'<td>'.$companystatic->getNomUrl(1,
'customer').
'</td>';
285 print
'<td>'.dol_print_date($db->jdate($obj->datec),
'day').
'</td>';
286 print
'<td class="right">'.$supplier_proposalstatic->LibStatut($obj->fk_statut, 3).
'</td>';
291 print
"</table></div><br>";
300 if (!empty($conf->supplier_proposal->enabled) && $user->rights->supplier_proposal->lire) {
301 $langs->load(
"supplier_proposal");
305 $sql =
"SELECT s.nom as socname, s.rowid as socid, s.canvas, s.client, p.rowid as supplier_proposalid, p.total_ttc, p.total_tva, p.total_ht, p.ref, p.fk_statut, p.datec as dp";
306 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s";
307 $sql .=
", ".MAIN_DB_PREFIX.
"supplier_proposal as p";
308 if (empty($user->rights->societe->client->voir) && !$socid) {
309 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
311 $sql .=
" WHERE p.fk_soc = s.rowid";
312 $sql .=
" AND p.entity IN (".getEntity(
'supplier_proposal').
")";
313 $sql .=
" AND p.fk_statut = 1";
314 if (empty($user->rights->societe->client->voir) && !$socid) {
315 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
318 $sql .=
" AND s.rowid = ".((int) $socid);
320 $sql .=
" ORDER BY p.rowid DESC";
322 $result = $db->query($sql);
325 $num = $db->num_rows($result);
328 print
'<div class="div-table-responsive-no-min">';
329 print
'<table class="noborder centpercent">';
330 print
'<tr class="liste_titre"><th colspan="5">'.$langs->trans(
"RequestsOpened").
' <a href="'.DOL_URL_ROOT.
'/supplier_proposal/list.php?search_status=1"><span class="badge">'.$num.
'</span></a></th></tr>';
332 $nbofloop = min($num, (empty($conf->global->MAIN_MAXLIST_OVERLOAD) ? 500 : $conf->global->MAIN_MAXLIST_OVERLOAD));
333 while ($i < $nbofloop) {
334 $obj = $db->fetch_object($result);
336 print
'<tr class="oddeven">';
339 print
'<td class="nowrap" width="140">';
341 $supplier_proposalstatic->id = $obj->supplier_proposalid;
342 $supplier_proposalstatic->ref = $obj->ref;
344 print
'<table class="nobordernopadding"><tr class="nocellnopadd">';
345 print
'<td class="nobordernopadding nowrap">';
346 print $supplier_proposalstatic->getNomUrl(1);
348 print
'<td width="18" class="nobordernopadding nowrap">';
349 if ($db->jdate($obj->dfv) < ($now - $conf->supplier_proposal->cloture->warning_delay)) {
353 print
'<td width="16" class="center nobordernopadding">';
356 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->supplier_proposalid;
357 print $formfile->getDocumentsLink($supplier_proposalstatic->element, $filename, $filedir);
358 print
'</td></tr></table>';
362 $companystatic->id = $obj->socid;
363 $companystatic->name = $obj->socname;
364 $companystatic->client = $obj->client;
365 $companystatic->canvas = $obj->canvas;
366 print
'<td class="left">'.$companystatic->getNomUrl(1,
'customer', 44).
'</td>'.
"\n";
368 print
'<td class="right">';
370 print
'<td class="right">'.price($obj->total_ttc).
'</td>';
371 print
'<td class="center" width="14">'.$supplier_proposalstatic->LibStatut($obj->fk_statut, 3).
'</td>'.
"\n";
374 $total += $obj->total_ttc;
376 if ($num > $nbofloop) {
377 print
'<tr class="liste_total"><td colspan="5">'.$langs->trans(
"XMoreLines", ($num - $nbofloop)).
"</td></tr>";
378 } elseif ($total > 0) {
379 print
'<tr class="liste_total"><td colspan="3">'.$langs->trans(
"Total").
'</td><td class="right">'.
price($total).
"</td><td> </td></tr>";
381 print
"</table></div><br>";
388 print
'</div></div>';
390 $parameters = array(
'user' => $user);
391 $reshook = $hookmanager->executeHooks(
'dashboardSupplierProposal', $parameters, $object);