<?php
//////////////////////////////////////////////////////////////////
// ContactPerson.inc
//////////////////////////////////////////////////////////////////

//////////////////////////////////////////////////////////////////
// get original contact id
//////////////////////////////////////////////////////////////////
function GetContactOriginalID($var_ID)
{
    global $dblink;
    
    $sql = "
        SELECT  col_PersonID
        FROM    tb_Person
        WHERE   col_ID = '$var_ID'
        AND     col_ContactPersonOriginalYN = 'Yes'";
    //echo '<br>'.$sql;
    $result = mysqli_query($dblink,$sql);
    if ($result)
        if ($myrow = mysqli_fetch_array($result))
    {
        $var_PersonID = $myrow['col_PersonID'];
    }

    return $var_PersonID;
}

//////////////////////////////////////////////////////////////////
// get contact person id
//////////////////////////////////////////////////////////////////
function GetContactID($var_ID)
{
    global $dblink;
    
    $sql = "
        SELECT  col_PersonID
        FROM    tb_Person
        WHERE   col_ID = '$var_ID'
        AND     col_ContactPersonYN = 'Yes'";
    //echo '<br>'.$sql;
    $result = mysqli_query($dblink,$sql);
    if ($result)
        if ($myrow = mysqli_fetch_array($result))
    {
        $var_PersonID = $myrow['col_PersonID'];
    }

    return $var_PersonID;
}

//////////////////////////////////////////////////////////////////
// get contact person name
//////////////////////////////////////////////////////////////////
function GetContactName($var_ID)
{
    global $dblink;
    
    $sql = "
        SELECT  col_Name
        FROM    tb_Person
        WHERE   col_ID = '$var_ID'
        AND     col_ContactPersonYN = 'Yes'";
    //echo '<br>'.$sql;
    $result = mysqli_query($dblink,$sql);
    if ($result)
        if ($myrow = mysqli_fetch_array($result))
    {
        $var_Name = $myrow['col_Name'];
    }

    return $var_Name;
}

//////////////////////////////////////////////////////////////////
// get contact person string
//////////////////////////////////////////////////////////////////
function GetContactNameString($var_ID)
{
    global $dblink;
    
    $sql1 = "
        SELECT  col_Name,
                col_Type
        FROM    tb_Person
        WHERE   col_ID = '$var_ID'
        AND     col_ContactPersonYN = 'Yes'";
    //echo '<br>'.$sql1;
    $result = mysqli_query($dblink,$sql1);
    if ($result)
        if ($myrow = mysqli_fetch_array($result))
    {
        $var_Contact = $myrow['col_Name'];
        $var_Type = $myrow['col_Type'];
    }

    $var_BR = "";
    $var_Names = "";
    $cnt_names = 0;

    if ($var_Type)
    {
        $sql2 = "
            SELECT  col_Name
            FROM    tb_Person
            WHERE   col_ID = '$var_ID'
            AND     col_Type = '$var_Type'
            AND     col_Name != \"$var_Contact\"
            ORDER BY col_PurchaserNumber, col_PersonID";
        //echo '<br>'.$sql2;
        $result = mysqli_query($dblink,$sql2);
        if ($result)
        {
            $rows = mysqli_num_rows($result);
            
            while ($myrow = mysqli_fetch_array($result))
            {
                $var_Name = $myrow['col_Name'];

                if ($var_Name)
                {
                    if ($cnt_names && $rows>1)
                        $var_BR = ' & ';
                    elseif ($cnt_names)
                        $var_BR = ', ';
                    
                    $var_Names .= $var_BR.$var_Name;
                    $cnt_names++;
                }
            }
        }
        
        if ($var_Contact && $var_Names && $rows>1)
        {
            $var_BR = ', ';
            $var_Names = $var_Contact.$var_BR.$var_Names;
        }
        elseif ($var_Contact && $var_Names)
        {
            $var_BR2 = ' & ';
            $var_Names = $var_Contact.$var_BR2.$var_Names;
        }
        else
        {
            $var_Names = $var_Contact;
        }
    }
    
    $var_quote = "&#x27;";
    $var_Names = str_replace("’", $var_quote, $var_Names);
    $var_Names = str_replace("'", $var_quote, $var_Names);

    return $var_Names;
}

//////////////////////////////////////////////////////////////////
// get contact person list
//////////////////////////////////////////////////////////////////
function GetContactNameList($var_ID)
{
    global $dblink;
    
    $sql1 = "
        SELECT  col_Type
        FROM    tb_Person
        WHERE   col_ID = '$var_ID'
        AND     col_ContactPersonYN = 'Yes'
        ORDER BY col_PurchaserNumber, col_PersonID";
    //echo '<br>'.$sql1;
    $result = mysqli_query($dblink,$sql1);
    if ($result)
        if ($myrow = mysqli_fetch_array($result))
    {
        $var_Type = $myrow['col_Type'];
    }

    $var_BR = "";
    $var_Names = "";

    if ($var_Type)
    {
        $sql2 = "
            SELECT  col_Name,
                    col_ContactPersonYN
            FROM    tb_Person
            WHERE   col_ID = '$var_ID'
            AND     col_Type = '$var_Type'
            ORDER BY col_PurchaserNumber, col_PersonID";
        //echo '<br>'.$sql2;
        $result = mysqli_query($dblink,$sql2);
        if ($result)
            while ($myrow = mysqli_fetch_array($result))
        {
            $var_Name = $myrow['col_Name'];
            $var_ContactPersonYN = $myrow['col_ContactPersonYN'];

            if ($var_Name && $var_ContactPersonYN=='Yes')
            {
                $var_Contact = $var_Name;
            }
            elseif ($var_Name)
            {
                $var_Names .= $var_BR.$var_Name;
                $var_BR = ',';
            }
        }
        
        $var_Names = ($var_Contact && $var_Names)? $var_Contact.$var_BR.$var_Names : $var_Names;
    }
    
    $var_quote = "&#x27;";
    $var_Names = str_replace("’", $var_quote, $var_Names);
    $var_Names = str_replace("'", $var_quote, $var_Names);

    return $var_Names;
}

//////////////////////////////////////////////////////////////////
// get contact person address
//////////////////////////////////////////////////////////////////
function GetContactAddress($var_ID,$var_Lines)
{
    global $dblink;
    
    $sql = "
        SELECT  col_PersonID,
                col_Type,
                col_salutation,
                col_Name,
                col_Apartment,
                col_Address,
                col_City,
                col_Province,
                col_Postal,
                col_Country,
                col_Email
        FROM    tb_Person
        WHERE   col_ID = '$var_ID'
        AND     col_ContactPersonYN = 'Yes'";
    //echo '<br>'.$sql;
    $result = mysqli_query($dblink,$sql);
    if ($result)
      if ($myrow = mysqli_fetch_array($result))
    {
        $var_Address = $myrow['col_Address'];
        $var_Apartment = $myrow['col_Apartment'];
        $var_City = $myrow['col_City'];
        $var_Province = $myrow['col_Province'];
        $var_Country = $myrow['col_Country'];
        $var_Postal = strtoupper($myrow['col_Postal']);

        $var_HOApartment = ($var_Apartment)? " - Apt: $var_Apartment" : "";
        $var_HOAddress1 = $var_Address.$var_HOApartment;
        
        //$var_HOAddress2 = $var_HOCity.', '.$var_HOProvince.' '.$var_HOPostalCode;
        $var_HOAddress2 = $var_City;
        $var_HOAddress2 .= ($var_Province)?', '.$var_Province :'';
        
        $var_HOAddress3 .= $var_Country;
        $var_HOAddress3 .= ($var_Country && $var_Postal)? " &nbsp;".$var_Postal : $var_Postal;
        $var_TxtNamesBR = "<br/>";
    }
    
    if ($var_Lines==1)
    {
        $var_HOAddress = $var_HOAddress1;
    }
    elseif ($var_Lines==2)
    {
        $var_HOAddress  = $var_HOAddress1;
        $var_HOAddress .= ($var_HOAddress2)? $var_TxtNamesBR.$var_HOAddress2 : "";
        
        if ($var_HOAddress3 && $var_Country)
            $var_HOAddress .= ", ".$var_HOAddress3;
        elseif ($var_HOAddress3 && $var_Postal)
            $var_HOAddress .= " &nbsp;".$var_Postal;
    }
    elseif ($var_Lines==3)
    {
        $var_HOAddress  = $var_HOAddress1;
        $var_HOAddress .= ($var_HOAddress2)? $var_TxtNamesBR.$var_HOAddress2 : "";
        $var_HOAddress .= ($var_HOAddress3)? $var_TxtNamesBR.$var_HOAddress3 : "";
    }
    
    return $var_HOAddress;
}

//////////////////////////////////////////////////////////////////
// get contact person email
//////////////////////////////////////////////////////////////////
function GetContactEmail($var_ID)
{
    global $dblink;
    
    $sql = "
        SELECT  col_PersonID,
                col_Email
        FROM    tb_Person
        WHERE   col_ID = '$var_ID'
        AND     col_ContactPersonYN = 'Yes'";
    //echo '<br>'.$sql;
    $result = mysqli_query($dblink,$sql);
    if ($result)
      if ($myrow = mysqli_fetch_array($result))
    {
        $var_Email = $myrow['col_Email'];
    }
    
    return $var_Email;
}

//////////////////////////////////////////////////////////////////
// get contact person phone
//////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////
?>