<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<!-- Favicon icon -->
	<link rel="icon" type="image/png" sizes="16x16" href="assets/<?php echo $core->favicon ?>">
	<title>Shipment print</title>
	<link type='text/css' href='assets/css/label_custom.css' rel='stylesheet' />

</head>

<body onload="window.print();">
	<div id="page-wrap">

		<?php

		$userData = $user->cdp_getUserData();

		require_once('helpers/querys.php');

		if (!isset($_GET['data'])) {

			cdp_redirect_to("courier_list.php");
		}


		if (isset($_GET['data'])) {

			$data = json_decode($_GET['data']);

			foreach ($data as $key) {

				$data_key = cdp_getCourierPrintMultiple($key);


				$row = $data_key['data'];



				$db->cdp_query("SELECT * FROM cdb_users where id= '" . $row->sender_id . "'");
				$sender_data = $db->cdp_registro();

				$db->cdp_query("SELECT * FROM cdb_users where id= '" . $row->receiver_id . "'");
				$receiver_data = $db->cdp_registro();




				$db->cdp_query("SELECT * FROM cdb_address_shipments where order_track='" . $row->order_prefix . $row->order_no . "'");
				$address_order = $db->cdp_registro();


				$db->cdp_query("SELECT * FROM cdb_courier_com where id= '" . $row->order_courier . "'");
				$courier_com = $db->cdp_registro();

				$db->cdp_query("SELECT * FROM cdb_met_payment where id= '" . $row->order_pay_mode . "'");
				$met_payment = $db->cdp_registro();

				$db->cdp_query("SELECT * FROM cdb_shipping_mode where id= '" . $row->order_service_options . "'");
				$order_service_options = $db->cdp_registro();



				// total shipping cost
				$total = $row->total_order;
				$total = cdb_money_format_bar($total);


				$db->cdp_query("SELECT SUM(order_item_length) as total0 from cdb_add_order_item where order_id='" . $row->order_id . "'");
				$db->cdp_execute();
				$row0 = $db->cdp_registro();

				$rw_add0 = $row0->total0;


				// volumetric query of the box width

				$db->cdp_query("SELECT SUM(order_item_width) as total1 from cdb_add_order_item where order_id='" . $row->order_id . "'");
				$db->cdp_execute();
				$row1 = $db->cdp_registro();

				$rw_add1 = $row1->total1;

				// volumetric query of the box width

				$db->cdp_query("SELECT SUM(order_item_height) as total2 from cdb_add_order_item where order_id='" . $row->order_id . "'");
				$db->cdp_execute();
				$row2 = $db->cdp_registro();

				$rw_add2 = $row2->total2;

				$db->cdp_query("SELECT SUM(order_item_height) as total3 from cdb_add_order_item where order_id='" . $row->order_id . "'");
				$db->cdp_execute();
				$row3 = $db->cdp_registro();

				$rw_add3 = $row3->total3;

				$length = $rw_add0; //Length
				$width = $rw_add1; //Width
				$height = $rw_add2; //Height

				if ($row->volumetric_percentage) {
					$volumetric_percentage = $row->volumetric_percentage;
				} else {

					$volumetric_percentage = $core->meter;
				}
				$total_metric = $length * $width * $height / $volumetric_percentage;


				$db->cdp_query("SELECT * FROM cdb_add_order_item WHERE order_id='" . $row->order_id . "'");
				$order_items = $db->cdp_registros();



				$sumador_libras = 0;
				$sumador_volumetric = 0;
				$count = 0;
				foreach ($order_items as $row_item) {

					$weight_item = $row_item->order_item_weight;

					$total_metric = $row_item->order_item_length * $row_item->order_item_width * $row_item->order_item_height / $volumetric_percentage;

					// calculate weight x price
					if ($weight_item > $total_metric) {

						$calculate_weight = $weight_item;
						$sumador_libras += $weight_item; //Sumador

					} else {

						$calculate_weight = $total_metric;
						$sumador_volumetric += $total_metric; //Sumador
					}

					$count++;
				}

		?>


				<div class="container_etiqueta" style="min-height: 540px; max-height: 540px; min-width: 420px; max-width: 420px;">
					<div class="print_ticket_zebra" style="max-height: 110px; min-height: 110px;">
						<div style="width: 30%;line-height:110px;margin:0px auto;text-align:center;">

						<?php echo ($core->logo) ? '<img src="assets/uploads/galeyr.png"/>' : $core->site_name; ?>
						</div>
						<div style="width: 70%;">
							<strong><?php echo $core->site_name; ?><br></strong>

							<?php echo $core->c_country; ?>, <?php echo $core->c_city; ?>, <?php echo $core->c_postal; ?>.<br>
							TEL: <?php echo $core->c_phone; ?>
						</div>
					</div>
					<div class="app_print_ticket_zebra" style="margin-top: -18px; height: 100px; max-width: 420px; margin-left: 22px">
						<img style="width: 380px; min-height: 100px; max-height: 100px;" src='https://barcode.tec-it.com/barcode.ashx?data=<?php echo $row->order_prefix . $row->order_no; ?>&code=EANUCC128&multiplebarcodes=false&translate-esc=true&unit=Fit&dpi=96&imagetype=Gif&rotation=0&color=%23000000&bgcolor=%23ffffff&qunit=Mm&quiet=0' alt='' />
					</div>
					<div class="app_easypack_ticket_zebra" style="padding-top:50px; max-width: 420px; text-align: center">
						<div class="track_courier"><strong> <?php echo $row->order_prefix . $row->order_no; ?></strong></div>
					</div>
					<div class="app_easypack_print" style="padding-top: 5px;font-weight: bold">
						<div>Package ref: &nbsp;</div>
						<div>&nbsp;</div>
					</div>
					<div class="datas_easypack_print">
						<div>Date: &nbsp;<?php echo $row->order_date; ?> &nbsp;|&nbsp;Qnty: &nbsp;<?php echo $count; ?>&nbsp;|&nbsp;W: &nbsp;
							<?php if ($sumador_libras > $sumador_volumetric) {
								echo  cdp_round_out($sumador_libras);
							} else {
								echo cdp_round_out($sumador_volumetric);
							} ?>&nbsp;|&nbsp;USFOB: &nbsp;<?php echo $row->total_order; ?> </div>
					</div>
					<div class="app_easypack_print">
						<div><strong>REF. SERVICE: </strong>&nbsp;</div>
						<div><?php if ($order_service_options) {
									echo $order_service_options->ship_mode;
								} ?> </div>
					</div>
					<div class="app_easypack_ticket_zebra" style="padding-top: 3px; padding-bottom: 3px; font-size: 22px; max-height: 18px; min-height: 25px;">
						<strong><?php echo $met_payment->name_pay; ?></strong>
					</div>
					<br>
					<div class="app_easypack_ticket_zebra" style="font-size: 37px; margin-top: 1px; margin-left: 0px; ">
						<strong><?php echo $address_order->recipient_country . " - " . $address_order->recipient_city; ?></strong>
					</div>
					<div class="app_easypack_qr_code" style="max-height: 110px; min-height: 110px;">
						<div style="width: 30%;">
							<img src='https://barcode.tec-it.com/barcode.ashx?data=Tracking:+<?php echo $row->order_prefix . $row->order_no; ?>&code=QRCode&multiplebarcodes=false&translate-esc=false&unit=Fit&dpi=72&imagetype=Gif&rotation=0&color=%23000000&bgcolor=%23ffffff&qunit=Mm&quiet=0&eclevel=L' alt='' />
						</div>
						<div style="width: 70%;">
							<?php echo $receiver_data->fname; ?> <?php echo $receiver_data->lname; ?> <br>
							<?php echo $address_order->recipient_address . " <br> " . $receiver_data->phone; ?>
						</div>
					</div>
				</div>

				<br><br><br><br><br><br><br>


		<?php
			}
		} ?>

	</div>
</body>

</html>