Skip to content

Instantly share code, notes, and snippets.

View pdeddy78's full-sized avatar
🎯
Focusing

Deddy Pratama pdeddy78

🎯
Focusing
View GitHub Profile
1.100.10.10.000 CASH ON HAND
1.100.10.20.000 BANK
1.100.20.10.000 LOCAL01 TRADE AR
1.100.20.20.000 LOCAL02 TRADE AR
1.100.20.30.000 OVERSEAS TRADE AR
1.100.30.10.001 WORK IN PROCESS
1.100.30.10.002 WIP IN TRANSIT
1.100.30.20.001 FINISHED GOODS
1.100.30.20.002 PROJECT MATERIAL
1.100.30.30.001 GOODS IN TRANSIT
Membuka kembali halaman yang ditinggalkan
menilik kenangan samar pada penanda
Ya kuingat, saat itu aku menemukan ...
... sebuah cahaya!
Entah sejak kapankah hatiku ini
tidak lagi merasakan kesepian
Perasaan yang kauberi telah membuat diriku
keluar dari kegelapan
Bagai bintang-bintang menari di langit malam
masa depan mulai bersinar cerah
$lastweek ="SELECT date_format(logtime, '%Y-%m-%d') AS date, COUNT(*) AS visits FROM {{nama_tabel}} WHERE logtime > DATE_SUB(NOW(), INTERVAL 1 WEEK) GROUP BY date";
$command =Yii::app()->db->createCommand($lastweek);
$result =$command->queryAll();
$arrLastWeek = array(array('Date','Visits'));
foreach ($result as $row) {
$arrLastWeek[] = array(
$row['date'], (int)$row['visits']
);
};