<?php
include_once '../functions.php';
checklogin();
$conn = opendb();
$id = sanitise('id');
if ($loggedin == 1) {
$query = "SELECT * FROM payments LEFT JOIN accounts ON payments.AccountID=accounts.AccountID WHERE payments.UserID='{$user}' AND PaymentID='{$id}'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result);
$amount = $row['PaymentAmount'];
$amount = displayamount($amount, $user, 1);
echo "<td>" . date("d/m/y", $row['Timestamp']) . "</td>\n\t\t\t <td>" . stripslashes($row['PaymentName']) . "</td>\n\t\t\t <td>" . stripslashes($row['PaymentDesc']) . "</td>\n\t\t\t <td class='align_right'>" . $amount . "</td>\n\t\t\t <td>" . $row['PaymentType'] . "</td>\n\t\t\t <td>" . stripslashes($row['AccountName']) . "</td>\n\t\t\t <td><input type='checkbox' id='reconciled' onclick=\"reconcile(this, " . $row['PaymentID'] . ")\"";
if ($row['Reconciled'] == 1) {
echo "checked='checked'";
}
echo "></td>\n\t\t\t <td>\n\t\t\t\t <button onclick=\"confirmDelete('" . $row['PaymentID'] . "')\">Delete</button>\n\t\t\t\t <button onclick=\"editForm('" . $row['PaymentID'] . "')\">Edit</button>\n\t\t\t </td>";
} else {
loginform();
}
<?php
include_once '../functions.php';
checklogin();
$conn = opendb();
$endtime = time();
$query = "SELECT * FROM payments WHERE UserID='{$user}' AND Deleted='0' AND Timestamp<'{$endtime}'";
$result = mysql_query($query) or die(mysql_error());
$total = 0;
while ($row = mysql_fetch_assoc($result)) {
$total = $total + $row['PaymentAmount'];
}
$total = displayamount($total, $user, 1);
echo $total;
function updatereconcile($user, $account, $value)
{
$account = checkAccount($user, $account, 0);
$query = "UPDATE accounts SET ReconciledTotal='{$value}' WHERE AccountID='{$account}'";
mysql_query($query) or die(mysql_error());
if ($account != 0) {
$account = "AccountID='{$account}' AND ";
} else {
$account = NULL;
}
$query = "SELECT * FROM payments WHERE " . $account . " UserID='{$user}' AND Reconciled='1'";
$result = mysql_query($query) or die(mysql_error());
$recbal = 0;
while ($row = mysql_fetch_assoc($result)) {
$recbal = $recbal + $row['PaymentAmount'];
}
$diff = $value - $recbal;
$recbal = displayamount($recbal, $user);
$diff = displayamount($diff, $user);
echo "Reconciled Balance: " . $recbal . " Difference: " . $diff;
}
