input->post('a'); $password = hash("sha512", md5($this->input->post('b'))); $cek = $this->db->query("SELECT * FROM rb_reseller where username='" . $this->db->escape_str($username) . "' AND password='" . $this->db->escape_str($password) . "'"); $row = $cek->row_array(); $total = $cek->num_rows(); if ($total > 0) { $this->session->set_userdata( array( 'id_reseller' => $row['id_reseller'], 'username' => $row['username'], 'level' => 'reseller' ) ); redirect('reseller/home'); } else { $data['title'] = 'Pelapak › Log In'; $this->load->view('reseller/view_login', $data); } } else { $data['title'] = 'Pelapak › Log In'; $this->load->view('reseller/view_login', $data); } } function ref() { if (isset($_POST['submit2'])) { $cek = $this->model_app->view_where('rb_reseller', array('username' => $this->input->post('a')))->num_rows(); if ($cek >= 1) { $username = $this->input->post('a'); echo ""; } else { $route = array('administrator', 'agenda', 'auth', 'berita', 'contact', 'download', 'gallery', 'konfirmasi', 'main', 'members', 'page', 'produk', 'reseller', 'testimoni', 'video'); if (in_array($this->input->post('a'), $route)) { $username = $this->input->post('a'); echo ""; } else { $data = array( 'username' => $this->input->post('a'), 'password' => hash("sha512", md5($this->input->post('b'))), 'nama_reseller' => $this->input->post('c'), 'jenis_kelamin' => $this->input->post('d'), 'alamat_lengkap' => $this->input->post('e'), 'no_telpon' => $this->input->post('f'), 'email' => $this->input->post('g'), 'kode_pos' => $this->input->post('h'), 'referral' => $this->input->post('i'), 'tanggal_daftar' => date('Y-m-d H:i:s') ); $this->model_app->insert('rb_reseller', $data); $id = $this->db->insert_id(); $this->session->set_userdata(array('id_reseller' => $id, 'level' => 'reseller')); $identitas = $this->model_app->view_where('identitas', array('id_identitas' => '1'))->row_array(); $ref = $this->model_app->view_where('rb_reseller', array('username' => $this->input->post('i')))->row_array(); $email_tujuan = $ref['email']; $tglaktif = date("d-m-Y H:i:s"); $subject = 'Pendaftaran Sebagai Reseller Berhasil...'; $message = "Selamat, Pada Hari ini tanggal $tglaktif
Bpk/Ibk " . $this->input->post('c') . " Sukses Mendafatar Sebagai reseller dengan referral " . $ref['nama_reseller'] . "..."; $message .= "

Berikut Informasi akun :
Nama Reseller	: " . $this->input->post('c') . "
Alamat Email	: " . $this->input->post('g') . "
No Telpon	: " . $this->input->post('f') . "
Jenis Kelamin	: " . $this->input->post('d') . "
Alamat Lengkap	: " . $this->input->post('e') . "
Kode Pos	: " . $this->input->post('h') . "
Waktu Daftar	: " . date('Y-m-d H:i:s') . "

Admin, $identitas[nama_website] \n"; $this->email->from($identitas['email'], $identitas['nama_website']); $this->email->to($email_tujuan, $this->input->post('g')); $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); redirect($this->uri->segment(1) . '/home'); } } } } function home() { $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/view_home'); } function edit_reseller() { if (isset($_POST['submit'])) { $config['upload_path'] = 'asset/foto_user/'; $config['allowed_types'] = 'gif|jpg|png|jpeg'; $config['max_size'] = '5000'; // kb $this->load->library('upload', $config); $this->upload->do_upload('gg'); $hasil = $this->upload->data(); if ($hasil['file_name'] == '') { if (trim($this->input->post('b')) != '') { $data = array( 'password' => hash("sha512", md5($this->input->post('b'))), 'nama_reseller' => $this->input->post('c'), 'jenis_kelamin' => $this->input->post('d'), 'alamat_lengkap' => $this->input->post('e'), 'no_telpon' => $this->input->post('f'), 'email' => $this->input->post('g'), 'kode_pos' => $this->input->post('h'), 'keterangan' => $this->input->post('i'), 'referral' => $this->input->post('j'), 'kota_id' => $this->input->post('kota') ); } else { $data = array( 'nama_reseller' => $this->input->post('c'), 'jenis_kelamin' => $this->input->post('d'), 'alamat_lengkap' => $this->input->post('e'), 'no_telpon' => $this->input->post('f'), 'email' => $this->input->post('g'), 'kode_pos' => $this->input->post('h'), 'keterangan' => $this->input->post('i'), 'referral' => $this->input->post('j'), 'kota_id' => $this->input->post('kota') ); } } else { if (trim($this->input->post('b')) != '') { $data = array( 'password' => hash("sha512", md5($this->input->post('b'))), 'nama_reseller' => $this->input->post('c'), 'jenis_kelamin' => $this->input->post('d'), 'alamat_lengkap' => $this->input->post('e'), 'no_telpon' => $this->input->post('f'), 'email' => $this->input->post('g'), 'kode_pos' => $this->input->post('h'), 'keterangan' => $this->input->post('i'), 'foto' => $hasil['file_name'], 'referral' => $this->input->post('j'), 'kota_id' => $this->input->post('kota') ); } else { $data = array( 'nama_reseller' => $this->input->post('c'), 'jenis_kelamin' => $this->input->post('d'), 'alamat_lengkap' => $this->input->post('e'), 'no_telpon' => $this->input->post('f'), 'email' => $this->input->post('g'), 'kode_pos' => $this->input->post('h'), 'keterangan' => $this->input->post('i'), 'foto' => $hasil['file_name'], 'referral' => $this->input->post('j'), 'kota_id' => $this->input->post('kota') ); } } $where = array('id_reseller' => $this->input->post('id')); $this->model_app->update('rb_reseller', $data, $where); redirect($this->uri->segment(1) . '/detail_reseller'); } else { $edit = $this->model_app->edit('rb_reseller', array('id_reseller' => $id))->row_array(); $data = array('rows' => $edit); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_reseller/view_reseller_edit', $data); } } function detail_reseller() { $edit = $this->model_app->edit('rb_reseller', array('id_reseller' => $id))->row_array(); $data = array('rows' => $edit); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_reseller/view_reseller_detail', $data); } // Controller Modul Produk function produk() { cek_session_reseller(); if (isset($_POST['submit'])) { $jml = $this->model_app->view('rb_produk')->num_rows(); for ($i = 1; $i <= $jml; $i++) { $a = $_POST['a'][$i]; $b = $_POST['b'][$i]; $cek = $this->model_app->edit('rb_produk_diskon', array('id_produk' => $a, 'id_reseller' => $this->session->id_reseller))->num_rows(); if ($cek >= 1) { if ($b > 0) { $data = array('diskon' => $b); $where = array('id_produk' => $a, 'id_reseller' => $this->session->id_reseller); $this->model_app->update('rb_produk_diskon', $data, $where); } else { $this->model_app->delete('rb_produk_diskon', array('id_produk' => $a, 'id_reseller' => $this->session->id_reseller)); } } else { if ($b > 0) { $data = array( 'id_produk' => $a, 'id_reseller' => $this->session->id_reseller, 'diskon' => $b ); $this->model_app->insert('rb_produk_diskon', $data); } } } redirect($this->uri->segment(1) . '/produk'); } else { $data['record'] = $this->model_app->view_where_ordering('rb_produk', array('id_reseller' => $this->session->id_reseller), 'id_produk', 'DESC'); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_produk/view_produk', $data); } } function tambah_produk() { cek_session_reseller(); 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'), 'id_reseller' => $this->session->id_reseller, '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, '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'), 'id_reseller' => $this->session->id_reseller, '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); $id_produk = $this->db->insert_id(); if ($this->input->post('diskon') > 0) { $cek = $this->db->query("SELECT * FROM rb_produk_diskon where id_produk='" . $id_produk . "' AND id_reseller='" . $this->session->id_reseller . "'"); if ($cek->num_rows() >= 1) { $data = array('diskon' => $this->input->post('diskon')); $where = array('id_produk' => $id_produk, 'id_reseller' => $this->session->id_reseller); $this->model_app->update('rb_produk_diskon', $data, $where); } else { $data = array( 'id_produk' => $id_produk, 'id_reseller' => $this->session->id_reseller, 'diskon' => $this->input->post('diskon') ); $this->model_app->insert('rb_produk_diskon', $data); } } if ($this->input->post('stok') != '') { $kode_transaksi = "TRX-" . date('YmdHis'); $data = array( 'kode_transaksi' => $kode_transaksi, 'id_pembeli' => $this->session->id_reseller, 'id_penjual' => '1', 'status_pembeli' => 'reseller', 'status_penjual' => 'admin', 'service' => 'Stok Otomatis (Pribadi)', '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' => $this->input->post('stok'), 'harga_jual' => $this->input->post('e'), 'satuan' => $this->input->post('c') ); $this->model_app->insert('rb_penjualan_detail', $data); } redirect('reseller/produk'); } else { $data['record'] = $this->model_app->view_ordering('rb_kategori_produk', 'id_kategori_produk', 'DESC'); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_produk/view_produk_tambah', $data); } } function edit_produk() { cek_session_reseller(); $id = $this->uri->segment(3); 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 ); } 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'), 'id_reseller' => $this->session->id_reseller); $this->model_app->update('rb_produk', $data, $where); if ($this->input->post('diskon') >= 0) { $cek = $this->db->query("SELECT * FROM rb_produk_diskon where id_produk='" . $this->input->post('id') . "' AND id_reseller='" . $this->session->id_reseller . "'"); if ($cek->num_rows() >= 1) { $data = array('diskon' => $this->input->post('diskon')); $where = array('id_produk' => $this->input->post('id'), 'id_reseller' => $this->session->id_reseller); $this->model_app->update('rb_produk_diskon', $data, $where); } else { $data = array( 'id_produk' => $this->input->post('id'), 'id_reseller' => $this->session->id_reseller, 'diskon' => $this->input->post('diskon') ); $this->model_app->insert('rb_produk_diskon', $data); } } if ($this->input->post('stok') != '') { $kode_transaksi = "TRX-" . date('YmdHis'); $data = array( 'kode_transaksi' => $kode_transaksi, 'id_pembeli' => $this->session->id_reseller, 'id_penjual' => '1', 'status_pembeli' => 'reseller', 'status_penjual' => 'admin', 'service' => 'Stok Otomatis (Pribadi)', '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' => $this->input->post('id'), 'jumlah' => $this->input->post('stok'), 'harga_jual' => $this->input->post('e'), 'satuan' => $this->input->post('c') ); $this->model_app->insert('rb_penjualan_detail', $data); } redirect('reseller/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, 'id_reseller' => $this->session->id_reseller))->row_array(); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_produk/view_produk_edit', $data); } } private function set_upload_options() { $config = array(); $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_reseller(); $id = array('id_produk' => $this->uri->segment(3)); $this->model_app->delete('rb_produk', $id); redirect('reseller/produk'); } // Controller Modul Rekening function rekening() { cek_session_reseller(); $data['record'] = $this->model_app->view_where('rb_rekening_reseller', array('id_reseller' => $this->session->id_reseller)); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_rekening/view_rekening', $data); } function tambah_rekening() { cek_session_reseller(); if (isset($_POST['submit'])) { $data = array( 'id_reseller' => $this->session->id_reseller, 'nama_bank' => $this->input->post('a'), 'no_rekening' => $this->input->post('b'), 'pemilik_rekening' => $this->input->post('c') ); $this->model_app->insert('rb_rekening_reseller', $data); redirect($this->uri->segment(1) . '/rekening'); } else { $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_rekening/view_rekening_tambah'); } } function edit_rekening() { cek_session_reseller(); $id = $this->uri->segment(3); if (isset($_POST['submit'])) { $data = array( 'id_reseller' => $this->session->id_reseller, 'nama_bank' => $this->input->post('a'), 'no_rekening' => $this->input->post('b'), 'pemilik_rekening' => $this->input->post('c') ); $where = array('id_rekening_reseller' => $this->input->post('id'), 'id_reseller' => $this->session->id_reseller); $this->model_app->update('rb_rekening_reseller', $data, $where); redirect($this->uri->segment(1) . '/rekening'); } else { $data['rows'] = $this->model_app->edit('rb_rekening_reseller', array('id_rekening_reseller' => $id))->row_array(); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_rekening/view_rekening_edit', $data); } } function delete_rekening() { cek_session_reseller(); $id = array('id_rekening_reseller' => $this->uri->segment(3)); $this->model_app->delete('rb_rekening_reseller', $id); redirect($this->uri->segment(1) . '/rekening'); } // Controller Modul Pembelian function pembelian() { cek_session_reseller(); $this->session->unset_userdata('idp'); $data['record'] = $this->model_reseller->reseller_pembelian($this->session->id_reseller, 'admin'); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_pembelian/view_pembelian', $data); } function detail_pembelian() { cek_session_reseller(); $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($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_pembelian/view_pembelian_detail', $data); } function tambah_pembelian() { cek_session_reseller(); if (isset($_POST['submit'])) { if ($this->session->idp == '') { $kode_transaksi = "TRX-" . date('YmdHis'); $data = array( 'kode_transaksi' => $kode_transaksi, 'id_pembeli' => $this->session->id_reseller, 'id_penjual' => '1', '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)); } if ($this->input->post('idpd') == '') { $data = array( 'id_penjualan' => $this->session->idp, 'id_produk' => $this->input->post('aa'), 'jumlah' => $this->input->post('dd'), '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'), '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($this->uri->segment(1) . '/tambah_pembelian'); } 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_where_ordering('rb_produk', array('id_reseller' => '0'), 'id_produk', 'ASC'); $data['reseller'] = $this->model_app->view_ordering('rb_reseller', 'id_reseller', 'ASC'); if ($this->uri->segment(3) != '') { $data['row'] = $this->model_app->view_where('rb_penjualan_detail', array('id_penjualan_detail' => $this->uri->segment(3)))->row_array(); } $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_pembelian/view_pembelian_tambah', $data); } } function delete_pembelian() { cek_session_reseller(); $id = array('id_penjualan' => $this->uri->segment(3)); $this->model_app->delete('rb_penjualan', $id); $this->model_app->delete('rb_penjualan_detail', $id); redirect($this->uri->segment(1) . '/pembelian'); } function delete_pembelian_tambah_detail() { cek_session_reseller(); $id = array('id_penjualan_detail' => $this->uri->segment(3)); $this->model_app->delete('rb_penjualan_detail', $id); redirect($this->uri->segment(1) . '/tambah_pembelian'); } function konfirmasi_pembayaran() { cek_session_reseller(); $id = $this->uri->segment(3); 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', $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', $data); } $data1 = array('proses' => '2'); $where = array('id_penjualan' => $this->input->post('id')); $this->model_app->update('rb_penjualan', $data1, $where); redirect($this->uri->segment(1) . '/pembelian'); } else { $data['record'] = $this->model_app->view('rb_rekening'); $data['total'] = $this->db->query("SELECT sum((a.harga_jual*a.jumlah)-a.diskon) as total FROM `rb_penjualan_detail` a where a.id_penjualan='" . $this->uri->segment(3) . "'")->row_array(); $data['rows'] = $this->model_app->view_where('rb_penjualan', array('id_penjualan' => $this->uri->segment(3)))->row_array(); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_pembelian/view_konfirmasi_pembayaran', $data); } } function keterangan() { cek_session_reseller(); if (isset($_POST['submit'])) { $cek = $this->model_app->view_where('rb_keterangan', array('id_reseller' => $this->session->id_reseller))->num_rows(); if ($cek >= 1) { $data1 = array('keterangan' => $this->input->post('a')); $where = array('id_keterangan' => $this->input->post('id'), 'id_reseller' => $this->session->id_reseller); $this->model_app->update('rb_keterangan', $data1, $where); } else { $data = array( 'id_reseller' => $this->session->id_reseller, 'keterangan' => $this->input->post('a'), 'tanggal_posting' => date('Y-m-d H:i:s') ); $this->model_app->insert('rb_keterangan', $data); } redirect($this->uri->segment(1) . '/keterangan'); } else { $data['record'] = $this->model_app->edit('rb_keterangan', array('id_reseller' => $this->session->id_reseller))->row_array(); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_keterangan/view_keterangan', $data); } } function penjualan() { cek_session_reseller(); $this->session->unset_userdata('idp'); $id = $this->session->id_reseller; $data['record'] = $this->model_reseller->penjualan_list_konsumen($id, 'reseller'); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_penjualan/view_penjualan', $data); } function detail_penjualan() { cek_session_reseller(); $data['rows'] = $this->model_reseller->penjualan_konsumen_detail_reseller($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($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_penjualan/view_penjualan_detail', $data); } function tambah_penjualan() { cek_session_reseller(); if (isset($_POST['submit1'])) { if ($this->session->idp == '') { $data = array( 'kode_transaksi' => $this->input->post('a'), 'id_pembeli' => $this->input->post('b'), 'id_penjual' => $this->session->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)); } 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($this->uri->segment(1) . '/tambah_penjualan'); } elseif (isset($_POST['submit'])) { $jual = $this->model_reseller->jual_reseller($this->session->id_reseller, $this->input->post('aa'))->row_array(); $beli = $this->model_reseller->beli_reseller($this->session->id_reseller, $this->input->post('aa'))->row_array(); $stok = $beli['beli'] - $jual['jual']; if ($this->input->post('dd') > $stok) { echo ""; } else { if ($this->input->post('idpd') == '') { $data = array( 'id_penjualan' => $this->session->idp, 'id_produk' => $this->input->post('aa'), 'jumlah' => $this->input->post('dd'), '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'), '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($this->uri->segment(1) . '/tambah_penjualan'); } } else { $data['rows'] = $this->model_reseller->penjualan_konsumen_detail_reseller($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['konsumen'] = $this->model_app->view_ordering('rb_konsumen', 'id_konsumen', 'ASC'); if ($this->uri->segment(3) != '') { $data['row'] = $this->model_app->view_where('rb_penjualan_detail', array('id_penjualan_detail' => $this->uri->segment(3)))->row_array(); } $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_penjualan/view_penjualan_tambah', $data); } } function edit_penjualan() { cek_session_reseller(); 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($this->uri->segment(1) . '/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_reseller($this->session->id_reseller, $this->input->post('aa'))->row_array(); $beli = $this->model_reseller->beli_reseller($this->session->id_reseller, $this->input->post('aa'))->row_array(); $stok = $beli['beli'] - $jual['jual'] + $cekk['jumlah']; if ($this->input->post('dd') > $stok) { echo ""; } 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'), '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'), '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($this->uri->segment(1) . '/edit_penjualan/' . $this->input->post('idp')); } } else { $data['rows'] = $this->model_reseller->penjualan_konsumen_detail_reseller($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['konsumen'] = $this->model_app->view_ordering('rb_konsumen', 'id_konsumen', '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($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_penjualan/view_penjualan_edit', $data); } } function proses_penjualan() { cek_session_reseller(); $data = array('proses' => $this->uri->segment(4)); $where = array('id_penjualan' => $this->uri->segment(3)); $this->model_app->update('rb_penjualan', $data, $where); redirect($this->uri->segment(1) . '/penjualan'); } function proses_penjualan_detail() { cek_session_reseller(); $data = array('proses' => $this->uri->segment(4)); $where = array('id_penjualan' => $this->uri->segment(3)); $this->model_app->update('rb_penjualan', $data, $where); redirect($this->uri->segment(1) . '/detail_penjualan/' . $this->uri->segment(3)); } function delete_penjualan() { cek_session_reseller(); $id = array('id_penjualan' => $this->uri->segment(3)); $this->model_app->delete('rb_penjualan', $id); $this->model_app->delete('rb_penjualan_detail', $id); redirect($this->uri->segment(1) . '/penjualan'); } function delete_penjualan_detail() { cek_session_reseller(); $id = array('id_penjualan_detail' => $this->uri->segment(4)); $this->model_app->delete('rb_penjualan_detail', $id); redirect($this->uri->segment(1) . '/edit_penjualan/' . $this->uri->segment(3)); } function delete_penjualan_tambah_detail() { cek_session_reseller(); $id = array('id_penjualan_detail' => $this->uri->segment(3)); $this->model_app->delete('rb_penjualan_detail', $id); redirect($this->uri->segment(1) . '/tambah_penjualan'); } function detail_konsumen() { cek_session_reseller(); $id = $this->uri->segment(3); $edit = $this->model_app->edit('rb_konsumen', array('id_konsumen' => $id))->row_array(); $data = array('rows' => $edit); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_konsumen/view_konsumen_detail', $data); } function pembayaran_konsumen() { cek_session_reseller(); $data['record'] = $this->db->query("SELECT * FROM `rb_konfirmasi_pembayaran_konsumen` WHERE id_rekening IN (SELECT id_rekening_reseller FROM rb_rekening_reseller WHERE id_reseller='" . $this->session->id_reseller . "')"); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_konsumen/view_konsumen_pembayaran', $data); } function download() { $name = $this->uri->segment(3); $data = file_get_contents("asset/files/" . $name); force_download($name, $data); } function keuangan() { $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($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_reseller/view_reseller_keuangan', $data); } // Controller Modul COD function alamat_cod() { cek_session_reseller(); $data['record'] = $this->model_app->view_where('rb_reseller_cod', array('id_reseller' => $this->session->id_reseller)); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_alamat_cod/view', $data); } function tambah_cod() { cek_session_reseller(); if (isset($_POST['submit'])) { $data = array( 'id_reseller' => $this->session->id_reseller, 'nama_alamat' => $this->input->post('a'), 'biaya_cod' => $this->input->post('b') ); $this->model_app->insert('rb_reseller_cod', $data); redirect($this->uri->segment(1) . '/alamat_cod'); } else { $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_alamat_cod/tambah'); } } function edit_cod() { cek_session_reseller(); $id = $this->uri->segment(3); if (isset($_POST['submit'])) { $data = array( 'id_reseller' => $this->session->id_reseller, 'nama_alamat' => $this->input->post('a'), 'biaya_cod' => $this->input->post('b') ); $where = array('id_cod' => $this->input->post('id'), 'id_reseller' => $this->session->id_reseller); $this->model_app->update('rb_reseller_cod', $data, $where); redirect($this->uri->segment(1) . '/alamat_cod'); } else { $data['rows'] = $this->model_app->edit('rb_reseller_cod', array('id_cod' => $id))->row_array(); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_alamat_cod/edit', $data); } } function delete_cod() { cek_session_reseller(); $id = array('id_cod' => $this->uri->segment(3)); $this->model_app->delete('rb_reseller_cod', $id); redirect($this->uri->segment(1) . '/alamat_cod'); } function logout() { $this->session->sess_destroy(); redirect('main'); } function logowebsite() { if (isset($_POST['submit'])) { $config['upload_path'] = 'asset/logo/'; $config['allowed_types'] = 'gif|jpg|png|JPG'; $config['max_size'] = '2000'; // kb $this->load->library('upload', $config); $this->upload->do_upload('logo'); $hasil = $this->upload->data(); $datadb = array('gambar' => $hasil['file_name']); $where = array('id_logo' => $this->input->post('id')); $this->model_app->update('logo', $datadb, $where); redirect($this->uri->segment(1) . '/logowebsite'); } else { $data['record'] = $this->model_app->view('logo'); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_logowebsite/view_logowebsite', $data); } } // Controller Modul Template Website function templatewebsite() { $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_template/view_template', $data); } function tambah_templatewebsite() { if (isset($_POST['submit'])) { $data = array( 'judul' => $this->db->escape_str($this->input->post('a')), 'username' => $this->session->username, 'pembuat' => $this->input->post('b'), 'folder' => $this->input->post('c') ); $this->model_app->insert('templates', $data); redirect($this->uri->segment(1) . '/templatewebsite'); } else { $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_template/view_template_tambah', $data); } } function edit_templatewebsite() { $id = $this->uri->segment(3); if (isset($_POST['submit'])) { $data = array( 'judul' => $this->db->escape_str($this->input->post('a')), 'username' => $this->session->username, 'pembuat' => $this->input->post('b'), 'folder' => $this->input->post('c') ); $where = array('id_templates' => $this->input->post('id')); $this->model_app->update('templates', $data, $where); redirect($this->uri->segment(1) . '/templatewebsite'); } else { if ($this->session->level == 'admin') { $proses = $this->model_app->edit('templates', array('id_templates' => $id))->row_array(); } else { $proses = $this->model_app->edit('templates', array('id_templates' => $id, 'username' => $this->session->username))->row_array(); } $data = array('rows' => $proses); // $this->template->load('/template','/mod_template/view_template_edit',$data); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_template/view_template_edit', $data); } } function aktif_templatewebsite() { $id = $this->uri->segment(3); if ($this->uri->segment(4) == 'Y') { $aktif = 'N'; } else { $aktif = 'Y'; } $data = array('aktif' => $aktif); $where = array('id_templates' => $id); $this->model_app->update('templates', $data, $where); $dataa = array('aktif' => 'N'); $wheree = array('id_templates !=' => $id); $this->model_app->update('templates', $dataa, $wheree); redirect($this->uri->segment(1) . '/templatewebsite'); } function delete_templatewebsite() { if ($this->session->level == 'admin') { $id = array('id_templates' => $this->uri->segment(3)); } else { $id = array('id_templates' => $this->uri->segment(3), 'username' => $this->session->username); } $this->model_app->delete('templates', $id); redirect($this->uri->segment(1) . '/templatewebsite'); } function background() { $id = $this->uri->segment(3); if (isset($_POST['submit'])) { $data = array('gambar' => $this->input->post('a')); $where = array('id_background' => 1); $this->model_app->update('background', $data, $where); redirect($this->uri->segment(1) . '/background'); } else { $proses = $this->model_app->edit('background', array('id_background' => 1))->row_array(); $data = array('rows' => $proses); // $this->template->load('/template','/mod_background/view_background',$data); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_background/view_background', $data); } } function manajemenuser() { $data['record'] = $this->model_app->view_ordering('users', 'username', 'DESC'); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_users/view_users', $data); } function tambah_manajemenuser() { $id = $this->session->username; if (isset($_POST['submit'])) { $config['upload_path'] = 'asset/foto_user/'; $config['allowed_types'] = 'gif|jpg|png|JPG|JPEG'; $config['max_size'] = '1000'; // kb $this->load->library('upload', $config); $this->upload->do_upload('f'); $hasil = $this->upload->data(); if ($hasil['file_name'] == '') { $data = array( 'username' => $this->db->escape_str($this->input->post('a')), 'password' => hash("sha512", md5($this->input->post('b'))), 'nama_lengkap' => $this->db->escape_str($this->input->post('c')), 'email' => $this->db->escape_str($this->input->post('d')), 'no_telp' => $this->db->escape_str($this->input->post('e')), 'level' => $this->db->escape_str($this->input->post('g')), 'blokir' => 'N', 'id_session' => md5($this->input->post('a')) . '-' . date('YmdHis') ); } else { $data = array( 'username' => $this->db->escape_str($this->input->post('a')), 'password' => hash("sha512", md5($this->input->post('b'))), 'nama_lengkap' => $this->db->escape_str($this->input->post('c')), 'email' => $this->db->escape_str($this->input->post('d')), 'no_telp' => $this->db->escape_str($this->input->post('e')), 'foto' => $hasil['file_name'], 'level' => $this->db->escape_str($this->input->post('g')), 'blokir' => 'N', 'id_session' => md5($this->input->post('a')) . '-' . date('YmdHis') ); } $this->model_app->insert('users', $data); $mod = count($this->input->post('modul')); $modul = $this->input->post('modul'); $sess = md5($this->input->post('a')) . '-' . date('YmdHis'); for ($i = 0; $i < $mod; $i++) { $datam = array( 'id_session' => $sess, 'id_modul' => $modul[$i] ); $this->model_app->insert('users_modul', $datam); } redirect($this->uri->segment(1) . '/edit_manajemenuser/' . $this->input->post('a')); } else { $proses = $this->model_app->view_where_ordering('modul', array('publish' => 'Y', 'status' => 'user'), 'id_modul', 'DESC'); $data = array('record' => $proses); // $this->template->load('administrator/template','administrator/mod_users/view_users_tambah',$data); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_users/view_users_tambah', $data); } } function edit_manajemenuser() { if (isset($_POST['submit'])) { $config['upload_path'] = 'asset/foto_user/'; $config['allowed_types'] = 'gif|jpg|png|JPG|JPEG'; $config['max_size'] = '1000'; // kb $this->load->library('upload', $config); $this->upload->do_upload('f'); $hasil = $this->upload->data(); if ($hasil['file_name'] == '' and $this->input->post('b') == '') { $data = array( 'username' => $this->db->escape_str($this->input->post('a')), 'nama_lengkap' => $this->db->escape_str($this->input->post('c')), 'email' => $this->db->escape_str($this->input->post('d')), 'no_telp' => $this->db->escape_str($this->input->post('e')), 'blokir' => $this->db->escape_str($this->input->post('h')) ); } elseif ($hasil['file_name'] != '' and $this->input->post('b') == '') { $data = array( 'username' => $this->db->escape_str($this->input->post('a')), 'nama_lengkap' => $this->db->escape_str($this->input->post('c')), 'email' => $this->db->escape_str($this->input->post('d')), 'no_telp' => $this->db->escape_str($this->input->post('e')), 'foto' => $hasil['file_name'], 'blokir' => $this->db->escape_str($this->input->post('h')) ); } elseif ($hasil['file_name'] == '' and $this->input->post('b') != '') { $data = array( 'username' => $this->db->escape_str($this->input->post('a')), 'password' => hash("sha512", md5($this->input->post('b'))), 'nama_lengkap' => $this->db->escape_str($this->input->post('c')), 'email' => $this->db->escape_str($this->input->post('d')), 'no_telp' => $this->db->escape_str($this->input->post('e')), 'blokir' => $this->db->escape_str($this->input->post('h')) ); } elseif ($hasil['file_name'] != '' and $this->input->post('b') != '') { $data = array( 'username' => $this->db->escape_str($this->input->post('a')), 'password' => hash("sha512", md5($this->input->post('b'))), 'nama_lengkap' => $this->db->escape_str($this->input->post('c')), 'email' => $this->db->escape_str($this->input->post('d')), 'no_telp' => $this->db->escape_str($this->input->post('e')), 'foto' => $hasil['file_name'], 'blokir' => $this->db->escape_str($this->input->post('h')) ); } $where = array('username' => $this->input->post('id')); $this->model_app->update('users', $data, $where); $modul_post = $this->input->post('modul'); if (!empty($modul_post) && is_array($modul_post)) { $mod = count($modul_post); $modul = $modul_post; for ($i = 0; $i < $mod; $i++) { $datam = array( 'id_session' => $this->input->post('ids'), 'id_modul' => $modul[$i] ); $this->model_app->insert('users_modul', $datam); } } redirect($this->uri->segment(1) . '/edit_manajemenuser/' . $this->input->post('id')); } else { if ($this->session->username) { $proses = $this->model_app->edit('users', array('username' => $id))->row_array(); $akses = $this->model_app->view_join_where('users_modul', 'modul', 'id_modul', array('id_session' => $proses['id_session']), 'id_umod', 'DESC'); $modul = $this->model_app->view_where_ordering('modul', array('publish' => 'Y', 'status' => 'user'), 'id_modul', 'DESC'); $data = array('rows' => $proses, 'record' => $modul, 'akses' => $akses); $this->template->load($this->uri->segment(1) . '/template', $this->uri->segment(1) . '/mod_users/view_users_edit', $data); // $this->template->load('administrator/template','administrator/mod_users/view_users_edit',$data); } else { redirect($this->uri->segment(1) . '/edit_manajemenuser/' . $this->session->username); } } } function delete_manajemenuser() { $id = array('username' => $this->uri->segment(3)); $this->model_app->delete('users', $id); redirect($this->uri->segment(1) . '/manajemenuser'); } function delete_akses() { $id = array('id_umod' => $this->uri->segment(3)); $this->model_app->delete('users_modul', $id); redirect($this->uri->segment(1) . '/edit_manajemenuser/' . $this->uri->segment(4)); } function pesanan_selesai() { $kode_transaksi = $this->input->get('kode'); if ($kode_transaksi) { $data = array('proses' => '3'); $where = $this->db->where('kode_transaksi', $kode_transaksi); $this->model_app->update('rb_penjualan', $data, $where); redirect($this->uri->segment(1) . '/pembelian'); } } }