private function XMLExport($iduser) { $xml = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n\n"; $do_user = new User(); $do_user->getId($iduser); $xml .= "<user>\n"; $xml .= " <iduser><![CDATA[" . $do_user->iduser . "]]></iduser>\n"; $xml .= " <firstname><![CDATA[" . $do_user->firstname . "]]></firstname>\n"; $xml .= " <middlename><![CDATA[" . $do_user->middlename . "]]></middlename>\n"; $xml .= " <lastname><![CDATA[" . $do_user->lastname . "]]></lastname>\n"; $xml .= " <email><![CDATA[" . $do_user->email . "]]></email>\n"; $xml .= " <phone><![CDATA[" . $do_user->phone . "]]></phone>\n"; $xml .= " <company><![CDATA[" . $do_user->company . "]]></company>\n"; $xml .= " <position><![CDATA[" . $do_user->position . "]]></position>\n"; $xml .= " <address1><![CDATA[" . $do_user->address1 . "]]></address1>\n"; $xml .= " <address2><![CDATA[" . $do_user->address2 . "]]></address2>\n"; $xml .= " <city><![CDATA[" . $do_user->city . "]]></city>\n"; $xml .= " <zip><![CDATA[" . $do_user->zip . "]]></zip>\n"; $xml .= " <state><![CDATA[" . $do_user->state . "]]></state>\n"; $xml .= " <country><![CDATA[" . $do_user->country . "]]></country>\n"; $xml .= " <username><![CDATA[" . $do_user->username . "]]></username>\n"; $xml .= " <password><![CDATA[" . $do_user->password . "]]></password>\n"; $xml .= " <isadmin><![CDATA[" . $do_user->isadmin . "]]></isadmin>\n"; $xml .= " <regdate><![CDATA[" . $do_user->regdate . "]]></regdate>\n"; $xml .= " <openid><![CDATA[" . $do_user->openid . "]]></openid>\n"; $xml .= " <last_login><![CDATA[" . $do_user->last_login . "]]></last_login>\n"; $xml .= " <drop_box_code><![CDATA[" . $do_user->drop_box_code . "]]></drop_box_code>\n"; $xml .= " <idcontact><![CDATA[" . $do_user->idcontact . "]]></idcontact>\n"; $xml .= " <fb_user_id><![CDATA[" . $do_user->fb_user_id . "]]></fb_user_id>\n"; $xml .= " <api_key><![CDATA[" . $do_user->api_key . "]]></api_key>\n"; $xml .= " <plan><![CDATA[" . $do_user->plan . "]]></plan>\n"; $xml .= " <status><![CDATA[" . $do_user->status . "]]></status>\n"; $xml .= " <google_openid_identity><![CDATA[" . $do_user->google_openid_identity . "]]></google_openid_identity>\n"; $xml .= "</user>\n"; if (!$this->appendToFile($xml)) { return false; } $xml = ' '; $i = 1; $do_contact = new Contact(); $do_contact->getUserContacts($iduser); $xml .= "<contacts>\n"; while ($do_contact->next()) { set_time_limit(3600); //1 hr $xml .= " <contact>\n"; $xml .= " <idcontact><![CDATA[" . $do_contact->getData("idcontact") . "]]></idcontact>\n"; $xml .= " <firstname><![CDATA[" . $do_contact->getData("firstname") . "]]></firstname>\n"; $xml .= " <lastname><![CDATA[" . $do_contact->getData("lastname") . "]]></lastname>\n"; $xml .= " <position><![CDATA[" . $do_contact->getData("position") . "]]></position>\n"; $xml .= " <company><![CDATA[" . $do_contact->getData("company") . "]]></company>\n"; $xml .= " <idcompany><![CDATA[" . $do_contact->getData("idcompany") . "]]></idcompany>\n"; $xml .= " <iduser><![CDATA[" . $do_contact->getData("iduser") . "]]></iduser>\n"; $xml .= " <picture><![CDATA[" . $do_contact->getData("picture") . "]]></picture>\n"; $xml .= " <summary><![CDATA[" . $do_contact->getData("summary") . "]]></summary>\n"; $xml .= " <birthday><![CDATA[" . $do_contact->getData("birthday") . "]]></birthday>\n"; $xml .= " <portal_code><![CDATA[" . $do_contact->getData("portal_code") . "]]></portal_code>\n"; $xml .= " <fb_userid><![CDATA[" . $do_contact->getData("fb_userid") . "]]></fb_userid>\n"; $xml .= " <tw_user_id><![CDATA[" . $do_contact->getData("tw_user_id") . "]]></tw_user_id>\n"; $xml .= " <email_optout><![CDATA[" . $do_contact->getData("email_optout") . "]]></email_optout>\n\n"; $contact_address = $do_contact->getChildContactAddress(); while ($contact_address->next()) { $xml .= " <contact_address>\n"; $xml .= " <idcontact_address><![CDATA[" . $contact_address->idcontact_address . "]]></idcontact_address>\n"; $xml .= " <city><![CDATA[" . $contact_address->city . "]]></city>\n"; $xml .= " <country><![CDATA[" . $contact_address->country . "]]></country>\n"; $xml .= " <state><![CDATA[" . $contact_address->state . "]]></state>\n"; $xml .= " <street><![CDATA[" . $contact_address->street . "]]></street>\n"; $xml .= " <zipcode><![CDATA[" . $contact_address->zipcode . "]]></zipcode>\n"; $xml .= " <idcontact><![CDATA[" . $contact_address->idcontact . "]]></idcontact>\n"; $xml .= " <address><![CDATA[" . $contact_address->address . "]]></address>\n"; $xml .= " <address_type><![CDATA[" . $contact_address->address_type . "]]></address_type>\n"; $xml .= " </contact_address>\n"; } $contact_email = $do_contact->getChildContactEmail(); while ($contact_email->next()) { $xml .= " <contact_email>\n"; $xml .= " <idcontact_email><![CDATA[" . $contact_email->idcontact_email . "]]></idcontact_email>\n"; $xml .= " <idcontact><![CDATA[" . $contact_email->idcontact . "]]></idcontact>\n"; $xml .= " <email_address><![CDATA[" . $contact_email->email_address . "]]></email_address>\n"; $xml .= " <email_type><![CDATA[" . $contact_email->email_type . "]]></email_type>\n"; $xml .= " <email_isdefault><![CDATA[" . $contact_email->email_isdefault . "]]></email_isdefault>\n"; $xml .= " </contact_email>\n"; } $contact_phone = $do_contact->getChildContactPhone(); while ($contact_phone->next()) { $xml .= " <contact_phone>\n"; $xml .= " <idcontact_phone><![CDATA[" . $contact_phone->idcontact_phone . "]]></idcontact_phone>\n"; $xml .= " <phone_number><![CDATA[" . $contact_phone->phone_number . "]]></phone_number>\n"; $xml .= " <phone_type><![CDATA[" . $contact_phone->phone_type . "]]></phone_type>\n"; $xml .= " <idcontact><![CDATA[" . $contact_phone->email_type . "]]></idcontact>\n"; $xml .= " </contact_phone>\n"; } $contact_note = $do_contact->getChildContactNotes(); while ($contact_note->next()) { $xml .= " <contact_note>\n"; $xml .= " <idcontact_note><![CDATA[" . $contact_note->idcontact_note . "]]></idcontact_note>\n"; $xml .= " <idcontact><![CDATA[" . $contact_note->idcontact . "]]></idcontact>\n"; $xml .= " <note><![CDATA[" . $contact_note->note . "]]></note>\n"; $xml .= " <date_added><![CDATA[" . $contact_note->date_added . "]]></date_added>\n"; $xml .= " <document><![CDATA[" . $contact_note->document . "]]></document>\n"; $xml .= " <idcompany><![CDATA[" . $contact_note->idcompany . "]]></idcompany>\n"; $xml .= " <iduser><![CDATA[" . $contact_note->iduser . "]]></iduser>\n"; $xml .= " <priority><![CDATA[" . $contact_note->priority . "]]></priority>\n"; $xml .= " <send_email><![CDATA[" . $contact_note->send_email . "]]></send_email>\n"; $xml .= " <hours_work><![CDATA[" . $contact_note->hours_work . "]]></hours_work>\n"; $xml .= " <note_visibility><![CDATA[" . $contact_note->note_visibility . "]]></note_visibility>\n"; $xml .= " </contact_note>\n"; } if (!$this->appendToFile($xml)) { return false; } $xml = ' '; if ($i == '1') { $do_task = new Task(); $do_task->getTaskWithoutProject(); while ($do_task->next()) { $xml .= " <contact_task>\n"; $xml .= " <idtask><![CDATA[" . $do_task->getData("idtask") . "]]></idtask>\n"; $xml .= " <task_description><![CDATA[" . $do_task->getData("task_description") . "]]></task_description>\n"; $xml .= " <due_date><![CDATA[" . $do_task->getData("due_date") . "]]></due_date>\n"; $xml .= " <category><![CDATA[" . $do_task->getData("category") . "]]></category>\n"; $xml .= " <iduser><![CDATA[" . $do_task->getData("iduser") . "]]></iduser>\n"; $xml .= " <due_date_dateformat><![CDATA[" . $do_task->getData("due_date_dateformat") . "]]></due_date_dateformat>\n"; $xml .= " <status><![CDATA[" . $do_task->getData("status") . "]]></status>\n"; $xml .= " <date_completed><![CDATA[" . $do_task->getData("date_completed") . "]]></date_completed>\n"; $xml .= " <idcontact><![CDATA[" . $do_task->getData("idcontact") . "]]></idcontact>\n"; $xml .= " <from_note><![CDATA[" . $do_task->getData("from_note") . "]]></from_note>\n"; $xml .= " <is_sp_date_set><![CDATA[" . $do_task->getData("is_sp_date_set") . "]]></is_sp_date_set>\n"; $xml .= " <task_category><![CDATA[" . $do_task->getData("task_category") . "]]></task_category>\n"; $xml .= " </contact_task>\n"; if (!$this->appendToFile($xml)) { return false; } $xml = ' '; } $do_task->free(); } $do_task = new Task(); $do_task->getContactTaskWithoutProject($do_contact->getData("idcontact")); while ($do_task->next()) { $xml .= " <contact_task>\n"; $xml .= " <idtask><![CDATA[" . $do_task->getData("idtask") . "]]></idtask>\n"; $xml .= " <task_description><![CDATA[" . $do_task->getData("task_description") . "]]></task_description>\n"; $xml .= " <due_date><![CDATA[" . $do_task->getData("due_date") . "]]></due_date>\n"; $xml .= " <category><![CDATA[" . $do_task->getData("category") . "]]></category>\n"; $xml .= " <iduser><![CDATA[" . $do_task->getData("iduser") . "]]></iduser>\n"; $xml .= " <due_date_dateformat><![CDATA[" . $do_task->getData("due_date_dateformat") . "]]></due_date_dateformat>\n"; $xml .= " <status><![CDATA[" . $do_task->getData("status") . "]]></status>\n"; $xml .= " <date_completed><![CDATA[" . $do_task->getData("date_completed") . "]]></date_completed>\n"; $xml .= " <idcontact><![CDATA[" . $do_task->getData("idcontact") . "]]></idcontact>\n"; $xml .= " <from_note><![CDATA[" . $do_task->getData("from_note") . "]]></from_note>\n"; $xml .= " <is_sp_date_set><![CDATA[" . $do_task->getData("is_sp_date_set") . "]]></is_sp_date_set>\n"; $xml .= " <task_category><![CDATA[" . $do_task->getData("task_category") . "]]></task_category>\n"; $xml .= " </contact_task>\n"; } $do_task->free(); if (!$this->appendToFile($xml)) { return false; } $xml = ' '; /** * For all the contact tasks which are associated with Project. */ $do_task = new Task(); //$do_task->getContactTasksAssociatedWithProject($do_contact->getData("idcontact")); $do_task->getContactTasksAssociatedWithProject($do_contact->getData("idcontact")); while ($do_task->next()) { $do_project = new Project(); $do_project->getId($do_task->idproject); $xml .= " <contact_task_with_project>\n"; $xml .= " <idproject><![CDATA[" . $do_project->idproject . "]]></idproject>\n"; $xml .= " <iduser><![CDATA[" . $do_project->iduser . "]]></iduser>\n"; $xml .= " <name><![CDATA[" . $do_project->name . "]]></name>\n"; $xml .= " <end_date_dateformat><![CDATA[" . $do_project->end_date_dateformat . "]]></end_date_dateformat>\n"; $xml .= " <idcompany><![CDATA[" . $do_project->idcompany . "]]></idcompany>\n"; $xml .= " <status><![CDATA[" . $do_project->status . "]]></status>\n"; $xml .= " <effort_estimated_hrs><![CDATA[" . $do_project->effort_estimated_hrs . "]]></effort_estimated_hrs>\n"; $xml .= " <is_public><![CDATA[" . $do_project->is_public . "]]></is_public>\n\n"; $xml .= " <project_task>\n"; $xml .= " <idproject_task><![CDATA[" . $do_task->getData("idproject_task") . "]]></idproject_task>\n"; $xml .= " <idtask><![CDATA[" . $do_task->getData("idtask") . "]]></idtask>\n"; $xml .= " <idproject><![CDATA[" . $do_task->getData("idproject") . "]]></idproject>\n"; $xml .= " <progress><![CDATA[" . $do_task->getData("progress") . "]]></progress>\n"; $xml .= " <drop_box_code><![CDATA[" . $do_task->getData("drop_box_code") . "]]></drop_box_code>\n"; $xml .= " <priority><![CDATA[" . $do_task->getData("priority") . "]]></priority>\n"; $xml .= " <hrs_work_expected><![CDATA[" . $do_task->getData("hrs_work_expected") . "]]></hrs_work_expected>\n"; $xml .= " <task_description><![CDATA[" . $do_task->getData("task_description") . "]]></task_description>\n"; $xml .= " <due_date><![CDATA[" . $do_task->getData("due_date") . "]]></due_date>\n"; $xml .= " <category><![CDATA[" . $do_task->getData("category") . "]]></category>\n"; $xml .= " <iduser><![CDATA[" . $do_task->getData("iduser") . "]]></iduser>\n"; $xml .= " <due_date_dateformat><![CDATA[" . $do_task->getData("due_date_dateformat") . "]]></due_date_dateformat>\n"; $xml .= " <status><![CDATA[" . $do_task->getData("status") . "]]></status>\n"; $xml .= " <date_completed><![CDATA[" . $do_task->getData("date_completed") . "]]></date_completed>\n"; $xml .= " <idcontact><![CDATA[" . $do_task->getData("idcontact") . "]]></idcontact>\n"; $xml .= " <from_note><![CDATA[" . $do_task->getData("from_note") . "]]></from_note>\n"; $xml .= " <is_sp_date_set><![CDATA[" . $do_task->getData("is_sp_date_set") . "]]></is_sp_date_set>\n"; $xml .= " <task_category><![CDATA[" . $do_task->getData("task_category") . "]]></task_category>\n\n"; if (!$this->appendToFile($xml)) { return false; } $xml = ' '; $do_prj_discuss = new ProjectDiscuss(); $do_prj_discuss->getProjectTaskDiscussions($do_task->getData("idproject_task")); while ($do_prj_discuss->next()) { $xml .= " <project_discuss>\n"; $xml .= " <idproject_discuss><![CDATA[" . $do_prj_discuss->getData("idproject_discuss") . "]]></idproject_discuss>\n"; $xml .= " <idproject_task><![CDATA[" . $do_prj_discuss->getData("idproject_task") . "]]></idproject_task>\n"; $xml .= " <idtask><![CDATA[" . $do_prj_discuss->getData("idtask") . "]]></idtask>\n"; $xml .= " <idproject><![CDATA[" . $do_prj_discuss->getData("idproject") . "]]></idproject>\n"; $xml .= " <discuss><![CDATA[" . $do_prj_discuss->getData("discuss") . "]]></discuss>\n"; $xml .= " <date_added><![CDATA[" . $do_prj_discuss->getData("date_added") . "]]></date_added>\n"; $xml .= " <document><![CDATA[" . $do_prj_discuss->getData("document") . "]]></document>\n"; $xml .= " <iduser><![CDATA[" . $do_prj_discuss->getData("iduser") . "]]></iduser>\n"; $xml .= " <drop_box_sender><![CDATA[" . $do_prj_discuss->getData("drop_box_sender") . "]]></drop_box_sender>\n"; $xml .= " <priority><![CDATA[" . $do_prj_discuss->getData("priority") . "]]></priority>\n"; $xml .= " <hours_work><![CDATA[" . $do_prj_discuss->getData("hours_work") . "]]></hours_work>\n"; $xml .= " <discuss_edit_access><![CDATA[" . $do_prj_discuss->getData("discuss_edit_access") . "]]></discuss_edit_access>\n"; $xml .= " </project_discuss>\n"; if (!$this->appendToFile($xml)) { return false; } $xml = ' '; } $do_prj_discuss->free(); $xml .= " </project_task>\n"; $xml .= " </contact_task_with_project>\n"; $do_project->free(); } $do_task->free(); if (!$this->appendToFile($xml)) { return false; } $xml = ''; if ($i == '1') { $do_task = new Task(); $do_task->getTasksWithProject(); while ($do_task->next()) { $do_project = new Project(); $do_project->getId($do_task->idproject); $xml .= " <contact_task_with_project>\n"; $xml .= " <idproject><![CDATA[" . $do_project->idproject . "]]></idproject>\n"; $xml .= " <iduser><![CDATA[" . $do_project->iduser . "]]></iduser>\n"; $xml .= " <name><![CDATA[" . $do_project->name . "]]></name>\n"; $xml .= " <end_date_dateformat><![CDATA[" . $do_project->end_date_dateformat . "]]></end_date_dateformat>\n"; $xml .= " <idcompany><![CDATA[" . $do_project->idcompany . "]]></idcompany>\n"; $xml .= " <status><![CDATA[" . $do_project->status . "]]></status>\n"; $xml .= " <effort_estimated_hrs><![CDATA[" . $do_project->effort_estimated_hrs . "]]></effort_estimated_hrs>\n"; $xml .= " <is_public><![CDATA[" . $do_project->is_public . "]]></is_public>\n\n"; $xml .= " <project_task>\n"; $xml .= " <idproject_task><![CDATA[" . $do_task->getData("idproject_task") . "]]></idproject_task>\n"; $xml .= " <idtask><![CDATA[" . $do_task->getData("idtask") . "]]></idtask>\n"; $xml .= " <idproject><![CDATA[" . $do_task->getData("idproject") . "]]></idproject>\n"; $xml .= " <progress><![CDATA[" . $do_task->getData("progress") . "]]></progress>\n"; $xml .= " <drop_box_code><![CDATA[" . $do_task->getData("drop_box_code") . "]]></drop_box_code>\n"; $xml .= " <priority><![CDATA[" . $do_task->getData("priority") . "]]></priority>\n"; $xml .= " <hrs_work_expected><![CDATA[" . $do_task->getData("hrs_work_expected") . "]]></hrs_work_expected>\n"; $xml .= " <task_description><![CDATA[" . $do_task->getData("task_description") . "]]></task_description>\n"; $xml .= " <due_date><![CDATA[" . $do_task->getData("due_date") . "]]></due_date>\n"; $xml .= " <category><![CDATA[" . $do_task->getData("category") . "]]></category>\n"; $xml .= " <iduser><![CDATA[" . $do_task->getData("iduser") . "]]></iduser>\n"; $xml .= " <due_date_dateformat><![CDATA[" . $do_task->getData("due_date_dateformat") . "]]></due_date_dateformat>\n"; $xml .= " <status><![CDATA[" . $do_task->getData("status") . "]]></status>\n"; $xml .= " <date_completed><![CDATA[" . $do_task->getData("date_completed") . "]]></date_completed>\n"; $xml .= " <idcontact><![CDATA[" . $do_task->getData("idcontact") . "]]></idcontact>\n"; $xml .= " <from_note><![CDATA[" . $do_task->getData("from_note") . "]]></from_note>\n"; $xml .= " <is_sp_date_set><![CDATA[" . $do_task->getData("is_sp_date_set") . "]]></is_sp_date_set>\n"; $xml .= " <task_category><![CDATA[" . $do_task->getData("task_category") . "]]></task_category>\n\n"; if (!$this->appendToFile($xml)) { return false; } $xml = ' '; $do_prj_discuss = new ProjectDiscuss(); $do_prj_discuss->getProjectTaskDiscussions($do_task->getData("idproject_task")); while ($do_prj_discuss->next()) { $xml .= " <project_discuss>\n"; $xml .= " <idproject_discuss><![CDATA[" . $do_prj_discuss->getData("idproject_discuss") . "]]></idproject_discuss>\n"; $xml .= " <idproject_task><![CDATA[" . $do_prj_discuss->getData("idproject_task") . "]]></idproject_task>\n"; $xml .= " <idtask><![CDATA[" . $do_prj_discuss->getData("idtask") . "]]></idtask>\n"; $xml .= " <idproject><![CDATA[" . $do_prj_discuss->getData("idproject") . "]]></idproject>\n"; $xml .= " <discuss><![CDATA[" . $do_prj_discuss->getData("discuss") . "]]></discuss>\n"; $xml .= " <date_added><![CDATA[" . $do_prj_discuss->getData("date_added") . "]]></date_added>\n"; $xml .= " <document><![CDATA[" . $do_prj_discuss->getData("document") . "]]></document>\n"; $xml .= " <iduser><![CDATA[" . $do_prj_discuss->getData("iduser") . "]]></iduser>\n"; $xml .= " <drop_box_sender><![CDATA[" . $do_prj_discuss->getData("drop_box_sender") . "]]></drop_box_sender>\n"; $xml .= " <priority><![CDATA[" . $do_prj_discuss->getData("priority") . "]]></priority>\n"; $xml .= " <hours_work><![CDATA[" . $do_prj_discuss->getData("hours_work") . "]]></hours_work>\n"; $xml .= " <discuss_edit_access><![CDATA[" . $do_prj_discuss->getData("discuss_edit_access") . "]]></discuss_edit_access>\n"; $xml .= " </project_discuss>\n"; if (!$this->appendToFile($xml)) { return false; } $xml = ' '; } $do_prj_discuss->free(); $xml .= " </project_task>\n"; $xml .= " </contact_task_with_project>\n"; $do_project->free(); } $do_task->free(); } if (!$this->appendToFile($xml)) { return false; } $xml = ' '; $do_invoice = new Invoice(); $do_invoice->getContactInvoiceDetailsWithUser($do_contact->getData("idcontact"), $do_user->iduser); while ($do_invoice->next()) { $xml .= " <invoice>\n"; $xml .= " <idinvoice><![CDATA[" . $do_invoice->getData("idinvoice") . "]]></idinvoice>\n"; $xml .= " <num><![CDATA[" . $do_invoice->getData("num") . "]]></num>\n"; $xml .= " <iduser><![CDATA[" . $do_invoice->getData("iduser") . "]]></iduser>\n"; $xml .= " <description><![CDATA[" . $do_invoice->getData("description") . "]]></description>\n"; $xml .= " <amount><![CDATA[" . $do_invoice->getData("amount") . "]]></amount>\n"; $xml .= " <datepaid><![CDATA[" . $do_invoice->getData("datepaid") . "]]></datepaid>\n"; $xml .= " <datecreated><![CDATA[" . $do_invoice->getData("datecreated") . "]]></datecreated>\n"; $xml .= " <status><![CDATA[" . $do_invoice->getData("status") . "]]></status>\n"; $xml .= " <discount><![CDATA[" . $do_invoice->getData("discount") . "]]></discount>\n"; $xml .= " <idcontact><![CDATA[" . $do_invoice->getData("idcontact") . "]]></idcontact>\n"; $xml .= " <due_date><![CDATA[" . $do_invoice->getData("due_date") . "]]></due_date>\n"; $xml .= " <invoice_address><![CDATA[" . $do_invoice->getData("invoice_address") . "]]></invoice_address>\n"; $xml .= " <invoice_term><![CDATA[" . $do_invoice->getData("invoice_term") . "]]></invoice_term>\n"; $xml .= " <invoice_note><![CDATA[" . $do_invoice->getData("invoice_note") . "]]></invoice_note>\n"; $xml .= " <sub_total><![CDATA[" . $do_invoice->getData("sub_total") . "]]></sub_total>\n"; $xml .= " <net_total><![CDATA[" . $do_invoice->getData("net_total") . "]]></net_total>\n"; $xml .= " <amt_due><![CDATA[" . $do_invoice->getData("amt_due") . "]]></amt_due>\n"; $xml .= " <idcompany><![CDATA[" . $do_invoice->getData("idcompany") . "]]></idcompany>\n"; $xml .= " <tax><![CDATA[" . $do_invoice->getData("tax") . "]]></tax>\n"; $xml .= " <set_delete><![CDATA[" . $do_invoice->getData("set_delete") . "]]></set_delete>\n"; $xml .= " <total_discounted_amt><![CDATA[" . $do_invoice->getData("total_discounted_amt") . "]]></total_discounted_amt>\n"; $xml .= " <total_taxed_amount><![CDATA[" . $do_invoice->getData("total_taxed_amount") . "]]></total_taxed_amount>\n"; $invoice_line = $do_invoice->getChildInvoiceLine(); while ($invoice_line->next()) { $xml .= " <invoiceline>\n"; $xml .= " <idinvoiceline><![CDATA[" . $invoice_line->idinvoiceline . "]]></idinvoiceline>\n"; $xml .= " <idinvoice><![CDATA[" . $invoice_line->idinvoice . "]]></idinvoice>\n"; $xml .= " <description><![CDATA[" . $invoice_line->description . "]]></description>\n"; $xml .= " <price><![CDATA[" . $invoice_line->price . "]]></price>\n"; $xml .= " <qty><![CDATA[" . $invoice_line->qty . "]]></qty>\n"; $xml .= " <total><![CDATA[" . $invoice_line->total . "]]></total>\n"; $xml .= " <item><![CDATA[" . $invoice_line->item . "]]></item>\n"; $xml .= " <line_tax><![CDATA[" . $invoice_line->line_tax . "]]></line_tax>\n"; $xml .= " <discounted_amount><![CDATA[" . $invoice_line->discounted_amount . "]]></discounted_amount>\n"; $xml .= " <taxed_amount><![CDATA[" . $invoice_line->taxed_amount . "]]></taxed_amount>\n"; $xml .= " </invoiceline>\n"; } $invoice_line->free(); if (!$this->appendToFile($xml)) { return false; } $xml = ' '; $do_recurrent_invoice = new RecurrentInvoice(); $do_recurrent_invoice->getRecurrentInvoiceDetail($do_invoice->getData("idinvoice")); while ($do_recurrent_invoice->next()) { $xml .= " <recurrentinvoice>\n"; $xml .= " <idrecurrentinvoice><![CDATA[" . $do_recurrent_invoice->getData("idrecurrentinvoice") . "]]></idrecurrentinvoice>\n"; $xml .= " <iduser><![CDATA[" . $do_recurrent_invoice->getData("iduser") . "]]></iduser>\n"; $xml .= " <idinvoice><![CDATA[" . $do_recurrent_invoice->getData("idinvoice") . "]]></idinvoice>\n"; $xml .= " <nextdate><![CDATA[" . $do_recurrent_invoice->getData("nextdate") . "]]></nextdate>\n"; $xml .= " <recurrence><![CDATA[" . $do_recurrent_invoice->getData("recurrence") . "]]></recurrence>\n"; $xml .= " <recurrencetype><![CDATA[" . $do_recurrent_invoice->getData("recurrencetype") . "]]></recurrencetype>\n"; $xml .= " </recurrentinvoice>\n"; } $do_recurrent_invoice->free(); $do_paymentlog = new PaymentLog(); $do_paymentlog->getPaymentLogDetails($do_invoice->getData("idinvoice")); while ($do_paymentlog->next()) { $xml .= " <paymentlog>\n"; $xml .= " <idpaymentlog ><![CDATA[" . $do_paymentlog->getData("idpaymentlog") . "]]></idpaymentlog >\n"; $xml .= " <timestamp><![CDATA[" . $do_paymentlog->getData("timestamp") . "]]></timestamp>\n"; $xml .= " <idinvoice><![CDATA[" . $do_paymentlog->getData("idinvoice") . "]]></idinvoice>\n"; $xml .= " <amount><![CDATA[" . $do_paymentlog->getData("amount") . "]]></amount>\n"; $xml .= " <payment_type><![CDATA[" . $do_paymentlog->getData("payment_type") . "]]></payment_type>\n"; $xml .= " <ref_num><![CDATA[" . $do_paymentlog->getData("ref_num") . "]]></ref_num>\n"; $xml .= " <date_added><![CDATA[" . $do_paymentlog->getData("date_added") . "]]></date_added>\n"; $do_payment_invoice = new PaymentInvoice(); $do_payment_invoice->getInvDetails($do_paymentlog->getData("idpaymentlog")); while ($do_payment_invoice->next()) { $xml .= " <payment_invoice>\n"; $xml .= " <idpayment_invoice><![CDATA[" . $do_payment_invoice->getData("idpayment_invoice") . "]]></idpayment_invoice>\n"; $xml .= " <idpayment><![CDATA[" . $do_payment_invoice->getData("idpayment") . "]]></idpayment>\n"; $xml .= " <idinvoice><![CDATA[" . $do_payment_invoice->getData("idinvoice") . "]]></idinvoice>\n"; $xml .= " <amount><![CDATA[" . $do_payment_invoice->getData("amount") . "]]></amount>\n"; $xml .= " </payment_invoice>\n"; } $do_payment_invoice->free(); $do_paymentlog_extra_amount = new PaymentLog(); $do_paymentlog_extra_amount->getPaymentLogExtraAmountDetails($do_paymentlog->getData("idpaymentlog")); while ($do_paymentlog_extra_amount->next()) { $xml .= " <paymentlog_extra_amount>\n"; $xml .= " <idpaymentlog_extra_amount><![CDATA[" . $do_paymentlog_extra_amount->getData("idpaymentlog_extra_amount") . "]]></idpaymentlog_extra_amount>\n"; $xml .= " <idpaymentlog><![CDATA[" . $do_paymentlog_extra_amount->getData("idpaymentlog") . "]]></idpaymentlog>\n"; $xml .= " <extra_amt><![CDATA[" . $do_paymentlog_extra_amount->getData("extra_amt") . "]]></extra_amt>\n"; $xml .= " <iduser><![CDATA[" . $do_paymentlog_extra_amount->getData("iduser") . "]]></iduser>\n"; $xml .= " </paymentlog_extra_amount>\n"; } $do_paymentlog_extra_amount->free(); $xml .= " </paymentlog>\n"; if (!$this->appendToFile($xml)) { return false; } $xml = ' '; } $do_paymentlog->free(); $xml .= " </invoice>\n"; } $do_invoice->free(); $do_tag = new Tag(); $do_tag->getUserContactTags($iduser, $do_contact->getData("idcontact")); while ($do_tag->next()) { $xml .= " <tag>\n"; $xml .= " <idtag><![CDATA[" . $do_tag->idtag . "]]></idtag>\n"; $xml .= " <tag_name><![CDATA[" . $do_tag->tag_name . "]]></tag_name>\n"; $xml .= " <iduser><![CDATA[" . $do_tag->iduser . "]]></iduser>\n"; $xml .= " <reference_type><![CDATA[" . $do_tag->reference_type . "]]></reference_type>\n"; $xml .= " <idreference><![CDATA[" . $do_tag->idreference . "]]></idreference>\n"; $xml .= " <date_added><![CDATA[" . $do_tag->date_added . "]]></date_added>\n"; $xml .= " </tag>\n"; if (!$this->appendToFile($xml)) { return false; } $xml = ' '; } $do_tag->free(); $xml .= " </contact>\n"; $i++; } //end line $xml .= "</contacts>\n"; if (!$this->appendToFile($xml)) { return false; } else { return true; } }
function eventExportContacts(EventControler $evtcl) { $iduser = $_SESSION['do_User']->iduser; $do_contact = new Contact(); $do_contact->getAllContactsForAUser(); $num_contacts = $do_contact->getNumRows(); $report_name = "ofuz_" . $iduser . "_report" . ".xls"; $fname = "xls_report/{$report_name}"; $workbook =& new writeexcel_workbook($fname); $worksheet =& $workbook->addworksheet('Report'); $heading =& $workbook->addformat(array('align' => 'center', 'bold' => 1, 'fg_color' => 'yellow')); $right =& $workbook->addformat(array('align' => 'right')); $left =& $workbook->addformat(array('align' => 'left')); # Create a border format $border1 =& $workbook->addformat(); $border1->set_color('magenta'); $border1->set_bold(); $border1->set_size(15); $border1->set_pattern(0x1); $border1->set_fg_color('aqua'); $border1->set_border_color('yellow'); $border1->set_top(6); $border1->set_bottom(6); $border1->set_left(6); $border1->set_align('center'); $border1->set_align('vcenter'); $border1->set_merge(); # This is the key feature # Create another border format. $border2 =& $workbook->addformat(); $border2->set_color('magenta'); $border2->set_bold(); $border2->set_size(15); $border2->set_pattern(0x1); $border2->set_fg_color('aqua'); $border2->set_border_color('yellow'); $border2->set_top(6); $border2->set_bottom(6); $border2->set_right(6); $border2->set_align('center'); $border2->set_align('vcenter'); $border2->set_merge(); # This is the key feature /* # Set the row height for row 0 (heading current date) $worksheet->set_row(0, 24); $worksheet->write (0, 0, "Welcome", $border1); $worksheet->write_blank(0, 1, $border2); $worksheet->write_blank(0, 2, $border2); */ # Set the row height for row 0 (heading current date) $worksheet->set_row(1, 24); $current_date = _("As on ") . date('m/d/Y h:i:s') . ", "; $heading_total_contacts = $current_date . _("Total Contacts : ") . $num_contacts; $worksheet->write(1, 0, $heading_total_contacts, $border1); $worksheet->write_blank(1, 1, $border2); $worksheet->write_blank(1, 2, $border2); $worksheet->write_blank(1, 3, $border2); $worksheet->write_blank(1, 4, $border2); $worksheet->write_blank(1, 5, $border2); $report_heading = array('First Name', 'Last Name', 'Company', 'Position', 'Email', 'Phone', 'Tags'); $col = 0; foreach ($report_heading as $colum) { $worksheet->write(3, $col, $colum, $heading); $col++; } $row = 4; if ($num_contacts) { while ($do_contact->next()) { $col = 0; $worksheet->write($row, $col, $do_contact->getData('firstname'), $left); $col++; $worksheet->write($row, $col, $do_contact->getData('lastname'), $left); $col++; $worksheet->write($row, $col, $do_contact->getData('company'), $left); $col++; $worksheet->write($row, $col, $do_contact->getData('position'), $left); $col++; $worksheet->write($row, $col, $do_contact->getData('email_address'), $left); $col++; $worksheet->write($row, $col, $do_contact->getData('phone_number'), $left); $col++; $worksheet->write($row, $col, $do_contact->getData('tags'), $left); $row++; } } else { } $workbook->close(); //header("Location: {$fname}"); $evtcl->setDisplayNext(new Display($fname)); }
* A cron job script for sending the autoresponders. * Will get the autoresponders with the tags and will send the email to the contacts associated with the tag_name * @see class/Autoresponder.class.php */ include_once 'config.php'; $AutoResponder = new AutoResponder(); $AutoResponder->getAutoresponders(); if ($AutoResponder->getNumRows()) { while ($AutoResponder->next()) { $User = new User(); $User->getId($AutoResponder->iduser); $User->sessionPersistent('do_User', 'contacts.php', OFUZ_TTL); $email_template = new EmailTemplate(); $email_template->bodyhtml = nl2br(stripslashes($AutoResponder->bodyhtml)); $email_template->subject = $AutoResponder->subject; $email_template->senderemail = $User->email; $email_template->sendername = $User->firstname . ' ' . $User->lastname; $resp_name = $AutoResponder->resp_name; $Contact = new Contact(); $Contact->getContactsForAutoResponder($AutoResponder->iduser, $AutoResponder->tag_name, $AutoResponder->num_days_to_send); if ($Contact->getNumRows()) { while ($Contact->next()) { $values = array("idcontact" => $Contact->idcontact, "firstname" => $Contact->firstname, "lastname" => $Contact->lastname, "position" => $Contact->position, "company" => $Contact->company, "idtag" => $Contact->idtag, "resp_name" => $resp_name, "flag" => "unsubscribe_autoresponder"); $Contact->sendMessage($email_template, $values); echo '<br /> Email Sent to :' . $Contact->email_address; } } $Contact->free(); } $AutoResponder->free(); }
/** * Back up Inactive users data from all the fields and Delete Inactive User's account. * This function is used to generate the xml back up file for the user information from the DB * This function is differnt from exportUserAccount as we have added more table to the backup * And we have function to delete the table once back up is done. And the function exportUserAccount * was not disturbed as this was already in use. * @param int : $iduser * @return void */ public function exportUserAccountandDelete($iduser) { $xml = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n\n"; $do_user = new User(); $do_user->getId($iduser); $xml .= "<document>\n"; $xml .= "<user>\n"; $xml .= " <iduser><![CDATA[" . $do_user->iduser . "]]></iduser>\n"; $xml .= " <firstname><![CDATA[" . $do_user->firstname . "]]></firstname>\n"; $xml .= " <middlename><![CDATA[" . $do_user->middlename . "]]></middlename>\n"; $xml .= " <lastname><![CDATA[" . $do_user->lastname . "]]></lastname>\n"; $xml .= " <email><![CDATA[" . $do_user->email . "]]></email>\n"; $xml .= " <phone><![CDATA[" . $do_user->phone . "]]></phone>\n"; $xml .= " <company><![CDATA[" . $do_user->company . "]]></company>\n"; $xml .= " <position><![CDATA[" . $do_user->position . "]]></position>\n"; $xml .= " <address1><![CDATA[" . $do_user->address1 . "]]></address1>\n"; $xml .= " <address2><![CDATA[" . $do_user->address2 . "]]></address2>\n"; $xml .= " <city><![CDATA[" . $do_user->city . "]]></city>\n"; $xml .= " <zip><![CDATA[" . $do_user->zip . "]]></zip>\n"; $xml .= " <state><![CDATA[" . $do_user->state . "]]></state>\n"; $xml .= " <country><![CDATA[" . $do_user->country . "]]></country>\n"; $xml .= " <username><![CDATA[" . $do_user->username . "]]></username>\n"; $xml .= " <password><![CDATA[" . $do_user->password . "]]></password>\n"; $xml .= " <isadmin><![CDATA[" . $do_user->isadmin . "]]></isadmin>\n"; $xml .= " <regdate><![CDATA[" . $do_user->regdate . "]]></regdate>\n"; $xml .= " <openid><![CDATA[" . $do_user->openid . "]]></openid>\n"; $xml .= " <last_login><![CDATA[" . $do_user->last_login . "]]></last_login>\n"; $xml .= " <drop_box_code><![CDATA[" . $do_user->drop_box_code . "]]></drop_box_code>\n"; $xml .= " <idcontact><![CDATA[" . $do_user->idcontact . "]]></idcontact>\n"; $xml .= " <fb_user_id><![CDATA[" . $do_user->fb_user_id . "]]></fb_user_id>\n"; $xml .= " <api_key><![CDATA[" . $do_user->api_key . "]]></api_key>\n"; $xml .= " <plan><![CDATA[" . $do_user->plan . "]]></plan>\n"; $xml .= " <status><![CDATA[" . $do_user->status . "]]></status>\n"; $xml .= " <google_openid_identity><![CDATA[" . $do_user->google_openid_identity . "]]></google_openid_identity>\n"; $xml .= "</user>\n"; $i = 1; //$tbl_name = "userid".$iduser."_contact"; $do_contact = new Contact(NULL, NULL, $iduser); $do_contact->getUserContacts($iduser); $nums = $do_contact->GetNumRows(); if ($nums >= 1) { $xml .= "<contacts>\n"; while ($do_contact->next()) { $xml .= " <contact>\n"; $xml .= " <idcontact><![CDATA[" . $do_contact->getData("idcontact") . "]]></idcontact>\n"; $xml .= " <firstname><![CDATA[" . $do_contact->getData("firstname") . "]]></firstname>\n"; $xml .= " <lastname><![CDATA[" . $do_contact->getData("lastname") . "]]></lastname>\n"; $xml .= " <position><![CDATA[" . $do_contact->getData("position") . "]]></position>\n"; $xml .= " <company><![CDATA[" . $do_contact->getData("company") . "]]></company>\n"; $xml .= " <idcompany><![CDATA[" . $do_contact->getData("idcompany") . "]]></idcompany>\n"; $xml .= " <iduser><![CDATA[" . $do_contact->getData("iduser") . "]]></iduser>\n"; $xml .= " <picture><![CDATA[" . $do_contact->getData("picture") . "]]></picture>\n"; $xml .= " <summary><![CDATA[" . $do_contact->getData("summary") . "]]></summary>\n"; $xml .= " <birthday><![CDATA[" . $do_contact->getData("birthday") . "]]></birthday>\n"; $xml .= " <portal_code><![CDATA[" . $do_contact->getData("portal_code") . "]]></portal_code>\n"; $xml .= " <fb_userid><![CDATA[" . $do_contact->getData("fb_userid") . "]]></fb_userid>\n"; $xml .= " <tw_user_id><![CDATA[" . $do_contact->getData("tw_user_id") . "]]></tw_user_id>\n"; $xml .= " <email_optout><![CDATA[" . $do_contact->getData("email_optout") . "]]></email_optout>\n\n"; $contact_address = $do_contact->getChildContactAddress(); while ($contact_address->next()) { $xml .= " <contact_address>\n"; $xml .= " <idcontact_address><![CDATA[" . $contact_address->idcontact_address . "]]></idcontact_address>\n"; $xml .= " <city><![CDATA[" . $contact_address->city . "]]></city>\n"; $xml .= " <country><![CDATA[" . $contact_address->country . "]]></country>\n"; $xml .= " <state><![CDATA[" . $contact_address->state . "]]></state>\n"; $xml .= " <street><![CDATA[" . $contact_address->street . "]]></street>\n"; $xml .= " <zipcode><![CDATA[" . $contact_address->zipcode . "]]></zipcode>\n"; $xml .= " <idcontact><![CDATA[" . $contact_address->idcontact . "]]></idcontact>\n"; $xml .= " <address><![CDATA[" . $contact_address->address . "]]></address>\n"; $xml .= " <address_type><![CDATA[" . $contact_address->address_type . "]]></address_type>\n"; $xml .= " </contact_address>\n"; } $contact_email = $do_contact->getChildContactEmail(); while ($contact_email->next()) { $xml .= " <contact_email>\n"; $xml .= " <idcontact_email><![CDATA[" . $contact_email->idcontact_email . "]]></idcontact_email>\n"; $xml .= " <idcontact><![CDATA[" . $contact_email->idcontact . "]]></idcontact>\n"; $xml .= " <email_address><![CDATA[" . $contact_email->email_address . "]]></email_address>\n"; $xml .= " <email_type><![CDATA[" . $contact_email->email_type . "]]></email_type>\n"; $xml .= " <email_isdefault><![CDATA[" . $contact_email->email_isdefault . "]]></email_isdefault>\n"; $xml .= " </contact_email>\n"; } $contact_phone = $do_contact->getChildContactPhone(); while ($contact_phone->next()) { $xml .= " <contact_phone>\n"; $xml .= " <idcontact_phone><![CDATA[" . $contact_phone->idcontact_phone . "]]></idcontact_phone>\n"; $xml .= " <phone_number><![CDATA[" . $contact_phone->phone_number . "]]></phone_number>\n"; $xml .= " <phone_type><![CDATA[" . $contact_phone->phone_type . "]]></phone_type>\n"; $xml .= " <idcontact><![CDATA[" . $contact_phone->email_type . "]]></idcontact>\n"; $xml .= " </contact_phone>\n"; } $contact_note = $do_contact->getChildContactNotes(); while ($contact_note->next()) { $xml .= " <contact_note>\n"; $xml .= " <idcontact_note><![CDATA[" . $contact_note->idcontact_note . "]]></idcontact_note>\n"; $xml .= " <idcontact><![CDATA[" . $contact_note->idcontact . "]]></idcontact>\n"; $xml .= " <note><![CDATA[" . $contact_note->note . "]]></note>\n"; $xml .= " <date_added><![CDATA[" . $contact_note->date_added . "]]></date_added>\n"; $xml .= " <document><![CDATA[" . $contact_note->document . "]]></document>\n"; $xml .= " <idcompany><![CDATA[" . $contact_note->idcompany . "]]></idcompany>\n"; $xml .= " <iduser><![CDATA[" . $contact_note->iduser . "]]></iduser>\n"; $xml .= " <priority><![CDATA[" . $contact_note->priority . "]]></priority>\n"; $xml .= " <send_email><![CDATA[" . $contact_note->send_email . "]]></send_email>\n"; $xml .= " <hours_work><![CDATA[" . $contact_note->hours_work . "]]></hours_work>\n"; $xml .= " <note_visibility><![CDATA[" . $contact_note->note_visibility . "]]></note_visibility>\n"; $xml .= " </contact_note>\n"; } if ($i == '1') { $do_task = new Task(); $do_task->getContactTaskWithoutProjectAndWithUser($iduser); while ($do_task->next()) { $xml .= " <contact_task>\n"; $xml .= " <idtask><![CDATA[" . $do_task->getData("idtask") . "]]></idtask>\n"; $xml .= " <task_description><![CDATA[" . $do_task->getData("task_description") . "]]></task_description>\n"; $xml .= " <due_date><![CDATA[" . $do_task->getData("due_date") . "]]></due_date>\n"; $xml .= " <category><![CDATA[" . $do_task->getData("category") . "]]></category>\n"; $xml .= " <iduser><![CDATA[" . $do_task->getData("iduser") . "]]></iduser>\n"; $xml .= " <due_date_dateformat><![CDATA[" . $do_task->getData("due_date_dateformat") . "]]></due_date_dateformat>\n"; $xml .= " <status><![CDATA[" . $do_task->getData("status") . "]]></status>\n"; $xml .= " <date_completed><![CDATA[" . $do_task->getData("date_completed") . "]]></date_completed>\n"; $xml .= " <idcontact><![CDATA[" . $do_task->getData("idcontact") . "]]></idcontact>\n"; $xml .= " <from_note><![CDATA[" . $do_task->getData("from_note") . "]]></from_note>\n"; $xml .= " <is_sp_date_set><![CDATA[" . $do_task->getData("is_sp_date_set") . "]]></is_sp_date_set>\n"; $xml .= " <task_category><![CDATA[" . $do_task->getData("task_category") . "]]></task_category>\n"; $xml .= " </contact_task>\n"; } $do_task->free(); } $do_task = new Task(); $do_task->getContactTaskWithoutProjectAndWithContact($do_contact->getData("idcontact")); while ($do_task->next()) { $xml .= " <contact_task>\n"; $xml .= " <idtask><![CDATA[" . $do_task->getData("idtask") . "]]></idtask>\n"; $xml .= " <task_description><![CDATA[" . $do_task->getData("task_description") . "]]></task_description>\n"; $xml .= " <due_date><![CDATA[" . $do_task->getData("due_date") . "]]></due_date>\n"; $xml .= " <category><![CDATA[" . $do_task->getData("category") . "]]></category>\n"; $xml .= " <iduser><![CDATA[" . $do_task->getData("iduser") . "]]></iduser>\n"; $xml .= " <due_date_dateformat><![CDATA[" . $do_task->getData("due_date_dateformat") . "]]></due_date_dateformat>\n"; $xml .= " <status><![CDATA[" . $do_task->getData("status") . "]]></status>\n"; $xml .= " <date_completed><![CDATA[" . $do_task->getData("date_completed") . "]]></date_completed>\n"; $xml .= " <idcontact><![CDATA[" . $do_task->getData("idcontact") . "]]></idcontact>\n"; $xml .= " <from_note><![CDATA[" . $do_task->getData("from_note") . "]]></from_note>\n"; $xml .= " <is_sp_date_set><![CDATA[" . $do_task->getData("is_sp_date_set") . "]]></is_sp_date_set>\n"; $xml .= " <task_category><![CDATA[" . $do_task->getData("task_category") . "]]></task_category>\n"; $xml .= " </contact_task>\n"; } $do_task->free(); /** * For all the contact tasks which are associated with Project. */ $do_task = new Task(); //$do_task->getContactTasksAssociatedWithProject($do_contact->getData("idcontact")); $do_task->getContactTasksAssociatedWithProjectWithContact($do_contact->getData("idcontact")); while ($do_task->next()) { $do_project = new Project(); $do_project->getId($do_task->idproject); $xml .= " <contact_task_with_project>\n"; $xml .= " <idproject><![CDATA[" . $do_project->idproject . "]]></idproject>\n"; $xml .= " <iduser><![CDATA[" . $do_project->iduser . "]]></iduser>\n"; $xml .= " <name><![CDATA[" . $do_project->name . "]]></name>\n"; $xml .= " <end_date_dateformat><![CDATA[" . $do_project->end_date_dateformat . "]]></end_date_dateformat>\n"; $xml .= " <idcompany><![CDATA[" . $do_project->idcompany . "]]></idcompany>\n"; $xml .= " <status><![CDATA[" . $do_project->status . "]]></status>\n"; $xml .= " <effort_estimated_hrs><![CDATA[" . $do_project->effort_estimated_hrs . "]]></effort_estimated_hrs>\n"; $xml .= " <is_public><![CDATA[" . $do_project->is_public . "]]></is_public>\n\n"; $xml .= " <project_task>\n"; $xml .= " <idproject_task><![CDATA[" . $do_task->getData("idproject_task") . "]]></idproject_task>\n"; $xml .= " <idtask><![CDATA[" . $do_task->getData("idtask") . "]]></idtask>\n"; $xml .= " <idproject><![CDATA[" . $do_task->getData("idproject") . "]]></idproject>\n"; $xml .= " <progress><![CDATA[" . $do_task->getData("progress") . "]]></progress>\n"; $xml .= " <drop_box_code><![CDATA[" . $do_task->getData("drop_box_code") . "]]></drop_box_code>\n"; $xml .= " <priority><![CDATA[" . $do_task->getData("priority") . "]]></priority>\n"; $xml .= " <hrs_work_expected><![CDATA[" . $do_task->getData("hrs_work_expected") . "]]></hrs_work_expected>\n"; $xml .= " <task_description><![CDATA[" . $do_task->getData("task_description") . "]]></task_description>\n"; $xml .= " <due_date><![CDATA[" . $do_task->getData("due_date") . "]]></due_date>\n"; $xml .= " <category><![CDATA[" . $do_task->getData("category") . "]]></category>\n"; $xml .= " <iduser><![CDATA[" . $do_task->getData("iduser") . "]]></iduser>\n"; $xml .= " <due_date_dateformat><![CDATA[" . $do_task->getData("due_date_dateformat") . "]]></due_date_dateformat>\n"; $xml .= " <status><![CDATA[" . $do_task->getData("status") . "]]></status>\n"; $xml .= " <date_completed><![CDATA[" . $do_task->getData("date_completed") . "]]></date_completed>\n"; $xml .= " <idcontact><![CDATA[" . $do_task->getData("idcontact") . "]]></idcontact>\n"; $xml .= " <from_note><![CDATA[" . $do_task->getData("from_note") . "]]></from_note>\n"; $xml .= " <is_sp_date_set><![CDATA[" . $do_task->getData("is_sp_date_set") . "]]></is_sp_date_set>\n"; $xml .= " <task_category><![CDATA[" . $do_task->getData("task_category") . "]]></task_category>\n\n"; $do_prj_discuss = new ProjectDiscuss(); $do_prj_discuss->getProjectTaskDiscussions($do_task->getData("idproject_task")); while ($do_prj_discuss->next()) { $xml .= " <project_discuss>\n"; $xml .= " <idproject_discuss><![CDATA[" . $do_prj_discuss->getData("idproject_discuss") . "]]></idproject_discuss>\n"; $xml .= " <idproject_task><![CDATA[" . $do_prj_discuss->getData("idproject_task") . "]]></idproject_task>\n"; $xml .= " <idtask><![CDATA[" . $do_prj_discuss->getData("idtask") . "]]></idtask>\n"; $xml .= " <idproject><![CDATA[" . $do_prj_discuss->getData("idproject") . "]]></idproject>\n"; $xml .= " <discuss><![CDATA[" . $do_prj_discuss->getData("discuss") . "]]></discuss>\n"; $xml .= " <date_added><![CDATA[" . $do_prj_discuss->getData("date_added") . "]]></date_added>\n"; $xml .= " <document><![CDATA[" . $do_prj_discuss->getData("document") . "]]></document>\n"; $xml .= " <iduser><![CDATA[" . $do_prj_discuss->getData("iduser") . "]]></iduser>\n"; $xml .= " <drop_box_sender><![CDATA[" . $do_prj_discuss->getData("drop_box_sender") . "]]></drop_box_sender>\n"; $xml .= " <priority><![CDATA[" . $do_prj_discuss->getData("priority") . "]]></priority>\n"; $xml .= " <hours_work><![CDATA[" . $do_prj_discuss->getData("hours_work") . "]]></hours_work>\n"; $xml .= " <discuss_edit_access><![CDATA[" . $do_prj_discuss->getData("discuss_edit_access") . "]]></discuss_edit_access>\n"; $xml .= " </project_discuss>\n"; } $do_prj_discuss->free(); $xml .= " </project_task>\n"; $xml .= " </contact_task_with_project>\n"; $do_project->free(); } $do_task->free(); if ($i == '1') { $do_task = new Task(); $do_task->getContactTasksAssociatedWithProjectWithUser($iduser); while ($do_task->next()) { $do_project = new Project(); $do_project->getId($do_task->idproject); $xml .= " <contact_task_with_project>\n"; $xml .= " <idproject><![CDATA[" . $do_project->idproject . "]]></idproject>\n"; $xml .= " <iduser><![CDATA[" . $do_project->iduser . "]]></iduser>\n"; $xml .= " <name><![CDATA[" . $do_project->name . "]]></name>\n"; $xml .= " <end_date_dateformat><![CDATA[" . $do_project->end_date_dateformat . "]]></end_date_dateformat>\n"; $xml .= " <idcompany><![CDATA[" . $do_project->idcompany . "]]></idcompany>\n"; $xml .= " <status><![CDATA[" . $do_project->status . "]]></status>\n"; $xml .= " <effort_estimated_hrs><![CDATA[" . $do_project->effort_estimated_hrs . "]]></effort_estimated_hrs>\n"; $xml .= " <is_public><![CDATA[" . $do_project->is_public . "]]></is_public>\n\n"; $xml .= " <project_task>\n"; $xml .= " <idproject_task><![CDATA[" . $do_task->getData("idproject_task") . "]]></idproject_task>\n"; $xml .= " <idtask><![CDATA[" . $do_task->getData("idtask") . "]]></idtask>\n"; $xml .= " <idproject><![CDATA[" . $do_task->getData("idproject") . "]]></idproject>\n"; $xml .= " <progress><![CDATA[" . $do_task->getData("progress") . "]]></progress>\n"; $xml .= " <drop_box_code><![CDATA[" . $do_task->getData("drop_box_code") . "]]></drop_box_code>\n"; $xml .= " <priority><![CDATA[" . $do_task->getData("priority") . "]]></priority>\n"; $xml .= " <hrs_work_expected><![CDATA[" . $do_task->getData("hrs_work_expected") . "]]></hrs_work_expected>\n"; $xml .= " <task_description><![CDATA[" . $do_task->getData("task_description") . "]]></task_description>\n"; $xml .= " <due_date><![CDATA[" . $do_task->getData("due_date") . "]]></due_date>\n"; $xml .= " <category><![CDATA[" . $do_task->getData("category") . "]]></category>\n"; $xml .= " <iduser><![CDATA[" . $do_task->getData("iduser") . "]]></iduser>\n"; $xml .= " <due_date_dateformat><![CDATA[" . $do_task->getData("due_date_dateformat") . "]]></due_date_dateformat>\n"; $xml .= " <status><![CDATA[" . $do_task->getData("status") . "]]></status>\n"; $xml .= " <date_completed><![CDATA[" . $do_task->getData("date_completed") . "]]></date_completed>\n"; $xml .= " <idcontact><![CDATA[" . $do_task->getData("idcontact") . "]]></idcontact>\n"; $xml .= " <from_note><![CDATA[" . $do_task->getData("from_note") . "]]></from_note>\n"; $xml .= " <is_sp_date_set><![CDATA[" . $do_task->getData("is_sp_date_set") . "]]></is_sp_date_set>\n"; $xml .= " <task_category><![CDATA[" . $do_task->getData("task_category") . "]]></task_category>\n\n"; $do_prj_discuss = new ProjectDiscuss(); $do_prj_discuss->getProjectTaskDiscussions($do_task->getData("idproject_task")); while ($do_prj_discuss->next()) { $xml .= " <project_discuss>\n"; $xml .= " <idproject_discuss><![CDATA[" . $do_prj_discuss->getData("idproject_discuss") . "]]></idproject_discuss>\n"; $xml .= " <idproject_task><![CDATA[" . $do_prj_discuss->getData("idproject_task") . "]]></idproject_task>\n"; $xml .= " <idtask><![CDATA[" . $do_prj_discuss->getData("idtask") . "]]></idtask>\n"; $xml .= " <idproject><![CDATA[" . $do_prj_discuss->getData("idproject") . "]]></idproject>\n"; $xml .= " <discuss><![CDATA[" . $do_prj_discuss->getData("discuss") . "]]></discuss>\n"; $xml .= " <date_added><![CDATA[" . $do_prj_discuss->getData("date_added") . "]]></date_added>\n"; $xml .= " <document><![CDATA[" . $do_prj_discuss->getData("document") . "]]></document>\n"; $xml .= " <iduser><![CDATA[" . $do_prj_discuss->getData("iduser") . "]]></iduser>\n"; $xml .= " <drop_box_sender><![CDATA[" . $do_prj_discuss->getData("drop_box_sender") . "]]></drop_box_sender>\n"; $xml .= " <priority><![CDATA[" . $do_prj_discuss->getData("priority") . "]]></priority>\n"; $xml .= " <hours_work><![CDATA[" . $do_prj_discuss->getData("hours_work") . "]]></hours_work>\n"; $xml .= " <discuss_edit_access><![CDATA[" . $do_prj_discuss->getData("discuss_edit_access") . "]]></discuss_edit_access>\n"; $xml .= " </project_discuss>\n"; } $do_prj_discuss->free(); $xml .= " </project_task>\n"; $xml .= " </contact_task_with_project>\n"; $do_project->free(); } $do_task->free(); } $do_invoice = new Invoice(); $do_invoice->getContactInvoiceDetailsWithUser($do_contact->getData("idcontact"), $do_user->iduser); while ($do_invoice->next()) { $xml .= " <invoice>\n"; $xml .= " <idinvoice><![CDATA[" . $do_invoice->getData("idinvoice") . "]]></idinvoice>\n"; $xml .= " <num><![CDATA[" . $do_invoice->getData("num") . "]]></num>\n"; $xml .= " <iduser><![CDATA[" . $do_invoice->getData("iduser") . "]]></iduser>\n"; $xml .= " <description><![CDATA[" . $do_invoice->getData("description") . "]]></description>\n"; $xml .= " <amount><![CDATA[" . $do_invoice->getData("amount") . "]]></amount>\n"; $xml .= " <datepaid><![CDATA[" . $do_invoice->getData("datepaid") . "]]></datepaid>\n"; $xml .= " <datecreated><![CDATA[" . $do_invoice->getData("datecreated") . "]]></datecreated>\n"; $xml .= " <status><![CDATA[" . $do_invoice->getData("status") . "]]></status>\n"; $xml .= " <discount><![CDATA[" . $do_invoice->getData("discount") . "]]></discount>\n"; $xml .= " <idcontact><![CDATA[" . $do_invoice->getData("idcontact") . "]]></idcontact>\n"; $xml .= " <due_date><![CDATA[" . $do_invoice->getData("due_date") . "]]></due_date>\n"; $xml .= " <invoice_address><![CDATA[" . $do_invoice->getData("invoice_address") . "]]></invoice_address>\n"; $xml .= " <invoice_term><![CDATA[" . $do_invoice->getData("invoice_term") . "]]></invoice_term>\n"; $xml .= " <invoice_note><![CDATA[" . $do_invoice->getData("invoice_note") . "]]></invoice_note>\n"; $xml .= " <sub_total><![CDATA[" . $do_invoice->getData("sub_total") . "]]></sub_total>\n"; $xml .= " <net_total><![CDATA[" . $do_invoice->getData("net_total") . "]]></net_total>\n"; $xml .= " <amt_due><![CDATA[" . $do_invoice->getData("amt_due") . "]]></amt_due>\n"; $xml .= " <idcompany><![CDATA[" . $do_invoice->getData("idcompany") . "]]></idcompany>\n"; $xml .= " <tax><![CDATA[" . $do_invoice->getData("tax") . "]]></tax>\n"; $xml .= " <set_delete><![CDATA[" . $do_invoice->getData("set_delete") . "]]></set_delete>\n"; $xml .= " <total_discounted_amt><![CDATA[" . $do_invoice->getData("total_discounted_amt") . "]]></total_discounted_amt>\n"; $xml .= " <total_taxed_amount><![CDATA[" . $do_invoice->getData("total_taxed_amount") . "]]></total_taxed_amount>\n"; $invoice_line = $do_invoice->getChildInvoiceLine(); while ($invoice_line->next()) { $xml .= " <invoiceline>\n"; $xml .= " <idinvoiceline><![CDATA[" . $invoice_line->idinvoiceline . "]]></idinvoiceline>\n"; $xml .= " <idinvoice><![CDATA[" . $invoice_line->idinvoice . "]]></idinvoice>\n"; $xml .= " <description><![CDATA[" . $invoice_line->description . "]]></description>\n"; $xml .= " <price><![CDATA[" . $invoice_line->price . "]]></price>\n"; $xml .= " <qty><![CDATA[" . $invoice_line->qty . "]]></qty>\n"; $xml .= " <total><![CDATA[" . $invoice_line->total . "]]></total>\n"; $xml .= " <item><![CDATA[" . $invoice_line->item . "]]></item>\n"; $xml .= " <line_tax><![CDATA[" . $invoice_line->line_tax . "]]></line_tax>\n"; $xml .= " <discounted_amount><![CDATA[" . $invoice_line->discounted_amount . "]]></discounted_amount>\n"; $xml .= " <taxed_amount><![CDATA[" . $invoice_line->taxed_amount . "]]></taxed_amount>\n"; $xml .= " </invoiceline>\n"; } $invoice_line->free(); $do_recurrent_invoice = new RecurrentInvoice(); $do_recurrent_invoice->getRecurrentInvoiceDetail($do_invoice->getData("idinvoice")); while ($do_recurrent_invoice->next()) { $xml .= " <recurrentinvoice>\n"; $xml .= " <idrecurrentinvoice><![CDATA[" . $do_recurrent_invoice->getData("idrecurrentinvoice") . "]]></idrecurrentinvoice>\n"; $xml .= " <iduser><![CDATA[" . $do_recurrent_invoice->getData("iduser") . "]]></iduser>\n"; $xml .= " <idinvoice><![CDATA[" . $do_recurrent_invoice->getData("idinvoice") . "]]></idinvoice>\n"; $xml .= " <nextdate><![CDATA[" . $do_recurrent_invoice->getData("nextdate") . "]]></nextdate>\n"; $xml .= " <recurrence><![CDATA[" . $do_recurrent_invoice->getData("recurrence") . "]]></recurrence>\n"; $xml .= " <recurrencetype><![CDATA[" . $do_recurrent_invoice->getData("recurrencetype") . "]]></recurrencetype>\n"; $xml .= " </recurrentinvoice>\n"; } $do_recurrent_invoice->free(); $do_paymentlog = new PaymentLog(); $do_paymentlog->getPaymentLogDetails($do_invoice->getData("idinvoice")); while ($do_paymentlog->next()) { $xml .= " <paymentlog>\n"; $xml .= " <idpaymentlog ><![CDATA[" . $do_paymentlog->getData("idpaymentlog") . "]]></idpaymentlog >\n"; $xml .= " <timestamp><![CDATA[" . $do_paymentlog->getData("timestamp") . "]]></timestamp>\n"; $xml .= " <idinvoice><![CDATA[" . $do_paymentlog->getData("idinvoice") . "]]></idinvoice>\n"; $xml .= " <amount><![CDATA[" . $do_paymentlog->getData("amount") . "]]></amount>\n"; $xml .= " <payment_type><![CDATA[" . $do_paymentlog->getData("payment_type") . "]]></payment_type>\n"; $xml .= " <ref_num><![CDATA[" . $do_paymentlog->getData("ref_num") . "]]></ref_num>\n"; $xml .= " <date_added><![CDATA[" . $do_paymentlog->getData("date_added") . "]]></date_added>\n"; $do_payment_invoice = new PaymentInvoice(); $do_payment_invoice->getInvDetails($do_paymentlog->getData("idpaymentlog")); while ($do_payment_invoice->next()) { $xml .= " <payment_invoice>\n"; $xml .= " <idpayment_invoice><![CDATA[" . $do_payment_invoice->getData("idpayment_invoice") . "]]></idpayment_invoice>\n"; $xml .= " <idpayment><![CDATA[" . $do_payment_invoice->getData("idpayment") . "]]></idpayment>\n"; $xml .= " <idinvoice><![CDATA[" . $do_payment_invoice->getData("idinvoice") . "]]></idinvoice>\n"; $xml .= " <amount><![CDATA[" . $do_payment_invoice->getData("amount") . "]]></amount>\n"; $xml .= " </payment_invoice>\n"; } $do_payment_invoice->free(); $do_paymentlog_extra_amount = new PaymentLog(); $do_paymentlog_extra_amount->getPaymentLogExtraAmountDetails($do_paymentlog->getData("idpaymentlog")); while ($do_paymentlog_extra_amount->next()) { $xml .= " <paymentlog_extra_amount>\n"; $xml .= " <idpaymentlog_extra_amount><![CDATA[" . $do_paymentlog_extra_amount->getData("idpaymentlog_extra_amount") . "]]></idpaymentlog_extra_amount>\n"; $xml .= " <idpaymentlog><![CDATA[" . $do_paymentlog_extra_amount->getData("idpaymentlog") . "]]></idpaymentlog>\n"; $xml .= " <extra_amt><![CDATA[" . $do_paymentlog_extra_amount->getData("extra_amt") . "]]></extra_amt>\n"; $xml .= " <iduser><![CDATA[" . $do_paymentlog_extra_amount->getData("iduser") . "]]></iduser>\n"; $xml .= " </paymentlog_extra_amount>\n"; } $do_paymentlog_extra_amount->free(); $xml .= " </paymentlog>\n"; } $do_paymentlog->free(); $xml .= " </invoice>\n"; } $do_invoice->free(); $do_tag = new Tag(); $do_tag->getUserContactTags($iduser, $do_contact->getData("idcontact")); while ($do_tag->next()) { $xml .= " <tag>\n"; $xml .= " <idtag><![CDATA[" . $do_tag->idtag . "]]></idtag>\n"; $xml .= " <tag_name><![CDATA[" . $do_tag->tag_name . "]]></tag_name>\n"; $xml .= " <iduser><![CDATA[" . $do_tag->iduser . "]]></iduser>\n"; $xml .= " <reference_type><![CDATA[" . $do_tag->reference_type . "]]></reference_type>\n"; $xml .= " <idreference><![CDATA[" . $do_tag->idreference . "]]></idreference>\n"; $xml .= " <date_added><![CDATA[" . $do_tag->date_added . "]]></date_added>\n"; $xml .= " </tag>\n"; } $do_tag->free(); $xml .= " </contact>\n"; $i++; } //end line $xml .= "</contacts>\n"; } else { // if no contact $do_task = new Task(); $do_task->getContactTasksAssociatedWithProjectWithUser($iduser); while ($do_task->next()) { $do_project = new Project(); $do_project->getId($do_task->idproject); $xml .= " <project>\n"; $xml .= " <idproject><![CDATA[" . $do_project->idproject . "]]></idproject>\n"; $xml .= " <iduser><![CDATA[" . $do_project->iduser . "]]></iduser>\n"; $xml .= " <name><![CDATA[" . $do_project->name . "]]></name>\n"; $xml .= " <end_date_dateformat><![CDATA[" . $do_project->end_date_dateformat . "]]></end_date_dateformat>\n"; $xml .= " <idcompany><![CDATA[" . $do_project->idcompany . "]]></idcompany>\n"; $xml .= " <status><![CDATA[" . $do_project->status . "]]></status>\n"; $xml .= " <effort_estimated_hrs><![CDATA[" . $do_project->effort_estimated_hrs . "]]></effort_estimated_hrs>\n"; $xml .= " <is_public><![CDATA[" . $do_project->is_public . "]]></is_public>\n\n"; $xml .= " <project_task>\n"; $xml .= " <idproject_task><![CDATA[" . $do_task->getData("idproject_task") . "]]></idproject_task>\n"; $xml .= " <idtask><![CDATA[" . $do_task->getData("idtask") . "]]></idtask>\n"; $xml .= " <idproject><![CDATA[" . $do_task->getData("idproject") . "]]></idproject>\n"; $xml .= " <progress><![CDATA[" . $do_task->getData("progress") . "]]></progress>\n"; $xml .= " <drop_box_code><![CDATA[" . $do_task->getData("drop_box_code") . "]]></drop_box_code>\n"; $xml .= " <priority><![CDATA[" . $do_task->getData("priority") . "]]></priority>\n"; $xml .= " <hrs_work_expected><![CDATA[" . $do_task->getData("hrs_work_expected") . "]]></hrs_work_expected>\n"; $xml .= " <task_description><![CDATA[" . $do_task->getData("task_description") . "]]></task_description>\n"; $xml .= " <due_date><![CDATA[" . $do_task->getData("due_date") . "]]></due_date>\n"; $xml .= " <category><![CDATA[" . $do_task->getData("category") . "]]></category>\n"; $xml .= " <iduser><![CDATA[" . $do_task->getData("iduser") . "]]></iduser>\n"; $xml .= " <due_date_dateformat><![CDATA[" . $do_task->getData("due_date_dateformat") . "]]></due_date_dateformat>\n"; $xml .= " <status><![CDATA[" . $do_task->getData("status") . "]]></status>\n"; $xml .= " <date_completed><![CDATA[" . $do_task->getData("date_completed") . "]]></date_completed>\n"; $xml .= " <idcontact><![CDATA[" . $do_task->getData("idcontact") . "]]></idcontact>\n"; $xml .= " <from_note><![CDATA[" . $do_task->getData("from_note") . "]]></from_note>\n"; $xml .= " <is_sp_date_set><![CDATA[" . $do_task->getData("is_sp_date_set") . "]]></is_sp_date_set>\n"; $xml .= " <task_category><![CDATA[" . $do_task->getData("task_category") . "]]></task_category>\n\n"; $do_prj_discuss = new ProjectDiscuss(); $do_prj_discuss->getProjectTaskDiscussions($do_task->getData("idproject_task")); while ($do_prj_discuss->next()) { $xml .= " <project_discuss>\n"; $xml .= " <idproject_discuss><![CDATA[" . $do_prj_discuss->getData("idproject_discuss") . "]]></idproject_discuss>\n"; $xml .= " <idproject_task><![CDATA[" . $do_prj_discuss->getData("idproject_task") . "]]></idproject_task>\n"; $xml .= " <idtask><![CDATA[" . $do_prj_discuss->getData("idtask") . "]]></idtask>\n"; $xml .= " <idproject><![CDATA[" . $do_prj_discuss->getData("idproject") . "]]></idproject>\n"; $xml .= " <discuss><![CDATA[" . $do_prj_discuss->getData("discuss") . "]]></discuss>\n"; $xml .= " <date_added><![CDATA[" . $do_prj_discuss->getData("date_added") . "]]></date_added>\n"; $xml .= " <document><![CDATA[" . $do_prj_discuss->getData("document") . "]]></document>\n"; $xml .= " <iduser><![CDATA[" . $do_prj_discuss->getData("iduser") . "]]></iduser>\n"; $xml .= " <drop_box_sender><![CDATA[" . $do_prj_discuss->getData("drop_box_sender") . "]]></drop_box_sender>\n"; $xml .= " <priority><![CDATA[" . $do_prj_discuss->getData("priority") . "]]></priority>\n"; $xml .= " <hours_work><![CDATA[" . $do_prj_discuss->getData("hours_work") . "]]></hours_work>\n"; $xml .= " <discuss_edit_access><![CDATA[" . $do_prj_discuss->getData("discuss_edit_access") . "]]></discuss_edit_access>\n"; $xml .= " </project_discuss>\n"; } $do_prj_discuss->free(); $xml .= " </project_task>\n"; $xml .= " </project>\n"; $do_project->free(); } $do_task->free(); $do_task = new Task(); $do_task->getProjectsWithNoTask($iduser); while ($do_task->next()) { $do_project = new Project(); $do_project->getId($do_task->idproject); $xml .= " <project>\n"; $xml .= " <idproject><![CDATA[" . $do_project->idproject . "]]></idproject>\n"; $xml .= " <iduser><![CDATA[" . $do_project->iduser . "]]></iduser>\n"; $xml .= " <name><![CDATA[" . $do_project->name . "]]></name>\n"; $xml .= " <end_date_dateformat><![CDATA[" . $do_project->end_date_dateformat . "]]></end_date_dateformat>\n"; $xml .= " <idcompany><![CDATA[" . $do_project->idcompany . "]]></idcompany>\n"; $xml .= " <status><![CDATA[" . $do_project->status . "]]></status>\n"; $xml .= " <effort_estimated_hrs><![CDATA[" . $do_project->effort_estimated_hrs . "]]></effort_estimated_hrs>\n"; $xml .= " <is_public><![CDATA[" . $do_project->is_public . "]]></is_public>\n"; $xml .= " </project>\n"; } $do_task->free(); } $do_login_audit = new LoginAudit(); $do_login_audit->getLoginAuditDetails($iduser); while ($do_login_audit->next()) { $xml .= " <login_audit>\n"; $xml .= " <idlogin_audit><![CDATA[" . $do_login_audit->idlogin_audit . "]]></idlogin_audit>\n"; $xml .= " <iduser><![CDATA[" . $do_login_audit->iduser . "]]></iduser>\n"; $xml .= " <last_login><![CDATA[" . $do_login_audit->last_login . "]]></last_login>\n"; $xml .= " <ip_address><![CDATA[" . $do_login_audit->ip_address . "]]></ip_address>\n"; $xml .= " <login_type><![CDATA[" . $do_login_audit->login_type . "]]></login_type>\n"; $xml .= " </login_audit>\n"; $xml .= " </document>\n"; } $do_login_audit->free(); if (!is_dir(XML_EXPORT)) { mkdir(XML_EXPORT); } $xml_file = XML_EXPORT . "adm_" . $iduser . "_inactiveuser_bkp.xml"; $handle_xml = fopen($xml_file, "w+"); if (fwrite($handle_xml, $xml) === FALSE) { //$_SESSION['in_page_message'] = "ofuz_export_xml_failure"; echo 'could not write'; exit; } else { $_SESSION['in_page_message'] = "ofuz_export_xml_success"; } fclose($handle_xml); //Below method deletes user information $deleteuser = new OfuzCancelAccount(); $deleteuser->deleteUserAccount($iduser); $do_login_audit = new LoginAudit(); $id = $do_login_audit->getLastLogin($iduser); $do_login_audit->getId($id); $do_login_audit->delete(); $do_login_audit->free(); }
/** * Add the note to the workfeed * Select all other Co-Worker on the project and push the note to them. * Every Co-Worker in the project get the feed except the one posting the note. * @param EventControler object */ function eventAddFeed(EventControler $evtcl) { $prefix_note = $evtcl->block_unblock_flag == "Block" ? "<b>Task Block </b>" : "<b>Task Unblock </b>"; $this->idproject_task = $evtcl->ofuz_idprojecttask; $this->discuss = $prefix_note . $evtcl->block_unblock_reason; $this->iduser = $_SESSION['do_User']->iduser; $this->idproject_discuss = $evtcl->idproject_discuss; $this->idproject = $_SESSION['do_project_task']->idproject; $this->block_unblock_flag = $evtcl->block_unblock_flag; $do_project = new Project(); $do_project->getId($this->idproject); $this->project_name = $do_project->getProjectName(); $user = new User(); $user->getId($this->iduser); $this->user_full_name = $user->getFullName(); $do_contact = new Contact(); $do_contact->getContactPictureDetails($this->iduser); if ($do_contact->getNumRows()) { while ($do_contact->next()) { $this->user_picture = $do_contact->picture; $this->contact_id = $do_contact->idcontact; } } $do_proj_task_feed = new ProjectTask(); $do_proj_task_feed->getProjectTaskDetails($this->idproject_task); $this->task_description = $do_proj_task_feed->task_description; if (strlen($this->discuss) > 200) { $this->discuss = substr($this->discuss, 0, 200); $this->more = True; } else { $this->more = False; } $do_project_sharing = new ProjectSharing(); $project_users = $do_project_sharing->getCoWorkersAsArray($do_project); $project_users[] = $do_project->getProjectOwner(); $users = array(); foreach ($project_users as $project_user) { if ($_SESSION['do_User']->iduser != $project_user) { $users[] = $project_user; } } $this->addFeed($users); }
/** * Add the note to the workfeed from drop box email * Select all other Co-Worker on the project and push the note to them. * Every Co-Worker in the project get the feed except the one posting the note. * @param EventControler object */ function AddProjectDiscussFeedFromDropBox($idproject_task, $discuss, $iduser, $idproject_discuss, $idproject) { $this->idproject_task = $idproject_task; $this->discuss = $discuss; $this->iduser = $iduser; $this->idproject_discuss = $idproject_discuss; $this->idproject = $idproject; $do_project = new Project(); $do_project->getId($this->idproject); $this->project_name = $do_project->getProjectName(); $user = new User(); $user->getId($this->iduser); $this->user_full_name = $user->getFullName(); $do_contact = new Contact(); $do_contact->getContactPictureDetails($this->iduser); if ($do_contact->getNumRows()) { while ($do_contact->next()) { $co_workers[] = $do_->idcoworker; $this->user_picture = $do_contact->picture; $this->contact_id = $do_contact->idcontact; } } $do_proj_task_feed = new ProjectTask(); $do_proj_task_feed->getProjectTaskDetails($this->idproject_task); $this->task_description = $do_proj_task_feed->task_description; if (strlen($this->discuss) > 200) { $this->discuss = substr($this->discuss, 0, 200); $this->more = True; } else { $this->more = False; } $do_project_sharing = new ProjectSharing(); $project_users = $do_project_sharing->getCoWorkersAsArray($do_project); $project_users[] = $do_project->getProjectOwner(); $users = array(); foreach ($project_users as $project_user) { if ($iduser != $project_user) { $users[] = $project_user; } } $this->addFeed($users); }
echo '</div>'; $user_coworker = new User(); while ($_SESSION['do_coworker']->next()) { $user_coworker->getId($_SESSION['do_coworker']->idcoworker); echo '<div class="contact" id="cw' . $_SESSION['do_coworker']->idcoworker . '" onclick="fnHighlightCoworkers(\'' . $_SESSION['do_coworker']->idcoworker . '\')">'; echo '<input type="checkbox" class="ofuz_list_checkbox" name="cwid[]" id="cwid' . $_SESSION['do_coworker']->idcoworker . '" value="' . $_SESSION['do_coworker']->idcoworker . '" onclick="fnHighlightCoworkers(\'' . $_SESSION['do_coworker']->idcoworker . '\')"> '; $no_cont_shared = $_SESSION['do_contact_sharing']->countSharedContacts($_SESSION['do_coworker']->idcoworker); $no_cont_shared_by_co_worker = $_SESSION['do_contact_sharing']->countSharedContactsByCoWorker($_SESSION['do_coworker']->idcoworker); /*echo '<div style="width:auto;">' .$user_coworker->getFullName(). '</div> ';*/ $do_contact = new Contact(); $do_contact->getUserContacts($_SESSION['do_coworker']->idcoworker); if ($do_contact->getNumRows()) { while ($do_contact->next()) { $co_workers[] = $do_->idcoworker; $user_picture = $do_contact->picture; $contact_id = $do_contact->idcontact; } } if ($user_picture == '') { $user_pic = "/images/empty_avatar.gif"; } else { $user_pic = "/dbimage/" . $user_picture; } echo '<div class="feed_user_pic" style="overflow:hidden;">'; $user_first_name = $_SESSION['do_coworker']->firstname; echo '<a href="/profile/' . $user_first_name[0] . '"> <img height="100%" alt="" src=' . $user_pic . ' > </a>'; echo '</div>'; echo '<div style="width:auto;"><a style="color:#C52EAD;" href="#" onclick="showSharedDetail(\'' . $_SESSION['do_coworker']->idcoworker . '\');" >' . $_SESSION['do_coworker']->firstname . ' ' . $_SESSION['do_coworker']->lastname . '</a></div>
</div> <div class="left_menu_footer"></div> <br /><br /> <div class="left_menu_header"> <div class="left_menu_header_content"><?php echo _('People in this Company'); ?> </div> </div> <div class="left_menu"> <div class="left_menu_content"> <?php $do_comp_cont = new Contact(); $do_comp_cont->getCompanyRelatedContacts($idcompany); if ($do_comp_cont->getNumRows()) { while ($do_comp_cont->next()) { $currentpage = $_SERVER['PHP_SELF']; //$e_detail = new Event("mydb.gotoPage"); //$e_detail->addParam("goto", "contact.php"); //$e_detail->addParam("idcontact",$do_comp_cont->idcontact); //$e_detail->addParam("tablename", "contact"); //$e_detail->requestSave("eDetail_contact", $currentpage); $id_shared_owner = $do_comp_cont->isContactRelatedToUser($do_comp_cont->idcontact); ?> <span class="contact_name"> <?php if ($id_shared_owner) { ?> <a href="/Contact/<?php echo $do_comp_cont->idcontact;
public function rebuildContactUserTable($iduser = 0) { if (empty($iduser)) { $iduser = $this->iduser; } $this->setUser($iduser); //$this->sql_view_name = "userid".$iduser."_contact"; $this->query("DROP VIEW IF EXISTS " . $this->sql_view_name); $this->query("DROP TABLE IF EXISTS " . $this->sql_view_name); $this->query("CREATE TABLE `" . $this->sql_view_name . "` (\n\t\t\t`idcontact` int(10) NOT NULL default '0',\n\t\t\t`firstname` varchar(50) NOT NULL,\n\t\t\t`lastname` varchar(60) NOT NULL,\n\t\t\t`company` varchar(70) NOT NULL,\n\t\t\t`idcompany` int(10) NOT NULL,\n\t\t\t`position` varchar(60) NOT NULL,\n\t\t\t`picture` varchar(200) NOT NULL,\n\t\t\t`email_address` varchar(180),\n\t\t\t`phone_number` varchar(30),\n\t\t\t`tags` varchar(250) NOT NULL,\n\t\t\t`last_activity` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,\n\t\t\t`last_update` timestamp NOT NULL default '0000-00-00 00:00:00',\n\t\t\t`first_created` timestamp NOT NULL default '0000-00-00 00:00:00',\n\t\t\tKEY `firstname` (`firstname`),\n\t\t\tKEY `lastname` (`lastname`),\n\t\t\tKEY `company` (`company`), \n\t\t\tKEY `tags` (`tags`), \n\t\t\tKEY `last_activity` (`last_activity`)) ENGINE=MyISAM DEFAULT CHARSET=utf8"); //echo $this->getSqlQuery(); // exit; $contacts = new Contact(); $contacts->getUserContacts($this->iduser); $this->setLog("\n importing Contacts:" . $contacts->getNumRows()); while ($contacts->next()) { $this->setLog("\n name:" . $contacts->firstname); $this->rebuildAddContact($contacts); } /** $contacts->query("SELECT contact.idcontact as idcontact, contact.firstname as firstname, contact.lastname as lastname, contact.company as company, contact.idcompany as idcompany, contact.position as position, contact.picture as picture FROM contact, contact_sharing WHERE `contact_sharing`.`idcoworker` = ".$this->iduser." AND contact.idcontact = contact_sharing.idcontact"); while($contacts->next) { $this->rebuildAddContact($contacts); } **/ /** $this->query("SELECT contact.idcontact as idcontact, contact.firstname as firstname, contact.lastname as lastname, contact.company as company, contact.idcompany as idcompany, contact.position as position, contact.picture as picture, contact_email.email_address as email_address, contact_phone.phone_number, GROUP_CONCAT(DISTINCT tag.tag_name ORDER BY tag.tag_name SEPARATOR ',') as tags, activity.when, created_date_log.created_date, updated_date_log.updatedate FROM contact LEFT JOIN contact_email ON contact.idcontact = contact_email.idcontact LEFT JOIN contact_phone ON contact.idcontact = contact_phone.idcontact LEFT JOIN tag ON (contact.idcontact = tag.idreference AND reference_type='contact' AND tag.iduser="******") LEFT JOIN activity ON (contact.idcontact = activity.idcontact) LEFT JOIN created_date_log ON (created_date_log.id = contact.idcontact AND created_date_log.table_name='contact') LEFT JOIN updated_date_log ON (updated_date_log.primarykeyvalue = contact.idcontact AND updated_date_log.tablename='contact') WHERE contact.iduser = "******" GROUP BY contact.idcontact UNION SELECT contact.idcontact as idcontact, contact.firstname as firstname, contact.lastname as lastname, contact.company as company, contact.idcompany as idcompany, contact.position as position, contact.picture as picture, contact_email.email_address as email_address, contact_phone.phone_number, GROUP_CONCAT(DISTINCT tag.tag_name ORDER BY tag.tag_name SEPARATOR ',') as tags, activity.when, created_date_log.created_date, updated_date_log.updatedate FROM contact LEFT JOIN tag ON (contact.idcontact = tag.idreference AND reference_type='contact' AND tag.iduser="******"), contact_sharing LEFT JOIN contact_email ON contact_sharing.idcontact = contact_email.idcontact LEFT JOIN contact_phone ON contact_sharing.idcontact = contact_phone.idcontact LEFT JOIN activity ON (contact_sharing.idcontact = activity.idcontact) LEFT JOIN created_date_log ON (created_date_log.id = contact_sharing.idcontact AND created_date_log.table_name='contact') LEFT JOIN updated_date_log ON (updated_date_log.primarykeyvalue = contact_sharing.idcontact AND updated_date_log.tablename='contact') WHERE `contact_sharing`.`idcoworker` = ".$iduser." AND contact.idcontact = contact_sharing.idcontact GROUP BY contact.idcontact "); $this->setLog("\n---------\n Users contact: ".$this->getSqlQuery()."\n----------\n"); $q_insert = new sqlQuery($this->getDbCon()); while($this->next()) { $q_insert->query("INSERT INTO ".$this->sql_view_name." VALUES (".$this->idcontact.", '".addslashes($this->firstname)."', '".addslashes($this->lastname)."', '".addslashes($this->company)."', ".$this->idcompany.", '".addslashes($this->position)."', '".$this->picture."', '".$this->email_address."', '".$this->phone_number."', '".addslashes($this->tags)."', '".$this->when."', '".$this->created_date."', '".$this->updatedate."')"); $this->setLog("\n ".$q_insert->getSqlQuery()); } //$this->setLog("\n Create table contact:".$this->getSqlQuery()); */ $_SESSION['refresh_contacts'] = false; $_SESSION['contact_view_name'] = $this->sql_view_name; }