Re: Find method with multiple tables

2012-09-16 Thread Ly Dara 
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
lyda...@gmail.com or lydara9.

Sincerely Yours,
Dara,

On Sun, Sep 16, 2012 at 1:04 PM, Mike Griffin  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
> NoItem 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+unsubscr...@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+unsubscr...@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+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.

Re: Find method with multiple tables

2012-09-16 Thread Mike Griffin 
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 (http://www.sparrowmailapp.com/?sig)


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
> NoItem 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 
> (mailto:cake-php@googlegroups.com).
> To unsubscribe from this group, send email to 
> cake-php+unsubscr...@googlegroups.com 
> (mailto:cake-php+unsubscr...@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+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.

Find method with multiple tables

2012-09-15 Thread Mr. Manager 
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
NoItem 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+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.