wpinv-gd-functions.php ➔ wpinv_tool_merge_invoices()

Complexity

Conditions	11
Paths	3

Size

Total Lines	59
Code Lines	37

Duplication

Lines	5
Ratio	8.47 %

Importance

Changes

0

<?php
function wpinv_tool_merge_invoices() {
    global $wpdb, $wpi_gdp_inv_merge, $wpi_tax_rates;
    
    $sql = "SELECT `gdi`.`id`, `gdi`.`date`, `gdi`.`date_updated` FROM `" . INVOICE_TABLE . "` AS gdi LEFT JOIN `" . $wpdb->posts . "` AS p ON `p`.`ID` = `gdi`.`invoice_id` AND `p`.`post_type` = 'wpi_invoice' WHERE `p`.`ID` IS NULL ORDER BY `gdi`.`id` ASC";

    $items = $wpdb->get_results( $sql );
    
    $count = 0;
    
    if ( !empty( $items ) ) {
        $success = true;
        $wpi_gdp_inv_merge = true;
        
        foreach ( $items as $item ) {
            $wpi_tax_rates = NULL;
            
            $wpdb->query( "UPDATE `" . INVOICE_TABLE . "` SET `invoice_id` = 0 WHERE id = '" . $item->id . "'" );
            
            $merged = wpinv_cpt_save( $item->id );
            
            if ( !empty( $merged ) && !empty( $merged->ID ) ) {
                $count++;
                
                $post_date = !empty( $item->date ) && $item->date != '0000-00-00 00:00:00' ? $item->date : current_time( 'mysql' );
                $post_date_gmt = get_gmt_from_date( $post_date );
                $post_modified = !empty( $item->date_updated ) && $item->date_updated != '0000-00-00 00:00:00' ? $item->date_updated : $post_date;
                $post_modified_gmt = get_gmt_from_date( $post_modified );
                
                $wpdb->update( $wpdb->posts, array( 'post_date' => $post_date, 'post_date_gmt' => $post_date_gmt, 'post_modified' => $post_modified, 'post_modified_gmt' => $post_modified_gmt ), array( 'ID' => $merged->ID ) );
                
                if ( $merged->is_paid() ) {
                    update_post_meta( $merged->ID, '_wpinv_completed_date', $post_modified );
                }
                
                clean_post_cache( $merged->ID );
                
                wpinv_error_log( 'Invoice merge S : ' . $item->id . ' => ' . $merged->ID );
            } else {
                wpinv_error_log( 'Invoice merge F : ' . $item->id );
            }
        }
        
        $wpi_gdp_inv_merge = false;
        
        if ( $count > 0 ) {
            $message = sprintf( _n( 'Total <b>%d</b> invoice is merged successfully.', 'Total <b>%d</b> invoices are merged successfully.', $count, 'invoicing' ), $count );
        } else {
            $message = __( 'No invoices merged.', 'invoicing' );
        }
    } else {
        $success = false;
        $message = __( 'No invoices found to merge!', 'invoicing' );
    }
    
    $response = array();
    $response['success'] = $success;
    $response['data']['message'] = $message;
    wp_send_json( $response );
}
add_action( 'wpinv_tool_merge_invoices', 'wpinv_tool_merge_invoices' );
add_action( 'wpinv_subscription_cancelled', 'wpinv_wpi_to_gdp_handle_subscription_cancel', 10, 2 );