[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r5621 - phpcompta/trunk/include
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r5621 - phpcompta/trunk/include |
Date: |
Fri, 27 Dec 2013 00:29:10 +0100 (CET) |
Author: danydb
Date: 2013-12-27 00:29:09 +0100 (Fri, 27 Dec 2013)
New Revision: 5621
Modified:
phpcompta/trunk/include/class_fiche.php
Log:
Recherche par Nom, pr?\195?\169nom, quickcode, num?\195?\169ro TVA et
num?\195?\169ro client
Task #954 - CUST, SUPPLIER... Recherche par quick code ne fonctionne pas
Modified: phpcompta/trunk/include/class_fiche.php
===================================================================
--- phpcompta/trunk/include/class_fiche.php 2013-12-26 23:13:56 UTC (rev
5620)
+++ phpcompta/trunk/include/class_fiche.php 2013-12-26 23:29:09 UTC (rev
5621)
@@ -310,7 +310,6 @@
}
$Ret=$this->cn->exec_sql($sql);
-
if ( ($Max=Database::num_row($Ret)) == 0 )
return ;
$all[0]=new Fiche($this->cn);
@@ -1536,7 +1535,7 @@
if ( $p_amount) $filter_amount=' and f_id in (select f_id from jrnx
where '.$filter_year.')';
-
$all_tiers=$this->count_by_modele($this->fiche_def_ref,$p_search,$p_sql.$filter_amount);
+
$all_tiers=$this->count_by_modele($this->fiche_def_ref,"",$p_sql.$filter_amount);
// Get offset and page variable
$offset=( isset ($_REQUEST['offset'] )) ?$_REQUEST['offset']:0;
$page=(isset($_REQUEST['page']))?$_REQUEST['page']:1;
@@ -1553,9 +1552,9 @@
if ( trim($p_search) != "" )
{
$search.=" and f_id in
- (select f_id from fiche_detail
+ (select distinct f_id from fiche_detail
where
- ad_id=1 and ad_value ~* '$p_search')";
+ ad_id in (1,32,30,23,18,13) and ad_value ~* '$p_search')";
}
// Get The result Array
$step_tiers=$this->GetAll($offset,$search.$filter_amount,'name');
---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r5621 - phpcompta/trunk/include,
phpcompta-dev <=