public function syn_data()
{
set_time_limit(0);
es_session::close();
//同步，supplier_location表, deal表, youhui表, event表 , supplier 表
//总数
$page = intval($_REQUEST['p']) == 0 ? 1 : intval($_REQUEST['p']);
if ($page == 1) {
syn_dealing();
}
$page_size = 5;
$location_total = M("SupplierLocation")->count();
$deal_total = M("Deal")->count();
$youhui_total = M("Youhui")->count();
$event_total = M("Event")->count();
$supplier_total = M("Supplier")->count();
$count = max(array($location_total, $deal_total, $youhui_total, $event_total, $supplier_total));
$limit = ($page - 1) * $page_size . "," . $page_size;
$location_list = M("SupplierLocation")->limit($limit)->findAll();
foreach ($location_list as $v) {
recount_supplier_data_count($v['id'], "tuan");
recount_supplier_data_count($v['id'], "youhui");
recount_supplier_data_count($v['id'], "daijin");
recount_supplier_data_count($v['id'], "event");
recount_supplier_data_count($v['id'], "shop");
syn_supplier_location_match($v['id']);
}
$supplier_list = M("Supplier")->limit($limit)->findAll();
foreach ($supplier_list as $v) {
syn_supplier_match($v['id']);
}
$deal_list = M("Deal")->limit($limit)->findAll();
foreach ($deal_list as $v) {
syn_deal_match($v['id']);
}
$youhui_list = M("Youhui")->limit($limit)->findAll();
foreach ($youhui_list as $v) {
syn_youhui_match($v['id']);
}
$event_list = M("Event")->limit($limit)->findAll();
foreach ($youhui_list as $v) {
syn_event_match($v['id']);
}
if ($page * $page_size >= $count) {
$this->assign("jumpUrl", U("Cache/index"));
$ajax = intval($_REQUEST['ajax']);
$data['status'] = 1;
$data['info'] = "<div style='line-height:50px; text-align:center; color:#f30;'>同步成功</div><div style='text-align:center;'><input type='button' onclick='\$.weeboxs.close();' class='button' value='关闭' /></div>";
header("Content-Type:text/html; charset=utf-8");
exit(json_encode($data));
} else {
$total_page = ceil($count / $page_size);
$data['status'] = 0;
$data['info'] = "共" . $total_page . "页，当前第" . $page . "页,等待更新下一页记录";
$data['url'] = U("Cache/syn_data", array("p" => $page + 1));
header("Content-Type:text/html; charset=utf-8");
exit(json_encode($data));
}
}
public function update()
{
B('FilterString');
$data = M(MODULE_NAME)->create();
$log_info = M(MODULE_NAME)->where("id=" . intval($data['id']))->getField("name");
//开始验证有效性
$this->assign("jumpUrl", u(MODULE_NAME . "/edit", array("id" => $data['id'])));
if (!check_empty($data['name'])) {
$this->error(L("LOCATION_NAME_EMPTY_TIP"));
}
if ($data['supplier_id'] == 0) {
$this->error(L("SUPPLIER_NOT_EXIST"));
}
// 更新数据
$list = M(MODULE_NAME)->save($data);
if (false !== $list) {
M("SupplierLocationAreaLink")->where("location_id=" . $data['id'])->delete();
$area_ids = $_REQUEST['area_id'];
foreach ($area_ids as $area_id) {
$area_data['area_id'] = $area_id;
$area_data['location_id'] = $data['id'];
M("SupplierLocationAreaLink")->add($area_data);
}
M("SupplierLocationBrandLink")->where("location_id=" . $data['id'])->delete();
$brand_ids = $_REQUEST['brand_id'];
foreach ($brand_ids as $brand_id) {
$brand_data['brand_id'] = $brand_id;
$brand_data['location_id'] = $data['id'];
M("SupplierLocationBrandLink")->add($brand_data);
}
M("DealCateTypeLocationLink")->where("location_id=" . $data['id'])->delete();
foreach ($_REQUEST['deal_cate_type_id'] as $type_id) {
$link_data = array();
$link_data['deal_cate_type_id'] = $type_id;
$link_data['location_id'] = $data['id'];
M("DealCateTypeLocationLink")->add($link_data);
}
M("SupplierTagGroupPreset")->where("supplier_location_id=" . $data['id'])->delete();
$group_ids = $_REQUEST['group_id'];
foreach ($group_ids as $gid => $preset) {
if (trim($preset) != '') {
$link['group_id'] = $gid;
$link['supplier_location_id'] = $data['id'];
$link['preset'] = trim($preset);
M("SupplierTagGroupPreset")->add($link);
}
}
$show_group_ids = $_REQUEST['show_group_id'];
$exist_tags_array = array("''");
foreach ($show_group_ids as $gid => $row) {
if (trim($row) != '') {
$show_tags_array = preg_split("[ |,]", $row);
foreach ($show_tags_array as $kk => $rr) {
$rs = explode("|", $rr);
$tag = trim($rs[0]);
$count = intval($rs[1]);
$exist_tags_array[] = "'" . $tag . "'";
$tag_rs = M("SupplierTag")->where("tag_name = '" . $tag . "' and supplier_location_id = " . $data['id'] . " and group_id = " . $gid)->find();
if ($tag_rs) {
$tag_rs['total_count'] = $count;
$GLOBALS['db']->query("update " . DB_PREFIX . "supplier_tag set total_count = " . $count . " where tag_name = '" . $tag . "' and supplier_location_id = " . $data['id'] . " and group_id = " . $gid);
} else {
if (trim($tag) != '') {
$tag_rs = array();
$tag_rs['tag_name'] = $tag;
$tag_rs['supplier_location_id'] = $data['id'];
$tag_rs['group_id'] = $gid;
$tag_rs['total_count'] = $count;
M("SupplierTag")->add($tag_rs);
}
}
}
}
}
$GLOBALS['db']->query("delete from " . DB_PREFIX . "supplier_tag where tag_name not in (" . implode(",", $exist_tags_array) . ") and supplier_location_id = " . $data['id']);
syn_supplier_location_match($data['id']);
clear_auto_cache("static_goods_info");
//成功提示
save_log($log_info . L("UPDATE_SUCCESS"), 1);
$this->success(L("UPDATE_SUCCESS"));
} else {
//错误提示
save_log($log_info . L("UPDATE_FAILED"), 0);
$this->error(L("UPDATE_FAILED"), 0, $log_info . L("UPDATE_FAILED"));
}
}
public function update()
{
B('FilterString');
$data = M("SupplierSubmit")->getById(intval($_REQUEST['id']));
if (!$data) {
$this->error("非法的数据");
}
//已有商家，只同步一份管理员
$user_info = M("User")->getById($data['user_id']);
$account = M("SupplierAccount")->where("account_name='" . $user_info['merchant_name'] . "'")->find();
$location_info = M("SupplierLocation")->getById($data['location_id']);
if ($account && $location_info) {
//已经绑定过商户
if ($account['supplier_id'] != $location_info['supplier_id']) {
$this->error("该会员已经是其他商户的管理员，请手动创建");
}
}
$cate_config = unserialize($data['cate_config']);
$data['deal_cate_id'] = $cate_config['deal_cate_id'];
$data['deal_cate_type_list'] = $cate_config['deal_cate_type_id'];
$data['area_list'] = unserialize($data['location_config']);
if ($data['location_id'] == 0) {
$supplier_id = intval($_REQUEST['supplier_id']);
if ($supplier_id == 0) {
//先创建商户
$supplier_info['name'] = $data['name'];
$supplier_info['bank_info'] = $data['h_bank_info'];
$supplier_info['bank_user'] = $data['h_bank_user'];
$supplier_info['bank_name'] = $data['h_bank_name'];
$supplier_info['preview'] = $data['h_supplier_logo'];
$supplier_id = M("Supplier")->add($supplier_info);
$location_info['is_main'] = 1;
}
$location_info['name'] = $data['name'];
$location_info['address'] = $data['address'];
$location_info['tel'] = $data['tel'];
$location_info['xpoint'] = $data['xpoint'];
$location_info['ypoint'] = $data['ypoint'];
$location_info['supplier_id'] = $supplier_id;
$location_info['open_time'] = $data['open_time'];
$location_info['city_id'] = $data['city_id'];
$location_info['deal_cate_id'] = $data['deal_cate_id'];
$location_info['preview'] = $data['h_supplier_image'];
$location_info['is_effect'] = 1;
$location_info['xpoint'] = !empty($data['xpoint']) ? $data['xpoint'] : '119.025595';
$location_info['ypoint'] = !empty($data['ypoint']) ? $data['ypoint'] : '33.596043';
$location_info['location'] = 'GeomFromText("POINT(' . $data['xpoint'] . ' ' . $data['ypoint'] . ')")';
$location_info['location_id'] = M("SupplierLocation")->add($location_info);
foreach ($data['deal_cate_type_list'] as $deal_cate_type_id) {
$link = array();
$link['location_id'] = $data['location_id'];
$link['deal_cate_type_id'] = $deal_cate_type_id;
M("DealCateTypeLocationLink")->add($link);
}
foreach ($data['area_list'] as $area_id) {
$link = array();
$link['location_id'] = $data['location_id'];
$link['area_id'] = $area_id;
M("SupplierLocationAreaLink")->add($link);
}
syn_supplier_location_match($data['location_id']);
}
if ($data['location_id'] > 0) {
if ($account) {
$id = $account['id'];
$link = array();
$link['account_id'] = $id;
$link['location_id'] = $data['location_id'];
$rs = M("SupplierAccountLocationLink")->add($link);
if ($rs) {
//认领成功，并同步营业执照
$location_info['biz_license'] = $data['h_license'];
$location_info['biz_other_license'] = $data['h_other_license'];
M("SupplierLocation")->save($location_info);
$this->assign("jumpUrl", u("SupplierLocation/edit", array("id" => $data['location_id'])));
M("SupplierSubmit")->where("id=" . intval($_REQUEST['id']))->setField("is_publish", 1);
save_log($data['name'] . "审核成功", 1);
$this->success("审核成功");
} else {
$this->error("该会员已经是该商户的管理员");
}
} else {
//会员未绑定商户，或绑定的不是同名商户管理员，创建一个商户管理员
$account['account_name'] = $user_info['user_name'];
$account['account_password'] = $user_info['user_pwd'];
$account['supplier_id'] = $location_info['supplier_id'];
$account['is_effect'] = 1;
$account['description'] = $data['h_faren'] . "电话：" . $data['h_tel'];
$account['update_time'] = get_gmtime();
$id = M("SupplierAccount")->add($account);
if ($id) {
//添加成功
$link = array();
$link['account_id'] = $id;
$link['location_id'] = $data['location_id'];
M("SupplierAccountLocationLink")->add($link);
//认领成功
$location_info['biz_license'] = $data['h_license'];
$location_info['biz_other_license'] = $data['h_other_license'];
M("SupplierLocation")->save($location_info);
$this->assign("jumpUrl", u("SupplierLocation/edit", array("id" => $data['location_id'])));
M("SupplierSubmit")->where("id=" . intval($_REQUEST['id']))->setField("is_publish", 1);
save_log($data['name'] . "审核成功", 1);
$user_info['is_merchant'] = 1;
$user_info['merchant_name'] = $account['account_name'];
M("User")->save($user_info);
$this->success("审核成功");
} else {
$account = M("SupplierAccount")->where("account_name='" . $user_info['user_name'] . "'")->find();
if ($account['supplier_id'] == $location_info['supplier_id']) {
$link = array();
$link['account_id'] = $account['id'];
$link['location_id'] = $data['location_id'];
M("SupplierAccountLocationLink")->add($link);
if (M()->getDbError() != '') {
$this->error("该会员已经认领了");
} else {
$location_info['biz_license'] = $data['h_license'];
$location_info['biz_other_license'] = $data['h_other_license'];
M("SupplierLocation")->save($location_info);
$this->assign("jumpUrl", u("SupplierLocation/edit", array("id" => $data['location_id'])));
M("SupplierSubmit")->where("id=" . intval($_REQUEST['id']))->setField("is_publish", 1);
save_log($data['name'] . "审核成功", 1);
$this->success("审核成功");
}
}
$this->error("该会员已有同名的商户管理员，请手动创建");
}
}
}
}
public function update()
{
B('FilterString');
$data = M("SupplierSubmit")->getById(intval($_REQUEST['id']));
if (!$data) {
$this->error("非法的数据");
}
$cate_config = unserialize($data['cate_config']);
$data['deal_cate_id'] = $cate_config['deal_cate_id'];
$data['deal_cate_type_list'] = $cate_config['deal_cate_type_id'];
$data['area_list'] = unserialize($data['location_config']);
if ($data['location_id'] == 0) {
$supplier_id = intval($_REQUEST['supplier_id']);
if ($supplier_id == 0) {
//先创建商户
$supplier_info['name'] = $data['name'];
$supplier_info['bank_info'] = $data['h_bank_info'];
$supplier_info['bank_user'] = $data['h_bank_user'];
$supplier_info['bank_name'] = $data['h_bank_name'];
$supplier_info['preview'] = $data['h_supplier_logo'];
//公司信息
$supplier_info['h_name'] = $data['h_name'];
$supplier_info['h_faren'] = $data['h_faren'];
$supplier_info['h_tel'] = $data['h_tel'];
$supplier_id = M("Supplier")->add($supplier_info);
$location_info['is_main'] = 1;
}
$location_info['name'] = $data['name'];
$location_info['address'] = $data['address'];
$location_info['tel'] = $data['tel'];
$location_info['xpoint'] = $data['xpoint'];
$location_info['ypoint'] = $data['ypoint'];
$location_info['supplier_id'] = $supplier_id;
$location_info['open_time'] = $data['open_time'];
$location_info['city_id'] = $data['city_id'];
$location_info['deal_cate_id'] = $data['deal_cate_id'];
$location_info['preview'] = $data['h_supplier_image'];
$location_info['biz_license'] = $data['h_license'];
$location_info['biz_other_license'] = $data['h_other_license'];
$location_info['is_effect'] = 1;
$data['location_id'] = M("SupplierLocation")->add($location_info);
foreach ($data['deal_cate_type_list'] as $deal_cate_type_id) {
$link = array();
$link['location_id'] = $data['location_id'];
$link['deal_cate_type_id'] = $deal_cate_type_id;
M("DealCateTypeLocationLink")->add($link);
}
foreach ($data['area_list'] as $area_id) {
$link = array();
$link['location_id'] = $data['location_id'];
$link['area_id'] = $area_id;
M("SupplierLocationAreaLink")->add($link);
}
syn_supplier_location_match($data['location_id']);
}
if ($data['location_id'] > 0) {
//会员未绑定商户，或绑定的不是同名商户管理员，创建一个商户管理员
$account['account_name'] = $data['account_name'];
$account['account_password'] = $data['account_password'];
$account['supplier_id'] = $location_info['supplier_id'];
$account['is_effect'] = 1;
$account['description'] = $data['h_name'] . " 法人：" . $data['h_faren'] . " 电话：" . $data['h_tel'];
$account['update_time'] = NOW_TIME;
$account['mobile'] = $data['account_mobile'];
$account['is_main'] = 1;
$account['allow_delivery'] = 1;
$account['allow_charge'] = 1;
$id = M("SupplierAccount")->add($account);
if ($id) {
//添加成功
$link = array();
$link['account_id'] = $id;
$link['location_id'] = $data['location_id'];
M("SupplierAccountLocationLink")->add($link);
//认领成功
$location_info['biz_license'] = $data['h_license'];
$location_info['biz_other_license'] = $data['h_other_license'];
M("SupplierLocation")->save($location_info);
$this->assign("jumpUrl", u("SupplierLocation/edit", array("id" => $data['location_id'])));
M("SupplierSubmit")->where("id=" . intval($_REQUEST['id']))->setField("is_publish", 1);
save_log($data['name'] . "审核成功", 1);
if ($data['user_id'] > 0) {
$user_info = M("User")->getById($data['user_id']);
$user_info['is_merchant'] = 1;
$user_info['merchant_name'] = $account['account_name'];
M("User")->save($user_info);
}
$this->success("审核成功");
} else {
$this->error("审核失败，请联系系统管理员");
}
}
}
public function update()
{
if (intval($_POST['id']) == 0) {
showErr($GLOBALS['lang']['ERROR_TITLE'], 0, url("biz", "profile"));
exit;
}
$id = intval($_POST['id']);
$s_account_info = es_session::get("account_info");
$location_ids = $s_account_info['location_ids'];
$info = $GLOBALS['db']->getRow(" SELECT * FROM " . DB_PREFIX . "supplier_location WHERE id = " . intval($id) . " and id in (" . implode(",", $s_account_info['location_ids']) . ")");
if (!$info) {
showErr("门店不存在或者没有编辑该门店的权限");
}
$data['preview'] = str_replace(get_domain() . APP_ROOT, ".", addslashes(htmlspecialchars(trim($_POST['preview']))));
$data['tags'] = addslashes(htmlspecialchars(trim($_POST['tags'])));
$data['address'] = addslashes(htmlspecialchars(trim($_POST['address'])));
$data['route'] = addslashes(htmlspecialchars(trim($_POST['route'])));
$data['tel'] = addslashes(htmlspecialchars(trim($_POST['tel'])));
$data['contact'] = addslashes(htmlspecialchars(trim($_POST['contact'])));
$data['open_time'] = addslashes(htmlspecialchars(trim($_POST['open_time'])));
$data['api_address'] = addslashes(htmlspecialchars(trim($_POST['api_address'])));
$data['xpoint'] = $_POST['xpoint'];
$data['ypoint'] = $_POST['ypoint'];
$data['sms_content'] = addslashes(htmlspecialchars(trim($_POST['sms_content'])));
$data['brief'] = addslashes(trim(replace_public($_POST['brief'])));
$data['brief'] = valid_tag($data['brief']);
$data['id'] = intval($_POST['id']);
$data['seo_title'] = addslashes(htmlspecialchars(trim($_POST['seo_title'])));
$data['seo_keyword'] = addslashes(htmlspecialchars(trim($_POST['seo_keyword'])));
$data['seo_description'] = addslashes(htmlspecialchars(trim($_POST['seo_description'])));
$rs = $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location", $data, "UPDATE", " id = " . intval($_POST['id']));
if ($rs) {
//更新统计
syn_supplier_locationcount($data);
syn_supplier_location_match($data['id']);
$cache_id = md5("store" . "view" . $data['id']);
$GLOBALS['tmpl']->clear_cache('store_view.html', $cache_id);
showSuccess($GLOBALS['lang']['SUPPLIER_MODIFY_SUCCESS'], 0, url("biz", "profile#modify", array("id" => intval($_POST['id']))));
}
}