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

<?php
function lang_trans_shop_name()
{
	include('db_con.php');
	$get_lang ="select * from lang_transtb where english='Shop Name'";
	$run_lang = mysqli_query($con,$get_lang);
	while($row_lang = mysqli_fetch_array($run_lang))
	{
		$lang_output = $row_lang['arabic'];
		echo"$lang_output";
	}	
}

?>

<?php
function lang_trans_amount()
{
	include('db_con.php');
	$get_lang ="select * from lang_transtb where english='Money'";
	$run_lang = mysqli_query($con,$get_lang);
	while($row_lang = mysqli_fetch_array($run_lang))
	{
		$lang_output = $row_lang['arabic'];
		echo"$lang_output";
	}
}
?>

<?php
function lang_trans_percentge()
{
	include('db_con.php');
	$get_lang ="select * from lang_transtb where english='percentge'";
	$run_lang = mysqli_query($con,$get_lang);
	while($row_lang = mysqli_fetch_array($run_lang))
	{
		$lang_output = $row_lang['arabic'];
		echo"$lang_output";
	}
}
?>

<?php
function lang_trans_date()
{
	include('db_con.php');
	$get_lang ="select * from lang_transtb where english='date'";
	$run_lang = mysqli_query($con,$get_lang);
	while($row_lang = mysqli_fetch_array($run_lang))
	{
		$lang_output = $row_lang['arabic'];
		echo"$lang_output";
	}
}
?>

<?php
function lang_trans_property_name()
{
	include('db_con.php');
	$get_lang ="select * from lang_transtb where english='property name'";
	$run_lang = mysqli_query($con,$get_lang);
	while($row_lang = mysqli_fetch_array($run_lang))
	{
		$lang_output = $row_lang['arabic'];
		echo"$lang_output";
	}
}
?>






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

<div id="main_expend_div_trans" style="display:none;" >

<div class="main_expend_lebal_div" >

<div class="shop_exp_to_name"><!--span id="english_lang6t" >SHOP NAME </span--><span idk="arabic_lang6t" ><?php lang_trans_shop_name(); ?></span></div>
<div class="shop_exp_to_amount"><!--span id="english_lang7t" >AMOUNT BD </span--><span idk="arabic_lang7t" ><?php lang_trans_amount(); ?></span></div>
<div class="shop_exp_to_date"><!--span id="english_lang8t" >DATE7</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 class="main_expend_out_div" >	
<?php	
	if($name_shop == $lang_output2){
		$my_name = $name_shop;
?>
<div class="shop_exp_to_name_output"><?php echo $lang_output ?></div>
<?php }else{?>
<div class="shop_exp_to_name_output"><?php echo $name_shop ?></div>

<?php } ?>
<div class="shop_exp_to_amount_output"><?php echo $spent_amount ?></div>
<div class="shop_exp_to_date_output"><?php echo"<span style='color:green'>$start_date </span> / <span style='color:red'>$end_date</span>"; ?></div>
	
	

	
</div>

<?php } ?>

</div><!--end of main_expend_div_trans  -->
<?php } ?>


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

	/*$get_calender = "select * from graph_calendartb ";
	$run_get_calender = mysqli_query($con,$get_calender);
	while($row_calender = mysqli_fetch_array($run_get_calender)){
		$calender_id = $row_calender['id'];
		$start_date = $row_calender['start_date'];
		$shop_name = $row_calender['shop_name'];
		$status_code = $row_calender['status_code'];
		$final_amount = $row_calender['total_amount'];//////*/
		
		

$lang_output="";
$lang_output2=""; 

	$get_calender = "select * from graph_calendartb order by id desc ";
	$run_get_calender = mysqli_query($con,$get_calender);
	while($row_calender = mysqli_fetch_array($run_get_calender)){
		$calender_id = $row_calender['id'];
		$start_date = $row_calender['start_date'];
		$shop_name = $row_calender['shop_name'];
		$status_code = $row_calender['status_code'];
		$final_amount = $row_calender['total_amount'];
		
	$get_lang ="select * from lang_transtb where english ='$shop_name'";
	$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'];

	}	
		
		if($shop_name == $lang_output2){?>
		<div class="graph_info_title" style="font-size:1.3em;" ><?php echo $lang_output; ?> المصروفات <!--Expenditure.--></div>	
	
<?php	}else{ ?>
<div class="graph_info_title" style="font-size:1.3em;" ><?php echo $shop_name; ?> المصروفات <!--Expenditure.--></div>	

<?php } ?>
<!--div class="graph_info_title" style="" ><?php //echo $shop_name; ?> Expenditure.</div-->	
<div id="graph_text_info_head_div" class="graph_text_info_head_div" >

<div class="graph_building_lebal" style="font-size:1.2em;" ><!--PROPERTY NAME--><?php lang_trans_property_name(); ?></div>
<div class="graph_amount_lebal" style="font-size:1.3em;"><!--AMOUNT BD--><?php lang_trans_amount(); ?></div>
<div class="graph_percent_lebal" style="font-size:1.3em;" ><!--PERCENTAGE--><?php lang_trans_percentge(); ?></div>

<div class="graph_date4m_lebal" style="font-size:1.3em;" ><!--DATE--><?php lang_trans_date(); ?>

<button name="<?php echo"$calender_id"; ?>" onmousedown="close_all();" onClick="show_graph_option_arabic(this.name)" class="graph_more_option_btn" >...</button>


<div id="graph_more_option_div_arabic<?php echo"$calender_id"; ?>" onmouseleave="close_graph_more_option_arabic();" class="graph_more_option_div" style="display:none;" >
<button id="show_graph_diagram_btn" name="<?php echo"$status_code"; ?>" onClick="show_graph_diagram(this.name)" class="datagraph_btn">Graph</button>
<button onClick="print_text_graph_dat_arabic(this.name);" name="<?php echo"$calender_id"; ?>" class="datagraph_btn">Print</button>
<a href="extraction.php?status_code=<?php echo"$status_code"; ?>" ><button class="datagraph_btn">add</button></a>
</div>


</div>

</div>


	
<?php
$lang_output="";
$lang_output2=""; 
$disp_graph_info = "select * from graph_datatb where status_code='$status_code' ";//trans_start_date='$start_date' AND trans_end_date='$end_date'";
$run_disp_graph_info = mysqli_query($con,$disp_graph_info);
while($row_disp_graph_info = mysqli_fetch_array($run_disp_graph_info))
{
	$propert_name = $row_disp_graph_info['property_name'];
	$propert_amount = $row_disp_graph_info['amount'];
	$trans_start_date = $row_disp_graph_info['trans_start_date'];
	$trans_end_date = $row_disp_graph_info['trans_end_date'];
	$my_percentage = 100;
	
		$amount_percentage = number_format($propert_amount / $final_amount * $my_percentage,1,'.','');
		
	$get_lang ="select * from lang_transtb where english ='$propert_name'";
	$run_lang = mysqli_query($con,$get_lang);
	?>
	<div id="graph_text_info_div" class="graph_text_info_div" style="font-size:1.2em;" >
	<?php
	while($row_lang = mysqli_fetch_array($run_lang))
	{
		$lang_output = $row_lang['arabic'];
		$lang_output2 = $row_lang['english'];

	}	
		
		if($propert_name == $lang_output2){
?>
		<div class="graph_building_out"><?php echo"$lang_output"; ?></div>	
<?php }else{ ?>
	<div class="graph_building_out"><?php echo"$propert_name"; ?></div>	
<?php } ?>

<div class="graph_amount_out"><?php echo"$propert_amount"; ?></div>
<div class="graph_percent_out"><?php echo"$amount_percentage%"; ?></div>
<div class="graph_date4m_out"><?php echo"<span style='color:green'>$trans_start_date </span>/<span style='color:red'> $trans_end_date </span>"; ?></div>



</div><!-- end of graph_text_info_div-->

<script>



</script>

<?php } } } ?>