filephp fin2@agn

FilePHP

/home/u902783705/domains/azkapersada.com/public_html/sub/fin/

inc.bank.php

<main>
  <div class="container-fluid">
    <div class="row align-items-center justify-content-between pt-2">
      <div class="col-auto mb-3">
          <h2>Bank</h2>
      </div>
      <div class="col-12 col-xl-auto mb-3">          
        <?php if($col=='month') {

for($a=1;$a<date("n");$a++) {
            ?>
            <a href="?op=bank&op2=<?=$op2;?>&col1=<?=$col1;?>&q1=<?=$q1;?>&col=month&q=2025<?=$ar['month_seq'][$a];?>" class="btn btn-xs btn-color-cyan"><?=$ar['month_name'][$a];?></a>
            <?php
          }
        } ?>
          <a class="btn btn-xs btn-color-orange" href="?op=bank&op2=bnipt_csv&rek=1">Import Text BNI PT</a>
          <a class="btn btn-xs btn-color-blue" href="?op=bank&op2=mandiript_csv&rek=2">Import CSV Mandiri PT</a>
          <a class="btn btn-xs btn-color-teal" href="?op=bank&op2=mandiri_json">Import JSON Mandiri</a>
          <a class="btn btn-xs btn-color-pink" href="?op=bank&op2=bca_csv&rek=4">Import CSV BCA</a>
          <a class="btn btn-xs btn-color-purple" href="?op=bank&op2=jago_csv&rek=4">Import CSV Jago</a>
          <a class="btn btn-xs btn-color-lime" href="?op=bank&op2=add">Add bank</a>
      </div>
    </div>

<?php

switch($op2) {
        
      case "mandiri_json";
          f_mandiri_json('','');
          break;

case "mandiri_json2";
          f_mandiri_json($_POST['json'],$_POST['rek']);
          $js=json_decode($_POST['json']);
          ///$json1 = str_replace('\n',' ',$js2);
          //$js = preg_replace('/\s+/', ' ', $json1);
          $dt=array();
          $b=0;
          foreach ($js as $k => $v) {
            if(isset($v->no) && $v->no!='') {
              $dt[$b]['no']=$v->no;

if(isset($v->tgl) && $v->tgl!='') {
                $dt[$b]['tgl']=$v->tgl;
              }
              if(isset($v->keterangan) && $v->keterangan!='') {
                $ket = preg_replace('/\n/',' ',$v->keterangan);
                $ket2 = preg_replace('/\r/',' ',$ket);
                $dt[$b]['keterangan']=$ket2;
              }
              if(isset($v->saldo) && $v->saldo!='') {
                $dt[$b]['saldo']=$v->saldo;
                //echo $v->saldo."|";
              }
              if(isset($v->kredit) && $v->kredit!='') {
                //echo $v->kredit."|";
                $dt[$b]['kredit']=$v->kredit;
              } else {
                $dt[$b]['kredit']=0;
              }
              if(isset($v->debit) && $v->debit!='') {
                //echo $v->debit."|";
                $dt[$b]['debit']=$v->debit;
              } else {
                $dt[$b]['debit']=0;              
              }
            }
            if(isset($v->no) && $v->no!='') {
              $b++;
            }
          }

$d=0;
          foreach ($js as $k => $v) {
            if(!isset($v->no)) {
              if(isset($v->tgl) && $v->tgl!='') {
                $dt[$d]['time']=$v->tgl;
                $d++;
              }
            }
          }

$sql4 = "select * from csv_m order by id desc limit 1";
          $res4 = mysqli_query($db, $sql4);
          $rw4 = mysqli_fetch_assoc($res4);
          if(isset($rw4['id'])) {
            $id2=$rw4['id']+1;
          } else {
            $id2=1;
          }

foreach ($dt as $k => $v) {
            $etg=explode(" ",$v['tgl']);
            $ejam=explode(" ",$v['time']);
            $tgl=$etg[2]."-".$ar['bulan'][strtolower($etg[1])]."-".$etg[0]." ".$ejam[0];
            if($v['debit']==0) {
              $dk=2;
            } else {
              $dk=1;
            }
            $idt=array(
              'id'=>$id2,
                'rek'=>$_POST['rek'],
                //'curr'=>'idr',
                'year'=>$etg[2],
                'month'=>$etg[2]."".$ar['bulan'][strtolower($etg[1])],
                'tgl'=>$tgl,
                'tgl2'=>strtotime($tgl),
                'seq'=>$k+1,
                'inout'=>$dk,
                'keterangan'=>trim(gpc($v['keterangan'])),
                'kredit'=>to_numeric(substr($v['kredit'],0,-3)),
                'debit'=>to_numeric(substr($v['debit'],0,-3)),
                'saldo'=>to_numeric(substr($v['saldo'],0,-3)),
              );
              $udt=array(
                'seq'=>$k+1,
                'inout'=>$dk,
                'keterangan'=>trim(gpc($v['keterangan'])),
                'kredit'=>to_numeric(substr($v['kredit'],0,-3)),
                'debit'=>to_numeric(substr($v['debit'],0,-3)),
                'saldo'=>to_numeric(substr($v['saldo'],0,-3)),
              );
              InsertUpdate($db,"csv_m",$idt,$udt,1);
              $id2++;
            }

echo "<pre>"; print_r($dt); echo "</pre>";          
          
          //echo "<pre>"; print_r($js); echo "</pre>";
          break;

case "jago_list_mutasi";
          list_jago_mutasi($q,$col,$q2,$col2,$sortby,$sort,$page);
          break;

case "jago_csv";
          f_jago_csv('','','');
          break;

case "jago_csv2";

$sql4 = "select * from jago_mutasi order by id desc limit 1";
          $res4 = mysqli_query($db, $sql4);
          $rw4 = mysqli_fetch_assoc($res4);
          if(isset($rw4['id'])) {
            $id2=$rw4['id']+1;
          } else {
            $id2=1;
          }

//f_jago_csv($_POST['csv'],$_POST['csv2'],$_POST['month']);
          $lines = explode(PHP_EOL, $_POST['csv']);
          echo "total baris: ".count($lines)."<br>";
          $search=$_POST['month'];
          if($_POST['csv2']=='') {
            $dt2="";
            foreach ($lines as $k => $v) {
              $v2 = trim(preg_replace('/\s\s+/', '', $v));
              if(preg_match("/{$search}/i", $v)) {
                  //echo $v."<br>";
                $dt2 .="\n".$v2."|";
              } else {
                $dt2 .=$v2."|";
              }
            }
          } else {
            $dt2=$_POST['csv2'];
          }
          f_jago_csv($_POST['csv'],$dt2,$_POST['month']);

/*
          if($_POST['csv2']=='') {
            $dt2=preg_replace('/(\r\n|\r|\n)+/', "|", $_POST['csv']);
            $dt2.="|";
          } else {
            $dt2=$_POST['csv2'];
          }
          f_jago_csv($_POST['csv'],$dt2);
          */
          $lines = explode(PHP_EOL, $_POST['csv2']);
          echo "total baris: ".count($lines)."<br>";   
          $seq=1;  
          foreach ($lines as $k => $v) {
            $col=explode("|",$v);
            $jc=count($col);
            if($jc>7) {
              $etg=explode(" ",$col[0]);
              $ejam=explode(".",$col[1]);
              $tgl1=$etg[2]."-".$ar['bulan'][strtolower($etg[1])]."-".$etg[0]." ".$col[1];
              $ej=explode(" ",$col[$jc-2]);
              $jej=count($ej);
              if($jej>2) {
                $remark="";
                for($f=0;$f<$jej-2;$f++) {
                  $remark.=$ej[$f]." ";
                }
                $saldo=$ej[$jej-1];
                if(to_money($ej[$jej-2])>0) {
                  $debit=$ej[$jej-2];
                  $kredit=0;
                  $kd=2;
                } else {
                  $kredit=$ej[$jej-2];     
                  $debit=0;             
                  $kd=1;
                }
              } else {
                $remark="";
                $saldo=$ej[1];
                if(to_money($ej[0])>0) {
                  $debit=$ej[0];
                  $kredit=0;
                  $kd=2;
                } else {
                  $kredit=$ej[0];   
                  $debit=0;               
                  $kd=1;
                }
              }

$dr_to="";
              if($col[$jc-5]=='Pembayaran Produk' && $col[$jc-4]=='Digital') {
                $jenis=$col[$jc-5]." ".$col[$jc-4];
                for($g=2;$g<$jc-5;$g++) {
                  $dr_to .=$col[$g]." ";
                }
              } else {
                $jenis=$col[$jc-4];
                for($g=2;$g<$jc-4;$g++) {
                  $dr_to .=$col[$g]." ";
                }
              }

$jid=to_numeric($col[$jc-3]);
              /* 
              echo $k." ";
              echo $jc." ";
              //echo $col[$jc-2]." ";
              echo " | ".$dr_to." | ".$jenis." | ".$jid." | jej:".$jej." | rem:".$remark." | kd:".$kd." | deb:".to_money($debit)." | kre:".to_money($kredit)." | ".$saldo." | ".$v;
              echo "<br>";
              /*  */
              $idt=array(
                'id'=>$id2,
                'rek'=>'503086696958',
                'bank'=>9,
                'year'=>$etg[2],
                'month'=>$etg[2].''.$ar['bulan'][strtolower($etg[1])],
                'tgl'=>$tgl1,
                'tgl2'=>strtotime($tgl1),
                'seq'=>$seq,
                'kd'=>$kd,
                'jid'=>$jid,
                'category'=>$jenis,
                'keterangan'=>trim(gpc($dr_to)),
                'remark'=>trim($remark),
                'debit'=>to_numeric($debit),
                'kredit'=>to_numeric($kredit),
                'saldo'=>to_numeric($saldo),
              );
              $udt=array(
                'debit'=>to_numeric($debit),
                'kredit'=>to_numeric($kredit),
                'saldo'=>to_numeric($saldo),
              );
              InsertUpdate($db,"jago_mutasi",$idt,$udt,1);
              $seq++; $id2++;
            }
          }       
          /* */
          break;

case "bca_csv";
          f_bca_csv('','','');
          break;

case "bca_csv2";
          //f_mutasi_bca($rek,$year,$csv)
          f_bca_csv($_POST['rek'],$_POST['year'],$_POST['csv']);
          //f_mutasi($_POST['rek'],$_POST['csv'],$_POST['year']);

$lines = explode(PHP_EOL, $_POST['csv']);
          $lines3 = preg_replace("/'/","",$lines);
          $lines4 = str_replace('\r',' ',$lines3);
          $lines2 = preg_replace('/\s+/', ' ', $lines4);
          /*
          echo "<hr>";
          $dt=array();
          $b=1; $c=1;
          echo "total baris: ".count($lines2)."<br>";
          foreach ($lines2 as $k => $v) {            
            $c=explode(",",$v);
            //echo "baris ke-".$k.": ".$v."<br>";
            $dt[$k]=$c;
          }

echo "<pre>"; print_r($dt); echo "</pre>";
          */
          
          $sql4 = "select * from bca_mutasi order by id desc limit 1";
          $res4 = mysqli_query($db, $sql4);
          $rw4 = mysqli_fetch_assoc($res4);
          if(isset($rw4['id'])) {
            $id2=$rw4['id']+1;
          } else {
            $id2=1;
          }

$lines = explode(PHP_EOL, $_POST['csv']);
          $seq=1;
          foreach ($lines2 as $k => $v) {
            $col=explode(",",$v);
            if(count($col)>4 && $k>4) {
              $etgl=explode("/",$col[0]);
              $idt=array(
                'id'=>$id2,
                'rek'=>$_POST['rek'],
                'year'=>$_POST['year'],
                'month'=>$_POST['year'].''.$etgl[1],
                'tgl'=>$_POST['year'].'-'.$etgl[1].'-'.$etgl[0],
                'tgl2'=>strtotime($_POST['year'].'-'.$etgl[1].'-'.$etgl[0]),
                'seq'=>$seq,
                'keterangan'=>$col[1],
                'remark'=>to_numeric($col[2]),
                'saldo'=>$col[5],
              );
              $udt=array(
                'month'=>$_POST['year'].''.$etgl[1],
                'keterangan'=>$col[1],
                'remark'=>to_numeric($col[2]),
                'saldo'=>$col[5],
              );

if($col[4]=='DB') {
                $udt['kredit']=$idt['kredit']=$col[3];
              } else {
                $udt['debit']=$idt['debit']=$col[3];
              }
              InsertUpdate($db,"bca_mutasi",$idt,$udt,1);
              $seq++;
            }
            $id2++;
          }
          break;

case "bca_list_mutasi";
          list_bca_mutasi($q,$col,$q1,$col1,$q2,$col2,$sortby,$sort,$page);
          break;

case "mandiri_csv";
          f_mutasi5('','','');
          break;
      case "mandiri_csv2";
          f_mutasi5($_POST['rek'],$_POST['year'],$_POST['csv']);
          $lines = explode(PHP_EOL, $_POST['csv']);
          $lines3 = preg_replace("/\,/","",$lines);
          $lines4 = str_replace('\r',' ',$lines3);
          $lines2 = preg_replace('/\s+/', ' ', $lines4);
          
          echo "<hr>";
          $dt=array();
          $b=1; $c=1;
          foreach ($lines2 as $k => $v) {
            $c=explode(" ",$v);
            if (preg_match('/\//', $c[0])) {
              if(strlen($c[0])==5) {
              $b=$b+1;      
              }
            }
            //echo $s." b:".$b." ".$v."<br>";
            $dt[$b]['text'][]=$v;
            $c2=explode(" ",$dt[$b]['text'][0]);
            $jc2=count($c2);
          }
          //echo "<pre>"; print_r($dt); echo "</pre>";
          
          $sql4 = "select * from csv_m order by id desc limit 1";
          $res4 = mysqli_query($db, $sql4);
          $rw4 = mysqli_fetch_assoc($res4);
          $id2=$rw4['id']+1;

foreach($dt as $k=>$v) {
            $t2="";  
            foreach($v['text'] as $k2=>$v2) {
                $t2 .=$v2." ";
            }
            //echo $k."; ".$t2."<br>";
            $idt=array(
              'id'=>$id2,
              'seq'=>$k,
              'text'=>trim(gpc($t2)),
              'year'=>$_POST['year'],
              'rek'=>$_POST['rek'],
            );
            Insert($db,"csv_m",$idt,1);
            $id2++;
          }
        break;
          
      case "m_csv";
          include_once "csv.mandiri.pribadi.function.php";
          csv_mandiri_pribadi_1();
          csv_mandiri_pribadi_2();
          csv_mandiri_pribadi_2b();
          csv_mandiri_pribadi_3();
          csv_mandiri_pribadi_4();
          csv_mandiri_pribadi_5();
          csv_mandiri_pribadi_6();
          csv_mandiri_pribadi_7();
        break;
        
      case "exp";
          $sql4 = "select * from mandiript_mutasi where id=".$_GET['id'];
          $res4 = mysqli_query($db, $sql4);
          $r4 = mysqli_fetch_assoc($res4);
          echo "<pre>"; print_r($r4); echo "</pre>";
          
          if($r4['debit']==0) {
              $amount=$r4['kredit'];
          } else {
              $amount=$r4['debit'];
          }

$sql3 = "select * from action where bank=".$_GET['bank']." and amount=".$amount." and tgl='".$r4['tgl']."'";
          echo $sql3."<br>";
          $res3 = mysqli_query($db, $sql3);
          if(mysqli_num_rows($res3)>0) {
            $r3 = mysqli_fetch_assoc($res3);
            echo "<pre>"; print_r($r3); echo "</pre>";
            $udt=array(
              'action_id'=>$r3['id'],
            );
            Update($db,"mandiript_mutasi",$udt,"id=".$r4['id'],1);
              
          } else {
              
          }
          list_mandiript_mutasi($q,$col,$q2,$col2,$sortby,$sort,$page);

break;

case "exp1";
          $sql4 = "select * from bnipt_mutasi where id=".$_GET['id'];
          $res4 = mysqli_query($db, $sql4);
          $r4 = mysqli_fetch_assoc($res4);
          echo "<pre>"; print_r($r4); echo "</pre>";
          
          if($r4['debit']==0) {
              $amount=$r4['kredit'];
          } else {
              $amount=$r4['debit'];
          }

$sql3 = "select * from action where bank=1 and amount=".$amount." and tgl='".$r4['tgl']."'";
          echo $sql3."<br>";
          $res3 = mysqli_query($db, $sql3);
          if(mysqli_num_rows($res3)>0) {
            $r3 = mysqli_fetch_assoc($res3);
            echo "<pre>"; print_r($r3); echo "</pre>";
            $udt=array(
              'action_id'=>$r3['id'],
            );
            Update($db,"bnipt_mutasi",$udt,"id=".$r4['id'],1);
              
          } else {
              
          }
          $col="year"; $q=2024;
          list_bnipt_mutasi($q,$col,$q2,$col2,$sortby,$sort,$page);

break; 
      case "exp3";
          $sql4 = "select * from csv_m where id=".$_GET['id'];
          $res4 = mysqli_query($db, $sql4);
          $r4 = mysqli_fetch_assoc($res4);
          echo "<pre>"; print_r($r4); echo "</pre>";
          
          if($r4['debit']==0) {
              $amount=$r4['kredit'];
          } else {
              $amount=$r4['debit'];
          }

$sql3 = "select * from action where bank=3 and amount=".$amount." and tgl='".$r4['tgl']."'";
          echo $sql3."<br>";
          $res3 = mysqli_query($db, $sql3);
          if(mysqli_num_rows($res3)>0) {
            $r3 = mysqli_fetch_assoc($res3);
            echo "<pre>"; print_r($r3); echo "</pre>";
            $udt=array(
              'action_id'=>$r3['id'],
            );
            Update($db,"csv_m",$udt,"id=".$r4['id'],1);
              
          } else {
              
          }
          $col="month"; $q=$r4['month'];
          //list_bnipt_mutasi($q,$col,$q2,$col2,$sortby,$sort,$page);
          list_mandiri_mutasi($q,$col,$q2,$col2,$sortby,$sort,$page);

break;         
      case "bnipt_mutasi";
          list_bnipt_mutasi($q,$col,$q2,$col2,$sortby,$sort,$page);
          break;

case "bnipt_csv";
          f_mutasi4($_GET['rek'],'');
          break;
      case "bnipt_csv2";
          f_mutasi4($_POST['rek'],$_POST['csv']);

$sql4 = "select * from bnipt_mutasi order by id desc limit 1";
          $res4 = mysqli_query($db, $sql4);
          $rw4 = mysqli_fetch_assoc($res4);
          if(isset($rw4['id'])) {
            $id2=$rw4['id']+1;
          } else {
            $id2=501;
          }

$lines = explode(PHP_EOL, $_POST['csv']);

foreach ($lines as $k => $v) {
            $seq=$k+1;
            if($k>4) {
              $c=explode("|",$v);
              $jcol=count($c);
              if($jcol>7) {
                $saldo=$c[$jcol-1];
                $dk=$c[$jcol-2];
                if($dk=='D') {
                  $kredit=$c[$jcol-3]; 
                  $debit=0;
                } else {
                  $debit=$c[$jcol-3];
                  $kredit=0;
                }
                $desc="";
                for($d=4;$d<$jcol-3;$d++) {
                    $desc .= $c[$d]." ";
                }

$desc2 = preg_replace('/\s+/', ' ', ucwords(strtolower($desc)));
                //$desc2=substr($desc3,0,-1);
                
                $sid = preg_replace("/[^0-9]/"," ",$c[1]);
                $etg=explode(" ",strtolower($sid));
                $year=$etg[2];
                $ym=$etg[2]."".$etg[1];
                $tgl=$etg[2]."-".$etg[1]."-".$etg[0];
                $time=$etg[2]."-".$etg[1]."-".$etg[0]." ".$etg[3].":".$etg[4].":".$etg[5];
                $tgl2=strtotime($time);

//echo $k.". ".count($c)."; ".$c[0]."; ".$c[1]."; ".$sid."; ".$time."; ".$c[2]."; ".$c[3]."; ".$kredit."; ".$debit."; ".$saldo."; ".$desc2."<br>";
            $idt=array(
              'id'=>$id2,
                'rek'=>1494762650,
                'curr'=>'IDR',
                'year'=>$year,
                'month'=>$ym,
                'tgl'=>$tgl,
                'tgl2'=>$tgl2,
                'seq'=>$c[0],
                'keterangan'=>trim($desc2),
                'kredit'=>$kredit,
                'debit'=>$debit,
                'saldo'=>$saldo,
                'jurnal'=>$c[3],
                'branch'=>$c[2],
              );
              $udt=array(
                'year'=>$year,
                'month'=>$ym,
                'tgl'=>$tgl,
                'tgl2'=>$tgl2,
                'seq'=>$c[0],
                'keterangan'=>trim($desc2),
                'kredit'=>$kredit,
                'debit'=>$debit,
                'saldo'=>$saldo,
                'jurnal'=>$c[3],
                'branch'=>$c[2],
              );
              InsertUpdate($db,"bnipt_mutasi",$idt,$udt,1);
              
            echo "<br>";
            $id2++;
              }
            }
          }
          break;        
        
      case "mandiript_mutasi";
          list_mandiript_mutasi($q,$col,$q2,$col2,$sortby,$sort,$page);
          break;
        
      case "mandiript_csv";
          f_mutasi3($_GET['rek'],'');
          break;
      case "mandiript_csv2";
          f_mutasi3($_POST['rek'],$_POST['csv']);

$sql4 = "select * from mandiript_mutasi order by id desc limit 1";
          $res4 = mysqli_query($db, $sql4);
          $rw4 = mysqli_fetch_assoc($res4);
          if(isset($rw4['id'])) {
            $id2=$rw4['id']+1;
          } else {
            $id2=1;
          }

$lines = explode(PHP_EOL, $_POST['csv']);

foreach ($lines as $k => $v) {
            $seq=$k+1;
            $c=explode(";",$v);
            if(count($c)>6 && $k>0) {
                $etg=explode(" ",strtolower($c[2]));
                $time=$etg[2]."-".$ar['bulan'][$etg[1]]."-".$etg[0]." ".$etg[3];
                $year=$etg[2];
                $ym=$etg[2]."".$ar['bulan'][$etg[1]];
                $tgl=$etg[2]."-".$ar['bulan'][$etg[1]]."-".$etg[0];
                
                $tgl2=strtotime($time);
                if($c[4]!='') {
                    $desc = preg_replace('/\s+/', ' ', $c[4]);
                } else {
                    $desc="";
                }
                //echo $k.". ".$c[0]."; ".$c[1]."; ".$time."; ".$c[5]."; ".$c[6]."; ".$c[7]."; ".$desc;
                
              $idt=array(
              'id'=>$id2,
                'rek'=>$c[0],
                'curr'=>$c[1],
                'year'=>$year,
                'month'=>$ym,
                'tgl'=>$tgl,
                'tgl2'=>$tgl2,
                'seq'=>$k,
                'keterangan'=>trim($desc),
                'kredit'=>$c[6],
                'debit'=>$c[5],
                'saldo'=>$c[7],
              );
              $udt=array(
                'rek'=>$c[0],
                'curr'=>$c[1],
                'year'=>$year,
                'month'=>$ym,
                'tgl'=>$tgl,
                'tgl2'=>$tgl2,
                'seq'=>$k,
                'keterangan'=>trim($desc),
                'kredit'=>$c[6],
                'debit'=>$c[5],
                'saldo'=>$c[7],
              );
              InsertUpdate($db,"mandiript_mutasi",$idt,$udt,1);
            echo "<br>";
            $id2++;
            }
          }
          break;
        
      case "mandiri_mutasi2";
          f_mutasi2($_POST['rek'],$_POST['csv'],$_POST['year']);
          
          $lines = explode(PHP_EOL, $_POST['csv']);
          $lines2 = preg_replace("/\,/","",$lines);
          foreach ($lines2 as $k => $v) {
              $s=$k+1;
              /*
            $c=explode(" ",$v);
            $jc=count($c);
            if($jc>5){
            echo $k.". ".$jc."; ".$c[0]."; ".$c[3]."; ".$c[5]."<br>";
            }*/
            $idt=array(
              'seq'=>$k,
              'text'=>$v,
              'rek'=>$_POST['rek'],
            );
            Insert($db,"csv_m",$idt,1);

}
          break;

case "mandiri_list_mutasi";
          list_mandiri_mutasi($q,$col,$q1,$col1,$q2,$col2,$sortby,$sort,$page);
          break;

case "add";
          add();
          break;

case "add2";
          $sql4 = "select * from bank order by id desc limit 1";
          $res4 = mysqli_query($db, $sql4);
          $rw4 = mysqli_fetch_assoc($res4);
          $id2=$rw4['id']+1;

$udata=array(
              'id'=>$id2,
              'cif'=>$_POST['cif'],
              'balance'=>$_POST['balance'],
              'bank_name'=>$_POST['bank_name'],
              'swift_code'=>$_POST['swift_code'],
              'account_name'=>$_POST['account_name'],
              'account_number'=>$_POST['account_number'],
              'update_at'=>time(),
          );
          Insert($db,"bank",$udata,0);
          listbank($q,$col,$q2,$col2,$sortby,$sort,$page);
          break;

case "mandiri_mutasi";
          f_mutasi2($_GET['rek'],'','');
          break;

case "mandiri_mutasi2old";
          f_mutasi2($_POST['rek'],$_POST['csv'],$_POST['year']);
          $lines = explode(PHP_EOL, $_POST['csv']);
          $lines2=mandiri_mutasi($lines);

$sql4 = "select * from mandiri_mutasi order by id desc limit 1";
          $res4 = mysqli_query($db, $sql4);
          $rw4 = mysqli_fetch_assoc($res4);
          if(isset($rw4['id'])) {
            $id2=$rw4['id']+1;
          } else {
            $id2=1;
          }
          
          foreach ($lines2 as $k => $v) {          
            echo $v."<br>";
            $seq=$k+1;

if (strpos($v, ';')) { 
                $e_line=explode(";",$v);
                $v2=$e_line[0];
                $remark=$e_line[1];
            }  else {
                $v2=$v;
                $remark="";
            }

$col=explode(" ",$v2);
            $etgl=explode("/",$col[0]);

foreach ($col as $k3 => $v3) {
              //echo $seq."-".$k3.": ".$v3." ";
            }

if(!isset($col[5])) {
              $saldo=$col[4];
            } else {
              $saldo=$col[5];
            }

$idt=array(
              'id'=>$id2,
              'rek'=>$_POST['rek'],
              'year'=>$_POST['year'],
              'tgl'=>$_POST['year'].'-'.$etgl[1].'-'.$etgl[0],
              'month'=>$_POST['year'].''.$etgl[1],
              'seq'=>$seq,
              'keterangan'=>$col[2],
              'jumlah'=>$col[3],
              'kd'=>$col[4],
              'saldo'=>to_numeric(substr($saldo,0,-3)),
              'remark'=>$remark,
            );
            $udt=array(
              'month'=>$_POST['year'].''.$etgl[1],
              'tgl'=>$_POST['year'].'-'.$etgl[1].'-'.$etgl[0],
              'keterangan'=>$col[2],
              'jumlah'=>$col[3],
              'kd'=>$col[4],
              'saldo'=>to_numeric(substr($saldo,0,-3)),
              'remark'=>$remark,
              'update_at'=>time(),
            );
            if($_POST['tes']==0) {
            //InsertUpdate($db,"mandiri_mutasi",$idt,$udt,1);   
            }         
            $id2++;
          }
          
          break;

case "edit";
          edit($_GET['id']);
          break;

case "edit2";
          $udata=array(
              'cif'=>$_POST['cif'],
              'currency'=>$_POST['currency'],
              'balance'=>$_POST['balance'],
              'min_saldo'=>$_POST['min_saldo'],
              'bank_name'=>$_POST['bank_name'],
              'swift_code'=>$_POST['swift_code'],
              'account_name'=>$_POST['account_name'],
              'account_number'=>$_POST['account_number'],
              'update_at'=>time(),
          );
          Update($db,"bank",$udata,"id=".$_POST['id'],0);
          listbank($q,$col,$q2,$col2,$sortby,$sort,$page);
          break;

case "del";
          $udata=array(
          'st'=>0,
          'update_at'=>time(),
          );
          Update($db,"bank",$udata,"id=".$_GET['id'],0);
          listbank($q,$col,$q2,$col2,$sortby,$sort,$page);
          break;

case "reset";
          $udata=array(
          'st'=>1,
          'update_at'=>time(),
          );
          Update($db,"bank",$udata,"",0);
          listbank($q,$col,$q2,$col2,$sortby,$sort,$page);

case "list";
      default;
      listbank($q,$col,$q2,$col2,$sortby,$sort,$page);
    }
    
    ?>
      
  </div>
</main>

<?php
function listbank($q,$col,$q2,$col2,$sortby,$sort,$page) {
    global $db,$ar;
    
    //print_r($ar);
    ?>
    <h3>List</h3>     
    <table class="table table-bordered table-striped" id="dataTable_4d" width="100%" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>ID</th>
                <th>Bank</th>
                <th>Account</th>
                <th>Name</th>
                <th>Balance</th>
                <th>MinSaldo</th>
                <th>Curr</th>
                <th>Update</th>
                <th>Menu</th>
            </tr>
        </thead>

<tbody>
        <?php
        $sql = "select * from bank where st>0 ";
        
        if($col!='') {
            $sql .= " and ".$col."='".$q."' ";
        }

if($col2!='') {
            $sql .= " and ".$col2."='".$q2."' ";
        }
        
        $sql .= " order by ".$sortby." ".$sort." ";
        $res = mysqli_query($db, $sql);
        //echo $sql;
        $j_balance=$j['min_saldo']=0;
        while($rw = mysqli_fetch_assoc($res)) {
          $j_balance=$j_balance+$rw['balance'];
          $j['min_saldo']=$j['min_saldo']+$rw['min_saldo'];
        
        ?>
        
            <tr>
                <td><?=$rw['id'];?></td>
                <td><?=$rw['bank_name'];?></td>
                <td><?=$rw['account_number'];?></td>
                <td><?=$rw['account_name'];?></td>
                <td class="text-right"><?=ang2($rw['balance']);?></td>
                <td class="text-right"><?=ang2($rw['min_saldo']);?></td>
                <td><?=$rw['currency'];?></td>
                <td><?=date("y-m-d h:i:s",$rw['update_at']);?></td>
                <td nowrap>
                <a class="btn btn-xs btn-color-green" href="?op=bank&op2=edit&id=<?=$rw['id'];?>">edit</a>                  
                <a class="btn btn-xs btn-color-blue" href="?op=bank&op2=bca_mutasi&rek=<?=$rw['account_number'];?>">bca</a>
                <a class="btn btn-xs btn-color-orange" href="?op=bank&op2=mandiri_mutasi&rek=<?=$rw['account_number'];?>">mandiri</a>                  
                </td>
            </tr>
          <?php
          }
          ?>  
            
        </tbody>
        <tfoot>
            <tr class="table-danger">
                <th colspan="4"></th>
                <th class="text-right"><?=ang2($j_balance);?></th>
                <th class="text-right"><?=ang2($j['min_saldo']);?></th>
                <th colspan="3"></th>
            </tr>
        </tfoot>

</table>
        
    <?php
    
}

function edit($id) {
    global $db,$ar;
    
    $sql = "select * from bank where id=".$id;
    $res = mysqli_query($db, $sql);
    //echo $sql;
    $rw = mysqli_fetch_assoc($res);    
    ?>
    <h3>Edit</h3>
    <form action="index.php?op=bank&op2=edit2" method="post" enctype="multipart/form-data">
    <input type="hidden" name="id" value="<?=$id;?>">

<div class="form-group row">
          <label for="cif" class="col-sm-1 col-form-label">CIF</label>
          <div class="col-sm-2">
              <input type="text" value="<?=$rw['cif'];?>" class="form-control" name="cif">
          </div>
          <label for="bank_name" class="col-sm-1 col-form-label">Bank Name</label>
          <div class="col-sm-2">
              <input type="text" value="<?=$rw['bank_name'];?>" class="form-control" name="bank_name">
          </div>

<label for="swift_code" class="col-sm-1 col-form-label">SWIFT Code</label>
          <div class="col-sm-2">
              <input type="text" value="<?=$rw['swift_code'];?>" class="form-control" name="swift_code">
          </div>
          <label for="account_name" class="col-sm-1 col-form-label">Account Name</label>
          <div class="col-sm-2">
              <input type="text" value="<?=$rw['account_name'];?>" class="form-control" name="account_name">
          </div>
      </div>

<div class="form-group row">
          <label for="account_number" class="col-sm-1 col-form-label">Rekening</label>
          <div class="col-sm-2">
              <input type="text" value="<?=$rw['account_number'];?>" class="form-control" name="account_number">
          </div>
          <label for="balance" class="col-sm-1 col-form-label">Saldo</label>
          <div class="col-sm-2">
              <input type="text" value="<?=$rw['balance'];?>" class="form-control" name="balance">
          </div>
          <label for="min_saldo" class="col-sm-1 col-form-label">Min Saldo</label>
          <div class="col-sm-2">
              <input type="text" value="<?=$rw['min_saldo'];?>" class="form-control" name="min_saldo">
          </div>
          <label for="currency" class="col-sm-1 col-form-label">currency</label>
          <div class="col-sm-2">
              <input type="text" value="<?=$rw['currency'];?>" class="form-control" name="currency">
          </div>
      </div>

<div class="form-group row">
          <div class="col-sm-10 offset-sm-2 text-right">
              <a href="?op=bank&op2=del&id=<?=$id;?>" class="btn btn-danger">Delete</a> <button type="submit" name="submit" class="btn btn-primary">Update</button>
          </div>
      </div>
  </form>
      
    <?php

}

function add() {
    global $db,$ar;
    
  
    ?>
    <h3>Add</h3>
    <form action="index.php?op=bank&op2=add2" method="post" enctype="multipart/form-data">
      <div class="form-group row">
          <label for="cif" class="col-sm-2 col-form-label">CIF</label>
          <div class="col-sm-4">
              <input type="text" class="form-control" name="cif">
          </div>
          <label for="bank_name" class="col-sm-2 col-form-label">Bank Name</label>
          <div class="col-sm-4">
              <input type="text" class="form-control" name="bank_name">
          </div>
      </div>

<div class="form-group row">
          <label for="swift_code" class="col-sm-2 col-form-label">SWIFT Code</label>
          <div class="col-sm-4">
              <input type="text" class="form-control" name="swift_code">
          </div>
          <label for="account_name" class="col-sm-2 col-form-label">Account Name</label>
          <div class="col-sm-4">
              <input type="text" class="form-control" name="account_name">
          </div>
      </div>

<div class="form-group row">
          <label for="account_number" class="col-sm-2 col-form-label">Rekening</label>
          <div class="col-sm-4">
              <input type="text" class="form-control" name="account_number">
          </div>
          <label for="balance" class="col-sm-2 col-form-label">Saldo</label>
          <div class="col-sm-4">
              <input type="text" class="form-control" name="balance">
          </div>
      </div>

<div class="form-group row">
          <div class="col-sm-10 offset-sm-2 text-right">
              <button type="submit" name="submit" class="btn btn-primary">Add</button>
          </div>
      </div>
    </form>
       
    <?php

}

function f_mutasi($rek,$csv,$year) {
    global $db,$ar;
    ?>
    <h3>Export Mutasi BCA</h3>
    <form action="index.php?op=bank&op2=bca_mutasi2" method="post" enctype="multipart/form-data">
      <input type="hidden" name="rek" value="<?=$rek;?>">
      <div class="form-group row">
          
          <div class="col-sm-2">
            <label for="year" class="col-form-label">Year</label>
              <input type="text" value="<?=$year;?>" class="form-control" name="year">
          </div>
          
          <div class="col-sm-10">
            <label for="cif" class="col-form-label">CSV</label>
            <textarea class="form-control" name="csv" rows="10"><?=$csv;?></textarea>
              
          </div>
      </div>

<div class="form-group row">
          <div class="col-sm-10 offset-sm-2 text-right">
              <button type="submit" name="submit" class="btn btn-primary">Submit</button>
          </div>
      </div>
    </form>
    <?php
}

function f_mutasi2($rek,$csv,$year) {
    global $db,$ar;
    ?>
    
    <form action="index.php?op=bank&op2=mandiri_mutasi2" method="post" enctype="multipart/form-data">
      <input type="hidden" name="rek" value="<?=$rek;?>">
      <div class="form-group row">
          
          <div class="col-sm-2">
            <label for="year" class="col-form-label">Thn</label>
              <input type="text" value="<?=$year;?>" class="form-control" name="year">
              <input type="text" value="" class="form-control" name="tes">

</div>
          
          <div class="col-sm-10">
            <label for="cif" class="col-form-label">CSV</label>
            <textarea class="form-control" name="csv" rows="10"><?=$csv;?></textarea>
              
          </div>
      </div>

function f_mutasi3($rek,$csv) {
    global $db,$ar;
    ?>
    <h3>Import CSV Mandiri PT</h3>
    <form action="index.php?op=bank&op2=mandiript_csv2" method="post" enctype="multipart/form-data">
      <input type="hidden" name="rek" value="<?=$rek;?>">
      <div class="form-group row">
          <div class="col-sm-11">
            <label for="cif" class="col-form-label">CSV</label>
            <textarea class="form-control" required name="csv" rows="10"><?=$csv;?></textarea>
              
          </div>
          <div class="col-sm-1">
              <p><br><br></p>
              <button type="submit" name="submit" class="btn btn-primary">Submit</button>
              <br>
              <p>format yg diperkenankan:<br>
    <a href="storage/mandiri.pt.txt" target="_blank">mandiri.pt.txt</a></p>
          </div>
      </div>

</form>
    
    <?php
}
function f_mutasi4($rek,$csv) {
    global $db,$ar;
    ?>
    <h3>Import Text BNI PT</h3>
    <form action="index.php?op=bank&op2=bnipt_csv2" method="post" enctype="multipart/form-data">
      <input type="hidden" name="rek" value="<?=$rek;?>">
      <div class="form-group row">
          <div class="col-sm-11">
            <label for="cif" class="col-form-label">CSV</label>
            <textarea class="form-control" name="csv" rows="10"><?=$csv;?></textarea>
              
          </div>
          <div class="col-sm-1"><p><br></p>
              <button type="submit" name="submit" class="btn btn-primary">Submit</button>
              <br><br>
              format yg diperkenankan:<br>
    <a href="storage/bni.pt.txt" target="_blank">bni.pt.txt</a><br>
          </div>
      </div>

</form>
    
    <?php
}

function f_mutasi5($rek,$year,$csv) {
    global $db,$ar;
    ?>
    <h3>Import CSV Mandiri Pribadi</h3>
    <form action="index.php?op=bank&op2=mandiri_csv2" method="post" enctype="multipart/form-data">
      
      <div class="form-group row">
          <div class="col-sm-11">
            <label for="cif" class="col-form-label">CSV</label>
            <textarea class="form-control" required name="csv" rows="10"><?=$csv;?></textarea>
              
          </div>
          <div class="col-sm-1">
            <label for="year" class="col-form-label">Thn</label>
              <input type="text" value="<?=$year;?>" required class="form-control" name="year">
              <br>
              <label for="rek" class="col-form-label">Rek</label>
              <input type="text" value="<?=$rek;?>" required class="form-control" name="rek">
              <br>
              <button type="submit" name="submit" class="btn btn-primary">Submit</button>
              <br>
              format yg diperkenankan:<br>
    <a href="storage/mandiri.txt" target="_blank">mandiri.txt</a>
          </div>
      </div>
    </form>
    
    <?php
}

function f_bca_csv($rek,$year,$csv) {
    global $db,$ar;
    ?>
    <h3>Import CSV BCA</h3>
    <form action="index.php?op=bank&op2=bca_csv2" method="post" enctype="multipart/form-data">
      
      <div class="form-group row">
          <div class="col-sm-11">
            <label for="cif" class="col-form-label">CSV</label>
            <textarea class="form-control" required name="csv" rows="10"><?=$csv;?></textarea>
              
          </div>
          <div class="col-sm-1">
            <label for="year" class="col-form-label">Thn</label>
              <input type="text" value="<?=$year;?>" required class="form-control" name="year">
              <br>
              <label for="rek" class="col-form-label">Rek</label>
              <input type="text" value="<?=$rek;?>" required class="form-control" name="rek">
              <br>
              <button type="submit" name="submit" class="btn btn-primary">Submit</button>
              <br>
              format yg diperkenankan:<br>
    <a href="storage/bca.txt" target="_blank">bca.txt</a>
          </div>
      </div>
    </form>
    
    <?php
}

function f_mandiri_json($json,$rek) {
    global $db,$ar;
    ?>
    <h3>Import Mandiri Json</h3>
    <form action="index.php?op=bank&op2=mandiri_json2" method="post" enctype="multipart/form-data">
      
      <div class="form-group row">
          <div class="col-sm-9">
            <label for="json" class="col-form-label">json</label>
            <textarea class="form-control" name="json" rows="10"><?=$json;?></textarea>              
          </div>
          <div class="col-sm-2">
                        
          </div>
          <div class="col-sm-1">
              <label for="rek" class="col-form-label">rek</label>
              <input type="text" value="<?=$rek;?>" required class="form-control" name="rek">
              <br>            
              <button type="submit" name="submit" class="btn btn-primary">Submit</button>
              <br>
              format yg diperkenankan:<br>
    <a href="storage/mandiri.json" target="_blank">mandiri.json</a>
              <br>gunakan nodesj/nibras/node app.xls.js
          </div>
      </div>
    </form>
    
    <?php
}

function f_jago_csv($csv,$csv2,$month) {
    global $db,$ar;
    ?>
    <h3>Import CSV Jago</h3>
    <form action="index.php?op=bank&op2=jago_csv2" method="post" enctype="multipart/form-data">
      
      <div class="form-group row">
          <div class="col-sm-9">
            <label for="cif" class="col-form-label">CSV2</label>
            <textarea class="form-control" name="csv2" rows="10"><?=$csv2;?></textarea>              
          </div>
          <div class="col-sm-2">
            <label for="cif" class="col-form-label">CSV</label>
            <textarea class="form-control" required name="csv" rows="10"><?=$csv;?></textarea>              
          </div>
          <div class="col-sm-1">
              <label for="month" class="col-form-label">month</label>
              <input type="text" value="<?=$month;?>" required class="form-control" name="month">
              <br>            
              <button type="submit" name="submit" class="btn btn-primary">Submit</button>
              <br>
              format yg diperkenankan:<br>
    <a href="storage/jago.txt" target="_blank">jago.txt</a>
          </div>
      </div>
    </form>
    
    <?php
}

function list_jago_mutasi($q,$col,$q2,$col2,$sortby,$sort,$page) {
    global $db,$ar;
    
    //print_r($ar);
    ?>
    <h3>List</h3>     
    <table class="table table-bordered table-striped" id="dataTable_5a" width="100%" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>ID</th>
                <th>Rek</th>
                <th>Y</th>
                <th>Month</th>
                <th>Tgl</th>
                <th>Seq</th>
                
                <th>ActId</th>
                <th>Descr</th>
                <th>Remark</th>
                
                <th>debit</th>
                <th>kredit</th>
                <th>Saldo</th>
                <th>debit</th>
                <th>kredit</th>
                <th>Saldo</th>
                <th>Menu</th>
            </tr>
        </thead>

<tbody>
        <?php
        $sql = "select * from jago_mutasi where id>0 ";
        
        if($col!='') {
            $sql .= " and `".$col."`='".$q."' ";
        }

if($col2!='') {
            $sql .= " and `".$col2."`='".$q2."' ";
        }
        
        $sql .= " order by ".$sortby." ".$sort." ";
        $res = mysqli_query($db, $sql);
        //echo $sql;
        $j['d']=$j['k']=$s=0;
        while($rw = mysqli_fetch_assoc($res)) {
          $j['d']=$j['d']+$rw['debit'];
          $j['k']=$j['k']+$rw['kredit'];
          if($rw['action_id']==0) {
              $emn='<a class="btn btn-xs btn-color-red text-white" id="btn-exp-'.$rw['id'].'" onclick="jagoExp('.$rw['id'].');">Exp</a>';
          } else {
              $emn='';
          }
          
        
        ?>
        
            <tr>
                <td><?=$rw['id'];?></td>
                <td><a href="?op=bank&op2=jago_list_mutasi&col=rek&q=<?=$rw['rek'];?>"><?=substr($rw['rek'],0,4);?></a></td>
                <td><a href="?op=bank&op2=jago_list_mutasi&col2=rek&q2=<?=$rw['rek'];?>&col=year&q=<?=$rw['year'];?>"><?=$rw['year'];?></a></td>
                <td><a href="?op=bank&op2=jago_list_mutasi&col2=rek&q2=<?=$rw['rek'];?>&col=month&q=<?=$rw['month'];?>"><?=$rw['month'];?></a></td>
                <td><?=date("Y-m-d H:i",$rw['tgl2']);?></td>
                <td><?=$rw['seq'];?></td>
                
                <td><a href="?op=action&op2=edit&id=<?=$rw['action_id'];?>"><?=$rw['action_id'];?></a></td>
                <td><?=$rw['keterangan'];?></td>
                
                <td contenteditable="true" onBlur="colUpdate(this,'remark',<?=$rw['id'];?>,'jago_mutasi')" onClick="editRow(this);"><?=$rw['remark'];?></td>
                
                <td contenteditable="true" onBlur="colUpdate(this,'debit',<?=$rw['id'];?>,'jago_mutasi')" onClick="editRow(this);"><?=$rw['debit'];?></td>
                
                <td contenteditable="true" onBlur="colUpdate(this,'kredit',<?=$rw['id'];?>,'jago_mutasi')" onClick="editRow(this);"><?=$rw['kredit'];?></td>
                <td contenteditable="true" onBlur="colUpdate(this,'saldo',<?=$rw['id'];?>,'jago_mutasi')" onClick="editRow(this);"><?=$rw['saldo'];?></td>
                <td class="text-right"><?=ang2($rw['debit']);?></td>
                <td class="text-right"><?=ang2($rw['kredit']);?></td>
                <td class="text-right"><?=ang2($rw['saldo']);?></td>
                <td nowrap>
                    <?=$emn;?>     
                  
                </td>
            </tr>
          <?php
          }
          $j['s']=$j['d']-$j['k'];
          ?>  
            
        </tbody>
        <tfoot>
            <tr class="table-info">
                <th colspan="12"></th>
                <th class="text-right"><?=ang2($j['d']);?></th>
                <th class="text-right"><?=ang2($j['k']);?></th>
                <th class="text-right red lighten-5"><?=ang2($j['s']);?></th>
                <th></th>
                
            </tr>
        </tfoot>
    </table><?=$sql;?><br>
    <script>
    function editRow(val) {
      $(val).css("background","#e1bee7");
    }
    function colUpdate(val,col,id,tbl) {
      $(val).css("background","#e1bee7 url(loaderIcon.gif) no-repeat right");
      $.ajax({
        url: "tbl.update.php",
        type: "POST",
        data:'tbl='+tbl+'&col='+col+'&val='+$(val).text()+'&id='+id,
        success: function(data){
          $(val).css("background","#FDFDFD");
        }
      });
    }
    function jagoExp(id) {
      //$(val).css("background","#e1bee7 url(loaderIcon.gif) no-repeat right");
      $.ajax({
        url: "exp_jago2action.php",
        type: "POST",
        data:'id='+id,
        success: function(data){
          $("#btn-exp-"+id).remove();
        }
      });
    }        
    </script>
        
    <?php
    
}

function list_bca_mutasi($q,$col,$q1,$col1,$q2,$col2,$sortby,$sort,$page) {
    global $db,$ar;
    
    //print_r($ar);
    ?>
    <h3>List</h3>     
    <table class="table table-bordered table-striped" id="dataTable_5a" width="100%" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>ID</th>
                <th>Rek</th>
                <th>Y</th>
                <th>Month</th>
                <th>Tgl</th>
                <th>Seq</th>
                
                <th>ActId</th>
                <th>Descr</th>
                <th>Remark</th>
                
                <th>debit</th>
                <th>kredit</th>
                <th>Saldo</th>
                <th>debit</th>
                <th>kredit</th>
                <th>Saldo</th>
                <th>Menu</th>
            </tr>
        </thead>

<tbody>
        <?php
        $sql = "select * from bca_mutasi where id>0 ";
        
        if($col!='') {
            $sql .= " and `".$col."`='".$q."' ";
        }

if($col1!='') {
            $sql .= " and `".$col1."`='".$q1."' ";
        }
        if($col2!='') {
            $sql .= " and `".$col2."`='".$q2."' ";
        }
        
        $sql .= " order by ".$sortby." ".$sort." ";
        $res = mysqli_query($db, $sql);
        //echo $sql;
        $j['d']=$j['k']=$s=0;
        while($rw = mysqli_fetch_assoc($res)) {
          $j['d']=$j['d']+$rw['debit'];
          $j['k']=$j['k']+$rw['kredit'];
          if($rw['action_id']==0) {
              $emn='<a class="btn btn-xs btn-color-red text-white" id="btn-exp-'.$rw['id'].'" onclick="bcaExp('.$rw['id'].');">Exp</a>';
          } else {
              $emn='';
          }
          
        
        ?>
        
            <tr>
                <td><?=$rw['id'];?></td>
                <td><a href="?op=bank&op2=bca_list_mutasi&col1=rek&q1=<?=$rw['rek'];?>"><?=substr($rw['rek'],0,4);?></a></td>
                <td><a href="?op=bank&op2=bca_list_mutasi&col1=rek&q1=<?=$rw['rek'];?>&col=year&q=<?=$rw['year'];?>"><?=$rw['year'];?></a></td>
                <td><a href="?op=bank&op2=bca_list_mutasi&col1=rek&q1=<?=$rw['rek'];?>&col=month&q=<?=$rw['month'];?>"><?=$rw['month'];?></a></td>
                <td><?=$rw['tgl'];?></td>
                <td><?=$rw['seq'];?></td>
                
                <td><a href="?op=action&op2=edit&id=<?=$rw['action_id'];?>"><?=$rw['action_id'];?></a></td>
                <td><?=$rw['keterangan'];?></td>
                
                <td contenteditable="true" onBlur="colUpdate(this,'remark',<?=$rw['id'];?>,'bca_mutasi')" onClick="editRow(this);"><?=$rw['remark'];?></td>
                
                <td contenteditable="true" onBlur="colUpdate(this,'debit',<?=$rw['id'];?>,'bca_mutasi')" onClick="editRow(this);"><?=$rw['debit'];?></td>
                
                <td contenteditable="true" onBlur="colUpdate(this,'kredit',<?=$rw['id'];?>,'bca_mutasi')" onClick="editRow(this);"><?=$rw['kredit'];?></td>
                <td contenteditable="true" onBlur="colUpdate(this,'saldo',<?=$rw['id'];?>,'bca_mutasi')" onClick="editRow(this);"><?=$rw['saldo'];?></td>
                <td class="text-right"><?=ang2($rw['debit']);?></td>
                <td class="text-right"><?=ang2($rw['kredit']);?></td>
                <td class="text-right"><?=ang2($rw['saldo']);?></td>
                <td nowrap>
                    <?=$emn;?>     
                  
                </td>
            </tr>
          <?php
          }
          $j['s']=$j['d']-$j['k'];
          ?>  
            
        </tbody>
        <tfoot>
            <tr class="table-info">
                <th colspan="12"></th>
                <th class="text-right"><?=ang2($j['d']);?></th>
                <th class="text-right"><?=ang2($j['k']);?></th>
                <th class="text-right red lighten-5"><?=ang2($j['s']);?></th>
                <th></th>
                
            </tr>
        </tfoot>
    </table><?=$sql;?><br>
    <script>
    function editRow(val) {
      $(val).css("background","#e1bee7");
    }
    function colUpdate(val,col,id,tbl) {
      $(val).css("background","#e1bee7 url(loaderIcon.gif) no-repeat right");
      $.ajax({
        url: "tbl.update.php",
        type: "POST",
        data:'tbl='+tbl+'&col='+col+'&val='+$(val).text()+'&id='+id,
        success: function(data){
          $(val).css("background","#FDFDFD");
        }
      });
    }
    function bcaExp(id) {
      //$(val).css("background","#e1bee7 url(loaderIcon.gif) no-repeat right");
      $.ajax({
        url: "exp_bca2action.php",
        type: "POST",
        data:'id='+id,
        success: function(data){
          $("#btn-exp-"+id).remove();
        }
      });
    }        
    </script>
        
    <?php
    
}

function list_mandiri_mutasi($q,$col,$q1,$col1,$q2,$col2,$sortby,$sort,$page) {
    global $db,$ar;
    
    //print_r($ar);
    ?>
    <h3>List</h3>     
    <table class="table table-bordered table-striped" id="dataTable_5a" width="100%" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>ID</th>
                <th>Rek</th>
                <th>Y</th>
                <th>Month</th>
                <th>Tgl</th>
                <th>Seq</th>
                <th></th>
                <th>ActId</th>
                <th>Descr</th>
                <th>Remark</th>
                <th>To</th>
                <th>debit</th>
                <th>kredit</th>
                <th>Saldo</th>
                <th>debit</th>
                <th>kredit</th>
                <th>Saldo</th>
                <th>Menu</th>
            </tr>
        </thead>

<tbody>
        <?php
        $sql = "select * from csv_m where id>0 ";
        
        if($col!='') {
            $sql .= " and `".$col."`='".$q."' ";
        }

if($col1!='') {
            $sql .= " and `".$col1."`='".$q1."' ";
        }

if($col2!='') {
            $sql .= " and `".$col2."`='".$q2."' ";
        }
        
        $sql .= " order by ".$sortby." ".$sort." ";
        $res = mysqli_query($db, $sql);
        //echo $sql;
        $j['d']=$j['k']=$s=0;
        while($rw = mysqli_fetch_assoc($res)) {
          $j['d']=$j['d']+$rw['debit'];
          $j['k']=$j['k']+$rw['kredit'];
          if($rw['action_id']==0) {
              $emn='<a class="btn btn-xs btn-color-red text-white" id="btn-exp-'.$rw['id'].'" onclick="manpExp('.$rw['id'].');">Exp</a>';
          } else {
              $emn='';
          }
          
        
        ?>
        
            <tr>
                <td><?=$rw['id'];?></td>
                <td><a href="?op=bank&op2=mandiri_list_mutasi&col1=rek&q1=<?=$rw['rek'];?>"><?=substr($rw['rek'],-4);?></a></td>
                <td><a href="?op=bank&op2=mandiri_list_mutasi&col1=rek&q1=<?=$rw['rek'];?>&col=year&q=<?=$rw['year'];?>"><?=$rw['year'];?></a></td>
                <td><a href="?op=bank&op2=mandiri_list_mutasi&col1=rek&q1=<?=$rw['rek'];?>&col=month&q=<?=$rw['month'];?>"><?=$rw['month'];?></a></td>
                <td><?=$rw['tgl'];?></td>
                <td><?=$rw['seq'];?></td>
                <td><a href="?op=bank&op2=mandiri_list_mutasi&col1=rek&q1=<?=$rw['rek'];?>&col2=inout&q2=<?=$rw['inout'];?>&col=month&q=<?=$rw['month'];?>"><?=$rw['inout'];?></a></td>
                <td><a href="?op=action&op2=edit&id=<?=$rw['action_id'];?>"><?=$rw['action_id'];?></a></td>
                <td><?=$rw['keterangan'];?></td>
                
                <td contenteditable="true" onBlur="colUpdate(this,'remark',<?=$rw['id'];?>,'csv_m')" onClick="editRow(this);"><?=$rw['remark'];?></td>
                <td contenteditable="true" onBlur="colUpdate(this,'payto',<?=$rw['id'];?>,'csv_m')" onClick="editRow(this);"><?=$rw['payto'];?></td>
                <td contenteditable="true" onBlur="colUpdate(this,'debit',<?=$rw['id'];?>,'csv_m')" onClick="editRow(this);"><?=$rw['debit'];?></td>
                
                <td contenteditable="true" onBlur="colUpdate(this,'kredit',<?=$rw['id'];?>,'csv_m')" onClick="editRow(this);"><?=$rw['kredit'];?></td>
                <td contenteditable="true" onBlur="colUpdate(this,'saldo',<?=$rw['id'];?>,'csv_m')" onClick="editRow(this);"><?=$rw['saldo'];?></td>
                <td class="text-right"><?=ang2($rw['debit']);?></td>
                <td class="text-right"><?=ang2($rw['kredit']);?></td>
                <td class="text-right"><?=ang2($rw['saldo']);?></td>
                <td nowrap>
                    <?=$emn;?>     
                  
                </td>
            </tr>
          <?php
          }
          $j['s']=$j['d']-$j['k'];
          ?>  
            
        </tbody>
        <tfoot>
            <tr class="table-info">
                <th colspan="14"></th>
                <th class="text-right"><?=ang2($j['d']);?></th>
                <th class="text-right"><?=ang2($j['k']);?></th>
                <th class="text-right red lighten-5"><?=ang2($j['s']);?></th>
                <th></th>
                
            </tr>
        </tfoot>
    </table><?=$sql;?><br>
    <script>
    function editRow(val) {
      $(val).css("background","#e1bee7");
    }
    function colUpdate(val,col,id,tbl) {
      $(val).css("background","#e1bee7 url(loaderIcon.gif) no-repeat right");
      $.ajax({
        url: "tbl.update.php",
        type: "POST",
        data:'tbl='+tbl+'&col='+col+'&val='+$(val).text()+'&id='+id,
        success: function(data){
          $(val).css("background","#FDFDFD");
        }
      });
    }
    function manpExp(id) {
      //$(val).css("background","#e1bee7 url(loaderIcon.gif) no-repeat right");
      $.ajax({
        url: "exp_m2action.php",
        type: "POST",
        data:'id='+id,
        success: function(data){
          $("#btn-exp-"+id).remove();
        }
      });
    }        
    </script>
        
    <?php
    
}

function list_mandiript_mutasi($q,$col,$q2,$col2,$sortby,$sort,$page) {
    global $db,$ar;
    
    //print_r($ar);
    ?>
    <h3>List</h3>     
    <table class="table table-bordered table-hover" id="dataTable_6a" width="100%" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>ID</th>
                <th>Rek</th>
                <th>Curr</th>
                <th>Year</th>
                <th>Month</th>
                <th>Tgl</th>
                <th>Seq</th>
                <th>ActId</th>
                <th>Descr</th>
                <th>Debit</th>
                <th>Kredit</th>
                <th>Saldo</th>
                <th>Menu</th>
            </tr>
        </thead>

<tbody>
        <?php
        $sql = "select * from mandiript_mutasi where id>0 ";
        
        if($col!='') {
            $sql .= " and ".$col."='".$q."' ";
        }

if($col2!='') {
            $sql .= " and ".$col2."='".$q2."' ";
        }
        
        $sql .= " order by ".$sortby." ".$sort." ";
        $res = mysqli_query($db, $sql);
        //echo $sql;
        $j['d']=$j['k']=0;
        while($rw = mysqli_fetch_assoc($res)) {
          $j['d']=$j['d']+$rw['debit'];
          $j['k']=$j['k']+$rw['kredit'];
          if($rw['action_id']==0) {
              $emn='<a class="btn btn-xs btn-color-red text-white" id="btn-exp-'.$rw['id'].'" onclick="mandiriExp('.$rw['id'].');">Exp</a>';
          } else {
              $emn='';
          }
        ?>
        
            <tr>
                <td><?=$rw['id'];?></td>
                <td><a href="?op=bank&op2=mandiript_mutasi&col=rek&q=<?=$rw['rek'];?>"><?=$rw['rek'];?></a></td>
                <td><?=$rw['curr'];?></td>
                <td><a href="?op=bank&op2=mandiript_mutasi&col=year&q=<?=$rw['year'];?>"><?=$rw['year'];?></a></td>
                <td><a href="?op=bank&op2=mandiript_mutasi&col=month&q=<?=$rw['month'];?>"><?=$rw['month'];?></a></td>
                <td><?=date("y-m-d h:i:s",$rw['tgl2']);?></td>
                <td><?=$rw['seq'];?></td>
                <td><a href="?op=action&op2=edit&id=<?=$rw['action_id'];?>"><?=$rw['action_id'];?></a></td>
                <td><?=$rw['keterangan'];?></td>
                <td class="text-right"><?=ang2($rw['debit']);?></td>
                <td class="text-right"><?=ang2($rw['kredit']);?></td>
                <td class="text-right"><?=ang2($rw['saldo']);?></td>
                <td nowrap>
                  <?=$emn;?>     
                  
                </td>
            </tr>
          <?php
          }
          $j['s']=$j['d']-$j['k'];
          ?>  
            
        </tbody>
        <tfoot>
            <tr class="table-info">
                <th colspan="9"></th>
                <th class="text-right"><?=ang2($j['d']);?></th>
                <th class="text-right"><?=ang2($j['k']);?></th>
                <th class="text-right red lighten-5"><?=ang2($j['s']);?></th>
                <th></th>
            </tr>
        </tfoot>
    </table><?=$sql;?><br>
    <script>
    function mandiriExp(id) {
      //$(val).css("background","#e1bee7 url(loaderIcon.gif) no-repeat right");
      $.ajax({
        url: "exp_mpt2action.php",
        type: "POST",
        data:'id='+id,
        success: function(data){
          $("#btn-exp-"+id).remove();
        }
      });
    }        
    </script>
        
    <?php
    
}

function list_bnipt_mutasi($q,$col,$q2,$col2,$sortby,$sort,$page) {
    global $db,$ar;
    
    //print_r($ar);
    ?>
    <h3>List</h3>     
    <table class="table table-bordered table-hover" id="dataTable_6a" width="100%" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>ID</th>
                <th>Rek</th>
                <th>Curr</th>
                <th>Year</th>
                <th>Month</th>
                <th>Tgl</th>
                <th>Seq</th>
                <th>ActId</th>
                <th>Descr</th>
                <th>Debit</th>
                <th>Kredit</th>
                <th>Saldo</th>
                <th>Menu</th>
            </tr>
        </thead>

<tbody>
        <?php
        $sql = "select * from bnipt_mutasi where id>0 ";
        
        if($col!='') {
            $sql .= " and ".$col."='".$q."' ";
        }

if($col2!='') {
            $sql .= " and ".$col2."='".$q2."' ";
        }
        
        $sql .= " order by ".$sortby." ".$sort." ";
        $res = mysqli_query($db, $sql);
        //echo $sql;
        $j['d']=$j['k']=0;
        while($rw = mysqli_fetch_assoc($res)) {
          $j['d']=$j['d']+$rw['debit'];
          $j['k']=$j['k']+$rw['kredit'];
          if($rw['action_id']==0) {
              $emn='<a class="btn btn-xs btn-color-red text-white" id="btn-exp-'.$rw['id'].'" onclick="bniExp('.$rw['id'].');">Exp</a>';
          } else {
              $emn='';
          }
        ?>
        
            <tr>
                <td><?=$rw['id'];?></td>
                <td><a href="?op=bank&op2=bnipt_mutasi&col=rek&q=<?=$rw['rek'];?>"><?=$rw['rek'];?></a></td>
                <td><?=$rw['curr'];?></td>
                <td><a href="?op=bank&op2=bnipt_mutasi&col=year&q=<?=$rw['year'];?>"><?=$rw['year'];?></a></td>
                <td><a href="?op=bank&op2=bnipt_mutasi&col=month&q=<?=$rw['month'];?>"><?=$rw['month'];?></a></td>
                <td><?=date("y-m-d h:i:s",$rw['tgl2']);?></td>
                <td><?=$rw['seq'];?></td>
                <td><a href="?op=action&op2=edit&id=<?=$rw['action_id'];?>"><?=$rw['action_id'];?></a></td>
                <td><?=$rw['keterangan'];?></td>
                <td class="text-right"><?=ang2($rw['debit']);?></td>
                <td class="text-right"><?=ang2($rw['kredit']);?></td>
                <td class="text-right"><?=ang2($rw['saldo']);?></td>
                <td nowrap>
                    <?=$emn;?>
                    
                </td>
            </tr>
          <?php
          }
          $j['s']=$j['d']-$j['k'];
          ?>  
            
        </tbody>
        <tfoot>
            <tr class="table-info">
                <th colspan="9"></th>
                <th class="text-right"><?=ang2($j['d']);?></th>
                <th class="text-right"><?=ang2($j['k']);?></th>
                <th class="text-right red lighten-5"><?=ang2($j['s']);?></th>
                <th></th>
            </tr>
        </tfoot>
    </table><?=$sql;?><br>
    <script>
    function bniExp(id) {
      //$(val).css("background","#e1bee7 url(loaderIcon.gif) no-repeat right");
      $.ajax({
        url: "exp_bnipt2action.php",
        type: "POST",
        data:'id='+id,
        success: function(data){
          $("#btn-exp-"+id).remove();
        }
      });
    }        
    </script>
    <?php
}
?>