function addUpdateReportData($iduser)
{
$do_contact = new Contact();
$total_contacts = $do_contact->getTotalNumContactsForUser($iduser);
$do_contact_notes = new ContactNotes();
$total_notes = $do_contact_notes->getTotalNumContactNotesForUser($iduser);
$do_contact_projects = new Project();
$total_projects = $do_contact_projects->getTotalNumProjectsForUser($iduser);
$do_task = new Task();
$total_tasks = $do_task->getTotalNumTasksForUser($iduser);
$do_proj_discussion = new ProjectDiscuss();
$total_proj_discussions = $do_proj_discussion->getTotalNumProjectDiscussionsForUser($iduser);
$do_invoice = new Invoice();
$total_invoices = $do_invoice->getTotalNumInvoicesForUser($iduser);
//total email sent today
$msg_con = new sqlQuery($this->getDbCon());
$sql_msg_check = "SELECT SUM(`num_msg_sent`) AS num_msg_sent FROM `message_usage` WHERE `iduser` = " . $iduser;
$msg_con->query($sql_msg_check);
$total_email_sent = 0;
if ($msg_con->getNumRows()) {
$msg_con->fetch();
$total_email_sent = $msg_con->getData("num_msg_sent");
}
$this->getId($iduser);
if ($this->hasData()) {
$this->total_contacts = $total_contacts;
$this->total_notes = $total_notes;
$this->total_projects = $total_projects;
$this->total_tasks = $total_tasks;
$this->total_discussion = $total_proj_discussions;
$this->total_invoices = $total_invoices;
$this->current_date = date("Y-m-d");
$this->total_email_sent = $total_email_sent;
$this->update();
} else {
$this->total_contacts = $total_contacts;
$this->total_notes = $total_notes;
$this->total_projects = $total_projects;
$this->total_tasks = $total_tasks;
$this->total_discussion = $total_proj_discussions;
$this->total_invoices = $total_invoices;
$this->current_date = date("Y-m-d");
$this->iduser = $iduser;
$this->total_email_sent = $total_email_sent;
$this->add();
}
}
function updateStatus($idtask, $status)
{
$this->getId($idtask);
$this->status = $status;
$this->date_completed = date("Y-m-d");
$this->update();
if ($this->getContactForTask($idtask)) {
include_once "class/ContactNotes.class.php";
include_once "class/TaskCategory.class.php";
$do_contact_obj = new ContactNotes();
$do_task_cat_obj = new TaskCategory();
//$do_contact_obj->note = 'Task Completed:<br /><span class="task_category">'.$do_task_cat_obj->getTaskCategoryName($this->getTaskCategory($idtask)).'</span> <STRIKE>'.$this->getTaskDetail($idtask).'</STRIKE>';
$do_contact_obj->note = _('Task Completed:') . '<br /><span class="task_category">' . $this->getTaskCategory($idtask) . '</span> <STRIKE>' . $this->getTaskDetail($idtask) . '</STRIKE>';
$do_contact_obj->idcontact = $this->getContactForTask($idtask);
$do_contact_obj->date_added = date("Y-m-d");
$do_contact_obj->iduser = $_SESSION['do_User']->iduser;
$do_contact_obj->add();
}
}
public function checkFileAccessSecurity($filename)
{
$return = false;
/*
Check if the request is from the Contact Portal and then do the operation
*/
if ($_SESSION['portal_idcontact'] != '') {
$do_cnt_note = new ContactNotes();
if ($do_cnt_note->isDocumentForContact($_SESSION['portal_idcontact'], $filename)) {
$return = true;
}
} elseif ($_SESSION['do_User']->iduser != '') {
// We have userid set then the request is from a loggedin user
$q_project_discuss = new sqlQuery($this->getDbCon());
$q_project_discuss->query("select idproject_task from project_discuss where document = '" . $filename . "'");
// Check if the file is in project_discuss
if ($q_project_discuss->getNumRows()) {
$q_project_discuss->fetch();
$do_proj_task = new ProjectTask();
if ($do_proj_task->isProjectTaskReletedToUser($q_project_discuss->getData("idproject_task"), $_SESSION['do_User']->iduser)) {
$return = true;
}
} else {
// Not in project Discuss then check in contact_note
$q_cnt_note = new ContactNotes();
$q_cnt_note->query("select idcontact from contact_note where document = '" . $filename . "'");
if ($q_cnt_note->getNumRows()) {
$q_cnt_note->fetch();
$do_cont = new Contact();
if ($do_cont->isContactRelatedToUser($q_cnt_note->getData("idcontact"))) {
$return = true;
}
}
}
}
return $return;
}
/**
* Import a Twitter friend
*/
function importTwitterFriend($friend_data, $extra_tag = '')
{
$iduser = $_SESSION['do_User']->iduser;
$tw_user_id = $friend_data['user_id'];
$idcontact = $this->isTwFriendInContacts($iduser, $tw_user_id);
list($fname, $lname) = explode(' ', $friend_data['name'], 2);
$screen_name = $friend_data['screen_name'];
$description = $friend_data['description'];
$profile_image_url = $friend_data['profile_image_url'];
$url = $friend_data['url'];
$do_tag = new Tag();
if ($idcontact) {
//update the data
$c = new Contact();
$c->getId($idcontact);
$c->firstname = $fname;
$c->lastname = $lname;
if ($c->picture == "") {
$c->picture = $profile_image_url;
}
$c->tw_user_id = $tw_user_id;
$c->update();
$do_tag->addTagAssociation($idcontact, 'Twitter', 'contact', $iduser);
if ($extra_tag != '') {
$do_tag->addTagAssociation($idcontact, $extra_tag, 'contact', $iduser);
}
} else {
// new entry
$c = new Contact();
$c->firstname = $fname;
$c->lastname = $lname;
$c->iduser = $iduser;
$c->picture = $profile_image_url;
$c->tw_user_id = $tw_user_id;
$c->add();
$idcontact = $c->idcontact;
$w = new ContactWebsite();
$w->idcontact = $idcontact;
$w->website = 'http://twitter.com/' . $screen_name;
$w->website_type = 'Twitter';
$w->feed_auto_fetch = 'Yes';
$w->add();
if ($url != '') {
$w = new ContactWebsite();
$w->idcontact = $idcontact;
$w->website = $url;
$w->website_type = 'Personal';
$w->add();
}
$link = '<br /><a href="http://twitter.com/' . $screen_name . '" target="_blank">Back to the Source of the Article</a><br />';
$do_contact_note = new ContactNotes();
$do_contact_note->idcontact = $idcontact;
$do_contact_note->note = $description . $link;
$do_contact_note->date_added = date('Y-m-d');
$do_contact_note->iduser = $iduser;
$do_contact_note->add();
$do_tag->addTagAssociation($idcontact, 'Twitter', 'contact', $iduser);
if ($extra_tag != '') {
$do_tag->addTagAssociation($idcontact, $extra_tag, 'contact', $iduser);
}
}
}
$msg = new Message();
$msg->setData(array("user_firstname" => $do_user->firstname, "user_lastname" => $do_user->lastname, "user_company" => $do_user->company));
$msg->getMessage("welcome client portal");
$msg->setCanClose("no");
echo $msg->displayMessage();
}
?>
</div>
<div class="grayline2"></div>
<div class="headline_fuscia"><?php
echo _('Add a Note or File');
?>
</div>
<div class="percent95">
<?php
$ContactNotes = new ContactNotes($GLOBALS['conx']);
$ContactNotes->sessionPersistent("ContactNoteEditSave", "contacts.php", 300);
$_SESSION['ContactNoteEditSave']->idcontact = $idcontact;
//$_SESSION['ContactNoteEditSave']->iduser = $do_user->iduser;
$e_addContactNote = $_SESSION['ContactNoteEditSave']->newForm("ContactNoteEditSave->eventAdd");
$e_addContactNote->setLevel(123);
$e_addContactNote->setGotFile(true);
$e_addContactNote->addEventAction("mydb.gotoPage", 90);
//$e_addContactNote->addEventAction("ContactNoteEditSave->eventFormatNoteInsert", 119);
$e_addContactNote->addEventAction("ContactNoteEditSave->eventHTMLCleanUp", 119);
$e_addContactNote->addEventAction("portalUser->eventSendPortalAlert", 238);
$e_addContactNote->addEventAction("WorkFeedContactNotePortal->eventAddFeed", 245);
$e_addContactNote->addParam("iduser_for_feed", $iduser_for_feed);
$e_addContactNote->addParam("added_by_cont", $added_by_contact);
$e_addContactNote->addParam('goto', $_SERVER['PHP_SELF']);
$e_addContactNote->addParam('errPage', $_SERVER['PHP_SELF']);
/**
* sendMessage
* This abstract the message sending so we use a general function
* that will send email or facebook or twitter based on the user
* preferences and settings.
* its possible to generate an EmailTemplate on the fly with no records in the DB
* Here is an exemple:
* <code php>
* $do_template = new EmailTemplate();
* $do_template->senderemail = "*****@*****.**";
* $do_template->sendername = "Philippe Lewicki";
* $do_template->subject = "This is an example";
* $do_template->bodytext = "This is the content of the sample message";
* $do_template->bodyhtml = nl2br($do_template->bodytext);
* </code>
*
* An other example more OO / stylish
* <code php>
* $do_template = new EmailTemplate();
* $do_template->setFrom("*****@*****.**", "Philippe Lewicki")
* ->setSubject("This is an example")
* ->setMessage("This is the content of the sample message");
* </code>
* setFrom() is optional, if not provided it takes the do_User data
*
* Then send the message with: $contact->sendMessage($do_template);
*
* If you used a saved EmailTemplate like
* $do_template = new EmailTemplate("my template in email template table");
* and want the sender to be the currently signed in user, make sure the senderemail field
* is empty.
*
* @param $message an EmailTemplate object.
* @param $values an array with values to merge, optional.
*
*/
function sendMessage($template, $values = array())
{
if (!is_object($template)) {
return false;
}
if (empty($values)) {
$values = $this->getValues();
}
$this->last_message_sent = false;
$do_contact_email = $this->getChildContactEmail();
$email_to = $do_contact_email->getDefaultEmail();
$this->setLog("\n Sending message to:" . $email_to);
$contact_link = '<a href="/Contact/' . $this->idcontact . '">' . $this->firstname . ' ' . $this->lastname . '</a>';
if (strlen($email_to) > 4) {
if ($this->email_optout != 'y') {
$emailer = new Ofuz_Emailer('UTF-8');
if (strlen($template->senderemail) == 0) {
$template->setFrom($_SESSION['do_User']->email, $_SESSION['do_User']->getFullName());
}
$emailer->setEmailTemplate($template);
$emailer->mergeArrayWithFooter($values);
$emailer->addTo($email_to);
$this->last_message_sent = true;
return $emailer->send();
} else {
$_SESSION['in_page_message'] .= _("<br>" . $contact_link . " has opt-out and will not receive this email");
}
} elseif (strlen($this->tw_user_id) > 0) {
// send direct message using twitter api.
try {
$do_twitter = new OfuzTwitter();
$tw_config = $do_twitter->getTwitterConfig();
$serialized_token = $do_twitter->getAccessToken();
$token = unserialize($serialized_token);
$ofuz_twitter = new Ofuz_Service_Twitter($token->getParam('user_id'), $tw_config, $token);
$followers = $ofuz_twitter->userFollowers(false);
if (is_object($followers) && count($followers->user) > 0) {
foreach ($followers->user as $follower) {
if ($follower->id == $this->tw_user_id) {
$merge = new MergeString();
$message = $merge->withArray($template->bodytext, $values);
$ofuz_twitter->directMessageNew($this->tw_user_id, $message);
$do_contact_notes = new ContactNotes();
$do_contact_notes->iduser = $_SESSION['do_User']->iduser;
$do_contact_notes->note = $message;
$do_contact_notes->date_added = date('Y-m-d');
$do_contact_notes->idcontact = $this->idcontact;
$do_contact_notes->add();
return true;
}
}
}
$_SESSION['in_page_message'] .= _("<br>Notification can not be sent to " . $contact_link);
} catch (Exception $e) {
$_SESSION['in_page_message'] .= _("<br>Notification can not be sent to " . $contact_link);
}
} elseif ($this->fb_userid && $_SESSION["do_User"]->global_fb_connected) {
// send message using facebook api.
include_once 'facebook_client/facebook.php';
include_once 'class/OfuzFacebook.class.php';
$facebook = new Facebook(FACEBOOK_API_KEY, FACEBOOK_APP_SECRET);
try {
$msg = _(' has sent the following message using ofuz') . '<br />';
$msg .= '<b>' . $template->subject . '</b><br/>' . $template->bodyhtml;
$facebook->api_client->notifications_send($this->fb_userid, $msg, 'user_to_user');
//$this->last_message_sent = true;
} catch (Exception $e) {
$_SESSION['in_page_message'] .= _("<br>Notification can not be sent to " . $contact_link);
}
} else {
$_SESSION['in_page_message'] .= _("<br>" . $contact_link . " doesn't have a valid email address, facebook account, or twitter id.");
}
if ($this->last_message_sent) {
return true;
} else {
return false;
}
}
$workfeed->addRssFeed($do_contact_note, 'http://twitter.com/' . $user->screen_name, $note_content);
$imported[] = $user->id;
}
}
}
// Import Notes from followers
$followers = $ofuz_twitter->userFollowers(true);
if (is_object($followers) && count($followers->user) > 0) {
foreach ($followers->user as $user) {
// Don't import twice; friends may be followers
if (in_array($user->id, $imported)) {
continue;
}
$idcontact = $do_twitter->cronFeedStatus($iduser, $user->id, strtotime($user->status->created_at));
if ($idcontact !== false) {
$link = '<br /><a href="http://twitter.com/' . $user->screen_name . '" target="_blank">Back to the Source of the Article</a><br />';
$note_content = nl2br(strip_tags($user->status->text));
$do_contact_note = new ContactNotes();
$do_contact_note->idcontact = $idcontact;
$do_contact_note->note = $note_content . $link;
$do_contact_note->date_added = date('Y-m-d');
$do_contact_note->iduser = $iduser;
$do_contact_note->add();
$workfeed = new WorkFeedRssFeedImport();
$workfeed->addRssFeed($do_contact_note, 'http://twitter.com/' . $user->screen_name, $note_content);
}
}
}
}
}
}
echo '<b>' . $_SESSION['adm_project_report_discuss']->getTotalHoursEnteredMonthly($_SESSION['adm_project_report_discuss']->iduser, $_SESSION['adm_project_report']->idproject) . ' hrs</b>';
echo ' ';
echo ' by ' . $_SESSION['do_User']->getFullName($_SESSION['adm_project_report_discuss']->iduser);
//echo _('For the current month total work done : ').$_SESSION['adm_project_report_discuss']->getTotalHoursEnteredMonthly($_SESSION['adm_project_report_discuss']->iduser,"") ;
//echo '<br />';
echo '</div></div>';
//echo '<div class="dottedline"></div>';
}
echo '<div class="dottedline"></div>
<div class="section20">';
//echo '<div class="section20">';
}
}
}
echo '<div class="headline_fuscia">' . _('Contacts') . '</div>';
$do_adm_contacts = new ContactNotes();
$do_adm_contact_notes = new ContactNotes();
$do_contact = new Contact();
$do_adm_contacts->getUserContactsFromNotesMonthly($_SESSION['adm_project_report_discuss']->report_year, $_SESSION['adm_project_report_discuss']->report_month);
while ($do_adm_contacts->next()) {
if ($do_contact->isContactRelatedToUser($do_adm_contacts->idcontact)) {
//$monthly_hours = $do_adm_contact_notes->getUserContactNotesMonthlyHours($_SESSION['adm_project_report_discuss']->report_year,$_SESSION['adm_project_report_discuss']->report_month, $do_adm_contacts->idcontact);
//if($monthly_hours > '0.00') {
echo '<b>' . $do_adm_contacts->monthly_hours . ' ' . _('hrs') . '</b> ' . _(' spent with ') . ' <span class="contacts_name"><a href="/Contact/' . $do_adm_contacts->idcontact . '">' . $do_adm_contacts->cname . ' </a></span> ';
echo '<br />';
//}
}
}
echo '<br />';
?>
<div class="dottedline"></div>
function eventImportAccount(EventControler $evtcl)
{
$msg = "";
$uploaded_file = $_FILES['fields']['name']['import_account'];
$target_path = 'files/' . $uploaded_file;
if (!move_uploaded_file($_FILES['fields']['tmp_name']['import_account'], $target_path)) {
$msg = "There was an error uploading the file, please try again!";
} else {
chmod($target_path, 0755);
if (file_exists($target_path)) {
//$xml = simplexml_load_file($_SERVER['DOCUMENT_ROOT']."/".$target_path);
$str_xml = file_get_contents($_SERVER['DOCUMENT_ROOT'] . "/" . $target_path);
$str_xml = preg_replace('/[^(\\x20-\\x7F)]*/', '', $str_xml);
$xml = simplexml_load_string($str_xml);
echo '<pre>';
print_r($xml);
echo '</pre>';
die;
if ($xml !== FALSE) {
$c_cnt = count($xml->contact);
if ($c_cnt) {
for ($i = 0; $i < $c_cnt; $i++) {
$do_contact = new Contact();
$contact = $xml->contact[$i];
$do_contact->firstname = $contact->firstname;
$do_contact->lastname = $contact->lastname;
$do_contact->position = $contact->position;
$do_contact->company = $contact->company;
$do_contact->idcompany = $contact->idcompany;
$do_contact->iduser = $_SESSION['do_User']->iduser;
$do_contact->picture = $contact->picture;
$do_contact->summary = $contact->summary;
$do_contact->birthday = $contact->birthday;
$do_contact->portal_code = $contact->portal_code;
$do_contact->fb_userid = $contact->fb_userid;
$do_contact->tw_user_id = $contact->tw_user_id;
$do_contact->email_optout = $contact->email_optout;
$do_contact->add();
$lastInsertedContId = $do_contact->getPrimaryKeyValue();
/**
*Contact Address
*/
$ca_cnt = count($contact->contact_address);
if ($ca_cnt) {
for ($ca_cnt_i = 0; $ca_cnt_i < $ca_cnt; $ca_cnt_i++) {
$do_contact_address = new ContactAddress();
$contact_address = $contact->contact_address[$ca_cnt_i];
$do_contact_address->city = $contact_address->city;
$do_contact_address->country = $contact_address->country;
$do_contact_address->state = $contact_address->state;
$do_contact_address->street = $contact_address->street;
$do_contact_address->zipcode = $contact_address->zipcode;
$do_contact_address->idcontact = $lastInsertedContId;
$do_contact_address->address = $contact_address->address;
$do_contact_address->address_type = $contact_address->address_type;
$do_contact_address->add();
$do_contact_address->free();
}
}
/**
*Contact Email
*/
$ce_cnt = count($contact->contact_email);
if ($ce_cnt) {
for ($ce_cnt_i = 0; $ce_cnt_i < $ce_cnt; $ce_cnt_i++) {
$do_contact_email = new ContactEmail();
$contact_email = $contact->contact_email[$ce_cnt_i];
$do_contact_email->idcontact = $lastInsertedContId;
$do_contact_email->email_address = $contact_email->email_address;
$do_contact_email->email_type = $contact_email->email_type;
$do_contact_email->email_isdefault = $contact_email->email_isdefault;
$do_contact_email->add();
$do_contact_email->free();
}
}
/**
*Contact Phone
*/
$cp_cnt = count($contact->contact_phone);
if ($cp_cnt) {
for ($cp_cnt_i = 0; $cp_cnt_i < $cp_cnt; $cp_cnt_i++) {
$do_contact_phone = new ContactPhone();
$contact_phone = $contact->contact_phone[$cp_cnt_i];
$do_contact_phone->phone_number = $contact_phone->phone_number;
$do_contact_phone->phone_type = $contact_phone->phone_type;
$do_contact_phone->idcontact = $lastInsertedContId;
$do_contact_phone->add();
$do_contact_phone->free();
}
}
/**
*Contact Note
*/
$cn_cnt = count($contact->contact_note);
if ($cn_cnt) {
for ($cn_cnt_i = 0; $cn_cnt_i < $cn_cnt; $cn_cnt_i++) {
$do_contact_note = new ContactNotes();
$contact_note = $contact->contact_note[$cn_cnt_i];
$do_contact_note->idcontact = $lastInsertedContId;
$do_contact_note->note = $contact_note->note;
$do_contact_note->date_added = $contact_note->date_added;
$do_contact_note->document = $contact_note->document;
$do_contact_note->idcompany = $contact_note->idcompany;
$do_contact_note->iduser = $_SESSION['do_User']->iduser;
$do_contact_note->priority = $contact_note->priority;
$do_contact_note->send_email = $contact_note->send_email;
$do_contact_note->hours_work = $contact_note->hours_work;
$do_contact_note->note_visibility = $contact_note->note_visibility;
$do_contact_note->type = $contact_note->type;
$do_contact_note->add();
$do_contact_note->free();
}
}
/**
*Contact Tag
*/
$ctag_cnt = count($contact->contact_tag);
if ($ctag_cnt) {
for ($ctag_cnt_i = 0; $ctag_cnt_i < $ctag_cnt; $ctag_cnt_i++) {
$do_tag = new Tag();
$contact_tag = $contact->contact_tag[$ctag_cnt_i];
$do_tag->tag_name = $contact_tag->tag_name;
$do_tag->iduser = $_SESSION['do_User']->iduser;
$do_tag->reference_type = $contact_tag->reference_type;
$do_tag->idreference = $lastInsertedContId;
$do_tag->date_added = $contact_tag->date_added;
$do_tag->add();
$do_tag->free();
}
}
/**
*Contact tasks which are not associated with Project
*/
//Contact tasks which are not associated with Project
$ctwop_cnt = count($contact->contact_task_without_project);
if ($ctwop_cnt) {
for ($ctwop_cnt_i = 0; $ctwop_cnt_i < $ctwop_cnt; $ctwop_cnt_i++) {
$do_task = new Task();
$contact_task_wo_p = $contact->contact_task_without_project[$ctwop_cnt_i];
$do_task->task_description = $contact_task_wo_p->task_description;
$do_task->due_date = $contact_task_wo_p->due_date;
$do_task->category = $contact_task_wo_p->category;
$do_task->iduser = $_SESSION['do_User']->iduser;
$do_task->due_date_dateformat = $contact_task_wo_p->due_date_dateformat;
$do_task->status = $contact_task_wo_p->status;
$do_task->date_completed = $contact_task_wo_p->date_completed;
$do_task->idcontact = $lastInsertedContId;
$do_task->from_note = $contact_task_wo_p->from_note;
$do_task->is_sp_date_set = $contact_task_wo_p->is_sp_date_set;
$do_task->task_category = $contact_task_wo_p->task_category;
$do_task->add();
$do_task->free();
}
}
/**
*Contact tasks which are associated with Project
*/
$arr_prj = array();
$cont_task_with_prj_cnt = count($contact->contact_task_with_project);
if ($cont_task_with_prj_cnt) {
for ($i = 0; $i < $cont_task_with_prj_cnt; $i++) {
$do_project = new Project();
$project = $contact->contact_task_with_project[$i];
$do_project->iduser = $_SESSION['do_User']->iduser;
$do_project->name = $project->name;
$do_project->end_date_dateformat = $project->end_date_dateformat;
$do_project->idcompany = $project->idcompany;
$do_project->status = $project->status;
$do_project->effort_estimated_hrs = $project->effort_estimated_hrs;
$do_project->is_public = $project->is_public;
$do_project->add();
$lastInsertedPrjId = $do_project->getPrimaryKeyValue();
//$arr_prj[$lastInsertedPrjId] = $project->idproject;
$pt_cnt = count($project->project_task);
if ($pt_cnt) {
for ($pt_cnt_i = 0; $pt_cnt_i < $pt_cnt; $pt_cnt_i++) {
$do_task = new Task();
$project_task = $project->project_task[$pt_cnt_i];
$do_task->task_description = $project_task->task_description;
$do_task->due_date = $project_task->due_date;
$do_task->category = $project_task->category;
$do_task->iduser = $_SESSION['do_User']->iduser;
$do_task->due_date_dateformat = $project_task->due_date_dateformat;
$do_task->status = $project_task->status;
$do_task->date_completed = $project_task->date_completed;
$do_task->idcontact = $lastInsertedContId;
$do_task->from_note = $project_task->from_note;
$do_task->is_sp_date_set = $project_task->is_sp_date_set;
$do_task->task_category = $project_task->task_category;
$do_task->add();
$lastInsertedTaskId = $do_task->getPrimaryKeyValue();
$do_project_task = new ProjectTask();
$do_project_task->idtask = $lastInsertedTaskId;
$do_project_task->idproject = $lastInsertedPrjId;
$do_project_task->progress = $project_task->progress;
$do_project_task->drop_box_code = $project_task->drop_box_code;
$do_project_task->priority = $project_task->priority;
$do_project_task->hrs_work_expected = $project_task->hrs_work_expected;
$do_project_task->add();
$lastInsertedPrjTaskId = $do_project_task->getPrimaryKeyValue();
$pd_cnt = count($project_task->project_discuss);
if ($pd_cnt) {
for ($i = 0; $i < $pd_cnt; $i++) {
$do_project_discuss = new ProjectDiscuss();
$project_discuss = $project_task->project_discuss[$i];
$do_project_discuss->idproject_task = $lastInsertedPrjTaskId;
$do_project_discuss->idtask = $lastInsertedTaskId;
$do_project_discuss->idproject = $lastInsertedPrjId;
$do_project_discuss->discuss = $project_discuss->discuss;
$do_project_discuss->date_added = $project_discuss->date_added;
$do_project_discuss->document = $project_discuss->document;
$do_project_discuss->iduser = $_SESSION['do_User']->iduser;
$do_project_discuss->drop_box_sender = $project_discuss->drop_box_sender;
$do_project_discuss->priority = $project_discuss->priority;
$do_project_discuss->hours_work = $project_discuss->hours_work;
$do_project_discuss->discuss_edit_access = $project_discuss->discuss_edit_access;
$do_project_discuss->type = $project_discuss->type;
$do_project_discuss->add();
$do_project_discuss->free();
}
}
$do_project_task->free();
$do_task->free();
}
}
$do_project->free();
}
}
/**
*Invoice import
*/
$msg_inv = "";
$inv_cnt = count($contact->invoice);
if ($inv_cnt) {
for ($inv_cnt_i = 0; $inv_cnt_i < $inv_cnt; $inv_cnt_i++) {
$do_invoice = new Invoice();
$invoice = $contact->invoice[$inv_cnt_i];
$do_invoice->num = $invoice->num;
$do_invoice->iduser = $_SESSION['do_User']->iduser;
$do_invoice->description = $invoice->description;
$do_invoice->amount = $invoice->amount;
$do_invoice->datepaid = $invoice->datepaid;
$do_invoice->datecreated = $invoice->datecreated;
$do_invoice->status = $invoice->status;
$do_invoice->discount = $invoice->discount;
$do_invoice->idcontact = $lastInsertedContId;
$do_invoice->due_date = $invoice->due_date;
$do_invoice->invoice_address = $invoice->invoice_address;
$do_invoice->invoice_term = $invoice->invoice_term;
$do_invoice->invoice_note = $invoice->invoice_note;
$do_invoice->sub_total = $invoice->sub_total;
$do_invoice->net_total = $invoice->net_total;
$do_invoice->amt_due = $invoice->amt_due;
$do_invoice->idcompany = $invoice->idcompany;
$do_invoice->tax = $invoice->tax;
$do_invoice->set_delete = $invoice->set_delete;
$do_invoice->total_discounted_amt = $invoice->total_discounted_amt;
$do_invoice->total_taxed_amount = $invoice->total_taxed_amount;
$do_invoice->add();
$lastInsertedInvoiceId = $do_invoice->getPrimaryKeyValue();
$invline_cnt = count($invoice->invoiceline);
if ($invline_cnt) {
for ($invline_cnt_i = 0; $invline_cnt_i < $invline_cnt; $invline_cnt_i++) {
$do_invoiceline = new InvoiceLine();
$invoiceline = $invoice->invoiceline[$invline_cnt_i];
$do_invoiceline->idinvoice = $lastInsertedInvoiceId;
$do_invoiceline->description = $invoiceline->description;
$do_invoiceline->price = $invoiceline->price;
$do_invoiceline->qty = $invoiceline->qty;
$do_invoiceline->total = $invoiceline->total;
$do_invoiceline->item = $invoiceline->item;
$do_invoiceline->line_tax = $invoiceline->line_tax;
$do_invoiceline->discounted_amount = $invoiceline->discounted_amount;
$do_invoiceline->taxed_amount = $invoiceline->taxed_amount;
$do_invoiceline->add();
$do_invoiceline->free();
}
}
//invoiceline import ends
// recurrentinvoice
$recinv_cnt = count($invoice->recurrentinvoice);
if ($recinv_cnt) {
for ($recinv_cnt_i = 0; $recinv_cnt_i < $recinv_cnt; $recinv_cnt_i++) {
$do_recurrentinvoice = new RecurrentInvoice();
$recurrentinvoice = $invoice->recurrentinvoice[$recinv_cnt_i];
$do_recurrentinvoice->iduser = $_SESSION['do_User']->iduser;
$do_recurrentinvoice->idinvoice = $lastInsertedInvoiceId;
$do_recurrentinvoice->nextdate = $recurrentinvoice->nextdate;
$do_recurrentinvoice->recurrence = $recurrentinvoice->recurrence;
$do_recurrentinvoice->recurrencetype = $recurrentinvoice->recurrencetype;
$do_recurrentinvoice->add();
$do_recurrentinvoice->free();
}
}
//recurrentinvoice import ends
// Payment Log import
$paymentlog_cnt = count($invoice->paymentlog);
if ($paymentlog_cnt) {
for ($paymentlog_cnt_i = 0; $paymentlog_cnt_i < $paymentlog_cnt; $paymentlog_cnt_i++) {
$do_paymentlog = new PaymentLog();
$paymentlog = $invoice->paymentlog[$paymentlog_cnt_i];
$do_paymentlog->timestamp = $paymentlog->timestamp;
$do_paymentlog->idinvoice = $lastInsertedInvoiceId;
$do_paymentlog->amount = $paymentlog->amount;
$do_paymentlog->payment_type = $paymentlog->payment_type;
$do_paymentlog->ref_num = $paymentlog->ref_num;
$do_paymentlog->date_added = $paymentlog->date_added;
$do_paymentlog->add();
$lastInsertedPaymentLogId = $do_paymentlog->getPrimaryKeyValue();
//payment_invoice : Payment Invoice import
$paymentinv_cnt = count($paymentlog->payment_invoice);
if ($paymentinv_cnt) {
for ($paymentinv_cnt_i = 0; $paymentinv_cnt_i < $paymentinv_cnt; $paymentinv_cnt_i++) {
$do_payment_invoice = new PaymentInvoice();
$paymentinvoice = $paymentlog->payment_invoice[$paymentinv_cnt_i];
$do_payment_invoice->idpayment = $lastInsertedPaymentLogId;
$do_payment_invoice->idinvoice = $lastInsertedInvoiceId;
$do_payment_invoice->amount = $paymentinvoice->amount;
$do_payment_invoice->add();
$do_payment_invoice->free();
}
}
// payment_invoice import ends
//paymentlog_extra_amount import
$paymentlog_ext_amt_cnt = count($paymentlog->paymentlog_extra_amount);
if ($paymentlog_ext_amt_cnt) {
for ($paymentlog_ext_amt_cnt_i = 0; $paymentlog_ext_amt_cnt_i < $paymentlog_ext_amt_cnt; $paymentlog_ext_amt_cnt_i++) {
$paymentlog_extra_amount = $paymentlog->paymentlog_extra_amount[$paymentlog_ext_amt_cnt_i];
$q = new sqlQuery($GLOBALS['conx']);
$query = "INSERT INTO paymentlog_extra_amount (`idpaymentlog`,`extra_amt`,`iduser`)\n VALUES (" . $lastInsertedPaymentLogId . "," . $paymentlog_extra_amount->extra_amt . "," . $_SESSION['do_User']->iduser . ")\n ";
$q->query($query);
$q->free();
}
}
// paymentlog_extra_amount import ends
$do_paymentlog->free();
}
}
//Payment Log import ends
$msg_inv = ", Invoices";
$do_invoice->free();
}
}
// Invoice import ends
/************************************************************************************************************************/
$do_contact->free();
}
$msg = "Your Contacts" . $msg_inv;
}
/**
*Company insert
*/
$compani_id = array();
$lastInsertedCompani_id = array();
$companies_cnt = count($xml->companies);
if ($companies_cnt) {
for ($i = 0; $i < $companies_cnt; $i++) {
$do_company = new Company();
$company = $xml->companies[$i];
array_push($compani_id, "{$company->idcompany}");
// $do_company->idcompany=$company->idcompany;
$do_company->name = $company->name;
$do_company->iduser = $_SESSION['do_User']->iduser;
$do_company->add();
array_push($lastInsertedCompani_id, $do_company->getPrimaryKeyValue());
$do_company->free();
}
}
//tasks which are neither associated with Contact nor with project
$task_wop_cnt = count($xml->task_without_project);
if ($task_wop_cnt) {
for ($i = 0; $i < $task_wop_cnt; $i++) {
$do_task = new Task();
$task_wop = $xml->task_without_project[$i];
$do_task->task_description = $task_wop->task_description;
$do_task->due_date = $task_wop->due_date;
$do_task->category = $task_wop->category;
$do_task->iduser = $_SESSION['do_User']->iduser;
$do_task->due_date_dateformat = $task_wop->due_date_dateformat;
$do_task->status = $task_wop->status;
$do_task->date_completed = $task_wop->date_completed;
$do_task->idcontact = $task_wop->idcontact;
//it would be 0 since not associated with contact.
$do_task->from_note = $task_wop->from_note;
$do_task->is_sp_date_set = $task_wop->is_sp_date_set;
$do_task->task_category = $task_wop->task_category;
$do_task->add();
$do_task->free();
}
$msg .= ", Tasks";
}
//tasks which are associated with Project
$prj_cnt = count($xml->project);
if ($prj_cnt) {
for ($i = 0; $i < $prj_cnt; $i++) {
$do_project = new Project();
$project = $xml->project[$i];
$do_project->iduser = $_SESSION['do_User']->iduser;
$do_project->name = $project->name;
$do_project->end_date_dateformat = $project->end_date_dateformat;
$do_project->idcompany = $project->idcompany;
$do_project->status = $project->status;
$do_project->effort_estimated_hrs = $project->effort_estimated_hrs;
$do_project->is_public = $project->is_public;
$do_project->add();
$lastInsertedPrjId = $do_project->getPrimaryKeyValue();
$pt_cnt = count($project->project_task);
if ($pt_cnt) {
for ($pt_cnt_i = 0; $pt_cnt_i < $pt_cnt; $pt_cnt_i++) {
$do_task = new Task();
$project_task = $project->project_task[$pt_cnt_i];
$do_task->task_description = $project_task->task_description;
$do_task->due_date = $project_task->due_date;
$do_task->category = $project_task->category;
$do_task->iduser = $_SESSION['do_User']->iduser;
$do_task->due_date_dateformat = $project_task->due_date_dateformat;
$do_task->status = $project_task->status;
$do_task->date_completed = $project_task->date_completed;
$do_task->idcontact = $project_task->idcontact;
$do_task->from_note = $project_task->from_note;
$do_task->is_sp_date_set = $project_task->is_sp_date_set;
$do_task->task_category = $project_task->task_category;
$do_task->add();
$lastInsertedTskId = $do_task->getPrimaryKeyValue();
$q = new sqlQuery($GLOBALS['conx']);
if ($project_task->progress == '') {
$project_task_progress = 0;
} else {
$project_task_progress = $project_task->progress;
}
$sql = "INSERT INTO \n\t\t\tproject_task (idtask, idproject, progress,drop_box_code,priority,hrs_work_expected) \n\t\t\tVALUES ({$lastInsertedTskId},{$lastInsertedPrjId},{$project_task_progress},{$project_task->drop_box_code},{$project_task->priority},{$project_task->hrs_work_expected})";
echo $sql;
echo "<br>";
$q->query($sql);
$lastInsertedPrjTaskId = $q->getInsertId('project_task', 'idproject_task');
$pd_cnt = count($project_task->project_discuss);
if ($pd_cnt) {
for ($pd_cnt_i = 0; $pd_cnt_i < $pd_cnt; $pd_cnt_i++) {
$do_project_discuss = new ProjectDiscuss();
$project_discuss = $project_task->project_discuss[$pd_cnt_i];
$do_project_discuss->idproject_task = $lastInsertedPrjTaskId;
$do_project_discuss->idtask = $lastInsertedTskId;
$do_project_discuss->idproject = $lastInsertedPrjId;
$do_project_discuss->discuss = $project_discuss->discuss;
$do_project_discuss->date_added = $project_discuss->date_added;
$do_project_discuss->document = $project_discuss->document;
$do_project_discuss->iduser = $_SESSION['do_User']->iduser;
$do_project_discuss->drop_box_sender = $project_discuss->drop_box_sender;
$do_project_discuss->priority = $project_discuss->priority;
$do_project_discuss->hours_work = $project_discuss->hours_work;
$do_project_discuss->discuss_edit_access = $project_discuss->discuss_edit_access;
$do_project_discuss->type = $project_discuss->type;
$do_project_discuss->add();
$do_project_discuss->free();
}
}
// $do_project_task->free();
$do_task->free();
}
}
$do_project->free();
}
$compani_id_cnt = count($compani_id);
if ($compani_id_cnt) {
$j = 0;
foreach ($compani_id as $cmp_id) {
$q = new sqlQuery($GLOBALS['conx']);
$sql = "UPDATE contact SET idcompany ={$lastInsertedCompani_id[$j]} WHERE iduser={$_SESSION['do_User']->iduser} AND idcompany ={$cmp_id}";
$q->query($sql);
$sql1 = "UPDATE invoice SET idcompany ={$lastInsertedCompani_id[$j]} WHERE iduser={$_SESSION['do_User']->iduser} AND idcompany ={$cmp_id}";
$q->query($sql1);
$sql2 = "UPDATE project SET idcompany ={$lastInsertedCompani_id[$j]} WHERE iduser={$_SESSION['do_User']->iduser} AND idcompany ={$cmp_id}";
$q->query($sql2);
$q->free();
$j++;
}
}
$do_create_usrtbl = new ContactView();
$do_create_usrtbl->rebuildContactUserTable($_SESSION['do_User']->iduser);
$msg .= " and Projects have been imported successfully.";
}
} else {
$msg = "Sorry! The data could not be imported.";
}
} else {
$msg = "Sorry! Could not find the uploaded file.";
}
}
$_SESSION['in_page_message'] = $msg;
}
function eventImportContactsFromCsv(EventControler $eventcontroler)
{
$iduser = $eventcontroler->iduser;
$handle = fopen($eventcontroler->targetpath, "r");
$row = 1;
while ($data = fgetcsv($handle)) {
$contact_firstname = "";
$contact_lastname = "";
$contact_company = "";
$company = "";
$contact_position = "";
$contact_summary = "";
$contact_birthday = "";
$contact_city = "";
$contact_state = "";
$contact_street = "";
$contact_zipcode = "";
$contact_country = "";
$contact_address_hm = "";
$contact_address_hm_type = "";
$contact_address_wk = "";
$contact_address_wk_type = "";
$contact_address_ot = "";
$contact_address_ot_type = "";
$contact_email_hm = "";
$contact_email_hm_type = "";
$contact_email_wk = "";
$contact_email_wk_type = "";
$contact_email_ot = "";
$contact_email_ot_type = "";
$contact_phone_hm = "";
$contact_phone_hm_type = "";
$contact_phone_wk = "";
$contact_phone_wk_type = "";
$contact_phone_ot = "";
$contact_phone_ot_type = "";
$contact_phone_mb = "";
$contact_phone_mb_type = "";
$contact_phone_fx = "";
$contact_phone_fx_type = "";
$contact_website_comp = "";
$contact_website_comp_type = "";
$contact_website_blog = "";
$contact_website_blog_type = "";
$contact_website_ot = "";
$contact_website_ot_type = "";
$contact_website_personal = "";
$contact_website_personal_type = "";
$contact_website_twitter = "";
$contact_website_twitter_type = "";
$contact_im_aim_wk = "";
$contact_im_aim_wk_type = "";
$contact_im_aim_per = "";
$contact_im_aim_per_type = "";
$contact_im_aim_ot = "";
$contact_im_aim_ot_type = "";
$im_aim = "";
$contact_im_msn_wk = "";
$contact_im_msn_wk_type = "";
$contact_im_msn_per = "";
$contact_im_msn_per_type = "";
$contact_im_msn_ot = "";
$contact_im_msn_ot_type = "";
$im_msn = "";
$contact_im_icq_wk = "";
$contact_im_icq_wk_type = "";
$contact_im_icq_per = "";
$contact_im_icq_per_type = "";
$contact_im_icq_ot = "";
$contact_im_icq_ot_type = "";
$im_icq = "";
$contact_im_jabber_wk = "";
$contact_im_jabber_wk_type = "";
$contact_im_jabber_per = "";
$contact_im_jabber_per_type = "";
$contact_im_jabber_ot = "";
$contact_im_jabber_ot_type = "";
$im_jabber = "";
$contact_im_yahoo_wk = "";
$contact_im_yahoo_wk_type = "";
$contact_im_yahoo_per = "";
$contact_im_yahoo_per_type = "";
$contact_im_yahoo_ot = "";
$contact_im_yahoo_ot_type = "";
$im_yahoo = "";
$contact_im_skype_wk = "";
$contact_im_skype_wk_type = "";
$contact_im_skype_per = "";
$contact_im_skype_per_type = "";
$contact_im_skype_ot = "";
$contact_im_skype_ot_type = "";
$im_skype = "";
$contact_im_gt_wk = "";
$contact_im_gt_wk_type = "";
$contact_im_gt_per = "";
$contact_im_gt_per_type = "";
$contact_im_gt_ot = "";
$contact_im_gt_ot_type = "";
$im_gt = "";
$contact_note = "";
$do_contact = new Contact();
$do_company = new Company();
$do_contact_notes = new ContactNotes();
$num = count($data);
if ($row > 1) {
for ($c = 0; $c < $num; $c++) {
switch ($eventcontroler->fields[$c]) {
case "firstname":
$contact_firstname = $data[$c];
break;
case "lastname":
$contact_lastname = $data[$c];
break;
case "company":
$company = $data[$c];
$contact_company = $data[$c];
break;
case "position":
$contact_position = $data[$c];
break;
case "summary":
$contact_summary = $data[$c];
break;
case "birthday":
$contact_birthday = $data[$c];
break;
case "city":
$contact_city = $data[$c];
break;
case "state":
$contact_state = $data[$c];
break;
case "street":
$contact_street = $data[$c];
break;
case "zipcode":
$contact_zipcode = $data[$c];
break;
case "country":
$contact_country = $data[$c];
break;
case "address_hm":
$contact_address_hm = $data[$c];
$contact_address_hm_type = "Home";
break;
case "address_wk":
$contact_address_wk = $data[$c];
$contact_address_wk_type = "Work";
break;
case "address_ot":
$contact_address_ot = $data[$c];
$contact_address_ot_type = "Other";
break;
case "email_hm":
$contact_email_hm = $data[$c];
$contact_email_hm_type = "Home";
break;
case "email_wk":
$contact_email_wk = $data[$c];
$contact_email_wk_type = "Work";
break;
case "email_ot":
$contact_email_ot = $data[$c];
$contact_email_ot_type = "Other";
break;
case "phone_number_hm":
$contact_phone_hm = $data[$c];
$contact_phone_hm_type = "Home";
break;
case "phone_number_wk":
$contact_phone_wk = $data[$c];
$contact_phone_wk_type = "Work";
break;
case "phone_number_ot":
$contact_phone_ot = $data[$c];
$contact_phone_ot_type = "Other";
break;
case "phone_number_mb":
$contact_phone_mb = $data[$c];
$contact_phone_mb_type = "Mobile";
break;
case "phone_number_fx":
$contact_phone_fx = $data[$c];
$contact_phone_fx_type = "Fax";
break;
case "website_comp":
$contact_website_comp = $data[$c];
$contact_website_comp_type = "Company";
break;
case "website_blog":
$contact_website_blog = $data[$c];
$contact_website_blog_type = "Blog";
break;
case "website_ot":
$contact_website_ot = $data[$c];
$contact_website_ot_type = "Other";
break;
case "website_personal":
$contact_website_personal = $data[$c];
$contact_website_personal_type = "Personal";
break;
case "website_twitter":
$contact_website_twitter = $data[$c];
$contact_website_twitter_type = "Twitter";
break;
case "website_linkedin":
$contact_website_linkedin = $data[$c];
$contact_website_linkedin_type = "LinkedIn";
break;
case "website_fb":
$contact_website_fb = $data[$c];
$contact_website_fb_type = "Facebook";
break;
case "im_aim_wk":
$contact_im_aim_wk = $data[$c];
$im_aim = "AIM";
$contact_im_aim_wk_type = "Work";
break;
case "im_aim_per":
$contact_im_aim_per = $data[$c];
$im_aim = "AIM";
$contact_im_aim_per_type = "Personal";
break;
case "im_aim_ot":
$contact_im_aim_ot = $data[$c];
$im_aim = "AIM";
$contact_im_aim_ot_type = "Other";
break;
case "im_msn_wk":
$contact_im_msn_wk = $data[$c];
$im_msn = "MSN";
$contact_im_msn_wk_type = "Work";
break;
case "im_msn_per":
$contact_im_msn_per = $data[$c];
$im_msn = "MSN";
$contact_im_msn_per_type = "Personal";
break;
case "im_msn_ot":
$contact_im_msn_ot = $data[$c];
$im_msn = "MSN";
$contact_im_msn_ot_type = "Other";
break;
case "im_icq_wk":
$contact_im_icq_wk = $data[$c];
$im_icq = "ICQ";
$contact_im_icq_wk_type = "Work";
break;
case "im_icq_per":
$contact_im_icq_per = $data[$c];
$im_icq = "ICQ";
$contact_im_icq_per_type = "Personal";
break;
case "im_icq_ot":
$contact_im_icq_ot = $data[$c];
$im_icq = "ICQ";
$contact_im_icq_ot_type = "Other";
break;
case "im_jabber_wk":
$contact_im_jabber_wk = $data[$c];
$im_jabber = "Jabber";
$contact_im_jabber_wk_type = "Work";
break;
case "im_jabber_per":
$contact_im_jabber_per = $data[$c];
$im_jabber = "Jabber";
$contact_im_jabber_per_type = "Personal";
break;
case "im_jabber_ot":
$contact_im_jabber_ot = $data[$c];
$im_jabber = "Jabber";
$contact_im_jabber_ot_type = "Other";
case "im_yahoo_wk":
$contact_im_yahoo_wk = $data[$c];
$im_yahoo = "Yahoo";
$contact_im_yahoo_wk_type = "Work";
break;
case "im_yahoo_per":
$contact_im_yahoo_per = $data[$c];
$im_yahoo = "Yahoo";
$contact_im_yahoo_per_type = "Personal";
break;
case "im_yahoo_ot":
$contact_im_yahoo_ot = $data[$c];
$im_yahoo = "Yahoo";
$contact_im_yahoo_ot_type = "Other";
break;
case "im_skype_wk":
$contact_im_skype_wk = $data[$c];
$im_skype = "Skype";
$contact_im_skype_wk_type = "Work";
break;
case "im_skype_per":
$contact_im_skype_per = $data[$c];
$im_skype = "Skype";
$contact_im_skype_per_type = "Personal";
break;
case "im_skype_ot":
$contact_im_skype_ot = $data[$c];
$im_skype = "Skype";
$contact_im_skype_ot_type = "Other";
case "im_gt_wk":
$contact_im_gt_wk = $data[$c];
$im_gt = "Google Talk";
$contact_im_gt_wk_type = "Work";
break;
case "im_gt_per":
$contact_im_gt_per = $data[$c];
$im_gt = "Google Talk";
$contact_im_gt_per_type = "Personal";
break;
case "im_gt_ot":
$contact_im_gt_ot = $data[$c];
$im_gt = "Google Talk";
$contact_im_gt_ot_type = "Other";
break;
case "note":
$contact_note .= "<p>" . $data[$c] . "</p>";
break;
}
}
$do_company->name = $company;
$do_company->iduser = $iduser;
$do_company->add();
$idcompany = $do_company->getPrimaryKeyValue();
$do_contact->idcompany = $idcompany;
$do_contact->iduser = $iduser;
$do_contact->firstname = $contact_firstname;
$do_contact->lastname = $contact_lastname;
$do_contact->company = $contact_company;
$do_contact->position = $contact_position;
$do_contact->summary = $contact_summary;
$do_contact->birthday = $contact_birthday;
$do_contact->add();
$idcontact = $do_contact->getPrimaryKeyValue();
//In theory this below should not be needed
$do_contact->idcontact = $idcontact;
$do_tag = new Tag();
if (strpos($_SESSION['import_tag'], ",") === false) {
$do_tag->addTagAssociation($idcontact, trim($_SESSION['import_tag']), "contact", $_SESSION['do_User']->iduser);
} else {
$tags = explode(",", $_SESSION['import_tag']);
foreach ($tags as $tag) {
$do_tag->addTagAssociation($idcontact, trim($tag), "contact", $_SESSION['do_User']->iduser);
}
}
if ($contact_address_hm != "" || $contact_city != "" || $contact_state != "" || $contact_street != "" || $contact_zipcode != "" || $contact_country != "") {
$do_contact->addAddress($contact_address_hm, $contact_address_hm_type, $contact_city, $contact_state, $contact_street, $contact_zipcode, $contact_country);
}
if ($contact_address_wk != "" || $contact_city != "" || $contact_state != "" || $contact_street != "" || $contact_zipcode != "" || $contact_country != "") {
$do_contact->addAddress($contact_address_wk, $contact_address_wk_type, $contact_city, $contact_state, $contact_street, $contact_zipcode, $contact_country);
}
if ($contact_address_ot != "" || $contact_city != "" || $contact_state != "" || $contact_street != "" || $contact_zipcode != "" || $contact_country != "") {
$do_contact->addAddress($contact_address_ot, $contact_address_ot_type, $contact_city, $contact_state, $contact_street, $contact_zipcode, $contact_country);
}
if ($contact_email_hm != "") {
$do_contact->addEmail($contact_email_hm, $contact_email_hm_type);
}
if ($contact_email_wk != "") {
$do_contact->addEmail($contact_email_wk, $contact_email_wk_type);
}
if ($contact_email_ot != "") {
$do_contact->addEmail($contact_email_ot, $contact_email_ot_type);
}
if ($contact_phone_hm != "") {
$do_contact->addPhone($contact_phone_hm, $contact_phone_hm_type);
}
if ($contact_phone_wk != "") {
$do_contact->addPhone($contact_phone_wk, $contact_phone_wk_type);
}
if ($contact_phone_ot != "") {
$do_contact->addPhone($contact_phone_ot, $contact_phone_ot_type);
}
if ($contact_phone_mb != "") {
$do_contact->addPhone($contact_phone_mb, $contact_phone_mb_type);
}
if ($contact_phone_fx != "") {
$do_contact->addPhone($contact_phone_fx, $contact_phone_fx_type);
}
if ($contact_website_comp != "") {
$do_contact->addWebsite($contact_website_comp, $contact_website_comp_type);
}
if ($contact_website_blog != "") {
$do_contact->addWebsite($contact_website_blog, $contact_website_blog_type);
}
if ($contact_website_ot != "") {
$do_contact->addWebsite($contact_website_ot, $contact_website_ot_type);
}
if ($contact_website_personal != "") {
$do_contact->addWebsite($contact_website_personal, $contact_website_personal_type);
}
if ($contact_website_twitter != "") {
$do_contact->addWebsite($contact_website_twitter, $contact_website_twitter_type);
}
if ($contact_website_linkedin != "") {
$do_contact->addWebsite($contact_website_linkedin, $contact_website_linkedin_type);
}
if ($contact_website_fb != "") {
$do_contact->addWebsite($contact_website_fb, $contact_website_fb_type);
}
if ($contact_im_aim_wk != "") {
$do_contact->addIM($im_aim, $contact_im_aim_wk_type, $contact_im_aim_wk);
}
if ($contact_im_aim_per != "") {
$do_contact->addIM($im_aim, $contact_im_aim_per_type, $contact_im_aim_per);
}
if ($contact_im_aim_ot != "") {
$do_contact->addIM($im_aim, $contact_im_aim_ot_type, $contact_im_aim_ot);
}
if ($contact_im_msn_wk != "") {
$do_contact->addIM($im_msn, $contact_im_msn_wk_type, $contact_im_msn_wk);
}
if ($contact_im_msn_per != "") {
$do_contact->addIM($im_msn, $contact_im_msn_per_type, $contact_im_msn_per);
}
if ($contact_im_msn_ot != "") {
$do_contact->addIM($im_msn, $contact_im_msn_ot_type, $contact_im_msn_ot);
}
if ($contact_im_icq_wk != "") {
$do_contact->addIM($im_icq, $contact_im_icq_wk_type, $contact_im_icq_wk);
}
if ($contact_im_icq_per != "") {
$do_contact->addIM($im_icq, $contact_im_icq_per_type, $contact_im_icq_per);
}
if ($contact_im_icq_ot != "") {
$do_contact->addIM($im_icq, $contact_im_icq_ot_type, $contact_im_icq_ot);
}
if ($contact_im_jabber_wk != "") {
$do_contact->addIM($im_jabber, $contact_im_jabber_wk_type, $contact_im_jabber_wk);
}
if ($contact_im_jabber_per != "") {
$do_contact->addIM($im_jabber, $contact_im_jabber_per_type, $contact_im_jabber_per);
}
if ($contact_im_jabber_ot != "") {
$do_contact->addIM($im_jabber, $contact_im_jabber_ot_type, $contact_im_jabber_ot);
}
if ($contact_im_yahoo_wk != "") {
$do_contact->addIM($im_yahoo, $contact_im_yahoo_wk_type, $contact_im_yahoo_wk);
}
if ($contact_im_yahoo_per != "") {
$do_contact->addIM($im_yahoo, $contact_im_yahoo_per_type, $contact_im_yahoo_per);
}
if ($contact_im_yahoo_ot != "") {
$do_contact->addIM($im_yahoo, $contact_im_yahoo_ot_type, $contact_im_yahoo_ot);
}
if ($contact_im_skype_wk != "") {
$do_contact->addIM($im_skype, $contact_im_skype_wk_type, $contact_im_skype_wk);
}
if ($contact_im_skype_per != "") {
$do_contact->addIM($im_skype, $contact_im_skype_per_type, $contact_im_skype_per);
}
if ($contact_im_skype_ot != "") {
$do_contact->addIM($im_skype, $contact_im_skype_ot_type, $contact_im_skype_ot);
}
if ($contact_im_gt_wk != "") {
$do_contact->addIM($im_gt, $contact_im_gt_wk_type, $contact_im_gt_wk);
}
if ($contact_im_gt_per != "") {
$do_contact->addIM($im_gt, $contact_im_gt_per_type, $contact_im_gt_per);
}
if ($contact_im_gt_ot != "") {
$do_contact->addIM($im_gt, $contact_im_gt_ot_type, $contact_im_gt_ot);
}
if ($contact_note != "") {
$do_contact_notes->idcontact = $idcontact;
$do_contact_notes->iduser = $iduser;
$do_contact_notes->note = $contact_note;
$do_contact_notes->date_added = date('Y-m-d');
$do_contact_notes->add();
}
$do_cont_view = new ContactView();
$do_cont_view->addFromContact($do_contact);
$do_cont_view->updateFromContact($do_contact);
// Added the method call updateFromContact() so that the child data is updated just after insert
$do_cont_view->addTag($_SESSION['import_tag'], $do_contact->idcontact);
// Update the contact view for tags.
$do_contact->free();
$do_company->free();
$do_contact_notes->free();
}
$row++;
}
fclose($handle);
$goto = $eventcontroler->getParam("goto");
$disp = new Display($goto);
$disp->addParam("message", "Contacts have been imported successfully.");
$eventcontroler->setDisplayNext($disp);
}
//$do_company = new Company($GLOBALS['conx']);
//$do_task = new Task($GLOBALS['conx']);
//$do_task_category = new TaskCategory($GLOBALS['conx']);
//$do_contact_task = new Contact();
if (is_object($_SESSION["eDetail_contact"])) {
$idcontact = $_SESSION["eDetail_contact"]->getparam("idcontact");
} elseif (isset($_GET['id'])) {
$idcontact = $_GET['id'];
} elseif ($do_contact->idcontact) {
$idcontact = $do_contact->idcontact;
} elseif (is_object($_SESSION['ContactEditSave'])) {
$idcontact = $_SESSION['ContactEditSave']->idcontact;
}
$do_contact->getContactDetails($idcontact);
if (!is_object($_SESSION['do_sharenotes'])) {
$do_contact_notes = new ContactNotes();
$do_contact_notes->sessionPersistent("do_sharenotes", "index.php", 36000);
}
//echo $_SESSION['do_sharenotes'];
$thistab = 'Welcome';
include_once 'ofuz_navtabs.php';
?>
<div class="content">
<script type="text/javascript">
//<![CDATA[
var openform;
function fnEditTask(task) {
if ($("#e"+openform).length > 0) fnCancelEdit(openform);
openform = task;
$.ajax({
type: "GET",
$secrate_string = "Ofuz is Open Source";
$date = date("YMDH");
$s_string = "{$secrate_string}" . "{$date}";
$secrate_key = MD5($s_string);
//if($key === $secrate_key){
//echo $email;die();
$code_found = false;
$addnote = false;
$addtask = false;
$addprojectnote = false;
$add_project_task = false;
$attachments_extracted = false;
$OfuzEmailFetcher = new OfuzEmailFetcher();
$do_user = new User();
$do_contact = new Contact();
$do_contact_note = new ContactNotes();
$do_contact_email = new ContactEmail();
$do_project = new Project();
$do_project_discuss = new ProjectDiscuss();
//$do_project_task = new ProjectTask();
//$do_task = new Task();
$do_activity = new Activity();
// Take any one as per convinience
//$OfuzEmailFetcher->fetchEmailText('/var/www/ofuz/files/ofuz_catch.log');
$OfuzEmailFetcher->fetchEmailRow($email);
//$OfuzEmailFetcher->fetchEmailStream($stream);
$to = $OfuzEmailFetcher->getToEmail();
$from = $OfuzEmailFetcher->getFromEmail();
$bcc = $OfuzEmailFetcher->getBCCEmail();
$cc = $OfuzEmailFetcher->getCCEmail();
$msg_text = $OfuzEmailFetcher->getMessageBody('text');
function add_note()
{
$max_note_length = 200;
/*
May be need to limit the note text as in
RFC 2068 states:
Servers should be cautious about depending on URI lengths above 255 bytes, because some older client or proxy implementations may not properly support these lengths.
The spec for URL length does not dictate a minimum or maximum URL length, but implementation varies by browser. On Windows: Opera supports ~4050 characters, IE 4.0+ supports exactly 2083 characters, Netscape 3 -> 4.78 support up to 8192 characters before causing errors on shut-down, and Netscape 6 supports ~2000 before causing errors on start-up.
*/
$do_api_contact = new Contact();
if (!$this->idcontact || $this->idcontact == '') {
$this->setMessage("621", "Contact Id Missing");
return false;
} elseif ($this->note == '') {
$this->setMessage("631", "Note Missing");
return false;
} elseif (strlen($this->note) > $max_note_length) {
$msg = 'Note lenght is exceding the limit allowed lenght is ' . $max_note_length . ' characters' . $this->setMessage("632", $msg);
return false;
} elseif (!$do_api_contact->isContactRelatedToUser($this->idcontact, $this->iduser)) {
$this->setMessage("615", "Contact does not belong to you nor shared by your Co-Worker");
return false;
} else {
$do_api_contact_notes = new ContactNotes();
$do_api_contact_notes->addNew();
$do_api_contact_notes->note = $this->note;
$do_api_contact_notes->iduser = $this->iduser;
$do_api_contact_notes->idcontact = $this->idcontact;
$do_api_contact_notes->date_added = date("Y-m-d");
$do_api_contact_notes->note_visibility = $this->note_visibility;
$do_api_contact_notes->add();
$this->setValues(array("msg" => "Note Added", "stat" => "ok", "code" => "636"));
return true;
}
}
</div>
<div class="div_right">
<?php
echo $noteFields->type;
// Hidden Note type and default is 'Note'
echo $e_addContactNote->getFormFooter(_('Add this note'));
echo '</form>';
// closing the form so as other forms can be operative
?>
</div>
<?php
// Deleted Note
$deleted_note = $do_notes->getNotesDataFromDeleted($idcontact, "contact");
if (is_array($deleted_note) && count($deleted_note) > 0) {
$do_cn = new ContactNotes();
echo $do_cn->viewDeletedNote($deleted_note, "ContactNote");
}
?>
<?php
$do_notes->getContactNotes($idcontact);
$do_notes->sessionPersistent("ContactNotes", "contacts.php", OFUZ_TTL);
// Make sure to have the same HTML in autoLoadNotesOnScrollDown() method as below
if ($do_notes->getNumRows()) {
echo '<div class="headline_fuscia">';
printf(_("%s's Notes:"), $do_contact->firstname);
echo '</div>' . "\n";
$note_count = 0;
while ($do_notes->next()) {
if ($do_notes->iduser != $_SESSION['do_User']->iduser) {
if ($do_notes->note_visibility == 'user coworker' || $do_notes->note_visibility == 'user coworker contact') {
function insertNoteForAutoFetchOn()
{
$q = new sqlQuery($this->getDbCon());
$q->query("SELECT * FROM contact_website WHERE feed_auto_fetch = 'Yes' AND website_type <> 'Twitter'");
if ($q->getNumRows()) {
$f_feed = new Feed();
while ($q->fetch()) {
$do_contact_note = new ContactNotes($this->getDbCon());
$this->getId($q->getData("idcontact_website"));
$do_contact = new Contact();
$do_contact->getId($this->idcontact);
//print_r($do_contact);
//exit;
if (!$do_contact->hasData()) {
continue;
}
$do_user = $do_contact->getParentUser();
if (!$do_user->hasData()) {
continue;
}
//print_r($do_user);
//exit;
$website = $q->getData("website");
$website = (substr(ltrim($website), 0, 7) != 'http://' ? 'http://' : '') . $website;
$arr_item = array();
//try {
$arr_items = $f_feed->retrieveSinceLastFetch($website, $q->getData("idcontact_website"));
//}catch(Exception $ex){
// $f_feed->turnFeedOff($q->getData("idcontact_website"));
//}
if (is_array($arr_items)) {
foreach ($arr_items as $arr_item) {
if ($q->getData("feed_last_fetch") < $arr_item[1]) {
$do_contact_note->idcontact = $q->getData("idcontact");
$link = "<br /><a href='" . $website . "' target='_blank'>" . _('Back to the Source of the Article') . "</a><br />";
$search = array('<br />', '<br>', '<br >', '<br/>');
$replace = "\n";
$note_content = $arr_item[0];
$note_content = nl2br(strip_tags($note_content));
$note_content = preg_replace('/(<br[^>]*>\\s*){2,}/', '<br/>', $note_content);
$do_contact_note->note = $note_content . $link;
//$do_contact_note->note = nl2br(strip_tags(str_replace($search, $replace, $arr_item[0]))).$link;
$do_contact_note->date_added = date('Y-m-d');
//$do_contact_note->iduser = $do_contact->getIdUser($q->getData("idcontact"));
$do_contact_note->iduser = $do_user->iduser;
$do_contact_note->type = 'RSS';
//$do_contact_note->iduser = 20;
//$do_contact_note->iduser = $_SESSION['do_User']->iduser;
$do_contact_note->add();
$do_wf_rss_feed_import = new WorkFeedRssFeedImport();
$do_wf_rss_feed_import->addRssFeed($do_contact_note, $website, $note_content);
}
}
}
$this->feed_last_fetch = time();
$this->update();
//$do_contact_note->free();
}
}
}
$q_auto_resp = new sqlQuery($GLOBALS['conx']);
/*$sql_auto_resp = "SELECT ar.name,arem.subject FROM autoresponder AS ar
INNER JOIN autoresponder_email AS arem ON ar.idautoresponder = arem.idautoresponder
WHERE ar.iduser = {$iduser} AND ar.tag_name = '{$tag_name}'";*/
$sql_auto_resp = "SELECT `name` FROM autoresponder\n WHERE iduser = {$iduser} AND tag_name = '{$tag_name}'";
$q_auto_resp->query($sql_auto_resp);
$responder = "";
$resp_email_subj = "";
if ($q_auto_resp->getNumRows()) {
$q_auto_resp->fetch();
$responder = $q_auto_resp->getData("name");
//$resp_email_subj = $q_auto_resp->getData("subject");
} else {
$message = 'already_unsub_from_list';
}
$do_cont_note = new ContactNotes();
$do_cont_note->addNew();
$do_cont_note->idcontact = $idcontact;
$do_cont_note->note = $firstname . " " . $lastname . " has unsubscribed from the autoresponder series called " . $responder;
$do_cont_note->date_added = date("Y-m-d");
$do_cont_note->iduser = $iduser;
$do_cont_note->add();
$do_workfeed_uns = new WorkFeedContactUnsubscibeEmails();
$do_workfeed_uns->addUnsubscribeEmailWorkfeed($do_cont_note, $responder);
$q = new sqlQuery($GLOBALS['conx']);
$sql = "DELETE FROM `tag` WHERE iduser={$iduser} AND idreference={$idcontact} AND idtag={$idtag}";
$q->query($sql);
$do_contact_view = new ContactView();
$do_contact_view->setUser($iduser);
$do_contact_view->deleteTag($do_tag->tag_name, $idcontact);
//$message = $firstname." ".$lastname.' '._('you have successfully unsubscribed from the autoresponder series called').' '.$responder;
<?php
/** Ofuz Open Source version is released under the GNU Affero General Public License, please read the full license at: http://www.gnu.org/licenses/agpl-3.0.html **/
// Copyright 2008 - 2010 all rights reserved, SQLFusion LLC, info@sqlfusion.com
/** Ofuz Open Source version is released under the GNU Affero General Public License, please read the full license at: http://www.gnu.org/licenses/agpl-3.0.html **/
$pageTitle = 'Ofuz';
$Author = 'SQLFusion LLC';
$Keywords = 'Keywords for search engine';
$Description = 'Description for search engine';
$background_color = 'white';
include_once 'config.php';
include_once 'includes/ofuz_check_access.script.inc.php';
include_once 'includes/header.inc.php';
$do_notes = new ContactNotes($GLOBALS['conx']);
$do_contact = new Contact($GLOBALS['conx']);
$do_company = new Company($GLOBALS['conx']);
$do_task = new Task($GLOBALS['conx']);
$do_task_category = new TaskCategory($GLOBALS['conx']);
$do_contact_task = new Contact();
$do_notes->sessionPersistent("ContactNotesEditSave", "index.php", 3600);
$thistab = 'Welcome';
include_once 'i_ofuz_navtabs.php';
?>
<div class="content">
<script type="text/javascript">
//<![CDATA[
var openform;
function fnEditTask(task) {
if ($("#e"+openform).length > 0) fnCancelEdit(openform);
openform = task;
$.ajax({
// header("Location: http://www.ofuz.com/");
// exit;
//}
include_once 'includes/ofuz_check_access.script.inc.php';
include_once 'includes/header.inc.php';
$do_notes = new ContactNotes($GLOBALS['conx']);
$do_contact = new Contact($GLOBALS['conx']);
$do_company = new Company($GLOBALS['conx']);
$do_task = new Task($GLOBALS['conx']);
$do_task_category = new TaskCategory($GLOBALS['conx']);
$do_contact_task = new Contact();
$ProjectDiscuss = new ProjectDiscuss();
$ProjectTask = new ProjectTask();
$ProjectDiscuss->sessionPersistent("ProjectDiscuss", "index.php", OFUZ_TTL);
//$do_notes->sessionPersistent("ContactNotesEditSave", "index.php", OFUZ_TTL);
$ContactNoteExpend = new ContactNotes($GLOBALS['conx']);
$ContactNoteExpend->sessionPersistent("ContactNoteExpend", "contacts.php", OFUZ_TTL);
$DiscussNoteExpend = new ProjectDiscuss($GLOBALS['conx']);
$DiscussNoteExpend->sessionPersistent("DiscussNoteExpend", "contacts.php", OFUZ_TTL);
if (!is_object($_SESSION['do_work_feed'])) {
$do_work_feed = new WorkFeed($GLOBALS['conx']);
$do_work_feed->sessionPersistent("do_work_feed", "contacts.php", OFUZ_TTL);
}
$_SESSION['do_work_feed']->sql_qry_start = 0;
$_SESSION['do_work_feed']->getWorkfeedCount();
?>
<script type="text/javascript">
//<