Skip to content

Instantly share code, notes, and snippets.

@donovan-duplessis
donovan-duplessis / README.md
Created October 13, 2022 11:38
Melville Douglas Valuations Import

Non financial data

  1. Create Tau_contract_fee_updated TABLE

    -- DROP TABLE [HiSight_LZ].[LZ].[Tau_contract_fee_updated] -- GO SELECT * INTO [HiSight_LZ].[LZ].[Tau_contract_fee_updated] FROM [HiSight_LZ].[LZ].[Tau_contract_fee] GO

Assumptions and Considerations:

  1. Identity Access Management via Secure Services

    This section handles the following items on the website:

    • Authentication (login, registrations, session management and access rights)
    • Password management (forgot password, change password, OTP)

    The assumption is that this will be implemented. Things to consider and finalise:

def status
if new_record?
'Partially Created'
else
if login.new
if !login.active
'Pending HI activation'
end
else
if login.awaiting_confirmation
[
["+", "avatar_url", "/images/no-image.jpg"],
["+", "birth_date", "1982-02-27"],
["+", "country", {
"name": "Albania"
}],
["+", "created_at", "2015-11-26T10:53:46.059+02:00"],
["+", "email", "test@west.com"],
["+", "fax_number", "013"],
["+", "firstname", "Test"],
[
[
"~",
"brokerage.active",
false,
true
],
[
"~",
"brokerage.active_comment",
=begin
* Name: setting.rb
* Description: Generic Settings Model (Rails 4.1+)
* Version: 0.3
* Author: Donovan du Plessis <donovan@binarytrooper.com>
* Date: 2014/07/31
=end
change_log = """
2014-07-23 DdP Initial version
datatables instantiation options:
save/load in localstorage
bStateSave: true
fnStateSave: (oSettings, oData) ->
localStorage.setItem window.location.hostname.replace(/\./g, '_') + "_DataTables_" + window.location.pathname, JSON.stringify(oData)
fnStateLoad: (oSettings) ->
JSON.parse localStorage.getItem(window.location.hostname.replace(/\./g, '_') + "_DataTables_" + window.location.pathname)
class Division < ActiveRecord::Base
def products_excel
query = <<-EOS
SELECT firstname, surname, mobile,
IF(subscribe_email = 1, 'Yes', 'No') as subscribe_email,
IF(subscribe_sms = 1, 'Yes', 'No') as subscribe_sms,
doppelbock_products.email,
DATE_FORMAT(doppelbock_products.created_at, '%Y-%m-%d %H:%i:%s') as created_at,
doppelbock_locations.name AS location,
# Report Transform Configuration File - Multi Manager TransactionFiles
# Import mappings from specified file
[include]
file = /admin/etc/rt_multimanager_mappingstab
# Format time from hh:mm to hhmm00
[format_valtime]
regex = s/^(\d\d):(\d\d)$/${1}${2}00/
format = "%06d"
# File: deploy.rb
# Author: Donovan du Plessis
# Description: Capistrano Deployment Automation
# Last Modified: May 17, 2012
default_run_options[:pty] = true
set :application, "pwnurl"
set :repository, "git@github.com:SDC2012/intranet.git"