/**
* Update existing request of an asset
*
* @param String $requestId
* @param String $assetid
* @param String $date
* @param String $desc
* @param Int $st_id
* @param String $contact_name
* @param String $note
* @param String $by_user
* @param Int $visitpid
*
* @return Boolean $num_affected_rows Returns true if rows have been altered
*/
public function updateRequest($requestId, $assetid, $date, $desc, $st_id, $contact_name, $note, $by_user, $visitpid)
{
$lastmodified = RequestHelper::getTimestamp();
$query = "UPDATE request SET Request_date = ?, Request_desc = ?, AssetID = ?, Request_st_id = ?, Request_contact_name = ?, Request_note = ?, lastmodified = ?, by_user = ?, VisiTpID = ? WHERE Request_id = ?";
if ($stmt = $this->core->dbh->prepare($query)) {
//i = int, s = String, d = double, b = blob
$stmt->bind_param("sssissssis", $date, $desc, $assetid, $st_id, $contact_name, $note, $lastmodified, $by_user, $visitpid, $requestId);
}
$stmt->execute();
$num_affected_rows = $stmt->affected_rows;
$stmt->close();
return $num_affected_rows > 0;
}
/**
* Update intervention work with totalWork
*
* @param $intervId
* @param $totalWork
* @param $by_user
* @return bool
*/
public function updateInterventionWork($intervId, $totalWork, $by_user)
{
$lastmodified = RequestHelper::getTimestamp();
$query = "UPDATE intervention SET TotalWork = ?, lastmodified = ?, by_user = ? WHERE IntervID = ?";
if ($stmt = $this->core->dbh->prepare($query)) {
//i = int, s = String, d = double, b = blob
$stmt->bind_param("dsss", $totalWork, $lastmodified, $by_user, $intervId);
}
$stmt->execute();
$num_affected_rows = $stmt->affected_rows;
$stmt->close();
return $num_affected_rows > 0;
}
/**
* Update asset
*
* @param String $assetId
* @param Int $genericAssetId
* @param Int $umdns
* @param String $assetFullName
* @param String $manufacturerId
* @param String $model
* @param String $serialNumber
* @param String $internaliventoryNumber
* @param String $locationId
* @param String $responsiblePers
* @param Int $assetStatusId
* @param Int $assetUtilizationId
* @param String $purchaseDate
* @param String $installationDate
* @param String $lifeTime
* @param Double $purchasePrice
* @param Double $currentValue
* @param Int $warrantyContractId
* @param String $agentId
* @param String $warrantyContractExp
* @param String $warrantyContractNotes
* @param String $employeeId
* @param String $supplierId
* @param String $donorId
* @param String $serviceManual
* @param String $notes
* @param String $picture
* @param String $by_user
* @param String $URL_Manual
* @param String $metrologyDocument
* @param String $metrologyDate
* @param String $metrology
* @param String $assetFullName
*
* @return Int Number of affected rows
*/
public function updateAsset($assetId, $genericAssetId, $umdns, $assetFullName, $manufacturerId, $model, $serialNumber, $internaliventoryNumber, $locationId, $responsiblePers, $assetStatusId, $assetUtilizationId, $purchaseDate, $installationDate, $lifeTime, $purchasePrice, $currentValue, $warrantyContractId, $agentId, $warrantyContractExp, $warrantyContractNotes, $employeeId, $supplierId, $donorId, $serviceManual, $notes, $picture, $by_user, $URL_Manual, $metrologyDocument, $metrologyDate, $metrology)
{
$lastmodified = RequestHelper::getTimestamp();
//cast the incoming parameters (all Strings) to its original data type(s)
$genericAssetId = (int) $genericAssetId;
$umdns = (int) $umdns;
$assetStatusId = (int) $assetStatusId;
$assetUtilizationId = (int) $assetUtilizationId;
$lifeTime = (int) $lifeTime;
$purchasePrice = (double) $purchasePrice;
$currentValue = (double) $currentValue;
$warrantyContractId = (int) $warrantyContractId;
$sql = "UPDATE assets SET GenericAssetID = ?, UMDNS = ?, AssetFullName = ?, ManufacturerID = ?, Model = ?, SerialNumber = ?, InternalIventoryNumber = ?, LocationID = ?, ResponsiblePers = ?, AssetStatusID = ?, AssetUtilizationID = ?, PurchaseDate = ?, InstallationDate = ?, Lifetime = ?, PurchasePrice = ?, CurrentValue = ?, WarrantyContractID = ?, AgentID = ?, WarrantyContractExp = ?, WarrantyContractNotes = ?, EmployeeID = ?, SupplierID = ?, DonorID = ?, ServiceManual = ?, Notes = ?, Picture = ?, lastmodified = ?, by_user = ?, URL_Manual = ?, MetrologyDocument = ?, MetrologyDate = ?, Metrology = ? WHERE AssetID = ?";
if ($stmt = $this->core->dbh->prepare($sql)) {
//i = int, s = String, d = double, b = blob
$stmt->bind_param("iisssssssiissiddissssssssssssssss", $genericAssetId, $umdns, $assetFullName, $manufacturerId, $model, $serialNumber, $internaliventoryNumber, $locationId, $responsiblePers, $assetStatusId, $assetUtilizationId, $purchaseDate, $installationDate, $lifeTime, $purchasePrice, $currentValue, $warrantyContractId, $agentId, $warrantyContractExp, $warrantyContractNotes, $employeeId, $supplierId, $donorId, $serviceManual, $notes, $picture, $lastmodified, $by_user, $URL_Manual, $metrologyDocument, $metrologyDate, $metrology, $assetId);
}
$stmt->execute();
$num_affected_rows = $stmt->affected_rows;
$stmt->close();
return $num_affected_rows > 0;
}
