Full page code (it’s quite extensive and not very elegant…):
import wixData from ‘wix-data’ ;
import { session } from ‘wix-storage’ ;
import wixWindow from ‘wix-window’ ;
$w ( "#minimumDisclaimer" ). hide ();
$w ( "#text69" ). hide ();
$w ( "#text67" ). hide ();
$w ( "#minimumDollar" ). hide ();
$w ( "#box6" ). hide ();
console . log ( "inside " )
wixData . query ( “Pricing” ) // <— here your database-name
. contains ( “title” , “Bedroom” )
. find ()
. then ( ( results ) => {
if ( results.items.length > 0 ) {
let priceLine = results.items [ 0 ]; //see item below
let steam = Number ( results.items [ 0 ]. steamClean )
let deep = Number ( results.items [ 0 ]. deepClean )
let sc = Number ( results.items [ 0 ]. scotchGuard )
session . setItem ( “BRsteam” , steam );
session . setItem ( “BRdeep” , deep );
session . setItem ( “BRsc” , sc );
} **else** {
// handle case where no matching items found
}
} )
. catch ( ( err ) => {
let errorMsg = err ;
console . log ( err )
} );
wixData . query ( “Pricing” ) // <— here your database-name
. contains ( “title” , “LR” )
. find ()
. then ( ( results ) => {
if ( results.items.length > 0 ) {
let priceLine = results.items [ 0 ]; //see item below
let steam = Number ( results.items [ 0 ]. steamClean )
let deep = Number ( results.items [ 0 ]. deepClean )
let sc = Number ( results.items [ 0 ]. scotchGuard )
session . setItem ( “LRsteam” , steam );
session . setItem ( “LRdeep” , deep );
session . setItem ( “LRsc” , sc );
} **else** {
// handle case where no matching items found
}
} )
. catch ( ( err ) => {
let errorMsg = err ;
} );
wixData . query ( “Pricing” ) // <— here your database-name
. contains ( “title” , “Stairs” )
. find ()
. then ( ( results ) => {
if ( results.items.length > 0 ) {
let priceLine = results.items [ 0 ]; //see item below
let steam = Number ( results.items [ 0 ]. steamClean )
let deep = Number ( results.items [ 0 ]. deepClean )
let sc = Number ( results.items [ 0 ]. scotchGuard )
session . setItem ( "STsteam" , steam );
session . setItem ( "STdeep" , deep );
session . setItem ( "STsc" , sc );
} **else** {
// handle case where no matching items found
}
} )
. catch ( ( err ) => {
let errorMsg = err ;
} );
wixData . query ( “Pricing” ) // <— here your database-name
. contains ( “title” , “Basement” )
. find ()
. then ( ( results ) => {
if ( results.items.length > 0 ) {
let priceLine = results.items [ 0 ]; //see item below
let steam = Number ( results.items [ 0 ]. steamClean )
let deep = Number ( results.items [ 0 ]. deepClean )
let sc = Number ( results.items [ 0 ]. scotchGuard )
//console.log(results)
session . setItem ( “BSsteam” , steam );
session . setItem ( “BSdeep” , deep );
session . setItem ( “BSsc” , sc );
} **else** {
// handle case where no matching items found
}
} )
. catch ( ( err ) => {
let errorMsg = err ;
} );
//////////////////////Mnagae Bedroom ////////////////////////
export function roomplus_click ( event ) {
let rooms = Number ($w ( “#rooms” ). value );
$w ( “#rooms” ). value = String ( rooms + 1 )
calculate ()
}
export function roomminus_click ( event ) {
// This function was added from the Properties & Events panel. To learn more, visit Velo: Working with the Properties & Events Panel | Help Center | Wix.com
// Add your code for this event here:
let rooms = Number ( $w ( “#rooms” ). value );
if ( rooms > 0 ) {
rooms –
$w ( “#rooms” ). value = String ( rooms )
let roomsDC = Number ($w ( “#roomsDC” ). value );
let roomsSC = Number ($w ( “#roomsSC” ). value );
if ( rooms<roomsDC ){
$w ( “#roomsDC” ). value = String ( rooms )
}
if ( rooms<roomsSC ){
$w ( “#roomsSC” ). value = String ( rooms )
}
calculate ()
}
}
export function DCplus_click ( event ) {
let rooms = Number ($w ( “#rooms” ). value );
let roomsDC = Number ($w ( “#roomsDC” ). value );
**if** ( roomsDC < rooms ) {
roomsDC ++
$w ( "#roomsDC" ). value = String ( roomsDC )
calculate ()}
}
export function DCminus_click ( event ) {
let roomsDC = Number ( $w ( “#roomsDC” ). value );
let roomsSC = Number ( $w ( “#roomsSC” ). value );
if ( roomsDC > 0 ) {
roomsDC –
$w ( “#roomsDC” ). value = String ( roomsDC )
let roomsSC = Number ($w ( “#roomsSC” ). value );
if ( roomsDC<roomsSC ){
$w ( “#roomsSC” ). value = String ( roomsDC )
}
calculate ()
}
}
export function SCplus_click ( event ) {
let roomsSC = Number ($w ( “#roomsSC” ). value );
let roomsDC = Number ($w ( “#roomsDC” ). value );
**if** ( roomsSC < roomsDC ) {
roomsSC ++
$w ( "#roomsSC" ). value = String ( roomsSC )
calculate ()}
}
export function SCminus_click ( event ) {
**let** roomsSC = Number ( $w ( "#roomsSC" ). value );
**if** ( roomsSC > 0 ) {
roomsSC --
$w ( "#roomsSC" ). value = String ( roomsSC )
calculate ()
}
}
/////////////////////Manage LR /////////////////////////////
export function LRroomplus_click ( event ) {
console . log ( “In LR Plus” )
let rooms = Number ($w ( “#LRrooms” ). value );
$w ( “#LRrooms” ). value = String ( rooms + 1 )
calculate ()
}
export function LRroomminus_click ( event ) {
// This function was added from the Properties & Events panel. To learn more, visit Velo: Working with the Properties & Events Panel | Help Center | Wix.com
// Add your code for this event here:
let rooms = Number ( $w ( “#LRrooms” ). value );
if ( rooms > 0 ) {
rooms –
$w ( “#LRrooms” ). value = String ( rooms )
let roomsDC = Number ($w ( “#LRroomsDC” ). value );
let roomsSC = Number ($w ( “#LRroomsSC” ). value );
if ( rooms<roomsDC ){
$w ( “#LRroomsDC” ). value = String ( rooms )
}
if ( rooms<roomsSC ){
$w ( “#LRroomsSC” ). value = String ( rooms )
}
calculate ()
}
}
export function LRDCplus_click ( event ) {
let rooms = Number ($w ( “#LRrooms” ). value );
let roomsDC = Number ($w ( “#LRroomsDC” ). value );
**if** ( roomsDC < rooms ) {
roomsDC ++
$w ( "#LRroomsDC" ). value = String ( roomsDC )
calculate ()}
}
export function LRDCminus_click ( event ) {
let roomsDC = Number ( $w ( “#LRroomsDC” ). value );
let roomsSC = Number ( $w ( “#LRroomsSC” ). value );
if ( roomsDC > 0 ) {
roomsDC –
$w ( “#LRroomsDC” ). value = String ( roomsDC )
let roomsSC = Number ($w ( “#LRroomsSC” ). value );
if ( roomsDC<roomsSC ){
$w ( “#LRroomsSC” ). value = String ( roomsDC )
}
calculate ()
}
}
export function LRSCplus_click ( event ) {
let roomsSC = Number ($w ( “#LRroomsSC” ). value );
let roomsDC = Number ($w ( “#LRroomsDC” ). value );
**if** ( roomsSC < roomsDC ) {
roomsSC ++
$w ( "#LRroomsSC" ). value = String ( roomsSC )
calculate ()}
}
export function LRSCminus_click ( event ) {
**let** roomsSC = Number ( $w ( "#LRroomsSC" ). value );
**if** ( roomsSC > 0 ) {
roomsSC --
$w ( "#LRroomsSC" ). value = String ( roomsSC )
calculate ()
}
}
/////////////////////Manage Stairs /////////////////////////////
export function STroomplus_click ( event ) {
console . log ( “In LR Plus” )
let rooms = Number ($w ( “#STrooms” ). value );
$w ( “#STrooms” ). value = String ( rooms + 1 )
calculate ()
}
export function STroomminus_click ( event ) {
// This function was added from the Properties & Events panel. To learn more, visit Velo: Working with the Properties & Events Panel | Help Center | Wix.com
// Add your code for this event here:
let rooms = Number ( $w ( “#STrooms” ). value );
if ( rooms > 0 ) {
rooms –
$w ( “#STrooms” ). value = String ( rooms )
let roomsDC = Number ($w ( “#STroomsDC” ). value );
let roomsSC = Number ($w ( “#STroomsSC” ). value );
if ( rooms<roomsDC ){
$w ( “#STroomsDC” ). value = String ( rooms )
}
if ( rooms<roomsSC ){
$w ( “#STroomsSC” ). value = String ( rooms )
}
calculate ()
}
}
export function STDCplus_click ( event ) {
let rooms = Number ($w ( “#STrooms” ). value );
let roomsDC = Number ($w ( “#STroomsDC” ). value );
**if** ( roomsDC < rooms ) {
roomsDC ++
$w ( "#STroomsDC" ). value = String ( roomsDC )
calculate ()}
}
export function STDCminus_click ( event ) {
let roomsDC = Number ( $w ( “#STroomsDC” ). value );
let roomsSC = Number ( $w ( “#STroomsSC” ). value );
if ( roomsDC > 0 ) {
roomsDC –
$w ( “#STroomsDC” ). value = String ( roomsDC )
let roomsSC = Number ($w ( “#STroomsSC” ). value );
if ( roomsDC<roomsSC ){
$w ( “#STroomsSC” ). value = String ( roomsDC )
}
calculate ()
}
}
export function STSCplus_click ( event ) {
let roomsSC = Number ($w ( “#STroomsSC” ). value );
let roomsDC = Number ($w ( “#STroomsDC” ). value );
**if** ( roomsSC < roomsDC ) {
roomsSC ++
$w ( "#STroomsSC" ). value = String ( roomsSC )
calculate ()}
}
export function STSCminus_click ( event ) {
**let** roomsSC = Number ( $w ( "#STroomsSC" ). value );
**if** ( roomsSC > 0 ) {
roomsSC --
$w ( "#STroomsSC" ). value = String ( roomsSC )
calculate ()
}
}
/////////////////////Manage Basement /////////////////////////////
export function BSroomplus_click ( event ) {
let rooms = Number ($w ( “#BSroom” ). value );
$w ( “#BSroom” ). value = String ( rooms + 1 )
calculate ()
}
export function BSroomminus_click ( event ) {
// This function was added from the Properties & Events panel. To learn more, visit Velo: Working with the Properties & Events Panel | Help Center | Wix.com
// Add your code for this event here:
let rooms = Number ( $w ( “#BSroom” ). value );
if ( rooms > 0 ) {
rooms –
$w ( “#BSroom” ). value = String ( rooms )
let roomsDC = Number ($w ( “#BSroomsDC” ). value );
let roomsSC = Number ($w ( “#BSroomsSC” ). value );
if ( rooms<roomsDC ){
$w ( “#BSroomsDC” ). value = String ( rooms )
}
if ( rooms<roomsSC ){
$w ( “#BSroomsSC” ). value = String ( rooms )
}
calculate ()
}
}
export function BSDCplus_click ( event ) {
let rooms = Number ($w ( “#BSroom” ). value );
let roomsDC = Number ($w ( “#BSroomsDC” ). value );
**if** ( roomsDC < rooms ) {
roomsDC ++
$w ( "#BSroomsDC" ). value = String ( roomsDC )
calculate ()}
}
export function BSDCminus_click ( event ) {
let roomsDC = Number ( $w ( “#BSroomsDC” ). value );
let roomsSC = Number ( $w ( “#BSroomsSC” ). value );
if ( roomsDC > 0 ) {
roomsDC –
$w ( “#BSroomsDC” ). value = String ( roomsDC )
let roomsSC = Number ($w ( “#BSroomsSC” ). value );
if ( roomsDC<roomsSC ){
$w ( “#BSroomsSC” ). value = String ( roomsDC )
}
calculate ()
}
}
export function BSSCplus_click ( event ) {
let roomsSC = Number ($w ( “#BSroomsSC” ). value );
let roomsDC = Number ($w ( “#BSroomsDC” ). value );
**if** ( roomsSC < roomsDC ) {
roomsSC ++
$w ( "#BSroomsSC" ). value = String ( roomsSC )
calculate ()}
}
export function BSSCminus_click ( event ) {
**let** roomsSC = Number ( $w ( "#BSroomsSC" ). value );
**if** ( roomsSC > 0 ) {
roomsSC --
$w ( "#BSroomsSC" ). value = String ( roomsSC )
calculate ()
}
}
export function calculate () {
// This function was added from the Properties & Events panel. To learn more, visit Velo: Working with the Properties & Events Panel | Help Center | Wix.com
let BRsteam = Number ( session . getItem ( “BRsteam” ));
let BRdeep = Number ( session . getItem ( “BRdeep” ));
let BRsc = Number ( session . getItem ( “BRsc” ));
**let** LRsteam = Number ( session . getItem ( "LRsteam" ));
**let** LRdeep = Number ( session . getItem ( "LRdeep" ));
**let** LRsc = Number ( session . getItem ( "LRsc" ));
**let** STsteam = Number ( session . getItem ( "STsteam" ));
**let** STdeep = Number ( session . getItem ( "STdeep" ));
**let** STsc = Number ( session . getItem ( "STsc" ));
**let** BSsteam = Number ( session . getItem ( "BSsteam" ));
**let** BSdeep = Number ( session . getItem ( "BSdeep" ));
**let** BSsc = Number ( session . getItem ( "BSsc" ));
**let** rooms = Number ($w ( "#rooms" ). value ) + Number($w ( "#LRrooms" ). value )+ Number($w ( "#STrooms" ). value ) + Number($w ( "#BSroom" ). value );
**let** roomsDC = Number ($w ( "#roomsDC" ). value ) + Number($w ( "#LRroomsDC" ). value ) + Number($w ( "#STroomsDC" ). value ) + Number($w ( "#BSroomsDC" ). value );
**let** roomsSC = Number ($w ( "#roomsSC" ). value ) + Number($w ( "#LRroomsSC" ). value ) + Number($w ( "#STroomsSC" ). value ) + Number($w ( "#BSroomsSC" ). value );
**let** steamtotal = Number ( Number ( $w ( "#rooms" ). value )* BRsteam ) + ( Number ($w ( "#LRrooms" ). value )* LRsteam ) + ( Number($w ( "#STrooms" ). value ) * STsteam ) + ( Number($w ( "#BSroom" ). value )* BSsteam ) ;
**let** DCtotal = Number ( Number ( $w ( "#roomsDC" ). value )* BRdeep ) + ( Number ($w ( "#LRroomsDC" ). value )* LRdeep ) + ( Number($w ( "#STroomsDC" ). value ) * STdeep ) + ( Number($w ( "#BSroomsDC" ). value )* BSdeep ) ;
**let** SCtotal = Number ( Number ( $w ( "#roomsSC" ). value )* BRsc ) + ( Number ($w ( "#LRroomsSC" ). value )* LRsc ) + ( Number($w ( "#STroomsSC" ). value ) * STsc ) + ( Number($w ( "#BSroomsSC" ). value )* BSsc ) ;
$w ( "#SCsub" ). text = String ( rooms );
$w ( "#SCsubDollar" ). text = String ( steamtotal );
$w ( "#DCsub" ). text = String ( roomsDC );
$w ( "#DCsubDollar" ). text = String ( DCtotal );
$w ( "#SGsub" ). text = String ( roomsSC );
$w ( "#SGsubDollar" ). text = String ( SCtotal );
**let** Subtotal = Number ( steamtotal+DCtotal+SCtotal )
**let** MinimumJob = Number ( 99 )
$w ( "#subtotal" ). text = String ( Subtotal )
$w ( "#minimumDollar" ). text = String ( MinimumJob );
**if** ( Subtotal < 99 ){
console . log ( "inside if Subtotal<69" )
$w ( "#minimumDisclaimer" ). hide ();
$w ( "#text69" ). hide ();
$w ( "#text67" ). hide ();
$w ( "#minimumDollar" ). hide ();
$w ( "#box6" ). hide ();
$w ( "#minimumDisclaimer" ). show ();
$w ( "#text69" ). show ();
$w ( "#text67" ). show ();
$w ( "#minimumDollar" ). show ();
$w ( "#box6" ). show ();
MinimumJob = ( 99 - Subtotal )
$w ( "#minimumDollar" ). text = String ( MinimumJob );}
**else** {
$w ( "#minimumDisclaimer" ). hide ();
$w ( "#text69" ). hide ();
$w ( "#text67" ). hide ();
$w ( "#minimumDollar" ). hide ();
$w ( "#box6" ). hide ();
MinimumJob = 0
}
**let** Quote = Number ( Subtotal + MinimumJob )
$w ( "#quote" ). text = String ( Quote );
}