$retVal = array(false, "Data not inserted"); // insert/update the data $retVal = updateObjectReturnID($fundingObj); //error_log("Funding: " .$retVal); $validated = $retVal[0]; // set the return codes and messages if ($retVal[0]) { // init the return code $retVal = array(false, "Data not inserted"); if ($companyObj) { $retVal = updateObjectReturnID($companyObj); $validated = $retVal[0]; } if ($retVal[0]) { if ($financingObj) { $retVal = updateObjectReturnID($financingObj); $validated = $retVal[0]; } if ($retVal[0]) { $validationMessage = "Update successful."; } } } } // if we came in with a funding ID if (isset($FundingID) && !empty($FundingID) && (isset($CompanyID) && !empty($CompanyID))) { //error_log("CompanyID Beforehand: " .$CompanyID); // get the founder data $funding = doGetAllFundingInformation($FundingID, $CompanyID); //error_log(print_r($funding)); // save the data in local variables for the form
// get the founder object definition loaded include_once "Founder.cls.php"; // create a new founder object $founder = new Founder(); // load the founder object $founder->FirstName = sqlEscapeString($FirstName); $founder->LastName = sqlEscapeString($LastName); $founder->MidInitial = sqlEscapeString($MidInitial); $founder->CompanyName = sqlEscapeString($CompanyName); $founder->LastUpdatedBy = $userInfo->ID; // include the data access class include_once "SQLUtils.php"; // init the return code $retVal = array(false, "Data not inserted"); // insert the data $retVal = updateObjectReturnID($founder); // set the return codes and messages $validated = $retVal[0]; $validationMessage = $retVal[1]; // clear out for the next run $FirstName = ''; $LastName = ''; $MidInitial = ''; // redirect to the company detail page header("Location: FounderDetails.php?FounderID=" . $retVal[1]); die; } else { // set the return codes and messages $validated = false; $validationMessage = 'Insertion of founder "' . $FirstName . ' ' . $MidInitial . ' ' . $LastName . '" was not successful because duplicates were detected.</br></br>'; // save the duplicate founder message
$companyObj->AffiliationID = nullpulldown($AffiliationID); $companyObj->EntryType = sqlEscapeString($EntryType); $companyObj->TLOSource = sqlEscapeString($TLOSource); $companyObj->TLOAffiliation = sqlEscapeString($TLOAffiliation); $companyObj->IFUniAffiliation = sqlEscapeString($IFUniAffiliation); $companyObj->RTPAnchor = sqlEscapeString($RTPAnchor); $companyObj->EstaEntryLoc = sqlEscapeString($EstaEntryLoc); $companyObj->EntryTypeSource = sqlEscapeString($EntryTypeSource); $companyObj->EstEntryLocationSource = sqlEscapeString($EstEntryLocationSource); $companyObj->CompanyAddressSource = sqlEscapeString($CompanyAddressSource); // include the data access class include_once "SQLUtils.php"; // init the return code $retVal = array(false, "Data not inserted"); // insert/update the data $retVal = updateObjectReturnID($companyObj); // set the return codes and messages $validated = $retVal[0]; $validationMessage = "Update successful."; } // if we camne in with a company ID if (isset($CompanyID) && !empty($CompanyID)) { // get the data $company = doGetCompany($CompanyID); // did we get a company back if (isset($company) && !empty($company)) { // save the data in local variables for the form $CompanyName = $company[0]->CompanyName; $Establishment = $company[0]->Establishment; $Website = $company[0]->Website; $SOSID = $company[0]->SOSID;
$acquisitionObj = new Acquisition(); // load the founder object with the page parameters $acquisitionObj->AcquisitionID = sqlEscapeString($AcquisitionID); $acquisitionObj->CompanyID = sqlEscapeString($CompanyID); $acquisitionObj->Date = sqlEscapeString($Date); $acquisitionObj->Amount = sqlEscapeString($Amount); $acquisitionObj->Source = sqlEscapeString($Source); // if the user added a suffix save it //if($Suffix != "-1") //$founderObj->Suffix = $Suffix; // include the data access class include_once "SQLUtils.php"; // init the return code $retVal = array(false, "Data not inserted"); // insert/update the data $retVal = updateObjectReturnID($acquisitionObj); //error_log(print_r($retVal)); // set the return codes and messages $validated = $retVal[0]; // updateObjectReturnID returns an id. so set update successful text if so if ($validated) { $validationMessage = "Update successful"; } else { $validationMessage = "Error"; } } // if we came in with a acquisition ID if (isset($AcquisitionID) && !empty($AcquisitionID)) { // get the acquisition data $acquisition = doGetAcquisition($AcquisitionID); // save the data in local variables for the form
// load the founder object with the page parameters $mergerObj->MergerID = sqlEscapeString($MergerID); $mergerObj->CompanyID = sqlEscapeString($CompanyID); $mergerObj->StateID = sqlEscapeString($StateID); $mergerObj->Date = sqlEscapeString($Date); $mergerObj->Amount = sqlEscapeString($Amount); $mergerObj->Source = sqlEscapeString($Source); // if the user added a suffix save it //if($Suffix != "-1") //$founderObj->Suffix = $Suffix; // include the data access class include_once "SQLUtils.php"; // init the return code $retVal = array(false, "Data not inserted"); // insert/update the data $retVal = updateObjectReturnID($mergerObj); // set the return codes and messages $validated = $retVal[0]; // updateObjectReturnID returns an id. so set update successful text if so if ($validated) { $validationMessage = "Update successful"; } else { $validationMessage = "Error"; } } // if we came in with a merger ID if (isset($MergerID) && !empty($MergerID)) { // get the event data $merger = doGetMerger($MergerID); // save the data in local variables for the form $CompanyID = $merger[0]->CompanyID;
$eventObj->S8 = sqlEscapeString($S8); $eventObj->S9 = sqlEscapeString($S9); $eventObj->S10 = sqlEscapeString($S10); $eventObj->S11 = sqlEscapeString($S11); $eventObj->S12 = sqlEscapeString($S12); $eventObj->S13 = sqlEscapeString($S13); $eventObj->S14 = sqlEscapeString($S14); // if the user added a suffix save it //if($Suffix != "-1") //$founderObj->Suffix = $Suffix; // include the data access class include_once "SQLUtils.php"; // init the return code $retVal = array(false, "Data not inserted"); // insert/update the data $retVal = updateObjectReturnID($eventObj); //error_log(print_r($retVal)); // set the return codes and messages $validated = $retVal[0]; // updateObjectReturnID returns an id. so set update successful text if so if ($validated) { $validationMessage = "Update successful"; } else { $validationMessage = "Error"; } } // if we came in with a event ID if (isset($EID) && !empty($EID)) { // get the event data $event = doGetEvent($EID); // save the data in local variables for the form