mirror of
https://gitee.com/ShopeX/OMS
synced 2026-03-22 18:35:35 +08:00
83 lines
2.7 KiB
PHP
83 lines
2.7 KiB
PHP
<?php
|
|
/**
|
|
* Copyright 2012-2026 ShopeX (https://www.shopex.cn)
|
|
*
|
|
* Licensed under the Apache License, Version 2.0 (the "License");
|
|
* you may not use this file except in compliance with the License.
|
|
* You may obtain a copy of the License at
|
|
*
|
|
* http://www.apache.org/licenses/LICENSE-2.0
|
|
*
|
|
* Unless required by applicable law or agreed to in writing, software
|
|
* distributed under the License is distributed on an "AS IS" BASIS,
|
|
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
|
|
* See the License for the specific language governing permissions and
|
|
* limitations under the License.
|
|
*/
|
|
|
|
/**
|
|
*
|
|
*/
|
|
class wms_iostockdata{
|
|
|
|
|
|
/***
|
|
* 获取仓库对应售后仓
|
|
*/
|
|
function getDamagedbranch($branch_id){
|
|
$oBranch = app::get('ome')->model('branch');
|
|
$branch_damaged = $oBranch->dump(array('parent_id' => $branch_id, 'type' => 'damaged'), 'branch_id,branch_bn');
|
|
return $branch_damaged;
|
|
|
|
|
|
}
|
|
/**
|
|
* 根据仓库ID返回仓库信息
|
|
*/
|
|
function getBranchByid($branch_id){
|
|
$oBranch = app::get('ome')->model('branch');
|
|
$branch = $oBranch->getlist('type,branch_id,branch_bn',array('branch_id' => $branch_id),0,1);
|
|
$branch = $branch[0];
|
|
return $branch;
|
|
|
|
}
|
|
|
|
/**
|
|
* 根据出入库编号查询出对应入库数量是否异常并返回
|
|
*/
|
|
function getIsoBybn($iso_bn){
|
|
$oIso = app::get('taoguaniostockorder')->model("iso");
|
|
$iso = $oIso->dump(array('iso_bn'=>$iso_bn),'iso_id');
|
|
$iso_id = $iso['iso_id'];
|
|
$sql = 'SELECT nums,normal_num,defective_num,bn FROM sdb_taoguaniostockorder_iso_items WHERE iso_id='.$iso_id.' AND (normal_num>nums OR defective_num>0)';
|
|
$iso_item = $oIso->db->select($sql);
|
|
return $iso_item;
|
|
}
|
|
|
|
/**
|
|
* 根据编号查询采购单入库数量是否异常并返回
|
|
*
|
|
*/
|
|
function getPoBybn($po_bn){
|
|
$oPo = app::get('purchase')->model('po');
|
|
$po = $oPo->dump(array('po_bn'=>$po_bn),'po_id');
|
|
$po_id = $po['po_id'];
|
|
$SQL = 'SELECT in_num,num,defective_num,bn FROM sdb_purchase_po_items WHERE po_id='.$po_id.' AND (in_num>num OR defective_num>0)';
|
|
$po_item = $oPo->db->select($SQL);
|
|
return $po_item;
|
|
}
|
|
|
|
/**
|
|
* 根据编号查询采购单入库数量是否异常并返回
|
|
*
|
|
*/
|
|
function getPurchasereturnBybn($rp_bn){
|
|
$oRp = app::get('purchase')->model('returned_purchase');
|
|
$rp = $oRp->dump(array('rp_bn'=>$rp_bn),'rp_id');
|
|
$rp_id = $rp['rp_id'];
|
|
$SQL = 'SELECT num,out_num,bn FROM sdb_purchase_returned_purchase_items WHERE rp_id='.$rp_id.' AND (out_num>num)';
|
|
$rp_item = $oRp->db->select($SQL);
|
|
return $rp_item;
|
|
}
|
|
}
|