Why is CakePHP duplicating my queries
The jobs are now being attributed towards the Vehicles in an virtually arbitrary way (my memory of Cake is that this may occur); the nature within the HABTM simply call attaches the Job/s to each with the 15 Vans. This is apparently the current system from my viewpoint;
Get all vans.
Concern 1: The resource from the problem. You’ll see inside of the 2nd question (Decide on Project.), the place it employs the right truck_id’s inside the ON assertion, but Cake simply cannot “join” these Occupations back again to the most suitable Truck, replica christian louboutin men shoes due to the fact that it’s really a alternative question! So it joins the observed careers to every Truck.
Main problem two: This is the ‘real’ downside, for Cake is not going to assemble prolonged Sign up for statements, louboutin replicas shoes so there is no way for you to discover the Employees/Leads just for all those Trucks that you choose to want. That’s why it finds them for every Truck, this is because you’re carrying out a FindAll on Truck.
I hope that makes feeling. You wish to carry out a notice all on Employment, www.extremefangrowth.com/buy-christian-louboutin-replica/ for the reason that which is the ‘center’ in the question (pickup_date).
$this->loadModel(‘Job’);
$whatev = $this->Job->find(‘all’, array(
‘contain’ => array(
‘Job’ => array(
‘Truck’, http://www.extremefangrowth.com/buy-christian-louboutin-replica/
‘Employee’,
‘Lead’, christian louboutin replica
‘conditions’ => array(
CakePHP queries in reality only do the job when you come across one/all of the sure product, it really is more effective to get started on within the middle and deliver the results either side assuming you have a double HABTM association. If you wish to ‘sort’ by Truck, cheap christian louboutin you then may have to put in writing you’re own query (design means) to perform the chore you. In raw SQL this question possibly will be not difficult, in abstracted PHP super-cake-ness that is hard for CakePHP to allow.
That you are proper in regards to the Occupation made up of Position, which was an oversight of mine. Notably with all the increased HABTM marriage TruckLog, you might close to absolutely want to design a model solution that finds precisely whatever you want. You can either really need to SQL question of your own choosing $Model->query(), and possibly utilize a sub-query/s to realize this in one query (a lot faster for functionality certainly). Ghostpsalm Nov twenty five ’10 at 0:37
http://pofio.com/activity/p/62079/
http://cvolunteer.com/forum.php?mod=viewthread&tid=82550
http://gy.com/bbs/forum.php?mod=viewthread&tid=2389794
http://wiki.aeternityonline.com/index.php?title=User:Chwp84522c7#sxjp_Christian_louboutin_sale_qbwt