cavebatsofware

	    SELECT * FROM DocumentsUploadConfig WHERE DocumentType in ('Essay', 'LPN Program Classes') AND sectionid in (select id from supplementalsection where formsubsectionid in (select id from ApplicationFormSubsection where formsectionid in (select id from ApplicationFormSection where formid = @application_form_id)));


USE unicas_config;
SELECT * FROM DocumentsUploadConfig WHERE DocumentType in ('Essay', 'LPN Program Classes') AND formsubsectionid in (

select id from ApplicationFormSubsection where formsectionid in (
select id from ApplicationFormSection where formid = 6412));

cavebatsofware

master_r4 = CSV.parse(File.read('/Users/grantdefayette/Documents/rails40-master-1.csv'))
master_r3 = CSV.parse(File.read('/Users/grantdefayette/Documents/rails31-master-1.csv'))

nf11481_r4 = CSV.parse(File.read('/Users/grantdefayette/Documents/general_comb_rails4.csv'))
nf11481_r3 = CSV.parse(File.read('/Users/grantdefayette/Documents/general_comb_rails3.csv'))

hash_ma4 = ma4.map { |r| h = Hash.new; h[r[2].to_i] = [r[8], r[4], r[8], r[3]]; h }
hash_ks4 = nf11481_r4.map { |r| h = Hash.new; h[r[0].to_i] = [r[1], r[2], r[3], r[4]]; h }

hhma4 = Hash.new; hma4.each { |h| hhma4[h.first.key] = h.first.value }

cavebatsofware

SELECT 
    d.order_id AS OrderID,
    o.ship_date AS ShipDate,
    a.shipping_company AS ShippingCompany,
    a.shipping_city AS ShippingCity,
    a.shipping_state AS ShippingState,
    a.shipping_zip AS ShippingZip,
    d.client_reference AS ClientReference,
    m.carrier AS Carrier,
    IF(ISNULL(bo.bol_id),

cavebatsofware

require 'time'
require 'date'

class Keeper
  
  EXPIRE_TIME = 1209600 # 14 days

  def initialize(path)
    @root = Dir.new(path)
    @client_folders = {}

cavebatsofware

select 
    o.order_id as 'NEG order',
    d.client_reference as 'Order number',
    o.status as 'Order status',
    p.name as 'Product name',
    p.sku as 'SKU',
    p.upc as 'Barcode',
    SUM(i.quantity) as 'Order calls for',
    SUM(IFNULL(y.available, 0)) as 'Available',
    SUM(IFNULL(y.allocated, 0)) as 'Allocated to other orders',

cavebatsofware

insert into 
    order_pickpack (order_id, product_id, container_id, quantity)
select 
    '101813.2886', product_id, container_id, allocated
from
    inventory_history
where
    transaction_id = 9450767;

update order_inventory 

cavebatsofware

class FileReader

  def self.read_file(text, file_delim, field_delim)
    result = []
    lines_array = text.split([file_delim].pack('H*'))
    lines_array.each do |line|
      result << fields = line.split([field_delim].pack('H*'))
      fields.each do |field|
        puts field
      end

cavebatsofware

require 'active_record'
require 'yaml'
require 'pry'

dbconfig = YAML::load_file('config/database.yml')
ActiveRecord::Base.establish_connection(dbconfig)

class String
  def camelize
      self.split('_').map {|w| w.capitalize}.join

cavebatsofware

update order_details
set shipment_method_id = 'i2U12R'
where order_id in 
    (
        select 
            order_id
        from
            orders
        where
            client_id = 'artkohlcom' and status <> 'Shipped' and status <> 'Cancelled'

cavebatsofware

    Imports System.Transactions

    Class TemporalIncursionGenerator
        Public Property ClientID As String
        Public Property TransactionID As String
        Public Property UserID As String

        Private transaction_table As New DataTable
        Private query_command As New System.Text.StringBuilder("")
        Private command As New MySqlCommand()