28 require
'../main.inc.php';
29 require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.commande.class.php';
30 require_once DOL_DOCUMENT_ROOT.
'/reception/class/reception.class.php';
35 $hookmanager->initHooks(array(
'receptionindex'));
37 $langs->loadLangs(array(
"orders",
"receptions"));
44 $socid = $user->socid;
54 $companystatic =
new Societe($db);
56 $helpurl =
'EN:Module_Receptions|FR:Module_Receptions|ES:Módulo_Receptiones';
57 llxHeader(
'', $langs->trans(
"Reception"), $helpurl);
62 print
'<div class="fichecenter"><div class="fichethirdleft">';
65 if (!empty($conf->global->MAIN_SEARCH_FORM_ON_HOME_AREAS)) {
66 print
'<form method="post" action="list.php">';
67 print
'<input type="hidden" name="token" value="'.newToken().
'">';
68 print
'<div class="div-table-responsive-no-min">';
69 print
'<table class="noborder nohover centpercent">';
70 print
'<tr class="liste_titre"><td colspan="3">'.$langs->trans(
"Search").
'</td></tr>';
71 print
'<tr class="oddeven"><td>';
72 print $langs->trans(
"Reception").
':</td><td><input type="text" class="flat" name="sall" size="18"></td><td><input type="submit" value="'.$langs->trans(
"Search").
'" class="button"></td></tr>';
73 print
"</table></div></form><br>\n";
83 $sql =
"SELECT e.rowid, e.ref, e.ref_supplier,";
84 $sql .=
" s.nom as name, s.rowid as socid,";
85 $sql .=
" c.ref as commande_fournisseur_ref, c.rowid as commande_fournisseur_id";
86 $sql .=
" FROM ".MAIN_DB_PREFIX.
"reception as e";
87 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"element_element as el ON e.rowid = el.fk_target AND el.targettype = 'reception'";
88 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"commande_fournisseur as c ON el.fk_source = c.rowid";
89 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON s.rowid = e.fk_soc";
90 if (empty($user->rights->societe->client->voir) && !$socid) {
91 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON e.fk_soc = sc.fk_soc";
92 $sql .= $clause.
" sc.fk_user = ".((int) $user->id);
95 $sql .= $clause.
" e.fk_statut = 0";
96 $sql .=
" AND e.entity IN (".getEntity(
'reception').
")";
98 $sql .=
" AND c.fk_soc = ".((int) $socid);
101 $resql = $db->query($sql);
103 print
'<div class="div-table-responsive-no-min">';
104 print
'<table class="noborder centpercent">';
105 print
'<tr class="liste_titre">';
106 print
'<th colspan="3">'.$langs->trans(
"ReceptionsToValidate").
'</th></tr>';
108 $num = $db->num_rows(
$resql);
112 $obj = $db->fetch_object(
$resql);
114 $reception->id = $obj->rowid;
115 $reception->ref = $obj->ref;
116 $reception->ref_supplier = $obj->ref_supplier;
118 print
'<tr class="oddeven"><td class="nowrap">';
119 print $reception->getNomUrl(1);
122 print
'<a href="'.DOL_URL_ROOT.
'/comm/card.php?socid='.$obj->socid.
'">'.$obj->name.
'</a>';
125 if ($obj->commande_fournisseur_id) {
126 print
'<a href="'.DOL_URL_ROOT.
'/commande_fournisseur/card.php?id='.$obj->commande_fournisseur_id.
'">'.$obj->commande_fournisseur_ref.
'</a>';
132 print
'<tr><td><span class="opacitymedium">'.$langs->trans(
"None").
'</span></td><td></td><td></td></tr>';
135 print
"</table></div><br>";
139 print
'</div><div class="fichetwothirdright">';
147 $sql =
"SELECT e.rowid, e.ref, e.ref_supplier,";
148 $sql .=
" s.nom as name, s.rowid as socid,";
149 $sql .=
" c.ref as commande_fournisseur_ref, c.rowid as commande_fournisseur_id";
150 $sql .=
" FROM ".MAIN_DB_PREFIX.
"reception as e";
151 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"element_element as el ON e.rowid = el.fk_target AND el.targettype = 'reception' AND el.sourcetype IN ('order_supplier')";
152 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"commande_fournisseur as c ON el.fk_source = c.rowid AND el.sourcetype IN ('order_supplier') AND el.targettype = 'reception'";
153 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON s.rowid = e.fk_soc";
154 if (empty($user->rights->societe->client->voir) && !$socid) {
155 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON e.fk_soc = sc.fk_soc";
157 $sql .=
" WHERE e.entity IN (".getEntity(
'reception').
")";
158 if (empty($user->rights->societe->client->voir) && !$socid) {
159 $sql .=
" AND sc.fk_user = ".((int) $user->id);
161 $sql .=
" AND e.fk_statut = 1";
163 $sql .=
" AND c.fk_soc = ".((int) $socid);
165 $sql .=
" ORDER BY e.date_delivery DESC";
166 $sql .= $db->plimit($max, 0);
168 $resql = $db->query($sql);
170 $num = $db->num_rows(
$resql);
173 print
'<div class="div-table-responsive-no-min">';
174 print
'<table class="noborder centpercent">';
175 print
'<tr class="liste_titre">';
176 print
'<th colspan="3">'.$langs->trans(
"LastReceptions", $num).
'</th></tr>';
178 $obj = $db->fetch_object(
$resql);
180 $reception->id = $obj->rowid;
181 $reception->ref = $obj->ref;
182 $reception->ref_supplier = $obj->ref_supplier;
184 print
'<tr class="oddeven"><td>';
185 print $reception->getNomUrl(1);
187 print
'<td><a href="'.DOL_URL_ROOT.
'/comm/card.php?socid='.$obj->socid.
'">'.
img_object($langs->trans(
"ShowCompany"),
"company").
' '.$obj->name.
'</a></td>';
189 if ($obj->commande_fournisseur_id > 0) {
190 $orderstatic->id = $obj->commande_fournisseur_id;
191 $orderstatic->ref = $obj->commande_fournisseur_ref;
192 print $orderstatic->getNomUrl(1);
199 print
"</table></div><br>";
212 $sql =
"SELECT c.rowid, c.ref, c.ref_supplier as ref_supplier, c.fk_statut as status, c.billed as billed, s.nom as name, s.rowid as socid";
213 $sql .=
" FROM ".MAIN_DB_PREFIX.
"commande_fournisseur as c,";
214 $sql .=
" ".MAIN_DB_PREFIX.
"societe as s";
215 if (empty($user->rights->societe->client->voir) && !$socid) {
216 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
218 $sql .=
" WHERE c.fk_soc = s.rowid";
219 $sql .=
" AND c.entity IN (".getEntity(
'supplier_order').
")";
222 $sql .=
" AND c.fk_soc = ".((int) $socid);
224 if (empty($user->rights->societe->client->voir) && !$socid) {
225 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
227 $sql .=
" ORDER BY c.rowid ASC";
228 $resql = $db->query($sql);
230 $num = $db->num_rows(
$resql);
232 $langs->load(
"orders");
235 print
'<div class="div-table-responsive-no-min">';
236 print
'<table class="noborder centpercent">';
237 print
'<tr class="liste_titre">';
238 print
'<th colspan="3">'.$langs->trans(
"SuppliersOrdersToProcess").
' <span class="badge">'.$num.
'</span></th></tr>';
240 $obj = $db->fetch_object(
$resql);
242 $orderstatic->id = $obj->rowid;
243 $orderstatic->ref = $obj->ref;
244 $orderstatic->ref_supplier = $obj->ref_supplier;
245 $orderstatic->statut = $obj->status;
246 $orderstatic->facturee = $obj->billed;
248 $companystatic->name = $obj->name;
249 $companystatic->id = $obj->socid;
251 print
'<tr class="oddeven">';
252 print
'<td class="nowrap">';
253 print $orderstatic->getNomUrl(1);
256 print $companystatic->getNomUrl(1,
'customer', 32);
258 print
'<td class="right">';
259 print $orderstatic->getLibStatut(3);
264 print
"</table></div><br>";
268 print
'</div></div>';
270 $parameters = array(
'user' => $user);
271 $reshook = $hookmanager->executeHooks(
'dashboardWarehouseReceptions', $parameters, $object);