Re: Getting conditions Data for View

2013-03-05 Thread Jerome Walitzek
Hi Jeremy,

thanks for your answer.

I hard coded "2" into the controller to check what happens.

i think it is important to notice following.

in an other view i write the "event_id" into a session 
"$this->Session->write('Event.active', $id);"
that works and when i read it out in an model it works also.

what I want:
I click in my event view on a button called "activate" at the relevant data 
set on.
This click writes the respective event_id in the session "event.active".
Now I jump into the joblist and will get only the datasets with the 
"event_id" which is located in the session read.
Why I want to solve this with a SESSION is a little too complicated to 
explain it now :-)

do you understand what i meen ? :-)


Am Dienstag, 5. März 2013 18:12:20 UTC+1 schrieb Jeremy Burns:
>
> You are doing two finds and it is the last one (paginate) that is being 
> returned to the view. Comment that out and see what happens.
>
> You also didn't ought to hard code the value 2; you ought to pass it in as 
> a variable, something like this:
>
> public function sorted($eventId = null) {
> if ($this->Session->read('Event.active') == NULL) {
> $this->redirect(array('action' => 'index'));
> } else {
> if ($eventId) {
> $jobs = $this->Job->find(
> 'list',
> array(
> 'conditions' => array('Job.event_id' => $eventId)
> )
> );
> } else {
> $jobs = $this->Job->find('list');
> }
>  $this->set('jobs', $jobs);
>  }
> }
>
> Jeremy Burns
> Class Outfit
>
> http://www.classoutfit.com 
>
> On 5 Mar 2013, at 17:06:15, Jerome Walitzek 
> > 
> wrote:
>
> Hi there,
>
> i have a view which reads all data from database (find'list')
> now i would like to get only the data with the event_id '2" 
> so i have created a own view 'sorted'
> in the controller i use following
>
> public function sorted() {
> if ($this->Session->read('Event.active') == NULL) {
> $this->redirect(array('action' => 'index'));
> } else {
> $jobs = $this->Job->find('list', array('conditions' => 
> array('Job.event_id' => '2')));
> $this->set('jobs', $this->paginate());
> }
> }
>
>
> But the problem, i always get all data.
>
> any ideal how i can read out only the data with the Job.event_id = 2 
> values ??
>
> Thx for help
>
> -- 
> Like Us on FaceBook 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 unsubscribe from this group and stop receiving emails from it, send an 
> email to cake-php+u...@googlegroups.com .
> To post to this group, send email to cake...@googlegroups.com
> .
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>  
>  
>
>
>

-- 
Like Us on FaceBook 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 unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: Getting conditions Data for View

2013-03-05 Thread Jeremy Burns | Class Outfit
You are doing two finds and it is the last one (paginate) that is being 
returned to the view. Comment that out and see what happens.

You also didn't ought to hard code the value 2; you ought to pass it in as a 
variable, something like this:

public function sorted($eventId = null) {
if ($this->Session->read('Event.active') == NULL) {
$this->redirect(array('action' => 'index'));
} else {
if ($eventId) {
$jobs = $this->Job->find(
'list',
array(
'conditions' => array('Job.event_id' => 
$eventId)
)
);
} else {
$jobs = $this->Job->find('list');
}

$this->set('jobs', $jobs);

}

}

Jeremy Burns
Class Outfit

http://www.classoutfit.com

On 5 Mar 2013, at 17:06:15, Jerome Walitzek  wrote:

> Hi there,
> 
> i have a view which reads all data from database (find'list')
> now i would like to get only the data with the event_id '2" 
> so i have created a own view 'sorted'
> in the controller i use following
> 
> public function sorted() {
>   if ($this->Session->read('Event.active') == NULL) {
>   $this->redirect(array('action' => 'index'));
>   } else {
>   $jobs = $this->Job->find('list', array('conditions' => 
> array('Job.event_id' => '2')));
>   $this->set('jobs', $this->paginate());
>   }
>   
> }
> 
> 
> But the problem, i always get all data.
> 
> any ideal how i can read out only the data with the Job.event_id = 2 values ??
> 
> Thx for help
> 
> -- 
> Like Us on FaceBook 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 unsubscribe from this group and stop receiving emails from it, send an 
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>  
>  

-- 
Like Us on FaceBook 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 unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Getting conditions Data for View

2013-03-05 Thread Jerome Walitzek
Hi there,

i have a view which reads all data from database (find'list')
now i would like to get only the data with the event_id '2" 
so i have created a own view 'sorted'
in the controller i use following

public function sorted() {
if ($this->Session->read('Event.active') == NULL) {
$this->redirect(array('action' => 'index'));
} else {
$jobs = $this->Job->find('list', array('conditions' => array('Job.event_id' 
=> '2')));
$this->set('jobs', $this->paginate());
}
}


But the problem, i always get all data.

any ideal how i can read out only the data with the Job.event_id = 2 values 
??

Thx for help

-- 
Like Us on FaceBook 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 unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.