<?php include('db_con.php'); ?>

<?php
function expendiure_printing()
{
	include('db_con.php');
?>

<div style="float:left;width:900px;height:auto;margin-leftk:15%;margin-top:5px;backgroundk:red;borderk:1px solid gray;" >
<div style="float:left;width:895px;height:40px;line-height:40px;margin-leftk:15%;background:pink;text-align:center;font-size:1.2em;font-weight:bold;border-top:1px solid gray;border-left:1px solid gray;border-right:1px solid gray;">MAINTENANCE Expenses.</div>

<div style="float:left;width:41%;height:40px;line-height:40px;background:#ccc;text-align:center;border:1px solid gray;color:blue;font-weight:bold;font-size:1.2em;	">SHOP NAME</span></div>
<div style="float:left;width:29%;height:40px;line-height:40px;background:#ccc;text-align:center;border:1px solid gray;color:blue;font-weight:bold;font-size:1.2em;">AMOUNT BD</span></div>
<div style="float:left;width:29%;height:40px;line-height:40px;background:#ccc;text-align:center;border:1px solid gray;color:blue;font-weight:bold;font-size:1.2em;">DATE</span></div>

</div>

<?php
	$get_shop_name = "select * from expendituretb order by id desc ";
	$run_get_expenditure = mysqli_query($con,$get_shop_name);
	while($row_get_expenditure = mysqli_fetch_array($run_get_expenditure))
	{
	$name_shop = $row_get_expenditure['shop_name'];
    $spent_amount = $row_get_expenditure['amount'];	
    $start_date= $row_get_expenditure['start_date'];
    $end_date= $row_get_expenditure['end_date'];


	
?>


<div style="float:left;width:900px;height:40px;margin-leftk:15%;margin-rightk:15%;margin-topk:65px;backgroundk:pink;borderk:1px solid gray;font-size:1.1em;" >
<div style="float:left;width:41%;height:40px;line-height:40px;background:#fff;text-align:center;border:1px solid gray;font-size:1.3em;"><?php echo $name_shop ?></div>
<div style="float:left;width:29%;height:40px;line-height:40px;background:#fff;text-align:center;border:1px solid gray;"><?php echo $spent_amount ?></div>
<div style="float:left;width:29%;height:40px;line-height:40px;background:#fff;text-align:center;border:1px solid gray;"><?php echo"<span style='color:green'>$start_date </span> / <span style='color:red'>$end_date</span>"; ?></div>

</div>


<?php } ?>

	
<?php } ?>



<?php
function trans_expendiure_printing()
{
	include('db_con.php');
?>

<div style="float:left;width:900px;height:auto;margin-leftk:15%;margin-top:5px;backgroundk:red;borderk:1px solid gray;" >
<div style="float:left;width:895px;height:40px;line-height:40px;margin-leftk:15%;background:pink;text-align:center;font-size:1.2em;font-weight:bold;border-top:1px solid gray;border-left:1px solid gray;border-right:1px solid gray;"><!--MAINTENANCE Expenses.-->.نفقات الصيانة</div>

<div style="float:left;width:41%;height:40px;line-height:40px;background:#ccc;text-align:center;border:1px solid gray;color:blue;font-weight:bold;font-size:1.2em;	"><!--span id="english_lang1t" >SHOP NAME</span--> <span idk="arabic_lang1t"><?php lang_trans_shop_name(); ?></span></div>
<div style="float:left;width:29%;height:40px;line-height:40px;background:#ccc;text-align:center;border:1px solid gray;color:blue;font-weight:bold;font-size:1.2em;"><!--span id="english_lang2t" >AMOUNT BD</span--> <span idk="arabic_lang2t" ><?php lang_trans_amount(); ?></span></div>
<div style="float:left;width:29%;height:40px;line-height:40px;background:#ccc;text-align:center;border:1px solid gray;color:blue;font-weight:bold;font-size:1.2em;"><!--span id="english_lang8t" >DATE9 </span--><span idk="arabic_lang8t"  ><?php lang_trans_date(); ?></span></div>

</div>


<?php
$lang_output2="";
	$get_shop_name = "select * from expendituretb order by id desc ";
	$run_get_expenditure = mysqli_query($con,$get_shop_name);
	while($row_get_expenditure = mysqli_fetch_array($run_get_expenditure))
	{
	$name_shop = $row_get_expenditure['shop_name'];
    $spent_amount = $row_get_expenditure['amount'];	
    $start_date= $row_get_expenditure['start_date'];
    $end_date= $row_get_expenditure['end_date'];
	
		$get_lang ="select * from lang_transtb where english ='$name_shop'";
	$run_lang = mysqli_query($con,$get_lang);
	while($row_lang = mysqli_fetch_array($run_lang))
	{
		$lang_output = $row_lang['arabic'];
		$lang_output2 = $row_lang['english'];

	}
?>

<div style="float:left;width:900px;height:40px;margin-leftk:15%;margin-rightk:15%;margin-topk:65px;backgroundk:pink;borderk:1px solid gray;font-size:1.1em;" >

<?php	
	if($name_shop == $lang_output2){
		$my_name = $name_shop;
?>

<div style="float:left;width:41%;height:40px;line-height:40px;background:#fff;text-align:center;border:1px solid gray;font-size:1.3em;"><?php echo $lang_output ?></div>
<?php }else{?>
<div style="float:left;width:41%;height:40px;line-height:40px;background:#fff;text-align:center;border:1px solid gray;font-size:1.3em;"><?php echo $name_shop ?></div>
<?php } ?>
<div style="float:left;width:29%;height:40px;line-height:40px;background:#fff;text-align:center;border:1px solid gray;"><?php echo $spent_amount ?></div>
<div style="float:left;width:29%;height:40px;line-height:40px;background:#fff;text-align:center;border:1px solid gray;"><?php echo"<span style='color:green'>$start_date </span> / <span style='color:red'>$end_date</span>"; ?></div>

</div>


<?php } ?>

	
<?php } ?>