"; $sql="INSERT INTO Tariffsnew (TariffPhone,TariffNetwork,TariffPAYG,TariffName,TariffPhoneCost,TariffRental,TariffAT,TariffOP,TariffPK,TariffTX,TariffContract,TariffOffers,TariffURL,TariffMerchant,Tariff1stYearCost) VALUES($phoneid,$networkid,$payg,'".$tariff."',$phonecost,$tariffcost,$at,$op,$pk,$text,$contract,'".$offercode."','".$url."',$merchantid,$year1)"; echo $sql."
"; $result2 = mysql_query($sql) or die(mysql_error()); } } mysql_close($link); ### function zero($var){ if (!$var){ $var=0; } return $var; } function VerifyCSV($offers) { $a=CSV2Array($csv); $count=0; foreach ($a as $value){ $count++; if ($value[0]){ $phoneid=$value[0]; $networkid=$value[1]; $payg=$value[2]; $tariff=$value[3]; $phonecost=$value[4]; $tariffcost=$value[5]; $at=$value[6]; $op=$value[7]; $pk=$value[8]; $text=$value[9]; $contract=$value[10]; $offercode=$value[11]; $url=$value[12]; $year1=GetYear1Cost($offers,$tariffcost,$phonecost,$offercode); echo "ROW ".$count." : ".$phoneid." - ".$offercode." - ".$year1."
"; } } } function CSV2Array($openFile, $columnsOnly = false) { $handle = fopen ($openFile,"r"); $rows = 0; while (!feof($handle)) { $columns[] = explode(",", fgets($handle, 4096)); if ($rows++ == 0 && $columnsOnly) break; } fclose ($handle); return $columns; } 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"; } array_push($offlist, array("order" => $order, "desc" => $text, "cost" => $ans, "icons" => $icons)); ##echo '
*****************************
"; #echo "Balance: ".$yearLR; #echo "
Usual LR: ".$OrigyearLR; #echo "
"; #return $phonecost+$yearLR; return array($phonecost+$yearLR,$offlist); } function GetYear1Cost($offers,$LR,$phonecost,$code){ $offlist = array(); $yearLR=$LR*12; #echo "*** $yearLR ****
"; $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; } } $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 "Saving: £".$ans." - "; $yearLR=$yearLR+$ans; } } #echo $text."
"; } return $phonecost+$yearLR; } ############### 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"; #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;} } ?>