public function CreateSiteTrackingFollowup($projectId, $data, $userId) { try { if (Followup::CreateSiteTrackingFollowup($projectId, $data, $userId)) { echo AppUtil::getReturnStatus("Successful", "Conduction Successful"); } else { echo AppUtil::getReturnStatus("Unsuccessful", "Database Error Occurred"); } } catch (Exception $e) { echo AppUtil::getReturnStatus("Unsuccessful", $e->getMessage()); } }
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; }