public static function saveCustomer($data, $userId) { $custnum = AppUtil::generateId(); $object = array(); $t = time(); $current = date("Y-m-d", $t); $isDeleted = '0'; $pincode = ""; //echo "nside save customer"; //echo json_encode($data); //echo json_encode($data); $db = Database::getInstance(); $conn = $db->getConnection(); $stmt = $conn->prepare("SELECT `CustomerName` FROM `customer_master` WHERE `CustomerName`=:customerName"); $stmt->bindParam(':customerName', $data->customer_name, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_ASSOC); if (count($result) > 0) { return 2; } $stmt = $conn->prepare("INSERT INTO customer_master (CustomerId,CustomerName,Address,City,State,Country,Pincode,Mobileno,Landlineno,FaxNo,EmailId,isDeleted,CreationDate,CreatedBy,LastModificationDate,LastModifiedBy,VATNo,CSTNo,PAN,ServiceTaxNo) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); if ($stmt->execute([$custnum, $data->customer_name, $data->customer_address, $data->customer_city, $data->customer_state, $data->customer_country, $pincode, $data->customer_phone, $data->customer_landline, $data->customer_faxNo, $data->customer_emailId, $isDeleted, $current, $userId, $current, $userId, $data->customer_vatNo, $data->customer_cstNo, $data->customer_panNo, $data->customer_serviceTaxNo]) === TRUE) { //echo "\nit true"; return 1; } else { //echo "\n its false"; return 0; } $conn = null; }
public function saveUser($data) { $usernum = AppUtil::generateId(); try { $db = Database::getInstance(); $conn = $db->getConnection(); $conn->beginTransaction(); $stmt = $conn->prepare("INSERT INTO usermaster(UserId, FirstName, LastName, isDeleted) VALUES(?,?,?,?)"); if ($stmt->execute([$usernum, $data->FirstName, $data->LastName, 0]) === TRUE) { $conn->commit(); return "User created succesfully "; } else { return "Error in user creation"; } } catch (PDOException $e) { echo $e->getMessage(); $conn->rollBack(); } $conn = null; }
public static function saveTask($data) { if (!isset($_SESSION['token'])) { session_start(); } $userId = $_SESSION['token']; $taskId = AppUtil::generateId(); try { $db = Database::getInstance(); $conn = $db->getConnection(); $conn->beginTransaction(); $stmt = $conn->prepare("INSERT INTO task_master (TaskID,TaskName, TaskDescripion, ScheduleStartDate, ScheduleEndDate, CompletionPercentage, TaskAssignedTo, isCompleted, CreationDate, CreatedBy) VALUES(?,?,?,?,?,?,?,?,?,?)"); if ($stmt->execute([$taskId, $data->TaskName, $data->TaskDescripion, $data->ScheduleStartDate, $data->ScheduleEndDate, $data->CompletionPercentage, $data->TaskAssignedTo, $data->isCompleted, $data->CreationDate, $userId]) === TRUE) { $conn->commit(); return "Task created successfully"; } else { return "Task creation Failed.."; } } catch (PDOException $e) { echo $e->getMessage(); $conn->rollBack(); } $db = null; }
public function CreateApplicatorFollowup($ApplicatorId, $data, $userId) { $FollowupId = AppUtil::generateId(); $t = time(); $current = date("Y-m-d", $t); $db = Database::getInstance(); $conn = $db->getConnection(); $conn->beginTransaction(); $stmt = $conn->prepare("INSERT INTO applicator_follow_up(date_of_follow_up,last_modification_date,last_modified_by,created_by,creation_date,enrollment_id, `followup_title`,`assignEmployeeId`)\n VALUES (:followupDate,NOW(),:lastModifiedBy,:createdBy,NOW(),:lastEnrollmentId ,:followupTitle ,:assignEmployeeId)"); $stmt->bindParam(':followupDate', $data->FollowupDate); $stmt->bindParam(':lastEnrollmentId', $ApplicatorId); $stmt->bindParam(':lastModifiedBy', $userId); $stmt->bindParam(':createdBy', $userId); $stmt->bindParam(':followupTitle', $data->FollowupTitle); $stmt->bindParam(':assignEmployeeId', $data->AssignEmployee); if ($stmt->execute()) { $conn->commit(); return true; } else { $conn->rollBack(); return false; } }
public static function addTempAcccessRequest($data, $userId) { try { $db = Database::getInstance(); $conn = $db->getConnection(); $conn->beginTransaction(); HicreteLogger::logInfo("Adding temp access request"); $requestId = AppUtil::generateId(); $stmt = $conn->prepare("INSERT INTO `tempaccessrequest`(`requestId`, `requestedBy`, `fromDate`, `toDate`, `description`, `status`, `requestDate`) \n VALUES (:requestId,:requestedBy,:fromDate,:toDate,:description,'Pending',now())"); $stmt->bindParam(':requestId', $requestId, PDO::PARAM_STR); $stmt->bindParam(':requestedBy', $userId, PDO::PARAM_STR); $date = new DateTime($data->accessRequest->fromDate); $fromDate = $date->format('Y-m-d H:i:s'); $stmt->bindParam(':fromDate', $fromDate, PDO::PARAM_STR); $date = new DateTime($data->accessRequest->toDate); $toDate = $date->format('Y-m-d H:i:s'); $stmt->bindParam(':toDate', $toDate, PDO::PARAM_STR); $stmt->bindParam(':description', $data->accessRequest->description, PDO::PARAM_STR); $rollback = false; HicreteLogger::logDebug("Query:\n " . json_encode($stmt)); HicreteLogger::logDebug("Data:\n " . json_encode($data)); if ($stmt->execute()) { foreach ($data->accessList as $accessEntry) { if ($accessEntry->read->val) { if (!ConfigUtils::insertRequestedAccess($conn, $requestId, $accessEntry->read->accessId)) { $rollback = true; } } if ($accessEntry->write->val) { if (!ConfigUtils::insertRequestedAccess($conn, $requestId, $accessEntry->write->accessId)) { $rollback = true; } } } } else { HicreteLogger::logError("Unknown databse error occured"); echo AppUtil::getReturnStatus("Unsuccessful", "Unknown database error occurred"); } if ($rollback) { $conn->rollback(); HicreteLogger::logError("Unknown databse error occured"); echo AppUtil::getReturnStatus("Unsuccessful", "Unknown database error occurred"); } else { $conn->commit(); HicreteLogger::logInfo("Access request added"); echo AppUtil::getReturnStatus("Successful", "Access Request Added"); } } catch (Exception $e) { HicreteLogger::logFatal("Exception Occured Message:\n" . $e->getMessage()); echo AppUtil::getReturnStatus("Exception", "Exception Occurred while requesting access"); } }
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()); } }
public static function saveQuotationDetailsAndTax($data) { $QuotationId = AppUtil::generateId(); $quotation = $data->Quotation; $quotationBasicDetails = $data->Details; $quotationTaxDetails = $data->taxDetails; $detailIdArray = []; $quotationIndex = []; $db = Database::getInstance(); $conn = $db->getConnection(); $conn->beginTransaction(); $date1 = new DateTime($quotation->DateOfQuotation); $quotationDate = $date1->format('Y-m-d'); $stmt = $conn->prepare("INSERT INTO quotation(QuotationId, QuotationTitle, RefNo, DateOfQuotation, Subject, ProjectId, CompanyId, QuotationBlob, isApproved, isDeleted) VALUES(?,?,?,?,?,?,?,?,?,?);"); if ($stmt->execute([$QuotationId, $quotation->QuotationTitle, $quotation->RefNo, $quotationDate, $quotation->Subject, $quotation->ProjectId, $quotation->CompanyId, $quotation->QuotationBlob, 0, 0]) === TRUE) { for ($i = 0; $i < sizeof($quotationBasicDetails); $i++) { $DetailId = AppUtil::generateId(); $stmt1 = $conn->prepare("INSERT INTO quotation_details(DetailID, QuotationId, Title, Description, Quantity, UnitRate, Amount, DetailNo,unit) VALUES(?,?,?,?,?,?,?,?,?)"); if ($stmt1->execute([$DetailId, $QuotationId, $quotationBasicDetails[$i]->quotationItem, $quotationBasicDetails[$i]->quotationDescription, $quotationBasicDetails[$i]->quotationQuantity, $quotationBasicDetails[$i]->quotationUnitRate, $quotationBasicDetails[$i]->amount, $i + 1, $quotationBasicDetails[$i]->quotationUnit]) === TRUE) { //$detailIdArray.push($DetailId); array_push($detailIdArray, $DetailId); array_push($quotationIndex, $i + 1); } else { $conn->rollBack(); return false; } } for ($tx = 0; $tx < sizeof($quotationTaxDetails); $tx++) { $TaxId = AppUtil::generateId(); $stmt2 = $conn->prepare("INSERT INTO quotation_tax_details(TaxID, QuotationId, TaxName, TaxPercentage, TaxAmount) VALUES(?,?,?,?,?)"); if ($stmt2->execute([$TaxId, $QuotationId, $quotationTaxDetails[$tx]->taxTitle, $quotationTaxDetails[$tx]->taxPercentage, $quotationTaxDetails[$tx]->amount]) === TRUE) { for ($s = 0; $s < sizeof($quotationTaxDetails[$tx]->taxArray); $s++) { for ($qut = 0; $qut < sizeof($quotationIndex); $qut++) { if ($quotationTaxDetails[$tx]->taxArray[$s] === $quotationIndex[$qut]) { $stmt3 = $conn->prepare("INSERT INTO quotation_tax_applicable_to(TaxID, DetailsID) VALUES(?,?)"); if ($stmt3->execute([$TaxId, $detailIdArray[$qut]]) === FALSE) { $conn->rollBack(); return false; } } } } } else { $conn->rollBack(); return false; } } } $conn->commit(); return true; }
public function createLeave($data) { $db = Database::getInstance(); $connect = $db->getConnection(); $applicationId = AppUtil::generateId(); $leaveAppliedBy = $data->userId; $date1 = new DateTime($data->fromDate); $fromDate = $date1->format('Y-m-d'); $date2 = new DateTime($data->toDate); $toDate = $date2->format('Y-m-d'); $noOfLeaves = $data->numberOfLeaves; $typeOfLeave = $data->typeofLeave; $reason = $data->description; $status = $data->status; $actionDate = "null"; $actionBy = "null"; HicreteLogger::logInfo("Creating leaves"); try { $stmt1 = $connect->prepare("INSERT INTO leave_application_master(application_id,leave_applied_by,from_date,to_date,type_of_leaves,no_of_leaves,reason,status,application_date,action_by,action_date)\n VALUES(:applicationId,:leaveAppliedBy,:fromDate,:toDate,:type_of_leaves,:no_of_leaves,:reason,:status,NOW(),:actionBy,:actionDate)"); $stmt1->bindParam(':applicationId', $applicationId); $stmt1->bindParam(':leaveAppliedBy', $leaveAppliedBy); $stmt1->bindParam(':fromDate', $fromDate); $stmt1->bindParam('toDate', $toDate); $stmt1->bindParam('type_of_leaves', $typeOfLeave); $stmt1->bindParam('no_of_leaves', $noOfLeaves); $stmt1->bindParam(':reason', $reason); $stmt1->bindParam(':status', $status); $stmt1->bindParam(':actionDate', $actionDate); $stmt1->bindParam(':actionBy', $actionBy); HicreteLogger::logDebug("query: \n" . json_encode($stmt1)); HicreteLogger::logDebug("Data: \n" . json_encode($data)); if ($stmt1->execute()) { HicreteLogger::logInfo("Creation of leaves successful "); return true; } else { HicreteLogger::logError("Creation of leaves failed "); return false; } } catch (Exception $e) { HicreteLogger::logFatal("Exception Occured Message:\n" . $e->getMessage()); $message = "Exception Occur While Creating Leave...!!!"; $arr = array('msg' => '', 'error' => $message); $jsn = json_encode($arr); echo $jsn; } }
public static function saveProject($data, $userId) { $projnum = AppUtil::generateId(); $projectBasicDetails = $data->projectDetails; $t = time(); $current = date("Y-m-d", $t); $object = array(); $rollBack = true; $db = Database::getInstance(); $conn = $db->getConnection(); $conn->beginTransaction(); $stmt = $conn->prepare("SELECT `ProjectName` FROM `project_master` WHERE `ProjectName`= :projectName"); $stmt->bindParam(':projectName', $projectBasicDetails->ProjectName, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_ASSOC); if (count($result) > 0) { return 2; } $stmt = $conn->prepare("INSERT INTO project_master (ProjectId, ProjectName, ProjectManagerId, ProjectSource, IsSiteTrackingProject, ProjectStatus, CustomerId, IsClosedProject, isDeleted, CreationDate, CreatedBy, LastModificationDate, LastModifiedBy)\n\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)"); if ($stmt->execute([$projnum, $projectBasicDetails->ProjectName, $projectBasicDetails->ProjectManagerId, $projectBasicDetails->ProjectSource, '0', 'Initiated', $projectBasicDetails->CustomerId, '0', '0', $current, $userId, $current, $userId]) === TRUE) { $stmt2 = $conn->prepare("INSERT INTO project_address_details (ProjectId, Address, City, State, Country, Pincode) VALUES (?,?,?,?,?,?)"); if ($stmt2->execute([$projnum, $projectBasicDetails->Address, $projectBasicDetails->City, $projectBasicDetails->State, $projectBasicDetails->Country, $projectBasicDetails->Pincode]) === TRUE) { $stmt3 = $conn->prepare("INSERT INTO project_point_of_contact_details (ProjectId, PointContactName, MobileNo, LandlineNo, EmailId) VALUES (?,?,?,?,?)"); if ($stmt3->execute([$projnum, $projectBasicDetails->PointContactName, $projectBasicDetails->MobileNo, $projectBasicDetails->LandlineNo, $projectBasicDetails->EmailId]) === TRUE) { $break = false; foreach ($data->companiesInvolved as $company) { $stmt4 = $conn->prepare("INSERT INTO companies_involved_in_project (ProjectID, CompanyID) VALUES (?,?)"); if (!$stmt4->execute([$projnum, $company->companyId])) { throw new Exception($stmt4->errorInfo); $break = true; break; } } if (!$break) { $conn->commit(); $rollBack = false; if (isset($data->followupData)) { if (Followup::CreateSiteTrackingFollowup($projnum, $data->followupData, $userId)) { // echo AppUtil::getReturnStatus("Successful", "Conduction Successful"); } else { // echo AppUtil::getReturnStatus("Unsuccessful", "Database Error Occurred"); } } } } else { throw new Exception($stmt3->errorInfo); } } else { throw new Exception($stmt2->errorInfo); } } else { throw new Exception($stmt->errorInfo); } if ($rollBack) { $conn->rollBack(); return 0; } $conn = null; return 1; }
public static function modifyInvoice($conn, $data, $invoiceNo) { $main = $data->Invoice; $InvoicebasicDetails = $data->Details; $invoiceTaxDetails = $data->taxDetails; $detailIdArray = []; $invoiceIndex = []; $date1 = new DateTime($main->InvoiceDate); $invoiceDate = $date1->format('Y-m-d'); $stmt = $conn->prepare("UPDATE `invoice` SET `InvoiceNo`=:newInvoiceNo ,`InvoiceDate`=:invoiceDate,`InvoiceTitle`=:title,`TotalAmount`=:totalAmount,`RoundingOffFactor`=:roundOff,`GrandTotal`=:grandTotal,`InvoiceBLOB`=:invoiceBlob,`PurchasersVATNo`=:purchaserVatNo,`PAN`=:pan,`ContactPerson`=:contactPerson WHERE `InvoiceNo`=:oldInvoiceNo"); $stmt->bindparam(':invoiceDate', $invoiceDate, PDO::PARAM_STR); $stmt->bindparam(':title', $main->InvoiceTitle, PDO::PARAM_STR); $stmt->bindparam(':totalAmount', $main->TotalAmount, PDO::PARAM_STR); $stmt->bindparam(':roundOff', $main->RoundingOffFactor, PDO::PARAM_STR); $stmt->bindparam(':grandTotal', $main->GrandTotal, PDO::PARAM_STR); $stmt->bindparam(':invoiceBlob', $main->InvoiceBLOB, PDO::PARAM_STR); $stmt->bindparam(':purchaserVatNo', $main->PurchasersVATNo, PDO::PARAM_STR); $stmt->bindparam(':pan', $main->PAN, PDO::PARAM_STR); $stmt->bindparam(':contactPerson', $main->ContactPerson, PDO::PARAM_STR); $stmt->bindparam(':newInvoiceNo', $main->InvoiceNo, PDO::PARAM_STR); $stmt->bindparam(':oldInvoiceNo', $invoiceNo, PDO::PARAM_STR); if ($stmt->execute() === TRUE) { for ($i = 0; $i < sizeof($InvoicebasicDetails); $i++) { $DetailId = AppUtil::generateId(); $stmt1 = $conn->prepare("INSERT INTO invoice_details(DetailID, InvoiceId, DetailNo, Title, Description, Quantity, UnitRate, Amount,unit) VALUES(?,?,?,?,?,?,?,?,?)"); if ($stmt1->execute([$DetailId, $main->InvoiceNo, $i + 1, $InvoicebasicDetails[$i]->quotationItem, $InvoicebasicDetails[$i]->quotationDescription, $InvoicebasicDetails[$i]->quotationQuantity, $InvoicebasicDetails[$i]->quotationUnitRate, $InvoicebasicDetails[$i]->amount, $InvoicebasicDetails[$i]->quotationUnit]) === TRUE) { array_push($detailIdArray, $DetailId); array_push($invoiceIndex, $i + 1); } else { return false; } } for ($tx = 0; $tx < sizeof($invoiceTaxDetails); $tx++) { $TaxId = AppUtil::generateId(); $stmt2 = $conn->prepare("INSERT INTO invoice_tax_details(TaxId, InvoiceId, TaxName, TaxPercentage, TaxAmount) VALUES(?,?,?,?,?)"); if ($stmt2->execute([$TaxId, $main->InvoiceNo, $invoiceTaxDetails[$tx]->taxTitle, $invoiceTaxDetails[$tx]->taxPercentage, $invoiceTaxDetails[$tx]->amount]) === TRUE) { for ($s = 0; $s < sizeof($invoiceTaxDetails[$tx]->taxArray); $s++) { for ($qut = 0; $qut < sizeof($invoiceIndex); $qut++) { if ($invoiceTaxDetails[$tx]->taxArray[$s] === $invoiceIndex[$qut]) { $stmt3 = $conn->prepare("INSERT INTO invoice_tax_applicable_to(TaxId, DetailsId) VALUES(?,?)"); if ($stmt3->execute([$TaxId, $detailIdArray[$qut]]) === FALSE) { return false; } } } } } else { return false; } } } else { return false; } return true; }
public static function addUser($data, $requestUserId) { try { $db = Database::getInstance(); $conn = $db->getConnection(); if (Config::isUserAvailable($data->userInfo->email)) { $conn->beginTransaction(); $password = ""; $userId = AppUtil::generateId(); $date = new DateTime($data->userInfo->dob); $dob = $date->format('Y-m-d'); $stmt = $conn->prepare("INSERT INTO `usermaster`(`userId`, `firstName`, `lastName`, `dateOfBirth`, `address`, `city`, `state`, `country`, `pincode`, `mobileNumber`, `emailId`, `createdBy`, `creationDate`, `lastModifiedBy`, `lastModificationDate`)\n VALUES (:userId,:firstName,:lastName,:dob,:address,:city,:state,:country,:pincode,:mobileNumber,:emailId,:createdBy,now(),:lastModifiedBy,now())"); $stmt->bindParam(':userId', $userId, PDO::PARAM_STR); $stmt->bindParam(':firstName', $data->userInfo->firstName, PDO::PARAM_STR); $stmt->bindParam(':lastName', $data->userInfo->lastName, PDO::PARAM_STR); $stmt->bindParam(':dob', $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->mobile, PDO::PARAM_STR); $stmt->bindParam(':emailId', $data->userInfo->email, PDO::PARAM_STR); $stmt->bindParam(':createdBy', $requestUserId, PDO::PARAM_STR); $stmt->bindParam(':lastModifiedBy', $requestUserId, PDO::PARAM_STR); $rollback = false; HicreteLogger::logDebug("Query:\n " . json_encode($stmt)); HicreteLogger::logDebug("Data:\n " . json_encode($data)); if ($stmt->execute()) { if (!Config::insertRoleInfo($conn, $userId, $data->userInfo->designation, $data->roleId, $data->userInfo->userType, $requestUserId)) { $rollback = true; } else { // foreach ($data->accessPermissions as $accessEntry) { // if ($accessEntry->read->ispresent) { // if (!Config::insertUserAccessPermission($conn, $userId, $requestUserId, $accessEntry->read->accessId)) { // $rollback = true; // // break; // } // // } // // if ($accessEntry->write->ispresent) { // if (!Config::insertUserAccessPermission($conn, $userId, $requestUserId, $accessEntry->write->accessId)) { // $rollback = true; // // break; // } // } // } //if (!$rollback) { $str = $data->userInfo->email . $userId; $stmt = $conn->prepare("INSERT INTO `logindetails`(`userId`, `userName`, `password`) \n VALUES (:userId,:userName,:password)"); $stmt->bindParam(':userId', $userId, PDO::PARAM_STR); $stmt->bindParam(':userName', $data->userInfo->email, PDO::PARAM_STR); $password = mt_rand(1000000, 9999999); $hash = sha1($password); $stmt->bindParam(':password', $hash, PDO::PARAM_STR); HicreteLogger::logDebug("Query:\n " . json_encode($stmt)); if (!$stmt->execute()) { $rollback = true; } //} } } else { HicreteLogger::logError("Unknown Database error occured "); echo AppUtil::getReturnStatus("Unsuccessful", "Unknown database error occurred"); } if ($rollback) { $conn->rollback(); HicreteLogger::logError("Unknown Database error occured "); echo AppUtil::getReturnStatus("Unsuccessful", "Unknown database error occurred"); } else { $conn->commit(); HicreteLogger::logInfo("User added successfully"); echo AppUtil::getReturnStatus("Successful", $password); AppUtil::sendMail($data->userInfo->email, $password, $data->userInfo->email, $data->userInfo->firstName); } } else { HicreteLogger::logError("user already available"); echo AppUtil::getReturnStatus("Unsuccessful", "User Already Available"); } } catch (Exception $e) { HicreteLogger::logFatal("Exception Occured Message:\n" . $e->getMessage()); echo AppUtil::getReturnStatus("Exception", "Exception Occurred while creating role"); } }
public function savePayment($data) { $invoiceNo = AppUtil::generateId(); $paymentId = AppUtil::generateId(); $object = array(); try { $db = Database::getInstance(); $conn = $db->getConnection(); $conn->beginTransaction(); $stmt = $conn->prepare("INSERT INTO invoice(InvoiceNo, QuotationId, InvoiceDate, InvoiceTitle, TotalAmount, RoundingOffFactor, GrandTotal, InvoiceBLOB, isPaymentRetention, PurchasersVATNo, PAN, CreatedBy) VALUES(?,?,?,?,?,?,?,?,?,?,?,?);"); if ($stmt->execute([$invoiceNo, $data->QuotationId, $data->InvoiceDate, $data->InvoiceTitle, $data->TotalAmount, $data->RoundingOffFactor, $data->GrandTotal, $data->InvoiceBLOB, $data->isPaymentRetention, $data->PurchasersVATNo, $data->PAN, $data->CreatedBy]) === TRUE) { $stmt2 = $conn->prepare("INSERT INTO project_payment(PaymentId, InvoiceNo, AmountPaid, PaymentDate, IsCashPayment, PaidTo) VALUES(?,?,?,?,?,?)"); if ($stmt2->execute([$paymentId, $invoiceNo, $data->AmountPaid, $data->PaymentDate, $data->IsCashPayment, $data->PaidTo]) === TRUE) { $stmt3 = $conn->prepare("INSERT INTO project_payment_mode_details(PaymentId, InstrumentOfPayment, IDOfInstrument, BankName, City) VALUES(?,?,?,?,?)"); if ($stmt3->execute([$paymentId, $data->InstrumentOfPayment, $data->IDOfInstrument, $data->BankName, $data->City]) === TRUE) { $conn->commit(); return "Payment creted succcesfully.."; } else { $conn->rollBack(); return "Error while creating payment in stmt3"; } } else { $conn->rollBack(); return "ERROR i cration of payment in stmt2"; } } else { $conn->rollBack(); return "Error in creation of invoice "; } } catch (PDOException $e) { echo $e->getMessage(); $conn->rollBack(); } $conn = null; }