public function savePost()
{
foreach ($_POST as $key => $val) {
if ($key != "id") {
$sqlv[] = " {$key} = '" . sb_addslashes($val) . "'";
}
}
if (!$_POST["id"]) {
$sql = "INSERT INTO " . get_table("brands") . " SET " . implode(",", $sqlv);
} else {
$sql = "UPDATE " . get_table("brands") . " SET " . implode(",", $sqlv) . " WHERE id=" . $_POST["id"];
}
$rs = $this->mDb->execute($sql);
return $rs;
}
public function savePost()
{
foreach ($_POST as $key => $val) {
if (!in_array($key, array("id", "aid"))) {
$sqlv[] = " {$key} = '" . sb_addslashes($val) . "'";
}
}
if (!$_POST["id"]) {
$sql = "INSERT INTO " . get_table("asks") . " SET " . implode(",", $sqlv) . ",addtime='" . time() . "'";
} else {
$sql = "UPDATE " . get_table("asks") . " SET " . implode(",", $sqlv) . " WHERE id=" . $_POST["id"];
}
$rs = $this->mDb->execute($sql);
return $rs;
}
public function savePost()
{
if ($_POST["status"] == "1") {
}
$aid = $_POST["aid"];
unset($_POST["aid"]);
foreach ($_POST as $key => $val) {
if (!in_array($key, array("id", "place_traffic"))) {
$sqlv[] = " {$key} = '" . sb_addslashes($val) . "'";
}
}
if (!$_POST["id"]) {
//$sqlv[] = " createtime = '".time()."'";
$sql = "INSERT INTO " . get_table("events") . " SET " . implode(",", $sqlv);
} else {
$sql = "UPDATE " . get_table("events") . " SET " . implode(",", $sqlv) . " WHERE id=" . $_POST["id"];
}
$rs = $this->mDb->execute($sql);
if (!$_POST["id"]) {
$pid = $this->mDb->Insert_ID();
} else {
$pid = $_POST["id"];
}
if ($rs) {
$rs = $pid;
}
$this->updateAttachments($aid, $pid, "events");
return $rs;
}
private function createExpand($expand, $pid, $type)
{
$this->mDb->execute("DELETE FROM " . get_table("expands") . " WHERE pid={$pid} AND type='{$type}'");
if ($expand) {
foreach ($expand as $data) {
$sqlv = "";
$sqlv[] = " type = '{$type}'";
$sqlv[] = " pid = '{$pid}'";
foreach ($data as $key => $val) {
$sqlv[] = " {$key} = '" . sb_addslashes($val) . "'";
}
$sql = "INSERT INTO " . get_table("expands") . " SET " . implode(",", $sqlv);
$this->mDb->execute($sql);
}
}
}
public function savePost()
{
foreach ($_POST as $key => $val) {
if (!in_array($key, array("id", "aid"))) {
$sqlv[] = " {$key} = '" . sb_addslashes($val) . "'";
}
}
if (!$_POST["id"]) {
$sql = "INSERT INTO " . get_table("articles") . " SET " . implode(",", $sqlv) . ",addtime='" . time() . "'";
} else {
$sql = "UPDATE " . get_table("articles") . " SET " . implode(",", $sqlv) . " WHERE id=" . $_POST["id"];
}
$rs = $this->mDb->execute($sql);
if (!$_POST["id"] and $_POST["email"] != "888") {
if ($_POST["email"] == "999") {
$send = $this->Send_mail(999);
//发送全部
} else {
$send = $this->Send_mail($_POST["email"]);
//按班级发送
}
}
return $rs;
}
public function savePackagesSales()
{
foreach ($_POST as $key => $val) {
if (!in_array($key, array("id", "product_package"))) {
$sqlv[] = " {$key} = '" . sb_addslashes($val) . "'";
}
}
if (!$_POST["id"]) {
$sql = "INSERT INTO " . get_table("product_packages") . " SET " . implode(",", $sqlv);
} else {
$sql = "UPDATE " . get_table("product_packages") . " SET " . implode(",", $sqlv) . " WHERE id=" . $_POST["id"];
}
$rs = $this->mDb->execute($sql);
if (!$_POST["id"]) {
$ppid = $this->mDb->Insert_ID();
} else {
$ppid = $_POST["id"];
}
$sql = "DELETE FROM " . get_table("product_to_packages") . " WHERE ppid=" . $ppid;
$this->mDb->execute($sql);
foreach ($_POST["product_package"] as $val) {
$sql = "INSERT INTO " . get_table("product_to_packages") . " SET ppid='{$ppid}',pid='" . $val["pid"] . "',quantity='" . $val["quantity"] . "'";
$this->mDb->execute($sql);
}
return $rs;
}
