[ Selling Categories ]
EOD;
}
$info .= <<
| -$title |
$content |
>> |
$content1 |
EOD;
}
$TMP_H = $gubun;
return $info;
}
$start = microtime();
include 'lib.php';
// $tpl_menu, $tpl_top, $tpl_footer
include 'menu.php';
//head title
$headquery = "SELECT comp_nm|| ' - '|| ' Company Info ' headtitle FROM EMEMBER_T WHERE member_id='$user'";
list($HEAD_TITLE) = ORA_SELECT($connect, $headquery);
// 업체 정보
list($M_GUBUN, $M_COMP_NM, $M_TYPE, $M_COMP_INFO, $M_FOUND_DT, $M_EMPLOYEE, $M_REVENUE_QT, $TRADE_NO)
= ORA_SELECT($connect, "SELECT GUBUN, COMP_NM, TYPE, COMP_INFO, FOUND_DT, EMPLOYEE, REVENUE_QT, TRADE_NO
FROM EMEMBER_T WHERE MEMBER_ID = '$user'");
// location
list($result_loc, $rows_loc) = ORA_SELECT_ALL($connect, "SELECT * FROM ELOCATION_T WHERE MEMBER_ID = '$user'");
// location
// 한글 위치정보가 표시되면 안됨 주석처리 by kbg 20030725
//list($result_loc, $rows_loc) = ORA_SELECT_ALL($connect, "SELECT * FROM KLOCATION_T WHERE MEMBER_ID = '$user'");
// category hms 0828
list($result_cate, $rows_cate) = ORA_SELECT_ALL($connect, "select c.member_id, c.gubun ,
a.CATEGORY_ENM AA, b.CATEGORY_ENM BB
from EMCATEGORY_T c,
( select CATEGORY_ID,STEP,PARENT_ID,CATEGORY_CD,CATEGORY_ENM from category_t where step ='1' ) a,
( select CATEGORY_ID,STEP,PARENT_ID,CATEGORY_CD,CATEGORY_ENM from category_t where step ='2' ) b
where b.parent_id = a.category_id
and b.category_id = c.category_id
and c.member_id = '$user'");
// contact info
$contact_info = GET_CONTACT_INFO($connect, $user, '');
// 오라클 연결 해제
OCILogoff($connect);
$sDesc = $M_COMP_INFO;
if ( strpos(strtolower($sDesc)," -1 || strpos(strtolower($sDesc)," -1 || strpos(strtolower($sDesc)," -1 || strpos(strtolower($sDesc)," -1 || strpos(strtolower($sDesc)," -1 || strpos(strtolower($sDesc)," -1 ){
$sDesc = rtrim($sDesc);
while(strrpos($sDesc, "
") == strlen($sDesc)-4)
{
$sDesc = substr($sDesc, 0, strlen($sDesc)-4);
$sDesc = rtrim($sDesc);
}
} else {
$sDesc = ereg_replace( "<", "<", $sDesc );
$sDesc = ereg_replace( ">", ">", $sDesc );
$sDesc = ereg_replace( " ", " ", $sDesc);
$sDesc = ereg_replace( "\n", "
", $sDesc );
$sDesc = rtrim($sDesc);
}
$tpl_main = <<
| [ Company Profile ] |
EOD;
if ($domain[2] == 'ec21.com') {
$tpl_main .= <<
EOD;
}else{
$tpl_main .= <<
EOD;
}
$tpl_main .= << |
|
|
$aaa
$sDesc
|
EOD;
$gubun_array = array('B'=>'Buyer', 'S'=>'Seller', 'M'=>'Both');
$type_array = array('',
'Manufacturer', // 1
'Trading Company', // 2
'Buying Office', // 3
'Agent', // 4
'Distributor/Wholesaler', // 5
'Retailer', // 6
'Others' // 7
);
$employee_array = array('',
'1 - 5', // 1
'6 - 10', // 2
'11 - 50', // 3
'51 - 100', // 4
'101 - 500', // 5
'501 - 1000', // 6
'Above 1000', // 7
);
$revenue_qt_array = array('',
'Less than USD 100,000', // 1
'USD 100,000 - 500,000', // 2
'USD 500,001 - 1,000,000', // 3
'USD 1,000,001 - 2,000,000', // 4
'USD 2,000,001 - 5,000,000', // 5
'USD 5,000,001 - 10,000,000', // 6
'USD 10,000,001 - 50,000,000', // 7
'USD 50,000,001 - 100,000,000', // 8
'More than 100,000,000', // 9
);
// HMS
for ($i=0 ; $i<$rows_cate ; $i++) {
reset($result_cate);
$tpl_main .= GET_CATE($result_cate[GUBUN][$i], $result_cate[AA][$i], $result_cate[BB][$i]);
}
$tpl_main .= <<
EOD;
if ($M_GUBUN) {
$tpl_main .= GET_INFO('Buyer / Seller in EC21', $gubun_array[$M_GUBUN]);
}
if ($M_TYPE) {
$int_key = (int)$M_TYPE;
$tpl_main .= GET_INFO('Business Type', $type_array[$int_key]);
}
if ($M_FOUND_DT) {
$tpl_main .= GET_INFO('Year established', $M_FOUND_DT);
}
if ($M_EMPLOYEE) {
$int_key = (int)$M_EMPLOYEE;
$tpl_main .= GET_INFO('Employees total', $employee_array[$int_key]);
}
if ($M_REVENUE_QT) {
$int_key = (int)$M_REVENUE_QT;
$tpl_main .= GET_INFO('Annual revenue', $revenue_qt_array[$int_key]);
}
if ($domain[2] == 'ec21.com') {
$sendinquiry .= <<
EOD;
}else {
$sendinquiry .= <<
EOD;
}
$tpl_main .= <<
EOD;
if ($TRADE_NO) { //20020719 TradeNo HMS
$tpl_main .= "
";
}
$tpl_main .= <<| [ Contact Info ] |
|
EOD;
$type_array = array('',
'Corporate headquarters', // 1
'Corporate branch office', // 2
'Sales Office', // 3
'Trading house', // 4
'Factory', // 5
'Warehouse', // 6
'Laboratory' // 7
);
for ($i=0 ; $i<$rows_loc ; $i++) {
reset($result_loc);
$type_key = (int)$result_loc[TYPE][$i];
$ecountry_nm = GET_COUNTRY($connect, $result_loc[COUNTRY_CD][$i]);
$tpl_main .= <<[ Location Info - {$result_loc[LOCATION_NM][$i]} ] |
 Location
type |
{$type_array[$type_key]} |
| Address |
{$result_loc[ADDR3][$i]} {$result_loc[ADDR2][$i]} {$result_loc[ADDR1][$i]} {$result_loc[ZIP_NO][$i]} $ecountry_nm |
| Phone |
{$result_loc[TEL1_NO][$i]} - {$result_loc[TEL2_NO][$i]} - {$result_loc[TEL3_NO][$i]} |
| Fax |
{$result_loc[FAX1_NO][$i]} - {$result_loc[FAX2_NO][$i]} - {$result_loc[FAX3_NO][$i]} |
| Contact |
{$result_loc[CONTACT_NM][$i]} |
|
EOD;
}
$tpl_main .= <<
EOD;
include '_new.tpl';
// for testing
//echo GET_TIME($start) . ' ms';
?>
| |
$title