filephp fin2@agn

FilePHP

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

inc.account.php

<main>
  <div class="container-fluid">
    <div class="row align-items-center justify-content-between pt-2">
      <div class="col-auto mb-3">
          <h2>Account</h2>
      </div>
      <div class="col-12 col-xl-auto mb-3">          
          <a class="btn btn-xs btn-color-blue" href="?op=account&op2=gen_tbl">Gen Table Report</a>
          <a class="btn btn-xs btn-color-lime" href="?op=account&op2=v2_tree">v2 Tree</a>
          <a class="btn btn-xs btn-color-lime" href="?op=account&op2=tree">Tree</a>
          
      </div>
    </div>

<?php
    switch($op2) {
        
      case "v2_tree";
          v2_tree();
          break;        
      case "addv2";
          addv2($_GET['id']);
          break;
      case "addv22";
          $sql4 = "select * from account_v2 order by id desc limit 1";
          $res4 = mysqli_query($db, $sql4);
          $rw4 = mysqli_fetch_assoc($res4);
          $id2=$rw4['id']+1;

$udata=array(
              'parent'=>$_POST['parent'],
              'code'=>strtolower($_POST['code']),
              'name'=>$_POST['name'],
              'update_at'=>time(),
              'id'=>$id2,
          );
          Insert($db,"account_v2",$udata,0);
          v2_tree();
          break;    
      case "editv2";
          editv2($_GET['id']);
          break;
      case "editv22";
          $udata=array(
              'code'=>strtolower($_POST['code']),
              'code1'=>$_POST['code1'],
              'sel'=>$_POST['sel'],
              'col'=>$_POST['col'],
              'name'=>$_POST['name'],
              'lev1'=>$_POST['lev1'],
              'lev2'=>'c'.substr($_POST['code'],0,5),
              'level'=>$_POST['level'],
              'remark'=>$_POST['remark'],
              'update_at'=>time(),
          );
          Update($db,"account_v2",$udata,"id=".$_POST['id'],1);
          //listaccount($q,$col,$q2,$col2,$sortby,$sort,$page);
          v2_tree();
          break;
          
      case "tree";
          tree();
          break;

case "tree2";
          tree2();
          break;

case "gen_tbl";

$sql3 = "select * from report order by id desc limit 1";
          $res3 = mysqli_query($db, $sql3);
          $r3 = mysqli_fetch_assoc($res3);
          if(isset($r3['id'])) {
            $id2=$r3['id']+1;
          } else {
            $id2=1;
          }

$sql4 = "select * from account where sel=1 order by code";
          $res4 = mysqli_query($db, $sql4);
          while($r4 = mysqli_fetch_assoc($res4)) {
            for($a=2022;$a<2026;$a++) {
              $idt=array(
                'id'=>$id2,
                'account'=>$r4['id'],
                'parent'=>$r4['parent_id'],
                'code'=>$r4['code'],
                'remark'=>$r4['remark'],
                'level'=>$r4['level'],
                'name'=>$r4['name'],
                'year'=>$a,
                'trx'=>$r4['trx'],
                'seq'=>$r4['seq'],
                'st'=>1
              );
              $udt=array(
                'account'=>$r4['id'],
                'parent'=>$r4['parent_id'],
                'code'=>$r4['code'],
                'remark'=>$r4['remark'],
                'level'=>$r4['level'],
                'name'=>$r4['name'],
                'trx'=>$r4['trx'],
                'seq'=>$r4['seq'],
                'year'=>$a,
              );
              InsertUpdate($db,"report",$idt,$udt,1);
              $id2++;
            }
          }

break;

case "addspc";
          addSpc($_GET['pid'],$_GET['id']);
          break;

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

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

$udata=array(
              'parent_id'=>$_POST['parent_id'],
              'code'=>$_POST['code'],
              'name'=>$_POST['name'],
              'update_at'=>time(),
              'id'=>$id2,
          );
          Insert($db,"account",$udata,0);
          tree();
          break;

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

case "edit2";
          $udata=array(
              'code'=>$_POST['code'],
              'sel'=>$_POST['sel'],
              'col'=>$_POST['col'],
              'name'=>$_POST['name'],
              'lev1'=>$_POST['lev1'],
              'lev2'=>'c'.substr($_POST['code'],0,5),
              'level'=>$_POST['level'],
              'remark'=>$_POST['remark'],
              'update_at'=>time(),
          );
          Update($db,"account",$udata,"id=".$_POST['id'],1);
          //listaccount($q,$col,$q2,$col2,$sortby,$sort,$page);
          tree();
          break;

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

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

case "count";
          $sql="SELECT * from journal where year=".$_GET['year']." and account_code='".$_GET['code']."' order by action_at asc,id asc ";
          $res = mysqli_query($db, $sql);
          $saldo=array();

$j_d=0;
          $j_c=0;

while($r1 = mysqli_fetch_assoc($res)) {
            $j_c=$j_c+$r1['credit'];
            $j_d=$j_d+$r1['debit'];
            echo "debit: ".ang2($r1['debit']).", credit: ".ang2($r1['credit']).", saldo: ".ang2($r1['balance'])."<br>";
          }
          $sal=$j_d-$j_c;

echo end($saldo)." total debit: ".ang2($j_d)." kredit: ".ang2($j_c).", saldo: ".ang2($sal)."<br>";

$udt=array(
            'amount'=>to_numeric($sal),
            'c'.$_GET['c']=>to_numeric($sal),
            'update_at'=>time(),
          );
          Update($db,"report",$udt,"code='".$_GET['code']."' and year=".$_GET['year'],1);

$col="sel2";
          $q=1;

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

<?php
function listaccount($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_1a" width="100%" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>ID</th>
                <th>Code</th>
                <th>Name</th>
                <th>col</th>
                <th>Lev1</th>
                <th>Lev2</th>
                <th>Sel1</th>
                <th>Sel2</th>
                <th>Level</th>
                <th>Trx</th>
                <th>Menu</th>
            </tr>
        </thead>

<tbody>
        <?php
        $sql = "select * from account 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;
        while($rw = mysqli_fetch_assoc($res)) {
        //https://fin.ipikn.blog/?op=journal&op2=list&q=11100&col=account_code&q2=2022&col2=year
        ?>
        
            <tr>
                <td><?=$rw['id'];?></td>
                <td><?=$rw['code'];?></td>
                <td><?=$rw['name'];?></td>
                <td contenteditable="true" onBlur="saveToDatabase(this,'col','<?=$rw['id'];?>','account')" onClick="editRow(this);"><?=$rw['col'];?></td>
                <td contenteditable="true" onBlur="saveToDatabase(this,'lev1','<?=$rw['id'];?>','account')" onClick="editRow(this);"><?=$rw['lev1'];?></td>
                <td contenteditable="true" onBlur="saveToDatabase(this,'lev2','<?=$rw['id'];?>','account')" onClick="editRow(this);"><?=$rw['lev2'];?></td>
                <td contenteditable="true" onBlur="saveToDatabase(this,'sel','<?=$rw['id'];?>','account')" onClick="editRow(this);"><?=$rw['sel'];?></td>
                <td><a href="?op=account&op2=list&col=sel2&q=1"><?=$rw['sel2'];?></a></td>
                <td contenteditable="true" onBlur="saveToDatabase(this,'level','<?=$rw['id'];?>','account')" onClick="editRow(this);"><?=$rw['level'];?></td>
                <td contenteditable="true" onBlur="saveToDatabase(this,'trx','<?=$rw['id'];?>','account')" onClick="editRow(this);"><?=$rw['trx'];?></td>
                <td nowrap>
                <a class="btn btn-xs btn-warning" href="?op=account&op2=edit&id=<?=$rw['id'];?>">edit</a> 
                <a class="btn btn-xs btn-success" target="_blank" href="?op=journal&op2=list&col=account_code&q=<?=$rw['code'];?>&q2=2022&col2=year">count 2022</a> 
                <a class="btn btn-xs btn-info" target="_blank" href="?op=journal&op2=list&col=account_code&q=<?=$rw['code'];?>&q2=2023&col2=year">count 2023</a> 
                <a class="btn btn-xs btn-color-red" onclick="updateRecord('account','trx','1',<?=$rw['id'];?>);">trx</a>
                <a class="btn btn-xs btn-color-green" href="?op=account&op2=count&code=<?=$rw['code'];?>&year=2022&c=<?=$rw['col'];?>">count-v2 2022</a> 
                </td>
            </tr>
          <?php
          }
          ?>  
            
        </tbody>
    </table>
    <script>
      function editRow(editableObj) {
        $(editableObj).css("background","#FFF");
      }
      function saveToDatabase(editableObj,column,id,tbl) {
        $(editableObj).css("background","#FFF url(loaderIcon.gif) no-repeat right");
        $.ajax({
          url: "col.update.php",
          type: "POST",
          data:'tbl='+tbl+'&col='+column+'&val='+$(editableObj).text()+'&id='+id,
          success: function(data){
            $(editableObj).css("background","#FDFDFD");
          }
        });
      }
      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 account where id=".$id;
    $res = mysqli_query($db, $sql);
    //echo $sql;
    $rw = mysqli_fetch_assoc($res);    
    ?>
    <h3>Edit</h3>
    <form action="index.php?op=account&op2=edit2" method="post" enctype="multipart/form-data">
    <input type="hidden" name="id" value="<?=$id;?>">

<div class="form-group row">
          <label for="code" class="col-sm-1 col-form-label">Code</label>
          <div class="col-sm-2">
              <input type="text" value="<?=$rw['code'];?>" class="form-control" name="code">
          </div>
          <label for="name" class="col-sm-1 col-form-label">Name</label>
          <div class="col-sm-2">
              <input type="text" value="<?=$rw['name'];?>" name="name" class="form-control">
          </div>
          <label for="lev1" class="col-sm-1 col-form-label">Lev 1</label>
          <div class="col-sm-1">
              <input type="text" value="<?=$rw['lev1'];?>" name="lev1" class="form-control">
          </div>
          <label for="lev2" class="col-sm-1 col-form-label">Lev 2</label>
          <div class="col-sm-1">
              <input type="text" value="<?=$rw['lev2'];?>" name="lev2" class="form-control">
          </div>
          <label for="level" class="col-sm-1 col-form-label">Level</label>
          <div class="col-sm-1">
              <input type="text" value="<?=$rw['level'];?>" name="level" class="form-control">
          </div>
      </div>

<div class="form-group row">
          <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>
          <label for="sel" class="col-sm-1 col-form-label">Sel</label>
          <div class="col-sm-1">
              <input type="text" value="<?=$rw['sel'];?>" name="sel" class="form-control">
          </div>
          <label for="col" class="col-sm-1 col-form-label">repCol</label>
          <div class="col-sm-1">
              <input type="text" value="<?=$rw['col'];?>" name="col" class="form-control">
          </div>
      </div>

<div class="form-group row">
          <div class="col-sm-10 offset-sm-2 text-right">
              <a href="?op=account&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 addSpc($pid,$id) {
    global $db,$ar;    
    $id2=$id-1;
    ?>
    <h3>Add</h3>
    <form action="index.php?op=account&op2=add2" method="post" enctype="multipart/form-data">
    <input type="hidden" name="parent_id" value="<?=$pid;?>">

<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 add($id) {
    global $db,$ar;    
    ?>
    <h3>Add</h3>
    <form action="index.php?op=account&op2=add2" method="post" enctype="multipart/form-data">
    <input type="hidden" name="parent_id" value="<?=$id;?>">

}

function tree() {
    global $db,$ar;
    
    $sql = "select * from account where parent_id=0";
    $res = mysqli_query($db, $sql);
    //echo $sql;
    while($r = mysqli_fetch_assoc($res)) {
      ?>
      <br>
      <h4><?=$r['name'];?> <sup><a href="?op=account&op2=add&id=<?=$r['id'];?>">Add</a> | <a href="?op=account&op2=edit&id=<?=$r['id'];?>">Edit</a></sup></h4>
      <?php

$sql1 = "select * from account where parent_id=".$r['id']." order by code";
      $res1 = mysqli_query($db, $sql1);
      //echo $sql;
      while($r1 = mysqli_fetch_assoc($res1)) {
        ?>
        <h5>- <?=$r1['code'];?> <?=$r1['name'];?> <sup><a href="?op=account&op2=add&id=<?=$r1['id'];?>">Add</a> | <a href="?op=account&op2=edit&id=<?=$r1['id'];?>">Edit</a>  | <i><?=$r1['remark'];?></i></sup></h5>

<?php

$sql2 = "select * from account where parent_id=".$r1['id']." order by code";
        $res2 = mysqli_query($db, $sql2);
        //echo $sql;
        while($r2 = mysqli_fetch_assoc($res2)) {
          ?>
          <h6>----- <?=$r2['code'];?> <?=$r2['name'];?> <sup><a href="?op=account&op2=add&id=<?=$r2['id'];?>">Add</a> | <a href="?op=account&op2=edit&id=<?=$r2['id'];?>">Edit</a> | <a class="btn btn-xs btn-danger" onclick="updateRecord('account','sel',1,<?=$r2['id'];?>);">sel</a> | <i><?=$r2['remark'];?></i></sup></h6>

<?php
          $sql3 = "select * from account where parent_id=".$r2['id']." order by code";
          $res3 = mysqli_query($db, $sql3);
          //echo $sql;
          while($r3 = mysqli_fetch_assoc($res3)) {
            ?>
            <p>----------- <?=$r3['code'];?> <?=$r3['name'];?> <sup><a href="?op=account&op2=edit&id=<?=$r3['id'];?>">Edit</a> | <a class="btn btn-xs btn-danger" onclick="updateRecord('account','sel',1,<?=$r3['id'];?>);">sel</a> | <i><?=$r3['remark'];?></i></sup></p>
            <?php
          }

}

}      
    }    
    ?>
    
    <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 v2_tree() {
    global $db,$ar;
    
    $sql = "select * from account_v2 where parent=0";
    $res = mysqli_query($db, $sql);
    //echo $sql;
    while($r = mysqli_fetch_assoc($res)) {
      ?>
      <br>
      <h4><?=$r['name'];?> <sup><a href="?op=account&op2=addv2&id=<?=$r['id'];?>">Add</a> | <a href="?op=account&op2=editv2&id=<?=$r['id'];?>">Edit</a></sup></h4>
      <?php

$sql1 = "select * from account_v2 where parent=".$r['id']." order by code";
      $res1 = mysqli_query($db, $sql1);
      //echo $sql;
      while($r1 = mysqli_fetch_assoc($res1)) {
        ?>
        <h5>- <?=$r1['code'];?> <?=$r1['name'];?> <sup><a href="?op=account&op2=addv2&id=<?=$r1['id'];?>">Add</a> | <a href="?op=account&op2=editv2&id=<?=$r1['id'];?>">Edit</a>  | <i><?=$r1['remark'];?></i></sup></h5>

<?php

$sql2 = "select * from account_v2 where parent=".$r1['id']." order by code";
        $res2 = mysqli_query($db, $sql2);
        //echo $sql;
        while($r2 = mysqli_fetch_assoc($res2)) {
          ?>
          <h6>----- <?=$r2['code'];?> (<?=$r2['code1'];?>) <?=$r2['name'];?> <sup><a href="?op=account&op2=addv2&id=<?=$r2['id'];?>">Add</a> | <a href="?op=account&op2=editv2&id=<?=$r2['id'];?>">Edit</a> | <a class="btn btn-xs btn-danger" onclick="updateRecord('account_v2','sel',1,<?=$r2['id'];?>);">sel</a> | <i><?=$r2['remark'];?></i></sup></h6>

<?php
          $sql3 = "select * from account_v2 where parent=".$r2['id']." order by code";
          $res3 = mysqli_query($db, $sql3);
          //echo $sql;
          while($r3 = mysqli_fetch_assoc($res3)) {
            ?>
            <p>----------- <?=$r3['code'];?> (<?=$r3['code1'];?>) <?=$r3['name'];?> <sup><a href="?op=account&op2=addv2&id=<?=$r3['id'];?>">Add</a> | <a href="?op=account&op2=editv2&id=<?=$r3['id'];?>">Edit</a> | <a class="btn btn-xs btn-danger" onclick="updateRecord('account_v2','sel',1,<?=$r3['id'];?>);">sel</a> | <i><?=$r3['remark'];?></i></sup></p>
            <?php
            
          $sql4 = "select * from account_v2 where parent=".$r3['id']." order by code";
          $res4 = mysqli_query($db, $sql4);
          //echo $sql;
          while($r4 = mysqli_fetch_assoc($res4)) {
            ?>
            <p>--------------- <?=$r4['code'];?> <?=$r4['name'];?> <sup><a href="?op=account&op2=addv2&id=<?=$r4['id'];?>">Add</a> | <a href="?op=account&op2=editv2&id=<?=$r4['id'];?>">Edit</a> | <a class="btn btn-xs btn-danger" onclick="updateRecord('account_v2','sel',1,<?=$r4['id'];?>);">sel</a> | <i><?=$r4['remark'];?></i></sup></p>
            <?php
            
            
          }
          
          }

}

function addv2($id) {
    global $db,$ar;    
    ?>
    <h3>Add</h3>
    <form action="index.php?op=account&op2=addv22" method="post" enctype="multipart/form-data">
    <input type="hidden" name="parent" value="<?=$id;?>">

}

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

<div class="form-group row">
          <label for="code1" class="col-sm-1 col-form-label">Code Old</label>
          <div class="col-sm-2">
              <input type="text" value="<?=$rw['code1'];?>" class="form-control" name="code1">
          </div>
          <label for="remark" class="col-sm-1 col-form-label">Remark</label>
          <div class="col-sm-4">
              <input type="text" value="<?=$rw['remark'];?>" class="form-control" name="remark">
          </div>
          <label for="sel" class="col-sm-1 col-form-label">Sel</label>
          <div class="col-sm-1">
              <input type="text" value="<?=$rw['sel'];?>" name="sel" class="form-control">
          </div>
          <label for="col" class="col-sm-1 col-form-label">repCol</label>
          <div class="col-sm-1">
              <input type="text" value="<?=$rw['col'];?>" name="col" class="form-control">
          </div>
      </div>

}

function tree2() {
    global $db,$ar;
    
    $sql = "select * from account where parent_id=0";
    $res = mysqli_query($db, $sql);
    //echo $sql;
    while($r = mysqli_fetch_assoc($res)) {
      ?>
      <br>
      <h4><?=$r['name'];?></h4>
      <?php

<?php

$sql2 = "select * from account where parent_id=".$r1['id']." order by code";
        $res2 = mysqli_query($db, $sql2);
        //echo $sql;
        while($r2 = mysqli_fetch_assoc($res2)) {
          ?>
          <h6>--- 
          <a href="?op=journal&op2=list&q=<?=$r2['code'];?>&col=account_code"><?=$r2['code'];?></a> 
          <a href="?op=journal&op2=list&q=<?=$r2['code'];?>&col=account_code&q2=2022&col2=year&c=<?=$r2['col'];?>">2022</a> 
          <a href="?op=journal&op2=list&q=<?=$r2['code'];?>&col=account_code&q2=2023&col2=year&c=<?=$r2['col'];?>">2023</a>
          <a href="?op=journal&op2=list&q=<?=$r2['code'];?>&col=account_code&q2=2024&col2=year&c=<?=$r2['col'];?>">2024</a> 
          <a href="?op=journal&op2=list&q=<?=$r2['code'];?>&col=account_code&q2=2025&col2=year&c=<?=$r2['col'];?>">2025</a>
          <?=$r2['name'];?> <?=$r2['sel2'];?> [<?=$r2['level'];?>]</h6>
          <p>
          <?php
          $sql3 = "select * from account where parent_id=".$r2['id']." order by code";
          $res3 = mysqli_query($db, $sql3);
          //echo $sql;
          while($r3 = mysqli_fetch_assoc($res3)) {
            ?>
            -------- 
            <a href="?op=journal&op2=list&q=<?=$r3['code'];?>&col=account_code"><?=$r3['code'];?></a> 
            <a href="?op=journal&op2=list&q=<?=$r3['code'];?>&col=account_code&q2=2022&col2=year&c=<?=$r3['col'];?>">2022</a> 
            <a href="?op=journal&op2=list&q=<?=$r3['code'];?>&col=account_code&q2=2023&col2=year&c=<?=$r3['col'];?>">2023</a>
            <a href="?op=journal&op2=list&q=<?=$r3['code'];?>&col=account_code&q2=2024&col2=year&c=<?=$r3['col'];?>">2024</a> 
            <a href="?op=journal&op2=list&q=<?=$r3['code'];?>&col=account_code&q2=2025&col2=year&c=<?=$r3['col'];?>">2025</a> 
            <?=$r3['name'];?> <?=$r3['sel2'];?> [<?=$r3['level'];?>]<br>
            <?php
          }
          ?></p>
          <?php

}

}      
    }    
    ?> 
      
    <?php

}