Reports Emailing

<?php

class Controller_Report extends Controller_cron

{

        public function __construct()

        {

                parent::__construct();

                SWIFT_Ticket::LoadLanguageTable();

                return true;

        }

        public function __destruct()

        {

                parent::__destruct();

                return true;

        }

    Public function MyReports ($_CustomCode = '')

    {

/*

Enter your custom reports in this section, by repeating the $_MyCustomCodes line, the format is as follows:

$_MyCustomCodes[] = Array(<Start Code>,<Report ID>,<Email Address to sent the report to>,<Email Subject>,<Email Body>);

Example:

$_MyCustomCodes[] = Array('22424324324324','111','gary@emailaddy.com','My new report!','This is my new report');

$_MyCustomCodes[] = Array('466364','111','gary@emailaddy.com','The weekly info','Please find attached your weekly ticket update');

$_MyCustomCodes[] = Array('72434242','111','gary@emailaddy.com','your daily report','Tickets submitted today');

You can also create several reports with the same Start Code, then when that start code is called, all the reports using that code will be emailed out

Example:

$_MyCustomCodes[] = Array('22424324324324','111','gary@emailaddy.com','Tickets still open','Tickets which are not resolved yet');

$_MyCustomCodes[] = Array('22424324324324','115','gary@emailaddy.com','Tickets closed this week','List of tickets closed this week');

$_MyCustomCodes[] = Array('22424324324324','123','gary@emailaddy.com','Tickets created by your staff','List of how many tickets your staff created, grouped by staff name');

ATTACH ALL REPORTS TO A SINGLE EMAIL

If you wish to attach several reports to a single email for the same customer, you can do so by replacing the report number with an array, example below:

$_MyCustomCodes[] = Array('22424324324324',array('111','65','46'),'gary@emailaddy.com','Your weekly reports','Please find attached all your weekly reports');

How to Use, once your reports are setup, you can simply call the relevant URL, and the reports will be run

Example:

http://helpdeskURL/cron/index.php?/Tickets/Report/GeneralTasks/22424324324324

You can then either schedule a task to call the reports URL as needed, or give the URL to your customers, who can then call the reports

for themselves, whenever they wish. ( Obviously you will want to assign each customer a unique code )

*/

        $_MyCustomCodes[] = Array('codehere','reportidhere','emailhere','emailsubject','emailbody');

// DO NOT EDIT BELOW THIS LINE

$_SWIFT = SWIFT::GetInstance();

    $_firedreport = false;

    foreach ($_MyCustomCodes as $CustomReports)

    {

        If ($CustomReports[0] == $_CustomCode){

            if (is_array($CustomReports[1]))

            {

            $_Finalattachments = Array();

            $_rpttext = 'The reports have been emailed out via a single email<br>Reports attached:<br> ';

            foreach ($CustomReports[1] as $Mfile) {

                  $_SWIFT_ReportObject = new SWIFT_Report(new SWIFT_DataID($Mfile));

                    $_exportFormat = 'exportexcel2007';

                    $_SWIFT_ReportExportObject = SWIFT_ReportExport::Process($_SWIFT_ReportObject, $_exportFormat);

                     $_Finalattachments[] = $_SWIFT_ReportExportObject->DispatchMEFile($Mfile);

              }

            $this->Mail = new SWIFT_Mail();

            foreach ($_Finalattachments as $attachment){

            $this->Mail->Attach($attachment[0],$attachment[1] ,$attachment[2]);

            $_rpttext .= $attachment[2] . '<br>';

            }

                        $this->Mail->SetToField($CustomReports[2]);

                        $this->Mail->SetFromField($this->Settings->Get('general_returnemail'), SWIFT::Get('companyname'));

                        $this->Mail->SetSubjectField($CustomReports[3]);

                        $this->Mail->SetDataText($CustomReports[4]);

                        $this->Mail->SetDataHTML($CustomReports[4]);

                        $this->Mail->SendMail();

            $_firedreport = true;

            echo $_rpttext . '<br>Finished.<br>';

            }else{

                $_SWIFT_ReportObject = new SWIFT_Report(new SWIFT_DataID($CustomReports[1]));

                $_exportFormat = 'exportexcel2007';

                $_SWIFT_ReportExportObject = SWIFT_ReportExport::Process($_SWIFT_ReportObject, $_exportFormat);

                $_result = $_SWIFT_ReportExportObject->DispatchEFile($CustomReports[2],$CustomReports[3],$CustomReports[4]);

                echo 'The report: ' . $CustomReports[1] .' has been emailed out<br>';

                $_firedreport = true;

            }

        }

    }

    if ($_firedreport != true){

    echo 'No Reports were found matching your request.';

    }

return;

    }

        public function GeneralTasks($_CustomCode = '')

        {

                if (!$this->GetIsClassLoaded())

                {

                        throw new SWIFT_Exception(SWIFT_CLASSNOTLOADED);

                        return false;

                }

        if ($_CustomCode == '' ){

            echo 'sorry, no valid code was entered';

            return;

        }

        self::MyReports($_CustomCode);

                return true;

        }

        /**

         * Runs the Ticket Auto Close Routines

         *

         * @author Varun Shoor

         * @return bool "true" on Success, "false" otherwise

         * @throws SWIFT_Exception If the Class is not Loaded

         */

}

?>