CI_Controller
function controller01(){
$data['view'] = 'view/controller01';
if($this->input->post('tgl_aw')){
$tgl_aw = $this->input->post('tgl_aw');
$data['sumber']= $sumber= $this->input->post('sumber');
$data['tgl_aw'] = $tgl_aw = date("dmY", strtotime($tgl_aw));
$data['list_data'] = $this->ci_model->model01($tgl_aw,$sumber);
}
$this->load->view($data);
}
CI_Model
function model01($tgl_aw,$sumber){
$data = "select * FROM TABLE where TGL='$tgl_aw' and SUMBER='$sumber' order by DATA1 asc";
return $this->db->query($data);
}
View-Controller01
<body>
<div class="box">
<form method="post" action="">
<div class="form-group"><label>Periode Laporan:</label>
<div class="input-group">
<div class="input-group-addon"><i class="fa fa-calendar"></i></div>
<input name="tgl_aw" class="datepicker" class="form-control" type="text" value="<?php echo $this->input->post('tgl_aw');?>" required/>
</div>
</div>
<div class="form-group"><label>Sumber :</label>
<div class="input-group">
<select name="sumber" class="form-control" id='sumber' required/>
<option value='<?php echo $this->input->post('sumber');?>'><?php echo $this->input->post('sumber');?></option>
</select>
</div>
</div>
<input type="submit" id="submit" class="btn btn-sm btn-primary btn-flat" name="submit" value="Submit" />
<div class="box-footer"></div>
</form>
<?php if($this->input->post('tgl_aw')){ ?>
<?php
if($list_data->num_rows() > 0)
{ $this->load->view('view/controller02'); }
else
{ echo "<br /><font color='#FF3300' size='-1'><i>Maaf, data tidak tersedia</i></font>"; }
} ?>
</div>
</body>
View-Controller02
<div class="box-body">
<table>
<thead><tr><th>NO</th><th>DATA1</th><th>DATA2</th><th>DATA3</th></tr></thead>
<tbody>
<?php $no=1; foreach($list_data->result() as $row): ?>
<tr>
<td align="center"><?php echo $no;?>.</td>
<td><?php echo $row->DATA1;?></td>
<td><?php echo $row->DATA2;?></td>
<td><?php echo $row->DATA3;?></td>
</tr>
<?php $no++; endforeach; ?>
</tbody>
</table>
</div>
No comments:
Post a Comment