// include the site constants
include_once "Constants.php";
// include the for parameter helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// include the pulldown helpers
include_once "Pulldown.php";
// get the user session helper object
include_once 'UserHelper.php';
// include the dump utils
include_once 'DumpUtils.php';
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed or poosible funding info
getExtraParams(array("CompanyID", "MergerID", "Refresh", "FundingID", "AddMerger", "Source", "StateID", "State", "Amount", "Date", "Source", "Remove"));
// did we get a company name
if (isset($CompanyID)) {
    // get the company name
    $companyName = getCompanyName($CompanyID);
    // set the title name to be displayed in the header
    $title = "Merger data for company: " . $companyName;
} else {
    $title = "Merger data";
}
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"CompanyMerger.js\" />";
// is this a post to add a new funding
if (isset($AddMerger)) {
    // validation
    if (isset($CompanyID) && !empty($CompanyID)) {

 */
// include the site constants
include_once "Constants.php";
// include the for parameter helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// get the user session helper object
include_once 'UserHelper.php';
// get the user info object from the session
$userInfo = getUserSessionObj();
// init the validation variables
$validationMessage = 'Functionality not implemented yet';
$validated = true;
// get whether they clicked proceed or possible company info
getExtraParams(array("Refresh"));
// set the title name to be displayed in the header
$title = "Executive data";
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"Executive.js\" />";
// output the basic header HTML
include "../Includes/header.php";
// message for the user on post operations
if (isset($validationMessage) && !empty($validationMessage)) {
    echo '<div class="' . ($validated == true ? 'info' : 'err') . '">' . $validationMessage . '</div>';
}
// create a new form
echo '<form action="Executive.php" method="post">';
// create the section header
echo '<div class="row show-grid">';
// create grid column

// get the dump utils
include_once 'DumpUtils.php';
// include the founder object
include_once "Funding.cls.php";
include_once "Financing.cls.php";
include_once "Company.cls.php";
// include the pulldown helper funcs
include_once "Pulldown.php";
$scripts = "<script type=\"text/javascript\" src=\"FundingDetails.js\" />";
// get the user info object from the session
$userInfo = getUserSessionObj();
// init the validation variables
$validationMessage = '';
$validated = true;
// get whether they clicked proceed or form variables
getExtraParams(array("CompanyID", "IPODate", "date", "IPOValue", "IPORaised", "Date", "Amount", "FinancingType", "FinancingProvider1", "FinancingProvider2", "FinancingProvider3", "FinancingProvider4", "Update", "FundingID", "FundingSourceID", "FundingSource", "FundingTypeID", "FundingType", "AwardDate", "AwardAmount", "Comment", "DataSource", "AwdDate", "PrivateFinancingType", "PFAmount", "PFSource", "PublicProgramType", "Announcement", "AISource", "RealizeIPO", "IPODetails", "IPOSource", "PublicProgramSource", "PublicProgramAmount"));
// set the title name to be displayed in the header
$title = "Funding Detail Information";
// add flag to detect pages that need update messages
$DirtyPageEnabled = true;
// the update button was hit
if (isset($Update)) {
    // create a new founder object
    $fundingObj = new Funding();
    $financingObj = new Financing();
    $companyObj = new Company();
    //Company
    $companyObj->CompanyID = sqlEscapeString($CompanyID);
    $companyObj->IPODate = sqlEscapeString($IPODate);
    $companyObj->IPOValue = sqlEscapeString($IPOValue);
    $companyObj->IPORaised = nullpulldown($IPORaised);

// include the site constants
include_once "Constants.php";
// include the for parameter helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// include the pulldown helpers
include_once "Pulldown.php";
// get the user session helper object
include_once 'UserHelper.php';
// include the dump utils
include_once 'DumpUtils.php';
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed or poosible funding info
getExtraParams(array("CompanyID", "Refresh", "AddEvent", "Source", "Notes", "EEventID", "EventType", "EventMarket", "EventCategory", "EID", "ETypeID", "EventDate", "Amount", "Benificiary", "SourceID", "MarketID", "Comment", "CategoryID", "Remove"));
// did we get a company name
if (isset($CompanyID)) {
    // get the company name
    $companyName = getCompanyName($CompanyID);
    // set the title name to be displayed in the header
    $title = "Event data for company: " . $companyName . ". Company ID: " . $CompanyID;
} else {
    $title = "Event data";
}
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"CompanyEvent.js\" />";
// is this a post to add a new funding
if (isset($AddEvent)) {
    // validation
    if (isset($CompanyID) && !empty($CompanyID)) {

// include the site constants
include_once "Constants.php";
// include the for parameter helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// include the pulldown helpers
include_once "Pulldown.php";
// get the user session helper object
include_once 'UserHelper.php';
// include the dump utils
include_once 'DumpUtils.php';
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed or poosible funding info
getExtraParams(array("CompanyID", "IPODate", "IPOValue", "IPORaised", "Date", "Amount", "FinancingType", "FinancingProvider1", "FinancingProvider2", "FinancingProvider3", "FinancingProvider4", "DataSource", "MergerState", "MergerAmount", "MergerDate", "MergerSource", "AcquisitionSource", "AcquisitionAmount", "AcquisitionDate", "Refresh", "AddFunding", "AddSelectedFunding", "FundingID", "FundingSourceID", "FundingSource", "FundingTypeID", "FundingType", "AwardDate", "AwardAmount", "Comment", "Remove"));
// did we get a company name
if (isset($CompanyID)) {
    // get the company name
    $companyName = getCompanyName($CompanyID);
    // set the title name to be displayed in the header
    $title = "Funding data for company: " . $companyName . ". Company ID: " . $CompanyID;
} else {
    $title = "Funding data";
}
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"CompanyFunding.js\" />";
// is this a post to add a new funding
if (isset($AddFunding)) {
    // validation
    if (isset($CompanyID) && !empty($CompanyID)) {

include_once "FormsUtil.php";
// get the user session helper object
include_once 'UserHelper.php';
// get the dump utils
include_once 'DumpUtils.php';
// include the company object
include_once "Company.cls.php";
// include the pulldown helpers
include_once "Pulldown.php";
// get the user info object from the session
$userInfo = getUserSessionObj();
// init the validation variables
$validationMessage = '';
$validated = true;
// get whether they clicked proceed or form variables
getExtraParams(array("Update", "Delete", "CompanyAddressSource", "EstaEntryLoc", "EntryType", "CompanyID", "NewCompanyID", "CheckWebsite", "CompanyName", "Year", "YearID", "SOSID", "Phone", "EntryTypeGroup", "TLOAffiliation", "IFUniAffiliation", "RTPAnchor", "TLOSource", "Email", "C_Remark", "AdditionalSOSID", "Website", "SourceForCompany", "Establishment", "CompanyDescription", "SourceID", "CurrStreet", "CurrCity", "CurrState", "CurrZip", "CompanyNameSource", "CompanyYearSource", "CompanyDescriptionSource", "ParentCompany", "Subsidiary", "EModeID", "SectorID", "SubSectorID", "Technology", "TypeID", "MarketID", "SourceID", "HqOrigin", "HqCurrent", "EnteredNC", "AcquiredBool", "AcquiredDate", "AcquiredBy", "AcquiredValue", "IPOBool", "IPODate", "IPOValue", "IPORaised", "ClosureBool", "ClosureDate", "ActiveBool", "LocationType", "OrigCity", "OrigState", "OrigStreet", "OrigZip", "MailingAddress", "AlternatePhone", "Fax", "Inc_DE", "RTP", "MoveoutNC", "EntryTypeSource", "EstEntryLocationSource", "MoveoutDate", "AffiliationType", "DUNS", "AffiliationID", "ClosureDataSource", "ClosureType"));
// set the title name to be displayed in the header
$title = "Company Detail Information";
$scripts = "<script type=\"text/javascript\" src=\"CompanyDetails.js\" />";
// add flag to detect pages that need update messages
$DirtyPageEnabled = true;
function mssql_escape($data)
{
    if (is_numeric($data)) {
        return $data;
    }
    $unpacked = unpack('H*hex', $data);
    return '0x' . $unpacked['hex'];
}
if (isset($Delete)) {
    doDeleteCompany($CompanyID);

// include the site constants
include_once "Constants.php";
// include the for parameter helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// include the pulldown helpers
include_once "Pulldown.php";
// get the user session helper object
include_once 'UserHelper.php';
// include the dump utils
include_once 'DumpUtils.php';
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed or poosible funding info
getExtraParams(array("CompanyID", "Refresh", "AddFunding", "EventSource", "EventType", "EventMarket", "EventCategory", "ID", "TypeID", "EventDate", "Amount", "Benificiary", "SourceID", "MarketID", "Comment", "CategoryID", "Remove"));
// did we get a company name
if (isset($CompanyID)) {
    // get the company name
    $companyName = getCompanyName($CompanyID);
    // set the title name to be displayed in the header
    $title = "Event data for company: " . $companyName;
} else {
    $title = "Event data";
}
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"CompanyEvent.js\" />";
// is this a post to add a new funding
if (isset($AddEvent)) {
    // validation
    if (isset($CompanyID) && !empty($CompanyID)) {

include_once "FormsUtil.php";
// get the user session helper object
include_once 'UserHelper.php';
// get the dump utils
include_once 'DumpUtils.php';
// include the founder object
include_once "Founder.cls.php";
include_once "FounderEdu.cls.php";
// include the pulldown helper funcs
include_once "Pulldown.php";
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"FounderDetails.js\" />";
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed or form variables
getExtraParams(array("Update", "NameSource", "ContactInfoSource", "HomepageSource", "Delete", "WorkHisID", "Number", "WorkHisDetail", "PositionHeld", "Seniority", "Position_Domain", "W_From", "W_To", "Industry", "GraduatedYr", "Sector", "DegreeLookupID", "FounderEduID", "NewDegreeFrom", "NewMajor", "NewGraduatedYr", "FounderID", "CompanyID", "FirstName", "MidInitial", "LastName", "Suffix", "PhoneNumber", "Email", "Homepage", "F_Remark", "Other_Name"));
// set the title name to be displayed in the header
$title = "Founder Detail Information";
$scripts = "<script type=\"text/javascript\" src=\"FounderDetails.js\" />";
// add flag to detect pages that need update messages
$DirtyPageEnabled = true;
//if(isset($Delete)){
//doDeleteFounder($FounderID);
//header('Location: founders.php');
//}
// the update button was hit
if (isset($Update)) {
    // create a new founder object
    $founderObj = new Founder();
    // load the founder object with the page parameters
    $founderObj->FounderID = $FounderID;

 *
 * For questions, comments please contact [email protected]
 *
 */
// include the site constants
include_once "Constants.php";
// include the workflow step parameter boilerplate helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// get the user session helper object
include_once 'UserHelper.php';
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed and a possible RBP database ID
getExtraParams(array("NewList", "Refresh", "Name", "Description", "Version"));
// set the title name to be displayed in the header
$title = "Diagnostic List Overview";
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"../Overview/Overview.js\" />";
// preset validation flag
$validated = true;
if (isset($Refresh)) {
    // clear all previous data
    $Name = '';
    $Description = '';
    $Version = '';
} else {
    if (isset($NewList)) {
        // validate the parameters
        if (isset($Name) && !empty($Name) && isset($Description) && !empty($Description) && isset($Version) && !empty($Version) && is_numeric($Version)) {

// include the site constants
include_once "Constants.php";
// include the for parameter helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// include the pulldown helpers
include_once "Pulldown.php";
// get the user session helper object
include_once 'UserHelper.php';
// include the dump utils
include_once 'DumpUtils.php';
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed or poosible funding info
getExtraParams(array("CompanyID", "ID", "Refresh", "AddSectors", "SectorID", "SubSector1ID", "SubSector2ID", "Remove"));
// did we get a company name
if (isset($CompanyID)) {
    // get the company name
    $companyName = getCompanyName($CompanyID);
    // set the title name to be displayed in the header
    $title = "Sector data for company: " . $companyName . ". Company ID: " . $CompanyID;
} else {
    $title = "Funding data";
}
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"CompanySectors.js\" />";
// is this a post to add a new funding
if (isset($AddSectors)) {
    // validate that the alias name is good
    if (isset($SectorID) && !empty($SectorID) && isset($SubSector1ID) && !empty($SubSector1ID) && isset($SubSector2ID) && !empty($SubSector2ID)) {

include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// include the pulldown helpers
include_once "Pulldown.php";
// get the user session helper object
include_once 'UserHelper.php';
// include the dump utils
include_once 'DumpUtils.php';
// get the user info object from the session
$userInfo = getUserSessionObj();
// init the validation variables
$validationMessage = '';
$validated = true;
// save the posted page values
getExtraParams(array("AddFundingSource", "AddFundingType", "SourceID", "SourceName", "TypeID", "TypeName"));
// set the title name to be displayed in the header
$title = "Funding Source and Funding Type List";
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"Funding.js\" />";
// is this a post to add a new founder
if (isset($AddFundingSource)) {
    // validation
    if (isset($SourceName) && !empty($SourceName)) {
        // check for a duplucate name or prev/other name
        $retVal = checkForDuplicateSourceName($SourceName);
        // was this a new founder
        if ($retVal[0] == false) {
            // get the founder object definition loaded
            include_once "FundingSource.cls.php";
            // create a new founder object

include_once "FormsUtil.php";
// get the user session helper object
include_once 'UserHelper.php';
// get the dump utils
include_once 'DumpUtils.php';
// include the founder object
include_once "FounderEdu.cls.php";
include_once "Founder.cls.php";
// include the pulldown helper funcs
include_once "Pulldown.php";
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"FounderDetails.js\" />";
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed or form variables
getExtraParams(array("Update", "DegreeLookupID", "FounderEduID", "NewDegreeFrom", "NewDegreeType", "NewMajor", "NewGraduatedYr", "FounderID", "CompanyID"));
// set the title name to be displayed in the header
$title = "Founder Education Information";
$scripts = "<script type=\"text/javascript\" src=\"FounderEdu.js\" />";
// add flag to detect pages that need update messages
$DirtyPageEnabled = true;
// the update button was hit
if (isset($Update)) {
    // validate that the education data is good
    if (1) {
        // create a new founderEdu object
        $founderEduObj = new FounderEdu();
        //load the FounderEdu object with the page parameters
        //$founderEduObj->FounderEduID = NULL;
        $founderEduObj->FounderID = $FounderID;
        $founderEduObj->DegreeFrom = sqlEscapeString($NewDegreeFrom);

// include the site constants
include_once "Constants.php";
// include the for parameter helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// get the user session helper object
include_once 'UserHelper.php';
// include the dump utils
include_once 'DumpUtils.php';
// include the pulldown helpers
include_once "Pulldown.php";
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed and a possible RBP database ID
getExtraParams(array("validationMessage", "CompanyData", "FoundersData", "FundingData", "NoteData", "ProductData", "ExecutiveData", "EventData", "SearchCompanyName", "SearchCompany", "companySelect", "ViewSelectedCompany", "CompanySearchResult"));
// set the title name to be displayed in the header
$title = "Enter Company ID";
$scripts = "<script type=\"text/javascript\" src=\"EnterCompanyID.js\" />";
if (isset($SearchCompany)) {
    // validation
    if (isset($SearchCompanyName) && !empty($SearchCompanyName)) {
        // search for company names
        $retVal = searchForCompanyName(sqlEscapeString($SearchCompanyName));
        // companies found
        if ($retVal[0]) {
            // set the validation error flag
            $validated = false;
            // reset the validation error message
            $validationMessage = '';
            // save the search results

// include the site constants
include_once "Constants.php";
// include the for parameter helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// include the pulldown helpers
include_once "Pulldown.php";
// get the user session helper object
include_once 'UserHelper.php';
// include the dump utils
include_once 'DumpUtils.php';
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed or poosible funding info
getExtraParams(array("CompanyID", "ID", "Refresh", "AddTechnologies", "Technology", "Remove"));
// did we get a company name
if (isset($CompanyID)) {
    // get the company name
    $companyName = getCompanyName($CompanyID);
    // set the title name to be displayed in the header
    $title = "Technology data for company: " . $companyName . ". Company ID: " . $CompanyID;
} else {
    $title = "Technology data";
}
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"CompanyTechnologies.js\" />";
// is this a post to add a new funding
if (isset($AddTechnologies)) {
    // validate that the alias name is good
    if (isset($Technology) && !empty($Technology)) {

// include the site constants
include_once "Constants.php";
// include the for parameter helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// include the pulldown helpers
include_once "Pulldown.php";
// get the user session helper object
include_once 'UserHelper.php';
// include the dump utils
include_once 'DumpUtils.php';
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed or poosible founder info
getExtraParams(array("CompanyName", "FounderID", "Refresh", "AddCompany", "CompanyForFounderPulldown", "SearchCompany", "SearchCompanyName", "companySelect", "CompanySearchResult", "AddSelectedCompany"));
$scripts = "<script type=\"text/javascript\" src=\"FounderCompany.js\" />";
$keyword = "'%" . $_POST['keyword'] . "%'";
//$sql = "SELECT top 50 * FROM Companies where CompanyName like " . $keyword . " order by CompanyID ASC";
$sql = "select distinct c.CompanyName from Companies c left join PreviousOtherNames p on c.CompanyID = p.CompanyID where ((c.CompanyName like " . $keyword . ") or (p.OtherName like " . $keyword . ")) order by c.CompanyName";
//$query = $pdo->prepare($sql);
//$query->bindParam(':keyword', $keyword, PDO::PARAM_STR);
//$query->execute();
include_once "SQLUtils.php";
$list = query($sql);
//$list = doGetCompanyList();
foreach ($list as $rs) {
    // put in bold the written text
    $company_name = str_replace($_POST['keyword'], '<b>' . $_POST['keyword'] . '</b>', $rs['CompanyName']);
    // add new option
    echo '<li onclick="set_item(\'' . str_replace("'", "\\'", $rs['CompanyName']) . '\')">' . $company_name . '</li>';

// include the site constants
include_once "Constants.php";
// include the for parameter helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// get the user session helper object
include_once 'UserHelper.php';
// include the dump utils
include_once 'DumpUtils.php';
// include the pulldown helpers
include_once "Pulldown.php";
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed or possible founder info
getExtraParams(array("CompanyID", "Refresh", "OtherName", "AddAlias", "CompanyName", "SearchCompanyName", "NewAliasName"));
// get the company name
$CompanyName = getCompanyName($CompanyID);
// set the title name to be displayed in the header
$title = "Associated Names for: " . $CompanyName . ". Company ID: " . $CompanyID;
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"PreviousOtherNames.js\" />";
// was the add selected company button hit  MAKE COMPANY NAME GET ASSIGNED IN OTHERNAMES AND COMPANYID SET TO CURRENT ON SITE
if (isset($AddAlias)) {
    // validate that the alias name is good
    if (isset($NewAliasName) && !empty($NewAliasName)) {
        $NewAliasName = htmlspecialchars($NewAliasName, ENT_QUOTES);
        // create the SQL statement for the insert
        $sql = "EXEC dbo.CreatePreviousOtherName @CompanyID=" . $CompanyID . ", @OtherName=" . "'" . $NewAliasName . "'";
        // insert the record
        $result = nonQuery($sql);

// include the site constants
include_once "Constants.php";
// include the for parameter helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// include the pulldown helpers
include_once "Pulldown.php";
// get the user session helper object
include_once 'UserHelper.php';
// include the dump utils
include_once 'DumpUtils.php';
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed or poosible founder info
getExtraParams(array("FirstName", "MidInitial", "LastName"));
$scripts = "<script type=\"text/javascript\" src=\"Founder.js\" />";
//$keyword = "'%" . $_POST['keyword'] . "%'";
$firstName = htmlspecialchars($_POST['FirstName'], ENT_QUOTES);
$MidInitial = htmlspecialchars($_POST['MidInitial'], ENT_QUOTES);
$lastName = htmlspecialchars($_POST['LastName'], ENT_QUOTES);
//$keyword = "'%" . htmlspecialchars($_POST['keyword'], ENT_QUOTES) . "%'";
//$sql = "SELECT top 50 * FROM Companies where CompanyName like " . $keyword . " order by CompanyID ASC";
//$sql = "select distinct c.CompanyName from Companies c left join PreviousOtherNames p on c.CompanyID = p.CompanyID where ((c.CompanyName like " . $keyword . ") or (p.OtherName like " . $keyword . ")) order by c.CompanyName";
$sql = "EXEC dbo.checkForDuplicateFounderName @FirstName='" . $firstName . "'" . ", @LastName='" . $lastName . "'" . ", @MidInitial='" . $MidInitial . "'";
//$query = $pdo->prepare($sql);
//$query->bindParam(':keyword', $keyword, PDO::PARAM_STR);
//$query->execute();
include_once "SQLUtils.php";
$list = query($sql);
//$list = doGetCompanyList();

include_once 'UserHelper.php';
// get the dump utils
include_once 'DumpUtils.php';
// include the founder object
include_once "Acquisition.cls.php";
// include the pulldown helper funcs
include_once "Pulldown.php";
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"AcquisitionDetails.js\" />";
// get the user info object from the session
$userInfo = getUserSessionObj();
// init the validation variables
$validationMessage = '';
$validated = true;
// get whether they clicked proceed or form variables
getExtraParams(array("CompanyID", "FundingID", "AcquisitionID", "Refresh", "Update", "AddAcquisition", "Source", "State", "Amount", "Date", "Source", "Remove"));
// set the title name to be displayed in the header
$title = "Acquisition Detail Information";
$scripts = "<script type=\"text/javascript\" src=\"AcquisitionDetails.js\" />";
// add flag to detect pages that need update messages
$DirtyPageEnabled = true;
// the update button was hit
if (isset($Update)) {
    // create a new founder object
    $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);

// include the site constants
include_once "Constants.php";
// include the for parameter helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
// include the pulldown helpers
include_once "Pulldown.php";
// get the user session helper object
include_once 'UserHelper.php';
// include the dump utils
include_once 'DumpUtils.php';
// get the user info object from the session
$userInfo = getUserSessionObj();
// get whether they clicked proceed or poosible founder info
getExtraParams(array("CompanyID", "FounderID", "dupeSelect", "Refresh", "AddFounder", "AddSelectedFounder", "pageLink", "duplicatedFounder", "ViewSelectedFounder", "FirstName", "MidInitial", "LastName", "Suffix", "OtherName", "PhoneNumber", "Email", "Cur_Resident", "F_Remark", "VerifiedBy", "Homepage"));
// did we get a company name
if (isset($CompanyID)) {
    // get the company name
    $companyName = getCompanyName($CompanyID);
    // set the title name to be displayed in the header
    $title = "Founder data for company: " . $companyName . ". Company ID: " . $CompanyID;
} else {
    $title = "Founder data";
}
// add the jqx workflow list script which generates the jqxgrid
$scripts = "<script type=\"text/javascript\" src=\"Founder.js\" />";
// is this a post to add a new founder
if (isset($AddFounder)) {
    // validation
    if (isset($FirstName) && !empty($FirstName) && isset($LastName) && !empty($LastName) && isset($MidInitial)) {

// include the for parameter helper
include_once "GetFormParams.php";
// include the form element helpers
include_once "FormsUtil.php";
include_once "SQLUtils.php";
// get the user session helper object
include_once 'UserHelper.php';
//get the checkbox bootstrap stuff
//include_once();
// get the user info object from the session
$userInfo = getUserSessionObj();
// init the validation variables
$validationMessage = '';
$validated = true;
// get whether they clicked proceed or form variables
getExtraParams(array("UpdateGrid", "CCompanyID", "inputCol", "Refresh", "ExportCSV", "AddCompany", "Description", "EstYear", "Update", "CompanyID", "CheckWebsite", "CompanyName", "Year", "YearID", "SOSID", "Phone", "Email", "C_Remark", "AdditionalSOSID", "Website", "SourceForCompany", "Establishment", "CompanyDescription", "SourceID", "CurrStreet", "CurrCity", "CurrState", "CurrZip", "CompanyNameSource", "CompanyYearSource", "CompanyDescriptionSource", "ParentCompany", "Subsidiary", "EModeID", "SectorID", "SubSector1ID", "SubSector2ID", "Technology", "TypeID", "MarketID", "SourceID", "HqOrigin", "HqCurrent", "EnteredNC", "AcquiredBool", "AcquiredDate", "AcquiredBy", "AcquiredValue", "IPOBool", "IPODate", "IPOValue", "IPORaised", "ClosureBool", "ClosureDate", "ActiveBool", "LocationType", "OrigCity", "OrigState", "OrigStreet", "OrigZip", "MailingAddress", "AlternatePhone", "Fax", "Inc_DE", "RTP", "MoveoutNC", "MoveoutDate", "AffiliationType", "DUNS", "UserName", "AffiliationID", "checkboxinfo", "fileContents", "Checkboxes", "rv", "replace", "replaceMessage", "validationMessage", "validated"));
function isCBChecked($arr, $index)
{
    if (isset($arr) && !empty($arr)) {
        if (is_array($arr)) {
            if (in_array($index, $arr)) {
                return "checked";
            } else {
                return '';
            }
        } else {
            if ($arr == $index) {
                return "checked";
            } else {
                return '';
            }