public function render_link()
{
$url = '';
$link = nl2br($this->description);
$siteconfig = org_openpsa_core_siteconfig::get_instance();
$projects_url = $siteconfig->get_node_full_url('org.openpsa.projects');
$sales_url = $siteconfig->get_node_full_url('org.openpsa.sales');
if ($projects_url) {
try {
$task = org_openpsa_projects_task_dba::get_cached($this->task);
$url = $projects_url . 'task/' . $task->guid . '/';
} catch (midcom_error $e) {
}
}
if ($url == '' && $sales_url) {
try {
$deliverable = org_openpsa_sales_salesproject_deliverable_dba::get_cached($this->deliverable);
$url = $sales_url . 'deliverable/' . $deliverable->guid . '/';
} catch (midcom_error $e) {
}
}
if ($url != '') {
$link = '<a href="' . $url . '">' . $link . '</a>';
}
return $link;
}
public function get_row(midcom_core_dbaobject $at_entry)
{
$invoice = array('time' => strftime('%Y-%m-%d %H:%M:%S', $at_entry->start));
try {
$deliverable = org_openpsa_sales_salesproject_deliverable_dba::get_cached($at_entry->arguments['deliverable']);
$salesproject = org_openpsa_sales_salesproject_dba::get_cached($deliverable->salesproject);
} catch (midcom_error $e) {
$e->log();
return $invoice;
}
if ($deliverable->invoiceByActualUnits) {
$type = midcom::get('i18n')->get_l10n('org.openpsa.expenses')->get('invoiceable reports');
$invoice_sum = $deliverable->units * $deliverable->pricePerUnit;
} else {
$invoice_sum = $deliverable->price;
$type = midcom::get('i18n')->get_l10n('org.openpsa.reports')->get('fixed price');
}
$invoice['sum'] = $invoice_sum;
$invoice['deliverable'] = $deliverable->title;
$invoice['index_deliverable'] = $deliverable->title;
$invoice['type'] = $type;
$invoice = $this->_render_contact_field($salesproject->customer, 'customer', $invoice, 'org_openpsa_contacts_group_dba');
$invoice = $this->_render_contact_field($salesproject->customerContact, 'customerContact', $invoice);
$invoice = $this->_render_contact_field($salesproject->owner, 'owner', $invoice);
if (!empty($this->_sales_url)) {
$invoice['deliverable'] = '<a href="' . $this->_sales_url . 'deliverable/' . $deliverable->guid . '/">' . $invoice['deliverable'] . '</a>';
}
return $invoice;
}
private function _generate_invoice()
{
$invoice = new org_openpsa_invoices_invoice_dba();
$invoice->customer = (int) $_POST['org_openpsa_invoices_invoice_customer'];
$invoice->number = $invoice->generate_invoice_number();
$invoice->owner = midcom_connection::get_user();
$invoice->vat = $invoice->get_default('vat');
$invoice->description = $invoice->get_default('remarks');
if (!$invoice->create()) {
midcom::get('uimessages')->add($this->_l10n->get('org.openpsa.invoices'), $this->_l10n->get('failed to create invoice, reason ') . midcom_connection::get_error_string(), 'error');
return false;
}
// create invoice_items
foreach ($_POST['org_openpsa_invoices_invoice_tasks'] as $task_id => $invoiceable) {
if (!$invoiceable) {
continue;
}
$task = $this->_tasks[$task_id];
//instance the invoice_items
$item = new org_openpsa_invoices_invoice_item_dba();
$item->task = $task_id;
try {
$deliverable = org_openpsa_sales_salesproject_deliverable_dba::get_cached($task->agreement);
$item->deliverable = $deliverable->id;
} catch (midcom_error $e) {
$e->log();
}
$item->invoice = $invoice->id;
$item->description = $task->title;
$item->pricePerUnit = (double) $_POST['org_openpsa_invoices_invoice_tasks_price'][$task_id];
$item->units = (double) $_POST['org_openpsa_invoices_invoice_tasks_units'][$task_id];
$item->create();
// Connect invoice to the tasks involved
org_openpsa_projects_workflow::mark_invoiced($task, $invoice);
}
// Generate "Send invoice" task
$invoice_sender_guid = $this->_config->get('invoice_sender');
if (!empty($invoice_sender_guid)) {
$invoice->generate_invoicing_task($invoice_sender_guid);
}
midcom::get('uimessages')->add($this->_l10n->get('org.openpsa.invoices'), sprintf($this->_l10n->get('invoice %s created'), $invoice->get_label()), 'ok');
midcom::get()->relocate("invoice/edit/{$invoice->guid}/");
// This will exit
}
private function _prepare_grid_data()
{
$this->_request_data['grid'] = new org_openpsa_widgets_grid('invoice_items', 'local');
$entries = array();
$invoice_sum = 0;
foreach ($this->_request_data['invoice_items'] as $item) {
$entry = array();
$entry['id'] = $item->id;
try {
$deliverable = org_openpsa_sales_salesproject_deliverable_dba::get_cached($item->deliverable);
$entry['deliverable'] = $deliverable->title;
} catch (midcom_error $e) {
$entry['deliverable'] = '';
}
try {
$task = org_openpsa_projects_task_dba::get_cached($item->task);
$entry['task'] = $task->title;
} catch (midcom_error $e) {
$entry['task'] = '';
}
$entry['description'] = $item->description;
$entry['price'] = $item->pricePerUnit;
$entry['quantity'] = $item->units;
$entry['position'] = $item->position;
$item_sum = $item->units * $item->pricePerUnit;
$invoice_sum += $item_sum;
$entry['sum'] = $item_sum;
$entry['action'] = '';
$entries[] = $entry;
}
$this->_request_data['entries'] = $entries;
$this->_request_data['grid']->set_footer_data(array('sum' => $invoice_sum));
}
/**
*
* @param mixed $handler_id The ID of the handler.
* @param array &$data The local request data.
*/
public function _show_generator($handler_id, array &$data)
{
midcom_show_style('sales_report-deliverable-start');
// Quick workaround to Bergies lazy determination of whether this is user's or everyone's report...
if ($this->_request_data['query_data']['resource'] == 'user:'******'auth')->user->guid) {
// My report
$data['handler_id'] = 'deliverable_report';
} else {
// Generic report
$data['handler_id'] = 'sales_report';
}
/*** Copied from sales/handler/deliverable/report.php ***/
midcom_show_style('sales_report-deliverable-header');
$invoices_node = midcom_helper_misc::find_node_by_component('org.openpsa.invoices');
$sums_per_person = array();
$sums_all = array('price' => 0, 'cost' => 0, 'profit' => 0);
$odd = true;
foreach ($data['invoices'] as $deliverable_guid => $invoices) {
if (count($invoices) == 0) {
// No invoices sent in this project, skip
continue;
}
try {
$deliverable = org_openpsa_sales_salesproject_deliverable_dba::get_cached($deliverable_guid);
$product = org_openpsa_products_product_dba::get_cached($deliverable->product);
$salesproject = org_openpsa_sales_salesproject_dba::get_cached($deliverable->salesproject);
$customer = midcom_db_group::get_cached($salesproject->customer);
} catch (midcom_error $e) {
continue;
}
if (!array_key_exists($salesproject->owner, $sums_per_person)) {
$sums_per_person[$salesproject->owner] = array('price' => 0, 'cost' => 0, 'profit' => 0);
}
// Calculate the price and cost from invoices
$invoice_price = 0;
$data['invoice_string'] = '';
$invoice_cycle_numbers = array();
foreach ($invoices as $invoice) {
$invoice_price += $invoice->sum;
$invoice_class = $invoice->get_status();
if ($invoices_node) {
$invoice_label = "<a class=\"{$invoice_class}\" href=\"{$invoices_node[MIDCOM_NAV_FULLURL]}invoice/{$invoice->guid}/\">" . $invoice->get_label() . "</a>";
} else {
$invoice_label = $invoice->get_label();
}
if ($product->delivery == org_openpsa_products_product_dba::DELIVERY_SUBSCRIPTION) {
$invoice_cycle_numbers[] = (int) $invoice->parameter('org.openpsa.sales', 'cycle_number');
}
$data['invoice_string'] .= "<li class=\"{$invoice_class}\">{$invoice_label}</li>\n";
}
if ($product->delivery == org_openpsa_products_product_dba::DELIVERY_SUBSCRIPTION) {
// This is a subscription, it should be shown only if it is the first invoice
if (!in_array(1, $invoice_cycle_numbers)) {
continue;
// This will skip to next deliverable
}
$scheduler = new org_openpsa_invoices_scheduler($deliverable);
if ($deliverable->end == 0) {
// Subscription doesn't have an end date, use specified amount of months for calculation
$cycles = $scheduler->calculate_cycles($this->_config->get('subscription_profit_months'));
$data['calculation_basis'] = sprintf($data['l10n']->get('%s cycles in %s months'), $cycles, $this->_config->get('subscription_profit_months'));
} else {
$cycles = $scheduler->calculate_cycles();
$data['calculation_basis'] = sprintf($data['l10n']->get('%s cycles, %s - %s'), $cycles, strftime('%x', $deliverable->start), strftime('%x', $deliverable->end));
}
$price = $deliverable->price * $cycles;
$cost = $deliverable->cost * $cycles;
} else {
// This is a single delivery, calculate cost as percentage as it may be invoiced in pieces
if ($deliverable->price) {
$cost_percentage = 100 / $deliverable->price * $invoice_price;
$cost = $deliverable->cost / 100 * $cost_percentage;
} else {
$cost_percentage = 100;
$cost = $deliverable->cost;
}
$price = $invoice_price;
$data['calculation_basis'] = sprintf($data['l10n']->get('%s%% of %s'), round($cost_percentage), $deliverable->price);
}
// And now just count the profit
$profit = $price - $cost;
$data['customer'] = $customer;
$data['salesproject'] = $salesproject;
$data['deliverable'] = $deliverable;
$data['price'] = $price;
$sums_per_person[$salesproject->owner]['price'] += $price;
$sums_all['price'] += $price;
$data['cost'] = $cost;
$sums_per_person[$salesproject->owner]['cost'] += $cost;
$sums_all['cost'] += $cost;
$data['profit'] = $profit;
$sums_per_person[$salesproject->owner]['profit'] += $profit;
$sums_all['profit'] += $profit;
if ($odd) {
$data['row_class'] = '';
$odd = false;
} else {
$data['row_class'] = ' class="even"';
$odd = true;
}
midcom_show_style('sales_report-deliverable-item');
}
$data['sums_per_person'] = $sums_per_person;
$data['sums_all'] = $sums_all;
midcom_show_style('sales_report-deliverable-footer');
/*** /Copied from sales/handler/deliverable/report.php ***/
midcom_show_style('sales_report-deliverable-end');
}
/**
* Connect the task hour reports to an invoice
*
* @param org_openpsa_projects_task_dba &$task The task we're working on
* @param org_openpsa_invoices_invoice_dba &$invoice The invoice we're working on
*/
static function mark_invoiced(&$task, &$invoice)
{
debug_add("task->mark_invoiced() called with user #" . midcom_connection::get_user());
try {
$deliverable = org_openpsa_sales_salesproject_deliverable_dba::get_cached($task->agreement);
} catch (midcom_error $e) {
$e->log();
}
// Mark the hour reports invoiced
$hours_marked = 0;
$qb = org_openpsa_projects_hour_report_dba::new_query_builder();
$qb->add_constraint('task', '=', $task->id);
$qb->add_constraint('invoice', '=', 0);
$qb->add_constraint('invoiceable', '=', true);
// Check how the agreement deals with hour reports
if ($deliverable && $deliverable->invoiceApprovedOnly) {
// The agreement allows invoicing only approved hours, therefore don't mark unapproved
$qb->add_constraint('metadata.isapproved', '=', true);
}
$reports = $qb->execute();
foreach ($reports as $report) {
$report->invoice = $invoice->id;
$report->_skip_parent_refresh = true;
if ($report->update()) {
$hours_marked += $report->hours;
}
}
// Update hour caches to agreement
if (!$task->update_cache()) {
debug_add('Failed to update task hour caches, last Midgard error: ' . midcom_connection::get_error_string(), MIDCOM_LOG_WARN);
}
// Notify user
midcom::get('uimessages')->add(midcom::get('i18n')->get_string('org.openpsa.projects', 'org.openpsa.projects'), sprintf(midcom::get('i18n')->get_string('marked %s hours as invoiced in task "%s"', 'org.openpsa.projects'), $hours_marked, $task->title), 'ok');
return $hours_marked;
}
private function _prepare_save()
{
//Make sure we have start
if (!$this->start) {
$this->start = time();
}
//Make sure we have end
if (!$this->end || $this->end == -1) {
$this->end = time();
}
//Reset start and end to start/end of day
$this->start = mktime(0, 0, 0, date('n', $this->start), date('j', $this->start), date('Y', $this->start));
$this->end = mktime(23, 59, 59, date('n', $this->end), date('j', $this->end), date('Y', $this->end));
if ($this->start > $this->end) {
debug_add("start ({$this->start}) is greater than end ({$this->end}), aborting", MIDCOM_LOG_ERROR);
return false;
}
if ($this->orgOpenpsaWgtype == ORG_OPENPSA_OBTYPE_TASK) {
$this->orgOpenpsaWgtype = ORG_OPENPSA_WGTYPE_NONE;
}
if ($this->agreement) {
// Get customer company into cache from agreement's sales project
try {
$agreement = org_openpsa_sales_salesproject_deliverable_dba::get_cached($this->agreement);
$this->hoursInvoiceableDefault = true;
if (!$this->customer) {
$salesproject = org_openpsa_sales_salesproject_dba::get_cached($agreement->salesproject);
$this->customer = $salesproject->customer;
}
} catch (midcom_error $e) {
}
} else {
// No agreement, we can't be invoiceable
$this->hoursInvoiceableDefault = false;
}
// Update hour caches
$this->update_cache(false);
return true;
}
/**
* List all tasks, optionally filtered by status
*/
private function _handler_list_all($args)
{
// Default to open tasks list if none specified
if (!isset($args[1]) || empty($args[1])) {
$this->_request_data['view_identifier'] = 'open';
$args[1] = 'open';
}
switch ($args[1]) {
case 'agreement':
if (!$args[2]) {
throw new midcom_error('Invalid arguments for agreement filter');
}
$agreement_id = (int) $args[2];
$this->_request_data['agreement'] = $agreement_id;
$deliverable = org_openpsa_sales_salesproject_deliverable_dba::get_cached($agreement_id);
$title = sprintf($this->_l10n->get('tasks for agreement %s'), $deliverable->title);
midcom::get('head')->set_pagetitle($title);
$this->add_breadcrumb("", $title);
$this->_qb->add_constraint('agreement', '=', $deliverable->id);
$this->_provider->add_order('end', 'DESC');
break;
case 'all':
case 'both':
$args[1] = 'all';
$this->_provider->add_order('end', 'DESC');
break;
case 'open':
$this->set_active_leaf($this->_topic->id . ':tasks_open');
$this->_qb->add_constraint('status', '<', org_openpsa_projects_task_status_dba::CLOSED);
$this->_provider->add_order('end');
break;
case 'closed':
$this->set_active_leaf($this->_topic->id . ':tasks_closed');
$this->_qb->add_constraint('status', '=', org_openpsa_projects_task_status_dba::CLOSED);
$this->_provider->add_order('end', 'DESC');
break;
case 'current':
$this->_qb->add_constraint('status', 'IN', array(org_openpsa_projects_task_status_dba::ACCEPTED, org_openpsa_projects_task_status_dba::STARTED, org_openpsa_projects_task_status_dba::REJECTED, org_openpsa_projects_task_status_dba::REOPENED));
$this->_provider->add_order('end');
break;
case 'invoiceable':
$this->set_active_leaf($this->_topic->id . ':tasks_invoiceable');
$this->_qb->add_constraint('invoiceableHours', '>', 0);
$this->_provider->add_order('end');
break;
case 'invoiced':
$this->set_active_leaf($this->_topic->id . ':tasks_invoiced');
$this->_qb->add_constraint('invoicedHours', '>', 0);
$this->_provider->add_order('end', 'DESC');
break;
default:
throw new midcom_error("Filter {$args[1]} not recognized");
}
$qf = new org_openpsa_core_queryfilter('org_openpsa_task_list_' . $args[1]);
$qf->add_filter(new org_openpsa_core_filter('priority', '<=', $this->_request_data['priority_array']));
$date_filter = new org_openpsa_core_filter('timeframe');
$date_filter->set('mode', 'timeframe');
$date_filter->set('helptext', $this->_l10n->get("timeframe"));
$date_filter->set('fieldname', array('start' => 'start', 'end' => 'end'));
$qf->add_filter($date_filter);
$qf->apply_filters($this->_qb);
$this->_request_data["qf"] = $qf;
$this->_request_data['table-heading'] = $args[1] . ' tasks';
$this->_request_data['view'] = 'grid';
}
private function _get_scheduled_invoices()
{
$invoices = array();
$at_qb = midcom_services_at_entry_dba::new_query_builder();
$at_qb->add_constraint('method', '=', 'new_subscription_cycle');
$at_qb->add_constraint('component', '=', 'org.openpsa.sales');
$at_entries = $at_qb->execute();
foreach ($at_entries as $at_entry) {
try {
$deliverable = org_openpsa_sales_salesproject_deliverable_dba::get_cached($at_entry->arguments['deliverable']);
if ($deliverable->continuous || $deliverable->start < $this->_request_data['end'] && $deliverable->end > $this->_request_data['start']) {
$invoices = array_merge($invoices, $this->_get_invoices_for_subscription($deliverable, $at_entry));
}
} catch (midcom_error $e) {
}
}
$invoices = array_filter($invoices, array($this, '_filter_by_date'));
usort($invoices, array($this, '_sort_by_date'));
return $invoices;
}
<?php
$view_task =& $data['object_view'];
$task =& $data['object'];
$task->get_members();
$prefix = midcom_core_context::get()->get_key(MIDCOM_CONTEXT_ANCHORPREFIX);
$siteconfig = org_openpsa_core_siteconfig::get_instance();
$sales_url = $siteconfig->get_node_full_url('org.openpsa.sales');
$expenses_url = $siteconfig->get_node_relative_url('org.openpsa.expenses');
?>
<div class="org_openpsa_projects_task">
<div class="sidebar">
<?php
if ($task->agreement) {
try {
$agreement = org_openpsa_sales_salesproject_deliverable_dba::get_cached($task->agreement);
$output = $agreement->deliverable_html;
if ($sales_url) {
$salesproject = org_openpsa_sales_salesproject_dba::get_cached($agreement->salesproject);
$output = "<a href=\"{$sales_url}salesproject/{$salesproject->guid}/#{$agreement->guid}/\">{$output}</a>\n";
}
echo "<h2>" . $data['l10n']->get('agreement') . "</h2>\n";
echo $output;
} catch (midcom_error $e) {
}
}
if ($task->manager) {
echo "<h2>" . $data['l10n']->get('manager') . "</h2>\n";
$contact = org_openpsa_widgets_contact::get($task->manager);
echo $contact->show_inline();
}
