/[fcproducts]/index.php
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /index.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.2 by dpavlin, Wed Jun 6 07:04:04 2001 UTC revision 1.6 by ravilov, Wed Jun 6 08:55:25 2001 UTC
# Line 14  Line 14 
14                          if ($PHP_AUTH_PW != $row[0]) $auth = false;                          if ($PHP_AUTH_PW != $row[0]) $auth = false;
15                  }                  }
16          }          }
17          if (!$auth) {          if (!$auth || $relogin == $PHP_AUTH_USER) {
18                  Header("WWW-Authenticate: Basic realm=\"fcproducts\"");                  Header("WWW-Authenticate: Basic realm=\"fcproducts\"");
19                  Header("HTTP/1.0 401 Unauthorized");                  Header("HTTP/1.0 401 Unauthorized");
20                  echo "<HTML><B>No access.</B></HTML>\n";                  echo "<HTML><B>No access.</B></HTML>\n";
21                  exit;                  exit;
22          }          }
23  //      if (!$id) { echo "<HTML><B>No product ID!</B></HTML>\n"; exit; }          # if (!$id) { echo "<HTML><B>No product ID!</B></HTML>\n"; exit; }
24          if (!$id) { $id=1; }          DBOpen();
25            if (!$id) {
26                    $id = 1;
27                    $row = DBQuery("SELECT MIN(product_id) FROM products");
28                    if ($row[0]) $id = $row[0][0];
29            }
30          $error = "";          $error = "";
31          $msg = false;          $msg = false;
32          $err = 0;          $err = 0;
         DBOpen();  
33          $row = DBQuery("SELECT market,production,purchasing,economics,risks,competition,potential,portfolio,sales,quality,dosage,evaluation,comment FROM user_product WHERE (product_id=$id) AND (login='$PHP_AUTH_USER')");          $row = DBQuery("SELECT market,production,purchasing,economics,risks,competition,potential,portfolio,sales,quality,dosage,evaluation,comment FROM user_product WHERE (product_id=$id) AND (login='$PHP_AUTH_USER')");
         if (is_array($row[0]) && count($row[0]) > 0) bool_fix($row[0]);  
34          list($ok_market, $ok_production, $ok_purchasing, $ok_economics,          list($ok_market, $ok_production, $ok_purchasing, $ok_economics,
35                  $ok_risks, $ok_competition, $ok_potential, $ok_portfolio,                  $ok_risks, $ok_competition, $ok_potential, $ok_portfolio,
36                  $ok_sales, $ok_quality, $ok_dosage, $ok_evaluation,                  $ok_sales, $ok_quality, $ok_dosage, $ok_evaluation,
37                  $ok_comment) = $row[0];                  $ok_comment) = array(-1, -1, -1, -1, -1, -1, -1, -1, -1,
38                    -1, -1, -1, -1);
39            if (is_array($row[0])) {
40                    bool_fix($row[0]);
41                    list($ok_market, $ok_production, $ok_purchasing,
42                            $ok_economics, $ok_risks, $ok_competition,
43                            $ok_potential, $ok_portfolio, $ok_sales, $ok_quality,
44                            $ok_dosage, $ok_evaluation, $ok_comment) = $row[0];
45            }
46          if ($save) {          if ($save) {
47                  $error = "";                  $error = "";
48                  $q = array();                  $q = array();
# Line 128  Line 139 
139          }          }
140          $row = DBQuery("SELECT naziv FROM products WHERE (product_id=$id)");          $row = DBQuery("SELECT naziv FROM products WHERE (product_id=$id)");
141          list($product_name) = $row[0];          list($product_name) = $row[0];
         DBClose();  
142  ?>  ?>
143  <HTML>  <HTML>
144  <HEAD>  <HEAD>
145  <META HTTP-EQUIV="Pragma" CONTENT="no-cache">  <META HTTP-EQUIV="Pragma" CONTENT="no-cache">
146  <META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">  <META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
147  <LINK REL="StyleSheet" HREF="style.css">  <?php
148            $ns_ua = "Mozilla/4.";
149            $old_netscape = (substr($HTTP_USER_AGENT, 0, strlen($ns_ua)) == $ns_ua) ?
150                    true : false;
151            if ($old_netscape) $old_netscape = strstr($HTTP_USER_AGENT, "MSIE") ? false : true;
152            if ($old_netscape) echo "<LINK REL=\"StyleSheet\" HREF=\"style-ns.css\">\n";
153                    else echo "<LINK REL=\"StyleSheet\" HREF=\"style.css\">\n";
154    ?>
155  <TITLE><?= $product_name ?></TITLE>  <TITLE><?= $product_name ?></TITLE>
156  <?php if ($msg): ?>  <?php if ($msg): ?>
157  <META HTTP-EQUIV="Refresh" CONTENT="1; URL=?id=<?= $id ?>">  <META HTTP-EQUIV="Refresh" CONTENT="1; URL=?id=<?= $id ?>">
# Line 154  Line 171 
171  </TD></TR></TABLE>  </TD></TR></TABLE>
172  </TD></TR></TABLE>  </TD></TR></TABLE>
173  <?php else: ?>  <?php else: ?>
 <FORM ENCTYPE="multipart/form-data" METHOD="post" ACTION="<?= $PHP_SELF ?>">  
174  <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="2" WIDTH="100%" HEIGHT="100%">  <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="2" WIDTH="100%" HEIGHT="100%">
175  <TR>  <TR>
176  <TD ALIGN="left" VALIGN="top" ROWSPAN="2" WIDTH="33%" HEIGHT="1%"><TABLE BORDER="0" CELLSPACING="0"><TR><TD CLASS="title1"><B>FINE CHEMICALS</B></TD></TR></TABLE></TD>  <TD ALIGN="left" VALIGN="top" WIDTH="33%" HEIGHT="1%"><TABLE BORDER="0" CELLSPACING="0"><TR><TD CLASS="title1"><B>FINE CHEMICALS</B></TD></TR></TABLE></TD>
177  <TD ALIGN="center" VALIGN="top" ROWSPAN="2" WIDTH="33%" HEIGHT="1%"><TABLE BORDER="0" CELLSPACING="0"><TR><TD CLASS="title2"><B><?= $product_name ?></B></TD></TR></TABLE></TD>  <TD ALIGN="center" VALIGN="top" ROWSPAN="2" WIDTH="33%" HEIGHT="1%"><TABLE BORDER="0" CELLSPACING="0"><TR><TD CLASS="title2"><B><?= $product_name ?></B></TD></TR></TABLE></TD>
178  <TD ALIGN="right" VALIGN="top" WIDTH="33%" HEIGHT="1%"><TABLE BORDER="0" CELLSPACING="0"><TR><TD CLASS="title3"><B>PRODUCT MATRIX</B></TD></TR></TABLE></TD>  <TD ALIGN="right" VALIGN="top" WIDTH="33%" HEIGHT="1%" COLSPAN="2"><TABLE BORDER="0" CELLSPACING="0"><TR><TD CLASS="title3"><B>PRODUCT MATRIX</B></TD></TR></TABLE></TD>
179  </TR>  </TR>
180  <TR><TD ALIGN="right" VALIGN="middle" HEIGHT="1%"><B>Date of last change:</B> <?php $tmp = getlastmod(); echo date("F d, Y.", $tmp)." at ".date("H:i:s", $tmp); ?></TD></TR>  <FORM ENCTYPE="multipart/form-data" METHOD="post" ACTION="<?= $PHP_SELF ?>">
181  <TR><TD COLSPAN="3" ALIGN="center" HEIGHT="1%"><HR WIDTH="100%" SIZE="2"></TD></TR>  <TR><TD ALIGN="left" VALIGN="bottom"><HR WIDTH="100%" SIZE="1" NOSHADE><INPUT TYPE="submit" NAME="change" VALUE="Change" CLASS="button"> product to <SELECT NAME="id" ONCHANGE="document.forms[0].submit();"><?php
182            $row = DBQuery("SELECT product_id,naziv FROM products ORDER BY naziv");
183            while (list($key, $val) = each($row)) {
184                    list($_id, $name) = $val;
185                    $selected = ($id == $_id) ? " SELECTED" : "";
186                    echo "<OPTION VALUE=\"$_id\"$selected>$name</OPTION>\n";
187            }
188    ?></SELECT></TD><TD ALIGN="right" VALIGN="bottom" HEIGHT="1%" COLSPAN="2"><B>Date of last change:</B> <?php $tmp = getlastmod(); echo date("F d, Y.", $tmp)." at ".date("H:i:s", $tmp); ?></TD></TR>
189    </FORM>
190    <TR><TD COLSPAN="4" ALIGN="center" HEIGHT="1%"><HR WIDTH="100%" SIZE="2"></TD></TR>
191    <FORM ENCTYPE="multipart/form-data" METHOD="post" ACTION="<?= $PHP_SELF ?>">
192  <TR>  <TR>
193    
194  <TD WIDTH="33%" ALIGN="center" VALIGN="top">  <TD WIDTH="33%" ALIGN="center" VALIGN="top">
# Line 192  Line 218 
218  </TABLE>  </TABLE>
219  </TD>  </TD>
220    
221  <TD WIDTH="33%" ALIGN="center" VALIGN="top">  <TD WIDTH="33%" ALIGN="center" VALIGN="top" COLSPAN="2">
222  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">
223  <TR><TD CLASS="cell3" ALIGN="center" VALIGN="middle" HEIGHT="1%"><B>Quality and Regulations</B></TD></TR>  <TR><TD CLASS="cell3" ALIGN="center" VALIGN="middle" HEIGHT="1%"><B>Quality and Regulations</B></TD></TR>
224  <TR><?php if ($ok_quality >= 0): ?><TD CLASS="cell1" ALIGN="left" VALIGN="top">  <TR><?php if ($ok_quality >= 0): ?><TD CLASS="cell1" ALIGN="left" VALIGN="top">
# Line 235  Line 261 
261  </TABLE>  </TABLE>
262  </TD>  </TD>
263    
264  <TD WIDTH="33%" ALIGN="center" VALIGN="top">  <TD WIDTH="33%" ALIGN="center" VALIGN="top" COLSPAN="2">
265  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">
266  <TR><TD CLASS="cell3" ALIGN="center" VALIGN="middle" HEIGHT="1%"><B>Dosage Form Market</B></TD></TR>  <TR><TD CLASS="cell3" ALIGN="center" VALIGN="middle" HEIGHT="1%"><B>Dosage Form Market</B></TD></TR>
267  <TR><?php if ($ok_dosage >= 0): ?><TD CLASS="cell1" ALIGN="left" VALIGN="top">  <TR><?php if ($ok_dosage >= 0): ?><TD CLASS="cell1" ALIGN="left" VALIGN="top">
# Line 271  Line 297 
297  </TABLE>  </TABLE>
298  </TD>  </TD>
299    
300  <TD WIDTH="33%" ROWSPAN="2" ALIGN="center" VALIGN="top">  <TD WIDTH="33%" ROWSPAN="2" ALIGN="center" VALIGN="top" COLSPAN="2">
301  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">
302  <TR><TD CLASS="cell3" ALIGN="center" VALIGN="middle" HEIGHT="1%"><SPAN CLASS="red"><B>Product Evaluation</B></SPAN></TD></TR>  <TR><TD CLASS="cell3" ALIGN="center" VALIGN="middle" HEIGHT="1%"><SPAN CLASS="red"><B>Product Evaluation</B></SPAN></TD></TR>
303  <TR><?php if ($ok_evaluation >= 0): ?><TD CLASS="cell2" ALIGN="left" VALIGN="top">  <TR><?php if ($ok_evaluation >= 0): ?><TD CLASS="cell2" ALIGN="left" VALIGN="top">
# Line 290  Line 316 
316  <TD WIDTH="33%" ROWSPAN="3" ALIGN="center" VALIGN="top">  <TD WIDTH="33%" ROWSPAN="3" ALIGN="center" VALIGN="top">
317  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">
318  <TR><TD CLASS="cell3" ALIGN="center" VALIGN="middle" HEIGHT="1%"><B>Sales: realisation&amp;plan / Price trend</B></SPAN></TD></TR>  <TR><TD CLASS="cell3" ALIGN="center" VALIGN="middle" HEIGHT="1%"><B>Sales: realisation&amp;plan / Price trend</B></SPAN></TD></TR>
319  <TR><TD CLASS="cell1" ALIGN="center" VALIGN="middle" HEIGHT="100%"><?php if ($ok_sales >= 0): ?><?php if ($edit && $ok_sales > 0): ?><B>Please choose an image to display here.</B><BR><BR><INPUT TYPE="file" CLASS="file" NAME="sales_img" VALUE="<?= $info_sales ?>"><BR><SMALL><I><B>NOTE:</B> The previously specified image will be used if no image is specified.</I></SMALL><?php elseif ($sales_img): ?><IMG SRC="img/<?= $sales_img ?>" BORDER="0"><?php else: ?>&nbsp;<?php endif; ?><?php else: ?><?= $msg_no_data ?><?php endif; ?></TD></TR>  <TR><TD CLASS="cell1" ALIGN="center" VALIGN="middle" HEIGHT="100%"><?php if ($ok_sales >= 0): ?><?php if ($edit && $ok_sales > 0): ?><B>Please choose an image to display here.</B><BR><BR><INPUT TYPE="file" CLASS="file" NAME="sales_img" VALUE="<?= $info_sales ?>"><BR><SMALL><I><B>NOTE:</B> The previously specified image will be used if no image is specified.</I></SMALL><?php elseif ($sales_img): ?><IMG SRC="img/<?= $sales_img ?>" BORDER="0" ALT=""><?php else: ?>&nbsp;<?php endif; ?><?php else: ?><?= $msg_no_data ?><?php endif; ?></TD></TR>
320  </TABLE>  </TABLE>
321  </TD>  </TD>
322    
# Line 312  Line 338 
338  </TABLE>  </TABLE>
339  </TD>  </TD>
340    
341  <TD WIDTH="33%" ROWSPAN="2" ALIGN="center" VALIGN="top">  <TD WIDTH="33%" ROWSPAN="2" ALIGN="center" VALIGN="top" COLSPAN="2">
342  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">
343  <TR><TD CLASS="cell2" ALIGN="left" VALIGN="top"><B>Comments</B><BR><?php if ($ok_comment >= 0): ?><?php if ($edit && $ok_comment > 0): ?><TEXTAREA NAME="comment" WRAP="virtual" CLASS="ta2"><?= $comment ?></TEXTAREA><?php else: ?><BLOCKQUOTE><?php  <TR><TD CLASS="cell2" ALIGN="left" VALIGN="top"><B>Comments</B><BR><?php if ($ok_comment >= 0): ?><?php if ($edit && $ok_comment > 0): ?><TEXTAREA NAME="comment" WRAP="virtual" CLASS="ta2"><?= $comment ?></TEXTAREA><?php else: ?><BLOCKQUOTE><?php
344          $out = str_replace("&", "&amp;", $comment);          $out = str_replace("&", "&amp;", $comment);
# Line 321  Line 347 
347          $out = str_replace(">", "&gt;", $out);          $out = str_replace(">", "&gt;", $out);
348          $out = ereg_replace("\r?\n", "<BR>", $out);          $out = ereg_replace("\r?\n", "<BR>", $out);
349          echo $out;          echo $out;
350  ?></BLOCKQUOTE><?php endif; ?><?php else: ?><BR><BR><BR><BR><P CLASS="center"><?= $msg_no_data ?></P><?php endif; ?></TD></TR>  ?></BLOCKQUOTE><?php endif; ?><?php else: ?><BR><BR><BR><P CLASS="center"><?= $msg_no_data ?></P><?php endif; ?></TD></TR>
351  </TABLE>  </TABLE>
352  </TD>  </TD>
353    
354  </TR>  </TR>
355  <TR>  <TR>
356    
357  <TD WIDTH="33%">  <TD WIDTH="33%" HEIGHT="1%">
358  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">
359  <TR><TD CLASS="cell3" ALIGN="center" VALIGN="middle" HEIGHT="1%"><B>Risks</B></TD></TR>  <TR><TD CLASS="cell3" ALIGN="center" VALIGN="middle" HEIGHT="1%"><B>Risks</B></TD></TR>
360  <TR><?php if ($ok_risks >= 0): ?><TD CLASS="cell1" ALIGN="left" VALIGN="middle">  <TR><?php if ($ok_risks >= 0): ?><TD CLASS="cell1" ALIGN="left" VALIGN="middle">
# Line 342  Line 368 
368    
369  </TR>  </TR>
370  <TR>  <TR>
371  <TD ALIGN="left" VALIGN="top"><?php if ($error): ?><FONT COLOR="#FF0000" SIZE="2"><B><?= $error ?></B><?php else: ?>&nbsp;<?php endif; ?></TD>  <TD ALIGN="left" VALIGN="top" COLSPAN="2"><?php if ($error): ?><FONT COLOR="#FF0000" SIZE="2"><B><?= $error ?></B><?php else: ?>&nbsp;<?php endif; ?></TD>
372  <TD COLSPAN="2" ALIGN="right"><?php if ($edit): ?><INPUT TYPE="submit" CLASS="button" VALUE="Cancel">&nbsp;<INPUT TYPE="submit" CLASS="button" NAME="save" VALUE="Save"><?php else: ?><INPUT TYPE="hidden" NAME="edit" VALUE="1"><INPUT TYPE="submit" CLASS="button" VALUE="Edit..."><?php endif; ?></TD>  <TD ALIGN="left" VALIGN="middle"><SMALL CLASS="info">&nbsp;&nbsp;Logged in as <B><?= $PHP_AUTH_USER ?></B>.&nbsp;&nbsp;[<A HREF="?relogin=<?= $PHP_AUTH_USER ?>" CLASS="logout">Logout</A>]</SMALL></TD>
373    <TD ALIGN="right"><?php if ($edit): ?><INPUT TYPE="submit" CLASS="button" VALUE="Cancel">&nbsp;<INPUT TYPE="submit" CLASS="button" NAME="save" VALUE="Save"><?php else: ?><INPUT TYPE="hidden" NAME="edit" VALUE="1"><INPUT TYPE="submit" CLASS="button" VALUE="Edit..."><?php endif; ?></TD>
374  </TR>  </TR>
375  </TABLE>  </TABLE>
376  </TD></TR>  </TD></TR>
 </TABLE>  
377  <INPUT TYPE="hidden" NAME="id" VALUE="<?= $id ?>"></FORM>  <INPUT TYPE="hidden" NAME="id" VALUE="<?= $id ?>"></FORM>
378    </TABLE>
379  <?php endif; ?>  <?php endif; ?>
380  </BODY>  </BODY>
381    <?php DBClose(); ?>
382  </HTML>  </HTML>

Legend:
Removed from v.1.2  
changed lines
  Added in v.1.6

  ViewVC Help
Powered by ViewVC 1.1.26