合肥市瑶海区税务局办税服务厅地址办公时间及联系电话
216132019-01-21 21:22 中国政务服务网
function getshangpin($params) {
extract($params);
if(empty($sid)) return null;
$db = _G('db');
global $_G;
$table_name = $_G['dns']['dbpre'] . 'subject';
$sids = array_map('intval', explode(',', $sid));
$select_fields = $select ? $select : 'sid,name,subname,thumb,catid,pid,reviews,avgsort,address,tel,description';
$sql = "SELECT {$select_fields} FROM `{$table_name}` WHERE sid IN (" . implode(',', $sids) . ") AND status = 1";
if($orderby) $sql .= " ORDER BY " . $orderby;
else $sql .= " ORDER BY FIELD(sid, " . implode(',', $sids) . ")";
$limit_rows = isset($rows) ? (int)$rows : 10;
$start = isset($start) ? (int)$start : 0;
$sql .= " LIMIT {$start}, {$limit_rows}";
$result = $db->query($sql);
if(!$result) return null;
$return = array();
while($row = $db->fetch_array($result)) $return[] = $row;
$db->free_result($result);
return !empty($return) ? $return : null;
}
function subject_hyrw($params) {
extract($params);
if(empty($catid) && empty($sid)) return null;
$db = _G('db');
global $_G;
$table_name = $_G['dns']['dbpre'] . 'subject';
$where = array("status = 1");
if(!empty($catid)) $where[] = "catid = " . (int)$catid;
if(!empty($sid)) $where[] = "sid IN (" . implode(',', array_map('intval', explode(',', $sid))) . ")";
if(!empty($city_id)) $where[] = "city_id = " . (int)$city_id;
$select_fields = $select ? $select : 'sid,name,subname,thumb,catid,pid,reviews,avgsort';
$sql = "SELECT {$select_fields} FROM `{$table_name}` WHERE " . implode(' AND ', $where);
if($orderby) $sql .= " ORDER BY " . $orderby;
else $sql .= " ORDER BY sid DESC";
$limit_rows = isset($rows) ? (int)$rows : 10;
$start = isset($start) ? (int)$start : 0;
$sql .= " LIMIT {$start}, {$limit_rows}";
$result = $db->query($sql);
if(!$result) return null;
$return = array();
while($row = $db->fetch_array($result)) $return[] = $row;
$db->free_result($result);
return !empty($return) ? $return : null;
}
function product_pic_li($params) {
extract($params);
if(empty($sid)) return null;
$db = _G('db');
global $_G;
$table_name = $_G['dns']['dbpre'] . 'subject_picture';
$sids = array_map('intval', explode(',', $sid));
$select_fields = $select ? $select : 'sid,pid,title,description,thumb,pictures,posttime';
$sql = "SELECT {$select_fields} FROM `{$table_name}` WHERE sid IN (" . implode(',', $sids) . ") AND status = 1";
if($orderby) $sql .= " ORDER BY " . $orderby;
else $sql .= " ORDER BY posttime DESC";
$limit_rows = isset($rows) ? (int)$rows : 10;
$start = isset($start) ? (int)$start : 0;
$sql .= " LIMIT {$start}, {$limit_rows}";
$result = $db->query($sql);
if(!$result) return null;
$return = array();
while($row = $db->fetch_array($result)) $return[] = $row;
$db->free_result($result);
return !empty($return) ? $return : null;
}
地址：合肥市瑶海区胜利路106号
电话：0551-64310030
办公时间：工作日9：00-17:00
主要职责：各项税收、非税收入业务办理（不含外贸企业出口退（免）税、车辆购置税、车船税、个人二手房交易税收业务）
地址：合肥市瑶海区芜湖路2号坝上街环球中心综合楼8楼西侧
电话：0551-65973599
办公时间：工作日9：00-17:00
主要职责：各项税收、非税收入业务办理（不含外贸企业出口退（免）税、车辆购置税、车船税、个人二手房交易税收业务）
合肥市税务局各（区）县办税服务厅办公地址时间及咨询电话
备注：综合厅是指办理单位纳税人各类依申请涉税业务的办税服务厅，专业厅是指专门办理个体工商户、车购税、不动产交易、出口退税等涉税业务的办税服务厅，以上信息由95商服网收集整理，转载请注明出处。
