Files
OMS/app/o2o/lib/regions/select.php
2026-01-04 19:08:31 +08:00

83 lines
2.8 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
<?php
/**
* Copyright 2012-2026 ShopeX (https://www.shopex.cn)
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
class o2o_regions_select
{
/**
* 通过p_region_id区域层级来得到地区的信息
* @params object app object
* @params string p_region_id
* @params array 参数数组 - depth
* @params string 当前激活的regions id
*/
public function get_area_select($p_region_id, $params, $selected_id=null)
{
$regionsObj = app::get('eccommon')->model('regions');
$params['depth'] = ($params['depth'] ? $params['depth'] : 1);
$html = '<select onchange="selectO2oArea(this,this.value,'.($params['depth']+1).')">';
$html.='<option value="_NULL_">请选择...</option>';
$where = '1';
if($p_region_id)
{
$where .= " AND b.p_region_id=" . $p_region_id;
}
$region_grade = 'region_' . $params['depth'];
$sql = "SELECT b.region_id, b.local_name, b.haschild FROM sdb_o2o_store_regions AS a
LEFT JOIN sdb_eccommon_regions AS b ON a.". $region_grade ."=b.region_id
WHERE ". $where ." GROUP BY a.". $region_grade ." ORDER BY a.". $region_grade ." ASC";
$rows = $regionsObj->db->select($sql);
if ($rows)
{
foreach ($rows as $item)
{
if ($item['region_grade']<=app::get('eccommon')->getConf('system.area_depth'))
{
$selected = $selected_id == $item['region_id']?'selected="selected"':'';
// 查找当前地区是否有子集
if ($item['haschild'] == 1)
{
$html.= '<option has_c="true" value="'.$item['region_id'].'" '.$selected.'>'.$item['local_name'].'</option>';
}
else
{
$html.= '<option value="'.$item['region_id'].'" '.$selected.'>'.$item['local_name'].'</option>';
}
}
else
{
$no = true;
}
}
$html.='</select>';
if($no) $html="";
return $html;
}
else
{
return false;
}
}
}