Welcome to Yupi Sugianto Personal Website

Welcome to My Personal Website ^_^! ..
My name is Yupi Sugianto… I am 24 years old. Computer Science is my basic knowledge, what I get at BiNus University. That's University teach me how be a good programmer (hehehe.. but not the best programmer), I must explore that's knowledge to get more.. I like Algorithm, for me it's like RPG game hahaha.. I am a good coder.. I have a lot of another skill about computers such as networking, hardware, solve hardware troubleshoot, multimedia interactive, video editing, DVR. Overall I like learn about technology. For detail, You can see My Biography.

Tips from me to all new programmer.. when You coding, Think you're in the Roling Playing Game and You must search the way out, don't be surrender... believe your self and You will done it. Enjoy and Feel the game..

At this site I want to share all of my knowledge and experience to You, ^_^... I like helping others.. It's Fun, I think..
Computer science is my based knowledge. I hope my knowledge and experience can useful for You.
Thanks for coming.. and have a nice day. ^_^

Recent Post

Repair Always Checking Disk when start up (Monday, 19 July 2010 13:19) 0 Total Comment

, 12 views

cara supaya checkdisknya ilang
1. km pilih start -> Run
2. trus ketik 'cmd' trus enter
3. lalu muncul windows hitam(command promt)
nah lalu ketik 'chkntfs /X C: D: E:' tanpa tanda kutip. C D or E bisa diganti ama drive lain.. drive yang selalu di scan.
4. abis itu langsung restart kalo selesai
done: hope usefull ^_^

Yupi Sugianto.. read more..

Query 4 my client (Friday, 18 June 2010 06:04) 1 Total Comment

, 63 views

it's easy but need a few concentration..

one a bit freak query to calculate my client sales commission..
SELECT huhu.* , head.tanggal , head.sales, head.customer
FROM
(
SELECT x.faktur_penjualan_header_no, COALESCE(x.customer_name,z.customer_name) AS customer_name, COALESCE(weight_total2mToUp,'') AS weight_total2mToUp, COALESCE(weight_total2mToDown,'') AS weight_total2mToDown
FROM
(
SELECT zz.faktur_penjualan_header_no, xx.tanggal, xx.tanggal_BayarKomisi, xx.customer_name, xx.sales_code, xx.sales_name, xx.weight_total2mToUp, xx.status_transaksi FROM (
SELECT a.faktur_penjualan_header_no,
CONCAT(SUBSTRING(tanggal,9,2),'/',SUBSTRING(tanggal,6,2),'/',SUBSTRING(tanggal,1,4)) AS tanggal,
tanggal_BayarKomisi,
customer_name,
sales_code,
sales_name,
COALESCE(SUM(e.qty*d.commision_sales),'') AS weight_total2mToUp,
status_transaksi
FROM faktur_penjualan_header a, customer b, sales c , product d , faktur_penjualan_detail e
WHERE a.customer=b.customer_code
AND a.sales=c.sales_code
AND e.product_id=d.product_id
AND e.faktur_penjualan_header_no=a.faktur_penjualan_header_no
AND thickness >= 2
AND status_transaksi = 'LUNAS'
AND tanggal_BayarKomisi IS NULL
GROUP BY e.faktur_penjualan_header_no
) xx
RIGHT JOIN (
SELECT faktur_penjualan_header_no FROM faktur_penjualan_header
WHERE status_transaksi = 'LUNAS' AND tanggal_BayarKomisi IS NULL ) zz
ON xx.faktur_penjualan_header_no=zz.faktur_penjualan_header_no
) X
JOIN
(
SELECT uu.faktur_penjualan_header_no, yy.tanggal, yy.tanggal_BayarKomisi, yy.customer_name, yy.sales_code, yy.sales_name, yy.weight_total2mToDown, yy.status_transaksi
FROM (
SELECT a.faktur_penjualan_header_no,
CONCAT(SUBSTRING(tanggal,9,2),'/',SUBSTRING(tanggal,6,2),'/',SUBSTRING(tanggal,1,4)) AS tanggal,
tanggal_BayarKomisi,
customer_name,
sales_code,
sales_name,
COALESCE(SUM(e.qty*d.commision_sales),'') AS weight_total2mToDown,
status_transaksi
FROM faktur_penjualan_header a, customer b, sales c , product d , faktur_penjualan_detail e
WHERE a.customer=b.customer_code
AND a.sales=c.sales_code
AND e.product_id=d.product_id
AND e.faktur_penjualan_header_no=a.faktur_penjualan_header_no
AND thickness < 2
AND status_transaksi = 'LUNAS'
AND tanggal_BayarKomisi IS NULL
GROUP BY e.faktur_penjualan_header_no
) yy
RIGHT JOIN (
SELECT faktur_penjualan_header_no FROM faktur_penjualan_header
WHERE status_transaksi = 'LUNAS' AND tanggal_BayarKomisi IS NULL ) uu
ON yy.faktur_penjualan_header_no=uu.faktur_penjualan_header_no
) z ON x.faktur_penjualan_header_no=z.faktur_penjualan_header_no
ORDER BY faktur_penjualan_header_no
) huhu , faktur_penjualan_header head
WHERE huhu.faktur_penjualan_header_no=head.faktur_penjualan_header_no read more..