input pesanan

// controller
public function opesan()
    {

        $data = array('id_pesanan' => $this->input->post('id_pesanan'),
                      'no_meja' => $this->input->post('no_meja'),
                      'tgl_pesan' => $this->input->post('tgl_pesan'),
                      'total' => $this->input->post('total'));
        $query = $this->kuale->insert('tb_pesanan', $data);
        $this->kuale->selesai();
        redirect('admin/pelayan');
    }
//view tpesan2.php
<form>
  <div class="col-xs-12 col-sm-12">
    <table id="example2" class="table table-bordered table-hover table-striped" style="width: 100%">
      <thead>
    <th>Nomor Meja</th>
    <th>Tanggal Order</th>
    <th>Total Order</th>
    <th>Aksi</th>
  </thead>
  <tbody>
    <tr>
      <?php
$total=0;
foreach ($detail->result() as $row => $r) {
$total +=$r->subtotal;
}
?>
<?php echo form_open('admin/opesan'); ?>
<td><select name="no_meja" class="form-control">
  <option>Pilih No.Meja</option>
  <option value="1">1</option>
  <option value="2">2</option>
  <option value="3">3</option>
  <option value="4">4</option>
  <option value="5">5</option>
  <option value="6">6</option>
  <option value="7">7</option>
  <option value="8">8</option>
  <option value="9">9</option>
  <option value="10">10</option>
</select></td>

<td><input type="date" name="tgl_order" id="tgl_order" required></td>
<td><input type="text" name="total" class="subtotal_val" value="<?=$total ;?>" readonly></td>
<td><button type="submit" onClick="return confirm('apakah anda sudah selesai menginput menu?')">Selesai</button></td></tr>
<?php echo form_close(); ?>

<h4></h4>
</tbody></table><br/>
</div>
</form>

//model
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Kuale extends CI_Model {

    public function select($tabel,$where)
    {
        return $query = $this->db->get_where($tabel, $where);
    }

    public function selectAll($tabel)
    {
        return $query = $this->db->get($tabel);
    }

    public function update($tabel,$data,$where)
    {
        return $query = $this->db->update($tabel, $data, $where);
    }

    public function delete($tabel,$where)
    {
        return $query = $this->db->delete($tabel, $where);
    }
    public function insert($tabel,$data)
    {

        return $query =$this->db->insert($tabel, $data);
    }

    public function proseslogin($username,$password)
    {
        $this->db->where('username', $username);
        $this->db->where('password', $password);
        return $this->db->get('user')->row();
    }
    public function getmenu()
    {
        $sql = "SELECT id_menu, nama_pesanan, harga_satuan, jml_porsi, (harga_satuan * jml_porsi) as subtotal FROM tb_detail_pesanan ORDER BY id_detail_pesanan ";
        return $this->db->query($sql);
    }
    public function getsum()
    {
        $this->db->select_sum('subtotal', 'total');
        $this->db->from('tb_detail_pesanan');
        return $this->db->get('')->row();
    }
    public function selesai($data)
    {
        $this->db->insert('tb_pesanan', $data);
        $last_id = $this->db->query("select id_pesanan from tb_pesanan order by id_pesanan desc")->row_array();
        $this->db->query("update tb_detail_pesanan set id_pesanan='".$last_id['id_pesanan']."' where status='0'");
        $this->db->query("update tb_detail_pesanan set status='1' where status='0'");
    }
}

/* End of file kuale.php */
/* Location: ./application/models/kuale.php */