<?php //debugbreak(); error_reporting(0); // E_ALL); ini_set('display_errors', 0); require "../include/class_funcs.php"; // all static functions require "../include/class_alex_data.php"; require "../include/class_alex_dental_globals.php"; session_start(); $_g = new alex_dental_globals(); $pagetitle = ''; ?> <!DOCTYPE html> <html> <head> <title><?php echo $pagetitle; ?> | <?php echo $_g->mailname; ?> </title><meta name="ROBOTS" content="NOINDEX, NOFOLLOW" /> <meta http-equiv="Content-Language" content="en-us" /> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link rel="shortcut icon" type="image/x-icon" href="px/favicon.png" /><link rel="icon" type="image/png" href="px/favicon.png" /> <?php if ($_g->devmode) { echo '<link rel="stylesheet" href="css/di.css" type="text/css" />';
<?php require "../include/oldphpfuncs.php"; require "../include/class_funcs.php"; // all static functions require "../include/class_alex_data.php"; require "../include/class_alex_dental_globals.php"; session_start(); $_g = new alex_dental_globals(); $startdate = $_g->get('d', $_g->today); $uid = $_g->sget('uid', 0); $home_office = $_g->sget('home_office', 'fh'); $access_level = $_g->sget('access_level', 9); $_g->sys_admin = $_g->sget('sys_admin', 0); $office = strtolower($_g->get('o', $home_office)); $qb_class = $_g->qb_classes[$office]; $details_type = $_g->get('t', ''); $details = array(); if ($_g->sys_admin == 1 || $uid) { echo '<strong>' . $startdate . '</strong>'; if ($details_type == 'q') { // qb echo '<br>Quickbooks<br><table border="1" class="fixed_table">'; $srch_cat = " cat IN ( 'Fee for Service Income', 'Returned Checks', 'Refunds', 'Misc Income') "; $metric = 0.0; $plusminus_flag = -1; // simliar to globals, public function qb_details_ary($qb_class, $srch_cat, $startdate, $enddate, $plusminus_flag, $details = 0) {, but not grouped - need details $qb_tables_minus = 'alexqb_bill'; $qb_deposit_minus = 'alexqb_deposit'; $result = array(); $sql = "\n SELECT\n amt,\n cat,\n memo,\n name,\n view\n FROM\n acct_transactions\n WHERE\n view IN (':QBTABLES')\n AND\n dayt BETWEEN ':STARTDATE' AND ':ENDDATE'\n AND\n class = ':QB_CLASS'\n AND\n {$srch_cat}\n ORDER BY amt\n ";