コード例 #1
0
ファイル: liste.php プロジェクト: remyyounes/dolibarr
	{
		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>';
コード例 #2
0
 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 '&nbsp;'.$langs->trans('Year').': ';
 //$syear = GETPOST('year')?GETPOST('year'):-1;
 //$formother->select_year($syear,'year',1, 20, 5);
 print '</td>';
 echo '<td>';
コード例 #3
0
 /* 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", "&amp;id=" . $id, "", "", $sortfield, $sortorder);
 print_liste_field_titre($langs->trans("Label"), "", "p.label", "&amp;id=" . $id, "", "", $sortfield, $sortorder);
 print_liste_field_titre($langs->trans("Units"), "", "ps.reel", "&amp;id=" . $id, "", 'align="right"', $sortfield, $sortorder);
 print_liste_field_titre($langs->trans("AverageUnitPricePMPShort"), "", "ps.pmp", "&amp;id=" . $id, "", 'align="right"', $sortfield, $sortorder);
 print_liste_field_titre($langs->trans("EstimatedStockValueShort"), "", "", "&amp;id=" . $id, "", 'align="right"', $sortfield, $sortorder);
 if (empty($conf->global->PRODUIT_MULTIPRICES)) {
     print_liste_field_titre($langs->trans("SellPriceMin"), "", "p.price", "&amp;id=" . $id, "", 'align="right"', $sortfield, $sortorder);
 }
 if (empty($conf->global->PRODUIT_MULTIPRICES)) {
     print_liste_field_titre($langs->trans("EstimatedStockValueSellShort"), "", "", "&amp;id=" . $id, "", 'align="right"', $sortfield, $sortorder);
 }
 if ($user->rights->stock->mouvement->creer) {
     print '<td>&nbsp;</td>';
 }
 if ($user->rights->stock->creer) {
     print '<td>&nbsp;</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";
コード例 #4
0
ファイル: list.php プロジェクト: TAASA/Dolibarr-ERP-3.8.1
     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').': ';
コード例 #5
0
     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">&nbsp;</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">&nbsp;</td>';
     print '<td class="liste_titre">&nbsp;</td>';
     print '<td class="liste_titre">&nbsp;</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>';
コード例 #6
0
ファイル: paiement.php プロジェクト: netors/dolibarr
     $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>&nbsp;</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>&nbsp;</td>';
         print '</tr>';
         $i++;
     }
     print '</table>';
 }
コード例 #7
0
} 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>';
コード例 #8
0
ファイル: contrat.php プロジェクト: remyyounes/dolibarr
		$result = $db->query($sql);
		if ($result)
		{
			$num = $db->num_rows($result);

			print_barre_liste($langs->trans("Contrats"),$page,$_SERVER["PHP_SELF"],"&amp;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","","&amp;id=".$_GET["id"],'',$sortfield,$sortorder);
			print_liste_field_titre($langs->trans("Company"),$_SERVER["PHP_SELF"],"s.nom","","&amp;id=".$_GET["id"],'',$sortfield,$sortorder);
			print_liste_field_titre($langs->trans("CustomerCode"),$_SERVER["PHP_SELF"],"s.code_client","","&amp;id=".$_GET["id"],'',$sortfield,$sortorder);
			print_liste_field_titre($langs->trans("Date"),$_SERVER["PHP_SELF"],"c.date_contrat","","&amp;id=".$_GET["id"],'align="center"',$sortfield,$sortorder);
			//print_liste_field_titre($langs->trans("AmountHT"),$_SERVER["PHP_SELF"],"c.amount","","&amp;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;
コード例 #9
0
ファイル: list.php プロジェクト: ADDAdev/Dolibarr
     $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">&nbsp;</td>';
     print '<td class="liste_titre">&nbsp;</td>';
     print '<td class="liste_titre">&nbsp;</td>';
 }
コード例 #10
0
ファイル: liste.php プロジェクト: nrjacker4/crm-php
$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 = "&amp;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;
コード例 #11
0
ファイル: index.php プロジェクト: ADDAdev/Dolibarr
 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";
コード例 #12
0
ファイル: avalider.php プロジェクト: ADDAdev/Dolibarr
}
$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>&nbsp;</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 . '&amp;action=valide">' . $langs->trans("PaymentStatusToValidShort") . '</a>';
        } else {
            print "-";
コード例 #13
0
 $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"], "&amp;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", "", "&amp;id=" . $product->id, '', $sortfield, $sortorder);
     print_liste_field_titre($langs->trans("Company"), $_SERVER["PHP_SELF"], "s.nom", "", "&amp;id=" . $product->id, '', $sortfield, $sortorder);
     print_liste_field_titre($langs->trans("SupplierCode"), $_SERVER["PHP_SELF"], "s.code_client", "", "&amp;id=" . $product->id, '', $sortfield, $sortorder);
     print_liste_field_titre($langs->trans("OrderDate"), $_SERVER["PHP_SELF"], "c.date_commande", "", "&amp;id=" . $product->id, 'align="center"', $sortfield, $sortorder);
     print_liste_field_titre($langs->trans("Qty"), $_SERVER["PHP_SELF"], "d.qty", "", "&amp;id=" . $product->id, 'align="center"', $sortfield, $sortorder);
     print_liste_field_titre($langs->trans("AmountHT"), $_SERVER["PHP_SELF"], "c.total_ht", "", "&amp;id=" . $product->id, 'align="right"', $sortfield, $sortorder);
     print_liste_field_titre($langs->trans("Status"), $_SERVER["PHP_SELF"], "c.fk_statut", "", "&amp;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";
コード例 #14
0
ファイル: list.php プロジェクト: nrjacker4/crm-php
$result = $db->query($sql);
if ($result) {
    $num = $db->num_rows($result);
    $interventionstatic = new Fichinter($db);
    $urlparam = "&amp;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">&nbsp;</td>';
    print '<td class="liste_titre">&nbsp;</td>';
    print '<td class="liste_titre">&nbsp;</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);
コード例 #15
0
ファイル: valo.php プロジェクト: nrjacker4/crm-php
    $num = $db->num_rows($result);

    $i = 0;

    $help_url='EN:Module_Stocks_En|FR:Module_Stock|ES:M&oacute;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">';
コード例 #16
0
 $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", "", "&amp;agentid=" . $agentid, '', $sortfield, $sortorder);
 } else {
     print_liste_field_titre($langs->trans("SalesRepresentative"), $_SERVER["PHP_SELF"], "u.lastname", "", "&amp;agentid=" . $agentid, '', $sortfield, $sortorder);
 }
 print_liste_field_titre($langs->trans("SellingPrice"), $_SERVER["PHP_SELF"], "selling_price", "", "&amp;agentid=" . $agentid, 'align="right"', $sortfield, $sortorder);
 print_liste_field_titre($langs->trans("BuyingPrice"), $_SERVER["PHP_SELF"], "buying_price", "", "&amp;agentid=" . $agentid, 'align="right"', $sortfield, $sortorder);
 print_liste_field_titre($langs->trans("Margin"), $_SERVER["PHP_SELF"], "marge", "", "&amp;agentid=" . $agentid, 'align="right"', $sortfield, $sortorder);
 if (!empty($conf->global->DISPLAY_MARGIN_RATES)) {
     print_liste_field_titre($langs->trans("MarginRate"), $_SERVER["PHP_SELF"], "", "", "&amp;agentid=" . $agentid, 'align="right"', $sortfield, $sortorder);
 }
 if (!empty($conf->global->DISPLAY_MARK_RATES)) {
     print_liste_field_titre($langs->trans("MarkRate"), $_SERVER["PHP_SELF"], "", "", "&amp;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 : '';
コード例 #17
0
ファイル: list.php プロジェクト: TAASA/Dolibarr-ERP-3.8.1
 } 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 '&nbsp;';
 print '</td>';
コード例 #18
0
     }
     $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;
コード例 #19
0
ファイル: valo.php プロジェクト: ADDAdev/Dolibarr
$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&oacute;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 {
コード例 #20
0
ファイル: avalider.php プロジェクト: remyyounes/dolibarr
$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>&nbsp;</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)
コード例 #21
0
ファイル: impayees.php プロジェクト: remyyounes/dolibarr
		$titre=($socid?$langs->trans("BillsSuppliersUnpaidForCompany",$soc->nom):$langs->trans("BillsSuppliersUnpaid"));
		print_barre_liste($titre,$page,"impayees.php","&amp;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","","&amp;socid=$socid","",$sortfield,$sortorder);
		print_liste_field_titre($langs->trans("RefSupplier"),$_SERVER["PHP_SELF"],"f.facnumber","","&amp;socid=$socid","",$sortfield,$sortorder);
		print_liste_field_titre($langs->trans("Date"),$_SERVER["PHP_SELF"],"f.datef","","&amp;socid=$socid",'align="center"',$sortfield,$sortorder);
		print_liste_field_titre($langs->trans("DateDue"),$_SERVER["PHP_SELF"],"f.date_lim_reglement","","&amp;socid=$socid",'align="center"',$sortfield,$sortorder);
		print_liste_field_titre($langs->trans("Company"),$_SERVER["PHP_SELF"],"s.nom","","&amp;socid=$socid","",$sortfield,$sortorder);
		print_liste_field_titre($langs->trans("AmountHT"),$_SERVER["PHP_SELF"],"f.total_ht","","&amp;socid=$socid",'align="right"',$sortfield,$sortorder);
		print_liste_field_titre($langs->trans("AmountTTC"),$_SERVER["PHP_SELF"],"f.total_ttc","","&amp;socid=$socid",'align="right"',$sortfield,$sortorder);
		print_liste_field_titre($langs->trans("AlreadyPaid"),$_SERVER["PHP_SELF"],"am","","&amp;socid=$socid",'align="right"',$sortfield,$sortorder);
		print_liste_field_titre($langs->trans("Status"),$_SERVER["PHP_SELF"],"fk_statut,paye,am","","&amp;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">&nbsp;</td>';
		print '<td class="liste_titre">&nbsp;</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"].'">';
コード例 #22
0
ファイル: liste.php プロジェクト: remyyounes/dolibarr
    $urladd = "&amp;statut=".$statut;
    $urladd .= "&amp;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">&nbsp;</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>&nbsp;</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">&nbsp;</td>';
    print '<td class="liste_titre">&nbsp;</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>';
コード例 #23
0
ファイル: casoc.php プロジェクト: ADDAdev/Dolibarr
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);
コード例 #24
0
ファイル: propal.php プロジェクト: remyyounes/dolibarr
	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".'&amp;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">&nbsp;</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.'">';
コード例 #25
0
ファイル: list.php プロジェクト: Albertopf/prueba
 $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">';
コード例 #26
0
 /**
  * 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 ' &nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?action=delete&linkid=' . $link->id . $param . '" class="deletefilelink">' . img_delete() . '</a>';
                 // id= is included into $param
             } else {
                 print '&nbsp;';
             }
             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;
 }
コード例 #27
0
ファイル: index.php プロジェクト: ADDAdev/Dolibarr
    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);
コード例 #28
0
ファイル: impayees.php プロジェクト: nrjacker4/crm-php
 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">&nbsp;</td>';
 print '<td class="liste_titre">&nbsp;</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 . '">';
コード例 #29
0
$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 = "&amp;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">&nbsp;</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);
コード例 #30
0
ファイル: lines.php プロジェクト: Albertopf/prueba
 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">&nbsp;</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);