View difference between Paste ID: 5C7HmHZs and Aajttm3L

 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');
 
         	}