listify_get_job_listing_price_job_id.php

function listify_get_job_listing_price_job_id( $job_id ) {
	global $wpdb;
	$order_itemmeta_sql = 'SELECT * FROM ' . 
	$wpdb->prefix . 'woocommerce_order_itemmeta WHERE 
	meta_key ="_job_id" AND meta_value=' .$job_id;

	$order_itemmeta_results = $wpdb->get_row( $order_itemmeta_sql , OBJECT );

	$order_items_sql = 'SELECT * FROM ' . 
	$wpdb->prefix . 'woocommerce_order_items WHERE 
	order_item_id =' .$order_itemmeta_results->order_item_id;

	$order_items_results = $wpdb->get_row( $order_items_sql , OBJECT );

	$order = new WC_Order( $order_items_results->order_id );
    $get_formatted_order_total = $order->get_formatted_order_total();


	return $get_formatted_order_total;
}