Example #1
0
 function strExportPage(&$sRpt)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     if (!bTestForURLHack('allowExports')) {
         return;
     }
     switch ($sRpt->rptName) {
         case CENUM_REPORTNAME_GROUP:
             return $this->groups->strGroupReportPage($sRpt->enumContext, $sRpt->groupIDs, $sRpt->bShowAny, false, null, null);
             break;
         case CENUM_REPORTNAME_VOLJOBSKILL:
             return $this->clsVolSkills->strJobSkillsReportPage($sRpt->skillIDs, $sRpt->bShowAny, $sRpt->bIncludeInactive, false, null, null);
             break;
         case CENUM_REPORTNAME_VOLHOURSVIAVID:
             return $this->clsVolHours->strHoursViaVIDReport($sRpt, false, null, null, null);
             break;
         case CENUM_REPORTNAME_VOLHOURSTFSUM:
             if (bAllowAccess('showReports')) {
                 return $this->clsVolHours->strVolHoursTFSumReportExport($sRpt, false, null, null);
             } else {
                 return '';
             }
             break;
         case CENUM_REPORTNAME_SPONPASTDUE:
             $dummy = null;
             return $this->clsSCP->strSponsorPastDueReport($this, $sRpt, $sRpt->reportID, false, $dummy);
             break;
         case CENUM_REPORTNAME_GIFTACK:
             return $this->clsGifts->strGiftAckReportExport($sRpt, null, false, null, null);
             break;
         case CENUM_REPORTNAME_GIFTRECENT:
             return $this->clsGifts->strGiftRecentReportExport($sRpt, null, false, null, null);
             break;
         case CENUM_REPORTNAME_HONMEMGIFTLIST:
             return $this->clsGifts->strHonMemReportExport($sRpt, false, null, null);
             break;
         case CENUM_REPORTNAME_GIFTTIMEFRAME:
         case CENUM_REPORTNAME_GIFTACCOUNT:
         case CENUM_REPORTNAME_GIFTCAMP:
         case CENUM_REPORTNAME_GIFTYEAREND:
             return $this->clsGifts->strGiftTimeFrameReportExport($sRpt, null, false, null, null);
             break;
         case CENUM_REPORTNAME_SPONVIAPROG:
             $dummy = null;
             return $this->clsSponProg->strSponViaProgReportExport($sRpt, $dummy, false, null, null);
             break;
         case CENUM_REPORTNAME_SPONVIALOCID:
             $dummy = null;
             return $this->clsSpon->strSponViaLocReportExport($sRpt, $dummy, false, null, null);
             break;
         case CENUM_REPORTNAME_SPONWOCLIENT:
             $dummy = null;
             return $this->clsSpon->strSponWOClientReportExport($sRpt, $dummy, false, null, null);
             break;
         case CENUM_REPORTNAME_ATTRIB:
             $dummy = null;
             return $this->clsAttrib->strAttribReportExport($sRpt, $dummy, false, null, null);
             break;
         case CENUM_REPORTNAME_SPONINCOMEMONTH:
             $dummy = null;
             return $this->clsSpon->strSponIncomeMonthReportExport($sRpt, $dummy, false, null, null);
             break;
         case CENUM_REPORTNAME_CLIENTAGE:
             return $this->cCRpt->strClientAgeReportExport($sRpt, false, null, null);
             break;
         case CENUM_REPORTNAME_CLIENTVIASTATUS:
             return $this->cCRpt->strCViaStatIDReportExport($sRpt, false, null, null);
             break;
         case CENUM_REPORTNAME_CLIENTVIASTATCAT:
             return $this->cCRpt->strCViaStatCatIDReportExport($sRpt, false, null, null);
             break;
         case CENUM_REPORTNAME_CLIENTBDAY:
             return $this->cCRpt->strClientBDayReportExport($sRpt, false, null, null);
             break;
         case CENUM_REPORTNAME_VOLEVENTSCHEDULE:
             $dummy = null;
             return $this->clsVolEvents->scheduleReportExport($sRpt, $dummy, false);
             break;
         case CENUM_REPORTNAME_VOLHRS_PVA:
             return $this->clsVolHours->strVolHoursPVAReportExport($sRpt, false, null, null);
             break;
         case CENUM_REPORTNAME_VOLHRSDETAIL_PVA:
             return $this->clsVolHours->strVolHoursPVADetailReportExport($sRpt, false, null, null);
             break;
         case CENUM_REPORTNAME_VOL_HRS_SUM:
             return $this->clsVolHours->strVolHoursSumReportExport($sRpt, false, null, null);
             break;
         case CENUM_REPORTNAME_VOL_HRS_MON:
             return $this->clsVolHours->strVolHoursViaMonthReportExport($sRpt, false, null, null);
             break;
         case CENUM_REPORTNAME_VOL_HRS_DETAIL:
             return $this->clsVolHours->strVolHoursDetailReportExport($sRpt, false, null, null);
             break;
         case CENUM_REPORTNAME_DEPOSITLOG:
             return $this->clsDeposits->strDepositLogReportExport($sRpt, false, null, null);
             break;
         case CENUM_REPORTNAME_DEPOSITENTRY:
             return $this->clsDeposits->strDepositEntryExport($sRpt);
             break;
         default:
             $this->session->set_flashdata('error', 'This report is currenly not available for export.');
             redirect_Reports();
             break;
     }
 }
 function run($reportID)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $displayData = array();
     $displayData['js'] = '';
     //------------------------------------------------
     // models, libraries and utilities
     //------------------------------------------------
     $this->load->model('admin/mpermissions', 'perms');
     $this->load->model('personalization/muser_fields', 'clsUF');
     $this->load->model('personalization/muser_schema', 'cUFSchema');
     $this->load->model('client_features/mcprograms', 'cprograms');
     $this->load->model('client_features/mcprog_enrollee_rpt', 'cperpt');
     $this->load->helper('clients/link_client_features');
     $this->load->helper('dl_util/web_layout');
     $params = array('enumStyle' => 'terse', 'clsRpt');
     $this->load->library('generic_rpt', $params);
     if (!isset($_SESSION[CS_NAMESPACE . 'Reports'][$reportID])) {
         $this->session->set_flashdata('error', 'The report you requested is no longer available. Please run the report again.');
         redirect_Reports();
     }
     //------------------------------------------------
     // stripes
     //------------------------------------------------
     $this->load->model('util/mbuild_on_ready', 'clsOnReady');
     $this->clsOnReady->addOnReadyTableStripes();
     $this->clsOnReady->closeOnReady();
     $displayData['js'] .= $this->clsOnReady->strOnReady;
     $sRpt = $_SESSION[CS_NAMESPACE . 'Reports'][$reportID];
     $sRpt->timeStamp = time();
     $sRpt->strCProgIn = ' IN (' . implode(',', $sRpt->cProgIDs) . ') ';
     $displayData['dateRange'] = $sRpt->strDateRange;
     $this->cperpt->loadReportEnrolless($sRpt);
     $displayData['lNumEnrollees'] = $this->cperpt->lNumEnrollees;
     $displayData['enrollees'] =& $this->cperpt->enrollees;
     $displayData['cprogs'] =& $this->cperpt->cprogs;
     //--------------------------
     // breadcrumbs
     //--------------------------
     $displayData['pageTitle'] = anchor('main/menu/reports', 'Reports', 'class="breadcrumb"') . ' | ' . anchor('cprograms/cprog_enrollees/opts', ' Client Programs: Enrollees', 'class="breadcrumb"') . ' | Run';
     $displayData['title'] = CS_PROGNAME . ' | Reports';
     $displayData['nav'] = $this->mnav_brain_jar->navData();
     $displayData['mainTemplate'] = 'cprograms/cprograms_enrollee_rpt_run_view';
     $this->load->vars($displayData);
     $this->load->view('template');
 }
 function run($reportID)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $displayData = array();
     $displayData['js'] = '';
     //------------------------------------------------
     // models, libraries and utilities
     //------------------------------------------------
     $this->load->model('reports/mreports', 'clsReports');
     $this->load->model('groups/mgroups', 'groups');
     $this->load->helper('groups/groups');
     $this->load->helper('reports/report_util');
     if (!isset($_SESSION[CS_NAMESPACE . 'Reports'][$reportID])) {
         $this->session->set_flashdata('error', 'The report you requested is no longer available. Please run the report again.');
         redirect_Reports();
     }
     $sRpt = $_SESSION[CS_NAMESPACE . 'Reports'][$reportID];
     $sRpt->timeStamp = time();
     $displayData['dateRange'] = $sRpt->strDateRange;
     $displayData['enumSource'] = $enumSource = $sRpt->enumSource;
     if ($enumSource != 'client') {
         $sRpt->enumGroup = 'individual';
     }
     $displayData['enumGroup'] = $enumGroup = $sRpt->enumGroup;
     //------------------------------------------------
     // libraries and utilities
     //------------------------------------------------
     $this->load->library('util/dl_date_time', '', 'clsDateTime');
     $this->load->library('generic_form');
     $this->load->helper('dl_util/time_date');
     $this->load->helper('dl_util/web_layout');
     $this->load->model('reports/mdata_entry_log', 'cde');
     $params = array('enumStyle' => 'terse', 'clsRpt');
     $this->load->library('generic_rpt', $params);
     // client programs
     $this->load->model('admin/mpermissions', 'perms');
     $this->load->model('personalization/muser_fields', 'clsUF');
     $this->load->model('personalization/muser_schema', 'cUFSchema');
     $this->load->model('client_features/mcprograms', 'cprograms');
     //------------------------------------------------
     // stripes
     //------------------------------------------------
     $this->load->model('util/mbuild_on_ready', 'clsOnReady');
     $this->clsOnReady->addOnReadyTableStripes();
     $this->clsOnReady->closeOnReady();
     $displayData['js'] .= $this->clsOnReady->strOnReady;
     $this->cde->loadDataEntryStats($sRpt);
     switch ($enumSource) {
         case 'client':
             $displayData['strRptType'] = 'Client record entry';
             $displayData['strTotCnt'] = 'Tot. Client recs during timeframe';
             $displayData['lTotRecCnt'] = $this->cde->lTotClientCnt;
             break;
         case 'enroll':
             $displayData['strRptType'] = 'Client Programs: Enrollment Records';
             $displayData['strTotCnt'] = 'Tot. Enroll. recs during timeframe';
             $displayData['lTotRecCnt'] = $this->cde->lTotEnrollAttendCnt;
             break;
         case 'attend':
             $displayData['strRptType'] = 'Client Programs: Attendance Records';
             $displayData['strTotCnt'] = 'Tot. Attend. recs during timeframe';
             $displayData['lTotRecCnt'] = $this->cde->lTotEnrollAttendCnt;
             break;
         default:
             screamForHelp($enumSource . ': invalid report source<br>error on line  <b> -- ' . __LINE__ . ' --</b>,<br>file ' . __FILE__ . ',<br>function ' . __FUNCTION__);
             break;
     }
     switch ($enumGroup) {
         case 'individual':
             $displayData['strRptGroup'] = 'Grouped by Individual Users';
             switch ($enumSource) {
                 case 'client':
                     $displayData['lNumEntries'] = $this->cde->lNumEntries;
                     $displayData['entries'] =& $this->cde->entries;
                     break;
                 case 'attend':
                 case 'enroll':
                     $displayData['lNumEntries'] = $this->cde->lTotEnrollAttendCnt;
                     $displayData['cprogs'] =& $this->cde->ccprogs->cprogs;
                     break;
                 default:
                     screamForHelp($enumSource . ': invalid report source<br>error on line  <b> -- ' . __LINE__ . ' --</b>,<br>file ' . __FILE__ . ',<br>function ' . __FUNCTION__);
                     break;
             }
             break;
         case 'staffGroup':
             $displayData['strRptGroup'] = 'By Staff Group';
             switch ($enumSource) {
                 case 'client':
                     $displayData['lNumStaffGroups'] = $this->cde->lNumStaffGroups;
                     $displayData['staffGroups'] =& $this->cde->staffGroups;
                     break;
                 default:
                     screamForHelp($enumSource . ': invalid report source<br>error on line  <b> -- ' . __LINE__ . ' --</b>,<br>file ' . __FILE__ . ',<br>function ' . __FUNCTION__);
                     break;
             }
             break;
         default:
             screamForHelp($enumGroup . ': invalid report group<br>error on line  <b> -- ' . __LINE__ . ' --</b>,<br>file ' . __FILE__ . ',<br>function ' . __FUNCTION__);
             break;
     }
     //--------------------------
     // breadcrumbs
     //--------------------------
     $displayData['pageTitle'] = anchor('main/menu/reports', 'Reports', 'class="breadcrumb"') . ' | ' . anchor('reports/pre_data_entry/daOpts', 'Data Entry Log', 'class="breadcrumb"') . ' | View Report';
     $displayData['title'] = CS_PROGNAME . ' | Reports';
     $displayData['nav'] = $this->mnav_brain_jar->navData();
     $displayData['mainTemplate'] = 'reports/pre_data_entry_log_rpt_view';
     $this->load->vars($displayData);
     $this->load->view('template');
 }
 function complete($reportID)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     //------------------------------------------------
     // models, libraries and utilities
     //------------------------------------------------
     $this->load->library('util/dl_date_time', '', 'clsDateTime');
     $this->load->helper('reports/report_util');
     $this->load->helper('dl_util/web_layout');
     $params = array('enumStyle' => 'terse', 'clsRpt');
     $this->load->library('generic_rpt', $params);
     if (!isset($_SESSION[CS_NAMESPACE . 'Reports'][$reportID])) {
         $this->session->set_flashdata('error', 'The report you requested is no longer available. Please run the report again.');
         redirect_Reports();
     }
     $sRpt = $_SESSION[CS_NAMESPACE . 'Reports'][$reportID];
     $enumContext = $sRpt->enumContext;
     switch ($enumContext) {
         case CENUM_CONTEXT_CLIENT:
             $this->load->model('clients/mclients', 'cclients');
             $this->cclients->loadClientsViaClientID($sRpt->goodID);
             $displayData['client'] = $this->cclients->clients[0];
             $displayData['dupCIDs'] = $sRpt->dupIDs;
             $displayData['pageTitle'] = anchor('main/menu/client', 'Clients', 'class="breadcrumb"') . ' | ' . anchor('util/dup_records/opts/' . CENUM_CONTEXT_CLIENT, 'Client Duplicates', 'class="breadcrumb"') . ' | Client Duplicates: Completed';
             $displayData['title'] = CS_PROGNAME . ' | Clients';
             $displayData['mainTemplate'] = 'util/dup_complete_clients_view';
             break;
         case CENUM_CONTEXT_PEOPLE:
             //            $this->load->helper('dl_util/email_web');
             $this->load->model('admin/madmin_aco', 'clsACO');
             $this->load->model('people/mpeople', 'clsPeople');
             $this->clsPeople->loadPeopleViaPIDs($sRpt->goodID, false, false);
             $displayData['people'] = $this->clsPeople->people[0];
             $displayData['dupIDs'] = $sRpt->dupIDs;
             $displayData['pageTitle'] = anchor('main/menu/people', 'People', 'class="breadcrumb"') . ' | ' . anchor('util/dup_records/opts/' . CENUM_CONTEXT_PEOPLE, 'Duplicate People Records', 'class="breadcrumb"') . ' | People Duplicates: Completed';
             $displayData['title'] = CS_PROGNAME . ' | People';
             $displayData['mainTemplate'] = 'util/dup_complete_people_view';
             break;
         case CENUM_CONTEXT_BIZ:
             //            $this->load->helper('dl_util/email_web');
             $this->load->model('admin/madmin_aco', 'clsACO');
             $this->load->model('biz/mbiz', 'clsBiz');
             $this->clsBiz->loadBizRecsViaBID($sRpt->goodID, false, false);
             $displayData['biz'] = $this->clsBiz->bizRecs[0];
             $displayData['dupIDs'] = $sRpt->dupIDs;
             $displayData['pageTitle'] = anchor('main/menu/biz', 'Businesses/Organizations', 'class="breadcrumb"') . ' | ' . anchor('util/dup_records/opts/' . CENUM_CONTEXT_BIZ, 'Duplicate Business Records', 'class="breadcrumb"') . ' | Business Duplicates: Completed';
             $displayData['title'] = CS_PROGNAME . ' | Businesses';
             $displayData['mainTemplate'] = 'util/dup_complete_biz_view';
             break;
         default:
             screamForHelp($enumContext . ': invalid context for duplicate record consolidation<br>error on line  <b> -- ' . __LINE__ . ' --</b>,<br>file ' . __FILE__ . ',<br>function ' . __FUNCTION__);
             break;
     }
     //--------------------------
     // breadcrumbs
     //--------------------------
     $displayData['nav'] = $this->mnav_brain_jar->navData();
     $this->load->vars($displayData);
     $this->load->view('template');
 }
 function run($reportID, $lStartRec = null, $lRecsPerPage = null, $v1 = null, $v2 = null, $v3 = null)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     $displayData = array();
     $this->load->helper('reports/report_util');
     $this->load->model('reports/mreports', 'clsReports');
     $displayData['contextSummary'] = '';
     if (!isset($_SESSION[CS_NAMESPACE . 'Reports'][$reportID])) {
         $this->session->set_flashdata('error', 'The report you requested is no longer available. Please run the report again.');
         redirect_Reports();
     }
     $sRpt = $_SESSION[CS_NAMESPACE . 'Reports'][$reportID];
     $sRpt->timeStamp = time();
     // clear out stale reports
     if (rand(1, 10) % 10 == 1) {
         $this->testStaleReports();
     }
     modelLoadViaRptType($this, $sRpt);
     //---------------------------------------------------
     // for screen reports, set the record navigation
     //---------------------------------------------------
     $this->screenRpt($reportID, $sRpt, $lStartRec, $lRecsPerPage, $v1, $v2, $v3);
 }
 function complete($reportID)
 {
     //---------------------------------------------------------------------
     //
     //---------------------------------------------------------------------
     //------------------------------------------------
     // models, libraries and utilities
     //------------------------------------------------
     $this->load->library('util/dl_date_time', '', 'clsDateTime');
     $this->load->model('clients/mclients', 'cclients');
     $this->load->helper('reports/report_util');
     $this->load->helper('dl_util/web_layout');
     $params = array('enumStyle' => 'terse', 'clsRpt');
     $this->load->library('generic_rpt', $params);
     if (!isset($_SESSION[CS_NAMESPACE . 'Reports'][$reportID])) {
         $this->session->set_flashdata('error', 'The report you requested is no longer available. Please run the report again.');
         redirect_Reports();
     }
     $sRpt = $_SESSION[CS_NAMESPACE . 'Reports'][$reportID];
     /* -------------------------------------
     echo('<font class="debug">'.substr(__FILE__, strrpos(__FILE__, '\\'))
        .': '.__LINE__.'<br>$sRpt   <pre>');
     echo(htmlspecialchars( print_r($sRpt, true))); echo('</pre></font><br>');
     // ------------------------------------- */
     $this->cclients->loadClientsViaClientID($sRpt->goodCID);
     $displayData['client'] = $this->cclients->clients[0];
     $displayData['dupCIDs'] = $sRpt->dupCIDs;
     //--------------------------
     // breadcrumbs
     //--------------------------
     $displayData['pageTitle'] = anchor('main/menu/client', 'Clients', 'class="breadcrumb"') . ' | ' . anchor('clients/client_dups/opts', 'Client Duplicates', 'class="breadcrumb"') . ' | Client Duplicates: Completed';
     $displayData['title'] = CS_PROGNAME . ' | Clients';
     $displayData['nav'] = $this->mnav_brain_jar->navData();
     $displayData['mainTemplate'] = 'client/client_dup_complete_view';
     $this->load->vars($displayData);
     $this->load->view('template');
 }