You could try something like the following
$isBooked = $this->Point->BookedSurvey->find('count', array(
'conditions' => array(
'BookedSurvey.survey_date' => date('Y-m-d') // Maybe pass an actual
specific date rather than just today
)
));
if($isBooked > 0) {
echo "Already booked";
}
If your survey_date field is using datetime, you can check between 00:00:00
and 23:59:59 using the TimeHelper::dayAsSql method here
http://book.cakephp.org/2.0/en/core-libraries/helpers/time.html#TimeHelper::dayAsSql
I'd recommend using the time helper where applicable really, you'd need to
use CakeTime:: if you plan to do this in a controller or model.
Hope this helps
On 23 July 2014 01:44, Jumy Elerossë <[email protected]> wrote:
> Hello everyone.
>
> I'm struggling with a problem since a week ago, and this is driving me
> crazy.
>
> I'm doing a website for doing surveys in the forest. This is the schema:
>
> 1 place have several points, and for each point, an user can book a day
> for doing a survey. If that point has booked already a survey for that
> date, an error will be shown.
>
> I have the following tables: places, points, users and booked_surveys.
>
> The table booked_surveys has the following fields: id, survey_date,
> point_id and user_id
>
> Models: Place, Point, User, BookedSurvey
>
> Controllers: PlacesController, PointController, UserController,
> BookedSurveysController
>
> Views: add, edit, index and view for each one.
>
> When the user is viewing a point, there's a date selector in the view for
> booking:
>
> <h2>Book a date:</h2>
>
> <?php echo $this->Form->create('BoostCake', array(
> 'inputDefaults' => array(
> 'div' => 'form-group',
> 'label' => array(
> 'class' => 'col col-md-1 control-label'
> ),
> 'wrapInput' => 'col col-md-9',
> 'class' => 'form-control'
> ),
> 'class' => 'form-horizontal'
> )); ?>
>
> <?php echo $this->Form->create('Point');
>
>
> echo $this->Form->input('BookedSurvey.survey_date',
> array(
> 'type'=>'date',
> 'label' => '',
> 'dateFormat' => 'YMD',
> 'minYear' => date('Y'),
> 'minMonth' => date('M'),
> 'minDay' => date('D'),
> 'div' => 'col col-md-9',
> 'style' => 'margin: 15px 5px 5px 0px'
> ));
>
> echo $this->Form->hidden('User.id', array(
> 'value' => $user_id)
> );
>
> ?>
>
>
>
> <div class="form-group">
> <?php echo $this->Form->submit('Book survey', array(
> 'div' => 'col col-md-9',
> 'class' => 'btn btn-success btn-lg',
> 'style' => 'margin: 10px 5px 5px 10px'
> )); ?>
> </div>
>
> And then, the PointsControllers looks if there is someone that already
> booked for that day. And this is what is driving me crazy, because I'm not
> able to doing it to work. What I tried is this:
>
> if ($this->request->is('post')) {
>
>
>
> // Begin of comprobation
>
> $booked_condition = $this->Point->BookedSurvey->find('first',
> array('conditions'=>array(
>
> 'DATE(BookedSurvey.survey_date)'=>'date()')));
>
>
>
> if ($booked_condition){
>
> echo "Already booked";
> }
>
>
> If anyone can PLEASE give some light to this... Please....
>
> --
> 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 [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/cake-php.
> For more options, visit https://groups.google.com/d/optout.
>
--
Kind Regards
Stephen Speakman
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
