| Server IP : 104.21.37.246 / Your IP : 104.23.243.33 [ Web Server : Apache System : Linux cpanel01wh.bkk1.cloud.z.com 2.6.32-954.3.5.lve1.4.59.el6.x86_64 #1 SMP Thu Dec 6 05:11:00 EST 2018 x86_64 User : cp648411 ( 1354) PHP Version : 7.2.34 Disable Function : NONE Domains : 0 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home2/cp648411/public_html/simded.com/wallpaper/backend/main/ |
Upload File : |
<?php require_once("../include/class.php");?>
<?php require_once("../include/header.php");?>
<?php require_once("../include/nav_top.php");?>
<?php require_once("../include/sidebar.php");?>
<div id="main-content">
<div class="container-fluid">
<ul class="breadcrumb">
<li><a href="#">Home</a><span class="divider">»</span></li>
<li class="active">Dashboard</li>
</ul>
<div class="dashboard-widget">
<div class="row-fluid">
<!-- <div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../customer/list.php"> <i class="dashboard-icons-colors customers_sl"></i> <span class="dasboard-icon-title">สมาชิก</span> </a> </div>
</div>
</div>-->
<?php
if($_SESSION["admin_cn_type"] == 1)
{
?>
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../wallpaper/list.php"> <i class="dashboard-icons image_2_blk"></i>
<span class="dasboard-icon-title">wallpaper</span> </a>
</div>
</div>
</div>
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../banner/list.php"> <i class="dashboard-icons image_2_blk"></i>
<span class="dasboard-icon-title">Banner</span> </a>
</div>
</div>
</div>
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../zodiac/list.php"> <i class="dashboard-icons refresh_2_blk"></i> <span class="dasboard-icon-title">ราศี</span> </a> </div>
</div>
</div>
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../element/list.php"> <i class="dashboard-icons refresh_2_blk"></i> <span class="dasboard-icon-title">ธาตุ</span> </a> </div>
</div>
</div>
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../category/list.php"> <i class="dashboard-icons tags_2_blk"></i> <span class="dasboard-icon-title">หมวดหมู่</span> </a> </div>
</div>
</div>
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../category_supplement/list.php"> <i class="dashboard-icons tags_2_blk"></i> <span class="dasboard-icon-title">หมวดหมู่เสริม</span> </a> </div>
</div>
</div>
<!--
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../phonenumber/list.php"> <i class="dashboard-icons iphone_4_blk"></i> <span class="dasboard-icon-title">เบอร์มือถือ</span> </a> </div>
</div>
</div>
-->
<!--<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../sumnumber/list.php"> <i class="dashboard-icons note_book_blk"></i> <span class="dasboard-icon-title">ผลรวมของเบอร์</span> </a> </div>
</div>
</div>-->
<!--
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../mobilenetwork/list.php"> <i class="dashboard-icons box_outgoing_blk"></i> <span class="dasboard-icon-title">ค่ายมือถือ</span> </a> </div>
</div>
</div>
-->
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../number/list.php"> <i class="dashboard-icons books_blk"></i> <span class="dasboard-icon-title">ชุดตัวเลข</span> </a> </div>
</div>
</div>
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../order/list.php"> <i class="dashboard-icons shopping_cart_3_blk"></i> <span class="dasboard-icon-title">รายการซื้อ</span> </a> </div>
</div>
</div>
<!--
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../faq/list.php"> <i class="dashboard-icons speech_bubbles_blk"></i> <span class="dasboard-icon-title">ถาม-ตอบ</span> </a> </div>
</div>
</div>
-->
<!--
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../dealerprices/list.php"> <i class="dashboard-icons money_blk"></i> <span class="dasboard-icon-title">ราคา Dealer</span> </a> </div>
</div>
</div>
-->
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../aboutus/list.php"> <i class="dashboard-icons table_blk"></i> <span class="dasboard-icon-title">เกี่ยวกับเรา</span> </a> </div>
</div>
</div>
<!--
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../orders/list.php"> <i class="dashboard-icons shopping_cart_3_blk"></i> <span class="dasboard-icon-title">ORDER</span> </a> </div>
</div>
</div>
-->
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../code/list.php"> <i class="dashboard-icons price_tags_blk"></i> <span class="dasboard-icon-title">รหัสส่วนลด</span> </a> </div>
</div>
</div>
<!--
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../expire/list.php"> <i class="dashboard-icons month_calendar_blk"></i> <span class="dasboard-icon-title">ซิมเติมเงิน หมดอายุ</span> </a> </div>
</div>
</div>
-->
<!--
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../log_reading/list.php"> <i class="dashboard-icons file_cabinet_blk"></i> <span class="dasboard-icon-title">Log ทำนายเบอร์</span> </a> </div>
</div>
</div>
-->
<!-- <div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../expire/list2.php"> <i class="dashboard-icons price_tags_blk"></i> <span class="dasboard-icon-title">รายเดือน หมดอายุ</span> </a> </div>
</div>
</div>-->
<!--
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../transfer/list.php"> <i class="dashboard-icons money_2_blk"></i> <span class="dasboard-icon-title">ยืนยันการโอนเงิน</span> </a> </div>
</div>
</div>
-->
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../member/list.php"> <i class="dashboard-icons user_blk"></i> <span class="dasboard-icon-title">สมาชิก</span> </a> </div>
</div>
</div>
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../contactus/list.php"> <i class="dashboard-icons phone_blk"></i> <span class="dasboard-icon-title">ติดต่อเรา</span> </a> </div>
</div>
</div>
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../admin/list.php"> <i class="dashboard-icons admin_user_blk"></i> <span class="dasboard-icon-title">Admin</span> </a> </div>
</div>
</div>
<?php
}
if($_SESSION["admin_cn_type"] == 2)
{
?>
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../phonenumber/list.php"> <i class="dashboard-icons iphone_4_blk"></i> <span class="dasboard-icon-title">phone number</span> </a> </div>
</div>
</div>
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../expire/list.php"> <i class="dashboard-icons month_calendar_blk"></i> <span class="dasboard-icon-title">phone number expire</span> </a> </div>
</div>
</div>
<div class="span2">
<div class="dashboard-wid-wrap">
<div class="dashboard-wid-content"> <a href="../orderdetail/list.php"> <i class="dashboard-icons shopping_cart_3_blk"></i> <span class="dasboard-icon-title">ORDER</span> </a> </div>
</div>
</div>
<?php
}
?>
</div>
</div>
<?php
if($_SESSION["admin_cn_type"] == 1)
{
?>
<div class="row">
<div class="span10">
<div class="index-graph">
<div class="chart-block">
<div id="chart1"> </div>
</div>
</div>
</div>
</div>
<div class="row">
<div class="span9">
<div class="summary" style="padding-top:30px;">
<ul>
<?php
$sql_NH = array('table'=>'wal_log_order','count'=>'COUNT(id) AS max_id','where'=>'status = "success" AND type = 1');
$view_NH = $view_db->view($sql_NH);
$row_NH = $view_db->q($view_NH);
$max_id = $row_NH['max_id'];
?>
<li>
<span class="summary-icon">
<img src="../img/user-accounts.png" width="36" height="36" alt="New Accounts">
</span>
<span class="count" style="color: #eaa228;">
<?php echo $max_id; ?>
</span>
<span class="summary-title">จำนวนการซื้อวอลเปเปอร์</span>
</li>
<?php
$sql_NI = array('table'=>'wal_log_order','count'=>'COUNT(id) AS max_id','where'=>'status = "success" AND type = 2');
$view_NI = $view_db->view($sql_NI);
$row_NI = $view_db->q($view_NI);
$max_id2 = $row_NI['max_id'];
?>
<li>
<span class="summary-icon">
<img src="../img/user-accounts.png" width="36" height="36" alt="New Accounts">
</span>
<span class="count" style="color: #c5b47f;">
<?php echo $max_id2; ?>
</span>
<span class="summary-title">จำนวนการซื้อวอลเปเปอร์แบบใช้โค้ด</span>
</li>
<?php
$sql_NI2 = array('table'=>'wal_log_order','count'=>'COUNT(id) AS max_id','where'=>'status = "success" AND type = 3');
$view_NI2 = $view_db->view($sql_NI2);
$row_NI2 = $view_db->q($view_NI2);
$max_id3 = $row_NI2['max_id'];
?>
<li>
<span class="summary-icon">
<img src="../img/user-accounts.png" width="36" height="36" alt="New Accounts">
</span>
<span class="count" style="color: #579575;">
<?php echo $max_id3; ?>
</span>
<span class="summary-title" >จำนวนการดาวน์โหลดวอลเปเปอร์แบบฟรี</span>
</li>
<?php
$sql_NI3 = array('table'=>'wal_log_order','count'=>'COUNT(id) AS max_id','where'=>'status = "again" AND type = 4');
$view_NI3 = $view_db->view($sql_NI3);
$row_NI3 = $view_db->q($view_NI3);
$max_id4 = $row_NI3['max_id'];
?>
<li>
<span class="summary-icon">
<img src="../img/user-accounts.png" width="36" height="36" alt="New Accounts">
</span>
<span class="count" style="color: #839557;">
<?php echo $max_id4; ?>
</span>
<span class="summary-title">จำนวนการดาวน์โหลดวอลเปเปอร์ซ้ำ</span>
</li>
</ul>
</div>
</div>
</div>
<?php
}
?>
</div>
</div>
<?php
$date_m = date('m');
$month_thai = array('1'=>"มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฎาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");
$date_m_num = date('t');
for($i=1;$i <= $date_m_num;$i++)
{
$total_day = 0;
$total_day2 = 0;
$total_day3 = 0;
$total_day4 = 0;
$total_day5 = 0;
$to = date('Y').'-'.$date_m.'-'.$i . ' 00:00:00';
$from = date('Y').'-'.$date_m.'-'.$i . ' 23:59:00';
$list = array('table'=>'wal_order','where'=>'status = "success" AND datetime >= "'.$to.'" AND datetime <= "'.$from.'"');//เติมเงินหมดอายุ
$view = $view_db->view($list);
$result = $view_db->q_re($view);
while($row = $view_db->q_ro($result))
{
$total = $row['amount'];
$total_day = $total_day + $total;
}
$list2 = array('table'=>'wal_log_order','count'=>'COUNT(id) AS max_id','where'=>'status = "success" AND type = 1 AND datetime >= "'.$to.'" AND datetime <= "'.$from.'"');//เติมเงินหมดอายุ
$view2 = $view_db->view($list2);
$result2 = $view_db->q_re($view2);
while($row2 = $view_db->q_ro($result2))
{
$total2 = $row2['max_id'];
$total_day2 = $total_day2 + $total2;
}
$list3 = array('table'=>'wal_log_order','count'=>'COUNT(id) AS max_id','where'=>'status = "success" AND type = 2 AND datetime >= "'.$to.'" AND datetime <= "'.$from.'"');//เติมเงินหมดอายุ
$view3 = $view_db->view($list3);
$result3 = $view_db->q_re($view3);
while($row3 = $view_db->q_ro($result3))
{
$total3 = $row3['max_id'];
$total_day3 = $total_day3 + $total3;
}
$list4 = array('table'=>'wal_log_order','count'=>'COUNT(id) AS max_id','where'=>'status = "success" AND type = 3 AND datetime >= "'.$to.'" AND datetime <= "'.$from.'"');//เติมเงินหมดอายุ
$view4 = $view_db->view($list4);
$result4 = $view_db->q_re($view4);
while($row4 = $view_db->q_ro($result4))
{
$total4 = $row4['max_id'];
$total_day4 = $total_day4 + $total4;
}
$list5 = array('table'=>'wal_log_order','count'=>'COUNT(id) AS max_id','where'=>'status = "again" AND type = 4 AND datetime >= "'.$to.'" AND datetime <= "'.$from.'"');//เติมเงินหมดอายุ
$view5 = $view_db->view($list5);
$result5 = $view_db->q_re($view5);
while($row5 = $view_db->q_ro($result5))
{
$total5 = $row5['max_id'];
$total_day5 = $total_day5 + $total5;
}
//echo $total_day;
$txt_d = '["'.date('Y').'-'.$date_m.'-'.$i.'",'.$total_day.'],';
$txt_d_m = $txt_d_m . $txt_d;
$txt_d2 = '["'.date('Y').'-'.$date_m.'-'.$i.'",'.$total_day2.'],';
$txt_d_m2 = $txt_d_m2 . $txt_d2;
$txt_d3 = '["'.date('Y').'-'.$date_m.'-'.$i.'",'.$total_day3.'],';
$txt_d_m3 = $txt_d_m3 . $txt_d3;
$txt_d4 = '["'.date('Y').'-'.$date_m.'-'.$i.'",'.$total_day4.'],';
$txt_d_m4 = $txt_d_m4 . $txt_d4;
$txt_d5 = '["'.date('Y').'-'.$date_m.'-'.$i.'",'.$total_day5.'],';
$txt_d_m5 = $txt_d_m5 . $txt_d5;
}
$txt_d_m = substr($txt_d_m,0,-1);
$txt_d_m2 = substr($txt_d_m2,0,-1);
$txt_d_m3 = substr($txt_d_m3,0,-1);
$txt_d_m4 = substr($txt_d_m4,0,-1);
$txt_d_m5 = substr($txt_d_m5,0,-1);
//print_r($txt_d_m2);
?>
<?php require_once("../include/footer_js.php");?>
<?php require_once("../include/footer.php");?>
<script>
$(function(){
var line1=[<?php echo $txt_d_m; ?>]; // รายได้ประจำเดือน สี info
var line2=[<?php echo $txt_d_m2; ?>]; //#eaa228 จ่ายเงิน
var line3=[<?php echo $txt_d_m3; ?>]; //#c5b47f ใช้โค้ด
var line4=[<?php echo $txt_d_m4; ?>]; //#579575 ดาว์นโหลดฟรี
var line5=[<?php echo $txt_d_m5; ?>]; //#839557 ดาว์นโหลดซ้ำ
var plot1 = $.jqplot('chart1', [line1,line2,line3,line4,line5], {
title:'รายงานการขายประจำเดือน <?php echo $month_thai[$date_m];?>',
axes:{
xaxis:{
renderer:$.jqplot.DateAxisRenderer,
tickOptions:{
formatString:'%#d'
},
min: "<?php echo date('Y');?>-<?php echo $date_m; ?>-01",
max: "<?php echo date('Y');?>-<?php echo $date_m; ?>-<?php echo $date_m_num;?>",
tickInterval: "1 days",
},
yaxis:{
tickOptions:{
formatString:'%.2f'
}
}
},
seriesDefaults: {
show: true, // wether to render the series.
xaxis: 'xaxis', // either 'xaxis' or 'x2axis'.
yaxis: 'yaxis', // either 'yaxis' or 'y2axis'.
/*color: '#196795', */ // CSS color spec to use for the line. Determined automatically.
lineWidth: 3, // Width of the line in pixels.
shadow: false, // show shadow or not.
},
highlighter: {
show: true,
sizeAdjust: 7.5
},
grid: {
background: '#fff',
drawBorder: false,
shadow: false,
gridLineColor: '#ccc',
gridLineWidth: 1
},
cursor: {
show: false
}
});
});
</script>