--- index.php 2001/06/07 06:06:05 1.8 +++ index.php 2001/06/21 10:07:13 1.11 @@ -3,6 +3,7 @@ $auth = true; if ($auth && (!isset($PHP_AUTH_USER) || !isset($PHP_AUTH_PW))) $auth = false; + if ($change) { $id = $new_id; $edit = false; } if ($auth) { include("conn.php"); DBOpen(); @@ -61,7 +62,7 @@ } if ($save) { $error = ""; - $q = array(); + $q = array("cas_no='$cas_no'"); if ($error == "" && $ok_market > 0) { if (!CheckURL($info_market)) { $error = "Invalid URL."; $err = 1; } if ($error == "") array_push($q, "link_market='$info_market',cust_existing='$cust_existing',cust_potential='$cust_potential',fc_price='$fc_price'"); @@ -139,7 +140,7 @@ } if ($error == "") $msg = true; else $edit = 1; } else { - $row = DBQuery("SELECT link_market,link_production,link_purchasing,link_economics,link_risks,link_competition,link_potential,link_quality,link_dosage,link_sales,comment,cust_potential,cust_existing,fc_price,competitors,holders,market_size,quality,registrations,last_fda,cap_nominal,cap_util,ther_class,indication,sales_1999,launch_year,mat_raw,suppliers,mat_cost,fc_rank,fc_share,maturity,comp_intensity,comp_position,cogs,op_income,break_even,m3,sales_img,risks FROM products WHERE (product_id=$id)"); + $row = DBQuery("SELECT link_market,link_production,link_purchasing,link_economics,link_risks,link_competition,link_potential,link_quality,link_dosage,link_sales,comment,cust_potential,cust_existing,fc_price,competitors,holders,market_size,quality,registrations,last_fda,cap_nominal,cap_util,ther_class,indication,sales_1999,launch_year,mat_raw,suppliers,mat_cost,fc_rank,fc_share,maturity,comp_intensity,comp_position,cogs,op_income,break_even,m3,sales_img,risks,cas_no FROM products WHERE (product_id=$id)"); if (count($row) <= 0) { echo "No such product ID."; exit; } list($info_market, $info_production, $info_purchasing, $info_economics, $info_risks, $info_competition, @@ -151,7 +152,7 @@ $launch_year, $mat_raw, $suppliers, $mat_cost, $fc_rank, $fc_share, $maturity, $comp_intensity, $comp_position, $cogs, $op_income, $break_even, - $m3, $sales_img, $risks) = $row[0]; + $m3, $sales_img, $risks, $cas_no) = $row[0]; } $row = DBQuery("SELECT naziv FROM products WHERE (product_id=$id)"); list($product_name) = $row[0]; @@ -168,7 +169,7 @@ if ($old_netscape) echo "\n"; else echo "\n"; ?> -<?= ereg_replace("\r?\n(.*)$", " (\\1)", $product_name); ?> +<?= $product_name ?><?php if ($cas_no): ?> (CAS No: <?= $cas_no ?>)<?php endif; ?> @@ -187,29 +188,25 @@ +
- + - - - +?> - -
FINE CHEMICALS
\\1", $product_name); ?>

CAS No:
CAS No:
PRODUCT MATRIX
product to 		 
product to 		Date of last change:
Date of last change:
- +
BORDER="1"> = 0): ?>
Market Position of Fine Chemicals
    @@ -222,7 +219,7 @@
- +
BORDER="1"> = 0): ?>
Competition
    @@ -236,7 +233,7 @@
- +
BORDER="1"> = 0): ?>
Quality and Regulations
    @@ -253,7 +250,7 @@
- +
BORDER="1"> = 0): ?>
Production
    @@ -266,7 +263,7 @@
- +
BORDER="1"> = 0): ?>
Therapeutic Potential
    @@ -279,7 +276,7 @@
- +
BORDER="1"> = 0): ?>
Dosage Form Market
    @@ -295,7 +292,7 @@
- +
BORDER="1"> = 0): ?>
Purchasing
    @@ -309,13 +306,13 @@
- +
BORDER="1">
= 0): ?>Rank in FC portfolio: 0): ?>
Share in FC portfolio: 0): ?>
 - +
BORDER="1"> = 0): ?>
Product Evaluation
    @@ -331,7 +328,7 @@
- +
BORDER="1">
Sales: realisation&plan / Price trend
= 0): ?> 0): ?>Please choose an image to display here.


NOTE: The previously specified image will be used if no image is specified. 
@@ -341,7 +338,7 @@
- +
BORDER="1"> = 0): ?>
Product Economics
    @@ -356,7 +353,7 @@
- +
BORDER="1"> - +
Comments
= 0): ?> 0): ?>
 - +
BORDER="1"> = 0): ?> - +
Risks
    @@ -386,13 +383,14 @@
   Logged in as .  [Logout]   Logged in as .  [Logout]  
+