[eluser]redraw[/eluser]
untuk seperti itu gimna caranya mas?
model sya kya gini :
Code:
function cetak_master()
{
$data = $this->fungsi->accept_data(array_keys($_POST));
//$this->gl_model->gl_browse_trans($data);
$data['tanggal_mulai'] = $_POST['tanggal_mulai'];
$this->session->set_userdata('tanggal_mulai', $this->input->post('tanggal_mulai'));
$data['tanggal_sampai'] = $_POST['tanggal_sampai'];
$this->session->set_userdata('tanggal_sampai', $this->input->post('tanggal_sampai'));
$data['detail'] = $this->gl_model->gl_browse_trans();
$data['detail_nomer'] = $this->gl_model->ambil_nomer();
$data['detail_batasan'] = $this->gl_model->ambil_batasan_list();
$this->load->view('haluser/cetak_trans', $data);
}
model saya :
Code:
function ambil_master()
{
$tanggal_mulai = $this->input->post('tanggal_mulai');
$tanggal_sampai = $this->input->post('tanggal_sampai');
$sql = "SELECT gl_master.master_id, gl_master.no_bukti, gl_master.tanggal, gl_akun.code, gl_akun.account,"
."gl_master.keterangan, gl_master.nilai, if(gl_master.jenis='d', gl_master.nilai,0) as debet, if(gl_master.jenis='k', gl_master.nilai,0) as kredit,"
."gl_master.jenis, gl_master.awal, gl_master.aktif "
."FROM gl_master JOIN gl_akun "
."ON gl_akun.code = gl_master.code "
."WHERE gl_master.tanggal BETWEEN '".$tanggal_mulai."' AND DATE '".$tanggal_sampai."'"
."order by gl_master.tanggal,gl_master.no_bukti,gl_master.jenis ASC";
$data = $this->db->query($sql);
return $data;
}