public function updateAction($params)
{
$db = new connection();
$pk = $params['pk'];
if ($pk != "") {
$columns_values = array("sys_name" => $params['sys_name'], "sys_role_id" => $params['sys_role_id'], "dob" => $db->storeDBDate($params['dob']), "email" => $params['email'], "mobile" => $params['mobile'], "address" => $params['address'], "user_name" => $params['user_name'], "modified_by" => $_SESSION['sys_user_id'], "modified_at" => $db->now_time, "flag" => 0);
$msg = "";
if ($db->alreadyExists("Select * from system_user where flag=0 and user_name='" . $params['user_name'] . "' and email='" . $params['email'] . "' and sys_user_id!='{$pk}'")) {
$res = $db->updateData($this->table_name, $columns_values, " sys_user_id={$pk}");
if ($res == true) {
$msg = "Success";
} else {
$msg = "Failed";
}
} else {
$msg = "Data Already Exists";
}
} else {
$msg = "System Error";
}
return $msg;
}
