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