Witam
Proszę o pomoc - w poniższej funkcji potrzebuję wstawić warunek gdzie:
WHERE cash.customerid = ? AND cash.time <= aktualna data(UNIX)
function GetCustomerBalanceListUserpanel($id, $totime = NULL, $direction = 'ASC') {
($direction == 'ASC' || $direction == 'asc') ? $direction == 'ASC' : $direction == 'DESC';
$saldolist = array();
if ($tslist = $this->DB->GetAll('SELECT cash.id AS id, time, cash.type AS type,
cash.value AS value, taxes.label AS tax, cash.customerid AS customerid,
comment, docid, users.name AS username,
documents.type AS doctype, documents.closed AS closed ,
documents.number AS docnumber, documents.cdate AS docdate,
numberplans.template AS doctemplate, documents.extnumber AS docextnumber,
documents.fullnumber, documents.paytime
FROM cash
LEFT JOIN users ON users.id = cash.userid
LEFT JOIN documents ON documents.id = docid
LEFT JOIN taxes ON cash.taxid = taxes.id
LEFT JOIN numberplans ON (numberplans.id = documents.numberplanid)
WHERE cash.customerid = ? AND cash.time <= '
. ($totime ? ' AND time <= ' . intval($totime) : '')
. ' ORDER BY time ' . $direction, array($id)))
{
$saldolist['balance'] = 0;
$saldolist['total'] = 0;
$i = 0;
foreach ($tslist as $row) {
// old format wrapper
foreach ($row as $column => $value)
$saldolist[$column][$i] = $value;
$saldolist['after'][$i] = round($saldolist['balance'] + $row['value'], 2);
$saldolist['balance'] += $row['value'];
$saldolist['date'][$i] = date('Y/m/d', $row['time']);
$saldolist['pdate'][$i] = $row['time'] + ($row['paytime'] * 86400);
$i++;
}
$saldolist['total'] = sizeof($tslist);
}
$saldolist['customerid'] = $id;
return $saldolist;
}
.................. pozdrawiam
MB