/**
* Get the chart for this report.
*
* @since 1.0
*
* @param string $date_type
* @param int $product
*
* @return Base
*/
public function get_chart($date_type = 'this_year', $product = 0)
{
$start = date('Y-m-d H:i:s', $this->convert_date($date_type));
$end = date('Y-m-d H:i:s', $this->convert_date($date_type, true));
$grouping = self::get_grouping_for_date_type($date_type);
$sql = self::get_group_by($grouping, 'r.renewal_date');
$group = $sql['group'];
$per = $sql['per'];
if ($per) {
$per .= ' AS d, ';
}
if ($group) {
$group = "GROUP BY {$group}";
}
/**
* @var \wpdb $wpdb
*/
global $wpdb;
$rtn = Manager::get('itelic-renewals')->get_table_name($wpdb);
$ktn = Manager::get('itelic-keys')->get_table_name($wpdb);
if ($product) {
$raw = "SELECT {$per}SUM(revenue) as c FROM {$rtn} r JOIN {$ktn} k ON(k.lkey = r.lkey AND k.product = %d) WHERE r.renewal_date BETWEEN %s AND %s";
$raw .= $group;
$revenue = $wpdb->get_results($wpdb->prepare($raw, $product, $start, $end));
} else {
$raw = "SELECT {$per}SUM(revenue) as c FROM {$rtn} r WHERE r.renewal_date BETWEEN %s AND %s";
$raw .= $group;
$revenue = $wpdb->get_results($wpdb->prepare($raw, $start, $end));
}
$revenue = self::fill_gaps(self::translate_results($revenue), $start, $end, $grouping);
$labels = self::get_labels($revenue, $date_type);
$before = $after = '';
$settings = it_exchange_get_option('settings_general');
$currency = html_entity_decode(it_exchange_get_currency_symbol($settings['default-currency']));
if ('after' === $settings['currency-symbol-position']) {
$after = $currency;
} else {
$before = $currency;
}
$chart = new Line($labels, 600, 200, array('responsive' => true, 'tooltipTemplate' => "{$before}<%= value %>{$after}"));
$chart->add_data_set(array_values($revenue), __("Revenue", Plugin::SLUG), array('fillColor' => "rgba(140,197,62,0.2)", 'strokeColor' => "rgba(140,197,62,1)", 'pointColor' => "rgba(140,197,62,1)", 'pointStrokeColor' => "#fff", 'pointHighlightFill' => "#fff", 'pointHighlightStroke' => "rgba(140,197,62,1)"));
return $chart;
}
/**
* Render the page.
*
* @since 1.0
*/
public function render()
{
$df = it_exchange_php_date_format_to_jquery_datepicker_format(get_option('date_format'));
$options = it_exchange_get_option('settings_general');
$position = $options['currency-symbol-position'];
$decimals = $options['currency-decimals-separator'];
$thousands = $options['currency-thousands-separator'];
$symbol = it_exchange_get_currency_symbol($options['default-currency']);
$form = \ITUtility::merge_defaults($_POST, array('product' => '', 'customer' => '', 'username' => '', 'email' => '', 'first' => '', 'last' => '', 'activations' => '', 'expiration' => '', 'license' => '', 'paid' => '', 'customer-type' => 'existing'));
?>
<form method="POST" action="<?php
echo esc_attr(add_query_arg('view', 'add-new', Dispatch::get_tab_link('licenses')));
?>
">
<div class="main-editor">
<?php
do_action('itelic_add_new_license_screen_before_steps');
?>
<ol>
<?php
do_action('itelic_add_new_license_screen_begin_steps');
?>
<li>
<label for="product"><?php
_e("Select a Product", Plugin::SLUG);
?>
</label>
<div class="product-container">
<select id="product" name="product">
<?php
foreach ($this->products as $product) {
?>
<option value="<?php
echo $product->ID;
?>
" <?php
selected($form['product'], $product->ID);
?>
>
<?php
echo $product->post_title;
?>
</option>
<?php
}
?>
</select>
</div>
</li>
<li>
<fieldset id="customer-type">
<label><?php
_e("Select a Customer", Plugin::SLUG);
?>
</label>
<div class="new-customer-container">
<p>
<input type="radio" id="new-customer" name="customer-type" value="new" <?php
checked($form['customer-type'], 'new');
?>
>
<label for="new-customer"><?php
_e("New Customer", Plugin::SLUG);
?>
</label>
</p>
</div>
<div class="existing-customer-container">
<p>
<input type="radio" id="existing-customer" name="customer-type" value="existing" <?php
checked($form['customer-type'], 'existing');
?>
>
<label for="existing-customer"><?php
_e("Existing Customer", Plugin::SLUG);
?>
</label>
</p>
</div>
</fieldset>
<fieldset class="new-customer-form <?php
echo $form['customer-type'] == 'new' ? '' : 'hide-if-js';
?>
">
<p>
<label for="username"><?php
_e("Username", Plugin::SLUG);
?>
</label>
<input type="text" id="username" name="username" value="<?php
echo $form['username'];
?>
">
</p>
<p>
<label for="email"><?php
_e("Email", Plugin::SLUG);
?>
</label>
<input type="email" id="email" name="email" value="<?php
echo $form['email'];
?>
">
</p>
<p>
<label for="first"><?php
_e("First Name", Plugin::SLUG);
?>
</label>
<input type="text" id="first" name="first" value="<?php
echo $form['first'];
?>
">
</p>
<p>
<label for="last"><?php
_e("Last Name", Plugin::SLUG);
?>
</label>
<input type="text" id="last" name="last" value="<?php
echo $form['last'];
?>
">
</p>
</fieldset>
<fieldset class="existing-customer-form <?php
echo $form['customer-type'] == 'existing' ? '' : 'hide-if-js';
?>
">
<p>
<label for="customer" class="screen-reader-text"><?php
_e('Customer', Plugin::SLUG);
?>
</label>
<select id="customer" name="customer">
<?php
foreach (get_users() as $user) {
?>
<option value="<?php
echo $user->ID;
?>
" <?php
selected($form['customer'], $user->ID);
?>
>
<?php
echo $user->user_login;
?>
</option>
<?php
}
?>
</select>
</p>
</fieldset>
</li>
<li>
<div class="activations-container">
<label for="activations"><?php
_e("Activation Limit", Plugin::SLUG);
?>
</label>
<input type="number" id="activations" name="activations" min="0" value="<?php
echo $form['activations'];
?>
">
<p class="description"><?php
_e("Leave blank for unlimited activations.");
?>
</p>
</div>
</li>
<li>
<div class="expiration-container">
<label for="expiration"><?php
_e("Expiration Date", Plugin::SLUG);
?>
</label>
<input type="date" id="expiration" name="expiration" value="<?php
echo $form['expiration'];
?>
" data-format="<?php
echo esc_attr($df);
?>
">
</div>
</li>
<li>
<div class="key-container">
<label for="license"><?php
_e('License Key', Plugin::SLUG);
?>
</label>
<p>
<a href="javascript:" id="trigger-manual-key" class="<?php
echo empty($form['license']) ? '' : 'hide-if-js';
?>
">
<?php
_e("Set the license key manually.", Plugin::SLUG);
?>
</a>
<a href="javascript:" id="trigger-automatic-key" class="<?php
echo empty($form['license']) ? 'hide-if-js' : '';
?>
">
<?php
_e("Let Exchange automatically generate a license key for you.", Plugin::SLUG);
?>
</a>
</p>
<input type="text" name="license" id="license" value="<?php
echo $form['license'];
?>
" class="<?php
echo empty($form['license']) ? 'hide-if-js' : '';
?>
">
</div>
</li>
<li>
<div class="paid-container">
<label for="paid"><?php
_e("Amount Paid", Plugin::SLUG);
?>
</label>
<input type="text" name="paid" id="paid" value="<?php
echo $form['paid'];
?>
"
data-symbol="<?php
echo $symbol;
?>
" data-symbol-position="<?php
echo $position;
?>
"
data-thousands-separator="<?php
echo $thousands;
?>
"
data-decimals-separator="<?php
echo $decimals;
?>
">
</div>
</li>
<?php
do_action('itelic_add_new_license_screen_end_steps');
?>
</ol>
<?php
do_action('itelic_add_new_license_screen_after_steps');
?>
<p class="buttons">
<?php
submit_button(__("Create", Plugin::SLUG), 'primary', 'itelic-add-new-key', false);
?>
</p>
</div>
<?php
wp_nonce_field('itelic-add-new-key');
?>
</form>
<?php
}