print_barre_liste PHP代码示例

示例#1

0

显示文件

文件： list.php 项目： Albertopf/prueba

if ($search_user > 0) {
    $sql .= " AND ec.fk_c_type_contact = tc.rowid AND tc.element='contrat' AND tc.source='internal' AND ec.element_id = c.rowid AND ec.fk_socpeople = " . $search_user;
}
$sql .= " GROUP BY c.rowid, c.ref, c.datec, c.date_contrat, c.statut, c.ref_supplier, s.nom, s.rowid";
$totalnboflines = 0;
$result = $db->query($sql);
if ($result) {
    $totalnboflines = $db->num_rows($result);
}
$sql .= $db->order($sortfield, $sortorder);
$sql .= $db->plimit($conf->liste_limit + 1, $offset);
$resql = $db->query($sql);
if ($resql) {
    $num = $db->num_rows($resql);
    $i = 0;
    print_barre_liste($langs->trans("ListOfContracts"), $page, $_SERVER["PHP_SELF"], '&search_contract=' . $search_contract . '&search_name=' . $search_name, $sortfield, $sortorder, '', $num, $totalnboflines, 'title_commercial.png');
    print '<form method="POST" action="' . $_SERVER['PHP_SELF'] . '">';
    if ($optioncss != '') {
        print '<input type="hidden" name="optioncss" value="' . $optioncss . '">';
    }
    print '<input type="hidden" name="token" value="' . $_SESSION['newtoken'] . '">';
    print '<input type="hidden" name="action" value="list">';
    print '<input type="hidden" name="sortfield" value="' . $sortfield . '">';
    print '<input type="hidden" name="sortorder" value="' . $sortorder . '">';
    if ($sall) {
        foreach ($fieldstosearchall as $key => $val) {
            $fieldstosearchall[$key] = $langs->trans($val);
        }
        print $langs->trans("FilterOnInto", $all) . join(', ', $fieldstosearchall);
    }
    // If the user can view prospects other than his'

示例#2

0

显示文件

文件： list.php 项目： Albertopf/prueba

                    } else {
                        print $product_static->LibStatut($objp->tosell, 5, 0);
                    }
                    print '</td>';
                }
                // Status (to buy)
                if (!empty($arrayfields['p.tobuy']['checked'])) {
                    print '<td align="center" nowrap="nowrap">';
                    if (!empty($conf->use_javascript_ajax) && $user->rights->produit->creer && !empty($conf->global->MAIN_DIRECT_STATUS_UPDATE)) {
                        print ajax_object_onoff($product_static, 'status_buy', 'tobuy', 'ProductStatusOnBuy', 'ProductStatusNotOnBuy');
                    } else {
                        print $product_static->LibStatut($objp->tobuy, 5, 1);
                    }
                    print '</td>';
                }
                // Action
                print '<td>&nbsp;</td>';
                print "</tr>\n";
                $i++;
            }
            print_barre_liste('', $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, $nbtotalofrecords, '', '', '', 'paginationatbottom');
            $db->free($resql);
            print "</table>";
            print '</form>';
        }
    } else {
        dol_print_error($db);
    }
}
llxFooter();
$db->close();

示例#3

0

显示文件

文件： bons.php 项目： LionSystemsSolutions/El-Canelo-ERP

/*
 * Mode Liste
 *
 */
$sql = "SELECT p.rowid, p.ref, p.amount, p.statut";
$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;

示例#4

0

显示文件

文件： listsessions.php 项目： LionSystemsSolutions/El-Canelo-ERP

// Unlock new sessions
if ($action == 'confirm_unlock' && $user->admin) {
    if (dolibarr_del_const($db, 'MAIN_ONLY_LOGIN_ALLOWED', -1) < 0) {
        dol_print_error($db);
    }
}
/*
*	View
*/
llxHeader();
$form = new Form($db);
$userstatic = new User($db);
$usefilter = 0;
$listofsessions = listOfSessions();
$num = count($listofsessions);
print_barre_liste($langs->trans("Sessions"), $page, $_SERVER["PHP_SELF"], "", $sortfield, $sortorder, '', $num, 0, 'setup');
$savehandler = ini_get("session.save_handler");
$savepath = ini_get("session.save_path");
$openbasedir = ini_get("open_basedir");
$phparray = phpinfo_array();
$suhosin = empty($phparray['suhosin']["suhosin.session.encrypt"]["local"]) ? '' : $phparray['suhosin']["suhosin.session.encrypt"]["local"];
print '<b>' . $langs->trans("SessionSaveHandler") . '</b>: ' . $savehandler . '<br>';
print '<b>' . $langs->trans("SessionSavePath") . '</b>: ' . $savepath . '<br>';
if ($openbasedir) {
    print '<b>' . $langs->trans("OpenBaseDir") . '</b>: ' . $openbasedir . '<br>';
}
if ($suhosin) {
    print '<b>' . $langs->trans("SuhosinSessionEncrypt") . '</b>: ' . $suhosin . '<br>';
}
print '<br>';
if ($action == 'purge') {

示例#5

0

显示文件

文件： list.php 项目： TAASA/Dolibarr-ERP-3.8.1

 if ($search_user > 0) {
     $param .= '&search_user='******'&search_sale=' . $search_sale;
 }
 if ($search_montant_ht) {
     $param .= '&search_montant_ht=' . $search_montant_ht;
 }
 if ($search_author) {
     $param .= '&search_author=' . $search_author;
 }
 if ($search_town) {
     $param .= '&search_town=' . $search_town;
 }
 print_barre_liste($langs->trans('ListOfProposals') . ' ' . ($socid ? '- ' . $soc->name : ''), $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, $nbtotalofrecords, 'title_commercial.png');
 // Lignes des champs de filtre
 print '<form method="GET" action="' . $_SERVER["PHP_SELF"] . '">';
 $i = 0;
 print '<table class="liste" width="100%">';
 $moreforfilter = '';
 // If the user can view prospects other than his'
 if ($user->rights->societe->client->voir || $socid) {
     $langs->load("commercial");
     $moreforfilter .= '<div class="divsearchfield">';
     $moreforfilter .= $langs->trans('ThirdPartiesOfSaleRepresentative') . ': ';
     $moreforfilter .= $formother->select_salesrepresentatives($search_sale, 'search_sale', $user, 0, 1, 'maxwidth300');
     $moreforfilter .= '</div>';
 }
 // If the user can view prospects other than his'
 if ($user->rights->societe->client->voir || $socid) {

示例#6

0

显示文件

文件： services.php 项目： Samara94/dolibarr

 }
 $title = $langs->trans("ListOfServices");
 if ($mode == "0") {
     $title = $langs->trans("ListOfInactiveServices");
 }
 // Must use == "0"
 if ($mode == "4" && $filter != "expired") {
     $title = $langs->trans("ListOfRunningServices");
 }
 if ($mode == "4" && $filter == "expired") {
     $title = $langs->trans("ListOfExpiredServices");
 }
 if ($mode == "5") {
     $title = $langs->trans("ListOfClosedServices");
 }
 print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, $totalnboflines, 'title_commercial.png');
 print '<form method="POST" action="' . $_SERVER["PHP_SELF"] . '">';
 print '<input type="hidden" name="token" value="' . $_SESSION['newtoken'] . '">';
 print '<table class="liste" width="100%">';
 print '<tr class="liste_titre">';
 print_liste_field_titre($langs->trans("Contract"), $_SERVER["PHP_SELF"], "c.rowid", $param, "", "", $sortfield, $sortorder);
 print_liste_field_titre($langs->trans("Service"), $_SERVER["PHP_SELF"], "p.description", $param, "", "", $sortfield, $sortorder);
 print_liste_field_titre($langs->trans("Company"), $_SERVER["PHP_SELF"], "s.nom", $param, "", "", $sortfield, $sortorder);
 // Date debut
 if ($mode == "0") {
     print_liste_field_titre($langs->trans("DateStartPlannedShort"), $_SERVER["PHP_SELF"], "cd.date_ouverture_prevue", $param, '', ' align="center"', $sortfield, $sortorder);
 }
 if ($mode == "" || $mode > 0) {
     print_liste_field_titre($langs->trans("DateStartRealShort"), $_SERVER["PHP_SELF"], "cd.date_ouverture", $param, '', ' align="center"', $sortfield, $sortorder);
 }
 // Date fin

示例#7

0

显示文件

文件： listevents.php 项目： netors/dolibarr

if ($search_desc) {
    $usefilter++;
    $sql .= " AND e.description like '%" . $search_desc . "%'";
}
if ($search_ua) {
    $usefilter++;
    $sql .= " AND e.user_agent like '%" . $search_ua . "%'";
}
$sql .= $db->order($sortfield, $sortorder);
$sql .= $db->plimit($conf->liste_limit + 1, $offset);
//print $sql;
$result = $db->query($sql);
if ($result) {
    $num = $db->num_rows($result);
    $i = 0;
    print_barre_liste($langs->trans("ListOfSecurityEvents"), $page, $_SERVER["PHP_SELF"], "", $sortfield, $sortorder, '', $num, 0, 'setup');
    if ($_GET["action"] == 'purge') {
        $formquestion = array();
        $ret = $form->form_confirm($_SERVER["PHP_SELF"] . '?noparam=noparam', $langs->trans('PurgeAuditEvents'), $langs->trans('ConfirmPurgeAuditEvents'), 'confirm_purge', $formquestion, 'no', 1);
        if ($ret == 'html') {
            print '<br>';
        }
    }
    print '<table class="liste" width="100%">';
    print '<tr class="liste_titre">';
    print_liste_field_titre($langs->trans("Date"), $_SERVER["PHP_SELF"], "e.dateevent", "", "", 'align="left"', $sortfield, $sortorder);
    print_liste_field_titre($langs->trans("Code"), $_SERVER["PHP_SELF"], "e.type", "", "", 'align="left"', $sortfield, $sortorder);
    print_liste_field_titre($langs->trans("IP"), $_SERVER["PHP_SELF"], "e.ip", "", "", 'align="left"', $sortfield, $sortorder);
    print_liste_field_titre($langs->trans("User"), $_SERVER["PHP_SELF"], "u.login", "", "", 'align="left"', $sortfield, $sortorder);
    print_liste_field_titre($langs->trans("Description"), $_SERVER["PHP_SELF"], "e.description", "", "", 'align="left"', $sortfield, $sortorder);
    print_liste_field_titre('', '', '');

示例#8

0

显示文件

文件： agentMargins.php 项目： LionSystemsSolutions/El-Canelo-ERP

    $sql .= " AND d.buy_price_ht <> 0";
}
if ($agentid > 0) {
    $sql .= " GROUP BY s.rowid, s.nom, s.code_client, s.client, u.rowid, u.login, u.lastname, u.firstname";
} else {
    $sql .= " GROUP BY u.rowid, u.login, u.lastname, u.firstname";
}
$sql .= $db->order($sortfield, $sortorder);
// TODO: calculate total to display then restore pagination
//$sql.= $db->plimit($conf->liste_limit +1, $offset);
dol_syslog('margin::agentMargins.php sql=' . $sql, LOG_DEBUG);
$result = $db->query($sql);
if ($result) {
    $num = $db->num_rows($result);
    print '<br>';
    print_barre_liste($langs->trans("MarginDetails"), $page, $_SERVER["PHP_SELF"], "", $sortfield, $sortorder, '', 0, 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)) {

示例#9

0

显示文件

文件： index.php 项目： LionSystemsSolutions/El-Canelo-ERP

    print '<tr><td width="25%" valign="top">' . $langs->trans("Ref") . '</td>';
    print '<td colspan="2">';
    print $form->showrefnav($fuser, 'id', '', $user->rights->user->user->lire || $user->admin);
    print '</td>';
    print '</tr>';
    // LastName
    print '<tr><td width="25%" valign="top">' . $langs->trans("LastName") . '</td>';
    print '<td colspan="2">' . $fuser->lastname . '</td>';
    print "</tr>\n";
    // FirstName
    print '<tr><td width="25%" valign="top">' . $langs->trans("FirstName") . '</td>';
    print '<td colspan="2">' . $fuser->firstname . '</td>';
    print "</tr>\n";
    print '</table><br>';
} else {
    print_barre_liste($langs->trans("ListeCP"), $page, $_SERVER["PHP_SELF"], '', $sortfield, $sortorder, "", $num);
    dol_fiche_head('');
}
$nbaquis = $holiday->getCPforUser($user_id);
$nbdeduced = $holiday->getConfCP('nbHolidayDeducted');
$nb_holiday = $nbaquis / $nbdeduced;
print $langs->trans('SoldeCPUser', round($nb_holiday, 2)) . ($nbdeduced != 1 ? ' (' . $nbaquis . ' / ' . $nbdeduced . ')' : '');
if ($id > 0) {
    dol_fiche_end();
    print '</br>';
} else {
    dol_fiche_end();
}
print '<form method="get" action="' . $_SERVER["PHP_SELF"] . '">' . "\n";
print '<table class="noborder" width="100%;">';
print "<tr class=\"liste_titre\">";

示例#10

0

显示文件

文件： contrat_past.php 项目： abbenbouchta/immobilier

$limit = $conf->liste_limit;
$offset = $limit * $page;
$sql = "SELECT c.rowid as reference, loc.nom as nom, l.adresse as adresse , l.nom as local, loc.statut as statut, c.montant_tot as total, c.encours as encours , c.preavis as preavis";
$sql .= " FROM " . MAIN_DB_PREFIX . "immo_locataire as loc";
$sql .= " , " . MAIN_DB_PREFIX . "immo_contrat as c";
$sql .= " , " . MAIN_DB_PREFIX . "immo_local as l";
$sql .= " WHERE preavis = 1 AND loc.rowid = c.locataire_id and l.rowid = c.local_id  ";
if ($user->id != 1) {
    $sql .= " AND l.proprietaire_id=" . $user->id;
}
$sql .= " ORDER BY loc.nom ASC " . $db->plimit($limit + 1, $offset);
$result = $db->query($sql);
if ($result) {
    $num_lignes = $db->num_rows($result);
    $i = 0;
    print_barre_liste("contrat", $page, "contrat/contrat.php", "", $sortfield, $sortorder, '', $num_lignes);
    print '<a class="butAction" href="contrat/fiche_contrat.php?action=create">nouveau contrat</a>';
    print '<table class="noborder" width="100%">';
    print '<tr></tr>';
    print '<tr class="liste_titre">';
    print '<td>Nom</td>';
    print '<td>adresse</td>';
    print '<td>appartement</td>';
    print '<td>loyer total</td>';
    print '<td>encours loyer</td>';
    print '<td>&nbsp;</td>';
    print "</tr>\n";
    $var = True;
    while ($i < min($num_lignes, $limit)) {
        $objp = $db->fetch_object($result);
        $var = !$var;

示例#11

0

显示文件

文件： list.php 项目： ADDAdev/Dolibarr

 if ($socid) {
     $urlparam .= "&socid=" . $socid;
 }
 if ($search_ref) {
     $urlparam .= "&search_ref=" . urlencode($search_ref);
 }
 if ($search_company) {
     $urlparam .= "&search_company=" . urlencode($search_company);
 }
 if ($search_desc) {
     $urlparam .= "&search_desc=" . urlencode($search_desc);
 }
 if ($search_status != '' && $search_status > -1) {
     $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">';

示例#12

0

显示文件

文件： contrat.php 项目： remyyounes/dolibarr

		$sql.= " WHERE c.rowid = cd.fk_contrat";
		$sql.= " AND c.fk_soc = s.rowid";
		$sql.= " AND s.entity = ".$conf->entity;
		$sql.= " AND cd.fk_product =".$product->id;
		if (!$user->rights->societe->client->voir && !$socid) $sql.= " AND s.rowid = sc.fk_soc AND sc.fk_user = "******" AND s.rowid = ".$socid;
		$sql.= " GROUP BY c.rowid, c.date_contrat, c.statut, s.nom, s.rowid, s.code_client";
		$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("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";

示例#13

0

显示文件

文件： list.php 项目： Albertopf/prueba

 if ($search_ref) {
     $urlparam .= "&search_ref=" . urlencode($search_ref);
 }
 if ($search_company) {
     $urlparam .= "&search_company=" . urlencode($search_company);
 }
 if ($search_desc) {
     $urlparam .= "&search_desc=" . urlencode($search_desc);
 }
 if ($search_status != '' && $search_status > -1) {
     $urlparam .= "&search_status=" . urlencode($search_status);
 }
 if ($optioncss != '') {
     $urlparam .= '&optioncss=' . $optioncss;
 }
 print_barre_liste($langs->trans("ListOfInterventions"), $page, $_SERVER['PHP_SELF'], $urlparam, $sortfield, $sortorder, '', $num, $totalnboflines, 'title_commercial.png');
 print '<form method="POST" action="' . $_SERVER["PHP_SELF"] . '">' . "\n";
 if ($optioncss != '') {
     print '<input type="hidden" name="optioncss" value="' . $optioncss . '">';
 }
 print '<input type="hidden" name="token" value="' . $_SESSION['newtoken'] . '">';
 print '<input type="hidden" name="action" value="list">';
 print '<input type="hidden" name="sortfield" value="' . $sortfield . '">';
 print '<input type="hidden" name="sortorder" value="' . $sortorder . '">';
 if ($sall) {
     foreach ($fieldstosearchall as $key => $val) {
         $fieldstosearchall[$key] = $langs->trans($val);
     }
     print $langs->trans("FilterOnInto", $sall) . join(', ', $fieldstosearchall);
 }
 print '<table class="noborder" width="100%">';

示例#14

0

显示文件

文件： liste.php 项目： nrjacker4/crm-php

    $sql .= " AND sc.fk_user = "******" AND e.fk_soc = " . $socid;
}
if (GETPOST('sf_ref', 'alpha')) {
    $sql .= " AND e.ref like '%" . $db->escape(GETPOST('sf_ref', 'alpha')) . "%'";
}
$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>";

示例#15

0

显示文件

文件： list.php 项目： Samara94/dolibarr

 if ($search_refsupp) {
     $param .= "&search_refsupp=" . $search_refsupp;
 }
 if ($socid) {
     $param .= "&socid=" . $socid;
 }
 if ($search_status >= 0) {
     $param .= "&search_status=" . $search_status;
 }
 if ($billed != '') {
     $param .= "billed=" . $billed;
 }
 if ($optioncss != '') {
     $param .= '&optioncss=' . $optioncss;
 }
 print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, $nbtotalofrecords);
 print '<form action="' . $_SERVER["PHP_SELF"] . '" method="POST">';
 if ($optioncss != '') {
     print '<input type="hidden" name="optioncss" value="' . $optioncss . '">';
 }
 print '<input type="hidden" name="token" value="' . $_SESSION['newtoken'] . '">';
 print '<input type="hidden" name="action" value="list">';
 print '<input type="hidden" name="sortfield" value="' . $sortfield . '">';
 print '<input type="hidden" name="sortorder" value="' . $sortorder . '">';
 print '<input type="hidden" name="viewstatut" value="' . $viewstatut . '">';
 if ($sall) {
     foreach ($fieldstosearchall as $key => $val) {
         $fieldstosearchall[$key] = $langs->trans($val);
     }
     print $langs->trans("FilterOnInto", $sall) . join(', ', $fieldstosearchall);
 }

示例#16

0

显示文件

文件： avalider.php 项目： remyyounes/dolibarr

if ($socid)
{
    $sql.= " AND f.fk_soc = ".$socid;
}
$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, "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]>";

示例#17

0

显示文件

文件： paiement.php 项目： netors/dolibarr

 }
 $sql = 'SELECT p.datep as dp, p.amount, f.amount as fa_amount, f.facnumber';
 $sql .= ', f.rowid as facid, c.libelle as paiement_type, p.num_paiement';
 $sql .= ' FROM ' . MAIN_DB_PREFIX . 'paiement as p, ' . MAIN_DB_PREFIX . 'facture as f, ' . MAIN_DB_PREFIX . 'c_paiement as c';
 $sql .= ' WHERE p.fk_facture = f.rowid AND p.fk_paiement = c.id';
 if ($socid) {
     $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";

示例#18

0

显示文件

文件： liste.php 项目： remyyounes/dolibarr

{
    $sql .= " AND s.nom LIKE '%".$search_societe."%'";
}
$sql.=$db->order($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;
    $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>';

示例#19

0

显示文件

文件： valo.php 项目： ADDAdev/Dolibarr

    $sql .= " AND (e.label LIKE '%" . $db->escape($sall) . "%'";
    $sql .= " OR e.description LIKE '%" . $db->escape($sall) . "%'";
    $sql .= " OR e.lieu LIKE '%" . $db->escape($sall) . "%'";
    $sql .= " OR e.address LIKE '%" . $db->escape($sall) . "%'";
    $sql .= " OR e.town LIKE '%" . $db->escape($sall) . "%')";
}
$sql .= " GROUP BY e.rowid, e.label, e.statut, e.lieu, e.address, e.zip, e.town, e.fk_pays";
$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] . ">";

示例#20

0

显示文件

文件： propal.php 项目： remyyounes/dolibarr

	{
		$sql.= " AND s.nom LIKE '%".$db->escape($_GET['search_societe'])."%'";
	}
	if (!empty($_GET['search_montant_ht']))
	{
		$sql.= " AND p.price='".$db->escape($_GET['search_montant_ht'])."'";
	}
	$sql.= " ORDER BY $sortfield $sortorder, p.rowid DESC ";
	$sql.= $db->plimit($limit + 1,$offset);

	$result = $db->query($sql);
	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

示例#21

0

显示文件

文件： price.php 项目： LionSystemsSolutions/El-Canelo-ERP

     print "\n" . '<div class="tabsAction">' . "\n";
     print '<div class="inline-block divButAction"><a class="butAction" href="' . $_SERVER["PHP_SELF"] . '?socid=' . $soc->id . '">' . $langs->trans("Ok") . '</a></div>';
     print "\n</div><br>\n";
 } else {
     // View mode
     // Count total nb of records
     $nbtotalofrecords = 0;
     if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
         $nbtotalofrecords = $prodcustprice->fetch_all('', '', 0, 0, $filter);
     }
     $result = $prodcustprice->fetch_all($sortorder, $sortfield, $conf->liste_limit, $offset, $filter);
     if ($result < 0) {
         setEventMessage($prodcustprice->error, 'errors');
     }
     $option = '&search_soc=' . $search_soc . '&id=' . $object->id;
     print_barre_liste($langs->trans('PriceByCustomer'), $page, $_SERVEUR['PHP_SELF'], $option, $sortfield, $sortorder, '', count($prodcustprice->lines), $nbtotalofrecords);
     if (count($prodcustprice->lines) > 0) {
         print '<form action="' . $_SERVER["PHP_SELF"] . '?id=' . $object->id . '" method="POST">';
         print '<input type="hidden" name="id" value="' . $object->id . '">';
         print '<table class="noborder" width="100%">';
         print '<tr class="liste_titre">';
         print '<td>' . $langs->trans("Product") . '</td>';
         print '<td>' . $langs->trans("AppliedPricesFrom") . '</td>';
         print '<td align="center">' . $langs->trans("PriceBase") . '</td>';
         print '<td align="right">' . $langs->trans("VAT") . '</td>';
         print '<td align="right">' . $langs->trans("HT") . '</td>';
         print '<td align="right">' . $langs->trans("TTC") . '</td>';
         print '<td align="right">' . $langs->trans("MinPrice") . ' ' . $langs->trans("HT") . '</td>';
         print '<td align="right">' . $langs->trans("MinPrice") . ' ' . $langs->trans("TTC") . '</td>';
         print '<td align="right">' . $langs->trans("ChangedBy") . '</td>';
         print '<td>&nbsp;</td>';

示例#22

0

显示文件

文件： index.php 项目： nrjacker4/crm-php

$form=new Form($db);
$projectstatic = new Project($db);
$taskstatic = new Task($db);

$title=$langs->trans("Activities");
if ($mine) $title=$langs->trans("MyActivities");

llxHeader("",$title,"Projet");

if ($id)
{
	$projectstatic->fetch($id);
	$projectstatic->societe->fetch($projectstatic->societe->id);
}

print_barre_liste($title, $page, $_SERVER["PHP_SELF"], "", $sortfield, $sortorder, "", $num);

// Show description of content
if ($mine) print $langs->trans("MyProjectsDesc").'<br><br>';
else
{
	if ($user->rights->projet->all->lire && ! $socid) print $langs->trans("ProjectsDesc").'<br><br>';
	else print $langs->trans("ProjectsPublicDesc").'<br><br>';
}

// Get list of project id allowed to user
$projectsListId = $projectstatic->getProjectsAuthorizedForUser($user,$mine,1,$socid);

// Get list of tasks in tasksarray and taskarrayfiltered
// We need all tasks (even not limited to a user because a task to user can have a parent that is not affected to him).
$tasksarray=$taskstatic->getTasksArray(0, 0, $projectstatic->id, $socid, 0, $search_product);

示例#23

0

显示文件

文件： impayees.php 项目： remyyounes/dolibarr

	$sql.= " f.facnumber DESC";

	$result = $db->query($sql);

	if ($result)
	{
		$num = $db->num_rows($result);

		if ($socid)
		{
			$soc = new Societe($db);
			$soc->fetch($socid);
		}

		$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";

示例#24

0

显示文件

文件： valo.php 项目： nrjacker4/crm-php

}
$sql.= " GROUP BY e.rowid, e.label, e.statut, e.lieu";
$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, "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;

示例#25

0

显示文件

文件： index.php 项目： LionSystemsSolutions/El-Canelo-ERP

$resql = $db->query($sql);
if ($resql) {
    $num = $db->num_rows($resql);
    $i = 0;
    $var = true;
    $param = '';
    if ($year) {
        $param .= '&amp;year=' . $year;
    }
    if ($typeid) {
        $param .= '&amp;typeid=' . $typeid;
    }
    if ($year) {
        print_fiche_titre($langs->trans("SocialContributions"), $year ? "<a href='index.php?year=" . ($year - 1) . "'>" . img_previous() . "</a> " . $langs->trans("Year") . " {$year} <a href='index.php?year=" . ($year + 1) . "'>" . img_next() . "</a>" : "");
    } else {
        print_barre_liste($langs->trans("SocialContributions"), $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, $totalnboflines);
    }
    dol_htmloutput_mesg($mesg);
    if (empty($mysoc->country_id) && empty($mysoc->country_code)) {
        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);

示例#26

0

显示文件

文件： list.php 项目： TAASA/Dolibarr-ERP-3.8.1

        }
    }
} else {
    if ($year > 0) {
        $sql .= " AND bc.date_bordereau BETWEEN '" . $db->idate(dol_get_first_day($year, 1, false)) . "' AND '" . $db->idate(dol_get_last_day($year, 12, false)) . "'";
    }
}
$sql .= " ORDER BY {$sortfield} {$sortorder}";
$sql .= $db->plimit($limit + 1, $offset);
//print "$sql";
$resql = $db->query($sql);
if ($resql) {
    $num = $db->num_rows($resql);
    $i = 0;
    $params = '';
    print_barre_liste($langs->trans("MenuChequeDeposits"), $page, $_SERVER["PHP_SELF"], $params, $sortfield, $sortorder, '', $num);
    print '<form method="GET" action="' . $_SERVER["PHP_SELF"] . '">';
    print '<table class="liste" width="100%">';
    print '<tr class="liste_titre">';
    print_liste_field_titre($langs->trans("Ref"), $_SERVER["PHP_SELF"], "bc.number", "", $params, "", $sortfield, $sortorder);
    print_liste_field_titre($langs->trans("DateCreation"), $_SERVER["PHP_SELF"], "dp", "", $params, 'align="center"', $sortfield, $sortorder);
    print_liste_field_titre($langs->trans("Account"), $_SERVER["PHP_SELF"], "ba.label", "", $params, "", $sortfield, $sortorder);
    print_liste_field_titre($langs->trans("NbOfCheques"), $_SERVER["PHP_SELF"], "bc.nbcheque", "", $params, 'align="right"', $sortfield, $sortorder);
    print_liste_field_titre($langs->trans("Amount"), $_SERVER["PHP_SELF"], "bc.amount", "", $params, 'align="right"', $sortfield, $sortorder);
    print_liste_field_titre($langs->trans("Status"), $_SERVER["PHP_SELF"], "bc.statut", "", $params, 'align="right"', $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" size="4" name="search_ref" value="' . $search_ref . '">';
    print '</td>';

示例#27

0

显示文件

文件： mouvement.intentohector.php 项目： LionSystemsSolutions/El-Canelo-ERP

 if ($sref) {
     $param .= '&sref=' . urlencode($sref);
 }
 if ($snom) {
     $param .= '&snom=' . urlencode($snom);
 }
 if ($search_user) {
     $param .= '&search_user='******'&idproduct=' . $idproduct;
 }
 if ($id) {
     print_barre_liste($texte, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, 0, '');
 } else {
     print_barre_liste($texte, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num);
 }
 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

示例#28

0

显示文件

文件： list.php 项目： TAASA/Dolibarr-ERP-3.8.1

if ($search_amount) {
    $sql .= " AND d.amount='" . $db->escape(price2num(trim($search_amount))) . "'";
}
$sql .= $db->order($sortfield, $sortorder);
$sql .= $db->plimit($limit + 1, $offset);
$resql = $db->query($sql);
if ($resql) {
    $num = $db->num_rows($resql);
    $i = 0;
    $param = "&statut={$statut}&sortorder={$sortorder}&sortfield={$sortfield}";
    if ($statut >= 0) {
        $donationstatic->statut = $statut;
        $label = $donationstatic->getLibStatut(0);
        print_barre_liste($label, $page, $_SERVER["PHP_SELF"], $param, '', '', '', $num);
    } 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";

示例#29

0

显示文件

文件： osc-liste.php 项目： nrjacker4/crm-php

/*
 * View
 */
llxHeader();
if ($sortfield == "") {
    $sortfield = "p.label,p.price";
}
if ($sortorder == "") {
    $sortorder = "ASC";
}
if ($page == -1) {
    $page = 0;
}
$limit = $conf->liste_limit;
$offset = $limit * $page;
print_barre_liste("Liste des produits oscommerce", $page, "osc-liste.php");
$sql = "SELECT p.products_id, p.products_model, p.products_quantity, p.products_status, d.products_name, m.manufacturers_name, m.manufacturers_id";
$sql .= " FROM " . $conf->global->OSC_DB_NAME . "." . $conf->global->OSC_DB_TABLE_PREFIX . "products as p, " . $conf->global->OSC_DB_NAME . "." . $conf->global->OSC_DB_TABLE_PREFIX . "products_description as d, " . $conf->global->OSC_DB_NAME . "." . $conf->global->OSC_DB_TABLE_PREFIX . "manufacturers as m";
$sql .= " WHERE p.products_id = d.products_id AND d.language_id =" . $conf->global->OSC_LANGUAGE_ID;
$sql .= " AND p.manufacturers_id=m.manufacturers_id";
if ($reqstock == 'epuise') {
    $sql .= " AND p.products_quantity <= 0";
}
//$sql .= " ORDER BY $sortfield $sortorder ";
$sql .= $dbosc->plimit($limit, $offset);
print "<p><TABLE border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"4\">";
print '<tr class="liste_titre">';
print "<td>id</td>";
print "<td>Ref</td>";
print "<td>Titre</td>";
print "<td>Groupe</td>";

示例#30

0

显示文件

文件： avalider.php 项目： ADDAdev/Dolibarr

    $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "facture as f ON pf.fk_facture = f.rowid";
}
$sql .= " WHERE p.fk_paiement = c.id";
$sql .= " AND p.entity = " . $conf->entity;
if ($socid) {
    $sql .= " AND f.fk_soc = " . $socid;
}
$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";

PHP print_barre_liste示例