示例#1
0
function web_invoice_get_single_invoice_status($invoice_id)
{
    // in class
    global $wpdb;
    if ($status_update = $wpdb->get_row("SELECT * FROM " . Web_Invoice::tablename('log') . " WHERE invoice_id = {$invoice_id} ORDER BY `" . Web_Invoice::tablename('log') . "`.`time_stamp` DESC LIMIT 0 , 1")) {
        return $status_update->value . " - " . web_invoice_Date::convert($status_update->time_stamp, 'Y-m-d H', __('M d Y'));
    }
}
示例#2
0
 function display($what)
 {
     global $_web_invoice_clear_cache, $wpdb;
     if (!$this->_row_cache || $_web_invoice_clear_cache) {
         $this->_setRowCache($wpdb->get_row("SELECT * FROM " . Web_Invoice::tablename('main') . " WHERE invoice_num = '{$this->id}'"));
         $_web_invoice_clear_cache = false;
     }
     $invoice_info = $this->_row_cache;
     switch ($what) {
         case 'log_status':
             if ($status_update = $wpdb->get_row("SELECT * FROM " . Web_Invoice::tablename('log') . " WHERE invoice_id = " . $this->id . " ORDER BY `" . Web_Invoice::tablename('log') . "`.`time_stamp` DESC LIMIT 0 , 1")) {
                 return $status_update->value . " - " . web_invoice_Date::convert($status_update->time_stamp, 'Y-m-d H', __('M d Y', WEB_INVOICE_TRANS_DOMAIN));
             }
             break;
         case 'paid_date':
             $paid_date = $wpdb->get_var("SELECT time_stamp FROM  " . Web_Invoice::tablename('log') . " WHERE action_type = 'paid' AND invoice_id = '" . $this->id . "' ORDER BY time_stamp DESC LIMIT 0, 1");
             if ($paid_date) {
                 return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime(web_invoice_Date::convert($paid_date, 'Y-m-d H', __('M d Y', WEB_INVOICE_TRANS_DOMAIN))));
             }
             break;
         case 'paid_date_raw':
             $paid_date = $wpdb->get_var("SELECT time_stamp FROM  " . Web_Invoice::tablename('log') . " WHERE action_type = 'paid' AND invoice_id = '" . $this->id . "' ORDER BY time_stamp DESC LIMIT 0, 1");
             if ($paid_date) {
                 return $paid_date;
             }
             break;
         case 'subscription_name':
             return web_invoice_meta($this->id, 'web_invoice_subscription_name');
             break;
         case 'interval_length':
             return web_invoice_meta($this->id, 'web_invoice_subscription_length');
             break;
         case 'interval_unit':
             return web_invoice_meta($this->id, 'web_invoice_subscription_unit');
             break;
         case 'totalOccurrences':
             return web_invoice_meta($this->id, 'web_invoice_subscription_total_occurances');
             break;
         case 'installment':
             return web_invoice_meta($this->id, 'installment', 0);
             break;
         case 'startDate':
             $web_invoice_subscription_start_day = web_invoice_meta($this->id, 'web_invoice_subscription_start_day');
             $web_invoice_subscription_start_year = web_invoice_meta($this->id, 'web_invoice_subscription_start_year');
             $web_invoice_subscription_start_month = web_invoice_meta($this->id, 'web_invoice_subscription_start_month');
             if ($web_invoice_subscription_start_month && $web_invoice_subscription_start_year && $web_invoice_subscription_start_day && strtotime($web_invoice_subscription_start_year . "-" . $web_invoice_subscription_start_month . "-" . $web_invoice_subscription_start_day) > time()) {
                 return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime($web_invoice_subscription_start_year . "-" . $web_invoice_subscription_start_month . "-" . $web_invoice_subscription_start_day));
             } else {
                 return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), time() + 1800);
             }
             break;
         case 'endDate':
             return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime("+" . $this->display('interval_length') * $this->display('totalOccurrences') . " " . $this->display('interval_unit'), strtotime($this->display('startDateM'))));
             break;
         case 'nextDate':
             if ($this->display('totalOccurrences') > $this->display('installment')) {
                 if ($this->display('installment') == 0 && strtotime($this->display('startDateM')) >= strtotime($this->display('due_dateM'))) {
                     $start_date = $this->display('due_dateM');
                 } else {
                     $start_date = $this->display('startDateM');
                 }
                 return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime("+" . $this->display('interval_length') * $this->display('installment') . " " . $this->display('interval_unit'), strtotime($start_date)));
             }
             return $this->display('endDate');
             break;
         case 'startDateM':
             $web_invoice_subscription_start_day = web_invoice_meta($this->id, 'web_invoice_subscription_start_day');
             $web_invoice_subscription_start_year = web_invoice_meta($this->id, 'web_invoice_subscription_start_year');
             $web_invoice_subscription_start_month = web_invoice_meta($this->id, 'web_invoice_subscription_start_month');
             if ($web_invoice_subscription_start_month && $web_invoice_subscription_start_year && $web_invoice_subscription_start_day && strtotime($web_invoice_subscription_start_year . "-" . $web_invoice_subscription_start_month . "-" . $web_invoice_subscription_start_day) > time()) {
                 return date('Y-m-d', strtotime($web_invoice_subscription_start_year . "-" . $web_invoice_subscription_start_month . "-" . $web_invoice_subscription_start_day));
             } else {
                 return date('Y-m-d', time() + 1800);
             }
             break;
         case 'endDateM':
             return date('Y-m-d', strtotime("+" . $this->display('interval_length') * $this->display('totalOccurrences') . " " . $this->display('interval_unit'), strtotime($this->display('startDateM'))));
             break;
         case 'nextDateM':
             if ($this->display('totalOccurrences') > $this->display('installment')) {
                 if ($this->display('installment') == 0 && strtotime($this->display('startDateM')) >= strtotime($this->display('due_dateM'))) {
                     $start_date = $this->display('due_dateM');
                 } else {
                     $start_date = $this->display('startDateM');
                 }
                 return date('Y-m-d', strtotime("+" . $this->display('interval_length') * $this->display('installment') . " " . $this->display('interval_unit'), strtotime($start_date)));
             }
             return $this->display('endDate');
             break;
         case 'profileEndDate':
             return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime("+" . $this->display('interval_length') * ($this->display('totalOccurrences') - 1) . " " . $this->display('interval_unit'), strtotime($this->display('startDate')) + 3600 * 24));
             break;
         case 'archive_status':
             $result = $wpdb->get_col("SELECT action_type FROM  " . Web_Invoice::tablename('log') . " WHERE invoice_id = '" . $this->id . "' ORDER BY time_stamp DESC");
             foreach ($result as $event) {
                 if ($event == 'unarchive') {
                     return '';
                     break;
                 }
                 if ($event == 'archive') {
                     return 'archive';
                     break;
                 }
             }
             break;
         case 'display_billing_rate':
             $length = web_invoice_meta($this->id, 'web_invoice_subscription_length');
             $unit = web_invoice_meta($this->id, 'web_invoice_subscription_unit');
             $occurances = web_invoice_meta($this->id, 'web_invoice_subscription_total_occurances');
             // days
             if ($unit == "days") {
                 if ($length == '1') {
                     return "daily for {$occurances} days";
                 }
                 if ($length > '1') {
                     return "every {$length} days for a total of {$occurances} billing cycles";
                 }
             }
             //months
             if ($unit == "months") {
                 if ($length == '1') {
                     return "monthly for {$occurances} months";
                 }
                 if ($length > '1') {
                     return "every {$length} months {$occurances} times";
                 }
             }
             if ($unit == "years") {
                 if ($length == '1') {
                     return "annually for {$occurances} years";
                 }
                 if ($length > '1') {
                     return "every {$length} years {$occurances} times";
                 }
             }
             break;
         case 'link':
             $link_to_page = get_permalink(get_option('web_invoice_web_invoice_page'));
             $hashed = md5($this->id);
             if (get_option("permalink_structure")) {
                 return $link_to_page . "?invoice_id=" . $hashed;
             } else {
                 return $link_to_page . "&invoice_id=" . $hashed;
             }
             break;
         case 'invoice_hash':
             return md5($this->id);
             break;
         case 'print_link':
             return $this->display('link') . '&print=1';
             break;
         case 'hash':
             return md5($this->id);
             break;
         case 'currency':
             if (web_invoice_meta($this->id, 'web_invoice_currency_code') != '') {
                 $currency_code = web_invoice_meta($this->id, 'web_invoice_currency_code');
             } else {
                 if (get_option('web_invoice_default_currency_code') != '') {
                     $currency_code = get_option('web_invoice_default_currency_code');
                 } else {
                     $currency_code = "USD";
                 }
             }
             return $currency_code;
             break;
         case 'display_id':
             $web_invoice_custom_invoice_id = web_invoice_meta($this->id, 'web_invoice_custom_invoice_id');
             if (empty($web_invoice_custom_invoice_id)) {
                 return $this->id;
             } else {
                 return $web_invoice_custom_invoice_id;
             }
             break;
         case 'due_date':
             $web_invoice_due_date_month = web_invoice_meta($this->id, 'web_invoice_due_date_month');
             $web_invoice_due_date_year = web_invoice_meta($this->id, 'web_invoice_due_date_year');
             $web_invoice_due_date_day = web_invoice_meta($this->id, 'web_invoice_due_date_day');
             if (!empty($web_invoice_due_date_month) && !empty($web_invoice_due_date_year) && !empty($web_invoice_due_date_day)) {
                 return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime("{$web_invoice_due_date_year}-{$web_invoice_due_date_month}-{$web_invoice_due_date_day}"));
             }
             return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)));
             break;
         case 'due_dateM':
             $web_invoice_due_date_month = web_invoice_meta($this->id, 'web_invoice_due_date_month');
             $web_invoice_due_date_year = web_invoice_meta($this->id, 'web_invoice_due_date_year');
             $web_invoice_due_date_day = web_invoice_meta($this->id, 'web_invoice_due_date_day');
             if (!empty($web_invoice_due_date_month) && !empty($web_invoice_due_date_year) && !empty($web_invoice_due_date_day)) {
                 return date('Y-m-d', strtotime("{$web_invoice_due_date_year}-{$web_invoice_due_date_month}-{$web_invoice_due_date_day}"));
             }
             return date('Y-m-d');
             break;
         case 'invoice_date':
             if ($invoice_info && $invoice_info->invoice_date && !empty($invoice_info->invoice_date)) {
                 date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime($invoice_info->invoice_date));
             }
             return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)));
             break;
         case 'amount':
             return $invoice_info->amount;
             break;
         case 'due_amount':
             $payments = web_invoice_sum_payments($this->id);
             return max(0, $invoice_info->amount - $payments);
             break;
         case 'tax_percent':
             $_tax_values = unserialize(web_invoice_meta($this->id, 'tax_value'));
             if (is_array($_tax_values)) {
                 $_tax_value = 0;
                 foreach ($_tax_values as $_tax_valuex) {
                     $_tax_value += $_tax_valuex;
                 }
             } else {
                 $_tax_value = $_tax_values;
             }
             return $_tax_value;
             break;
         case 'tax_total':
             $_tax_values = unserialize(web_invoice_meta($this->id, 'tax_value'));
             if (is_array($_tax_values)) {
                 $_tax_value = 0;
                 foreach ($_tax_values as $_tax_valuex) {
                     $_tax_value += $_tax_valuex;
                 }
             } else {
                 $_tax_value = $_tax_values;
             }
             return $_tax_value * $invoice_info->amount;
             break;
         case 'subject':
             return $invoice_info->subject;
             break;
         case 'display_amount':
             return web_invoice_display_payment($this->display('currency'), $invoice_info->amount);
             break;
         case 'description':
             return str_replace("\n", "<br />", $invoice_info->description);
             break;
         case 'itemized':
             return unserialize(urldecode($invoice_info->itemized));
             break;
         case 'status':
             return $invoice_info->status;
             break;
         case 'trx_id':
             return web_invoice_payment_register($this->id, $this->display('amount'));
             break;
     }
 }