woocommerce - N.Ordine

// inserito in functions.php del tema


add_action('woocommerce_checkout_create_order', 'before_checkout_create_order', 20, 2);

function before_checkout_create_order( $order, $data ) {
    $payment_method=$order->get_payment_method();
    $status = $order->get_status();
    if ($payment_method != "cod" && $status == "pending" || $status == "cancelled")
            {
                $prefix = 'IP-';

                 $chiave = "finti";
                 $new_ordewr_id = update_number($chiave);

                 $new_order_id = $prefix.$new_ordewr_id;
            }else{
                 $chiave = "ordini";
                 $new_ordewr_id = update_number($chiave);

                 $new_order_id = $new_ordewr_id;
            }

     $order->update_meta_data( '_order_number', "$new_order_id" );

}



function update_number($tipo){
    global $wpdb;
    $progressivo = $wpdb->get_results("SELECT valore FROM progressivi WHERE chiave = '$tipo'");
    $val = $progressivo[0]->valore;
    $newval = $val+1;
    $wpdb->query( $wpdb->prepare("
        UPDATE progressivi
        SET valore = $newval
        WHERE chiave = '$tipo'")
    );


    return $newval;
}