Programming made easy :)

An Easy Way to Backup and or Move Magento

May11
2012 2 Comments Written by leland

First of all I cant take credit for this. I came across it randomly and I thought the scripts were amazing and thought I would share them here.

Export Script

#!/bin/bash
 
#####################################################
#          MyProject export script                  #
#####################################################
#
#  To use this script:
#
#  1) Place this script into the MyProject directory you'd like to copy
#  2) Edit the database settings below
#  3) Use the command "./export" or "./export -date"
#
#  This script creates a file called "backup.tar.gz" that can be used
#  to make a new installation of MyProject using the "import" script
#
#  Use "./export -date" to save the file as (TIMESTAMP).tar.gz
#
#  Open the import script for further instructions
#
#  http://magentoadvisor.com
#
#####################################################
#         Keeping this file up to date              #
#####################################################
#
#  Any files modified outside of the directories listed under the
#  comment "Directories to be copied" need to be added to this script
#
#####################################################
 
#########################
#   Database settings   #
#########################
DBHOST=localhost
DBUSER=advisor_myuser
DBNAME=advisor_myproject
DBPASS=p4ssw0rd
 
PROJECTNAME=MyProject
 
#####################################################
#  End configuration options
#####################################################
 
if [ "$1" = "-date" ]; then
    FILENAME="$PROJECTNAME-$(date +%Y%m%d-%H%M).tar.gz"
else
    FILENAME="backup.tar.gz"
fi
 
mkdir backup
 
#############################
# Directories to be created #
#############################
mkdir -p backup/media
mkdir -p backup/app/etc/modules
mkdir -p backup/app/code/local
mkdir -p backup/app/design/adminhtml/default/default
mkdir -p backup/app/design/frontend/default/default
mkdir -p backup/skin/adminhtml/default/default
mkdir -p backup/skin/frontend/default/default
mkdir -p backup/js/jquery
########### End ############
 
# Config file
cp app/etc/local.xml backup/app/etc/local.xml
 
# Media directory
cp -r media backup/
 
# Module declarations
cp app/etc/modules/Yourname_All.xml backup/app/etc/modules/Yourname_All.xml
 
# Local directories
cp -r app/code/local backup/app/code/
cp -r app/design/adminhtml/default/default backup/app/design/adminhtml/default/
cp -r app/design/frontend/default/default backup/app/design/frontend/default/
cp -r skin/adminhtml/default/default backup/skin/adminhtml/default/
cp -r skin/frontend/default/default backup/skin/frontend/default/
cp -r js/jquery backup/js/
 
# Dump the database
mysqldump -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME > backup/data.sql
 
# Create the .tar.gz
tar -zcf $FILENAME ./backup
 
# Delete the backup directory
rm -rf ./backup
 
echo "Completed"
echo "$FILENAME has been created"

Import Script

#!/bin/bash
 
####################################################
#          MyProject installation script           #
####################################################
#
#  This script installs both Magento and MyProject
#
#  To use:
#
#  1) Copy "backup.tar.gz" and this script to chosen directory
#
#  2) Make an empty database and edit the variables below
#
#  3) Run ./import
#
#  4) That's it.  Your magento is ready to go
#
#  http://magentoadvisor.com
#
####################################################
 
#####################################
#             Variables             #
#####################################
 
# Set owner of files so apache can execute properly
# "myusername" will typically be your login name
# or /home/<yourname>/public_html
APACHEUSER=myusername
APACHEGROUP=myusername
 
# Set URL
BASEURL=http://www.yourdomain.com/shop/
 
# Database Settings
DBHOST=localhost
DBUSER=advisor_myuser
DBNAME=advisor_myproject
DBPASS=p4ssw0rd
 
# Magento Installation settings
MAGENTOURL=http://www.magentocommerce.com/downloads/assets/1.4.0.1/magento-1.4.0.1.tar.gz
MAGENTOFILE=magento-1.4.0.1.tar.gz
 
# magento configuration table.  add prefix if your magento is set to use prefixes
CONFIGTABLE=core_config_data
 
#####################################
#       End Configuration           #
#####################################
 
#####################################
#       Magento Installation        #
#####################################
 
wget $MAGENTOURL
tar -zxf $MAGENTOFILE
mv magento/* magento/.htaccess .
chmod -R 0755 .
chmod o+w var var/.htaccess app/etc
chmod -R o+w media
rm -rf downloader/pearlib/cache/* downloader/pearlib/download/*
rm -rf magento/
rm -rf $MAGENTOFILE
 
#####################################
#    MyProject Installation         #
#####################################
 
tar -zxf backup.tar.gz
cp -ar backup/* .
rm -rf backup/
 
#####################################
#      app/etc/local.xml            #
#####################################
 
USERNAMEREGX='s/<username><![CDATA[.*]]></username>/<username><![CDATA['$DBUSER']]></username>/g'
PASSWORDREGX='s/<password><![CDATA[.*]]></password>/<password><![CDATA['$DBPASS']]></password>/g'
DBNAMEREGX='s/<dbname><![CDATA[.*]]></dbname>/<dbname><![CDATA['$DBNAME']]></dbname>/g'
 
sed -i $USERNAMEREGX app/etc/local.xml
sed -i $PASSWORDREGX app/etc/local.xml
sed -i $DBNAMEREGX app/etc/local.xml
 
######################################
#     Import DB from data.sql        #
######################################
 
# we need to edit web/unsecure/baseurl in __core_config_data__
QUERY="update "$CONFIGTABLE" set "$CONFIGTABLE".value = '"$BASEURL"' where path = 'web/unsecure/base_url' or path = 'web/secure/base_url'"
# just append the update to the end of data.sql
echo $QUERY >> data.sql;
mysql -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME < data.sql
rm -f ./data.sql
 
######################################
#     End                            #
######################################
 
chown -R $APACHEUSER:$APACHEGROUP .
 
echo "Installation complete.  Delete backup.tar.gz"

And to checkout the tutorial go here. I would like to thank Brady Matthews for this awesome tutorial.

Posted in Magento, Tutorials - Tagged , ,

How to Create an Ajax Coupon / Discount Code Box in Magento

Apr28
2012 Leave a Comment Written by leland

Today I am going to show you how to create an ajax coupon / discount code box for your cart page. The first thing you are going to want to do is follow this tutorial. Basically this will set you up with the new extension you are going to create. The only thing in the tutorial that you do not need to do is putting any information in the controller file. Ares is going to look a little different then theirs.

I am going to assume you have followed the tutorial and you are ready to edit your CartController.php. To start off your file is going to look like this.

<?php

  require_once 'Mage/Checkout/controllers/CartController.php';

  class YourNameSpace_YourModule_CartController extends Mage_Checkout_CartController
  {
    
  }

This is our basic controller file. With this any functions we write that have the same name as the Mage Cart Controller will now be overwritten. this is great if you ever need to make changes like adding ajax functionality to any other parts of magento. Next we add the following code and our file should look like this.

<?php

  require_once 'Mage/Checkout/controllers/CartController.php';

  class YourNameSpace_YourModule_CartController extends Mage_Checkout_CartController
  {
    function couponPostAction()
    {
      // if not ajax have parent deal with result
      
      if(!isset($_POST['ajax']))
      {
        parent::couponPostAction();
        return;
      }
      
      $msg = '';
      
      $couponCode = (string) $this->getRequest()->getParam('coupon_code');
          if ($this->getRequest()->getParam('remove') == 1) {
              $couponCode = '';
          }
          $oldCouponCode = $this->_getQuote()->getCouponCode();
  
          if (!strlen($couponCode) && !strlen($oldCouponCode)) {
              $this->_goBack();
              return;
          }
  
          try {
              $this->_getQuote()->getShippingAddress()->setCollectShippingRates(true);
              $this->_getQuote()->setCouponCode(strlen($couponCode) ? $couponCode : '')
                  ->collectTotals()
                  ->save();
  
              if ($couponCode) {
                  if ($couponCode == $this->_getQuote()->getCouponCode()) {
                      $this->_getSession()->addSuccess(
                          $this->__('Coupon code "%s" was applied.', Mage::helper('core')->htmlEscape($couponCode))
                      );
                  }
                  else {
                     $msg = $this->__('Coupon code "%s" is not valid.', Mage::helper('core')->htmlEscape($couponCode));
                  }
              } else {
                  $this->_getSession()->addSuccess($this->__('Coupon code was canceled.'));
              }
  
          } catch (Mage_Core_Exception $e) {
              $msg = $e->getMessage();
          } catch (Exception $e) {
               $msg = $this->__('Cannot apply the coupon code.');
              Mage::logException($e);
          }
      
      echo $msg;
    }
  }

So basically what we do is check for a POST variable called ajax. If this does not exist then we know not to use our ajax code so let the regular code run or the parents code if you will. If it is available then we continue. The code is essentially the same as it’s parent except instead of putting any errors into a session variable and send the browser back a page, we are echoing out any error messages. If the $msg variable is empty then we know there were no errors.

Now we can move on to our form and javascript. Our form should look something like the following

<div class="box">
  <strong class="ttl">DISCOUNT CODE</strong>
  <p>Enter your coupon code if you  have one</p>
  <form id="discountcode-form" action="<?= $this->getUrl('checkout/cart/couponPost') ?>" name="discountcode-form" method="post">
    <div class="text discount-code"><input type="text" name="coupon_code" value="SUBMIT YOUR CODE" /></div>
    <input type="submit" class="btn-apply" value="APPLY"/>
  </form>
</div>

This is just your basic discount code form. You can make any design modifications as you want the only things that are important are the form tags and the input box. Once you have your form you will want to create the following javascript

$('#discountcode-form').submit(function(e)
{
  e.preventDefault();
  
  $.ajax({
    url:$('#discountcode-form').attr('action'),
    type:'POST',
    data:'ajax=true&'+$('#discountcode-form').serialize(),
    success:function(data)
    {
      if(data != '')
      {
        // Display error message however you would like
      }
    }
  });
});

What this script does is takes the action url from the form and passes all of the forms data to our php script using the jQuery ajax function. It then listens for a response. If it getts something other then null you can take that message and display it however you like.

If you have any questions please let me know and as always leave your feedback :)

Posted in Magento, PHP, Tutorials - Tagged , ,

How to Properly Loop Through a Configurable Products Super Attributes in Magento

Apr27
2012 Leave a Comment Written by leland

I have run into the problem where I wanted to get all of a products super attributes and display them in my own custom way so today I am going to show you how to do it.

Once you have your current product which in this case we are going to call $_product all you have to do is the following

$_attributes = $_product->getTypeInstance(true)->getConfigurableAttributes($_product);

foreach($_attributes as $attribute)
{
    $attributeCode = $attribute->getProductAttribute()->getAttributeCode();

    $_allSubProducts = $_product->getTypeInstance(true)->getUsedProducts(null, $_product);

    foreach($_allSubProducts as $_subProduct)
    {
        if ($subproduct->isSaleable())
        {
            $label = $_subProduct->getAttributeText($attributeCode);
            $value = $_subProduct->getData($attributeCode);

            // Your code goes here
        }
    }
}

The first thing you are doing is getting all of the super attributes. You then use a foreach loop to go through all of them. While you are doing that you are getting all of your sub-products which would be your simple products. With this you check if it is currently sellable because if it is not you don’t want it to show up. You then get the attributes label and value then display it however you need to. I usually use this technique for size and color on products because I can make it look more interesting then just a dropdown menu.

As always give me your feedback and let me know if you have another way of doing it. :)

Posted in Magento, PHP, Tutorials - Tagged , ,

Yii and Up and Coming Framework

Apr21
2012 Leave a Comment Written by leland

Today i want to talk about an up and coming framework called Yii. But before I do I want o give you a little background on the other frameworks I have used. I have used CakePHP, Zend Framework and Code Igniter. All have their advantages and disadvantages but none of them really worked for me. Zend is probably my least favorite which is ironic since i have been doing a lot of work in Magento and it is based off this framework. I just never could get into it when I used it and taking over somebody else’s project was a hassel to me. CakePHP was great but I havent had to many projects that I have used it in and the same goes for Code Igniter. I would have probably used them more if any of them really caught my intrest but Yii has caught my intrest and I love it.

Even though Yii is in it’s young stage compared to everyone else i feel it has a lot to offer. It is one of the few event driven frameworks out there and it does not concern itself with PHP4 compatibility which is great because it looses a lot of bloat that a lot of frameworks have by still supporting it.

Yii overall is very quick to use thanks to the GUI named Gii which it uses for making your models, views and controllers. This saves a lot of time because it will put all of your files in the right spots as well as give you the flexibility to limit or extend it as much as you want. To me this is important because with CakePHP I always felt like I was fighting the way it wanted to do things when there was something I wanted to do that was out of it’s normal bounds.

Yii has another advantage that i like and that is the ability for people to create extensions and plugins and the community has expanded on this quite quickly. I feel that at this pace it could have the potential to have community like WordPress where you can get a wide arrange of plugins and extensions to help build your projects even faster.

I will continue to write about Yii and how I feel it is changing and keep everyone updated as it progresses. If you want to check it out click here for yourself and let me know how you feel about it.

Posted in Frameworks, PHP, Yii - Tagged , ,

Installing ImageMagick PHP into MAMP Pro 2.0.5 OS 10.7 X Lion

Apr13
2012 7 Comments Written by leland

So getting this to work can be quite tedious. It has taken hours upon hours and google search after google search but I have finally gotten it working.

The first things you need to do are

Once ImageMagick is installed on your system I am going to show you how to make it work with MAMP.

First you should run the following command

export PATH=/Applications/MAMP/bin/php/php5.3.6/bin:$PATH

This will make sure that we are using the correct PHP, Pear and PECL libraries. Then you will want to quite terminal and reopen it or you can type the following

source ~/.bash_profile

Second uncompress MAMP_components_2.0.2.zip which is most likely in your downloads directory. Now to the commandline

cd ~/Downloads/MAMP_components_2.0.2

tar -xf php-5.3.6.tar.gz

mv php-5.3.6 /Applications/MAMP/bin/php/php5.3.6/include/php

cd /Applications/MAMP/bin/php/php5.3.6/include/php

Now durring my searches i came across someone setting config options but theres was for snow leopard so i modified it to work with Lion

MACOSX_DEPLOYMENT_TARGET=10.7 CFLAGS="-arch i386 -arch x86_64 -g -Os -pipe -no-cpp-precomp" CCFLAGS="-arch i386 -arch x86_64 -g -Os -pipe" CXXFLAGS="-arch i386 -arch x86_64 -g -Os -pipe" LDFLAGS="-arch i386 -arch x86_64 -bind_at_load"

export CFLAGS CXXFLAGS LDFLAGS CCFLAGS MACOSX_DEPLOYMENT_TARGET

One the build is done we can move on to building in the PECL extension for ImageMagick. Now because there is a bug with the latest version of the PECL extension for ImageMagick and installing it into MAMP, you will want to download versions 2.3 which you can get here. Once downloaded unzip and then do the following commands in the terminal

cd ~/Downloads/imagick-2.3.0/imagick-2.3.0

phpize

./configure

make

make install

Next edit /Applications/MAMP/Library/bin/envvars and change the following lines to like this

#DYLD_LIBRARY_PATH=”/Applications/MAMP/Library/lib:$DYLD_LIBRARY_PATH”

#export DYLD_LIBRARY_PATH

Once that is done all you have to do is add

extension=imagick.so

to your php.ini file and restart MAMP. You should now have ImageMagick PHP installed and working properly. To make sure it is enabled you can view a page with the phpinfo() function in it.

Let me know if you have any questions and I hope this helps somebody.

Posted in MAMP, OS X Lion, PHP, Tutorials - Tagged , , , , , ,

Magento and is it worth using

Apr10
2012 9 Comments Written by leland

I have built many e-commerce sites. Everything from custom to using an e-commerce like magento and I have come to a decision. Building custom e-commerce sites just isn’t cost effective any more. Clients today want solutions that can be expanded on and that can save time. they want to cut costs by using plugins and they want to use something that can be updated by anyone.

I think wordpress really started this movement. To me it was the first to really show what a community of people can do and how easy it can be to maintain and because it is so widely used finding a programmer to work in it has become a breeze. This is the reason magento is becoming such a popular choice. Clients want to know that at the end of the day if for some reason you cannot do work with them anymore, they can find somebody to pick up the slack.

Magento offers a lot right out of the box and has the power of paypal behind it so you know it isn’t going anywhere anytime soon but the biggest advantage is the fact that there are many plugins available for little to know money that can really push your e-commerce site to new levels very quickly. Another advantage over building a custom site is the fact that you save so much time building the admin. This is the biggest advantage to me as a programmer because this is where I spend most of my time. Having to build something you have built many times becomes tedious and eventually you get bored which has happened to me many times.

Now this isn’t a review of magento. This is more of my thoughts and experiences that I have had over the years and the current trends that are going on in the industry. Many big companies are going this way. Let me know what you think. What are you using?

Posted in Magento - Tagged ,