static function static_run($key, $begin = 0, $end = 9999999999)
{
// $local=new medoo();
$remote = new maindb();
$firstdb = new firstdb();
$auth_list = $remote->select('p_user', 'uid', array('AND' => array('invite' => $key, 'auth_time[>]' => $begin, 'auth_time[<]' => $end, 'auth' => 1)));
if (empty($auth_list)) {
return 0;
//没有邀请认证，b值返回0
} else {
//根据每个uid去查询机器码
// print_r($auth_list);
$mc_list = array();
$null_mc = 0;
foreach ($auth_list as $v) {
$re = $firstdb->select('auth', 'deviceid', array('uid' => $v));
if (empty($re[0])) {
$mc_list[$null_mc] = '';
$null_mc += 1;
} else {
$mc_list[$re[0]] = '';
}
// $mc_list[]=$re[0];
}
// print_r($mc_list);
$b_value = number_format(count($auth_list) / count($mc_list), 2);
//b_value保留两位小数
return $b_value;
}
}
protected function performance_data()
{
$remote = new maindb();
$num = $remote->count('p_user', '*', array('invite' => $this->key));
$re = $remote->select('p_user', array('nickname', 'phone', 'auth'), array('invite' => $this->key, 'LIMIT' => 20));
if ($num != 0) {
$pages = ceil($num / 20);
//分多少页
} else {
$pages = 0;
}
//推送总数和数据
$this->assign('data', array('num' => $num, 'list' => $re, 'pages' => $pages, 'index' => 1, 'key' => $this->key));
}
protected function get_order_list()
{
$local = new medoo();
$remote = new maindb();
$list = $local->select('orders', '*', array('ekey' => $this->key));
if (!empty($list)) {
foreach ($list as &$v) {
$info = $remote->select('p_order', '*', array('id' => $v['order_id']));
//将unix时间戳转化为日期
$v['u_time'] = date('Y-m-d H:i:s', $v['u_time']);
$v['c_time'] = date('Y-m-d H:i:s', $v['c_time']);
if ($info[0]['did'] > 0) {
$v['order_state'] = $this->state['-1'];
} else {
$v['order_state'] = $this->state[$info[0]['state']];
}
}
}
$this->assign('list', $list);
}
<?php
/**
* Created by PhpStorm.
* User: KeenSting
* Date: 2015/10/24
* Time: 0:57
*/
require './maindb.php';
//require('./firstdb.php');
//$db=new firstdb();
$db = new maindb();
$re = $db->select('p_user', '*', array('nickname' => $_GET['name']));
//$re=$db->select('auth','*');
print_r($re);
<?php
/**
* Created by PhpStorm.
* User: KeenSting
* Date: 2015/10/15
* Time: 13:54
*/
require_once '../../../medoo/maindb.php';
$page = $_POST['page'];
$key = $_POST['key'];
$remote = new maindb();
$start = ($page - 1) * 20;
$re = $remote->select('p_user', array('nickname', 'phone', 'auth'), array('invite' => $key, 'LIMIT' => [$start, 20]));
$result = array('list' => $re, 'index' => $page);
echo json_encode($result);
<?php
/**
* Created by PhpStorm.
* User: KeenSting
* Date: 2015/11/20
* Time: 14:53
*/
require '../medoo/maindb.php';
$demo = new maindb();
$id = $_POST['id'];
$re = $demo->select('p_user', '*', array('uid' => $id));
$lifeTime = 3600;
//生命周期为1小时
session_set_cookie_params($lifeTime);
session_start();
$_SESSION['user_info'] = $re[0];
//将用户信息存储起来
echo $re[0]['nickname'];
/**
* Created by PhpStorm.
* User: KeenSting
* Date: 2015/10/19
* Time: 10:30
*/
require_once '../../../medoo/medoo.php';
require_once '../../../medoo/maindb.php';
$id = $_POST['id'];
session_start();
$key = $_SESSION['userinfo']['ekey'];
//获取用户的唯一key
$remote = new maindb();
$local = new medoo();
//查询一次远端数据库，匹配订单状态
$item = $remote->select('p_order', '*', array('id' => $id));
if (empty($item)) {
echo 'noinfo';
} elseif ($item[0]['state'] < 2) {
echo 'unfinish';
} else {
//todo
//可能会添加几个大使开放所有订单种类
$sid = $item[0]['sid'];
$sell_info = $remote->select('p_sell_goods', 'ccid', array('id' => $sid));
$ccid = $sell_info[0];
if ($ccid != 100) {
echo 'type';
exit;
}
$check = $local->count('orders', '*', array('order_id' => $id));
<?php
/**
* Created by PhpStorm.
* User: KeenSting
* Date: 2015/10/24
* Time: 0:57
*/
//require('medoo.php');
//$local=new medoo();
//$orders=$local->count('orders','*',array(
// 'AND'=>array(
// 'u_time[<]'=>9999999999,
// 'u_time[>]'=>0,
// 'state'=>0,//只统计未结算的订单
// 'ekey'=>'230230',
// 'act_id'=>0,
// )));
//echo 'dasd';
//print_r($orders);
require 'maindb.php';
$demo = new maindb();
$list = $demo->select('p_user', '*', array('phone' => '13121062200'));
print_r($list);
