asvechkar

// Плавный скролл к верху страницы
$("a[href='#top']").click(function() {
  $("html, body").animate({ scrollTop: 0 }, "slow");
  return false;
});

// Дублирование thead в самый низ html таблицы
var $tfoot = $('<tfoot></tfoot>');
$($('thead').clone(true, true).children().get().reverse()).each(function() {
  $tfoot.append($(this));

asvechkar

sudo -u postgres psql
 
CREATE DATABASE test_database;
 
CREATE USER test_user WITH password 'qwerty';
 
GRANT ALL privileges ON DATABASE test_database TO test_user;
 
psql -h localhost test_database test_user
 

asvechkar

Есть набор данных (КЛАДР):

var data = [

   { region: 1, city: 0, street:0, name: "Ростовская обл.", type: 1 },
   { region: 2, city: 0, street:0, name: "Ленинградская обл.", type: 1 },
   { region: 3, city: 0, street:0, name: "Магаданская обл.", type: 1 },

/** ... **/

asvechkar

Select
  acqt.transaction_id As transactnum
, acqt.fld_007 As transactdate
, acqt.fld_004 / 100 As amount
, acqt.fld_042 As merchant_id
, acqt.fld_002 As card_num
, acqt.reader_sn As reader_num
, acqt.mti As transtype
, acqt.card_type As brand
, COALESCE(uc.user_id, ue.client_id, 1010379) As client_id

asvechkar

SELECT
	uc.user_id AS Id,
	uc.client_name AS name,
	lc.law_full_name AS fullname,
	us.username AS phone,
	us.email,
	lc.inn,
	lc.ogrn,
	cba.account_num AS account,
	b.bank_name AS bank,

asvechkar

SELECT u.firm_name AS 'Компания',
  ROUND(SUM(CASE WHEN p.t_time BETWEEN DATE(DATE_ADD(NOW(), INTERVAL -30 day)) AND DATE(NOW()) THEN p.amount ELSE 0 END),2) AS 'За весь месяц' ,
  ROUND(SUM(CASE WHEN p.t_time BETWEEN DATE(DATE_ADD(NOW(), INTERVAL -7 day)) AND DATE(NOW()) THEN p.amount ELSE NULL END),2) AS 'За 1 неделю',
  ROUND(SUM(CASE WHEN p.t_time BETWEEN DATE(DATE_ADD(NOW(), INTERVAL -14 day)) AND DATE(DATE_ADD(NOW(), INTERVAL -7 day)) THEN p.amount ELSE NULL END),2) AS 'За 2 неделю',
  ROUND(SUM(CASE WHEN p.t_time BETWEEN DATE(DATE_ADD(NOW(), INTERVAL -21 day)) AND DATE(DATE_ADD(NOW(), INTERVAL -14 day)) THEN p.amount ELSE NULL END),2) AS 'За 3 неделю',
  ROUND(SUM(CASE WHEN p.t_time BETWEEN DATE(DATE_ADD(NOW(), INTERVAL -28 day)) AND DATE(DATE_ADD(NOW(), INTERVAL -21 day)) THEN p.amount ELSE NULL END),2) AS 'За 4 неделю'
  FROM payments p
  JOIN user u
  ON p.user_id=u.id
  WHERE p.status='sign'

asvechkar

---
en:
  date:
    abbr_day_names:
    - Sun
    - Mon
    - Tue
    - Wed
    - Thu
    - Fri

asvechkar

require 'sneakers'
require 'json'
require 'tubesock'

class Processor
  include Sneakers::Worker
  include Tubesock::Hijack
  from_queue 'receive_transactions_queue',
             durable: true,
             arguments: {

asvechkar

// Закомментировать строку
// background:url(./images/leaf.png) no-repeat;

// Добавить в конце файла
.sublogotip {
  color: #fff;
  font-size: 11pt;
}
.contactblock {
  color: #fff;

asvechkar

select posts.post_name
, posts.post_date
, (select pm.meta_value from lrt7sk_postmeta as pm where pm.post_id = posts.ID and pm.meta_key = 'wpcf-client_email' limit 1) as email
, (select pm.meta_value from lrt7sk_postmeta as pm where pm.post_id = posts.ID and pm.meta_key = 'wpcf-client_phone' limit 1) as phone
from lrt7sk_posts as posts
where posts.post_type = 'orders'