function print_audit_trail() { global $path_to_root, $systypes_array; $from = $_POST['PARAM_0']; $to = $_POST['PARAM_1']; $systype = $_POST['PARAM_2']; $user = $_POST['PARAM_3']; $comments = $_POST['PARAM_4']; $orientation = $_POST['PARAM_5']; $destination = $_POST['PARAM_6']; if ($destination) { include_once $path_to_root . "/reporting/includes/excel_report.inc"; } else { include_once $path_to_root . "/reporting/includes/pdf_report.inc"; } $orientation = $orientation ? 'L' : 'P'; $dec = user_price_dec(); $cols = array(0, 60, 120, 180, 240, 340, 400, 460, 520); $headers = array(_('Date'), _('Time'), _('User'), _('Trans Date'), _('Type'), _('#'), _('Action'), _('Amount')); $aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'left', 'right'); $usr = get_user($user); $user_id = $usr['user_id']; $params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Type'), 'from' => $systype != -1 ? $systypes_array[$systype] : _('All'), 'to' => ''), 3 => array('text' => _('User'), 'from' => $user != -1 ? $user_id : _('All'), 'to' => '')); $rep = new FrontReport(_('Audit Trail'), "AuditTrail", user_pagesize(), 9, $orientation); if ($orientation == 'L') { recalculate_cols($cols); } $rep->Font(); $rep->Info($params, $cols, $headers, $aligns); $rep->NewPage(); $trans = getTransactions($from, $to, $systype, $user); while ($myrow = db_fetch($trans)) { $rep->TextCol(0, 1, sql2date(date("Y-m-d", $myrow['unix_stamp']))); if (user_date_format() == 0) { $rep->TextCol(1, 2, date("h:i:s a", $myrow['unix_stamp'])); } else { $rep->TextCol(1, 2, date("H:i:s", $myrow['unix_stamp'])); } $rep->TextCol(2, 3, $myrow['user_id']); $rep->TextCol(3, 4, sql2date($myrow['gl_date'])); $rep->TextCol(4, 5, $systypes_array[$myrow['type']]); $rep->TextCol(5, 6, $myrow['trans_no']); if ($myrow['gl_seq'] == null) { $action = _('Changed'); } else { $action = _('Closed'); } $rep->TextCol(6, 7, $action); if ($myrow['amount'] != null) { $rep->AmountCol(7, 8, $myrow['amount'], $dec); } $rep->NewLine(1, 2); } $rep->Line($rep->row + 4); $rep->End(); }
display_warning(_("Display settings have been updated. Keep in mind that changed settings are restored on every login in demo mode.")); } else { display_notification_centered(_("Display settings have been updated.")); } } } start_form(); start_outer_table(TABLESTYLE2); table_section(1); table_section_title(_("Decimal Places")); number_list_row(_("Prices/Amounts:"), 'prices_dec', user_price_dec(), 0, 10); number_list_row(_("Quantities:"), 'qty_dec', user_qty_dec(), 0, 10); number_list_row(_("Exchange Rates:"), 'rates_dec', user_exrate_dec(), 0, 10); number_list_row(_("Percentages:"), 'percent_dec', user_percent_dec(), 0, 10); table_section_title(_("Dateformat and Separators")); dateformats_list_row(_("Dateformat:"), "date_format", user_date_format()); dateseps_list_row(_("Date Separator:"), "date_sep", user_date_sep()); /* The array $dateseps is set up in config.php for modifications possible separators can be added by modifying the array definition by editing that file */ thoseps_list_row(_("Thousand Separator:"), "tho_sep", user_tho_sep()); /* The array $thoseps is set up in config.php for modifications possible separators can be added by modifying the array definition by editing that file */ decseps_list_row(_("Decimal Separator:"), "dec_sep", user_dec_sep()); /* The array $decseps is set up in config.php for modifications possible separators can be added by modifying the array definition by editing that file */ if (!isset($_POST['language'])) { $_POST['language'] = $_SESSION['language']->code; } table_section_title(_("Language")); languages_list_row(_("Language:"), 'language', $_POST['language']); table_section(2);
function date_cells($label, $name, $title = null, $check = null, $inc_days = 0, $inc_months = 0, $inc_years = 0, $params = null, $submit_on_change = false) { global $use_date_picker, $path_to_root, $Ajax; if (!isset($_POST[$name]) || $_POST[$name] == "") { if ($inc_years == 1001) { $_POST[$name] = null; } else { $dd = Today(); if ($inc_days != 0) { $dd = add_days($dd, $inc_days); } if ($inc_months != 0) { $dd = add_months($dd, $inc_months); } if ($inc_years != 0) { $dd = add_years($dd, $inc_years); } $_POST[$name] = $dd; } } if ($use_date_picker) { $calc_image = file_exists("{$path_to_root}/themes/" . user_theme() . "/images/cal.gif") ? "{$path_to_root}/themes/" . user_theme() . "/images/cal.gif" : "{$path_to_root}/themes/default/images/cal.gif"; $post_label = "<a tabindex='-1' href=\"javascript:date_picker(document.getElementsByName('{$name}')[0]);\">" . "\t<img src='{$calc_image}' width='15' height='15' border='0' alt='" . _('Click Here to Pick up the date') . "'></a>\n"; } else { $post_label = ""; } $class = $submit_on_change ? 'date active form-control' : 'date form-control'; $aspect = $check ? 'aspect="cdate"' : ''; if ($check && get_post($name) != Today()) { $aspect .= ' style="color:#FF0000"'; } default_focus($name); $size = user_date_format() > 3 ? 11 : 10; $controlAsString = "<div class=\"input-group\">" . "<input type=\"text\" name=\"{$name}\" class=\"{$class}\" {$aspect} size=\"{$size}\" maxlength=\"12\" value=\"" . $_POST[$name] . "\"" . ($title ? " title='{$title}'" : '') . " > " . "<span class=\"input-group-addon\">{$post_label}</span>" . "</div>"; View::get()->addControl(View::controlFromRenderedString(View::CONTROL_DATE, $label, $controlAsString)); // CONTROL_DATE? CP 2014-11 $Ajax->addUpdate($name, $name, $_POST[$name]); }