function syn_deal($deal_id)
{
$deal_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "crowd where id = " . $deal_id);
if ($deal_info) {
$deal_info['comment_count'] = intval($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "crowd_comment where deal_id = " . $deal_info['id'] . " and log_id = 0"));
$deal_info['support_count'] = intval($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "crowd_support_log where deal_id = " . $deal_info['id']));
$deal_info['focus_count'] = intval($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "crowd_focus_log where deal_id = " . $deal_info['id']));
$deal_info['view_count'] = intval($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "crowd_visit_log where deal_id = " . $deal_info['id']));
$deal_info['support_amount'] = doubleval($GLOBALS['db']->getOne("select sum(price) from " . DB_PREFIX . "crowd_support_log where deal_id = " . $deal_info['id']));
$deal_info['delivery_fee_amount'] = doubleval($GLOBALS['db']->getOne("select sum(delivery_fee) from " . DB_PREFIX . "crowd_order where deal_id = " . $deal_info['id'] . " and order_status=3 "));
if ($deal_info['type'] == 0) {
$deal_info["virtual_num"] = $GLOBALS['db']->getOne("select sum(virtual_person) from " . DB_PREFIX . "crowd_item where deal_id=" . $deal_id);
$deal_info["virtual_price"] = $GLOBALS['db']->getOne("select sum(virtual_person*price) from " . DB_PREFIX . "crowd_item where deal_id=" . $deal_id);
if ($deal_info['support_amount'] + $deal_info["virtual_price"] >= $deal_info['limit_price']) {
$deal_info['is_success'] = 1;
} else {
$deal_info['is_success'] = 0;
}
} elseif ($deal_info['type'] == 1) {
}
if ($deal_info['pay_radio'] > 0) {
$deal_info['pay_amount'] = $deal_info['support_amount'] * (1 - $deal_info['pay_radio']) + $deal_info['delivery_fee_amount'];
} else {
$deal_info['pay_amount'] = $deal_info['support_amount'] * (1 - app_conf("PAY_RADIO")) + $deal_info['delivery_fee_amount'];
}
$deal_info['tags_match'] = "";
$deal_info['tags_match_row'] = "";
$GLOBALS['db']->autoExecute(DB_PREFIX . "crowd", $deal_info, $mode = 'UPDATE', "id=" . $deal_info['id'], $querymode = 'SILENT');
$tags_arr = preg_split("/[, ]/", $deal_info["tags"]);
foreach ($tags_arr as $tgs) {
if (trim($tgs) != "") {
insert_match_item(trim($tgs), "crowd", $deal_info['id'], "tags_match");
}
}
$name_arr = div_str($deal_info['name']);
foreach ($name_arr as $name_item) {
if (trim($name_item) != "") {
insert_match_item(trim($name_item), "crowd", $deal_info['id'], "name_match");
}
}
}
}
function review_supplier_location_match($location_id, $tags, $group_id)
{
$location = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier_location where id = " . $location_id);
if ($location) {
$location['tags_match'] = "";
$location['tags_match_row'] = "";
//标签
$tags_arr = explode(" ", $tags);
foreach ($tags_arr as $tgs) {
//同步 supplier_tag 表
$tag_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier_tag where tag_name = '" . trim($tgs) . "' and supplier_location_id = " . $location_id . " and group_id = " . $group_id);
if ($tag_data) {
$tag_data['total_count'] = intval($tag_data['total_count']) + 1;
$GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_tag", $tag_data, "UPDATE", "tag_name = '" . trim($tgs) . "' and supplier_location_id = " . $location_id . " and group_id = " . $group_id);
} else {
$tag_data['tag_name'] = trim($tgs);
$tag_data['supplier_location_id'] = $location_id;
$tag_data['group_id'] = $group_id;
$tag_data['total_count'] = 1;
$GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_tag", $tag_data, "INSERT");
}
insert_match_item(trim($tgs), "supplier_location", $location_id, "tags_match");
}
}
}
function syn_deal_match($deal_id)
{
$deal = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "deal where id = " . $deal_id);
if ($deal) {
$deal['name_match'] = "";
$deal['name_match_row'] = "";
$deal['deal_cate_match'] = "";
$deal['deal_cate_match_row'] = "";
$deal['type_match'] = "";
$deal['type_match_row'] = "";
$deal['tag_match'] = "";
$deal['tag_match_row'] = "";
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal", $deal, $mode = 'UPDATE', "id=" . $deal_id, $querymode = 'SILENT');
//同步名称
$name_arr = div_str(trim($deal['name']));
foreach ($name_arr as $name_item) {
insert_match_item($name_item, "deal", $deal_id, "name_match");
}
//分类类别
$deal_cate = array();
get_all_parent_id(intval($deal['cate_id']), DB_PREFIX . "deal_cate", $deal_cate);
if (count($deal_cate) > 0) {
$deal_cates = $GLOBALS['db']->getAll("select name from " . DB_PREFIX . "deal_cate where id in (" . implode(",", $deal_cate) . ")");
foreach ($deal_cates as $row) {
insert_match_item(trim($row['name']), "deal", $deal_id, "deal_cate_match");
}
}
$goods_cate = array();
get_all_parent_id(intval($deal['type_id']), DB_PREFIX . "deal_loan_type", $goods_cate);
if (count($goods_cate) > 0) {
$goods_cates = $GLOBALS['db']->getAll("select name from " . DB_PREFIX . "deal_loan_type where id in (" . implode(",", $goods_cate) . ")");
foreach ($goods_cates as $row) {
insert_match_item(trim($row['name']), "deal", $deal_id, "type_match");
}
}
}
}
function update()
{
//B('FilterString');
$name = $this->getActionName();
$model = D($name);
if (false === ($data = $model->create())) {
$this->error($model->getError());
}
$id = $data[$model->getPk()];
if ($data['reply_content'] != "" && $data['reply_time'] == "") {
$data['reply_time'] = NOW_TIME;
}
// 更新数据
$list = $model->save($data);
$dp = $model->getById($id);
if (false !== $list) {
//成功提示
$group_points = $_REQUEST['group_point'];
foreach ($group_points as $group_id => $point) {
$model->query("update " . DB_PREFIX . "supplier_location_dp_point_result set point = " . $point . " where group_id = " . $group_id . " and dp_id = " . $id . " and supplier_location_id = " . $dp['supplier_location_id']);
M()->query("update " . DB_PREFIX . "deal_dp_point_result set point = " . $point . " where group_id = " . $group_id . " and dp_id = " . $id . " and deal_id = " . $dp['deal_id']);
M()->query("update " . DB_PREFIX . "youhui_dp_point_result set point = " . $point . " where group_id = " . $group_id . " and dp_id = " . $id . " and youhui_id = " . $dp['youhui_id']);
M()->query("update " . DB_PREFIX . "event_dp_point_result set point = " . $point . " where group_id = " . $group_id . " and dp_id = " . $id . " and event_id = " . $dp['event_id']);
}
$group_tags = $_REQUEST['group_tag'];
M()->query("update " . DB_PREFIX . "supplier_location_dp set tags_match = '',tags_match_row='' where id = " . $id);
foreach ($group_tags as $group_id => $tags) {
$model->query("update " . DB_PREFIX . "supplier_location_dp_tag_result set tags = '" . $tags . "' where group_id = " . $group_id . " and dp_id = " . $id . " and supplier_location_id = " . $dp['supplier_location_id']);
M()->query("update " . DB_PREFIX . "deal_dp_tag_result set tags = '" . $tags . "' where group_id = " . $group_id . " and dp_id = " . $id . " and deal_id = " . $dp['deal_id']);
M()->query("update " . DB_PREFIX . "youhui_dp_tag_result set tags = '" . $tags . "' where group_id = " . $group_id . " and dp_id = " . $id . " and youhui_id = " . $dp['youhui_id']);
M()->query("update " . DB_PREFIX . "event_dp_tag_result set tags = '" . $tags . "' where group_id = " . $group_id . " and dp_id = " . $id . " and event_id = " . $dp['event_id']);
insert_match_item($tags, "supplier_location_dp", $id, "tags_match");
//更新点评的索引
}
$count = M("SupplierLocationDpReply")->where("dp_id=" . $id)->count();
$model->where("id=" . $id)->setField("reply_count", $count);
$supplier_info['id'] = $dp['supplier_location_id'];
syn_supplier_locationcount($supplier_info);
save_log($dp . L("UPDATE_SUCCESS"), 1);
$this->assign('jumpUrl', Cookie::get('_currentUrl_'));
$this->success(L('UPDATE_SUCCESS'));
} else {
//错误提示
$dbErr = M()->getDbError();
save_log($dp . L("UPDATE_FAILED") . $dbErr, 0);
$this->error(L('EDIT_ERROR'));
}
}
