public function tldSummary() { $NS = new Zend_Session_Namespace('Default'); $registry = Shineisp_Registry::getInstance(); $translation = $registry->Zend_Translate; if (!empty($NS->customer)) { $data = $NS->customer; $summary = Domains::getSummary($data['customer_id']); if (isset($summary[0])) { foreach ($summary as $item) { $totals[] = $item['total']; $tlds[] = $item['tld']; } $totals = implode(",", $totals); $tlds = implode("|", $tlds); $this->view->uri = "http://chart.apis.google.com/chart?cht=bvs&chtt=" . $translation->translate('Domains Summary') . "&chts=4d89f9,18&chs=380x300&chd=t:" . $totals . "&chxt=x&chxl=0:|" . strtoupper($tlds) . "&chco=4d89f9,c6d9fd&chds=0," . ($summary[0]['total'] + 100) . "&chm=N,000000,0,-1,13&chbh=a"; } } return $this->view->render('partials/graph.phtml'); }
public static function prepareGraphData() { $data = array(); $translator = Shineisp_Registry::getInstance()->Zend_Translate; // Get the domain tlds summary data $summary = Domains::getSummary(); if (isset($summary[0])) { foreach ($summary as $item) { $data[] = array('label' => $item['tld'], 'value' => $item['total']); } } return $data; }
/** * showAction * Create the reports page */ public function showAction() { $request = $this->getRequest(); $datatype = $request->getParam('type'); $param = $request->getParam('q'); $autorenew = 1; $links = ""; switch ($datatype) { case 'profitofyear': if (is_numeric($param)) { $links = $this->translator->_("Click one of these links to show the economic reports"); $years = Invoices::getYears(); foreach ($years as $year) { $links .= " <a href='/admin/reports/show/type/profitofyear/q/{$year}'>{$year}</a>"; } $this->view->title = $this->translator->_("Estimated Revenue for %s", $param); if (!empty($years)) { $this->view->description = $this->translator->_("Below is the economic summary of the %s.", $param) . " " . $links; } else { $this->view->description = $this->translator->_("Below is the economic summary of the %s.", $param); } $this->view->year = $param; $graph = new Shineisp_Commons_Morris(); // Get the total of the revenues per year $graphdata = $graph->setType('Area')->setData(Orders::prepareGraphData(array($param), 'month', false))->setElement('graph')->setXkey('xdata')->setLabels(array($this->translator->translate('Net Revenue (Taxable Income less Costs)')))->setOptions(array('lineColors' => array('#428BCA'), 'preUnits' => Settings::findbyParam('currency') . " "))->plot(); $this->view->placeholder("admin_endbody")->append($graphdata); Invoices::getSummaryGrid($this->_helper, $param); PurchaseInvoices::getSummaryGrid($this->_helper, $param); } else { $this->_helper->redirector('show', 'reports', 'admin', array('type' => 'profitofyear', 'q' => date('Y'))); } break; case 'productsummary': $years = Invoices::getYears(); foreach ($years as $year) { $links .= " <a href='/admin/reports/show/type/productsummary/q/{$year}'>{$year}</a>"; } if (!empty($years)) { $this->view->description = $this->translator->_("In this list you can see the summary of the products sold. %s", $param) . " <br/> " . $links . " <a href='/admin/reports/show/type/productsummary/'>" . $this->translator->translate('Show All') . "</a> "; } else { $this->view->description = $this->translator->_("In this list you can see the summary of the products sold. %s", $param); } $this->view->title = $this->translator->translate("Products summary"); $this->view->data = array('records' => Products::getBestseller($param)); break; case 'tldsummarypermonth': $this->view->title = $this->translator->translate("Domain TLD monthly summary"); $this->view->description = $this->translator->translate("In this list you can see the summary of the TLD per month."); $graph = new Shineisp_Commons_Morris(); $data = Domains::prepareGraphDataperMonth(); if (!empty($data)) { // Get the total of the revenues per year $graphdata = $graph->setType('Bar')->setData($data)->setElement('graph')->setXkey('xdata')->setLabels(array_keys($data['tld']))->plot(); $this->view->placeholder("admin_endbody")->append($graphdata); } $this->view->data = array('records' => Domains::getSummaryPerMonth()); break; case 'domainstats': $this->view->title = $this->translator->translate("Domain stats"); $this->view->description = $this->translator->translate("This list shows all the costs and earnings of the domains sold grouped by tld."); $graph = new Shineisp_Commons_Morris(); // Get the tlds domains per type $graphdata = $graph->setType('Donut')->setData(Domains::prepareGraphData())->setElement('graph')->plot(); $this->view->placeholder("admin_endbody")->append($graphdata); $this->view->data = array('records' => Domains::getSummary()); break; case 'tldsummaryowner': $this->view->title = $this->translator->translate("Summary per client"); $this->view->description = $this->translator->translate("By this list you can see the summary of the domains bought per client."); $this->view->data = array('records' => Domains::domains_per_customers(), 'pager' => true); break; case 'domainstasks': $this->view->title = $this->translator->translate("List of all domain tasks (last 100 records)"); $this->view->description = $this->translator->translate("By this list you can know all the tasks for each created domain."); $this->view->graph = ""; $this->view->data = array('records' => DomainsTasks::GetTask(100), 'delete' => array('controller' => 'reports', 'action' => 'deletetask'), 'pager' => true); break; case 'servicesummary': // get all the recurring products and services as default $groups = ProductsAttributesGroups::getList(null, true); if (!empty($groups)) { $groups = array_keys($groups); } $groups = array('3', '9'); $fields = "detail_id,\n\t\t\t\t\t\t\to.order_id as orderid,\n\t\t\t\t\t\t\tc.customer_id as customer_id, \n\t\t\t\t\t\t\toid.relationship_id as relationship_id,\n\t\t\t\t\t\t\tDATE_FORMAT(oi.date_end, '%d/%m/%Y') as expiringdate,\n\t\t\t\t\t\t\td.autorenew as autorenew,\n\t\t\t\t\t\t\tCONCAT(c.firstname, ' ', c.lastname, ' ', c.company) as customer,\n\t\t\t\t\t\t\toi.description as description,\n\t\t\t\t\t\t\tCONCAT(d.domain, '.', d.tld) as domain, \n\t\t\t\t\t\t\toi.cost as cost, \n\t\t\t\t\t\t\toi.price as price"; $this->view->title = $this->translator->translate("List of the recurring services"); $this->view->description = $this->translator->translate("By this list you can see the summary of the services bought per client."); $this->view->graph = ""; $this->view->data = array('records' => OrdersItems::getAllRecurringServices($fields, $groups), 'pager' => true); break; case 'ticketsummary': $this->view->title = $this->translator->translate("Ticket summary"); $this->view->description = $this->translator->translate("List of the last help requests."); $this->view->graph = ""; $this->view->data = array('records' => Tickets::Last(), 'actions' => array('/admin/tickets/edit/id/' => 'show'), 'pager' => true); break; case 'domainsexpiration': $this->view->title = $this->translator->translate("Expiration list of domains"); $this->view->description = $this->translator->translate("This view helps you to check which are the domains next to expiration."); $this->view->graph = ""; $this->view->data = array('records' => Domains::getExpiringDomains(), 'actions' => array('/admin/domains/edit/id/' => 'show'), 'pager' => true); break; case 'servicesexpiration': $this->view->title = $this->translator->translate("Expiration list of services"); $this->view->description = $this->translator->translate("This view helps you to check which are the services next to expiration."); $this->view->graph = ""; $this->view->data = array('records' => Products::getExpiringProducts(), 'actions' => array('/admin/services/edit/id/' => 'show'), 'pager' => true); break; default: $this->_helper->redirector('show', 'reports', 'admin', array('type' => 'profitofyear', 'q' => date('Y'))); break; } }