/** * 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; }