Web Programming 7

 

>template->load(template().'/template', 

template().'/reseller/view_reseller_produk',$data); 

}else{ 

282 

redirect('main'); 

} 

} 

 

function keranjang(){ 

$id_reseller = $this->uri->segment(3); 

$id_produk   = $this->uri->segment(4); 

$j = $this->model_reseller->jual_reseller($id_reseller, 

$id_produk)->row_array(); 

$b=$this->model_reseller->beli_reseller($id_reseller, 

$id_produk)->row_array(); 

$stok = $b['beli']-$j['jual']; 

$qty = $this->input->post('qty'); 

if ($id_produk!=''){ 

if ($stok < $qty){ 

$produk = $this->model_app->edit('rb_produk', array 

('id_produk'=>$id_produk))->row_array(); 

$produk_cek = filter($produk['nama_produk']); 

echo "<script>window.alert('Maaf, Stok untuk Produk 

$produk_cek pada Pelapak ini telah habis, silahkan menunggu 

atau order dengan pelapak lain!'); 

window.location=('".base_url()."/produk/produk_reseller/$i

d_reseller')</script>"; 

}else{ 

$this->session->unset_userdata('produk'); 

if ($this->session->idp == ''){ 

$idp = 'TRX-'.date('YmdHis'); 

283 

$this->session->set_userdata(array('idp'=>$idp, 

'reseller'=>$id_reseller)); } 

$cek=$this->model_app->view_where('rb_ penjualan_ temp', 

array('session'=>$this->session-> 

idp,'id_produk'=>$id_produk))->num_rows(); 

if ($this->session->reseller==$id_reseller){ 

if ($cek >=1){ 

$this->db->query("UPDATE rb_penjualan_temp SET 

jumlah=jumlah+$qty where session='".$this-> session-> idp."' 

AND id_produk='$id_produk'"); 

}else{ 

$harga=$this->model_app->view_where('rb_ produk', 

array('id_produk'=>$id_produk))-> row_array(); 

$disk = $this->model_app->edit('rb_produk_diskon', array  

('id_produk'=>$id_produk,'id_reseller'=>$id_reseller))-> 

row_array(); 

$harga_konsumen = $harga['harga_konsumen']; 

$data = array('session'=>$this->session->idp, 

'id_produk'=>$id_produk, 'jumlah'=>$qty, 'diskon'=> 

$disk['diskon'], 'harga_jual'=>$harga_konsumen, 

'satuan'=>$harga['satuan'],'waktu_order'=>date('Y-m-d 

H:i:s')); 

$this->model_app->insert('rb_penjualan_temp', $data); 

} 

redirect('produk/keranjang'); 

}else{ 

if ($this->session->idp != ''){ 

284 

$data['rows'] = $this->model_app->edit('rb_reseller', array 

('id_reseller'=>$this->session->reseller))-> row_array(); 

$data['record']=$this->model_app->view_join_where 

('rb_penjualan_temp','rb_produk','id_produk',array('session'=

>$this->session->idp),'id_penjualan_ detail','ASC'); 

} 

$data['title'] = 'Keranjang Belanja'; 

$data['description'] = description(); 

$data['keywords'] = keywords(); 

echo $this->session->set_flashdata('message', '<div 

class="alert alert-danger"><center>Maaf, Dalam 1 Transaksi 

hanya boleh order dari 1 Reseller saja. </center></div>'); 

redirect('produk/keranjang'); 

} 

} 

}else{ 

if ($this->session->idp != ''){ 

$data['rows'] = $this->model_app->edit('rb_reseller', 

array('id_reseller'=>$this->session->reseller))-> row_array(); 

$data['record']=$this->model_app->view_join_ where 

('rb_penjualan_temp','rb_produk','id_produk',array 

('session'=>$this->session->idp),'id_penjualan_ detail','ASC'); 

} 

$data['title'] = 'Keranjang Belanja'; 

$this->template->load(template().'/template', 

template().'/reseller/view_keranjang',$data); } } 

 

function keranjang_detail(){ 

285 

$data['rows'] = $this->model_reseller->penjualan_ 

konsumen_detail($this->uri->segment(3))-> row_array(); 

$data['record']=$this->model_app->view_join_ where 

('rb_penjualan_temp','rb_produk','id_produk',array 

('session'=>$this->uri->segment(3)), 

'id_penjualan_detail','ASC'); 

$data['title'] = 'Detail Belanja'; 

$this->template->load(template().'/template', 

template().'/reseller/view_keranjang_detail',$data); 

} 

 

function keranjang_delete(){ 

$id=array('id_penjualan_detail'=>$this->uri-> segment (3)); 

$this->model_app->delete('rb_penjualan_temp',$id); 

$isi_keranjang = $this->db->query("SELECT sum (jumlah) as 

jumlah FROM rb_penjualan_temp where session='".$this  -> 

session->idp."'")->row_array(); 

if ($isi_keranjang['jumlah']==''){ 

$this->session->unset_userdata('idp'); 

$this->session->unset_userdata('reseller'); 

} 

redirect('produk/keranjang'); 

} 

 

function checkouts(){ 

if (isset($_POST['submit'])){ 

if ($this->session->idp!=''){ 

$this->load->library('email'); 

286 

$data = array('username'=>$this->input->post('b'), 

'password'=>hash("sha512", md5(date('YmdHis'))), 

'nama_lengkap'=>$this->input->post('a'), 'email'=> $this-> 

input->post('b'),'jenis_kelamin'=>'Laki-laki', 'tanggal_lahir' 

=>date('Y-m-d'),'tempat_lahir'=> 'Belum ada informasi', 

'alamat_lengkap'=>$this-> input-> post('c'),'kecamatan' 

=>$this->input->post ('g'),'kota_id'=>$this->input-> 

post('f'),'no_hp'=>$this ->input->post('h'), 

'tanggal_daftar'=>date('Y-m-d H:i:s')); 

$this->model_app->insert('rb_konsumen',$data); 

$id = $this->db->insert_id(); 

$data = array('kode_transaksi'=>$this->session->idp, 

'id_pembeli'=>$id,'id_penjual'=>$this->session->reseller, 

'status_pembeli'=>'konsumen',  'status_ penjual'=>'reseller', 

'waktu_transaksi'=>date('Y-m-d H:i:s'), 'proses'=>'0'); 

$this->model_app->insert('rb_penjualan',$data); 

$idp = $this->db->insert_id(); 

$keranjang = $this->model_app->view_where ('rb_penjualan 

_temp',array('session'=>$this->session-> idp)); 

foreach ($keranjang->result_array() as $row) { 

$dataa = array('id_penjualan'=>$idp, 'id_produk'=> $row 

['id_produk'],'jumlah'=>$row['jumlah'], 'harga_ jual' => $row 

['harga_jual'], 'satuan'=>$row ['satuan']); $this->model_app-> 

insert('rb_penjualan_detail', $dataa);  

} 

$session = array('session' => $this->session->idp); 

$this->model_app->delete('rb_penjualan_temp', $session); 

$data['title'] = 'Transaksi Success'; 

287 

$data['email'] = $this->input->post('b'); 

$data['orders'] = $this->session->idp; 

$iden = $this->model_app->view_where('tb_identitas', array 

('id_identitas'=>'1'))->row_array(); 

$res = $this->model_app->view_where('rb_reseller', array 

('id_reseller'=>$this->session->reseller))-> row_array(); 

$alamat = $this->db->query("SELECT a.nama_kota as kota, 

b.nama_provinsi as propinsi FROM `rb_kota`a JOIN 

rb_provinsi b ON a.provinsi_id=b.provinsi_id where 

a.kota_id='".$this->input->post('f')."'") -> row_array(); 

$data['rekening_reseller']=$this->model_app-> view_where 

('rb_rekening_reseller',array('id_reseller'=>$this->session   -> 

reseller)); 

$email_tujuan = $this->input->post('b'); 

$tglaktif = date("d-m-Y H:i:s"); 

$subject="$iden[nama_website]-Detail Orderan anda"; 

$message="<html><body>Halooo!<b>".$this->input-> post 

('a')."</b> ... <br> Hari ini pada tanggal <span 

style='color:red'>$tglaktif</span> Anda telah order produk di 

$iden[nama_website]. 

<br><table style='width:100%;'> 

<tr><td style='background:#337ab7; color:#fff; pading: 20px' 

cellpadding=6 colspan='2'><b>Berikut Data Anda : 

</b></td></tr> 

<tr><td width='140px'><b>Nama Lengkap</b></td>  <td> : 

".$this->input->post('a')."</td></tr> 

<tr><td><b>Alamat Email</b></td>  

<td> : ".$this->input->post('b')."</td></tr> 

288 

<tr><td><b>No Telpon</b></td>    

<td> : ".$this->input->post('h')."</td></tr> 

<tr><td><b>Alamat</b></td>    

<td> : ".$this->input->post('c')." </td></tr> 

<tr><td><b>Provinsi</b></td>    

<td> : ".$alamat['propinsi']." </td></tr> 

<tr><td><b>Kabupaten/Kota</b></td>   

<td> : ".$alamat['kota']." </td></tr> 

<tr><td><b>Kecamatan</b></td>    

<td> : ".$this->input->post('g')." </td></tr> 

</table><br> 

<table style='width:100%;'> 

<tr><td style='background:#337ab7; color:#fff; pading:20px' 

cellpadding=6 colspan='2'><b>Berikut Data Reseller : 

</b></td></tr> 

<tr><td width='140px'><b>Nama Reseller</b></td> 

<td> : ".$res['nama_reseller']."</td></tr> 

<tr><td><b>Alamat</b></td>    

<td> : ".$res['alamat_lengkap']."</td></tr> 

<tr><td><b>No Telpon</b></td>    

<td> : ".$res['no_telpon']."</td></tr> 

<tr><td><b>Email</b></td>    

<td> : ".$res['email']." </td></tr> 

<tr><td><b>Keterangan</b></td>   

<td> : ".$res['keterangan']." </td></tr> 

</table><br> 

No Orderan anda : <b>".$this->session->idp." </b> <br> 

Berikut Detail Data Orderan Anda : 

289 

<table style='width:100%;' class='table table-striped'> 

<thead> 

<tr bgcolor='#337ab7'> 

<th style='width:40px'>No</th> 

<th width='47%'>Nama Produk</th> 

<th>Harga</th> 

<th>Qty</th> 

<th>Berat</th> 

<th>Subtotal</th> 

</tr> 

</thead> 

<tbody>"; 

$no = 1; 

$belanjaan = $this->model_app->view_join_where 

('rb_penjualan_detail','rb_produk','id_produk',array 

('id_penjualan'=>$idp),'id_penjualan_detail','ASC'); 

foreach ($belanjaan as $row){ 

$sub_total = ($row['harga_jual']*$row['jumlah']); 

$message .= "<tr bgcolor='#e3e3e3'><td>$no</td> 

<td>$row[nama_produk]</td> 

<td>".rupiah($row['harga_jual'])."</td> 

<td>$row[jumlah]</td> 

<td>".($row['berat']*$row['jumlah'])." Gram</td> 

<td>Rp ".rupiah($sub_total)."</td> 

</tr>"; 

$no++; 

} 

290 

$total = $this->db->query("SELECT sum((a.harga_ jual* 

a.jumlah)-a.diskon) as total, sum(b.berat* a.jumlah) as 

total_berat FROM `rb_penjualan_detail` a JOIN rb_produk b 

ON a.id_produk=b.id_produk where a.id_penjualan='". 

$idp."'")->row_array(); 

$message .= "<tr bgcolor='lightgreen'> 

<td colspan='5'><b>Total Harga</b></td> 

<td><b>Rp ".rupiah($total['total'])."</b></td> 

</tr> 

<tr bgcolor='lightblue'> 

<td colspan='5'><b>Total Berat</b></td> 

<td><b>$total[total_berat] Gram</b></td> 

</tr> 

</tbody> 

</table><br> 

Silahkan melakukan pembayaran ke rekening reseller : 

<table style='width:100%;' class='table table-hover table-

condensed'> 

<thead> 

<tr bgcolor='#337ab7'> 

<th width='20px'>No</th> 

<th>Nama Bank</th> 

<th>No Rekening</th> 

<th>Atas Nama</th> 

</tr> 

</thead> 

<tbody>"; 

$noo = 1; 

291 

$rekening=$this->model_app->view_where('rb_ 

rekening_reseller',array('id_reseller'=>$this-> session-> 

reseller)); 

foreach ($rekening->result_array() as $row){ 

$message .= "<tr bgcolor='#e3e3e3'><td>$noo</td> 

<td>$row[nama_bank]</td> 

<td>$row[no_rekening]</td> 

<td>$row[pemilik_rekening]</td> 

</tr>"; 

$noo++; 

} 

$message .= "</tbody> 

</table><br><br> 

Jika sudah melakukan transfer, jangan lupa konfirmasi 

transferan anda 

<a href='".base_url()."konfirmasi'>disini</a> <br> 

Admin, $iden[nama_website] </body></html> \n"; 

$this->email->from($iden['email'], $iden['nama_website']); 

$this->email->to($email_tujuan); 

$this->email->cc(''); 

$this->email->bcc(''); 

$this->email->subject($subject); 

$this->email->message($message); 

$this->email->set_mailtype("html"); 

$this->email->send(); 

$config['protocol'] = 'sendmail'; 

$config['mailpath'] = '/usr/sbin/sendmail'; 

$config['charset'] = 'utf-8'; 

292 

$config['wordwrap'] = TRUE; 

$config['mailtype'] = 'html'; 

$this->email->initialize($config); 

$this->session->unset_userdata('idp'); 

$this->session->unset_userdata('reseller'); 

$this->template->load('phpmu-one/template','phpmu-one/ 

view_order_success', $data); 

}else{ 

redirect('produk/keranjang'); 

} 

}else{ 

if ($this->session->id_konsumen==''){ 

redirect('auth/login'); 

}else{ 

$data['title'] = 'Data Pelanggan'; 

$data['provinsi'] = $this->model_app->view_ordering 

('rb_provinsi','provinsi_id','DESC'); 

$this->template->load('phpmu-one/template', 'phpmu-one 

/view_checkouts',$data); 

$this->template->load(template().'/template', 

template().'/reseller/view_checkouts',$data); 

} 

} 

} 

 

function order(){ 

$this->session->set_userdata(array('produk'=>$this->uri-> 

segment(3))); 

293 

redirect('produk/reseller'); } 

 

public function detail(){ 

$ids = $this->uri->segment(3); 

$dat = $this->db->query("SELECT * FROM rb_produk where 

produk_seo='$ids' AND id_reseller!='0'"); 

$row = $dat->row(); 

$total = $dat->num_rows(); 

if ($total == 0){ 

redirect('main'); 

} 

$data['title'] = $row->nama_produk; 

$data['record'] = $this->model_app->view_where 

('rb_produk',array('id_produk'=>$row->id_produk))-> 

row_array(); 

$this->template->load(template().'/template', 

template().'/reseller/view_produk_detail',$data); 

} 

} 

 

6.10 Membuat Keranjang Belanja 

a. View_Keranjang.php 

<p class='sidebar-title text-danger produk-title'> Berikut Data 

Pesanan anda</p> 

<div class='col-md-8'> 

<?php  

echo"<form action='".base_url()."members/selesai_ belanja' 

method='POST'>"; 

294 

echo $error_reseller;  

if ($this->session->idp == ''){ 

echo "<center style='padding:10%'> <i class='text-danger'> 

Maaf, Keranjang belanja anda saat ini masih 

kosong,...</i><br> 

<a class='btn btn-warning btn-sm' href='".base_url()." 

members/reseller'>Klik Disini Untuk mulai Belanja! 

</a></center>"; 

  }else{ 

?> 

<?php  

echo "<a class='btn btn-success btn-sm' href='".base_url(). 

"members/produk_reseller/$rows[id_reseller]'>Lanjut 

Belanja</a> 

<a class='btn btn-danger btn-sm' href='".base_url() 

."members/batalkan_transaksi' onclick=\"return confirm 

('Apa anda yakin untuk Batalkan Transaksi ini?')\">Batalkan 

Transaksi</a>";  

?> 

<div style="clear:both"><br></div> 

<table class="table table-striped table-condensed"> 

<tbody> 

<?php  

$no = 1; 

foreach ($record as $row){ 

$ex = explode(';', $row['gambar']); 

if (trim($ex[0])==''){ $foto_produk = 'no-image.png'; }else{ 

$foto_produk = $ex[0]; } 

295 

$sub_total = ($row['harga_jual']*$row['jumlah'])-

$row['diskon']; 

echo "<tr><td>$no</td> 

<td width='70px'><img style='border:1px solid #cecece; 

width:60px' src='".base_url()."asset/foto_ 

produk/$foto_produk'></td> 

<td><a style='color:#ab0534' href='".base_url()." 

produk/detail/$row[produk_seo]'><b>$row[nama_ 

produk]</b></a> 

<br>Qty.<b>$row[jumlah]</b>, Harga. Rp ".rupiah 

($row['harga_jual']-$row['diskon'])."/$row [satuan],  

<br>Berat.<b>".($row['berat']*$row['jumlah'])." 

Gram</b></td> 

<td>Rp ".rupiah($sub_total)."</td> 

<td width='30px'><a class='btn btn-danger btn-xs' 

title='Delete'href='".base_url()."members /keranjang_ 

delete/$row[id_penjualan_detail]'><span class= 'glyphicon 

glyphicon-remove'> </span></a></td> 

</tr>"; 

$no++; 

} 

$total = $this->db->query("SELECT sum((a.harga_jual 

*a.jumlah)-a.diskon) as total, sum(b.berat*a.jumlah) as 

total_berat FROM `rb_penjualan_detail` a JOIN rb_produk b 

ON a.id_produk=b.id_produk where a.id_penjualan='".$this-> 

session->idp."'")->row_array (); 

echo "<tr class='success'> 

<td colspan='3'><b>Total Berat</b></td> 

296 

<td><b>$total[total_berat] Gram</b></td> 

<td></td> 

</tr> 

</tbody> 

</table> 

<div class='col-md-4 pull-right'> 

<center>Total Bayar <br><h2 id='totalbayar'></h2>    

<button type='submit' name='submit' id='oksimpan' class='btn 

btn-success btn-flat btn-sm' style='display: none'>Lakukan 

Pembayaran</button> 

</center> 

</div>"; 

$ket = $this->db->query("SELECT * FROM rb_keterangan 

where id_reseller='".$rows['id_ reseller']."'")->row_array(); 

$diskon_total = '0'; 

?> 

<input type="hidden" name="total" id="total" value="<?php 

echo $total['total']; ?>"/> 

<input type="hidden" name="ongkir" id="ongkir" 

value="0"/> 

<input type="hidden" name="berat" value="<?php echo 

$total['total_berat']; ?>"/> 

<input type="hidden" name="diskonnilai" id= "diskonnilai" 

value="<?php echo $diskon_total; ?>"/> 

<div class="form-group"> 

<label class="col-sm-2 control-label" for="">Pilih 

Kurir</label> 

<div class="col-md-10"> 

297 

<?php        

$kurir=array('jne','pos','tiki'); 

foreach($kurir as $rkurir){ 

?>           

<label class="radio-inline"> 

<input type="radio" name="kurir" class="kurir" value="<?php 

echo $rkurir; ?>"/> <?php echo strtoupper($rkurir); ?> 

</label> 

<?php 

} 

?> 

<label class="radio-inline"><input type="radio" name="kurir" 

class="kurir" value="cod"/> COD (Cash on delivery)</label> 

</div> 

</div> 

<div id="kuririnfo" style="display: none;"> 

<div class="form-group"> 

<div class="col-md-12"> 

<div class='alert alert-info' style='padding:5px; border-

radius:0px; margin-bottom:0px'> Service </div> 

<p class="form-control-static" id="kurirserviceinfo"> </p> 

</div> 

</div> 

</div> 

<?php 

echo form_close(); 

?> 

<script> 

298 

$(document).ready(function(){ 

$(".kurir").each(function(o_index,o_val){ 

$(this).on("change",function(){ 

var did=$(this).val(); 

var berat="<?php echo $total['total_berat']; ?>"; 

var kota="<?php echo $rows['kota_id']; ?>"; 

$.ajax({ 

method: "get", 

dataType:"html", 

url: "<?php echo base_url(); ?>produk/kurirdata", 

data: "kurir="+did+"&berat="+berat+"&kota="+kota, 

beforeSend:function(){ 

$("#oksimpan").hide(); 

} 

}) 

.done(function( x ) {            

$("#kurirserviceinfo").html(x); 

$("#kuririnfo").show();          

}) 

.fail(function(  ) { 

$("#kurirserviceinfo").html(""); 

$("#kuririnfo").hide(); 

}); 

}); 

}); 

$("#diskon").html(toDuit(0)); 

hitung(); 

}); 

299 

 

function hitung(){ 

var diskon=$('#diskonnilai').val(); 

var total=$('#total').val(); 

var ongkir=$("#ongkir").val(); 

var bayar=(parseFloat(total)+parseFloat(ongkir)); 

if(parseFloat(ongkir) > 0){ 

$("#oksimpan").show(); 

}else{ 

$("#oksimpan").hide(); 

} 

$("#totalbayar").html(toDuit(bayar)); 

} 

</script> 

<?php  

echo "<div style='clear:both'></div><hr><br>$ket 

[keterangan]";  

} 

?> 

</div> 

<div class="col-sm-4 colom4"> 

<?php $res = $this->db->query("SELECT a.*, b.nama_kota, 

c.nama_provinsi FROM rb_reseller a JOIN rb_kota b ON 

a.kota_id=b.kota_id rb_provinsi c ON 

b.provinsi_id=c.provinsi_id where a.id_reseller= 

'$rows[id_reseller]'")->row_array(); ?> 

<table class='table table-condensed'> 

<tbody> 

300 

<tr class='alert alert-info'><th scope='row' style 

='width:90px'>Pengirim</th><td><?php echo $res 

['nama_reseller']?></td></tr> 

<tr class='alert alert-info'><th scope='row'>Alamat 

</th><td><?php echo $res['alamat_lengkap'].', '.$res 

['nama_kota'].', '.$res['nama_provinsi']; ?></td></tr> 

</tbody> 

</table> 

<?php $usr = $this->db->query("SELECT a.*, b.nama_kota, 

c.nama_provinsi FROM rb_konsumen a JOIN rb_kota b ON 

a.kota_id=b.kota_id JOIN rb_provinsi c ON 

b.provinsi_id=c.provinsi_id where a.id_konsumen='".$this-

>session->id_konsumen."'")-> row_array(); ?> 

<table class='table table-condensed'> 

<tbody> 

<tr class='alert alert-danger'><th scope='row' style= 

'width:90px'>Penerima</th><td><?php echo $usr 

['nama_lengkap']?></td></tr> 

<tr><th scope='row'>Alamat</th><td><?php echo $usr 

['alamat_lengkap'].', '.$usr['nama_kota'].', '.$usr ['nama_ 

provinsi']; ?></td></tr> 

</tbody> 

</table> 

<img style='width:100%' src='<?php echo base_url();?> 

asset/foto_pasangiklan/ekpedisi2.jpg'> 

</div> 

 

b. View_keranjang_detail.php 

301 

<p class='sidebar-title text-danger produk-title'> Detail 

Pesanan Anda</p> 

<div class="col-sm-8"> 

<table class="table table-striped table-condensed"> 

<tbody> 

<?php  

$no = 1; 

foreach ($record as $row){ 

$ex = explode(';', $row['gambar']); 

if (trim($ex[0])==''){ $foto_produk = 'no-image.png'; }else{ 

$foto_produk = $ex[0]; } 

$sub_total = ($row['harga_jual']*$row['jumlah'])-$row 

['diskon']; 

echo "<tr><td>$no</td> 

<td width='70px'><img style='border:1px solid #cecece; 

width:60px' src='".base_url()."asset/ 

foto_produk/$foto_produk'></td> 

<td><a style='color:#ab0534' href='".base_url()." 

produk/detail/$row[produk_seo]'><b>$row[nama_produk]<

/b></a> 

<br>Qty.<b>$row[jumlah]</b>, Harga. Rp ".rupiah 

($row['harga_jual']-$row['diskon'])." / $row [satuan],  

<br>Berat.<b>".($row['berat']*$row['jumlah'])." 

Gram</b></td> 

<td>Rp ".rupiah($sub_total)."</td> 

</tr>"; 

$no++; 

} 

302 

$detail = $this->db->query("SELECT * FROM rb_penjualan 

where id_penjualan='".$this->uri->segment(3)."'")-> row_array 

(); 

$total = $this->db->query("SELECT sum((a.harga_jual 

*a.jumlah)-a.diskon) as total, sum(b.berat*a.jumlah) as 

total_berat FROM `rb_penjualan_detail` a JOIN rb_produk b 

ON a.id_produk=b.id_produk where a.id_penjualan='".$this-

>uri->segment(3)."'")-> row_array(); 

if ($rows['proses']=='0'){ $proses = '<i class="text-danger"> 

Pending</i>'; $status = 'Proses';} 

elseif ($rows['proses']= ='1'){$proses = '<i class="text-success"> 

Proses</i>'; } 

else{ $proses = '<i class="text-info">Konfirmasi</i>'; } 

echo " 

<tr class='success'> 

<td colspan='3'><b>Berat</b> <small><i class='pull-

right'>(".terbilang($total['total_berat'])." Gram)</i> </small> 

</td> 

<td><b>$total[total_berat] Gram</b></td> 

</tr> 

<tr> 

<td colspan='3'><b><span style='text-transform: uppercase'> 

$detail[kurir]</span> - $detail[service] </b><small><i class= 

'pull-right'> (".terbilang ($detail ['ongkir']).") </i></small> 

</td> 

<td><b>Rp ".rupiah($detail['ongkir'])."</b></td> 

</tr> 

<tr> 

303 

<td colspan='3'><b>Total </b> <small><i class='pull-

right'>(".terbilang($total['total'])."Rupiah)</i> </small></td> 

<td><b>Rp ".rupiah($total['total'])."</b></td> 

</tr> 

<tr> 

<td style='color:Red' colspan='3'><b>Subtotal </b> <small><i 

class='pull-right'>(".terbilang($total 

['total']+$detail['ongkir'])."Rupiah)</i></small> </td> 

<td style='color:Red'><b>Rp ".rupiah($total['total'] +$detail 

['ongkir'])."</b></td> 

</tr> 

<tr><td align=center colspan='4'><b> $proses</b>  

</tbody> 

</table>"; 

?> 

</div> 

<div class="col-sm-4 colom44"> 

<?php $res = $this->db->query("SELECT a.*, b.nama_kota, 

c.nama_provinsi FROM rb_reseller a JOIN rb_kota b ON 

a.kota_id=b.kota_id JOIN rb_provinsi c ON b.provinsi_id= 

c.provinsi_id where a.id_reseller='$rows[id_reseller]'")-> 

row_array(); ?> 

<table class='table table-condensed'> 

<tbody> 

<tr class='alert alert-info'><th scope='row' style= 

'width:90px'>Pengirim</th> 

<td><?php echo $res['nama_reseller']?></td></tr> 

304 

<tr class='alert alert-info'><th scope='row'>No Telpon</th> 

<td><?php echo $res['no_telpon']; ?> </td></tr> 

<tr class='alert alert-info'><th scope='row'> Alamat </th>  

<td><?php echo $res['alamat_lengkap'].', '.$res ['nama_kota'].', 

'.$res['nama_provinsi']; ?></td></tr> 

</tbody> 

</table> 

<?php $usr = $this->db->query("SELECT a.*, b.nama_kota, 

c.nama_provinsi FROM rb_konsumen a JOIN rb_kota b ON 

a.kota_id=b.kota_id JOIN rb_provinsi c ON 

b.provinsi_id=c.provinsi_id where a.id_konsumen='".$this-> 

session->id_konsumen."'")-> row_array(); ?> 

<table class='table table-condensed'> 

<tbody> 

<tr class='alert alert-danger'><th scope='row' style='width: 

90px'>Penerima</th> <td><?php echo $usr['nama_lengkap'] 

?></td></tr> 

<tr><th scope='row'>No Telpon</th> <td><?php echo 

$usr['no_hp']; ?></td></tr> 

<tr><th scope='row'>Alamat</th><td><?php echo $usr 

['alamat_lengkap'].', '.$usr['nama_kota'].', '.$usr['nama_ 

provinsi']; ?></td></tr> 

</tbody> 

</table> 

<hr> 

</div> 

<hr> 

 

c. View_order_report.php 

305 

<p class='sidebar-title text-danger produk-title'> Laporan Data 

Pesanan Anda</p> 

<?php  

if ($this->uri->segment(3)=='success'){ 

echo "<div class='alert alert-success'><b>SUCCESS </b> - 

Terima kasih telah Melakukan Konfirmasi Pembayaran! 

</div>"; 

}elseif($this->uri->segment(3)=='orders'){ 

echo "<div class='alert alert-success'><b>SUCCESS </b> - 

Orderan anda sukses terkirim, silahkan melakukan 

pembayaran ke rekening reseller pesanan anda dan 

selanjutnya lakukan konfirmasi pembayaran!</div>"; 

} 

?> 

<table id='example2' style='overflow-x:scroll; width:96%' 

class="table table-striped table-condensed"> 

<thead> 

<tr> 

<th width="20px">No</th> 

<th>Kode Transaksi</th> 

<th>Nama Lapak</th> 

<th>Subtotal</th> 

<th>Ongkir</th> 

<th>Status</th> 

<th>Total + Ongkir</th> 

<th></th> 

</tr> 

</thead> 

306 

<tbody> 

<?php  

if ($row['proses']=='0'){ $proses = '<i class="text-danger"> 

Pending</i>'; } 

elseif($row['proses']=='1'){ $proses = '<i class="text-

success">Proses</i>'; } 

else{ $proses = '<i class="text-info">Konfirmasi</i>'; } 

$total = $this->db->query("SELECT sum((a.harga_jual 

*a.jumlah)-a.diskon) as total FROM `rb_penjualan_ detail` a 

where a.id_penjualan='$row[id_penjualan]'") ->row_array(); 

echo "<tr><td>$no</td> 

<td><span class='text-success'>$row[kode_ transaksi] 

</span></td> 

<td><a href='".base_url()."members/detail_reseller/$row 

[id_reseller]'>$row[nama_reseller]</a></td> 

<td><span style='color:blue;'>Rp ".rupiah($total ['total'])." 

</span></td> 

<td><i style='color:green;'><b style='text-transform: 

uppercase'>$row[kurir]</b> - Rp ".rupiah($row['ongkir'])." 

</i> </td> 

<td>$proses</td> 

<td style='color:red;'>Rp ".rupiah($total ['total'] +$row 

['ongkir'])."</td> 

<td width='130px'>"; 

if ($row['proses']=='0'){ 

echo "<a style='margin-right:3px' class='btn btn-success btn-xs' 

title='Konfirmasi Pembayaran' href='".base_url()."konfirmasi? 

kode=$row[kode_transaksi]'>Konfirmasi</a>"; 

307 

}else{ 

echo "<a style='margin-right:3px' class='btn btn-default btn-xs' 

href='#'  onclick=\"return confirm('Maaf, Pembayaran ini 

sudah di konfirmasi!')\">Konfirmasi</a>"; 

} 

echo "<a class='btn btn-info btn-xs' title='Detail data pesanan' 

href='".base_url()."members/keranjang_ 

detail/$row[id_penjualan]'><span class='glyphicon glyphicon 

-search'> </span></a></td> 

</tr> 

"; 

$no++; 

} 

?> 

</tbody> </table> 

 

 

6.11 Membuat Halaman Konfirmasi Pembayaran 

d. View_konfirmasi_pembayaran.php 

<p class='sidebar-title block-title'> Konfirmasi Pembayaran 

Pesanan Anda</p> 

<?php  

if ($this->uri->segment(3)=='success'){ 

echo "<div class='alert alert-success' style= 'margin:10% 

0px'><center>Success Melakukan Konfirmasi pembayaran... 

<br> 

akan segera kami cek dan proses!</center></div>"; 

}else{ 

308 

$attributes = array('class'=>'form-horizontal', 'role' =>'form'); 

$ongk = $this->db->query("SELECT * FROM rb_penjualan 

where id_penjualan='$rows[id_ penjualan]'")->row_array(); 

echo form_open_multipart('konfirmasi/index', $attributes);  

echo "<div class='alert alert-danger'>Masukkan No Invoice 

atau No Transaksi Terlebih dahulu!</div> 

<table class='table table-condensed'> 

<tbody> 

<input type='hidden' name='id' value='$rows [id_penjualan]'> 

<tr><th scope='row' width='120px'>No Invoice</th>       

<td><input type='text' name='a' class='form-control' 

style='width:100%' value='$rows[kode_transaksi]' 

placeholder='TRX-0000000000' required>"; 

if ($rows['kode_transaksi']!=''){ 

echo "<tr><th scope='row'>Total</th>                 

<td><input type='text' name='b' class='form-control' 

style='width:50%' value='Rp ".rupiah($total['total']+ $ongk 

['ongkir'])."' required> 

<tr><th scope='row'>Transfer Ke</th>                   

<td> <select name='c' class='form-control'>"; 

foreach ($record->result_array() as $row){ 

 echo "<option value='$row[id_rekening]'> $row [nama_bank] 

- $row[no_rekening], A/N : $row [pemilik_rekening] 

</option>"; 

} 

<tr><th width='130px' scope='row'>Nama Pengirim </th> 

<td><input type='text' class='form-control' style='width: 70%' 

name='d' required> </td></tr> 

309 

<tr><th scope='row'>Tanggal Transfer</th>              

<td><input type='text' class='datepicker form-control' 

style='width:40%' name='e' data-date-format='yyyy-mm-dd' 

value='".date('Y-m-d')."'></td> </tr> 

<tr><th scope='row'>Bukti Transfer</th>                

<td> <input type='file' name='f'></td></tr>";} 

echo "</tbody> 

</table> 

<div class='box-footer'>"; 

if ($rows['kode_transaksi']!=''){ 

echo "<button type='submit' name='submit' class= 'btn btn-

info'>Kirimkan</button>"; 

}else{ 

echo "<button type='submit' name='submit1' class='btn btn-

info'>Cek Invoice</button>"; 

} 

echo "</div>"; 

echo form_close(); 

} 

 

e. Buat Kontroler untuk konfirmasi pembayaran dengan 

nama file konfirmasi.php 

<?php 

defined('BASEPATH') OR exit('No direct script access 

allowed'); 

class Konfirmasi extends CI_Controller { 

 

function index(){ 

$id = $this->uri->segment(3); 

310 

if (isset($_POST['submit'])){ 

$config['upload_path'] = 'asset/files/'; 

$config['allowed_types'] = 'gif|jpg|png|jpeg'; 

$config['max_size'] = '10000'; // kb 

$this->load->library('upload', $config); 

$this->upload->do_upload('f'); 

$hasil=$this->upload->data(); 

if ($hasil['file_name']==''){ 

$data = array('id_penjualan'=>$this->input->post('id'), 

'total_transfer'=>$this->input->post('b'), 'id_rekening'=>$this  

->input->post('c'), 'nama_pengirim'=>$this->input->post('d'), 

'tanggal_transfer'=>$this->input->post('e'), 

'waktu_konfirmasi'=>date('Y-m-d H:i:s')); 

$this->model_app->insert('rb_konfirmasi_ 

pembayaran_konsumen',$data); 

}else{ 

$data = array('id_penjualan'=>$this->input->post ('id'),  

'total_transfer'=>$this->input->post('b'), 

'id_rekening'=>$this->input->post('c'), 

'nama_pengirim'=>$this->input->post('d'), 

'tanggal_transfer'=>$this->input->post('e'), 

'bukti_transfer'=>$hasil['file_name'], 

'waktu_konfirmasi'=>date('Y-m-d H:i:s')); 

$this->model_app->insert('rb_konfirmasi_ 

pembayaran_konsumen',$data); 

} 

$data1 = array('proses'=>'2'); 

$where = array('id_penjualan' => $this->input->post ('id')); 

311 

$this->model_app->update('rb_penjualan', $data1, $where); 

redirect('members/keranjang_detail/'.$this->input-> 

post('id')); 

}else{ 

$data['title'] = 'Konfirmasi Orderan anda'; 

$data['description'] = description(); 

$data['keywords'] = keywords(); 

if (isset($_POST['submit1']) OR $_GET['kode']){ 

if ($_GET['kode']!=''){ 

$kode_transaksi = filter($this->input->get('kode')); 

}else{ 

$kode_transaksi = filter($this->input->post('a')); 

} 

$row = $this->db->query("SELECT a.id_penjualan, 

b.id_reseller FROM `rb_penjualan` a jOIN rb_reseller b ON 

a.id_penjual=b.id_reseller where status_penjual= 'reseller' 

AND a.kode_transaksi='$kode_transaksi'")-> row_array(); 

$data['record'] = $this->model_app->view ('rb_rekening'); 

$data['total'] = $this->db->query("SELECT sum( 

(a.harga_jual*a.jumlah)-a.diskon) as total, a.id_penjualan 

FROM `rb_penjualan_detail` a where a.id_penjualan='" 

.$row['id_penjualan']."'")-> row_array(); 

$data['rows'] = $this->model_app->view_where 

('rb_penjualan',array('id_penjualan'=>$row['id_penjualan']))-> 

row_array(); 

$this->template->load(template().'/template', 

template().'/reseller/view_konfirmasi_pembayaran',$data); 

}else{ 

312 

$this->template->load(template().'/template', 

template().'/reseller/view_konfirmasi_pembayaran',$data); 

} 

} 

} 

 

function tracking(){ 

if (isset($_POST['submit1']) OR $this->uri->segment (3)!=''){ 

if ($this->uri->segment(3)!=''){ 

$kode_transaksi = filter($this->uri->segment(3)); 

}else{ 

$kode_transaksi = filter($this->input->post('a')); } 

$cek=$this->model_app->view_where('rb_penjualan',array 

('kode_transaksi'=>$kode_transaksi)); 

if ($cek->num_rows()>=1){ 

$data['title'] = 'Tracking Order '.$kode_transaksi; 

$data['description'] = description(); 

$data['keywords'] = keywords(); 

$data['rows'] = $this->db->query("SELECT * FROM 

rb_penjualan a JOIN rb_konsumen b ON a.id_pembeli= 

b.id_konsumen JOIN rb_kota c ON b.kota_id=c.kota_id where 

a.kode_transaksi= '$kode_transaksi'")->row_array(); 

$data['record'] = $this->db->query("SELECT a.kode_transaksi, 

b.*, c.nama_produk, c.satuan, c.berat, c.produk_seo FROM 

`rb_penjualan` a JOIN rb_penjualan_detail b ON 

a.id_penjualan= b.id_penjualan JOIN rb_produk c ON 

b.id_produk= c.id_produk where a.kode_transaksi='".$kode_ 

transaksi."'"); 

313 

$data['total'] = $this->db->query("SELECT a.kode_ transaksi, 

a.kurir, a.service, a.proses, a.ongkir, sum(b.harga_jual 

*b.jumlah) as total, sum(b.diskon* b.jumlah) as diskon_total, 

sum(c.berat*b.jumlah) as total_berat FROM `rb_penjualan` a 

JOIN rb_penjualan_detail b ON a.id_penjualan=b.id_ 

penjualan JOIN rb_produk c ON b.id_produk= c.id_produk 

where a.kode_transaksi='".$kode_ transaksi."'")->row_array(); 

$this->template->load(template().'/template', 

template().'/reseller/view_tracking_view',$data); 

}else{ 

redirect('konfirmasi/tracking'); 

}else{ 

$data['title'] = 'Tracking Order'; 

$data['description'] = description(); 

$data['keywords'] = keywords(); 

$this->template->load(template().'/template', 

template().'/reseller/view_tracking',$data); 

} 

} 

} 

 

6.12 Membuat Halaman Rekening 

f. View_rekening.php 

<div class="col-xs-12">   

<div class="box"> 

<div class="box-header"> 

<h3 class="box-title">Rekening Bank Toko </h3> 

314 

<a class='pull-right btn btn-primary btn-sm' href='<?php echo 

base_url().$this->uri->segment(1); 

?>/tambah_rekening'>Tambahkan Data</a> 

</div><!-- /.box-header --> 

<div class="box-body"> 

<table id="example1" class="table table-bordered table-

striped"> 

<thead> 

<tr> 

<th style='width:20px'>No</th> 

<th>Nama Bank</th> 

<th>No Rekening</th> 

<th>Atas Nama</th> 

<th style='width:70px'>Action</th> 

</tr> 

</thead> 

<tbody> 

<?php  

$no = 1; 

foreach ($record->result_array() as $row){ 

echo "<tr><td>$no</td> 

<td>$row[nama_bank]</td> 

<td>$row[no_rekening]</td> 

<td>$row[pemilik_rekening]</td> 

<a class='btn btn-success btn-xs' title='Edit Data' 

href='".base_url().$this->uri->segment(1)."/ 

edit_rekening/$row[id_rekening_reseller]'><span 

class='glyphicon glyphicon-edit'> </span></a> 

315 

<a class='btn btn-danger btn-xs' title='Delete Data' 

href='".base_url().$this->uri->segment(1)."/delete_rekening/ 

$row[id_rekening_reseller]' onclick=\" return confirm('Apa 

anda yakin untuk hapus Data ini?')\"><span class='glyphicon 

glyphicon-remove'> </span></a> 

</center></td> 

</tr>"; 

$no++; 

} 

?> 

</tbody> 

</table> 

</div> 

 

g. View_rekening_edit.php 

<?php  

echo "<div class='col-md-12'> 

<div class='box box-info'> 

<div class='box-header with-border'> 

<h3 class='box-title'>Edit Rekening Bank Toko </h3> 

</div> 

<div class='box-body'>"; 

$attributes = array('class'=>'form-horizontal','role'=> 'form'); 

echo form_open_multipart($this->uri->segment(1).' 

/edit_rekening',$attributes);  

echo "<div class='col-md-12'> 

<table class='table table-condensed table-bordered'> 

<tbody> 

316 

<input type='hidden' name='id' value='$rows 

[id_rekening_reseller]'> 

<tr><th width='120px' scope='row'>Nama Bank </th>     

<td><input type='text' class='form-control' name='a' 

value='$rows[nama_bank]' required></td></tr> 

<tr><th scope='row'>No Rekening</th>                  

<td><input type='number' class='form-control' name='b' 

value='$rows[no_rekening]'></td></tr> 

<tr><th scope='row'>Atas Nama</th>                    

<td><input type='text' class='form-control' name='c' 

value='$rows[pemilik_rekening]'></td></tr> 

</tbody> 

</table> 

</div> 

</div> 

<div class='box-footer'> 

<button type='submit' name='submit' class='btn btn-

info'>Update</button> 

<a href='".base_url().$this->uri->segment(1)."/ rekening'> 

<button type='button' class='btn btn-default pull-right'> 

Cancel</button></a> 

</div> 

</div>"; 

 

h. View_rekening_tambah.php 

<?php  

echo "<div class='col-md-12'> 

<div class='box box-info'> 

<div class='box-header with-border'> 

317 

<h3 class='box-title'>Tambah Rekening Bank Toko</h3> 

</div> 

<div class='box-body'>"; 

$attributes = array('class'=>'form-horizontal','role' =>'form'); 

echo form_open_multipart($this->uri->segment(1).'/tambah_ 

rekening',$attributes);  

<table class='table table-condensed table-bordered'> 

<tbody> 

<input type='hidden' name='id' value=''> 

<tr><th width='120px' scope='row'>Nama Bank </th>     

<td><input type='text' class='form-control' name='a' 

required></td></tr> 

<tr><th scope='row'>No Rekening</th>                  

<td><input type='number' class='form-control' 

name='b'></td></tr> 

<tr><th scope='row'>Atas Nama</th>                    

<td><input type='text' class='form-control' name= 

'c'></td></tr> 

</tbody> 

</table> 

</div> 

</div> 

<div class='box-footer'> 

<button type='submit' name='submit' class='btn btn-

info'>Tambahkan</button> 

<a href='".base_url().$this->uri->segment(1)."/rekening'> 

<button type='button' class='btn btn-default pull-right'> 

Cancel</button></a> 

318 

</div> 

</div>"; 

 

 

6.13 Membuat Halaman Berita 

a. View_beroita.php 

<div class="col-xs-12">   

<div class="box"> 

<div class="box-header"> 

<h3 class="box-title">Semua Berita</h3> 

<a class='pull-right btn btn-primary btn-sm' href=' <?php echo 

base_url().$this->uri->segment(1);?> 

/tambah_listberita'>Tambahkan Data</a> 

</div><!-- /.box-header --> 

<div class="box-body"> 

<table id="example1" class="table table-bordered table-

striped"> 

<thead> 

<tr> 

<th style='width:20px'>No</th> 

<th>Judul Berita</th> 

<th>Tanggal</th> 

<th>Status</th> 

<th style='width:75px'>Action</th> 

</tr> 

</thead> 

<tbody> 

 

319 

<?php  

$no = 1; 

foreach ($record as $row){ 

$tgl_posting = tgl_indo($row['tanggal']); 

if ($row['status']=='Y'){ $status = '<span style= "color:green"> 

Published</span>';  

}else{ $status = '<span style="color:red"> Unpublished 

</span>'; } 

echo "<tr><td>$no</td> 

<td>$row[judul]</td> 

<td>$tgl_posting</td> 

<td>$status</td> 

<td><center> 

<a class='btn btn-primary btn-xs' title='Edit Data' 

href='".base_url().$this->uri->segment(1)."/publish_listberita 

/$row[id_berita]/$row[status]'><span class='glyphicon 

glyphicon-ok'> </span></a> 

<a class='btn btn-success btn-xs' title='Edit Data' 

href='".base_url().$this->uri->segment(1)."/edit_listberita 

/$row[id_berita]'><span class=' glyphicon glyphicon-edit'> 

</span></a> 

<a class='btn btn-danger btn-xs' title='Delete Data' 

href='".base_url().$this->uri->segment(1)."/ 

delete_listberita/$row[id_berita]'onclick=\"return confirm 

('Apa anda yakin untuk hapus Data ini?')\"><span 

class='glyphicon glyphicon-remove'> </span></a> 

</center></td> 

</tr>"; 

320 

$no++; 

} 

?> 

</tbody> 

</table> 

</div> 

 

b. View_berita_edit.php 

<?php  

echo "<div class='col-md-12'> 

<div class='box box-info'> 

<div class='box-header with-border'> 

<h3 class='box-title'>Edit Berita Terpilih</h3> 

</div> 

<div class='box-body'>"; 

 $attributes=array('class'=>'form-horizontal', 'role'=> 'form'); 

echo form_open_multipart($this->uri->segment(1).' 

/edit_listberita',$attributes);  

echo "<div class='col-md-12'> 

<table class='table table-condensed table-bordered'> 

<tbody> 

<input type='hidden' name='id' value='$rows [id_berita]'> 

<tr><th width='120px' scope='row'>Judul</th>    <td><input 

type='text' class='form-control' name='b' value='$rows[judul]' 

required></td></tr> 

<tr><th scope='row'>Sub Judul</th>               

<td><input type='text' class='form-control' name='c' value= 

'$rows[sub_judul]'></td></tr> 

<tr><th scope='row'>Video Youtube</th>           

321 

<td><input type='text' class='form-control' name='d' 

value='$rows[youtube]' placeholder='Contoh link: 

http://www.youtube.com/embed/xbuEmoRWQHU'></td>

</tr> 

<tr><th scope='row'>Kategori</th>                

<td><select name='a' class='form-control' required> "; 

foreach ($record as $row){ 

if ($rows['id_kategori'] == $row['id_kategori']){ 

echo "<option value='$row[id_kategori]' selected>$row 

[nama_kategori]</option>"; 

}else{ 

echo "<option value='$row[id_kategori]'>$row[nama_ 

kategori]</option>"; 

} 

} 

echo "</td></tr> 

<tr><th scope='row'>Headline</th>                

<td>"; if($rows['headline']=='Y'){ echo "<input type='radio' 

name='e' value='Y' checked> Ya &nbsp; <input type='radio' 

name='e' value='N'> Tidak"; }else{ echo "<input type='radio' 

name='e' value='Y'> Ya &nbsp; <input type='radio' name='e' 

value='N' checked> Tidak"; } echo "</td></tr> 

<tr><th scope='row'>Pilihan </th>         

<td>";if ($rows['aktif']=='Y'){ echo "<input type= 'radio' 

name='f' value='Y' checked> Ya &nbsp; <input type='radio' 

name='f' value='N'> Tidak"; }else{ echo " <input type='radio' 

name='f' value='Y'> Ya &nbsp; <input type='radio' name='f' 

value='N' checked> Tidak"; } echo "</td></tr> 

322 

<tr><th scope='row'>Berita Utama</th>            

<td>"; if ($rows['utama']=='Y'){ echo "<input type='radio' 

name='g' value='Y' checked> Ya &nbsp; <input type='radio' 

name='g' value='N'> Tidak"; }else{ echo "<input type='radio' 

name='g' value='Y'> Ya &nbsp; <input type='radio' name='g' 

value='N' checked> Tidak"; } echo "</td></tr> 

<tr><th scope='row'>Isi Berita</th>              

<td><textarea id='editor1' class='form-control' name='h' 

style='height:260px' required>$rows[isi_berita] </textarea> 

</td></tr> 

<tr><th scope='row'>Ganti Gambar</th>                  

<td><input type='file' class='form-control' name= 'k'>"; 

if ($rows['gambar'] != ''){ echo "<i style='color: red'>Lihat 

Gambar Saat ini : </i><a target='_BLANK' href='".base_url(). 

"asset/foto_berita/$rows[gambar]'> $rows[gambar]</a>"; } 

echo "</td></tr> 

<tr><th scope='row'>Ket. Gambar</th>             

<td><input type='text' class='form-control' name='i' value= 

'$rows[keterangan_gambar]'></td></tr> 

<tr><th scope='row'>Tag</th>                     

<td><div class= 'checkbox-scroll'>"; 

$_arrNilai = explode(',', $rows['tag']); 

foreach ($tag as $tag){ 

$_ck = (array_search($tag['tag_seo'], $_arrNilai) === false)? '' : 

'checked'; 

echo "<span style='display:block;'><input type= checkbox 

value='$tag[tag_seo]' name=j[] $_ck> $tag[nama_tag] &nbsp; 

&nbsp; &nbsp; </span>"; 

323 

} 

echo "</div></td></tr> 

</tbody> 

</table> 

</div> 

<div class='box-footer'> 

<button type='submit' name='submit' class='btn btn-info'> 

Update</button> 

<a href='".base_url().$this->uri->segment(1)."/ listberita'> 

<button type='button' class='btn btn-default pull-right'> 

Cancel</button></a> 

</div></div> 

</div></div>"; 

echo form_close(); 

 

c. View_berita_tambah.php 

<?php  

echo "<div class='col-md-12'> 

<div class='box box-info'> 

<div class='box-header with-border'> 

<h3 class='box-title'>Tambah Berita Baru </h3> 

</div> 

<div class='box-body'>"; 

$attributes = array('class'=>'form-horizontal','role'=> 'form'); 

echo form_open_multipart($this->uri->segment(1).'/tambah_ 

listberita',$attributes);  

echo "<div class='col-md-12'> 

<table class='table table-condensed table-bordered'> 

<tbody> 

324 

<input type='hidden' name='id' value=''> 

<tr><th width='120px' scope='row'>Judul</th>    <td><input 

type='text' class='form-control' name='b' required> 

</td></tr> 

<tr><th scope='row'>Sub Judul</th>               

<td><input type='text' class='form-control' name= 

'c'></td></tr> 

<tr><th scope='row'>Video Youtube</th>           

<td><input type='text' class='form-control' name='d' 

placeholder='Contoh link: http://www.youtube.com/ 

embed/xbuEmoRWQHU'></td></tr> 

<tr><th scope='row'>Kategori</th>                

<td><select name='a' class='form-control' required> 

 <option value='' selected>- Pilih Kategori -</option>"; 

foreach ($record as $row){ 

echo "<option value='$row[id_kategori]'>$row 

[nama_kategori]</option>"; 

} 

echo "</td></tr> 

<tr><th scope='row'>Headline</th>                

<td><input type='radio' name='e' value='Y'> Ya &nbsp; 

<input type='radio' name='e' value='N' checked> 

Tidak</td></tr> 

<tr><th scope='row'>Pilihan </th>         

<td><input type='radio' name='f' value='Y'> Ya &nbsp; 

<input type='radio' name='f' value='N' checked> Tidak 

</td></tr> 

<tr><th scope='row'>Berita Utama</th>            

325 

<td><input type='radio' name='g' value='Y'> Ya &nbsp; 

<input type='radio' name='g' value='N' checked> 

Tidak</td></tr> 

<tr><th scope='row'>Isi Berita</th>              

<td><textarea id='editor1' class='form-control' name='h' 

style='height:260px' required></textarea> 

</td></tr> 

<tr><th scope='row'>Gambar</th>                  

<td><input type='file' class='form-control' name='k'> 

</td></tr> 

<tr><th scope='row'>Ket. Gambar</th>             

<td><input type='text' class='form-control' name='i'> 

</td></tr> 

<tr><th scope='row'>Tag</th>                     

<td><div class='checkbox-scroll'>"; 

foreach ($tag as $tag){ 

echo "<span style='display:block;'><input type= checkbox 

value='$tag[tag_seo]' name=j[]> $tag [nama_tag] &nbsp; 

&nbsp; &nbsp; </span>";} 

echo "</div></td></tr> 

</tbody> 

</table> 

</div> 

<div class='box-footer'> 

<button type='submit' name='submit' class='btn btn-

info'>Tambahkan</button> 

326 

<a href='".base_url().$this->uri->segment(1)."/ listberita'> 

<button type='button' class='btn btn-default pull-

right'>Cancel</button></a> 

</div> 

</div></div></div>"; 

echo form_close(); 

 

d. Buat Contoller berita.php 

<?php 

defined('BASEPATH') OR exit('No direct script access 

allowed'); 

class Berita extends CI_Controller { 

 

public function index(){ 

$jumlah= $this->model_utama->view('tb_berita')-> num_rows 

(); 

$config['base_url'] = base_url().'tb_berita/index/'; 

$config['total_rows'] = $jumlah; 

$config['per_page'] = 15;   

if ($this->uri->segment('3')==''){ 

$dari = 0; 

}else{ 

$dari = $this->uri->segment('3'); 

} 

 

if ($this->input->post('kata')){ 

$data['title'] = "Hasil Pencarian keyword - ".cetak($this-> 

input->post('kata')); 

$data['description'] = description(); 

327 

$data['keywords'] = keywords(); 

$data['berita'] = $this->model_utama->cari_berita ($this-> 

input->post('kata')); 

}else{ 

$data['title'] = "Semua Berita"; 

$data['description'] = description(); 

$data['keywords'] = keywords(); 

$data['berita'] = $this->model_utama->view_joinn 

('berita','users','kategori','username','id_kategori','id_berita','DE

SC',$dari,$config['per_page']); 

$this->pagination->initialize($config); 

} 

$this->template->load(template().'/template', 

template().'/tb_berita',$data); 

} 

 

public function detail(){ 

$query = $this->model_utama->view_join_two 

('tb_berita','users','kategori','username','id_kategori', 

array('judul_seo' => $this->uri->segment(3)), 'id_berita', 

'DESC',0,1); 

if ($query->num_rows()<=0){ 

redirect('main'); 

}else{ 

$row = $query->row_array(); 

$data['title'] = cetak($row['judul']); 

$data['description'] = cetak_meta($row['isi_berita'],0,500); 

$data['keywords'] = cetak($row['tag']); 

328 

$data['rows'] = $row; 

$dataa = array('dibaca'=>$row['dibaca']+1); 

$where = array('id_berita' => $row['id_berita']); 

$this->model_utama->update('tb_berita',$dataa, $where); 

$this->load->helper('captcha'); 

$vals = array( 

'img_path'  => './captcha/', 

'img_url'  => base_url().'captcha/', 

'font_path' => './asset/Tahoma.ttf', 

'font_size'     => 17, 

'img_width'  => '150', 

'img_height' => 45, 

'border' => 0,  

'word_length'   => 5, 

'expiration' => 7200 

); 

$cap = create_captcha($vals); 

$data['image'] = $cap['image']; 

$this->session->set_userdata('mycaptcha', $cap['word']); 

$data['us'] = $this->model_app->view_where ('users', 

array('username'=>$this->session->username))-> row_array(); 

$this->template->load(template().'/template', 

template().'/detailberita',$data); 

} 

} 

 

function kirim_komentar(){ 

if (isset($_POST['submit'])){ 

329 

$cek = $this->model_utama->view_where('tb_berita', 

array('id_berita' => $this->input->post('a'))); 

$row = $cek->row_array(); 

if ($cek->num_rows()<=0){ 

redirect('main'); 

}else{ 

if ($this->input->post() && (strtolower($this->input->post 

('secutity_code')) == strtolower($this->session->userdata 

('mycaptcha')))) { 

$data = array('id_berita'=>cetak($this->input-> post ('a')), 

'nama_komentar'=>cetak($this->input->post ('b')), 'url'=> 

cetak($this->input->post('c')), 

'isi_komentar'=>cetak($this->input->post('d')), 

'tgl'=>date('Y-m-d'), 'jam_komentar'=>date('H:i:s'), 

'aktif'=>'N', 'email'=>cetak($this->input->post('e'))); 

$this->model_utama->insert('komentar',$data); 

echo $this->session->set_flashdata('message', '<div class= 

"alert alert-success"><center>Komentar anda akan tampil 

setelah kami setujui!</center></div>'); 

}else{ 

echo $this->session->set_flashdata('message', '<div class= 

"alert alert-danger"><center>Security Code yang anda 

masukkan salah!</center></div>'); 

} 

} 

redirect('tb_berita/detail/'.$row['judul_seo'].'#listcomment'); 

} 

} 

330 

 

function indeks_berita(){ 

$data['title'] = 'Indeks Berita'; 

$data['description'] = description(); 

$data['keywords'] = keywords(); 

data['record'] = $this->model_utama->view ('kategori'); 

if (isset($_POST['filter'])){ 

$bulan = strlen($_POST['bulan']); 

$tanggal = strlen($_POST['tanggal']);  

if ($bulan <= 1){ $bulann = '0'.$this->input-> post('bulan'); 

}else{ $bulann = $this->input->post ('bulan'); } 

if ($tanggal <= 1){ $tanggall = '0'.$this->input-> post('tanggal'); 

}else{ $tanggall = $this->input->post ('tanggal'); } 

$fil = $_POST['tahun'].'-'.$bulann.'-'.$tanggall; 

$data['hari_ini'] = $fil; 

$data['hitung'] = $this->model_utama->view_where 

('tb_berita' ,array('tanggal'=>$fil)); 

}else{ 

$data['hari_ini'] = date('Y-m-d'); 

$data['hitung'] = $this->model_utama->view_where 

('tb_berita', array('tanggal'=>date('Y-m-d'))); 

} 

$this->template->load(template().'/template', 

template().'/indeks_berita',$data); 

} 

} 

  

331