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