<?php
class M_login extends CI_Model{
    
    function cekadmin($u,$p){
        $hasil=$this->db->query("select*from tbl_pengguna where pengguna_username='$u'and pengguna_password=md5('$p')");
        return $hasil;
    }
    
    function cekNomor($notelp){
        return $this->db->query("SELECT * FROM tbl_pelanggan WHERE plg_notelp = '$notelp'");
    }
    
    function semuaKedai(){
        return $this->db->query("SELECT kd_toko,nm_toko FROM tabel_toko WHERE stat = 2 AND area != 'A8' AND area != 'AA'");
    }
  
    function getPelanggan($notelp){
        return $this->db->select("plg_nama,plg_id,jenis,kdcabang,transaksi")
        ->where("plg_notelp", $notelp)->get("tbl_pelanggan");
    }
    
    
}