⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 left_panel1.php

📁 通达OA部分源代码
💻 PHP
字号:
<?
function left()
{
/////---getting settings
$sbq_con="select * from sbbleads_config where sb_id=1";
$sbrow_con=mysql_fetch_array(mysql_query($sbq_con));
$sb_recent_count=$sbrow_con["sb_recent_count"];

$sbq_icon="select * from sbbleads_icons where sb_id=".$sbrow_con["sb_icon_list"];
$sbrow_icon=mysql_fetch_array(mysql_query($sbq_icon));
$sb_bar=$sbrow_icon["sb_bar"];
$sb_how_to_sell=$sbrow_icon["sb_how_to_sell"];
$sb_how_to_buy=$sbrow_icon["sb_how_to_buy"];
$sb_join_now=$sbrow_icon["sb_join_now"];
$sb_mem_area=$sbrow_icon["sb_mem_area"];
$sb_more=$sbrow_icon["sb_more"];


$username="";
$pwd="";
if(isset($_COOKIE["softbiz_blead_user"]))
{

$username=$_COOKIE["softbiz_blead_user"];
}
if(isset($_COOKIE["softbiz_blead_pwd"]))
{
$pwd=$_COOKIE["softbiz_blead_pwd"];
}


?>
<table width="150" border="0" align="left" cellpadding="0" cellspacing="0" >
  <tr> 
    <td><table width="100%" border="0" cellspacing="0" cellpadding="2" >
        <tr> 
          <td colspan="2"   class="sidetitle" ><strong>&nbsp;<img src="admin/sbbleads_icons/<?php echo $sb_bar; ?>"  align="absmiddle" border="0">&nbsp;&nbsp;<font size="2" face="Arial, Helvetica, sans-serif">Welcome 
            </font></strong></td>
        </tr>
        <tr> 
          <td width="2" bgcolor="#F2F2F2">&nbsp;</td>
          <td width="160" bgcolor="#F2F2F2"><a href="how_to_sell.php" target="_blank"><img src="admin/sbbleads_icons/<?php echo $sb_how_to_sell; ?>" border="0" align="absmiddle" title="How to sell"></a></td>
        </tr>
        <tr> 
          <td bgcolor="#F2F2F2">&nbsp;</td>
          <td bgcolor="#F2F2F2"><a href="how_to_buy.php" target="_blank"><img src="admin/sbbleads_icons/<?php echo $sb_how_to_buy; ?>" border="0" align="absmiddle" title="How to buy"></a></td>
        </tr>
        <tr> 
          <td bgcolor="#F2F2F2">&nbsp;</td>
          <td bgcolor="#F2F2F2"> 
            <?php 
		  if(isset($_SESSION["sbbleads_userid"]))
		  {?>
            <a href="userhome.php" ><img src="admin/sbbleads_icons/<?php echo $sb_mem_area; ?>" border="0" align="absmiddle" title="Member Home"></a> 
            <?php 
		  }		//end if session
		  else
		  {?>
            <a href="signup.php" ><img src="admin/sbbleads_icons/<?php echo $sb_join_now; ?>" border="0" align="absmiddle" title="Signup Now"></a> 
            <?php 
		  }		//end else session not ?>
          </td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
        <tr> 
          <td colspan="2"   class="sidetitle" ><strong>&nbsp;<img src="admin/sbbleads_icons/<?php echo $sb_bar; ?>"  align="absmiddle" border="0">&nbsp;&nbsp;<font size="2" face="Arial, Helvetica, sans-serif">Sell 
            Offers</font></strong></td>
        </tr>
        <?php 
		$sbq_off="select * from sbbleads_offers where sb_approved='yes' order by sb_id desc";
		$sbrs_off=mysql_query($sbq_off);
		$sb_no_of_row=mysql_num_rows($sbrs_off);
		if($sb_no_of_row > 0)
		{
			$sbcount=0;
			while( ($sbrow_off=mysql_fetch_array($sbrs_off)) && ($sbcount < $sb_recent_count) )
			{	
				$sbcount++;
				?>
        <tr> 
          <td bgcolor="#F2F2F2" width="2"></td>
          <td width="160" bgcolor="#F2F2F2"><a href="view_offer.php?id=<?php echo $sbrow_off['sb_id']; ?>"><?php 				if (strlen ($sbrow_off["sb_title"])>15)
					{
					 echo substr($sbrow_off["sb_title"], 0,  strrpos( substr($sbrow_off["sb_title"], 0, 15),' ' ));  
					}
					else
					{
					 echo $sbrow_off["sb_title"];  
					}
		//echo $sbrow_off['sb_title']; ?></a><font class="red"><strong> 
            [<?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"]; ?>
            ]</strong></font></td>
        </tr>
        <?php 	
			}		//end while
			if($sb_no_of_row > $sb_recent_count)
			{?>
        <tr> 
          <td bgcolor="#F2F2F2"></td>
          <td bgcolor="#F2F2F2"><div align="right"><a href="selloffers.php" ><img src="admin/sbbleads_icons/<?php echo $sb_more; ?>"   border="0" alt="More"></a></div></td>
        </tr>
        <?php		}	//end if $sb_no_of_row > $sb_recent_count i.e. whether to show more link
		}
		else
		{ ?>
        <!--tr> 
          <td bgcolor="#F2F2F2"></td>
          <td bgcolor="#F2F2F2">No Latest entry available</td>
        </tr-->
        <?php 
		}	//end else ?>
      </table></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
        <tr> 
          <td colspan="2"   class="sidetitle" ><strong>&nbsp;<img src="admin/sbbleads_icons/<?php echo $sb_bar; ?>"  align="absmiddle" border="0">&nbsp;&nbsp;<font size="2" face="Arial, Helvetica, sans-serif">Buy 
            Offers </font></strong></td>
        </tr>
        <?php 
		$sbq_off="select * from sbbleads_offers_buy where sb_approved='yes' order by sb_id desc";
		$sbrs_off=mysql_query($sbq_off);
		$sb_no_of_row=mysql_num_rows($sbrs_off);
		if( ($sb_no_of_row > 0) )
		{
			$sbcount=0;
			while( ($sbrow_off=mysql_fetch_array($sbrs_off)) && ($sbcount < $sb_recent_count) )
			{	
				$sbcount++;
			?>
        <tr> 
          <td bgcolor="#F2F2F2" width="2"></td>
          <td width="159" bgcolor="#F2F2F2"><a href="view_offer_buy.php?id=<?php echo $sbrow_off['sb_id']; ?>"><?php 			if (strlen ($sbrow_off["sb_title"])>15)
					{
					 echo substr($sbrow_off["sb_title"], 0,  strrpos( substr($sbrow_off["sb_title"], 0, 15),' ' ));  
					}
					else
					{
					 echo $sbrow_off["sb_title"];  
					}
		//echo $sbrow_off['sb_title']; ?></a></td>
        </tr>
        <?php 	
			}		//end while
			if($sb_no_of_row > $sb_recent_count)
			{?>
        <tr> 
          <td width="3" bgcolor="#F2F2F2"></td>
          <td bgcolor="#F2F2F2"><div align="right"><a href="buyoffers.php" ><img src="admin/sbbleads_icons/<?php echo $sb_more; ?>"   border="0" alt="More"></a></div></td>
        </tr>
        <?php		}			//end if $sb_no_of_row > $sb_recent_count i.e. whether to show more link
		}
		else
		{ ?>
        <!--tr> 
          <td bgcolor="#F2F2F2" width="2"></td>
          <td bgcolor="#F2F2F2">No Latest entry available</td>
        </tr-->
        <?php 
		}	//end else ?>
      </table></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
        <tr> 
          <td colspan="2"   class="sidetitle" ><strong>&nbsp;<img src="admin/sbbleads_icons/<?php echo $sb_bar; ?>"  align="absmiddle" border="0">&nbsp;&nbsp;<font size="2" face="Arial, Helvetica, sans-serif">Product 
            Catalogs</font></strong></td>
        </tr>
        <?php 
		$sbq_off="select * from sbbleads_products where sb_approved='yes' order by sb_id desc";
		$sbrs_off=mysql_query($sbq_off);
		$sb_no_of_row=mysql_num_rows($sbrs_off);
		if( ($sb_no_of_row > 0) )
		{
			$sbcount=0;
			while( ($sbrow_off=mysql_fetch_array($sbrs_off)) && ($sbcount < $sb_recent_count) )
			{	
				$sbcount++;
	?>
        <tr> 
          <td bgcolor="#F2F2F2" width="2"></td>
          <td width="160" bgcolor="#F2F2F2"><a href="view_product.php?id=<?php echo $sbrow_off['sb_id']; ?>"><?php 			if (strlen ($sbrow_off["sb_title"])>15)
					{
					 echo substr($sbrow_off["sb_title"], 0,  strrpos( substr($sbrow_off["sb_title"], 0, 15),' ' ));  
					}
					else
					{
					 echo $sbrow_off["sb_title"];  
					}
		//echo $sbrow_off['sb_title']; ?></a></td>
        </tr>
        <?php 	
			}		//end while
			if($sb_no_of_row > $sb_recent_count)
			{?>
        <tr> 
          <td bgcolor="#F2F2F2"></td>
          <td bgcolor="#F2F2F2"><div align="right"><a href="products.php" ><img src="admin/sbbleads_icons/<?php echo $sb_more; ?>"   border="0" alt="More"></a></div></td>
        </tr>
        <?php		}			//end if $sb_no_of_row > $sb_recent_count i.e. whether to show more link
		}
		else
		{ ?>
        <!--tr> 
          <td bgcolor="#F2F2F2">No Latest entry available</td>
        </tr-->
        <?php 
		}	//end else ?>
      </table></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
        <tr> 
          <td   class="sidetitle"  colspan="2"><strong>&nbsp;<img src="admin/sbbleads_icons/<?php echo $sb_bar; ?>"  align="absmiddle" border="0">&nbsp;<font size="2" face="Arial, Helvetica, sans-serif">Company 
            Profiles </font></strong></td>
        </tr>
        <?php 
		$sbq_off="select * from sbbleads_companyprofiles where sb_approved='yes' order by sb_id desc";
		$sbrs_off=mysql_query($sbq_off);
		$sb_no_of_row=mysql_num_rows($sbrs_off);
		if( ($sb_no_of_row > 0) )
		{
			$sbcount=0;
			while( ($sbrow_off=mysql_fetch_array($sbrs_off)) && ($sbcount < $sb_recent_count) )
			{	
				$sbcount++;
	?>
        <tr> 
            <td bgcolor="#F2F2F2" width="2"></td>
  			<td width="160" bgcolor="#F2F2F2"><a href="view_profile.php?id=<?php echo $sbrow_off['sb_id']; ?>"><?php 			if (strlen ($sbrow_off["sb_companyname"])>15)
					{
					 echo substr($sbrow_off["sb_companyname"], 0,  strrpos( substr($sbrow_off["sb_companyname"], 0, 15),' ' ));  
					}
					else
					{
					 echo $sbrow_off["sb_companyname"];  
					}
		//echo $sbrow_off['sb_companyname']; ?></a> 
            <font class="red"><strong>[
            <?php 
	$mem=mysql_fetch_array(mysql_query("select * from sbbleads_members where sb_id=".$sbrow_off["sb_uid"]));
	$cur=mysql_fetch_array(mysql_query("select * from sbbleads_country where id=".$mem["sb_country"]));
	echo $cur["country"];
				?>
            ]</strong></font></td>
        </tr>
        <?php 	
			}		//end while
			if($sb_no_of_row > $sb_recent_count)
			{?>
        <tr> 
          <td bgcolor="#F2F2F2" ></td>
          <td bgcolor="#F2F2F2"><div align="right"><a href="profiles.php" ><img src="admin/sbbleads_icons/<?php echo $sb_more; ?>"   border="0" alt="More"></a></div></td>
        </tr>
        <?php		}	//end if $sb_no_of_row > $sb_recent_count i.e. whether to show more link
		}
		else
		{ ?>
        <!--tr> 
          <td bgcolor="#F2F2F2">No Latest entry available</td>
        </tr-->
        <?php 
		}	//end else ?>
      </table></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td><FORM name=loginForm  action="login.php"
      method=post>
        <div align="center"></div>
        <table width="100%" border=0 align=center cellpadding=2 cellspacing=0 class="innertablestyle">
          <tbody>
            <tr valign=center> 
              <? if(!isset($_SESSION["sbbleads_userid"])) 
			  {
			  ?>
              <td colspan="2"  class="sidetitle" ><strong><img src="admin/sbbleads_icons/<?php echo $sb_bar; ?>"  align="absmiddle" border="0">&nbsp;&nbsp;Member 
                Login</strong></td>
            </tr>
            <tr valign=center> 
              <td> <div align=right><font class="smalltext"><strong>Username</strong></font></div></td>
              <td width="97"><font color="#006699"> 
                <input  name="username" type="text" size="10">
                </font></td>
            </tr>
            <tr valign=center> 
              <td> <div align=right><font class="smalltext"><strong>Password</strong></font></div></td>
              <td> <input name="pwd"  type=password id="pwd"   size="10"> 
              </td>
            </tr>
            <tr valign=center> 
              <td colspan="2"><input name="remember_user" type="checkbox" id="remember_user" value="yes"> 
                <font class="smalltext">Remember Username/Password</font></td>
            </tr>
            <tr align=right> 
              <td 
        colspan=2> <table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr> 
                    <td width="67%"><p><font color="#006699"><a  class="insidelink"  href="signup.php">Signup 
                        Now</a><br>
                        <a class="insidelink" href="lostpassword.php">Lost Password</a></font></p></td>
                    <td width="33%"> <div align="left"> <font color="#006699"> 
                        <input type="submit" name="Submit" value="Sign In" >
                        </font></div></td>
                  </tr>
                </table></td>
              <? }?>
            </tr>
            <tr align=right> 
              <td colspan=2>&nbsp; </td>
            </tr>
          </tbody>
        </table>
        <div align="center"></div>
      </FORM></td>
  </tr>
</table>
<?
}// end left
?>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -