public function show()
{
$table = I('get.table');
$Model = new \Think\Model();
$sql = 'show columns from ' . $table . ';';
$tabel_info = $Model->query($sql);
$data = $Model->table($table)->select();
$this->assign('table', $table);
$this->assign('data', $data);
$this->assign('tabel_info', $tabel_info);
$this->display();
}
public function index_trans()
{
$line_items = array("0" => "line 1", "1" => "line 2", "2" => "line 3");
if (IS_POST) {
$transDB = new \Think\Model();
$transDB->startTrans();
$title = array('title' => $_POST['title']);
$header_result = $transDB->table('t_header')->add($title);
if ($header_result) {
$id = $transDB->table('t_header')->getLastInsID();
$line = array('line' => $_POST['selectedText'], 'header_id' => $id);
$line_result = $transDB->table('t_detail')->add($line);
if ($line_result) {
$transDB->commit();
} else {
$transDB->rollback();
}
} else {
$transDB->rollback();
}
}
$this->assign('line_items', $line_items);
$this->display('transDemo');
}
public function index()
{
session_start();
header('Content-Type:text/html; charset=UTF-8');
//防止出现乱码
$uid = $_SESSION['uid'];
$username = $_SESSION['username'];
$this->assign('username', $username);
//用户抵押物品信息
$goods = new \Think\Model();
$condition['f_uid'] = $uid;
$goodsarr = $goods->table('t_user_stock a')->field('a.f_uid uid,a.f_sid sid,a.f_shares shares,f_shares_frozen frozenshares,b.f_id id,b.f_stockcode stockcode,b.f_stockname stockname,b.f_price price')->join('t_stockinfo b on a.f_sid = b.f_id')->where($condition)->select();
$this->assign('goodsarr', $goodsarr);
//投资列表
$Model = new \Think\Model();
$investarr = $Model->query("select a.f_uid userid,a.f_username username,b.f_id vid,round(b.f_yield*100,2) yield,round(b.f_money) money,round(b.f_danbaomoney,2) danbaomoney,b.f_horizon horizon,b.f_state state,DATE_FORMAT(b.f_addtime,'%Y-%m-%d') addtime from t_userinfo a,t_invest b where a.f_uid=b.f_userid and b.f_state=200 order by b.f_addtime desc limit 20");
$this->assign('investlist', $investarr);
$this->display();
}
public function index()
{
session_start();
header('Content-Type:text/html; charset=UTF-8');
//防止出现乱码
$username = session('username');
$uid = session('uid');
$isLogin = $uid ? true : false;
$this->assign('username', $username);
$this->assign('islogin', $isLogin);
//股票列表
$Stock = M("stockinfo");
$stocklist = $Stock->field('f_id sid,f_stockcode stockcode,f_stockname stockname,round(f_openprice,2) openprice,round(f_price,2) price,f_state state')->select();
$this->assign('stocklist', $stocklist);
//我的股票
if ($isLogin) {
$Stock = new \Think\Model();
$mystockinfo = $Stock->table('t_stockinfo a,t_user_stock b')->where('a.f_id = b.f_sid and b.f_uid =' . $uid . ' and b.f_shares>0')->field('a.f_id sid,a.f_stockcode stockcode,a.f_stockname stockname,round(a.f_price,2) price,round(f_openprice,2) openprice,b.f_shares shares,b.f_state state')->order('b.f_uptime desc')->limit(20)->select();
$this->assign('mystockinfo', $mystockinfo);
}
$this->display();
}
