hai master2 CI gw minta bantuannye donk...langsung aje yaaa nih kodingnye...
Controller member.php
function nilai($mode = 'view', $item = NULL) {
switch ($mode) {
case 'view':
$this->nilai_view($item);
break;
case 'detail':
$this->nilai_detail($item);
break;
}
}
private function nilai_view($page) {
$user = $this->auth->getLoggedUser();
$this->load->library('pagination');
$config['base_url'] = site_url('member/nilai/view');
$config['total_rows'] = $this->nilaimodel->countAll();
$config['per_page'] = '10';
$config['cur_page'] = $page;
$this->pagination->initialize($config);
$nilais = $this->nilaimodel->getAllNilaiByNis(
$user['nis_nip'], $config['per_page'], $config['cur_page']
);
$data['nilais'] = $nilais;
$profile = $this->auth->getProfile($user['nis_nip']);
$data['profile'] = $profile;
$this->load->view('member/nilai', $data);
}
private function nilai_detail($id) {
$data['nilai'] = $this->nilaimodel->getDetail($id);
$this->load->view('member/nilai_detail', $data);
}
Model nilaimodel.php
class NilaiModel extends Model {
private $table = 'tbl_nilai';
function NilaiModel() {
parent::Model();
}
function countAll() {
$this->db->where('deleted', 0);
return $this->db->count_all($this->table);
}
function add($data) {
$this->db->insert($this->table, $data);
}
function update($id, $data) {
$this->db->where('tanggal', $id);
$this->db->update($this->table, $data);
}
function delete($id) {
$data['deleted'] = 1;
$this->update($id, $data);
}
function getAllNilaiByNis($nis_nip, $num, $offset) {
$this->db->where('nis_nip', $nis_nip);
$this->db->where('deleted', 0);
$query = $this->db->get($this->table, $num, $offset);
return $query->result();
}
function getNilaiDetail($nis_nip) {
$this->db->where('nis_nip', $nis_nip);
$this->db->where('deleted', 0);
$query = $this->db->get($this->table);
return $query->result_array();
}
function getAll() {
$this->db->select('tanggal, nilai_a, nilai_b');
$this->db->where('deleted', 0);
$this->db->order_by('tanggal asc');
$query = $this->db->get($this->table);
return $query->result();
}
function getAllWait() {
$this->db->select('tanggal, nilai_a, nilai_b');
$this->db->where('deleted', 0);
$this->db->order_by('level desc,nis_nip desc');
$query = $this->db->get($this->table);
return $query->result();
}
function getDetail($id) {
$this->db->where('tanggal', $id);
$this->db->where('deleted', 0);
$this->db->order_by('level desc,nis_nip desc');
$query = $this->db->get($this->table);
return $query->row();
}
}
?>
View nilai.php
<?
$user = $this->auth->getLoggedUser();
$class = 'row-b';
?>
<?
if ($this->session->flashdata('pesan'))
echo ''.$this->session->flashdata('pesan').'';
?>
<? if(count($nilais) == 0): ?>
NIS
:
<?=$profile->nis_nip?>
Daftar nilai raport masih kosong.
<? else: ?>
NIS
:
<?=$profile->nis_nip?>
Nilai Angka
Nilai Huruf
<? foreach ($nilais as $item):?>
<? $class = ($class == 'row-b') ? 'row-a' : 'row-b'; ?>
">
<?=$item->nilai_a?>
<?=$item->nilai_b?>
<? endforeach; ?>
<?=$this->pagination->create_links()?>
<? endif; ?>
<?
$this->load->view('footer');
?>
Pertanyaannya :
1. Gmn buat download laporan nilai format pdf dr koding di atas, ane mo nye ksh link tuk dowload di koding view nilai.php yg bisa download laporan nilai dlm format pdf pake R&OS library
2. Gmn tuk buat edit nilai dr koding diatas soalnye ntu koding diatas cuma tuk tampilin nilai dr database aje
hehehehehe...kebanyakan yaaa nih gw ksh link curhatan gw di kaskus klo mo jwb disana biar lengkap http://www.kaskus.us/showthread.php?t=1611573&page=79...mohon bantuannya...thx