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
what is SDC? SDC (Secure Download Cabinet) file is ecrypted file that can be downloaded from MSDNAA (MSDN Academic Alliance) server , in this server you can found many file micr*sof* that can be downloaded directly.. but actually only for certain groups or people.. ^_^
thats has 3 mirror server :
http://elms.pjwstk.edu.pl/sdc/
http://oknos.fi.muni.cz/?C=S;O=D
http://ftp.sh.cvut.cz/MSDNAA/Rapid_Setup/?C=M;O=A
my non stop running track.. once a week.. sometimes twice..
^_^
There are so many image sliders out there. Javascript plugins, tutorials, inspirational posts are everywhere.. I filtered out simple javascript slider that uses fadein/fadeout and sliding and choose slider with beautiful transition and some flash sliders as well. you can use in your web..
check this out...
Do not love one or two. But love the one who loves you TOO..
Do not love three or four. But love the one who loves you MORE..
Do not love five or six. But love the one who truly STICKS..
Do not love seven or eight. But love the one who is willing to WAIT..
Do not love nine or ten. But love the one who’ll love you till the END....
Monkey Evolution.. wkwkwkwk
Money Makes Trouble...
This site will be back on track in a week, the developers are taking a needed vacation, all emails and project will be answered when they are back on (May 7th 2011). Thank you for your consideration.
try this query code :
select @rownum:=@rownum+1 ’NO’, p.barang_name from barang p, (SELECT @rownum:=0) r order by barang_name asc limit 5;
result :
NO | barang_name
---------------------
1 | Barang name 1
2 | Barang name 2
3 | Barang name 3
4 | Barang name 4
5 | Barang name 5
do u know some vectoring application in desktop... maybe like corel draw, adobe illustrator ? I imagine it’s hard to made that application.
and I imagine it’s harder to made that application running at web and Online. but, Aviary’s do it.. AWESOME... Aviary’s programmers make that with flash. so u need flash player to use that. Aviary takes the full set of image and audio editing tools online - and they’re free!
Aviary’s Online Vector Editing Web Application
Aviary’s Online Sound Editing Web Application
Aviary is a collection of ornithologically named online tools designed to bring creativity to the cloud. There is a strong focus on graphic work in the form of photo, vector and palette editors, but an online audio editor is also available.
What happen with my feet... grrrr.... after woke up in the morning I feel so hurt in my feet.. I’m try to walk then feel more hurt.. not possible to walk with this hurt... I just get a little hurt in my feet on last night so I ignore that.. but in the morning.. it feel more hurt..
oh my God... zzzzz.... I must call up two client to reschedule the meeting..