Skip to content

Instantly share code, notes, and snippets.

View ptrnov's full-sized avatar

Piter Novian ptrnov

3 followers · 1 following
View GitHub Profile
@ptrnov
ptrnov / get tabx index active
Created September 20, 2016 17:15
/*
* Triger timeout button triger with timeout.
* @author piter novian [ptr.nov@gmail.com]
*/
$this->registerJs("
$(document).ready(function() {
$('#tab-project-id').click(function(){
setTimeout(function(){
var idx = $('ul li.active').index();
//alert(idx);
@ptrnov
ptrnov / triger button
Created September 20, 2016 17:13
/*
* Triger timeout button triger with timeout.
* @author piter novian [ptr.nov@gmail.com]
*/
$this->registerJs("
$(document).ready(function() {
$('#tab-project-id').click(function(){
setTimeout(function(){
var idx = $('ul li.active').index();
//alert(idx);
@ptrnov
ptrnov / YII2 CPANEL
Created May 23, 2016 11:13
[1]=== .htaccess ===> public_html ====
#Options +FollowSymlinks
RewriteEngine On
# deal with admin first
#RewriteCond %{REQUEST_URI} ^/(admin)
#RewriteRule ^admin/assets/(.*)$ backend/web/assets/$1 [L]
#RewriteRule ^admin/css/(.*)$ backend/web/css/$1 [L]
#RewriteCond %{REQUEST_URI} !^/backend/web/(assets|css)/
@ptrnov
ptrnov / CHAT REFRESH
Created May 23, 2016 04:38
<?php
Pjax::begin(['id'=>'msg-chat']);
//echo "asd";
echo Html::mediaList([
[
//'id'=>'msg-chat',
'heading' => false,
'body' => false,
'imgOptions'=>false,
'src' => false,
@ptrnov
ptrnov / Gridview - Image Base64
Created April 3, 2016 06:51
'value'=>function($model){
$test1='data:image/jpeg;charset=utf-8;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQH/2wBDAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQH/wAARCABkAEsDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD+Mjwt8evHmk6anh7WX0/xp4ZRgBoPjGwi1yziHK/6I9z/AKXYSBSVSW0nhdMDbkAV6DB4o/Zw8URK3iP4Y+KvCGoklpLnwH4pgewkY/8AUO8Q6
@ptrnov
ptrnov / Template HTML Mail
Created February 25, 2016 10:53
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Grudnik Helpdesk</title>
</head>
<body style="margin:0px;
padding:0px;
border: 0 none;
font-size: 11px;
@ptrnov
ptrnov / MYSQL SCHEDULE
Created February 24, 2016 03:31
1. conf my.ini
event_scheduler = ON
2. run query procedure
BEGIN
#conf add mysql.ini
#--event-scheduler=ON
SET GLOBAL event_scheduler = OFF;
SET @@global.event_scheduler = OFF;
SET GLOBAL event_scheduler = 0;
@ptrnov
ptrnov / MYSQL GROUP_CONCAT LIMIT
Created February 5, 2016 17:34
SET SESSION GROUP_CONCAT_MAX_LEN = 1000000;
@ptrnov
ptrnov / Yii2 PLSQL
Created February 5, 2016 07:52
#YII2 Call Procedure
#public function getScripts($page, $section){
# return Yii::app()->db->createCommand("CALL your_stored_procedure(:page, :section)")
# ->queryAll(array(':page' => $page, ':section' => $section));
#}
#$command = Yii::app()->db->createCommand('call my_proc("nice day today")');
#$command->execute();
#$connection = Yii::$app->db;
@ptrnov
ptrnov / Mysql PLSQL ROW to COLUMN
Created February 3, 2016 15:33
CREATE DEFINER=`root`@`localhost` PROCEDURE `so_1_ver1.1`()
BEGIN
SET @sql = NULL;
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
"MAX(case when KD_BARANG_ALIAS = '",
KD_BARANG_ALIAS,
"' then SO_QTY end) AS ",
replace(NM_BARANG, ' ', '')