all data is live and searchable
|
Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||
|
|
|
Yellow
|
|
|||||||||
|
|||||||||
|
|
|
Notes:
|
|
Scan 64 – Changes to Database Changes to Database: Add: - Invoice payments o Deposit number o Deposit line id o Deposit line items o Invoice payment id o Deposit line id - Payments – I need o Deposit # o Deposit line ide # o Date deposited - Payments o Invoice – main o Date – main o Deposit id – deposit line o Deposit # - main o Deposit date – main o Payment • Received • Marked • Used • Deposited Scan 108 – Changes to make to the database – Tech Tables Changes that Need to be Made to Database (Please see scan in photo gallery) Scan 137 & 138 – Decimals -May need an extra field to help with rounding error Multiplier default = 1 - Raw values - Formatted values - Rounding error values Attributes (real) standard – price is absolute – other measurements (user-maintained) Primary conversion Secondary conversion Two different things: 1. Decimals 2. Conversions Examples: (Please see scans in photo gallery) Scan 152 – Sorenson 360 Notes Sorenson 360 is a video CMS that ties into squeeze - OVP = online video platform - CMS = content management system - Password protection on video - Close captions – text file o Time codes in o Time code out o Verbage to display - Hybrid solution - Layout, color, settings, branding - Auto play vs. - Overlay – press play to begin vs. - None - Duration viewed – start & stop points - Creating the thumbnail image for the video at what frame or time - Em-bed codes need to check for device and players and be able to choose from assets on the fly - Eventually build the entire thing on a standard API and document the API for outside developers - H.264 standard streaming (supported by Apple) - WebM – made by google but not supported by IE and Apple Scan 154 & 153 – Cf Images Cf Image Stuff: - For older versions ImageCFC - 1 tag – 50 functions - Jpeg, gif, tiff, png, bmp - - Read gets into & puts into a var write - Do a read & action = “info” – this will give the height and width - Resize action = “resize” - Able to write without resaving it, write to Browser and it deletes the files after 5 minutes - Actions = “WriteToBrowser” - May be able to store images higher than the web root and then access them through the cfimage tag, that way they can’t be browsed to directly - Write to a temp folder if needed and then manually flash the temp folder ever five minutes. That keeps things clean. We may also be able to use a cryptic value to make each file unique per user. - Scripting Cf Image Continued: - 1st is ImageFile( ) – check the file - 2nd is ImageRead( ) – pull it into a var - 3rd is Image( ) – checks the var - ImageWrite( ) – write actions & conversions - ImageInfo( ) – var width, var height, var size - getFileInfo( ) – basic file info (not image specific) Resize: - ImageResize( ) – leave height as a blank and the image will be proportionate - ImageScaleToFit( ) - ImageRotate( ) - ImageFlip( ) - ImageCrop( ) - You can create images on the fly… this might be good for things like my cart favorites - ImageNew( ) - Able to create watermarks Scan 157 – Photo Upload History Table Need a quick photo upload history table: - Photo upload id – int key - Corp id – int(10)1 - Payee id – int(10)1 - App type id – int (10)1 - Main id – int(10)1 - History date time – date/time - The file size – decimal(12,2)0.00 - The compression size – decimal (10,2)0.00 - All uploads and resizes methods URL Vars: - URL.mode = all o Main o Lines o Pmts - URL from date - URL to date App Types: - 3 = invoice - 4 = PO - 5 = expense - 6 = BSI - 7 = stock/unit - 8 = cust - 11 = part Line Items: - FORM vendor name filter - FORM starting letter type - URL report format - URL payee - FORM report format Image number – small int(3)1 Image mode – var(10)Null |