Projekt

Obecné

Profil

Stáhnout (42 KB) Statistiky
| Větev: | Tag: | Revize:

freenetis-github/application/controllers/work_reports.php @ 8baed187

8baed187 Michal Kliment
<?php defined('SYSPATH') or die('No direct script access.');
/*
* This file is part of open source system FreenetIS
* and it is released under GPLv3 licence.
*
* More info about licence can be found:
* http://www.gnu.org/licenses/gpl-3.0.html
*
* More info about project can be found:
* http://www.freenetis.org/
*
*/

/**
* Controllers manages user's work reports and it's (dis)approval directed by
* approval types and templates.
*
* Work reports contains work in specified date interval.
*
* Each work report has to be approved by other pre-defined users by their votes.
*
* @author Michal Kliment, Ondřej Fibich
* @package Controller
*/
class Work_reports_Controller extends Controller
{
/**
* Redirects to pending
*/
public function index()
{
url::redirect('work_reports/pending');
}

/**
* Shows pending works
*
* @param integer $limit_results
* @param string $order_by
* @param string $order_by_direction
* @param integer $page_word
* @param integer $page
*/
public function pending(
$limit_results = 100, $order_by = 'id', $order_by_direction = 'ASC',
$page_word = null, $page = 1)
{
// acccess control
if (!$this->acl_check_view('Users_Controller', 'work'))
{
Controller::error(ACCESS);
}

// gets new selector
if (is_numeric($this->input->get('record_per_page')))
{
$limit_results = (int) $this->input->get('record_per_page');
}
$filter_form = new Filter_form('wr');
$filter_form->add('description');
$filter_form->add('uname')
->label('Worker')
->callback('json/user_fullname');
$filter_form->add('suggest_amount')
->type('number')
->label('Suggest amount');
$filter_form->add('hours')
->type('number');
$filter_form->add('km')
->type('number');
$filter_form->add('date_from')
->type('date');
$filter_form->add('date_to')
->type('date');
$filter_form->add('payment_type')
->type('select')
->values(Job_report_Model::get_payment_types());

$work_report_model = new Job_report_Model();
$total_work_reports = $work_report_model->count_all_pending_work_reports(
$filter_form->as_sql()
);

if (($sql_offset = ($page - 1) * $limit_results) > $total_work_reports)
$sql_offset = 0;

$work_reports = $work_report_model->get_all_pending_work_reports(
$sql_offset, (int)$limit_results, $order_by, $order_by_direction,
$filter_form->as_sql()
);

// create grid
$grid = new Grid('work_reports/pending', __('List of all pending work reports'), array
(
'use_paginator' => true,
'use_selector' => true,
'current' => $limit_results,
'selector_increace' => 100,
'selector_min' => 100,
'selector_max_multiplier' => 20,
'base_url' => Config::get('lang').'/work_reports/pending/'
. $limit_results.'/'.$order_by.'/'.$order_by_direction,
'uri_segment' => 'page',
'total_items' => $total_work_reports,
'items_per_page' => $limit_results,
'style' => 'classic',
'filter' => $filter_form,
'order_by' => $order_by,
'order_by_direction' => $order_by_direction,
'limit_results' => $limit_results
));

if ($this->acl_check_new('Users_Controller', 'work'))
{
$grid->add_new_button('work_reports/add', __('Add new work report'));
}

$grid->order_field('id')
->label('ID');
$grid->order_link_field('user_id')
->link('users/show', 'uname')
->label('Worker');
$grid->order_callback_field('description')
->callback('callback::limited_text');
$grid->order_callback_field('type')
->callback('callback::work_report_type');
$grid->order_callback_field('hours')
->callback('callback::round');
$grid->order_callback_field('km')
->callback('callback::round');
$grid->order_callback_field('suggest_amount')
->callback('callback::money');
$grid->order_callback_field('your_votes')
->callback('callback::votes_of_voter');
$actions = $grid->grouped_action_field();
if ($this->acl_check_view('Users_Controller', 'work'))
{
$actions->add_action()
->icon_action('show')
->url('work_reports/show');
}
if ($this->acl_check_edit('Users_Controller', 'work'))
{
$actions->add_action()
->icon_action('edit')
->url('work_reports/edit');
}

$grid->datasource($work_reports);
$breadcrumbs = breadcrumbs::add()
->text('Work reports')
->text('Pending work reports');

$view = new View('main');
$view->title = __('Pending work reports');
$view->breadcrumbs = $breadcrumbs->html();
$view->content = new View('work_reports/show_all');
$view->content->grid = $grid;
$view->render(TRUE);
}

/**
* Shows approved works
*
* @param integer $limit_results
* @param string $order_by
* @param string $order_by_direction
* @param integer $page_word
* @param integer $page
*/
public function approved(
$limit_results = 100, $order_by = 'id', $order_by_direction = 'ASC',
$page_word = null, $page = 1)
{
// acccess control
if (!$this->acl_check_view('Users_Controller', 'work'))
Controller::error(ACCESS);

// gets new selector
if (is_numeric($this->input->get('record_per_page')))
$limit_results = (int) $this->input->get('record_per_page');
$filter_form = new Filter_form('wr');
$filter_form->add('description');
$filter_form->add('uname')
->label('Worker')
->callback('json/user_fullname');
$filter_form->add('suggest_amount')
->type('number')
->label('Suggest amount');
$filter_form->add('hours')
->type('number');
$filter_form->add('km')
->type('number');
$filter_form->add('date_from')
->type('date');
$filter_form->add('date_to')
->type('date');
$filter_form->add('payment_type')
->type('select')
->values(Job_report_Model::get_payment_types());

$work_report_model = new Job_report_Model();
$total_work_reports = $work_report_model->count_all_approved_work_reports(
$filter_form->as_sql()
);

if (($sql_offset = ($page - 1) * $limit_results) > $total_work_reports)
$sql_offset = 0;

$work_reports = $work_report_model->get_all_approved_work_reports(
$sql_offset, (int)$limit_results, $order_by, $order_by_direction,
$filter_form->as_sql()
);

// create grid
$grid = new Grid(
'work_reports/approved',
__('List of all approved work reports'), array
(
'use_paginator' => true,
'use_selector' => true,
'current' => $limit_results,
'selector_increace' => 100,
'selector_min' => 100,
'selector_max_multiplier' => 20,
'base_url' => Config::get('lang').'/work_reports/approved/'
. $limit_results.'/'.$order_by.'/'.$order_by_direction ,
'uri_segment' => 'page',
'total_items' => $total_work_reports,
'items_per_page' => $limit_results,
'style' => 'classic',
'filter' => $filter_form,
'order_by' => $order_by,
'order_by_direction' => $order_by_direction,
'limit_results' => $limit_results
));

$grid->order_field('id')
->label(__('Id'));
$grid->order_link_field('user_id')
->link('users/show', 'uname')
->label('Worker');
$grid->order_field('description');
$grid->order_callback_field('type')
->callback('callback::work_report_type');
$grid->order_callback_field('hours')
->callback('callback::round');
$grid->order_callback_field('km')
->callback('callback::round');
$grid->order_callback_field('suggest_amount')
->callback('callback::money');
$grid->order_callback_field('rating')
->callback('callback::work_report_rating');

// access control
if ($this->acl_check_view('Users_Controller','work'))
{
$grid->grouped_action_field()
->add_action()
->icon_action('show')
->url('work_reports/show');
}

$grid->datasource($work_reports);
$breadcrumbs = breadcrumbs::add()
->text('Work reports')
->text('Approved work reports');

$view = new View('main');
$view->title = __('Approved work reports');
$view->breadcrumbs = $breadcrumbs->html();
$view->content = new View('work_reports/show_all');
$view->content->grid = $grid;
$view->render(TRUE);
}

/**
* Shows rejected works
*
* @param integer $limit_results
* @param string $order_by
* @param string $order_by_direction
* @param integer $page_word
* @param integer $page
*/
public function rejected(
$limit_results = 100, $order_by = 'id', $order_by_direction = 'ASC',
$page_word = null, $page = 1)
{
// acccess control
if (!$this->acl_check_view('Users_Controller', 'work'))
Controller::error(ACCESS);

// gets new selector
if (is_numeric($this->input->get('record_per_page')))
$limit_results = (int) $this->input->get('record_per_page');
$filter_form = new Filter_form('wr');
$filter_form->add('description');
$filter_form->add('uname')
->label('Worker')
->callback('json/user_fullname');
$filter_form->add('suggest_amount')
->type('number')
->label('Suggest amount');
$filter_form->add('hours')
->type('number');
$filter_form->add('km')
->type('number');
$filter_form->add('date_from')
->type('date');
$filter_form->add('date_to')
->type('date');
$filter_form->add('payment_type')
->type('select')
->values(Job_report_Model::get_payment_types());

$work_report_model = new Job_report_Model();
$total_work_reports = $work_report_model->count_all_rejected_work_reports(
$filter_form->as_sql()
);

if (($sql_offset = ($page - 1) * $limit_results) > $total_work_reports)
$sql_offset = 0;

$work_reports = $work_report_model->get_all_rejected_work_reports(
$sql_offset, (int)$limit_results, $order_by, $order_by_direction,
$filter_form->as_sql()
);

// create grid
$grid = new Grid(
'work_reports/rejected',
__('List of all rejected work reports'), array
(
'use_paginator' => true,
'use_selector' => true,
'current' => $limit_results,
'selector_increace' => 100,
'selector_min' => 100,
'selector_max_multiplier' => 20,
'base_url' => Config::get('lang').'/work_reports/rejected/'
. $limit_results.'/'.$order_by.'/'.$order_by_direction ,
'uri_segment' => 'page',
'total_items' => $total_work_reports,
'items_per_page' => $limit_results,
'style' => 'classic',
'filter' => $filter_form,
'order_by' => $order_by,
'order_by_direction' => $order_by_direction,
'limit_results' => $limit_results
));

$grid->order_field('id');
$grid->order_link_field('user_id')
->link('users/show', 'uname')
->label('Worker');
$grid->order_field('description');
$grid->order_callback_field('type')
->callback('callback::work_report_type');
$grid->order_callback_field('hours')
->callback('callback::round');
$grid->order_callback_field('km')
->callback('callback::round');
$grid->order_callback_field('suggest_amount')
->callback('callback::money');

$actions = $grid->grouped_action_field();
if ($this->acl_check_view('Users_Controller', 'work'))
{
$actions->add_action()
->icon_action('show')
->url('work_reports/show');
}

$grid->datasource($work_reports);

$breadcrumbs = breadcrumbs::add()
->text('Work reports')
->text('Rejected work reports');
$view = new View('main');
$view->title = __('Rejected work reports');
$view->breadcrumbs = $breadcrumbs->html();
$view->content = new View('work_reports/show_all');
$view->content->grid = $grid;
$view->render(TRUE);
}
/**
* Shows works reports by user
*
* @author Ondřej Fibich
* @param integer $user_id
*/
public function show_by_user($user_id = NULL)
{
if (empty($user_id) || !is_numeric($user_id))
{
Controller::warning(PARAMETER);
}
$user = new User_Model($user_id);
$work_report = new Job_report_Model();
if (!$user || !$user->id)
{
Controller::error(RECORD);
}
if (!$this->acl_check_view('Users_Controller', 'work', $user->member_id))
{
Controller::error(ACCESS);
}
// stats init
$pending_stats = $approved_stats = $rejected_stats = $concept_stats = array
(
'hours' => 0.0,
'kms' => 0,
'suggest_amount' => 0.0,
);
/* Concepts */
$concepts = $work_report->get_concepts_work_reports_of_user($user->id);
foreach ($concepts as $concept)
{
$concept_stats['hours'] += $concept->hours;
$concept_stats['kms'] += $concept->km;
$concept_stats['suggest_amount'] += $concept->suggest_amount;
}
$concept_stats['hours'] = round($concept_stats['hours'], 2);
$concept_stats['kms'] = round($concept_stats['kms'], 2);
$grid_concepts = new Grid('work_reports/show_by_user' . $user->id, '', array
(
'use_paginator' => false,
'use_selector' => false,
'total_items' => count($concepts)
));

if ($this->acl_check_new('Users_Controller', 'work', $user->member_id))
{
$grid_concepts->add_new_button(
'work_reports/add/' . $user->id,
__('Add new work report')
);
}

$grid_concepts->field('id')
->label('ID');
$grid_concepts->link_field('user_id')
->link('users/show', 'uname')
->label('Worker');
$grid_concepts->callback_field('description')
->callback('callback::limited_text');
$grid_concepts->callback_field('type')
->callback('callback::work_report_type');
$grid_concepts->callback_field('hours')
->callback('callback::round');
$grid_concepts->callback_field('km')
->callback('callback::round');
$grid_concepts->callback_field('suggest_amount')
->callback('callback::money');
$actions = $grid_concepts->grouped_action_field();
if ($this->acl_check_view('Users_Controller', 'work', $user->member_id))
{
$actions->add_action()
->icon_action('show')
->url('work_reports/show');
}
if ($this->acl_check_edit('Users_Controller', 'work', $user->member_id))
{
$actions->add_action()
->icon_action('edit')
->url('work_reports/edit');
}
if ($this->acl_check_delete('Users_Controller', 'work', $user->member_id))
{
$actions->add_action()
->icon_action('delete')
->url('work_reports/delete')
->class('delete_link');
}

$grid_concepts->datasource($concepts);

/* Pending */
$pendings = $work_report->get_pending_work_reports_of_user($user->id);
foreach ($pendings as $pend)
{
$pending_stats['hours'] += $pend->hours;
$pending_stats['kms'] += $pend->km;
$pending_stats['suggest_amount'] += $pend->suggest_amount;
}
$pending_stats['hours'] = round($pending_stats['hours'], 2);
$pending_stats['kms'] = round($pending_stats['kms'], 2);
$grid_pending = new Grid('work_reports/show_by_user' . $user->id, '', array
(
'use_paginator' => false,
'use_selector' => false,
'total_items' => count($pendings)
));

$grid_pending->field('id')
->label('ID');
$grid_pending->link_field('user_id')
->link('users/show', 'uname')
->label('Worker');
$grid_pending->callback_field('description')
->callback('callback::limited_text');
$grid_pending->callback_field('type')
->callback('callback::work_report_type');
$grid_pending->callback_field('hours')
->callback('callback::round');
$grid_pending->callback_field('km')
->callback('callback::round');
$grid_pending->callback_field('suggest_amount')
->callback('callback::money');
$actions = $grid_pending->grouped_action_field();
if ($this->acl_check_view('Users_Controller', 'work', $user->member_id))
{
$actions->add_action()
->icon_action('show')
->url('work_reports/show');
}

$grid_pending->datasource($pendings);
/* Approved */
$approved = $work_report->get_approved_work_reports_of_user($user->id);
foreach ($approved as $approve)
{
$approved_stats['hours'] += $approve->hours;
$approved_stats['kms'] += $approve->km;
$approved_stats['suggest_amount'] += $approve->rating;
}
$approved_stats['hours'] = round($approved_stats['hours']);
$approved_stats['kms'] = round($approved_stats['kms']);
$grid_approved = new Grid('work_reports/show_by_user' . $user->id, '', array
(
'use_paginator' => false,
'use_selector' => false,
'total_items' => count($approved)
));

$grid_approved->field('id')
->label('ID');
$grid_approved->link_field('user_id')
->link('users/show', 'uname')
->label('Worker');
$grid_approved->callback_field('description')
->callback('callback::limited_text');
$grid_approved->callback_field('type')
->callback('callback::work_report_type');
$grid_approved->callback_field('hours')
->callback('callback::round');
$grid_approved->callback_field('km')
->callback('callback::round');
$grid_approved->callback_field('suggest_amount')
->callback('callback::money');
$grid_approved->callback_field('rating')
->callback('callback::work_report_rating');
$actions = $grid_approved->grouped_action_field();
if ($this->acl_check_view('Users_Controller', 'work', $user->member_id))
{
$actions->add_action()
->icon_action('show')
->url('work_reports/show');
}

$grid_approved->datasource($approved);
/* Rejected */
$rejected = $work_report->get_rejected_work_reports_of_user($user->id);
foreach ($rejected as $reject)
{
$pending_stats['hours'] += $reject->hours;
$pending_stats['kms'] += $reject->km;
$pending_stats['suggest_amount'] += $reject->suggest_amount;
}
$pending_stats['hours'] = round($pending_stats['hours'], 2);
$pending_stats['kms'] = round($pending_stats['kms'], 2);
$grid_rejected = new Grid('work_reports/show_by_user' . $user->id, '', array
(
'use_paginator' => false,
'use_selector' => false,
'total_items' => count($rejected)
));

$grid_rejected->field('id')
->label('ID');
$grid_rejected->link_field('user_id')
->link('users/show', 'uname')
->label('Worker');
$grid_rejected->callback_field('description')
->callback('callback::limited_text');
$grid_rejected->callback_field('type')
->callback('callback::work_report_type');
$grid_rejected->callback_field('hours')
->callback('callback::round');
$grid_rejected->callback_field('km')
->callback('callback::round');
$grid_rejected->callback_field('suggest_amount')
->callback('callback::money');
$actions = $grid_rejected->grouped_action_field();
if ($this->acl_check_view('Users_Controller', 'work', $user->member_id))
{
$actions->add_action()
->icon_action('show')
->url('work_reports/show');
}

$grid_rejected->datasource($rejected);
/* view */
// breadcrumbs navigation
$breadcrumbs = breadcrumbs::add()
->link('members/show_all', 'Members',
$this->acl_check_view('Members_Controller', 'members'))
->disable_translation()
->link('members/show/'.$user->member->id,
'ID ' . $user->member->id . ' - ' . $user->member->name,
$this->acl_check_view(
'Members_Controller', 'members',
$user->member->id
)
)->enable_translation()
->link('users/show_by_member/' . $user->member_id,
'Users',
$this->acl_check_view(
'Users_Controller', 'users',
$user->member_id
)
)->disable_translation()
->link('users/show/'.$user->id,
$user->name . ' ' . $user->surname .
' (' . $user->login . ')',
$this->acl_check_view(
'Users_Controller','users',
$user->member_id
)
)->enable_translation()
->text('Work reports');
$headline = __('List of work reports of user');
$view = new View('main');
$view->title = $headline;
$view->breadcrumbs = $breadcrumbs->html();
$view->content = new View('work_reports/show_by_user');
$view->content->headline = $headline;
$view->content->user = $user;
$view->content->show_concepts = ($user->id == $this->user_id);
$view->content->grid_concepts = $grid_concepts;
$view->content->grid_approved = $grid_approved;
$view->content->grid_rejected = $grid_rejected;
$view->content->grid_pending = $grid_pending;
$view->content->stats_concepts = $concept_stats;
$view->content->stats_approved = $approved_stats;
$view->content->stats_rejected = $rejected_stats;
$view->content->stats_pending = $pending_stats;
$view->render(TRUE);
}

/**
* Shows work
*
* @param integer $work_report_id
*/
public function show($work_report_id = NULL)
{
if (!$work_report_id || !is_numeric($work_report_id))
{
Controller::warning(PARAMETER);
}

$work_report_model = new Job_report_Model($work_report_id);
$work_report = $work_report_model->get_work_report();

if (!$work_report_model || !$work_report_model->id)
{
Controller::error(RECORD);
}
$member_id = $work_report_model->user->member_id;
// concept can be viewed only by owner
if (!$this->acl_check_view('Users_Controller', 'work', $member_id) || (
$work_report->concept &&
$this->user_id != $work_report_model->user_id &&
$this->user_id != $work_report_model->added_by_id
))
{
Controller::error(ACCESS);
}

$works = ORM::factory('job')->get_all_works_by_job_report_id($work_report->id);

$approval_template_item_model = new Approval_template_item_Model();

// test if user can vote
$can_vote = FALSE;

if (!$work_report_model->concept && $work_report->state <= 1)
{
foreach ($works as $work)
{
if ($approval_template_item_model->check_user_vote_rights(
$work->id,
Session::instance()->get('user_id'),
$work_report->suggest_amount
))
{
$can_vote = TRUE;
break;
}
}
}

// create grid
$works_grid = new Grid('work_reports/show/' . $work_report->id, '', array
(
'use_paginator' => false,
'use_selector' => false,
'total_items' => count($works),
'id' => 'work_reports__show_grid'
));

if ($can_vote)
{
$works_grid->add_new_button(
'#', __('Set votes to') . ' ' . __('Abstain', '', 1),
array('id' => 'mark_all_abstain')
);

if ($this->user_id != $work_report_model->user_id)
{
$works_grid->add_new_button(
'#', __('Set votes to') . ' ' . __('Disagree', '', 1),
array('id' => 'mark_all_disagree')
);

$works_grid->add_new_button(
'#', __('Set votes to') . ' ' . __('Agree', '', 1),
array('id' => 'mark_all_agree')
);
}
}
if ($work_report->state >= 2)
{
$works_grid->callback_field('approved')
->label('')
->callback('callback::work_approved');
}

$works_grid->field('date');
$works_grid->callback_field('description')
->callback('callback::limited_text');
$works_grid->callback_field('hours')
->callback('callback::round');
$works_grid->callback_field('km')
->callback('callback::round');
$works_grid->callback_field('suggest_amount')
->callback('callback::money');
if (!$work_report_model->concept)
{
$works_grid->callback_field('approval_state')
->label(__('State'))
->help(help::hint('approval_state'))
->callback('callback::vote_state_field');

$works_grid->callback_field('comments_count')
->label(__('Comments'))
->callback('callback::comments_field');
}

if ($can_vote)
{
$works_grid->form_field('vote')
->type('dropdown')
->rules('required')
->options(array
(
NULL => '----------------',
1 => __('Agree'),
-1 => __('Disagree'),
0 => __('Abstain')
))->callback('Works_Controller::vote_form_field');
$works_grid->form_field('comment')
->type('textarea')
->callback('Works_Controller::comment_form_field');
}

// access control
if ($this->acl_check_view('Users_Controller', 'work', $member_id))
{
$works_grid->grouped_action_field()
->add_action()
->icon_action('show')
->url('works/show');
}

$works_grid->datasource($works);

$links = array();
// breadcrumbs and links back
$breadcrumbs = breadcrumbs::add()
->link('work_reports', 'Work reports',
$this->acl_check_view('Users_Controller', 'work'));

switch ($work_report->state)
{
case 0:
case 1:
$state_text = __('Pending');
$breadcrumbs->link('work_reports/pending', 'Pending',
$this->acl_check_view('Users_Controller', 'work'));
break;

case 2:
$state_text = '<span style="color: red;">'.__('Rejected').'</span>';
$breadcrumbs->link(
'work_reports/rejected', 'Rejected',
$this->acl_check_view('Users_Controller', 'work')
);
break;

case 3:
$state_text = '<span style="color: green;">'.__('Approved');
if ($work_report->suggest_amount != $work_report_model->get_rating())
{
$state_text .= ' (' . __('Partially') . ')';
}
$state_text .= '</span>';
$breadcrumbs->link(
'work_reports/approved', 'Approved',
$this->acl_check_view('Users_Controller', 'work')
);
break;
}
$breadcrumbs->disable_translation()
->link('work_reports/show_by_user/' . $work_report_model->user_id,
$work_report_model->user->get_full_name())
->text(text::limit_chars($work_report_model->description, 40));

if ($this->acl_check_edit('Users_Controller', 'work', $work_report->member_id) &&
$work_report->state == 0)
{
$links[] = html::anchor(
url_lang::base().'work_reports/edit/'.$work_report->id,
__('Edit')
);
}

if ($this->acl_check_delete('Users_Controller', 'work', $work_report->member_id) &&
$work_report->state == 0)
{
$links[] = html::anchor(
url_lang::base().'work_reports/delete/'.$work_report->id,
__('Delete'), array('class' => 'delete_link')
);
}

$links = implode(' | ', $links);
// post votes
if (isset($_POST) && count($_POST))
{
$post_votes = $_POST['vote'];
$vote_model = new Vote_Model();
$comments = $_POST['comment'];
$approval_template_model = new Approval_template_Model();
$approval_template_item_model = new Approval_template_item_Model();
$state = 0;

$amount = 0;
$approved_works_ids = array();
$rejected_works_ids = array();
$pending_works_ids = array();
$work_model = new Job_Model();

foreach ($post_votes as $id => $post_vote)
{
$work = $work_model->find($id);

if (!$work || !$work->id)
{
continue;
}

$suggest_amount = $work->suggest_amount;

if ($work->job_report_id)
{
$suggest_amount = $work->job_report->get_suggest_amount();
}

// finding aro group of logged user
$aro_group = $approval_template_item_model->get_aro_group_by_approval_template_id_and_user_id(
$work->approval_template_id,
$this->session->get('user_id'),
$suggest_amount
);

// user can vote
if ($aro_group && $aro_group->id)
{
// finding vote of user
$vote = $vote_model->where('user_id', $this->user_id)
->where('fk_id', $id)
->where('type', Vote_Model::WORK)
->find();

// edit/delete vote
if ($vote->id)
{
if ($post_vote == '')
{
$vote->delete();
}
else
{
$vote->vote = $post_vote;
$vote->comment = $comments[$id];
$vote->time = date('Y-m-d H:i:s');
$vote->save();
}
}
// create vote
else
{
$vote->clear();
$vote->user_id = $this->user_id;
$vote->fk_id = $id;
$vote->aro_group_id = $aro_group->id;
$vote->type = Vote_Model::WORK;
$vote->vote = $post_vote;
$vote->time = date('Y-m-d H:i:s');
$vote->comment = $comments[$id];
$vote->save();
}

// set up state of work
$work->state = $work->get_state(Vote_Model::WORK);
$work->save();

switch ($work->state)
{
case 0:
case 1:
$pending_works_ids[] = $work->id;
break;
case 2:
$rejected_works_ids[] = $work->id;
break;
case 3:
$approved_works_ids[] = $work->id;
$amount += $work->suggest_amount;
break;
}
}
}

if (!count($pending_works_ids) &&
count($approved_works_ids) &&
$work_report_model->payment_type == Job_report_Model::PAYMENT_BY_CREDIT)
{
// creates new transfer
$account_model = new Account_Model();

$operating_id = $account_model->where(
'account_attribute_id', Account_attribute_Model::OPERATING
)->find()->id;

$credit_id = $account_model->where('member_id', $work->user->member_id)
->where('account_attribute_id', Account_attribute_Model::CREDIT)
->find()
->id;

$transfer_id = Transfer_Model::insert_transfer(
$operating_id, $credit_id, null, null,
$this->session->get('user_id'), null, date('Y-m-d'),
date('Y-m-d H:i:s'), __('Work report approval'),
round($amount, 2)
);

$work_report_model->transfer_id = $transfer_id;
$work_report_model->save();

foreach ($approved_works_ids as $approved_work_id)
{
$approved_work = new Job_Model($approved_work_id);
$approved_work->transfer_id = $transfer_id;
$approved_work->save();
}
}
url::redirect(url::base(TRUE).url::current(TRUE));
}

$view = new View('main');
$view->title = __('Show work report');
$view->breadcrumbs = $breadcrumbs->html();
$view->content = new View('work_reports/show');
$view->content->work_report = $work_report;
$view->content->work_report_model = $work_report_model;
$view->content->transfer = $work_report_model->transfer;
$view->content->links = $links;
$view->content->state_text = $state_text;
$view->content->works_grid = $works_grid;
$view->render(TRUE);
}

/**
* Adds new work report
*
* @author Ondřej Fibich
* @param integer $user_id
*/
public function add($user_id = NULL)
{
if ($user_id)
{
if (!is_numeric($user_id))
Controller::warning(PARAMETER);
$user = new User_Model($user_id);
if (!$user->id)
Controller::error(RECORD);
if (!$this->acl_check_new('Users_Controller', 'work', $user->member_id))
Controller::error(ACCESS);
$selected = $user->id;
$arr_users[$user->id] = $user->get_full_name() . ' - ' . $user->login;
}
else
{
if (!$this->acl_check_new('Users_Controller', 'work'))
Controller::error(ACCESS);
$selected = $this->session->get('user_id');
$concat = "CONCAT(
COALESCE(surname, ''), ' ',
COALESCE(name, ''), ' - ',
COALESCE(login, '')
)";
$arr_users = ORM::factory('user')->select_list('id', $concat);
}
// approval templates
$arr_approval_templates = array();

if ($this->acl_check_view('approval', 'templates'))
{
$arr_approval_templates = ORM::factory('approval_template')->select_list();
}
// posted?
if ($_POST && count($_POST))
{
try
{
$form_data = $_POST;
// transaction
$work_report = new Job_report_Model();
$work_report->transaction_start();
// check
if (!isset($form_data['user_id']) ||
!isset($form_data['description']) ||
!isset($form_data['payment_type']) ||
!isset($form_data['price_per_hour']) ||
!isset($form_data['price_per_km']))
{
throw new Exception('Invalid post');
}
// approval template
if (isset($form_data['approval_template_id']) &&
$this->acl_check_view('approval', 'templates'))
{
$at_id = intval($form_data['approval_template_id']);
}
else
{
$at_id = $this->settings->get('default_work_approval_template');
}
// save report
$work_report->user_id = $form_data['user_id'];
$work_report->added_by_id = $this->user_id;
$work_report->approval_template_id = $at_id;
$work_report->description = $form_data['description'];
$work_report->price_per_hour = $form_data['price_per_hour'];
$work_report->concept = TRUE;
$work_report->payment_type = intval($form_data['payment_type']);
if (isset($form_data['type']) &&
preg_match('/^[0-9]{4}-[0-9]{1,2}$/', $form_data['type']))
{
$work_report->type = $form_data['type'];
}
if (is_numeric($form_data['price_per_km']))
{
$work_report->price_per_km = $form_data['price_per_km'];
}
$work_report->save_throwable();
// add works
if (isset($form_data['work_description']) &&
is_array($form_data['work_description']))
{
foreach ($form_data['work_description'] as $i => $description)
{
$hours = $form_data['work_hours'][$i];
$km = $form_data['work_km'][$i];

if (empty($description) ||
empty($hours) ||
empty($form_data['work_date']))
{
continue;
}

$suggest_amount = $work_report->price_per_hour * $hours;
$suggest_amount += $work_report->price_per_km * $km;

$date = explode('-', $form_data['work_date'][$i]);

$work = new Job_Model();
$work->job_report_id = $work_report->id;
$work->user_id = $form_data['user_id'];
$work->added_by_id = $this->user_id;
$work->approval_template_id = $at_id;
$work->description = $description;
$work->suggest_amount = $suggest_amount;
$work->date = date::create($date[2], $date[1], $date[0]);
$work->create_date = date('Y-m-d H:i:s');
$work->hours = $hours;
$work->km = $km;
$work->save_throwable();
}
}
// end adding
$work_report->transaction_commit();
status::success('Work report has been successfully added');
url::redirect('work_reports/show/' . $work_report->id);
}
catch (Exception $e)
{
$work_report->transaction_rollback();
Log::add_exception($e);
status::error('Error - cant add new work report.');
}
}
// view
$breadcrumbs = breadcrumbs::add()
->link('work_reports', 'Work reports',
$this->acl_check_view('Users_Controller','work'))
->text('Add new work report');

$view = new View('main');
$view->title = __('Add new work report');
$view->breadcrumbs = $breadcrumbs->html();
$view->content = new View('work_reports/add');
$view->content->arr_users = $arr_users;
$view->content->selected_user = $selected;
$view->content->arr_approval_templates = $arr_approval_templates;
$view->render(TRUE);
}

/**
* Edits work report
*
* @author Ondřej Fibich
* @param integer $work_report_id
*/
public function edit($work_report_id = NULL)
{
if (!$work_report_id || !is_numeric($work_report_id))
{
Controller::warning(PARAMETER);
}

$work_report = new Job_report_Model($work_report_id);

if (!$work_report || !$work_report->id)
{
Controller::error(RECORD);
}

// work report is locked
if ($work_report->get_state() > 0)
{
status::warning('It is not possible edit locked work report.');
url::redirect('work_reports/show/'.$work_report->id);
}
// concept can be edited only by owner
if (!$this->acl_check_edit(
'Users_Controller', 'work', $work_report->user->member_id
) || (
$work_report->concept &&
$this->user_id != $work_report->user_id &&
$this->user_id != $work_report->added_by_id
))
{
Controller::error(ACCESS);
}

// grouped works
if (empty($work_report->type))
{
$works = $work_report->jobs;
}
// monthly report
else
{
$works = $work_report->get_works_of_monthly_workreport();
}
// approval templates
$arr_approval_templates = array();

if ($this->acl_check_view('approval', 'templates'))
{
$arr_approval_templates = ORM::factory('approval_template')->select_list();
}

// posted
if ($_POST && count($_POST))
{
$form_data = $_POST;
$issaved = TRUE;
$count = 0;
if (!isset($form_data['price_per_hour']) ||
!isset($form_data['price_per_km']) ||
!isset($form_data['payment_type']) ||
!isset($form_data['description']))
{
throw new Exception('Invalid post');
}
// prices
$price_per_hour = doubleval($form_data['price_per_hour']);
if (empty($form_data['price_per_km']))
{
$price_per_km = NULL;
}
else
{
$price_per_km = doubleval($form_data['price_per_km']);
}
// db work
try
{
$work_report->transaction_start();
//// save report
if (isset($form_data['approval_template_id']) &&
$this->acl_check_view('approval', 'templates'))
{
$at_id = intval($form_data['approval_template_id']);
$work_report->approval_template_id = $at_id;
}
$work_report->description = $form_data['description'];
$work_report->price_per_hour = $price_per_hour;
$work_report->price_per_km = $price_per_km;
$work_report->payment_type = intval($form_data['payment_type']);
$work_report->save_throwable();
//// delete works
// delete all works in report
if (!isset($form_data['work_id']) ||
!is_array($form_data['work_id']) ||
!count($form_data['work_id']))
{
$work_report->delete_works();
}
// delete all deleted, preserved existings
else
{
$preserved_ids = array_values($form_data['work_id']);
$work_report->delete_works($preserved_ids);
}
//// add/update works
if (isset($form_data['work_description']))
{
foreach ($form_data['work_description'] as $i => $description)
{
$date = $form_data['work_date'][$i];
$hours = doubleval($form_data['work_hours'][$i]);
$km = intval($form_data['work_km'][$i]);
$work_id = isset($form_data['work_id'][$i]) ? $form_data['work_id'][$i] : FALSE;
// valid?
if (!preg_match('/^[0-9]{4}-[0-9]{1,2}-[0-9]{1,2}$/', $date) ||
($hours <= 0) || ($hours > 24))
{
// skip to next
continue;
}
// load for edit
if ($work_id)
{
$work = new Job_Model($work_id);
}
else
{
$work = new Job_Model();
$work->added_by_id = $this->user_id;
}
$suggest_amount = $work_report->price_per_hour * $hours;
$suggest_amount += $work_report->price_per_km * $km;

$date = explode('-', $date);

// edit/add
$work->job_report_id = $work_report->id;
$work->user_id = $work_report->user_id;
$work->approval_template_id = $work_report->approval_template_id;
$work->description = $description;
$work->suggest_amount = $suggest_amount;
$work->date = date::create($date[2], $date[1], $date[0]);
$work->create_date = date('Y-m-d H:i:s');
$work->hours = $hours;
$work->km = $km;
$work->save_throwable();
}
}
//// finish
$work_report->transaction_commit();
status::success('Work report has been successfully updated');
url::redirect('work_reports/show/'.$work_report->id);
}
catch (Exception $e)
{
$work_report->transaction_rollback();
Log::add_exception($e);
status::error('Error - cant edit work report.');
}
}
// breadcrumbs
$breadcrumbs = breadcrumbs::add()
->link('work_reports', 'Work reports',
$this->acl_check_view('Users_Controller', 'work'));

switch ($work_report->get_state())
{
case 0:
case 1:
$breadcrumbs->link('work_reports/pending', 'Pending');
break;
case 2:
$breadcrumbs->link('work_reports/rejected', 'Rejected');
break;
case 3:
$breadcrumbs->link('work_reports/approved', 'Approved');
break;
}
$breadcrumbs->disable_translation()
->link('work_reports/show_by_user/' . $work_report->user_id,
$work_report->user->get_full_name())
->link('work_reports/show/' . $work_report->id,
text::limit_chars($work_report->description, 40))
->enable_translation()
->text('Edit');

// view
$view = new View('main');
$view->title = __('Edit work report');
$view->breadcrumbs = $breadcrumbs->html();
$view->content = new View('work_reports/edit');
$view->content->work_report = $work_report;
$view->content->month = intval(substr($work_report->type, 5, 6));
$view->content->year = intval(substr($work_report->type, 0, 4));
$view->content->works = $works;
$view->content->arr_approval_templates = $arr_approval_templates;
$view->render(TRUE);
}

/**
* Deletes work report and it's works.
* Unlock approval template if it is possible.
*
* @param integer $work_report_id
*/
public function delete($work_report_id = NULL)
{
if (!$work_report_id || !is_numeric($work_report_id))
{
Controller::warning(PARAMETER);
}

$work_report_model = new Job_report_Model($work_report_id);
$work_report = $work_report_model->get_work_report($work_report_id);

if (!$work_report || !$work_report->id)
{
Controller::error(RECORD);
}

if (!$this->acl_check_delete('Users_Controller', 'work', $work_report->member_id))
{
Controller::error(ACCESS);
}

// work is locked?
if ($work_report->state > 0)
{
status::warning('It is not possible delete locked work report.');
url::redirect('work_reports/show/' . $work_report->id);
}

$approval_template_id = $work_report->approval_template_id;

// delete report (works are deleted by forein key)
$saved = $work_report_model->delete();

// set up state of approval template
$approval_template = new Approval_template_Model($approval_template_id);
$approval_template->state = $approval_template->get_state();
$saved = $saved && $approval_template->save();

if ($saved)
{
status::success('Work report has been successfully deleted');
}
$linkback = Path::instance()->previous();
if (url::slice(url_lang::uri($linkback),1,1) == 'show')
{
$linkback = 'work_reports/pending';
}

$this->redirect($linkback);
}
/**
* Un-concept report by owner
*
* @param integer $work_report_id
*/
public function concept_change($work_report_id = NULL)
{
if (!$work_report_id || !is_numeric($work_report_id))
{
Controller::warning(PARAMETER);
}

$work_report = new Job_report_Model($work_report_id);

if (!$work_report || !$work_report->id)
{
Controller::error(RECORD);
}
// is actual user owner of concept?
if ($this->user_id != $work_report->user_id &&
$this->user_id != $work_report->added_by_id)
{
Controller::error(ACCESS);
}

// work report is locked?
if ($work_report->get_state() > 0 || !$work_report->concept)
{
status::warning('It is not possible edit locked work report.');
url::redirect( 'work_reports/show/' . $work_report->id);
}
// has any work?
if (!$work_report->jobs->count())
{
status::warning('Work report has to have at least one work.');
url::redirect( 'work_reports/show/' . $work_report->id);
}
$work_report->concept = FALSE;
if ($work_report->save())
{
status::success('Concept of report has been sended fo approval.');
}
url::redirect( 'work_reports/show/' . $work_report->id);
}

}