cavebatsofware

The AppBasicStateService provides an easy way to maintain a state for a specific part of the application, allowing components to read from and update that state. The examples below will cover:

1. Initializing the state in a component.
2. Updating the state in a component.
3. Subscribing to state changes in a component.
4. Unsubscribing and cleanup.

Usage Documentation for AppBasicStateService

---

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 
    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()

cavebatsofware

class Weight

  def method_missing(method_id)
    return nil if self.class == Weight
    name = method_id.id2name
    result = nil
    if name =~ /^to_(\w+)s$/
      klass = eval $1.capitalize
      result = klass.from_ounces(self.to_ounces)