|
Directory : /var/www/vhosts/lautnusantara.com/httpdocs/mis/app/Models/ |
<?php
namespace App\Models;
use CodeIgniter\Model;
class Login_Model extends Model {
protected $table = 'ssn_users';
protected $primaryKey = 'id';
protected $allowedFields = ['usergroup_id', 'username', 'password', 'firstname', 'lastname', 'email', 'image', 'active', 'created'];
public function getLogin($username=false,$password=false)
{
$builder = $this->table('ssn_users');
$builder->select('ssn_user_groups.name,cys_users.*');
$builder->join('ssn_user_groups','ssn_user_groups.id=ssn_users.usergroup_id', 'left');
return $builder->where($where)->get();
}
}
?>