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);