search_case_do2.php3

来自「FIREFLY 是一个多用户专业帮助桌面系统」· PHP3 代码 · 共 104 行

<?
################################################################
#
#  SEARCH CASE DO
#
################################################################

/* init */
include ("../include/levels.php3");
$access_level = $r_level["customer"];
include ("../include/config.php3");

/* process */
$title=$msg_search_case;

if ($inf_day or $inf_month or $inf_year)
{
  $datas['liminf'] = SQL_TIME ($inf_day,$inf_month,$inf_year,1,1,30,"datetime");
  $urlinf = "&inf_day=$inf_day&inf_month=$inf_month&inf_year=$inf_year";
}

else
$urlinf = "";

if ($sup_day or $sup_month or $sup_year)
{
  $datas['limsup'] = SQL_TIME ($sup_day,$sup_month,$sup_year,23,59,30,"datetime");
  $urlsup = "&sup_day=$sup_day&sup_month=$sup_month&sup_year=$sup_year";
}
else
$urlsup = "";

switch ($tri1)
{
 case "ASC":
   $tri1 = "DESC";
   break;

 default:
   $tri1 = "ASC";
}

$url = "search_case_do2.php3?search_string=".urlencode($search_string)."&tri1=$tri1$urlsup$urlinf";

if (is_array($field))
{
  while ($line = each($field))
    $url .= "&field[".$line[0]."]=".$line[1];
}

if (is_array($status))
{
  while ($line = each($status))
    $url .= "&status[".$line[0]."]=".$line[1];
}

if ($ctr_id)
     $url .= "&ctr_id=$ctr_id";


     $datas['cmp_id'] = $cmp_id;
     $datas['field'] = $field;
     $datas['tri1'] = $tri1;
     $datas['user_id'] = $user->ent_id;
     $datas['per_id'] = $user->per_id;
     $datas['cmp_id'] = $user->cmp_id;
     $datas['access_level'] = $user->access_level;
     $datas['search_string'] = $search_string;
     $datas['order'] = $order;
     $datas['status'] = $status;
     $datas['mycases'] = $mycases;
     $datas['ctr_id'] = $ctr_id;

     $result = SQL_CASES_SEARCH($dbproc,$datas);
     if ($result)
     $num_res = $result[0]['num_of_rows'];
     include "../include/header.inc";
     $class= 'color_title';

     echo "<TABLE width='90%' cellspacing='1' cellpadding='2' border='0' >
        <TR><TD class='color_title' >
        <H1>$num_res $msg_cases_match</H1>
        </TD></TR>
        </TABLE>
        ";

echo "  <TABLE width='90%' cellspacing='1' cellpadding='2' border='0' >\n";
echo "    <TR>\n";
echo "      <TH class=\"color_title\">$msg_case_id</TH>\n";
echo "      <TH class=\"color_title\"><A class='$class' HREF=\"$url\">$msg_result_status</A></TH>\n";
echo "      <TH class=\"color_title\"><A class='$class' HREF=\"$url&order=level\">$msg_result_level</A></TH>\n";
echo "      <TH class=\"color_title\"><A class='$class' HREF=\"$url&order=deposit\">$msg_case_deposit</A></TH>\n";
echo "      <TH class=\"color_title\">&nbsp;&nbsp;</TH>\n";
echo "      <TH class=\"color_title\"><A class='$class' HREF=\"$url&order=lastupd\">$msg_result_lastupd</A></TH>\n";
echo "      <TH class=\"color_title\">&nbsp;&nbsp;</TH>\n";
echo "      <TH class=\"color_title\"><A class='$class' HREF=\"$url&order=contract\">$msg_result_ctrref</A></TH>\n";
echo "      <TH class=\"color_title\"><A class='$class' HREF=\"$url&order=contact\">$msg_result_caller</A></TH>\n";
echo "      <TH class=\"color_title\"><A class='$class' HREF=\"$url&order=company\">$msg_menu_company</A></TH>\n";
echo "    </TR>\n";
$class = 'tdcl';
for ($index=0;$index<$num_res;$index++)
{
  echo "    <TR>\n";
  echo "      <TD class='$class' ><A class='$class' HREF='display_case.php3?cas_id=".$result[$index]["cas_id"]."&search_string=".urlencode($search_string)."' target='upright' ><IMG src='../images/magnify_small.gif' width='13' height='15' border='0' align='top'> n