function listlogo()
{
echo parent::listimg();
}
public function agreeuser()
{
if (parent::isroot()) {
$id = I('id', '');
if ($id == '') {
$this->ajaxReturn("找不到该认证信息");
}
$user = M('Userinfo')->where(array('id' => $id))->find();
$datas['status'] = 3;
if (M('Userinfo')->where(array('id' => $id))->save($datas)) {
$this->ajaxReturn("同意修改");
} else {
$this->ajaxReturn("系统出错");
}
} else {
redirect(__ROOT__ . '/Public/error.html');
}
}
function listmonthtime()
{
if (parent::isroot()) {
} else {
redirect(__ROOT__ . '/Public/error.html');
return;
}
$refshopid = I('refshopid', '');
if ($refshopid != '') {
$datas['refshopid'] = $refshopid;
} else {
$this->ajaxReturn('No shopid');
//无店铺ID
}
$bt = I('bt', '');
$et = I('et', '');
if ($bt != '' and $et != '') {
} else {
//日期不完整
$this->ajaxReturn('date not complete');
}
try {
$data1 = explode('-', $bt);
$data2 = explode('-', $et);
$y1 = (int) $data1[0];
$m1 = (int) $data1[1];
$y2 = (int) $data2[0];
$m2 = (int) $data2[1];
} catch (Exception $e) {
//日期不正确
$this->ajaxReturn('date change error' . $e->getTrace());
}
if ($m1 <= 0 or $m1 > 12 or ($m2 <= 0 or $m2 > 12)) {
//月数不对
$this->ajaxReturn('month wrong');
}
if ($y1 > $y2) {
//年数不对
$this->ajaxReturn('year wrong');
} else {
if ($y1 == $y2) {
if ($m1 >= $m2) {
//年对、月不对
$this->ajaxReturn('year right month wrong');
}
} else {
}
}
$daylength = array();
/*从这里开始干活了*/
if ($y1 == $y2) {
for ($i = $y1; $i <= $y2; $i++) {
for ($j = $m1; $j <= $m2; $j++) {
if ($j < 10) {
$daylength[] = $i . '-0' . $j;
} else {
$daylength[] = $i . '-' . $j;
}
}
}
} else {
//2015-02**2016-08
for ($k = $m1; $k <= 12; $k++) {
if ($k < 10) {
$daylength[] = $y1 . '-0' . $k;
} else {
$daylength[] = $y1 . '-' . $k;
//20
}
}
for ($i = $y1 + 1; $i < $y2; $i++) {
for ($j = 1; $j <= 12; $j++) {
if ($j < 10) {
$daylength[] = $i . '-0' . $j;
} else {
$daylength[] = $i . '-' . $j;
}
}
}
for ($h = 1; $h <= $m2; $h++) {
if ($h < 10) {
$daylength[] = $y2 . '-0' . $h;
} else {
$daylength[] = $y2 . '-' . $h;
//20
}
}
}
/* $this->ajaxReturn($daylength);
return; */
$rows = array();
foreach ($daylength as $day) {
$isexist = M('qingmu.timer', 'oa')->where(array('shopid' => $refshopid, 'yearmonth' => $day))->find();
$updateid = 0;
$pai = 0;
if ($isexist) {
$paichustatus = $isexist['paichustatus'];
if ('0' === $paichustatus) {
$pai = 2;
//这个值好啊!!
}
// var_dump('0'===$paichustatus);
if ($isexist['status'] == 1 and $pai != 2) {
//last year data
$lastyear1 = explode('-', $day);
$lastyear2 = $lastyear1[0] - 1;
$lastyear = $lastyear2 . '-' . $lastyear1[1];
//var_dump($lastyear);
$qunian = M('qingmu.timer', 'oa')->where(array('shopid' => $refshopid, 'yearmonth' => $lastyear))->find();
//var_dump($qunian);
if ($qunian) {
$isexist['qcgmoney'] = $qunian['cgmoney'];
$isexist['qcgrate'] = $qunian['cgrate'];
$isexist['qsumrate'] = $qunian['sumrate'];
} else {
$isexist['qcgmoney'] = 'none';
$isexist['qcgrate'] = 'none';
$isexist['qsumrate'] = 'none';
}
$rows[] = $isexist;
continue;
} else {
$updateid = $isexist['id'];
$paichushijian = explode(',', $isexist['paichushijian']);
}
}
if (1 == 1) {
//开始插数据、处理数据
//笨蛋，不要看这里
/*CREATE TABLE `oatimer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`shopname` varchar(200) DEFAULT NULL COMMENT '店铺名',
`shopid` int(11) DEFAULT NULL COMMENT '店铺id',
`yearmonth` varchar(100) DEFAULT NULL COMMENT '月-年（2015-02）',
`day` varchar(100) DEFAULT NULL COMMENT '天(如果数据还没有到达月尾，则为那天,一般值为29,30,31）',
`cgrate` varchar(45) DEFAULT NULL COMMENT '常规完成率',
`sumrate` varchar(45) DEFAULT NULL COMMENT '总体完成率',
`cgmoney` varchar(45) DEFAULT NULL COMMENT '日成交额（常规平均,活动聚划算当天不算）',
`createtime` datetime DEFAULT NULL COMMENT '查询时间',
`updatetime` datetime DEFAULT NULL COMMENT '更新时间',
`username` varchar(64) DEFAULT NULL COMMENT '最后一次查询人',
`status` tinyint(4) DEFAULT NULL COMMENT '是否到达月尾（1表示已经到达月尾，0表示需要重新计算）',
`calday` tinyint(4) DEFAULT NULL COMMENT '该月常规天数',
`summonthmoney` decimal(19,2) DEFAULT NULL COMMENT '月累计销售额',
`sumcgmonthmoney` decimal(19,2) DEFAULT NULL COMMENT '月常规销售额',
`plan` decimal(19,2) DEFAULT NULL COMMENT '月总目标',
`lzcgplan` decimal(19,2) DEFAULT NULL COMMENT '常规目标',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OA时间序列预测统计数据表';*/
//SELECT * FROM qingmu.statshopdata where refShopId=91 and statDay like '2016-02-%' order by statDay desc;
//SELECT sum(sumcgmoney)/count(*) FROM qingmu.statshopdata where refShopId=8 and statDay like '2016-03-%' and sumjhsMoney=0 and sumhdMoney=0 order by statDay desc;
//这样算日常规很快
$sql1 = "refshopid=" . $refshopid . " and statday like '" . $day . "-%' and sumjhsmoney=0 and sumhdmoney=0";
if ($pai != 2) {
} else {
foreach ($paichushijian as $temp) {
$sql1 = $sql1 . " and statday not like '" . $day . "-" . $temp . "'";
//var_dump($sql1);
}
}
/* $this->ajaxReturn($sql1);return; */
$sql1rs = M('shopdata', 'stat', C('qingmu'))->where($sql1)->field("count(*) as calday, sum(sumcgmoney)/count(*) as cgmoney")->order("statday desc")->select();
$sql1r = $sql1rs[0];
//var_dump($sql1r);
/**************保护对象*******************/
//日成交额常规
$cgmoney = $sql1r['cgmoney'];
//该月常规天数
$calday = $sql1r['calday'];
/***************保护对象******************/
$sql2 = "refshopid=" . $refshopid . " and statday like '" . $day . "-%'";
$sql2rs = M('shopdata', 'stat', C('qingmu'))->where($sql2)->order("statday desc")->limit(1)->select();
if ($sql2rs == false) {
continue;
}
$sql2r = $sql2rs[0];
//var_dump($sql2r);
/**************保护对象*******************/
//月累计销售额
$summonthmoney = $sql2r['summonthmoney'];
//月常规销售额
$sumcgmonthmoney = $sql2r['sumcgmonthmoney'];
//常规完成率
$cgrate = 0;
//总体完成率
$sumrate = 0;
//月总目标
$plan = 0;
//常规目标
$lzcgplan = 0;
//当月最后一天
$lastday = $sql2r['statday'];
//是否已经是最后一天
$status = 0;
$shopname = '';
$shop = M('shop', 'ref', C('qingmu'))->where(array('id' => $refshopid))->find();
if ($shop) {
//店铺名
$shopname = $shop['sname'];
}
$mubiao = M('sellplan', 'stat', C('qingmu'))->where("refshopid=" . $refshopid . " and pmonth='" . $day . "'")->find();
if ($mubiao) {
//月总目标
$plan = $mubiao['plan'];
$sumrate = $summonthmoney / $plan;
//常规目标
$lzcgplan = $mubiao['lzcgplan'];
$cgrate = $sumcgmonthmoney / $lzcgplan;
//判断是否最后一天
$temp = explode('-', $lastday);
$tempy = $temp[0];
//2015
$tempm = $temp[1];
//05
$tempd = $temp[2];
//06
/*
* 这里傻逼放一个界定 是否最后一天的标记，排除BUG在此
*
* 还是不放了！！
* */
switch ($tempd) {
case '29':
if ($tempm == '02') {
if ($tempy % 100 == 0 and $tempy % 400 == 0 or $tempy % 100 != 0 and $tempy % 4 == 0) {
$status = 1;
} else {
$status = 0;
}
}
break;
case '28':
if ($tempm == '02') {
if ($tempy % 100 == 0 and $tempy % 400 == 0 or $tempy % 100 != 0 and $tempy % 4 == 0) {
$status = 0;
} else {
$status = 1;
}
}
break;
case '31':
if ($tempm == '01' or $tempm == '03' or $tempm == '05' or $tempm == '07' or $tempm == '08' or $tempm == '10' or $tempm == '12') {
$status = 1;
} else {
$status = 0;
}
break;
case '30':
if ($tempm == '04' or $tempm == '06' or $tempm == '09' or $tempm == '11') {
$status = 1;
} else {
$status = 0;
}
break;
default:
$status = 0;
}
}
//插数据、look hear
$data['day'] = $lastday;
$data['status'] = $status;
$data['shopname'] = $shopname;
$data['shopid'] = $refshopid;
$data['yearmonth'] = $day;
$data['cgrate'] = $cgrate;
$data['sumrate'] = $sumrate;
$data['cgmoney'] = $cgmoney;
$data['createtime'] = date("Y-m-d H:i:s", strtotime('now'));
$username = $_SESSION['username'];
$data['username'] = $username;
$data['status'] = $status;
$data['calday'] = $calday;
$data['summonthmoney'] = $summonthmoney;
$data['sumcgmonthmoney'] = $sumcgmonthmoney;
$data['plan'] = $plan;
$data['lzcgplan'] = $lzcgplan;
//var_dump($data);
if ($updateid != 0) {
$data['updatetime'] = date("Y-m-d H:i:s", strtotime('now'));
if ($pai == 2 and $status == 1) {
//没问题的
$data['paichustatus'] = 1;
} else {
if ($pai == 2 and $status == 0) {
//傻逼的最后一天
$data['paichustatus'] = 0;
} else {
$data['paichustatus'] = null;
//其他
}
}
$isexist1 = M('qingmu.timer', 'oa')->where('id=' . $updateid)->save($data);
$isexist1 = M('qingmu.timer', 'oa')->where('id=' . $updateid)->find();
$lastyear1 = explode('-', $day);
$lastyear2 = $lastyear1[0] - 1;
$lastyear = $lastyear2 . '-' . $lastyear1[1];
$qunian = M('qingmu.timer', 'oa')->where(array('shopid' => $refshopid, 'yearmonth' => $lastyear))->find();
if ($qunian) {
$isexist1['qcgmoney'] = $qunian['cgmoney'];
$isexist1['qcgrate'] = $qunian['cgrate'];
$isexist1['qsumrate'] = $qunian['sumrate'];
} else {
$isexist1['qcgmoney'] = 'none';
$isexist1['qcgrate'] = 'none';
$isexist1['qsumrate'] = 'none';
}
$rows[] = $isexist1;
} else {
$isexist1 = M('qingmu.timer', 'oa')->add($data);
$isexist2 = M('qingmu.timer', 'oa')->where(array('yearmonth' => $day, 'shopname' => $shopname))->find();
$lastyear1 = explode('-', $day);
$lastyear2 = $lastyear1[0] - 1;
$lastyear = $lastyear2 . '-' . $lastyear1[1];
$qunian = M('qingmu.timer', 'oa')->where(array('shopid' => $refshopid, 'yearmonth' => $lastyear))->find();
if ($qunian) {
$isexist2['qcgmoney'] = $qunian['cgmoney'];
$isexist2['qcgrate'] = $qunian['cgrate'];
$isexist2['qsumrate'] = $qunian['sumrate'];
} else {
$isexist2['qcgmoney'] = 'none';
$isexist2['qcgrate'] = 'none';
$isexist2['qsumrate'] = 'none';
}
$rows[] = $isexist2;
}
/***************保护对象******************/
}
// var_dump($day);
}
// $temp=var_dump($daylength);
$datajinhan['total'] = count($rows);
$datajinhan['rows'] = $rows;
$this->ajaxReturn($datajinhan);
}
public function deleteuser()
{
if (parent::isroot()) {
$id = I('id', '');
if ($id == '') {
$this->ajaxReturn("找不到用户");
}
$user = M('User')->where(array('id' => $id))->find();
if (in_array($user['username'], C('ADMIN_AUTH_KEY'))) {
$this->ajaxReturn("神一样的存在，不能删除");
}
$datas['status'] = 3;
if (M('User')->where(array('id' => $id))->save($datas)) {
$this->ajaxReturn("成功删除");
} else {
$this->ajaxReturn("删除失败");
}
} else {
redirect(__ROOT__ . '/Public/error.html');
}
}
