blue-mouse
Member
Hi,
i need to modify my simple email plugin that was sended ,earlier, email to recipient1.
Now i would like to write 2 email plugin:
email(1) is send email to recipient1 when he is NOT on holiday
email(2) should send email to other person (i write sql SELECT for this)= recipient_substituted1_person that has email recipient_substituted1_email in case when recipient1 is on holiday
we have knowledge if recipient1 is on holiday because we have:
Status if holiday are active: YES/NO = TAK/NIE --- `ccjom_cc_lista_zastepstw`.`status_zastepstwa`
START_DATA of holiday --- `ccjom_cc_lista_zastepstw`.`data_zast_od`
END_DATA of holiday --- `ccjom_cc_lista_zastepstw`.`data_zast_do`
Please help with this php scripting and mysql query,
======================================================================================
Fabrik:edit form--Plugins -- email(1)
Email to (eval) ----- (This works)
$db =& JFactory::getDBO();
$recipient1 = '{ccjom_cc_zapotrzebowanie___recipient1_raw}';
var_dump($recipient1);
$query = "SELECT `email` FROM `ccjom_users` WHERE `id` = " . $db->Quote($recipient1);
$db->setQuery($query);
$result = $db->loadResult();
return $result;
----------------------------------------------------------------
User tools:
Condition: ---- email should be send when SELECT return no row/record ----
----- and i have problem with this: `data_zast_od`===START_DATA=<today>=END_DATA===`data_zast_do`
I have a problem to write right condition
SELECT `email_zastep` FROM `ccjom_cc_lista_zastepstw` WHERE `ccjom_cc_lista_zastepstw`.`status_zastepstwa`='TAK' AND `ccjom_cc_lista_zastepstw`.`osoba_zastepowana`=`ccjom_cc_zapotrzebowanie`.`recipient1` AND `ccjom_cc_lista_zastepstw`.`form_id`='20' AND `ccjom_cc_lista_zastepstw`.`data_zast_od`<=today AND `ccjom_cc_lista_zastepstw`.`data_zast_do`>=today;
====================================================================================================
Fabrik:edit form--Plugins -- email(2)
Email to (eval) -----
Email should be send to the email address
$db =& JFactory::getDBO();
$recipient_substituted1_email = '{ccjom_cc_lista_zastepstw___email_zastep}'
var_dump($recipient_substituted1_email);
$query="SELECT `email_zastep` FROM `ccjom_cc_lista_zastepstw` WHERE `ccjom_cc_lista_zastepstw`.`status_zastepstwa`='TAK' AND `ccjom_cc_lista_zastepstw`.`osoba_zastepowana`=`ccjom_cc_zapotrzebowanie`.`recipient1` AND `ccjom_cc_lista_zastepstw`.`form_id`='20' AND `ccjom_cc_lista_zastepstw`.`data_zast_od`<=today AND `ccjom_cc_lista_zastepstw`.`data_zast_do`>=today;
????
$db->setQuery($query);
$result = $db->loadResult();
return $result;
---------------------------------------------------------------------------------------
User tools:
Condition: ---- email should be send when SELECT return any row/record - 1 or more records ----
----- and i have problem with this: `data_zast_od`===START_DATA=<today>=END_DATA===`data_zast_do`
I have a problem to write right condition
SELECT `email_zastep` FROM `ccjom_cc_lista_zastepstw` WHERE `ccjom_cc_lista_zastepstw`.`status_zastepstwa`='TAK' AND `ccjom_cc_lista_zastepstw`.`osoba_zastepowana`=`ccjom_cc_zapotrzebowanie`.`recipient1` AND `ccjom_cc_lista_zastepstw`.`form_id`='20' AND `ccjom_cc_lista_zastepstw`.`data_zast_od`<=today AND `ccjom_cc_lista_zastepstw`.`data_zast_do`>=today;
=============================================================================================================
i need to modify my simple email plugin that was sended ,earlier, email to recipient1.
Now i would like to write 2 email plugin:
email(1) is send email to recipient1 when he is NOT on holiday
email(2) should send email to other person (i write sql SELECT for this)= recipient_substituted1_person that has email recipient_substituted1_email in case when recipient1 is on holiday
we have knowledge if recipient1 is on holiday because we have:
Status if holiday are active: YES/NO = TAK/NIE --- `ccjom_cc_lista_zastepstw`.`status_zastepstwa`
START_DATA of holiday --- `ccjom_cc_lista_zastepstw`.`data_zast_od`
END_DATA of holiday --- `ccjom_cc_lista_zastepstw`.`data_zast_do`
Please help with this php scripting and mysql query,
======================================================================================
Fabrik:edit form--Plugins -- email(1)
Email to (eval) ----- (This works)
$db =& JFactory::getDBO();
$recipient1 = '{ccjom_cc_zapotrzebowanie___recipient1_raw}';
var_dump($recipient1);
$query = "SELECT `email` FROM `ccjom_users` WHERE `id` = " . $db->Quote($recipient1);
$db->setQuery($query);
$result = $db->loadResult();
return $result;
----------------------------------------------------------------
User tools:
Condition: ---- email should be send when SELECT return no row/record ----
----- and i have problem with this: `data_zast_od`===START_DATA=<today>=END_DATA===`data_zast_do`
I have a problem to write right condition
SELECT `email_zastep` FROM `ccjom_cc_lista_zastepstw` WHERE `ccjom_cc_lista_zastepstw`.`status_zastepstwa`='TAK' AND `ccjom_cc_lista_zastepstw`.`osoba_zastepowana`=`ccjom_cc_zapotrzebowanie`.`recipient1` AND `ccjom_cc_lista_zastepstw`.`form_id`='20' AND `ccjom_cc_lista_zastepstw`.`data_zast_od`<=today AND `ccjom_cc_lista_zastepstw`.`data_zast_do`>=today;
====================================================================================================
Fabrik:edit form--Plugins -- email(2)
Email to (eval) -----
Email should be send to the email address
$db =& JFactory::getDBO();
$recipient_substituted1_email = '{ccjom_cc_lista_zastepstw___email_zastep}'
var_dump($recipient_substituted1_email);
$query="SELECT `email_zastep` FROM `ccjom_cc_lista_zastepstw` WHERE `ccjom_cc_lista_zastepstw`.`status_zastepstwa`='TAK' AND `ccjom_cc_lista_zastepstw`.`osoba_zastepowana`=`ccjom_cc_zapotrzebowanie`.`recipient1` AND `ccjom_cc_lista_zastepstw`.`form_id`='20' AND `ccjom_cc_lista_zastepstw`.`data_zast_od`<=today AND `ccjom_cc_lista_zastepstw`.`data_zast_do`>=today;
????
$db->setQuery($query);
$result = $db->loadResult();
return $result;
---------------------------------------------------------------------------------------
User tools:
Condition: ---- email should be send when SELECT return any row/record - 1 or more records ----
----- and i have problem with this: `data_zast_od`===START_DATA=<today>=END_DATA===`data_zast_do`
I have a problem to write right condition
SELECT `email_zastep` FROM `ccjom_cc_lista_zastepstw` WHERE `ccjom_cc_lista_zastepstw`.`status_zastepstwa`='TAK' AND `ccjom_cc_lista_zastepstw`.`osoba_zastepowana`=`ccjom_cc_zapotrzebowanie`.`recipient1` AND `ccjom_cc_lista_zastepstw`.`form_id`='20' AND `ccjom_cc_lista_zastepstw`.`data_zast_od`<=today AND `ccjom_cc_lista_zastepstw`.`data_zast_do`>=today;
=============================================================================================================