/**
* Save the event transaction
*
*
*/
function mdjm_save_event_transaction_ajax()
{
global $mdjm_event;
$result = array();
$mdjm_event = new MDJM_Event($_POST['event_id']);
$mdjm_txn = new MDJM_Txn();
$txn_data = array('post_parent' => $_POST['event_id'], 'post_author' => $mdjm_event->client, 'post_status' => $_POST['direction'] == 'Out' ? 'mdjm-expenditure' : 'mdjm-income', 'post_date' => date('Y-m-d H:i:s', strtotime($_POST['date'])));
$txn_meta = array('_mdjm_txn_status' => 'Completed', '_mdjm_payment_from' => $mdjm_event->client, '_mdjm_txn_total' => $_POST['amount'], '_mdjm_payer_firstname' => mdjm_get_client_firstname($mdjm_event->client), '_mdjm_payer_lastname' => mdjm_get_client_lastname($mdjm_event->client), '_mdjm_payer_email' => mdjm_get_client_email($mdjm_event->client), '_mdjm_payment_from' => mdjm_get_client_display_name($mdjm_event->client), '_mdjm_txn_source' => $_POST['src']);
if ($_POST['direction'] == 'In') {
if (!empty($_POST['from'])) {
$txn_meta['_mdjm_payment_from'] = sanitize_text_field($_POST['from']);
} else {
$txn_meta['_mdjm_payment_from'] = mdjm_get_client_display_name($mdjm_event->client);
}
}
if ($_POST['direction'] == 'Out') {
if (!empty($_POST['to'])) {
$txn_meta['_mdjm_payment_to'] = sanitize_text_field($_POST['to']);
} else {
$txn_meta['_mdjm_payment_to'] = mdjm_get_client_display_name($mdjm_event->client);
}
}
$mdjm_txn->create($txn_data, $txn_meta);
if ($mdjm_txn->ID > 0) {
$result['type'] = 'success';
mdjm_set_txn_type($mdjm_txn->ID, $_POST['for']);
$args = array('user_id' => get_current_user_id(), 'event_id' => $_POST['event_id'], 'comment_content' => sprintf(__('%1$s payment of %2$s received for %3$s %4$s.', 'mobile-dj-manager'), $_POST['direction'] == 'In' ? __('Incoming', 'mobile-dj-manager') : __('Outgoing', 'mobile-dj-manager'), mdjm_currency_filter(mdjm_format_amount($_POST['amount'])), mdjm_get_label_singular(true), mdjm_get_event_contract_id($_POST['event_id'])));
mdjm_add_journal($args);
// Email overide
if (empty($_POST['send_notice']) && mdjm_get_option('manual_payment_cfm_template')) {
$manual_email_template = mdjm_get_option('manual_payment_cfm_template');
mdjm_update_option('manual_payment_cfm_template', 0);
}
$payment_for = $mdjm_txn->get_type();
$amount = mdjm_currency_filter(mdjm_format_amount($_POST['amount']));
mdjm_add_content_tag('payment_for', __('Reason for payment', 'mobile-dj-manager'), function () use($payment_for) {
return $payment_for;
});
mdjm_add_content_tag('payment_amount', __('Payment amount', 'mobile-dj-manager'), function () use($amount) {
return $amount;
});
mdjm_add_content_tag('payment_date', __('Date of payment', 'mobile-dj-manager'), 'mdjm_content_tag_ddmmyyyy');
/**
* Allow hooks into this payment. The hook is suffixed with 'in' or 'out' depending
* on the payment direction. i.e. mdjm_post_add_manual_txn_in and mdjm_post_add_manual_txn_out
*
* @since 1.3.7
* @param int $event_id
* @param obj $txn_id
*/
do_action('mdjm_post_add_manual_txn_' . strtolower($_POST['direction']), $_POST['event_id'], $mdjm_txn->ID);
// Email overide
if (empty($_POST['send_notice']) && isset($manual_email_template)) {
mdjm_update_option('manual_payment_cfm_template', $manual_email_template);
}
$result['deposit_paid'] = 'N';
$result['balance_paid'] = 'N';
if ($mdjm_event->get_remaining_deposit() < 1) {
mdjm_update_event_meta($mdjm_event->ID, array('_mdjm_event_deposit_status' => 'Paid'));
$result['deposit_paid'] = 'Y';
}
if ($mdjm_event->get_balance() < 1) {
mdjm_update_event_meta($mdjm_event->ID, array('_mdjm_event_balance_status' => 'Paid'));
mdjm_update_event_meta($mdjm_event->ID, array('_mdjm_event_deposit_status' => 'Paid'));
$result['balance_paid'] = 'Y';
$result['deposit_paid'] = 'Y';
}
} else {
$result['type'] = 'error';
$result['msg'] = __('Unable to add transaction', 'mobile-dj-manager');
}
ob_start();
mdjm_do_event_txn_table($_POST['event_id']);
$result['transactions'] = ob_get_contents();
ob_get_clean();
echo json_encode($result);
die;
}
/**
* Output the event client row
*
* @since 1.3.7
* @global obj $mdjm_event MDJM_Event class object
* @global bool $mdjm_event_update True if this event is being updated, false if new.
* @param int $event_id The event ID.
* @return str
*/
function mdjm_event_metabox_client_select_row($event_id)
{
global $mdjm_event, $mdjm_event_update;
?>
<div class="mdjm_field_wrap mdjm_form_fields">
<div class="mdjm_col">
<label for="client_name"><?php
_e('Client:');
?>
</label>
<?php
if (mdjm_event_is_active($event_id)) {
?>
<?php
$clients = mdjm_get_clients('client');
?>
<?php
echo MDJM()->html->client_dropdown(array('selected' => $mdjm_event->client, 'class' => '', 'roles' => array('client'), 'chosen' => true, 'placeholder' => __('Select a Client', 'mobile-dj-manager'), 'null_value' => array('' => __('Select a Client', 'mobile-dj-manager')), 'add_new' => empty($mdjm_event->client) ? true : false, 'show_option_all' => false, 'show_option_none' => false));
?>
<?php
} else {
?>
<?php
echo MDJM()->html->text(array('name' => 'client_name_display', 'class' => '', 'value' => mdjm_get_client_display_name($mdjm_event->client), 'readonly' => true));
?>
<?php
echo MDJM()->html->hidden(array('name' => 'client_name', 'class' => '', 'value' => $mdjm_event->client));
?>
<?php
}
?>
<?php
if (mdjm_employee_can('view_clients_list') && $mdjm_event_update && $mdjm_event->client) {
?>
<a id="toggle_client_details" class="mdjm-small mdjm-fake"><?php
_e('Toggle Client Details', 'mobile-dj-manager');
?>
</a>
<?php
}
?>
</div>
</div>
<?php
}
/**
* Get the Export Data
*
* @access public
* @since 1.4
* @return arr $data The data for the CSV file
*/
public function get_data()
{
$data = array();
// Export all events
$offset = 30 * ($this->step - 1);
$args = array('post_type' => 'mdjm-event', 'posts_per_page' => 30, 'offset' => $offset, 'paged' => $this->step, 'post_status' => $this->status, 'order' => 'ASC', 'orderby' => 'ID');
if (!empty($this->start) || !empty($this->end)) {
$args['meta_query'] = array(array('key' => '_mdjm_event_date', 'value' => array(date('Y-m-d', strtotime($this->start)), date('Y-m-d', strtotime($this->end))), 'compare' => 'BETWEEN', 'type' => 'DATE'));
}
$events = get_posts($args);
if ($events) {
$i = 0;
foreach ($events as $event) {
$event_data = mdjm_get_event_data($event->ID);
$employees = array();
$package = '';
$addons = array();
if (!empty($event_data['client'])) {
$client = '(' . $event_data['client'] . ') ' . mdjm_get_client_display_name($event_data['client']);
}
if (!empty($event_data['employees']['primary_employee'])) {
$primary_employee = '(' . $event_data['employees']['primary_employee'] . ') ' . mdjm_get_employee_display_name($event_data['employees']['primary_employee']);
}
if (!empty($event_data['employees']['employees'])) {
foreach ($event_data['employees']['employees'] as $employee_id => $employee_data) {
$employees[] = '(' . $employee_id . ') ' . mdjm_get_employee_display_name($employee_id);
}
}
if (!empty($event_data['equipment']['package'])) {
$package = $event_data['equipment']['package'];
}
if (!empty($event_data['equipment']['addons'])) {
foreach ($event_data['equipment']['addons'] as $addon_id) {
$addons[] = mdjm_get_addon_name($addon_id);
}
}
$data[$i] = array('id' => $event->ID, 'event_id' => mdjm_get_event_contract_id($event->ID), 'date' => mdjm_format_short_date($event_data['date']), 'status' => $event_data['status'], 'client' => $client, 'primary_employee' => '(' . $event_data['employees']['primary_employee'] . ') ' . mdjm_get_client_display_name($event_data['employees']['primary_employee']), 'employees' => implode(',', $employees), 'package' => $package, 'addons' => implode(', ', $addons), 'cost' => mdjm_format_amount($event_data['cost']['cost']), 'deposit' => mdjm_format_amount($event_data['cost']['deposit']), 'deposit_status' => $event_data['cost']['deposit_status'], 'balance' => mdjm_format_amount($event_data['cost']['balance']), 'balance_status' => $event_data['cost']['balance_status'], 'start_time' => mdjm_format_time($event_data['start_time']), 'end_time' => mdjm_format_time($event_data['end_time']), 'end_date' => mdjm_format_short_date($event_data['end_date']), 'setup_date' => mdjm_format_short_date($event_data['setup_date']), 'setup_time' => mdjm_format_time($event_data['setup_time']), 'duration' => $event_data['duration'], 'contract' => $event_data['contract'], 'contract_status' => $event_data['contract_status'], 'playlist_enabled' => $event_data['playlist']['playlist_enabled'], 'playlist_status' => $event_data['playlist']['playlist_status'], 'source' => $event_data['source'], 'converted' => $event_data['contract_status'], 'venue' => $event_data['venue']['name'], 'address' => !empty($event_data['venue']['address']) ? implode(', ', $event_data['venue']['address']) : '');
$i++;
}
$data = apply_filters('mdjm_export_get_data', $data);
$data = apply_filters('mdjm_export_get_data_' . $this->export_type, $data);
return $data;
}
return false;
}
/**
* Content tag: client_fullname.
* The full name of the client.
*
* @param int The event ID.
* @param int The client ID.
*
* @return str The full name (display name) of the client.
*/
function mdjm_content_tag_client_fullname($event_id = '', $client_id = '')
{
if (!empty($client_id)) {
$user_id = $client_id;
} elseif (!empty($event_id)) {
$user_id = mdjm_get_event_client_id($event_id);
} else {
$user_id = '';
}
$full_name = '';
if (!empty($user_id)) {
$full_name = mdjm_get_client_display_name($user_id);
}
return $full_name;
}
/**
* Mark the event balance as paid.
*
* Determines if any balance remains and if so, assumes it has been paid and
* creates an associted transaction.
*
* @since 1.3
* @param int $event_id The event ID.
* @return void
*/
function mdjm_mark_event_balance_paid($event_id)
{
$mdjm_event = new MDJM_Event($event_id);
$txn_id = 0;
if ('Paid' == $mdjm_event->get_balance_status()) {
return;
}
$remaining = $mdjm_event->get_balance();
do_action('mdjm_pre_mark_event_balance_paid', $event_id, $remaining);
if (!empty($remaining) && $remaining > 0) {
$mdjm_txn = new MDJM_Txn();
$txn_meta = array('_mdjm_txn_source' => mdjm_get_option('default_type', __('Cash', 'mobile-dj-manager')), '_mdjm_txn_currency' => mdjm_get_currency(), '_mdjm_txn_status' => 'Completed', '_mdjm_txn_total' => $remaining, '_mdjm_payer_firstname' => mdjm_get_client_firstname($mdjm_event->client), '_mdjm_payer_lastname' => mdjm_get_client_lastname($mdjm_event->client), '_mdjm_payer_email' => mdjm_get_client_email($mdjm_event->client), '_mdjm_payment_from' => mdjm_get_client_display_name($mdjm_event->client));
$mdjm_txn->create(array('post_parent' => $event_id), $txn_meta);
if ($mdjm_txn->ID > 0) {
mdjm_set_txn_type($mdjm_txn->ID, mdjm_get_txn_cat_id('slug', 'mdjm-balance-payments'));
$args = array('user_id' => get_current_user_id(), 'event_id' => $event_id, 'comment_content' => sprintf(__('%1$s payment of %2$s received and %1$s marked as paid.', 'mobile-dj-manager'), mdjm_get_balance_label(), mdjm_currency_filter(mdjm_format_amount($remaining))));
mdjm_add_journal($args);
mdjm_add_content_tag('payment_for', __('Reason for payment', 'mobile-dj-manager'), 'mdjm_content_tag_balance_label');
mdjm_add_content_tag('payment_amount', __('Payment amount', 'mobile-dj-manager'), function () use($remaining) {
return mdjm_currency_filter(mdjm_format_amount($remaining));
});
mdjm_add_content_tag('payment_date', __('Date of payment', 'mobile-dj-manager'), 'mdjm_content_tag_ddmmyyyy');
do_action('mdjm_post_add_manual_txn_in', $event_id, $mdjm_txn->ID);
}
}
mdjm_update_event_meta($mdjm_event->ID, array('_mdjm_event_deposit_status' => 'Paid', '_mdjm_event_balance_status' => 'Paid'));
do_action('mdjm_post_mark_event_balance_paid', $event_id);
}
/**
* Format the playlist results for emailing/printing.
*
* @since 1.3
* @param int $event_id The event ID to retrieve the playlist for.
* @param str $orderby Which field to order the playlist entries by.
* @param str $order Order ASC or DESC.
* @param int $repeat_headers Repeat the table headers after this many rows.
* @param bool $hide_empty If displaying by category do we hide empty categories?
* @return str $results Output of playlist entries.
*/
function mdjm_format_playlist_content($event_id, $orderby = 'category', $order = 'ASC', $hide_empty = true, $repeat_headers = 0)
{
global $current_user;
$mdjm_event = mdjm_get_event($event_id);
// Obtain results ordered by category
if ($orderby == 'category') {
$playlist = mdjm_get_playlist_by_category($event_id, array('hide_empty' => $hide_empty));
if ($playlist) {
foreach ($playlist as $cat => $entries) {
foreach ($entries as $entry) {
$entry_data = mdjm_get_playlist_entry_data($entry->ID);
$results[] = array('ID' => $entry->ID, 'event' => $event_id, 'artist' => stripslashes($entry_data['artist']), 'song' => stripslashes($entry_data['song']), 'added_by' => stripslashes($entry_data['added_by']), 'category' => $cat, 'notes' => stripslashes($entry_data['djnotes']), 'date' => mdjm_format_short_date($entry->post_date));
}
}
}
} else {
$args = array('orderby' => $orderby == 'date' ? 'post_date' : 'meta_value', 'order' => $order, 'meta_key' => $orderby == 'date' ? '' : '_mdjm_playlist_entry_' . $orderby);
$entries = mdjm_get_playlist_entries($event_id, $args);
if ($entries) {
foreach ($entries as $entry) {
$entry_data = mdjm_get_playlist_entry_data($entry->ID);
$categories = wp_get_object_terms($entry->ID, 'playlist-category');
if (!empty($categories)) {
$category = $categories[0]->name;
}
$results[] = array('ID' => $entry->ID, 'event' => $event_id, 'artist' => stripslashes($entry_data['artist']), 'song' => stripslashes($entry_data['song']), 'added_by' => stripslashes($entry_data['added_by']), 'category' => !empty($category) ? $category : '', 'notes' => stripslashes($entry_data['djnotes']), 'date' => mdjm_format_short_date($entry->post_date));
}
}
}
// Build out the formatted display
if (!empty($results)) {
$i = 0;
$output = '<p>' . sprintf(__('Hey %s', 'mobile-dj-manager'), $current_user->first_name) . '</p>' . "\n";
$output .= '<p>' . __('Here is the playlist you requested...', 'mobile-dj-manager') . '</p>' . "\n";
$output .= '<p>' . __('Client Name', 'mobile-dj-manager') . ': ' . mdjm_get_client_display_name($mdjm_event->client) . '<br />' . "\n" . __('Event Date', 'mobile-dj-manager') . ': ' . mdjm_get_event_long_date($mdjm_event->ID) . '<br />' . "\n" . __('Event Type', 'mobile-dj-manager') . ': ' . mdjm_get_event_type($mdjm_event->ID) . '<br />' . "\n" . __('Songs in Playlist', 'mobile-dj-manager') . ': ' . count($results) . '<br />' . "\n" . '</p>';
$output .= '<hr />' . "\n";
$headers = '<tr style="height: 30px">' . "\n" . '<td style="width: 15%"><strong>' . __('Song', 'mobile-dj-manager') . '</strong></td>' . "\n" . '<td style="width: 15%"><strong>' . __('Artist', 'mobile-dj-manager') . '</strong></td>' . "\n" . '<td style="width: 15%"><strong>' . __('Category', 'mobile-dj-manager') . '</strong></td>' . "\n" . '<td style="width: 40%"><strong>' . __('Notes', 'mobile-dj-manager') . '</strong></td>' . "\n" . '<td style="width: 15%"><strong>' . __('Added By', 'mobile-dj-manager') . '</strong></td>' . "\n" . '</tr>' . "\n";
$output .= '<table width="90%" border="0" cellpadding="0" cellspacing="0">' . "\n";
$output .= $headers;
foreach ($results as $result) {
if ($repeat_headers > 0 && $i == $repeat_headers) {
$output .= '<tr>' . "\n" . '<td colspan="5"> </td>' . "\n" . '</tr>' . "\n" . $headers;
$i = 0;
}
if (is_numeric($result['added_by'])) {
$user = get_userdata($result['added_by']);
$name = $user->display_name;
} else {
$name = $result['added_by'];
}
$output .= '<tr>' . "\n" . '<td>' . stripslashes($result['song']) . '</td>' . "\n" . '<td>' . stripslashes($result['artist']) . '</td>' . "\n" . '<td>' . stripslashes($result['category']) . '</td>' . "\n" . '<td>' . stripslashes($result['notes']) . '</td>' . "\n" . '<td>' . stripslashes($name) . '</td>' . "\n" . '</tr>' . "\n";
$i++;
}
$output .= '</table>' . "\n";
} else {
$output = '<p>' . __('The playlist for this event does not contain any entries!', 'mobile-dj-manager') . '</p>' . "\n";
}
return $output;
}
