Birthday module [SOLVED]

Where birth date is stored? Date and Time field? Is it also affect article create date?

Sergey Where birth date is stored? Date and Time field?

Yes

Is it also affect article create date?

No

I think you can custom code records module using records API. But I do not know good way to make it the way, you do not lose changes on update.

I have been struggeling for ages trying to achieve this, without success. At the moment I don't care much about loosing it on update. Could you please show me how to accomplish this?

You have to use records API

But as a last paramter $ids you have pass result of your filter.

$sql = "SELECT record_id FROM #__js_res_record_values 
    WHERE field_id = 12
      AND MONTH(field_value) = MONTH(NOW())";
$db = JFactory::getDbo();
$db->setQuery($sql);
$ids = $db->loadColumn();

This is how you get $ids of the records where date and time field ID 12 the same month as now.

Thanks Sergey,

What about Born Today?

Born today

SELECT record_id FROM #__js_res_record_values
WHERE field_id = 12
AND MONTH(field_value) = MONTH(NOW())
AND DAY(field_value) = DAY(NOW())

Born tomorow

SELECT record_id FROM #__js_res_record_values
WHERE field_id = 12
AND MONTH(field_value) = MONTH(NOW() + INTERVAL 1 DAY)
AND DAY(field_value) = DAY(NOW() + INTERVAL 1 DAY)

Born today

SELECT record_id FROM #__js_res_record_values
WHERE field_id = 12
AND MONTH(field_value) = MONTH(NOW())
AND DAY(field_value) = DAY(NOW())

returns a full unfiltered list. Pretty weird, isn't it?

This is because this query rturn 0 and when you pass 0 to API it does not limit at all.

You have to call API only if there are IDs.

if($ids)
{
    $items = $api->records(...);
}

if($ids)
{
    $items = $api->records(...);
}

ok, now you have lost me. I am not a programmer, remember?

What is your code to use records API? I gave tou the link in 6th post.

I have used NoNumber's Sourcerer and module Custom HTML to create the list:

{source}
<!-- You can place html anywhere within the source tags -->

<?php
$file = JPATH_ROOT.'/components/com_cobalt/api.php';
if(JFile::exists($file))
{
    include_once $file;
}

$sql = "SELECT record_id FROM #__js_res_record_values
    WHERE field_id = 3
AND MONTH(field_value) = MONTH(NOW())";

$db = JFactory::getDbo();
$db->setQuery($sql);
$ids = $db->loadColumn();

$api = new CobaltApi();
$section_id=1;
$limit=15;
$template=table;
$data = $api->records(
    $section_id,
    $view_what,
    $orderby,
    $type_ids,
    $user_id,
    $category_id,
    $limit,
    $template,
    $client,
    $client_id,
    $lang,
    $ids
);
?>

<ul>
<?php
foreach($data['list'] AS $item) {
    printf('<li><a href="/%s">%s</a></li>', $item->url, $item->title);
} ?>
</ul>
{/source}

1. Insead of $section_id theer should be section ID like 1 or 5. Somethign liek this.

$data = $api->records(
    1,
    'all',
    'r.ctime DESC',
    NULL,
    NULL,
    NULL,
    10,
    NULL,
    NULL,
    NULL,
    NULL,
    $ids
);

And after $ids = $db->loadColumn(); insert

if(empty($ids))
{
    return;
}

Sorry for my late response, Sergey. With your code I managed to create exactly what I want.

Thank you!

Hi whilst debugging I've encountered some warnings in my custom module :

Notice: Undefined offset: 1 in /home/mysite/public_html/sandbox/components/com_cobalt/api.php on line 259

Warning: strpos() expects parameter 1 to be string, array given in /home/mysite/public_html/sandbox/libraries/joomla/language/text.php on line 72

Warning: strtoupper() expects parameter 1 to be string, array given in /home/mysite/public_html/sandbox/libraries/joomla/language/language.php on line 328

I was wondering if these warnings are related to code you have provided and if so how to solve them.

Notice: Undefined offset: 1 in /home/mysite/public_html/sandbox/components/com_cobalt/api.php on line 259

This was caused due to an empty value for $orderby

2 warnings left to solve.....

If you manage to install xdebug to your PHP you will see your errors like so

This will give you error stak and you will be able to identify where is the origin of the error.

It is very hard to tell without tracking system.

Sergey It is very hard to tell without tracking system.

I understand. I'll leave it for the moment then, because it's not a major problem.

I do however, have another question:

How can I exclude expired records from this list?

I assume a connection has to be made to another table (__js_res_record_) to retrieve the column access where access = 1 ?

Could you give me a hint how to achieve this?

This module should display acording to section param,eters. Show future records parameter in section to NO.