<?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_fund_list.php');
$delinfo = 'none';
$addinfo = 'none';
$msg = "";
if(isset($_GET['id']) && $_GET['id'] != '' && $_GET['id'] > 0){
	$sqlx= "DELETE FROM `tbl_add_fund` WHERE fund_id = ".$_GET['id'];
	mysqli_query($link,$sqlx); 
	$delinfo = 'block';
}
if(isset($_GET['m']) && $_GET['m'] == 'add'){
	$addinfo = 'block';
	$msg = $_data['added_fund_successfully'];
}
if(isset($_GET['m']) && $_GET['m'] == 'up'){
	$addinfo = 'block';
	$msg = $_data['update_fund_successfully'];
}
?>
<!-- Content Header (Page header) -->

<section class="content-header">
  <h1><?= $_data['add_new_fund'];?></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['fund'];?></li>
    <li class="active"><?= $_data['add_new_fund'];?></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_fund_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; ?>fund/add_fund.php" data-original-title="<?= $_data['add_new_fund_breadcam'];?>"><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_fund'];?></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_1'];?></th>
              <th><?= $_data['add_new_form_field_text_3'];?></th>
              <th><?= $_data['add_new_form_field_text_5'];?></th>
              <th><?= $_data['add_new_form_field_text_6'];?></th>
              <th><?= $_data['add_new_form_field_text_7'];?></th>
              <th><?= $_data['action_text'];?></th>
            </tr>
          </thead>
          <tbody>
            <?php
				$result = mysqli_query($link,"Select *,ow.o_name,ow.image,m.month_name,y.xyear as y_xyear from tbl_add_fund fu inner join tbl_add_owner ow on ow.ownid = fu.owner_id inner join tbl_add_month_setup m on m.m_id = fu.month_id inner join tbl_add_year_setup y on y.y_id = fu.xyear where fu.branch_id = " . (int)$_SESSION['objLogin']['branch_id'] . " order by fu.fund_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['month_name']; ?></td>
              <td><?= $row['y_xyear']; ?></td>
              <td><?= $row['f_date']; ?></td>
              <td><?= $ams_helper->currency($localization, $row['total_amount']); ?></td>
              <td><a target="_blank" class="btn btn-info ams_btn_special" data-original-title="<?= $_data['add_new_form_field_text_9'];?>" data-toggle="tooltip" href="<?= WEB_URL;?>fund/invoice.php?fundid=<?= $row['fund_id']; ?>"><i class="fa fa-file-text-o"></i></a> <a class="btn btn-success ams_btn_special" data-toggle="tooltip" href="javascript:;" onclick="$('#nurse_view_<?= $row['fund_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;?>fund/add_fund.php?id=<?= $row['fund_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="deleteFund(<?= $row['fund_id']; ?>);" href="javascript:;" data-original-title="<?= $_data['delete_text'];?>"><i class="fa fa-trash-o"></i></a>
                <div id="nurse_view_<?= $row['fund_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['fund_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_1'];?> :</b> <?= $row['o_name']; ?><br/>
                            <b><?= $_data['add_new_form_field_text_3'];?> :</b> <?= $row['month_name'];?><br/>
                            <b><?= $_data['add_new_form_field_text_7'];?> : </b> <?= $ams_helper->currency($localization, $row['total_amount']); ?><br/>
                            <b><?= $_data['add_new_form_field_text_6'];?> :</b> <?= $row['f_date']; ?><br/>
                          </div>
                          <div class="col-xs-6"> <b><?= $_data['add_new_form_field_text_8'];?> :</b> <?= $row['purpose']; ?><br/>
                          </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 deleteFund(Id){
  	var iAnswer = confirm("<?= $_data['delete_confirm']; ?>");
	if(iAnswer){
		window.location = '<?= WEB_URL; ?>fund/fund_list.php?id=' + Id;
	}
  }
  
  $( document ).ready(function() {
	setTimeout(function() {
		  $("#me").hide(300);
		  $("#you").hide(300);
	}, 3000);
});
</script>
<?php include_once('../footer.php'); ?>
