dlaccount.inc.php
1.62 KB
<?php
global $_GPC, $_W;
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
$storeid=$_COOKIE["storeid"];
$uid=$_COOKIE["uid"];
$GLOBALS['frames'] = $this->getNaveMenu($storeid, $action='start',$uid);
$cur_store = $this->getStoreById($storeid);
if ($operation == 'display') {
$strwhere = '';
$pindex = max(1, intval($_GPC['page']));
$psize = 10;
$list = pdo_fetchall("SELECT a.*,b.username AS username,b.status AS status,c.name as user_name FROM " . tablename('cjdc_account') . " a LEFT JOIN
" . tablename('users') . " b ON a.uid=b.uid left join".tablename('cjdc_store')."c on a.storeid=c.id WHERE a.weid = :weid and a.storeid=:storeid AND a.role=2 $strwhere ORDER BY id DESC LIMIT
" . ($pindex - 1) * $psize . ',' . $psize, array(':weid' =>$_W['uniacid'],':storeid'=>$storeid));
if (!empty($list)) {
$total = pdo_fetchcolumn('SELECT COUNT(1) FROM ' . tablename('cjdc_account') . " WHERE weid = :weid $strwhere", array(':weid' => $_W['uniacid']));
$pager = pagination($total, $pindex, $psize);
}
} else if ($operation == 'delete') {
$id = intval($_GPC['id']);
$item = pdo_fetch("SELECT * FROM " . tablename('cjdc_account') . " WHERE id = '$id'");
if (empty($item)) {
message('抱歉,不存在或是已经被删除!', $this->createWebUrl2('dlaccount', array('op' => 'display')), 'error');
}
pdo_delete('users', array('uid' => $item['uid']));
pdo_delete('cjdc_account', array('id' => $id, 'weid' => $_W['uniacid']));
message('删除成功!', $this->createWebUrl2('dlaccount', array('op' => 'display')), 'success');
}
include $this->template('web/dlaccount');