Skip to content

Instantly share code, notes, and snippets.

******NOTE: Keep in mind this was a raw query but it should at least give a pretty accurate picture.
****** The numbers are in integers, so the total you see in #1 is $17,740,905
1.
Paid Orders from '2020-06-01 00:00:00' till '2021-06-01 00:00:00'
It was 121786 orders
TOTAL: 17740905
by payment_method:
# The actual string of the start date and end date in the two lines below need to be adjusted to reflect the date range of the inquiries you want to update.
# This script is safe to run even on inquiries that successfully sync'd to Salesforce. Therefore, you dont need to find the exact Inquiries that didnt sync,
# you can just run this for the entire day where the problem occured.
start_date = Time.strptime('06-10-2020', '%m-%d-%Y').beginning_of_day.in_time_zone
end_date = Time.strptime('06-10-2020', '%m-%d-%Y').end_of_day.in_time_zone
errors = []
Inquiry.where('created_at >= ? AND created_at < ?', start_date, end_date).each do |i|
{"public_id"=>["portraits_eg2ut5_rxijma"],
"version"=>["1585070106"],
"signature"=>["f5e8896f0f8a56414e070fd5fcc720fa96c835e4"],
"width"=>["2835"],
"height"=>["2835"],
"format"=>["jpg"],
"resource_type"=>["image"],
"created_at"=>["2020-03-24T17:15:06Z"],
"pages"=>["1"],
"bytes"=>["701652"],
State,ZipCode,TaxRegionName,StateRate,EstimatedCombinedRate,EstimatedCountyRate,EstimatedCityRate,EstimatedSpecialRate,RiskLevel
CA,90001,"LOS ANGELES COUNTY",0.060000,0.095000,0.002500,0,0.032500,2
CA,90002,"LOS ANGELES CO",0.060000,0.095000,0.002500,0.000000,0.032500,2
CA,90003,"LOS ANGELES CO",0.060000,0.095000,0.002500,0.000000,0.032500,1
CA,90004,"LOS ANGELES CO",0.060000,0.095000,0.002500,0.000000,0.032500,2
CA,90005,"LOS ANGELES CO",0.060000,0.095000,0.002500,0.000000,0.032500,2
CA,90006,"LOS ANGELES CO",0.060000,0.095000,0.002500,0.000000,0.032500,2
CA,90007,"LOS ANGELES CO",0.060000,0.095000,0.002500,0.000000,0.032500,2
CA,90008,"LOS ANGELES CO",0.060000,0.095000,0.002500,0.000000,0.032500,5
CA,90009,"LOS ANGELES CO",0.060000,0.095000,0.002500,0.000000,0.032500,1
#<ArtUploadStore id: 1255, page_id: 34697, default_medium_id: nil, display_artist_names: false, default_style_finish: nil, frame_insets: {}, watermark_avail: false, watermark_picture: nil, canvas_overlay_avail: false, canvas_overlay_picture: nil, personalization: {"shopping_tabs"=>{"tab1_text"=>"1 Medium", "tab1_tooltip"=>"first, choose a medium", "tab2_text"=>"2 Size", "tab2_tooltip"=>"then, choose a size", "tab3_content"=>{"canvas_options_label_text"=>"Canvas Options", "color_label_text"=>"Color", "finishing_label_text"=>"Finishing", "additional_options_label_text"=>"Additional Options"}, "tab3_text"=>"3 Styles", "tab3_tooltip"=>"then, choose your styles", "tab4_text"=>"4 Frame", "tab4_tooltip"=>"choose a frame", "tab5_content"=>{"summary_label_text"=>"Summary", "add_a_message_label_text"=>"Add a Message"}, "tab5_text"=>"<i class=\"fa fa-shopping-cart\"></i>", "tab5_tooltip"=>"review and confirm"}}, copyright_text: "", copyright_tooltip: "", display_cropper: true, display_crop_teaser_pricing: false, crop_si
{
"11722" => {
"8x10" => "149.88",
"8x12" => "129.06",
"8x24" => "155.16",
"8x40" => "165.59",
"10x10" => "149.9",
"11x14" => "149.9",
"12x12" => "167.27",
"12x16" => "171.75",
<%= cl_image_upload_tag(:picture,
:html => { :multiple => true },
:image_metadata => true,
:exif => true,
:flags => "keep_iptc",
:use_filename => true,
:eager_async => true,
:eager => [
{ :format => 'jpg',
// Cloudinary jQuery integration library uses jQuery File Upload widget
// (see http://blueimp.github.io/jQuery-File-Upload/).
// Any file input field with cloudinary-fileupload class is automatically
// wrapped using the File Upload widget and configured for Cloudinary uploads.
// You can further customize the configuration using .fileupload method
// as we do below.
function uploadToCloudinary(form) {
var uploadButton = $(form).find('.cloudinary-fileupload'),
uploadLimit = 50000000,
class OrderAssetsZipDownloadCreator
def self.build(order_id, force = false)
@order = Order.find(order_id)
@force = force
unless @order.download_zip_url.present? #prevent duplicate images from being added to zip.
reupload_assets_with_tag
#create_zip
end
class OrderAssetsZipDownloadCreator
def self.build(order_id, force = false)
@order = Order.find(order_id)
@force = force
unless @order.download_zip_url.present? #prevent duplicate images from being added to zip.
reupload_assets_with_tag
#create_zip
end