| $prod_name |  |  | | "; switch($ct) { case "1": //$text=" For "; #D0D0BB #E6E7C7 $table .=" | For Current Prices Subscribe Now! | Click here for Latest Posting! | Get the best deal out of ODD LOTS! | "; //$table .=" |
";
$table .="";
$table .="| $prod_name | | | | "; switch($ct) { case "1": //$text=" For "; #D0D0BB #E6E7C7 $table .=" | For Current Prices Subscribe Now! | Click here for Latest Posting! | Get the best deal out of ODD LOTS! | "; //$table .=" |
";
$table .="";
//$table .="";
//$table .="
";
//$table .="";
}
return($table.$tbl_rem);
}
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
function is_service_taken($login,$service)
{
global $DATABASE;
$date=substr(mktime_to_mysqltime(time()),0,8);
$query="Select * from serviceaccess where login='$login' and expdate>$date and status='Paid' and serviceid='$service'";
$result=mysql_db_query($DATABASE,$query);
if(mysql_error()) error("Unexpected Error".mysql_error());
return (mysql_num_rows($result));
}
function get_product_name($id)
{
global $DATABASE;
//print "SELECT name FROM ynfx_mis_product where id='$id'| $std_text_font $prod_name | $std_text_font $prod_name |
";
$t.="$std_text_font $companyname ";
$t.="";
}else if($memberplan=="PS")
{
//means the person online is pref show him
$t.="";
$t.="";
$t.="
$std_text_font $companyname";
$t.="";
}else if($memberplan == "Free")
{
$t.="";
$t.="";
$t.="$std_text_font $companyname";
$t.="";
}
else
{
$t.="";
$t.="$std_text_font $companyname";
$t.="";
}
}
$t.=" $std_text_font see all ";
return($t);
}//end of function
function new_get_user_pref($login)
{
global $DATABASE;
$query= "SELECT mis_setting, mis_value FROM ynfx_mis_user_pref WHERE mis_login='".$login."'";
$result=mysql_db_query($DATABASE,$query);
if(mysql_error()) error("Unexpected Error".mysql_error());
$user_pref[]="";
while ($row=mysql_fetch_row($result))
{
$setting=$row[0];
$value=$row[1];
$user_pref[$setting] =$value;
}
return $user_pref;
}
function new_get_admin_pref($login)
{
global $DATABASE;
$query= "SELECT mis_setting, mis_value FROM ynfx_mis_admin_pref WHERE mis_login='".$login."'";
$result=mysql_db_query($DATABASE,$query);
if(mysql_error()) error("Unexpected Error".mysql_error());
while ($row=mysql_fetch_row($result))
{
$setting=$row[0];
$value=$row[1];
$admin_pref[$setting]=$value;
}
return $admin_pref;
}
function get_classification_name($id)
{
global $DATABASE;
global $tbl_mis_classification;
$result=mysql_db_query($DATABASE,"SELECT name FROM ynfx_mis_classification where id='$id'");
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($result)) return mysql_result($result, 0, "name");echo mysql_error();
}
function get_country_name($id)
{
global $DATABASE;
global $tbl_mis_country;
$result=mysql_db_query($DATABASE,"SELECT name FROM ynfx_mis_country where id='$id'");
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($result)) return mysql_result($result, 0, "name");
}
function get_prev_price($pid,$sid,$country)
{
global $DATABASE;
$condition=($sid?" AND subprodid='$sid' ":" AND subprodid='0'");
$sql="SELECT price FROM ynfx_mis_pricewatchglobal WHERE approve='Y' AND visibility='Y' AND country='$country' AND productid='$pid' $condition ORDER BY recorddate DESC LIMIT 2";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($result)>1) return mysql_result($result,1,"price");
else return 0;
}
function get_measure_name($uid)
{
GLOBAL $DATABASE,$tbl_mis_units;
$result1=@mysql_db_query($DATABASE,"SELECT name FROM ynfx_mis_units WHERE id='$uid'");
if(mysql_num_rows($result1))
{
$name=stripslashes(mysql_result($result1,0,0));
if(mysql_error()) error("Unexpected Error".mysql_error());
}//end of if
return($name);
}//end of function
function get_pricewatch_table($login)
{
global $view_font1, $DATABASE, $tbl_mis_product, $tbl_mis_subproduct, $tbl_mis_pricewatchglobal, $std_maroon_font, $std_title_font, $MSG_185, $MSG_103, $MSG_022, $MSG_102, $MSG_100, $std_text_font, $tbl_admin_pref, $tbl_user_pref, $print, $HTTP_HOST;
global $pref_TEXTCOLOR,$pref_BANDCOLOR;
$std_newsheader_font = "";
$std_text_font="";
$pref_usr_arr=new_get_user_pref($login);
$pref_admin_arr=new_get_admin_pref($login);
$sql="Select * from ynfx_mis_admin_pref where mis_Setting like 'pw_%'";
$result=mysql_db_query($DATABASE,$sql); if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($result))
{
if ($pref_usr_arr["pw_pref_SOURCE"])
{
$pw_pref_SOURCE=unserialize($pref_usr_arr["pw_pref_SOURCE"]);
}
else
{
$pw_pref_SOURCE=unserialize($pref_admin_arr["pw_pref_SOURCE"]);
}
if ($pref_usr_arr["pw_pref_SUBPRODUCT"])
{
$pw_pref_SUBPRODUCT=unserialize($pref_usr_arr["pw_pref_SUBPRODUCT"]);
}
else $pw_pref_SUBPRODUCT=unserialize($pref_admin_arr["pw_pref_SUBPRODUCT"]);
if ($pref_usr_arr["pw_pref_CATEGORY"])
{
$pw_pref_CATEGORY=unserialize($pref_usr_arr["pw_pref_CATEGORY"]);
}
else $pw_pref_CATEGORY=unserialize($pref_admin_arr["pw_pref_CATEGORY"]);
if ($pref_usr_arr["pw_pref_PRODUCT"])
{
$pw_pref_PRODUCT=unserialize($pref_usr_arr["pw_pref_PRODUCT"]);
}
else $pw_pref_PRODUCT=unserialize($pref_admin_arr["pw_pref_PRODUCT"]);
if($pref_usr_arr["pw_pref_COUNTRY"])
{
$pw_pref_COUNTRY=unserialize($pref_usr_arr["pw_pref_COUNTRY"]);
}
else $pw_pref_COUNTRY=unserialize($pref_admin_arr["pw_pref_COUNTRY"]);
if($pref_usr_arr["pw_pref_COMPANY"])
{
$pw_pref_COMPANY=unserialize($pref_usr_arr["pw_pref_COMPANY"]);
}
else $pw_pref_COMPANY=unserialize($pref_admin_arr["pw_pref_COMPANY"]);
if(is_array($pw_pref_SUBPRODUCT)) $subproduct= "(\"".@join( $pw_pref_SUBPRODUCT , "\",\"" )."\")";
if(is_array($pw_pref_PRODUCT)) $product= "(\"".@join( $pw_pref_PRODUCT , "\",\"" )."\")";
$country = "(\"".@join( $pw_pref_COUNTRY , "\",\"" )."\")";
$source= "(\"".@join( $pw_pref_SOURCE , "\",\"" )."\")";
if(($product)||($subproduct)) $cond_product.="(";
if($product) $cond_product.=" productid in ".$product;
if($subproduct)
{
if($product)
{
$cond_product.=" or ";
$cond_product.=" subprodid in ".$subproduct;
}
}
if(($product)||($subproduct)) $cond_product.=")";
$sql="Select max(recorddate) as date, productid, subprodid from ynfx_mis_pricewatchglobal where approve='Y' and visibility='Y' and country in $country and $cond_product group by productid, subprodid order by classification, date desc";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($result))
{
$k="0";
$table = "";
while($row=mysql_fetch_row($result))
{
$show1=0;
$dateval=substr($row[0],0,8);
$date=date("d - M Y",mysqltime_to_mktime($row[0]));
//$country=stripslashes($row[1]);
$pid1=stripslashes($row[1]);
$sqlprice="Select id, recorddate, country, price, comments, outlook, graphimage, country, company, source, dateupdate, productid, subprodid, unit, region, classification, terms from ynfx_mis_pricewatchglobal where approve='Y' and visibility='Y' and productid=$pid1 and subprodid='$row[2]' and SUBSTRING(recorddate,1,8)='$dateval' group by productid, subprodid order by recorddate desc ";
$resultp=mysql_db_query($DATABASE,$sqlprice);
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($resultp))
{
for($i=0;$i| Product | Price | Movement | Terms | Region | Graph |
| Product | Price | Movement | Terms | Region | Graph |
| $std_text_font $prod_name Dated : $date | $std_text_font $currency $price/$unit | $std_text_font $currency $price/$unit | $std_text_font $dev ![\"Trend\"](\"../mis/images/$img.gif\") | $std_text_font $terms | $std_text_font $region | $std_text_font $region | $std_text_fontGraph | $std_text_font |
| Product | Price | Movement | Terms | Region | Graph |
| $std_text_font $prod_name | $std_text_font $currency $price/$unit | $view_font1 $dev |
$std_text_font $terms | $std_text_font $region | Graph |
| $name |
| $high |
| $name | |
| $high | |
| $name | |
| $high | |
| $name |
| $high |
| $name |
| $high |
| $name |
| $high |
| $name |
| $high |
";
}
return $news;
}
//function to get latest 3 stats
function get_stats_nonlogged()
{
global $DATABASE;
$cdate=mktime();
$query="Select header,id from ynfx_mis_istats WHERE visibility='1' AND status ='a' AND company !='1' AND date_display_from < '$cdate' AND date_display_to >'$cdate' order by date desc limit 3" ;
$result=mysql_db_query($DATABASE,$query);
if(mysql_error()) error("Unexpected Error".mysql_error());
$bgcolor=="#ffffff";
if(mysql_num_rows($result))
{
while($row=mysql_fetch_row($result))
{
//if($bgcolor=="#F1F1F1") {$bgcolor="#FFFFFF"; }
//else {$bgcolor="#F1F1F1";}
$header=stripslashes($row[0]);
$id=stripslashes($row[1]);
$stats.="";
//$stats.="$header";
$stats.="$header";
$stats.="";
$stats.="";
$stats.="
";
//$stats.="view table";
$stats.="view table";
$stats.="";
$stats.="";
$stats.="";
$stats.="";
}//end of while
}//end of if
if($stats)
{
$stats.="";
}
return $stats;
}
//function to get the latest highlights
function get_highlights_nonlogged()
{
global $DATABASE, $colorbgrow;
///////getting the details of the highlights from the pricewatch table
$array=array();
$sql="select id from ynfx_mis_subproducts where name like '%Acrylonitrile%' and enable='1'";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($result))
{
$idacn=mysql_result($result,0,0);
$array[]=$idacn;
}
$sql="select id from ynfx_mis_subproducts where name like '%Monoethylene Glycol%' and enable='1'";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($result))
{
$idmg=mysql_result($result,0,0);
$array[]=$idmg;
}
$sql="select id from ynfx_mis_subproducts where name like '%Purified Terephthalic Acid%' and enable='1'";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($result))
{
$idpta=mysql_result($result,0,0);
$array[]=$idpta;
}
$highlights="";
$highlights.="";
$highlights.="";
for($i=0;$i| $name: |
| $high |
| $name: |
| $high |
";
$highlights.="";
$highlights.="";
$highlights.="";
$highlights.="";
$highlights.="";
$highlights.="";
$highlights.="";
$highlights.="";
$highlights.="";
$highlights.="| $name: |
$high |
";
$highlights.="";
}
}
$highlights.="";
$highlights.="";
$highlights.="";
$highlights.="";
$highlights.="";
$highlights.="";
return $highlights;
}
//function to get the latest highlights
/*
function get_highlights_nonlogged()
{
global $DATABASE,$colorbgrow;
///////getting the details of the highlights from the pricewatch table
$array=array();
$sql="select id from ynfx_mis_subproducts where name like '%Acrylonitrile%' and enable='1'";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($result)){
$idacn=mysql_result($result,0,0);
$array[]=$idacn;
}
$sql="select id from ynfx_mis_subproducts where name like '%Monoethylene Glycol%' and enable='1'";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($result)){
$idmg=mysql_result($result,0,0);
$array[]=$idmg;
}
$sql="select id from ynfx_mis_subproducts where name like '%Purified Terephthalic Acid%' and enable='1'";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($result)){
$idpta=mysql_result($result,0,0);
$array[]=$idpta;
}
for($i=0;$i| $name: |
| $high |
| $name |
| $high |
| $name | |
$high | |
| $name | |
$high | |