search_contract_do.php3

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

<?
################################################################
#
#  SEARCH CONTRACT DO
#
################################################################

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

/* process */
$title=$msg_search_contract;

if ($field=="cmp_id")
     $mode="equal";

     if ($user->access_level > $r_level["support"])
{
  $mode = "equal";
  $expired = "all";
  if ($user->cmp_id)
    {
      $contract_search = $user->cmp_id;
      $field = "cmp_id";
      $mode = "equal";
    }
  else if ($user->per_id)
    {
      $contract_search = $user->per_id;
      $field = "per_id";
      $mode = "equal";
    }
  else
    header("location:denied.php3?mess=Not_allowed_to_display_contracts");
}
include "../include/header.inc";
$result=SQL_LIST_CTRS($dbproc, $contract_search, $field , $mode, $expired);
$numrows=0;
if ($result) $numrows=SQL_NUM_ROWS($result);

echo "<TABLE width='90%' cellspacing='1' cellpadding='2' border='0' >
        <TR><TD class='color_title' >";
if ($numrows==0)
     echo "<h1>$msg_nocontract</h1>";
     else
     echo "<h1>$msg_eml $numrows $msg_find_contract</h1>";
echo "</TD></TR>
        </TABLE>
        ";

echo "  <TABLE width='90%' cellspacing='1' cellpadding='2' border='0' >\n";
echo "    <TR>";
echo "      <TH class='color_title'>$msg_ctr_ref</TH>\n";
echo "      <TH class='color_title'>$msg_cmp_crt</TH>\n";
echo "      <TH class='color_title'>$msg_sign_date</TH>\n";
echo "      <TH class='color_title'>$msg_type_crt</TH>\n";
echo "      <TH class='color_title'>$msg_cases</TH>\n";
echo "    </TR>\n";

$printrows=0;
$rows=SQL_FETCH_RESULT($result);
$class = "tdcl";
for ($index=0;$index<count($rows);$index++)
{
  echo "    <TR class=\"rows" . ($index % 2) . "\">\n";
  echo "      <TD valign='top' class='$class' ><A class='$class' HREF='display_contract.php3?ctr_id=" . $rows[$index]["ctr_id"] . "' target='upright' ><IMG src='../images/magnify_small.gif' width='13' height='15' border='0' align='top'>&nbsp;<B>" . $rows[$index]["ctr_ref"] . "</B></A></TD>\n";
  echo "      <TD valign='top' class='$class' ><A class='$class' HREF='/modules/contacts/scripts/display_company.php3?cmp_id=" . $rows[$index]["cmp_id"] . "' target='upright' >" . $rows[$index]["cmp_name_flat"] . "</A></TD>\n";
  echo "      <TD valign='top' class='$class' >" . $rows[$index]["cdet_signdate"] . "</TD>\n";
  echo "      <TD valign='top' class='$class' ><i>" . $contract_type[$rows[$index]["cdet_type"]] . "</i></TD>\n";
  echo "      <TD valign='top' class='$class' ><A class='$class' HREF='search_case_do2.php3?ctr_id=" . $rows[$index]["ctr_id"] . "'>list cases<IMG src='../images/right_small.gif' width='10' height='12' border='0' align='middle'></TD>\n";
  echo "    </TR>\n";

  if ($class == 'tdcl')
    $class = 'color_title';
  else
    $class = 'tdcl';

}
echo "  </TABLE>";
include "../include/footer.inc";
?>