Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function lap_member_sales($dcetak='',$dcetak2='',$member='',$nm_member=''){
- $lcnosp2d3 = str_replace('123456789','/',$this->uri->segment(4));
- $dokumen = str_replace('987654321',' ',$lcnosp2d3);
- $tglperiode = $this->tukd_model->tanggal_format_indonesia($dcetak);
- $tglperiode2 = $this->tukd_model->tanggal_format_indonesia($dcetak2);
- $cRet ='<TABLE width="100%" border="0">
- <tr>
- <TD align="center" ><b> <br><B>LAPORAN PENDAPATAN PER MEMBER</TD>
- </tr>
- </TABLE>';
- $cRet .="<table width='100%' border='0' >
- <tr>
- <td align='left' width='18%'>Nama Member</td>
- <td width='1%'>:</td>
- <td>$nm_member</td>
- </tr>
- <tr>
- <td width='18%'>Periode</td>
- <td width='1%'>:</td>
- <td> $tglperiode S/D $tglperiode2 </td>
- </tr></table>";
- $cRet .="<table width='100%' border='1' cellpadding='0' cellspacing='0'>
- <tr>
- <td width=\"20%\" bgcolor=\"#CCCCCC\" align='center'><B>No Bukti</B></td>
- <td width=\"9%\" bgcolor=\"#CCCCCC\" align='center'><B>Member</B></td>
- <td width=\"9%\" bgcolor=\"#CCCCCC\" align='center'><B>Tanggal</B></td>
- <td width=\"20%\" bgcolor=\"#CCCCCC\" align='center'><B>Tgl Tempo</B></td>
- <td width=\"7%\" bgcolor=\"#CCCCCC\" align='center'><B>Keterangan</B></td>
- <td width=\"7%\" bgcolor=\"#CCCCCC\" align='center'><B>Piutang</B></td>
- <td width=\"20%\" bgcolor=\"#CCCCCC\" align='center'><B>Bayar</B></td>
- <td width=\"9%\" bgcolor=\"#CCCCCC\" align='center'><B>Saldo</B></td>
- </tr>
- ";
- $sql = "SELECT * FROM (
- SELECT a.no_bukti,a.tgl_bukti,a.tgl_tempo,a.ket,a.kd_sales,a.nm_member,(SELECT alamat FROM ms_member WHERE kd_member=a.kd_member) AS alamat,SUM(b.qty) AS jm_utang,SUM(b.nilai) AS totnil,''AS byr
- FROM trhjual a inner join trbyrpiutang_jual JOIN trdjual b ON a.no_bukti=b.no_bukti WHERE a.sts_jual='1' GROUP BY a.kd_member,a.tgl_bukti,a.tgl_tempo
- UNION
- SELECT d.no_kas AS no_bukti,d.tgl_kas AS tgl_bukti,''AS tgl_tempo,d.ket,c.kd_sales,c.nm_member,(SELECT alamat FROM ms_member WHERE kd_member=c.kd_member) AS alamat, '' jm_utang,''AS totnil,SUM(d.nilai) AS byr
- FROM trhjual c INNER JOIN trbyrpiutang_jual d ON c.kd_member=d.kd_member WHERE c.sts_jual='1' GROUP BY c.kd_member,c.tgl_bukti )AS t
- ORDER BY nm_member,tgl_bukti ";
- $query1 = $this->db->query($sql);
- $ii = 0;
- $tot=0;
- $totnil=0;
- // $member1 ='';
- $memberActive='';
- /*
- ------------------------------------------
- BEGINI?
- -------------------------------------
- */
- foreach($query1->result_array() as $resulte)
- {
- if($memberActive!= $resulte['nm_member']){
- $memberActive = $resulte['nm_member'];
- $saldo=0;
- }
- $ii = $ii+1;
- $no_bukti = $resulte['no_bukti'];
- $tgl = $resulte['tgl_bukti'];
- $tempo = $resulte['tgl_tempo'];
- $member = $resulte['nm_member'];
- $ket = $resulte['ket'];
- $piutang =$resulte['totnil'];// number_format($resulte['totnil'],2,',','.');
- $bayar =$resulte['byr'];// number_format($resulte['byr'],2,',','.');
- $tot = $tot+$resulte['totnil'];
- $totnil= $totnil+$resulte['byr'];
- $saldo = $saldo + $resulte['totnil'] - $resulte['byr'];
- $cRet .="<tr>
- <td>$no_bukti</td>
- <td>$member $member1</td>
- <td>$tgl</td>
- <td align='left'>$tempo</td>
- <td align='right'>$ket</td>
- <td align='right'>$piutang</td>
- <td align='right'>$bayar</td>
- <td align='right'>".number_format($saldo,2,',','.')."</td>
- </tr>
- ";
- }
- $cRet .="<tr>
- <td colspan=\"5\" align='center'><b>Jumlah</td>
- <td align='right'><b>".number_format($tot,2,',','.')."</td>
- <td align='right'><b>".number_format($totnil,2,',','.')."</td>
- <td align='left'></td>
- </tr>
- ";
- $cRet .="</table>";
- $cRet .= "<table width=\"100%\" border=\"0\" cellpadding = \"10\" >
- </table>";
- $this->template->set('title', ' ');
- $this->tukd_model->_mpdf('',$cRet,25,8,5,'0');
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement