'0.42',
'100004' => '0.42',
'100005' => '0.42',
'100006' => '0.46',
'100007' => '0',
'100008' => '0.42',
'100010' => '0',
'100011' => '0.45',
'100020' => '0.42',
'100021' => '0.48',
'100022' => '0.42',
'100023' => '0.42',
'100025' => '0.7',
'100026' => '0.6',
'100030' => '0.65',
'100031' => '0',
'100032' => '0',
'100033' => '0.56',
'100035' => '0.45',
'100036' => '0.47',
'100037' => '0.63',
'100038' => '0.45',
'100050' => '0.45',
'100051' => '0',
'100053' => '0',
'100054' => '0',
'100055' => '0',
'100056' => '0.42',
'100057' => '0.42',
'100060' => '0.45',
'100061' => '0.45',
'100062' => '0.63',
'100063' => '0.63',
'100065' => '0.65',
'100068' => '0.42',
'100069' => '0.42',
'100073' => '0.65',
'100074' => '0',
'100075' => '0.45',
'100079' => '0.42',
'100080' => '0.42',
'100082' => '0.35',
'100083' => '0.65',
'100085' => '0.7',
'100086' => '0.65',
'100089' => '0.7',
'100092' => '0.45',
'100093' => '0.7',
'100094' => '0.35',
'100095' => '0.65',
'100096' => '0.7',
'100097' => '0.45',
'100098' => '0.5',
'100099' => '0.45',
'100100' => '0.45',
'100101' => '0.9',
'100102' => '0.65',
'100103' => '0.67',
'100104' => '0.35',
'100105' => '0.7',
'100106' => '0.7',
'100108' => '0.45',
'100110' => '0.5',
'100112' => '0.42',
'102001' => '0',
'102002' => '0.46',
'102008' => '0.65',
'102009' => '0',
'102010' => '0',
'102011' => '0.7',
'102013' => '0',
'102020' => '0.65'
);
//'100022' => '自家MM-幻想小勇士',
public $userLimit = array(
'mili' => '1',
'wcl' => '`产品号` <= 200000 AND `产品号` >= 100000',
'wcl2018' => '`产品号` <= 400000 AND `产品号` >= 300000',
'czq' => '`产品号` <= 800000 AND `产品号` >= 700000',
'hq' => '`产品号` <= 300000 AND `产品号` >= 200000',
'zry' => '`产品号` <= 600000 AND `产品号` >= 500000'
);
public $userLimitMin = array(
'mili' => 0,
'wcl' => 100000,
'wcl2018' => 300000,
'czq' => 700000,
'hq' => 200000,
'zry' => 500000
);
public $userLimitMax = array(
'mili' => 99999999,
'wcl' => 200000,
'wcl2018' => 400000,
'czq' => 800000,
'hq' => 300000,
'zry' => 600000
);
public $codeLookUpTable = array(
'100003' => '自家-开放平台-',
'100004' => '自家-开放平台-',
'100005' => '向总-天翼空间',
'100006' => '广州朗天-混合代码',
'100007' => '千禧-IDO',
'100008' => '自家-爱动漫',
'100010' => '考拉-DDO',
'100011' => '考拉-IDO',
'100020' => '自家MM-轻松躲避',
'100021' => '自家MM-悟空消消乐',
'100022' => '自家MM-极速穿越者',
'100023' => '自家MM-跑跑更健康',
'100025' => '快点-视频包月',
'100026' => '掌握-视频包月',
'100030' => '刘文林-手机报',
'100031' => '黄海波-RDO',
'100032' => '赞成科技-天翼阅读',
'100033' => '定位通-DDO',
'100035' => '华策-RDO',
'100036' => '新梦-页游',
'100037' => '非同凡响哲信-音乐',
'100038' => '掌游-RDO',
'100050' => '掌游动漫',
'100051' => '博瑞RDO',
'100053' => '赞成科技-天翼空间',
'100054' => '凤凰阅读',
'100055' => '凡山书城',
'100056' => '自家动漫-励才漫画',
'100057' => '自家动漫-鼎通-保卫萝卜',
'100060' => '动漫-哲信',
'100061' => 'MM弱联网-掌游',
'100062' => '赞成科技视频-中报',
'100063' => '赞成科技视频-环球',
'100064' => '哲信-DDO包月',
'100065' => '黄海波-IDO无比乐',
'100066' => '应美-阅读包月-吴晓波悦读会',
'100067' => '应美-阅读包月-理想谷悦读汇',
'100068' => '自家动漫-励才漫画-恒大',
'100069' => '自家动漫-励才漫画-咕噜',
'100070' => '应美-阅读包月-咪咕萤石',
'100071' => '应美-阅读包月-理想谷悦读会10元',
'100072' => '哲信-音乐-天天壁纸',
'100073' => '黄海波-IDO可米酷',
'100074' => '黄海波-音乐',
'100075' => '向前-API接口',
'100076' => '博士通动漫包月api',
'100077' => '哲信mm白名单',
'100078' => '哲信联合会员包',
'100079' => '自家动漫-迅速躲西门吹风版',
'100080' => '自家动漫-指点漫画',
'100081' => '向前-动漫包月api',
'100082' => '考拉-MM弱联网',
'100083' => '哲信-IDO包月',
'100084' => '考拉-MM弱联网10元',
'100085' => '米馥-IDO',
'100086' => '黄海波-IDO体育会员',
'100087' => '哲信-RDO',
'100089' => '玩乐汇-音乐',
'100092' => '龙芩mm白名单',
'100093' => '龙芩联合会员包',
'100094' => '绿通短代',
'100095' => '麦广ido',
'100096' => '黄海波-ido新浪微博',
'100097' => '鼎通联通api',
'100098' => '鼎通电信api',
'100099' => '平治沃听书',
'100100' => '平治天翼空间',
'100101' => '哲信天翼视讯',
'100102' => '米点联通玩乐付',
'100103' => '海波视频包月',
'100104' => '哲信rdo-搜小说',
'100105' => '杰游IDO',
'100106' => '掌游电信天翼空间',
'100108' => '麦广MDO',
'100110' => '迅点API',
'100112' => '杰游MDO',
'900004' => '奇葩-sdk',
'900005' => '微云-sdk',
'900006' => '泰酷-sdk',
'900007' => '米玩-sdk',
'102001' => '赞成科技-小沃',
'102002' => '自家-联通华为WO+',
'102008' => '赞成科技-在信',
'102009' => '赞成科技-三网',
'102010' => '信通',
'102011' => '赞成科技-WO阅读',
'102013' => '信通SB代码',
'102020' => '自家-小沃-雷电战机传奇'
);
public $haqingchanel = array(
"0" => array (
"2014",
"2014搜狐",
),
"1" => array (
"2015",
"2015搜狗",
)
);
public $haqingyouxiproduct = array(
"0" => array (
"200093",
"超级萝卜保卫战2",
),
"1" => array (
"200081",
"雷电战机-传奇",
),
"2" => array (
"200092",
"植物大战怪兽全明星",
),
"3" => array (
"200033",
"消灭糖果3奇幻之旅",
),
"4" => array (
"200070",
"豪华竞速",
),
"5" => array (
"200032",
"萌果爱消除",
),
"6" => array (
"200101",
"萝卜保卫战",
),
"7" => array (
"200082",
"雷电风云战机",
),
"8" => array (
"200094",
"植物大战怪兽",
),
"9" => array (
"200096",
"萝卜保卫战3",
),
"10" => array (
"200084",
"超级雷电(雷霆版)",
),
"11" => array (
"200098",
"萝卜保卫战3(2)",
),
"12" => array (
"200099",
"植物大战怪兽全明星(2)",
),
"13" => array (
"200100",
"糖果开心传奇",
),
"14" => array (
"200102",
"开心萌消消",
),
"15" => array (
"200103",
"激烈竞速",
)
);
public $haqingyouxiNumber = array(
'0' => '200093',
'1' => '200081',
'2' => '200092',
'3' => '200033',
'4' => '200070',
'5' => '200032',
'6' => '200101'
);
public $haqingyouxiName = array(
'0' => '超级萝卜保卫战2',
'1' => '雷电战机-传奇',
'2' => '植物大战怪兽全明星',
'3' => '消灭糖果3奇幻之旅',
'4' => '豪华竞速',
'5' => '萌果爱消除',
'6' => '贪吃蛇大作战2017'
);
public $specialNumber = array(
'0' => '礼包间隔时间',
'1' => 'BC中B礼包出现比例',
'2' => '单用户计费上限',
'3' => '基地计费间隔',
'4' => '礼包A资费',
'5' => '礼包B资费',
'6' => '礼包C资费',
'7' => '礼包D资费',
'8' => '礼包E资费',
'9' => 'AE中A礼包出现机率',
'10' => 'AE礼包调用基地机率',
'11' => '游戏过程中调用礼包概率',
);
public $specialNumberDefault = array(
'0' => '20',
'1' => '20',
'2' => '6000',
'3' => '60',
'4' => '2000',
'5' => '2000',
'6' => '1500',
'7' => '2000',
'8' => '1500',
'9' => '80',
'10' => '70',
'11' => '100'
);
public $downChannelList = array(
'1002' => '精众',
'1015' => '微游2',
'1016' => '华为',
'1017' => '优投',
'1018' => '聚优',
'1019' => '动信通',
'1020' => '万普',
'1021' => '道有道',
'1022' => '九俊',
'1034' => '微游',
'1035' => '掌众',
'1036' => '多讯',
'1037' => '米饭',
'1038' => '移触',
'1039' => '麒逆',
'1040' => '天宝',
'1041' => '优投',
'1042' => '测试',
'1058' => '掌鸿',
'1059' => '欢趣',
'1099' => '刷卡'
);
public $upChannelList = array(
'2000' => '百度91',
'2001' => '百度多酷',
'2002' => '百度手机助手',
'2003' => '百度贴吧',
'2004' => '拇指玩',
'2005' => '魅族',
'2006' => '搜游',
'2007' => '腾讯应用商店',
'2008' => '腾讯浏览器',
'2009' => '腾讯游戏中心',
'2010' => '腾讯内部2',
'2011' => '腾讯视频',
'2012' => '腾讯应用宝',
'2013' => '掌星立意900',
'2014' => '搜狐',
'2015' => '搜狗游戏大厅',
'2016' => '搜狗搜索',
'2017' => '搜狗手机助手',
'2018' => '搜狗浏览器九宫格',
'2019' => '指点',
'2020' => '阿里云',
'2021' => '野火',
'2022' => 'QQ管家',
'2023' => '三星',
'2024' => '青柠创享',
'2025' => '天天游戏',
'2026' => 'oppo',
'2027' => 'vivo',
'2028' => '华为',
'2029' => '金立',
'2030' => '小米',
'2032' => '阿里',
'2033' => '4399',
'2034' => '安智',
'2035' => '掌众'
);
public $threeName = array(
"SB","250","111","222"
);
public $SecondName=array("0" => array (
"开关",
"计费代码",
"收入列表",
"代码省份分析"
),
"1" => array (
"16数据10月数据",
"二级分类",
"二级分类",
"二级分类"
),
"2" => array (
"代码",
"代码",
"代码",
"代码"
)
);
public $TableHeader=array("0" => array (
"日期",
"时间",
"IMSI",
"计费代码",
"产品号",
"渠道号",
"价格",
"运营商",
"IP地区",
"手机归属地",
"机型"
),
"1" => array (
"运营商",
"产品名",
"产品号",
"渠道号",
"开关",
"IP屏蔽省",
"归属地屏蔽省",
"黑包屏蔽省",
"开通时间",
"特殊屏蔽"
),
"2" => array (
"代码编号",
"代码名称",
"屏蔽归属地",
"开通时间段",
"日限",
"月限",
"运营商"
),
"3" => array (
"代码编号",
"屏蔽归属地",
"开通时间",
"日限",
"月限",
"运营商"
),
"4" => array (
"日期",
"产品名",
"渠道号",
"启动次数",
"启动用户数",
"新增用户数",
"返回代码数用户数",
"点击用户数",
"人均点击计费点次数",
"策略率",
"ARPU",
"支付人数",
"ARPPU",
"MR",
"溢出率",
"收款",
"平台新增用户数"
),
"5" => array (
"名称",
"代码编号",
"符合省份用户数(新增)",
"请求MO次数",
"请求MO人数",
"请求MO",
"成功MO次数",
"成功MO人数",
"成功MO",
"MR次数",
"MR人数",
"MR",
"收款",
"ARPPU",
"计费成功率(用户)",
"计费成功率(金额)",
"代码效率",// MR次数/成功MO次数
"新增用户到成功用户转化率",//付费用户/新增用户数
"符合用户数ARPU"
),
"6" => array (
"日期",
"产品名",
"渠道号",
"启动次数",
"启动用户数",
"新增用户数",
"返回代码数用户数",
"点击用户数",
"人均点击计费点次数",
"策略率",
"ARPU",
"MR",
"收款"
),
"7" => array (
"省份",
"新增人数",
"启动人数",
"请求MO次数",
"请求MO人数",
"成功MO次数",
"成功MO人数",
"MR次数",
"MR人数",
"MR",
"ARPU",
"ARPPU",
"计费成功率(用户)",
"计费成功率(金额)"
),
"8" => array(
"全省份","北京", "天津", "河北", "山西", "内蒙古", "辽宁", "吉林",
"黑龙江", "上海", "江苏", "浙江", "安徽", "福建", "江西", "山东", "河南", "湖北", "湖南",
"广东", "广西", "海南", "四川", "贵州", "云南", "西藏", "陕西", "甘肃", "青海", "宁夏",
"新疆", "重庆"
),
"9" => array(
"无","上线", "审核"
)
);
private $proListMove = array("北京", "天津", "河北", "山西", "内蒙古", "辽宁", "吉林",
"黑龙江", "上海", "江苏", "浙江", "安徽", "福建", "江西", "山东", "河南", "湖北", "湖南",
"广东", "广西", "海南", "四川", "贵州", "云南", "西藏", "陕西", "甘肃", "青海", "宁夏",
"新疆", "重庆");
//黑包屏蔽省份 theOpenEdit显示的省份数
private $proListMove2 = array("北京", "天津", "河北", "山西", "内蒙古", "辽宁", "吉林",
"黑龙江", "上海", "江苏", "浙江", "安徽", "福建", "江西", "山东", "河南", "湖北", "湖南",
"广东", "广西", "海南", "四川", "贵州", "云南", "西藏", "陕西", "甘肃", "青海", "宁夏",
"新疆", "重庆", "无");
private $theOpenTimeArray = array(
"00","01","02","03","04","05","06","07","08","09","10","11",
"12","13","14","15","16","17","18","19","20","21","22","23",
);
public $chooseNumberSheildSpecilArray = array(
"广东9-21","北京全天","上海9-21","重庆9-21","天津9-21",
"南京9-21","杭州9-21","长沙9-21","武汉9-21","合肥9-21",
"厦门9-21","福州9-21","沈阳9-21","大连9-21","苏州9-21",
"成都9-21","海口9-21","石家庄9-21"
);
public $chooseNumberSheildSpecilArraytheValue = array(
"01","02","03","04","05",
"06","07","08","09","10",
"11","12","13","14","15",
"16","17","18"
);
public function forwuzhong($CodeNumber = 0){
$willLikeDb = "代码";
$m=M($willLikeDb);
if($CodeNumber == 0){
$willLikeDb = "开关";
$list = $m->query("SELECT * FROM `$willLikeDb` ");
//表头数组
$tableheader = array('IMSI', '记费代码', '时间戳', '日期', 'price', 'pid', 'IP省', 'IP市', '运营商', '时间', '渠道号', 'IMEI', '产品号', 'ICCID', '机型', 'ICCID省', 'fail', 'op', '是第几次请求', '手机号', 'orderId');
}else{
$willLikeDb = "1706其他请求付费";
$list = $m->query("SELECT * FROM `$willLikeDb` ORDER BY `时间戳` DESC ");
//表头数组
$tableheader = array('IMSI', '时间戳', '时间', '日期', 'price', '归属地', '运营商', '返回代码编号', 'ICCID', '产品号', '渠道号', '是第几次请求', '返回价格', 'IP省', 'IP市', '机型', '错误描述', 'orderId', 'mobile', 'tempNumber', 'myid');
}
//创建对象
$excel = new \PHPExcel();
//Excel表格式,这里简略写了8列
$letter = array('A','B','C','D','E','F','F','G');
for($i = 0;$i < 25;$i++){
$letter[$i] = chr(65+$i);
}
//填充表头信息
for($i = 0;$i < count($tableheader);$i++) {
$excel->getActiveSheet()->setCellValue("$letter[$i]1","$tableheader[$i]");
}
//表格数组
$data = $list;
//填充表格信息
for ($i = 2;$i <= count($data) + 1;$i++) {
$j = 0;
foreach ($data[$i - 2] as $key=>$value) {
$excel->getActiveSheet()->setCellValue("$letter[$j]$i","$value");
$j++;
}
}
//创建Excel输入对象
$write = new \PHPExcel_Writer_Excel5($excel);
header("Pragma: public");
header("Expires: 0");
header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");
if($CodeNumber == 0){
header('Content-Disposition:attachment;filename="1706OtherData.xls"');
}else{
header('Content-Disposition:attachment;filename="1706其他请求付费.xls"');
}
header("Content-Transfer-Encoding:binary");
$write->save('php://output');
}
public function Percentage($CodeNumber,$CodeNumber2 = 10,$tempCheckDate = '2016/12/01'){
//isInString
// $Percentage; Province
$t=time();//为这次访问的时间数据 date('Y-m-d H:i:s',"1228348800");
/*
$tempop = I('post.op','3','htmlspecialchars');
$tempChanel = I('post.chanel','10','htmlspecialchars');
$tempProductID = I('post.productID','10','htmlspecialchars');
$tempCheckDate = I('post.checkDate','2016/12/01','htmlspecialchars');
if('100' > $tempChanel){
$chanel = "1";
$tempChanel = "";
}else{
$chanel = "(`渠道号` = '$tempChanel')";
}
if('100' > $tempProductID){
$ProductID = "1";
$tempProductID = "";
}else{
$ProductID = "(`产品号` = '$tempProductID')";
}
if('1' > $tempop){
$op = "1";
$tempop = "";
}else{
$op = "(`运营商` = '$tempop')";//1移动 2联通 3电信 or die("Error in query: $query. ".mysql_error())
}
*/
if('1' > $tempCheckDate){
$checkDate = "1";
$tempCheckDate = date("Y-m",$t);
}else{
$tempabc = (strtotime($tempCheckDate." 12:00:00"));
$tempCheckDate = date("Y-m-d",$tempabc);
$checkDate = "`日期` = '$tempCheckDate'";//1移动 2联通 3电信 or die("Error in query: $query. ".mysql_error())
}
$checkDate = "`日期` = '$tempCheckDate'";
$tBeiJing = (strtotime($tempCheckDate." 12:00:00"));
$list = $m->query("SELECT distinct `IMSI`,`日期`,`时间戳`,`渠道号`,`产品号` FROM `$willLikeDb` WHERE $op AND $chanel AND $ProductID GROUP BY `IMSI` ORDER BY `$willLikeDb`.`时间戳` ASC");
//echo count($list);echo '
';
$tempnumber1 = 0;
foreach ($list as $value){
//var_dump ($value);
if ($value["日期"] == $tempCheckDate){
$tempnumber1 = $tempnumber1+1;
}
}
$willLikeDb = date("ym",$tBeiJing);
$willLikeDb = $willLikeDb."请求付费次数";
$m=M($willLikeDb);
$where = "$checkDate ";
$list1=$m->field(true)->where($where)->order('时间戳 DESC')->select();
$theAllClickNumber = count($list);//总点击计费点次数
$linkName = "返回代码编号";
$daimalink = "(`$linkName` LIKE '%$CodeNumber%')"; // 这里写返回代码编号
$where = "$op AND $checkDate AND $chanel AND $ProductID AND $daimalink";
$list2=$m->field(true)->where($where)->order('时间戳 DESC')->select();
$theSuccessClickNumber = count($list);//点击计费点成功次数
$willLikeDb = date("ym",$tBeiJing);
$willLikeDb = $willLikeDb."数据";
$tempNumberA = 0;
foreach ($proListMove as $value){
$theMoNumberQust[$tempNumberA] = $list1;
$theMoNumberSuccess[$tempNumberA] = $list1;
$theMRNumber[$tempNumberA] = $list1;
if ($value["ICCID省"] == $tempProvince){
$tempnumber1 = $tempnumber1+1;
}
$theResult1 ="";
$theResult2 ="";
}
return Percentage;
}
public function getTheNumberProvince($list,$tempProvince){
$tempnumber1 = 0;
foreach ($list as $value){
if ($value["归属地"] == $tempProvince){
$tempnumber1 = $tempnumber1+1;
}
}
return $tempnumber1;
}
public function getTheNumberProvince2($list,$tempProvince){
$tempnumber1 = 0;
foreach ($list as $value){
if ($value["ICCID省"] == $tempProvince){
$tempnumber1 = $tempnumber1+1;
}
}
return $tempnumber1;
}
public function index(){
$UseNumberT = 0;//使用第几套显数据
//parent::__construct();
//$FirstName3344 = $this->FirstName3344;
//$this->FirstName3344 = "cccc";
//dump($this->FirstName[123]);
//dump($this->FirstName[0]);
$User = M("1610数据"); // 实例化User对象
$User->where('1')->select();
echo $User;
$Result123 = $User->select();
$Data = M("1610数据"); // 实例化Data数据对象 date 是你的表数据
import('ORG.Util.Page');// 导入分页数据
$count = $Data->where($map)->count();// 查询满足要求的数据�记录数 $map表示查询条件
//$Page = new Page($count);// 实例化分页类 传入总记录数
$page = new \Think\Page($count);
//$show = $Page->show();// 分页显示输出
// 进行分页数据查询
$list = $Data->where($map)->order('IMSI')->limit($Page->firstRow.','.$Page->listRows)->select(); // $Page->firstRow 起始条数 $Page->listRows 获取多少数据
$this->assign('list',$list);// 赋数据�数据集
$this->assign('page',$show);// 赋数据�分页输数据
$Name = $Result123[1]["日期"];
//$Name = 12321;
$t=time();//为这次访问的时间数据
$tBeiJing=$t+21600;
$willLikeDb = date("ym",$tBeiJing);
$willLikeDb = $willLikeDb."数据";
//这里查进行分数据
$where = "1";
$m=M($willLikeDb);
$p=IndexController::getpageA($m,$where,10);
//$list=$m->field(true)->where($where)->order('IMEI desc')->select();
$list=$m->field(true)->order('时间 desc')->select();
$this->list=$list;
$this->page=$p->show();
//$this->assign('list',$list);
//$this->assign('page', $p->show());
//上面查进行分数据
$willShowDbName = date("y年m数据",$tBeiJing);
$willShowDbName = $willShowDbName."用户付费数据";
$this->assign('willShowDbName',$willShowDbName);
//$FirstName332244 = $this->FirstName3344;
//$FirstName3344= "333";
$i = 0;
foreach ($this->FirstName as $value3321) {
$this->assign('FirstName'.$i,$this->FirstName[$i]);$i++;
}
$i = 0;$j = 0;
foreach ($this->SecondName as $value3321) {
for ($j = 0;$j<4;$j++) {
$this->assign('SecondName'.$i.'A'.$j,$this->SecondName[$i][$j]);
}
$i++;
}
$this->assign('TableHeader',$this->TableHeader[$UseNumberT]);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "我日了你狗";
$this->assign('name',$Name);
$this->display();
}
public function verifyPassword(){
// 2014-搜狐 2015-搜狗游戏大厅
if (isset($_POST['myID']) && isset($_POST['myPassword']) && isset($_POST['checkCode'])){
if($_POST['myID'] == "mofeng" && $_POST['myPassword'] == "mofeng753" && session('verification') == md5($_POST['checkCode']) ){
session('name',5);
}else if($_POST['myID'] == "mili" && $_POST['myPassword'] == "mi789852" && session('verification') == md5($_POST['checkCode']) ){
session('name',6);
session('userName',"mili");
}else if($_POST['myID'] == "wcl" && $_POST['myPassword'] == "wcl789654" && session('verification') == md5($_POST['checkCode']) ){
session('name',6);
session('userName',"wcl");
}else if($_POST['myID'] == "wcl2018" && $_POST['myPassword'] == "wcl789654" && session('verification') == md5($_POST['checkCode']) ){
session('name',6);
session('userName',"wcl");
}else if($_POST['myID'] == "czq" && $_POST['myPassword'] == "czq741258" && session('verification') == md5($_POST['checkCode']) ){
session('name',6);
session('userName',"czq");
}else if($_POST['myID'] == "hq" && $_POST['myPassword'] == "hq159357" && session('verification') == md5($_POST['checkCode']) ){
session('name',6);
session('userName',"hq");
}else if($_POST['myID'] == "zry" && $_POST['myPassword'] == "zry3422566" && session('verification') == md5($_POST['checkCode']) ){
session('name',6);
session('userName',"zry");
}else if($_POST['myID'] == "tiantain" && $_POST['myPassword'] == "tiantain666" && session('verification') == md5($_POST['checkCode']) ){
session('name',3);
}else if($_POST['myID'] == "shouhu" && $_POST['myPassword'] == "shouhu652" && session('verification') == md5($_POST['checkCode']) ){
session('name',3);
session('chanel',2014);
}else if($_POST['myID'] == "shougou" && $_POST['myPassword'] == "shougou1122" && session('verification') == md5($_POST['checkCode']) ){
session('name',3);
session('chanel',2015);
}else if($_POST['myID'] == "shougouG2" && $_POST['myPassword'] == "shougou2017" && session('verification') == md5($_POST['checkCode']) ){
session('name',3);
session('chanel',2016);
}
else{
session('name',2);echo "error!not have ID or Password or CheckCode";
}
}else{
session('name',2);echo "error!not have ID or Password or CheckCode";
}
if(isset($_POST['password'])){
if($_POST['password'] == 0){
header("Location:".$this->myIP."app/index.php/Home/Index/spIncom");
}else if($_POST['password'] == 1){
header("Location:".$this->myIP."app/index.php/Home/Index/chaneldata");
}else if($_POST['password'] == 2){
header("Location:".$this->myIP."app/index.php/Home/Index/chanelcheck");
}
}else{
header("Location:".$this->myIP."app/index.php/Home/Index/chanelcheck");
}
}
public function inputPassword(){//传入URL
if( session('name') < 4){
echo "
";
die("用户登陆");
}
if( session('name') == 2){
echo "error ID or Password or CheckCode
";
die("用户登陆");
}
}
public function inputPassword2($passwordWillGo){//传入URL
if( session('name') < 1){
echo "";
die("用户登陆");
}
if( session('name') == 2){
echo "error ID or Password or CheckCode
";
die("用户登陆");
}
}
public function registerTheTitle($UseNumberT,$tBeiJing){
//页面显示的可查数数据
for ($i = 0; $i < 4; $i++) {
$tempYear = (Int)(date("y",$tBeiJing));
$tempYue = (Int)(date("m",$tBeiJing)) - $i;
if($tempYue < 1){
$tempYue = $tempYue + 12;
$tempYear = $tempYear - 1;
}
$tempYueSring = "0";
if ($tempYue < 10){
$tempYueSring = "0".(String)($tempYue % 12);
}else {
$tempYueSring = (String)($tempYue % 12);
}
if($tempYueSring == 0){$tempYueSring = 12;}
$tempYearSring = (String)($tempYear);
$tempWillLikeDb = $tempYearSring.$tempYueSring;
$this->SecondName[1][$i] = $tempWillLikeDb;
//dump($this->SecondName[1][$i]);
}
$i = 0;
foreach ($this->FirstName as $value3321) {
$this->assign('FirstName'.$i,$this->FirstName[$i]);$i++;
}
$i = 0;$j = 0;
foreach ($this->SecondName as $value3321) {
for ($j = 0;$j<4;$j++) {
$this->assign('SecondName'.$i.'A'.$j,$this->SecondName[$i][$j]);
}
$i++;
}
//var_dump($this->threeName);
$this->assign('threeName',$this->threeName);
$this->assign('willLikeDbNumber',$willLikeDbNumber);
$this->assign('TableHeader',$this->TableHeader[$UseNumberT]);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
}
public function theData($lookData="1610",$timeStamp="999",$theIMSI="999"){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$UseNumberT = 0;//使用第几套显数据
$t=time();//为这次访问的时间数据
$tBeiJing=$t+21600;
if (strlen($lookData)!=4){
$willLikeDbNumber = date("ym",$tBeiJing);
$willLikeDb = $willLikeDbNumber."数据";
}else{
$willLikeDbNumber = $lookData;
$willLikeDb = $lookData."数据";
}
/*
//这里查进行分数据
$m=M($willLikeDb);
//$list=$m->field(true)->where($where)->order('IMEI desc')->select();
if ($timeStamp == "999" && $theIMSI == "999"){
$p=IndexController::getpageA($m,$where,50);
$list=$m->field(true)->order('时间戳 desc')->select();
}else {
if($timeStamp != "999"){
$tBeiJingtheimte = (Int)($timeStamp)+21600;
$tempYearMoonDay = (date("Y-m-d",$tBeiJingtheimte));
$is_date=strtotime($tempYearMoonDay)?strtotime($tempYearMoonDay):false;
$is_date = $is_date - 21600;
$is_date2 = $is_date + 86400;
$tiaojian1 = '时间戳 > '."$is_date"." AND ".'时间戳 < '."$is_date2";
}
if($theIMSI != "999"){
$tiaojian2 = 'IMSI = '."$theIMSI";
}
//$where = '日期 = '."$tempYearMoonDay"." AND ".'IMSI = '."$theIMSI";
if($tiaojian2 != null){
$where = $tiaojian1." AND ".$tiaojian2;
echo "执行的这";
}else{
$where = $tiaojian1;
echo "tiaojian2出错";
}
$p=IndexController::getpageA($m,$where,100);
$list=$m->field(true)->where($where)->order('时间戳 desc')->select();
}
$this->list=$list;
$this->page=$p->show();
//上面查进行分数据
*/
$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/check");//查询对应的HTTP界面
$willShowDbName = $lookData."用户付费数据";
$this->assign('willShowDbName',$willShowDbName);//表头名
$this->assign('lookData',$lookData);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->display();
}
public function check(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$UseNumberT = 4;//使用第几套显数据
$tempChanel = I('post.chanel','10','htmlspecialchars');
$tempProductID = I('post.productID','10','htmlspecialchars');
$tempCheckDate = I('post.checkDate','2016/12/01','htmlspecialchars');
$tempop = I('post.op','3','htmlspecialchars');
$t=time();//为这次访问的时间数据 date('Y-m-d H:i:s',"1228348800");
if('100' > $tempChanel){
$chanel = "1";
$tempChanel = "";
}else{
$chanel = "(`渠道号` = '$tempChanel')";
}
if('100' > $tempProductID){
$ProductID = "1";
$tempProductID = "";
}else{
$ProductID = "(`产品号` = '$tempProductID')";
}
if('1' > $tempop){
//$op = "1"; //晕
$op = "(`运营商` = '1')";
$tempop = "";
}else{
$op = "(`运营商` = '$tempop')";//1移动 2联通 3电信 or die("Error in query: $query. ".mysql_error())
}
if('1' > $tempCheckDate){
$checkDate = "1";
$tempCheckDate = date("Y-m",$t);
}else{
$tempabc = (strtotime($tempCheckDate." 12:00:00"));
$tempCheckDate = date("Y-m-d",$tempabc);
$checkDate = "`日期` = '$tempCheckDate'";//1移动 2联通 3电信 or die("Error in query: $query. ".mysql_error())
}
if('1' > $tempop){
$dateOp = "1";
}else{
$dateOp = "(`op` = '$tempop')";//1移动 2联通 3电信 or die("Error in query: $query. ".mysql_error())
}
//var_dump ($tempCheckDate);
$tBeiJing = (strtotime($tempCheckDate." 12:00:00"));
//echo $ProductID.$chanel.$checkDate.$op;echo '
';
$willLikeDb = date("ym",$tBeiJing);
$willLikeDb = $willLikeDb."激活数据";//echo $willLikeDb;
//换表查询数据 18/07/12后
if($tempCheckDate >= date("Y-m-d",(strtotime("2018/07/12"." 12:00:00")))){
$willLikeDb = $willLikeDb."1";
}
//echo "表名=".$willLikeDb;
//echo "表--".$willLikeDb;
$m=M($willLikeDb);
$where = "$op AND $checkDate AND $chanel AND $ProductID";
//echo "where==".$where;
$list=$m->field(true)->where($where)->select();
//var_dump($list);
$startNumber = count($list);//启动次数 $list=$m->field(true)->where($where)->order('时间戳 DESC')->select();
$list=$m->distinct(true)->field('IMSI')->where($where)->group(`IMSI`)->select();
$startUserNumber = count($list);//启动用户数 var_dump($list);echo $startUserNumber;
//$where = "$op AND $chanel AND $ProductID";
//$list=$m->distinct(true)->field('`IMSI`,`日期`,`时间戳`,`渠道号`,`产品号`')->where($where)->group(`IMSI`)->order('时间戳 ASC')->select();
$list = $m->query("SELECT distinct `IMSI`,`日期`,`时间戳`,`渠道号`,`产品号` FROM `$willLikeDb` WHERE $op AND $chanel AND $ProductID GROUP BY `IMSI` ORDER BY `$willLikeDb`.`时间戳` ASC");
//echo count($list);echo '
';
$tempnumber1 = 0;
foreach ($list as $value){
//var_dump ($value);
if ($value["日期"] == $tempCheckDate){
$tempnumber1 = $tempnumber1+1;
}
}
//var_dump($tempCheckDate);
$appUserNumber = $tempnumber1;//新增用户数
// echo "启动次数="."$startNumber","
";
// echo "新增="."$appUserNumber","
";
$willLikeDb = date("ym",$tBeiJing);
$willLikeDb = $willLikeDb."请求付费次数";
$m=M($willLikeDb);
$where = "$op AND $checkDate AND $chanel AND $ProductID";
$list=$m->field(true)->where($where)->order('时间戳 DESC')->select();
$theAllClickNumber = count($list);//总点击计费点次数
$linkName = "返回代码编号";
$daimalink = "(`$linkName` LIKE '%100003%' OR `$linkName` LIKE '%100004%' OR `$linkName` LIKE '%100005%' OR `$linkName` LIKE '%100006%')"; // 这里写返回代码编号
$where = "$op AND $checkDate AND $chanel AND $ProductID AND $daimalink";
$list=$m->field(true)->where($where)->order('时间戳 DESC')->select();
$theSuccessClickNumber = count($list);//点击计费点成功次数
$list=$m->field(true)->where($where)->order('时间戳 DESC')->sum('price');
$askMo = $list;//请求MO
// 这里要注意,这里会多写几个变量,用来记录 各代码的成功率 0代表返回本代码多少次 1代表本代码成功多少次 2代表此代码失败多少次
$daimalink = "(`$linkName` LIKE '%100003%' OR `$linkName` LIKE '%100004%' )";
$list=$m->field(true)->where("$op AND $checkDate AND $chanel AND $ProductID AND $daimalink")->order('时间戳 DESC')->select();
$xingyuan0 = count($list);
$daimalink = "(`$linkName` LIKE '%100006%')";
$list=$m->field(true)->where("$op AND $checkDate AND $chanel AND $ProductID AND $daimalink")->order('时间戳 DESC')->select();
$langtian0 = count($list);
$daimalink = "(`$linkName` LIKE '%100005%')";
$list=$m->field(true)->where("$op AND $checkDate AND $chanel AND $ProductID AND $daimalink")->order('时间戳 DESC')->select();
$tianyi0 = count($list);
//以上为记录结束
$willLikeDb = date("ym",$tBeiJing);
$willLikeDb = $willLikeDb."数据";
$linkName = "记费代码";//计费代码这里要注意, 100005返回的是 2048007001
$daimalink = "(`$linkName` LIKE '%2048004001%' OR `$linkName` LIKE '%2048009001%' OR `$linkName` LIKE '%2048007001%' OR `$linkName` LIKE '%100006%')"; // 这里写记费代码
$m=M($willLikeDb);
$where = "$dateOp AND $checkDate AND $chanel AND $ProductID AND $daimalink";
$list=$m->field(true)->where($where)->order('时间戳 DESC')->select();
$succsesNumber = count($list);//成功次数
$list=$m->field(true)->where($where)->order('时间戳 DESC')->sum('price');
$succsesPrice = $list;//成功金额
// 这里要注意,这里会多写几个变量,用来记录 各代码的成功率 0代表返回本代码多少次 1代表本代码成功多少次 2代表此代码失败多少次
//$daimalink = "(`$linkName` LIKE '%100003%' OR `$linkName` LIKE '%100004%' )"; 查信元,但这里是查成功次数所以不是100003与4
$daimalink = "(`$linkName` LIKE '%2048004001%' OR `$linkName` LIKE '%2048009001%' )";
$list=$m->field(true)->where("$op AND $checkDate AND $chanel AND $ProductID AND $daimalink")->order('时间戳 DESC')->select();
$xingyuan1 = count($list);
$list=$m->field(true)->where("$op AND $checkDate AND $chanel AND $ProductID AND $daimalink")->order('时间戳 DESC')->sum('price');
$xingyuan1Yuan = $list;
$daimalink = "(`$linkName` LIKE '%100006%')";
$list=$m->field(true)->where("$op AND $checkDate AND $chanel AND $ProductID AND $daimalink")->order('时间戳 DESC')->select();
$langtian1 = count($list);
$list=$m->field(true)->where("$op AND $checkDate AND $chanel AND $ProductID AND $daimalink")->order('时间戳 DESC')->sum('price');
$langtian1Yuan = $list;
$daimalink = "(`$linkName` LIKE '%2048007001%')";
$list=$m->field(true)->where("$op AND $checkDate AND $chanel AND $ProductID AND $daimalink")->order('时间戳 DESC')->select();
$tianyi1 = count($list);
//以上为记录结束
$willLikeDb = date("ym",$tBeiJing);
$willLikeDb = $willLikeDb."失败计费数据";
$m=M($willLikeDb);
$daimalink = "(`$linkName` LIKE '%100003%' OR `$linkName` LIKE '%100004%' OR `$linkName` LIKE '%2048007001%' OR `$linkName` LIKE '%100006%')";
$where = "$dateOp AND $checkDate AND $chanel AND $ProductID AND $daimalink";
$list=$m->field(true)->where($where)->order('时间戳 DESC')->select();
$failNumber = count($list);//失败次数
// 这里要注意,这里会多写几个变量,用来记录 各代码的成功率 0代表返回本代码多少次 1代表本代码成功多少次 2代表此代码失败多少次
$willLikeDb = date("ym",$tBeiJing);
$willLikeDb = $willLikeDb."数据";
$m=M($willLikeDb);
$daimalink = "(`$linkName` LIKE '%100003%')";
$list=$m->field(true)->where("$op AND $checkDate AND $chanel AND $ProductID AND $daimalink")->order('时间戳 DESC')->select();
$xingyuan2 = count($list);
$daimalink = "(`$linkName` LIKE '%100003%')";
$list=$m->field(true)->where("$op AND $checkDate AND $chanel AND $ProductID AND $daimalink")->order('时间戳 DESC')->sum('price');// 这里暂时不加OP
$xingyuan2Yuan = $list;
$willLikeDb = date("ym",$tBeiJing);
$willLikeDb = $willLikeDb."失败计费数据";
$m=M($willLikeDb);
$daimalink = "(`$linkName` LIKE '%100006%')";
$list=$m->field(true)->where("$op AND $checkDate AND $chanel AND $ProductID AND $daimalink")->order('时间戳 DESC')->select();
$langtian2 = count($list);
$list=$m->field(true)->where("$op AND $checkDate AND $chanel AND $ProductID AND $daimalink")->order('时间戳 DESC')->sum('price');
$langtian2Yuan = $list;
$daimalink = "(`$linkName` LIKE '%2048007001%')";
$list=$m->field(true)->where("$op AND $checkDate AND $chanel AND $ProductID AND $daimalink")->order('时间戳 DESC')->select();
$tianyi2 = count($list);
//以上为记录结束
/*
echo $failNumber;echo '
';echo '
';
echo $xingyuan1;echo '
';
echo $xingyuan2;echo '
';
echo $langtian1;echo '
';
echo $langtian2;echo '
';echo '
';
echo $xingyuan1Yuan;echo '
';
echo $xingyuan2Yuan;echo '
';
echo $langtian1Yuan;echo '
';
echo $langtian2Yuan;echo '
';
*/
/*
echo iconv("GB2312","UTF-8","启动次数:".$startNumber);echo '
';
echo iconv("GB2312","UTF-8","启动用户数:".$startUserNumber);echo '
';
echo iconv("GB2312","UTF-8","新增用户数:".$appUserNumber);echo '
';
echo iconv("GB2312","UTF-8","总点击计费点次数:".$theAllClickNumber);echo '
';
echo iconv("GB2312","UTF-8","点击计费点成功次数:".$theSuccessClickNumber);echo '
';
echo iconv("GB2312","UTF-8","完成计费流程次数:".($xingyuan1+$xingyuan2+$langtian1+$langtian2+$tianyi1+$tianyi2));echo '
';
echo iconv("GB2312","UTF-8","请求MO:".$askMo);echo '
';
echo iconv("GB2312","UTF-8","成功MO:".($xingyuan1Yuan+$xingyuan2Yuan+$langtian1Yuan+$langtian2Yuan+$tianyi1Yuan+$tianyi2Yuan));echo
'
';
echo iconv("GB2312","UTF-8","成功计费次数:".($failNumber+$succsesNumber));echo '
';
echo iconv("GB2312","UTF-8","成功MR:".$succsesPrice);echo '
';
echo iconv("GB2312","UTF-8","信元MR:".$xingyuan1Yuan);echo '
';
echo iconv("GB2312","UTF-8","朗天MR:".$langtian1Yuan);echo '
';
echo iconv("GB2312","UTF-8","相加MR:".($xingyuan1Yuan+$langtian1Yuan+$tianyi1Yuan));echo '
';
echo "返回信元代码";echo '
';
echo $xingyuan0;echo '
';
echo $xingyuan1;echo '
';
echo $xingyuan2;echo '
';
echo "返回朗天代码";echo '
';
echo $langtian0;echo '
';
echo $langtian1;echo '
';
echo $langtian2;echo '
';
echo "返回天翼代码";echo '
';
echo $tianyi0;echo '
';
echo $tianyi1;echo '
';
echo $tianyi2;echo '
';
*/
$theChengGong = $xingyuan1+$xingyuan2+$langtian1+$langtian2;//+$tianyi1+$tianyi2
$theChengGongMo = $xingyuan1Yuan+$xingyuan2Yuan+$langtian1Yuan+$langtian2Yuan;//+$tianyi1Yuan+$tianyi2Yuan
//$theChengGongNumber = $xingyuan1Yuan+$xingyuan2Yuan+$langtian1Yuan+$langtian2Yuan+$tianyi1Yuan+$tianyi2Yuan;
$theChengGongNumber = $xingyuan1+$langtian1;
$askMo = $askMo/100;
$theChengGongMo = $theChengGongMo/100;
$succsesPrice = $succsesPrice/100;
$xingyuan1Yuan = $xingyuan1Yuan/100;
$langtian1Yuan = $langtian1Yuan/100;
$p=IndexController::getpageB($m,2,100);
$list=array(
"$tempCheckDate",
"$tempProductID",
"$tempChanel",
"$startNumber",
"$startUserNumber",
"$appUserNumber",
"$theAllClickNumber",
"$theSuccessClickNumber",
"$theChengGong",
"$askMo",
"$theChengGongMo",
"$succsesNumber",
"$succsesPrice",
"$xingyuan1Yuan",
"$langtian1Yuan"
);
//var_dump($list);
//$this->list=$list;
//$this->page=$p->show();
//echo '
';echo '
';echo '
';
$this->assign('CCTV',$list);
$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/check");//查询对应的HTTP界面
$willShowDbName = $lookData."用户付费数据";
$this->assign('willShowDbName',$willShowDbName);//表头名
$this->assign('lookData',$lookData);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->display();
}
public function theOpen(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$UseNumberT = 1;//使用第几套显数据
$t=time();//为这次访问的时间数据
$tBeiJing=$t+21600;
$willLikeDb = "开关";
//这里查进行分数据
$where = $this->userLimit[session('userName')];
$m=M($willLikeDb);
$p=IndexController::getpageA($m,$where,25);
//$list=$m->field(true)->where($where)->order('IMEI desc')->select();
$list=$m->field(true)->where($where)->order('产品号 desc')->select();
$this->list=$list;
$this->assign('list',$list);
//$this->page=$p->show();
//上面查进行分数据
//var_dump($list[0]);
$this->assign('willGotoHttpXingZheng',$this->myIP."app/index.php/Home/Index/theOpenEdit?new=1");//查询对应的HTTP界面
$willShowDbName = "开关";//表头名
$this->assign('willShowDbName',$willShowDbName);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->assign('TableHeader',$this->TableHeader[$UseNumberT]);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
$this->display();
}
public function theOpen2(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$UseNumberT = 1;//使用第几套显数据
$t=time();//为这次访问的时间数据
$tBeiJing=$t+21600;
$willLikeDb = "开关";
//这里查进行分数据
$where = "1";
$m=M($willLikeDb);
$p=IndexController::getpageA($m,$where,25);
//$list=$m->field(true)->where($where)->order('IMEI desc')->select();
$list=$m->field(true)->order('产品号 desc')->select();
$this->list=$list;
$this->page=$p->show();
//上面查进行分数据
$this->assign('willGotoHttpXingZheng',$this->myIP."app/index.php/Home/Index/theOpenEdit?new=1");//查询对应的HTTP界面
$willShowDbName = "开关";//表头名
$this->assign('willShowDbName',$willShowDbName);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->assign('TableHeader',$this->TableHeader[$UseNumberT]);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
$this->display();
}
public function theCode(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$UseNumberT = 2;//使用第几套显数据
$t=time();//为这次访问的时间数据
$tBeiJing=$t+21600;
$willLikeDb = "代码";
IndexController::getFenchengAndName();//赋值 codeLook|UpTableTable
//这里查进行分数据
$where = "1";
$m=M($willLikeDb);
$p=IndexController::getpageA($m,$where,25);
//$list=$m->field(true)->where($where)->order('IMEI desc')->select();
$list=$m->field(true)->order('代码编号 desc')->select();
$i = 0;
foreach ($list as $value) {
$tempNumber = $value['代码编号'];
$list[$i]['codeLookUpTable'] = $this->codeLookUpTable["$tempNumber"];
$i++;
}
MiLi1123:
$this->list=$list;
$this->page=$p->show();
//上面查进行分数据
$willShowDbName = "代码管理";
$this->assign('willShowDbName',$willShowDbName);//表头名
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->assign('TableHeader',$this->TableHeader[$UseNumberT]);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
$this->display();
}
//mode 1 为插入
public function accessEditSuccess($miliId=1,$mode = 0){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
if(session('name') <= 5){
echo "权限不足,请登陆管理员用户
";
die("权限不足,请登陆管理员用户");
}
echo "miliId=".$miliId."mode".$mode;
echo "
";
var_dump($_POST);
$t=time();
date_default_timezone_set("PRC");
$tempMax = (count($_POST) - 2)/3;
for($i=0;$i<$tempMax;$i++){
if($_POST['switch'.$i] == "" || $_POST['switch'.$i] == null){
$channel_stats .= "无".":";
}else{
$channel_stats .= $_POST['switch'.$i].":";
}
if($_POST['theTime'.$i] == "" || $_POST['theTime'.$i] == null){
$time .= "0101".":";
}else{
$time .= $_POST['theTime'.$i].":";
}
if($_POST['remark'.$i] == "" || $_POST['remark'.$i] == null){
$remark .= "未选择".":";
}else{
$remark .= $_POST['remark'.$i].":";
}
//$time .= $_POST['theTime'.$i].":";
//$remark .= $_POST['remark'.$i].":";
}
$channel_stats = substr($channel_stats,0,strlen($channel_stats) - 1);
$time = substr($time,0,strlen($time) - 1);
$remark = substr($remark,0,strlen($remark) - 1);
echo $channel_stats,"
";
echo $time,"
";
echo $remark,"
";
$willLikeDb = "the_channel_name";
$m=M($willLikeDb);
$willLikeDb = "the_channel_name";
if($mode == 0){
$query = "UPDATE `the_channel_stat` SET `channel_stats`='$channel_stats', `time`='$time', `remark`='$remark' WHERE (`main_id`='$miliId')";
}else{
$gameName = $_POST['game_name'];
if($gameName == "" || $gameName == null){
$gameName .= "未填写";
}
$query = "INSERT INTO `the_channel_stat` (`game_name`, `channel_stats`, `time`, `remark`, `time_stamp`) VALUES ('$gameName', '$channel_stats', '$time', '$remark', '$t')";
}
try {
$m->query($query);
} catch (\Exception $e) {
}
$url = $this->myIP."app/index.php/Home/Index/Access";
echo "2秒后跳转",'';
flush();
echo "";
}
public function accessEdit($miliId=1,$mode = 0){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
if(session('name') <= 5){
echo "权限不足,请登陆管理员用户
";
die("权限不足,请登陆管理员用户");
}
if(isset($_GET['mode'])){
$displayType[$_GET['mode']] = "style=\"display:none;\"";
$changeModeMymimi = $_GET['mode'];
}
$willLikeDb = "the_channel_name";
$m=M($willLikeDb);
$willLikeDb = "the_channel_name";
$query = "SELECT * FROM `$willLikeDb` ORDER BY `main_id` ";
$tempTableHeader = $m->query($query);
$willLikeDb = "the_company_name";
$query = "SELECT * FROM `$willLikeDb` ORDER BY `main_id` ";
$tempTableCompanyName = $m->query($query);
$query = "SELECT * FROM `the_channel_stat` WHERE `main_id` = '$miliId'";
$tempList = $m->query($query);
$tempArrayChannel_stats = split(":",$tempList[0]["channel_stats"]);
$tempArrayTime = split(":",$tempList[0]["time"]);
$tempArrayRemark = split(":",$tempList[0]["remark"]);
$i=0;
foreach($tempTableHeader as $key => $value ){
$List[$i][0] = $i;
$List[$i][1] = $value['channel_name'];
$List[$i][2] = $tempArrayTime[$i];
$List[$i][3] = $tempArrayRemark[$i];
$j = 0;
foreach ($this->TableHeader[9] as $key1 => $value1){
//echo "|对比".$tempArrayChannel_stats[$i]."-->".$value1."|"."now==".$i;
if(IndexController::isInString($tempArrayChannel_stats[$i],$value1)){
$List[$i][10+$j] = "selected=\"true\"";
}
$j++;
}
$i++;
}
$i = 0;
foreach($tempTableCompanyName as $key => $value ){
$ListCompany[$i] = $value['company_name'];
$i++;
}
//var_dump($List);
if($mode != 1){
$displayType = "style=\"display:none;\"";
}else{
$displayType = "";
}
$willgoHtml = $this->myIP."app/index.php/Home/Index/accessEditSuccess/miliId/$miliId/mode/$mode";
$this->assign('willgoHtml',$willgoHtml);
$this->assign('displayType',$displayType);
$this->assign('ListCompany',$ListCompany);
$this->assign('List',$List);
$this->assign('opitonS',$this->TableHeader[9]);
// $this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
// $this->assign('TableHeader',$tempTableHeaderOver);
// $this->assign('getAccess',$this->getAccess);
// $this->assign('FirstName3344',$this->FirstName3344);
// $Name = "施工中【这排都没用】";
// $this->assign('name',$Name);
$this->display();
}
public function Access($op="1"){
//$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$t=time();
date_default_timezone_set("PRC");
$willLikeDb = "代码";
$m=M($willLikeDb);
$willLikeDb = "the_channel_name";
$query = "SELECT * FROM `$willLikeDb`";
$tempTableHeader = $m->query($query);
$tempTableHeaderOver[0]="游戏名\渠道";
$i=1;
foreach($tempTableHeader as $key => $value){
$tempTableHeaderOver[$i] = $value["channel_name"];
$i++;
}
$query = "SELECT * FROM `the_channel_stat` ORDER BY `time_stamp` DESC";
$tempList = $m->query($query);
//var_dump($tempList);
$i=0;
foreach($tempList as $key => $value){
$showList[$i][0][0] = $value["game_name"];
$showList[$i][0][1] = $value["game_name"];
$showList[$i][0][2] = "#cedc37";//游戏名颜色
$j = 1;
//echo "mimimimi==";
//echo $value["channel_stats"];
$tempArrayChannel_stats = split(":",$value["channel_stats"]);
$tempArrayTime = split(":",$value["time"]);
$tempArrayRemark = split(":",$value["remark"]);
//var_dump($tempArrayChannel_stats);
$u = 0;
foreach($tempArrayChannel_stats as $key2 => $value2){
$showList[$i][$j][0] = $tempArrayRemark[$u];//公司名字
$showList[$i][$j][1] = $tempArrayChannel_stats[$u].$tempArrayTime[$u];//审核状态
//颜色 红 ed1414 粉 f773a2 绿 6ce889
if(IndexController::isInString($showList[$i][$j][1],"上线")){
$showList[$i][$j][2] = "#6ce889";
}else if(IndexController::isInString($showList[$i][$j][1],"审核")){
$showList[$i][$j][2] = "#f773a2";
}else{
$showList[$i][$j][2] = "#ed1414";
}
$j++;
$u++;
}
//echo "SBSBSBSBS==". $value["main_id"];
$showList[$i]["main_id"] = $value["main_id"];
$i++;
}
//echo "showList==";
//var_dump($showList);
// "#008B8B"
$willGotoHttpXingZheng = $this->myIP."app/index.php/Home/Index/accessEdit/miliId/0/mode/1";
$this->assign('willGotoHttpXingZheng',$willGotoHttpXingZheng);
$this->assign('showList',$showList);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->assign('TableHeader',$tempTableHeaderOver);
$this->assign('getAccess',$this->getAccess);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
$this->display();
}
//以前用来查代码的
public function Access2($op="1"){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$UseNumberT = 8;//使用第几套显数据
$t=time();//为这次访问的时间数据
$tBeiJing=$t+21600;
$willLikeDb = "代码";
IndexController::getFenchengAndName();//赋值 codeLook|UpTableTable
//这里查进行分数据
$m=M($willLikeDb);
//$list=$m->field(true)->where($where)->order('IMEI desc')->select();
$list=$m->field(true)->order('代码编号 desc')->select();
$query = "SELECT distinct `代码编号`,`屏蔽省`,`price` FROM `$willLikeDb` WHERE `op` = '$op' ";
$list = $m->query($query);
$showList = array();
$j = 0;
foreach ($list as $value) {
$proListOpen = IndexController::getProvinceNumber($value['屏蔽省'],$this->proListMove);
$showList[$j][0] = $this->codeLookUpTable["$value[代码编号]"];
$i = 0;
foreach($this->proListMove as $value2){
$i++;
$havePrice = false;
if(IndexController::isInString($proListOpen,$value2)){
$showList[$j][$i] = (Int)($value['price'] / 100);
$havePrice = true;
}
if(!$havePrice)
{
$showList[$j][$i]=0;
}
}
$j++;
}
$showList[$j][0] = '资费';
for($i=1;$i < 32;$i++){
for($k=0;$k < $j;$k++){
$showList[$j][$i] += $showList[$k][$i];
}
}
MiLi1123:
$this->assign('showList',$showList);
$this->assign('allList',$allList);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->assign('TableHeader',$this->TableHeader[$UseNumberT]);
$this->assign('getAccess',$this->getAccess);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
$this->display();
}
public function theCodeEdit($miliId=100010){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
if(session('name') <= 5){
echo "权限不足,请登陆管理员用户
";
die("权限不足,请登陆管理员用户");
}
if(IS_POST){
//这里写提交后接收的数数据
}else{
//这里边写的事根据传过来的id查出来的数据,然后展示给页面
$User = M("代码"); // 实例化User对象 '代码编号 = '."$codeNumber"." AND ".'price = '."$price"
//dump('代码编号 = '."$codeNumber");
$Result = $User->where('mili_id = '."$miliId")->select();
//dump($Result);
//$checkTrue=array(0,0,0);
for ($i = 0; $i < 24; $i++) {
$OpenTime[$i][5] = $i;
if($i < 10){
$checkString = "0".(String)$i;
}else{
$checkString = (String)$i;
}
if ($i%12==0){
$OpenTime[$i][3] = "";
}
$OpenTime[$i][1] = (String)$i."-".(String)($i+1);
//dump($checkString);
if (IndexController::isInString($Result[0][开通时段],$checkString)){
$OpenTime[$i][0]="checked";
$OpenTime[$i][4]=1;
}else{
$OpenTime[$i][0]="";
$OpenTime[$i][4]=2;
}
//dump($checkTrue[$i]);
}
for ($i = 0; $i < 31; $i++) {
$checkProListTrue[$i][5] = $i;
if (IndexController::isInString($Result[0][屏蔽省],$this->proListMove[$i])){
$checkProListTrue[$i][0]="checked";
$checkProListTrue[$i][1]=$this->proListMove[$i];
$checkProListTrue[$i][4]=1;
}else{
$checkProListTrue[$i][0]="";
$checkProListTrue[$i][1]=$this->proListMove[$i];
$checkProListTrue[$i][4]=2;
}
if ($i%12==0){
$checkProListTrue[$i][3] = "
";
}
}
if("电信" == $Result[0][运营商]){
$opMi[0] = "selected";
}
if("联通" == $Result[0][运营商]){
$opMi[1] = "selected";
}
if("移动" == $Result[0][运营商]){
$opMi[2] = "selected";
}
//echo var_dump($opMi);
//dump($checkTrue);
$this->assign('op',$opMi);
$this->assign('Result',$Result);
$this->assign('openTime',$OpenTime);
$this->assign('checkProListTrue',$checkProListTrue);
$this->display();
}
}
public function theCodeEditSucc(){
if(session('name') <= 5){
echo "权限不足,请登陆管理员用户
";
die("权限不足,请登陆管理员用户");
}
//header("Content-type: text/html; charset=GBK");
$willshieldProvince = "";
$willopenMyTime = "";
$willChangeId = "";
if(isset($_POST['mili_id'])){
$willChangeId = mysql_escape_string($_POST['mili_id']);
}
for ($x=0; $x<31; $x++) {
$tempString = 'shieldProvince'.$x;
if(isset($_POST[$tempString])){
$tempICCID = mysql_escape_string($_POST[$tempString]);
$willshieldProvince .= '|'.$this->proListMove[$x];
}
}
for ($x=0; $x<23; $x++) {
$tempString = 'openMyTime'.$x;
if(isset($_POST[$tempString])){
$tempICCID = mysql_escape_string($_POST[$tempString]);
$tempNumber = IndexController::zeroFillLeft($x,2,"0",0);
$willopenMyTime .= '|'.$tempNumber;
}
}
$willshieldProvince = substr($willshieldProvince,1,strlen($willshieldProvince) - 1);
$willopenMyTime = substr($willopenMyTime,1,strlen($willopenMyTime) - 1);
//echo $willshieldProvince,'
';
//echo $willopenMyTime,'
';
//echo $willChangeId,'
';
$query = "UPDATE `代码` SET `屏蔽省` = '$willshieldProvince' WHERE `mili_id` = '$willChangeId' ORDER BY `mili_id` DESC LIMIT 1";//`开通时段` = '$willopenMyTime',
//$query = iconv("GB2312","UTF-8",$query);
//echo $query,'';
$Model = new \Think\Model();
$Result = $Model->execute($query);
$url = $this->myIP."app/index.php/Home/Index/theCode";
echo "2秒后跳转",'';
flush();
echo "";
}
private function getOpenProductIDFormMiliid($miliId=0){
$Model = new \Think\Model();
$query = "SELECT `产品号` FROM `开关` WHERE `开关`.`mili_id` = $miliId LIMIT 1";
$Result = $Model->query($query);
//var_dump($Result);
return $Result[0]["产品号"];
}
private function verifyLimit($ProductID){
$bool = false;
$tempMax = $this->userLimitMax[session('userName')];
$tempMin = $this->userLimitMin[session('userName')];
if($ProductID <= $tempMax && $ProductID >= $tempMin){
$bool = true;
}
//echo "||ProductID=".$ProductID."||userLimitMax=".$this->userLimitMax[session('userName')]."||userLimitMin=".$this->userLimitMin[session('userName')];
//echo "||verifyLimit==".$bool."||";
return $bool;
}
public function theOpenDele($miliId=0){
if(!$this->verifyLimit($this->getOpenProductIDFormMiliid($miliId))){
die("权限不足");
}
echo "";
die("输入验证码后开始删除");
}
public function theOpenDeleSucc(){
if (isset($_POST['miliId']) && isset($_POST['checkCode'])){
$miliId = I('miliId');
if(!$this->verifyLimit($this->getOpenProductIDFormMiliid($miliId))){
die("权限不足");
}
if(session('verification') == md5($_POST['checkCode']) ){
$Model = new \Think\Model();
$query = "DELETE FROM `开关` WHERE `开关`.`mili_id` = $miliId LIMIT 1";
$Result = $Model->execute($query);
if($Result){
echo "删除成功",'';
}else{
echo "删除失败,其它错误。",'';
}
}else{
echo "删除失败,验证码错误。",'';
}
}else{
echo "没有验证码或ID。",'';
}
$url = $this->myIP."app/index.php/Home/Index/theOpen";
echo "2秒后跳转",'';
flush();
echo "";
}
public function theOpenEdit($miliId=100010){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
if(session('name') <= 5){
echo "权限不足,请登陆管理员用户
";
die("权限不足,请登陆管理员用户");
}
if(isset($_GET['mode'])){
$displayType[$_GET['mode']] = "style=\"display:none;\"";
$changeModeMymimi = $_GET['mode'];
}
$openNumber = array(
"1" => "selected=\"selected\"",
"2" => "",
"3" => "",
"4" => "",
"5" => "",
"6" => "",
"7" => "",
"8" => "",
"9" => "",
);
//inputttttt
if(isset($_GET['new'])){
$Result[0]['mili_id'] = 0;
$thisIsNew = 1;
}else{
//这里边写的事根据传过来的id查出来的数据,然后展示给页面
$tempArryMiliId = explode(":",$miliId);
$User = M("开关");
$Result = $User->where('mili_id = '."$tempArryMiliId[0]")->select();
}
if($thisIsNew == 1){
}else{
/*
echo $miliId."==";
echo "产品号==".$this->getOpenProductIDFormMiliid($miliId)."---";
echo "bool==".$this->verifyLimit($this->getOpenProductIDFormMiliid($miliId))."====";*/
$tempSBArray = split(":",$miliId);
foreach($tempSBArray as $tempValue){
if($this->verifyLimit($this->getOpenProductIDFormMiliid($tempValue))){
}else{
die("权限不足");
}
}
}
for ($i = 0; $i < 31; $i++) {
$ipShieldProList[$i][5]=$i;
if (IndexController::isInString($Result[0]['从ip屏蔽省'],$this->proListMove[$i])){
$ipShieldProList[$i][0]="checked";
$ipShieldProList[$i][1]=$this->proListMove[$i];
$ipShieldProList[$i][4]=1;
}else {
$ipShieldProList[$i][0]="";
$ipShieldProList[$i][1]=$this->proListMove[$i];
$ipShieldProList[$i][4]=0;
}
if ($i%12==0){
$ipShieldProList[$i][3] = "
";
}
}
for ($i = 0; $i < 31; $i++) {
$iccidShieldProList[$i][5]=$i;
if (IndexController::isInString($Result[0]['从手机卡屏蔽省'],$this->proListMove[$i])){
$iccidShieldProList[$i][0]="checked";
$iccidShieldProList[$i][1]=$this->proListMove[$i];
$iccidShieldProList[$i][4]=1;
}else {
$iccidShieldProList[$i][0]="";
$iccidShieldProList[$i][1]=$this->proListMove[$i];
$iccidShieldProList[$i][4]=0;
}
if ($i%12==0){
$iccidShieldProList[$i][3] = "
";
}
}
for ($i = 0; $i < 32; $i++) {
$blackShieldProList[$i][5]=$i;
if (IndexController::isInString($Result[0]['黑包屏蔽省份'],$this->proListMove2[$i])){
$blackShieldProList[$i][0]="checked";
$blackShieldProList[$i][1]=$this->proListMove2[$i];
$blackShieldProList[$i][4]=1;
}else {
$blackShieldProList[$i][0]="";
$blackShieldProList[$i][1]=$this->proListMove2[$i];
$blackShieldProList[$i][4]=0;
}
if ($i%12==0){
$blackShieldProList[$i][3] = "
";
}
}
for ($i = 0; $i < 24; $i++) {
$theOpenTimeList[$i][5]=$i;
if (IndexController::isInString($Result[0]['time_open'],$this->theOpenTimeArray[$i])){
$theOpenTimeList[$i][0]="checked";
$theOpenTimeList[$i][1]=$this->theOpenTimeArray[$i];
$theOpenTimeList[$i][4]=1;
}else {
$theOpenTimeList[$i][0]="";
$theOpenTimeList[$i][1]=$this->theOpenTimeArray[$i];
$theOpenTimeList[$i][4]=0;
}
if ($i%8==0){
$theOpenTimeList[$i][3] = "
";
}
if($thisIsNew == 1){
$theOpenTimeList[$i][0]="checked";
$theOpenTimeList[$i][4]=1;
}
}
//
for ($i = 0; $i < 18; $i++) {
$chooseNumberSheildSpecilArrayList[$i][5]=$i;
if (IndexController::isInString($Result[0]['secendmilishieldedprovince'],$this->chooseNumberSheildSpecilArraytheValue[$i])){
$chooseNumberSheildSpecilArrayList[$i][0]="checked";
$chooseNumberSheildSpecilArrayList[$i][1]=$this->chooseNumberSheildSpecilArray[$i];
$chooseNumberSheildSpecilArrayList[$i][4]=1;
}else {
$chooseNumberSheildSpecilArrayList[$i][0]="";
$chooseNumberSheildSpecilArrayList[$i][1]=$this->chooseNumberSheildSpecilArray[$i];
$chooseNumberSheildSpecilArrayList[$i][4]=0;
}
if ($i%8==0){
$chooseNumberSheildSpecilArrayList[$i][3] = "
";
}
if($thisIsNew == 1){
$chooseNumberSheildSpecilArrayList[$i][0]="checked";
$chooseNumberSheildSpecilArrayList[$i][4]=1;
}
}
$tempArryString = explode("|",$Result[0]['specialnumber']);
for($i = 0; $i < count($this->specialNumber); $i++){
if(isset($_GET['new'])){
$specialNumber[$i][0] = $this->specialNumberDefault[$i];
}else{
$specialNumber[$i][0] = $tempArryString[$i];
}
$specialNumber[$i][2] = $this->specialNumber[$i];
if ($i%2==0){
$specialNumber[$i][3] = "
";
}
}
if(isset($_GET['new'])){
$i = 0;
foreach($this->upChannelList as $key => $value){
$upChannelList[$i][0]=$key;
$upChannelList[$i][1]=$value;
$upChannelList[$i][2]=$key."-".$value;
$upChannelList[$i][2] = IndexController::zeroFillLeft($upChannelList[$i][2],20,"-",1);
if ($i%4==0){
$upChannelList[$i][3] = "
";
}
$i++;
}
$i = 0;
foreach($this->downChannelList as $key => $value){
$downChannelList[$i][0]=$key;
$downChannelList[$i][1]=$value;
$downChannelList[$i][2]=$key."-".$value;
if ($i%8==0){
$downChannelList[$i][3] = "
";
}
$i++;
}
$upAndDown[0] = "线下渠道选择";
$upAndDown[1] = "线上渠道选择";
}
if($Result[0]['开关'] == 0){
$switchMy[0] = "selected";
}else{
$switchMy[$Result[0]['开关']] = "selected";
}
if($Result[0]['使用sdk'] == 0){
$op[1] = "selected";
}else{
$op[$Result[0]['op']] = "selected";
}
$Result[0]['mili_id'] = $miliId;//这出了问题
if(isset($_GET['new'])){
$Result[0]['mili_id'] = 0;
}
//dump($checkTrue);
$tempArrayChooseNumberSdk = array(0,1,2,3,4,5,6,7,8,9);
$tempSBArray = split(":",$Result[0]['黑包屏蔽省份']);
$sbArray = array(
"",
"",
"",
"",
"",
"",
"",
"",
"",
""
);
$sbArray[count($tempSBArray)-1] = "selected='selected'";
$SBSBSBSBSBSBS = count($tempSBArray);
$this->assign('SBSBSBSBSBSBS',$SBSBSBSBSBSBS);
$this->assign('sbArray',$sbArray);
$this->assign('sheildSdkPro',$Result[0]['黑包屏蔽省份']);
$this->assign('chooseNumberSdk',$tempArrayChooseNumberSdk);
$this->assign('openNumber',$openNumber);
$this->assign('op',$op);
$this->assign('Result',$Result);
$this->assign('switchMy',$switchMy);
$this->assign('displayType',$displayType);
$this->assign('changeModeMymimi',$changeModeMymimi);
$this->assign('specialNumber',$specialNumber);
$this->assign('specialNumber22',$Result[0]['specialNumber']);
$this->assign('upAndDown',$upAndDown);
$this->assign('upChannelList',$upChannelList);
$this->assign('downChannelList',$downChannelList);
$this->assign('ipShieldProList',$ipShieldProList);
$this->assign('iccidShieldProList',$iccidShieldProList);
$this->assign('blackShieldProList',$blackShieldProList);
$this->assign('theOpenTimeList',$theOpenTimeList);
$this->assign('chooseNumberSheildSpecilArrayList',$chooseNumberSheildSpecilArrayList);
$this->display();
}
public function theOpenEditSucc(){
if(session('name') <= 5){
echo "权限不足,请登陆管理员用户
";
die("权限不足,请登陆管理员用户");
}
//header("Content-type: text/html; charset=GBK");
$willshieldIpProvince = "";
$willshieldIccidProvince = "";
$willMili_blackShieldPro = "";
$willProductId = "";
$willProductName = "";
$willChannelId = "";
$willOp = 1;
$willChangeSwitch = 1;
$willChangeId = "";
$willChangeSpecialNumber = "";
$changeModeMymimi = 0;
if(isset($_POST['mili_id'])){
$willChangeId = mysql_escape_string($_POST['mili_id']);
}
if(isset($_POST['switch'])){
$willChangeSwitch = mysql_escape_string($_POST['switch']);
}
if(isset($_POST['mili_blackShieldPro'])){
$willMili_blackShieldPro = mysql_escape_string($_POST['mili_blackShieldPro']);
}
if(isset($_POST['productId'])){
$willProductId = mysql_escape_string($_POST['productId']);
}
if(isset($_POST['productName'])){
$willProductName = mysql_escape_string($_POST['productName']);
}
if(isset($_POST['channelId'])){
$willChannelId = mysql_escape_string($_POST['channelId']);
}
if(isset($_POST['op'])){
$willOp = mysql_escape_string($_POST['op']);
}
if(isset($_POST['specialNumber'])){
$willChangeSpecialNumber = mysql_escape_string($_POST['specialNumber']);
}
if(isset($_POST['modeMymimi'])){
$changeModeMymimi = mysql_escape_string($_POST['modeMymimi']);
}
if($willChangeId == 0){
if(!$this->verifyLimit($willProductId)){
die("权限不足1");
}
}else{
$tempSBArray = split(":",$willChangeId);
foreach($tempSBArray as $tempValue){
if($this->verifyLimit($this->getOpenProductIDFormMiliid($tempValue))){
}else{
die("权限不足2");
}
}
}
//die($changeModeMymimi);
echo "cc==".$willMili_blackShieldPro;
for ($x=0; $x<31; $x++) {
$tempString = 'ipShieldPro'.$x;
//$tempICCID = mysql_escape_string($_POST[$tempString]);
//var_dump ($tempICCID);
//echo "---$x".'
';
if(isset($_POST[$tempString])){
$tempICCID = mysql_escape_string($_POST[$tempString]);
$willshieldIpProvince .= '|'.$this->proListMove[$x];
}
}
for ($x=0; $x<31; $x++) {
$tempString = 'iccidShieldPro'.$x;
if(isset($_POST[$tempString])){
$tempICCID = mysql_escape_string($_POST[$tempString]);
$willshieldIccidProvince .= '|'.$this->proListMove[$x];
}
}
for ($x=0; $x<24; $x++) {
$tempString = 'theOpenTimeList'.$x;
if(isset($_POST[$tempString])){
$tempICCID = mysql_escape_string($_POST[$tempString]);
$willtheOpenTimeList .= '|'.$this->theOpenTimeArray[$x];
}
}
var_dump($_POST);
for ($x=0; $x<18; $x++) {
$tempString = 'chooseNumberSheildSpecilArrayList'.$x;
if(isset($_POST[$tempString])){
$tempICCID = mysql_escape_string($_POST[$tempString]);
$willtheChooseNumberSheildSpecilArrayList .= '|'.$this->chooseNumberSheildSpecilArraytheValue[$x];
}
}
//echo "
"."开通:".$willtheChooseNumberSheildSpecilArrayList."
";
$willtheOpenTimeList = substr($willtheOpenTimeList,1,strlen($willtheOpenTimeList) - 1);
$willshieldIpProvince = substr($willshieldIpProvince,1,strlen($willshieldIpProvince) - 1);
$willshieldIccidProvince = substr($willshieldIccidProvince,1,strlen($willshieldIccidProvince) - 1);
echo "
"."开通时间:".$willtheOpenTimeList."
";
$tempArryWillChannelId = explode(":",$willChannelId);
$Model = new \Think\Model();
if($willChangeId == 0 ){
if($willOp == 0){
$tempNumberIapp=1;
}else{
$tempNumberIapp=3;
}
for($i = $tempNumberIapp;$i < 4;$i++){
if($willOp == 0){
$tempWillOp = $i;
}else{
$tempWillOp = $willOp;
}
for($j = 0;$j < count($tempArryWillChannelId);$j++){
$tempWillChannelId = $tempArryWillChannelId[$j];
$query = "INSERT INTO `开关` (`产品号`, `开关`, `产品名`, `渠道号`, `从IP屏蔽市`, `从IP屏蔽省`, `从手机卡屏蔽市`, `从手机卡屏蔽省`,
`黑包屏蔽省份`, `咪咕移动基地屏蔽省份`, `使用SDK`, `使用权限策略`, `op`, `specialNumber`, `time_open`, `secendMiLiShieldedProvince`) VALUES
('$willProductId', '1', '$willProductName', '$tempWillChannelId', '', '$willshieldIpProvince', '', '$willshieldIccidProvince',
'$willMili_blackShieldPro', '', '0', '0', '$tempWillOp', '$willChangeSpecialNumber','$willtheOpenTimeList','$willtheChooseNumberSheildSpecilArrayList')";
$Result = $Model->execute($query);
}
}
}
$tempArryWillChangeId = explode(":",$willChangeId);
if($willMili_blackShieldPro == ""){
$query = "SELECT * FROM `代码` WHERE `代码编号` >= '900000' ORDER BY `代码编号` ASC;";
$Result = $Model->query($query);
$tempString = "";
foreach($Result as $value){
$tempString .= ":".$value['屏蔽省'];
}
$willMili_blackShieldProEnd = "上海:上海:上海:上海:".substr($tempString,1,strlen($tempString) - 1);
}else{
//$willMili_blackShieldProSql = ",`黑包屏蔽省份` = '$willMili_blackShieldPro'";
//$SqlE = "";
}
if($willChangeId != 0){
if($changeModeMymimi == 3 || $changeModeMymimi == 2){
die("暂时不可用");
$willMili_blackShieldProArray = explode(":",$willMili_blackShieldPro);
$willMili_blackShieldProArray2 = explode("|",$willMili_blackShieldProArray[0]);
}
if(count($tempArryWillChangeId) > 1){
for($j = 0;$j < count($tempArryWillChangeId);$j++){
$tempWillChangeId = $tempArryWillChangeId[$j];
if($changeModeMymimi == 0){
if($willMili_blackShieldPro == ""){
$chaneTempSQL = "";
}else{
$chaneTempSQL =",`黑包屏蔽省份` = '$willMili_blackShieldPro'";
}
$query = "UPDATE `开关` SET `从手机卡屏蔽省` = '$willshieldIccidProvince',`从IP屏蔽省` = '$willshieldIpProvince'$chaneTempSQL WHERE `mili_id` = '$tempWillChangeId' ORDER BY `mili_id` DESC LIMIT 1";
$Result = $Model->execute($query);
}else if($changeModeMymimi == 1){
$query = "UPDATE `开关` SET `开关`= '$willChangeSwitch' WHERE `mili_id` = '$tempWillChangeId' ORDER BY `mili_id` DESC LIMIT 1";
$Result = $Model->execute($query);
}else if($changeModeMymimi == 2){
$query = "SELECT * FROM `开关` WHERE `mili_id` = '$tempWillChangeId'";
//$Result = $Model->execute($query);
$Result = $Model->query($query);
$ResultArray = explode(":",$Result[0]["黑包屏蔽省份"]);
$willStringAdd = "";
foreach($willMili_blackShieldProArray2 as $value){
if(!IndexController::isInString($ResultArray[0],$value) ){
$willStringAdd .= $value."|";
}
}
echo '
'."增加$willStringAdd".'
';
$value1 = "$willStringAdd".$Result[0]['黑包屏蔽省份'];
echo '
'."改为$value1".'
';
$query = "UPDATE `开关` SET `黑包屏蔽省份` = '$value1' WHERE `mili_id` = '$tempWillChangeId' ORDER BY `mili_id` DESC LIMIT 1";
$Result = $Model->execute($query);
}else if($changeModeMymimi == 3){
foreach($willMili_blackShieldProArray2 as $value){
$value1 = $value."|";
$query = "UPDATE `开关` SET `黑包屏蔽省份` = replace(`黑包屏蔽省份`,'$value1','') WHERE `mili_id` = '$tempWillChangeId' ORDER BY `mili_id` DESC LIMIT 1";
$Result = $Model->execute($query);
$value2 = "|".$value;
$query = "UPDATE `开关` SET `黑包屏蔽省份` = replace(`黑包屏蔽省份`,'$value2','') WHERE `mili_id` = '$tempWillChangeId' ORDER BY `mili_id` DESC LIMIT 1";
$Result = $Model->execute($query);
}
}else if($changeModeMymimi == 4){
$query = "UPDATE `开关` SET `time_open` = '$willtheOpenTimeList',`secendMiLiShieldedProvince` = '$willtheChooseNumberSheildSpecilArrayList' WHERE `mili_id` = '$tempWillChangeId' ORDER BY `mili_id` DESC LIMIT 1";
$Result = $Model->execute($query);
}
}
}else if(count($tempArryWillChangeId) == 1){
$query = "UPDATE `开关` SET `op` = '$willOp' ,`time_open` = '$willtheOpenTimeList', `开关`= '$willChangeSwitch',`从手机卡屏蔽省` = '$willshieldIccidProvince',`从IP屏蔽省` = '$willshieldIpProvince',`黑包屏蔽省份` = '$willMili_blackShieldPro',`specialNumber` = '$willChangeSpecialNumber',`secendMiLiShieldedProvince` = '$willtheChooseNumberSheildSpecilArrayList' WHERE `mili_id` = '$willChangeId' ORDER BY `mili_id` DESC LIMIT 1";
$Result = $Model->execute($query);
if($willMili_blackShieldProEnd != ""){
$query = "UPDATE `开关` SET `黑包屏蔽省份` = '$willMili_blackShieldProEnd' WHERE `mili_id` = '$willChangeId' AND `产品号` BETWEEN '400000' AND '500000' LIMIT 1";
$Result = $Model->execute($query);
}
}
}
$url = $this->myIP."app/index.php/Home/Index/theOpen";
echo "2秒后跳转",'';
//$willgoHtml = $this->myIP."app/index.php/Home/Index/theCode";
flush();
/*
echo "-->";
*/
echo "";
}
public function spIncom(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$UseNumberT = 0;//使用第几套显数据
$t=time();//为这次访问的时间数据
$tBeiJing=$t+21600;
echo "-----spIncom()";
if (strlen($lookData)!=4){
$willLikeDbNumber = date("ym",$tBeiJing);
$willLikeDb = $willLikeDbNumber."数据1";
}else{
$willLikeDbNumber = $lookData;
$willLikeDb = $lookData."数据1";
}
echo " $willLikeDb"." $willLikeDb","ffffffffffffffffff";
$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/spIncomTable2");
$willShowDbName = $lookData."用户付费数据";
$this->assign('willShowDbName',$willShowDbName);//表头名
$this->assign('lookData',$lookData);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->display();
}
public function spIncom2(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$UseNumberT = 0;//使用第几套显数据
$t=time();//为这次访问的时间数据
$tBeiJing=$t+21600;
if (strlen($lookData)!=4){
$willLikeDbNumber = date("ym",$tBeiJing);
$willLikeDb = $willLikeDbNumber."数据";
}else{
$willLikeDbNumber = $lookData;
$willLikeDb = $lookData."数据";
}
echo "-----spIncom2()";
$this->assign('willGotoHttp2',$this->myIP."app/index.php/Home/Index/spIncomTable2");
$willShowDbName = $lookData."用户付费数据";
$this->assign('willShowDbName',$willShowDbName);//表头名
$this->assign('lookData',$lookData);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->display();
}
public function spIncomTable2()
{
ini_set('max_execution_time', '0');
ini_set("memory_limit","1024M");
echo "-----spIncomTable2()";
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$UseNumberT = 5;//使用第几套显数据
$t=time();//为这次访问的时间数据
$tBeiJing=$t+21600;
IndexController::getFenchengAndName();//赋值 codeLook|UpTableTable
$nowOp = I('op');
$nowProductID = I('productID');
$nowChanel = I('chanel');
$nowCheckDateStar = I('checkDateStar');
$nowCheckDateEnd = I('checkDateEnd');
$chanel = "(`Channel` = '$nowChanel')";//自已定义的渠道号1002
$chanel1 = "(`渠道号` = '$nowChanel')";
echo "sb".$chanel."--".$chanel1;
if($nowChanel == 0){$chanel = "1";$chanel1 = "1";}
$checkDateStar = strtotime($nowCheckDateStar." 0:00:00");
$checkDateEnd = strtotime($nowCheckDateEnd." 24:00:00");
// 2018/07/12之后的数据
if($checkDateStar <=date("Y-m-d",(strtotime("2018/07/12"." 12:00:00")))){
$checkDateStar = strtotime("2018/07/12"." 12:00:00");
}
$checkDateStarDateT = date("Y-m-d",$checkDateStar+10);
$checkDateEndDateT = date("Y-m-d",$checkDateEnd-10);
$willCheckPar = "op=".$nowOp."&productID=".$nowProductID."&chanel=".$nowChanel."&checkDateStar=".$checkDateStarDateT."&checkDateEnd=".$checkDateEndDateT;
$willLikeDb = "代码";
$m=M($willLikeDb);
$willLinkDbName = date("ym",$checkDateStar+10);
$op = "(`运营商` = '$nowOp')";$op1 = "(`运营商` = '$nowOp')";
$opForNumber = "(`op` = '$nowOp')";
if($nowOp == 0){$op = "1";$opForNumber = "1";$op1 = "(`运营商` = '1')";}
$ProductID = "(`Product` = '$nowProductID')";
$ProductID1 = "(`产品号` = '$nowProductID')";
if($nowProductID == 700000){$ProductID = "(`Product` > $nowProductID AND `Product` < 800000 )";$ProductID1 = "(`产品号` > $nowProductID AND `产品号` < 800000 )";}
if($nowProductID == 600000){$ProductID = "(`Product` > $nowProductID AND `Product` < 700000 )";$ProductID1 = "(`产品号` > $nowProductID AND `产品号` < 700000 )";}
if($nowProductID == 500000){$ProductID = "(`Product` > $nowProductID AND `Product` < 600000 )";$ProductID1 = "(`产品号` > $nowProductID AND `产品号` < 600000 )";}
if($nowProductID == 400000){$ProductID = "(`Product` > $nowProductID AND `Product` < 500000 )";$ProductID1 = "(`产品号` > $nowProductID AND `产品号` < 500000 )";}
if($nowProductID == 200000){$ProductID = "(`Product` > $nowProductID AND `Product` < 300000 )";$ProductID1 = "(`产品号` > $nowProductID AND `产品号` < 300000 )";}
if($nowProductID == 300000){$ProductID = "((`Product` > $nowProductID) AND `Product` < 400000 OR (`Product` = 0))";$ProductID1 = "((`产品号` > $nowProductID) AND `产品号` < 400000 OR (`产品号` = 0))";}
if($nowProductID == 100000){$ProductID = "(`Product` > $nowProductID AND `Product` < 200000)";$ProductID1 = "(`产品号` > $nowProductID AND `产品号` < 200000)";}
if($nowProductID == 0){$ProductID = "1";$ProductID1 = "(1)";}
$chcekDay = ($checkDateEnd - $checkDateStar)/ 86400;
if($nowProductID == 0 && $nowChanel == 0){
}else{
$willLikeDb = $willLinkDbName."激活数据1";
//$willLinkDbLateTime = date("ym",$checkDateStar+10) - 1;
$willLinkDbLateTime = date("ym",$checkDateStar+10);
echo "
",$willLinkDbLateTime,"
";
if($willLinkDbLateTime % 100 == 0){$willLinkDbLateTime = date("ym",$checkDateStar + 10 - 86400 * 31);}
echo "
",$willLinkDbLateTime,"
";
$willLikeDbLate = $willLinkDbLateTime."激活数据1";
$query = "SELECT `日期`,`归属地`,COUNT(*) FROM (SELECT distinct `IMSI`,`日期`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < '$t' AND $chanel1 AND $ProductID1 AND $op1 GROUP BY `IMSI` ORDER BY `时间戳` ASC )as t1 LEFT JOIN (SELECT distinct `IMSI` AS `i`FROM `$willLikeDbLate` WHERE $chanel1 AND $ProductID1 AND $op1)as t2 ON t1.`IMSI`=t2.`i` WHERE t2.`i` IS NULL GROUP BY `归属地`,`日期`;";
$tempAppUserList = $m->query($query);
echo "
",$query,"
";
var_dump($tempAppUserList);
if($nowOp == 0){
$query = "SELECT `日期`,`归属地`,COUNT(*) FROM (SELECT distinct `IMSI`,`日期`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < '$t' AND $chanel1 AND $ProductID1 AND (`运营商` = '2') GROUP BY `IMSI` ORDER BY `时间戳` ASC )as t1 LEFT JOIN (SELECT distinct `IMSI` AS `i`FROM `$willLikeDbLate` WHERE $chanel1 AND $ProductID1 AND (`运营商` = '2'))as t2 ON t1.`IMSI`=t2.`i` WHERE t2.`i` IS NULL GROUP BY `归属地`,`日期`;";
$tempAppUserList2 = $m->query($query);
$query = "SELECT `日期`,`归属地`,COUNT(*) FROM (SELECT distinct `IMSI`,`日期`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < '$t' AND $chanel1 AND $ProductID1 AND (`运营商` = '3') GROUP BY `IMSI` ORDER BY `时间戳` ASC )as t1 LEFT JOIN (SELECT distinct `IMSI` AS `i`FROM `$willLikeDbLate` WHERE $chanel1 AND $ProductID1 AND (`运营商` = '3'))as t2 ON t1.`IMSI`=t2.`i` WHERE t2.`i` IS NULL GROUP BY `归属地`,`日期`;";
$tempAppUserList3 = $m->query($query);
$query = "SELECT `日期`,`归属地`,COUNT(*) FROM (SELECT distinct `IMSI`,`日期`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < '$t' AND $chanel1 AND $ProductID1 AND (`运营商` = '0') GROUP BY `IMSI` ORDER BY `时间戳` ASC )as t1 LEFT JOIN (SELECT distinct `IMSI` AS `i`FROM `$willLikeDbLate` WHERE $chanel1 AND $ProductID1 AND (`运营商` = '2'))as t2 ON t1.`IMSI`=t2.`i` WHERE t2.`i` IS NULL GROUP BY `归属地`,`日期`;";
$tempAppUserList0 = $m->query($query);
}
}
//var_dump($tempAppUserList);
for($i= 0 ; $i <= $chcekDay;$i++){
if($i == 1 && $chcekDay == 1){break;}
$nowCheckTimeStampEnd = $checkDateStar + 86400 * $i;
$nowCheckDate1 = date("Y-m-d",$nowCheckTimeStampEnd + 60);
$nowCheckDateStart = "(`日期` = '$nowCheckDate1')";
$nowCheckDate = "(`time` = '$nowCheckDate1')";
if($i == $chcekDay){
$nowCheckDate2 = date("Y-m-d",$checkDateStar + 60);
$nowCheckDate1 = date("Y-m-d",$nowCheckTimeStampEnd - 6000);
$nowCheckDate = "(`time` >= '$nowCheckDate2' AND `time` <= '$nowCheckDate1')";
$nowCheckDateStart = "(`日期` >= '$nowCheckDate2' AND `日期` <= '$nowCheckDate1')";
}
//echo "
","$i---$nowCheckDate-","
";
$willLikeDb = $willLinkDbName."_checked_every_month";
$codeList = $m->query("SELECT * FROM `$willLikeDb` WHERE $nowCheckDate AND $chanel AND $ProductID AND $opForNumber ");
//echo "SELECT * FROM `$willLikeDb` WHERE $nowCheckDate AND $chanel AND $ProductID AND $opForNumber";
//var_dump($codeList);
foreach($tempAppUserList as $value){
if($value['日期'] == "$nowCheckDate1"){// && $value['归属地'] != ""
$list1[$i][5] += $value['count(*)'];
}
}
if($nowOp == 0){
foreach($tempAppUserList2 as $value){
if($value['日期'] == "$nowCheckDate1"){
$list1[$i][5] += $value['count(*)'];
}
}
foreach($tempAppUserList3 as $value){
if($value['日期'] == "$nowCheckDate1"){
$list1[$i][5] += $value['count(*)'];
}
}
foreach($tempAppUserList0 as $value){
if($value['日期'] == "$nowCheckDate1"){
$list1[$i][5] += $value['count(*)'];
}
}
}
if($i == $chcekDay){
$list1[$i][5] = 0;
//总计新增用户数
foreach($tempAppUserList as $value){
//if($value['归属地'] != "" && $value['日期'] >= "$nowCheckDate2" && $value['日期'] <= "$nowCheckDate1"){
if($value['归属地'] != "" && $value['日期'] >= "$nowCheckDate2" && $value['日期'] <= "$nowCheckDate1"){
$list1[$i][5] += $value['count(*)'];
}
}
if($nowOp == 0){
foreach($tempAppUserList2 as $value){
if($value['归属地'] != "" && $value['日期'] >= "$nowCheckDate2" && $value['日期'] <= "$nowCheckDate1"){
$list1[$i][5] += $value['count(*)'];
}
}
foreach($tempAppUserList3 as $value){
if($value['归属地'] != "" && $value['日期'] >= "$nowCheckDate2" && $value['日期'] <= "$nowCheckDate1"){
$list1[$i][5] += $value['count(*)'];
}
}
foreach($tempAppUserList0 as $value){
if($value['归属地'] != "" && $value['日期'] >= "$nowCheckDate2" && $value['日期'] <= "$nowCheckDate1"){
$list1[$i][5] += $value['count(*)'];
}
}
}
}
for($j = 0 ; $j < count($codeList);$j++){
$list1[$i][3] += $codeList[$j]['startcount'];
//$list1[$i][4] += $codeList[$j]['startuser'];
$list1[$i][16] += $codeList[$j]['newuser'];
$list1[$i][6] += $codeList[$j]['returnuser'];
$list1[$i][7] += $codeList[$j]['pointuser'];
$temp[$i][8] += $codeList[$j]['pointuserall'];
$temp[$i][9] += $codeList[$j]['returnuserall'];
$list1[$i][11] += $codeList[$j]['mr_user'];
$list1[$i][13] += $codeList[$j]['mr'];
}
//echo "this is ".$temp[$i][8]."===".$temp[$i][9],"
";
$willLikeDb1 = $willLinkDbName."激活数据1";
$query = "SELECT distinct `IMSI` FROM `$willLikeDb1` WHERE $chanel1 AND $ProductID1 AND $op AND $nowCheckDateStart";
$tempStartNmber = $m->query($query);
$list1[$i][4] = count($tempStartNmber);
if($nowProductID == 0 AND $nowChanel == 0){$list1[$i][5] = $list1[$i][16];}
$list1[$i][13] = $list1[$i][13]/100;
$list1[$i][0] = $codeList[0]['time'];
$list1[$i][1] = $nowProductID;//$codeList[0]['product'];
$list1[$i][2] = $nowChanel;//$codeList[0]['channel'];
$list1[$i][8] = intval(100*$temp[$i][8]/$list1[$i][7])/100;//$codeList[$j]['pointuserall']/$codeList[$j]['pointuser'];
$list1[$i][9] = IndexController::qubaifengbi($temp[$i][9]/$temp[$i][8]*100,2) . "%";
//$list1[$i][9] = intval(100*$temp[$i][9]/$temp[$i][8])."%";//$codeList[$j]['returnuserall']/$codeList[$j]['pointuserall']."%";
$list1[$i][10] = intval(100*$list1[$i][13]/$list1[$i][5])/100;//$codeList[$j]['mr']/$codeList[$j]['newuser'];
$list1[$i][12] = intval($list1[$i][13]/$list1[$i][11]*100)/100;//$list1[$i][13]/$list1[$i][11]
if($chcekDay > 1 && $chcekDay == $i){$list1[$i][0]="总计";}
if($chcekDay > 1){
if($chcekDay == $i){
$willCheckGochannel = "op=".$nowOp."&productID=".$nowProductID."&chanel=".$nowChanel."&checkDateStar=".$nowCheckDate2."&checkDateEnd=".$nowCheckDate1;
}else{
$willCheckGochannel = "op=".$nowOp."&productID=".$nowProductID."&chanel=".$nowChanel."&checkDateStar=".$nowCheckDate1."&checkDateEnd=".$nowCheckDate1;
}
if(($nowOp != 0 && $nowOp != 3 && $nowOp != 1) || $chcekDay != $i && $chcekDay != 1)$list1[$i][13] = IndexController::setUrl($list1[$i][13],$this->myIP."app/index.php/Home/Index/spIncomTableGoChanel"."?".$willCheckGochannel);
}else{
$willCheckGochannel = "op=".$nowOp."&productID=".$nowProductID."&chanel=".$nowChanel."&checkDateStar=".$nowCheckDate1."&checkDateEnd=".$nowCheckDate1;
if(($nowOp != 0 && $nowOp != 3 && $nowOp != 1) || $chcekDay != $i && $chcekDay != 1)$list1[$i][13] = IndexController::setUrl($list1[$i][13],$this->myIP."app/index.php/Home/Index/spIncomTableGoChanel"."?".$willCheckGochannel);
}
//这里符合省份新增 暂时以搜索的第一天为主。
$nowCheckCodeNumber1=800000+$nowOp;
$tempListPro = $m->query("SELECT `ShieldProvince` FROM `recordCodeInfo` WHERE `codeNumber`='$nowCheckCodeNumber1' AND `Time`='$nowCheckDate1' limit 1");
$temparryfor = explode("|",$tempListPro[0]['shieldprovince']);
$tempProvinceforSql = "(";
foreach($temparryfor as $value4){
$tempProvinceforSql .= "`Province` = '$value4' OR ";
}
$tempProvinceforSql = substr($tempProvinceforSql,0,strlen($tempProvinceforSql)-3);
$tempProvinceforSql .= ")";
$tempMyProList = $m->query("SELECT SUM(`NewUser`) FROM `$willLikeDb` WHERE $nowCheckDate AND $chanel AND $ProductID AND $opForNumber AND $tempProvinceforSql");
//echo "SELECT SUM(`NewUser`) FROM `$willLikeDb` WHERE $nowCheckDate AND $chanel AND $ProductID AND $opForNumber AND $tempProvinceforSql";
$list1[$i][14] = $tempMyProList[0]['sum(`newuser`)'];
$list1[$i][14] = intval(10000*$list1[$i][14]/$list1[$i][5])/100;
$list1[$i][14] .= "%";
$list1[$i][20] = $willCheckGochannel."&codeNumber="."0";
}
//var_dump($list1);
//echo '
';echo '
';echo '
';
if($chcekDay == 1){
$nowCheckDate = "(`time` = '$checkDateStarDateT')";
}else{
$nowCheckDate = "(`time` >= '$checkDateStarDateT' AND `time` <= '$checkDateEndDateT')";
}
//第二栏
$willLikeDb = $willLinkDbName."_checked_every_month";
$returnList = $m->query("SELECT * FROM `$willLikeDb` WHERE $nowCheckDate AND $chanel AND $ProductID AND $opForNumber ");
if($nowProductID == 0 AND $nowChanel == 0){
foreach($returnList as $value){
$tempNewUserArray["$value[province]"] += $value['newuser']; //排去平台重复 之后的新增APP USER
}
}else{
foreach($tempAppUserList as $value){
if($value['日期'] >= "$checkDateStarDateT" && $value['日期'] <= "$checkDateEndDateT"){
$tempNewUserArray["$value[归属地]"] += $value['count(*)'];
}
}
if($nowOp == 0){
foreach($tempAppUserList2 as $value){
if($value['日期'] >= "$checkDateStarDateT" && $value['日期'] <= "$checkDateEndDateT"){
$tempAppUserList2["$value[归属地]"] += $value['count(*)'];
}
}
foreach($tempAppUserList3 as $value){
if($value['日期'] >= "$checkDateStarDateT" && $value['日期'] <= "$checkDateEndDateT"){
$tempAppUserList3["$value[归属地]"] += $value['count(*)'];
}
}
foreach($tempAppUserList0 as $value){
if($value['日期'] >= "$checkDateStarDateT" && $value['日期'] <= "$checkDateEndDateT"){
$tempAppUserList0["$value[归属地]"] += $value['count(*)'];
}
}
}
}
$willLikeDb = $willLinkDbName."_code_every_month";
$codeList = $m->query("SELECT distinct `ReturnCode` FROM `$willLikeDb` WHERE $nowCheckDate AND $chanel AND $ProductID AND $opForNumber ORDER BY `ReturnCode` ASC");
if($nowOp == 0 || $nowOp == 3 || $nowOp == 1){//针对无回调的100008代码
$tempSbReturnCode = array("100008","100094");
foreach($tempSbReturnCode as $value){
$codeSbListMOUser[$value] = $m->query("SELECT SUM(`MoUserAll`) FROM `$willLikeDb` WHERE `ReturnCode` = '$value' AND `Time` <= '$checkDateEndDateT' AND `Time` >= '$checkDateStarDateT'");
//echo "SELECT SUM(`MoUserAll`) FROM `$willLikeDb` WHERE `ReturnCode` = '$value' AND `Time` <= '$checkDateEndDateT' AND `Time` >= '$checkDateStarDateT'","
";
$willLikeDbtemp = $willLinkDbName."数据";
$codeSbListMR[$value] = $m->query("SELECT SUM(`price`) FROM `$willLikeDbtemp` WHERE `记费代码` = '$value' AND `日期` <= '$checkDateEndDateT' AND `日期` >= '$checkDateStarDateT'");
//echo "SELECT SUM(`MoUserAll`) FROM `$willLikeDb` WHERE `ReturnCode` = '$value' AND `Time` <= '$checkDateEndDateT' AND `Time` >= '$checkDateStarDateT'","
";
}
}
//var_dump($codeSbListMOUser);
//var_dump($codeSbListMR);
//555555555
if($nowOp == 1 ){
$proListAllThis = array("北京", "天津", "河北", "山西", "内蒙古", "辽宁", "吉林",
"黑龙江", "上海", "江苏", "浙江", "安徽", "福建", "江西", "山东", "河南", "湖北", "湖南",
"广东", "广西", "海南", "四川", "贵州", "云南", "西藏", "陕西", "甘肃", "青海", "宁夏",
"新疆", "重庆");
$theWuZongOpenProvince = $m->query("SELECT `ShieldProvince` FROM `recordCodeInfo` WHERE `codeNumber`>= '900000' AND `Time`='$checkDateStarDateT' ");
$tempArryThis =array ();
$tempNumberThis=0;
$sizePro=sizeof($theWuZongOpenProvince);
$tempSizePro = $sizePro;
for($s=0;$s<31;$s++){
for($j=0;$j < $sizePro;$j++){
if($j==0 && $tempNumberThis>1){
$tempNumberThis=0;
}
if(IndexController::isInString($theWuZongOpenProvince[$j]['shieldprovince'],$proListAllThis[$s])){
$tempNumberThis ++;
}
if( $tempNumberThis == $tempSizePro){
array_push($tempArryThis,$proListAllThis[$s]);
}else{
continue;
}
}
}
unset($tempArryThis[0]);
unset($tempArryThis[$tempSizePro-1]);
$theWuZongOpenProvince = $tempArryThis;
//var_dump($theWuZongOpenProvince);
}
// die("9090");
$rowsNumber = 0;
foreach($codeList as $value){
$codeNumber = $value['returncode'];
$tempCodeNumber = "(`returncode` = '$codeNumber')";
$tempList = $m->query("SELECT * FROM `$willLikeDb` WHERE $nowCheckDate AND $chanel AND $ProductID AND $tempCodeNumber AND $opForNumber");
$list[$rowsNumber][0]=$this->codeLookUpTable["$codeNumber"];
$list[$rowsNumber][1]=$codeNumber;
for($j = 0 ; $j < count($tempList);$j++){
//$list[$rowsNumber][2] += $tempList[$j]['newuser'];
$list[$rowsNumber][3] += $tempList[$j]['mouserall'];
$list[$rowsNumber][4] += $tempList[$j]['mouser'];
$list[$rowsNumber][5] += $tempList[$j]['mocount'];
$list[$rowsNumber][6] += $tempList[$j]['mruserallfail'] + $tempList[$j]['mruserall'];
$list[$rowsNumber][7] += $tempList[$j]['mruserfail'] + $tempList[$j]['mruser'];
$list[$rowsNumber][8] += $tempList[$j]['mrcountfail'] + $tempList[$j]['mrcount'];
$list[$rowsNumber][9] += $tempList[$j]['mruserall'];
$list[$rowsNumber][10] += $tempList[$j]['mruser'];
$list[$rowsNumber][11] += $tempList[$j]['mrcount'];
/*
if($codeNumber > 900000){
$tempTotalMrSDK = $codeNumber;
}else{
$tempTotalMrUser = $codeNumber;
}*/
}
if($nowOp == 1 && $codeNumber == 1){//应吴总要求,计算不返回SDK计费 和自己代码计费的 请求
$list[$rowsNumber][3] = 0;
$list[$rowsNumber][4] = 0;
$list[$rowsNumber][5] = 0;
for($j = 0 ; $j < count($tempList);$j++){
if(IndexController::isInString($theWuZongOpenProvince,$tempList[$j]['province'])){
$list[$rowsNumber][3] += $tempList[$j]['mouserall'];
$list[$rowsNumber][4] += $tempList[$j]['mouser'];
$list[$rowsNumber][5] += $tempList[$j]['mocount'];
}
}
}
if($codeNumber == 100008 || $codeNumber == 100094){//针对无回调的100008 100094代码
$list[$rowsNumber][11] = ($list[$rowsNumber][3]/$codeSbListMOUser[$codeNumber][0]['sum(`mouserall`)'])*$codeSbListMR[$codeNumber][0]['sum(`price`)'];
$list[$rowsNumber][11] = IndexController::qubaifengbi($list[$rowsNumber][11]/100,0)*100;
$tempSbcodeNumberSb[$codeNumber] = $list[$rowsNumber][11];
}
//这里符合省份新增 暂时以搜索的第一天为主。
$tempListPro = $m->query("SELECT `ShieldProvince` FROM `recordCodeInfo` WHERE `codeNumber`='$codeNumber' AND `Time`='$checkDateStarDateT' limit 1");
$proListOpen = IndexController::getProvinceNumber($tempListPro[0]['shieldprovince'],$this->proListMove);
foreach($this->proListMove as $key4 => $value4){
if(IndexController::isInString($proListOpen,$value4)){
$list[$rowsNumber][2] += $tempNewUserArray["$value4"];
}
}
$list[$rowsNumber][5] = $list[$rowsNumber][5]/100;
$list[$rowsNumber][8] = $list[$rowsNumber][8]/100;
$list[$rowsNumber][11] = $list[$rowsNumber][11]/100;
$list[$rowsNumber][12] = $list[$rowsNumber][11] * $this->codeLookUpTableInfo["$codeNumber"];
if($chcekDay == 1){
$list1[0][15] += $list[$rowsNumber][12];//第一张表的收入
}else{
$list1[$chcekDay][15] += $list[$rowsNumber][12];//第一张表的收入
}
$list[$rowsNumber][13] = $list[$rowsNumber][11]/$list[$rowsNumber][10];
$list[$rowsNumber][14] = $list[$rowsNumber][10]/$list[$rowsNumber][4];
$list[$rowsNumber][15] = $list[$rowsNumber][11]/$list[$rowsNumber][5];
$list[$rowsNumber][16] = $list[$rowsNumber][10]/$list[$rowsNumber][7];
$list[$rowsNumber][17] = $list[$rowsNumber][10]/$list[$rowsNumber][2];
$list[$rowsNumber][18] = $list[$rowsNumber][11]/$list[$rowsNumber][2];
$list[$rowsNumber][2] = $list[$rowsNumber][2]?$list[$rowsNumber][2]:0;
for($tempi = 13;$tempi <= 18;$tempi++){
$list[$rowsNumber][$tempi] = $list[$rowsNumber][$tempi]?$list[$rowsNumber][$tempi]:0;
if($tempi == 18 || $tempi == 13){
$list[$rowsNumber][$tempi] = IndexController::qubaifengbi($list[$rowsNumber][$tempi],2);
}else{
$list[$rowsNumber][$tempi] = IndexController::qubaifengbi($list[$rowsNumber][$tempi]*100,2) . "%";
}
}
/*
$list[$rowsNumber][14] = $tempList[$j]['MrCount'];
$list[$rowsNumber][15] = 10/7 $tempList[$j]['MrUser'];
$list[$rowsNumber][16] = 11/5 $tempList[$j]['MrCount'];
$list[$rowsNumber][17] = 11/8$tempList[$j]['MrUser'];
$list[$rowsNumber][18] = 10/2$tempList[$j]['MrCount'];
*/
$list[$rowsNumber][19] = $willCheckPar."&codeNumber=".$codeNumber;
$rowsNumber++;
}
//查其它SDK数据 把其它SDK当成数据在下方显示
//var_dump($list1);
if($nowOp == 0 || $nowOp == 3 ){//针对无回调的100008代码
$tempNumberI = 0;
if($chcekDay > 1){
$tempNumberI = $chcekDay;
}
$list1[$tempNumberI][13] = $list1[$tempNumberI][13] + $tempSbcodeNumberSb[100008]/100;
$list1[$tempNumberI][10] = intval(100*$list1[$tempNumberI][13]/$list1[$tempNumberI][5])/100;//$codeList[$j]['mr']/$codeList[$j]['newuser'];
$list1[$tempNumberI][13] = IndexController::setUrl($list1[$tempNumberI][13],$this->myIP."app/index.php/Home/Index/spIncomTableGoChanel"."?".$willCheckGochannel);
}elseif($nowOp == 1){
$tempNumberI = 0;
if($chcekDay > 1){
$tempNumberI = $chcekDay;
}
//echo $list1[$tempNumberI][13],"
";
$list1[$tempNumberI][13] = $list1[$tempNumberI][13] + $tempSbcodeNumberSb[100094]/100;
$list1[$tempNumberI][10] = intval(100*$list1[$tempNumberI][13]/$list1[$tempNumberI][5])/100;//$codeList[$j]['mr']/$codeList[$j]['newuser'];
$list1[$tempNumberI][13] = IndexController::setUrl($list1[$tempNumberI][13],$this->myIP."app/index.php/Home/Index/spIncomTableGoChanel"."?".$willCheckGochannel);
}
/*
$list[$rowsNumber][11]=$succMr[0]['sum(`price`)']/100;
$rowsNumber++;
}//foreach结束
*/
//这里查进行分数据
$willLikeDb = $willLinkDbName."请求付费次数";
$i = 0;
$theCheckData[0] = $nowProductID;
$theCheckData[1] = $nowChanel;
$theCheckData[2] = $nowCheckDateStar;
$theCheckData[3] = $nowCheckDateEnd;
$this->assign('theCheckData',$theCheckData);
MiLi1123:
$this->list=$list;
//$this->page=$p->show();
//上面查进行分数据
$this->assign('list1',$list1);
$this->assign('list',$list);
$this->assign('willShowDbName1',"总收入");
$willShowDbName = "SP收入列表";//表头名
//$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/spIncomTable");//查询对应的HTTP界面
$this->assign('willShowDbName',$willShowDbName);
$this->assign('TableHeader1',$this->TableHeader[4]);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->assign('TableHeader',$this->TableHeader[$UseNumberT]);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
$this->assign('theCheckData',$theCheckData);
$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/spIncomTable2");
$this->display();
}
public function spIncomTableInfo2(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
IndexController::getFenchengAndName();//赋值 codeLook|UpTableTable
$nowOp = I('get.op');
$nowProductID = I('get.productID');
$nowChanel = I('get.chanel');
$nowCheckDateStar = I('get.checkDateStar');
$nowCheckDateEnd = I('get.checkDateEnd');
$nowCheckCodeNumber = I('get.codeNumber');
$nowIsCheck = I('get.isCheck');
$UseNumberT = 7;//
$isSendEmail = 0;
date_default_timezone_set("PRC");
$t=time();//为这次访问的时间数据
$tBeiJing=$t+0;
//这里开始查代码。
$chanel = "(`Channel` = '$nowChanel')";//自已定义的渠道号1002
$chanel1 = "(`渠道号` = '$nowChanel')";
if($nowChanel == 0){$chanel = "1";$chanel1 = "1";}
$checkDateStar = strtotime($nowCheckDateStar." 0:00:00");
$checkDateEnd = strtotime($nowCheckDateEnd." 0:00:00");
$checkDateStarDateT = date("Y-m-d",$checkDateStar+10);
$checkDateEndDateT = date("Y-m-d",$checkDateEnd+10);
$willLinkDbName = date("ym",$checkDateStar+10);
$op = "(`运营商` = '$nowOp')";$op1 = "(`运营商` = '$nowOp')";
$opForNumber = "(`op` = '$nowOp')";
if($nowOp == 0){$op = "1";$opForNumber = "1";$op1 = "(`运营商` = '1')";}
$ProductID = "(`Product` = '$nowProductID')";
$ProductID1 = "(`产品号` = '$nowProductID')";
if($nowProductID == 0){$ProductID = "1";$ProductID1 = "(1)";}
if($nowProductID == 600000){$ProductID = "(`Product` > $nowProductID AND `Product` < 700000 )";$ProductID1 = "(`产品号` > $nowProductID AND `产品号` < 700000 )";}
if($nowProductID == 500000){$ProductID = "(`Product` > $nowProductID AND `Product` < 600000 )";$ProductID1 = "(`产品号` > $nowProductID AND `产品号` < 600000 )";}
if($nowProductID == 400000){$ProductID = "(`Product` > $nowProductID AND `Product` < 500000 )";$ProductID1 = "(`产品号` > $nowProductID AND `产品号` < 500000 )";}
if($nowProductID == 200000){$ProductID = "(`Product` > $nowProductID AND `Product` < 300000 )";$ProductID1 = "(`产品号` > $nowProductID AND `产品号` < 300000 )";}
if($nowProductID == 300000){$ProductID = "((`Product` > $nowProductID) AND `Product` < 400000 OR (`Product` = 0))";$ProductID1 = "((`产品号` > $nowProductID) AND `产品号` < 400000 OR (`产品号` = 0))";}
if($nowProductID == 100000){$ProductID = "(`Product` > $nowProductID AND `Product` < 200000)";$ProductID1 = "(`产品号` > $nowProductID AND `产品号` < 200000)";}
$code = "(`返回代码编号` = '$nowCheckCodeNumber')";
$codeTable2 = "(`记费代码` = '$nowCheckCodeNumber')";
$tempCodeNumber = "(`returncode` = '$nowCheckCodeNumber')";
if($nowCheckCodeNumber == 0){$tempCodeNumber = "(`returncode` != '0')";$nowCheckCodeNumber1=800000+$nowOp;}else{$nowCheckCodeNumber1=$nowCheckCodeNumber;}
$willLikeDb = "代码";
$m=M($willLikeDb);
//$codeList = $m->query("SELECT distinct `代码编号`,`屏蔽省` FROM `$willLikeDb` WHERE `代码编号` = '$nowCheckCodeNumber' GROUP BY `代码编号` ORDER BY `$willLikeDb`.`代码编号` ASC");
$nowCheckTimeStampStart = $checkDateStar + 86400 * $i;
//$nowCheckTimeStampEnd = $checkDateStar + 86400 * $i;
$nowCheckDate1 = date("Y-m-d",$checkDateEnd + 60);
$chcekDay = ($checkDateEnd - $checkDateStar)/ 86400;
if($chcekDay > 0){
$nowCheckDate2 = date("Y-m-d",$checkDateStar + 60);
$nowCheckDate = "(`time` >= '$nowCheckDate2' AND `time` <= '$nowCheckDate1')";
}else{
$nowCheckDate = "(`time` = '$nowCheckDate1')";
}
$tempListPro = $m->query("SELECT `ShieldProvince` FROM `recordCodeInfo` WHERE `codeNumber`='$nowCheckCodeNumber1' AND `Time`='$nowCheckDate1' limit 1");
if($nowCheckCodeNumber == 0){$code = "(1)";$codeTable2 = "(1)";}
$proListOpen = IndexController::getProvinceNumber($tempListPro[0]["shieldprovince"],$this->proListMove);
$willLikeDb = $willLinkDbName."激活数据";
$willLinkDbLateTime = date("ym",$checkDateStar+10) - 1;
if($willLinkDbLateTime % 100 == 0){$willLinkDbLateTime = date("ym",$checkDateStar + 10 - 86400 * 24);}
$willLikeDbLate = $willLinkDbLateTime."激活数据";
//$query = "SELECT `日期`,`归属地`,COUNT(*) FROM (SELECT distinct `IMSI`,`日期`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < '$t' AND $chanel1 AND $ProductID1 AND $op1 GROUP BY `IMSI` ORDER BY `时间戳` ASC ) as t GROUP BY `归属地`,`日期`;";
$query = "SELECT `日期`,`归属地`,COUNT(*) FROM (SELECT distinct `IMSI`,`日期`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < '$t' AND $chanel1 AND $ProductID1 AND $op1 GROUP BY `IMSI` ORDER BY `时间戳` ASC )as t1 LEFT JOIN (SELECT distinct `IMSI` AS `i`FROM `$willLikeDbLate` WHERE $chanel1 AND $ProductID1 AND $op1)as t2 ON t1.`IMSI`=t2.`i` WHERE t2.`i` IS NULL GROUP BY `归属地`,`日期`;";
$tempAppUserList = $m->query($query);
//echo "
",$query,"
";
//var_dump($tempAppUserList);
foreach($tempAppUserList as $value){
if($value['日期'] >= "$checkDateStarDateT" && $value['日期'] <= "$checkDateEndDateT"){
$tempNewUserArray["$value[归属地]"] += $value['count(*)'];
}
}
$tempNumber = 0;
$test = $this->proListMove;
$test[31] = "无";
foreach ($test as $value1){
$isOpenPro = 0;
$list[$tempNumber][0] = $value1;
if(IndexController::isInString($proListOpen,$value1) ){$list[$tempNumber][0] .= "(开通)";$isOpenPro = 1;}
$tempNowChcekPro = "(`Province` = '$value1')";
$willLikeDb = $willLinkDbName."_checked_every_month";
$tempList = $m->query("SELECT * FROM `$willLikeDb` WHERE $nowCheckDate AND $tempNowChcekPro AND $chanel AND $ProductID AND $opForNumber ");
for($j = 0 ; $j < count($tempList);$j++){
//$list[$tempNumber][1] += $tempList[$j]['newuser'];//去重之后的平台新增
$list[$tempNumber][2] += $tempList[$j]['startuser'];
if($nowCheckCodeNumber == 0){
$list[$tempNumber][4] += $tempList[$j]['pointuser'];
}
}
$list[$tempNumber][1] = $tempNewUserArray["$value1"];
$codeNumber = $value['returncode'];
$willLikeDb = $willLinkDbName."_code_every_month";
$tempList = $m->query("SELECT * FROM `$willLikeDb` WHERE $nowCheckDate AND $tempNowChcekPro AND $chanel AND $ProductID AND $tempCodeNumber AND $opForNumber");
for($j = 0 ; $j < count($tempList);$j++){
$list[$tempNumber][3] += $tempList[$j]['mouserall'];
if($nowCheckCodeNumber != 0){$list[$tempNumber][4] += $tempList[$j]['mouser'];}
$temp1[$tempNumber][0] += $tempList[$j]['mocount'];
$list[$tempNumber][5] += $tempList[$j]['mruserallfail'] + $tempList[$j]['mruserall'];
$list[$tempNumber][6] += $tempList[$j]['mruserfail'] + $tempList[$j]['mruser'];
$list[$tempNumber][7] += $tempList[$j]['mruserall'];
$list[$tempNumber][8] += $tempList[$j]['mruser'];
$list[$tempNumber][9] += $tempList[$j]['mrcount'];
}
$list[$tempNumber][9] = $list[$tempNumber][9]/100;
$temp1[$tempNumber][0] = $temp1[$tempNumber][0]/100;
$list[$tempNumber][10] = $list[$tempNumber][9]/$list[$tempNumber][1];
$list[$tempNumber][11] = $list[$tempNumber][9]/$list[$tempNumber][8];
$list[$tempNumber][12] = $list[$tempNumber][8]/$list[$tempNumber][4];
$list[$tempNumber][13] = $list[$tempNumber][9]/$temp1[$tempNumber][0];
for($tempi = 10;$tempi <= 13;$tempi++){
$list[$tempNumber][$tempi] = $list[$tempNumber][$tempi]?$list[$tempNumber][$tempi]:0;
if($tempi == 10 || $tempi == 11){
$list[$tempNumber][$tempi] = IndexController::qubaifengbi($list[$tempNumber][$tempi],2);
}else{
$list[$tempNumber][$tempi] = IndexController::qubaifengbi($list[$tempNumber][$tempi]*100,2) . "%";
}
}
if ($nowIsCheck == 1){
if ($isOpenPro == 1 && $list[$tempNumber][2] > 30 && (intval(($list[$tempNumber][6] / $list[$tempNumber][4])*10000)/100) < 8){
$isSendEmail = $tempNumber;
}
}
//这里给字体增加URL
$url = $_SERVER['QUERY_STRING'];//'http://'.$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF'].'?'.$_SERVER['QUERY_STRING'];
$tempNewUserfornext = $list[$tempNumber][1];
$list[$tempNumber][1] = IndexController::setUrl($list[$tempNumber][1],$this->myIP."app/index.php/Home/Index/spIncomTableInfoGoChanel"."?province=$tempNumber"."&".$url);
$list[$tempNumber][3] = IndexController::setUrl($list[$tempNumber][3],$this->myIP."app/index.php/Home/Index/spIncomTableInfoGoCode2"."?province=$tempNumber"."&"."newappuser=$tempNewUserfornext"."&".$url);
if ($nowIsCheck == 1){
$url = 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF'].'?'.$_SERVER['QUERY_STRING'];
echo "";
$chcekOpen[0] = "open1";
$chcekOpen[1] = "open2";
$chcekOpen[2] = "1";
}else{
$chcekOpen[0] = "close1";
$chcekOpen[1] = "close2";
$chcekOpen[2] = "0";
}
if ($isSendEmail != 0){
$mail = new \MySendMail();
$mail->setServer("smtp.qq.com", "2893656503@qq.com", "blyxbjoosnxpdeah", 465, true); //设置smtp服务器,到服务器的SSL连接
$mail->setFrom("2893656503@qq.com"); //设置发件人
$mail->setReceiver("515298497@qq.com"); //设置收件人,多个收件人,调用多次
$mail->setReceiver("1442364747@qq.com"); //设置收件人,多个收件人,调用多次
$mail->setReceiver("1033955681@qq.com"); //设置收件人,多个收件人,调用多次
$province = $GLOBALS['province'];
$mail->setMail("收入异常!", "".$url.""); //设置邮件主题、内容
$mail->sendMail(); //发送
}
$tempNumber++;
}
//var_dump($list);
$this->assign('open',$chcekOpen);
$this->list=$list;
$willShowDbName = $this->codeLookUpTable["$nowCheckCodeNumber"]."($nowCheckCodeNumber)收入分析";//表头名
if($nowCheckCodeNumber == 0){$willShowDbName="省份分析";}
$this->assign('willShowDbName',$willShowDbName);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->assign('TableHeader',$this->TableHeader[$UseNumberT]);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
$this->display();
}
public function spIncomTableInfoGoCode2(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
IndexController::getFenchengAndName();//赋值 codeLook|UpTableTable
$nowOp = I('get.op');
$nowProductID = I('get.productID');
$nowChanel = I('get.chanel');
$nowCheckDateStar = I('get.checkDateStar');
$nowCheckDateEnd = I('get.checkDateEnd');
$nowCheckCodeNumber = I('get.codeNumber');
$nowIsCheck = I('get.isCheck');
$nowCheckProvince = I('get.province');
$isSendEmail = 0;
$nowCheckProvinceNewAppUser = I('get.newappuser');
date_default_timezone_set("PRC");
$t=time();//为这次访问的时间数据
$tBeiJing=$t+0;
//这里开始查代码。
$chanel = "(`Channel` = '$nowChanel')";//自已定义的渠道号1002
if($nowChanel == 0){$chanel = "1";}
$checkDateStar = strtotime($nowCheckDateStar." 0:00:00");
$checkDateEnd = strtotime($nowCheckDateEnd." 0:00:00");
$checkDateStarDateT = date("Y-m-d",$checkDateStar+10);
$checkDateEndDateT = date("Y-m-d",$checkDateEnd+10);
$willLinkDbName = date("ym",$checkDateStar+10);
$op = "(`运营商` = '$nowOp')";
$opForNumber = "(`op` = '$nowOp')";
if($nowOp == 0){$op = "1";$opForNumber = "1";}
$ProductID = "(`Product` = '$nowProductID')";
if($nowProductID == 0){$ProductID = "1";}
//if($nowProductID == 200000){$ProductID = "(`产品号` > $nowProductID)";}
if($nowProductID == 500000){$ProductID = "(`Product` > $nowProductID AND `Product` < 600000 )";}
if($nowProductID == 400000){$ProductID = "(`Product` > $nowProductID AND `Product` < 500000 )";}
if($nowProductID == 200000){$ProductID = "(`Product` > $nowProductID AND `Product` < 300000 )";}
if($nowProductID == 300000){$ProductID = "((`Product` > $nowProductID) AND `Product` < 400000 OR (`Product` = 0))";}
if($nowProductID == 100000){$ProductID = "(`Product` > $nowProductID AND `Product` < 200000)";}
$code = "(`返回代码编号` = '$nowCheckCodeNumber')";
$codeTable2 = "(`记费代码` = '$nowCheckCodeNumber')";
$tempCodeNumber = "(`returncode` = '$nowCheckCodeNumber')";
$willLikeDb = "代码";
$m=M($willLikeDb);
$ProList = $this->proListMove;
$tempProvince = $ProList[$nowCheckProvince];
if(strlen($tempProvince) > 2){
$tempNowChcekPro = "(`Province` = '$tempProvince')";
}else{
$tempNowChcekPro = "1";
}
$nowCheckDate1 = date("Y-m-d",$checkDateEnd + 60);
$chcekDay = ($checkDateEnd - $checkDateStar)/ 86400;
if($chcekDay > 0){
$nowCheckDate2 = date("Y-m-d",$checkDateStar + 60);
$nowCheckDate = "(`time` >= '$nowCheckDate2' AND `time` <= '$nowCheckDate1')";
}else{
$nowCheckDate = "(`time` = '$nowCheckDate1')";
}
if($nowCheckCodeNumber == 0){$tempCodeNumber = "(`returncode` != '0')";
}else{
//这里出打相应数据
$this->list=$list;
$this->assign('willShowDbName1',$tempProvince.":代码 $nowCheckCodeNumber 请求详情表");
$willShowDbName = "SP收入列表";//表头名
//$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/spIncomTable");//查询对应的HTTP界面
$this->assign('willShowDbName',$willShowDbName);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->assign('TableHeader',$this->TableHeader[5]);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
$this->display();
die();
}
$codeNumber = $value['returncode'];
$willLikeDb = $willLinkDbName."_code_every_month";
$tempList = $m->query("SELECT `ReturnCode`,SUM(`MoUser`),SUM(`MoUserAll`),SUM(`MoCount`),SUM(`mruserallfail`),SUM(`mruserfail`),SUM(`mrcountfail`),SUM(`mruserall`),SUM(`mruser`),SUM(`mrcount`),SUM(`newUser`) FROM `$willLikeDb` WHERE $nowCheckDate AND $tempNowChcekPro AND $chanel AND $ProductID AND $tempCodeNumber AND $opForNumber GROUP BY `ReturnCode`");
/*
foreach($tempList as $value){
$tempNewAppUser += $value["sum(`newuser`)"];
}*/
$rowsNumber = 0;
foreach($tempList as $value){
//echo "代码".$value['returncode']."共有".$value['sum(`mouser`)']."个用户请求 ".$value['sum(`mouserall`)']."次",'
';
$codeNumber = $value['returncode'];
//$tempCodeNumber = "(`returncode` = '$codeNumber')";
$list[$rowsNumber][0]=$this->codeLookUpTable["$codeNumber"];
$list[$rowsNumber][1]=$codeNumber;
$list[$rowsNumber][2]=$nowCheckProvinceNewAppUser;
$list[$rowsNumber][3] += $value['sum(`mouserall`)'];
$list[$rowsNumber][4] += $value['sum(`mouser`)'];
$list[$rowsNumber][5] += $value['sum(`mocount`)'];
$list[$rowsNumber][6] += $value['sum(`mruserallfail`)'] + $value['sum(`mruserall`)'];
$list[$rowsNumber][7] += $value['sum(`mruserfail`)'] + $value['sum(`mruser`)'];
$list[$rowsNumber][8] += $value['sum(`mrcountfail`)'] + $value['sum(`mrcount`)'];
$list[$rowsNumber][9] += $value['sum(`mruserall`)'];
$list[$rowsNumber][10] += $value['sum(`mruser`)'];
$list[$rowsNumber][11] += $value['sum(`mrcount`)'];
//这里符合省份新增 暂时以搜索的第一天为主。
$tempListPro = $m->query("SELECT `ShieldProvince` FROM `recordCodeInfo` WHERE `codeNumber`='$codeNumber' AND `Time`='$checkDateStarDateT' limit 1");
$proListOpen = IndexController::getProvinceNumber($tempListPro[0]['shieldprovince'],$this->proListMove);
foreach($this->proListMove as $key4 => $value4){
if(IndexController::isInString($proListOpen,$value4)){
$list[$rowsNumber][2] += $tempNewUserArray["$value4"];
}
}
$list[$rowsNumber][5] = $list[$rowsNumber][5]/100;
$list[$rowsNumber][8] = $list[$rowsNumber][8]/100;
$list[$rowsNumber][11] = $list[$rowsNumber][11]/100;
$list[$rowsNumber][13] = $list[$rowsNumber][11]/$list[$rowsNumber][10];
$list[$rowsNumber][14] = $list[$rowsNumber][10]/$list[$rowsNumber][4];
$list[$rowsNumber][15] = $list[$rowsNumber][11]/$list[$rowsNumber][5];
$list[$rowsNumber][16] = $list[$rowsNumber][10]/$list[$rowsNumber][7];
$list[$rowsNumber][17] = $list[$rowsNumber][10]/$list[$rowsNumber][2];
$list[$rowsNumber][18] = $list[$rowsNumber][11]/$list[$rowsNumber][2];
$list[$rowsNumber][2] = $list[$rowsNumber][2]?$list[$rowsNumber][2]:0;
for($tempi = 13;$tempi <= 18;$tempi++){
$list[$rowsNumber][$tempi] = $list[$rowsNumber][$tempi]?$list[$rowsNumber][$tempi]:0;
if($tempi == 18 || $tempi == 13){
$list[$rowsNumber][$tempi] = IndexController::qubaifengbi($list[$rowsNumber][$tempi],2);
}else{
$list[$rowsNumber][$tempi] = IndexController::qubaifengbi($list[$rowsNumber][$tempi]*100,2) . "%";
}
}
/*
$list[$rowsNumber][14] = $tempList[$j]['MrCount'];
$list[$rowsNumber][15] = 10/7 $tempList[$j]['MrUser'];
$list[$rowsNumber][16] = 11/5 $tempList[$j]['MrCount'];
$list[$rowsNumber][17] = 11/8$tempList[$j]['MrUser'];
$list[$rowsNumber][18] = 10/2$tempList[$j]['MrCount'];
*/
$rowsNumber++;
}
$this->list=$list;
$this->assign('willShowDbName1',$tempProvince.":请求列表");
$willShowDbName = "SP收入列表";//表头名
//$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/spIncomTable");//查询对应的HTTP界面
$this->assign('willShowDbName',$willShowDbName);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->assign('TableHeader',$this->TableHeader[5]);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
$this->assign('theCheckData',$theCheckData);
$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/spIncomTable2");
$this->display();
}
public function testmymimicaculation($time = "0"){
ini_set('max_execution_time', '0');
ini_set("memory_limit","1024M");
ini_set('display_errors', 1);
$checkDateTimeStamp = strtotime($time." 00:00:00");
for($i=0;$i<30;$i++){
$checkDate = date("Y-m-d",$checkDateTimeStamp + $i * 86400 + 10);
echo $checkDate,"
";
//$this->caculationMYmimi($checkDate);
}
}
public function caculationMYmimi($time = "0"){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
if($time == "0"){echo "请输入时间";}
$nowTime = time();
if($nowTime < (session('MyTempTime') + 60) ){
die($nowTime."=error=".(session('MyTempTime') + 60));
}
session('MyTempTime',$nowTime);
//夏令时为准
ini_set('max_execution_time', '0');
ini_set("memory_limit","1024M");
echo $time,"
";
date_default_timezone_set("PRC");
//以时间为判断依据
$EveryDayTime = date('H:i:s');//$EveryDayTime == "05:00:10"
if(true)
{
$checkDateTimeStamp = strtotime($time." 00:00:00");
$checkDateTimeStampEnd = strtotime($time." 24:00:00");
$checkDate = date("Y-m-d",$checkDateTimeStamp + 10);
$willLinkDbName = date("ym",$checkDateTimeStamp + 10);
$willLikeDb = "开关";
$m=M($willLikeDb);
//error_reporting(0);
ini_set('display_errors', 1);
$link = mysql_connect('localhost:3306','root','zz753951');
if (!$link) {
die(iconv("GB2312","UTF-8",'连接服务器失败:'."
"). mysql_error());
}
mysql_query("set names 'utf8'");
mysql_select_db("door", $link);
$tempReslt = mysql_query("DELETE FROM `recordCodeInfo` WHERE `Time`='$checkDate'");
$tempListPro = $m->query("SELECT `屏蔽省`,`代码编号` FROM `代码` GROUP BY `代码编号`");
for($i=0;$i < count($tempListPro);$i++){
$tempA = $tempListPro[$i]['屏蔽省'];
$tempB = $tempListPro[$i]['代码编号'];
$result = mysql_query("INSERT INTO `recordCodeInfo` (`ShieldProvince`, `codeNumber`, `Time`)
VALUES ('$tempA', '$tempB', '$checkDate')");
}
$willLikeDb = $willLinkDbName."激活数据";
$willLinkDbLateTime = $willLinkDbName - 1;
if($willLinkDbLateTime % 100 == 0){$willLinkDbLateTime = 1612;}
$willLikeDbLate = $willLinkDbLateTime."激活数据";
for($i=0;$i<4;$i++){
$query = "SELECT * FROM
(SELECT distinct `IMSI`,`日期`,`归属地`,`产品号`,`渠道号`,`运营商` FROM `$willLikeDb`
WHERE `时间戳` < '$checkDateTimeStampEnd' AND `运营商` = '$i' GROUP BY `IMSI` ORDER BY `时间戳` ASC )as t1
LEFT JOIN (SELECT distinct `IMSI` AS `i`FROM `$willLikeDbLate` WHERE `运营商` = '$i')as t2 ON t1.`IMSI`=t2.`i` WHERE t2.`i` IS NULL AND t1.`日期` = '$checkDate';";
//echo $query;
//$query = "SELECT * FROM (SELECT distinct `IMSI`,`日期`,`归属地`,`产品号`,`渠道号`,`运营商` FROM `$willLikeDb` WHERE `时间戳` < '$checkDateTimeStampEnd' AND `运营商` = '$i' GROUP BY `IMSI` ORDER BY `时间戳` ASC) as t WHERE `日期` = '$checkDate' ORDER BY `渠道号` ASC";
$UserNewAll= $m->query($query);
foreach($UserNewAll as $value)
{
$tempArrayUserNewAll["$value[运营商]"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++;
}
}
$UserAll= $m->query("SELECT `IMSI`,`产品号`,`渠道号`,`运营商`,`归属地` FROM `$willLikeDb` where `日期`='$checkDate' ORDER BY `IMSI` DESC");
$n = 0;
foreach($UserAll as $value)
{
$n++;
$tempArrayStartAll["$value[运营商]"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++;
if($UserAll[$n]["imsi"] != $UserAll[$n - 1]["imsi"]){
$tempArrayUserAll["$value[运营商]"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++;
}
}
$willLikeDb = $willLinkDbName."请求付费次数";
//返回用户数
$UserNumberReturnCodeList = $m->query("SELECT `IMSI`,`归属地`,`产品号`,`渠道号`,`运营商`,`返回代码编号`,`返回价格`,`price` FROM `$willLikeDb` WHERE `日期`='$checkDate' ORDER BY `IMSI`,`返回代码编号` DESC");
//echo "SELECT `IMSI`,`归属地`,`产品号`,`渠道号`,`运营商`,`返回代码编号`,`返回价格` FROM `$willLikeDb` WHERE `日期`='$checkDate' ORDER BY `IMSI`,`返回代码编号` DESC";
$j = 0;
foreach($UserNumberReturnCodeList as $value)
{
$j++;
if($value['返回代码编号'] != 0){
$tempArrayReturnUser["$value[运营商]"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++;
}
if($value['isCompleted'] == 0){
$tempArrayPointUser["$value[运营商]"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++;
}
$tempCodeArrayPointUser["$value[运营商]"]["$value[返回代码编号]"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++; //第二栏
if($value['运营商'] == 1 && $value['返回代码编号'] == 0){//应吴总要求,计算不返回SDK计费 和自己代码计费的 请求
$tempCodeArrayPointUser[1][1]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++; //第二栏
}
$tempCodeArrayPointUserPrice["$value[运营商]"]["$value[返回代码编号]"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"] += $value['返回价格']; //第二栏
if($value['运营商'] == 1 && $value['返回代码编号'] == 0){//应吴总要求,计算不返回SDK计费 和自己代码计费的 请求
$tempCodeArrayPointUserPrice["$value[运营商]"]["$value[返回代码编号]"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"] += $value['price']; //第二栏
$tempCodeArrayPointUserPrice[1][1]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"] += $value['price']; //第二栏
}
if($UserNumberReturnCodeList[$j - 1]['imsi'] != $UserNumberReturnCodeList[$j]['imsi']){
$tempCodeArrayPointUserTwo["$value[运营商]"]["$value[返回代码编号]"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++; //第二栏
if($value['运营商'] == 1 && $value['返回代码编号'] == 0){//应吴总要求,计算不返回SDK计费 和自己代码计费的 请求
$tempCodeArrayPointUserTwo[1][1]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++; //第二栏
}
}else{
if($UserNumberReturnCodeList[$j - 1]['返回代码编号'] != $UserNumberReturnCodeList[$j]['返回代码编号']){
$tempCodeArrayPointUserTwo["$value[运营商]"]["$value[返回代码编号]"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++; //第二栏
if($value['运营商'] == 1 && $value['返回代码编号'] == 0){//应吴总要求,计算不返回SDK计费 和自己代码计费的 请求
$tempCodeArrayPointUserTwo[1][1]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++; //第二栏
}
}
}
}
$UserNumberReturnTwo = $m->query("SELECT distinct `IMSI`,`归属地`,`产品号`,`渠道号`,`运营商`,`返回代码编号` FROM `$willLikeDb` WHERE `日期`='$checkDate' GROUP BY `IMSI`");
foreach($UserNumberReturnTwo as $value)
{
$tempArrayPointUserTwo["$value[运营商]"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++;
}
$UserNumberReturnThree = $m->query("SELECT distinct `IMSI`,`归属地`,`产品号`,`渠道号`,`运营商`,`返回代码编号` FROM `$willLikeDb` WHERE `日期`='$checkDate' AND `返回代码编号` != '0' GROUP BY `IMSI`");
foreach($UserNumberReturnThree as $value)
{
$tempArrayReturnUserTwo["$value[运营商]"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++;
}
$willLikeDb = $willLinkDbName."数据";
$MRlist = $m->query("SELECT `price`,`产品号`,`渠道号`,`op`,`ICCID省`,`记费代码` FROM `$willLikeDb` WHERE `日期`='$checkDate'");
foreach($MRlist as $value)
{
$tempArrayPriceNumber["$value[op]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"]++;
$tempArrayPrice["$value[op]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"] += $value['price'];
$tempCodeArrayPrice["$value[op]"]["$value[记费代码]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"] += $value['price']; //第二栏
$tempCodeArrayNumber["$value[op]"]["$value[记费代码]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"]++; //第二栏
}
$MRlist2 = $m->query("SELECT DISTINCT `IMSI`,`产品号`,`渠道号`,`op`,`ICCID省`,`记费代码` FROM `$willLikeDb` WHERE `日期`='$checkDate' GROUP BY `IMSI`");
foreach($MRlist2 as $value)
{
$tempArrayPriceNumberTwo["$value[op]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"]++;
//$tempCodeArrayNumberTwo["$value[记费代码]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"]++; //第二栏
}
$MRlist3 = $m->query("SELECT DISTINCT `IMSI`,`产品号`,`渠道号`,`op`,`ICCID省`,`记费代码` FROM `$willLikeDb` WHERE `日期`='$checkDate' GROUP BY `IMSI`,`记费代码`");
foreach($MRlist3 as $value)
{
//$tempArrayPriceNumberTwo["$value[op]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"]++;
$tempCodeArrayNumberTwo["$value[op]"]["$value[记费代码]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"]++; //第二栏
}
$willLikeDb = $willLinkDbName."失败计费数据";
$MRlistFail = $m->query("SELECT `price`,`产品号`,`渠道号`,`op`,`ICCID省`,`记费代码` FROM `$willLikeDb` WHERE `日期`='$checkDate'");
foreach($MRlistFail as $value)
{
$tempArrayPriceNumberFail["$value[op]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"]++;
$tempArrayPriceFail["$value[op]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"] += $value['price'];
$tempCodeArrayPriceFail["$value[op]"]["$value[记费代码]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"] += $value['price']; //第二栏
$tempCodeArrayNumberFail["$value[op]"]["$value[记费代码]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"]++; //第二栏
}
$MRlist2Fail = $m->query("SELECT DISTINCT `IMSI`,`产品号`,`渠道号`,`op`,`ICCID省`,`记费代码` FROM `$willLikeDb` WHERE `日期`='$checkDate' GROUP BY `IMSI`");
foreach($MRlist2Fail as $value)
{
$tempArrayPriceNumberTwoFail["$value[op]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"]++;
//$tempCodeArrayNumberTwoFail["$value[记费代码]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"]++; //第二栏
}
$MRlist3Fail = $m->query("SELECT DISTINCT `IMSI`,`产品号`,`渠道号`,`op`,`ICCID省`,`记费代码` FROM `$willLikeDb` WHERE `日期`='$checkDate' GROUP BY `IMSI`,`记费代码`");
foreach($MRlist3Fail as $value)
{
//$tempArrayPriceNumberTwoFail["$value[op]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"]++;
$tempCodeArrayNumberTwoFail["$value[op]"]["$value[记费代码]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"]++; //第二栏
}
/*
echo '
',"新增用户数";
var_dump($tempArrayUserNewAll);
echo '
',"$n";
echo '
',"启动次数";
var_dump($tempArrayStartAll);
echo '
',"启动用户数";
var_dump($tempArrayUserAll);
echo '
',"返回代码数";
var_dump($tempArrayReturnUser);
echo '
',"点击数";
var_dump($tempArrayPointUser);
echo '
',"返回代码的次数";
var_dump($tempCodeArrayPointUser);
echo '
',"返回代码的金额";
var_dump($tempCodeArrayPointUserPrice);
echo '
',"返回代码的用户数[从代码上分]";
var_dump($tempCodeArrayPointUserTwo);
echo '
',"点击用户数";
var_dump($tempArrayPointUserTwo);
echo '
',"返回代码数用户数[总数]";
var_dump($tempArrayReturnUserTwo);
echo '
',"MR次数";
var_dump($tempArrayPriceNumber);
echo '
',"计费MR";
var_dump($tempArrayPrice);
echo '
',"MR次数【代码上分】";
var_dump($tempCodeArrayNumber);
echo '
',"计费MR【代码上分】";
var_dump($tempCodeArrayPrice);
echo '
',"MR人数";
var_dump($tempArrayPriceNumberTwo);
echo '
',"MR人数【代码上分】";
var_dump($tempCodeArrayNumberTwo);
echo '
',"MR次数Fail";
var_dump($tempArrayPriceNumberFail);
echo '
',"计费MRFail";
var_dump($tempArrayPriceFail);
echo '
',"MR次数【代码上分】Fail";
var_dump($tempCodeArrayNumberFail);
echo '
',"计费MR【代码上分】Fail";
var_dump($tempCodeArrayPriceFail);
echo '
',"MR人数";
var_dump($tempArrayPriceNumberTwoFail);
echo '
',"MR人数【代码上分】";
var_dump($tempCodeArrayNumberTwoFail);
*/
$willLikeDb = $willLinkDbName."_checked_every_month";
$tempReslt = mysql_query("DELETE FROM `$willLikeDb` WHERE `Time`='$checkDate'");
foreach($tempArrayStartAll as $key => $value){
//echo '
',"===运行一次===";
foreach($value as $key1 => $value1){
foreach($value1 as $key2 => $value2){
foreach($value2 as $key3 => $value3){
//$willLikeDb = "1707_checked_every_month";
//$m=M($willLikeDb);
$date= array(
'Time' => "'$checkDate'",//时间戳,
'op' => "$key",//运营商
'Product' => "$key1",//产品号
'Channel' => "$key2",//渠道号
'Province' => $key3 == ""?"无":$key3,//省份 归属地
'StartCount' => $tempArrayStartAll["$key"]["$key1"]["$key2"]["$key3"]?$tempArrayStartAll["$key"]["$key1"]["$key2"]["$key3"]:0,//启动次数
'StartUser' => $tempArrayUserAll["$key"]["$key1"]["$key2"]["$key3"]?$tempArrayUserAll["$key"]["$key1"]["$key2"]["$key3"]:0,//启动用户数
'NewUser' => $tempArrayUserNewAll["$key"]["$key1"]["$key2"]["$key3"]?$tempArrayUserNewAll["$key"]["$key1"]["$key2"]["$key3"]:0,//新增用户数
'ReturnUser' => $tempArrayReturnUserTwo["$key"]["$key1"]["$key2"]["$key3"]?$tempArrayReturnUserTwo["$key"]["$key1"]["$key2"]["$key3"]:0,//返回用户数
'ReturnUserAll' => $tempArrayReturnUser["$key"]["$key1"]["$key2"]["$key3"]?$tempArrayReturnUser["$key"]["$key1"]["$key2"]["$key3"]:0,//返回代码总数
'PointUser' => $tempArrayPointUserTwo["$key"]["$key1"]["$key2"]["$key3"]?$tempArrayPointUserTwo["$key"]["$key1"]["$key2"]["$key3"]:0,//用户点击数
'PointUserAll' => $tempArrayPointUser["$key"]["$key1"]["$key2"]["$key3"]?$tempArrayPointUser["$key"]["$key1"]["$key2"]["$key3"]:0,//用户点击总数
'MR' => $tempArrayPrice["$key"]["$key1"]["$key2"]["$key3"]?$tempArrayPrice["$key"]["$key1"]["$key2"]["$key3"]:0, //MR
'MR_User' => $tempArrayPriceNumberTwo["$key"]["$key1"]["$key2"]["$key3"]?$tempArrayPriceNumberTwo["$key"]["$key1"]["$key2"]["$key3"]:0, //MR
'MR_User_All' => $tempArrayPriceNumber["$key"]["$key1"]["$key2"]["$key3"]?$tempArrayPriceNumber["$key"]["$key1"]["$key2"]["$key3"]:0 //MR
);
//var_dump($date);
/*
echo '
',"INSERT INTO `1707_checked_every_month`
(`Time`,`op`,`Product`,`Channel`,`Province`,`StartCount`,`StartUser`,
`NewUser`,`ReturnUser`,`ReturnUserAll`,`PointUser`,`PointUserAll`,`MR`,`MR_User`,`MR_User_All`)
VALUES
($date[Time],$date[op],$date[Product],$date[Channel],'$date[Province]',$date[StartCount],$date[StartUser],
$date[NewUser],$date[ReturnUser],$date[ReturnUserAll],$date[PointUser],$date[PointUserAll],$date[MR],$date[MR_User],$date[MR_User_All]);";
*/
//$m->query
$result = mysql_query("INSERT INTO `$willLikeDb`
(`Time`,`op`,`Product`,`Channel`,`Province`,`StartCount`,`StartUser`,
`NewUser`,`ReturnUser`,`ReturnUserAll`,`PointUser`,`PointUserAll`,`MR`,`MR_User`,`MR_User_All`)
VALUES
($date[Time],$date[op],$date[Product],$date[Channel],'$date[Province]',$date[StartCount],$date[StartUser],
$date[NewUser],$date[ReturnUser],$date[ReturnUserAll],$date[PointUser],$date[PointUserAll],$date[MR],$date[MR_User],$date[MR_User_All]);")
;
}
}
}
}
echo '
',$willLikeDb." is OK",'
';
// 以上为 ["$value[op]"]["$value[产品号]"]["$value[渠道号]"]["$value[iccid省]"] 相对应 新增 点击 收入 等等 这一列表
$willLikeDb = $willLinkDbName."_code_every_month";
$tempReslt = mysql_query("DELETE FROM `$willLikeDb` WHERE `Time`='$checkDate'");
//var_dump($tempCodeArrayPointUser);
//以下为第二张表
foreach($tempCodeArrayPointUser as $key10 => $value10){
foreach($value10 as $key => $value){
foreach($value as $key1 => $value1){
foreach($value1 as $key2 => $value2){
$tempList = $m->query("SELECT `屏蔽省`,`op` FROM `代码` WHERE `代码编号`='$key' limit 1");
$tempNumberA = $tempList[0]['op'];
$tempNewUser = 0;
$proListOpen = IndexController::getProvinceNumber($tempList[0]['屏蔽省'],$this->proListMove);
//var_dump ($tempList);
//echo "代码 $key 开 $tempNumberA 通".$proListOpen;
foreach($tempArrayUserNewAll["$key10"]["$key1"]["$key2"] as $key4 => $value4){
if(IndexController::isInString($proListOpen,$key4)){
//echo "判断成功 $key4 $value4";
$tempNewUser += $value4;
}
}
//echo "开通人数".$tempNewUser;
foreach($value2 as $key3 => $value3){
//$willLikeDb = "1707_checked_every_month";
//$m=M($willLikeDb);
$date= array(
'Time' => "'$checkDate'",//时间戳,
'op' => "$key10",//返回代码编号 或 记费代码
'ReturnCode' => "$key",//返回代码编号 或 记费代码
'Product' => "$key1",//产品号
'Channel' => "$key2",//渠道号
'Province' => $key3 == ""?"无":$key3,//省份 归属地
'newUser' => $tempNewUser?$tempNewUser:0,//当前代码的当日 复合新增用户数
'MoUserAll' => $tempCodeArrayPointUser["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayPointUser["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//MO次数 返回代码次数
'MoCount' => $tempCodeArrayPointUserPrice["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayPointUserPrice["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//请求MO 返回代码-请求MO
'MoUser' => $tempCodeArrayPointUserTwo["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayPointUserTwo["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//请求MO人数 返回代码-请求MO人数
'MrCount' => $tempCodeArrayPrice["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayPrice["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//单条代码的 MR
'MrUserAll' => $tempCodeArrayNumber["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayNumber["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//单条代码的 MR次数
'MrUser' => $tempCodeArrayNumberTwo["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayNumberTwo["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//单条MR用户数
'MrCountFail' => $tempCodeArrayPriceFail["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayPriceFail["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//单条代码的 MO失败
'MrUserAllFail' => $tempCodeArrayNumberFail["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayNumberFail["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//单条代码的 MO失败次数
'MrUserFail' => $tempCodeArrayNumberTwoFail["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayNumberTwoFail["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//单条 MO失败 用户数
);
//var_dump($date);
/*
echo '
',"INSERT INTO `1707_code_every_month`
(`Time`,`op`,`ReturnCode`,`Product`,`Channel`,`Province`,`newUser`,`MoUserAll`,`MoCount`,
`MoUser`,`MrCount`,`MrUserAll`,`MrUser`,`MrCountFail`,`MrUserAllFail`,`MrUserFail`)
VALUES
($date[Time],$date[op],$date[ReturnCode],$date[Product],$date[Channel],'$date[Province]','$date[newUser]',$date[MoUserAll],$date[MoCount],
$date[MoUser],$date[MrCount],$date[MrUserAll],$date[MrUser],$date[MrCountFail],$date[MrUserAllFail],$date[MrUserFail]);")
;*/
//$m->query
$result = mysql_query("INSERT INTO `$willLikeDb`
(`Time`,`op`,`ReturnCode`,`Product`,`Channel`,`Province`,`newUser`,`MoUserAll`,`MoCount`,
`MoUser`,`MrCount`,`MrUserAll`,`MrUser`,`MrCountFail`,`MrUserAllFail`,`MrUserFail`)
VALUES
($date[Time],$date[op],$date[ReturnCode],$date[Product],$date[Channel],'$date[Province]','$date[newUser]',$date[MoUserAll],$date[MoCount],
$date[MoUser],$date[MrCount],$date[MrUserAll],$date[MrUser],$date[MrCountFail],$date[MrUserAllFail],$date[MrUserFail]);")
;//or die("Error in query: $query. ".mysql_error()); echo "Error in query: $query. ".mysql_error()
$tempNewUser = 0;
}
}
}
}
}
//以上为第二张表自己代码
echo '
',$willLikeDb." is OK",'
';
$willLikeDb = $willLinkDbName."其他请求付费";
$UserNumberReturnCodeList = $m->query("SELECT `IMSI`,`归属地`,`产品号`,`渠道号`,`运营商`,`返回代码编号`,`price` FROM `$willLikeDb` WHERE `日期`='$checkDate' ORDER BY `IMSI`,`返回代码编号` DESC");
$j = 0;
foreach($UserNumberReturnCodeList as $value)
{
$j++;
$tempA = $value['返回代码编号'] + 900000;
$tempCodeArrayPointUserPrice["$value[运营商]"]["$tempA"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"] += $value['price']; //第二栏
if($value['返回代码编号'] != 0){
$tempCodeArrayPointUser["$value[运营商]"]["$tempA"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++; //第二栏
}
if($UserNumberReturnCodeList[$j - 1]['imsi'] != $UserNumberReturnCodeList[$j]['imsi']){
$tempCodeArrayPointUserTwo["$value[运营商]"]["$tempA"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++; //第二栏
}else{
if($UserNumberReturnCodeList[$j - 1]['返回代码编号'] != $UserNumberReturnCodeList[$j]['返回代码编号']){
$tempCodeArrayPointUserTwo["$value[运营商]"]["$tempA"]["$value[产品号]"]["$value[渠道号]"]["$value[归属地]"]++; //第二栏
}
}
}
$willLikeDb = $willLinkDbName."_code_every_month";
//以下为第二张表其它SDK
//var_dump($tempCodeArrayPrice);
foreach($tempCodeArrayPrice as $key10 => $value10){
foreach($value10 as $key => $value){
if($key < 900000){continue;}//如果是自己代码 那么跳出。
foreach($value as $key1 => $value1){
foreach($value1 as $key2 => $value2){
$tempList = $m->query("SELECT `屏蔽省`,`op` FROM `代码` WHERE `代码编号`='$key' limit 1");
$tempNumberA = $tempList[0]['op'];
$tempNewUser = 0;
$proListOpen = IndexController::getProvinceNumber($tempList[0]['屏蔽省'],$this->proListMove);
//var_dump ($tempList);
//echo "代码 $key 开 $tempNumberA 通".$proListOpen;
foreach($tempArrayUserNewAll["$key10"]["$key1"]["$key2"] as $key4 => $value4){
if(IndexController::isInString($proListOpen,$key4)){
//echo "判断成功 $key4 $value4";
$tempNewUser += $value4;
}
}
//echo "开通人数".$tempNewUser;
foreach($value2 as $key3 => $value3){
//$willLikeDb = "1707_checked_every_month";
//$m=M($willLikeDb);
$date= array(
'Time' => "'$checkDate'",//时间戳,
'op' => "$key10",//返回代码编号 或 记费代码
'ReturnCode' => "$key",//返回代码编号 或 记费代码
'Product' => "$key1",//产品号
'Channel' => "$key2",//渠道号
'Province' => $key3 == ""?"无":$key3,//省份 归属地
'newUser' => $tempNewUser?$tempNewUser:0,//当前代码的当日 复合新增用户数
'MoUserAll' => $tempCodeArrayPointUser["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayPointUser["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//MO次数 返回代码次数
'MoCount' => $tempCodeArrayPointUserPrice["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayPointUserPrice["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//请求MO 返回代码-请求MO
'MoUser' => $tempCodeArrayPointUserTwo["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayPointUserTwo["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//请求MO人数 返回代码-请求MO人数
'MrCount' => $tempCodeArrayPrice["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayPrice["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//单条代码的 MR
'MrUserAll' => $tempCodeArrayNumber["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayNumber["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//单条代码的 MR次数
'MrUser' => $tempCodeArrayNumberTwo["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayNumberTwo["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//单条MR用户数
'MrCountFail' => $tempCodeArrayPriceFail["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayPriceFail["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//单条代码的 MO失败
'MrUserAllFail' => $tempCodeArrayNumberFail["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayNumberFail["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//单条代码的 MO失败次数
'MrUserFail' => $tempCodeArrayNumberTwoFail["$key10"]["$key"]["$key1"]["$key2"]["$key3"]?$tempCodeArrayNumberTwoFail["$key10"]["$key"]["$key1"]["$key2"]["$key3"]:0,//单条 MO失败 用户数
);
$result = mysql_query("INSERT INTO `$willLikeDb`
(`Time`,`op`,`ReturnCode`,`Product`,`Channel`,`Province`,`newUser`,`MoUserAll`,`MoCount`,
`MoUser`,`MrCount`,`MrUserAll`,`MrUser`,`MrCountFail`,`MrUserAllFail`,`MrUserFail`)
VALUES
($date[Time],$date[op],$date[ReturnCode],$date[Product],$date[Channel],'$date[Province]','$date[newUser]',$date[MoUserAll],$date[MoCount],
$date[MoUser],$date[MrCount],$date[MrUserAll],$date[MrUser],$date[MrCountFail],$date[MrUserAllFail],$date[MrUserFail]);")
;//or die("Error in query: $query. ".mysql_error()); echo "Error in query: $query. ".mysql_error()
$tempNewUser = 0;
}
}
}
}
}
echo '
',$willLikeDb."2 is OK",'
';
//以上为第二张表其它SDK
//以上为第二张表
mysql_close($link);
echo "ok";
}
}
public function testmimi(){
$checkDate = "2017-07-18";
error_reporting(0);
$link = mysql_connect('localhost:3306','root','zz753951');
if (!$link) {
die(iconv("GB2312","UTF-8",'连接服务器失败:'."
"). mysql_error());
}
mysql_query("set names 'utf8'");
mysql_select_db("door", $link);
$tempReslt = mysql_query("DELETE FROM `recordCodeInfo` WHERE `Time`='$checkDate'");
$willLikeDb = "代码";
$m=M($willLikeDb);
$tempListPro = $m->query("SELECT `屏蔽省`,`代码编号` FROM `代码` GROUP BY `代码编号`");
for($i=0;$i < count($tempListPro);$i++){
$tempA = $tempListPro[$i]['屏蔽省'];
$tempB = $tempListPro[$i]['代码编号'];
$result = mysql_query("INSERT INTO `recordCodeInfo` (`ShieldProvince`, `codeNumber`, `Time`)
VALUES ('$tempA', '$tempB', '$checkDate')");
}
mysql_close($link);
echo "ok";
}
public function spIncomTable(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$UseNumberT = 5;//使用第几套显数据
$t=time();//为这次访问的时间数据
$tBeiJing=$t+21600;
IndexController::getFenchengAndName();//赋值 codeLook|UpTableTable
$nowOp = I('op');
$nowProductID = I('productID');
$nowChanel = I('chanel');
$nowCheckDateStar = I('checkDateStar');
$nowCheckDateEnd = I('checkDateEnd');
$chanel = "(`渠道号` = '$nowChanel')";//自已定义的渠道号1002
if($nowChanel == 0){$chanel = "1";}
$checkDateStar = strtotime($nowCheckDateStar." 0:00:00");
$checkDateEnd = strtotime($nowCheckDateEnd." 24:00:00");
$checkDateStarDateT = date("Y-m-d",$checkDateStar+10);
$checkDateEndDateT = date("Y-m-d",$checkDateEnd+10);
$willCheckPar = "op=".$nowOp."&productID=".$nowProductID."&chanel=".$nowChanel."&checkDateStar=".$checkDateStarDateT."&checkDateEnd=".$checkDateEndDateT;
$willLikeDb = "代码";
//这里查进行分数据
$where = "1";
$m=M($willLikeDb);
//$p=IndexController::getpageA($m,$where,25);
//$list=$m->field(true)->where($where)->order('IMEI desc')->select();
$codeList = $m->query("SELECT distinct `代码编号`,`op`,`屏蔽省` FROM `$willLikeDb` WHERE `op` = '$nowOp' GROUP BY `代码编号` ORDER BY `$willLikeDb`.`代码编号` ASC");
$query = iconv("GB2312","UTF-8","SELECT * FROM `$willLikeDb` WHERE `日期` = '$checkDate' AND $chanel AND $ProductID AND $willcheckCode ORDER BY `时间戳` DESC ");
//var_dump($codeList);
//这里开始查代码。
/*
echo '
';
echo $willCheckPar;
echo '
';
echo '
';
echo '
';
echo $checkDateStar;
echo '
';
echo $checkDateEnd;
echo '
';
*/
$willLinkDbName = date("ym",$checkDateStar+10);
$op = "(`运营商` = '$nowOp')";
if($nowOp == 0){$op = "1";}
$ProductID = "(`产品号` = '$nowProductID')";
if($nowProductID == 500000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 600000 )";}
if($nowProductID == 400000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 500000 )";}
if($nowProductID == 200000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 300000 )";}
if($nowProductID == 300000){$ProductID = "((`产品号` > $nowProductID) AND `产品号` < 400000 OR (`产品号` = 0))";}
if($nowProductID == 100000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 200000)";}
if($nowProductID == 0){$ProductID = "1";}
$chcekDay = ($checkDateEnd - $checkDateStar)/ 86400;
$willLikeDb = $willLinkDbName."激活数据";
$UserNumberList = $m->query("SELECT distinct `IMSI`,`日期`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < '$checkDateEnd' AND $chanel AND $ProductID AND $op GROUP BY `IMSI` ORDER BY `时间戳` ASC ");
for($i= 0 ; $i <= $chcekDay;$i++){
if($i == 1 && $chcekDay == 1){break;}
$nowCheckTimeStampStart = $checkDateStar + 86400 * $i;
$nowCheckTimeStampEnd = $checkDateStar + 86400 * ($i + 1);
$nowCheckDateSString = "";
if($chcekDay == $i){
$nowCheckTimeStampStart = $checkDateStar;
$nowCheckTimeStampEnd = $checkDateEnd;
}
$nowCheckDate = date("Y-m-d",$nowCheckTimeStampStart + 60);
$nowCheckDateTheEnd = date("Y-m-d",$nowCheckTimeStampEnd + 60);
$willLikeDb = $willLinkDbName."请求付费次数";
$UserNumberClickList = $m->query("SELECT distinct `IMSI`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < $nowCheckTimeStampEnd AND `时间戳` > $nowCheckTimeStampStart AND $chanel AND $ProductID AND $op ORDER BY `时间戳` DESC ");
$code = "(`返回代码编号` != '0') AND (`返回代码编号` != '100030')";
$UserNumberReturnCodeList = $m->query("SELECT distinct `IMSI`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < $nowCheckTimeStampEnd AND `时间戳` > $nowCheckTimeStampStart AND $chanel AND $ProductID AND $op AND $code ORDER BY `时间戳` DESC ");
$NumberReturnCodeList = $m->query("SELECT * FROM `$willLikeDb` WHERE `时间戳` < $nowCheckTimeStampEnd AND `时间戳` > $nowCheckTimeStampStart AND $chanel AND $ProductID AND $op AND $code ORDER BY `时间戳` DESC ");
$willLikeDb = $willLinkDbName."激活数据";
$UserStartNumber = $m->query("SELECT `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $nowCheckTimeStampEnd AND `时间戳` > $nowCheckTimeStampStart AND $chanel AND $ProductID AND $op ORDER BY `时间戳` DESC ");
$UserStartUserNumber = $m->query("SELECT distinct `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $nowCheckTimeStampEnd AND `时间戳` > $nowCheckTimeStampStart AND $chanel AND $ProductID AND $op GROUP BY `IMSI` ORDER BY `时间戳` ASC ");
$UserAppUserNumber = 0;
foreach($UserNumberList as $value){
if ($chcekDay == $i){
if($nowCheckDate <= $value["日期"]){
$UserAppUserNumber++;
}
}else{
if($nowCheckDate == $value["日期"]){
$UserAppUserNumber++;
}
}
}
$willLikeDb = $willLinkDbName."请求付费次数";
$UserQustNumber = $m->query("SELECT `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $nowCheckTimeStampEnd AND `时间戳` > $nowCheckTimeStampStart AND $chanel AND $ProductID AND $op ORDER BY `时间戳` DESC ");
$op2 = "(`op` = '$nowOp')";
$willLikeDb = $willLinkDbName."数据";
$succMr = $m->query("SELECT sum(`price`) FROM `$willLikeDb` WHERE `时间戳` < $nowCheckTimeStampEnd AND `时间戳` > $nowCheckTimeStampStart AND $chanel AND $ProductID AND $op2 ORDER BY `时间戳` DESC ");
//$succMrNumber = $m->query("SELECT `IMSI` FROM `$willLikeDb` WHERE `日期` = '$nowCheckDate' AND $chanel AND $ProductID AND $op2 ORDER BY `时间戳` DESC ");
//$succMrUserNumber = $m->query("SELECT distinct `IMSI` FROM `$willLikeDb` WHERE `日期` = '$nowCheckDate' AND $chanel AND $ProductID AND $op2 GROUP BY `IMSI` ORDER BY `时间戳` DESC ");
$list1[$i][0] = $nowCheckDate;if($chcekDay > 1 && $chcekDay == $i){$list1[$i][0]="总计";}
$list1[$i][1] = $nowProductID;
$list1[$i][2] = $nowChanel;
$list1[$i][3] = count($UserStartNumber);
$list1[$i][4] = count($UserStartUserNumber);
$list1[$i][5] = $UserAppUserNumber;
$list1[$i][6] = count($UserNumberReturnCodeList);
$list1[$i][7] = count($UserNumberClickList);
$list1[$i][8] = intval((count($UserQustNumber)/count($UserNumberClickList)*100))/100;
$list1[$i][9] = (intval(count($NumberReturnCodeList)/count($UserQustNumber)*10000)/100)."%";
$list1[$i][10] = intval($succMr[0]['sum(`price`)']/$UserAppUserNumber)/100;
$list1[$i][11] = $succMr[0]['sum(`price`)']/100;
if($chcekDay > 1){
if($chcekDay == $i){
$willCheckGochannel = "op=".$nowOp."&productID=".$nowProductID."&chanel=".$nowChanel."&checkDateStar=".$nowCheckDate."&checkDateEnd=".$nowCheckDateTheEnd;
}else{
$willCheckGochannel = "op=".$nowOp."&productID=".$nowProductID."&chanel=".$nowChanel."&checkDateStar=".$nowCheckDate."&checkDateEnd=".$nowCheckDate;
}
$list1[$i][11] = IndexController::setUrl($list1[$i][11],$this->myIP."app/index.php/Home/Index/spIncomTableGoChanel"."?".$willCheckGochannel);
}else{
$willCheckGochannel = "op=".$nowOp."&productID=".$nowProductID."&chanel=".$nowChanel."&checkDateStar=".$nowCheckDate."&checkDateEnd=".$nowCheckDate;
}
$list1[$i][20] = $willCheckGochannel."&codeNumber="."0";
}
/*
if(count($list1) > 1){
foreach($list1 as $value4433){
for ($icd = 0;$icd < 12;$icd++){
$tempArry[$icd] += $value4433[$icd];
}
}
$list1[$chcekDay][0] = "总计";
$list1[$chcekDay][1] = $nowProductID;
$list1[$chcekDay][2] = $nowChanel;
for ($icd = 3;$icd < 12;$icd++){
$list1[$chcekDay][$icd] = $tempArry[$icd];
}
$list1[$chcekDay][20] = $willCheckPar."&codeNumber="."0";
}*/
//echo $codeList[0]["屏蔽省"],'
';
//var_dump($UserNumberList);
//
$specilCodeIcon = 0;
$specilCodeIncome = 0;
$rowsNumber = 0;
foreach($codeList as $nowCodeInfo){
$codeNumber = $nowCodeInfo["代码编号"];
$code = "(`返回代码编号` = '$codeNumber')";
$codeTable2 = "(`记费代码` = '$codeNumber')";
$proListOpen = IndexController::getProvinceNumber($codeList[$rowsNumber]["屏蔽省"],$this->proListMove);
$UserNumber = 0;
foreach ($UserNumberList as $value){
if ( IndexController::isInString($proListOpen,$value["归属地"]) && ($checkDateStarDateT <= $value["日期"] && $checkDateEndDateT >= $value["日期"])){
//$nowCheckDate == $value["日期"]
$UserNumber++;
}
}
$willLikeDb = $willLinkDbName."请求付费次数";
$qustMo = $m->query("SELECT sum(`返回价格`) FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $code ORDER BY `时间戳` DESC ");
$qustMoNumber = $m->query("SELECT `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $code ORDER BY `时间戳` DESC ");
$qustMoUserNumber = $m->query("SELECT distinct `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $code GROUP BY `IMSI` ORDER BY `时间戳` DESC ");
$willLikeDb = $willLinkDbName."数据";
$succMr = $m->query("SELECT sum(`price`) FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 ORDER BY `时间戳` DESC ");
$succMrNumber = $m->query("SELECT `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 ORDER BY `时间戳` DESC ");
$succMrUserNumber = $m->query("SELECT distinct `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 GROUP BY `IMSI` ORDER BY `时间戳` DESC ");
$willLikeDb = $willLinkDbName."失败计费数据";
$failMr = $m->query("SELECT sum(`price`) FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 ORDER BY `时间戳` DESC ");
$failMrNumber = $m->query("SELECT `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 ORDER BY `时间戳` DESC ");
$failMrUserNumber = $m->query("SELECT distinct `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 GROUP BY `IMSI` ORDER BY `时间戳` DESC ");
/*
echo '
';echo '
';echo '
';
echo $this->codeLookUpTable["$codeNumber"],'
';$list[$rowsNumber][0]=$this->codeLookUpTable["$codeNumber"];
echo $codeNumber,'
';$list[$rowsNumber][1]=$codeNumber;
echo $UserNumber,'
';$list[$rowsNumber][2]=$UserNumber;//符合省份的用户数
echo '
';
echo count($qustMoNumber),'
';$list[$rowsNumber][3]=count($qustMoNumber);//发起多少次付费请求
echo count($qustMoUserNumber),'
';$list[$rowsNumber][4]=count($qustMoUserNumber);//发起付费请求的用户数
echo $qustMo[0]['sum(`price`)'],'
';$list[$rowsNumber][5]=$qustMo[0]['sum(`price`)'];
echo '
';
echo count($succMrNumber)+count($failMrNumber),'
';$list[$rowsNumber][6]=count($succMrNumber)+count($failMrNumber);
echo count($succMrUserNumber)+count($failMrUserNumber),'
';$list[$rowsNumber][7]=count($succMrUserNumber)+count($failMrUserNumber);
echo $succMr[0]['sum(`price`)']+$failMr[0]['sum(`price`)'],'
';$list[$rowsNumber][8]=$succMr[0]['sum(`price`)']+$failMr[0]['sum(`price`)'];
echo '
';
echo count($succMrNumber),'
';$list[$rowsNumber][9]=count($succMrNumber);
echo count($succMrUserNumber),'
';$list[$rowsNumber][10]=count($succMrUserNumber);
echo $succMr[0]['sum(`price`)'],'
';$list[$rowsNumber][11]=$succMr[0]['sum(`price`)'];
echo '
';
echo $succMr[0]['sum(`price`)'] / count($succMrUserNumber),'
';$list[$rowsNumber][12]=$succMr[0]['sum(`price`)'] / count($succMrUserNumber);
echo count($succMrUserNumber) / count($qustMoUserNumber),'
';$list[$rowsNumber][13]=count($succMrUserNumber) / count($qustMoUserNumber);
echo $succMr[0]['sum(`price`)'] / $qustMo[0]['sum(`price`)'],'
';$list[$rowsNumber][14]=$succMr[0]['sum(`price`)'] / $qustMo[0]['sum(`price`)'];
echo '
';
echo count($succMrNumber)/(count($succMrNumber)+count($failMrNumber)),'
';$list[$rowsNumber][15]=count($succMrNumber)/(count($succMrNumber)+count($failMrNumber));
echo count($succMrUserNumber)/$UserNumber,'
';$list[$rowsNumber][16]=count($succMrUserNumber)/$UserNumber;
echo count($succMr[0]['sum(`price`)'])/$UserNumber,'
';$list[$rowsNumber][17]=count($succMr[0]['sum(`price`)'])/$UserNumber;
echo '
';echo '
';echo '
';
*/
$list[$rowsNumber][0]=$this->codeLookUpTable["$codeNumber"];
$list[$rowsNumber][1]=$codeNumber;
$list[$rowsNumber][2]=$UserNumber;
$list[$rowsNumber][3]=count($qustMoNumber);
$list[$rowsNumber][4]=count($qustMoUserNumber);
$list[$rowsNumber][5]=$qustMo[0]['sum(`返回价格`)']/100;
$list[$rowsNumber][6]=count($succMrNumber)+count($failMrNumber);
$list[$rowsNumber][7]=count($succMrUserNumber)+count($failMrUserNumber);
$list[$rowsNumber][8]=($succMr[0]['sum(`price`)']+$failMr[0]['sum(`price`)'])/100;
$list[$rowsNumber][9]=count($succMrNumber);
$list[$rowsNumber][10]=count($succMrUserNumber);
$list[$rowsNumber][11]=$succMr[0]['sum(`price`)']/100;
if($codeNumber == "100008" || $codeNumber == "100037" || $codeNumber == "100072"){ //无透传的代码特殊处理
$willLikeDb = $willLinkDbName."请求付费次数";
$qustMoUserNumberTotal = $m->query("SELECT distinct `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $code GROUP BY `IMSI` ORDER BY `时间戳` DESC ");
$willLikeDb = $willLinkDbName."数据";
$succMrTotal = $m->query("SELECT sum(`price`) FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $codeTable2 ORDER BY `时间戳` DESC ");
$list[$rowsNumber][11] = intval(($succMrTotal[0]['sum(`price`)'] * (count($qustMoUserNumber)/count($qustMoUserNumberTotal)))/100);
$specilCodeIcon += $list[$rowsNumber][11];
}
$list[$rowsNumber][12]=$list[$rowsNumber][11] * $this->codeLookUpTableInfo["$codeNumber"];
if($codeNumber == "100008" || $codeNumber == "100037" || $codeNumber == "100072"){ //无透传的代码特殊处理
$specilCodeIncome += $list[$rowsNumber][12];
}
if($chcekDay <= 1){
$tempNumber = 0;
}else{$tempNumber = $chcekDay;}
$list1[$tempNumber][12] += $list[$rowsNumber][12];
$list[$rowsNumber][13]=intval(($succMr[0]['sum(`price`)'] / count($succMrUserNumber)))/100;
$list[$rowsNumber][14]=(intval((count($succMrUserNumber) / count($qustMoUserNumber))*10000)/100)."%";
$list[$rowsNumber][15]=(intval(($succMr[0]['sum(`price`)'] / $qustMo[0]['sum(`返回价格`)'])*10000)/100)."%";
$list[$rowsNumber][16]=(intval((count($succMrNumber)/(count($succMrNumber)+count($failMrNumber)))*10000)/100)."%";
$list[$rowsNumber][17]=(intval((count($succMrUserNumber)/$UserNumber*10000))/100)."%";
$list[$rowsNumber][18]=(intval((($succMr[0]['sum(`price`)']/$UserNumber)))/100);
$list[$rowsNumber][19] = $willCheckPar."&codeNumber=".$codeNumber;
//这里设置字体颜色
if($list[$rowsNumber][14] < 15){
$list[$rowsNumber][14] = IndexController::setColor($list[$rowsNumber][14],"#FF0000");;
}
if($list[$rowsNumber][15] < 15){
$list[$rowsNumber][15] = IndexController::setColor($list[$rowsNumber][15],"#FF0000");;
}
if($list[$rowsNumber][16] < 30){
$list[$rowsNumber][16] = IndexController::setColor($list[$rowsNumber][16],"#FF0000");;
}
$rowsNumber++;
}//foreach结束
//echo "走到了这里$chcekDay";
if($chcekDay <= 1){ //无透传的代码特殊处理 //原本 MR上不会加上这些SB代码,收款会加上这些SB代码。 那么单天加MR,多天去掉收款
$list1[0][11] = $list1[0][11] + $specilCodeIcon;
$list1[0][10] = intval($list1[0][11]/$list1[0][5]*100)/100;
$list1[0][11] = IndexController::setUrl($list1[0][11],$this->myIP."app/index.php/Home/Index/spIncomTableGoChanel"."?".$willCheckGochannel);
}else{
$list1[$chcekDay][12] = $list1[$chcekDay][12] - $specilCodeIncome;
}
//这里查进行分数据
$willLikeDb = $willLinkDbName."请求付费次数";
//$m=$list;
$where = "1";
//$p=IndexController::getpageA($m,$where,25);
//$list=$m->field(true)->where($where)->order('IMEI desc')->select();
//$list=$m->field(true)->order('代码编号 desc')->select();
$i = 0;
$theCheckData[0] = $nowProductID;
$theCheckData[1] = $nowChanel;
$theCheckData[2] = $nowCheckDateStar;
$theCheckData[3] = $nowCheckDateEnd;
$this->assign('theCheckData',$theCheckData);
MiLi1123:
$this->list=$list;
//$this->page=$p->show();
//上面查进行分数据
$this->assign('list1',$list1);
$this->assign('willShowDbName1',"总收入");
$willShowDbName = "SP收入列表";//表头名
$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/spIncomTable");//查询对应的HTTP界面
$this->assign('willShowDbName',$willShowDbName);
$this->assign('TableHeader1',$this->TableHeader[6]);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->assign('TableHeader',$this->TableHeader[$UseNumberT]);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
$this->display();
}
public function chaneldata(){
$willTableName = array (
"日期",
"产品名",
"启动次数",
"启动用户数",
"新增用户数",
"ARPU",
"MR(单位元)"
);
$this->inputPassword2(1);//是否已经登陆 ,是的话,开始输数据。
IndexController::loadHaQingYouxi(); //载入哈勍 游戏名与对应编号
$UseNumberT = 5;//使用第几套显数据
$Model = new \Think\Model();
date_default_timezone_set("PRC");
$t=time();//为这次访问的时间数据
$tBeiJing=$t+0;
$nowProductID = I('productID',1000);
$nowCheckDateStar = I('checkDateStar');
$nowCheckDateEnd = I('checkDateEnd');
$nowChanel = session('chanel');
//echo '
';echo '
';
//echo $nowChanel;
//echo '
';echo '
';
$chanel = "(`channelID` = '$nowChanel')";
$checkDateStar = strtotime($nowCheckDateStar." 0:00:00");
$checkDateEnd = strtotime($nowCheckDateEnd." 24:00:00");
$ProductID = "(`productID` = '$nowProductID')";
if($nowProductID == 0){$ProductID = "1";}
$chcekDay = ($checkDateEnd - $checkDateStar)/ 86400;
$allGameNumber = count($this->haqingyouxiproduct);
//echo $allGameNumber;
for($i= 0 ; $i < $chcekDay;$i++){
if ($nowProductID == 900000){
$j=0;
foreach($this->haqingyouxiproduct as $value232){
$tempProductID = $value232[0];
$ProductID = "(`productID` = '$tempProductID')";
$nowCheckTimeStampStart = $checkDateStar + 86400 * $i;
$nowCheckTimeStampDay = $checkDateStar + 86400 * $i;
$nowCheckDate = date("Y-m-d",$nowCheckTimeStampStart + 60);
$getData = $Model->query("SELECT * FROM `haQingInputData` WHERE `date` = '$nowCheckDate' AND $chanel AND $ProductID ORDER BY `timeStamp` ASC LIMIT 1");
if($nowChanel == 2014){
$getData = $Model->query("SELECT * FROM `haQingInputData` WHERE `date` = '$nowCheckDate' AND $chanel AND $ProductID ORDER BY `timeStamp` DESC LIMIT 1");
}
//echo "SELECT * FROM `haQingInputData` WHERE `date` = '$nowCheckDate' AND $chanel AND $ProductID ORDER BY `timeStamp` ASC LIMIT 1";
$list1[$i*$allGameNumber+$j][0] = $nowCheckDate;
foreach($this->haqingyouxiproduct as $value){
if ($value[0] == $tempProductID){
$list1[$i*$allGameNumber+$j][1] = $value[1];//$this->haqingyouxiproduct[$tempProductID][1];
}
}
$list1[$i*$allGameNumber+$j][2] = $getData[0]['startnumber'];//count($UserStartNumber);
$list1[$i*$allGameNumber+$j][3] = $getData[0]['startusernumber'];//count($UserStartUserNumber);
$list1[$i*$allGameNumber+$j][4] = $getData[0]['userapp'];//$UserAppUserNumber;
$list1[$i*$allGameNumber+$j][5] = intval($getData[0]['totalprice'] / $list1[$i*$allGameNumber+$j][4] / 10 )/10;
$list1[$i*$allGameNumber+$j][6] = $getData[0]['totalprice'] / 100;
$j++;
}
}else{
$nowCheckTimeStampStart = $checkDateStar + 86400 * $i;
$nowCheckTimeStampDay = $checkDateStar + 86400 * $i;
$nowCheckDate = date("Y-m-d",$nowCheckTimeStampStart + 60);
$getData = $Model->query("SELECT * FROM `haQingInputData` WHERE `date` = '$nowCheckDate' AND $chanel AND $ProductID ORDER BY `timeStamp` ASC LIMIT 1");
if($nowChanel == 2014){
$getData = $Model->query("SELECT * FROM `haQingInputData` WHERE `date` = '$nowCheckDate' AND $chanel AND $ProductID ORDER BY `timeStamp` DESC LIMIT 1");
}
$list1[$i][0] = $nowCheckDate;
if($nowProductID == 0){
}else{
foreach($this->haqingyouxiproduct as $value){
if ($value[0] == $nowProductID){
$list1[$i][1] = $value[1];
}
}
}
$list1[$i][2] = $getData[0]['startnumber'];//count($UserStartNumber);
$list1[$i][3] = $getData[0]['startusernumber'];//count($UserStartUserNumber);
$list1[$i][4] = $getData[0]['userapp'];//$UserAppUserNumber;
$list1[$i][5] = intval($getData[0]['totalprice'] / $list1[$i][4] / 10 )/10;
$list1[$i][6] = $getData[0]['totalprice'] / 100;
}
}
$this->assign('checkDateStar',$nowCheckDateStar);
$this->assign('checkDateEnd',$nowCheckDateEnd);
$this->assign('ChooseTableProduct',$this->haqingyouxiproduct);
$this->assign('list1',$list1);
$this->assign('willShowDbName1',"总收入");
$willShowDbName = "SP收入列表";//表头名
$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/chaneldata");//查询对应的HTTP界面
$this->assign('willShowDbName',$willShowDbName);
$this->assign('TableHeader1', $willTableName); //$this->TableHeader[6]);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->assign('TableHeader',$this->TableHeader[$UseNumberT]);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
$this->display();
}
public function WuChannelData(){
$this->inputPasswordWu($this->myIP."app/index.php/Home/Index/WuChannelData");//是否已经登陆 ,是的话,开始输数据。
$willTableName = array (
"日期",
"游戏名",
"渠道名",
"单价(元)",
"新增用户数",
"金额"
);
$UseNumberT = 5;//使用第几套显数据
$Model = new \Think\Model();
date_default_timezone_set("PRC");
$t=time();//为这次访问的时间数据
$tBeiJing=$t+0;
$nowProductID = I('productID',900000);
$nowCheckDateStar = I('checkDateStar');
$nowCheckDateEnd = I('checkDateEnd');
$nowChanel = session('channel');
if($nowChanel >= 9000){
$willTableName = array (
"日期",
"游戏名",
"渠道名",
"当日TP收益(元)"
);
}
//echo '
';echo '
';
//echo $nowChanel; WuChannelData
//echo '
';echo '
';
$chanel = "(`channelID` = '$nowChanel')";
$checkDateStar = strtotime($nowCheckDateStar." 0:00:00");
$checkDateEnd = strtotime($nowCheckDateEnd." 24:00:00");
$ProductID = "(`game_name` = '$nowProductID')";
if($nowProductID == 900000){$ProductID = "1";}
$chcekDay = ($checkDateEnd - $checkDateStar)/ 86400;
$query = "SELECT `name` FROM `the_wu_id` WHERE `Channel` = '$nowChanel'";
$getDataMiId = $Model->query($query);
$query = "SELECT DISTINCT `game_name` FROM `the_wu_data` WHERE `Channel` = '$nowChanel'";
if($nowChanel >= 9000)$query = "SELECT DISTINCT `game_name` FROM `the_zou_data` WHERE `Channel` = '$nowChanel'";
$getDataMi = $Model->query($query);
for($i=0;$i < count($getDataMi);$i++){
$WuYouXiProduct[$i] = array($getDataMi[$i]['game_name'],$getDataMi[$i]['game_name']);
}
$allGameNumber = count($WuYouXiProduct);
//echo $allGameNumber."chcekDay".$chcekDay;
//var_dump($WuYouXiProduct);
for($i = $chcekDay - 1; $i >= 0;$i--){
$nowCheckTimeStampStart = $checkDateStar + 86400 * $i;
$nowCheckDate = date("Y-m-d",$nowCheckTimeStampStart + 60);
$query = "SELECT * FROM `the_wu_data` WHERE `channel` = '$nowChanel' AND `date` = '$nowCheckDate' AND $ProductID ORDER BY `date` DESC";
if($nowChanel >= 9000)$query = "SELECT * FROM `the_zou_data` WHERE `channel` = '$nowChanel' AND `date` = '$nowCheckDate' AND $ProductID ORDER BY `date` DESC";
$getData = $Model->query($query);
//echo "this is . $i";
//echo '
',"$query";
//var_dump($getData);
//$list1[$i*$allGameNumber+$j][0] = $nowCheckDate;
$j=0;
foreach($getData as $keyMiLi => $valueMiLi){
$valueMiLi['channel'] = $getDataMiId[0]['name'];
$u = 0;
foreach($valueMiLi as $keyMi => $valueMi){
if($nowChanel >= 9000 && $u > 3)continue;
if($u > 5){continue;}
$list1[$i*$allGameNumber+$j][$u] = $valueMi;
if($u == 4){
$list1[$i*$allGameNumber+$j][$u] = intval($valueMiLi["new_app"] * $valueMiLi["bili"] / $valueMiLi["zuanhua"]);
if($list1[$i*$allGameNumber+$j][0] > "2017-09-19" && $list1[$i*$allGameNumber+$j][$u] != 0){
$list1[$i*$allGameNumber+$j][$u]++;
}
}
if($u == 5){
$list1[$i*$allGameNumber+$j][$u] = $list1[$i*$allGameNumber+$j][4] * $valueMiLi["per"];
}
$u++;
}
$tempPrice += $list1[$i*$allGameNumber+$j][5];
if($nowChanel >= 9000){
$tempPrice += $list1[$i*$allGameNumber+$j][3];
}
$j++;
}
}
if($nowChanel >= 9000){
array_push($list1,array("总计"," "," ",$tempPrice));
}else{
array_push($list1,array("总计"," "," "," "," ",$tempPrice));
}
//var_dump($list1);
$this->assign('checkDateStar',$nowCheckDateStar);
$this->assign('checkDateEnd',$nowCheckDateEnd);
$this->assign('ChooseTableProduct',$WuYouXiProduct);
$this->assign('list1',$list1);
$this->assign('willShowDbName1',"放量列表");
$willShowDbName = "收入列表";
$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/WuChannelData");//查询对应的HTTP界面
$this->assign('willShowDbName',$willShowDbName);
$this->assign('TableHeader1', $willTableName);
$this->display();
}
public function verifyPasswordWu(){
// 2014-搜狐 2015-搜狗游戏大厅
$myID = I('post.myID');
$myPassword = I('post.myPassword');
if(session('verification') == md5($_POST['checkCode'])){
$Model = new \Think\Model();
$query = "SELECT * FROM `the_wu_id` WHERE `id` = '$myID' ";
$getData = $Model->query($query);
if($getData[0]['key'] == $myPassword){
session('channel',$getData[0]['channel']);
session('nameWu',3);
}else{
session('nameWu',2);
}
header("Location:".$this->myIP."app/index.php/Home/Index/WuChannelData");
}else{
die("Error CheckCode");
}
/*
if (isset($_POST['myID']) && isset($_POST['myPassword']) && isset($_POST['checkCode'])){
if($_POST['myID'] == "mofeng" && $_POST['myPassword'] == "mofeng753" && session('verification') == md5($_POST['checkCode']) ){
session('name',5);
}else if($_POST['myID'] == "mili" && $_POST['myPassword'] == "mili123" && session('verification') == md5($_POST['checkCode']) ){
session('name',6);
}else if($_POST['myID'] == "tiantain" && $_POST['myPassword'] == "tiantain666" && session('verification') == md5($_POST['checkCode']) ){
session('name',3);
}else if($_POST['myID'] == "shouhu" && $_POST['myPassword'] == "shouhu652" && session('verification') == md5($_POST['checkCode']) ){
session('name',3);
session('chanel',2014);
}else if($_POST['myID'] == "shougou" && $_POST['myPassword'] == "shougou1122" && session('verification') == md5($_POST['checkCode']) ){
session('name',3);
session('chanel',2015);
}else if($_POST['myID'] == "shougouG2" && $_POST['myPassword'] == "shougou2017" && session('verification') == md5($_POST['checkCode']) ){
session('name',3);
session('chanel',2016);
}
else{
session('name',2);echo "error!not have ID or Password or CheckCode";
}
}else{
session('name',2);echo "error!not have ID or Password or CheckCode";
}*/
}
public function inputPasswordWu($passwordWillGo){//传入URL
if( session('nameWu') < 1){
echo "";
//$this->display("inputPasswordWu");
die("用户登陆");
}
if( session('nameWu') == 2){
echo "Error ID or Password
";
//$this->display();
die("用户登陆");
}
}
public function chaneldataReturn($nowProductID){
}
public function chanelDataInput($checkDate=""){
$this->inputPassword();
IndexController::loadHaQingYouxi(); //载入哈勍 游戏名与对应编号
$this->assign('checkDate',$checkDate);
$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/chanelDataInputsucc");//查询对应的HTTP界面
$this->assign('ChooseTableChannle',$this->haqingchanel);
$this->assign('ChooseTableProduct',$this->haqingyouxiproduct);
$this->display();
}
public function chanelDataInputsucc(){
$this->inputPassword();
date_default_timezone_set("PRC");
$nowCheckDateStar = I('checkDateStar');
$nowCheckTimeStampStart = strtotime($nowCheckDateStar." 0:00:00");
$nowCheckDate = date("Y-m-d",$nowCheckTimeStampStart + 60);
$nowMr = I('myMr',0);
$nowMyUserApp = I('myUserApp',0);
if($nowMr < 0){$nowMr = 0;}
$nowChannel = I('channelID',0);
$nowProductID = I('productID',0);
$timeStamp = time();
//$m=M('1701数据');
$Model = new \Think\Model();
$query = ("INSERT INTO `haQingData` (`productID`, `channelID`, `date`, `price`, `timeStamp`, `userApp`) VALUES ('$nowProductID', '$nowChannel', '$nowCheckDate', '$nowMr', '$timeStamp', '$nowMyUserApp')");
$Result = $Model->execute($query);
if($Result){
$url = $this->myIP."app/index.php/Home/Index/chanelDataInput?checkDate=$nowCheckDate";
echo "输入数据:产品号:'$nowProductID', 渠道号:'$nowChannel', 时间:'$nowCheckDate', 资费:'$nowMr')",'';
echo "输入成功",'';
echo "2秒后跳转",'';
echo "";
}else{
echo "输入失败",'';
}
}
public function chanelDataCaculation(){
$this->inputPassword();
$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/chanelDataCaculationSucc");//查询对应的HTTP界面
$this->assign('ChooseTable',$this->haqingchanel);
$this->display();
}
public function chanelDataCaculationSucc(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
IndexController::loadHaQingYouxi(); //载入哈勍 游戏名与对应编号
date_default_timezone_set("PRC");
$t=time();//为这次访问的时间数据
$Model = new \Think\Model();
$m=M('1701数据');
//$nowOp = I('op');
//$nowProductID = I('productID',1000);
$nowChanel = I('channelID');
$nowCheckDateStar = I('checkDateStar',$t);
//$nowCheckDateEnd = I('checkDateEnd');
$bilibili = I('bilibili');//扣量比例
$chanel = "(`渠道号` = '$nowChanel')";//自已定义的渠道号1002
if($nowChanel == 2015){$chanel = "(`渠道号` = '2015' OR `渠道号` = '2016' OR `渠道号` = '2017' OR `渠道号` = '2018')";}
if($nowChanel == 0){$chanel = "1";}
$checkDateStar = strtotime($nowCheckDateStar." 0:00:00");
$checkDateEnd = strtotime($nowCheckDateStar." 24:00:00");
$willLinkDbName = date("ym",$checkDateStar+10);
echo "$nowChanel"."将计算渠道:$chanel"."计算比例:$bilibili",'';
echo "计算时间:$nowCheckDateStar",'';
foreach($this->haqingyouxiproduct as $vale21){
$nowCheckTimeStampStart = $checkDateStar;
$nowCheckTimeStampEnd = $checkDateStar + 86400 * 1;
$nowCheckDate = date("Y-m-d",$nowCheckTimeStampStart + 60);
echo '';
$ProductID = "(`产品号` = '$vale21[0]')";
echo "$ProductID",'';
$willLikeDb = $willLinkDbName."数据";
$query = "SELECT sum(`price`) FROM `$willLikeDb` WHERE `日期` = '$nowCheckDate' AND $chanel AND $ProductID ORDER BY `时间戳` DESC ";
//"SELECT sum(`price`) FROM `$willLikeDb` WHERE 1 AND 1 AND 1 ORDER BY `时间戳` DESC "
$succMr = $Model->query($query);
//var_dump($succMr);
//$failMr[0]['sum(`price`)']
//echo $succMr[0]['sum(`price`)'],'';
//这里查找输入的数据 `productID`, `channelID`, `date`, `price`, `timeStamp`
$inputData = $Model->query("SELECT * FROM `haQingData` WHERE `date` = '$nowCheckDate' AND `channelID` = '$nowChanel' AND `productID`= '$vale21[0]' ORDER BY `timeStamp` DESC LIMIT 1");
//var_dump($inputData);
//echo $inputData[0]['price'],'';
//查其它数据
$willLikeDb = $willLinkDbName."激活数据";
$UserNumberList = $m->query("SELECT distinct `IMSI`,`日期`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < '$checkDateEnd' AND $chanel AND $ProductID GROUP BY `IMSI` ORDER BY `时间戳` ASC ");
$willLikeDb = $willLinkDbName."激活数据";
$UserStartNumber = $m->query("SELECT `IMSI` FROM `$willLikeDb` WHERE `日期` = '$nowCheckDate' AND $chanel AND $ProductID ORDER BY `时间戳` DESC ");
$UserStartUserNumber = $m->query("SELECT distinct `IMSI` FROM `$willLikeDb` WHERE `日期` = '$nowCheckDate' AND $chanel AND $ProductID GROUP BY `IMSI` ORDER BY `时间戳` ASC ");
$UserAppUserNumber = 0;
foreach($UserNumberList as $value){
if($nowCheckDate == $value["日期"]){
$UserAppUserNumber++;
}
}
$numberStart = count($UserStartNumber);
$numberUserStart = count($UserStartUserNumber);
$numberUserApp = $UserAppUserNumber + $inputData[0]['userApp'];
//运算
$totalPrice = $succMr[0]['sum(`price`)'] + $inputData[0]['price'];
echo "总资费:".$totalPrice." 其中--米粒资费:".$succMr[0]['sum(`price`)']." 秦敌输入数据资费:".$inputData[0]['price'],'';
if($nowChanel == 2015){
$totalPrice = $totalPrice * $bilibili / 0.32;
$totalPrice = intval($totalPrice / 100)*100;//IndexController::specialIntval($totalPrice / 100,array(10)) * 100; //20,15,12,10,8
//$Model->query("INSERT INTO `haQingInputData` (`productID`, `channelID`, `date`, `totalPrice`) VALUES ('$nowProductID', '2016', '$nowCheckDate', '$totalPrice')");
$query = "INSERT INTO `haQingInputData`
(`productID`, `channelID`, `date`, `totalPrice`, `timeStamp`, `userApp`, `startNumber`, `startUserNumber`)
VALUES ('$vale21[0]', '2016', '$nowCheckDate', '$totalPrice', '$t', '$numberUserApp', '$numberStart', '$numberUserStart');";
echo "扣量后给搜狗对私输入资费:".$totalPrice,'';
$Result = $Model->execute($query);
$totalPrice = $totalPrice * 0.73; //* 0.22 / $bilibili
$totalPrice = intval($totalPrice / 100)*100;//IndexController::specialIntval($totalPrice / 100,array(10)) * 100;
}else{
$totalPrice = $totalPrice * $bilibili / 0.30;
$totalPrice = intval($totalPrice / 100)*100;//IndexController::specialIntval($totalPrice / 100,array(10)) * 100;
}
//最后输入数据
$query = "INSERT INTO `haQingInputData`
(`productID`, `channelID`, `date`, `totalPrice`, `timeStamp`, `userApp`, `startNumber`, `startUserNumber`)
VALUES ('$vale21[0]', '$nowChanel', '$nowCheckDate', '$totalPrice', '$t', '$numberUserApp', '$numberStart', '$numberUserStart');";
echo "最终给".$nowChanel."渠道。输入资费:".$totalPrice,'';
$Result = $Model->execute($query);
}
}
public function chanelcheck(){
$willTableName = array (
"日期",
"产品名",
"启动次数",
"启动用户数",
"新增用户数",
"ARPU",
"MR"
);
$this->inputPassword2(2);//是否已经登陆 ,是的话,开始输数据。
$UseNumberT = 5;//使用第几套显数据
$t=time();//为这次访问的时间数据
$tBeiJing=$t+21600;
IndexController::getFenchengAndName();//赋值 codeLook|UpTableTable
$nowOp = I('op');
$nowProductID = I('productID',1000);
$nowChanel = I('chanel');
$nowCheckDateStar = I('checkDateStar');
$nowCheckDateEnd = I('checkDateEnd');
$nowChanel=session('chanel');
$willCheckPar = "op=".$nowOp."&productID=".$nowProductID."&chanel=".$nowChanel."&checkDateStar=".$nowCheckDateStar."&checkDateEnd=".$nowCheckDateEnd;
$willLikeDb = "代码";
//这里查进行分数据
$where = "1";
$m=M($willLikeDb);
//$p=IndexController::getpageA($m,$where,25);
//$list=$m->field(true)->where($where)->order('IMEI desc')->select();
$codeList = $m->query("SELECT distinct `代码编号`,`op`,`屏蔽省` FROM `$willLikeDb` WHERE `op` = '$nowOp' GROUP BY `代码编号` ORDER BY `$willLikeDb`.`代码编号` ASC");
$query = iconv("GB2312","UTF-8","SELECT * FROM `$willLikeDb` WHERE `日期` = '$checkDate' AND $chanel AND $ProductID AND $willcheckCode ORDER BY `时间戳` DESC ");
//var_dump($codeList);
//这里开始查代码。
$chanel = "(`渠道号` = '$nowChanel')";//自已定义的渠道号1002
if($nowChanel == 0){$chanel = "1";}
$checkDateStar = strtotime($nowCheckDateStar." 0:00:00");
$checkDateEnd = strtotime($nowCheckDateEnd." 24:00:00");
$willLinkDbName = date("ym",$checkDateStar+10);
$op = "(`运营商` = '$nowOp')";
if($nowOp == 0){$op = "1";}
$ProductID = "(`产品号` = '$nowProductID')";
if($nowProductID == 200000){$ProductID = "(`产品号` > $nowProductID)";}
if($nowProductID == 100000){$ProductID = "(`产品号` < 200000)";}
if($nowProductID == 0){$ProductID = "1";}
$chcekDay = ($checkDateEnd - $checkDateStar)/ 86400;
$willLikeDb = $willLinkDbName."激活数据";
$UserNumberList = $m->query("SELECT distinct `IMSI`,`日期`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < '$checkDateEnd' AND $chanel AND $ProductID AND $op GROUP BY `IMSI` ORDER BY `时间戳` ASC ");
for($i= 0 ; $i < $chcekDay;$i++){
$nowCheckTimeStampStart = $checkDateStar + 86400 * $i;
$nowCheckTimeStampEnd = $checkDateStar + 86400 * ($i + 1);
$nowCheckDate = date("Y-m-d",$nowCheckTimeStampStart + 60);
$willLikeDb = $willLinkDbName."请求付费次数";
$UserNumberClickList = $m->query("SELECT distinct `IMSI`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < $nowCheckTimeStampEnd AND `时间戳` > $nowCheckTimeStampStart AND $chanel AND $ProductID AND $op ORDER BY `时间戳` DESC ");
$willLikeDb = $willLinkDbName."激活数据";
$UserStartNumber = $m->query("SELECT `IMSI` FROM `$willLikeDb` WHERE `日期` = '$nowCheckDate' AND $chanel AND $ProductID AND $op ORDER BY `时间戳` DESC ");
$UserStartUserNumber = $m->query("SELECT distinct `IMSI` FROM `$willLikeDb` WHERE `日期` = '$nowCheckDate' AND $chanel AND $ProductID AND $op GROUP BY `IMSI` ORDER BY `时间戳` ASC ");
$UserAppUserNumber = 0;
foreach($UserNumberList as $value){
if($nowCheckDate == $value["日期"]){
$UserAppUserNumber++;
}
}
$willLikeDb = $willLinkDbName."请求付费次数";
$UserQustNumber = $m->query("SELECT `IMSI` FROM `$willLikeDb` WHERE `日期` = '$nowCheckDate' AND $chanel AND $ProductID AND $op ORDER BY `时间戳` DESC ");
$op2 = "(`op` = '$nowOp')";
$willLikeDb = $willLinkDbName."数据";
$succMr = $m->query("SELECT sum(`price`) FROM `$willLikeDb` WHERE `日期` = '$nowCheckDate' AND $chanel AND $ProductID AND $op2 ORDER BY `时间戳` DESC ");
//$succMrNumber = $m->query("SELECT `IMSI` FROM `$willLikeDb` WHERE `日期` = '$nowCheckDate' AND $chanel AND $ProductID AND $op2 ORDER BY `时间戳` DESC ");
//$succMrUserNumber = $m->query("SELECT distinct `IMSI` FROM `$willLikeDb` WHERE `日期` = '$nowCheckDate' AND $chanel AND $ProductID AND $op2 GROUP BY `IMSI` ORDER BY `时间戳` DESC ");
$list1[$i][0] = $nowCheckDate;
$list1[$i][1] = $nowProductID;
//$list1[$i][2] = $nowChanel;
$list1[$i][2] = count($UserStartNumber);
$list1[$i][3] = count($UserStartUserNumber);
$list1[$i][4] = $UserAppUserNumber;
//$list1[$i][6] = count($UserNumberClickList);
//$list1[$i][7] = intval((count($UserQustNumber)/count($UserStartUserNumber)*100))/100;
$list1[$i][5] = intval($succMr[0]['sum(`price`)']/$UserAppUserNumber)/100;
$list1[$i][6] = $succMr[0]['sum(`price`)']/100;
}
//echo $codeList[0]["屏蔽省"],'
';
//var_dump($UserNumberList);
//
$rowsNumber = 0;
foreach($codeList as $nowCodeInfo){
$codeNumber = $nowCodeInfo["代码编号"];
$code = "(`返回代码编号` = '$codeNumber')";
$codeTable2 = "(`记费代码` = '$codeNumber')";
$proListOpen = IndexController::getProvinceNumber($codeList[$rowsNumber]["屏蔽省"],$this->proListMove);
$UserNumber = 0;
foreach ($UserNumberList as $value){
if ( IndexController::isInString($proListOpen,$value["归属地"]) && $nowCheckDate == $value["日期"]){
$UserNumber++;
}
}
$willLikeDb = $willLinkDbName."请求付费次数";
$qustMo = $m->query("SELECT sum(`返回价格`) FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $code ORDER BY `时间戳` DESC ");
$qustMoNumber = $m->query("SELECT `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $code ORDER BY `时间戳` DESC ");
$qustMoUserNumber = $m->query("SELECT distinct `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $code GROUP BY `IMSI` ORDER BY `时间戳` DESC ");
$willLikeDb = $willLinkDbName."数据";
$succMr = $m->query("SELECT sum(`price`) FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 ORDER BY `时间戳` DESC ");
$succMrNumber = $m->query("SELECT `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 ORDER BY `时间戳` DESC ");
$succMrUserNumber = $m->query("SELECT distinct `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 GROUP BY `IMSI` ORDER BY `时间戳` DESC ");
$willLikeDb = $willLinkDbName."失败计费数据";
$failMr = $m->query("SELECT sum(`price`) FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 ORDER BY `时间戳` DESC ");
$failMrNumber = $m->query("SELECT `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 ORDER BY `时间戳` DESC ");
$failMrUserNumber = $m->query("SELECT distinct `IMSI` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 GROUP BY `IMSI` ORDER BY `时间戳` DESC ");
/*
echo '
';echo '
';echo '
';
echo $this->codeLookUpTable["$codeNumber"],'
';$list[$rowsNumber][0]=$this->codeLookUpTable["$codeNumber"];
echo $codeNumber,'
';$list[$rowsNumber][1]=$codeNumber;
echo $UserNumber,'
';$list[$rowsNumber][2]=$UserNumber;//符合省份的用户数
echo '
';
echo count($qustMoNumber),'
';$list[$rowsNumber][3]=count($qustMoNumber);//发起多少次付费请求
echo count($qustMoUserNumber),'
';$list[$rowsNumber][4]=count($qustMoUserNumber);//发起付费请求的用户数
echo $qustMo[0]['sum(`price`)'],'
';$list[$rowsNumber][5]=$qustMo[0]['sum(`price`)'];
echo '
';
echo count($succMrNumber)+count($failMrNumber),'
';$list[$rowsNumber][6]=count($succMrNumber)+count($failMrNumber);
echo count($succMrUserNumber)+count($failMrUserNumber),'
';$list[$rowsNumber][7]=count($succMrUserNumber)+count($failMrUserNumber);
echo $succMr[0]['sum(`price`)']+$failMr[0]['sum(`price`)'],'
';$list[$rowsNumber][8]=$succMr[0]['sum(`price`)']+$failMr[0]['sum(`price`)'];
echo '
';
echo count($succMrNumber),'
';$list[$rowsNumber][9]=count($succMrNumber);
echo count($succMrUserNumber),'
';$list[$rowsNumber][10]=count($succMrUserNumber);
echo $succMr[0]['sum(`price`)'],'
';$list[$rowsNumber][11]=$succMr[0]['sum(`price`)'];
echo '
';
echo $succMr[0]['sum(`price`)'] / count($succMrUserNumber),'
';$list[$rowsNumber][12]=$succMr[0]['sum(`price`)'] / count($succMrUserNumber);
echo count($succMrUserNumber) / count($qustMoUserNumber),'
';$list[$rowsNumber][13]=count($succMrUserNumber) / count($qustMoUserNumber);
echo $succMr[0]['sum(`price`)'] / $qustMo[0]['sum(`price`)'],'
';$list[$rowsNumber][14]=$succMr[0]['sum(`price`)'] / $qustMo[0]['sum(`price`)'];
echo '
';
echo count($succMrNumber)/(count($succMrNumber)+count($failMrNumber)),'
';$list[$rowsNumber][15]=count($succMrNumber)/(count($succMrNumber)+count($failMrNumber));
echo count($succMrUserNumber)/$UserNumber,'
';$list[$rowsNumber][16]=count($succMrUserNumber)/$UserNumber;
echo count($succMr[0]['sum(`price`)'])/$UserNumber,'
';$list[$rowsNumber][17]=count($succMr[0]['sum(`price`)'])/$UserNumber;
echo '
';echo '
';echo '
';
*/
$list[$rowsNumber][0]=$this->codeLookUpTable["$codeNumber"];
$list[$rowsNumber][1]=$codeNumber;
$list[$rowsNumber][2]=$UserNumber;
$list[$rowsNumber][3]=count($qustMoNumber);
$list[$rowsNumber][4]=count($qustMoUserNumber);
$list[$rowsNumber][5]=$qustMo[0]['sum(`返回价格`)']/100;
$list[$rowsNumber][6]=count($succMrNumber)+count($failMrNumber);
$list[$rowsNumber][7]=count($succMrUserNumber)+count($failMrUserNumber);
$list[$rowsNumber][8]=($succMr[0]['sum(`price`)']+$failMr[0]['sum(`price`)'])/100;
$list[$rowsNumber][9]=count($succMrNumber);
$list[$rowsNumber][10]=count($succMrUserNumber);
$list[$rowsNumber][11]=$succMr[0]['sum(`price`)']/100;
$list[$rowsNumber][12]=$list[$rowsNumber][11] * $this->codeLookUpTableInfo["$codeNumber"];
$list[$rowsNumber][13]=intval(($succMr[0]['sum(`price`)'] / count($succMrUserNumber)))/100;
$list[$rowsNumber][14]=(intval((count($succMrUserNumber) / count($qustMoUserNumber))*10000)/100)."%";
$list[$rowsNumber][15]=(intval(($succMr[0]['sum(`price`)'] / $qustMo[0]['sum(`返回价格`)'])*10000)/100)."%";
$list[$rowsNumber][16]=(intval((count($succMrNumber)/(count($succMrNumber)+count($failMrNumber)))*10000)/100)."%";
$list[$rowsNumber][17]=(intval((count($succMrUserNumber)/$UserNumber*10000))/100)."%";
$list[$rowsNumber][18]=(intval((($succMr[0]['sum(`price`)']/$UserNumber)))/100);
$list[$rowsNumber][19] = $willCheckPar."&codeNumber=".$codeNumber;
$rowsNumber++;
}//foreach结束
$list1[0][10] = $willCheckPar."&codeNumber="."0";
//这里查进行分数据
$willLikeDb = $willLinkDbName."请求付费次数";
//$m=$list;
$where = "1";
//$p=IndexController::getpageA($m,$where,25);
//$list=$m->field(true)->where($where)->order('IMEI desc')->select();
//$list=$m->field(true)->order('代码编号 desc')->select();
$i = 0;
MiLi1123:
$this->list=$list;
//$this->page=$p->show();
//上面查进行分数据
$this->assign('list1',$list1);
$this->assign('willShowDbName1',"总收入");
$willShowDbName = "SP收入列表";//表头名
$this->assign('willGotoHttp',$this->myIP."app/index.php/Home/Index/chanelcheck");//查询对应的HTTP界面
$this->assign('willShowDbName',$willShowDbName);
$this->assign('TableHeader1', $willTableName); //$this->TableHeader[6]);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->assign('TableHeader',$this->TableHeader[$UseNumberT]);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
$this->display();
}
public function spIncomTableInfo(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
IndexController::getFenchengAndName();//赋值 codeLook|UpTableTable
$nowOp = I('get.op');
$nowProductID = I('get.productID');
$nowChanel = I('get.chanel');
$nowCheckDateStar = I('get.checkDateStar');
$nowCheckDateEnd = I('get.checkDateEnd');
$nowCheckCodeNumber = I('get.codeNumber');
$nowIsCheck = I('get.isCheck');
$UseNumberT = 7;//
$isSendEmail = 0;
date_default_timezone_set("PRC");
$t=time();//为这次访问的时间数据
$tBeiJing=$t+0;
//这里开始查代码。
$chanel = "(`渠道号` = '$nowChanel')";//自已定义的渠道号1002
if($nowChanel == 0){$chanel = "1";}
$checkDateStar = strtotime($nowCheckDateStar." 0:00:00");
$checkDateEnd = strtotime($nowCheckDateEnd." 24:00:00");
$checkDateStarDateT = date("Y-m-d",$checkDateStar+10);
$checkDateEndDateT = date("Y-m-d",$checkDateEnd+10);
$willLinkDbName = date("ym",$checkDateStar+10);
$op = "(`运营商` = '$nowOp')";
$op2 = "(`op` = '$nowOp')";
if($nowOp == 0){$op = "1";$op2 = "1";}
$ProductID = "(`产品号` = '$nowProductID')";
if($nowProductID == 0){$ProductID = "1";}
//if($nowProductID == 200000){$ProductID = "(`产品号` > $nowProductID)";}
if($nowProductID == 500000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 600000 )";}
if($nowProductID == 400000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 500000 )";}
if($nowProductID == 200000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 300000 )";}
if($nowProductID == 300000){$ProductID = "((`产品号` > $nowProductID) AND `产品号` < 400000 OR (`产品号` = 0))";}
if($nowProductID == 100000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 200000)";}
$code = "(`返回代码编号` = '$nowCheckCodeNumber')";
$codeTable2 = "(`记费代码` = '$nowCheckCodeNumber')";
//$chcekDay = ($checkDateEnd - $checkDateStar)/ 86400;
$willLikeDb = "代码";
$m=M($willLikeDb);
$codeList = $m->query("SELECT distinct `代码编号`,`屏蔽省` FROM `$willLikeDb` WHERE `代码编号` = '$nowCheckCodeNumber' GROUP BY `代码编号` ORDER BY `$willLikeDb`.`代码编号` ASC");
$nowCheckTimeStampStart = $checkDateStar + 86400 * $i;
//$nowCheckTimeStampEnd = $checkDateStar + 86400 * $i;
$nowCheckDate = date("Y-m-d",$nowCheckTimeStampStart + 60);
if($nowCheckCodeNumber == 0){$codeList[0]["屏蔽省"]="";$code = "(1)";$codeTable2 = "(1)";}
$proListOpen = IndexController::getProvinceNumber($codeList[0]["屏蔽省"],$this->proListMove);
$willLikeDb = $willLinkDbName."激活数据";
$UserNumberList = $m->query("SELECT distinct `IMSI`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < '$checkDateEnd' AND `时间戳` > '$checkDateStar' AND $chanel AND $ProductID AND $op ORDER BY `时间戳` DESC ");
$willLikeDb = $willLinkDbName."激活数据";
$UserNumberListFormAppNumber = $m->query("SELECT distinct `IMSI`,`日期`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < '$checkDateEnd' AND $chanel AND $ProductID AND $op GROUP BY `IMSI` ORDER BY `时间戳` ASC ");
$willLikeDb = $willLinkDbName."请求付费次数";
$qustMoNumber = $m->query("SELECT `IMSI`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $code AND $op ORDER BY `时间戳` DESC ");
$qustMoUserNumber = $m->query("SELECT distinct `IMSI`,`归属地` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $code AND $op GROUP BY `IMSI` ORDER BY `时间戳` DESC ");
$willLikeDb = $willLinkDbName."数据";
$succMrNumber = $m->query("SELECT `IMSI`,`ICCID省` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 AND $op2 ORDER BY `时间戳` DESC ");
$succMrUserNumber = $m->query("SELECT distinct `IMSI`,`ICCID省` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 AND $op2 GROUP BY `IMSI` ORDER BY `时间戳` DESC ");
$willLikeDb = $willLinkDbName."失败计费数据";
//$failMr = $m->query("SELECT sum(`price`) FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 ORDER BY `时间戳` DESC ");
$failMrNumber = $m->query("SELECT `IMSI`,`ICCID省` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 AND $op2 ORDER BY `时间戳` DESC ");
$failMrUserNumber = $m->query("SELECT distinct `IMSI`,`ICCID省` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 AND $op2 GROUP BY `IMSI` ORDER BY `时间戳` DESC ");
//$proListOpen = explode("|", $proListOpen);
$tempNumber = 0;
//这里之前是用的 $proListOpen as $value1 现在改为 $this->proListMove as $value1
$test = $this->proListMove;
$test[31] = "";
foreach ($test as $value1){
$willLikeDb = $willLinkDbName."数据";
$succMr = $m->query("SELECT sum(`price`) FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 AND `ICCID省` = '$value1' AND $op2 ORDER BY `时间戳` DESC ");
$isOpenPro = 0;
$list[$tempNumber][0] = $value1;
if( IndexController::isInString($proListOpen,$value1) ){$list[$tempNumber][0] .= "(开通)";$isOpenPro = 1;}
foreach ($UserNumberListFormAppNumber as $value){
if ($value1 == rtrim($value["归属地"]) && ($checkDateStarDateT <= $value["日期"] && $checkDateEndDateT >= $value["日期"])){
//&& $nowCheckDate == $value["日期"]
$list[$tempNumber][1]++;
}
}
foreach ($UserNumberList as $value){
if ($value1 == rtrim($value["归属地"]) ){
$list[$tempNumber][2]++;
}
}
foreach ($qustMoNumber as $value){
if ($value1 == rtrim($value["归属地"]) ){
$list[$tempNumber][3]++;
}
}
foreach ($qustMoUserNumber as $value){
if ($value1 == rtrim($value["归属地"]) ){
$list[$tempNumber][4]++;
}
}
foreach ($succMrNumber as $value){
if ($value1 == rtrim($value["iccid省"]) ){
$list[$tempNumber][7]++;
}
}
foreach ($succMrUserNumber as $value){
if ($value1 == rtrim($value["iccid省"]) ){
$list[$tempNumber][8]++;
}
}
foreach ($failMrNumber as $value){
if ($value1 == rtrim($value["iccid省"]) ){
$list[$tempNumber][5]++;
}
}
$list[$tempNumber][5] += $list[$tempNumber][7];
foreach ($failMrUserNumber as $value){
if ($value1 == rtrim($value["iccid省"]) ){
$list[$tempNumber][6]++;
}
}
$list[$tempNumber][6] += $list[$tempNumber][8];
$list[$tempNumber][9] = $succMr[0]["sum(`price`)"]/100;
$list[$tempNumber][10] = intval($list[$tempNumber][9] / $list[$tempNumber][1] * 100)/100;
$list[$tempNumber][11] = intval($list[$tempNumber][9] / $list[$tempNumber][8] * 100)/100;
$list[$tempNumber][12] = (intval(($list[$tempNumber][8] / $list[$tempNumber][4])*10000)/100)."%";
$list[$tempNumber][13] = (intval(($list[$tempNumber][7] / $list[$tempNumber][3])*10000)/100)."%";
if ($nowIsCheck == 1){
if ($isOpenPro == 1 && $list[$tempNumber][2] > 30 && (intval(($list[$tempNumber][6] / $list[$tempNumber][4])*10000)/100) < 8){
$isSendEmail = $tempNumber;
}
}
//这里给字体增加URL
$url = $_SERVER['QUERY_STRING'];//'http://'.$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF'].'?'.$_SERVER['QUERY_STRING'];
//$this->myIP."app/index.php/Home/Index/spIncomTableInfoGoChanel"."?$tempNumber"."&".$url
$list[$tempNumber][1] = IndexController::setUrl($list[$tempNumber][1],$this->myIP."app/index.php/Home/Index/spIncomTableInfoGoChanel"."?province=$tempNumber"."&".$url);
$tempNumber++;
}
if ($nowIsCheck == 1){
$url = 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF'].'?'.$_SERVER['QUERY_STRING'];
echo "";
$chcekOpen[0] = "open1";
$chcekOpen[1] = "open2";
$chcekOpen[2] = "1";
}else{
$chcekOpen[0] = "close1";
$chcekOpen[1] = "close2";
$chcekOpen[2] = "0";
}
if ($isSendEmail != 0){
$mail = new \MySendMail();
$mail->setServer("smtp.qq.com", "2893656503@qq.com", "blyxbjoosnxpdeah", 465, true); //设置smtp服务器,到服务器的SSL连接
$mail->setFrom("2893656503@qq.com"); //设置发件人
$mail->setReceiver("515298497@qq.com"); //设置收件人,多个收件人,调用多次
$mail->setReceiver("1442364747@qq.com"); //设置收件人,多个收件人,调用多次
$mail->setReceiver("1033955681@qq.com"); //设置收件人,多个收件人,调用多次
$province = $GLOBALS['province'];
$mail->setMail("收入异常!", "".$url.""); //设置邮件主题、内容
$mail->sendMail(); //发送
}
$this->assign('open',$chcekOpen);
$this->list=$list;
$willShowDbName = $this->codeLookUpTable["$nowCheckCodeNumber"]."($nowCheckCodeNumber)收入分析";//表头名
if($nowCheckCodeNumber == 0){$willShowDbName="省份分析";}
$this->assign('willShowDbName',$willShowDbName);
$this->registerTheTitle($UseNumberT,$tBeiJing);//注册左标题栏
$this->assign('TableHeader',$this->TableHeader[$UseNumberT]);
$this->assign('FirstName3344',$this->FirstName3344);
$Name = "施工中【这排都没用】";
$this->assign('name',$Name);
$this->display();
}
public function spIncomTableGoChanel(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$nowOp = I('get.op');
$nowProductID = I('get.productID');
$nowChanel = I('get.chanel');
$nowCheckDateStar = I('get.checkDateStar');
$nowCheckDateEnd = I('get.checkDateEnd');
$nowCheckCodeNumber = I('get.codeNumber',0);
$nowIsCheck = I('get.isCheck');
$nowCheckProvince = I('get.province');
date_default_timezone_set("PRC");
$t=time();//为这次访问的时间数据
$tBeiJing=$t+0;
//这里开始查代码。
$chanel = "(`渠道号` = '$nowChanel')";//自已定义的渠道号1002
if($nowChanel == 0){$chanel = "1";}
$checkDateStar = strtotime($nowCheckDateStar." 0:00:00");
$checkDateEnd = strtotime($nowCheckDateEnd." 24:00:00");
$willLinkDbName = date("ym",$checkDateStar+10);
$op = "(`运营商` = '$nowOp')";
$op2 = "(`op` = '$nowOp')";
if($nowOp == 0){$op = "1";$op2 = "1";}
$ProductID = "(`产品号` = '$nowProductID')";
if($nowProductID == 0){$ProductID = "1";}
if($nowProductID == 500000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 600000 )";}
if($nowProductID == 400000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 500000 )";}
if($nowProductID == 200000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 300000 )";}
if($nowProductID == 300000){$ProductID = "((`产品号` > $nowProductID) AND `产品号` < 400000 OR (`产品号` = 0))";}
if($nowProductID == 100000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 200000)";}
$code = "(`返回代码编号` = '$nowCheckCodeNumber')";
$codeTable2 = "(`记费代码` = '$nowCheckCodeNumber')";
if($nowCheckCodeNumber == 0){$code = "(1)";$codeTable2 = "1";}
$m=M($willLikeDb);
$nowCheckTimeStampStart = $checkDateStar + 86400 * $i;
$nowCheckDate = date("Y-m-d",$nowCheckTimeStampStart + 60);
$willLikeDb = $willLinkDbName."数据";
//echo "SELECT `渠道号` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 AND $op2 ORDER BY `时间戳` DESC ";
$succMrNumber = $m->query("SELECT distinct `渠道号` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 AND $op2 ORDER BY `时间戳` DESC ");
$succMrUserNumber = $m->query("SELECT distinct `IMSI`,`ICCID省` FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $chanel AND $ProductID AND $codeTable2 AND $op2 ORDER BY `时间戳` DESC ");
//var_dump($succMrNumber);
$url = $_SERVER['QUERY_STRING'];
$test = $this->proListMove;
$test[31] = "";
$i =0;
foreach ($succMrNumber as $value){
$tempChanel = "`渠道号` = '".$value['渠道号']."'";
//echo 'numner'.$i++,'
';
$succMr = $m->query("SELECT sum(`price`) FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $tempChanel AND $ProductID AND $codeTable2 AND $op2 ORDER BY `时间戳` DESC ");
//echo "SELECT sum(`price`) FROM `$willLikeDb` WHERE `时间戳` < $checkDateEnd AND `时间戳` > $checkDateStar AND $tempChanel AND $ProductID AND $codeTable2 AND $op2 ORDER BY `时间戳` DESC ";
//var_dump($succMr);
$list[$value["渠道号"]] = $succMr[0]['sum(`price`)'];
}
//echo "SB";
//var_dump($list);
$totalPrice = 0;
foreach($list as $key => $value){
$tempStringecho = $key."渠道有资费:".($value /100);
$totalPrice += $value;
//$tempStringecho = IndexController::setUrl($tempStringecho,$this->myIP."app/index.php/Home/Index/spIncomTableInfoGoProductID"."?GoChanel=$key"."&".$url);
//echo $key.":".$value,"
";
echo $tempStringecho,"
";
}
$tempStringecho = "总资费:".($totalPrice /100);
echo $tempStringecho,"
";
}
public function spIncomTableInfoGoChanel(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$nowOp = I('get.op');
$nowProductID = I('get.productID');
$nowChanel = I('get.chanel');
$nowCheckDateStar = I('get.checkDateStar');
$nowCheckDateEnd = I('get.checkDateEnd');
$nowCheckCodeNumber = I('get.codeNumber');
$nowIsCheck = I('get.isCheck');
$nowCheckProvince = I('get.province');
date_default_timezone_set("PRC");
$t=time();//为这次访问的时间数据
$tBeiJing=$t+0;
//这里开始查代码。
$chanel = "(`渠道号` = '$nowChanel')";//自已定义的渠道号1002
if($nowChanel == 0){$chanel = "1";}
$checkDateStar = strtotime($nowCheckDateStar." 0:00:00");
$checkDateEnd = strtotime($nowCheckDateEnd." 24:00:00");
$checkDateStarDateT = date("Y-m-d",$checkDateStar+10);
$checkDateEndDateT = date("Y-m-d",$checkDateEnd+10);
$willLinkDbName = date("ym",$checkDateStar+10);
$op = "(`运营商` = '$nowOp')";
$op2 = "(`op` = '$nowOp')";
if($nowOp == 0){$op = "1";$op2 = "1";}
$ProductID = "(`产品号` = '$nowProductID')";
if($nowProductID == 0){$ProductID = "1";}
if($nowProductID == 500000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 600000 )";}
if($nowProductID == 400000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 500000 )";}
if($nowProductID == 200000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 300000 )";}
if($nowProductID == 300000){$ProductID = "((`产品号` > $nowProductID) AND `产品号` < 400000 OR (`产品号` = 0))";}
if($nowProductID == 100000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 200000)";}
$m=M($willLikeDb);
$nowCheckTimeStampStart = $checkDateStar + 86400 * $i;
$nowCheckDate = date("Y-m-d",$nowCheckTimeStampStart + 60);
$willLikeDb = $willLinkDbName."激活数据";
$UserNumberListFormAppNumber = $m->query("SELECT distinct `IMSI`,`日期`,`归属地`,`产品号`,`渠道号` FROM `$willLikeDb` WHERE `时间戳` < '$checkDateEnd' AND $chanel AND $ProductID AND $op GROUP BY `IMSI` ORDER BY `时间戳` ASC ");
echo "此处数据未去除上个月的留存用户,但去除了本月的留存用户","
";
$url = $_SERVER['QUERY_STRING'];
$test = $this->proListMove;
$test[31] = "";
foreach ($UserNumberListFormAppNumber as $value){
if ($test[$nowCheckProvince] == rtrim($value["归属地"]) && ($checkDateStarDateT <= $value["日期"] && $checkDateEndDateT >= $value["日期"])){
$list[$value["渠道号"]]++;
}
}
$tempNumber = 0;
foreach($list as $key => $value){
$tempStringecho = $key."渠道有用户:".$value;
$tempStringecho = IndexController::setUrl($tempStringecho,$this->myIP."app/index.php/Home/Index/spIncomTableInfoGoProductID"."?GoChanel=$key"."&".$url);
//echo $key.":".$value,"
";
echo $tempStringecho,"
";
}
}
public function spIncomTableInfoGoProductID(){
$this->inputPassword();//是否已经登陆 ,是的话,开始输数据。
$nowOp = I('get.op');
$nowProductID = I('get.productID');
$nowChanel = I('get.chanel');
$nowCheckDateStar = I('get.checkDateStar');
$nowCheckDateEnd = I('get.checkDateEnd');
$nowCheckCodeNumber = I('get.codeNumber');
$nowIsCheck = I('get.isCheck');
$nowCheckProvince = I('get.province');
$nowGoChanel = I('get.GoChanel');
$t=time();//为这次访问的时间数据
$tBeiJing=$t+21600;
//这里开始查代码。
$chanel = "(`渠道号` = '$nowChanel')";//自已定义的渠道号1002
if($nowChanel == 0){$chanel = "1";}
$checkDateStar = strtotime($nowCheckDateStar." 0:00:00");
$checkDateEnd = strtotime($nowCheckDateEnd." 24:00:00");
$willLinkDbName = date("ym",$checkDateStar+10);
$op = "(`运营商` = '$nowOp')";
$op2 = "(`op` = '$nowOp')";
if($nowOp == 0){$op = "1";$op2 = "1";}
$ProductID = "(`产品号` = '$nowProductID')";
if($nowProductID == 0){$ProductID = "1";}
if($nowProductID == 500000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 600000 )";}
if($nowProductID == 400000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 500000 )";}
if($nowProductID == 200000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 300000 )";}
if($nowProductID == 300000){$ProductID = "((`产品号` > $nowProductID) AND `产品号` < 400000 OR (`产品号` = 0))";}
if($nowProductID == 100000){$ProductID = "(`产品号` > $nowProductID AND `产品号` < 200000)";}
$m=M($willLikeDb);
$nowCheckTimeStampStart = $checkDateStar + 86400 * $i;
$nowCheckDate = date("Y-m-d",$nowCheckTimeStampStart + 60);
$willLikeDb = $willLinkDbName."激活数据";
$UserNumberListFormAppNumber = $m->query("SELECT distinct `IMSI`,`日期`,`归属地`,`产品号`,`渠道号` FROM `$willLikeDb` WHERE `时间戳` < '$checkDateEnd' AND $chanel AND $ProductID AND $op GROUP BY `IMSI` ORDER BY `时间戳` ASC ");
$test = $this->proListMove;
$test[31] = "";
foreach ($UserNumberListFormAppNumber as $value){
if ($test[$nowCheckProvince] == rtrim($value["归属地"]) && $nowCheckDate == $value["日期"] && $nowGoChanel == $value["渠道号"]){
$list[$value["产品号"]]++;
}
}
$tempNumber = 0;
foreach($list as $key => $value){
echo $key."产品号有用户:".$value,"
";
}
}
public function getFenchengAndName(){
if($this->myIP == 'http://123.59.81.165/'){
$this->codeLookUpTableInfo = array();
$this->codeLookUpTable = array();
}
$willLikeDb = "代码";
$m=M($willLikeDb);
$list = $m->query("SELECT * FROM `$willLikeDb` where 1");
foreach($list as $value){
if($value['fencheng'] != null && $value['fencheng'] > 0)
$this->codeLookUpTableInfo["$value[代码编号]"] = $value['fencheng'] / 100;
if($value['name'] != null && strlen($value['name']) > 2)
$this->codeLookUpTable["$value[代码编号]"] = $value['name'];
}
}
public function loadHaQingYouxi(){
$this->haqingyouxiproduct = array();
$willLikeDb = "the_ha_game_name";
$m=M($willLikeDb);
$list = $m->query("SELECT * FROM `$willLikeDb` where 1");
foreach($list as $value){
array_push($this->haqingyouxiproduct,array($value['the_number'],$value['name']));
}
}
public function getProvinceNumber($list,$proListMove){
$listReturn = "";
foreach ($proListMove as $value){
if (!IndexController::isInString($list,$value)){
$listReturn .= "|".$value;
}
}
return $listReturn;
}
public function theDataLookEdit($lookData="1610",$codeTimeStamp,$codeImsi){
if(IS_POST){
//这里写提交后接收的数数据
}else{
$willLikeDb = "1610数据";
if (strlen($lookData)!=4){
$willLikeDb = date("ym",$tBeiJing);
$willLikeDb = $willLikeDb."数据";
}else{
$willLikeDb = $lookData."数据";
}
//这里边写的事根据传过来的id查出来的数据,然后展示给页面
//$m=M($willLikeDb);
$User = M($willLikeDb); // 实例化User对象
//dump('代码编号 = '."$codeNumber");
$Result = $User->where('时间戳 = '."$codeTimeStamp"." AND ".'IMSI = '."$codeImsi" )->select();
dump($Result);
//$checkTrue=array(0,0,0);
for ($i = 0; $i < 24; $i++) {
if($i < 10){
$checkString = "0".(String)$i;
}else{
$checkString = (String)$i;
}
if ($i%12==1){
$checkTrue[$i][3] = "
";
}
$checkTrue[$i][1] = (String)$i."-".(String)($i+1);
//dump($checkString);
if (IndexController::isInString($Result[0]["123"],$checkString)){
$checkTrue[$i][0]="checked";
}else {
$checkTrue[$i][0]="";
}
//dump($checkTrue[$i]);
}
for ($i = 0; $i < 31; $i++) {
if (IndexController::isInString($Result[0][屏蔽省],$this->proListMove[$i])){
$checkProListTrue[$i][0]="checked";
$checkProListTrue[$i][1]=$this->proListMove[$i];
}else {
$checkProListTrue[$i][0]="";
$checkProListTrue[$i][1]=$this->proListMove[$i];
}
if ($i%12==1){
$checkProListTrue[$i][3] = "
";
}
}
//dump($checkTrue);
$this->assign('Result',$Result);
$this->assign('OpenTime',$checkTrue);
$this->assign('checkProListTrue',$checkProListTrue);
$this->display();
}
}
public function getpageA($m,$where,$pagesize=10){
$m1=clone $m;//浅复制一个模数据
$count = $m->where($where)->count();//连惯操作后会对join等操作进行重数据
$m=$m1;//为保持在为定的连惯操作,浅复制一个模数据
$p=new \Think\Page($count,$pagesize);
$p->lastSuffix=false;//%LIST_ROWS%
$p->setConfig('listrow',$pagesize);
$p->setConfig('header','共有%TOTAL_ROW%条记录 第%NOW_PAGE%页/共%TOTAL_PAGE%页');
$p->setConfig('prev','上一数据');
$p->setConfig('next','下一数据');
$p->setConfig('last','末页');
$p->setConfig('first','首页');
$p->setConfig('theme','%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% %HEADER%');
$p->parameter=I('get.');
$m->limit($p->firstRow,$p->listRows);
return $p;
}
public function getpageB($m,$count,$pagesize=10){
$m1=clone $m;//浅复制一个模数据
$m=$m1;//为保持在为定的连惯操作,浅复制一个模数据
$p=new \Think\Page($count,$pagesize);
$p->lastSuffix=false;//%LIST_ROWS%
$p->setConfig('listrow',$pagesize);
$p->setConfig('header','共有%TOTAL_ROW%条记录 第%NOW_PAGE%页/共%TOTAL_PAGE%页');
$p->setConfig('prev','上一数据');
$p->setConfig('next','下一数据');
$p->setConfig('last','末页');
$p->setConfig('first','首页');
$p->setConfig('theme','%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% %HEADER%');
$p->parameter=I('get.');
$m->limit($p->firstRow,$p->listRows);
return $p;
}
public function getpage(){
$where = "1";
$m=M("1610数据");
$p=IndexController::getpageA($m,$where,10);
//$list=$m->field(true)->where($where)->order('IMEI desc')->select();
$list=$m->field(true)->order('产品数据 desc')->select();
$this->list=$list;
$this->page=$p->show();
$this->assign('list',$list);
$this->assign('page', $p->show());
//$this->assign('pagination',$p);
$this->display();
echo '这是数据个测试方数据!';
dump($list);
}
public function hello($name='thinkphp'){
$User = M("1610数据"); // 实例化User对象
$Result123 = $User->select();;
$condition['pid'] = '1476005105908';
// 把查询条件传入查询方数据
$User->where($condition)->select();
$userC = $User->where($condition)->select();
$userCount = $User->count();
//$name = mysql_fetch_row($result);
//$name = $result[0];
$where = "1";
$m=M('1610数据');
$p=IndexController::getpageA($m,$where,10);
$list=$m->field(true)->where($where)->order('IMEI desc')->select();
$this->list=$list;
$this->page=$p->show();
//$name = $userCount;
//$maxScore = $User->sum('TTT');
$this->assign('name',$Result123[1]["数据"]);
$this->display();
}
public function test(){
echo '这是一个测试方法在';
}
protected function hello2(){
echo '只是protected方法!';
}
private function hello3(){
echo '这是private方法!';
}
function isInString($haystack, $needle) {
$haystack = '-_-!' . $haystack;
return (bool)strpos($haystack, $needle);
}
//给字体增加连接
function setUrl($originalString,$url){
$returnString = "".$originalString."";
return $returnString;
}
//设置字体颜色
function setColor($originalString,$color){
$returnString = "".$originalString."";
return $returnString;
}
//参数 0 原始数字 1要求是多少的倍数【可以是数组】
function specialIntval($originalNumber,$multiple){
$real_num = $originalNumber;
$real_num = intval($real_num);
shuffle($multiple);
$real_num = intval($real_num / $multiple[0])*$multiple[0];
return $real_num;
}
//补位 参数0 原始字符串 参数1 将补到 多少 位 参数2 补的字符是什么 参数3 为0时在左端 为1时在右端补
function zeroFillLeft($originalString,$number,$willString,$mode){
$num_len = strlen($originalString);
$num_len1 = mb_strlen($originalString,'utf8');
//echo $num_len.' ';
//echo $num_len1.' ';
$num_len = ($num_len - $num_len1)/2 + $num_len1;
//echo "mimi:".$num_len.' '.$originalString,'
';
$zero = '';
for($i=$num_len; $i< $number; $i++){
$zero .= $willString;
}
if($mode == 0){
$real_num = "".$zero.$originalString;
}else{
$real_num = "".$originalString.$zero;
}
return $real_num;
}
function qubaifengbi($origil,$baoliu=2){
$tempNumber = pow(10,$baoliu);
return intval($origil*$tempNumber)/$tempNumber;
}
}