public function indexAction() { $contract = Contractruntime::findFirst(array("conditions" => "deleted=0 AND hidden=0 AND usergroup = ?1 AND active =1 AND (enddate > ?2 OR enddate = 0)", "bind" => array(1 => $this->session->get('auth')['usergroup'], 2 => time()))); if ($contract) { $projects = Projects::find(array('conditions' => 'deleted=0 AND hidden =0 AND usergroup =?1 AND crdate > ?2', 'bind' => array(1 => $this->session->get('auth')['usergroup'], 2 => $contract->startdate), 'columns' => "count(uid) AS count,projecttype", 'group' => 'projecttype')); $projectCount = array(); foreach ($projects as $project) { $projectCount[$project->projecttype] = $project->count; } $budget = $contract->getBudget(); $specs = $budget->getBudgetcount(); $specscount = array(); foreach ($specs as $spec) { $title = $spec->getProjecttype()->title; $specscount[$spec->uid_foreign] = array('amount' => $spec->amount, 'title' => $title); } $this->view->setVar('projectcount', $projectCount); $this->view->setVar('contract', $contract); $this->view->setVar('specscount', $specscount); } else { $this->view->setVar('projectcount', $projectCount = array()); $this->view->setVar('contract', $contract = array()); $this->view->setVar('specscount', $specscount = array()); } }
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 = Clippings::findFirstByUid($clippingUid); $clipping->assign(array('pid' => $this->request->getPost('project'), 'cruser_id' => $this->session->get('auth')['uid'], 'usergroup' => $this->request->getPost('usergroup'), 'tstamp' => $this->littlehelpers->processDateOnly($this->request->getPost('tstamp')), 'crdate' => $time, 'title' => $this->request->getPost('title'), 'description' => $this->request->getPost('description'), 'clippingtype' => $this->request->getPost('clippingtype'), 'mediumuid' => $this->request->getPost('medium'), 'url' => $this->request->getPost('url'), 'filelink' => $filename)); if (!$clipping->update()) { $this->flashSession->error($clipping->getMessages()); } else { $this->response->redirect('backend/' . $this->view->language . '/clippings/'); $this->flashSession->success($this->translate('successUpdate')); $this->view->disable(); } } else { $clippingUid = $this->dispatcher->getParam("uid") ? $this->dispatcher->getParam("uid") : 0; $clipping = Clippings::findFirstByUid($clippingUid); $usergroup = Usergroups::findFirstByUid($clipping->usergroup); $projects = Projects::find(array('conditions' => 'deleted=0 AND usergroup =?1', 'bind' => array(1 => $usergroup->uid))); $medium = Medium::find(array('conditions' => 'deleted=0 AND hidden=0')); $this->view->setVar('medium', $medium); $this->view->setVar('usergroup', $usergroup); $this->view->setVar('projects', $projects); $this->view->setVar('clipping', $clipping); } }
public function updateAction() { if ($this->request->isPost()) { $coordinationsUid = $this->request->hasPost('uid') ? $this->request->getPost('uid') : 0; $coordination = Coordinations::findFirstByUid($coordinationsUid); if ($coordination) { $coordination->assign(array('tstamp' => time(), 'title' => $this->request->hasPost('title') ? $this->request->getPost('title') : '', 'description' => $this->request->hasPost('description') ? $this->request->getPost('description') : '', 'icon' => $this->request->hasPost('icon') ? $this->request->getPost('icon') : '')); if (!$coordination->update()) { $this->flashSession->error($medium->getMessages()); } else { $this->flashSession->success($this->translate('successUpdate')); } } } else { $coordinationsUid = $this->dispatcher->getParam("uid") ? $this->dispatcher->getParam("uid") : 0; $coordination = Coordinations::findFirstByUid($coordinationsUid); $projectsArray = array(); foreach ($coordination->getProjects() as $project) { $projectsArray[] = $project->uid; } $projects = Projects::find(array('conditions' => 'deleted=0 AND hidden =0 AND usergroup =?1', 'bind' => array(1 => $coordination->usergroup))); $usergroup = Usergroups::findFirstByUid($coordination->usergroup); $this->view->setVar('coordination', $coordination); $this->view->setVar('usergroup', $usergroup); $this->view->setVar('projects', $projects); $this->view->setVar('projectsarray', $projectsArray); } }
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); $documentUid = $this->dispatcher->getParam("uid") ? $this->dispatcher->getParam("uid") : 0; $document = Documents::findFirstByUid($documentUid); $oldfile = $document->filelink; $document->assign(array('pid' => $this->request->getPost('pid'), 'cruser_id' => $this->session->get('auth')['uid'], 'usergroup' => $this->request->getPost('usergroup'), 'tstamp' => $this->littlehelpers->processDateOnly($this->request->getPost('tstamp')), 'crdate' => $time, 'title' => $this->request->getPost('title'), 'description' => $this->request->getPost('description'), 'filelink' => $filename)); $this->createOldVersion($document->uid, $oldfile, $time); if (!$document->update()) { $this->flashSession->error($document->getMessages()); } else { //$this->response->redirect('backend/'.$this->view->language.'/documents/update/'.$document->uid.'/'); $this->flashSession->success($this->translate('successUpdate')); $this->view->disable(); } } else { $documentUid = $this->dispatcher->getParam("uid") ? $this->dispatcher->getParam("uid") : 0; $document = Documents::findFirstByUid($documentUid); $usergroup = Usergroups::findFirstByUid($document->usergroup); $projects = Projects::find(array('conditions' => 'deleted=0 AND hidden =0 AND usergroup =?1', 'bind' => array(1 => $usergroup->uid))); $this->view->setVar('usergroup', $usergroup); $this->view->setVar('projects', $projects); $this->view->setVar('document', $document); } }
public function deleteAction() { if ($this->request->isPost()) { $element = Projects::findFirstByUid($this->request->getPost('uid')); $element->deleted = 1; $element->save(); } }
/** * @return \Phalcon\Http\ResponseInterface */ public function overviewAction() { /*$runningJobs=$this->getRunningJobs(); $this->view->setVar('runningJobs',$runningJobs);*/ $contract = \reportingtool\Models\Contractruntime::findFirst(array("conditions" => "deleted=0 AND hidden=0 AND usergroup = ?1 AND active =1 AND (enddate > ?2 OR enddate = 0)", "bind" => array(1 => $this->session->get('auth')['usergroup'], 2 => time()))); if ($contract) { $projects = \reportingtool\Models\Projects::find(array('conditions' => 'deleted=0 AND hidden =0 AND usergroup =?1 AND crdate > ?2', 'bind' => array(1 => $this->session->get('auth')['usergroup'], 2 => $contract->startdate))); $projectCount = array(); $projectPrepCount = array(); $projectArr = array(); foreach ($projects as $project) { if (!empty($project->getProjectstate())) { if ($project->getProjectstate()->statetype >= 2) { if (isset($projectCount[$project->projecttype])) { $projectCount[$project->projecttype] = $projectCount[$project->projecttype] + 1; } else { $projectCount[$project->projecttype] = 1; } } else { if (isset($projectPrepCount[$project->projecttype])) { $projectPrepCount[$project->projecttype] = $projectPrepCount[$project->projecttype] + 1; } else { $projectPrepCount[$project->projecttype] = 1; } } } $projectArr[$project->projecttype][] = $project; } $budget = $contract->getBudget(); $specs = $budget->getBudgetcount(); $specscount = array(); foreach ($specs as $spec) { $projecttype = $spec->getProjecttype(); if ($projecttype->deleted == 0 && $projecttype->hidden == 0) { $title = $projecttype->title; $specscount[$spec->uid_foreign] = array('amount' => $spec->amount, 'title' => $title); } } $lastProject = \reportingtool\Models\Projects::findFirst(array('conditions' => 'deleted=0 AND hidden =0 AND usergroup =?1 AND crdate > ?2', 'bind' => array(1 => $this->session->get('auth')['usergroup'], 2 => $contract->startdate), 'order' => 'tstamp DESC')); $lastClipping = \reportingtool\Models\Clippings::findFirst(array('conditions' => 'deleted=0 AND hidden =0 AND usergroup =?1 AND crdate > ?2', 'bind' => array(1 => $this->session->get('auth')['usergroup'], 2 => $contract->startdate), 'order' => 'tstamp DESC')); $this->view->setVar('projects', $projectArr); $this->view->setVar('projectprepcount', $projectPrepCount); $this->view->setVar('projectcount', $projectCount); $this->view->setVar('contract', $contract); $this->view->setVar('specscount', $specscount); $this->view->setVar('lastupdate', $lastClipping->crdate > $lastProject->crdate ? date('d.m.Y', $lastClipping->crdate) : date('d.m.Y', $lastProject->crdate)); } else { $this->view->setVar('projectprepcount', $projectPrepCount = array()); $this->view->setVar('projectcount', $projectCount = array()); $this->view->setVar('contract', $contract = array()); $this->view->setVar('specscount', $specscount = array()); } }
public function updateAction() { $mediumtypeUid = $this->dispatcher->getParam('uid'); $mediumtype = Mediumtypes::findFirstByUid($mediumtypeUid); $projects = Projects::find(array('conditions' => 'deleted=0 AND hidden=0 AND usergroup = ?1', 'bind' => array(1 => $this->session->get('auth')['usergroup']))); $clippings = new Clippings(); $clippingstotal = $clippings->countMediumtypeClippings($mediumtypeUid); $this->view->setVar('clippingstotal', $clippingstotal); $this->view->setVar('projects', $projects); $this->view->setVar('mediumtype', $mediumtype); }
public function updateAction() { if ($this->request->isPost()) { $result = $this->getClippingData(); $output = json_encode($result, true); die($output); } else { $projectUid = $this->dispatcher->getParam("uid") ? $this->dispatcher->getParam("uid") : 0; $project = Projects::findFirstByUid($projectUid); $projecttypes = Projecttypes::find(array('conditions' => 'deleted=0 AND hidden=0')); $ptypesArr = array(); foreach ($projecttypes as $projecttype) { $ptypesArr[$projecttype->uid] = $projecttype->title; } $documents = $project->getDocuments(array('contidions' => 'deleted = 0 AND hidden = 0', 'order' => 'crdate DESC')); $this->view->setVar('document', count($documents) > 0 ? $documents[0]->filelink : ''); $this->view->setVar('project', $project); $this->view->setVar('ptypesarr', $ptypesArr); $this->view->setVar('projectstates', array('in Vorbereitung', 'in Abstimmung', 'live', 'abgeschlossen')); $this->view->setVar('projectstate', $project->getProjectstates(array('conditions' => 'deleted=0 AND hidden=0 AND active=1'))[0]); } }