search_company_do.php3

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

<?
################################################################
#
#  SEARCH COMPANY DO
#
################################################################

/* init */
$access_level = 150;
include ("../include/config.php3");

/* process */
$title="Lookup Company";
include "../include/header.inc";

if ($debug==1) {
  echo "  <PRE>" . $query . "  </PRE>\n";
}

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

     $numrows=SQL_NUM_ROWS($result);

     $class='color_title';

     echo "<TABLE width='90%' cellspacing='0' cellpadding='2'><TR><TD class='color_title'>\n";
     if ($numrows==0)
     echo "<h1>No company match the criteria</h1>";
     else
     echo "<h1>$msg_there_is $numrows $msg_app_comp</h1>";

echo "</TD></TR><TR></TR></TABLE>";
echo "  <TABLE width='90%' cellspacing='0' cellpadding='2'>\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'>$msg_cmp_name</TH>\n";
echo "      <TH class='color_title'>$msg_cmp_activity</TH>\n";
echo "      <TH class='color_title'>&nbsp;</TH>\n";
echo "      <TH class='color_title'>&nbsp;</TH>\n";
echo "      <TH class='color_title'>&nbsp;</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.upright.document.forms[0].$sender.value='".$rows[$index]["cmp_name_flat"]."';";
  if ($sender2<>"")
    echo "window.parent.upright.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 "      <TD class='$class'>" .
    "<a class='$class' href='display_company.php3?cmp_id=".$rows[$index]["cmp_id"]."' target='upright'>".
    $msg_details."</a>
    </TD>\n";
  echo "      <TD class='$class'>" .
    "<a class='$class' href='add_company_form.php3?cmp_id=".$rows[$index]["cmp_id"]."&mode=edit' target='upright'>".
    $msg_edit."</a>
    </TD>\n";
  echo "      <TD class='$class'>" .
    "<a class='$class' href='../../support/scripts/search_contract_do.php3?contract_search=".$rows[$index]["cmp_id"]."&field=cmp_id'>".
    "contracts"."</a>
    </TD>\n";
  echo "    </TR>\n";
}
echo "  </TABLE>";
include "../include/footer.inc";
?>