Chris,
Just to help you out instead of the giant mktime string you have you can
also use strtotime(). Within the function you can simply do strtotime('+30
days') which will do the same thing as above.
On Wed, Dec 19, 2012 at 2:39 PM, Chris <[email protected]> wrote:
> hi cricket,.... thank you for your response
> I have another approach to it,... on the click to advertising banner
> and/or link thru function (link goes thru function), and checks and compare
> "featured_end" date with today's date,... and if it less than today's date
> it resets table.
> here is the function,... just in case anyone needs it:
>
> function featured($id = null)
> {
> if(!($dba = $this->Dba->findById($id)))
> {
> $this->flash('error', ucfirst(i18n::translate('dba not found')));
> $this->redirect('/not_found');
> }
> elseif(!($user = $this->User->findById($dba['Dba']['user_id'])))
> {
> $this->flash('error', ucfirst(i18n::translate('user not found')));
> $this->redirect('/not_found');
> }
> else
> {
> $today = date('Y-m-d H:i:s');
>
> if($dba['Dba']['featured_end'] <= $today)
> {
> $dba['Dba']['featured'] = 0;
> $dba['Dba']['featured_start'] = NULL;
> $dba['Dba']['featured_end'] = NULL;
>
> $this->Dba->save($dba);
>
> $this->redirect('/');
>
> }
> $this->redirect('/dbas/view/' . $dba['Dba']['id']);
> }
> }
>
>
>
>
> On Wednesday, December 19, 2012 11:11:07 AM UTC-8, cricket wrote:
>
>> Create a shell task to fetch all records with featured == 1 and
>> end_date in the past. Run a cron job at midnight to call it.
>>
>> On Wed, Dec 19, 2012 at 6:22 AM, Chris <[email protected]> wrote:
>> > hi guys,... can anyone help please
>> >
>> > I'm building promotional advertising feature on a site,...
>> > and have a table fields: "featured_start" once the user is call the
>> function
>> > and "featured_end" after 30 days:
>> >
>> > $dba['Dba']['featured'] = 1;
>> > $dba['Dba']['featured_start'] = date('Y-m-d H:i:s');
>> > $after_30 = mktime(date("H"), date("i"), date("s"), date("m"),
>> date("d")+30,
>> > date("y"));
>> > $dba['Dba']['featured_end'] = date('Y-m-d H:i:s', $after_30);
>> >
>> > now I want to set $dba['Dba']['featured'] = 0; after 30 days,
>> > and reset "featured_start" and "featured_end" to NULL
>> > so the promotion can stop,...
>> >
>> > how can I this,...?
>> >
>> > thanks in advance
>> > chris
>> >
>> >
>> >
>> > --
>> > Like Us on FaceBook
>> > https://www.facebook.com/**CakePHP<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 [email protected].
>> > To unsubscribe from this group, send email to
>> > cake-php+u...@**googlegroups.com.
>> > Visit this group at
>> > http://groups.google.com/**group/cake-php?hl=en<http://groups.google.com/group/cake-php?hl=en>.
>>
>> >
>> >
>>
> --
> 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 post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
>
>
>
--
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 post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en.
