/** * Get CSV data * @param [type] $data_type [description] * @return [type] [description] */ public function getCsvData($data_type) { $app = \Cobalt\Container::fetch('app'); $data = array(); $export_ids = $app->input->get('ids'); switch ($data_type) { case "deals": $model = new Deal(); $data = $model->getDeals($export_ids); break; case "companies": $model = new Company(); $data = $model->getCompanies($export_ids); break; case "people": $model = new People(); $data = $model->getPeople($export_ids); break; case "sales_pipeline": $model = new Deal(); $data = $model->getReportDeals($export_ids); break; case "source_report": $model = new Deal(); $data = $model->getDeals($export_ids); break; case "roi_report": $model = new Source(); $data = $model->getRoiSources($export_ids); break; case "notes": $model = new Note(); $data = $model->getNotes(NULL, NULL, FALSE); break; case "custom_report": $model = new Report(); $data = $model->getCustomReportData($app->input->get('report_id')); break; } if (count($data)) { $header = array_keys((array) $data[0]); } return array('header' => $header, 'rows' => $data); }
public function _display_custom_report_filter() { //get report $reportModel = new ReportModel(); $this->report = $reportModel->getCustomReports($app->input->get('id')); $this->report_data = $reportModel->getCustomReportData($app->input->get('id')); $this->state = $reportModel->getState(); }
public function _display_custom_report() { //get model $reportModel = new ReportModel(); //get report $this->report = $reportModel->getCustomReports($this->app->input->get('id')); $this->report_data = $reportModel->getCustomReportData($this->app->input->get('id')); $state = $reportModel->getState(); //info for dropdowns $deal_amounts = DealHelper::getAmounts(); $deal_sources = DealHelper::getSources(); $deal_stages = DealHelper::getSourceStages(); $deal_statuses = DealHelper::getStatuses(); $deal_close_dates = DealHelper::getClosing(); $modified_dates = DealHelper::getModified(); $custom_report_header = ViewHelper::getView('reports', 'custom_report_header', 'phtml', array('report_data' => $this->report_data, 'report' => $this->report, 'state' => $state)); $custom_report_list = ViewHelper::getView('reports', 'custom_report_filter', 'phtml', array('report_data' => $this->report_data, 'report' => $this->report, 'state' => $state)); $custom_report_footer = ViewHelper::getView('reports', 'custom_report_footer', 'phtml'); $custom_report_header->deal_amounts = $deal_amounts; $custom_report_header->deal_sources = $deal_sources; $custom_report_header->deal_stages = $deal_stages; $custom_report_header->deal_statuses = $deal_statuses; $custom_report_header->deal_close_dates = $deal_close_dates; $custom_report_header->modified_dates = $modified_dates; $custom_report_header->created_dates = DateHelper::getCreatedDates(); $custom_report_header->team_names = DropdownHelper::getTeamNames(); $custom_report_header->user_names = DropdownHelper::getUserNames(); $custom_report_header->state = $state; //assign refs to view $this->custom_report_header = $custom_report_header; $this->custom_report_list = $custom_report_list; $this->custom_report_footer = $custom_report_footer; $this->state = $state; }