ac_common.php File Reference

common utilities for a lot of procedure, classe More...

Go to the source code of this file.

Functions
	add_http_link ($text)
	ajax_disconnected ($p_div)
	Should a dialog box when you are disconnected from an ajax call propose to reload or to connect in another tab. More...
	ajax_xml_error ($p_code, $p_string)
	alert ($p_msg, $buffer=false)
	alert in javascript More...
	check_password_strength ($password)
	returns an double array with the error found and code , if the count is 0 then the password is very string, 5 means it is empty ,4 weak, ... the array contains the errors, [msg]=>array message [code] => array of code Codes are More...
	cmpDate ($p_date, $p_date_oth)
	Compare 2 dates. More...
	complete_default_menu ($pa_menu)
	Check if there is a default menu for this user and add it. More...
	compute_variable ($p_string)
	the string has the format a=b&c=d, it is parsed and an array[][key,value] is returned More...
	confirm_with_string ($p_ctl_name, $p_car)
	generate a string of p_car character and a input text with name p_ctl_name work like a kind of captcha.The control code for checking is ctlcode. More...
if(!function_exists( 'tracedebug'))	convert_to_rtf ($p_string)
	encode the string for RTF, return a string More...
	Decode ($p_html)
	Decode the html for the widegt richtext and remove newline. More...
	display_menu ($p_menuid)
	Display a menu @global type $g_user. More...
	echo_error ($p_log, $p_line="", $p_message="")
	log error into the /tmp/noalyss_error.log it doesn't work on windows More...
	echo_warning ($p_string)
	warns More...
	factory_Ledger (Database &$p_cn, $ledger_id)
	This function create a ledger object and return the right one. More...
	FaxTo ($p_tel)
	compose a HTML string with fax More...
	find_default_menu ($pn_menu)
	Find the menu marked as default in the given profile. More...
	find_default_module ()
	findSide ($p_number)
	return D if the number is smaller than 0 , C if bigger and an empty string if equal to 0. More...
	format_date ($p_date, $p_from_format='YYYY-MM-DD', $p_to_format='DD.MM.YYYY')
	format the date, when taken from the database the format is MM-DD-YYYY More...
	FormatString ($p_string)
	replaced by sql_string More...
	generate_random_password ($car)
	generate a strong random password More...
	generate_random_string ($p_length, $special=1)
	Create randomly a string. More...
	get_array_column ($p_array, $key)
	getPeriodeFromMonth ($p_cn, $p_date)
	Return the period corresponding to the date. More...
	getPeriodeName ($p_cn, $p_id, $pos='p_start')
	Show the periode which found thanks its id. More...
	h ($p_string)
	to protect again bad characters which can lead to a cross scripting attack the string to be diplayed must be protected. More...
	h1 ($p_string, $p_class="")
	h2 ($p_string, $p_class="", $raw="")
	h2info ($p_string)
	hb ($p_string)
	header_csv ($p_filename)
	Send an header CSV with a filename. More...
	hi ($p_string)
	html_min_page_start ($p_theme="", $p_script="", $p_script2="")
	Minimal page header for each page, used for small popup window. More...
	html_page_start ($p_theme="", $p_script="", $p_script2="")
	Default page header for each page. More...
	html_page_stop ()
	end tag More...
	is_msie ()
	Check if we use IE 8 or 9. More...
	isDate ($p_date)
	isNumber ($p_int)
	j ($p_string)
	escape correctly php string to javascript More...
	linkTo ($p_url)
	mailTo ($p_email)
	compose a HTML string with email More...
	MaintenanceMode ($p_file)
	When you want to prevent users to connect, create a file in noalyss/ (NOALYSS_BASE) with the message in Html. More...
	nb ($p_number)
	format the number for the CSV export More...
	nbm ($p_number, $p_dec=2)
	format the number with a sep. More...
	NoAccess ($js=1)
	Echo no access and stop. More...
	noalyss_bcadd ($p_first, $p_second, $p_decimal=4)
	noalyss_bcmul ($p_first, $p_second)
	noalyss_bcsub ($p_first, $p_second, $p_decimal=4)
	noalyss_explode ($separator, $string)
	to avoid deprecated in PHP8.1 : explode cannot use a null More...
	noalyss_round ($p_first, $p_second)
	noalyss_str_replace ($search, $replace, $string)
	noalyss_strip_tags ($p_string)
	noalyss_strlen ($p_string)
	noalyss_strlentrim ($p_string)
	noalyss_trim ($p_string)
	p ($p_string)
	phoneTo ($p_tel)
	compose a HTML string with phone More...
	put_global ($array)
	Put in superglobal (get,post,request) the value contained in the parameter field (me_parameter) More...
	rebuild_access_code ($pan_code)
	rebuild the access code More...
	record_log ($p_message)
	Record an error message into the log file of the server. More...
	remove_divide_zero ($p_formula)
	When it is needed to eval a formula , this function prevent the divide by zero. More...
	sanitize_filename ($filename)
	removed invalid character when computing a filename, the suffix is kept More...
	set_language ()
	set the lang thanks the _SESSION['g_lang'] var. More...
	show_menu ($module)
	show_module ($selected)
	Show the modules. More...
	ShowItem ($p_array, $p_dir='V', $class="nav-item", $class_ref="nav-link", $default="", $p_extra="nav nav-pills nav-fill")
	store the string which print the content of p_array in a table used to display the menu More...
	shrink_date ($p_date)
	shrink the date, make a date shorter for the printing More...
	smaller_date ($p_date)
	shrink the date, make a date shorter for the printing More...
	span ($p_string, $p_extra='')
	sql_filter_per ($p_cn, $p_from, $p_to, $p_form='p_id', $p_field='jr_tech_per')
	Create the condition to filter on the j_tech_per thanks a from and to date. More...
	sql_string ($p_string)
	Fix the problem with the quote char for the database. More...
	td ($p_string='', $p_extra='')
	surround the string with td More...
	th ($p_string, $p_extra='', $raw='')
	tr ($p_string, $p_extra='')
	transform_sql_filter_per ($p_sql)
	transform the SQL for ANALYTIC table operation_analytique More...
	what_os ()
	try to determine on what os you are running the pĥpcompte server More...

Detailed Description

common utilities for a lot of procedure, classe

Definition in file ac_common.php.

Function Documentation

add_http_link()

add_http_link

(

$text

)

Definition at line 1527 of file ac_common.php.

{
    
    $ret=preg_replace("!http[s]{0,1}://[[:graph:]*]*!",'<a href="\\0" target="_blank">\0</a>',$text);
    
    return $ret;
 
}

References $ret, and $text.

ajax_disconnected()

ajax_disconnected

(

$p_div

)

Should a dialog box when you are disconnected from an ajax call propose to reload or to connect in another tab.

Definition at line 907 of file ac_common.php.

{
 
    echo HtmlInput::title_box(_("Déconnecté"), $p_div);
    echo h2(_('Données non disponibles'), 'class="error" ');
    echo h2(_('Veuillez vous reconnecter soit dans une autre fenêtre soit '
            . ' en cliquant sur le bouton'), 'class="error"');
    // Reload button
    $reload=new IButton("reload");
    $reload->value=_("Se connecter");
    $reload->class="button";
    $reload->javascript='window.location.reload()';
    // Link to log in another tab
    echo '<p style="text-align:center">';
    echo $reload->input();
    echo HtmlInput::button_close($p_div,'button');
    echo '</p>';
 
 
}

ajax_xml_error()

ajax_xml_error	(		$p_code,
			$p_string
	)

Definition at line 1265 of file ac_common.php.

{
    $html = escape_xml($p_string);
    header('Content-type: text/xml; charset=UTF-8');
                echo <<<EOF
<?xml version="1.0" encoding="UTF-8"?>
<data>
<code>$p_code</code>
<value>$html</value>
</data>
EOF;
}

References $html, escape_xml(), and value.

Here is the call graph for this function:

alert()

alert	(		$p_msg,
			$buffer = false
	)

alert in javascript

Parameters

$p_msg	is the message
$buffer	if false, echo directly and execute the javascript, if $buffer is true, the alert javascript is in the return string

Returns

string with alert javascript if $buffer is true

Definition at line 738 of file ac_common.php.

{
    $r = '<script>';
    $r.= 'alert_box(\'' . j($p_msg) . '\')';
    $r.= '</script>';
 
    if ($buffer)
    {
        return $r;
    }
    echo $r;
}

References $p_msg, $r, and j().

Referenced by Fiche_Def\Add(), Extension\check_version(), Anc_Acc_List\display_html(), Anc_Group\display_html(), Anc_Table\display_html(), Acc_Ledger_Fin\input(), Todo_List\insert(), Extension\insert_plugin(), js_include(), Fiche\remove(), Extension\remove_plugin(), Acc_Parm_Code\save(), Document_Type\set_number(), Acc_Ledger\test_me(), ICard\test_me(), Extension\update_plugin(), Acc_Report\upload(), and Menu_Ref\verify().

Here is the call graph for this function:

check_password_strength()

check_password_strength

(

$password

)

returns an double array with the error found and code , if the count is 0 then the password is very string, 5 means it is empty ,4 weak, ... the array contains the errors, [msg]=>array message [code] => array of code Codes are

• 1 : too short
• 2 : missing digit
• 3 : missing lowercase letter
• 4 : missing uppercase letter
• 5 : too many time same letter or symbol..
• 6 : missing special char

If the password is strong returns an empty array

Parameters

$password

string $error = check_password_strength($password); if ( count($error['msg']) > 0 ) { echo "password to weak"; foreach ($error['msg'] as $item_error) { echo "error $item_error"; } } else { echo "OK password strong"; }

Definition at line 1700 of file ac_common.php.

                                            {
    $errors=array();
    $error_code=array();
 
    $len=strlen($password??"");
    if ( $len < 8) {
        $errors[] = _("mot de passe de 8 lettres minimum");
        $error_code[]=1;
    }
 
    if (!preg_match("#[0-9]+#", $password)) {
        $errors[] = _("mot de passe doit inclure au moins un chiffre");
        $error_code[]=2;
    }
 
    if (!preg_match("#[a-z]+#", $password)) {
        $errors[] = _("mot de passe doit inclure au moins une minuscule");
        $error_code[]=3;
    }
    if (!preg_match("#[A-Z]+#", $password)) {
        $errors[] = _("mot de passe doit inclure au moins une majuscule");
        $error_code[]=4;
    }
 
    if ( $len > 0 ) {
        $cnt_diff=count(count_chars($password,1));
        $ratio_diff=$len/$cnt_diff;
 
        if ($ratio_diff > 2) {
            $errors[] = _("Trop souvent le(s) même(s) symbole(s)");
            $error_code[]=5;
        }
        $special_char=preg_replace('/[[:alnum:]]/','',$password);
        if ( strlen($special_char??"")==0)
        {
            $errors[] = _("mot de passe doit inclure au moins un caractére spécial '+-/*[...'");
            $error_code[]=6;
 
        }
    }
 
    return  array( 'msg'=>$errors, 'code'=>$error_code);
}

Referenced by generate_random_password().

cmpDate()

cmpDate	(		$p_date,
			$p_date_oth
	)

Compare 2 dates.

Parameters

p_date
p_date_oth

Returns

• == 0 les dates sont identiques
• > 0 date1 > date2
• < 0 date1 < date2

Definition at line 188 of file ac_common.php.

{
    date_default_timezone_set('Europe/Brussels');
 
    $l_date = isDate($p_date);
    $l2_date = isDate($p_date_oth);
    if ($l_date == null || $l2_date == null)
    {
        throw new Exception("erreur date [$p_date] [$p_date_oth]");
    }
    $l_adate = explode(".", $l_date);
    $l2_adate = explode(".", $l2_date);
    $l_mkdate = mktime(0, 0, 0, $l_adate[1], $l_adate[0], $l_adate[2]);
    $l2_mkdate = mktime(0, 0, 0, $l2_adate[1], $l2_adate[0], $l2_adate[2]);
    // si $p_date > $p_date_oth return > 0
    return $l_mkdate - $l2_mkdate;
}

References $p_date, and isDate().

Referenced by Fiche\HtmlTable(), Acc_Ledger_Fin\verify_operation(), Acc_Ledger_Purchase\verify_operation(), and Acc_Ledger_Sale\verify_operation().

Here is the call graph for this function:

complete_default_menu()

complete_default_menu

(

$pa_menu

)

Check if there is a default menu for this user and add it.

The array is filling from 1 to 3

* 
* COMPTA              0   -   0 - 173
* COMPTA/MENUACH      0   - 173 -   3
* COMPTA/MENUACH/ACH  173 -   3 -  85
* 
* 

Parameters

array

$pa_menu

if the array of option ; index pm_id_v1 , pm_id_v2 and pm_id_v3

Definition at line 1482 of file ac_common.php.

{
    $a_result=$pa_menu;
    // find the first one which is null
    if ($pa_menu[0]['pm_id_v2'] == 0) {
        $tmp=find_default_menu($pa_menu[0]['pm_id_v1']);
        if ( $tmp <> 0 ) {
            $a_result[0]['pm_id_v2']=$pa_menu[0]['pm_id_v1'];
            $a_result[0]['pm_id_v1']=$tmp;
        }
    }
    if ($pa_menu[0]['pm_id_v3'] == 0) {
         $tmp=find_default_menu($a_result[0]['pm_id_v1']);
        if ( $tmp <> 0 ) {
            $a_result[0]['pm_id_v3']=$a_result[0]['pm_id_v2'];
            $a_result[0]['pm_id_v2']=$a_result[0]['pm_id_v1'];
            $a_result[0]['pm_id_v1']=$tmp;
        }
    }
    return $a_result;
}

References $tmp, and find_default_menu().

Here is the call graph for this function:

compute_variable()

compute_variable

(

$p_string

)

the string has the format a=b&c=d, it is parsed and an array[][key,value] is returned

Parameters

$p_string

Returns

$array usable in put_global

Definition at line 1250 of file ac_common.php.

{
    $array=array();
    if ($p_string == '') return $array;
 
    $var=explode("&",$p_string);
    if (empty ($var))   return $array;
    for ($i=0;$i < count($var);$i++)
    {
        $var2=explode('=',$var[$i]);
        $array[$i]['key']=$var2[0];
        $array[$i]['value']=$var2[1];
    }
    return $array;
}

References $array, $i, and $var.

Referenced by Noalyss\Mobile\execute_menu().

confirm_with_string()

confirm_with_string	(		$p_ctl_name,
			$p_car
	)

generate a string of p_car character and a input text with name p_ctl_name work like a kind of captcha.The control code for checking is ctlcode.

You compare the content of the variable p_ctl_name with ctlcode

Parameters

$p_ctl_name	name of the HTML input text
$p_car	length of the string

Definition at line 1444 of file ac_common.php.

{
    $code=generate_random_string($p_car );
    $r =  HtmlInput::hidden("ctlcode",$code);
    $r.='<span style="margin-left:1.2em;margin-right:1.2em;font-size:112%;font-weight:bold;border:navy solid 1px ; padding:0.5rem">'. $code.'</span>';
    $ctl=new IText($p_ctl_name);
    $r.=$ctl->input();
    return $r;
}

References $code, $ctl, $r, generate_random_string(), and HtmlInput\hidden().

Here is the call graph for this function:

convert_to_rtf()

if(!function_exists('tracedebug')) convert_to_rtf

(

$p_string

)

encode the string for RTF, return a string

Parameters

$p_string

string to convert

Returns

string

Definition at line 1382 of file ac_common.php.

{
    $result="";
    $p_string2=mb_convert_encoding($p_string,'ISO-8859-1','UTF-8');
    $p_string2=iconv('UTF-8','ISO-8859-1//IGNORE',$p_string);
 
    
    $nb_result=strlen($p_string2);
    for ($i = 0 ; $i < $nb_result ; $i++ ){
        if (ord($p_string[$i]) < 127 ) {
            $result.=$p_string[$i];
        } else {
            $result.='\u'.ord($p_string[$i]).chr(92).chr(39).'3f';
        }
    }
    return $result;
}

References $i, and $result.

Referenced by Acc_Bilan\generate_plain().

Decode()

Decode

(

$p_html

)

Decode the html for the widegt richtext and remove newline.

Parameters

$p_html

string to decode

Returns

the html code without new line

Definition at line 648 of file ac_common.php.

{
    $p_html = noalyss_str_replace('%0D', '', $p_html);
    $p_html = noalyss_str_replace('%0A', '', $p_html);
    $p_html = urldecode($p_html);
    return $p_html;
}

References noalyss_str_replace().

Here is the call graph for this function:

display_menu()

display_menu

(

$p_menuid

)

Display a menu @global type $g_user.

Parameters

type

$p_menuid

Returns

type

Definition at line 1150 of file ac_common.php.

{
    if ($p_menuid == 0) return;
    global $g_user;
    $cn=Dossier::connect();
    
    $file = $cn->get_array("
        select me_file,me_parameter,me_javascript,me_type
        from menu_ref
        join profile_menu using (me_code)
        join profile_user using (p_id)
        where
        pm_id=$1 and
        user_name=$2 and
        (me_file is not null or trim(me_file) <>'' or
        me_javascript is not null or trim (me_javascript) <> '')", array($p_menuid,$g_user->login));
 
    if (count($file)==0)
    {
            return;
    }
 
    if ($file[0]['me_file'] != "")
    {
            if ($file[0]['me_parameter'] !== "")
            {
                    // if there are paramter put them in superglobal
                    $array=compute_variable($file[0]['me_parameter']);
                    put_global($array);
            }
            \Noalyss\Dbg::echo_var(1,$file[0]['me_file']." ".$file[0]['me_parameter']);
            /*
             * Log the file we input to put in the folder test-noalyss for replaying it
             */
            if (LOGINPUT) {
                    $file_loginput=fopen($_ENV['TMP'].'/scenario-'.$_SERVER['REQUEST_TIME'].'.php','a+');
                    fwrite($file_loginput, "include '".$file[0]['me_file']."';");
                    fwrite($file_loginput,"\n");
                    fclose($file_loginput);
            }
            // if file is not a plugin, include the file, otherwise
            // include the plugin launcher
            if ( $file[0]['me_type'] != 'PL') {
                if (file_exists ($file[0]['me_file']) )
                {
                    require_once $file[0]['me_file'];
                } elseif ( file_exists(NOALYSS_INCLUDE.'/'.$file[0]['me_file'])) {
                    require_once NOALYSS_INCLUDE.'/'.$file[0]['me_file'];
                }else {                            
                    echo echo_warning(_("Fichier non trouvé"));
                }
            } else {
                    require 'extension_get.inc.php';
            }
 
            exit();
    } elseif ( $file[0]['me_javascript'] != '')
    {
        $js=  noalyss_str_replace('<DOSSIER>', dossier::id(), $file[0]['me_javascript']);
        echo create_script($js);
    } 
 
}

echo_error()

echo_error	(		$p_log,
			$p_line = "",
			$p_message = ""
	)

log error into the /tmp/noalyss_error.log it doesn't work on windows

Parameters

p_log	message
p_line	line number
p_message	is the message

Returns

nothing

Definition at line 169 of file ac_common.php.

{
    $msg="ERREUR :" . $p_log . " " . $p_line . " " . $p_message;
    echo $msg;
    syslog(LOG_ERR,$msg);
 
}

References $msg.

Referenced by Database\format_name(), Fiche\get_row(), Fiche\get_row_date(), getPeriodeName(), isValid_deprecrated(), Document_modele\Save(), sql_filter_per(), Document_modele\update(), and DatabaseCore\upload().

echo_warning()

echo_warning

(

$p_string

)

warns

Parameters

p_string

error message gen : none

Returns

:

• none

Definition at line 589 of file ac_common.php.

{
    echo '<span class="warning">' . $p_string . '</span>';
}

Referenced by Acc_Tax_Purchase_Sale\display(), Acc_Bilan\display_form(), Noalyss\Mobile\execute_menu(), Stock_Goods\input(), Extension\read_definition(), Dossier\synchro_admin(), and Dossier\upgrade().

factory_Ledger()

factory_Ledger	(	Database &	$p_cn,
			$ledger_id
	)

This function create a ledger object and return the right one.

It uses the factory pattern

Parameters

Database	$p_cn
type	$ledger_id

Returns

Acc_Ledger

Exceptions

Exception

Definition at line 1299 of file ac_common.php.

{
    $ledger=new Acc_Ledger($p_cn, $ledger_id);
    $type=$ledger->get_type();
 
    switch ($type)
    {
        case 'VEN':
            $obj=new Acc_Ledger_Sale($p_cn, $ledger_id);
            break;
        case 'ACH':
            $obj=new Acc_Ledger_Purchase($p_cn, $ledger_id);
            break;
        case 'FIN':
            $obj= new Acc_Ledger_Fin($p_cn, $ledger_id);
            break;
        case 'ODS':
            $obj=$ledger;
            break;
 
        default:
            throw new Exception('Ledger type not found');
    }
    return $obj;
}

References $ledger, $ledger_id, $obj, and $type.

FaxTo()

FaxTo

(

$p_tel

)

compose a HTML string with fax

Parameters

string

$p_fax

fax number

Returns

false|string returns false if $p_fax is empty

Definition at line 1642 of file ac_common.php.

                       {
    if (!empty($p_tel)) {
        $r=sprintf('<a href="fax:%s">%s</a>',h($p_tel),h($p_tel));
        return $r;
    }
    return false;
}

References $r, and h().

Here is the call graph for this function:

find_default_menu()

find_default_menu

(

$pn_menu

)

Find the menu marked as default in the given profile.

Parameters

number

$pn_menu

(profile_menu.id)

Definition at line 1457 of file ac_common.php.

{
    $cn=Dossier::connect();
    $sql = '  select pm_id from profile_menu where pm_default =1 and pm_id_dep = $1';
    $aresult=$cn->get_array($sql, [$pn_menu]);
    if (empty($aresult)) {
        return 0;
    }
    return $aresult[0]['pm_id'];
}

References $cn, $sql, and Dossier\connect().

Referenced by complete_default_menu().

Here is the call graph for this function:

find_default_module()

find_default_module

(

)

Definition at line 991 of file ac_common.php.

{
    global $g_user;
    $cn = Dossier::connect();
 
    $default_module = $cn->get_array("select me_code
            from profile_menu join profile_user using (p_id)
            where
            p_type_display='M' and
            user_name=$1 and pm_default=1", array($g_user->login));
 
        /*
         * Try to find the smallest order for module
         */
    if (empty($default_module))
    {
                $default_module = $cn->get_array("select me_code
            from profile_menu join profile_user using (p_id)
            where
            p_type_display='M' and
            user_name=$1 order by p_order limit 1", array($g_user->login));
 
                // if no default try to find the default menu
                if ( empty ($default_module))
                {
                        $default_module = $cn->get_array("select me_code
                         from profile_menu join profile_user using (p_id)
                           where
                           p_type_display='E' and
                           user_name=$1 and pm_default=1 ", array($g_user->login));
                        /*
                         * Try to find a default menu by order
                         */
                        if (empty ($default_module))
                        {
                                $default_module = $cn->get_array("select me_code
                                from profile_menu join profile_user using (p_id)
                                where
                                user_name=$1 and p_order=(select min(p_order) from profile_menu join profile_user using (p_id)
                                where user_name=$2) limit 1", array($g_user->login, $g_user->login));
                        }
 
                        /*
                        * if nothing found, there is no profile for this user => exit
                        */
                        if (empty ($default_module))
                        {
                            /* 
                             * If administrateur, then we insert a default profile (1)
                             * for him
                             */
                            if ( $g_user->admin == 1 )
                            {
                                $cn->exec_sql('insert into profile_user(user_name,p_id) values ($1,1) ',array($g_user->login));
                                return find_default_module();
                            }
                            echo_warning(_("Utilisateur n'a pas de profil, votre administrateur doit en configurer un dans CFGSEC"));
                            exit();
                        }
                }
                return $default_module[0]['me_code'];
    }
 
    if (count($default_module) > 1)
    {
                // return the first module found
                return $default_module[0]['me_code'];
    }
    elseif (count($default_module) == 1)
    {
        return $default_module[0]['me_code'];
    }
}

findSide()

findSide

(

$p_number

)

return D if the number is smaller than 0 , C if bigger and an empty string if equal to 0.

Used for displaying saldo D / C (debit / credit )

Parameters

float

$p_number

Definition at line 121 of file ac_common.php.

{
    $return ='';
    if ( $p_number > 0 ) {
        $return ='D';
    }else {
        $return =($p_number== 0)?"":"C";
    }
    return $return;
}

Referenced by Anc_Listing\display_html().

format_date()

format_date	(		$p_date,
			$p_from_format = 'YYYY-MM-DD',
			$p_to_format = 'DD.MM.YYYY'
	)

format the date, when taken from the database the format is MM-DD-YYYY

Parameters

$p_date

format

Exceptions

1	if invalid format DOMEntity

Parameters

return date in the format DD.MM.YYYY

Definition at line 852 of file ac_common.php.

{
    if (empty($p_date)) {return $p_date;}
    if ($p_from_format == 'YYYY-MM-DD')
    {
        $date = explode('-', $p_date);
        if (count($date) != 3)
            return $p_date;
    }
    if ($p_from_format == 'DD.MM.YYYY')
    {
        $temp_date = explode('.', $p_date);
        if (count($temp_date) != 3)
            return $p_date;
        $date[0] = $temp_date[2]; // 0 is year
        $date[1] = $temp_date[1]; // 1 for month
        $date[2] = $temp_date[0]; // 2 for day
    }
 
    switch ($p_to_format)
    {
        case 'DD.MM.YYYY':
            $str_date = $date[2] . '.' . $date[1] . '.' . $date[0];
            break;
        case 'DD-MM-YYYY':
            $str_date = $date[2] . '-' . $date[1] . '-' . $date[0];
            break;
        case 'YYYY-MM-DD':
            $str_date = $date[0] . '-' . $date[1] . '-' . $date[2];
            break;
       case 'YYYYMMDD':
            $str_date = $date[0] . $date[1] . $date[2];
            break;
        case 'YYYY/MM/DD':
            $str_date = $date[0] . '/' . $date[1] . '/' . $date[2];
            break;
        case "DD.MM.YY":
            $str_date = $date[2] . '.' . $date[1] . '.' . substr($date[0],2,2);
            break;
        case "DD-MM-YY":
            $str_date = $date[2] . '-' . $date[1] . '-' . substr($date[0],2,2);
            break;
        default:
            throw new Exception(_("Format Invalide"),1);
            
                }
    return $str_date;
}

Referenced by Stock\build_tmp_table(), Anticipation\display(), Operation_Exercice\display_result(), Periode_Ledger_Table\display_row(), Periode\display_row_global(), Acc_Bilan\filter_date(), Acc_Account_Ledger\HtmlTable(), Fiche\HtmlTable(), Follow_Up\myList(), and Document\replace().

FormatString()

FormatString

(

$p_string

)

replaced by sql_string

Deprecated:

Definition at line 500 of file ac_common.php.

{
    return sql_string($p_string);
}

References sql_string().

Here is the call graph for this function:

generate_random_password()

generate_random_password

(

$car

)

generate a strong random password

Parameters

$car	int length of the password, minimum 8

Definition at line 1748 of file ac_common.php.

                                       :string
{
    $string="";
    $car=($car < 8 )?8:$car;
    $max_loop=20;$loop=0;
    do
    {
        $loop++;
        $string="";
        $chaine="abcdefghijklmnpqrstuvwxy";
       // srand( (int)microtime()*1020030);
        for ($i=0; $i<$car; $i++)
        {
            $string .= $chaine[rand()%strlen($chaine)];
        }
        $chaine="ABCDEFGHIJKLMNPQRSTUVWXY";
        for ($i=0;$i<2;$i++) {
            $string[rand()%$car]=$chaine[rand()%strlen($chaine)];;
        }
        $chaine="0123456789";
        for ($i=0;$i<2;$i++) {
            $string[rand()%$car]=$chaine[rand()%strlen($chaine)];;
        }
        $special_set="+-/*;,.=:&()[]";
        $special_car=$special_set[rand()%strlen($special_set)];
        $string[rand()%$car]=$special_car;
     //   echo $string."\n";
    }while ( count(check_password_strength($string)['msg'])> 0 && $loop<$max_loop);
    return $string;
}

References $i, $string, and check_password_strength().

Here is the call graph for this function:

generate_random_string()

generate_random_string	(		$p_length,
			$special = 1
	)

Create randomly a string.

Parameters

int

$p_length

length of the generate string

Definition at line 1420 of file ac_common.php.

{
    $string="";
    if ($special == 1)
        $chaine="abcdefghijklmnpqrstuvwxyABCDEFGHIJKLMNPQRSTUVWXY0123456789*/+-=";
    if ($special == 0)
        $chaine="abcdefghijklmnpqrstuvwxyABCDEFGHIJKLMNPQRSTUVWXY0123456789";
    $microtime=microtime(true)*microtime(true)*100;
    srand(0);
    srand((int)$microtime);
    for ($i=0; $i<$p_length; $i++)
    {
        $string .= $chaine[rand()%strlen($chaine)];
    }
    return $string;
}

References $i, and $string.

Referenced by confirm_with_string(), and display_file_config().

get_array_column()

get_array_column	(		$p_array,
			$key
	)

Definition at line 1278 of file ac_common.php.

{
    $array=array();
    for ($i=0;$i<count($p_array);$i++)
    {
        $r=$p_array[$i];
        if ( isset($r[$key])) {
            $array[]=$r[$key];
        }
    }
    return $array;
}

References $array, $i, $p_array, and $r.

getPeriodeFromMonth()

getPeriodeFromMonth	(		$p_cn,
			$p_date
	)

Return the period corresponding to the date.

Parameters

p_cn	database connection
p_date	the month + year 'MM.YYYY'

Returns

: parm_periode.p_id

Definition at line 633 of file ac_common.php.

{
    $R = $p_cn->get_value("select p_id from parm_periode where
                        to_char(p_start,'DD.MM.YYYY') = $1", array('01.'.$p_date));
    if ($R == "")
        return -1;
    return $R;
}

References $p_date.

getPeriodeName()

getPeriodeName	(		$p_cn,
			$p_id,
			$pos = 'p_start'
	)

Show the periode which found thanks its id.

Parameters

$p_cn	database connection
p_id
pos	Start or end

Returns

: string

Definition at line 605 of file ac_common.php.

{
    if ($pos != 'p_start' &&  $pos != 'p_end')
    {
        echo_error('lib/ac_common.php' . "-" . __LINE__ . '  UNDEFINED PERIODE');
        throw new Exception(_("paramètre invalide"));
    }
    if ( isNumber($p_id) == 0 )
        {
        throw new Exception("Paramètre invalide");
        return;
        }
    $ret = $p_cn->get_value("select to_char($pos,'Mon YYYY') as t from parm_periode where p_id=$1", 
           array( $p_id));
    return $ret;
}

References $p_id, $pos, $ret, echo_error(), and isNumber().

Here is the call graph for this function:

h()

h

(

$p_string

)

to protect again bad characters which can lead to a cross scripting attack the string to be diplayed must be protected.

Side effects with htmlentities, especially for the date (transform dot in &periode;) and number

Definition at line 35 of file ac_common.php.

{
    return ( $p_string === null)?"":htmlspecialchars($p_string,ENT_QUOTES|ENT_HTML5,'UTF-8',true);
}

References ENT_QUOTES.

Referenced by FaxTo(), h1(), h2info(), hb(), hi(), mailTo(), phoneTo(), and th().

h1()

h1	(		$p_string,
			$p_class = ""
	)

Examples

acc_ledger_historyTest.php, and inplace_edit.test.php.

Definition at line 72 of file ac_common.php.

{
    return '<h1 ' . $p_class . '>' . h($p_string) . '</h1>';
}

References h().

Referenced by Fiche\test_me().

Here is the call graph for this function:

h2()

h2	(		$p_string,
			$p_class = "",
			$raw = ""
	)

Examples

acc_ledger_historyTest.php.

Definition at line 68 of file ac_common.php.

{
    return '<h2 ' . $p_class . '>' . $raw.h($p_string) . '</h2>';
}

Referenced by Acc_Ledger\display_additional_tax(), Noalyss\Dbg\display_request(), Operation_Closing\display_result(), Operation_Opening\display_result(), Print_Operation_Currency\export_html(), Acc_Ledger_Fin\input(), Template_Card_Category\input(), Acc_Ledger\input_additional_tax(), Anticipation\input_form(), Document_modele\myList(), Tag\show_form_add(), Default_Menu\test_me(), HtmlInput\title_box(), and Follow_Up\update().

h2info()

h2info

(

$p_string

)

Definition at line 63 of file ac_common.php.

{
    return '<h2 class="info">' . h($p_string) . '</h2>';
}

References h().

Referenced by Anc_Balance_Double\display_html().

Here is the call graph for this function:

hb()

hb

(

$p_string

)

Definition at line 53 of file ac_common.php.

{
    return '<b>' . h($p_string) . '</b>';
}

References h().

Referenced by Acc_Ledger_Purchase\confirm(), and Acc_Ledger_Sale\confirm().

Here is the call graph for this function:

header_csv()

header_csv

(

$p_filename

)

Send an header CSV with a filename.

Parameters

string

$p_filename,file

name , caution , it must be sanitized BEFORE calling this function

Definition at line 1217 of file ac_common.php.

{
  
    header('Pragma: public');
    header('Content-type: application/csv');
    header("Content-Disposition: attachment;filename=\"{$p_filename}\"",
            FALSE);
    header('Cache-Control: no-store, no-cache, must-revalidate');
    header('Expires: Sun, 1 Jan 2000 12:00:00 GMT');
    header('Last-Modified: '.gmdate('D, d M Y H:i:s').'GMT');
}

hi()

hi

(

$p_string

)

Definition at line 48 of file ac_common.php.

{
    return '<i>' . h($p_string) . '</i>';
}

References h().

Referenced by Template_Card_Category\input().

Here is the call graph for this function:

html_min_page_start()

html_min_page_start	(		$p_theme = "",
			$p_script = "",
			$p_script2 = ""
	)

Minimal page header for each page, used for small popup window.

Parameters

p_theme	default theme
$p_script
$p_script2	another js script

Returns

none

Definition at line 408 of file ac_common.php.

{
 
    $cn = new Database();
    if ($p_theme != "")
    {
        $Res = $cn->exec_sql("select the_filestyle from theme
                           where the_name='" . $p_theme . "'");
        if (Database::num_row($Res) == 0)
            $style = "style-classic7.css";
        else
        {
            $s = Database::fetch_array($Res, 0);
            $style = $s['the_filestyle'];
        }
    }
    else
    {
        $style = "style-classic7.css";
    } // end if
    echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 FINAL//EN">';
    echo "<HTML>";
 
 
    if ($p_script2!="")
    {
        $p_script2='<script src="'.$p_script2.'" type="text/javascript"></script>';
    }
 
    echo "<HEAD>
    <TITLE>NOALYSS</TITLE>
    <META http-equiv=\"Content-Type\" content=\"text/html; charset=UTF8\">
    <LINK REL=\"stylesheet\" type=\"text/css\" href=\"css/$style\" media=\"screen\">
    <link rel=\"stylesheet\" type=\"text/css\" href=\"css/style-print.css\" media=\"print\">" .
    $p_script2 . "
    <script src=\"js/prototype.js\" type=\"text/javascript\"></script>
    <script src=\"js/noalyss_script.js\" type=\"text/javascript\"></script>
    <script src=\"js/acc_ledger.js\" type=\"text/javascript\"></script>
    <script src=\"js/smoke.js\" type=\"text/javascript\"></script>";
    echo "<LINK id=\"pagestyle\" REL=\"stylesheet\" type=\"text/css\" href=\"css/font/fontello/css/fontello.css\" media=\"screen\"/>";
    include_once NOALYSS_INCLUDE.'/lib/message_javascript.php';
    //  Retrieve colors for this folder
    if ( isset($_REQUEST['gDossier'])  ) {
        $noalyss_appearance=new Noalyss_Appearance();
        $noalyss_appearance->print_css();
    }
    echo '</HEAD>';
    echo "<BODY $p_script>";
    /* If we are on the user_login page */
    if (basename($_SERVER['PHP_SELF']) == 'user_login.php')
    {
        return;
    }
}

References $_REQUEST, $cn, $noalyss_appearance, $Res, $s, $style, DatabaseCore\fetch_array(), and DatabaseCore\num_row().

Here is the call graph for this function:

html_page_start()

html_page_start	(		$p_theme = "",
			$p_script = "",
			$p_script2 = ""
	)

Default page header for each page.

Parameters

p_theme	default theme
$p_script
$p_script2	another js script Must be called only once

Returns

none

Examples

inplace_edit.test.php.

Definition at line 275 of file ac_common.php.

{
    // check not called twiced
    static  $already_call=0;
    if ( $already_call==1)return;
    $already_call=1;
 
    $cn = new Database();
    if ($p_theme != "")
    {
        $Res = $cn->exec_sql("select the_filestyle from theme
                           where the_name=$1" ,[$p_theme]);
        if (Database::num_row($Res) == 0)
        {
            $style = "style-classic7.css";
        }
        else
        {
            $s = Database::fetch_array($Res, 0);
            $style = $s['the_filestyle'];
        }
    }
    else
    {
        $style = "style-classic7.css";
    } // end if
        $title="NOALYSS";
        
        if ( isset ($_REQUEST['ac'])) {
            $ac=strip_tags($_REQUEST['ac']);
                if (strpos($ac,'/') <> 0)
                {
                        $m=  explode('/',$ac);
                        $title=$m[count($m)-1]."  ".$title;
                }
                else
                        $title=$ac."  ".$title;
        }
    $is_msie=is_msie();
    
    if ($is_msie == 0 ) 
    {
        echo '<!doctype html>';
        printf("\n");
 
    }
    else {
        echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 FINAL//EN" >';
        printf("\n");
    }
    echo '<HTML>';
    
    if ($p_script2!="")
    {
        $p_script2='<script src="'.$p_script2.'" type="text/javascript"></script>';
    }
    $style=trim($style);
    echo "<HEAD>";
    echo '<meta charset="utf-8">';
    echo "<META http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">";
    if ($is_msie==1)
    {
        echo '      <meta http-equiv="x-ua-compatible" content="IE=edge"/>';
    }
    global $version_noalyss;
    echo <<<EOF
    <TITLE>$title</TITLE>
        <link rel="icon" type="image/ico" href="favicon.ico" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <LINK id="bootstrap" REL="stylesheet" type="text/css" href="css/bootstrap.min.css" media="screen"/>
    <LINK id="fontello" REL="stylesheet" type="text/css" href="css/font/fontello/css/fontello.css" media="screen"/>
    <LINK id="pagestyle" REL="stylesheet" type="text/css" href="css/$style?version=$version_noalyss" media="screen"/>
    <link rel="stylesheet" type="text/css" href="css/style-print.css?version=$version_noalyss" media="print"/>
    $p_script2 
EOF;
    // preload font
    echo    '<link rel="preload" href="css/font/OpenSansRegular.woff" as="font" crossorigin="anonymous" />';
    echo    '<link rel="preload" href="css/font/SansationLight/SansationLight.woff" as="font" crossorigin="anonymous" />';
    echo    '<link rel="preload" href="css/font/fontello/fontello.woff" as="font" crossorigin="anonymous" />';
    
    echo '<script language="javascript" src="js/calendar.js"></script>
    <script type="text/javascript" src="js/lang/calendar-en.js"></script>';
 
    if (isset($_SESSION[SESSION_KEY.'g_lang']) && $_SESSION[SESSION_KEY.'g_lang']=='fr_FR.utf8' )
    {
        echo '<script type="text/javascript" src="js/lang/calendar-fr.js"></script>';
    }
    if (isset($_SESSION[SESSION_KEY.'g_lang']) && $_SESSION[SESSION_KEY.'g_lang']=='nl_NL.utf8' )
    {
        echo '<script type="text/javascript" src="js/lang/calendar-nl.js"></script>';
    }
    echo '
    <script language="javascript" src="js/calendar-setup.js"></script>
    <LINK REL="stylesheet" type="text/css" href="css/calendar-blue.css" media="screen">
    ';
    // language
    if (isset($_SESSION[SESSION_KEY.'g_lang']))
    {
                set_language();
    }
 
    echo load_all_script();
 
    //  Retrieve colors for this folder
    if ( isset($_REQUEST['gDossier'])  ) {
        $noalyss_appearance=new Noalyss_Appearance();
        $noalyss_appearance->print_css();
    }
    echo '    </HEAD>    ';
 
    echo "<BODY $p_script>";
    echo '<div id="info_div"></div>';
    echo '<div id="error_div">'.
            HtmlInput::title_box(_("Erreur"), 'error_div','hide').
            '<div id="error_content_div">'.
            '</div>'.
            '<p style="text-align:center">'.
            HtmlInput::button_action('Valider','$(\'error_div\').style.visibility=\'hidden\';$(\'error_content_div\').innerHTML=\'\';').
            '</p>'.
            '</div>';
 
}

References $_REQUEST, $ac, $cn, $m, $noalyss_appearance, $Res, $s, $style, $title, $version_noalyss, HtmlInput\button_action(), content, DatabaseCore\fetch_array(), is_msie(), load_all_script(), name, DatabaseCore\num_row(), set_language(), HtmlInput\title_box(), and type.

Referenced by Acc_Ledger\test_me().

Here is the call graph for this function:

html_page_stop()

html_page_stop

(

)

end tag

Definition at line 468 of file ac_common.php.

{
    echo "</BODY>";
    echo "</HTML>";
}

is_msie()

is_msie

(

)

Check if we use IE 8 or 9.

Returns

int 1 for IE8-9;0 otherwise

Definition at line 1328 of file ac_common.php.

{
    if ( strpos ($_SERVER['HTTP_USER_AGENT'],'MSIE 8.0')  != 0 ||
         strpos ($_SERVER['HTTP_USER_AGENT'],'MSIE 9.0')  != 0 )
       $is_msie=1;
    else
        $is_msie=0;
    return $is_msie;
}

Referenced by html_page_start().

isDate()

isDate

(

$p_date

)

Definition at line 236 of file ac_common.php.

{
    if (noalyss_strlentrim($p_date) == 0)
        return null;
    if (preg_match("/^[0-9]{1,2}\.[0-9]{1,2}\.[0-9]{4}$/", $p_date) == 0)
    {
 
        return null;
    }
    else
    {
        $l_date = explode(".", $p_date);
 
        if (sizeof($l_date) != 3)
            return null;
 
        if ($l_date[2] > COMPTA_MAX_YEAR || $l_date[2] < COMPTA_MIN_YEAR)
        {
            return null;
        }
 
        if (checkdate($l_date[1], $l_date[0], $l_date[2]) == false)
        {
            return null;
        }
    }
    return $p_date;
}

References $p_date, COMPTA_MAX_YEAR, COMPTA_MIN_YEAR, and noalyss_strlentrim().

Referenced by Acc_Ledger_Search\build_search_sql(), Todo_List\check(), Anc_Print\check(), Currency_MTable\check(), HttpInput\check_type(), cmpDate(), Acc_Ledger_Fin\confirm(), Follow_Up\create_query(), Anc_Table\create_temp_table_account(), Anc_Table\create_temp_table_card(), Acc_Bilan\filter_date(), Acc_Reconciliation\filter_date(), Follow_Up\fromArray(), Acc_Currency\get_rate_date(), Acc_Account_Ledger\get_used_accounting(), Periode\insert(), Acc_Operation\operation_update_date_limit(), Stock_Goods\record_save(), Acc_Ledger\reverse(), Tax_Summary\set_date_end(), Tax_Summary\set_date_start(), Anc_Acc_Link\set_sql_filter(), sql_filter_per(), Follow_Up\verify(), Todo_List\verify(), Acc_Ledger_Fin\verify_operation(), Acc_Ledger_Purchase\verify_operation(), and Acc_Ledger_Sale\verify_operation().

Here is the call graph for this function:

isNumber()

isNumber

(

$p_int

)

Definition at line 215 of file ac_common.php.

{
    if (strlen(noalyss_trim($p_int)) == 0)
        return 0;
    if (is_numeric($p_int) === true)
        return 1;
    else
        return 0;
}

References noalyss_trim().

Referenced by Fiche\__construct(), Acc_Ledger_Search\build_search_sql(), Todo_List\check(), Card_Attribut_MTable\check(), Currency_MTable\check(), Mobile_Device_MTable\check(), Tva_Rate_MTable\check(), HttpInput\check_type(), Acc_Ledger\convert_from_follow(), Follow_Up\create_query(), Stock\create_query_histo(), Acc_Ledger\display_ledger(), Follow_Up\filter_by_tag(), contact\filter_category(), Follow_Up_Detail\from_array(), Lettering_Account\get_filter(), Lettering_Card\get_filter(), Acc_Ledger\get_last_pj(), getPeriodeName(), ITva_Popup\input(), Acc_Reconciliation\insert(), Acc_Ledger_Fin\insert(), Periode\insert(), Periode\insert_exercice(), Acc_Reconciliation\insert_rapt(), Noalyss_Csv\nb(), Acc_Reconciliation\remove(), Document\replace_special_tag(), Document_modele\Save(), IDate\set_firstDate(), Acc_Operation\set_id(), Acc_Ledger\verify_ledger(), Acc_Ledger_Fin\verify_operation(), Acc_Ledger_Purchase\verify_operation(), and Acc_Ledger_Sale\verify_operation().

Here is the call graph for this function:

j()

j

(

$p_string

)

escape correctly php string to javascript

Definition at line 96 of file ac_common.php.

{
    $a = preg_replace("/\r?\n/", "\\n", addslashes($p_string));
    $a = noalyss_str_replace("'", '\'', $a);
    return $a;
}

References $a, and noalyss_str_replace().

Referenced by alert().

Here is the call graph for this function:

linkTo()

linkTo

(

$p_url

)

Definition at line 1649 of file ac_common.php.

{
    if (empty($p_url) ) return "";
    if (filter_var(trim($p_url,FILTER_VALIDATE_URL)) ) {
        return sprintf('<a href="%s" target="_blank">%s</a>',$p_url,$p_url);
    } else {
        return $p_url;
    }
}

References $p_url.

Referenced by Card_Property\add_link().

mailTo()

mailTo

(

$p_email

)

compose a HTML string with email

Parameters

string

$p_email

email or emails separated by a comma

Returns

false|string returns false if email not valide

Definition at line 1615 of file ac_common.php.

                          {
    if (empty($p_email )) return "";
    $nComma=preg_match("/,/",$p_email);
    if ( $nComma > 0) {
        $aEmail=explode(",",$p_email);
    } else {
        $aEmail[0]=$p_email;
    }
    $r="";
    foreach ($aEmail as $email) {
        if ( filter_var(trim($email),FILTER_VALIDATE_EMAIL) ) {
            $r.=sprintf('<a href="mailto:%s">%s</a> ',h($email),h($email));
        } else {
            $r.=sprintf("%s",h($email));
            $r.=Icon_Action::warnbulle(83);
 
        }
 
    }
    return $r;
}

References $r, h(), and Icon_Action\warnbulle().

Referenced by Card_Property\add_link().

Here is the call graph for this function:

MaintenanceMode()

MaintenanceMode

(

$p_file

)

When you want to prevent users to connect, create a file in noalyss/ (NOALYSS_BASE) with the message in Html.

Parameters

string

$p_file

file in NOALYSS_BASE

Definition at line 1663 of file ac_common.php.

{
    if ( file_exists(NOALYSS_BASE."/".$p_file )) {
        include NOALYSS_BASE."/".$p_file;
        exit;
    }
}

References exit.

nb()

nb

(

$p_number

)

format the number for the CSV export

Parameters

$p_number

number

Definition at line 107 of file ac_common.php.

{
    $r=trim($p_number);
    $r = sprintf('%.4f', $p_number);
    $r = noalyss_str_replace('.', ',', $r);
 
    return $r;
}

References $r, and noalyss_str_replace().

Referenced by Acc_Ledger\__construct(), Sort_Table\__construct(), Sort_Table\add(), Acc_Ledger\convert_from_follow(), Anc_Balance_Double\display_pdf(), Sort_Table\get_header(), Acc_Ledger\input(), and PDF_Operation\print_operation_info().

Here is the call graph for this function:

nbm()

nbm	(		$p_number,
			$p_dec = 2
	)

format the number with a sep.

for the thousand

Parameters

$p_number	number
$p_dec	number of decimal to display

Definition at line 137 of file ac_common.php.

{
 
    if (noalyss_trim($p_number) == '')
        return '';
    if ($p_number == 0)
        return "0,00";
    
    $a = doubleval($p_number);
    $r = number_format($a, $p_dec, ",", ".");
    if (trim($r) == '')
    {
        var_dump($r);
        var_dump($p_number);
        var_dump($a);
        exit();
    }
 
    return $r;
}

References $a, $r, exit, and noalyss_trim().

Referenced by Acc_Ledger_Fin\confirm(), Acc_Ledger\confirm(), Acc_Ledger_Purchase\confirm(), Acc_Ledger_Sale\confirm(), Anc_GrandLivre\display_html(), Anc_Acc_List\display_html(), Anc_Balance_Double\display_html(), Anc_Balance_Simple\display_html(), Anc_Listing\display_html(), Anc_Table\display_html(), Anc_Balance_Simple\display_pdf(), Operation_Exercice\display_row(), Additional_Tax\display_row(), Forecast_Item_MTable\display_row(), Manage_Table_SQL\display_row(), Operation_Exercice\display_total(), Print_Ledger_Detail\export(), Print_Ledger_Detail_Item\export(), Print_Ledger_Financial\export(), Print_Ledger_Misc\export(), Print_Ledger_Simple\export(), Print_Operation_Currency\export_csv(), Print_Operation_Currency\export_html(), Acc_Ledger_History_Generic\export_oneline_html(), Print_Ledger_Financial\Footer(), Print_Ledger_Simple\Footer(), Print_Ledger_Financial\Header(), Print_Ledger_Simple\Header(), Acc_Account_Ledger\HtmlTable(), Fiche\HtmlTable(), Acc_Ledger_Fin\insert(), Acc_Ledger_Search\list_operation(), Acc_Ledger_Search\list_operation_to_reconcile(), PDF_Anc_Acc_List\pdf_card(), PDF_Operation\print_acc_writing(), PDF_Operation\print_anc_detail(), PDF_Operation\print_operation_info(), PDF_Operation\print_other_tax(), PDF_Operation\print_purchase(), PDF_Operation\print_sale(), PDF_Anc_Acc_List\put_total(), Fiche\Summary(), Acc_Balance\summary_display(), and Acc_Balance\summary_display_pdf().

Here is the call graph for this function:

NoAccess()

NoAccess

(

$js = 1

)

Echo no access and stop.

Returns

nothing

Definition at line 480 of file ac_common.php.

{
    if ($js == 1)
    {
        echo "<script>";
        echo "alert ('" . _('Cette action ne vous est pas autorisée Contactez votre responsable') . "');";
        echo "</script>";
    }
    else
    {
        echo '<div class="redcontent">';
        echo '<h2 class="error">' . _(' Cette action ne vous est pas autorisée Contactez votre responsable') . '</h2>';
        echo '</div>';
    }
    exit - 1;
}

References $js, and exit.

noalyss_bcadd()

noalyss_bcadd	(		$p_first,
			$p_second,
			$p_decimal = 4
	)

Definition at line 1563 of file ac_common.php.

{
    $p_first=(empty($p_first))?0:$p_first;
    $p_second=(empty($p_second))?0:$p_second;
    return bcadd($p_first,$p_second,$p_decimal);
}

Referenced by Print_Ledger_Detail_Item\export(), and Document\replace().

noalyss_bcmul()

noalyss_bcmul	(		$p_first,
			$p_second
	)

Definition at line 1574 of file ac_common.php.

{
    $p_first=(empty($p_first))?0:$p_first;
    $p_second=(empty($p_second))?0:$p_second;
      return bcmul($p_first??0,$p_second??0);
}

Referenced by Document\replace().

noalyss_bcsub()

noalyss_bcsub	(		$p_first,
			$p_second,
			$p_decimal = 4
	)

Definition at line 1557 of file ac_common.php.

{
    $p_first=(empty($p_first))?0:$p_first;
    $p_second=(empty($p_second))?0:$p_second;
    return bcsub($p_first,$p_second,$p_decimal);
}

Referenced by Print_Ledger_Detail_Item\export(), and Acc_Ledger\previous_amount().

noalyss_explode()

noalyss_explode	(		$separator,
			$string
	)

to avoid deprecated in PHP8.1 : explode cannot use a null

Parameters

$separator
$string

Returns

array | empty string

Definition at line 1593 of file ac_common.php.

                                             {
    if ($string===null) return '';
    return explode($separator,$string);
}

References $string.

Referenced by Acc_Ledger\display_ledger().

noalyss_round()

noalyss_round	(		$p_first,
			$p_second
	)

Definition at line 1580 of file ac_common.php.

{
    $p_first=(empty($p_first))?0:$p_first;
    $p_second=(empty($p_second))?0:$p_second;
    return round($p_first??0,$p_second??0);
}

Referenced by Document\replace().

noalyss_str_replace()

noalyss_str_replace	(		$search,
			$replace,
			$string
	)

Definition at line 1553 of file ac_common.php.

                                                       {
    if ($string===null) return "";
    else return str_replace($search,$replace??"",$string);
}

References $string.

Referenced by Lettering\__construct(), Select_Box\add_javascript(), Acc_Ledger_Search\build_search_filter(), Fiche\build_sql(), Noalyss_Parameter_Folder\check(), Anc_Account_Table\check(), Impress\check_formula(), clean_filename(), Impress\compute_amount(), Document\compute_filename(), Acc_Bilan\compute_formula(), Noalyss_Csv\correct_name(), Decode(), escape_xml(), Noalyss\Mobile\execute_menu(), Acc_Ledger_History_Generic\export_csv(), Document_Export\export_receipt(), Anc_Key\fill_table(), Menu_Ref\format_code(), Acc_Bilan\generate_odt(), Acc_Bilan\generate_plain(), Acc_Operation\get_jrnx_detail(), Acc_Ledger\get_last(), Acc_Account_Ledger\get_row_date(), INum\input(), IText\input(), j(), Acc_Reconciliation\ledger_filter(), navigation_bar(), nb(), Impress\parse_formula(), Document\parseDocument(), PDF_Core\print_row(), Anc_Group\remove(), remove_divide_zero(), Document\replace(), Document\replace_value(), Acc_Ledger_Search\search_form(), sql_string(), Fiche_Def\to_array(), toNumber(), transform_sql_filter_per(), unescape_xml(), and Noalyss_Csv\write().

noalyss_strip_tags()

noalyss_strip_tags

(

$p_string

)

Definition at line 1569 of file ac_common.php.

{
    if ($p_string===null) return "";
    return strip_tags($p_string);
}

Referenced by Card_Property\update().

noalyss_strlen()

noalyss_strlen

(

$p_string

)

Definition at line 1541 of file ac_common.php.

                                   :int{
    if ($p_string ==null ) return 0;
    else return strlen($p_string);
}

Referenced by Manage_Table_SQL\input().

noalyss_strlentrim()

noalyss_strlentrim

(

$p_string

)

Definition at line 1549 of file ac_common.php.

                                       :int {
    if ($p_string ==null ) return 0;
    return strlen(trim($p_string));
}

Referenced by Fiche_Def\Add(), Card_Property\build_input(), Fiche\build_sql(), Todo_List\check(), Acc_Plan_MTable\check(), Acc_Bilan\compute_formula(), Acc_Ledger_Fin\confirm(), Acc_Ledger_Purchase\confirm(), Acc_Ledger_Sale\confirm(), Acc_Ledger\create_document(), Follow_Up\create_query(), Pre_op_ach\display(), Pre_op_ven\display(), Follow_Up\display(), Acc_Operation\display_jrnx_detail(), Acc_Account_Ledger\get_account_ledger(), Acc_Ledger_History_Generic\get_detail(), Acc_Ledger_History_Generic\get_row(), Acc_Ledger_Purchase\input(), Acc_Ledger_Sale\input(), Acc_Ledger_Fin\insert(), Acc_Ledger_Purchase\insert(), Acc_Ledger_Sale\insert(), Periode\insert(), Acc_Operation\insert_jrn(), isDate(), Follow_Up\myList(), Document\replace(), Pre_op_ach\save(), Pre_op_ven\save(), Acc_Ledger_Info\save_extra(), Acc_Operation\set_pj(), Dossier\update(), Card_Property\update(), Acc_Report\upload(), Forecast\verify(), Acc_Ledger_Fin\verify_operation(), Acc_Ledger_Purchase\verify_operation(), and Acc_Ledger_Sale\verify_operation().

noalyss_trim()

noalyss_trim

(

$p_string

)

Definition at line 1545 of file ac_common.php.

                                 {
    if ($p_string===null) return "";
    else return trim($p_string);
}

Referenced by Fiche\build_sql(), Fiche\empty_attribute(), isNumber(), Noalyss_Csv\nb(), nbm(), Follow_Up\save(), Fiche\strAttribut(), Fiche\Summary(), Acc_Account\verify(), Data_SQL\verify(), and Acc_Ledger\verify_autonumber().

p()

p

(

$p_string

)

Examples

select-box-test.php.

Definition at line 39 of file ac_common.php.

{
    return '<p>'.$p_string."</p>";
}

Referenced by Fiche_Def\input_detail(), and Fiche\test_me().

phoneTo()

phoneTo

(

$p_tel

)

compose a HTML string with phone

Parameters

string

$p_tel

Returns

false|string returns false if $p_tel is empty

Definition at line 1602 of file ac_common.php.

                         {
     if (!empty($p_tel)) {
     $r=sprintf('<a href="tel:%s">%s</a>',h($p_tel),h($p_tel));
     return $r;
     }
    return false;
}

References $r, and h().

Here is the call graph for this function:

put_global()

put_global

(

$array

)

Put in superglobal (get,post,request) the value contained in the parameter field (me_parameter)

Parameters

$array

[key] [value]

Definition at line 1233 of file ac_common.php.

{
    for ($i=0;$i<count($array);$i++)
    {
        $key=$array[$i]['key'];
        $value=$array[$i]['value'];
        $_GET[$key]=$value;
        $_POST[$key]=$value;
        $_REQUEST[$key]=$value;
    }
}

References $_GET, $_POST, $_REQUEST, $array, $i, and $value.

Referenced by Noalyss\Mobile\execute_menu(), and Dossier\set_current().

rebuild_access_code()

rebuild_access_code

(

$pan_code

)

rebuild the access code

See also

complete_default_menu

Parameters

array

of number $pan_code index row [0] = index pm_id_v1 , pm_id_v2 and pm_id_v3

Definition at line 1508 of file ac_common.php.

{
    if ( empty ($pan_code)) {return;}
    $s_result="";
    $cn=Dossier::connect();
    $an_code=['pm_id_v3','pm_id_v2','pm_id_v1'];
    $sep="";
    for ($i=0;$i<3;$i++)
    {
        $ix=$an_code[$i];
        $s_result.=$sep.$cn->get_value("select me_code from profile_menu where pm_id=$1",[ $pan_code[0][$ix] ]);
        $sep=($s_result != "" )?"/":"";
    }
    return $s_result;
}

References $cn, $i, $ix, $sep, and Dossier\connect().

Here is the call graph for this function:

record_log()

record_log

(

$p_message

)

Record an error message into the log file of the server.

Record also the GET and POST data

Parameters

string

$p_message

Definition at line 1342 of file ac_common.php.

{
    if ( gettype ($p_message) == "object" && method_exists($p_message,"getTraceAsString") == 1) {
 
        error_log("noalyss exception ".$p_message->getMessage(),0);
        error_log("noalyss exception".$p_message->getTraceAsString(),0);
    } else {
        error_log("noalyss".var_export($p_message,true),0);
 
    }
    error_log("noalyss GET [".json_encode($_GET,0,10)."]");
    error_log("_POST [".json_encode($_POST,0,10)."]",0);
}
if(!function_exists('tracedebug')) {
  function tracedebug($file,$var, $label = NULL) {
 
    $tmp_file = sys_get_temp_dir().DIRECTORY_SEPARATOR.$file;
    if ( ! is_writable($tmp_file)) return;
    $output = '';
    $output .= date('d-m-y H:i');
    if(!is_null($label)) {
      $output .= $label . ': ';
    }
    if ( gettype ($var) == 'object' && get_class($var)=='DOMDocument')
    {
      $var->formatOutput=true;
      $output.=$var->saveXML() .PHP_EOL;
    } else
    {
      $output .= print_r($var, 1) . PHP_EOL;
    }
 
    file_put_contents($tmp_file, $output, FILE_APPEND);
  }
}

References $_GET, and $_POST.

Referenced by Anc_Group_Operation\add(), Sendmail_Core\compose(), Noalyss_Csv\correct_name(), Action_Document_Type_MTable\delete(), Acc_Ledger\delete_ledger(), Card_Multiple\display_option(), DatabaseCore\exec_sql(), Document\generate(), Table_Data_SQL\get_all_to_array(), Anc_Operation\get_balance(), Fiche\get_bank_ledger(), Acc_Ledger\input(), Acc_Ledger_Purchase\input(), Acc_Ledger_Fin\insert(), Acc_Ledger_Sale\insert(), Periode\insert(), Fiche\insert(), Acc_Ledger_Info\insert(), Periode\insert_exercice(), Acc_Bilan\load(), Document\parseDocument(), Stock_Goods\record_save(), Acc_Ledger\reverse(), Anc_Key\save(), Pre_op_ach\save(), Pre_Op_Advanced\save(), Pre_op_ven\save(), Pre_op_ods\save(), Anc_Group_Operation\save(), Default_Menu\save(), Document_modele\Save(), Pre_op_fin\save(), Pre_operation\save_insert(), Acc_Ledger_History\set_ledger_type(), Document_Type\set_number(), Follow_Up\sql_security_filter(), Dossier\synchro_admin(), Acc_Ledger\test_me(), Document\transform2pdf(), Document_modele\update(), Acc_Ledger_Info\update(), Card_Property\update(), and Acc_Ledger\verify_ledger().

remove_divide_zero()

remove_divide_zero

(

$p_formula

)

When it is needed to eval a formula , this function prevent the divide by zero.

the formula is a math operation to evaluate like : 1.0+2.0/1 (...) , it is used in "report", it removes the operation "divide by 0 "

Parameters

string

$p_formula

string containing a operation to evaluate

See also

Impress::parse_formula

Definition at line 1408 of file ac_common.php.

{
    $test=noalyss_str_replace(" ","",$p_formula).";";
    $p_formula=preg_replace("![0-9]+\.*[0-9]*/0\.{0,1}0*(\+|-|\*|/|;){1}!","0$1",$test);
    $p_formula=trim($p_formula,';');
    return $p_formula;
}

References noalyss_str_replace().

Referenced by Impress\parse_formula().

Here is the call graph for this function:

sanitize_filename()

sanitize_filename

(

$filename

)

removed invalid character when computing a filename, the suffix is kept

Parameters

$filename

String filename to sanitize

Returns

string without offending char

Definition at line 1784 of file ac_common.php.

{
    // save the suffix
    $pos_prefix=strrpos($filename, ".");
    if ($pos_prefix==0)
    {
        $filename_suff=".pdf";
        $filename.=$filename_suff;
        $pos_prefix=strrpos($filename, ".");
    }
    else
        $filename_suff=substr($filename, $pos_prefix, strlen($filename));
 
    $filename=str_replace(array('/', '*', '<', '>', ';', ',', '\\', '.', ':', '(', ')', ' ', '[', ']'), "-", $filename);
 
    $filename_no=substr($filename, 0, $pos_prefix);
 
    $new_filename=strtolower($filename_no)."-".date("Ymd-Hi").$filename_suff;
    return $new_filename;
}

Referenced by Card_PDF\export().

set_language()

set_language

(

)

set the lang thanks the _SESSION['g_lang'] var.

Definition at line 754 of file ac_common.php.

{
    // desactivate local check
    if (defined("LOCALE")&&LOCALE==0)
    {
        return;
    }
    if (!isset($_SESSION[SESSION_KEY.'g_lang']))
    {
        return;
    }
 
    /*
     * If translation is not supported by current
     */
    if (!function_exists("bindtextdomain"))
    {
        return;
    }
 
    $dir = "";
    // set differently the language depending of the operating system
    if (what_os() == 1)
    {
        $dir = setlocale(LC_MESSAGES, $_SESSION[SESSION_KEY.'g_lang']);
        if ($dir == "")
        {
            $g_lang = 'fr_FR.utf8';
            $dir = setlocale(LC_MESSAGES, $g_lang);
           // echo '<span class="notice">' . $_SESSION[SESSION_KEY.'g_lang'] . ' domaine non supporté</h2>';
        }
        bindtextdomain('messages', NOALYSS_HOME.'/lang');
        textdomain('messages');
        bind_textdomain_codeset('messages', 'UTF8');
 
        return;
    }
    // for windows
    putenv('LANG=' . $_SESSION[SESSION_KEY.'g_lang']);
    $dir = setlocale(LC_ALL, $_SESSION[SESSION_KEY.'g_lang']);
    bindtextdomain('messages', '.\\lang');
    textdomain('messages');
    bind_textdomain_codeset('messages', 'UTF8');
}

Referenced by html_page_start(), and Noalyss\Mobile\page_start().

show_menu()

show_menu

(

$module

)

Show the submenus

Definition at line 1071 of file ac_common.php.

{
    if ($module == 0)return;
    static $level=0;
    global $g_user;
    $http=new HttpInput();
    $access_code=$http->request("ac");
    $cn = Dossier::connect();
    /**
     * Show the submenus
     */
    $amenu = $cn->get_array("
        select 
            pm_id,
            me_code,
            pm_id_dep,
            me_file,
            me_javascript,
            me_url,
            me_menu,
            me_description,
            me_description_etendue
            from profile_menu 
            join menu_ref using (me_code) 
            where pm_id_dep=$1 and p_id=$2
         order by p_order", array($module, $g_user->get_profile()));
    
    // There are submenuS, so show them
    if (!empty($amenu) && count($amenu) > 1)
    {
        $a_style_menu=array('topmenu','menu2','menu3');
        if ( $level > count($a_style_menu))
            $style_menu='menu3';
        else {
            $style_menu=$a_style_menu[$level];
        }
        require NOALYSS_TEMPLATE.'/menu.php';
          $level++;
           return;
    } elseif (count($amenu) == 1)
    {
        // there is only one submenu so we include the code or javascript 
        // or we show the submenu
        if ( trim($amenu[0]['me_url']??"") != "" ||
             trim ($amenu[0]['me_file']??"") != "" ||
             trim ($amenu[0]['me_javascript']??"") != "" )
        {
                echo '<div class="topmenu">';
                echo h2info(_($amenu[0]['me_menu']));
                echo '</div>';
                $module = $amenu[0]['pm_id'];
                display_menu($module);
                $level++;
                return;
        } else {
           $url=$access_code.'/'.$amenu[0]['me_code'];
           echo '<a href="do.php?gDossier='.Dossier::id().'&ac='.$url.'">';
           echo _($amenu[0]['me_menu']);
           echo '</a>';
           $level++;
           return;
        }
    }
    
    // !!! this point should never be reached 
    // There is no submenu or only one
    if (empty($amenu) || count($amenu) == 1)
    {
        display_menu($module);
                
    }
    $level++;
}

show_module()

show_module

(

$selected

)

Show the modules.

Parameters

int

$selected

module selected profile_menu.pm_id

Definition at line 932 of file ac_common.php.

{
    global $g_user;
    $cn = Dossier::connect();
    $amodule = $cn->get_array("select
        me_code,me_menu,me_url,me_javascript,p_order,me_type,me_description
        from v_all_menu
        where
        p_id=$1
        and p_type_display='M'
        order by p_order", array($g_user->get_profile()));
 
    if ($selected != -1)
    {
        $selected_module=$cn->get_value('select me_code from profile_menu where'
                . ' pm_id = $1 ', array($selected));
        require_once NOALYSS_TEMPLATE.'/module.php';
        $file = $cn->get_array("select me_file,me_parameter,me_javascript,me_type,me_description from v_all_menu
            where pm_id=$1 and p_id=$2", array($selected,$g_user->get_profile()));
        if ( count($file ) == 0 )
        {
                echo '</div>';
                echo '</div>';
                echo '<div class="content">';
                echo_warning(_("Module inexistant")."[ $selected ] ");
                echo '</div>';
                exit();
        }
        if ($file[0]['me_file'] != '')
        {
            if ($file[0]['me_parameter'] != "")
            {
                // if there are paramter put them in superglobal
                $array=compute_variable($file[0]['me_parameter']);
                put_global($array);
            }
 
                // if file is not a plugin, include the file, otherwise
                // include the plugin launcher
                if ($file[0]['me_type'] != 'PL')
                        {
                                require_once $file[0]['me_file'];
                        }
                        else
                        {
                                // nothing  : direct call to plugin
                        }
        }
        if ( $file[0]['me_javascript'] != '')
        {
                create_script($file[0]['me_javascript']);
        }
    }
}

ShowItem()

ShowItem	(		$p_array,
			$p_dir = 'V',
			$class = "nav-item",
			$class_ref = "nav-link",
			$default = "",
			$p_extra = "nav nav-pills nav-fill"
	)

store the string which print the content of p_array in a table used to display the menu

Parameters

$p_array	array like ( 0=>HREF reference, 1=>visible item (name),2=>Help(opt), 3=>selected (opt) 4=>javascript (normally a onclick event) (opt)
$p_dir	direction of the menu (H Horizontal V vertical)
$class	CSS for li tag
$class_ref	CSS for the A tag
$default	selected item
$p_extra	extra code for the table tag (CSS or javascript)

Definition at line 535 of file ac_common.php.

{
    $ret = '';
    // for comptability with old application  mtitle for anchor is replace by nav-link
    
    
    // direction Vertical
    if ($p_dir == 'V')
    { 
        $ret .= "<ul class=\"$p_extra \"  flex-row>";
    } else {
        $ret .= "<ul class=\"$p_extra \" >";
       
    }
    
    foreach ($p_array as $all => $href)
    {
        $javascript = (isset($href[4])) ? $href[4] : "";
        $title = "";
        $set = "XX";
        if (isset($href[2]))
        {
            $title=$href[2];
        }
        if (isset($href[3]))
        {
            $set=$href[3];
        }
 
        if ($set==$default)
        {
            $ret.='<li class="nav-item"><A class="'.$class_ref.' active'.'" HREF="'.$href[0].'" title="'.$title.'" '.$javascript.'>'.$href[1].'</A></li>';
        }
        else
        {
            $ret.='<li class="nav-item"><A class="'.$class_ref.'" HREF="'.$href[0].'" title="'.$title.'" '.$javascript.'>'.$href[1].'</A></li>';
        }
        
    }
 
    $ret.="</ul>";
    return $ret;
}

References $all, $href, $p_array, $ret, and $title.

Referenced by MenuAdmin().

shrink_date()

shrink_date

(

$p_date

)

shrink the date, make a date shorter for the printing

Parameters

$p_date

format DD.MM.YYYY

Returns

date in the format DDMMYY (size = 13 mm in arial 8)

Definition at line 826 of file ac_common.php.

{
    $date = noalyss_str_replace('.', '', $p_date);
    $str_date = substr($date, 0, 4) . substr($date, 6, 2);
    return $str_date;
}

smaller_date()

smaller_date

(

$p_date

)

shrink the date, make a date shorter for the printing

Parameters

$p_date

format DD.MM.YYYY

Returns

date in the format DD.MM.YY (size = 13 mm in arial 8)

Definition at line 837 of file ac_common.php.

{
    if (empty ($p_date)) return "";
    $str_date = substr($p_date, 0, 6) . substr($p_date, 8, 2);
    return $str_date;
}

Referenced by Print_Ledger_Misc\export().

span()

span	(		$p_string,
			$p_extra = ''
	)

Definition at line 43 of file ac_common.php.

{
    return '<span ' . $p_extra . '>' . $p_string . '</span>';
}

Referenced by Acc_Ledger_Purchase\confirm(), Acc_Ledger_Sale\confirm(), Anc_Print\display_form(), Operation_Exercice\display_total(), Document\generate(), Acc_Ledger\input(), Forecast_Item_MTable\input(), Inplace_Edit\input(), Profile_Menu\sub_menu(), and Acc_Ledger\warn_manual_receipt().

sql_filter_per()

sql_filter_per	(		$p_cn,
			$p_from,
			$p_to,
			$p_form = 'p_id',
			$p_field = 'jr_tech_per'
	)

Create the condition to filter on the j_tech_per thanks a from and to date.

Parameters

$p_cn	database conx
$p_from	start date (date)
$p_to	end date (date)
$p_form	if the p_from and p_to are date or p_id
$p_field	column name

Returns

a string containg the query

Definition at line 682 of file ac_common.php.

{
 
    if ($p_form != 'p_id' && $p_form != 'date')
    {
        echo_error(__FILE__, __LINE__, 'Mauvais parametres ');
        exit(-1);
    }
    $p_from=  sql_string($p_from);
    $p_to=  sql_string($p_to);
    $p_field=  sql_string($p_field);
    if ($p_form == 'p_id')
    {
        if ( isNUmber($p_from)==0 || isNUmber($p_to)==0){
            throw new Exception("SFP1"._("Nombre invalide")."\$p_from=$p_from \$p_to=$p_to");
        }
        // retrieve the date
        $pPeriode = new Periode($p_cn);
        $a_start = $pPeriode->get_date_limit($p_from);
        $a_end = $pPeriode->get_date_limit($p_to);
        if ($a_start==null||$a_end==null)
        {
            throw new Exception(__FILE__.__LINE__.sprintf(_('Attention periode 
                     non trouvee periode p_from= %s p_to_periode = %s'), $p_from, $p_to));
        }
 
 
        $p_from = $a_start['p_start'];
        $p_to = $a_end['p_end'];
    }else {
        if ( isDate($p_from)==NULL || isDate($p_to)==NULL){
            throw new Exception("SFP2"._("Date invalide")."\$p_from=$p_from \$p_to=$p_to");
        }
    }
    if ($p_from==$p_to)
    {
        $periode=" $p_field = (select p_id from parm_periode ".
                " where ".
                " p_start = to_date('$p_from','DD.MM.YYYY')) ";
    }
    else
    {
        $periode="$p_field in (select p_id from parm_periode ".
                " where p_start >= to_date('$p_from','DD.MM.YYYY') and p_end <= to_date('$p_to','DD.MM.YYYY')) ";
    }
    return $periode;
}

References $periode, $pPeriode, echo_error(), exit, isDate(), and sql_string().

Referenced by Impress\compute_periode(), Anc_Operation\get_balance(), Acc_Account_Ledger\get_row(), Fiche\get_row(), Acc_Ledger_History_Financial\get_row(), Acc_Ledger_History_Purchase\get_row(), Acc_Ledger_History_Sale\get_row(), Acc_Ledger_History_Generic\get_row(), Acc_Ledger_History_Generic\get_rowSimple(), Acc_Ledger\get_solde(), Impress\parse_formula(), Acc_Bilan\verify(), and Acc_Bilan\warning().

Here is the call graph for this function:

sql_string()

sql_string

(

$p_string

)

Fix the problem with the quote char for the database.

Parameters

$p_string

Returns

a string which won't let strange char for the database

Definition at line 511 of file ac_common.php.

{
    $p_string = trim($p_string??"");
    if (strlen($p_string) == 0)
        return null;
    $p_string = noalyss_str_replace("'", "''", $p_string);
    $p_string = noalyss_str_replace('\\', '\\\\', $p_string);
    return $p_string;
}

References noalyss_str_replace().

Referenced by Fiche_Def\Add(), Anc_Plan\add(), Acc_Ledger_Search\build_search_sql(), contact\build_sql(), Fiche\build_sql(), Card_Multiple\build_sql(), Card_Multiple\count_sql(), Follow_Up\create_query(), Stock\create_query_histo(), Follow_Up\filter_by_tag(), FormatString(), Pre_operation\get_operation(), Acc_Ledger_Fin\insert(), Acc_Ledger_Purchase\insert(), Acc_Ledger_Sale\insert(), Fiche\insert(), Acc_Ledger_Purchase\insert_no_deductible(), Acc_Parm_Code\save(), Fiche_Def\save_class_base(), Fiche_Def\SaveLabel(), HtmlInput\select_stock(), sql_filter_per(), Fiche\Summary(), Anc_Plan\update(), and Card_Property\update().

Here is the call graph for this function:

td()

td	(		$p_string = '',
			$p_extra = ''
	)

surround the string with td

Parameters

$p_string	string to surround by TD
$p_extra	extra info (class, style, javascript...)

Returns

string surrounded by td

Definition at line 83 of file ac_common.php.

{
    return '<td  ' . $p_extra . '>' . $p_string . '</td>';
}

Referenced by Acc_Ledger_Fin\confirm(), Acc_Ledger\confirm(), Acc_Ledger_Purchase\confirm(), Acc_Ledger_Sale\confirm(), Pre_Op_Advanced\display(), Fiche\Display(), Acc_Bilan\display_form(), Anc_Print\display_form(), Anc_GrandLivre\display_html(), Anc_Acc_List\display_html(), Anc_Balance_Double\display_html(), Anc_Balance_Simple\display_html(), Anc_Listing\display_html(), Anc_Table\display_html(), Operation_Exercice\display_row(), Follow_Up_Other_Concerned\display_row(), Additional_Tax\display_row(), Acc_Plan_MTable\display_row(), Forecast_Item_MTable\display_row(), Manage_Table_SQL\display_row(), Periode_Ledger_Table\display_row(), Fiche\display_row(), Acc_Report_MTable\display_row_custom(), Card_Attribut_MTable\display_row_custom(), Mobile_Device_MTable\display_row_custom(), Manage_Table_SQL\display_row_custom(), Periode\display_row_global(), display_security_fieldset(), Acc_Ledger_History_Generic\export_accounting_html(), Print_Operation_Currency\export_html(), Acc_Ledger_History_Generic\export_oneline_html(), Anc_Group_Operation\form(), Document_modele\form(), Periode\form_periode_add(), Anc_Operation\html_table(), Acc_Account_Ledger\HtmlTable(), Fiche\HtmlTable(), Acc_Ledger\input(), Acc_Ledger_Purchase\input(), Card_Property\input(), IAncCard\input(), ICard\input(), IPoste\input(), ITva_Popup\input(), Template_Card_Category\input(), Mobile_Device_MTable\input_custom(), Acc_Ledger_Fin\insert(), Acc_Ledger_Search\list_operation(), Acc_Ledger_Search\list_operation_to_reconcile(), Follow_Up\myList(), Document_modele\myList(), Html_Table\sql2table(), Fiche\Summary(), Acc_Balance\summary_display(), and Acc_Bilan\verify().

th()

th	(		$p_string,
			$p_extra = '',
			$raw = ''
	)

Definition at line 58 of file ac_common.php.

{
    return '<th  ' . $p_extra . '>' . h($p_string).$raw . '</th>';
}

References h().

Referenced by Anc_GrandLivre\display_html(), Anc_Balance_Double\display_html(), Anc_Listing\display_html(), Anc_Table\display_html(), Periode\display_periode_global(), Operation_Exercice\display_result(), Periode_Ledger_Table\display_table(), Manage_Table_SQL\display_table_header(), Print_Operation_Currency\export_html(), Acc_Ledger_History_Generic\export_oneline_html(), Anc_Group_Operation\form(), Anc_Operation\html_table(), Acc_Account_Ledger\HtmlTable(), Fiche\HtmlTable(), Acc_Ledger_Fin\insert(), Acc_Ledger_Search\list_operation(), Acc_Ledger_Search\list_operation_to_reconcile(), Follow_Up\myList(), Document_modele\myList(), and Acc_Ledger_Search\select_ledger().

Here is the call graph for this function:

tr()

tr	(		$p_string,
			$p_extra = ''
	)

Definition at line 88 of file ac_common.php.

{
    return '<tr  ' . $p_extra . '>' . $p_string . '</tr>';
}

Referenced by Acc_Ledger_Fin\confirm(), Acc_Ledger\confirm(), Acc_Ledger_Purchase\confirm(), Acc_Ledger_Sale\confirm(), Pre_Op_Advanced\display(), Fiche\Display(), Anc_Print\display_form(), Anc_Operation\display_form_plan(), Follow_Up_Other_Concerned\display_row(), display_security_fieldset(), Print_Operation_Currency\export_html(), Periode\form_periode_add(), Acc_Ledger\input(), Template_Card_Category\input(), Acc_Ledger_Fin\insert(), and Acc_Bilan\verify().

transform_sql_filter_per()

transform_sql_filter_per

(

$p_sql

)

transform the SQL for ANALYTIC table operation_analytique

See also

sql_filter_per

Parameters

string

$p_sql

Definition at line 660 of file ac_common.php.

{
    $result=noalyss_str_replace("j_tech_per in (select p_id from parm_periode  where","",$p_sql);
    $result=noalyss_str_replace("jr_tech_per in (select p_id from parm_periode  where","",$result);
    $result=noalyss_str_replace("j_tech_per = (select p_id from parm_periode  where  p_start "," oa_date ",$result);
    $result=noalyss_str_replace("p_start >= to_date","oa_date >= to_date",$result);
    $result=noalyss_str_replace("p_end <= to_date","oa_date <= to_date",$result);
 
    $result="( $result";
    return $result;
}

References $result, and noalyss_str_replace().

Here is the call graph for this function:

what_os()

what_os

(

)

try to determine on what os you are running the pĥpcompte server

Returns

0 it is a windows 1 it is a Unix like

Definition at line 806 of file ac_common.php.

{
    $inc_path = get_include_path();
 
    if (strpos($inc_path, ";") != 0)
    {
        $os = 0;   /* $os is 0 for windoz */
    }
    else
    {
        $os = 1;   /* $os is 1 for unix */
    }
    return $os;
}