<?php include_once('../header.php');
if(!check_login()){
	header("Location: " . WEB_URL . "logout.php");
	die();
}
?>
<?php
include_once(ROOT_PATH.'language/'.$lang_code_global.'/lang_owner_utility_list.php');
$delinfo = 'none';
$addinfo = 'none';
$msg = "";
if(isset($_GET['id']) && $_GET['id'] != '' && $_GET['id'] > 0){
	$sqlx= "DELETE FROM `rent` WHERE f_id = ".$_GET['id'];
	mysqli_query($link,$sqlx); 
	$delinfo = 'block';
}
if(isset($_GET['m']) && $_GET['m'] == 'add'){
	$addinfo = 'block';
	$msg = $_data['added_owner_utility_successfully'];
}
if(isset($_GET['m']) && $_GET['m'] == 'up'){
	$addinfo = 'block';
	$msg = $_data['update_owner_utility_successfully'];
}
?>
<!-- Content Header (Page header) -->

<section class="content-header">
  <h1><?= $_data['add_new_owner_list_utility_title'];?></h1>
  <ol class="breadcrumb">
    <li><a href="<?= WEB_URL?>dashboard.php"><i class="fa fa-dashboard"></i><?= $_data['home_breadcam'];?></a></li>
    <li class="active"><?= $_data['owner_utility'];?></li>
    <li class="active"><?= $_data['add_new_owner_list_utility_title'];?></li>
  </ol>
</section>
<!-- Main content -->
<section class="content">
<!-- Full Width boxes (Stat box) -->
<div class="row">
  <div class="col-xs-12">
    <div id="me" class="alert alert-danger alert-dismissable" style="display:<?= $delinfo; ?>">
      <button aria-hidden="true" data-dismiss="alert" class="close" type="button"><i class="fa fa-close"></i></button>
      <h4><i class="icon fa fa-ban"></i> <?= $_data['delete_text'];?> !</h4>
      <?= $_data['delete_owner_utility_information'];?> </div>
    <div id="you" class="alert alert-success alert-dismissable" style="display:<?= $addinfo; ?>">
      <button aria-hidden="true" data-dismiss="alert" class="close" type="button"><i class="fa fa-close"></i></button>
      <h4><i class="icon fa fa-check"></i> <?= $_data['success'];?> !</h4>
      <?= $msg; ?> </div>
    <div align="right" style="margin-bottom:1%;"> <a class="btn btn-success" data-toggle="tooltip" href="<?= WEB_URL; ?>owner_utility/add_owner_utility.php" data-original-title="<?= $_data['add_owner_utility'];?>"><i class="fa fa-plus"></i></a> <a class="btn btn-success" data-toggle="tooltip" href="<?= WEB_URL; ?>dashboard.php" data-original-title="<?= $_data['home_breadcam'];?>"><i class="fa fa-dashboard"></i></a> </div>
    <div class="box box-success">
      <div class="box-header">
        <h3 class="box-title"><?= $_data['add_new_owner_list_utility_title'];?></h3>
      </div>
      <!-- /.box-header -->
      <div class="box-body">
        <table class="table sakotable table-bordered table-striped dt-responsive">
          <thead>
            <tr>
              <th><?= $_data['image'];?></th>
              <th><?= $_data['add_new_form_field_text_6'];?></th>
              <th><?= $_data['add_new_form_field_text_1'];?></th>
              <th><?= $_data['add_new_form_field_text_3'];?></th>
              <th><?= $_data['add_new_form_field_text_16'];?></th>
			  <th><?= $_data['add_new_form_field_text_17'];?></th>
              <th><?= $_data['add_new_form_field_text_18'];?></th>
              <th><?= $_data['add_new_form_field_text_14'];?></th>
              <th><?= $_data['action_text'];?></th>
            </tr>
          </thead>
          <tbody>
        <?php
		$result = mysqli_query($link,"Select *,fl.b_name as fl_floor,u.unit_no as u_unit,orl.owner_id,w.o_name,w.image,m.month_name from rent ou inner join blocks fl on fl.bid = ou.b_name inner join units u on u.uid = ou.unit_no inner join tbl_add_owner_unit_relation orl on orl.unit_id = u.uid inner join tbl_add_owner w on w.ownid = orl.owner_id inner join tbl_add_month_setup m on m.m_id = ou.month_id where ou.type='Owner' and ou.branch_id = " . (int)$_SESSION['objLogin']['branch_id'] . " order by ou.f_id desc");
				while($row = mysqli_fetch_array($result)){
					$image = WEB_URL . 'img/no_image.jpg';	
					if(file_exists(ROOT_PATH . '/img/upload/' . $row['image']) && $row['image'] != ''){
						$image = WEB_URL . 'img/upload/' . $row['image'];
					}
				?>
            <tr>
            <td><img class="photo_img_round" style="width:50px;height:50px;" src="<?= $image;  ?>" /></td>
            <td><?= $row['o_name']; ?></td>
            <td><?= $row['fl_floor']; ?></td>
            <td><?= $row['u_unit']; ?></td>
            <td><?= $row['month_name']; ?></td>
			<td><?= $row['xyear']; ?></td>
            <td><?= $ams_helper->currency($localization, $row['rent']); ?></td>
			<td><?= $ams_helper->currency($localization, $row['total_rent']); ?></td>
            <td>
            <a class="btn btn-success ams_btn_special" data-toggle="tooltip" href="javascript:;" onclick="$('#nurse_view_<?= $row['f_id']; ?>').modal('show');" data-original-title="<?= $_data['view_text'];?>"><i class="fa fa-eye"></i></a> <a class="btn btn-warning ams_btn_special" data-toggle="tooltip" href="<?= WEB_URL;?>owner_utility/add_owner_utility.php?id=<?= $row['f_id']; ?>" data-original-title="<?= $_data['edit_text'];?>"><i class="fa fa-pencil"></i></a> <a class="btn btn-danger ams_btn_special" data-toggle="tooltip" onclick="deleteOwnerUtility(<?= $row['f_id']; ?>);" href="javascript:;" data-original-title="<?= $_data['delete_text'];?>"><i class="fa fa-trash-o"></i></a>
            <div id="nurse_view_<?= $row['f_id']; ?>" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
              <div class="modal-dialog">
                <div class="modal-content">
                  <div class="modal-header green_header">
                    <button aria-label="Close" data-dismiss="modal" class="close" type="button"><span aria-hidden="true"><i class="fa fa-close"></i></span></button>
                    <h3 class="modal-title"><?= $_data['owner_utility_details'];?></h3>
                  </div>
                  <div class="modal-body model_view" align="center">&nbsp;
                    <div><img class="photo_img_round" style="width:100px;height:100px;" src="<?= $image;  ?>" /></div>
                    <div class="model_title"><?= $row['o_name']; ?></div>
                  </div>
				  <div class="modal-body">
                    <h3 style="text-decoration:underline;"><?= $_data['details_information'];?></h3>
                    <div class="row">
                      <div class="col-xs-6"> 
					    <b><?= $_data['add_new_form_field_text_6'];?> :</b> <?= $row['o_name']; ?><br/>
                        <b><?= $_data['add_new_form_field_text_1'];?> :</b> <?= $row['fl_floor']; ?><br/>
                        <b><?= $_data['add_new_form_field_text_3'];?> :</b> <?= $row['u_unit']; ?><br/>
                        <b><?= $_data['add_new_form_field_text_16'];?> :</b> <?= $row['month_name'];?><br/>
						<b><?= $_data['add_new_form_field_text_17'];?> :</b> <?= $row['xyear'];?><br/>
                        <b><?= $_data['add_new_form_field_text_18'];?> : </b> <?= $ams_helper->currency($localization, $row['rent']); ?><br/>
						<b><?= $_data['add_new_form_field_text_8'];?> : </b> <?= $ams_helper->currency($localization, $row['water_bill']); ?><br/>
						<b><?= $_data['add_new_form_field_text_9'];?> : </b> <?= $ams_helper->currency($localization, $row['electric_bill']); ?><br/>
                      </div>
                      
                      <div class="col-xs-6"> 
					    <b><?= $_data['add_new_form_field_text_10'];?> : </b> <?= $ams_helper->currency($localization, $row['gas_bill']); ?><br/>
						<b><?= $_data['add_new_form_field_text_11'];?> : </b> <?= $ams_helper->currency($localization, $row['security_bill']); ?><br/>
						<b><?= $_data['add_new_form_field_text_12'];?> : </b> <?= $ams_helper->currency($localization, $row['utility_bill']); ?><br/>
                        <b><?= $_data['add_new_form_field_text_13'];?> : </b> <?= $ams_helper->currency($localization, $row['other_bill']); ?><br/>
                        <b><?= $_data['add_new_form_field_text_14'];?> : </b> <?= $ams_helper->currency($localization, $row['total_rent']); ?><br/>
                        <b><?= $_data['add_new_form_field_text_15'];?> :</b> <?= $row['issue_date']; ?>
                      </div>
                      
                    </div>
                  </div>
				  
                </div>
                <!-- /.modal-content -->
              </div>
            </div>
            </td>
            </tr>
           <?php } mysqli_close($link);$link = NULL; ?>
          </tbody>
        </table>
      </div>
      <!-- /.box-body -->
    </div>
    <!-- /.box -->
  </div>
  <!-- /.col -->
</div>
<!-- /.row -->
<script type="text/javascript">
function deleteOwnerUtility(Id){
	var iAnswer = confirm("<?= $_data['confirm']; ?>");
	if(iAnswer){
		window.location = '<?= WEB_URL; ?>owner_utility/owner_utility_list.php?id=' + Id;
	}
  }
  
  $( document ).ready(function() {
	setTimeout(function() {
		  $("#me").hide(300);
		  $("#you").hide(300);
	}, 3000);
});
</script>
<?php include_once('../footer.php'); ?>
