Skip to content

Instantly share code, notes, and snippets.

Avatar

Jonathon Hill compwright

View GitHub Profile
View populate_merged_orders_table_20220423.log
Order Progress: 0.1%, 0 Failed, Time: 5s, Memory: 337.48MB
Order Progress: 0.1%, 0 Failed, Time: 6s, Memory: 337.43MB
Order Progress: 0.1%, 0 Failed, Time: 7s, Memory: 337.46MB
Order Progress: 0.1%, 0 Failed, Time: 8s, Memory: 337.77MB
Order Progress: 0.1%, 0 Failed, Time: 10s, Memory: 337.45MB
Order Progress: 0.1%, 0 Failed, Time: 11s, Memory: 337.45MB
Order Progress: 0.1%, 0 Failed, Time: 12s, Memory: 337.46MB
Order Progress: 0.1%, 0 Failed, Time: 13s, Memory: 337.48MB
Order Progress: 0.2%, 0 Failed, Time: 14s, Memory: 337.46MB
Order Progress: 0.2%, 0 Failed, Time: 15s, Memory: 337.51MB
View ServiceTitan-BusinessUnit-898-Client-6850.json
{
"id": 898,
"active": true,
"name": "HVAC Service",
"officialName": "4 Service Pros",
"email": "info@4servicepros.com",
"currency": "USD",
"phoneNumber": "(703) 444-0000",
"invoiceHeader": "4 Service Pros\n7000 Newington Rd. \nSuite E\nLorton, VA 22079\n703-444-0000\nwww.4servicepros.com\ninfo@4servicepros.com",
"invoiceMessage": "Thank you for your business and the opportunity to serve you. If you have any questions please call our office at 703-444-0000.",
View Page 1 URL (decoded).txt
https://office.toyoursuccess.com/crm/1321/history?filter=1&pg=2&q=&cat[]=accounting&cat[]=automation&cat[]=customer_relations&cat[]=graphics&cat[]=nuturing_dashboard&cat[]=order_generation&cat[]=order_processing&cat[]=purchasing&cat[]=sales&type[]=note&type[]=phone&type[]=voicemail&type[]=email&type[]=text&type[]=online&type[]=mail&type[]=drip+automation&type[]=other&type[]=in-person&type[]=task&type[]=file&assigned[]=6342&assigned[]=6347&assigned[]=6348&assigned[]=6350&assigned[]=6351&assigned[]=6352&assigned[]=6359&assigned[]=6360&assigned[]=6361&assigned[]=6362&assigned[]=6363&assigned[]=6364&assigned[]=6367&assigned[]=6368&assigned[]=6370&assigned[]=6371&assigned[]=6372&assigned[]=6373&assigned[]=6376&assigned[]=6377&assigned[]=6378&assigned[]=6383&assigned[]=6384&assigned[]=6392&assigned[]=6393&assigned[]=6395&assigned[]=6397&assigned[]=6399&assigned[]=6401&assigned[]=6402&assigned[]=6403&assigned[]=6404&assigned[]=6405&assigned[]=6406&assigned[]=6407&assigned[]=6408&assigned[]=6409&assigned[]=6410&assig
@compwright
compwright / H3194.md
Last active May 4, 2021
H.3194 of 2021 (Santee Cooper) version
View H3194.md

House Amendment 2a

Reps. LUCAS, G.M. SMITH, SIMRILL, RUTHERFORD, FINLAY and DAVIS propose the following Amendment No. to H. 3194 (COUNCIL\ZW\3194C005.CC.ZW21):

Reference is to Printer's Date 4/22/21-S. Amend the bill, as and if amended, by striking all after the enacting words and inserting: / Part 3 SECTION 1.Chapter 31, Title 58 is amended by adding: "Article 7 Retail Rates Process Section 58-31-710. The Public Service Authority, through its board of directors, shall adopt and publish pricing principles that respect and balance factors including, but not limited to, adherence to the authority's mission to be a low-cost provider, reliability, transparency, preservation of the authority's financial integrity, equity among customer classes, gradualism in adjustments to its pricing and rate schedule type, encouragement of efficiency and demand response, adequate notice to customers, and relief mechanisms for financially distressed customers. The authority shall also maintain and continue to offer rate sche

@compwright
compwright / production.log
Last active Apr 22, 2021
#1625 Migrate Business Unit Name
View production.log
[ec2-user@ip-172-31-29-39 ~]$ php /opt/toyoursuccess/app/scripts/fix/fix_automation_rules.php
Migrating servicetitan settings for Air Conditioning Services (ACS)
*** Rule #1 ***
*** Rule #2 ***
*** Rule #3 ***
*** Rule #4 ***
*** Exclusions ***
@compwright
compwright / bill.md
Created Apr 12, 2021
H3510 vs S201 of 2021
View bill.md

124th Session, 2021-2022

S. 201

STATUS INFORMATION

General Bill

Sponsors: Senator Hembree

@compwright
compwright / run.log
Last active Apr 1, 2021
tys_quickbooks_replay.log
View run.log
[ec2-user@ip-172-31-29-39 ~]$ php /opt/toyoursuccess/app/scripts/import/quickbooks.php --export-invoice=171102
############################
# Quickbooks export script #
############################
Exports accounting records to QuickBooks via the QuickBooks Web Connector
2021/04/01 10:01:57 [/opt/toyoursuccess/app/scripts/import/quickbooks.php] Exporting Invoice #171102
Script ran for [ec2-user@ip-172-31-29-39 ~]$ php /opt/toyoursuccess/app/scripts/import/quickbooks.php --export-invoice=171661
############################
@compwright
compwright / query.sql
Created Sep 18, 2020
Legacy membership migration query
View query.sql
SELECT
clients.id AS client_id,
clients.name AS client_name,
DATE(MAX(orders.time_stamp)) AS last_order,
clients.program AS program_id,
programs.name AS program_name,
membership_invoice.id AS last_invoice_id,
membership_invoice.total AS last_invoice_amount,
membership_invoice.payment_method AS last_invoice_payment_method,
membership_invoice.notes AS last_invoice_notes,
@compwright
compwright / fieldedge.json
Created May 8, 2020
FieldEdge field configuration
View fieldedge.json
[
{
"name": "quoteNumber",
"label": "Quote Number",
"type": "string",
"exampleValue": ""
},
{
"name": "quotedAmountSubtotal",
"label": "Quoted Amount Subtotal",
@compwright
compwright / template.html
Last active Apr 20, 2020
Email template with responsive text
View template.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0"/>
<title></title>
<style type="text/css">
* {
-webkit-text-size-adjust:100%;
-ms-text-size-adjust:100%;