Skip to content

Instantly share code, notes, and snippets.

View slav123's full-sized avatar

Slawomir Jasinski slav123

16 followers · 1 following
View GitHub Profile
@slav123
slav123 / trigger.sql
Created November 3, 2021 09:31
trigger mysql to update items
DELIMITER $$
CREATE TRIGGER on_items_update
AFTER INSERT
ON order_items FOR EACH ROW
BEGIN
UPDATE orders SET total_photos=total_photos+1 WHERE id=new.order_id;
END$$
DELIMITER ;
@slav123
slav123 / post.js
Created September 27, 2021 07:50
post fetch query
postData('notes/update_note_date', {
id: element.parentElement.getAttribute("data-id"),
lead_id: element.parentElement.getAttribute('data-lead'),
note_type: element.parentElement.getAttribute('data-type'),
field: element.parentElement.getAttribute('data-field'),
value: element.value
}).then(data => {
console.log(data); // JSON data parsed by `data.json()` call
});
@slav123
slav123 / index.html
Last active September 24, 2021 09:57
inline date picker with HTML5
<!DOCTYPE html>
<html>
<head>
<title>Sandbox</title>
<meta charset="UTF-8" />
</head>
<body>
<div class="editable date" data-id="6">2021-09-23</div>
<div class="editable date" data-id="1">2011-08-11</div>
@slav123
slav123 / MY_Upload.php
Created September 23, 2021 08:28
Extended / Overloaded CI-Upload Class to handle Flash-Form-Uploaded Images via Application/octet-stream
<?php
/**
* Extended / Overloaded CI-Upload Class to handle Flash-Form-Uploaded Images via Application/octet-stream
*
*/
if (!defined('BASEPATH')) exit('No direct script access allowed');
/**
* Extends the CodeIgniter Upload-Class
*/
@slav123
slav123 / post.php
Last active September 17, 2021 10:30
PHP POST request with file_get_contents
<?php
$data = [];
// www-form-urlencoded
$opts = array('http' => array('method' => 'POST',
'header' => 'Content-Type: application/x-www-form-urlencoded',
'content' => http_build_query($data)
));
// json
@slav123
slav123 / autosave.js
Created September 8, 2021 14:08
simple javascript autosave
var timeoutId;
$(document).on('keypress', '#overview', function () {
if (timeoutId) clearTimeout(timeoutId);
let brief = $(this).val()
let steps_id = $(this).data('id')
timeoutId = setTimeout(function () {
$.ajax({
@slav123
slav123 / functions.php
Created September 10, 2013 11:21
downgrade jQuery on wordpress
<?php
// Downgrade to jQuery given version
function downgrade_jquery() {
global $wp_scripts;
// We want to use version 1.8.3 of jQuery, but it may break something in the admin so we only load it on the actual site.
if ( !is_admin() ) :
wp_deregister_script('jquery');
wp_register_script('jquery', '//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js', false, '1.8.2');
endif;
@slav123
slav123 / exif.go
Last active July 28, 2021 08:18
https://github.com/dsoprea/go-exif/issues/50
package main
import (
exif "github.com/dsoprea/go-exif/v3"
exifcommon "github.com/dsoprea/go-exif/v3/common"
jpeg "github.com/dsoprea/go-jpeg-image-structure/v2"
)
func setExifTag(rootIB *exif.IfdBuilder, ifdPath, tagName, tagValue string) error {
@slav123
slav123 / Dockerfile
Created July 14, 2021 07:20
full docker file with working CGO bindings and option to update debian image
FROM golang:latest AS base
RUN apt-get update && \
apt-get -y --no-install-recommends install software-properties-common && \
add-apt-repository "deb http://httpredir.debian.org/debian bullseye main" && \
apt-get update && \
apt-get -qq install -y libvips-dev && rm -rf /var/lib/apt/lists/*
WORKDIR /app
@slav123
slav123 / pm.js
Created July 13, 2021 09:37
datatables defs
"columnDefs": [
{"className": 'nowrap', 'targets': [0, 1, 4]},
{"className": 'text-right', 'targets': [10, 11, 13, 14, 15, 16, 21, 23]},
// {"render": $.fn.dataTable.render.moment( 'Do MMM YYYY' , 'YYYY-MM-DD' ), 'targets' : [8]}
],