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 updateAction()
{
if ($this->request->isPost()) {
$time = time();
$usergroup = Usergroups::findFirstByUid($this->request->getPost('usergroup'));
$filename = $this->littlehelpers->saveFile($this->request->getUploadedFiles(), $time, $usergroup);
$clippingUid = $this->dispatcher->getParam("uid") ? $this->dispatcher->getParam("uid") : 0;
$clipping = Clippingsoverview::findFirstByUid($clippingUid);
$clipping->assign(array('cruser_id' => $this->session->get('auth')['uid'], 'usergroup' => $this->request->getPost('usergroup'), 'tstamp' => $this->littlehelpers->processDate($this->request->getPost('tstamp')), 'crdate' => $time, 'overviewyear' => $this->request->getPost('overviewyear'), 'overviewmonth' => $this->request->getPost('overviewmonth'), 'filelink' => $filename));
if (!$clipping->update()) {
$this->flashSession->error($clipping->getMessages());
} else {
$this->response->redirect('backend/' . $this->view->language . '/clippingsoverview/update/' . $clipping->uid . '/');
$this->flashSession->success($this->translate('successUpdate'));
$this->view->disable();
}
} else {
$clippingUid = $this->dispatcher->getParam("uid") ? $this->dispatcher->getParam("uid") : 0;
$clipping = Clippingsoverview::findFirstByUid($clippingUid);
$usergroup = Usergroups::findFirstByUid($clipping->usergroup);
$this->view->setVar('usergroup', $usergroup);
$this->view->setVar('clipping', $clipping);
}
}