ruby on rails - Is this an efficient way of producing sales reporting / analytics? -

-

i have app receive & ingest daily sales reports multiple sources. structured differently store down postgres db in separate tables.

i'm doing iterate on last 30 days sales 1 report source , seems work quite nicely. concern how efficient & scaleable when add additional report sources way have structured means i'd have add , repeat large amounts of code each new source.

<% = date.today - 30 %> #30 days ago <% = date.today %> #today <% step_date = %>   <% source_one_chart_data = [] %> #initialise empty array later pass js chart library  <% begin %>     <% count = @product.sales_source_one.total.where(:report_date => step_date).count %> #check if there sales product on current step date         <% if count != 0 %>             <% sale = @product.sum_total_net_by_day(step_date) %>             <% source_one_chart_data.push(sale.to_s) %> #push sales total array if sales exist on date         <% else %>             <% source_one_chart_data.push("0") %> #otherwise push 0 array 30 days map value         <% end %>      <% step_date += 1.day %> #increase step_date 1 on each iteration of loop <% end while step_date <= %> #stop loop when reach date

can offer guidance on how efficiently bring in additional sales sources without having repeat code? also, if change step day week/month/year , have calculate sales accordingly; if sales source reported daily , step week sum values occur in step week.

why have of code in view? should move of model / controller.

def process_chart_data   = 1.month.ago.to_date   = date.today   step_date =   chart_data = []    while step_date <=     sales_total = sales_source_one.total.where(report_date: step_date).count     if sales_total.zero?       chart_data.push(0)     else       sale = sum_total_net_by_day(step_date)       chart_data.push(sale.to_s)     end     step_date += 1   end    return chart_data end

the above refactored further, if place in product model in controller can do:

@product = product.find(params[:id]) # or whatever @chart_data = @product.process_chart_data

then in view can use @chart_data.

moving code method allows update quicker, lets want user control how far records retrieved:

def process_chart_data(start_date)   = start_date   ... end

in controller:

@product = product.find(params[:id]) @chart_data = @product.process_chart_data(params[:start_date])

Popular posts from this blog

How to calculate SNR of signals in MATLAB? -

-
i've encountered simple, yet fundamental problem on calculating snr: there several signals : s1 = original , pure clean signal without noise. n1 = white gaussian noise going added s1. s2 = s1 + n1 (the noisy signal before performing noise-reduction algorithm) s3 = noise-reduced signal (after performing noise reduction algorithm) n2 = s3 - s1 (the amount of noise after performing noise-reduction algorithm) now want compare snr before , after performing noise-reduction algorithm. which signals should consider snr_before!? s1/n1 or s2/n1 ? which signals should consider snr_after!? s3/n1 or s3/n2 ? which commands or functions should use in matlab in order compute snr_before , snr_after? thanks billion putting time on helping me. what know calculating snr before : snrbeforenoise = mean( signal .^ 2 ) / mean( noise .^ 2 ); and snr after : residual_noise = signal - noise_reduced_signal; snr_after = mean( signal .^ 2 ) / mean( residual_noise .^ 2...
Read more

c# - Attempting to upload to FTP: System.Net.WebException: System error -

-
i have api takes in xml , uploads files based on information in xml. uploads on schedule (also xml), , have tested surrounding , know works. i getting error 40% of time on first file attempt upload in each time cycle (time cycle = 45 minutes files, 30 minutes others). here code upload: try { loggerftp.log("uploading file: " + filename, false); // create request. ftpwebrequest request = (ftpwebrequest)webrequest.create(appsettingsftp.ftpurl + @"/" + filename); request.method = webrequestmethods.ftp.uploadfile; request.timeout = 6000000; //set 100 minutes //request.timeout = -1; //set infinite // add login credentials. request.credentials = new networkcredential(appsettingsftp.ftplogin, appsettingsftp.ftppassword); // grab file contents. streamreader sourcestream = new streamreader(appsettingsftp.uploadfiledirectory + filename); byte[] filecontents = encoding.utf8.getbytes(sourcestream.readtoend()); sourcest...
Read more

ios - UISlider customization: how to properly add shadow to custom knob image -

-
Image
i need place custom knob image shadow uislider. far have image of 38x38, of there region defines shadow of knob. now while using image, when slide knob extreme ends actual knob not able cover end points, hence end points visible under transparent region of knob image this code using customize uislider uiimage *slidebtimg = [uiimage imagenamed:sliderknobimg]; [self.ratingslider setthumbimage:slidebtimg forstate:uicontrolstatenormal]; [self.ratingslider setthumbimage:slidebtimg forstate:uicontrolstatehighlighted]; how can implement custom knob shadow beneath it, covering end points?? look inside uislider.h , there methods let customize slider knob , track needed. (ios 2.0 , above) // lets subclass lay out track , thumb needed - (cgrect)minimumvalueimagerectforbounds:(cgrect)bounds; - (cgrect)maximumvalueimagerectforbounds:(cgrect)bounds; - (cgrect)trackrectforbounds:(cgrect)bounds; - (cgrect)thumbrectforbounds:(cgrect)bounds trackrect:(cgrect)rect value:...
Read more