"; ##echo "
"; ##echo "&&&".$value["TariffOffers"]; $co=GetOfferDetails($offers,$value["TariffRental"],$value["TariffPhoneCost"],$value["TariffOffers"]); #print_r($co); #echo "
"; $co1=$co[1]; array_multisort($co1, SORT_DESC,SORT_STRING,$co1); ?> "; } echo "
"; $phone=$value["MakeName"]." ".$value["PhoneModel"]; $network=$value["NetworkName"]; echo "
".$phone." on ".$network." ".$value["TariffName"]."
"; ##." ".$value["TariffRental"]; echo "
"; echo ''; echo ""; #print_r(array_values($co)); $month=currency($co[0]/12); $phonecost=currency($value["TariffPhoneCost"],1); #if ($value["TariffPhoneCost"]==0) { #$phonecost="FREE"; #} echo ""; echo ""; $rental="N/A"; if (!$value["TariffPAYG"]){ $rental=currency($value["TariffRental"],1); } echo ""; echo ""; echo ""; echo "
"; if ($value["TariffAT"]>0){ echo ''.$value['; } if ($value["TariffPK"]>0){ echo ''.$value['; } if ($value["TariffOP"]>0){ echo ''.$value['; } if ($value["TariffTX"]>0){ echo ''.$value['; } foreach ($co1 as $value2){ if ($value2["icons"]){ echo ''.$value2['; } } echo ""; foreach ($co1 as $value2){ echo $value2["desc"]."
"; } echo "		Phone Cost
".$phonecost."		Cost in 1st Year
".currency($co[0],1)."
(".$month." pm)

 
Line Rental
".$rental."
"; echo "
"; #echo $offers[0]['code']; ##echo GetYear1Cost($offers,40,0,'HP/6-CB/50'); ##echo GetYear1Cost($offers,40,0,'LR/6/0-IN/3-FD-CB/50-FM-FG'); #echo GetYear1Cost($offers,40,0,'IN/3'); #$co= GetYear1Cost($offers,40,0,'LR/6/0-IN/3-FM-VI/5-VV/3/50/25-VC/25-FD-CB/50'); #array_multisort($co, SORT_DESC,SORT_STRING,$co); #print_r(array_values($co)); ##UpdateFirstYearCost($offers); ####################################################### function GetOfferDetails($offers,$LR,$phonecost,$code){ $offlist = array(); $yearLR=$LR*12; $OrigyearLR=$yearLR; $codes=split("-",$code); foreach ($codes as $value){ $codeparts=split('/',$value); foreach ($offers as $value2){ if($codeparts[0]==$value2['ShortCode']){ $code=$value2['OfferCode']; $text=$value2['OfferDesc']; $val=$value2['OfferEquation']; $order=$value2['OfferOrder']; $icons=$value2['OfferIcons']; $code1=split('/',$code); break; } } ##echo $text; $c=0; if ($codeparts[1]!=""){ foreach ($code1 as $value3){ #echo $value3; $ans=0; if ($c>0){ $v= '$'.$value3."=".$codeparts[$c].";"; $prefix=""; if ($value3=='X'){ if ($codeparts[$c]==0){ $codeparts[$c]="FREE"; }else{ $prefix='£'; } } $text=str_replace('{'.$value3.'}',$prefix.$codeparts[$c],$text); ####### maximum 1st yr cost limited to 12 months #### if ($M>12){ $M=12; } ###### ##echo "
*** ".$v." ***
"; eval ($v); } $c++; } if ($val!=""){ eval ('$ans='.$val.';'); ##echo "
".$val." M=".$M." X=".$X; ###echo "Saving: £".$ans." - "; $yearLR=$yearLR+$ans; } } #echo $text."
"; ##$offlist = array("desc" => $text, "cost" => $ans); if ($icons){ #echo "5=".$codeparts[2]; if (($icons=='LR.gif') AND ($codeparts[2]=='FREE')){ $icons="LR0.gif"; } $icons=str_replace('{Y}',$Y,$icons); ##echo ''; } array_push($offlist, array("order" => $order, "desc" => $text, "cost" => $ans, "icons" => $icons)); #array_push($offlist["desc"], $text); #array_push($offlist["cost"], $ans); } #echo "
*****************************
"; #echo "Balance: ".$yearLR; #echo "
Usual LR: ".$OrigyearLR; #echo "
"; #return $phonecost+$yearLR; return array($phonecost+$yearLR,$offlist); } function GetYear1Cost($offers,$LR,$phonecost,$code){ #$offlist["desc"]["cost"]=array(); #$offlist=array( # array ( # "desc", # "cost" # ) # ); $offlist = array(); $yearLR=$LR*12; $OrigyearLR=$yearLR; $codes=split("-",$code); foreach ($codes as $value){ $codeparts=split('/',$value); ##if ($codeparts[1]!=""){ ##echo " XX".$codeparts[1]."XX "; ###$codeparts=split('/',$code); ###$c=0; foreach ($offers as $value2){ #echo "
part1=".$codeparts[0]."
"; #echo "
shortcode=".$value2['ShortCode']."
"; if($codeparts[0]==$value2['ShortCode']){ $code=$value2['OfferCode']; $text=$value2['OfferDesc']; $val=$value2['OfferEquation']; $order=$value2['OfferOrder']; $icons=$value2['OfferIcons']; $code1=split('/',$code); break; } } ##echo $text; $c=0; if ($codeparts[1]!=""){ foreach ($code1 as $value3){ #echo $value3; $ans=0; if ($c>0){ $v= '$'.$value3."=".$codeparts[$c].";"; $prefix=""; if ($value3=='X'){ if ($codeparts[$c]==0){ $codeparts[$c]="FREE"; }else{ $prefix='£'; } } $text=str_replace('{'.$value3.'}',$prefix.$codeparts[$c],$text); ####### maximum 1st yr cost limited to 12 months #### if ($M>12){ $M=12; } ###### ##echo "
*** ".$v." ***
"; eval ($v); } $c++; } if ($val!=""){ eval ('$ans='.$val.';'); ##echo "
".$val." M=".$M." X=".$X; echo "Saving: £".$ans." - "; $yearLR=$yearLR+$ans; } } echo $text."
"; ##$offlist = array("desc" => $text, "cost" => $ans); array_push($offlist, array("order" => $order, "desc" => $text, "cost" => $ans)); if ($icons){ #echo "5=".$codeparts[2]; if (($icons=='LR.gif') AND ($codeparts[2]=='FREE')){ $icons="LR0.gif"; } echo ''; } #array_push($offlist["desc"], $text); #array_push($offlist["cost"], $ans); } echo "
*****************************
"; echo "Balance: ".$yearLR; echo "
Usual LR: ".$OrigyearLR; echo "
"; #return $phonecost+$yearLR; return array($phonecost+$yearLR,$offlist); } ############### function GetData($connect,$func,$id=0,$disconnect) { $link = mysql_connect ("localhost", "phones_3phones", "thunder") or die("Could not connect : " . mysql_error()); mysql_select_db ("phones_3phones"); switch ($func) { case "offer_equations": $query="SELECT OfferCodes.OfferCode, OfferCodes.OfferEquation, OfferDesc, OfferOrder, LEFT(OfferCode,2) AS ShortCode FROM OfferCodes WHERE (((OfferCodes.OfferEquation)<>''))"; $query="SELECT OfferCodes.OfferCode, OfferCodes.OfferEquation, OfferDesc, OfferOrder, OfferIcons, LEFT(OfferCode,2) AS ShortCode FROM OfferCodes"; #echo "
".$query."
"; break; case "offer_all": $query="SELECT * FROM Offers"; break; case "tariffs" : $query="SELECT * FROM Tariffsnew ORDER BY Tariff1stYearCost"; $query="SELECT Tariffsnew.Tariff1stYearCost, TariffAT+TariffTX AS ATplusTexts, Makes.MakeName, Networks.NetworkName, Phones.PhoneModel, Tariffsnew.TariffID, Tariffsnew.TariffPhone, Tariffsnew.TariffNetwork, Tariffsnew.TariffPAYG, Tariffsnew.TariffName, Tariffsnew.TariffPhoneCost, Tariffsnew.TariffRental, Tariffsnew.TariffAT, Tariffsnew.TariffOP, Tariffsnew.TariffPK, Tariffsnew.TariffTX, Tariffsnew.TariffContract, Tariffsnew.TariffOffers, Tariffsnew.TariffURL, Tariffsnew.TariffMerchant FROM Networks INNER JOIN (Makes INNER JOIN (Phones INNER JOIN Tariffsnew ON Phones.PhoneID = Tariffsnew.TariffPhone) ON Makes.MakeID = Phones.PhoneMake) ON Networks.NetworkID = Tariffsnew.TariffNetwork ORDER BY Tariffsnew.Tariff1stYearCost, TariffAT+TariffTX DESC LIMIT 30"; #echo $query; break; } $result = mysql_query($query); if ($result){ $num_fields = mysql_num_fields($result); #echo $num_fields; $j=0; $x=1; while($row=mysql_fetch_array($result)){ for($j=0;$j<$num_fields;$j++){ $name = mysql_field_name($result, $j); $data[$x][$name]=$row[$name]; # echo $data[$x][$name]; }$x++; } #echo "Make=".$data[20]["PhoneModel"]; return $data; } #else{return null;} } function UpdateFirstYearCost($offers){ ##function GetData($connect,$func,$id=0,$disconnect,$id2=0,$id3='=') $link = mysql_connect ("localhost", "phones_3phones", "thunder") or die("Could not connect : " . mysql_error()); mysql_select_db ("phones_3phones"); $query="SELECT * FROM Tariffsnew"; #echo $query; $result = mysql_query($query); if ($result){ $num_fields = mysql_num_fields($result); #echo $num_fields; while($row=mysql_fetch_array($result)){ #echo $row["TariffOffers"]."
"; $co=GetYear1Cost($offers,$row["TariffRental"],$row["TariffPhoneCost"],$row["TariffOffers"]); $t=$row["TariffID"]; $yearcost=$co[0]+$row["TariffPhoneCost"]; $arr=$co[1]; $sql="UPDATE Tariffsnew SET Tariff1stYearCost=$yearcost WHERE TariffID=$t"; ##echo $sql; $result2 = mysql_query($sql) or die(mysql_error()); ##echo "**** ".$result." ***"; } #echo "Make=".$data[20]["PhoneModel"]; #return $data; mysql_close($link); } #else{return null;} } ?>