scm/lib/Stock.php

<?php

namespace Scm\Lib;

use Dever;

class Stock
{
	public function out_check($id, $name, $data)
	{
		$table = Dever::input('table');
		$col = Dever::input('col');
		$goods = Dever::param('goods', $data);
		list($goods_id, $sku_id) = explode('-', $goods);
		$where['goods_id'] = $goods_id;
		$where['sku_id'] = $sku_id;
		$where[$col] = Dever::input('update_' . $col);
		$info = Dever::db($table)->getOne($where);
		$error = false;
		$total = '';
		if ($info) {
			$num = Dever::param('num', $data);
			if ($info['total'] < $num) {
				$error = true;
				$total = $info['total'];
			}
		} else {
			$error = true;
			$total = 0;
		}
		if ($error) {
			$order_table = Dever::input('order_table');
			if ($order_table) {
				$order_id = Dever::param('order_id', $data);
				Dever::db($order_table)->delete($order_id);
			}
			$goods_info = Dever::load('scm_product/lib/info')->getBaseInfo($goods_id, $sku_id);
			Dever::alert('【' . $goods_info['aname'] . '】剩余库存：' . $total . $goods_info['unit'] . '，已不足出库');
		}
	}

    # 更新库存
    public function update_commit($id, $name, $data)
    {
    	$table = Dever::input('table');
    	$type = Dever::input('type');
    	$col = Dever::input('col');
    	$stock = Dever::input('stock');

    	$goods = Dever::db($table . '_goods')->find(array('order_id' => $id));
    	if (!$goods) {
    		Dever::db($table)->delete($id);
    		Dever::alert('未选择商品，新增订单失败');
    	}
    	$info = Dever::db($table)->find($id);
    	if ($table && $type && $info && $info['status'] == 1) {
    		$audit = Dever::param('audit', $data);
    		$admin = Dever::load('manage/auth.info');
    		if ($admin) {
    			$update['audit_admin'] = $admin['id'];
    		}
    		$update['status'] = $audit;
    		$update['where_id'] = $id;
    		Dever::db($table)->update($update);
    		if ($audit == 2) {
    			# 审核通过 更新库存
    			$this->up($table, $type, $col, $stock, $info);
    		}
    		Dever::db($table . '_goods')->updates(array('option_order_id' => $info['id'], 'set_status' => $update['status']));
    	}
    }

    public function up($table, $type, $col, $stock, $info)
    {
    	if ($col && $stock && isset($info[$col])) {
    		$order_goods = Dever::db($table . '_goods')->select(array('order_id' => $info['id'], 'status' => 1));
			if ($order_goods) {
				foreach ($order_goods as $k => $v) {
					$update = array('goods_id' => $v['goods_id'], $col => $info[$col]);
					$goods = Dever::db($stock)->find($update);
					if (!$goods) {
						Dever::db($stock)->insert($update);
					}

					$result = Dever::load('scm/lib/price')->getByUnit($v['goods_id'], $v['sku_id'], $v['unit_id'], $v['num'], $v['cash'], Dever::input('supplier_id'));
					if ($result) {
						$v['unit_id'] = $result['base_unit_id'];
						$v['cash'] = $result['base_cash'];
						$v['num'] = $result['base_num'];
					} else {
						Dever::db($table)->delete($info['id']);
    					Dever::alert('商品不存在');
					}

					if ($type == 'in') {
						# 入库
						if (!$v['batch']) {
							$v['batch'] = date('Ymd');
						}
						$update['sku_id'] = $v['sku_id'];
						$update['batch'] = $v['batch'];
						if ($v['sdate']) {
							$update['sdate'] = $v['sdate'];
						}
						$goods = Dever::db($stock . '_sku')->find($update);
						if (!$goods) {
							$update['cash'] = $v['cash'];
							$update['unit_id'] = $v['unit_id'];
							$id = Dever::db($stock . '_sku')->insert($update);
							$where['where_id'] = $id;
						} else {
							$where['where_id'] = $goods['id'];
						}

						$where[$type . '_num'] = $v['num'];
						$method = $type . 'Update';
						Dever::db($stock . '_sku')->$method($where);
					} elseif ($type == 'out') {
						# 出库
						$update['sku_id'] = $v['sku_id'];
						$goods = Dever::db($stock . '_sku')->getList($update);
						if ($goods) {
							$num = $v['num'];
							foreach ($goods as $k1 => $v1) {
								if ($v1['total'] >= $num) {
									Dever::db($stock . '_sku')->outUpdate(array('where_id' => $v1['id'], 'out_num' => $num));
									break;
								} else {
									$num = $num - $v1['total'];
									Dever::db($stock . '_sku')->outUpdate(array('where_id' => $v1['id'], 'out_num' => $v1['total']));
								}
							}
						}
					}

					//Dever::db($table . '_goods')->update(array('where_id' => $v['id'], 'status' => 2));
				}
			}
		}
    }
}