<?
	session_start(); 
	require_once("eagritrader/login/authenticate.php");
	$cid1=$cid;
	
	if($cid == 0 or $cid == ""){
		$cid = 1;
		$cid1=0;
	}

	/*if(($varid == 0 || $varid == "") && $varietyid1 <> "")
	{
		$varid = $varietyid1;
	}*/
	
	if($varid == "")
		$varid = 0;

	require_once("phplib/db_mysql_eagri.php");
	require("phplib/template.php");
	$t= new Template();
	$t->set_file("file","quotes_top.html");
	$q=new DB_Sql();

	$commname = "Home";

	if($cid <> 0 and $cid <> "")
	{
		$sql = "select commodityname from CommodityMaster where commodityid = " . $cid;
		$q->query($sql);
		$q->next_record();
		$commname = $q->f("commodityname");
	}

	if($varid <> 0 and $varid <> "")
	{
		$sql = "select varietyname from VarietyMaster where varietyid = " . $varid;
		$q->query($sql);
		$q->next_record();
		$varname = " > " . $q->f("varietyname");
	}
	


	$t->set_var(array("COMID"=>$cid,"GETQUOTES"=>$getquotes,"MKTTYPE"=>$mkttype, "CID"=>$cid, "VARID"=>$varid, "COMMNAME"=>$commname, "VARNAME"=>$varname));

	if ($mkttype == "D")
	{
		$display_text = "Daily Quotes - Domestic";
		$itemtype = "PQL";
		$pages="QD";
	}
	else
	{
		$display_text = "Daily Quotes - International";
		$itemtype = "PQI";
		$pages="QI";
	}

	if($varid == "" or $varid == 0)
		$data_sql = "select OptionMaster.varietyid from OptionMaster where CommodityId = $cid";
	else
		$data_sql = "select optionid, OptionMaster.varietyid from OptionMaster where OptionMaster.varietyid = $varid and ItemType = '$itemtype'";

	//echo $data_sql;
	$optvarid = "";
	$q->query($data_sql);
	$i=0;
	while($q->next_record())
	{
		$optionid=$q->f("optionid");
		$variety_id=$q->f("varietyid");
		if($i == 0)
			$optvarid = $optvarid . $variety_id;
		else
			$optvarid = $optvarid . "," . $variety_id;

		$i++;
	}
	$t->set_var(array("OPTVARID"=>$optvarid));

	$variety_sql = "Select Distinct variety_id, variety_name from eAgri_Variety, eagri_market_associate, eagri_sub_variety Where pack_varietyid in(" . $optvarid . ") and Variety_Status = 'A' and eagri_market_associate.associate_commodity_id = eAgri_Variety.Pack_VarietyID and  eagri_market_associate.associate_variety_sub_id = eagri_sub_variety.variety_sub_id and eagri_sub_variety.variety_relation = eAgri_Variety.Variety_Id and eagri_market_associate.online='Y' order by variety_name";
	
	$q->query($variety_sql);
	$t->set_block("file", "variety_block", "variety_blk");
	while($q->next_record())
	{
		$variety_id=$q->f("variety_id");
		if($varietyid1 == $variety_id)
		{
			$selected_val="selected";
			$svariety_name=$q->f("variety_name");
		}
		else
			$selected_val="";

		$variety_name=$q->f("variety_name");
		$t->set_var(array("VARIETY_ID"=>$variety_id, "VARIETY_NAME"=>$variety_name, "SELECTED_VAL"=>$selected_val));
		$t->parse("variety_blk", "variety_block", "true");
	}

	if($varietyid1 <> "")
	{
		$subvariety_sql="SELECT DISTINCT eagri_sub_variety.variety_sub_id as variety_id, eagri_sub_variety.variety_sub_name as variety_name FROM eagri_sub_variety, eagri_market_associate WHERE (eagri_sub_variety.variety_relation) = " . $varietyid1." and eagri_market_associate.associate_variety_sub_id = eagri_sub_variety.variety_sub_id and eagri_market_associate.online='Y'";

		$q->query($subvariety_sql);
		$t->set_block("file", "subvariety_block", "subvariety_blk");
		while($q->next_record())
		{
			$subvariety_id=$q->f("variety_id");
			if($subvarietyid == $subvariety_id)
			{
				$selected_val="selected";
				$ssubvariety_name=$q->f("variety_name");
			}
			else
				$selected_val="";

			$subvariety_name=$q->f("variety_name");
			$t->set_var(array("SUBVARIETY_START"=>"","SUBVARIETY_END"=>"","SUBVARIETY_ID"=>$subvariety_id, "SUBVARIETY_NAME"=>$subvariety_name, "SUBSELECTED_VAL"=>$selected_val));
			$t->parse("subvariety_blk", "subvariety_block", "true");
		}
	}
	else
	{
		$t->set_block("file", "subvariety_block", "subvariety_blk");
		$t->set_var(array("SUBVARIETY_START"=>"<!--","SUBVARIETY_END"=>"-->","SUBVARIETY_ID"=>"", "SUBVARIETY_NAME"=>"", "SUBSELECTED_VAL"=>""));
		$t->parse("subvariety_blk", "subvariety_block", "true");
	}

	if ($mkttype == "D")
		$market_condn = " and MArket_Type = 'D'";
	else
		$market_condn = " and MArket_Type = 'I'";
	
	$market_sql="Select Distinct MarketID mid,Market_Name mname from DailyQuotes join Eagri_Market on Eagri_Market.Market_Id = DailyQuotes.MarketID Join eagri_market_associate on eagri_market_associate.Associate_Market_Id = Eagri_Market.Market_ID left Join CurrencyMaster on DailyQuotes.CurrenCyId = CurrencyMaster.CurrencyID left Join UnitMaster on DailyQuotes.UnitId = UnitMaster.UnitID join eagri_sub_variety on eagri_sub_variety.Variety_Sub_Id = DailyQuotes.SubvarietyId join eAgri_Variety on eAgri_Variety.Variety_Id = eagri_sub_variety.variety_relation where substring(DailyQuotes.LastTraded,1,10)>=DATE_SUB(CURDATE(), INTERVAL 2 DAY) and eAgri_Variety.Variety_Id='".$varietyid1."' and Pack_VarietyId in (". $optvarid .") and eagri_market_associate.online = 'Y' and Market_status = 'A' ".$market_condn." order by Market_Name";

	//$market_sql="select Distinct market_id mid, market_name mname from Eagri_Market, eAgri_Variety, eagri_sub_variety, eagri_market_associate where eagri_market_associate.associate_market_id = Eagri_Market.Market_Id and eagri_sub_variety.Variety_sub_id = eagri_market_associate.Associate_Variety_sub_id and eAgri_Variety.Variety_Id = eagri_sub_variety.Variety_relation and Pack_VarietyId in (". $optvarid .") and eagri_market_associate.online = 'Y' and Market_status = 'A' ".$market_condn." order by Market_Name";//

	$q->query($market_sql);
	$t->set_block("file", "market_block", "market_blk");
	while($q->next_record())
	{
		$market_id=$q->f("mid");
		if($MarketId == $market_id)
		{
			$selected_val="selected";
			$smarket_name=$q->f("mname");
		}
		else
			$selected_val="";

		$market_name=$q->f("mname");
		$t->set_var(array("MARKET_ID"=>$market_id, "MARKET_NAME"=>$market_name, "MKTSELECTED_VAL"=>$selected_val));
		$t->parse("market_blk", "market_block", "true");
	}

	if($getquotes == 1)
		$daily_quotes = join("",file("http://127.0.0.1/eagritrader/common/daily_quotes.php?Opt=Var&MktType=$mkttype&VarietyId=$varietyid1&International=1&SubVarietyId=$subvarietyid&Variety_Name=" . str_replace(" ","%20",$svariety_name). "&Variety_Sub_Name=" . str_replace(" ","%20",$ssubvariety_name)));
	elseif($getquotes == 2)
		$daily_quotes = join("",file("http://127.0.0.1/eagritrader/common/daily_quotes.php?Opt=&MarketId=$MarketId&Market_Name=" . str_replace(" ","%20",$smarket_name) . "&OptVarID=$optvarid&MktType=$mkttype&VarietyId=$varietyid1&International=1&SubVarietyId=$subvarietyid&Variety_Name=" . str_replace(" ","%20",$svariety_name). "&Variety_Sub_Name=" . str_replace(" ","%20",$ssubvariety_name)));

	$referer=$PHP_SELF;

	$common_lhs=join(" ", file("http://127.0.0.1/eagritrader/home_exchange_menu.php?cid=$cid"));
	$common_top=join(" ", file("http://127.0.0.1/eagritrader/home_menu.php?ref=$referer&cid=$cid&err=$err&login=$login&subs_opt=$subs_opt&userid=$userid"));
	
	$common_footer=join(" ", file('http://127.0.0.1/eagritrader/common/footer.php?pages='.$pages.'&cid='.$cid1.'&varid='.$varid));
	$more_resources=join(" ", file("http://127.0.0.1/eagritrader/common/more_resources.php?cid=$cid"));
	$type="quote";
	$cmemail1=$_COOKIE["commoditiesemail"];
	
	$cmuser=$_COOKIE["commoditiesname"];

	$comment=join(" ", file("http://127.0.0.1/eagritrader/common/user_comment.php?cmemail=$cmemail&cmuser=$cmuser&userid=$userid&type=" . $type ."&itemid=" . $itemid . "&comid=" . $cid . "&varid=" . $varid . "&log=Y&com=$com"));

	$topcomments=join(" ", file("http://127.0.0.1/eagritrader/common/top5comments.php?cid=".$cid."&itemid=".$itemid."&type=".$type));

	$t->set_var(array("DAILY_QUOTES"=>$daily_quotes, "COMMON_TOP"=>$common_top, "LOGIN_PATCH"=>$login_patch, "COMMON_LHS"=>$common_lhs, "COMMON_FOOTER"=>$common_footer, "CID"=>$cid, "VARID"=>$varid, "CENTER_GIF"=>$center_gif, "LOGINID"=>$loginid, "USERID"=>$userid, "MORE_RESOURCES"=>$more_resources,"COMMENT"=>$comment,"TOPCOMMENTS"=>$topcomments));

	$t->pparse("OUT","file");

	include "ht_count.php";
	$key = array_search($_SERVER['REMOTE_ADDR'], $arr_iplist); 
	if($key=="")
	{
		include "http://gateway.commoditiescontrol.com/eagriAdmin1/eagritrader_english_page_count.php?pages=$pages&cid=".$cid."&varid=".$varid;
	}

	/************************** Hits Tracking Page ************************************/
	if ($mkttype == "D")
	{
		$type='QD';
	}
	else
	{
		$type='QI';
	}

	include "http://www.commoditiescontrol.com/eagriAdmin1/page_track.php?type=".$type."&cid=".$cid."&varid=".$varid;
	/************************** Hits Tracking Page ************************************/
?>