API tools faq
paste
Advertisement
cdsatrian

layout aset

cdsatrian
Apr 25th, 2014
156
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 7.04 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. /*
  3. USE `test`;
  4.  
  5. DROP TABLE IF EXISTS `kategori_neraca`;
  6. CREATE TABLE IF NOT EXISTS `kategori_neraca` (
  7.   id_kategori_neraca int(11) unsigned not null auto_increment,
  8.   nama_kategori_neraca varchar(100) not null,
  9.   jenis_neraca varchar(10) not null,
  10.   username_pegawai varchar(50) not null,
  11.   PRIMARY KEY (id_kategori_neraca)
  12. ) ENGINE=MyISAM;
  13.  
  14. INSERT INTO `kategori_neraca`
  15. VALUES
  16. (1,'Aset Lancar','AKTIVA','agus'),
  17. (2,'Aset Tidak Lancar','AKTIVA','agus'),
  18. (3,'Aset Lain-lain','AKTIVA','agus');
  19.  
  20. DROP TABLE IF EXISTS `detail_neraca`;
  21. CREATE TABLE IF NOT EXISTS `detail_neraca` (
  22.   id_detail_neraca int(11) unsigned not null auto_increment,
  23.   id_kategori_neraca int(11) unsigned not null,
  24.   nama_neraca varchar(100) not null,
  25.   nilai_neraca DOUBLE,
  26.   PRIMARY KEY (id_detail_neraca)
  27. ) ENGINE=MyISAM;
  28.  
  29. INSERT INTO `detail_neraca`
  30. VALUES
  31. (1,1,'Biaya dibayar dimuka',0),
  32. (2,1,'Biaya dibayar dibelakang',368000000.0),
  33. (3,1,'Efek dimiliki dan jatuh tempo',4000000.0),
  34. (4,2,'Kas dan Setara Kas',4000000.0),
  35. (5,2,'Pajak dibayar di muka',10000000.0),
  36. (6,2,'Kas',100000000.0);
  37.  
  38. DROP TABLE IF EXISTS `subkategori_neraca`;
  39. CREATE TABLE IF NOT EXISTS `subkategori_neraca` (
  40.   id_subkategori_neraca int(11) unsigned not null auto_increment,
  41.   id_detail_neraca int(11) unsigned not null,
  42.   nama_subkategori varchar(100) not null,
  43.   nilai_neraca DOUBLE,
  44.   PRIMARY KEY (id_subkategori_neraca)
  45. ) ENGINE=MyISAM;
  46.  
  47. INSERT INTO `subkategori_neraca`
  48. VALUES
  49. (1,1,'Piutang Satu',90000.0),
  50. (2,1,'Piutang Dua',190000.0),
  51. (3,1,'Piutang Tiga',987000000.0),
  52. (4,1,'Piutang Empat',98043000.0),
  53. (5,1,'Piutang Lima',9000000.0);
  54. */
  55. $dbhost='localhost';
  56. $dbuser='root';
  57. $dbpass='';
  58. $dbname='test';
  59. //$db=new mysqli($dbhost,$dbuser,$dbpass,$dbname);
  60. $db=mysql_connect($dbhost,$dbuser,$dbpass);
  61. mysql_select_db($dbname);
  62. ?>
  63. <!DOCTYPE html>
  64. <html>
  65.   <head>
  66.     <title>Neraca</title>
  67.     <style>
  68.       .h1 {background-color:#33e;font-weight:bold;}
  69.       .h2 {background-color:#aaf;font-weight:bold;}
  70.       .h0 {color:#fff;background-color:#336;font-weight:bold;}
  71.     </style>
  72.   </head>
  73.   <body>
  74.     <table border='1'>
  75.       <thead>
  76.         <tr class='h0'>
  77.           <th colspan='2'>ASET</th>
  78.           <th>Aksi</th>
  79.         </tr>
  80.       </thead>
  81.       <tbody>
  82.       <?php
  83.       $kategori=$detail='';
  84.       $h1=$h2=$h3=0;
  85.       $sql="
  86.            SELECT
  87.               k.id_kategori_neraca,
  88.               k.nama_kategori_neraca,
  89.               d.id_detail_neraca,
  90.               d.nama_neraca,
  91.               s.nama_subkategori,
  92.               IF(ISNULL(s.nilai_neraca),d.nilai_neraca,s.nilai_neraca) AS nilai_neraca
  93.            FROM kategori_neraca k
  94.            LEFT JOIN detail_neraca d USING(id_kategori_neraca)
  95.            LEFT JOIN subkategori_neraca s USING(id_detail_neraca)
  96.            WHERE
  97.             k.username_pegawai='agus'
  98.             AND k.jenis_neraca='AKTIVA'
  99.            ORDER BY k.id_kategori_neraca,d.id_detail_neraca,s.id_subkategori_neraca";          
  100.       //$result=$db->query($sql);
  101.       $result=mysql_query($sql);
  102.       //while($data=$result->fetch_object())
  103.       while($data=mysql_fetch_object($result))
  104.       {
  105.         if($kategori!=$data->nama_kategori_neraca){
  106.           $kategori=$data->nama_kategori_neraca;
  107.           echo "<tr class='h1'><td colspan='3'>".(++$h1).". $kategori</td></tr>\n";
  108.           $h2=0;
  109.         }
  110.         if($detail!=$data->nama_neraca){
  111.           $detail=$data->nama_neraca;
  112.           echo (empty($data->nama_subkategori)?(empty($data->nilai_neraca)?"":"<tr class='h2'><td>".($h1).".".(++$h2).".$detail </td>"):"<tr class='h2'><td colspan='3'>".($h1).".".(++$h2).".$detail</td></tr>\n");
  113.           $h3=0;
  114.         }
  115.         echo (empty($data->nama_subkategori)?"":"<tr><td width='250'>{$h1}.{$h2}.".(++$h3).". {$data->nama_subkategori}</td>");
  116.         echo (empty($data->nilai_neraca)?"":"<td align='right'>".number_format($data->nilai_neraca,2)."</td><td align='center'>edit|del</td></tr>\n");
  117.       }
  118.       //$result->close();
  119.       ?>
  120.       </tbody>
  121.     </table>
  122.     <hr/>
  123.     <table border='1'>
  124.       <thead>
  125.         <tr class='h0'>
  126.           <th colspan='4'>ASET</th>
  127.           <th>Aksi</th>
  128.         </tr>
  129.       </thead>
  130.       <tbody>
  131.       <?php
  132.       $sql="
  133.            SELECT
  134.               k.id_kategori_neraca,
  135.               k.nama_kategori_neraca,
  136.               d.id_detail_neraca,
  137.               d.nama_neraca,
  138.               ( SELECT COUNT(1)
  139.                 FROM detail_neraca
  140.                 LEFT JOIN subkategori_neraca USING(id_detail_neraca)
  141.                 WHERE id_kategori_neraca=k.id_kategori_neraca
  142.               ) AS jml_detail,
  143.               s.nama_subkategori,
  144.               IF(ISNULL(s.nilai_neraca),d.nilai_neraca,s.nilai_neraca) AS nilai_neraca,
  145.               ( SELECT COUNT(1)
  146.                 FROM subkategori_neraca
  147.                 WHERE id_detail_neraca=d.id_detail_neraca
  148.               ) AS jml_subkategori
  149.            FROM kategori_neraca k
  150.            LEFT JOIN detail_neraca d USING(id_kategori_neraca)
  151.            LEFT JOIN subkategori_neraca s USING(id_detail_neraca)
  152.            WHERE
  153.             k.username_pegawai='agus'
  154.             AND k.jenis_neraca='AKTIVA'
  155.            ORDER BY k.id_kategori_neraca,d.id_detail_neraca,s.id_subkategori_neraca";
  156.       //$result=$db->query($sql);
  157.       $result=mysql_query($sql);
  158.       $jml_detail=0;
  159.       $jml_sub=0;
  160.       $h1=0;
  161.       //while($data=$result->fetch_object())
  162.       while($data=mysql_fetch_object($result))
  163.       {
  164.         echo "<tr valign='top'>";
  165.         if($jml_detail<=1){
  166.           $jml_detail=$data->jml_detail;
  167.           echo "<td rowspan='{$jml_detail}'".($data->jml_detail==0?" colspan='3'":'').">"
  168.               .(++$h1).".{$data->nama_kategori_neraca}</td>";        
  169.           if($jml_sub<=1){
  170.             $h2=1;
  171.             $h3=0;
  172.             $jml_sub=$data->jml_subkategori;
  173.             echo ($data->jml_detail==0?"":"<td rowspan='{$jml_sub}'".($data->jml_subkategori==0?" colspan='2'":'').">"
  174.                 ."{$h1}.{$h2}.{$data->nama_neraca}</td>")
  175.                 .($data->jml_subkategori==0?'':"<td>{$h1}.{$h2}.".(++$h3).".{$data->nama_subkategori}</td>")
  176.                 ."<td align='right'>".number_format($data->nilai_neraca,2)."</td>";
  177.           }else{
  178.             $jml_sub--;
  179.           }
  180.         }else{
  181.           $jml_detail--;
  182.           if($jml_sub<=1){
  183.             $h3=0;
  184.             $jml_sub=$data->jml_subkategori;
  185.             echo "<td rowspan='{$jml_sub}'".($data->jml_subkategori==0?" colspan='2'":'').">{$h1}.".(++$h2).".{$data->nama_neraca}</td>"
  186.                ."<td align='right'>".number_format($data->nilai_neraca,2)."</td>";      
  187.           }else{
  188.             $jml_sub--;
  189.             echo "<td>{$h1}.{$h2}.".(++$h3).".{$data->nama_subkategori}</td>
  190.                 <td align='right'>".number_format($data->nilai_neraca,2)."</td>";
  191.            
  192.           }
  193.         }    
  194.         echo "<td align='center'>edit|del</td></tr>\n";
  195.       }
  196.       //$result->close();
  197.       //$db->close();
  198.       ?>
  199.       </tbody>
  200.     </table>
  201.   </body>
  202. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!