<?php 
namespace App\Models;
use CodeIgniter\Model;
class RoleModel extends Model
{
    protected $table = 'roles';
    protected $primaryKey = 'role_id';
    protected $allowedFields = ['role_id','roles','isactive'];
    public function getRoles(){
        return $this->where('roles !=', 'Super Admin')->findAll();
    }
    public function getRoleNameById($roleId)
    {
        $role = $this->where('role_id', $roleId)->first();
        return $role ? $role['roles'] : 'Unknown';
    }

    public function get_workers($logged_user_branch_id)
    {
        $this->select('roles.*,users.user_id, users.name, users.business_id,  users.branch_id,  users.role,  users.mobile_no,  users.isactive');
        $this->join('users', 'users.role = roles.role_id');
        $this->where('roles.isactive', 1);
        $this->where('users.isactive', 1);
        $this->whereIn('roles.roles', ['Senior Mechanic','Mechanic','Helper']);
        $this ->where('users.branch_id',$logged_user_branch_id);
        return $this->findAll();
    }
}