//添加地址并使用
$name = $_REQUEST['name'];
$tel = $_REQUEST['tel'];
$province = $_REQUEST['province'];
$city = $_REQUEST['city'];
$country = $_REQUEST['country'];
$detail_address = $_REQUEST['detail_address'];
$time = date('Y-m-d H:i:s', time());
$Mysql = new MySqlHelper();
//检查是否已经存在默认地址；
$sqlcheck = "SELECT id FROM sh_store_address where userid={$userID} AND delstate='N' AND state='ON'";
$datacheck = $Mysql->FetchData($sqlcheck);
$flag = count($datacheck);
//如果存在默认地址，则设置为普通地址，如果不存在默认地址，则设置成默认地址。
if ($flag > 0) {
$state = 'OFF';
} else {
$state = 'ON';
}
$sqlinaddress = "INSERT INTO sh_store_address (userid,provinceid,cityid,countyid,detailaddress,createtime,tel,`name`,state) VALUES ({$userID},{$province},{$city},{$country},'{$detail_address}','{$time}','{$tel}','{$name}','{$state}')";
$row = $Mysql->ExecuteSql($sqlinaddress);
$sqlsearchid = "SELECT id FROM sh_store_address WHERE userid={$userID} ORDER BY createtime DESC LIMIT 1";
$datasearchid = $Mysql->FetchData($sqlsearchid);
if ($row > 0) {
echo json_encode(array("code" => "200", "mess" => $datasearchid[0][0]));
return;
} else {
echo json_encode(array("code" => "110", "mess" => '添加失败！'));
return;
}
}
$dataInfo = $Mysql->FetchData($sqlInfo);
if ($dataInfo[0]['state'] != 'ON') {
echo json_encode(array("code" => "110", "mess" => '该商品已经下架！'));
return;
}
if ($dataInfo[0]['dnum'] < $sdnum) {
echo json_encode(array("code" => "110", "mess" => '库存量不足！'));
return;
}
$price = $dataInfo[0]['dprice'];
$totalmoney = $price * $sdnum + $expressprice;
$time = date("Y-m-d H:i:s", time());
$Mysql->Query("BEGIN");
$sqlInToOrder = "INSERT INTO sh_store_order (userid,ordertime,paystate,deliverstate,orderstate,money,discountmoney,countmoney,realpay,paytype,remarks,address,phone,`name`,expressPrice,ordernum) SELECT {$userID},'{$time}','N', 'NOT','PRE',{$totalmoney},0,{$totalmoney},0,4,'{$remarks}',concat(ar2.areaname,ar1.areaname,ar.areaname,a.detailaddress) AS address,a.tel,a.`name`,{$expressprice},'{$orderNum}' FROM sh_store_address a JOIN sh_store_area ar ON a.countyid=ar.areaid JOIN sh_store_area ar1 ON a.cityid=ar1.areaid JOIN sh_store_area ar2 ON a.provinceid=ar2.areaid WHERE id={$addressId} AND a.userid={$userID} AND delstate='N' limit 1";
//new Log("","ssss".$sqlInToOrder);
$effectRow = $Mysql->ExecuteSql($sqlInToOrder);
if ($effectRow > 0) {
$sqlSearchOrderId = "SELECT orderid FROM sh_store_order WHERE ordernum='{$orderNum}' LIMIT 1 ";
//new Log(""," ad".$sqlSearchOrderId);
$dataTableSearchOID = $Mysql->FetchData($sqlSearchOrderId);
$row = count($dataTableSearchOID);
if ($row == 1) {
$orderId = $dataTableSearchOID[0][0];
//插入订单详细信息到sh_store_order_detail表
$sqlInToOrderDetail = "INSERT INTO sh_store_order_detail (goodsid,price,orderid,num) values ({$gdetailid},{$price},{$orderId},{$sdnum}) ";
//new Log("","详细".$sqlInToOrderDetail);
$effectDetailRows = $Mysql->ExecuteSql($sqlInToOrderDetail);
if ($effectDetailRows > 0) {
//订单提交成功时，减少商品库存量
$Order = new Order();
$numUpResult = $Order->updateNums($orderId);
$num = $_REQUEST['num'];
$sql = "UPDATE sh_store_cart SET snum={$num} WHERE gdetailid={$id} AND userid=" . $userID;
$Mysql = new MySqlHelper();
$row = $Mysql->ExecuteSql($sql);
if ($row > 0) {
echo json_encode(array("code" => "200", "mess" => "修改成功！"));
return;
} else {
echo json_encode(array("code" => "110", "mess" => "修改失败！"));
return;
}
} elseif ($m == 'CHECK') {
$strid = $_REQUEST['strid'];
$flag = false;
if ($strid != '') {
$strid = substr($strid, 0, -1);
$flag = true;
} else {
$strid = 0;
}
$sql = "update sh_store_cart set checkstate=CASE WHEN gdetailid in ({$strid}) THEN 'ON' ELSE 'OFF' END WHERE userid={$userID}";
$Mysql = new MySqlHelper();
$row = $Mysql->ExecuteSql($sql);
if ($row > 0) {
echo json_encode(array("code" => "200", "mess" => "修改成功！"));
return;
} else {
echo json_encode(array("code" => "110", "mess" => $strid));
return;
}
}
function test()
{
$Mysql = new MySqlHelper();
return $row2 = $Mysql->ExecuteSql("INSERT INTO test (datatime,znum,onenum) VALUES ('2015-12-29',2,6)");
}
public function updateNums($orderid = 0)
{
$Mysql = new MySqlHelper();
$where = '';
//两个条件满足一个就可以更改，orderid优先
if ($orderid < 1) {
return false;
}
if ($orderid > 0) {
$where = " where o.orderid={$orderid} ";
}
$sqlInfo = "SELECT d.goodsid,d.num FROM sh_store_order o JOIN sh_store_order_detail d ON o.orderid=d.orderid " . $where;
new Log("", "" . $sqlInfo);
$dataInfo = $Mysql->FetchData($sqlInfo);
$row = count($dataInfo);
if ($row > 0) {
foreach ($dataInfo as $Items) {
$upsql = "UPDATE sh_store_goods_detail SET dnum =dnum-" . $Items['num'] . " ,salenum =salenum+" . $Items['num'] . " WHERE detailid=" . $Items['goodsid'];
$upRow = $Mysql->ExecuteSql($upsql);
if ($upRow < 1) {
new Log("", "更改商品数量失败，sql===" . $upsql);
return false;
}
}
return true;
} else {
return false;
}
}