filephp fin2@agn

FilePHP

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

inc.action.php

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

for($a=1;$a<date("n");$a++) {
            ?>
            <a href="?op=action&op2=<?=$op2;?>&col=<?=$col;?>&q=<?=$q;?>&col2=month&q2=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-red" href="?op=action&op2=add&t=1&inout=1">Cash-In</a>
          <a class="btn btn-xs btn-color-pink" href="?op=action&op2=add&t=2&inout=2">Cash-Out</a>
          <a class="btn btn-xs btn-color-purple" href="?op=action&op2=add&t=3&inout=2">Beli</a>
          <a class="btn btn-xs btn-color-indigo" href="?op=action&op2=add&t=4&inout=1">Jual</a>
          <a class="btn btn-xs btn-color-blue" href="?op=action&op2=add&t=5&inout=2">Penyusutan Aset</a>
          <a class="btn btn-xs btn-color-cyan" href="?op=action&op2=add&t=6&inout=2">Penyisihan Piutang</a>
          <a class="btn btn-xs btn-color-brown" href="?op=action&op2=list&col=cat&q=3">Inventory</a><br>
          <?php

$sql1="SELECT * from bank where sel=1";
          $res1=mysqli_query($db,$sql1);
          while($r1=mysqli_fetch_assoc($res1)) {
              echo '<a href="?op=action&op2=list&col=bank&q='.$r1['id'].'&col3=month&q3='.date('Ym', strtotime('last month')).'" class="btn btn-xs btn-color-yellow mt-1 mr-1">'.$r1['id'].'</a>';
          }
          ?><br>
          <a class="btn btn-xs btn-color-brown mt-1" href="?op=action&op2=tool_id2">tool-Id</a>
          <?php if($col2=='month') { echo '<a href="?op=action&op2=list&col=bank&q='.$q.'&col='.$col.'&q2='.$q2.'&col2='.$col2.'&col1=st_trx&q1=0" class="btn btn-xs btn-color-green mt-1">no-trx</a>'; } ?>
      </div>
    </div>

<?php
    switch($op2) {
        
      case "tool_id2";
        tool_id2("action");
        tool_id2("journal");
        tool_id2("transaction");
        tool_id2("account_equation");
        list_action($q,$col,$q1,$col1,$q2,$col2,$q3,$col3,$sortby,$sort,$page);
        break;

case "tool2";
        $sql = "select * from action order by id";
          $res = mysqli_query($db, $sql);
          while($rw = mysqli_fetch_assoc($res)) {
            $udt=array(
                'year'=>date("Y",$rw['action_at']),
                'month'=>date("Ym",$rw['action_at']),
                'tgl'=>date("Y-m-d",$rw['action_at']),
            );
            Update($db,"action",$udt,"id=".$rw['id'],1);
              
          }
      
        break;

case "tool";
          $sql4 = "SELECT * from `action` 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;
          }

$sql = "select * from transaction_old order by action_at asc,id asc ";
          $res = mysqli_query($db, $sql);
          while($rw = mysqli_fetch_assoc($res)) {

$udt=array(
              'id'=>$id2,
              'reff_trx_id'=>$rw['id'],
              'action_at'=>$rw['action_at'],
              'descr'=>$rw['descr'],
              'pay_to'=>$rw['pay_to'],
              'pay_from'=>$rw['pay_from'],
              'url_pdf'=>$rw['url_pdf'],
              'cat'=>$rw['cat'],
              'invoice'=>$rw['invoice'],
              'inout'=>$rw['inout'],
              'bank'=>$rw['bank'],
              'debit'=>$rw['debit'],
              'credit'=>$rw['credit'],
              'amount'=>$rw['amount'],
              'update_at'=>time(),
            );
            Insert($db,"action",$udt,1);
            $id2++;
          }

break;

case "add_trx";
          $sql4 = "select * from action where id=".$_GET['id'];
          $res4 = mysqli_query($db, $sql4);
          $r4 = mysqli_fetch_assoc($res4);
          add_trx($r4,$_GET['d'],$_GET['c']);
          edit($_GET['id']);
          break;

case "copy";
          $sql4 = "select id from action where id2=id 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;
          }

$sql = "select * from action where id=".$_GET['id'];
          $res = mysqli_query($db, $sql);
          $rw = mysqli_fetch_assoc($res);

$idt=array(
              'id'=>$id2,
              'action_at'=>$rw['action_at']+(86400*30),
              'descr'=>$rw['descr'],
              'pay_to'=>$rw['pay_to'],
              'pay_from'=>$rw['pay_from'],
              'cat'=>$rw['cat'],
              'seq'=>$rw['seq'],
              'invoice'=>$rw['invoice'],
              'inout'=>$rw['inout'],
              'bank'=>$rw['bank'],
              'amount'=>$rw['amount'],
              'st'=>1,
              'update_at'=>time(),
          );
          Insert($db,"action",$idt,1);
          tool_id3("action");
          edit($id2);
          break;
    
      case "add";
          add($_GET['t'],$_GET['inout']);
          break;

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

$udata=array(
              'id'=>$id2,
              'action_at'=>strtotime($_POST['action_at']),
              'descr'=>$_POST['descr'],
              'pay_to'=>$_POST['pay_to'],
              'pay_from'=>$_POST['pay_from'],
              //'url_pdf'=>$_POST['url_pdf'],
              'cat'=>$_POST['cat'],
              'invoice'=>$_POST['invoice'],
              'inout'=>$_POST['inout'],
              'bank'=>$_POST['bank'],
              'amount'=>$_POST['amount'],
              'update_at'=>time(),
          );
          Insert($db,"action",$udata,0);
          list_action($q,$col,$q1,$col1,$q2,$col2,$q3,$col3,$sortby,$sort,$page);
          break;

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

case "edit2";
          //echo "<pre>"; print_r($_POST); echo "</pre>";
          $udata=array(
              'action_at'=>strtotime($_POST['action_at']),
              'year'=>date("Y",strtotime($_POST['action_at'])),
              'month'=>date("Ym",strtotime($_POST['action_at'])),
              'tgl'=>date("Y-m-d",strtotime($_POST['action_at'])),
              'descr'=>$_POST['descr'],
              'pay_to'=>$_POST['pay_to'],
              'pay_from'=>$_POST['pay_from'],
              //'url_pdf'=>$_POST['url_pdf'],
              'cat'=>$_POST['cat'],
              'seq'=>$_POST['seq'],
              'invoice'=>$_POST['invoice'],
              'inout'=>$_POST['inout'],
              'bank'=>$_POST['bank'],
              'amount'=>$_POST['amount'],
              'update_at'=>time(),
          );
          Update($db,"action",$udata,"id=".$_POST['id'],1);
          if(isset($_FILES['file']['tmp_name']) && ($_FILES['file']['tmp_name']!='')) {
              UploadImage($_POST,$_FILES,'action');
          }
          $col="bank"; $q=$_POST['bank'];
          list_action($q,$col,$q1,$col1,$q2,$col2,$q3,$col3,$sortby,$sort,$page);
          break;

case "edit_inventory2";
          echo "<pre>"; print_r($_POST); echo "</pre>";
          $udata=array(
              'name'=>$_POST['name'],
              'brand'=>$_POST['brand'],
              'qty'=>$_POST['qty'],
              'unit'=>$_POST['unit'],
              'remark'=>$_POST['remark'],
              'position'=>$_POST['position'],
              'group'=>$_POST['group'],
              'condition'=>$_POST['condition'],
              'purchase_date'=>strtotime($_POST['purchase_date']),
              'will_age'=>$_POST['will_age'],
              'price_per_unit'=>$_POST['price_per_unit'],
              'value'=>$_POST['price_per_unit']*$_POST['qty'],
              'update_at'=>time(),
          );
          Update($db,"inventory",$udata,"action_id=".$_POST['action_id'],1);
          break;

case "del";
          delete($db,"account_equation","action_id=".$_GET['id'],1);
          delete($db,"journal","action_id=".$_GET['id'],1);
          delete($db,"transaction","action_id=".$_GET['id'],1);
          delete($db,"action","id=".$_GET['id'],1);
          list_action($q,$col,$q1,$col1,$q2,$col2,$q3,$col3,$sortby,$sort,$page);
          break;

case "reset";
          $udata=array(
          'st'=>1,
          'update_at'=>time(),
          );
          Update($db,"action",$udata,"",0);
          list_action($q,$col,$q1,$col1,$q2,$col2,$q3,$col3,$sortby,$sort,$page);

case "list";
      default;
      list_action($q,$col,$q1,$col1,$q2,$col2,$q3,$col3,$sortby,$sort,$page);
    }
    
    ?>
      
  </div>
</main>

<?php
function list_action($q,$col,$q1,$col1,$q2,$col2,$q3,$col3,$sortby,$sort,$page) {
    global $db,$ar;

//print_r($ar);
    ?>
    <h3>List</h3>     
    <table class="table table-bordered table-striped" id="dataTable_1d" width="100%" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>ID</th>
                <th>At</th>
                <th>Y</th>
                <th>m</th>
                <th>seq</th>
                <th>B</th>
                <th>Descr</th>
                <th>Amount</th>
                <th>To</th>
                <th>From</th>
                <th>Cat</th>
                <th>Inout</th>
                
                <th>Trx</th>
                <th>Jour</th>
                <th>Equ</th>
                <th>d</th>
                <th>k</th>
                <th>Update</th>
                <th>Menu</th>
                <th>Menu</th>
            </tr>
        </thead>

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

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

if($col2!='') {
            $sql .= " and `".$col2."`='".$q2."' ";
        }

if($col3!='') {
            $sql .= " and `".$col3."`='".$q3."' ";
        }
        
        $sql .= " order by ".$sortby." ".$sort." ";
        $res = mysqli_query($db, $sql);
        //echo $sql;
        while($rw = mysqli_fetch_assoc($res)) {
        
          $sql2="SELECT debit,credit,count(*) as jum from transaction where action_id=".$rw['id'];
          $res2 = mysqli_query($db, $sql2);
          $r2 = mysqli_fetch_assoc($res2);
        
          $sql3="SELECT count(*) as jum from journal where action_id=".$rw['id'];
          $res3 = mysqli_query($db, $sql3);
          $r3 = mysqli_fetch_assoc($res3);

$sql4="SELECT count(*) as jum from account_equation where action_id=".$rw['id'];
          $res4 = mysqli_query($db, $sql4);
          $r4 = mysqli_fetch_assoc($res4);

if($rw['pay_to']!='') {
            $pay_to = '<a href="?op=action&op2=list&col=pay_to&q='.$rw['pay_to'].'">'.$rw['pay_to'].'</a>';
          } else {
            $pay_to='';
          }

if($rw['pay_from']!='') {
            $pay_from = '<a href="?op=action&op2=list&col=pay_from&q='.$rw['pay_from'].'">'.$rw['pay_from'].'</a>';
          } else {
            $pay_from='';
          }
          
          if($r2['jum']>0) {
              //$trx_menu='<a class="btn btn-xs btn-color-pink" href="?op=transaction&op2=edit&id='.$rw['id'].'">Edit Transaction</a>';
              $trx_menu='<a class="btn btn-xs btn-color-green" href="?op=action&op2=add_trx&id='.$rw['id'].'" target="_blank">+Trx</a>';
              $credit='<a href="?op=journal&op2=list&col=account_code&q='.$r2['credit'].'&col2=year&q2='.$rw['year'].'">'.$r2['credit'].'</a>'; $debit='<a href="?op=journal&op2=list&col=account_code&q='.$r2['debit'].'&col2=year&q2='.$rw['year'].'">'.$r2['debit'].'</a>';;
          } else {
              $trx_menu='<a class="btn btn-xs btn-color-green" href="?op=action&op2=add_trx&id='.$rw['id'].'&d=62000&c='.$ar['c22'][$rw['bank']].'" target="_blank">+Trx 62</a> <a class="btn btn-xs btn-color-green" href="?op=action&op2=add_trx&id='.$rw['id'].'&d=81000&c='.$ar['c22'][$rw['bank']].'" target="_blank">+Trx 81</a>';
              $credit=""; $debit="";
          }
          
          if($rw['view']==1) {
              
              $v_menu='<a href="#" id="view-'.$rw['id'].'" class="btn btn-xs btn-color-red text-white" onClick="tView(0,'.$rw['id'].');">hide</a>';
              
          } else {
              $v_menu='<a href="#" id="view-'.$rw['id'].'" class="btn btn-xs btn-color-blue text-white" onClick="tView(1,'.$rw['id'].');">hide</a>';
          }

?>
        
            <tr>
                <td><?=$rw['id'];?></td>
                <td><?=date("Y-m-d",$rw['action_at']);?>-<?=$rw['seq'];?></td>
                <td><a href="?op=action&op2=list&col=bank&q=<?=$rw['bank'];?>&col2=year&q2=<?=$rw['year'];?>"><?=$rw['year'];?></a></td>
                <td><a href="?op=action&op2=list&col=bank&q=<?=$rw['bank'];?>&col2=month&q2=<?=$rw['month'];?>"><?=substr($rw['month'],4,2);?></a></td>
                <td contenteditable="true" onBlur="colUpdate(this,'seq',<?=$rw['id'];?>,'action')" onClick="editRow(this);"><?=$rw['seq'];?></td>
                <td><a href="?op=action&op2=list&col=bank&q=<?=$rw['bank'];?>"><?=$rw['bank'];?></a></td>
                <td><?=$rw['descr'];?></td>
                <td class="text-right"><?=ang2($rw['amount']);?></td>
                <td><?=$pay_to;?></td>
                <td><?=$pay_from;?></td>
                <td><a href="?op=action&op2=list&col=cat&q=<?=$rw['cat'];?>"><?=$rw['cat'];?></a></td>
                <td><a href="?op=action&op2=list&col=inout&q=<?=$rw['inout'];?>"><?=$rw['inout'];?></a></td>
                
                <td class="text-right"><?=$r2['jum'];?></td>
                <td class="text-right"><?=$r3['jum'];?></td>
                <td class="text-right"><?=$r4['jum'];?></td>
                <td><?=$debit;?></td>
                <td><?=$credit;?></td>
                
                <td><?=date("y-m-d h:i:s",$rw['update_at']);?></td>
                <td nowrap>
                <a class="btn btn-xs btn-warning" href="?op=action&op2=edit&id=<?=$rw['id'];?>">ed</a>
                <a class="btn btn-xs btn-color-blue" href="?op=action&op2=copy&id=<?=$rw['id'];?>">cp</a>
                <?=$trx_menu;?>                   
                <a class="btn btn-xs btn-danger" href="?op=action&op2=del&id=<?=$rw['id'];?>">de</a>
                <?=$v_menu;?>
                
                </td>
                <td>

</td>
            </tr>
          <?php
          }
          ?>  
            
        </tbody>
    </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 tView(id,val) {
      $.ajax({
        url: "update.view.php",
        type: "POST",
        data:'val='+val+'&id='+id,
        success: function(data){
          $("#view-"+id).remove();
        }
      });
    }
    </script>    
        
    <?php
    
}

function edit($id) {
    global $db,$ar;
    
    $sql = "select * from action where id=".$id;
    $res = mysqli_query($db, $sql);
    //echo $sql;
    $rw = mysqli_fetch_assoc($res);

$sql1 = "select * from transaction where action_id=".$id;
    $res1 = mysqli_query($db, $sql1);
    //echo $sql;
    $r1 = mysqli_fetch_assoc($res1);

?>
    <h3>Edit</h3>
    <form action="index.php?op=action&op2=edit2" method="post" enctype="multipart/form-data">
    <input type="hidden" name="id" value="<?=$id;?>">
    <input type="hidden" name="file_type" value="pdf">

<div class="form-group row">
      <label for="pay_to" class="col-sm-1 col-form-label">Pay To</label>
      <div class="col-sm-2">
          <input type="text" value="<?=$rw['pay_to'];?>" class="form-control" name="pay_to" placeholder="pay_to">
      </div>
      <label for="pay_from" class="col-sm-1 col-form-label">Pay From</label>
      <div class="col-sm-2">
          <input type="text" value="<?=$rw['pay_from'];?>" class="form-control" name="pay_from" placeholder="pay_from">
      </div>
      <label for="cat" class="col-sm-1 col-form-label">Cat</label>
      <div class="col-sm-1">
        <select class="form-control" id="role" name="cat">
          <?php
            for($a=0;$a<count($ar['trx_category']);$a++) {
            if($rw['cat']==$a) { $sel="selected"; } else { $sel=""; }
          ?>
            <option <?=$sel;?> value="<?=$a;?>"><?=$ar['trx_category'][$a];?></option>
          <?php
            }
          ?>
        </select>
      </div>
      <label for="bank" class="col-sm-1 col-form-label">Bank</label>
      <div class="col-sm-3">
        <select class="form-control" name="bank">
          <option value=0></option>
          <?php
           $sql1 = "select * from bank where st=1 and sel=1 order by bank_name ";
           $res1 = mysqli_query($db, $sql1);
  //echo $sql;
            while($rw1 = mysqli_fetch_assoc($res1)) {
            
            if($rw['bank']==$rw1['id']) { $sel="selected"; } else { $sel=""; }
          ?>
           
            <option <?=$sel;?> value="<?=$rw1['id'];?>"><?=$rw1['swift_code']." ".$rw1['account_number']." an ".$rw1['account_name']." (".$rw1['currency'].").";?></option>
                        
          <?php
            }
          ?>
        </select>
      </div>

</div>

<div class="form-group row">
        <label for="action_at" class="col-sm-1 col-form-label">Date</label>
        <div class="col-sm-2">
            <input type="date" value="<?=date("Y-m-d",$rw['action_at']);?>" class="form-control" name="action_at" placeholder="Date">
        </div>
        <label for="invoice" class="col-sm-1 col-form-label">No Invoice</label>
        <div class="col-sm-2">
            <input type="text" value="<?=$rw['invoice'];?>" class="form-control" name="invoice">
        </div>
        <label for="inout" class="col-sm-1 col-form-label">InOut</label>
        <div class="col-sm-1">
          <select class="form-control" id="role" name="inout">
            <?php
              for($a=0;$a<count($ar['inout']);$a++) {
              if($rw['inout']==$a) { $sel="selected"; } else { $sel=""; }
            ?>
              <option <?=$sel;?> value="<?=$a;?>"><?=$ar['inout'][$a];?></option>
            <?php
              }
            ?>
          </select>
        </div>
        <label for="amount" class="col-sm-1 col-form-label">Amount</label>
        <div class="col-sm-3">
            <input type="text" value="<?=$rw['amount'];?>" class="form-control" name="amount">
        </div>                   
    </div>
    <div class="form-group row">
      <label for="file" class="col-sm-1 col-form-label">PDF Invoice</label>
      <div class="col-sm-2">
        <div class="input-group">
          <div class="custom-file">
            <input type="file" class="custom-file-input" name="file" id="file"
              aria-describedby="file1">
            <label class="custom-file-label" for="file">Choose file</label>
          </div>
        </div>
      </div>        
      <label for="descr" class="col-sm-1 col-form-label">Description</label>
      <div class="col-sm-6">
          <input type="text" value="<?=$rw['descr'];?>" class="form-control" name="descr" placeholder="Description">
      </div>   
      <label for="seq" class="col-sm-1 col-form-label">Seq</label>
      <div class="col-sm-1">
          <input type="text" value="<?=$rw['seq'];?>" class="form-control" name="seq">
      </div>
    </div>
    <?php if($rw['url_pdf']!='') { ?>
    <div class="form-group row">
        <label for="file" class="col-sm-1 col-form-label">URL Invoice</label>
        <div class="col-sm-4 pt-2"><a target="_blank" href="<?=$ar['img_url']."".$rw['url_pdf'];?>"><?=$rw['url_pdf'];?></a></div>
    </div>
    <?php } ?>
    <hr>
    <div class="form-group row">
        <div class="col-sm-10 offset-sm-2 text-right">
            <a href="?op=action&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

/*if($rw['cat']==3) {
    edit_inventory($rw);    
  }*/

//add_transaction($rw);
  if(mysqli_num_rows($res1)>0) {
      //echo "<pre>"; print_r($r1); echo "</pre>";
      //list_transaction($r1['id']);
  }
  
  if($rw['bank']==3) {
    $sql1 = "select * from csv_m where action_id=".$id;
    $res1 = mysqli_query($db, $sql1);
    //echo $sql;
    $r1 = mysqli_fetch_assoc($res1);   
    echo "<pre>"; print_r($r1); echo "</pre>";
      
  }

}

function add($cat,$inout) {
  global $db,$ar;
  ?>
  <h3>Add</h3>
  <form action="index.php?op=action&op2=add2" method="post" enctype="multipart/form-data">
    <input type="hidden" name="file_type" value="pdf">
    <input type="hidden" name="cat" value="<?=$cat;?>">
    <input type="hidden" name="inout" value="<?=$inout;?>">

</div>

}

function add_trx($rw,$d,$c) {
    global $db,$ar;
    //echo "<pre>"; print_r($rw); echo "</pre>";
    
    $sql1 = "select * from transaction where action_id=".$rw['id'];
    $res1 = mysqli_query($db, $sql1);
    //echo $sql;
    $r1 = mysqli_fetch_assoc($res1);    
    //echo "<pre>"; print_r($r1); echo "</pre>";
    
    ?>
    <h4>Add Transaction</h4>
    <form action="index.php?op=transaction&op2=add2" method="post" enctype="multipart/form-data">
      <input type="hidden" name="cat" value="<?=$rw['cat'];?>">
      <input type="hidden" name="action_id" value="<?=$rw['id'];?>">
      <input type="hidden" name="inout" value="<?=$rw['inout'];?>">
      <input type="hidden" name="action_at" value="<?=$rw['action_at'];?>">

<div class="form-group row">
          <label for="debit" class="col-sm-1 col-form-label">Debit</label>
          <div class="col-sm-2">
            <select class="form-control" name="debit">
            <option value=0></option>
              <?php
               $sql1 = "select * from account where trx=1 order by code";
               $res1 = mysqli_query($db, $sql1);
      //echo $sql;
                while($rw1 = mysqli_fetch_assoc($res1)) {
                if($d==$rw1['code']) { $sel="selected"; } else { $sel=""; }
                //if($r1['debit']==$rw1['code']) { $sel="selected"; } else { $sel=""; }
              ?>
               
                <option <?=$sel;?> value="<?=$rw1['code'];?>"><?=$rw1['code'].", ".$rw1['name'];?></option>
                            
              <?php
                }
              ?>
            </select>
          </div>
          <label for="amount" class="col-sm-1 col-form-label">Amount</label>
          <div class="col-sm-2">
              <input type="text" value="<?=$rw['amount'];?>" class="form-control" name="amount" placeholder="Amount">
          </div>                    
      </div>

<div class="form-group row">
          <label for="debit" class="col-sm-5 col-form-label"></label>
          <label for="credit" class="col-sm-1 col-form-label">Credit</label>
          <div class="col-sm-2">
            <select class="form-control" name="credit">
            <option value=0></option>
              <?php
               $sql1 = "select * from account where trx=1 order by code";
               $res1 = mysqli_query($db, $sql1);
      //echo $sql;
                while($rw1 = mysqli_fetch_assoc($res1)) {
                
                if($c==$rw1['code']) { $sel="selected"; } else { $sel=""; }
                //if($r1['credit']==$rw1['code']) { $sel="selected"; } else { $sel=""; }
              ?>
               
                <option <?=$sel;?> value="<?=$rw1['code'];?>"><?=$rw1['code'].", ".$rw1['name'];?></option>
                            
              <?php
                }
              ?>
            </select>
          </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 Transaction</button>
          </div>
      </div>
    </form>
       
    <?php

}

function add_transaction($rw) {
    global $db,$ar;
    //echo "<pre>"; print_r($rw); echo "</pre>";
    ?>
    <h4>Add Transaction</h4>
    <form action="index.php?op=transaction&op2=add2" method="post" enctype="multipart/form-data">
      <input type="hidden" name="cat" value="<?=$rw['cat'];?>">
      <input type="hidden" name="action_id" value="<?=$rw['id'];?>">
      <input type="hidden" name="inout" value="<?=$rw['inout'];?>">
      <input type="hidden" name="action_at" value="<?=$rw['action_at'];?>">

<div class="form-group row">
          <label for="debit" class="col-sm-1 col-form-label">Debit</label>
          <div class="col-sm-2">
            <select class="form-control" name="debit">
            <option value=0></option>
              <?php
               $sql1 = "select * from account where trx=1 order by code";
               $res1 = mysqli_query($db, $sql1);
      //echo $sql;
                while($rw1 = mysqli_fetch_assoc($res1)) {
                
                if($rw['debit']==$rw1['code']) { $sel="selected"; } else { $sel=""; }
              ?>
               
                <option <?=$sel;?> value="<?=$rw1['code'];?>"><?=$rw1['code'].", ".$rw1['name'];?></option>
                            
              <?php
                }
              ?>
            </select>
          </div>

<label for="credit" class="col-sm-1 col-form-label">Credit</label>
          <div class="col-sm-2">
            <select class="form-control" name="credit">
            <option value=0></option>
              <?php
               $sql1 = "select * from account where trx=1 order by code";
               $res1 = mysqli_query($db, $sql1);
      //echo $sql;
                while($rw1 = mysqli_fetch_assoc($res1)) {
                
                if($rw['credit']==$rw1['code']) { $sel="selected"; } else { $sel=""; }
              ?>
               
                <option <?=$sel;?> value="<?=$rw1['code'];?>"><?=$rw1['code'].", ".$rw1['name'];?></option>
                            
              <?php
                }
              ?>
            </select>
          </div>
          <label for="amount" class="col-sm-1 col-form-label">Amount</label>
          <div class="col-sm-2">
              <input type="text" value="<?=$rw['amount'];?>" class="form-control" name="amount" placeholder="Amount">
          </div>
                    
      </div>

}

function list_transaction($trx) {
    global $db,$ar;
    
    //print_r($ar);
    ?>
    <h4><?=$trx['descr'];?></h4>     
    <table class="table table-bordered table-striped" id="dataTable_1a" width="100%" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>ID</th>
                <th>At</th>
                <th>Code</th>
                <th>Name</th>
                <th>Debit</th>
                <th>Credit</th>
                <th>Menu</th>
            </tr>
        </thead>

<tbody>
        <?php
        $sql = "select a.*,b.name from journal a JOIN account b ON a.account_code=b.code where a.st>0 and a.transaction_id=".$trx['id'];
        $res = mysqli_query($db, $sql);
        //echo $sql;
        while($rw = mysqli_fetch_assoc($res)) {
        
        ?>
        
            <tr>
                <td><?=$rw['id'];?></td>
                <td class="text-right"><?=date("Y-m-d",$trx['action_at']);?></td>
                <td><?=$rw['account_code'];?></td>
                <td><?=$rw['name'];?></td>
                <td class="text-right"><?=ang2($rw['debit']);?></td>
                <td class="text-right"><?=ang2($rw['credit']);?></td>
                <td nowrap>
                <a class="btn btn-xs btn-warning" href="?op=transaction&op2=edit&id=<?=$rw['id'];?>">edit</a> 
                <a class="btn btn-xs btn-danger" onclick="updateRecord('journal','st',0,<?=$rw['id'];?>);">del</a> 
                </td>
            </tr>
          <?php
          }
          ?>  
            
        </tbody>
    </table>   
    <?php
    
}

function edit_inventory($r2) {
    global $db,$ar;
    
    $sql = "select * from copy_inventory where transaction_id=".$r2['reff_trx_id'];
    $res = mysqli_query($db, $sql);
    //echo $sql;
    $rw = mysqli_fetch_assoc($res);    
    print_r($rw);
    ?>
    <h3>Edit</h3>
    <form action="index.php?op=action&op2=edit_inventory2" method="post" enctype="multipart/form-data">
    <input type="hidden" name="action_id" value="<?=$r2['id'];?>">
    <input type="hidden" name="file_type" value="image">
      <div class="form-group row">
          <label for="name" class="col-sm-1 col-form-label">Name</label>
          <div class="col-sm-4">
              <input type="text" value="<?=$rw['name'];?>" class="form-control" name="name">
          </div>
          <label for="brand" class="col-sm-1 col-form-label">Brand</label>
          <div class="col-sm-4">
              <input type="text" value="<?=$rw['brand'];?>" class="form-control" name="brand">
          </div>
          <label for="qty" class="col-sm-1 col-form-label">Qty</label>
          <div class="col-sm-1">
              <input type="text" value="<?=$rw['qty'];?>" class="form-control" name="qty">
          </div>
      </div>
      <div class="form-group row">
          <label for="price_per_unit" class="col-sm-1 col-form-label">Price</label>
          <div class="col-sm-4">
              <input type="text" value="<?=$rw['price_per_unit'];?>" class="form-control" name="price_per_unit">
          </div>
          <label for="purchase_date" class="col-sm-2 col-form-label">Purchase Date</label>
          <div class="col-sm-3">
              <input type="date" value="<?=date("Y-m-d",$rw['purchase_date']);?>" class="form-control" name="purchase_date">
          </div>
          <label for="unit" class="col-sm-1 col-form-label">Unit/satuan</label>
          <div class="col-sm-1">
              <input type="text" value="<?=$rw['unit'];?>" class="form-control" name="unit">
          </div>
      </div>      
      <div class="form-group row">
          <label for="position" class="col-sm-1 col-form-label">Position</label>
          <div class="col-sm-4">
              <input type="text" value="<?=$rw['position'];?>" class="form-control" name="position">
          </div>
          <label for="condition" class="col-sm-1 col-form-label">Condition</label>
          <div class="col-sm-3">
              <input type="text" value="<?=$rw['condition'];?>" class="form-control" name="condition">
          </div>
          <label for="will_age" class="col-sm-2 col-form-label">Will Age (th)</label>
          <div class="col-sm-1">
              <input type="text" value="<?=$rw['will_age'];?>" class="form-control" name="will_age">
          </div>
      </div>      
      <div class="form-group row">
          <label for="group" class="col-sm-1 col-form-label">Group</label>
          <div class="col-sm-3">
              <input type="text" value="<?=$rw['group'];?>" class="form-control" name="group">
          </div>
          <label for="remark" class="col-sm-1 col-form-label">Remark</label>
          <div class="col-sm-7">
              <input type="text" value="<?=$rw['remark'];?>" class="form-control" name="remark">
          </div>
      </div>
        <div class="form-group row">
            <label for="file" class="col-sm-1 col-form-label">Foto</label>
            <div class="col-sm-4">
              <div class="input-group">
                <div class="custom-file">
                  <input type="file" class="custom-file-input" name="file" id="file"
                    aria-describedby="file1">
                  <label class="custom-file-label" for="file">Choose file</label>
                </div>
              </div>
            </div>
        </div>
      <div class="form-group row">
          <div class="col-sm-10 offset-sm-2 text-right">
              <a href="?op=inventory&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
  echo viewImage('inventory',$id);
}
?>