###END_AUTOCODE
/**
*
+ * Build an email to sent do user
+ *
+ * key 'args'
+ *
+ * no_auth => disable authentication check on
+ * templateDir => alternative template directory.
+ * HTTP_HOST
+ *
+ * expects mail/TMPLATE.txt (if .html exists, it will be the html body version)
+ *
* @param {String} $templateFile (mail/XXXXXXX.txt) exclude the mail and .txt bit.
* @param {Array|Object} $args data to send out..
* @return {Array|PEAR_Error} array of $recipents, $header, $body
(isset($ff->HTTP_HOST) ? $ff->HTTP_HOST : 'localhost');
/* use the regex compiler, as it doesnt parse <tags */
- require_once 'HTML/Template/Flexy.php';
- $template = new HTML_Template_Flexy( array(
+
+ $tops = array(
'compiler' => 'Flexy',
'nonHTML' => true,
'filters' => array('SimpleTags','Mail'),
// 'debug'=>1,
- ));
+ );
-
-
+
+ if (!empty($args['templateDir'])) {
+ $tops['templateDir'] = $args['templateDir'];
+ }
+
+
+
+ require_once 'HTML/Template/Flexy.php';
+ $template = new HTML_Template_Flexy( $tops );
$template->compile("mail/$templateFile.txt");
/* use variables from this object to ouput data. */
$mailtext = $template->bufferedOutputObject($content);
+
+ $htmlbody = false;
+ // if a html file with the same name exists, use that as the body
+ // I've no idea where this code went, it was here before..
+ if (false !== $template->resolvePath ( "mail/$templateFile.html" )) {
+ $tops['nonHTML'] = false;
+ $template = new HTML_Template_Flexy( $tops );
+ $template->compile("mail/$templateFile.html");
+ $htmlbody = $template->bufferedOutputObject($content);
+
+ }
+
+
+
//echo "<PRE>";print_R($mailtext);
//print_R($mailtext);exit;
/* With the output try and send an email, using a few tricks in Mail_MimeDecode. */
$decoder = new Mail_mimeDecode($mailtext);
$parts = $decoder->getSendArray();
+
if (PEAR::isError($parts)) {
return $parts;
//echo "PROBLEM: {$parts->message}";
}
$headers['Date'] = date('r');
+ if ($htmlbody !== false) {
+ require_once 'Mail/mime.php';
+ $mime = new Mail_mime(array('eol' => "\n"));
+ $mime->setTXTBody($body);
+ $mime->setHTMLBody($htmlbody);
+ // I think there might be code in mediaoutreach toEmail somewhere
+ // h embeds images here..
+ $body = $mime->get();
+ $headers = $mime->headers($headers);
+
+ }
+
+
+
return array(
'recipients' => $recipents,
'headers' => $headers,
function applyFilters($q, $au, $roo)
{
//DB_DataObject::DebugLevel(1);
-// if (!empty($q['query']['person_not_internal'])) {
-// $this->whereAdd(" join_company_id_id.isOwner = 0 ");
-// }
-//
-//
-// if (!empty($q['query']['person_internal_only_all'])) {
-//
-//
-// // must be internal and not current user (need for distribution list)
-// // user has a projectdirectory entry and role is not blank.
-// //DB_DataObject::DebugLevel(1);
-// $pd = DB_DataObject::factory('ProjectDirectory');
-// $pd->whereAdd("role != ''");
-// $pd->selectAdd();
-// $pd->selectAdd('distinct(person_id) as person_id');
-// $roled = $pd->fetchAll('person_id');
-// $rs = $roled ? " OR
-// {$this->tableName()}.id IN (".implode(',', $roled) . ")
-// " : '';
-// $this->whereAdd(" join_company_id_id.comptype = 'OWNER' $rs ");
-//
-// }
-// // -- for distribution
-// if (!empty($q['query']['person_internal_only'])) {
-// // must be internal and not current user (need for distribution list)
-// $this->whereAdd(" join_company_id_id.comptype = 'OWNER'");
-//
-// //$this->whereAdd(($this->tableName() == 'Person' ? 'Person' : "join_person_id_id") .
-// // ".id != ".$au->id);
-// $this->whereAdd("Person.id != {$au->id}");
-// }
-//
-// if (!empty($q['query']['comptype_or_company_id'])) {
-// // DB_DataObject::debugLevel(1);
-// $bits = explode(',', $q['query']['comptype_or_company_id']);
-// $id = (int) array_pop($bits);
-// $ct = $this->escape($bits[0]);
-//
-// $this->whereAdd(" join_company_id_id.comptype = '$ct' OR Person.company_id = $id");
-//
-// }
-//
-//
-// // staff list..
-// if (!empty($q['query']['person_inactive'])) {
-// // DB_Dataobject::debugLevel(1);
-// $this->active = 1;
-// }
-// $tn_p = $this->tableName();
-// $tn_gm = DB_DataObject::Factory('group_members')->tableName();
-// $tn_g = DB_DataObject::Factory('Groups')->tableName();
-//
-// ///---------------- Group views --------
-// if (!empty($q['query']['in_group'])) {
-// // DB_DataObject::debugLevel(1);
-// $ing = (int) $q['query']['in_group'];
-// if ($q['query']['in_group'] == -1) {
-//
-// // list all staff who are not in a group.
-// $this->whereAdd("Person.id NOT IN (
-// SELECT distinct(user_id) FROM $tn_gm LEFT JOIN
-// $tn_g ON $tn_g.id = $tn_gm.group_id
-// WHERE $tn_g.type = ".$q['query']['type']."
-// )");
-//
-//
-// } else {
-//
-// $this->whereAdd("$tn_p.id IN (
-// SELECT distinct(user_id) FROM $tn_gm
-// WHERE group_id = $ing
-// )");
-// }
-//
-// }
-//
-// if (!empty($q['query']['not_in_directory'])) {
-// // it's a Person list..
-// // DB_DATaobjecT::debugLevel(1);
-//
-// // specific to project directory which is single comp. login
-// //
-// $owncomp = DB_DataObject::Factory('Companies');
-// $owncomp->get('comptype', 'OWNER');
-// if ($q['company_id'] == $owncomp->id) {
-// $this->active =1;
-// }
-//
-//
-//
-// if ( $q['query']['not_in_directory'] > -1) {
-// $tn_pd = DB_DataObject::Factory('ProjectDirectory')->tableName();
-// // can list current - so that it does not break!!!
-// $this->whereAdd("$tn_p.id NOT IN
-// ( SELECT distinct person_id FROM $tn_pd WHERE
-// project_id = " . $q['query']['not_in_directory'] . " AND
-// company_id = " . $this->company_id . ')');
-// }
-// }
-//
-// if (!empty($q['query']['role'])) {
-// // it's a Person list..
-// // DB_DATaobjecT::debugLevel(1);
-//
-// // specific to project directory which is single comp. login
-// //
-// $tn_pd = DB_DataObject::Factory('ProjectDirectory')->tableName();
-// // can list current - so that it does not break!!!
-// $this->whereAdd("$tn_p.id IN
-// ( SELECT distinct person_id FROM $tn_pd WHERE
-// role = '". $this->escape($q['query']['role']) ."'
-// )");
-//
-// }
-//
-//
-// if (!empty($q['query']['project_member_of'])) {
-// // this is also a flag to return if they are a member..
-// //DB_DataObject::debugLevel(1);
-// $do = DB_DataObject::factory('ProjectDirectory');
-// $do->project_id = $q['query']['project_member_of'];
-// $tn_pd = DB_DataObject::Factory('ProjectDirectory')->tableName();
-// $this->joinAdd($do,array('joinType' => 'LEFT', 'useWhereAsOn' => true));
-// $this->selectAdd("IF($tn_pd.id IS NULL, 0, $tn_pd.id ) as is_member");
-//
-//
-// if (!empty($q['query']['project_member_filter'])) {
-// $this->having('is_member !=0');
-//
-// }
-//
-// }
-//
-//
-// if (!empty($q['query']['search'])) {
-// $s = $this->escape($q['query']['search']);
-// $this->whereAdd("
-// $tn_p.name LIKE '%$s%' OR
-// $tn_p.email LIKE '%$s%' OR
-// $tn_p.role LIKE '%$s%' OR
-// $tn_p.remarks LIKE '%$s%'
-//
-// ");
-// }
+ if (!empty($q['query']['person_not_internal'])) {
+ $this->whereAdd(" join_company_id_id.isOwner = 0 ");
+ }
+
+
+ if (!empty($q['query']['person_internal_only_all'])) {
+
+
+ // must be internal and not current user (need for distribution list)
+ // user has a projectdirectory entry and role is not blank.
+ //DB_DataObject::DebugLevel(1);
+ $pd = DB_DataObject::factory('ProjectDirectory');
+ $pd->whereAdd("role != ''");
+ $pd->selectAdd();
+ $pd->selectAdd('distinct(person_id) as person_id');
+ $roled = $pd->fetchAll('person_id');
+ $rs = $roled ? " OR
+ {$this->tableName()}.id IN (".implode(',', $roled) . ")
+ " : '';
+ $this->whereAdd(" join_company_id_id.comptype = 'OWNER' $rs ");
+
+ }
+ // -- for distribution
+ if (!empty($q['query']['person_internal_only'])) {
+ // must be internal and not current user (need for distribution list)
+ $this->whereAdd(" join_company_id_id.comptype = 'OWNER'");
+
+ //$this->whereAdd(($this->tableName() == 'Person' ? 'Person' : "join_person_id_id") .
+ // ".id != ".$au->id);
+ $this->whereAdd("Person.id != {$au->id}");
+ }
+
+ if (!empty($q['query']['comptype_or_company_id'])) {
+ // DB_DataObject::debugLevel(1);
+ $bits = explode(',', $q['query']['comptype_or_company_id']);
+ $id = (int) array_pop($bits);
+ $ct = $this->escape($bits[0]);
+
+ $this->whereAdd(" join_company_id_id.comptype = '$ct' OR Person.company_id = $id");
+
+ }
+
+
+ // staff list..
+ if (!empty($q['query']['person_inactive'])) {
+ // DB_Dataobject::debugLevel(1);
+ $this->active = 1;
+ }
+ $tn_p = $this->tableName();
+ $tn_gm = DB_DataObject::Factory('group_members')->tableName();
+ $tn_g = DB_DataObject::Factory('Groups')->tableName();
+
+ ///---------------- Group views --------
+ if (!empty($q['query']['in_group'])) {
+ // DB_DataObject::debugLevel(1);
+ $ing = (int) $q['query']['in_group'];
+ if ($q['query']['in_group'] == -1) {
+
+ // list all staff who are not in a group.
+ $this->whereAdd("Person.id NOT IN (
+ SELECT distinct(user_id) FROM $tn_gm LEFT JOIN
+ $tn_g ON $tn_g.id = $tn_gm.group_id
+ WHERE $tn_g.type = ".$q['query']['type']."
+ )");
+
+
+ } else {
+
+ $this->whereAdd("$tn_p.id IN (
+ SELECT distinct(user_id) FROM $tn_gm
+ WHERE group_id = $ing
+ )");
+ }
+
+ }
+
+ if (!empty($q['query']['not_in_directory'])) {
+ // it's a Person list..
+ // DB_DATaobjecT::debugLevel(1);
+
+ // specific to project directory which is single comp. login
+ //
+ $owncomp = DB_DataObject::Factory('Companies');
+ $owncomp->get('comptype', 'OWNER');
+ if ($q['company_id'] == $owncomp->id) {
+ $this->active =1;
+ }
+
+
+
+ if ( $q['query']['not_in_directory'] > -1) {
+ $tn_pd = DB_DataObject::Factory('ProjectDirectory')->tableName();
+ // can list current - so that it does not break!!!
+ $this->whereAdd("$tn_p.id NOT IN
+ ( SELECT distinct person_id FROM $tn_pd WHERE
+ project_id = " . $q['query']['not_in_directory'] . " AND
+ company_id = " . $this->company_id . ')');
+ }
+ }
+
+ if (!empty($q['query']['role'])) {
+ // it's a Person list..
+ // DB_DATaobjecT::debugLevel(1);
+
+ // specific to project directory which is single comp. login
+ //
+ $tn_pd = DB_DataObject::Factory('ProjectDirectory')->tableName();
+ // can list current - so that it does not break!!!
+ $this->whereAdd("$tn_p.id IN
+ ( SELECT distinct person_id FROM $tn_pd WHERE
+ role = '". $this->escape($q['query']['role']) ."'
+ )");
+
+ }
+
+
+ if (!empty($q['query']['project_member_of'])) {
+ // this is also a flag to return if they are a member..
+ //DB_DataObject::debugLevel(1);
+ $do = DB_DataObject::factory('ProjectDirectory');
+ $do->project_id = $q['query']['project_member_of'];
+ $tn_pd = DB_DataObject::Factory('ProjectDirectory')->tableName();
+ $this->joinAdd($do,array('joinType' => 'LEFT', 'useWhereAsOn' => true));
+ $this->selectAdd("IF($tn_pd.id IS NULL, 0, $tn_pd.id ) as is_member");
+
+
+ if (!empty($q['query']['project_member_filter'])) {
+ $this->having('is_member !=0');
+
+ }
+
+ }
+
+
+ if (!empty($q['query']['search'])) {
+ $s = $this->escape($q['query']['search']);
+ $this->whereAdd("
+ $tn_p.name LIKE '%$s%' OR
+ $tn_p.email LIKE '%$s%' OR
+ $tn_p.role LIKE '%$s%' OR
+ $tn_p.remarks LIKE '%$s%'
+
+ ");
+ }
//
}