yosoyhendrix
/
Module-Simple-billing
mirror of https://github.com/OpenGamePanel/Module-Simple-billing


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152
							<?php
function exec_ogp_module()
{
	//Include database connection details
	require('includes/config.inc.php');

	global $db,$view,$settings;
	if(isset($_GET['type']) && $_GET['type'] == 'cleared')
	{
		echo '<body onload="window.print()" >';
		$view->setCharset(get_lang('lang_charset'));
	}	

	$user_id = $_SESSION['user_id'];
	$cart_id = $_POST['cart_id'];
	$cart_id = $db->realEscapeSingle($cart_id);
	$isAdmin = $db->isAdmin( $_SESSION['user_id'] );
	if ( $isAdmin )
		$orders = $db->resultQuery( "SELECT * FROM OGP_DB_PREFIXbilling_orders WHERE cart_id=".$db->realEscapeSingle($cart_id) );
	else
		$orders = $db->resultQuery( "SELECT * FROM OGP_DB_PREFIXbilling_orders WHERE cart_id=".$db->realEscapeSingle($cart_id)." AND user_id=".$db->realEscapeSingle($user_id) );
		
	$cart = $db->resultQuery( "SELECT * FROM OGP_DB_PREFIXbilling_carts WHERE cart_id=".$db->realEscapeSingle($cart_id) );
			
	if( !empty($orders) )
	{
		?>
		<br><br>
		<table width="772" height="438" border="0" style="color:#000000" bgcolor="#FFFFFF">
			  <tr bgcolor="#000000">
				<td colspan="5" align="center"  style="color:white">
					<p style="font-size:18pt"><b><?php print_lang("invoice");?></b></p>
				</td>
			  </tr>
			  <tr>
				<td height="21" colspan="5">&nbsp;</td>
			  </tr>
			  <tr>
				<td width="150" height="21" align="left"><?php print_lang("business");?>:<br><b><?php  echo "<b>".$settings['panel_name']."</b>"; ?></td>
				<td colspan="2" rowspan="3">&nbsp;</td>
				<td colspan="2" rowspan="3"><img width="300" height="100" src="images/banner.gif"></td>
			  </tr>
			  <tr>
				<td width="150" height="21" align="left"><?php print_lang("business_email");?>:<br><?php  echo "<b>".$settings['panel_email_address']."</b>"; ?></td>
			  </tr>
			  <tr>
				<td height="23" colspan="5">&nbsp;</td>
			  </tr>
			  <tr>
				<td height="23" style="border: 2px solid #000000" bgcolor="#CCCCCC"><div align="center"><strong><?php print_lang("item");?></strong></div></td>
				<td width="150" style="border: 2px solid #000000" bgcolor="#CCCCCC"><div align="center"><strong><?php print_lang("invoice_duration");?></strong></div></td>
				<td width="150" style="border: 2px solid #000000" bgcolor="#CCCCCC"><div align="center"><strong><?php print_lang("slot_cost");?></strong></div></td>
				<td style="border: 2px solid #000000" bgcolor="#CCCCCC"><div align="center"><strong><?php print_lang("slot_quantity");?></strong></div></td>
				<td style="border: 2px solid #000000" bgcolor="#CCCCCC"><div align="center"><strong><?php print_lang("order_price");?></strong></div></td>
			  </tr>
		<?php
		$subtotal = 0;		
		foreach($orders as $order)
		{
			$order_id = $order['order_id'];
			$user_id = $order['user_id'];
			$service_id = $order['service_id'];
			$home_name = $order['home_name']." - ".$order_id;
			$ip = $order['ip'];
			$max_players = $order['max_players'];
			$qty = $order['qty'];
			$invoice_duration = $order['invoice_duration'];
			$price = $order['price'];
			$subtotal += $price;
			$qry_service = "SELECT DISTINCT price_hourly, price_monthly, price_year FROM ".$table_prefix."billing_services WHERE service_id=".$db->realEscapeSingle($service_id);
			$result_service = $db->resultQuery($qry_service);
			$row_service = $result_service[0];

				//Calculating Costs
				
			if ($invoice_duration == "hour")
			{
			$price_slot=$row_service['price_hourly'];
			}
			elseif ($invoice_duration == "month")
			{
			$price_slot=$row_service['price_monthly'];
			}
			elseif ($invoice_duration == "year")
			{
			$price_slot=$row_service['price_year']*12;
			}
			$duration = $invoice_duration > 1 ? $invoice_duration."s":$invoice_duration;
			?>			  
			  <tr>
				<td height="23"><?php  echo $order['home_name']; ?></td>
				<td><?php  echo $qty." ".get_lang($duration); ?></td>
				<td><?php  echo number_format( $price_slot, 2 )." ".$settings['currency']."/".get_lang($invoice_duration); ?></td>
				<td><?php  echo $max_players; ?></td>
				<td><?php  echo number_format( $price, 2 )." ".$settings['currency']; ?></td>
			  </tr><?php
		}
		
		$total = $subtotal+($cart[0]['tax_amount']/100*$subtotal);
		
		?>
			  <tr>
				<td height="24" colspan="5">&nbsp;</td>
			  </tr>
			  <tr>
				<td colspan="3" rowspan="4">&nbsp;</td>
				<td height="23" style="border: 2px solid #000000"><div align="right"><strong><?php print_lang("subtotal");?> : </strong></div></td>
				<td style="border: 2px solid #000000"><?php  echo number_format( $subtotal, 2 )." ".$settings['currency']; ?></td>
			  </tr>
			  <tr>
				<td height="23" style="border: 2px solid #000000"><div align="right"><strong><?php print_lang("tax");?> : </strong></div></td>
				<td style="border: 2px solid #000000"><?php  echo $cart[0]['tax_amount']."%"; ?></td>
			  </tr>
			  <tr>
				<td height="23" style="border: 2px solid #000000" bgcolor="#CCCCCC"><div align="right"><strong><?php print_lang("total");?> : </strong></div></td>
				<td style="border: 2px solid #000000" bgcolor="#CCCCCC"><?php  echo $total." ".$settings['currency']; ?></td>
			  </tr>
			  <tr>
				<td height="23" style="border: 2px solid #000000" bgcolor="#CCCCCC"><div align="right"><strong><?php print_lang("cart_id");?> : </strong></div></td>
				<td style="border: 2px solid #000000" ><?php  echo $cart_id; ?></td>
			  </tr>
			  <tr>
				<td height="23" style="border: 2px solid #000000" bgcolor="#CCCCCC"><div align="right"><strong><?php print_lang("date");?> : </strong></div></td>
				<td style="border: 2px solid #000000"><?php  echo $cart[0]['date']; ?></td>
			  </tr>
			  <tr>
				<td height="21" colspan="2">&nbsp;</td>
			  </tr>
			</table>
			<br><br>
			<form method='post' action='?m=simple-billing&p=bill&type=cleared' >
			<input type="hidden" name="cart_id" value="<?php echo $_POST['cart_id'];?>">
			<input type="submit" value="<?php print_lang('print_invoice') ?>" />
			</form>
			<form method='post' action='?m=simple-billing&p=<?php 
			$isAdmin = $db->isAdmin($_SESSION['user_id']);
			if ($isAdmin)
			{
				echo 'orders';
			}
			else
			{
				echo 'cart';
			}
			echo "'><input type='submit' value='";
			print_lang('back');
			?>'/>
			</form>
			<br><br><?php
	}
}	
?>