include('admin/inc/123456.php');
include('admin/inc/mysql.php');
include('admin/inc/functions.php');
include('inc/proverko.php');
if (isset($_GET['id'])) {$id=htmlspecialchars(strip_tags($_GET['id']),ENT_QUOTES);} else {$id=0;}
$query_company=mysql_query("SELECT name,address FROM `tbl_company` WHERE `id`='".$id."' LIMIT 1 ",$dbcnx);
$arr_rez_company=array();
while ($rez_company=mysql_fetch_array($query_company, MYSQL_NUM))
{
$arr_rez_company[]=$rez_company;
}
if (count($arr_rez_company)==1)
{
$name_company_cats2=$arr_rez_company[0][0];
$address_company_cats2=$arr_rez_company[0][1];
}
else
{
header("Location: ".$URL);
}
?>
Контакты:
echo $address_company_cats2;?>
Список товаров и услуг echo $name_company_cats2;?>
$query_cats1=mysql_query("SELECT DISTINCT `parent_id` FROM `product` WHERE `company_id` = '".$id."' ",$dbcnx);
$arr_rez_cats1=array();
while ($rez_cats1=mysql_fetch_array($query_cats1, MYSQL_NUM))
{
$arr_rez_cats1[]=$rez_cats1;
}
$count_cats1=count($arr_rez_cats1);
if ($count_cats1>0)
{
for ($i=0; $i<$count_cats1; $i++)
{
$query_parr1=mysql_query("SELECT `name`,`parent_id` FROM `category` WHERE `id` = '".$arr_rez_cats1[$i][0]."' ",$dbcnx);
$arr_rez_parr1=array();
while ($rez_parr1=mysql_fetch_array($query_parr1, MYSQL_NUM))
{
$arr_rez_parr1[]=$rez_parr1;
}
$count_parr1=count($arr_rez_parr1);
if ($count_parr1>0)
{
$query_parr2=mysql_query("SELECT `name`, `parent_id` FROM `category` WHERE `id` = '".$arr_rez_parr1[0][1]."' ",$dbcnx);
$arr_rez_parr2=array();
while ($rez_parr2=mysql_fetch_array($query_parr2, MYSQL_NUM))
{
$arr_rez_parr2[]=$rez_parr2;
}
$count_parr2=count($arr_rez_parr2);
}
echo "
".$arr_rez_parr2[0][0]." - ".$arr_rez_parr1[0][0]."
";
$query_cats5=mysql_query("SELECT `id`,`name`,`gost`,`country`,`ed_id` FROM `product` WHERE `company_id` = '".$id."' and `parent_id`='".$arr_rez_cats1[$i][0]."' ",$dbcnx);
$arr_rez_cats5=array();
while ($rez_cats5=mysql_fetch_array($query_cats5, MYSQL_NUM))
{
$arr_rez_cats5[]=$rez_cats5;
}
$count_cats5=count($arr_rez_cats5);
if ($count_cats5>0)
{//
echo "
Товар (услуга) |
Тех. информация |
Ед. изм. |
Цена, сум |
";
for ($i5=0; $i5<$count_cats5; $i5++)
{
$id_cats5=$arr_rez_cats5[$i5][0];
$name_cats5=$arr_rez_cats5[$i5][1];
$gost_cats5=$arr_rez_cats5[$i5][2];
$country_cats5=$arr_rez_cats5[$i5][3];
$ed_id_cats5=$arr_rez_cats5[$i5][4];
$query_edizm=mysql_query("SELECT name FROM `tbl_edizm` WHERE `id`='".$ed_id_cats5."' LIMIT 1 ",$dbcnx);
$arr_rez_edizm=array();
while ($rez_edizm=mysql_fetch_array($query_edizm, MYSQL_NUM))
{
$arr_rez_edizm[]=$rez_edizm;
}
if (count($arr_rez_edizm)==1) $ed_cats5=$arr_rez_edizm[0][0]; else $ed_cats5='???';
$query_price=mysql_query("SELECT price,date FROM `price` WHERE `id_product`='".$id_cats5."' ORDER BY `date` DESC LIMIT 1 ",$dbcnx);
$arr_rez_price=array();
while ($rez_price=mysql_fetch_array($query_price, MYSQL_NUM))
{
$arr_rez_price[]=$rez_price;
}
if (count($arr_rez_price)==1)
{
$price_price=$arr_rez_price[0][0];
$date_price=$arr_rez_price[0][1];
$date_price="Цена по состоянию на ".$date_price;
}
else
{
$price_price='по заявке';
$date_price='нет данных';
}
if ($price_price=='0') {$price_price='по заявке';}
if (($gost_cats5!='') and ($gost_cats5!='-') and ($country_cats5!='') and ($country_cats5!='-'))
{
$text_gost_cats5=$gost_cats5." (".$country_cats5.")";
}
else
{
if (($gost_cats5=='') or ($gost_cats5=='-')) {$text_gost_cats5=$country_cats5;}
if (($country_cats5=='') or ($country_cats5=='-')) {$text_gost_cats5=$gost_cats5;}
if ((($gost_cats5=='') or ($gost_cats5=='-')) and ($country_cats5=='')) {$text_gost_cats5='';}
}
echo "
".$name_cats5." |
".$text_gost_cats5." |
".$ed_cats5." |
".kkk($price_price)." | ";
}
echo "
";
}//
}
$query_bot_print=mysql_query("SELECT text FROM `text` WHERE `id` = '23' LIMIT 1",$dbcnx);
$arr_rez_bot_print=array();
while ($rez_bot_print=mysql_fetch_array($query_bot_print, MYSQL_NUM))
{
$arr_rez_bot_print[]=$rez_bot_print;
}
$count_bot_print=count($arr_rez_bot_print);
if ($count_bot_print!=0)
{
$text_bot_print=$arr_rez_bot_print[0][0];
}
else
{
$text_bot_print="C уважением, Администрация ООО «MEGA EXPERT GROUP»";
}
echo pic($text_bot_print, $URL);
}
?>
}
else // доступ закрыт
{
$query_please=mysql_query("SELECT text FROM `text` WHERE `id` = '19' LIMIT 1",$dbcnx);
$arr_rez_please=array();
while ($rez_please=mysql_fetch_array($query_please, MYSQL_NUM))
{
$arr_rez_please[]=$rez_please;
}
$count_please=count($arr_rez_please);
if ($count_please!=0)
{
$text_please=$arr_rez_please[0][0];
}
else
{
$text_please="Раздел доступен только зарегистрированным пользователям";
}
echo pic($text_please, $URL);
}
?>