沉冰浮水 发表于 2018-9-8 10:12:04

关于如何的正确自建表

完整插件下载:https://we.tl/t-fHdIlGQsAE

<?php
//注册插件
RegisterPlugin("Order", "ActivePlugin_Order");
function ActivePlugin_Order()
{
Add_Filter_Plugin('Filter_Plugin_Admin_LeftMenu', 'Order_Mng');
}
function Order_Mng(&$leftmenus){
global $zbp;
$leftmenus['nav_order'] = MakeLeftMenu("3", "订单管理", $zbp->host . "zb_users/plugin/Order/main.php", "nav_order", "aOrderMng", "");
}
function InstallPlugin_Order()
{
Order::CreateTable();
}
function UninstallPlugin_Order()
{
}
//数据测试
function Order_test($n = 0)
{
if ($n > 0)
    Order_test($n - 1);
$article = new Post();
$article->LoadInfoByID(15);
if ($article->ID == 0)
    return false;
$Count      = 2;
$Usr      = "usr";
$Tel      = "10086";
$Add      = "Add";
$Note       = "Note";
$ord      = new Order();
$ord->LogID = $article->ID;
$ord->Name= $article->Title;
$ord->Count = $Count;
$ord->Price = $article->Metas->price * $Count;
$ord->Usr   = $Usr;
$ord->Add   = $Add;
$ord->Tel   = $Tel;
$ord->Note= $Note;
return $ord->Save();
}
class Order extends Base
{
public static $tableX = '%pre%plugin_order';
public static $datainfoX = array(
    'ID' => array('ord_ID', 'integer', '', 0),
    'Send' => array('ord_Send', 'boolean', '', false),
    'Open' => array('ord_Open', 'boolean', '', true),
    'LogID' => array('ord_LogID', 'integer', '', 0),
    'Time' => array('ord_Time', 'integer', '', 0),
    'Name' => array('ord_Name', 'string', 50, ''),
    'Count' => array('ord_Count', 'integer', '', 1),
    'Price' => array('ord_Price', 'integer', '', 1),
    'Usr' => array('ord_Usr', 'string', 50, ''),
    'Add' => array('ord_Add', 'string', '', ''),
    'Tel' => array('ord_Tel', 'string', 50, ''),
    'Note' => array('ord_Note', 'string', 255, ''),
    'Mail' => array('ord_Mail', 'string', 50, ''),
    'IP' => array('ord_IP', 'string', 50, '')
);
public function __construct()
{
    parent::__construct(self::$tableX, self::$datainfoX, __CLASS__);
    $this->Time = time();
    $this->IP   = GetGuestIP();
}
// Order::CreateTable()
public static function CreateTable()
{
    global $zbp;
    if (!$zbp->db->ExistTable(self::$tableX)) {
      $sql = $zbp->db->sql->CreateTable(self::$tableX, self::$datainfoX);
      $zbp->db->QueryMulit($sql);
    }
}
}


17cat 发表于 2018-9-8 16:43:24

可行,但并不完全正确。:hehe
页: [1]
查看完整版本: 关于如何的正确自建表