/** 检查长时间未支付的订单
* @author zhengqian@dajiayao.cc
*/
public function checkOrderExpire()
{
$paymentDuration = Setting::getByKey(Setting::KEY_ORDER_PAYMENT_DURATION)->value;
$orders = Order::where('created_at', '<', date("Y-m-d H:i:s", time() - 3600 * $paymentDuration))->where('payment_status', Order::PAY_STATUS_NO)->where("status", '!=', Order::STATUS_CLOSED)->get();
foreach ($orders as $order) {
$order->status = Order::STATUS_CLOSED;
$order->save();
//恢复库存
$orderItems = $order->orderItems;
foreach ($orderItems as $orderItem) {
$item = $orderItem->items;
$item->stock += $orderItem->quantity;
$item->save();
}
}
}
/**
* 编辑商品
* @author Hanxiang
* @param $id
* @return view
*/
public function update($id)
{
//TODO:检查当前用户是否可编辑
$item = Item::find($id);
if (!$item) {
abort(404);
}
$item->imgurl = asset('/themeforest/images/avatar.png');
//TODO
$itemImage = ItemImage::where('item_id', $id)->first();
if (count($itemImage) > 0) {
$image = Image::find($itemImage->image_id);
if (count($image)) {
$item->imgurl = $image->url;
}
}
$supplier = Supplier::find($item->supplier_id);
$itemTypes = ItemType::orderBy('sort')->get();
$setting = Setting::getByKey(Setting::KEY_COMMISSIONS_RATE);
return view('admin.items.update')->with('item', $item)->with('supplier', $supplier)->with('itemTypes', $itemTypes)->with('setting', $setting);
}
public function getSettingByKey($key)
{
return Setting::getByKey($key);
}
