<?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 ";
