filephp fin2@agn

FilePHP

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

inc.report.php

<main>
  <div class="container-fluid">
    <div class="row align-items-center justify-content-between pt-2">
      <div class="col-auto mb-3">
          <h2>Report</h2>
      </div>
      <div class="col-12 col-xl-auto mb-3">
          <?php
            $ar['col_report']=array(0,4,3,2,2);
          ?>
          
          
          <p>
            2025: 
            <?php 
            foreach ($ar['report_category'] as $key => $value) {
              if($key>0) {
                $k2=$key+4;
              echo '<a href="?op=report&op2=list&parent='.$key.'&year=2025" class="mt-1 btn btn-xs btn-color-'.$ar['color'][$k2].'">'.$value.'</a> ';
              //echo '<a href="?op=report&op2=list2&parent='.$key.'&year=2024&ccol='.$ccol.'" class="mt-1 btn btn-xs btn-color-'.$ar['color'][$k2].'">'.$value.'</a> ';
              }
            }
            ?>
        </p>
      </div>
    </div>

<?php
    switch($op2) {

case "3";
        neraca($_GET['year']);
        break;

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

case "list2";
        if($_GET['ccol']==2) {
        list_report_2c($parent,$year);
        }
        if($_GET['ccol']==3) {
        list_report_3c($parent,$year);
        }
        if($_GET['ccol']==4) {
        list_report_4c($parent,$year);
        }
        break;

case "list";
      default;
      list_report($parent,$year);
    }
    
    ?>
    <div class="row align-items-center justify-content-between pt-2">
        <div class="col-auto mb-3">
          
        </div>
        <div class="col-12 col-xl-auto mb-3">
          <?php
            $ar['col_report']=array(0,4,3,2,2);
          ?>
          
          
          <p>2022: 
            <?php 
            foreach ($ar['report_category'] as $key => $value) {
              if($key>0) {
              echo '<a href="?op=report&op2=list&parent='.$key.'&year=2022" class="btn btn-xs btn-color-'.$ar['color'][$key].'">'.$value.'</a> ';
              }
            }
            ?>
            <br>
          2023: 
            <?php 
            foreach ($ar['report_category'] as $key => $value) {
              if($key>0) {
                $ccol=$ar['col_report'][$key];
                $k2=$key+4;
              echo '<a href="?op=report&op2=list&parent='.$key.'&year=2023" class="mt-1 btn btn-xs btn-color-'.$ar['color'][$k2].'">'.$value.'</a> ';
              
              echo '<a href="?op=report&op2=list2&parent='.$key.'&year=2023&ccol='.$ccol.'" class="mt-1 btn btn-xs btn-color-'.$ar['color'][$k2].'">'.$value.'</a> ';
              }
            }
            ?>
            <br>
          2024: 
            <?php 
            foreach ($ar['report_category'] as $key => $value) {
              if($key>0) {
                $ccol=$ar['col_report'][$key];
                $k2=$key+4;
              echo '<a href="?op=report&op2=list&parent='.$key.'&year=2024" class="mt-1 btn btn-xs btn-color-'.$ar['color'][$k2].'">'.$value.'</a> ';
              
              echo '<a href="?op=report&op2=list2&parent='.$key.'&year=2024&ccol='.$ccol.'" class="mt-1 btn btn-xs btn-color-'.$ar['color'][$k2].'">'.$value.'</a> ';
              }
            }
            ?>
            
        </p>
      </div>
    </div>      
  </div>
</main> 
<script>
  function CopyToClipboard(element) {
    var doc = document
    , text = doc.getElementById(element)
    , range, selection;

if (doc.body.createTextRange)
        {
            range = doc.body.createTextRange();
            range.moveToElementText(text);
            range.select();
        } 
        
        else if (window.getSelection)
        {
            selection = window.getSelection();        
            range = doc.createRange();
            range.selectNodeContents(text);
            selection.removeAllRanges();
            selection.addRange(range);
        }
        document.execCommand('copy');
        window.getSelection().removeAllRanges();
        document.getElementById("btn").value="Copied";
    }
</script>

<?php
function list_report($parent,$year) {
    global $db,$ar;
    
    //print_r($ar);
    ?>
    <h3><?=$ar['report_category'][$parent]." ".$year;?> </h3> 
    <table class="table table-bordered table-striped table-hover" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>Id</th>
                <th>Code</th>
                <th>Seq</th>
                <th>Lev</th>
                <th>Description</th>
                <th>c1</th>
                <th>c2</th>
                <th>c3</th>
                <th>c4</th>
                <th>UpdateAt</th>
            </tr>
        </thead>

<tbody>
        <?php
        $sql = "select * from report where st>0 and parent=".$parent." and year=".$year." order by seq,code";
        $res = mysqli_query($db, $sql);
        //echo $sql;
        while($rw = mysqli_fetch_assoc($res)) {
            
            if($rw['code']==39000 or $rw['code']==13000) {
                $bg='class="purple lighten-4"';
            } else {
                $bg='';
            }

?>
        
            <tr <?=$bg;?>>
                <td><?=$rw['id'];?></td>
                <td><?=$rw['code'];?></td>
                <td contenteditable="true" onBlur="colUpdate(this,'account','seq','code','<?=$rw['code'];?>')" onClick="editRow(this);"><?=$rw['seq'];?></td>
                <td><?=$rw['level'];?></td>
                <td><?=$rw['name'];?></td>
                <td class="text-right"><?=ang2($rw['c1']);?></td>
                <td class="text-right"><?=ang2($rw['c2']);?></td>
                <td class="text-right"><?=ang2($rw['c3']);?></td>
                <td class="text-right"><?=ang2($rw['c4']);?></td>
                <td class="text-right" nowrap><?=date("y-m-d H:i",$rw['update_at']);?></td>
            </tr>
          <?php

$sql1 = "select * from report where st>0 and parent=".$rw['account']." and year=".$year." order by code";
            $res1 = mysqli_query($db, $sql1);
            while($r1 = mysqli_fetch_assoc($res1)) {
                if($r1['trx']==1) {
                  $name='<a href="?op=journal&op2=list&col=account_code&q='.$r1['code'].'&col2=year&q2='.$year.'">'.$r1['name'].'</a>';
                } else {
                  $name= $r1['name'];
                }
              ?>
            <tr>
                <td><?=$r1['id'];?></td>
                <td><?=$r1['code'];?></td>
                <td contenteditable="true" onBlur="colUpdate(this,'account','seq','code','<?=$r1['code'];?>')" onClick="editRow(this);"><?=$r1['seq'];?></td>
                <td><?=$r1['level'];?></td>
                <td>-- <?=$name;?></td>
                <td class="text-right"><?=ang2($r1['c1']);?></td>
                <td class="text-right"><?=ang2($r1['c2']);?></td>
                <td class="text-right"><?=ang2($r1['c3']);?></td>
                <td class="text-right"><?=ang2($r1['c4']);?></td>
                <td class="text-right" nowrap><?=date("y-m-d H:i",$r1['update_at']);?></td>
            </tr>

<?php

$sql2 = "select * from report where st>0 and parent=".$r1['account']." and year=".$year." order by code";
              $res2 = mysqli_query($db, $sql2);
              while($r2 = mysqli_fetch_assoc($res2)) {
                if($r2['trx']==1) {
                  $name='<a href="?op=journal&op2=list&col=account_code&q='.$r2['code'].'&col2=year&q2='.$year.'">'.$r2['name'].'</a>';
                } else {
                  $name= $r2['name'];
                }
                ?>
              <tr>
                  <td><?=$r2['id'];?></td>
                  <td><?=$r2['code'];?></td>
                  <td contenteditable="true" onBlur="colUpdate(this,'account','seq','code','<?=$r2['code'];?>')" onClick="editRow(this);"><?=$r2['seq'];?></td>
                  <td><?=$r2['level'];?></td>
                  <td>---- <?=$name;?></td>
                  <td class="text-right"><?=ang2($r2['c1']);?></td>
                  <td class="text-right"><?=ang2($r2['c2']);?></td>
                  <td class="text-right"><?=ang2($r2['c3']);?></td>
                  <td class="text-right"><?=ang2($r2['c4']);?></td>
                  <td class="text-right" nowrap><?=date("y-m-d H:i",$r2['update_at']);?></td>
              </tr>

<?php

}

}
          ?>  
            
        </tbody>
    </table>    
    <script>
        function editRow(val) {
          $(val).css("background","#e1bee7");
        }
        function colUpdate(val,tbl,col,wc1,wv1) {
          //$(val).css("background","#e1bee7 url(loaderIcon.gif) no-repeat right");
          $.ajax({
            url: "ucol.php",
            type: "POST",
            data:'tbl='+tbl+'&col='+col+'&val='+$(val).text()+'&wc1='+wc1+'&wv1='+wv1,
            success: function(data){
              $(val).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 list_report_4c($parent,$year) {
    global $db,$ar;
    
    //print_r($ar);
    ?>
    <div id="text">
    <p>PT ALFA GLOBAL NIAGA</p>
    <h3><?=$ar['report_category'][$parent];?> </h3>
    <p>Periode 1 Januari - 31 Desember <?=$year;?></p>
    <table class="table table-bordered table-striped table-hover" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>Kode</th>
                <th>Deskripsi</th>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                
            </tr>
        </thead>

<tbody>
        <?php
        $sql = "select * from report where st>0 and parent=".$parent." and year=".$year." order by seq,code";
        $res = mysqli_query($db, $sql);
        //echo $sql;
        while($rw = mysqli_fetch_assoc($res)) {
            
            if($rw['code']==39000 or $rw['code']==13000) {
                $bg1='class="blue lighten-2"';
            } else {
                $bg1='';
            }

?>
        
            <tr><td colspan="6">&nbsp;</td></tr>
            <tr <?=$bg1;?>>
                <td><?=$rw['code'];?></td>
                <td><b><?=$rw['name'];?></b></td>
                <td class="text-right"><?=ang3($rw['c1']);?></td>
                <td class="text-right"><?=ang3($rw['c2']);?></td>
                <td class="text-right"><?=ang3($rw['c3']);?></td>
                <td class="text-right"><?=ang3($rw['c4']);?></td>
                
            </tr>
          <?php

$sql1 = "select * from report where st>0 and parent=".$rw['account']." and year=".$year." order by code";
            $res1 = mysqli_query($db, $sql1);
            while($r1 = mysqli_fetch_assoc($res1)) {
                if($r1['trx']==1) {
                  $name='<a href="?op=journal&op2=list&col=account_code&q='.$r1['code'].'&col2=year&q2='.$year.'">'.$r1['name'].'</a>';
                } else {
                  $name= $r1['name'];
                }
            if($r1['code']==11900 or $r1['code']==12900 or $r1['code']==31900) {
                $bg2='class="blue lighten-4"';
            } else {
                $bg2='';
            }
                
              ?>
            <tr <?=$bg2;?>>
                <td><?=$r1['code'];?></td>
                <td>;;<?=$r1['name'];?></td>
                <td class="text-right"><?=ang3($r1['c1']);?></td>
                <td class="text-right"><?=ang3($r1['c2']);?></td>
                <td class="text-right"><?=ang3($r1['c3']);?></td>
                <td class="text-right"><?=ang3($r1['c4']);?></td>
                
            </tr>

<?php

$sql2 = "select * from report where st>0 and parent=".$r1['account']." and year=".$year." order by code";
              $res2 = mysqli_query($db, $sql2);
              while($r2 = mysqli_fetch_assoc($res2)) {
                if($r2['trx']==1) {
                  $name='<a href="?op=journal&op2=list&col=account_code&q='.$r2['code'].'&col2=year&q2='.$year.'">'.$r2['name'].'</a>';
                } else {
                  $name= $r2['name'];
                }
                if($r2['c1']!=0 or $r2['c2']!=0 or $r2['c3']!=0 or $r2['c4']!=0) {
                ?>
              <tr>
                  <td><?=$r2['code'];?></td>
                  <td>;;;;<?=$r2['name'];?></td>
                  <td class="text-right"><?=ang3($r2['c1']);?></td>
                  <td class="text-right"><?=ang3($r2['c2']);?></td>
                  <td class="text-right"><?=ang3($r2['c3']);?></td>
                  <td class="text-right"><?=ang3($r2['c4']);?></td>
                  
              </tr>

<?php
                }

}

}
          ?>  
            
        </tbody>
    </table>    
    </div>
    <input id="btn" class="btn btn-sm btn-color-blue pull-right" onclick="CopyToClipboard('text')" type="button" value="Copy" />     
    <?php
    
}
function list_report_3c($parent,$year) {
    global $db,$ar;
    
    //print_r($ar);
    ?>
    <div id="text">
    <p>PT ALFA GLOBAL NIAGA</p>
    <h3><?=$ar['report_category'][$parent];?> </h3>
    <p>Periode 1 Januari - 31 Desember <?=$year;?></p>
    <table class="table table-bordered table-striped table-hover" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>Kode</th>
                <th>Deskripsi</th>
                <th></th>
                <th></th>
                <th></th>

</tr>
        </thead>

<tbody>
        <?php
        $sql = "select * from report where st>0 and parent=".$parent." and year=".$year." order by seq,code";
        $res = mysqli_query($db, $sql);
        //echo $sql;
        while($rw = mysqli_fetch_assoc($res)) {
            
            if($rw['code']==90000) {
                $bg='class="purple lighten-4"';
            } else {
                $bg='';
            }

?>
            <tr><td colspan="5">&nbsp;</td></tr>
            <tr <?=$bg;?>>
                <td><?=$rw['code'];?></td>
                <td><b><?=$rw['name'];?></b></td>
                <td class="text-right"><?=ang3($rw['c1']);?></td>
                <td class="text-right"><?=ang3($rw['c2']);?></td>
                <td class="text-right"><?=ang3($rw['c3']);?></td>

</tr>
          <?php

$sql1 = "select * from report where st>0 and parent=".$rw['account']." and year=".$year." order by code";
            $res1 = mysqli_query($db, $sql1);
            while($r1 = mysqli_fetch_assoc($res1)) {
                if($r1['trx']==1) {
                  $name='<a href="?op=journal&op2=list&col=account_code&q='.$r1['code'].'&col2=year&q2='.$year.'">'.$r1['name'].'</a>';
                } else {
                  $name= $r1['name'];
                }
                
            if($r1['code']==59000 or $r1['code']==69000 or $r1['code']==81000 or $r1['code']==79000) {
                $bg2='class="blue lighten-4"';
            } else {
                $bg2='';
            }
              ?>
            <tr <?=$bg2;?>>
                <td><?=$r1['code'];?></td>
                <td>;;<?=$r1['name'];?></td>
                <td class="text-right"><?=ang3($r1['c1']);?></td>
                <td class="text-right"><?=ang3($r1['c2']);?></td>
                <td class="text-right"><?=ang3($r1['c3']);?></td>

</tr>

<?php

$sql2 = "select * from report where st>0 and parent=".$r1['account']." and year=".$year." order by code";
              $res2 = mysqli_query($db, $sql2);
              while($r2 = mysqli_fetch_assoc($res2)) {
                if($r2['trx']==1) {
                  $name='<a href="?op=journal&op2=list&col=account_code&q='.$r2['code'].'&col2=year&q2='.$year.'">'.$r2['name'].'</a>';
                } else {
                  $name= $r2['name'];
                }
                if($r2['c1']!=0 or $r2['c2']!=0 or $r2['c3']!=0 or $r2['c4']!=0) {
                ?>
              <tr>
                  <td><?=$r2['code'];?></td>
                  <td>;;;;<?=$r2['name'];?></td>
                  <td class="text-right"><?=ang3($r2['c1']);?></td>
                  <td class="text-right"><?=ang3($r2['c2']);?></td>
                  <td class="text-right"><?=ang3($r2['c3']);?></td>

</tr>

<?php
                }

}

}
          ?>  
            
        </tbody>
    </table>    
    </div>
    <input id="btn" class="btn btn-sm btn-color-blue" onclick="CopyToClipboard('text')" type="button" value="Copy" />     
    <?php
    
}

function list_report_2c($parent,$year) {
    global $db,$ar;
    
    //print_r($ar);
    ?>
    <div id="text">
    <p>PT ALFA GLOBAL NIAGA</p>
    <h3><?=$ar['report_category'][$parent];?> </h3>
    <p>Periode 1 Januari - 31 Desember <?=$year;?></p>
    <table class="table table-bordered table-striped table-hover" cellspacing="0">
        <thead>
            <tr class="table-primary">
                <th>Kode</th>
                <th>Deskripsi</th>
                <th></th>
                <th></th>

</tr>
        </thead>

?>
            <tr><td colspan="4">&nbsp;</td></tr>
            <tr <?=$bg;?>>
                <td><?=$rw['code'];?></td>
                <td><?=$rw['name'];?></td>
                <td class="text-right"><?=ang3($rw['c1']);?></td>
                <td class="text-right"><?=ang3($rw['c2']);?></td>

</tr>
          <?php

</tr>

<?php

</tr>

<?php
                }

}

}
          ?>  
            
        </tbody>
    </table>
    </div>
    <input id="btn" class="btn btn-sm btn-color-blue" onclick="CopyToClipboard('text')" type="button" value="Copy" />
       
    <?php
    
}

function neraca($year) {
  global $db,$ar;
  
  $sql = "select action_at from journal where year=".$year." order by action_at";
  $res = mysqli_query($db, $sql);
  echo $sql;
  $time=array();
  while($r1 = mysqli_fetch_assoc($res)) {
    $time[]=$r1['action_at'];
  }

echo "<br>".date("d F Y",$time[0])."<br>";
  echo "<br>".date("d F Y",end($time))."<br>";

//echo "<pre>"; print_r($time); echo "</pre>";
  ?>
  <div class="container text-center">
  <h2><?=$ar['company_name'];?></h2>
  <p><?=$ar['company_address'];?><br>
  Phone: <?=$ar['company_phone'].", Email: ".$ar['company_email'].", Instagram: ".$ar['company_ig'].", Tiktok: ".$ar['company_tiktok'];?></p>
  <hr>
  <h3>NERACA</h3>
  <?=date("d F Y",$time[0]);?> - <?=date("d F Y",end($time));?>
  </div>
  <div class="container mt-2">
    <div class="row cyan lighten-4">
      <div class="col-6 pt-2">
        <h5>Aktiva</h5>
      </div>
      <div class="col-6 pt-2">
        <h5>Pasiva</h5>
      </div>
    </div>
    <div class="row">
      <div class="col-6">

</div>
      <div class="col-6">

</div>
    </div>
    <div class="row lime lighten-4">
      <div class="col-6 pt-2">
        <h5>Total Aktiva</h5>
      </div>
      <div class="col-6 pt-2">
        <h5>Total Pasiva</h5>
      </div>
    </div>

</div>

<?php
}