2 /**********************************************************************
3 Copyright (C) FrontAccounting, LLC.
4 Released under the terms of the GNU General Public License, GPL,
5 as published by the Free Software Foundation, either version 3
6 of the License, or (at your option) any later version.
7 This program is distributed in the hope that it will be useful,
8 but WITHOUT ANY WARRANTY; without even the implied warranty of
9 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
10 See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
11 ***********************************************************************/
12 include_once($path_to_root . "/includes/prefs/userprefs.inc");
14 //--------------------------------------------------------------------------
27 var $role_set = false;
34 function current_user()
38 $this->loginname = $this->username = $this->name = "";
39 $this->company = isset($def_coy)? $def_coy : 0;
40 $this->logged = false;
42 $this->prefs = new user_prefs();
50 function set_company($company)
52 $this->company = $company;
55 function login($company, $loginname, $password)
57 global $security_areas, $security_groups, $security_headings, $path_to_root;
59 $this->set_company($company);
60 $this->logged = false;
62 $Auth_Result = get_user_for_login($loginname, $password);
64 if (db_num_rows($Auth_Result) > 0)
66 $myrow = db_fetch($Auth_Result);
67 $this->old_db = isset($myrow["full_access"]);
68 if (! @$myrow["inactive"]) {
71 // db was not yet upgraded after source update to v.2.2
72 // give enough access for admin user to continue upgrade
73 if (!isset($security_groups) || !isset($security_headings)) {
74 echo "<center><br><br><font size='5' color='red'><b>";
75 echo _('Before software upgrade you have to include old $security_groups and $security_headings arrays from old config.php file to the new one.');
76 echo '<br>'."<a href=$path_to_root/index.php>"._("Back")."</a>";
77 echo "</b></font><br><br></center>";
80 $this->access = $myrow["full_access"];
81 if (in_array(20, $security_groups[$this->access]))
82 // temporary access for admin users
83 $this->role_set[] = $security_areas['SA_SOFTWAREUPGRADE'][0];
85 echo "<center><br><br><font size='5' color='red'><b>";
86 echo _('System is available for site admin only until full database upgrade');
87 echo "</b></font><br><br></center>";
91 $this->role_set = array();
92 $this->access = $myrow["role_id"];
93 // store area codes available for current user role
94 $role = get_security_role($this->access);
97 foreach( $role['areas'] as $code )
98 // filter only area codes for enabled security sections
99 if (in_array($code&~0xff, $role['sections']))
100 $this->role_set[] = $code;
102 $this->name = $myrow["real_name"];
103 $this->pos = $myrow["pos"];
104 $this->loginname = $loginname;
105 $this->username = $this->loginname;
106 $this->prefs = new user_prefs($myrow);
107 $this->user = @$myrow["id"];
108 update_user_visitdate($this->username);
109 $this->logged = true;
110 $this->last_act = time();
111 $this->timeout = session_timeout();
114 return $this->logged;
117 function check_user_access()
119 global $security_groups;
121 // notification after upgrade from pre-2.2 version
122 return isset($security_groups) && is_array(@$security_groups[$this->access]);
124 return !isset($security_groups) && is_array($this->role_set);
127 function can_access($page_level)
129 global $security_groups, $security_areas;
130 if (isset($security_groups)) {
131 return $this->company == 0 &&
132 in_array(20, $security_groups[$this->access]);
135 if ($page_level === 'SA_OPEN')
137 if ($page_level === 'SA_DENIED' || $page_level === '')
140 $code = $security_areas[$page_level][0];
142 // only first registered company has site admin privileges
143 return $code && in_array($code, $this->role_set)
144 && ($this->company == 0 || (($code&~0xff) != SS_SADMIN));
147 function can_access_page($page_level)
149 return $this->can_access($page_level);
152 function get_db_connection($id=-1)
154 global $db_connections;
156 $connection = $db_connections[$id == -1 ? $this->company : $id];
158 //print_r($connection);
160 $db = mysql_connect($connection["host"] ,
161 $connection["dbuser"], $connection["dbpassword"]);
162 mysql_select_db($connection["dbname"],$db);
164 if (!defined('TB_PREF'))
165 define('TB_PREF', $connection["tbpref"]);
170 function update_prefs($prefs)
172 global $allow_demo_mode;
174 if(!$allow_demo_mode) {
175 update_user_prefs($this->user, $prefs);
178 $this->prefs = new user_prefs($prefs);
182 //--------------------------------------------------------------------------
184 function round2($number, $decimals=0)
186 $delta = ($number < 0 ? -.000001 : .000001);
187 return round($number+$delta, $decimals);
190 function number_format2($number, $decimals=0)
192 global $thoseps, $decseps;
193 $tsep = $thoseps[$_SESSION["wa_current_user"]->prefs->tho_sep()];
194 $dsep = $decseps[$_SESSION["wa_current_user"]->prefs->dec_sep()];
195 //return number_format($number, $decimals, $dsep, $tsep);
196 $delta = ($number < 0 ? -.000001 : .000001);
197 return number_format($number+$delta, $decimals, $dsep, $tsep);
202 function fallback_mode() {
203 return $_SESSION["wa_current_user"]->ui_mode==0;
206 function price_format($number) {
207 return number_format2($number,
208 $_SESSION["wa_current_user"]->prefs->price_dec());
211 function price_decimal_format($number, &$dec)
213 $dec = user_price_dec();
214 $str = strval($number);
215 $pos = strpos($str, '.');
218 $len = strlen(substr($str, $pos + 1));
222 return number_format2($number, $dec);
224 // function money_format doesn't exist in OS Win.
225 if (!function_exists('money_format'))
227 function money_format($format, $number)
229 return price_format($number);
233 // 2008-06-15. Added extra parameter $stock_id and reference for $dec
234 //--------------------------------------------------------------------
235 function qty_format($number, $stock_id=null, &$dec) {
236 $dec = get_qty_dec($stock_id);
237 return number_format2($number, $dec);
240 function get_qty_dec($stock_id=null)
242 global $path_to_root;
243 include_once($path_to_root."/inventory/includes/db/items_units_db.inc");
244 if ($stock_id != null)
245 $dec = get_unit_dec($stock_id);
246 if ($stock_id == null || $dec == -1 || $dec == null)
247 $dec = $_SESSION["wa_current_user"]->prefs->qty_dec();
250 //-------------------------------------------------------------------
251 function exrate_format($number) {
252 return number_format2($number,
253 $_SESSION["wa_current_user"]->prefs->exrate_dec());
256 function percent_format($number) {
257 return number_format2($number,
258 $_SESSION["wa_current_user"]->prefs->percent_dec());
261 function user_numeric($input) {
262 global $decseps, $thoseps;
265 $sep = $thoseps[user_tho_sep()];
267 $num = str_replace( $sep, '', $num);
269 $sep = $decseps[user_dec_sep()];
271 $num = str_replace( $sep, '.', $num);
273 if (!is_numeric($num))
276 if ($num == (int)$num)
282 function user_company()
284 return $_SESSION["wa_current_user"]->company;
289 return $_SESSION["wa_current_user"]->pos;
292 function user_language()
294 return $_SESSION["wa_current_user"]->prefs->language();
297 function user_qty_dec()
299 return $_SESSION["wa_current_user"]->prefs->qty_dec();
302 function user_price_dec()
304 return $_SESSION["wa_current_user"]->prefs->price_dec();
307 function user_exrate_dec()
309 return $_SESSION["wa_current_user"]->prefs->exrate_dec();
312 function user_percent_dec()
314 return $_SESSION["wa_current_user"]->prefs->percent_dec();
317 function user_show_gl_info()
319 return $_SESSION["wa_current_user"]->prefs->show_gl_info();
322 function user_show_codes()
324 return $_SESSION["wa_current_user"]->prefs->show_codes();
327 function user_date_format()
329 return $_SESSION["wa_current_user"]->prefs->date_format();
332 function user_date_display()
334 return $_SESSION["wa_current_user"]->prefs->date_display();
337 function user_date_sep()
339 return $_SESSION["wa_current_user"]->prefs->date_sep();
342 function user_tho_sep()
344 return $_SESSION["wa_current_user"]->prefs->tho_sep();
347 function user_dec_sep()
349 return $_SESSION["wa_current_user"]->prefs->dec_sep();
352 function user_theme()
354 return $_SESSION["wa_current_user"]->prefs->get_theme();
357 function user_pagesize()
359 return $_SESSION["wa_current_user"]->prefs->get_pagesize();
362 function user_hints()
364 return $_SESSION["wa_current_user"]->prefs->show_hints();
367 function user_print_profile()
369 return $_SESSION["wa_current_user"]->prefs->print_profile();
372 function user_rep_popup()
374 return $_SESSION["wa_current_user"]->prefs->rep_popup();
377 function user_query_size()
379 return $_SESSION["wa_current_user"]->prefs->query_size();
382 function user_graphic_links()
384 return $_SESSION["wa_current_user"]->prefs->graphic_links();
387 function sticky_doc_date()
389 return $_SESSION["wa_current_user"]->prefs->sticky_date();
392 function user_startup_tab()
394 return $_SESSION["wa_current_user"]->prefs->start_up_tab();
397 function set_user_prefs($prefs)
399 $_SESSION["wa_current_user"]->update_prefs($prefs);
402 function add_user_js_data() {
403 global $path_to_root, $thoseps, $decseps, $date_system, $dateseps;
405 $ts = $thoseps[user_tho_sep()];
406 $ds = $decseps[user_dec_sep()];
410 . "theme: '". $path_to_root . '/themes/'. user_theme().'/'."',\n"
411 . "loadtxt: '"._('Requesting data...')."',\n"
412 . "date: '".Today()."',\n" // server date
413 . "datesys: ".$date_system.",\n"
414 . "datefmt: ".user_date_format().",\n"
415 . "datesep: '".$dateseps[user_date_sep()]."',\n"
418 . "pdec : " . user_price_dec() . "}\n";
423 //--------------------------------------------------------------------------
425 function session_timeout()
427 $tout = @get_company_pref('login_tout'); // mask warning for db ver. 2.2
428 return $tout ? $tout : ini_get('session.gc_maxlifetime');
431 //-----------------------------------------------------------------------------
432 // Inserts $elements into $array at position $index.
433 // $elements is list of any objects
435 function array_insert(&$array, $index, $elements)
437 if (!is_array($elements)) $elements = array($elements);
439 $head = array_splice($array, 0, $index);
440 $array = array_merge($head, $elements, $array);
443 function array_remove(&$array, $index, $len=1)
445 array_splice($array, $index, $len);
448 function array_substitute(&$array, $index, $len, $elements)
450 array_splice($array, $index, $len);
451 array_insert($array, $index, $elements);
454 function array_append(&$array, $elements)
456 foreach($elements as $key => $el) {
464 // Search $needle in $haystack or in $haystack[][$valuekey]
465 // returns $needle found or null.
467 function array_search_value($needle, $haystack, $valuekey=null)
469 foreach($haystack as $key => $value) {
470 $val = isset($valuekey) ? $value[$valuekey] : $value;
471 if ($needle == $val){
478 // Search $needle in $haystack or in $haystack[][$valuekey]
479 // returns array of keys of $haystack elements found
481 function array_search_keys($needle, $haystack, $valuekey=null)
485 foreach($haystack as $key => $value) {
486 $val = isset($valuekey) ? $value[$valuekey] : $value;
487 if ($needle == $val){
494 // Find first (single) $needle in $haystack or in $haystack[][$valuekey]
495 // returns $haystack element found or null
497 function array_search_key($needle, $haystack, $valuekey=null)
499 $keys = array_search_keys($needle, $haystack, $valuekey);