Add Button in WooCommerce Order Detail Email

Add a button in the order details email by passing orderID and productID in the button link to a new page

<?php
/**
 * Order details table shown in emails.
 *
 * This template can be overridden by copying it to yourtheme/woocommerce/emails/email-order-details.php.
 *
 * HOWEVER, on occasion WooCommerce will need to update template files and you
 * (the theme developer) will need to copy the new files to your theme to
 * maintain compatibility. We try to do this as little as possible, but it does
 * happen. When this occurs the version of the template file will be bumped and
 * the readme will list any important changes.
 *
 * @see https://docs.woocommerce.com/document/template-structure/
 * @package WooCommerce\Templates\Emails
 * @version 3.7.0
 */

defined( 'ABSPATH' ) || exit;

$text_align = is_rtl() ? 'right' : 'left';

do_action( 'woocommerce_email_before_order_table', $order, $sent_to_admin, $plain_text, $email ); 


//Get the products in the order
$order_items = $order->get_items( apply_filters( 'woocommerce_purchase_order_item_types', 'line_item' ) );

//Global variables
$product_id = "";
$order_id = "";

?>

   <style> 
      .myButton{ 
          padding: 14px 28px; 
          background-color: #C1666B; 
          text-align: center; 
          color: white; 
          border-radius: 8px;
          border: 0px; 
          color: #fff;           
      } 
      .myButton:hover{ 
          background-color: #1a5fc4; 
          color: #fff; 
          
      } 
      </style>

<h2>
	<?php
	if ( $sent_to_admin ) {
		$before = '<a class="link" href="' . esc_url( $order->get_edit_order_url() ) . '">';
		$after  = '</a>';
	} else {
		$before = '';
		$after  = '';
	}
	/* translators: %s: Order ID. */
	echo wp_kses_post( $before . sprintf( __( '[Order #%s]', 'woocommerce' ) . $after . ' (<time datetime="%s">%s</time>)', $order->get_order_number(), $order->get_date_created()->format( 'c' ), wc_format_datetime( $order->get_date_created() ) ) );
	?>
</h2>

<div style="margin-bottom: 40px;">
	<table class="td" cellspacing="0" cellpadding="6" style="width: 100%; font-family: 'Helvetica Neue', Helvetica, Roboto, Arial, sans-serif;" border="1">
		<thead>
			<tr>
				<th class="td" scope="col" style="text-align:<?php echo esc_attr( $text_align ); ?>;"><?php esc_html_e( 'Product', 'woocommerce' ); ?></th>
				<th class="td" scope="col" style="text-align:<?php echo esc_attr( $text_align ); ?>;"><?php esc_html_e( 'Quantity', 'woocommerce' ); ?></th>
				<th class="td" scope="col" style="text-align:<?php echo esc_attr( $text_align ); ?>;"><?php esc_html_e( 'Price', 'woocommerce' ); ?></th>
			</tr>
		</thead>
		<tbody>
<?php
//Iterating products
foreach ( $order_items as $item_id => $item ) {
    $product = $item->get_product();
    $product_id = $product->get_id();
    $order_id = $item['order_id'];
			}
			//
			
			echo wc_get_email_order_items( // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped
		$order,
		array(
	      'show_sku'      => $sent_to_admin,
	      'show_image'    => false,
	      'image_size'    => array( 32, 32 ),
		'plain_text'    => $plain_text,
		'sent_to_admin' => $sent_to_admin,
				)
			);
			?>
		</tbody>
		<tfoot>
			<?php
			$item_totals = $order->get_order_item_totals();

			if ( $item_totals ) {
				$i = 0;
				foreach ( $item_totals as $total ) {
					$i++;
					?>
					<tr>
						<th class="td" scope="row" colspan="2" style="text-align:<?php echo esc_attr( $text_align ); ?>; <?php echo ( 1 === $i ) ? 'border-top-width: 4px;' : ''; ?>"><?php echo wp_kses_post( $total['label'] ); ?></th>
						<td class="td" style="text-align:<?php echo esc_attr( $text_align ); ?>; <?php echo ( 1 === $i ) ? 'border-top-width: 4px;' : ''; ?>"><?php echo wp_kses_post( $total['value'] ); ?></td>
					</tr>
					<?php
				}
			}
			if ( $order->get_customer_note() ) {
				?>
				<tr>
					<th class="td" scope="row" colspan="2" style="text-align:<?php echo esc_attr( $text_align ); ?>;"><?php esc_html_e( 'Note:', 'woocommerce' ); ?></th>
					<td class="td" style="text-align:<?php echo esc_attr( $text_align ); ?>;"><?php echo wp_kses_post( nl2br( wptexturize( $order->get_customer_note() ) ) ); ?></td>
				</tr>
				<?php
			}
			?>
		</tfoot>
	</table>
<!-- VISUALIZZO PULSANTI -->
<section style="text-align: center; margin-top: 34px">
    	
    	   	<?php  
    	if($ServiceType == "Pratica"){
    	
    	$link = "https://www.yoursite.it/your-page/?orderID=".$order_id."&productID=".$product_id
    	?>
    	
    	<p>YOUR EMAIL TEXT</p>
    	
    	    <a
    	         href= <?php echo $link?>
    	   type="button"
    	    class="myButton">
    	        YOUR TEXT BUTTON</a>
    	        
    	        	<p style="margin-top: 21px">Se hai bisogno di aiuto, puoi inviare un email su</p>
    	        	<a href="mailto:info@yoursite.it">info@yoursite.it</a>
    	<?php 	}?>
    
</section>

</div>

<?php do_action( 'woocommerce_email_after_order_table', $order, $sent_to_admin, $plain_text, $email ); ?>

Create CSV file with data from another CSV and from a JSON file

123456789,Markroc
213243546,Ferththas
435465657,Vellwerd
657483920,Roc
987654367,Conorah
549023565,Rocric
569028494,Do
768494893,Wardethel
756389574,Stanguth
564757485,Lafjohn
877589584,Mann-mac
575848584,Bandoald
575848685,Nethcla
839483958,Niel-sara
575493854,Thoann
728458395,Helmley
[
  {
    "_id": "5e637643b1bda0806a485ebe",
    "age": 31,
    "email": "gaysmith@nikuda.com",
    "address": "238 Grimes Road, Sandston, Idaho, 1847",
    "friends": [
      {
        "id": 0,
        "name": "Emilia Tyson"
      },
      {
        "id": 1,
        "name": "Gibson Kirkland"
      },
      {
        "id": 2,
        "name": "Everett Ferrell"
      }
    ]
  },
  {
    "_id": "5e637643ef9baa2fabbae262",
    "age": 22,
    "email": "everettferrell@nikuda.com",
    "address": "121 Furman Street, Tooleville, Kansas, 1989",
    "friends": [
      {
        "id": 0,
        "name": "Case Jefferson"
      },
      {
        "id": 1,
        "name": "Henderson Delacruz"
      },
      {
        "id": 2,
        "name": "Delia Morrow"
      }
    ]
  },
  {
    "_id": "5e637643b74c487d86a47ce3",
    "age": 26,
    "email": "deliamorrow@nikuda.com",
    "address": "220 Hegeman Avenue, Interlochen, Colorado, 668",
    "friends": [
      {
        "id": 0,
        "name": "Earnestine Meyer"
      },
      {
        "id": 1,
        "name": "Bethany Nixon"
      },
      {
        "id": 2,
        "name": "Dixie Carver"
      }
    ]
  },
  {
    "_id": "5e637643dbd01881c5990425",
    "age": 40,
    "email": "dixiecarver@nikuda.com",
    "address": "716 Benson Avenue, Robinson, Massachusetts, 9444",
    "friends": [
      {
        "id": 0,
        "name": "Contreras Mccormick"
      },
      {
        "id": 1,
        "name": "Lindsay Bond"
      },
      {
        "id": 2,
        "name": "Key Richard"
      }
    ]
  },
  {
    "_id": "5e6376433a30bffc7ca1ce01",
    "age": 34,
    "email": "keyrichard@nikuda.com",
    "address": "478 Thomas Street, Calpine, Guam, 1121",
    "friends": [
      {
        "id": 0,
        "name": "Mitzi Avila"
      },
      {
        "id": 1,
        "name": "Marci Beach"
      },
      {
        "id": 2,
        "name": "Angeline Davis"
      }
    ]
  },
  {
    "_id": "5e637643e09566e263912eab",
    "age": 21,
    "email": "angelinedavis@nikuda.com",
    "address": "106 Kimball Street, Vale, Arkansas, 8438",
    "friends": [
      {
        "id": 0,
        "name": "Bradford Christian"
      },
      {
        "id": 1,
        "name": "Carly Nash"
      },
      {
        "id": 2,
        "name": "Riggs Hicks"
      }
    ]
  }
]
<?php
        //Show Error Code
        ini_set('display_errors', 1);
        ini_set('display_startup_errors', 1);
        error_reporting(E_ALL);

        //Read file JSON and CSV
        $json = file_get_contents('dataUsers.json');
        $file = fopen("contact.csv", "r");

        //Decode JSON
        $arrayJSON = json_decode($json, true);

        //Create Result Data Class
        class Result {
            public $item_id;
            public $name;
            public $age;
            public $email;
            public $address;
            public $bestFriend;
            public $date;
        }

        //Create Result Data Array 
        $resultData= array();

        //Iterate CSV
        while (($row = fgetcsv($file, 0, ",")) !== FALSE) {

            //Iterate JSON
            foreach($arrayJSON as $obj){

                //Create result new object
                $myResult = new Result();
                
                //Read Data CSV
                $myResult->item_id = $row[0]; // ID
                $myResult->name = $row[1];  //Namee

                //Read Data JSON
                $myResult->age = $obj['age'];
                $myResult->email = $obj['email'];
                $myResult->address = $obj['address'];
                $myResult->address = $obj['friends'][0]['name'];

                //New value
                $myResult->date = new DateTime();
    
                //Add object created into array
                array_push($resultData, $myResult);
            }
        }     

        //Show results
        echo(json_encode($resultData));

        //Create file Results CSV
        $fp = fopen('result.csv', 'wb');
        foreach ($resultData as $obj) {
            fputcsv($fp, (array) $obj);
        }
        fclose($fp); 
?>