Re: Find method with multiple tables

Dear All,

Now I can solve it by using query function instead of find and use my sql query language instead of cakephp language syntax.

However, I will post my code later because I still want to find out to use cakephp syntax with complex find condition.

Thanks a lot for your taking time to help.

I think that it's more easy to contact me on skype my email is lydara9@gmail.com or lydara9.

Sincerely Yours,
Dara,

On Sun, Sep 16, 2012 at 1:04 PM, Mike Griffin <griffinm@gmail.com> wrote:

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.
 
 

--
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.