search_company_do.php3

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

<?

/* Init */

  include "../include/config.php3";

  $title="Lookup Company";
  include "../include/header.inc";
 
  if ($debug==1) {
    echo "  <PRE>" . $query . "  </PRE>\n";
  }

  $result=SQL_SEARCH_CMP($dbproc, $cmp_name, $mode)
  or die("<H2 class=\"error\">sql_query() failed!</H2>");

  $numrows=SQL_NUM_ROWS($result);

  $class='color_title';

  echo "<TABLE width='100%' cellspacing='0' cellpadding='0' border='0'><TR><TD class='color_title'>\n";
  if ($numrows==0)
     echo "<h1>No company match the criteria</h1>";
  else
     echo "<h1>il y a $numrows companies approchantes</h1>";

  echo "</TD></TR><TR></TR></TABLE>";


  echo "  <TABLE width='100%' cellspacing='0' border='0' cellpadding='0'>\n";
  echo "    <TR>\n";
  echo "      <TH class='color_title'>&nbsp;</TH>\n";
  echo "      <TH class='color_title'>Ref</TH>\n";
  echo "      <TH class='color_title'>Name</TH>\n";
  echo "      <TH class='color_title'>Activity</TH>\n";
  echo "    </TR>\n";

  $origfield_id=$origfield . "id";
  $origfield_name=$origfield . "name";
  $col_id=$prefname . "id";
  $col_name=$prefname . "name";

  $printrows=0;
  $rows=SQL_FETCH_RESULT($result);
  for ($index=0;$index<count($rows);$index++)
  {
  if ($class=="color_title")
        $class='tdcl';
            else $class='color_title';

    echo "    <TR>\n";
    echo "      <TD class='$class'>\n";

    echo "        <A HREF=\"javascript:void(0)\"";
    if ($sender<>"")
    echo " onClick=\"window.parent.admin_content1.document.forms[0].$sender.value='".$rows[$index]["cmp_name_flat"]."';";
    if ($sender2<>"")
    echo "window.parent.admin_content1.document.forms[0].$sender2.value='".$rows[$index]["cmp_id"]."'";
    echo "\">";
    echo "<IMG src=\"../images/reload.gif\" border=\"0\"></A></TD>\n";

    echo "      <TD class='$class'>" . $rows[$index]["cmp_id"] . "&nbsp;</TD>\n";
    echo "      <TD class='$class'>" . $rows[$index]["cmp_name_flat"] . "&nbsp;</TD>\n";
    echo "      <TD class='$class'>" . $rows[$index]["cmp_activity"] . "&nbsp;</TD>\n";
    echo "    </TR>\n";
  }
  echo "  </TABLE>";
?>

<?
  include "../include/footer.inc";
?>