View difference between Paste ID: gguHTqcz and q1VNPFs3

-model:
+model:<?php
 function lihat_outlet1($id_callsheet)
      {
 
 
-		$coba = $this->db->query("select * from tabel_callsheet a, tabel_rute b, tabel_outlet c, tabel_tipe_outlet d, tabel_callsheet_outlet e, tabel_brand f
+		$coba0 = $this->db->query("select * from tabel_callsheet a, tabel_rute b, tabel_outlet c, tabel_tipe_outlet d, tabel_callsheet_outlet e, tabel_brand f
 		where a.id_rute=b.id_rute and b.id_rute=c.id_rute and c.id_tipe_outlet=d.id_tipe_outlet and a.id_callsheet=e.id_callsheet and e.id_brand=f.id_brand and
-		e.id_outlet=c.id_outlet and a.id_callsheet='".$id_callsheet."' group by c.id_outlet")->row_array();
+		e.id_outlet=c.id_outlet and a.id_callsheet='".$id_callsheet."' group by c.id_outlet")->result_array();
 		foreach($coba0 as $coba){
-		$detail = $this->db->query("select * from tabel_callsheet_outlet a, tabel_brand b where a.id_brand=b.id_brand and a.id_callsheet='".$coba['id_callsheet']."'
+		$detail[] = $this->db->query("select * from tabel_callsheet_outlet a, tabel_brand b where a.id_brand=b.id_brand and a.id_callsheet='".$coba['id_callsheet']."'
 		and a.id_outlet='".$coba['id_outlet']."'");
 		}
 		return $detail;
-
+
 ?>
 controller:
 <?php
 public function input_callsheet($id_callsheet)
 	{
 		$id_callsheet= $this->uri->segment(3);
 		$this->load->model("model_brand",'',TRUE);
 		$data['brand']=$this->model_brand->lihat();
 		$data['notasi']=$this->model_brand->lihat();
 
 
 		$this->load->model("model_callsheet");
 		$data['callsheet'] = $this->model_callsheet->lihat_data($id_callsheet);
 		$data['outlet']= $this->model_callsheet->lihat_outlet($id_callsheet);
 		$data['detail']= $this->model_callsheet->lihat_outlet1($id_callsheet);
 
 		$data['title']="PT. Surya Mustika Lampung";
 		$data['user']=$this->session->userdata('username');
 		$data['level']=$this->session->userdata('level');
 
-
+
 	}
-<table width="200%">
+?>
 view:
  <table width="200%">
 		<tr align="center">
 			<td width="1%" rowspan="2"><b>OPTION</b></td>
 			<td width="1%" rowspan="2"><b>NO</b></td>
 			<td width="2%" rowspan="2"><b>KODE OUTLET</b></td>
 			<td width="5%" rowspan="2"><b>NAMA OUTLET</b></td>
 			<td width="8%" rowspan="2"><b>ALAMAT</b></td>
 			<td width="2%" rowspan="2"><b>TIPE OUTLET</b></td>
 			<?php foreach($brand->result_array() as $brand){?>
 			<td width="8%" Colspan="4" align="center"><?php echo $brand['nama_brand'];?></td>
 			<?php } ?>
 		</tr>
 		<tr align="center">
 		<?php foreach($notasi->result_array() as $notasi){?>
 			<td width="2%">STOCK</td>
 			<td width="2%">BUY</td>
 			<td width="2%">NOTE</td>
 			<td width="2%">VIS</td>
 		<?php } ?>
 		</tr>
 		<?php
 		foreach($outlet->result_array() as $outlet){
 		$i++;
 		?>
 		<tr>
 			<td align="center"><img src="<?php echo base_url();?>asset/images/tambah.gif" onclick="window.open('<?php echo base_url();?>callsheet/isi_data/<?php echo $tampil['id_callsheet'];?>/<?php echo $outlet['id_outlet'];?>', 'winpopup', 'toolbar=yes,statusbar=yes,menubar=yes,resizable=yes,scrollbars=yes,width=1200,height=800');" style="cursor:pointer"></td>
 			<td align="center"><?php echo $i;?></td>
 			<td><?php echo $outlet['kode_outlet'];?></td>
 			<td><?php echo $outlet['nama_outlet'];?></td>
 			<td><?php echo $outlet['alamat_outlet'];?></td>
-		foreach($detail->result_array() as $a){
+
 		<?php
 		foreach($detail as $detail1){
 //->result_array() as $a){
 		$a=$detail1->result_array();
 		?>
 			<td align="center"><?php echo $a['stock_outlet'];?></td>
 			<td align="center"><?php echo $a['buy_outlet'];?></td>
 			<td align="center"><?php echo $a['notasi_outlet'];?></td>
 			<td align="center"><?php echo $a['visibility_outlet'];?></td>
 		<?php } ?>
 		</tr>
 
 		<?php } ?>
 		</table>