コード例 #1
0
ファイル: auto.model.php プロジェクト: ohjack/newErp
 public static function checkHasRepertoryOs($sku, $num)
 {
     $sql = "select count from ow_stock where sku='{$sku}'";
     $sql = self::$dbConn->execute($sql);
     $real_count = self::$dbConn->fetch_first($sql);
     $totalnums = CommonModel::get_waiting_sale($sku);
     //var_dump($real_count['count'],$totalnums);
     $virtualnum = $real_count['count'] - $totalnums;
     return $virtualnum;
     /*
     	    $returnData    = FALSE;
     	    $sql   = "select count, salensend  from ow_stock where sku='$sku'";
     	    $row   = self::$dbConn->fetch_first($sql);
     	    if (empty($row)) {
     	    	$returnData = TRUE;
     	    } else {
     	        $count = $row['count'];
     	        $hold = $row['salensend'];
     	        if ($num > ($count - $hold)) {
     	        	$returnData   = TRUE;
     	        } else {
     	            $returnData    = FALSE;
     	        }
     	    }
     	    return $returnData;*/
 }