fid_card.php File Reference

this file is used by the autocomplete functionnality More...

Go to the source code of this file.

Variables
	$cn =Dossier::connect()
	$fid =$http->request("FID")
	$filter_card =""
global	$g_user =new Noalyss_user($cn)
if(! isset($_SESSION[SESSION_KEY."g_user"]))	$http =new HttpInput()
	if not connected, session is expired then exit with a message NOCONX
	$jrn = $http->request("j","number",-1)
	$limit =$http->request("limit","number",12)
	$sql =$cn->get_array($sql_str ,array($fid))
	$sql_str
	$typecard =$http->request('e')
if($typecard=='all') else if(strpos($typecard, 'sql]')==true)	else

Detailed Description

this file is used by the autocomplete functionnality

See also

ICard

• Received parameters are
  • j for the ledger
  • e for extra (typecard)poss. values : all , a sql condition or a list of fd_id (fiche_def.fd_id) separated by comma
  • type is the ledger type (ach, ven, fin, gl or nothing)
  • FID contains the string the user is typing

Note

the typecard can be

• cred card for the debit only if j is set
• deb card for the debit only if j is set
• filter card for debit and credit only if j OR type is set
• list of fd_id

Definition in file fid_card.php.

Variable Documentation

$cn

$cn =Dossier::connect()

Definition at line 61 of file fid_card.php.

$fid

$fid =$http->request("FID")

Definition at line 146 of file fid_card.php.

$filter_card

$filter_card =""

Definition at line 60 of file fid_card.php.

$g_user

$g_user =new Noalyss_user($cn)

Definition at line 66 of file fid_card.php.

$http

if (! isset( $_SESSION[SESSION_KEY."g_user"])) $http =new HttpInput()

if not connected, session is expired then exit with a message NOCONX

Definition at line 54 of file fid_card.php.

$jrn

$jrn = $http->request("j","number",-1)

Definition at line 56 of file fid_card.php.

$limit

$limit =$http->request("limit","number",12)

Definition at line 57 of file fid_card.php.

$sql

$sql =$cn->get_array($sql_str ,array($fid))

Definition at line 149 of file fid_card.php.

$sql_str

$sql_str

Initial value:

="select distinct f_id 
         from fiche 
         join fiche_detail using (f_id) 
         where 
         ad_id in (9,1,23) 
         and ad_value ilike '%'||$1||'%' ".$filter_enable_card.$filter_card.' limit '.$limit

Definition at line 138 of file fid_card.php.

$typecard

$typecard =$http->request('e')

Definition at line 62 of file fid_card.php.

Referenced by Fiche\build_sql().

else

if ( $sql !=false &&sizeof( $sql) !=0 else)

Initial value:

{
    $typecard=(empty($typecard))?-1:sql_string($typecard)

Definition at line 79 of file fid_card.php.