public function getVAllEmployees()
{
$db = Zend_Db_Table::getDefaultAdapter();
$empmodel = new Default_Model_Employee();
$acceptedrolesArr = $empmodel->getUserRole();
$roles = $acceptedrolesArr[0]['roles'];
$where = "u.isactive = 1 AND u.userstatus = 'old' ";
if ($roles != '') {
$where .= " AND emprole IN(" . $roles . ")";
}
$empData = $db->query("SELECT u.id,u.profileimg,\n\t\t\t\t\t\t\t concat(u.userfullname,if(j.jobtitlename is null,'',concat(' , ',j.jobtitlename))) as name\n\t\t\t\t\t\t\t FROM main_users u\n\t\t\t\t\t\t\t left JOIN main_jobtitles j on j.id = u.jobtitle_id\n\t\t\t\t\t\t\t WHERE " . $where . " ORDER BY name ASC");
$result = $empData->fetchAll();
return $result;
}
