Building a Heritage Trees Registry with Velo

$w.onReady(function () {
    
  $w("#captcha").onVerified(() => {
      $w("#errorMessage").hide();
	  $w("#successMessage").hide();    
    $w("#submitButton").enable();
  })
  
  $w("#captcha").onError(() => {
    $w("#errorMessage").text = "The reCAPTCHA element lost connection with the CAPTCHA provider. Try again later.";
    $w("#errorMessage").show()
    .then(() => {
      $w("#errorMessage").hide("fade", {"delay": 10000});
    } );
  })

  $w("#captcha").onTimeout(() => {
    $w("#submitButton").disable();
  })
 
});

/**
    *	Adds an event handler that runs when the element is clicked.
    *	 @param {$w.MouseEvent} event
    */
    export function generateID_click(event) {
	  // This function was added from the Properties & Events panel. To learn more, visit http://wix.to/UcBnC-4
	  // Add your code for this event here: 
      let t = new Date().getTime();
      let numCode = t.toString();
      let thanaCode = $w('#thana').value;
      thanaCode = thanaCode.replace(/\s/g,'');
      thanaCode = thanaCode.slice(0,4);
      thanaCode = thanaCode.toUpperCase();
      let personCode = $w('#contributorName').value;
      personCode = personCode.replace(/\s/g,'');
      personCode = personCode.slice(0,3);
      personCode = personCode.toUpperCase();
      let customID = numCode.concat(personCode);
      let gencode = thanaCode.concat(customID);
      if($w('#thana').valid && $w('#contributorName').valid){
         $w('#dataset1').setFieldValue('title', gencode);
      }   
    }

import wixData from 'wix-data';

$w.onReady(function () {
	wixData.query('DehradunPoliceStations')
	.find()
	.then(res => {
		let options = [{"value":'','label':'All Thanas'}];
		options.push(...res.items.map(DehradunPoliceStations => {
			return {'value': DehradunPoliceStations.title,'label' : DehradunPoliceStations.title};
		}));
		$w('#iThana').options = options;
	})
});

let lastFilterTitle;
let lastFilterThana;
let lastFilterTree;

let debounceTimer;
export function iTreeID_keyPress(event) {
	// This function was added from the Properties & Events panel. To learn more, visit http://wix.to/UcBnC-4
	// Add your code for this event here: 
	if (debounceTimer) {
		clearTimeout(debounceTimer);
		debounceTimer = undefined;
	}
	debounceTimer = setTimeout(() => {
		filter($w('#iTreeID').value, lastFilterThana, lastFilterTree);
	}, 200);
}


function filter(title, thana, tree) {
	if (lastFilterTitle !== title || lastFilterThana !== thana || lastFilterTree !== tree) {
		let newFilter = wixData.filter();
		if (title) 
			newFilter = newFilter.contains('title', title);
		if (thana)
			newFilter = newFilter.eq('thana', thana);
		if (tree)
			newFilter = newFilter.contains('treeName', tree);
		newFilter = newFilter.eq('status',1);
		$w('#dataset1').setFilter(newFilter);
		lastFilterTitle = title;
		lastFilterThana = thana;
		lastFilterTree = tree;
	}
}


/**
*	Adds an event handler that runs when an input element's value
 is changed.
*	 @param {$w.Event} event
*/
export function iThana_change(event) {
	// This function was added from the Properties & Events panel. To learn more, visit http://wix.to/UcBnC-4
	// Add your code for this event here: 
	filter(lastFilterTitle, $w('#iThana').value, lastFilterTree);
}



/**
*	Adds an event handler that runs when the cursor is inside the
 input element and a key is pressed.
*	 @param {$w.KeyboardEvent} event
*/
export function iTree_keyPress(event) {
	// This function was added from the Properties & Events panel. To learn more, visit http://wix.to/UcBnC-4
	// Add your code for this event here: 
	if (debounceTimer) {
		clearTimeout(debounceTimer);
		debounceTimer = undefined;
	}
	debounceTimer = setTimeout(() => {
		filter(lastFilterTitle, lastFilterThana, $w('#iTree').value);
	}, 200);
}

/**
 *	Adds an event handler that runs when the element is clicked.
 *	 @param {$w.MouseEvent} event
 */
export function clearFilters_click(event) {
	// This function was added from the Properties & Events panel. To learn more, visit http://wix.to/UcBnC-4
	// Add your code for this event here: 

		$w("#iTreeID").value= null;
		$w("#iTreeID").resetValidityIndication();

		$w("#iTree").value= null;
		$w("#iTree").resetValidityIndication();

		$w("#iThana").value = '';
		$w("#iThana").resetValidityIndication();

		if (debounceTimer) {
		clearTimeout(debounceTimer);
		debounceTimer = undefined;
	}
	debounceTimer = setTimeout(() => {
		filter($w('#iTreeID').value, $w('#iThana').value, $w('#iTree').value);
	}, 200);
}

import wixData from 'wix-data';

$w.onReady(function () {
	// Write your JavaScript here

	// To select an element by ID use: $w("#elementID")
    const today = new Date();
 	const options = {
        //weekday: "long",
        //day: "numeric",
        month: "long",
        year: "numeric"
    };
    $w("#month").text = today.toLocaleDateString('en-US', options);

	let currentMonth = new Date().getMonth();
	let nextMonth = currentMonth + 1;
	let currentYear = new Date().getFullYear();
	console.log(currentMonth);
	console.log(nextMonth);
	console.log(currentYear);
		
  // set the table columns
  $w("#table1").columns = [
    // the column that shows the document name
    {
      "id": "col1",
      "dataPath": "title", // matches field key from collection
      "label": "Name",
      "width": 130,
      "visible": true,
      "type": "string",
    },
    // the column that shows the document description
    {
      "id": "col2",
      "dataPath": "count", // matches field key from collection
      "label": "Contributions",
      "width": 130,
      "visible": true,
      "type": "string",
    }
  ];

   const beginDate = new Date(currentYear, currentMonth, 1, 0, 0, 0) // first day of month
   const endDate = new Date(currentYear, nextMonth, 1, 0, 0, 0) // first day of next month
	let filter = wixData.filter().gt("_createdDate",beginDate).lt("_createdDate",endDate);
	// Click "Preview" to run your code
	wixData.aggregate("ContributionTable")
	.filter(filter)
	.group("contributionBy","title")
	.count()
	.run()
	.then( (results) => {
		let items = results.items;
		items = items.reverse();
		console.log(results.items);
		let ItemsTable;
		if(items.length >= 3)
		ItemsTable = [items[0],items[1],items[2]];
		if(items.length === 2)
		ItemsTable = [items[0],items[1]];
		if(items.length === 1)
		ItemsTable = [items[0]];
    if(items.length === 0)
    ItemsTable = [];
		$w('#table1').rows = ItemsTable;
	});

});