snipt

Ctrl+h for KB shortcuts

SQL

Pensión alimenticia

1
2
3
4
5
6
7
8
# IMPORTANTE: Verificar primero que no exista ya el registro

INSERT into paysheet_company_element_concepts (element_id,company_id, `key`, label, name, sort, config, status, created_at, unique_id, concept,type, deleted_at, dynamic_columns,afterall_callback, apply)
SELECT
    id, 'id-de-la-compañia', `key`, 'PENSIÓN ALIMENTICIA', 'PENSIÓN ALIMENTICIA', 1500, '{}', 1, NOW(),  RIGHT(MD5(CONCAT(unique_id, "-id-de-la-compañia")), 25), 'pension_alimenticia', type, NULL, COLUMN_CREATE('default', 1, 'discountForPeriods', 0, 'isFix', 1), NULL, 1
FROM paysheet_elements
WHERE unique_id = 'd_alimienticia'
;
https://snippets.siftie.com/embed/9e77180e42a141aacacc8caaedbf32b1/
/raw/9e77180e42a141aacacc8caaedbf32b1/
9e77180e42a141aacacc8caaedbf32b1
sql
SQL
8
2019-02-18T14:37:03
True
False
False
Feb 12, 2019 at 01:28 PM
/api/public/snipt/148256/
pension-alimenticia
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a> <a href="#L-6">6</a> <a href="#L-7">7</a> <a href="#L-8">8</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="o">#</span> <span class="n">IMPORTANTE</span><span class="p">:</span> <span class="n">Verificar</span> <span class="n">primero</span> <span class="n">que</span> <span class="k">no</span> <span class="n">exista</span> <span class="n">ya</span> <span class="n">el</span> <span class="n">registro</span> </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a><span class="k">INSERT</span> <span class="k">into</span> <span class="n">paysheet_company_element_concepts</span> <span class="p">(</span><span class="n">element_id</span><span class="p">,</span><span class="n">company_id</span><span class="p">,</span> <span class="o">`</span><span class="k">key</span><span class="o">`</span><span class="p">,</span> <span class="n">label</span><span class="p">,</span> <span class="n">name</span><span class="p">,</span> <span class="n">sort</span><span class="p">,</span> <span class="n">config</span><span class="p">,</span> <span class="n">status</span><span class="p">,</span> <span class="n">created_at</span><span class="p">,</span> <span class="n">unique_id</span><span class="p">,</span> <span class="n">concept</span><span class="p">,</span><span class="k">type</span><span class="p">,</span> <span class="n">deleted_at</span><span class="p">,</span> <span class="n">dynamic_columns</span><span class="p">,</span><span class="n">afterall_callback</span><span class="p">,</span> <span class="n">apply</span><span class="p">)</span> </span><span id="L-4"><a name="L-4"></a><span class="k">SELECT</span> </span><span id="L-5"><a name="L-5"></a> <span class="n">id</span><span class="p">,</span> <span class="s1">&#39;id-de-la-compañia&#39;</span><span class="p">,</span> <span class="o">`</span><span class="k">key</span><span class="o">`</span><span class="p">,</span> <span class="s1">&#39;PENSIÓN ALIMENTICIA&#39;</span><span class="p">,</span> <span class="s1">&#39;PENSIÓN ALIMENTICIA&#39;</span><span class="p">,</span> <span class="mi">1500</span><span class="p">,</span> <span class="s1">&#39;{}&#39;</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="n">NOW</span><span class="p">(),</span> <span class="k">RIGHT</span><span class="p">(</span><span class="n">MD5</span><span class="p">(</span><span class="n">CONCAT</span><span class="p">(</span><span class="n">unique_id</span><span class="p">,</span> <span class="ss">&quot;-id-de-la-compañia&quot;</span><span class="p">)),</span> <span class="mi">25</span><span class="p">),</span> <span class="s1">&#39;pension_alimenticia&#39;</span><span class="p">,</span> <span class="k">type</span><span class="p">,</span> <span class="k">NULL</span><span class="p">,</span> <span class="n">COLUMN_CREATE</span><span class="p">(</span><span class="s1">&#39;default&#39;</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="s1">&#39;discountForPeriods&#39;</span><span class="p">,</span> <span class="mi">0</span><span class="p">,</span> <span class="s1">&#39;isFix&#39;</span><span class="p">,</span> <span class="mi">1</span><span class="p">),</span> <span class="k">NULL</span><span class="p">,</span> <span class="mi">1</span> </span><span id="L-6"><a name="L-6"></a><span class="k">FROM</span> <span class="n">paysheet_elements</span> </span><span id="L-7"><a name="L-7"></a><span class="k">WHERE</span> <span class="n">unique_id</span> <span class="o">=</span> <span class="s1">&#39;d_alimienticia&#39;</span> </span><span id="L-8"><a name="L-8"></a><span class="p">;</span> </span></pre></div> </td></tr></table>
"pension alimenticia", insert, paysheet_company_element_concepts

Text only

Sass

1
2
3
https://scotch.io/tutorials/getting-started-with-sass
http://sass-lang.com/guide
https://tutorialzine.com/2016/01/learn-sass-in-15-minutes
https://snippets.siftie.com/embed/96211c48f3b4c9fd10232f030a15d377/
/raw/96211c48f3b4c9fd10232f030a15d377/
96211c48f3b4c9fd10232f030a15d377
text
Text only
3
2019-02-18T07:30:24
True
False
False
Feb 12, 2019 at 08:29 AM
/api/public/snipt/148250/
sass-5b6ea0e0
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>https://scotch.io/tutorials/getting-started-with-sass </span><span id="L-2"><a name="L-2"></a>http://sass-lang.com/guide </span><span id="L-3"><a name="L-3"></a>https://tutorialzine.com/2016/01/learn-sass-in-15-minutes </span></pre></div> </td></tr></table>

Text only

Javascript & Jquery Form Validation

https://www.ntu.edu.sg/home/ehchua/programming/webprogramming/JavaScript_Examples.html
https://formvalidation.io/guide/examples/
https://snippets.siftie.com/embed/c4efc173700f218b40505dc336b46014/
/raw/c4efc173700f218b40505dc336b46014/
c4efc173700f218b40505dc336b46014
text
Text only
2
2019-02-18T10:54:23
True
False
False
/api/public/snipt/148249/
javascript-form-validation
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>https://www.ntu.edu.sg/home/ehchua/programming/webprogramming/JavaScript_Examples.html </span><span id="L-2"><a name="L-2"></a>https://formvalidation.io/guide/examples/ </span></pre></div> </td></tr></table>

Text only

Design inspiration sites

1
2
3
4
https://www.uplabs.com/
https://in.pinterest.com/
https://dribbble.com/
https://www.instagram.com/
https://snippets.siftie.com/embed/7098460ca61b84333f50af647e07b980/
/raw/7098460ca61b84333f50af647e07b980/
7098460ca61b84333f50af647e07b980
text
Text only
4
2019-02-18T22:32:20
True
False
False
/api/public/snipt/148248/
design-inspiration-sites
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>https://www.uplabs.com/ </span><span id="L-2"><a name="L-2"></a>https://in.pinterest.com/ </span><span id="L-3"><a name="L-3"></a>https://dribbble.com/ </span><span id="L-4"><a name="L-4"></a>https://www.instagram.com/ </span></pre></div> </td></tr></table>

Text only

Logo Maker Tool

https://logomakr.com/
https://snippets.siftie.com/embed/1a06a0ceac8f70ae4aa9cc055eda1ccb/
/raw/1a06a0ceac8f70ae4aa9cc055eda1ccb/
1a06a0ceac8f70ae4aa9cc055eda1ccb
text
Text only
1
2019-02-18T10:12:08
True
False
False
Feb 12, 2019 at 08:07 AM
/api/public/snipt/148247/
logo-maker-tool
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>https://logomakr.com/ </span></pre></div> </td></tr></table>

Text only

Freebies

1
2
3
4
5
https://growthsupply.com/
https://unsplash.com/
https://pixabay.com/
https://www.freepik.com/
https://coverr.co/
https://snippets.siftie.com/embed/de9b8a535a06ec37f7518696a0db4b2e/
/raw/de9b8a535a06ec37f7518696a0db4b2e/
de9b8a535a06ec37f7518696a0db4b2e
text
Text only
5
2019-02-18T10:55:49
True
False
False
/api/public/snipt/148246/
free-stock-images
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>https://growthsupply.com/ </span><span id="L-2"><a name="L-2"></a>https://unsplash.com/ </span><span id="L-3"><a name="L-3"></a>https://pixabay.com/ </span><span id="L-4"><a name="L-4"></a>https://www.freepik.com/ </span><span id="L-5"><a name="L-5"></a>https://coverr.co/ </span></pre></div> </td></tr></table>