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