getSetData(); $this->assign('set', $setData['setList']); $this->assignconfig('set',$setData['setList']); $this->assign('nowmenu', $setData['nowmenu']); $this->model = new \app\admin\model\kuerp\Warehouse; $this->view->assign("businessTypeList", $this->model->getBusinessTypeList()); $this->view->assign("examineStatusList", $this->model->getExamineStatusList()); $this->view->assign("customersList", $this->model->getCustomersList()); $this->view->assign("storesList", $this->model->getStoresList()); $this->assignconfig("storesList", $this->model->getStoresList()); $this->view->assign("goodsList", $this->model->getGoodsList()); $this->assignconfig("goodsList", $this->model->getGoodsList()); } public function import() { parent::import(); } /** * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法 * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑 * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改 */ /** * 查看 */ public function index() { //当前是否为关联查询 $this->relationSearch = true; //设置过滤方法 $this->request->filter(['strip_tags', 'trim']); if ($this->request->isAjax()) { //如果发送的来源是Selectpage,则转发到Selectpage if ($this->request->request('keyField')) { return $this->selectpage(); } list($where, $sort, $order, $offset, $limit) = $this->buildparams(); $alist = $this->model->where('see_stastus',0)->select(); if(!empty($alist)){ $t_model = new \app\admin\model\fastflow\bill\Tmrxyo(); foreach ($alist as &$item){ $status = $t_model->where('id',$item['tmrxyo_id'])->value('status'); if($status == 2){ $this->model->where('id',$item['id'])->update(['see_stastus'=>1]); } } } $list = $this->model ->with(['admin','examine','customers']) ->where($where) ->where('see_stastus',1) ->order($sort, $order) ->paginate($limit); foreach ($list as $row) { $row->getRelation('examine')->visible(['username']); $row->getRelation('admin')->visible(['username']); $row->getRelation('customers')->visible(['customer_name']); } foreach ($list as $list_k=>$list_v){ if(isset($list_v['print_num']) && empty($list_v['print_num'])){ $list[$list_k]['print_num'] = 0; } } $result = array("total" => $list->total(), "rows" => $list->items()); return json($result); } return $this->view->fetch(); } public function add($purchase_code = null,$type=null) { if ($this->request->isPost()) { $params = $this->request->post("row/a"); if ($params) { $params = $this->preExcludeFields($params); (new \app\admin\controller\kuerp\Checkout())->checkOutTime($params['purchase_time']); $code = $params['purchase_code']; if($this->model->where((new Goods())->setWhere(['purchase_code'=>trim($params['purchase_code'])]))->find()){ $this->error('单据编号已占用'); } $purchase_time = strtotime($params['purchase_time']); $business_type = $params['business_type']; if(empty($code)){ $this->error('请输入单据编号'); }else if(empty($purchase_time)){ $this->error('请输入单据时间'); }else if(empty($business_type)){ $this->error('请选择业务类型'); } $supplyer = Db::name('kuerp_customers')->where((new Goods())->setWhere(['id'=>$params['customers_id']]))->find(); $admin = Session::get('admin'); $serial= Db::name('kuerp_sets')->where((new Goods())->setWhere(['name'=>'serial']))->value('is_checked'); $batch= Db::name('kuerp_sets')->where((new Goods())->setWhere(['name'=>'batch']))->value('is_checked'); $auxiliary_status= Db::name('kuerp_sets')->where(['name'=>'auxiliary'])->value('is_checked'); $data = []; $all_number = 0;//总数量 $all_price = 0;//总金额 foreach ($params['goods_code'] as $k=>$v){ if(!empty($v)){//有产品编号 if(!isset($params['stores_id'][$k]) || empty($params['stores_id'][$k])){ $this->error('请选择仓库'); } if(!isset($params['number'][$k]) || empty($params['number'][$k])){ $this->error('请输入出库数量'); } $all_number += $params['number'][$k]; $all_price += $params['all_money'][$k]; $goods = Db::name('kuerp_goods')->where((new Goods())->setWhere(['goods_code'=>$v]))->find(); $goods_unit = $params['goods_unit'][$k]===''?null:(float)$params['goods_unit'][$k]; if(empty($goods_unit)){ $this->error('请选择单位'); } if ($goods['auxiliary']==1 && empty($params['goods_attr'][$k]) && $auxiliary_status==1){ return ['status'=>500,'msg'=>'请选择商品'.$v.'属性']; } $advance_rate = 1;//换算进率 if($goods['more_unit']==1) { if($goods_unit!=$goods['unit_id']){ //所选单位不等于商品默认单位,需查询进率换算基础数量 $more_unit = Db::name('kuerp_unit_conversion') ->where((new Goods())->setWhere(['main_unit'=>$goods['unit_id'],'vice_unit'=>$goods_unit])) ->field('id,advance_rate') ->find(); if(empty($more_unit)){ $this->error('商品单位信息查询失败'); }else{ $advance_rate = $more_unit['advance_rate']; } } } if($goods['batch']==1 && $batch==1) { if (empty($params['batch'][$k])) { $this->error('请选择生产批次'); } if (empty($params['manufacture'][$k])) { $this->error('请输入生产日期'); } if($params['guarantee'][$k]===''){ $this->error('请输入保质期'); } if ($params['guarantee'][$k]<0){ $this->error('保质期天数不可小于0'); } if (empty($params['validity'][$k])) { $this->error('请输入过期时间'); } $where = []; $where['goods_code'] = $goods['goods_code']; $where['stores_id'] = (float)$params['stores_id'][$k]; if(!empty($params['goods_attr'][$k])){ $where['attribute_id'] = (float)$params['goods_attr'][$k]; } $where['batch_id'] = (float)$params['batch_id'][$k]; $where = (new Goods())->setWhere($where); $basic_nmber = round(($advance_rate*$params['number'][$k]),4); $batch_stock = Db::name('kuerp_goods_batch_stock')->where($where)->find(); if(empty($batch_stock)){ $this->error('批次信息查询错误'); }elseif ($batch_stock['stock']<$basic_nmber){ $this->error('此批次库存不足'); } } if(isset($params['period_period'][$k]) && $goods['serial']==1 && $serial==1){ if(empty($params['period_period'][$k])){ $this->error('请输入商品序列号'); } $basic_nmber = (float)$params['number'][$k]; $per_code = []; $period = unserialize($params['period_period'][$k]); foreach ($period as $period_k=>$period_v){ if(!in_array($period_v['serial'],$per_code)){ $per_code[] = $period_v['serial']; } } $per_s = Db::name('kuerp_goods_serial')->where((new Goods())->setWhere(['serial'=>['in',$per_code],'store_status'=>'1']))->column('serial'); if(sizeof($per_code)!=sizeof($per_s)){ $str = []; foreach ($per_code as $per_code_k=>$per_code_v){ if(!in_array($per_code_v,$per_s)){ $str[] = $per_code_v; } } $this->error('序列号'.implode(',',$str).'不在库,不可出库'); } }else{ $basic_nmber = round(($advance_rate*$params['number'][$k]),4); } $data[] = (new Goods())->setDataInfo([ 'purchase_code' => $code, 'purchase_time' => $purchase_time, 'goods_id' => $goods['id'], 'goods_attr' => $params['goods_attr'][$k]===''?null:(float)$params['goods_attr'][$k], 'goods_unit' => $goods_unit, 'stores_id' => $params['stores_id'][$k]===''?null:(float)$params['stores_id'][$k], 'stock' => $params['allow_stock'][$k]===''?null:(float)$params['allow_stock'][$k], 'number' => $params['number'][$k]===''?null:(float)$params['number'][$k], 'basic_nmber' => $basic_nmber, 'period' => $params['period_period'][$k]===''?null:$params['period_period'][$k], 'unit_price' => $params['unit_price'][$k]===''?null:(float)$params['unit_price'][$k], 'price' => $params['all_money'][$k]===''?null:(float)$params['all_money'][$k], 'remark' => $params['remark'][$k]===''?null:$params['remark'][$k], 'batch' => $params['batch'][$k]===''?null:$params['batch'][$k], 'batch_id' => $params['batch_id'][$k]===''?null:(float)$params['batch_id'][$k], 'manufacture' => $params['manufacture'][$k]===''?null:strtotime($params['manufacture'][$k]), 'guarantee' => $params['guarantee'][$k]===''?null:(float)$params['guarantee'][$k], 'validity' => $params['validity'][$k]===''?null:strtotime($params['validity'][$k]), 'createtime' => time(), 'updatetime' => time(), ]); } } if(!empty($data)){ $row = (new Goods())->setDataInfo([ 'purchase_code' => $code, 'purchase_time' => $purchase_time, 'business_type' => $business_type, 'number' => $all_number, 'price' => $all_price, 'customers_id' => isset($supplyer['id'])?$supplyer['id']:null, 'preparation_id' => $admin['id'], 'remarks' => $params['note'], 'order_id' => isset($params['order_id'])?$params['order_id']:null, 'order_type' => isset($params['order_type'])?(empty($params['order_type'])?null:$params['order_type']):null, 'createtime' => time(), 'updatetime' => time(), ]); } $result = false; Db::startTrans(); try { //halt($row); if(!empty($row)){ $result = $this->model->insertGetId($row); } if(!empty($data)){ Db::name('kuerp_warehouse_info')->insertAll($data); } Db::commit(); } catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } if (isset($result) && $result !== false) { $examine= Db::name('kuerp_sets')->where(['name'=>'examine'])->value('is_checked'); if($examine!=1){ try { $exa = $this->examine($result,1); } catch (Exception $e) { } if(!isset($exa) || $exa['status']!=1){ $exa = $this->examine($result,1); try { $this->del($result); } catch (Exception $e) { } $this->error($exa['msg']); } } $this->success(); } else { $this->error(__('No rows were inserted')); } } $this->error(__('Parameter %s can not be empty', '')); } $code = (new Goods())->getCodes('',18); $this->view->assign("code", $code); switch ($type){ case 1: //盘点盘亏 if(!empty($purchase_code)){ $row = Db::name('kuerp_inventory')->where((new Goods())->setWhere(['purchase_code'=>$purchase_code]))->find(); $info = Db::name('kuerp_inventory_info')->where((new Goods())->setWhere(['purchase_code'=>$purchase_code,'profit'=>['<',0]]))->select(); foreach ($info as $info_k=>$info_v){ $goods = Db::name('kuerp_goods')->where((new Goods())->setWhere(['id'=>$info_v['goods_id']]))->find(); $info[$info_k]['goods'] = $goods; $goodsInfo = json_decode((new GoodsPurchase())->getUnit($goods['goods_code'],$info_v['stores_id'],$info_v['goods_attr']),true); $info[$info_k]['unit_price'] = 0; $info[$info_k]['price'] = 0; $info[$info_k]['unit'] = $goodsInfo; if($info[$info_k]['profit']<0){ $info[$info_k]['profit'] = -$info[$info_k]['profit']; } } $row['order_type'] = 1; $this->view->assign("business_type", 1); $this->view->assign("row", $row); $this->view->assign("purchase_info", $info); } break; case 2: //序列号盘亏 if(!empty($purchase_code)){ $row = Db::name('kuerp_inventory_serial')->where((new Goods())->setWhere(['purchase_code'=>$purchase_code]))->find(); $info = Db::name('kuerp_inventory_serial_info')->where((new Goods())->setWhere(['purchase_code'=>$purchase_code,'loss'=>['>',0]]))->select(); foreach ($info as $info_k=>$info_v){ $goods = Db::name('kuerp_goods')->where((new Goods())->setWhere(['id'=>$info_v['goods_id']]))->find(); $info[$info_k]['goods'] = $goods; $goodsInfo = json_decode((new GoodsPurchase())->getUnit($goods['goods_code'],$info_v['stores_id'],$info_v['goods_attr']),true); $goods_code = isset($goods['goods_code'])?$goods['goods_code']:''; $stores_id = isset($info_v['stores_id'])?$info_v['stores_id']:''; $attribute_id = isset($info_v['goods_attr'])?$info_v['goods_attr']:''; $where = []; $where['store_status'] = '1'; $where['goods_code'] = $goods_code; $where['stores_id'] = $stores_id; if($attribute_id){ $where['attribute_id'] = $attribute_id; } $serial = Db::name('kuerp_goods_serial')->where($where)->column('serial'); $serial_arr = [];$inventory = 0; if(isset($info_v['period_period'])){ $serial_pds = unserialize($info_v['period_period']); foreach ($serial as $serial_k=>$serial_v){ $status = false; foreach ($serial_pds as $serial_pds_k=>$serial_pds_v){ if($serial_pds_v['serial']==$serial_v){ $status = true; } } if(!$status){ $inventory += 1; $serial_arr[] = ['serial'=>$serial_v,'remark'=>'']; } } } $info[$info_k]['profit'] = $inventory; $info[$info_k]['unit_price'] = 0; $info[$info_k]['price'] = 0; $info[$info_k]['unit'] = $goodsInfo; if($info[$info_k]['profit']<0){ $info[$info_k]['profit'] = -$info[$info_k]['profit']; } $info[$info_k]['period'] = serialize($serial_arr); } $row['order_type'] = 2; $this->view->assign("business_type", 1); $this->view->assign("row", $row); $this->view->assign("purchase_info", $info); } break; default: $this->view->assign("row", []); $this->view->assign("purchase_info", []); break; } return $this->view->fetch(); } public function edit($ids = null) { $row = $this->model->where((new Goods())->setWhere(['id'=>$ids]))->find(); if (!$row) { $this->error(__('No Results were found')); } $adminIds = $this->getDataLimitAdminIds(); if (is_array($adminIds)) { if (!in_array($row[$this->dataLimitField], $adminIds)) { $this->error(__('You have no permission')); } } if ($this->request->isPost()) { (new \app\admin\controller\kuerp\Checkout())->checkOutTime($row['purchase_time']); $examine= Db::name('kuerp_sets')->where((new Goods())->setWhere(['name'=>'examine']))->value('is_checked'); if($row['examine_status']==1 && $examine==1){ $this->error('不能编辑已审核的数据'); } $params = $this->request->post("row/a"); if ($params) { $params = $this->preExcludeFields($params); $code = $params['purchase_code']; if($this->model->where((new Goods())->setWhere(['purchase_code'=>trim($params['purchase_code']),'id'=>['<>',$ids]]))->find()){ $this->error('单据编号已占用'); } $purchase_time = strtotime($params['purchase_time']); $business_type = $params['business_type']; $old_purchase_code = $params['old_purchase_code'];unset($params['old_purchase_code']); if(empty($code)){ $this->error('请输入单据编号'); }else if(empty($purchase_time)){ $this->error('请输入单据时间'); }else if(empty($business_type)){ $this->error('请选择业务类型'); } $supplyer = Db::name('kuerp_customers')->where((new Goods())->setWhere(['id'=>$params['customers_id']]))->find(); $admin = Session::get('admin'); $serial= Db::name('kuerp_sets')->where((new Goods())->setWhere(['name'=>'serial']))->value('is_checked'); $batch= Db::name('kuerp_sets')->where((new Goods())->setWhere(['name'=>'batch']))->value('is_checked'); $auxiliary_status= Db::name('kuerp_sets')->where(['name'=>'auxiliary'])->value('is_checked'); $data = []; $all_number = 0;//总数量 $all_price = 0;//总金额 foreach ($params['goods_code'] as $k=>$v){ if(!empty($v)){//有产品编号 if(!isset($params['stores_id'][$k]) || empty($params['stores_id'][$k])){ $this->error('请选择仓库'); } if(!isset($params['number'][$k]) || empty($params['number'][$k])){ $this->error('请输入出库数量'); } $all_number += $params['number'][$k]; $all_price += $params['all_money'][$k]; $goods = Db::name('kuerp_goods')->where((new Goods())->setWhere(['goods_code'=>$v]))->find(); $goods_unit = $params['goods_unit'][$k]===''?null:(float)$params['goods_unit'][$k]; if(empty($goods_unit)){ $this->error('请选择单位'); } if ($goods['auxiliary']==1 && empty($params['goods_attr'][$k]) && $auxiliary_status==1){ return ['status'=>500,'msg'=>'请选择商品'.$v.'属性']; } $advance_rate = 1;//换算进率 if($goods['more_unit']==1) { if($goods_unit!=$goods['unit_id']){ //所选单位不等于商品默认单位,需查询进率换算基础数量 $more_unit = Db::name('kuerp_unit_conversion') ->where((new Goods())->setWhere(['main_unit'=>$goods['unit_id'],'vice_unit'=>$goods_unit])) ->field('id,advance_rate') ->find(); if(empty($more_unit)){ $this->error('商品单位信息查询失败'); }else{ $advance_rate = $more_unit['advance_rate']; } } } if($goods['batch']==1 && $batch==1) { if (empty($params['batch'][$k])) { $this->error('请选择生产批次'); } if (empty($params['manufacture'][$k])) { $this->error('请输入生产日期'); } if($params['guarantee'][$k]===''){ $this->error('请输入保质期'); } if ($params['guarantee'][$k]<0){ $this->error('保质期天数不可小于0'); } if (empty($params['validity'][$k])) { $this->error('请输入过期时间'); } $where = []; $where['goods_code'] = $goods['goods_code']; $where['stores_id'] = (float)$params['stores_id'][$k]; if(!empty($params['goods_attr'][$k])){ $where['attribute_id'] = (float)$params['goods_attr'][$k]; } $where['batch_id'] = (float)$params['batch_id'][$k]; $where = (new Goods())->setWhere($where); $basic_nmber = round(($advance_rate*$params['number'][$k]),4); $batch_stock = Db::name('kuerp_goods_batch_stock')->where($where)->find(); if(empty($batch_stock)){ $this->error('批次信息查询错误'); }elseif ($batch_stock['stock']<$basic_nmber){ $this->error('此批次库存不足'); } } if(isset($params['period_period'][$k]) && $goods['serial']==1 && $serial==1){ if(empty($params['period_period'][$k])){ $this->error('请输入商品序列号'); } $basic_nmber = (float)$params['number'][$k]; $per_code = []; $period = unserialize($params['period_period'][$k]); foreach ($period as $period_k=>$period_v){ if(!in_array($period_v['serial'],$per_code)){ $per_code[] = $period_v['serial']; } } $per_s = Db::name('kuerp_goods_serial')->where((new Goods())->setWhere(['serial'=>['in',$per_code],'store_status'=>'1']))->column('serial'); if(sizeof($per_code)!=sizeof($per_s)){ $str = []; foreach ($per_code as $per_code_k=>$per_code_v){ if(!in_array($per_code_v,$per_s)){ $str[] = $per_code_v; } } $this->error('序列号'.implode(',',$str).'不在库,不可出库'); } }else{ $basic_nmber = round(($advance_rate*$params['number'][$k]),4); } $data[] = (new Goods())->setDataInfo([ 'purchase_code' => $code, 'purchase_time' => $purchase_time, 'goods_id' => $goods['id'], 'goods_attr' => $params['goods_attr'][$k]===''?null:(float)$params['goods_attr'][$k], 'goods_unit' => $goods_unit, 'stores_id' => $params['stores_id'][$k]===''?null:(float)$params['stores_id'][$k], 'stock' => $params['allow_stock'][$k]===''?null:(float)$params['allow_stock'][$k], 'number' => $params['number'][$k]===''?null:(float)$params['number'][$k], 'basic_nmber' => $basic_nmber, 'period' => $params['period_period'][$k]===''?null:$params['period_period'][$k], 'unit_price' => $params['unit_price'][$k]===''?null:(float)$params['unit_price'][$k], 'price' => $params['all_money'][$k]===''?null:(float)$params['all_money'][$k], 'remark' => $params['remark'][$k]===''?null:$params['remark'][$k], 'batch' => $params['batch'][$k]===''?null:$params['batch'][$k], 'batch_id' => $params['batch_id'][$k]===''?null:(float)$params['batch_id'][$k], 'manufacture' => $params['manufacture'][$k]===''?null:strtotime($params['manufacture'][$k]), 'guarantee' => $params['guarantee'][$k]===''?null:(float)$params['guarantee'][$k], 'validity' => $params['validity'][$k]===''?null:strtotime($params['validity'][$k]), 'createtime' => time(), 'updatetime' => time(), ]); } } if(!empty($data)){ $rowdata = (new Goods())->setDataInfo([ 'purchase_code' => $code, 'purchase_time' => $purchase_time, 'business_type' => $business_type, 'number' => $all_number, 'price' => $all_price, 'customers_id' => isset($supplyer['id'])?$supplyer['id']:null, 'preparation_id' => $admin['id'], 'remarks' => $params['note'], 'updatetime' => time(), ]); } $result = false; Db::startTrans(); try { if($examine!=1 && $row['examine_status']==1){ $this->examine($ids,2); } Db::name('kuerp_warehouse_info')->where((new Goods())->setWhere(['purchase_code'=>$old_purchase_code]))->delete(); if(!empty($row)){ $result = $this->model->where((new Goods())->setWhere(['id'=>$ids]))->update($rowdata); } if(!empty($data)){ Db::name('kuerp_warehouse_info')->insertAll($data); } Db::commit(); } catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } if (isset($result) && $result !== false) { if($examine!=1){ try { $exa = $this->examine($ids,1); } catch (Exception $e) { } if(!isset($exa) || $exa['status']!=1){ $this->error(__('No rows were inserted')); } } $this->success(); } else { $this->error(__('No rows were inserted')); } } $this->error(__('Parameter %s can not be empty', '')); } $this->view->assign("row", $row); $info = Db::name('kuerp_warehouse_info')->where((new Goods())->setWhere(['purchase_code'=>$row['purchase_code']]))->select(); foreach ($info as $info_k=>$info_v){ $goods = Db::name('kuerp_goods')->where((new Goods())->setWhere(['id'=>$info_v['goods_id']]))->find(); $info[$info_k]['unit'] = json_decode((new GoodsPurchase())->getUnit($goods['goods_code']),true); } $this->view->assign("purchase_info", $info); $kuerp_customers = Db::name('kuerp_customers')->where(['id'=>$row['customers_id']])->field('id,customer_name')->find(); $this->assignconfig("kuerp_customers", $kuerp_customers); //审核禁止输入 $examine_set= Db::name('kuerp_sets')->where(['name'=>'examine'])->value('is_checked'); if($examine_set==1 && $row['examine_status']==1){ $this->assign('exclass','hiddens'); } $this->assignconfig("examine_status", $row['examine_status']); return $this->view->fetch(); } /** * 删除 */ public function del($ids = "") { if (!$this->request->isPost()) { $this->error(__("Invalid parameters")); } $ids = $ids ? $ids : $this->request->post("ids"); if ($ids) { $pk = $this->model->getPk(); $adminIds = $this->getDataLimitAdminIds(); if (is_array($adminIds)) { $this->model->where($this->dataLimitField, 'in', $adminIds); } $list = $this->model->where($pk, 'in', $ids)->where((new Goods())->setWhere())->select(); $examine= Db::name('kuerp_sets')->where((new Goods())->setWhere(['name'=>'examine']))->value('is_checked'); foreach ($list as $list_k=>$list_v){ if($list_v['examine_status']==1){ (new \app\admin\controller\kuerp\Checkout())->checkOutTime($list_v['purchase_time']); } if($list_v['examine_status']==1 && $examine==1){ $this->error('不能删除已审核的数据'); }elseif ($list_v['examine_status']==1 && $examine!=1){ try { $this->examine($list_v['id'],2); } catch (Exception $e) { } } } $count = 0; Db::startTrans(); try { foreach ($list as $k => $v) { $count += $v->delete(); Db::name('kuerp_warehouse_info')->where(['purchase_code'=>$v['purchase_code']])->delete(); } Db::commit(); }catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } if ($count) { $this->success(); } else { $this->error(__('No rows were deleted')); } } $this->error(__('Parameter %s can not be empty', 'ids')); } //审核/反审核 public function examine($ids = null,$examine=1){ $examine_set= Db::name('kuerp_sets')->where((new Goods())->setWhere(['name'=>'examine']))->value('is_checked'); if(empty($ids)){ if($examine_set!=1){ return ['status'=>0,'msg'=>'系统错误']; } $this->error('请选择要操作的数据'); } $serial= Db::name('kuerp_sets')->where((new Goods())->setWhere(['name'=>'serial']))->value('is_checked'); $batch= Db::name('kuerp_sets')->where((new Goods())->setWhere(['name'=>'batch']))->value('is_checked'); if($examine==1){ $list = $this->model->where((new Goods())->setWhere(['id'=>['in',$ids],'examine_status'=>'0']))->select(); foreach ($list as $list_k=>$list_v){ (new \app\admin\controller\kuerp\Checkout())->checkOutTime($list_v['purchase_time']); } $editstock = []; $goods_stock = []; $purchase_info = []; $goods_stock_log = [];//收发详情 $serial_log = [];//序列号跟踪 $goods_batch_edit = []; $goods_batch_log = []; $edit_serial = []; foreach ($list as $list_k=>$list_v){ $info_list = Db::name('kuerp_warehouse_info')->where((new Goods())->setWhere(['purchase_code'=>$list_v['purchase_code']]))->select(); foreach ($info_list as $info_list_k=>$info_list_v){ $stock_number = $info_list_v['basic_nmber']; $goods = Db::name('kuerp_goods')->where(['id'=>$info_list_v['goods_id']])->field('id,goods_code,attribute_id,inventory,batch,serial')->find(); $status = false; foreach ($goods_stock as $goods_stock_k=>$goods_stock_v){ if($goods_stock_v['id']==$goods['id']){ $goods_stock[$goods_stock_k]['inventory'] = $goods_stock_v['inventory']-$stock_number; $status = true; } } if(!$status){ $goods_stock[] = [ 'id'=>$goods['id'], 'inventory'=>$goods['inventory']-$stock_number, ]; } //商品库存 $where = []; $where['goods_code'] = $goods['goods_code']; $where['stores_id'] = $info_list_v['stores_id']; $goods_attr = 0; if($info_list_v['goods_attr']>0){ $goods_attr = $info_list_v['goods_attr']; if($goods_attr>0){ $where['attribute_id'] = $goods_attr; } } $stock = Db::name('kuerp_goods_stock')->where($where)->field('stock,id,cost_money')->find(); if($stock){ $status = false; foreach ($editstock as $editstock_k=>$editstock_v){ if($editstock_v['id']==$stock['id']){ $editstock[$editstock_k]['stock'] -= $stock_number; $editstock[$editstock_k]['cost_money'] = (round($editstock_v['cost_money']-$info_list_v['price'],4)); $status = true; } } if(!$status){ $editstock[] = [ 'id'=>$stock['id'], 'stock'=>(round($stock['stock']-$stock_number,4)), 'cost_money'=>(round($stock['cost_money']-$info_list_v['price'],4)) ]; } foreach ($editstock as $editstock_k=>$editstock_v){ if($editstock_v['stock']<0){ $store = Db::name('kuerp_stores')->where(['id'=>$info_list_v['stores_id']])->value('name'); if($examine_set!=1){ return ['status'=>0,'msg'=>$goods['goods_name'].'库存不足,操作失败']; } $this->error($store.'库存不足,操作失败'); } } }else{ if($examine_set!=1){ return ['status'=>0,'msg'=>'库存不足']; } $this->error('库存不足'); } $purchase_info[] = $info_list_v['id']; $supplyer = Db::name('kuerp_customers')->where((new Goods())->setWhere(['id'=>$list_v['customers_id']]))->value('id'); //收发详情 if($goods){ $goods_stock_log[] = (new Goods())->setDataInfo([ 'purchase_code' => $info_list_v['purchase_code'], 'purchase_id' => $info_list_v['id'], 'purchase_time' => $info_list_v['purchase_time'], 'business_type' => $list_v['business_type']==1?10:11, 'customer_id' => (float)$supplyer, 'goods_id' => $goods['id'], 'goods_code' => $goods['goods_code'], 'attribute_id' => (float)$info_list_v['goods_attr'], 'goods_unit' => (float)$info_list_v['goods_unit'], 'stores_id' => (float)$info_list_v['stores_id'], 'remark' => $info_list_v['remark'], 'out_number' => (float)$info_list_v['number'], 'out_basics' => (float)$info_list_v['basic_nmber'], 'out_unit' => round($info_list_v['unit_price'],4), 'out_cost' => (float)$info_list_v['price'], 'createtime' => time(), 'updatetime' => time(), ]); } //收发详情结束 //批次跟踪 if($batch==1 && $goods['batch']==1){ $where = []; $where['goods_id'] = $goods['id']; if($goods_attr>0){ $where['attribute_id'] = $goods_attr; } $where['stores_id'] = $info_list_v['stores_id']; $where['batch_id'] = $info_list_v['batch_id']; $where = (new Goods())->setWhere($where); $goods_batch_stock = Db::name('kuerp_goods_batch_stock')->where($where)->find(); if(empty($goods_batch_stock)){ if($examine_set!=1){ return ['status'=>0,'msg'=>'批次信息查询失败']; } $this->error('批次信息查询失败'); }else{ if(isset($goods_batch_edit[$goods_batch_stock['id']])){ $goods_batch_edit[$goods_batch_stock['id']] -= $stock_number; }else{ $goods_batch_edit[$goods_batch_stock['id']] = $goods_batch_stock['stock']-$stock_number; } } //商品批次跟踪 $goods_batch_log[] = (new Goods())->setDataInfo([ 'goods_id' => $goods['id'], 'goods_unit' => $info_list_v['goods_unit'], 'stores_id' => $info_list_v['stores_id'], 'batch_id' => (float)$info_list_v['batch_id'], 'number' => (float)$info_list_v['basic_nmber'], 'purchase_code' => $info_list_v['purchase_code'], 'purchase_time' => $info_list_v['purchase_time'], 'business_type' => $list_v['business_type']==1?9:10, 'remarks' => $info_list_v['remark'], 'order_id' => $info_list_v['id'], 'unit_price' => $info_list_v['unit_price'], 'tax_included' => $info_list_v['unit_price'], 'all_money' => $info_list_v['price'], 'tax_money' => 0, 'money_tax_price' => $info_list_v['price'], 'customer_id' => $supplyer, 'createtime' => time(), 'updatetime' => time(), ]); //商品批次跟踪结束 } //序列号跟踪 if($goods && $goods['serial']==1 && $serial==1 && !empty($info_list_v['period'])){ $period = unserialize($info_list_v['period']); foreach ($period as $period_k=>$period_v){ $per_s = Db::name('kuerp_goods_serial')->where((new Goods())->setWhere(['serial'=>$period_v['serial']]))->field('serial,status,store_status')->find();//序列号 if($per_s){//仓库有记录 if($per_s['store_status']!=1){ if($examine_set!=1){ return ['status'=>0,'msg'=>'序列号不在库,不可出库']; } $this->error('序列号不在库,不可出库'); } $type = Db::name('kuerp_warehouse')->where((new Goods())->setWhere(['purchase_code'=>$list_v['purchase_code']]))->value('business_type'); $edit_serial[] = ['serial'=>$per_s['serial'],'warehousing_id'=>$info_list_v['id'],'type'=>($type==1?9:10),'old_status'=>$per_s['status'],'old_store'=>$per_s['store_status']]; }else{ if($examine_set!=1){ return ['status'=>0,'msg'=>'序列号查询失败']; } $this->error('序列号查询失败'); } $serial_log[] = (new Goods())->setDataInfo([ 'goods_id'=>$info_list_v['goods_id'], 'stores_id'=>$info_list_v['stores_id'], 'attribute_id'=>isset($goods_attr)?$goods_attr:0, 'serial'=>$period_v['serial'], 'business_type'=>$list_v['business_type']==1?9:10, 'store_status'=>'1', 'remarks' => $period_v['remark'], 'purchase_id'=>$info_list_v['id'], 'customer_id'=>$supplyer, 'purchase_code'=>$info_list_v['purchase_code'], 'purchase_time' => $info_list_v['purchase_time'], 'order_id' => $info_list_v['id'], 'createtime' => time(), 'updatetime' => time(), ]); } } //序列号跟踪 } } foreach ($goods_stock as $k=>$v){ if($v['inventory']<0){ $this->error('库存不足,不可出库'); } } foreach ($goods_batch_edit as $k=>$v){ if($v<0){ $this->error('库存不足,不可出库'); } } //批次库存数据结束 $admin = Session::get('admin'); Db::startTrans(); try { $result = $this->model->where((new Goods())->setWhere(['id'=>['in',$ids],'examine_status'=>'0']))->update(['examine_status'=>1,'examine_id'=>$admin['id'],'examine_time'=>time(),'operation_id'=>$admin['id']]); if(!empty($editstock)){ (new \app\admin\model\kuerp\GoodsStock())->saveAll($editstock); } if(!empty($goods_stock)){ (new \app\admin\model\kuerp\Goods())->saveAll($goods_stock); } //商品收发明细 if(!empty($goods_stock_log)){ Db::name('kuerp_goods_log')->insertAll($goods_stock_log); } //批次库存数据 //批次 if(!empty($goods_batch_log)){ Db::name('kuerp_goods_batch_log')->insertAll($goods_batch_log); } if(!empty($goods_batch_edit)){ foreach ($goods_batch_edit as $k=>$v){ Db::name('kuerp_goods_batch_stock')->where((new Goods())->setWhere(['id'=>$k]))->update(['stock'=>$v]); } } //批次库存数据结束 if(!empty($edit_serial)){ foreach ($edit_serial as $edit_serial_k=>$edit_serial_v){ Db::name('kuerp_goods_serial')->where((new Goods())->setWhere(['serial'=>$edit_serial_v['serial']]))->update([ 'warehoue_id'=>$edit_serial_v['warehousing_id'], 'status'=>$edit_serial_v['type'], 'store_status'=>'2', 'old_status'=>$edit_serial_v['old_status'], 'old_store'=>$edit_serial_v['old_store'] ]); } } //序列号跟踪 if(!empty($serial_log)){ Db::name('kuerp_goods_serial_log')->insertAll($serial_log); } Db::commit(); } catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } if(isset($result) && $result !== false){ if($examine_set!=1){ return ['status'=>1,'msg'=>'操作成功']; } $this->success(sizeof($list).'条数据审核成功'); }else{ if($examine_set!=1){ return ['status'=>0,'msg'=>'操作失败']; } $this->error('审核失败'); } }else{ $list = $this->model->where((new Goods())->setWhere(['id'=>['in',$ids],'examine_status'=>'1']))->select(); foreach ($list as $list_k=>$list_v){ (new \app\admin\controller\kuerp\Checkout())->checkOutTime($list_v['purchase_time']); } if(empty($list)){ if($examine_set!=1){ return ['status'=>0,'msg'=>'操作失败']; } $this->error('请选择需要反审核的数据'); } $edit_arr = []; foreach ($list as $list_k=>$list_v){ $info_id = Db::name('kuerp_warehouse_info')->where((new Goods())->setWhere(['purchase_code'=>$list_v['purchase_code']]))->column('id'); $edit_arr[] = ['business_type'=>$list_v['business_type'],'ids'=>$info_id]; } $list = $this->model->where(['id'=>['in',$ids],'examine_status'=>'1'])->column('purchase_code'); $editstock = [];$goods_stock = []; $info_list = Db::name('kuerp_warehouse_info')->where((new Goods())->setWhere(['purchase_code'=>['in',$list]]))->select(); $purchase_info = [];$goods_batch_edit = []; foreach ($info_list as $list_k=>$list_v){ $stock_number = $list_v['basic_nmber']; $goods = Db::name('kuerp_goods')->where(['id'=>$list_v['goods_id']])->field('id,attribute_id,inventory,goods_name,goods_code,batch')->find(); $status = false; foreach ($goods_stock as $goods_stock_k=>$goods_stock_v){ if($goods_stock_v['id']==$goods['id']){ $goods_stock[$goods_stock_k]['inventory'] = $goods_stock_v['inventory']+$stock_number; $status = true; } } if(!$status){ $goods_stock[] = [ 'id'=>$goods['id'], 'inventory'=>$goods['inventory']+$stock_number, ]; } $where = []; $where['goods_code'] = $goods['goods_code']; $where['stores_id'] = $list_v['stores_id']; $goods_attr = 0; if($list_v['goods_attr']>0){ $goods_attr = $list_v['goods_attr']; if($goods_attr>0){ $where['attribute_id'] = $goods_attr; } } $stock = Db::name('kuerp_goods_stock')->where($where)->field('stock,id,cost_money')->find(); if($stock){ $status = false; foreach ($editstock as $editstock_k=>$editstock_v){ if($editstock_v['id']==$stock['id']){ $editstock[$editstock_k]['stock'] += $stock_number; $editstock[$editstock_k]['cost_money'] = (round($editstock_v['cost_money']+$list_v['price'],4)); $status = true; } } if(!$status){ $editstock[] = [ 'id'=>$stock['id'], 'stock'=>(round($stock['stock']+$stock_number,2)), 'cost_money'=>(round($stock['cost_money']+$list_v['price'],4)) ]; } }else{ $store = Db::name('kuerp_stores')->where(['id'=>$list_v['stores_id']])->value('name'); if($examine!=1){ return ['status'=>0,'msg'=>$goods['goods_name'].'库存不足,操作失败']; } $this->error($store.'库存不足,反审核失败'); } $purchase_info[] = $list_v['id']; if($goods['batch']==1 && $batch==1){ //批次库存数据 $where = []; $where['goods_id'] = $list_v['goods_id']; if($goods_attr>0){ $where['attribute_id'] = $goods_attr; } $where['stores_id'] = $list_v['stores_id']; $where['batch_id'] = $list_v['batch_id']; $where = (new Goods())->setWhere($where); $goods_batch_stock = Db::name('kuerp_goods_batch_stock')->where($where)->find(); if(empty($goods_batch_stock)){ if($examine_set!=1){ return ['status'=>0,'msg'=>'库存不足']; } $this->error('库存不足'); }else{ if(isset($goods_batch_edit[$goods_batch_stock['id']])){ $goods_batch_edit[$goods_batch_stock['id']] += $stock_number; }else{ $goods_batch_edit[$goods_batch_stock['id']] = $goods_batch_stock['stock']+$stock_number; } } } } //批次库存数据结束 $admin = Session::get('admin'); Db::startTrans(); try { $result = $this->model->where((new Goods())->setWhere(['id'=>['in',$ids],'examine_status'=>'1']))->update(['examine_status'=>0,'examine_id'=>0,'examine_time'=>'','operation_id'=>$admin['id']]); //商品详细库存 if(!empty($editstock)){ (new \app\admin\model\kuerp\GoodsStock())->saveAll($editstock); } //商品总库存 if(!empty($goods_stock)){ (new \app\admin\model\kuerp\Goods())->saveAll($goods_stock); } if(!empty($goods_batch_edit)){ foreach ($goods_batch_edit as $k=>$v){ Db::name('kuerp_goods_batch_stock')->where((new Goods())->setWhere(['id'=>$k]))->update(['stock'=>$v]); } } foreach ($edit_arr as $edit_arr_k=>$edit_arr_v){ //批次 $type = $edit_arr_v['business_type']==1?3:4; Db::name('kuerp_goods_batch_info')->where((new Goods())->setWhere(['type'=>$type,'purchase_info_id'=>['in',$edit_arr_v['ids']]]))->delete(); $type = $edit_arr_v['business_type']==1?7:8; Db::name('kuerp_goods_batch_log')->where((new Goods())->setWhere(['business_type'=>$type,'order_id'=>['in',$edit_arr_v['ids']]]))->delete(); Db::name('kuerp_goods_serial_log')->where((new Goods())->setWhere(['business_type'=>$type,'order_id'=>['in',$edit_arr_v['ids']]]))->delete(); $type = $edit_arr_v['business_type']==1?10:11; Db::name('kuerp_goods_log')->where((new Goods())->setWhere(['business_type'=>$type,'purchase_id'=>['in',$edit_arr_v['ids']]]))->delete(); $serial = Db::name('kuerp_goods_serial')->where((new Goods())->setWhere(['warehoue_id'=>['in',$edit_arr_v['ids']]]))->select(); foreach ($serial as $serial_k=>$serial_v){ Db::name('kuerp_goods_serial')->where((new Goods())->setWhere(['id'=>$serial_v['id']]))->update(['status'=>$serial_v['old_status'],'store_status'=>$serial_v['old_store']]); } } Db::commit(); } catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } if(isset($result) && $result !== false){ if($examine_set!=1){ return ['status'=>1,'msg'=>'操作成功']; } $this->success(sizeof($list).'条数据反审核成功'); }else{ if($examine_set!=1){ return ['status'=>0,'msg'=>'操作失败']; } $this->error('反审核失败'); } } } /** * 获取可用序列号 * @param string goods_code 商品编号 * @param string stores_id 仓库ID * @param string attribute_id 属性id * @param string purchase_code 购货单单号 * @return array */ public function getSerial(){ $data = input(); $goods_code = isset($data['goods_code'])?$data['goods_code']:''; $stores_id = isset($data['stores_id'])?$data['stores_id']:''; $attribute_id = isset($data['attribute_id'])?$data['attribute_id']:''; $where = []; $where['store_status'] = '1'; $where['goods_code'] = $goods_code; $where['stores_id'] = $stores_id; $where['attribute_id'] = $attribute_id; $serial = Db::name('kuerp_goods_serial')->where($where)->field('serial,remark,status')->select(); return json_encode(['list'=>$serial]); } }