Skip to content

Instantly share code, notes, and snippets.

View slav123's full-sized avatar

Slawomir Jasinski slav123

View GitHub Profile
@slav123
slav123 / jsonPost.js
Created February 9, 2021 17:19
json ajax form
jsonData = $('#formularz').serializeArray().map(function(x){this[x.name] = x.value; return this;}.bind({}))[0]
$.ajax({
type: "POST",
url: "",
data: JSON.stringify(jsonData),
success: function(data){
if (data.error == "") {
$('#formWrapper').html("<p>Dziekujemy za wysłanie wiadomości</p>");
} else {
@slav123
slav123 / array_insert.php
Created January 26, 2021 13:03
array_insert
<?php
function array_insert (&$array, $position, $insert_array) {
$first_array = array_splice ($array, 0, $position);
$array = array_merge ($first_array, $insert_array, $array);
}
@slav123
slav123 / water-level.ino
Created January 8, 2021 15:20
Arduino Water Level sensor with battery check
#include <ESP8266WiFi.h>
#include <ESP8266HTTPClient.h>
#include <ArduinoJson.h>
#define trigPin 14 // d5
#define echoPin 12 // d6
#define SERVER_IP "10.0.0.55"
const int analogInPin = A0;
@slav123
slav123 / group.php
Created November 5, 2020 07:47
group select - CodeIgniter 4 builder
<?php
$builder->select('id, email, name, phone, created_at, status');
$groupSelect = '(SELECT GROUP_CONCAT(ag.name) FROM auth_groups_users gu LEFT JOIN auth_groups ag ON ag.id=gu.group_id WHERE gu.user_id=users.id) AS groups';
$builder->select($groupSelect);
$builder->where('deleted_at', NULL);
$builder->limit($limit, $offset);
// get select, for calc filtered
$compiledSelect = $builder->getCompiledSelect(FALSE);
$compiledSelect = str_replace($groupSelect, '', $compiledSelect);
@slav123
slav123 / groups.sql
Created July 17, 2020 08:56
Single query to pull users with group names.
SELECT id, email, (SELECT GROUP_CONCAT(ag.name) FROM auth_groups_users gu LEFT JOIN auth_groups ag ON ag.id=gu.group_id WHERE gu.user_id=u.id ) FROM users u
@slav123
slav123 / material.xml
Created July 7, 2020 13:00
Material and power speed ratio for laser engraver / cutter
<?xml version="1.0" standalone="yes"?>
<MaterialDB xmlns="http://tempuri.org/MaterialDB.xsd">
<Materials>
<id>3d3e2cff-f117-4df7-a7c3-09e4fd62ce44</id>
<Visible>true</Visible>
<Model>Ortur LU7W (1.5W)</Model>
<Material>Plywood</Material>
<Thickness>-</Thickness>
<Action>Engrave</Action>
<Power>100</Power>
@slav123
slav123 / distance.sql
Created June 9, 2020 13:02
distance-km-sql.sql
(6371 * acos ( cos ( radians(' . $address['latitude'] . ') ) * cos( radians( clients.latitude ) ) * cos( radians( clients.longitude ) - radians(' . $address['longitude'] . ') ) + sin ( radians(' . $address['latitude'] . ') ) * sin( radians( clients.latitude ) ) ) ) AS distance_adv'
DELIMITER //
CREATE FUNCTION `GCDistDeg`(
_lat1 DOUBLE,
_lon1 DOUBLE,
_lat2 DOUBLE,
_lon2 DOUBLE
) RETURNS double
DETERMINISTIC
SQL SECURITY INVOKER
COMMENT 'Degrees in, Degrees out. For conversion: 69.172 mi/deg or 111.325 km/deg'
@slav123
slav123 / threeSum.php
Created April 26, 2020 08:16
threeSum optimised
<?php
class Solution {
/**
* @param Integer[] $nums
* @return Integer[][]
*/
function threeSum($nums) {
$results = [];
$max = count($nums);
@slav123
slav123 / threeSum.php
Last active April 26, 2020 08:15
threes sum brutforce
<?php
function threeSum($nums) {
$results = [];
$max=count($nums);
sort($nums);
print_r($nums);
for ($a = 0;$a < $max;$a++) {