{ print '<tr class="liste_titre">'; print '<td class="liste_titre" colspan="8">'; print $moreforfilter; print '</td></tr>'; } print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Name")." / ".$langs->trans("Company"),"liste.php","d.nom",$param,"","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("Login"),"liste.php","d.login",$param,"","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("Type"),"liste.php","t.libelle",$param,"","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("Person"),"liste.php","d.morphy",$param,"","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("EMail"),"liste.php","d.email",$param,"","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("Status"),"liste.php","d.statut,d.datefin",$param,"","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("EndSubscription"),"liste.php","d.datefin",$param,"",'align="center"',$sortfield,$sortorder); print_liste_field_titre($langs->trans("Action"),"liste.php","",$param,"",'width="60" align="center"',$sortfield,$sortorder); print "</tr>\n"; // Lignes des champs de filtre print '<tr class="liste_titre">'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" name="search_nom" value="'.$_REQUEST["search_nom"].'" size="12"></td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" name="search_login" value="'.$_REQUEST["search_login"].'" size="7"></td>'; print '<td class="liste_titre">'; $listetype=$membertypestatic->liste_array(); print $form->selectarray("type", $listetype, $_REQUEST["type"], 1, 0, 0, '', 0, 12); print '</td>';
print '<table class="noborder" width="100%">'; print "<tr class=\"liste_titre\">"; //print_liste_field_titre($langs->trans("Id"),$_SERVER["PHP_SELF"], "m.rowid","",$param,"",$sortfield,$sortorder); print_liste_field_titre($langs->trans("Date"), $_SERVER["PHP_SELF"], "m.datem", "", $param, "", $sortfield, $sortorder); echo "<td></td>"; print_liste_field_titre($langs->trans("LabelMovement"), $_SERVER["PHP_SELF"], "m.label", "", $param, "", $sortfield, $sortorder); // Checkpoint: eliminar la columna de origen // print_liste_field_titre($langs->trans("Source"),$_SERVER["PHP_SELF"], "m.label","",$param,"",$sortfield,$sortorder); print_liste_field_titre($langs->trans("ProductRef"), $_SERVER["PHP_SELF"], "p.ref", "", $param, "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("ProductLabel"), $_SERVER["PHP_SELF"], "p.ref", "", $param, "", $sortfield, $sortorder); print_liste_field_titre('Almacén de Origen', $_SERVER["PHP_SELF"], "", "", $param, "", $sortfield, $sortorder); // We are on a specific warehouse card, no filter on other should be possible print_liste_field_titre('Almacén Destino', $_SERVER["PHP_SELF"], "", "", $param, "", $sortfield, $sortorder); // We are on a specific warehouse card, no filter on other should be possible print_liste_field_titre($langs->trans("Author"), $_SERVER["PHP_SELF"], "m.fk_user_author", "", $param, "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("Units"), $_SERVER["PHP_SELF"], "m.value", "", $param, 'align="right"', $sortfield, $sortorder); print "</tr>\n"; // Lignes des champs de filtre print '<form method="get" action="' . $_SERVER["PHP_SELF"] . '">'; if ($id) { print '<input type="hidden" name="id" value="' . $id . '">'; } // Checkpoint: fecha print '<tr class="liste_titre">'; print '<td class="liste_titre" valign="right">'; print $langs->trans('Date') . ': <input class="flat" type="text" size="11" maxlength="10" name="date_ini" value="' . $date_ini . '"> - <input class="flat" type="text" size="11" maxlength="10" name="date_fin" value="' . $date_fin . '">'; //print ' '.$langs->trans('Year').': '; //$syear = GETPOST('year')?GETPOST('year'):-1; //$formother->select_year($syear,'year',1, 20, 5); print '</td>'; echo '<td>';
/* Affichage de la liste des produits de l'entrepot */ /* */ /* ************************************************************************** */ print '<br>'; print '<table class="noborder" width="100%">'; print "<tr class=\"liste_titre\">"; print_liste_field_titre($langs->trans("Product"), "", "p.ref", "&id=" . $id, "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("Label"), "", "p.label", "&id=" . $id, "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("Units"), "", "ps.reel", "&id=" . $id, "", 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("AverageUnitPricePMPShort"), "", "ps.pmp", "&id=" . $id, "", 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("EstimatedStockValueShort"), "", "", "&id=" . $id, "", 'align="right"', $sortfield, $sortorder); if (empty($conf->global->PRODUIT_MULTIPRICES)) { print_liste_field_titre($langs->trans("SellPriceMin"), "", "p.price", "&id=" . $id, "", 'align="right"', $sortfield, $sortorder); } if (empty($conf->global->PRODUIT_MULTIPRICES)) { print_liste_field_titre($langs->trans("EstimatedStockValueSellShort"), "", "", "&id=" . $id, "", 'align="right"', $sortfield, $sortorder); } if ($user->rights->stock->mouvement->creer) { print '<td> </td>'; } if ($user->rights->stock->creer) { print '<td> </td>'; } print "</tr>"; $totalunit = 0; $totalvalue = $totalvaluesell = 0; $sql = "SELECT p.rowid as rowid, p.ref, p.label as produit, p.fk_product_type as type, p.pmp as ppmp, p.price, p.price_ttc,"; $sql .= " ps.pmp, ps.reel as value"; $sql .= " FROM " . MAIN_DB_PREFIX . "product_stock ps, " . MAIN_DB_PREFIX . "product p"; $sql .= " WHERE ps.fk_product = p.rowid"; $sql .= " AND ps.reel <> 0";
print '<tr class="liste_titre">'; print '<td class="liste_titre" colspan="10">'; print $moreforfilter; print '</td></tr>'; } print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans('Ref'), $_SERVER["PHP_SELF"], 'p.ref', '', $param, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans('RefCustomer'), $_SERVER["PHP_SELF"], 'p.ref_client', '', $param, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans('Company'), $_SERVER["PHP_SELF"], 's.nom', '', $param, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans('Town'), $_SERVER["PHP_SELF"], 's.town', '', $param, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans('Date'), $_SERVER["PHP_SELF"], 'p.datep', '', $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans('DateEndPropalShort'), $_SERVER["PHP_SELF"], 'dfv', '', $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans('AmountHT'), $_SERVER["PHP_SELF"], 'p.total_ht', '', $param, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans('Author'), $_SERVER["PHP_SELF"], 'u.login', '', $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans('Status'), $_SERVER["PHP_SELF"], 'p.fk_statut', '', $param, 'align="right"', $sortfield, $sortorder); print_liste_field_titre('', $_SERVER["PHP_SELF"], "", '', '', '', $sortfield, $sortorder, 'maxwidthsearch '); print "</tr>\n"; print '<tr class="liste_titre">'; print '<td class="liste_titre">'; print '<input class="flat" size="6" type="text" name="search_ref" value="' . $search_ref . '">'; print '</td>'; print '<td class="liste_titre">'; print '<input class="flat" size="6" type="text" name="search_refcustomer" value="' . $search_refcustomer . '">'; print '</td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" size="12" name="search_societe" value="' . $search_societe . '">'; print '</td>'; print '<td class="liste_titre"><input class="flat" type="text" size="10" name="search_town" value="' . $search_town . '"></td>'; // Date print '<td class="liste_titre" colspan="1" align="center">'; //print $langs->trans('Month').': ';
print '<div class="error">'; $langs->load("errors"); $countrynotdefined = $langs->trans("ErrorSetACountryFirst"); print $countrynotdefined; print '</div>'; } else { print '<form method="GET" action="' . $_SERVER["PHP_SELF"] . '">'; print "<table class=\"noborder\" width=\"100%\">"; print "<tr class=\"liste_titre\">"; print_liste_field_titre($langs->trans("Ref"), $_SERVER["PHP_SELF"], "id", "", $param, "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("Label"), $_SERVER["PHP_SELF"], "cs.libelle", "", $param, 'align="left"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Type"), $_SERVER["PHP_SELF"], "type", "", $param, 'align="left"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("PeriodEndDate"), $_SERVER["PHP_SELF"], "periode", "", $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Amount"), $_SERVER["PHP_SELF"], "cs.amount", "", $param, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("DateDue"), $_SERVER["PHP_SELF"], "cs.date_ech", "", $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Status"), $_SERVER["PHP_SELF"], "cs.paye", "", $param, 'align="right"', $sortfield, $sortorder); print "</tr>\n"; print '<tr class="liste_titre">'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre"><input type="text" class="flat" size="8" name="search_label" value="' . GETPOST("search_label") . '"></td>'; // Type print '<td class="liste_titre" align="left">'; $formsocialcontrib->select_type_socialcontrib($typeid, 'typeid', 1, 16, 0); print '</td>'; // Period end date print '<td class="liste_titre"> </td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre" align="right">'; print '<input type="image" class="liste_titre" src="' . img_picto($langs->trans("Search"), 'search.png', '', '', 1) . '" name="button_search" value="' . dol_escape_htmltag($langs->trans("Search")) . '" title="' . dol_escape_htmltag($langs->trans("Search")) . '">'; print '</td>';
$sql .= ' AND f.fk_soc = ' . $socid; } $sql .= ' ORDER BY ' . $sortfield . ' ' . $sortorder; $sql .= $db->plimit($limit + 1, $offset); $resql = $db->query($sql); if ($resql) { $num = $db->num_rows($resql); $i = 0; $var = True; print_barre_liste($langs->trans('Payments'), $page, 'paiement.php', '', $sortfield, $sortorder, '', $num); print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans('Invoice'), 'paiement.php', 'facnumber', '', '', '', $sortfield, $sortorder); print_liste_field_titre($langs->trans('Date'), 'paiement.php', 'dp', '', '', '', $sortfield, $sortorder); print_liste_field_titre($langs->trans('Type'), 'paiement.php', 'libelle', '', '', '', $sortfield, $sortorder); print_liste_field_titre($langs->trans('Amount'), 'paiement.php', 'fa_amount', '', '', 'align="right"', $sortfield, $sortorder); print '<td> </td>'; print "</tr>\n"; while ($i < min($num, $limit)) { $objp = $db->fetch_object($resql); $var = !$var; print '<tr ' . $bc[$var] . '>'; print '<td><a href="facture.php?facid=' . $objp->facid . '">' . $objp->facnumber . "</a></td>\n"; print '<td>' . dol_print_date($db->jdate($objp->dp)) . "</td>\n"; print '<td>' . $objp->paiement_type . ' ' . $objp->num_paiement . "</td>\n"; print '<td align="right">' . price($objp->amount) . '</td><td> </td>'; print '</tr>'; $i++; } print '</table>'; }
} else { if ($action == 'lock') { $formquestion = array(); print $form->formconfirm($_SERVER["PHP_SELF"] . '?noparam=noparam', $langs->trans('LockNewSessions'), $langs->trans('ConfirmLockNewSessions', $user->login), 'confirm_lock', $formquestion, 'no', 1); } } if ($savehandler == 'files') { print '<table class="liste" width="100%">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Login"), $_SERVER["PHP_SELF"], "login", "", "", 'align="left"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("SessionId"), $_SERVER["PHP_SELF"], "id", "", "", 'align="left"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("DateCreation"), $_SERVER["PHP_SELF"], "datec", "", "", 'align="left"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("DateModification"), $_SERVER["PHP_SELF"], "datem", "", "", 'align="left"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Age"), $_SERVER["PHP_SELF"], "age", "", "", 'align="left"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Raw"), $_SERVER["PHP_SELF"], "raw", "", "", 'align="left"', $sortfield, $sortorder); print_liste_field_titre('', '', ''); print "</tr>\n"; $var = True; foreach ($listofsessions as $key => $sessionentry) { $var = !$var; print "<tr " . $bc[$var] . ">"; // Login print '<td>' . $sessionentry['login'] . '</td>'; // ID print '<td align="left" class="nowrap">'; if ("{$key}" == session_id()) { print $form->textwithpicto($key, $langs->trans("YourSession")); } else { print $key; } print '</td>';
$result = $db->query($sql); if ($result) { $num = $db->num_rows($result); print_barre_liste($langs->trans("Contrats"),$page,$_SERVER["PHP_SELF"],"&id=$product->id",$sortfield,$sortorder,'',$num,0,''); $i = 0; print "<table class=\"noborder\" width=\"100%\">"; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Ref"),$_SERVER["PHP_SELF"],"c.rowid","","&id=".$_GET["id"],'',$sortfield,$sortorder); print_liste_field_titre($langs->trans("Company"),$_SERVER["PHP_SELF"],"s.nom","","&id=".$_GET["id"],'',$sortfield,$sortorder); print_liste_field_titre($langs->trans("CustomerCode"),$_SERVER["PHP_SELF"],"s.code_client","","&id=".$_GET["id"],'',$sortfield,$sortorder); print_liste_field_titre($langs->trans("Date"),$_SERVER["PHP_SELF"],"c.date_contrat","","&id=".$_GET["id"],'align="center"',$sortfield,$sortorder); //print_liste_field_titre($langs->trans("AmountHT"),$_SERVER["PHP_SELF"],"c.amount","","&id=".$_GET["id"],'align="right"',$sortfield,$sortorder); print '<td class="liste_titre" width="16">'.$staticcontratligne->LibStatut(0,3).'</td>'; print '<td class="liste_titre" width="16">'.$staticcontratligne->LibStatut(4,3).'</td>'; print '<td class="liste_titre" width="16">'.$staticcontratligne->LibStatut(5,3).'</td>'; print "</tr>\n"; $contratstatic=new Contrat($db); if ($num > 0) { $var=True; while ($i < $num && $i < $conf->liste_limit) { $objp = $db->fetch_object($result); $var=!$var;
$urlparam .= "&search_status=" . urlencode($search_status); } print_barre_liste($langs->trans("ListOfInterventions"), $page, $_SERVER['PHP_SELF'], $urlparam, $sortfield, $sortorder, '', $num); print '<form method="POST" action="' . $_SERVER["PHP_SELF"] . '">' . "\n"; print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Ref"), $_SERVER["PHP_SELF"], "f.ref", "", $urlparam, 'width="15%"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Company"), $_SERVER["PHP_SELF"], "s.nom", "", $urlparam, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Description"), $_SERVER["PHP_SELF"], "f.description", "", $urlparam, '', $sortfield, $sortorder); if (empty($conf->global->FICHINTER_DISABLE_DETAILS)) { print_liste_field_titre('', $_SERVER["PHP_SELF"], ''); print_liste_field_titre($langs->trans("Date"), $_SERVER["PHP_SELF"], "fd.date", "", $urlparam, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Duration"), $_SERVER["PHP_SELF"], "fd.duree", "", $urlparam, 'align="right"', $sortfield, $sortorder); } print_liste_field_titre($langs->trans("Status"), $_SERVER["PHP_SELF"], "f.fk_statut", "", $urlparam, 'align="right"', $sortfield, $sortorder); print_liste_field_titre('', $_SERVER["PHP_SELF"], ''); print "</tr>\n"; print '<tr class="liste_titre">'; print '<td class="liste_titre">'; print '<input type="text" class="flat" name="search_ref" value="' . $search_ref . '" size="8">'; print '</td><td class="liste_titre">'; print '<input type="text" class="flat" name="search_company" value="' . $search_company . '" size="10">'; print '</td><td class="liste_titre">'; print '<input type="text" class="flat" name="search_desc" value="' . $search_desc . '" size="12">'; print '</td>'; if (empty($conf->global->FICHINTER_DISABLE_DETAILS)) { // Desc of line print '<td class="liste_titre"> </td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre"> </td>'; }
$sql .= $db->order($sortfield, $sortorder); $sql .= $db->plimit($limit + 1, $offset); $resql = $db->query($sql); if ($resql) { $num = $db->num_rows($resql); $expedition = new Expedition($db); $param = "&socid={$socid}"; print_barre_liste($langs->trans('ListOfSendings'), $page, "liste.php", $param, $sortfield, $sortorder, '', $num); $i = 0; print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Ref"), "liste.php", "e.ref", "", $param, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Company"), "liste.php", "s.nom", "", $param, 'align="left"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("DateDeliveryPlanned"), "liste.php", "e.date_delivery", "", $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("DateReceived"), "liste.php", "e.date_expedition", "", $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Status"), "liste.php", "e.fk_statut", "", $param, 'align="right"', $sortfield, $sortorder); print "</tr>\n"; $var = True; while ($i < min($num, $limit)) { $objp = $db->fetch_object($resql); $var = !$var; print "<tr {$bc[$var]}>"; print "<td>"; $shipment->id = $objp->rowid; $shipment->ref = $objp->ref; print $shipment->getNomUrl(1); print "</td>\n"; // Third party print '<td>'; $companystatic->id = $objp->socid; $companystatic->ref = $objp->socname;
if (preg_match('/^pv/', $sortfield)) { $sql .= $db->order($sortfield, $sortorder); } $result = $db->query($sql); if ($result) { $num = $db->num_rows($result); $i = 0; $total = 0; print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("PeriodEndDate"), $_SERVER["PHP_SELF"], "pv.datev", "", $param, 'width="120"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Label"), $_SERVER["PHP_SELF"], "pv.label", "", $param, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("ExpectedToPay"), $_SERVER["PHP_SELF"], "pv.amount", "", $param, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("RefPayment"), $_SERVER["PHP_SELF"], "pv.rowid", "", $param, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("DatePayment"), $_SERVER["PHP_SELF"], "pv.datep", "", $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("PayedByThisPayment"), $_SERVER["PHP_SELF"], "pv.amount", "", $param, 'align="right"', $sortfield, $sortorder); print "</tr>\n"; $var = 1; while ($i < $num) { $obj = $db->fetch_object($result); $total = $total + $obj->amount; $var = !$var; print "<tr " . $bc[$var] . ">"; print '<td align="left">' . dol_print_date($db->jdate($obj->dm), 'day') . '</td>' . "\n"; print "<td>" . $obj->label . "</td>\n"; print '<td align="right">' . price($obj->amount) . "</td>"; // Ref payment $tva_static->id = $obj->rowid; $tva_static->ref = $obj->rowid; print '<td align="left">' . $tva_static->getNomUrl(1) . "</td>\n"; print '<td align="center">' . dol_print_date($db->jdate($obj->dp), 'day') . "</td>\n";
} $sql .= " AND p.statut = 0"; $sql .= " ORDER BY {$sortfield} {$sortorder}"; $sql .= $db->plimit($limit + 1, $offset); $resql = $db->query($sql); if ($resql) { $num = $db->num_rows($resql); $i = 0; $var = True; print_barre_liste($langs->trans("ReceivedCustomersPaymentsToValid"), $page, $_SERVER["PHP_SELF"], "", $sortfield, $sortorder, '', $num); print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Ref"), $_SERVER["PHP_SELF"], "p.rowid", "", "", 'width="60"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Date"), $_SERVER["PHP_SELF"], "dp", "", "", 'width="80" align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Type"), $_SERVER["PHP_SELF"], "c.libelle", "", "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("AmountTTC"), $_SERVER["PHP_SELF"], "c.libelle", "", "", 'align="right"', $sortfield, $sortorder); print "<td> </td>"; print "</tr>\n"; while ($i < min($num, $limit)) { $objp = $db->fetch_object($resql); $var = !$var; print "<tr " . $bc[$var] . ">"; print '<td><a href="' . DOL_URL_ROOT . '/compta/paiement/card.php?id=' . $objp->rowid . '">' . img_object($langs->trans("ShowPayment"), "payment") . ' ' . $objp->rowid . '</a></td>'; print '<td width="80" align="center">' . dol_print_date($db->jdate($objp->dp), 'day') . "</td>\n"; print "<td>{$objp->paiement_type} {$objp->num_paiement}</td>\n"; print '<td align="right">' . price($objp->amount) . '</td>'; print '<td align="center">'; if ($objp->statut == 0) { print '<a href="card.php?id=' . $objp->rowid . '&action=valide">' . $langs->trans("PaymentStatusToValidShort") . '</a>'; } else { print "-";
$sql .= " ORDER BY {$sortfield} {$sortorder} "; $sql .= $db->plimit($conf->liste_limit + 1, $offset); $result = $db->query($sql); if ($result) { $num = $db->num_rows($result); print_barre_liste($langs->trans("SuppliersOrders"), $page, $_SERVER["PHP_SELF"], "&id={$product->id}", $sortfield, $sortorder, '', $num, 0, ''); $i = 0; print "<table class=\"noborder\" width=\"100%\">"; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Ref"), $_SERVER["PHP_SELF"], "c.rowid", "", "&id=" . $product->id, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Company"), $_SERVER["PHP_SELF"], "s.nom", "", "&id=" . $product->id, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("SupplierCode"), $_SERVER["PHP_SELF"], "s.code_client", "", "&id=" . $product->id, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("OrderDate"), $_SERVER["PHP_SELF"], "c.date_commande", "", "&id=" . $product->id, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Qty"), $_SERVER["PHP_SELF"], "d.qty", "", "&id=" . $product->id, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("AmountHT"), $_SERVER["PHP_SELF"], "c.total_ht", "", "&id=" . $product->id, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Status"), $_SERVER["PHP_SELF"], "c.fk_statut", "", "&id=" . $product->id, 'align="right"', $sortfield, $sortorder); print "</tr>\n"; $commandestatic = new CommandeFournisseur($db); if ($num > 0) { $var = True; while ($i < $num && $i < $conf->liste_limit) { $objp = $db->fetch_object($result); $var = !$var; $commandestatic->id = $objp->commandeid; $commandestatic->ref = $objp->ref; $commandestatic->statut = $objp->statut; print "<tr " . $bc[$var] . ">"; print '<td>' . $commandestatic->getNomUrl(1) . "</td>\n"; print "</a></td>\n"; print '<td><a href="' . DOL_URL_ROOT . '/fourn/card.php?socid=' . $objp->socid . '">' . img_object($langs->trans("ShowCompany"), "company") . ' ' . dol_trunc($objp->name, 44) . '</a></td>'; print "<td>" . $objp->code_client . "</td>\n";
$result = $db->query($sql); if ($result) { $num = $db->num_rows($result); $interventionstatic = new Fichinter($db); $urlparam = "&socid={$socid}"; print_barre_liste($langs->trans("ListOfInterventions"), $page, "list.php", $urlparam, $sortfield, $sortorder, '', $num); print '<form method="get" action="' . $_SERVER["PHP_SELF"] . '">' . "\n"; print '<table class="noborder" width="100%">'; print "<tr class=\"liste_titre\">"; print_liste_field_titre($langs->trans("Ref"), $_SERVER["PHP_SELF"], "f.ref", "", $urlparam, 'width="15%"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Company"), $_SERVER["PHP_SELF"], "s.nom", "", $urlparam, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Description"), $_SERVER["PHP_SELF"], "f.description", "", $urlparam, '', $sortfield, $sortorder); print_liste_field_titre('', $_SERVER["PHP_SELF"], ''); print_liste_field_titre($langs->trans("Date"), $_SERVER["PHP_SELF"], "fd.date", "", $urlparam, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Duration"), $_SERVER["PHP_SELF"], "fd.duree", "", $urlparam, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Status"), $_SERVER["PHP_SELF"], "f.fk_statut", "", $urlparam, 'align="right"', $sortfield, $sortorder); print "</tr>\n"; print '<tr class="liste_titre">'; print '<td class="liste_titre">'; print '<input type="text" class="flat" name="search_ref" value="' . $search_ref . '" size="8">'; print '</td><td class="liste_titre">'; print '<input type="text" class="flat" name="search_company" value="' . $search_company . '" size="10">'; print '</td><td class="liste_titre">'; print '<input type="text" class="flat" name="search_desc" value="' . $search_desc . '" size="12">'; print '</td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre" align="right"><input class="liste_titre" type="image" src="' . DOL_URL_ROOT . '/theme/' . $conf->theme . '/img/search.png" value="' . dol_escape_htmltag($langs->trans("Search")) . '" title="' . dol_escape_htmltag($langs->trans("Search")) . '"></td>'; print "</tr>\n"; $companystatic = new Societe($db);
$num = $db->num_rows($result); $i = 0; $help_url='EN:Module_Stocks_En|FR:Module_Stock|ES:Módulo_Stocks'; llxHeader("",$langs->trans("EnhancedValueOfWarehouses"),$help_url); print_barre_liste($langs->trans("EnhancedValueOfWarehouses"), $page, "valo.php", "", $sortfield, $sortorder,'',$num); print '<table class="noborder" width="100%">'; print "<tr class=\"liste_titre\">"; print_liste_field_titre($langs->trans("Ref"),"valo.php", "e.label","","","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("LocationSummary"),"valo.php", "e.lieu","","","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("EstimatedStockValue"),"valo.php", "e.valo_pmp",'','','align="right"',$sortfield,$sortorder); print_liste_field_titre($langs->trans("EstimatedStockValueSell"),"", "",'','','align="right"',$sortfield,$sortorder); print_liste_field_titre($langs->trans("Status"),"valo.php", "e.statut",'','','align="right"',$sortfield,$sortorder); print "</tr>\n"; if ($num) { $entrepot=new Entrepot($db); $total = $totalsell = 0; $var=false; while ($i < min($num,$limit)) { $objp = $db->fetch_object($result); print "<tr $bc[$var]>"; print '<td><a href="fiche.php?id='.$objp->ref.'">'.img_object($langs->trans("ShowWarehouse"),'stock').' '.$objp->label.'</a></td>'; print '<td>'.$objp->lieu.'</td>'; // PMP value print '<td align="right">';
$i = 0; print "<table class=\"noborder\" width=\"100%\">"; print '<tr class="liste_titre">'; if ($agentid > 0) { print_liste_field_titre($langs->trans("Customer"), $_SERVER["PHP_SELF"], "s.nom", "", "&agentid=" . $agentid, '', $sortfield, $sortorder); } else { print_liste_field_titre($langs->trans("SalesRepresentative"), $_SERVER["PHP_SELF"], "u.lastname", "", "&agentid=" . $agentid, '', $sortfield, $sortorder); } print_liste_field_titre($langs->trans("SellingPrice"), $_SERVER["PHP_SELF"], "selling_price", "", "&agentid=" . $agentid, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("BuyingPrice"), $_SERVER["PHP_SELF"], "buying_price", "", "&agentid=" . $agentid, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Margin"), $_SERVER["PHP_SELF"], "marge", "", "&agentid=" . $agentid, 'align="right"', $sortfield, $sortorder); if (!empty($conf->global->DISPLAY_MARGIN_RATES)) { print_liste_field_titre($langs->trans("MarginRate"), $_SERVER["PHP_SELF"], "", "", "&agentid=" . $agentid, 'align="right"', $sortfield, $sortorder); } if (!empty($conf->global->DISPLAY_MARK_RATES)) { print_liste_field_titre($langs->trans("MarkRate"), $_SERVER["PHP_SELF"], "", "", "&agentid=" . $agentid, 'align="right"', $sortfield, $sortorder); } print "</tr>\n"; $rounding = min($conf->global->MAIN_MAX_DECIMALS_UNIT, $conf->global->MAIN_MAX_DECIMALS_TOT); if ($num > 0) { $var = true; while ($i < $num) { $objp = $db->fetch_object($result); $pa = $objp->buying_price; $pv = $objp->selling_price; $marge = $objp->marge; if ($marge < 0) { $marginRate = $pa != 0 ? -1 * (100 * $marge / $pa) : ''; $markRate = $pv != 0 ? -1 * (100 * $marge / $pv) : ''; } else { $marginRate = $pa != 0 ? 100 * $marge / $pa : '';
} else { print_barre_liste($langs->trans("Donations"), $page, $_SERVER["PHP_SELF"], $param, '', '', '', $num); } print '<form method="get" action="' . $_SERVER["PHP_SELF"] . '">' . "\n"; print "<table class=\"noborder\" width=\"100%\">"; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Ref"), $_SERVER["PHP_SELF"], "d.rowid", "&page={$page}&statut={$statut}", "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("Company"), $_SERVER["PHP_SELF"], "d.societe", "&page={$page}&statut={$statut}", "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("Name"), $_SERVER["PHP_SELF"], "d.lastname", "&page={$page}&statut={$statut}", "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("Date"), $_SERVER["PHP_SELF"], "d.datedon", "&page={$page}&statut={$statut}", "", 'align="center"', $sortfield, $sortorder); if (!empty($conf->projet->enabled)) { $langs->load("projects"); print_liste_field_titre($langs->trans("Project"), $_SERVER["PHP_SELF"], "fk_projet", "&page={$page}&statut={$statut}", "", "", $sortfield, $sortorder); } print_liste_field_titre($langs->trans("Amount"), $_SERVER["PHP_SELF"], "d.amount", "&page={$page}&statut={$statut}", "", 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Status"), $_SERVER["PHP_SELF"], "d.fk_statut", "&page={$page}&statut={$statut}", "", 'align="right"', $sortfield, $sortorder); print "</tr>\n"; // Filters lines print '<tr class="liste_titre">'; print '<td class="liste_titre">'; print '<input class="flat" size="10" type="text" name="search_ref" value="' . $search_ref . '">'; print '</td>'; print '<td class="liste_titre">'; print '<input class="flat" size="10" type="text" name="search_company" value="' . $search_company . '">'; print '</td>'; print '<td class="liste_titre">'; print '<input class="flat" size="10" type="text" name="search_name" value="' . $search_name . '">'; print '</td>'; print '<td class="liste_titre" align="left">'; print ' '; print '</td>';
} $db->free($resql); } else { dol_print_error($db); } print '</table>'; print '<br>'; // List of notifications done print_fiche_titre($langs->trans("ListOfNotificationsDone"), '', ''); $var = true; // Line with titles print '<table width="100%" class="noborder">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Contact"), "fiche.php", "c.lastname", '', $param, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Action"), "fiche.php", "a.titre", '', $param, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Date"), "fiche.php", "a.daten", '', $param, 'align="right"', $sortfield, $sortorder); print '</tr>'; // List $sql = "SELECT n.rowid, n.daten, n.email, n.objet_type, n.objet_id,"; $sql .= " c.rowid as id, c.lastname, c.firstname, c.email,"; $sql .= " a.code, a.label"; $sql .= " FROM " . MAIN_DB_PREFIX . "c_action_trigger as a,"; $sql .= " " . MAIN_DB_PREFIX . "notify as n, "; $sql .= " " . MAIN_DB_PREFIX . "socpeople as c"; $sql .= " WHERE a.rowid = n.fk_action"; $sql .= " AND c.rowid = n.fk_contact"; $sql .= " AND c.fk_soc = " . $object->id; $resql = $db->query($sql); if ($resql) { $num = $db->num_rows($resql); $i = 0;
$sql .= $db->order($sortfield, $sortorder); $sql .= $db->plimit($limit + 1, $offset); $result = $db->query($sql); if ($result) { $num = $db->num_rows($result); $i = 0; $help_url = 'EN:Module_Stocks_En|FR:Module_Stock|ES:Módulo_Stocks'; llxHeader("", $langs->trans("EnhancedValueOfWarehouses"), $help_url); print_barre_liste($langs->trans("EnhancedValueOfWarehouses"), $page, $_SERVER["PHP_SELF"], "", $sortfield, $sortorder, '', $num); print '<table class="noborder" width="100%">'; print "<tr class=\"liste_titre\">"; print_liste_field_titre($langs->trans("Ref"), $_SERVER["PHP_SELF"], "e.label", "", "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("LocationSummary"), $_SERVER["PHP_SELF"], "e.lieu", "", "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("EstimatedStockValue"), $_SERVER["PHP_SELF"], "e.valo_pmp", '', '', 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("EstimatedStockValueSell"), $_SERVER["PHP_SELF"], "", '', '', 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Status"), $_SERVER["PHP_SELF"], "e.statut", '', '', 'align="right"', $sortfield, $sortorder); print "</tr>\n"; if ($num) { $entrepot = new Entrepot($db); $total = $totalsell = 0; $var = false; while ($i < min($num, $limit)) { $objp = $db->fetch_object($result); print "<tr " . $bc[$var] . ">"; print '<td><a href="card.php?id=' . $objp->rowid . '">' . img_object($langs->trans("ShowWarehouse"), 'stock') . ' ' . $objp->ref . '</a></td>'; print '<td>' . $objp->lieu . '</td>'; // PMP value print '<td align="right">'; if (price2num($objp->estimatedvalue, 'MT')) { print price(price2num($objp->estimatedvalue, 'MT'), 1); } else {
$resql = $db->query($sql); if ($resql) { $num = $db->num_rows($resql); $i = 0; $var=True; print_barre_liste($langs->trans("ReceivedCustomersPaymentsToValid"), $page, "avalider.php","",$sortfield,$sortorder,'',$num); print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Ref"),"avalider.php","p.rowid","","",'width="60"',$sortfield,$sortorder); print_liste_field_titre($langs->trans("Date"),"avalider.php","dp","","",'width="80" align="center"',$sortfield,$sortorder); print_liste_field_titre($langs->trans("Type"),"avalider.php","c.libelle","","","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("AmountTTC"),"avalider.php","c.libelle","","",'align="right"',$sortfield,$sortorder); print "<td> </td>"; print "</tr>\n"; while ($i < min($num,$limit)) { $objp = $db->fetch_object($resql); $var=!$var; print "<tr $bc[$var]>"; print '<td>'.'<a href="'.DOL_URL_ROOT.'/compta/paiement/fiche.php?id='.$objp->rowid.'">'.img_object($langs->trans("ShowPayment"),"payment").' '.$objp->rowid.'</a></td>'; print '<td width="80" align="center">'.dol_print_date($db->jdate($objp->dp),'day')."</td>\n"; print "<td>$objp->paiement_type $objp->num_paiement</td>\n"; print '<td align="right">'.price($objp->amount).'</td>'; print '<td align="center">'; if ($objp->statut == 0)
$titre=($socid?$langs->trans("BillsSuppliersUnpaidForCompany",$soc->nom):$langs->trans("BillsSuppliersUnpaid")); print_barre_liste($titre,$page,"impayees.php","&socid=$socid",$sortfield,$sortorder,'',0); // We don't want pagination on this page $i = 0; print '<table class="liste" width="100%">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Ref"),$_SERVER["PHP_SELF"],"f.rowid","","&socid=$socid","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("RefSupplier"),$_SERVER["PHP_SELF"],"f.facnumber","","&socid=$socid","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("Date"),$_SERVER["PHP_SELF"],"f.datef","","&socid=$socid",'align="center"',$sortfield,$sortorder); print_liste_field_titre($langs->trans("DateDue"),$_SERVER["PHP_SELF"],"f.date_lim_reglement","","&socid=$socid",'align="center"',$sortfield,$sortorder); print_liste_field_titre($langs->trans("Company"),$_SERVER["PHP_SELF"],"s.nom","","&socid=$socid","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("AmountHT"),$_SERVER["PHP_SELF"],"f.total_ht","","&socid=$socid",'align="right"',$sortfield,$sortorder); print_liste_field_titre($langs->trans("AmountTTC"),$_SERVER["PHP_SELF"],"f.total_ttc","","&socid=$socid",'align="right"',$sortfield,$sortorder); print_liste_field_titre($langs->trans("AlreadyPaid"),$_SERVER["PHP_SELF"],"am","","&socid=$socid",'align="right"',$sortfield,$sortorder); print_liste_field_titre($langs->trans("Status"),$_SERVER["PHP_SELF"],"fk_statut,paye,am","","&socid=$socid",'align="right"',$sortfield,$sortorder); print "</tr>\n"; // Lignes des champs de filtre print '<form method="get" action="impayees.php">'; print '<tr class="liste_titre">'; print '<td class="liste_titre">'; print '<input class="flat" size="8" type="text" name="search_ref" value="'.$_GET["search_ref"].'"></td>'; print '<td class="liste_titre">'; print '<input class="flat" size="8" type="text" name="search_ref_supplier" value="'.$_GET["search_ref_supplier"].'"></td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" size="6" name="search_societe" value="'.$_GET["search_societe"].'">'; print '</td><td class="liste_titre" align="right">'; print '<input class="flat" type="text" size="8" name="search_montant_ht" value="'.$_GET["search_montant_ht"].'">';
$urladd = "&statut=".$statut; $urladd .= "&search_bon=".$search_bon; print_barre_liste($langs->trans("WithdrawalsLines"), $page, "liste.php", $urladd, $sortfield, $sortorder, '', $num); print"\n<!-- debut table -->\n"; print '<table class="liste" width="100%">'; print '<tr class="liste_titre">'; print '<td class="liste_titre">'.$langs->trans("Line").'</td>'; print_liste_field_titre($langs->trans("WithdrawalReceipt"),$_SERVER["PHP_SELF"],"p.ref"); print_liste_field_titre($langs->trans("Bill"),$_SERVER["PHP_SELF"],"f.facnumber",'',$urladd); print_liste_field_titre($langs->trans("Company"),$_SERVER["PHP_SELF"],"s.nom"); print_liste_field_titre($langs->trans("CustomerCode"),$_SERVER["PHP_SELF"],"s.code_client",'','','align="center"'); print_liste_field_titre($langs->trans("Date"),$_SERVER["PHP_SELF"],"p.datec","","",'align="center"'); print_liste_field_titre($langs->trans("Amount"),$_SERVER["PHP_SELF"],"pl.amount","","",'align="right"'); print '<td class="liste_titre"> </td>'; print '</tr>'; print '<form action="liste.php" method="GET">'; print '<tr class="liste_titre">'; print '<td class="liste_titre"><input type="text" class="flat" name="search_ligne" value="'. $search_line.'" size="6"></td>'; print '<td class="liste_titre"><input type="text" class="flat" name="search_bon" value="'. $search_bon.'" size="8"></td>'; print '<td> </td>'; print '<td class="liste_titre"><input type="text" class="flat" name="search_societe" value="'. $search_societe.'" size="12"></td>'; print '<td class="liste_titre" align="center"><input type="text" class="flat" name="search_code" value="'. $search_code.'" size="8"></td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre" align="right"><input type="image" class="liste_titre" src="'.DOL_URL_ROOT.'/theme/'.$conf->theme.'/img/search.png" name="button_search" value="'.dol_escape_htmltag($langs->trans("Search")).'" title="'.dol_escape_htmltag($langs->trans("Search")).'"></td>'; print '</tr>'; print '</form>';
print '></td>'; print '<td colspan="4" align="right">'; print '<input type="image" class="liste_titre" name="button_search" src="' . img_picto($langs->trans("Search"), 'search.png', '', '', 1) . '" value="' . dol_escape_htmltag($langs->trans("Search")) . '" title="' . dol_escape_htmltag($langs->trans("Search")) . '">'; print '</td>'; print '</tr>'; // Array titles print "<tr class='liste_titre'>"; print_liste_field_titre($langs->trans("Company"), $_SERVER["PHP_SELF"], "nom", "", $paramslink, "", $sortfield, $sortorder); if ($modecompta == 'CREANCES-DETTES') { print_liste_field_titre($langs->trans('AmountHT'), $_SERVER["PHP_SELF"], "amount_ht", "", $paramslink, 'align="right"', $sortfield, $sortorder); } else { print '<td colspan="1"></td>'; } print_liste_field_titre($langs->trans("AmountTTC"), $_SERVER["PHP_SELF"], "amount_ttc", "", $paramslink, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Percentage"), $_SERVER["PHP_SELF"], "amount_ttc", "", $paramslink, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("OtherStatistics"), $_SERVER["PHP_SELF"], "", "", "", 'align="center" width="20%"'); print "</tr>\n"; $var = true; if (count($amount)) { $arrayforsort = $name; // Defining array arrayforsort if ($sortfield == 'nom' && $sortorder == 'asc') { asort($name); $arrayforsort = $name; } if ($sortfield == 'nom' && $sortorder == 'desc') { arsort($name); $arrayforsort = $name; } if ($sortfield == 'amount_ht' && $sortorder == 'asc') { asort($amount_ht);
if ($result) { $num = $db->num_rows($result); print_barre_liste($langs->trans("Proposals"), $page, "propal.php","&socid=$socid&month=$month&year=$year&search_ref=$search_ref&search_societe=$search_societe&search_montant_ht=$search_montant_ht".'&viewstatut='.$viewstatut,$sortfield,$sortorder,'',$num); $i = 0; $var=true; print "<table class=\"noborder\" width=\"100%\">"; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Ref"),"propal.php","p.ref","","&year=$year&viewstatut=$viewstatut",'width=20%',$sortfield,$sortorder); print_liste_field_titre($langs->trans("Company"),"propal.php","s.nom","&viewstatut=$viewstatut","",'',$sortfield,$sortorder); print_liste_field_titre($langs->trans("Date"),"propal.php","p.datep","&viewstatut=$viewstatut","",'align="right"',$sortfield,$sortorder); print_liste_field_titre($langs->trans("AmountHT"),"propal.php","p.price","&viewstatut=$viewstatut","",'align="right"',$sortfield,$sortorder); print_liste_field_titre($langs->trans("Status"),"propal.php","p.fk_statut","&viewstatut=$viewstatut","",'align="right"',$sortfield,$sortorder); print '<td class="liste_titre"> </td>'; print "</tr>\n"; // Lignes des champs de filtre print '<form method="get" action="'.$_SERVER["PHP_SELF"].'">'; print '<tr class="liste_titre">'; print '<td class="liste_titre" valign="right">'; print '<input class="flat" size="10" type="text" name="search_ref" value="'.$_GET['search_ref'].'">'; print '</td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" size="40" name="search_societe" value="'.$_GET['search_societe'].'">'; print '</td>'; print '<td class="liste_titre" colspan="1" align="right">'; print $langs->trans('Month').': <input class="flat" type="text" size="2" maxlength="2" name="month" value="'.$month.'">';
$reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters); // Note that $action and $object may have been modified by hook print $hookmanager->resPrint; if (!empty($arrayfields['p.datec']['checked'])) { print_liste_field_titre($arrayfields['p.datec']['label'], $_SERVER["PHP_SELF"], "p.datec", "", $param, 'align="center" class="nowrap"', $sortfield, $sortorder); } if (!empty($arrayfields['p.tms']['checked'])) { print_liste_field_titre($arrayfields['p.tms']['label'], $_SERVER["PHP_SELF"], "p.tms", "", $param, 'align="center" class="nowrap"', $sortfield, $sortorder); } if (!empty($arrayfields['p.tosell']['checked'])) { print_liste_field_titre($langs->trans("Status") . ' (' . $langs->trans("Sell") . ')', $_SERVER["PHP_SELF"], "p.tosell", "", $param, 'align="center"', $sortfield, $sortorder); } if (!empty($arrayfields['p.tobuy']['checked'])) { print_liste_field_titre($langs->trans("Status") . ' (' . $langs->trans("Buy") . ')', $_SERVER["PHP_SELF"], "p.tobuy", "", $param, 'align="center"', $sortfield, $sortorder); } print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], "", '', '', 'align="right"', $sortfield, $sortorder, 'maxwidthsearch '); print "</tr>\n"; // Lines with input filters print '<tr class="liste_titre">'; if (!empty($arrayfields['p.ref']['checked'])) { print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" name="sref" size="8" value="' . dol_escape_htmltag($sref) . '">'; print '</td>'; } if (!empty($arrayfields['pfp.ref_fourn']['checked'])) { print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" name="search_ref_supplier" size="8" value="' . dol_escape_htmltag($search_ref_supplier) . '">'; print '</td>'; } if (!empty($arrayfields['p.label']['checked'])) { print '<td class="liste_titre" align="left">';
/** * Show array with linked files * * @param Object $object Object * @param int $permtodelete Deletion is allowed * @param string $action Action * @param string $selected ??? * @param string $param More param to add into URL * @return int Number of links */ public function listOfLinks($object, $permtodelete = 1, $action = null, $selected = null, $param = '') { global $user, $conf, $langs, $user; global $bc; global $sortfield, $sortorder; $langs->load("link"); require_once DOL_DOCUMENT_ROOT . '/core/class/link.class.php'; $link = new Link($this->db); $links = array(); if ($sortfield == "name") { $sortfield = "label"; } elseif ($sortfield == "date") { $sortfield = "datea"; } else { $sortfield = null; } $res = $link->fetchAll($links, $object->element, $object->id, $sortfield, $sortorder); $param .= isset($object->id) ? '&id=' . $object->id : ''; // Show list of associated links print load_fiche_titre($langs->trans("LinkedFiles")); print '<form action="' . $_SERVER['PHP_SELF'] . ($param ? '?' . $param : '') . '" method="POST">'; print '<table width="100%" class="liste">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Links"), $_SERVER['PHP_SELF'], "name", "", $param, 'align="left"', $sortfield, $sortorder); print_liste_field_titre("", "", "", "", "", 'align="right"'); print_liste_field_titre($langs->trans("Date"), $_SERVER['PHP_SELF'], "date", "", $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre('', $_SERVER['PHP_SELF'], "", "", $param, 'align="center"'); print_liste_field_titre('', '', ''); print '</tr>'; $nboflinks = count($links); if ($nboflinks > 0) { include_once DOL_DOCUMENT_ROOT . '/core/lib/images.lib.php'; } $var = true; foreach ($links as $link) { $var = !$var; print '<tr ' . $bc[$var] . '>'; //edit mode if ($action == 'update' && $selected === $link->id) { print '<td>'; print '<input type="hidden" name="id" value="' . $object->id . '">'; print '<input type="hidden" name="linkid" value="' . $link->id . '">'; print '<input type="hidden" name="action" value="confirm_updateline">'; print $langs->trans('Link') . ': <input type="text" name="link" size="50" value="' . $link->url . '">'; print '</td>'; print '<td>'; print $langs->trans('Label') . ': <input type="text" name="label" value="' . $link->label . '">'; print '</td>'; print '<td align="center">' . dol_print_date(dol_now(), "dayhour", "tzuser") . '</td>'; print '<td align="right"></td>'; print '<td align="right">'; print '<input type="submit" name="save" class="button" value="' . dol_escape_htmltag($langs->trans('Save')) . '">'; print '<input type="submit" name="cancel" class="button" value="' . dol_escape_htmltag($langs->trans('Cancel')) . '">'; print '</td>'; } else { print '<td>'; print '<a data-ajax="false" href="' . $link->url . '" target="_blank">'; print $link->label; print '</a>'; print '</td>' . "\n"; print '<td align="right"></td>'; print '<td align="center">' . dol_print_date($link->datea, "dayhour", "tzuser") . '</td>'; print '<td align="center"></td>'; print '<td align="right">'; print '<a href="' . $_SERVER['PHP_SELF'] . '?action=update&linkid=' . $link->id . $param . '" class="editfilelink" >' . img_edit() . '</a>'; // id= is included into $param if ($permtodelete) { print ' <a href="' . $_SERVER['PHP_SELF'] . '?action=delete&linkid=' . $link->id . $param . '" class="deletefilelink">' . img_delete() . '</a>'; // id= is included into $param } else { print ' '; } print '</td>'; } print "</tr>\n"; } if ($nboflinks == 0) { print '<tr ' . $bc[false] . '><td colspan="5">'; print $langs->trans("NoLinkFound"); print '</td></tr>'; } print "</table>"; print '</form>'; return $nboflinks; }
print '<table class="noborder nohover" width="100%">'; print '<tr class="liste_titre"><td colspan="3">' . $langs->trans("SearchAProject") . '</td></tr>'; print '<tr ' . $bc[$var] . '>'; print '<td class="nowrap"><label for="sf_ref">' . $langs->trans("Ref") . '</label>:</td><td><input type="text" class="flat" name="search_ref" id="sf_ref" size="18"></td>'; print '<td rowspan="2"><input type="submit" value="' . $langs->trans("Search") . '" class="button"></td></tr>'; print '<tr ' . $bc[$var] . '><td class="nowrap"><label for="sall">' . $langs->trans("Other") . '</label>:</td><td><input type="text" class="flat" name="search_all" id="search_all" size="18"></td>'; print '</tr>'; print "</table></form>\n"; print "<br>\n"; } print_projecttasks_array($db, $socid, $projectsListId, 0, 0); print '</div><div class="fichetwothirdright"><div class="ficheaddleft">'; print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("ThirdParties"), $_SERVER["PHP_SELF"], "s.nom", "", "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("NbOfProjects"), "", "", "", "", 'align="right"', $sortfield, $sortorder); print "</tr>\n"; $sql = "SELECT count(p.rowid) as nb"; $sql .= ", s.nom as name, s.rowid as socid"; $sql .= " FROM " . MAIN_DB_PREFIX . "projet as p"; $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "societe as s on p.fk_soc = s.rowid"; $sql .= " WHERE p.entity = " . $conf->entity; if ($mine || empty($user->rights->projet->all->lire)) { $sql .= " AND p.rowid IN (" . $projectsListId . ")"; } if ($socid) { $sql .= " AND (p.fk_soc IS NULL OR p.fk_soc = 0 OR p.fk_soc = " . $socid . ")"; } $sql .= " GROUP BY s.nom, s.rowid"; $var = true; $resql = $db->query($sql);
print_fiche_titre($titre, $link); //print_barre_liste($titre,$page,$_SERVER["PHP_SELF"],$param,$sortfield,$sortorder,'',0); // We don't want pagination on this page dol_htmloutput_mesg($mesg); $i = 0; print '<table class="liste" width="100%">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Ref"), $_SERVER["PHP_SELF"], "f.facnumber", "", $param, "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("Date"), $_SERVER["PHP_SELF"], "f.datef", "", $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("DateDue"), $_SERVER["PHP_SELF"], "f.date_lim_reglement", "", $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Company"), $_SERVER["PHP_SELF"], "s.nom", "", $param, "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("AmountHT"), $_SERVER["PHP_SELF"], "f.total", "", $param, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("AmountTTC"), $_SERVER["PHP_SELF"], "f.total_ttc", "", $param, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Received"), $_SERVER["PHP_SELF"], "am", "", $param, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Rest"), $_SERVER["PHP_SELF"], "am", "", $param, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Status"), $_SERVER["PHP_SELF"], "fk_statut,paye,am", "", $param, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Merge"), $_SERVER["PHP_SELF"], "", "", $param, 'align="center"', $sortfield, $sortorder); print "</tr>\n"; // Lignes des champs de filtre print '<form method="GET" action="' . $_SERVER["PHP_SELF"] . '">'; print '<tr class="liste_titre">'; // Ref print '<td class="liste_titre">'; print '<input class="flat" size="10" type="text" name="search_ref" value="' . $search_ref . '"></td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" size="12" name="search_societe" value="' . $search_societe . '">'; print '</td><td class="liste_titre" align="right">'; print '<input class="flat" type="text" size="10" name="search_montant_ht" value="' . $search_montant_ht . '">'; print '</td><td class="liste_titre" align="right">'; print '<input class="flat" type="text" size="10" name="search_montant_ttc" value="' . $search_montant_ttc . '">';
$sql .= ", p.datec"; $sql .= " FROM " . MAIN_DB_PREFIX . "prelevement_bons as p"; $sql .= " WHERE p.entity = " . $conf->entity; $sql .= " ORDER BY {$sortfield} {$sortorder} "; $sql .= $db->plimit($conf->liste_limit + 1, $offset); $result = $db->query($sql); if ($result) { $num = $db->num_rows($result); $i = 0; $urladd = "&statut=" . $statut; print_barre_liste($langs->trans("WithdrawalsReceipts"), $page, "bons.php", $urladd, $sortfield, $sortorder, '', $num); print "\n<!-- debut table -->\n"; print '<table class="liste" width="100%">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("WithdrawalsReceipts"), "bons.php", "p.ref", '', '', 'class="liste_titre"'); print_liste_field_titre($langs->trans("Date"), "bons.php", "p.datec", "", "", 'class="liste_titre" align="center"'); print '<td class="liste_titre" align="right">' . $langs->trans("Amount") . '</td>'; print '</tr>'; print '<tr class="liste_titre">'; print '<form action="bons.php" method="GET">'; print '<td class="liste_titre"><input type="text" class="flat" name="search_ligne" value="' . $search_line . '" size="10"></td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre" align="right"><input type="image" class="liste_titre" src="' . img_picto($langs->trans("Search"), 'search.png', '', '', 1) . '" name="button_search" value="' . dol_escape_htmltag($langs->trans("Search")) . '" title="' . dol_escape_htmltag($langs->trans("Search")) . '"></td>'; print '</form>'; print '</tr>'; $var = True; while ($i < min($num, $conf->liste_limit)) { $obj = $db->fetch_object($result); $var = !$var; print "<tr " . $bc[$var] . "><td>"; print $bon->LibStatut($obj->statut, 2);
print '<form method="POST" action="' . $_SERVER["PHP_SELF"] . '">'; print '<table class="noborder" width="100%">'; print '<br><div class="inline-block divButAction">' . $langs->trans("ChangeAccount") . '<br>'; print $formventilation->select_account($account_parent, 'account_parent', 1); print '<input type="submit" class="butAction" value="' . $langs->trans("Validate") . '"/></div>'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Invoice"), $_SERVER["PHP_SELF"], "f.facnumber", "", $param, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Ref"), $_SERVER["PHP_SELF"], "p.ref", "", $param, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Label"), $_SERVER["PHP_SELF"], "p.label", "", $param, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Description"), $_SERVER["PHP_SELF"], "l.description", "", $param, '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Amount"), $_SERVER["PHP_SELF"], "l.total_ht", "", $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("VATRate"), $_SERVER["PHP_SELF"], "l.tva_tx", "", $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Account"), $_SERVER["PHP_SELF"], "aa.account_number", "", $param, 'align="center"', $sortfield, $sortorder); print_liste_field_titre(''); print_liste_field_titre(''); print_liste_field_titre($langs->trans("Ventilate") . '<br><label id="select-all">' . $langs->trans('All') . '</label>/<label id="unselect-all">' . $langs->trans('None') . '</label>', '', '', '', '', 'align="center"'); print "</tr>\n"; print '<tr class="liste_titre">'; print '<td class="liste_titre"><input type="text" class="flat" name="search_invoice" size="10" value="' . $search_invoice . '"></td>'; print '<td class="liste_titre"><input type="text" class="flat" size="15" name="search_ref" value="' . $search_ref . '"></td>'; print '<td class="liste_titre"><input type="text" class="flat" size="15" name="search_label" value="' . $search_label . '"></td>'; print '<td class="liste_titre"><input type="text" class="flat" size="15" name="search_desc" value="' . $search_desc . '"></td>'; print '<td class="liste_titre" align="center"><input type="text" class="flat" size="8" name="search_amount" value="' . $search_amount . '"></td>'; print '<td class="liste_titre" align="center"><input type="text" class="flat" size="5" name="search_vat" value="' . $search_vat . '">%</td>'; print '<td class="liste_titre" align="center"><input type="text" class="flat" size="15" name="search_account" value="' . $search_account . '"></td>'; print '<td class="liste_titre" colspan="2"> </td>'; print '<td class="liste_titre" align="center"><input type="image" class="liste_titre" name="button_search" src="' . img_picto($langs->trans("Search"), 'search.png', '', '', 1) . '" value="' . dol_escape_htmltag($langs->trans("Search")) . '" title="' . dol_escape_htmltag($langs->trans("Search")) . '">'; print '<input type="image" class="liste_titre" name="button_removefilter" src="' . img_picto($langs->trans("Search"), 'searchclear.png', '', '', 1) . '" value="' . dol_escape_htmltag($langs->trans("RemoveFilter")) . '" title="' . dol_escape_htmltag($langs->trans("RemoveFilter")) . '">'; print "</td></tr>\n"; $facture_static = new Facture($db); $product_static = new Product($db);