Web Programming 6

 

']['tmp_name'] = $files['userfile'] 

['tmp_name'][$i]; 

$_FILES['userfile']['error'] = $files['userfile']['error'] [$i]; 

$_FILES['userfile']['size']= $files['userfile']['size'][$i]; 

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

$this->upload->initialize($this->set_upload_ options()); 

$this->upload->do_upload(); 

$fileName = $this->upload->data()['file_name']; 

$images[] = $fileName; 

} 

$fileName = implode(';',$images); 

$fileName = str_replace(' ','_',$fileName); 

if (trim($fileName)!=''){ 

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

'id_kategori_produk_sub'=>$this->input-> post('aa'), 

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

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

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

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

post('f'),'berat'=>$this-> input->post('berat'),'gambar' => 

198 

$fileName,'keterangan'=> $this->input->post('ff'), 'username' 

=>$this->session-> username, 'waktu_input'=>date('Y-m-d 

H:i:s')); 

}else{ 

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

'id_kategori_produk_sub'=>$this->input->post('aa'), 

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

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

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

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

>post('f'),'berat'=>$this-> input-> post('berat'), 'keterangan'=> 

$this->input->post('ff'),'username'=>$this->session-> 

username, 'waktu_input' =>date('Y-m-d H:i:s')); 

} 

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

redirect('administrator/produk'); 

}else{ 

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

('rb_kategori_produk','id_kategori_produk','DESC'); 

$this->template->load('administrator/template', 

'administrator/additional/mod_produk/view_produk_tamba

h',$data); 

} 

} 

 

function edit_produk(){ 

cek_session_akses('produk',$this->session-> id_session); 

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

199 

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

$files = $_FILES; 

$cpt = count($_FILES['userfile']['name']); 

for($i=0; $i<$cpt; $i++){ 

$_FILES['userfile']['name']= $files['userfile']['name'] [$i]; 

$_FILES['userfile']['type']= $files['userfile']['type'] [$i]; 

$_FILES['userfile']['tmp_name']=$files['userfile']['tmp_name'] 

[$i]; 

$_FILES['userfile']['error']= $files['userfile']['error'] [$i]; 

$_FILES['userfile']['size']= $files['userfile']['size'][$i]; 

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

$this->upload->initialize($this->set_upload_ options()); 

$this->upload->do_upload(); 

$fileName = $this->upload->data()['file_name']; 

$images[] = $fileName; 

} 

$fileName = implode(';',$images); 

$fileName = str_replace(' ','_',$fileName); 

if (trim($fileName)!=''){ 

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

'id_kategori_produk_sub'=>$this->input->post('aa'), 

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

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

post('c'),'harga_beli'=>$this->input->post('d'),'harga_ reseller' 

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

post('f'),'berat'=>$this->input->post('berat'), 'gambar'=> 

$fileName,'keterangan'=>$this->input->post ('ff'), 'username' 

=>$this->session->username); 

200 

}else{ 

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

'id_kategori_produk_sub'=>$this->input-> post('aa'), 

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

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

post('c'),'harga_beli'=>$this->input->post('d'),'harga_ reseller' 

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

>post('f'),'berat'=>$this->input->post('berat'), 'keterangan'=> 

$this->input->post('ff'),'username'=>$this-> session -> 

username); 

} 

 

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

$this->model_app->update('rb_produk', $data, $where); 

redirect('administrator/produk'); 

}else{ 

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

('rb_kategori_produk','id_kategori_produk','DESC'); 

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

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

$this->template->load('administrator/template', 

'administrator/additional/mod_produk/view_produk_edit',$

data); 

} 

} 

 

private function set_upload_options(){ 

$config = array(); 

201 

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

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

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

$config['encrypt_name'] = FALSE; 

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

return $config; } 

 

function delete_produk(){ 

cek_session_akses('produk',$this->session-> id_session); 

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

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

redirect('administrator/produk'); 

} 

 

// Controller Modul Rekening 

function rekening(){ 

cek_session_akses('rekening',$this->session-> id_session); 

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

('rb_rekening','id_rekening','DESC'); 

$this->template->load('administrator/template', 

'administrator/additional/mod_rekening/view_rekening',$da

ta); 

} 

 

function tambah_rekening(){ 

cek_session_akses('rekening',$this->session-> id_session); 

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

$this->model_rekening->rekening_tambah(); 

202 

$data = array('nama_bank'=>$this->db->escape_str ($this-> 

input->post('a')),'no_rekening'=>$this->db->escape_str($this-> 

input->post('b')), 'pemilik_rekening'=>$this->db-> escape_str 

($this-> input->post('c'))); 

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

redirect('administrator/rekening'); 

}else{ 

$this->template->load('administrator/template', 

'administrator/additional/mod_rekening/view_rekening_ta

mbah'); 

} 

} 

 

function edit_rekening(){ 

cek_session_akses('rekening',$this->session-> id_session); 

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

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

$data = array('nama_bank'=>$this->db->escape_str ($this-> 

input->post('a')), 'no_rekening'=>$this->db-> escape_str 

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

escape_str($this-> input->post('c'))); 

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

$this->model_app->update('rb_rekening', $data, $where); 

redirect('administrator/rekening'); 

}else{ 

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

array('id_rekening'=>$id))->row_array (); 

203 

$this->template->load('administrator/template', 

'administrator/additional/mod_rekening/view_rekening_edi

t',$data); } } 

function delete_rekening(){ 

cek_session_akses('rekening',$this->session-> id_session); 

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

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

redirect('administrator/rekening'); 

} 

 

// Controller Modul Pembelian 

function pembelian(){ 

cek_session_akses('pembelian',$this->session-> id_session); 

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

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

('rb_pembelian','rb_supplier','id_supplier','id_pembelian','DES

C'); 

$this->template->load('administrator/template', 

'administrator/additional/mod_pembelian/view_pembelian',

$data); } 

 

function detail_pembelian(){ 

cek_session_akses('pembelian',$this->session-> id_session); 

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

('rb_pembelian','rb_supplier','id_supplier',array('id_pembelian'

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

row_array(); 

204 

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

('rb_pembelian_detail','rb_produk','id_produk',array('id_pemb

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

'id_pembelian_detail','DESC'); 

$this->template->load('administrator/template', 

'administrator/additional/mod_pembelian/view_pembelian_

detail',$data); 

} 

 

function tambah_pembelian(){ 

cek_session_akses('pembelian',$this->session-> id_session); 

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

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

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

'id_supplier'=>$this->input->post('b'), 'waktu_beli'=> date('Y-

m-d H:i:s')); 

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

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

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

}else{ 

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

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

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

$this->model_app->update('rb_pembelian', $data, $where); 

} 

redirect('administrator/tambah_pembelian'); 

}elseif(isset($_POST['submit'])){ 

if ($this->input->post('idpd')==''){ 

205 

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

'id_produk'=>$this->input->post('aa'),'harga_pesan'=> $this-> 

input->post('bb'),'jumlah_pesan'=>$this->input-> post('cc'), 

'satuan'=>$this->input->post('dd')) ; 

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

}else{ 

$data = array('id_produk'=>$this->input->post('aa'), 

'harga_pesan'=>$this->input->post('bb'), 

'jumlah_pesan'=>$this->input->post('cc'), 'satuan'=>$this-> 

input->post('dd')); 

$where = array('id_pembelian_detail' => $this->input -> 

post('idpd')); 

$this->model_app->update('rb_pembelian_detail', $data, 

$where); 

} 

redirect('administrator/tambah_pembelian'); 

}else{ 

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

('rb_pembelian','rb_supplier','id_supplier',array('id_pembelian'

=>$this->session->idp),'id_pembelian','DESC')-> row_array(); 

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

('rb_pembelian_detail','rb_produk','id_produk',array('id_pemb

elian'=>$this->session->idp), 'id_pembelian_detail','DESC'); 

$data['barang'] = $this->model_app->view_where_ordering 

('rb_produk',array('id_reseller'=>'0'),'id_produk','ASC'); 

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

('rb_supplier','id_supplier','ASC'); 

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

206 

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

('rb_pembelian_detail',array('id_pembelian_detail'=>$this-> 

uri->segment(3)))->row_array(); 

} 

$this->template->load('administrator/template', 

'administrator/additional/mod_pembelian/view_pembelian_

tambah',$data); 

} 

} 

 

function edit_pembelian(){ 

cek_session_akses('pembelian',$this->session-> id_session); 

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

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

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

input->post('c'));  

$where = array('id_pembelian' => $this->input->post ('idp')); 

$this->model_app->update('rb_pembelian', $data, $where); 

redirect('administrator/edit_pembelian/'.$this->input-> post 

('idp')); 

}elseif(isset($_POST['submit'])){ 

if ($this->input->post('idpd')==''){ 

$data = array('id_pembelian'=>$this->input->post('idp'), 

'id_produk'=>$this->input->post('aa'), 'harga_pesan'=>$this-> 

input->post('bb'), 'jumlah_pesan'=>$this->input->post('cc'), 

'satuan'=> $this->input->post('dd')); 

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

}else{ 

207 

$data = array('id_produk'=>$this->input->post('aa'), 

'harga_pesan'=>$this->input->post('bb'),'jumlah_pesan'=> 

$this->input->post('cc'),'satuan'=>$this->input->post('dd')) ; 

$where=array('id_pembelian_detail'=>$this->input->post 

('idpd')); 

$this->model_app->update('rb_pembelian_detail',$data, 

$where); } 

redirect('administrator/edit_pembelian/'.$this->input-> 

post('idp')); 

}else{ 

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

('rb_pembelian','rb_supplier','id_supplier',array('id_pembelian'

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

row_array(); 

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

('rb_pembelian_detail','rb_produk','id_produk',array('id_pemb

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

id_pembelian_detail','DESC'); 

$data['barang'] = $this->model_app->view_where_ ordering 

('rb_produk',array('id_reseller'=>'0'),'id_produk','ASC'); 

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

('rb_supplier','id_supplier','ASC'); 

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

$data['row'] = $this->model_app->view_where ('rb_pembelian 

_detail',array('id_pembelian_detail'=>$this-> uri->segment 

(4)))->row_array(); 

} 

208 

$this->template->load('administrator/template', 

'administrator/additional/mod_pembelian/view_pembelian_

edit',$data); 

}  

} 

 

function delete_pembelian(){ 

cek_session_akses('pembelian',$this->session-> id_session); 

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

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

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

redirect('administrator/pembelian'); 

} 

 

function delete_pembelian_detail(){ 

cek_session_akses('pembelian',$this->session-> id_session); 

$id = array('id_pembelian_detail' => $this->uri-> segment (4)); 

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

redirect('administrator/edit_pembelian/'.$this->uri-> 

segment(3)); 

} 

 

function delete_pembelian_tambah_detail(){ 

cek_session_akses('pembelian',$this->session-> id_session); 

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

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

redirect('administrator/tambah_pembelian'); 

} 

// Controller Modul Penjualan 

209 

function penjualan(){ 

cek_session_akses('penjualan',$this->session-> id_session); 

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

$data['record'] = $this->model_reseller-> penjualan_list 

(1,'admin'); 

$this->template->load('administrator/template', 

'administrator/additional/mod_penjualan/view_penjualan',$

data); 

} 

 

function detail_penjualan(){ 

cek_session_akses('penjualan',$this->session-> id_session); 

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

->uri->segment(3))->row_array(); 

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

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

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

'id_penjualan_detail','DESC'); 

$this->template->load('administrator/template', 

'administrator/additional/mod_penjualan/view_penjualan_d

etail',$data); 

} 

 

function tambah_penjualan(){ 

cek_session_akses('penjualan',$this->session-> id_session); 

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

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

210 

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

'id_pembeli'=>$this->input->post('b'),'id_penjual'=>0, 

'status_pembeli'=>'reseller','status_penjual'=>'admin', 

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

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

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

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

}else{ 

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

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

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

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

redirect('administrator/tambah_penjualan'); 

}elseif(isset($_POST['submit'])){ 

$jual = $this->model_reseller->jual($this->input-> post('aa'))-> 

row_array(); 

$beli = $this->model_reseller->beli($this->input-> post('aa'))-> 

row_array(); 

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

if ($this->input->post('dd') > $stok){ 

echo "<script>window.alert('Maaf, Stok Tidak Mencukupi!'); 

window.location=('".base_url()."administrator/tambah_penjua

lan')</script>"; 

}else{ 

if ($this->input->post('idpd')==''){ 

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

'id_produk'=>$this->input->post('aa'), 'jumlah'=> $this-> 

input->post('dd'),'diskon'=>$this->input->post('cc'), 

211 

'harga_jual'=>$this->input->post('bb'),'satuan'=>$this-> input 

->post('ee')); 

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

}else{ 

$data = array('id_produk'=>$this->input->post('aa'), 

'jumlah'=>$this->input->post('dd'), 'diskon'=>$this-> input-> 

post('cc'), 'harga_jual'=>$this->input->post ('bb'), 'satuan'=> 

$this->input->post('ee')); 

$where = array('id_penjualan_detail' => $this->input-> 

post('idpd')); 

$this->model_app->update('rb_penjualan_detail',$data, 

$where); 

} 

redirect('administrator/tambah_penjualan'); 

}       

}else{ 

$data['rows'] = $this->model_reseller->penjualan_detail ($this-

>session->idp)->row_array(); 

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

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

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

'id_penjualan_detail','DESC'); 

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

('rb_produk','id_produk','ASC'); 

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

('rb_reseller','id_reseller','ASC'); 

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

212 

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

('rb_penjualan_detail', array('id_penjualan_detail'=> $this-> 

uri->segment(3)))->row_array(); 

} 

$this->template->load('administrator/template', 

'administrator/additional/mod_penjualan/view_penjualan_t

ambah',$data); 

} 

} 

 

function edit_penjualan(){ 

cek_session_akses('penjualan',$this->session-> id_session); 

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

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

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

$this->input->post('c')); 

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

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

redirect('administrator/edit_penjualan/'.$this->input->post 

('idp')); 

}elseif(isset($_POST['submit'])){ 

$cekk = $this->db->query("SELECT * FROM rb_penjualan_ 

detail where id_penjualan='".$this-> input-> post('idp')."' AND 

id_produk='".$this->input->post('aa'). "'")->row_array(); 

$jual=$this->model_reseller->jual($this->input->post ('aa')) -> 

row_array(); 

$beli = $this->model_reseller->beli($this->input->post ('aa'))-> 

row_array(); 

213 

$stok = $beli['beli']-$jual['jual']+$cekk['jumlah']; 

if ($this->input->post('dd') > $stok){ 

echo "<script>window.alert('Maaf, Stok Tidak Mencukupi!'); 

                                  

window.location=('".base_url()."administrator/edit_penjualan

/".$this->input->post('idp')."')</script>"; 

}else{ 

if ($this->input->post('idpd')==''){ 

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

'id_produk'=>$this->input->post('aa'), 'jumlah'=>$this-> 

input->post('dd'),'diskon'=>$this->input->post('cc'), 

'harga_jual'=>$this->input->post ('bb'), 'satuan'=>$this-> 

input->post('ee')); 

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

}else{ 

$data = array('id_produk'=>$this->input->post('aa'), 

'jumlah'=>$this->input->post('dd'), 'diskon'=>$this-> input-> 

post('cc'), 'harga_jual'=>$this->input->post ('bb'), 'satuan' 

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

$where = array('id_penjualan_detail' => $this->input -> post 

('idpd')); 

$this->model_app->update('rb_penjualan_detail', $data, 

$where); 

} 

redirect('administrator/edit_penjualan/'.$this->input-> 

post('idp'));} 

}else{ 

214 

$data['rows'] = $this->model_reseller->penjualan_detail ($this 

->uri->segment(3))->row_array(); 

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

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

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

'id_penjualan_detail','DESC'); 

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

('rb_produk','id_produk','ASC'); 

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

('rb_reseller','id_reseller','ASC'); 

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

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

('rb_penjualan_detail',array('id_penjualan_detail'=>$this->uri  

->segment(4)))->row_array(); 

} 

$this->template->load('administrator/template', 

'administrator/additional/mod_penjualan/view_penjualan_e

dit',$data); 

} 

} 

 

function proses_penjualan(){ 

cek_session_akses('penjualan',$this->session-> id_session); 

$data = array('proses'=>$this->uri->segment(4)); 

$where = array('id_penjualan' => $this->uri-> segment(3)); 

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

$order = $this->db->query("SELECT a.*, b.id_pembeli, 

b.kode_transaksi FROM rb_penjualan_detail a JOIN 

215 

rb_penjualan b ON a.id_penjualan=b.id_penjualan where 

a.id_penjualan='".$this->uri->segment(3)."'"); 

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

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

rb_produk where id_produk_perusahaan='$row [id_produk]' 

AND id_reseller='$row [id_pembeli]'"); 

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

$pro = $cek_produk->row_array(); 

$kode_transaksi = "TRX-".date('YmdHis'); 

$data = array('kode_transaksi'=>$kode_transaksi, 'id_pembeli' 

=>$row['id_pembeli'], 'id_penjual'=>'1', 'status_pembeli'=> 

'reseller', 'status_penjual'=> 'admin', 'service'=>$row 

['kode_transaksi'], 'waktu_ transaksi'=>date('Y-m-d H:i:s'), 

'proses'=>'1'); 

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

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

$data = array('id_penjualan'=>$idp, 'id_produk'=> 

$pro['id_produk'],'jumlah'=>$row['jumlah'], 

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

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

}else{ 

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

id_produk='$row[id_produk]'")->row_array(); 

$data = array('id_produk_perusahaan'=>$p ['id_produk'], 

’id_kategori_produk'=>$p['id_kategori_produk'], 

'id_kategori_produk_sub'=>$p['id_kategori_ produk_sub'], 

'id_reseller'=>$row['id_pembeli'], 'nama_produk'=> 

$p['nama_produk'], 'produk_seo'=> $p['produk_seo'], 

216 

'satuan'=>$p['satuan'], 'harga_beli' =>$p['harga_beli'], 

'harga_reseller'=>$p['harga_reseller'],'harga_konsumen'=>$p['

harga_konsumen'], 

'berat'=>$p['berat'],'gambar'=>$p['gambar'], 

'keterangan'=>$p['keterangan'], 'username'=>$p ['username'], 

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

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

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

$kode_transaksi = "TRX-".date('YmdHis'); 

$data = array('kode_transaksi'=>$kode_transaksi, 'id_pembeli' 

=>$row['id_pembeli'],'id_penjual'=>'1',   'status_pembeli'=> 

'reseller','status_penjual'=> 'admin', 'service'=>$row 

['kode_transaksi'], 'waktu_ transaksi'=>date('Y-m-d H:i:s'), 

'proses'=>'1') ; 

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

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

$data = array('id_penjualan'=>$idp, 'id_produk'=> 

$id_produk, 'jumlah'=>$row['jumlah'], 'harga_jual'=> 

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

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

} 

} 

redirect('administrator/penjualan');  

} 

 

function proses_penjualan_detail(){ 

cek_session_akses('penjualan',$this->session-> id_session); 

$data = array('proses'=>$this->uri->segment(4)); 

217 

$where = array('id_penjualan' => $this->uri-> segment(3)); 

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

redirect('administrator/detail_penjualan/'.$this->uri-> 

segment(3));  

} 

 

function delete_penjualan(){ 

cek_session_akses('penjualan',$this->session-> id_session); 

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

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

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

redirect('administrator/penjualan'); 

 } 

 

function delete_penjualan_detail(){ 

cek_session_akses('penjualan',$this->session-> id_session); 

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

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

redirect('administrator/edit_penjualan/'.$this->uri-> 

segment(3)); 

} 

 

function delete_penjualan_tambah_detail(){ 

cek_session_akses('penjualan',$this->session-> id_session); 

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

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

redirect('administrator/tambah_penjualan'); 

 } 

 

218 

 

function pembayaran_reseller(){ 

cek_session_akses('konsumen',$this->session-> id_session); 

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

c.kode_transaksi, c.proses FROM `rb_konfirmasi_ 

pembayaran` a JOIN rb_rekening b ON a.id_rekening 

=b.id_rekening JOIN rb_penjualan c ON a.id_penjualan 

=c.id_penjualan ORDER BY a.id_konfirmasi_pembayaran 

DESC"); 

$this->template->load('administrator/template', 

'administrator/additional/mod_reseller/view_reseller_pemba

yaran',$data); 

 } 

 

function download_bukti(){ 

cek_session_akses('pembayaran_reseller',$this-> session-> 

id_session); 

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

$data = file_get_contents("asset/files/".$name); 

force_download($name, $data); 

} 

 

function keuangan(){ 

cek_session_akses('keuangan',$this->session-> id_session); 

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

('rb_reseller','id_reseller','DESC'); 

$this->template->load('administrator/template', 

'administrator/additional/mod_keuangan/view_keuangan',$

data); } 

219 

 

function bayar_bonus(){ 

cek_session_akses('keuangan',$this->session-> id_session); 

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

$data = array('id_reseller'=>$this->input->post('idk'), 

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

'waktu_pencairan'=>date('YmdHis')); 

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

redirect('administrator/bayar_bonus/'.$this->input   -> post 

('idk')); 

}else{ 

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

$record = $this->model_reseller->reseller_pembelian 

($id,'admin'); 

$penjualan = $this->model_reseller->penjualan_list_ 

konsumen($id,'reseller'); 

$edit = $this->model_app->edit('rb_reseller',array 

('id_reseller'=>$id))->row_array(); 

$reward = $this->model_app->view_ordering 

('rb_reward','id_reward','ASC'); 

$data = array('rows' => $edit,'record'=>$record, 'penjualan'=> 

$penjualan,'reward'=>$reward);$this-> template->load 

('administrator/template', 'administrator/additional/mod_ 

keuangan/view_bayar_bonus',$data); 

} } 

function logout(){ 

$this->session->sess_destroy(); 

redirect('main');  

} 

220 

} 

 

6.7 Membuat Form Reseller(member)  

a. Membuat Form Registrasi 

Buat file registari reseller lalu simpan dalam folder 

C:\.....\application\views\phpmu\reseller dengan nama file 

view register, lalu ketik kode program seperti ini: 

 

<div class='panel-body'> 

<ul class='myTabs nav nav-tabs' role='tablist'> 

<li role='presentation' class='active'><a href= '#konsumen' 

id='konsumen-tab' role='tab' data-toggle='tab' aria-

controls='konsumen' aria-expanded ='true'>Pendaftaran 

Pembeli </a></li> 

<li role='presentation' class=''><a href='#reseller' role='tab' 

id='reseller-tab' data-toggle='tab' aria-controls='reseller' aria-

expanded='false'> Pendaftaran Penjual</a></li> 

</ul><br> 

<div id='myTabContent' class='tab-content'> 

<div role='tabpanel' class='tab-pane fade active in' 

id='konsumen' aria-labelledby='konsumen-tab'> 

<div class='alert alert-info'><b>PENTING!</b> Lengkapi 

Form dibawah ini untuk mendaftarkan diri Sebagai 

<b>Pembeli</b>, harap di isi dengan data yang sebenar-

benarnya sesuai dengan KTP, Terima kasih...</div> 

<div class="block-content"> 

<div id="writecomment"> 

221 

<form action="<?php echo base_url();?> auth/register" 

method="POST" id="form_komentar "> 

<p class="contact-form-user"> 

<label for="c_name">Username<span class= "required">* 

</label> 

<input type="text" name='a' class="required" onkeyup= 

"nospaces(this)" required/> 

</p> 

<p class="contact-form-user"> 

<label for="c_name">Password<span class= "required">* 

</label> 

<input type="password" name='b' class="required" onkeyup= 

"nospaces(this)" required/> 

</p> 

<p class="contact-form-user"> 

<label for="c_name">Nama Lengkap<span class= "required"> 

*</label> 

<input type="text" name='c' placeholder="Tuliskan Nama 

Lengkap,.." class="required" required/> 

</p> 

<p class="contact-form-email"> 

<label for="c_email">E-mail<span class= "required"> * 

</span></label> 

<input type="email" name='d' placeholder= 

"alamat.emailanda@mail.com" onkeyup="nospaces (this)" 

class="required" required/> 

</p> 

<p class="contact-form-message"> 

222 

<label for="c_message">Provinsi<span class= 

"required">*</span></label> 

<?php echo "<select style='margin-left:5px' class='form-

control' name='g' id='state' required> 

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

foreach ($provinsi as $rows) { 

echo "<option value='$rows[provinsi_id]'> $rows 

[nama_provinsi]</option>"; 

} 

echo "</select>"; ?> 

</p> 

<p class="contact-form-message"> 

<label for="c_message"> Kota <span class= 

"required">*</span></label> 

<select style='margin-left:5px' class='form-control' name='h' 

id='city' required> 

<option value=''>- Pilih -</option> 

</select> 

</p> 

<p class="contact-form-user"> 

<label for="c_name">Kecamatan<span class= "required">* 

</label> 

<input type="text" name='i' placeholder="Nama Kecamatan.." 

class="required" required/></p> 

<p class="contact-form-message"> 

<label for="c_message"> Alamat <span class= 

"required">*</span></label> 

223 

<textarea name='e' placeholder="Alamat Desa, Jalan, dan No 

Rumah/Kantor anda.." class="required" required></textarea> 

</p> 

<p class="contact-form-user"> 

<label for="c_name">No Handphone<span class= 

"required">*</label> 

<input type="number" name='j'placeholder= "08**********" 

class="required" required/> 

</p> 

<p><input type="submit" name="submit1" class= "styled-

button" value="Daftar Sebagai Pembeli"/> </p> 

</form> 

</div> 

</div> 

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

</div> 

<div role='tabpanel' class='tab-pane fade' id= 'reseller' aria-

labelledby='reseller-tab'> 

<div class='alert alert-warning'><b>PENTING!</b> Lengkapi 

Form dibawah ini untuk mendaftarkan diri sebagai 

<b>Penjual</b>, harap di isi dengan data yang sebenar-

benarnya, Terima kasih...</div> 

<div class="block-content"> 

<div id="writecomment"> 

<form action="<?php echo base_url(); ?> auth/register" 

method="POST" id="form_ komentar" > 

<p class="contact-form-user"> 

224 

<label for="c_name">Username<span class= "required">* 

</label> 

<input type="text" name='a' class="required" onkeyup= 

"nospaces(this)" required/></p> 

<p class="contact-form-user"> 

<label for="c_name">Password<span class= "required"> 

*</label> 

<input type="password" name='b' class="required" onkeyup= 

"nospaces(this)" required/></p> 

<p class="contact-form-user"> 

<label for="c_name">Nama Toko<span class= "required">* 

</label> 

<input type="text" name='c' placeholder="Tuliskan Nama 

Anda/Toko,.." class="required" required/> 

</p> 

<p class="contact-form-user"> 

<label for="c_name">Jenis Kelamin<span class= "required">* 

</label> 

<input type='radio' name='d' value='Laki-laki'> Laki-laki 

&nbsp; 

<input type='radio' name='d' value='Perempuan'> Perempuan 

</p> 

<p class="contact-form-user"> 

<label for="c_name">No Handphone<span class= "required"> 

*</label> 

<input type="number" name='f'placeholder= "08**********" 

class="required" required/> 

</p> 

225 

<p class="contact-form-email"> 

<label for="c_email"> E-mail <span class= "required">* 

</span> 

</label> 

<input type="email" name='g' placeholder=  

"alamat.emailanda@mail.com" onkeyup="nospaces (this)" 

class="required" required/> 

</p> 

<p class="contact-form-message"> 

<label for="c_message"> Provinsi <span class= "required">* 

</span></label> 

<?php echo "<select style='margin-left:5px' class='form-

control' name='state' id='state_reseller' required> 

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

foreach ($provinsi as $rows) { 

echo "<option value='$rows[provinsi_id]'> $rows 

[nama_provinsi] </option>"; 

} 

echo "</select>"; ?> 

</p> 

<p class="contact-form-message"> 

<label for="c_message"> Kota <span class= "required"> 

*</span></label> 

<select style='margin-left:5px' class='form-control' name= 

'kota' id='city_reseller' required> 

<option value=''>- Pilih -</option> 

</select> 

</p> 

226 

<p class="contact-form-message"> 

<label for="c_message"> Alamat <span class= "required">* 

</span> 

</label> 

<textarea name='e' placeholder="Nama Kecamatan, Desa, 

Jalan, dan No Rumah anda.." class="required" 

required></textarea> 

</p>                    

<p class="contact-form-user"> 

<label for="c_name">Kode POS <span class= "required">* 

</label> 

<input type="number" name='h' placeholder= "*******" 

onkeyup="nospaces(this)" class="required" required/> 

</p> 

<p class="contact-form-user"> 

<label for="c_name">Referral<span class= "required">* 

</label> 

<input type="text" name='i' placeholder="Username 

Referral.." onkeyup="nospaces(this)" class= "required" 

required/> 

</p> 

<p><input type="submit" name="submit2" class= "styled-

button" value="Daftar Sebagai Penjual"/> </p> 

</form> 

</div> 

</div> 

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

</div> 

227 

</div> 

</div> 

 

 

b. Membuat view login 

Setelah file form register dibuat, lalu buat file view_login.php 

untuk login sebagai reseller/member. 

Ketikan kode program berikut: 

<div class='panel-body'> 

<ul class='myTabs nav nav-tabs' role='tablist'> 

<li role='presentation' class='active'> 

<a href= '#konsumen' id='konsumen-tab' role='tab' data-

toggle='tab' aria-controls='konsumen' aria-expanded= 

'true'>Pendaftaran Pembeli </a></li> 

<li role='presentation' class=''><a href='#reseller' role='tab' 

id='reseller-tab' data-toggle='tab' aria-controls='reseller' aria-

expanded='false'> Pendaftaran Penjual</a></li> 

</ul><br> 

<div id='myTabContent' class='tab-content'> 

<div role='tabpanel' class='tab-pane fade active in' 

id='konsumen' aria-labelledby='konsumen-tab'> 

 

<div class='alert alert-info'><b>PENTING!</b> Lengkapi 

Form dibawah ini untuk mendaftarkan diri Sebagai 

<b>Pembeli</b>, harap di isi dengan data yang sebenar-

benarnya sesuai dengan KTP, Terima kasih...</div> 

<div class="block-content"> 

<div id="writecomment"> 

228 

<form action="<?php echo base_url(); ?> auth/register" 

method="POST" id="form_komentar"> 

<p class="contact-form-user"> 

<label for="c_name"> Username <span class= "required">* 

</label> 

<input type="text" name='a' class="required" onkeyup= 

"nospaces(this)" required/> 

</p> 

<p class="contact-form-user"> 

<label for="c_name"> Password <span class= "required">* 

</label> 

<input type="password" name='b' class="required" onkeyup= 

"nospaces(this)" required/> 

</p> 

<p class="contact-form-user"> Lengkap <span class= 

"required">*</label> 

<input type="text" name='c' placeholder="Tuliskan Nama 

Lengkap,.." class="required" required/> 

</p> 

<p class="contact-form-email"> 

<label for="c_email"> E-mail <span class= "required"> 

*</span></label> 

<input type="email" name='d' placeholder= 

"alamat.emailanda@mail.com" onkeyup="nospaces (this)" 

class="required" required /> 

</p> 

<p class="contact-form-message"> 

229 

<label for="c_message"> Provinsi <span class= "required">* 

</span></label> 

<?php echo "<select style='margin-left:5px' class='form-

control' name='g' id='state' required> 

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

foreach ($provinsi as $rows) { 

  echo "<option value='$rows[provinsi_id]'>$rows 

[nama_provinsi] </option>"; 

} 

echo "</select>"; ?> 

</p> 

<p class="contact-form-message"> 

<label for="c_message"> Kota <span class= "required">* 

</span></label> 

<select style='margin-left:5px' class='form-control' name='h' 

id='city' required> 

<option value=''>- Pilih -</option> 

</select> 

</p> 

<p class="contact-form-user"> 

<label for="c_name"> Kecamatan <span class= "required">* 

</label> 

<input type="text" name='i' placeholder="Nama Kecamatan.." 

class="required" required/> 

</p> 

<p class="contact-form-message"> 

<label for="c_message"> Alamat <span class= "required">* 

</span></label> 

230 

<textarea name='e' placeholder="Alamat Desa, Jalan, dan No 

Rumah/Kantor anda.." class="required" required></textarea> 

</p> 

 

<p class="contact-form-user"> 

<label for="c_name"> No Handphone <span class= 

"required">*</label> 

<input type="number" name='j' placeholder= "08**********" 

class="required" required/> 

</p> 

<p><input type="submit" name="submit1" class= "styled-

button" value="Daftar Sebagai Pembeli"/> </p> 

</form> 

</div> 

</div> 

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

</div> 

<div role='tabpanel' class='tab-pane fade' id= 'reseller' aria-

labelledby='reseller-tab'> 

<div class='alert alert-warning'><b>PENTING!</b> Lengkapi 

Form dibawah ini untuk mendaftarkan diri sebagai 

<b>Pelapak</b>, harap di isi dengan data yang sebenar-

benarnya, Terima kasih...</div> 

<div class="block-content"> 

<div id="writecomment"> 

<form action="<?php echo base_url(); ?> auth/register" 

method="POST" id="form_komentar"> 

<p class="contact-form-user"> 

231 

<label for="c_name"> Username <span class= "required"> 

*</label> 

<input type="text" name='a' class="required" onkeyup= 

"nospaces(this)" required/> 

</p> 

<p class="contact-form-user"> 

<label for="c_name"> Password <span class= "required"> 

*</label> 

<input type="password" name='b' class="required" 

onkeyup="nospaces(this)" required/> 

</p> 

<p class="contact-form-user"> 

<label for="c_name">Nama Toko<span class= "required">* 

</label> 

<input type="text" name='c' placeholder="Tuliskan Nama 

Anda / Toko,.." class="required" required/></p> 

<p class="contact-form-user"> 

<label for="c_name"> Jenis Kelamin <span class= "required">* 

</label> 

<input type='radio' name='d' value='Laki-laki'> Laki-laki 

&nbsp; 

<input type='radio' name='d' value='Perempuan'> Perempuan 

</p> 

<p class="contact-form-user"> 

<label for="c_name">No Handphone<span class= "required"> 

*</label> 

<input type="number" name='f'placeholder= "08**********" 

class="required" required/> 

232 

</p> 

<p class="contact-form-email"> 

<label for="c_email"> E-mail <span class= "required"> 

*</span></label> 

<input type="email" name='g' placeholder= 

"alamat.emailanda@mail.com" onkeyup="nospaces (this)" 

class="required" required/></p> 

<p class="contact-form-message"> 

<label for="c_message"> Provinsi <span class= "required">* 

</span></label> 

<?php echo "<select style='margin-left:5px' class='form-

control' name='state' id='state_reseller' required> 

foreach ($provinsi as $rows) { 

echo "<option value='$rows[provinsi_id]'>$rows 

[nama_provinsi]</option>"; 

} 

echo "</select>"; ?> 

</p> 

<p class="contact-form-message"> 

<label for="c_message"> Kota <span class= "required">* 

</span></label> 

<select style='margin-left:5px' class='form-control' name= 

'kota' id='city_reseller' required> 

<option value=''>- Pilih -</option> 

</select> 

</p> 

<p class="contact-form-message"> 

233 

<label for="c_message"> Alamat <span class= "required">* 

</span></label> 

<textarea name='e' placeholder="Nama Kecamatan, Desa, 

Jalan, dan No Rumah anda.." class="required" required> 

</textarea></p> 

<p class="contact-form-user"> 

<label for="c_name"> Kode POS <span class= "required"> 

*</label> 

<input type="number" name='h' placeholder= "*******" 

onkeyup="nospaces(this)" class="required" required/> 

</p> 

<p class="contact-form-user"> 

<label for="c_name"> Referral <span class= "required">* 

</label> 

<input type="text" name='i' placeholder="Username 

Referral.." onkeyup="nospaces(this)" class= "required" 

required/> 

</p> 

<p><input type="submit" name="submit2" class="styled-

button" value="Daftar Sebagai Penjual"/></p> 

</form> 

</div> 

</div> 

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

</div> 

</div> 

</div> 

 

c. View_profile.php 

234 

<?php  

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

Profile Anda  

<a class='btn btn-success btn-xs pull-right' href='".base_url() 

."members/edit_profile'><span class='glyphicon glyphicon-

edit'></span> Edit Profile </a></p>"; 

echo $this->session->flashdata('message');  

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

echo "<p>Berikut Informasi Data Profile anda.<br>  

Pastikan data-data dibawah ini sudah benar, agar tidak terjadi 

kesalahan saat transaksi.</p>";                 

echo "<table class='table table-hover table-condensed'> 

<thead> 

<tr><td width='170px'><b>Username</b></td> <td><b 

style='color:red'>$row[username]</b></td> </tr> 

<tr><td><b>Nama Lengkap</b></td>           

<td>$row[nama_lengkap]</td></tr> 

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

<td>$row[email]</td></tr> 

<tr><td><b>Jenis Kelamin</b></td> 

<td>$row [jenis_kelamin]</td></tr> 

<tr><td><b>Tanggal Lahir</b></td>          

<td>".tgl_indo($row['tanggal_lahir'])."</td></tr> 

<tr><td><b>Tempat Lahir</b></td>           

<td>$row[tempat_lahir]</td></tr> 

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

<td>$row[alamat_lengkap]</td></tr> 

235 

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

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

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

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

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

<td>$row[kecamatan]</td></tr> 

<tr><td><b>No Hp</b></td>                  

<td>$row[no_hp]</td></tr> 

</thead> 

</table>"; 

 

/* 

echo "<table id='example11' class='table table-hover table-

condensed'> 

<thead> 

<tr> 

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

<th>Nama Penjual</th> 

<th>Belanja & Ongkir</th> 

<th>Status</th> 

<th>Total + Ongkir</th> 

<th></th> 

</tr> 

</thead> 

<tbody>"; 

$no = 1; 

$record = $this->model_reseller->orders_report ($this-> 

session->id_konsumen,'reseller'); 

236 

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

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><a href='".base_url()."members/detail_reseller /$row 

[id_reseller]'><small><b>$row[nama_reseller]</b></small><

br><small class='text-success'> $row [kode_transaksi] 

</small></a></td> 

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

</span> <br> <small> <i style='color:  green;'> <b style='text-

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

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

<td>$proses <br><small>$row[nama_reseller]</small></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-

sm' title='Konfirmasi Pembayaran' href='".base_url(). 

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

}else{ 

237 

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

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

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

} 

               

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

href='".base_url()."members/keranjang_detail/$row 

[id_penjualan]'><span class='glyphicon glyphicon-search'> 

</span></a></td> 

</tr>"; 

$no++; 

} 

echo "</tbody> 

</table>"; */ 

?> 

d. Edit_profile.php 

<?php  

echo "<p class='sidebar-title text-danger produk-title'> Edit 

Data Profile Anda</p> 

<p>Berikut Informasi Data Profile anda.<br>  

Pastikan data-data dibawah ini sudah benar, agar tidak terjadi 

kesalahan saat transaksi.</p>";                 

$attributes = array('id' => 'formku','class'=>'form-horizontal' 

,'role'=>'form'); 

echo form_open_multipart('members/edit_profile', 

$attributes);  

$ko = $this->db->query("SELECT * FROM rb_kota where 

kota_id='$row[kota_id]'")->row_array(); 

echo "<table class='table table-hover table-condensed'> 

238 

<thead> 

<tr><td width='140px'><b>Username</b></td> <td><input 

class='required form-control' style= 'width:50%; display:inline-

block' name='aa' type= 'text' value='$row[username]'> 

</td></tr> 

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

<td><input class='form-control' style='width:50%; display: 

inline-block' type='password' name='a'> <small style= 

'color:red'><i>Kosongkan Saja Jika Tidak dirubah.</i> 

</small></td></tr> 

<tr><td><b>Nama Lengkap</b></td> 

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

value='$row[nama_lengkap]'></td></tr> 

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

<td><input class='required email form-control' type='email' 

name='c' value='$row[email]'></td> </tr> 

<tr><td><b>Jenis Kelamin</b></td> 

<td>"; if($row['jenis_kelamin']=='Laki-laki'){ echo "<input 

type='radio' value='Laki-laki' name='d' checked> Laki-laki 

<input type='radio' value='Perempuan' name='d'> Perempuan 

";  

}else{echo "<input type='radio' value='Laki-laki' name='d'> 

Laki-laki <input type='radio' value='Perempuan' name='d' 

checked> Perempuan "; } echo "</td></tr> 

<tr><td><b>Tanggal Lahir</b></td>  

<td><input class='required datepicker form-control' 

type='text' name='e' value='$row[tanggal_lahir]' data-date-

format='yyyy-mm-dd'></td></tr> 

239 

<tr><td><b>Tempat Lahir</b></td> 

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

value='$row[tempat_lahir]'></td></tr> 

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

<td><textarea class='required form-control' name='g'> 

$row[alamat_lengkap]</textarea> </td> </tr> 

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

<td> <select class='form-control' name='ewrwe' 

id='state_reseller' required> 

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

foreach ($provinsi as $rows) { 

if ($ko['provinsi_id']==$rows['provinsi_id']){ 

echo "<option value='$rows[provinsi_id]' selected> $rows 

[nama_provinsi]</option>"; 

}else{ 

echo "<option value='$rows[provinsi_id]'>$rows 

[nama_provinsi]</option>"; 

} 

} 

echo "</select></td></tr> 

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

<td><select class='form-control' name='ga' id='city_ reseller' 

required> 

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

$kota = $this->model_app->view_where_ordering ('rb_kota', 

array('provinsi_id'=>$ko['provinsi_id']),'kota_id','DESC'); 

foreach ($kota as $rows) { 

if ($ko['kota_id']==$rows['kota_id']){ 

240 

echo "<option value='$rows[kota_id]' selected>$rows 

[nama_kota] </option>"; 

}else{ 

echo "<option value='$rows[kota_id]'>$rows [nama_kota] 

</option>"; 

} 

} 

echo "</select></td></tr> 

</td></tr> 

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

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

value='$row[kecamatan]'></td></tr> 

<tr><td><b>No Hp</b></td>                   

<td><input style='width:40%' class='required number form-

control' type='number' name='l' value='$row [no_hp]'> 

</td></tr> 

                          

<tr><td></td><td><input class='btn btn-sm btn-primary' 

type='submit' name='submit' value='Simpan Perubahan'> 

</td></tr> 

</thead> 

</table>"; 

echo form_close(); 

?> 

 

Setelah membuat file view_profile.php dan 

edit_profile.php, lalu buat file member.php dan simpan pada 

241 

folder C:\.....\application\controllers. Ketikan kode program 

seperti berikut: 

 

<?php 

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

allowed'); 

class Members extends CI_Controller { 

 

function foto(){ 

cek_session_members(); 

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

$this->model_reseller->modupdatefoto(); 

redirect('members/profile'); 

}else{ 

redirect('members/profile'); 

} 

} 

 

function profile(){ 

cek_session_members(); 

$data['title'] = 'Profile Anda'; 

$data['row'] = $this->model_reseller->profile_ konsumen 

($this->session->id_konsumen)-> row_array(); 

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

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

} 

 

function edit_profile(){ 

242 

cek_session_members(); 

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

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

$this->model_reseller->profile_update($this-> session-> 

id_konsumen); 

redirect('members/profile'); 

}else{ 

$data['title'] = 'Edit Profile Anda'; 

$data['row'] = $this->model_reseller->profile_konsumen 

($this->session->id_konsumen)->row_ array(); 

$row = $this->model_reseller->profile_konsumen ($this-> 

session->id_konsumen)->row_array(); 

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

('rb_provinsi','provinsi_id','ASC'); 

$data['rowse'] = $this->db->query("SELECT provinsi_id 

FROM rb_kota where kota_id='$row [kota_id]'")-> 

row_array(); 

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

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

} 

} 

function reseller(){ 

cek_session_members(); 

$jumlah= $this->model_app->view('rb_reseller')-> num_rows 

(); 

$config['base_url'] = base_url().'members/reseller'; 

$config['total_rows'] = $jumlah; 

$config['per_page'] = 12;   

243 

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

$dari = 0; 

}else{ 

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

} 

if (is_numeric($dari)) { 

$data['title'] = 'Semua Daftar Reseller'; 

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

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

$data['record'] = $this->model_reseller->cari_reseller  

}elseif (isset($_GET['cari_reseller'])){ 

$data['record'] = $this->model_reseller->cari_reseller (filter 

($this->input->get('cari_reseller'))); 

$total = $this->model_reseller->cari_reseller(filter ($this-> 

input->get('cari_reseller'))); 

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

$row = $total->row_array(); 

redirect('produk/keranjang/'.$row['id_reseller'].'/'.$this-> 

session->produk); 

} 

}else{ 

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

rb_reseller a LEFT JOIN rb_kota b ON a.kota_id=b.kota_id 

ORDER BY id_reseller DESC LIMIT $dari,$config[per_page]"); 

} 

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

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

}else{ 

244 

redirect('main'); 

} 

} 

 

function detail_reseller(){ 

cek_session_members(); 

$data['title'] = 'Detail Profile Reseller'; 

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

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

array('id_reseller'=>$id))->row_array(); 

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

list_konsumen($id,'reseller'); 

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

('rb_rekening_reseller',array('id_reseller'=>$id)); 

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

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

} 

 

function orders_report(){ 

cek_session_members(); 

$data['title'] = 'Laporan Pesanan Anda'; 

$data['record'] = $this->model_reseller->orders_report ($this-> 

session->id_konsumen,'reseller'); 

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

'/reseller/members/view_orders_report',$data); 

} 

 

function produk_reseller(){ 

cek_session_members(); 

245 

$jumlah= $this->model_app->view('rb_produk')-> 

num_rows(); 

$config['base_url'] = base_url().'members/produk_ reseller 

/'.$this->uri->segment('3'); 

$config['total_rows'] = $jumlah; 

$config['per_page'] = 12;   

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

$dari = 0; 

}else{ 

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

} 

if (is_numeric($dari)) { 

$data['title'] = 'Data Produk Reseller'; 

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

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

a JOIN rb_kota b ON a.kota_id=b.kota_id where a.id_reseller= 

'$id'")->row_array(); 

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

_limit('rb_produk',array('id_reseller!='=>'0'),'id_produk','DES

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

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

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

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

}else{ 

redirect('main'); 

}  

} 

 

function keranjang(){ 

246 

cek_session_members(); 

$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']; 

if ($id_produk!=''){ 

if ($stok <= '0'){ 

$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 Reseller ini telah habis!'); 

window.location=('".base_url()."members/reseller') 

</script>"; 

}else{ 

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

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

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

$data = array('kode_transaksi'=>$kode_transaksi, 'id_pembeli' 

=>$this->session->id_konsumen,'id_penjual'=>$id_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(); 

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

247 

} 

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

$reseller=$this->model_app->view_where('rb_penjualan', 

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

$cek=$this->model_app->view_where('rb_penjualan_detail', 

array('id_penjualan'=>$this->session->idp,'id_produk'=> 

$id_produk))->num_rows (); 

if ($reseller['id_penjual']==$id_reseller){ 

if ($cek >=1){ 

$this->db->query("UPDATE rb_penjualan_detail SET jumlah= 

jumlah+$qty where id_penjualan='".$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']-$disk 

['diskon']; 

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

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

=>$harga_konsumen, 'satuan'=>$harga['satuan']); 

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

redirect('members/keranjang'); 

}else{ 

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

248 

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

detail($this->session->idp)->row_array(); 

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

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

('id_penjualan'=>$this->session->idp), 

'id_penjualan_detail','ASC'); 

} 

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

$data['error_reseller'] = "<div class='alert alert-danger'> Maaf, 

Dalam 1 Transaksi hanya boleh order dari 1 Reseller 

saja.</div>"; 

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

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

} 

} 

}else{ 

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

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

detail($this->session->idp)->row_array(); 

$data['rowsk'] = $this->model_reseller->view_join_where 

_one('rb_konsumen','rb_kota','kota_id',array('id_konsumen' 

=>$this->session->id_konsumen))-> row_array (); 

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

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

('id_penjualan'=>$this->session->idp),'id_penjualan_detail', 

'ASC'); 

} 

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

249 

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

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

} 

} 

 

function keranjang_detail(){ 

cek_session_members(); 

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

detail($this->uri->segment(3))->row_ array(); 

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

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

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

'id_penjualan_detail','ASC'); 

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

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

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

} 

 

 

function keranjang_delete(){ 

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

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

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

jumlah FROM rb_penjualan_detail where id_penjualan= 

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

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

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

$this->model_app->delete('rb_penjualan',$idp); 

250 

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

} 

redirect('members/keranjang'); 

} 

 

function selesai_belanja(){ 

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

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

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

$cekres=$this->model_app->view_where 

('rb_penjualan',array('id_penjualan'=>$this->session->idp)) -> 

row_array(); 

$kons = $this->model_reseller->profile_konsumen ($this-> 

session->id_konsumen)->row_array(); 

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

('id_reseller'=>$cekres['id_penjual']))-> row_array(); 

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

('rb_rekening_reseller',array('id_reseller'=>$cekres['id_penjual'

])); 

$data1 = array('kurir'=>$this->input->post('kurir'), 

'service'=>$this->input->post('service'), 'ongkir'=>$this-> 

input-> post('ongkir')); 

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

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

$email_tujuan = $kons['email']; 

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

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

251 

$message="<html><body>Halooo!<b>".$kons['nama_ 

lengkap']."</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> : 

".$kons['nama_lengkap']."</td></tr> 

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

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

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

<td> : ".$kons['no_hp']."</td></tr> 

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

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

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

<td> : ".$kons['negara']." </td></tr> 

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

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

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

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

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

<td> : ".$kons['kecamatan']." </td></tr> 

</table><br> 

 

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

252 

<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>".$cekres['kode_transaksi']." </b> <br> 

Berikut Detail Data Orderan Anda : 

<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>"; 

253 

$no = 1; 

$belanjaan = $this->model_app->view_join_where 

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

alan'=>$this->session->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'])." Kg</td> 

<td>Rp ".rupiah($sub_total)."</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 (); 

$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] Kg</b></td> 

</tr> 

254 

</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; 

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

reseller',array('id_reseller'=>$cekres ['id_penjual'])); 

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> 

 

255 

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

$config['wordwrap'] = TRUE; 

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

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

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

} 

redirect('members/orders_report/orders');} 

function batalkan_transaksi(){ 

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

"alert alert-danger"><center>Anda Telah mebatalkan 

Transaksi! </center></div>'); 

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

$this->model_app->delete('rb_penjualan',$idp); 

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

256 

$this->model_app->delete('rb_penjualan_detail', $idp_detail); 

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

redirect('members/profile'); 

} 

 

function order(){ 

cek_session_members(); 

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

segment(3))); 

$cek = $this->db->query("SELECT b.nama_kota FROM 

rb_konsumen a JOIN rb_kota b ON a.kota_id=b.kota_id where 

a.id_konsumen='".$this->session->id_konsumen."'")-> 

row_array(); 

redirect('members/reseller?cari_reseller='.$cek['nama_kota']); 

} 

 

public function username_check(){ 

// allow only Ajax request     

if($this->input->is_ajax_request()) { 

// grab the email value from the post variable. 

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

if(!$this->form_validation->is_unique($username, 

'rb_konsumen.username')) {           

$this->output->set_content_type('application/json')-> 

set_output(json_encode(array('messageusername'=>'Maaf, 

Username ini sudah terdaftar,..')));  

} 

} 

257 

} 

 

public function email_check(){ 

// allow only Ajax request     

if($this->input->is_ajax_request()) { 

// grab the email value from the post variable. 

$email = $this->input->post('d'); 

if(!$this->form_validation->is_unique($email, 

'rb_konsumen.email')) {           

$this->output->set_content_type('application/json') -> 

set_output(json_encode(array('message' => 'Maaf, Email ini 

sudah terdaftar,..'))); 

} 

} 

} 

 

function logout(){ 

cek_session_members(); 

$this->session->sess_destroy(); 

redirect('main');  

} } 

6.8 Membuat Kategori Barang 

a. View_kategori.php 

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

<div class="box"> 

<div class="box-header"> 

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

258 

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

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

?>  

/tambah_kategoriberita'>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 Kategori</th> 

<th>Link</th> 

<th>Posisi</th> 

<th>Aktif</th> 

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

</tr> 

</thead> 

<tbody> 

<?php  

$no = 1; 

foreach ($record as $row){ 

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

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

 <td><a target='_BLANK' href='".base_url()."kategori /detail/ 

$row[kategori_seo]'>kategori/detail/$row 

kategori_seo]</a></td> 

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

259 

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

<td><center> 

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

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

edit_kategoriberita/$row[id_kategori]'><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_kategoriberita/$row[id_kategori]' onclick=\" return 

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

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

</center></td> 

</tr>"; 

$no++; 

} 

?> 

</tbody> 

</table> 

</div> 

 

 

 

b. View_kategori_edit 

<?php  

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

<div class='box box-info'> 

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

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

</div> 

260 

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

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

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

'/edit_kategoriberita',$attributes);  

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

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

<tbody> 

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

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

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

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

<tr><th scope='row'>Aktif</th> <td>";  

if ($rows['aktif']=='Y'){ echo "<input type='radio' name='b' 

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

value='N'> Tidak"; } 

else{ echo "<input type='radio' name='b' value='Y'> Ya &nbsp; 

<input type='radio' name='b' value='N' checked> Tidak"; } 

echo "</td></tr> 

<tr><th scope='row'>Posisi</th>                         <td><input 

type='number' class='form-control' name='c' 

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

</tbody> 

</table> 

</div> 

<div class='box-footer'> 

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

info'>Update</button> 

261 

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

kategoriberita'><button type='button' class='btn btn-default 

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

</div> 

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

echo form_close(); 

 

c. View_kategori_tambah 

<?php  

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

<div class='box box-info'> 

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

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

</div> 

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

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

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

kategoriberita',$attributes);  

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

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

<tbody> 

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

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

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

required></td></tr> 

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

<td><input type='radio' name='b' value='Y' checked> Ya 

&nbsp; <input type='radio' name='b' value='N'> Tidak 

</td></tr> 

262 

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

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

</td></tr> 

</tbody> 

</table> 

</div> 

<div class='box-footer'> 

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

info'>Tambahkan</button> 

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

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

Cancel</button></a> 

</div> 

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

echo form_close(); 

 

d. kategori.php 

Buat Controller kategori dengan nama file kategori.php 

<?php 

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

allowed'); 

class Kategori extends CI_Controller { 

 

public function detail(){ 

$query = $this->model_utama->view_where ('kategori', 

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

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

redirect('main'); 

}else{ 

263 

$row = $query->row_array(); 

$jumlah= $this->model_utama->view_where('tb_berita', array 

('id_kategori' => $row['id_kategori']))->num_ rows(); 

$config['base_url'] = base_url().'kategori/detail/'. $this->uri-> 

segment(3); 

$config['total_rows'] = $jumlah; 

$config['per_page'] = 10;   

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

$dari = 0; 

}else{ 

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

} 

$data['title'] = "Berita Kategori $row[nama_ kategori]"; 

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

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

$data['rows'] = $row; 

if (is_numeric($dari)) { 

$data['beritakategori'] = $this->model_utama->view_join_ 

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

('berita.status' => 'Y', 'tb_berita.id_ kategori' =>$row 

['id_kategori']),'id_berita','DESC',$dari, $config['per_page']); 

}else{ 

redirect('main'); 

} 

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

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

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

}  

264 

} 

} 

 

6.9 Membuat CRUD Data Produk 

a. view_Produk.php 

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

<div class="box"> 

<div class="box-header"> 

<h3 class="box-title">Data Stok Produk anda</h3> 

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

base_url(); 

?> reseller /tambah_produk'>Tambahkan Data</a> 

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

<div class="box-body"> 

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

table-condensed"> 

<thead> 

<tr> 

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

<th>Nama Produk</th> 

<th>Harga Modal</th> 

 <th>Harga Jual</th> 

<th>Stok</th> 

<th>Satuan</th> 

<th>Berat (Gram)</th> 

<th>Diskon (Rp)</th> 

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

</tr> 

265 

</thead> 

<tbody> 

<?php  

$no = 1; 

foreach ($record as $row){ 

$jual = $this->model_reseller->jual_reseller($this-> session-

>id_reseller,$row['id_produk'])->row_array (); 

$beli = $this->model_reseller->beli_reseller($this-> session -

>id_reseller,$row['id_produk'])->row_array() ; 

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

('id_produk'=>$row['id_produk'],'id_reseller'=>$this->session-

>id_reseller))->row_array(); 

if ($disk['diskon']=='' OR $disk['diskon']=='0'){ $diskon = '0'; 

$line = ''; $harga = ''; }else{ $diskon = $disk['diskon']; 

$line='line-through'; $harga= "/<span style ='color:red'>". 

rupiah($row ['harga_ konsumen']-$disk['diskon'])."</span>";} 

if ($row['id_produk_perusahaan']!='0'){ $perusahaan = 

"<small><i style='color:green'>(Perusahaan) </i> </small>"; 

}else{ $perusahaan = ''; } 

if ($row['id_produk_perusahaan']=='0'){$modal = $row 

['harga_beli']; 

}else{ $modal = $row['harga_reseller']; } 

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

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

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

<td>Rp <span style='text-decoration:$line'>".rupiah($row 

['harga_konsumen'])."</span> $harga</td> 

<td>".($beli['beli']-$jual['jual'])."</td> 

266 

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

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

<td>$diskon</td> 

<td><center> 

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

'".base_url()."reseller/edit_produk/$row[id_produk]'><span 

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

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

href='".base_url()."reseller/delete_produk/$row[id_produk]' 

onclick=\"return confirm('Apa anda yakin untuk hapus Data 

ini?')\"><span class='glyphicon glyphicon-

remove'></span></a> 

</center></td> 

</tr>"; 

$no++; 

} 

?> 

</tbody> 

</table><hr></div> 

 

b. view_produk_edit.php 

<script language="JavaScript" type="text/JavaScript"> 

 

function showSub(){ 

<?php 

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

_produk"); 

foreach ($query->result_array() as $data) { 

$id_kategori_produk = $data['id_kategori_produk']; 

267 

echo "if (document.demo.a.value == \"".$id_kategori_ 

produk."\")"; 

echo "{"; 

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

rb_kategori_produk_sub where id_kategori_produk= 

'$id_kategori_produk'"); 

$content = "document.getElementById('sub_kategori_ 

produk').innerHTML = \"  <option value=''>- Pilih Sub 

Kategori Produk -</option>"; 

foreach ($query_sub_kategori->result_array() as $data2) { 

$content .= "<option value='".$data2['id_kategori_ 

produk_sub']."'>".$data2['nama_kategori_sub']."</option>"; 

} 

$content .= "\""; 

echo $content; 

echo "}\n"; 

} 

?> 

} 

</script> 

 

<?php  

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

<div class='box box-info'> 

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

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

</div> 

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

268 

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

'form','name'=>'demo'); 

echo form_open_multipart('reseller/edit_produk' $attributes); 

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

('id_produk'=>$rows['id_produk'],'id_reseller' =>$this-> 

session->id_reseller))->row_array(); 

$jual = $this->model_reseller->jual_reseller($this-> session -> 

id_reseller,$rows['id_produk'])->row_array (); 

$beli = $this->model_reseller->beli_reseller($this-> session -> 

id_reseller,$rows['id_produk'])->row_array (); 

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

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

<tbody> 

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

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

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

\"showSub()\" required> 

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

foreach ($record as $row){ 

if ($rows['id_kategori_produk']==$row ['id_kategori_ 

produk']){ 

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

$row[nama_kategori]</option>"; 

}else{ 

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

[nama_kategori]</option>"; 

} 

} 

269 

echo "</select></td></tr> 

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

<td><select name='aa' class='form-control' id='sub_ 

kategori_produk'> 

<option value='' selected>- Pilih Sub Kategori Produk -

</option>"; 

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

rb_kategori_produk_sub"); 

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

if ($rows['id_kategori_produk_sub']== $row['id_kategori 

_produk_sub']){ 

echo "<option value='$row[id_kategori_produk_sub]' 

selected>$row[nama_kategori_sub]</option>"; 

}else{ 

echo "<option value='$row[id_kategori_produk_ 

sub]'>$row[nama_kategori_sub]</option>"; 

} 

} 

echo "</select></td></tr> 

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

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

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

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

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

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

<tr><th scope='row'>Berat / Gram</th>                       

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

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

270 

<tr><th scope='row'>Harga Modal</th>                  

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

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

<input type='hidden' class='form-control' name='e' 

value='$rows[harga_reseller]'> 

<tr><th scope='row'>Harga Jual</th>              

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

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

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

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

'diskon' value='$disk[diskon]'></td></tr> 

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

<td><input style='display:inline-block; width:80px; color:red' 

type='number' class='form-control' value='".($beli['beli']-

$jual['jual'])."' disabled> + <input style='display:inline-block; 

width:80px' type='number' class='form-control' name='stok'> 

</td></tr> 

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

<td><textarea class='textarea form-control' name='ff' style= 

'height:180px'>$rows[keterangan]</textarea></td></tr> 

<tr><th scope='row'>Foto Produk</th>                      

<td><input type='file' id='fileupload' class='form-control' 

name='userfile[]' multiple>Multiple Upload, Allowed File : 

.gif, jpg, png 

<div id='dvPreview'></div>"; 

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

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

foto_produk/$rows[gambar]'>$rows[gambar]</a>";  

271 

}  

echo "</td></tr> 

</tbody> 

</table> 

</div> 

</div> 

<div class='box-footer'> 

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

info'>Update</button> 

<a href='index.php'><button type='button' class='btn btn-

default pull-right'>Cancel</button></a> 

</div> 

</div>"; 

 

c. view_produk_tambah.php 

<script language="JavaScript" type="text/ JavaScript"> 

function showSub(){ 

<?php 

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

rb_kategori_produk"); 

foreach ($query->result_array() as $data) { 

$id_kategori_produk = $data['id_kategori_produk']; 

echo "if (document.demo.a.value == \"".$id_kategori_ 

produk."\")"; 

echo "{"; 

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

rb_kategori_produk_sub where id_kategori_produk= 

'$id_kategori_produk'"); 

272 

$content = "document.getElementById('sub_kategori_ 

produk').innerHTML = \"  <option value=''>- Pilih Sub 

Kategori Produk -</option>"; 

foreach ($query_sub_kategori->result_array() as $data2) { 

$content .= "<option value='".$data2['id_kategori_produk 

_sub']."'>".$data2['nama_kategori_sub']."</option>"; 

} 

$content .= "\""; 

echo $content; 

echo "}\n"; 

} 

?> 

} 

</script> 

<?php  

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

<div class='box box-info'> 

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

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

</div> 

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

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

'name'=>'demo'); 

echo form_open_multipart('reseller/tambah_produk', 

$attributes);  

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

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

<tbody> 

273 

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

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

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

\"showSub()\" required> 

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

foreach ($record as $row){ 

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

[nama_kategori]</option>"; 

} 

echo "</td></tr> 

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

<td><select name='aa' class='form-control' id='sub_ 

kategori_produk'> 

<option value='' selected>- Pilih Sub Kategori Produk -

</option> 

</td></tr> 

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

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

required></td></tr> 

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

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

</td></tr> 

<tr><th scope='row'>Berat / Gram</th>                       

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

'berat'></td></tr> 

<tr><th scope='row'>Harga Modal</th>                  

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

</td></tr> 

274 

<input type='hidden' class='form-control' name='e' value='0'> 

<tr><th scope='row'>Harga Jual</th>              

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

</td></tr> 

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

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

'diskon'></td></tr> 

<tr><th scope='row'>Stok Awal</th>                  

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

'stok'></td></tr> 

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

<td><textarea class='textarea form-control' name='ff' style= 

'height:180px'></textarea></td></tr> 

<tr><th scope='row'>Foto Produk</th>                      

<td><input type='file' id='fileupload' class='form-control' 

name='userfile[]' multiple>Multiple Upload, Allowed File : 

.gif, jpg, png 

<div id='dvPreview'></div> </td></tr> 

</tbody> 

</table> 

</div> 

</div> 

<div class='box-footer'> 

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

info'>Tambahkan</button> 

<a href='index.php'><button type='button' class='btn btn-

default pull-right'>Cancel</button></a> 

</div></div>"; 

275 

 

d. Buat Controller produk.php 

<?php 

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

allowed'); 

class Produk extends CI_Controller { 

 

function index(){ 

$jumlah= $this->model_app->view('rb_produk')-> num_rows 

(); 

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

$config['total_rows'] = $jumlah; 

$config['per_page'] = 24;   

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

$dari = 0; 

}else{ 

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

if (is_numeric($dari)) { 

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

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

post('kata'))."''"; 

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

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

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

b.nama_reseller, c.nama_kota FROM rb_produk a LEFT JOIN 

rb_reseller b ON a.id_reseller=b.id_reseller LEFT JOIN rb_kota 

c ON b.kota_id=c.kota_id where a.id_reseller!='0' AND 

a.id_produk_perusahaan='0' AND a.nama_produk LIKE 

276 

'%".cetak($this->input-> post('kata'))."%' ORDER BY 

a.id_produk DESC LIMIT $dari,$config[per_page]"); 

}else{ 

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

$data['judul'] = 'Semua Produk Kami'; 

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

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

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

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

b.nama_reseller, c.nama_kota FROM rb_produk a LEFT JOIN 

rb_reseller b ON a.id_reseller=b.id_reseller 

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

a.id_reseller!='0' AND a.id_produk_perusahaan='0' ORDER 

BY a.id_produk DESC LIMIT $dari,$config[per_page]"); 

} 

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

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

}else{ 

redirect('main'); } } 

 

function kategori(){ 

$cek = $this->model_app->edit('rb_kategori_produk', array 

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

$jumlah=$this->model_app->view_where 

('rb_produk',array('id_kategori_produk'=>$cek['id_kategori_p

roduk']))->num_rows(); 

$config['base_url'] = base_url().'produk/kategori/'. $this->uri-

>segment(3); 

$config['total_rows'] = $jumlah; 

277 

$config['per_page'] = 12;   

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

$dari = 0; 

}else{ 

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

} 

if (is_numeric($dari)) { 

$data['title'] = "Kategori - $cek[nama_kategori]"; 

$data['judul'] = "Kategori - $cek[nama_kategori]"; 

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

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

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

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

b.nama_reseller, c.nama_kota FROM rb_produk a LEFT JOIN 

rb_reseller b ON a.id_reseller=b.id_reseller 

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

a.id_reseller!='0' AND a.id_produk_perusahaan='0' AND 

a.id_kategori_produk='$cek[id_kategori_produk]' ORDER BY 

a.id_produk DESC LIMIT $dari,$config[per_page]"); 

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

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

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

}else{ 

redirect('main'); 

} 

} 

 

function subkategori(){ 

278 

$cek = $this->model_app->edit('rb_kategori_ produk_sub', 

array('kategori_seo_sub'=>$this->uri->segment(3)))-> 

row_array(); 

$jumlah=$this->model_app->view_where('rb_produk', 

array('id_kategori_produk_sub'=>$cek['id_kategori_produk_s

ub']))->num_rows(); 

$config['base_url'] = base_url().'produk/ subkategori/'.$this-

>uri->segment(3); 

$config['total_rows'] = $jumlah; 

$config['per_page'] = 12;   

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

$dari = 0; 

}else{ 

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

} 

if (is_numeric($dari)) { 

$data['title'] = "Subkategori - $cek[nama_kategori_ sub]"; 

$data['judul'] = "Subkategori - $cek[nama_kategori_ sub]"; 

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

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

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

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

b.nama_reseller, c.nama_kota FROM rb_produk a LEFT JOIN 

rb_reseller b ON a.id_reseller=b.id_reseller 

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

a.id_reseller!='0' AND a.id_produk_perusahaan='0' AND 

a.id_kategori_produk_sub='$cek[id_kategori_produk_sub]' 

279 

ORDER BY a.id_produk DESC LIMIT $dari,$config 

[per_page]"); 

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

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

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

}else{ 

redirect('main'); 

} 

} 

 

function reseller(){ 

$jumlah= $this->model_app->view('rb_reseller')-> num_rows 

(); 

$config['base_url'] = base_url().'produk/reseller'; 

$config['total_rows'] = $jumlah; 

$config['per_page'] = 18;   

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

$dari = 0; 

}else{ 

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

} 

if (is_numeric($dari)) { 

$data['title'] = 'Semua Daftar Pelapak'; 

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

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

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

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

$data['record'] = $this->model_reseller->cari_reseller(filter 

($this->input->post('cari_reseller'))); 

280 

}elseif (isset($_GET['cari_reseller'])){ 

$data['record'] = $this->model_reseller->cari_reseller(filter 

($this->input->get('cari_reseller'))); 

}else{ 

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

rb_reseller a LEFT JOIN rb_kota b ON a.kota_id =b.kota_id 

ORDER BY id_reseller DESC LIMIT $dari,$config 

[per_page]"); 

} 

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

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

}else{ 

redirect('main'); 

} 

} 

function detail_reseller(){ 

$data['title'] = 'Detail Profile Reseller'; 

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

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

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

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

('id_reseller'=>$id))->row_array(); 

$data['record'] = $this->model_reseller->penjualan_list_ 

konsumen($id,'reseller'); 

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

('rb_rekening_reseller', array('id_reseller'=>$id)); 

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

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

281 

} 

 

function produk_reseller(){ 

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

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

('id_reseller'=>$id))->num_rows(); 

$config['base_url'] = base_url().'produk/produk_reseller/' 

.$this->uri->segment('3'); 

$config['total_rows'] = $jumlah; 

$config['per_page'] = 18;   

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

$dari = 0; 

}else{ 

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

} 

if (is_numeric($dari)) { 

$data['title'] = 'Data Produk Reseller'; 

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

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

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

('id_reseller'=>$id))->row_array(); 

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

limit('rb_produk',array('id_reseller'=>$id), 

'id_produk','DESC',$dari,$config['per_page']); 

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

$this-