jimmybaker

select 
`o`.`order_number` AS `order_id`,
`o`.`placed_at` AS `date`,
`o`.`user_id` AS `shopper_id`,
`o`.`shipto_first_name` AS `shipto_firstname`,
`o`.`shipto_last_name` AS `shipto_lastname`,
`o`.`shipto_company` AS `shipto_company`,
`o`.`shipto_street` AS `shipto_address`,
`o`.`shipto_street2` AS `shipto_address2`,
`o`.`shipto_city` AS `shipto_city`,

jimmybaker

HOWTO: iPhone AT&T Tethering

In 10 steps:

• Update iTunes to 8.2 via Software Update
• Update your iPhone to the 3.0 release (out today - June 17th)
• Download this dmg and mount it: tethering file
• Enable hidden carrier testing option (in Terminal.app): defaults write com.apple.iTunes carrier-testing -bool TRUE
• Start up iTunes

jimmybaker

def inventory_for_warehouse(whs)
    inventories.find_by_warehouse_id(whs.id)
  end
  
  def quantity_on_hand_for_warehouse(whs)
    inventory = inventory_for_warehouse(whs)
    inventory.starting_quantity + inventory.inventory_transactions.sum(:adjustment, :conditions => ['created_at >= ?', inventory.starting_date])
  end

jimmybaker

select month(so.placed_at),
sum(case month(so.placed_at) when 1 then (soi.price*soi.quantity) else 0 end) as JanuarySales
from sales_orders so
inner join sales_order_items soi on so.id = soi.sales_order_id
where
year(so.placed_at) = 2009
and
(so.state != 'pending' and so.state != 'cancelled')

jimmybaker

    xml.Styles do
      xml.Style 'ss:ID' => 'currency', 'ss:Name' => 'Currency' do
        xml.NumberFormat 'ss:Format' => '_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)'
      end
    end

jimmybaker

update sales_orders so
inner join users u on so.user_id = u.id
set so.sales_team_id = case u.sales_team_id
                          when 1 then
                            case so.shipto_state
                              when 'TN' OR 'AL' then 2
                              when 'TX' then 3
                              when 'GA' OR 'NC' OR 'SC' then 4
                              else 1
                            end

jimmybaker

jimmy-bakers-macbook-pro-15:TapeOnline jimmy$ sudo rake gems:install --trace
(in /Users/jimmy/Projects/TapeOnline)
** Invoke gems:install (first_time)
** Invoke gems:base (first_time)
** Execute gems:base
** Invoke environment (first_time)
** Execute environment
rake aborted!
undefined method `searchable_by' for #<Class:0x38f034c>
/Library/Ruby/Gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1833:in `method_missing'

jimmybaker

0,5,10,15,20,25,30,35,40,45,50,55 * * * * /home/deploy/apps/tapeonline/releases/20090709231752/script/runner -e production "UserMailer.deliver_test_message_to_jimmy"

jimmybaker

#!/usr/bin/env ruby
require 'yaml'
require 'logger'
require 'rubygems'
require 'net/scp'

class Backup  
  def self.directory
    @@directory ||= File.dirname(__FILE__)
  end

jimmybaker

def title_and_price
    "#{title} - #{ActionView::Helpers::NumberHelper.number_to_currency(price)}"
  end