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