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]);
}
}
