<?php
$sql = "
CREATE TABLE IF NOT EXISTS `ims_wwx_fxxt_printer` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uniacid` int(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `printertype` int(11) NOT NULL DEFAULT '0' COMMENT '0常规打印，1快递',
  `createtime` int(10) NOT NULL DEFAULT '0',
  `isdefault` int(11) NOT NULL DEFAULT '0',
  `expressdaxiao` varchar(50) DEFAULT '12' COMMENT '字体大小',
  `expressziti` varchar(50) DEFAULT '宋体' COMMENT '字体样式',
  `expresspic` varchar(1000) DEFAULT '',
  `expresscode` varchar(100) NOT NULL DEFAULT '',
  `expressconfig` text,
  `printerconfig` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_wwx_fxxt_member_flaggrade` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uniacid` int(11) NOT NULL,
  `displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '级别',
  `flag_name` varchar(50) DEFAULT NULL COMMENT '等级名称',
  `flag_commission1` int(3) NOT NULL DEFAULT '0' COMMENT '1级分销比例',
  `flag_commission2` int(3) NOT NULL DEFAULT '0' COMMENT '2级分销比例',
  `flag_commission3` int(3) NOT NULL DEFAULT '0' COMMENT '3级分销比例',
  `flag_money` decimal(10,2) NOT NULL DEFAULT '0' COMMENT '提现金额',
  `flag_totalmoney` decimal(10,2) NOT NULL DEFAULT '0' COMMENT '分销总金额',
  `flag_count` int(10) NOT NULL DEFAULT '0' COMMENT '所需粉丝数量',
  `promoterstate` tinyint(1) DEFAULT '0' COMMENT '加入此代理需要分销订单的状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_wwx_fxxt_member_shipgrade` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uniacid` int(11) NOT NULL,
  `displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '级别',
  `member_name` varchar(50) DEFAULT NULL COMMENT '等级名称',
  `member_turnover` decimal(10,2) NOT NULL DEFAULT '0' COMMENT '所需交易额',
  `member_motercount` int(10) NOT NULL DEFAULT '0' COMMENT '所需成交单数',
  `member_commission` int(3) NOT NULL DEFAULT '0' COMMENT '享受折扣率,百分比',
  `promoterstate` tinyint(1) DEFAULT '0' COMMENT '加入此会员需要订单的状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_wwx_fxxt_phb_medal`;
";

pdo_run($sql);

if(!pdo_fieldexists('wwx_fxxt_order', 'zhifutime')) {
	pdo_query("ALTER TABLE ".tablename('wwx_fxxt_order')." ADD COLUMN `zhifutime` int(10) DEFAULT '0' COMMENT '订单付款时间';");
}

if(!pdo_fieldexists('wwx_fxxt_order', 'ordermessage')) {
	pdo_query("ALTER TABLE ".tablename('wwx_fxxt_order')." ADD COLUMN `ordermessage` tinyint(1) NOT NULL DEFAULT '0' COMMENT '订单消息状态,0未发送,1已发送';");
}

if(!pdo_fieldexists('users', 'collection')) {
	pdo_query("ALTER TABLE ".tablename('users')." ADD COLUMN `collection` int(11) unsigned DEFAULT '5' COMMENT '采集点数';");
}

if(!pdo_fieldexists('wwx_fxxt_rules', 'promoterstate')) {
	pdo_query("ALTER TABLE ".tablename('wwx_fxxt_rules')." ADD COLUMN `promoterstate` int(10) NOT NULL DEFAULT '0' COMMENT '成为代理需要订单的状态';");
}

if(!pdo_fieldexists('wwx_fxxt_rules', 'autocanceltime')) {
	pdo_query("ALTER TABLE ".tablename('wwx_fxxt_rules')." ADD COLUMN `autocanceltime` int(10) NOT NULL DEFAULT '0' COMMENT '自动取消订单检查';");
}

if(!pdo_fieldexists('wwx_fxxt_printer', 'expressdaxiao')) {
	pdo_query("ALTER TABLE ".tablename('wwx_fxxt_printer')." ADD COLUMN `expressdaxiao` varchar(50) DEFAULT '12' COMMENT '字体大小';");
}

if(!pdo_fieldexists('wwx_fxxt_printer', 'expressziti')) {
	pdo_query("ALTER TABLE ".tablename('wwx_fxxt_printer')." ADD COLUMN `expressziti` varchar(50) DEFAULT '宋体' COMMENT '字体样式';");
}

if(!pdo_fieldexists('wwx_fxxt_member', 'usergrade')) {
	pdo_query("ALTER TABLE ".tablename('wwx_fxxt_member')." ADD COLUMN `usergrade` tinyint(3) DEFAULT '0' COMMENT '会员等级';");
}

if(!pdo_fieldexists('wwx_fxxt_member', 'usergradeauto')) {
	pdo_query("ALTER TABLE ".tablename('wwx_fxxt_member')." ADD COLUMN `usergradeauto` tinyint(1) DEFAULT '0' COMMENT '是否允许会员自动升级，0为自动升级，1为手动调整。';");
}

if(!pdo_fieldexists('wwx_fxxt_member', 'flaggrade')) {
	pdo_query("ALTER TABLE ".tablename('wwx_fxxt_member')." ADD COLUMN `flaggrade` tinyint(3) DEFAULT '0' COMMENT '代理等级';");
}

if(!pdo_fieldexists('wwx_fxxt_member', 'flaggradeauto')) {
	pdo_query("ALTER TABLE ".tablename('wwx_fxxt_member')." ADD COLUMN `flaggradeauto` tinyint(1) DEFAULT '0' COMMENT '是否允许代理自动升级，0为自动升级，1为手动调整。';");
}

if(!pdo_fieldexists('wwx_fxxt_member', 'flagcount')) {
	pdo_query("ALTER TABLE ".tablename('wwx_fxxt_member')." ADD COLUMN `flagcount` int(11) NOT NULL DEFAULT '0' COMMENT '下级代理总人数';");
}

if(!pdo_fieldexists('wwx_fxxt_member', 'nickname')) {
	pdo_query("ALTER TABLE ".tablename('wwx_fxxt_member')." ADD COLUMN `nickname` varchar(50) NOT NULL COMMENT '用户昵称';");
	$namelist = pdo_fetchall("select * from ".tablename('wwx_fxxt_member')." where realname<>''");
	foreach ($namelist as &$names){ 
		$names['realname'] = htmlspecialchars_decode($names['realname']);
		pdo_query("update ".tablename('wwx_fxxt_member')." set nickname = '{$names['realname']}' where id='{$names['id']}'");
	}
}

$wwx_fxxt = pdo_fetch("select `version` from ".tablename('modules')." where `name`='wwx_fxxt'");
if($wwx_fxxt['version']=='5.5.5')
{
	$wechatslist = pdo_fetchall("select * from ".tablename('account_wechats'));
	foreach ($wechatslist as $wechats)
	{
		$total =pdo_fetchcolumn('SELECT count(id) FROM '.tablename('wwx_fxxt_rules')." WHERE  uniacid = :uniacid " , array(':uniacid' => $wechats['uniacid']) );
		if($total>1)
		{
			$items =pdo_fetchall('SELECT * FROM '.tablename('wwx_fxxt_rules')." WHERE  uniacid = :uniacid order by id" , array(':uniacid' => $wechats['uniacid']) );
			$newitem='';
			foreach ($items as $item)
			{
				if(empty($newitem)||empty($newitem['id']))
				{
					$newitem=$item;
				}else {
					pdo_query("delete from  ".tablename('wwx_fxxt_rules')." WHERE uniacid = :uniacid and id!=:id" , array(':uniacid' => $wechats['uniacid'],':id' => $newitem['id']));
				}
			}
		}
	}
}