So i make a web apps which will approve the order list, and so make the sales, the user can add or remove the product from the list before approve/confirm it
the user must select the product brand, and fill input such quantity, disount, prices, and soon, the input show up after user select the brand
so the flow is -webapps load data from database -webapps show order list to user -user add/remove the product into/from the list (optional) -user fill the input which show up after select the brand -user confirm it -data submitter to server and so to the database
the problem is when i tried to confirm the list, the value not submitted to the server, i didnt know whether the cause is because the input form created in table tag, or the form created dynamically,
i use Code Igniter
please help me
this is my controller
function confirm($id){
$cek = $this->session->userdata('logged_in');
$dt['title']='Pasti Jaya Motor | Confirm Orderan';
$id_confirm['kd_order'] = $id;
$data['kd_order'] = $id;
$data['data_barang_kategori'] = $this->app_model->getAllData('tbl_tipe_kategori')->result();
$data['kd_penjualan'] = $this->app_model->getMaxKodePenjualan();
$data['data_order'] = $this->app_model->getSelectedData("tbl_order", $id_confirm)->result();
$data['data_order_confirm'] = $this->app_model->manualQuery("select a.id_tipe_kategori, a.qty, b.kategori, b.type from tbl_order_detail a left join tbl_tipe_kategori b
on a.id_tipe_kategori=b.id_tipe_kategori where a.kd_order='".$id_confirm['kd_order']."'")->result();
$data['data_barang'] = $this->app_model->getAllData('tbl_barang')->result();
foreach ($data['data_order'] as $key => $value) {
$data['kd_order'] = $value->kd_order;
$data['kd_sales'] = $value->kd_sales;
$data['nama_sales'] = $this->app_model->getNamaSales($value->kd_sales);
$data['nama_pelanggan'] = $value->nama_pelanggan;
$data['potongan'] = $value->potongan;
$data['alamat'] = $value->alamat;
$data['tgl_order'] = $value->tgl_order;
}
if (!empty($cek)) {
$this->form_validation->set_error_delimiters('<div class="text-red"> <i class="fa fa-ban"></i> ', ' </div>');
$this->form_validation->set_rules('nama_pelanggan', 'Nama Pelanggan', 'required');
if ($this->form_validation->run()) {
$cek_qty_array = $this->input->post('qty_dikirim');
$cek_qty = 0;
if ($cek_qty > 0) {
$id_cek['kd_penjualan'] = $this->input->post('kd_penjualan');
$cek_kd_penjualan = $data['data_penjualan'] = $this->app_model->getSelectedData("tbl_penjualan", $id_cek)->result();
$kd_penjualan = '';
if (count($cek_kd_penjualan > 0)) {
$kd_penjualan = $this->app_model->getMaxKodePenjualan();
}else{
$kd_penjualan = $this->input->post('kd_penjualan');
}
$confirm['kd_penjualan'] = $kd_penjualan;
$confirm['kd_order'] = $this->input->post('kd_order');
$confirm['nama_pelanggan'] = $this->input->post('nama_pelanggan');
$confirm['kd_user'] = $this->input->post('kd_user');
$confirm['total_harga'] = $this->input->post('total');
$confirm['alamat'] = $this->input->post('alamat');
$confirm['tgl_penjualan'] = strtotime(date('Y-m-d H:i:s'));
$confirm['jenis'] = 'Order';
$status['status'] = 'Confirm';
$result = $this->app_model->insertData('tbl_penjualan', $confirm);
$result2 = $this->app_model->updateData('tbl_order', $status, $id_confirm);
$result3 = 0;
$kd_barang = $this->input->post('kd_barang');
$qty_dikirim = $this->input->post('qty_dikirim');
$potongan = $this->input->post('potongan');
$harga_potongan= $this->input->post('harga_potongan');
$dus = $this->input->post('dus');
for ($i=0; $i < count($kd_barang); $i++) {
if ($qty_dikirim[$i] > 0) {
$confirm_detail['kd_penjualan'] = $kd_penjualan;
$confirm_detail['kd_barang'] = $kd_barang[$i];
$confirm_detail['qty'] = $qty_dikirim[$i];
$confirm_detail['harga_tersimpan'] = $harga_potongan[$i];
$confirm_detail['potongan'] = $potongan[$i];
$confirm_detail['dus'] = $dus[$i];
$result3 = $this->app_model->insertData("tbl_penjualan_detail", $confirm_detail);
$stok['stok'] = $this->app_model->getBalancedStok($confirm_detail['kd_barang'], $confirm_detail['qty']);
$key = $confirm_detail['kd_barang'];
$this->app_model->updateStok($stok, $key);
}
}
if ($result && $result2 && $result3) {
$pesan = 'Confirm Orderan Sukses';
$this->session->set_flashdata('pesan', $pesan);
redirect(base_url('orderan'));
}else{
$data['pesan'] = 'Confirm Orderan Gagal';
$this->load->view('elements/header', $dt);
$this->load->view('orderan/confirm', $data);
$this->load->view('elements/footer');
}
}else{
$pesan = 'Tidak Ada Barang Yang di Confirm';
$this->session->set_flashdata('pesan', $pesan);
redirect(base_url('orderan'));
}
}else{
$this->load->view('elements/header', $dt);
$this->load->view('orderan/confirm', $data);
$this->load->view('elements/footer');
}
}else{
redirect(base_url('login'));
}
}
this is my view
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
Master Orderan
<small>Confirm Orderan</small>
</h1>
<ol class="breadcrumb">
<li><a href="<?php echo base_url('dashboard')?>"><i class="fa fa-home"></i> Home</a></li>
<li class="active"><a href="<?php echo base_url('orderan')?>">Orderan</a></li>
<li class="active"><a href="<?php echo base_url('orderan/confirm/'.$kd_order)?>">Confirm Orderan</a></li>
</ol>
</section>
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-md-12">
<div class="box">
<div class="box-header">
<div class="box-button">
<div class="row">
<div class="col-md-12">
<a href="<?php echo base_url('orderan');?>" class="btn btn-default flat"><i class="fa fa-list fa-fw"></i> List</a>
</div>
</div>
<div class="cleaner_h3"></div>
</div>
</div><!-- /.box-header -->
<hr>
<div class="box-body table-responsive">
<div class="cleaner_h3"></div>
<div class="row">
<div class="col-md-12">
<?php
if(isset($pesan)){
echo '<div class="alert alert-info alert-dismissable"><i class="fa fa-info"></i><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button> '.$this->session->flashdata('pesan').'</div>';
};
?>
</div>
</div>
<div class="cleaner_h3"></div>
<div class="box-button">
<div class="row">
<div class="col-md-12">
<h4>Header Penjualan</h4>
</div>
</div>
<div class="cleaner_h3"></div>
</div>
<form class="form-horizontal" method="post" name="form-confirm" role="form" enctype="multipart/form-data" action="<?php echo base_url('orderan/confirm/'.$kd_order) ?>">
<div class="row">
<div class="col-md-5">
<?php
if (form_error('kd_penjualan')) {
echo '<div class="form-group has-error">';
}else{
echo '<div class="form-group">';
}
?>
<label for="kd_penjualan" class="col-md-6 control-label">Kode Penjualan</label>
<div class="col-md-6">
<input type="text" class="form-control flat" id="kd_penjualan" name="kd_penjualan" value='<?php echo $kd_penjualan; ?>' readonly>
</div>
<div class="col-md-4"><?php echo form_error('kd_penjualan'); ?></div>
</div>
<?php
if (form_error('kd_order')) {
echo '<div class="form-group has-error">';
}else{
echo '<div class="form-group">';
}
?>
<label for="kd_order" class="col-md-6 control-label">Kode Orderan</label>
<div class="col-md-6">
<input type="text" class="form-control flat" id="kd_order" name="kd_order" value='<?php echo $kd_order; ?>' readonly>
</div>
<div class="col-md-4"><?php echo form_error('kd_order'); ?></div>
</div>
<?php
if (form_error('tgl_order')) {
echo '<div class="form-group has-error">';
}else{
echo '<div class="form-group">';
}
?>
<label for="tgl_order" class="col-md-6 control-label pull-left">Tanggal Orderan</label>
<div class="col-md-6">
<input type="text" class="form-control flat" id="tgl_order" name="tgl_order" value='<?php echo gmdate('d/m/Y - H:i:s', $tgl_order); ?>' readonly>
</div>
<div class="col-md-4"><?php echo form_error('tgl_order'); ?></div>
</div>
<?php
if (form_error('potongan')) {
echo '<div class="form-group has-error">';
}else{
echo '<div class="form-group">';
}
?>
<label for="potongan" class="col-md-6 control-label pull-left">Potongan</label>
<div class="col-md-3">
<input type="text" class="form-control flat" id="potongan" name="potongan" value='<?php echo $potongan; ?>' readonly>
</div>
<div class="col-md-4"><?php echo form_error('potongan'); ?></div>
</div>
</div>
<div class="col-md-6">
<?php
if (form_error('nama_pelanggan')) {
echo '<div class="form-group has-error">';
}else{
echo '<div class="form-group">';
}
?>
<label for="nama_pelanggan" class="col-md-4 control-label">Nama Pelanggan</label>
<div class="col-md-8">
<input type="text" class="form-control flat" id="nama_pelanggan" name="nama_pelanggan" value='<?php echo $nama_pelanggan; ?>' readonly>
</div>
<div class="col-md-4"><?php echo form_error('nama_pelanggan'); ?></div>
</div>
<?php
if (form_error('alamat')) {
echo '<div class="form-group has-error">';
}else{
echo '<div class="form-group">';
}
?>
<label for="alamat" class="col-md-4 control-label">Alamat</label>
<div class="col-md-8">
<input type="text" class="form-control flat" id="alamat" name="alamat" value='<?php echo $alamat; ?>' readonly>
</div>
<div class="col-md-4"><?php echo form_error('alamat'); ?></div>
</div>
<?php
if (form_error('kd_sales')) {
echo '<div class="form-group has-error">';
}else{
echo '<div class="form-group">';
}
?>
<label for="kd_sales" class="col-md-4 control-label pull-left">Kode Sales</label>
<div class="col-md-4">
<input type="text" class="form-control flat" id="kd_sales" name="kd_sales" value='<?php echo $kd_sales; ?>' readonly>
</div>
<div class="col-md-4">
<input type="text" class="form-control flat" id="nama_sales" name="nama_sales" value='<?php echo $nama_sales; ?>' readonly>
</div>
<div class="col-md-4"><?php echo form_error('kd_sales'); ?></div>
</div>
<?php
if (form_error('kd_user')) {
echo '<div class="form-group has-error">';
}else{
echo '<div class="form-group">';
}
?>
<label for="kd_user" class="col-md-4 control-label pull-left">Kode User</label>
<div class="col-md-4">
<input type="text" class="form-control flat" id="kd_user" name="kd_user" value='<?php echo $this->session->userdata('kd_user'); ?>' readonly>
</div>
<div class="col-md-4">
<input type="text" class="form-control flat" id="nama" name="nama" value='<?php echo $this->session->userdata('nama'); ?>' readonly>
</div>
<div class="col-md-4"><?php echo form_error('kd_user'); ?></div>
</div>
</div>
</div>
</div>
<hr>
<div class="box-button">
<div class="row">
<div class="col-md-12">
<h4>Detail Orderan</h4>
</div>
</div>
<div class="cleaner_h3"></div>
</div>
<div class="row">
<div class="col-md-4">
<div class="box-body table-responsive">
<div class="cleaner_h3"></div>
<table class="table table-bordered table-striped">
<thead>
<tr>
<th>Nama Barang</th>
<th style="width:90px;">Orderan</th>
</tr>
</thead>
<tbody>
<?php
foreach ($data_order_confirm as $key => $value) {
?>
<tr>
<td><?php echo $value->kategori.' '.$value->type; ?></td>
<td><?php echo $value->qty; ?></td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
</tfoot>
</table>
</div>
</div>
</div>
<div class="box-button">
<div class="row">
<div class="col-md-12">
<h4>Detail Penjualan</h4>
</div>
</div>
<div class="cleaner_h3"></div>
</div>
<div class="row>"
<div class="col-md-12">
<div class="box-body table-responsive detail-penjualan">
<div class="cleaner_h3"></div>
<table class="table table-bordered table-striped">
<thead>
<tr>
<th style="width:14%;">Nama Barang</th>
<th style="width:14%;">Brand</th>
<th style="width:11%;">Kode Barang</th>
<th style="width:9%;">Qty</th>
<th style="width:9%;">Harga</th>
<th style="width:7%;">Potongan</th>
<th style="width:9%;">Hrg * Pot</th>
<th style="width:11%;">SubTotal</th>
<th style="width:8%;">Dus</th>
<th style="text-align:center; width:10%;" class="action"><a href="#modalAddPenjualanBarang" data-toggle="modal" class="btn btn-default flat"><i class="fa fa-plus fa-fw"></i> Add Barang</a></th>
</thead>
<tbody class="barang-confirm">
<?php
foreach ($data_order_confirm as $key => $value) {
?>
<tr class="gradeX">
<td class="nama-barang-col"><?php echo $value->kategori.' '.$value->type; ?></td>
<td class="brand-col">
<select class="form-control flat brand" id="brand" name="brand[]">
<option value="none">--- SELECT ---</option>
<?php
foreach($data_barang as $key2 => $value_2) {
if ($value->id_tipe_kategori == $value_2->id_tipe_kategori) {
echo "<option value='".$value_2->kd_barang."'>".$value_2->brand."</option>";
}
}
?>
</select>
</td>
<td class="kd-barang-col"> - </td>
<td class="qty-col"> - </td>
<td class="harga-col"> - </td>
<td class="potongan-col"> - </td>
<td class="harga-potongan-col"> - </td>
<td class="subtotal-col"> - </td>
<td class="dus-col"> - </td>
<td class="delbutton-col" style="text-align:center;" ><a class="btn btn-default flat delbutton"><i class="fa fa-trash fa-fw"></i> Delete</a></td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<tr class="gradeX">
<td colspan="7">Total</td>
<td><input type="text" class="form-control flat" id="total" name="total" readonly></td>
<td colspan="2"></td>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
<div class="cleaner_h20"></div>
<div class="form-group">
<div class="col-sm-7">
<button type="submit" class="btn btn-primary flat" disabled="disabled" id="btnsimpan" name="submit" >Confirm</button>
</div>
</div>
</form>
<div class="cleaner_h20"></div>
</div><!-- /.box-body -->
</div><!-- /.box -->
</div>
</div>
</section><!-- /.content -->
<!-- ============ MODAL ADD PENJUALAN BARANG =============== -->
<div id="modalAddPenjualanBarang" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="addLabel" aria-hidden="false">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h3 class="modal-title" id="addLabel">Tambah Barang</h3>
</div>
<form class="form-horizontal" id="form-add-order" method="post" role="form" action="#">
<div class="modal-body">
<div class="form-group">
<label for="barang" class="col-md-3 control-label">List Barang</label>
<div class="col-md-6">
<select id="barang_add" class="chzn-select form-control flat" name="barang" data-placeholder="Pilih Barang">
<option value=""></option>
<?php
if(count($data_barang_kategori) > 0){
foreach($data_barang_kategori as $key => $value){
?>
<option value="<?php echo $value->id_tipe_kategori?>"><?php echo $value->kategori." ".$value->type?></option>
<?php
}
}
?>
</select>
</div>
</div>
<div id="detail_barang"></div>
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-primary" disabled="disabled" id="add" name="add">Simpan</button>
<button class="btn" data-dismiss="modal" id="closemodal" aria-hidden="true">Close</button>
</div>
</form>
</div>
</div>
</div>
and my javascript is here http://ift.tt/1EQ9iVK
MY SCREEN SHOOT
i am really stuck, please help
Aucun commentaire:
Enregistrer un commentaire