/[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.3 by dpavlin, Wed Jun 6 07:25:51 2001 UTC revision 1.8 by ravilov, Thu Jun 7 06:06:05 2001 UTC
# Line 11  Line 11 
11                  if (count($row) <= 0) $auth = false;                  if (count($row) <= 0) $auth = false;
12                  if ($auth) {                  if ($auth) {
13                          $row = $row[0];                          $row = $row[0];
14                          if ($PHP_AUTH_PW != $row[0]) $auth = false;                          if (substr($row[0], 0, 5) == "auth_") {
15                                    switch (strtoupper(substr($row[0], 5))) {
16                                            case "POP3":
17                                                    include("auth_POP3.php");
18                                                    $pop = new POP3();
19                                                    $pop->connect("intranet.pliva.hr");
20                                                    $ret = $pop->checklogin($PHP_AUTH_USER, $PHP_AUTH_PW);
21                                                    $pop->quit();
22                                                    if (!$ret) $auth = false;
23                                                    break;
24                                            default: $auth = false; break;
25                                    }
26                            } else {
27                                    $pw = md5($PHP_AUTH_USER.$PHP_AUTH_PW);
28                                    if ($pw != $row[0]) $auth = false;
29                            }
30                            # if ($PHP_AUTH_PW != $row[0]) $auth = false;
31                  }                  }
32          }          }
33          if (!$auth || $relogin == $PHP_AUTH_USER) {          if (!$auth || $relogin == $PHP_AUTH_USER) {
# Line 20  Line 36 
36                  echo "<HTML><B>No access.</B></HTML>\n";                  echo "<HTML><B>No access.</B></HTML>\n";
37                  exit;                  exit;
38          }          }
39  //      if (!$id) { echo "<HTML><B>No product ID!</B></HTML>\n"; exit; }          # if (!$id) { echo "<HTML><B>No product ID!</B></HTML>\n"; exit; }
40          if (!$id) { $id=1; }          DBOpen();
41            if (!$id) {
42                    $id = 1;
43                    $row = DBQuery("SELECT MIN(product_id) FROM products");
44                    if ($row[0]) $id = $row[0][0];
45            }
46          $error = "";          $error = "";
47          $msg = false;          $msg = false;
48          $err = 0;          $err = 0;
         DBOpen();  
49          $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]);  
50          list($ok_market, $ok_production, $ok_purchasing, $ok_economics,          list($ok_market, $ok_production, $ok_purchasing, $ok_economics,
51                  $ok_risks, $ok_competition, $ok_potential, $ok_portfolio,                  $ok_risks, $ok_competition, $ok_potential, $ok_portfolio,
52                  $ok_sales, $ok_quality, $ok_dosage, $ok_evaluation,                  $ok_sales, $ok_quality, $ok_dosage, $ok_evaluation,
53                  $ok_comment) = $row[0];                  $ok_comment) = array(-1, -1, -1, -1, -1, -1, -1, -1, -1,
54                    -1, -1, -1, -1);
55            if (is_array($row[0])) {
56                    bool_fix($row[0]);
57                    list($ok_market, $ok_production, $ok_purchasing,
58                            $ok_economics, $ok_risks, $ok_competition,
59                            $ok_potential, $ok_portfolio, $ok_sales, $ok_quality,
60                            $ok_dosage, $ok_evaluation, $ok_comment) = $row[0];
61            }
62          if ($save) {          if ($save) {
63                  $error = "";                  $error = "";
64                  $q = array();                  $q = array();
# Line 128  Line 155 
155          }          }
156          $row = DBQuery("SELECT naziv FROM products WHERE (product_id=$id)");          $row = DBQuery("SELECT naziv FROM products WHERE (product_id=$id)");
157          list($product_name) = $row[0];          list($product_name) = $row[0];
         DBClose();  
158  ?>  ?>
159  <HTML>  <HTML>
160  <HEAD>  <HEAD>
161  <META HTTP-EQUIV="Pragma" CONTENT="no-cache">  <META HTTP-EQUIV="Pragma" CONTENT="no-cache">
162  <META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">  <META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
163  <?php  <?php
164          $ns_ua="Mozilla/4.";          $ns_ua = "Mozilla/4.";
165          $old_netscape=false;          $old_netscape = (substr($HTTP_USER_AGENT, 0, strlen($ns_ua)) == $ns_ua) ?
166          if (substr($HTTP_USER_AGENT,0,strlen($ns_ua)) == $ns_ua) {                  true : false;
167                  $old_netscape=true;          if ($old_netscape) $old_netscape = strstr($HTTP_USER_AGENT, "MSIE") ? false : true;
168                  print '<LINK REL="StyleSheet" HREF="style-ns.css">';          if ($old_netscape) echo "<LINK REL=\"StyleSheet\" HREF=\"style-ns.css\">\n";
169          } else {                  else echo "<LINK REL=\"StyleSheet\" HREF=\"style.css\">\n";
                 print '<LINK REL="StyleSheet" HREF="style.css">';  
         }  
170  ?>  ?>
171  <TITLE><?= $product_name ?></TITLE>  <TITLE><?= ereg_replace("\r?\n(.*)$", " (\\1)", $product_name); ?></TITLE>
172  <?php if ($msg): ?>  <?php if ($msg): ?>
173  <META HTTP-EQUIV="Refresh" CONTENT="1; URL=?id=<?= $id ?>">  <META HTTP-EQUIV="Refresh" CONTENT="1; URL=?id=<?= $id ?>">
174  <?php else: ?>  <?php else: ?>
# Line 163  Line 187 
187  </TD></TR></TABLE>  </TD></TR></TABLE>
188  </TD></TR></TABLE>  </TD></TR></TABLE>
189  <?php else: ?>  <?php else: ?>
 <FORM ENCTYPE="multipart/form-data" METHOD="post" ACTION="<?= $PHP_SELF ?>">  
190  <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="2" WIDTH="100%" HEIGHT="100%">  <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="2" WIDTH="100%" HEIGHT="100%">
191  <TR>  <TR>
192  <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>
193  <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><?= ereg_replace("\r?\n(.*)$", "<BR><SMALL>\\1</SMALL>", $product_name); ?></B></TD></TR></TABLE></TD>
194  <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>
195  </TR>  </TR>
196  <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 ?>">
197  <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
198            $row = DBQuery("SELECT product_id,naziv FROM products ORDER BY naziv");
199            while (list($key, $val) = each($row)) {
200                    list($_id, $name) = $val;
201                    $name = ereg_replace("\r?\n.*$", "", $name);
202                    $selected = ($id == $_id) ? " SELECTED" : "";
203                    echo "<OPTION VALUE=\"$_id\"$selected>$name</OPTION>\n";
204            }
205    ?></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>
206    </FORM>
207    <TR><TD COLSPAN="4" ALIGN="center" HEIGHT="1%"><HR WIDTH="100%" SIZE="2"></TD></TR>
208    <FORM ENCTYPE="multipart/form-data" METHOD="post" ACTION="<?= $PHP_SELF ?>">
209  <TR>  <TR>
210    
211  <TD WIDTH="33%" ALIGN="center" VALIGN="top">  <TD WIDTH="33%" ALIGN="center" VALIGN="top">
# Line 194  Line 228 
228  <UL>  <UL>
229  <LI>relevant competitors: <?php if ($edit && $ok_competition > 0): ?><INPUT TYPE="text" CLASS="text" NAME="competitors" VALUE="<?= $competitors ?>"><?php else: ?><?= $competitors ?><?php endif; ?></LI>  <LI>relevant competitors: <?php if ($edit && $ok_competition > 0): ?><INPUT TYPE="text" CLASS="text" NAME="competitors" VALUE="<?= $competitors ?>"><?php else: ?><?= $competitors ?><?php endif; ?></LI>
230  <LI>holders of the US DMF: <?php if ($edit && $ok_competition > 0): ?><INPUT TYPE="text" CLASS="text" NAME="holders" VALUE="<?= $holders ?>"><?php else: ?><?= $holders ?><?php endif; ?></LI>  <LI>holders of the US DMF: <?php if ($edit && $ok_competition > 0): ?><INPUT TYPE="text" CLASS="text" NAME="holders" VALUE="<?= $holders ?>"><?php else: ?><?= $holders ?><?php endif; ?></LI>
231  <LI>API market size 1999: <?php if ($edit && $ok_competition > 0): ?><INPUT TYPE="text" CLASS="text" NAME="market_size" VALUE="<?= $market_size ?>"><?php else: ?><?= $market_size ?><?php endif; ?> t/US$</LI>  <LI>API market size 1999: <?php if ($edit && $ok_competition > 0): ?><INPUT TYPE="text" CLASS="text" NAME="market_size" VALUE="<?= $market_size ?>"><?php else: ?><?= $market_size ?><?php endif; ?></LI>
232  </UL>  </UL>
233  <P<?php if ($err == 2): ?> CLASS="error" <?php endif; ?>><?php if ($edit && $ok_competition > 0): ?>&quot;<B>more data</B>&quot; URL: <INPUT TYPE="text" CLASS="text" NAME="info_competition" VALUE="<?= $info_competition ?>"><?php elseif ($info_competition): ?><B><A HREF="<?= $info_competition ?>">more data</A></B><?php else: ?>&nbsp;<?php endif; ?></P>  <P<?php if ($err == 2): ?> CLASS="error" <?php endif; ?>><?php if ($edit && $ok_competition > 0): ?>&quot;<B>more data</B>&quot; URL: <INPUT TYPE="text" CLASS="text" NAME="info_competition" VALUE="<?= $info_competition ?>"><?php elseif ($info_competition): ?><B><A HREF="<?= $info_competition ?>">more data</A></B><?php else: ?>&nbsp;<?php endif; ?></P>
234  </TD><?php else: ?><TD CLASS="cell1" ALIGN="center" VALIGN="middle"><?= $msg_no_data ?></TD><?php endif; ?></TR>  </TD><?php else: ?><TD CLASS="cell1" ALIGN="center" VALIGN="middle"><?= $msg_no_data ?></TD><?php endif; ?></TR>
235  </TABLE>  </TABLE>
236  </TD>  </TD>
237    
238  <TD WIDTH="33%" ALIGN="center" VALIGN="top">  <TD WIDTH="33%" ALIGN="center" VALIGN="top" COLSPAN="2">
239  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">
240  <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>
241  <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 244  Line 278 
278  </TABLE>  </TABLE>
279  </TD>  </TD>
280    
281  <TD WIDTH="33%" ALIGN="center" VALIGN="top">  <TD WIDTH="33%" ALIGN="center" VALIGN="top" COLSPAN="2">
282  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">
283  <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>
284  <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 280  Line 314 
314  </TABLE>  </TABLE>
315  </TD>  </TD>
316    
317  <TD WIDTH="33%" ROWSPAN="2" ALIGN="center" VALIGN="top">  <TD WIDTH="33%" ROWSPAN="2" ALIGN="center" VALIGN="top" COLSPAN="2">
318  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">
319  <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>
320  <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 299  Line 333 
333  <TD WIDTH="33%" ROWSPAN="3" ALIGN="center" VALIGN="top">  <TD WIDTH="33%" ROWSPAN="3" ALIGN="center" VALIGN="top">
334  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">
335  <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>
336  <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>
337  </TABLE>  </TABLE>
338  </TD>  </TD>
339    
# Line 321  Line 355 
355  </TABLE>  </TABLE>
356  </TD>  </TD>
357    
358  <TD WIDTH="33%" ROWSPAN="2" ALIGN="center" VALIGN="top">  <TD WIDTH="33%" ROWSPAN="2" ALIGN="center" VALIGN="top" COLSPAN="2">
359  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">
360  <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
361          $out = str_replace("&", "&amp;", $comment);          $out = str_replace("&", "&amp;", $comment);
# Line 330  Line 364 
364          $out = str_replace(">", "&gt;", $out);          $out = str_replace(">", "&gt;", $out);
365          $out = ereg_replace("\r?\n", "<BR>", $out);          $out = ereg_replace("\r?\n", "<BR>", $out);
366          echo $out;          echo $out;
367  ?></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>
368  </TABLE>  </TABLE>
369  </TD>  </TD>
370    
371  </TR>  </TR>
372  <TR>  <TR>
373    
374  <TD WIDTH="33%">  <TD WIDTH="33%" HEIGHT="1%">
375  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">  <TABLE CLASS="table" CELLSPACING="0" CELLPADDING="1" WIDTH="100%" HEIGHT="100%">
376  <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>
377  <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 351  Line 385 
385    
386  </TR>  </TR>
387  <TR>  <TR>
388  <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>
389  <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>
390    <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>
391  </TR>  </TR>
392  </TABLE>  </TABLE>
393  </TD></TR>  </TD></TR>
 </TABLE>  
394  <INPUT TYPE="hidden" NAME="id" VALUE="<?= $id ?>"></FORM>  <INPUT TYPE="hidden" NAME="id" VALUE="<?= $id ?>"></FORM>
395    </TABLE>
396  <?php endif; ?>  <?php endif; ?>
397  </BODY>  </BODY>
398    <?php DBClose(); ?>
399  </HTML>  </HTML>
Legend:
Removed from v.1.3  
changed lines
  Added in v.1.8
  ViewVC Help
Powered by ViewVC 1.1.26