view_product.php

通达OA部分源代码

<?php
include_once "myconnect.php";
include_once "date_time_format.php";


if(!isset($_REQUEST['id']) || !is_numeric($_REQUEST['id']) || ($_REQUEST['id'] == 0) )
{
	header("Location: gen_confirm.php?errmsg=".urlencode("Invalid access, denied"));
	die();
}

$id=$_REQUEST['id'];

$sbq_off="select *,UNIX_TIMESTAMP(sb_postedon) as sbposted from sbbleads_products where sb_id=$id and sb_approved='yes'";
//die($sbq_off);
$sbrow_off=mysql_fetch_array(mysql_query($sbq_off));
if(!$sbrow_off)
{
	header("Location: gen_confirm.php?errmsg=".urlencode("No such product catalog exists or disabled by admin"));
	die();
}
///////////------updating view count
$sbqu_off="update sbbleads_offers set sb_viewed=sb_viewed+1 where sb_id=$id";
mysql_query($sbqu_off);

//////////---------
function main()
{
	global $sbrow_off;
	
$id=$_REQUEST['id'];

	$config=mysql_fetch_array(mysql_query("select * from sbbleads_config"));
	
	if(($config["sb_image_magik"]=="enable"))
	{
	$img_path="thumbs2/";
	$img_pmt="";
	}
	else
	{
	$img_path="uploadedimages/";
	$img_pmt="width=".$config["sb_th_width2"]." height=".$config["sb_th_width2"];
}
	$icons=mysql_fetch_array(mysql_query("select * from sbbleads_icons where sb_id=".$config["sb_icon_list"]));
	$send_inquiry_icon="admin/sbbleads_icons/".$icons["sb_send_inquiry"];
	$inquiry_basket_icon="admin/sbbleads_icons/".$icons["sb_inquiry_basket"];
	$contact_list_icon="admin/sbbleads_icons/".$icons["sb_contact_list"];
	$block_list_icon="admin/sbbleads_icons/".$icons["sb_block_list"];
	$add_fav_icon="admin/sbbleads_icons/".$icons["sb_add_fav"];
	$company_profile_icon="admin/sbbleads_icons/".$icons["sb_profile"];

$cid=0;
$keyword="";

	if(isset($_REQUEST["cid"])&&($_REQUEST["cid"]<>""))
	{
	$cid=$_REQUEST["cid"];
	}

	if(isset($_REQUEST["keyword"])&&($_REQUEST["keyword"]<>""))
	{
		$keyword=$_REQUEST["keyword"];
	}


	$catname="";
	$category=0;
  
  	$cat_query=mysql_query("Select * from sbbleads_categories where sb_id=" . $cid );
	if ($cat=mysql_fetch_array($cat_query))
	{
	$catname=$cat["sb_cat_name"];
	$category=$cat["sb_id"];
	}

	$catpath="";
  	$cat_query=mysql_query("Select * from sbbleads_categories where sb_id=" . $cid );
	while ($rs=mysql_fetch_array($cat_query))
    {
    $catpath =" > <a href=\"cat_products.php?cid=" . $rs["sb_id"] . "\">" .$rs["sb_cat_name"]."</a>".$catpath; 
  	$cat_query=mysql_query("Select * from sbbleads_categories where sb_id=" . $rs["sb_pid"] );
	 
	}
		   $mem=mysql_fetch_array(mysql_query("select * from sbbleads_members where sb_id=".$sbrow_off["sb_uid"]));
		  $profile=mysql_fetch_array(mysql_query("select * from sbbleads_companyprofiles where sb_uid=".$sbrow_off["sb_uid"]));


?> 
<script language="JavaScript">
function win(box)
{
str="addcontact_popup.php?"  + box;

window.open(str,"Allot","top=5,left=30,toolbars=no,maximize=yes,resize=yes,width=350,height=150,location=no,directories=no,scrollbars=yes");
return false;
}

function win1(box)
{
str="addblock_popup.php?"  + box;

window.open(str,"Allot","top=5,left=30,toolbars=no,maximize=yes,resize=yes,width=350,height=150,location=no,directories=no,scrollbars=yes");
return false;
}
</script>
<table width="100%" border="0" cellspacing="10" cellpadding="2" class="maintablestyle">
  <tr> 
    <td valign="top"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" class="onepxtable">
        <tr> 
          <form name="form1" method="post" action="search.php">
            <td align="center" valign="middle" class="innertablestyle"><br> <input name="keyword" type="text" value="<? echo $keyword;?>" size="40"> 
              &nbsp;&nbsp; <select name="type">
                <option value="1">Sell Offers</option>
                <option value="2">Buy Offers</option>
                <option value="3" selected>Products Catalogs</option>
                <option value="4">Company Profiles</option>
              </select>
              &nbsp;&nbsp;<font class='normal'>
              <input name="show_save" type="hidden" id="show_save" value="yes">
              </font> 
              <input type="submit" name="Submit" value="Search"> 
              &nbsp;<a href="advance_search.php">Advance Search</a> <br> &nbsp; 
            </td>
          </form>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td valign="top"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" >
        <tr> 
          <td> 
            <!--font class="normal">&nbsp;<a href="index.php">Home</a><? echo $catpath;?></font-->
          </td>
        </tr>
        <tr> 
          <td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" class="titlestyle">
              <tr> 
                <td width="150" align="center" valign="middle" >&#8595; &nbsp;Product 
                  Catalog </td>
                <td valign="middle"  class="subtitle"> &nbsp;<?php echo $sbrow_off["sb_title"]; ?> 
                  <div align="left"></div>
                  <div align="right" ></div></td>
              </tr>
            </table></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td valign="top"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="1" class="onepxtable">
        <tr valign="top"> 
          <td><table width="100%" border="0" cellspacing="1" cellpadding="1">
              <tr valign="top"> 
                <td width="50%"> <table width="100%" border="0" cellpadding="2" cellspacing="1">
                    <tr valign="top" class="onepxtable"> 
                      <td width="40%" height="25" class="subtitle"> <div align="left">Price 
                        </div></td>
                      <td width="60%" height="25" class="innertablestyle" > <font class="normal"> 
                        <?php 
		  $sbq_cur="select * from sbbleads_currencies where sbcur_id=".$sbrow_off["sb_price_cur_id"];
		  $sbrow_cur=mysql_fetch_array(mysql_query($sbq_cur));
		  echo $sbrow_cur['sbcur_symbol'].' '.$sbrow_off["sb_price"]; ?>
                        </font></td>
                    </tr>
                    <tr valign="top" class="onepxtable"> 
                      <td width="40%" height="25" class="subtitle"> <div align="left">Location</div></td>
                      <td width="60%" height="25" class="innertablestyle" ><font class="normal"><?php echo $sbrow_off["sb_location"]; ?></font></td>
                    </tr>
                    <tr valign="top" class="onepxtable"> 
                      <td width="40%" height="25" class="subtitle"> <div align="left">Posted 
                          On</div></td>
                      <td width="60%" height="25" class="innertablestyle" ><font class='normal'><?php echo sb_date($sbrow_off["sbposted"]);?></font></td>
                    </tr>
                    <tr valign="top" class="onepxtable"> 
                      <td width="40%" height="25" class="subtitle"> <div align="left">Posted 
                          By</div></td>
                      <td width="60%" height="25" class="innertablestyle" ><strong><font class="normal"> 
                        <?php 
		  if ($profile) 
		   	echo $profile["sb_companyname"]; 
		  else   
		  	echo $mem["sb_username"];
 ?>
                        </font><font class="smalltext"><font class="red"><strong>[ 
                        <?php  
			$level_query=mysql_query("select * from sbbleads_levels where sb_levelid=" .$mem["sb_memtype"]);