Tuesday, October 6, 2020

Kelinci Baruku

Kami memulai hobi kami dengan pertamakali membeli kelinci di pasar baru tanggal 4 October 2020. kami membeli 4 kelinci pertama yang kami beri nama Rubi, Kumkum, Browny dan Garit. Lalu kami bawa ke tanah kosong kami disana kami bermain dengan kelinci kami.

Nama-namanya :

1. Kumkum

2. Ruby

3. Browny

4. Garyd

5. Tamtam

6. Bubu

Monday, October 5, 2020

Rumus Kapasitas Item - Mach Stampy

 KOMBINASI FORMING  = (F34*60)*G34*D34
PROGRESIF FORMING  = (F48*60)*G48*D48
FORGING                   = (F45*60*60)*G45/D45
STEP FORMING          = (F54*60*60)*G54/D54
TEFLON                     =      (E62*60*60)*G62/D62
TRIMMING                =      (E65*60*60)*G65*C65/D65

Chemical from NAV nambah ke Bawah

 

1.  list chemical yang diambil dari NAV masih ke bawah.. Cek

2. aku benerin urutannya.. jd total lot 10, inc 8, outbound 6, aftercure 3.. jd stock 2 dan yg blm dikerjakan 2 lot gitu ya bu

Warna Weekly Schedule Rubber

  RUBBER 1 LIME
RUBBER 2 GOLD
RUBBER 3 ROSE
RUBBER 1 & 2 LIGHT CORNFLOWER BLUE
RUBBER 1 & 3 LIGHT GREEN
RUBBER 2 & 3 TURQOISE

Jenis - Jenis Job Tag

 

jenis - jenis job tag
PK  :(permintaan khusus)

EX : (job sisa hanya diisue ke warehouse)

X : job pastdue

R : job trial

J :  m/c dan rubber

N : spring export

M : M/C export

C : Rubber only

W : job biasa 

TS : Trial Sample


yang tidak diisu ke parts sementara adalah : PK,EX,TS,R

POSTGRESQL Tutorial - Select Count with Condition

 

 in Postgresql there is a way to select count with condition. in PostgreSQL 9.1 version cannot user Filter to get Select Count with Condition then should use CASE WHEN

first. I use this SQL

SELECT
COUNT(sjobstatus) FILTER (WHERE sjobstatus = 'CANCELLED') AS fclose
FROM rdr.xwkschrb 

working in my local PC but not working in liver server due to different Postgreql version. then i change to this SQL then working

SELECT
 COUNT(CASE WHEN sjobstatus = 'CANCELLED' THEN sjobstatus  END) AS close
FROM rdr.xwkschrb "

Cara Start dan Stop Linux Appserver 08

 

 Command untuk stop glassfish server : 

sudo systemctl stop glassfish

 Command untuk start glassfish server : 

sudo systemctl start glassfish

Login  : system

Passwd : system23XX

mau nambah autorisasi untuk folder tertentu : RADAR/PLANING

sudo mkdir -p /opt/RADAR/PLANING

sudo chown -R system:system /opt/RADAR

begitu gaess ini untuk linux ubunto