fin2@agn
BNI-PT
Man-PT
KasKecil
BCA 671
Man 709
Account Tree
db backup
eBook #1
eBook #2
eBook #3
Tax eBook #4
Color
Logout
Mutasi BNI PT
Mutasi Mandiri PT
Mutasi Mandiri 709
Mutasi Mandiri 202
Mutasi BCA 671
Mutasi BCA 471
Mutasi Jago
Action
Transaction
Journal
Report
FilePHP
Tes cURL [1]
Copy This
Save
folder
slug
param
method
body
remark
php
Copy
/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"> </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"> </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> <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><td colspan="4"> </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 $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['code'];?></td> <td>;;<?=$r1['name'];?></td> <td class="text-right"><?=ang3($r1['c1']);?></td> <td class="text-right"><?=ang3($r1['c2']);?></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> </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 } ?>