filephp fin2@agn

FilePHP

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

inc.cash.php

<main>
  <div class="container-fluid">
    <div class="row align-items-center justify-content-between pt-2">
      <div class="col-auto mb-3">
          <h2>Cash</h2>
      </div>
      <div class="col-12 col-xl-auto mb-3">
          
          <a class="btn btn-xs btn-color-red" href="?op=cash&op2=fcash_out">Rekam Cash Out</a>
          <a class="btn btn-xs btn-color-blue" href="?op=cash&op2=fcash_in">Rekam Cash In</a>
          
          <a class="btn btn-xs btn-color-indigo" href="?op=cash&op2=list&col=is_inventory&q=1">inv</a>
      </div>
    </div>

<?php
    switch($op2) {

case "fcash_out";
        add_cash_out();
        break;
      case "fcash_in";
        add_cash_in();
        break;
      case "add_cash_out2";
      case "add2";
          print_r($_POST);
          $sql4 = "select * from cash order by id desc limit 1";
          $res4 = mysqli_query($db, $sql4);
          $rw4 = mysqli_fetch_assoc($res4);
          $id2=$rw4['id']+1;

if($_POST['inout']==1) {
            $out=0;
            $in=$_POST['amount'];
          } else {
            $in=0;
            $out=$_POST['amount'];            
          }
          $timestr=strtotime($_POST['transaction_date']);

$udata=array(
              'id'=>$id2,
              'pay_from'=>$_POST['pay_from'],
              'pay_to'=>$_POST['pay_to'],
              'amount'=>$_POST['amount'],
              'in'=>$in,
              'out'=>$out,
              'transaction_date'=>strtotime($_POST['transaction_date']),
              'unit'=>$_POST['unit'],
              'quantity'=>$_POST['quantity'],
              'invoice'=>$_POST['invoice'],
              'inout'=>$_POST['inout'],
              'st'=>1,
              'year'=>date("Y",$timestr),
              'week'=>date("W",$timestr),
              'month'=>date("Ym",$timestr),
              'description'=>$_POST['description'],
              'network_id'=>$_SESSION['user_finagn']['id'],
              'update_at'=>time(),
          );
          Insert($db,"cash",$udata,1);
          liststock($q,$col,$q2,$col2,$sortby,$sort,$page);
          break;

case "edit";
          edit($_GET['id']);
          break;
          
      case "edit2";
          $timestr=strtotime($_POST['transaction_date']);
          if(isset($_POST['category_id'])) {
            $category=$_POST['category_id'];
          } else {
            $category=0;
          }
          if(isset($_POST['inventory_id'])) {
            $inventory=$_POST['inventory_id'];
          } else {
            $inventory=0;
          }
          if($_POST['inout']==1) {
            $out=0;
            $in=$_POST['amount'];
          } else {
            $in=0;
            $out=$_POST['amount'];            
          }
          $udata=array(
              'pay_to'=>$_POST['pay_to'],
              'bank'=>$_POST['bank'],
              'amount'=>$_POST['amount'],
              'transaction_date'=>$timestr,
              'inventory_id'=>$inventory,
              'category_id'=>$category,
              'in'=>$in,
              'out'=>$out,
              'tgl2'=>$_POST['transaction_date'],
              'unit'=>$_POST['unit'],
              'quantity'=>$_POST['quantity'],
              'invoice'=>$_POST['invoice'],
              'inout'=>$_POST['inout'],
              'description'=>$_POST['description'],
              'network_id'=>$_SESSION['user_finagn']['id'],
              'year'=>date("Y",$timestr),
              'week'=>date("W",$timestr),
              'month'=>date("Y-m",$timestr),
              'update_at'=>time(),
          );
          Update($db,"cash",$udata,"id=".$_POST['id'],1);
          if(isset($_FILES['file']['tmp_name']) && ($_FILES['file']['tmp_name']!='')) {
              UploadImage($_POST,$_FILES,'cash');
          }
          listcash($q,$col,$q2,$col2,$sortby,$sort,$page);
          break;

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

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

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

<?php
function listcash($q,$col,$q2,$col2,$sortby,$sort,$page) {
    global $db,$ar;
    
    //print_r($ar);
    ?>
            
    <table class="table table-bordered" id="dataTable_1d" width="100%" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>ID</th>
                <th>Date</th>
                <th>Description</th>
                <th>In</th>
                <th>Out</th>
                <th>Saldo</th>
                <th>UpdateAt</th>
                <th>InOut</th>
                <th>Menu</th>
            </tr>
        </thead>

<tbody>
        <?php
        $sql = "select * from cash 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_in=0;
        $j_out=0;

while($rw = mysqli_fetch_assoc($res)) {
        $j_in=$j_in+$rw['in'];
        $j_out=$j_out+$rw['out'];
        ?>
        
            <tr>
                <td><?=$rw['id'];?></td>
                <td class="text-right" nowrap><?=date("y-m-d H:i",$rw['transaction_date']);?></td>
                <td><?=$rw['description'];?></td>
                <td class="text-right"><?=ang2($rw['in']);?></td>
                <td class="text-right"><?=ang2($rw['out']);?></td>
                <td class="text-right"><?=ang2($rw['balance']);?></td>
                <td class="text-right" nowrap><?=date("y-m-d H:i",$rw['update_at']);?></td>
                <td><?=$rw['inout'];?></td>
                <td nowrap>
                <a class="btn btn-xs btn-warning" href="?op=cash&op2=edit&id=<?=$rw['id'];?>">edit</a> 
                <a class="btn btn-xs btn-success" href="?op=cash&op2=copy&id=<?=$rw['id'];?>">copy</a> 
                <a class="btn btn-xs btn-danger" onclick="updateRecord('cash','is_inventory',1,<?=$rw['id'];?>);">inv</a> 
                
                </td>
            </tr>
          <?php
          }
          $j_bal=$j_in-$j_out;
          ?>  
            
        </tbody>
        <tfoot>
            <tr class="table-danger">
                <th colspan="3"></th>
                <th><?=ang2($j_in);?></th>
                <th><?=ang2($j_out);?></th>
                <th><?=ang2($j_bal);?></th>
                <th colspan="3"></th>
            </tr>
        </tfoot>
    </table>    
    <script>
      function updateRecord(tbl,col,val,id) {
        $.ajax({
          url: "tbl.update.php",
          type: "POST",
          data:'tbl='+tbl+'&col='+col+'&val='+val+'&id='+id,
          success: function(data){
            //$(editableObj).css("background","#FDFDFD");
          }
        });
      }
    </script>     
    <?php
    
}

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

<div class="form-group row">
          <label for="pay_to" class="col-sm-1 col-form-label">Pay To</label>
          <div class="col-sm-3">
              <input type="text" value="<?=$rw['pay_to'];?>" class="form-control" name="pay_to" placeholder="Pay To" required>
          </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" placeholder="Amount">
          </div>
          <label for="transaction_date" class="col-sm-1 col-form-label">Date</label>
          <div class="col-sm-3">
              <input type="date" value="<?=date("Y-m-d",$rw['transaction_date']);?>" class="form-control" name="transaction_date">
          </div>
      </div>

<div class="form-group row">
          <label for="description" class="col-sm-1 col-form-label">Description</label>
          <div class="col-sm-11">
              <input type="text" value="<?=$rw['description'];?>" class="form-control" name="description" placeholder="Description">
          </div>
          
      </div>

<div class="form-group row">
          <label for="quantity" class="col-sm-1 col-form-label">Quantity</label>
          <div class="col-sm-3">
              <input type="text" value="<?=$rw['quantity'];?>" class="form-control" name="quantity" placeholder="Quantity">
          </div>
          <label for="unit" class="col-sm-1 col-form-label">Unit/Satuan</label>
          <div class="col-sm-3">
              <input type="text" value="<?=$rw['unit'];?>" class="form-control" name="unit" placeholder="Unit/Satuan">
          </div>
          <label for="invoice" class="col-sm-1 col-form-label">Invoice</label>
          <div class="col-sm-3">
              <input type="text" value="<?=$rw['invoice'];?>" class="form-control" name="invoice">
          </div>
      </div>

<div class="form-group row">
        <label for="bank" class="col-sm-1 col-form-label">Bank</label>
        <div class="col-sm-5">
          <select class="form-control" name="bank">
            <option value=0></option>
            <?php
             $sql1 = "select * from bank where st=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'];?></option>
                          
            <?php
              }
            ?>
          </select>
        </div>          
        <label for="category_id" class="col-sm-1 col-form-label">Category</label>
        <div class="col-sm-3">
          <select class="form-control" name="category_id">
            <option value=0></option>
            <?php
             $sql1 = "select * from category where st=1 order by code ";
             $res1 = mysqli_query($db, $sql1);
    //echo $sql;
              while($rw1 = mysqli_fetch_assoc($res1)) {
              
              if($rw['category_id']==$rw1['id']) { $sel="selected"; } else { $sel=""; }
            ?>
             
              <option <?=$sel;?> value="<?=$rw1['id'];?>"><?=$rw1['code']." ".$rw1['category'];?></option>
                          
            <?php
              }
            ?>
          </select>
        </div>          
        <label for="inout" class="col-sm-1 col-form-label">InOut</label>
        <div class="col-sm-1">
          <select class="form-control" name="inout">
            <?php
              foreach ($ar['inout'] as $a => $val) {
              if($rw['inout']==$a) { $sel="selected"; } else { $sel=""; }
            ?>
             
              <option <?=$sel;?> value="<?=$a;?>"><?=$val;?></option>
                          
            <?php
              }
            ?>
          </select>
        </div>
      </div>
      <?php 
      if($rw['is_inventory']==1) {
      ?>

<div class="form-group row">          
        <label for="inventory_id" class="col-sm-1 col-form-label">Inventory</label>
        <div class="col-sm-5">
          <select class="form-control" name="inventory_id">
          <option value=0></option>
            <?php
             $sql1 = "select * from inventory where st=1 order by name ";
             $res1 = mysqli_query($db, $sql1);
    //echo $sql;
              while($rw1 = mysqli_fetch_assoc($res1)) {
              
              if($rw['inventory_id']==$rw1['id']) { $sel="selected"; } else { $sel=""; }
            ?>
             
              <option <?=$sel;?> value="<?=$rw1['id'];?>"><?=$rw1['name']." ".$rw1['brand']." ".ang2($rw1['price_per_unit']);?></option>
                          
            <?php
              }
            ?>
          </select>
        </div>          
      </div>

<?php } ?>

<?php 
      if($rw['url_pdf']!='') {
      ?>

<div class="form-group row">          
        <label for="inventory_id" class="col-sm-1 col-form-label">File PDF</label>
        <div class="col-sm-5 pt-2">
          <a href="<?=$ar['img_url']."".$rw['url_pdf'];?>" target="_blank"><?=$rw['url_pdf'];?></a>
        </div>          
      </div>

<?php } else { ?>

<div class="form-group row">          
          <label for="file" class="col-sm-1 col-form-label">PDF Invoice</label>
          <div class="col-sm-3">
            <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>

<?php } ?>

<div class="form-group row">
          <div class="col-sm-10 offset-sm-2 text-right">
              <a href="?op=cash&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('cash',$id);

}

function add_cash_out() {
  global $db,$ar;
  ?>
  <h3>Add Cash Out</h3>
  <form action="index.php?op=cash&op2=add_cash_out2" method="post" enctype="multipart/form-data">
    <input type="hidden" name="pay_from" value="0">
    
      <div class="form-group row">
          <label for="pay_to" class="col-sm-1 col-form-label">Pay To</label>
          <div class="col-sm-3">
              <input type="text" class="form-control" name="pay_to" placeholder="Pay To" required>
          </div>
          <label for="amount" class="col-sm-1 col-form-label">Amount</label>
          <div class="col-sm-3">
              <input type="text" class="form-control" name="amount" placeholder="Amount">
          </div>
          <label for="transaction_date" class="col-sm-1 col-form-label">Date</label>
          <div class="col-sm-3">
              <input type="date" class="form-control" name="transaction_date">
          </div>
      </div>

<div class="form-group row">
          <label for="description" class="col-sm-1 col-form-label">Description</label>
          <div class="col-sm-11">
              <input type="text" class="form-control" name="description" placeholder="Description">
          </div>
          
      </div>

<div class="form-group row">
          <label for="quantity" class="col-sm-1 col-form-label">Quantity</label>
          <div class="col-sm-3">
              <input type="text" class="form-control" name="quantity" placeholder="Quantity">
          </div>
          <label for="unit" class="col-sm-1 col-form-label">Unit/Satuan</label>
          <div class="col-sm-3">
              <input type="text" class="form-control" name="unit" placeholder="Unit/Satuan">
          </div>
          <label for="invoice" class="col-sm-1 col-form-label">Invoice</label>
          <div class="col-sm-3">
              <input type="text" class="form-control" name="invoice">
          </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>
  Laporkan pengeluaran di hari/tanggal yang sama, paling lambat satu hari berikutnya<br>
Siapkan bukti pengeluaran<br>
Foto bukti pengeluaran tersebut dengan kamera hp/smartphone, hasilkan foto terbaik dan sehingga bukti pengeluaran terlihat jelas
Login<br>
Isikan data dengan benar<br>
Satu item laporan untuk satu bukti pengeluaran<br>
  <?php
}

function add_cash_in() {
  global $db,$ar;
  ?>
  <h3>Add Cash Out</h3>
  <form action="index.php?op=cash&op2=add2" method="post" enctype="multipart/form-data">
    <input type="hidden" name="input" value="1">
    <input type="hidden" name="pay_to" value="0">
    
      <div class="form-group row">
          <label for="pay_from" class="col-sm-1 col-form-label">Pay From</label>
          <div class="col-sm-3">
              <input type="text" class="form-control" name="pay_to" placeholder="Pay To" required>
          </div>
          <label for="amount" class="col-sm-1 col-form-label">Amount</label>
          <div class="col-sm-3">
              <input type="text" class="form-control" name="amount" placeholder="Amount">
          </div>
          <label for="transaction_date" class="col-sm-1 col-form-label">Date</label>
          <div class="col-sm-3">
              <input type="date" class="form-control" name="transaction_date">
          </div>
      </div>

<?php
}