"; if ($var_VendorID) { $sql = " SELECT * FROM tb_ListCompany WHERE col_ListCompanyID = $var_VendorID AND col_ListCompanyRcdExpiry is null "; if($result = mysql_query($sql,$db)) while ($myrow = mysql_fetch_array($result)) { echo "
Current Vendor - ".$myrow["col_CompanyName"]."

"; $varVendor = $myrow["col_ListCompanyID"]; } } $VendorSelected="Yes"; $AddOrEditVendorProfile="Yes"; if($refresh_mode == "PostVendor") { $var_PostVendor ="Yes"; } if($refresh_mode == "PostTrade") { $var_PostVendor = "Yes"; $var_PostTrade ="Yes"; } if($refresh_mode == "PostContact") { $var_PostVendor = "Yes"; $var_PostContact ="Yes"; } if($refresh_mode == "PostPhone") { $var_PostVendor = "Yes"; $var_PostContact = "Yes"; $var_PostPhone = "Yes"; } function ShowPhoneNumber($val) { $res = ""; $p = 0; $n = "0123456789"; for ($i=1; $i<=strlen($val); $i++) { $c = substr($val, -$i, 1); if(strrchr($n,$c)) { $res = $c.$res; $p++; if($p==4) $res = " - " . $res; if($p==7) $res = ") " . $res; if($p==10) break; } } if($p>=7) $res = "(" . $res; return $res; } if ($var_PostVendor) { if ($var_VendorID) { if ($var_VendorName) $sql =" UPDATE tb_ListCompany SET col_address ='$var_address', col_city ='$var_city', col_state ='$var_state', col_zip ='$var_zip', col_telephone ='$var_telephone', col_fax ='$var_fax', col_contact ='$var_contact', col_comment ='$var_comment', col_email ='$var_email', col_BuildProEmail ='$var_BuildProEmail', col_WSIBNumber ='$var_WSIBNumber', col_WSIBExpiryDate ='$var_WSIBExpiryDate', col_WSIBVerifiedDate ='$var_WSIBVerifiedDate', col_ManageAppointments = '$var_ManageAppointments', col_PaymentTerms ='$var_PaymentTerms', col_ControlInvoice ='$var_ControlInvoice', col_AccountingCode ='$var_AccountingCode' WHERE col_ListCompanyOID = $var_VendorID AND col_ListCompanyRcdExpiry is null "; $refresh_mode = "ShowVendorList"; } else { $var_VendorID = 0; $sql = " SELECT max(col_ListCompanyOID) as max_ListCompanyID FROM tb_ListCompany WHERE col_ListCompanyRcdExpiry is null "; if($result = mysql_query($sql,$db)) if($myrow = mysql_fetch_array($result)) $var_VendorID = $myrow["max_ListCompanyID"] + 1; $sql = " INSERT INTO tb_ListCompany ( col_ListCompanyOID, col_CompanyName, col_address, col_city, col_state, col_zip, col_telephone, col_fax, col_contact, col_comment, col_email, col_BuildProEmail, col_WSIBNumber, col_WSIBExpiryDate, col_WSIBVerifiedDate, col_ManageAppointments, col_PaymentTerms, col_ControlInvoice, col_AccountingCode, col_CentreFilter ) VALUES ( $var_VendorID, '$var_VendorName', '$var_address', '$var_city', '$var_state', '$var_zip', '$var_telephone', '$var_fax', '$var_contact', '$var_comment', '$var_email', '$var_BuildProEmail', '$var_WSIBNumber', '$var_WSIBExpiryDate', '$var_WSIBVerifiedDate', '$var_ManageAppointments', '$var_PaymentTerms', '$var_ControlInvoice', '$var_AccountingCode', 'All' ) "; $refresh_mode = "ShowVendor"; } //echo $sql; if($result = mysql_query($sql,$db)); } if($var_PostTrade) { $refresh_mode = "ShowVendor"; if($var_TradeID) { $tmp_CompanyTradeID = ""; $sql = " SELECT col_CompanyTradeOID as col_CompanyTradeID FROM tb_CompanyTrade WHERE col_ListCompanyOID = $var_VendorID AND col_TradeOID = $var_TradeID AND col_CompanyTradeRcdExpiry is null "; //echo $sql; if($result = mysql_query($sql,$db)) if($myrow = mysql_fetch_array($result)) $tmp_CompanyTradeID = $myrow["col_CompanyTradeID"]; if(!$tmp_CompanyTradeID) { $tmp_CompanyTradeID = 0; $sql = " SELECT max(col_CompanyTradeOID) as max_CompanyTradeID FROM tb_CompanyTrade WHERE col_CompanyTradeRcdExpiry is null "; //echo $sql; if($result = mysql_query($sql,$db)) if($myrow = mysql_fetch_array($result)) $tmp_CompanyTradeID = $myrow["max_CompanyTradeID"] + 1; $sql = " INSERT INTO tb_CompanyTrade ( col_CompanyTradeOID, col_TradeOID, col_ListCompanyOID ) VALUES ( $tmp_CompanyTradeID, $var_TradeID, $var_VendorID ) "; //echo $sql; if($result = mysql_query($sql,$db)); } } } if($var_PostContact) { if(!$var_CompanyPersonelID || ($var_CompanyPersonelID =="undefined")) { $var_CompanyPersonelID = ""; $sql = " SELECT col_CompanyPersonelOID as col_CompanyPersonelID FROM tb_CompanyPersonel WHERE col_CompanyPersonelRcdExpiry is null AND col_ListCompanyOID = $var_VendorID AND col_PersonName = '$var_ContactPersonNameNew' "; //echo $sql; if($result = mysql_query($sql,$db)) if($myrow = mysql_fetch_array($result)) $var_CompanyPersonelID = $myrow["col_CompanyPersonelID"]; } if($var_CompanyPersonelID) { if($var_ContactPersonName) { $sql =" UPDATE tb_CompanyPersonel SET col_PersonName = '$var_ContactPersonName', col_Address = '$var_ContactAddress', col_City = '$var_ContactCity', col_PostalCode = '$var_ContactPostalCode', col_Spouse = '$var_ContactSpouse' WHERE col_CompanyPersonelRcdExpiry is null AND col_CompanyPersonelOID = $var_CompanyPersonelID "; //echo $sql; if($result = mysql_query($sql,$db)); } if($var_DefaultPhone) { $sql =" UPDATE tb_Phone SET col_DefaultPhone = 'No' WHERE col_PhoneRcdExpiry is null AND col_CompanyPersonelOID = $var_CompanyPersonelID "; //echo $sql; if($result = mysql_query($sql,$db)); $sql =" UPDATE tb_Phone SET col_DefaultPhone = 'Yes' WHERE col_PhoneRcdExpiry is null AND col_PhoneOID = $var_DefaultPhone AND col_CompanyPersonelOID = $var_CompanyPersonelID "; //echo $sql; if($result = mysql_query($sql,$db)); } $refresh_mode = "ShowVendor"; } else { $var_CompanyPersonelID = 0; $sql = " SELECT max(col_CompanyPersonelOID) as max_CompanyPersonelID FROM tb_CompanyPersonel WHERE col_CompanyPersonelRcdExpiry is null "; //echo $sql; if($result = mysql_query($sql,$db)) if($myrow = mysql_fetch_array($result)) $var_CompanyPersonelID = $myrow["max_CompanyPersonelID"] + 1; $sql = " INSERT INTO tb_CompanyPersonel ( col_CompanyPersonelOID, col_ListCompanyOID, col_PersonName ) VALUES ( $var_CompanyPersonelID, $var_VendorID, '$var_ContactPersonNameNew' ) "; //echo $sql; if($result = mysql_query($sql,$db)); $refresh_mode = "ShowContact"; } } if($var_PostPhone) { if(!$var_PhoneID) { $sql = " SELECT col_PhoneOID as col_PhoneID FROM tb_Phone WHERE col_PhoneRcdExpiry is null AND col_CompanyPersonelOID = $var_CompanyPersonelID AND col_ListCompanyOID = $var_VendorID AND col_PhoneNumber = '$var_PhoneNumberNew' "; //echo $sql; if($result = mysql_query($sql,$db)) if($myrow = mysql_fetch_array($result)) $var_PhoneID = $myrow["col_PhoneID"]; } if($var_PhoneID) { if($var_PhoneNumber) { $sql =" UPDATE tb_Phone SET col_PhoneNumber = '$var_PhoneNumber', col_PhoneType = '$var_PhoneType', col_PhoneExtension = '$var_PhoneExtension', col_Instruction = '$var_Instruction' WHERE col_PhoneRcdExpiry is null AND col_PhoneOID = $var_PhoneID "; //echo $sql; if($result = mysql_query($sql,$db)); } $refresh_mode = "ShowContact"; } else { $var_PhoneID = 0; $sql = " SELECT max(col_PhoneOID) as max_PhoneID FROM tb_Phone WHERE col_PhoneRcdExpiry is null "; //echo $sql; if($result = mysql_query($sql,$db)) if($myrow = mysql_fetch_array($result)) $var_PhoneID = $myrow["max_PhoneID"] + 1; $sql = " INSERT INTO tb_Phone ( col_PhoneOID, col_CompanyPersonelOID, col_ListCompanyOID, col_PhoneNumber ) VALUES ( $var_PhoneID, $var_CompanyPersonelID, $var_VendorID, '$var_PhoneNumberNew' ) "; //echo $sql; if($result = mysql_query($sql,$db)); $refresh_mode = "ShowPhone"; } } if($var_CompanyTradeID && ($refresh_mode == "DeleteTrade")) { $refresh_mode = "ShowVendor"; $sql = " UPDATE tb_CompanyTrade SET col_CompanyTradeRcdExpiry = '$TodaysDate' WHERE col_CompanyTradeOID = $var_CompanyTradeID AND col_CompanyTradeRcdExpiry is null "; //echo $sql; if($result = mysql_query($sql,$db)); } if(!$refresh_mode || $refresh_mode == "ShowVendorList") { // Clear var_VendorID after use $var_VendorID=""; $VendorSelected="No"; $AddOrEditVendorProfile="No"; echo "
Vendor Management
Add a Vendor


"; $sql = " SELECT col_ListCompanyOID, col_CompanyName FROM tb_ListCompany WHERE (col_Centre ='' OR col_Centre is null) AND col_ListCompanyRcdExpiry is null ORDER BY col_CompanyName "; if($result = mysql_query($sql,$db)) while ($myrow = mysql_fetch_array($result)) { if(!$myrow["col_CompanyName"]) continue; $str_format = " "; printf($str_format,$myrow["col_ListCompanyOID"], $myrow["col_CompanyName"]); } echo "
Current Vendor List
%s
"; } if ($AddOrEditVendorProfile=="Yes") { if ($var_VendorID) { $sql = " SELECT * FROM tb_ListCompany WHERE col_ListCompanyOID = $var_VendorID AND col_ListCompanyRcdExpiry is null "; if($result = mysql_query($sql,$db)) if($myrow = mysql_fetch_array($result)) { $var_VendorID = $myrow["col_ListCompanyOID" ]; $var_VendorName = $myrow["col_CompanyName" ]; $var_address = $myrow["col_address" ]; $var_city = $myrow["col_city" ]; $var_state = $myrow["col_state" ]; $var_zip = $myrow["col_zip" ]; $var_telephone = $myrow["col_telephone" ]; $var_fax = $myrow["col_fax" ]; $var_contact = $myrow["col_contact" ]; $var_comment = $myrow["col_comment" ]; $var_email = $myrow["col_email" ]; $var_ManageAppointments = $myrow["col_ManageAppointments" ]; $var_BuildProEmail = $myrow["col_BuildProEmail" ]; $var_WSIBNumber = $myrow["col_WSIBNumber" ]; $var_WSIBExpiryDate = $myrow["col_WSIBExpiryDate" ]; $var_WSIBVerifiedDate = $myrow["col_WSIBVerifiedDate" ]; $var_PaymentTerms = $myrow["col_PaymentTerms" ]; $var_ControlInvoice = $myrow["col_ControlInvoice" ]; $var_AccountingCode = $myrow["col_AccountingCode" ]; echo "
Editing Vendor Profile

"; } } else { echo "
Adding a Vendor Profile

"; } echo "
"; $str_TradeLabel = " Trade:  "; $str_border_style1 = " style=\"border-top-style:ridge; border-left-style:ridge; border-right-style:ridge; height=25;\""; $str_border_style2 = " style=\"border-top-style:ridge; border-left-style:ridge; border-right-style:ridge; border-bottom-style:ridge; height=40;\""; $lst_TradeID = "-1"; $sql = " SELECT tb_CompanyTrade.col_TradeOID as col_TradeID, tb_Trade.col_Trade, tb_CompanyTrade.col_CompanyTradeOID FROM tb_CompanyTrade LEFT JOIN tb_Trade ON tb_CompanyTrade.col_TradeOID = tb_Trade.col_TradeOID AND tb_Trade.col_TradeRcdExpiry is null WHERE tb_CompanyTrade.col_ListCompanyOID = $var_VendorID AND tb_CompanyTrade.col_CompanyTradeRcdExpiry is null "; if($result = mysql_query($sql,$db)) while ($myrow = mysql_fetch_array($result)) { $lst_TradeID .= ", ".$myrow["col_TradeID"]; echo " "; $str_TradeLabel = " "; $str_border_style2 = " style=\"border-left-style:ridge; border-right-style:ridge; border-bottom-style:ridge; height=40;\""; $str_border_style1 = " style=\"border-left-style:ridge; border-right-style:ridge;\""; } echo "
"; $sql = " Select * FROM tb_Users WHERE col_UsersName='$LoggedInUser' "; if($result = mysql_query($sql,$db)) while ($myrow = mysql_fetch_array($result)) $var_UserSecLevel = $myrow["col_SecurityLevel"]; If ($var_UserSecLevel <> "0" && $var_UserSecLevel <> "1") echo ""; echo " $var_VendorName
Vendor Name: 

Address: 

City: 

Province: 

Postal Code: 

Telephone: 

Fax: 

Contact Name: 

Service and PO Email: 

BuildPro Email: 

WSIB Clearance Number: 

WSIB Clearance Expiry: 

\"Click   \"Set 

WSIB Verif. Date  \"Click   \"Set 
Comments: 

Payment Terms: 

Accounting Code: 

Show Manage Appointments:  "; if ($var_ManageAppointments =="Yes") { echo " "; } else { echo " "; } echo "
$str_TradeLabel   ".$myrow["col_Trade"] ."
$str_TradeLabel  
"; if($var_PhoneID && ($refresh_mode == "ShowPhone")) { echo "
"; $sql = " SELECT col_PhoneType, col_PhoneNumber, col_PhoneExtension, col_Instruction FROM tb_Phone WHERE col_PhoneRcdExpiry is null AND col_PhoneOID = $var_PhoneID "; //echo $sql; if($result = mysql_query($sql,$db)) if($myrow = mysql_fetch_array($result)) { $var_PhoneType = $myrow[ "col_PhoneType" ]; $var_PhoneNumber = $myrow[ "col_PhoneNumber" ]; $var_PhoneExtension = $myrow[ "col_PhoneExtension" ]; $var_Instruction = $myrow[ "col_Instruction" ]; echo " "; } echo "
$var_PhoneNumber
Phone 

Extension 

Type 

Instructions: 
"; } // else if($var_CompanyPersonelID && ($refresh_mode == "ShowContact")) else if(($refresh_mode == "ShowContact")) { echo "
"; $sql = " SELECT col_PersonName, col_Address, col_City, col_PostalCode, col_Spouse FROM tb_CompanyPersonel WHERE col_CompanyPersonelRcdExpiry is null AND col_CompanyPersonelOID = $var_CompanyPersonelID "; //echo $sql; if($result = mysql_query($sql,$db)) if($myrow = mysql_fetch_array($result)) { $var_ContactPersonName = $myrow[ "col_PersonName" ]; $var_ContactAddress = $myrow[ "col_Address" ]; $var_ContactCity = $myrow[ "col_City" ]; $var_ContactPostalCode = $myrow[ "col_PostalCode" ]; $var_ContactSpouse = $myrow[ "col_Spouse" ]; } echo "
$var_ContactPersonName
 Name: 

 Address: 

 City: 

 Postal Code: 

 Spouse Name: 

"; $str_fieldset = "  Phones: 
"; $str_fieldset_end = ""; $str_checked = "checked"; $sql = " SELECT col_PhoneOID as col_PhoneID, col_PhoneType, col_PhoneNumber, col_PhoneExtension, col_Instruction, col_DefaultPhone FROM tb_Phone WHERE col_PhoneRcdExpiry is null AND col_CompanyPersonelOID = $var_CompanyPersonelID ORDER BY col_PhoneOID DESC "; //echo $sql; if($result = mysql_query($sql,$db)) while ($myrow = mysql_fetch_array($result)) { $lst_PhoneID = $myrow[ "col_PhoneID" ]; $lst_PhoneType = $myrow[ "col_PhoneType" ]; $lst_PhoneNumber = $myrow[ "col_PhoneNumber" ]; $lst_PhoneExtension = $myrow[ "col_PhoneExtension" ]; $lst_Instruction = $myrow[ "col_Instruction" ]; $lst_DefaultPhone = $myrow[ "col_DefaultPhone" ]; if(!$lst_PhoneNumber) continue; if($lst_DefaultPhone=="Yes") $str_checked = "checked"; else $str_checked = ""; echo " $str_fieldset "; if ($lst_Instruction) echo " "; $str_fieldset = ""; $str_fieldset_end = "
 ".ShowPhoneNumber($lst_PhoneNumber)."  "; if ($lst_PhoneExtension) echo "Ext: $lst_PhoneExtension "; if ($lst_PhoneType) echo " ($lst_PhoneType) "; echo "
 $lst_Instruction  
"; } echo " $str_fieldset_end
 New Phone: 

"; } else { echo "
 Contacts  
"; $sql = " SELECT tb_CompanyPersonel.col_CompanyPersonelOID as col_CompanyPersonelID, tb_CompanyPersonel.col_PersonName, tb_Phone.col_PhoneNumber, tb_Phone.col_PhoneExtension FROM tb_CompanyPersonel LEFT JOIN tb_Phone ON tb_CompanyPersonel.col_CompanyPersonelOID = tb_Phone.col_CompanyPersonelOID AND tb_Phone.col_ListCompanyOID = $var_VendorID AND tb_Phone.col_DefaultPhone = 'Yes' AND tb_Phone.col_PhoneRcdExpiry is null WHERE tb_CompanyPersonel.col_CompanyPersonelRcdExpiry is null AND tb_CompanyPersonel.col_ListCompanyOID = $var_VendorID "; //echo $sql; if($result = mysql_query($sql,$db)) while ($myrow = mysql_fetch_array($result)) { $lst_PersonName = $myrow[ "col_PersonName" ]; $lst_PhoneNumber = $myrow[ "col_PhoneNumber" ]; $lst_PhoneExtension = $myrow[ "col_PhoneExtension" ]; $lst_CompanyPersonelID = $myrow[ "col_CompanyPersonelID" ]; if(!$lst_PersonName) continue; echo " "; } echo "
 Name    Phone   Ext 
 $lst_PersonName    ".ShowPhoneNumber($lst_PhoneNumber)."   $lst_PhoneExtension 

 New Contact: 
"; } echo "
"; } ?>