$result_deposit[$k]['amt'] = -$plusminus_flag * $v['amt']; } $result = $result_minus; $result = array_merge($result, $result_deposit); foreach ($result as $valid_row) { echo '<tr><td>' . substr($valid_row['view'], 7, 4) . '</td><td>' . substr($valid_row['cat'], 0, 4) . '</td><td>' . substr($valid_row['memo'], 0, 12) . '</td><td>$' . number_format($valid_row['amt'], 2) . '</td><td>' . substr($valid_row['name'], 0, 12) . '</td></tr>'; } echo '</table>'; } if ($details_type == 'c') { // collect echo '<br><a href="acct_detail&startdate=' . $startdate . '&office=' . $office . '" target="_acctdetail">Collections</a><br><table border="1" class="fixed_table">'; $sql = "\n SELECT\n patient_id,\n provider_id,\n ABS(amount) AS metric\n FROM \n ledger\n WHERE \n office_id IN (:OFFICES)\n AND \n dayt BETWEEN ':STARTDATE' AND ':ENDDATE'\n AND\n entry_type = 3 -- types: 2 = prodadj, 1 = coladj, 3= collect\n ORDER BY \n amount DESC\n "; $binds = array('OFFICES' => $_g->offices[$office]['id'], 'STARTDATE' => $startdate, 'ENDDATE' => $startdate); $result = $_g->select($sql, $binds, 'alex'); $_g->get_providers(); foreach ($result as $valid_row) { echo '<tr><td><a href="patients&patid=' . $valid_row['patient_id'] . '&off=' . $office . '" target="_patdetail">' . $valid_row['patient_id'] . '</a></td><td>$' . number_format(-$valid_row['metric'], 2) . '</td><td>' . $_g->providers2rsc[$valid_row['provider_id']] . '</td></tr>'; } echo '</table>'; } if ($details_type == 'a') { // adjs echo '<br>Adjustments<br><table border="1" class="fixed_table">'; $sql = "\n SELECT\n leg.patient_id,\n CONCAT(first_name, ' ', last_name) as patname,\n leg.amount AS metric\n FROM \n ledger leg LEFT JOIN patients pt ON pt.office_id = leg.office_id AND pt.patient_id = leg.patient_id\n WHERE \n leg.office_id IN (:OFFICES)\n AND \n leg.dayt BETWEEN ':STARTDATE' AND ':ENDDATE'\n AND\n leg.entry_type = 1 -- types: 2 = prodadj, 1 = coladj, 3= collect\n ORDER BY \n amount DESC\n "; $binds = array('OFFICES' => $_g->offices[$office]['id'], 'STARTDATE' => $startdate, 'ENDDATE' => $startdate); $result = $_g->select($sql, $binds, 'alex'); $_g->get_providers(); foreach ($result as $valid_row) { echo '<tr><td><a href="patients&patid=' . $valid_row['patient_id'] . '&off=' . $office . '" target="_patdetail">' . $valid_row['patient_id'] . '</a></td><td>$' . number_format($valid_row['metric'], 2) . '</td><td>'; echo ' </td><td>' . $valid_row['patname'] . '</td></tr>';