Home
StatisticsAndBillingRedirect
writeStats(Object spreadsheetData, Object sheet, Object type, Object from, Object to)
Writes statistics into the sheet
Arguments:
Name |
Type |
Description |
spreadsheetData |
Object |
data to write into sheet |
sheet |
Object |
sheet |
type |
Object |
switches writing stats to different modes |
from |
Object |
from which data to write stats |
to |
Object |
to which data to write stats |
setProp(Object prop, Object value)
Wrapper function.
Arguments:
Name |
Type |
Description |
prop |
Object |
|
value |
Object |
|
getClients()
Return Values:
Type |
Description |
Array<Object> |
array with name of all clients |
msToTime(Object duration)
Converts duration into time format string @duration miliseconds
Arguments:
Name |
Type |
Description |
duration |
Object |
|
Return Values:
Type |
Description |
string |
duration in format h:mm:ss:SSS |
getSortedObjProps(Object obj)
Creates array of object properties and sortes them
Arguments:
Name |
Type |
Description |
obj |
Object |
Object with string properties |
Return Values:
Type |
Description |
Array<Object> |
sorted array of obj properties |
getResource(Object resource)
Helper function to create main HTML. It can return html, javascript ot strings we need to include in our page.
Arguments:
Name |
Type |
Description |
resource |
Object |
string describing wanted resource |
Return Values:
Type |
Description |
Object |
requested resource or null if resource not found |
createPresentableHTML(Object content, Object sourceType, Object title)
Creates presentable HTML for a browser *cannot be run from library, becaouse of filename
Arguments:
Name |
Type |
Description |
content |
Object |
depends on a sourceType, if sourceType isn't string, it includes file with name == content |
sourceType |
Object |
is string indicating values 'string'/'file' for source type, takes file as default for any other value |
title |
Object |
title of a window |
Return Values:
Type |
Description |
string |
string of html |
doGet(Object e)
Serves HTML and checks user's permissionto view it
Arguments:
Name |
Type |
Description |
e |
Object |
url parameters setting this webapp's beahviour |
Return Values:
Type |
Description |
Object |
HTML page with javascript |
include(Object filename)
Generates HMTL from a file. *just shortcut a for a long command
Arguments:
Name |
Type |
Description |
filename |
Object |
name of file to be included |
Return Values:
Type |
Description |
string |
html |
writeToCell(Object sheet, Object row, Object col, Object value)
Writes data to specific cell
Arguments:
Name |
Type |
Description |
sheet |
Object |
where to write |
row |
Object |
where to write |
col |
Object |
where to write |
value |
Object |
value to write |
writeBilling(Object spreadsheetData, Object sheet, Object client)
Writes billing into the sheet
Arguments:
Name |
Type |
Description |
spreadsheetData |
Object |
data to write into sheet |
sheet |
Object |
sheet |
client |
Object |
name of client |
getProp(Object name)
Wrapper function.
Arguments:
Name |
Type |
Description |
name |
Object |
|
writeToCellSpec(Object sheet, Object row, Object col, Object obj)
Writes data to specific cell in a format specified in obj
Arguments:
Name |
Type |
Description |
sheet |
Object |
where to write |
row |
Object |
where to write |
col |
Object |
where to write |
obj |
Object |
obj with input data and its format (as {value: xx, color: xx, isDuration: xx, roundPrice: xx, oneDigitFormat: xx, twoDigitFormat: xx}) |
setRuntimeProperties(Object params)
Sets runtime properties
Arguments:
Name |
Type |
Description |
params |
Object |
object with properties to set |
createBilling(Object from, Object to, Object client)
Creates billing spreadsheet in user's google drive and generates data into it
Arguments:
Name |
Type |
Description |
from |
Object |
from which day bill is going to be created |
to |
Object |
to which day bill is going to be created |
client |
Object |
name of client |
Return Values:
Type |
Description |
string |
url of new spreadsheet |
processStatOrBillObj(Object formObject, Object isBill)
Parses and validates data from formObject, then it creates Billing or Statistics.
Arguments:
Name |
Type |
Description |
formObject |
Object |
Object received from client's browser form. |
isBill |
Object |
if true processes billing form, statistics otherwise |
Return Values:
Type |
Description |
Object |
object which designates success or failure (in a case form had nonvalid data) |
roundToTwo(Object num)
Rounds to two places, "banking format" @num number
Arguments:
Name |
Type |
Description |
num |
Object |
|
Return Values:
Type |
Description |
number |
number with two places decimal |
createStatistics(Object from, Object to)
Creates statistics spreadsheet in user's google drive and generates data into it
Arguments:
Name |
Type |
Description |
from |
Object |
from which day stats are going to be created |
to |
Object |
to which day stats are going to be created |
Return Values:
Type |
Description |
string |
url of new spreadsheet |
processForm(Object formObject)
Processes form and returns result.
Arguments:
Name |
Type |
Description |
formObject |
Object |
Form object |
Return Values:
Type |
Description |
Object |
object which designates success or failure |