At Kingston Free Zone
Shipped to Kingston Free Zone
Waiting Shipment Exotic & Supercars
///include("featured_stock_slider.php") ?>
///include("featured_stock_slider.php") ?>
if(!$_SESSION['ipcountry']) $_SESSION['ipcountry'] = 'JAMAICA'; include("header.php"); include("function_stock_price.php"); include("function_stock_panels.php"); $mobile_device = isMobileDevice(); $pic_res = stockPicDimension($mobile_device); $pic_width = $pic_res['pic_width']; $pic_height = $pic_res['pic_height']; $pic_counter = $pic_res['pic_counter']; /* function getWharfStatus($event , $days , $shipdate , $arrdate) { if($event == 'Shipment' && $shipdate) { if($days > 0 ) $event_date = date("Y-m-d" , strtotime("+ $days Days ".$shipdate)); else $event_date = date("Y-m-d" , strtotime("$days Days".$shipdate)); if($event_date < date("Y-m-d")) echo " At Kingston Wharf "; } if($event == 'Arrival' && $arrdate) { if($days > 0 ) $event_date = date("Y-m-d" , strtotime("+ $days Days ".$arrdate)); else $event_date = date("Y-m-d" , strtotime("$days Days".$arrdate)); if($event_date < date("Y-m-d")) echo " At Kingston Wharf "; } } */ $price_color_list['Original'] = '#9D9C9D;text-decoration: line-through;'; $price_color_list['Discounted'] = '#0099F4;'; $price_color_list['50%'] = '#009148;'; $price_color_list['100%'] = '#0060B9;'; $q = " SELECT * FROM kingston_price_setup "; $r = pg_query($q); $row = pg_fetch_array($r); $price_change_event = $row['price_change_event']; $price_change_days = $row['price_change_days']; $q = "SELECT payment_discount , payment_departure_days, refrence_exr_calc FROM misc_setting "; $r = pg_query($q); $row = pg_fetch_array($r); $payment_discount = json_decode($row['payment_discount'] , true); $payment_departure_days = $row['payment_departure_days']?:0; $refrence_exr_calc = $row['refrence_exr_calc']?:0; $dis_options = array(); $dis_options['payment_departure_days'] = $payment_departure_days; $dis_options['payment_discount'] = $payment_discount; $dis_options['refrence_exr_calc'] = $refrence_exr_calc; $sSQL = "SELECT customer.userid AS userid,customer.username AS cusername,customer.company AS ccompany,customer.country AS country,customer.port AS port,customer.agentdef AS cagentdef,customer.email AS cemail, customer.tel,tenderlogin.username as staffname,tenderlogin.email as temail, auctionsheet ,realmilage_place, realaucpoints_place, auctionsheet_place , priceuptype, priceup,priceup_slabs,stk_liner,port,country, bidding_per , gct_per , auction_per,roadtax_per, freight_per,ff_per, recycle_per,duedatetype , duedays , storage_per, thc_per,blfee_per,radiation_per,custom_label1,custom_charges1, shipmentamount, documentrelease , trans_per, trans_per1 ,trans_per2 , misc_per1 ,misc_per2 , misc_per3 , engine_no_checking, custom_label2,custom_charges2,custom_label3 , custom_charges3 , eff_special_price , trans_setting , bidding_price_1 , bidding_price_2 ,bidding_price_3, bidding_price_4 , bidding_price_5, fixed_price_1 , fixed_price_2, fixed_price_3, fixed_price_4, fixed_price_5, bidding_per_1 , bidding_per_2, bidding_per_3, bidding_per_4, bidding_per_5, bidding_m3_1 , bidding_m3_2, bidding_m3_3, bidding_m3_4, bidding_m3_5, bidding_trans_1 , bidding_trans_2, bidding_trans_3, bidding_trans_4, bidding_trans_5 , hand_charges1,hand_charges2,hand_charges3,hand_charges4,hand_charges5,hand_charges6,hand_charges7 , salesmanager, buy_days , buy_percent, order_days , order_percent , ship_days , ship_percent , arrive_days , arrive_percent , docs_days , docs_percent , del_days , del_percent , priceuptype , priceup , priceup_slabs"; $sSQL .= ",orderablesw,reserveablesw,partssw,withoutpricesw,priceup,priceuptype,priceup_slabs,discounttype,percentdiscount,perunitdiscount,needinsurance,needbalance , auctionsheet,realmilage,realaucpoints,currenctystock"; $sSQL .= " FROM customer INNER JOIN tenderlogin on customer.salesmanager=tenderlogin.userid"; $sSQL .= " where stockbuysw = 1 AND customer.userid=3129"; $result = pg_query($db,$sSQL) or die(pg_last_error()); $line_customer = pg_fetch_array($result, null, PGSQL_ASSOC); $cus_sel_liner = json_decode($line_customer['stk_liner'] , true); foreach($cus_sel_liner as $buy_country => $liner) { $qfr = "SELECT * FROM stk_freight WHERE buy_country = '".$buy_country."' AND liner = '".$liner."' AND ship_country = '".$line_customer['country']."' AND ship_port = '".$line_customer['port']."' "; $result = pg_query($db, $qfr ) or die(pg_last_error()); $row = pg_fetch_array($result); $freight_list[$buy_country] = $row; } $curr = strtoupper(substr($SCURR,4)); $exr_list = getExrList(); $q = "SELECT cpfixedamountup FROM countryport WHERE cpcountry = '".$line_customer['country']."' "; $r = pg_query($q); $row = pg_fetch_array($r); $misc_options['cpfixedamountup'] = $row['cpfixedamountup']; $sSQL = " SELECT * FROM exrate_prefrence WHERE exrate_country = 'JAMAICA' "; $result = pg_query($db,$sSQL); $line_ex_pref = pg_fetch_array($result, null, PGSQL_ASSOC); $exrate_slabs = json_decode($line_ex_pref['exrate_slabs'] , true); ?> include "scripts_stock_panels.php"; ?>