mysql to pdf???

[Meyer]

Hi there

I am trying to create invoice.
Below is the query where i inly want invoice to show where curmonth -3
The query works 100% in mysql, but when i put the code below in i receive all invoices. When i change the operator to '>' i get nothing returned. Please help.

$where = array(
'lhs_field' => '!invoice.date_entered',

'rhs_value' => 'YEAR(date_entered) = YEAR(CURDATE())
AND MONTH(date_entered) = MONTH(CURDATE())-3',

'operator' => '=',
);

[andopes]

Inside which file you are trying to implement such code?

Cheers

[Meyer]

hi Andopes

PDFStatement.php in accounts module.

-------------

$last_currency = 0;

$single_currency = true;

$balance = $balance_usdollar = 0;

$this->focus->load_relationship('invoice');

// Return invoices
$where = array(
'lhs_field' => '!invoice.cancelled AND invoice.amount_due ',
'rhs_value' => '0',
'operator' => '!=',
);


$where = array(
'lhs_field' => '!invoice.date_entered',
'rhs_value' => '!CURDATE()-60',
'operator' => '=',
);


$invoices = $this->focus->invoice->getBeans(new Invoice, array(), 0, -1, 0, $where
);

$this->moveY('20pt');
// Currency Start
$currency =& new Currency;
$currency->retrieve(-99);
$symbol = $default_symbol = $currency->getPdfCurrencySymbol();
$currency_id = $default_currency_id = $currency->id;
$orig_lm = $this->lMargin;