/** * 根据仓库id获取仓库对应的地址 * @param int $stockid 仓库id * 此方法可以加缓存处理 */ function get_stock_info($stockid) { global $db, $ecs; $sql = "select parent_id from " . $ecs->table('store_main') . " where store_id=" . $stockid; $parentid = $db->getOne($sql); //获取主虚拟仓库id if ($parentid > 0) { //$where = ''; $address = cookie_to_str(); return get_address_string($address, $parentid); /* foreach($address as $k=>$v){ $where.=" and ".$k."=".$v; } $sql = "select count(rec_id) from ".$ecs->table('store_shipping_region')." where store_id=".$parentid.$where; $result = $db->getOne($sql); if($result>0){ return $result; }*/ } return false; }
<?php function get_address_by_id($id) { switch ($id) { case 1: return array('first' => 'Иван', 'last' => 'Иванов', 'street' => 'ул. Ленина д. 123', 'city' => 'г. Зеленоград', 'state' => 'Московская обл.', 'zip' => '855384'); case 2: return array('first' => 'Владимир', 'last' => 'Петров', 'street' => 'ул. Октябрьская д. 12', 'city' => 'г. Сочи', 'state' => 'Краснодарский край', 'zip' => '045283'); } } function get_address_string($id) { $a = get_address_by_id($id); extract($a); return "{$first} {$last}\n{$street}\n{$city}, {$state} {$zip}"; } function screener($in) { return Trim(htmlspecialchars($in)); } if (isset($_REQUEST['id']) && null != ($_REQUEST['id'] = screener($_REQUEST['id']))) { $id = $_REQUEST['id']; } echo get_address_string($id);