Jump to content

I am having trouble figuring out how to display the shipping costs :S


dwr

Recommended Posts

hey guys i am facing some problems that are realy starting to anoy me :)

 

first thing is that i cant even figure out how to add shipping costs towards the item detail page ...

 

i have managed to get it in the widget but not in the item page what am i doing wrong ?

 

the $localization are where english and the languages come ....

 


<?php
/**
* This class is used to display the item details
*/
class Display_DItemDetail
{
    function listDetails($arr,$price='',$qty,$buyprice='',$lotrecords='',$total_bids='',$minprice='',$sellerid,$auctype,$ship_details='')
    {
        //print_r($arr);
        include 'admin/cache/sitesettings.php';
        if(isset($_SESSION['language']) && $_SESSION['language']!='')
            $lang = $_SESSION['language'];
        else
            $lang = $sitesettings['language'];
        $path='classes/Lib/Local/'.$lang.'/localization.php';
        include $path;

        include("classes/Core/Views/CVDateCalculation.php");
        $sel="SELECT rate_wise_bidder FROM auction_search WHERE auction_id='".$arr['auction_id']."'";
        $qry=new Lib_Query();
        $qry->executeQuery($sel);
        $rate=$qry->records[0]['rate_wise_bidder'];
        $ratewise=0;
        if($rate>0)
        {
            if(!empty($_SESSION['auctionuserid']))
            {
                $se="SELECT count(*) as num FROM feedback WHERE feedback_to='".$_SESSION['auctionuserid']."' AND user_type=1 AND feedback_type=1";
                $qr=new Lib_Query();
                $qr->executeQuery($se);
                $count=$qr->records[0]['num'];            
                if($rate<=$count)
                    $ratewise=1;
                else
                    $ratewise=0;
            }
        }
         //$ratewise=1;
        $ff= new Core_Views_CVDateCalculation();
        $string_difference = $ff->getDiff($arr['expire_on']);
        if(strlen($string_difference)<=2)
                $date ="Duraion Expired";
        $output = "";
        $output .= '<tr>
            <td colspan="2" align="left" class="profile_list_txt"><span class="details_title">'.stripslashes(html_entity_decode($arr['title'])).'</span></td>
            </tr>';
        if($string_difference!='Duration Expired')
        {
            if($auctype==4)
            {
                $se="SELECT * FROM dutch_lottype WHERE auction_id='".$_GET['id']."' AND status=0";
                $qr=new Lib_Query();
                $qr->executeQuery($se);

                $cnt=count($qr->records);
                for($i=0;$i<$cnt;$i++)
                {
                    $chk=($i==0) ? "checked": "";
                    $output .= '<tr><td class="profile_list_txt" align="right"><input name="lot" id="lot'.($i+1).'"  type="radio"  value="'.($i).'" '.$chk.' /><input type="hidden" name="lotprice'.$i.'" value="'.$qr->records[$i]['lot_price'].'" /><input type="hidden" name="lotqty'.$i.'" value="'.$qr->records[$i]['lot_qty'].'" /><strong><label for ="lot'.($i+1).'">Lot '.($i+1).'</label></strong> : </td>
                            <td class="profile_list_txt"><label>'.$qr->records[$i]['lot_qty'].' '.$localization['ENG1531'].'-'.$qr->records[$i]['lot_price'].' </label></td>
                            </tr>';
                }
                if($cnt>0)
                    $output .= '<tr><td class="profile_list_txt" align="right"> </td><td class="profile_list_txt" align="left"><input type="submit" name="btnBid" id="btnBid" value="Buy Now" class="buy_it_bttn" /></td></tr>';
            }
        }

        if($price)
        {
            if( $string_difference!='Duration Expired')
            {
                if($arr['auct_type']==0)
                {
                    $sel="SELECT * FROM closed_auctions WHERE auction_id='".$arr['auction_id']."'";
                    $qq=new Lib_Query();
                    if(!$qq->executeQuery($sel))
                    {
                        $se="SELECT buy_it_price FROM simple_auction WHERE auction_id='".$arr['auction_id']."'";
                        $qr=new Lib_Query();
                        $qr->executeQuery($se);
                        $buyit=$qr->records[0]['buy_it_price'];
                        if($buyit>0)
                        {        
                            $sql = "SELECT symbol FROM currency_setting WHERE currency_id = '".$sitesettings['currency_set']."'";
                            $query = new Lib_Query();
                            $query->executeQuery($sql);
                            $currency = $query->records[0]['symbol'];
                            $output .= '<tr><td width="29%" align="right" class="profile_list_txt"><span class="buy_it_now">'.$localization['ENG1292'].' </span> '.$localization['ENG1533'].': </td>
                                <td width="71%" class="profile_list_txt"><span class="price_txt">'.$currency.' '.$buyit.'</span> <input type="button" onclick="submt()" name="btnBid" id="btnBid" value="Buy it Now" class="buy_it_bttn" /> </td></tr>';
                        }
                    }
                }
                $sel="SELECT * FROM closed_auctions WHERE auction_id='".$arr['auction_id']."'";
                $qq=new Lib_Query();
                if(!$qq->executeQuery($sel) && $auctype !=6 && $auctype !=5)
                {
                    $sql = "SELECT symbol FROM currency_setting WHERE currency_id = '".$sitesettings['currency_set']."'";
                    $query = new Lib_Query();
                    $query->executeQuery($sql);
                    $currency = $query->records[0]['symbol'];
                    $output .='<tr><td width="29%" align="right" class="profile_list_txt"><span class="buy_it_now">'.$localization['ENG1534'].' </span> '.$localization['ENG1533'].': </td><td width="71%" class="profile_list_txt"><span class="price_txt">'.$currency.' '.$price.'</span></td></tr>';    
                }
                if( $string_difference!='Duration Expired')
                {
                    if($auctype == 2)
                    {
                        $output .= '<tr><td class="profile_list_txt" align="right"><strong>'.$localization['ENG1255'].'</strong> : </td><td class="profile_list_txt"><label><input type="text" name="txtqty" id="txtqty" class="txt_box2"><input type="hidden" name="dqty" id="dqty" value="'.$qty.'" ></label></td></tr>';                      
                    }
                    $sql = "SELECT symbol FROM currency_setting WHERE currency_id = '".$sitesettings['currency_set']."'";
                    $query = new Lib_Query();
                    $query->executeQuery($sql);
                    $currency = $query->records[0]['symbol'];
                    $sqlBid = "SELECT * FROM `closed_auctions` a,reg_users b WHERE a.won_by=b.reg_id AND auction_id='".$_GET['id']."'";                
                    $queryBid = new Lib_Query();
                    if(!$queryBid->executeQuery($sqlBid))
                    {
                        if($auctype == 5 || $auctype == 6)
                        {
                            $output .= '<tr><td class="profile_list_txt" align="right"><strong>'.$localization['ENG1370'].'</strong> : '.$currency.'</td><input type="hidden" name="price" value="'.$price.'" /> <input type="hidden" name="minprice" value="'.$price.'"/><input type="hidden" name="auctionid" value="'.$_GET['id'].'"/><td class="profile_list_txt"><label><input type="text" name="txtbid" id="txtbid" class="txt_box2" />-(Enter more than'.' '.$currency.' '.$price.')<br />';
                        }
                        else
                        {
                            $minprice = $arr['current_bid_amount'];
                            $output .= '<tr><td class="profile_list_txt" align="right"><strong>'.$localization['ENG1370'].'</strong> : '.$currency.'</td><input type="hidden" name="price" value="'.$price.'" /> <input type="hidden" name="minprice" value="'.$minprice.'"/><input type="hidden" name="auctionid" value="'.$_GET['id'].'"/><td class="profile_list_txt"><label><input type="text" name="txtbid" id="txtbid" class="txt_box2" />';
                        }
                    }    
                    else
                    {
                        if(empty($queryBid->records[0]))
                        {
                            $output .='<tr><td class="profile_list_txt" align="right"> </td><td class="profile_list_txt" align="left"><strong>---'.$localization['ENG1535'].'---<br/>---'.$localization['ENG1536'].'---</strong></td></tr>';
                        }
                        else
                        {                        
                            $output .='<tr><td class="profile_list_txt" align="right"><strong>'.$localization['ENG1921'].':</strong></td><td class="profile_list_txt" align="left"><strong>'.$queryBid->records[0]['user_name'].'</strong></td></tr>';
                        }
                    }
                    if($auctype != 2 && !$queryBid->executeQuery($sqlBid) && $auctype != 6 && $auctype != 5)
                        $output .= '-(Enter more than '.$currency.''.$minprice.')<br />';
                    $output .= '</label></td>      </tr>      <tr><td class="profile_list_txt"> </td>';
                    if(!$queryBid->executeQuery($sqlBid))
                    {
                        $output .='<td class="profile_list_txt"><label>
                        <input type="submit" name="btnBid" id="btnBid" value="'.$localization['ENG1372'].'" class="buy_it_bttn" />    </label></td><td> </td>
                      </tr>';
                    }
                    if($buyprice)
                        $output .= '<tr>
                    <td width="29%" align="right" class="profile_list_txt"><span class="buy_it_now">'.$localization['ENG1292'].'</span> '.$localization['ENG1533'].': <span class="price_txt">'.$currency.''.$buyprice.'</span></td>
                    <td width="71%" class="profile_list_txt"><input name="button6" type="submit" class="buy_it_bttn" onclick="submt();" id="button9" value="'.$localization['ENG1292'].'" /></td></tr>';
                }
            }
        }
        elseif ($buyprice)
        {
            if($string_difference!='Duration Expired' && $arr['status']!=2)
            {
                $sql = "SELECT symbol FROM currency_setting WHERE currency_id = '".$sitesettings['currency_set']."'";
                $query = new Lib_Query();
                $query->executeQuery($sql);
                $currency = $query->records[0]['symbol'];
                $output .= '<tr>
                    <td width="29%" align="right" class="profile_list_txt"><span class="buy_it_now">'.$localization['ENG1292'].'</span> '.$localization['ENG1533'].': <span class="price_txt">'.$currency.''.$buyprice.'</span></td>
                    <td width="71%" class="profile_list_txt">';
                $output .= '<input name="button6" type="submit" class="buy_it_bttn" onclick="submt();" id="button9" value="'.$localization['ENG1292'].'" />';
            }
        }
        elseif ($lotrecords)
        {
            if($_SESSION['auctionuserid'] != $sellerid)
            {
                for ($i=0;$i<count($lotrecords);$i++)
                {
                        ($lotrecords);
                }
            }
        }
        if($_GET['auctype']!="won" && $_GET['auctype']!="sold" && $_GET['auctype']!="unsold" )
        {
        $output .= '<tr>
                <td align="right" class="profile_list_txt"><strong>'.$localization['ENG1540'].':</strong></td>
                <td class="profile_list_txt">'.$string_difference.'('.$arr['expire_on'].')</td>
                </tr>';
        }
        if($total_bids >1)
        {
            $output .= '<tr>
                <td align="right" class="profile_list_txt"><strong>'.$localization['ENG1541'].':</strong></td>
                <td class="profile_list_txt"><a href="?do=bidhistory&id='.$_GET['id'].'">'.($total_bids-1).'</a></td>
                </tr>';
        }
        $ship_cost = (isset($ship_details['ship_cost']))?$ship_details['ship_cost']:'';
        if($ship_cost)
        {
            $output .= '<tr>
                    <td align="right" class="profile_list_txt"><strong>'.$localization['ENG1542'].':</strong></td>
                    <td class="profile_list_txt">';
            $output .= '$'.$ship_details['ship_cost'].' <span class="number_txt">('.$localization['ENG1543'].')</span></td>
                    </tr>';
        }
        if($_GET['auctype']!="won" && $_GET['auctype']!="sold" && $_GET['auctype']!="unsold" )
        {
        $output .= '<tr>
                <td align="right" class="profile_list_txt"><strong>'.$localization['ENG1255'].':</strong></td>
                <td class="profile_list_txt">'.$qty.' '.$localization['ENG1544'].'</td>
              </tr>';

        if(isset($_SESSION['auctionuserid']))
        {
            $s="SELECT * FROM  watchlist WHERE user_id=".$_SESSION['auctionuserid']." AND auction_id=".$_GET['id'];
            $q=new Lib_Query();
            if(!$q->executeQuery($s))
            {
                 $output .='<tr>
                        <td align="right" class="profile_list_txt"><strong>'.$localization['ENG1545'].':</strong></td>
                        <td class="profile_list_txt"><a href="?do=itemdetail&action=watch&id='.$_GET['id'].'" class="advanced_search">'.$localization['ENG1546'].'</a></td>
                      </tr>';
            }
        }
        else
        {
            $output .='<tr>
                <td align="right" class="profile_list_txt"><strong>'.$localization['ENG1545'].':</strong></td>
                <td class="profile_list_txt"><a href="?do=itemdetail&action=watch&id='.$_GET['id'].'" class="advanced_search">'.$localization['ENG1546'].'</a></td>
              </tr>';
        }
        }    
        $query=new Lib_Query();
        $sql="select address,city,state,country,zipcode from reg_users_personal where reg_id=".$sellerid;
        if($query->executeQuery($sql))
        {
            $address=$query->records[0]['address'];
            $city=$query->records[0]['city'];
            $state=$query->records[0]['state'];
            $country=$query->records[0]['country'];
            $zipcode=$query->records[0]['zipcode'];
        }
           
        $sql="select state_name from state_province_mas where state_value='".$state."'";
        if($query->executeQuery($sql))
            $state_name=$query->records[0]['state_name'];
           
        $sql="select country_name from country_mas where country_value='".$country."'";
        if($query->executeQuery($sql))
            $country_name=$query->records[0]['country_name'];
        $sq = "SELECT item_condition FROM auction_search WHERE auction_id = '".$_GET['id']."'";
        $q = new Lib_Query();
        if($q->executeQuery($sq))
            $item_condition = $q->records[0]['item_condition'];
        if($item_condition == 0)
            $condt = "New";    
        else if($item_condition == 1)
            $condt = "Used";    
/*        '.$address.'<br>'.$city.'<br><br>'.$zipcode.'*/
        $output.='<tr>
            <td align="right" class="profile_list_txt" valign="top"> <strong>'.$localization['ENG1272'].':</strong></td>
            <td class="profile_list_txt" valign="top">'.$state_name.'<br>'.$country_name.'</td> </tr>
            <tr>
                <td align="right" class="profile_list_txt" valign="top"> <strong>'.$localization['ENG1029'].':</strong></td>
                <td class="profile_list_txt" valign="top">'.$condt.'</td> </tr>';
        return $output;
    }
   
    function listLocation($loc,$flag='')
    {
        include 'admin/cache/sitesettings.php';
        if(isset($_SESSION['language']) && $_SESSION['language']!='')
            $lang = $_SESSION['language'];
        else
            $lang = $sitesettings['language'];
        $path='classes/Lib/Local/'.$lang.'/localization.php';
        include $path;
        $output = "";
        $output .= '<tr>
            <td align="right" class="profile_list_txt"><strong>'.$localization['ENG1272'].':</strong></td>
            <td class="profile_list_txt">'.$loc['address'].",".$loc['country_name'].'</td>
          </tr>';
         if($flag!=1)
         {
         $output .= '    
          <tr>
            <td align="right" class="profile_list_txt"><strong>'.$localization['ENG1545'].':</strong></td>
            <td class="profile_list_txt"><a href="?do=itemdetail&action=watch&id='.$_GET['id'].'" class="advanced_search">'.$localization['ENG1546'].'</a></td>
          </tr>';
          }
          return $output;
    }
    function listPreDetails()
    {
        include 'admin/cache/sitesettings.php';
        if(isset($_SESSION['language']) && $_SESSION['language']!='')
            $lang = $_SESSION['language'];
        else
            $lang = $sitesettings['language'];
        $path='classes/Lib/Local/'.$lang.'/localization.php';
        include $path;
        include("classes/Core/Views/CVDateCalculation.php");
        include("classes/Core/Sell/CFeatureDetails.php");
        $feat = new Core_Sell_CFeatureDetails();
        $ff= new Core_Views_CVDateCalculation();
&nbs

 

thnx for looking

this here is what i am trying to bind in to the page, but it isnt showing anywhere, except in the widget files......

 

   $ship_cost = (isset($ship_details['ship_cost']))?$ship_details['ship_cost']:'';
        if($ship_cost)
        {
            $output .= '<tr>
                    <td align="right" class="profile_list_txt"><strong>'.$localization['ENG1542'].':</strong></td>
                    <td class="profile_list_txt">';
            $output .= '$'.$ship_details['ship_cost'].' <span class="number_txt">('.$localization['ENG1543'].')</span></td>
                    </tr>';

 

 

or do you mean something else ?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.