<?php
|
|
|
class crm_audit_controller extends adminCommon
|
{
|
|
function index_action()
|
{
|
|
$companyorderM = $this->MODEL('companyorder');
|
|
$where = $urlarr = array();
|
|
$where['order_state'] = 2;
|
$where['order_price'] = array('>', 0);
|
|
if (isset($_GET['iscrm']) && $_GET['iscrm'] == 1){
|
|
$where['crm_uid'] = array('>', 0);
|
$urlarr['iscrm'] = $_GET['iscrm'];
|
}
|
|
if ($_GET['time']) {
|
if ($_GET['time'] == -1) {
|
|
$timeBegin = mktime(0, 0, 0, date('m'), date('d'), date('y'));
|
$timeEnd = time();
|
} elseif ($_GET['time'] == 1) {
|
|
$timeBegin = mktime(0, 0, 0, date('m'), date('d'), date('y')) - 86400;
|
$timeEnd = mktime(23, 59, 59, date('m'), date('d'), date('Y')) - 86400;
|
} else {
|
|
$timeBegin = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - $_GET['time'] * 86400;
|
$timeEnd = mktime(23, 59, 59, date('m'), date('d'), date('Y'));
|
}
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['order_time'][] = array('>=', $timeBegin, '');
|
$where['order_time'][] = array('<=', $timeEnd, '');
|
$where['PHPYUNBTWEND_A'] = '';
|
$urlarr['time'] = urlencode($_GET['time']);
|
}
|
if ($_GET['stime']) {
|
|
$stime = explode('-', $_GET['stime']);
|
$etime = explode('-', $_GET['etime']);
|
|
$timeBegin = mktime(0, 0, 0, $stime[1], $stime[2], $stime[0]);
|
$timeEnd = mktime(23, 59, 59, $etime[1], $etime[2], $etime[0]);
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['order_time'][] = array('>=', $timeBegin, '');
|
$where['order_time'][] = array('<=', $timeEnd, '');
|
$where['PHPYUNBTWEND_A'] = '';
|
|
$urlarr['stime'] = urlencode($_GET['stime']);
|
$urlarr['etime'] = urlencode($_GET['etime']);
|
}
|
|
$where['groupby'] = 'date';
|
$urlarr = $_GET;
|
$urlarr['page'] = '{{page}}';
|
$pageurl = Url($_GET['m'], $urlarr, 'admin');
|
|
$limit = 10;
|
$page = $_GET['page'] < 1 ? 1 : $_GET['page'];
|
|
$rows = $companyorderM->getList($where, array('field' => "sum(order_price) as `num`,FROM_UNIXTIME(order_time,'%Y-%m-%d') as `date`"));
|
$num = count($rows);
|
$pages['total'] = $num;
|
|
if ($num > $limit) {
|
|
$pagenav = Page($page, $num, $limit, $pageurl, $notpl = false, $this->tpl, 'pagenav');
|
$pages['pages'] = ceil($num / $limit);
|
$this->yunset('pagenav', $pagenav);
|
}
|
|
if ($pages['total'] > 0) {
|
if ($_GET['order']) {
|
|
$where['orderby'] = $_GET['t'] . ',' . $_GET['order'];
|
$urlarr['order'] = $_GET['order'];
|
$urlarr['t'] = $_GET['t'];
|
} else {
|
|
$where['orderby'] = 'date';
|
}
|
|
$where['limit'] = array(($page - 1) * $limit, $page * $limit);
|
$orderRows = $companyorderM->getList($where, array('field' => "sum(order_price) as `num`,FROM_UNIXTIME(order_time,'%Y-%m-%d') as `date`, FROM_UNIXTIME(order_time,'%d') as `day`, FROM_UNIXTIME(order_time,'%m') as `month`, FROM_UNIXTIME(order_time,'%Y') as `year`"));
|
}
|
|
//支出
|
$owhere['order_state'] = 1;
|
|
if ($_GET['time']) {
|
if ($_GET['time'] == -1) {
|
|
$timeBegin = mktime(0, 0, 0, date('m'), date('d'), date('y'));
|
$timeEnd = time();
|
} elseif ($_GET['time'] == 1) {
|
|
$timeBegin = mktime(0, 0, 0, date('m'), date('d'), date('y')) - 86400;
|
$timeEnd = mktime(23, 59, 59, date('m'), date('d'), date('Y')) - 86400;
|
} else {
|
|
$timeBegin = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - $_GET['time'] * 86400;
|
$timeEnd = mktime(23, 59, 59, date('m'), date('d'), date('Y'));
|
}
|
$owhere['PHPYUNBTWSTART_A'] = '';
|
$owhere['time'][] = array('>=', $timeBegin, '');
|
$owhere['time'][] = array('<=', $timeEnd, '');
|
$owhere['PHPYUNBTWEND_A'] = '';
|
}
|
|
if ($_GET['stime']) {
|
|
$stime = explode('-', $_GET['stime']);
|
$etime = explode('-', $_GET['etime']);
|
|
$timeBegin = mktime(0, 0, 0, $stime[1], $stime[2], $stime[0]);
|
$timeEnd = mktime(23, 59, 59, $etime[1], $etime[2], $etime[0]);
|
$owhere['PHPYUNBTWSTART_A'] = '';
|
$owhere['time'][] = array('>=', $timeBegin, '');
|
$owhere['time'][] = array('<=', $timeEnd, '');
|
$owhere['PHPYUNBTWEND_A'] = '';
|
}
|
|
$owhere['groupby'] = 'date';
|
|
$fieldo = "sum(order_price) as `num`,from_unixtime(`time`,'%Y-%m-%d') as `date`";
|
$packM = $this->MODEL('pack');
|
$out = $packM->getList($owhere, array('field' => $fieldo));
|
$outArr = array();
|
foreach ($out as $r) {
|
$outArr [$r['date']] = $r['num'];
|
}
|
|
$swhere['order_state'] = 2;
|
$swhere['crm_uid'] = array('>', 0);
|
if ($_GET['time']) {
|
if ($_GET['time'] == -1) {
|
|
$timeBegin = mktime(0, 0, 0, date('m'), date('d'), date('y'));
|
$timeEnd = time();
|
} elseif ($_GET['time'] == 1) {
|
|
$timeBegin = mktime(0, 0, 0, date('m'), date('d'), date('y')) - 86400;
|
$timeEnd = mktime(23, 59, 59, date('m'), date('d'), date('Y')) - 86400;
|
} else {
|
|
$timeBegin = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - $_GET['time'] * 86400;
|
$timeEnd = mktime(23, 59, 59, date('m'), date('d'), date('Y'));
|
}
|
$swhere['PHPYUNBTWSTART_A'] = '';
|
$swhere['order_time'][] = array('>=', $timeBegin, '');
|
$swhere['order_time'][] = array('<=', $timeEnd, '');
|
$swhere['PHPYUNBTWEND_A'] = '';
|
}
|
if ($_GET['stime']) {
|
|
$stime = explode('-', $_GET['stime']);
|
$etime = explode('-', $_GET['etime']);
|
|
$timeBegin = mktime(0, 0, 0, $stime[1], $stime[2], $stime[0]);
|
$timeEnd = mktime(23, 59, 59, $etime[1], $etime[2], $etime[0]);
|
$swhere['PHPYUNBTWSTART_A'] = '';
|
$swhere['order_time'][] = array('>=', $timeBegin, '');
|
$swhere['order_time'][] = array('<=', $timeEnd, '');
|
$swhere['PHPYUNBTWEND_A'] = '';
|
}
|
$swhere['groupby'] = 'date';
|
$fields = "sum(order_price) as `num`, from_unixtime(`order_time`,'%Y-%m-%d') as `date`";
|
$salesmanOrder = $companyorderM->getList($swhere, array('field' => $fields));
|
$salesmanOrderArr = array();
|
foreach ($salesmanOrder as $r) {
|
$salesmanOrderArr[$r['date']] = $r['num'];
|
}
|
|
foreach ($orderRows as &$r) {
|
if (!isset($outArr[$r['date']])) {
|
|
$r['out'] = 0.00;
|
$r['total'] = $r['num'];
|
} else {
|
|
$r['out'] = $outArr[$r['date']];
|
$r['total'] = $r['num'] - $r['out'];
|
}
|
$r['salesmanNum'] = isset($salesmanOrderArr[$r['date']]) ? $salesmanOrderArr[$r['date']] : 0;
|
}
|
|
$orderRows = $this->getDetail($orderRows);
|
|
$this->yunset('order', $orderRows);
|
$this->yuntpl(array('admin/crm_audit'));
|
}
|
|
private function getDetail($rows){
|
|
$dateArr = array();
|
foreach ($rows as $k => $v) {
|
$dateArr[] = $v['date'];
|
}
|
$timeBegin = strtotime($dateArr[9]);
|
$timeEnd = strtotime($dateArr[0]);
|
$timeEnd = strtotime('+1 day', $timeEnd);
|
|
$orderM = $this->MODEL('companyorder');
|
|
if (isset($_GET['iscrm']) && $_GET['iscrm'] == 1){
|
|
$where['crm_uid'] = array('>', 0);
|
}
|
|
$where['order_state'] = 2;
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['order_time'][] = array('>=', $timeBegin, 'AND');
|
$where['order_time'][] = array('<=', $timeEnd, 'AND');
|
$where['PHPYUNBTWEND_A'] = '';
|
$where['orderby'] = 'order_time';
|
|
|
$orders = $orderM->getList($where, array('field' => '`id`,`uid`,`order_id`, order_price, order_type, order_time,`crm_uid`', 'utype' => 'crmaduit'));
|
|
foreach ($rows as $k => $v) {
|
foreach ($orders as $ok => $ov) {
|
if ($v['date'] == $ov['date']){
|
$rows[$k]['orders'][] = $ov;
|
}
|
}
|
}
|
return $rows;
|
}
|
|
public function detail_action()
|
{
|
|
$orderM = $this->MODEL('companyorder');
|
$where = $urlarr = array();
|
|
$where['type'] = 1;
|
$where['order_state'] = 2;
|
$where['crm_uid'] = array('>', 0);
|
|
if ($_GET['date']) {
|
|
$timeBegin = strtotime($_GET['date']);
|
$timeEnd = strtotime('+1 day', $timeBegin);
|
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['order_time'][] = array('>=', $timeBegin, 'AND');
|
$where['order_time'][] = array('<=', $timeEnd, 'AND');
|
$where['PHPYUNBTWEND_A'] = '';
|
$urlarr['date'] = $_GET['date'];
|
}
|
|
$urlarr['c'] = $_GET['c'];
|
$urlarr = $_GET;
|
$urlarr['page'] = '{{page}}';
|
$pageurl = Url($_GET['m'], $urlarr, 'admin');
|
|
$pageM = $this->MODEL('page');
|
$pages = $pageM->pageList('company_order', $where, $pageurl, $_GET['page']);
|
|
if ($pages['total'] > 0) {
|
if ($_GET['order']) {
|
|
$where['orderby'] = $_GET['t'] . ',' . $_GET['order'];
|
$urlarr['order'] = $_GET['order'];
|
$urlarr['t'] = $_GET['t'];
|
} else {
|
|
$where['orderby'] = 'order_time';
|
}
|
$where['limit'] = $pages['limit'];
|
|
$list = $orderM->getList($where, array('field' => '`id`,`uid`,`order_id`, order_price, order_time, `rating`,`crm_uid`', 'utype' => 'crmaduit'));
|
$this->yunset(array('order' => $list));
|
}
|
$this->yuntpl(array('admin/crm_audit_detail'));
|
}
|
}
|
