scepion1d

# Create offer
offer = Offer.new(
  {
    "id"=>3454, 
    "order_id"=>9206599, 
    "entries"=>[
      {"id"=>5796, "uid"=>2651, "cover"=>{"id"=>896780, "image"=>{"big"=>{"url"=>"https://storage.googleapis.com/iqbanket-media/production/uploads/media/896780/media/big.jpg", "width"=>845, "height"=>500}}, "title"=>nil, "is_vertical"=>false}, "price"=>123, "title"=>"Красивый", "banquet"=>{"id"=>2992, "title"=>"Тестовый", "address"=>"Варварка 14", "contacts"=>[{"id"=>7483, "name"=>"Eduard A", "role"=>"Начальник кислых щей", "email"=>"", "phone"=>"+79634698719", "position"=>1, "for_client"=>true}, {"id"=>1847, "name"=>"Eris", "role"=>"Кислые щи", "email"=>"", "phone"=>"+79634698720", "position"=>2, "for_client"=>true}, {"id"=>2001, "name"=>"Кто-то там второй", "role"=>"Кислые щи", "email"=>"scepion1d.dev@gmail.com", "phone"=>"+79220135341", "position"=>1, "for_client"=>true}]}, "regions"=>[{"id"=>4, "name"=>"ЮВАО"}], "subways"=>[{"id"=>7574, "line"=>"filyovskaya", "name"=>"Александровский сад", "color"=>"#19C1F3",

scepion1d

get_current_git_branch() {
  local branch=`git rev-parse --abbrev-ref HEAD 2> /dev/null`

  if [ "$branch" != "" ]; then
      echo " ⌥ $branch "
  fi
}

get_git_stat() {
    local branch=`git rev-parse --abbrev-ref HEAD 2> /dev/null`

scepion1d

video		type	length		resolution	rendering	parallel
phable_PL	.mp4	57.4		1920x1080	177.258317	1
phable_PL	.mp4	57.4		1920x1080	175.066136	1
phable_PL	.mp4	57.4		1920x1080	190.108336	1
phable_PL	.mp4	57.4		1920x1080	574.541037	2
phable_PL	.mp4	57.4		1920x1080	625.973804	2
phable_PL	.mp4	57.4		1920x1080	385.371598	3
phable_PL	.mp4	57.4		1920x1080	281.963515	3
phable_PL	.mp4	57.4		1920x1080	415.118817	4
phable_PL	.mp4	57.4		1920x1080	388.200012	4

scepion1d

AllCops:
  TargetRubyVersion: 2.3
  Exclude:
    - 'bin/**/*'
    - 'db/**/*'
    - 'log/**/*'
    - 'tmp/**/*'
    - 'vendor/**/*'
    - 'public/**/*'
  DisplayCopNames: true

scepion1d

get_current_git_branch() {
  local branch=`git rev-parse --abbrev-ref HEAD 2> /dev/null`

  if [ "$branch" != "" ]; then
      echo " ⌥ $branch "
  fi
}

get_git_stat() {
    local branch=`git rev-parse --abbrev-ref HEAD 2> /dev/null`

scepion1d

select mdfr_list.material_id,
       mdfr_list.unit_id,
       mdfr_list.unit_name,
       mdfr_list.oper_unit_sys,
       mdfr_list.oper_unit_sys_mdfr,
       mdfr_list.oper_sys_mdfr,
       mdfr_list.oper_unit_sys_spec_cond,
       mdfr_list.oper_unit_tech,
       mdfr_list.oper_unit_tech_mdfr,
       mdfr_list.oper_tech_mdfr,

scepion1d

-------------------------------------------
-------------------------------------------
---!!!Сначала проверьте на тестовой базе!!!
-------------------------------------------
-------------------------------------------

declare
  -----------------------------------  
  material_no             varchar(10) := '400706414'; -- номер выходного пакета
  defect_pcs              number := 1; -- количество брака  

scepion1d

select rownum as "№",  cipher_list.*
  from (select to_number(m.material_id) as "Код материала",
               nvl(m.tns, m.proportional_tns) as "Тонны",
               dv.code as "Шифр MES",
               (select max(aw.no) keep(dense_rank last order by po.prod_oper_time) 
                  from rs_product@erp        p,
                       rs_prod_oper@erp      po,
                       rs_transform_oper@erp tro,
                       acc_ware@erp          aw
                 where p.rs_product_guid = c.document_guid

scepion1d

--добавляет брак на термообработке

declare
  -----------------------------------  
  material_no             varchar(10) := '400665184'; -- номер выходного пакета
  defect_pcs              number := 1; -- количество брака  
  defect_code             number := 359; -- вид дефекта             select * from description_value where upper(name) like '%КРИВЫЕ%'
  new_material_no         varchar(10) := ''; -- номер пакета брака, опционально
  workshop                number := 4; -- Номер цеха, нужен для генерации кода
  lower_material_no       number := workshop * 100000000; -- Наименьший возможный код пакета

scepion1d

import java.sql.ResultSet;
import java.sql.Statement;

import java.util.StringTokenizer;
import java.util.Vector;

public class Apriori {
    private static Statement stmt;
    private static Vector<String> candidates;
    private static Vector<Double> supports;