28 require
'../main.inc.php';
29 require_once DOL_DOCUMENT_ROOT.
'/commande/class/commande.class.php';
30 require_once DOL_DOCUMENT_ROOT.
'/expedition/class/expedition.class.php';
33 $socid =
GETPOST(
'socid',
'int');
36 $hookmanager->initHooks(array(
'sendingindex'));
39 $langs->loadLangs(array(
'orders',
'sendings'));
46 $companystatic =
new Societe($db);
49 $helpurl =
'EN:Module_Shipments|FR:Module_Expéditions|ES:Módulo_Expediciones';
50 llxHeader(
'', $langs->trans(
"Shipment"), $helpurl);
55 print
'<div class="fichecenter"><div class="fichethirdleft">';
63 $sql =
"SELECT e.rowid, e.ref, e.ref_customer,";
64 $sql .=
" s.nom as name, s.rowid as socid,";
65 $sql .=
" c.ref as commande_ref, c.rowid as commande_id";
66 $sql .=
" FROM ".MAIN_DB_PREFIX.
"expedition as e";
67 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"element_element as el ON e.rowid = el.fk_target AND el.targettype = 'shipping'";
68 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"commande as c ON el.fk_source = c.rowid";
69 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON s.rowid = e.fk_soc";
70 if (empty($user->rights->societe->client->voir) && !$socid) {
71 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON e.fk_soc = sc.fk_soc";
72 $sql .= $clause.
" sc.fk_user = ".((int) $user->id);
76 $sql .=
" AND e.entity IN (".getEntity(
'expedition').
")";
78 $sql .=
" AND c.fk_soc = ".((int) $socid);
83 $num = $db->num_rows(
$resql);
85 print
'<div class="div-table-responsive-no-min">';
86 print
'<table class="noborder centpercent">';
87 print
'<tr class="liste_titre">';
88 print
'<th colspan="3">';
89 print $langs->trans(
"SendingsToValidate").
' ';
91 print
'<span class="badge">'.$num.
'</span>';
99 $obj = $db->fetch_object(
$resql);
101 $shipment->id = $obj->rowid;
102 $shipment->ref = $obj->ref;
103 $shipment->ref_customer = $obj->ref_customer;
105 print
'<tr class="oddeven"><td class="nowrap">';
106 print $shipment->getNomUrl(1);
109 print
'<a href="'.DOL_URL_ROOT.
'/comm/card.php?socid='.$obj->socid.
'">'.$obj->name.
'</a>';
112 if ($obj->commande_id) {
113 print
'<a href="'.DOL_URL_ROOT.
'/commande/card.php?id='.$obj->commande_id.
'">'.$obj->commande_ref.
'</a>';
119 print
'<tr><td>'.$langs->trans(
"None").
'</td><td></td><td></td></tr>';
122 print
"</table></div><br>";
128 print
'</div><div class="fichetwothirdright">';
135 $sql =
"SELECT e.rowid, e.ref, e.ref_customer,";
136 $sql .=
" s.nom as name, s.rowid as socid,";
137 $sql .=
" c.ref as commande_ref, c.rowid as commande_id";
138 $sql .=
" FROM ".MAIN_DB_PREFIX.
"expedition as e";
139 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"element_element as el ON e.rowid = el.fk_target AND el.targettype = 'shipping' AND el.sourcetype IN ('commande')";
140 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"commande as c ON el.fk_source = c.rowid AND el.sourcetype IN ('commande') AND el.targettype = 'shipping'";
141 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON s.rowid = e.fk_soc";
142 if (empty($user->rights->societe->client->voir) && !$socid) {
143 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON e.fk_soc = sc.fk_soc";
145 $sql .=
" WHERE e.entity IN (".getEntity(
'expedition').
")";
146 if (empty($user->rights->societe->client->voir) && !$socid) {
147 $sql .=
" AND sc.fk_user = ".((int) $user->id);
149 $sql .=
" AND e.fk_statut = ".Expedition::STATUS_VALIDATED;
151 $sql .=
" AND c.fk_soc = ".((int) $socid);
153 $sql .=
" ORDER BY e.date_delivery DESC";
154 $sql .= $db->plimit($max, 0);
156 $resql = $db->query($sql);
158 $num = $db->num_rows(
$resql);
160 print
'<div class="div-table-responsive-no-min">';
161 print
'<table class="noborder centpercent">';
162 print
'<tr class="liste_titre">';
163 print
'<th colspan="4">';
164 print $langs->trans(
"LastSendings").
' ';
166 print
'<span class="badge">'.$num.
'</span>';
174 $obj = $db->fetch_object(
$resql);
176 $shipment->id = $obj->rowid;
177 $shipment->ref = $obj->ref;
178 $shipment->ref_customer = $obj->ref_customer;
180 print
'<tr class="oddeven"><td>';
181 print $shipment->getNomUrl(1);
183 print
'<td><a href="'.DOL_URL_ROOT.
'/comm/card.php?socid='.$obj->socid.
'">'.
img_object($langs->trans(
"ShowCompany"),
"company").
' '.$obj->name.
'</a></td>';
185 if ($obj->commande_id > 0) {
186 $orderstatic->id = $obj->commande_id;
187 $orderstatic->ref = $obj->commande_ref;
188 print $orderstatic->getNomUrl(1);
191 print
'<td class="">';
198 print
'<tr><td>'.$langs->trans(
"None").
'</td><td></td><td></td><td></td></tr>';
200 print
"</table></div><br>";
209 $sql =
"SELECT c.rowid, c.ref, c.ref_client as ref_customer, c.fk_statut as status, c.facture as billed, s.nom as name, s.rowid as socid";
210 $sql .=
" FROM ".MAIN_DB_PREFIX.
"commande as c,";
211 $sql .=
" ".MAIN_DB_PREFIX.
"societe as s";
212 if (empty($user->rights->societe->client->voir) && !$socid) {
213 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
215 $sql .=
" WHERE c.fk_soc = s.rowid";
216 $sql .=
" AND c.entity IN (".getEntity(
'order').
")";
217 $sql .=
" AND c.fk_statut IN (".Commande::STATUS_VALIDATED.
", ".Commande::STATUS_ACCEPTED.
")";
219 $sql .=
" AND c.fk_soc = ".((int) $socid);
221 if (empty($user->rights->societe->client->voir) && !$socid) {
222 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
224 $sql .=
" ORDER BY c.rowid ASC";
226 $resql = $db->query($sql);
228 $langs->load(
"orders");
230 $num = $db->num_rows(
$resql);
232 print
'<div class="div-table-responsive-no-min">';
233 print
'<table class="noborder centpercent">';
235 print
'<tr class="liste_titre">';
236 print
'<th colspan="3">'.$langs->trans(
"OrdersToProcess").
' ';
237 print
'<a href="'.DOL_URL_ROOT.
'/commande/list.php?search_status='.
Commande::STATUS_VALIDATED.
','.Commande::STATUS_ACCEPTED.
'">';
238 print
'<span class="badge">'.$num.
'</span>';
245 while ($i < $num && $i < 10) {
246 $obj = $db->fetch_object(
$resql);
248 $orderstatic->id = $obj->rowid;
249 $orderstatic->ref = $obj->ref;
250 $orderstatic->ref_customer = $obj->ref_customer;
251 $orderstatic->statut = $obj->status;
252 $orderstatic->billed = $obj->billed;
254 $companystatic->name = $obj->name;
255 $companystatic->id = $obj->socid;
257 print
'<tr class="oddeven"><td>';
258 print $orderstatic->getNomUrl(1);
261 print $companystatic->getNomUrl(1,
'customer', 32);
263 print
'<td class="right">';
264 print $orderstatic->getLibStatut(3);
271 print
'<tr class="opacitymedium">';
272 print
'<td>'.$langs->trans(
"More").
'...</td>';
278 print
'<tr><td>'.$langs->trans(
"None").
'</td><td></td><td></td></tr>';
281 print
"</table></div><br>";
287 print
'</div></div>';
289 $parameters = array(
'user' => $user);
290 $reshook = $hookmanager->executeHooks(
'dashboardWarehouseSendings', $parameters, $object);