$smarty->assign('region', $region);
$sql = "select a.district_id, a.district_name,a.province,a.city,a.county,a.sort,a.is_show, b.region_name as city_name, c.region_name as county_name from " . $GLOBALS['ecs']->table('virtual_goods_district') . " as a left join " . $GLOBALS['ecs']->table('region') . " as b on b.region_id = a.city" . " left join " . $GLOBALS['ecs']->table('region') . " as c on c.region_id = a.county where district_id = {$district_id}";
$district = $GLOBALS['db']->getRow($sql);
$smarty->assign('district', $district);
$smarty->assign('district_id', $district_id);
$smarty->display('virtual_district_info.htm');
}
/* 添加商圈模板赋值 */
if ($_REQUEST['act'] == 'insert_district') {
$district_id = empty($_REQUEST['district_id']) ? '' : intval($_REQUEST['district_id']);
$province = empty($_REQUEST['add_province']) ? '' : intval($_REQUEST['add_province']);
$city = empty($_REQUEST['add_city']) ? '' : intval($_REQUEST['add_city']);
$county = empty($_REQUEST['add_county']) ? '' : intval($_REQUEST['add_county']);
$is_show = empty($_REQUEST['is_show']) ? '' : intval($_REQUEST['is_show']);
$district_name = empty($_REQUEST['district_name']) ? '' : trim($_REQUEST['district_name']);
$sort = empty($_REQUEST['sort']) ? '1' : inval($_REQUEST['$sort']);
if ($district_id == '') {
$sql = "INSERT INTO " . $GLOBALS['ecs']->table('virtual_goods_district') . " (district_name, province, city,county,sort,is_show) VALUES ('{$district_name}','{$province}','{$city}','{$county}','{$sort}','{$is_show}') ";
} else {
$sql = "UPDATE " . $GLOBALS['ecs']->table('virtual_goods_district') . " set district_name = '{$district_name}', province = '{$province}',city ='{$city}',county='{$county}', sort='{$sort}',is_show='{$is_show}' where district_id = {$district_id}";
}
$GLOBALS['db']->query($sql);
if ($GLOBALS['db']->errno() == 0) {
$link[0] = array('text' => '继续添加新商圈', 'href' => 'virtual_goods.php?act=add_district');
$link[1] = array('text' => '返回商圈列表', 'href' => 'virtual_goods.php?act=district');
sys_msg('恭喜你,商圈添加成功', 0, $link);
} else {
make_json_error($GLOBALS['db']->errorMsg());
}
}
/* 获取区域列表 */
public function doWebDispatch()
{
global $_W, $_GPC;
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
if ($operation == 'display') {
$list = pdo_fetchall("SELECT * FROM " . tablename('hx_zhongchou_dispatch') . " WHERE weid = '{$_W['uniacid']}' ORDER BY displayorder DESC");
} elseif ($operation == 'post') {
$id = intval($_GPC['id']);
if (checksubmit('submit')) {
$data = array('weid' => $_W['uniacid'], 'displayorder' => intval($_GPC['dispatch_name']), 'dispatchtype' => intval($_GPC['dispatchtype']), 'dispatchname' => $_GPC['dispatchname'], 'express' => $_GPC['express'], 'firstprice' => $_GPC['firstprice'], 'firstweight' => $_GPC['firstweight'], 'secondprice' => $_GPC['secondprice'], 'secondweight' => $_GPC['secondweight'], 'description' => $_GPC['description'], 'enabled' => inval($_GPC['enabled']));
if (!empty($id)) {
pdo_update('hx_zhongchou_dispatch', $data, array('id' => $id));
} else {
pdo_insert('hx_zhongchou_dispatch', $data);
$id = pdo_insertid();
}
message('更新配送方式成功！', $this->createWebUrl('dispatch', array('op' => 'display')), 'success');
}
//修改
$dispatch = pdo_fetch("SELECT * FROM " . tablename('hx_zhongchou_dispatch') . " WHERE id = '{$id}' and weid = '{$_W['uniacid']}'");
$express = pdo_fetchall("select * from " . tablename('hx_zhongchou_express') . " WHERE weid = '{$_W['uniacid']}' ORDER BY displayorder DESC");
} elseif ($operation == 'delete') {
$id = intval($_GPC['id']);
$dispatch = pdo_fetch("SELECT id FROM " . tablename('hx_zhongchou_dispatch') . " WHERE id = '{$id}' AND weid=" . $_W['uniacid'] . "");
if (empty($dispatch)) {
message('抱歉，配送方式不存在或是已经被删除！', $this->createWebUrl('dispatch', array('op' => 'display')), 'error');
}
pdo_delete('hx_zhongchou_dispatch', array('id' => $id));
message('配送方式删除成功！', $this->createWebUrl('dispatch', array('op' => 'display')), 'success');
} else {
message('请求方式不存在');
}
include $this->template('dispatch', TEMPLATE_INCLUDEPATH, true);
}
/**
* Finds whether a variable $value is less than $number
*
* @param mixed $value
* @param int $number
* @return bool
*/
public static function isLess($value, $number)
{
return inval($value) < intval($number);
}
/**
*
*/
public function hasLock($name)
{
$r = $this->selectOne("SELECT IS_FREE_LOCK('lck_{$name}', 10) AS r", 'r');
return !inval($r);
}
/**
* Parse un fichier de configuration
* @exception Minz_PermissionDeniedException si le CONF_PATH_NAME n'est pas accessible
* @exception Minz_BadConfigurationException si CONF_PATH_NAME mal formaté
*/
private static function parseFile()
{
$ini_array = (include DATA_PATH . self::CONF_PATH_NAME);
if (!is_array($ini_array)) {
throw new Minz_PermissionDeniedException(DATA_PATH . self::CONF_PATH_NAME, Minz_Exception::ERROR);
}
// [general] est obligatoire
if (!isset($ini_array['general'])) {
throw new Minz_BadConfigurationException('[general]', Minz_Exception::ERROR);
}
$general = $ini_array['general'];
// salt est obligatoire
if (!isset($general['salt'])) {
if (isset($general['sel_application'])) {
//v0.6
$general['salt'] = $general['sel_application'];
} else {
throw new Minz_BadConfigurationException('salt', Minz_Exception::ERROR);
}
}
self::$salt = $general['salt'];
if (isset($general['environment'])) {
switch ($general['environment']) {
case 'silent':
self::$environment = Minz_Configuration::SILENT;
break;
case 'development':
self::$environment = Minz_Configuration::DEVELOPMENT;
break;
case 'production':
self::$environment = Minz_Configuration::PRODUCTION;
break;
default:
if ($general['environment'] >= 0 && $general['environment'] <= 2) {
// fallback 0.7-beta
self::$environment = $general['environment'];
} else {
throw new Minz_BadConfigurationException('environment', Minz_Exception::ERROR);
}
}
}
if (isset($general['base_url'])) {
self::$base_url = $general['base_url'];
}
if (isset($general['use_url_rewriting'])) {
self::$use_url_rewriting = $general['use_url_rewriting'];
}
if (isset($general['title'])) {
self::$title = $general['title'];
}
if (isset($general['language'])) {
self::$language = $general['language'];
}
if (isset($general['cache_enabled'])) {
self::$cache_enabled = $general['cache_enabled'];
if (CACHE_PATH === false && self::$cache_enabled) {
throw new FileNotExistException('CACHE_PATH', Minz_Exception::ERROR);
}
}
if (isset($general['delay_cache'])) {
self::$delay_cache = inval($general['delay_cache']);
}
if (isset($general['default_user'])) {
self::$default_user = $general['default_user'];
}
if (isset($general['auth_type'])) {
self::_authType($general['auth_type']);
}
if (isset($general['allow_anonymous'])) {
self::$allow_anonymous = (bool) $general['allow_anonymous'] && $general['allow_anonymous'] !== 'no';
}
if (isset($general['allow_anonymous_refresh'])) {
self::$allow_anonymous_refresh = (bool) $general['allow_anonymous_refresh'] && $general['allow_anonymous_refresh'] !== 'no';
}
// Base de données
if (isset($ini_array['db'])) {
$db = $ini_array['db'];
if (empty($db['host'])) {
throw new Minz_BadConfigurationException('host', Minz_Exception::ERROR);
}
if (empty($db['user'])) {
throw new Minz_BadConfigurationException('user', Minz_Exception::ERROR);
}
if (!isset($db['password'])) {
throw new Minz_BadConfigurationException('password', Minz_Exception::ERROR);
}
if (empty($db['base'])) {
throw new Minz_BadConfigurationException('base', Minz_Exception::ERROR);
}
if (!empty($db['type'])) {
self::$db['type'] = $db['type'];
}
self::$db['host'] = $db['host'];
self::$db['user'] = $db['user'];
self::$db['password'] = $db['password'];
self::$db['base'] = $db['base'];
if (isset($db['prefix'])) {
self::$db['prefix'] = $db['prefix'];
}
}
}
/**
* Deletes a category
*
* @param - int $id The id
*/
function delete_category($id) {
$id = intval($id);
$sql = "SELECT id FROM ".Rsys :: getTable("item")." WHERE category_id=".inval($id)."";
$result = Database::query($sql);
if (Database::num_rows($result) == 0) {
$sql2 = "DELETE FROM ".Rsys :: getTable("category")." WHERE id =".intval($id)."";
Database::query($sql2);
return 0;
} else {
return Database::num_rows($result);
}
}
