, `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,价格信息不符合正常规范!'; } } } } } }