public static function modifyCompanyDetails($data, $userId)
{
try {
$db = Database::getInstance();
$conn = $db->getConnection();
HicreteLogger::logInfo("Modifying company details");
if (ConfigUtils::isCompanyAvailableForModify($data->data->companyName, $data->data->companyId)) {
$stmt = $conn->prepare("UPDATE companymaster SET companyName=:companyName,companyAbbrevation=:abbrevation,startDate=:startdate,address=:address,city=:city,state=:state,country=:country,pincode=:pincode,emailId=:emailId,phoneNumber=:phoneNumber,lastModifiedBy=:userId,lastModificationDate=now() WHERE companyId=:companyId");
$stmt->bindParam(':companyName', $data->data->companyName, PDO::PARAM_STR);
$stmt->bindParam(':abbrevation', $data->data->companyAbbrevation, PDO::PARAM_STR);
$stmt->bindParam(':startdate', $data->data->startDate, PDO::PARAM_STR);
$stmt->bindParam(':address', $data->data->address, PDO::PARAM_STR);
$stmt->bindParam(':city', $data->data->city, PDO::PARAM_STR);
$stmt->bindParam(':state', $data->data->state, PDO::PARAM_STR);
$stmt->bindParam(':country', $data->data->country, PDO::PARAM_STR);
$stmt->bindParam(':pincode', $data->data->pincode, PDO::PARAM_STR);
$stmt->bindParam(':emailId', $data->data->emailId, PDO::PARAM_STR);
$stmt->bindParam(':phoneNumber', $data->data->phoneNumber, PDO::PARAM_STR);
$stmt->bindParam(':userId', $userId, PDO::PARAM_STR);
$stmt->bindParam(':companyId', $data->data->companyId, PDO::PARAM_STR);
HicreteLogger::logDebug("Query:\n " . json_encode($stmt));
HicreteLogger::logDebug("Data:\n " . json_encode($data));
if ($stmt->execute()) {
HicreteLogger::logInfo("Company details modified successfully");
echo AppUtil::getReturnStatus("Successful", "Company Modified successfully");
} else {
HicreteLogger::logError("company details not modified");
echo AppUtil::getReturnStatus("Unsuccessful", "Unknown database error occurred");
}
} else {
HicreteLogger::logError("company is already available");
echo AppUtil::getReturnStatus("Unsuccessful", "Company Name you entered is already available");
}
} catch (Exception $e) {
HicreteLogger::logFatal("Exception Occured Message:\n" . $e->getMessage());
echo AppUtil::getReturnStatus("Exception", "Exception Occurred while fetching company details");
}
}
