📄 messages.php

📁 通达OA部分源代码
💻 PHP
字号:
<?
include_once "logincheck.php"; 
include_once "myconnect.php";
function main()
{
/////////////getting null char
$null_char[0]="-";

$strpass="";
$searchkeyword="";

if ( isset($_REQUEST["keyword"] ) )
{
$strpass=$strpass . "&keyword=" . $_REQUEST["keyword"];
			if (!get_magic_quotes_gpc()) 
			{
			$searchkeyword=str_replace('$', '\$',addslashes($_REQUEST["keyword"]));
			}
			else
			{
			$searchkeyword=str_replace('$', '\$',$_REQUEST["keyword"]);
			}
			$searchkeyword=trim($searchkeyword);

}
$radio=1;
if ( isset($_REQUEST["radio"] ) )
{
$strpass=$strpass . "&radio=" . $_REQUEST["radio"];
$radio=$_REQUEST["radio"];
}


if ( isset($_REQUEST["to_m"] ) )
{
$strpass=$strpass . "&to_m=" . $_REQUEST["to_m"];
}

if ( isset($_REQUEST["from_m"] ) )
{
$strpass=$strpass . "&from_m=" . $_REQUEST["from_m"];
}

if ( isset($_REQUEST["both_m"] ) )
{
$strpass=$strpass . "&both_m=" . $_REQUEST["both_m"];
}
$rs0=mysql_fetch_array(mysql_query("select * from sbbleads_config"));
$recperpage=$rs0["sb_recperpage"];
if ( isset($_REQUEST["recperpage"] ) )
{
$strpass=$strpass . "&recperpage=" . $_REQUEST["recperpage"];
$recperpage=$_REQUEST["recperpage"];
}


$sql0="select * from sbbleads_messages where sb_tid<>0";

$keyword="";

if (isset($_REQUEST["keyword"]) &&( $_REQUEST["keyword"]<>""))
{		
$keyword=$_REQUEST["keyword"];
		$search_str="";
		$keyword_arr=explode(" ",$searchkeyword);

if($_REQUEST["radio"]==1)
{
		foreach($keyword_arr as $key)
		{
			if($search_str=="")
			{
			$search_str="sb_subject like '%$key%' or sb_message like '%$key%'";
			}
			else
			{
			$search_str.=" or sb_subject like '%$key%' or sb_message like '%$key%'";
			}
		}
		$sql0.=" and ($search_str)";

}
if($_REQUEST["radio"]==2)
{
		foreach($keyword_arr as $key)
		{
			if($search_str=="")
			{
			$search_str="sb_subject like '%$key%'";
			}
			else
			{
			$search_str.=" or sb_subject like '%$key%'";
			}
		}
		$sql0.=" and ($search_str)";
}
if($_REQUEST["radio"]==3)
{

		foreach($keyword_arr as $key)
		{
			if($search_str=="")
			{
			$search_str="sb_message like '%$key%'";
			}
			else
			{
			$search_str.=" or sb_message like '%$key%'";
			}
		}
		$sql0.=" and ($search_str)";
}

}//end if

if (isset($_REQUEST["to_m"]) && $_REQUEST["to_m"]<>"")
{		
$to_m=$_REQUEST["to_m"];
$sql0=$sql0." and sb_tid=$to_m";
}//end if

if (isset($_REQUEST["from_m"]) && $_REQUEST["from_m"]<>"")
{		
$from_m=$_REQUEST["from_m"];
$sql0=$sql0." and sb_fid=$from_m";
}//end if

if (isset($_REQUEST["both_m"]) && $_REQUEST["both_m"]<>"")
{		
$both_m=$_REQUEST["both_m"];
$sql0=$sql0." and (sb_fid=$both_m or sb_tid=$both_m)";
}//end if

$sql0=$sql0." order by sb_id desc";


$query=mysql_query($sql0);
$rs_query=mysql_fetch_array($query);

///////////////////////////////////PAGINATION /////////
	if(!isset($_REQUEST["pg"]))
	{
			$pg=1;
	}
	else 
	{
	$pg=$_REQUEST["pg"];
	}

$rcount=mysql_num_rows($query);

if ($rcount==0 )
{ 
	$pages=0;
}	
else
{
	$pages=floor($rcount / $recperpage);
	if  (($rcount%$recperpage) > 0 )
	{
		$pages=$pages+1;
	}
}
$jmpcnt=1;
while ( $jmpcnt<=($pg-1)*$recperpage  && $rs_query = mysql_fetch_array($query) )
    {	
		$jmpcnt = $jmpcnt + 1;
	}

////////////////////////////////////////////////////////////////////////
?>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><table width="100%" border="0" align="center" cellpadding="2" cellspacing="10">
        <tr> 
          <td height="25" colspan="2" bgcolor="#004080"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>&nbsp;Search 
            Messages</strong></font></td>
        </tr>
        <form name="search_form" action="messages.php" method="post" >
          <tr> 
            <td width="50%" bgcolor="#F5F5F5"><div align="right"><strong><font size="2" face="Arial, Helvetica, sans-serif">Keyword:</font></strong></div></td>
            <td><input name="keyword" type="text" id="keyword" value="<? echo $keyword;?>"></td>
          </tr>
          <tr align="left" valign="top"> 
            <td bgcolor="#F5F5F5"><div align="right"><font color="#006699">&nbsp;</font><font size="2" face="Arial, Helvetica, sans-serif"><strong>&nbsp;In:</strong></font></div></td>
            <td><font face="Arial, Helvetica, sans-serif"> <font size="2"> 
              <input name="radio" type="radio" value="1" <? if($radio==1) { echo "checked";}?>>
              All Fields</font></font><font size="2" face="Arial, Helvetica, sans-serif"> 
              <input type="radio" name="radio" value="2" <? if($radio==2) { echo "checked";}?> >
              </font><font face="Arial, Helvetica, sans-serif"><font size="2">Subject 
              </font></font><font size="2" face="Arial, Helvetica, sans-serif">&nbsp; 
              <input type="radio" name="radio" value="3" <? if($radio==3) { echo "checked";}?> >
              Message</font></td>
          </tr>
          <tr> 
            <td bgcolor="#F5F5F5"><div align="right"><strong><font size="2" face="Arial, Helvetica, sans-serif">Record 
                Per Page</font></strong></div></td>
            <td><select name="recperpage">
                <option value="10" <? if($recperpage==10) { echo "selected";}?>>10</option>
                <option value="20" <? if($recperpage==20) { echo "selected";}?>>20</option>
                <option value="30" <? if($recperpage==30) { echo "selected";}?>>30</option>
                <option value="50" <? if($recperpage==50) { echo "selected";}?>>50</option>
                <option value="100" <? if($recperpage==100) { echo "selected";}?>>100</option>
              </select></td>
          </tr>
          <tr> 
            <td bgcolor="#F5F5F5">&nbsp;</td>
            <td><input type="submit" name="Submit2" value="Search"> </td>
          </tr>
        </form>
      </table></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" align="center" cellpadding="2" cellspacing="10">
        <tr> 
          <td valign="top"> <div align="center"> 
              <table width="100%" border="0" cellspacing="0" cellpadding="1">
                <tr> 
                  <td height="25" bgcolor="#004080"> <strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"> 
                    &nbsp; 
                    <?
		  if($keyword<>"")
		  {
         	echo "Search results for <b><font color='#FFCC00'>".$keyword."</font></b>";
			}
		  elseif(isset($_REQUEST["to_m"]))
		  {
		  $member=mysql_fetch_array(mysql_query("select * from sbbleads_members where sb_id=".$to_m));
		  echo "Messages Recieved by <b><font color='#FFCC00'>".$member["sb_username"]."</font></b>";
		 }
		  elseif(isset($_REQUEST["from_m"]))
		  {
		  $member=mysql_fetch_array(mysql_query("select * from sbbleads_members where sb_id=".$from_m));
	      echo "Messages Sent by <b><font color='#FFCC00'>".$member["sb_username"]."</font></b>";
		  } 
		  elseif(isset($_REQUEST["both_m"]))
		  {
 		  $member=mysql_fetch_array(mysql_query("select * from sbbleads_members where sb_id=".$both_m));
    	  echo "Messages Recieved/Sent by <b><font color='#FFCC00'>".$member["sb_username"]."</font></b>";
		 }
		 else
		 {
		 echo "All Messages";
		 }
		  ?>
                    </font></strong></td>
                </tr>
              </table>
            </div></td>
        </tr>
        <tr> 
          <td> <div align="center"> 
              <?
if (!$rs_query)
{
?>
              <br>
              <table align="center" bgcolor="#FEFCFC" bordercolor="#333333" border="1" cellpadding="5" >
                <tr> 
                  <td><font color="#666666"><b><font face="verdana, arial" size="1"> 
                    No Message satisfies the criteria you specified. </font></b></font></td>
                </tr>
              </table>
              <br>
              <?
}//end if 
else
{
?>
            </div></td>
        </tr>
        <tr> 
          <td><div align="center"> 
              <table width="100%" border="0" align="center" cellpadding="1" cellspacing="0">
                <tr bgcolor='#F5F5F5'> 
                  <td height="20"><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font></td>
                  <td height="20" align="center"> <div align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong>To</strong></font></div></td>
                  <td height="20" align="center"> <div align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Subject</strong></font></div></td>
                  <td height="20" align="center"> <div align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong>From</strong></font></div></td>
                  <td height="20"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Message</strong></font></td>
                  <td height="20"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Options</strong></font></td>
                </tr>
                <?
  $cnt=0;
  while ( ($rs_query) && ($cnt<$recperpage))
  {
?>
                <tr bgcolor='<? if ($cnt%2==0) echo "#FFFFFF"; else echo "#F5F5F5"?>'> 
                  <td width="4%"><font size="2" face="Arial, Helvetica, sans-serif"><? echo $jmpcnt;?></font></td>
                  <td width="14%"><font size="2" face="Arial, Helvetica, sans-serif"> 
                    <? 
			$to=mysql_fetch_array(mysql_query("select * from sbbleads_members where sb_id=".$rs_query["sb_tid"]));
			echo $to["sb_username"];?>
                    </font></td>
                  <td width="21%"><font size="2" face="Arial, Helvetica, sans-serif"><? echo $rs_query["sb_subject"];?></font></td>
                  <td width="15%"><font size="2" face="Arial, Helvetica, sans-serif"> 
                    <? 
			$from=mysql_fetch_array(mysql_query("select * from sbbleads_members where sb_id=".$rs_query["sb_fid"]));
			echo $from["sb_username"];?>
                    </font></td>
                  <td width="31%"><font size="1" face="Arial, Helvetica, sans-serif"><? echo substr($rs_query["sb_message"],0,15);
			if(strlen($rs_query["sb_message"])>15)
			echo " ...";?></font></td>
                  <td width="15%"><font size="1" face="Arial, Helvetica, sans-serif">[ <a target=other href="viewmessage.php?id=<? echo $rs_query["sb_id"];?>&pg=<? echo $pg; ?>">View</a> ]&nbsp;&nbsp;[ <a href="deletemessage.php?id=<? echo $rs_query["sb_id"];?>&pg=<? echo $pg; ?>" onClick="javascript: return confirm('Do you really want to delete the Message.');">Delete</a> ]</font></td>
                </tr>
                <?
	  $cnt=$cnt+1;
	  $jmpcnt=$jmpcnt+1;
	  $rs_query=mysql_fetch_array($query);
	  }//  wend
	?>
              </table>
              <table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr> 
                  <td>&nbsp;</td>
                </tr>
                <tr> 
                  <td height="25" bgcolor="#004080"> <p> <font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
                      <strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">&nbsp;Pages: 
                      &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
                      <?

if ($pg>1) 
{
      echo "&nbsp;<a href='".$_SERVER['PHP_SELF']."?pg=".($pg-1).$strpass."' class='pagelink'><font color='#FFCC00'>"; 
    
}//end if
if ($pages<>1)
echo "Previous";
if ($pg>1)
{
echo "</font></a>&nbsp;";
}//end if
echo " ";
for ($i=1; $i<=$pages; $i++)
{
	if ($pg<>$i)
	{
	echo "&nbsp;<a href='".$_SERVER['PHP_SELF']."?pg=".$i.$strpass."' class='pagelink'><font color='#FFCC00'>"; 
	echo $i; 
    echo "</font></a>&nbsp;";
	}
	else
	{
	echo "&nbsp;".$i."&nbsp;";
	}
}//for
echo " ";
	if ($pg<$pages )
	{
	echo "&nbsp;<a href='".$_SERVER['PHP_SELF']."?pg=".($pg+1).$strpass."' class='pagelink'><font color='#FFCC00'>"; 
	}//end if
	if ($pages<>1)
	{
	echo "Next";
	}//end if
	if ($pg<>($pages))
	{
    echo "</font></a>&nbsp;"; 
	}//end if
?>
                      </font> </strong> </font></p></td>
                </tr>
              </table>
            </div></td>
        </tr>
        <? }?>
        <tr> 
          <td><div align="center"></div></td>
        </tr>
      </table></td>
  </tr>
</table>
<p>&nbsp; </p>
<p><br>



<?
}//main()
include "template.php";
?>
⌨️ 快捷键说明

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