mirror of
https://gitee.com/ShopeX/OMS
synced 2026-03-22 18:35:35 +08:00
658 lines
27 KiB
PHP
658 lines
27 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 purchase_ctl_admin_inventory extends desktop_controller{
|
||
|
||
var $name = "盘点表管理";
|
||
var $workground = "storage_center";
|
||
|
||
/*
|
||
*
|
||
*/
|
||
function index(){
|
||
$params = array(
|
||
'title'=>'盘点导入',
|
||
'use_buildin_new_dialog' => false,
|
||
'use_buildin_set_tag'=>false,
|
||
'use_buildin_recycle'=>false,
|
||
'use_buildin_export'=>false,
|
||
'use_buildin_import'=>true,
|
||
'use_buildin_filter'=>true,
|
||
//'finder_aliasname'=>'inventory_record_finder',
|
||
//'finder_cols'=>'inventory_date,inventory_name,inventory_checker,import_status,update_status,is_create,confirm_status',
|
||
);
|
||
$this->finder('purchase_mdl_inventory', $params);
|
||
}
|
||
|
||
/*
|
||
* 盘点导入
|
||
*/
|
||
function import(){
|
||
$str = '';
|
||
/*if ($instance = kernel::service('ome.service.getbranchview')){
|
||
$branch_id = $instance->getBranchView($_GET['branch_id'], 'index.php?app=purchase&ctl=admin_inventory&act=import', '盘点导入', 'GET');
|
||
}
|
||
if ($branch_id){
|
||
$oBranch = app::get('ome')->model('branch');
|
||
$branch = $oBranch->dump($branch_id);
|
||
$str = "(".$branch['name'].")";
|
||
}*/
|
||
$params = array(
|
||
'title'=>'盘点导入'.$str,
|
||
'use_buildin_new_dialog' => false,
|
||
'use_buildin_set_tag'=>false,
|
||
'use_buildin_recycle'=>false,
|
||
'use_buildin_export'=>false,
|
||
'use_buildin_import'=>true,
|
||
'use_buildin_filter'=>true,
|
||
//'finder_aliasname'=>'inventory_record_finder',
|
||
//'finder_cols'=>'inventory_date,inventory_name,inventory_checker,import_status,update_status,is_create,confirm_status',
|
||
);
|
||
//if ($branch_id) $params['base_filter']['branch_id'] = $branch_id;
|
||
/*
|
||
* 获取操作员管辖仓库
|
||
*/
|
||
$oBranch = app::get('ome')->model('branch');
|
||
$is_super = kernel::single('desktop_user')->is_super();
|
||
if (!$is_super){
|
||
$branch_ids = $oBranch->getBranchByUser(true);
|
||
if ($branch_ids){
|
||
$params['base_filter']['branch_id'] = $branch_ids;
|
||
}else{
|
||
$params['base_filter']['branch_id'] = 'false';
|
||
}
|
||
}
|
||
|
||
$this->finder('purchase_mdl_inventory', $params);
|
||
}
|
||
|
||
/*
|
||
* 盘点导出,$page页码， $f1-5为过滤条件
|
||
*/
|
||
function export(){
|
||
|
||
//$page = $page ? $page : 1;
|
||
//$pagelimit = 10;
|
||
|
||
//获取仓库模式
|
||
// $branch_mode = app::get('ome')->getConf('ome.branch.mode');
|
||
// if (!$branch_mode){
|
||
// $branch_mode = 'single';
|
||
// }
|
||
// if ($branch_mode=='single'){
|
||
// //获取第一个仓库值与ID
|
||
// $oBranch = app::get('ome')->model('branch');
|
||
// $branch = $oBranch->getList('branch_id, name','',0,1);
|
||
// $data['branch_id'] = $branch[0]['branch_id'];
|
||
// }
|
||
|
||
$oBranch = app::get('ome')->model('branch');
|
||
$branch = $oBranch->getList('branch_id, name','',0,-1);
|
||
|
||
/*
|
||
* 获取操作员管辖仓库
|
||
*/
|
||
$is_super = kernel::single('desktop_user')->is_super();
|
||
if (!$is_super){
|
||
$branch_list = $oBranch->getBranchByUser();
|
||
}
|
||
$this->pagedata['branch_list'] = $branch_list;
|
||
$this->pagedata['is_super'] = $is_super;
|
||
|
||
//读取仓库的货品信息
|
||
//$oInventory = $this->app->model('inventory');
|
||
//$inventory_detail = $oInventory->getProduct($data, $pagelimit*($page-1), $pagelimit);
|
||
|
||
$this->pagedata['branch'] = $branch;
|
||
$this->pagedata['op_name'] = kernel::single('desktop_user')->get_name();
|
||
$this->pagedata['inventory_name'] = date('m月d日',time()).'盘点表';
|
||
$this->page("admin/inventory/export.html");
|
||
}
|
||
|
||
/*
|
||
* 盘点导出，Json数据返回，为解决避免一次性抛出大量数据而改用动态翻页方法
|
||
*/
|
||
function inventoryPreview($page=1){
|
||
|
||
$data = $_POST;
|
||
|
||
$page = $page ? $page : 1;
|
||
$pagelimit = 12;
|
||
|
||
//获取第一个仓库值与ID
|
||
//$oBranch = app::get('ome')->model('branch');
|
||
//$branch = $oBranch->getList('branch_id, name','',0,1);
|
||
//$data['branch_id'] = $branch[0]['branch_id'];
|
||
$data['branch_id'] = $_POST['branch_id'];
|
||
//读取仓库的货品信息
|
||
$oInventory = $this->app->model('inventory');
|
||
|
||
$inventory_detail = $oInventory->getProduct($data, $pagelimit*($page-1), $pagelimit);
|
||
|
||
$count = $inventory_detail['count'];
|
||
$total_page = ceil($count/$pagelimit);
|
||
$pager = $this->ui()->pager(array(
|
||
'current'=>$page,
|
||
'total'=>$total_page,
|
||
'link'=>'?page=%d'
|
||
));
|
||
$this->pagedata['pager'] = $pager;
|
||
unset($inventory_detail['count']);
|
||
$this->pagedata['inventory'] = $inventory_detail;
|
||
$this->pagedata['total_page'] = $total_page;
|
||
$this->pagedata['pagelimit'] = $pagelimit;
|
||
$this->pagedata['count'] = $count;
|
||
$this->pagedata['cur_page'] = $page;
|
||
return $this->display("admin/inventory/inventory_items_div.html");
|
||
|
||
//echo json_encode($inventory_detail);
|
||
|
||
}
|
||
|
||
/*
|
||
* 盘点损益确认finder
|
||
*/
|
||
function confirm($confirm_status=null){
|
||
$this->workground = "finance_center";
|
||
$base_filter['confirm_status'] = $confirm_status;
|
||
$params = array(
|
||
'title'=>'盘点损益确认',
|
||
'use_buildin_new_dialog' => false,
|
||
'use_buildin_set_tag'=>false,
|
||
'use_buildin_recycle'=>false,
|
||
'use_buildin_export'=>false,
|
||
'use_buildin_import'=>false,
|
||
'use_buildin_filter'=>false,
|
||
'base_filter' => $base_filter,
|
||
//'finder_aliasname'=>'inventory_confirm_finder',
|
||
//'finder_cols'=>'inventory_date,inventory_name,confirm_status,inventory_checker,branch_name,inventory_type,warehousing_dept',
|
||
);
|
||
$this->finder('purchase_mdl_inventory', $params);
|
||
}
|
||
|
||
/*
|
||
* 盘点损益确认操作:confirm_detail
|
||
*/
|
||
function confirm_detail($inventory_id=null, $page=1){
|
||
|
||
$inventory_id = intval($inventory_id);
|
||
$page = intval($page);
|
||
$page = $page ? $page : 1;
|
||
$pagelimit = 12;
|
||
|
||
if ($_GET['view']=='true' and $_GET['from']=='counterTables'){
|
||
$this->workground = "invoice_center";
|
||
}
|
||
elseif ($_GET['view']=='true' and $_GET['from']<>'counterTables'){
|
||
$this->workground = "storage_center";
|
||
}
|
||
else {
|
||
$this->workground = "finance_center";
|
||
}
|
||
$oInventory = $this->app->model('inventory');
|
||
$oInventory_items = $this->app->model('inventory_items');
|
||
$inventory_detail = $oInventory->dump($inventory_id, '*');
|
||
|
||
//盘点明细
|
||
$inventory_items = $oInventory_items->getList('*', array('inventory_id'=>$inventory_id), $pagelimit*($page-1), $pagelimit);
|
||
//总计
|
||
$total = $oInventory->getInventoryTotal($inventory_id);
|
||
if ($inventory_items)
|
||
foreach ($inventory_items as $k=>$v){
|
||
//小计
|
||
$subtotal['accounts_num'] += $v['accounts_num'];
|
||
$subtotal['actual_num'] += $v['actual_num'];
|
||
$subtotal['shortage_over'] += $v['shortage_over'];
|
||
}
|
||
$count = $total['count'];
|
||
// $this->pagedata['pager'] = array(
|
||
// 'current'=>$page,
|
||
// 'total'=>ceil($count/$pagelimit),
|
||
// 'link'=>'index.php?app=purchase&ctl=admin_inventory&act=confirm_detail&p[0]='.$inventory_id.'&p[1]=%d&view='.$_GET['view'].'&from='.$_GET['from'],
|
||
// );
|
||
$pager = $this->ui()->pager(array(
|
||
'current'=>$page,
|
||
'total'=>ceil($count/$pagelimit),
|
||
'link'=>'index.php?app=purchase&ctl=admin_inventory&act=confirm_detail&p[0]='.$inventory_id.'&p[1]=%d&view='.$_GET['view'].'&from='.$_GET['from'],
|
||
));
|
||
$this->pagedata['pager'] = $pager;
|
||
$this->pagedata['detail'] = $inventory_detail;
|
||
$this->pagedata['items'] = $inventory_items;
|
||
$this->pagedata['inventory_id'] = $inventory_id;
|
||
$this->pagedata['subtotal'] = $subtotal;#小计
|
||
$this->pagedata['total'] = $total[0];#总计
|
||
$this->pagedata['count'] = $count;
|
||
$this->pagedata['pagelimit'] = $pagelimit;
|
||
$this->pagedata['view'] = $_GET['view'];
|
||
$this->page("admin/inventory/confirm.html");
|
||
}
|
||
|
||
/*
|
||
* 确认操作
|
||
*/
|
||
function doconfirm(){
|
||
|
||
$this->workground = "finance_center";
|
||
$oInventory = $this->app->model('inventory');
|
||
$data = $_POST;
|
||
$inventory_id = intval($data['inventory_id']);
|
||
|
||
if ($data['doSubmit']=='true'){
|
||
$gotourl = 'index.php?app=purchase&ctl=admin_inventory&act=doconfirm&p[0]='.$inventory_id;
|
||
$this->begin($gotourl);
|
||
$datas['inventory_id'] = $inventory_id;
|
||
$datas['confirm_status'] = '2';
|
||
$datas['confirm_op'] = kernel::single('desktop_user')->get_name();
|
||
$datas['confirm_time'] = time();
|
||
$result = $oInventory->confirm($datas);
|
||
|
||
$endurl = 'index.php?app=purchase&ctl=admin_inventory&act=confirm&p[0]=1';
|
||
if ($result) $msg = '成功';else $msg = '失败';
|
||
$this->end($result, '确认'.$msg, $endurl);
|
||
}
|
||
}
|
||
|
||
/*
|
||
* 损益汇总表
|
||
*/
|
||
function counterTables($page=1, $begin_date=null, $end_date=null){
|
||
|
||
$page = intval($page);
|
||
$page = $page ? $page : 1;
|
||
$pagelimit = 8;
|
||
$begin_date = $_POST['begin_date'] ? $_POST['begin_date'] : $begin_date;
|
||
$end_date = $_POST['end_date'] ? $_POST['end_date'] : $end_date;
|
||
if ($begin_date) {
|
||
$begin_date = strtotime($begin_date);
|
||
$begin_date = date("Y-m-d",$begin_date);
|
||
$filter['begin_date'] = $begin_date;
|
||
}
|
||
if ($end_date) {
|
||
$end_date = strtotime($end_date);
|
||
$end_date = date("Y-m-d",$end_date);
|
||
$filter['end_date'] = $end_date;
|
||
}
|
||
$this->workground = "invoice_center";
|
||
$oInventory = $this->app->model('inventory');
|
||
|
||
//盘点明细
|
||
$inventory_list = $oInventory->getInventoryList('inventory_id,inventory_date,inventory_checker,difference', $filter, $pagelimit*($page-1), $pagelimit);
|
||
|
||
//总计
|
||
$total = $oInventory->getTotal($begin_date, $end_date);
|
||
|
||
if ($inventory_list)
|
||
foreach ($inventory_list as $k=>$v){
|
||
//小计
|
||
$subtotal['total_shortage_over'] += $v['difference'];
|
||
}
|
||
$count = $total['count'];
|
||
// $this->pagedata['pager'] = array(
|
||
// 'current'=>$page,
|
||
// 'total'=>ceil($count/$pagelimit),
|
||
// 'link'=>'index.php?app=purchase&ctl=admin_inventory&act=counterTables&p[0]=%d&p[1]='.$begin_date.'&p[2]='.$end_date,
|
||
// );
|
||
$pager = $this->ui()->pager(array(
|
||
'current'=>$page,
|
||
'total'=>ceil($count/$pagelimit),
|
||
'link'=>'index.php?app=purchase&ctl=admin_inventory&act=counterTables&p[0]=%d&p[1]='.$begin_date.'&p[2]='.$end_date,
|
||
));
|
||
$this->pagedata['pager'] = $pager;
|
||
$this->pagedata['list'] = $inventory_list;
|
||
$this->pagedata['subtotal'] = $subtotal;#小计
|
||
$this->pagedata['total'] = $total[0];#总计
|
||
$this->pagedata['count'] = $count;
|
||
$this->pagedata['pagelimit'] = $pagelimit;
|
||
$this->pagedata['begin_date'] = $begin_date;
|
||
$this->pagedata['end_date'] = $end_date;
|
||
$this->page("admin/inventory/counterTables.html");
|
||
}
|
||
|
||
function getProduct(){
|
||
if ($_POST['barcode']){
|
||
$barcode = trim($_POST['barcode']);
|
||
$branch_id = $_POST['branch_id'];
|
||
if (!$branch_id) exit('false');
|
||
$ivObj = $this->app->model('inventory');
|
||
$data = $ivObj->getBranchProduct($branch_id, $barcode);
|
||
if (!$data) exit('false');
|
||
echo json_encode($data);
|
||
}else {
|
||
exit('false');
|
||
}
|
||
}
|
||
|
||
function exsitPosition(){
|
||
if ($_POST['pos_name']){
|
||
$pos_name = trim($_POST['pos_name']);
|
||
$branch_id = $_POST['branch_id'];
|
||
if (!$branch_id) exit("false");
|
||
$bpObj = app::get('ome')->model('branch_pos');
|
||
$bp = $bpObj->dump(array('store_position'=>$pos_name,'branch_id'=>$branch_id),'pos_id');
|
||
if (!$bp) exit("false");
|
||
echo json_encode($bp);
|
||
}else {
|
||
echo "false";
|
||
}
|
||
}
|
||
|
||
function toInventory(){
|
||
$branch_id = $_POST['branch_id'];
|
||
if (!$branch_id) $branch_id = $_GET['branch_id'];
|
||
if (!$branch_id){
|
||
$this->begin("index.php?app=purchase&ctl=admin_inventory&act=online");
|
||
$this->end(false,'请选择仓库');
|
||
}else {
|
||
$brObj = app::get('ome')->model('branch');
|
||
$branch = $brObj->dump($branch_id);
|
||
|
||
$this->pagedata['branch_id'] = $branch_id;
|
||
$this->pagedata['branch_name'] = $branch['name'];
|
||
$this->pagedata['op_name'] = kernel::single('desktop_user')->get_name();
|
||
$this->pagedata['date'] = date("Y年m月d日");
|
||
$this->page("admin/inventory/inventory_online.html");
|
||
}
|
||
}
|
||
|
||
function online(){
|
||
$brObj = app::get('ome')->model('branch');
|
||
$branch_list = $brObj->getBranchByUser();
|
||
$branch_mode = app::get('ome')->getConf('ome.branch.mode');
|
||
|
||
$is_super = kernel::single('desktop_user')->is_super();
|
||
|
||
if ($is_super){
|
||
$branch_rows = $brObj->getList('branch_id,name','',0,-1);
|
||
if (count($branch_rows) == 1){
|
||
|
||
$this->pagedata['branch_id'] = $branch_rows[0]['branch_id'];
|
||
$this->pagedata['branch_name'] = $branch_rows[0]['name'];
|
||
$this->pagedata['op_name'] = kernel::single('desktop_user')->get_name();
|
||
$this->pagedata['date'] = date("Y年m月d日");
|
||
$this->page("admin/inventory/inventory_online.html");
|
||
}else {
|
||
$this->pagedata['branch_list'] = $branch_rows;
|
||
$this->page("admin/inventory/online.html");
|
||
}
|
||
}else {
|
||
if (count($branch_list) == 1){
|
||
|
||
$this->pagedata['branch_id'] = $branch_list[0]['branch_id'];
|
||
$this->pagedata['branch_name'] = $branch_list[0]['name'];
|
||
$this->pagedata['op_name'] = kernel::single('desktop_user')->get_name();
|
||
$this->pagedata['date'] = date("Y年m月d日");
|
||
$this->page("admin/inventory/inventory_online.html");
|
||
}else {
|
||
$this->pagedata['branch_list'] = $branch_list;
|
||
$this->page("admin/inventory/online.html");
|
||
}
|
||
}
|
||
}
|
||
|
||
/*
|
||
* 盘点更新
|
||
*/
|
||
function updateBranchProductPos()
|
||
{
|
||
$basicMaterialLib = kernel::single('material_basic_material');
|
||
$libBranchProductPos = kernel::single('ome_branch_product_pos');
|
||
|
||
$this->begin("index.php?app=purchase&ctl=admin_inventory&act=updateBranchProductPos");
|
||
if (!$_POST['branch_id']){
|
||
$this->end(false, '无仓库信息');
|
||
}
|
||
if (!$_POST['product_id']){
|
||
$this->end(false, '无商品信息');
|
||
}
|
||
if (!$_POST['pos_id']){
|
||
$this->end(false, '无货位信息');
|
||
}else {
|
||
$_bpp_ = app::get('ome')->model('branch_pos')->dump(array('pos_id'=>$_POST['pos_id'],'branch_id'=>$_POST['branch_id']));
|
||
if (!$_bpp_){
|
||
$this->end(false, '货位不存在');
|
||
}
|
||
}
|
||
if ($_POST['number'] == 0 || !empty($_POST['number'])){
|
||
if (!is_numeric($_POST['number']) || intval($_POST['number']) < 0){
|
||
$this->end(false, '请输入自然数');
|
||
}
|
||
}
|
||
|
||
$pos_id = $_POST['pos_id'];
|
||
$number = $_POST['number'];
|
||
$product_id = $_POST['product_id'];
|
||
$branch_id = $_POST['branch_id'];
|
||
if ($_POST['delete'])
|
||
$delete = true;
|
||
else
|
||
$delete = false;
|
||
|
||
$bppObj = app::get('ome')->model('branch_product_pos');
|
||
$bpObj = app::get('ome')->model('branch_product');
|
||
$bpsObj = app::get('ome')->model('branch_pos');
|
||
$bObj = app::get('ome')->model('branch');
|
||
|
||
$invObj = $this->app->model('inventory');
|
||
$poObj = $this->app->model('po');
|
||
$invitemObj = $this->app->model('inventory_items');
|
||
|
||
$op_name = kernel::single('desktop_user')->get_name();
|
||
$op_id = kernel::single('desktop_user')->get_id();
|
||
$branch = $bObj->dump($branch_id,'name');
|
||
|
||
$inv_date = $invObj->getList('inventory_id,difference,inventory_date',array('op_id'=>$op_id,'branch_id'=>$branch_id,'inventory_type'=>'3'),0,1,'inventory_date DESC');
|
||
if ($inv_date){
|
||
foreach ($inv_date as $v){
|
||
if (date('Ymd',time()) == date('Ymd',$v['inventory_date'])){
|
||
$inv_id = $v['inventory_id'];
|
||
$total = $v['difference'];
|
||
}else {
|
||
//记录盘点表
|
||
$inv['inventory_name'] = date("Ymd")."在线盘点表";
|
||
$inv['inventory_bn'] = $invObj->gen_id();
|
||
$inv['inventory_date'] = time();
|
||
$inv['inventory_checker'] = $op_name;
|
||
$inv['second_checker'] = $op_name;
|
||
$inv['finance_dept'] = $op_name;
|
||
$inv['warehousing_dept'] = $op_name;
|
||
$inv['op_name'] = $op_name;
|
||
$inv['op_id'] = $op_id;
|
||
$inv['branch_id'] = $branch_id;
|
||
$inv['branch_name'] = $branch['name'];
|
||
$inv['inventory_type'] = '3';//在线盘点
|
||
|
||
$invObj->save($inv);
|
||
$inv_id = $inv['inventory_id'];
|
||
$total = 0;
|
||
}
|
||
break;
|
||
}
|
||
}else {
|
||
//记录盘点表
|
||
$inv['inventory_name'] = date("Ymd")."在线盘点表";
|
||
$inv['inventory_bn'] = $invObj->gen_id();
|
||
$inv['inventory_date'] = time();
|
||
$inv['inventory_checker'] = $op_name;
|
||
$inv['second_checker'] = $op_name;
|
||
$inv['finance_dept'] = $op_name;
|
||
$inv['warehousing_dept'] = $op_name;
|
||
$inv['op_name'] = $op_name;
|
||
$inv['op_id'] = $op_id;
|
||
$inv['branch_id'] = $branch_id;
|
||
$inv['branch_name'] = $branch['name'];
|
||
$inv['inventory_type'] = '3';//在线盘点
|
||
|
||
$invObj->save($inv);
|
||
$inv_id = $inv['inventory_id'];
|
||
$total = 0;
|
||
}
|
||
|
||
$p = $basicMaterialLib->getBasicMaterialExt($product_id);
|
||
|
||
$price = $poObj->getPurchsePrice($product_id,'DESC');
|
||
$pos = $bpsObj->dump(array('pos_id'=>$pos_id,'branch_id'=>$branch_id));
|
||
|
||
$bpp = $bppObj->getList('pos_id,store',array('product_id'=>$product_id,'branch_id'=>$branch_id),0,-1);
|
||
|
||
if ($bpp){
|
||
if ($delete){
|
||
foreach ($bpp as $v){
|
||
$tmp_pos = $bpsObj->dump(array('pos_id'=>$v['pos_id'],'branch_id'=>$branch_id));
|
||
$bppObj->delete(array('product_id'=>$product_id,'pos_id'=>$v['pos_id'],'branch_id'=>$branch_id));
|
||
//记录损益表
|
||
$inv_item['inventory_id'] = $inv_id;
|
||
$inv_item['product_id'] = $product_id;
|
||
$inv_item['pos_id'] = $pos_id;
|
||
$inv_item['name'] = $p['material_name'];
|
||
$inv_item['bn'] = $p['material_bn'];
|
||
$inv_item['spec_info'] = $p['specifications'];
|
||
$inv_item['unit'] = $p['unit'];
|
||
$inv_item['pos_name'] = $tmp_pos['store_position'];
|
||
$inv_item['accounts_num'] = $v['store'];
|
||
$inv_item['actual_num'] = 0;//实际数量
|
||
$inv_item['shortage_over'] = $inv_item['actual_num']-$v['store'];
|
||
$inv_item['price'] = $price;
|
||
$inv_item['availability'] = 'true';
|
||
$inv_item['memo'] = '在线盘点，删除商品';
|
||
|
||
$total += $inv_item['shortage_over']*$price;
|
||
$invitemObj->save($inv_item);//记录导入明细
|
||
$inv_item = null;
|
||
}
|
||
//change
|
||
$libBranchProductPos->count_store($product_id,$branch_id);//count
|
||
}
|
||
$tmp = array(
|
||
'product_id' =>$product_id,
|
||
'pos_id' =>$pos_id,
|
||
'branch_id' =>$branch_id,
|
||
'store' =>$number
|
||
);
|
||
if ($delete) {
|
||
$tmp['create_time'] = time();
|
||
$tmp['default_pos'] = true;
|
||
}
|
||
|
||
$bpp_ = $bppObj->dump(array('pos_id'=>$pos_id,'product_id'=>$product_id,' branch_id'=>$branch_id),'store');
|
||
$bppObj->save($tmp);
|
||
//change
|
||
$libBranchProductPos->count_store($product_id,$branch_id);//count
|
||
if ($delete){
|
||
//记录损益表
|
||
$inv_item['inventory_id'] = $inv_id;
|
||
$inv_item['product_id'] = $product_id;
|
||
$inv_item['pos_id'] = $pos_id;
|
||
$inv_item['name'] = $p['name'];
|
||
$inv_item['bn'] = $p['bn'];
|
||
$inv_item['spec_info'] = $p['specifications'];
|
||
$inv_item['unit'] = $p['unit'];
|
||
$inv_item['pos_name'] = $pos['store_position'];
|
||
$inv_item['accounts_num'] = 0;
|
||
$inv_item['actual_num'] = $number;//实际数量
|
||
$inv_item['shortage_over'] = $inv_item['actual_num'];
|
||
$inv_item['price'] = $price;
|
||
$inv_item['availability'] = 'true';
|
||
$inv_item['memo'] = '在线盘点，新增商品数量';
|
||
|
||
$total += $inv_item['shortage_over']*$price;
|
||
$invitemObj->save($inv_item);//记录导入明细
|
||
$inv_item = null;
|
||
}else {
|
||
|
||
//记录损益表
|
||
$inv_item['inventory_id'] = $inv_id;
|
||
$inv_item['product_id'] = $product_id;
|
||
$inv_item['pos_id'] = $pos_id;
|
||
$inv_item['name'] = $p['name'];
|
||
$inv_item['bn'] = $p['bn'];
|
||
$inv_item['spec_info'] = $p['specifications'];
|
||
$inv_item['unit'] = $p['unit'];
|
||
$inv_item['pos_name'] = $pos['store_position'];
|
||
$inv_item['accounts_num'] = $bpp_['store'];
|
||
$inv_item['actual_num'] = $number;//实际数量
|
||
$inv_item['shortage_over'] = $inv_item['actual_num']-$bpp_['store'];
|
||
$inv_item['price'] = $price;
|
||
$inv_item['availability'] = 'true';
|
||
$inv_item['memo'] = '在线盘点，修改已有商品数量';
|
||
|
||
$total += $inv_item['shortage_over']*$price;
|
||
$invitemObj->save($inv_item);//记录导入明细
|
||
$inv_item = null;
|
||
}
|
||
}else {
|
||
$tmp = array(
|
||
'product_id' => $product_id,
|
||
'branch_id' => $branch_id,
|
||
'pos_id' => $pos_id,
|
||
'store' => $number,
|
||
'default_pos' => true,
|
||
'create_time' => time(),
|
||
);
|
||
$bppObj->save($tmp);
|
||
//change
|
||
$libBranchProductPos->count_store($product_id,$branch_id);
|
||
//记录损益表
|
||
$inv_item['inventory_id'] = $inv_id;
|
||
$inv_item['product_id'] = $product_id;
|
||
$inv_item['pos_id'] = $pos_id;
|
||
$inv_item['name'] = $p['name'];
|
||
$inv_item['bn'] = $p['bn'];
|
||
$inv_item['spec_info'] = $p['specifications'];
|
||
$inv_item['unit'] = $p['unit'];
|
||
$inv_item['pos_name'] = $pos['store_position'];
|
||
$inv_item['accounts_num'] = 0;
|
||
$inv_item['actual_num'] = $number;//实际数量
|
||
$inv_item['shortage_over'] = $inv_item['actual_num'];
|
||
$inv_item['price'] = $price;
|
||
$inv_item['availability'] = 'true';
|
||
$inv_item['memo'] = '在线盘点，新增商品数量';
|
||
|
||
$total += $inv_item['shortage_over']*$price;
|
||
$invitemObj->save($inv_item);//记录导入明细
|
||
$inv_item = null;
|
||
}
|
||
$inv['inventory_id'] = $inv_id;
|
||
$inv['difference'] = $total;//$tmp['total'];
|
||
$inv['import_status'] = '2';
|
||
$inv['update_status'] = '2';
|
||
|
||
|
||
$invObj->save($inv);
|
||
$this->end(true, '盘点完成', 'index.php?app=purchase&ctl=admin_inventory&act=toInventory&branch_id='.$branch_id);
|
||
}
|
||
|
||
function existDeletePosRelation($branch_id=0, $product_id=0){
|
||
if ($_POST){
|
||
$branch_id = $_POST['branch_id'];
|
||
$product_id = $_POST['product_id'];
|
||
}
|
||
$bppObj = app::get('ome')->model('branch_product_pos');
|
||
$invObj = $this->app->model('inventory');
|
||
$bpp = $bppObj->getList('pos_id,store',array('product_id'=>$product_id,'branch_id'=>$branch_id),0,-1);
|
||
if ($bpp){
|
||
foreach ($bpp as $v){
|
||
if ($invObj->existPosNotProcess($v['pos_id'])){
|
||
exit('false');
|
||
}
|
||
}
|
||
}
|
||
echo 'true';
|
||
}
|
||
}
|
||
|
||
?>
|