if (Admintype(3)) {
$sql = 'INSERT INTO `duihuan` SET `num_iid`="' . $num_iid . '", `title`="' . $title . '"
, `pic_url`="' . $pic_url . '", `detail_url`="' . $detail_url . '", `price`=' . $price . '
, `num`=' . $num . ',`category_id`=' . $categoryId . ', `left_num`=' . $num . ', `description`="' . $description . '", `end_time`="' . $end_time . '"
, `freight_payer`="' . $freight_payer . '", `nick`="' . $nick . '"
, `begin_time`="' . $begin_time . '",`youhui_link`="' . $youhui_link . '", `sid`=' . $sid . ', `create_user_id`=' . $create_user_id . ', `Taoortmall`=' . $Taoortmall . ', `jifen`=' . $jifen . ', `xianshi`=' . $xianshi . ',`gift_type`=1';
} else {
$sql = 'INSERT INTO `duihuan` SET `num_iid`="' . $num_iid . '", `title`="' . $title . '"
, `pic_url`="' . $pic_url . '", `detail_url`="' . $detail_url . '", `price`=' . $price . '
, `num`=' . $num . ',`category_id`=' . $categoryId . ', `left_num`=' . $num . ', `description`="' . $description . '", `end_time`="' . $end_time . '"
, `freight_payer`="' . $freight_payer . '", `nick`="' . $nick . '"
, `begin_time`="' . $begin_time . '",`youhui_link`="' . $youhui_link . '", `sid`=' . $sid . ', `create_user_id`=' . $create_user_id . ', `Taoortmall`=' . $Taoortmall . ', `jifen`=' . $jifen . ',`gift_type`=1';
}
$count = $pdo->exec($sql);
if ($count > 0) {
Useroperatelog($sql, $_SESSION['shadminid'], $_SESSION['shadmin'], 'duihuan', 0);
$createMessage = "新增成功";
} else {
$createMessage = "添加失败";
}
} else {
if (!rRuleUrl($detail_url)) {
$createMessage .= '商品链接url填写不规范，带http://模式<br>';
} elseif (!rRuleNum($num_iid)) {
$createMessage .= '商品id填写不规范，数字模式<br>';
} elseif (!rRulePrice($price)) {
$createMessage .= '商品价格填写不规范，小数模式：10.00<br>';
} elseif (!rRulePrice($coupon_price)) {
$createMessage .= '促销价格填写不规范，小数模式：10.00<br>';
}
}
if (Admintype(3)) {
$sql = 'INSERT INTO `gift` SET `num_iid`="' . $num_iid . '", `title`="' . $title . '"
, `pic_url`="' . $pic_url . '", `detail_url`="' . $detail_url . '", `price`=' . $price . '
, `num`=' . $num . ',`category_id`=' . $categoryId . ', `left_num`=' . $num . ', `description`="' . $description . '", `end_time`="' . $end_time . '"
, `freight_payer`="' . $freight_payer . '", `nick`="' . $nick . '"
, `begin_time`="' . $begin_time . '",`youhui_link`="' . $youhui_link . '", `sid`=' . $sid . ', `HongBao1`=' . $HongBao1 . ', `HongBao2`=' . $HongBao2 . ', `HongBao3`=' . $HongBao3 . ', `create_user_id`=' . $create_user_id . ', `Taoortmall`=' . $Taoortmall . ', `xianshi`=' . $xianshi . ',`gift_type`=1';
} else {
$sql = 'INSERT INTO `gift` SET `num_iid`="' . $num_iid . '", `title`="' . $title . '"
, `pic_url`="' . $pic_url . '", `detail_url`="' . $detail_url . '", `price`=' . $price . '
, `num`=' . $num . ',`category_id`=' . $categoryId . ', `left_num`=' . $num . ', `description`="' . $description . '", `end_time`="' . $end_time . '"
, `freight_payer`="' . $freight_payer . '", `nick`="' . $nick . '"
, `begin_time`="' . $begin_time . '",`youhui_link`="' . $youhui_link . '", `sid`=' . $sid . ', `HongBao1`=' . $HongBao1 . ', `HongBao2`=' . $HongBao2 . ', `HongBao3`=' . $HongBao3 . ', `create_user_id`=' . $create_user_id . ', `Taoortmall`=' . $Taoortmall . ',`gift_type`=1';
}
$count = $pdo->exec($sql);
if ($count > 0) {
Useroperatelog($sql, $_SESSION['shadminid'], $_SESSION['shadmin'], 'gift', 0);
$createMessage = "新增成功";
} else {
$createMessage = "添加失败";
}
} else {
if (!rRuleUrl($detail_url)) {
$createMessage .= '商品链接url填写不规范，带http://模式<br>';
} elseif (!rRuleNum($num_iid)) {
$createMessage .= '商品id填写不规范，数字模式<br>';
} elseif (!rRulePrice($price)) {
$createMessage .= '商品价格填写不规范，小数模式：10.00<br>';
} elseif (!rRulePrice($coupon_price)) {
$createMessage .= '促销价格填写不规范，小数模式：10.00<br>';
}
}
function Zbkdel($table, $where = null)
{
$sql = "delete from {$table} " . (empty($where) ? ';' : "where {$where}" . ';');
mysql_query($sql);
if (mysql_affected_rows() > 0) {
if ($_SESSION['shadmin'] == "") {
Useroperatelog($sql, $_SESSION['usidse'], $_SESSION['usnamese'], $table, 0);
} else {
Useroperatelog($sql, $_SESSION['shadminid'], $_SESSION['shadmin'], $table, 0);
}
return true;
} else {
return false;
}
}
$promote_id = $_POST['promote_id'];
$pindao_id = $_POST['pindao_id'];
$category_id = $_POST['category_id'];
$remai_id = intval($_POST["remai_id"]);
$miaosha_id = intval($_POST["miaosha_id"]);
$dian_id = intval($_POST["dian_id"]);
$num = $_POST['num'];
$nick = $_POST['nick'];
$description = reditnmagic($_POST['description']);
$shiyongtype = $_POST['shiyongtype'];
$create_user_id = intval($_POST['create_user_id']);
$xianshi = intval($_POST['xianshi']);
$jifen = trim($_POST['jifen']);
$diwen = reditnmagic($_POST['diwen']);
if ($detail_url == "" || $title == "" || $pic_url == "" || $price == "" || $coupon_price == "" || $create_user_id == "") {
$updateMessage = "请把商品信息填写完整！！";
} else {
if (Admintype(3)) {
$sql = 'UPDATE `shiyong` SET `freight_payer`="' . $freight_payer . '", `detail_url`="' . $detail_url . '", `title`="' . $title . '", `pic_url`="' . $pic_url . '", `jifen`="' . $jifen . '", `price`="' . $price . '", `hs_price`="' . $hs_price . '", `coupon_price`="' . $coupon_price . '",`hongbao`="' . $hongbao . '",`xiadanfangshi`="' . $xiadanfangshi . '",`guanjianci`="' . $guanjianci . '",`kuaidi`="' . $kuaidi . '",`shuxing`="' . $shuxing . '", `begin_time`="' . $begin_time . '", `end_time`="' . $end_time . '", `promote_id`="' . $promote_id . '", `category_id`="' . $category_id . '", `create_user_id`="' . $create_user_id . '", `xianshi`="' . $xianshi . '", `num`="' . $num . '", `pindao_id`="' . $pindao_id . '", `remai_id`="' . $remai_id . '", `miaosha_id`="' . $miaosha_id . '", `shiyongtype`="' . $shiyongtype . '", `dian_id`="' . $dian_id . '", `description`="' . $description . '", `diwen`="' . $diwen . '" WHERE `id`="' . $id . '"';
} else {
$sql = 'UPDATE `shiyong` SET `freight_payer`="' . $freight_payer . '", `detail_url`="' . $detail_url . '", `title`="' . $title . '", `pic_url`="' . $pic_url . '", `jifen`="' . $jifen . '", `price`="' . $price . '", `begin_time`="' . $begin_time . '", `end_time`="' . $end_time . '", `promote_id`="' . $promote_id . '", `category_id`="' . $category_id . '", `pindao_id`="' . $pindao_id . '", `remai_id`="' . $remai_id . '", `miaosha_id`="' . $miaosha_id . '", `shiyongtype`="' . $shiyongtype . '", `dian_id`="' . $dian_id . '", `description`="' . $description . '", `diwen`="' . $diwen . '" WHERE `id`="' . $id . '"';
}
$result = $pdo->exec($sql);
if ($result > 0) {
Useroperatelog($sql, $_SESSION['shadminid'], $_SESSION['shadmin'], 'shiyong', $id);
$updateMessage = "修改成功";
} else {
$updateMessage = "修改失败";
}
}
}
<?php
include dirname(__FILE__) . '../../../../include/session.php';
include dirname(__FILE__) . '../../../../include/admincommon.inc.php';
$data = array('er' => 0, 'msg' => '数据审核信息初始化');
$sheet = $_POST['sheet'];
$id = $_POST["entityId"];
$fangfa = $_POST["fangfa"];
if ($fangfa > 2) {
if (Admintype(3)) {
$sql = 'update `' . $sheet . '` set xianshi=' . $fangfa . ' where `id`=' . $id;
}
} else {
$sql = 'update `' . $sheet . '` set xianshi=' . $fangfa . ' where `id`=' . $id;
}
$result = $pdo->exec($sql);
if ($result > 0) {
Useroperatelog($sql, $_SESSION['shadminid'], $_SESSION['shadmin'], $sheet, $id);
$data['id'] = $_POST["fangfa"];
$data['msg'] = "更新成功";
}
echo json_encode($data);
