ajax_boxcard_search.php

Go to the documentation of this file.

<?php
 
/*
 *   This file is part of NOALYSS.
 *
 *   NOALYSS is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 *   NOALYSS is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU General Public License for more details.
 *
 *   You should have received a copy of the GNU General Public License
 *   along with NOALYSS; if not, write to the Free Software
 *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */
 
// Copyright Author Dany De Bontridder danydb@aevalys.eu
 
/**
 * @file
 * @brief show result card search
 *
 */
if ( ! defined ('ALLOWED') ) die('Appel direct ne sont pas permis');
$sql="
        select distinct vw.f_id,vw_name,vw_first_name,vw_description,fd_label,quick_code,tva_num,(select ad_value from fiche_Detail where f_id=pc.f_id and ad_id=5) as poste
        from vw_fiche_attr as vw
        join fiche_def as fd on (vw.fd_id=fd.fd_id)
        left join fiche_detail as pc on (pc.f_id=vw.f_id)
        where
        ad_value ~* $1
        order by 2
";
$array=$cn->get_array($sql,array($_GET['card']));
echo HtmlInput::title_box(_("Résultat recherche"), "boxsearch_card_div");
$max=(count($array)>MAX_CARD_SEARCH)?MAX_CARD_SEARCH:count($array);
?>
<?php if (count($array)>MAX_CARD_SEARCH ): ?>
<h2 class="notice"><?php printf (_("Résultat limité à %d , %d nombre de fiches trouvées"), MAX_CARD_SEARCH,count($array))?> </h2>
 
<?php endif?>
<?php echo _('Cherche')?> <?php echo Icon_Action::infobulle(26);echo HtmlInput::filter_table("tb_fiche", "0,1,2,3,4,5", 1); ?> :
<table id="tb_fiche" class="sorttable" style="width:100%">
        <tr>
                <th>
                        <?php echo _("Quick Code");?> <?php echo Icon_Action::infobulle(17); ?>
                </th>
                <th class=" sorttable_sorted">
                        Nom
                </th>
                <th>
                        <?php echo _("Categorie");?>
                </th>
                <th>
                        <?php echo _("Description");?>
                </th>
                <th>
                        <?php echo _("Numéro TVA");?>
                </th>
                <th>
                        <?php echo _("Poste comptable");?>
                </th>
 
        </tr>
<?php if (count($array)==0) : ?>
        <h2 class="notice"> <?php echo _("Aucun résultat");?></h2>
<?php endif?>
<?php for ($i=0;$i<$max;$i++):?>
        <tr class="<?php echo ($i%2 == 0)?'even':'odd';?>">
 
                <td>
                        <?php echo HtmlInput::card_detail($array[$i]['quick_code'])?>
                </td>
                <td>
                        <?php echo h($array[$i]['vw_name'])?>&nbsp;
                        <?php echo h($array[$i]['vw_first_name'])?>
                </td>
                <td>
                        <?php echo h($array[$i]['fd_label'])?>
                </td>
                <td>
                        <?php echo h($array[$i]['vw_description'])?>
 
                </td>
                <td>
                        <?php echo h($array[$i]['tva_num'])?>
 
                </td>
                <td style="text-align:right">
                        <?php echo HtmlInput::history_account($array[$i]['poste'],$array[$i]['poste'])?>
 
                </td>
        </tr>
 
 
<?php endfor; ?>
</table>
<?php echo HtmlInput::button_close("boxsearch_card_div")?>