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();
}
}
