'; ?> // if(somecart($usevid)>0) // { // echo '

Checkout

'; // echo '

View Cart

'; // } // echo '

Win a Barbour scarf?

'; // echo '

Repairs

'; // echo '
'; //show main cats if no category chosen // show any products at this level $goodprods = " AND pr_available<>'H'"; // must not be an "extra" from any other products perspective $sqlnex = " AND NOT EXISTS (SELECT * FROM shopprodprods WHERE spp_prodid2=pc_prodref AND spp_relationship='EXTRA')"; // Must not exist a higher seq diff cat $sqlnex2 = " AND NOT EXISTS (SELECT *, MAX(pc_seq) AS maxseq FROM shopprodcats WHERE pc_prodref=pr_prodref HAVING maxseq>pc_seq"; $sqlp = "SELECT * FROM shopprodcats, shopprods WHERE pc_prodref = pr_prodref AND pc_catref = $parcat".$goodprods.$sqlnex.' ORDER BY pc_seq'; $resp = query_db($sqlp); $noprods = mysqli_num_rows($resp); if((0==$parcat) || (0==$noprods)) { $sql = "SELECT * FROM shopcats WHERE sc_parentcat = $parcat AND sc_catlive='Y' ORDER BY sc_catseq"; $result = query_db($sql); while($row = mysqli_fetch_array($result)) { $catref = $row["sc_catref"]; $catname = stripslashes($row["sc_name"]); $linkcat = jemurl($catname); //echo '

'.$catname.'

'; } } else { //echo 'got '.$noprods.'
'; while($rowp = mysqli_fetch_array($resp)) { $prodid = $rowp["pr_prodref"]; $supplierid = $rowp["pr_supplier"]; $prodnamevis = $rowp["pr_namevis"]; $linkprod = jemurl($prodnamevis); if($inprodref == $prodid) { //echo '

'.$prodnamevis.'

'; } else { //echo '

'.$prodnamevis.'

'; } } } // Removed Sale area and Brands area 12/09/2017 // echo '

'; // echo '

Sale Items

'; // echo '

Brands

'; // //

//

//

?> 0) //{ $desc = ''; $sqlsc = "SELECT * FROM shopcartlines WHERE scl_visit=$usevid"; $ressc = query_db($sqlsc); $bad = 0; while($rowsc = mysqli_fetch_array($ressc)) { $cprodid = $rowsc["scl_prodid"]; $cqty = $rowsc["scl_qty"]; //$addedtext .= ' checking '.$cqty.' x '.$cprodid; $clineref = $rowsc["scl_auto"]; // get the desc $sqlcp = "SELECT * FROM shopprods WHERE pr_prodref=$cprodid"; $rescp = query_db($sqlcp); if($rowcp = mysqli_fetch_array($rescp)) { $desc = stripslashes($rowcp["pr_namevis"]); // now add options if any $sqlcp = "SELECT * FROM shopcartlinedetail WHERE (scld_personalisation='N') AND (scld_lineref = $clineref)"; $rescp = query_db($sqlcp); $coptions = ' ('; while($rowcp = mysqli_fetch_array($rescp)) { if(strlen($coptions)>2) { $coptions .= ','; } // looking for sizes and colours $option = stripslashes($rowcp["scld_option"]); $value = stripslashes($rowcp["scld_value"]); $coptions .= $option.':-'.$value; } if(strlen($coptions)>2) { $desc .= $coptions.')'; // try reverse variant $variant = reverseengineervariant($cprodid, $desc); //$addedtext .= ' '.$cqty.' x '.$desc.' ('.$variant.')'; // now look up and check for negative availability $sqlcp = "SELECT * FROM shopprodvariant WHERE pv_suppliercode='$variant'"; if($rescp = query_db($sqlcp)) { if($rowcp = mysqli_fetch_array($rescp)) { $avail = $rowcp["pv_available"]; // y/n $qty = $rowcp["pv_quantity"]; if($avail == 'n') { $bad++; // we may want to mention this one. $addedtext .= '

Note the product '.$variant.' '.$desc.' is out of stock currently.'; } elseif(($avail=='y') && ($qty>0) && ($qty<$cqty)) { $bad++; $addedtext .= '

Note you have requested '.$cqty.' of the product '.$variant.' '.$desc.'. We do not appear to have enough in stock. We will normally ship what we can now and the balance later.'; } } } } } } if($bad>0) { $addedtext .= '

Any products which are not available to ship now will be placed on back order and we will aim to ship within 7-10 days unless you hear otherwise. We do not take any money for products until we ship. View Cart'; } //} } else { if($_GET["pad"] == 'n') { $notecol = 'red'; $addedtext = 'Error adding to your shopping bag: Please call us on 01494 775577'; } } if (strlen($addedtext)>0) { echo '

'; echo ''.$addedtext.''; echo '

'; } } if(!$activebuying) { echo '

'; echo 'Our system is undergoing essential maintenance for a few days. If you wish to order, please email required product(s), with size and colour to help@saddler.co.uk. DO NOT INCLUDE PAYMENT DETAILS, we will contact you during office hours to complete. Or if easier, call us during our office hours (otherwise dial in UK 07827 818531) to place your order and pay.'; echo '

'; } $dovat = vatable($usevid); $payable = showcarttotalonly( $usevid, $linkappends, $dovat); //echo ''; echo ''; // echo ''; if($payable>0.00) { echo ''; } echo ''; // wrapper echo ''; // login if($parcat>0) { $fontsize = '"2"'; $cellspace='"10"'; } else { $fontsize = '"4"'; $cellspace = '"15"'; } $postwhen = postmessage2(); $subs = ''; // see if we are on a spare part? if($inprodref>0) { $fontsize='"2"'; $spare = checksparepart($inprodref); if(!$spare) { $subs = subscribemessage2(); } } else { $spare = checksparepartcat($parcat); if(!$spare) { $subs = subscribemessage2(); } } // try setting variables depending on client /* echo ''; echo ''; echo ''; echo ''; */ echo ''; // wrapper // what is top category? $foundcat = topcat($parcat); if($foundcat==true) { echo ''; } echo '