, `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>';
}
}
} else {
$createMessage = "同一礼品，在同一天出现开始！";
}
}
}
$price = $goodsItem->price;
//商品原价格
$freight_payer = $goodsItem->freight_payer;
//商品原价格
$coupon_price = $_POST['coupon_price']["{$num_iid}"];
$category_id = intval($_POST["cat_id"]);
$create_time = time();
$begin_time = strtotime($begin_date);
$end_time = $begin_time + 86400 * $days;
$pindaoId = intval($_POST['pin_id']);
$sql = 'SELECT * FROM `goods` WHERE `num_iid`="' . $num_iid . '" OR `title`="' . $title . '"';
$rs = $pdo->query($sql);
$row = $rs->fetchAll();
//取得所有记录
if (count($row) == 0) {
if (rRuleUrl($detail_url) && rRuleNum($num_iid) && rRulePrice($price) && rRulePrice($coupon_price)) {
$sql = 'INSERT INTO `goods` SET `num_iid`="' . $num_iid . '", `title`="' . $title . '", `pic_url`="' . $pic_url . '", `detail_url`="' . $detail_url . '", `price`="' . $price . '", `coupon_price`="' . $coupon_price . '", `num`="' . $num . '", `create_time`="' . $create_time . '", `category_id`="' . $category_id . '", `end_time`="' . $end_time . '", `freight_payer`="' . $freight_payer . '", `nick`="' . $nick . '", `begin_time`="' . $begin_time . '", `pindao_id`="' . $pindao_id . '"';
$count = $pdo->exec($sql);
if ($count > 0) {
$createMessage = "新增成功";
} else {
$createMessage = $sql . "添加失败！请检查sql语句！";
}
} else {
$createMessage = '数据规则不规范！例如链接地址，商品iid，价格信息不符合正常规范！';
}
}
}
}
}
}
