Re: Find method with multiple tables

Code, code, code, code, code. Show what you have tried. 

And saying something is urgent (has everything you posted been urgent?) won't help in most cases.

-- 

Mike Griffin

Sent with Sparrow

On Sunday 16 September 2012 at 05:09, Mr. Manager wrote:

Dear All,

I have problem with using find method to retrieve field from many table.

I have table as the following:

items(id, no, name, price, discount, sample, outside)
invoices(id, no, name, patient_id, doctor_id, source_id, discount, paying_date, request_date, exchange_rate, bad)
invoice_details(id, invoice_id, item_id, price)
sources(id, no, name, phone, address)

The condition of find is about the date with $start_date, $end_date that should be filter in table invoices and source_id.

The preferable result
No                Item Name              Number_of_Item                  Price                 Total_Price


This is urgent and I hope that anyone can help me find the solution.

Thanks a lot in advance.
Dara,

--
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.
 
 

--
Like Us on FacekBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.