pacificshack

OK ^ ignore last post, I managed to use 3 x functions to get what I wanted to achieve. Posting this here incase other people may find it useful:

// Disable FREE Shipping if product in cart has shipping class 
function ps_hide_free_shipping_for_shipping_class( $rates, $package ) {
	$shipping_class_target = 74; // shipping class ID (to find it, see screenshot below)
	$in_cart = false;
	foreach( WC()->cart->cart_contents as $key => $values ) {
		if( $values[ 'data' ]->get_shipping_class_id() == $shipping_class_target ) {
			$in_cart = true;
			break;
		} 
	}
	if( $in_cart ) {
		unset( $rates['free_shipping:2'] ); // shipping method with ID (to find it, see screenshot below)
	}
	return $rates;
}
add_filter( 'woocommerce_package_rates', 'ps_hide_free_shipping_for_shipping_class', 10, 2 );

// Hide shipping rates when free shipping available
function my_hide_shipping_when_free_is_available( $rates ) {
	$free = array();
	foreach ( $rates as $rate_id => $rate ) {
		if ( 'free_shipping' === $rate->method_id ) {
			$free[ $rate_id ] = $rate;
			break;
		}
	}
	return ! empty( $free ) ? $free : $rates;
}
add_filter( 'woocommerce_package_rates', 'my_hide_shipping_when_free_is_available', 100 );

// Amend Flat Rate amount if over $100 and shipping class
function wc_ninja_change_flat_rates_cost( $rates, $package ) {
	// Current value of the shopping cart
	$cart_subtotal = WC()->cart->subtotal;
	// Check if the subtotal is greater than $100
	if ( $cart_subtotal >= 100 ) {
		// Set the cost minus $11.99 for shipping rate
		$rates['flat_rate:1']->cost = $rates['flat_rate:1']->cost-11.99;
	}
	return $rates;
}
add_filter( 'woocommerce_package_rates', 'wc_ninja_change_flat_rates_cost', 10, 2 );

Hi Frank, thanks for your response. I actually ended up creating my own ‘app’ in the end which sits on a WordPress page. The page has:

– 12 questions
– Each question is answered by choosing one of 10 radio buttons (choosing 1-10)
– The user enters name and email to get results.
– Form is sent to a php form using ajax. Details are sent to a database for reference. Details are then sent out on a HTML email using phpMailer to the user. Each question has a copy of their score with the answer.
– Questions and answers set up in an external database.
– If the user answered ‘3’ they are given an answer which has a range of ‘1-3’.
– Email has call to action to encourage user to get in touch.

Could add more to it, but better to keep simple. Cheers.

OK, some good news! Infinite scroll on WordPress with custom post types inside Masonry – works! Yippee!

I set up an includes file called page-gallery.inc – and I point to it if the user is on the Gallery page, then use the following code:

<?php
# db configuration
define('DB_HOST', '<DB_HOST>');
define('DB_USER', '<DB_USER>');
define('DB_PASS', '<DB_PASS>');
define('DB_NAME', '<DB_NAME>');
$limit = 10; #item per page
# db connect
$link = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die('Could not connect to MySQL DB ') . mysql_error();
$db = mysql_select_db(DB_NAME, $link);
$page = (!isset($_GET['page'])) ? 1 : $_GET['page'];
# sql query
$sql = "SELECT * FROM wp_posts WHERE post_type = 'gallery' AND post_status = 'publish' ORDER BY post_title ASC";
# find out query stat point
$start = ($page * $limit) - $limit;
# query for page navigation
if( mysql_num_rows(mysql_query($sql)) > ($page * $limit) ){
	$next = ++$page;
}
$query = mysql_query( $sql . " LIMIT {$start}, {$limit}");
if (mysql_num_rows($query) < 1) {
	header('HTTP/1.0 404 Not Found');
	echo 'Page not found!';
	exit();
}
?>

<div id="pageRowMasonry" class="pageRow js-masonry" id="contentScroller" data-masonry-options='{ "columnWidth": 200, "itemSelector": ".pageGalleryContainer" }'>

	<?php
	// Loop first wp_posts
	while ($row = mysql_fetch_array($query)):
		// Look for featured image in WP_postmeta
		$sqlMETA1 = "SELECT * FROM wp_postmeta WHERE post_id = '".$row['ID']."'";
		$queryMETA1 = mysql_query($sqlMETA1);
		$rowMETA1 = mysql_fetch_array($queryMETA1);

		// Look for _thumbnail_id
		if ($rowMETA1['meta_key'] == '_thumbnail_id') {
			$sqlMETA2 = "SELECT * FROM wp_postmeta WHERE post_id = '".$rowMETA1['meta_value']."'";
			$queryMETA2 = mysql_query($sqlMETA2);
			$rowMETA2 = mysql_fetch_array($queryMETA2);

			// Look for categories through WP
			$sqlTERMS = "SELECT * FROM wp_terms WHERE name = 'Gallery (Double)'";
			$queryTERMS = mysql_query($sqlTERMS);
			$rowTERMS = mysql_fetch_array($queryTERMS);

			$sqlTAX = "SELECT * FROM wp_term_taxonomy WHERE term_id = '".$rowTERMS['term_id']."'";
			$queryTAX = mysql_query($sqlTAX);
			$rowTAX = mysql_fetch_array($queryTAX);

			$sqlRELS = "SELECT * FROM wp_term_relationships WHERE object_id = '".$row['ID']."' AND term_taxonomy_id = '".$rowTAX['term_taxonomy_id']."'";
			$queryRELS = mysql_query($sqlRELS);
			$rowRELS = mysql_fetch_array($queryRELS);

			if (isset($rowRELS['object_id'])) {
				$pageGalleryContainerType = 'pageGalleryContainerDouble';
			} else { $pageGalleryContainerType = 'pageGalleryContainerSingle'; }
			?>
			<div class="pageGalleryContainer <?php echo $pageGalleryContainerType; ?> masonry-brick" style="position: absolute;">
				<a href="http://beta.photographersinc.co.nz/wp-content/uploads/<?php echo $rowMETA2['meta_value']; ?>" class="fancybox">
					<div class="pageGalleryContainerText"><h3 class="displayNone"><?php echo $row['post_title']; ?></h3></div>
					<img width="474" height="316" src="http://beta.photographersinc.co.nz/wp-content/uploads/<?php echo $rowMETA2['meta_value']; ?>" class="attachment-large wp-post-image" alt="<?php echo $row['post_title']; ?>">
				</a>
			</div>
	<?php } ?>
	<?php endwhile; ?>

	<!--page navigation-->
	<?php if (isset($next)): ?>
	<div class="page-nav">
		<a href='http://beta.photographersinc.co.nz/gallery.php?page=<?php echo $next?>'>Next</a>
	</div>
	<?php endif?>

	<script src="<?php bloginfo('template_directory'); ?>/js/masonry.pkgd.min.js"></script>
	<script src="<?php bloginfo('template_directory'); ?>/js/jquery.infinitescroll.min.js"></script>
	<script>
	  jQuery(function(){

	    var $container = jQuery('#pageRowMasonry');

	    $container.imagesLoaded(function(){
	      $container.masonry({
	        itemSelector: '.pageGalleryContainer',
	        columnWidth: 100
	      });
	    });

	    $container.infinitescroll({
	      navSelector  : '.page-nav',    // selector for the paged navigation
	      nextSelector : '.page-nav a',  // selector for the NEXT link (to page 2)
	      itemSelector : '.pageGalleryContainer',     // selector for all items you'll retrieve
	      loading: {
	          finishedMsg: 'No more pages to load.',
	          img: 'http://i.imgur.com/6RMhx.gif'
	        }
	      },
	      // trigger Masonry as a callback
	      function( newElements ) {
	        // hide new items while they are loading
	        var $newElems = jQuery( newElements ).css({ opacity: 0 });
	        // ensure that images load before adding to masonry layout
	        $newElems.imagesLoaded(function(){
	          // show elems now they're ready
	          $newElems.animate({ opacity: 1 });
	          $container.masonry( 'appended', $newElems, true );
	        });
	      }
	    );

	  });
	</script>
</div>

Bingo. As the page scrolls down it loads in more posts of the type ‘gallery’ which have been set up as a custom post type.

Hope this helps other people, it has taken me a long time to resolve.

Have found a solution for adding a one off fee to cart, depending on the post meta:

In functions.php file

// WooCommerce hook to add LogoUpload value to cart
add_action( 'woocommerce_before_calculate_totals', 'cp_add_custom_price' );
function cp_add_custom_price( $cart_object ) {

    global $woocommerce;
    foreach ( $cart_object->cart_contents as $key => $value ) {

        //$proid = $value['product_id'];
        //$variantid = $value['variation_id'];
        //$price = $value['data']->price;
        $cartItemData = $woocommerce->cart->get_item_data($value);

        if (preg_match("/Yes, upload logo/i", $cartItemData)) {
		    $excost = 99;
			$woocommerce->cart->add_fee( 'Logo set up fee', $excost, $taxable = false, $tax_class = '' );
		}

   }
}

This adds the function to the cart. It gets the item data, and uses a php function to scan the content. If it matches a certain term, add the fee, if it doesn’t don’t add the fee.

Done.