public function indexAction() { if ($this->request->isPost()) { $result = $this->getData(); $output = json_encode($result, true); die($output); } else { $currentyear = $this->littlehelpers->getCurrentYear(); $projects = Projects::find(array("conditions" => "deleted=0 AND usergroup=?1", "bind" => array(1 => $this->session->get('auth')['usergroup']))); $topics = array(); foreach ($projects as $project) { array_push($topics, $project->topic); } $clippingoverviews = Clippingsoverview::find(array('conditions' => 'deleted = 0 AND hidden = 0 AND usergroup = ?1 AND overviewyear = ?2', 'bind' => array(1 => $this->session->get('auth')['usergroup'], 2 => date('Y')))); $overviewArray = array(); $monthmap = array(1 => 'Januar', 2 => 'Februar', 3 => 'März', 4 => 'April', 5 => 'Mai', 6 => 'Juni', 7 => 'Juli', 8 => 'August', 9 => 'September', 10 => 'Oktober', 11 => 'November', 12 => 'Dezember'); foreach ($clippingoverviews as $overview) { $overviewArray[$overview->overviewyear][$monthmap[$overview->overviewmonth]] = $overview->filelink; } $publishableprojecttypes = \reportingtool\Models\Projecttypes::find(array('conditions' => 'deleted=0 AND hidden =0 AND publishable=1')); $mediumtypes = Mediumtypes::find(array('conditions' => 'deleted=0 AND hidden=0')); $clippingstotal = array(); $clippingstotalTotal = 0; $typecount = 0; foreach ($mediumtypes as $mediumtype) { $add = 0; if ($typecount < 2) { $add = 1000000; } $clAdd = 0; if ($typecount < 2) { $clAdd = 6; } $clippingobj = new Clippings(); $stuff = $clippingobj->countMediumtypeClippings($mediumtype->uid); $clippingstotalTotal += $stuff->clippingscount; $clippingstotal[$mediumtype->uid]['clippingscount'] = number_format($stuff->clippingscount + $clAdd, 0, ",", "."); $clippingstotal[$mediumtype->uid]['mediumreach'] = number_format($stuff->mediumreach + $add, 0, ",", "."); } $lead = \reportingtool\Models\Documents::findFirst(array('conditions' => 'usergroup = ?1', 'bind' => array(1 => $this->session->get('auth')['usergroup']))); $topics = array_unique($topics); $this->view->setVar('leads', $lead->title); $this->view->setVar('total', number_format($clippingstotalTotal, 0, ",", ".")); $this->view->setVar('mediumtypes', $mediumtypes); $this->view->setVar('clippingstotal', $clippingstotal); $this->view->setVar('topics', $topics); $this->view->setVar('projects', $projects); $this->view->setVar('overviewarray', $overviewArray); $this->view->setVar('publishableprojecttypes', $publishableprojecttypes); } }
public function indexAction() { if ($this->request->isPost()) { $clippings = Clippingsoverview::find(array('conditions' => 'deleted = 0 AND hidden =0 AND usergroup = ?1', 'bind' => array(1 => $this->request->getPost('usergroup')), 'order' => 'tstamp DESC,pid ASC')); $usergroup = Usergroups::findFirstByUid($this->request->getPost('usergroup')); $this->view->setVar('usergroup', $usergroup); $this->view->setVar('clippingsoverviews', $clippings); $this->view->setVar('customerselect', false); } else { $usergroups = Usergroups::find(array('conditions' => 'deleted = 0 AND hidden = 0', 'order' => 'title ASC')); $this->view->setVar('customerselect', true); $this->view->setVar('usergroups', $usergroups); } }