// If no keys
if (!$keys) {
// If email sent from a known staff member
$from_staff = inbox::change_current_user($email_receive->mail_headers["from"]);
if ($from_staff) {
inbox::convert_email_to_new_task($email_receive, true);
} else {
$email_receive->mark_seen();
// mark it seen so we don't poll for it again
alloc_error("Could not create a task from this email. Email was not sent by a staff member. Email resides in INBOX.");
}
// Else if we have a key, append to comment
} else {
// Skip over emails that are from alloc. These emails are kept only for
// posterity and should not be parsed and downloaded and re-emailed etc.
if (same_email_address($email_receive->mail_headers["from"], ALLOC_DEFAULT_FROM_ADDRESS)) {
$email_receive->mark_seen();
$email_receive->archive();
} else {
inbox::process_one_email($email_receive);
}
}
} catch (Exception $e) {
// There may have been a database error, so let the database know it can run this next bit
db_alloc::$stop_doing_queries = false;
// Try forwarding the errant email
try {
$email_receive->forward(config::get_config_item("allocEmailAdmin"), "Email command failed", "\n" . $e->getMessage() . "\n\n" . $e->getTraceAsString());
// If that fails, try last-ditch email send
} catch (Exception $e) {
mail(config::get_config_item("allocEmailAdmin"), "Email command failed(2)", "\n" . $e->getMessage() . "\n\n" . $e->getTraceAsString());
function add_interested_party($data)
{
static $people;
$data["emailAddress"] = str_replace(array("<", ">"), "", $data["emailAddress"]);
// Add new entry
$ip = new interestedParty();
$existing = interestedParty::exists($data["entity"], $data["entityID"], $data["emailAddress"]);
if ($existing) {
$ip->set_id($existing["interestedPartyID"]);
$ip->select();
}
$ip->set_value("entity", $data["entity"]);
$ip->set_value("entityID", $data["entityID"]);
$ip->set_value("fullName", $data["name"]);
$ip->set_value("emailAddress", $data["emailAddress"]);
$ip->set_value("interestedPartyActive", 1);
if ($data["personID"]) {
$ip->set_value("personID", $data["personID"]);
$ip->set_value("fullName", person::get_fullname($data["personID"]));
} else {
$people or $people =& get_cached_table("person");
foreach ($people as $personID => $p) {
if ($data["emailAddress"] && same_email_address($p["emailAddress"], $data["emailAddress"])) {
$ip->set_value("personID", $personID);
$ip->set_value("fullName", $p["name"]);
}
}
}
$extra_interested_parties = config::get_config_item("defaultInterestedParties");
if (!$ip->get_value("personID") && !in_array($data["emailAddress"], (array) $extra_interested_parties)) {
$ip->set_value("external", 1);
$q = prepare("SELECT * FROM clientContact WHERE clientContactEmail = '%s'", $data["emailAddress"]);
$db = new db_alloc();
$db->query($q);
if ($row = $db->row()) {
$ip->set_value("clientContactID", $row["clientContactID"]);
$ip->set_value("fullName", $row["clientContactName"]);
}
}
$ip->save();
return $ip->get_id();
}
function find_email($debug = false, $get_blobs = false, $ignore_date = false)
{
$info = inbox::get_mail_info();
$mailbox = $this->get_value("commentMaster") . $this->get_value("commentMasterID");
$mail = new email_receive($info);
$mail->open_mailbox(config::get_config_item("allocEmailFolder") . "/" . $mailbox, OP_HALFOPEN + OP_READONLY);
$mail->check_mail();
$msg_nums = $mail->get_all_email_msg_uids();
$debug and print "<hr><br><b>find_email(): " . date("Y-m-d H:i:s") . " found " . count($msg_nums) . " emails for mailbox: " . $mailbox . "</b>";
// fetch and parse email
foreach ((array) $msg_nums as $num) {
$debug and print "<hr><br>Examining message number: " . $num;
unset($mimebits);
// this will stream output
$mail->set_msg($num);
$mail->get_msg_header();
$text = $mail->fetch_mail_text();
list($from1, $e1n) = parse_email_address($mail->mail_headers["from"]);
list($from2, $e2n) = parse_email_address($this->get_value("commentCreatedUserText"));
if (!$from2 && $this->get_value("commentCreatedUser")) {
$p = new person();
$p->set_id($this->get_value("commentCreatedUser"));
$p->select();
$from2 = $p->get_value("emailAddress");
}
if (!$from2 && $this->get_value("commentCreatedUserClientContactID")) {
$p = new clientContact();
$p->set_id($this->get_value("commentCreatedUserClientContactID"));
$p->select();
$from2 = $p->get_value("clientContactEmail");
}
$text1 = str_replace(array("\\s", "\n", "\r"), "", trim($text));
$text2 = str_replace(array("\\s", "\n", "\r"), "", trim($this->get_value("comment")));
$date = format_date("U", $this->get_value("commentCreatedTime"));
$date1 = strtotime($mail->mail_headers["date"]) - 300;
$date3 = strtotime($mail->mail_headers["date"]) + 300;
similar_text($text1, $text2, $percent);
if ($percent >= 99 && ($from1 == $from2 || !$from2 || same_email_address($from1, config::get_config_item("AllocFromEmailAddress"))) && ($date > $date1 && $date < $date3 || $ignore_date)) {
$debug and print "<br><b style='color:green'>Found you! Msg no: " . $num . " in mailbox: " . $mailbox . " for commentID: " . $this->get_id() . "</b>";
foreach ((array) $mail->mail_parts as $v) {
$s = $v["part_object"];
// structure
$raw_data = imap_fetchbody($mail->connection, $mail->msg_uid, $v["part_number"], FT_UID | FT_PEEK);
$thing = $mail->decode_part($s->encoding, $raw_data);
$filename = $mail->get_parameter_attribute_value($s->parameters, "name");
$filename or $filename = $mail->get_parameter_attribute_value($s->parameters, "filename");
$filename or $filename = $mail->get_parameter_attribute_value($s->dparameters, "name");
$filename or $filename = $mail->get_parameter_attribute_value($s->dparameters, "filename");
$bits = array();
$bits["part"] = $v["part_number"];
$bits["name"] = $filename;
$bits["size"] = strlen($thing);
$get_blobs and $bits["blob"] = $thing;
$filename and $mimebits[] = $bits;
}
$mail->close();
return array($mail, $text, $mimebits);
} else {
similar_text($text1, $text2, $percent);
$debug and print "<br>TEXT: " . sprintf("%d", $text1 == $text2) . " (" . sprintf("%d", $percent) . "%)";
#$debug and print "<br>Text1:<br>".$text1."<br>* * *<br>";
#$debug and print "Text2:<br>".$text2."<br>+ + +</br>";
$debug and print "<br>FROM: " . sprintf("%d", $from1 == $from2 || !$from2 || same_email_address($from1, config::get_config_item("AllocFromEmailAddress")));
$debug and print " From1: " . page::htmlentities($from1);
$debug and print " From2: " . page::htmlentities($from2);
$debug and print "<br>DATE: " . sprintf("%d", $date > $date1 && $date < $date3) . " (" . date("Y-m-d H:i:s", $date) . " | " . date("Y-m-d H:i:s", $date1) . " | " . date("Y-m-d H:i:s", $date3) . ")";
$debug and print "<br>";
}
}
$mail->close();
return array(false, false, false);
}
/**
* Convert a comma separated string of names, into an array with email addresses
* @param string $people
* @param string $entity the related entity that can assist in the look up
* @param integer $entityID the id of the related entity
* @return array an array of people, indexed by their email address
*/
public function get_people($options = array(), $entity = "", $entityID = "")
{
$person_table =& get_cached_table("person");
$people = $options;
if ($entity && $entityID) {
$e = new $entity();
$e->set_id($entityID);
$e->select();
in_array("default", $people) and $default_recipients = $e->get_all_parties();
in_array("internal", $people) and $internal_recipients = $e->get_all_parties();
}
// remove default and internal from the array
$clean_people = array_diff($people, array("default", "internal"));
if (is_object($e)) {
$projectID = $e->get_project_id();
$p = new project();
$p->set_id($projectID);
$p->select();
$client = $p->get_foreign_object("client");
$clientID = $client->get_id();
}
foreach ((array) $default_recipients as $email => $info) {
if ($info["selected"]) {
$rtn[$email] = $this->reduce_person_info($info);
}
}
foreach ((array) $internal_recipients as $email => $info) {
if ($info["selected"] && !$info["external"]) {
$rtn[$email] = $this->reduce_person_info($info);
}
}
foreach ((array) $clean_people as $person) {
$bad_person = true;
$person = trim($person);
// personID
if (is_numeric($person)) {
if ($person_table[$person]["personActive"]) {
$rtn[$person_table[$person]["emailAddress"]] = $person_table[$person];
$bad_person = false;
continue;
}
// email addresses
} else {
if (in_str("@", $person)) {
foreach ($person_table as $pid => $data) {
if (same_email_address($person, $data["emailAddress"]) && $data["personActive"]) {
$rtn[$data["emailAddress"]] = $data;
$bad_person = false;
continue 2;
}
}
if ($ccID = clientContact::find_by_email($person)) {
$cc = new clientContact();
$cc->set_id($ccID);
$cc->select();
$rtn[$cc->get_value("clientContactEmail")] = $cc->row();
$bad_person = false;
continue;
}
// If we get here, then return the email address entered
list($e, $n) = parse_email_address($person);
$rtn[$e] = array("emailAddress" => $e, "name" => $n);
$bad_person = false;
continue;
// usernames, partial and full names
} else {
foreach ($person_table as $pid => $data) {
// If matches username
if (strtolower($person) == strtolower($data["username"]) && $data["personActive"]) {
$rtn[$data["emailAddress"]] = $data;
$bad_person = false;
continue 2;
}
}
foreach ($person_table as $pid => $data) {
// If matches name
if (strtolower($person) == strtolower($data["firstName"] . " " . $data["surname"]) && $data["personActive"]) {
$rtn[$data["emailAddress"]] = $data;
$bad_person = false;
continue 2;
}
}
foreach ($person_table as $pid => $data) {
// If matches a section of name, eg: a search for "Ale" will match the full name "Alex Lance"
if (strtolower($person) == strtolower(substr(strtolower($data["firstName"] . " " . $data["surname"]), 0, strlen($person))) && $data["personActive"]) {
$rtn[$data["emailAddress"]] = $data;
$bad_person = false;
continue 2;
}
}
if ($ccID = clientContact::find_by_nick($person, $clientID)) {
$cc = new clientContact();
$cc->set_id($ccID);
$cc->select();
$rtn[$cc->get_value("clientContactEmail")] = $cc->row();
$bad_person = false;
continue;
}
if ($ccID = clientContact::find_by_name($person, $projectID)) {
$cc = new clientContact();
$cc->set_id($ccID);
$cc->select();
$rtn[$cc->get_value("clientContactEmail")] = $cc->row();
$bad_person = false;
continue;
}
if ($ccID = clientContact::find_by_partial_name($person, $projectID)) {
$cc = new clientContact();
$cc->set_id($ccID);
$cc->select();
$rtn[$cc->get_value("clientContactEmail")] = $cc->row();
$bad_person = false;
continue;
}
}
}
if ($bad_person) {
die("Unable to find person: " . $person);
}
}
foreach ((array) $rtn as $id => $p) {
$rtn[$id] = $this->reduce_person_info($p);
}
return (array) $rtn;
}
