public static function CancelTempAccessRequest($requestId) { try { $db = Database::getInstance(); $conn = $db->getConnection(); HicreteLogger::logInfo("Adding temporary request"); $stmt = $conn->prepare("UPDATE `tempaccessrequest` SET `status`='Cancel' WHERE `requestId`=:requestId"); $stmt->bindParam(':requestId', $requestId, PDO::PARAM_STR); HicreteLogger::logDebug("Query:\n " . json_encode($stmt)); if ($stmt->execute()) { HicreteLogger::logInfo("Access request added"); echo AppUtil::getReturnStatus("Successful", "Access Request Added"); } else { HicreteLogger::logError("Unknown databse error occured"); echo AppUtil::getReturnStatus("Unsuccessful", "Unknown database error occurred"); } } catch (Exception $e) { HicreteLogger::logFatal("Exception Occured Message:\n" . $e->getMessage()); echo AppUtil::getReturnStatus("Exception", $e->getMessage()); } }
public function searchLeaveByEmployee($data) { $db = Database::getInstance(); $connect = $db->getConnection(); $json_response = array(); $searchBy = $data->employee; $stmt1 = $connect->prepare("SELECT * FROM leave_application_master WHERE leave_applied_by=:searchBy"); $stmt1->bindParam(':searchBy', $searchBy); HicreteLogger::logDebug("query: \n" . json_encode($stmt1)); if ($stmt1->execute()) { HicreteLogger::logDebug("Row Count : \n" . json_encode($stmt1->rowCount())); while ($result = $stmt1->fetch(PDO::FETCH_ASSOC)) { $result_array = array(); $result_array['from_date'] = date("d-m-Y", strtotime($result['from_date'])); $result_array['to_date'] = date("d-m-Y", strtotime($result['to_date'])); $result_array['reason'] = $result['reason']; $result_array['type_of_leaves'] = $result['type_of_leaves']; $result_array['status'] = $result['status']; $result_array['application_date'] = date("d-m-Y", strtotime($result['application_date'])); $result_array['no_of_leaves'] = $result['no_of_leaves']; $userId = $result['leave_applied_by']; $stmt2 = $connect->prepare("SELECT firstName,lastName FROM usermaster WHERE userId='{$userId}'"); if ($stmt2->execute()) { $result1 = $stmt2->fetch(PDO::FETCH_ASSOC); $result_array['leave_applied_by'] = $result1['firstName'] . " " . $result1['lastName']; } array_push($json_response, $result_array); } if (sizeof($json_response) > 0) { HicreteLogger::logInfo("Leave details found "); echo AppUtil::getReturnStatus("success", $json_response); return true; } else { HicreteLogger::logError("Leave details not found"); return false; } } else { HicreteLogger::logError("Leave details not found"); return false; } }
public static function modifyCostCenter($projectId, $segmentData, $costCentermaterials, $userId) { $db = Database::getInstance(); $conn = $db->getConnection(); $conn->beginTransaction(); try { $stmt1 = $conn->prepare("DELETE FROM `budget_details` where projectid=:projectid"); $stmt1->bindParam(':projectid', $projectId); if ($stmt1->execute()) { $stmt2 = $conn->prepare("DELETE FROM `material_budget_details` where projectid=:projectid"); $stmt2->bindParam(':projectid', $projectId); if ($stmt2->execute()) { $success = false; HicreteLogger::logInfo("Creating cost center"); foreach ($segmentData as $segment) { $budgetId = AppUtil::generateId(); $stmt = $conn->prepare("INSERT INTO `budget_details`(`budgetdetailsid`,`projectid`, `budgetsegmentid`, `allocatedbudget`, `alertlevel`, `createdby`, `creationdate`, `lastmodificationdate`, `lastmodifiedby`)\n VALUES (:budgetId,:projectId,:segmentId,:allocatedBudget,:alertLevel,:createdBy,now(),now(),:lastModifiedBy)"); $stmt->bindParam(':budgetId', $budgetId, PDO::PARAM_STR); $stmt->bindParam(':projectId', $projectId, PDO::PARAM_STR); $stmt->bindParam(':segmentId', $segment->budgetsegmentid, PDO::PARAM_STR); $stmt->bindParam(':allocatedBudget', $segment->allocatedbudget, PDO::PARAM_INT); $stmt->bindParam(':alertLevel', $segment->alertlevel, PDO::PARAM_STR); $stmt->bindParam(':createdBy', $userId, PDO::PARAM_STR); $stmt->bindParam(':lastModifiedBy', $userId, PDO::PARAM_STR); HicreteLogger::logDebug("Query: \n" . json_encode($stmt)); if ($stmt->execute()) { $success = true; } else { $success = false; } } if ($costCentermaterials != null) { foreach ($costCentermaterials as $material) { $materialbudgetdetailsid = uniqid(); $stmtCostCenterMaterial = $conn->prepare("INSERT INTO `material_budget_details`(`materialbudgetdetailsid`,`projectid`,`materialid` ,`allocatedbudget`, `alertlevel`, `creadtedby`, `creationdate`, `lastmodificationdate`, `lastmodifiedby`)\n VALUES (:materialbudgetdetailsid,:projectId,:materialid,:allocatedBudget,:alertLevel,:creadtedby,now(),now(),:lastmodifiedby)"); $stmtCostCenterMaterial->bindParam(':materialbudgetdetailsid', $materialbudgetdetailsid, PDO::PARAM_STR); $stmtCostCenterMaterial->bindParam(':projectId', $projectId, PDO::PARAM_STR); $stmtCostCenterMaterial->bindParam(':materialid', $material->materialid, PDO::PARAM_STR); $stmtCostCenterMaterial->bindParam(':allocatedBudget', $material->allocatedbudget, PDO::PARAM_INT); $stmtCostCenterMaterial->bindParam(':alertLevel', $material->alertlevel, PDO::PARAM_STR); $stmtCostCenterMaterial->bindParam(':creadtedby', $userId, PDO::PARAM_STR); $stmtCostCenterMaterial->bindParam(':lastmodifiedby', $userId, PDO::PARAM_STR); if ($stmtCostCenterMaterial->execute()) { $success = true; } else { $success = false; } } } if ($success) { $conn->commit(); $message = "Cost Center Updated successfully..!!!"; HicreteLogger::logInfo("Cost center Updated successfully"); echo AppUtil::getReturnStatus("success", $message); } else { $conn->rollBack(); $message = "Could not create cost center..!!!"; HicreteLogger::logError("Error while creating cost center"); echo AppUtil::getReturnStatus("failure", $message); } } } else { $conn->rollBack(); $message = "Could not update cost center..!!!"; HicreteLogger::logError("Error while updating cost center"); echo AppUtil::getReturnStatus("failure", $message); } } catch (Exception $e) { $conn->rollBack(); HicreteLogger::logError("Exception while updating cost center"); echo AppUtil::getReturnStatus("failure", $e->getMessage()); } }
$stmt->bindParam(':delflg', $dfltDelFlg, PDO::PARAM_STR, 10); $stmt->bindParam(':lchnguserid', $userId, PDO::PARAM_STR, 10); $stmt->bindParam(':creuserid', $userId, PDO::PARAM_STR, 10); HicreteLogger::logDebug("Query: \n" . json_encode($stmt)); HicreteLogger::logDebug("DATA: \n" . json_encode($data->data[$i]->type)); if ($stmt->execute()) { $count++; } } if ($count == sizeof($data->data)) { HicreteLogger::logInfo("Material type Added successfully"); $arr = array('msg' => "Material type added Successfully!!!", 'error' => ''); $jsn = json_encode($arr); echo $jsn; } else { HicreteLogger::logError("Material type Not added successfully"); $arr = array('msg' => '', 'error' => "Material Type not added due to technical reasons Please try after some time "); $jsn = json_encode($arr); echo $jsn; } } catch (Exception $e) { HicreteLogger::logFatal("Exception occured :\n" . $e->getMessage()); $arr = array('msg' => '', 'error' => "Exception occured Please contact administrator"); $jsn = json_encode($arr); echo $jsn; } break; case 'fetch': try { $dfltDelFlg = 'Y'; $stmt = $dbh->prepare("Select materialtypeid,materialtype from materialtype where delflg!=:delflg");
public function insertOutwardInToDb($dbh, $userId, $data) { try { //BEGIN THE TRANSACTION $dbh->beginTransaction(); HicreteLogger::logInfo("Inserting outward entries"); $date = new DateTime($this->dateOfOutward); $dob = $date->format('Y-m-d'); $stmtOutward = $dbh->prepare("INSERT INTO outward (warehouseid,companyid,supervisorid,dateofentry,outwardno,lchnguserid,lchngtime,creuserid,cretime)\n values (:warehouseid,:companyid,:supervisorid,:dateofentry,:Outwardno,:lchnguserid,now(),:creuserid,now())"); $stmtOutward->bindParam(':warehouseid', $this->warehouse, PDO::PARAM_STR, 10); $stmtOutward->bindParam(':companyid', $this->companyName, PDO::PARAM_STR, 10); $stmtOutward->bindParam(':supervisorid', $this->suppervisor, PDO::PARAM_STR, 10); $stmtOutward->bindParam(':dateofentry', $dob, PDO::PARAM_STR, 40); $stmtOutward->bindParam(':Outwardno', $this->OutwardNumber, PDO::PARAM_STR, 10); $stmtOutward->bindParam(':lchnguserid', $userId, PDO::PARAM_STR, 10); $stmtOutward->bindParam(':creuserid', $userId, PDO::PARAM_STR, 10); HicreteLogger::logDebug("Query: " . json_encode($stmtOutward)); HicreteLogger::logDebug("Data: " . json_encode($this)); if ($stmtOutward->execute()) { HicreteLogger::logInfo("Insertion to outward successful. Inserting outward details"); $lastOutwardId = $dbh->lastInsertId(); $materials = $data->outwardData->outwardMaterials; //Insert Data into Outward Details table foreach ($materials as $material) { $stmtOutwardDetails = $dbh->prepare("INSERT INTO outward_details (Outwardid,materialid,quantity,packagedunits,packagesize,lchnguserid,lchngtime,creuserid,cretime)\n values (:Outwardid,:materialid,:quantity,:packagedunits,:packagesize,:lchnguserid,now(),:creuserid,now())"); $stmtOutwardDetails->bindParam(':Outwardid', $lastOutwardId, PDO::PARAM_STR, 10); $stmtOutwardDetails->bindParam(':materialid', $material->material, PDO::PARAM_STR, 10); $stmtOutwardDetails->bindParam(':quantity', $material->materialQuantity, PDO::PARAM_STR, 40); $stmtOutwardDetails->bindParam(':packagedunits', $material->packageUnit, PDO::PARAM_STR, 10); $stmtOutwardDetails->bindParam(':packagesize', $material->packagesize, PDO::PARAM_STR, 10); $stmtOutwardDetails->bindParam(':lchnguserid', $userId, PDO::PARAM_STR, 10); $stmtOutwardDetails->bindParam(':creuserid', $userId, PDO::PARAM_STR, 10); HicreteLogger::logDebug("Query: " . json_encode($stmtOutwardDetails)); HicreteLogger::logDebug("Data: " . json_encode($material)); if ($stmtOutwardDetails->execute()) { $isSuccess = true; // I CAN OPTIMIZE THIS CODE HicreteLogger::logInfo(" Inserting outward details successfull updating inventory"); $result = null; $stmtInventoryCount = $dbh->prepare("SELECT totalquantity from inventory WHERE materialid = :materialid"); $stmtInventoryCount->bindParam(':materialid', $material->material, PDO::PARAM_STR, 10); $stmtInventoryCount->execute(); // if($stmtInventoryCount->execute()){ $result = $stmtInventoryCount->setFetchMode(PDO::FETCH_ASSOC); $result = $stmtInventoryCount->fetch(PDO::FETCH_ASSOC); // } if ($result['totalquantity'] != 0) { HicreteLogger::logInfo("Updating inventory"); $stmtInventory = $dbh->prepare("UPDATE inventory SET totalquantity =totalquantity- :totalquantity\n WHERE materialid = :materialid"); $stmtInventory->bindParam(':totalquantity', $material->materialQuantity, PDO::PARAM_STR, 10); $stmtInventory->bindParam(':materialid', $material->material, PDO::PARAM_STR, 10); if ($stmtInventory->execute()) { $isSuccess = true; } else { HicreteLogger::logError("Error in updating or inserting main table"); $this->showAlert('Failure', "Error 3rd"); $isSuccess = false; } } else { HicreteLogger::logError("Error in inserting outward details"); $this->showAlert('Failure', "Error 2nd"); $isSuccess = false; } } else { HicreteLogger::logError("Error in inserting outward details"); $this->showAlert('Failure', "Error 1st"); $isSuccess = false; } } if ($isSuccess) { $lastOutwardDetailsId = $dbh->lastInsertId(); // Insert Data into Transport Details Table if ($this->hasTransportDetails == 'Yes') { HicreteLogger::logInfo("Inserting transport details "); $stmtTransportDetails = $dbh->prepare("INSERT INTO outward_transportation_details (Outwardid,transportationmode,vehicleno,drivername,transportagency,cost,lchnguserid,lchngtime,creuserid,cretime,remark)\n values (:Outwardid,:transportationmode,:vehicleno,:drivername,:transportagency,:cost,:lchnguserid,now(),:creuserid,now(),:remark)"); $stmtTransportDetails->bindParam(':Outwardid', $lastOutwardId, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':transportationmode', $this->transportMode, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':vehicleno', $this->vehicleNumber, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':drivername', $this->driverName, PDO::PARAM_STR, 40); $stmtTransportDetails->bindParam(':transportagency', $this->transportAgency, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':cost', $this->transportCost, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':lchnguserid', $userId, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':creuserid', $userId, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':remark', $this->remark, PDO::PARAM_STR, 10); if ($stmtTransportDetails->execute()) { HicreteLogger::logInfo("Outward details added successfully"); $this->showAlert('success', "Outward details added Successfully!!!"); $dbh->commit(); } else { HicreteLogger::logError("Error in inserting outward transport details"); $this->showAlert('Failure', "Error while adding 3rd"); $dbh->rollBack(); } } else { HicreteLogger::logInfo("Outward details added successfully"); $this->showAlert('success', "Outward details added Successfully!!!"); $dbh->commit(); } } else { HicreteLogger::logError("Error in inserting outward details"); $this->showAlert('Failure', "Error while adding 2nf"); $dbh->rollBack(); } } else { HicreteLogger::logError("Error in inserting outward"); $this->showAlert('Failure', "Error while adding 1st"); $dbh->rollBack(); } } catch (Exception $e) { HicreteLogger::logFatal("Exception occured \n" . $e->getMessage()); echo $e->getMessage(); } }
public function addToInhouseTransport($dbh, $userId) { try { //$dbh->beginTransaction(); $stmt = $dbh->prepare("INSERT INTO inhouse_transportation_details (inhouseinwardid,transportationmode,vehicleno,drivername,transportagency,cost,LCHNGUSERID,LCHNGTIME,CREUSERID,CRETIME) \n values (:inhouseinwardid,:transportationmode,:vehicleno,:drivername,:transportagency,:cost,:lchngUserId,now(),:creUserId,now())"); $stmt->bindParam(':inhouseinwardid', $this->inhouseInwardId, PDO::PARAM_STR, 10); $stmt->bindParam(':transportationmode', $this->modeOfTransport, PDO::PARAM_STR, 10); $stmt->bindParam(':vehicleno', $this->vehicleNo, PDO::PARAM_STR, 10); $stmt->bindParam(':drivername', $this->driver, PDO::PARAM_STR, 10); $stmt->bindParam(':transportagency', $this->TranspAgency, PDO::PARAM_STR, 10); $stmt->bindParam(':cost', $this->cost, PDO::PARAM_STR, 10); $stmt->bindParam(':lchngUserId', $userId, PDO::PARAM_STR, 10); $stmt->bindParam(':creUserId', $userId, PDO::PARAM_STR, 10); HicreteLogger::logDebug("Query: \n" . json_encode($stmt)); if ($stmt->execute()) { HicreteLogger::logInfo("Insert to inhouse_transport_details successful"); return 1; } else { HicreteLogger::logError("Insert to inhouse_transport_details unsuccessful"); return 0; } } catch (Exception $e) { HicreteLogger::logFatal("Exception occured: \n" . $e->getMessage()); } }
public function insertInwardInToDb($dbh, $userId, $data) { try { //Begin Transaction $dbh->beginTransaction(); //Create preapred Statement $date = new DateTime($this->dateOfInward); $inwardDate = $date->format('Y-m-d'); HicreteLogger::logInfo("Inserting inward entries"); $stmtInward = $dbh->prepare("INSERT INTO inward (warehouseid,companyid,supervisorid,dateofentry,inwardno,lchnguserid,lchngtime,creuserid,cretime)\n values (:warehouseid,:companyid,:supervisorid,:dateofentry,:inwardno,:lchnguserid,now(),:creuserid,now())"); $stmtInward->bindParam(':warehouseid', $this->warehouse, PDO::PARAM_STR, 10); $stmtInward->bindParam(':companyid', $this->companyName, PDO::PARAM_STR, 10); $stmtInward->bindParam(':supervisorid', $this->suppervisor, PDO::PARAM_STR, 10); $stmtInward->bindParam(':dateofentry', $inwardDate, PDO::PARAM_STR, 40); $stmtInward->bindParam(':inwardno', $this->inwardNumber, PDO::PARAM_STR, 10); $stmtInward->bindParam(':lchnguserid', $userId, PDO::PARAM_STR, 10); $stmtInward->bindParam(':creuserid', $userId, PDO::PARAM_STR, 10); HicreteLogger::logDebug("Query: \n" . json_encode($stmtInward)); HicreteLogger::logDebug("DATA: \n" . json_encode($this)); if ($stmtInward->execute()) { HicreteLogger::logInfo("Insertion to Inward successful.Inserting inward Details"); $lastInwardId = $dbh->lastInsertId(); $materials = $data->inwardData->inwardMaterials; //Insert Data into Inward Details table foreach ($materials as $material) { $stmtInwardDetails = $dbh->prepare("INSERT INTO inward_details (inwardid,materialid,supplierid,quantity,packagedunits,size,lchnguserid,lchngtime,creuserid,cretime)\n values (:inwardid,:materialid,:supplierid,:quantity,:packagedunits,:size,:lchnguserid,now(),:creuserid,now())"); $stmtInwardDetails->bindParam(':inwardid', $lastInwardId, PDO::PARAM_STR, 10); $stmtInwardDetails->bindParam(':materialid', $material->material, PDO::PARAM_STR, 10); $stmtInwardDetails->bindParam(':supplierid', $material->suppplierName, PDO::PARAM_STR, 10); $stmtInwardDetails->bindParam(':quantity', $material->materialQuantity, PDO::PARAM_STR, 40); $stmtInwardDetails->bindParam(':packagedunits', $material->packageUnit, PDO::PARAM_STR, 10); $stmtInwardDetails->bindParam(':size', $material->packagesize, PDO::PARAM_STR, 10); $stmtInwardDetails->bindParam(':lchnguserid', $userId, PDO::PARAM_STR, 10); $stmtInwardDetails->bindParam(':creuserid', $userId, PDO::PARAM_STR, 10); HicreteLogger::logDebug("Query: \n" . json_encode($stmtInwardDetails)); HicreteLogger::logDebug("DATA: \n" . json_encode($material)); if ($stmtInwardDetails->execute()) { $isSuccess = true; HicreteLogger::logInfo("Insertion of Inward Details successful.Updating inventory"); //Check if material already exist in inventory table if yes update else Insert $stmtAvailabiltyCheck = $dbh->prepare("SELECT materialid FROM inventory WHERE materialid=:materialid "); $stmtAvailabiltyCheck->bindParam(':materialid', $material->material, PDO::PARAM_STR, 10); $stmtAvailabiltyCheck->execute(); $count = $stmtAvailabiltyCheck->rowcount(); if ($count != 0) { //UPDATE HicreteLogger::logInfo("Updating inventory"); $stmtInventory = $dbh->prepare("UPDATE inventory SET totalquantity =totalquantity+ :totalquantity,\n warehouseid=:warehouseid,companyid=:companyid\n WHERE materialid = :materialid"); $stmtInventory->bindParam(':totalquantity', $material->materialQuantity, PDO::PARAM_STR, 10); $stmtInventory->bindParam(':warehouseid', $this->warehouse, PDO::PARAM_STR, 10); $stmtInventory->bindParam(':companyid', $this->companyName, PDO::PARAM_STR, 10); $stmtInventory->bindParam(':materialid', $material->material, PDO::PARAM_STR, 10); HicreteLogger::logDebug("Query: \n" . json_encode($stmtInventory)); if ($stmtInventory->execute()) { $isSuccess = true; } else { $isSuccess = false; } } else { //Insert HicreteLogger::logInfo("Inserting to inventory"); $stmtInventory = $dbh->prepare("INSERT INTO inventory (materialid,warehouseid,companyid,totalquantity)\n values (:materialid,:warehouseid,:companyid,:totalquantity)"); $stmtInventory->bindParam(':totalquantity', $material->materialQuantity, PDO::PARAM_STR, 10); $stmtInventory->bindParam(':warehouseid', $this->warehouse, PDO::PARAM_STR, 10); $stmtInventory->bindParam(':companyid', $this->companyName, PDO::PARAM_STR, 10); $stmtInventory->bindParam(':materialid', $material->material, PDO::PARAM_STR, 10); HicreteLogger::logDebug("Query: \n" . json_encode($stmtInventory)); if ($stmtInventory->execute()) { $isSuccess = true; } else { $isSuccess = false; } } } else { $isSuccess = false; } } if ($isSuccess) { $lastInwardDetailsId = $dbh->lastInsertId(); // Insert Data into Transport Details Table if ($this->hasTransportDetails == 'Yes') { HicreteLogger::logInfo("Inserting into transport details "); $stmtTransportDetails = $dbh->prepare("INSERT INTO inward_transportation_details (inwardid,transportationmode,vehicleno,drivername,transportagency,cost,lchnguserid,lchngtime,creuserid,cretime,remark)\n values (:inwardid,:transportationmode,:vehicleno,:drivername,:transportagency,:cost,:lchnguserid,now(),:creuserid,now(),:remark)"); $stmtTransportDetails->bindParam(':inwardid', $lastInwardId, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':transportationmode', $this->transportMode, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':vehicleno', $this->vehicleNumber, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':drivername', $this->driverName, PDO::PARAM_STR, 40); $stmtTransportDetails->bindParam(':transportagency', $this->transportAgency, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':cost', $this->transportCost, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':lchnguserid', $userId, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':creuserid', $userId, PDO::PARAM_STR, 10); $stmtTransportDetails->bindParam(':remark', $this->remark, PDO::PARAM_STR, 10); HicreteLogger::logDebug("Query: \n" . json_encode($stmtTransportDetails)); if ($stmtTransportDetails->execute()) { $lastTransportId = $dbh->lastInsertId(); $this->showAlert('success', "Inward details added Successfully!!!"); $dbh->commit(); //MAP PURCHASE ORDER TO INWARD ENTRY HERE } else { HicreteLogger::logError("Error while adding transport"); $this->showAlert('Failure', "Error while adding transport"); $dbh->rollBack(); } } else { HicreteLogger::logInfo("Inward details added Successfully"); $this->showAlert('success', "Inward details added Successfully!!!"); $dbh->commit(); } } else { HicreteLogger::logError("Error while adding 2nd"); $this->showAlert('Failure', "Error while adding 2nd"); $dbh->rollBack(); } } else { HicreteLogger::logError("Error while adding 1st"); $this->showAlert('Failure', "Error while adding 1st"); $dbh->rollBack(); } } catch (Exception $e) { HicreteLogger::logFatal("Exception occured \n" . $e->getMessage()); echo $e->getMessage(); $dbh->rollBack(); } }
public function deleteApplicator($data, $userId) { $db = Database::getInstance(); $connect = $db->getConnection(); $applicatorId = $data->applicator_id; $stmt1 = $connect->prepare("DELETE FROM `applicator_master` WHERE `applicator_master_id`=:applicatorId"); $stmt1->bindParam(':applicatorId', $applicatorId); if ($stmt1->execute()) { HicreteLogger::logInfo("Applicator deleted successfully"); return true; } else { HicreteLogger::logError("Could Not Delete Applicator"); return false; } }
public function updateProduct($dbh, $userId, $productDetails) { try { //BEGIN THE TRANSACTION $dbh->beginTransaction(); $flag = false; $updatedProductName = $productDetails->productname; $productmasterid = $productDetails->productmasterid; HicreteLogger::logInfo("Updating product"); if ($productDetails->isProductMasterTable) { HicreteLogger::logInfo("Updating product master"); $stmtMasterTable = $dbh->prepare("UPDATE product_master SET productname =:productname,materialtypeid=:materialtypeid,unitofmeasure=:unitofmeasure,lchnguserid=:lchnguserid,lchngtime=now()\n WHERE productmasterid = :productmasterid"); $stmtMasterTable->bindParam(':productname', $updatedProductName, PDO::PARAM_STR, 10); $stmtMasterTable->bindParam(':materialtypeid', $productDetails->materialtypeid, PDO::PARAM_STR, 10); $stmtMasterTable->bindParam(':unitofmeasure', $productDetails->unitofmeasure, PDO::PARAM_STR, 10); $stmtMasterTable->bindParam(':lchnguserid', $userId, PDO::PARAM_STR, 10); $stmtMasterTable->bindParam(':productmasterid', $productmasterid, PDO::PARAM_STR, 10); HicreteLogger::logDebug("Query: \n" . json_encode($stmtMasterTable)); HicreteLogger::logDebug("DATA: \n" . json_encode($productDetails)); if ($stmtMasterTable->execute()) { // $this->showAlert('success',"Inward details updated Successfully!!!"); $flag = true; } else { //$this->showAlert('Failure',"Error while adding"); $flag = false; } } if ($productDetails->isProductDetailsTable) { HicreteLogger::logInfo("Updating product details"); $stmtDetailsTable = $dbh->prepare("UPDATE product_details SET color =:color,description=:description,alertquantity=:alertquantity,\n lchnguserid=:lchnguserid,lchngtime=now()\n WHERE productdetailsid = :productdetailsid"); $stmtDetailsTable->bindParam(':color', $productDetails->color, PDO::PARAM_STR, 10); $stmtDetailsTable->bindParam(':description', $productDetails->description, PDO::PARAM_STR, 10); $stmtDetailsTable->bindParam(':alertquantity', $productDetails->alertquantity, PDO::PARAM_STR, 10); $stmtDetailsTable->bindParam(':lchnguserid', $userId, PDO::PARAM_STR, 10); $stmtDetailsTable->bindParam(':productdetailsid', $productDetails->productdetailsid, PDO::PARAM_STR, 10); HicreteLogger::logDebug("Query: \n" . json_encode($stmtDetailsTable)); HicreteLogger::logDebug("DATA: \n" . json_encode($productDetails)); if ($stmtDetailsTable->execute()) { // $this->showAlert('success',"Inward details updated Successfully!!!"); $flag = true; } else { //$this->showAlert('Failure',"Error while adding"); $flag = false; } } if ($productDetails->isProductPackagingTable) { HicreteLogger::logInfo("Updating product packaging"); $stmtPackagingTable = $dbh->prepare("UPDATE product_packaging SET packaging =:packaging, lchnguserid=:lchnguserid,lchngtime=now()\n WHERE productpackagingid = :productpackagingid"); $stmtPackagingTable->bindParam(':packaging', $productDetails->packaging, PDO::PARAM_STR, 10); $stmtPackagingTable->bindParam(':lchnguserid', $userId, PDO::PARAM_STR, 10); $stmtPackagingTable->bindParam(':productpackagingid', $productDetails->productpackagingid, PDO::PARAM_STR, 10); HicreteLogger::logDebug("Query: \n" . json_encode($stmtPackagingTable)); HicreteLogger::logDebug("DATA: \n" . json_encode($productDetails)); if ($stmtPackagingTable->execute()) { // $this->showAlert('success',"Inward details updated Successfully!!!"); $flag = true; } else { // $this->showAlert('Failure',"Error while adding"); $flag = false; } } if ($productDetails->isProductMaterialTable) { HicreteLogger::logInfo("Updating material"); $stmtMaterialTable = $dbh->prepare("UPDATE material SET abbrevation =:abbrevation, lchnguserid=:lchnguserid,lchngtime=now()\n WHERE materialid = :materialid"); $stmtMaterialTable->bindParam(':abbrevation', $productDetails->abbrevation, PDO::PARAM_STR, 10); $stmtMaterialTable->bindParam(':lchnguserid', $userId, PDO::PARAM_STR, 10); $stmtMaterialTable->bindParam(':materialid', $productDetails->materialid, PDO::PARAM_STR, 10); HicreteLogger::logDebug("Query: \n" . json_encode($stmtMaterialTable)); HicreteLogger::logDebug("DATA: \n" . json_encode($productDetails)); if ($stmtMaterialTable->execute()) { // $this->showAlert('success',"Inward details updated Successfully!!!"); $flag = true; } else { // $this->showAlert('Failure',"Error while adding"); $flag = false; } } if ($flag) { // $this->showAlert('success',"Inward details updated Successfully!!!"); if ($dbh->commit()) { HicreteLogger::logInfo("Product updated successfully"); $this->showAlert('success', "Product Updated Successfully!!!"); } else { $this->showAlert('success', "Commit failed!!"); } } else { HicreteLogger::logError("Error while updating product"); $this->showAlert('Failure', "Error while Updating"); $dbh->rollBack(); } } catch (Exception $e) { HicreteLogger::logFatal("Exception occured :\n" . $e->getMessage()); $this->showAlert('Failure', "Exception occured please contact admin"); } }
public static function modifyUserDetails($data) { try { HicreteLogger::logInfo("Modifying user"); $db = Database::getInstance(); $conn = $db->getConnection(); $conn->beginTransaction(); $date = new DateTime($data->userInfo->newDate); $dob = $date->format('Y-m-d'); $userId = $data->userInfo->userId; $stmt = $conn->prepare("UPDATE usermaster SET firstName=:firstName,\n lastName=:lastName,dateOfBirth=:dateOfBirth,address=:address,city=:city,state=:state,country=:country,pincode=:pincode,mobileNumber=:mobileNumber,lastModifiedBy=:lastModifiedBy,lastModificationDate=now(),profilePicPath=:profilePicPath WHERE userId = :userId"); $stmt->bindParam(':firstName', $data->userInfo->firstName, PDO::PARAM_STR); $stmt->bindParam(':lastName', $data->userInfo->lastName, PDO::PARAM_STR); $stmt->bindParam(':dateOfBirth', $dob, PDO::PARAM_STR); $stmt->bindParam(':address', $data->userInfo->address, PDO::PARAM_STR); $stmt->bindParam(':city', $data->userInfo->city, PDO::PARAM_STR); $stmt->bindParam(':state', $data->userInfo->state, PDO::PARAM_STR); $stmt->bindParam(':country', $data->userInfo->country, PDO::PARAM_STR); $stmt->bindParam(':pincode', $data->userInfo->pincode, PDO::PARAM_STR); $stmt->bindParam(':mobileNumber', $data->userInfo->mobileNumber, PDO::PARAM_STR); $stmt->bindParam(':lastModifiedBy', $userId, PDO::PARAM_STR); $stmt->bindParam(':userId', $userId, PDO::PARAM_STR); $stmt->bindParam(':profilePicPath', $data->userInfo->profilePic, PDO::PARAM_STR); HicreteLogger::logDebug("Query:\n " . json_encode($stmt)); HicreteLogger::logDebug("Data:\n " . json_encode($data)); if ($stmt->execute()) { $conn->commit(); HicreteLogger::logInfo("Profile modified successfully"); echo "Profile Modified successfully"; } else { HicreteLogger::logError("Failure in updating user details"); echo "Something went wrong.Please try again"; } } catch (Exception $e) { HicreteLogger::logFatal("Exception Occured Message:\n" . $e->getMessage()); echo $e->getMessage(); } }