function eventExportUserContacts(EventControler $evtcl)
 {
     $do_contact = new Contact();
     $do_contact->getUserContacts($_SESSION['do_User']->iduser);
     $xml = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n\n";
     $xml .= "<contacts>\n";
     /**
      *Contact Exporting
      */
     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_address->free();
         $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_email->free();
         $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->idcontact . "]]></idcontact>\n";
             $xml .= "  </contact_phone>\n";
         }
         $contact_phone->free();
         $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 .= "   <type><![CDATA[" . $contact_note->type . "]]></type>\n";
             $xml .= "  </contact_note>\n";
         }
         $contact_note->free();
         $do_tag = new Tag();
         $do_tag->getUserContactTags($_SESSION['do_User']->iduser, $do_contact->getData("idcontact"));
         $do_tag->getValues();
         while ($do_tag->next()) {
             $xml .= "  <contact_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 .= "  </contact_tag>\n";
         }
         $do_tag->free();
         $do_task = new Task();
         $do_task->getContactTaskWithoutProject($do_contact->getData("idcontact"));
         while ($do_task->next()) {
             $xml .= "  <contact_task_without_project>\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_without_project>\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"));
         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 .= "     <type><![CDATA[" . $do_prj_discuss->getData("type") . "]]></type>\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();
         /**
          * Invoice
          */
         $do_invoice = new Invoice();
         $do_invoice->getContactInvoiceDetails($do_contact->getData("idcontact"));
         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();
         $xml .= " </contact>\n";
     }
     $do_task = new Task();
     $do_task->getTasksWithoutProject();
     while ($do_task->next()) {
         $xml .= " <task_without_project>\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 .= " </task_without_project>\n";
     }
     $do_task->free();
     /**
      *Company Exporting
      */
     $do_company = new Company();
     $do_company->getAllCompanies($_SESSION['do_User']->iduser);
     while ($do_company->next()) {
         $xml .= " <companies>\n";
         $xml .= " <idcompany><![CDATA[" . $do_company->getData("idcompany") . "]]></idcompany>\n";
         $xml .= " <name><![CDATA[" . $do_company->getData("name") . "]]></name>\n";
         $xml .= " </companies>\n";
     }
     $do_company->free();
     $do_prj = new Project();
     $do_prj->getUserProjects();
     while ($do_prj->next()) {
         $xml .= " <project>\n";
         $xml .= "  <idproject><![CDATA[" . $do_prj->getData("idproject") . "]]></idproject>\n";
         $xml .= "  <iduser><![CDATA[" . $do_prj->getData("iduser") . "]]></iduser>\n";
         $xml .= "  <name><![CDATA[" . $do_prj->getData("name") . "]]></name>\n";
         $xml .= "  <end_date_dateformat><![CDATA[" . $do_prj->getData("end_date_dateformat") . "]]></end_date_dateformat>\n";
         $xml .= "  <idcompany><![CDATA[" . $do_prj->getData("idcompany") . "]]></idcompany>\n";
         $xml .= "  <status><![CDATA[" . $do_prj->getData("status") . "]]></status>\n";
         $xml .= "  <effort_estimated_hrs><![CDATA[" . $do_prj->getData("effort_estimated_hrs") . "]]></effort_estimated_hrs>\n";
         $xml .= "  <is_public><![CDATA[" . $do_prj->getData("is_public") . "]]></is_public>\n\n";
         $do_task = new Task();
         $do_task->getTasksAssociatedWithProject($do_prj->getData("idproject"));
         while ($do_task->next()) {
             $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 .= "     <type><![CDATA[" . $do_prj_discuss->getData("type") . "]]></type>\n";
                 $xml .= "    </project_discuss>\n";
             }
             $do_prj_discuss->free();
             $xml .= "   </project_task>\n";
         }
         $do_task->free();
         $xml .= " </project>\n";
     }
     $do_prj->free();
     $xml .= "</contacts>\n";
     $xml_file = "xml_export/" . $_SESSION['do_User']->iduser . "_contacts.xml";
     $handle_xml = fopen($xml_file, "w+");
     if (fwrite($handle_xml, $xml) === FALSE) {
         $_SESSION['in_page_message'] = "ofuz_export_xml_failure";
     } else {
         $_SESSION['in_page_message'] = "ofuz_export_xml_success";
     }
     fclose($handle_xml);
     header('Content-Description: File Transfer');
     header('Content-Type: application/octet-stream');
     header('Content-Disposition: attachment; filename=' . basename($xml_file));
     header('Content-Transfer-Encoding: binary');
     header('Expires: 0');
     header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
     header('Pragma: public');
     header('Content-Length: ' . filesize($xml_file));
     ob_clean();
     flush();
     readfile($xml_file);
 }
	<?php 
$do_prj = new Project();
$total_public_prjs = $do_prj->getTotalPublicProjects();
?>
		<tr class="total_users"><td colspan="2">Total Public Projects: <?php 
echo $total_public_prjs;
?>
</td></tr>
		<tr class="report_heading">
   <td>Project Name</td>
			<td>Status</td>
		</tr>
<?php 
$count = 1;
$do_prj->getAllPublicProjects();
while ($do_prj->next()) {
    $class = $count % 2 == 0 ? "even" : "odd";
    ?>

    <tr class="<?php 
    echo $class;
    ?>
">
      <td><a href="/PublicProject/<?php 
    echo $do_prj->getData("idproject");
    ?>
"><?php 
    echo $do_prj->getData("name");
    ?>
</a></td>
      <td><?php 
Example #3
0
 function eventAjaxGetEditForm(EventControler $evtcl)
 {
     $Parsedown = new Parsedown();
     $_SESSION['ContactNoteEditSave']->setApplyRegistry(false, "Form");
     $html = '';
     $curdiv = $evtcl->curdiv;
     $this->getId($evtcl->idnote);
     $vis_user = $this->note_visibility == 'user' ? 'checked' : '';
     $vis_user_cw = $this->note_visibility == 'user coworker' ? 'checked' : '';
     $vis_user_cont = $this->note_visibility == 'user contact' ? 'checked' : '';
     $vis_user_cw_cont = $this->note_visibility == 'user coworker contact' ? 'checked' : '';
     $do_cont = new Contact();
     $contact_fullname = $do_cont->getContactName($evtcl->idcontact);
     if ($this->iduser == $_SESSION['do_User']->iduser) {
         $note_val = $this->note;
         $e_edit = new Event("ContactNoteEditSave->eventUpdate");
         $e_edit->setLevel(110);
         $e_edit->addEventAction("mydb.gotoPage", 111);
         $e_edit->addEventAction("ContactNoteEditSave->eventHTMLCleanUp", 109);
         $e_edit->setGotFile(true);
         $html .= $e_edit->getFormHeader();
         $html .= $e_edit->getFormEvent();
         $_SESSION['ContactNoteEditSave']->setRegistry("ofuz_add_contact_note");
         $_SESSION['ContactNoteEditSave']->setApplyRegistry(true, "Form");
         $html .= '<br />' . _('Note :') . '<br /><textarea id="note_edit" name = "fields[note]" rows="3" cols="110">' . $Parsedown->text($note_val) . '</textarea><br />';
         $html .= '<div width="100%">';
         $html .= '<div id="edit_note_more" style="position:relative;float:left;text-align:left;width:50%"><a href="#" onclick ="fnEditNoteMoreOpts();return false;">' . _('More Options') . '</a></div>';
         $html .= '<div style="position:relative;float:left;text-align:left;width:50%"><a href="javascript:;" onclick="showProjectList();">' . _('Attached to a project') . '</a>';
         $html .= '<div id="cp_prj_list" style="position:relative;display:none;">';
         $do_prjs = new Project();
         $do_prjs->getAllProjects("open");
         $num_prjs = $do_prjs->getNumRows();
         $html .= '<select name="cpy_prjs" id="cpy_prjs" onchange="populateTasks();">';
         if ($num_prjs > 0) {
             $html .= '<option value="">' . _('Select Project') . '</option>';
         } else {
             $html .= '<option value="">' . _('You do not have Project.') . '</option>';
         }
         while ($do_prjs->next()) {
             $html .= '<option value="' . $do_prjs->getData("idproject") . '">' . $do_prjs->getData("name") . '</option>';
         }
         $html .= '</select>';
         $html .= '</div>';
         $html .= '<div id="cp_prj_tasks"></div>';
         $html .= '</div></div>';
         $html .= '<div class="div_right" id="edit_note_more_opts" style="display: none;"> ';
         $html .= 'File : ' . $_SESSION['ContactNoteEditSave']->document . '<br /><br />';
         $html .= '</div>';
         $html .= '<div id="edit_note_more_opts_vis" style="text-align: left; width: 50%;display: none;"> ';
         $html .= _('Who can view this note:') . '<br />';
         $html .= '<input type="radio" name="fields[note_visibility]" value="user" ' . $vis_user . '> ' . _('Just me') . ' <br />';
         $html .= '<input type="radio" name="fields[note_visibility]" value="user coworker" ' . $vis_user_cw . '> ' . _('My Co-Workers and I') . '<br />';
         $html .= '<input type="radio" name="fields[note_visibility]" value="user contact" ' . $vis_user_cont . '> ' . $contact_fullname . _(' and I') . '<br />';
         $html .= '<input type="radio" name="fields[note_visibility]" value="user coworker contact" ' . $vis_user_cw_cont . '> ' . _('Me, Co-Workers and ') . $contact_fullname;
         $html .= '</div>';
         $html .= '<div style="text-align:right">';
         $html .= '<input type="submit" name="Save" value = "' . _('Save') . '">&nbsp;&nbsp;<a href="#" onclick = "fnCancelEdit(\'' . $curdiv . '\',' . $evtcl->idnote . ');return false;">' . _('close') . '</a>';
         $html .= '</div>';
         $html .= '</form>';
         $evtcl->addOutputValue($html);
     } else {
         $msg = new Message();
         $msg->getMessage("unauthorized_note_edit");
         $html .= $msg->content . '<br /><br />';
         $html .= '<a href="#" onclick = "fnCancelEdit(\'' . $curdiv . '\',' . $evtcl->idnote . ');return false;">' . _('close') . '</a>';
         $evtcl->addOutputValue($html);
     }
 }