Advertisement
Guest User

Untitled

a guest
Feb 26th, 2020
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. function GetDataPerbaikan()
  2. {
  3. $this->db->select('
  4. ast.nama_asset,
  5. ast.id_asset,
  6. bgn.id_bg_mesin,
  7. bgn.id_asset,
  8. bgn.nama_bagian,
  9. prb.id_perbaikan,
  10. prb.id_asset,
  11. prb.tgl_perbaikan,
  12. prb.tgl_selesai,
  13. prb.jumlah_perbaikan,
  14. prb.biaya_perbaikan,
  15. prb.status,
  16. prb.foto
  17. ');
  18. $this->db->from('tb_perbaikan AS prb');
  19. $this->db->join('tb_asset AS ast', 'prb.id_asset = ast.id_asset');
  20. $this->db->join('tb_bg_mesin as bgn', 'prb.id_bg_mesin = bgn.id_bg_mesin');
  21. return $this->db->get();
  22.  
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement