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);