MauricioMoraes

## print_element.html
<html>
<body>
<div id='print-wrapper'>

  <h1>CONTENT TO PRINT</h1>
  <p>CONTENT TO PRINT</p>
  <p>CONTENT TO PRINT</p>
  <p>CONTENT TO PRINT</p>
  <p>CONTENT TO PRINT</p>
  <p>CONTENT TO PRINT</p>

## print_element.html


<div id='print-wrapper'>

  CONTENT TO PRINT

</div>

<button id="print">PRINT</button>

## access_postgresql_with_docker.md

      
              1 file
            
          
              29 forks
            
          
              20 comments
            
          
              105 stars
            
          
                MauricioMoraes
                / access_postgresql_with_docker.md
            
            
              Last active
              May 2, 2024 10:21
            
              
                Allow Docker Container Access to Host's Postgres Database on linux (ubuntu)
              
          
    You have to do 2 things in order to allow your container to access your host's postgresql database

Make your postgresql listen to an external ip address
Let this client ip  (your docker container) access your postgresql database with a given user

Obs: By "Host" here I mean "the server where docker is running on".
Make your postgresql listen to an external ip address

Find your postgresql.conf (in case you don't know where it is)
$ sudo find / -type f -name postgresql.conf

  
## list-files-in-folder.js
function listFilesInFolder() {
  var folder = DocsList.getFolder("Maudesley Debates");
  var contents = folder.getFiles();

  var file;
  var data;

  var sheet = SpreadsheetApp.getActiveSheet();
  sheet.clear();


## delete_all_shapes_from_xls.vba
Option Explicit
Sub delete_all_shapes()
  Dim shape As Shape
  Dim worksheet As Worksheet

  Dim response As Integer
  response = MsgBox("This action will delete all pictures and shapes from your spreadsheet. Do you want to continue?", vbYesNo, "Delete all shapes from spreadsheet")

    If response = vbYes Then
      For Each worksheet In ThisWorkbook.Worksheets

## brazilian_phone_mask_with_area_code.js
// Using jquery.inputmask: https://github.com/RobinHerbots/jquery.inputmask
// For 8 digit phone fields, the mask is like this: (99) 9999-9999
// For 9 digit phone fields the mask is like this: (99) 99999-9999
function setupPhoneMaskOnField(selector){
  var inputElement = $(selector)

  setCorrectPhoneMask(inputElement);
  inputElement.on('input, keyup', function(){
    setCorrectPhoneMask(inputElement);
  });

## column_numbers_from_names.gs
// Pass the column headers range and names, and it will return an object with the relation between column names and column numbers
function getColumnNumbersForNames(sheetName, columnHeadersRangeA1Notation, columnNames){
  var thisSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = thisSpreadsheet.getSheetByName(sheetName);
  var columnHeadersRange = sheet.getRange(columnHeadersRangeA1Notation);
  var columnNamesOnSheet = flatten(columnHeadersRange.getValues());

  var columnNumbersForNames = {};
  for(var count = 0; count < columnNames.length; count++){
    var columnName = columnNames[count]

## one_level_flatten.js
// Takes and array of arrays matrix and return an array of elements.
function flatten(arrayOfArrays){
  return [].concat.apply([], arrayOfArrays);
}

## jquery_datatable_checkboxes_with_pagination.js
function setupDatatableCheckboxesWithPagination(tableSelector, attributeName) {
  var dataTableObject = $(tableSelector).dataTable();
  form = $(tableSelector).closest("form");

  $(form).submit(function(){
    insertHiddenInputsWithCheckboxesValues(tableSelector, attributeName);
    dataTableObject.fnFilter('');
  });
};

## gist:a8f4b4bd89b647b749f5
function findRowNumberForCellWithValue(targetValue, rangeA1Notation, sheet) {
  var range = sheet.getRange(rangeA1Notation);
  var values = range.getValues()

  for (var i = 0; i < values.length; i++) {
    if (values[i][0] == targetValue) {
      return i+1;
    }
  }
}
	<html>
	<body>
	<div id='print-wrapper'>

	<h1>CONTENT TO PRINT</h1>
	<p>CONTENT TO PRINT</p>
	<p>CONTENT TO PRINT</p>
	<p>CONTENT TO PRINT</p>
	<p>CONTENT TO PRINT</p>
	<p>CONTENT TO PRINT</p>


	<div id='print-wrapper'>

	CONTENT TO PRINT

	</div>

	<button id="print">PRINT</button>
	function listFilesInFolder() {
	var folder = DocsList.getFolder("Maudesley Debates");
	var contents = folder.getFiles();

	var file;
	var data;

	var sheet = SpreadsheetApp.getActiveSheet();
	sheet.clear();
	Option Explicit
	Sub delete_all_shapes()
	Dim shape As Shape
	Dim worksheet As Worksheet

	Dim response As Integer
	response = MsgBox("This action will delete all pictures and shapes from your spreadsheet. Do you want to continue?", vbYesNo, "Delete all shapes from spreadsheet")

	If response = vbYes Then
	For Each worksheet In ThisWorkbook.Worksheets
	// Using jquery.inputmask: https://github.com/RobinHerbots/jquery.inputmask
	// For 8 digit phone fields, the mask is like this: (99) 9999-9999
	// For 9 digit phone fields the mask is like this: (99) 99999-9999
	function setupPhoneMaskOnField(selector){
	var inputElement = $(selector)

	setCorrectPhoneMask(inputElement);
	inputElement.on('input, keyup', function(){
	setCorrectPhoneMask(inputElement);
	});
	// Pass the column headers range and names, and it will return an object with the relation between column names and column numbers
	function getColumnNumbersForNames(sheetName, columnHeadersRangeA1Notation, columnNames){
	var thisSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
	var sheet = thisSpreadsheet.getSheetByName(sheetName);
	var columnHeadersRange = sheet.getRange(columnHeadersRangeA1Notation);
	var columnNamesOnSheet = flatten(columnHeadersRange.getValues());

	var columnNumbersForNames = {};
	for(var count = 0; count < columnNames.length; count++){
	var columnName = columnNames[count]
	// Takes and array of arrays matrix and return an array of elements.
	function flatten(arrayOfArrays){
	return [].concat.apply([], arrayOfArrays);
	}
	function setupDatatableCheckboxesWithPagination(tableSelector, attributeName) {
	var dataTableObject = $(tableSelector).dataTable();
	form = $(tableSelector).closest("form");

	$(form).submit(function(){
	insertHiddenInputsWithCheckboxesValues(tableSelector, attributeName);
	dataTableObject.fnFilter('');
	});
	};
	function findRowNumberForCellWithValue(targetValue, rangeA1Notation, sheet) {
	var range = sheet.getRange(rangeA1Notation);
	var values = range.getValues()

	for (var i = 0; i < values.length; i++) {
	if (values[i][0] == targetValue) {
	return i+1;
	}
	}
	}